CS240 Intro Engineering Programming Programming Assignment #8, Due Saturday, December 2, 2017 Topics: User Defined Function, MATLAB Conditionals, and Excel An Engineer has requested you write a program to compare the theoretical maximum deflection with actual measurements of deflection that are recorded in an Excel Worksheet. Utilize the deflection function developed in homework #5 Ask the user for the following name of the file (Excel) that contain the inputs. Then using that filename read the following items from the worksheet. a. Length of the beam in inches. (A3) b. Load in pounds.(B3) c. Modulus of elasticity in psi.(C3) d. Moment of inertia. (D3) e. The number of measurement points (E3) f. The location of the measurements on the beam. The range starts at cell A6 and the ending 1. cell will be calculated using the value read from E3..e A6:A(6+E3-1(this vector is A in the formulas) g. The actual measurements. The range starts at cell B6 and the ending cell will be calculated using the value read from E3. i.e B6:B(6+E3-1). You program must then call the function deflection, to compute the deflection at center. deflection at load and the maximum deflection deflections for each of the points where actual measurements were taken. (A vector) 2. You must the generate a report with 4 labeled columns, Position, Maximum Deflection, Actual Deflection, and the difference between the two as shown in the sample run. 3. 4. Generate a plot where the theoretical data is charted using a blue, solid line with no symbols and the actual data points are plotted using red X's with no line Write a MATLAB Script that (uses the Deflection function) to satisfy the above description. Outline: I. 2. Create a MATLAB Script .m file -named ProgramO5.m Write the necessary MATLAB commands to prompt for the Excel worksheet name and read into variables all the values needed from that worksheet. 3. Call your deflection.m function to compute the deflections CS240 Intro Engineering Programming Programming Assignment #8, Due Saturday, December 2, 2017 Topics: User Defined Function, MATLAB Conditionals, and Excel An Engineer has requested you write a program to compare the theoretical maximum deflection with actual measurements of deflection that are recorded in an Excel Worksheet. Utilize the deflection function developed in homework #5 Ask the user for the following name of the file (Excel) that contain the inputs. Then using that filename read the following items from the worksheet. a. Length of the beam in inches. (A3) b. Load in pounds.(B3) c. Modulus of elasticity in psi.(C3) d. Moment of inertia. (D3) e. The number of measurement points (E3) f. The location of the measurements on the beam. The range starts at cell A6 and the ending 1. cell will be calculated using the value read from E3..e A6:A(6+E3-1(this vector is A in the formulas) g. The actual measurements. The range starts at cell B6 and the ending cell will be calculated using the value read from E3. i.e B6:B(6+E3-1). You program must then call the function deflection, to compute the deflection at center. deflection at load and the maximum deflection deflections for each of the points where actual measurements were taken. (A vector) 2. You must the generate a report with 4 labeled columns, Position, Maximum Deflection, Actual Deflection, and the difference between the two as shown in the sample run. 3. 4. Generate a plot where the theoretical data is charted using a blue, solid line with no symbols and the actual data points are plotted using red X's with no line Write a MATLAB Script that (uses the Deflection function) to satisfy the above description. Outline: I. 2. Create a MATLAB Script .m file -named ProgramO5.m Write the necessary MATLAB commands to prompt for the Excel worksheet name and read into variables all the values needed from that worksheet. 3. Call your deflection.m function to compute the deflections
