Excel Ship Designer v2025.04.18

[Hardwire]

The second sounds better but whatever is easier for you for do and yet still accomplish the task.

 

[MasterGwydion]

It sounds like a can of worms (eels?). Each side has points in its favor and I really don't have an opinion one way or the other.

I am with Terry on this one. Both sound good, so I have no opinion either way.

 

[boggo2300]

Is it weird I wanna make Streaker from Startide Rising now?

 

[Arkathan]

This is what I settled on. Have to finish hooking up Errors and set it up in Summary.
Moved Common Area Options, Armoured and EM up for continuity.
Won't need another tab this way.

 

[Terry Mixon]

This is what I settled on. Have to finish hooking up Errors and set it up in Summary.
Moved Common Area Options, Armoured and EM up for continuity.
Won't need another tab this way.

View attachment 4254

Nice!

 

[Hardwire]

This is what I settled on. Have to finish hooking up Errors and set it up in Summary.
Moved Common Area Options, Armoured and EM up for continuity.
Won't need another tab this way.

View attachment 4254

Very nice.

 

[Arkathan]

Extreme Beta Feature
New Version: 2025.04.14

Test of Internal Aquatic and Internal Deepwater
If you don't want to test this feature, wait a few days until we find everything that got broken by putting this in.

 

[Hardwire]

I looked at the new sheet and I do not see the above screen shot on the Staterooms.

 

[Arkathan]

I looked at the new sheet and I do not see the above screen shot on the Staterooms.View attachment 4277

Check your version. I downloaded from the link above and have the correct file.
File name should end in 2025.04.14

Edit: Checked page 1 as well. Correct file there too.

 

[Hardwire]

I downloaded from the link the version that I am using is Ship Designer Blank v2025.04.11 - Fab Mod

 

[Terry Mixon]

I downloaded from the link the version that I am using is Ship Designer Blank v2025.04.11 - Fab Mod

That's not it. The one you need is v2025.04.14,

 

[Arkathan]

New Version 2025.04.18

The Singularity Kickstarter preview adds rules for Luxury passengers. Thanks to Terry for the heads up.
Implemented rules for required steward levels in the Crew Tab
Automated adding required passenger storage in the Cargo Tab.
You can turn it off, but it will glare at you very annoyingly if you do that.

 

[Terry Mixon]

I foresee unrelenting howls of outrage when merchants have to start accounting for the .1 ton per Middle passenger, 1 ton per High passenger, and 2 tons per Luxury passenger cargo allotment. Oh, and the skill level 2 steward that is mandated for EVERY LUXURY STATEROOM (one per) will go over well, too.

While the cargo mandate and steward requirements can be ignored, that still means that ship isn't valid under the rules as written. Fair skies, merchants with lots of passenger cabins hoping to make ends meet with cargo, or with a dozen luxury staterooms needing a Steward 2 to see to each one.

 

[J. L. Brown]

I foresee unrelenting howls of outrage when merchants have to start accounting for the .1 ton per Middle passenger, 1 ton per High passenger, and 2 tons per Luxury passenger cargo allotment. Oh, and the skill level 2 steward that is mandated for EVERY LUXURY STATEROOM (one per) will go over well, too.

While the cargo mandate and steward requirements can be ignored, that still means that ship isn't valid under the rules as written. Fair skies, merchants with lots of passenger cabins hoping to make ends meet with cargo, or with a dozen luxury staterooms needing a Steward 2 to see to each one.

The Stewards (skill 2 = 3000 Cr per four weeks) can ride two to a standard Middle stateroom; plus 1000 Cr per four weeks for an occupied Middle stateroom, plus 1000 Cr each for each crewmember for Life Support. That is 9000 Cr per four weeks, selling just a single J-1 Luxury passage covers it.

 

[Terry Mixon]

The Stewards (skill 2 = 3000 Cr per four weeks) can ride two to a standard Middle stateroom; plus 1000 Cr per four weeks for an occupied Middle stateroom, plus 1000 Cr each for each crewmember for Life Support. That is 9000 Cr per four weeks, selling just a single J-1 Luxury passage covers it.

Yep, but it sure eats into the profit. High passengers suddenly become a lot better deal in quantity.

Or I’m just over reacting.

 

[Arkathan]

File Update
Terry found an error from moving the entertainment above Multi Environment
Also suggested separating passenger storage from internal storage.

This will be included in the next revision, but here is the current file

 

[J. L. Brown]

Yep, but it sure eats into the profit. High passengers suddenly become a lot better deal in quantity.

Or I’m just over reacting.

In High Guard, when crew salaries are listed, it states that higher skilled crew get paid 50% more per level of skill above skill-1. But there seems to be no allowance for higher-skill crew actually doing more (or better). A Engineer with Engineer (Power Plant)-4 still only operates and maintains 35 dTons worth of power plant.

[Edit:] I also miss the 'Crew doing more than one job' rules and salaries. Very handy for ships which are running short-handed. [/Edit]

 

[Arkathan]

In High Guard, when crew salaries are listed, it states that higher skilled crew get paid 50% more per level of skill above skill-1. But there seems to be no allowance for higher-skill crew actually doing more (or better). A Engineer with Engineer (Power Plant)-4 still only operates and maintains 35 dTons worth of power plant.

Correct. They just get better rolls to get things done and avoids Nasty Badnesses.
Which means when you use rules that penalize players for shorting the Engineer pool, they will roll as a lower level Engineer instead of a barely skilled or unskilled one.

 

[Arkathan]

Sorry. Tweak.
Passenger Storage not going away on the Summary when it is zero is bugging me. Had to fix it.

 

[J. L. Brown]

Sorry. Tweak.
Passenger Storage not going away on the Summary when it is zero is bugging me. Had to fix it.

I am getting odd behavior in OpenDocument. Any value in the 'Additional Tons of Fuel' throws an 'Invalid Value' error. Also, I am attempting to put extendable fuel bladders on a ship with External Cargo mounts and Interplanetary Cargo Nets -- but it seems as though the 'fuel' page does not recognize those as cargo space.

I will look to see if this happens in Sheets.... Yes, yes it does.

In GoogleSheets any value in the 'Additional Tons of Fuel' throws a data validation error.
"There was a problem
The data you entered in cell C11 violates the data validation rules set on this cell."

Also, external cargo apparently does not count as cargo space available for fuel. So apparently this is the same in both other spreadsheet programs. I do not have excel, so I cannot check it there.

Also -- is H23 on the Fuel tab supposed to calculate a dTonnage? I added a simple '=C23/100' to that cell, but it seemed blank before.

On both Sheets and OpenDoc, the Fuel tab cell C11 (the 'Additional Tons of Fuel' cell) apparently the validation rule expected a number between 0 and =B1048567. I deleted the 'B' at the beginning, and it worked fine. Added Cargo tab cells 'D11' and 'D12' to the error-detection stuff on the Fuel tab (cells 'T29' & 'T32'). Seems to work fine.