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
The future keeps telling us what the past was about. You make the past mean different things by what you do with the time that comes after.

Last edited by ericbsmith; 02-08-2018 at 04:00 AM.
ericbsmith is online now   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
The future keeps telling us what the past was about. You make the past mean different things by what you do with the time that comes after.

Last edited by ericbsmith; 09-17-2009 at 05:09 AM.
ericbsmith is online now   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
The future keeps telling us what the past was about. You make the past mean different things by what you do with the time that comes after.
ericbsmith is online now   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 09-17-2009, 06:06 AM   #7
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

Here's a blank worksheet PDF, good for printing out and filling in by hand.
__________________
Eric B. Smith GURPS Data File Coordinator
GURPSLand
The future keeps telling us what the past was about. You make the past mean different things by what you do with the time that comes after.
ericbsmith is online now   Reply With Quote
Old 09-17-2009, 07:11 AM   #8
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
Here's a blank worksheet PDF, good for printing out and filling in by hand.
Cool, Thanks.
__________________
MIB #1457
sjard is offline   Reply With Quote
Old 09-17-2009, 09:17 AM   #9
Shrale
 
Shrale's Avatar
 
Join Date: Jan 2007
Default Re: GURPS Spaceships Design Spreadsheet

Quote:
Originally Posted by sjard View Post
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.

>
__________________
"Now you see me, now you don't, woof" -- The Invisible Vargr
.
.
There are 10 types of people in the world. Those who understand binary, and those who don't.
Shrale is offline   Reply With Quote
Old 09-25-2009, 11:54 AM   #10
panton41
 
panton41's Avatar
 
Join Date: Jul 2005
Location: Jeffersonville, Ind.
Default Re: GURPS Spaceships Design Spreadsheet

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.
__________________
The user formerly known as ciaran_skye.

__________________

Quirks: Doesn't proofread forum posts before clicking "Submit". [-1]

My ebook page.

Quote:
"My mace speaks Goblin." Antoni Ten Monros
panton41 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 10:48 PM.


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