GURPS Spaceships Design Spreadsheet

[ericbsmith]

LIGHT FRIGATE

 TL    Spacecraft   dST/dHP  Hnd/SR  HT   Move  LWt.    Load   SM     Occ        dDR    Range    Cost    
11^  Light Frigate     50    -1 / 5  13  4 G/c   300  5.8 [1]  +7  8 ASV [2]  20 [3,4]    x2   $97.175M

Length: 30 yd. (90 ft.) Crush Depth: 3,333 ft.
Power Points: +8 / -10
Space Performance: sAccel: 4 Gs Hnd/SR: -1 / 5 FTL Rating: FTL-2
Air Performance: aAccel: 4 Gs aSpeed: 500 mph Hnd/SR: -1 / 5


SHIP SYSTEMS

    FRONT     
[1]           Armor - Diamondoid
                20 dDR [3]
[2]           Weapon Battery - Mixed Sec/Tert
                5 Sec / 15 Tert Weapon Mounts
[3-5]         Habitat
                6 Cabins
[6!]          Weapon Battery - Spinal (Front)

   CENTER     
[1]           Armor - Diamondoid
                20 dDR [3]
[2!]          Weapon Battery - Mixed Med/Sec
                2 Med / 3 Sec Weapon Mounts
[3-4!!]       Stardrive - Jump
                FTL-2
[5]           Control Room
                Computer: C7 / Comm/Sensor: 7 / Stations: 3
[6!!]         Force Screen - Heavy
                50 dDR / 100 dDR w/Extra Power Point [4,5]
[Core!]       Weapon Battery - Spinal (Core)
                1 Weapon Mount

    REAR      
[1]           Armor - Diamondoid
                20 dDR [3]
[2]           Engine Room
                1 Workspace
[3-4!!]       Reactionless Engine - Hot
                4 Gs
[5!]          Weapon Battery - Spinal (Rear)
[6,Core‡‡‡‡]  Power Plant - Super Fusion
                8 Power Points / 400 yr Fuel [6]

User Notes: The Light Frigate's main duty is to escourt small convoys and squadrons for short durations. Typical crew is two shifts of 1 Pilot, 1 Comm/Sensor Operator, 1 Gunner, and 1 Engineer.
Design Switches, Features, & Notes: 3 Airlocks (Capacity: 3 people each), SHIP OPTIONS: Artificial Gravity, Gravitic Compensators, Stealth Hull, Dynamic Chameleon, [1] Load includes: 0.8 tons of Crew & Passengers, 5 tons of Steerage Cargo, [2] Crew Requirement: 3 Control Stations, 1 Workspaces, [3] All Armor Hardened, [4] Plus dDR 50 Force Screen (dDR 100 if reinforced with second Power Point), [5] FORCE SCREEN OPTIONS: Hardened, ENGINE OPTIONS: FUEL USED: [6] Hydrogen Isotopes, TROOP STRENGTH (TS): 89,400 Classes: Air, Space Features: Night, Sealed


HABITATS

Qty.  Location        Type            Notes      
   2    Front   Cabin                  4 person
   1    Front   Bunkroom               4 person
   1    Front   Steerage Cargo           5 tons
   2    Front   Sickbay: Automed  2 bed automed

WEAPONS TABLE

              Range Scale:         Basic Combat Ranges  Turn Length:    20-sec    
Qty.             Mount                    Weapon           Options      Options    Size             Damage            sAcc   Rcl.    RoF   Shots  MPS  Accel  Range  
   1         Front - Spinal            X-Ray Laser                                300 MJ      3dx5 burn sur (5)      +2 [1]    1      1                         L
   2    Center - Medium - Turret       X-Ray Laser                                 30 MJ       6d burn sur (5)         +0      1      1                        S/L
   3  Center - Secondary - Turret      X-Ray Laser       Rapid Fire                1 MJ        2d burn sur (5)         +0      1     10                         S
   5   Front - Secondary - Fixed     Missile Launcher                 100kT Nuke   20 cm  8dx1,000  burn ex rad sur  +5 [1]    1    5 [2]    35    10    5G     L
                                                                                  Linked        6dx2,000 cr ex                                                   
       Front - Secondary - Fixed     Missile Launcher                              20 cm         6dx5 cr (2)         +5 [1]    1      1            10    5G     L
  15    Front - Tertiary - Fixed     Missile Launcher                  25kT Nuke   16 cm   4dx1,000 burn ex rad sur  +5 [1]    1   15 [2]    75    10    5G     L
                                                                                  Linked        3dx1,000 cr ex                                                   
        Front - Tertiary - Fixed     Missile Launcher                              16 cm         6dx4 cr (2)         +5 [1]    1      1            10    5G     L

