Author Archives: dougaj4

Newton’s Cradle

Posted on 20/07/2008 by dougaj4

Previous animation post I have added a Newton’s Cradle animation to the animation file posted previously: Animation.zip The animation finds the correct period for the input string length and starting angle, and displays the movement of the balls in real … Continue reading →

Posted in Animation, Drawing, Excel, Newton | Tagged , , , | 4 Comments

Drawing in Excel-4

Posted on 15/07/2008 by dougaj4

This post will look in a bit more detail at the methods presented in the previous post.  It would be a good idea to open the previous post on another tab, or download the example file and open the code … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 3 Comments

The history of the theory of beam bending – Part 3

Posted on 12/07/2008 by dougaj4

In the previous post in this series I took the story up to 1773 and the work of Coulomb, skipping over the work of the Bernoulli family and Euler, which in the modern context was certainly the most important advance in … Continue reading →

Posted in Beam Bending, Newton | Tagged , , , | 5 Comments

Evaluate Function – update

Posted on 05/07/2008 by dougaj4

Previous post The evaluate function described in the previous post has been used in writing a UDF that will evaluate the integral of any suitable function over a specified range. The revised worksheet can be downloaded from: Eval.zip

Posted in Excel, Maths, UDFs | Tagged , , , , | 5 Comments

Drawing in Excel-3

Posted on 04/07/2008 by dougaj4

Previous post OK, here are some of the promised basics of using VBA to create drawings in Excel. This and following posts will cover: The shape objects and how to create them How to select, group, and delete shapes How … Continue reading →

Posted in Drawing, Excel | Tagged , , , | 6 Comments