BattleTech - The Board Game of Armored Combat

BattleTech Player Boards => Fan Designs and Rules => Non-Combat Vehicles => Topic started by: NullVoid on 18 June 2016, 08:01:37

Title: Spreadsheet for Small Support Vehicle Design
Post by: NullVoid 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.