test

Announcement

Collapse
No announcement yet.

Building Upgrade Spreadsheet

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

  • #46
    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

    Comment


    • Dimun
      Dimun commented
      Editing a comment
      Yes the armored ambush trap is 70k oil without any discounts

  • #47
    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.
    The Greeks
    Μονο για πολεμοχαρης παικτες! Απο επιπεδο 180 και πανω.

    The Greeks 2
    Training academy για ολα τα επιπεδα παικτων.

    Comment


    • #48
      library level 3 takes in my case 7d 14h which could be 8d without reduction
      The Greeks
      Μονο για πολεμοχαρης παικτες! Απο επιπεδο 180 και πανω.

      The Greeks 2
      Training academy για ολα τα επιπεδα παικτων.

      Comment


      • Dimun
        Dimun commented
        Editing a comment
        As I assume you have Microprocessors researched, that'll be 9 days without any time reduction

      • wrathchild_78
        wrathchild_78 commented
        Editing a comment
        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

    • #49
      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.

      Comment


      • #50
        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

        Comment


        • Dimun
          Dimun commented
          Editing a comment
          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

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

        Comment


        • Agamemnon999
          Agamemnon999 commented
          Editing a comment
          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
          W1ll1am commented
          Editing a comment
          Thank you, very nice.

      • #52
        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

        Comment


        • #53
          thanks mate! great work! As for traps, i have no idea cause mine are cwa/sa level
          The Greeks
          Μονο για πολεμοχαρης παικτες! Απο επιπεδο 180 και πανω.

          The Greeks 2
          Training academy για ολα τα επιπεδα παικτων.

          Comment


          • #54
            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.

            Comment


            • Agamemnon999
              Agamemnon999 commented
              Editing a comment
              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.

          • #55
            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

            Comment


          • #56
            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.

            Comment


            • #57
              Originally posted by Agamemnon999 View Post
              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
              Wanted to congratulate you for taking the time to do this upgrade sheet ! It's extremely helpful. Have you, by any chance, upgraded it since its last revision ? I am sure many people using it would appreciate it.

              Thanks once again !!

              Comment


              • #58
                iparout, I have recently updated it for Information Age, Wonder building time discounts, bookcases, Parliament and some other stuff. I'm not a google sheet expert so I wind up fixing up my personal copy and I haven't found an easy way to push those changes back to the raw template. So when I have some time in the next week, I'll remove the current template link and post a new one.

                Not everything is quite right on it, higher level bookcases as well as some Parliament levels, but those are easy enough to correct once I post it if people let me know the right values. The biggest challenge I've had is the wiki data is no longer accurate. People post the cost/duration they see forgetting that there are so many modifiers that when I use what they put in, they don't line up.

                Will post an update soon for everyone

                Aga

                Comment


                • #59
                  Originally posted by Agamemnon999 View Post
                  iparout, I have recently updated it for Information Age, Wonder building time discounts, bookcases, Parliament and some other stuff. I'm not a google sheet expert so I wind up fixing up my personal copy and I haven't found an easy way to push those changes back to the raw template. So when I have some time in the next week, I'll remove the current template link and post a new one.

                  Not everything is quite right on it, higher level bookcases as well as some Parliament levels, but those are easy enough to correct once I post it if people let me know the right values. The biggest challenge I've had is the wiki data is no longer accurate. People post the cost/duration they see forgetting that there are so many modifiers that when I use what they put in, they don't line up.

                  Will post an update soon for everyone

                  Aga
                  Really appreciate the time you put into it and the will to keep on updating the spreadsheet. It gives the game a whole new meaning.

                  Comment


                  • #60
                    Here is a link to the new spreadsheet. If you don't know how to use it, please read back on this thread. I took the old one down.

                    Happy to answer any questions if anyone has any. Also happy to find a better way to distribute updates when I have them.

                    Please make yourself a local copy to use it and don't ask for edit rights. I don't give those out unless you tell me that you want to help maintain it.

                    Have fun realizing you have years of upgrades ahead of you!!!

                    Aga
                    Last edited by Agamemnon999; 03-17-2021, 04:19 PM.

                    Comment

                    Unconfigured PHP Module

                    Collapse

                    Working...
                    X