GURPS Spaceships Design Spreadsheet

[thesmiths4]

Sorry if I missed this in the stack of posts, but have you ever considered modding the sheet for the Gurps Vorkosigan ship design rules? (Necklin Rods, different weapons and shield systems, etc.)

[ericbsmith]

Version 1.36a
-Incorporated Rev. Pee Kitty's rules for using GURPS Spaceships with GURPS Traveller
-Fixed label display bug with Hydrocarbon Fuel Tank
-Fixed label display bug with Mixed Peripheral Weapon Battery Mounts

[DaltonS]

In order to use the spreadsheet to design buildings (as per Pyramid 3-34), I'd like to see the following options added:

1. A switch for "Vertical Design" that would change the hull section labels from "Front", "Center" and "Rear" to "Upper", "Middle" and "Lower" respectively.
2. When the above switch is on, a new "Basement" option for the "Lower Hull" systems to add $1000/system ton to the cost.

Dalton "the secret headquarters architect" Spence

[ericbsmith]

Version 1.37b
-Added option for 'Orientation Design Options' (Vertical, Horizontal, Building, Building w/Basement)
-Moved the 'Campaign Options' checkboxes down and to the right (I was running out of room, had to put them somewhere)
-Corrected bug with Campaign Stardrive '(Reactionless)' option
-Added Structural Reinforcement system (each system doubles dHP)
-Corrected some SM issues with the Armor/Volume rules

[SalsaDoom]

Hi fellas,

Thanks again to Eric! He's the reason gurps spaceships is good.

But I wanted to ask. I never did figure out a way to add modules to the system. It seems every time I build a ship I end up needing at least one module not existing anywhere. How is this done exactly?

Cheers!

[ericbsmith]

In the current version of the sheet there isn't a way to add custom modules. I had played around with the idea, but it never came to fruition. Likely, if I ever get back to the v2.0 of the sheet I'll add the capability to create custom modules.

[ericbsmith]

Version 2.00 Beta 1
This version represents a considerable overhaul of the spreadsheet. One of the primary goals of this overhaul was to make it feasible to incorporate Smaller SM Systems and Reconfigurable Systems. Other goals were to redesign the GUI streamlining the Design Table to do away with the Vertical Scrolling. A side effect of this was to eliminate the second ship.

Smaller SM and Reconfigurable Systems are only available in two- and three- unit systems. So you can have Half-Sized Systems, SM-1 Systems, double-Reconfigurable Systems and triple-Reconfigurable systems. I have no plans to expand beyond this, as that would just about triple the size and complexity of the sheet for very little gain.

In order to use Smaller SM Systems and Reconfigurable Systems the collapsing/expansion of hidden rows has become a necessity, which also makes Macros a necessity.
As with the previous version, the two Excel versions use an automated Core Macro which will adjust the hidden rows when the sheet has been changed and showing those rows is necessary. There is still a checkbox to disable the Core Macro, and a new button to Refresh Rows which you can use to show those hidden rows as needed.
New in this version of the OpenOffice sheet the Refresh Rows button now has a Macro assigned to it that will show/hide the hidden rows as well. You will need to use it any time you add (or remove) a Smaller SM/Reconfigurable system.

Macros and Security
Excel 2000, Excel 2007, and OpenOffice all have different methods of handling Macro security. You will need to adjust these settings in order to properly use the Macros:

Excel 2000
When you first open the sheet a Security Warning will pop up; click the "Always trust macros from this source." checkbox then the Enable Macros button.
You can later remove or adjust the settings by going to:
Tools -> Macros -> Security -> Trusted Sources (tab)

Excel 2007
Office Button (upper left corner) -> Excel Options -> Trust Center (left pane) -> Trust Center Settings (right pane button) -> Trusted Locations (left pane) -> Add new location... (right pane button)
Add the folder in which you've saved the Spreadsheet to the Trusted Locations.

OpenOffice
Tools -> Options -> OpenOffice.org (left pane menu section) -> Security (menu sub-section) -> Macro Security (Button) -> Trusted Sources (Tab)
In the bottom section click Add... and add the folder in which you've saved the Spreadsheet to the Trusted Locations.




This sheet was a branch off of Version 1.26. Many of the changes and corrections I've made since then had to be reincorporated into this sheet. I'm considering this a Beta release because of the large number of things that could have been messed up or that I could have forgotten to hook up along the way. I've now reached a point where I can't see any obvious bugs, so I'm releasing the beta to let you guys find them for me :-)

Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (1.86MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (771KB)

Excel 2007
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (2.30MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (2.23MB)

OpenOffice 3.3.0
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (1.61MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (1.37MB)

[vierasmarius]

Originally Posted by ericbsmith

Version 2.00 Beta 1
This version represents a considerable overhaul of the spreadsheet. One of the primary goals of this overhaul was to make it feasible to incorporate Smaller SM Systems and Reconfigurable Systems. Other goals were to redesign the GUI streamlining the Design Table to do away with the Vertical Scrolling. A side effect of this was to eliminate the second ship.

YES YES YES! Oh, you have made me so happy... Hopefully the macros will work with my Open Office.

[ericbsmith]

Originally Posted by vierasmarius

YES YES YES! Oh, you have made me so happy... Hopefully the macros will work with my Open Office.

The Refresh Rows button should work, as I've tested it and it works fine. You'll probably have to adjust security settings to allow Macros in your save folder (which is true for Office 2007 as well)

If not you can manually unhide rows, but that gets annoying, which is why I like macros :-)

[vierasmarius]

Originally Posted by ericbsmith

The Refresh Rows button should work, as I've tested it and it works fine. You'll probably have to adjust security settings to allow Macros in your save folder (which is true for Office 2007 as well)

If not you can manually unhide rows, but that gets annoying, which is why I like macros :-)

Yeah, I remember with the prior version that the Macros didn't seem to work. Where do I find the security settings, and is there a particular setting that works best?