"Anchor Bolt (318-08)" --- Embedment Strength per ACI 318-08 Appendix D

Program Description:

"Anchor Bolt(318-08).xls" is a MS-Excel spreadsheet workbook for the analysis of anchor bolt anchorage per
ACI 318-08, Appendix D. The spreadsheet is designed to find the embedment strength of a determined anchor
bolt or bolts within 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.

Program Environment: Microsoft Office Excel 2003

Creation Date: May 20th, 2008

Design References: 1. ACI 318-08

2. Strength Design of Anchorage to Concrete by Ronald A. Cook

This program is a workbook consisting of four (4) worksheets, described as follows:

Worksheet Name Description

Doc This documentation sheet
Anchorage Embedment Strength per ACI 318-08 Appendix D (ver.1.4)
Tension Reinf. Anchor Reinforcement per ACI 318-08 Section D.5.2.9 (ver.1.1)
Shear Reinf. Anchor Reinforcement per ACI 318-08 Section D.6.2.9 (ver.1.0)
REVISIONS
Anchorage: REVISION 1.5.2 - Revised cell E113 format to have two decimal places.
Tension Reinf.: REVISION 1.1 - (1/19/2015). Revised minimum embed length to reflect hook length.

Program Assumptions and Limitations:

1. This spreadsheet program is intended to analyze and design the embedment of various anchors.
Shear and tension strength is calculated per Appendix D of ACI 318.
2. This program assumes that the anchor strength is not governed by ductile yielding of the anchored steel
which would cause significant redistribution of anchor forces and that the attachment that distributes the
loads to the anchors is sufficiently stiff.
3. The required strength is calculated from the applicable load combinations in Section 9.2.
4. This spreadsheet, as well as the provisions of Appendix D, do not apply to the design of anchors in hinge
zones of concrete structures under seismic loads.
5. Post-installed anchors shall be verified for suitability for use in concrete demonstrated by the ACI 355.2
prequalification tests when installed for use in regions of moderate or high seismic risk, or for structrures
assigned to intermediate or high seismic performance or design catefories.
6. If a ACI 355.2 product evaluation report is used, this program does not account for alternative factors and needs
to be calculated by user.
7. 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 hef
AND (ED - bc). The latter is not restricted and must be checked by the user.
8. In TENSION REINF. spreadsheet, if the edge distance is less than 1.5 x hef, containment steel such as stirrups
must be used.
9. 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".)
Program Theory and Operation: The top left of the spreadsheet screen allows for input of required
information in lightly yellow highlighted boxes. Information required includes the following:

Anchorage Spreadsheet:
Input:
1. Loads:
a. Nua (Ultimate Factored Tensile Load) in kips
b. Vua (Ultimate Factored Shear Load) in kips
2. f Factor Conditions :
a. Steel Element
b. Reinforcement Surfaces
c. Anchor Type
d. Installment Category (Post-installed Anchor only)
e. Cracking from service loads
f. Anchor location
g. Concrete Type
3. Specific Tension and Shear Strength Variables: Each section contains the necessary input variables and
attempts to be self contained.

Output:
1. Steel strength of anchor in tension: (SEC D.5.1)

Nsa = nAse,Vfuta

2. Concrete Breakout strength of anchor in tension: (SEC D.5.2)

Ncb = Anc Yed,NYc,NYcp,NNb Single Anchor

Anco

Ncbg = Anc Yec,NYed,NYc,NYcp,NNb Group of Anchors

Anco

3. Pullout strength of anchor in tension: (SEC D.5.3)

Npn = Yc,PNp
Np = Abrg8f'c The pullout strength in tension of a single headed stud or bolt

Np = 0.9f'cehda The pullout strength in tension of a single hooked bolt

4. Concrete Side-Face Blowout strength of Headed anchor in tension: (SEC D.5.4)

Nsb = 160ca1Abrg1/2f'c1/2 Single Anchor

Nsbg = (1 + s/6ca1)Nsb Hooked Anchor

5. Steel strength of anchor in shear: (SEC D.6.1)

Vsa = nAse,Vfuta For cast-in headed stud anchors

Vsa = 0.6nAse,Vfuta For cast-in headed bolt & hooked bolt anchors

Vsa = 0.6nAse,Vfuta For post-installed anchors

6. Concrete Breakout strength of anchor in shear: (SEC D.6.2)

Vcb = Avc Yed,VYc,VYh,VVb Single Anchor

Avco

