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.
Tuesday, December 6, 2016
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.