Tag Archives: UDF

Continuous Beams with Shear Deflections

Posted on 31/12/2011 by dougaj4

The Macaulay Spreadsheet has now been modified to optionally include shear deflections, as well as a new option to output support reactions, and fixes to minor bugs. The revised spreadsheet (including full open source code) can be downloaded from: Macaulay.zip … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | 10 Comments

Continuous Beams With Spring Supports by Macaulay’s Method

Posted on 15/12/2011 by dougaj4

Following the last post on this topic: Continuous Beams With Cantilevers by Macaulay’s Method, and by popular demand, I have now updated the continuous beam and single span analysis functions to accept spring translational and moment restraints.  Also added is … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | 36 Comments

Continuous Beams With Cantilevers by Macaulay’s Method

Posted on 05/12/2011 by dougaj4

Edit 13 Apr 2014: See Continuous Beam Spreadsheet with Moving Load for the latest version, which is now called ConBeamU. I have updated the Macaulay spreadsheet (described here) to allow the analysis of continuous beams with cantilevers at one or … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | 12 Comments

Linest, NPV, IRR and solving polynomials

Posted on 01/12/2011 by dougaj4

In a comment on Using LINEST for non-linear curve fitting Lori Miller posted a formula that found the coefficients fitting a cubic polynomial curve to a set of data, then solved the resulting equation to find the X value for a given … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 3 Comments

Linestgap with data in rows

Posted on 26/11/2011 by dougaj4

In response to a comment I have modified the LinestGap function to work on data arranged in rows.  This function works the same as the Excel built in LinEst function, but ignores any data that has a blank cell in the … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , | 11 Comments