ࡱ>    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHRoot EntryڂI@Workbook WksSSWorkBook=WksSSChart0.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   @   ` Sheet1$ Print_Area;Q   q  dMbP?_*+%-&?'?(?)?"??M oU } } } m} I} $} } m} } } I} $} q0! U    U4+WEIGHT OF WALLS, FLOORS AND ROOF CALCULATOR version apr 8 2007f<]a FREE DOWNLOAD from griffithplans.com (other calculators are available at griffithplans.com)  pg 1 of 2S  \pMS Works Ba==-8X@"1Arial1Arial1Arial1Arial1Arial1 Arial1 Arial1( Arial Narrow1 Arial1( Arial Narrow1( Arial Narrow1 Arial1  Arial1  Arial1(  Arial Narrow1 Arial1( Arial Narrow1 Arial1 Arial1 Arial1 Arial1@ Copperplate Gothic Light1( Arial Narrow"$"#,##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_);( #,##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]\( #,##HJRead additional instructions before using (available at griffithplans.com)FFFFFFFF F F.H%Enter numbers under yellow cells onlyFFFFFFFF1 P( SEE USER HINTS AT THE BOTTOM OF PAGE. F@=7MAKE NO ENTRIES WHERE FONT IS BOLD. THESE ARE FORMULAS+ JOB NAME:C JBOBS COUNTRY RESTAURANTCCCC. COMPONENT'& /WALL ).ENTER UNIT SIZE'&/ SEGMENT SIZE ) EWALL MATERIALS B1 = YESA ,8MATERIAL THICK inches or decimals of inches no Fractions# %EXPOSED FACE HORIZ INCHES! #EXPOSED FACE VERT INCHES  WT PER CU FT! WT PER UNIT SIZE to left %ENTER LENGTH IN FT $ENTER HT IN FT 6TOTAL UNITS TO BUILD TOTAL SEGMENT WT HOW MANY SEGMENTS 3TOTAL WT PER SEGMENT LOG ~ 4~ @~ (@~ (@~ >A@@  *D D  D  D  D ~ "?~ "0@2 70@D D D D ! ! D D ~ ?! ! D D  HOLLOW CONC BLOCK~ 4?~  @~ 0@~  @~ >T@@  B{ %G@*D D  D  D  D ~ "?~ " @2 7"@D D D D ! !z@ D D ~ ?! !z@ D D   DOWNPOURS *~ 4?~ @~ @~ X@~ >b@@  j@*D D  D  D  D ~ "D@~ "?2 7rh|?D D D D ! !9@ D D ~ ?! !9@ D D   SOLID LINTEL~ 4?~  @~ (@~ 0@~ >b@@  `@*D D  D  D  D ~ "?~ "`@2 7Q?D D D D ! !`@ D D ~ ?! !`@ D D SOLID CONC COLUMN~ 4~ 0@~ 0@~ (@~ >b@@ *DD D D D~ "?~  "`@2 7Q?DD DD! ! DD ~  ?! ! D D SOLID CONC FOOTING~ 4?~ 0@~ (@~ (@~ >b@@ i@*DD D D D~ "?~  "?2 7?DD DD! !i@ DD ~  ?! !i@ D D SOLID CONC WALL~ 4~ (@~ (@~ (@~ >b@@ *DD D D D~ "$@~  "$@2 7Y@DD DD! ! DD ~  ?! ! D D  STEEL COLUMN~ 4~ @~ @~ X@~ >@@ *DD D D D~ "?~  " @2 7?DD DD! ! DD ~  ?! ! D D  STEEL PLATE~ 4~ ?~ (@~ (@~ >@@ *DD D D D~ "4@~  "?2 74@DD DD! ! DD ~  ?! ! D D  STEEL PANELS~ 4V-?~ (@~ (@~ >@@ *DD D D D~ "$@~  "4@2 7i@DD DD! ! DD ~  ?! ! D D PURLINS~ 4~ ?~ (@~ (@~ >@@ *DD D D D~ "4@~  "?2 74@DD DD! ! DD ~  ?! ! D D  WOOD SIDING~ 4?? ?~ (@~ (@~ >B@@ @*DD D D D~ "?~  "$@2 7$@DD DD! !6@ DD ~  ?! !6@ D D WOOD SHEATHING~ 4?~ ?~ (@~ (@~ >A@@ UUUUUU?*DD D D D~ "?~  "$@2 7$@DD DD! !*-@ DD ~  ?! !*-@ D D  WOOD STUDS~ 4?~ @~ @~ (@~ >;@@ ?*DD D D D~ "?~  " @2 7(@DD DD! !2@ DD ~  ?! !2@ D D DRYWALL~ 4?~ ?~ (@~ (@~ >N@@ @*DD D D D~ "?~  "0@2 70@DD DD! !D@ DD ~  ?! !D@ D D WOOD PLANKING INT~ 4~ ?~ @~ ^@~ >A@@ *DD D D D~ "@~  "4@2 70@DD DD! ! DD ~  ?! ! D D WOOD PLANKING EXT~ 5~ @~ (@~ (@~ >A@@ *DD D D D~ "$@~  "$@2 7Y@DD DD! ! DD ~  ?! ! D D   8   . COMPONENT'&/FLOOR ) 8   &ENTER UNIT SIZE'&( SEGMENT SIZE ) 8   EFLOOR MATERIALSB1 = YES7,.MATERIAL THICK inches or decimals no Fractions#%EXPOSED FACE HORIZ INCHES!#EXPOSED FACE VERT INCHES WT PER CU FT!WT PER UNIT SIZE ENTERED%ENTER LENGTH IN FT $ENTER HT IN FT 6TOTAL UNITS TO BUILD TOTAL SEGMENT WT HOW MANY SEGMENTS  TOTAL WT  2X6 T & G~ 4~ @~ ^@~ @~ >A@@ *DD D D D~ "@~  "8@2 7333333#@DD DD! ! DD ~  $@! ! D D   (!"#$%&'()*+,-./U0123456789:;<=>? WOOD SHEATHING~ 4~ ?~ (@~ (@~ >A@@  *D D  D  D  D ~ "@~ "@2 7@D D D D ! ! D D ~ ?! ! D D ! WOOD STUDS~ !4~ !@~ !@~ !(@~ !>;@@! *D!D! D! D! D!~ !"?~ ! " @2! 78@D!D! D!D!!! ! D!D! ~ ! ?!! ! D! D! "DRYWALL CEILING~ "4?~ "?~ "(@~ "(@~ ">N@@" @*D"D" D" D" D"~ ""?~ " "0@2" 70@D"D" D"D"!" !D@ D"D" ~ " ?!" !D@ D" D" #WOOD PLANKING INT~ #4~ #?~ #@~ #^@~ #>A@@# *D#D# D# D# D#~ #"@~ # "4@2# 70@D#D# D#D#!# ! D#D# ~ # ?!# ! D# D# $5/8" WOOD PANELS~ $4~ $?~ $X@~ $H@~ $>A@@$ *D$D$ D$ D$ D$~ $"$@~ $ "$@2$ 7 @D$D$ D$D$!$ ! D$D$ ~ $ ?!$ ! D$ D$ %3/4" WOOD PANELS~ %4?%? ?~ %(@~ %(@~ %>A@@% @*D%D% D% D% D%~ %" @~ % "?2% 7 @D%D% D%D%!% !1@ D%D% ~ % ?!% !1@ D% D% &2X4 FLOOR TRUSSES~ &4?~ &@~ &(@~ &8@~ &>2@@& (@*D&D& D& D& D&~ &"D@~ & "$@2& 7@D&D& D&D&!& !8@ D&D& ~ & ?!& !8@ D& D&  'TILE~ '4?~ 'P@~ '(@~ '(@~ '>^@@' ffffff@*D'D' D' D' D'~ '"?~ ' "@2' 7@D'D' D'D'!' !@@ D'D' ~ ' ?!' !@@ D' D' (2X4 WOOD FLOOR JOISTS~ (4~ (@~ (@~ (b@~ (>A@@( *D(D( D( D( D(~ ("@@~ ( "(@2( 7Gz?D(D( D(D(!( ! D(D( ~ ( ?!( ! D( D( )2X6 WOOD FLOOR JOISTS~ )4~ )@~ )8@~ )X@~ )>A@@) *D)D) D) D) D)~ )" @~ ) "?2) 7?D)D) D)D)!) ! D)D) ~ ) ?!) ! D) D) *040 PSF LIVE LOAD~ *4?~ *(@~ *(@~ *(@~ *>D@@* D@*D*D* D* D* D*~ *"?~ * " @2* 7 @D*D* D*D*!* !t@ D*D* ~ * ?!* !t@ D* D* ++@+@+@+@+?+@+ @+ 9,,@,@,@,@,@,@, @, @--@-A COMPONENT-'-& -/ROOF- )- @-  pg 2 of 2.&ENTER UNIT SIZE.'.&...( SEGMENT SIZE. ). 8. . . /EROOF MATERIALS/B1 = YES7/,.MATERIAL THICK inches or decimals no Fractions#/%EXPOSED FACE HORIZ INCHES!/#EXPOSED FACE VERT INCHES/ WT PER CU FT!/WT PER UNIT SIZE ENTERED/%ENTER LENGTH IN FT/ $ENTER HT IN FT/ 6TOTAL UNITS TO BUILD/ TOTAL SEGMENT WT/ HOW MANY SEGMENTS/  TOTAL WT 0 2X6 T & G~ 04?~ 0@~ 0^@~ 0@~ 0>A@@0 *=@*D0D0 D0 D0 D0~ 0@~ 0 8@20 7333333#@D0D0 D0D0!0 !q@ D0D0 ~ 0 $@!0 !@ D0 D0 1 1 X 6 T& G~ 14~ 1?~ 1^@~ 1@~ 1>A@@1 *D1D1 D1 D1 D1~ 1$@~ 1 $@21 74@D1D1 D1D1!1 ! D1D1 ~ 1 ?!1 ! D1 D1 2 50LB SHINGLES~ 24~ 2"?~ 2(@~ 2(@~ 2>I@@2 *D2D2 D2 D2 D2~ 2$@~ 2 $@22 7Y@D2D2 D2D2!2 ! D2D2 ~ 2 ?!2 ! D2 D2 3METAL ROOF PANEL~ 34?3X9v?~ 3(@~ 3(@~ 3>@@3 \<@*D3D3 D3 D3 D3~ 3?~ 3 (@23 7(@D3D3 D3D3!3 ! cZ>@ D3D3 ~ 3 ?!3 ! cZ>@ D3 D3  4TILE~ 44~ 4P@~ 4(@~ 4(@~ 4>^@@4 *D4D4 D4 D4 D4~ 4$@~ 4 $@24 7Y@D4D4 D4D4!4 ! D4D4 ~ 4 ?!4 ! D4 D4 5 LIGHT WT TILE~ 54~ 5P@~ 5(@~ 5(@~ 5>Q@@5 *D5D5 D5 D5 D5~ 5$@~ 5 $@25 7Y@D5D5 D5D5!5 ! D5D5 ~ 5 ?!5 ! D5 D5 6 CEDAR SHAKES~ 64~ 6?~ 6(@~ 6(@~ 6>;@@6 *D6D6 D6 D6 D6~ 6$@~ 6 $@26 7Y@D6D6 D6D6!6 ! D6D6 ~ 6 ?!6 ! D6 D6 74' INSULATING PANELS~ 74~ 7@~ 7(@~ 7(@~ 7>@P@@7 *D7D7 D7 D7 D7~ 7$@~ 7 $@27 7Y@D7D7 D7D7!7 ! D7D7 ~ 7 ?!7 ! D7 D7 86" INSULATING PANELS~ 84~ 8@~ 8(@~ 8(@~ 8>@P@@8 *D8D8 D8 D8 D8~ 8$@~ 8 $@28 7Y@D8D8 D8D8!8 ! D8D8 ~ 8 ?!8 ! D8 D8 91/2" WOOD PANELS~ 94?~ 9?~ 9(@~ 9(@~ 9>A@@9 UUUUUU?*D9D9 D9 D9 D9~ 9?~ 9 (@29 7(@D9D9 D9D9!9 !1@ D9D9 ~ 9 ?!9 !1@ D9 D9 :5/8" WOOD PANELS~ :4~ :?~ :X@~ :H@~ :>A@@: *D:D: D: D: D:~ :$@~ : $@2: 7 @D:D: D:D:!: ! D:D: ~ : ?!: ! D: D: ;3/4" WOOD PANELS~ ;4;? ?~ ;X@~ ;H@~ ;>A@@; *D;D; D; D; D;~ ;@~ ; 4@2; 7?D;D; D;D;!; ! D;D; ~ ; ?!; ! D; D; <2X4 WOOD TRUSSES~ <4?~ <@~ <H@~ <8@~ <>,@@< B@*D<D< D< D< D<~ <?~ < (@2< 7?D<D< D<D<!< !K@ D<D< ~ < ?!< !K@ D< D< =SOLID WOOD BEAM~ =4~ =@~ =H@~ =8@~ =>B@@= *D=D= D= D= D=~ =@~ = @2= 7?D=D= D=D=!= ! D=D= ~ = ?!= ! D= D= >WOOD SHEATHING~ >4~ >?~ >X@~ >H@~ >>A@@> *D>D> D> D> D>~ >$@~ > $@2> 7 @D>D> D>D>!> ! D>D> ~ > ?!> ! D> D> ?90 LB ROLL ROOFING~ ?4?~ ??~ ?(@~ ?(@~ ?>>@@? ?*D?D? D? D? D?~ ?@~ ? 8@2? 7H@D?D? D?D?!? !@ D?D? ~ ? ?!? !@ D? D? @iABCDEFGHIJKLMNOQRSTUVWXYZ[\]^_`@FURRING STRIPS~ @4~ @?~ @@~ @X@~ @>A@@@ *D@D@ D@ D@ D@@sh|??~ @  @2@ 7Zd;?D@D@ D@D@!@ ! D@D@ ~ @ ?!@ ! D@ D@ A2X4 WOOD ROOF RAFTERS~ A4~ A@~ A@~ Ab@~ A>A@@A *DADA DA DA DA~ A@@~ A (@2A 7Gz?DADA DADA!A ! DADA ~ A ?!A ! DA DA B2X6 WOOD ROOF RAFTERS~ B4~ B@~ B@~ Bb@~ B>A@@B *DBDB DB DB DB~ BV@~ B $@2B 7?DBDB DBDB!B ! DBDB ~ B ?!B ! DB DB C10X10 RAM LOGS~ C4~ C(@~ C(@~ C(@~ C>A@@C *DCDC DC DC DC~ C?~ C 4@2C 74@DCDC DCDC!C ! DCDC ~ C ?!C ! DC DC DDDDDDD D D EEE+E@EEE E +COMBINED LOADS WEIGH#E (~먚@ % C B E LBSE .F+%APPROX (assumed) SOIL BEARING PSF IS~ F-@@F +WEIGHT PER LIN FT ISF (~먚@DE  F LBS'G +MIN FOOTING WIDTH ALLOWABLE IS+G 9;a?DF DF333333?G FT orG :ؑ(@ DG  HCHCHCHCHCHCHCHCHCH CH CH CUH DLNOTE: MOST BUILDING CODES REQUIRE A MINIMUM OF 12" WIDE FOOTINGS FOR HOUSES.H ;inches=I +4SOIL BEARING (above) LESS WALL, FLOOR & ROOF WEIGHT=!I 1`Q\r@ DFDF  I LBS.'JEXISTING FOOTING CALCULATIONS:J + SAFETY MARGIN&J 2[?DF DF~ K-0@5K0,INCHES enter existing footing width if known!Lk @ DKDG IL0@inches difference from calculated min footing width and existing&L +COMBINED SEGMENTS WEIGH (LBS)#L !c:@ % C B)MUUUUUդ@DK DF2M0)pounds allowable load on existing footing!NY<}@ DMDF 9N00allowable load less calc wall floor roof weight. N JOB:N EDBOBS COUNTRY RESTAURANT&O2RBU ?DF DMEO0<safety margin for existing footing (MUST BE POSITIVE NUMBER)kQ<bGriffithplans.com has stock plans, custom plans, and free const calculators and const information.2RI)USER HINTS.....BUILDING WEIGHT CALCULATORTSIKMAKE ENTRIES IN YELLOW COLUMNS ONLY. ALL ITEMS IN BOLD BLACK ARE FORMULAS.bTFYALL THE FORMULAS ARE LINKED TO OTHERS. IF YOU CHANGE ONE YOU WILL GET INCORRECT RESULTS.}UNtCalculate building weights based on many types of structures and sizes. You can separate wall weights, roof weights,iVF`and floor weights or add them all together. Over 51 weights of building materials are included.VFVFVFVFVF^WKUYou can calculate almost any wall floor or roof segment weights with this calculator.WFWFWFWFWFXvYou can pick the components that go into the structure and get unit weight, segment weight and total structure weight.YFYFYF?YG6Performs 214 calculations instantly as you enter data.YKYFZO Definitions:ZOZOZOZOZOZOZOZOZ FZ FZ FQ[OHUnits- Are individual items like a concrete block or a piece of plywood.[O[O[O[O[O[O[O[O[ F[ F[ FI\O@Components-Are a list of units that are a part of the structure.\O\O\O\O\O\O\O\O\ F\ F\ Ft]OkSegments-Are the combined units that make up a portion of the structure. A frame wall segment 20'x8' would]O]O]O]F]F]F]F]F] F] F] FO^OFcontain 5 pieces of 4x8 plywood (units). 22 2x4 studs (units) etc.^O^O^O^F^F^F^F^F^ F^ F^ F_O_O_O_O_F_F_F_F_F_ F_ F_ FF`F=Select any material by entering a 1 in the YES (Yellow blank)`O`O`O`F`F`F`F`F` F` F` FabcdefghijklmnopMaFDLeave the component sizes alone unless you are using some odd sizes.aOaOaOaFaFaFaFaFa Fa Fa FhbO_Enter the segment size to match the part of the structure you are interested in. (Yellow blank)bObObObFbFbFbFbFb Fb Fb F?cF6enter the number of segments you need (Yellow blank). cOcOcOcFcFcFcFcFc Fc Fc FmdFdThe wall segment length, roof length, and floor length is often the same. (depends on structure tho)dOdOdOdFdFdFdFdFd Fd Fd FaeOXRecheck the Yes column to make sure only the items you select have a 1 in front of them.eFeFeFeFeFeFeFeFe Fe Fe FefO\Your total loads and footing size (based on soil bearing) will be at the bottom of the page.fFfFfFfFfFfFfFfFf Ff Ff FFgF=LEAVE ALL THE BOLD PRINT ENTRIES ALONE AS THESE ARE FORMULASgFgFgFgFgFgFgFgFg Fg Fg F7hH.YOU CAN ONLY MAKE ENTRIES IN THE YELLOW BLANKSNiFEleave the soil bearing at 2000 lbs PSF unless you know it to be less.RjNI(loose, sandy, muddy, or disturbed soil could be much less.) so find out.fkM]user to take full responsibilty for any errors, loss or damages from use of this spreadsheet.ZlLQIF YOU ACCIDENTALLY MESS UP THE FORMULAS YOU CAN GET A NEW COPY FROM OUR WEBSITE.\mLSYOU CAN COPY THE MISSING FORMULAS AND PASTE THEM INTO YOUR SPREADSHEET SO YOU DON'TnLLOSE YOUR DATA.oKpK>ggg ) Arial