Excel Ship Designer v2025.11.11

[mavikfelna]

Adding Crystaliron armor to standard designs and it seems to be rounding up the tonnage somehow? On each of the designs in the .zip, armor tonnage should be 5 tons , if I read the armor rules right, but it's showing up as 6 tons.

 

[Arkathan]

Adding Crystaliron armor to standard designs and it seems to be rounding up the tonnage somehow? On each of the designs in the .zip, armor tonnage should be 5 tons , if I read the armor rules right, but it's showing up as 6 tons.

Streamlining adds 20% to armor volume.

 

[mavikfelna]

Streamlining adds 20% to armor volume.

I see where it says that for cost, but where does it say it for tonnage?

 

[mavikfelna]

Streamlining adds 20% to armor volume.

Ok, never mind, I was looking at the chart in the CRB, and missed the bigger chart in HG. I see it now. Thank you!

 

[Hootenheimer]

Before I launch into my question, I just way to say that this spreadsheet is tremendous and I want to think everyone who has worked on it.

I have a question for the peanut gallery here; I've tried searching the now 92 pages of this thread and I haven't found an answer.

What is a "Middle Stateroom" that listed on the 11-Staterooms sheet of the workbook? I see the option for "Staterooms" on page 182 of the Core Rulebook, and on page 186 of the Core Rulebook (with an additional reference on page 51 of High Guard) I see the option for High and Luxury Staterooms, but I don't see anything about "Middle" Staterooms.

My understanding is that "regular/plain" Staterooms allow you to book high passengers if you can find them, but High and Luxury staterooms merely give you an added bonus DM when trying to find high passengers. Is that wrong? The profitability sheet of the workbook seems to indicate that if you have a "Middle Stateroom" you're stuck with only recruiting Basic and Middle passengers. That probably also impacts the calculations for passenger cargo too (which I've been setting to "Ignore" since they differ depending on the type of passenger you have in a Stateroom).

That's all. Thanks again for anyone who's ever worked on this spreadsheet, it is outstanding.

 

[Arkathan]

Before I launch into my question, I just way to say that this spreadsheet is tremendous and I want to think everyone who has worked on it.

I have a question for the peanut gallery here; I've tried searching the now 92 pages of this thread and I haven't found an answer.

What is a "Middle Stateroom" that listed on the 11-Staterooms sheet of the workbook? I see the option for "Staterooms" on page 182 of the Core Rulebook, and on page 186 of the Core Rulebook (with an additional reference on page 51 of High Guard) I see the option for High and Luxury Staterooms, but I don't see anything about "Middle" Staterooms.

My understanding is that "regular/plain" Staterooms allow you to book high passengers if you can find them, but High and Luxury staterooms merely give you an added bonus DM when trying to find high passengers. Is that wrong? The profitability sheet of the workbook seems to indicate that if you have a "Middle Stateroom" you're stuck with only recruiting Basic and Middle passengers. That probably also impacts the calculations for passenger cargo too (which I've been setting to "Ignore" since they differ depending on the type of passenger you have in a Stateroom).

That's all. Thanks again for anyone who's ever worked on this spreadsheet, it is outstanding.

Thanks/You're Welcome.
Middle Stateroom is the standard middle passage room, and although you might be able to lure in a High passage on a middle stateroom, this sheet covers design capacities. If you are designing for Middle passage and regular crew, those are the staterooms you build. Anything above that is gravy. Yes that effects the profitability tab, but it again is a design estimate that several players wanted as a quick estimate to benchmark their designs.
Prior to Terry Mixon helping with the passenger cargo calculations and supplies, I used the Internal Storage line for both.

 

[Hootenheimer]

Thanks for the reply and explanation @Arkathan, that cleared things up for me! I have no additional questions, I just want to stress that the work you and @Terry Mixon and anyone else has put in on this spreadsheet has been outstanding and is deeply appreciated.

 

[Terry Mixon]

Thanks for the reply and explanation @Arkathan, that cleared things up for me! I have no additional questions, I just want to stress that the work you and @Terry Mixon and anyone else has put in on this spreadsheet has been outstanding and is deeply appreciated.

Thanks. It's almost all @Arkathan. I've done a bit to help, but only a bit.

 

[Tominator2]

I think I found a problem, but am not sure if it is in the spreadsheet or the rulebook (or me). In High Guard Update 2022, page 64 (Space Stations, step 2), it is stated that a manoeuver drive with Thrust 0 consumes tonnage equal to 0.25% of a space station’s total hull and costs MCr1 per ton. Unfortunately, page 16 of the same book (Ship Design, step 2) states that a manoeuver drive with Thrust 0 consumes tonnage equal to 0.5% of the ships’s total hull and costs MCr2 per ton.

Either the book is inconsistent, or choosing the "Station" option in the spreadsheet does not result in the correct calculation - the Ship values are used regardless of the choice.

 

[Arkathan]

I think I found a problem, but am not sure if it is in the spreadsheet or the rulebook (or me). In High Guard Update 2022, page 64 (Space Stations, step 2), it is stated that a manoeuver drive with Thrust 0 consumes tonnage equal to 0.25% of a space station’s total hull and costs MCr1 per ton. Unfortunately, page 16 of the same book (Ship Design, step 2) states that a manoeuver drive with Thrust 0 consumes tonnage equal to 0.5% of the ships’s total hull and costs MCr2 per ton.

Either the book is inconsistent, or choosing the "Station" option in the spreadsheet does not result in the correct calculation - the Ship values are used regardless of the choice.

No, that was me. I missed coding the reduction in volume.

NEW VERSION 2025.11.11

-Stations now use correct volume for 0 rating M-Drives.'

Thanks, Tominator2

 

[mavikfelna]

So, since I'm updating ships, can we get the small craft in the list updated with the correct prices? Doing it by hand every time is a pain.

 

[Terry Mixon]

So, since I'm updating ships, can we get the small craft in the list updated with the correct prices? Doing it by hand every time is a pain.

I gave the prices in the book. You need to say which are wrong and give the correct numbers from the book itself. Without knowing which are wrong (as in different than the book) that would be a huge undertaking. If the book is wrong, speak to a manager.

 

[Terry Mixon]

Found a glitch. The free airlocks use cell AH33 for validation. It looks like that should be AI33.

 

[Terry Mixon]

Found another glitch. The page total cost on the 9B - Optional tab doesn't include the manufacturing section at the bottom.

 

[Terry Mixon]

Found another one. The Crew Robot Slots (cell D67) on the 9B - Options tab points at cell '10-Crew'!U65. It should point at '10-Crew'!U63. Also, there is a gap at row 54 in the tally of slots on the target side.

 

[mavikfelna]

I gave the prices in the book. You need to say which are wrong and give the correct numbers from the book itself. Without knowing which are wrong (as in different than the book) that would be a huge undertaking. If the book is wrong, speak to a manager.

I will gladly supply the list. There are also multiples of some of some of the designs that don't have multiples on the list, despite being slightly different builds between CRB and HG. How do you want the list, in spreadsheet form with just model and price?

 

[Terry Mixon]

I will gladly supply the list. There are also multiples of some of some of the designs that don't have multiples on the list, despite being slightly different builds between CRB and HG. How do you want the list, in spreadsheet form with just model and price?

That’s for @Arkathan to say. Have fun storming the castle.