Thx this is what i needed.
Thx this is what i needed.
@janekkowal
Yes I noticed that but it's actually the other way around. You need to use comma instead of dot.
@n00bmasta
Big thanks for this sheet man! Keep up the good work!
+5 rep
Last edited by EviLSidE; 09-10-2012 at 04:45 AM.
Under 1.5% is fine. Don't need to get that to 0. That'll last a few hrs at least
It's actually easy to get it very close to 0% variance. Pick up 2 or 3 of each dropped strength/vitality gem, and then look at the two charts at the bottom.
Also, make sure your talents aren't affecting your stats--I had glass cannon on, for example, and wasn't sure what was messing with my values.
thanks for the barb updated spreadsheet. +rep
the lower ur health is when u get out of combat the more survivability multiplier u gain from surviving i.e 3.4% or .5%... basically the lower the better... the lower the health regen the more xp u get over the long run.. if u regen too fast ull lose xp overall.. then again u dont want to regen too low or else ull die and dont get any xp at all
and for the OP its a very nice spreadsheet works great +rep
Thank you for your work on this spreadsheet, it's very helpful. I think it needs more fine tuning. I am doing 2x spot with friend, I had to correct the formula to 4x, you had 3x. My variance is only .25%/hr according to spreadsheet. However after 4 hours my life went down 7%, not 1%. I read somewhere there is a 5% critical hit chance that is maybe doing more damage?
My stats:
4014 Armor
829 PR
73.43% PR
19036 HP
regen needed for 2x spot 225.01 (.25%/hr variance)
actual regen 225
When I started I was bottoming out at 8.5%, and after 4 hours I was bottoming out at 1.8%, so I'm losing more life than I should be according to the spreadsheet.
Great work! Also could you please give the code blocking the edition so we can adjust w/o having to do it all again?
Thanks
I got a question
Since this calculator is calibrated for normal difficulty, i am assuming it is done in normal because the survival bonus +155XP is the same in inferno mode?
it's based on player level; Not based on difficulty.
155xp is at level 60. feel free to try on a level 30 and you'll see a much lower number.
what does this even do who cares about regen? im confused on how this helps exp gain? can someone just quixk explain the purpose of this
(D13) the dmg/sec should correspond to the red dmg displayed right?
i dont understand how this works... u remove ur rings amus, put armor+psn res+psn reduction+hp stats, and it shows how much hp regen is needed for this to work? or do i need to manually change the numbers where it shows hp regen until status changes to balanced?
Edit:
Heres my barb that im trying to put to work:
Armor: 4935
PSN Res: 440
PSN Reduction%: 59.45
HP: 21136
When i enter these stats, i get:
Standing on 1x line 63,29 Unbalanced
Standing on 2x spot 126,58 Unbalanced
do i need to keep changing the hp regen values manually? (63,29 and 126,58 )
Last edited by wizofoz; 09-17-2012 at 06:43 AM.