Author Topic: Spreadsheet for Small Support Vehicle Design  (Read 3182 times)

NullVoid

  • Sergeant
  • *
  • Posts: 145
Spreadsheet for Small Support Vehicle Design
« on: 18 June 2016, 08:01:37 »
So, I'd like to share this spreadsheet I created years ago for creating small support vehicles for A Time of War. It's somewhat limited, seeing as it requires the designer to manually enter the equipment details, the concealed/pintle/turret/energy/weapon flags for autocalculating the extra weight for these subsystems only works if the SUMIF comparison is set not to match the whole cell, and it doesn't even try to calculate BV.

Input cells are painted blue, and most non-obvious (to me) of those have notes explaining what the cell expects. I think it correctly handles mass and cost calculations, but if anyone notices any inconsistencies let me know.