Excel Ship Designer v2025.05.03d

[mavikfelna]

Ok, Found a new one. Adding Cabin Space to the Passenger section on the Stateroom tab doesn't show the cost for them on the Summary tab and they are not added to the total cost of the ship. All other type of passenger accommodations show up and are accounted for correctly, I believe.

Additional issue discovered. Sensors are messed up. Improved sensors are giving Civilian grade info, Advanced and Superior are returning #N/A, and on the Secondary sensor list, Military is giving Improved info and Improved is giving Military while Advance is just 0s.

 

[Arkathan]

Hotfix to fix what the last hotfix broke.
2025.05.03b

Eliminated Vlookup from sensors, so they report correctly and don't need "Class I,..." to keep them in alphabetical order
The summary now lists cost of passenger cabin space, and if you toggle Use interplanetary Seating on a small craft, it adds to passenger accommodations

 

[boggo2300]

.

I just wanted to give you a tip of the hat, not only does this very complex spreadsheet work well, it allows building of truly complex ships in accordance to the published rules (something Mongoose doesn't seem to be able to do ) but not only that, it's about the only complex Excel sheet I've ever had work so flawlessly in Libre Office!

 

[Arkathan]

Thanks. I try to stay away from the newer commands so that it will port to the other sheets.

 

[Terry Mixon]

I've still got two multi-variant ships to port and a pile of pods, but I found no errors today. I should wrap up the rest of my ports tomorrow.

 

[boggo2300]

Hmmm using Ship Designer Blank v2025.05.03b, adding Armoured Bulkheads to staterooms gives an Err522 for both cost and space

 

[Arkathan]

Hmmm using Ship Designer Blank v2025.05.03b, adding Armoured Bulkheads to staterooms gives an Err522 for both cost and space

Circular reference. That snuck in when things got moved around for Multiple Multi-Environment boxes. Thanks

2025.05.03c
Stateroom Armored bulkheads no longer adds itself in its calculations.

 

[boggo2300]

Improved and Advanced Auxilliary Sensor arrays have the cost and size screwed up, and I get a Sensors flag on the summary if I have an Improved Primary sensor and a military auxilliary array.

 

[Arkathan]

Improved and Advanced Auxilliary Sensor arrays have the cost and size screwed up, and I get a Sensors flag on the summary if I have an Improved Primary sensor and a military auxilliary array.

I thought I was being clever, switching sensors over to index,match so I could have the names match the book instead of adding class X to put them in alphabetical order.... And completely ignored switching the aux line over. CRS. Hopefully, I'll get to my computer before lunch Eastern US time

 

[Terry Mixon]

I’m waiting for an answer from Mongoose (which may or may not happen) about emergency low berths. @rinku did some research and they’ve always been MCr.1 (a reason to use KCr for sure ) until Mongoose 2e High Guard. We both believe a typo crept in and they are supposed to be KCr100. Just a heads up.

 

[Arkathan]

I’m waiting for an answer from Mongoose (which may or may not happen) about emergency low berths. @rinku did some research and they’ve always been MCr.1 (a reason to use KCr for sure ) until Mongoose 2e High Guard. We both believe a typo crept in and they are supposed to be KCr100. Just a heads up.

Was watching that.

 

[Terry Mixon]

Was watching that.

It would solve people’s comments on how I was able to create robotic emergency low berths for 1/10 the cost of a book unit.

 

[Arkathan]

Improved and Advanced Auxilliary Sensor arrays have the cost and size screwed up, and I get a Sensors flag on the summary if I have an Improved Primary sensor and a military auxilliary array.

2025.05.3d

Fixed Aux sensor problem

 

[Terry Mixon]

The new sensor setup isn't complaining when you get a better (or same) sensor array in the aux position.

 

[Terry Mixon]

I'm also getting a summary error with only the advanced array, no secondary. The ship is TL15, so it shouldn't be throwing an error. And the ship file so you can see it in action.

 

[Terry Mixon]

For those of us (like me) who use batteries for powering the jump drives because the rules say that the power in them is treated as if it comes from the original power source, someone on Farcebook pointed out that the Express Freighter in Traders and Gunboats explicitly uses this hack, so it is now officially legal! They've been watching us.

As this makes sense in all but the smallest of jump ships, it should be used wherever it makes sense in official designs going forward. 15 power points is the break-even spot. If your jump drive uses more than 15 power points, it now makes sense to use batteries to power the jump and reduce the size of the power plant by that amount. a 100-ton J1 ship does not hit that sweet spot, but 100-ton J2 does. 150-ton J1 ships are at that break-even point as well. Basically, if you aren't making a 100-ton J1 ship, you should be using this method.

Tagging @J. L. Brown



Following up on the info in the Farcebook post, it seems this has been explicitly legal since High Guard 2022 Update came out, as the X-Boat does the same thing.


As this makes sense in all but the smallest of jump ships, it should be used wherever it makes sense in official (and private) designs going forward. 15 power points is the break-even spot. If your jump drive uses more than 15 power points (1 ton of power plant), it now makes sense to use batteries to power the jump and reduce the size of the power plant by that amount. A 100-ton J1 ship does not hit that sweet spot, but 100-ton J2 does. 150-ton J1 ships are at that break-even point as well. Basically, if you aren't making a 100-ton J1 ship, you should be using this method.

 

[Arkathan]

I'm also getting a summary error with only the advanced array, no secondary. The ship is TL15, so it shouldn't be throwing an error. And the ship file so you can see it in action.

I don't mind the Main and Aux being the same, even though you can have multiple mains now.
The other was a product of prefacing sensor type with ClassX to keep them in alphabetic order. Allowed the Aux vs Main check to be if Aux > Main then error. With no class 1-5, "None" is "Greater than" "Advanced, alphabetically. That's fixed now.

2025.05.03e

 

[Terry Mixon]

I don't mind the Main and Aux being the same, even though you can have multiple mains now.
The other was a product of prefacing sensor type with ClassX to keep them in alphabetic order. Allowed the Aux vs Main check to be if Aux > Main then error. With no class 1-5, "None" is "Greater than" "Advanced, alphabetically. That's fixed now.

2025.05.03e

I'm not sure why I thought it had to be lesser. Maybe I was conflating it with computers. Thanks.

 

[Terry Mixon]

The error is still there. It looks like it is choking on adding distributed arrays to an advanced system for me as that is when the error appears.

 

[Terry Mixon]

I've narrowed down the error to having advanced sensors, distributed arrays, and hull armor. Weird, but there you are. No armor? No error. Armor, advanced sensors, and distributed arrays? Error.