Vcb = Av Yec,V Yed,VYc,VYh,VVb Group of Anchors

Avco
7. Concrete Pryout strength of anchor in shear: (SEC D.6.3)

Vcp = kcpNcb Single Anchor

Vcpg = kcpNcbg Group of Anchors

8. Interaction of tensile and shear forces: (SEC D.7)

if Vua < 0.2fVn fNn > NUA
if Nua < 0.2fNn fVn > VUA
if Nua > 0.2fNn & Vua > 0.2fVn NUA + VUA < 1.2
ΦNn ΦVn
TENSION REINF. Spreadsheet:
Input:
1. Req'd Anchor Reinf. Strength, N: The required anchor reinforcement strength must be equal or larger than
the anchor bolt steel strength, ΦNsa, if anchor design includes earthquake forces for structures assigned
with Seismic Design Category is C,D,E, or F. (ACI Section D3.3)
2. Number of Vert. Reinf., Nr: Number of vertical steel reinforcement bars to resist vertical forces.
3. Estimated Embedment, hef: User's current embedment design of anchor bolts (w/o tension breakout strength
per ACI 318-08 Section D.5.2)
4. Anchor Reinforcement Size: Size of steel rebar from #3 to #14.
5. Reinforcing Yield Strength, fy: in units of ksi
6. Concrete Comp. Strength, f 'c: in units of ksi
7. Lightweight Concrete: If the concrete is lightweight, then "Yes".
8. Epoxy Coated Bars: If bars are epoxy coated, then "Yes".
9. Ratio: As(required)/As(provided): Per Section 12.2.5, the development length may be shortened if the ratio is less
than one. (N/A for Chapter 21 design)
10. Seismic Design per Chapter 21: If anchors are located in structure assigned to Seismic Design Category C, D,
E, or F. (Sect. D3.3), then "Yes".
11. Center-to-Center Bar Spacing, bs: The minimum center-to-center bar spacing between parallel bars in a layer
MUST BE >= 2*db and >= 1". For walls and slabs, maximum center-to-center bar spacing MUST BE <=
3*wall or slab thickness and <= 18".
12. Clear Cover to Face of Bar, bc: Minimum clear cover per Section 7.7.
13. Bolt-Reinf. Distance, d: The bolt-reinforcement distance should be the less than or equal to the maximum
(edge distance - bc) and 0.5hef.

