I have added a Newton’s Cradle animation to the animation file posted previously:
The animation finds the correct period for the input string length and starting angle, and displays the movement of the balls in real time.
Recent Comments
Benata on Ana Vidović 
mindOnion on Drawing a Buckyball in Ex… 
dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… 
Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… 
Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…
Newton Excel Bach, not (just) an Excel Blog 
Hi Doug –
Very neat, but Newton seems to have lost his gravity 😉
The balls never come to rest.
…Michael
LikeLike
mrt – they wouldn’t move at all if there was no gravity!
But yes, I did assume no loss of kinetic energy at the collisions, which makes everything much simpler.
Maybe I’ll get around to putting in some collision losses one day, but to do it properly it would mean that after the collision all the balls would have some velocity, so the next collision would not occur exactly at the low point, so I’d have to keep track of the position and velocity of every ball, and check for collisions of every pair of adjacent balls at evey step.
LikeLike
Pingback: By Jingo « Newton Excel Bach, not (just) an Excel Blog
Yeah this is cool
LikeLike