Category Archives: Excel

Reinforced Concrete Moment-Curvature – 2; Shrinkage and Creep

Posted on 08/12/2009 by dougaj4

The previous post in this series provided an Excel User Defined Function (UDF) to find  the short term curvature of a reinforced concrete section subject to combined bending and axial load.  In this post UDFs will be presented to determine the strain … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 4 Comments

Daniel’s XL Toolbox

Posted on 25/11/2009 by dougaj4

I downloaded this yesterday: Daniel’s XL Toolbox “Daniel’s XL Toolbox is a free, open source add-in for Excel® that helps you to analyze and present data.” See the link for a full description. I’ve only had a brief look, but … Continue reading →

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

Reinforced Concrete Moment-Curvature – 1

Posted on 22/11/2009 by dougaj4

The flexural curvature of any beam composed of material with linear elastic behaviour, subject to a bending moment, M, is given by: C = M / EI where E is the elastic modulus of the beam, and I is its … Continue reading →

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

Some New Links

Posted on 09/11/2009 by dougaj4

A couple of return links to sites that have been sending traffic my way, and are well worth a look: AJP Excel Information (Andy Pope’s site): “The intention of this site is to be a useful resource of alternative solutions … Continue reading →

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

Chart Trend Lines and the Linest Function

Posted on 03/11/2009 by dougaj4

At the Mr Excel discussion forum the output of the worksheet function Linest(), compared with chart trend lines raised a question, where it is said that in Excel 2007 the trend line gives different (and incorrect) coefficients for a polynomial curve … Continue reading →

Posted in Excel, Maths | Tagged , , , , | 1 Comment