A spreadsheet is used as the development environment for a dynamic force model of a manoeuvring ship. The dynamic equations are coded by a method of self- referencing formulas. The technique does not require spreadsheet macros and is described in the paper. Some advantages and disadvantages of spreadsheets for this type of application are discussed.
Bodily, Samuel (1986), "Spreadsheet modeling as a stepping stone", Interfaces, vol. 16, no. 5, pp 34-52.
2.
McCallum, I.R. (1976), A new approach to manoeuvring ship simulation , Ph.D. Thesis, The City University, London.
3.
McCallum, I.R. (1980), "A ship steering mathematical model for all manoeuvring regimes", Proc. Instituto Internazionale delle Comunicatazioni Conference on Ship Steering Automatic Control, Genoa, June 1980, pp 119-139.
4.
Pourzanjani, M. (1990), "Formulation of the force mathematical model of ship manoeuvring", International Shipbuilding Progress, 37, no. 409, pp 5-32.
5.
Press, W.H., Teukolsky, S.A., Vetterling, W.T. and Flannery B.P. (1992), Numerical Recipes in FORTRAN, Second Edition, Cambridge University Press, Cambridge.
6.
Ronen, B., Palley M.A. and Lucas H.C., "Spreadsheet analysis and design", Communications of the ACM, vol 32, no. 1, January 1989, pp 84-93.
