This is a fantastic piece of work, and thank you. I had worked out a spreadsheet which was under the High Guard rules before the update, which was working well. However when the updated edition came out I didn't have the time (or the energy!) to go through it and check everything for changes, and fix it where it needed. So this version is a great relief.
I've started to transfer some designs onto your version (the 2024.12.25b update) and I have found some issues as I've been going.
Typo on "Hull tab", cell S5. Should read "Cylinder".
Power Plant tab: Power Plant Mods section
The increase in power output having selected "D1 Advanced - Energy Efficient" does not seem to factor in the increased output (plus 10%) on the Power Plant or on the Summary tab.
Furthermore, this is impacted by a change between High Guard 2016 and the updated High Guard 2022 update:
Page 71 of High Guard 2022 (in the customising ships section) states:
"Increased Power: This power plant produces +10% more Power than normal (round up). Increased Power requires two Advantages." (italics mine as this was not present in the 2016 version)
"Energy Efficient" isn't listed against power plants, although "Energy Inefficient" is (as a disadvantage). I suspect this is an error that slipped through proofing as using consistent terms would have been clearer.
Then there's the bit which I've put in italics. Given there are only three advantage 'slots', if Increased Power/Energy Efficient takes up two of them, then only one instance is possible.
Suggest excluding option from the dropdown lists for B13 and B14 so it can only be chosen once (in cell B12).
It looks like Point Defence Batteries (tab 8a-Weapons) are counted towards the number of gunner/crew positions. I don't think this is intended to be the case. High Guard 2022 page 33 states, re Point Defence Batteries:
"This removes the need for separate gunners dedicated to point defence, needing only a command from the bridge to activate when an incoming attack is detected.
I have a couple of thoughts/suggestions for consideration as well, if I may:
On tab 9a-Optional, there is a section for additional airlocks. Is it worth including the option to designate the additional airlocks as Cargo Airlocks, so this is mirrored as such on the summary tab?
Trivial, but is it worth considering including the Hull Points and the Radiation Shielding rating on the summary tab, as well as the SSD?
Lastly, none of the above is intended as any criticism, so I hope you don't take it as such. I know just how much work putting together something like this is, and I am hugely appreciative!
