ࡱ>    !"#$%&'()*+,-./0123456789:;<=>?@ABCDRoot EntryK)~{E@Workbook ݃WksSSWorkBook=WksSSChart?/???) #,##0_);( #,##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       @@ @@#@     #@  @     @ !"@ @  "  \pMS Works Ba==-8X@"1Arial1Arial1Arial1Arial1Arial1 Arial1 Arial1 Arial1 Arial1 Arial1 Arial1( Arial Narrow1( Arial Narrow1( Arial Narrow1( Arial Narrow1( Arial Narrow1 Arial1 Arial1( Arial Narrow1(  Arial Narrow1 Arial1( Arial Narrow1( Arial Narrow1 Arial1 Arial1( Arial Narrow1(  Arial Narrow1 Arial1(  Arial Narrow1  Arial1( Arial Narrow1( Arial Narrow1  Arial1 Arial1 Arial1 Arial1 Arial1 Arial1 Arial1@ Copperplate Gothic Light"$"#,##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\) #\ ?@  #      "D  D  D "PP !P@ !P !P @#@@#@ @D @@        @" # $ % & ' ! # % & ' ( @  `&Sheet1$ Print_Area;:   ^  dMbP?_*+%&333333?'333333?(333333?)333333?"??M oU } $} } $}  } } }  } I} } } } $} $} ^!!Pd*@!!!!!!!! ! ! ! ! !!!!!!!!!!!!!!!!!!!     X2)LOG WALL FOOTING & anchor bolt CALCULATORPROJECT 2 STORY LOG CABIN "!;ANCHOR BOLT CALCULATIONSG>MAKE ENTRIES IN YELLOW BLANKS ONLY BOLD ENTRIES ARE FORMULAS!]Ta FREE DOWNLOAD from griffithplans.com (other calculators FREE at griffithplans.com). %MAKE ENTRIES IN YELLOW BLANKS ONLY  "~ @p@CONC STRENGTH PSI"&& leading edge is low-pointSJRead additional instructions before using (available at griffithplans.com)#  BOLD ENTRIES ARE FORMULAS "~ @@"ANCHOR YIELD STRENGTH PSI%aA@D D )5 cone cross section area in sq in56"$INFO FROM FOIL SIM ADVANCED$& roof is open underneath DEADLOADS * 15% safety factor WINDLOADS  , 15% safety factor "556"3*used for footing and column pad calcs only3*used for footing and column pad calcs only "x!@D8 *y!TOTAL BOLT LENGTH REQUIRED inches"F100 MPHF125 MPH F130 MPHh WALL SEGMENTS!h ROOF SEGMENTS!nLATERAL WINDLOAD ! h ROOF WINDLOAD ! "P?D4BOLT DIAa? D5 bolt radius'bPERT!?DDD6 bolt sq in`"ROOF UPLIFT TABLESY windward roofY windward roof Y windward roofi WALL 1 LOGS"iROOF 1"iWALL 1 " iROOF 1 " "Q@D4  EMBED LENGTH"Z roof pitchZdegrees[tangent[radians) downloads) downloads ) downloadsHEIGHT~ j2@HEIGHT~ j4@HEIGHT~  j4@ HEIGHT~  j4@ "%A"@D?+"FREE EDGE DIST use 1.5 times embed`PERT! @ =pi"\LBS PSF\LBS PSF \LBS PSF  WIDTH~ j4@ WIDTH~ j4@  WIDTH~ j4@ WIDTH~ j4@ " Blv @D A SLANT HEIGHT of cone . aR@DDDD! 9hyp=SQ RT OF side1+side2 5 6 "~ ] @ ^a @ ZuOU?~ F*@~ F5@~ F6@  WT PSF~ j<@ WT PSF~ j9@   WLOAD PSF~ jګ@  WLOAD PSF~ j@ "& B[hf=Mm@D D  CONE SURFACE AREA # %area of cone=PI*R*SLANT HT  "~ ]@ Z6r"@ ZKqU?~ F:@~ FD@~ FF@  SF! kv@ DD  SF! ky@ DD   SF! ky@ D D  SF! ky@ D D  "' Bܾ:F\@DDD  CIRCLE AREAV DMpi=3.141592654ratio of the circumf to the dia (C/d)=3.14 of circle.22 / 7 =pi "~ ]@ Z,@~ Z?~ FC@~ FN@~ FP@   TOTAL LBS.! l@ D D   TOTAL LBS.! l@ D D    TOTAL LBS.! l@ D D   TOTAL LBS.! l@ D D  " B    "~ ]`@ Zk6j2@ ZZd;O?~ FI@~ FT@~ FU@   "  "   "  " " ALLOWABLE TENSILE LOAD    >    "~ ] @ Z7r6@ ZB[Υ?~ F`@~ FU@~ F@W@iWALL 2 basement"i1ST & 2ND FLOOR"iWALL 2 " iROOF 2 " "5<>ҫ7Dj@?D DAD/&1.ALLOWABLE LOAD psi (based on anchor)"UEL formula=.5*(cone surface area)*sq rt(bolt dia*anchr yield strength psi.) "~ ]@Z1:@~ Z?HEIGHT~ j @HEIGHT~ jD@HEIGHT~  j HEIGHT~  j "<"Tresult above / ~ $^@dfor close spacingdpull-out factor~ ]@ZťA>@Z_?WIDTH~ j4@WIDTH~ j4@WIDTH~  j WIDTH~  j "=N"dc~ ]@^Uz@@ZioT?WT PSF~ jb@WT PSF~ j>@ WLOAD PSF~  j  WLOAD PSF~  j ":<@$D?DDD2)2.ALLOWABLE LOAD psi (based on conc psi)"IC@ formula=bolt dia times .02 *(cone cross sec*conc strength psi)"~ ]@^8oXoB@~ Z? SF!kd@ DD SF!k@ DD SF! k D D   SF! k D D  ":   #Tresult above / U333333?Ddfor close spacingcpull-out factor~ ]@ @^ՎC@Z_? TOTAL LBS.!mp@ DD TOTAL LBS.!mp@ DD TOTAL LBS.! m D D   TOTAL LBS.! m D D  "dc~ ] @^HVAE@Z-R\U? "~ ?@(inches ACTUAL DIST TO CONC EDGE!"~ ]@~ ^F@~ Z?%  TOTAL LATERAL WINDLOAD% @D D B "<3 value below cannot exceed allowable load 2 above""o COLUMN PAD!oFOOTING ! TOTAL ROOF WINDLOAD"  D D  ".: @DDDD@}7ADJUSTED LOAD psf ( based on conc psi & edge distance)  #IC@ formula=PSF load*(actual edge dist divided by free edge dist.)"DEPTH ft~ jDEPTH ft~ j?-FOOTING SOIL BEARING  ! "Tresult above / U333333?Ddfor close spacingcpull-out factorWIDTH ft~ jWIDTH ft~ j@4S@D DDD D * wall roof PSF "~  @@  PSF "<3 value below cannot exceed allowable load 1 abovec LENGTH ft~ j LENGTH ft~ j4@(zb@DDD Y footing PSF "! enter soil bearing above "!8bc^@ DDK9Bactual bolt strength based on size = (bolt sq in*anchor yield psi)55_6" WT per cf~ j WT per cf~ jb@!|ī@ DD , TOTAL LBS PSF% lR5@DD   inches "       #p totalCF conc'kDDDp totalCF conc'qD@DDD(. equals a safety margin of !  min.ftg width required  "TOTAL WT!m DDTOTAL WT!rp@ DD({k@D DD  PSF  8@ D  inches "   footing design given  "0COLUMN SOIL BEARING! "1QB@ D&1%(SF MIN COL PAD for 2000psf soil bearing.".;%(ASTM A 307 Bolt Tightening Criteria)    ! " !a!!"!#!$!%!&!'!(!)!*!+!,!-!.!/!0!1!2!3!4!;5!6!7!8!9!:!;!P@<!=!>!?! ! 2 DD 3SF DESIGNED PAD SIZE     #  4diameter Ftorque3 G*initially tighten bolts to achieve mating. " "    !!~ !H@~ ! F.@-! G$Final Tighten Bolts measuring Torque! "! "!!!!!!!"""""tWALL WEIGHT LBS%"u@D DB"~ "H@~ " FB@*" G!Conc strength achieved in 28 days" "" """"###ROOF WEIGHT LBS%#v@D DB#~ #H@%@~ # FR@# "# "######$$$COLUMN PAD WEIGHT LBS$vD$~ $H @~ $ F^@$ "$ "$$$$$$%%%FOOTING WEIGHT LBS%wp@D%~ %H,@~ % Fg@% "% "%%%%%%&&& & "&~TOTAL DEADLOAD WEIGHT LBS#&@ %"%B&~ &4?~ & F0q@& "& "&&&&&&'''~ 'I?~ ' Fpw@' "' "''''''(!(DEADLOAD LESS UPLIFT LBS!(f@ D&D (~ (J?~ ( Kh@( ( ( #( "((())3)*result must be positive to prevent lifting)) ")))**=*O4 LOWEST amount is tension & shear allowance per bolt* M* * * * !***++"+e embedded bolt allowance+ G#+ RTension + Shear safety amt+ "+++,#,NUMBER OF COLUMNS IN CALCS~ ,,,fbc^@D, smax bolt strength(, /@D,D.D/, C bolt strength, ",,,-#-BOLT COUNT PER WALL LENGTH~ -&@--f>ҫ7Dj@D- C anchor load(- @O@D-D.D/- C anchor load- "---.%.tension LOAD NEEDED PER BOLT,..袃@D D- .%LBS..f@D. C conc strength(. ]tE@D.D.D/. C conc strength. "...//SHEAR NEEDED PER BOLT"/E]tA@ D D- /%LBS//f @D/ C edge dist(/ &l@D/D.D// C edge dist/ "00 0 0 0 0 0 090V0values above must be positive to prevent failure0 L0 0 0 0 #A1,8BOLTS SELECTED EXCEED REQUIREMENTS OF FBC 1912 AND 1913.22)ANCHOR BOLT INFORMATION for footing boltsE2%<Bolts shall conform to ASTM A 307 or an approved equivalent.n3e Griffithplans.com has stock plans, custom plans, free const calculators and const references3&3&3&3&3&3&3 &3 &3 &3 Winches44'4&4(REQUIRED BOLT DIAMETER~ 4? 4&in4&4&4 &4 &-4 ($MINIMUM EMBEDMENT in inches (12 dia)~ 4 g@5&5&5&5&55&5&5&5 &5 &5 &6&6&6&$6(THREADED PORTION ABOVE CONC~ 6$@ 6&in6&6&6 &6 &26 +) IDEAL MIN DIST FROM CONC EDGE 1.5xshank%6 7"@D4 ?7&7&7&7&7)7&7&7&7 &7 &7 &M8&DNOTE: Locate all anchor bolts with templates before pouring concrete8&8&8&8&8&8&8&8 &8 &*8 (!TOTAL BOLT LENGTH REQUIRED inches!8 /!@ D4 D6O9&Fuse ASTM A 307 bolts or approved equiv. The use of lower rated bolts9&9&9&9&9&9&9&9 &9 &69 +-conc cover from bolt bottom to FOOTING bottom&9 /@D D4 C:&:could result in building collapse in high wind conditions.:&:&:&:&:&:&:&: &: &9: +0conc cover from bolt bottom to COLUMN PAD bottom&: /D D4 ;;;;;;;;;; ; ; ; ; <C=:USER HINTS.....LOG WALL FOOTING and anchor bolt calculator======== = T>KMAKE ENTRIES IN YELLOW COLUMNS ONLY. ALL ITEMS IN BOLD BLACK ARE FORMULAS.>>>>>>>>> > b?YALL THE FORMULAS ARE LINKED TO OTHERS. IF YOU CHANGE ONE YOU WILL GET INCORRECT RESULTS.????????? ? @!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![!\!]!@~Calculates weights of log walls based on height and length. Uses log wall & basement wall weight to calculate footing sizes. @oAfAlso calculates weight of solid concrete basement walls. Also calculates bolt embedment and strength. AA B User inputs wall sizesBBsoil bearing psf etc.BCCPCGThis calculator performs 68 calculations instantly as user inputs data.CCCCCCC C @D7First, enter the wall data into the Yellow spaces only.DDDDDDDDD D EE<Second, enter the windload data into the Yellow spaces only.EEEEEEEEE E RFILeave the windloading info alone if you can't get your local windloading.FFFFFFFFF F gG^You can obtain the PSF wall and roof windloading based on the highest windspeed for your area.GGGGGGGGG G kHbWindward means the side facing the wind. This is where the main force is applied to the building.HHHHH_IVWe do not include the side walls because the most force is on the main (longest) wall.IIIIIIIII I xJoThird, enter the column pad and footing info. Only enter the footings that are a part of the wall system aboveJJJJJJJJJ J oKfYou can enter column pad sizes and footing sizes (in Yellow blanks) to determine the best size to use.KKKKKKKKK K xLoSome building designs carry most of the weight on columns and that is what the column pad sizes should reflect.LLLLLLLLL L aMXOnly use the column pads if they are the main bearing points for the wall you are using.MMMMMMMMM M NwEntering the number of columns (in Yellow blanks) in the building segment will give you an approximate load per column.NNNNNOwIf most of your wall weight and windloading is carried by the footings then leave the column pads blank and vice versa.OOOOOTPKYou can include both columns and pads if they both carry substantial loads.PPPPPvQmThe number of bolts per column or wall segment (in Yellow blanks) will affect the bolt sizing calculations. QQQQQ REnter the right amount.RRRRRpSgEnter the bolt distance from the edge of concrete (in Yellow blanks) on page 2. the closer to the edgeSSSSSS+T"the weaker the connection becomes.TTTTTTTTT T uUlIn general, shallow and close to edge bolts will pull-out of concrete before the properly sized bolt breaks.UUUUUUUUU U iV`properly sized bolts that are deeper and farther from the edge provide the strongest connection.VVVVVVVVV V eW\This spreadsheet calculates bolt pull-out based on both concrete strength and bolt strength.WWWWWfX]user to take full responsibilty for any errors, loss or damages from use of this spreadsheet.ZYQIF YOU ACCIDENTALLY MESS UP THE FORMULAS YOU CAN GET A NEW COPY FROM OUR WEBSITE.YYY\ZSYOU CAN COPY THE MISSING FORMULAS AND PASTE THEM INTO YOUR SPREADSHEET SO YOU DON'TZZZ[LOSE YOUR DATA.[[[f\]a FREE DOWNLOAD from griffithplans.com (other calculators are available at griffithplans.com)\n]e Griffithplans.com has stock plans, custom plans, free const calculators and const references]>VVV ) Arial