Column Interaction Diagram Excel 🆕

If your column has 4 or 6 bars across the section (not just two faces), modify the calculation loop. For each rebar layer at depth y_i from compression face:

In Excel: = (C_c * (h/2 - a/2)) + (C_s_corrected * (h/2 - d_prime)) + (T * (d - h/2))

With powerful software available, why bother with Excel? column interaction diagram excel

A column interaction diagram is a vital graphical tool used in structural engineering to determine the safety of reinforced concrete columns . By plotting the relationship between axial load ( ) and bending moment (

Pn = C_c + sum(Fs) Mn = C_c * (h/2 – β1*c/2) + sum(Fs * (h/2 – d_i)) If your column has 4 or 6 bars

An interaction diagram represents the failure envelope of a reinforced concrete column. Any combination of axial load (P) and moment (M) that falls inside the curve is considered safe. The curve is typically generated by shifting the neutral axis of the column cross-section from pure compression to pure tension. Step 1: Set Up Your Input Data

Enter . Microsoft Excel remains the most underrated tool in structural engineering. By building a column interaction diagram in Excel , you achieve three critical goals: By plotting the relationship between axial load (

The engine behind the Excel spreadsheet is the . This method assumes that plane sections remain plane (linear strain distribution) and relies on equilibrium of forces.

Strain in the compression steel layer (at distance d' from compression face): ε_s' = ε_cu * (c - d') / c

Equations used: