{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Changes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":17,"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":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Mediterranea"]
["File as","M"]
["Product Code","G"]
["CCTD Effective Date","8/1/24 (Updated)"]
[]
[]
[]
["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,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"G"}]
[]
[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,null,null,null,null,null,null,null,null,"  "]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0]
[null,2,null,"Trim",null,"No",0]
[null,3,null,"Decos",null,"No",0]
[null,4,null,"Import I - Field Tile",null,"No",0]
[null,5,null,"Import I - Trim",null,"No",0]
[null,6,null,"Import I - Decos",null,"No",0]
[null,7,null,"Import T -Field Tile",null,"No",0]
[null,8,null,"Import T - Trim",null,"No",0]
[null,9,null,"Import T - Decos",null,"No",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":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,0,5,10],[49,0,49,10],[51,0,51,10],[2,5,2,10]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'M' - Mediterranea"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 8/1/24 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type"]
[1,null,"Backwoods",null,"Inkjet Rectified Porcelain"]
[1,null,"Boardwalk",null,"Inkjet Rectified Porcelain"]
[1,null,"Chicago",null,"Inkjet Porcelain"]
[1,null,"Copacabana",null,"Inkjet Porcelain"]
[1,null,"Forum",null,"Inkjet Porcelain"]
[1,null,"Loom",null,"Inkjet Porcelain"]
[1,null,"Meritage",null,"Inkjet Porcelain"]
[1,null,"Modern Slate",null,"Inkjet Rectified Porcelain"]
[2,null,"Neptune",null,"Glazed Ceramic Wall"]
[2,null,"Sahara",null,"Color Body Inkjet Porcelain"]
[2,null,"Symmetry",null,"Inkjet Rectified Porcelain"]
[2,null,"Touch",null,"Inkjet Rectified Porcelain"]
[2,null,"Urban Loft",null,"Inkjet Porcelain"]
[2,null,"Vogue",null,"Inkjet Porcelain"]
[2,null,"Waterfalls",null,"Inkjet Porcelain"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":224,"n_cols":41,"rows_kept":224,"cut":false,"hidden":false,"merged":[[213,3,213,4],[20,2,20,19],[19,14,19,15],[210,2,210,18],[208,2,208,19],[14,14,14,19],[16,13,17,19],[15,30,15,32],[14,22,14,23],[12,14,12,15],[11,14,11,19],[11,22,11,23],[11,25,11,32]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA1*(1-W1)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W1","v":0},0.05,{"$f":"(AG1-AC1)/AG1","v":0},null,1,{"$f":"SUM(AJ1:AL1)+AE1","v":0.05},null,null,{"$f":"ROUND(AC1/(1-VLOOKUP(AF1,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF1,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ1,1)-AJ1,2),Round,2,FALSE)+VLOOKUP(AF1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",0,ROUND(AJ1-0.04999,1)-AJ1+AM1)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF1,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA2,AG2)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,2,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,3,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import I - Field Tile",null,null,"Size",null,"Field",null,"Description",null,null,null,null,null,null,"SF/CTN",null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,4,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,5,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import I - Decos",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,6,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import T -Field Tile",null,null,"Size",null,"Field",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,7,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import T - Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA8,AG8)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA8*(1-W8)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W8","v":0},{"$f":"+X8","v":0.05},{"$f":"(AG8-AC8)/AG8","v":0},null,8,{"$f":"SUM(AJ8:AL8)+AE8","v":0.05},null,null,{"$f":"ROUND(AC8/(1-VLOOKUP(AF8,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF8,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ8,1)-AJ8,2),Round,2,FALSE)+VLOOKUP(AF8,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF8,Group,7,FALSE)=\"\",0,ROUND(AJ8-0.04999,1)-AJ8+AM8)","v":0},{"$f":"IF(VLOOKUP(AF8,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF8,Group,7,FALSE))","v":""},null,"X"]
[null,"Import T - Decos",null,null,"Size",null,"Shape",null,"Description",null,null," ",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA9,AG9)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA9*(1-W9)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W9","v":0},{"$f":"+X9","v":0.05},{"$f":"(AG9-AC9)/AG9","v":0},null,9,{"$f":"SUM(AJ9:AL9)+AE9","v":0.05},null,null,{"$f":"ROUND(AC9/(1-VLOOKUP(AF9,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF9,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ9,1)-AJ9,2),Round,2,FALSE)+VLOOKUP(AF9,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF9,Group,7,FALSE)=\"\",0,ROUND(AJ9-0.04999,1)-AJ9+AM9)","v":0},{"$f":"IF(VLOOKUP(AF9,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF9,Group,7,FALSE))","v":""},null,"X"]
[null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","a",1000,"ABC",null,null,0.1,1000,null,"ABC",1000,0.1,1000,0.1,10,null,1000,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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price List",null,null,null,null,null,null,null,"Cust. Cost",null,null,"Customer Cost Calculation",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",{"$f":"IF(Suggested=\"Yes\",AA13,AG13)","v":"List Price"},"U/M","Code",null,"Disc.","Net",null,"Chg","List Price","Disc","Act. Cost","GP%","Adj.","Group","Price",null,null,"Calc Price",".05 Round","Cents","Round to",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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'M' - Mediterranea"},null,null,null,null,null,null,null,"Cost",null,null,null,null,null,null,null,null,null,"Retail Price Calculations",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,{"$f":"+Instructions!B4","v":"8/1/24 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-10-02"},null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!C8=\"\",\"\",+Instructions!C8)","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,"X"]
[null,null,{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code 'G'"},null,null,null,null,null,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(Instructions!$C$8=\"\",\"\",Instructions!$C$8)","v":""},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,"X"]
[null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"+S$13","v":"List Price"},"U/M",{"$f":"+U$13","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$13","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$13","v":"Group"},"Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[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,"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,"X"]
[null,null,"BACKWOODS - Inkjet Rectified Porcelain",null,null,null,null,null,null,null,null,null," "," ",null,null,null,"Item # Lookup:","MEBK",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,"X"]
[null,null,null,"Colors:","Country Oak          Kentucky Bourbon          Leather Saddle",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,null,"6\" x 36\"",null,"Field",null,null,null,null,null,null,null,null,"10.21 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA27,AG27)","v":7.25},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA27*(1-W27)+0.004999,2)","v":7.25},null,"",7.25,{"$f":"+W27","v":0},{"$f":"+X27","v":7.25},{"$f":"(AG27-AC27)/AG27","v":0},null,1,{"$f":"SUM(AJ27:AL27)+AE27","v":7.25},null,null,{"$f":"ROUND(AC27/(1-VLOOKUP(AF27,Group,2,FALSE)),2)","v":7.25},{"$f":"IF(VLOOKUP(AF27,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ27,1)-AJ27,2),Round,2,FALSE)+VLOOKUP(AF27,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF27,Group,7,FALSE)=\"\",0,ROUND(AJ27-0.04999,1)-AJ27+AM27)","v":0},{"$f":"IF(VLOOKUP(AF27,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF27,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"BOARDWALK - Inkjet Rectified Porcelain",null,null,null,null,null,null,null,null," "," ",null,null,null,null,"Item # Lookup:","MEBW",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,"X"]
[null,null,null,"Colors:","Atlantic City (Ash)",null,null,null,"    Myrtle Beach (White Wash)",null,null,null,null,null,null,null,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,"Coney Island (Walnut)",null,null,null,"    Venice Beach (Amber)",null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,null,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.58 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA34,AG34)","v":7.65},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA34*(1-W34)+0.004999,2)","v":7.65},null,"",7.65,{"$f":"+W34","v":0},{"$f":"+X34","v":7.65},{"$f":"(AG34-AC34)/AG34","v":0},null,1,{"$f":"SUM(AJ34:AL34)+AE34","v":7.65},null,null,{"$f":"ROUND(AC34/(1-VLOOKUP(AF34,Group,2,FALSE)),2)","v":7.65},{"$f":"IF(VLOOKUP(AF34,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ34,1)-AJ34,2),Round,2,FALSE)+VLOOKUP(AF34,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF34,Group,7,FALSE)=\"\",0,ROUND(AJ34-0.04999,1)-AJ34+AM34)","v":0},{"$f":"IF(VLOOKUP(AF34,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF34,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"8\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.58 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA35,AG35)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":8.8000000000000007},null,"",8.8000000000000007,{"$f":"+W35","v":0},{"$f":"+X35","v":8.8000000000000007},{"$f":"(AG35-AC35)/AG35","v":0},null,1,{"$f":"SUM(AJ35:AL35)+AE35","v":8.8000000000000007},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":8.8000000000000007},{"$f":"IF(VLOOKUP(AF35,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ35,1)-AJ35,2),Round,2,FALSE)+VLOOKUP(AF35,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",0,ROUND(AJ35-0.04999,1)-AJ35+AM35)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF35,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,"X"]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null," 16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA37,AG37)","v":12.2},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":12.2},null,"",12.2,{"$f":"+W37","v":0},{"$f":"+X37","v":12.2},{"$f":"(AG37-AC37)/AG37","v":0},null,2,{"$f":"SUM(AJ37:AL37)+AE37","v":12.2},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":12.2},{"$f":"IF(VLOOKUP(AF37,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ37,1)-AJ37,2),Round,2,FALSE)+VLOOKUP(AF37,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",0,ROUND(AJ37-0.04999,1)-AJ37+AM37)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF37,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,"X"]
[null,null,"CHICAGO - Inkjet Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MECH",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,"X"]
[null,null,null,"Colors:","Old Chicago (Classic)",null,null,null,"        State Street (Café)",null,null,null,null,null,null,null,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,"South Side (White Wash)",null,null,null,"        Wrigley (Red)",null,null,null,null,null,null,null,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,"X"]
[null,"Import I - Field Tile",null,null,"4\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"7.32 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",AA44,AG44)","v":8.4},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA44*(1-W44)+0.004999,2)","v":8.4},null,"",8.4,{"$f":"+W44","v":0},8.4,{"$f":"(AG44-AC44)/AG44","v":0},null,4,{"$f":"SUM(AJ44:AL44)+AE44","v":8.4},null,null,{"$f":"ROUND(AC44/(1-VLOOKUP(AF44,Group,2,FALSE)),2)","v":8.4},{"$f":"IF(VLOOKUP(AF44,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ44,1)-AJ44,2),Round,2,FALSE)+VLOOKUP(AF44,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",0,ROUND(AJ44-0.04999,1)-AJ44+AM44)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF44,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"4\" x 8\"",null,"Field - City Mix",null,null,null,null,null,null,null,null,"7.32 SF/CTN","Stock","b,c",8.9,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},8.9,null,"",8.9,0,8.9,0,null,4,8.9,null,null,8.9,0,0,"",null,"X"]
[null,"Import I - Field Tile",null,null,"8\" x 8\"",null,"Field",null,null," ",null,null,null,null,null,"10.33 SF/CTN","Stock","c",8.5500000000000007,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},8.5500000000000007,null,"",8.5500000000000007,0,8.5500000000000007,0,null,4,8.5500000000000007,null,null,8.5500000000000007,0,0,"",null,"X"]
[null,"Import I - Field Tile",null,null,"8\" x 16\"",null,"Field",null,null," ",null,null,null,null,null,"10.33 SF/CTN","Stock","c",8.5500000000000007,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},8.5500000000000007,null,"",8.5500000000000007,{"$f":"+W47","v":0},{"$f":"+X47","v":8.5500000000000007},0,null,4,8.5500000000000007,null,null,8.5500000000000007,0,0,"",null,"X"]
[null,"Import I - Field Tile",null,null,"16\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"13.77 SF/CTN",null,"c,d",8.4,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},8.4,null,"",8.4,{"$f":"+W48","v":0},{"$f":"+X48","v":8.4},0,null,4,8.4,null,null,8.4,0,0,"",null,"X"]
[null,"Import I - Field Tile",null,null,"9-7/16\" x 10-7/8\"",null,"Field - 10\" Hexagon",null,null,null,null,null,null,null,null,"10.44 SF/CTN","Stock",null,10.95,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},10.95,null,"",10.95,0,10.95,0,null,4,10.95,null,null,10.95,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,"X"]
[null,"Import I - Decos",null,null,"12\" x 16\"",null,"3\" x 3\" Mosaic",null,null,null,null,null,null,null,null,"1.29 SF/Sheet","Stock","e",{"$f":"IF(Suggested=\"Yes\",AA51,AG51)","v":26.8},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA51*(1-W51)+0.004999,2)","v":26.8},null,"",26.8,0,26.8,{"$f":"(AG51-AC51)/AG51","v":0},null,6,{"$f":"SUM(AJ51:AL51)+AE51","v":26.8},null,null,{"$f":"ROUND(AC51/(1-VLOOKUP(AF51,Group,2,FALSE)),2)","v":26.8},{"$f":"IF(VLOOKUP(AF51,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ51,1)-AJ51,2),Round,2,FALSE)+VLOOKUP(AF51,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF51,Group,7,FALSE)=\"\",0,ROUND(AJ51-0.04999,1)-AJ51+AM51)","v":0},{"$f":"IF(VLOOKUP(AF51,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF51,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,"X"]
[null,"Import I - Trim",null,null,"2-5/8\" x 16\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,null,"c",{"$f":"IF(Suggested=\"Yes\",AA53,AG53)","v":9.65},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA53*(1-W53)+0.004999,2)","v":9.65},null,"",9.65,{"$f":"+W53","v":0},{"$f":"+X53","v":9.65},{"$f":"(AG53-AC53)/AG53","v":0},null,5,{"$f":"SUM(AJ53:AL53)+AE53","v":9.65},null,null,{"$f":"ROUND(AC53/(1-VLOOKUP(AF53,Group,2,FALSE)),2)","v":9.65},{"$f":"IF(VLOOKUP(AF53,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ53,1)-AJ53,2),Round,2,FALSE)+VLOOKUP(AF53,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",0,ROUND(AJ53-0.04999,1)-AJ53+AM53)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF53,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,"X"]
[null,null,null,"Notes:","a) Approximately 5-7% of pieces have \"Chicago\" printed on face of each brick tile.",null,null,null,null,null,null,null,null,null,null,null,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,"b) Assorted U.S. city names printed on face of each brick tile.",null,null,null,null,null,null,null,null,null,null,null,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,"c) Not available in colors State Street (Café) and Wrigley (Red).",null,null,null,null,null,null,null,null,null,null,null,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,"e) Not available in color Wrigley (Red).",null,null,null,null,"d) Please allow approximately 6 to 8 weeks lead time.",null,null,null,null,null,null,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,"X"]
[null,null,"COPACABANA - Inkjet Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MECO",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,"X"]
[null,null,null,"Colors:","Blue          Wave",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA64,AG64)","v":6.05},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":6.05},null,"",6.05,{"$f":"+W64","v":0},{"$f":"+X64","v":6.05},{"$f":"(AG64-AC64)/AG64","v":0},null,1,{"$f":"SUM(AJ64:AL64)+AE64","v":6.05},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":6.05},{"$f":"IF(VLOOKUP(AF64,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ64,1)-AJ64,2),Round,2,FALSE)+VLOOKUP(AF64,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",0,ROUND(AJ64-0.04999,1)-AJ64+AM64)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF64,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,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,null,null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":24.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA66*(1-W66)+0.004999,2)","v":24.05},null,"",24.05,{"$f":"+W66","v":0},{"$f":"+X66","v":24.05},{"$f":"(AG66-AC66)/AG66","v":0},null,3,{"$f":"SUM(AJ66:AL66)+AE66","v":24.05},null,null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":24.05},{"$f":"IF(VLOOKUP(AF66,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ66,1)-AJ66,2),Round,2,FALSE)+VLOOKUP(AF66,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",0,ROUND(AJ66-0.04999,1)-AJ66+AM66)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF66,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,"X"]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null," 16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA68,AG68)","v":10.65},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA68*(1-W68)+0.004999,2)","v":10.65},null,"",10.65,{"$f":"+W68","v":0},{"$f":"+X68","v":10.65},{"$f":"(AG68-AC68)/AG68","v":0},null,2,{"$f":"SUM(AJ68:AL68)+AE68","v":10.65},null,null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":10.65},{"$f":"IF(VLOOKUP(AF68,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ68,1)-AJ68,2),Round,2,FALSE)+VLOOKUP(AF68,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",0,ROUND(AJ68-0.04999,1)-AJ68+AM68)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF68,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,"X"]
[null,null,"FORUM - Inkjet Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MEFO",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,"X"]
[null,null,null,"Colors:","Ivory          Silver",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA74,AG74)","v":6.1},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA74*(1-W74)+0.004999,2)","v":6.1},null,"",6.1,{"$f":"+W74","v":0},{"$f":"+X74","v":6.1},{"$f":"(AG74-AC74)/AG74","v":0},null,1,{"$f":"SUM(AJ74:AL74)+AE74","v":6.1},null,null,{"$f":"ROUND(AC74/(1-VLOOKUP(AF74,Group,2,FALSE)),2)","v":6.1},{"$f":"IF(VLOOKUP(AF74,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ74,1)-AJ74,2),Round,2,FALSE)+VLOOKUP(AF74,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",0,ROUND(AJ74-0.04999,1)-AJ74+AM74)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF74,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,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"1\" x 2\" Mosaic",null,null,null,null,null,"Mesh-Mounted",null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA76,AG76)","v":34.65},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":34.65},null,"",34.65,{"$f":"+W76","v":0},34.65,{"$f":"(AG76-AC76)/AG76","v":0},null,3,{"$f":"SUM(AJ76:AL76)+AE76","v":34.65},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":34.65},{"$f":"IF(VLOOKUP(AF76,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ76,1)-AJ76,2),Round,2,FALSE)+VLOOKUP(AF76,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",0,ROUND(AJ76-0.04999,1)-AJ76+AM76)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF76,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,null,null,"Mesh-Mounted",null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA77,AG77)","v":24.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":24.05},null,"",24.05,0,24.05,{"$f":"(AG77-AC77)/AG77","v":0},null,3,{"$f":"SUM(AJ77:AL77)+AE77","v":24.05},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":24.05},{"$f":"IF(VLOOKUP(AF77,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ77,1)-AJ77,2),Round,2,FALSE)+VLOOKUP(AF77,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",0,ROUND(AJ77-0.04999,1)-AJ77+AM77)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF77,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 24\"",null,"Strip Mosaic",null,null,null,null,null,"Mesh-Mounted",null,null,"4 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA78,AG78)","v":34.85},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":34.85},null,"",34.85,0,34.85,{"$f":"(AG78-AC78)/AG78","v":0},null,3,{"$f":"SUM(AJ78:AL78)+AE78","v":34.85},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":34.85},{"$f":"IF(VLOOKUP(AF78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ78,1)-AJ78,2),Round,2,FALSE)+VLOOKUP(AF78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",0,ROUND(AJ78-0.04999,1)-AJ78+AM78)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF78,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,"X"]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null," 16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA80,AG80)","v":10.65},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA80*(1-W80)+0.004999,2)","v":10.65},null,"",10.65,{"$f":"+W80","v":0},{"$f":"+X80","v":10.65},{"$f":"(AG80-AC80)/AG80","v":0},null,2,{"$f":"SUM(AJ80:AL80)+AE80","v":10.65},null,null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":10.65},{"$f":"IF(VLOOKUP(AF80,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ80,1)-AJ80,2),Round,2,FALSE)+VLOOKUP(AF80,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",0,ROUND(AJ80-0.04999,1)-AJ80+AM80)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF80,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,"X"]
[null,null,"LOOM - Inkjet Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MELO",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,"X"]
[null,null,null,"Colors:","Cotton          Linen          Silk          Suede          Velvet          Wool",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA86,AG86)","v":6.05},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA86*(1-W86)+0.004999,2)","v":6.05},null,"",6.05,{"$f":"+W86","v":0},{"$f":"+X86","v":6.05},{"$f":"(AG86-AC86)/AG86","v":0},null,1,{"$f":"SUM(AJ86:AL86)+AE86","v":6.05},null,null,{"$f":"ROUND(AC86/(1-VLOOKUP(AF86,Group,2,FALSE)),2)","v":6.05},{"$f":"IF(VLOOKUP(AF86,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ86,1)-AJ86,2),Round,2,FALSE)+VLOOKUP(AF86,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",0,ROUND(AJ86-0.04999,1)-AJ86+AM86)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF86,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,"Matte",null,null,"Mesh-Mounted",null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA88,AG88)","v":24.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA88*(1-W88)+0.004999,2)","v":24.05},null,"",24.05,{"$f":"+W88","v":0},{"$f":"+X88","v":24.05},{"$f":"(AG88-AC88)/AG88","v":0},null,3,{"$f":"SUM(AJ88:AL88)+AE88","v":24.05},null,null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":24.05},{"$f":"IF(VLOOKUP(AF88,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ88,1)-AJ88,2),Round,2,FALSE)+VLOOKUP(AF88,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",0,ROUND(AJ88-0.04999,1)-AJ88+AM88)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF88,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,"Matte",null,null,null,null,null," 16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA90,AG90)","v":10.5},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA90*(1-W90)+0.004999,2)","v":10.5},null,"",10.5,{"$f":"+W90","v":0},{"$f":"+X90","v":10.5},{"$f":"(AG90-AC90)/AG90","v":0},null,2,{"$f":"SUM(AJ90:AL90)+AE90","v":10.5},null,null,{"$f":"ROUND(AC90/(1-VLOOKUP(AF90,Group,2,FALSE)),2)","v":10.5},{"$f":"IF(VLOOKUP(AF90,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ90,1)-AJ90,2),Round,2,FALSE)+VLOOKUP(AF90,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,7,FALSE)=\"\",0,ROUND(AJ90-0.04999,1)-AJ90+AM90)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF90,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,"X"]
[null,null,"MERITAGE - Inkjet Rectified Porcelain",null,null,null,null,null,null,null,null," "," ",null,null,null,null,"Item # Lookup:","MEME",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,"X"]
[null,null,null,"Colors:","Beige          Black          Grey          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,null,null,null,"X"]
[]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,"Matte",null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA96,AG96)","v":6.35},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA96*(1-W96)+0.004999,2)","v":6.35},null,"",6.35,{"$f":"+W96","v":0},{"$f":"+X96","v":6.35},{"$f":"(AG96-AC96)/AG96","v":0},null,1,{"$f":"SUM(AJ96:AL96)+AE96","v":6.35},null,null,{"$f":"ROUND(AC96/(1-VLOOKUP(AF96,Group,2,FALSE)),2)","v":6.35},{"$f":"IF(VLOOKUP(AF96,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ96,1)-AJ96,2),Round,2,FALSE)+VLOOKUP(AF96,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",0,ROUND(AJ96-0.04999,1)-AJ96+AM96)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF96,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,"Matte",null,null,"Mesh-Mounted",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA98,AG98)","v":24.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA98*(1-W98)+0.004999,2)","v":24.05},null,"",24.05,{"$f":"+W98","v":0},{"$f":"+X98","v":24.05},{"$f":"(AG98-AC98)/AG98","v":0},null,3,{"$f":"SUM(AJ98:AL98)+AE98","v":24.05},null,null,{"$f":"ROUND(AC98/(1-VLOOKUP(AF98,Group,2,FALSE)),2)","v":24.05},{"$f":"IF(VLOOKUP(AF98,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ98,1)-AJ98,2),Round,2,FALSE)+VLOOKUP(AF98,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",0,ROUND(AJ98-0.04999,1)-AJ98+AM98)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF98,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,"Matte",null,null,null,null,null," 16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA100,AG100)","v":12.3},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA100*(1-W100)+0.004999,2)","v":12.3},null,"",12.3,{"$f":"+W100","v":0},{"$f":"+X100","v":12.3},{"$f":"(AG100-AC100)/AG100","v":0},null,2,{"$f":"SUM(AJ100:AL100)+AE100","v":12.3},null,null,{"$f":"ROUND(AC100/(1-VLOOKUP(AF100,Group,2,FALSE)),2)","v":12.3},{"$f":"IF(VLOOKUP(AF100,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ100,1)-AJ100,2),Round,2,FALSE)+VLOOKUP(AF100,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF100,Group,7,FALSE)=\"\",0,ROUND(AJ100-0.04999,1)-AJ100+AM100)","v":0},{"$f":"IF(VLOOKUP(AF100,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF100,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,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,"Polished",null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA102,AG102)","v":8.5500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA102*(1-W102)+0.004999,2)","v":8.5500000000000007},null,"",8.5500000000000007,{"$f":"+W102","v":0},{"$f":"+X102","v":8.5500000000000007},{"$f":"(AG102-AC102)/AG102","v":0},null,1,{"$f":"SUM(AJ102:AL102)+AE102","v":8.5500000000000007},null,null,{"$f":"ROUND(AC102/(1-VLOOKUP(AF102,Group,2,FALSE)),2)","v":8.5500000000000007},{"$f":"IF(VLOOKUP(AF102,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ102,1)-AJ102,2),Round,2,FALSE)+VLOOKUP(AF102,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",0,ROUND(AJ102-0.04999,1)-AJ102+AM102)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF102,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,"Polished",null,null,"Mesh-Mounted",null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA104,AG104)","v":27.1},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA104*(1-W104)+0.004999,2)","v":27.1},null,"",27.1,{"$f":"+W104","v":0},{"$f":"+X104","v":27.1},{"$f":"(AG104-AC104)/AG104","v":0},null,3,{"$f":"SUM(AJ104:AL104)+AE104","v":27.1},null,null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":27.1},{"$f":"IF(VLOOKUP(AF104,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ104,1)-AJ104,2),Round,2,FALSE)+VLOOKUP(AF104,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",0,ROUND(AJ104-0.04999,1)-AJ104+AM104)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF104,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,"Polished",null,null,null,null,null," 16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA106,AG106)","v":15.35},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":15.35},null,"",15.35,{"$f":"+W106","v":0},{"$f":"+X106","v":15.35},{"$f":"(AG106-AC106)/AG106","v":0},null,2,{"$f":"SUM(AJ106:AL106)+AE106","v":15.35},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":15.35},{"$f":"IF(VLOOKUP(AF106,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ106,1)-AJ106,2),Round,2,FALSE)+VLOOKUP(AF106,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",0,ROUND(AJ106-0.04999,1)-AJ106+AM106)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF106,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"MODERN SLATE - Inkjet Rectified Porcelain",null,null,null,null,null,null,null,null," "," ",null,null,null,null,"Item # Lookup:","MEMS",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,"X"]
[null,null,null,"Colors:","Charcoal          Grey          Ivory          Noce          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,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,"X"]
[null,"Field Tile",null," ","12\" x 24\" x 8mm",null,"Field",null,null,"Matte",null,null,null,null,null,"15.50 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA112,AG112)","v":6.4},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA112*(1-W112)+0.004999,2)","v":6.4},null,"",6.4,{"$f":"+W112","v":0},{"$f":"+X112","v":6.4},{"$f":"(AG112-AC112)/AG112","v":0},null,1,{"$f":"SUM(AJ112:AL112)+AE112","v":6.4},null,null,{"$f":"ROUND(AC112/(1-VLOOKUP(AF112,Group,2,FALSE)),2)","v":6.4},{"$f":"IF(VLOOKUP(AF112,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ112,1)-AJ112,2),Round,2,FALSE)+VLOOKUP(AF112,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",0,ROUND(AJ112-0.04999,1)-AJ112+AM112)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF112,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\" x 8mm",null,"Field",null,null,"Matte",null,null,null,null,null,"31.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA113,AG113)","v":7.85},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA113*(1-W113)+0.004999,2)","v":7.85},null,"",7.85,{"$f":"+W113","v":0},{"$f":"+X113","v":7.85},{"$f":"(AG113-AC113)/AG113","v":0},null,1,{"$f":"SUM(AJ113:AL113)+AE113","v":7.85},null,null,{"$f":"ROUND(AC113/(1-VLOOKUP(AF113,Group,2,FALSE)),2)","v":7.85},{"$f":"IF(VLOOKUP(AF113,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ113,1)-AJ113,2),Round,2,FALSE)+VLOOKUP(AF113,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",0,ROUND(AJ113-0.04999,1)-AJ113+AM113)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF113,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,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,"Matte",null,null,"Mesh-Mounted",null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA115,AG115)","v":24.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA115*(1-W115)+0.004999,2)","v":24.05},null,"",24.05,{"$f":"+W115","v":0},{"$f":"+X115","v":24.05},{"$f":"(AG115-AC115)/AG115","v":0},null,3,{"$f":"SUM(AJ115:AL115)+AE115","v":24.05},null,null,{"$f":"ROUND(AC115/(1-VLOOKUP(AF115,Group,2,FALSE)),2)","v":24.05},{"$f":"IF(VLOOKUP(AF115,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ115,1)-AJ115,2),Round,2,FALSE)+VLOOKUP(AF115,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,7,FALSE)=\"\",0,ROUND(AJ115-0.04999,1)-AJ115+AM115)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF115,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,"X"]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,"Matte",null,null,null,null,null," 16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA117,AG117)","v":12.3},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA117*(1-W117)+0.004999,2)","v":12.3},null,"",12.3,{"$f":"+W117","v":0},{"$f":"+X117","v":12.3},{"$f":"(AG117-AC117)/AG117","v":0},null,2,{"$f":"SUM(AJ117:AL117)+AE117","v":12.3},null,null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":12.3},{"$f":"IF(VLOOKUP(AF117,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ117,1)-AJ117,2),Round,2,FALSE)+VLOOKUP(AF117,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",0,ROUND(AJ117-0.04999,1)-AJ117+AM117)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF117,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,"X"]
[null,"Field Tile",null,null,"12\" x 24\" x 8mm",null,"Field",null,null,"Anti-slip",null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA119,AG119)","v":6.8},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA119*(1-W119)+0.004999,2)","v":6.8},null,"",6.8,{"$f":"+W119","v":0},{"$f":"+X119","v":6.8},{"$f":"(AG119-AC119)/AG119","v":0},null,1,{"$f":"SUM(AJ119:AL119)+AE119","v":6.8},null,null,{"$f":"ROUND(AC119/(1-VLOOKUP(AF119,Group,2,FALSE)),2)","v":6.8},{"$f":"IF(VLOOKUP(AF119,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ119,1)-AJ119,2),Round,2,FALSE)+VLOOKUP(AF119,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",0,ROUND(AJ119-0.04999,1)-AJ119+AM119)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF119,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,"X"]
[null,null,"NEPTUNE - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MENE",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,"X"]
[null,null,null,"Color:","Neptune",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,"Wall:","8\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"13.78 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA125,AG125)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA125*(1-W125)+0.004999,2)","v":10.85},null,"",10.85,{"$f":"+W125","v":0},{"$f":"+X125","v":10.85},{"$f":"(AG125-AC125)/AG125","v":0},null,1,{"$f":"SUM(AJ125:AL125)+AE125","v":10.85},null,null,{"$f":"ROUND(AC125/(1-VLOOKUP(AF125,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF125,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ125,1)-AJ125,2),Round,2,FALSE)+VLOOKUP(AF125,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",0,ROUND(AJ125-0.04999,1)-AJ125+AM125)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF125,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,"X"]
[null,null,null,"Note:","Tiles vary in coloration, sorted randomly in each carton.",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,null,"SAHARA - Color Body Inkjet Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MESH",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,"X"]
[null,null,null,"Colors:","Sand",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.75 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA133,AG133)","v":6.05},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA133*(1-W133)+0.004999,2)","v":6.05},null,"",6.05,{"$f":"+W133","v":0},{"$f":"+X133","v":6.05},{"$f":"(AG133-AC133)/AG133","v":0},null,1,{"$f":"SUM(AJ133:AL133)+AE133","v":6.05},null,null,{"$f":"ROUND(AC133/(1-VLOOKUP(AF133,Group,2,FALSE)),2)","v":6.05},{"$f":"IF(VLOOKUP(AF133,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ133,1)-AJ133,2),Round,2,FALSE)+VLOOKUP(AF133,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",0,ROUND(AJ133-0.04999,1)-AJ133+AM133)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF133,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,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,null,null,"Mesh-Mounted",null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA135,AG135)","v":24.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA135*(1-W135)+0.004999,2)","v":24.05},null,"",24.05,{"$f":"+W135","v":0},{"$f":"+X135","v":24.05},{"$f":"(AG135-AC135)/AG135","v":0},null,3,{"$f":"SUM(AJ135:AL135)+AE135","v":24.05},null,null,{"$f":"ROUND(AC135/(1-VLOOKUP(AF135,Group,2,FALSE)),2)","v":24.05},{"$f":"IF(VLOOKUP(AF135,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ135,1)-AJ135,2),Round,2,FALSE)+VLOOKUP(AF135,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",0,ROUND(AJ135-0.04999,1)-AJ135+AM135)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF135,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,"X"]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null," 16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA137,AG137)","v":12.3},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA137*(1-W137)+0.004999,2)","v":12.3},null,"",12.3,{"$f":"+W137","v":0},{"$f":"+X137","v":12.3},{"$f":"(AG137-AC137)/AG137","v":0},null,2,{"$f":"SUM(AJ137:AL137)+AE137","v":12.3},null,null,{"$f":"ROUND(AC137/(1-VLOOKUP(AF137,Group,2,FALSE)),2)","v":12.3},{"$f":"IF(VLOOKUP(AF137,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ137,1)-AJ137,2),Round,2,FALSE)+VLOOKUP(AF137,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",0,ROUND(AJ137-0.04999,1)-AJ137+AM137)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF137,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,"X"]
[null,null,"SYMMETRY - Inkjet Rectified Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MESY",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,"X"]
[null,null,null,"Colors:","Moon Glow          Morning Mist          Starry Night          Sunrise",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,"Linen:","12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA143,AG143)","v":7.35},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA143*(1-W143)+0.004999,2)","v":7.35},null,"",7.35,{"$f":"+W143","v":0},{"$f":"+X143","v":7.35},{"$f":"(AG143-AC143)/AG143","v":0},null,1,{"$f":"SUM(AJ143:AL143)+AE143","v":7.35},null,null,{"$f":"ROUND(AC143/(1-VLOOKUP(AF143,Group,2,FALSE)),2)","v":7.35},{"$f":"IF(VLOOKUP(AF143,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ143,1)-AJ143,2),Round,2,FALSE)+VLOOKUP(AF143,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",0,ROUND(AJ143-0.04999,1)-AJ143+AM143)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF143,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,null,null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA145,AG145)","v":24},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA145*(1-W145)+0.004999,2)","v":24},null,"",24,{"$f":"+W145","v":0},{"$f":"+X145","v":24},{"$f":"(AG145-AC145)/AG145","v":0},null,3,{"$f":"SUM(AJ145:AL145)+AE145","v":24},null,null,{"$f":"ROUND(AC145/(1-VLOOKUP(AF145,Group,2,FALSE)),2)","v":24},{"$f":"IF(VLOOKUP(AF145,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ145,1)-AJ145,2),Round,2,FALSE)+VLOOKUP(AF145,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",0,ROUND(AJ145-0.04999,1)-AJ145+AM145)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF145,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,"16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA147,AG147)","v":12.15},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA147*(1-W147)+0.004999,2)","v":12.15},null,"",12.15,{"$f":"+W147","v":0},{"$f":"+X147","v":12.15},{"$f":"(AG147-AC147)/AG147","v":0},null,2,{"$f":"SUM(AJ147:AL147)+AE147","v":12.15},null,null,{"$f":"ROUND(AC147/(1-VLOOKUP(AF147,Group,2,FALSE)),2)","v":12.15},{"$f":"IF(VLOOKUP(AF147,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ147,1)-AJ147,2),Round,2,FALSE)+VLOOKUP(AF147,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,7,FALSE)=\"\",0,ROUND(AJ147-0.04999,1)-AJ147+AM147)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF147,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"TOUCH - Inkjet Rectified Porcelain",null,null,null,null,null,null,null," "," "," ",null,null,null,null,"Item # Lookup:","METO",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,"X"]
[null,null,null,"Colors:","Evening Sunset (Olive)",null,null,null," Snow Crest (White)",null,null,"         Sun Glow (Beige)",null,null,null,null,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,"Pearl Essence (Grey)",null,null,null," Summer Breeze (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,"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,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA154,AG154)","v":7.85},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA154*(1-W154)+0.004999,2)","v":7.85},null,"",7.85,{"$f":"+W154","v":0},{"$f":"+X154","v":7.85},{"$f":"(AG154-AC154)/AG154","v":0},null,1,{"$f":"SUM(AJ154:AL154)+AE154","v":7.85},null,null,{"$f":"ROUND(AC154/(1-VLOOKUP(AF154,Group,2,FALSE)),2)","v":7.85},{"$f":"IF(VLOOKUP(AF154,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ154,1)-AJ154,2),Round,2,FALSE)+VLOOKUP(AF154,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",0,ROUND(AJ154-0.04999,1)-AJ154+AM154)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF154,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,"X"]
[null,"Trim",null,null,"3\" x 12\"",null,"Bullnose",null,null,null,null,null,null,null,null,"15 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA156,AG156)","v":6.75},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA156*(1-W156)+0.004999,2)","v":6.75},null,"",6.75,{"$f":"+W156","v":0},{"$f":"+X156","v":6.75},{"$f":"(AG156-AC156)/AG156","v":0},null,2,{"$f":"SUM(AJ156:AL156)+AE156","v":6.75},null,null,{"$f":"ROUND(AC156/(1-VLOOKUP(AF156,Group,2,FALSE)),2)","v":6.75},{"$f":"IF(VLOOKUP(AF156,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ156,1)-AJ156,2),Round,2,FALSE)+VLOOKUP(AF156,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",0,ROUND(AJ156-0.04999,1)-AJ156+AM156)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF156,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,"X"]
[null,null,"URBAN LOFT - Inkjet Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MEUL",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,"X"]
[null,null,null,"Color:","Wynwood",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA162,AG162)","v":6.05},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA162*(1-W162)+0.004999,2)","v":6.05},null,"",6.05,{"$f":"+W162","v":0},{"$f":"+X162","v":6.05},{"$f":"(AG162-AC162)/AG162","v":0},null,1,{"$f":"SUM(AJ162:AL162)+AE162","v":6.05},null,null,{"$f":"ROUND(AC162/(1-VLOOKUP(AF162,Group,2,FALSE)),2)","v":6.05},{"$f":"IF(VLOOKUP(AF162,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ162,1)-AJ162,2),Round,2,FALSE)+VLOOKUP(AF162,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF162,Group,7,FALSE)=\"\",0,ROUND(AJ162-0.04999,1)-AJ162+AM162)","v":0},{"$f":"IF(VLOOKUP(AF162,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF162,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,null,null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA164,AG164)","v":24.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA164*(1-W164)+0.004999,2)","v":24.05},null,"",24.05,{"$f":"+W164","v":0},{"$f":"+X164","v":24.05},{"$f":"(AG164-AC164)/AG164","v":0},null,3,{"$f":"SUM(AJ164:AL164)+AE164","v":24.05},null,null,{"$f":"ROUND(AC164/(1-VLOOKUP(AF164,Group,2,FALSE)),2)","v":24.05},{"$f":"IF(VLOOKUP(AF164,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ164,1)-AJ164,2),Round,2,FALSE)+VLOOKUP(AF164,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,7,FALSE)=\"\",0,ROUND(AJ164-0.04999,1)-AJ164+AM164)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF164,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,"16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA166,AG166)","v":9.75},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":9.75},null,"",9.75,{"$f":"+W166","v":0},{"$f":"+X166","v":9.75},{"$f":"(AG166-AC166)/AG166","v":0},null,2,{"$f":"SUM(AJ166:AL166)+AE166","v":9.75},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":9.75},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ166,1)-AJ166,2),Round,2,FALSE)+VLOOKUP(AF166,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",0,ROUND(AJ166-0.04999,1)-AJ166+AM166)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF166,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,"X"]
[null,null,"VOGUE - Inkjet Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MEVO",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,"X"]
[null,null,null,"Color:","Warm Grey",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA172,AG172)","v":6.05},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA172*(1-W172)+0.004999,2)","v":6.05},null,"",6.05,{"$f":"+W172","v":0},{"$f":"+X172","v":6.05},{"$f":"(AG172-AC172)/AG172","v":0},null,1,{"$f":"SUM(AJ172:AL172)+AE172","v":6.05},null,null,{"$f":"ROUND(AC172/(1-VLOOKUP(AF172,Group,2,FALSE)),2)","v":6.05},{"$f":"IF(VLOOKUP(AF172,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ172,1)-AJ172,2),Round,2,FALSE)+VLOOKUP(AF172,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",0,ROUND(AJ172-0.04999,1)-AJ172+AM172)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF172,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,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"1\" x 2\" Mosaic",null,null,null,null,null,"Mesh-Mounted",null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA174,AG174)","v":32.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA174*(1-W174)+0.004999,2)","v":32.4},null,"",32.4,{"$f":"+W174","v":0},{"$f":"+X174","v":32.4},{"$f":"(AG174-AC174)/AG174","v":0},null,3,{"$f":"SUM(AJ174:AL174)+AE174","v":32.4},null,null,{"$f":"ROUND(AC174/(1-VLOOKUP(AF174,Group,2,FALSE)),2)","v":32.4},{"$f":"IF(VLOOKUP(AF174,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ174,1)-AJ174,2),Round,2,FALSE)+VLOOKUP(AF174,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF174,Group,7,FALSE)=\"\",0,ROUND(AJ174-0.04999,1)-AJ174+AM174)","v":0},{"$f":"IF(VLOOKUP(AF174,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF174,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 24\"",null,"Strip Mosaic",null,null,null,null,null,"Mesh-Mounted",null,null,"4 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA175,AG175)","v":32.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA175*(1-W175)+0.004999,2)","v":32.4},null,"",32.4,{"$f":"+W175","v":0},{"$f":"+X175","v":32.4},{"$f":"(AG175-AC175)/AG175","v":0},null,3,{"$f":"SUM(AJ175:AL175)+AE175","v":32.4},null,null,{"$f":"ROUND(AC175/(1-VLOOKUP(AF175,Group,2,FALSE)),2)","v":32.4},{"$f":"IF(VLOOKUP(AF175,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ175,1)-AJ175,2),Round,2,FALSE)+VLOOKUP(AF175,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF175,Group,7,FALSE)=\"\",0,ROUND(AJ175-0.04999,1)-AJ175+AM175)","v":0},{"$f":"IF(VLOOKUP(AF175,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF175,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,"X"]
[null,"Trim",null,null,"3\" x 12\"",null,"Bullnose",null,null,null,null,null,null,null,null," 15 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA177,AG177)","v":6.85},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA177*(1-W177)+0.004999,2)","v":6.85},null,"",6.85,{"$f":"+W177","v":0},{"$f":"+X177","v":6.85},{"$f":"(AG177-AC177)/AG177","v":0},null,2,{"$f":"SUM(AJ177:AL177)+AE177","v":6.85},null,null,{"$f":"ROUND(AC177/(1-VLOOKUP(AF177,Group,2,FALSE)),2)","v":6.85},{"$f":"IF(VLOOKUP(AF177,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ177,1)-AJ177,2),Round,2,FALSE)+VLOOKUP(AF177,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",0,ROUND(AJ177-0.04999,1)-AJ177+AM177)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF177,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,"X"]
[null,null,"WATERFALLS - Inkjet Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MEWA",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,"X"]
[null,null,null,"Colors:","Niagara Crush          River Rush          White Water",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA183,AG183)","v":6.1},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":6.1},null,"",6.1,{"$f":"+W183","v":0},6.1,{"$f":"(AG183-AC183)/AG183","v":0},null,1,{"$f":"SUM(AJ183:AL183)+AE183","v":6.1},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":6.1},{"$f":"IF(VLOOKUP(AF183,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ183,1)-AJ183,2),Round,2,FALSE)+VLOOKUP(AF183,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",0,ROUND(AJ183-0.04999,1)-AJ183+AM183)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF183,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 48\"",null,"Field",null,"Rectified",null,null,null,null,null,null,"19.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA184,AG184)","v":7.8},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA184*(1-W184)+0.004999,2)","v":7.8},null,"",7.8,0,7.8,{"$f":"(AG184-AC184)/AG184","v":0},null,1,{"$f":"SUM(AJ184:AL184)+AE184","v":7.8},null,null,{"$f":"ROUND(AC184/(1-VLOOKUP(AF184,Group,2,FALSE)),2)","v":7.8},{"$f":"IF(VLOOKUP(AF184,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ184,1)-AJ184,2),Round,2,FALSE)+VLOOKUP(AF184,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",0,ROUND(AJ184-0.04999,1)-AJ184+AM184)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF184,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,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,null,null,"Mesh-Mounted",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA186,AG186)","v":22.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA186*(1-W186)+0.004999,2)","v":22.4},null,"",22.4,{"$f":"+W186","v":0},{"$f":"+X186","v":22.4},{"$f":"(AG186-AC186)/AG186","v":0},null,3,{"$f":"SUM(AJ186:AL186)+AE186","v":22.4},null,null,{"$f":"ROUND(AC186/(1-VLOOKUP(AF186,Group,2,FALSE)),2)","v":22.4},{"$f":"IF(VLOOKUP(AF186,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ186,1)-AJ186,2),Round,2,FALSE)+VLOOKUP(AF186,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF186,Group,7,FALSE)=\"\",0,ROUND(AJ186-0.04999,1)-AJ186+AM186)","v":0},{"$f":"IF(VLOOKUP(AF186,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF186,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,"X"]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null," 16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA188,AG188)","v":9.75},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA188*(1-W188)+0.004999,2)","v":9.75},null,"",9.75,{"$f":"+W188","v":0},{"$f":"+X188","v":9.75},{"$f":"(AG188-AC188)/AG188","v":0},null,2,{"$f":"SUM(AJ188:AL188)+AE188","v":9.75},null,null,{"$f":"ROUND(AC188/(1-VLOOKUP(AF188,Group,2,FALSE)),2)","v":9.75},{"$f":"IF(VLOOKUP(AF188,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ188,1)-AJ188,2),Round,2,FALSE)+VLOOKUP(AF188,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF188,Group,7,FALSE)=\"\",0,ROUND(AJ188-0.04999,1)-AJ188+AM188)","v":0},{"$f":"IF(VLOOKUP(AF188,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF188,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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"X"]
[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,"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,"X"]
[null,null,"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.",null,null,null,null,null,null,null,null,null,null,null,null,null,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","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,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01,null,null,null,null,null," "]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page","http://mediterranea-usa.com/"]
[]
[]
["Product","Direct Website Link"]
["BACKWOODS","https://www.mediterranea-usa.com/backwoods.html"]
["BOARDWALK","http://www.mediterranea-usa.com/boardwalk.html"]
["CHICAGO","http://www.mediterranea-usa.com/chicago.html"]
["COPACABANA","https://www.mediterranea-usa.com/copacabana.html"]
["FORUM","http://www.mediterranea-usa.com/forum.html"]
["LOOM","https://www.mediterranea-usa.com/loom.html"]
["MERITAGE","https://www.mediterranea-usa.com/meritage.html"]
["MODERN SLATE","https://www.mediterranea-usa.com/modern-slate.html"]
["NEPTUNE","https://www.mediterranea-usa.com/neptune.html"]
["SAHARA","http://www.mediterranea-usa.com/sahara.html"]
["SYMMETRY","http://www.mediterranea-usa.com/symmetry.html"]
["TOUCH","http://mediterranea-usa.com/usa/touch/"]
["URBAN LOFT","https://www.mediterranea-usa.com/urban-loft.html"]
["VOGUE","http://www.mediterranea-usa.com/vogue.html"]
["WATERFALLS","https://www.mediterranea-usa.com/waterfalls.html"]

{"sheet":"Changes","index":4,"n_rows":149,"n_cols":4,"rows_kept":149,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products:"]
["2008-06-01","Bellagio","Glazed Porcelain"]
["2008-06-01","Metro Life","Rectified TruColor Porcelain"]
["2008-06-01","Safari","Glazed Porcelain"]
["2008-06-01","Sonoma Valley","Glazed Porcelain"]
["2009-09-01","Havana","Rectified TruColor Porcelain"]
["2011-05-24","Mountain Timbers","Inkjet Rectified Porcelain"]
["2011-05-24","American Naturals","Inkjet Rectified Porcelain"]
["2012-12-20","Essence","Glazed Porcelain"]
["2012-12-20","Boardwalk","Inkjet Rectified Porcelain"]
["2012-12-20","Marmol","Inkjet Porcelain"]
["2012-12-20","Precious Stones","Inkjet Porcelain"]
["2012-12-20","Touch","Inkjet Rectified Porcelain"]
["2013-11-20","American Naturals","8\" x 36\" Field Tile size added."]
["2014-07-07","Chicago","Inkjet Porcelain"]
["2014-11-05","Bayside","Color Body Inkjet Porcelain"]
["2014-11-05","Chicago","8\" x 8\", 8\" x 16\" and 16\" x 16\" Field Tile sizes, 3\" x 3\" Mosaic and 3-1/8\" x 16\" Bullnose added in all colors."]
["2014-11-05","Dream","Color Body Inkjet Porcelain"]
["2014-11-05","Forum","Inkjet Porcelain"]
["2014-11-05","Sahara","Color Body Inkjet Porcelain"]
["2014-11-05","Savanna","Color Body Inkjet Rectified Porcelain"]
["2014-11-05","Soho","Inkjet Porcelain"]
["2014-11-05","Stonehenge","Inkjet Porcelain"]
["2014-11-05","Urban Stone","Color Body Inkjet Porcelain"]
["2014-11-05","Vogue","Inkjet Porcelain"]
["2016-02-03","Duomo","Inkjet Porcelain"]
["2016-10-01","Bedrock","Inkjet Porcelain"]
["2016-10-01","Quantum","Extra Large Format HD Inkjet Porcelain"]
["2016-10-01","Sahara","8\" x 48\" Rectified Field Tile format added and is available in all colors."]
["2016-10-01","Symmetry","Inkjet Rectified Porcelain"]
["2017-01-09","Touch","Now available in 3\" x 12\", 4\" x 18\" and 18\" x 36\" Field Tile sizes and 4\" x 36\" Bullnose size in all colors."," "]
["2017-03-06","Martha's Vineyard","Inkjet Rectified Porcelain"]
["2017-12-01","Quantum","Pearl Wave Series Extra Large Format HD Inkjet Porcelain added. "]
["2018-11-30","Backwoods","Inkjet Rectified Porcelain"]
["2018-11-30","Sonoma Coast","Inkjet Rectified Porcelain"]
["2018-11-30","Waterfalls","Inkjet Rectified Porcelain"]
["2019-09-16","Atlantis","Inkjet Porcelain"]
["2019-09-16","Babylon","Inkjet Porcelain"]
["2019-09-16","El Dorado","Inkjet Porcelain"]
["2019-09-16","Neptune","Glazed Ceramic Wall"]
["2019-09-16","Trident","Inkjet Porcelain"]
["2019-09-16","Urban Groove","Glazed Ceramic Wall"]
["2019-11-13","Giza","Inkjet Porcelain"]
["2019-11-13","Inkwell","Inkjet Rectified Porcelain"]
["2020-09-11","Copacabana","Inkjet Porcelain"]
["2020-09-11","Coral Wood","Inkjet Rectified Porcelain"]
["2020-09-11","Forge","Inkjet Rectified Porcelain"]
["2020-09-11","Oceans","Inkjet Rectified Porcelain"]
["2020-09-11","Provincial","Inkjet Rectified Porcelain"]
["2022-03-09","Modern Slate","Inkjet Rectified Porcelain"]
["2023-08-01","Meritage","Inkjet Rectified Porcelain"]
["2024-07-03","Loom","Inkjet Rectified Porcelain"]
[]
[]
[]
[]
["Discontinued Products:"]
["2010-09-15","Safari","Entire Series."]
["2011-05-17","Bellagio","Color Noce only in all items."]
["2011-08-19","Affresco","Entire Series."]
["2011-11-02","Metro Life","Entire Series."]
["2012-10-03","Sonoma Valley","Color Chardonnay (Gold) in all formats."]
["2012-12-04","American Naturals","6\" x 24\" Bullnose in all colors."]
["2012-12-04","Havana","6\" x 24\" Bullnose in all colors."]
["2012-12-04","Mountain Timber","6\" x 24\" Bullnose in all colors."]
["2013-03-12","Sonoma Valley","Entire Series. (Discontinued by Mediterannea)"]
["2013-11-20","American Naturals","4\" x 24\" Field Tile size in all colors."]
["2014-11-05","Precious Stones","18\" x 18\" Field Tile size in all colors."]
["2014-11-05","Precious Stones","Entire Series."]
["2015-05-29","Havana","Colors Cherry and Mambo Red only in all formats.  12\" x 24\" Field Tile format in all colors."]
["2015-12-15","Bellagio","Entire Series. (Discontinued by CCTD)"]
["2016-03-03","Bayside","8\" x 48\" Field Tile format only in all colors."]
["2016-03-03","Havana","Colors Cohiba Tan and Tropicana Gold only in all formats."]
["2016-03-03","Mountain Timber","12\" x 24\" Field Tile format only in all colors."]
["2016-03-03","Urban Stone","8\" x 48\" Field Tile format only in all colors."]
["2016-03-16","Soho","12\" x 24\" Strip Mosaic in all colors."]
["2016-05-12","Mediterranean Stone","Color Light Walnut in all formats."]
["2016-10-25","Mediterranean Stone","Entire Series. Mediterranean Stone is currently marketed under Mediterranea but is actually produced by Ragno.  We have decided to end our relationship with Ragno.  (Discontinued by Conestoga)"]
["2016-10-25","Vatican Gallery","Entire Series. Vatican Gallery is currently marketed under Mediterranea but is actually produced by Ragno.  We have decided to end our relationship with Ragno.  (Discontinued by Conestoga)"]
["2017-08-03","American Naturals","Color Black Rock only in all formats."]
["2017-08-03","Havana","Color Sugarcane White only in all formats."]
["2017-08-03","Marmol","Brushed Finish only in all colors and formats."]
["2017-08-03","Mountain Timber","Entire Series."]
["2017-08-03","Savanna","Colors Oak and Saddle only in all formats."]
["2017-08-03","Stonehenge","Entire Series."]
["2017-08-03","Urban Stone","Entire Series."]
["2018-04-12","Vogue","Color Hazelnut only in all formats."]
["2018-07-10","Bayside","24\" x 48\" Field Tile Format only in all colors."]
["2018-07-10","Forum","Color Walnut only in all formats."]
["2018-07-10","Symmetry","All formats with the \"Wave\" fabric pattern only."]
["2018-07-10","Touch","18\" x 36\" Field Tile Format only in all colors."]
["2019-06-17","Dream","Entire Series."]
["2019-06-17","Marmol","18\" x 18\" Rectified Field Tile format in all colors in both the Honed and the Polished finishes. "]
["2019-06-17","Savanna","Entire Series."]
["2019-11-15","Bedrock","Entire Series."]
["2020-01-16","American Naturals","Entire Series."]
["2020-01-16","Bayside","Colors Pewter & Tobacco only in all formats."]
["2020-01-16","Marmol","Colors Cafe & Select only in all formats & finishes."]
["2020-01-16","Sonoma Coast","Entire Series."]
["2020-01-16","Symmetry","Color Café only in all formats."]
["2020-01-16","Touch","The following formats in all colors:  3\" x 6\", 3\" x 12\", 12\" x 12\" & 4\" x 18\" Field Tile and 4\" x 36\" Bullnose."]
["2020-08-03","Havana","Entire Series."]
["2021-05-04","Forge","8\" x 48\" and 24\" x 48\" Field Tile formats in all colors."]
["2021-05-26","Coral Wood","Entire Series."]
["2021-05-26","Inkwell","Entire Series."]
["2021-05-26","Provincial","Color Pinot Noir 12\" x 48\" Field Tile format only."]
["2021-05-26","Sahara","8\" x 48\" Field Tile format only in all colors."]
["2021-05-26","Vogue","12\" x 12\" Field Tile format only in color Warm Grey."]
["2021-10-01","Marmol","12\" x 12\" Field Tile format in both the Honed and the Polished/Rectified finishes in all colors. "]
["2021-10-01","Oceans","Entire Series."]
["2021-11-11","Bayside","Entire Series."]
["2021-11-11","El Dorado","Entire Series."]
["2021-11-11","Giza","Entire Series."]
["2021-11-11","Marmol","Entire Series."]
["2021-11-11","Martha's Vineyard","12\" x 48\" Field Tile format only in all colors."]
["2021-11-11","Soho","Entire Series."]
["2021-11-11","Symmetry","3\" x 12\" Field Tile format only in all colors."]
["2021-11-11","Waterfalls","8\" x 48\" Field Tile format only in all colors."]
["2022-03-09","Quantum Pearl Wave","All formats of the Pearl Wave colors Designer Grey and Extra White only."]
["2022-06-14","Chicago","8\" x 8\" and 16\" x 16\" Field Tile formats in color State Street (Café) and 8\" x 8\", 8\" x 16\" and 16\" x 16\" Field Tile formats in color Wrigley (Red) only."]
["2023-01-17","Babylon","Entire Series."]
["2023-01-17","Forge","Entire Series."]
["2023-01-17","Martha's Vineyard","Entire Series."]
["2023-01-25","Essence","Entire Series.","(Discontinued by CCTD, however, we will no longer be importing from the factory in Turkey that produces the Essence series.  We will not be ordering any more material period.)"]
["2023-03-02","Duomo","Entire Series.","(Discontinued by Manufacturer)"]
["2023-08-01","Chicago","3\" x 3\" Mosaic and 2-5/8\" x 16\" Bullnose formats in color Wrigley (Red) only.","(Discontinued by Manufacturer)"]
["2023-11-17","Atlantis","Entire Series.","(Discontinued by Manufacturer)"]
["2023-11-17","Forum","Color Cappuccino only in all formats.","(Discontinued by Manufacturer)"]
["2023-11-17","Provincial","Entire Series.","(Discontinued by Manufacturer)"]
["2023-11-17","Sahara","Color Autumn only in all formats.","(Discontinued by Manufacturer)"]
["2023-11-17","Trident","Entire Series.","(Discontinued by Manufacturer)"]
["2023-11-17","Waterfalls","4\" x 12\" and 24\" x 48\" Field Tile formats only in all colors.","(Discontinued by Manufacturer)"]
["2024-04-11","Urban Groove","Entire Series.","(Discontinued by Manufacturer)"]
["2024-07-03","Chicago","4\" x 8\" City Mix Field in colors State Street (Café) and Wrigley (Red) only.  8\" x 16\" Field and 2-5/8\" x 16\" Bullnose in color State Street (Café) only.  4\" x 2-9/16\" x 5-5/16 \"L\" Corner Wall Piece in all colors.","(Discontinued by Manufacturer)"]
["2024-07-03","Quantum","Entire Series.","(Discontinued by Manufacturer)"]
[]
[]
[]
["Changes:"]
["2014-11-05","Marmol","The 18\" x 18\" Field Tile in the Brushed and Honed finishes is being changed to a rectified format.  The rectified format will be available as Mediterranea's inventory of the pressed format is depleted."]
["2015-10-16","Chicago","The size of the Bullnose will be changing from 3-1/8\" x 16\" to 2-5/8\" x 16\" as inventory of the old size is depleted.  "]
["2024-09-27","Chicago","2-5/8\" x 16\" Bullnose format is no longer being \"Stocked\" in any color."]
["2024-09-27","Meritage","All formats in all colors are no longer being \"Stocked\"."]
["2024-09-27","Modern Slate","3\" x 24\" Bullnose format is no longer being \"Stocked\" in any color."]
["2024-09-27","Neptune","8\" x 8\" Field Tile format is no longer being \"Stocked\"."]
["2024-09-27","Waterfalls","All formats in all colors are no longer being \"Stocked\"."]