Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
Recent Comments
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 Excel, Interpolation, Intersection Points, Polar Coordiantes, Rectangular Coordinates, UDF, VBA
37 Comments
Ideas for suspension bridges
here: – mollwollfumble’s science Some old, some new, some might work, some just plain weird.
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 animation, Excel, Newton's Cradle, VBA
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
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