[AFK] XP Regen Spreadsheet. No more Guesswork!

[hokutanm]

Thx this is what i needed.

[EviLSidE]

@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

[Spritze]

Try using the armour increase table to find the perfect balance

im assuming %h = %health? is that via helm amethyst or chest amethysts?

No the %/h is +% per hour, that viliance procentage. The one you want at 0%, impossible to get it good, i've got no ideé how.

[n00bmasta]

Under 1.5% is fine. Don't need to get that to 0. That'll last a few hrs at least

[Kahra]

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.

[zuezlll]

thanks for the barb updated spreadsheet. +rep

[johnn11]

i must be missing something how does health regen affect ur exp gained?

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

[nocturnaljames]

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.

[Feldeath]

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

[BattleSparks]

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?

[suthek]

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.

[silv3rinc]

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

[BattleSparks]

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

are you for real?

[kelvinblade]

(D13) the dmg/sec should correspond to the red dmg displayed right?

[wizofoz]

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 )