Military Organizer Spreadsheet

Xsinthis

Ebil Kitteh Fusion

Date of registration: Mar 19th 2008

Posts: 1,376

Gender: male

Location: Somewhere......

Friday, April 24th 2009, 8:55pm

Military Organizer Spreadsheet

Introducing my Military Organizer Spreadsheet for Ikariam. This nifty little organizational device will display the total of each type of unit is costing you, the sub total for your navy upkeep and military upkeep, and the grand total for them both. These calculations are correct within +0.7%.

Also arrayed across the bottom is the attack and defence stats for your army and navy in each town as if they were defending the town. This means Resistance is taken into affect and for land troops the wall bonus.

However, for any of these to work properly the data must be entered correctly

1.) Fill in how many of each units you have in each town.

2.) Fill in the level of upgrade you have for each unit(0=none,1=bronze,2=silver,3=gold) and each attack and defence.

3.) Enter how many upkeep reducing researches you have. For Military they are:
0 = None
1 = Maps
2 = Code of Honour
3 = Logistics
4-6 = Military Future 1-3

For seafaring they are:
0 = None
1 = Ship maintenance
2 = Pitch
3 = Sea maps
4-6 = Seafaring Future 1-3

Here is the link to the original, made with Excel 2007: http://dl.getdropbox.com/u/194690/Military-Organizer.xlsx

Here is the link for a version saved in compatibility mode for people with older versions of excel or other worksheet handlers: http://dl.getdropbox.com/u/194690/Military-Organizer.xls

For those who like it if you could send me your numbers of what the sheet says your upkeep should be and what the game says, I would much appreciate it as i want to make sure that the variances is the same(or better) than of my test group.

Speaking of that i would like to thank Glenwing, braddley, Ignomis and Large Panda for their help.(If i've forgotten anyone poke me and i'll add you)

Xsinthis

Ebil Kitteh Fusion

Date of registration: Mar 19th 2008

Posts: 1,376

Gender: male

Location: Somewhere......

Sunday, April 26th 2009, 1:22am

Update:

Changed the upkeep formula's so it should be perfectly accurate now. Many thanks to iggy and CactiFantastico for help with this

Sunfighter

Newcomer

Date of registration: Apr 20th 2009

Posts: 24

Birthday: Dec 23rd

Gender: male

Location: South central Missouri

Occupation: chef

Sunday, May 3rd 2009, 4:51pm

I down loaded from http://dl.getdropbox.com/u/194690/Military-Organizer.xlsx and tried to open in microsoft works. Was told it is password protected. Could you check that.

CactiFantastico

Mayor

Date of registration: Feb 27th 2008

Posts: 203

Birthday: Dec 17th 1986 (23)

Gender: male

Location: Cambridge, UK

Sunday, May 3rd 2009, 5:17pm

what version of works is it?

Xsinthis saved the spreadsheet in Excel 2007 (?) mode, its unlikely that older versions of excel or works will be able to read it properly. (i could be wrong though)

If he re-saves it in compatibility mode you should be good to go.

Xsinthis

Ebil Kitteh Fusion

Date of registration: Mar 19th 2008

Posts: 1,376

Gender: male

Location: Somewhere......

Sunday, May 3rd 2009, 5:27pm

I saved it in two modes. One for 2007 and one for 98-2003. Try downloading that one. Also, the password protect is only on certain formula's. Shouldn't keep you from using the actual sheet

The Shrike

Citizen

Date of registration: Apr 4th 2009

Posts: 97

Location: The darker side of TP-K

Sunday, May 17th 2009, 12:06am

Thank you !
Keep up the good job :respect:

"Impossibly tall, four-armed, molded in chrome and cartilage, the Shrike turned its red gaze on us"

Tp-k Colonel
Representing the dark side

Dionysas

Governor

Date of registration: Mar 30th 2009

Posts: 367

Birthday: Jan 15th

Gender: male

Location: A small island in Iota

Occupation: Pillager

Sunday, May 17th 2009, 2:44am

Thx for the Spreadsheet

I hav an atk calc but din hav the def calc good job man

BTW add that usage manual that u posted at the top into the sheet. That wud b best

Server: Iota, IGN Dionysas, Alliance AOD

Noob !!! Warrior >>> Warrior Elite <<< Loudmouth @_@ An******st Hmmmmm Farmer ^_^ ....... Faust ......

As you can see I am the reason the HS in AOD has a job

For those I Pillaged - QUOTED FOR TRUTH

This post has been edited 1 times, last edit by "Dionysas" (May 17th 2009, 2:54am)

Xsinthis

Ebil Kitteh Fusion

Date of registration: Mar 19th 2008

Posts: 1,376

Gender: male

Location: Somewhere......

Wednesday, May 20th 2009, 11:30pm

Quoted from "Dionysas"

BTW add that usage manual that u posted at the top into the sheet. That wud b best

that would be kinda hard to do on a spreadsheet tbh...but i'll see

Jhuatz

Newcomer

Date of registration: Jun 4th 2009

Posts: 15

Friday, June 5th 2009, 9:26am

3.) Enter how many upkeep reducing researches you have. For Military they are:
0 = None
1 = Maps
2 = Code of Honour
3 = Logistics
4-6 = Military Future 1-3

For seafaring they are:
0 = None
1 = Ship maintenance
2 = Pitch
3 = Sea maps
4-6 = Seafaring Future 1-3

what does that means?? i dont really understand.. what should i put in the spreadsheet for the researches??