Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Removing Add-ins
- Latex Maths Text in Excel
- Commenting a block of code in VBA
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Solving cubic and quartic equations with Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Retrieving unique values from a range or array ...
Recent Comments
Tag Archives: Newton
ULS Design Functions 2.13
Update 17 May 2022: Following discussion on 10-11 May 22 the download file has been updated to version 2.15, fixing problems with the interaction diagram with a rectangular stress block under high axial loads. I have uploaded another update to … Continue reading
Posted in Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, Excel, Newton, non-rectangular concrete sections, Parabolic stress block, UDF, ULS design of concrete, VBA
25 Comments
Solving the Lagrangian Point equation for the Moon
This post was prompted by a recent question at Fitting high order polynomials, asking for Excel methods to solve the equations for the radius of the Moon’s Lagrangian Point 1. All the methods described in this post have been added to … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Excel, iterative solution, Lagrangian point, Newton, polynomial solution, UDFs, VBA
3 Comments
Falling feathers and hammers
It is well known that at the end of the Apollo 15 Moon landing, Commander David Scott dropped a hammer and a feather to demonstrate that they would accelerate at the same rate, and land on the ground together: What is … Continue reading
The statement below is false
If you think I’m wrong, try looking at it from a different perspective. The picture above came from an optical illusion blog at: http://www.anopticalillusion.com/ and I was led there from: http://www.josleys.com/index.php which is an amazing collection of mathematical imagery by … Continue reading
Posted in Bach, Maths, Newton, Ray Tracing
Tagged Bach, Fractals, mathematical images, Newton, optical illusions
Leave a comment
Daily Download 28: The Hole Through the Middle of the Earth, using ODE solvers, and Three Blokes
Today’s download is based on a series of posts on the “hole through the middle of the Earth”, which by devious means has been tied in with the solution of differential equations, buckling of columns, and a story by Bill … Continue reading
Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA
Tagged air density, Bill Bailey, column buckling, hole trough the middle of the Earth, Newton, Three blokes
Leave a comment