Category Archives: Excel

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

Reinforced Concrete Section Analysis – with prestress

Posted on 25/10/2009 by dougaj4

The simplified reinforced concrete section analysis spreadsheet presented here has been revised to allow the input of a pre-tension stress to either or both layers of reinforcement.  The spreadsheet (including full open source code) can be downloaded from RC Design Functions5. Note … Continue reading →

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