Recent Comments
dougaj4 on Multiple Integration with… dougaj4 on Multiple Integration with… dougaj4 on Multiple Integration with… 
Excel Developer (@ex… on Multiple Integration with… Excel Developer (@ex… on Multiple Integration with… Excel Developer (@ex… on Multiple Integration with… dougaj4 on Another (very slow) way of com… 
Matt on Another (very slow) way of com… Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… dougaj4 on Using the AlgLib ODE (Runge-Ku… Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… 
Larry on Scarborough Fair 
g2-9ed9acc685824c666… on Scarborough Fair 
Daniel Crotzer on About Newton Excel Bach More SciPy Solvers |… on xlwSciPy update for Python…
Author Archives: dougaj4
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
Solid Air – Norma Waterson
I don’t know how I missed this, but I just discovered yesterday: More about the album: The Very Thought of You On her second solo album the Grande Dame of British folk is presenting us with a surprising, inspired selection … Continue reading
Posted in Bach
Tagged Danny Thompson, John Martyn, Martin Carthy, Norma Waterson, Richard Thompson
Leave a comment
Python Problems
I have recently returned to using Pyxll to link Excel to Python (of which more later), which required the installation of a 32 bit version of Python 3.7. First trials after installation returned the message: “AttributeError: ‘module’ object has no … Continue reading
Posted in Computing - general, Link to Python, NumPy and SciPy
Tagged CLSIDToPackageMap, installation, Python, py_gen
Leave a comment
Numerical Integration; Tanh-Sinh Quadrature v. 4.4
Update 27 Nov 2018: Version 4.41 now available from the link below, with minor modifications for compatibility with Excel 2007. I recently received a new version (4.4) of the numerical integration spreadsheet by Graeme Dennes which is now available for … Continue reading
Posted in Charts, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Double Exponential, Excel, Gauss-Kronrod, numerical integration, Romberg, Tanh-Sinh method, Tanh-Sinh Quadrature, UDF, VBA
9 Comments
AS 3600 and RC Design Functions 8.01
The updated RC Design Functions spreadsheet (presented here) included an updated UMom function to find the ultimate strength of a rectangular section under combined bending and axial load; but I omitted to include the revisions to the alpha2 and Gamma … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, Excel, Rectangular stress block factors, Reinforced Concrete Design Functions, UDF, ULS design, VBA
Leave a comment
Falling feathers and hammers
It is well known that at the end of the Apollo 15 Moon landing, Commander David Scott dropped a hammer and a feather to demonstrate that they would accelerate at the same rate, and land on the ground together: What is … Continue reading
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
