DPS and EHP Spreadsheet

  • #261
    Try agan, it should be updated now. Not sure why it hadn't updated before.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #262
    Yup, whatever you did, it worked :Thumbs Up:

    Thanks, awesome work.
  • #263
    I have a problem with the IAS shown in the spreadsheet... the ias shown differs a lot... with and without enchantress
    htt p://i. imgur.com/KgC76pN.jpg,

    i have a 1.65 chantodo
    no IAS on weap but 0,25 atks

    62% ias on gear


    edit: THANKS
  • #264
    Quote from HanGtimEr

    I have a problem with the IAS shown in the spreadsheet... the ias shown differs a lot... with and without enchantress
    htt p://i. imgur.com/KgC76pN.jpg,

    i have a 1.65 chantodo
    no IAS on weap but 0,25 atks

    62% ias on gear


    You need to put 0.25 attacks per second in the box in the weapon column.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #265
    Minor bug fix but I fixed the relative EHP contributions calculations.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #266
    Great sheet, let me know when you catch up to every other spreadsheet developer and add an armory import.
  • #267
    Quote from Xathian

    Great sheet, let me know when you catch up to every other spreadsheet developer and add an armory import.


    Not planning to do that. In part because I don't know how. If I did know it would probably take more work than I have the time or desire to implement.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #268
    Quote from Xathian

    Great sheet, let me know when you catch up to every other spreadsheet developer and add an armory import.


    :facepalm:

    Keep up the good work, Loroese.
  • #269
    Great sheet, thanks for sharing
  • #270
    Hi Loroese,

    Any plans to add elite damage calculation for the spreadsheet?

    We could have with equipped gear and with rings swapped to a SOJ/Unity/Wailing Host etc.

    I believe it would be very useful and the only thing that I find lacking in your wonderful spreadsheet.
  • #271
    I could, but there's a couple issues with that. First it would give a value that is different from the in game dps value. Second, there's some kind of diminishing returns with bonus to elite damage that makes it annoying at best to calculate with more than 1 piece, especially if there's any number of slots for the bonus damage (weapon, rings, chest, helm, maybe others).

    The actual bonus is something like 100*(1-(1-Bonus1)*(1-Bonus2)*(1-Bonus3)...). With one piece, like a SoJ, that just gives 100(1-(1-.30)) = 30% bonus damage. If you add another 4%, say from a SC, the actual bonus is 32.8%, so you only gain 2.8% from the SC. Compared to using just the SoJ that ends up being just a 2.15% increase in dps against elites (1.328/1.30). Thus stacking bonus vs elites isn't very useful beyond a SoJ.

    Otherwise, if you want to know your effective dps against elites with a SoJ, you can manually multiply the dps by 1.xx where xx is the % bonus, which is 30% for a perfect SoJ.

    I suppose I could just put a couple boxes in where you can add bonus vs elites. 5 boxes should suffice, and then have a readout of the effective dps vs elites.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #272
    Well I learnt something new today. Didn't realize there was diminishing returns. Are the diminishing returns based on the number of pieces that have elite dmg or based on going beyond a cap (30%). For example if I have a storm crow with 6 and unity with 4 will my effective dmg against elites be less than 10?
  • #273
    But don't you have the same diminishing returns for elemental damage as well, e.g., when using a Triumvirate and a Tal Rasha's amulet? Couldn't you just use that part of the formula?

    I agree with your other argument though, it's kind of nice that the spreadsheet aligns so nicely with the char sheet DPS, and real DPS is a completely different topic anyways (and let's not even talk about other things such as "+x% damage to demons" and so on).

    Damn, sometimes I wish back the good old WoW times where you could log everything and mod the hell out of your game.
  • #274
    The elite bonus damage dim returns applies as soon as you add a second piece. The zuni boots+triumvirate affixes do not have the same diminishing returns. They do have their own relative dimishing returns, since triumvirate with 6/6/6 will add 18% dps, but adding boots to that only adds 1.26/1.18 = 1.068x, or about 6.8% to your dps. It still adds the right amount of damage though, so if you have 100k dps before triumvirate bonus, then you have 118k with triumvirate and 126k with tri plus boots. In short, each 1% from those adds the same dps as each other. For elite bonus damage that is not the case.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #275
    At the suggestion above I added a couple new features that are completely optional to use and have no impact on the rest of the spreadsheet

    Added Bonus vs Elites boxes to show effective char sheet dps against elites.
    Added Damage Reduction vs elites boxes to show effective EHP against elites
    Added a box showing how much damage you take vs Reflect Damage. Negative means you gain life against RD. Sign of the box depends only on LS and total damage reduction
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #276
    Awesome! Thanks a ton.
  • #277
    Quote from Loroese

    The elite bonus damage dim returns applies as soon as you add a second piece. The zuni boots+triumvirate affixes do not have the same diminishing returns. They do have their own relative dimishing returns, since triumvirate with 6/6/6 will add 18% dps, but adding boots to that only adds 1.26/1.18 = 1.068x, or about 6.8% to your dps. It still adds the right amount of damage though, so if you have 100k dps before triumvirate bonus, then you have 118k with triumvirate and 126k with tri plus boots. In short, each 1% from those adds the same dps as each other. For elite bonus damage that is not the case.


    My head is about to explode.

    100k base DPS, 118k with Trium, 126k with Zuni => that makes sense, because it's only 6.8% increase from 118k to 126k (relative increase, keeping diminishing returns in mind). But it only works because you add the 8% to the base DPS, not the 118k from Zuni.

    100,000 * 1.06 * 1.06 * 1.06 * 1.08 = 128,630 would be multiplicative; 100,000 * (1 + (0.06 + 0.06 + 0.06 + 0.08)) = 126,000 is additive and that's what's happening.

    So, where is the difference to elite bonus damage? (Meh, it's getting late at here, maybe that's why I don't get it - sorry.)
  • #278
    Quote from Bagstone

    Quote from Loroese

    The elite bonus damage dim returns applies as soon as you add a second piece. The zuni boots+triumvirate affixes do not have the same diminishing returns. They do have their own relative dimishing returns, since triumvirate with 6/6/6 will add 18% dps, but adding boots to that only adds 1.26/1.18 = 1.068x, or about 6.8% to your dps. It still adds the right amount of damage though, so if you have 100k dps before triumvirate bonus, then you have 118k with triumvirate and 126k with tri plus boots. In short, each 1% from those adds the same dps as each other. For elite bonus damage that is not the case.


    My head is about to explode.

    100k base DPS, 118k with Trium, 126k with Zuni => that makes sense, because it's only 6.8% increase from 118k to 126k (relative increase, keeping diminishing returns in mind). But it only works because you add the 8% to the base DPS, not the 118k from Zuni.

    100,000 * 1.06 * 1.06 * 1.06 * 1.08 = 128,630 would be multiplicative; 100,000 * (1 + (0.06 + 0.06 + 0.06 + 0.08)) = 126,000 is additive and that's what's happening.

    So, where is the difference to elite bonus damage? (Meh, it's getting late at here, maybe that's why I don't get it - sorry.)


    Honestly I have no idea why elite bonus works like that, but it's what someone else posted in a dps calculator. Before I saw it I just assumed it would be additive like the trifecta type items.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #279
    Minor update:

    Fixed a bug where Ruby damage wasn't being applied in the Full Gear Comparison tab
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #280
    Hey, Loroese, I use OpenOffice. I know I shouldn't lose anything when converting from .xlsx to .xls (or .ods), but I'll ask anyway (because OpenOffice reads .xlsx files but doesn't save, you have to use a different format). So, is it safe to save it as .xls or .ods?
  • To post a comment, please or register a new account.
Posts Quoted:
Reply
Clear All Quotes