### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- Cubic Splines
- Lateral pile analyis with PY curves ...
- Installing Adobe Reader non-DC version.
- Solving Quadratic, Cubic, Quartic and higher order equations; examples

### Recent Comments

vgmendes on LinEstGap with non-linear… dougaj4 on LinEstGap with non-linear… vgmendes on LinEstGap with non-linear… Stan on ALGLIB linear and polynomial f… dougaj4 on ALGLIB linear and polynomial f… S Rijdt on ALGLIB linear and polynomial f… dougaj4 on Fast Search Reminder Larry on Fast Search Reminder Fast Search Reminder… on Opening and searching pdf file… dougaj4 on Opening and searching pdf file… dougaj4 on Weighted Least Squares Regress… GP on Weighted Least Squares Regress… Kamran khan on Opening and searching pdf file… dougaj4 on 3D Frame Update angelgalvanc on 3D Frame Update

# 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