Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Cubic Splines
- Automatic download of csv files
- Frame Analysis with Excel - 3, Continuous beam or frame
- Daily Download 4: Continuous Beam Analysis
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Category Archives: Newton
LatPilePY 1.02
Following some discussion at Eng-Tips and elsewhere I have updated the LatPilePY spreadsheet, previously presented at Lateral pile analysis with PY curves … This spreadsheet provides User Defined Functions (UDFs) to carry out the analysis of vertical piles under lateral loading, … Continue reading
Posted in Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged COM624, Excel, laterally loaded piles, PY curves, soil properties, UDF, VBA
3 Comments
Continuous Beams with Shear Deflections
The Macaulay Spreadsheet has now been modified to optionally include shear deflections, as well as a new option to output support reactions, and fixes to minor bugs. The revised spreadsheet (including full open source code) can be downloaded from: Macaulay.zip … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, shear deflections, support reactions, UDF, VBA
10 Comments
Bach for Christmas
Al Vachris sent me a link to this visualisation of the opening Prelude from Bach’s 1st Suite for Solo Cello: “Baroque.me (2011) by Alexander Chen. Video capture. baroque.me visualizes the first Prelude from Bach’s Cello Suites. Using the math behind … Continue reading
Posted in Bach, Newton
Tagged Bach, Pablo Casals, Suites for solo cello, visualisation
Leave a comment
When does 35 not equal 35?
… and when does 35 – 35 not equal zero? In the first case the answer is when one “35” is on an Excel spreadsheet and the other 35 is in VBA. The question arose from the ongoing continuous beam … Continue reading
Posted in Excel, Maths, Newton, VBA
Tagged Excel, Floating point arithmatic, IEE 754, VBA
12 Comments
The “Glass Bridge” King’s Park, Perth
The Lotterywest Walkway is a fairly recent addition to Perth’s King’s Park, featuring a spectacular arched pedestrian bridge built of weathering steel with glass parapets. My impressions are shown in the photos below. Click on any image for a slide show.
Posted in Arch structures, Newton
Tagged Glass Bridge, King's Park, Lotterywest Walkway, Perth, steel arch bridge
Leave a comment