Appendix D - Anchor Bolt Anchorage
Description
Anchor Bolt Design to CSA A23.3-04 Annex D
Checks the factored resistance of a cast-in or post-installed anchor, or a group of anchors, in concrete under factored tension and shear to the Canadian standard CSA A23.3-04, Annex D. Each failure mode is set out on one sheet with the relevant tables and figures beside the input cells, and a summary shows OK or NG for each mode. Revision 1.1 corrected small errors and added options for concrete other than normal density and for seismic provisions.
Method
- Material resistance factors φs = 0.85 and φc = 0.65, with the resistance modification factor R chosen from steel ductility, supplementary reinforcement (Condition A or B), anchor type and installation category; a further 0.75 factor for seismic regions
- Tension: steel resistance (futa limited to 860 MPa and 1.9fy), concrete breakout with k = 10 (cast-in) or 7 (post-installed), or 3.9√f′c hef5/3 for 275 mm ≤ hef ≤ 625 mm, pullout and side-face blowout
- Shear: steel resistance, concrete breakout and pryout
- Tension–shear interaction with the 1.2 trilinear limit
Inputs
- Factored tension and shear (kN)
- Anchor type, number of anchors, effective area (mm²), futa and fy (MPa), bearing area
- Embedment depth, edge distances, spacing, eccentricities and f′c (mm, MPa)
- Cracked or uncracked concrete, concrete density type and seismic condition
Outputs
- Factored resistance for each failure mode against the factored load, the interaction check and an OK/NG summary
The workbook is supplied blank, without a worked example, so the results read zero or show errors until data are entered. SI units.
Please note
- The load input labels say “kips”, but the units shown and used are kN.
- Pullout resistance is calculated for one anchor and compared with the total group load (conservative), but it is left out of the interaction check.
- The sheet is protected without a password. No macros. Based on the 2004 edition of CSA A23.3.
Calculation reference: CSA A23.3-04, Annex D.
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.
Comments: 3
×
Thank you for your CSA A23.3 anchorage calculation. We checked its formulas against the standard (steel tension, concrete breakout, pullout, side-face blowout, shear breakout and pryout) and they are set out correctly.
While rewriting the description we found the same gap as in your ACI version. The interaction check in AI207/AI208 takes the governing tension resistance from steel, breakout and side-face blowout, but leaves out the pullout resistance in E104. Where pullout governs, the interaction ratio will be unconservative. Including E104 in the minimum would fix this.
There is also a units slip in the labels: L13 and L14 say "(kips)", but the loads are used in kN.
You may also want to consider storing a worked example in the sheet, so users can check their own results against it.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team