The project assigned per grading matrix aims at introducing the students to the concept of using excel in practical applications pertaining to ships performance curves. Moreover, the project assesses the students understanding and skills in solving practical problems in operational research. The project is comprised of two major problems as below. For each problem the student is required to:

1) Explain how he/she reached the solution what method(s) were used.

2) Present their results

3) Comment on their results.

Deliverables for the project are the following:

1) Report containing brief introduction on the problems, the solution, description on how the solution was obtained (Mark Assigned 12.5%).

2) Original excel files solution(s) for each problem (Mark Assigned 12.5%).

Problems:

Problem 1: Ship Rated Power vs. Speed tables provides the required power a ship consumes to reach and maintain a fixed speed. Data available in EXCEL (Speed Vs Power 2022.excl) shows the ship power vs. speed data. Do the following:

a) Graph the data using excel and add the appropriate titles.

b) Determine the best data fit using a linear trendline and a polynomial trendline. Justify your choices.

c) Using linear interpolation determine the ship power at the following speed: 9.5 knots

d) Use extrapolation methods to determine the ship speed at a power rating of: 22 MW.

e) For the ship power vs. speed data sets, determine using numerical tools the integrals of the speed vs. power between 4 knots to 14 knots.

\begin{tabular}{rr|r|} \hline Speed (knots) & Power (MW) \\ \hline & 0 & 0 \\ \hline 1 & 0.266 \\ \hline 2 & 0.496 \\ \hline 3 & 0.717 \\ \hline 4 & 0.943 \\ \hline 5 & 1.193 \\ \hline 6 & 1.481 \\ \hline 7 & 1.824 \\ \hline 8 & 2.238 \\ \hline 9 & 2.740 \\ \hline 10 & 3.345 \\ \hline 11 & 4.070 \\ \hline 12 & 4.931 \\ \hline 13 & 5.945 \\ \hline 14 & 7.126 \\ \hline 15 & 8.493 \\ \hline 16 & 10.060 \\ \hline 17 & 11.844 \\ \hline 18 & 13.861 \\ \hline 19 & 16.128 \\ \hline 20 & 18.660 \\ \hline \end{tabular} \begin{tabular}{rr|r|} \hline Speed (knots) & Power (MW) \\ \hline & 0 & 0 \\ \hline 1 & 0.266 \\ \hline 2 & 0.496 \\ \hline 3 & 0.717 \\ \hline 4 & 0.943 \\ \hline 5 & 1.193 \\ \hline 6 & 1.481 \\ \hline 7 & 1.824 \\ \hline 8 & 2.238 \\ \hline 9 & 2.740 \\ \hline 10 & 3.345 \\ \hline 11 & 4.070 \\ \hline 12 & 4.931 \\ \hline 13 & 5.945 \\ \hline 14 & 7.126 \\ \hline 15 & 8.493 \\ \hline 16 & 10.060 \\ \hline 17 & 11.844 \\ \hline 18 & 13.861 \\ \hline 19 & 16.128 \\ \hline 20 & 18.660 \\ \hline \end{tabular}