7 March 2019 Off By The Engineering Community

Table of Contents



Program Description:

“Anchor Reinf.xls” is a MS-Excel spreadsheet workbook for the analysis of anchor bolt reinforcement to suppliment tension/shear concrete breakout per ACI 318-08, Appendix D (Section D5.2.9 / D6.2.9). The spreadsheet is designed to find the embedment strength of determined reinforcementwithin certain concrete parameters. Tables and figures have been given adjacent to the required data cells in an attempt to self contain the calculations within the worksheet. The spreadsheet is protected but with no password required.

Design References:

1. ACI 318-08
2. Strength Design of Anchorage to Concrete by Ronald A. Cook

This program is a workbook consisting of three (3) worksheets, described as follows:

Worksheet NameDescription
DocThis documentation sheet
Tension Reinf.Anchor Reinforcement per ACI 318-08 Section D.5.2.9
Shear Reinf.Anchor Reinforcement per ACI 318-08 Section D.6.2.9

Program Assumptions and Limitations:

  1. In TENSION REINF. spreadsheet, the edge distance is not in the program’s parameters.User must be mindful that the maximum distance between the anchor and anchor reinforcement must be less than or equal to 0.5 x hefAND (ED – bc).The latter is not restricted and must be checked by the user.
    2.In TENSION REINF. spreadsheet, if the edge distance is less than 1.5 x hef, containment steel such as stirrups must be used.
    3. The required strength is calculated from the applicable load combinations in Section 9.2.
    4.This program contains numerous “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc.(Note:presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell.Merely move the mouse pointer to the desired cell to view the contents of that particular “comment box”.)

Download link