GURPS Spaceships Design Spreadsheet

[ericbsmith]

This tread is intended to be a place for discussion of and notifications for my spreadsheet. Please keep posts on this topic; if you have other Spaceships related questions/topics feel free to start your own thread.

The GURPS Spaceships Design Spreadsheet is a pretty sophisticated spreadsheet which contains almost everything from the Spaceship series of books. The way I designed the sheet you can duplicate the Design Table worksheet to create more ships within the same spreadsheet or duplicate the Saved Ships sheets to better organize saved ships. The only options that carry over to all ships are those designated as Campaign Options.

This is still a work in progress. If you find any significant errors, or have any suggestions for improvements, please post them!

A few notes: The spreadsheet contains several worksheets, three of which are visible to the user. Optional Rules contains write-ups for several new systems, habitats, and rules which can be turned off if desired. Campaign Options contains a place to set Design Switches & Features that apply to all ships you design with the spreadsheet as well as allowing you to Filter out ship systems, Habitats, or Weapons you don't wish to use in your designs. Design Table contains a work area to create two spaceships and print them out. This worksheet is completely self contained - so you can copy this worksheet (by right-clicking on the tab for it and selecting copy) to create even more ships within a single spreadsheet.

Macros

The spreadsheet is written in Excel 2000, but is fully compatible with OpenOffice v3.3.0. It has been tested to work in OpenOffice v3.2 Portable, OpenOffice v3.4.x, and LibreOffice v4, all of which are completely free to download (see below). The spreadsheet makes use of many Macros -- most of these Macros have now been ported over to work in OpenOffice (but some run slow as nails in OpenOffice v3.4.x and LibreOffice v4).

I've created a Self-Signed Security Certificate for the Macros in both Excel and Open Office. Obviously not the most secure, but if you trust me that shouldn't be a problem. The Macros do add significant functionality to the sheet which cannot be attained any other way, allowing it to automatically show or hide rows as needed. To enable Macros you either need to accept the Certificate or create a Security exception for the save folder you have placed the spreadsheet in.

In OpenOffice you can can create a Security Exception under:
Tools -> Options -> Security -> Macro Security (button) -> Trusted Sources (tab) -> Trusted file locations (Add button)

In Microsoft Office 2007 you can create a Security Exception under:
Office Button (top-left corner) -> Excel Options (button) -> Trust Center -> Trust Center Settings (button) -> Trusted Locations

In Office 2000 you cannot set a Trusted location, but instead must accept the Certificate to enable Macros.


This spreadsheet may have issues with Regional Settings other than English (USA) - in particular those regions where a comma is used for a decimal separator instead of a period.


Download
There's a sample output PDF here.
Here's a blank worksheet, good for printing out and filling in by hand.
Daniel N. Smith has made up a very good Spaceship Worksheet which you can find in this thread.


You can download the spreadsheet here:

Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (3.37 MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (1.58 MB)

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

Excel 2007 No Macro
http://gurpsland.no-ip.org/zip/Space...007NoMacro.zip (4.32MB)
http://gurpsland.no-ip.org/zip/Space...2007NoMacro.7z (3.85MB)

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

Here's a PDF of the optional rules I incorporate into the spreadsheet (these options can be turned off from within the spreadsheet).:
http://gurpsland.no-ip.org/pdf/Space...ionalRules.pdf


OpenOffice / LibreOffice
OpenOffice v3.2.0 Portable
OpenOffice v3.3.0
OpenOffice v3.4.x
LibreOffice v4

Version History
Version 2.0 Release Candidate 21
V2.0 RC20
v2.0 RC19
v2.0 RC18
v2.0 RC17
v2.0 RC16
v2.0 RC15
v2.0 RC14
v2.0 RC13
v2.0 RC12
v2.0 RC11
v2.0 RC10
v2.0 RC9
v2.0 RC8
v2.0 RC7
-Macro compatibility with OpenOffice.
v2.0 RC6
v2.0 RC5
v2.0 RC4
v2.0 RC3
v2.0 RC2
v2.0 RC1
- This version marks a complete redesign of the sheet.

v1.40c

[sjard]

Have you considered putting together a simple pdf worksheet form for those of us who don't particularly like spreadsheets?

[ericbsmith]

Originally Posted by sjard

Have you considered putting together a simple pdf worksheet form for those of us who don't particularly like spreadsheets?

Nope. I've never even created a PDF worksheet.

What do you dislike about spreadsheets? Because I've designed this one to have a very user friendly interface - it looks (and acts) more like a program than a spreadsheet. You select TL, SM, and the 20 ship systems from drop down menus, then fill in checkboxes for the various ship options, design switches, etc. You can fill in the entire thing with mouse clicks - no need to enter any data except the ship name, and no need to go mucking about with formulas and the like. That's already been done for you (by ME! ugh... I spent way too much time on this thing ;-).

[sjard]

Originally Posted by ericbsmith

What do you dislike about spreadsheets?

I can't print it out and use it away from a computer. That is pretty much my only problem with that sort of generation system.

[ericbsmith]

Originally Posted by sjard

I can't print it out and use it away from a computer. That is pretty much my only problem with that sort of generation system.

My spreadsheet, if left blank, works as a pretty decent worksheet once printed. If all you want is a blank PDF that's not that hard; when you said "pdf worksheet" I had assumed you meant one of the PDFs which can be filled in by a user.

[sjard]

Originally Posted by ericbsmith

I had assumed you meant one of the PDFs which can be filled in by a user.

No, I was meaning a pdf format of a form to print out. Sort of like a record sheet.

[ericbsmith]

Here's a blank worksheet PDF, good for printing out and filling in by hand.

[sjard]

Originally Posted by ericbsmith

Here's a blank worksheet PDF, good for printing out and filling in by hand.

Cool, Thanks.

[Shrale]

Originally Posted by sjard

No, I was meaning a pdf format of a form to print out. Sort of like a record sheet.

Good idea.

That's how I learned G:Robots 3e, made a blank HTML table
for each section and sat down and made robots with pencil.

Before long I'd done 20 or 30.

Helped me a bit with Vehicles 3e too.

Hmmm, wonder if a PHP version would be worth it. Well let's
see how many ships I can build by pencil & paper first.

>

[panton41]

I noticed today that if you place a Weapon Battery in the Center #1 section (maybe others, but that stood out since that was the one I wanted to use) that the section lower on the page where you can choose the type of weapons didn't work.