Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Linking Excel to C - 2
- Downloads
- Frame Analysis with Excel - 3, Continuous beam or frame
- 3DFrame - 3D Frame analysis for Excel
- Writing Arrays to the worksheet - VBA function
Recent Comments
Category Archives: Newton
Elegant solutions, 192 of them
The Edge is a place where they seek: To arrive at the edge of the world’s knowledge, seek out the most complex and sophisticated minds, put them in a room together, and have them ask each other the questions they … Continue reading
VBA code generation on the spreadsheet
A previous post looked at using VBA to generate more VBA code. This post looks at automatic code generation on the spreadsheet, which may be transferred into the a VBA project using the techniques discussed in the earlier post, or simply … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged API, code generation, Excel, Strand7, UDF, VBA
Leave a comment
The Switch Function (VBA and UDF)
Switch is a VBA function that operates in a similar way to the Select Case statement. The function arguments are a series of pairs of values, the first of each pair being an expression that can be evaluated as TRUE … Continue reading
Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Excel, PY curves, Switch function, UDF, VBA
9 Comments
LatPilePY 1.03
The LatPilePY spreadsheet has been updated with detailed corrections to the function for generating PY curves. The updated version can be downloaded from LatPilePY.zip. See LatPilePY 1.02 for more details of the spreadsheet content and background.
Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged COM624, Excel, laterally loaded piles, LatPilePY, UDF, VBA
5 Comments
The Hawkesbury River Bridge at North Richmond, NSW
The bridge over the Hawkesbury River near North Richmond, North-West of Sydney, is one of the first reinforced concrete structures in Australia. At the time of its construction it was the largest reinforced concrete bridge in the country, and it … Continue reading