PDA

View Full Version : Health Regeneration 4 Dummies



steveo127
05-29-2013, 11:33 PM
Here it is boys and girls! The attached is a Microsoft Excel Spreadsheet I have made that is an easy-to-use health regeneration time calculator!

there is short process you must follow in order to access the fruits of my labor, since the ability to upload anything other than a picture is still currently unavailable.....That being said, my instructions are very clear; so it shouldn't take you longer than 30 seconds as long as you follow them precisely

(if this proves to be too difficult to access, then I may post my personal e-mail for you to e-mail me directly for the document)

So without further adieu......



Step 1) click on this URL https://docs.google.com/spreadsheet/ccc?key=0AmG4AV0ATN9NdGhpZWs3LVhjbjFteElCVVNaenljW FE#gid=0

Step 2) Click on File (upper left of screen) then scroll down to "Download as" and choose "Microsoft Excel (.xlsx)

Step 3) DONE!! :)


I have spent a fair bit of time on this, mostly on making it more user friendly...this has required truncating formulae in order for there not to be nasty scratch work all over the screen so I hope you find it clear and not confusing.

I believe you will find this quite useful; though if you don't please, only constructive comments. Feel free to voice your opinion, and let me know if there are any bugs you find. Please note that this has been made based upon Boss Events. I'm not sure yet if the calculations will need to be adjusted for World Domination Events. I will do my best to update this with new versions accordingly.


Instructions are included.

Download and Enjoy!

steveo127
05-29-2013, 11:36 PM
Reserved for self-congratulatory praise


:o :) Good job Stephen! Thanks so much! :) :o

vNastIER
05-29-2013, 11:37 PM
out friggin standing my man.
do you do phone walk throughs lol

skype perhaps haa

this stuff is gold. gonna take it for a test drive right now.
will report back

p.s. where did my bacon wrapped cake go ;)

Starling
05-29-2013, 11:38 PM
I haven't even opened it yet but wanted to say thanks anyways Steveo.

vNastIER
05-29-2013, 11:50 PM
def right. not the easiest to use. will try again lol. do i put the number of faction 5%s on bottom cell (factions max /6)

steveo127
05-29-2013, 11:52 PM
all you do is input the value for the number of ranks of the health regen upgrade that your faction has. if your faction has 4/6 you just put 4. if it has 6/6 you put 6.....etc.


does that help?
def right. not the easiest to use. will try again lol. do i put the number of faction 5%s on bottom cell (factions max /6)

vNastIER
05-29-2013, 11:53 PM
k. second try same as first. it seems as tho when I transfer between the URL and excel...the formulas do not transfer. still says 1:00
will post screenshot in a min

steveo127
05-29-2013, 11:54 PM
OMG. i see what you mean. i've got to correct that somehow...hmm...one second be right back.


k. second try same as first. it seems as tho when I transfer between the URL and excel...the formulas do not transfer. still says 1:00
will post screenshot in a min

steveo127
05-30-2013, 12:05 AM
all please try again, I believe it should be working now. sorry for the initial bug, but hey things never go perfectly the first time, right?

hope all goes well, please give feedback!

vNastIER
05-30-2013, 12:10 AM
3rd attempt start

Money. Dead on. Amazing work steveo127. A big thank you.
http://i40.tinypic.com/n5j6fd.jpg
http://i40.tinypic.com/n5j6fd.jpg

kind of hard to see but it says 8:13
this is much nicer to have than someone just rattling off a bunch of numbers that makes no sense to you.

psxnitro
05-30-2013, 12:23 AM
Works fine, you should have included another cell the highlights how many seconds per 1 health :)

steveo127
05-30-2013, 12:23 AM
LOL at everyone who just spent their time following those instructions, I'm so sorry, I feel like a fool. all you need to do is "Click on File (upper left of screen) then scroll down to "Download as" and choose "Microsoft Excel (.xlsx)"

sorry for all of the guinea pig trial runs vNastIER :)

but yes thank you that's the effect I'm hoping everyone will get from it, that they have concrete evidence to back them up and won't need to worry about other arguing individuals....

woo! finally that's over, ENJOY EVERYONE


Edit: noted psxnitro...that will be the first to come in tomorrow. all i need to do is update the googledoc then everyone can just click on it again and press download from the file drop down box again, and it'll be changed.


keep the suggestions in coming

vNastIER
05-30-2013, 12:29 AM
i have heard that the final health regen (6/6) only adds 2% or takes off a couple of seconds on the time.....is this true because if I plug 6/6 in my scenario, I lose about 25 seconds. We were wondering if the last regen bonus is worth buying???

