test

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

  • ZaqMuse
    replied
    Hi Aga,

    First of all, very nice spreadsheet and i can't thank much for the efforts!!!!!!!
    Got some trouble after downloaded it.

    Error popup for some repair need to be done. After click yes, library became a mess. all skills only 4 out of 5.

    Appreciated some comments.

    Leave a comment:


  • wrathchild_78
    commented on 's reply
    thx mate! !!!!

  • Agamemnon999
    replied
    The Google Sheet has been updated with Parliament as well as some cost/time fixes for newer university leaders. When I have some time I may add a section on Parliament Laws to track the cost and time discounts properly. Everything else would be for tracking purposes only.

    I have not updated any of the items for the Digital age at this point. That may come in the future as I have some time. I'm still Space Age at this point.

    Also, people keep asking for the ability to edit the google sheet. I haven't allowed that and at this point don't plan to. As a reminder, if you want to use it, please copy the sheet to your own account and have fun.

    Thanks,

    Aga

    Leave a comment:


  • Agamemnon999
    commented on 's reply
    Miraz, make sure you fill out the library sheet. Based on your library research it should open up the additional spots you mention. At the Atomic age, the sheet should work almost perfectly. There are a few things I still update but those tend to be Space age and Digital Age.

  • Miraz
    replied
    Domination Upgrade sheet should be more updated. in Atomic age, farm 8, caravan is 8, tower is 8, SAM battery is 4, Land mine is 8, barbed wire is 8, ambush trap is 9, garrison is 5, bunker is 2, air defense is 4, mortar is 4. this things should be changed.

    Leave a comment:


  • 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

Unconfigured PHP Module

Collapse

Working...
X