GURPS Spaceships Design Spreadsheet

[vierasmarius]

I've found a couple bugs that have persisted:
• Power tally includes all powered systems within Reconfigurable systems, instead of just the most draining one.
• Reactionless Stardrives don't count their Thrust towards Air Performance.

And a new one:
• Troop Strength includes all weapons in Reconfigurable Systems, rather than max one per set.

[ericbsmith]

Originally Posted by vierasmarius

• Troop Strength includes all weapons in Reconfigurable Systems, rather than max one per set.

I should be able to fix this, but it's going to wind up with an issue that I just don't care enough to worry about.

If you leave uninstalled weapons in a reconfigurable battery it's going to seriously mess up troop strength, because the sum of all uninstalled mounts is subtracted from total batteries. e.g. if you put two Medium Batteries in a Reconfigurable system, then mount one weapon each in them you will wind up with 2 (total number of batteries) - 1.3333 (for having four uninstalled medium mounts) -1 (number of redundant reconfigurable) = -0.3333 weapon batteries.

[ericbsmith]

Version 2.00 Beta 16


Fixed with the above caveat:
• Troop Strength includes all weapons in Reconfigurable Systems, rather than max one per set.
Fixed:
• Power tally includes all powered systems within Reconfigurable systems, instead of just the most draining one.
• Reactionless Stardrives don't count their Thrust towards Air Performance.

Thought I got the Reactionless Stardrive last time; forgot about the Campaign Reactionless option.

[ericbsmith]

Version 2.00 Beta 17

-Added section just below the Ship Options to list the Fuel onboard the ship, cost of the fuel, and cost to refuel ship.
-Cleaned up fuel used of some systems; added a few new Fuel Tank types. In particular, Hydrogen, Antimatter-Catalyzed Hydrogen, and Antimatter-Boosted Hydrogen have been listed separately.

-In Excel improved performance of core macro. Sheet changes should cause less recalculation time; in particular setting or changing ship TL and SM will be significantly faster.
-In OpenOffice modified the row show/hide for Reconfigurable & Smaller SM systems. Selecting one of those systems will now cause the [a] rows to show; making further sheet changes will make [b] & [c] rows show.

[ericbsmith]

Version 2.00 Beta 18

-Further improvements in the Core Macro in both Excel and OpenOffice. I believe I eked out something like a 20% speed improvement in the responsiveness after making a selection in both sheets by making what was, really, a simple modification to the code.

-In Excel added ability to save the current ship into a storage sheet, then reload any ship from the storage sheet back into the main Design Table. Ships in the storage sheet are shown on the Saved Ships table, where you can browse the saved ships presented on a standard GURPS Spaceships/Vehicles table. The table can be sorted by ship Name, SM, or TL. Currently I have saved into the sheet two ships from Spaceships 1 - the Midnight Sun Orbiter and Star Flower tramp freighter.
You can also import all saved ships from an existing sheet, so future compatibility is ensured. When importing ships, the ships are added to the existing ones, only overwriting if the ship names are identical and you tell it to overwrite.


Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (1.83MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (777KB)

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

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

[ericbsmith]

Version 2.00 Beta 19

-No update for the OpenOffice sheet. All the work here was to the various Excel Macros.

-Continued development of the 'Save Ship to Sheet' in Excel. Finished work on the import functions, including complete error trapping (typing incorrect values into the various dialogs should now produce informative message boxes rather than causing debugging errors).
-You can now copy the 'Saved Ships' sheet and save ships into each sheet separately. Useful to do things like have one sheet to save ships from different campaigns, TL's, or empires into.
-Added a second Saved Ships sheet called 'Official Ships'. This contains the three ships from Spaceships 1 and the first half-dozen ships from Spaceships 2.

[vicky_molokh]

Ornithopters again. Apparently the latest OpenOffice sheet does not set a speed limit for ornithopters at all. Though it inspired me to allow superscience TL10^ wings that don't have a speed limit.
Is it possible to get a field or a checkbox that brings back a speed limit? Could come in handy for some versions of reactionless drives (e.g. Star Wars).

[ericbsmith]

Version 2.00 Beta 20

-Many minor bug fixes
-Added intermediate SM's. A ship of intermediate SM has twice the mass of the previous SM ship, but is treated as the next higher SM for purposes of being targeted or detected. So a SM+8.5 ship has a Loaded Weight of 2,000 tons (twice that of a SM+8 ship) but is considered SM+9 for purposes of attack and detection. All other statistics are extrapolated from the existing systems.


Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (2.15MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (928KB)

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

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

[Magpie]

Possible Bug:
I'm not getting all available armor above Advanced Metallic Laminate on SM +4/4.5 ships when TL is set to 9(^) or 10(^). (Using 2.00 Beta 20)

Overall, the spreadsheet is amazing. I especially like the new 1/2 SM feature- it helps a lot for statting ships from fiction. Thanks!

[ericbsmith]

Originally Posted by Magpie

Possible Bug:
I'm not getting all available armor above Advanced Metallic Laminate on SM +4/4.5 ships when TL is set to 9(^) or 10(^). (Using 2.00 Beta 20)

Overall, the spreadsheet is amazing. I especially like the new 1/2 SM feature- it helps a lot for statting ships from fiction. Thanks!

It does look like a couple of the Armors were incorrectly labeled as unavailable below SM+5. I've just uploaded a fixed version of the Excel sheets (which also fix numerous other minor errors); the OpenOffice sheet will get updated eventually. In the meantime you can always check the "Don't Filter available systems by SM" checkbox in the upper-left of the Design Table.