Using excel.

where Vel is the velocity of the piston LVel is the angular velocity of the connecting rod (in rad/s) Ace is the acceleration of the piston LAce is the angular acceleration of the connection rod (in rad's Use the Excel spreadsheet template provided (Lab Assignment 1-Template.xlsx) in order to calculate the values of all variables and the Force in the connecting nod (F), for the Crank The following columns must appear in your spreadsheet, and all calculations must be made based on the equations provided: Vel Vel rads Crank Angk, Theta Phi Ace F rads 2 For this assignment, use the following values of R. L, R=5m, -45 rads, and W L-10 m, W-15N Use the Exeel spreadsheet provided, in order to do the following tasks and analysis: 1. Header Include a header for the entire data set called "Force in Connecting Rod. Center align the header 2. Constants: Enter the aforementioned values of R, L andW at the top of the spreadsheet (as constants). Make sure to include the units for all the constants. Data Formatting: Format the column headers so that they appear in Bold, and inc lude appropriate units All data and header cells must have Borders Fomat all the data so that they all appear in the same format (the Number format in Excel, with up to 2 decimal places only). 4. Enter data in the first column (Crank angle) such that the Crank angle (0) varies from zero 5. Calculate the values of all seyen variables in the spreadsheet (Phi, R. L-Vel Vel, 6. Plot the following in increments of 5 degrees to 360 degrees L-Acc, Acc and Force) using the equations provided on page 2 of this document a. Piston Displacement ( in metres (on Y-axis) versus Crank Angle ) in degrees (on X-axis) b. Connecting Rod Force (F) in Newtons (on Y-axis) versus Crank Angle in degrees (on X-axis) 7. From the data, find the following values a. Maximum Piston Displacement (r) b. Minimum Piston Displacement (r c. Maximum Connecting Rod Force (F) d. Minimum Connecting Rod Force (F) (display the se maximum and minimum values below the r and F columns respectively in the Excel spreadsheet). where Vel is the velocity of the piston LVel is the angular velocity of the connecting rod (in rad/s) Ace is the acceleration of the piston LAce is the angular acceleration of the connection rod (in rad's Use the Excel spreadsheet template provided (Lab Assignment 1-Template.xlsx) in order to calculate the values of all variables and the Force in the connecting nod (F), for the Crank The following columns must appear in your spreadsheet, and all calculations must be made based on the equations provided: Vel Vel rads Crank Angk, Theta Phi Ace F rads 2 For this assignment, use the following values of R. L, R=5m, -45 rads, and W L-10 m, W-15N Use the Exeel spreadsheet provided, in order to do the following tasks and analysis: 1. Header Include a header for the entire data set called "Force in Connecting Rod. Center align the header 2. Constants: Enter the aforementioned values of R, L andW at the top of the spreadsheet (as constants). Make sure to include the units for all the constants. Data Formatting: Format the column headers so that they appear in Bold, and inc lude appropriate units All data and header cells must have Borders Fomat all the data so that they all appear in the same format (the Number format in Excel, with up to 2 decimal places only). 4. Enter data in the first column (Crank angle) such that the Crank angle (0) varies from zero 5. Calculate the values of all seyen variables in the spreadsheet (Phi, R. L-Vel Vel, 6. Plot the following in increments of 5 degrees to 360 degrees L-Acc, Acc and Force) using the equations provided on page 2 of this document a. Piston Displacement ( in metres (on Y-axis) versus Crank Angle ) in degrees (on X-axis) b. Connecting Rod Force (F) in Newtons (on Y-axis) versus Crank Angle in degrees (on X-axis) 7. From the data, find the following values a. Maximum Piston Displacement (r) b. Minimum Piston Displacement (r c. Maximum Connecting Rod Force (F) d. Minimum Connecting Rod Force (F) (display the se maximum and minimum values below the r and F columns respectively in the Excel spreadsheet)