The Worksheet in Question!
A little over a year ago I put together my first version of a logistics worksheet that allowed the user to work out how many of what kind of dropship would be needed to transport a given size of ground combat formation in Battletech. It was pretty fun, but required a lot of cutting and pasting and you had to be super careful about the formatting and it was kind of a hassle, plus I had only included the most common ships.
Fast forward a year of quarantine and my nerdery has only grown. So I returned to the project with an eye to improve it. First off, rather than copying and pasting you now select ships from a dropdown list (I highly recommend typing at least the first few letters of the ship you're looking for), then the sheet will autofill the relevant capacity fields by pulling from the libraries on other tabs. Secondly, I did a BUNCH more data entry, and it not includes practically every dropship, jumpship, and warship I have access to a full TRO entry for in my EXTENSIVE collection of PDFs, and the capacities calculated now include bulk cargo and docking collar usage. With all these shiny new features, I figured it would be good to share it with the community at large.
To use this worksheet, Create a copy, fill out the transport needs of the unit in question in the appropriate fields in Column M, then select dropships by typing names or selecting from the dropdown until the needs of the unit are met. Next, select ships in the KF Flotilla to meet the resulting dropcollar requirements. If you wish to add custom variants or new ships to the worksheet, I HIGHLY suggest adding them to the existing library tabs rather than just wildcatting them into the front end of the worksheet, unless you like rebuilding VLOOKUP functions.
Go forth and calculate logistics!
