Tag Archives: unit aware

Units and solvers with Pint and Sympy

Posted on July 29, 2018 by

Following the previous post I have adapted the units code to use the Pint package, and added a function using the Sympy equation solver, with Pint units.  I have applied the functions to finding the depth of neutral axis of a … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, UDFs, VBA, xlwings | Tagged , , , , , , , , , , , | Leave a comment

Evaluating text with units and finding the neutral axis

Posted on January 7, 2018 by

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 , , , , , , , , , , | 5 Comments

Moving Load Spreadsheet – update and how to use

Posted on December 3, 2013 by

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

Posted on November 22, 2013 by

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

Posted on October 11, 2012 by

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 , , , , | 1 Comment

Continuous Beam Spreadsheet – with Units

Posted on September 6, 2012 by

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

Posted on August 9, 2012 by

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