But I am sad, that I can no longer download it via google. It gave me the choice to download it in ODS format (Open Office Format). When I convert it from XSLM format, it destroys some rows.
I also converted the buttons (very VERY poorly) from v6 so there is are 'equip selection' and 'clear selection' buttons, but I'm not sure how/if macros will work for you - They may be the worst written macros ever seen but they are functional.
I have 2.30 life steal on one of my weapons. (I dual wield)
I have 0 life on hit
I have 34743 damage.
Life on hit regen states : 799. But I never see that number when I auto attack. is this accurate or bugged or what?
Trying to figure out whats better, getting like 5% more life steal or life on hit.
The 799 on the spreadsheet is the total amount of heals expected to come from your life on hit regen (your 2.3% life steal) before you either die, or reset your health with a healing ability. I would check your health regen multiple and ensure it is somewhat accurate to your experiences, and then just look at the relative stat value of life steal and life on hit to compare them (note: health regen multiple won't matter if you are only comparing life on hit to life steal as the multiple would effect them both equally)
I am usually able to load this document up in Google documents. Was the extension changed on v6 at all?
EDIT: I was able to get it loaded up by changing the extension on it from xlsm to xls. Thank you for your hard work. Have you thought about expanding this spreadsheet to all classes?
Was there an in-game change in the calculation of attacks per second? My understanding of the IAS change was that there was just a straight reduction in IAS numbers and no hidden diminishing returns, but it doesn't seem to be calculating the same as before. I am going sword-and-board with a 1.44 base APS weapon. The weapon itself has +11% IAS and I have +20% IAS on my armor. My in-game stats tells me my APS is 1.77. Using the calculation from the spreadsheet, I should have an APS of 1.92 rather than the 1.77 the game is telling me. Am I missing something? Everything matched up perfect before I made this weapon switch (didnt have IAS on my weapon before)....
You are correct, I was misunderstanding the base weapon speed. If I change my base weapon speed to 1.30, then add Enchantress to the calculation, it comes out correct. Thanks for correcting me
I killed Izual yesterday too and had no problem in defeating him, because of the fact that the massive loh could heal his damage without any problems. This would mean I have to set the value for “Expected time to live without heals” technically to infinite (for that fight), which would mean that my effective health would be infinite too (regarding to your spreadsheet). But don't think that I don't died yesterday from champion packs.
I would say that the correct model comes from the comparison of the incoming damage to the life regeneration mechanics. I would write the equation X = heal – damage for it. If X is positive or zero I would classify the play style as solid, because that means that the character can't die due to planned scenarios. If X is negative on the other hand, it would mean that the character is dying at least slowly if no other sources for healing are used (e. g. a skill, healing potion or shrine). A thing you have to keep in mind is that the incoming damage is reduced due to armour, resistance, etc. So the equation would change to X = heal – reduction * damage. If you want, you can interpret X as a characters health and say that he will die when the time dependent term health + heal – reduction * damage is zero or less(see edit). As you can see the healing effects can't be interpreted as direkt health (as you are doing in the spreadsheet). The right way, from my unterstanding, would be to compare the healing to the incoming damage. Which leads to the question for accurate raw damage numbers for the single acts.
Ideally if there was a source for average damage from acts this model could work. However as it is currently setup, the values for life on hit are meant to model your worst case scenario, so you should enter numbers from the champion pack rather than from izual, and if you happen to completely over gear a fight great. When you come up against a group that is giving you trouble, the current model will at least value your LoH at something that might be valuable.
Just as an afterthought, if the model did change, and you input izual's damage into your average damage formula, you would still come up with a over stated value of LoH and be disapointed when you die to the champion pack. The model isn't perfect, but its reasonable and easy to use. In most cases your healing will be better than projected if you are using conservative health regeneration multiples.
But I have one final question. If I have seen it right the block mechanics are not valued at the moment. Have you plans in changing this?
Nothing super soon, but I was thinking about adding an optional "Average damage taken" slot for use with the block mechanic, and you could use in game damage tooltips for putting a value in there. It would basically take your average damage and compare it to your average block value to find the value of block % or block amounts. I'd likely upload with the option turned off so that only people who are interested in the feature would have to change the value, I'm thinking of a revision Wednesday-ish / maybe thursday to include this and a few more options.
Does this spreadsheet account for the Barbarians and Monks innate 30% damage reduction from all sources?
I have Jungle Fortitude with my Witch Doctor which grants 20% damage reduction. Where would I be able to squeeze this in there?
No, it doesn't account for the 30% innate damage reducation, this is a flat reduction that everyone has (or doesnt have) and won't affect any choices you use this sheet to make.
As far as the jungle fortitude, does it stack with threatening shout? You could add that on in the spreadsheet if it doesn't. However again a flat increase doesn't really change any choices. The only reason threatening shout is on the spreadsheet is to compare it to other abilities that actually scale based on gear and possibly exploit break even points.
Does this spreadsheet account for the Barbarians and Monks innate 30% damage reduction from all sources?
I have Jungle Fortitude with my Witch Doctor which grants 20% damage reduction. Where would I be able to squeeze this in there?
No, it doesn't account for the 30% innate damage reducation, this is a flat reduction that everyone has (or doesnt have) and won't affect any choices you use this sheet to make.
As far as the jungle fortitude, does it stack with threatening shout? You could add that on in the spreadsheet if it doesn't. However again a flat increase doesn't really change any choices. The only reason threatening shout is on the spreadsheet is to compare it to other abilities that actually scale based on gear and possibly exploit break even points.
Ah... excellent.. I think i can use Threatening shout for my purposes.
Does this spreadsheet account for the Barbarians and Monks innate 30% damage reduction from all sources?
I have Jungle Fortitude with my Witch Doctor which grants 20% damage reduction. Where would I be able to squeeze this in there?
No, it doesn't account for the 30% innate damage reducation, this is a flat reduction that everyone has (or doesnt have) and won't affect any choices you use this sheet to make.
As far as the jungle fortitude, does it stack with threatening shout? You could add that on in the spreadsheet if it doesn't. However again a flat increase doesn't really change any choices. The only reason threatening shout is on the spreadsheet is to compare it to other abilities that actually scale based on gear and possibly exploit break even points.
Ok, so I ended up using the Monk's Resolve ability. Just lowered the amount by 5% and my effective HP when from 67k to 89k. Still a huge fan of your spreadsheet.
Can you please add non-survivability oriented shouts and passives to the spreadsheet? Battle Shout, Weapon Master, etc. I know it's surivvability focused, but since it's calculating dps anyway, it would be nice to get a more accurate picture.
Err... Also, the spreadsheet is telling me I *lose* effective health if I turn on Tough as Nails. Is this even theoretically possible?
Can you please add non-survivability oriented shouts and passives to the spreadsheet? Battle Shout, Weapon Master, etc. I know it's surivvability focused, but since it's calculating dps anyway, it would be nice to get a more accurate picture.
Err... Also, the spreadsheet is telling me I *lose* effective health if I turn on Tough as Nails. Is this even theoretically possible?
Yep, I'm going to be a bit busy the next couple of days, but I was planning on doing something like that soon, definitely sometime over the weekend. The main reason increases damage % was optional was to make this more of a open to other classes type thing, but that could definitely be changed to an automatic based on passives (and of course overwritten if needed to be).
Depending on what you mean by losing effective health. If it has a negative % beside it in the options panel, then something is wrong, if your effective health decreases and your only change is turning the passive on then please see this previous post:
EDIT: Upon further testing, its only changing "tough as nails" from 1 to 0 that seems to increase my effective health by around 20k.
The change you are seeing is because you are turning off your passive that gives you armor (tough as nails) without changing your character sheet armor value. This is working properly. The plus armor buffs are additive and not multiplactive, so for example if you have a 25% armor buff and a 20% armor buff they would combine to 45% rather than 50% (which you would get by multiplying) because this is the case, each "real" armor value gives you more total armor than the "extra" armor from the passive.
The problem basically stems from you telling the spreadsheet 25% of your armor is from the buff when you turn it on, when in reality you haven't added the 25% armor the buff gives you.This is also a planned change in a new revision, that armor will be calculated rather than input.
The Barbarian belt modifiers to Bash,Cleave,Frenzy,Rend,Revenge,Weapons Throw
The Barbarian 2-hand modifiers Hammer of the Ancients,Overpower,Seismic Slam,Whirlwind
Also the Monk abilities for those monk players.
Would it be possible to add to the Relative Stat values or something along those lines so we can get an idea of what amount of dps they will add. Or what they are normalized to Str.
Example. Belt 1: 200 Str 100 Vit 60 RAE = 2000 dps upgrade
Belt 2: 100 Str 100 Vit 60 RAE 10% increased Frenzy Damage = ?
Also Damage increased by skills % add it to be modified with current equipped an possible switch.
Since with passive talent mace gets 10% crit were sword gets 15% damage. This way we can see the dps change based on weapon type when we are looking for upgrades.
The belt modifiers to abilities like Frenzy is not a strait damage increase to ability its factored in after all other modifiers. So say you hit for 100k an have 10% Frenzy on belt you would then hit for 110k. I dont know the math for it but its possible to get an idea of what it translates into compared to str (yes rotation an usage factor into it also). Same for the modifers to other abilities. Most people would like an idea even if its a rough one on what you get from these abilities compared to other stats. Even setting on spreadsheet to state your rotation to get a more precise number. I am just posting what alot of people might find useful.
Also on the damage % i am referring to is Weapons Master passive. Your unable to compare a mace that gives 10% crit to a sword you have on that gives 15% damage because you can not remove the 15% damage in current equipped row its colored out. It is just a simple change that i thought i would mention.
The Barbarian belt modifiers to Bash,Cleave,Frenzy,Rend,Revenge,Weapons Throw
The Barbarian 2-hand modifiers Hammer of the Ancients,Overpower,Seismic Slam,Whirlwind
Also the Monk abilities for those monk players.
Would it be possible to add to the Relative Stat values or something along those lines so we can get an idea of what amount of dps they will add. Or what they are normalized to Str.
Example. Belt 1: 200 Str 100 Vit 60 RAE = 2000 dps upgrade
Belt 2: 100 Str 100 Vit 60 RAE 10% increased Frenzy Damage = ?
Also Damage increased by skills % add it to be modified with current equipped an possible switch.
Since with passive talent mace gets 10% crit were sword gets 15% damage. This way we can see the dps change based on weapon type when we are looking for upgrades.
I am so thoroughly confused... Can't you just put in belt 1 and belt 2, and see how much of a change between them they are and then if its more then 10%, for sure use belt 1, and if its less then 10% decide if its worth the frenzy damage?
Also, you can put in % damage (D33) and % crit (F/G35) into the spreadsheet, although weapon type is an addition that probably will make it into the next version.
Loving this sheet, thank you so much for making it.
I want to compare weapons, one has +STR one doesn't. If I'm doing this correctly, do I just put -100 in the Possible Switch column under Strength to reflect the change in DPS?
Loving this sheet, thank you so much for making it.
I want to compare weapons, one has +STR one doesn't. If I'm doing this correctly, do I just put -100 in the Possible Switch column under Strength to reflect the change in DPS?
Yep, or you could put 100 dps in the current equip column, but both will do the same thing.
Rollback Post to RevisionRollBack
To post a comment, please login or register a new account.
Still trying to find information on mantra of healing / Invigorate to include their scaling with level.
I primarily use OpenOffice as well and convert every revision for personal use. You can get the v6 I have here https://dl.dropbox.c...e.v6.Macros.ods
I also converted the buttons (very VERY poorly) from v6 so there is are 'equip selection' and 'clear selection' buttons, but I'm not sure how/if macros will work for you - They may be the worst written macros ever seen but they are functional.
The 799 on the spreadsheet is the total amount of heals expected to come from your life on hit regen (your 2.3% life steal) before you either die, or reset your health with a healing ability. I would check your health regen multiple and ensure it is somewhat accurate to your experiences, and then just look at the relative stat value of life steal and life on hit to compare them (note: health regen multiple won't matter if you are only comparing life on hit to life steal as the multiple would effect them both equally)
EDIT: I was able to get it loaded up by changing the extension on it from xlsm to xls. Thank you for your hard work. Have you thought about expanding this spreadsheet to all classes?
Ideally if there was a source for average damage from acts this model could work. However as it is currently setup, the values for life on hit are meant to model your worst case scenario, so you should enter numbers from the champion pack rather than from izual, and if you happen to completely over gear a fight great. When you come up against a group that is giving you trouble, the current model will at least value your LoH at something that might be valuable.
Just as an afterthought, if the model did change, and you input izual's damage into your average damage formula, you would still come up with a over stated value of LoH and be disapointed when you die to the champion pack. The model isn't perfect, but its reasonable and easy to use. In most cases your healing will be better than projected if you are using conservative health regeneration multiples.
Nothing super soon, but I was thinking about adding an optional "Average damage taken" slot for use with the block mechanic, and you could use in game damage tooltips for putting a value in there. It would basically take your average damage and compare it to your average block value to find the value of block % or block amounts. I'd likely upload with the option turned off so that only people who are interested in the feature would have to change the value, I'm thinking of a revision Wednesday-ish / maybe thursday to include this and a few more options.
Excel. I'll upload a macro free one, and possibly an open office format in the next revision, but it really shouldn't be giving you troubles.
Does this spreadsheet account for the Barbarians and Monks innate 30% damage reduction from all sources?
I have Jungle Fortitude with my Witch Doctor which grants 20% damage reduction. Where would I be able to squeeze this in there?
No, it doesn't account for the 30% innate damage reducation, this is a flat reduction that everyone has (or doesnt have) and won't affect any choices you use this sheet to make.
As far as the jungle fortitude, does it stack with threatening shout? You could add that on in the spreadsheet if it doesn't. However again a flat increase doesn't really change any choices. The only reason threatening shout is on the spreadsheet is to compare it to other abilities that actually scale based on gear and possibly exploit break even points.
Ok, so I ended up using the Monk's Resolve ability. Just lowered the amount by 5% and my effective HP when from 67k to 89k. Still a huge fan of your spreadsheet.
Err... Also, the spreadsheet is telling me I *lose* effective health if I turn on Tough as Nails. Is this even theoretically possible?
Yep, I'm going to be a bit busy the next couple of days, but I was planning on doing something like that soon, definitely sometime over the weekend. The main reason increases damage % was optional was to make this more of a open to other classes type thing, but that could definitely be changed to an automatic based on passives (and of course overwritten if needed to be).
Depending on what you mean by losing effective health. If it has a negative % beside it in the options panel, then something is wrong, if your effective health decreases and your only change is turning the passive on then please see this previous post:
The problem basically stems from you telling the spreadsheet 25% of your armor is from the buff when you turn it on, when in reality you haven't added the 25% armor the buff gives you.This is also a planned change in a new revision, that armor will be calculated rather than input.
The Barbarian 2-hand modifiers Hammer of the Ancients,Overpower,Seismic Slam,Whirlwind
Also the Monk abilities for those monk players.
Would it be possible to add to the Relative Stat values or something along those lines so we can get an idea of what amount of dps they will add. Or what they are normalized to Str.
Example. Belt 1: 200 Str 100 Vit 60 RAE = 2000 dps upgrade
Belt 2: 100 Str 100 Vit 60 RAE 10% increased Frenzy Damage = ?
Also Damage increased by skills % add it to be modified with current equipped an possible switch.
Since with passive talent mace gets 10% crit were sword gets 15% damage. This way we can see the dps change based on weapon type when we are looking for upgrades.
Also on the damage % i am referring to is Weapons Master passive. Your unable to compare a mace that gives 10% crit to a sword you have on that gives 15% damage because you can not remove the 15% damage in current equipped row its colored out. It is just a simple change that i thought i would mention.
I am so thoroughly confused... Can't you just put in belt 1 and belt 2, and see how much of a change between them they are and then if its more then 10%, for sure use belt 1, and if its less then 10% decide if its worth the frenzy damage?
Also, you can put in % damage (D33) and % crit (F/G35) into the spreadsheet, although weapon type is an addition that probably will make it into the next version.
I want to compare weapons, one has +STR one doesn't. If I'm doing this correctly, do I just put -100 in the Possible Switch column under Strength to reflect the change in DPS?
Yep, or you could put 100 dps in the current equip column, but both will do the same thing.