City Template

This is a city template I've created that might prove useful for when you wish to either create or edit your existing cities. As far as I can tell, the template is accurate, but being human, I've likely made some mistakes.

If you happen to find any, simply post here or PM me detailing the issue.



Anyway, I hope you enjoy.

:tonberry:


NOTE: I realize that there are many values already present in the spreadsheet; however, these are here so that if the comments are not as useful as I thought them to be, you might be able to see how the values are strung together through example.
UPDATED SPREADSHEET
UPLOADED REVISED EDITION
UPLOADED REVISED, CORRECT VERSION. USE THIS ONE.

Bravo, NE. That's definitely a simple and effective way to get an overall idea of a city. :up:

I found that I had forgotten to include the fishing, caravan routes, planned housing, and police proficiency training fields.

These can now be found in the spreadsheet.

==========================================================================

EDIT:

I've revised the spreadsheet so that it's more flexible to how exactly you wish to arm your military forces. I have also cleaned up various parts of the spreadsheet, so that it might be easier to read and understand.

Such a sheet is available in the first post.

Um... I'm not very used to using Excel... How exactly do you change the number of soliders?

:save: Selena

Quote:

---

Originally Posted by Selena_Akariko

Um... I'm not very used to using Excel... How exactly do you change the number of soliders?

:save: Selena

---

To change a value in anything, simply click the cell (the box), and then enter in a number. Armenent costs and whatnot ought to be calculated automatically.

can you use notepad or something cuz i cant open it

Quote:

---

Originally Posted by NeoTifa

can you use notepad or something cuz i cant open it

---

OpenOffice.org: Home

Also, I'll soon be uploading a revised spreadsheet containing notes on how to enter in everything, for those of whom are confused.

I noticed you've neglected both light cavalry and archers in the garrison area, at least in the regard of calculating the recruitment cost of all soldiers.

EDIT: Also, you double the cost of military training - it's an extra gil per soldier, not 2 gil.

EDIT: nvm fixed my prob, great template!

Updated spreadsheet!

• Revamped completely in order to be more accurate and comprehensive.
• Much more intuitive layout.
• More options, including TRUE//FALSE statements.
• Comments are given throughout spreadsheet. READ these.
  
  
• There are only a few instances where you must make the calculations manually (Number of keep walls and their costs, and the research facility technology level advancement costs). All else is automatic - you need only enter in values.

also, the spreadsheet doesnt allow for soldiers with both heavy weapons and heavy armor