Ship design
Salaries
Ship design generatorby: Richard Di Ioia
This worksheet calculates the characteristics of a Ship.
Softwood density = 500 kg/m3Ship categoryTime[1]Matl cost[2]
Hardwood density = 750 kg/m3Basic - Raft0.250.25o Very basic ship.
Basic - Dugout20.2o Very basic ship.
Ships are a mix of hardwood (keep, frame, masts) and softwood (planks). Average wood density is 625 kg/m3Basic - Other21o Ships that use basic buoyancy of the wood to float – they are not made watertight using tar or other materials.
Masts are hardwood so 750 kg/m3 densitySimple32o Small ships that are used on rivers and placid lakes such as rowboats, fishing boats and barges. 
Complicated43o Coastal vessels that have limited technology such as cogs and galleys.
Intricate84o Ocean going vessels such as caravels and galleons.
Innovative126o Exotic vessels such as elven warships  that couple magic with technology.
Superb188o Special vessels such as submarines and flying ships. .
Weight  Build Time (in man-days)Selling Price
Ship nameCategory of ship[3]Cat #Length[4]Beam[5]Depth[6]Hull thickness[7]# of full decks# of partial decksDeck floorboard thickness[8]# of  mastsMast diameter[9]Base boatDecksP. DecksMastsTotalCarry TonnageBest speed (sailing)Hull sectionsMast HPPower Ratio[10]Sail areaMerchant or Warship[11]Standard crew membersOccupancy
(for a long voyage)[12]		Base boatMastsTotalMatl costTime costsFactor[13]Total
Raft
12 m2 m0.4 m0 m000.04 m00.06 m1000 kg0 kg0 kg0 kg1000 kg400 kgN/A40 HP00 m2Merchant221 days0 days1 days2.5 gp4 gp212 gp
Dugout, small
23 m1 m0.6 m0.1 m000.04 m00.09 m425 kg0 kg0 kg0 kg425 kg300 kgN/A30 HP00 m2Merchant126 days0 days6 days0.9 gp22 gp245 gp
Dugout, large
28 m2 m2 m0.1 m000.04 m00.24 m3328 kg0 kg0 kg0 kg3328 kg1280 kgN/A160 HP00 m2Merchant7832 days0 days32 days6.7 gp115 gp2244 gp
Rowboat43 m1.3 m0.5 m0.03 m000.04 m00.09 m148 kg0 kg0 kg0 kg148 kg390 kgN/A40 HP00 m2Merchant1212 days0 days12 days3.0 gp42 gp290 gp
Skiff45 m2 m1 m0.04 m000.04 m10.15 m582 kg0 kg0 kg66 kg648 kg1000 kg7.0 km/hour1027 HP1013 m2Merchant2530 days2 days32 days28.0 gp115 gp2286 gp
Fishing boat48 m3 m1.4 m0.04 m000.04 m10.24 m1343 kg0 kg0 kg271 kg1614 kg2880 kg8.0 km/hour2468 HP1436 m2Merchant41272 days3 days75 days56.3 gp270 gp2653 gp
River galley412 m4 m1.4 m0.04 m020.04 m10.36 m2283 kg0 kg900 kg916 kg4099 kg11520 kg10.0 km/hour48153 HP1059 m2Merchant936144 days4 days148 days118.0 gp533 gp21302 gp
Cog, small515 m5 m2 m0.04 m020.04 m10.45 m3827 kg0 kg1313 kg1789 kg6929 kg22500 kg12.0 km/hour75239 HP14127 m2Merchant1157300 days5 days305 days252.9 gp1098 gp22702 gp
Cog, large524 m8 m5 m0.06 m120.04 m10.72 m19012 kg4800 kg3000 kg7329 kg34140 kg122880 kg15.0 km/hour192611 HP14387 m2Merchant18192768 days8 days776 days1096.2 gp2794 gp27780 gp
Sloop615 m5 m3.5 m0.05 m110.04 m10.45 m6635 kg1875 kg656 kg1789 kg10955 kg26250 kg12.0 km/hour75239 HP16169 m2Merchant1266600 days5 days605 days483.2 gp2178 gp25322 gp
Caravel, single deck620 m6.5 m5 m0.06 m120.04 m20.6 m14649 kg3250 kg2125 kg8482 kg28506 kg67600 kg13.0 km/hour130424 HP18359 m2Merchant171301040 days13 days1053 days1260.2 gp3791 gp210102 gp
Caravel, dual deck624 m8 m7 m0.06 m220.04 m30.72 m23794 kg9600 kg3000 kg21986 kg58380 kg153600 kg15.0 km/hour192611 HP18608 m2Merchant242401536 days24 days1560 days2551.2 gp5616 gp216334 gp
Trireme535 m4 m2.5 m0.12 m100.04 m11.05 m24337 kg3500 kg0 kg22730 kg50567 kg33600 kg18.0 km/hour1401299 HP10182 m2Warship45105560 days4 days564 days1622.0 gp2030 gp27305 gp
Galleon, large638 m12 m11 m0.15 m330.04 m31.14 m143858 kg34200 kg9975 kg87270 kg275304 kg711360 kg18.0 km/hour4561531 HP161506 m2Warship1587413648 days36 days3684 days11354.1 gp13262 gp249233 gp
Galleon, small627 m9 m8 m0.12 m220.04 m30.81 m60493 kg12150 kg3713 kg31304 kg107660 kg218700 kg16.0 km/hour243773 HP16721 m2Warship743041944 days27 days1971 days4549.4 gp7096 gp223290 gp
Dinghy42.5 m1.2 m1 m0.04 m000.04 m10.075 m249 kg0 kg0 kg8 kg257 kg300 kg5.0 km/hour37 HP106 m2Merchant129 days1 days10 days12.6 gp37 gp299 gp
Rowboat33 m1.3 m0.5 m0.05 m000.04 m00.09 m240 kg0 kg0 kg0 kg240 kg390 kgN/A40 HP0 m2Merchant128 days0 days8 days2.4 gp28 gp261 gp
Rowboat33 m1.3 m0.5 m0.05 m000.04 m00.09 m240 kg0 kg0 kg0 kg240 kg390 kgN/A40 HP0 m2Merchant128 days0 days8 days2.4 gp28 gp261 gp
        
