Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

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

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.

Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

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)

Re: GURPS Spaceships Design Spreadsheet
 

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

Re: GURPS Spaceships Design Spreadsheet
 

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?

Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

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.)

Re: GURPS Spaceships Design Spreadsheet
 

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.