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
- XLDennis, the MSDN Library, and VBA rant
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel - 3, Continuous beam or frame
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Author Archives: dougaj4
Some thoughts on Magic …
… from Alana Hicks, Leonard Cohen, and Buffy St Marie. Alana Hicks is a friend of my daughter’s. This is her story: … which reminded me of a song I heard once on the radio over 40 years ago, and … Continue reading
Posted in Bach
Tagged Alana Hicks, Buffy Sainte-Marie, Leonard Cohen, Magic, Magic is Afoot, Smoke and Fire
2 Comments
The Conjugate Beam Method
The Conjugate Beam Method is a variation of the Moment-Area Method that allows beam slopes and deflections to be calculated purely from the calculation of shear forces and bending moments of the beam with (in some cases) modified support conditions. Both methods were … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton
Tagged Beam deflections, Conjugate Beam Method, Excel, Mohr
6 Comments
3D Frame analyses with spring releases – 2
The latest version of the 3DFrame spreadsheet (previously presented here) includes provision for spring end releases, allowing for either rotational or translational springs in any direction. These springs are now incorporated in the model by adjustment of the beam properties, … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 3D frame analysis, Excel, moment release, spring end release, Strand7, VBA
Leave a comment
On the probability of frog croaks.
A recent logical puzzle from TED discussed the probability of one of two frogs being female, if we know that at least one of them is male: This puzzle is discussed (arriving at different conclusions) here: and puzzles of this … Continue reading
Posted in Excel, Maths, Newton, VBA
Tagged croaking frog paradox, Probability puzzle, probability spreadsheet
Leave a comment
Chris Hadfield reviews 2016
Canadian Astronaut, Commander Chris Hadfield, reminds us of all the great many positives that happened in 2016. : It’s easy to forget that this year saw a great many positives