GURPS Spaceships Design Spreadsheet - Page 35

davester65 · 03-30-2012, 09:49 PM

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

davester65 · 03-30-2012, 10:37 PM

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.

vierasmarius · 03-30-2012, 10:39 PM

Quote:

Originally Posted by davester65

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.

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.

ericbsmith · 03-30-2012, 10:50 PM

Quote:

Originally Posted by davester65

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.

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

davester65 · 03-30-2012, 10:55 PM

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

ericbsmith · 03-30-2012, 10:58 PM

Quote:

Originally Posted by davester65

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

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.

davester65 · 03-30-2012, 11:04 PM

Okay, it seems to be working now. Thanks.

ericbsmith · 03-31-2012, 03:44 AM

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.

Snoman314 · 03-31-2012, 05:46 AM

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

DemiBenson · 03-31-2012, 11:24 PM

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?

03-30-2012, 09:49 PM	#341
davester65 Join Date: May 2009	Re: GURPS Spaceships Design Spreadsheet A late thanks for doing this (I've been away). I can't wait to fiddle with it.

03-30-2012, 10:37 PM	#342
davester65 Join Date: May 2009	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.

03-30-2012, 10:55 PM	#345
davester65 Join Date: May 2009	Re: GURPS Spaceships Design Spreadsheet Nothing seems to be happening. Do the extra rows appear on the design table?

03-30-2012, 11:04 PM	#347
davester65 Join Date: May 2009	Re: GURPS Spaceships Design Spreadsheet Okay, it seems to be working now. Thanks.

03-31-2012, 03:44 AM	#348
ericbsmith Join Date: Aug 2004 Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.	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. __________________ Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya.

03-31-2012, 05:46 AM	#349
Snoman314 Join Date: Sep 2009	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.

03-31-2012, 11:24 PM	#350
DemiBenson Join Date: Aug 2007 Location: Boston, Hub of the Universe!	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? __________________ Demi Benson