Assignment 2 Excel, engineering homework help

I have work in the (Excel). And all the steps you can found in the files brought by. And we has been working on the last class is complemented by the assignment 1. I submit here assignment 1 and steps for the new assignment.

1. Thoroughly read the instruction manual’s “Reference” section on mechanical vibration of cantilever beams, tubular chimes, and palm pipes. Write Excel application which can calculate and graph theoretical first harmonic frequency of a cantilever beam as calculated from (Eq. 1)
1 = 1/ 2 2 √ as a function of the beam length L. The application should take the values
listed in Table 6, convert all values to SI units and calculate f1.

a. To verify that the Excel gives correct results, calculate by hand the single frequency for all the values listed in Table 6 and for L = 4 inches. Make sure that all the units are consistent. Compare your result with the result from Excel.

2. Use the Excel application you created to investigate the f1(L) relation for three cases: (a) Steel beam described in Table 6; (b) steel tubular chime described in Table 7; (c) Copper tubular chime described in Table 7. For each case:

a. Create a table with two columns: L (in) with at least 10 values, and f1 with the corresponding calculated frequency (Hz). Adjust the range of L so that the frequency is approximately between 100 and 500 Hz.

b. Graph f1(L) using ‘scatter’ plot in Excel. Add labels, units, etc.

c. Determine the value of the theoretical beam length L, which will result in the assigned target frequencies assigned to your team (Refer to attached file).

3. In a similar fashion, determine the f1(L) relation and the target pipe lengths for palm pipes, as described by (Eq. 4) in the instructions.

Also, I am work with the (Group A) in the class you can find the table in PDF.

Table 1: Frequency Assignments

Group A

Electronic Note 1 (Hz) A: 440.0
Electronic Note 2 (Hz) D: 587.4
Beam Note (Hz) E: 329.6