Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- ULS Design Functions 2.13
- Continuous Beams With Spring Supports by Macaulay’s Method
- About Newton Excel Bach
- Buckling of columns with varying cross section
- Intersections, interpolations, and rotations
- Downloads
- Fitting high order polynomials
Recent Comments
Tag Archives: Excel Solver
ConBeamU and Strand7 check update
Results of the continuous beam spreadsheet were last checked against Strand7 results 10 years ago. I have now updated this check with the latest version (4.19), which can be downloaded from: ConBeamU.zip The download file now includes: The Strand7 check … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, Strand7 check, UDFs, Units, VBA, Working with units.
1 Comment
ConBeamU update
Following a comment at https://newtonexcelbach.com/2023/01/20/using-conbeamu/ I have updated the ConBeamU-Template file so that the function to select the input range works the same as in the main spreadsheet. For more details of how the spreadsheet works, see the link above, … Continue reading
Posted in Beam Bending, Excel, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, UDFs, Units, VBA
Leave a comment
Using ConbeamU
This post was prompted by a thread at Eng-Tips: https://www.eng-tips.com/threads/deflection-equations.501339/#post-8860838 The beam analysis functions in the ConbeamU spreadsheet allow for the use of any SI units, or any non-SI units found in the long list included with the spreadsheet. I … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, UDFs, Units, VBA, Working with units
12 Comments