My version seems to be under the actual value by 10% or so.
My version seems to be under the actual value by 10% or so.
I got it from the legends old website like 3 years ago...I think there might be a link in the forums somewhere.
EDIT: http://forums.nation-wars.com/showthread.php?t=2051
My excel worksheet:
http://www.upload.ee/files/2358998/n...acro.xlsx.html
Includes:
- Grab calculator (inaccurate, if you know the correct formula, then let me know)
- Battle calculator (quickly copy/paste as text enemy espionage into A1 cell)
- War calculator - BR calculator, AA calculator, Genocide calculator, Population calculator, Land calculator
- Economy - Indy, casher, techer production (thanks to ang101 and the legends calc).
Includes small tips how to use the file. If something is too vague, ask here.
I have been using the copy/paste function for like 2-3 months, I can't imagine going back to calculating break amounts in head/calculator any more. Calculating it in head may be even faster, but the risk of failing is greater and you don't get as accurate result as with this excel - reduced readyness loss.
***Make sure you copy enemy espionage FROM SAVED INTELS. There, the intel doesnt consist of different names for each unit upgrade level, therefor it's easily usable in excel.
Things to do:
Farmer production
GA calculator
copy/paste vol 2.0 -> copy enemy overview.
good stuff there blaa nice work
*yoink* I had just been wondering if anyone had updated something like this recently.
EoS
Resounding echoes in the silence after the storm
In emptiness flutters by, the pretty white butterfly
my first official kill =^.^= nom nom nom! tasty!
You have killed strawberry panties(#305)
You have killed huh(#310)
17 May '12 You have killed Good Morning Vietnam(#720) - #1 state
11 June '12 You have killed steeler nation(#78)
8 July '12 You have killed A friend of Blaa(#718)
15 Aug '12 You have killed namibia(#70)
Version 2:
http://www.upload.ee/files/2401815/n...c_v2.xlsm.html
Added:
*Farmer production formula
*Advanced GA calculator: shows the regression of infantry after 20 AAs and regression of infantry while performing GAs.
Things to do:
copy/paste vol 2.0 -> copy enemy overview.
?
Version 3 (uploaded to permanent host now, old host deleted file after some time):
http://www.hot.ee/aeuio//nwcalc_v3_macro.xlsm
Added:
*Since the introduction of the new spy random, it became obvious that there will always be states that you can not break with spies. But you can see enemies networth, you know how much land he's got, how many spies he MUST have, so you can calculate how much infantry is required to break in SA. Note that this only applies if enemy has only spies and infantry, so you actually need to send less infantry. This tool is found in 'Random' page.
*Cleaned the workpage a bit, hid the unnecessary pages.
No macro free version, this means that you will be asked, each time you start the workpage, if you want to allow macros. I used macros for 2 buttons so they delete everything from the 'Your army' boxes. So it's not necessary at all to allow macros.
Since my set is over this month, I'll do some random stuff and probably come up with new things to add for the next version. I was thinking to find out the exact land grab formula and finding out how much army you'll lose in an attack.
Is anybody even using this? Is it difficult to use/get used to?
Last edited by SkyCat; 11-22-2012 at 19:49.
pohjakiht[KIHT]; domination[EE]
I was declared a cheater in Nation-Wars!!! @ welcome to the DARK SIDE
NEVER STOP
LIFT THE BAN ON POSTING STATE NUMBERS IN THE FORUMS