Tutorial: T5.10 ShipMaker Spreadsheet

[AnotherDilbert]

Crew calculations changed to T5 style based on consoles and control panels, rather than the old CT inspired defaulting.
1. Panels are counted and assigned to crew departments.
2. Consoles are assigned per crew departement, based on Panels and desired Ergonomics.
3. Crew are assigned to consoles, based on Consoles and desired watches.
4. Some crew added based on other crew, such as medics and stewards.
5. Crew numbers can be adjusted as desired with a number in the Adjustment column.
6. Petty Officers are assigned per Crew, and Officers based on Petty Officers, per crew department.
7. Senior officers added to the Command section based on officers in all departments using the Officer per PO ratio.
8. Troops can be assigned as a custom number or standard unit(s) (squad, platoon, ...).
Example: The crew my calculations defaults for the Daring-class (B2p47):


Some defaults are added to increase compatibility, such as a steward if any high passengers are allocated and a medic if low berths are added.

Civilian ships adds one or a few extra gunner console(s) for future upgrades, but no gunners. That way we can add e.g. a sensor or turret without compromising Ergonomics.

Most of the numbers can be overridden simply by changing them to taste.
The used Officer per PO and PO per Crew ratios can be adjusted far left, and separately for troops.

Example: Added five astrogators:


Troops can be added as a custom number:


or as standard unit(s):


Standard units are not added as part of the crew, but as "passengers" in separate standard barracks:

 

[AnotherDilbert]

Code block enhanced (Daring-class, B2p47):

PT-DS33   TL-14                      Ergo 2   Comfort 1    Demand 0        Agility 1
                                     Total:        50         213,1        Stability 1
System                                    #       Dton         Cost      
Hull                                              400                    
Config: Streamlined                                            28        
Structure: Charged Plate       AV=56 ( 560 vs Blast, 560 vs Heat/Beam, 560 vs Pres, 0 vs Rad, 0 vs EMP )      
Coating:                       AV= 0 (  )      
Armour Std                                1                          AV=28 ( 280 vs Blast, 280 vs H/B, 0 vs Rad, 0 vs EMP )      
Armour Std                                1        16                AV=28 ( 280 vs Blast, 280 vs H/B, 0 vs Rad, 0 vs EMP )      
Landing Wheels Wilderness                          12           6        
Wings Incr Perform                                -20           4        
Folding Fins Incr Agility                                       2        
Lifters Installed                                               2        
                                                                         
External Craft                            0                                -50  External Craft 
Drop Tanks (95% fuel)                     0                                 50  Hull 
Total Drive Capacity                    400                                  0  Over/undertonnage: Agility ±0
                                                                         
Jump Field: Jump Bubble                                                    D=351 m, Flash 7
Adv M Drive F  3 G, 720 EP                1         3,7        14,7      
Mod J Drive F  J-3, 660 EP                1        17,5        17,5      
Adv P Plant F  P 3, 720 EP                1         6,3        12,7      
                                                                         
Fuel, Jump                                        108                    
Fuel, Power                                         9,6                  
Purifier                                  2         2           2        
Scoops                                    2         2           0,2      
                                                                         
Console, Control C+S=14                  19        38           3,8        
Computer Mod m/4                          1         4           9        
                                                                         