steveo127
05-30-2013, 12:33 AM
the spreadsheet does not lie......
HOWEVER, even if you didn't believe in the math (which would be crazy, I double and triple and quadruple checked it, the spreadsheet is right) I have your same boosts! (I looked at your picture) and I can verify that my regen time is in fact 7:49, just like yours would be if you get the extra faction boost

is it worth the price? up to you



i have heard that the final health regen (6/6) only adds 2% or takes off a couple of seconds on the time.....is this true because if I plug 6/6 in my scenario, I lose about 25 seconds. We were wondering if the last regen bonus is worth buying???

vNastIER
05-30-2013, 12:38 AM
awesome. i fully trust the math. Math doesnt lie lol
I just wont believe what people with no solid eveidence tell others.

like you said...this is hard evidence and not just mendacious arguments

jon_funzio
05-30-2013, 02:30 AM
Hey steveo, good work.

It doesn't appear that you have taken into account any rounding which I suspect (anecdotally) that Gree may do. For example, when referring to the 26% maxed faction health boost:

1-((1-0.05)^6) = 0.2649...
Whilst Gree display this as 26%.

Based on this single piece of evidence I have always used a ROUNDUP formula in all of my calculations for BtB and WD health regeneration. We are talking a difference of a couple of seconds here, but that can be crucial in ensuring that you hit the boss with exactly 1 health, and not 0.99 (your poor little avatar will take a dive).

Cheers!

Mcdoc
05-30-2013, 02:30 AM
Hey - I'm no Dummy - and I truly appreciate all the work you put into it :)

Although - your spreadsheet shows me at 6:15 - but the game still shows me at 6:30.

It looks as if my 5% Curragh Combat Ship (which is actually a jet) is not working - as that was the last bonus I put in and that 5% when removed took me back to fluctuating between 6:26 & 6:30

DAMN those 15 seconds - LoL

GeoffW
05-30-2013, 03:43 AM
Nice little tool steveo127.

Having done quite a bit of calculation and measurement of my own I have found a quirk with the Deadly Bridge Jumper. The actual health bonus seems to be calculated as if it were 4 lots of 5% bonus rather than one of 20%.



Although - your spreadsheet shows me at 6:15 - but the game still shows me at 6:30.

It looks as if my 5% Curragh Combat Ship (which is actually a jet) is not working - as that was the last bonus I put in and that 5% when removed took me back to fluctuating between 6:26 & 6:30

DAMN those 15 seconds - LoL
Bonus items do not stack. In other words if you have multiple items you still only get the bonus once. This extends to items that are in the same item group. So perhaps you have another item that is in the same group as the Curragh Combat Ship.
http://www.funzio.com/forum/showthread.php?55280-GREE-Please-explain-boost-stacking&p=773198&viewfull=1#post773198



1-((1-0.05)^6) = 0.2649...
Whilst Gree display this as 26%.

Based on this single piece of evidence I have always used a ROUNDUP formula in all of my calculations for BtB and WD health regeneration. We are talking a difference of a couple of seconds here, but that can be crucial in ensuring that you hit the boss with exactly 1 health, and not 0.99 (your poor little avatar will take a dive).
The bonus displays are well know to have problems. What is displayed and what bonus is actually applied are two different things.

Miner
05-30-2013, 05:32 AM
Nice work steveo. Nice work!

Dutchie
05-30-2013, 06:06 AM
Hey - I'm no Dummy - and I truly appreciate all the work you put into it :)

Although - your spreadsheet shows me at 6:15 - but the game still shows me at 6:30.

It looks as if my 5% Curragh Combat Ship (which is actually a jet) is not working - as that was the last bonus I put in and that 5% when removed took me back to fluctuating between 6:26 & 6:30

DAMN those 15 seconds - LoL

Yes, the spreadsheet shows me 11:45 but the game still shows me at 12:00. If I take away 5% of the faction ranks (faction health regen bonus i.e. 5/6) it shows as 12:22, so I have no idea how GREE have come to this calculation of 12 mins that is clearly shown here -

http://i43.tinypic.com/igc775.jpg

Dutchie
05-30-2013, 06:08 AM
...Having done quite a bit of calculation and measurement of my own I have found a quirk with the Deadly Bridge Jumper. The actual health bonus seems to be calculated as if it were 4 lots of 5% bonus rather than one of 20%....


That sounds like a plausible explanation as to why we are missing those 15 seconds!

