Using the spreadsheet from my signature, I recreated all of the canon warships. Had to buy a few more PDFs to finish it but I got them all (that I know about).
First the link:
https://docs.google.com/spreadsheets/d/1MgPrZSOW7Uit4bs3x05AR9xQfF6uN5FXoM1Iears8xU/edit?usp=sharingIt was suggested to me that as long as I post it here, and don't try to claim they are official (they aren't), the mods probably wouldn't have a problem with this, but if there is, I'll remove it.
This is set to view only. To make your own copy, go to 'File' and select 'Make a copy' which will result in your own editable version. They are in alphabetical order rather than by tonnage, class, or faction.
I stuck as close to the designs as I could. There are some differences. First, I didn't always put the actual armor values, just the armor tonnages. Where they are missing, just get them from the TRO or other book. I'll eventually update those. I also didn't separate weapons into their bays. I typically do that when I put a ship on a TRO style entry, so I wasn't concerned with it here. I don't plan on changing that, since the TRO entries list it. Feel free to change that on your own copies as you see fit. This has no effect on BV2, C-bills, or anything else in the design process.
Other differences:
- On any discrepancy between amount of ammo and tonnage of ammo, I sided with the amount, to preserve the same performance.
- For discrepancies in armor, I sided with the armor amount over armor tonnage, to preserve the same performance. Some of those armor tonnages were very far off.
- Crew numbers are often different. I used the minimum crew as calculated by the formulas in SO. In some cases I had discovered some crew, like HPG operators, were put in as passengers, they are instead in the 'Gunners and Other' section on my sheets
- I used the standard format of Officers in 10-ton first class quarters, then Crew, Gunners, and Others in 7 ton second class quarters.
- I used a minimalist approach for bay personnel, giving them only the free quarters that came with the bay.
- Like Bay personnel, I took the minimalist approach to putting marines on the ship, assigning infantry bays or compartments to the ship for the amount needed. Since those are bays, they technically have the quarters for those troops, so I didn't put any other quarters on for marines.
- The Thera's TRO 3067 entry says it only has a bit over 100 fighters, but prior entries, and it's fluff indicate it should have 216. I gave it 216 fighter bays.
- The Nightwing's entry indicated that it had sensors of some kind in bays that it could extend from the hull from 3 bays. It's fluff indicated these bays were in the forward and side section. This equipment totaled 75 tons. I placed several look-down radars, Hi-Res Imagers, and infrared Imagers in the nose and both broadsides, adding up to the required tonnage.This seemed to me to meet the requirements for that gear, however it is a liberty I took with it, not canon, and c-bill costs reflect that choice.
- I didn't put standard cargo amounts on the bottom section of the sheets as I should, however this affects nothing. the 'Tonnage Remaining' value at the top is the amount of standard cargo the ship has. This has no effect on c-bills or anything else.
If something doesn't make sense on the spreadsheet, the 'Warship Calculator' link in my signature has an explanation of things on the spreadsheet. Try reading through that, and if it doesn't answer questions, feel free to ask me for clarifications.
As usual if anyone spots any egregious errors on my part like missing docking collars or something, please point them out so I can fix it.
If you just disagree with some of the choices I made (for example the quarters set-up), you can change your own version to match how you think it should be. I chose the minimalist route specifically to give the minimum it could be, with an expectation that they might have done more, but it is at least this much.
