### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Fitting high order polynomials
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Bridges Over the Tiber -3
- Retrieving unique values from a range or array ...
- Drawing in Excel 7 - Creating drawings from coordinates

### Recent Comments

dougaj4 on Buckling of columns with varyi… Marco Valsecchi on Buckling of columns with varyi… Displaying trend lin… on Using LINEST for non-linear cu… RCInteract and RC De… on RC Design Functions 7.03 Larry Schuster on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu…

# Category Archives: AlgLib

## 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
Leave a comment

## 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

## Alglib/Python spline functions update

The Excel Spline-Matrix spreadsheet has now been updated with several new spline interpolation functions. See Alglib/Python linear and non-linear fitting functions for links to download and install the necessary Excel-Python and Alglib files. Also required is Python version 2.7 or 2.6. The … Continue reading

Posted in AlgLib, Arrays, Excel, Link to Python, Maths, Newton, UDFs, VBA
Tagged 3D Spline function, AlgLib, Excel, Excel-Python, Parametric Splines, Python, Radial Basis Functions, Rational Interpolation, Spline functions, UDF, VBA
1 Comment

## Alglib/Python spline functions

Continuing from the previous post, the new xl_Spline-Matrix.zip spreadsheet includes functions for 1D and 2D linear and cubic splines. The basic 1D spline allows for output of linear splines, or 5 different types of cubic spline, as listed above. Output may … Continue reading

Posted in AlgLib, Excel, Link to Python, Maths, Newton, Numerical integration, UDFs, VBA
Tagged 1D splines, 2D splines, AlgLib, Cubic splines, Excel, Excel-Python, Python, spline curve fitting, spline differentiation, Spline Integration, UDF, VBA
1 Comment

## Alglib/Python linear and non-linear fitting functions

I have updated the Alglib spline-matrix spreadsheet to use the latest Alglib release, using the Python version, in conjunction with the Excel-Python add-in. To use the spreadsheet requires: Python ver 2.7 (or 2.6) Excel-Python Alglib with Python interface In addition … Continue reading

Posted in AlgLib, Excel, Link to Python, Newton, UDFs, VBA
Tagged AlgLib, Excel, linear fitting, non-linear fitting, Python, UDF, VBA
4 Comments

## Evaluating text and Integration with Python and ALGLIB

Following the previous post on evaluating mathematical functions entered as text on the spreadsheet, I have now written a spreadsheet with similar functionality using Python functions, and the Excel-Python add-in. Also included are integration functions using the SciPy Python library, … Continue reading

Posted in AlgLib, Arrays, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged AlgLib, evaluation of text strings, Excel, Integration, Python, SciPy, VBA
1 Comment