[AFK] XP Regen Spreadsheet. No more Guesswork!

[owned727]

If anyone can help me out, id greatly appreciate it. numbers arent working for me on US realm.

[zuezlll]

the spreadsheet looks great, easy to input values and its intuitive. Only problem is the values don't seem to work for me. I've got the xp trick to work by guess and check. Would be nice if the values could be tightened up a bit. Seem to be off by about a third over three tries by myself.

[owned727]

the spreadsheet looks great, easy to input values and its intuitive. Only problem is the values don't seem to work for me. I've got the xp trick to work by guess and check. Would be nice if the values could be tightened up a bit. Seem to be off by about a third over three tries by myself.

Agreed. I had to get it to work by guessing. The values were pretty far off for me.

[b005td]

the values are way off
um .... about 100 life/sec too much

[n00bmasta]

Guys if its not working for you, can you plz post ur stats and class.

[senzmonk]

on double lines single person I'm using the following and its working great.

Class: Monk
Armor: 3530
Poison Resist: 451
Poison Resist %: 60.05
Life per second: 258
HP: 33713

This didn't match up to your spreadsheet for me, I just guess and checked it, the chart was helpful though.

[zuezlll]

on double lines as well, the chart was helpful also.

Class: barb
Armor: 4432
Poison Resist: 350
Poison Resist %: 53.85
Life per second: 104
HP: 16621

Would be nice if the spreadsheet would work for me.

If anyone wants to do 2p for more exp send me a pm

[n00bmasta]

Sorry guys i think the main problem is Barb and Monk's 30% innate reduction. I play wiz so didn't even think of that.

Quick fix it to multiply the required regen figures by 0.7

Let me know if that works, then I can update the spreadsheet

[n00bmasta]

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

I have deliberately not used +% life gems in helm for a few reasons.
1) +2% +4% +6% etc are all huge changes in terms of absolute numbers for life. It does not really help in the fine tuning process
2) I was at 35k life with +% life but the required regen actually got too high - Max regen is about 400 on ammy, and 220 each on rings. It was too hard to find 800 regen on ammy + 2rings
3) The AR indestruct helm i bought has no sockets :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

The +6 gems, and +4 thereafter is editable! You can edit that and mix and match to your heart's desire

"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.

Have tested this, but apparently each extra person only adds a flat 1x to the psn trail. Standing in 1xline with 1extra person = 2x, whereas standing in double line with 1extra person only does 3x. From what i've tested anyway

[senzmonk]

that might be my issue since i use a helm of command and it has 8% life on it cause even with taking the value for regen and multiplying it by .7 it was still off a bit ill tweek it some and try a helm without % life.

[n00bmasta]

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

that might be my issue since i use a helm of command and it has 8% life on it cause even with taking the value for regen and multiplying it by .7 it was still off a bit ill tweek it some and try a helm without % life.

Try it without shield, poison can be be blocked

[senzmonk]

Do you use an indestructable set btw? was thinking of putting some gold into it now that i understand the chart better.

[n00bmasta]

I have an indestruc set, but any set will do really; Problem is rings/ammy cant be indestruct,
As long as each piece of your gearset has more than 40 or 50 dura, its fine. (i think i lose about 6 dura/hr)

[gatoqueri]

+rep

Nice sheet!

[microgrinder]

Sorry guys i think the main problem is Barb and Monk's 30% innate reduction. I play wiz so didn't even think of that.

Quick fix it to multiply the required regen figures by 0.7

Let me know if that works, then I can update the spreadsheet

Seems right, tested the numbers with my barb that lasted through the night. Spreadsheet said i needed 56 life regen and I have 56.28 (using inspiring presence to regen). Not sure what the slight 0.28 difference is from (maybe blizzard rounds my life regen number), but I ran it for hours without a change in life and I only have 5.5k hp.