Results 1 to 33 of 33

Thread: DPS Calculator (not weapon comparison)

  1. #1
    BrueFromXev
    Guest

    Default DPS Calculator (not weapon comparison)

    ***UPDATE***

    I have recreated this for level 70. HUGE thanks to Yoda from TSW as his hate generation sheet finally gave me a list of 2H DBs at level 70 (as well as info on WA<5 and combat effects). I added a couple blocks for combat effects and worn ferocity.



    home.earthlink.net/~garge...mage70.xls



    I also tweaked the formula a bit. I had some bonuses compounding each other, but previous known EQ math almost never does that so I changed it.



    I'm leaving the original post in below.



    ----------------------------------------------------------------------------------



    I decided to make a DPS calculator, not a weapon comparison, but an actual DPS calculator. It seems to be pretty close and at the very least is the best weapon comparison tool widely available. Lots of people (including me) have tried to figure out all the computations involved and even worse, used modals to try to make these sheets before. The (Dmg*2+Bonus)/Delay calculation is a rediculously outdated estimate. The other formulas don't account for diminishing returns and "damage charts". That DPS program that is floating around seems closer, but completely messes up procs by applying them as if his calculations were right even though he admits that the number is not supposed to be your actual DPM.



    Instead of complex computations made up of every concieved formula that the game may or may not use, I took a much more brute force approach. I started looking up parses and took (MaxHit - Bonus)/WeaponDmg as my base number. I then used crit maxes to figure out the hit bonus for crits, basically I just used the end result instead of worrying about how it got there. This allowed me to very accurately apply well known variables like damage bonuses and procs. It also means that this only counts for level 65 people with 305 str and maxed weapon skills, but there is an adjustment for hit% (to account for atk vs AC) and crit% so it is somewhat scalable. I also included some boxes for common DPS AAs, although they were unfortunately heavily estimated due to lack of good info. If anybody has any feedback or wants to point out errors, corrections, or ommisions, please post here. I'd love to iron the bugs that I'm sure exist in this.



    To adjust for proc rate increases, just modify the proc damage (ie GSot4W 75DD plus 40% is the same as 100DD with no mod so I put in 100).





    home.earthlink.net/~garge...Damage.xls


    </p>Edited by: <A HREF=http://p201.ezboard.com/bmonklybusiness43508.showUserPublicProfile?gid=bru efromxev>BrueFromXev</A> at: 2/1/05 10:53 pm

  2. #2
    BrueFromXev
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    I found two major but somewhat offsetting errors in the math and fixed them. Beta 0.2 is uploaded


    </p>

  3. #3
    Daemankyl
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    weapon effiency is what again? <img src=http://www.ezboard.com/images/emoticons/frown.gif ALT=":("> my numbers seem overly high.




    </p>

  4. #4
    Ghitming
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    Pretty certain your Weapon Affinity numbers are on the high side.



    Set 2hb at 1/100 with 0 proc and WA0....got 20.5 dps



    Set 2hb at 1/100 with 150 proc and WA0...got 25.5 dps...



    So 5.0 dps from the proc at WA0



    Changed WA0 to WA5 and got 38.5 dps.



    From most accounts, WA5 should only give me about 50 percent more procs than WA0. The DPS number should have been in the neighborhood of 28 rather than 38.5.



    Otherwise really great tool. Looking forward to seeing it get fine tuned with the help of the community.






    <a>

    <img border=0 src=http://www.clawofnagafen.com/Characters/Ghitming/Ghitsig.gif
    usemap="#ghitmap">

    <map id="ghitmap" name="ghitmap">

    <area shape="rect"
    coords="72,0,350,27"
    alt="Profile"
    href=http://www.magelo.com/eq_view_profile.html?num=16393 target="web">

    <area shape="rect"
    coords="72,28,350,51"
    alt="Profile"
    href=http://www.magelo.com/eq_view_profile.html?num=298897 target="web">

    <area shape="rect"
    coords="72,52,350,75"
    alt="The Claw of Nagafen"
    href=http://www.clawofnagafen.com/ target="web">

    <area shape="rect"
    coords="0,0,71,75"
    alt="Email"
    href="mailto:ghitming@clawofnagafen.com">

    </map>

    </a></p>Edited by: <A HREF=http://p201.ezboard.com/bmonklybusiness43508.showUserPublicProfile?gid=ghi tming>Ghitming</A>* at: 8/3/04 7:11 pm

  5. #5
    BrueFromXev
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    Lots to update



    First to Ghitming:

    The WA column is a straight yes/no column meaning that you put in "1" for WA 5 and "0" for WA 0. If you have WA 2-4... well you could put in a fraction to try to estimate it, but I couldn't put it in the formula because I couldn't find good info on WA 2-4. You put in 5 for WA which would be the equivalent of WA 25. Ingenuity 3 is the same. EDIT: this is no longer true on the level 70 version



    To Daemankyl:

    Damage Efficiency represents the percentage of your average hit vs your max hit, not counting damage bonus. 100% would represent hitting for max every time. In math form it would be (AvgHit-Bonus)/(MaxHit-Bonus). Basically it accounts for different atk vs AC. In hard LDoN I get about 50-55% with +20 atk gear. In VT (very high AC) I get about 40%. Most uber guild monk parses I saw were around 60-65%. As for the DPS innacuracies, more below.







    The biggest question mark I had regarding my formulas was how often double attack, triple attack, PB, etc fire off. I decided to find out myself and attacked the Katta banker with a dual weild set for 9 hours (one 1HB and 1 H2H) followed by 11 hours with a 2HB. What I found was pretty interesting. With Ferocity 3, the chance to double attack, as shown by the offhand in the 1H parse, is 69%. EVERY one of my parse results had 31% single attack which means that triple attack and PB can only fire off if double attack does, although they are independant of each other. I'm assuming that Rapid Strikes is the same and fires independantly of the other two based on the description. Early results showed RS1 to give a 1% inrease in swings, but that is compared to 1.84 a round (with others maxed) so I am going with 2% per rank. PB gave 3% per rank. PB and most likely RS get a small boost from Ferocity. If anyone with RS5 could post reliable numbers regarding how often they single, double, triple, quad, and quint I would appreciate it. If anyone out there has PB3 but NOT ferocity, I would also love to see a good single, double, triple, quad breakdown from that.



    I also found that my efficiency against the banker was about the same as it is during an average grind, but my hit% was about 10% higher. Unfortunately this means that I need to seperate the two <img src=http://www.ezboard.com/images/emoticons/frown.gif ALT=":("> although keeping it set at 58% for the pre-elemental crew and 62% for the Uber guild crew will be about right 90% of the time. I suspect that hit% is purely a weapon skill vs defense skill calculation and atk/AC only come in to play for mitigation calculations. It has been shown in the past that atk buffs do absolutely nothing for hit%.



    Finally, this will almost always show higher dps than you average because it shows a perfect case scenario, but it should be pretty close. It assumes you are level 65, behind the mob, in range, and have 305 str which means you must have planar power (lower the efficiency a few points to compensate if not). If you spend time in front of the mob or get "can not see" messages it will decrease your DPS. Basically you should expect to beat this sheet a few times from luck, but genreally you will come up a bit short. That's not to say it's perfect and errors are always from you and not me. I'm sure I'll need to tweak it more. 0.3 will be uploaded later tonight after I look it over.


    </p>Edited by: <A HREF=http://p201.ezboard.com/bmonklybusiness43508.showUserPublicProfile?gid=bru efromxev>BrueFromXev</A> at: 2/1/05 10:56 pm

  6. #6
    BrueFromXev
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    0.3 uploaded







    Here is a breakdown of the current formulas:





    2HB:



    (((WeapDmg+WeapBonus)*6.04*Efficiency*(1+(0.726*Cr it%))+InnateBonus)*

    --{_____________________AverageHitCalculation_______ _______________}-



    ((1.63+Ferocity*0.02)*(1+RS*0.02+PB*0.03))*Hit%)/(WeapDelay/10)*(1+Haste)+

    -{________________HitsPerRound_____________}-{RoundFrequency}--{Haste}--



    (Proc/30*(1+WA5*0.5)*(1+0.035*Ing3))

    -{_________ProcDamage____________}





    *the non-variable numbers (such as 6.04) come from the brute force tactic mentioned in the first post





    Primary 1H:



    (((WeapDmg+WeapBonus)*6.04*Efficiency*(1+(0.726*Cr it%))+InnateBonus)*

    --{_____________________AverageHitCalculation_______ _______________}-



    ((1.63+Ferocity*0.02)*(1+RS*0.02))*Hit%)/(WeapDelay/10)*(1+Haste)+

    -{____________HitsPerRound_________}-{RoundFrequency}--{Haste}--



    (Proc/30*(1+WA5*0.5)*(1+0.035*Ing3))

    -{_________ProcDamage____________}





    Secondary 1H:

    ((((WeapDmg+WeapBonus)*6.04*Efficiency*(1+(0.726*C rit%))+(SinStri*INT(Delay/3.5)))*

    --{____________________________AverageHitCalculation _________________________}-



    (1.63*(0.792+(Ambi*0.1)))*Hit%)/(WeapDelay/10))*(1+Haste)+

    -{_______HitsPerRound_______}-{RoundFrequency}--{Haste}--



    (Proc/60*(1+WA5*0.5)*(1+0.035*Ing3))

    -{_________ProcDamage____________}


    </p>

  7. #7
    Torami
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    I appreciate the effort you have put into this... thanks.


    Torami Truefist

    Sister of the Celestial Fists

    House Archon

    Torvonnilous</p>

  8. #8
    Ghitming
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    Thanks, that makes a lot more sense.



    Still, looks like an SoT will outdamage a SSoC by a large amount under any given situation. Is that right?






    <a>

    <img border=0 src=http://www.clawofnagafen.com/Characters/Ghitming/Ghitsig.gif
    usemap="#ghitmap">

    <map id="ghitmap" name="ghitmap">

    <area shape="rect"
    coords="72,0,350,27"
    alt="Profile"
    href=http://www.magelo.com/eq_view_profile.html?num=16393 target="web">

    <area shape="rect"
    coords="72,28,350,51"
    alt="Profile"
    href=http://www.magelo.com/eq_view_profile.html?num=298897 target="web">

    <area shape="rect"
    coords="72,52,350,75"
    alt="The Claw of Nagafen"
    href=http://www.clawofnagafen.com/ target="web">

    <area shape="rect"
    coords="0,0,71,75"
    alt="Email"
    href="mailto:ghitming@clawofnagafen.com">

    </map>

    </a></p>

  9. #9
    BrueFromXev
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    I put in SSoC myself (44/20 proc 100) and SoT (54/30 proc 200) myself and got higher estimated dps from the SSoC unless the efficiency was down to about 25% which nobody with either of those weapons should ever see, or even anybody at all really. Have you downloaded 0.3 (the only one with a "Hit %" block)?


    </p>

  10. #10
    Lotwell
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    Just a tip to help for people entering data. Make it so the the blocks you want people to change are hi-lighted and then lock everything else so it cant be changed/touched.




    Lotwell and The Mullwin</p>

  11. #11
    Ghitming
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    SOT



    54/30 with 36 Damage Bonus on the default settings = 234.18 DPS



    SSOC



    44/20 with 14 Damage Bonus on the default settings = 213.97 DPS



    If I am wrong, please correct me.



    Thanks.






    <a>

    <img border=0 src=http://www.clawofnagafen.com/Characters/Ghitming/Ghitsig.gif
    usemap="#ghitmap">

    <map id="ghitmap" name="ghitmap">

    <area shape="rect"
    coords="72,0,350,27"
    alt="Profile"
    href=http://www.magelo.com/eq_view_profile.html?num=16393 target="web">

    <area shape="rect"
    coords="72,28,350,51"
    alt="Profile"
    href=http://www.magelo.com/eq_view_profile.html?num=298897 target="web">

    <area shape="rect"
    coords="72,52,350,75"
    alt="The Claw of Nagafen"
    href=http://www.clawofnagafen.com/ target="web">

    <area shape="rect"
    coords="0,0,71,75"
    alt="Email"
    href="mailto:ghitming@clawofnagafen.com">

    </map>

    </a></p>

  12. #12
    BrueFromXev
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    With the default settings (not even extra AAs or crit increase) I get:



    SoT - 154.43



    SSoC - 166.48



    Adding in the AAs and crit increases on widens the margin. The only way I can get the SoT to outdamage the SSoC is to reduce the hit% or efficiency to rediculously low numbers.



    EDIT:

    I figured it out, the innate damage bonus is uncluded automatically and should not be put in the "Bonus" box. The "Bonus" box is for things like Bane damge and +1 Magic damage.



    Heh, I originally just made it for myself so didn't have a user friendly interface in mind. Maybe I should rework the interface to something simpler and more intuitive for 0.4.


    </p>Edited by: <A HREF=http://p201.ezboard.com/bmonklybusiness43508.showUserPublicProfile?gid=bru efromxev>BrueFromXev</A> at: 8/5/04 5:35 pm

  13. #13
    Ghitming
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    Thanks for the clarification.



    Did I mention I love this thing? I do.


    <a>

    <img border=0 src=http://www.clawofnagafen.com/Characters/Ghitming/Ghitsig.gif
    usemap="#ghitmap">

    <map id="ghitmap" name="ghitmap">

    <area shape="rect"
    coords="72,0,350,27"
    alt="Profile"
    href=http://www.magelo.com/eq_view_profile.html?num=16393 target="web">

    <area shape="rect"
    coords="72,28,350,51"
    alt="Profile"
    href=http://www.magelo.com/eq_view_profile.html?num=298897 target="web">

    <area shape="rect"
    coords="72,52,350,75"
    alt="The Claw of Nagafen"
    href=http://www.clawofnagafen.com/ target="web">

    <area shape="rect"
    coords="0,0,71,75"
    alt="Email"
    href="mailto:ghitming@clawofnagafen.com">

    </map>

    </a></p>

  14. #14
    Roshambo Yaforit
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    Yar...I love this thing...working on figuring out how to use some of it, but by looking at multiple different weapon comparison things I think I understand...



    Thanks a bunch for making this <img src=http://www.ezboard.com/images/emoticons/smile.gif ALT=":)">


    Esedess The Monk Pet Petition



    Follower of the Path of Confusion (wait...where'd the path go...I thought it was here, is that it? No, but there's a sign...ah-hah! There we go......what am I supposed to be doing again?)


    My Stuff in an easy to read format (AHHHH THE LACK OF CONFUSION...IT BURNS!)





    <TABLE BORDER=0><TR><TD>
    I am Mr Do.


    I am sedentary by nature, enjoying passive entertainment, eating when the mood takes me, and playing with my food. I try to avoid conflict, but when I'm angered, I can be a devil - if you force me to fight, I will crush you. With apples. What Video Game Character Are You?
    </BR>I am also a Chaoic Good Elf Bard Mage D&D.</BR></TD></TR></TABLE></p>

  15. #15
    Radil09
    Guest

    Default Re: DPS Calculator (not weapon comparison)

    This is great, just learned that WLK outdamges my Primal. Nice work man hope you keep updating it <img src=http://www.ezboard.com/images/emoticons/smile.gif ALT=":)">


    <div style="text-align:center">Radil</div></p>

  16. #16
    dxkj21
    Guest

    Default Hrm ...

    This looks good, but does it account for the delay cap? IE a 16 delay item, with 100% haste?







    Thanks )


    </p>

  17. #17
    Ugle
    Guest

    Default Re: Hrm ...

    There is no delay cap. Most parsers only sample once per second, making people believe that there was a delay cap. Otherwise something like a Moss-Covered Twig would perform as well unhasted as it would hasted. DPS from bare epic fists wouldn't be any better then a Jade Mace (guess that would depend on where you put the "minimum" delay at). There was a parse a long time ago using a 10 delay Twig that proved this.


    Natassi Dogym

    Dawulfie Duklin

    </p>

  18. #18
    dxkj21
    Guest

    Default Re: Hrm ...

    Thanks!!! I was given this lie for a while and no one had ever straightened me out. I like this sheet, btw, good job!


    </p>

  19. #19
    BrueFromXev
    Guest

    Default Re: Hrm ...

    Bump... new version for level 70. (see first post)


    </p>

  20. #20
    Grendo
    Guest

    Default Re: Hrm ...

    Very nice...wonder what kind of additional work id have to add to make it work for Zerkers...



    Confirmed the 2h DMG Bonus to 70. We at GoBerserker have been using guess-tamites based on Lucy...obviously leaving a few holes.



    BIG thanks!



    -Grendo

    Axe Master of Zeb

    Iratus Lepus

    www.goberserker.com


    </p>

  21. #21
    BrueFromXev
    Guest

    Default Re: Hrm ...

    bump



    New version uploaded. Main changes were cosmetic and I changed all of the 2HB bonuses. I found that my previous list ultimately came from lucy which I didn't use before because I knew it was wrong. I found a list from somebody that actually checked them all in game and then verified it on the selection of 2HBs in my bank ranging from 30 delay to 50 delay.


    </p>

  22. #22
    ajack hykick
    Guest

    Default Re: error in calc for secondary weapon

    BrueFromXev,



    For non-zero rapid strikes, secondary weapon 1 and secondary weapon two give different results for the same weapon.



    Only secondary weapon 1 factors in rapid strikes. Secondary weapon 2 omited the "I5*0.02" term.



    -Ajack


    </p>Edited by: <A HREF=http://p201.ezboard.com/bmonklybusiness43508.showUserPublicProfile?gid=aja ckhykick>ajack hykick</A> at: 6/27/05 5:11 pm

  23. #23
    wolvurene
    Guest

    Default Re: error in calc for secondary weapon

    how can we add in multiple augments for weapons for procs ? ie my 1.5 has 2 lifetap augs, do I put in 250 for 2 x 125 ?


    Wolvurene

    Enlightened

    Terror Australis</p>

  24. #24
    BrueFromXev
    Guest

    Default Re: error in calc for secondary weapon

    Recent version had the secondary weapons messed up a bit :/



    I fixed it and uploaded it. (I took rapid strikes off the primary secondary though because I don't think it affect secondary)



    <blockquote>Quote:<hr> how can we add in multiple augments for weapons for procs ? ie my 1.5 has 2 lifetap augs, do I put in 250 for 2 x 125 ?<hr></blockquote>

    That is correct.


    </p>Edited by: <A HREF=http://p201.ezboard.com/bmonklybusiness43508.showUserPublicProfile?gid=bru efromxev>BrueFromXev</A> at: 7/10/05 12:31 pm

  25. #25
    Ex-Druid Monk-in-Training
    Join Date
    Sep 2005
    Posts
    63

    Default

    this superb tool is giving me a "page not found"

    could anyone be so kind as to mail it to me at

    ali_curran@hotmail.com

    many many thanks

  26. #26
    Ex-Druid Monk-in-Training
    Join Date
    Sep 2005
    Posts
    63

    Default

    many thanks to Kunis, i have it now

    cheers

  27. #27
    Ex-Druid Monk-in-Training
    Join Date
    Mar 2006
    Posts
    89

    Default

    Created a new version of this for level 75 and made some significant changes while I was at it. List of changes:

    -- Numbers updated for level 75 (i.e. only works for level 75 folks)
    -- Added missing variables (new AAs, minimum damage mod, hundred hands effect)
    -- Multiple procs separated out (ans spot for buff procs)
    -- "Damage Efficiency" replaced with Atk and AC numbers
    -- Delay rounding limitation accounted for (creates some very interesting results).
    -- All calculations completely rewritten. While the math has the same general layout, a lot of stuff was tweaked to account for more recent information.


    Unfortunately I lost the ability to modify the first post when the board moved, but here's the link: http://www.guildseofon.com/MonkDamage.xls . As always, feedback is appreciated.

  28. #28
    Ex-Druid Monk-in-Training
    Join Date
    Mar 2006
    Posts
    89

    Default

    For those of you without Excel, you can download the viewer for free here. You can't save changes so you'll get my defaults every time you open it though.

  29. #29
    Ex-Druid Monk-in-Training
    Join Date
    Mar 2006
    Posts
    89

    Default

    New version up ( http://www.guildseofon.com/MonkDamage.xls ). I changed the way damage efficiency is calculated to actually calculate the exact efficiency based on how I think the system works rather than a rough estimation. I also fixed delay rounding, for real this time.

  30. #30
    Ascendant Ashenhand
    Join Date
    Oct 2002
    Posts
    2,902

    Default

    Freaky, I was just searching my computer for this and didn't find it, and the same day (same hour even) there's a new version.

  31. #31
    Ex-Druid Monk-in-Training
    Join Date
    Mar 2006
    Posts
    89

    Default

    Updated for 80.

    I also removed the last of the "you need to parse your own info to put in here" blocks and it now goes completely off of stats you should know.

    Heroic strength is, at best, an educated guess since i don't have any heroic strength gear, but it shouldn't be too far off. Some of the crit rate and flurry stuff is pretty fuzzy too.

    LINK: http://www.guildseofon.com/MonkDamage.xls

  32. #32
    Ex-Druid Monk-in-Training
    Join Date
    Jul 2008
    Posts
    10

    Default

    Wow, that's a pretty impressive spreadsheet! Not entirely sure how to fill everything out, but still, very nice.
    Things I stole from mobs
    When Chuck Norris has sex with a man, it is not because he is gay, but because he has run out of women.
    Chuck Norris doesn't read books. He stares them down until he gets the information he wants.
    Chuck Norris only masturbates to pictures of Chuck Norris.
    Chuck Norris lost his virginity before his dad did.
    Since 1940, the year Chuck Norris was born, roundhouse kick related deaths have increased 13,000 percent.


  33. #33
    Ex-Druid Monk-in-Training
    Join Date
    Sep 2006
    Posts
    13

    Default

    So is anyone good enough with math to update this thing? It was awesome to have back when it first came out...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •