### 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
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Time in hours and minutes between two dates
- Writing Arrays to the worksheet - VBA function
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads by category
- Biaxial bending update

### Recent Comments

Mohd Yousef on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Beam Fixed End Actions by Maca… Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw… SDAmy on Time in hours and minutes betw… Concrete Stress Bloc… on Equivalent Stress Blocks Concrete Stress Bloc… on Stress blocks in AS 3600

# 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