[AFK] XP Regen Spreadsheet. No more Guesswork!

[n00bmasta]

Hi all, it seems there has been a lot of trouble with people using guess and check to find a balanced point with AFK survival.

After some hard work, I have compiled this into a spreadsheet that will calculate all this for you automatically.

All you need to do is enter your stats without rings/ammy. Let the spreadsheet tell you how much regen you need. Then purchase away! (make sure the rings/ammy don't have Str/Vit/Int/Resists on it or it will change the calcs.)

Note: Dex is not calculated because the Poison trails on the ground apparently ignore dodge.

Any questions feel free to ask.

D3 Paragon XP regen calcs 1.03.xls

tbh this has been more fun than farming

Edit: http://www.ownedcore.com/forums/diab...any-class.html ([AFK] survive with x% health exping for any class) Link to orig thread

Solo yields 2.4m xp/hr
With 1 friend yield 3.6m xp/hr

Edit 2: Whoops it was showing double the amount of regen required :\
New spreadsheet should fix that

*UPDATE* - If you're playing Monk/Barb the 30% innate reduction is throwing the figures off. Quick fix is multiply the required regen figures by 0.7, will update spreadsheet when I get back

*UPDATE* 2 - Updated for Monk/Barb, figures slightly refined.

*UPDATE* 3 - v1.03: Unlocked sheet, changed dmg for x2 players etc.

[S0ul3r]

Where do I have to put my stats in this file? Can u make short TuT or sth?

[LaHonda]

Arm 2.167
PSN Res 84
PSN Reduc% 30,17%
Real Res 84,5
HP 14.645
DR from Arm: 66,330%
DR from Res: 43,445%
Total DR: 80,958%

The fat ones.

+rp to the thread, very nice sheet

Can you explain the Life Variance/hr?

[n00bmasta]

Life variance = how much life (as a percentage of your max life) you will gain/lose every hr due to the numbers not being perfectly balanced.
Since you need to be under 10% life to gain the xp, its an important measure of how long u can keep the exp going.

If you have 3% variance/hr, and assuming u're gaining life; You can start the run on 1% life and after 3hrs you will be over 10% and no longer gaining exp

[LaHonda]

Aight thanks.
Idk why but its pretty hard for me to get it to balanced xd

[n00bmasta]

How come? what stats u on? did u dismiss follower/turn off active spells like force armour?

[S0ul3r]

Can someone tell me How much regen do I have to have becouse I dont know where do I have to put my EQ info in this file Szczochu - Spo

[silv3rinc]

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

[venom1stas]

Can you pls add option for 4x players? Cant get it to work.

[janekkowal]

1) Add more gem options:
- +4 and all multiplications (8, 12, 16, etc.)
- -4 and all multiplications (-8, -12, -16, etc.)

2) include +% lifeoption. I have in total +17% life and I believe you haven't included that in your vita-gem calculations. e.g. (=$C23*($D$2*35)+$D$7) where is 1.17 in my case

3) 50+ gems are almost useless. no one would use them :P

[S0ul3r]

Can someone tell me How much regen do I have to have becouse I dont know where do I have to put my EQ info in this file Szczochu - Spo

[B166ER]

1) Add more gem options:
- +4 and all multiplications (8, 12, 16, etc.)
- -4 and all multiplications (-8, -12, -16, etc.)

2) include +% lifeoption. I have in total +17% life and I believe you haven't included that in your vita-gem calculations. e.g. (=$C23*($D$2*35)+$D$7) where is 1.17 in my case

3) 50+ gems are almost useless. no one would use them :P

with enough slots u can do + or - 2 by adding a chipped and removing 4 off anouther gem... so if u had a flawless square giving you 34 u could change that to a regular square being 30 and add a chipped for 6 giving u 2 more then before

[owned727]

Cant get it to work w/ spreadsheet. Just confirmed my stats are correct in it yet its telling me I need more regen than I do. I am using a 2x spot where i can notice extra ticks.

Arm 6,983 Sheet Armor Workings for decimal dot in AR Version 1.01 9/8/2012
PSN Res 604 Sheet Poison Resist 0.014% -0.5 66.796% Created by skyQuake
PSN Reduc% 66.81% Mouseover the PSN Resist number 0.011% -0.4 66.799%
Real Res 603.9 Real PSN resist with hidden decimal 0.007% -0.3 66.803%
HP 8,746 Sheet HP 0.003% -0.2 66.807%
DR from Arm: 86.391% Damage Reduction from Armor 0.000% -0.1 66.810%
DR from Res: 84.592% Damage Reduction from Armor 0.004% 0 66.814%
Total DR: 97.903% Total DR vs Poison Trail in Normal 0.008% 0.1 66.818%
0.011% 0.2 66.821%
Exp Dmg: 107.5911 Expected Damage over 5 sec 0.015% 0.3 66.825%
Dmg/sec 21.5182 Damage per second 0.019% 0.4 66.829%
0.023% 0.5 66.833%

Regen Required For: Life/sec Life Variance/hr Status:
Standing on 1x line 21.52 Standing on 1 Poison Trail 19.83% Unbalanced Unbalanced = unsustainable overnight, you will either full heal or die quickly
Standing on 2x spot 43.04 Spot where 2 Poison trails hit u 1.50% Balanced Balanced = very low net hp gain/loss. You will sit there and gain xp through the night!
2x Spot with Friend 64.55 Friend needs to be within 40 yards 18.33% Unbalanced

I am using 43 regen like it says and im regening too fast. Spreadsheet isnt working properly even though I edited all the blue fields.

[chs91]

Thx this is what i needed !

[janekkowal]

"Standing on 1x line 18.00 Standing on 1 Poison Trail
Standing on 2x spot 36.01 Spot where 2 Poison trails hit u
2x Spot with Friend 54.01 Friend needs to be within 40 yards
"
I think "2x Spot with Friend" is not correct. 2xspot in 2player game deals 4x dmg.