GURPS Spaceships Design Spreadsheet

[DaltonS]

FWIW: Just noticed the Kobold Work Bug (SS6:12) has a Troop Strength of 583 on the spreadsheet. Must be kind of crowded at SM+5. ;) (Seems hard coded since I can't change it.)

Dalton “Think of the pilot's bar tab!” Spence

[Anders]

Originally Posted by DaltonS

FWIW: Just noticed the Kobold Work Bug (SS6:12) has a Troop Strength of 583 on the spreadsheet. Must be kind of crowded at SM+5. ;) (Seems hard coded since I can't change it.)

Dalton “Think of the pilot's bar tab!” Spence

Kobolds are very very smol.

[ericbsmith]

Originally Posted by DaltonS

FWIW: Just noticed the Kobold Work Bug (SS6:12) has a Troop Strength of 583 on the spreadsheet. Must be kind of crowded at SM+5. ;) (Seems hard coded since I can't change it.)

Troop Strength is based on a formula that includes Weapon and dDR (plus some other combat systems). The Work Bug has a large mining laser and is fairly well armored, making it attack capable. At TS 583 it is well below any of the other attack-capable SM+5 ships. For full details see the rules for calculating Spaceship TS from Pyramid #3/30.

If you want to zero out the TS get rid of the Weapon Battery then create a User System called "Mining Laser" that uses 1 PP and has the cost of a Major Weapon Battery.

[Prince Charon]

Originally Posted by Anders

Kobolds are very very smol.

How small? Are they smurfs (this would actually be possible in TransHuman Space, IIRC)?

[DaltonS]

Originally Posted by ericbsmith

Troop Strength is based on a formula that includes Weapon and dDR (plus some other combat systems). The Work Bug has a large mining laser and is fairly well armored, making it attack capable. At TS 583 it is well below any of the other attack-capable SM+5 ships. For full details see the rules for calculating Spaceship TS from Pyramid #3/30.

If you want to zero out the TS get rid of the Weapon Battery then create a User System called "Mining Laser" that uses 1 PP and has the cost of a Major Weapon Battery.

Okay, that's doable. Thank you. I'd still like a switch that could suppress displaying troop strength altogether. I prefer to design non-fighting vessels and structures and it's not appropriate there.

Dalton “Why can't we just all get along?” Spence

[ericbsmith]

Version 2.0 Release Candidate 30
-Fixed bug where Troop Strength was always calculated and shown on the output, regardless of the state of the "Calculate Troop Strength" button.
-Fixed a few bugs with regards to Spin Tethers
-Fixed issues with Solar Panels where the Solar Luminosity & Distance has been set and partial power points are generated. The sheet will now track all power produced for all panels grouped together, rounding down Power Points generated to 1/3. The sheet will also track total power points generated from all panels and add them together, rounding that total down to the nearest whole Power Point (or 1/3 Power Point if Combine Large & Small PP is selected). This does mean that total Power Generated may be slightly more than that displayed by each set of panels; for instance, if Lum is set to 1.2 then each panel will produce 1.2 PP; five panels would thus produce 6 PP, but depending on how those 5 panels are installed on the sheet they may show as little as 1 PP generated each.
-Hangar Bay option Optimized for [Craft] now allows you to select the craft from a drop-down menu of craft from the Save Sheets. However, for both this field and the craft selection field in Vehicle Dock you may also type in the name of a craft in addition to using the drop-down menu.

You can download the spreadsheet here:

Excel 2000 (RC30)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z

Excel 2007 (RC30)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z

OpenOffice 3.3.0 (RC9)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z

Spaceships Optional Rules
http://gurpsland.no-ip.org/pdf/Space...ionalRules.pdf

[DaltonS]

You need to update the RC numbers next to the links.

Dalton “Quick to Pick a Nit. And Thanks!” Spence

[DaltonS]

Selective Automation
I seem to remember that in a earlier edition of the spreadsheet it was possible to automate individual systems. I understand if it can no longer be possible but I would like to be able to automate a single hull section. Why? So I can put an unshielded reactor or drive there without endangering maintenance crews. I keep remembering the Discovery in "2001: A Space Odyssey" where the nuclear engines were kept a long way from the habitat module. I'm sure HAL took care of that system (before he took care of the crew).

Dalton “Open the pod bay doors, HAL.” Spence

[DaltonS]

I've noticed that whenever I reload one of my saved ships the "Calculate Troop Strength" option is set on even if it was off when I last saved it. Is this a glitch? Also is there any way to save multiple campaign settings so I can use specific ones with multiple ship designs? If so, maybe you could add "Solar Power Options" to the campaign setting.

Dalton “with big plans for some 'Domed Mars' designs” Spence

[ericbsmith]

Originally Posted by DaltonS

I've noticed that whenever I reload one of my saved ships the "Calculate Troop Strength" option is set on even if it was off when I last saved it. Is this a glitch?

I'm not seeing that on a ship I just saved & reloaded. I don't think that should have been an issue with previously saved ships, either, since the issue I fixed was with the Design Table not respecting the state of the button in regards to displaying the results. (note that Troop Strength is always calculated, regardless of the checkbox; technically the checkbox only affects whether or not that information will be displayed on the ship and the output sheets).

Originally Posted by DaltonS

Also is there any way to save multiple campaign settings so I can use specific ones with multiple ship designs? If so, maybe you could add "Solar Power Options" to the campaign setting.

Any time you reset the design table, save, or reload a ship there are a series of checkboxes on the right-side of the dialog box where you can choose which sections to save, load, or reset. What you want to do is create a "dummy" ship - name it Mars Campaign Settings or something - and save just the Campaign Options (this is the information from the same-named tab) and the Ship Options (this is the information from the Design Table from the Ship Options, Features, etc section of the sheet). Then you can reload this before you start a new ship.