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. 