Announcement

Collapse
No announcement yet.

Fortification / Base Building Planning Tool

Collapse
This is a sticky topic.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    When is the xp increased. Is it level 150? Please let me know

    Comment


  • #17
    Do U have to have a sapphire hatched. I'm asking this because a team member hit 150 and didn't see the increase. I got the increase when it was released... so I don't know what the requirements are. It wasn't a concern of mine. Thanks for your time emrah

    Comment


    • EmrahT
      EmrahT commented
      Editing a comment
      Happy if i could help. I dont know about some criteria... should be possible for all players who reached that level normally... otherwise the support should be asked. Echo is there a criteria with breeding to get XP-increase after a point ? hmm

  • #18
    All player who hit that level will get the increase, but keep in mind, its the max XP possible (attack stronger bases), if you are not attacking stronger bases then you shouldn't expect to get any more xp.

    Comment


  • #19
    Just an FYI that I have a version of the tool updated to include level 45 towers, new farm/mill levels, etc., as well as the first perch, but am waiting on info from PG regarding build times for all 3 perches that was discussed in this comment. EggToken, could you get us an answer to the build times question please? Once I have that confirmed, I can update the public version.

    Thank you.
    Last edited by aldinach; 02-02-2017, 04:23 PM.
    "The only winning move is not to play" first Wargames, and now War Dragons

    Check out my Base/Fortification Event Planning Tool

    Comment


    • #20
      Hi all - I never heard back from PG about the question on build times, so I've gone ahead and released the tool with my best guesses as to build times for the 2nd and third towers. You can get a copy of the updated tool using the link in the first post in this thread.

      This version contained a lot of changes with the three different perches and level 45 towers, so if you find any errors, please let me know.
      "The only winning move is not to play" first Wargames, and now War Dragons

      Check out my Base/Fortification Event Planning Tool

      Comment


      • #21
        Sorry I couldn't find time to do this before the fortification event.

        Seagazer
        Level Upgrade Cost Upgrade Time HP Dragon Tier
        1 Black Pearl: 100 0:25:00 6,600 Purple
        2 Lumber: 208 3:45:00 7,840 Purple
        3 Black Pearl: 200 9:00:00 8,976 Purple
        4 Lumber: 861 15:24:00 10,275 Purple
        5 Black Pearl: 300 26:24:00 11,763 Purple
        6 Lumber: 1894 32:24:00 13,467 Blue
        7 Black Pearl: 400 42:00:00 15,402 Blue
        8 Lumber: 3714 42:00:00 17,544 Blue
        9 Black Pearl: 500 45:00:00 19,904 Blue
        10 Lumber: 8712 45:34:10 22,492 Blue
        11 Black Pearl: 600 46:45:11 25,316 Orange
        12 Lumber: 17819 51:12:00 28,381 Orange
        13 Black Pearl: 700 57:32:03 31,689 Orange
        14 Lumber: 38115 59:09:17 35,277 Orange
        15 Black Pearl: 800 68:52:10 39,272 Orange
        16 Lumber: 57617 85:31:38 46,129 Green
        17 Black Pearl: 900 115:44:00 54,182 Green
        18 Lumber: 86400 134:24:00 63,642 Green
        19 Black Pearl: 1000 151:12:00 74,755 Green
        20 Lumber: 154799 168:00:00 87,807 Green
        21 Black Pearl: 1100 201:36:00 103,140 Gold
        22 Lumber: 219599 235:12:00 121,149 Gold
        23 Black Pearl: 1200 268:48:00 142,304 Gold
        24 Lumber: 269232 336:00:00 167,154 Gold
        25 Black Pearl: 1300 336:00:00 196,342 Gold
        26 Lumber: 340800 364:00:00 243,339 Platinum
        27 Black Pearl: 1400 420:00:00 301,585 Platinum
        28 Lumber: 422592 448:00:00 352,741 Platinum
        29 Black Pearl: 1600 476:00:00 389,356 Platinum
        30 Lumber: 504384 532:00:00 429,775 Platinum
        31 Black Pearl: 1800 627:12:00 474,388 Sapphire
        32 Lumber: 586176 705:36:00 523,635 Sapphire
        33 Black Pearl: 2000 752:38:24 577,993 Sapphire
        34 Lumber: 667968 772:48:00 637,994 Sapphire
        35 Black Pearl: 2200 792:57:36 704,223 Sapphire
        36 Lumber: 749760 813:07:12 777,330 Garnet
        37 Black Pearl: 2400 833:16:48 858,025 Garnet
        38 Lumber: 831552 853:26:24 947,096 Garnet
        39 Black Pearl: 2600 873:36:00 1,045,416 Garnet
        40 Lumber: 913344 893:45:36 1,153,941 Garnet
        41 Black Pearl: 2800 919:04:11 1,273,732 Garnet
        42 Lumber: 995136 973:54:58 1,405,960 Garnet
        43 Black Pearl: 3000 1085:28:11 1,551,915 Garnet
        44 Lumber: 1076928 1183:01:57 1,713,021 Garnet
        45 Black Pearl: 3200 1203:16:27 1,890,852 Garnet
        Riverwatch
        Level Upgrade Cost Upgrade Time HP Dragon Tier
        1 Black Pearl: 2000 0:25:00 6,600 Purple
        2 Lumber: 208 3:45:00 7,840 Purple
        3 Black Pearl: 200 9:00:00 8,976 Purple
        4 Lumber: 861 15:24:00 10,275 Purple
        5 Black Pearl: 300 26:24:00 11,763 Purple
        6 Lumber: 1894 32:24:00 13,467 Blue
        7 Black Pearl: 400 42:00:00 15,402 Blue
        8 Lumber: 3714 42:00:00 17,544 Blue
        9 Black Pearl: 500 45:00:00 19,904 Blue
        10 Lumber: 8712 45:34:10 22,492 Blue
        11 Black Pearl: 600 46:45:11 25,316 Orange
        12 Lumber: 17819 51:12:00 28,381 Orange
        13 Black Pearl: 700 57:32:03 31,689 Orange
        14 Lumber: 38115 59:09:17 35,277 Orange
        15 Black Pearl: 800 68:52:10 39,272 Orange
        16 Lumber: 57617 85:31:38 46,129 Green
        17 Black Pearl: 900 115:44:00 54,182 Green
        18 Lumber: 86400 134:24:00 63,642 Green
        19 Black Pearl: 1000 151:12:00 74,755 Green
        20 Lumber: 154799 168:00:00 87,807 Green
        21 Black Pearl: 1100 201:36:00 103,140 Gold
        22 Lumber: 219599 235:12:00 121,149 Gold
        23 Black Pearl: 1200 268:48:00 142,304 Gold
        24 Lumber: 269232 336:00:00 167,154 Gold
        25 Black Pearl: 1300 336:00:00 196,342 Gold
        26 Lumber: 340800 364:00:00 243,339 Platinum
        27 Black Pearl: 1400 420:00:00 301,585 Platinum
        28 Lumber: 422592 448:00:00 352,741 Platinum
        29 Black Pearl: 1600 476:00:00 389,356 Platinum
        30 Lumber: 504384 532:00:00 429,775 Platinum
        31 Black Pearl: 1800 627:12:00 474,388 Sapphire
        32 Lumber: 586176 705:36:00 523,635 Sapphire
        33 Black Pearl: 2000 752:38:24 577,993 Sapphire
        34 Lumber: 667968 772:48:00 637,994 Sapphire
        35 Black Pearl: 2200 792:57:36 704,223 Sapphire
        36 Lumber: 749760 813:07:12 777,330 Garnet
        37 Black Pearl: 2400 833:16:48 858,025 Garnet
        38 Lumber: 831552 853:26:24 947,096 Garnet
        39 Black Pearl: 2600 873:36:00 1,045,416 Garnet
        40 Lumber: 913344 893:45:36 1,153,941 Garnet
        41 Black Pearl: 2800 919:04:11 1,273,732 Garnet
        42 Lumber: 995136 973:54:58 1,405,960 Garnet
        43 Black Pearl: 3000 1085:28:11 1,551,915 Garnet
        44 Lumber: 1076928 1183:01:57 1,713,021 Garnet
        45 Black Pearl: 3200 1203:16:27 1,890,852 Garnet
        Stonespear
        Level Upgrade Cost Upgrade Time HP Dragon Tier
        1 Black Pearl: 3000 13:45:00 8,389 Purple
        2 Lumber: 208 29:15:00 9,603 Purple
        3 Black Pearl: 200 33:45:00 10,994 Purple
        4 Lumber: 861 42:04:30 12,586 Purple
        5 Black Pearl: 300 47:01:30 14,409 Purple
        6 Lumber: 1894 48:00:00 16,446 Blue
        7 Black Pearl: 400 52:30:00 18,696 Blue
        8 Lumber: 3714 52:30:00 21,169 Blue
        9 Black Pearl: 500 55:23:04 23,875 Blue
        10 Lumber: 8712 63:09:28 26,818 Blue
        11 Black Pearl: 600 64:51:53 30,004 Orange
        12 Lumber: 17819 66:40:00 33,435 Orange
        13 Black Pearl: 700 72:00:00 37,221 Orange
        14 Lumber: 38115 74:07:03 41,436 Orange
        15 Black Pearl: 800 84:00:00 46,129 Orange
        16 Lumber: 57617 100:48:00 51,352 Green
        17 Black Pearl: 900 117:36:00 57,168 Green
        18 Lumber: 86400 134:24:00 63,642 Green
        19 Black Pearl: 1000 151:12:00 74,755 Green
        20 Lumber: 154799 168:00:00 87,807 Green
        21 Black Pearl: 1100 201:36:00 103,140 Gold
        22 Lumber: 219599 235:12:00 121,149 Gold
        23 Black Pearl: 1200 268:48:00 142,304 Gold
        24 Lumber: 269232 336:00:00 167,154 Gold
        25 Black Pearl: 1300 336:00:00 196,342 Gold
        26 Lumber: 340800 364:00:00 243,339 Platinum
        27 Black Pearl: 1400 420:00:00 301,585 Platinum
        28 Lumber: 422592 448:00:00 352,741 Platinum
        29 Black Pearl: 1600 476:00:00 389,356 Platinum
        30 Lumber: 504384 532:00:00 429,775 Platinum
        31 Black Pearl: 1800 627:12:00 474,388 Sapphire
        32 Lumber: 586176 705:36:00 523,635 Sapphire
        33 Black Pearl: 2000 752:38:24 577,993 Sapphire
        34 Lumber: 667968 772:48:00 637,994 Sapphire
        35 Black Pearl: 2200 792:57:36 704,223 Sapphire
        36 Lumber: 749760 813:07:12 777,330 Garnet
        37 Black Pearl: 2400 833:16:48 858,025 Garnet
        38 Lumber: 831552 853:26:24 947,096 Garnet
        39 Black Pearl: 2600 873:36:00 1,045,416 Garnet
        40 Lumber: 913344 893:45:36 1,153,941 Garnet
        41 Black Pearl: 2800 919:04:11 1,273,732 Garnet
        42 Lumber: 995136 973:54:58 1,405,960 Garnet
        43 Black Pearl: 3000 1085:28:11 1,551,915 Garnet
        44 Lumber: 1076928 1183:01:57 1,713,021 Garnet
        45 Black Pearl: 3200 1203:16:27 1,890,852 Garnet

        Delivered.jpg
        +10 points if you recognize this guy

        Comment


        • #22
          Thanks EggToken - I'll update my tool before the next fort.

          Edit: update.. I've fixed the third perch in the tool to map to EggToken's info.
          Last edited by aldinach; 02-10-2017, 02:23 PM.
          "The only winning move is not to play" first Wargames, and now War Dragons

          Check out my Base/Fortification Event Planning Tool

          Comment


          • #23
            I downloaded 1.3 a while back but just started toying with it today. Great work! Thanks for the contribution!

            Comment


            • #24
              Thanks itsjustjoe.

              Also as an FYI to everyone, I've uploaded a new version today that includes a total speedup calculator on a new tab to show you how many total days of speedups you have in your inventory. Many might have something like this already, but I figured putting it together with the fort planner made sense. You can access the latest version using the link in the first post.
              "The only winning move is not to play" first Wargames, and now War Dragons

              Check out my Base/Fortification Event Planning Tool

              Comment


              • #25
                ​aldinach, first of all many thanks for this wonderful tool! Been using it for 3 fort events now and it never disappoints.

                Second, I noticed that it doesn't recognize mills and farms above lvl 32 (so if you start at 31 and end at 35 it takes into account only 31->32). Not sure if I'm just using a link to an old version before their max was raised or something... Just thought I'd let you know.

                Comment


                • aldinach
                  aldinach commented
                  Editing a comment
                  Yep. Must be broken. I'll have a quick look this weekend.

                • aldinach
                  aldinach commented
                  Editing a comment
                  DragonHunter - this has now been fixed, thanks for the heads up. You can download a copy from the original link.

                • DragonHunter
                  DragonHunter commented
                  Editing a comment
                  Thank you aldinach!

              • #26
                aldinach I've just downloaded and checked the latest version for the upcoming fortification event this weekend.
                Two bugs I would like to report, maybe you can fix them before the event goes live:
                1) The speedup calculator has no formulas that accumulate the numbers that are typed in (I did a quick fix myself for the file I downloaded)
                2) When selecting a perch to upgrade by only one level that should use Black Pearls, it pulls the Pearls as well as a lumber cost (Tested with Perch 1 upgrade from lvl22 to 23 that should only pull the 1200 Pearls, however it also pulls a 251.999 lumber cost which is wrong)

                Again thank you for the great work, it's very useful to plan ahead to optimize event points for the amount of timers you have

                Another idea: You could have the excel file make a simple check if the total timers you have from the speed up calculation tab is sufficient for the accumulated upgrades you're planning and have the background of the Total of "Time w/ Research Bonus" go red when there aren't enough timers and green when you have enough timers.
                MareZ ~ lvl20X ~ Garnet Tier Dragons

                Important Threads to find everything you need

                Comment


                • aldinach
                  aldinach commented
                  Editing a comment
                  Sorry I haven't responded to this. I will try to get to it at some point, I just find myself less motivated to keep it updated after leaving. If you'd like to take over the main version, I'd be happy to give you edit rights.

                  edits: I think I managed to fix both issues, but please test a little as I made the change quickly and hopefully didn't break something else while fixing the math for perch (2) and (3) upgrades. Thanks MareZ for finding the bugs.
                  Last edited by aldinach; 03-26-2017, 08:43 PM.

              • #27
                Hi all - I've had a few people ask me to update the tool for flak cannons, and I just can't find the will to do so. Is there anyone who follows this thread who would like to take over maintenance of the tool? You need some pretty sharp Excel skills, but beyond that it's not super complicated. If you're interested please let me know.

                "The only winning move is not to play" first Wargames, and now War Dragons

                Check out my Base/Fortification Event Planning Tool

                Comment


                • #28
                  Hello base builders.

                  Gambrin was willing to step forward and help to update the fortification planner to account for new tower levels & types, as well as to make a number of improvements to the 'innards' of the original tool. He's now opening it up for a public beta to make sure we've worked all the bugs out. If you have time, can you please download the new tool using the link below and play with it, and let us know if you find any problems?

                  Fortification Planner Beta Tool

                  Thank you, and thanks to Gambrin for teaching me a few new tricks about Excel in the process.
                  Last edited by aldinach; 04-28-2017, 04:19 PM.
                  "The only winning move is not to play" first Wargames, and now War Dragons

                  Check out my Base/Fortification Event Planning Tool

                  Comment


                  • Gambrin
                    Gambrin commented
                    Editing a comment
                    Version 2.2 beta now includes a separate sheet for a very long scenario, allowing for 40+ defensive buildings to be modeled, for those of long bases. Let me know if it is useful.
                    P.S. The link remains the same.
                    Last edited by Gambrin; 04-29-2017, 04:55 AM.

                  • MareZ
                    MareZ commented
                    Editing a comment
                    Looking good! Seems to work very well with the updated values, I especially like the check for sufficient clocks
                    The infobox still says v2.1 but the long case scenario of v2.2 is already in my version, also the Data Tab could be hidden but that's just minor stuff.
                    Will report bugs if I find any, great work so far!

                  • Gambrin
                    Gambrin commented
                    Editing a comment
                    Thanks MareZ.

                    The plan was to leave all tabs visible to betatesters, while in the release version, only the scenario tabs and speedup calc will be visible.

                    - Version number in the Instruction box is now fixed.
                    - Data and version history tabs are hidden now.
                    Last edited by Gambrin; 05-02-2017, 02:49 AM.

                • #29
                  Is is only counting the value of 1 perch? I can't seem to find the other 2?

                  Comment


                  • aldinach
                    aldinach commented
                    Editing a comment
                    Thanks for testing Morpheus. If you start typing "Perch" in any of the building input rows you'll see the option to select Perch (1), Perch (2), or Perch (3). When you open the sheet only the first is shown as that's the only scenario modeled, but you can choose all 3. Keep the feedback coming.

                • #30
                  I'm having a hell of a time getting the po.st shortener to work well with my desktop browsers. I even downloaded a stock one to ensure it wasn't a problem with extensions etc. Any chance you can provide one with a bit.ly or goo.gl shortener guys?

                  Comment

                Working...
                X