Animated 4-bar Linkage



Illustration of animation techniques in Excel. User can specify lengths of members and parameters controlling rotation of the crank. Uses both subroutines and user-defined functions in VBA. Macros must be enabled to run the animation.

Calculation Reference
Mechanisms and kinematics

Submitted On:
22 Jan 2009
File Size:
50.50 Kb
File Version:
File Author:
Rodney L Huffman
File HomePage:
Click to visit site

Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 5
JohnDoyle[Admin] 12 years ago
bobmo - if you change steps parameter (B11) to 360 then changing the index parameter changes the angle 1 degree per step :)
bobmo 12 years ago
Excellent! That helps with the stepping the linkage motion. How can I get the linkage to rotate, say 90 degrees, and return to 0.
JohnDoyle[Admin] 12 years ago
bobmo you can just change the index parameter or use the slider control to step through the animation.
bobmo 12 years ago
It would be great if you could stop the linkage during its run, and if you could cycle it +/- through and angle range.
Nice work!
rlhuffman 14 years ago
Thank you for your submission rlhuffman. We have rewarded you with a free 3 month XLC Pro subscription.