GURPS Spaceships Design Spreadsheet

ericbsmith · 05-13-2013, 06:45 PM

Version 2.0 Release Candidate 7

Corrected several significant errors
Incorporated near full Macro support into the OpenOffice version of the sheet.
- You can now load and save ships from/to either of the Save Sheets (Saved Ships or Official Ships) the Design Table. There are new buttons at the top of the Design Table as well as the Save Sheets to run these macros. Also, there is a selection menu at the Top Right of the Design Table to select which Sheet and which Ship within the sheet to load from, or which sheet to save the current ship into.
- You can also load or reset just parts of a ship (using the checkboxes at the top-right of the Design Table)
- You can Import ships from other Files into this one. This means that you can easily update your older ships. To do so both files must be saved in the same directory and you must manually type in the file name in the appropriate field in the Design Table.

This version represents an important milestone because I've now incorporated most of the Macros from the Excel version into the OpenOffice version. Unfortunately, while these Macros work fairly well they are slow as snails in OpenOffice v3.4.x and LibreOffice v4. I have no idea why they are so slow; the code to load a ship runs in about 5 seconds in Excel, 15 seconds to run the ported code in OpenOffice v3.3.x, but in the newer programs they take several minutes to run (3-5 minutes in my testing). I don't know why they are running so slow, nor can I do anything about it. My suggestion here is to either just live with it or revert to the older version of OpenOffice (OpenOffice v3.2.0 Portable would be particularly good for this, as it won't interfere with another install of OO v3.4.x or LibreOffice).

Note that at this point there is one important Macro I still haven't incorporated into this sheet, and that is the ability to import all ships in the Save Sheets forward into a newer version of this SpreadSheet (you can import individual ships from the Design Table, but not all ships in the Save Sheet all at once). This Macro will surely be incorporated into my next revision, so that you can easily import your own ships forward into future versions of the sheet.

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

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

OpenOffice 3.2.0/3.3.0/3.4.x/LiberOffice 4
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (2.14MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (2.56MB)

05-13-2013, 06:45 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 7 Corrected several significant errors Incorporated near full Macro support into the OpenOffice version of the sheet. You can now load and save ships from/to either of the Save Sheets (Saved Ships or Official Ships) the Design Table. There are new buttons at the top of the Design Table as well as the Save Sheets to run these macros. Also, there is a selection menu at the Top Right of the Design Table to select which Sheet and which Ship within the sheet to load from, or which sheet to save the current ship into. You can also load or reset just parts of a ship (using the checkboxes at the top-right of the Design Table) You can Import ships from other Files into this one. This means that you can easily update your older ships. To do so both files must be saved in the same directory and you must manually type in the file name in the appropriate field in the Design Table. This version represents an important milestone because I've now incorporated most of the Macros from the Excel version into the OpenOffice version. Unfortunately, while these Macros work fairly well they are slow as snails in OpenOffice v3.4.x and LibreOffice v4. I have no idea why they are so slow; the code to load a ship runs in about 5 seconds in Excel, 15 seconds to run the ported code in OpenOffice v3.3.x, but in the newer programs they take several minutes to run (3-5 minutes in my testing). I don't know why they are running so slow, nor can I do anything about it. My suggestion here is to either just live with it or revert to the older version of OpenOffice (OpenOffice v3.2.0 Portable would be particularly good for this, as it won't interfere with another install of OO v3.4.x or LibreOffice). Note that at this point there is one important Macro I still haven't incorporated into this sheet, and that is the ability to import all ships in the Save Sheets forward into a newer version of this SpreadSheet (you can import individual ships from the Design Table, but not all ships in the Save Sheet all at once). This Macro will surely be incorporated into my next revision, so that you can easily import your own ships forward into future versions of the sheet. Excel 2000 http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (1.24MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (2.72MB) Excel 2007 http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (3.33MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (3.43MB) OpenOffice 3.2.0/3.3.0/3.4.x/LiberOffice 4 http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (2.14MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (2.56MB) __________________ Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. Last edited by ericbsmith; 05-13-2013 at 09:48 PM.