Description
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
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
K1
L
3,5156
L.L
Pi
2.PI.L.L
K1/2.PI.L.L E(Pa)
d(m)
b(m)
0,1016 0,010323 3,141593 0,064859 54,204104
2E+11 0,001575
0,0254
bd^3
I
EI
ρ
9,92E-11 8,26663E-12 1,653327
A
7900
ρA
EI/ρA
Sqrt (EI/ρA) f1
4E-05 0,315999 5,232057 2,28736902 123,9848
L(in)
3,5156
3,5156
3,5156
3,5156
3,5156
3,5156
3,5156
3,5156
3,5156
3,5156
4,4
3,5
3,3
3
2,8
2,5
2,3
2,2
2,1
2
L(m)
0,11176
0,0889
0,08382
0,0762
0,07112
0,0635
0,05842
0,05588
0,05334
0,0508
L.L
0,01249
0,007903
0,007026
0,005806
0,005058
0,004032
0,003413
0,003123
0,002845
0,002581
Pi
3,141593
3,141593
3,141593
3,141593
3,141593
3,141593
3,141593
3,141593
3,141593
3,141593
L(in)
f1(Hz)
102,4668
161,9393
182,1631
220,4174
253,0302
317,4011
375,0013
409,8671
449,8314
495,9392
4,4
3,5
3,3
3
2,8
2,5
2,3
2,2
2,1
2
2.PI.L.L
0,078479
0,049657
0,044144
0,036483
0,031781
0,025335
0,021444
0,01962
0,017877
0,016215
K1/2.PI.L.L E(Pa)
44,79678
2E+11
70,797197
2E+11
79,638721
2E+11
96,362852
2E+11
110,62062
2E+11
138,76251
2E+11
163,94436
2E+11
179,18712
2E+11
196,65888
2E+11
216,81642
2E+11
d(m)
0,001575
0,001575
0,001575
0,001575
0,001575
0,001575
0,001575
0,001575
0,001575
0,001575
Steel beam freque
600
500
400
f(Hz)
K1
300
200
100
0
0
0,5
b(m)
bd^3
I
EI
ρ
0,0254 9,92E-11 8,26663E-12 1,653327
0,0254 9,92E-11 8,26663E-12 1,653327
0,0254 9,92E-11 8,26663E-12 1,653327
0,0254 9,92E-11 8,26663E-12 1,653327
0,0254 9,92E-11 8,26663E-12 1,653327
0,0254 9,92E-11 8,26663E-12 1,653327
0,0254 9,92E-11 8,26663E-12 1,653327
0,0254 9,92E-11 8,26663E-12 1,653327
0,0254 9,92E-11 8,26663E-12 1,653327
0,0254 9,92E-11 8,26663E-12 1,653327
A
7900
7900
7900
7900
7900
7900
7900
7900
7900
79...