### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Cubic Splines
- The angle between two vectors, Python version
- Working with dynamic arrays in Excel
- Returning Arrays From VBA and Python
- Drawing in Excel 7 - Creating drawings from coordinates
- Fitting high order polynomials

### Recent Comments

Working with dynamic… on Returning Arrays From VBA and… dougaj4 on Drawing in Excel – … J.D. on Drawing in Excel – … dougaj4 on The Largest Early World Map… Doug Glancy on The Largest Early World Map… Larry Schuster on How Reinforced Earth work… dougaj4 on ConBeamU 4.13 roshan_rai@hotmail.c… on ConBeamU 4.13 dougaj4 on RC Design Functions 8_03 andre on RC Design Functions 8_03 dougaj4 on RC Design Functions 8_03 andre on RC Design Functions 8_03 dougaj4 on RC Design Functions 8_03 andre on RC Design Functions 8_03 dougaj4 on RC Design Functions 8_03

# Tag Archives: SciPy

## Multiple Integration with Scipy

Scipy has 3 functions for multiple numerical integration in the scipy.integrate module: dblquad: Compute a double integral. tplquad: Compute a triple integral’ nquad: Integration over multiple variables. I have written six functions to call these functions from Excel, via Pyxll: Each … Continue reading

Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, multiple integration, Python, PyXLL, SciPy, UDFs
6 Comments

## More SciPy Solvers

The xlwings Scipy spreadsheet has been updated with a new example of the xl_SolveF function, that uses the Scipy Optimize root function. The new spreadsheet can be downloaded from: xlScipy3.zip The new example uses a python function ic_calc (included in the … Continue reading

Posted in Excel, Link to Python, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged bolt group, Excel, Python, SciPy, solvers, UDFs, VBA, xlwings
Leave a comment

## More iterative solvers

Following the recent post on using Brent’s Method solvers on an array (Iterative solvers and arrays), here is another example with an engineering related problem. The example is included in the xlScipy3 spreadsheet, which can be downloaded from: xlScipy3.zip The depth … Continue reading

Posted in Arrays, Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Brents method, depth of neutral axis, Excel, Python, Reinforced Concrete, SciPy, UDFs, VBA, xlwings
Leave a comment

## Iterative solvers and arrays

A recent thread at Eng-Tips was looking for a solution to the problem described below: The solutions to this problem described below can be downloaded from: ItSolve.zip and xlScipy3.zip The ItSolve.xlsb spreadsheet contains a user defined function (UDF) to solve iterative … Continue reading

## Scipy Statistics Functions – coding and getting help

The Python Scipy library currently has 84 statistics functions. I have now updated the xlwSciPy3 spreadsheet to access all of them directly from Excel. The new version can be downloaded from: xlwSciPy3.zip As usual, the download includes full open-source code. … Continue reading

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Excel, link to Python docs, Python, SciPy, Scipy stats, UDFs, VBA, xlwings
Leave a comment

## xlwSciPy update for Python 3

The xlwSciPy spreadsheet allows a wide variety of the science and maths functions in the Python Numpy and Scipy libraries to be called directly from Excel. The spreadsheet has now been updated for use with Python 3. The spreadsheet and … Continue reading

Posted in Coordinate Geometry, Differential Equations, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, UDFs, VBA, xlwings
Tagged Excel, Numpy, Python, SciPy, UDF, VBA, xlwings
2 Comments

## More circle fitting options with Scipy

A comment on the first post on this topic found that the method used did not work well for short arcs of large radius circles. An example of the problem can be seen in the screen shots below: The function … Continue reading

Posted in Coordinate Geometry, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged curve fitting, Excel, least squares, Numpy, ODR, Python, SciPy, VBA
Leave a comment