View Single Post
Old 09-17-2009, 03:01 AM   #1
ericbsmith
 
ericbsmith's Avatar
 
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
Default GURPS Spaceships Design Spreadsheet

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
__________________
Eric B. Smith GURPS Data File Coordinator
GURPSLand
I shall pull the pin from this healing grenade and...
Kaboom-baya.

Last edited by ericbsmith; 02-08-2018 at 04:00 AM.
ericbsmith is offline   Reply With Quote