### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using Goal Seek on Multiple Cells
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Commenting a block of code in VBA
- Drawing in Excel 7 - Creating drawings from coordinates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Fitting high order polynomials

### Recent Comments

Two forks in the Cel… on Tam Lin dougaj4 on Tables and VBA Cameron Wallace on Tables and VBA Evaluating text with… on Reinforced Concrete Section An… Freek van Gilst on On not using Hungarian Notatio… dougaj4 on Reinforced Concrete Section An… dougaj4 on Section Properties with MeshPY… metroxx on Section Properties with MeshPY… dougaj4 on Section Properties with MeshPY… metroxx on Section Properties with MeshPY… metrox on Excel Uservoice and Python for… sado on Reinforced Concrete Section An… dougaj4 on Drawing in Excel 7 – Cre… Section Properties w… on Downloads Charalampos Dala on Drawing in Excel 7 – Cre…

# Tag Archives: AlgLib

## Update to AL-Spline-Matrix

Has the free software at this site saved you time and/or money? If so, please contribute to the Raw Impact charity group providing practical help to poor communities in Cambodia: Everydayhero – Cambodia 2018 All contributions gratefully accepted. Contributions are … Continue reading

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Cubic spline, Excel, spline curve fitting, UDF, VBA, weights and constraints
Leave a comment

## Using Alglib least-squares solvers

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 AlgLib, Excel, Levenberg Marquardt, lsfit, minlm, Numpy, Python, SciPy, UDF, VBA, xlwings
Leave a comment

## Evaluating text and calling Python functions from Excel with xlwings

The Alglib spreadsheet presented here includes functions to evaluate formulas entered as text on the spreadsheet, or to call specified Python functions. I have now added a user defined function (UDF) that will perform either of these operations (xl_CallFuncD), and added … Continue reading

Posted in AlgLib, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged AlgLib, call Python functions, evaluate text strings, Excel, Numpy, Python, SciPy, UDF, VBA, xlwings
1 Comment

## Excel to Alglib via xlwings

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 AlgLib, Cubic Spline functions, curve fitting, Excel, Higher order polynomials, Matrix Functions, Python, UDF, VBA, xlwings
3 Comments

## Weighted Least Squares Regression, using Excel, VBA, Alglib and Python

Least squares linear regression in Excel is easy. That’s what the Linest and Trend functions do. That is, they find the coefficients of a straight line (or higher dimension shape) so that the sum of the squares of the distances of … Continue reading

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged AlgLib, Linest, Python, SciPy, UDF, VBA, Weighted least squares regression
3 Comments

## ExcelPython2, Alglib and Spline-Matrix Rel 2.03

Following a comment here: ExcelPython2, Alglib and Spline-Matrix update I have updated the VBA and Python code, and added a missing Python module to the download zip file. See the earlier post for details of installation and use, or download the revised files … Continue reading

Posted in AlgLib, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged AlgLib, Excel, ExcelPython, Python, Spline-Matrix, UDF, VBA
Leave a comment

## ExcelPython2, Alglib and Spline-Matrix update

The ExcelPython add-in, offering easy access to Python code from Excel VBA, has had a major update to Release 2. The new version provides new features and simpler installation, but has some incompatibilities with code written for the previous version, so the … Continue reading

Posted in AlgLib, Excel, Link to Python, Maths, Newton, UDFs, VBA
Tagged AlgLib, curve fitting, Excel, ExcelPython, Matrix Functions, Python, Spline functions, UDF, VBA
4 Comments