| STRUCTURE LAYOUT DATA | VARIABLE SHEET MARK | UNITS | mm | in | ||||||||
| in | ||||||||||||
| PAY ITEM #: | Θ | |||||||||||
| SIGN #: | Θ | |||||||||||
| JOB #: | Θ | |||||||||||
| PANEL VARIABLES | TRUSS SPAN | A | 81.25[1] | =IF(D2="mm",D6*39.37,D6*12) | ||||||||
| NUMBER OF PANELS | D | 11 | ||||||||||
| CAMBER | K | 2 | =IF(D2="mm",D8*0.03937,D8) | |||||||||
| AMOUNT OF CHORD PAST PANEL POINT ON REAR CHORD | GC | 16 | =IF(D2="mm",D9*0.03937,D9) | |||||||||
| CHORD VARIABLES | CHORD DIAMETER | F | 5.56 | =IF(D2="mm",D10*0.03937,D10) | ||||||||
| WALL THICKNESS | F | 0.375 | =IF(D2="mm",D11*0.03937,D11) | |||||||||
| CHORD SEPERATION | E | 69 | =IF(D2="mm",D12*0.03937,D12) | |||||||||
| CHORD HEAD PLATE VARIABLES | HEAD PLATE THICKNESS | 0.5 | =IF(D2="mm",D13*0.03937,D13) | |||||||||
| RIGHT HEAD PLATE BOLT DIAMETER | RA | 0.875 | =IF(D2="mm",D14*0.03937,D14) | |||||||||
| RIGHT HEAD PLATE BOLT QUANTITY | RB | 4 | =D15/2 | =ISEVEN(E15) | ||||||||
| RIGHT HEAD PLATE WELD SIZE | RG | 0.3125 | =IF(D2="mm",D16*0.03937,D16) | |||||||||
| LEFT HEAD PLATE BOLT DIAMETER | LA | 0.875 | =IF(D2="mm",D17*0.03937,D17) | |||||||||
| LEFT HEAD PLATE BOLT QUANTITY | LB | 4 | =D18/2 | =ISEVEN(E18) | ||||||||
| LEFT HEAD PLATE WELD SIZE | LG | 0.1875 | =IF(D2="mm",D19*0.03937,D19) | |||||||||
| RIGHT COLUMN VARIABLES | ||||||||||||
| COLUMN VARIABLES | "C" DIMENSION FROM BASE PLATE TO CENTER OF TRUSS | C | 25.5[2] | =IF(D2="mm",D21*39.37,D21*12) | ||||||||
| COLUMN DIAMETER | J | 20 | =IF(D2="mm",D22*0.03937,D22) | |||||||||
| WALL THICKNESS | J | 0.5 | =IF(D2="mm",D23*0.03937,D23) | |||||||||
| COLUMN HEAD PLATE VARIABLES | HEAD PLATE THICKNESS | RC | 0.5 | =IF(D2="mm",D24*0.03937,D24) | ||||||||
| HEAD PLATE GUSSET THICKNESS | RD | 0.5 | =IF(D2="mm",D25*0.03937,D25) | |||||||||
| WELD SIZE | RH | 0.1875 | =IF(D2="mm",D26*0.03937,D26) | |||||||||
| WELD SIZE | RE | 0.1875 | =IF(D2="mm",D27*0.03937,D27) | |||||||||
| WELD SIZE | RF | 0.1875 | =IF(D2="mm",D28*0.03937,D28) | |||||||||
| BASE PLATE VARIABLES | BASE PLATE THICKNESS | CC | 1.5 | =IF(D2="mm",D29*0.03937,D29) | ||||||||
| WELD SIZE | CF | 0.3125 | =IF(D2="mm",D30*0.03937,D30) | |||||||||
| WELD SIZE | CG | =D30 | =IF(D2="mm",D31*0.03937,D31) | |||||||||
| BASE PLATE GUSSET VARIABLES | BASE PLATE GUSSET THICKNESS | CD | 0.375 | =IF(D2="mm",D32*0.03937,D32) | ||||||||
| BASE PLATE GUSSET HEIGHT | CE | 18 | =IF(D2="mm",D33*0.03937,D33) | |||||||||
| WELD SIZE | CH | 0.3125 | =IF(D2="mm",D34*0.03937,D34) | |||||||||
| WELD SIZE | CJ | 0.1875 | =IF(D2="mm",D35*0.03937,D35) | |||||||||
| ANCHOR BOLT VARIABLES | ANCHOR BOLT QUANTITY | CB | 12 | |||||||||
| ANCHOR BOLT DIAMETER | CA | 1.75 | =IF(D2="mm",D37*0.03937,D37) | |||||||||
| ANCHOR BOLT LENGTH | FE | 67 | =IF(D2="mm",D38*0.03937,D38) | |||||||||
| LEFT COLUMN VARIABLES | ||||||||||||
| COLUMN VARIABLES | "B" DIMENSION FROM BASE PLATE TO CENTER OF TRUSS | B | 27.5[3] | =IF(D2="mm",D40*39.37,D40*12) | ||||||||
| COLUMN DIAMETER | H | 20 | =IF(D2="mm",D41*0.03937,D41) | |||||||||
| WALL THICKNESS | H | 0.5 | =IF(D2="mm",D42*0.03937,D42) | |||||||||
| COLUMN HEAD PLATE VARIABLES | HEAD PLATE THICKNESS | LC | 0.5 | =IF(D2="mm",D43*0.03937,D43) | ||||||||
| HEAD PLATE GUSSET THICKNESS | LD | 0.5 | =IF(D2="mm",D44*0.03937,D44) | |||||||||
| WELD SIZE | LH | 0.1875 | =IF(D2="mm",D45*0.03937,D45) | |||||||||
| WELD SIZE | LE | 0.1875 | =IF(D2="mm",D46*0.03937,D46) | |||||||||
| WELD SIZE | LF | 0.1875 | =IF(D2="mm",D47*0.03937,D47) | |||||||||
| BASE PLATE VARIABLES | BASE PLATE THICKNESS | BC | 1.25 | =IF(D2="mm",D48*0.03937,D48) | ||||||||
| WELD SIZE | BF | 0.3125 | =IF(D2="mm",D49*0.03937,D49) | |||||||||
| WELD SIZE | BG | =D49 | =IF(D2="mm",D50*0.03937,D50) | |||||||||
| BASE PLATE GUSSET VARIABLES | BASE PLATE GUSSET THICKNESS | BD | 0.375 | =IF(D2="mm",D51*0.03937,D51) | ||||||||
| BASE PLATE GUSSET HEIGHT | BE | 18 | =IF(D2="mm",D52*0.03937,D52) | |||||||||
| WELD SIZE | BH | 0.3125 | =IF(D2="mm",D53*0.03937,D53) | |||||||||
| WELD SIZE | BJ | 0.1875 | =IF(D2="mm",D54*0.03937,D54) | |||||||||
| ANCHOR BOLT VARIABLES | ANCHOR BOLT QUANTITY | BB | 12 | |||||||||
| ANCHOR BOLT DIAMETER | BA | 1.75 | =IF(D2="mm",D56*0.03937,D56) | |||||||||
| ANCHOR BOLT LENGTH | DE | 67 | =IF(D2="mm",D57*0.03937,D57) | |||||||||
| WEB PLATES & ANGLE VARIABLES | ||||||||||||
| WEB PLATE VARIABLES | WEB PLATE THICKNESS | GA | 0.375 | =IF(D2="mm",D59*0.03937,D59) | ||||||||
| WELD SIZE | GL | 0.1875 | =IF(D2="mm",D60*0.03937,D60) | |||||||||
| pn PLATE | HEIGHT | GD | 6.75 | =IF(D2="mm",D61*0.03937,D61) | ||||||||
| LENGTH | GC | 13 | =IF(D2="mm",D62*0.03937,D62) | |||||||||
| ph PLATE | HEIGHT | GD | =D61 | =IF(D2="mm",D63*0.03937,D63) | ||||||||
| LENGTH | GC | =D62 | =IF(D2="mm",D64*0.03937,D64) | |||||||||
| pp PLATE | HEIGHT | GF | 6.25 | =IF(D2="mm",D65*0.03937,D65) | ||||||||
| LENGTH | GE | 13.25 | =IF(D2="mm",D66*0.03937,D66) | |||||||||
| pb PLATE | HEIGHT | GF | =D65 | =IF(D2="mm",D67*0.03937,D67) | ||||||||
| LENGTH | GE | 13.25 | =IF(D2="mm",D68*0.03937,D68) | |||||||||
| pk PLATE | HEIGHT | GJ | 7.25 | =IF(D2="mm",D69*0.03937,D69) | ||||||||
| LENGTH | GH | 6.25 | =IF(D2="mm",D70*0.03937,D70) | |||||||||
| pd PLATE | HEIGHT | GF | =D65 | =IF(D2="mm",D71*0.03937,D71) | ||||||||
| LENGTH | GK | 7.75 | =IF(D2="mm",D72*0.03937,D72) | |||||||||
| pa PLATE | HEIGHT | GF | =D65 | =IF(D2="mm",D73*0.03937,D73) | ||||||||
| LENGTH | 6 | =IF(D2="mm",D74*0.03937,D74) | ||||||||||
| pr PLATE | HEIGHT | GF | =D65 | =IF(D2="mm",D75*0.03937,D75) | ||||||||
| LENGTH | GG | 16.75 | =IF(D2="mm",D76*0.03937,D76) | |||||||||
| WEB ANGLE VARIABLES | ANGLE WIDTH | G | 3 | =IF(D2="mm",D77*0.03937,D77) | ||||||||
| ANGLE THICKNESS | G | 0.25 | =IF(D2="mm",D78*0.03937,D78) | |||||||||
| BOLT DIAMETER | GB | 0.75 | =IF(D2="mm",D79*0.03937,D79) | |||||||||
| SPLICE FLANGE VARIABLES | ||||||||||||
| SPLICE FLANGE VARIBLES | SPLICE FLANGE O.D. | PB | 2 | =IF(D2="mm",D81*0.03937,D81) | ||||||||
| SPLICE FLANGE THICKNESS | PA | 1.375 | =IF(D2="mm",D82*0.03937,D82) | |||||||||
| SPLICE BOLT QUANTITY | PF | 9 | ||||||||||
| SPLICE BOLT DIAMETER | PE | 1 | =IF(D2="mm",D84*0.03937,D84) | |||||||||
| WELD SIZE | PC | 0.3125 | =IF(D2="mm",D85*0.03937,D85) | |||||||||
| WELD SIZE | PD | =D85 | =IF(D2="mm",D86*0.03937,D86) | |||||||||
| STRUCTURE FORMULAS | ||||||||||||
| COLUMN HEAD PLATE FORMULAS | ||||||||||||
| RIGHT CORD TO COLUMN CL | =(E10+E22/2)+C91 | =IF(E12>83,14,10) | ||||||||||
| LEFT CORD TO COLUMN CL | =(E10+E41/2)+C91 | |||||||||||
| CORD CL TO END OF PLATE | =(E10+7)/2 | |||||||||||
| "uh" GUSSET OFFSET | =C94-(E25/2) | =IF(F15=FALSE,5.25,3.5) | ||||||||||
| "ug" GUSSET OFFSET | =C95-(E44/2) | =IF(F18=FALSE,5.25,3.5) | ||||||||||
| WEB ANGLE FORMULAS | ||||||||||||
| WEB ANGLE CG | =(((E77*E77)+(E77*E78))-(E78*E78))/(((E77+E77)-E78)*2) | |||||||||||
| HOLE CL | =IF(E77=2.5,1.375,E77/2) | |||||||||||
| WEB ANGLE HOLE CENTERS | =LOOKUP(E79,{0,0.624,0.74,0.874,0.99,1.26},{2.25,2.5,3,3.5,4.375}) | |||||||||||
| PANEL FORMULAS (INCLUDES HALF PANELS) | ||||||||||||
| PANEL QTY FOR LEFT FRONT CHORDS | =LOOKUP(D7,{6,7,8,9,10,11,12,13,14,15,16,17},{3.5,3.5,4.5,4.5,5.5,5.5,6.5,6.5,7.5,7.5,8.5,8.5}) | |||||||||||
| PANEL QTY FOR REAR LEFT CHORD | =LOOKUP(D7,{6,7,8,9,10,11,12,13,14,15,16,17},{2.5,2.5,3.5,3.5,4.5,4.5,5.5,5.5,6.5,6.5,7.5,7.5}) | |||||||||||
| PANEL SPAN | =E6/D7 | |||||||||||
| WEB ANGLE FORMULAS LEFT TRUSS | ||||||||||||
| # OF "aa" ANGLES | =B101-0.5 | |||||||||||
| # OF "ab" ANGLES | =B105 | |||||||||||
| # OF TOP "ad" ANGLES | =(B101-0.5)*2 | |||||||||||
| # OF BOTTOM "ad" ANGLES | =B107 | |||||||||||
| WEB ANGLE FORMULAS RIGHT TRUSS | ||||||||||||
| # OF "aa" ANGLES | =(D7-B101)-0.5 | |||||||||||
| # OF "ab" ANGLES | =B110 | |||||||||||
| # OF TOP "ad" ANGLES | =((D7-1)-B102)*2 | |||||||||||
| # OF BOTTOM "ad" ANGLES | =B112 | |||||||||||
| WEB PLATE FORMULAS LEFT TRUSS | ||||||||||||
| # OF "pb" PLATES | =B101-1.5 | |||||||||||
| # OF "pp" PLATES | =B115 | |||||||||||
| # OF TOP "ph" PLATES | =B101-0.5 | |||||||||||
| # OF BOTTOM "ph" PLATES | =B117 | |||||||||||
| # OF TOP "pn" PLATES | =B117 | |||||||||||
| # OF BOTTOM "pn" PLATES | =B119 | |||||||||||
| WEB PLATE FORMULAS RIGHT TRUSS | ||||||||||||
| # OF "pb" PLATES | =(D7-B101)-0.5 | |||||||||||
| # OF "pp" PLATES | =B122 | |||||||||||
| # OF TOP "ph" PLATES | =B122 | |||||||||||
| # OF BOTTOM "ph" PLATES | =B124 | |||||||||||
| # OF TOP "pn" PLATES | =((D7-1)-B102)+0.5 | |||||||||||
| # OF BOTTOM "pn" PLATES | =B126 | |||||||||||
| COMPONENT SIZES | ||||||||||||
| CHORDS | ||||||||||||
| CHORD DIAMETER | =CONCATENATE(J132,K132,M132,".",#REF!,"""") | =E10 | =INT(C132) | =C132-D132 | =IF(E132>=0.96875,1,0) | =D132+F132 | =G132/12 | =INT(H132) | =IF(I132=0,"",I132) | =IF(I132=0,"","' - ") | =(H132-I132)*12 | =ROUND(L132,0) |
| CHORD lbs/ft | =CONCATENATE(FIXED(C133,1)," lbs/ft") | =10.56*((C132-E11)*E11) | ||||||||||
| ma CHORD LENGTH | =CONCATENATE(J134,K134,M134,".",#REF!,"""") | =C136+[Θ.xls]Sheet1!J3 | =INT(C134) | =C134-D134 | =IF(E134>=0.96875,1,0) | =D134+F134 | =G134/12 | =INT(H134) | =IF(I134=0,"",I134) | =IF(I134=0,"","' - ") | =(H134-I134)*12 | =ROUND(L134,0) |
| ma CHORD WEIGHT | =CONCATENATE(FIXED(C135,1)," lbs") | =C133*(C134/12) | ||||||||||
| mb CHORD LENGTH | =CONCATENATE(J136,K136,M136,".",#REF!,"""") | =((B101*B103)+((E41/2)+1))-(E85+0.0625) | =INT(C136) | =C136-D136 | =IF(E136>=0.96875,1,0) | =D136+F136 | =G136/12 | =INT(H136) | =IF(I136=0,"",I136) | =IF(I136=0,"","' - ") | =(H136-I136)*12 | =ROUND(L136,0) |
| mb CHORD WEIGHT | =CONCATENATE(FIXED(C137,1)," lbs") | =C135 | ||||||||||
| mc CHORD LENGTH | =CONCATENATE(J138,K138,M138,".",#REF!,"""") | =(B103*B102)+E9-(E85+0.0625) | =INT(C138) | =C138-D138 | =IF(E138>=0.96875,1,0) | =D138+F138 | =G138/12 | =INT(H138) | =IF(I138=0,"",I138) | =IF(I138=0,"","' - ") | =(H138-I138)*12 | =ROUND(L138,0) |
| mc CHORD WEIGHT | =CONCATENATE(FIXED(C139,1)," lbs") | =C133*(C138/12) | ||||||||||
| md CHORD LENGTH | =CONCATENATE(J140,K140,M140,".",#REF!,"""") | =C142+[Θ.xls]Sheet1!I3 | =INT(C140) | =C140-D140 | =IF(E140>=0.96875,1,0) | =D140+F140 | =G140/12 | =INT(H140) | =IF(I140=0,"",I140) | =IF(I140=0,"","' - ") | =(H140-I140)*12 | =ROUND(L140,0) |
| md CHORD WEIGHT | =CONCATENATE(FIXED(C141,1)," lbs") | =C133*(C140/12) | ||||||||||
| me CHORD LENGTH | =CONCATENATE(J142,K142,M142,".",#REF!,"""") | =[Θ.xls]Sheet1!G3 | =INT(C142) | =C142-D142 | =IF(E142>=0.96875,1,0) | =D142+F142 | =G142/12 | =INT(H142) | =IF(I142=0,"",I142) | =IF(I142=0,"","' - ") | =(H142-I142)*12 | =ROUND(L142,0) |
| me CHORD WEIGHT | =CONCATENATE(FIXED(C143,1)," lbs") | =C141 | ||||||||||
| mf CHORD LENGTH | =CONCATENATE(J144,K144,M144,".",#REF!,"""") | =[Θ.xls]Sheet1!H3+([Θ.xls]Sheet1!I3/4) | =INT(C144) | =C144-D144 | =IF(E144>=0.96875,1,0) | =D144+F144 | =G144/12 | =INT(H144) | =IF(I144=0,"",I144) | =IF(I144=0,"","' - ") | =(H144-I144)*12 | =ROUND(L144,0) |
| mf CHORD WEIGHT | =CONCATENATE(FIXED(C145,1)," lbs") | =C133*(C144/12) | ||||||||||
| pm (CHORD END PLATE) DIAMETER | =CONCATENATE(J146,K146,M146,".",#REF!,"""") | =C132-0.25 | =INT(C146) | =C146-D146 | =IF(E146>=0.96875,1,0) | =D146+F146 | =G146/12 | =INT(H146) | =IF(I146=0,"",I146) | =IF(I146=0,"","' - ") | =(H146-I146)*12 | =ROUND(L146,0) |
| pm (CHORD END PLATE) HEIGHT | =CONCATENATE(J147,K147,M147,".",#REF!,"""") | =C132/2 | =INT(C147) | =C147-D147 | =IF(E147>=0.96875,1,0) | =D147+F147 | =G147/12 | =INT(H147) | =IF(I147=0,"",I147) | =IF(I147=0,"","' - ") | =(H147-I147)*12 | =ROUND(L147,0) |
| pe (CHORD HEAD PLATE) THICKNESS | =CONCATENATE(J148,K148,M148,".",#REF!,"""") | =E13 | =INT(C148) | =C148-D148 | =IF(E148>=0.96875,1,0) | =D148+F148 | =G148/12 | =INT(H148) | =IF(I148=0,"",I148) | =IF(I148=0,"","' - ") | =(H148-I148)*12 | =ROUND(L148,0) |
| pe (CHORD HEAD PLATE) WIDTH | =CONCATENATE(J149,K149,M149,".",#REF!,"""") | =E10+7 | =INT(C149) | =C149-D149 | =IF(E149>=0.96875,1,0) | =D149+F149 | =G149/12 | =INT(H149) | =IF(I149=0,"",I149) | =IF(I149=0,"","' - ") | =(H149-I149)*12 | =ROUND(L149,0) |
| pe (CHORD HEAD PLATE) LENGTH | =CONCATENATE(J150,K150,M150,".",#REF!,"""") | =(E41+2)+(E10*1.5) | =INT(C150) | =C150-D150 | =IF(E150>=0.96875,1,0) | =D150+F150 | =G150/12 | =INT(H150) | =IF(I150=0,"",I150) | =IF(I150=0,"","' - ") | =(H150-I150)*12 | =ROUND(L150,0) |
| pf (CHORD HEAD PLATE) THICKNESS | =CONCATENATE(J151,K151,M151,".",#REF!,"""") | =C148 | =INT(C151) | =C151-D151 | =IF(E151>=0.96875,1,0) | =D151+F151 | =G151/12 | =INT(H151) | =IF(I151=0,"",I151) | =IF(I151=0,"","' - ") | =(H151-I151)*12 | =ROUND(L151,0) |
| pf (CHORD HEAD PLATE) WIDTH | =CONCATENATE(J152,K152,M152,".",#REF!,"""") | =C149 | =INT(C152) | =C152-D152 | =IF(E152>=0.96875,1,0) | =D152+F152 | =G152/12 | =INT(H152) | =IF(I152=0,"",I152) | =IF(I152=0,"","' - ") | =(H152-I152)*12 | =ROUND(L152,0) |
| pf (CHORD HEAD PLATE) LENGTH | =CONCATENATE(J153,K153,M153,".",#REF!,"""") | =(E22+2)+(E10*1.5) | =INT(C153) | =C153-D153 | =IF(E153>=0.96875,1,0) | =D153+F153 | =G153/12 | =INT(H153) | =IF(I153=0,"",I153) | =IF(I153=0,"","' - ") | =(H153-I153)*12 | =ROUND(L153,0) |
| pt (SPLICE FLANGE) O.D. | =CONCATENATE(J154,K154,M154,".",#REF!,"""") | =E10+(E81*2) | =INT(C154) | =C154-D154 | =IF(E154>=0.96875,1,0) | =D154+F154 | =G154/12 | =INT(H154) | =IF(I154=0,"",I154) | =IF(I154=0,"","' - ") | =(H154-I154)*12 | =ROUND(L154,0) |
| pt (SPLICE FLANGE) THICKNESS | =CONCATENATE(J155,K155,M155,".",#REF!,"""") | =E82 | =INT(C155) | =C155-D155 | =IF(E155>=0.96875,1,0) | =D155+F155 | =G155/12 | =INT(H155) | =IF(I155=0,"",I155) | =IF(I155=0,"","' - ") | =(H155-I155)*12 | =ROUND(L155,0) |
| mv (SPLICE BOLT) DIAMETER | =CONCATENATE(J156,K156,M156,".",#REF!,"""") | =E84 | =INT(C156) | =C156-D156 | =IF(E156>=0.96875,1,0) | =D156+F156 | =G156/12 | =INT(H156) | =IF(I156=0,"",I156) | =IF(I156=0,"","' - ") | =(H156-I156)*12 | =ROUND(L156,0) |
| mv (SPLICE BOLT) LENGTH | =CONCATENATE(J157,K157,M157,".",#REF!,"""") | =(E82*2)+E84+0.5 | =INT(C157) | =C157-D157 | =IF(E157>=0.96875,1,0) | =D157+F157 | =G157/12 | =INT(H157) | =IF(I157=0,"",I157) | =IF(I157=0,"","' - ") | =(H157-I157)*12 | =ROUND(L157,0) |
| WEB ANGLES | ||||||||||||
| ANGLE WIDTH | =CONCATENATE(J159,K159,M159,".",#REF!,"""") | =E77 | =INT(C159) | =C159-D159 | =IF(E159>=0.96875,1,0) | =D159+F159 | =G159/12 | =INT(H159) | =IF(I159=0,"",I159) | =IF(I159=0,"","' - ") | =(H159-I159)*12 | =ROUND(L159,0) |
| ANGLE THICKNESS | =CONCATENATE(J160,K160,M160,".",#REF!,"""") | =E78 | =INT(C160) | =C160-D160 | =IF(E160>=0.96875,1,0) | =D160+F160 | =G160/12 | =INT(H160) | =IF(I160=0,"",I160) | =IF(I160=0,"","' - ") | =(H160-I160)*12 | =ROUND(L160,0) |
| aa LENGTH | =CONCATENATE(J161,K161,M161,".",#REF!,"""") | =[Θ.xls]Sheet1!X3 | =INT(C161) | =C161-D161 | =IF(E161>=0.96875,1,0) | =D161+F161 | =G161/12 | =INT(H161) | =IF(I161=0,"",I161) | =IF(I161=0,"","' - ") | =(H161-I161)*12 | =ROUND(L161,0) |
| ab LENGTH | =CONCATENATE(J162,K162,M162,".",#REF!,"""") | =[Θ.xls]Sheet1!Y3 | =INT(C162) | =C162-D162 | =IF(E162>=0.96875,1,0) | =D162+F162 | =G162/12 | =INT(H162) | =IF(I162=0,"",I162) | =IF(I162=0,"","' - ") | =(H162-I162)*12 | =ROUND(L162,0) |
| ad LENGTH | =CONCATENATE(J163,K163,M163,".",#REF!,"""") | =[Θ.xls]Sheet1!AA3 | =INT(C163) | =C163-D163 | =IF(E163>=0.96875,1,0) | =D163+F163 | =G163/12 | =INT(H163) | =IF(I163=0,"",I163) | =IF(I163=0,"","' - ") | =(H163-I163)*12 | =ROUND(L163,0) |
| af LENGTH | =CONCATENATE(J164,K164,M164,".",#REF!,"""") | =[Θ.xls]Sheet1!Z3 | =INT(C164) | =C164-D164 | =IF(E164>=0.96875,1,0) | =D164+F164 | =G164/12 | =INT(H164) | =IF(I164=0,"",I164) | =IF(I164=0,"","' - ") | =(H164-I164)*12 | =ROUND(L164,0) |
| d1 LENGTH | =CONCATENATE(J165,K165,M165,".",#REF!,"""") | =[Θ.xls]Sheet1!AC3 | =INT(C165) | =C165-D165 | =IF(E165>=0.96875,1,0) | =D165+F165 | =G165/12 | =INT(H165) | =IF(I165=0,"",I165) | =IF(I165=0,"","' - ") | =(H165-I165)*12 | =ROUND(L165,0) |
| d2 LENGTH | =CONCATENATE(J166,K166,M166,".",#REF!,"""") | =[Θ.xls]Sheet1!AE3 | =INT(C166) | =C166-D166 | =IF(E166>=0.96875,1,0) | =D166+F166 | =G166/12 | =INT(H166) | =IF(I166=0,"",I166) | =IF(I166=0,"","' - ") | =(H166-I166)*12 | =ROUND(L166,0) |
| d3 LENGTH | =CONCATENATE(J167,K167,M167,".",#REF!,"""") | =[Θ.xls]Sheet1!AF3 | =INT(C167) | =C167-D167 | =IF(E167>=0.96875,1,0) | =D167+F167 | =G167/12 | =INT(H167) | =IF(I167=0,"",I167) | =IF(I167=0,"","' - ") | =(H167-I167)*12 | =ROUND(L167,0) |
| WEB PLATES | ||||||||||||
| PLATE THICKNESS | =CONCATENATE(J169,K169,M169,".",#REF!,"""") | =E59 | =INT(C169) | =C169-D169 | =IF(E169>=0.96875,1,0) | =D169+F169 | =G169/12 | =INT(H169) | =IF(I169=0,"",I169) | =IF(I169=0,"","' - ") | =(H169-I169)*12 | =ROUND(L169,0) |
| mx DIAMETER | =CONCATENATE(J170,K170,M170,".",#REF!,"""") | =E79 | =INT(C170) | =C170-D170 | =IF(E170>=0.96875,1,0) | =D170+F170 | =G170/12 | =INT(H170) | =IF(I170=0,"",I170) | =IF(I170=0,"","' - ") | =(H170-I170)*12 | =ROUND(L170,0) |
| mx LENGTH | =CONCATENATE(J171,K171,M171,".",#REF!,"""") | =E78+E59+E79+0.05 | =INT(C171) | =C171-D171 | =IF(E171>=0.96875,1,0) | =D171+F171 | =G171/12 | =INT(H171) | =IF(I171=0,"",I171) | =IF(I171=0,"","' - ") | =(H171-I171)*12 | =ROUND(L171,0) |
| pd HEIGHT | =CONCATENATE(J172,K172,M172,".",#REF!,"""") | =E71 | =INT(C172) | =C172-D172 | =IF(E172>=0.96875,1,0) | =D172+F172 | =G172/12 | =INT(H172) | =IF(I172=0,"",I172) | =IF(I172=0,"","' - ") | =(H172-I172)*12 | =ROUND(L172,0) |
| pd LENGTH | =CONCATENATE(J173,K173,M173,".",#REF!,"""") | =E72 | =INT(C173) | =C173-D173 | =IF(E173>=0.96875,1,0) | =D173+F173 | =G173/12 | =INT(H173) | =IF(I173=0,"",I173) | =IF(I173=0,"","' - ") | =(H173-I173)*12 | =ROUND(L173,0) |
| pb HEIGHT | =CONCATENATE(J174,K174,M174,".",#REF!,"""") | =E67 | =INT(C174) | =C174-D174 | =IF(E174>=0.96875,1,0) | =D174+F174 | =G174/12 | =INT(H174) | =IF(I174=0,"",I174) | =IF(I174=0,"","' - ") | =(H174-I174)*12 | =ROUND(L174,0) |
| pb LENGTH | =CONCATENATE(J175,K175,M175,".",#REF!,"""") | =E68 | =INT(C175) | =C175-D175 | =IF(E175>=0.96875,1,0) | =D175+F175 | =G175/12 | =INT(H175) | =IF(I175=0,"",I175) | =IF(I175=0,"","' - ") | =(H175-I175)*12 | =ROUND(L175,0) |
| pp HEIGHT | =CONCATENATE(J176,K176,M176,".",#REF!,"""") | =E65 | =INT(C176) | =C176-D176 | =IF(E176>=0.96875,1,0) | =D176+F176 | =G176/12 | =INT(H176) | =IF(I176=0,"",I176) | =IF(I176=0,"","' - ") | =(H176-I176)*12 | =ROUND(L176,0) |
| pp LENGTH | =CONCATENATE(J177,K177,M177,".",#REF!,"""") | =E66 | =INT(C177) | =C177-D177 | =IF(E177>=0.96875,1,0) | =D177+F177 | =G177/12 | =INT(H177) | =IF(I177=0,"",I177) | =IF(I177=0,"","' - ") | =(H177-I177)*12 | =ROUND(L177,0) |
| pa HEIGHT | =CONCATENATE(J178,K178,M178,".",#REF!,"""") | =E73 | =INT(C178) | =C178-D178 | =IF(E178>=0.96875,1,0) | =D178+F178 | =G178/12 | =INT(H178) | =IF(I178=0,"",I178) | =IF(I178=0,"","' - ") | =(H178-I178)*12 | =ROUND(L178,0) |
| pa LENGTH | =CONCATENATE(J179,K179,M179,".",#REF!,"""") | =E74 | =INT(C179) | =C179-D179 | =IF(E179>=0.96875,1,0) | =D179+F179 | =G179/12 | =INT(H179) | =IF(I179=0,"",I179) | =IF(I179=0,"","' - ") | =(H179-I179)*12 | =ROUND(L179,0) |
| pk HEIGHT | =CONCATENATE(J180,K180,M180,".",#REF!,"""") | =E69 | =INT(C180) | =C180-D180 | =IF(E180>=0.96875,1,0) | =D180+F180 | =G180/12 | =INT(H180) | =IF(I180=0,"",I180) | =IF(I180=0,"","' - ") | =(H180-I180)*12 | =ROUND(L180,0) |
| pk LENGTH | =CONCATENATE(J181,K181,M181,".",#REF!,"""") | =E70 | =INT(C181) | =C181-D181 | =IF(E181>=0.96875,1,0) | =D181+F181 | =G181/12 | =INT(H181) | =IF(I181=0,"",I181) | =IF(I181=0,"","' - ") | =(H181-I181)*12 | =ROUND(L181,0) |
| ph HEIGHT | =CONCATENATE(J182,K182,M182,".",#REF!,"""") | =E63 | =INT(C182) | =C182-D182 | =IF(E182>=0.96875,1,0) | =D182+F182 | =G182/12 | =INT(H182) | =IF(I182=0,"",I182) | =IF(I182=0,"","' - ") | =(H182-I182)*12 | =ROUND(L182,0) |
| ph LENGTH | =CONCATENATE(J183,K183,M183,".",#REF!,"""") | =E64 | =INT(C183) | =C183-D183 | =IF(E183>=0.96875,1,0) | =D183+F183 | =G183/12 | =INT(H183) | =IF(I183=0,"",I183) | =IF(I183=0,"","' - ") | =(H183-I183)*12 | =ROUND(L183,0) |
| pn HEIGHT | =CONCATENATE(J184,K184,M184,".",#REF!,"""") | =E61 | =INT(C184) | =C184-D184 | =IF(E184>=0.96875,1,0) | =D184+F184 | =G184/12 | =INT(H184) | =IF(I184=0,"",I184) | =IF(I184=0,"","' - ") | =(H184-I184)*12 | =ROUND(L184,0) |
| pn LENGTH | =CONCATENATE(J185,K185,M185,".",#REF!,"""") | =E62 | =INT(C185) | =C185-D185 | =IF(E185>=0.96875,1,0) | =D185+F185 | =G185/12 | =INT(H185) | =IF(I185=0,"",I185) | =IF(I185=0,"","' - ") | =(H185-I185)*12 | =ROUND(L185,0) |
| pr HEIGHT | =CONCATENATE(J186,K186,M186,".",#REF!,"""") | =E75 | =INT(C186) | =C186-D186 | =IF(E186>=0.96875,1,0) | =D186+F186 | =G186/12 | =INT(H186) | =IF(I186=0,"",I186) | =IF(I186=0,"","' - ") | =(H186-I186)*12 | =ROUND(L186,0) |
| pr LENGTH | =CONCATENATE(J187,K187,M187,".",#REF!,"""") | =E76 | =INT(C187) | =C187-D187 | =IF(E187>=0.96875,1,0) | =D187+F187 | =G187/12 | =INT(H187) | =IF(I187=0,"",I187) | =IF(I187=0,"","' - ") | =(H187-I187)*12 | =ROUND(L187,0) |
| RIGHT COLUMN PARTS | ||||||||||||
| up (COLUMN) DIAMETER | =CONCATENATE(J189,K189,M189,".",#REF!,"""") | =E22 | =INT(C189) | =C189-D189 | =IF(E189>=0.96875,1,0) | =D189+F189 | =G189/12 | =INT(H189) | =IF(I189=0,"",I189) | =IF(I189=0,"","' - ") | =(H189-I189)*12 | =ROUND(L189,0) |
| up (COLUMN) LENGTH | =CONCATENATE(J190,K190,M190,".",#REF!,"""") | =(E21+(E12/2)+E13+E24+[Θ.xls]Sheet1!DE3+1)-0.375 | =INT(C190) | =C190-D190 | =IF(E190>=0.96875,1,0) | =D190+F190 | =G190/12 | =INT(H190) | =IF(I190=0,"",I190) | =IF(I190=0,"","' - ") | =(H190-I190)*12 | =ROUND(L190,0) |
| up (COLUMN) WEIGHT | =CONCATENATE(FIXED(C191,1)," lbs") | =D191*(C190/12) | =10.56*((C189-E23)*E23) | |||||||||
| ua (BASE PLATE) THICKNESS | =CONCATENATE(J192,K192,M192,".",#REF!,"""") | =E29 | =INT(C192) | =C192-D192 | =IF(E192>=0.96875,1,0) | =D192+F192 | =G192/12 | =INT(H192) | =IF(I192=0,"",I192) | =IF(I192=0,"","' - ") | =(H192-I192)*12 | =ROUND(L192,0) |
| ua (BASE PLATE) DIAMETER | =CONCATENATE(J193,K193,M193,".",#REF!,"""") | =E22+12 | =INT(C193) | =C193-D193 | =IF(E193>=0.96875,1,0) | =D193+F193 | =G193/12 | =INT(H193) | =IF(I193=0,"",I193) | =IF(I193=0,"","' - ") | =(H193-I193)*12 | =ROUND(L193,0) |
| ub (BASE PLATE GUSSET) THICKNESS | =CONCATENATE(J194,K194,M194,".",#REF!,"""") | =E32 | =INT(C194) | =C194-D194 | =IF(E194>=0.96875,1,0) | =D194+F194 | =G194/12 | =INT(H194) | =IF(I194=0,"",I194) | =IF(I194=0,"","' - ") | =(H194-I194)*12 | =ROUND(L194,0) |
| ub (BASE PLATE GUSSET) HEIGHT | =CONCATENATE(J195,K195,M195,".",#REF!,"""") | =E33+1 | =INT(C195) | =C195-D195 | =IF(E195>=0.96875,1,0) | =D195+F195 | =G195/12 | =INT(H195) | =IF(I195=0,"",I195) | =IF(I195=0,"","' - ") | =(H195-I195)*12 | =ROUND(L195,0) |
| ud (HEAD PLATE) THICKNESS | =CONCATENATE(J196,K196,M196,".",#REF!,"""") | =E24 | =INT(C196) | =C196-D196 | =IF(E196>=0.96875,1,0) | =D196+F196 | =G196/12 | =INT(H196) | =IF(I196=0,"",I196) | =IF(I196=0,"","' - ") | =(H196-I196)*12 | =ROUND(L196,0) |
| ud (HEAD PLATE) WIDTH | =CONCATENATE(J197,K197,M197,".",#REF!,"""") | =E22+2 | =INT(C197) | =C197-D197 | =IF(E197>=0.96875,1,0) | =D197+F197 | =G197/12 | =INT(H197) | =IF(I197=0,"",I197) | =IF(I197=0,"","' - ") | =(H197-I197)*12 | =ROUND(L197,0) |
| ud (HEAD PLATE) LENGTH | =CONCATENATE(J198,K198,M198,".",#REF!,"""") | =B91+B93 | =INT(C198) | =C198-D198 | =IF(E198>=0.96875,1,0) | =D198+F198 | =G198/12 | =INT(H198) | =IF(I198=0,"",I198) | =IF(I198=0,"","' - ") | =(H198-I198)*12 | =ROUND(L198,0) |
| mw (HEAD PLATE BOLT) DIAMETER | =CONCATENATE(J199,K199,M199,".",#REF!,"""") | =E14 | =INT(C199) | =C199-D199 | =IF(E199>=0.96875,1,0) | =D199+F199 | =G199/12 | =INT(H199) | =IF(I199=0,"",I199) | =IF(I199=0,"","' - ") | =(H199-I199)*12 | =ROUND(L199,0) |
| mw (HEAD PLATE BOLT) LENGTH | =CONCATENATE(J200,K200,M200,".",#REF!,"""") | =E13+E14+E24+0.05 | =INT(C200) | =C200-D200 | =IF(E200>=0.96875,1,0) | =D200+F200 | =G200/12 | =INT(H200) | =IF(I200=0,"",I200) | =IF(I200=0,"","' - ") | =(H200-I200)*12 | =ROUND(L200,0) |
| uh (HEAD PLATE GUSSET) THICKNESS | =CONCATENATE(J201,K201,M201,".",#REF!,"""") | =E25 | =INT(C201) | =C201-D201 | =IF(E201>=0.96875,1,0) | =D201+F201 | =G201/12 | =INT(H201) | =IF(I201=0,"",I201) | =IF(I201=0,"","' - ") | =(H201-I201)*12 | =ROUND(L201,0) |
| uh (HEAD PLATE GUSSET) LENGTH | =CONCATENATE(J202,K202,M202,".",#REF!,"""") | =[Θ.xls]Sheet1!DE3 | =INT(C202) | =C202-D202 | =IF(E202>=0.96875,1,0) | =D202+F202 | =G202/12 | =INT(H202) | =IF(I202=0,"",I202) | =IF(I202=0,"","' - ") | =(H202-I202)*12 | =ROUND(L202,0) |
| uk (COLUMN CAP) DIAMETER | =CONCATENATE(J203,K203,M203,".",#REF!,"""") | =E22+0.5 | =INT(C203) | =C203-D203 | =IF(E203>=0.96875,1,0) | =D203+F203 | =G203/12 | =INT(H203) | =IF(I203=0,"",I203) | =IF(I203=0,"","' - ") | =(H203-I203)*12 | =ROUND(L203,0) |
| au (COLUMN CAP ANGLE) LENGTH | =CONCATENATE(J204,K204,M204,".",#REF!,"""") | =(E22-(E23*2))-0.25 | =INT(C204) | =C204-D204 | =IF(E204>=0.96875,1,0) | =D204+F204 | =G204/12 | =INT(H204) | =IF(I204=0,"",I204) | =IF(I204=0,"","' - ") | =(H204-I204)*12 | =ROUND(L204,0) |
| ng (COLUMN CAP GASKET) DIAMETER | =CONCATENATE(J205,K205,M205,".",#REF!,"""") | =C203 | =INT(C205) | =C205-D205 | =IF(E205>=0.96875,1,0) | =D205+F205 | =G205/12 | =INT(H205) | =IF(I205=0,"",I205) | =IF(I205=0,"","' - ") | =(H205-I205)*12 | =ROUND(L205,0) |
| ul (ANCHOR BOLT) DIAMETER | =CONCATENATE(J206,K206,M206,".",#REF!,"""") | =E37 | =INT(C206) | =C206-D206 | =IF(E206>=0.96875,1,0) | =D206+F206 | =G206/12 | =INT(H206) | =IF(I206=0,"",I206) | =IF(I206=0,"","' - ") | =(H206-I206)*12 | =ROUND(L206,0) |
| ul (ANCHOR BOLT) LENGTH | =CONCATENATE(J207,K207,M207,".",#REF!,"""") | =E38+10.5 | =INT(C207) | =C207-D207 | =IF(E207>=0.96875,1,0) | =D207+F207 | =G207/12 | =INT(H207) | =IF(I207=0,"",I207) | =IF(I207=0,"","' - ") | =(H207-I207)*12 | =ROUND(L207,0) |
| ut (ANCHOR BOLT NUT) ID | =CONCATENATE(J208,K208,M208,".",#REF!,"""") | =C206 | =INT(C208) | =C208-D208 | =IF(E208>=0.96875,1,0) | =D208+F208 | =G208/12 | =INT(H208) | =IF(I208=0,"",I208) | =IF(I208=0,"","' - ") | =(H208-I208)*12 | =ROUND(L208,0) |
| LEFT COLUMN PARTS | ||||||||||||
| uq (COLUMN) DIAMETER | =CONCATENATE(J210,K210,M210,".",#REF!,"""") | =E41 | =INT(C210) | =C210-D210 | =IF(E210>=0.96875,1,0) | =D210+F210 | =G210/12 | =INT(H210) | =IF(I210=0,"",I210) | =IF(I210=0,"","' - ") | =(H210-I210)*12 | =ROUND(L210,0) |
| uq (COLUMN) LENGTH | =CONCATENATE(J211,K211,M211,".",#REF!,"""") | =(E40+(E12/2)+E13+E43+[Θ.xls]Sheet1!DH3+1)-0.375 | =INT(C211) | =C211-D211 | =IF(E211>=0.96875,1,0) | =D211+F211 | =G211/12 | =INT(H211) | =IF(I211=0,"",I211) | =IF(I211=0,"","' - ") | =(H211-I211)*12 | =ROUND(L211,0) |
| uq (COLUMN) WEIGHT | =CONCATENATE(FIXED(C212,1)," lbs") | =D212*(C211/12) | =10.56*((C210-E42)*E42) | |||||||||
| uc (BASE PLATE) THICKNESS | =CONCATENATE(J213,K213,M213,".",#REF!,"""") | =E48 | =INT(C213) | =C213-D213 | =IF(E213>=0.96875,1,0) | =D213+F213 | =G213/12 | =INT(H213) | =IF(I213=0,"",I213) | =IF(I213=0,"","' - ") | =(H213-I213)*12 | =ROUND(L213,0) |
| uc (BASE PLATE) DIAMETER | =CONCATENATE(J214,K214,M214,".",#REF!,"""") | =E41+12 | =INT(C214) | =C214-D214 | =IF(E214>=0.96875,1,0) | =D214+F214 | =G214/12 | =INT(H214) | =IF(I214=0,"",I214) | =IF(I214=0,"","' - ") | =(H214-I214)*12 | =ROUND(L214,0) |
| uf (BASE PLATE GUSSET) THICKNESS | =CONCATENATE(J215,K215,M215,".",#REF!,"""") | =E51 | =INT(C215) | =C215-D215 | =IF(E215>=0.96875,1,0) | =D215+F215 | =G215/12 | =INT(H215) | =IF(I215=0,"",I215) | =IF(I215=0,"","' - ") | =(H215-I215)*12 | =ROUND(L215,0) |
| uf (BASE PLATE GUSSET) HEIGHT | =CONCATENATE(J216,K216,M216,".",#REF!,"""") | =E52+1 | =INT(C216) | =C216-D216 | =IF(E216>=0.96875,1,0) | =D216+F216 | =G216/12 | =INT(H216) | =IF(I216=0,"",I216) | =IF(I216=0,"","' - ") | =(H216-I216)*12 | =ROUND(L216,0) |
| ue (HEAD PLATE) THICKNESS | =CONCATENATE(J217,K217,M217,".",#REF!,"""") | =E43 | =INT(C217) | =C217-D217 | =IF(E217>=0.96875,1,0) | =D217+F217 | =G217/12 | =INT(H217) | =IF(I217=0,"",I217) | =IF(I217=0,"","' - ") | =(H217-I217)*12 | =ROUND(L217,0) |
| ue (HEAD PLATE) WIDTH | =CONCATENATE(J218,K218,M218,".",#REF!,"""") | =E41+2 | =INT(C218) | =C218-D218 | =IF(E218>=0.96875,1,0) | =D218+F218 | =G218/12 | =INT(H218) | =IF(I218=0,"",I218) | =IF(I218=0,"","' - ") | =(H218-I218)*12 | =ROUND(L218,0) |
| ue (HEAD PLATE) LENGTH | =CONCATENATE(J219,K219,M219,".",#REF!,"""") | =B92+B93 | =INT(C219) | =C219-D219 | =IF(E219>=0.96875,1,0) | =D219+F219 | =G219/12 | =INT(H219) | =IF(I219=0,"",I219) | =IF(I219=0,"","' - ") | =(H219-I219)*12 | =ROUND(L219,0) |
| mw (HEAD PLATE BOLT) DIAMETER | =CONCATENATE(J220,K220,M220,".",#REF!,"""") | =E17 | =INT(C220) | =C220-D220 | =IF(E220>=0.96875,1,0) | =D220+F220 | =G220/12 | =INT(H220) | =IF(I220=0,"",I220) | =IF(I220=0,"","' - ") | =(H220-I220)*12 | =ROUND(L220,0) |
| mw (HEAD PLATE BOLT) LENGTH | =CONCATENATE(J221,K221,M221,".",#REF!,"""") | =E13+E17+E43+0.05 | =INT(C221) | =C221-D221 | =IF(E221>=0.96875,1,0) | =D221+F221 | =G221/12 | =INT(H221) | =IF(I221=0,"",I221) | =IF(I221=0,"","' - ") | =(H221-I221)*12 | =ROUND(L221,0) |
| ug (HEAD PLATE GUSSET) THICKNESS | =CONCATENATE(J222,K222,M222,".",#REF!,"""") | =E44 | =INT(C222) | =C222-D222 | =IF(E222>=0.96875,1,0) | =D222+F222 | =G222/12 | =INT(H222) | =IF(I222=0,"",I222) | =IF(I222=0,"","' - ") | =(H222-I222)*12 | =ROUND(L222,0) |
| ug (HEAD PLATE GUSSET) LENGTH | =CONCATENATE(J223,K223,M223,".",#REF!,"""") | =[Θ.xls]Sheet1!DH3 | =INT(C223) | =C223-D223 | =IF(E223>=0.96875,1,0) | =D223+F223 | =G223/12 | =INT(H223) | =IF(I223=0,"",I223) | =IF(I223=0,"","' - ") | =(H223-I223)*12 | =ROUND(L223,0) |
| ui (COLUMN CAP) DIAMETER | =CONCATENATE(J224,K224,M224,".",#REF!,"""") | =E41+0.5 | =INT(C224) | =C224-D224 | =IF(E224>=0.96875,1,0) | =D224+F224 | =G224/12 | =INT(H224) | =IF(I224=0,"",I224) | =IF(I224=0,"","' - ") | =(H224-I224)*12 | =ROUND(L224,0) |
| bu (COLUMN CAP ANGLE) LENGTH | =CONCATENATE(J225,K225,M225,".",#REF!,"""") | =(E41-(E42*2))-0.25 | =INT(C225) | =C225-D225 | =IF(E225>=0.96875,1,0) | =D225+F225 | =G225/12 | =INT(H225) | =IF(I225=0,"",I225) | =IF(I225=0,"","' - ") | =(H225-I225)*12 | =ROUND(L225,0) |
| nh (COLUMN CAP GASKET) DIAMETER | =CONCATENATE(J226,K226,M226,".",#REF!,"""") | =C224 | =INT(C226) | =C226-D226 | =IF(E226>=0.96875,1,0) | =D226+F226 | =G226/12 | =INT(H226) | =IF(I226=0,"",I226) | =IF(I226=0,"","' - ") | =(H226-I226)*12 | =ROUND(L226,0) |
| uj (ANCHOR BOLT) DIAMETER | =CONCATENATE(J227,K227,M227,".",#REF!,"""") | =E56 | =INT(C227) | =C227-D227 | =IF(E227>=0.96875,1,0) | =D227+F227 | =G227/12 | =INT(H227) | =IF(I227=0,"",I227) | =IF(I227=0,"","' - ") | =(H227-I227)*12 | =ROUND(L227,0) |
| uj (ANCHOR BOLT) LENGTH | =CONCATENATE(J228,K228,M228,".",#REF!,"""") | =E57+10.5 | =INT(C228) | =C228-D228 | =IF(E228>=0.96875,1,0) | =D228+F228 | =G228/12 | =INT(H228) | =IF(I228=0,"",I228) | =IF(I228=0,"","' - ") | =(H228-I228)*12 | =ROUND(L228,0) |
| uu (ANCHOR BOLT NUT) ID | =CONCATENATE(J229,K229,M229,".",#REF!,"""") | =C227 | =INT(C229) | =C229-D229 | =IF(E229>=0.96875,1,0) | =D229+F229 | =G229/12 | =INT(H229) | =IF(I229=0,"",I229) | =IF(I229=0,"","' - ") | =(H229-I229)*12 | =ROUND(L229,0) |
| COMPONENT SIZES | ||||||||||||
| DESCRIPTION | QTY | MARK | ||||||||||
| LEFT TRUSS | ||||||||||||
| =CONCATENATE("PIPE ",B132," DIA. X ",E11,""" W X ",B134," LG.") | 1 | ma | ||||||||||
| =CONCATENATE("PIPE ",B132," DIA. X ",E11,""" W X ",B136," LG.") | 1 | mb | ||||||||||
| =CONCATENATE("PIPE ",B132," DIA. X ",E11,""" W X ",B138," LG.") | 1 | mc | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B161," LG.") | =B105 | aa | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B162," LG.") | =B106 | ab | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B163," LG.") | =B107+B108 | ad | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B164," LG.") | 2 | af | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B186," X ",B187) | 1 | pr | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B172," X ",B173) | 1 | pd | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B174," X ",B175) | =B115 | pb | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B176," X ",B177) | =B116 | pp | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B180," X ",B181) | 2 | pk | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B178," X ",B179) | 1 | pa | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B182," X ",B183) | =B117+B118 | ph | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B184," X ",B185) | =B119+B120 | pn | ||||||||||
| =CONCATENATE("PLATE 1/4"" X ",B147," X ",B146," DIA. ") | 1 | pm | ||||||||||
| =CONCATENATE("PLATE ",B148," X ",B149," X ",B150) | 2 | pe | ||||||||||
| =CONCATENATE("PLATE ",B155," X ",B154," DIA.") | 3 | pt | ||||||||||
| =CONCATENATE("BOLT HEX HD ",B170," DIA. X ",B171, " LG. W/ SELFLOCKING NUT") | =(B238+B239+B240+B262)*4 | mx | ||||||||||
| =CONCATENATE("BOLT HEX HD ",B156," DIA. X ",B157, " LG. W/ SELFLOCKING NUT") | =D83*3 | mv | ||||||||||
| RIGHT TRUSS | ||||||||||||
| =CONCATENATE("PIPE ",B132," DIA. X ",E11,""" W X ",B140," LG.") | 1 | md | ||||||||||
| =CONCATENATE("PIPE ",B132," DIA. X ",E11,""" W X ",B142," LG.") | 1 | me | ||||||||||
| =CONCATENATE("PIPE ",B132," DIA. X ",E11,""" W X ",B144," LG.") | 1 | mf | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B161," LG.") | =B110 | aa | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B162," LG.") | =B111 | ab | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B163," LG.") | =B112+B113 | ad | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B164," LG.") | 2 | af | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B165," LG.") | 1 | d1 | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B166," LG.") | 1 | d2 | ||||||||||
| =CONCATENATE("ANGLE ",B159," X ",B159," X ",B160," X ",B167," LG.") | 1 | d3 | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B172," X ",B173) | 1 | pd | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B174," X ",B175) | =B122 | pb | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B176," X ",B177) | =B123 | pp | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B180," X ",B181) | 2 | pk | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B182," X ",B183) | =B124+B125 | ph | ||||||||||
| =CONCATENATE("PLATE ",B169," X ",B184," X ",B185) | =B126+B127 | pn | ||||||||||
| =CONCATENATE("PLATE 1/4"" X ",B147," X ",B146," DIA. ") | 1 | pm | ||||||||||
| =CONCATENATE("PLATE ",B151," X ",B152," X ",B153) | 2 | pf | ||||||||||
| =CONCATENATE("PLATE ",B155," X ",B154," DIA.") | 3 | pt | ||||||||||
| =CONCATENATE("BOLT HEX HD ",B170," DIA. X ",B171, " LG. W/ SELFLOCKING NUT") | =(B259+B260+B261+B262+B263+B264+B265)*4 | mx | ||||||||||
| RIGHT COLUMN | ||||||||||||
| =CONCATENATE("PIPE ",B189," DIA. X ",E23," W. X ",B190," LG.") | 1 | up | ||||||||||
| =CONCATENATE("PLATE ",B192," X ",B193," O.D.") | 1 | ua | ||||||||||
| =CONCATENATE("PLATE ",B194," X 6"" X ",B195," LG.") | =D36 | ub | ||||||||||
| =CONCATENATE("PLATE ",B196," X ",B197," X ",B198) | 2 | ud | ||||||||||
| =CONCATENATE("PLATE ",B201," X ",B202," X ",B202) | 2 | uh | ||||||||||
| =CONCATENATE("BOLT HEX HD ",B199," DIA. X ",B200, " LG. W/ SELFLOCKING NUT") | =(D15*2) | mw | ||||||||||
| =CONCATENATE("PLATE 3/8"" X ",B203," DIA.") | 1 | uk | ||||||||||
| =CONCATENATE("ANGLE 1.1/2"" X 1.1/2"" X 1/4"" X ",B204," LG.") | 1 | au | ||||||||||
| =CONCATENATE("NEOPRENE GASKET 1/8"" X ",B205," DIA.") | 1 | ng | ||||||||||
| BOLT HEX HD. 1/2" DIA. X 1.3/4" LG. | 1 | na | ||||||||||
| NUT HEX 1/2" DIA. | 1 | nb | ||||||||||
| WASHER RUBBER 1/2" DIA. | 1 | nc | ||||||||||
| =CONCATENATE("ANCHOR BOLT ",B206," DIA. X ",B207," LG.") | =D36 | ul | ||||||||||
| PLATE 1/4" X 4.1/2" SQ. | =D36*2 | um | ||||||||||
| =CONCATENATE("NUT HEX ",B208," DIA.") | =D36*5 | ut | ||||||||||
| LEFT COLUMN | ||||||||||||
| =CONCATENATE("PIPE ",B210," DIA. X ",E42," W. X ",B211," LG.") | 1 | uq | ||||||||||
| =CONCATENATE("PLATE ",B213," X ",B214," O.D.") | 1 | uc | ||||||||||
| =CONCATENATE("PLATE ",B215," X 6"" X ",B216," LG.") | =D55 | uf | ||||||||||
| =CONCATENATE("PLATE ",B217," X ",B218," X ",B219) | 2 | ue | ||||||||||
| =CONCATENATE("PLATE ",B222," X ",B223," X ",B223) | 2 | ug | ||||||||||
| =CONCATENATE("BOLT HEX HD ",B220," DIA. X ",B221, " LG. W/ SELFLOCKING NUT") | =D18*2 | mw | ||||||||||
| =CONCATENATE("PLATE 3/8"" X ",B224," DIA.") | 1 | ui | ||||||||||
| =CONCATENATE("ANGLE 1.1/2"" X 1.1/2"" X 1/4"" X ",B225," LG.") | 1 | bu | ||||||||||
| =CONCATENATE("NEOPRENE GASKET 1/8"" X ",B226," DIA.") | 1 | nh | ||||||||||
| BOLT HEX HD. 1/2" DIA. X 1.3/4" LG. | 1 | na | ||||||||||
| NUT HEX 1/2" DIA. | 1 | nb | ||||||||||
| WASHER RUBBER 1/2" DIA. | 1 | nc | ||||||||||
| =CONCATENATE("ANCHOR BOLT ",B227," DIA. X ",B228," LG.") | =D55 | uj | ||||||||||
| PLATE 1/4" X 4.1/2" SQ. | =D55*2 | um | ||||||||||
| =CONCATENATE("NUT HEX ",B229," DIA.") | =D55*5 | uu | ||||||||||