[AFK] XP Regen Spreadsheet. No more Guesswork!

[John479]

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

[weffweff03]

Hey I'm looking to partner up with someone for the 4.7m per hour bonus. I AFK on a separate laptop and will leave it on 24/7. Please PM me for battletag, thanks!

[AxeDH]

Mod of the original made by skyQuake,

https://dl.dropbox.com/u/104273897/D...cs_1.02.2.xlsm
(again thanks to skyQuake for this. i also updated his calculation of 58.655% in it.)


This is set for x2 spot, and you just enter how many gem slots you have, what you want the max size of these gems to be, and hit the macro button.
1) It figures out the best combination to use, and tells you what regen you need.
2) If you already know what regen you want, stick that in and it tells you what will make that combination work.

Feel free to mod it all up, sheet 2 is the nuts and bolts of it. columns A thru G are what figures out what possible gems to use, Columns M thru V is what gets populated upon hitting the button. maybe dont delete A thru G, or row 2 in columns M thru V, or move stuff around in sheet2. Some basic vba inside it, alt f11 brings it up, its in the Module Section. (im not a geek at VBA, so dont mock it.)

Limitations: Dont enter gem sizes that are retarded, like max 10. u should be able to afford at least a 34. Its only capable of max 6 Gem Slots atm. It can be easily expanded to 10, but i didnt really feel like doing all the work, nor the extra coding.


Anyways skyQuake, if you read this, and feel like posting the spreadsheet in your first page... its up to you.

[Kahman]

Unfortunately it seems they have fixed this in the sense that you will now get disconnected for inactivity. Has anyone else had this happen to them?

[rohan123321]

WHere is this place?

[Tester404]

Unfortunately it seems they have fixed this in the sense that you will now get disconnected for inactivity. Has anyone else had this happen to them?

Happens to me too: after 20-30 mins of survival xp, I get disconnected. How do you guys work around that ?

[kidmar]

Happens to me too: after 20-30 mins of survival xp, I get disconnected. How do you guys work around that ?

There are several ways to prevent it. The easiest is to interact with D3. If you are completely AFK you should look for an AFK preventing script.

Does crit% matter in the calculations?
This sheet is great and works good, but it isn't very accurate and I'm wondering what it could be.
I usually gain more vit then I should.

[Tester404]

Mod of the original made by skyQuake,

https://dl.dropbox.com/u/104273897/D...cs_1.02.2.xlsm
(again thanks to skyQuake for this. i also updated his calculation of 58.655% in it.)


This is set for x2 spot, and you just enter how many gem slots you have, what you want the max size of these gems to be, and hit the macro button.
1) It figures out the best combination to use, and tells you what regen you need.
2) If you already know what regen you want, stick that in and it tells you what will make that combination work.

Feel free to mod it all up, sheet 2 is the nuts and bolts of it. columns A thru G are what figures out what possible gems to use, Columns M thru V is what gets populated upon hitting the button. maybe dont delete A thru G, or row 2 in columns M thru V, or move stuff around in sheet2. Some basic vba inside it, alt f11 brings it up, its in the Module Section. (im not a geek at VBA, so dont mock it.)

Limitations: Dont enter gem sizes that are retarded, like max 10. u should be able to afford at least a 34. Its only capable of max 6 Gem Slots atm. It can be easily expanded to 10, but i didnt really feel like doing all the work, nor the extra coding.


Anyways skyQuake, if you read this, and feel like posting the spreadsheet in your first page... its up to you.

Extremely good stuff: thanks a lot !

[inforsir89]

no matter what i do i cant edit the spread sheet and its annoying anyone cna shead some light on this i has ms excel veiwer

[d3stroyed]

no matter what i do i cant edit the spread sheet and its annoying anyone cna shead some light on this i has ms excel veiwer

Try uploading it to Google docs, as I am not positive that you can edit fields in excel viewer.

[kertenkel]

you can't edit in excel viewer

[SilencerFU]

EDIT:

I had the old spreadsheet. Downloaded the new one---works great.

[Predsr]

is it possible to add 3p and 4p using the 2x spot?

[YukaChen]

thanks this is what i needed.

[thelegend0012]

Hello Guys,
first of all thx for this nice thing you brought to us
I played with the spreadsheet to find out which numbers i need and ended up with these... i've found the right equipment and went to the 2x zone. But my life Variance/hr is a lot higher than it should which means i'm ending up with full health after 5 mins... :/&


Anybody know a fix because ive spend some time finding the right numbers...

best regards,
thelegend0012