Anchor Bolt Design Spreadsheet PIP STE05121

Revision 0a, April 2003 January 2003

Company ENI PAKISTAN

Project K-19 WELLHEAD Project # EC0769
Subject ANCHOR BOLTCHECK
Name M.M Date 4/6/2018 Sheet Number 1
Checked by A.J Check Date 4/6/2018 Total Sheets 1

LOADING CONDITIONS DESIGN CONSIDERATIONS

Note: Calculations are per ACI 318-02 Appendix D. Ductility required? Tension Shear
Nu and Vu were factored using factors from ACI 318-02? Intermediate or high seismic risk?
Factored tensile load (kips) = Nu = 4.6 Specified concrete strength (psi) = f'c = 3000
Factored shear load (kips) = Vu = 9.44 Cracking
Is there a built-up grout pad? modification
factor,Y7
ANCHOR DATA, EMBEDMENT, AND THICKNESS OF MEMBER
Anchor material type = Adequate supplementary reinf. provided to resist tension loads in anchors?
Nominal anchor diameter (in.) = Adequate reinforcement provided to resist shear loads in anchors?
Note: hef used in calcs is limited to (Cmax /1.5) = 4 in., see ACI D5.2.3 10.00 = hef ECCENTRICITY
Thickness of member in which anchor is anchored, (in.) = h 12.00 = h Eccentricity of tensile force on group of tensile anchors (in.)
Number of anchors in tension = n(tension) = 4 eN' = 0 (0=single anchor)
Number of anchors in shear = n(shear) = 4 Eccentricity of shear force on group of anchors (in.)
CONCRETE FAILURE AREAS (Note ev' must be less than s perpendicular to shear) eV'= 0
Do you want to manually input the value of An? no EDGE DISTANCES AND SPACING
An = 200 TENSION SHEAR
Note: Units for An and Av are sq. in.
An= 324 Edge Distance, in. Spacing, in. Edge Distance, in. Spacing, in.
Do you want to manually input the value of Av? no c1 c1 = 6.0 c3 = 6.0 s1 = 6.0 c1 = 6.0 s2 = 6.0
Av = 2000 c2 = 6.0 c4 = 6.0 s2 = 6.0 c2 = 6.0
NU Av= 162 c4 = 6.0
c1 = minimum edge distance c1 = edge distance in direction of Vn (perp.)
1.5hef 1.5hef 35o
1.5c1

c2 = least edge distance perpendicular to c1 c2 = least edge distance perpendicular to c 1

VU (perpendicular)
c1 s1 c3 c1
VU

h or 1.5c1
hef
VU (parallel)

c2 s2 c4
1.5c1

35 o
c2 s2 c4

VU c1

Breakout cone for tension Breakout cone for shear c4 s2 c2

SUMMARY OF RESULTS
DUCTILITY INTERACTION OF TENSILE AND SHEAR FORCES RESULTS
CONNECTION IS DUCTILE FOR TENSION. fNn = 24.7 kips >= Nu = 4.6 kips Using supplemental reinf to carry Tension
CONNECTION IS DUCTILE FOR SHEAR. fVn = 10.3 kips >= Vu = 9.4 kips Using supplemental reinf to carry Shear
ADD Supplemental Reinf or REVISE Anchor Nu/(fNn) + Vu/(fVn) = 0.19 + 0.92 = 1.10 <=1.2 ANCHOR OK !
10.28

Process Industry Practices

Anchor Bolt Design Spreadsheet PIP STE05121
Revision 0a, April 2003 Output January 2003

Company ENI PAKISTAN Sheet 1 of 1

Project K-19 WELLHEAD Project # EC0769
Subject ANCHOR BOLTCHECK
Name M.M Date 4/6/2018
Checked by A.J Check Date 4/6/2018

BOLT PARAMETERS
Grade A307-Type C, Fu = 58 fy 36 ksi hef 10.00 in.
Size 1/2 in. fut 58 ksi n(tension) 4
do 0.500 in. Ase 0.142 sq. in. n(shear) 4
Ab 0.467 sq. in.

LOAD CONDITIONS REINFORCEMENT

LOAD FACTORS Section 9.2 ADEQUATE SUPPL REINF PROVIDED TO RESIST TENSION
TENSILE LOAD, Nu 4.6 kips ADEQUATE REINF PROVIDED TO RESIST SHEAR
SHEAR LOAD, Vu 9.4 kips

DESIGN CONSIDERATIONS
DUCTILITY REQD IN TENSION CONCRETE STRENGTH, f'c 3000 psi
DUCTILITY REQD FOR SHEAR CRACKING MOD FACTOR, Y 7 1.4
LOW SEISMIC RISK GROUT PAD
ECCENTRICITIES eN' = 0.00 in. eV' = 0.00 in.

DESIGN FOR TENSION DESIGN FOR SHEAR

STEEL STRENGTH Ns 32.9 kips STEEL STRENGTH Vs 15.8 kips

CONCRETE BREAKOUT
CONCRETE BREAKOUT STRENGTH OF ANCHOR,
STRENGTH OF Perpendicular to edge
ANCHOR(S) Ncb or Ncbg 29.6 kips Vcb or Vcbg 7.6 kips

PULLOUT STRENGTH CONCRETE PRYOUT

OF ANCHOR(S) nNpn 62.7 kips STRENGTH OF ANCHOR Vcp 59.2 kips

CONCRETE SIDE-FACE
BLOWOUT STRENGTH Nsb or Nsbg
OF HEADED ANCHOR(S) (governing) NA

EDGE DISTANCES, SPACINGS, SUMMARY OF RESULTS

FAILURE AREAS TENSION
Steel Capacity 24.7 kips
TENSION SHEAR Concrete Capacity 22.2 kips
c1 6.00 in. 6.00 in. CONNECTION IS DUCTILE FOR TENSION.
c2 6.00 in. 6.00 in. SHEAR
c3 6.00 in. Steel Capacity 10.3 kips
c4 6.00 in. 6.00 in. Concrete Capacity 5.7 kips
s1 6.00 in. CONNECTION IS DUCTILE FOR SHEAR.
s2 6.00 in. 6.00 in. INTERACTION OF TENSILE AND SHEAR FORCES
An or Av 324.0 sq. in. 162.0 sq. in. 24.7 kips = fNn* >= Nu = 4.6 kips
Calculated Calculated 10.3 kips = fVn* >= Vu = 9.4 kips
Nu/(fNn*) + Vu/(fVn*) = 0.19 + 0.92 <= 1.2
OK
*Multiplied by 0.75 if intermediate or high seismic area

Page

Process Industry Practices

Anchor Bolt Design Spreadsheet PIP STE05121
Revision 0a, April 2003 January 2003

c1 s1 c3

Direction of load

s2 c4
c2
Notes:

1. Determinations concerning fitness for purpose and particular matters or application of the Practice
to particular project or engineering situations should not be made solely on information contained in
these materials. All Practices or guidelines are intended to be consistent with applicable laws and
regulations including OSHA requirements. To the extent these Practices or guidelines should
conflict with OSHA or other applicable laws or regulations, such laws or regulations must be
followed. Consult an appropriate professional before applying or acting on any material contained
in or suggested by the Practice.

2. This spreadsheet has been developed utilizing ACI 318-02 Appendix D and PIP STE05121. It will
give shear and tensile capacities of an anchor or anchor group and the concrete around the anchor
or anchor group. It will also let the user know if the anchor configuration is ductile (refer to PIP
STE05121, section 6). The user needs to use this spreadsheet in combination with ACI 318-02
Appendix D and PIP STE05121. This spreadsheet merely saves the user time in laborious
calculations but is no substitute for the engineer’s expertise.

3. The spreadsheet works for any number of bolts in tension and/or shear.

4. For 1, 2, or 4 bolts in a rectangular pattern, this spreadsheet will calculate A n and Av. For other
numbers of bolts and bolt patterns, the user needs to calculate and input A n and Av.

5. For tensile loads, if the user has 1, 2, or 4 bolts in a rectangular pattern, the user should provide c 1
through c4 and s1 and s2. For 1 bolt, s1 and s2 should be input as 0 (zero). For 2 bolts, either s1 or
s2 should be input as 0. Note: Only the bolts in tension shall be considered. If there are bolts in
shear only, ignore them.

6. For shear loads c1, c2, c4 and s2 are required inputs. c1 could be different for shear than for tension.
Note: Only the bolts in shear shall be considered. If there are bolts in tension only ignore them. If
there is only one bolt (or 2 bolts in line of load), s2 = 0.

7. If the user is using rebar to resist either tensile or shear loads applied to the anchor, this needs to
be indicated in the spreadsheet. The rebar needs to develop the required strength in accordance
with ACI 318. See Section 7 of PIP STE05121.

8. If reinforcement is provided to resist tension, then the concrete breakout strength of the anchor in
tension will not be used in checking the anchor size. Furthermore, if a ductile material is specified
for the anchor, the anchor is automatically ductile in tension.

9. If reinforcement is provided to resist shear, then the concrete breakout strength of the anchor in
shear and the concrete pryout strength of the anchor in shear will not be used in checking the
anchor size. Furthermore, if a ductile material is specified for the anchor, the anchor is
automatically ductile in shear.

Process Industry Practices

 PIP STE05121
Anchor Bolt Design Spreadsheet
Revision 0a, April 2003
Calculations January 2003

Selected Bolt: 1/2 in. A307-Type C, Fu = 58 No. of Bolts

do = 0.500 in. Ase = 0.142 sq. in. fy = 36 ksi nt(tension) = 4
hef = 10.0 in. Abrg = 0.467 sq. in. fut = 58 ksi nv(shear) = 4

Note: Figures in parenthesis and in red refer to equations or paragraphs in ACI 318-02, Appendix D.

Steel Strength in Tension: Ns = nAsefut (fut < 1.9fy and fut < 125 ksi) = 32.9 kips (D-3)

1. Concrete breakout strength of anchor in tension:

AN(calc) = 324.0 sq. in. Use AN = 324.0 sq. in. ANo = 9hef2 = 144.0 sq. in. (D-6)
hef(max) = 4.0 in. Use hef = 4.0 in. (D.5.2.3)
Y1 = [1/(1 + 2eN'/3hef) <= 1] = 1.00 (D-9)
cmin = 6.0 in. Y2 = 1.000 (D-10 or D-11)
Y3 = 1.25 (D.5.2.6) Nb = 10.5 kips
(D-7 or D-8)
Ncb or Ncbg = (AN/ANo)Y1Y2Y3Nb = 29.6 kips (D-4 or D-5)
PROVIDE REBAR TO CARRY TENSION, CHECK REBAR EMBEDMENT ON EITHER SIDE OF CRACK

2. Pullout strength of anchor in tension:

Y4 = 1.4 (D.5.3.6) Np = Abrg8f'c = 11.2 kips (D-13)
For n bolts, nNpn = nY4Np = 62.7 kips (D-12)

3. Concrete side-face blowout strength of headed anchor in tension:

c = 6.0 in. c2 = 6.0 in. c2/c = 1.00 <=3
Side-face blowout strength does not apply.
Nsb = 160c(Abrg)0.5(f'c)0.5 = NA (D-15) Nsb (modified) = NA (D.5.4.1)
Side blowout (group effects) does not apply.
Nsbg = (1+so/6c)Nsb = NA (D-16)
Nsb or Nsbg (governing) = NA

Steel Strength of Fastener in Shear:

Vs = nAse(0.6 fut)*(0.8 if there is a grout pad) = 15.8 kips (D-18 & D.6.1.3)
1. Concrete breakout strength of anchor in shear:
Av(calc) = 162.0 sq. in. Use Av = 162.0 sq. in. Avo = 4.5c12 = 162.0 sq. in. (D-22)
AV (max) = nAVo = 648.0 sq. in. (D.6.2.1) Use min Av = 162.0 sq. in.

Process Industry Practices Sheet 4 of 11

 PIP STE05121
Anchor Bolt Design Spreadsheet
Revision 0a, April 2003
Calculations January 2003

l = min (8do and hef) = 4.0 in. (D.0 - Notation for l)

c1 (max) = 8.0 in. (D.6.2.4) Use c1 = 6.0 in.
Vb = 7(l/do)0.2(do)0.5(f'c)0.5(c1)1.5 = 6.0 kips (D-23)
Y5 = 1/(1 + 2eV'/3c1) <= 1 = 1 (D-25)
Y6 = [0.7+0.3(c2/(1.5c1) if c2 < 1.5c1, 1.0 if c2 >= 1.5c1] = 0.900 (D-26 [Errata] or D-27)
Y7 = 1.4 (D.6.2.7)
Vcb or Vcbg = (AV/AVo)Y5Y6Y7Vb = 7.6 kips (D-20 or D-21) Shear perpendicular to edge <------- Applies
16.9 kips (D-20 or D-21) Shear parallel to edge <-------- NA
PROVIDE REBAR TO CARRY SHEAR, CHECK REBAR EMBEDMENT ON EITHER SIDE OF CRACK
2. Concrete pryout strength of anchor in shear:
kcp = 2 (D.6.3.1) Ncb = 29.6 kips (D-4)
Vcp = kcpNcb = 59.2 kips (D-28)
PROVIDE REBAR TO CARRY SHEAR, CHECK REBAR EMBEDMENT ON EITHER SIDE OF CRACK
Summary of Results:
Tension: f for steel = 0.75 f for concrete = 0.75 (D.4.4)
Steel capacity = fNn[*0.75 if inter. or high seismic risk] = 24.7 kips (D.3.3)
Concrete capacity = fNn[*0.75 if inter. or high seismic risk] = 22.2 kips (D.3.3) Ductility?
Governing mode of concrete failure: Concrete breakout strength of anchor in tension Tension 1
CONNECTION IS DUCTILE FOR TENSION.

Shear: f for steel = 0.65 f for concrete = 0.75 (D.4.4)

Steel capacity = fVn[*0.75 if inter. or high seismic risk] = 10.3 kips (D.3.3)
Conc. capacity = fVn[*0.75 if inter. or high seismic risk] = 5.7 kips (D.3.3) Shear 1
Governing mode of concrete failure: Concrete breakout strength of anchor in shear
CONNECTION IS DUCTILE FOR SHEAR.

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

fNn = 24.7 kips fVn = 10.3 kips
0.2fNn = 4.9 kips 0.2fVn = 2.1 kips
Nu = 4.6 kips Vu = 9.4 kips
Nu/(fNn) = 0.19 Vu/(fVn) = 0.92
Applicable equation = (D-2) 10.28 OK

Process Industry Practices Sheet 5 of 11

 PIP STE05121
Anchor Bolt Design Spreadsheet
Revision 0a, April 2003
Calculations January 2003

Supplementary Calculations

Calculation for An and cmax

input If < 1.5 hef, 1, else 0 Find cmax
Edge distance (c1) = 6 1 6
Edge distance (c2) = 6 1 6
Edge distance (c3) = 6 1 6
Edge distance (c4) = 6 1 6
Total sides < 1.5 hef = 4
cmax = 6
Anchor spacing (s1) = 6
Anchor spacing (s2) = 6

Calculate Av and c1(max)

input If < 1.5 hef, 1, else 0
Edge distance (c1) = 6 1
Edge distance (c2) = 6 1
Edge distance (c4) = 6 1
Total sides < 1.5 hef = 3
Anchor spacing (s2) = 6

Process Industry Practices Sheet 6 of 11

 PIP STE05121
Anchor Bolt Design Spreadsheet
Revision 0a, April 2003
Tables January 2003

Minimum Maximum Fy Fut

Anchor Material Type Ductile?
Size Size ksi ksi
1 A307-Type A 4 0 60 Yes
2 A307-Type C 4 36 58 Yes
3 A36 8 36 58 Yes
4 F1554 Gr 36 2 36 58 Yes
5 F1554 Gr 55 2 55 75 Yes
6 F1554 Gr 105 2 105 125 Yes
7 A 193 Gr B7 2.5 105 125 Yes
8 A 193 Gr B7 2.51 4 95 115 Yes
9 A 193 Gr B7 4.01 7 75 100 Yes
10 A354 Gr BC 4 109 125 Yes
11 A354 Gr BD 4 130 150 Yes
12 A449 1 92 120 Yes
13 A449 1.01 1.5 81 105 Yes
14 A449 1.51 3 58 90 Yes
1 A307, Type A, Fu = 60 1
2 A307-Type C, Fu = 58 2
3 A36, Fu = 58 3 Row = 2 Adequate Reinforcement Provided to Resist Tension Loads in Anchors?
4 F1554 Gr 36 4 User's answer = 1 = yes
5 F1554 Gr 55 5 fy = 36
MUST CHECK CONCRETE for ....
6 F1554 Gr 105 6
7 A193 Gr B7 7 fut = 58 2. Pullout strength of anchor
8 A354 Gr BC 9
3. Concrete side-face blowout strength of headed anchor
The anchor is automatically DUCTILE for tension and
9 A354 Gr BD 10 Ductile anchor bolt mat'l
Yes phi factor (D.4.4) = 0.75.
10 A449 12
Bolt Type Used: 2 do = 0.5 inch
Adequate Reinforcement Provided to Resist Shear Loads in Anchors?
Bolt Diameter: 1 do Ase Abrg* User's answer = 1 = yes
1 1/2 0.500 0.142 0.467
2 5/8 0.625 0.226 0.671 The anchor is automatically DUCTILE for shear and
3 3/4 0.750 0.334 0.911 phi factor (D.4.4) = 0.75.
4 7/8 0.875 0.462 1.188

Process Industry Practices Sheet 7 of 11

Anchor Bolt Design Spreadsheet
The anchor is automatically DUCTILE for shear and PIP STE05121
Revision 0a, April 2003 phi factor Tables
(D.4.4) = 0.75. January 2003

51 1.000 0.606 1.501

6 1 1/8 1.125 0.763 1.851
7 1 1/4 1.250 0.969 2.237
8 1 3/8 1.375 1.160 2.659
9 1 1/2 1.500 1.410 3.118 Load Combinations per
10 1 3/4 1.750 1.900 4.144 ACI ……....….(D 4.4) 1 Section 9.2
11 2 2.000 2.500 5.316 (D 4.5) 2 Appendix C
12 2 1/4 2.250 3.250 6.633 1
13 2 1/2 2.500 4.000 8.095
14 2 3/4 2.750 4.930 9.703 Perpendicular or 1
15 3 3.000 5.970 11.456 parallel to edge? perpendicular to edge
16 4 4.000 11.080 19.923 (D.6.2.1 (a), (b), or (c)) parallel to edge
* Heavy Hex
Ductility Required for Intermediate or High Ductility Required for
1 2
Tension? Seismic Risk? Shear? 1
1 Yes 1 Yes 1 Yes
2 No 2 No 2 No

Built-up Grout Pad? 1 Y7: 4

1 Yes 1 1.0 1.0 - No edge reinf or edge reinf rebar < #4
2 No 2 1.2 1.2 - Edge reinf rebar >= #4
3 1.4 1.4 - Edge reinf rebar >=#4 + stirrups @ <= 4 in.
4 1.4 1.4 - Located in region where there isn't cracking at service loads (ft < fr)
Concrete Failure Modes Capacity (kips)
1 Concrete breakout strength of anchor in tension 29.6 1 Applicable Interaction Equation
2 Pullout strength of fastener in tension 62.7 2 1 (D-1) fNn >= Nu
3 Concrete side-face blowout strength of anchor in tension NA 3 2 (D-2) fVn >= Vu
4 Concrete breakout strength of anchor in shear 7.6 4 3 (D-29) Nu/(fNn) + Vu/(fVn) <= 1.2
5 Concrete pryout strength of anchor in shear 59.2 5
Use Equation 2
Governing Tension Concrete Capacity = 29.6 kips
Concrete Failure Mode for Tension = 1 Manual An 2 Manual Av 2
1 Yes 1 Yes

Process Industry Practices Sheet 8 of 11

 PIP STE05121
Anchor Bolt Design Spreadsheet
Revision 0a, April 2003
Tables January 2003

Governing Shear Concrete Capacity = 7.6 kips 2 No 2 No

Concrete Failure Mode for Shear = 4

Process Industry Practices Sheet 9 of 11

 PIP STE05121
Anchor Bolt Design Spreadsheet
Revision 0a, April 2003
Glossary January 2003

Abrg bearing area of the head of stud or anchor bolt, in. 2

ANo projected concrete failure area of one anchor, for calculation of strength in tension, when not limited
by edge distance
AN projected concrete failure area of an anchor or group of anchors, for calculation of strength in
tension
Ase effective cross-sectional area of anchor, in.2
AVo projected concrete failure area of one anchor, for calculation of strength in shear, when not limited
by corner influences, spacing, or member thickness
AV
Projected concrete failure area of an anchor or group of anchors, for calculation of strength in shear
c distance from center of an anchor shaft to the edge of concrete, in.
c1 distance from center of an anchor shaft to the edge of concrete in one direction, in. Where shear
force is applied to anchor, c1 is in the direction of the shear force. For tension, c1 is the minimum
edge distance.
c2
distance from center of an anchor shaft to the edge of concrete in the direction orthogonal to c 1, in.
cmax the largest of the edge distances that are less than or equal to 1.5h ef, in. (used only for the case of
3 or 4 edges).
cmin the smallest of the edge distances that are less than or equal to 1.5h ef, in.
do shaft diameter of anchor bolt, in.
du diameter of head of stud or anchor bolt or equivalent diameter of effective perimeter of an added
plate or washer at the head of the anchor, in.
eN' eccentricity of normal force on a group of anchors; the distance between the resultant tension load
on a group of anchors and the centroid of the group of anchors loaded in tension, in.
eV' eccentricity of shear force on a group of anchors; the distance between the point of shear force
application and the centroid of the group of anchors resisting shear in the direction of the applied
shear, in.
f'c specified compressive strength of concrete, psi
fct specified tensile strength of concrete, psi
fr modulus of rupture of concrete, psi
ft calculated tensile stress in a region of a member, psi
fy specified yield strength of anchor steel, psi
fut specified tensile strength of anchor steel, psi
h thickness of member in which an anchor is anchored measured parallel to anchor axis, in.
hef effective anchor embedment depth, in.
k coefficient for basic concrete breakout strength in tension
kcp coefficient for pryout strength
l load bearing length of anchor for shear, not to exceed 8d o, in.; hef for anchors with a constant
stiffness over the full length of the embedded section, such as headed studs.
n number of anchors in a group
Nb basic concrete breakout strength in tension of a single anchor in cracked concrete, lb.
Ncb nominal concrete breakout strength in tension of a single anchor, lb.
Ncbg nominal concrete breakout strength in tension of a group of anchors, lb.
Nn nominal strength in tension, lb.
Np pullout strength in tension of a single anchor in cracked concrete, lb.
Npn nominal pullout strength in tension of a single anchor, lb.
Nsb side-face blowout strength of a single anchor, lb.
Nsbg side-face blowout strength of a group of anchors, lb.

Process Industry Practices Page 10 of 11

 PIP STE05121
Anchor Bolt Design Spreadsheet
Revision 0a, April 2003
Glossary January 2003

Ns nominal strength of a single anchor in tension as governed by the steel strength, lb.
Nu factored tensile load, lb.
s anchor center-to-center spacing, in.
so spacing of the outer anchors along the edge in a group, in.
t thickness of washer or plate, in.
Vb basic concrete breakout strength in shear of a single anchor in cracked concrete, lb.
Vcb nominal concrete breakout strength in shear of a single anchor, lb.
Vcbg nominal concrete breakout strength in shear of a group of anchors, lb.
Vn nominal strength in shear, lb.
Vp pullout strength in shear of a single anchor in cracked concrete, lb.
Vpn nominal pullout strength in shear of a single anchor, lb.
Vsb side-face blowout strength of a single anchor, lb.
Vsbg side-face blowout strength of a group of anchors, lb.
Vs nominal strength of a single anchor in shear as governed by the steel strength, lb.
Vu factored tensile load, lb.
f strength reduction factor
Y1 modification factor, for strength in tension, to account for anchor groups loaded eccentrically
Y2 modification factor, for strength in tension, to account for edge distances smaller than 1.5h ef
Y3 modification factor, for strength in tension, to account for cracking
Y4 modification factor, for pullout strength, to account for cracking
Y5 modification factor, for strength in shear, to account for anchor groups loaded eccentrically
Y6 modification factor, for strength in shear, to account for edge distances smaller than 1.5h ef
Y7 modification factor, for strength in shear, to account for cracking

Process Industry Practices Page 11 of 11