Most Current Link:
https://docs.google.com/spreadsheets/d/1FG8gbws9gKoMRzpG0AgNS75IFiY1s2MhotHH0uK9zSo/edit?usp=sharingThe sheet is set to view only. Inside the link, click file, and select "Make a Copy" to create your own version you can use.
You can use this link to make the spreadsheet usable offline:
https://support.google.com/drive/answer/2375012?co=GENIE.Platform%3DDesktop&hl=enLike my other calculators, green is cell that can have user input, light grey is a formula that you should leave alone. On this sheet Yellow is an important total.
It does not yet calculate BV2 or C-bill cost, but will in the future.
Like my other sheets, there is only so much I can do on a spreadsheet, and if you want to make legal designs, you will need to be familiar with the rules. I can't really restrict you from putting things on one chassis that shouldn't be there, and I wasn't able to set a minimum engine weight, due to the complexity of all the different possibly chassis and engine types. I am working on fixing the minimum engine weight problem, but anything else you will need to know the rules on.
Like the other ones you can select weapons and equipment in the dropdown menus, then assign the number of them, and then the location. You need to assign any turrets the vehicle has in the "Turrets" section at the top. It is large enough to accommodate even the largest of Large Naval Support Vehicles' maximum number of turrets. If you don't assign what turrets you have here it will mess up calculations in several places.
Unlike the other calculators, I figured out how to do a filter function on this one's weapon and equipment lists. You will see a filter box with a trio of dropdown menus. The first dropdown is a simple yes no, yes means you want to use the filter, no means you don't. You can select an option for each box, and the options will change in the third one depending on what you select in the second one. Because of these filters, as long as the rest of the line fills in with the right info, ignore any warnings that appear on the weapon name column. There are a lot of things you can filter for, but if you just want it to be the list of everything a support vehicle can equip, set the first dropdown to 'No'.
As always, please let me know if you find anything wrong with it. This hasn't had as much testing as my other sheets.