{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Snap Frames"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":23,"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":"Snap Frames","index":0,"n_rows":47,"n_cols":36,"rows_kept":47,"cut":false,"hidden":false,"merged":[[42,30,42,31],[39,30,39,32],[6,30,6,32],[5,34,5,35],[5,30,5,32],[13,31,13,32],[19,31,19,32],[13,34,13,35],[9,30,9,37],[10,30,10,37],[18,1,18,28],[37,1,37,28],[38,1,38,28],[29,1,29,28],[31,1,31,28],[35,1,35,28],[30,1,30,28],[33,2,33,3],[32,2,32,3],[32,4,32,25],[33,4,33,25],[28,1,28,28],[23,1,23,28],[36,1,36,28],[27,1,27,28],[34,2,34,3],[1,1,1,28],[15,5,15,6],[15,7,15,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],[11,1,11,28],[12,1,12,28],[9,13,9,16],[8,27,10,27],[16,5,16,6],[14,1,14,28],[9,17,9,18],[9,19,10,25],[15,2,15,3],[9,5,9,6],[16,2,16,3],[9,11,9,12],[9,7,9,10],[8,26,10,26],[13,1,13,11],[13,12,13,15],[13,24,13,25],[13,26,13,28],[13,16,13,23],[2,1,2,28],[4,1,4,28],[22,5,22,6],[22,2,22,3],[7,1,7,28],[20,1,20,28],[21,2,21,3],[21,5,21,6],[22,7,22,25],[21,7,21,25],[16,7,16,25],[17,2,17,3],[8,28,10,28],[17,5,17,6],[19,1,19,28],[17,7,17,25],[34,4,34,25],[46,12,46,14],[44,1,44,5],[46,3,46,4],[46,5,46,7],[46,10,46,11],[39,1,39,6],[41,3,41,4],[41,5,41,7],[41,10,41,11],[41,12,41,14],[24,1,24,28],[25,1,25,28],[26,2,26,3],[26,5,26,6],[26,7,26,25]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"FRAME&MLPPTD&COVER","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(SNF=1,\" Snap Frame with\",IF(SNF=2,\" Large Snap Frame with\",\"\")))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(MPP=1,\" Mill Finish\",IF(MPP=2,\" Clear Anodized\",\"\")))","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,null,null,{"$f":"IF(KQ=0,\"\",IF(SNFC=1,\" Snap Frame Radius Cover\",IF(SNFC=2,\" Snap Frame Flat Cover\",\"\")))","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,null,null,null,null,null,null,null,null,null,null,null," Use Large Snap Frame for face material 1/8'' (.125) or greater in total thickness."]
[null,"Enter Fractions as Decimals",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," Use Snap Frame for face material 1/8'' (.125) or less in total thickness."]
[null,"Extrusions"]
[]
[null,"Snap Frame",null,null,null,null,null,null,null,null,null,null,"Face Thickness",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,1,"Snap Frame",null,1,"Face Thickness"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(SNF=1,OR(FT=3,FT=4)),\"\",IF(AND(SNF=1,THKNS>=0.126),\"\",IF(AND(SNF=2,OR(FT=1)),\"\",IF(AND(AND(SNF=2,FT=5,THKNS<=0.124)),\"\",IF(AND(SNF=1,FT<=2),KQ*2,IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),KQ*2,IF(AND(SNF=2,OR(FT=2,FT=3,FT=4)),KQ*2,IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),KQ*2,IF(AND(AND(SNF=2,FT=5,THKNS>=0.125,AND(THKNS<=0.25))),KQ*2,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(SNF=1,OR(FT=3,FT=4)),\"\",IF(AND(SNF=1,THKNS>=0.126),\"\",IF(AND(SNF=2,OR(FT=1)),\"\",IF(AND(AND(SNF=2,FT=5,THKNS<=0.124)),\"\",IF(AND(SNF=1,FT<=2),Hgt-0.08,IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),Hgt-0.08,IF(AND(SNF=2,OR(FT=2,FT=3,FT=4)),Hgt-0.08,IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),Hgt-0.08,IF(AND(AND(SNF=2,FT=5,THKNS>=0.125,AND(THKNS<=0.25))),Hgt-0.08,\"\"))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(AND(SNF=1,OR(FT=3,FT=4)),\"\",IF(AND(SNF=1,THKNS>=0.126),\"\",IF(AND(SNF=2,OR(FT=1)),\"\",IF(AND(AND(SNF=2,FT=5,THKNS<=0.124)),\"\",IF(AND(SNF=1,FT<=2),\"1899\",IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),\"1899\",IF(AND(SNF=2,OR(FT=2,FT=3,FT=4)),\"1898\",IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),\"1899\",IF(AND(AND(SNF=2,FT=5,THKNS>=0.125,AND(THKNS<=0.25))),\"1898\",\"\"))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(SNF=1,OR(FT=3,FT=4)),\" Use Large Snap Frame for face material 1/8'' (.125) or greater in total thickness.\",IF(AND(SNF=1,THKNS>=0.126),\" Use Large Snap Frame for face material 1/8'' (.125) or greater in total thickness.\",IF(AND(SNF=2,OR(FT=1)),\" Use Snap Frame for face material 1/8'' (.125) or less in total thickness.\",IF(AND(AND(SNF=2,FT=5,THKNS<=0.124)),\" Use Snap Frame for face material 1/8'' (.125) or less in total thickness.\",IF(AND(SNF=1,FT<=2),\" Snap Frame - Sides - Mitered Both Ends\",IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),\" Snap Frame - Sides - Mitered Both Ends\",IF(AND(SNF=2,OR(FT=2,FT=3,FT=4)),\" Large Snap Frame - Sides - Mitered Both Ends\",IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),\" Snap Frame - Sides - Mitered Both Ends\",IF(AND(AND(SNF=2,FT=5,THKNS>=0.125,AND(THKNS<=0.25))),\" Large Snap Frame - Sides - Mitered Both Ends\",\"\"))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(SNF=1,OR(FT=3,FT=4)),\"\",IF(AND(SNF=1,THKNS>=0.126),\"\",IF(AND(SNF=2,OR(FT=1)),\"\",IF(AND(AND(SNF=2,FT=5,THKNS<=0.124)),\"\",IF(AND(SNF=1,FT<=2),KQ*2,IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),KQ*2,IF(AND(SNF=2,OR(FT=2,FT=3,FT=4)),KQ*2,IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),KQ*2,IF(AND(AND(SNF=2,FT=5,THKNS>=0.125,AND(THKNS<=0.25))),KQ*2,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(SNF=1,OR(FT=3,FT=4)),\"\",IF(AND(SNF=1,THKNS>=0.126),\"\",IF(AND(SNF=2,OR(FT=1)),\"\",IF(AND(AND(SNF=2,FT=5,THKNS<=0.124)),\"\",IF(AND(SNF=1,FT<=2),Wdt-0.08,IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),Wdt-0.08,IF(AND(SNF=2,OR(FT=2,FT=3,FT=4)),Wdt-0.08,IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),Wdt-0.08,IF(AND(AND(SNF=2,FT=5,THKNS>=0.125,AND(THKNS<=0.25))),Wdt-0.08,\"\"))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(AND(SNF=1,OR(FT=3,FT=4)),\"\",IF(AND(SNF=1,THKNS>=0.126),\"\",IF(AND(SNF=2,OR(FT=1)),\"\",IF(AND(AND(SNF=2,FT=5,THKNS<=0.124)),\"\",IF(AND(SNF=1,FT<=2),\"1899\",IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),\"1899\",IF(AND(SNF=2,OR(FT=2,FT=3,FT=4)),\"1898\",IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),\"1899\",IF(AND(AND(SNF=2,FT=5,THKNS>=0.125,AND(THKNS<=0.25))),\"1898\",\"\"))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(SNF=1,OR(FT=3,FT=4)),\" Use Large Snap Frame for face material 1/8'' (.125) or greater in total thickness.\",IF(AND(SNF=1,THKNS>=0.126),\" Use Large Snap Frame for face material 1/8'' (.125) or greater in total thickness.\",IF(AND(SNF=2,OR(FT=1)),\" Use Snap Frame for face material 1/8'' (.125) or less in total thickness.\",IF(AND(AND(SNF=2,FT=5,THKNS<=0.124)),\" Use Snap Frame for face material 1/8'' (.125) or less in total thickness.\",IF(AND(SNF=1,FT<=2),\" Snap Frame - Top and Bottom - Mitered Both Ends\",IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),\" Snap Frame - Top and Bottom- Mitered Both Ends\",IF(AND(SNF=2,OR(FT=2,FT=3,FT=4)),\" Large Snap Frame - Top and Bottom - Mitered Both Ends\",IF(AND(AND(SNF=1,FT=5,THKNS>=0.01,AND(THKNS<=0.125))),\" Snap Frame - Top and Bottom - Mitered Both Ends\",IF(AND(AND(SNF=2,FT=5,THKNS>=0.125,AND(THKNS<=0.25))),\" Large Snap 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,"Snap Frame Cover",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,"Snap Frame Cover",null,1,{"$f":"IF(MPP=1,\"\",IF(MPP=2,\"A\"))","v":""},"Anodized"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(SNFC=1,KQ*2,IF(SNFC=2,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(SNFC=1,Hgt,IF(SNFC=2,Hgt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(SNFC=1,\"1896\"&PPTD,IF(SNFC=2,\"1895\"&PPTD,\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(SNFC=1,\" Snap Frame Radius Cover - Sides - Mitered Both Ends\",IF(SNFC=2,\" Snap Frame Flat Cover - Sides - Mitered both ends\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(SNFC=1,KQ*2,IF(SNFC=2,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(SNFC=1,Wdt,IF(SNFC=2,Wdt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(SNFC=1,\"1896\"&PPTD,IF(SNFC=2,\"1895\"&PPTD,\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(SNFC=1,\" Snap Frame Radius Cover - Sides - Mitered Both Ends\",IF(SNFC=2,\" Snap Frame Flat Cover - Sides - 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(SNF=1,KQ,IF(SNF=2,KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(zclp=2,\"\",IF(SNF=1,Wdt-1.5,IF(SNF=2,Wdt-1.5,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(zclp=2,\"\",IF(SNF=1,\"3099\",IF(SNF=2,\"3099\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(zclp=2,\"\",IF(SNF=1,\" Z-Clip - Straight Cut Both Ends\",IF(SNF=2,\" Z-Clip - Straight Cut Both Ends\",\"\"))))","v":""}]
[]
[null,"Hardware"]
[]
[null,"Snap Frame Hardware"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(SNF<=2,4*KQ,\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(SNF<=2,\"5890\",\"\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(SNF<=2,\" 2 Piece Corner Key - 1-1/2'' x 1-1/2'' - One (1) per corner\",\"\"))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(SNF<=2,HWCLPS*KQ,\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(SNFC=1,\"5892\",IF(SNFC=2,\"5893\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(SNF<=2,\" Snap Frame Spring - 1-1/16'' x 1-1/16'' Stainless Steel - One (1) every 18'' on center\",\"\"))","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,null," "]
[null,{"$f":"IF(KQ=0,\"\",IF(SNF<=2,KQ*2,\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(SNF<=2,\"5890-Scrw\",\"\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(SNF<=2,\" Extra - 2 Piece Corner Key Screws\",\"\"))","v":""}]
[]
[]
[null,"Face Trim Size - Visual Openings"]
[]
[null,"Face Trim Size",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,"Springs"]
[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,"Height ",{"$f":"IF(Hgt<=17.9375,\"2\",ROUNDUP(Hgt/17.9375,0))","v":"2"},{"$f":"HCLP*2","v":4}]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(SNF<=2,Hgt-1.75,\"\"))","v":""},null,"Height",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(SNF<=2,Wdt-1.75,\"\"))","v":""},null,"Width",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Width ",{"$f":"IF(Wdt<=17.9375,\"2\",ROUNDUP(Wdt/17.9375,0))","v":"2"},{"$f":"WCLP*2","v":4}]
[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,"Total Spring Clips ",null,{"$f":"HSPCLP+WSPCLP","v":8}]
[]
[null,"Visual Opening"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(SNF=1,SNFC=1),Hgt-2.625,IF(AND(SNF=1,SNFC=2),Hgt-2.5,IF(AND(SNF=2,SNFC=1),Hgt-2.625,IF(AND(SNF=2,SNFC=2),Hgt-2.5,\"\")))))","v":""},null,"Height",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(SNF=1,SNFC=1),Wdt-2.625,IF(AND(SNF=1,SNFC=2),Wdt-2.5,IF(AND(SNF=2,SNFC=1),Wdt-2.625,IF(AND(SNF=2,SNFC=2),Wdt-2.5,\"\")))))","v":""},null,"Width"]