[1] Includes +2 for Fixed Mount, [2] Already multiplied by number of mounts
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.

[vierasmarius]

Originally Posted by ericbsmith

Version 2.00 Beta 11
- Added output sheet with support for Plain Text, HTML, and BBCode (forum posting)

Originally Posted by ericbsmith

MISSILE FRIGATE
<SNIP>

This... is... amazing! One of the biggest challenges I've found with ship design is how to format it for posting on the forums. And you've gone and fixed it for us. Can't wait to try it out!

[vierasmarius]

Okay, not sure if I did something wrong, or what's going on, but I'm getting some bugs in the latest build. Troop Strength is displaying as 0 (despite the vessel having armor, weapons, maneuvering capability, etc); Projectile weapons are displaying Err:502 in their Accel stat; and every line on the Output page is also displaying Err:502. I'm using Open Office 3.3.0.

EDIT: Oh, and the Conventional Gun is also incorrectly getting the "Improved" option, x2 RoF, despite that only being available to energy weapons.

[ericbsmith]

Version 2.00 Beta 12

-Fixed issue with Missile Weapon Accel stat which caused the Output Sheet to error out in OpenOffice
-Corrected Troop Strength, which wasn't taking into account dDR or dHP (only Force Field dDR was being used).
-Corrected weapon RoF to increase with Space Combat Turn Length setting.

Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (1.86MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (755KB)

Excel 2007
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (2.30MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (2.23MB)

OpenOffice 3.3.0
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (1.7MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (1.47MB)

Originally Posted by vierasmarius

EDIT: Oh, and the Conventional Gun is also incorrectly getting the "Improved" option, x2 RoF, despite that only being available to energy weapons.

I don't see where Improved is limited to energy weapons. In fact, the description of Improved specifically says that this could represent a Multi-Barrel weapon, which could easily be used in the design of a Conventional gun. In fact, the note on the RoF table on p. 58 specifically mentions Improved guns.

[vierasmarius]

Originally Posted by ericbsmith

Version 2.00 Beta 12

-Fixed issue with Missile Weapon Accel stat which caused the Output Sheet to error out in OpenOffice
-Corrected Troop Strength, which wasn't taking into account dDR or dHP (only Force Field dDR was being used).

Thanks! I'll give it a try again.

I don't see where Improved is limited to energy weapons. In fact, the description of Improved specifically says that this could represent a Multi-Barrel weapon, which could easily be used in the design of a Conventional gun.

Well, it's listed specifically under the Options for Beam Weapons. Rapid Fire and Very Rapid Fire are listed separately for both Beams and Conventional guns. It thus implies that Improved is an option exclusively for energy weapons. Not a big deal though; your argument makes sense too.

[ericbsmith]

Originally Posted by vierasmarius

Well, it's listed specifically under the Options for Beam Weapons. Rapid Fire and Very Rapid Fire are listed separately for both Beams and Conventional guns. It thus implies that Improved is an option exclusively for energy weapons. Not a big deal though; your argument makes sense too.

See my edit. I also just re-updated because I noticed RoF wasn't taking into account Space Combat Turn Length.

[vierasmarius]

Originally Posted by ericbsmith

-Fixed issue with Missile Weapon Accel stat which caused the Output Sheet to error out in OpenOffice
-Corrected Troop Strength, which wasn't taking into account dDR or dHP (only Force Field dDR was being used).

Originally Posted by vierasmarius

Thanks! I'll give it a try again.

Hmm. I'm still getting both of these errors. All projectiles are still displaying an Error in their Accel stat (and thus spoiling the Output page), and TS is still displaying 0 (unless a Force Screen is present).

EDIT: The fact that having effectively 0 DR causes the TS calculation to return 0 indicates that it may not be including HP correctly in the formula. TS is based on dHP + Avg dDR, multiplied by number of combat systems (weapons + defensive ECM) and factors derived from Hnd and TL.

[ericbsmith]

Originally Posted by vierasmarius

EDIT: The fact that having effectively 0 DR causes the TS calculation to return 0 indicates that it may not be including HP correctly in the formula. TS is based on dHP + Avg dDR, multiplied by number of combat systems (weapons + defensive ECM) and factors derived from Hnd and TL.

I should have this fixed now. In fact, I fixed it several times, and something odd is going on with my system because it wasn't saving the changes for some reason.

[vierasmarius]

Originally Posted by ericbsmith

I should have this fixed now. In fact, I fixed it several times, and something odd is going on with my system because it wasn't saving the changes for some reason.

Nice, looks like it's working now. Thanks for being so patient. =P

EDIT: And as proof, here's the design I was using to test it:

PATROL GUNBOAT

 TL    Spacecraft    dST/dHP  Hnd/SR  HT   Move  LWt.    Load   SM     Occ     dDR  Range    Cost    
10^  Patrol Gunboat     30    +0 / 4  13  2 G/c   100  8.6 [1]  +6  6 ASV [2]   16    x1   $11.267M

Length: 20 yd. (60 ft.) Crush Depth: 4,000 ft.
Power Points: +4 / -4
Space Performance: sAccel: 2 Gs Hnd/SR: +0 / 4 FTL Rating: FTL-1
Air Performance: aAccel: 2 Gs aSpeed: 354 mph Hnd/SR: +0 / 4


SHIP SYSTEMS

 FRONT   
[1-2]    Armor - Advanced Metallic Laminate
           16 dDR
[3]      Control Room
           Computer: C7 / Comm/Sensor: 5 / Stations: 2
[4]      Comm/Sensor Array - Tactical
           Array level: 7
[5!]     Weapon Battery - Major
           1 Weapon Mount
[6]      Weapon Battery - Secondary
           10 Weapon Mounts

 CENTER  
[1-2]    Armor - Advanced Metallic Laminate
           16 dDR
[3-5]    Habitat
           3 Cabins
[6]      Cargo Hold
           5 Tons
[Core‡]  Power Plant - Fusion
           2 Power Points / 200 yr Fuel [3]

  REAR   
[1-2]    Armor - Advanced Metallic Laminate
           16 dDR
[3-4!!]  Reactionless Engine - Hot
           2 Gs
[5!]     Stardrive - Hyperdrive
           FTL-1
[6]      Engine Room
           1 Workspace
[Core‡]  Power Plant - Fusion
           2 Power Points / 200 yr Fuel [3]

User Notes:
Design Switches, Features, & Notes: 2 Airlocks (Capacity: 2 people each), CAMPAIGN OPTIONS: Armor/Volume Rules (Pyramid 3-34), SHIP OPTIONS: Artificial Gravity, Gravitic Compensators, [1] Load includes: 0.6 tons of Crew & Passengers, 8 tons of Refrigerated Cargo, [2] Crew Requirement: 2 Control Stations, 1 Workspaces, ENGINE OPTIONS: FUEL USED: [3] Hydrogen Isotopes, PERFORMANCE PROFILES: TROOP STRENGTH (TS): 9,200 Classes: Air, C3I, Space Features: Night, Sealed


HABITATS

Qty.  Location            Type             Notes   
   1   Center   Bunkroom                 4 person
   1   Center   Cabin                    2 person
   2   Center   Life Pod                 8 person
  12   Center   Steerage Cargo: Partial    3 tons

WEAPONS TABLE

             Range Scale:        Basic Combat Ranges  Turn Length:   20-sec  
Qty.            Mount                   Weapon           Options    Options   Size     Damage     sAcc   Rcl.    RoF   Shots  MPS  Accel  Range  
   1    Front - Major - Turret         UV Laser        Rapid Fire             3 MJ  3d burn (2)    +0      1     10                        S/L
  10  Front - Secondary - Fixed    Missile Launcher                          16 cm  6dx4 cr (2)  +4 [1]    1   10 [2]    50    10    5G     L

[1] Includes +2 for Fixed Mount, [2] Already multiplied by number of mounts
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.

[ericbsmith]

Version 2.00 Beta 14

-Added descriptive Error messages to the Ship Option checkboxes
-Hooked in campaign option for Stardrive (Reactionless)
-Corrected cost for individually selected Stardrive (Reactionless) engines
-Corrected some Engine Options a little bit better (NMP, Pseudo Velocity, Singularity Drive, and Boost Drive)
-Corrected ship stats for Boost Drive option
-Cleaned up the display of Design Switches, Features, & Notes:
(note: Plan on revamping this one for the final release, when I plan on moving a lot of things around a bit)
-Probably other bug fixes & adjustments


Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (1.86MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (755KB)

Excel 2007
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (2.30MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (2.23MB)

OpenOffice 3.3.0
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (1.7MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (1.47MB)