Traveller Store CotI Features New Posts Mark Forums Read Register


Go Back TravellerRPG.com > Citizens of the Imperium > Other Versions of Traveller > Classic Traveller

Classic Traveller Discussion on the granddaddy of them all, Classic Traveller!

Reply
 
Thread Tools Display Modes
  #1  
Old August 28th, 2018, 02:48 PM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 2,586
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default CT HG'80 Ship Design Sheet Walk-through

Spreadsheet: http://www.travellerrpg.com/CotI/Dis...54&postcount=7


[To Admin: Sorry, lots of external pictures linked, but I don't really see how I could make this otherwise. At least the spreadsheet contains an BBCode table so that finished ships can be posted.]


The spreadsheet is Excel without any macros, it should work fine in LibreOffice.


The spreadsheet starts with a default ship:


Only change values in grey cells. Mainly we add values in the "#" & "Desired" columns, we add number of systems in the "#" column and the size or rating of the desired system in the "Desired" column.

Generally what you get is limited by the selected TL, e.g if you ask for a J-6 drive at TL-12 you will get a J-3 drive.

Errors are marked with red colour, example:

This hull size requires a bigger computer than is available at the selected TL.
Reply With Quote
  #2  
Old August 28th, 2018, 03:00 PM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 2,586
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default

Let's build a small patrol ship:

We specify TL-12 in cell A1 and a military ship by specifying a positive number in cell A2. Military ships automatically use double occupancy, but that can be overridden in cell A3, 0 = Single occupance, 1 = Double occupancy.

We select ship type codes in the tables in cells A4 & A5, in this case Corvette and Escort. The USP is updated automatically.



We specify hull size in cell D7. Basically any hull size of 5 Dt and up is supported. If the hull is less than 100 Dt jump drive and staterooms are deselected.

Configuration is specified as a number between 1 - 9, corresponding to the list of configurations, 1 is Standard, 9 is Buffered Planetoid, or in the table in cell B8. Cell B8 overrides the number.

Armour is specified as a number, what you get is limited by TL. Specify e.g. 99 to get as good as possible.

We specify 400 Dt, Needle configuration, and Armour 4. The armour we actually get is shown in the "USP" column.
Reply With Quote
  #3  
Old August 28th, 2018, 03:21 PM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 2,586
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default

Drive sizes are based on the total size of the ship, both the hull and drop tanks. E.g.:

To get a drop tank with enough fuel for a J-2 (keeping the tank) specify 20%.

In this example we will not use any drop tanks.


We specify drives with the desired rating, and the desired Agility. The power plant is dimensioned automatically. Specify negative numbers in the "#" column to get LBB2 lettered drives.

We specify J-2, M-5, and Agility-4, and LBB2 drives for M-drive and P-plant:


Minimum fuel is automatically added. Jump fuel is added as demountable tanks in the cargo hold, that can be turned off in row 31.

A fuel purifier is automatically added, that can be turned off in cell C21.
Reply With Quote
  #4  
Old August 28th, 2018, 03:34 PM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 2,586
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default

A bridge and a computer is included automatically. A civilian ship includes the smallest computer possible, a military ship includes the maximum computer available.

The desired size of the computer is specified in cell D24, and bis/fib in cell E24, -1 = bis, 0 = normal, +1 = fib.

An appropriate computer is selected based on other systems. Selected computer is shown in cell B24.

We select a fib computer by specifying 1 in cell E24.



Accommodations are sized for the crew and passengers (specified below). Minimum number of staterooms can be specified in cells D26 to D28.
Reply With Quote
  #5  
Old August 28th, 2018, 03:37 PM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 2,586
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default

Remaining space is added to the cargo hold.

Demountable tanks are in addition to the shown cargo hold, so currently we have 172 Dt cargo = 80 Dt tanks + 92 Dt free.

Reply With Quote
  #6  
Old August 28th, 2018, 04:30 PM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 2,586
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default

Weapons:

A spinal can be specified in the table in cell D35.

Bays are specified by how many and type (+size).

Turret batteries are specified by type of weapon, number of batteries, weapons per turret, and turrets per batteries. Factor is calculated.

Example:

This shows 2 batteries of triple turrets, 4 turrets in each battery, giving factor-4. This is too many turrets for this ship so the Hardpoint column header shows red. We will not use those batteries in this ship.


Small ships can use mixed turrets, with several different weapon types in the same turret. Mixed turrets are specified by number of turrets and three rows of weapons where we can specify type of weapons and number of weapons in each turret. Number of weapons in each turret is shown in cell B46 as number of open slots, full, or red for too many weapons. The sheet keeps track of maximum size turret for selected weapon types.

Example, two Missile, Laser, and Sand turrets:



Fixed Mounts (Solomani) are specified like turrets.


Empty hardpoints with space for fire control are reserved, half available for civilians, all available for military. They can be removed by specifying 0 in cell C53.

If you need more weapon rows, copy an existing row and insert a new row. Copy the entire row, not just a few cells. Even if you want a new empty row, copy an existing row.

If you want a new mixed turrets, copy a block of four entire rows and insert four new rows:

Copy, then Insert:

In LibreOffice you have to Paste the four rows manually.


You can delete excess weapon rows (not in LibreOffice 6.0).


If batteries of the same type with different factors are selected everything but the highest factor is marked in red and not included in the USP. Example:




We add four mixed turrets to the ship, two Missile-Missile-Sand, one Missile-Pulse-Sand, and one Fusion-Missile:

Note that number of batteries and factor is calculated and shown in the USP in the header.
Note that we use all the power available from the PP-6, the maximum possible with LBB2 drives.
Reply With Quote
  #7  
Old August 28th, 2018, 04:37 PM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 2,586
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default

Screens:

Screens are specified by number of systems and desired factor. The maximum factor is preselected.

Example:



We don't include any screens in this small, power-starved ship:
Reply With Quote
  #8  
Old August 28th, 2018, 04:44 PM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 2,586
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default

Carried smallcraft and vehicles are specified by standard type (or custom size and cost) and number of craft. Size and Cost are given automatically for standard craft, if custom size and cost are specified, standard craft can no longer be specified.

More rows can be inserted as needed.

We specify a Launch and a GCarrier:
Reply With Quote
  #9  
Old August 28th, 2018, 04:50 PM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 2,586
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default

We can specify passengers, extra staterooms, and troops below the calculated crew.

We specify a single Mid passenger, 3 low (for medical use), and 8 troops:
Reply With Quote
  #10  
Old August 28th, 2018, 04:58 PM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 2,586
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default

Just above the Crew block the ship's systems are added together:


Nominal Cost is all raw sum of the cost of the included systems.
Class Cost is 20% for the first ship plus 1% architect's fee.
Ship Cost is the rebated 80% cost for subsequent ships.

Cost of carried craft is not rebated, nor included in the architect's fee.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MgT2 Ship Design Speadsheet Walk-through AnotherDilbert Mongoose Traveller 0 August 24th, 2018 04:44 PM
Starship design sheet for T20 Kharum1 Software Solutions 5 November 26th, 2007 08:22 PM

This website and its contents are copyright ©2010- Far Future Enterprises. All rights reserved. Traveller is a registered trademark of Far Future Enterprises .
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright (c) 2010-2013, Far Future Enterprises. All Rights Reserved.