All structural design building codes have design response spectra. In this video you will learn how this was made using just excel. However, in the code, ductility factor is incorporated such that base shear from earthquake is reduced. This video however shows pseudo acceleration response spectra which is required prior to doing the inelastic design response spectra. Download excel here.
Response spectrum generation
