DPS and EHP Spreadsheet

  • #21
    Quote from Madwizz

    Ive recently found 2 rare weapons with some sweet mods, one is a 714 dps 1 hander ok when I put it on my dps decreases by like 800damage, and the other is a sweet little dagger with 648 DPS, although when I put it on it does about the same damage as the 714 dps one hander, and both do about 800damage less then my 966DPS vanilla mace. Granted both of them add like 150 intelligence and the dagger gives 51%+ critical damage, but its still funny to see they all are about the same level(damage wise). In the spreadsheet though the numbers are a little off since it shows those 2 new weapons as "worse" then they appear in my charscreen damage... both of those weapons have %ias, maybe its something to do with that.


    I'm not quite clear on what the issue is. Do you mean the spreadsheet isn't reporting the same difference in dps that you're seeing? If that is the case, how much is it off by and do either of the weapons have +dmg%? I know you mentioned they have +IAS, are you using my latest version that asks for the IAS of weapons? If not there could be an issue that the tooltip weapon attacks per second on the weapons are slightly off than the actual values used in game since it can only report 2 decimals.

    Feel free to pm me the weapon stats and your stats if you want and I'll see what's going on, if there's indeed a difference between the spreadsheet and in game number, by more than a decimal place.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • #22
    I wanted to mention an update I just made to my spreadsheet. I added an extra tab that better explains what numbers to put in each box to try and make it more user friendly. I also included the EHP table vs number of hits you can take that I put in another thread for quick reference. The weapon comparison box now should work a lot better also, so that if you're not comparing a weapon, you can totally ignore the weapon stats boxes above the Primary Stat box when comparing items, just remember to set the Weapon Comparison box to 0. Finally, I did a little rearranging of rows so that all 4 main weapon stats (speed, +AS, min dmg and max dmg) are all in succession as well as putting the (arguably) least useful +bonus damage % from skills to the bottom.

    I also want to again mention that there still seems to be a bug associated with +dmg% weapons in that the numbers don't match up exactly with in game values. If you find yourself with a +dmg% weapon and the dps calculated on the spreadsheet is close but not quite to the same as your in game number, try tweaking your min weapon damage value by 0.05 until it matches. That's what I've had to do for 2 different weapons now but once I do that, my item comparisons have been accurate to 2 decimal places. If your damage number is far off of the spreadsheet calculation, double check to make sure you input the correct values, especially if you aren't using a weapon with +damage%.

    If anyone is still confused about anything or has any suggestions, feel free to send me a pm. Mostly the only edits or additions I've done so far have been things I wanted to add for my own benefit, since that was the original reason I made it, but I wouldn't mind adding some useful things if anyone has any ideas they'd like to see.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • #23
    Just updated again and added 2 new relative dps gain numbers: Base Weapon Speed and Weapon DPS. They go well with the +attack speed on weapon stat I added the other day. The first should be 0 if using a 2h or any gear without +bonus dmg outside of your weapon. I'm hoping it will make searching for weapons a bit easier since it seems weapon dps, weapon base AS, weapon +AS, int, and +crit dmg all play a significant role in the dps gained or lost from using certain weapons. Note the resulting dps gains listed are for +0.1 Weapon Speed and +1 weapon dps.

    For reference, because I've seen a lot of people comparing weapons of different dps, one with int 1 without, using my current gear and weapon, 1 weapon dps = 1.551 Int, so if I want to upgrade a weapon that has 155 int, I would want to start by looking at weaepons with at least 100 dps more, assuming the weapon speed and such were the same. That's just a rough estimate though since the relationship is not linnear. I still recommend putting the weapon stats in the comparison area because that will accurately calculate the final damage numbers of your character, but using the relative stat values can give you an idea where to start looking.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • #24
    Nice work Loroese
  • #25
    No need to delete your post or anything. I have no qualms with anyone using anything relating to my spreadsheet. I posted it precisely so people could use it themselves or for people to addon to it if desired. Assuming the numbers are coming out correctly for you, it looks good.

    So far I've avoided making people insert every stat of every piece of gear because all that really matters are the total stats and I only find myself comparing 1 item at a time. Well that and I didn't want to insert all the stats myself. Now with that said, I saw a really cool idea on another spreadsheet where the author computes EHP and total dps of each piece, which you can also include a gold value and look at some complex DPS/gold or EHP/gold or DPS/EHP calculations. While I might get around to doing that one day, I don't really feel the need to do so at this time.

    I'm totally open to sharing any ideas or working together if you like, though at this time the only things I would like to add or change is some approximation for the +% to bleed for xxx-yyy, which I have not looked into, and whatever formula is used with +damage% on weapons, since every time I get a weapon with that stat I have to change one or both of the weapon damage stats by 0.25 to get the damage number to match. If ANYONE has any ideas about that, I'd love to hear them, or if you have any questions I'll try to answer when I can. Feel free to pm me since we probably don't need to bounce ideas back and forth in the thread.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • #26
    Thanks for this. I'd hacked together my own calculations, but this is much cleaner. :)
  • #27
    According to your responce you've read my pm or where faster on reading my post before I deleted it , and you are correct I know the whole inserting might be a drag for some ppl but as you can see the numbers are some what correctly except the armor/resistance thing if you've checked it out and I haven't been abel to completly test it cuz AH was down for some time but according to theory it should work fine. My idea of not having to insert every stat would be a database of the items that you could use and that's a big db that I don't have atm. also the other Idea i had was to make another box next to the stats so you could see easier how much you would benefit from 1item to the other but I haven't figured that 1 out since I only made it in about 5hours (without AH downtime used AH to check what item can have what stats)

    But since no 1 understands what we are talking about I might as well post the spreadsheet I have been working on:
    https://docs.google.com/open?id=0B30-w7-ReAXYbWltRlZTaDBmQUE
  • #28
    i have dowenloede it and tryede it out thou for som wirde reason it says i got 2k dps more on the sheet than what i got ingame... and eveyting is to my knowlage put in right eney ideas? he is a screen shot of my wizzard




    eneybody got an idea way?
    i apologice for spelling errors i am from denmark and unfortnaly suffer from dyslixa
  • #29
    Which 1 did you download the 1 I posted or Loreone? If you downloaded Loreone's then maybe try mine (I need ppl to test mine) if you did download mine download Loreone's double checking doesn't hurt. And just a tip I think a green gem in your 1H would give you more benefit than a red gem ;)
  • #30
    Quote from Jack_The_Jackal

    i have dowenloede it and tryede it out thou for som wirde reason it says i got 2k dps more on the sheet than what i got ingame... and eveyting is to my knowlage put in right eney ideas? he is a screen shot of my wizzard

    eneybody got an idea way?


    First off, did you set the "Bonus Damage from skills" box to 0 to match that shown on your char sheet? It's set to 15% by default since it seems most people, myself included, are using Glass Cannon passive. If that isn't the issue, then can you pm me or post your weapon stats, including weapon damage range, attacks/sec and any +attackspeed or +damage% if appropriate?

    And LievenL is probably right about the gem, but you can use the spreadsheet to check, once you get it working right of course. Just do a weapon compare, use the same weapon stats for both but for the "Item 1" box just put negative values for +min and max damage matching that of the gem, and put the appropriate value for what green gem you'd put in. If I'm seeing that right, I think the red gem is +13-26? so you'd put -13 for min+dmg, -26 for max+dmg, then something like 45 for crit dmg % if that's the best one you have, since it's the best you can find laying around on the ground.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • #31
    ther servers are going dowen now somting about emgerncity rolling restarts but i think the bonus damage from skills is the ticker as i dont use glass cannon and the 2k sounds about right for thous 15% sorry about missing that .. huge probs thou for the spredsheet i love it so muce... now i just whana decied if 2800 hitpoints vs 1500 damage whats the best to get :P
    i apologice for spelling errors i am from denmark and unfortnaly suffer from dyslixa
  • #32
    Quote from LievenL

    Which 1 did you download the 1 I posted or Loreone? If you downloaded Loreone's then maybe try mine (I need ppl to test mine) if you did download mine download Loreone's double checking doesn't hurt. And just a tip I think a green gem in your 1H would give you more benefit than a red gem ;)


    i got the one from the first post will look at yours as well ( when the servers are back op) and thanks for the tip whit the green gem will defently look at it as i am doing what i can to make suer doing butcher runs goes faster and faster ( wishe i hade a wizspike and the ocules offhand thou) :P
    i apologice for spelling errors i am from denmark and unfortnaly suffer from dyslixa
  • #33
    To check HP vs DPS, you can use the EHP calculator in the spreadsheet. As long as you keep above 126k EHP, i'd go with the extra DPS. Once I found out my EHP I cut a decent amount of resists and HP to gain a fair amount of dps and haven't noticed a lot of difference in survivability. If anything it's nicer having a smaller health pool because it's easier to regenerate it faster, and health pots become more useful. On a side note, I need to update my spreadsheet really fast because I used 174k instead of 170k for mob attacks, meaning the EHP threshholds are a little higher than needed.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • #34
    Quote from Loroese

    On a side note, I need to update my spreadsheet really fast because I used 174k instead of 170k for mob attacks, meaning the EHP threshholds are a little higher than needed.


    i dont think a little higer hurts personly i whod rather be safe than sorry ;) thou thanks agin for the advice defently got a lot of studing left to do to become a yber wuzzard

    quick added qustion i just trypede the EHP thing and it seams like i am under 100k i am at 94109 if i am reading it right ( lowest box on at the same page i am putting in the numbers right? wher it says EHP whit just EA) thou i know my resis is a bit higer because i use the prismatic rune
    i apologice for spelling errors i am from denmark and unfortnaly suffer from dyslixa
  • #35
    Is there anything like this to switch from items? For xample if I want to upgrade my amu/ring. I have a +270 int +13 ias +7% life ring and I want to upgrade it. I bought a amu with +48% crit +6% hit +14 ias and only gave me only 500 damage increase so I sold it again. I really thought it would give me a bigger increase so a progrem could helm me on that before I buy?.
  • #36
    Quote from Smoort

    Is there anything like this to switch from items? For xample if I want to upgrade my amu/ring. I have a +270 int +13 ias +7% life ring and I want to upgrade it. I bought a amu with +48% crit +6% hit +14 ias and only gave me only 500 damage increase so I sold it again. I really thought it would give me a bigger increase so a progrem could helm me on that before I buy?.

    if you look up the spreadsheet, youll see that you can change stats like intelligence, ias from off weapon equipment, critical chance and damage, so all you have to do is fill those in the spreadsheet and make the comparison.
  • #37
    Very awesome and useful tool - thanks a bunch!
  • #38
    Hmmm okey I'll try it out later!
  • #39
    Minor update: I added values for +EHP per vit, armor, resist, and % life, simliar to the relative dps gains, in case you want to know how each stat affects your EHP. Keep in mind the values are unlikely to be linnear so while 1 armor might give you 27 EHP, 100 armor won't necessarily give you 2700 EHP, especially once you start changing around stats, like armor for resist, vit for % life, etc. I still recommend using the item comparison for more detailed information but it might give good information on where to start when looking for gear on the AH.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • #40
    I just made a fairly significant update in the form of adding a new link with a more detailed spreadsheet. The new spreadsheet has all the capabilities of the previous version, which should still be available. I have edited the original post to include the link but included it here for reference also.

    https://docs.google....cE9RR0tVRTBwUlk

    The addition is in the form of a new tab where you can insert all the details of your equipped items. In return, the spreadsheet computes what your dps would be without that particular item, or in essence computes the dps contribution by that item. It also sorts the different slots in order of which provides the most dps to make it easy to tell what items are slacking in that department. It also computes the EHP contribution in the same way and reports that value for each item with the reported dps value. It does not rank your items in terms of EHP, only DPS. Once you have that sheet filled out, you can then copy and paste the appropriate values into the Main tab to do item comparisons, and you can also copy and paste the equipped stats since the stat order is the same for both pages. For example, if I wanted to compare gloves, I could copy and paste the rows from Intellect to +attack speed from the Equipped Items tab, then paste them in the Main tab in the Equipped column.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • To post a comment, please or register a new account.
Posts Quoted:
Reply
Clear All Quotes