Steve Jackson Games - Site Navigation
Home General Info Follow Us Search Illuminator Store Forums What's New Other Games Ogre GURPS Munchkin Our Games: Home

Go Back   Steve Jackson Games Forums > Roleplaying > GURPS

Reply
 
Thread Tools Display Modes
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
Old 09-17-2009, 04:13 AM   #2
sjard
Stick in the Mud
 
sjard's Avatar
 
Join Date: Aug 2004
Location: Rural Utah
Default Re: GURPS Spaceships Design Spreadsheet

Have you considered putting together a simple pdf worksheet form for those of us who don't particularly like spreadsheets?
__________________
MIB #1457
sjard is offline   Reply With Quote
Old 09-17-2009, 05:02 AM   #3
ericbsmith
 
ericbsmith's Avatar
 
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
Default Re: GURPS Spaceships Design Spreadsheet

Quote:
Originally Posted by sjard View Post
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 ;-).
__________________
Eric B. Smith GURPS Data File Coordinator
GURPSLand
I shall pull the pin from this healing grenade and...
Kaboom-baya.

Last edited by ericbsmith; 09-17-2009 at 05:09 AM.
ericbsmith is offline   Reply With Quote
Old 09-17-2009, 05:17 AM   #4
sjard
Stick in the Mud
 
sjard's Avatar
 
Join Date: Aug 2004
Location: Rural Utah
Default Re: GURPS Spaceships Design Spreadsheet

Quote:
Originally Posted by ericbsmith View Post
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.
__________________
MIB #1457
sjard is offline   Reply With Quote
Old 09-17-2009, 05:22 AM   #5
ericbsmith
 
ericbsmith's Avatar
 
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
Default Re: GURPS Spaceships Design Spreadsheet

Quote:
Originally Posted by sjard View Post
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.
__________________
Eric B. Smith GURPS Data File Coordinator
GURPSLand
I shall pull the pin from this healing grenade and...
Kaboom-baya.
ericbsmith is offline   Reply With Quote
Old 09-17-2009, 05:24 AM   #6
sjard
Stick in the Mud
 
sjard's Avatar
 
Join Date: Aug 2004
Location: Rural Utah
Default Re: GURPS Spaceships Design Spreadsheet

Quote:
Originally Posted by ericbsmith View Post
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.
__________________
MIB #1457
sjard is offline   Reply With Quote
Old 10-05-2009, 01:48 PM   #7
DemiBenson
 
Join Date: Aug 2007
Location: Boston, Hub of the Universe!
Default Re: GURPS Spaceships Design Spreadsheet

Quote:
Originally Posted by ericbsmith View Post
The previous thread I started seems to have been deleted by the forum changes. Since this now seems to be the appropriate place to post the notices I'm starting this tread to be a discussion and notification thread for my spreadsheet.

Eric, this is fantastic! Thank you so much!

I have two tiny little feature requests
  1. For the Habitat section, can there be a dropdown for "Open Space"?
  2. Can there be a note somewhere for number and size of Airlocks?

Thanks again!
DemiBenson is offline   Reply With Quote
Old 10-27-2010, 02:16 PM   #8
DaltonS
 
DaltonS's Avatar
 
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
Default Re: GURPS Spaceships Design Spreadsheet

I just downloaded the Open Office version and I'm having a lot of fun with it. Just a couple of items from Spaceship 7 to tack onto the wishlist.
  1. An option to use Smaller and Larger systems as per page 4. The former could be more easily done by stacking the hull sections vertically rather than side-by-side. (That would also make it visually less cluttered.)
  2. A "Hyperdynamic Hull" feature could be added to both ship and campaign options.

I want to design ships for my hyperspace rule set that will fit into my Hyperverse tech sequence (radiation screen => hyperdynamic field grid => reactionless drive => "hypersink" cloaking => jump gates to hyperspace => hyperjump stardrive).

Dalton "who finds the sheet ans interesting as the ships" Spence
DaltonS is offline   Reply With Quote
Old 10-27-2010, 04:27 PM   #9
Flyndaran
Untagged
 
Join Date: Oct 2004
Location: Forest Grove, Beaverton, Oregon
Default Re: GURPS Spaceships Design Spreadsheet

I keep getting errors from nearly everything I try to do.
I'm using the open office one.
It keeps saying scripting framework error occurred while running the Basic script.
Flyndaran is offline   Reply With Quote
Old 10-27-2010, 10:08 PM   #10
ericbsmith
 
ericbsmith's Avatar
 
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
Default Re: GURPS Spaceships Design Spreadsheet

Quote:
Originally Posted by Flyndaran View Post
I keep getting errors from nearly everything I try to do.
I'm using the open office one.
It keeps saying scripting framework error occurred while running the Basic script.
Stupid macros. I thought I had this set to be fixed in a macro before I saved to Open Office, but apparently I didn't save the sheet with the stripping macro intact.

Anyway, I've just corrected the open office sheet and this should no longer be a problem.
__________________
Eric B. Smith GURPS Data File Coordinator
GURPSLand
I shall pull the pin from this healing grenade and...
Kaboom-baya.
ericbsmith is offline   Reply With Quote
Reply

Tags
design, game aids, gurpsland, program, sheet, spaceships, spreadsheet

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Fnords are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 11:26 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.