The summation can be done for columns E, G, I, K and M by using the instruction ' = SUM(E3:E11)' and so on, or the Excel X function can be used.

Then the area is obtained by (1/3)[SUM(E3:E11)]; the first moment about the y-axis by (1/3)[SUM(G3:G11)]; the centroid of area from the y-axis by moment/area or, in this case by ([SUM(G3:G11)]/ [SUM(E3:E11)]. It should be noted that the ordinate spacing in this case is unity. Had it been h, say, then the area would be given by (h/3)[SUM (E3:E11)] and so on.

More complex functions can be built in to the tables as the complexity of the calculations increases. There are many short cuts that can be used by those familiar with the software and the student will be aware of these through other applications. The great value of the spreadsheet is that templates can be created for common calculations and thoroughly checked. Then, in subsequent use, possible errors are restricted to the inputting of the basic data.

Excel has been used extensively for the tabular calculations in Appendix B.

How To Have A Perfect Boating Experience

How To Have A Perfect Boating Experience

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