Category Archives: Newton

ConBeamU 4.08

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

Paper bridge

Making a model bridge out of paper is pretty easy. Making a full size bridge, strong enough to carry a Range Rover, out of just paper takes a bit of doing: It seems the guy who built the bridge (Steve … Continue reading

Posted in Arch structures, Newton | Tagged , , , | Leave a comment

The VBA Decimal data type

This is what the Microsoft on-line help says about using the Decimal data type in VBA “” At least that is what the Microsoft search listed for me, and Google listed nothing from Microsoft related to VBA on the first … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , | 4 Comments

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

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

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