Tag Archives: Excel

RC Design Functions 8_03

Posted on 30/04/2019 by dougaj4

The RC Design Functions 8_03 spreadsheet is now available for free download from: RC Design Functions8.zip The main changes are: The NA layer check has been corrected for compression steel in tension The new AS 3600 crack width and curvature … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 11 Comments

Numerical Integration; Tanh-Sinh Quadrature v. 4.42

Posted on 17/03/2019 by dougaj4

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

Multiple Integration with Scipy

Posted on 31/01/2019 by dougaj4

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

Posted on 13/01/2019 by dougaj4

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

Transferring large arrays with Pyxll

Posted on 05/01/2019 by dougaj4

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