### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Commenting a block of code in VBA
- Fitting high order polynomials
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Linest for non-linear curve fitting, examples, hints and warnings
- The angle between two vectors, Python version
- Drawing in Excel 7 - Creating drawings from coordinates
- Writing Arrays to the worksheet - VBA function

### Recent Comments

dougaj4 on RCInteract and RC Design Funct… Stephen on RCInteract and RC Design Funct… dougaj4 on Solving Quadratic, Cubic, Quar… dougaj4 on RCInteract and RC Design Funct… Stephen on RCInteract and RC Design Funct… Paridhi Agarwal on Solving Quadratic, Cubic, Quar… dougaj4 on Raw Impact in Cambodia –… dougaj4 on Composite Beam Spreadsheet… Composite Beam Sprea… on Stress increments in prestress… Composite Beam Sprea… on Composite Beam Spreadsheet… dougaj4 on Composite Beam Spreadsheet… Stephen on Composite Beam Spreadsheet… dougaj4 on Composite Beam Spreadsheet… Stephen on Composite Beam Spreadsheet… dougaj4 on Tables and VBA

# Category Archives: Beam Bending

## Composite Beam Spreadsheet Update 1.01

Following a comment here, I have modified the Composite Beam spreadsheet to correct the stage 1 stresses forces in the reinforcement as listed in Columns 6 and 7, when the tensile face is the top. The output has also been … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, Composite beam design, Excel, Prestressed concrete, Reinforced Concrete, UDF, VBA
Leave a comment

## Stepping through 3DFrame

Following a recent comment this post looks at the code for setting up the stiffness matrix for a 3D frame, and how to step through any selected part of the code. The general procedure for setting up a 3D stiffness matrix, … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged 3DFrame, Debugging UDFs, Debuging VBA, Excel, UDF, VBA
Leave a comment

## Setting up UDF Applications

Following a recent comment, this post looks at setting up a user defined function (UDF) on a blank worksheet, using the ConBeamU function as an example. To use a UDF, the VBA code for the function must either be included … Continue reading

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, resize array functions, UDF, VBA
1 Comment

## Stress increments in prestressed concrete beams

The two main Australian Standards covering prestressed concrete structures (AS 3600, Concrete Structures, and AS 5100 Part 5, Concrete Bridges) put a limit on the allowable increase in stress in reinforcement and prestressing strands and tendons, when the load increases from … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, Excel, Prestressed Concrete Design, Stress increment, UDF, VBA
2 Comments

## 3DFrame update

The update to the Glob_to_loc3 and Loc_to_glob3 functions (and associated functions) has now been transferred to the 3DFrame spreadsheet, which will now give correct results when beams are defined in the global negative Z direction. The revised spreadsheet (including full … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA
Tagged 3D frame analysis, Excel, moment release, spring end release, Strand7, VBA
12 Comments

## RCInteract and RC Design Functions 7.03

Since the previous post, I have updated the notes in the RC Design Functions spreadsheet to reflect the fact that with the recent update to the Bridge Design Code (AS 5100) the reinforced concrete strength design requirements for beam bending … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged ACI318, AS3600, AS5100, Combined bending and axial load, Eurocode2, Excel, Interaction Diagram, RC Design Functions, Reinforced Concrete, UDF, VBA
14 Comments

## 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
3 Comments