Excel Ship Designer v2025.04.03

[Hardwire]

Thanks

 

[shirgall]

Thanks for the updates!

The only custom area in the stateroom tab is for multi environmental spaces.

So I was definitely not doing it correctly.

I fixed the tooltip, leftover from HG16.

Implemented a way to upgrade beds in your medbays to TL13-15 Autodocs. It will throw an error if you try to convert too many.
Since the medium stateroom takes up as much room as a medbay, and you've already done it, convert the room to a med bay, then you can upgrade to an autodoc. The refit rules allow it, and you'd just be retconning what you call it, right?

Working on allowing upgrading of the low berths in the Stateroom tab, then I'll release it.

Cool, this is good, and really quick work. I will only have to house rule one piece, the TL12 Scout stateroom they are using can only have one bed with a modified TL13 basic Autodoc in this space. This works well for my game.

 

[Terry Mixon]

Thanks for the updates!



So I was definitely not doing it correctly.



Cool, this is good, and really quick work. I will only have to house rule one piece, the TL12 Scout stateroom they are using can only have one bed with a modified TL13 basic Autodoc in this space. This works well for my game.

You don't even have to house rule it. Only buy one autodoc and that covers it. The two extra beds in a medbay aren't listed on the sheet after all.

 

[AndrewW]

What book is hull option Hostile Environment Operations Package I don't seem to find it and would like to know more about it

The Great Rift book 4, page: 23

 

[Arkathan]

Added Advanced Low Berths from the Robot Handbook to Low Berth upgrades in the Stateroom Tab
Thanks Terry.

 

[Hardwire]

The Great Rift book 4, page: 23

Yep found it thanks

 

[DigrizJB]

Added Advanced Low Berths from the Robot Handbook to Low Berth upgrades in the Stateroom Tab
Thanks Terry.

Thank You again...

 

[Arkathan]

New Version: 2025.03.27

Added vehicles from Reach Adventure #9. Thanks Terry.

 

[boggo2300]

Am I wrong, or should the formula in cell C6 of sheet 11-Staterooms be

=IF(C4=S2,SUM(D21:D30),SUM($'9b-Optional'.C92:C95,D21:D30))+IF(C3=S2,0,C7+(SUM(D15:D17)))

to get the desired result?

Though that may be something only required for Libre Office to work correctly, not sure, haven't used Excel since 2018.

 

[Arkathan]

Am I wrong, or should the formula in cell C6 of sheet 11-Staterooms be

=IF(C4=S2,SUM(D21:D30),SUM($'9b-Optional'.C92:C95,D21:D30))+IF(C3=S2,0,C7+(SUM(D15:D17)))

to get the desired result?

Though that may be something only required for Libre Office to work correctly, not sure, haven't used Excel since 2018.

You may be working off an old version.
D21 is common areas now.
'9b-Optional'. might be specific to Libre Office.
'9b-Optional'! is what I have to use. Hopefully, Libre Office automatically converts, because there are an awful lot of cross tab references.

 

[boggo2300]

You may be working off an old version.
D21 is common areas now.
'9b-Optional'. might be specific to Libre Office.
'9b-Optional'! is what I have to use. Hopefully, Libre Office automatically converts, because there are an awful lot of cross tab references.

Ship Designer Blank v2025.03.22.xlsx is the version I'm looking at. the first part with residentials was working fine, it was the second part for smallcraft cabins that was always returning 0

 

[Arkathan]

Ship Designer Blank v2025.03.22.xlsx is the version I'm looking at. the first part with residentials was working fine, it was the second part for smallcraft cabins that was always returning 0

Small craft cabins are now C7. The two (C6 & C7) are now added in error checking.

 

[hopsnbaer]

bump

 

[Arkathan]

New Version 2025.04.03

Terry discovered that the stealth tonnage was reporting as Adjustable Hull. Fixed.

Note that this only affected the Summary, not the actual ship calculations.