Results 1 to 11 of 11

Thread: City Template

  1. #1
    I have one of these now Nominus Experse's Avatar
    Join Date
    Jun 2006
    Location
    Here
    Posts
    4,884

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




    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.
    Last edited by Nominus Experse; 10-31-2008 at 01:35 AM.
    ...

  2. #2
    o double d to the l e r oddler's Avatar
    Join Date
    Apr 2006
    Location
    Arshkabalzk
    Posts
    5,430

    FFXIV Character

    Kelesis Aleid (Phoenix)

    Default

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

  3. #3
    I have one of these now Nominus Experse's Avatar
    Join Date
    Jun 2006
    Location
    Here
    Posts
    4,884

    Default

    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.
    Last edited by Nominus Experse; 12-07-2007 at 09:40 AM. Reason: Revision
    ...

  4. #4
    Selena_Akariko's Avatar
    Join Date
    Nov 2006
    Location
    I live in Russia ^^
    Posts
    407

    Default

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

    Selena


    http://clairvoyance.game-server.cc/nc_catastrophe.html
    Click the link to see the best flash movie EVER

  5. #5
    I have one of these now Nominus Experse's Avatar
    Join Date
    Jun 2006
    Location
    Here
    Posts
    4,884

    Default

    Quote Originally Posted by Selena_Akariko View Post
    Um... I'm not very used to using Excel... How exactly do you change the number of soliders?

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

  6. #6
    diafnaoplzkthnxbai NeoTifa's Avatar
    Join Date
    Jun 2005
    Location
    in psy's panties <3
    Posts
    3,411

    Default

    can you use notepad or something cuz i cant open it
    Oh gods, why? ಥ_ಥ


  7. #7
    I have one of these now Nominus Experse's Avatar
    Join Date
    Jun 2006
    Location
    Here
    Posts
    4,884

    Default

    Quote Originally Posted by NeoTifa View Post
    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.
    ...

  8. #8
    Newbie Administrator Loony BoB's Avatar
    Join Date
    Aug 2000
    Posts
    52,025
    Articles
    53
    Blog Entries
    19

    FFXIV Character

    Loony Bob (Sargatanas)

    Default

    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.
    Bow before the mighty Javoo!

  9. #9
    FullMetal Dope XD ~ Hot ~ rayquaza0's Avatar
    Join Date
    Apr 2006
    Location
    I am your neighbour
    Posts
    87

    Default ?

    EDIT: nvm fixed my prob, great template!
    Last edited by rayquaza0; 01-14-2008 at 04:45 AM.

  10. #10
    I have one of these now Nominus Experse's Avatar
    Join Date
    Jun 2006
    Location
    Here
    Posts
    4,884

    Default

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

  11. #11

    Default

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •