{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Flat Bleed D-F Body","Flex Face Dimensions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":12,"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":"Flat Bleed D-F Body","index":0,"n_rows":35,"n_cols":36,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,1,2,28],[4,1,4,28],[23,5,23,6],[23,2,23,3],[21,1,21,28],[22,2,22,3],[22,5,22,6],[23,7,23,25],[22,7,22,25],[17,7,17,25],[18,2,18,3],[8,18,8,24],[9,1,9,25],[7,26,11,26],[25,1,25,28],[16,2,16,3],[10,5,10,6],[17,2,17,3],[10,11,10,12],[10,7,10,10],[7,27,11,27],[7,28,11,28],[7,1,7,25],[10,19,10,25],[30,2,30,3],[30,4,30,25],[1,1,1,28],[16,5,16,6],[16,7,16,28],[10,1,10,4],[5,1,5,28],[6,1,6,28],[3,1,3,28],[8,1,8,4],[8,5,8,13],[11,1,11,18],[8,14,8,17],[14,1,14,28],[12,1,12,28],[13,1,13,28],[31,1,31,28],[5,34,5,35],[5,30,5,32],[19,1,19,28],[26,1,26,28],[24,1,24,28],[10,13,10,16],[18,5,18,6],[20,1,20,28],[18,7,18,25],[17,5,17,6],[15,1,15,28],[10,17,10,18],[27,1,27,28],[28,1,28,28],[29,1,29,28],[32,1,32,28],[34,2,34,3],[34,4,34,25],[35,1,35,28],[33,1,33,28]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"AE6&AH6&AI6","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(BodTyp=1,\"Flat Bleed Double Face Tension Body\",\"\"))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Cvr=1,\" with\",\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(Cvr=1,\" Flat Bleed Double Face Tension 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,"Lengths Required","Lengths Used","Drops Used"]
[null,"Customer  ",null,null,null,null,null,null,null,null,null,null,null,null,"Order#   "]
[]
[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,"Body",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,"Body Type",1,"Body"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,Hgt-0.254,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"2230\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\" Flat Bleed Double Face Body - Mitered Both Ends - Sides/Ends\",\"\"\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,Wdt-0.254,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"2230\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\" Flat Bleed Double Face Body - Mitered Both Ends - Top and Bottom\",\"\"\"\")))","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,"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,"Cover Type",1,"Cover"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,Hgt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,\"2235\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,\" Flat Bleed Double Face Tension Cover - Mitered Both Ends - Sides/Ends\",\"\"\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,Wdt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,\"2235\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,\" Flat Bleed Double Face Tension Cover - Mitered Both Ends - Top and Bottom\",\"\"\"\")))","v":""}]
[]
[]
[null,"Hardware"]
[]
[null,"Cover"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,(CvrScr+2)*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,\"5270\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(CvrTyp=1,\"\",IF(Cvr=1,\" Cover Screw - #8 x 1-1/2'' Stainless Sq/Phillips Countersink Screw - One (1) every 24'' 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,{"$f":"IF(KQ=0,\"\",SUM(AF31:AI31))","v":""},{"$f":"IF(KQ=0,\"\",(ROUNDUP(Hgt/24,0)+1))","v":""},{"$f":"IF(KQ=0,\"\",(ROUNDUP(Wdt/24,0)+1))","v":""},{"$f":"IF(KQ=0,\"\",(ROUNDUP(Hgt/24,0)+1))","v":""},{"$f":"IF(KQ=0,\"\",(ROUNDUP(Wdt/24,0)+1))","v":""},"Cover Screws"]
[]
[null,"Tension Clips"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,TClps*KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"5360\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\" Tension Clips - One (1) Clip every 5'' 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,{"$f":"IF(KQ=0,\"\",SUM(AF35:AI35))","v":""},{"$f":"IF(KQ=0,\"\",(ROUNDDOWN(Hgt/5,0)+1))","v":""},{"$f":"IF(KQ=0,\"\",(ROUNDDOWN(Wdt/5,0)+1))","v":""},{"$f":"IF(KQ=0,\"\",(ROUNDDOWN(Hgt/5,0)+1))","v":""},{"$f":"IF(KQ=0,\"\",(ROUNDDOWN(Wdt/5,0)+1))","v":""},"Tension Clips"]

{"sheet":"Flex Face Dimensions","index":1,"n_rows":58,"n_cols":31,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,1,54,28],[55,7,55,12],[55,13,55,14],[55,15,55,24],[34,1,34,28],[35,1,35,28],[52,1,52,28],[53,8,53,12],[53,13,53,14],[53,15,53,24],[33,1,33,28],[30,3,30,9],[30,10,30,11],[30,13,30,19],[30,20,30,21],[30,22,30,28],[31,1,31,28],[32,3,32,9],[32,10,32,11],[32,13,32,19],[32,20,32,21],[32,22,32,28],[28,3,28,9],[28,10,28,11],[28,13,28,19],[28,20,28,21],[28,22,28,28],[7,1,7,28],[57,7,57,12],[57,13,57,14],[57,15,57,26],[1,1,1,28],[2,1,2,28],[3,1,3,28],[4,1,5,28],[6,1,6,28],[29,1,29,28],[8,1,8,28],[25,1,25,28],[26,1,26,4],[26,5,26,21],[26,22,26,28],[27,1,27,28]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Face Trim Size Calculations"]
[]
[]
[]
[]
[]
[]
[]
[]
[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,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Frame Type:",null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodTyp=1,\" Flat Bleed Double Face Tension Body and Cover\",\"\"))","v":""}]
[]
[null,null,null,"Outside Frame dimension (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",Hgt))","v":""},null,null,"Outside Frame Dimension (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",Wdt))","v":""}]
[]
[null,null,null,"Visual Opening (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,Hgt-0.184,\"\")))","v":""},null,null,"Visual Opening (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,Wdt-0.184,\"\")))","v":""}]
[]
[null,null,null,"Face Trim Size (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,Hgt+6.5,\"\")))","v":""},null,null,"Face Trim Size (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,Wdt+6.5,\"\")))","v":""}]
[]
[]
[null,"Clip Line Calculations"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Clip Line Placement ",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"1-1/2''\",\"\")))","v":""},null,"(In from the trimmed edge of the face.)"]
[]
[null,null,null,null,null,null,null,"Clip Spacing ",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"5''\",\"\")))","v":""},null,"(Center to Center)"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodTyp=1,\"Tensioning Tool \",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"5135\",\"\")))","v":""},null,"(See Commercial Catalog Pg. 13 or Contact Customer Service)"]