ࡱ>  I@\pPGmant Vadalkar Ba= =XJ\+8X@"1Courier1Arial1Arial1Arial1Arial1 Courier1, Verdana1 Courier1Courier12,Bookman Old Style1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1,h Century Gothic1Courier1Courier1 Courier1Courier1 Verdana1Courier1 Verdana1Courier"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.000_)0_) mmm\-yy_) 0.00_) 0.0_) 0.0000_) 0.00000_) 0.0000% 00000 0.000 0.0000                + ) , *             # $ $ " $ $    @   !                               #        !  !     "  #  $   @(     &   `!EQCalc" Time periodChart1Chart2 KHelp PAGE1;| PAGE2;#  ;| ' Print_Area_MI;#j `ijb($  +3  @@  1 Earthquake load calculations as per IS1893-2002.TYPICAL STOREY HEIGHT =MTS.TYPICAL WIDTH OF COLUMN =MMS. TOTAL NUMBER Project : OF COLUMNS =User :hsvDate :DENSITY OF CONCRETE =TONS/M3(1)TONSCOL.TYPEIIIIIIIVVVIVIIVIIICOLUMNSTOREY LOAD?(2)"Height of the building h (metre) =COL. NO.(TONS)(3)*Base dimension of the building d (metre) =FOOTING(4)GROUNDFIRST(5)(Time period T (T1 = 0.09 * h / sqrt(d)=secondsSECOND(T2 = 0.075*h^0.75 ; T3 = 0.085*h^0.75 )(6)THIRD(7)(8)FOURTH(9)# From Fig 2 of IS:1893-2002 Sa/g =(10))Design Horizontal Seismic coefficient Ah FIFTH(11)# Ah =Z*I*Sa/(2*R*g) = SIXTH(12)#DESIGN BASE SHEAR ( Vb = Ah * W ) =SEVENTH(13)TYPICAL STOREY HEIGHT ( H ) =METRESEIGHTH(14)(15)TENTH= TOTAL LOAD =FLOORNO. OFJOINTTOTAL(MTS)JOINTSFORCEBMCUMMU.AT ROOFSTILT(I)(II)" TYPICAL FLOOR SLAB (DEAD) LOADS =(III)" TYPICAL FLOOR WALL (DEAD) LOADS =(IV)" TYPICAL FLOOR SLAB (LIVE) LOADS =(V) ROOF FLOOR SLAB (DEAD) LOADS =(VI) ROOF FLOOR SLAB (LIVE) LOADS =(VII)$ GR. / PLINTH LEVEL D.L. (NO L.L.) =(VIII)" TYPICAL FLOOR D.L. + (25%) L.L. =(IX) ROOF FLOOR D.L. + (25%) L.L. =ZoneZSeismic Zone Factor Strata type Hard Soil Medium Soil Soft SoilTime Period T =secSa/g(4a)'Soil strata 1: Hard, 2: Medium, 3: Soft Height h(m)Base dimension d (m)Bldg. Without Brick infillRC frame Steel frame T=0.075h^0.75 T=0.085h^0.75"Buildings with Brick infill panelsT= 0.09*h/d^0.5 Calculation of Time period T secFProvide the required parameters like building height, base dimension, ?soil strata, building type, zone factor, Importance factor etc.BProgram will calculate the base shear Vb for the entire structure.FTo calculate the seismic weight, provide DL+appropriate fraction of LLGfor every floor and height of floor. This is required to calculate the ;distribution of EQ forces along the height of the building.)P_FACTOR = (Wi*hi^2) / (TOTAL(Wi*hi^2))Qi = P_FACTOR * VbWihiWi*hi^2 P_FACTORQi)Approximate Seismic weight calculations :BaseTABLE 2 of IS1893-2002Figure 2 T v/s Sa/g% TYPICAL FLOOR BEAM+COL SELF WT(DL) =CEarthquake base shear calculations are done as per new IS1893-2002.NINTH(TOTAL SEISMIC WEIGHT OF BUILDING ( W ) =(W) MT(Vb) MTB.M. @ BASE ( TM) BReference may be made to IS1893-2002 for the different parameters.OValues of Zone factor Z are given at the location Col:AC Row:7 in sheet EQCalc.Mcan be carried out based on column sizes at different floors in sheet EQCalc./for RCC and steel frames without infill panels.+Help on the work sheet : by Hemant Vadalkar6All the cells with yellow colour are for data input. IAt location, Column:O , Row:1, approximate column selfweight calculationDGraphs of Time period T v/s Height H can be viewed in sheet "Chart1"NSheet named " Chart2" shows graph of T v/s H for RCC frames with infill panels8for different base dimensions like 10m, 20m,30m and 40m.:Numbers in blue colour are not protected & can be changed.F Earthquake load calculations as per IS1893-2002.- by Hemant Vadalkar.3%E#$Building Type 1: Bldg. with infill # 2 : RCC frame Bldg. without infill% 3 : Steel frame Bldg. without infillZone factor Z as per Table 2 =  $Importance Factor I as per Table 6 =,Response Reduction Factor R as per Table 7 =#Building xyz at Mumbai. Rev.Mar2003+Approximate Column selfweight calculation :KFor suggestions and comments contact Hemant Vadalkar at Email: vva@vsnl.comNo macro is used in this sheet.* "L./r,"bDQ3V8 8 K-  I@ $$N?U6q{}  dMbP?_*+%D# j MHP DeskJet 670C Series Printer7d,,HP DeskJet 670C Series PrinterLPT1 ,,"L,,??cU} } } } }  }  } }  } } } } } } }  Column AA  ; ,     ,         , 7 EFFFFFFFDDD ~  r@  ~ l@    & '' #O@FD %   & ''  2ƹ^i@AJ  ~ @  6  K@Dg                     c )d    a  b   ~ >4@ 6 @4@$@@@@ @?   ?$@ ?  @$@   !~ >$@ "6 z@@@@P@@@X@@ I +V@D D D D D D D D D D D D D D D D D2.ADD  @0@ @  @8@  # ~ >?5 At6? ףp= ?D D ? $6 pw@ |@h@@@p@ȉ@ @ ̳M@ D D D D D D D D D D D D D D D D D.ADD+ <׃@D Dw? @B@ =/=?333333?D ? ?/Rc?(\µ?D ? %6pw@ |@h@@@@p@ȉ@p= ףsL@DD DD DD DD DD DD DD DD D.ADD+ףp=:@DDy? i*At6?D j  l m~ >@ & 'WJAt6?AD   D *D   D DBB ( )6r@pw@ |@h@h@@@p@/$H@DD DD DD DD DD DD DD DD D.ADD+M2m@DDy? 6 * e #k  + ~ >0@ ,6r@r@pw@ |@ |@h@@@GzD@DD DD DD DD DD DD DD DD D.ADD+G*3@DDy?  - ~ >?~ ? f+yedA?{}D D? B$DKD? D? B$ @D"B  . ~ >@ /6l@r@r@pw@pw@ |@h@h@GzWB@DD DD DD DD DD DD DD DD D.ADD+Gz @DDy?~ @ g+ED<@D D? B$DQD? D? B$ @(\?D"B 0 1XIED<@BD  $*D  $ $"B~ @ h+@D D? B$DQD? Dq= ףp? B$ @Q?D"B 2 3 46l@l@r@r@pw@pw@ |@ |@Zd?@DD DD DD DD DD DD DD DD D.ADD+`"@DDy? 5 61Mp?gDDDD 7DD DD DD DD DD DD DD DD D.ADD+̤u@#DD{?L 8 9!H#[-@* DD  :DD DD DD DD DD DD DD DD D.ADD  ; <~ > r@ = >DD DD DD DD DD DD DD DD D.ADD ? ~ !DD DD DD DD DD DD DD DD D.ADDD{lV 8i8:D>iVHN O2o(  !"#$%&'()*+,-./0 1 2 3 4 5 6 7 8 9 : ; < = > ?   !@ ! !A!!#D!D D!D D!D D!D D!D D!D D!D D!D D.ADD! "!B "!B "!B ""B #C##Zd;v@ % !D##Hz\@  % !D $#D $# $# $# $ $# $#E $#F $ #G $ #G $ G %# %#H %# %#I %#J % #J % #K % #K &# & L & M & L ' D (!B (!B (!B (!B (!B (!B (!B (!B ( !B ( !B)) * N~ *&@@!*CGzS@* D,D'*MXA,D*D*D*!*c|J? D*Dg!*"Z@* D*D~ *:?!*"Z@* D*D** "Z@, D*~ * * , D* +C: +  ,9@&@!,C{G:S@* D.D',ףp=8OA.D,D,D,!,x- ;?, D,Dg!, f'P@, D,D~ ,:?!, f'P@, D,D,!, b`se@. D* D,!, QiPr@, D* D!, QiPr@. D* D, -C:- - .8@&@!.CzGR@, D0D'.= #BMA0D.D.D.!.p3ǵ?. D.Dg!.47 NO@. D.D~ .:?!.47 NO@. D.D.!. /q]Gm@0 D, D.!. /@. D, D!. @0 D, D. /C:/ / 07@&@!0CGzQ@. D2D'0p= OKA2D0D0D0!06yZm?0 D0Dg!0z{dL@0 D0D~ 0:?!0z{dL@0 D0D0!0 G[XW{@r@2 D. D0!0 B#:@0 D. D!0 b]@2 D. D0 1C:1 1 26@&@!2CGzQ@0 D4D'2ףHA4D2D2D2!2:E3?2 D2Dg!2fzVJ@2 D2D~ 2:?!2fzVJ@2 D2D2!2 %h&fu@4 D0 D2!2 Z>w@2 D0 D!2 =*@4 D0 D2 3C:3 3 45@&@!4CGzTP@2 D6D'4m= aFA6D4D4D4!4lת?4 D4Dg!4+`H@4 D4D~ 4:?!4+`H@4 D4D4!4 }x@6 D2 D4!4 0H@4 D2 D!4 ʖ0@6 D2 D4 5C:5 5 64@&@!6C(\5O@4 D8D'6ӣpDA8D6D6D6!6m[3?6 D6Dg!6nc38 CF@6 D6D~ 6:?!6nc38 CF@6 D6D6!6 g{@8 D4 D6!6 A h ڑ@6 D4 D!6 /u@8 D4 D6 7C:7 7 83@&@!8C(\M@6 D:D'8: ףpBA:D8D8D8!8ws*?8 D8Dg!8s=D@8 D8D~ 8:?!8s=D@8 D8D8!8 ۿ}@: D6 D8!8 D ޓ@8 D6 D!8 ҂rl@: D6 D8 9C:9 9 :2@&@!:C(\OL@8 D<D':p=AA<D:D:D:!:PR|?: D:Dg!:,$QB@: D:D~ ::?!:,$QB@: D:D:!: (@< D8 D:!: @: D8 D!: ~cٻ@< D8 D: ;C:; ; <1@&@!<CZ(J@: D>D'<G>A>D<D<D<!<{황?< D<Dg!< Z2}@@< D<D~ <:?!< Z2}@@< D<D<!< \Nd$@> D: D<!< k3]@< D: D!< ,`@> D: D< =C:= = >0@&@!>C'\hI@< D@D'>z;A@D>D>D>!>Xl?> D>Dg!>>_S=@> D>D~ >:?!>>_S=@> D>D>!> M@@ D< D>!>  ӤDۘ@> D< D!> `|@@ D< D> ?C:? ? DBl8\p85&R*R*R*R*R*R*R*R*R*R@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ @.@&@!@C(\G@> DBD'@Gz8ABD@D@D@!@\9\A?@ D@Dg!@txڦ=:@@ D@D~ @:?!@txڦ=:@@ D@D@!@ e 6@B D> D@!@ L 1@@ D> D!@ #6:@B D> D@ AC:A A B,@&@!BC(\F@@ DDD'BxG5ADDBDBDB!B9?B DBDg!BJ.)7@B DBD~ B:?!BJ.)7@B DBDB!B Ŭ@D D@ DB!B [|Zb@B D@ D!B @D D@ DB CC:C C D*@&@!DC(\E@B DFD'DEz 2AFDDDDDD!D8,5?D DDDg!DGNE4@D DDD~ D:?!DGNE4@D DDDD!D 73>@F DB DD!D To@D DB D!D Hb4@F DB DD EC:E E F(@&@!FC[(C@D DHD'FG n0AHDFDFDF!F29)u?F DFDg!FrGܓ1@F DFD~ F:?!FrGܓ1@F DFDF!F =sʄ@H DD DF!F &d0Z@F DD D!F ۈ]@H DD DF GC:G G H&@&@!HC(\(B@F DJD'H(\.,AJDHDHDH!Hʦ,?H DHDg!HdB&.@H DHD~ H:?!HdB&.@H DHDH!H ѕtiC@J DF DH!H %X&@H DF D!H ]@5@J DF DH IC:I I J$@&@!JC(\µ@@H DLD'JZ'ALDJDJDJ!JlBo‘?J DJDg!JCp)@J DJD~ J:?!JCp)@J DJDJ!J *7Մ@L DH DJ!J o i@Ԟ@J DH D!J $_G@L DH DJ KC:K K L"@N DJ~ L&@!LCQ>@J DND'L(\#ANDLDLDL!L2ln?L DLDg!L `I%@L DLD~ L:?!L `I%@L DLDL!L b&@N DJ DL!L +i@L DJ D!L _@N DJ DL MC:M M N @P DL~ N&@!NCQ;@L DPD'N(K APDNDNDN!NPB?N DNDg!NGg|NZo!@N DND~ N:?!NGg|NZo!@N DNDN!N 9TiD@P DL DN!N 艞y@N DL D!N \@P DL DN OC:O O P@R DN~ P&@!PCQ8@N DRD'POARDPDPDP!P4o?P DPDg!PaXw@P DPD~ P:?!PaXw@P DPDP!P F|@R DN DP!P v[$@P DN D!P u2@R DN DP QC:Q Q R@T DP~ R&@!RCQ5@P DTD'RQzWATDRDRDR!RAfyfH~?R DRDg!R{PB@R DRD~ R:?!R{PB@R DRDR!R 9ͧ@T DP DR!R 6ʼLM@R DP D!R FΟ@T DP DR SC:S S T@V DR~ T&@!TCQ2@R DVD'To= ׃AVDTDTDT!T*:ǩv?T DTDg!Tm8'\@T DTD~ T:?!Tm8'\@T DTDT!T RlȆ@V DR DT!T )f0l@T DR D!T  4;@V DR DT UC:U U V@X DT~ V&@!VCQ0@T DXD'Vףp=AXDVDVDV!VlY!Rp?V DVDg!VQ/v@V DVD~ V:?!VQ/v@V DVDV!V o-߆@X DT DV!V 攄@V DT D!V T}fp@X DT DV WC:W W X@Z DV~ X&@!XC> ףp=*@V DZD'X|Gj@ZDXDXDX!XV e?X DXDg!Xm?x?X DXD~ X:?!Xm?x?X DXDX!X llm@Z DV DX!X $Ԁb@X DV D!X ^y@Z DV DX YC:Y Y Z@\ DX~ Z&@!ZCq= ףp$@X D\D'ZHz@\DZDZDZ!Z"ϒZ?Z DZDg!Zh?Z DZD~ Z:?!Zh?Z DZDZ!Z {PE@\ DX DZ!Z ha@Z DX D!Z p`_Ѓ@\ DX DZ [A:[ [ \?  DZ\&@8@'\)\uP@^D\D\D\!\U˻CK?\ D\Dg!\UQA?\ D\D~ \:?!\UQA?\ D\D\!\ +@^ DZ D\!\ Y=짠@\ DZ D!\ R1#O@^ DZ D\ ]A:] ]  ^O^&@&v@'^Qx@`D^D^D^!^OBZe&?^ D^Dg!^=^#tE?^ D^D~ ^:?!^=^#tE?^ D^D^!^ #[-@` D\ D^(^ $Ke @^D\ D\D^!^ EH@` D\ D^  _B _:_ _ DlR*R*R*R*R*R*m*m*m*m*m,m,m,m,P,B`abcdefg,hijklmnop q r s t u v w x y z { | } ~   ``&e@8'`gD`D`D`!`` D`Dg!`g D`D~ `:?!`` D`D`!` #[-@L D^ D`(` **b @g D^ D^D`!` Wj/@` D^ D` a a:a a b b:b b c: c  d: d  e!B e!B e!B e"B e$B e%B e"B e"B e "B e "B e "B e %B e "Bff  gG#g6@ %*c`#g~A* %*c`#g?* %*c`#g<#[-@g %*c` g#g 6Wj/@` %*d ` g  h h h h9 h h #ii j5j kP k k~ ke@ kkl mQ mR m~ mY@ mmn oS oT o~ oy@ oop qU qV q~ qY@ qqrr sW sX~ s@ st uY uZ~ u uv w[ w\!w@Z DkDo wx y] y^8y@w"DkDmDoDq? yyz z {_ {` {2{̜u@yDkDsDu? {{||}~Dp lB,,(&P "PPPP8 8 O px x >@<d  ????mBT>B>B>BhXbab*0babhXb hXb*0*0Xbb)hxbh@;D@;I@;N@;Q@;T@ ~ ;/;333333?D?/(\µ?D?5- ףp= ?DD @?) p ףp= ?LL @?     ~ ;@a ?#-333333?L?nώ0?#-(\µ?L?At6? )-  ףp= ?LL @?"n¹?"T?At6?r|J? "LX? ;ľ?  "n©? ~ ;$@/T* ?/c?At6? "n?"T?At6?r|J? "LX? ;ľ?  "n¹? ~ ;.@џhJ?N2MX?bsR? %ZQ?3%l?bsR?,;p?  9BN? lO?  %ZQ? ~ ;4@=?Rc?At6? "n?"T?At6?r|J? "LX? ;ľ?  "n? ~ ;9@ci3?"i?0Rε? ;??t/jJ?0Rε?kO?\[]? /7? V;6?  ;?? ~ ;>@b ?!en?bsR? %ZQ?3%l?bsR?,;p?  9BN? lO?  %ZQ? ~ ;A@q6D?f?s˺1?  ?WkTJg?s˺1?? dBM? ET?   ? ~ ;D@`~$?\9?At6? "n?"T?At6?r|J? "LX? ;ľ?  "n? ~ ;F@ruNi??ɂ}? 8?gL_?ɂ}?alT? Ӫ5? 4?  8? ~ ;I@HALNI?d6u?0Rε? ;??t/jJ?0Rε?kO?\[]? /7? V;6?  ;?? ~ ;K@gN@  7  I@MHP DeskJet 670C Series Printer7d,,HP DeskJet 670C Series PrinterLPT1 ,,"d,,??3` 4#` 4#` 4#` 4#` 4#0X(  Xl X s * m  @v] ml <A< ll X s *Gm  @ FM ]Gml <B< 0 0 3 d 3Q <A : RC frames without infillQ ;-Q ;-Q3_  NM ]  4E4 3Q BB : Steel frames without infillQ ;-Q ;-Q3_ ! NM ] !!4E4D$% $M 3O&Q4$% $M 3O&Q4FAJQ 3Oj 3*#M! M43*#M! M4% M3O9&Q  Height h (m)'4% YfMZ3OS&Q &Time period T sec'43d" 3O% $M,3OQ443_ M NM ] MM<444% :T-M3Oz&Q 0Time period v/s height'44e@@$@$@.@.@4@4@9@9@>@>@A@A@D@D@ F@ F@ I@ I@ K@ K@ N@ N@ @P@ @P@Q@Q@R@R@T@T@@U@@U@V@V@W@W@Y@Y@@Z@@Z@[@[@\@\@^@^@@_@@_@@`@@`@`@`@a@a@ b@ b@b@b@ea ?nώ0?/T* ?/c?џhJ?N2MX?=?Rc?ci3?"i?b ?!en?q6D?f?`~$?\9? ruNi? ? HALNI? d6u? gN i4  I@MHP DeskJet 670C Series Printer7d,,HP DeskJet 670C Series PrinterLPT1 ,,"d,,??3` 4#` 4#` 4#` 4#` 4#` 4#` 4#` 4#` 4#  n(  r  0PLm  @  ]PLm|l <A<ll  s *Lm  @)  v]Lm l <B<ll  s *Lm  @)  ]]Lmd l <D 10<rr  0,Mm  @  ],Mm l <D 20<rr  0|Mm  @5 ` ]|Mmt l <D 30<ll  s *Mm  @  8 ]Mm l <D 40<ll  s *Nm  @9 M]Nm l a@<bFor A : T = 0.075 * h0.075 For B : T = 0.085 * h0.075 For others T = 0.09 * h / (d0.5) <@j}16\ _ a0 0 3d 3Q J#A : RC frames without infill panelsQ ;-Q ;-Q3_  NM ] MM<4E4 3Q L$B: Steel frames without infill panelQ ;-Q ;-Q3_ ! NM ] MM<4E4 3Q J#D 10 : Bldg. with infill & Base 10mQ ;-Q ;-Q3_  NM ] MM<4E4 3Q J#D 20 : Bldg. with infill & Base 20mQ ;-Q ;-Q3_ 4 NM ] MM<4E4 3Q J#D 30 : Bldg. with infill & Base 30mQ ;-Q ;-Q3_ $ NM ] MM<4E4 3Q D D40 : Bldg with infill &Base 40mQ ;-Q ;-Q3_ 3f0 NM ] MM<4E4D$%  M 3O&Q4$%  M 3O&Q4FAi 3Ok  3*#M! M43*#M! M4% |M3O=&Q  Height h (m)'4% ;^gM Z3O^&Q *Time period T Sec. '43d"  3O %  M,3O&Q423 M NM443_ M NM ] MM<444% XNM3O&Q 0Height v/s time period'44e@@@@@@$@$@$@$@$@$@.@.@.@.@.@.@4@4@4@4@4@4@9@9@9@9@9@9@>@>@>@>@>@>@A@A@A@A@A@A@D@D@D@D@D@D@ F@ F@ F@ F@ F@ F@ I@ I@ I@ I@ I@ I@ K@ K@ K@ K@ K@ K@ N@ N@ N@ N@ N@ N@ @P@ @P@ @P@ @P@ @P@ @P@Q@Q@Q@Q@Q@Q@R@R@R@R@R@R@T@T@T@T@T@T@@U@@U@@U@@U@@U@@U@V@V@V@V@V@V@W@W@W@W@W@W@Y@Y@Y@Y@Y@Y@@Z@@Z@@Z@@Z@@Z@@Z@[@[@[@[@[@[@\@\@\@\@\@\@^@^@^@^@^@^@@_@@_@@_@@_@@_@@_@@`@@`@@`@@`@@`@@`@`@`@`@`@`@`@a@a@a@a@a@a@ b@ b@ b@ b@ b@ b@b@b@b@b@b@b@ea ?nώ0?At6?"n¹?"T?At6?/T* ?/c?At6?"n?"T?At6?џhJ?N2MX?bsR?%ZQ?3%l?bsR?=?Rc?At6?"n?"T?At6?ci3?"i?0Rε?;??t/jJ?0Rε?b ?!en?bsR?%ZQ?3%l?bsR?q6D?f?s˺1? ?WkTJg?s˺1?`~$?\9?At6?"n?"T?At6? ruNi? ? ɂ}? 8? gL_? ɂ}? HALNI? d6u? 0Rε? ;?? t/jJ? 0Rε? gN Z I@   dMbP?_*+%"??cU      4~ ? '''''' GGGGGGG~ @ ~ @ ~ @ x y~ @ z { | }~ @ ~ @ ~  @  ~ "@    ~ $@ ,^|0$>@7  Oh+'0HPh Hemant VadalkarHemant VadalkarMicrosoft Excel@G@ns@od ՜.+,0 PXd lt| 2 EQCalc Time periodHelpChart1Chart2  WorksheetsCharts  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{}~Root Entry F+WorkbookSummaryInformation(|DocumentSummaryInformation8