Any Materials Permitted (602.5) 0 0 0 0 0 0 0: Windows (715.4.8) Door&Shutter (715.3)
Any Materials Permitted (602.5) 0 0 0 0 0 0 0: Windows (715.4.8) Door&Shutter (715.3)
Exception: Manual fire alarm system not required in low-height buildings with 1-hour separation of unit. Separate fire alarm system
not required in sprinkler buildings with local alarm notification.
E Educational facilities
Female: 1 per 50 = 2
Required lavatories
Male: 1 per 50 = 2
Female: 1 per 50 = 2
Required bath or shower
Total: 0 = 0
0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
= r QE ± 0.111(D)
Base Shear 1614 IBC 1616.4.1 IBC 1617.4 IBC 1617.4 IBC 1617.4 IBC 1617.4 IBC 1617.4
CsW CsW CsW CsW CsW
0.01 W 0.208W 0.208(W) 0.208(W) 0.208(W) 0.208(W)
Design and Detailing requirement ASCE 9.5.2.6.1 ASCE 9.5.2.6.2 ASCE 9.5.2.6.3 ASCE 9.5.2.6.4 ASCE 9.5.2.6.5 ASCE 9.5.2.6.5
Connection ASCE 9.5.2.6.1.1 ASCE 9.5.2.6.1.1 ASCE 9.5.2.6.1.1 ASCE 9.5.2.6.1.1 ASCE 9.5.2.6.1.1 ASCE 9.5.2.6.1.1
.133SDSWp .133SDSWp .133SDSWp .133SDSWp .133SDSWp .133SDSWp
.133SDSWp or 0.05Wp 0.074 0.074 0.074 0.266 0.074 0.074
Anchorage of concrete or masonry walls 9.5.2.6.1.2 9.5.2.6.2.8 9.5.2.6.3.2 9.5.2.6.3.2 9.5.2.6.3.2 9.5.2.6.3.2
.133SDSWp .40IESDSWw 0.8SDSIE(Ww) 0.8SDSIE(Ww) 0.8SDSIE(Ww) 0.8SDSIE(Ww)
Flexible or .05Wp 0.333(W) 0.666(W) 0.666(W) 0.666(W) 0.666(W)
Rigid or 400SDSI 0.666Wp 0.666Wp 0.666Wp 0.666Wp
Redundancy, r 1 1 1 ASCE 9.5.2.4 ASCE 9.5.2.4 ASCE 9.5.2.4
Diaphragm .2IESDSWp + Vpx .2IESDSWp + Vpx ASCE 9.5.2.6.4.4 ASCE 9.5.2.6.4.4 ASCE 9.5.2.6.4.4
Eq. 9.5.2.6.2.7 0.17Wp + Vpx
Collector, element & connection 9.5.2.6.2.6 9.5.2.6.3.1 9.5.2.6.4.1 9.5.2.6.3.1 9.5.2.6.3.1
E Em=W QE ± 0.2SDSD Em =WQE ± 0.2SDSD Em=WQE ± 0.2SDSD Em=WQE ± 0.2SDSD
=2 QE ± 0.111(D)
Light frame E E E E E
Bearing wall & Shear wall .40IESDSWw .40IESDSWw .40IESDSWw .40IESDSWw .40IESDSWw
0.333 0.333 0.333 0.333 0.333
concrete and masonry walls anchor 333 lbs/ft
Element Supporting discontinuous Em=WQE ± 0.2SDSD Em=WQE ± 0.2SDSD Em =WQE ± 0.2SDSD Em=WQE ± 0.2SDSD Em=WQE ± 0.2SDSD
Wall and Frame =2 QE ± 0.111(D)
Plan and Vertical Irregular n/a n/a n/a 9.5.2.6.4.2 9.5.2.6.5.1 9.5.2.6.5.1
Not permit Type 1b or 5 Type 1b or 5
Building Separations na n/a n/a n/a n/a n/a
Wall not part of the lateral-force-resisting system IBC 2106.3.1 IBC 2106.3.1 IBC 2106.3.1 IBC 2106.3.1 IBC 2106.3.1
Design of discontinuous members that are part
of the lateral-force-resisting system IBC 2106.4.1 IBC 2106.4.1 IBC 2106.4.1 IBC 2106.4.1
1.5 times the forces IBC 2106.5.1 IBC 2106.5.1 IBC 2106.5.1
Steel
Structural steel IBC 2205.2.1 IBC 2205.2.1 IBC 2205.2.1 IBC 2205.2.2 IBC 2205.2.2 IBC 2205.2.2
Composite IBC 2212.1.2 IBC 2212.1.2 IBC 2212.1.2
Light frame IBC 2211.1 IBC 2211.1 IBC 2211.1 IBC 2211.4 IBC 2211.4 IBC 2211.4
Wood
General IBC 2305 IBC2305 IBC2305 IBC2305 IBC2305 IBC2305
Shear wall 2305
Structural wood panel, h/d ratio, 2305.3.3 31/2:1 31/2:1 31/2:1 2:1 2:1 2:1
Gypsum Board & Stucco 11/2:1 11/2:1 11/2:1 11/2:1 NP NP
Particleboard 31/2:1 31/2:1 31/2:1 NP NP NP
Fiberboard 11/2:1 11/2:1 11/2:1 NP NP NP
Shear panel connections (2305.1.4) NA NA NA IBC 2305.1.4 IBC 2305.1.4 IBC 2305.1.4
Sill Plate IBC 2305.3.10 IBC 2305.3.10 IBC 2305.3.10
MSJC = Masonry Standards Joint Committee (ACI 530.1-02/ASCE 6-02/TMS 602-02)
2) ASCE 7-02, SECTION 6.5 ANALYTICAL PROCEDURE METHOD 2
6.5.12 Design Wind Loads on Enclosed and Partially Enclosed Buildings. (all Heights) ###
MWFRS Velocity pressure qz = .00256 Kz Kzt Kd V2 Iw Eq. 6-15 ###
Exposure B Roof Height h = 15 feet ###
Exposure coefficient Kz = Section 6.5.6.6, is obtained from Table 6-3, Case 2 for MWFRS ###
Topography factor Kzt = 1.00 Section 6.5.7.2, Figure 6-2
Directionality factor Kd = 0.85 Table 6-4
Wind Speed V = 90 mph
Importance factor Iw = 1.00 Table 1604.5 T-6-7
qz = 17.63 Kz psf Open Building
Internal Pressure Coefficient (GCpi) = ± 0.18 Figure 6-5 for Enclosed Building Partially Enclosed
Gust effect factor G = 0.85 Section 6.5.8.1 Enclosed Building
Pressures for MWFRS p = qGCp - qi (GCpi) Eq. 6-17 Figure 6-3
Wall and Roof External pressure Coefficients Cp from figure 6-6 or 6-8 ###
Wind Normal to ridge (┴ to 25) L/B = 2.00 h/L = 15/50 = 0.30 θ= 0.0 ###
Windward wall Cp = 0.8 Windward roof Cp = ###
Leeward wall Cp = -0.30 for L/B = 2.00 Leeward roof Cp = ###
Side wall Cp = -0.7 or Roof Cp = -0.90 -0.90 -0.50 -0.30
Wind parallel to ridge (┴ to 50) L/B = 0.50 ###
Windward wall Cp = 0.8 h/L = 15/25 = 0.60
Leeward wall Cp = -0.50 for L/B = 0.50 Roof Cp = -0.98 -0.94
Side wall Cp = -0.7 for dist 7.50 15.00 ###
for h/L < .5
for h/L > 1.0
-7.7, -7.7
-8.4 -8.1 ###
###
###
= 0.0 ###
###
qi ± 1.82 ###
GCpi = ± 0.18 ###
qi(GCpi) = ± 10.13(0.18)
= ± 1.82
All forces shown in psf All forces shown in psf
9.47 @ 0 to15 ft 11.19 @ 0 to 15 ft
= 50 = 25
p = qGCp - qi (GCpi) Eq. 6-15
where q = qz for windward
q = qh for leeward wall, side wall and roof @15 ft
qi = qh for enclosed building @15 ft
H = 50
= H/2
Lh = 600
Height above local ground z = 15 ft
Hill Shape 3-dimentional axisym
Exposure B
Height of hill, H= 50 ft < 60, Topographic Effects shall not be included###
Distance upwind of crest to where the
difference in ground elevation is half the
height of hill, Lh = 600 ft 2-dimensional ridge
H/Ln = 0.08 < 0.2, Topographic Effects shall not
2-dimensional
be included escarpments
calculate K1 by using H/Ln = 0.08 3-dimentional axisym
Distance from the crest to the building, x = 250 ft x/Lh = 0.42
from ASCE-7-02, Figure 6-4, K1/(H/Lh) = 0.95 K1 = 0.08
calculate K2, K3 by using Ln = 600
K2 = 1 - x/µLh µ= 1.5
K2 = 0.72
K3 = e-γz/Lh γ= 4
K3 = 0.90
Kzt = [1 +K1K2K3]2 Eq. 6-3
Kzt = 1.11 Back to Wind load
The application is created by Yo Ratanapeanchai, SE. This spreadsheet is intended as an
educational tool for the learning and understanding of the IBC 2003. It will perform both Fire Life
Safety (chapter 3, 5, 6, 7, 8, 9, 10, 15 and 29) and Structural (Snow, Wind and Earthquake Load,
Chapter 16 and ASCE7-02) . Requires Microsoft Excel 2000 or later. The application is freeware, so
feel free to distribute or modify.
DISCLAIM STATEMENT: The author disclaim any and all responsibility and liability for the accuracy
of and application of the information contained in this spreadsheet to the full extent permitted by the
law.
Date Location Note
1-Aug-03 All sheets IBC 2003 and ASCE7-02
23-Mar-04 Sheet EQ revise cell B42, to report a corrected base shear.
Input option for flexible or rigid diaphragm at cell B12 per Section 1616.3
26-Mar-04 Sheet Wind Add windload for open structure
1-Apr-04 Sheet L,Lr,S Add entire sheet
27-Jul-04 Sheet EQ Revise T-1604.5, Seismic use Group (Change from 2000)
T-9.5.2.2, for OCBF
ratany@yahoo.com
ratany@co.clark.nv.us
Revision 3