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

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.

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

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).

You can select multiple cells by click & drag or by holding CTRL and clicking, then you can delete them at once.

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.

Re: GURPS Spaceships Design Spreadsheet
 

But spread armor gets you better protection

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."

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

Re: GURPS Spaceships Design Spreadsheet
 

I'm not sure what you're talking about. SM+15 Metallic Laminate has dDR 150. If you Spread it you get dDR 50/50/50. A Smaller SM System SM+14 Metallic Laminate Armor installed on a SM+15 ship yields dDR 50 each. If you place three Smaller SM Metallic Laminates on the ship, one in each hull section, it will have the same dDR 50/50/50.

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.

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

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.