Output:
1. Required Development Length, Ld:
Ld = ((fy*1000)/(f'c*1000)^(1/2)*yt*ye/(l*20))*db*As/As(prov) (Section 12.2.2)

Ld = Maximum of: 3.25*(fy*1000)*db/(65*(f'c*1000)^(1/2))*ye, 8*db, or 6" (Section 21.7.5)

2. Required Embedment Length:

hef,min = Ld+bc+0.7*d
hef,prov = per embedment entered (See input #3)

3. Required Anchor Reinforcement Size:

As,min = N/(0.75*fy) (Section D.5.2.9)
As,prov = per size and number entered (See input #2 & 4)
SHEAR REINF. Spreadsheet:
Input:
1. Req'd Anchor Reinf. Strength, V: The required anchor reinforcement strength must be equal or larger than the
anchor bolt steel strength,ΦVsa, if anchor design includes earthquake forces for structures assigned with
Seismic Design Category is C,D,E, or F. (ACI Section D3.3)
2. Anchor Reinforcement Size: Size of steel rebar from #3 to #14.
3. Reinforcing Yield Strength, fy: in units of ksi
4. Concrete Comp. Strength, f 'c: in units of ksi
5. Lightweight Concrete: Enter whether the concrete is lightweight or normal weight concrete.
6. Lightweight Concrete: If the concrete is lightweight, then "Yes".
7. Epoxy Coated Bars: If bars are epoxy coated, then "Yes".
development length, then "Yes" (Section 12.2.4(a))
8. Ratio: As(required)/As(provided): Per Section 12.2.5, the development length may be shortened if the ratio is less
than one. (N/A for Chapter 21 design)
9. Seismic Design per Chapter 21: If anchors are located in structure assigned to Seismic Design Category C, D,
E, or F. (Sect. D3.3), then "Yes".
10. Center-to-Center Bar Spacing, bs: The minimum center-to-center bar spacing between parallel bars in a layer
MUST BE >= 2*db and >= 1". For walls and slabs, maximum center-to-center bar spacing MUST BE <=
3*wall or slab thickness and <= 18".
11. Clear Cover to Face of Bar, bc: Minimum clear cover per Section 7.7.

Output:
1. Required Development Length, Ld:
Ld = ((fy*1000)/(f'c*1000)^(1/2)*yt*ye/(l*20))*db*As/As(prov) (Section 12.2.2)

Ld = Maximum of: 3.25*(fy*1000)*db/(65*(f'c*1000)^(1/2))*ye, 8*db, or 6" (Section 21.7.5)

2. Required Anchor Reinforcement Size:

As,min = V/(0.75*fy) (Section D.5.2.9)
As,prov = per size and number entered (See input #2 & 4)
ACI318-08 APPENDIX D - ANCHORING TO CONCRETE
Version 1.5.2

MADE BY DATE Job No.

CKD. BY DATE Sheet No.

FOR

XYZ Baseplate

CONCRETE ANCHOR DESIGN BASED ON ACI318-08 APPENDIX D

NOTES & SKETCHES

1 Basic Design Parameters: (SEC D.3-D.4)
Loads: (Per Applicable Loads Combinations in Sect. 9.2; load applications that are

predominantly high cycle fatigue or impact loads are not covered.)

Nua = 27.55775 k Ultimate Factored Tensile Load (kips)

Vua = 0.00220462 k Ultimate Factored Shear Load (kips)

f Factor Conditions:

Brittle Steel Element

Yes Potential Failure Surfaces crossed by supplementary reinforcement

proportioned to tie prism into the structural member?
Headed Bolt Anchor Type NOTE: Hooks bolts are typically not a good design practice.

Category 1 N/A - Only applicable to Post-installed anchors

Yes Anchor located in a region of concrete member where analysis

indicates no cracking at service load levels? (YES = No Cracking Anticipated)
No Anchors are located in structure assigned to Seismic Design Category C, D, E, or F. (Sect. D3.3)

Normalweight Concrete Type

2 Steel strength of anchor in tension: (SEC D.5.1)

Nsa = nAsefuta Assumes no eccentricity in bolt group loading (D-3)

n= 3 Number of Anchors in a Group

Ase, N = 0.31164599124 in 2
Effective Cross Sectional Area of Anchor

futa = 58.0 ksi Specified Tensile strength of anchor steel

fy = 36.3 ksi Specified Yield strength of anchor steel

Nsa = 54.24 k f = 0.65

fNs = 35.26 k > Nu = 27.56 k OK

XYZ Baseplate Page No. 5 of 12

 3 Concrete Breakout strength of anchor in tension: (SEC D.5.2)
Ncb = Anc Yed,NYc,NYcp,NNb Single Anchor (D-4)
Anco

Ncbg = Anc Yec,NYed,NYc,NYcp,NNb Group of Anchors (D-5)

Anco

Anc = 508.884662754 in2 Projected concrete failure area of anchor or group of anchors. See RD.6.2.1(b)

hef = 7.87416 in Effective anchor embedment depth

ca,min = 9.448992 in The smallest edge distance

ca,max = 0 in The largest edge distance

f'c= 4351.14 psi

er imagens ao lado) e'N = 0 in Eccentricity of Normal Force on a group of anchor. See Figure RD.5.2.4
Edges = 0 Number of Edges surrounding anchor or group of anchors. See Figure RD.5.2.4 Commentary

cac = 12 in Critical edge distance required to develop the basic concrete breakout strength of a post
installed anchor in uncracked concrete w/o supplementary reinforcement to control splitting.

Anco = 9h ef
2
Projected area of the failure surface of a single anchor remote from edges for c a,min
of 1.5hef or greater

Yec,N = 1 <1 Modification factor for eccentrically loaded anchor groups

2e'N
( 1+ )
3hef
Yed,N = 1 if Cmin > 1.5hef Modification factor for edge effects

= 0.7 + 0.3 cmin if Cmin < 1.5hef Modification factor for edge effects
1.5 hef
Yc,N = 1.25 for Cast-in anchors in uncracked section

Ycp,N = 1.00 for Post-installed anchors in uncracked section w/o supplemental reinforcement

Nb = kclf'c1/2hef3/2 Basic concrete breakout strength

k = 24 for cast-in anchor

Nb = 16lf'c1/2hef5/3 Alternative concrete breakout strength for 11in < hef < 25in.

Anco = 403.2 in 2 f = 0.75

Yec,N = 1.00
Yed,N = 0.98
Yc,N = 1.25
Ycp,N = 1.00
Nb = 27.41 k
Ncb g = 42.49 k
fNcb = 31.87 k > Nu = 27.56 k OK

XYZ Baseplate Page No. 6 of 12

 4 Pullout strength of anchor in tension: (SEC D.5.3)

Npn = Yc,PNp NOT ONE (D-14)

Bearing area of single headed stud or anchor bolt.

Abrg = 1.08339587001 in2 See Table 1.
eh= -0.3 in Distance from the inner surface of the shaft to the outer tip of the bolt. 3da<eh<4.5da
da= 0.6 in Outside diameter of anchor or shaft diameter

Np = Abrg8f'c The pullout strength in tension of a single headed stud or bolt (D-15)

Np = 0.9f'cehda The pullout strength in tension of a single hooked bolt (D-16)

NOTE: Hooks bolts not preferred due to the oil used in bending hook which neglects friction.

Yc,P = 1.40 f = 0.75

Np = 52.80 Assume that the force is shared evenly w/ other bolts, if multiple anchors.

fNp g = 39.60 k > 9.19 k OK

5 Concrete Side-Face Blowout strength of Headed anchor in tension:

Single Anchor: (SEC D.5.4)

Nsb = 160ca1Abrg1/2lf'c1/2 (D-17)

Ca1 = 9.45 in Distance from center of anchor shaft to the edge of concrete
Distance from center of anchor shaft to the edge of concrete in direction
Ca2 = 19.69 in orthogonal to C = Ca1 See Commentary Figure 1.

Factor = 0.771 Ca2 < 3*Ca1 f = 0.75

Nsb = 80.01 k
fNsb = 60.01 k > Nu = 27.56 k N/A

Multiple Anchors:
Nsbg = (1 + s/6ca1)Nsb (D-18)

s= 4 in Spacing of the outer anchors along the edge in the group.

Nsbg = 80.01 k f = 0.75

fNsbg = 60.01 k > Nu = 27.56 k OK

XYZ Baseplate Page No. 7 of 12

 6 Steel strength of anchor in shear: (SEC D.6.1)

Vsa = nAse,Vfuta For cast-in headed stud anchors (D-19)

Vsa = 0.6nAse,Vfuta For cast-in headed bolt & hooked bolt anchors (D-20)
Vsa = 0.6nAse,Vfuta For post-installed anchors (D-20)

Grout? NO Is anchor in builtup grout pad?

Effective cross-sectional area of expansion or undercut anchor sleeve,
Ase,V= 0.31 in^2 if sleeve is within shear plane.

fut= 58.0152 ksi Specified tensile strength of anchor sleeve.

Vsa = 32.54 k f= 0.6

fVsa = 19.53 k > Vu = 0.00 k OK

7 Concrete Breakout strength of anchor in shear: (SEC D.6.2)

Vcb = Avc Yed,VYc,VYh,VVb Single Anchor (D-21)

Avco

Vcbg = Avc Yec,VYed,VYc,VYh,VVb Group of Anchors (D-22)

Avco

Avc = 498 in2 Projected concrete failure area on an anchor or group of anchors. See Figure 4 Commentary

Ca1* = 11.5 in Distance from center of anchor shaft to the edge of concrete in one direction.See Commentary

e'v = 0 in Eccentricity of shear force on a group of anchors. See Figure 5 Commentary

le = 12 in Load bearing length of anchor for shear. See Table 2 Commentary.

da = 1.5 in Outside diameter of anchor or shaft diameter of headed stud, headed bolt, or hooked bolt.

ha = 12 in Thickness of member in which an anchor is anchored, parallel to anchor axis.

Enter Case: Case 1: No supplementary reinforcement or edge reinforcement smaller than a No. 4 bar.
Case 2
Case 2: Supplementary reinforcement of a No. 4 bar or greater between the anchor and the edge.

Case 3: Supplementary reinforcement of a No. 4 bar or greater betwwen the anchor and the edge, and
with the supplementary reinforcement enclosed withing stirrups spaced at not more than 4 in.

Vb = 7(le/da)0.2da1/2λf'c1/2Ca11.5 See commentary

XYZ Baseplate Page No. 8 of 12

 7 Continued

Yec,V = 1 <1 Modification factor for eccentrically loaded anchor groups

2e'v
( 1+ )
3c1

Yed,V = 1.0 if Ca2 > 1.5Ca1 Modification factor for edge effects

= 0.7 + 0.3 ca2 if Ca2 < 1.5Ca1 Modification factor for edge effects
1.5 ca1

Yc,V = 1.4 Anchor in uncracked section

Yec,V = 1.00 f = 0.75

Yed,V = 1.00
Yc,V = 1.40
Yh,V = 1.20 Yh,V = (1.5ca1 / ha) ^ 0.5 (where ha < 1.5ca1)

Avco = 288.00 in2

Vb = 19.40 k
Vcb g = 56.29 k
fVcb g = 42.22 k > Vu = 0.00 k OK

8 Concrete Pryout strength of anchor in shear: (SEC D.6.3)

Vcp = kcpNcb Single Anchor (D-30)

Vcpg = kcpNcbg Group of Anchors (D-31)

Kcp = 1 for hef < 2.5

Kcp = 2 for hef > 2.5

Ncb g = 42.49 k f = 0.75

Vcp g = 84.97 k
fVcp g = 63.73 k > Vua = 0.00 k OK

9 Interaction of tensile and shear forces: (SEC D.7)

if Vua < 0.2fVn fNn > NUA OK

if Nua < 0.2fNn fVn > VUA N/A

if Nua > 0.2fNn & Vua > 0.2fVn NUA VUA

+ < 1.2
ΦNn ΦVn N/A

XYZ Baseplate Page No. 9 of 12

 TENSION ANCHOR REINFORCEMENT
Per Building Code Requirements for Structural Concrete (ACI 318-08)
Design of Anchor Reinforcement in place of Concrete Breakout Strength
Job Name: Subject: xyz baseplate Date: 8/16/2022 20:04
Job Number: Originator: Checker:

Input Data:
Req'd Anchor Reinf. Strength, N = 35 kips
Number of Vert. Reinf., Nr = 4
Estimated Embedment, hef = 14 in.
Anchor Reinforcement Size = 4 (dia. = 0,5'')
Reinforcing Yield Strength, fy = 60 ksi
Concrete Comp. Strength, f 'c = 4.0 ksi
Lightweight Concrete? No
Epoxy Coated Bars? No bs
Ratio: As(required)/As(provided) = 0.74
Seismic Design per Chapter 21? No d
Center-to-Center Bar Spacing, bs = 12.00 in.
Clear Cover to Face of Bar, bc = 2.00 in.
Bolt-Reinf. Distance, d = 6.00 in.

DESIGN SATISFACTORY
Results:

bc
Development Length (Section 12.2 or 21.7.5):
Ld = 17.6 in.
Ldh = 7.0 in.

Required Anchor Embedment:

hef,min = 13.22 in. hef,min = Ldh+bc+0.7*d
hef,prov = 14.0 in.
d

Anchor Reinforcement Strength(Section D.5.2.9):

As,min = 0.78 in2 As,min = N/(0.75*fy)
As,prov = 0.79 in2

Note: In situations where the edge distance, from centerline of bolts to edge of concrete, is less than 1.5 times
the embedment depth, it is recommended that containment steel, such as stirrups, be used.

Comments:

file:///conversion/tmp/activity_task_scratch/605746032.xlsx 10 of 12
 SHEAR ANCHOR REINFORCEMENT
Per Building Code Requirements for Structural Concrete (ACI 318-08)
Design of Hairpin Anchor Reinforcement in place of Concrete Breakout Strength
Job Name: Subject: Date: 8/16/2022 20:04
Job Number: Originator: Checker:

Input Data:
Req'd Anchor Reinf. Strength, V = 9.5 kips
Anchor Reinforcement Size = 3 (dia. = 0,375'')

Reinforcing Yield Strength, fy = 60 ksi

Concrete Comp. Strength, f 'c = 4.0 ksi
Lightweight Concrete? No
Epoxy Coated Bars? No
Top Bar? Yes
Ratio: As(required)/As(provided) = 0.80
Seismic Design per Chapter 21? No
Center-to-Center Bar Spacing, bs = 12.00 in.
Clear Cover to Face of Bar, bc = 2.00 in.

DESIGN SATISFACTORY

Results:

Development Length (Section 12.2 or 21.7.5):

Ld = 18.50 in.

Anchor Reinforcement Strength(Section D.6.2.9):

As,min = 0.21 in2 As,min = V/(0.75*fy)
As,prov = 0.22 in2

Comments:

file:///conversion/tmp/activity_task_scratch/605746032.xlsx 11 of 12
file:///conversion/tmp/activity_task_scratch/605746032.xlsx 12 of 12