Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 4: Continuous Beam Analysis
- Numerical Integration With Tanh-Sinh Quadrature v 6.0
- Writing Arrays to the worksheet - VBA function
- Drawing in Excel 7 - Creating drawings from coordinates
Recent Comments
Category Archives: Newton
ConBeamU 4.13
The continuous beam analysis spreadsheet, ConBeamU, is now up to version 4.13 with some minor bug-fixes, and the addition of a non-linear option for the BeamAct functions. See ConBeamU for more details of the functions available in the spreadsheet. Download … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged BeamAct functions, continuous beams, Excel, non-linear analysis, Strand7, UDF, VBA
7 Comments
Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Least squares linear regression in Excel is easy. That’s what the Linest and Trend functions do. That is, they find the coefficients of a straight line (or higher dimension shape) so that the sum of the squares of the distances of … Continue reading
Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged AlgLib, Linest, Python, SciPy, UDF, VBA, Weighted least squares regression
9 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