Column Confinement Reinforcement to NSR-10 (Colombia)
Description
Column Confinement Reinforcement to NSR-10 (Colombia)
Transverse (confinement) reinforcement for rectangular and circular reinforced concrete columns to the Colombian code NSR-10, Title C, for moderate (DMO) and special (DES) energy dissipation. The sheet finds the length of the confined zone at each end of the column, the code maximum hoop spacing, the spacing needed to provide the required hoop area in each direction, and the minimum volumetric ratio and pitch of spirals. Bar sizes and options are chosen from drop-down lists. The rules mirror ACI 318-08 Chapter 21. The worksheet is in Spanish.
Inputs
- Concrete strength f'c and hoop yield strength fyh (MPa)
- Section shape (rectangular or circular), dimensions b and h or diameter D, clear height and cover (m)
- Main longitudinal bar and hoop bar sizes (No. 2 to No. 18)
- Hoop type (rectangular or spiral), number of hoop legs in each direction
- Energy dissipation class: DMO or DES
Outputs
- Confined length Lo: the greatest of L/6, the largest section dimension and 500 mm
- Maximum spacing in the confined zone, from the section size, bar diameters, 150 mm and (DES) so
- Spacing for the required hoop area Ash in each direction
- Minimum volumetric ratio ρs and the corresponding spiral pitch
- The final required spacing or pitch
The example is a 0.40 × 0.60 m DMO column, f'c 21 MPa, with No. 6 bars and No. 3 hoops (4 × 3 legs): confined length 0.60 m, hoops at 107 mm. SI units.
Checked and corrected
Every result was recomputed independently. ExcelCalcs made four corrections to the uploaded file (17 November 2026, version 1.1):
- The final required spacing now includes the maximum spacing the sheet itself works out (sconf). Before, it was the least of the hoop-area spacings only, so it could exceed the code limit. The example is unchanged at 107 mm (the hoop area governs), but with No. 4 hoops the answer falls from 194 mm to 133 mm (DMO), and from 130 mm to 100 mm for DES.
- The spiral pitch is now also limited to sconf and to a clear pitch of 75 mm. For a 0.50 m circular column with a No. 4 spiral the pitch falls from 132 mm to 88 mm.
- A warning beside the final result now appears when the spiral's clear pitch would be under 25 mm, so a larger spiral bar is needed.
- Two labels are corrected: the first heading said “slab” instead of “column”, and the cover description now says it is the clear cover to the outside of the hoops, as the formulas use it.
Please note
- bc in the hoop-area equations is taken as the full section dimension rather than the core dimension. This is conservative (by about 15% in the example).
- For a circular column with rectangular hoops bc is taken as 0.8 D; no source is given.
- For DES the limit hx ≤ 350 mm is not checked, and the 16 db,hoop and 150 mm limits are also applied (conservative).
- The code and clause numbers follow NSR-10 Title C; check them against the current edition before use.
- The workbook keeps some unused names linked to another workbook; if Excel asks, choose not to update links.
Calculation Preview
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
**The correction needed**
- The final spacing in B72 should be the minimum of the area-based spacings and the maximum spacing in B54, and the pitch limits should also apply to the spiral case.
**Suggestions that would make it even better**
- State the purpose and the code (NSR-10, Title C) at the top, and correct the "losa" heading.
- Show units beside every input and result (m, mm, MPa).
- Add a sketch of the section showing b, h, cover and the tie legs counted in each direction.
- Say how you know it is right: a worked example checked by hand or against a published one.
- Say whether bc is the full or the core dimension, and delete the defined names that link to another workbook.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
**What we corrected**
- B72, the final required spacing, now includes the maximum spacing in B54: MIN(B54, B67:B70). Your example stays at 0.107 m because the hoop area governs, but with No. 4 hoops the result is now 0.133 m instead of 0.194 m.
- For spirals, B72 is now also limited to B54 and to a clear pitch of 75 mm. For a 0.50 m circular column with a No. 4 spiral the pitch becomes 88 mm instead of 132 mm.
- C72 now warns ("Paso libre t link to another workbook.
Thank you for a clear and useful detailing sheet; deriving the spiral pitch equation on the page made it easy to check. I have awarded you a 3-month XLC Pro subscription by way of thanks. Our guidance for authors is in The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide).