GURPS Spaceships Design Spreadsheet

ericbsmith · 03-20-2017, 07:40 PM

Version 2.0 Release Candidate 20
-If you delete a Ship System the sheet will now automatically delete all System Options associated with that system.
-If you select the Ship Orientation to be Building and then select a ship system to be Underground then all systems in Hull Sections below that system will also be set to Underground (that is, if you make one Front/Upper system Underground then all Center and Rear/Bottom systems will be set to Underground; if you select any Center system to be Underground then all Rear/Bottom systems will be set to Underground).

-Added two new buttons to the System Options section. Copy Options and Paste Options.
--When you select any cell within row in the System Options section and click Copy Options that system's options will be used when pasting; note that even if you change the options after you click Copy Options the sheet will use whatever options are most current.
--If you select a row and click Paste Options the sheet will:
---Check to see if the System names match; if so it will paste the Options into that system
---If the System name is blank it will paste the System name and all the Options into that row
--If you select a range of rows and click Paste Options the sheet will go through each row, as above, and paste the System Name and Options as appropriate.
---This will automatically skip Core systems if two Core systems are already installed.
---Multi-Row Pasting does not work on Sub-Systems (Smaller SM, Reconfigurable Systems, and Mixed Mount Weapon Batteries). You can still select one row at a time and Paste the System/Options into it.
---Pasting may allow you to paste Systems or Options into sections of the ship where they are disallowed. If so this will generally generate an appropriate error.

You can download the spreadsheet here:

Excel 2000 (RC20)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (5.1 MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (~2.5 MB)

Excel 2007 (RC20)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (~6.3 MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (~6.2 MB)

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

03-20-2017, 07:40 PM	#11
ericbsmith Join Date: Aug 2004 Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.	Re: GURPS Spaceships Design Spreadsheet Version 2.0 Release Candidate 20 -If you delete a Ship System the sheet will now automatically delete all System Options associated with that system. -If you select the Ship Orientation to be Building and then select a ship system to be Underground then all systems in Hull Sections below that system will also be set to Underground (that is, if you make one Front/Upper system Underground then all Center and Rear/Bottom systems will be set to Underground; if you select any Center system to be Underground then all Rear/Bottom systems will be set to Underground). -Added two new buttons to the System Options section. Copy Options and Paste Options. --When you select any cell within row in the System Options section and click Copy Options that system's options will be used when pasting; note that even if you change the options after you click Copy Options the sheet will use whatever options are most current. --If you select a row and click Paste Options the sheet will: ---Check to see if the System names match; if so it will paste the Options into that system ---If the System name is blank it will paste the System name and all the Options into that row --If you select a range of rows and click Paste Options the sheet will go through each row, as above, and paste the System Name and Options as appropriate. ---This will automatically skip Core systems if two Core systems are already installed. ---Multi-Row Pasting does not work on Sub-Systems (Smaller SM, Reconfigurable Systems, and Mixed Mount Weapon Batteries). You can still select one row at a time and Paste the System/Options into it. ---Pasting may allow you to paste Systems or Options into sections of the ship where they are disallowed. If so this will generally generate an appropriate error. You can download the spreadsheet here: Excel 2000 (RC20) http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (5.1 MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (~2.5 MB) Excel 2007 (RC20) http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (~6.3 MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (~6.2 MB) OpenOffice 3.3.0 (RC9) http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (~2.1 MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (~1.9 MB) __________________ Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. Last edited by ericbsmith; 03-22-2017 at 08:02 AM.