you can use this sheet to calculate Earthquake Lateral Forces according Egyptian Code of loads according to ( ECP201‐2008 ), Rev1.2
#ECP_Spreadsheet
#ECP_Spreadsheet
NOTE, MY OPINION IS TO USE THE TYPE 2 FOR ALL REGIONS OF EGYPT, DUE TO THE CONFLICT BETWEEN ECP201-2008 OR 2011 AND THE EC8-PART1 WHICH IS A REFERENCE FOR ECP201
SEE BELOW IMAGE FOR CONFECTION.ALSO YOU CAN COMPARE THE TOTAL BASE SHEAR WITH UBC97 OR IBC2006/ASCE7-05
for any comments in this sheet post your comment below.