Our Excel sheet will rely on standard strain compatibility. We assume:
f_s' = MIN(fy, Es * ε_s') (but also cannot exceed fy). column interaction diagram excel
📍 To make your formulas easier to read, name your input cells (e.g., name cell B1 "fc" instead of referencing If you'd like to take this further, I can help you with: The VBA code to automate the "c" value iterations. Our Excel sheet will rely on standard strain compatibility
| Parameter | Symbol | Example Value | Excel Cell | | :--- | :--- | :--- | :--- | | Column width | b | 12 in | B2 | | Column depth | h | 20 in | B3 | | Concrete strength | f'c | 4 ksi | B4 | | Steel yield strength | fy | 60 ksi | B5 | | Rebar diameter | db | #8 (1.0 in) | B6 | | Number of bars (each face) | n | 3 per face | B7 | | Cover to rebar ctr | d_c | 2.5 in | B8 | | Elastic modulus steel | Es | 29000 ksi | B9 | | Strength reduction factor (phi) | φ | 0.65/0.9 | B10 | | Parameter | Symbol | Example Value |
While I cannot attach a file directly, here is the structure of your final Excel workbook:
Here’s a structured content outline and explanation for creating a in Excel, which you can use for a tutorial, blog post, or engineering report.
Then compute: