GURPS Spaceships Design Spreadsheet

[ericbsmith]

Originally Posted by scc

It would be nice if there was some faster way to add systems in bulk, the design I'm working on includes 10 Jump Gates and that was something of a bear.

Make sure Tools -> Cell Contents -> AutoInput is checked. Once AutoInput is enabled you can then add the first system in the column, go to the entry box for the second and start typing the name and the spreadsheet will auto-complete the name; hitting enter twice will normally take you down to the third entry where you can start typing again. If you haven't entered one of that type of Ship System yet but you know the full name of the Ship System you want to add you can just type it into the entry field and the sheet will accept it.
As an important note, go to Tools -> Autocorrect Options -> Options (tab) -> uncheck "Replace Dashes." If you don't change this option OpenOffice will change the " - " I use as a separator in Ship System names into an endash.

Originally Posted by scc

Some way to clear choices for Center slots if change my mind would also be nice.

In RC9 you can delete entries by sheet section - so you can remove all entries in the Ship Systems or the Habitats section, etc. In the current Excel version I expanded on this allowing you to delete not just by sheet section but also by hull section, so you can remove Front Habitats or Center Ship Systems or Rear Weapons; or even all Center entries (Options/Systems/Habitats/Weapons/etc). This will follow to OpenOffice once I get it ported over.

Originally Posted by scc

The Vehicle Dock Capacity row is wrong.

What, specifically, is incorrect?

Originally Posted by scc

On the mention of Jump Gates Option 3 is available for them, listing what appears to be all fuels, even things like wood.

This is true of all FTL drives and Reactionless Engines, and it is to allow you to assign a fuel of your choice to the engines. This is likely to be a campaign level decision. By default it simply includes all available fuel types.