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

Quote:

Originally Posted by Snoman314 (Post 1345518)

Unless I'm doing it wrong, the ram-rocket option is not affecting the price. I've only tried it with the NTR engine.

It's possible I didn't hook up the cost increase. I'm away from home for a few days, so I'll check it out when I get back.

Quote:

Originally Posted by DemiBenson (Post 1345762)

It looks like Ionizable Reaction Mass has the same cost as HEDM Rocket Fuel, which it shouldn't.

Reaction Mass has never been included in the cost of the Fuel Tank or ship. I can probably work something up for it though.

Quote:

Originally Posted by DemiBenson (Post 1345762)

It also looks like there's a bit of wonkiness with counting up Power Points from smaller subsystems, and counting mps from smaller Fuel Tanks.

I've not seen anything wrong there. Do you have some examples? Note that with Fuel Tanks a smaller Tank is always counted as 1/3 of a larger one, even if the listed tonnage is not actually 1/3 of a larger one.

Quote:

Originally Posted by DemiBenson (Post 1345762)

Aside from that, the new version 2 looks great! Is there a way to import a version 2 from one sheet to another in Open Office?

As I said, at this point I don't have any plans to. I'm not familiar enough with the OpenOffice macro language to make it work.

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 1345861)

Reaction Mass has never been included in the cost of the Fuel Tank or ship. I can probably work something up for it though.

Thanks. It would be nice to see a fuel-cost-per-voyage stat.

Quote:

Originally Posted by ericbsmith (Post 1345861)

I'll PM you with the location of an example.

Quote:

Originally Posted by ericbsmith (Post 1345861)

As I said, at this point I don't have any plans to. I'm not familiar enough with the OpenOffice macro language to make it work.

Ah, too bad. The excel files don't come out right on my mac.

Re: GURPS Spaceships Design Spreadsheet

After some heavy fiddling, I think I've stumbled on a couple more bugs.

• Inconsistencies between crew complement and number of control stations when using a Control Room with reduced stations. It displays the reduced stations correctly on the Control Room system, but in the notes it seems to double the reduction in crew.
• Total Automation not reducing Workspace crew requirement.
• Contragravity system not providing ships with Underwater Performance stats.
• Small Power Points not being properly tallied. Counted as both Normal and Small PP, effectively increasing total by 1.33 per Small PP.
• Power tally includes all powered systems within Reconfigurable systems, instead of just the most draining one.
• Small-sized Defensive ECM and Weapon Mounts not being counted for Troop Strength.
• Cosmic Power and Cosmic Armor not multiplying Force Screen and Armor DR.
• Follow-up damage of Gravitic Focus Conversion Beam not displaying correctly. It gives an error on the design sheet, but seems to display correctly in the Output.
• Force Wings option does not register in the Air Performance stats.
• Extra Zeroes showing up between some lines on the Output.

Here's the test design on which I managed to squeeze in all these bugs:

TEST SPACECRAFT

Code:

 TL     Spacecraft    dST/dHP  Hnd/SR  HT          Move           LWt.     Load    SM      Occ       dDR    Range    Cost   

12^  Test Spacecraft    150    -1 / 5  13  50 G / 20000 mps [1]  10,000  802 [2]  +10  20 ASV [3]  200 [4]    x0   $7.447B

Length: 100 yd. (300 ft.) Lift: 10 Gs Crush Depth: 10,000 ft.
Power Points: +10 / -14 Small Power Points: -0 / -2
Space Performance: sAccel: 50 Gs / 20,000 mps Hnd/SR: -1 / 5
Air Performance: aAccel: 50 Gs aSpeed: 1,765 mph Hnd/SR: +1 / 5
Water Surface Performance: wSpeed: 20 mph (10 yps) wAccel: 4 mph/s (2 yps/s) Hnd/SR: -2/5

SHIP SYSTEMS

Code:

  FRONT    

[1!]       Armor - Structural Field

             200 dDR

[2]        Control Room

             Computer: C9 / Comm/Sensor: 11 / Stations: 8 [5]

[3]        Ramscoop

              [1]

[4]        Comm/Sensor Array - Multipurpose

             Array level: 13 [6]

[5]        Smaller SM Systems

             SM+9

  [a!!]    Weapon Battery - Medium

             1 Weapon Mount

  [b!!]    Nuclear Damper - Light

             150 Mile Radius

  [c]      External Clamp

             3,000 Tons

[6]        Smaller Systems - Half-Sized

  [a]      Defensive ECM

             -1  to Hit/Detect

  [b]      Habitat

             30 Cabins

Code:

  CENTER   

[1!]       Armor - Structural Field

             200 dDR

[2!]       Weapon Battery - Major

             1 Weapon Mount

[3]        Hangar Bay

             Cap.: 300 Tons / SM+6 / Launch: 100 Tons/min

[4]        Cargo Hold

             500 Tons

[5]        Reconfigurable System - Triple Systems

  [a!!]    Force Screen - Heavy

             200 dDR / 400 dDR w/Extra Power Point [4,7]

  [b!]     Cloaking Device

  [c]      Holoprojector

[6!]       Contragravity Lifter

             10 Gs Lift

[Core‡‡†]  Power Plant - Total Conversion

             5 Power Points

Code:

   REAR    

[1!]       Armor - Structural Field

             200 dDR

[2]        Reaction Engine - Super Conversion Torch

             50 Gs / 20,000 mps [8]

[3-4]      Fuel Tank

             1,000 Tons of Fuel

[5-6!!!!]  Screw Propeller (2 Power Point)

[Core‡‡†]  Power Plant - Total Conversion

             5 Power Points

