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
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 4: Continuous Beam Analysis
- Downloads
- P-Y Curve function
- Frame Analysis with Excel – 7; Shear deflections and support displacements
Recent Comments
Tag Archives: VBA
ConbeamU Update Update
Following some comments from 4Step on the last ConbeamU update, and a thorough check of results against Strand7 results, I have posted a new version that fixes a number of issues with the previous one. The new version number is … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, Strand7, UDF, VBA
4 Comments
ConbeamU Update; defined support deflections
As promised in a recent post, I have updated the ConBeamU spreadsheet to allow defined deflections to be specified at any support. The new spreadsheet (including full open-source code), can be downloaded from ConBeamU.zip In addition to the support deflections the … Continue reading
Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged array entry, Array function entry, ConBeamU, continuous beam, defined support deflections, deflections, Excel, Macaulay's Method, UDF, VBA
12 Comments
Pi day of the Century
In North America, where today is 3-14-15, it is Pi day, and since there are not 31 days in April, the rest of us have to go along with that as well. Not only is it Pi day, it’s the … Continue reading
Continuous Beams with Specified Deflections
A few weeks ago there was some discussion in a previous continuous beam post about how to analyse a continuous beam with specified deflections at the supports. In this post I will look at three different ways of doing this … Continue reading
Posted in Excel
Tagged ConBeamU, continuous beam analysis, Excel, specified displacements, UDF, VBA
1 Comment
Getting concrete shrinkage right
At the end of last year, very quietly, the commentary to the Australian Concrete Structures Code (AS 3600) was published. The commentary provides a wide range of explanatory and background information to the requirements in the main code, including some … Continue reading →