### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- Installing Adobe Reader non-DC version.
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Lateral pile analyis with PY curves ...

### Recent Comments

vgmendes on LinEstGap with non-linear… dougaj4 on LinEstGap with non-linear… vgmendes on LinEstGap with non-linear… Stan on ALGLIB linear and polynomial f… dougaj4 on ALGLIB linear and polynomial f… S Rijdt on ALGLIB linear and polynomial f… dougaj4 on Fast Search Reminder Larry on Fast Search Reminder Fast Search Reminder… on Opening and searching pdf file… dougaj4 on Opening and searching pdf file… dougaj4 on Weighted Least Squares Regress… GP on Weighted Least Squares Regress… Kamran khan on Opening and searching pdf file… dougaj4 on 3D Frame Update angelgalvanc on 3D Frame Update

# Tag Archives: ExcelPython

## Use Matplotlib from Excel with xlwings

Xlwings is another free and open source package allowing communication between Excel and Python. It now incorporates ExcelPython, and is included in the Anaconda Python package, so will support my ExcelPython based spreadsheets after installation of xlwings using: conda install … Continue reading

Posted in Drawing, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, VBA
Tagged Excel, ExcelPython, link Excel to Python, MatPlotlib, Python, VBA, xlwings
8 Comments

## Tanh-Sinh Quadrature via F2PY – Part 3

For the last of the current series on combining Fortran, Python and Excel with F2PY and ExcelPython I have updated the xlSciPy spreadsheet to include two other variants of the Tanh-Sinh function: Quad_TSi integrates a non-periodic function over a semi-infinite … Continue reading

## xlSciPy – Python SciPy for Excel; Update with new functions

The xlSciPy spreadsheet, previously described here, has been updated with new functions for integration, finding equation roots and maxima and minima, solving systems of non-linear equations, and evaluation of equations entered as text. The new version (including full open-source VBA … Continue reading

Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Integration, minimization, Python, root finding, SciPy, SciPy.optimize, solvers, UDF, VBA
Leave a comment

## Solving non-linear equations with two or more unknowns – 5

This will be the last of the series on solving non-linear equations (for now). Up until now all the examples have had two unknown values, and two target values. This can be extended by making three changes to the code: … Continue reading

Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, moment curvature, Newton's Method, Python, SciPy, SciPy optimize function, solving non-linear equations, tension stiffening, two or more objectives, two or more unknowns, UDF, VBA
3 Comments

## IP2 and IP2_py

The IP2 spreadsheet provides functions to calculate: Intersection points of 2D lines or polylines Intersection points of 2 circles, or a line and a circle Intersection circle of two spheres and intersection points of 3 spheres 3D centre point of … Continue reading