Added the new turrets allowed with OP9 (sorry I missed them 1st time around).
I also relaid out the spreadsheet. There are now two columns so you won't have to do so much scrolling around.
Enjoy!
Instructions
To use the Base HP Calculator, enter the level of each building in the column next to the building name. If a building has not been built or has been scrapped, enter a zero for its level. The calculator will update the HP for that building based on its level and calculate each building percentage of the entire base's HP. Default settings are for a fully built out base. Cell protection is used to prevent incorrect levels from being entered.
To determine Bubble / Star thresholds when being attacked, enter a "Y" by each building that has been destroyed. The calculator will determine the % HP destroyed and display a message if the bubble or star thresholds have been crossed.
Thanks to PriceIsWrong from Battle Vortex for suggesting this calculator, and xnih from BP Info for giving the base hitpoint data.
So how can we change the HP values to the correct ones for our bases. For instance I have a turret that has 436k armor and your spreadsheet only gives the level 7 turrets 280k. There is no way to figure this accurately without accurate numbers. Same with warehouses and any other building you can equip anything to.
ReplyDeleteSo how can we change the HP values to the correct ones for our bases. For instance I have a turret that has 436k armor and your spreadsheet only gives the level 7 turrets 280k. There is no way to figure this accurately without accurate numbers. Same with warehouses and any other building you can equip anything to.
ReplyDeleteArmor you add doesn't count for the bubble calculation in-game.
ReplyDeleteAdvanced Lab lvl12?
ReplyDeleteAdvance lab 12 not accepted
ReplyDeleteFixed.
DeleteIs there any way of downloading this or saving the data? that way you could put all the relevant data in and just change what you need to change when you upgrade without starting all over again.
ReplyDeleteYeah that's what I do. I just keep this on OneDrive & that's what's posted, then I just edit the local copy on my computer & everything updates. The blog post just announces the change.
Deletethanks for a very fine tool. I assist several in my alliance with refining their base designs and this tool would be very good at that. It is not clear to me how to save the sheet once I have entered the data for a base. Is there any way to save the current sheet to the local drive with a distinct name?
ReplyDeletePerhaps another user can assist with this question.
Thanks again
Didn't see this post until just now... there is a download button at the bottom right side of the window.
Deletenice
ReplyDelete