Category Archives: Excel

3D Frame with zero stiffness hinges

The previous version of 3DFrame allowed for spring releases at beam ends, but if the release stiffness was entered as zero it was treated as a rigid connection for that freedom.  Effectively zero stiffness releases could be modelled by entering … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton | Tagged , , , , , | 3 Comments

Numerical Integration; Tanh-Sinh Quadrature v. 4.42

Back to Newton and Excel. I recently received a new update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes, which may be downloaded from: Tanh_Sinh Quadrature. From the Readme: The Tanh-Sinh quadrature workbook has been enhanced as follows: The Tanh-Sinh … Continue reading

Posted in Charts, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , , | Leave a comment

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 , , , , , | 6 Comments

mpmath for Excel

mpmath has been mentioned in passing here before, but not in any detail.  The mpmath site says: mpmath is a free (BSD licensed) Python library for real and complex floating-point arithmetic with arbitrary precision. It has been developed by Fredrik … Continue reading

Posted in Excel, Link to Python, Maths, PyXLL, UDFs, VBA, xlwings | Tagged , , , , , , , , | Leave a comment

Transferring large arrays with Pyxll

Pyxll is a commercial Excel add-in linking Excel and Python.  The latest version  offers greatly improved performance in transferring data between Excel and Python as Numpy arrays, amongst many other new features and improvements. To check what this means in practice, … Continue reading

Posted in Arrays, Excel, Frame Analysis, Link to Python, PyXLL, UDFs, VBA | Tagged , , , , , , | Leave a comment

More updates to ArcSpline and IP2

I have uploaded version 2.18 of the IP2 spreadsheet to: The new version includes updates to the IP, IP_4, and ArcSpline functions, as described below.  The download is free and includes full open-source code. The IP and IP_4 functions find … Continue reading

Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

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: 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 , , , , , , , | Leave a comment