### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Cubic Splines
- The angle between two vectors, Python version
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads by category

### Recent Comments

New Tricks … |… on Tool-tip tip Sebastian Brown on Moving averages and User Defin… dougaj4 on Moving averages and User Defin… dougaj4 on More 3D Intersections and 3D p… Sebastian on Moving averages and User Defin… Lawrence Hoffman on More 3D Intersections and 3D p… dougaj4 on Passing variable argument list… maurizio nardò on Passing variable argument list… Units and solvers wi… on Evaluating text with units and… Units and solvers wi… on Working with units in Excel… Larry on Working with units in Excel… dougaj4 on Working with units in Excel… Larry on Working with units in Excel… vefa okumus on Section Properties with MeshPY… dougaj4 on Section Properties with MeshPY…

# Tag Archives: unit aware

## Units and solvers with Pint and Sympy

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 Evaluate text, evaluate units, Excel, Pint, Python, Solve text, Sympy, UDF, unit aware, Units, VBA, xlwings
Leave a comment

## 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 depth of neutral axis, elastic analysis, EvalU, evaluate text strings, evaluate units, Excel, Reinforced Concrete, UDF, ULS analyis, unit aware, VBA
5 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 ConBeamU, continuous beam, Excel, Macaulay's Method, moving load, Solver, UDF, unit aware, VBA
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 continuous beam analysis, Excel, Macaulay's Method, moment restraint, spring supports, UDF, unit aware, VBA
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

## 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 Continuouse beam, Excel, Macaulay's Method, UDF, unit aware, VBA
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 Concrete section, Excel, UDF, ULS Analysis, unit aware, VBA
10 Comments