Animated 4-bar Linkage

Rating:
16

Description

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

Uploaded
22 Jan 2009
Last Modified
22 Jan 2009
File Size:
50.50 Kb
Downloads:
251
File Version:
1.0
File Author:
Rodney L Huffman
File HomePage:
Click to visit site
Rating:
16

 
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] 13 years ago
bobmo - if you change steps parameter (B11) to 360 then changing the index parameter changes the angle 1 degree per step :)
bobmo 13 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.
Thanks
JohnDoyle[Admin] 13 years ago
bobmo you can just change the index parameter or use the slider control to step through the animation.
bobmo 13 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 15 years ago
Thank you for your submission rlhuffman. We have rewarded you with a free 3 month XLC Pro subscription.