assistance spreadsheet

I have been working a spreadsheet that can help us with our armies and farms. I have entitled it FTS (FarmTroopSheet). I know not a very imaginative name but it does the trick

Below is a synopsis of the sheet. If you have any issues with it or would like me to add something please either post on this thread or send me an in game message.

Sheet 1: Titled FarmAttack:
Farms;
Here you can list all your farms including information such as;
Player name, Village name, Alliance, Population, No. of villages, x & y coordinates etc.

Alliance Targets;
Here you can list all the targets given to by your wing leader. The column headings are the same here as for your farms.

Sheet 2: Titled Teuton Army:

This sheet is to detail your army. The first section list all troops types relating to Teutons and there requirements such as;
Troop name, Training time, Lumber required, Clay required, Iron required, Crop required, Upkeep cost and Speed (fields per hour).

Also listed here is a training chart:

This is designed to help with creating your army. You enter the number of troops you want next to the troop type and it works out how much of each resource you need and training time.
There is also a Total shown at the bottom which will calculate total resource required and total training time.

Also Listed here is a Current Army chart:

This will show you your current army and upkeep. You simply enter how many of each troop type you have and the TOTAL will change at the bottom to show how many troops are in your army and the total crop upkeep of them.

Sheet 3&4: Gaul & Roman Army:

The 3rd and 4th sheets are the same as sheet 2 except they are for the Gaul and Roman army.

You can delete one of last 3 sheets depending on which tribe you are. So if you are Teuton you can delete the Gaul and Roman Army sheets and vice versa for all tribes.

*NOTE: The times in the sheets are set to barrack/stable level 1.
To change them simply change the times in the brackets.
E.G.

Training 1 clubswinger = default time 00:15:00 so the equation is
=SUM(B15*TIME(0;15;0))
If you have a level 4 barrack the training time is 0:10:56 so the equation should read
=SUM(B15*TIME(0;10;56))

Again post here or send me an in game message if you have troubles.

Screenshots;

https://2img.net/h/i46.photobucket.com/albums/f110/TheDoctorS3/FTS1.jpg

https://2img.net/h/i46.photobucket.com/albums/f110/TheDoctorS3/FTSg.jpg

https://2img.net/h/i46.photobucket.com/albums/f110/TheDoctorS3/FTSr.jpg.

https://2img.net/h/i46.photobucket.com/albums/f110/TheDoctorS3/FTSt.jpg

Download Locations;

Format:.........................Location:
OpenOffice ....................http://rapidshare.com/files/134101632/FTS.ods.html

MS Excel (97/2000/XP).....http://rapidshare.com/files/134101793/FTS.xls.html