08-19-2016, 05:59 PM | #741 | |
Join Date: May 2009
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
It's from the design of a TL-11, SM +12 ship. The first two are from major battery 3GJ rapid fire x-ray lasers and the third is from medium battery 100 MJ VRF lasers. The 4th is from 48 cm missiles which seem unaffected. 3dx10 (5) burn sur 3dx10 (5) burn sur 2dx5 (2) burn 6dx12 (2) cr 8dx20 (5) burn sur 1750 (5) burn sur 315 (2) burn 6dx12 (2) cr |
|
08-20-2016, 06:16 AM | #742 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Yup, there it is. It looks like I corrected a formula but forgot to copy it down the column, so it's corrected in only the first row there. And you are correct, it's only an issue with Square Root of Destruction; essentially it's using a column offset and is looking in the wrong column for the data for SRoD.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
08-23-2016, 10:27 AM | #743 |
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
|
Re: GURPS Spaceships Design Spreadsheet
Hi, it's me again, with another item for the wish list. (Stop throwing things!)
Hot-Bunk An option for all crew bunks and cabins. These quarters are shared between two or three crew shifts for two or three times the cost for additional life support (or free if no life support). This assumes that only one shift is using quarters at any time, with other shifts either on-duty or off-duty but not in quarters. Suitable recreation areas should be provided for off-duty personnel. This can stretch accommodations on cramped vessels. Dalton “Get out of my damn bunk!” Spence
|
08-25-2016, 08:41 AM | #744 |
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
|
Re: GURPS Spaceships Design Spreadsheet
Okay, this is a bit of a bug report. Recently, due to my new computer's nagging, I finally fell to the dark side and installed Microsoft Office. This gave me a chance to check out the Excel version of the spreadsheet (V2 RC10) and compare it to the OpenOffice version (V2 RC9). Funny thing; the TL4 Pirate Galley I designed on the OO version didn't show any of the water performance stats for the ship's oars or sails when I wrote it on the Excel version. Huh?
Dalton “whose XL boat is going nowhere fast” Spence
|
08-25-2016, 06:21 PM | #745 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Looks like I broke a small piece of code that allowed it to count how many Oars and Sails the ship has for computing performance. Since it can't count them it assumes zero and doesn't display the statistics.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
08-26-2016, 10:18 AM | #746 | |
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Dalton “who’s just drifting along, singing this song...” Spence
|
|
08-26-2016, 07:22 PM | #747 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
I'm thinking I'll likely do a RC11 for Excel soonish. I just found another bug I introduced sometime that I need to fix; so probably after that. I don't know when I'll get another OpenOffice release done; the updates I did in RC10 and RC11 will significantly improve Macro performance in OO, but they also require a lot of rewriting of the OO specific Macros, which I just haven't had the inclination to do since I use the Excel version.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
08-28-2016, 03:27 PM | #748 |
Join Date: Jan 2014
Location: Calgary
|
Re: GURPS Spaceships Design Spreadsheet
I'm trying to add the Collapsible Fuel Tank upgrade to the Cargo bays on my ship. I can do it on the excel version of the sheet, but some of my PCs don't have excel so I'm trying in the Open Office version. And for some reason I don't get the option to do it.
Is there some setting I need to change? EDIT: I had though it was under the Unofficial Systems & Rules, but I already have it checked. And I toggled it off and on to try to fix it but the upgrade still does not appear. Last edited by Calvin; 08-28-2016 at 03:30 PM. |
08-28-2016, 08:28 PM | #749 | |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|
08-29-2016, 12:27 PM | #750 | ||
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
|
Re: GURPS Spaceships Design Spreadsheet
I need a little clarification on “Modular Sections” (RC10). I know there is something about modular systems in the Spaceships books, and I can using these rules for Small or Tiny modular sections, but the larger sizes might have different rules.
Quote:
Quote:
Dalton “Expiring minds need to kn....” Spence
|
||
Tags |
design, game aids, gurpsland, program, sheet, spaceships, spreadsheet |
Thread Tools | |
Display Modes | |
|
|