## Spreadsheets

It will be appreciated that the type of calculations discussed above lend themselves to the use of computer spreadsheets and Microsoft Excel is very convenient here as it is in many engineering situations as presented in Liengme (2002). A spreadsheet can be produced for the calculations in Table 4.1. This has been done to create Table 4.4. The first four columns present the ordinate number and the values of x, y and Simpson's multiplier. Assuming the x values are in cells B3 to B11, the y values in C3 to C11 and the SM values in D3 to D11, then:

• the figure to go in cell E3 is obtained by an instruction of the form ' = C3*D3' without the quotes, and so on for the rest of column E;

• the figure to go in cell F3 is obtained by an instruction of the form '=B3*C3' without the quotes, and so on for the rest of column F;

• the figure to go in cell G3 is obtained by an instruction of the form '=D3*F3' without the quotes, and so on for the rest of column G;

• the figure to go in cell H3 is obtained by an instruction of the form '=B3*B3*C3' without the quotes, and so on for the rest of column H;

• the figure to go in cell I3 is obtained by an instruction of the form ' = D3*H3' without the quotes, and so on for the rest of column I;

• the figure to go in cell J3 is obtained by an instruction of the form ' = C3*C3' without the quotes, and so on for the rest of column J;

• the figure to go in cell K3 is obtained by an instruction of the form '=D3*J3' without the quotes, and so on for the rest of column K;

• the figure to go in cell L3 is obtained by an instruction of the form ' = C3*C3*C3' without the quotes, and so on for the rest of column L;

• the figure to go in cell M3 is obtained by an instruction of the form '=D3*L3' without the quotes, and so on for the rest of column M.

Was this article helpful?

Lets start by identifying what exactly certain boats are. Sometimes the terminology can get lost on beginners, so well look at some of the most common boats and what theyre called. These boats are exactly what the name implies. They are meant to be used for fishing. Most fishing boats are powered by outboard motors, and many also have a trolling motor mounted on the bow. Bass boats can be made of aluminium or fibreglass.

Get My Free Ebook

## Post a comment