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