### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Removing Add-ins
- Commenting a block of code in VBA
- Latex Maths Text in Excel
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Solving cubic and quartic equations with Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- 3D Matplotlib Plots in Excel

### Recent Comments

# Category Archives: NumPy and SciPy

## Scipy linear algebra functions in Excel

The file pyLinAlgfuncs3.zip has open source Python code allowing the Scipy linear algebra functions to be called from Excel using the pyxll add-in. It also includes all the Python code to perform LU decomposition, as discussed in the previous post., … Continue reading

Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Liear algebra functions, Link to Python, PyPardiso, PyXLL, Scipy Linalg, UDFs
Leave a comment

## LU Decomposition with Python and Scipy

This post was prompted by a question at the Eng-Tips forum: LU Decomposition which asked why Mathcad was generating LU matrices different to those calculated from the basic theory. The short answer was that there is more than one way … Continue reading

Posted in Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, linear algebra, LUsolve, Python, PyXLL, SciPy
1 Comment

## py_Numpy update and using Numba

The py_Numpy spreadsheet presented at Calling Numpy polynomial functions from Excel has had a minor upgrade to the py_Polyfit function, which was previously returning an error message if the optional “full” argument was set to False. The new version can be … Continue reading

Posted in Curve fitting, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Numba, Numpy, PyXLL, py_Numpy, py_Polyfit, UDFs
Leave a comment

## More on combined shear and bending design to AS 3600

Further to the last post on this subject I have been looking at procedures to speed up design for shear to AS 3600 when the “refined” analysis procedure is used. The issues that need to be addressed are: I have … Continue reading

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Brents method, Combined shear and bending, Excel, Longitudinal shear force, Python, PyXLL, SciPy, shear capacity, UDFs
4 Comments

## Latex Maths Text in Excel

There have been many posts here looking at alternative ways of working with functions entered as text on a spreadsheet, and working with units, most recently here. One drawback with this approach is that text in an Excel cell must … Continue reading

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged EvalU, Excel, Latex, Math Text, mpmath, Pint, Python, PyXLL, Sympy, UDFs, Unit-aware calculation
Leave a comment