{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Wall Frame-Moldings"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Wall Frame-Moldings","index":0,"n_rows":52,"n_cols":35,"rows_kept":52,"cut":false,"hidden":false,"merged":[[15,32,15,35],[5,34,5,35],[5,30,5,32],[13,31,13,32],[20,1,20,28],[42,1,42,28],[30,1,30,28],[25,1,25,28],[9,13,9,16],[8,27,10,27],[8,28,10,28],[19,5,19,6],[21,1,21,28],[19,7,19,25],[18,5,18,6],[16,1,16,28],[9,17,9,18],[43,1,43,28],[31,1,31,28],[33,1,33,28],[36,1,36,28],[37,1,37,28],[38,1,38,28],[32,1,32,28],[35,2,35,3],[34,2,34,3],[34,4,34,25],[35,4,35,25],[39,2,39,3],[39,4,39,25],[40,1,40,28],[41,1,41,28],[44,1,44,6],[46,3,46,4],[46,5,46,7],[46,10,46,11],[46,12,46,14],[1,1,1,28],[17,5,17,6],[17,7,17,28],[8,18,8,25],[9,1,9,4],[5,1,5,28],[6,1,6,28],[3,1,3,28],[8,1,8,4],[8,5,8,13],[10,1,10,18],[8,14,8,17],[13,1,13,28],[11,1,11,28],[12,1,12,28],[14,1,14,28],[29,1,29,28],[15,1,15,5],[15,6,15,28],[9,19,10,25],[17,2,17,3],[9,5,9,6],[18,2,18,3],[9,11,9,12],[9,7,9,10],[26,1,26,28],[27,1,27,28],[28,2,28,3],[28,5,28,6],[28,7,28,25],[2,1,2,28],[4,1,4,28],[24,5,24,6],[24,2,24,3],[7,1,7,28],[22,1,22,28],[23,2,23,3],[23,5,23,6],[24,7,24,25],[23,7,23,25],[18,7,18,25],[19,2,19,3],[8,26,10,26],[51,12,51,14],[49,1,49,5],[51,3,51,4],[51,5,51,7],[51,10,51,11]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"MLPPTD&FRMMOD","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=3,WFMLD<=5,OR(MPP=3,MPP=4)),\"\",IF(AND(WFMLD=6,OR(MPP=2,MPP=3)),\"\",IF(AND(WFMLD=1,MPP=1),\" 3/4'' Wall Frame\",IF(AND(WFMLD=2,MPP=1),\" 1-3/8'' Wall Frame\",IF(AND(WFMLD=1,MPP=3),\" Clear Anodized 3/4'' Wall Frame\",IF(AND(WFMLD=2,MPP=3),\" Clear Anodized 1-3/8'' Wall Frame\",IF(WFMLD=3,\" 1'' H-Molding\",IF(WFMLD=4,\" 1'' Z-Molding\",IF(WFMLD=5,\" 1-1/2'' Z-Molding\",IF(WFMLD=6,\" 1-3/8'' L-Molding\",\"\")))))))))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(WFMLD>=1,WFMLD<=2,MPP=2)),\"\",IF(AND(WFMLD=6,MPP=2),\"\",IF(AND(MPP=4,WFMLD=6),\"Pre-Painted Matte Black\",IF(AND(AND(AND(WFMLD>=3,WFMLD<=5,MPP=2))),\"Pre-Painted - Quaker Dark Bronze Primer/Top Coat\",IF(MPP=1,\"Mill Finish\",IF(MPP=2,\"Pre-Painted\",\"\")))))))","v":""}]
[]
[]
[null,"Customer  ",null,null,null,null,null,null,null,null,null,null,null,null,"Order#   ",null,null,null,null,null,null,null,null,null,null,null,"Lengths Required","Lengths Used","Drops Used"]
[null,"Kit Quantity  ",null,null,null,0,null,"Height  ",null,null,null,0,null,"Width",null,null,null,0]
[null,"Enter Fractions as Decimals"]
[null,"Extrusions"]
[]
[null,"Wall Frame / Molding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Wall Frame/Molding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(KQ=0,\"\",IF(MPP=2,\"P\",IF(MPP=4,\"B\",\"\")))","v":""},"Painted"]
[null,"Wall Frame",null,null,null,null,"Fasteners",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Fasteners",{"$f":"IF(SCRWS=1,\" - Top and Bottom drilled and countersunk\",IF(SCRWS=2,\" - Sides drilled and countersunk\",\"\"))","v":" - Sides drilled and countersunk"}]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=1,WFMLD<=2),KQ*2,\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=1,WFMLD<=2),Hgt,\"\"))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD=1,MPP=2),\"\",IF(AND(WFMLD=1,MPP=4),\"\",IF(AND(WFMLD=2,MPP=2),\"\",IF(AND(WFMLD=2,MPP=4),\"\",IF(AND(WFMLD=1,MPP=3),\"1948\",IF(AND(WFMLD=2,MPP=3),\"1949\",IF(WFMLD=1,\"1948M\",IF(WFMLD=2,\"1949M\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD=1,SCRWS=1),\" 3/4'' Wall Frame - Sides - Mitered both ends\",IF(AND(WFMLD=1,SCRWS=2),\" 3/4'' Wall Frame - Sides - Mitered both ends\"&SCWTYP,IF(AND(WFMLD=2,SCRWS=1),\" 1-3/8'' Wall Frame - Sides - Mitered both ends\",IF(AND(WFMLD=2,SCRWS=2),\" 1-3/8'' Wall Frame - Sides - Mitered both ends\"&SCWTYP,\"\")))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=1,WFMLD<=2),KQ*2,\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=1,WFMLD<=2),Wdt,\"\"))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD=1,MPP=2),\"\",IF(AND(WFMLD=1,MPP=4),\"\",IF(AND(WFMLD=2,MPP=2),\"\",IF(AND(WFMLD=2,MPP=4),\"\",IF(AND(WFMLD=1,MPP=3),\"1948\",IF(AND(WFMLD=2,MPP=3),\"1949\",IF(WFMLD=1,\"1948M\",IF(WFMLD=2,\"1949M\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD=1,SCRWS=1),\" 3/4'' Wall Frame - Top and Bottom - Mitered both ends\"&SCWTYP,IF(AND(WFMLD=1,SCRWS=2),\" 3/4'' Wall Frame - Top and Bottom - Mitered both ends\",IF(AND(WFMLD=2,SCRWS=1),\" 1-3/8'' Wall Frame - Top and Bottom - Mitered both ends\"&SCWTYP,IF(AND(WFMLD=2,SCRWS=2),\" 1-3/8'' Wall Frame - Top and Bottom - Mitered both ends\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Moldings"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(WFMLD>=3,KQ*2,\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(WFMLD>=3,Hgt,\"\"))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(WFMLD>=3,WFMLD<=5,MPP=4)),\"NA\",IF(AND(AND(WFMLD>=3,WFMLD<=5,MPP=3)),\"NA\",IF(AND(WFMLD=6,MPP=2),\"NA\",IF(AND(WFMLD=6,MPP=3),\"NA\",IF(WFMLD=3,\"1945\"&PPTD,IF(WFMLD=4,\"1946\"&PPTD,IF(WFMLD=5,\"1947\"&PPTD,IF(WFMLD=6,\"1943\"&PPTD,\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(WFMLD=3,\" 1'' H-Molding - Sides - Mitered both ends\",IF(WFMLD=4,\" 1'' Z-Molding - Sides - Mitered both ends\",IF(WFMLD=5,\" 1-1/2'' Z-Molding - Sides - Mitered both ends\",IF(WFMLD=6,\" 1-3/8'' L-Molding - Sides - Mitered both ends\",\"\")))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(WFMLD>=3,KQ*2,\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(WFMLD>=3,Wdt,\"\"))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(WFMLD>=3,WFMLD<=5,MPP=4)),\"NA\",IF(AND(AND(WFMLD>=3,WFMLD<=5,MPP=3)),\"NA\",IF(AND(WFMLD=6,MPP=2),\"NA\",IF(AND(WFMLD=6,MPP=3),\"NA\",IF(WFMLD=3,\"1945\"&PPTD,IF(WFMLD=4,\"1946\"&PPTD,IF(WFMLD=5,\"1947\"&PPTD,IF(WFMLD=6,\"1943\"&PPTD,\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(WFMLD=3,\" 1'' H-Molding - Top and Bottom - Mitered both ends\",IF(WFMLD=4,\" 1'' Z-Molding - Top and Bottom - Mitered both ends\",IF(WFMLD=5,\" 1-1/2'' Z-Molding - Top and Bottom - Mitered both ends\",IF(WFMLD=6,\" 1-3/8'' L-Molding - Top and Bottom - Mitered both ends\",\"\")))))","v":""}]
[]
[null,"Z-Clip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Z-Clip"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(ZCLP=2,\"\",IF(WFMLD>=3,\"\",KQ)))","v":""},{"$f":"IF(KQ=0,\"\",IF(ZCLP=2,\"\",IF(WFMLD>=3,\"\",IF(WFMLD=1,Wdt-4,IF(WFMLD=2,Wdt-4.5,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(ZCLP=2,\"\",IF(WFMLD>=3,\"\",IF(WFMLD<=2,\"3099\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(ZCLP=2,\"\",IF(WFMLD>=3,\"\",IF(WFMLD<=2,\" Z-Clip - Straight Cut Both ends\",\"\"))))","v":""}]
[]
[null,"Hardware"]
[]
[null,"Wall Frames"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=1,WFMLD<=2),4*KQ,\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=1,WFMLD<=2),\"5210\",\"\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=1,WFMLD<=2),\" Corner Key - One (1) per corner\",\"\"))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=1,WFMLD<=2),6*KQ,\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=1,WFMLD<=2),\"5245\",\"\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(WFMLD>=1,WFMLD<=2),\" Wall Frame Corner Screw - #6 x 3/4'' Sq/Phillips Countersink S.S. Screw - Type A - One (1) per corner\",\"\"))","v":""}]
[]
[null,"Moldings"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(WFMLD=5,4*KQ,\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(WFMLD=5,\"5210\",\"\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(WFMLD=5,\" 1-1/2'' Z-Molding Corner Key - One (1) per corner\",\"\"))","v":""}]
[]
[]
[null,"Face Trim Size - Visual Openings"]
[]
[null,"Face Trim Size"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(WFMLD=1,Hgt-0.625,IF(WFMLD=2,Hgt-0.625,IF(WFMLD=3,Hgt-1.5,IF(WFMLD=4,Hgt-1.875,IF(WFMLD=5,Hgt-1.875,IF(WFMLD=6,Hgt-0.5,\"\")))))))","v":""},null,"Height",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(WFMLD=1,Wdt-0.625,IF(WFMLD=2,Wdt-0.625,IF(WFMLD=3,Wdt-1.5,IF(WFMLD=4,Wdt-1.875,IF(WFMLD=5,Wdt-1.875,IF(WFMLD=6,Wdt-0.5,\"\")))))))","v":""},null,"Width"]
[]
[]
[null,"Visual Opening"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(WFMLD=1,Hgt-1.5,IF(WFMLD=2,Hgt-2.75,IF(WFMLD=3,Hgt-2.94,IF(WFMLD=4,Hgt-3.36,IF(WFMLD=5,Hgt-4.38,IF(WFMLD=6,Hgt-2.82,\"\")))))))","v":""},null,"Height",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(WFMLD=1,Wdt-1.5,IF(WFMLD=2,Wdt-2.75,IF(WFMLD=3,Wdt-2.94,IF(WFMLD=4,Wdt-3.36,IF(WFMLD=5,Wdt-4.38,IF(WFMLD=6,Wdt-2.82,\"\")))))))","v":""},null,"Width"]