[AFK] XP Regen Spreadsheet. No more Guesswork!

[mat123]

Hii, Thx for this spreadsheet ! But I don't understand how to use it ! I put my Armor, Psn resist , % psn resist , HP stat of my char but i always have unbalanced status. Do i need to change my stuff or what ?

[n00bmasta]

whats ur stats/class?

are u standing in the spot where u get hit for 2x? Do u have all buffs off? etc

[mat123]

I didn't try it out yet, i tought i need to get Balanced status in the spreasheet in order to Buy Life regen right ?

[zuezlll]

you are right about the 30% reduction for barbs. It totally matches up now. If you have the time it would be nice to have a column or option for barbs with reduction. thanks for the sheet, great work so far.

[zuezlll]

Or maybe even a separate spreadsheet. *Fingers crossed*

[zuezlll]

@mat123 I believe you want to your life regen total close to a whole number. If the value is like 45.5 then you need to tweak the setup by following the gem guide on the bottom. add vit or str gems to bring you closer to not having a decimal like 45.01 for example.

[Licentia]

this is for normal ? or nightmare?

[janekkowal]

normal. . .

[microgrinder]

Just wondering if anyone has tried this spreadsheet without a level 60 character? Does it work or are the numbers off?

[b005td]

i have a 60 barb
the life per sec i have is off by 0.02 (sheet says 245.8, i have 246)
for whatever reason i keep dying after 2 hrs or so.... need more fine tuning

i have 9% life on the chest idk if that matters

[n00bmasta]

stats? try to get rid of life% cause that changes life to a decimal dot number rather than a round figure

[Spritze]

I'm trying and trying, any tips on where to begin approaching the goal ? once i fine tune the %/h gets a % boost and is unbalanced.

[n00bmasta]

Try using the armour increase table to find the perfect balance

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

[EviLSidE]

Hi n00bmasta and thank you for your work. I see you've put quite some effort in all the math and stuff and help the community.
However when I start filling up my DH's stats something strange is happening. I fill out the Armor cell and it's fine. Then comes the PSN Res cell and it's still fine. But when I fill up the PSN Reduc% it puts out #VALUE! in some of the lower cells and also in Regen required. I tried filling up 10 times and same happens (i.e. I'm 99% sure I'm not doing any mistakes).

My DH stats:
Armor: 4434
PSN Res: 1046
PSN Reduc%: 77.71%
HP: 12932

Thank you in advance!

EDIT: I'm a complete retard. Been using dot instead of comma for my 77,71% ..........

[janekkowal]

@EviLSidE:
use dot instead of coma.
77,71% WRONG
77.71% CORRECT


@n00bmasta:
There is still a mistake in "2x Spot with Friend" section. Damage taken in 2p game in a single-spot is doubled (2xDMG) and damage taken in 2p game in a double-spot is quadruple (4xDMG).