Phew, that was a long title.
Yesterday I was trying to add an armor that would make the Alliance more intimidating (the advent of the Tribe and heavy lasers reduced that) with their racial bonuses. Well, I was doing okay with that but I couldn’t visualize the values that easily and so it involved a lot of guesswork to get the right balance. Considering that I didn’t get close to my goal without spending 2 hours of fiddling, I believe this spreadsheet might help someone else.
Inputs:
- Damage Absorbable
- Stack Efficiency
- Price
- Weight
- Racial Bonus
Outputs (from stacks of 1 to 5)
- Total Armor (factoring racial bonus and stacking efficiency)
- Price per Unit
- Weight per Unit
- Avg Armor per Module (both 18 modules and 16 modules)
gsb armor calculations.zip (2.33 KB)