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
- Frame Analysis with Excel 1 - Single beam
- About Newton Excel Bach
- Taming Symbols in Excel
- Downloads
- Writing Arrays to the worksheet - VBA function
- Solving non-linear equations with two or more unknowns – 3
- The Conjugate Beam Method
Recent Comments
Category Archives: Newton
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
Continuous Beams With Spring Supports by Macaulay’s Method
Following the last post on this topic: Continuous Beams With Cantilevers by Macaulay’s Method, and by popular demand, I have now updated the continuous beam and single span analysis functions to accept spring translational and moment restraints. Also added is … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, spring supports, UDF, VBA
36 Comments