Announcement

Collapse

Bookmark the new forum URL!

Reminder! We have changed the URL of the DomiNations forums to https://forums.bighugegames.com/ Be sure to update your browser's bookmarks today!
See more
See less

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

    ******* UPDATE: 13 February 2020 - latest link available to the world ********

    https://docs.google.com/spreadsheets...it?usp=sharing

    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
    Last edited by Agamemnon999; 02-13-2020, 08:16 AM. Reason: Updated link information and removed old links

  • wrathchild_78
    replied
    thanks mate! great work! As for traps, i have no idea cause mine are cwa/sa level

    Leave a comment:


  • Agamemnon999
    replied
    OK, everyone I went through this thread and removed all old links as I kept getting access requests on old versions. Hopefully it should make it easier for people to know which is the latest version. I am trying to not post any new links, I am just updating the most recent version available to the world. Hope this helps avoid confusion.

    Dimun , I fixed the shipyard. As for the university issues can you be more specific? They should accurately reflect the number of levels needed to complete. The resource costs and time may be off as the wiki is sparse for new leaders, but the number of levels should be accurate.

    As for trap upgrades (or any upgrades to Digital Age generally), the primary issue there is data. As I am currently Space Age, I don't have complete resource cost or duration requirements for Digital Age. If you can supply any of that (or anyone at BHG if interested), I am happy to keep the template up to date. For example, in the last few days I have updated Harriet resource and duration costs as I learn them. I don't post updates on the forum when I do them, but just know that as I get information and I have time, I try to update the template.

    Let me know if anyone has any other feedback.

    Aga

    Leave a comment:


  • Dimun
    commented on 's reply
    Hey bro,

    thanks a lot for all the work, but for whatever reason you have the shipyard max level set to 12 - but currently the max is 11:
    https://dominations.fandom.com/wiki/Shipyard

    Also the university research sheet is showing all researches as 5 - regardless if it's a 10 level research or 1

    Additionally - if I put in my traps as upgraded to SA it doesn't calculate the values for DA upgrades
    Last edited by Dimun; 02-05-2020, 04:03 AM. Reason: tested a bit more

  • W1ll1am
    commented on 's reply
    Thank you, very nice.

  • Agamemnon999
    commented on 's reply
    So the Google Sheets is view only which allows anyone to make a copy of it to their own accounts. Once you do that, it will be editable. From there, you can enter your age (their is a legend further down on the Building tab) and it allows you to update your buildings levels available at that age. Their are tabs for University research and the library as well which will help unlock more building spaces as well as help calculate time and resource discounts.

    The point of this is to get a sense of how many more upgrades you need, how long it will take, etc. Helpful if you are a little obsessive.

    If you need more help figuring out how to use it just post your questions. Someone will answer them.

  • W1ll1am
    replied
    Can someone explain to me how this works, I can't input anything as mine says view only.

    Leave a comment:


  • Agamemnon999
    replied
    Everyone, here is the latest template. Unfortunately I had to remove the old shared template and create a new shareable link as I had way to many changes to make from my master copy.

    List of improvements:
    • Digital Age Armored Ambush Trap added
    • Library Research tab added
    • Wonders added
    • Cost and Time discounts from Wonders, Library, and University now auto-calculate based on completion levels
    • Number of buildings available to build auto-calculates based on research completed
    • Fixed bad calculations of trap upgrade time discounts based on Harriet Tubman research
    I will try to just update this template in the future and not post a new link. There were a lot of changes here in this iteration and this was easiest. If anyone finds any issues or has cost/time updates, please let me know. Happy to update them as I get the latest information.

    Enjoy!



    Building Levels Building,Max @CC,Quantity (Enter Level Below - Lowest to the Left),Next Level - Column "D" 1,2,3,4,5,6,7,8,9,Level,Time,^ HP %,^ DPS % City Center,1,2, 9 seconds,17%,N/A Edge,Alliance Gate,0,N/A,N/A,N/A,N/A Embassy,0,N/A,N/A,N/A,N/A Museum,0,N/A,N/A,N/A,N/A Shipyard,0,N/A,N/A,N/A

    Leave a comment:


  • wrathchild_78
    commented on 's reply
    I have microprocessors researched and enigma machine on top with -9% library research time. It is -24% in total for me.
    so, this makes the 3rd level last 10 1/2 days
    the 2nd should be 6 days
    the 1st should be 2 days like you said

  • Dimun
    commented on 's reply
    Yes the armored ambush trap is 70k oil without any discounts

  • Dimun
    commented on 's reply
    As I assume you have Microprocessors researched, that'll be 9 days without any time reduction

  • Dimun
    replied
    First level of economic prosperity takes 1d 16h for my DA account, where I have Microprocessors researched (15% less Library research time). So if I assume the first level is 48 hours and multiply by 0.85 I'm getting 40.8 hours, that should be the 1d 16h for the first research.

    Leave a comment:


  • wrathchild_78
    replied
    library level 3 takes in my case 7d 14h which could be 8d without reduction

    Leave a comment:


  • wrathchild_78
    replied
    yes Armored ambush needs oil.
    Library research needs probably 2d for the first level, 5d for the second. I say probably because I have some time reductions from library and enigma artifact and the duration changes in my case.

    Leave a comment:


  • Agamemnon999
    replied
    So I have a new version I will share in a couple of days that will include the following:
    • Library tab with dependencies mapped out (including Digital Age)
    • Wonders added on the building tab
    • Digital traps added (armored trap)
    • Time and Resource discounts for Buildings, University, and Library auto-calculated based on research, wonders, and museum artifacts
    • Number of buildings available now auto-calculated based on research completed
    Can anyone confirm the following for me:
    • Digital Age costs/duration for library research - any info would be helpful even for only a level or two
    • Confirm the Digital Age Armored Ambush Trap needs oil to build
    I'll try to share the new version soon, but any info requested above would be helpful.

    Thanks

    -Aga

    Leave a comment:

Working...
X