### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- The history of the theory of beam bending - Part 1
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials

### Recent Comments

Elastic Biaxial Bend… on Biaxial bending update Bill Harvey on Floating Point Precision … Floating Point Preci… on When does 35 not equal 35… dougaj4 on mpmath for Excel dougaj4 on mpmath for Excel Kapt Blasto on mpmath for Excel mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… mktisis on 3D Frame with zero stiffness… th3budd on Time in hours and minutes betw… dougaj4 on Moving Load Spreadsheet… Ario on Moving Load Spreadsheet… dougaj4 on About Newton Excel Bach David Graves on About Newton Excel Bach

# Category Archives: Maths

## Floating Point Precision Problems

A question on Quora : prompted me to look at how these numbers are handled in Excel, in VBA called from Excel, and in Python called from Excel via pyxll. The results are shown in the screenshot below: Column A … Continue reading

## Eval and Let examples

Final example updated 28th Feb 2021, following comment from Craig: There are many examples of the use of the new Let function on the web (see my previous post on this topic for links). This post compares use of Let … Continue reading

Posted in Excel, Maths, UDFs, VBA
Tagged Eval UDF, Excel, Let function, nested functions, UDFs, VBA
8 Comments

## Units4Excel Update

As discussed here, I have updated the Units4Excel spreadsheet, with the list of non-SI units updated from the latest Wikipedia table. The EvalU user defined function (UDF) has also been modified with three output options, as shown in the screen-shot … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Evaluate text functions, Excel, UDFs, Unit aware calculations, VBA
5 Comments

## Tanh-Sinh Quadrature update

Following some comments here Graeme Dennes and I have modified the start-up code for the Tanh-Sinh Quadrature spreadsheet to avoid problems opening the file when first downloaded, or copied to a new computer. The new file is located (as before) … Continue reading

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, Tanh-Sinh Quadrature, UDFs, VBA
Leave a comment

## Newton-Raphson and Brent’s Method – Solver examples

I recently discovered the Computing Skillset site (via open-struct-engineer), which has good information on the basis and use of the Newton-Raphson method: The Newton Raphson method explained, details, pictures, python code Highly instructive examples for the Newton Raphson method I … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Brents method, Computing Skillset, Excel, Newton Raphson Method, UDF, VBA
Leave a comment