GURPS Spaceships Design Spreadsheet

[ericbsmith]

Version 1.15 posted.

Originally Posted by pw02

Little glitch I found: If you select the "Engine: Ram-Rockets" option, it increases the cost of several major non-engine systems (so far I've found it affects control room, weapon batteries, and power plants).

Fixed.

Originally Posted by ciaran_skye

Edit: Yeah, both missiles and conventional guns use zero Power Points correctly.

And not just Missiles & Guns but also if you use some mounts as a Cargo Hold, though currently you have to select Cargo Hold as a Weapon but not it's location - in order to save space the sheet wraps all Weapon Mount Cargo Holds into one "weapon" entry.

[Diomedes]

Your Optional Rules link is bad, due to being abbreviated with ellipses.

[ericbsmith]

Posted version 1.16. I did a lot of coding reworking, so let me know if any bugs pop up.

[Mgellis]

Originally Posted by ericbsmith

Posted version 1.16. I did a lot of coding reworking, so let me know if any bugs pop up.

I played around with it for a few minutes and it seems to be working fine; if I find any bugs, I will let you know.

Thank you for putting this together; it is a wonderful and enjoyable tool.

Mark

[panton41]

The revised sheet up uploaded.

As a side note, I hadn't noticed the modular system rule, I've been looking for that kind of rule for a long time.

[congo]

ericbsmith:
- The lower sheet has a typo (Dynaic Chameleon Hull).

And another thing. In my campaign some ships are too static in combat, so they use water instead of hydrogen as fuel. But there is no mention that all fuel tanks have to be filled with the same substance(?). So my ships have one tank of higher thrust fuel. It would be nice to include Fuel tank (water) besides normal fuel tank to modules to simulate for this emergency high thrust fuel reserve.
And it would be nice to have an option to change TL of individual components, cause some of my ships have different module statistics to simulate some tech edge in sensors (example).
But Good Work. :). I had my own sheet, but i was too lazy to have it cleaned up like this one so i switched to yours :)

[ericbsmith]

Posted v1.17

LOL, that typo has probably been there since I put the sheet together :O

Adding the capability to set TL for each ship system turned out to be relatively easy, so it's done. The fuel tank thing would take a *LOT* more wrangling than I care put into it at the moment.

[congo]

Originally Posted by ericbsmith

Posted v1.17

LOL, that typo has probably been there since I put the sheet together :O

Adding the capability to set TL for each ship system turned out to be relatively easy, so it's done. The fuel tank thing would take a *LOT* more wrangling than I care put into it at the moment.

ok. so i dont see how i can change tl of individual systems. and whatever i choose as the first system in front hull i get en error information in B11(and black background). I'm using excel 2007. It worked fine earlier(100%sure for v15, i dont remember if i made a ship using v16)

[ericbsmith]

Fixed the error and re-uploaded.

To set the TL of a ship system there is a column all the way to the right, just to the right of the Modular checkboxes, to the left of the cost breakdown.

[Kale]

Could you post the open office version in .zip instead of or in addition to .7z? I'd like to use the open office version but I don't want to deal with .7z when I already have plain old .zip capability.