ࡱ>    !"#$%&'()*+,-./0123456789:;<=>?@Root Entry@)ƧA@Workbook zWksSSWorkBook=WksSSChart,##0\)1 #,##0.0_);( #,##0.0\)5 #,##0.00_);( #,##0.00\)9 #,##0.000_);( #,##0.000\)= #,##0.0000_);( #,##0.0000\)A #,##0.00000_);( #,##0.00000\)E  #,##0.000000_);( #,##0.000000\)I" #,##0.0000000_);( #,##0.0000000\)5 #,##0_);[Red]\( #,##0\)= #,##0.0_);[Red]\( #,##0.0\)A #,##0.00_);[Red]\( #,##0.00\)E  #,##0.000_);[Red]\( #,##0.000\)I" #,##0.0000_);[Red]\( #,##0.0000\)M$ #,##0.00000_);[Red]\( #,##0.00000\)Q& #,##0.000000_);[Red]\( #,##0.000000\)U( #,##0.0000000_);[Red]\( #,##0.0000000\)                + ) , *        D# @ @@ @ @     @      #! "   ! # ##D # ! # !#@!       ## # D @  @ @@    @ ! @!    # !@#@" D" D  "  D @ @    D  @  !   # #@#@  D D #D  @@ #@#@ #@   !   " #  ##" D !  # # "D   D @ @@  "@@  @   @ "  D#  #@  \pMS Works Ba==-8X@"1Arial1Arial1Arial1Arial1Arial1 Arial1 Arial1 Arial1 Arial1 Arial1 Arial1( Arial Narrow1( Arial Narrow1( Arial Narrow1( Arial Narrow1 Arial1( Arial Narrow1 Arial1 Arial1( Arial Narrow1 Arial1 Arial1( Arial Narrow1 Arial1( Arial Narrow1( Arial Narrow1( Arial Narrow1(  Arial Narrow1 Arial1(  Arial Narrow1 Arial1  Arial1 Arial1 Arial1 Arial1 Arial1@ Copperplate Gothic Light1( Arial Narrow1 Arial"$"#,##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.00.0000.00000.000000.000000 0.00000000E+000.0E+00 0.000E+00 0.0000E+00 0.00000E+00 0.000000E+00 0.0000000E+001$#,##0.0_);($#,##0.0\)9$#,##0.000_);($#,##0.000\)=$#,##0.0000_);($#,##0.0000\)A$#,##0.00000_);($#,##0.00000\)E $#,##0.000000_);($#,##0.000000\)I"$#,##0.0000000_);($#,##0.0000000\) 0.0%0.000%0.0000%0.00000% 0.000000% 0.0000000%#,##0.0 #,##0.000 #,##0.0000 #,##0.00000 #,##0.000000 #,##0.0000000 d\-mmm\-yy mmmm d, yyyy m/d m/yy mmmm, yyyymmmm dd mmm mmmm dd dddd yy yyyy 00 000 000000000000000000000000000000#\ ?/2#\ ?/3#\ ?/4#\ ?/8#\ ?/10#\ ?/16#\ ?/32#\ ?/100=$#,##0.0_);[Red]\($#,##0.0\)E $#,##0.000_);[Red]\($#,##0.000\)I"$#,##0.0000_);[Red]\($#,##0.0000\)M$$#,##0.00000_);[Red]\($#,##0.00000\)Q&$#,##0.000000_);[Red]\($#,##0.000000\)U($#,##0.0000000_);[Red]\($#,##0.0000000\)9#,##0.0_);[Red]\(#,##0.0\)A#,##0.000_);[Red]\(#,##0.000\)E #,##0.0000_);[Red]\(#,##0.0000\)I"#,##0.00000_);[Red]\(#,##0.00000\)M$#,##0.000000_);[Red]\(#,##0.000000\)Q&#,##0.0000000_);[Red]\(#,##0.0000000\) #\ ??/???) #,##0_);( #    #  @# !! D"     "D "D D   D  (    D " D" D  # #     " D  D  D ! " $ # & ' % """# `&Sheet1$ Print_Area;>   g  dMbP?_*+%0"&?'?(?)?"??M oU } $} } m } m } $} I } } } } I} } I } m} $} $} } g"""T"@"@""""," " " " ", "",","@"""""@"""",""",",",",0'OVERTURN CALCULATOR version 1.1- 17-074+based on representative segment of building]Ta FREE DOWNLOAD from griffithplans.com (other calculators FREE at griffithplans.com)SJRead additional instructions before using (available at griffithplans.com).%MAKE ENTRIES IN YELLOW BLANKS ONLY 4+ BOLD ENTRIES ARE FORMULAS... DO NOT CHANGE PROJECT:  SAMPLE BUILDING   ASCE 7 ADJUSTMENTS DATE~ P`@BUILDING SEGMENTS uASCE equiv mph t !BASIC WINDSPEED~ @Z@ mph$ obtain from local wind maps @_@ D vmph 3 sec gusts #+2 DEGREE OF ROOF SLOPE 1( @% degrees (from table below) +     E  ROOF PITCH enter rise~ ? in 12   degrees roof pitch      D  / ROOF span~ D@ ft a @~ @      F 2 /)ROOF WIDTH usually matches wall length ft~ ^@ ft %include overhangs 6r"@~ @      2 * ROOF SF WEIGHT lbs~ 9@ lbs ,@~ @      * 2 ROOF OVERHANG~ ? ft%in span direction k6j2@~  "@*2%TOTAL ROOF HEIGHT above wall7VUUUUU@!D D D  ? ft%to peak or high point 7r6@~  %@*2)=@+/"TOTAL BUILDING HEIGHT to roof peak!*6@ DD ft 1:@~  )@*2)=@3WALL LENGTH long wall~ ^@ ft ťA>@~  `-@2)=@/ WALL HEIGHT~ 4@ ft Uz@@~  @1@)=(FASCIA LEADING EDGE~ @in high& N@D D  8oXoB@~  5@)@WALL SF WEIGHT~ 9@ lbs ՎC@~  8@"/WALL WEIGHT per long wall!L@ DD lbs 1 if flat .5 if peak HVAE@~  <@)"SLOPE LENGTH to highpoint>6@(D D  DD D  ft~  ?~  F@~  @@*)>@/TOTAL ROOF AREAD@.D D  DD D D  sf~  ?>@WINDWARD ROOF AREA.T@D DD D  sf4 @@D D D  ~  s \@/TOTAL ROOF WEIGHT!VUUUA DD  lbs  ] ^enter 1 for hip roof@) WALL WINDLOAD AREA per long wall%@DDB sf@% degree to radians conversion@0FOOTING DEPTH ft~ t@ ft ( @D  degrees****?@WIDTH ft~ @ ft% Rf.RH?D L@ radians****?@%if footing segments LENGTH ft~ t@ ft?@~ ?total WT per cf~ b@ lbs* SxJm5?o! @D 9 (0Coeff Lift = 2 * pi * angle of attack in radians?@ ",n"!","",#"$"%",&"'"(",)",*",+",,",-",.",/"0"1"2",3"4"5"6" 7",8",9",:",;"T<",=",>"?"! t@ DD  ft long ea  totalCF conc' Tfffff@DDD cf (     * *    ? @ !!_A D!D!lbs ea!/TOTAL FOOTING WT!!A DD  !lbs ! =#! wS@ D!! x cy concrete! y!!!!*!*!*!!!!?!!."&%WALL, FOOTING AND ROOF WT LESS UPLIFT-"Y%tADD!DD+ "lbs5"%, RESULT MUST BE POSITIVE TO PREVENT LIFTING""2""""#########.$&%TOTAL long WALL, FOOTING AND ROOF WT.'$4ADD!D $lbs$$$$$$$$$$$$ $!%#% ` SOIL RESISTANCE (passive)% % !%%%%%%%%%%%% %!&WINDWARD WALL TOTAL1&@DDh㈵d?D &lbs,&(#by: velocity squared times .00256).*& B! soil-CF=L* H *(h*1.732(30d)) / 2&&&&&&&&&& &!#'WINDWARD WALL PRESSURE PSF!':MbX9<@ D&D 'psf*' B! 30d wedge shape soil at footing' "'''''''''' '!!(LEEWARD WALL SUCTION PSF<(B/H@&kC8c?DDDD  (psf( aftg L~ ( t@ ( dft((((C((( (!)SIDE WALL SUCTION PSF<)B/H@&kC8c?DDDD  )psf) aftg ht~ ) t@) hcombined))))))B))) )!** bcoeff~ * ?* efriction***** * * *! "+TOTAL ROOF UPLIFT leewardC+;2p U@-kC8c?DDDD D. .+(% LIFT=.5*.00238*VELsquared*SFarea*CL+ ~ + ?+ e ftg count+++++++++ +!%,TOTAL ROOF PRESSURE windward<,2p U@&kC8c?DDDD  ,lbs, asoil wt~ , [@ , dpcf,,,,,, !,!-WINDWARD ROOF PRESSURE!- i@ D,D -PSF- asoil cf6- @t@ D( D) D) ʡE? - dcf--5-*---- "-! .LEEWARD ROOF UPLIFT PSF!.: i@ D+D .PSF7. Q?!D _x6@   B. ctotal wt'. g K<AD- D, D*  . flbs....... ".!////////// "/!0(0LOVERTURNING MOMENT CALCULATIONS0000=04(may be based on representative segment of building)00 0 0 0 M0 !000000 "0!1%1U walls or support columns1111111 Z roof factors1 1 1 [1 !111111A1 1 1 #1!2H2MbX9<@D'2Gwall pressure PSF222  i@D. 2 Guplift roof suction PSF2 (2 "22222*222 2!33$@ D3*= wall height / 236 37= moment arm (centroid)3933 4@ D 3 *= roof span / 2 3 p= moment arm (centroid)3333*333 3!*404Cl5@D2DxDx94'0 = OT coeff = lateral wind psf*(windspd/120)sqrd44804 `@D2 DxDx84 '/uplift suction psf*(windspd/120)sqrd = OT coeff4 I444444*444 4!*5-5V`AD4DDD3)5W = OT coeff * L * W * (centroid)5X5X5X'5Y total OT moment wall 545  eCAAD4 D D D3 D )5 ' = OT coeff * L * W * (centroid)5 qOT moment roof555555*68Mot =6TOTAL OT MOMENT=!6!t/A D5D5 6ft-lbs6 k6 i6 jADDED WALL WEIGHT. = /6 oADD7 D7 D8  6 mlbs666666*787<2p U@D,7roof download windward7 7LL~ 7 l@*7 %! = number of long walls included.'7 @D DD777777*888 TOTAL lbs=(8VUUU"AD6 DD!$89walls, roof and footing lbs8 8$DL~ 8 r@+8 %" = number of short walls included.~ 8 nb@888888*98 9plus9 K<AD. 99ftg / soil resistance9 9$DL9 ~ enter wall count9 { slab depth ft~ 9 A@9  total job conc cy29 FWe@D< D< D; D!9D::equals':]-AD8D9D7 :plus!:ffffA D; D< :$ added conc :$DL: ": ADDED CONCRETE WEIGHT. : ? pad width ft~ : N@:::::;8;Mr = !;Ȅ L3A D:D:;TOTAL RESISTANCE;;$DL+LL3; }@D: D; D< D= D8 ; Gtotal col pad weight; ; ? length ft~ ; N@;;;;;;D<<$ surplus lbs =,<_q AD6D; <=&<K: ?D;D6<$ safety margin<$4< ZAD D D9 D8 D< < $ = slab wt x~ < zP@< ?deep ft~ < Nv@<<<<<<*==KB=J9 surplus value must be positive to prevent overturning= = = = = != AffffA D; D< = |total lbs. added= = total pad count~ = O,@======>>>>>>>*k?bGriffithplans.com has stock plans, custom plans, and free const calculators and const information.@",IA",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"["\"]"^"_"+@"USER HINTS.....OVERTURN CALCULATOR@@@@*TAKMAKE ENTRIES IN YELLOW COLUMNS ONLY. ALL ITEMS IN BOLD BLACK ARE FORMULAS.AAAAAA*bBYALL THE FORMULAS ARE LINKED TO OTHERS. IF YOU CHANGE ONE YOU WILL GET INCORRECT RESULTS.BBBBB9C0This calculator is a little difficult to explain>C5Performs 46 calculations instantly as you enter data.CCCCCkDbThe overturning moment is the moment a windload hits a building with enough force to turn it over.DDDDDDDDDDE|The idea is to design a building that has enough total weight to keep it from overturning in the strongest anticipated wind.EEEEEEEEEEFvAll we have to do is figure out how much force could be exerted on one side of the building and design it accordingly.FFFFFFFFFFG|The idea is to design a building that has enough total weight to keep it from overturning in the strongest anticipated wind.GGGGGGH|First enter the windload data into the (Yellow Spaces only) proper blanks. If you don't have this info leave what's there.HHHHHrIiSecond enter the roof pitch info. (Yellow blanks) You can get the info from the chart on the right side.IIIIIXJOThird, enter all the building data into the proper spaces. (Yellow spaces only)>K5REMEMBER, you can only enter info into Yellow Spaces.aLXFourth, Enter the footing sizes you want in the center of the page (Yellow spaces only.)TMKFifth, enter the footing info into the Soil resistance box. (Yellow spaces)XNOSix, check out the OT MOMENT (brown font) and the TOTAL RESISTANCE (green font)N%N%N%N%N%OOFAs long as the resistance is greater than the OT moment, you are good.O%O%O%O%O%fP]If the numbers aren't right you can add more footing depth. Conc weighs in at 150 lbs per CF.P%P%P%P%P%JQAAlso as footings get deeper you gain more passive soil resistance?R6If you need column pads you can make those deeper too.RRRRRFS=LEAVE ALL THE BOLD PRINT ENTRIES ALONE AS THESE ARE FORMULASS)S)S.SS7T.YOU CAN ONLY MAKE ENTRIES IN THE YELLOW BLANKSTT)T.TTfU]user to take full responsibilty for any errors, loss or damages from use of this spreadsheet.UU)U.UUZVQIF YOU ACCIDENTALLY MESS UP THE FORMULAS YOU CAN GET A NEW COPY FROM OUR WEBSITE.VV)VVV\WSYOU CAN COPY THE MISSING FORMULAS AND PASTE THEM INTO YOUR SPREADSHEET SO YOU DON'TWW)WWWXLOSE YOUR DATA.XX)XXXY)Y)YYYZZ)ZZZ[[)[[[\\\]7]]]]^7^.^^-^__,___(`"ra"b"c"d"e"f"``(```(aa(aaa(bb(bbb(cccccd'dddde$eeee>GGG ) Arial