### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Latex Maths Text in Excel
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Deflections and Moments in Rectangular Plates
- Using Goal Seek on Multiple Cells
- Taming Symbols in Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Pint, MPmath and implied units, working with Excel

### Recent Comments

Latex Maths Text in… on Pint, MPmath and implied units… dougaj4 on The VBA Decimal data type Ludek on The VBA Decimal data type dougaj4 on The VBA Decimal data type Ludek on The VBA Decimal data type dougaj4 on About Newton Excel Bach Reinaldo Chohfi Jr. on About Newton Excel Bach Solving cubic equati… on Solving Quadratic, Cubic, Quar… David N on A Match Function Bug … dougaj4 on A Match Function Bug … SectionProperties up… on SectionProperties update updat… David N on A Match Function Bug … dougaj4 on Fitting 3D circles to scattere… Aaron on Fitting 3D circles to scattere… dougaj4 on 3D plots with the latest …

# 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