Steve Jackson Games Forums - View Single Post

ericbsmith · 09-12-2016, 03:48 PM

Version 2.0 Release Candidate 11
This is another Excel only release. However, keep in mind that much of the work on Macros has been to eventually improve OpenOffice performance, compatibility, and ease of conversion.

-Significant improvements in Macro execution speed in Excel; These improvements will eventually be incorporated into the OpenOffice version, and help there as well.
-Updated all Quantity drop-down selections to accept user input as well as drop-down selection. That is, if you want to input 99,999 this is not available in the drop-down but if you manually input the value it will be accepted if it is otherwise valid (e.g. you can actually install 99,999 in that location). This applies to most sections of the sheet, including the Crew breakdown section, as well as Auxiliary Craft, Cargo Hold, Habitats, Open Spaces, and Weapons sections.
-Moved Space Combat Turn Length and Range Scale to Campaign Options. Will be saved, loaded, and reset as a Campaign Option from now on, and will import setting from older ships as needed.
-Added Campaign Option for Slower Industrial Systems
-Added Ship Options for No Computers, Pre-Radio, and Zombie Ship to the Ship Options: Spaceships 7 section.
-Various UI tweaks, including section jump buttons for the Optional Rules, Campaign Options, and User Systems pages.
-More garage vehicle options, with new Passenger variants (the vehicles exclude most cargo capacity for more passenger capacity).
-Improved search capabilities in the Saved Ships sheets.
--You can now search up to five words or phrases. You can search for a phrase by substituting spaces with underscores. For instance, searching for "Utility_Truck" will search for ships with the entire phrase "Utility Truck" where as if you search for "Utility Truck" it will return any ships which contain either "Utility" or "Truck."
--You can now check a box to search for all ships of the chosen TL or below. For this purpose if you choose a superscience TL then both superscience and non-superscience TL's equal or lower will be included. Ships with a divergent TL, such as TL4+3, will add the two numbers together to determine what effective TL they are; so TL4+3 would be treated the same as TL7.
--You can now search multiple SM of ship; there are two SM entry fields, if you enter a value into both then any ships that fall between the two values will be shown. For split SM ships if either value falls within the search criteria the ship will be shows. So a SM+6/+7 ship will show up in a search of SM+5 to SM+6, and will also show up in a criteria of SM+7 to SM+9.
-Fixed bug where Water Performance for Oars and Sails weren't displayed.
-Fixed bug where damage wasn't correctly calculated for some weapons when using the Square Root of Destruction option.
-Various other bug fixes

Excel 2000 RC11
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (3.7MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (1.8MB)

Excel 2007 RC11
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (4.8MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (4.7MB)

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

09-12-2016, 03:48 PM	#755
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 11 This is another Excel only release. However, keep in mind that much of the work on Macros has been to eventually improve OpenOffice performance, compatibility, and ease of conversion. -Significant improvements in Macro execution speed in Excel; These improvements will eventually be incorporated into the OpenOffice version, and help there as well. -Updated all Quantity drop-down selections to accept user input as well as drop-down selection. That is, if you want to input 99,999 this is not available in the drop-down but if you manually input the value it will be accepted if it is otherwise valid (e.g. you can actually install 99,999 in that location). This applies to most sections of the sheet, including the Crew breakdown section, as well as Auxiliary Craft, Cargo Hold, Habitats, Open Spaces, and Weapons sections. -Moved Space Combat Turn Length and Range Scale to Campaign Options. Will be saved, loaded, and reset as a Campaign Option from now on, and will import setting from older ships as needed. -Added Campaign Option for Slower Industrial Systems -Added Ship Options for No Computers, Pre-Radio, and Zombie Ship to the Ship Options: Spaceships 7 section. -Various UI tweaks, including section jump buttons for the Optional Rules, Campaign Options, and User Systems pages. -More garage vehicle options, with new Passenger variants (the vehicles exclude most cargo capacity for more passenger capacity). -Improved search capabilities in the Saved Ships sheets. --You can now search up to five words or phrases. You can search for a phrase by substituting spaces with underscores. For instance, searching for "Utility_Truck" will search for ships with the entire phrase "Utility Truck" where as if you search for "Utility Truck" it will return any ships which contain either "Utility" or "Truck." --You can now check a box to search for all ships of the chosen TL or below. For this purpose if you choose a superscience TL then both superscience and non-superscience TL's equal or lower will be included. Ships with a divergent TL, such as TL4+3, will add the two numbers together to determine what effective TL they are; so TL4+3 would be treated the same as TL7. --You can now search multiple SM of ship; there are two SM entry fields, if you enter a value into both then any ships that fall between the two values will be shown. For split SM ships if either value falls within the search criteria the ship will be shows. So a SM+6/+7 ship will show up in a search of SM+5 to SM+6, and will also show up in a criteria of SM+7 to SM+9. -Fixed bug where Water Performance for Oars and Sails weren't displayed. -Fixed bug where damage wasn't correctly calculated for some weapons when using the Square Root of Destruction option. -Various other bug fixes Excel 2000 RC11 http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (3.7MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (1.8MB) Excel 2007 RC11 http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (4.8MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (4.7MB) OpenOffice 3.2.0/3.3.0/LiberOffice 4 RC9 http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (3.4MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (3.0MB) __________________ Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. Last edited by ericbsmith; 09-13-2016 at 11:47 PM.