[AFK] XP Regen Spreadsheet. No more Guesswork!

[n00bmasta]

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 )

So far so good, you'll want 126.58 to get balanced by adding str or vit gems to your armour.
Scroll down to +str gems
and you'll see with +26 str you'll need 126.04 regen, which is Balanced.

So all you'll need is a +26 str gem and 126 worth of regen on rings/ammy. Make sure ur new rings have no stats on it or it'll change the calcs

[n00bmasta]

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

Not really;

The psn fire ticks 11 times per wave and the wave cycles every 5secs. Also, the red dmg numbers don't have decimals so its a bad indication of true dmg.

[janekkowal]

In double spot you are hit ~22times per 5sec cycle.
But still no decimals which in low-dmg-taken-bulids might be crucial.

[PleaseHelpMe]

any built up cheap set to recommend so that we don't have to use the spreadsheet? =D. Don't understand the spreadsheet sorry >_<... can i follow ur items instead? =)

[kelvinblade]

i'm using my alt account to help my main in a 2p game.
my alt just stands in the green with indestructable gear and regen gear and never gets disconnected.
my main gets disconnected sometimes. is it because i'm getting xp in my main?
i dont want to macro if i dont have to. anyone else with this problem?

[ingwe]

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




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



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

Hmm, I tried it with a second account last night, and the damage for 2 players, one on double spot, one on single spot, seems to inflict two times the damage of one person on double spot (four times of damage for one person in single spot). I tried the numbers predicted by the spread sheet, basically where you take the damage/sec times three, and health went down extremely fast. According to spreadsheet I needed like 280 regen. I then added another column with 4 times damage etc, simple duplication of your calculation, it I got something like 360 hp regeneration. I did not have time to test it, was already too late and I did not want to go back to the AH, but will test tonight.

Anyone else noticed this or had to make adjustments? Other than that, great spreadsheet, love how you incorporated the gems! Thanks a lot for this.

[janekkowal]

I have and I have already submitted this issue here ([AFK] XP Regen Spreadsheet. No more Guesswork!)but seems that n00bmasta haven't changed it in the spreadsheet.
It's confirmed that on double spot in 2p game you are taking 4x damage.

[n00bmasta]

Whoops fixed that and uploaded new one.

It appears that if someone is standing more than 10 yards away, its not double but 3x dmg, whereas if they're standing on top of u in the fire its 4x as above ^

[johnycocring]

how do u not get booted from game while afk?

[n00bmasta]

You're gaining survival exp which counts as doing something (such a attacking or walking). So you actually never get booted as long as you keeping gaining that survival xp

[johnycocring]

You're gaining survival exp which counts as doing something (such a attacking or walking). So you actually never get booted as long as you keeping gaining that survival xp

well i asked an obvious question that someone with the competence or common sense would recognize i was booted therefore im asking how do you not get booted

i did this for 1 hour 30 minutes and was DISCONNECTED from the game



also, has anyone ever been banned for this?

[n00bmasta]

well i asked an obvious question that someone with the competence or common sense would recognize i was booted therefore im asking how do you not get booted

i did this for 1 hour 30 minutes and was DISCONNECTED from the game



also, has anyone ever been banned for this?

Thanks for question my competence and common sense; my answer doesn't change, you will not get booted unless you're doing something wrong. (ie earning survival xp)

No you won't get banned.

Also, you're welcome.

[urge2012]

I found that, in v1.03. %Dmg has change from 58.6510% to 58.6550%.

May I ask where this %Dmg parameter can be found.

I really appreciate your work, helped me a lot, THX

[n00bmasta]

I found that, in v1.03. %Dmg has change from 58.6510% to 58.6550%.

May I ask where this %Dmg parameter can be found.

I really appreciate your work, helped me a lot, THX

Empirical testing

Still not sure that figure is 100% correct yet lol, but its pretty damn close.
Biggest problem is hidden decimals in health

[urge2012]

Empirical testing

Still not sure that figure is 100% correct yet lol, but its pretty damn close.
Biggest problem is hidden decimals in health

Empirical testing！That must have been very difficult.

58.6510% should be very close, but I am sorry to say that, 58.6550% may not be 100% accurate.

I have been using the XP Regen the Spreadsheet for ten days, always very effective, except last night.Yesterday I got" Life Variance / hr" 0.06% with %Dmg 58.6510%,that mean I do not need to do anything all the night.

But then, I found HP reduced fast. I estimate that the actual "Life Variance / hr " is 1.6%~2.0%. This morning I recalculated with %Dmg 58.6550%, " Life Variance / hr"change to 0.34%.

I think I should just be in a critical point, so the error is relatively large.10 days of actual use, prove that the Spreadsheet is very accurate and effective.