Question: Please use VBA (excel) 3. For the offset slider crank mechanism in Fig.3, (a) develop a computer program that can determine the position of all
Please use VBA (excel)

3. For the offset slider crank mechanism in Fig.3, (a) develop a computer program that can determine the position of all links for crank angles that range from 0 to 360. The algorithm must perform the following calculations e Step 1: Accept numeric data for L1, L2, L3, and store . Step 2: Enter a loop that indexes i from 0 to 360 at a step of your choice . Step 3: Print (or write to file) i, 3, L4 Step 4: Increment i and return back to step 2 (b) What is the range of motion of the slider (c) Plot the transmission angle , between links 2 and 3 as a function of 02, for different values of the offset Ly. How does the offset change the transmission angle. L, L4 Figure 3: Offset slider crank mechanism 3. For the offset slider crank mechanism in Fig.3, (a) develop a computer program that can determine the position of all links for crank angles that range from 0 to 360. The algorithm must perform the following calculations e Step 1: Accept numeric data for L1, L2, L3, and store . Step 2: Enter a loop that indexes i from 0 to 360 at a step of your choice . Step 3: Print (or write to file) i, 3, L4 Step 4: Increment i and return back to step 2 (b) What is the range of motion of the slider (c) Plot the transmission angle , between links 2 and 3 as a function of 02, for different values of the offset Ly. How does the offset change the transmission angle. L, L4 Figure 3: Offset slider crank mechanism
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
