The current example file has been designed to work with a particular design. The file would be more useful if it was adaptable to any given design. To do this would require the following steps to be taken.

§   Import the control points from Maxsurf, into their relevant Excel cells.

§   Manually modify the hull form in Maxsurf to a new hull shape.

§   Perform a parametric transformation of the hull so that some parameters remain the same between the two hulls, such as LWL and Displacement.

§   Import the second set of control points to their relevant cells in Excel

For this exercise, try creating macros to perform the above tasks so that any design can be used in the program.

Hint:

Start by manually performing the process of importing another hull form into the program, this will give a greater understanding of the processes that need to be coded