08-29-2016, 04:07 PM | #751 | |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Performance may increase, but it may not as there may be inherant limits to the systems or the ship's design. I wouldn't change dDR; the shape of the ship isn't changing, neither is the thickness of the armor. There's no reason dDR would change.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. Last edited by ericbsmith; 08-29-2016 at 04:12 PM. |
|
09-01-2016, 10:15 AM | #752 | ||
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Quote:
Dalton “who had his own ideas, but wanted to check yours first” Spence
|
||
09-01-2016, 03:17 PM | #753 | |||
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Quote:
There are also concerns about detaching small or tiny modules. A ship can carry a number of these and detaching a number of them can compromise structural integrity, making it difficult to do high acceleration maneuvers. Quote:
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|||
09-03-2016, 09:39 AM | #754 | |||||
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Quote:
Quote:
Quote:
Quote:
Dalton “who is glad he asked his questions” Spence
|
|||||
09-12-2016, 03:48 PM | #755 |
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. |
09-13-2016, 05:03 PM | #756 |
Join Date: May 2006
Location: Seattle, Washington
|
Re: GURPS Spaceships Design Spreadsheet
Two things:
1) This is amazing. 2) Where did you learn to do this? After looking at your sheet I realized that if I could do something similar for my random monster generator I'd be able to make it cross-platform. (There was a third thing that I got rid of because I'd misread your last post.)
__________________
Natural Encyclopedia: 660 GURPS bestiary entries It Came from the Forums: A Community Bestiary with 160 entries (last updated 2009...someday I will revisit.) |
09-13-2016, 05:32 PM | #757 | |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
2) Mostly, I've learned through trial and error. I learned some computer programming by going to college, and that's helped immensely in the Macros, but most of the functions of the spreadsheet itself I just googled it when there was something I wanted to do and didn't know how. A lot of the things I do that look complex are really just combinations of three or four simple tricks combined to make something more complex happen (such as the drop-down menus which can change their offerings based on other criteria you select). And, really, mostly it's just familiarity. I've been developing this spreadsheet for 7 or 8 years already, maybe longer (the oldest backup file I have is from 2011, but that was already v1.36 of the sheet). I've been messing with spreadsheets for 20 years, going back to the version of Microsoft Works I got with my first computer in 1996. 3) I saw your third point, and compatibility is something I've had in mind. In fact, largely it's why I've been rewriting the Macros for the last year or more. Last time I tried running the RC9 version of the sheet in LibreOffice it took something like 6 minutes to execute a Load/Save ship command. Last time I tested the new macros it was more like 20 seconds to (mostly) load a ship. Of course, I also pitched a ton of errors, which is one of the reasons why the rewriting has been very slow. And while that 20 seconds is kind of slow compared to the ~1.5 seconds it takes in Excel, it is at least usable speedwise.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|
09-13-2016, 05:35 PM | #758 |
Join Date: May 2006
Location: Seattle, Washington
|
Re: GURPS Spaceships Design Spreadsheet
I'm the same way with FileMaker Pro. I've been using it for 20+ years, ever since I built a database for a Psych department. Sadly it's not the most cross-platform-friendly program and most people don't use Macs. :(
Maybe I can trial and error my way through... A randomizer certainly won't be nearly as complex as Spaceships.
__________________
Natural Encyclopedia: 660 GURPS bestiary entries It Came from the Forums: A Community Bestiary with 160 entries (last updated 2009...someday I will revisit.) |
09-13-2016, 06:16 PM | #759 |
Join Date: May 2009
|
Re: GURPS Spaceships Design Spreadsheet
Great! Thanks for the update as well as a great generator which is fun to use. Hopefully the issues with Open Office can be worked out.
|
09-13-2016, 07:00 PM | #760 |
Join Date: Aug 2004
Location: MO, U.S.A.
|
Re: GURPS Spaceships Design Spreadsheet
The oldest one I have is from July 4 2009, I don't see a version number.
__________________
Xenophilia is Dr. Who. Plus Lecherous is Jack Harkness.- Anaraxes |
Tags |
design, game aids, gurpsland, program, sheet, spaceships, spreadsheet |
|
|