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.
Interesting case study on why software is hard. As I inserted a line on this sheet to display data I had already entered, I managed to:
ReplyDelete- forget to reprotect the sheet
- get the cell allowable values incorrect - I copied the Outpost because both go up to level 5, but the launch pad should also allow a zero
- cut off the last line from the embed because I inserted a line, and so the named embed range was too small.
Yes, fixing one bug caused three... Sometimes, you might want to cut Kixeye a break.
All I'm seeing is a white box. No spreadsheet. Is there somewhere I can download the sheet from?
ReplyDeleteI've checked this with IE, Chrome, and Torch - what browser are you using? I've also double checked and made sure this is accessible when I sign out of OneDrive, so the file is public.
DeleteNo luck on Chrome but I'm seeing it on Firefox.
ReplyDelete