Category Archives: Newton

Intersections, interpolations, and rotations

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

Ideas for suspension bridges

here: – mollwollfumble’s science Some old, some new, some might work, some just plain weird.

Posted in Newton | Tagged | Leave a comment

Newton’s Cradle

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

The history of the theory of beam bending – Part 3

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

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