GURPS Spaceships Design Spreadsheet

[DaltonS]

Originally Posted by ericbsmith

1) shouldn't be a problem
2) I'll think on that. I'll probably add an "atmospheres" listing along with the depth.

Thanks!

Originally Posted by ericbsmith

3) Already assumes "streamlining" if you have Force Wings for Air Performance 1 & 2, not streamlined for 3 & 4 (unless the ship actually has the streamlining option, in which case all profiles naturally assume streamlining)..

That's odd. When I didn't check Streamlining with Force Wings, Air Performance 1 & 2 used the unstreamlined airspeed.

Originally Posted by ericbsmith

4) What numbered items, specifically, are you seeing show up or not show up. Remember that each number does not get it's own line; some similar items are grouped together (such as all Armor/DR/Force Screen options being on the same line, or all Fuel Used being on a single line) (p.s. if you're using Excel and can give me an example ship from the ones saved that would be useful).

I'm using Open Office. Here's the BBCode output (slightly tweaked) of an SM+5 Gypsy Caravan.

CARAVAN CLASS PINNACE
PILOTING/TL10 (HIGH-PERFORMANCE SPACECRAFT) or PILOTING/TL10 (AEROSPACE)

 TL        Spacecraft       dST/dHP  Hnd/SR  HT      Move     LWt.    Load   SM      Occ      dDR   Range     Cost    
10^  Caravan Class Pinnace     20     -1/4   13  0.166667G/c   30   3.2 [1]  +5  5ASV [2,3]  2 [4]    —    $675.125k

Length: 30 yd. (90 ft.) Lift: 3.33333Gs Crush Depth: 333 ft.
Small Power Points: +2 / -2
Space Performance: sAccel: 0.166667Gs
Air Performance: aAccel: 0.166667Gs (3.7 mph/s) aSpeed: 1,000 mph (0.28 mps) Hnd/SR: -1/4

SHIP SYSTEMS

 FRONT                               | CENTER                                      | REAR                     
[1-2]   Armor - Light Alloy          | [1-2]   Armor - Light Alloy                 | [1-2]   Armor - Light Alloy            
          dDR 2                      |           dDR 2                             |           dDR 2                        
 [3]    Control Room                 | [3-5]   Habitat                             | [3-5]   Habitat                        
          Comm/Sensor: 4 / 1 Station |           0.9 Cabins                        |           0.9 Cabins                   
[4-5]   Habitat                      |  [6]    Smaller SM Systems                  |  [6]    Smaller SM Systems             
          0.6 Cabins                 |           SM+4                              |           SM+4                         
 [6]    Passenger Seating            |   [a]   Habitat                             |   [a!]  Contragravity Lifter           
          2 Seats                    |           0.1 Cabins                        |           3.33333Gs Lift               
                                     |   [b]   Cargo Hold                          |   [b!]  Reactionless Engine - Standard 
                                     |           0.5 Tons                          |           0.166667Gs [4,6,7]           
                                     |   [c‡]  Power Plant - Fusion Reactor        |   [c]   Habitat                        
                                     |           2 Power Points / 200 yr Fuel [5]  |           0.1 Cabins                   
                                     | [core]  Cargo Hold                          | [core]  Engine Room                    
                                     |           1.5 Tons                          |           1 Workspace

Design Switches, Features, & Notes: 1 Airlock (Capacity: 1 Person), Food Supplies: $250
CAMPAIGN OPTIONS: Reactionless Engine (Drive Field)
SHIP OPTIONS: Streamlined, Artificial Gravity
[1] Load includes: 0.7*tons of Crew & Passengers, 0.25*tons of Standard Food (125*man-days), 2*tons of Cargo Hold
[2] Plus 2 in Passenger Seats, [3] Crew Requirement: 1 Control Stations, 1 Workspaces, 1 Passenger Care
[4] Plus dDR 20 Drive Field

HABITATS

Qty.  Location            Type             Notes   
   1    Front   Cabin: Cramped           1 person
   2    Front   Steerage Cargo: Partial  0.5 tons
   1   Center   Passenger Cabin          2 person
   1    Rear    Passenger Cabin          2 person

Created using GURPS Spaceship Design Spreadsheet. GURPS Spaceships Design Spreadsheet is copyright © 2009-2012 Eric B. Smith. This spreadsheet is based on information contained in the GURPS Spaceships series of books.

Notes 5, 6 and 7 were referenced in the system descriptions but were not described in the Design Switches, Features, & Notes section.

Also note that I had to use 3 SM+5 plus 1 SM+4 Habitats to fit a full cabin in each of the Center and Rear hull sections. According to SS7 p5.

A system that’s one SM larger occupies three times its usual number of locations, and has the statistics of a system for a larger ship.

Could you add a switch that can consolidate three consecutive identical systems in the same hull section into a one SM larger version?

Originally Posted by ericbsmith

5)<tr> is missing, I can fix that. I think it's only missing in the top table - do you see anywhere else I missed something like that?

The closing tag for <th> cells should not be </td>. Also, there was no <h1> page header with the name of the craft.

Originally Posted by ericbsmith

While NOWRAP is not needed in most cells, it is needed for some of the cells. And I didn't want to make the coding any more difficult by having to test whether it is necessary for all of them or not so I just used NOWRAP in all cells. HTML doesn't care about superfluous tags like that, and frankly I'm not too worried about them so long as it's properly formatted.

Perhaps you could insert a small style sheet at the top of the code describing all the element styles instead of using formatting attributes in the element tags.

Dalton "Yes, I'm an HTML geek" Spence