[AFK] XP Regen Spreadsheet. No more Guesswork!

[janekkowal]

maybe you are using some passive (glass canon, etc.) or active (energy armor, etc.) skills? or follower?
if it says "274 reg/s" than you need 274 reg/s.
remember that every additional stat (str, int, vit, armor) on the life regeneration ring changes all the calculation.

[3outcast]

This tool is Perfect! No-no, I'm realy impressed.

Thank you.

[oxyi]

maybe you are using some passive (glass canon, etc.) or active (energy armor, etc.) skills? or follower?
if it says "274 reg/s" than you need 274 reg/s.
remember that every additional stat (str, int, vit, armor) on the life regeneration ring changes all the calculation.

Hmm. I do have glass canon on, but I thought that's taken into perspective already.. I will try without it and see if taken less damage..
I don't have any other skills on, and no follower.

Yes on the ring, I only picked ring with regen without any other modifier stats..

I will report back.. thanks janekkowal!

[Hackcar]

Did you change the class to something other than barb or monk? since using those names give u a 30% increase in armor

[oxyi]

Did you change the class to something other than barb or monk? since using those names give u a 30% increase in armor

yep, I did changed it to Wiz.

I think I figure out the problem... I thought you should be able to do this thing on any difficulty, but I was wrong, I was doing it in inferno and i was getting like a motherfker... now I change to nightmare or something else, I am getting hit around what I am suppose to regen back.

Is that the difficulty you guys are playing at ?

[firemand]

Looking for people to do in multiplayer! Post battletag if your up.

[th3supervisor]

Looking for people to do in multiplayer! Post battletag if your up.

in - hare#9834

[vocabuary]

add me firemand, currently me and 4 other friends doing it but we need more people.
tag= zyxx#7432

[frozzty]

Looking for people to do in multiplayer! Post battletag if your up.

Count me in ofc. Down#8432

[glasscanon47]

If it gives more experience in multiplayer then you can add me on sorc#7391
i am on europe!

[janekkowal]

Is that the difficulty you guys are playing at ?

Normal.

[Thrillseeker]

You should change the formulas for the life variance to this:

life variance/hr calculation:

=(ROUND(B18,0)-B18)*60*60/$B$7

this way you get either a negative or positive number which will also tell you if your average life is rising or falling over the course of several hours. That way you can either start your afk session at ~1% or 9%.

You would have to change the "Balanced"-Indicator to this to make up for the changes:

=IF(abs(E18)>1.5%,"Unbalanced","Balanced")

[ayeyoh]

I've been trying to develop the spreadsheet for 3 party members in 2x spot but couldn't find the exact damage per second or damage multiplier.

did someone manage to get it?

[afkexpfan2012]

Thanks, I tried this before but couldn't quite tweak it perfectly, now I got it just right. Needed to add some more str to increase my armor, so I could have a more even life regen number, and now it's working perfectly, thanks for this spreadsheet, very helpful. Registered just to say thank you for this.

Hmm, I keep getting disconnected after 30 minutes, any way to stop that from happening? Because it kind of defeats the purpose of afk leveling if you can't actually go afk for more than 30 minutes.

[sl350]

I think this has been fixed with 1.07. Health dropping below 10% does not seem to give xp any longer. Can anyone confirm?