GURPS Spaceships Design Spreadsheet

[Tzeentch]

If so, then the way you are calculating remaining habitat spaces is probably broken.

You seem to adjusting the steerage cargo values in Habitats!A13 which is why I was wondering.

[ericbsmith]

Originally Posted by Tzeentch

If so, then the way you are calculating remaining habitat spaces is probably broken.

I'm not sure what you're seeing, but it looks right to me. Can you provide me with some solid examples?

Originally Posted by Tzeentch

You seem to adjusting the steerage cargo values in Habitats!A13 which is why I was wondering.

Habitats column A is just a lookup value.

All Habitat modules take up a variable number of slots depending on which life support option you select. The adjustment moves the lookup value over one or two columns. depending on whether you selected Normal life support, Magic/No Life Support, or NBC.

I had that system in place when the Magic option was introduced; it was easier to adjust the number of cabins a Steerage Cargo took up than to adjust it's capacity, so that's what I did.

[Tzeentch]

Sure, I'm checking the Medusa from Pyramid 3-34 and using your sheet to also check my own sheet.

Central Habitat is Habitat (3 ops centers, 10 sickbay, 20 cabins, 24 bunkrooms, 18 tons cargo).
-- 60 x1.5 cabin units because of NBC Filter Only. 90 cabin equivalent units.

30 ops center
10 sickbay
20 cabins
24 bunkrooms
6 steerage

-- On your sheet everything is fine but the steerage, which comes out to 30 tons cargo and -3 unused cabins if you put in 6 steerage. Using your Steerage Cargo: Partial also does not give you the correct results (and is far harder to parse from existing designs anyways so I would rather just use the rules as written).


-- Also, you list water speeds as mph but those are given as yards per second in the rules.

[ericbsmith]

Version 1.38
-Fixed bug where all the Ground and Water propulsion systems from Pyramid #3/34 Alternate GURPS incorrectly had their Speed and Acceleration listed as mph or mph/s instead of yps and yps/s
-Addressed some issues with Habitat modules when using Life Support Options
-Added a few more Mixed Battery options (there's now one for each combination of Med/Sec/Tert/Per)
-Tweaked the number of Peripheral Mounts in most Mixed Batteries downward slightly (to ~20% instead of 33% for most)

[Tzeentch]

-- Thank ya! Your sheet has been been extremely useful in checking my own, and for use as another set of "eyes" on designs.

[Dammann]

I am having an issue. I looked through this thread, but maybe I missed something that other people have encountered.

When I use the blank sheet, I enter my design information and everything works just fine. But after I save as "S.S. Whatever," close it, and re-open, the Design Features, Switches, & Notes section shows an Err:511.

Anyone know what the heck is going on with that?

[ericbsmith]

Originally Posted by Dammann

Anyone know what the heck is going on with that?

Looks like there is a bug in the Stardrive (Reactionless) section of the Ship Options display which only shows up if you save then reopen or if you select a Stardrive (Reactionless) option. I've just uploaded the fixed sheet.


Version 1.39
-Fixed bug with Stardrive (Reactionless) option and Ship Options display.

[Dammann]

Had to go looking for this thread- the forum's been busy!

Thanks, Eric! This spreadsheet is so handy, I'm truly grateful for the work you put into it.

[Pragmatic]

Originally Posted by Dammann

Had to go looking for this thread- the forum's been busy!

At the top of the thread is a link for Thread Tools (under the page numbers, on the right). One of them is "Subscribe to the Thread." I generally choose "no email," so I don't get flooded.

Then, whenever you log on, just click on "User Settings." It'll bring up all the subscribed threads that have been recently active. (Since the last time you looked in the thread, at least.)

[flyingwombat]

WE downloaded the spreadsheet with macros, but the macros can't be found on my wife's Mac who has Excel.

Meanwhile...
I use Open Office. I had downloaded the spreadsheet earlier this year. I noticed it was version 1.27. So I downloaded 1.39 about 30 minutes ago. But all the ship systems are missing.