{"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":18,"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":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Mediterranea"]
["File as","M"]
["Product Code","B"]
["CCTD Effective Date","8/1/23 (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":"B"}]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"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/23 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type"]
["1",null,"Atlantis",null,"Inkjet Porcelain"]
["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,"Meritage",null,"Inkjet Porcelain"]
[1,null,"Modern Slate",null,"Inkjet Rectified Porcelain"]
[2,null,"Neptune",null,"Glazed Ceramic Wall"]
[2,null,"Provincial",null,"Inkjet Rectified Porcelain"]
[2,null,"Quantum",null,"Extra Large Format HD Inkjet Porcelain"]
[2,null,"Sahara",null,"Color Body Inkjet Porcelain"]
[2,null,"Symmetry",null,"Inkjet Rectified Porcelain"]
[2,null,"Touch",null,"Inkjet Rectified Porcelain"]
[3,null,"Trident",null,"Inkjet Porcelain"]
[3,null,"Urban Groove",null,"Glazed Ceramic Wall"]
[3,null,"Vogue",null,"Inkjet Porcelain"]
[3,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":311,"n_cols":41,"rows_kept":311,"cut":false,"hidden":false,"merged":[[15,30,15,32],[14,22,14,23],[12,14,12,15],[11,14,11,19],[11,22,11,23],[11,25,11,32],[295,2,295,19],[14,14,14,19],[16,13,17,19],[300,3,300,4],[20,2,20,19],[19,14,19,15],[297,2,297,18]]}
[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":"B"},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":"B"},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":"B"},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":"B"},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":"B"},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":"B"},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":"B"},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":"B"},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,null,{"$f":"IF(Suggested=\"Yes\",AA9,AG9)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},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/23 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-07-28"},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 'B'"},null,null,null,null,null,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,"ATLANTIS - Inkjet Porcelain",null,null,null,null,null,null,null,null," ",null,null,null,null,null,"Item # Lookup:","MEAT",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:","Atlantis",null,null,null,null,null,null,null,null,null,null,null,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 12\"",null,"Field",null,null,null,null,null,null,null,null,"9.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA27,AG27)","v":5.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA27*(1-W27)+0.004999,2)","v":5.25},null,"",5.25,{"$f":"+W27","v":0},{"$f":"+X27","v":5.25},{"$f":"(AG27-AC27)/AG27","v":0},null,1,{"$f":"SUM(AJ27:AL27)+AE27","v":5.25},null,null,{"$f":"ROUND(AC27/(1-VLOOKUP(AF27,Group,2,FALSE)),2)","v":5.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,"Decos",null,null,"12\" x 12\"",null,"Field - Poseidon Decos",null,null,null,null,null,null,null,null,"9.69 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA28,AG28)","v":5.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA28*(1-W28)+0.004999,2)","v":5.7},null,"",5.7,{"$f":"+W28","v":0},{"$f":"+X28","v":5.7},{"$f":"(AG28-AC28)/AG28","v":0},null,3,{"$f":"SUM(AJ28:AL28)+AE28","v":5.7},null,null,{"$f":"ROUND(AC28/(1-VLOOKUP(AF28,Group,2,FALSE)),2)","v":5.7},{"$f":"IF(VLOOKUP(AF28,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ28,1)-AJ28,2),Round,2,FALSE)+VLOOKUP(AF28,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF28,Group,7,FALSE)=\"\",0,ROUND(AJ28-0.04999,1)-AJ28+AM28)","v":0},{"$f":"IF(VLOOKUP(AF28,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF28,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,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA30,AG30)","v":23.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA30*(1-W30)+0.004999,2)","v":23.65},null,"",23.65,{"$f":"+W30","v":0},{"$f":"+X30","v":23.65},{"$f":"(AG30-AC30)/AG30","v":0},null,3,{"$f":"SUM(AJ30:AL30)+AE30","v":23.65},null,null,{"$f":"ROUND(AC30/(1-VLOOKUP(AF30,Group,2,FALSE)),2)","v":23.65},{"$f":"IF(VLOOKUP(AF30,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ30,1)-AJ30,2),Round,2,FALSE)+VLOOKUP(AF30,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF30,Group,7,FALSE)=\"\",0,ROUND(AJ30-0.04999,1)-AJ30+AM30)","v":0},{"$f":"IF(VLOOKUP(AF30,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF30,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\",AA32,AG32)","v":6.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":6.65},null,"",6.65,{"$f":"+W32","v":0},{"$f":"+X32","v":6.65},{"$f":"(AG32-AC32)/AG32","v":0},null,2,{"$f":"SUM(AJ32:AL32)+AE32","v":6.65},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":6.65},{"$f":"IF(VLOOKUP(AF32,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ32,1)-AJ32,2),Round,2,FALSE)+VLOOKUP(AF32,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",0,ROUND(AJ32-0.04999,1)-AJ32+AM32)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF32,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:","a) A distinctive mix of 6 randomly-blended deco pieces.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"BACKWOODS - Inkjet Rectified Porcelain",null,null,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\",AA40,AG40)","v":6.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA40*(1-W40)+0.004999,2)","v":6.65},null,"",6.65,{"$f":"+W40","v":0},{"$f":"+X40","v":6.65},{"$f":"(AG40-AC40)/AG40","v":0},null,1,{"$f":"SUM(AJ40:AL40)+AE40","v":6.65},null,null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":6.65},{"$f":"IF(VLOOKUP(AF40,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ40,1)-AJ40,2),Round,2,FALSE)+VLOOKUP(AF40,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,7,FALSE)=\"\",0,ROUND(AJ40-0.04999,1)-AJ40+AM40)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF40,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\",AA47,AG47)","v":7.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA47*(1-W47)+0.004999,2)","v":7.95},null,"",7.95,{"$f":"+W47","v":0},{"$f":"+X47","v":7.95},{"$f":"(AG47-AC47)/AG47","v":0},null,1,{"$f":"SUM(AJ47:AL47)+AE47","v":7.95},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":7.95},{"$f":"IF(VLOOKUP(AF47,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ47,1)-AJ47,2),Round,2,FALSE)+VLOOKUP(AF47,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF47,Group,7,FALSE)=\"\",0,ROUND(AJ47-0.04999,1)-AJ47+AM47)","v":0},{"$f":"IF(VLOOKUP(AF47,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF47,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\",AA48,AG48)","v":8.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA48*(1-W48)+0.004999,2)","v":8.35},null,"",8.35,{"$f":"+W48","v":0},{"$f":"+X48","v":8.35},{"$f":"(AG48-AC48)/AG48","v":0},null,1,{"$f":"SUM(AJ48:AL48)+AE48","v":8.35},null,null,{"$f":"ROUND(AC48/(1-VLOOKUP(AF48,Group,2,FALSE)),2)","v":8.35},{"$f":"IF(VLOOKUP(AF48,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ48,1)-AJ48,2),Round,2,FALSE)+VLOOKUP(AF48,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF48,Group,7,FALSE)=\"\",0,ROUND(AJ48-0.04999,1)-AJ48+AM48)","v":0},{"$f":"IF(VLOOKUP(AF48,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF48,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\",AA50,AG50)","v":12.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA50*(1-W50)+0.004999,2)","v":12.05},null,"",12.05,{"$f":"+W50","v":0},{"$f":"+X50","v":12.05},{"$f":"(AG50-AC50)/AG50","v":0},null,2,{"$f":"SUM(AJ50:AL50)+AE50","v":12.05},null,null,{"$f":"ROUND(AC50/(1-VLOOKUP(AF50,Group,2,FALSE)),2)","v":12.05},{"$f":"IF(VLOOKUP(AF50,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ50,1)-AJ50,2),Round,2,FALSE)+VLOOKUP(AF50,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF50,Group,7,FALSE)=\"\",0,ROUND(AJ50-0.04999,1)-AJ50+AM50)","v":0},{"$f":"IF(VLOOKUP(AF50,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF50,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\",AA57,AG57)","v":9.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA57*(1-W57)+0.004999,2)","v":9.35},null,"YES",9.35,{"$f":"+W57","v":0},9.35,{"$f":"(AG57-AC57)/AG57","v":0},null,4,{"$f":"SUM(AJ57:AL57)+AE57","v":9.35},null,null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":9.35},{"$f":"IF(VLOOKUP(AF57,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ57,1)-AJ57,2),Round,2,FALSE)+VLOOKUP(AF57,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",0,ROUND(AJ57-0.04999,1)-AJ57+AM57)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF57,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",9.9,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.9,null,"YES",9.9,0,9.9,0,null,4,9.9,null,null,9.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",9.5500000000000007,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.5500000000000007,null,"YES",9.5500000000000007,0,9.5500000000000007,0,null,4,9.5500000000000007,null,null,9.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","d",9.5500000000000007,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.5500000000000007,null,"YES",9.5500000000000007,{"$f":"+W60","v":0},{"$f":"+X60","v":9.5500000000000007},0,null,4,9.5500000000000007,null,null,9.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,e",9.4,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.4,null,"YES",9.4,{"$f":"+W61","v":0},{"$f":"+X61","v":9.4},0,null,4,9.4,null,null,9.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,12.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},12.05,null,"YES",12.05,0,12.05,0,null,4,12.05,null,null,12.05,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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","d",{"$f":"IF(Suggested=\"Yes\",AA64,AG64)","v":29.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":29.2},null,"YES",29.2,0,29.2,{"$f":"(AG64-AC64)/AG64","v":0},null,6,{"$f":"SUM(AJ64:AL64)+AE64","v":29.2},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":29.2},{"$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,"Import I - Trim",null,null,"4\" x 2-9/16\" x 5-5/16",null,"\"L\" Corner Wall Piece",null,null,null,null,null,null,null,null," 10 PCS/CTN",null,"e",{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":20.350000000000001},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA66*(1-W66)+0.004999,2)","v":20.350000000000001},null,"YES",20.350000000000001,{"$f":"+W66","v":0},{"$f":"+X66","v":20.350000000000001},{"$f":"(AG66-AC66)/AG66","v":0},null,5,{"$f":"SUM(AJ66:AL66)+AE66","v":20.350000000000001},null,null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":20.350000000000001},{"$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,"Import I - Trim",null,null,"2-5/8\" x 16\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock","d",{"$f":"IF(Suggested=\"Yes\",AA67,AG67)","v":10.4},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA67*(1-W67)+0.004999,2)","v":10.4},null,"YES",10.4,{"$f":"+W67","v":0},{"$f":"+X67","v":10.4},{"$f":"(AG67-AC67)/AG67","v":0},null,5,{"$f":"SUM(AJ67:AL67)+AE67","v":10.4},null,null,{"$f":"ROUND(AC67/(1-VLOOKUP(AF67,Group,2,FALSE)),2)","v":10.4},{"$f":"IF(VLOOKUP(AF67,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ67,1)-AJ67,2),Round,2,FALSE)+VLOOKUP(AF67,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF67,Group,7,FALSE)=\"\",0,ROUND(AJ67-0.04999,1)-AJ67+AM67)","v":0},{"$f":"IF(VLOOKUP(AF67,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF67,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,"d) Not available in color Wrigley (Red).",null,null,null,null,"e) 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\",AA78,AG78)","v":5.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":5.95},null,"",5.95,{"$f":"+W78","v":0},{"$f":"+X78","v":5.95},{"$f":"(AG78-AC78)/AG78","v":0},null,1,{"$f":"SUM(AJ78:AL78)+AE78","v":5.95},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":5.95},{"$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,"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\",AA80,AG80)","v":23.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA80*(1-W80)+0.004999,2)","v":23.8},null,"",23.8,{"$f":"+W80","v":0},{"$f":"+X80","v":23.8},{"$f":"(AG80-AC80)/AG80","v":0},null,3,{"$f":"SUM(AJ80:AL80)+AE80","v":23.8},null,null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":23.8},{"$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,"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\",AA82,AG82)","v":10.55},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":10.55},null,"",10.55,{"$f":"+W82","v":0},{"$f":"+X82","v":10.55},{"$f":"(AG82-AC82)/AG82","v":0},null,2,{"$f":"SUM(AJ82:AL82)+AE82","v":10.55},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":10.55},{"$f":"IF(VLOOKUP(AF82,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ82,1)-AJ82,2),Round,2,FALSE)+VLOOKUP(AF82,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",0,ROUND(AJ82-0.04999,1)-AJ82+AM82)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF82,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:","Cappuccino          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\",AA88,AG88)","v":6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA88*(1-W88)+0.004999,2)","v":6},null,"",6,{"$f":"+W88","v":0},{"$f":"+X88","v":6},{"$f":"(AG88-AC88)/AG88","v":0},null,1,{"$f":"SUM(AJ88:AL88)+AE88","v":6},null,null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":6},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA90,AG90)","v":34.299999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA90*(1-W90)+0.004999,2)","v":34.299999999999997},null,"",34.299999999999997,{"$f":"+W90","v":0},34.299999999999997,{"$f":"(AG90-AC90)/AG90","v":0},null,3,{"$f":"SUM(AJ90:AL90)+AE90","v":34.299999999999997},null,null,{"$f":"ROUND(AC90/(1-VLOOKUP(AF90,Group,2,FALSE)),2)","v":34.299999999999997},{"$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,"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\",AA91,AG91)","v":23.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":23.8},null,"",23.8,0,23.8,{"$f":"(AG91-AC91)/AG91","v":0},null,3,{"$f":"SUM(AJ91:AL91)+AE91","v":23.8},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":23.8},{"$f":"IF(VLOOKUP(AF91,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ91,1)-AJ91,2),Round,2,FALSE)+VLOOKUP(AF91,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",0,ROUND(AJ91-0.04999,1)-AJ91+AM91)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF91,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\",AA92,AG92)","v":34.4},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":34.4},null,"",34.4,0,34.4,{"$f":"(AG92-AC92)/AG92","v":0},null,3,{"$f":"SUM(AJ92:AL92)+AE92","v":34.4},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":34.4},{"$f":"IF(VLOOKUP(AF92,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ92,1)-AJ92,2),Round,2,FALSE)+VLOOKUP(AF92,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",0,ROUND(AJ92-0.04999,1)-AJ92+AM92)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF92,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\",AA94,AG94)","v":10.55},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA94*(1-W94)+0.004999,2)","v":10.55},null,"",10.55,{"$f":"+W94","v":0},{"$f":"+X94","v":10.55},{"$f":"(AG94-AC94)/AG94","v":0},null,2,{"$f":"SUM(AJ94:AL94)+AE94","v":10.55},null,null,{"$f":"ROUND(AC94/(1-VLOOKUP(AF94,Group,2,FALSE)),2)","v":10.55},{"$f":"IF(VLOOKUP(AF94,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ94,1)-AJ94,2),Round,2,FALSE)+VLOOKUP(AF94,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",0,ROUND(AJ94-0.04999,1)-AJ94+AM94)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF94,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","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA100,AG100)","v":6.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA100*(1-W100)+0.004999,2)","v":6.3},null,"new",6.3,{"$f":"+W100","v":0},{"$f":"+X100","v":6.3},{"$f":"(AG100-AC100)/AG100","v":0},null,1,{"$f":"SUM(AJ100:AL100)+AE100","v":6.3},null,null,{"$f":"ROUND(AC100/(1-VLOOKUP(AF100,Group,2,FALSE)),2)","v":6.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,"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\",AA102,AG102)","v":23.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA102*(1-W102)+0.004999,2)","v":23.8},null,"new",23.8,{"$f":"+W102","v":0},{"$f":"+X102","v":23.8},{"$f":"(AG102-AC102)/AG102","v":0},null,3,{"$f":"SUM(AJ102:AL102)+AE102","v":23.8},null,null,{"$f":"ROUND(AC102/(1-VLOOKUP(AF102,Group,2,FALSE)),2)","v":23.8},{"$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,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,"Matte",null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA104,AG104)","v":12.15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA104*(1-W104)+0.004999,2)","v":12.15},null,"new",12.15,{"$f":"+W104","v":0},{"$f":"+X104","v":12.15},{"$f":"(AG104-AC104)/AG104","v":0},null,2,{"$f":"SUM(AJ104:AL104)+AE104","v":12.15},null,null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":12.15},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA106,AG106)","v":8.4499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":8.4499999999999993},null,"new",8.4499999999999993,{"$f":"+W106","v":0},{"$f":"+X106","v":8.4499999999999993},{"$f":"(AG106-AC106)/AG106","v":0},null,1,{"$f":"SUM(AJ106:AL106)+AE106","v":8.4499999999999993},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":8.4499999999999993},{"$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,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,"Polished",null,null,"Mesh-Mounted",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA108,AG108)","v":26.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA108*(1-W108)+0.004999,2)","v":26.8},null,"new",26.8,{"$f":"+W108","v":0},{"$f":"+X108","v":26.8},{"$f":"(AG108-AC108)/AG108","v":0},null,3,{"$f":"SUM(AJ108:AL108)+AE108","v":26.8},null,null,{"$f":"ROUND(AC108/(1-VLOOKUP(AF108,Group,2,FALSE)),2)","v":26.8},{"$f":"IF(VLOOKUP(AF108,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ108,1)-AJ108,2),Round,2,FALSE)+VLOOKUP(AF108,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",0,ROUND(AJ108-0.04999,1)-AJ108+AM108)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF108,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,"Polished",null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA110,AG110)","v":15.15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA110*(1-W110)+0.004999,2)","v":15.15},null,"new",15.15,{"$f":"+W110","v":0},{"$f":"+X110","v":15.15},{"$f":"(AG110-AC110)/AG110","v":0},null,2,{"$f":"SUM(AJ110:AL110)+AE110","v":15.15},null,null,{"$f":"ROUND(AC110/(1-VLOOKUP(AF110,Group,2,FALSE)),2)","v":15.15},{"$f":"IF(VLOOKUP(AF110,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ110,1)-AJ110,2),Round,2,FALSE)+VLOOKUP(AF110,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",0,ROUND(AJ110-0.04999,1)-AJ110+AM110)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF110,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\",AA116,AG116)","v":6.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA116*(1-W116)+0.004999,2)","v":6.3},null,"",6.3,{"$f":"+W116","v":0},{"$f":"+X116","v":6.3},{"$f":"(AG116-AC116)/AG116","v":0},null,1,{"$f":"SUM(AJ116:AL116)+AE116","v":6.3},null,null,{"$f":"ROUND(AC116/(1-VLOOKUP(AF116,Group,2,FALSE)),2)","v":6.3},{"$f":"IF(VLOOKUP(AF116,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ116,1)-AJ116,2),Round,2,FALSE)+VLOOKUP(AF116,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",0,ROUND(AJ116-0.04999,1)-AJ116+AM116)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF116,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\",AA117,AG117)","v":7.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA117*(1-W117)+0.004999,2)","v":7.75},null,"",7.75,{"$f":"+W117","v":0},{"$f":"+X117","v":7.75},{"$f":"(AG117-AC117)/AG117","v":0},null,1,{"$f":"SUM(AJ117:AL117)+AE117","v":7.75},null,null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":7.75},{"$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,"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\",AA119,AG119)","v":23.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA119*(1-W119)+0.004999,2)","v":23.8},null,"",23.8,{"$f":"+W119","v":0},{"$f":"+X119","v":23.8},{"$f":"(AG119-AC119)/AG119","v":0},null,3,{"$f":"SUM(AJ119:AL119)+AE119","v":23.8},null,null,{"$f":"ROUND(AC119/(1-VLOOKUP(AF119,Group,2,FALSE)),2)","v":23.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,"Matte",null,null,null,null,null,null,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,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA121,AG121)","v":12.15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA121*(1-W121)+0.004999,2)","v":12.15},null,"",12.15,{"$f":"+W121","v":0},{"$f":"+X121","v":12.15},{"$f":"(AG121-AC121)/AG121","v":0},null,2,{"$f":"SUM(AJ121:AL121)+AE121","v":12.15},null,null,{"$f":"ROUND(AC121/(1-VLOOKUP(AF121,Group,2,FALSE)),2)","v":12.15},{"$f":"IF(VLOOKUP(AF121,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ121,1)-AJ121,2),Round,2,FALSE)+VLOOKUP(AF121,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",0,ROUND(AJ121-0.04999,1)-AJ121+AM121)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF121,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\",AA123,AG123)","v":6.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA123*(1-W123)+0.004999,2)","v":6.7},null,"",6.7,{"$f":"+W123","v":0},{"$f":"+X123","v":6.7},{"$f":"(AG123-AC123)/AG123","v":0},null,1,{"$f":"SUM(AJ123:AL123)+AE123","v":6.7},null,null,{"$f":"ROUND(AC123/(1-VLOOKUP(AF123,Group,2,FALSE)),2)","v":6.7},{"$f":"IF(VLOOKUP(AF123,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ123,1)-AJ123,2),Round,2,FALSE)+VLOOKUP(AF123,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",0,ROUND(AJ123-0.04999,1)-AJ123+AM123)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF123,Group,7,FALSE))","v":""},null,"X"]
[null,null,"NEPTUNE - Glazed Ceramic Wall Tile",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","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA128,AG128)","v":10.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA128*(1-W128)+0.004999,2)","v":10.7},null,"",10.7,{"$f":"+W128","v":0},{"$f":"+X128","v":10.7},{"$f":"(AG128-AC128)/AG128","v":0},null,1,{"$f":"SUM(AJ128:AL128)+AE128","v":10.7},null,null,{"$f":"ROUND(AC128/(1-VLOOKUP(AF128,Group,2,FALSE)),2)","v":10.7},{"$f":"IF(VLOOKUP(AF128,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ128,1)-AJ128,2),Round,2,FALSE)+VLOOKUP(AF128,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",0,ROUND(AJ128-0.04999,1)-AJ128+AM128)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF128,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,"PROVINCIAL - Inkjet Rectified Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MEPR",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:","Champagne          Chardonnay          Merlot          Prosecco",null,null,null,null,null,null,null,null,null,null,null,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 48\"",null,"Field",null,null,null,null,null,null,null,null,"19.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA136,AG136)","v":7.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA136*(1-W136)+0.004999,2)","v":7.7},null,"",7.7,{"$f":"+W136","v":0},{"$f":"+X136","v":7.7},{"$f":"(AG136-AC136)/AG136","v":0},null,1,{"$f":"SUM(AJ136:AL136)+AE136","v":7.7},null,null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":7.7},{"$f":"IF(VLOOKUP(AF136,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ136,1)-AJ136,2),Round,2,FALSE)+VLOOKUP(AF136,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",0,ROUND(AJ136-0.04999,1)-AJ136+AM136)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF136,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,"QUANTUM - Limitless Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MEQU",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,"Quantum Extra Large Format Porcelain will also involve additional packaging charges depending on sizes & quantities.  See below for these additional charges.",null,null,null,null,null,null,null,null,null,null,null,null,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,"QUANTUM Packaging Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MEQUZZ",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,"Size",null,null,null,null,"Total Pieces per Crate",null,null,"Description",null,null,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,null,null,"15\" x 30\" x 6mm",null,null,null,264,null,null,"Big Crate",null," ",null,null,{"$f":"IF(Suggested=\"Yes\",AA146,AG146)","v":160.19999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA146*(1-W146)+0.004999,2)","v":160.19999999999999},null,"",160.19999999999999,{"$f":"+W146","v":0},{"$f":"+X146","v":160.19999999999999},{"$f":"(AG146-AC146)/AG146","v":0},null,1,{"$f":"SUM(AJ146:AL146)+AE146","v":160.19999999999999},null,null,{"$f":"ROUND(AC146/(1-VLOOKUP(AF146,Group,2,FALSE)),2)","v":160.19999999999999},{"$f":"IF(VLOOKUP(AF146,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ146,1)-AJ146,2),Round,2,FALSE)+VLOOKUP(AF146,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",0,ROUND(AJ146-0.04999,1)-AJ146+AM146)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF146,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,null,null,"30\" x 30\" x 6mm",null,null,null,114,null,null,"Big Crate",null,null,null,null,160.19999999999999,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},160.19999999999999,null,"",160.19999999999999,0,160.19999999999999,0,null,1,160.19999999999999,null,null,160.19999999999999,0,0,"",null,"X"]
[null,"Field Tile",null,null,null,null,"30\" x 60\" x 6mm",null,null,null,"24 - 52",null,null,"Big Crate",null,null,null,null,160.19999999999999,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},160.19999999999999,null,"",160.19999999999999,0,160.19999999999999,0,null,1,160.19999999999999,null,null,160.19999999999999,0,0,"",null,"X"]
[null,"Field Tile",null,null,null,null,"30\" x 60\" x 6mm",null,null,null,"24",null,null,"Half T-Frame",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA149,AG149)","v":560.54999999999995},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA149*(1-W149)+0.004999,2)","v":560.54999999999995},null,"",560.54999999999995,{"$f":"+W149","v":0},{"$f":"+X149","v":560.54999999999995},{"$f":"(AG149-AC149)/AG149","v":0},null,1,{"$f":"SUM(AJ149:AL149)+AE149","v":560.54999999999995},null,null,{"$f":"ROUND(AC149/(1-VLOOKUP(AF149,Group,2,FALSE)),2)","v":560.54999999999995},{"$f":"IF(VLOOKUP(AF149,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ149,1)-AJ149,2),Round,2,FALSE)+VLOOKUP(AF149,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",0,ROUND(AJ149-0.04999,1)-AJ149+AM149)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF149,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,null,null,"60\" x 60\" x 6mm",null,null,null,"12",null,null,"Half T-Frame",null,null,null,null,560.54999999999995,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},560.54999999999995,null,"",560.54999999999995,0,560.54999999999995,0,null,1,560.54999999999995,null,null,560.54999999999995,0,0,"",null,"X"]
[null,"Field Tile",null,null,null,null,"60\" x 120\" x 6mm",null,null,null,50,null,null,"A-Frame",null,null,null,null,584.54999999999995,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},584.54999999999995,null,"",584.54999999999995,0,584.54999999999995,0,null,1,584.54999999999995,null,null,584.54999999999995,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,null,null,"QUANTUM STONE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MEQUQS",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,"Quantum Extra Large Format Porcelain will also involve additional packaging charges depending on sizes & quantities.  See above for these additional charges.",null,null,null,null,null,null,null,null,null,null,null,null,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,"Colors:",null,"Essential Grey          Optimum White",null,null,null,null,null,null,null,null,null,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,"30\" x 30\" x 6mm",null,"Field",null,null,null,"Honed",null,null,null,null,"36.30 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA159,AG159)","v":18.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA159*(1-W159)+0.004999,2)","v":18.5},null,"",18.5,{"$f":"+W159","v":0},18.5,{"$f":"(AG159-AC159)/AG159","v":0},null,1,{"$f":"SUM(AJ159:AL159)+AE159","v":18.5},null,null,{"$f":"ROUND(AC159/(1-VLOOKUP(AF159,Group,2,FALSE)),2)","v":18.5},{"$f":"IF(VLOOKUP(AF159,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ159,1)-AJ159,2),Round,2,FALSE)+VLOOKUP(AF159,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",0,ROUND(AJ159-0.04999,1)-AJ159+AM159)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF159,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"30\" x 60\" x 6mm",null,"Field",null," ",null,"Honed",null,null,null,null,"24.21 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA160,AG160)","v":18.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA160*(1-W160)+0.004999,2)","v":18.5},null,"",18.5,0,18.5,{"$f":"(AG160-AC160)/AG160","v":0},null,1,{"$f":"SUM(AJ160:AL160)+AE160","v":18.5},null,null,{"$f":"ROUND(AC160/(1-VLOOKUP(AF160,Group,2,FALSE)),2)","v":18.5},{"$f":"IF(VLOOKUP(AF160,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ160,1)-AJ160,2),Round,2,FALSE)+VLOOKUP(AF160,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF160,Group,7,FALSE)=\"\",0,ROUND(AJ160-0.04999,1)-AJ160+AM160)","v":0},{"$f":"IF(VLOOKUP(AF160,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF160,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"60\" x 60\" x 6mm",null,"Field",null,null,null,"Honed",null,null,null,null,"96.84 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA161,AG161)","v":21.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA161*(1-W161)+0.004999,2)","v":21.65},null,"",21.65,0,21.65,{"$f":"(AG161-AC161)/AG161","v":0},null,1,{"$f":"SUM(AJ161:AL161)+AE161","v":21.65},null,null,{"$f":"ROUND(AC161/(1-VLOOKUP(AF161,Group,2,FALSE)),2)","v":21.65},{"$f":"IF(VLOOKUP(AF161,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ161,1)-AJ161,2),Round,2,FALSE)+VLOOKUP(AF161,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",0,ROUND(AJ161-0.04999,1)-AJ161+AM161)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF161,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"60\" x 120\" x 6mm",null,"Field",null,null,null,"Honed",null,null,null,null,"96.84 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA162,AG162)","v":27.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA162*(1-W162)+0.004999,2)","v":27.3},null,"",27.3,0,27.3,{"$f":"(AG162-AC162)/AG162","v":0},null,1,{"$f":"SUM(AJ162:AL162)+AE162","v":27.3},null,null,{"$f":"ROUND(AC162/(1-VLOOKUP(AF162,Group,2,FALSE)),2)","v":27.3},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"30\" x 30\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"36.30 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA164,AG164)","v":21.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA164*(1-W164)+0.004999,2)","v":21.65},null,"",21.65,{"$f":"+W164","v":0},21.65,{"$f":"(AG164-AC164)/AG164","v":0},null,1,{"$f":"SUM(AJ164:AL164)+AE164","v":21.65},null,null,{"$f":"ROUND(AC164/(1-VLOOKUP(AF164,Group,2,FALSE)),2)","v":21.65},{"$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,"Field Tile",null,null,"30\" x 60\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"24.21 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA165,AG165)","v":21.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA165*(1-W165)+0.004999,2)","v":21.65},null,"",21.65,0,21.65,{"$f":"(AG165-AC165)/AG165","v":0},null,1,{"$f":"SUM(AJ165:AL165)+AE165","v":21.65},null,null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":21.65},{"$f":"IF(VLOOKUP(AF165,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ165,1)-AJ165,2),Round,2,FALSE)+VLOOKUP(AF165,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",0,ROUND(AJ165-0.04999,1)-AJ165+AM165)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF165,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"60\" x 60\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"96.84 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA166,AG166)","v":25.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":25.3},null,"",25.3,0,25.3,{"$f":"(AG166-AC166)/AG166","v":0},null,1,{"$f":"SUM(AJ166:AL166)+AE166","v":25.3},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":25.3},{"$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,"Field Tile",null,null,"60\" x 120\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"96.84 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA167,AG167)","v":30.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA167*(1-W167)+0.004999,2)","v":30.65},null,"",30.65,0,30.65,{"$f":"(AG167-AC167)/AG167","v":0},null,1,{"$f":"SUM(AJ167:AL167)+AE167","v":30.65},null,null,{"$f":"ROUND(AC167/(1-VLOOKUP(AF167,Group,2,FALSE)),2)","v":30.65},{"$f":"IF(VLOOKUP(AF167,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ167,1)-AJ167,2),Round,2,FALSE)+VLOOKUP(AF167,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF167,Group,7,FALSE)=\"\",0,ROUND(AJ167-0.04999,1)-AJ167+AM167)","v":0},{"$f":"IF(VLOOKUP(AF167,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF167,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,"WHITE WOOD",null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MEQUWW",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,"Quantum Extra Large Format Porcelain will also involve additional packaging charges depending on sizes & quantities.  See above for these additional charges.",null,null,null,null,null,null,null,null,null,null,null,null,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,"Color:","White 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,"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,"30\" x 30\" x 6mm",null,"Field",null,null,null,"Honed",null,null,null,null,"36.30 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA175,AG175)","v":18.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA175*(1-W175)+0.004999,2)","v":18.5},null,"",18.5,{"$f":"+W175","v":0},18.5,{"$f":"(AG175-AC175)/AG175","v":0},null,1,{"$f":"SUM(AJ175:AL175)+AE175","v":18.5},null,null,{"$f":"ROUND(AC175/(1-VLOOKUP(AF175,Group,2,FALSE)),2)","v":18.5},{"$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,"Field Tile",null,null,"30\" x 60\" x 6mm",null,"Field",null," ",null,"Honed",null,null,null,null,"24.21 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA176,AG176)","v":18.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA176*(1-W176)+0.004999,2)","v":18.5},null,"",18.5,0,18.5,{"$f":"(AG176-AC176)/AG176","v":0},null,1,{"$f":"SUM(AJ176:AL176)+AE176","v":18.5},null,null,{"$f":"ROUND(AC176/(1-VLOOKUP(AF176,Group,2,FALSE)),2)","v":18.5},{"$f":"IF(VLOOKUP(AF176,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ176,1)-AJ176,2),Round,2,FALSE)+VLOOKUP(AF176,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF176,Group,7,FALSE)=\"\",0,ROUND(AJ176-0.04999,1)-AJ176+AM176)","v":0},{"$f":"IF(VLOOKUP(AF176,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF176,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"60\" x 60\" x 6mm",null,"Field",null,null,null,"Honed",null,null,null,null,"96.84 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA177,AG177)","v":21.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA177*(1-W177)+0.004999,2)","v":21.65},null,"",21.65,0,21.65,{"$f":"(AG177-AC177)/AG177","v":0},null,1,{"$f":"SUM(AJ177:AL177)+AE177","v":21.65},null,null,{"$f":"ROUND(AC177/(1-VLOOKUP(AF177,Group,2,FALSE)),2)","v":21.65},{"$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,"Field Tile",null,null,"60\" x 120\" x 6mm",null,"Field",null,null,null,"Honed",null,null,null,null,"96.84 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA178,AG178)","v":27.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA178*(1-W178)+0.004999,2)","v":27.3},null,"",27.3,0,27.3,{"$f":"(AG178-AC178)/AG178","v":0},null,1,{"$f":"SUM(AJ178:AL178)+AE178","v":27.3},null,null,{"$f":"ROUND(AC178/(1-VLOOKUP(AF178,Group,2,FALSE)),2)","v":27.3},{"$f":"IF(VLOOKUP(AF178,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ178,1)-AJ178,2),Round,2,FALSE)+VLOOKUP(AF178,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF178,Group,7,FALSE)=\"\",0,ROUND(AJ178-0.04999,1)-AJ178+AM178)","v":0},{"$f":"IF(VLOOKUP(AF178,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF178,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,"30\" x 30\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"36.30 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA180,AG180)","v":21.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA180*(1-W180)+0.004999,2)","v":21.65},null,"",21.65,{"$f":"+W180","v":0},21.65,{"$f":"(AG180-AC180)/AG180","v":0},null,1,{"$f":"SUM(AJ180:AL180)+AE180","v":21.65},null,null,{"$f":"ROUND(AC180/(1-VLOOKUP(AF180,Group,2,FALSE)),2)","v":21.65},{"$f":"IF(VLOOKUP(AF180,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ180,1)-AJ180,2),Round,2,FALSE)+VLOOKUP(AF180,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF180,Group,7,FALSE)=\"\",0,ROUND(AJ180-0.04999,1)-AJ180+AM180)","v":0},{"$f":"IF(VLOOKUP(AF180,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF180,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"30\" x 60\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"24.21 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA181,AG181)","v":21.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA181*(1-W181)+0.004999,2)","v":21.65},null,"",21.65,0,21.65,{"$f":"(AG181-AC181)/AG181","v":0},null,1,{"$f":"SUM(AJ181:AL181)+AE181","v":21.65},null,null,{"$f":"ROUND(AC181/(1-VLOOKUP(AF181,Group,2,FALSE)),2)","v":21.65},{"$f":"IF(VLOOKUP(AF181,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ181,1)-AJ181,2),Round,2,FALSE)+VLOOKUP(AF181,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF181,Group,7,FALSE)=\"\",0,ROUND(AJ181-0.04999,1)-AJ181+AM181)","v":0},{"$f":"IF(VLOOKUP(AF181,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF181,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"60\" x 60\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"96.84 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA182,AG182)","v":25.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA182*(1-W182)+0.004999,2)","v":25.3},null,"",25.3,0,25.3,{"$f":"(AG182-AC182)/AG182","v":0},null,1,{"$f":"SUM(AJ182:AL182)+AE182","v":25.3},null,null,{"$f":"ROUND(AC182/(1-VLOOKUP(AF182,Group,2,FALSE)),2)","v":25.3},{"$f":"IF(VLOOKUP(AF182,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ182,1)-AJ182,2),Round,2,FALSE)+VLOOKUP(AF182,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",0,ROUND(AJ182-0.04999,1)-AJ182+AM182)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF182,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"60\" x 120\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"96.84 SF/CRATE",null,null,{"$f":"IF(Suggested=\"Yes\",AA183,AG183)","v":30.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":30.65},null,"",30.65,0,30.65,{"$f":"(AG183-AC183)/AG183","v":0},null,1,{"$f":"SUM(AJ183:AL183)+AE183","v":30.65},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":30.65},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Autumn          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\",AA189,AG189)","v":6.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA189*(1-W189)+0.004999,2)","v":6.65},null,"",6.65,{"$f":"+W189","v":0},{"$f":"+X189","v":6.65},{"$f":"(AG189-AC189)/AG189","v":0},null,1,{"$f":"SUM(AJ189:AL189)+AE189","v":6.65},null,null,{"$f":"ROUND(AC189/(1-VLOOKUP(AF189,Group,2,FALSE)),2)","v":6.65},{"$f":"IF(VLOOKUP(AF189,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ189,1)-AJ189,2),Round,2,FALSE)+VLOOKUP(AF189,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",0,ROUND(AJ189-0.04999,1)-AJ189+AM189)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF189,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\",AA191,AG191)","v":23.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA191*(1-W191)+0.004999,2)","v":23.8},null,"",23.8,{"$f":"+W191","v":0},{"$f":"+X191","v":23.8},{"$f":"(AG191-AC191)/AG191","v":0},null,3,{"$f":"SUM(AJ191:AL191)+AE191","v":23.8},null,null,{"$f":"ROUND(AC191/(1-VLOOKUP(AF191,Group,2,FALSE)),2)","v":23.8},{"$f":"IF(VLOOKUP(AF191,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ191,1)-AJ191,2),Round,2,FALSE)+VLOOKUP(AF191,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF191,Group,7,FALSE)=\"\",0,ROUND(AJ191-0.04999,1)-AJ191+AM191)","v":0},{"$f":"IF(VLOOKUP(AF191,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF191,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\",AA193,AG193)","v":12.15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA193*(1-W193)+0.004999,2)","v":12.15},null,"",12.15,{"$f":"+W193","v":0},{"$f":"+X193","v":12.15},{"$f":"(AG193-AC193)/AG193","v":0},null,2,{"$f":"SUM(AJ193:AL193)+AE193","v":12.15},null,null,{"$f":"ROUND(AC193/(1-VLOOKUP(AF193,Group,2,FALSE)),2)","v":12.15},{"$f":"IF(VLOOKUP(AF193,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ193,1)-AJ193,2),Round,2,FALSE)+VLOOKUP(AF193,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF193,Group,7,FALSE)=\"\",0,ROUND(AJ193-0.04999,1)-AJ193+AM193)","v":0},{"$f":"IF(VLOOKUP(AF193,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF193,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\",AA199,AG199)","v":7.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA199*(1-W199)+0.004999,2)","v":7.25},null,"",7.25,{"$f":"+W199","v":0},{"$f":"+X199","v":7.25},{"$f":"(AG199-AC199)/AG199","v":0},null,1,{"$f":"SUM(AJ199:AL199)+AE199","v":7.25},null,null,{"$f":"ROUND(AC199/(1-VLOOKUP(AF199,Group,2,FALSE)),2)","v":7.25},{"$f":"IF(VLOOKUP(AF199,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ199,1)-AJ199,2),Round,2,FALSE)+VLOOKUP(AF199,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF199,Group,7,FALSE)=\"\",0,ROUND(AJ199-0.04999,1)-AJ199+AM199)","v":0},{"$f":"IF(VLOOKUP(AF199,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF199,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\",AA201,AG201)","v":23.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA201*(1-W201)+0.004999,2)","v":23.7},null,"",23.7,{"$f":"+W201","v":0},{"$f":"+X201","v":23.7},{"$f":"(AG201-AC201)/AG201","v":0},null,3,{"$f":"SUM(AJ201:AL201)+AE201","v":23.7},null,null,{"$f":"ROUND(AC201/(1-VLOOKUP(AF201,Group,2,FALSE)),2)","v":23.7},{"$f":"IF(VLOOKUP(AF201,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ201,1)-AJ201,2),Round,2,FALSE)+VLOOKUP(AF201,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF201,Group,7,FALSE)=\"\",0,ROUND(AJ201-0.04999,1)-AJ201+AM201)","v":0},{"$f":"IF(VLOOKUP(AF201,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF201,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\",AA203,AG203)","v":12},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA203*(1-W203)+0.004999,2)","v":12},null,"",12,{"$f":"+W203","v":0},{"$f":"+X203","v":12},{"$f":"(AG203-AC203)/AG203","v":0},null,2,{"$f":"SUM(AJ203:AL203)+AE203","v":12},null,null,{"$f":"ROUND(AC203/(1-VLOOKUP(AF203,Group,2,FALSE)),2)","v":12},{"$f":"IF(VLOOKUP(AF203,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ203,1)-AJ203,2),Round,2,FALSE)+VLOOKUP(AF203,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF203,Group,7,FALSE)=\"\",0,ROUND(AJ203-0.04999,1)-AJ203+AM203)","v":0},{"$f":"IF(VLOOKUP(AF203,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF203,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,"     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,"Pearl Essence (Grey)",null,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,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\",AA210,AG210)","v":7.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA210*(1-W210)+0.004999,2)","v":7.7},null,"",7.7,{"$f":"+W210","v":0},{"$f":"+X210","v":7.7},{"$f":"(AG210-AC210)/AG210","v":0},null,1,{"$f":"SUM(AJ210:AL210)+AE210","v":7.7},null,null,{"$f":"ROUND(AC210/(1-VLOOKUP(AF210,Group,2,FALSE)),2)","v":7.7},{"$f":"IF(VLOOKUP(AF210,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ210,1)-AJ210,2),Round,2,FALSE)+VLOOKUP(AF210,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF210,Group,7,FALSE)=\"\",0,ROUND(AJ210-0.04999,1)-AJ210+AM210)","v":0},{"$f":"IF(VLOOKUP(AF210,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF210,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\",AA212,AG212)","v":6.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA212*(1-W212)+0.004999,2)","v":6.7},null,"",6.7,{"$f":"+W212","v":0},{"$f":"+X212","v":6.7},{"$f":"(AG212-AC212)/AG212","v":0},null,2,{"$f":"SUM(AJ212:AL212)+AE212","v":6.7},null,null,{"$f":"ROUND(AC212/(1-VLOOKUP(AF212,Group,2,FALSE)),2)","v":6.7},{"$f":"IF(VLOOKUP(AF212,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ212,1)-AJ212,2),Round,2,FALSE)+VLOOKUP(AF212,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF212,Group,7,FALSE)=\"\",0,ROUND(AJ212-0.04999,1)-AJ212+AM212)","v":0},{"$f":"IF(VLOOKUP(AF212,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF212,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,"Color:","Snow Crest (White)",null,null,null,null,null,null,null,null,null,null,null,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\",AA216,AG216)","v":8.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA216*(1-W216)+0.004999,2)","v":8.25},null,"",8.25,{"$f":"+W216","v":0},{"$f":"+X216","v":8.25},{"$f":"(AG216-AC216)/AG216","v":0},null,1,{"$f":"SUM(AJ216:AL216)+AE216","v":8.25},null,null,{"$f":"ROUND(AC216/(1-VLOOKUP(AF216,Group,2,FALSE)),2)","v":8.25},{"$f":"IF(VLOOKUP(AF216,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ216,1)-AJ216,2),Round,2,FALSE)+VLOOKUP(AF216,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",0,ROUND(AJ216-0.04999,1)-AJ216+AM216)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF216,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\",AA218,AG218)","v":6.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA218*(1-W218)+0.004999,2)","v":6.7},null,"",6.7,{"$f":"+W218","v":0},{"$f":"+X218","v":6.7},{"$f":"(AG218-AC218)/AG218","v":0},null,2,{"$f":"SUM(AJ218:AL218)+AE218","v":6.7},null,null,{"$f":"ROUND(AC218/(1-VLOOKUP(AF218,Group,2,FALSE)),2)","v":6.7},{"$f":"IF(VLOOKUP(AF218,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ218,1)-AJ218,2),Round,2,FALSE)+VLOOKUP(AF218,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",0,ROUND(AJ218-0.04999,1)-AJ218+AM218)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF218,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,"TRIDENT - Inkjet Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","METR",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:","Trident",null,null,null,null,null,null,null,null,null,null,null,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 12\"",null,"Field",null,null,null,null,null,null,null,null,"9.69 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA224,AG224)","v":5.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA224*(1-W224)+0.004999,2)","v":5.5},null,"",5.5,{"$f":"+W224","v":0},{"$f":"+X224","v":5.5},{"$f":"(AG224-AC224)/AG224","v":0},null,1,{"$f":"SUM(AJ224:AL224)+AE224","v":5.5},null,null,{"$f":"ROUND(AC224/(1-VLOOKUP(AF224,Group,2,FALSE)),2)","v":5.5},{"$f":"IF(VLOOKUP(AF224,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ224,1)-AJ224,2),Round,2,FALSE)+VLOOKUP(AF224,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF224,Group,7,FALSE)=\"\",0,ROUND(AJ224-0.04999,1)-AJ224+AM224)","v":0},{"$f":"IF(VLOOKUP(AF224,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF224,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,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA226,AG226)","v":23.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA226*(1-W226)+0.004999,2)","v":23.65},null,"",23.65,{"$f":"+W226","v":0},{"$f":"+X226","v":23.65},{"$f":"(AG226-AC226)/AG226","v":0},null,3,{"$f":"SUM(AJ226:AL226)+AE226","v":23.65},null,null,{"$f":"ROUND(AC226/(1-VLOOKUP(AF226,Group,2,FALSE)),2)","v":23.65},{"$f":"IF(VLOOKUP(AF226,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ226,1)-AJ226,2),Round,2,FALSE)+VLOOKUP(AF226,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF226,Group,7,FALSE)=\"\",0,ROUND(AJ226-0.04999,1)-AJ226+AM226)","v":0},{"$f":"IF(VLOOKUP(AF226,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF226,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,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA228,AG228)","v":6.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA228*(1-W228)+0.004999,2)","v":6.65},null,"",6.65,{"$f":"+W228","v":0},{"$f":"+X228","v":6.65},{"$f":"(AG228-AC228)/AG228","v":0},null,2,{"$f":"SUM(AJ228:AL228)+AE228","v":6.65},null,null,{"$f":"ROUND(AC228/(1-VLOOKUP(AF228,Group,2,FALSE)),2)","v":6.65},{"$f":"IF(VLOOKUP(AF228,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ228,1)-AJ228,2),Round,2,FALSE)+VLOOKUP(AF228,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF228,Group,7,FALSE)=\"\",0,ROUND(AJ228-0.04999,1)-AJ228+AM228)","v":0},{"$f":"IF(VLOOKUP(AF228,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF228,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:","See the Atlantic Series Poseidon Deco's Field that also coordinates with the Trident Series Field 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,null,null,null,null,null,null,null,null,null,null,null,null,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 GROOVE - Glazed Ceramic Wall Tile",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MEUG",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:","Chimney Smoke          London Fog          Silver Frost          Snow Crest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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:","4\" x 12\"",null,"Field",null,null,null,"Glossy",null,null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA236,AG236)","v":10.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA236*(1-W236)+0.004999,2)","v":10.75},null,"",10.75,{"$f":"+W236","v":0},{"$f":"+X236","v":10.75},{"$f":"(AG236-AC236)/AG236","v":0},null,1,{"$f":"SUM(AJ236:AL236)+AE236","v":10.75},null,null,{"$f":"ROUND(AC236/(1-VLOOKUP(AF236,Group,2,FALSE)),2)","v":10.75},{"$f":"IF(VLOOKUP(AF236,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ236,1)-AJ236,2),Round,2,FALSE)+VLOOKUP(AF236,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",0,ROUND(AJ236-0.04999,1)-AJ236+AM236)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF236,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\",AA242,AG242)","v":5.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA242*(1-W242)+0.004999,2)","v":5.95},null,"",5.95,{"$f":"+W242","v":0},{"$f":"+X242","v":5.95},{"$f":"(AG242-AC242)/AG242","v":0},null,1,{"$f":"SUM(AJ242:AL242)+AE242","v":5.95},null,null,{"$f":"ROUND(AC242/(1-VLOOKUP(AF242,Group,2,FALSE)),2)","v":5.95},{"$f":"IF(VLOOKUP(AF242,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ242,1)-AJ242,2),Round,2,FALSE)+VLOOKUP(AF242,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF242,Group,7,FALSE)=\"\",0,ROUND(AJ242-0.04999,1)-AJ242+AM242)","v":0},{"$f":"IF(VLOOKUP(AF242,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF242,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\",AA244,AG244)","v":32.049999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA244*(1-W244)+0.004999,2)","v":32.049999999999997},null,"",32.049999999999997,{"$f":"+W244","v":0},{"$f":"+X244","v":32.049999999999997},{"$f":"(AG244-AC244)/AG244","v":0},null,3,{"$f":"SUM(AJ244:AL244)+AE244","v":32.049999999999997},null,null,{"$f":"ROUND(AC244/(1-VLOOKUP(AF244,Group,2,FALSE)),2)","v":32.049999999999997},{"$f":"IF(VLOOKUP(AF244,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ244,1)-AJ244,2),Round,2,FALSE)+VLOOKUP(AF244,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF244,Group,7,FALSE)=\"\",0,ROUND(AJ244-0.04999,1)-AJ244+AM244)","v":0},{"$f":"IF(VLOOKUP(AF244,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF244,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\",AA245,AG245)","v":32},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA245*(1-W245)+0.004999,2)","v":32},null,"",32,{"$f":"+W245","v":0},{"$f":"+X245","v":32},{"$f":"(AG245-AC245)/AG245","v":0},null,3,{"$f":"SUM(AJ245:AL245)+AE245","v":32},null,null,{"$f":"ROUND(AC245/(1-VLOOKUP(AF245,Group,2,FALSE)),2)","v":32},{"$f":"IF(VLOOKUP(AF245,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ245,1)-AJ245,2),Round,2,FALSE)+VLOOKUP(AF245,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF245,Group,7,FALSE)=\"\",0,ROUND(AJ245-0.04999,1)-AJ245+AM245)","v":0},{"$f":"IF(VLOOKUP(AF245,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF245,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\",AA247,AG247)","v":6.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA247*(1-W247)+0.004999,2)","v":6.8},null,"",6.8,{"$f":"+W247","v":0},{"$f":"+X247","v":6.8},{"$f":"(AG247-AC247)/AG247","v":0},null,2,{"$f":"SUM(AJ247:AL247)+AE247","v":6.8},null,null,{"$f":"ROUND(AC247/(1-VLOOKUP(AF247,Group,2,FALSE)),2)","v":6.8},{"$f":"IF(VLOOKUP(AF247,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ247,1)-AJ247,2),Round,2,FALSE)+VLOOKUP(AF247,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF247,Group,7,FALSE)=\"\",0,ROUND(AJ247-0.04999,1)-AJ247+AM247)","v":0},{"$f":"IF(VLOOKUP(AF247,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF247,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,"Wall:","4\" x 12\"",null,"Field (Ceramic)",null,null,null,null,null,null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA253,AG253)","v":10.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA253*(1-W253)+0.004999,2)","v":10.75},null,"",10.75,{"$f":"+W253","v":0},{"$f":"+X253","v":10.75},{"$f":"(AG253-AC253)/AG253","v":0},null,1,{"$f":"SUM(AJ253:AL253)+AE253","v":10.75},null,null,{"$f":"ROUND(AC253/(1-VLOOKUP(AF253,Group,2,FALSE)),2)","v":10.75},{"$f":"IF(VLOOKUP(AF253,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ253,1)-AJ253,2),Round,2,FALSE)+VLOOKUP(AF253,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF253,Group,7,FALSE)=\"\",0,ROUND(AJ253-0.04999,1)-AJ253+AM253)","v":0},{"$f":"IF(VLOOKUP(AF253,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF253,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,"Floor:","12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.75 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA255,AG255)","v":5.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA255*(1-W255)+0.004999,2)","v":5.65},null,"",5.65,{"$f":"+W255","v":0},5.65,{"$f":"(AG255-AC255)/AG255","v":0},null,1,{"$f":"SUM(AJ255:AL255)+AE255","v":5.65},null,null,{"$f":"ROUND(AC255/(1-VLOOKUP(AF255,Group,2,FALSE)),2)","v":5.65},{"$f":"IF(VLOOKUP(AF255,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ255,1)-AJ255,2),Round,2,FALSE)+VLOOKUP(AF255,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",0,ROUND(AJ255-0.04999,1)-AJ255+AM255)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF255,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\",AA256,AG256)","v":7.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA256*(1-W256)+0.004999,2)","v":7.65},null,"",7.65,0,7.65,{"$f":"(AG256-AC256)/AG256","v":0},null,1,{"$f":"SUM(AJ256:AL256)+AE256","v":7.65},null,null,{"$f":"ROUND(AC256/(1-VLOOKUP(AF256,Group,2,FALSE)),2)","v":7.65},{"$f":"IF(VLOOKUP(AF256,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ256,1)-AJ256,2),Round,2,FALSE)+VLOOKUP(AF256,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF256,Group,7,FALSE)=\"\",0,ROUND(AJ256-0.04999,1)-AJ256+AM256)","v":0},{"$f":"IF(VLOOKUP(AF256,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF256,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,"Rectified",null,null,null,null,null,null,"31.67 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA257,AG257)","v":7.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA257*(1-W257)+0.004999,2)","v":7.7},null,"",7.7,0,7.7,{"$f":"(AG257-AC257)/AG257","v":0},null,1,{"$f":"SUM(AJ257:AL257)+AE257","v":7.7},null,null,{"$f":"ROUND(AC257/(1-VLOOKUP(AF257,Group,2,FALSE)),2)","v":7.7},{"$f":"IF(VLOOKUP(AF257,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ257,1)-AJ257,2),Round,2,FALSE)+VLOOKUP(AF257,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF257,Group,7,FALSE)=\"\",0,ROUND(AJ257-0.04999,1)-AJ257+AM257)","v":0},{"$f":"IF(VLOOKUP(AF257,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF257,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,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA259,AG259)","v":23.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA259*(1-W259)+0.004999,2)","v":23.8},null,"",23.8,{"$f":"+W259","v":0},{"$f":"+X259","v":23.8},{"$f":"(AG259-AC259)/AG259","v":0},null,3,{"$f":"SUM(AJ259:AL259)+AE259","v":23.8},null,null,{"$f":"ROUND(AC259/(1-VLOOKUP(AF259,Group,2,FALSE)),2)","v":23.8},{"$f":"IF(VLOOKUP(AF259,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ259,1)-AJ259,2),Round,2,FALSE)+VLOOKUP(AF259,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF259,Group,7,FALSE)=\"\",0,ROUND(AJ259-0.04999,1)-AJ259+AM259)","v":0},{"$f":"IF(VLOOKUP(AF259,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF259,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,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA261,AG261)","v":11.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA261*(1-W261)+0.004999,2)","v":11.3},null,"",11.3,{"$f":"+W261","v":0},{"$f":"+X261","v":11.3},{"$f":"(AG261-AC261)/AG261","v":0},null,2,{"$f":"SUM(AJ261:AL261)+AE261","v":11.3},null,null,{"$f":"ROUND(AC261/(1-VLOOKUP(AF261,Group,2,FALSE)),2)","v":11.3},{"$f":"IF(VLOOKUP(AF261,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ261,1)-AJ261,2),Round,2,FALSE)+VLOOKUP(AF261,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF261,Group,7,FALSE)=\"\",0,ROUND(AJ261-0.04999,1)-AJ261+AM261)","v":0},{"$f":"IF(VLOOKUP(AF261,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF261,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":26,"n_cols":2,"rows_kept":26,"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"]
["ATLANTIS","https://www.mediterranea-usa.com/atlantis.html"]
["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"]
["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"]
["PROVINCIAL","https://www.mediterranea-usa.com/provincial.html"]
["QUANTUM","http://www.quantumporcelain.com/"]
["SAHARA","http://www.mediterranea-usa.com/sahara.html"]
["SYMMETRY","http://www.mediterranea-usa.com/symmetry.html"]
["TOUCH","http://mediterranea-usa.com/usa/touch/"]
["TRIDENT","https://www.mediterranea-usa.com/trident.html"]
["URBAN GROOVE","https://www.mediterranea-usa.com/urban-groove.html"]
["VOGUE","http://www.mediterranea-usa.com/vogue.html"]
["WATERFALLS","https://www.mediterranea-usa.com/waterfalls.html"]

{"sheet":"Changes","index":4,"n_rows":134,"n_cols":4,"rows_kept":134,"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-07-11","Meritage","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."]
[]
[]
[]
["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.  "]