Re: GURPS Spaceships Design Spreadsheet
 

A late thanks for doing this (I've been away). I can't wait to fiddle with it.

Re: GURPS Spaceships Design Spreadsheet
 

Okay, I see where you added on the design table entries for 1/2 & 1/3 sized systems, but I can't seem to find where you enter exactly what those systems are. It's probably right in front of me, but I can't see it.
BTW, I'm running Open Office 3.3 and I'm pretty sure that I turned on the Macros per your instructions.

Re: GURPS Spaceships Design Spreadsheet
 

I got hung up on that too. After you select the Small Systems module, hit "Refresh Rows" up at the top of the sheet, and the extra rows should appear.

Re: GURPS Spaceships Design Spreadsheet
 

In the current version of the sheet they should pop up automatically, directly beneath the Smaller SM Systems entry. If Macros are working you should be able to hit Refresh Rows to get them to show up.

If you just enabled Macros you may need to close and re-open the sheet to get the automated sheet to work. If Macros aren't working you can still make them show up manually by unhiding the rows.
Tools -> Protect Document -> Sheet... (uncheck)
View -> Column & Row Headers
Then you can select the hidden rows, Right Click and select Show

Re: GURPS Spaceships Design Spreadsheet
 

Nothing seems to be happening. Do the extra rows appear on the design table?

Re: GURPS Spaceships Design Spreadsheet
 

Yes, on the Design Table. Directly below where you'd enter the Smaller SM Systems.

If you click the Optional Rules/Design Table/Campaign Options buttons in the upper-left corner of the sheets does that flip you between the three sheets? If not then Macros probably aren't enabled. You can follow my instructions for manually unhiding the rows or try to get Macros working.

Re: GURPS Spaceships Design Spreadsheet
 

Okay, it seems to be working now. Thanks.

Re: GURPS Spaceships Design Spreadsheet
 

I just uploaded a minor update, so no version increase.
There are two things that changed here:
In Excel:
-The Copy Ship button has been renamed to Import Ship
-The Import Ship window has had a few minor tweaks in appearance and function
In OpenOffice:
-The spreadsheet now has a Security Certificate. If you are not running the sheet from a trusted folder you will be given the option to accept the certificate and enable Macros.

Re: GURPS Spaceships Design Spreadsheet
 

Unless I'm doing it wrong, the ram-rocket option is not affecting the price. I've only tried it with the NTR engine.

Re: GURPS Spaceships Design Spreadsheet
 

It looks like Ionizable Reaction Mass has the same cost as HEDM Rocket Fuel, which it shouldn't.

It also looks like there's a bit of wonkiness with counting up Power Points from smaller subsystems, and counting mps from smaller Fuel Tanks.

Aside from that, the new version 2 looks great! Is there a way to import a version 2 from one sheet to another in Open Office?