I didn't realize what had happened to the question before. I really need help with figuring out the Excel formula for Ram Angular Velocity and Ram Angular Acceleration. Can you please help me. Thank you

 

Part 2 is a continuation of Part 1. The angular displacement of the ram was recorded in an Excel spreadsheet and, afterward, plotted as a function of the angle of rotation of the crank. You will be adding to your Excel spreadsheet data from part 1 to include more information about the mechanism, use the example Excel spreadsheet below as a template.

Now, knowing that the crank rotates clockwise at a constant angular speed omega (�) of 1750 rpm, complete the following:

1. Convert the angular speed � from rpm to degree/s and display it above the table as shown.
2. Insert a "Crank Time t(s)" column between the "Ram Angle �₃ (deg)" and "Ram Angular Displacement �₃ - �_3min (deg)" columns as shown.
3. Insert a "Data Point Index" column before the "Crank Angle �₁ (deg)" column and fill it with index values ranging from one to the total number of angle values (data points) as shown.
4. Plot the displacement in the function of time curve, including title and axes labels, and save it in your report document.
5. The time increment Δt, constant in this case, is the time difference between two consecutive positions of the crank. Display its value in a cell above the table as shown.
6. Add a "Ram angular Velocity �₃ (deg/s)" column after "Ram Angular Displacement" column in the spreadsheet as shown. This column will receive the data computed in the next step.
7. Using Richardson numerical differentiation method, compute the angular velocity �₃ of the ram from the "Ram Angular Displacement" and "Crank Time" columns.
8. Plot the velocity curve, including title and axes labels, and save it in your report document.
9. Insert a "Ram Angular Acceleration" column after the "Ram Angular Velocity" column in the spreadsheet as shown. This column will receive the data computed in the next step.
10. Using Richardson numerical differentiation method, compute the angular acceleration �₃ of the ram from the "Ram Angular Velocity" and "Crank Time" columns.
11. Plot the acceleration curve, including titles and axes labels, and save it in your report document.
12. What can be done to smooth out the velocity and acceleration diagrams?
13. Submit the progress report showing the detailed answers to questions 1 through 12 along with your Excel file to your instructor.

Image transcription text

Angular velocity w = 1750 rom E 10500 deg/s Time increment = S Ram minimum position 93min = deg Data Crank Ram Crank Ram Angular
Ram Angular | Ram Angular Point Angle Angle Time Displacement Velocity Acceleration Index 0, (deg) 03 (deg) t(5) 03 - 03min (deg) wa
(deg/s) as (deg/57 ) Don't plot 350 86.3 0.03333 14.5 2852.5 these rows 355 87.7 0.03381 15.9 2852.5 1 0 89 0.00000 17.2 2712.5... 

	Angular Speed ω =			1750	rpm
			=	10500	deg/s
	Time Increment ∆T =			0.00048	s
Ram Minimum Position θ3Min =				71.85	deg/s
Data Point	Crank Angle	Ram Angle	Crank Time	Ram Angular Displacement	Ram Angular Velocity	Ram Angular Acceleration
Index	θ1 (deg)	θ3  (mm)	t(s)	θ3 - θ3Min (deg)	ω3 (deg/s)	α3  (deg/s2)
Don't Plot	350	86.30	0.03333	14.5	2817.50
	355	87.70	0.03381	15.9	2819.25
