This spreadsheet is meant to be used in conjunction with High Guard.  
Note: This spreadsheet does note prevent you from building invalid designs.  
If after checking High Guard something is not clear or if you find any error in this spreadsheet please feel free to contcat me at chriscox@ix.netcom.com



Name:
Enter the ship's name

Class:
Enter the class name

Type:
Allows you to entry primary and secondary type codes.  The typical meaning of the codes are displayed in cells F6 and G6

Tech Level:
Enter the tech level

Tonnage:
Enter the ships size in tons.  The code for the entered tonnage is displayed in cell E8

Configuration:
Enter the configuration code into cell D9.  The description for the code is displayed in cell E9

Jump Drive: 
Enter the Jump Drive number.

Maneuver Drive: 
Enter the Maneuver Drive number.

Power Plant:
Enter the Power plant number.  The minimum power plant required is displayed in cell E12
 
Jump Fuel Carried:
Enter the number parsec worth of Jump fuel that is carried.

Power Plant Fuel Carried:
Enter the number of weeks worth of power plant fuel that is carried.

L-Hyd Tankage:
Enter the amount of L-Hyd tankage capacity of the L-Hyd drop tanks in tons.  Modif Jump (cell E16) shows the ship jump rating with tanks attached.  Modif Maneuver (cell F16) shows the ships maneuver rating with tanks attached.  Jump Fuel (cell G16) is how far the ship can jump with tanks attached.  Parsecs in Drop Tanks (cell E18) is how many parsecs of fuel are in the tanks if they are dropped before jump.

Fuel Scoops:
Enter "y" if the ship has fuel scoops, anything else enter into this cell will be treated as if the ship has no fuel scoops.


Fuel Purification Plant:
Enter number of tons of fuel to be purified

Energy Points:
Bridge:
Computer:
Enter the code for the ship's computer.

Hull Armor:
Enter the Armor factor.

Spinal Mount Type:
Enter the "meson" if the ship will have a meson spinal mount.  Otherwise if the ship has a spinal mount it will be treated as a particle weapon.

Spinal Mount Code: 
Enter the code for the ship's spinal mount.  Otherwise leave blank.

Bay Weapons:
Enter number of bays.

Turret Weapons:	
For turret weapons enter number of weapons, number of turrets and number of batteries.  For Particle Weapons number of turrets is the number of weapons.  Cost and energy are based on number of weapons, tons is based on number of turrets and crew is based on number of batteries.  
Example A: For a ship with 2 batteries of 10 triple laser turrets and 2 batteries of 5 double plasma turrets you would enter 60 for number of laser weapons, 20 for number of laser turrets, 2 for number of laser batteries, 20 for number of plasma weapons, 10 for number of plasma turrets and 2 for the number of plasma batteries.
Example B: A ship has 2 turrets. In the first turret there are 2 lasers and a sand caster and in the second turret there are 2 missiles and a sand caster.  You would enter 2 for the number of laser weapons, 1 for the number of laser turrets, 1 for the number of laser batteries, 2 for the number of missile weapons, 1 for the number of missile weapons, 1 for the number of missile batteries, 2 for the number of sand casters, 0 for the number of sand batteries and 0 for the number of sand batteries.

Nuclear Dampers:
Enter Nuclear Damper code.

Meson Screens:
Enter Meson Screen code.

Force Fields:
Enter Force Field code.

Small Craft:
  Shuttles:
  Enter size in tone and number of shuttles carried.

  Fighters:
  Enter size and number of fighters carried.
 
  Launch Tubes:
  Enter size of largest craft that the tube can launch and number of tubes

Crew: Enter the number of crew personnel for each category.  Recommended is the minimum number of crew personnel that each category should have.  The F column shows the number of recommended personnel that should be officers.

Staterooms:
Enter the number of staterooms.  Column E shows the recommended number of staterooms based on number of officers and passengers.

1/2 Staterooms:
Enter the number of half staterooms.  Column E shows the recommend number of half staterooms for non-officer personnel.

Low Berths:
Enter number of low berths.  Column E show recommend number of low berths based on size of frozen watch and number of low passengers.

Cargo:
Enter number of tons of cargo.  Column E shows how many tons are tons are left.

Middle Passengers:
Enter number of middle passengers.

High Passengers:
Enter number of high passengers.

Low Passengers: Enter number of low passengers.


Rating the design section:
The section of the work sheet is to help you fill out the ship USP form.  The number coresponded to the number sections on the USP.