sledge 187
05-30-2013, 08:22 AM
The reason for the "missing seconds" is due to truncating after the 2nd decimal-correct formula is =TRUNC(1-(0.95^F8*G8*H8*I8*J8),2)
F8 = number of faction bonuses (1-6)
G8 thru J8 = unit regens (bridge jumper 20%) enter .8
If no unit then enter 1 or delete it
* Credit to Corsair for figuring this out http://www.funzio.com/forum/showthread.php?49782-How-to-calculate-health-regen/page4&highlight=health+regen+calculation

Web323
05-30-2013, 09:06 AM
Reserved for self-congratulatory praise


:o :) Good job Stephen! Thanks so much! :) :o

Good job......Now if only the energy regen units worked & the double unit for 20% regen

Generik79
05-30-2013, 09:21 AM
@Stephen: Suggest a column is added for listing the units that you are counting as health regen for each percentage. This way, when people update their SS down the road, they know which they've already counted and which they have not.

Also, with the "variable" unknown, on my player it can actually go to 19 or 20 seconds.

TW Turtle55555
05-30-2013, 09:54 AM
Nice work. Thank You!!!

atretes1
05-30-2013, 10:35 AM
Mine didn't turn out right maybe one of my 20% prizes was consider the same prize with a different name. Its close with one of my 20% taken away.

These are my 20% regen units in my bonus section anyone know why one of them would not be working?

Aggressor Tomcat
Armored Tomcat
Deadly Bridge Jumper
First Strike Tomcat

I have a max faction bonus and another 5%. It says it should be 5 something and its really 7 something.

sledge 187
05-30-2013, 10:57 AM
Mine didn't turn out right maybe one of my 20% prizes was consider the same prize with a different name. Its close with one of my 20% taken away.

These are my 20% regen units in my bonus section anyone know why one of them would not be working?

Aggressor Tomcat
Armored Tomcat
Deadly Bridge Jumper
First Strike Tomcat

I have a max faction bonus and another 5%. It says it should be 5 something and its really 7 something.

With what you described (4 - 20%) units (6 )faction bonuses and (1) extra 5% unit your time to regen 25 points should be 7min 16 sec? Is that what you see? If one of your 20% units is not working it would be 9 min

steveo127
05-30-2013, 11:47 AM
it would be 7:09, similar to what Sledge said. not sure what you're doing atretes1 ?


http://i1338.photobucket.com/albums/o683/steveo12794/ScreenShot2013-05-30at24955PM_zps03d90494.png (http://s1338.photobucket.com/user/steveo12794/media/ScreenShot2013-05-30at24955PM_zps03d90494.png.html)





With what you described (4 - 20%) units (6 )faction bonuses and (1) extra 5% unit your time to regen 25 points should be 7min 16 sec? Is that what you see? If one of your 20% units is not working it would be 9 min

atretes1
05-30-2013, 03:54 PM
Never mind guys figured it out. Thanks

Slick50
05-30-2013, 04:56 PM
Thank you Steveo! I can't wait for all the bonuses to start working properly so I can plug them in here.

StoryTimeSteve
06-02-2013, 11:14 AM
I have very...err...close connections with steveo127 guys, and he wanted me to post this, an updated version of the spreadsheet! it's not finished yet, so he says, although it's a pretty good improvement if i may say so!!!



same instructions as before, but a new link. here you go!!

https://docs.google.com/spreadsheet/ccc?key=0AmG4AV0ATN9NdGhiSXBFYmlJa2cxZktyMmllTXhJU lE#gid=0

D4DDY
06-02-2013, 11:28 AM
why did Gree give this person 99% health regen

http://modernwarforum.com/forum/index.php?topic=566.0

Riptide
06-02-2013, 02:19 PM
nice work brother. it really helps

Adm.J
06-02-2013, 02:54 PM
why did Gree give this person 99% health regenhttp://modernwarforum.com/forum/index.php?topic=566.0I use the 99% as well. It's just easier that way to figure out the regen to without having to put numbers into a spreadsheet.

warrends
06-07-2013, 05:58 AM
Great job Steve. As far as I can tell it works. Mine is simple:
- 2 X 20% unit boosts
- 30% faction bonus

Shows a total of 11:12, which, since we just upgraded our faction regen boost to 6 this morning I'll verify this afternoon when Madagascar begins. At (20% X 2) + 25% I was down to 12:22 or so. So the additional 5% to 11:12 sounds about right.

Great job.

DMJ
06-07-2013, 06:32 AM
steveo127, This is a great spreadsheet. Great job and thank you for your time and energy