Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Downloads
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Lists and Arrays in Excel
- Writing Arrays to the worksheet - VBA function
- Filling Blanks with Go To-Special (and local help rant)
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Author Archives: dougaj4
Debugging VBA – 2
Following on from the opening post in this series (Debugging VBA) I will now look at the main debugging tools provided in the Visual Basic Editor (VBE): The Immediate Window allows interaction with the code while it is running. In the … Continue reading
Posted in Excel, UDFs, VBA
Tagged Debugging, Excel, Immediate window, UDF, VBA, watches window
Leave a comment
Using LatPilePY
LatPilePY is a User Defined Function (UDF) used to analyse the deflections and load actions in laterally loaded piles. It was presented in this post: LatPilePY. In response to an e-mail request, this post will give step by step instructions for … Continue reading
Posted in Arrays, Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Array Function, COM624, Excel, Laterally loaded pile, Non-linear concrete, UDF, VBA
Leave a comment
Buckling of Tubes – 2
Following on from yesterday’s post, today we’ll look at the buckling of the cylindrical tubes: The tube in this analysis was defined to have a small (0.01 mm) asymmetric bulge at mid height, to initiate buckling. The video shows that … Continue reading
Buckling of Tubes
The video here The Surfing Scientist shows a rough and ready experiment demonstrating the superior strength under axial load of cylindrical tubes, compared with square tubes (skip to 1:30 if you are not interested in the chat). The conclusion about … Continue reading
Posted in Finite Element Analysis, Newton
Tagged buckling, FEA, square tube, Strand7, Surfing Scientist
4 Comments
The Rough Island Band
Some more from John Elliot (who appeared under the name “the little unsaid” in the previous post), here performing with an aptly named group from the Scilly Isles called The Rough Island Band. First performing Paul Simon’s “Call me Al”, … Continue reading