Author Archives: dougaj4

Section Properties with MeshPY, including torsion and warping

I recently discovered robbie van leeuwen’s structural engineering blog, which has an open-source set of Python routines for calculation of section properties, including torsion and warping constants.  The program uses the MeshPY Library for generating the finite element meshes required … Continue reading

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Strand7, UDFs, VBA, xlwings | Tagged , , , , , , , , | Leave a comment

Brent’s Method; Update and Examples

Has the free software at this site saved you time and/or money? If so, please contribute to the Raw Impact charity group providing practical help to poor communities in Cambodia: Everydayhero – Cambodia 2018 All contributions gratefully accepted. Contributions are … Continue reading

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

Update to AL-Spline-Matrix

Has the free software at this site saved you time and/or money? If so, please contribute to the Raw Impact charity group providing practical help to poor communities in Cambodia:  Everydayhero – Cambodia 2018 All contributions gratefully accepted. Contributions are … Continue reading

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Raw Impact in Cambodia – Please Donate

Raw Impact is a charity group providing practical help to poor communities in Cambodia: Sustainable and innovative projects with a hand-up model, focusing on simple yet powerful ways to change the game for the poorest of the poor by equipping … Continue reading

Posted in Bach, Newton | Tagged , , , | 1 Comment

Composite Beam Spreadsheet Update 1.01

Following a comment here, I have modified the Composite Beam spreadsheet to correct the stage 1 stresses forces in the reinforcement as listed in Columns 6 and 7, when the tensile face is the top.  The output has also been … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Tables and VBA

I don’t use Excel Tables much, and not at all from VBA (where they are known as ListObjects), but that should probably change, so here are four links with comprehensive help on using Tables from VBA: The Spreadsheet Guru- VBA … Continue reading

Posted in Arrays, Excel, VBA | Tagged , , , , | 3 Comments

A Hard Rain

I happened to be looking at an old post here; Various routes to and from Nottamun Town, featuring Bob Dylan’s performance of A Hard Rain’s Gonna Fall, which led me to Patti Smith’s performance of the same song at last year’s … Continue reading

Posted in Bach | Tagged , , , | Leave a comment