1	0	89.02	0.00000	17.2	2754.50	-109331.25
2	5	90.3	0.00048	18.5	2716.00	-140568.75
3	10	91.6	0.00095	19.8	2616.25	-211312.50
4	15	92.82	0.00143	21.0	2516.50	-259393.75
5	20	93.99	0.00190	22.1	2366.00	-343918.75
6	25	95.07	0.00238	23.2	2196.25	-362600.00
7	30	96.08	0.00286	24.2	2019.50	-400881.25
8	35	96.99	0.00333	25.1	1816.50	-422625.00
9	40	97.81	0.00381	26.0	1618.75	-433343.75
10	45	98.53	0.00429	26.7	1405.25	-438243.75
11	50	99.15	0.00476	27.3	1205.75	-407312.50
12	55	99.68	0.00524	27.8	1016.75	-385568.75
13	60	100.12	0.00571	28.3	838.25	-368112.50
14	65	100.48	0.00619	28.6	668.50	-330443.75
15	70	100.76	0.00667	28.9	523.25	-297675.00
16	75	100.98	0.00714	29.1	385.00	-265212.50
17	80	101.13	0.00762	29.3	271.25	-222643.75
18	85	101.24	0.00810	29.4	168.00	-225706.25
19	90	101.29	0.00857	29.4	59.50	-194775.00
20	95	101.3	0.00905	29.5	-19.25	-174868.75
21	100	101.27	0.00952	29.4	-113.75	-210393.75
22	105	101.19	0.01000	29.3	-218.75	-231831.25
23	110	101.06	0.01048	29.2	-334.25	-249287.50
24	115	100.87	0.01095	29.0	-458.50	-286650.00
25	120	100.62	0.01143	28.8	-607.25	-294306.25
26	125	100.29	0.01190	28.4	-764.75	-818606.25
27	130	99.89	0.01238	28.0	-1102.50	1563406.25
28	135	99.4	0.01286	27.6	257.25	20518.75
29	140	99.8	0.01333	28.0	-1365.00	-4439093.75
30	145	98.1	0.01381	26.3	-2982.00	9800.00
31	150	97.29	0.01429	25.4	-1650.25	1428962.50
32	155	96.36	0.01476	24.5	-2080.75	-1011237.50
33	160	95.31	0.01524	23.5	-2320.50	-479587.50
34	165	94.15	0.01571	22.3	-2565.50	-497350.00
35	170	92.87	0.01619	21.0	-2787.75	-433343.75
36	175	91.5	0.01667	19.7	-2976.75	-362906.25
37	180	90.04	0.01714	18.2	-3134.25	-305637.50
38	185	88.52	0.01762	16.7	-3263.75	-218050.00
39	190	86.94	0.01810	15.1	-3337.25	-89731.25
40	195	85.35	0.01857	13.5	-3354.75	-15006.25
41	200	83.75	0.01905	11.9	-3349.50	74725.00
42	205	82.17	0.01952	10.3	-3276.00	233668.75
43	210	80.64	0.02000	8.8	-3134.25	327993.75
44	215	79.19	0.02048	7.3	-2968.00	387100.00
45	220	77.82	0.02095	6.0	-2759.75	504087.50
46	225	76.57	0.02143	4.7	-2492.00	590143.75
47	230	75.45	0.02190	3.6	-2206.75	600556.25
48	235	74.47	0.02238	2.6	-1916.25	653843.75
49	240	73.63	0.02286	1.8	-1585.50	701006.25
50	245	72.96	0.02333	1.1	-1258.25	662418.75
51	250	72.43	0.02381	0.6	-948.50	687225.00
52	255	72.06	0.02429	0.2	-605.50	701006.25
53	260	71.85	0.02476	0.0	-290.50	629650.00
54	265	71.78	0.02524	-0.1	0.00	617706.25
55	270	71.85	0.02571	0.0	297.50	599637.50
56	275	72.06	0.02619	0.2	568.75	561662.50
57	280	72.39	0.02667	0.5	833.00	534100.00
58	285	72.85	0.02714	1.0	1074.50	476218.75
59	290	73.41	0.02762	1.6	1291.50	463050.00
60	295	74.08	0.02810	2.2	1515.50	449881.25
61	300	74.85	0.02857	3.0	1715.00	392306.25
62	305	75.71	0.02905	3.9	1891.75	359843.75
63	310	76.65	0.02952	4.8	2059.75	341775.00
64	315	77.67	0.03000	5.8	2217.25	323706.25
65	320	78.76	0.03048	6.9	2366.00	290631.25
66	325	79.92	0.03095	8.1	2492.00	242243.75
67	330	81.13	0.03143	9.3	2597.00	198756.25
68	335	82.39	0.03190	10.5	2681.00	149756.25
69	340	83.68	0.03238	11.8	2742.25	125562.50
70	345	85	0.03286	13.2	2798.25	81156.25
71	350	86.34	0.03333	14.5	2817.50	21131.25
72	355	87.68	0.03381	15.8	2819.25	450493.75
73	360	89.02	0.03429	17.2	2789.50	-3453887.50
Don't Plot	5	90.33	0.00048	18.5
	10	91.6	0.00095	19.8

Transcribed Image Text:

Angular velocity w = = Time increment = Ram minimum position 93min = 1750 rpm ? 10500 deg/s S ? deg Data Crank Ram Crank Ram Angular Ram Angular Ram Angular Point Angle Angle Time Displacement Index 0 (deg) 03 (deg) t(s) 03 - 03min (deg) Velocity W3 (deg/s) Acceleration 3 (deg/s) Don't plot 350 86.3 0.03333 14.5 2852.5 these rows 355 87.7 0.03381 15.9 2852.5 1 0 89 0.00000 17.2 2712.5 -107187.5 2 5 90.3 0.00048 18.5 2747.5 -64312.5 3 10 91.6 0.00095 19.8 2625 -269500 72 355 87.7 0.03381 15.9 2852.5 -202125 73 360 89 0.03429 17.2 2712.5 -107187.5 Don't plot 5 90.3 0.00048 18.5 2747.5 these rows 10 91.6 0.00095 19.8 2625 Angular velocity w = = Time increment = Ram minimum position 93min = 1750 rpm ? 10500 deg/s S ? deg Data Crank Ram Crank Ram Angular Ram Angular Ram Angular Point Angle Angle Time Displacement Index 0 (deg) 03 (deg) t(s) 03 - 03min (deg) Velocity W3 (deg/s) Acceleration 3 (deg/s) Don't plot 350 86.3 0.03333 14.5 2852.5 these rows 355 87.7 0.03381 15.9 2852.5 1 0 89 0.00000 17.2 2712.5 -107187.5 2 5 90.3 0.00048 18.5 2747.5 -64312.5 3 10 91.6 0.00095 19.8 2625 -269500 72 355 87.7 0.03381 15.9 2852.5 -202125 73 360 89 0.03429 17.2 2712.5 -107187.5 Don't plot 5 90.3 0.00048 18.5 2747.5 these rows 10 91.6 0.00095 19.8 2625