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.

Wednesday, December 7, 2016

OP9 Part 2

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!

11 comments:

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

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

    ReplyDelete
  3. Armor you add doesn't count for the bubble calculation in-game.

    ReplyDelete
  4. Is 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.

    ReplyDelete
    Replies
    1. Yeah 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.

      Delete
  5. thanks 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?
    Perhaps another user can assist with this question.
    Thanks again

    ReplyDelete
    Replies
    1. Didn't see this post until just now... there is a download button at the bottom right side of the window.

      Delete