The 1997 Uniform Building Code (UBC) Lateral Design provisions were among the most widely used seismic and wind-resistant design tools in the late 1990s and early 2000s. This collection of Excel sheets covers UBC 1997 and IBC seismic and lateral design, automating the calculation of base shear, force distribution, and lateral load-resisting system design checks.
Background: UBC 1997 Lateral Design
The UBC 1997 seismic design methodology introduced significant refinements over earlier editions, including revised seismic zone maps for the western United States, near-source factors for sites close to known active faults, and a more refined soil profile classification system (SA through SF). It formed the basis for much of the seismic design practised in California and neighbouring states through the early 2000s.
Despite being superseded by IBC 2000 and later editions, UBC 1997 provisions remain directly relevant for:
- Seismic assessment and retrofit of structures designed under this code
- Jurisdictions internationally that continue to reference UBC 1997
- Academic study of the evolution of seismic design codes
- Comparative analysis with current ASCE 7-based IBC provisions
UBC 1997 Base Shear Formula
V = (Cv × I) / (R × T) × W, subject to minimum and maximum limits defined in UBC 97 Section 1630.2. The total base shear V is distributed over the building height using a modified triangular distribution accounting for higher mode effects via Ft.
IBC 2000 Seismic Sheets Also Included
- Seismic Analysis Based on IBC 2000 (ELF Procedure §1617.4)
- Redundancy Factor ρ Based on IBC 2000
- Special Moment Resisting Frame seismic detailing per ACI 318-02 (Beam, Column, Joints)
Download Excel Sheet Collection
Practical Value of These Sheets Today
While IBC 2021 and ASCE 7-22 are the current standards, practising engineers regularly encounter legacy structures designed under UBC 97 or IBC 2000. Having these Excel sheets on hand allows rapid verification of original design assumptions, supports permit applications for alterations, and assists in seismic assessment studies. Download the full collection below to access all UBC 1997 and IBC 2000 lateral design tools in one place.
