Steve Jackson Games Forums - View Single Post

ericbsmith · 04-22-2014, 08:31 PM

Version 2.0 Release Candidate 9
-Fixed Food Cargo unable to edit
-Fixed Magical Habitat Cabins not multiplied (introduced in RC8.1; not introduced in OpenOffice)
-Added two new worksheets, Saved Ships 2 and User Systems
--Saved Ships is now completely empty of ships, a good place for users to place their own ships. Saved Ships 2 houses my personal example ships as well as ships from Pyramid (the Official Ships sheet ran out of room, as the sheets are limited to 256 ships).
--User Systems has slots to place 5 user created Ship Systems. At the top there is a section where you can call up the stats of an existing Ship System from the sheet, making it easier to modify existing ships as well as see how they are created. There are also Macro Buttons to Copy the example system into one of the 5 user slots or to clear each of the user slots.
--If you save a ship to the Save Sheet the any User System it uses will be saved with it. When you restore a ship you it will be automatically loaded into a free User System slot if one is available, you will be asked to overwrite if an existing system has the same name and TL, or you will receive a warning if no slots are available.
-Added support for Equipment Packs from the Pyramid 3/40 article Mecha Operations. You can set a system up to mount Equipment Packs by selecting it from the Ship Options section area under Modular/Equip. Packs. Equipment Packs work similarly to Smaller SM Systems and Reconfigurable Systems, and use the same itemspace in the sheet, so you cannot attach an Equipment Pack to one of those systems (even though, technically, you should be able to). This is a limitation of the sheet I cannot work around at this time.
-Added support for new Systems and Options introduced in the Pyramid 3/64 article Sailing the Open Skies
-Consolidated Campaign Options so that all Pyramid Article options are activated using the same checkbox (adding new checkboxes causes a host of issues and is very time consuming; there's no real reason to add new option checkboxes unless some really weird rules are introduced)
-Added Force Screen options into the System Options section. You can specify up to six Force Screen Options here (either one or two options in each Options column), however if you select anything other than Magic/Psi Powered the General Force Screen Options (from the checkboxes above) will not be applied to the specific Force Screen you're adding options too.
-In Excel w/Macros you may now change the Ship System, SM, or TL from the System Options section as well as from the Spacecraft Design Table section. This requires use of Macros to copy the changes to multiple cells, so Macros must be enabled. This proved to be buggy/slow in OpenOffice, so is disabled for now.

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

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

Excel 2007 No Macro
http://gurpsland.no-ip.org/zip/Space...007NoMacro.zip (4.32MB)
http://gurpsland.no-ip.org/zip/Space...2007NoMacro.7z (3.85MB)

OpenOffice 3.2.0/3.3.0/LiberOffice 4
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (3.36MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (2.96MB)

04-22-2014, 08:31 PM	#592
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 9 -Fixed Food Cargo unable to edit -Fixed Magical Habitat Cabins not multiplied (introduced in RC8.1; not introduced in OpenOffice) -Added two new worksheets, Saved Ships 2 and User Systems --Saved Ships is now completely empty of ships, a good place for users to place their own ships. Saved Ships 2 houses my personal example ships as well as ships from Pyramid (the Official Ships sheet ran out of room, as the sheets are limited to 256 ships). --User Systems has slots to place 5 user created Ship Systems. At the top there is a section where you can call up the stats of an existing Ship System from the sheet, making it easier to modify existing ships as well as see how they are created. There are also Macro Buttons to Copy the example system into one of the 5 user slots or to clear each of the user slots. --If you save a ship to the Save Sheet the any User System it uses will be saved with it. When you restore a ship you it will be automatically loaded into a free User System slot if one is available, you will be asked to overwrite if an existing system has the same name and TL, or you will receive a warning if no slots are available. -Added support for Equipment Packs from the Pyramid 3/40 article Mecha Operations. You can set a system up to mount Equipment Packs by selecting it from the Ship Options section area under Modular/Equip. Packs. Equipment Packs work similarly to Smaller SM Systems and Reconfigurable Systems, and use the same itemspace in the sheet, so you cannot attach an Equipment Pack to one of those systems (even though, technically, you should be able to). This is a limitation of the sheet I cannot work around at this time. -Added support for new Systems and Options introduced in the Pyramid 3/64 article Sailing the Open Skies -Consolidated Campaign Options so that all Pyramid Article options are activated using the same checkbox (adding new checkboxes causes a host of issues and is very time consuming; there's no real reason to add new option checkboxes unless some really weird rules are introduced) -Added Force Screen options into the System Options section. You can specify up to six Force Screen Options here (either one or two options in each Options column), however if you select anything other than Magic/Psi Powered the General Force Screen Options (from the checkboxes above) will not be applied to the specific Force Screen you're adding options too. -In Excel w/Macros you may now change the Ship System, SM, or TL from the System Options section as well as from the Spacecraft Design Table section. This requires use of Macros to copy the changes to multiple cells, so Macros must be enabled. This proved to be buggy/slow in OpenOffice, so is disabled for now. Excel 2000 http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (3.37MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (1.58MB) Excel 2007 http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (4.32MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (4.20MB) Excel 2007 No Macro http://gurpsland.no-ip.org/zip/Space...007NoMacro.zip (4.32MB) http://gurpsland.no-ip.org/zip/Space...2007NoMacro.7z (3.85MB) OpenOffice 3.2.0/3.3.0/LiberOffice 4 http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (3.36MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (2.96MB) __________________ Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. Last edited by ericbsmith; 04-23-2014 at 05:00 PM.