{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Changes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":19,"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":"Instructions","index":0,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[8,2,8,7],[31,3,31,4]]}
["Manufacturer","ConestogaLVT"]
["File as","C"]
["Product Code","L"]
["CCTD Effective Date","1/1/24 (Updated)"]
["Enter \"MKTG\" in discount for Customers who have invested in a display.  For Others enter '0%\"",null,null,null,null,null,null,null,"MKTG"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Product Code","All LVT","Setting Materials","Care & Maint."]
[null,null,"Displayed","Stock Disc %","Stock Disc %"]
[null,{"$f":"+B3","v":"L"},0,0,0]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Glue-Down",null,"Yes",0]
[null,2,null,"Rigid Core",null,"Yes",0]
[null,3,null,"Loose Lay",null,"Yes",0]
[null,4,null,null,null,"Yes",0]
[null,5,null,"Design Strips",null,"Yes",0]
[null,6,null,"Care & Maintenance",null,"Yes",0]
[null,7,null,"Setting Material",null,"Yes",0]
[null,8,null,null,null,"Yes",0]
[null,9,null,null,null,"Yes",0]
[]
["If you want to manually adjust your price list, hit \"F5\" and go to \"Customer_Cost\" to manually adjust pricing."]
["You can enter a value in the column labeled \"Adj.\" to change your price manually."]
[]
[null,"Click on \"Your Price Calculation\" to set the print area for your personal cost calculation report."]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Your Price List\" to set the print area for your personal price list."]
[null,"Then you can send it to print"]
[null,null,null,null,null,null,null,"Yes"]
[]
["If you have any questions on how to best use this spreadsheet, please feel free to contact"]
["Jim Vogel at (800) 422-6860, ext. 4201 or via e-mail at jimvogel@cctd.com"]

{"sheet":"Index","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,0,5,10],[2,5,2,10],[48,0,48,10],[50,0,50,10]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'C' - ConestogaLVT"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 1/1/24 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
["The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom.  Print out individual price list for each series that can be attached to the back of your sample boards for easy reference."]

{"sheet":"Price List","index":2,"n_rows":206,"n_cols":44,"rows_kept":206,"cut":false,"hidden":false,"merged":[[14,29,14,31],[15,19,15,21],[191,3,191,17],[125,3,125,17],[130,3,130,17],[142,3,142,17],[158,3,158,17],[18,3,18,17]]}
[null,"A1","Glue-Down",null,null,"Size",null,"Field",null,null,null,null,null,null,null,"SF/CTN",null,null,null,0.05,"SF",0.05,null,0.05,{"$f":"+Instructions!$C$17","v":0},null,"new",{"$f":"+T1","v":0.05},{"$f":"(AF1-AB1)/AF1","v":0},null,1,{"$f":"SUM(AM1:AO1)+AD1","v":0.05},null,null,{"$f":"+AF1","v":0.05},{"$f":"+U1","v":"SF"},null,null,{"$f":"ROUND(AB1/(1-VLOOKUP(AE1,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AE1,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM1,1)-AM1,2),Round,2,FALSE)+VLOOKUP(AE1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE1,Group,7,FALSE)=\"\",0,ROUND(AM1-0.04999,1)-AM1+AP1)","v":0},{"$f":"IF(VLOOKUP(AE1,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE1,Group,7,FALSE))","v":""},null,"X"]
[null,"A2","Rigid Core",null,null,"Size",null,"Field",null,null,null,null,null,null,null,"SF/CTN",null,null,null,0.05,"SF",0.05,null,0.05,{"$f":"+Instructions!$C$17","v":0},null,"new",0.05,{"$f":"(AF2-AB2)/AF2","v":0},null,2,{"$f":"SUM(AM2:AO2)+AD2","v":0.05},null,null,{"$f":"+AF2","v":0.05},"SF",null,null,{"$f":"ROUND(AB2/(1-VLOOKUP(AE2,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AE2,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM2,1)-AM2,2),Round,2,FALSE)+VLOOKUP(AE2,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE2,Group,7,FALSE)=\"\",0,ROUND(AM2-0.04999,1)-AM2+AP2)","v":0},{"$f":"IF(VLOOKUP(AE2,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE2,Group,7,FALSE))","v":""},null,"X"]
[null,"A3","Loose Lay",null,null,"Size",null,"Field",null,null,null,null,null,null,null,"SF/CTN",null,null,null,0.05,"SF",0.05,null,0.05,{"$f":"+Instructions!$C$17","v":0},null,"new",0.05,0,null,3,0.05,null,null,0.05,"SF",null,null,0.05,0,0,"",null,"X"]
[null,"C4","Trim",null,null,"Size",null,"Shape",null,null,null,null,null,null,null,null,null,null,null,0.05,"EA",0.05,null,0.05,{"$f":"+Instructions!$C$17","v":0},null,"new",0.05,{"$f":"(AF4-AB4)/AF4","v":0},null,4,{"$f":"SUM(AM4:AO4)+AD4","v":0.05},null,null,{"$f":"+AF4","v":0.05},"EA",null,null,{"$f":"ROUND(AB4/(1-VLOOKUP(AE4,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AE4,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM4,1)-AM4,2),Round,2,FALSE)+VLOOKUP(AE4,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE4,Group,7,FALSE)=\"\",0,ROUND(AM4-0.04999,1)-AM4+AP4)","v":0},{"$f":"IF(VLOOKUP(AE4,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE4,Group,7,FALSE))","v":""},null,"X"]
[null,"A5","Design Strip",null,null,"Size",null,"Shape",null,null,null,null,null,null,null,null,null,null,null,0.05,"EA",0,null,0.05,{"$f":"+Instructions!$C$17","v":0},null,"new",0.05,0,null,5,0.05,null,null,0.05,"EA",null,null,0.05,0,0,"",null,"X"]
[null,"A6","Care & Maintenance",null,null,"Size",null,"Shape",null,null,null,null,null,null,null,null,null,null,null,0.05,"EA",0,null,0.05,{"$f":"+Instructions!$E$17","v":0},null,"new",0.05,{"$f":"(AF6-AB6)/AF6","v":0},null,6,{"$f":"SUM(AM6:AO6)+AD6","v":0.05},null,null,{"$f":"+AF6","v":0.05},"EA",null,null,{"$f":"ROUND(AB6/(1-VLOOKUP(AE6,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AE6,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM6,1)-AM6,2),Round,2,FALSE)+VLOOKUP(AE6,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE6,Group,7,FALSE)=\"\",0,ROUND(AM6-0.04999,1)-AM6+AP6)","v":0},{"$f":"IF(VLOOKUP(AE6,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE6,Group,7,FALSE))","v":""},null,"X"]
[null,"A7","Setting Material",null,null,"Size",null,"Description",null,null,null,null,null,null,null,null,null,null,null,0.05,"EA",0,null,0.05,{"$f":"+Instructions!$D$17","v":0},null,"new",0.05,0,null,7,0.05,null,null,0.05,"EA",null,null,0.05,0,0,"",null,"X"]
[null,null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","a",null,1000,"ABC",1000,null,1000,0.1,null,"ABC",1000,0.1,10,null,1000,null,null,1000,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Customer Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Calc",null,null,"Customer Selling Price Calculation",null,null,null,null,null," ","Retail P/L",null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'C' - ConestogaLVT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,null,null,null,null,null,null,null,{"$f":"+$D$13","v":"File 'C' - ConestogaLVT"},null,null,null,"Price List",null,null,null,null,null,null,null,"X"]
[null,null,null,{"$f":"IF(Instructions!C9=\"\",\"\",+Instructions!C9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/1/24 (Updated)",null,null,null,null,null,null,null,null,null,"Retail Price Calculations",null,null,null,{"$f":"+Instructions!$B$4","v":"1/1/24 (Updated)"},null,null,null,null,null,null,null,"X"]
[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":"TODAY()","v":"2024-02-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code 'L'"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Cost",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$C$9=\"\",\"\",Instructions!$C$9)","v":""},null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",null,"Net Unit","U/M",">1000 sf",null,"Unit Cost","Disc.",null,"Chg","Net Cost","GP%","Adj.","Group","Price",null,null,"List Price","U/M",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,null,"ALL ITEMS MARKED WITH PACKAGING QUANTITY ARE SOLD IN MULTIPLES OF THAT QUANTITY ONLY",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,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"BEL AIR - Luxury Vinyl Tiles",null,null,null,null,null,null,"Discontinued 2/6/24",null,null,null,null,"Item # Lookup:","COBE",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","CONT200 Brown Stone",null,null,null,"  CONT203 Granite Stone",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,null,null,null,"X"]
[null,null,null,null,null,"CONT202 Chalk Stone",null,null,null,"  CONT201 Misty Stone",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,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A1","Glue-Down",null,null,"18\" x 18\" x 2.5mm",null,"20mil",null,"Glue-Down",null,null,null,null,null,"36.00 SF/CTN","Stock",null,null,3.35,"SF",3.0199999999999996,null,3.35,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T26","v":3.35},{"$f":"(AF26-AB26)/AF26","v":0},null,1,{"$f":"SUM(AM26:AO26)+AD26","v":3.35},null,null,{"$f":"+AF26","v":3.35},{"$f":"+U26","v":"SF"},null,null,{"$f":"ROUND(AB26/(1-VLOOKUP(AE26,Group,2,FALSE)),2)","v":3.35},{"$f":"IF(VLOOKUP(AE26,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM26,1)-AM26,2),Round,2,FALSE)+VLOOKUP(AE26,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE26,Group,7,FALSE)=\"\",0,ROUND(AM26-0.04999,1)-AM26+AP26)","v":0},{"$f":"IF(VLOOKUP(AE26,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE26,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"BLOOMINGDALE - Luxury Vinyl Plank",null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","COBL",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","COBLANT Antique Willow          COBLENG English Toffee          COBLSED Sedona",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,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"B2","Rigid Core",null,null,"9\" x 60\" x 7.0mm",null,"20mil",null,"Rigid Core - WPC",null,null,null,null,null,"33.75 SF/CTN","Stock",null,null,4,"SF",3.6,null,4,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T32","v":4},{"$f":"(AF32-AB32)/AF32","v":0},null,2,{"$f":"SUM(AM32:AO32)+AD32","v":4},null,null,{"$f":"+AF32","v":4},{"$f":"+U32","v":"SF"},null,null,{"$f":"ROUND(AB32/(1-VLOOKUP(AE32,Group,2,FALSE)),2)","v":4},{"$f":"IF(VLOOKUP(AE32,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM32,1)-AM32,2),Round,2,FALSE)+VLOOKUP(AE32,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE32,Group,7,FALSE)=\"\",0,ROUND(AM32-0.04999,1)-AM32+AP32)","v":0},{"$f":"IF(VLOOKUP(AE32,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE32,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"BLOSSOM HILL - Luxury Vinyl Plank",null,null,null,null,null,null,"Discontinued 2/6/24",null,null,null,null,"Item # Lookup:","COBH",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","CON148 Ash Oak",null,null,null,"CON123 Harvest Oak",null,null,null,"CON120 Puritan Oak",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,"X"]
[null,null,null,null,null,"CON128 Carbon Oak",null,null,null,"CON150 Midtone Oak",null,null,null,"CON145 Sandy Oak",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,"X"]
[null,null,null,null,null,"CON151 Earthy Oak",null,null,null,"CON142 Mountain Oak",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,null,null,null,"X"]
[null,null,null,null,null,"CON121 Grey Oak",null,null,null,"CON147 Pale Oak",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,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A1","Glue-Down",null,null,"7\" x 48\" x 2.0mm",null,"12mil",null,"Glue-Down",null,null,null,null,null,"51.34 SF/CTN","Stock",null,null,2.7,"SF",2.4300000000000002,null,2.7,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T41","v":2.7},{"$f":"(AF41-AB41)/AF41","v":0},null,1,{"$f":"SUM(AM41:AO41)+AD41","v":2.7},null,null,{"$f":"+AF41","v":2.7},{"$f":"+U41","v":"SF"},null,null,{"$f":"ROUND(AB41/(1-VLOOKUP(AE41,Group,2,FALSE)),2)","v":2.7},{"$f":"IF(VLOOKUP(AE41,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM41,1)-AM41,2),Round,2,FALSE)+VLOOKUP(AE41,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE41,Group,7,FALSE)=\"\",0,ROUND(AM41-0.04999,1)-AM41+AP41)","v":0},{"$f":"IF(VLOOKUP(AE41,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE41,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","CONLL148 Ash Oak",null,null,null,"CONLL123 Harvest Oak",null,null,null,"CONLL120 Puritan Oak",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,"X"]
[null,null,null,null,null,"CONLL128 Carbon Oak",null,null,null,"CONLL150 Midtone Oak",null,null,null,"CONLL145 Sandy Oak",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,"X"]
[null,null,null,null,null,"CONLL151 Earthy Oak",null,null,null,"CONLL142 Mountain Oak",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,null,null,null,"X"]
[null,null,null,null,null,"CONLL121 Grey Oak",null,null,null,"CONLL147 Pale Oak",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,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A3","Loose Lay",null,null,"9.9\" x 41.3\" x 4.5mm",null,"20mil",null,"Loose Lay",null,null,null,null,null,"33.90 SF/CTN","Stock",null,null,5.0999999999999996,"SF",4.59,null,5.0999999999999996,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T48","v":5.0999999999999996},{"$f":"(AF48-AB48)/AF48","v":0},null,3,{"$f":"SUM(AM48:AO48)+AD48","v":5.0999999999999996},null,null,{"$f":"+AF48","v":5.0999999999999996},{"$f":"+U48","v":"SF"},null,null,{"$f":"ROUND(AB48/(1-VLOOKUP(AE48,Group,2,FALSE)),2)","v":5.0999999999999996},{"$f":"IF(VLOOKUP(AE48,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM48,1)-AM48,2),Round,2,FALSE)+VLOOKUP(AE48,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE48,Group,7,FALSE)=\"\",0,ROUND(AM48-0.04999,1)-AM48+AP48)","v":0},{"$f":"IF(VLOOKUP(AE48,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE48,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","CONRC148 Ash Oak",null,null,null,"CONRC123 Harvest Oak",null,null,null,"CONRC120 Puritan Oak",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,"X"]
[null,null,null,null,null,"CONRC128 Carbon Oak",null,null,null,"CONRC150 Midtone Oak",null,null,null,"CONRC145 Sandy Oak",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,"X"]
[null,null,null,null,null,"CONRC151 Earthy Oak",null,null,null,"CONRC142 Mountain Oak",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,null,null,null,"X"]
[null,null,null,null,null,"CONRC121 Grey Oak",null,null,null,"CONRC147 Pale Oak",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,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A2","Rigid Core",null,null,"7\" x 48\" x 4.5mm",null,"12mil",null,"Rigid Core",null,null,null,null,null,"26.56 SF/CTN","Stock",null,null,4.0999999999999996,"SF",3.69,null,4.0999999999999996,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T55","v":4.0999999999999996},{"$f":"(AF55-AB55)/AF55","v":0},null,2,{"$f":"SUM(AM55:AO55)+AD55","v":4.0999999999999996},null,null,{"$f":"+AF55","v":4.0999999999999996},{"$f":"+U55","v":"SF"},null,null,{"$f":"ROUND(AB55/(1-VLOOKUP(AE55,Group,2,FALSE)),2)","v":4.0999999999999996},{"$f":"IF(VLOOKUP(AE55,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM55,1)-AM55,2),Round,2,FALSE)+VLOOKUP(AE55,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE55,Group,7,FALSE)=\"\",0,ROUND(AM55-0.04999,1)-AM55+AP55)","v":0},{"$f":"IF(VLOOKUP(AE55,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE55,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"DEL RAY - Luxury Vinyl Plank",null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CODR",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","CODRASH Ash          CODRBAR Barnwood          CODRCAY Cayenne",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,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"B2","Rigid Core",null,null,"7\" x 48\" x 7.5mm",null,"20mil",null,"Rigid Core - WPC",null,null,null,null,null,"33.09 SF/CTN","Stock","a",null,4.2,"SF",3.78,null,4.2,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T61","v":4.2},{"$f":"(AF61-AB61)/AF61","v":0},null,2,{"$f":"SUM(AM61:AO61)+AD61","v":4.2},null,null,{"$f":"+AF61","v":4.2},{"$f":"+U61","v":"SF"},null,null,{"$f":"ROUND(AB61/(1-VLOOKUP(AE61,Group,2,FALSE)),2)","v":4.2},{"$f":"IF(VLOOKUP(AE61,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM61,1)-AM61,2),Round,2,FALSE)+VLOOKUP(AE61,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE61,Group,7,FALSE)=\"\",0,ROUND(AM61-0.04999,1)-AM61+AP61)","v":0},{"$f":"IF(VLOOKUP(AE61,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE61,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Note:","a) Packaging is changing from 18.91 SF/CTN to 33.09 SF/CTN as inventory with old packaging is depleted.",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,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"FEDERAL HILL - Luxury Vinyl Plank",null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","COFH",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","COFHESP Espresso",null,null,null,"COFHKIN Kings Canyon",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,null,null,null,"X"]
[null,null,null,null,null,"COFHHEM Hemlock",null,null,null,"COFHRIV River Birch",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,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"B2","Rigid Core",null,null,"7\" x 48\" x 5.0mm",null,"20mil",null,"Rigid Core - SPC",null,null,null,null,null,"23.64 SF/CTN","Stock",null,null,3.4,"SF",3.06,null,3.4,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T70","v":3.4},{"$f":"(AF70-AB70)/AF70","v":0},null,2,{"$f":"SUM(AM70:AO70)+AD70","v":3.4},null,null,{"$f":"+AF70","v":3.4},{"$f":"+U70","v":"SF"},null,null,{"$f":"ROUND(AB70/(1-VLOOKUP(AE70,Group,2,FALSE)),2)","v":3.4},{"$f":"IF(VLOOKUP(AE70,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM70,1)-AM70,2),Round,2,FALSE)+VLOOKUP(AE70,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE70,Group,7,FALSE)=\"\",0,ROUND(AM70-0.04999,1)-AM70+AP70)","v":0},{"$f":"IF(VLOOKUP(AE70,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE70,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Note:","a) This item is transitioning from 6.0mm to 5.0mm in thickness as inventories of the old thickness are depleted.",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,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,"(Packaging for the old 7\" x 48\" x 6.0mm is 18.91 SF/CTN.)   Check with Customer Service to be sure which",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,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,"packaging amount you will be receiving.",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,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"MICHAUX - Luxury Vinyl Plank w/ QXT Technology",null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","COMI",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","Amsterdam",null,"Cancun",null,"      Dublin",null," Tulum",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,null,"X"]
[null,null,null,null,null,"Berlin",null,"Copa",null,"      Sydney",null," Venice"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"C2","Rigid Core",null,null,"7\" x 48\" x 4.7mm",null,"12mil",null,"Rigid Core - SPC",null,null,null,null,null,"28.37 SF/CTN","Stock",null,null,2.9,"SF",2.61,null,2.9,{"$f":"+Instructions!$C$17","v":0},null,"new",{"$f":"+T81","v":2.9},{"$f":"(AF81-AB81)/AF81","v":0},null,2,{"$f":"SUM(AM81:AO81)+AD81","v":2.9},null,null,{"$f":"+AF81","v":2.9},{"$f":"+U81","v":"SF"},null,null,{"$f":"ROUND(AB81/(1-VLOOKUP(AE81,Group,2,FALSE)),2)","v":2.9},{"$f":"IF(VLOOKUP(AE81,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM81,1)-AM81,2),Round,2,FALSE)+VLOOKUP(AE81,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE81,Group,7,FALSE)=\"\",0,ROUND(AM81-0.04999,1)-AM81+AP81)","v":0},{"$f":"IF(VLOOKUP(AE81,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE81,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"C4","Trim",null,null,"7'10\" long",null,null,null,"3-in-1 Molding",null,null,null,null,null,null,null,null,null,34.799999999999997,"EA",null,null,34.799999999999997,{"$f":"+Instructions!$C$17","v":0},null,"new",{"$f":"+T83","v":34.799999999999997},{"$f":"(AF83-AB83)/AF83","v":0},null,4,{"$f":"SUM(AM83:AO83)+AD83","v":34.799999999999997},null,null,{"$f":"+AF83","v":34.799999999999997},{"$f":"+U83","v":"EA"},null,null,{"$f":"ROUND(AB83/(1-VLOOKUP(AE83,Group,2,FALSE)),2)","v":34.799999999999997},{"$f":"IF(VLOOKUP(AE83,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM83,1)-AM83,2),Round,2,FALSE)+VLOOKUP(AE83,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE83,Group,7,FALSE)=\"\",0,ROUND(AM83-0.04999,1)-AM83+AP83)","v":0},{"$f":"IF(VLOOKUP(AE83,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE83,Group,7,FALSE))","v":""},null,"X"]
[null,"C4","Trim",null,null,"7'10\" long",null,null,null,"Flush Stair Nose",null,null,null,null,null,null,null,null,null,73.3,"EA",null,null,73.3,{"$f":"+Instructions!$C$17","v":0},null,"new",{"$f":"+T84","v":73.3},0,null,4,73.3,null,null,73.3,{"$f":"+U84","v":"EA"},null,null,73.3,0,0,"",null,"X"]
[]
[null,null,null,"PATAPSCO - Luxury Vinyl Plank w/ QXT Technology",null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","COPA",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","Antiqua","Mile High",null,null,"         Rehoboth",null,"        Venice Beach",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,null,"X"]
[null,null,null,null,null,"Mancora","Palomino",null,null,"         Santorini",null,"        Wildwood Crest"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"C2","Rigid Core",null,null,"7\" x 48\" x 5mm",null,"20mil",null,"Rigid Core - SPC",null,null,null,null,null,"24.03 SF/CTN","Stock",null,null,3.3,"SF",2.97,null,3.3,{"$f":"+Instructions!$C$17","v":0},null,"new",{"$f":"+T91","v":3.3},{"$f":"(AF91-AB91)/AF91","v":0},null,2,{"$f":"SUM(AM91:AO91)+AD91","v":3.3},null,null,{"$f":"+AF91","v":3.3},{"$f":"+U91","v":"SF"},null,null,{"$f":"ROUND(AB91/(1-VLOOKUP(AE91,Group,2,FALSE)),2)","v":3.3},{"$f":"IF(VLOOKUP(AE91,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM91,1)-AM91,2),Round,2,FALSE)+VLOOKUP(AE91,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE91,Group,7,FALSE)=\"\",0,ROUND(AM91-0.04999,1)-AM91+AP91)","v":0},{"$f":"IF(VLOOKUP(AE91,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE91,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"C4","Trim",null,null,"7'10\" long",null,null,null,"3-in-1 Molding",null,null,null,null,null,null,null,null,null,34.799999999999997,"EA",null,null,34.799999999999997,{"$f":"+Instructions!$C$17","v":0},null,"new",{"$f":"+T93","v":34.799999999999997},{"$f":"(AF93-AB93)/AF93","v":0},null,4,{"$f":"SUM(AM93:AO93)+AD93","v":34.799999999999997},null,null,{"$f":"+AF93","v":34.799999999999997},{"$f":"+U93","v":"EA"},null,null,{"$f":"ROUND(AB93/(1-VLOOKUP(AE93,Group,2,FALSE)),2)","v":34.799999999999997},{"$f":"IF(VLOOKUP(AE93,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM93,1)-AM93,2),Round,2,FALSE)+VLOOKUP(AE93,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE93,Group,7,FALSE)=\"\",0,ROUND(AM93-0.04999,1)-AM93+AP93)","v":0},{"$f":"IF(VLOOKUP(AE93,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE93,Group,7,FALSE))","v":""},null,"X"]
[null,"C4","Trim",null,null,"7'10\" long",null,null,null,"Flush Stair Nose",null,null,null,null,null,null,null,null,null,73.3,"EA",null,null,73.3,{"$f":"+Instructions!$C$17","v":0},null,"new",{"$f":"+T94","v":73.3},0,null,4,73.3,null,null,73.3,{"$f":"+U94","v":"EA"},null,null,73.3,0,0,"",null,"X"]
[]
[null,null,null,"PHEASANT HILL - Luxury Vinyl Plank",null,null,null,null,null,null,"Discontinued 2/6/24",null,null,null,null,"Item # Lookup:","COPH",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","CONBU101 Carmel Oak",null,null,null,"CONBU102 Salem Oak",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,null,null,null,"X"]
[null,null,null,null,null,"CONBU103 Chocolate Oak",null,null,null,"CONBU100 Sunny Oak",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,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A1","Glue-Down",null,null,"7\" x 36\" x 2.5mm",null,"20mil",null,"Glue-Down",null,null,null,null,null,"35.63 SF/CTN","Stock",null,null,3.35,"SF",3.0199999999999996,null,3.35,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T101","v":3.35},{"$f":"(AF101-AB101)/AF101","v":0},null,1,{"$f":"SUM(AM101:AO101)+AD101","v":3.35},null,null,{"$f":"+AF101","v":3.35},{"$f":"+U101","v":"SF"},null,null,{"$f":"ROUND(AB101/(1-VLOOKUP(AE101,Group,2,FALSE)),2)","v":3.35},{"$f":"IF(VLOOKUP(AE101,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM101,1)-AM101,2),Round,2,FALSE)+VLOOKUP(AE101,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE101,Group,7,FALSE)=\"\",0,ROUND(AM101-0.04999,1)-AM101+AP101)","v":0},{"$f":"IF(VLOOKUP(AE101,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE101,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"SHENANDOAH - Luxury Vinyl Plank w/ QXT Technology",null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","COSH",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","Biscayne",null,"Brighton",null,"       Loredo",null,"           Oakwood",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,null,"X"]
[null,null,null,null,null,"Blue Sands",null,"Cannes",null,"       Myrtle Beach            Whitehaven"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"C2","Rigid Core",null,null,"7\" x 48\" x 5mm",null,"20mil",null,"Rigid Core - SPC",null,null,null,null,null,"24.03 SF/CTN","Stock",null,null,3.3,"SF",2.97,null,3.3,{"$f":"+Instructions!$C$17","v":0},null,"new",{"$f":"+T108","v":3.3},{"$f":"(AF108-AB108)/AF108","v":0},null,2,{"$f":"SUM(AM108:AO108)+AD108","v":3.3},null,null,{"$f":"+AF108","v":3.3},{"$f":"+U108","v":"SF"},null,null,{"$f":"ROUND(AB108/(1-VLOOKUP(AE108,Group,2,FALSE)),2)","v":3.3},{"$f":"IF(VLOOKUP(AE108,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM108,1)-AM108,2),Round,2,FALSE)+VLOOKUP(AE108,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE108,Group,7,FALSE)=\"\",0,ROUND(AM108-0.04999,1)-AM108+AP108)","v":0},{"$f":"IF(VLOOKUP(AE108,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE108,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"C4","Trim",null,null,"7'10\" long",null,null,null,"3-in-1 Molding",null,null,null,null,null,null,null,null,null,34.799999999999997,"EA",null,null,34.799999999999997,{"$f":"+Instructions!$C$17","v":0},null,"new",{"$f":"+T110","v":34.799999999999997},{"$f":"(AF110-AB110)/AF110","v":0},null,4,{"$f":"SUM(AM110:AO110)+AD110","v":34.799999999999997},null,null,{"$f":"+AF110","v":34.799999999999997},{"$f":"+U110","v":"EA"},null,null,{"$f":"ROUND(AB110/(1-VLOOKUP(AE110,Group,2,FALSE)),2)","v":34.799999999999997},{"$f":"IF(VLOOKUP(AE110,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM110,1)-AM110,2),Round,2,FALSE)+VLOOKUP(AE110,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE110,Group,7,FALSE)=\"\",0,ROUND(AM110-0.04999,1)-AM110+AP110)","v":0},{"$f":"IF(VLOOKUP(AE110,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE110,Group,7,FALSE))","v":""},null,"X"]
[null,"C4","Trim",null,null,"7'10\" long",null,null,null,"Flush Stair Nose",null,null,null,null,null,null,null,null,null,73.3,"EA",null,null,73.3,{"$f":"+Instructions!$C$17","v":0},null,"new",{"$f":"+T111","v":73.3},0,null,4,73.3,null,null,73.3,{"$f":"+U111","v":"EA"},null,null,73.3,0,0,"",null,"X"]
[]
[null,null,null,"SKYLINE DRIVE - Luxury Vinyl Plank",null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","COSK",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","COSKBRI Bristol",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,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A2","Rigid Core",null,null,"7\" x 48\" x 4.2mm",null,"12mil",null,"Rigid Core - SPC",null,null,null,null,null,"23.64 SF/CTN",null,null,null,2.85,"SF",2.57,null,2.85,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T117","v":2.85},{"$f":"(AF117-AB117)/AF117","v":0},null,2,{"$f":"SUM(AM117:AO117)+AD117","v":2.85},null,null,{"$f":"+AF117","v":2.85},{"$f":"+U117","v":"SF"},null,null,{"$f":"ROUND(AB117/(1-VLOOKUP(AE117,Group,2,FALSE)),2)","v":2.85},{"$f":"IF(VLOOKUP(AE117,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM117,1)-AM117,2),Round,2,FALSE)+VLOOKUP(AE117,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE117,Group,7,FALSE)=\"\",0,ROUND(AM117-0.04999,1)-AM117+AP117)","v":0},{"$f":"IF(VLOOKUP(AE117,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE117,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"SUSQUEHANNA - Luxury Vinyl Plank",null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","COSU",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","COSUTAM Tamarack",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,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A2","Rigid Core",null,null,"9\" x 48\" x 7.0mm",null,"20mil",null,"Rigid Core - SPC",null,null,null,null,null,"29.47 SF/CTN",null,null,null,4.0999999999999996,"SF",3.69,null,4.0999999999999996,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T123","v":4.0999999999999996},{"$f":"(AF123-AB123)/AF123","v":0},null,2,{"$f":"SUM(AM123:AO123)+AD123","v":4.0999999999999996},null,null,{"$f":"+AF123","v":4.0999999999999996},{"$f":"+U123","v":"SF"},null,null,{"$f":"ROUND(AB123/(1-VLOOKUP(AE123,Group,2,FALSE)),2)","v":4.0999999999999996},{"$f":"IF(VLOOKUP(AE123,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM123,1)-AM123,2),Round,2,FALSE)+VLOOKUP(AE123,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE123,Group,7,FALSE)=\"\",0,ROUND(AM123-0.04999,1)-AM123+AP123)","v":0},{"$f":"IF(VLOOKUP(AE123,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE123,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"TRIM PIECES",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,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Trim pieces can be purchased through Versatrim.com.  Use the ConestogaLVT Color Number for your product search on",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,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"their website.",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,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"DESIGN STRIPS",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,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"DESIGN STRIPS",null,null,null,null,null,null,null,null," ",null,null,"Item # Lookup:","CODS",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Colors:","Beige",null,"Brown",null,null,"    Ivory",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,null,null,"X"]
[null,null,null,null,null,"Black",null,"Chestnut",null,null,"    Taupe",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,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A5","Design Strip",null,null,"3 mm x 3' x 2.0mm",null,"3' Design Strip",null,null,null,null,null,null,null,"25 EA/CTN",null,null,null,0.8,"EA",null,null,0.8,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T138","v":0.8},{"$f":"(AF138-AB138)/AF138","v":0},null,5,{"$f":"SUM(AM138:AO138)+AD138","v":0.8},null,null,{"$f":"+AF138","v":0.8},{"$f":"+U138","v":"EA"},null,null,{"$f":"ROUND(AB138/(1-VLOOKUP(AE138,Group,2,FALSE)),2)","v":0.8},{"$f":"IF(VLOOKUP(AE138,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM138,1)-AM138,2),Round,2,FALSE)+VLOOKUP(AE138,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE138,Group,7,FALSE)=\"\",0,ROUND(AM138-0.04999,1)-AM138+AP138)","v":0},{"$f":"IF(VLOOKUP(AE138,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE138,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A5","Design Strip",null,null,"3 mm x 3' x 2.5mm",null,"3' Design Strip",null,null,null,null,null,null,null,"25 EA/CTN",null,null,null,1.45,"EA",null,null,1.45,{"$f":"+Instructions!$C$17","v":0},null,"",{"$f":"+T140","v":1.45},{"$f":"(AF140-AB140)/AF140","v":0},null,5,{"$f":"SUM(AM140:AO140)+AD140","v":1.45},null,null,{"$f":"+AF140","v":1.45},{"$f":"+U140","v":"EA"},null,null,{"$f":"ROUND(AB140/(1-VLOOKUP(AE140,Group,2,FALSE)),2)","v":1.45},{"$f":"IF(VLOOKUP(AE140,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM140,1)-AM140,2),Round,2,FALSE)+VLOOKUP(AE140,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE140,Group,7,FALSE)=\"\",0,ROUND(AM140-0.04999,1)-AM140+AP140)","v":0},{"$f":"IF(VLOOKUP(AE140,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE140,Group,7,FALSE))","v":""},null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"SETTING MATERIALS",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,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"DRYSET ADHESIVE",null,null,null,null,null,null,null,null," ",null,null,"Item # Lookup:","COSM",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A7","Setting Material",null,null,"1 Gallon",null,"Karndean DrySet - One Coat-Roller applied LVT Adhesive",null,null,null,null,null,null,null,null,"Stock","a",null,83.3,"EA",null,null,83.3,{"$f":"+Instructions!$D$17","v":0},null,"",{"$f":"+T147","v":83.3},{"$f":"(AF147-AB147)/AF147","v":0},null,7,{"$f":"SUM(AM147:AO147)+AD147","v":83.3},null,null,{"$f":"+AF147","v":83.3},{"$f":"+U147","v":"EA"},null,null,{"$f":"ROUND(AB147/(1-VLOOKUP(AE147,Group,2,FALSE)),2)","v":83.3},{"$f":"IF(VLOOKUP(AE147,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM147,1)-AM147,2),Round,2,FALSE)+VLOOKUP(AE147,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE147,Group,7,FALSE)=\"\",0,ROUND(AM147-0.04999,1)-AM147+AP147)","v":0},{"$f":"IF(VLOOKUP(AE147,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE147,Group,7,FALSE))","v":""},null,"X"]
[null,"A7","Setting Material",null,null,"4 Gallon",null,"Karndean DrySet - One Coat-Roller applied LVT Adhesive",null,null,null,null,null,null,null,null,"Stock","a",null,305.14999999999998,"EA",null,null,305.14999999999998,{"$f":"+Instructions!$D$17","v":0},null,"",{"$f":"+T148","v":305.14999999999998},0,null,7,305.14999999999998,null,null,305.14999999999998,{"$f":"+U148","v":"EA"},null,null,305.14999999999998,0,0,"",null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Note:","a) Approximate Coverage: 350-450 SF per Gallon",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,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"UNDERLAYMENT",null,null,null,null,null,null,null,null," ",null,null,"Item # Lookup:","COSM",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A7","Setting Material",null,null,"100 SF Roll",null,"Karndean Quiet Choice LVT Acoustic Underlayment",null,null,null,null,null,null,null,null,null,null,null,62.1,"EA",null,null,62.1,{"$f":"+Instructions!$D$17","v":0},null,"",{"$f":"+T154","v":62.1},{"$f":"(AF154-AB154)/AF154","v":0},null,7,{"$f":"SUM(AM154:AO154)+AD154","v":62.1},null,null,{"$f":"+AF154","v":62.1},{"$f":"+U154","v":"EA"},null,null,{"$f":"ROUND(AB154/(1-VLOOKUP(AE154,Group,2,FALSE)),2)","v":62.1},{"$f":"IF(VLOOKUP(AE154,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM154,1)-AM154,2),Round,2,FALSE)+VLOOKUP(AE154,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE154,Group,7,FALSE)=\"\",0,ROUND(AM154-0.04999,1)-AM154+AP154)","v":0},{"$f":"IF(VLOOKUP(AE154,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE154,Group,7,FALSE))","v":""},null,"X"]
[null,"A7","Setting Material",null,null,"Kit",null,"Kovara 95",null,null,"1 Kovara 95 roll (720sf) + 1 roll 2\" GREY tape",null,null,null,null,null,null,null,null,1057.05,"EA",null,null,1057.05,{"$f":"+Instructions!$D$17","v":0},null,"",{"$f":"+T155","v":1057.05},0,null,7,1057.05,null,null,1057.05,{"$f":"+U155","v":"EA"},null,null,1057.05,0,0,"",null,"X"]
[null,"A7","Setting Material",null,null,"Kit",null,"Kovara MBX",null,null,"1 Kovara MBX roll (720 sf) + 3 rolls tape (2-4\" and 1-2-1/2\")",null,null,null,null,null,null,null,null,2617.85,"EA",null,null,2617.85,{"$f":"+Instructions!$D$17","v":0},null,"",{"$f":"+T156","v":2617.85},0,null,7,2617.85,null,null,2617.85,{"$f":"+U156","v":"EA"},null,null,2617.85,0,0,"",null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"CARE & MAINTENANCE",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,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"CLEANING",null,null,null,null,null,null,null,null," ",null,null,"Item # Lookup:","COCM",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,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"A6","Care & Maintenance",null,null,"Kit",null,"Karndean Floor Care Kit",null,null,null,null,null,null,null,null,null,null,null,62.45,"EA",null,null,62.45,{"$f":"+Instructions!$E$17","v":0},null,"",{"$f":"+T163","v":62.45},{"$f":"(AF163-AB163)/AF163","v":0},null,6,{"$f":"SUM(AM163:AO163)+AD163","v":62.45},null,null,{"$f":"+AF163","v":62.45},{"$f":"+U163","v":"EA"},null,null,{"$f":"ROUND(AB163/(1-VLOOKUP(AE163,Group,2,FALSE)),2)","v":62.45},{"$f":"IF(VLOOKUP(AE163,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM163,1)-AM163,2),Round,2,FALSE)+VLOOKUP(AE163,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE163,Group,7,FALSE)=\"\",0,ROUND(AM163-0.04999,1)-AM163+AP163)","v":0},{"$f":"IF(VLOOKUP(AE163,Group,7,FALSE)=\"\",\"\",VLOOKUP(AE163,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,"Includes:","Clean 750ml, Remove 750 ml, Refresh 750 ml,",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,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,"Floor protector pack, Refresh Pas, Remove Pad,",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,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,"Applicator, and Floor Care Guide",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,null,null,null,"X"]
[null,"A6","Care & Maintenance",null,null,"750 ml",null,"Karndean Routine Cleaner",null,null,null,null,null,null,null,null,"Stock",null,null,6.35,"EA",null,null,6.35,{"$f":"+Instructions!$E$17","v":0},null,"",{"$f":"+T167","v":6.35},0,null,6,{"$f":"SUM(AM167:AO167)+AD167","v":6.35},null,null,{"$f":"+AF167","v":6.35},{"$f":"+U167","v":"EA"},null,null,{"$f":"ROUND(AB167/(1-VLOOKUP(AE167,Group,2,FALSE)),2)","v":6.35},{"$f":"IF(VLOOKUP(AE167,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AM167,1)-AM167,2),Round,2,FALSE)+VLOOKUP(AE167,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AE167,Group,7,FALSE)=\"\",0,ROUND(AM167-0.04999,1)-AM167+AP167)","v":0},"",null,"X"]
[null,"A6","Care & Maintenance",null,null,"5 Liter",null,"Karndean Routine Cleaner",null,null,null,null,null,null,null,null,null,null,null,24.05,"EA",null,null,24.05,{"$f":"+Instructions!$E$17","v":0},null,"",{"$f":"+T168","v":24.05},0,null,6,24.05,null,null,24.05,{"$f":"+U168","v":"EA"},null,null,24.05,0,0,"",null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists.",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,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["X",null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[]
[null,null,null,null,"$.05 Round Matrix"]
[null,null,null,null,-0.04,0.01,null,null,null,null,null," "]
[null,null,null,null,-0.03,0.02]
[null,null,null,null,-0.02,0.03]
[null,null,null,null,-0.01,-0.01]
[null,null,null,null,0,0]
[null,null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,null,0.03,3.0000000000001137E-2]
[null,null,null,null,0.04,-0.01]
[null,null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page"]
[]
[]
["Product","Direct Website Link"]

{"sheet":"Changes","index":4,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
["2019-07-01","Bel Air","Glue Down"]
["2019-07-01","Blossom Hill","Glue Down & Loose Lay"]
["2019-07-01","Landis Valley","Rigid Core"]
["2019-07-01","Pheasant Hill","Glue Down"]
["2020-08-01","Bellevue Park","Rigid Core - SPC"]
["2020-08-01","Bloomingdale","Rigid Core - WPC"]
["2020-08-01","Del Ray","Rigid Core - WPC"]
["2020-08-01","Federal Hill","Rigid Core - SPC"]
["2021-03-09","Blossom Hill","Rigid Core added and is available in all 10 Blossom Hill colors."]
["2023-08-14","Bloomingdale","Color COBLSED Sedona in the 9\" x 60\" x 7.0mm 20mil Rigid Core - WPC plank format added. "]
["2023-08-14","Federal Hill","Colors COFHESP Espresso and COFHHEM Hemlock in the 7\" x 48\" x 5.0mm 20mil Rigid Core - SPC plank format added. "]
["2023-08-14","Skyline Drive","Rigid Core - SPC"]
["2023-08-14","Susquehanna","Rigid Core - SPC"]
["2023-11-01","Michaux","Rigid Core"]
["2023-11-01","Patapsco","Rigid Core"]
["2023-11-01","Shenandoah","Rigid Core"]
[]
[]
["Discontinued Products"]
["2021-03-09","Landis Valley","Entire Series."]
["2022-06-01","Pheasant Hill","Colors CONBU109 Light Bamboo and CONBU110 Midtone Bamboo in the 4\" x 36\" x 2.5mm 20mil Glue-Down plank format only. "]
["2023-02-10","Bellevue Park","Entire Series."]
["2023-02-10","Bloomingdale","Colors COBLHAR Harbor Fog and COBLWHI Whispering Wheat only in the 9\" x 60\" x 7.0mm format."]
["2023-02-10","Federal Hill","Colors COFHJOS Joshua Tree and COFHRUS Rustic Slate only in the 7\" x 48\" x 6.0mm format."]
["2023-08-14","Del Ray","Color CODRTIM Timberland in the 7\" x 48\" x 7.5mm 20mil Rigid Core - WPC plank format only. "]
["2024-02-06","Bel Air","Entire Series."]
["2024-02-06","Blossom Hill","Entire Series."]
["2024-02-06","Pheasant Hill","Entire Series."]
[]
[]
[]
["Changes:"]
["2023-08-14","Del Ray","Packaging is changing from 18.91 SF/CTN to 33.09 SF/CTN as inventory with old packaging is depleted."]
["2023-08-14","Federal Hill","This item is transitioning from 6.0mm to 5.0mm in thickness as inventories of the old thickness are depleted.  Packaging of the 7\" x 48\" x 5.0mm will be 23.64 SF/CTN."]