04-23-2015, 05:01 PM | #691 |
Join Date: Mar 2013
|
Re: GURPS Spaceships Design Spreadsheet
Here's the SM and Capacity (Tons) rows from the copy I'm working with, note that this is just the user information section (At least as far as I know) and not what the rules actually use.
+5 +6 +7 +8 +9 +10 +11 +12 +13 +14 +15 1.5 5 15 50 150 15 1,500 150 15,000 1,500 150,000 As you can see past SM+9 the pattern is broken and not followed, at least for even sized SM's |
04-23-2015, 05:13 PM | #692 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Ahh, that's just the description on the Optional Rules page. It doesn't affect the actual capacity of the system when added to a ship, and it appears it's something I've fixed along the way in RC10 and will be fixed in RC11 for OpenOffice.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
04-25-2015, 12:45 AM | #693 |
Join Date: Mar 2013
|
Re: GURPS Spaceships Design Spreadsheet
Is the Spread Armor option cannon or one of your add-ons?
And I found a way to remove entries, just select the cell you wish to clear and hit delete, a pop up will appear and simply hit enter to accept to default options |
04-25-2015, 12:05 PM | #694 | |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
It's one of my add-on rules, found in the Optional Rules section. I've been using it less with newer designs, as these days you can easily add Smaller SM Armor Systems to "spread" the dDR out (I think I originally wrote the rule before SS7 and Smaller Systems came out, I *know* I wrote it before Smaller Systems were implemented in my sheet).
Quote:
That said, there is still a Reset Ship button to reset everything at once and the next version of the sheet will still allow more options for when you Load or Reset.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|
04-25-2015, 02:36 PM | #695 |
Join Date: Mar 2013
|
Re: GURPS Spaceships Design Spreadsheet
But spread armor gets you better protection
|
04-25-2015, 03:07 PM | #696 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Depends on the armor, and mostly has to do with rounding errors. Spread Armor doesn't drop fractions where as Smaller Systems Armor does drop fractions, so they will be the same within 1 dDR per section. Smaller Systems Armor has the virtue of being "cannon."
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
04-25-2015, 03:11 PM | #697 |
Join Date: Mar 2013
|
Re: GURPS Spaceships Design Spreadsheet
Spreading a Light Alloy over a SM+15 ship gives you 34/33/33, while placing a Metallic Laminate SM+14 will get you 33/33/33. Spreading that Metallic Laminate will get to 50/50/50
|
04-26-2015, 01:09 AM | #698 | |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
I have no idea where you're getting 33/33/33. I can think of a couple ways you might get it, but you're being far from clear.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|
04-26-2015, 01:30 AM | #699 |
Join Date: Mar 2013
|
Re: GURPS Spaceships Design Spreadsheet
I'm getting 33/33/33 when I put a SM+14 Metallic Laminate armor system on a SM+15 ship, I'd guess that the file I've got is dividing the smaller dDR by 3, not the bigger one.
Which is Legal? Scratch that, data entry error, I'd clicked on Metallic Laminate got for some reason Light Alloy ended up being enter |
04-26-2015, 01:34 AM | #700 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
It should be dividing the SM+15 dDR by 3, yielding dDR 50 for Smaller SM Metallic Laminate. Testing in both RC11 in Excel and the currently available RC9 in OpenOffice this is exactly what I'm getting. I've no idea why it would possibly show up as dDR 33.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
Tags |
design, game aids, gurpsland, program, sheet, spaceships, spreadsheet |
|
|