Author Archives: dougaj4

More from Danny Thompson

Posted on July 31, 2020

… with two of his regular musical partners over the years. Danny Thompson with Richard Thompson, The Ghost of You Walks: and with John Martyn on The Old Grey Whistle Test in 1977; I Couldn’t Love You More:

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

Reinforced Concrete Design for Circular Sections to Eurocode 2

Posted on July 26, 2020

As mentioned in the previous post, the Reinforced Concrete Design Functions spreadsheet includes a function for ULS analysis of circular sections, using either a rectangular  or a parabolic-linear stress block.  A new CircuPF function has now been added, for codes … Continue reading →

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

ULS Design Functions and EurocodeApplied

Posted on July 12, 2020

The ULS Design Functions spreadsheet (last updated here) has had another update (2.09) to fix a problem when bars in different layers had different E values.  The new version assigns the correct E and strain at yield to each layer. … Continue reading →

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

Numerical integration with on-sheet calculations

Posted on July 8, 2020

Following a comment here I have prepared a spreadsheet that works through the Tanh-Sinh Quadrature process with on-sheet calculations.  For that purpose Graeme Dennes has provided a simplified version of the code: QUAD_RODRIGUEZ_TANH_SINH for finite intervals. Translated from HP RPN … Continue reading →

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

Excel functions that return references and new functions

Posted on June 30, 2020

The MyOnlineTrainingHub blog recently posted an article on: Excel Functions that Return References As well as comprehensive advice on the use of OFFSET, INDEX, CHOOSE, IF and INDIRECT, it also covers the new functions XLOOKUP (Excel for Microsoft 365 only), and … Continue reading →

Posted in Arrays, Excel | Tagged , , , , , , , , , | Leave a comment