The project assigned per DSMO$-100$ grading matrix aims at introducing the students to the concept of using excel in practical applications pertaining to ship's performance curves. Moreover, the project assesses the student's understanding and skills in solving practical problems in operational research. The project is comprised of two major problems as below. The problems are to be solved in groups comprised of no more than TWO students. For each problem the student is required to:

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

Present their results

Comment on their results.

Deliverables for the project are the following:

Presentation containing brief introduction on the problems, the solution, description on how the solution was obtained $($Mark Assigned $10\%).$

Original excel files solution$($s$)$ for each problem $($Mark Assigned $10\%).$

$$ EOB ${29}^{th}$ of February $2024$ the presentation and the excel file$($s$)$ must be submitted.

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 $2023.$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\mathrm{.}5$ knots

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

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.

f$)$ Speed

$($knots$)$ Power $($MW$)$

$$

$$