GURPS Spaceships Design Spreadsheet - Page 36

ericbsmith · 04-01-2012, 04:24 AM

Quote:

Originally Posted by Snoman314

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

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

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

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.

DemiBenson · 04-01-2012, 10:34 AM

Quote:

Originally Posted by ericbsmith

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

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.

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

Quote:

Originally Posted by ericbsmith

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.

vierasmarius · 04-01-2012, 12:28 PM

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.

vierasmarius · 04-02-2012, 03:09 PM

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

ericbsmith · 04-02-2012, 09:28 PM

Quote:

Originally Posted by vierasmarius

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.

vierasmarius · 04-03-2012, 01:08 AM

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

ericbsmith · 04-03-2012, 03:12 PM

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)

ericbsmith · 04-03-2012, 03:15 PM

Quote:

Originally Posted by ericbsmith

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

vierasmarius · 04-03-2012, 08:44 PM

Quote:

Originally Posted by ericbsmith

Version 2.00 Beta 15

Quote:

Originally Posted by ericbsmith

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.

Daigoro · 04-04-2012, 04:06 AM

Quote:

Originally Posted by ericbsmith

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

04-01-2012, 12:28 PM	#353
vierasmarius Join Date: Nov 2009 Location: Oregon	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.

04-02-2012, 03:09 PM	#354
vierasmarius Join Date: Nov 2009 Location: Oregon	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). Last edited by vierasmarius; 04-03-2012 at 01:06 AM.

04-03-2012, 01:08 AM	#356
vierasmarius Join Date: Nov 2009 Location: Oregon	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

04-03-2012, 03:12 PM	#357
ericbsmith Join Date: Aug 2004 Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.	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) __________________ Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya.