GURPS Spaceships Design Spreadsheet

[jacobmuller]

Okay, first time I've seen GURPSLand...
{puppy wags tail sooo hard he falls over}
TQ

[ericbsmith]

Originally Posted by scc

V80 and AA80, right?

No, those only work with Macros enabled and may be a bit flakey with OpenOffice/Libre Office. You want to use B254 & AN254

[ericbsmith]

Just did a minor update correcting Campaign Fuel Cost Multiplier issue. Also changed a capability in the OpenOffice sheet as follows:

-In Excel w/Macros you may now change the Ship System, SM, or TL from the System Options section as well as from the Spacecraft Design Table section. This requires use of Macros to copy the changes to multiple cells, so Macros must be enabled. This proved to be buggy/slow in OpenOffice, so is disabled for now.

[Snoman314]

Originally Posted by ericbsmith

Just did a minor update correcting Campaign Fuel Cost Multiplier issue. Also changed a capability in the OpenOffice sheet as follows:

-In Excel w/Macros you may now change the Ship System, SM, or TL from the System Options section as well as from the Spacecraft Design Table section. This requires use of Macros to copy the changes to multiple cells, so Macros must be enabled. This proved to be buggy/slow in OpenOffice, so is disabled for now.

Awesome turnaround! I can now put in a cost modifier for fuel on the campaign settings and it comes out correct on the design page. However, the modified cost on the campaign settings page is incorrect, despite coming out correct on the design page.
Secondly, All the systems are consistently coming up as $0. I'm using the Rules from Spaceships 7, the Pyramid Articles, and the Unofficial Systems & Rules.

[ericbsmith]

In the OpenOffice version the Campaign Cost Multiplier seems to have accidentally been set to 0 (Campaign Options, Left most column, bottom entry). Resetting the Campaign Options via the Button seems to incorrectly default it to 0. Set it to 1 and the issue should go away. I'm going to upload a sheet with the Reset Campaign Options fixed as well as the default set to 1 upon opening the file.

[Snoman314]

Originally Posted by ericbsmith

In the OpenOffice version the Campaign Cost Multiplier seems to have accidentally been set to 0 (Campaign Options, Left most column, bottom entry). Resetting the Campaign Options via the Button seems to incorrectly default it to 0. Set it to 1 and the issue should go away. I'm going to upload a sheet with the Reset Campaign Options fixed as well as the default set to 1 upon opening the file.

Ah! I see, thanks!

[scc]

About PK's Vehicle Docks, is there a thread somewhere for them? They sort of itch (I get WHY they only use the standard instead of an enhanced cargo capacity, but why do they need crew?)

Addmendum: When trying to save (Note: I have downloaded to patched version) I get an error about a bad URL and this line is highlighted in the de-bugger that pops up: ToFile = Stardesktop.loadComponentFromURL(ToFilePathName, "_default", 0, Array())
Using OOo 3.2 portable

[ericbsmith]

Originally Posted by scc

About PK's Vehicle Docks, is there a thread somewhere for them? They sort of itch (I get WHY they only use the standard instead of an enhanced cargo capacity, but why do they need crew?)

AFAIK there's no discussion on them, but I'd expect they probably have Workspaces for the same reason that Hangar Bays need crew - to maintain the attached vessels (which are usually short duration "shuttles" or "fighters").

Originally Posted by scc

Addmendum: When trying to save (Note: I have downloaded to patched version) I get an error about a bad URL and this line is highlighted in the de-bugger that pops up: ToFile = Stardesktop.loadComponentFromURL(ToFilePathName, "_default", 0, Array())
Using OOo 3.2 portable

The sad thing is I know exactly what is causing this error because I've now corrected it three times. I have no idea how the code has reverted on me, but this is getting annoying :-(

Anyway, I've just posted a fixed version of the sheet which should work correctly now.

[scc]

Oh, eric, one more thing, you've got equipment packs implemented wrong, you get ONE system a SM smaller then your ship, not one the same size

[ericbsmith]

Originally Posted by scc

Oh, eric, one more thing, you've got equipment packs implemented wrong, you get ONE system a SM smaller then your ship, not one the same size

From my reading you can attach 1 to 3 systems that are a SM smaller than the ship to a specific location, and they can be combined - meaning you can effectively get one system of the same SM of the ship. This can be important for some systems that can't combine to form a single system that is one SM larger (such as Weapon Batteries).

At any rate, if you select Equip. Pack-(1) you get a full sized system, but if you select Equip. Pack-1 you get a Smaller SM System, and Pack-2 and Pack-3 gives two and three Smaller SM Systems.