Steve Jackson Games Forums - GURPS Spaceships Design Spreadsheet

Steve Jackson Games Forums (https://forums.sjgames.com/index.php)

- GURPS (https://forums.sjgames.com/forumdisplay.php?f=13)

- - GURPS Spaceships Design Spreadsheet (https://forums.sjgames.com/showthread.php?t=62539)

Re: GURPS Spaceships Design Spreadsheet

LIGHT FRIGATE

Code:

 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

Code:

    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)

Code:

   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

Code:

    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

Code:

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

Code:

              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.

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 1344313)

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

Quote:

Originally Posted by ericbsmith (Post 1344314)

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!

Re: GURPS Spaceships Design Spreadsheet

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.

Re: GURPS Spaceships Design Spreadsheet

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)

Quote:

Originally Posted by vierasmarius (Post 1344399)

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.

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 1344417)

Thanks! I'll give it a try again.

Quote:

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.

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by vierasmarius (Post 1344419)

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

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 1344417)

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

Quote:

Originally Posted by vierasmarius (Post 1344419)

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.

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by vierasmarius (Post 1344424)

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.

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 1344447)

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

Code:

 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

Code:

 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

Code:

 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]

Code:

  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

Code:

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

Code:

             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

Re: GURPS Spaceships Design Spreadsheet

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)