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.

Sunday, October 15, 2017

Quick Update

I added the Conquest Yard and the Advanced Lab level 13.  Thanks to the "unknown" commenter who pointed it out.

Note that the health on some of this new stuff is pretty much a guess based on patterns of previous levels.  However, the errors shouldn't be too large since the WH, turrets, and OP are really what drives your bubble pad.

Thursday, September 21, 2017

OP 10

All updated - I think it's right... but if you think I missed something, please let me know in the comments.

Friday, August 25, 2017

Portals

I've added the portals, and the 4 more turrets that you can mount to the portal ends.  The portal health is based on a Laredo post.

(EDIT: Those 4 turrets don't have their own health.  I took them back out)

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!

Tuesday, December 6, 2016

Updated for OP9

I've updated the spreadsheet for OP9:

  • New defaults try to get a better idea of where a player would be starting from for a OP9 upgrade
  • Added Level 9 Outpost with 3,000,000 health
  • Added Level 15 WH with 2,000,000 health
  • Added Level 4 Shipyard with 8000 health (guessed)
  • Added Level 13 Dock with 8350 health, changed Level 12 Dock to 7700 health (both guessed)
Let me know if there are any problems.

Monday, March 28, 2016

Updated for OP8


  • New Turret, Warehouse, and Outpost levels (and health) added.  
  • Two new turrets added. 

Please leave me a comment if anything looks wrong.  I'll be following up with a blog post this week to talk about the update.

Monday, February 29, 2016

Resource Generators

Added 2 more Metal/Oil/Energy/Zynthuim Generators so that you can correctly show 8 of each.

Monday, October 5, 2015

Outpost 7 Update

Thanks to a reader who pushed me into action, I have updated the sheet with the new building and turret levels available with Outpost 7.

Thursday, October 16, 2014

Outpost 6 Update

I added the Outpost 6, Dock 11, Resource Generators 11, and Labs 11.  Also added 2 more turrets.  Dock 11 health is estimated at 7050 based on progression from previous levels.

Thursday, April 17, 2014

Bug Fix 2

The warehouse hitpoints weren't being accounted for in the bubble calculation.  Now corrected.

I thought this got caught before release... sorry!

Wednesday, April 9, 2014

Bug Fix 1

Corrected to add Launchpad.

Initial Public Release

First release.  See article at http://bpprof.blogspot.com/2014/04/introducing-base-damage-calculator.html for more detailed instructions.
Level 12 warehouse ONLY has new hitpoint values reflecting higher health from 2 April 2014 update.