Excel Ship Designer

I noticed something when I added the 'Pressure Hull' option to a fully armored ship -- the armor value did not increase. But I believe the increase in Armor values stack. After all, the normal 'Maximum armor' does not include the 25% of the ships volume taken up by the pressure hull, so obviously new armor material is being added.

Or is this covered in Errata somewhere, and I missed it?
 
I noticed something when I added the 'Pressure Hull' option to a fully armored ship -- the armor value did not increase. But I believe the increase in Armor values stack. After all, the normal 'Maximum armor' does not include the 25% of the ships volume taken up by the pressure hull, so obviously new armor material is being added.

Or is this covered in Errata somewhere, and I missed it?
The pressure hull correctly adds 4 to armor.
See HG22, pg 12, last full paragraph. The TL limit applies even if there is intrinsic armor.
 
The number of sensor actions is being calculated wrong. I'm looking at a ship that is 16,000 tons and shows the correct 3 sensor actions before I add additional sensor stations. However, when I add sensor stations, it adds the new number to 1 rather than what the default actually should be.1730603966749.png1730603992090.png
 
The number of sensor actions is being calculated wrong. I'm looking at a ship that is 16,000 tons and shows the correct 3 sensor actions before I add additional sensor stations. However, when I add sensor stations, it adds the new number to 1 rather than what the default actually should be.View attachment 2809View attachment 2810
That's a compromise between RAW and letting you get away with adding sensor stations anyway. It was an either or choice. The system for less than 7500 or the system for more than 7500. If you can think of a more elegant solution, I am open to suggestions. Perhaps an override box that will also drive sensor crew requirements?
 
That's a compromise between RAW and letting you get away with adding sensor stations anyway. It was an either or choice. The system for less than 7500 or the system for more than 7500. If you can think of a more elegant solution, I am open to suggestions. Perhaps an override box that will also drive sensor crew requirements?
Ah. Now I remember. I designed this before I knew that there was a 7,500 ton limit (and I forgot it again). It used the spreadsheet before there was a warning.

I will take a look, but I’d imagine it won’t be hard. Tonnage / 7500 rounded up plus additional sensor stations would give the correct number. It would still be out of compliance with RAW and should trigger a warning.

Edit: It works correctly in the most recent version of the spreadsheet. False alarm.
 
Last edited:
I remembered that the Element-Class Cruisers box set had an intelligence pod and so I went to look at it. It was done before the High Guard 2022 Update, but it shows that there was intent to have specialized electronic warfare setups on ships larger than 7,500 tons.

In this 2,600-ton pod, they added 24 sensor stations. More and more, I'm sure who ever added the limit to sensor stations above 7,500 tons was smoking something good when he or she added it.

EDIT: I blame coffee for not recognizing that 2,600 is less than 7,500. Here is a ship that is actually larger than 7,500 tons with extra sensor stations. ;)

1730658909732.png
 
Last edited:
I was messing around with the spreadsheet (the most recent one this time) and wondered why the spinal mount didn't have the effects of the advantages/disadvantages show up like the other weapons. A little digging allowed me to copy the cell from one of the regular weapons, change the references from table5 to table6, and get them working.

In addition to asking you to add that to the master sheet, I found some cells that I missed in my quest to give commas to the masses for large numbers. If you could change these to numbers with commas, I would appreciate it.

Ship Info tab: M4, M5
Power Plant tab: D18, D20, D22
Fuel tab: F25
Weapons tab: N9, Q9
 
Last edited:
Sorry about the Spinal Mounts, an easier way is =Z157&Z158&Z159. Fixed, but the next update will wait on the Summary tab, and I am only at the bottom of the Power tab, ATM.
I figured it would wait until it was ready. No rush. Just tossing them in while you were doing other things.
 
Found another little glitch. When I change the High-Capacity Batteries from no to either TL, the number of units goes yellow as expected, but so does the number of accumulators/collectors just under it.
 
In the next update, it will be possible to use the main tanks as Cargo/fuel tanks.
When toggled, only the additional C/FT tonnage will be added, not the main tank volume.
 
In the next update, it will be possible to use the main tanks as Cargo/fuel tanks.
When toggled, only the additional C/FT tonnage will be added, not the main tank volume.
Interesting. How do you imagine that would work in practice? I'm not clearly seeing how it would be used.
 
A far trader going along the mains can take a normal cargo load jump-1, and then pick up additional cargo for the second stop jump-1 away.
That is scalable for any ship capable multi-jump operation or extended duty in-system operations.
Ex: a large sublight ore hauler making rounds in an asteroid belt between corpo miners and the refinery. The further it goes, the more it can carry.
It will show on the Cargo tab, but won't report there, so mainly an RP and fluff thing, other than the calculations.
 
A far trader going along the mains can take a normal cargo load jump-1, and then pick up additional cargo for the second stop jump-1 away.
That is scalable for any ship capable multi-jump operation or extended duty in-system operations.
Ex: a large sublight ore hauler making rounds in an asteroid belt between corpo miners and the refinery. The further it goes, the more it can carry.
It will show on the Cargo tab, but won't report there, so mainly an RP and fluff thing, other than the calculations.
Ah. Now I get it. Sounds useful.
 
I was messing around with the spreadsheet (the most recent one this time) and wondered why the spinal mount didn't have the effects of the advantages/disadvantages show up like the other weapons. A little digging allowed me to copy the cell from one of the regular weapons, change the references from table5 to table6, and get them working.

In addition to asking you to add that to the master sheet, I found some cells that I missed in my quest to give commas to the masses for large numbers. If you could change these to numbers with commas, I would appreciate it.

Ship Info tab: M4, M5
Power Plant tab: D18, D20, D22
Fuel tab: F25
Weapons tab: N9, Q9
Found two more cells that need commas. On the hull tab, H9 and K10.
 
Back
Top