Ikariam Library > Army Calculator Spreadsheet

Army Calculator Spreadsheet

Download Spreadsheet armycalcblank.zip
Total unique downloads: 11,972

Page 1

Description:

The purpose of the first page is for the main section to be filled in and saved and adjusted as needed so as to keep a personal reference to monitor the defense capabilities of each of your towns, your generals score and upkeep with each proposed change in military units. The second section allows you to assess the costs of your intended military expansion and will indicate how much generals score you will gain and how much your upkeep will rise as a result.

Features

Monitor the current and potential defense capabilities of your individual towns.
Assess the costs and benefits of expanding your army.
Incorporates upkeep reductions from research.
Takes into account wall bonuses, workshop upgrades and defense bonus from the resistance ability.

Instructions

Instructions are given within the document but here is a rundown:

Fill in all sections shaded in yellow where neccesary.
Do not change numbers in squares not shaded yellow.
Fill in the wokshop upgrades with numbers 0-3 depending on the number of upgrades you have achieved for that unit.
In the research section put a 1 in the shaded square next to your highest level of research for each tree and a 0 in the rest.
Upkeep adjustments from research are only calculated in the total upkeep not the upkeep for each unit (sorry for any inconvenience)

Page 2

Second Page
Click for full size.

Description

The purpose of this page is to give you an estimate of your oppositions defense prior to a battle taking place to to allow you to send an appropriately sized army. Or if you wish to calculate the defense of your own town to assess the minimum army size required to pillage you (worst case scenarios). If you have an idea of the structure of an attack heading your way you can use this to assess the likelyhood of the attack being successful.

Features

Calculate the army size neccessary to pillage a defended town.
Compare the defense capabilities of your town to a variety of attacking forces.
Calculate for fun the strength of your entire army defending or attacking.
Calculate the amount of gold you stand to gain or lose from an attack.
Incorporates breech bonuses (if maximum breeches) for all seige units and spies.
Incorporates workshop upgrades for your armies and known or worst case scenario for you enemy.
Can be used to calculate the number of workshop upgrades an enemy has from combat report information.
Asses the number of units necessary to have a battle last more than one round ;).

Instructions:

Instructions for page two are basically the same as that for page one simply fill out all sections shaded in yellow.

Tool Comments

Comments and issues should be posted on the Forum Thread

Subject: Re: Army Calculator Spreadsheet

Hello from Greece!

I downloaded today the Army Calculator Spreadsheet and started using it.

First of all, I would like to thank the author of this spreadsheet for his/her effort.

I have noticed some mistakes. (???)

I entered the details for one of my cities(Wall level = 20, Phalanx = 119) and I noticed that the Town Base Def. Value (without workshop upgrades)
number is not correct.

I looked at the cell formulas and I saw that the Phalanx contributes to the Town Base Def. Value by the following factor (C11*40*1.3)

C11 is the number of Phalanxes. I guess that 1.3 is the 30% defense bonus and 40 is the basic defensive ability of the Phalanx.
However, it's not 40 but 30.

Additionally, I noticed the same mistake for the defensive capability of the Swordsman. Instead of 11, 14 is used.
(C10*14)

I think that the basic defense of the Phalanx was also 30 in the 0.2.8 version but the Swordsman defense was indeed 14 and not 11.
Maybe the spreadsheet is not updated, not even for version 0.2.8?

regards
Nick

by, renegade at 2009-04-22 08:40:44

Subject: Re: Army Calculator Spreadsheet

Sorry; I forgot to reply to this, there was an issue with the download link. However it was resolved after a few minutes of it being pointed out.

Additionally, I have archived the XLS into a ZIP for faster downloads.

by, immortalnights at 2008-07-18 11:04:03

Subject: Re: Army Calculator Spreadsheet

are you sure it appears to work when i tried to download it to be sure

by, Leele at 2008-07-18 10:46:44

Subject: Re: Army Calculator Spreadsheet

Link is bad: ends with .xls.htm which fails.

by, BigBen2k at 2008-07-04 13:49:15

Subject: Army Calculator Spreadsheet

Army Calculator Spreadsheet, by leele.

URL:
http://ikariamlibrary.com/?content=Army ... preadsheet

by, immortalnights at 2008-07-02 11:42:07