Spreadsheet for armor calculations with stacking and bonuses


#1

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)


#2

Nifty. GSB is probably the only game that I play with a TI-83 on standby, so this could be fun to play with.