Tag Archives: unit aware

Evaluating text with units and finding the neutral axis

A few weeks ago a comment asked for guidance on finding the moment capacity of a reinforced concrete section.  This post will look at finding the depth of the neutral axis (NA) in a rectangular section, with a single layer of … Continue reading

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

Moving Load Spreadsheet – update and how to use

As noted in the comments on the previous post on this topic, the moving load function (and also the associated continuous beam functions) have been modified to make data entry more flexible; the output results are unchanged.  The modified spreadsheet … Continue reading

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

Unit aware continuous beam spreadsheet update

The ConbeamU spreadsheet provides Excel user defined functions (UDFs) for the analysis of continuous and simply supported beams and cantilevers using Macaulay’s method.  It allows complex combinations of any number of partial distributed loads, point loads and moments, with changes … Continue reading

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , | 1 Comment

Daily Download 24: Units for Excel

The Units4Excel spreadsheet provides: User Defined Functions (UDFs) to convert between any listed units, including compound SI units. A UDF to evaluate any function entered as text, including evaluation of input and output units. Recognition of all standard SI prefixes. An … Continue reading

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

Continuous Beam Spreadsheet – with Units

The spreadsheet previously known as Macaulay has been updated to include “unit aware” versions of all the included functions, and has been renamed “ConBeamU”, to make it more obvious what it does.  The new spreadsheet (including full opens source code) can be … Continue reading

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

ULS Analysis of Concrete Beams; now with added units

The spreadsheet for Ultimate Limit State Analysis of reinforced or prestressed concrete beams, previously presented here, has been combined with the Units4Excel spreadsheet to allow the program to work with any selected units, SI or non-SI.  Provision for the American … Continue reading

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