Calculator

[jasonlfunk]

My version seems to be under the actual value by 10% or so.

[Divine Intervention]

Yeah I always get alot less than what it says too.

Ive been using the old calc and it works just fine, +/- 5 land at the most

link?

[Crimson Shadow]

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

[blaa]

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.

[MellonColly]

good stuff there blaa nice work

[p-kitty]

*yoink* I had just been wondering if anyone had updated something like this recently.

[blaa]

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

[blaa]

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?

[Divine Intervention]

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?

i used your old ones for war calculations (# of BR / GA) and land grabs. i still do army break calculations on my own though.

[SkyCat]

(click image to see better reso)

made a little landcalc for android (seen in my galaxy s3), but its ugly as ****, if i can find some effort to make it bit more nice maybe will add it up to google play if anyone intrested!