Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Cubic Splines
- Contour plots with Excel and Matplotlib
- Fitting high order polynomials
- Latex Maths Text in Excel
- Removing Add-ins
Recent Comments
Jose Luna on More updates to ArcSpline and… Lucas Beattie on Drawing in Excel – … marcengineer on More on combined shear and ben… dougaj4 on More on combined shear and ben… Marc on More on combined shear and ben… Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU
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