please provide equations for everything how you typed it in excel as that is my main Question. Table is the correct answers for checking
1. Four-bar Mechanism (leading form): Given: r1=2.5in., 12 = 1.0in., r3 = 3.1in., r4 = 2.0in., az = lin., b;= 1.0in. Find: Use the spreadsheet (4bar template.xls) posted on Canvas to find 03, 0s, Xp, and yp for each value of 8, from 0-360 in increments of 10). Plot a scatter plot of 8 vs. 03 and 04 (on one plot) and x, vs. y, on a separate plot. Submit a printout of your spreadsheet and the two plots. Check: 0:3 = 30) = 19.36 = 62 6 2 0 1.5000 0.0000 32.31087 124.0558 23.6334 10 1.5251 6.53781 32.9359 122.5699 24 4942 201 1.5974 12.3637 34.5028 118.5990 26.8982 30: 1.7088 17.0142: 36.3767 113.1773 30.4460 401 1.8493 20.3400 38.0415 107 2231 34.7354 50 2.0090 22.4147 39.2471 101.2950 39.4579 60 2.1794 23.4132 39.9422 95.6614: 44.3964 709 2.35371 23.5307 40.1764 90.4266 49.3970 80 2.5262 22.9443: 40.0366 85.6198 54 3436 25 1.6488 14.8520 35.4397 116.0042: 28.5560 100 2.84931 20.2207 39.00171 77.2863 63.7120 1101 2.99339 18.2961 38.2718 73.7520 67.9762 120 3.1225 16.102137.4947 70.6423 71.8630 130 3.2348 13.69851 36.7300 67.9674 75.3026 140 3.32871 11.13401 36.0293 65.74251 78.2282: 150 3.4030 8.44911 35.4362 63.98551 80.5783 160 3.4567 5.6784 34.98601 62.7145 82 2995 170 3.4891 2.8527 34.7051 61.9449 83.3500 180 3.50009 0.00001 34.6096 61.68711 83.7033 190 3.4891 2.8527 34.7051 61.9449 83.3500 2007 3.4567 5.6784 34.9860 62.7145 82.2995 210 3.4030 8.44911 35.4362 63.9855 80.5783 220 3.32871 11.13401 36.02931 65.7425 78.2282 230 3.2348 13.69851 36.7300 67.9674 75.3026 240 3.1225 16.1021 37.4947 70.6423 71.8630 250 2.99331 18.29611 38.2718 73.7520 67.9762 2601 2.84931 20.22071 39.00171 77.28631 63.7120 270 2.69261 21.80141 39.6159 81.2415 59.1426 280 2.5262 22.94439 40.0366 85.6198 54.3436 290 2.3537 23.5307 40.1764 90.4266 49.3970 300 2.1794 23.41321 39.9422 95.6614 44.3964 83 32.311 26.40 22.14 19.36 17.70 16.83 16.53 16.65 17.09 20.59 18.78 19.98 21.39 23.03 24.90 26.99 29.31 31.85 34.61 37.56 40.66 43.89 47.16 50.43 53.60 56.57 59.22 61.42 62.98 63.71 63.36 64 55.94 50.89 49.04 49.81 52.44 56.29 60.93 66.04 71.44 49.14 82.49 87.95 93.26 98.33 103.12 107.57 111.611 115.20 118.31 120.91 122.96 124.46 125.39 125.73 125.46 124.54 122.93 120.56 117.32 113.10 107.75 HII Trigonometric Position Analysis Hall 4-bar 4-bar 8= 5x +r3 - 2r,r, cos , ; coupler link B 1 +8 - Brcos 2r8 coupler point ba W = cos 1 + 8 - : 2r;8 3 2 = cos og-4X +82-r 21,8 13 a 02 AS side link (rocker) 14 For oss 0; = Y-(B-@); 2. = 7 - 1-(8-0) side link (crank) 12 04 0: 1 1 x also ir + 8 y = $cos 2rars lagging form CCW angles are positive, CW angles are negative 1. Four-bar Mechanism (leading form): Given: r1=2.5in., 12 = 1.0in., r3 = 3.1in., r4 = 2.0in., az = lin., b;= 1.0in. Find: Use the spreadsheet (4bar template.xls) posted on Canvas to find 03, 0s, Xp, and yp for each value of 8, from 0-360 in increments of 10). Plot a scatter plot of 8 vs. 03 and 04 (on one plot) and x, vs. y, on a separate plot. Submit a printout of your spreadsheet and the two plots. Check: 0:3 = 30) = 19.36 = 62 6 2 0 1.5000 0.0000 32.31087 124.0558 23.6334 10 1.5251 6.53781 32.9359 122.5699 24 4942 201 1.5974 12.3637 34.5028 118.5990 26.8982 30: 1.7088 17.0142: 36.3767 113.1773 30.4460 401 1.8493 20.3400 38.0415 107 2231 34.7354 50 2.0090 22.4147 39.2471 101.2950 39.4579 60 2.1794 23.4132 39.9422 95.6614: 44.3964 709 2.35371 23.5307 40.1764 90.4266 49.3970 80 2.5262 22.9443: 40.0366 85.6198 54 3436 25 1.6488 14.8520 35.4397 116.0042: 28.5560 100 2.84931 20.2207 39.00171 77.2863 63.7120 1101 2.99339 18.2961 38.2718 73.7520 67.9762 120 3.1225 16.102137.4947 70.6423 71.8630 130 3.2348 13.69851 36.7300 67.9674 75.3026 140 3.32871 11.13401 36.0293 65.74251 78.2282: 150 3.4030 8.44911 35.4362 63.98551 80.5783 160 3.4567 5.6784 34.98601 62.7145 82 2995 170 3.4891 2.8527 34.7051 61.9449 83.3500 180 3.50009 0.00001 34.6096 61.68711 83.7033 190 3.4891 2.8527 34.7051 61.9449 83.3500 2007 3.4567 5.6784 34.9860 62.7145 82.2995 210 3.4030 8.44911 35.4362 63.9855 80.5783 220 3.32871 11.13401 36.02931 65.7425 78.2282 230 3.2348 13.69851 36.7300 67.9674 75.3026 240 3.1225 16.1021 37.4947 70.6423 71.8630 250 2.99331 18.29611 38.2718 73.7520 67.9762 2601 2.84931 20.22071 39.00171 77.28631 63.7120 270 2.69261 21.80141 39.6159 81.2415 59.1426 280 2.5262 22.94439 40.0366 85.6198 54.3436 290 2.3537 23.5307 40.1764 90.4266 49.3970 300 2.1794 23.41321 39.9422 95.6614 44.3964 83 32.311 26.40 22.14 19.36 17.70 16.83 16.53 16.65 17.09 20.59 18.78 19.98 21.39 23.03 24.90 26.99 29.31 31.85 34.61 37.56 40.66 43.89 47.16 50.43 53.60 56.57 59.22 61.42 62.98 63.71 63.36 64 55.94 50.89 49.04 49.81 52.44 56.29 60.93 66.04 71.44 49.14 82.49 87.95 93.26 98.33 103.12 107.57 111.611 115.20 118.31 120.91 122.96 124.46 125.39 125.73 125.46 124.54 122.93 120.56 117.32 113.10 107.75 HII Trigonometric Position Analysis Hall 4-bar 4-bar 8= 5x +r3 - 2r,r, cos , ; coupler link B 1 +8 - Brcos 2r8 coupler point ba W = cos 1 + 8 - : 2r;8 3 2 = cos og-4X +82-r 21,8 13 a 02 AS side link (rocker) 14 For oss 0; = Y-(B-@); 2. = 7 - 1-(8-0) side link (crank) 12 04 0: 1 1 x also ir + 8 y = $cos 2rars lagging form CCW angles are positive, CW angles are negative
