2009 IBC / ASCE 7-10 
SEISMIC BASE SHEAR, DIAPHRAGM LOAD AND ELEMENTS' LATERAL FORCE
IBCPRO by STRUCTECH
  Project  :  
Building : Folding Partition
     
REQUIRED INPUT ARE INDICATED BY BLUE COLOR NUMBERS 
 
INPUT  
Occupancy Category Per Table 1.1 II ndim  
Site Classification Per Geotechnical Engineer or Table 20.3-1   D ndim
0.2 Second Spectral Acceleration Ss Per Fig. 22-1 to 14 Ss = 1.500 g
1.0 Second Spectral Acceleration S1 Per Fig. 22-1 to 14 S1 = 0.600 g
R Factor per Table 12.2-1 R = 4 ndim
Redundancy Factor  - Section 12.3.4 r = 1 ndim
Period Parameters Ct - Table 12.8-2 Ct = 0.020 ndim
Long Period Transition Period TL - Fig. 22-15 to 20 TL = 6.000 second  
Regular Structure and 5 Stories and Less  in Height ? Yes  
Horizontal Force Factors Per Tables 13.5-1 &13.6-1    
Component Amplication Factor  Ap = 1 ndim
Component Response Modification Factor Rp = 2.5 ndim For Folding Partition
Component Importance Factor Per Section 13.1.3 Ip = 1.0 ndim
 
SEISMIC DESIGN PARAMETERS  
Occupancy Importance Factor Per Table 11.5-1 I = 1.00 ndim
Total Building Height H = 25 ft
Approximate Fundamental Period  Per Eq. (12.8-7)  Ta = 0.224 sec
Site Coefficient  Fa Per Table 11.4-1 Fa = 1.00 ndim
Site Coefficient  Fv Per Table 11.4-2 Fv = 1.50 ndim
Design Spectral Acceleration SDs for Base Shear SDs = 1.000 g
Design Spectral Acceleration SD1 SD1 = 0.600 g
SEISMIC DESIGN CATEGORY    D  
Seismic Response/ Base Shear Coefficient Without r Factor Cs = 0.250 ndim
DESIGN BASE SHEAR V = 0.40 kips
 
STORY LATERAL FORCE PER SECTION 12.8.3  
STORY HEIGHT WEIGHT LATERAL FORCE STORY SHEAR STORY OTM
LEVEL  hi wi wx*(hx)k Fx Fx/1.4 Vx Vx/1.4 Mot Mot/1.4  
ID ft kips kips.ft kips kips kips kips k ft k ft  
ROOF 25 0.54 13 0.27 0.19 0.27 0.19
L2 12 0.54 6 0.13 0.09 0.40 0.29 3.531 2.52
Ground 0 0.54 0 0.00 0.00 0.40 0.29 8.355 5.97
0
0
SUM 2 0.4 0.3
 
DIAPHRAGM LOAD  PER SECTION 12.10.11  
STORY HEIGHT DIAPHRAGM LOAD
LEVEL  hi Ft +S Fi S wi (Ft + SFi) Fpx Fpx/1.4
ID ft kips kips Swi kips kips
ROOF 25 0 1 0.51 0.2 0.2
L2 12 0 1 0.38 0.2 0.1
Ground 0 0 2 0.25 0.1 0.1
                   
0
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
0 0 #VALUE! 0 #VALUE! #VALUE! #VALUE!
                 
ELEMENTS OF STRUCTURES LATERAL & VERTICAL FORCE PER  SECTION 13.3     
Design Spectral Acceleration SDs SDs = 1.000 g
FOR ANCHOR @ CMU
STORY HEIGHT COEF. LATERAL FORCE VERT SEISMIC w/o YIELDING ATTACH. 
LEVEL  hi Wp (Fp / Wp) Fp Fp/1.4 Fpv Fpv/1.4 2.5 * Fp (2.5 * Fp)/1.4
ID ft lbs lbs lbs lbs lbs lbs lbs
ROOF 25 100 0.48 48 34 20 14 120 86
L2 12 100 0.31 31 22 20 14 78 56
Ground 0 100 0.30 30 21 20 14 75 54
                   
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
STRUCTURAL WALL'S OUT OF PLANE ANCHORAGE FORCES PER  SECTION 12.11     
Design Spectral Acceleration SDs SDs = 1.000 g Lf = 100 ft
FOR WALLS NOT AT ROOF
STORY HEIGHT Tributary FOR WALL DESIGN FOR ANCHOR DESIGN WITH NO FLEX DIAPHRAGM
LEVEL  hi Wp Fp Fp/1.4 Fp Fp/1.4 Fp Fp/1.4
ID ft lbs/ft lbs/ft lbs/ft lbs/ft lbs/ft lbs/ft lbs/ft
ROOF 25 1000 400 286 800 571
L2 12 1000 400 286 800 571 261 187
Ground 0 1000 400 286 800 571 133 95
                   
END OF CALCULATIONS
To report any 'bug' in the spreadsheet, please contact structech@gmail.com
                             www.structech.us