Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Writing Arrays to the worksheet - VBA function
- Downloads
- Cubic Splines
- Automatic download of csv files
- XLDennis, the MSDN Library, and VBA rant
- Linking Excel to C
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Author Archives: dougaj4
Elegant Solutions – completing the square
When I was at school (many years ago), if I recall correctly, we were told of the “completing the square” method of solving quadratic equations, but I never really appreciated the elegance of this method because it was treated as … Continue reading
Posted in Excel, Maths, Newton
Tagged completing the square, Excel, Maths, Quadratic equations, Skydrive
1 Comment
2010 in review
The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health: The Blog-Health-o-Meter™ reads Wow. Crunchy numbers The Louvre Museum has 8.5 million visitors per year. … Continue reading
Buckling of rings and arches
In 2007 I wrote a paper on buckling of confined steel tunnel liners for the ANZ Geomechanics Conference in Brisbane, and in the course of that I noticed that the calculated buckling load of an unconstrained pipe subject to uniform radial load was significantly … Continue reading
Posted in Arch structures, Beam Bending, Excel, Newton, VBA
Tagged buckling, Excel, Rings and Arches, VBA
15 Comments
Salutary pictures for bridge engineers
Following the Minnesota bridge collapse, Time magazine published photos of the ten worst bridge collapses of the last 100 years: The Worst Bridge Collapses in the Past 100 Years An interesting list, many of which I hadn’t heard of, although … Continue reading
ULS design of reinforced concrete, AS, ACI and European codes
The previous post in this series compared the results of current and previous Australian Standards, and the ACI 318 code, for the ultimate bending capacity of a rectangular reinforced concrete section, subject to combined bending and axial load. I have now extended … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs
Tagged ACI 318, AS 3600, BS 5400, BS 8110, Concrete, EC 2, Reinforced Concrete, Section Analysis, Ultimate capacity
1 Comment