Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Automating chart scale limits - update
- Filling Blanks with Go To-Special (and local help rant)
- Frame Analysis with Excel - 3, Continuous beam or frame
- The history of the theory of beam bending - Part 1
- Installing Python, Scipy and Pyxll
Recent Comments
Category Archives: Newton
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
Charting a Mathematical Function with Defined Names
This post is a compilation of information from Stephen Bullen, Jan Karel Pieterse, and George Lungu. To quote JKP “When doing mathematics, wouldn’t it be nice if we could type an equation into a cell in Excel and immediately see … Continue reading
Posted in Arrays, Charts, Excel, Maths
Tagged Chart, defined names, Excel, Lissajous Figures, plot function
7 Comments
More on the Excel Evaluate function
Previous posts have presented the Eval() User Defined Function, using the Evaluate function in VBA to evaluate mathematical functions displayed as text (Evaluate Function, Evaluate Function – Update). It was recently pointed out by Jeff Weir that the Evaluate function has its origins … Continue reading
Posted in Excel, Newton, Numerical integration, UDFs, VBA
Tagged Eval, EvalText, Evaluate, Excel, numerical integration, Substitutea, UDF, VBA
4 Comments