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.
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.
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?
This spreadsheet looks like it only calculates hit points for a character of max level. Could you adjust it so characters of lower level could have HP calculated? That would be awesome.
Good job on the spreadsheet!
If you know the hp level scaling, or know where I could find it, I'd be happy to include this.
Ok.. I had to load a few character and do a little math but it looks pretty basic.
You start with a base hp pool of 36 + (4 * Level), so a level 26 character would start with 140 hp.
You then get a bonus based on VIT. From levels 1 to 35, you get 10 Life per VIT. From levels 36 and beyond you get (Level-25). So a level 41 character would get 16 Life per VIT.
Then you just multiply the sum of those two by your Max Life% bonuses.
This spreadsheet looks like it only calculates hit points for a character of max level. Could you adjust it so characters of lower level could have HP calculated? That would be awesome.
Good job on the spreadsheet!
Rollback Post to RevisionRollBack
To post a comment, please login or register a new account.
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.
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?
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?
Ok.. I had to load a few character and do a little math but it looks pretty basic.
You start with a base hp pool of 36 + (4 * Level), so a level 26 character would start with 140 hp.
You then get a bonus based on VIT. From levels 1 to 35, you get 10 Life per VIT. From levels 36 and beyond you get (Level-25). So a level 41 character would get 16 Life per VIT.
Then you just multiply the sum of those two by your Max Life% bonuses.
Good job on the spreadsheet!