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
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Daily Download 4: Continuous Beam Analysis
Recent Comments
Tag Archives: UDF
Daily Download 5: Frame Analysis
Leading on from yesterday’s continuous beam functions, today’s download covers four frame analysis spreadsheets, with increasing levels of complexity. For those interested in the workings of the program I recommend working through each spreadsheet, but for practical applications the final … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged Excel, Frame Analysis, UDF, VBA
12 Comments
Daily Download 4: Continuous Beam Analysis
Today’s download files contain several alternative functions for analysing continuous beams. The most flexible is the ConBeamU spreadsheet, which in addition to the continuous beam function also contains functions for single span beams and cantilevers, and for fixed end moments and … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beams, Cubic splines, Excel, Macaulay's Method, UDF, VBA
15 Comments
Daily Download 3: ULS design of reinforced concrete sections
Today’s downloads provide a spreadsheet providing Ultimate Limit State (ULS) analysis of reinforced or prestressed concrete sections, and an iterative method for finding the depth of the Neutral Axis in a circular reinforced concrete section. The ULS analysis spreadsheet is described at: … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Brents method, Excel, Prestressed concrete, Reinforced Concrete, UDF, ULS Analysis, VBA
23 Comments
Daily Download 2: SLS design of reinforced concrete sections …
… and prestressed concrete sections. Today’s download installment covers spreadsheets for design of reinforced and prestressed concrete beams and columns at the Serviceability Limit State (SLS). The spreadsheets cover design of rectangular and circular sections, sections made up of any … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs
Tagged Composite section analysis, crack width, creep, Excel, flexural stiffness, Prestressed concrete, Reinforced Concrete, shrinkage, tension stiffening, UDF, VBA
15 Comments
Daily Download 1: Buckling of columns, rings and arches
One of the disadvantages of the blog format is that valuable resources tend to get lost somewhere in the archives. To help make them a bit more visible, for the next month or so I plan to post links to … Continue reading
Posted in Beam Bending, Excel, Newton, UDFs, VBA
Tagged buckling, Downloads, Excel, Rings and Arches, stepped columns, UDF, VBA
Leave a comment