Generating a Response Spectrum from acceleration time history

Hello everyone. In this video I am discussing how a response spectrum is generated using an acceleration time history. I also briefly discuss about displacement vs acceleration time history and how tall buildings are designed and detailed from a different perspective as they are drift driven designs because of the nature of the long period.
Download the spreadsheet from this link here:
drive.google.com/file/d/1hxFO...
For any engineer it is always important to understand how the loads are developed and how these loads impact the building behavior and design. I feel this spreadsheet can be very useful in fundamentally understanding the different excitation and ground motions and their impact on the structural performance.
You can download more seismic records from this link:
ngawest2.berkeley.edu/
Selection of relevant time histories for the building site comes from fundamentally understanding the response spectrum it generates. As it is extremely important to understand if the selected time histories actually produce the desired level of seismic hazard for the building that is being designed. Using these kind of tools can easily assist you in analyzing this data.

[@sreekanth4966]

Great Video!
Key Take aways
1. Soil_Structure interaction effects
2. Short buildings experience higher acclerations i.e, vigorous shaking while Tall buildings( Flexible buildings with higher natural frequencies) experiences higher displacement demands subjected to the soil on which it is resting. I mean short buildings resting on loose soil experiences lesser shaking compared to Tall buildings on loose soil ( Resonance effect).
Thanks a lot for this video it is really great that you have used excel to create these plots which I feel a tedious job👏👏.

[@seymurakbarov1742]

Great Video!

[@zhafranabel6179]

i love u, u made my thesis easy

[@ylmazylmaz222]

thx a lot mate u the beast

[@rabinsonrai2905]

Hello sir, can you make another video explaining the reason behind other buildings? As a engineering student, I feel these kind of videos are insightful and motivational.

[@sheykwaoswin7240]

Please why is that when i download the excel file the not everything is inside. No area to generate response as it's in the video

[@blue_niib]

Sir can you make a vedio on CSIbridge having damper and laminated rubber bearing

[@lamatoyoda1506]

Thank you for the great content. I can not generate the RS as you did.. would you please advise me.

[@erginulutas5419]

me to. Is the problem macros. I could not find

[@pinakiadak1025]

Sir in the macro we can not see any rs generate button. Even from macro I can not generate the graphs

[@user-lb9dj4zq2e]

Hi sir just came across this great video, seems when the excel file was uploaded to google drive the macro was deleted somehow...can't see any buttons or code when open the file on my local folder.

[@devashishrajpoot3610]

same for me

[@a.alperakis4585]

same for me

[@vineetgajamer304]

Hello can you please tell me how to calculate PGV?

[@user-sl1kf1oh4n]

Dear Sir there is no generate option in the excel sheet even after unblocking macros in the file

[@erginulutas5419]

Can you activate the generate option. I could not see

[@wazir252]

soft soil increases the shaking 5:16