0
Design Switches, Features, & Notes: 6 Airlocks (Capacity: 6 people each), CAMPAIGN OPTIONS: Cosmic Power, Cosmic Armor, Multiscanner Array, SHIP OPTIONS: Total Life Support, Total Automation, [1] Near-C with Ramscoop, [2] Load includes: 2 tons of Crew & Passengers, 500 tons of Cargo Hold, 300 tons of Hangar Bay, [3] Crew Requirement: 6 Control Stations, 13 Workspaces (1 per Full system, 0.0 per Smaller system), 4 Lab Worker, [4] Plus dDR 200 Force Screen (dDR 400 if reinforced with second Power Point), [5] Reduced Control Stations by 2, [6] Multiscanner Array, [7] FORCE SCREEN OPTIONS: Force Wings, CAMPAIGN FORCE SCREEN OPTIONS: Adjustable, FUEL USED: [8] Any Fuel, TROOP STRENGTH (TS): 3,600,000 Classes: Air, C3I, Space Features: Night, Sealed
0
0
HABITATS

Code:

Qty.  Location        Type               Notes        

  10    Front   Cabin                      20 person

   5    Front   Sickbay: Automed       5 bed automed

   2    Front   Lab: Science!     4 person, +1 Skill

   5    Front   Life Pod                   20 person

0
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  Center - Major - Turret   Disintegrator Beam   Rapid Fire   Gravitic Focus    300 GJ     6dx10 cor (infinite)    +0     1    10                       X

   1  Front - Medium - Turret    Conversion Beam                  Gravitic Focus     1 TJ         2dx50 cor (10)       +0     1    1                        X

                                                                                  Follow-up   2dx50 exp burn rad sur   +0     1    1                        X

                                                                                     1 TJ        2dx100 cor (10)       +0     1    1                       L/X

                                                                                  Follow-up  3dx100 exp burn rad sur

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

Okay, just a few more bugs:
•Boost Drive option gives incorrect velocity (a flat X mps per engine instead of X * Accel mps).
•Nautical Lines not reducing Air Speed (should be 1/5 of normal Streamlined speed).
•Underwater Performance registers as equal to Water Performance, despite them being different in most cases.
EDIT: •NPC Filters Only, No Life Support and Magical Life Support aren't multiplying number of Cabins in Habitat.

Overall it's working very well! I just built a massive psionic soul-eating space lobster-squid. Because I can (thanks to your excellent spreadsheet).

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by vierasmarius (Post 1346665)

Overall it's working very well! I just built a massive psionic soul-eating space lobster-squid. Because I can (thanks to your excellent spreadsheet).

If you find any more issues then keep them coming. I've managed to correct a few of these tonight, but it's time for some sleep. I'll pick up tomorrow and see if I can get all these issues taken care of.

Re: GURPS Spaceships Design Spreadsheet

Another small batch, which I'll just tack on the end here:
•Cargo Hold in Weapon Mounts displays an error in the Acc column and on the Output page
•Reactionless Stardrives don't count their Thrust towards Air Performance
•Sapient Brain (Psionic) doesn't provide a Psi Power Point
•Super-Soldier option doesn't double TS

Re: GURPS Spaceships Design Spreadsheet

Version 2.00 Beta 15

-Added Drop Capsule Launcher system
-Added Garage w/Vehicle to Habitat Modules

(See the Optional Rules page for descriptions of both)

-Addressed the following errors:
• Power tally includes all powered systems within Reconfigurable systems, instead of just the most draining one.
• Small-sized Defensive ECM and Weapon Mounts not being counted for Troop Strength.
• Cosmic Power and Cosmic Armor not multiplying Force Screen and Armor DR.
• Small Power Points not being properly tallied. Counted as both Normal and Small PP, effectively increasing total by 1.33 per Small PP.
• Follow-up damage of Gravitic Focus Conversion Beam not displaying correctly. It gives an error on the design sheet, but seems to display correctly in the Output.
• Reactionless Stardrives don't count their Thrust towards Air Performance
• Sapient Brain (Psionic) doesn't provide a Psi Power Point
• Cargo Hold in Weapon Mounts displays an error in the Acc column and on the Output page
• NPC Filters Only, No Life Support and Magical Life Support aren't multiplying number of Cabins in Habitat.
• Force Wings option does not register in the Air Performance stats.
• Super-Soldier option doesn't double TS
• Total Automation not reducing Workspace crew requirement.
• Inconsistencies between crew complement and number of control stations when using a Control Room with reduced stations. It displays the reduced stations correctly on the Control Room system, but in the notes it seems to double the reduction in crew.
• Nautical Lines not reducing Air Speed (should be 1/5 of normal Streamlined speed).
• Boost Drive option gives incorrect velocity (a flat X mps per engine instead of X * Accel mps).
• Contragravity system not providing ships with Underwater Performance stats.
• Underwater Performance registers as equal to Water Performance, despite them being different in most cases.
• Extra Zeroes showing up between some lines on the Output.
• Ram Rocket cost multiplier not counted

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

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

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

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 1347313)

-Addressed the following errors:

Note that while I should have addressed all of these errors, a double-check to make sure that I actually did, and did so correctly, would be appreciated.

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 1347313)

Version 2.00 Beta 15

Quote:

Originally Posted by ericbsmith (Post 1347316)

Note that while I should have addressed all of these errors, a double-check to make sure that I actually did, and did so correctly, would be appreciated.

Awesome! I'll take a look at it soon.

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 1347313)

-Added Drop Capsule Launcher system
-Added Garage w/Vehicle to Habitat Modules

Sweet. I was kvetching for some kind of drop capsule before, so nice to see an inclusion.

Would it be uncouth to offer suggestions for other optional systems and rules?
Ones I'd come up with before were Armoury, Shooting Range and Danger Room habitats.