Page 44 - Practical Ship Design

Introduction, Methods and Data 15

Column
A [W4] A ref no.
B [WS) A ship type T,B or R.
C [W17] ' Ship Name
D (F2)[W7] data L
E (F2)[W6] data B
F (F2)[W6] data D
G (F3)[W7] data T
H8 (F3)[W6] +0.7+). 125*@ATAN (0.25*(23-100N8)
H9 / copy from H8 to H9..H26
I8 (FO)[W7] + 1.03*D8*E8*G8*H8
I9 / copy I8 to I9..126
J (FO)[W7] data deadweight
K8 (F3)[W7] +J8/I8
K9 / copy K8 to K9..K26
L (F2)[W7] data speed
M8 (F2)[W6] +D8"0.S
M9 / copy M8 to M9..M26
N8 (F3)[W6] +0.16S*L8/M8
N9 / copy N8 to N9..N26
08 (F2)[W5] +D8/E8
09 / copy 08 to 09..026
P8 (F2)[W5] +E8/F8
P9 / copy P8 to P9..P26
Q8 (F3)[W6] + G8F8
Q9 I copy QS to Q9..Q26

One slightly disconcerting feature of the Lotus 123 and probably most, if not all,
other spreadsheet programs is that when an equation has no data to work on, an
entry of either 0 when the calculation is a multiplication or ERR if a division is
included appears in the answer address. Fortunately these entries disappear when
data is supplied.
After a little practice, a spreadsheet of this sort can be very quickly produced
and once available both eases the completion of tables of this sort and ensures an
accuracy which the author must admit he had not achieved in the hand calculations
which preceded its use.
A completed version of this spreadsheet is given as Table 1.1.