Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Deflections and Moments in Rectangular Plates
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Dancing Pendulums
Recent Comments
Tag Archives: Matrix Functions
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
12 Comments
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
Python Matrix Functions with ExcelPython – 2
Following the previous ExcelPython post I have modified the VBA and Python code for improved performance and to simplify the Python coding. The main change is that where Numpy Arrays are required in the Python code, these are now created … Continue reading
Posted in Arrays, Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Link to Python, Matrix Functions, sparse matrix solvers, UDF, VBA
14 Comments
Linking to Python with Excel-Python, and Python matrix functions
I have been experimenting for a few weeks with a new package linking Excel to Python, by the name of ExcelPython. Here is what the author says about it: “ExcelPython is a lightweight, easily distributable library for interfacing Excel and … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Maths, Matrix Functions, Python, Simultaneous equations, sparse matrix solvers, UDF, VBA
5 Comments
Compiled Matrix Functions for Excel
This is a follow on from the previous post, showing how the C# version of the ALGLIB maths library can be accessed from Excel, with very little additional coding. The download file, Matrixdll-c#.zip includes compiled .dll and .tlb files which can be used … Continue reading
Posted in AlgLib, Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, UDFs, VBA
Tagged AlgLib, C++, Eigen values, eigen vectors, Excel, linear equations solver, matrix determinant, Matrix Functions, matrix inverse, sparse solver, UDF, VBA
4 Comments