GURPS Spaceships Design Spreadsheet

[panton41]

Any thought on just coding it? Like in an actual programming language? I know it opens a can of cross-platform worms but still. I've had good luck with Java in that regard. (Java would open up Windows, Linux, Mac and Android as native platforms and other than Android it would pretty much just work.)

[ericbsmith]

Originally Posted by ciaran_skye

Any thought on just coding it? Like in an actual programming language? I know it opens a can of cross-platform worms but still. I've had good luck with Java in that regard. (Java would open up Windows, Linux, Mac and Android as native platforms and other than Android it would pretty much just work.)

I don't know Java, and I don't really know enough C++ or C^ to pull it off. Maybe a couple years down the line.

[Onkl]

Hi Eric

Your Excel Sheet is a wonderful tool to create GURPS Spaceships on the fly. I've run into a problem unterstanding your sheet though, could you please explain why there seems to be a discrepancy between the damage as per Spaceships 1 and the damage your sheet calculates?

I am sorry if this has been answered in the thread, I was not able to find it.

Thanks!

Onkl

[ericbsmith]

Originally Posted by Onkl

Hi Eric

Your Excel Sheet is a wonderful tool to create GURPS Spaceships on the fly.

Glad you enjoy it!

Originally Posted by Onkl

I've run into a problem unterstanding your sheet though, could you please explain why there seems to be a descrepancy between the damage as per Spaceships 1 and the damage your sheet calculates?

Looks like I introduced a bug, almost certainly in the last update, where the damage is calculated as if the beam is 3 "sizes" larger than it actually is and it completely messes up the damage of missile warheads. Turned out to be an easy fix, though, and I'll be uploading a fixed version shortly.

EDIT: Version 1.27
-Fixed bug where damage of all weapons is calculated as if they were 3 "sizes" larger than they actually are

See my first post for download links.

[davester65]

I just noticed a very minor glitch in version 1.27. When you have it open to where you have two design worksheets, on the lower one only it does not show the endurance of an MHD power plant in the appropriate place, whether or not you add extra tanks of hydrox fuel. Like I said, nothing major.

[davester65]

Just a quick question. Does anyone know where I can find a simple editable GURPS spaceships worksheet in pdf or some other format? Thanks. I'd like it for homebrew designs that the spreadsheet doesn't cover. Thanks.

[panton41]

Originally Posted by davester65

Just a quick question. Does anyone know where I can find a simple editable GURPS spaceships worksheet in pdf or some other format? Thanks. I'd like it for homebrew designs that the spreadsheet doesn't cover. Thanks.

I used to have a simple Excel sheet that was just a bunch of blanks, if that's what you mean. The limit of its automation was to add up the cells.

If that's all you're wanting it's trivial to create in Excel or OpenOffice.org.

[davester65]

For some reason the spreadsheet won't allow me to use the "High Thrust" and "Air Ram" options for fusion torches, etc... as well as the "Open Frame" option, the boxes are there on the right side of the worksheet, but they all have X's through them and when I check the appropriate box, nothing happens. Is this a glitch or is there some other option I need to check to get these to work? Thanks.

BTW I am using version 1.27 for open office if that makes a difference.

[ericbsmith]

Version 1.28
-Fixed minor bug with engine duration and second ship
-Fixed bug in Open Office version where some option checkboxes were unusable

See my first post for download links.

This fixes the MHD Turbine bug (which might have affected other systems, actually) as well as the Options being Crossed out (which I had actually fixed and posted previously, but forgotten to comment on).

[davester65]

Thanks. Off to download.