3D Dancing Pendulums
I received a lot of positive feedback which is appreciated.
One respondent, Stephen, asked a question about the Pendulum not being modeled as 3D.
Which isn’t correct as the pendulums are moving on, and hence represented on, a 2D plane within 3D space.
However this got me thinking!
There was no reason I couldn’t do a Side View and Top View of the Pendulums at the same time.
This allowed a user to view the Pendulums from the 3 views simultaneously. The animations will all be in sync as they should because they are all based on the same input and a series of named ranges.
The extra work involved adding a named range for each pendulum for the z value and copying the first chart and re-arranging axis for the different views.
This post won’t describe how to do this but if you are interested I direct you to the original post at Excelhero.com where the whole project is described.
Please enjoy the revised Pseudo 3D file.
Why Stop at Pseudo 3D ?
But why stop at pseudo 3D?
A while back I had played with a 3D transform spreadsheet that Andy Pope had made over at AJP Excel Information.
Andy had used a series of 3D transform matrices to transform 10 points on a scatter chart and rotate them around.
So I blatently
stole borrowed Andy’s example and took the logic into the Named Formula that I had used for the Dancing Pendulums.
I hope you enjoy the outcome:
The Excel version is a lot faster with smoother and more fluid animation than the Animated GIF display above, especially if you are using Internet Explorer.
I will be doing a separate post on the construction of this model when I find the time.
But until then I refer you to:
A detailed explanation of the orginal Dancing Pendulums model is available at: ExcelHero.com.
Any Popes 3D Transform is at AJP Excel Information.
In the meantime, I will be happy to answer any questions you have regarding this model in the comments.
I’m rather proud of how well this turned out and have to keep reminding myself that it is just a simple Excel XY Scatter Chart.
Please enjoy the 3D Dynamic Pendulums files.
I hope you enjoy this post as much as I did making it!
Update (7 July 2011)
I have added Axis Labelling and Automatic Y Axis Rotation options
Leave a Reply
|NPV() function to calculate Present Value||Sumproduct function to Consolidate Revenues?|