GURPS Spaceships Design Spreadsheet

[ericbsmith]

Originally Posted by jmurrell

Having an issue with assigning auxiliary craft. I have a SM+9 ship with a SM+8 hanger (30 ton capacity) but I can only load SM+4/10 ton craft into it. None of the SM+5/30 ton craft show up as an option.

Your issue is likely with the bay doors. A SM+8 Hangar has a bay door only big enough for a SM+4 craft (even if it, technically, has the storage capacity for a SM+5 craft). See Hangar Bay Doors, p. 43 of Spaceships 1.

EDIT: While I'm here, has anyone that had problems with the Excel Macros tested it in Excel 2010/11/12 yet?

[Adina]

Originally Posted by ericbsmith

Your issue is likely with the bay doors. A SM+8 Hangar has a bay door only big enough for a SM+4 craft (even if it, technically, has the storage capacity for a SM+5 craft). See Hangar Bay Doors, p. 43 of Spaceships 1.

Any workarounds for that?

[ericbsmith]

Temporarily increase the SM of the ship, add the Aux Craft you want, then set the ship back to SM+9.

[SCAR]

Originally Posted by ericbsmith

Your issue is likely with the bay doors. A SM+8 Hangar has a bay door only big enough for a SM+4 craft (even if it, technically, has the storage capacity for a SM+5 craft). See Hangar Bay Doors, p. 43 of Spaceships 1.

EDIT: While I'm here, has anyone that had problems with the Excel Macros tested it in Excel 2010/11/12 yet?

How does this interact with an Optimized Hangar Bay (SS4.p38), which specifically allows the Hangar to be optimised for craft of -3.SM. So an SM+8 Hanger (Optimized for SM+5), technically can't work because the Hangar Bay Doors aren't big enough!

[Adina]

Originally Posted by ericbsmith

Temporarily increase the SM of the ship, add the Aux Craft you want, then set the ship back to SM+9.

That works, thanks.

[ericbsmith]

Originally Posted by SCAR

How does this interact with an Optimized Hangar Bay (SS4.p38), which specifically allows the Hangar to be optimised for craft of -3.SM. So an SM+8 Hanger (Optimized for SM+5), technically can't work because the Hangar Bay Doors aren't big enough!

Yeah, you're right. It seems that the rules for Optimized Hangar Bays should supersede the rules for Hangar Bay Door size. Looks like I'm going to have to do some work to fix that.

[SCAR]

Originally Posted by ericbsmith

Yeah, you're right. It seems that the rules for Optimized Hangar Bays should supersede the rules for Hangar Bay Door size. Looks like I'm going to have to do some work to fix that.

I had never noticed this before, and I've built a load of spaceships, and juggled through the build mechanics a lot.

Additionally, if an Optimised Hangar Bay can have a -3.SM Hangar Door, then there seems to be no reason for a standard Hangar Bay not to have the same sized door. Both can still have whatever SM vessels fit in the bay, it's just the the launch rates which are different!

-3.SM is the actual size of a single Hangar Bay system, so it's just 1 step bigger than listed on Spaceships.p43, and 3+ Bays is effectively an additional +1 to SM, so I think I'm inclined to consider the maximum SM object through a hangar bay door to be an errata, and to just increase them by 1. Doesn't seem to obviously break anything else.

[sayke]

ericbsmith - latest built works! office 11, os x 10.9 =) thank you very much!

[Onkl]

Your sheet is fantastic Eric, thanks.

It seems I have run into a problem though... I use Open Office 3.3 and your 2.0 RC8 Sheet.

I've enabled Macros by trusting the path I saved the file under.

My problem is concerning deleting Space Ships in the saved tab. I would like to have only the ones present I want to use in my campaign.

what is the simplest way to accomplish this?

When I try to select one in the Saved Ships tab in the Ship to Load/Delete: Field, it tells me "Protected Cells can not be modified". Yes, I do click in the gray area and try to choose from the drop down.

If you could please help me, it would be appreciated.

Cheers!

Onkl

[ericbsmith]

Originally Posted by Onkl

When I try to select one in the Saved Ships tab in the Ship to Load/Delete: Field, it tells me "Protected Cells can not be modified". Yes, I do click in the gray area and try to choose from the drop down.

That's an oversight. Select the Saved Ships Sheet, go to Tools -> Protect Document -> Sheet (selecting Sheet should uncheck it in the menu). Then you may select the Ship to Load/Delete drop-down cell and go to Format -> Cells -> Cell Protection (tab) and uncheck the Protected checkbox.

Note that you can also include a tag in the Page field of the ships that you're creating. After that you can put that same tag in the Name Filter and only your ships will show up (this even filters the drop-down menus in the Saved Sheet, though all will be available from the drop-down menus of the Design Table). This shows up best in the Official Ships sheet, where you can put in something like SS4 or SS8 and filter out the ships from that specific volume.