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