Sample to check the formulas in the table
Length (m)30
Beam (m)30
Number of full decks2
Number of partial decks2
Suggested carrying capacity (kg)2700000
Suggested best speed (km/hour)19.2
Suggest occupancy900
Convert knots to KM/hour1 knot = 1.852 kmph
Knots =6
KMPH =11.112
Sample to check the sail area formula in the table
To calculate the total amount of sail needed the formula is as follows:
First find the Sail Area to Displacement ratio
Sail area is in Square feet
Then find the displacement of the ship. Displacement is weight of the ship in pounds divided by 64 (salt water density).
Then take the Displacement value and put it to the 2/3 power.
Divide the SA / D
if below 16 = underpowered
16-19 = reasonable
20-22 = high performance
23+ = super high performance
Example: a 12000 pound boat with a sail area of 650 square feet would have a SA/D ratio of 19.8
Sail area in square meters =50m2--->553.7792ft2
Loaded weight of ship in kg =5000kg--->11000pounds
Displacement =2.77777777830.91305
SA/D =18.017.9
Suggested Sail area
Loaded weight of ship in kg =5000kg
Displacement = 2.777777778
Desired SA/D ratio =18
Suggested Sail area =50.0m2
[1]
In days.
Per m2 of material.
[2]
In GP.
Per 10 kg of material weight.
[3]
See table above for definitions.
[4]
External dimension
[5]
External dimension
[6]
External dimension
[7]
As a guideline;
Merchant ships = length / 350
Warships = length / 200

Minimum thickness of 3 cm.
[8]
Usually 4 cm thick floorboards for decks.
[9]
Nominal diameter
[10]
This is the Power Ratio at full carry tonnage. It drives the area of the sails.

Slow ships = 10
Underpowered merchant ships = 14
Reasonable ships = 16
High performance ships =18
[11]
Enter either Merchant or Warship in the column below.
[12]
This includes sailors and passengers
[13]
This is the profit factor above the cost that the seller will demand when selling their ship.

A merchant will typically sell for twice what it cost them to build the ship.