Ship calculations

This is an example of my ship calculations for four ships that fought at Lowestoft, in 1665. The Dutch measurements are all in Amsterdam feet, and are sometimes noted with a "D". The English are noted with an "E". I have found Excel spreadsheets very useful for analyzing 17th Century ship characteristics and for computing wargame factors.

 

 

Admiralty	Rotterdam	Amsterdam	Amsterdam	Amsterdam
Name	Eendracht	Amsterdam	Huis Tijdverdrijf	Huis te Kruiningen
Date	1653	1653	1655	1653
Captain	Jacob van Wassenaer	Abraham van der Hulst	Albert Claeszoon Graeff	Jacob Andrieszoon Swart
Guns	73	68	58	58
Crew	409	290	258	255
Length (M4) (Amsterdam feet)	150	140	136	140
Beam (M8) (Amsterdam feet)	38	34.5	34	34
Hold (M11) (Amsterdam feet)	15	14	14	13.5
Displacement (tons)	1035	820.8	787.7	781
Broadside Wt (lbs)	460	373	347	347
36pdr	3
24pdr	22	4	4	4
18pdr		20	20	20
16pdr
15pdr
14pdr
12pdr	6	8	4	4
10pdr
9pdr
8pdr	20	18	20	20
6pdr
5pdr
4pdr	22
3pdr		14	10	10
2pdr		4
Steenstukken/Bases
Armament Weight (lbs)	84.25	70.29	65.42	65.42
Armament percent of displ.	8.14%	8.56%	8.30%	8.38%
LWL (English) (M25) (feet)	134.12	125.18	121.60	125.18
WL (Dutch) (M18) (feet)	144.55	134.91	131.05	134.91
B (outside-D) (M9) (feet)	39.33	35.83	35.33	35.33
B (outside-E) (M10) (feet)	36.50	33.20	32.80	32.80
Mean Draft (E) (M26) (feet)	14.80	13.83	13.83	13.31
Draft Forward (M15) (feet)	15.00	14.00	14.00	13.50
Draft Aft (M16) (feet)	16.90	15.80	15.80	15.20
Lasts	394.01	311.61	298.32	296.13
Last coefficient	217.00	217.00	217.00	217.00
Jan Glete's approximation	993.87	786.03	752.51	746.97
English Length Keel (feet)	112.78	105.26	102.26	105.26
English Tonnage (tons)	799.22	617.16	585.16	602.37
Block Coefficient	0.5	0.5	0.5	0.5
Difference between methods	3.97%	4.24%	4.47%	4.36%