Category Archives: Curve fitting

More circle fitting options with Scipy

Posted on 17/03/2018 by dougaj4

A comment on the first post on this topic found that the method used did not work well for short arcs of large radius circles.  An example of the problem can be seen in the screen shots below: The function … Continue reading →

Posted in Coordinate Geometry, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | Leave a comment

Cubic splines with jagged data

Posted on 07/02/2018 by dougaj4

A cubic spline provides a good approximation to a smooth curve, and alternative versions are available for free download (see Daily Download 22: Splines and Curves, Update to AL-Spline-Matrix, and xlwSciPy 1.09 – update for xlwings 0.10 and Scipy 0.18.1), but if … Continue reading →

Posted in Arrays, Beam Bending, Concrete, Curve fitting, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 2 Comments

Using Alglib least-squares solvers

Posted on 23/09/2017 by dougaj4

Following the last post on using the Python version of Alglib from Excel, via xlwings, this post looks in more detail at alternatives for fitting a non-linear function to a set of data, using the Levenberg-Marquardt method.  The spreadsheet with … Continue reading →

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , , , , | 2 Comments

Excel to Alglib via xlwings

Posted on 11/08/2017 by dougaj4

The Alglib library provides many valuable numerical analysis routines, but the VBA version is no longer actively maintained.  The latest versions are available in C++, C#, and Python, of which the Python version (in conjunction with xlwings) provides the easiest interface … Continue reading →

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, Numerical integration, UDFs, VBA, xlwings | Tagged , , , , , , , , , | 12 Comments

Plotting Freeze-Thaw Data …

Posted on 21/06/2017 by dougaj4

… or other irregular cyclic data. Another Eng-Tips question asked how to approximate ice area over a freeze-thaw cycle using a function based on a sine or cosine curve.  The screen-shot below shows three alternatives: Using built in Excel functions requires … Continue reading →

Posted in Arrays, Curve fitting, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment