Tag Archives: UDF

ConBeamU 4.08

Posted on 29/11/2015 by dougaj4

The continuous beam spreadsheet has had another update to fix a problem when point loads were applied to cantilevers, and the first support position was not listed as an output point.  The new version (4.08) can be downloaded from: ConbeamU.zip … Continue reading →

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

Importing Text Files; Unix Format

Posted on 10/11/2015 by dougaj4

Text files generated on Unix systems have a different convention to denote the ends of lines to that used on Dos/Windows systems (see Newline for more details).  This was causing problems with the Text-in2 spreadsheet, with small files being imported with … Continue reading →

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

Solving non-linear equations with two or more unknowns – 5

Posted on 20/10/2015 by dougaj4

This will be the last of the series on solving non-linear equations (for now).  Up until now all the examples have had two unknown values, and two target values.  This can be extended by making three changes to the code: … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , , , , , | 3 Comments

Solving non-linear equations with two or more unknowns – 4

Posted on 13/10/2015 by dougaj4

As promised in the previous post, the spreadsheet including the new functions to calculate reinforced (or prestressed) concrete moment-curvature with a revised concrete tension stress-block is now available for download from: RC design functions7.zip The spreadsheet includes full open source … Continue reading →

Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , | 1 Comment

Solving non-linear equations with two or more unknowns – 3

Posted on 08/10/2015 by dougaj4

For the next stage of the non-linear solver saga I am looking at the same problem as in the previous post (finding the curvature or a reinforced concrete section under specified bending moment and axial load), but with more realistic … Continue reading →

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