Showing results 1 to 11 of 11
  1. #1

    Pfeil Ultimate SimCity Tool

    This evolved out of an old planner I made. You'll need a program that can read .xls files. If you don't have one, you can download open office for free.

    Download the Ultimate SimCity Tool

    When using the construction planner, be sure to set the speed of the world you’re planning for (cell C3) and the building levels the village already has (cells AS7 through BJ7).

    I color-coded the fields.
    *yellow: must be filled out to get information about the current construction assignment
    *orange: Things you can change
    *grey: Calculated information that you shouldn’t change


    Explanation of Fields

    Construction Assignment
    -[queue]: the slot in the queue that the construction will be added to. Adding more than 3 constructions to the queue makes your buildings more expensive.
    -[next building]: the name of the building you want to construct.
    -[upgrade to level]: the level you want to upgrade the building to.

    Time
    -[duration of construction]: The amount of time it will take to construct the assigned building.
    -[current time]: The time that the previous assignment will finish being constructed (relative to the starting time)
    -[begin construction at]: The time that you want to begin constructing the assigned building (relative to the starting time). By default, this is set to equal the time when you’ll have enough resources to start the construction.

    Cost
    -[timber]: The amount of timber it will cost to construct the building
    -[clay]: The amount of clay it will cost to construct the building
    -[iron]: The amount of iron it will cost to construct the building
    -[total]: The total amount of resources it will cost to construct the building

    Cost/time (the default measure of time for this is 1 hour)
    -[timber]: The average cost of timber per time, for this construction
    -[clay]: The average cost of clay per time, for this construction
    -[iron]: The average cost of iron per time, for this construction
    -[total]: The average total cost of all resources per time, for this construction

    Stored resources
    -[timber]: The amount of timber stored in the warehouse before the construction
    -[clay]: The amount of clay stored in the warehouse before the construction
    -[iron]: The amount of iron stored in the warehouse before the construction

    Resources produced per hour
    -[timber]: The amount of timber produced by the timber camp per hour
    -[clay]: The amount of clay produced by the clay pit per hour
    -[iron]: The amount of iron produced by the iron mine per hour

    Other income (per hour estimate)
    -[timber]: The amount of timber you predict to make per hour, from pillaging and/or trade
    -[clay]: The amount of clay you predict to make per hour, from pillaging and/or trade
    -[iron]: The amount of iron you predict to make per hour, from pillaging and/or trade


    Total income per hour
    -[timber]: The total amount of timber you make per hour
    -[clay]: The total amount of clay you make per hour
    -[iron]: The total amount of iron you make each hour

    Waiting for resources
    -[timber available in]: The time it takes to get enough timber to construct this building
    -[timber available in]: The time it takes to get enough clay to construct this building
    -[timber available in]: The time it takes to get enough iron to construct this building
    -[ready in]: The time it takes to get enough of all resources to construct this building

    Population
    -[max]: The maximum amount of villagers the current farm will support.
    -[used]: The amount of villagers that are already used.
    -[available]: The amount of villagers that are available.
    -[will use]: The amount of villagers that this construction will use.

    Units that could be trained in the time it takes to construct this building
    This section tells how many of each unit you could train in the time it takes to complete the assigned construction.

    Building Levels
    These are the levels of your buildings before the construction.

    Population Breakdown
    This tells how many villagers each building uses before the construction.

    Warehouse Capacity
    This is the capacity of the warehouse before the construction.

    Queue
    [cost modifier] This modifies the cost of the construction based on it's queue number.
    Last edited by cheesasaurus : 2009,March 1st at 08:19
    [08:53:05] cheesasaurus: on a side note I have 76% of the hc in the world
    [08:53:16] Nauzhror: cool nauzh, thanks for sharing

  2. #2

    Default

    I just noticed that the hq modifier is off, so the construction times are wrong. I should have it fixed as soon as I get off work (should be within 9 hours).

    -edit: fixed it
    Last edited by cheesasaurus : 2008,November 8th at 07:55
    [08:53:05] cheesasaurus: on a side note I have 76% of the hc in the world
    [08:53:16] Nauzhror: cool nauzh, thanks for sharing

  3. #3

    Default

    Can you go into more detail about exactly what it does?

  4. #4

    Default

    alright, should be fixed now.

    Quote Originally Posted by ntoombs19
    Can you go into more detail about exactly what it does?
    It's a tool to help you plan a village's progress. Basically, you type in buildings in the order you want to build them, and it will calculate the following for each one:
    Spoiler:
    [08:53:05] cheesasaurus: on a side note I have 76% of the hc in the world
    [08:53:16] Nauzhror: cool nauzh, thanks for sharing

  5. #5

    Default

    Nice idea Will have a look later..
    Proud to be OB | DNS (W9) .WAR. (W51)
    Persona

  6. #6

    Default

    I thought me and Aaron were special :O

    ahh well easy access to explanation now :D <3

    Not member of POKE.------------------Hai der.

  7. #7

    Default

    I added churches to the planner and fixed all known problems:

    *cost of statue is now correct

    *"Units that could be trained in the time it takes to construct this building"
    -All units are now built in the correct buildings.

    The new version can be downloaded here.
    [08:53:05] cheesasaurus: on a side note I have 76% of the hc in the world
    [08:53:16] Nauzhror: cool nauzh, thanks for sharing

  8. #8

    Co-community manager
    allyboo's Avatar
    Join Date
    2007,August 5th
    Location
    Hamburg, Germany
    Posts
    2,157

    Default

    Oh this looks interesting. Never used anything like this before... I'll have a play about with it later. Thanks
    zomgtw.net - farmfinder, player/tribe achievements & other stuff
    InnoGames

  9. #9

    Default

    i love this tool... i build troops, but this tool is very useful, thanks

  10. #10
    witheringxuponxlove's Avatar
    Join Date
    2007,August 27th
    Location
    Australia
    Posts
    1,249

    Default

    I was working on a similar 'tool' a few weeks ago.

    It is still incomplete as of this moment, but I'm going to release an early prototype as a sort of beta test...

    Download

    Screenshots:






    Note: The startup manager assumes 100% efficiency in adding items to their queues. It also allows for you to make use of resources you don't actually have - so be careful that you're mindful of how much you're actually planning on using (future editions will have integrated farming income and it should be able to work out exactly when everything is able to be queued - instead of assuming it's always possible without delay).


    In addition to this, there is a Farm Calculator:

    Download

    The farm calculator basically works by showing you every village sorted by the distance it is from your village.

    Then, it looks at the points of the village and decides how much the village can produce (not an entirely accurate method).

    It then tells you how often you need to send x LC to each village.

    If executed correctly, under ideal conditions, this will leave your farms as dry as possible without wasting time sending troops to villages they won't get a full haul from.

    With growing barbs, this spreadsheet & the world data must be updated frequently.



    Both are extremely useful during the first few weeks/months of any world, even if you just want to work out a strategy before playing the world.

  11. #11
    xshahzad's Avatar
    Join Date
    2010,December 6th
    Location
    world
    Posts
    1,511

    Default

    Is there any tool other than this to calculate the construction planner. Need to do calculations for W56.

    Also is there a new version for this as well.

Posting Rules

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