Sensors                                                                  
Adv DS Surf Commu-13 +3 A+12 P            1                     7        
Ear AR Surf CommP-14 -1 A+7 PA            1                     3        
AR Surf Visor-14 ±0 A-- P(Phot            1                     2        
Mod DS Surf Neutr-14 +2 A-- P(            1                     5,5      
Mod AR Ant EMS-14 +3 A+7 PA(El            1         1           1        
Gen AR Surf Grav -14 ±0 A-- P(            1                     1,5      
Gen G Surf Life -14 ±0 A-- P(M            1                     6,1      
                                                                         
Crew:                             Comfort 1                              
Large Stateroom (1) 1                     1         4           0,2      
Suite (2) 2                               3        12           0,6      
Double Stateroom (2) 2                    4         8           0,4      
Spacer Niche (1) 1                       22        22                    
Common Areas                             31        31                    
Life Support:                                                            
Med Console                               1         0,5         0,5      
Clinic                                    1         2           1        
Life Support, Long term 160%              6        12          12          7200 person-days
                                                                         
Ship's Locker                                       1                    
Payload, Sophisticated                              1           1        
                                                                         
Standard Air Lock                         4                              
                                                                         
Cargo                                              36,4                  
                                                                         
Weapons                                                                  
Ult DS T3 Miss-14 +4 H:M Def+3            2         6          22        
Imp G T3 Beam-14 +3 H:3 Def+3             2         8          13        
                                                                         
Screens                                                                  
Mod Vd Bo Nucle-14 +3                     1         3           3,5      
                                                                         
Carried Craft                                                            
Grapple Ship's Boat 30 Dt                 1         1           9        
Bracket Fighter 10 Dt                     2         2          22        
                                                                         
                                                                         
                                       Crew    Consoles      Panels      
Crew                                45               13          24      
Command                              1                                   
Bridge Crew                         19    4                              
    Pilot                                 3           1           3      
    Astrogator                            3           1           0      
    Sensor Ops                            9           3           7      
Engineer                            12    3                              
    Engineer                              5           3           5      
    Maintenance                           4                              
Service Crew                         4    1                              
    Operations                            1           1           1      
    Medic                                 1           0           0      
    Steward                               1           0           0      
Gunner                               4    1                              
    Gunner                                2           2           4      
    Screen Ops                            1           1           1      
Flight Crew                          5                1           3

 

[AnotherDilbert]

Of course the crew calculations means that even large civilian ships with minimal staffing will have extremely small crews.

Example:

Using a 5000 Dton partially streamlined hull, it has a J Drive S3, a M Drive 5B5, and a P Plant S3 giving performance of jump-2 and 2 g acceleration. There is fuel tankage of 1100 Dton, enough for 4 weeks and 1 jump-2.
Controls consists of 27 control consoles, ten operating consoles, and a m/1/bis computer with Ergonomics 4.
There are three sensors: a communicator, a radar, and a scope.
Crew accomodations consists of five staterooms with a Comfort of 4.
Cargo capacity is 3249 Dton. The ship requires a crew of five: a pilot, an astrogator, two engineers, and a maintenance. The ship costs MCr 742,86.

 

[Ulsyus]

That's an awesome bit of work you've done there, quite impressive.

Are you able to post up the latest version, or was that it on p2 of this thread?

 

[AnotherDilbert]

Are you able to post up the latest version, or was that it on p2 of this thread?

Thanks.

Latest version here:
http://www.travellerrpg.com/CotI/Discuss/showthread.php?t=40404&p=612287

 

[agorski]

I noticed that in Book 2's Daring Class design, the cost and tonnage for drives is rounded up to the nearest whole number (you can get fractional values with Stage effects). What's your take on this?

 

[AnotherDilbert]

I don't round, since:

• When you should round (e.g. Ergonomics) that is specified in the rules.
• No rule says you should round drives or other components in general.
• Some rules depend on not rounding, e.g. weapons on firmpoints.
• Some standard components are specified in fractional Dtons, e.g. low berths and freshers, they are certainly not rounded (see Beowulf p45).


On the other hand, I don't mind if someone voluntarily wants to use larger and more expensive drives than necessary.

 

[agorski]

I agree with all you've said but with drives the additional cost and tonnage is minor and, if nothing else, it makes it easier to draw deck plans. Most other things the fraction is 0.5, so 1 square on a deck plan.

 

[AnotherDilbert]

Quite, the tonnage is minor, but the cost can be significant for small ships. Say 2/3 Dt × 4 MCr/Dton ≈ MCr 2.7 (Adv M-drive D).


Deck plans are always approximate, I don't really see a problem with a quarter Dton deviation here and there.

 

[agorski]

Yeah, that can be a killer for small craft.