Excel Ship Designer v2025.05.31

[mavikfelna]

Since there are official module designs that have power plants, see Cold Passenger module in the Small Craft Catalogue fo my immediate concern, can we at least get a toggle on that page like on the computer page? That, along with this new knowledge about the computer page, solves most of my current problems with module redesigns of the official stuff.
Thank you for all the support and interaction. I appreciate you taking the time to address my many questions.

And maybe a similar toggle option for Maneuver 0 drives since I'm asking.

 

[Terry Mixon]

And maybe a similar toggle option for Maneuver 0 drives since I'm asking.

If pods can't have them, why should modules? Though if modules get them, pods should too.

 

[mavikfelna]

If pods can't have them, why should modules? Though if modules get them, pods should too.

See the Orbital Outpost Module in the Small Ships Catalogue for the reason I am asking I'm all for pods getting the same option.

 

[Arkathan]

See the Orbital Outpost Module in the Small Ships Catalogue for the reason I am asking I'm all for pods getting the same option.

That thing SHOULD have been built as a station and used as Cargo that fits into a stripped Cutter module bay.
It is an independent entity, not a true module, dependent upon the ship for operations.

 

[Arkathan]

Minor update 2025.05.01b

-Toggle to allow illegal power plants on design-rule non-compliant, but nonetheless official modules.

No. I'm not being passive-aggressive. Why do you ask?

 

[Terry Mixon]

Looks like weapons in a firmpoint cannot be reduced in size. I know that turret weapons cannot be reduced in size, but should that apply to a firmpoint?

 

[Terry Mixon]

Follow up. No tonnage? If so, that explains the no size reduction.

 

[Arkathan]

Looks like weapons in a firmpoint cannot be reduced in size. I know that turret weapons cannot be reduced in size, but should that apply to a firmpoint?

View attachment 4722

View attachment 4721

Why pay extra to reduce the size of something that takes up no internal volume?

 

[Terry Mixon]

I think the interplanetary seating is still messed up. I have two crew in a dual cockpit and 10 marines on three acceleration benches for a boarding pod, but I get red on accommodations even with the "use interplanetary seating" toggle set to yes. It works for seats, though.

 

[Terry Mixon]

Found the error. The formula is looking at units not people.

=IF(C4=S2,SUM(D2233),SUM('9b-Optional'!C121:C124,D2233))+IF(C3="No",0,SUM(D2233,C7,C15:C17))

Should be:

=IF(C4=S2,SUM(D2233),SUM('9b-Optional'!C121:C124,D2233))+IF(C3="No",0,SUM(D2233,C7,D1517))

Edit: Stupid happy faces.

 

[mavikfelna]

Trying to add one of Terry's AutoBerth Cluster's to a module and the Life Support cost on the Ship Expenses is way off. It should be 7500 with a cost per ton of 300, and 2500 with a cost per ton of 100. 25 units of clusters are in the design with no other stateroom items so no other life support costs.

 

[Terry Mixon]

And accommodated should be 14 by the formula. 2 crew in the cockpit and 12 in seating. It only shows 12 though. I now they are accounted for in the cockpit, I'm only commenting on the formula and its odd behavior. If I take C7 out, the number doesn't change even though there are 2 in C7.

 

[Arkathan]

Fixing the Fix - 2025.05.01c
Because My Myopic buttocks cannot tell the difference between the quantity column and the accommodated column.

 

[Arkathan]

Found the error. The formula is looking at units not people.

=IF(C4=S2,SUM(D2233),SUM('9b-Optional'!C121:C124,D2233))+IF(C3="No",0,SUM(D2233,C7,C15:C17))

Should be:

=IF(C4=S2,SUM(D2233),SUM('9b-Optional'!C121:C124,D2233))+IF(C3="No",0,SUM(D2233,C7,D1517))

Edit: Stupid happy faces.

Yeah, I was changing it as you were typing that

 

[Terry Mixon]

Yeah, I was changing it as you were typing that

The formula includes C7 even though that is taken care of in the cockpit cell. In my example, even though C7 has a value of 2, it doesn't change the number and removing C7 from the end of the formula doesn't change the output. You might want to see if C7 belongs there.

 

[Terry Mixon]

That's mighty generous of no bridge to seat two.

 

[Terry Mixon]

=SUM(D2233)+C7+SUM(D1517) gets 14 rather than 12. Something about pilling all the sums in one place messed the original formula up. C7 should still come out.

 

[Arkathan]

View attachment 4729

That's mighty generous of no bridge to seat two.

I saw that and had a similar reaction.

 

[mavikfelna]

Fixing the Fix - 2025.05.01c
Because My Myopic buttocks cannot tell the difference between the quantity column and the accommodated column.

Ok, just tested with the c version and it's giving me the same wrong numbers for the life support cost.

 

[Terry Mixon]

More funkiness from that original formula. It is double counting people in barracks (and other crew accommodations) while interplanetary counting is set to yes. I put my amended formula in the cell next to what you have to show the difference.