Tag Archives: VBA

Intersections, interpolations, and rotations

Posted on 10/08/2008 by dougaj4

Amongst the many and varied functions provided by Excel (or as far as I know any other spreadsheet) there are none that provide a one step process for linear interpolation, finding the intersection points of lines, or conversion between polar … Continue reading →

Posted in Coordinate Geometry, Excel, UDFs, VBA | Tagged , , , , , , | 37 Comments

Drawing in Excel 5 – Shape List

Posted on 26/07/2008 by dougaj4

Previous Post For some reason best known to Microsoft, the Excel documentation does not include a graphic list of shapes with an example of each shape, and the text list they do provide is incomplete.  The file shapelist.zip rectifies that … Continue reading →

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

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

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