Announcement

Collapse
No announcement yet.

Building Upgrade Spreadsheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Agamemnon999
    started a topic Building Upgrade Spreadsheet

    Building Upgrade Spreadsheet

    Everyone, I thought I would share an Excel spreadsheet that can be used to calculate resources and time needed to complete your building upgrades in Dominations. I didn't create this from scratch but used one that someone built for Clash of Clans and modified it for this game. It's not perfect but should be pretty close. Most values were taken off of the Dominations Wiki for hp and damage.

    Things to be aware of - I used the concept of citizen days to get to a common value for build time. So a trap may be 2 citizen days (1 citizen x 2 days) and a mill would be 8 citizen days (4 citizens x 2 days). You can't have 8 people work on the mill at once so the build time may not work great at lower ages but in higher ones where there is so much to do, I think it works good enough to give you a sense of how long it will take to max a base out.

    Also, I did not try to deal with differences in Nations, research, damage modifiers, etc. Too much work for what I was looking for. I did assume the max buildings per age even if that required research to be completed. So if you are wondering why the xls has slots for more oil wells than you can build, that would be why.

    I left Wonders and houses off. For no real reason other than I already built them. If people are really interested, maybe I or someone can add them in. It wouldn't take long.

    I'm sure I took other liberties in building the thing out that I can't remember, so with that...

    The spreadsheet is here - http://s000.tinyupload.com/?file_id=98912963245033219163

    It's only about 200k, so quite small though the formula calculation is slow if you use it. If someone wants to repost it somewhere more useful feel free.

    I'm sure I will be asked about adding library, armory, and university options and maybe if I get real bored I might, but not anytime soon. I'm happy to try to answer questions people have when I have time.

    I hope some people find this useful. I know I did once I realized that I need over 6110 citizen days to max out my Atomic Age base! If I used all 17 of my citizens non-stop they would finish 360 days from now.

    Have fun!!

    -Agamemnon

  • pckrn
    replied
    Originally posted by tinsoldier
    Took it down before so the stickies were all thematically linked. Happy to put it back up!
    maybe you could have 1 sticky post that links to all the other useful posts.

    Leave a comment:


  • TinSoldier
    commented on 's reply
    Took it down before so the stickies were all thematically linked. Happy to put it back up!

  • bugalho
    replied
    Hopefully this will work - at lest it worked for my alliance members and I PM the wrathchild_78 which helped me testing it, and it worked. Again, thank you wrathchild_78 .

    https://1drv.ms/x/s!AnTnlGwEXC-lukVZR1_vqudIYCj5

    Let me know if you find any bugs or if you have any improvements that you would like to see in a future version.

    As a final note: I based my values on what is on the wiki, so not all levels are there for all the buildings and others may be wrong. I am only on GA so can only check those. If anyone find a the values are wrong just let me know so that I can correct. Also for Sally Ride I only have what is on the wiki, so Sally is not complete yet. However the logic behind it is already there it is just a matter os updating tables, which takes only a few minutes to update as long as one have the values to fill the table in.

    Leave a comment:


  • wrathchild_78
    commented on 's reply
    nope. it says file is missing or moved.

  • bugalho
    replied
    Sure I can. Can you try again?

    https://onedrive.live.com/edit.aspx?...7201&app=Excel


    Leave a comment:


  • wrathchild_78
    replied
    thanks for your dedication to create this. Can you post the link again cause it doesn't work

    Leave a comment:


  • bugalho
    replied
    TinSoldier can you stick this post again? I lost some time to find it again, and I think this will be very useful for a lot of people.

    Leave a comment:


  • bugalho
    replied
    Hi fellow Dominators.

    First of all I would like to apologize for the long waiting - you are used to be waiting anyway, due to the long upgrade times .

    I have been busy at work, and in my personal life, so didn't have much time to dedicate to this project. However in my idle times I did work on this, and today I am pleased to share with you the first final result from my upgrade spreadsheet. I would say this is a final version, unless new building, levels , university leaders and so on are added, but those are maintenance actions. The logic of the worksheet is already implemented and any new additions should be easy to update.

    What I am missing but don't see it as a priority:
    - to add bonus from the university and library to defensive building and troops.
    - to add bonus for economic production like caravans, farms and oils wells
    - to add HP bonus for buildings coming from the library and university

    This may be implemented in the future, but it is not a must, and doesn't affect purpose of the workbook.

    So here it goes - I added an user manual tab also. Hope this proves useful to you as it has been useful to me so far. Also, if you have any suggestions, they are more than welcome.

    Leave a comment:


  • zumbul
    replied
    Originally posted by ademirk View Post
    Agamemnon999 , your spreadsheet is no more available at the link. Can you share another link?
    This is the latest link, as posted by Bughalo: https://onedrive.live.com/view.aspx?...LmjX3dMO9tbe98

    Leave a comment:


  • ademirk
    replied
    Agamemnon999 , your spreadsheet is no more available at the link. Can you share another link?

    Leave a comment:


  • Giuseppe Lo Bue
    commented on 's reply
    the age relating to the cold war is missing

  • wrathchild_78
    replied
    well that sounds interesting. Why don't you upload it here and share it with us?

    Leave a comment:


  • CCC FRANCE**
    replied
    Really impressed by the quality and the lay out of this spreadsheet. Well done guys. I'm also maintaining a personnal spreadsheet. Here some ideas to develop yours :

    1/ In all sheets I have a targetted level (input field) next to the maximum level. Aim is to compute time for the next level for the things that I'm ready to develop, not up to the maximal target. Then I have a dashboard showing time left for buildings, library, leaders, troops, ... with some nice graphs. Here time review to next level is still missing for library, walls and leaders, Library slots field is still missing.
    2/ For HP & DPS, Production rate or stockage, I have the current absolute figures (to allow a fast check with the app).
    3/ I have also a tatics tree, a coalition tree, an alliance tree, a nation tree, a museum tree and a wonders tree.

    But nevertheless, a big positive feed back :-)

    Leave a comment:


  • bugalho
    replied
    Hi everyone,

    So here is a new version of the sheet with the library chapters added. Still some things missing, but I think some improvements have been made since the last version.

    Once again, would appreciate positive criticism to this, as well as any additional/missing data.

    Leave a comment:

Working...
X