{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Changes"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Concerti"]
["File as","C"]
["Product Code","B"]
["CCTD Effective Date","6/1/25 (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"]
[]
[null,null,null,null,null,null,null,null,"  "]
["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,"Decos - T",null,"No",0]
[null,2,null,"Field Tile - A",null,"No",0]
[null,3,null,"Trim - A",null,"No",0]
[null,4,null,"Decos - A",null,"No",0]
[null,5,null,"Field Tile - Turkey",null,"No",0]
[null,6,null,"Trim - Turkey",null,"No",0]
[null,7,null,"Decos - Turkey",null,"No",0]
[null,8,null,"Field Tile - MLW Stone",null,"No",0]
[null,9,null,"Trim - MLW Stone",null,"No",0]
[null,10,null,"Decos - MLW Stone",null,"No",0]
[null,11,null,"Field Tile - MLW",null,"No",0]
[null,12,null,"Trim - MLW",null,"No",0]
[null,13,null,"Decos - MLW",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":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,0,5,10],[48,0,48,10],[50,0,50,10],[2,5,2,10]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'C' - Concerti"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 6/1/25 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[1,null,"Alloy",null,"Porcelain Floor & Wall",null,3,null,"Milton",null,"Ceramic Wall"]
[1,null,"Andalucia",null,"Porcelain Floor & Wall",null,3,null,"Milton Ridge",null,"Ceramic Wall"]
[1,null,"Artisan",null,"Natural Limestone F & W",null,3,null,"Momentum",null,"Ceramic Wall"]
[1,null,"Artista",null,"Porcelain Floor & Wall",null,3,null,"Moroccan",null,"Porcelain Floor & Wall"]
[1,null,"Atlanta Brick",null,"Porcelain Floor & Wall",null,3,null,"Nami",null,"Porcelain Wall"]
[1,null,"Barcelona",null,"Porcelain Floor & Wall",null,3,null,"Nola",null,"Porcelain Floor & Wall"]
[1,null,"CadenceDiscontinued",null,"Porcelain",null,3,null,"Nola Black",null,"Porcelain Floor & Wall"]
[1,null,"Caliza",null,"Ceramic Wall",null,3,null,"Nomad",null,"Porcelain Floor & Wall"]
[1,null,"Cava Discontinued",null,"Porcelain",null,3,null,"Normandy",null,"Porcelain Floor & Wall"]
[1,null,"Charleston",null,"Porcelain Wall",null,3,null,"OnyxDiscontinued",null,"Porcelain"]
[1,null,"Chelsea",null,"Porcelain Wall",null,3,null,"Pacific",null,"Porcelain Floor & Wall"]
[1,null,"Chiclet",null,"Porcelain Floor & Wall",null,4,null,"Piazza",null,"Ceramic Wall"]
[2,null,"Cotto Brick",null,"Porcelain Floor & Wall",null,4,null,"Plume",null,"Ceramic Wall"]
[2,null,"Empire Discontinued",null,"Ceramic",null,4,null,"Portofino",null,"Porcelain Floor & Wall"]
[2,null,"Gatsby",null,"Porcelain Floor & Wall",null,4,null,"Quadrant",null,"Ceramic Wall"]
[2,null,"Gesso",null,"Porcelain Floor & Wall",null,4,null,"Quarry",null,"Porcelain Floor & Wall"]
[2,null,"Gibraltar",null,"Porcelain Floor & Wall",null,4,null,"Rainforest Discontinued",null,"Ceramic"]
[2,null,"Grand Canyon",null,"Ceramic Wall",null,4,null,"Sedona",null,"Ceramic Wall"]
[2,null,"Hampstead",null,"Porcelain Floor & Wall",null,"4-5",null,"Slate",null,"Natural Stone F & W"]
[2,null,"Havana",null,"Ceramic Wall",null,5,null,"Stella",null,"Porcelain Floor & Wall"]
[2,null,"Hudson Brick",null,"Porcelain Floor & Wall",null,5,null,"Stone Classics",null,"Porcelain Floor & Wall"]
[2,null,"Italia",null,"Porcelain Floor & Wall",null,5,null,"Tarragona",null,"Porcelain Floor & Wall"]
[2,null,"Kingston Wood",null,"Porcelain Floor & Wall",null,5,null,"Terracotta",null,"Porcelain Floor & Wall"]
[2,null,"Limerick",null,"Ceramic Wall",null,5,null,"Urban",null,"Porcelain Floor & Wall"]
[null,null,"Limestone (see Artisan)",null,"Natural Stone",null,5,null,"Valencia",null,"Porcelain Floor & Ceramic Wall"]
[2,null,"Luxor",null,"Ceramic Wall",null,5,null,"Vintage",null,"Ceramic Wall"]
[3,null,"Malibu",null,"Porcelain Wall",null,5,null,"Woodridge",null,"Ceramic Wall"]
[3,null,"Marmol",null,"Porcelain Floor & Wall",null,5,null,"Zahara",null,"Porcelain Floor & Wall"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":533,"n_cols":41,"rows_kept":533,"cut":false,"hidden":false,"merged":[[519,2,519,19],[20,13,21,19],[522,3,522,4],[24,2,24,19],[23,14,23,15],[517,2,517,19],[19,30,19,32],[16,14,16,15],[15,14,15,19],[15,22,15,23],[15,25,15,32],[18,22,18,23],[18,14,18,19]]}
[null,"Decos - T",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"EA",{"$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,"Field Tile - A",null,null,"Size",null,"Field",null,null,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,2,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Trim - A",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,"Decos - A",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,4,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Field Tile - Turkey",null,null,"Size",null,"Field",null,null,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,5,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Trim - Turkey",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,"Decos - Turkey",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,7,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"Size",null,"Field",null,null,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},{"$f":"ROUND($AA8*(1-W8)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W8","v":0},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,"Trim - MLW Stone",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,9,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos - MLW Stone",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,10,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Field Tile - MLW",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA11,AG11)","v":0.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,{"$f":"+W11","v":0},0.05,0,null,11,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Trim - MLW",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA12,AG12)","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,12,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos - MLW",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA13,AG13)","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,13,0.05,null,null,0.05,0,0,"",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,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",AA17,AG17)","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 'C' - Concerti"},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":"6/1/25 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-12-10"},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$17","v":"List Price"},"U/M",{"$f":"+U$17","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$17","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$17","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,"ALLOY - Porcelain Floor & Wall",null,null,null,null,null,null,null,null,null,"  "," "," ",null,null,"Item # Lookup:","CNAL",null,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:","Cyan          Pewter          Platinum          Umber"]
[]
[null,"Field Tile - MLW",null,null,"19.59\" x 39.19\"",null,"Field",null,null,null,null,null,null,null,null,"16.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA31,AG31)","v":19.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":19.7},null,"",19.7,{"$f":"+W31","v":0},{"$f":"+X31","v":19.7},{"$f":"(AG31-AC31)/AG31","v":0},null,11,{"$f":"SUM(AJ31:AL31)+AE31","v":19.7},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":19.7},{"$f":"IF(VLOOKUP(AF31,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ31,1)-AJ31,2),Round,2,FALSE)+VLOOKUP(AF31,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",0,ROUND(AJ31-0.04999,1)-AJ31+AM31)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF31,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos - MLW",null,null,"13.75\" x 13.75\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(1.36 SF/Sheet)",null,null,"6.80 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA33,AG33)","v":59.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA33*(1-W33)+0.004999,2)","v":59.35},null,"",59.35,{"$f":"+W33","v":0},{"$f":"+X33","v":59.35},{"$f":"(AG33-AC33)/AG33","v":0},null,13,{"$f":"SUM(AJ33:AL33)+AE33","v":59.35},null,null,{"$f":"ROUND(AC33/(1-VLOOKUP(AF33,Group,2,FALSE)),2)","v":59.35},{"$f":"IF(VLOOKUP(AF33,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ33,1)-AJ33,2),Round,2,FALSE)+VLOOKUP(AF33,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",0,ROUND(AJ33-0.04999,1)-AJ33+AM33)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF33,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Minimum purchase is 13.60 SF, (2 cartons) and is Special Order - approximately 3-4 weeks."]
[]
[null,null,"ANDALUCIA - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNAN",null,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:","Alhambra          Malaga          Marbella          Seville"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA41,AG41)","v":13.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA41*(1-W41)+0.004999,2)","v":13.35},null,"",13.35,{"$f":"+W41","v":0},{"$f":"+X41","v":13.35},{"$f":"(AG41-AC41)/AG41","v":0},null,11,{"$f":"SUM(AJ41:AL41)+AE41","v":13.35},null,null,{"$f":"ROUND(AC41/(1-VLOOKUP(AF41,Group,2,FALSE)),2)","v":13.35},{"$f":"IF(VLOOKUP(AF41,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ41,1)-AJ41,2),Round,2,FALSE)+VLOOKUP(AF41,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF41,Group,7,FALSE)=\"\",0,ROUND(AJ41-0.04999,1)-AJ41+AM41)","v":0},{"$f":"IF(VLOOKUP(AF41,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF41,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"ARTISAN - Natural Limestone Floor & Wall (previoulsy known as Limestone)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CNLI",null,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:","Faro (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"8\" x 16\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA47,AG47)","v":25.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA47*(1-W47)+0.004999,2)","v":25.5},null,"",25.5,{"$f":"+W47","v":0},{"$f":"+X47","v":25.5},{"$f":"(AG47-AC47)/AG47","v":0},null,8,{"$f":"SUM(AJ47:AL47)+AE47","v":25.5},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":25.5},{"$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 - MLW Stone",null,null,"16\" x 24\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA48,AG48)","v":25.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA48*(1-W48)+0.004999,2)","v":25.5},null,"",25.5,{"$f":"+W48","v":0},{"$f":"+X48","v":25.5},{"$f":"(AG48-AC48)/AG48","v":0},null,8,{"$f":"SUM(AJ48:AL48)+AE48","v":25.5},null,null,{"$f":"ROUND(AC48/(1-VLOOKUP(AF48,Group,2,FALSE)),2)","v":25.5},{"$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,"Color:","Orval (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"8\" x 16\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA52,AG52)","v":26.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA52*(1-W52)+0.004999,2)","v":26.85},null,"",26.85,{"$f":"+W52","v":0},{"$f":"+X52","v":26.85},{"$f":"(AG52-AC52)/AG52","v":0},null,8,{"$f":"SUM(AJ52:AL52)+AE52","v":26.85},null,null,{"$f":"ROUND(AC52/(1-VLOOKUP(AF52,Group,2,FALSE)),2)","v":26.85},{"$f":"IF(VLOOKUP(AF52,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ52,1)-AJ52,2),Round,2,FALSE)+VLOOKUP(AF52,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF52,Group,7,FALSE)=\"\",0,ROUND(AJ52-0.04999,1)-AJ52+AM52)","v":0},{"$f":"IF(VLOOKUP(AF52,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF52,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"16\" x 24\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,26.85,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA53*(1-W53)+0.004999,2)","v":26.85},null,"",26.85,0,26.85,0,null,8,26.85,null,null,26.85,0,0,"",null,"X"]
[]
[null,null,null,"Color:","Chimay (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"8\" x 16\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA57,AG57)","v":32.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA57*(1-W57)+0.004999,2)","v":32.1},null,"",32.1,{"$f":"+W57","v":0},{"$f":"+X57","v":32.1},{"$f":"(AG57-AC57)/AG57","v":0},null,8,{"$f":"SUM(AJ57:AL57)+AE57","v":32.1},null,null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":32.1},{"$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,"Field Tile - MLW Stone",null,null,"16\" x 24\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,32.1,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA58*(1-W58)+0.004999,2)","v":32.1},null,"",32.1,0,32.1,0,null,8,32.1,null,null,32.1,0,0,"",null,"X"]
[]
[null,null,"ARTISTA - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNAR",null,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:","Arroyo","El Greco",null,null,null,"Goya White",null,"      Murillo"]
[null,null,null,null,"Dali","Goya Black",null,null,null,"Miro",null,"      Picasso"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field (Decorative Pattern)",null,null,null," ",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":13.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":13.8},null,"",13.8,{"$f":"+W65","v":0},{"$f":"+X65","v":13.8},{"$f":"(AG65-AC65)/AG65","v":0},null,11,{"$f":"SUM(AJ65:AL65)+AE65","v":13.8},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":13.8},{"$f":"IF(VLOOKUP(AF65,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ65,1)-AJ65,2),Round,2,FALSE)+VLOOKUP(AF65,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",0,ROUND(AJ65-0.04999,1)-AJ65+AM65)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF65,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"ATLANTA BRICK - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNAT",null,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:","Buckhead          Midtown          Morningside          Westside"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 11\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"10.87 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA71,AG71)","v":14.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":14.5},null,"",14.5,{"$f":"+W71","v":0},{"$f":"+X71","v":14.5},{"$f":"(AG71-AC71)/AG71","v":0},null,11,{"$f":"SUM(AJ71:AL71)+AE71","v":14.5},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":14.5},{"$f":"IF(VLOOKUP(AF71,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ71,1)-AJ71,2),Round,2,FALSE)+VLOOKUP(AF71,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",0,ROUND(AJ71-0.04999,1)-AJ71+AM71)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF71,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"BARCELONA - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNBA",null,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:","Baked Clay          Midnight Blue          Taupe          White Mist"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 8\" x 5/16\"",null,"Field - Leaf",null,null,null,"Matte",null,null,null,null,"3.12 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA77,AG77)","v":31.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":31.2},null,"new",31.2,{"$f":"+W77","v":0},{"$f":"+X77","v":31.2},{"$f":"(AG77-AC77)/AG77","v":0},null,11,{"$f":"SUM(AJ77:AL77)+AE77","v":31.2},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":31.2},{"$f":"IF(VLOOKUP(AF77,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ77,1)-AJ77,2),Round,2,FALSE)+VLOOKUP(AF77,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",0,ROUND(AJ77-0.04999,1)-AJ77+AM77)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF77,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"6.5\" x 6.5\" x 5/16\"",null,"Field - Nexus",null,null,null,"Matte",null,null,null,null,"4.41 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA78,AG78)","v":31.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":31.3},null,"new",31.3,{"$f":"+W78","v":0},{"$f":"+X78","v":31.3},{"$f":"(AG78-AC78)/AG78","v":0},null,11,{"$f":"SUM(AJ78:AL78)+AE78","v":31.3},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":31.3},{"$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,"Colors:","Blue          Clay          Mixed"]
[]
[null,"Decos - MLW",null,null,"6.5\" x 6.5\" x 5/16\"",null,"Field - Nexus Deco",null,null,null,"Matte",null,null,null,null,"4.41 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA82,AG82)","v":33.049999999999997},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":33.049999999999997},null,"new",33.049999999999997,{"$f":"+W82","v":0},{"$f":"+X82","v":33.049999999999997},{"$f":"(AG82-AC82)/AG82","v":0},null,13,{"$f":"SUM(AJ82:AL82)+AE82","v":33.049999999999997},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":33.049999999999997},{"$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,"Notes:","a) This two-part combination pattern that requires ordering 1 carton of the Nexus Field and 2 cartons of the Leaf Field."]
[null,null,null,null,"Example: 106.50 SF total needed, order 44.10 SF (10 Cartons) of the Nexus Field and 62.40 SF (20 Cartons) of the Leaf Field."]
[null,null,null,null,"The Barcelona Series can also be combined with the Tarragona Series to create different colors and finish combinations."]
[]
[null,null,"CADENCE - Porcelain",null,null,null,null,null,null,"DISCONTINUED 12/10/25",null,null,null,null,null,null,null,"Item # Lookup:","CNCA",null,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:","Coal Black"]
[]
[null,"Field Tile - MLW",null,null,"8.8\" x 8.8\"",null,"Field (Decorative Pattern)",null,null,null,"Alley",null,null,null,null,"10.87 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA92,AG92)","v":14.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":14.95},null,"",14.95,{"$f":"+W92","v":0},{"$f":"+X92","v":14.95},{"$f":"(AG92-AC92)/AG92","v":0},null,11,{"$f":"SUM(AJ92:AL92)+AE92","v":14.95},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":14.95},{"$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,"CALIZA - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNCZ",null,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:","Capri          Perla"]
[]
[null,"Field Tile - MLW",null,null,"18\" x 48\" x 5/16\"",null,"Field - Carved",null,null,null,null," ",null,null,null,"18.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA98,AG98)","v":17.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA98*(1-W98)+0.004999,2)","v":17.5},null,"",17.5,{"$f":"+W98","v":0},{"$f":"+X98","v":17.5},{"$f":"(AG98-AC98)/AG98","v":0},null,11,{"$f":"SUM(AJ98:AL98)+AE98","v":17.5},null,null,{"$f":"ROUND(AC98/(1-VLOOKUP(AF98,Group,2,FALSE)),2)","v":17.5},{"$f":"IF(VLOOKUP(AF98,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ98,1)-AJ98,2),Round,2,FALSE)+VLOOKUP(AF98,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",0,ROUND(AJ98-0.04999,1)-AJ98+AM98)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF98,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"18\" x 48\" x 5/16\"",null,"Field - Scraped",null,null,null,null," ",null,null,null,"18.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA99,AG99)","v":17.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA99*(1-W99)+0.004999,2)","v":17.5},null,"",17.5,{"$f":"+W99","v":0},{"$f":"+X99","v":17.5},{"$f":"(AG99-AC99)/AG99","v":0},null,11,{"$f":"SUM(AJ99:AL99)+AE99","v":17.5},null,null,{"$f":"ROUND(AC99/(1-VLOOKUP(AF99,Group,2,FALSE)),2)","v":17.5},{"$f":"IF(VLOOKUP(AF99,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ99,1)-AJ99,2),Round,2,FALSE)+VLOOKUP(AF99,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,7,FALSE)=\"\",0,ROUND(AJ99-0.04999,1)-AJ99+AM99)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF99,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CAVA - Porcelain",null,null,null,null,null,null,"DISCONTINUED 9/4/25",null,null,null,null,null,null,null,"Item # Lookup:","CNCV",null,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:","Dark Gray             Light Gray             Taupe             White"]
[]
[null,"Field Tile - MLW",null,null,"6\" x 23.6\"",null,"Field",null,null,null,null,null,null,null,null,"14.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA105,AG105)","v":14.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA105*(1-W105)+0.004999,2)","v":14.1},null,"",14.1,{"$f":"+W105","v":0},{"$f":"+X105","v":14.1},{"$f":"(AG105-AC105)/AG105","v":0},null,11,{"$f":"SUM(AJ105:AL105)+AE105","v":14.1},null,null,{"$f":"ROUND(AC105/(1-VLOOKUP(AF105,Group,2,FALSE)),2)","v":14.1},{"$f":"IF(VLOOKUP(AF105,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ105,1)-AJ105,2),Round,2,FALSE)+VLOOKUP(AF105,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",0,ROUND(AJ105-0.04999,1)-AJ105+AM105)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF105,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CHARLESTON - Porcelain Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNCH",null,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:","Cromwell"]
[]
[null,"Field Tile - MLW",null,null,"13\" x 13\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"10.79 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA111,AG111)","v":14.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA111*(1-W111)+0.004999,2)","v":14.6},null,"",14.6,{"$f":"+W111","v":0},{"$f":"+X111","v":14.6},{"$f":"(AG111-AC111)/AG111","v":0},null,11,{"$f":"SUM(AJ111:AL111)+AE111","v":14.6},null,null,{"$f":"ROUND(AC111/(1-VLOOKUP(AF111,Group,2,FALSE)),2)","v":14.6},{"$f":"IF(VLOOKUP(AF111,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ111,1)-AJ111,2),Round,2,FALSE)+VLOOKUP(AF111,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",0,ROUND(AJ111-0.04999,1)-AJ111+AM111)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF111,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CHELSEA - Porcelain Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNCS",null,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:","Black","Dark Gray",null,null,null,"Ivory",null,"      Sage"]
[null,null,null,null,"Blue","Emerald",null,null,null,"Light Gray",null,"      White"]
[]
[null,"Field Tile - MLW",null,null,"2\" x 10\"",null,"Field",null,null,null,null,null,null,null,null,"5.17 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA118,AG118)","v":18.899999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA118*(1-W118)+0.004999,2)","v":18.899999999999999},null,"",18.899999999999999,{"$f":"+W118","v":0},{"$f":"+X118","v":18.899999999999999},{"$f":"(AG118-AC118)/AG118","v":0},null,11,{"$f":"SUM(AJ118:AL118)+AE118","v":18.899999999999999},null,null,{"$f":"ROUND(AC118/(1-VLOOKUP(AF118,Group,2,FALSE)),2)","v":18.899999999999999},{"$f":"IF(VLOOKUP(AF118,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ118,1)-AJ118,2),Round,2,FALSE)+VLOOKUP(AF118,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",0,ROUND(AJ118-0.04999,1)-AJ118+AM118)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF118,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW",null,null,"1/2\" x 10\"",null,"Quarter Round",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA120,AG120)","v":25.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA120*(1-W120)+0.004999,2)","v":25.35},null,"",25.35,{"$f":"+W120","v":0},{"$f":"+X120","v":25.35},{"$f":"(AG120-AC120)/AG120","v":0},null,12,{"$f":"SUM(AJ120:AL120)+AE120","v":25.35},null,null,{"$f":"ROUND(AC120/(1-VLOOKUP(AF120,Group,2,FALSE)),2)","v":25.35},{"$f":"IF(VLOOKUP(AF120,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ120,1)-AJ120,2),Round,2,FALSE)+VLOOKUP(AF120,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",0,ROUND(AJ120-0.04999,1)-AJ120+AM120)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF120,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CHICLET - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNCL",null,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:","Aviation Blue",null,"Cloud",null,"    Mint","       Navy Blue",null,"   Rope","     Smoke"]
[null,null,null,null,"Cement",null,"Ink",null,"    Myrtle","       Olive",null,"   Sea","     Snow"]
[]
[null,"Decos - MLW",null,null,"12\" x 12\" x 1/4\"",null,"Mosaic",null,null,"1\" x 1\"",null,null,"(0.97 SF/Sheet)",null,null,"13.58 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA127,AG127)","v":29},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA127*(1-W127)+0.004999,2)","v":29},null,"",29,{"$f":"+W127","v":0},{"$f":"+X127","v":29},{"$f":"(AG127-AC127)/AG127","v":0},null,13,{"$f":"SUM(AJ127:AL127)+AE127","v":29},null,null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":29},{"$f":"IF(VLOOKUP(AF127,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ127,1)-AJ127,2),Round,2,FALSE)+VLOOKUP(AF127,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",0,ROUND(AJ127-0.04999,1)-AJ127+AM127)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF127,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"COTTO BRICK - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNCO",null,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:","Ash             Blackened             Natural             White Washed"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"7.77 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA133,AG133)","v":17.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA133*(1-W133)+0.004999,2)","v":17.25},null,"",17.25,{"$f":"+W133","v":0},{"$f":"+X133","v":17.25},{"$f":"(AG133-AC133)/AG133","v":0},null,11,{"$f":"SUM(AJ133:AL133)+AE133","v":17.25},null,null,{"$f":"ROUND(AC133/(1-VLOOKUP(AF133,Group,2,FALSE)),2)","v":17.25},{"$f":"IF(VLOOKUP(AF133,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ133,1)-AJ133,2),Round,2,FALSE)+VLOOKUP(AF133,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",0,ROUND(AJ133-0.04999,1)-AJ133+AM133)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF133,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"6\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"11.65 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA134,AG134)","v":17.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA134*(1-W134)+0.004999,2)","v":17.25},null,"",17.25,{"$f":"+W134","v":0},{"$f":"+X134","v":17.25},{"$f":"(AG134-AC134)/AG134","v":0},null,11,{"$f":"SUM(AJ134:AL134)+AE134","v":17.25},null,null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":17.25},{"$f":"IF(VLOOKUP(AF134,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ134,1)-AJ134,2),Round,2,FALSE)+VLOOKUP(AF134,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",0,ROUND(AJ134-0.04999,1)-AJ134+AM134)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF134,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"EMPIRE - Ceramic",null,null,null,null,null,null,"DISCONTINUED 9/4/25",null,null,null,null,null,null,null,"Item # Lookup:","CNEM",null,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:","Oxide             Plaster"]
[]
[null,"Field Tile - MLW",null,null,"7.8\" x 7.8\" x 3/16\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"9.60 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA140,AG140)","v":16.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA140*(1-W140)+0.004999,2)","v":16.7},null,"",16.7,{"$f":"+W140","v":0},{"$f":"+X140","v":16.7},{"$f":"(AG140-AC140)/AG140","v":0},null,11,{"$f":"SUM(AJ140:AL140)+AE140","v":16.7},null,null,{"$f":"ROUND(AC140/(1-VLOOKUP(AF140,Group,2,FALSE)),2)","v":16.7},{"$f":"IF(VLOOKUP(AF140,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ140,1)-AJ140,2),Round,2,FALSE)+VLOOKUP(AF140,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",0,ROUND(AJ140-0.04999,1)-AJ140+AM140)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF140,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Color:","Tin"]
[]
[null,"Field Tile - MLW",null,null,"7.8\" x 7.8\" x 3/16\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"9.60 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA144,AG144)","v":18.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA144*(1-W144)+0.004999,2)","v":18.25},null,"",18.25,{"$f":"+W144","v":0},{"$f":"+X144","v":18.25},{"$f":"(AG144-AC144)/AG144","v":0},null,11,{"$f":"SUM(AJ144:AL144)+AE144","v":18.25},null,null,{"$f":"ROUND(AC144/(1-VLOOKUP(AF144,Group,2,FALSE)),2)","v":18.25},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ144,1)-AJ144,2),Round,2,FALSE)+VLOOKUP(AF144,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",0,ROUND(AJ144-0.04999,1)-AJ144+AM144)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF144,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"GATSBY - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNGA",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 - MLW",null,null,"24\" x 24\" x 5/16\"",null,"Field",null,null,"Gatsby Deco",null,null,null,null,null,"20.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA148,AG148)","v":28.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA148*(1-W148)+0.004999,2)","v":28.2},null,"",28.2,{"$f":"+W148","v":0},{"$f":"+X148","v":28.2},{"$f":"(AG148-AC148)/AG148","v":0},null,11,{"$f":"SUM(AJ148:AL148)+AE148","v":28.2},null,null,{"$f":"ROUND(AC148/(1-VLOOKUP(AF148,Group,2,FALSE)),2)","v":28.2},{"$f":"IF(VLOOKUP(AF148,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ148,1)-AJ148,2),Round,2,FALSE)+VLOOKUP(AF148,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",0,ROUND(AJ148-0.04999,1)-AJ148+AM148)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF148,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"GESSO - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNGE",null,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:","Gray             White"]
[]
[null,"Field Tile - MLW",null,"Floor:","8\" x 8\" x 1/4\"",null,"Field",null,null,null,"Natural",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA154,AG154)","v":15.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA154*(1-W154)+0.004999,2)","v":15.4},null,"",15.4,{"$f":"+W154","v":0},{"$f":"+X154","v":15.4},{"$f":"(AG154-AC154)/AG154","v":0},null,11,{"$f":"SUM(AJ154:AL154)+AE154","v":15.4},null,null,{"$f":"ROUND(AC154/(1-VLOOKUP(AF154,Group,2,FALSE)),2)","v":15.4},{"$f":"IF(VLOOKUP(AF154,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ154,1)-AJ154,2),Round,2,FALSE)+VLOOKUP(AF154,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",0,ROUND(AJ154-0.04999,1)-AJ154+AM154)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF154,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,"Wall:","8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,"Diagonal",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA156,AG156)","v":16},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA156*(1-W156)+0.004999,2)","v":16},null,"",16,{"$f":"+W156","v":0},{"$f":"+X156","v":16},{"$f":"(AG156-AC156)/AG156","v":0},null,11,{"$f":"SUM(AJ156:AL156)+AE156","v":16},null,null,{"$f":"ROUND(AC156/(1-VLOOKUP(AF156,Group,2,FALSE)),2)","v":16},{"$f":"IF(VLOOKUP(AF156,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ156,1)-AJ156,2),Round,2,FALSE)+VLOOKUP(AF156,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",0,ROUND(AJ156-0.04999,1)-AJ156+AM156)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF156,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,"Round",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA157,AG157)","v":16},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":16},null,"",16,{"$f":"+W157","v":0},{"$f":"+X157","v":16},{"$f":"(AG157-AC157)/AG157","v":0},null,11,{"$f":"SUM(AJ157:AL157)+AE157","v":16},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":16},{"$f":"IF(VLOOKUP(AF157,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ157,1)-AJ157,2),Round,2,FALSE)+VLOOKUP(AF157,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",0,ROUND(AJ157-0.04999,1)-AJ157+AM157)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF157,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,"Straight",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA158,AG158)","v":16},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA158*(1-W158)+0.004999,2)","v":16},null,"",16,{"$f":"+W158","v":0},{"$f":"+X158","v":16},{"$f":"(AG158-AC158)/AG158","v":0},null,11,{"$f":"SUM(AJ158:AL158)+AE158","v":16},null,null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":16},{"$f":"IF(VLOOKUP(AF158,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ158,1)-AJ158,2),Round,2,FALSE)+VLOOKUP(AF158,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",0,ROUND(AJ158-0.04999,1)-AJ158+AM158)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF158,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"GIBRALTAR - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNGI",null,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             Blue             Gray             Terra             Turquoise             White"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 7\"",null,"Field - Amulet",null,null,null,null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA164,AG164)","v":31.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA164*(1-W164)+0.004999,2)","v":31.4},null,"",31.4,{"$f":"+W164","v":0},{"$f":"+X164","v":31.4},{"$f":"(AG164-AC164)/AG164","v":0},null,11,{"$f":"SUM(AJ164:AL164)+AE164","v":31.4},null,null,{"$f":"ROUND(AC164/(1-VLOOKUP(AF164,Group,2,FALSE)),2)","v":31.4},{"$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,null,"GRAND CANYON - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNGR",null,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:","Buff             Calcite             Mesquite             Sagebrush"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 10\" x 5/16\"",null,"Field",null," ",null,null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA170,AG170)","v":18.850000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA170*(1-W170)+0.004999,2)","v":18.850000000000001},null,"",18.850000000000001,{"$f":"+W170","v":0},{"$f":"+X170","v":18.850000000000001},{"$f":"(AG170-AC170)/AG170","v":0},null,11,{"$f":"SUM(AJ170:AL170)+AE170","v":18.850000000000001},null,null,{"$f":"ROUND(AC170/(1-VLOOKUP(AF170,Group,2,FALSE)),2)","v":18.850000000000001},{"$f":"IF(VLOOKUP(AF170,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ170,1)-AJ170,2),Round,2,FALSE)+VLOOKUP(AF170,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",0,ROUND(AJ170-0.04999,1)-AJ170+AM170)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF170,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"HAMPSTEAD - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNHA",null,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","Forest Green",null,null,null,"    Hunter Green",null,null,"Terracotta"]
[null,null,null,null,"Blue","Frost",null,null,null,"    Silver",null,null,"Turquoise"]
[]
[null,"Field Tile - MLW",null,null,"2\" x 6\" x 5/16\"",null,"Field",null," ",null,null,null,null,null,null,"4.86 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA177,AG177)","v":15.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA177*(1-W177)+0.004999,2)","v":15.75},null,"",15.75,{"$f":"+W177","v":0},{"$f":"+X177","v":15.75},{"$f":"(AG177-AC177)/AG177","v":0},null,11,{"$f":"SUM(AJ177:AL177)+AE177","v":15.75},null,null,{"$f":"ROUND(AC177/(1-VLOOKUP(AF177,Group,2,FALSE)),2)","v":15.75},{"$f":"IF(VLOOKUP(AF177,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ177,1)-AJ177,2),Round,2,FALSE)+VLOOKUP(AF177,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",0,ROUND(AJ177-0.04999,1)-AJ177+AM177)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF177,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"HAVANA - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNHV",null,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:","Bosque Verde",null,"       Deep Blue",null,null,"    Loden Green",null,"         Tierra Brown"]
[null,null,null,null,"Cerda Rosa",null,"       Gray",null,null,"    Mission Red",null,"         White"]
[]
[null,"Field Tile - MLW",null,null,"2\" x 16\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"10.77 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA184,AG184)","v":15.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA184*(1-W184)+0.004999,2)","v":15.15},null,"",15.15,{"$f":"+W184","v":0},{"$f":"+X184","v":15.15},{"$f":"(AG184-AC184)/AG184","v":0},null,11,{"$f":"SUM(AJ184:AL184)+AE184","v":15.15},null,null,{"$f":"ROUND(AC184/(1-VLOOKUP(AF184,Group,2,FALSE)),2)","v":15.15},{"$f":"IF(VLOOKUP(AF184,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ184,1)-AJ184,2),Round,2,FALSE)+VLOOKUP(AF184,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",0,ROUND(AJ184-0.04999,1)-AJ184+AM184)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF184,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"HUDSON BRICK - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNHB",null,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:","Carbon Black",null,"    Pearl Gray",null,null,"Silver Gray",null,"White"]
[null,null,null,null,"Earth Brown",null,"    Sand",null,null,"Smoke"]
[null,null,null,null,"Multicolor",null,"    Sienna",null,null,"Terracotta"]
[]
[null,"Field Tile - MLW",null,null,"2\" x 18\"",null,"Field",null,null,null,null,null,null,null,null,"8.32 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA192,AG192)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA192*(1-W192)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W192","v":0},{"$f":"+X192","v":15.3},{"$f":"(AG192-AC192)/AG192","v":0},null,11,{"$f":"SUM(AJ192:AL192)+AE192","v":15.3},null,null,{"$f":"ROUND(AC192/(1-VLOOKUP(AF192,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF192,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ192,1)-AJ192,2),Round,2,FALSE)+VLOOKUP(AF192,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF192,Group,7,FALSE)=\"\",0,ROUND(AJ192-0.04999,1)-AJ192+AM192)","v":0},{"$f":"IF(VLOOKUP(AF192,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF192,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"ITALIA - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNIT",null,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:","Pisa"]
[]
[null,"Field Tile - MLW",null,null,"24\" x 48\" x 5/16\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA198,AG198)","v":21.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA198*(1-W198)+0.004999,2)","v":21.1},null,"",21.1,{"$f":"+W198","v":0},{"$f":"+X198","v":21.1},{"$f":"(AG198-AC198)/AG198","v":0},null,11,{"$f":"SUM(AJ198:AL198)+AE198","v":21.1},null,null,{"$f":"ROUND(AC198/(1-VLOOKUP(AF198,Group,2,FALSE)),2)","v":21.1},{"$f":"IF(VLOOKUP(AF198,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ198,1)-AJ198,2),Round,2,FALSE)+VLOOKUP(AF198,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF198,Group,7,FALSE)=\"\",0,ROUND(AJ198-0.04999,1)-AJ198+AM198)","v":0},{"$f":"IF(VLOOKUP(AF198,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF198,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Florence Beige",null,"       Milan Beige",null,null,"    Venice"]
[null,null,null,null,"Florence Gray",null,"       Milan Gray"]
[]
[null,"Field Tile - MLW",null,null,"24\" x 48\" x 5/16\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA203,AG203)","v":22.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA203*(1-W203)+0.004999,2)","v":22.3},null,"",22.3,{"$f":"+W203","v":0},{"$f":"+X203","v":22.3},{"$f":"(AG203-AC203)/AG203","v":0},null,11,{"$f":"SUM(AJ203:AL203)+AE203","v":22.3},null,null,{"$f":"ROUND(AC203/(1-VLOOKUP(AF203,Group,2,FALSE)),2)","v":22.3},{"$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,"KINGSTON WOOD - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNKW",null,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:","Bradwood             Chesawood             Emmawood"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA209,AG209)","v":15.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA209*(1-W209)+0.004999,2)","v":15.2},null,"",15.2,{"$f":"+W209","v":0},{"$f":"+X209","v":15.2},{"$f":"(AG209-AC209)/AG209","v":0},null,11,{"$f":"SUM(AJ209:AL209)+AE209","v":15.2},null,null,{"$f":"ROUND(AC209/(1-VLOOKUP(AF209,Group,2,FALSE)),2)","v":15.2},{"$f":"IF(VLOOKUP(AF209,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ209,1)-AJ209,2),Round,2,FALSE)+VLOOKUP(AF209,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,7,FALSE)=\"\",0,ROUND(AJ209-0.04999,1)-AJ209+AM209)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF209,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"LIMERICK - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNLR",null,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:","Alabaster          Dollar Green          Misty Gray          Pale Blue          White"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 9\" x 1/4\"",null,"Field",null,null,null,null,null,null,null,null,"8.25 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA215,AG215)","v":13},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA215*(1-W215)+0.004999,2)","v":13},null,"",13,{"$f":"+W215","v":0},{"$f":"+X215","v":13},{"$f":"(AG215-AC215)/AG215","v":0},null,11,{"$f":"SUM(AJ215:AL215)+AE215","v":13},null,null,{"$f":"ROUND(AC215/(1-VLOOKUP(AF215,Group,2,FALSE)),2)","v":13},{"$f":"IF(VLOOKUP(AF215,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ215,1)-AJ215,2),Round,2,FALSE)+VLOOKUP(AF215,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF215,Group,7,FALSE)=\"\",0,ROUND(AJ215-0.04999,1)-AJ215+AM215)","v":0},{"$f":"IF(VLOOKUP(AF215,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF215,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"LUXOR - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNLU",null,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:","Black          Greige          Olive          Sage          Silver          Terracotta          White"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 5/16\"",null,"Field",null,null,"Glossy",null,null,null,null,null,"10.76 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA221,AG221)","v":9.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA221*(1-W221)+0.004999,2)","v":9.6},null,"new",9.6,{"$f":"+W221","v":0},{"$f":"+X221","v":9.6},{"$f":"(AG221-AC221)/AG221","v":0},null,11,{"$f":"SUM(AJ221:AL221)+AE221","v":9.6},null,null,{"$f":"ROUND(AC221/(1-VLOOKUP(AF221,Group,2,FALSE)),2)","v":9.6},{"$f":"IF(VLOOKUP(AF221,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ221,1)-AJ221,2),Round,2,FALSE)+VLOOKUP(AF221,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF221,Group,7,FALSE)=\"\",0,ROUND(AJ221-0.04999,1)-AJ221+AM221)","v":0},{"$f":"IF(VLOOKUP(AF221,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF221,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Blue          Caramel          Honey"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 5/16\"",null,"Field",null,null,"Glossy",null,null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA225,AG225)","v":11.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA225*(1-W225)+0.004999,2)","v":11.65},null,"new",11.65,{"$f":"+W225","v":0},{"$f":"+X225","v":11.65},{"$f":"(AG225-AC225)/AG225","v":0},null,11,{"$f":"SUM(AJ225:AL225)+AE225","v":11.65},null,null,{"$f":"ROUND(AC225/(1-VLOOKUP(AF225,Group,2,FALSE)),2)","v":11.65},{"$f":"IF(VLOOKUP(AF225,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ225,1)-AJ225,2),Round,2,FALSE)+VLOOKUP(AF225,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF225,Group,7,FALSE)=\"\",0,ROUND(AJ225-0.04999,1)-AJ225+AM225)","v":0},{"$f":"IF(VLOOKUP(AF225,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF225,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Color:","Deep Green"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 5/16\"",null,"Field",null,null,"Glossy",null,null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA229,AG229)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA229*(1-W229)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W229","v":0},{"$f":"+X229","v":12.95},{"$f":"(AG229-AC229)/AG229","v":0},null,11,{"$f":"SUM(AJ229:AL229)+AE229","v":12.95},null,null,{"$f":"ROUND(AC229/(1-VLOOKUP(AF229,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF229,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ229,1)-AJ229,2),Round,2,FALSE)+VLOOKUP(AF229,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",0,ROUND(AJ229-0.04999,1)-AJ229+AM229)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF229,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Color Terracotta has a Matte finish."]
[]
[null,null,"MALIBU - Porcelain Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNML",null,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             Gray             Lime             Taupe             White"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 12\"",null,"Field",null,null,"Ripple",null,null,null,null,null,"5.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA237,AG237)","v":19.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA237*(1-W237)+0.004999,2)","v":19.55},null,"",19.55,{"$f":"+W237","v":0},{"$f":"+X237","v":19.55},{"$f":"(AG237-AC237)/AG237","v":0},null,11,{"$f":"SUM(AJ237:AL237)+AE237","v":19.55},null,null,{"$f":"ROUND(AC237/(1-VLOOKUP(AF237,Group,2,FALSE)),2)","v":19.55},{"$f":"IF(VLOOKUP(AF237,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ237,1)-AJ237,2),Round,2,FALSE)+VLOOKUP(AF237,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF237,Group,7,FALSE)=\"\",0,ROUND(AJ237-0.04999,1)-AJ237+AM237)","v":0},{"$f":"IF(VLOOKUP(AF237,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF237,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"4\" x 12\"",null,"Field",null,null,"Wave",null,null,null,null,null,"5.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA238,AG238)","v":19.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA238*(1-W238)+0.004999,2)","v":19.55},null,"",19.55,{"$f":"+W238","v":0},{"$f":"+X238","v":19.55},{"$f":"(AG238-AC238)/AG238","v":0},null,11,{"$f":"SUM(AJ238:AL238)+AE238","v":19.55},null,null,{"$f":"ROUND(AC238/(1-VLOOKUP(AF238,Group,2,FALSE)),2)","v":19.55},{"$f":"IF(VLOOKUP(AF238,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ238,1)-AJ238,2),Round,2,FALSE)+VLOOKUP(AF238,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF238,Group,7,FALSE)=\"\",0,ROUND(AJ238-0.04999,1)-AJ238+AM238)","v":0},{"$f":"IF(VLOOKUP(AF238,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF238,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"MARMOL - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNMR",null,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:","Blanco          Marron"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 7\" x 5/16\"",null,"Field - Amulet",null,null,null,null,null,null,"(36 Pieces per Carton, 0.149 SF per Piece)",null,"5.38 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA244,AG244)","v":31.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA244*(1-W244)+0.004999,2)","v":31.45},null,"",31.45,{"$f":"+W244","v":0},31.45,{"$f":"(AG244-AC244)/AG244","v":0},null,11,{"$f":"SUM(AJ244:AL244)+AE244","v":31.45},null,null,{"$f":"ROUND(AC244/(1-VLOOKUP(AF244,Group,2,FALSE)),2)","v":31.45},{"$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,"Field Tile - MLW",null,null,"6\" x 6\" x 5/16\"",null,"Field - Cross",null,null,null,null,null,null,"(24 Pieces per Carton, 0.269 SF per Piece)",null,"6.31 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA245,AG245)","v":31.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA245*(1-W245)+0.004999,2)","v":31.2},null,"",31.2,0,31.2,{"$f":"(AG245-AC245)/AG245","v":0},null,11,{"$f":"SUM(AJ245:AL245)+AE245","v":31.2},null,null,{"$f":"ROUND(AC245/(1-VLOOKUP(AF245,Group,2,FALSE)),2)","v":31.2},{"$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,"Field Tile - MLW",null,null,"6\" x 6\" x 5/16\"",null,"Field - Star",null,null,null,null,null,null,"(16 Pieces per Carton, 0.263 SF per Piece)",null,"4.21 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",AA246,AG246)","v":31.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA246*(1-W246)+0.004999,2)","v":31.65},null,"",31.65,0,31.65,{"$f":"(AG246-AC246)/AG246","v":0},null,11,{"$f":"SUM(AJ246:AL246)+AE246","v":31.65},null,null,{"$f":"ROUND(AC246/(1-VLOOKUP(AF246,Group,2,FALSE)),2)","v":31.65},{"$f":"IF(VLOOKUP(AF246,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ246,1)-AJ246,2),Round,2,FALSE)+VLOOKUP(AF246,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF246,Group,7,FALSE)=\"\",0,ROUND(AJ246-0.04999,1)-AJ246+AM246)","v":0},{"$f":"IF(VLOOKUP(AF246,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF246,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) For the Amulet & Cross pattern, order (2) Amulet per (1) Cross.  Example:  104.28 SF total needed, order 53.80 SF of the Amulet & 50.48 SF of the Cross."]
[null,null," ",null,"b) For the Cross & Star pattern, order equal amounts of each.  Example:  100 SF total needed, order 50 SF of the Cross & 50 SF of the Star."]
[]
[null,null,"MILTON - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNMI",null,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:","Aegean Green",null,"    Beige",null,null,"     Dark Blue",null,"   Light Blue"]
[null,null,null,null,"Anthracite",null,"    Celadon Green",null,null,"     Gray",null,"   White"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"6.35 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA256,AG256)","v":11.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA256*(1-W256)+0.004999,2)","v":11.6},null,"new",11.6,{"$f":"+W256","v":0},{"$f":"+X256","v":11.6},{"$f":"(AG256-AC256)/AG256","v":0},null,11,{"$f":"SUM(AJ256:AL256)+AE256","v":11.6},null,null,{"$f":"ROUND(AC256/(1-VLOOKUP(AF256,Group,2,FALSE)),2)","v":11.6},{"$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,"Trim - MLW",null,null,"5/8\" x 12\"",null,"Quarter Round",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA258,AG258)","v":15.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.1,null,"new",15.1,0,15.1,0,null,12,15.1,null,null,15.1,0,0,"",null,"X"]
[]
[null,null,"MILTON RIDGE - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNMD",null,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:","Aegean Green",null,"    Beige",null,null,"     Dark Blue",null,"   Light Blue"]
[null,null,null,null,"Anthracite",null,"    Celadon Green",null,null,"     Gray",null,"   White"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"6.35 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA265,AG265)","v":12.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA265*(1-W265)+0.004999,2)","v":12.3},null,"new",12.3,{"$f":"+W265","v":0},{"$f":"+X265","v":12.3},{"$f":"(AG265-AC265)/AG265","v":0},null,11,{"$f":"SUM(AJ265:AL265)+AE265","v":12.3},null,null,{"$f":"ROUND(AC265/(1-VLOOKUP(AF265,Group,2,FALSE)),2)","v":12.3},{"$f":"IF(VLOOKUP(AF265,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ265,1)-AJ265,2),Round,2,FALSE)+VLOOKUP(AF265,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF265,Group,7,FALSE)=\"\",0,ROUND(AJ265-0.04999,1)-AJ265+AM265)","v":0},{"$f":"IF(VLOOKUP(AF265,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF265,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"MOMENTUM - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNMM",null,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:","Black          Gray          Pumice          White"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 8\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"3.77 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA271,AG271)","v":19.600000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA271*(1-W271)+0.004999,2)","v":19.600000000000001},null,"",19.600000000000001,{"$f":"+W271","v":0},{"$f":"+X271","v":19.600000000000001},{"$f":"(AG271-AC271)/AG271","v":0},null,11,{"$f":"SUM(AJ271:AL271)+AE271","v":19.600000000000001},null,null,{"$f":"ROUND(AC271/(1-VLOOKUP(AF271,Group,2,FALSE)),2)","v":19.600000000000001},{"$f":"IF(VLOOKUP(AF271,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ271,1)-AJ271,2),Round,2,FALSE)+VLOOKUP(AF271,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF271,Group,7,FALSE)=\"\",0,ROUND(AJ271-0.04999,1)-AJ271+AM271)","v":0},{"$f":"IF(VLOOKUP(AF271,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF271,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"MOROCCAN - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNMO",null,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:","Casablanca          Fez          Safi          Tangier"]
[]
[null,"Field Tile - MLW",null,null,"5\" x 5\" x 5/16\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"5.54 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA277,AG277)","v":17.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA277*(1-W277)+0.004999,2)","v":17.2},null,"",17.2,{"$f":"+W277","v":0},17.2,{"$f":"(AG277-AC277)/AG277","v":0},null,11,{"$f":"SUM(AJ277:AL277)+AE277","v":17.2},null,null,{"$f":"ROUND(AC277/(1-VLOOKUP(AF277,Group,2,FALSE)),2)","v":17.2},{"$f":"IF(VLOOKUP(AF277,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ277,1)-AJ277,2),Round,2,FALSE)+VLOOKUP(AF277,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF277,Group,7,FALSE)=\"\",0,ROUND(AJ277-0.04999,1)-AJ277+AM277)","v":0},{"$f":"IF(VLOOKUP(AF277,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF277,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"NAMI - Porcelain Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNNA",null,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:","Butternut          Ice          Steel Mist          White"]
[]
[null,"Field Tile - MLW",null,null,"4.7\" x 4.7\" x 7/16\"",null,"Field",null,null,null,null,null,null,null,null,"3.41 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA283,AG283)","v":28.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA283*(1-W283)+0.004999,2)","v":28.75},null,"new",28.75,{"$f":"+W283","v":0},{"$f":"+X283","v":28.75},{"$f":"(AG283-AC283)/AG283","v":0},null,11,{"$f":"SUM(AJ283:AL283)+AE283","v":28.75},null,null,{"$f":"ROUND(AC283/(1-VLOOKUP(AF283,Group,2,FALSE)),2)","v":28.75},{"$f":"IF(VLOOKUP(AF283,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ283,1)-AJ283,2),Round,2,FALSE)+VLOOKUP(AF283,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF283,Group,7,FALSE)=\"\",0,ROUND(AJ283-0.04999,1)-AJ283+AM283)","v":0},{"$f":"IF(VLOOKUP(AF283,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF283,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"NOLA - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNNO",null,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:","Dauphine          Lafayette          Magazine          Orleans          Toulouse"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA289,AG289)","v":13.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA289*(1-W289)+0.004999,2)","v":13.35},null,"",13.35,{"$f":"+W289","v":0},13.35,{"$f":"(AG289-AC289)/AG289","v":0},null,11,{"$f":"SUM(AJ289:AL289)+AE289","v":13.35},null,null,{"$f":"ROUND(AC289/(1-VLOOKUP(AF289,Group,2,FALSE)),2)","v":13.35},{"$f":"IF(VLOOKUP(AF289,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ289,1)-AJ289,2),Round,2,FALSE)+VLOOKUP(AF289,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF289,Group,7,FALSE)=\"\",0,ROUND(AJ289-0.04999,1)-AJ289+AM289)","v":0},{"$f":"IF(VLOOKUP(AF289,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF289,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"NOLA BLACK - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNNB",null,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:","Decatur          Tulane"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA295,AG295)","v":13.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA295*(1-W295)+0.004999,2)","v":13.35},null,"",13.35,{"$f":"+W295","v":0},{"$f":"+X295","v":13.35},{"$f":"(AG295-AC295)/AG295","v":0},null,11,{"$f":"SUM(AJ295:AL295)+AE295","v":13.35},null,null,{"$f":"ROUND(AC295/(1-VLOOKUP(AF295,Group,2,FALSE)),2)","v":13.35},{"$f":"IF(VLOOKUP(AF295,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ295,1)-AJ295,2),Round,2,FALSE)+VLOOKUP(AF295,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF295,Group,7,FALSE)=\"\",0,ROUND(AJ295-0.04999,1)-AJ295+AM295)","v":0},{"$f":"IF(VLOOKUP(AF295,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF295,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"NOMAD - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNNM",null,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:","Bohemian White          Gypsy Blue"]
[]
[null,"Field Tile - MLW",null,null,"20\" x 40\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"16.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA301,AG301)","v":19.649999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA301*(1-W301)+0.004999,2)","v":19.649999999999999},null,"",19.649999999999999,{"$f":"+W301","v":0},{"$f":"+X301","v":19.649999999999999},{"$f":"(AG301-AC301)/AG301","v":0},null,11,{"$f":"SUM(AJ301:AL301)+AE301","v":19.649999999999999},null,null,{"$f":"ROUND(AC301/(1-VLOOKUP(AF301,Group,2,FALSE)),2)","v":19.649999999999999},{"$f":"IF(VLOOKUP(AF301,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ301,1)-AJ301,2),Round,2,FALSE)+VLOOKUP(AF301,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF301,Group,7,FALSE)=\"\",0,ROUND(AJ301-0.04999,1)-AJ301+AM301)","v":0},{"$f":"IF(VLOOKUP(AF301,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF301,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"NORMANDY - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNNR",null,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:","Black          Gray          Ivory"]
[]
[null,"Field Tile - MLW",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"12.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA307,AG307)","v":14.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA307*(1-W307)+0.004999,2)","v":14.15},null,"",14.15,{"$f":"+W307","v":0},14.15,{"$f":"(AG307-AC307)/AG307","v":0},null,11,{"$f":"SUM(AJ307:AL307)+AE307","v":14.15},null,null,{"$f":"ROUND(AC307/(1-VLOOKUP(AF307,Group,2,FALSE)),2)","v":14.15},{"$f":"IF(VLOOKUP(AF307,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ307,1)-AJ307,2),Round,2,FALSE)+VLOOKUP(AF307,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF307,Group,7,FALSE)=\"\",0,ROUND(AJ307-0.04999,1)-AJ307+AM307)","v":0},{"$f":"IF(VLOOKUP(AF307,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF307,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"16.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA308,AG308)","v":15.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA308*(1-W308)+0.004999,2)","v":15.4},null,"",15.4,0,15.4,{"$f":"(AG308-AC308)/AG308","v":0},null,11,{"$f":"SUM(AJ308:AL308)+AE308","v":15.4},null,null,{"$f":"ROUND(AC308/(1-VLOOKUP(AF308,Group,2,FALSE)),2)","v":15.4},{"$f":"IF(VLOOKUP(AF308,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ308,1)-AJ308,2),Round,2,FALSE)+VLOOKUP(AF308,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF308,Group,7,FALSE)=\"\",0,ROUND(AJ308-0.04999,1)-AJ308+AM308)","v":0},{"$f":"IF(VLOOKUP(AF308,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF308,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"24\" x 36\"",null,"Field",null,null,null,null,null,null,null,null,"18.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA309,AG309)","v":15.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA309*(1-W309)+0.004999,2)","v":15.95},null,"",15.95,0,15.95,{"$f":"(AG309-AC309)/AG309","v":0},null,11,{"$f":"SUM(AJ309:AL309)+AE309","v":15.95},null,null,{"$f":"ROUND(AC309/(1-VLOOKUP(AF309,Group,2,FALSE)),2)","v":15.95},{"$f":"IF(VLOOKUP(AF309,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ309,1)-AJ309,2),Round,2,FALSE)+VLOOKUP(AF309,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF309,Group,7,FALSE)=\"\",0,ROUND(AJ309-0.04999,1)-AJ309+AM309)","v":0},{"$f":"IF(VLOOKUP(AF309,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF309,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"ONYX - Porcelain",null,null,null,null,null,null,"DISCONTINUED 12/10/25",null,null,null,null,null,null,null,"Item # Lookup:","CNON",null,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:","Angora Gray          Persian White"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA315,AG315)","v":15.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA315*(1-W315)+0.004999,2)","v":15.65},null,"",15.65,{"$f":"+W315","v":0},15.65,{"$f":"(AG315-AC315)/AG315","v":0},null,11,{"$f":"SUM(AJ315:AL315)+AE315","v":15.65},null,null,{"$f":"ROUND(AC315/(1-VLOOKUP(AF315,Group,2,FALSE)),2)","v":15.65},{"$f":"IF(VLOOKUP(AF315,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ315,1)-AJ315,2),Round,2,FALSE)+VLOOKUP(AF315,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF315,Group,7,FALSE)=\"\",0,ROUND(AJ315-0.04999,1)-AJ315+AM315)","v":0},{"$f":"IF(VLOOKUP(AF315,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF315,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA316,AG316)","v":13.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA316*(1-W316)+0.004999,2)","v":13.7},null,"",13.7,0,13.7,{"$f":"(AG316-AC316)/AG316","v":0},null,11,{"$f":"SUM(AJ316:AL316)+AE316","v":13.7},null,null,{"$f":"ROUND(AC316/(1-VLOOKUP(AF316,Group,2,FALSE)),2)","v":13.7},{"$f":"IF(VLOOKUP(AF316,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ316,1)-AJ316,2),Round,2,FALSE)+VLOOKUP(AF316,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF316,Group,7,FALSE)=\"\",0,ROUND(AJ316-0.04999,1)-AJ316+AM316)","v":0},{"$f":"IF(VLOOKUP(AF316,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF316,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA317,AG317)","v":16.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA317*(1-W317)+0.004999,2)","v":16.05},null,"",16.05,0,16.05,{"$f":"(AG317-AC317)/AG317","v":0},null,11,{"$f":"SUM(AJ317:AL317)+AE317","v":16.05},null,null,{"$f":"ROUND(AC317/(1-VLOOKUP(AF317,Group,2,FALSE)),2)","v":16.05},{"$f":"IF(VLOOKUP(AF317,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ317,1)-AJ317,2),Round,2,FALSE)+VLOOKUP(AF317,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF317,Group,7,FALSE)=\"\",0,ROUND(AJ317-0.04999,1)-AJ317+AM317)","v":0},{"$f":"IF(VLOOKUP(AF317,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF317,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos - MLW",null,null,"12\" x 12\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(0.98 SF/Sheet)",null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA319,AG319)","v":32.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA319*(1-W319)+0.004999,2)","v":32.6},null,"",32.6,{"$f":"+W319","v":0},{"$f":"+X319","v":32.6},{"$f":"(AG319-AC319)/AG319","v":0},null,13,{"$f":"SUM(AJ319:AL319)+AE319","v":32.6},null,null,{"$f":"ROUND(AC319/(1-VLOOKUP(AF319,Group,2,FALSE)),2)","v":32.6},{"$f":"IF(VLOOKUP(AF319,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ319,1)-AJ319,2),Round,2,FALSE)+VLOOKUP(AF319,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF319,Group,7,FALSE)=\"\",0,ROUND(AJ319-0.04999,1)-AJ319+AM319)","v":0},{"$f":"IF(VLOOKUP(AF319,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF319,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PACIFIC - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNPC",null,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:","Birch          Chestnut          Driftwood          Pine"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA325,AG325)","v":13.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA325*(1-W325)+0.004999,2)","v":13.35},null,"",13.35,{"$f":"+W325","v":0},{"$f":"+X325","v":13.35},{"$f":"(AG325-AC325)/AG325","v":0},null,11,{"$f":"SUM(AJ325:AL325)+AE325","v":13.35},null,null,{"$f":"ROUND(AC325/(1-VLOOKUP(AF325,Group,2,FALSE)),2)","v":13.35},{"$f":"IF(VLOOKUP(AF325,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ325,1)-AJ325,2),Round,2,FALSE)+VLOOKUP(AF325,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF325,Group,7,FALSE)=\"\",0,ROUND(AJ325-0.04999,1)-AJ325+AM325)","v":0},{"$f":"IF(VLOOKUP(AF325,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF325,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Carmel          Laguna          Lodi          Ojai"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA329,AG329)","v":13.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA329*(1-W329)+0.004999,2)","v":13.35},null,"",13.35,{"$f":"+W329","v":0},13.35,{"$f":"(AG329-AC329)/AG329","v":0},null,11,{"$f":"SUM(AJ329:AL329)+AE329","v":13.35},null,null,{"$f":"ROUND(AC329/(1-VLOOKUP(AF329,Group,2,FALSE)),2)","v":13.35},{"$f":"IF(VLOOKUP(AF329,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ329,1)-AJ329,2),Round,2,FALSE)+VLOOKUP(AF329,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF329,Group,7,FALSE)=\"\",0,ROUND(AJ329-0.04999,1)-AJ329+AM329)","v":0},{"$f":"IF(VLOOKUP(AF329,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF329,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PIAZZA - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNPA",null,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:","Brown          Gray          White"]
[]
[null,"Field Tile - MLW",null,null,"6\" x 6\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"5.50 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA335,AG335)","v":15.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA335*(1-W335)+0.004999,2)","v":15.35},null,"",15.35,{"$f":"+W335","v":0},{"$f":"+X335","v":15.35},{"$f":"(AG335-AC335)/AG335","v":0},null,11,{"$f":"SUM(AJ335:AL335)+AE335","v":15.35},null,null,{"$f":"ROUND(AC335/(1-VLOOKUP(AF335,Group,2,FALSE)),2)","v":15.35},{"$f":"IF(VLOOKUP(AF335,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ335,1)-AJ335,2),Round,2,FALSE)+VLOOKUP(AF335,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF335,Group,7,FALSE)=\"\",0,ROUND(AJ335-0.04999,1)-AJ335+AM335)","v":0},{"$f":"IF(VLOOKUP(AF335,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF335,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Packaging is changing from 11.00 SF/CTN to 5.50 SF/CTN as inventory with old packaging is depleted."]
[]
[null,null,"PLUME - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNPL",null,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:","Gloss Aqua",null,"    Gloss Teal",null,null,"  Matte Graphite",null,"         Matte White"]
[null,null,null,null,"Gloss Black",null,"    Gloss White",null,null,"  Matte Gray"]
[null,null,null,null,"Gloss Pewter",null,"    Matte Clay",null,null,"  Matte Sea"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 8\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"5.17 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA345,AG345)","v":23.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA345*(1-W345)+0.004999,2)","v":23.65},null,"",23.65,{"$f":"+W345","v":0},{"$f":"+X345","v":23.65},{"$f":"(AG345-AC345)/AG345","v":0},null,11,{"$f":"SUM(AJ345:AL345)+AE345","v":23.65},null,null,{"$f":"ROUND(AC345/(1-VLOOKUP(AF345,Group,2,FALSE)),2)","v":23.65},{"$f":"IF(VLOOKUP(AF345,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ345,1)-AJ345,2),Round,2,FALSE)+VLOOKUP(AF345,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF345,Group,7,FALSE)=\"\",0,ROUND(AJ345-0.04999,1)-AJ345+AM345)","v":0},{"$f":"IF(VLOOKUP(AF345,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF345,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW",null,null,"1/2\" x 12\"",null,"Quarter Round",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA347,AG347)","v":10.45},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA347*(1-W347)+0.004999,2)","v":10.45},null,"",10.45,{"$f":"+W347","v":0},{"$f":"+X347","v":10.45},{"$f":"(AG347-AC347)/AG347","v":0},null,12,{"$f":"SUM(AJ347:AL347)+AE347","v":10.45},null,null,{"$f":"ROUND(AC347/(1-VLOOKUP(AF347,Group,2,FALSE)),2)","v":10.45},{"$f":"IF(VLOOKUP(AF347,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ347,1)-AJ347,2),Round,2,FALSE)+VLOOKUP(AF347,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF347,Group,7,FALSE)=\"\",0,ROUND(AJ347-0.04999,1)-AJ347+AM347)","v":0},{"$f":"IF(VLOOKUP(AF347,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF347,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PORTOFINO - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNPO",null,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:","Arabescato Marble",null,null,"Marmo Bianco",null,null,"    Silver Travertine"]
[null,null,null,null,"Ivory Travertine",null,null,"Marmo Fumo"]
[]
[null,"Field Tile - MLW",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"16.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA354,AG354)","v":16.399999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA354*(1-W354)+0.004999,2)","v":16.399999999999999},null,"",16.399999999999999,{"$f":"+W354","v":0},{"$f":"+X354","v":16.399999999999999},{"$f":"(AG354-AC354)/AG354","v":0},null,11,{"$f":"SUM(AJ354:AL354)+AE354","v":16.399999999999999},null,null,{"$f":"ROUND(AC354/(1-VLOOKUP(AF354,Group,2,FALSE)),2)","v":16.399999999999999},{"$f":"IF(VLOOKUP(AF354,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ354,1)-AJ354,2),Round,2,FALSE)+VLOOKUP(AF354,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF354,Group,7,FALSE)=\"\",0,ROUND(AJ354-0.04999,1)-AJ354+AM354)","v":0},{"$f":"IF(VLOOKUP(AF354,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF354,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"QUADRANT - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNQU",null,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:","Ash             Blue             Deep Blue             Gray             White"]
[]
[null,"Field Tile - MLW",null,null,"6\" x 6\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"11.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA360,AG360)","v":15.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA360*(1-W360)+0.004999,2)","v":15.2},null,"",15.2,{"$f":"+W360","v":0},{"$f":"+X360","v":15.2},{"$f":"(AG360-AC360)/AG360","v":0},null,11,{"$f":"SUM(AJ360:AL360)+AE360","v":15.2},null,null,{"$f":"ROUND(AC360/(1-VLOOKUP(AF360,Group,2,FALSE)),2)","v":15.2},{"$f":"IF(VLOOKUP(AF360,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ360,1)-AJ360,2),Round,2,FALSE)+VLOOKUP(AF360,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF360,Group,7,FALSE)=\"\",0,ROUND(AJ360-0.04999,1)-AJ360+AM360)","v":0},{"$f":"IF(VLOOKUP(AF360,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF360,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Packaging is changing from 11.00 SF/CTN to 5.50 SF/CTN as inventory with old packaging is depleted."]
[]
[null,null,"QUARRY - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNQR",null,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:","Calacatta Gold",null,null,"Noir Saint Laurent",null,null,"          Pulpis Gray"]
[null,null,null,null,"Calacatta Statuary",null,null,"Pulpis Dark Gray",null,null,"          Pulpis Taupe"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 9\" x 1/4\"",null,"Field - Hexagon",null,null,null,null,null,null,null,null,"9.04 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA369,AG369)","v":14.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA369*(1-W369)+0.004999,2)","v":14.45},null,"",14.45,{"$f":"+W369","v":0},{"$f":"+X369","v":14.45},{"$f":"(AG369-AC369)/AG369","v":0},null,11,{"$f":"SUM(AJ369:AL369)+AE369","v":14.45},null,null,{"$f":"ROUND(AC369/(1-VLOOKUP(AF369,Group,2,FALSE)),2)","v":14.45},{"$f":"IF(VLOOKUP(AF369,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ369,1)-AJ369,2),Round,2,FALSE)+VLOOKUP(AF369,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF369,Group,7,FALSE)=\"\",0,ROUND(AJ369-0.04999,1)-AJ369+AM369)","v":0},{"$f":"IF(VLOOKUP(AF369,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF369,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"RAINFOREST - Ceramic",null,null,null,null,null,null,"DISCONTINUED 10/6/25",null,null,null,null,null,null,null,"Item # Lookup:","CNRA",null,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:","Amazon Brown             Jungle Green             Lagoon Blue"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 12\" x 5/16\"",null,"Field",null,null,null,null," ",null,null,null,"9.91 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA375,AG375)","v":19.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA375*(1-W375)+0.004999,2)","v":19.95},null,"",19.95,{"$f":"+W375","v":0},{"$f":"+X375","v":19.95},{"$f":"(AG375-AC375)/AG375","v":0},null,11,{"$f":"SUM(AJ375:AL375)+AE375","v":19.95},null,null,{"$f":"ROUND(AC375/(1-VLOOKUP(AF375,Group,2,FALSE)),2)","v":19.95},{"$f":"IF(VLOOKUP(AF375,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ375,1)-AJ375,2),Round,2,FALSE)+VLOOKUP(AF375,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF375,Group,7,FALSE)=\"\",0,ROUND(AJ375-0.04999,1)-AJ375+AM375)","v":0},{"$f":"IF(VLOOKUP(AF375,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF375,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"SEDONA - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNSE",null,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:","Avocado","Gray",null,null,"          Spice",null,"         White"]
[null,null,null,null,"Bone","Light Blue",null,null,"          Terracotta"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 4\" x 5/16\"",null,"Field",null,null,null,null," ",null,null,null,"6.16 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA382,AG382)","v":16.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA382*(1-W382)+0.004999,2)","v":16.75},null,"",16.75,{"$f":"+W382","v":0},16.75,{"$f":"(AG382-AC382)/AG382","v":0},null,11,{"$f":"SUM(AJ382:AL382)+AE382","v":16.75},null,null,{"$f":"ROUND(AC382/(1-VLOOKUP(AF382,Group,2,FALSE)),2)","v":16.75},{"$f":"IF(VLOOKUP(AF382,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ382,1)-AJ382,2),Round,2,FALSE)+VLOOKUP(AF382,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF382,Group,7,FALSE)=\"\",0,ROUND(AJ382-0.04999,1)-AJ382+AM382)","v":0},{"$f":"IF(VLOOKUP(AF382,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF382,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"4\" x 8\" x 5/16\"",null,"Field",null,null,null,null," ",null,null,null,"11.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA383,AG383)","v":16.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA383*(1-W383)+0.004999,2)","v":16.95},null,"",16.95,0,16.95,{"$f":"(AG383-AC383)/AG383","v":0},null,11,{"$f":"SUM(AJ383:AL383)+AE383","v":16.95},null,null,{"$f":"ROUND(AC383/(1-VLOOKUP(AF383,Group,2,FALSE)),2)","v":16.95},{"$f":"IF(VLOOKUP(AF383,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ383,1)-AJ383,2),Round,2,FALSE)+VLOOKUP(AF383,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF383,Group,7,FALSE)=\"\",0,ROUND(AJ383-0.04999,1)-AJ383+AM383)","v":0},{"$f":"IF(VLOOKUP(AF383,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF383,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8\" x 24\" x 5/16\"",null,"Field",null,null,null,null," ",null,null,null,"10.64 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA384,AG384)","v":17.649999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA384*(1-W384)+0.004999,2)","v":17.649999999999999},null,"",17.649999999999999,0,17.649999999999999,{"$f":"(AG384-AC384)/AG384","v":0},null,11,{"$f":"SUM(AJ384:AL384)+AE384","v":17.649999999999999},null,null,{"$f":"ROUND(AC384/(1-VLOOKUP(AF384,Group,2,FALSE)),2)","v":17.649999999999999},{"$f":"IF(VLOOKUP(AF384,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ384,1)-AJ384,2),Round,2,FALSE)+VLOOKUP(AF384,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF384,Group,7,FALSE)=\"\",0,ROUND(AJ384-0.04999,1)-AJ384+AM384)","v":0},{"$f":"IF(VLOOKUP(AF384,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF384,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW",null,null,"5/8\" x 12\"",null,"Quarter Round",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA386,AG386)","v":11.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA386*(1-W386)+0.004999,2)","v":11.25},null,"",11.25,{"$f":"+W386","v":0},{"$f":"+X386","v":11.25},{"$f":"(AG386-AC386)/AG386","v":0},null,12,{"$f":"SUM(AJ386:AL386)+AE386","v":11.25},null,null,{"$f":"ROUND(AC386/(1-VLOOKUP(AF386,Group,2,FALSE)),2)","v":11.25},{"$f":"IF(VLOOKUP(AF386,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ386,1)-AJ386,2),Round,2,FALSE)+VLOOKUP(AF386,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF386,Group,7,FALSE)=\"\",0,ROUND(AJ386-0.04999,1)-AJ386+AM386)","v":0},{"$f":"IF(VLOOKUP(AF386,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF386,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Available in color White only."]
[]
[null,null,"SLATE - Natural Stone Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNSL",null,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:","Black Blizzard"]
[]
[null,"Field Tile - MLW Stone",null,null,"4\" x 4\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA394,AG394)","v":15.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA394*(1-W394)+0.004999,2)","v":15.45},null,"",15.45,{"$f":"+W394","v":0},{"$f":"+X394","v":15.45},{"$f":"(AG394-AC394)/AG394","v":0},null,8,{"$f":"SUM(AJ394:AL394)+AE394","v":15.45},null,null,{"$f":"ROUND(AC394/(1-VLOOKUP(AF394,Group,2,FALSE)),2)","v":15.45},{"$f":"IF(VLOOKUP(AF394,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ394,1)-AJ394,2),Round,2,FALSE)+VLOOKUP(AF394,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF394,Group,7,FALSE)=\"\",0,ROUND(AJ394-0.04999,1)-AJ394+AM394)","v":0},{"$f":"IF(VLOOKUP(AF394,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF394,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,15.45,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.45,null,"",15.45,0,15.45,0,null,8,15.45,null,null,15.45,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"8\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"11.20 SF/CTN",null,null,15.5,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.5,null,"",15.5,0,15.5,0,null,8,15.5,null,null,15.5,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,"a",26.85,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},26.85,null,"",26.85,0,26.85,0,null,8,26.85,null,null,26.85,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,14,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14,null,"",14,0,14,0,null,8,14,null,null,14,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,14.45,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.45,null,"",14.45,0,14.45,0,null,8,14.45,null,null,14.45,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"16\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"10.68 SF/CTN",null,null,15,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15,null,"",15,0,15,0,null,8,15,null,null,15,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,15.1,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.1,null,"",15.1,0,15.1,0,null,8,15.1,null,null,15.1,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,15.55,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.55,null,"",15.55,0,15.55,0,null,8,15.55,null,null,15.55,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"18\" x 36\"",null,"Field",null,null,null,null,null,null,null,null,"4.50 SF/PC",null,null,17.100000000000001,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},17.100000000000001,null,"",17.100000000000001,0,17.100000000000001,0,null,8,17.100000000000001,null,null,17.100000000000001,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"10\"",null,"Field - Hexagon",null,null,null,null,null,null,null,null,"6.00 SF/CTN",null,null,26.85,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},26.85,null,"",26.85,0,26.85,0,null,8,26.85,null,null,26.85,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"2-3/4\" x 11\"",null,"Field - Picket",null,null,null,null,null,null,null,null,"10.55 SF/CTN",null,null,18.350000000000001,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},18.350000000000001,null,"",18.350000000000001,0,18.350000000000001,0,null,8,18.350000000000001,null,null,18.350000000000001,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,null,null,"Field - Versailles Pattern",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",AA406,AG406)","v":14.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA406*(1-W406)+0.004999,2)","v":14.95},null,"",14.95,{"$f":"+W406","v":0},{"$f":"+X406","v":14.95},{"$f":"(AG406-AC406)/AG406","v":0},null,8,{"$f":"SUM(AJ406:AL406)+AE406","v":14.95},null,null,{"$f":"ROUND(AC406/(1-VLOOKUP(AF406,Group,2,FALSE)),2)","v":14.95},{"$f":"IF(VLOOKUP(AF406,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ406,1)-AJ406,2),Round,2,FALSE)+VLOOKUP(AF406,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF406,Group,7,FALSE)=\"\",0,ROUND(AJ406-0.04999,1)-AJ406+AM406)","v":0},{"$f":"IF(VLOOKUP(AF406,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF406,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos - MLW Stone",null,null,"10-3/4\" x 16-3/4\"",null,"Mosaic",null,null,"1-3/4\" x 5-5/8\" Herringbone",null,null,"(1.25 SF/Sheet)",null,null,"10.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA408,AG408)","v":57.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA408*(1-W408)+0.004999,2)","v":57.7},null,"",57.7,{"$f":"+W408","v":0},{"$f":"+X408","v":57.7},{"$f":"(AG408-AC408)/AG408","v":0},null,10,{"$f":"SUM(AJ408:AL408)+AE408","v":57.7},null,null,{"$f":"ROUND(AC408/(1-VLOOKUP(AF408,Group,2,FALSE)),2)","v":57.7},{"$f":"IF(VLOOKUP(AF408,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ408,1)-AJ408,2),Round,2,FALSE)+VLOOKUP(AF408,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF408,Group,7,FALSE)=\"\",0,ROUND(AJ408-0.04999,1)-AJ408+AM408)","v":0},{"$f":"IF(VLOOKUP(AF408,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF408,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos - MLW Stone",null,null,"12\" x 12\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(1.00 SF/Sheet)",null,null,"10.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA409,AG409)","v":33.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA409*(1-W409)+0.004999,2)","v":33.75},null,"",33.75,{"$f":"+W409","v":0},33.75,{"$f":"(AG409-AC409)/AG409","v":0},null,10,{"$f":"SUM(AJ409:AL409)+AE409","v":33.75},null,null,{"$f":"ROUND(AC409/(1-VLOOKUP(AF409,Group,2,FALSE)),2)","v":33.75},{"$f":"IF(VLOOKUP(AF409,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ409,1)-AJ409,2),Round,2,FALSE)+VLOOKUP(AF409,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF409,Group,7,FALSE)=\"\",0,ROUND(AJ409-0.04999,1)-AJ409+AM409)","v":0},{"$f":"IF(VLOOKUP(AF409,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF409,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos - MLW Stone",null,null,"12\" x 12\"",null,"Mosaic",null,null,"Large Herringbone",null,null,"(1.00 SF/Sheet)",null,null,"10.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA410,AG410)","v":54.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA410*(1-W410)+0.004999,2)","v":54.2},null,"",54.2,{"$f":"+W410","v":0},{"$f":"+X410","v":54.2},{"$f":"(AG410-AC410)/AG410","v":0},null,10,{"$f":"SUM(AJ410:AL410)+AE410","v":54.2},null,null,{"$f":"ROUND(AC410/(1-VLOOKUP(AF410,Group,2,FALSE)),2)","v":54.2},{"$f":"IF(VLOOKUP(AF410,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ410,1)-AJ410,2),Round,2,FALSE)+VLOOKUP(AF410,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF410,Group,7,FALSE)=\"\",0,ROUND(AJ410-0.04999,1)-AJ410+AM410)","v":0},{"$f":"IF(VLOOKUP(AF410,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF410,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos - MLW Stone",null,null,"12-1/2\" x 12-3/8",null,"Mosaic",null,null,"Small Herringbone",null,null,"(1.10 SF/Sheet)",null,null,"9.90 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA411,AG411)","v":58.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA411*(1-W411)+0.004999,2)","v":58.15},null,"",58.15,0,58.15,{"$f":"(AG411-AC411)/AG411","v":0},null,10,{"$f":"SUM(AJ411:AL411)+AE411","v":58.15},null,null,{"$f":"ROUND(AC411/(1-VLOOKUP(AF411,Group,2,FALSE)),2)","v":58.15},{"$f":"IF(VLOOKUP(AF411,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ411,1)-AJ411,2),Round,2,FALSE)+VLOOKUP(AF411,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF411,Group,7,FALSE)=\"\",0,ROUND(AJ411-0.04999,1)-AJ411+AM411)","v":0},{"$f":"IF(VLOOKUP(AF411,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF411,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Color:","Squall",null,null,null,null,null,null,null," "]
[]
[null,"Field Tile - MLW Stone",null,null,"4\" x 4\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA415,AG415)","v":15.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA415*(1-W415)+0.004999,2)","v":15.45},null,"",15.45,{"$f":"+W415","v":0},{"$f":"+X415","v":15.45},{"$f":"(AG415-AC415)/AG415","v":0},null,8,{"$f":"SUM(AJ415:AL415)+AE415","v":15.45},null,null,{"$f":"ROUND(AC415/(1-VLOOKUP(AF415,Group,2,FALSE)),2)","v":15.45},{"$f":"IF(VLOOKUP(AF415,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ415,1)-AJ415,2),Round,2,FALSE)+VLOOKUP(AF415,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF415,Group,7,FALSE)=\"\",0,ROUND(AJ415-0.04999,1)-AJ415+AM415)","v":0},{"$f":"IF(VLOOKUP(AF415,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF415,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,15.45,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.45,null,"",15.45,0,15.45,0,null,8,15.45,null,null,15.45,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"8\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"11.20 SF/CTN",null,null,15.5,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.5,null,"",15.5,0,15.5,0,null,8,15.5,null,null,15.5,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,"a",30.35,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},30.35,null,"",30.35,0,30.35,0,null,8,30.35,null,null,30.35,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 12\"",null,"Field",null,null,null,null," ",null,null,null,"10.00 SF/CTN",null,null,14,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14,null,"",14,0,14,0,null,8,14,null,null,14,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,14.45,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.45,null,"",14.45,0,14.45,0,null,8,14.45,null,null,14.45,0,0,"",null,"X"]
[]
[null,null,"continued on next page"]
[null,null,"SLATE - Natural Stone Floor & Wall - continued",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNSL",null,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:","Squall",null,null,null,null,null,null,null," "]
[]
[null,"Field Tile - MLW Stone",null,null,"16\" x 16\"",null,"Field",null,null,null," ",null,null,null,null,"10.68 SF/CTN",null,null,15,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15,null,"",15,0,15,0,null,8,15,null,null,15,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,27.4,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},27.4,null,"",27.4,0,27.4,0,null,8,27.4,null,null,27.4,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,15.55,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.55,null,"",15.55,0,15.55,0,null,8,15.55,null,null,15.55,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"10\"",null,"Field - Hexagon",null,null,null,null,null,null,null,null,"6.00 SF/CTN",null,null,26.85,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},26.85,null,"",26.85,0,26.85,0,null,8,26.85,null,null,26.85,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"2-3/4\" x 11\"",null,"Field - Picket",null,null,null,null,null,null,null,null,"10.55 SF/CTN",null,null,18.350000000000001,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},18.350000000000001,null,"",18.350000000000001,0,18.350000000000001,0,null,8,18.350000000000001,null,null,18.350000000000001,0,0,"",null,"X"]
[]
[null,"Decos - MLW Stone",null,null,"10-3/4\" x 16-3/4\"",null,"Mosaic",null,null,"1-3/4\" x 5-5/8\" Herringbone",null,null,"(1.25 SF/Sheet)",null,null,"10.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA433,AG433)","v":57.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA433*(1-W433)+0.004999,2)","v":57.7},null,"",57.7,{"$f":"+W433","v":0},{"$f":"+X433","v":57.7},{"$f":"(AG433-AC433)/AG433","v":0},null,10,{"$f":"SUM(AJ433:AL433)+AE433","v":57.7},null,null,{"$f":"ROUND(AC433/(1-VLOOKUP(AF433,Group,2,FALSE)),2)","v":57.7},{"$f":"IF(VLOOKUP(AF433,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ433,1)-AJ433,2),Round,2,FALSE)+VLOOKUP(AF433,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF433,Group,7,FALSE)=\"\",0,ROUND(AJ433-0.04999,1)-AJ433+AM433)","v":0},{"$f":"IF(VLOOKUP(AF433,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF433,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos - MLW Stone",null,null,"13.75\" x 13.75\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(1.36 SF/Sheet)",null,null,"6.80 SF/CTN",null,"a,c",{"$f":"IF(Suggested=\"Yes\",AA434,AG434)","v":57.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA434*(1-W434)+0.004999,2)","v":57.55},null,"",57.55,{"$f":"+W434","v":0},57.55,{"$f":"(AG434-AC434)/AG434","v":0},null,10,{"$f":"SUM(AJ434:AL434)+AE434","v":57.55},null,null,{"$f":"ROUND(AC434/(1-VLOOKUP(AF434,Group,2,FALSE)),2)","v":57.55},{"$f":"IF(VLOOKUP(AF434,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ434,1)-AJ434,2),Round,2,FALSE)+VLOOKUP(AF434,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF434,Group,7,FALSE)=\"\",0,ROUND(AJ434-0.04999,1)-AJ434+AM434)","v":0},{"$f":"IF(VLOOKUP(AF434,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF434,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos - MLW Stone",null,null,"12-1/2\" x 12-3/8",null,"Mosaic",null,null,"Small Herringbone",null,null,"(1.10 SF/Sheet)",null,null,"9.90 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA435,AG435)","v":58.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA435*(1-W435)+0.004999,2)","v":58.15},null,"",58.15,0,58.15,{"$f":"(AG435-AC435)/AG435","v":0},null,10,{"$f":"SUM(AJ435:AL435)+AE435","v":58.15},null,null,{"$f":"ROUND(AC435/(1-VLOOKUP(AF435,Group,2,FALSE)),2)","v":58.15},{"$f":"IF(VLOOKUP(AF435,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ435,1)-AJ435,2),Round,2,FALSE)+VLOOKUP(AF435,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF435,Group,7,FALSE)=\"\",0,ROUND(AJ435-0.04999,1)-AJ435+AM435)","v":0},{"$f":"IF(VLOOKUP(AF435,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF435,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Special Order - approximately 3-4 weeks."]
[null,null,null,null,"b) Consists of the following sizes:  8\" x 8\", 2 pieces, 8\" x 16\", 1 piece, 16\" x 16\", 2 pieces and 16\" x 24\", 1 piece.  "]
[null,null,null,null,"c) Minimum purchase is 13.60 SF, (2 cartons)."]
[]
[null,null,"STELLA - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNST",null,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:","Black             Tan             White"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA445,AG445)","v":13.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA445*(1-W445)+0.004999,2)","v":13.35},null,"",13.35,{"$f":"+W445","v":0},{"$f":"+X445","v":13.35},{"$f":"(AG445-AC445)/AG445","v":0},null,11,{"$f":"SUM(AJ445:AL445)+AE445","v":13.35},null,null,{"$f":"ROUND(AC445/(1-VLOOKUP(AF445,Group,2,FALSE)),2)","v":13.35},{"$f":"IF(VLOOKUP(AF445,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ445,1)-AJ445,2),Round,2,FALSE)+VLOOKUP(AF445,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF445,Group,7,FALSE)=\"\",0,ROUND(AJ445-0.04999,1)-AJ445+AM445)","v":0},{"$f":"IF(VLOOKUP(AF445,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF445,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field - Star",null,null,null,null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA447,AG447)","v":13.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA447*(1-W447)+0.004999,2)","v":13.35},null,"",13.35,{"$f":"+W447","v":0},{"$f":"+X447","v":13.35},{"$f":"(AG447-AC447)/AG447","v":0},null,11,{"$f":"SUM(AJ447:AL447)+AE447","v":13.35},null,null,{"$f":"ROUND(AC447/(1-VLOOKUP(AF447,Group,2,FALSE)),2)","v":13.35},{"$f":"IF(VLOOKUP(AF447,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ447,1)-AJ447,2),Round,2,FALSE)+VLOOKUP(AF447,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF447,Group,7,FALSE)=\"\",0,ROUND(AJ447-0.04999,1)-AJ447+AM447)","v":0},{"$f":"IF(VLOOKUP(AF447,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF447,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"STONE CLASSICS - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNSC",null,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:","Belgian Bluestone",null,null,"Piasentina Stone",null,null,"           Silver Gray Travertine"]
[null,null,null,null,"French Limestone",null,null,"Roman Travertine",null,null,"           Soap Stone"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 18\"",null,"Field",null,null,null,null,null,null,null,null,"9.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA454,AG454)","v":14.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA454*(1-W454)+0.004999,2)","v":14.65},null,"",14.65,{"$f":"+W454","v":0},{"$f":"+X454","v":14.65},{"$f":"(AG454-AC454)/AG454","v":0},null,11,{"$f":"SUM(AJ454:AL454)+AE454","v":14.65},null,null,{"$f":"ROUND(AC454/(1-VLOOKUP(AF454,Group,2,FALSE)),2)","v":14.65},{"$f":"IF(VLOOKUP(AF454,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ454,1)-AJ454,2),Round,2,FALSE)+VLOOKUP(AF454,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF454,Group,7,FALSE)=\"\",0,ROUND(AJ454-0.04999,1)-AJ454+AM454)","v":0},{"$f":"IF(VLOOKUP(AF454,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF454,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"TARRAGONA - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNTA",null,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:","Aegean Green             Lumen Gray             Putty             Twilight Gray             White"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 8\" x 5/16\"",null,"Field - Leaf",null,null,null,"Glossy",null,null,null,null,"3.12 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA460,AG460)","v":31.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA460*(1-W460)+0.004999,2)","v":31.2},null,"new",31.2,{"$f":"+W460","v":0},{"$f":"+X460","v":31.2},{"$f":"(AG460-AC460)/AG460","v":0},null,11,{"$f":"SUM(AJ460:AL460)+AE460","v":31.2},null,null,{"$f":"ROUND(AC460/(1-VLOOKUP(AF460,Group,2,FALSE)),2)","v":31.2},{"$f":"IF(VLOOKUP(AF460,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ460,1)-AJ460,2),Round,2,FALSE)+VLOOKUP(AF460,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF460,Group,7,FALSE)=\"\",0,ROUND(AJ460-0.04999,1)-AJ460+AM460)","v":0},{"$f":"IF(VLOOKUP(AF460,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF460,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"6.5\" x 6.5\" x 5/16\"",null,"Field - Nexus",null,null,null,"Glossy",null,null,null,null,"4.41 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA461,AG461)","v":31.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA461*(1-W461)+0.004999,2)","v":31.3},null,"new",31.3,{"$f":"+W461","v":0},{"$f":"+X461","v":31.3},{"$f":"(AG461-AC461)/AG461","v":0},null,11,{"$f":"SUM(AJ461:AL461)+AE461","v":31.3},null,null,{"$f":"ROUND(AC461/(1-VLOOKUP(AF461,Group,2,FALSE)),2)","v":31.3},{"$f":"IF(VLOOKUP(AF461,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ461,1)-AJ461,2),Round,2,FALSE)+VLOOKUP(AF461,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF461,Group,7,FALSE)=\"\",0,ROUND(AJ461-0.04999,1)-AJ461+AM461)","v":0},{"$f":"IF(VLOOKUP(AF461,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF461,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) This two-part combination pattern that requires ordering 1 carton of the Nexus Field and 2 cartons of the Leaf Field."]
[null,null,null,null,"Example: 106.50 SF total needed, order 44.10 SF (10 Cartons) of the Nexus Field and 62.40 SF (20 Cartons) of the Leaf Field."]
[null,null,null,null,"The Tarragona Series can also be combined with the Barcelona Series to create different colors and finish combinations."]
[]
[null,null,"TERRACOTTA - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNTE",null,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:","Dark          Light"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"11.52 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA471,AG471)","v":14.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA471*(1-W471)+0.004999,2)","v":14.85},null,"",14.85,{"$f":"+W471","v":0},{"$f":"+X471","v":14.85},{"$f":"(AG471-AC471)/AG471","v":0},null,11,{"$f":"SUM(AJ471:AL471)+AE471","v":14.85},null,null,{"$f":"ROUND(AC471/(1-VLOOKUP(AF471,Group,2,FALSE)),2)","v":14.85},{"$f":"IF(VLOOKUP(AF471,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ471,1)-AJ471,2),Round,2,FALSE)+VLOOKUP(AF471,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF471,Group,7,FALSE)=\"\",0,ROUND(AJ471-0.04999,1)-AJ471+AM471)","v":0},{"$f":"IF(VLOOKUP(AF471,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF471,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"URBAN - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNUR",null,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:","Black             Blue             Gray             Rose             White"]
[]
[null,"Field Tile - MLW",null,null,"4.5\" x 4.5\"",null,"Field",null,null,null,null,null," ",null,null,"5.42 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA477,AG477)","v":19.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA477*(1-W477)+0.004999,2)","v":19.2},null,"",19.2,{"$f":"+W477","v":0},19.2,{"$f":"(AG477-AC477)/AG477","v":0},null,11,{"$f":"SUM(AJ477:AL477)+AE477","v":19.2},null,null,{"$f":"ROUND(AC477/(1-VLOOKUP(AF477,Group,2,FALSE)),2)","v":19.2},{"$f":"IF(VLOOKUP(AF477,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ477,1)-AJ477,2),Round,2,FALSE)+VLOOKUP(AF477,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF477,Group,7,FALSE)=\"\",0,ROUND(AJ477-0.04999,1)-AJ477+AM477)","v":0},{"$f":"IF(VLOOKUP(AF477,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF477,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"2.25\" x 9\"",null,"Field",null,null,null,null,null,null,null,null,"5.42 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA478,AG478)","v":18.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA478*(1-W478)+0.004999,2)","v":18.75},null,"",18.75,0,18.75,{"$f":"(AG478-AC478)/AG478","v":0},null,11,{"$f":"SUM(AJ478:AL478)+AE478","v":18.75},null,null,{"$f":"ROUND(AC478/(1-VLOOKUP(AF478,Group,2,FALSE)),2)","v":18.75},{"$f":"IF(VLOOKUP(AF478,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ478,1)-AJ478,2),Round,2,FALSE)+VLOOKUP(AF478,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF478,Group,7,FALSE)=\"\",0,ROUND(AJ478-0.04999,1)-AJ478+AM478)","v":0},{"$f":"IF(VLOOKUP(AF478,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF478,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"4.5\" x 9\"",null,"Field",null,null,null,null,null,null,null,null,"5.46 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA479,AG479)","v":17.850000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA479*(1-W479)+0.004999,2)","v":17.850000000000001},null,"",17.850000000000001,0,17.850000000000001,{"$f":"(AG479-AC479)/AG479","v":0},null,11,{"$f":"SUM(AJ479:AL479)+AE479","v":17.850000000000001},null,null,{"$f":"ROUND(AC479/(1-VLOOKUP(AF479,Group,2,FALSE)),2)","v":17.850000000000001},{"$f":"IF(VLOOKUP(AF479,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ479,1)-AJ479,2),Round,2,FALSE)+VLOOKUP(AF479,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF479,Group,7,FALSE)=\"\",0,ROUND(AJ479-0.04999,1)-AJ479+AM479)","v":0},{"$f":"IF(VLOOKUP(AF479,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF479,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"4.5\" x 4.5\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"5.42 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA481,AG481)","v":22.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA481*(1-W481)+0.004999,2)","v":22.35},null,"",22.35,{"$f":"+W481","v":0},{"$f":"+X481","v":22.35},{"$f":"(AG481-AC481)/AG481","v":0},null,11,{"$f":"SUM(AJ481:AL481)+AE481","v":22.35},null,null,{"$f":"ROUND(AC481/(1-VLOOKUP(AF481,Group,2,FALSE)),2)","v":22.35},{"$f":"IF(VLOOKUP(AF481,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ481,1)-AJ481,2),Round,2,FALSE)+VLOOKUP(AF481,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF481,Group,7,FALSE)=\"\",0,ROUND(AJ481-0.04999,1)-AJ481+AM481)","v":0},{"$f":"IF(VLOOKUP(AF481,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF481,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW",null,null,"2.25\" x 9\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA483,AG483)","v":20.399999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA483*(1-W483)+0.004999,2)","v":20.399999999999999},null,"",20.399999999999999,{"$f":"+W483","v":0},{"$f":"+X483","v":20.399999999999999},{"$f":"(AG483-AC483)/AG483","v":0},null,12,{"$f":"SUM(AJ483:AL483)+AE483","v":20.399999999999999},null,null,{"$f":"ROUND(AC483/(1-VLOOKUP(AF483,Group,2,FALSE)),2)","v":20.399999999999999},{"$f":"IF(VLOOKUP(AF483,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ483,1)-AJ483,2),Round,2,FALSE)+VLOOKUP(AF483,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF483,Group,7,FALSE)=\"\",0,ROUND(AJ483-0.04999,1)-AJ483+AM483)","v":0},{"$f":"IF(VLOOKUP(AF483,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF483,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"VALENCIA - Porcelain Floor & Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNVA",null,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:","Chalk          Dove          Natural          White Gloss"]
[]
[null,"Field Tile - MLW",null,"Floor:","6\" x 6\"",null,"Field - Cross",null,null,null,null,null,null,"(24 pcs. Per Carton)",null,"6.14 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA489,AG489)","v":31.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA489*(1-W489)+0.004999,2)","v":31.25},null,"",31.25,{"$f":"+W489","v":0},{"$f":"+X489","v":31.25},{"$f":"(AG489-AC489)/AG489","v":0},null,11,{"$f":"SUM(AJ489:AL489)+AE489","v":31.25},null,null,{"$f":"ROUND(AC489/(1-VLOOKUP(AF489,Group,2,FALSE)),2)","v":31.25},{"$f":"IF(VLOOKUP(AF489,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ489,1)-AJ489,2),Round,2,FALSE)+VLOOKUP(AF489,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF489,Group,7,FALSE)=\"\",0,ROUND(AJ489-0.04999,1)-AJ489+AM489)","v":0},{"$f":"IF(VLOOKUP(AF489,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF489,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"6\" x 6\"",null,"Field - Star",null,null,null,null,null,null,"(16 pcs. Per Carton)",null,"4.10 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA490,AG490)","v":31.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA490*(1-W490)+0.004999,2)","v":31.65},null,"",31.65,{"$f":"+W490","v":0},{"$f":"+X490","v":31.65},{"$f":"(AG490-AC490)/AG490","v":0},null,11,{"$f":"SUM(AJ490:AL490)+AE490","v":31.65},null,null,{"$f":"ROUND(AC490/(1-VLOOKUP(AF490,Group,2,FALSE)),2)","v":31.65},{"$f":"IF(VLOOKUP(AF490,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ490,1)-AJ490,2),Round,2,FALSE)+VLOOKUP(AF490,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF490,Group,7,FALSE)=\"\",0,ROUND(AJ490-0.04999,1)-AJ490+AM490)","v":0},{"$f":"IF(VLOOKUP(AF490,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF490,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,"Wall:","4\" x 8\"",null,"Field - Brick",null,null,null,null,null,null,null,null,"11.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA492,AG492)","v":18.649999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA492*(1-W492)+0.004999,2)","v":18.649999999999999},null,"",18.649999999999999,{"$f":"+W492","v":0},{"$f":"+X492","v":18.649999999999999},{"$f":"(AG492-AC492)/AG492","v":0},null,11,{"$f":"SUM(AJ492:AL492)+AE492","v":18.649999999999999},null,null,{"$f":"ROUND(AC492/(1-VLOOKUP(AF492,Group,2,FALSE)),2)","v":18.649999999999999},{"$f":"IF(VLOOKUP(AF492,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ492,1)-AJ492,2),Round,2,FALSE)+VLOOKUP(AF492,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF492,Group,7,FALSE)=\"\",0,ROUND(AJ492-0.04999,1)-AJ492+AM492)","v":0},{"$f":"IF(VLOOKUP(AF492,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF492,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) For the Cross and Star pattern, order equal amounts of each.  Example:  100 SF total needed, order 50 SF of the Cross and 50 SF of the Star patterns."]
[]
[null,null,"VINTAGE - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNVI",null,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:","Auburn          Blue          Green"]
[]
[null,"Field Tile - MLW",null,null,"2.56\" x 7.87\" x 5/16\"",null,"Field - Flat",null,null,null,null,null,null,null,null,"5.39 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA500,AG500)","v":20.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA500*(1-W500)+0.004999,2)","v":20.45},null,"",20.45,{"$f":"+W500","v":0},{"$f":"+X500","v":20.45},{"$f":"(AG500-AC500)/AG500","v":0},null,11,{"$f":"SUM(AJ500:AL500)+AE500","v":20.45},null,null,{"$f":"ROUND(AC500/(1-VLOOKUP(AF500,Group,2,FALSE)),2)","v":20.45},{"$f":"IF(VLOOKUP(AF500,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ500,1)-AJ500,2),Round,2,FALSE)+VLOOKUP(AF500,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF500,Group,7,FALSE)=\"\",0,ROUND(AJ500-0.04999,1)-AJ500+AM500)","v":0},{"$f":"IF(VLOOKUP(AF500,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF500,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"2.56\" x 7.87\" x 5/16\"",null,"Field (Decorative Pattern)",null,null,null,"Crystal",null,null,null,null,"5.39 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA502,AG502)","v":21.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA502*(1-W502)+0.004999,2)","v":21.4},null,"",21.4,{"$f":"+W502","v":0},{"$f":"+X502","v":21.4},{"$f":"(AG502-AC502)/AG502","v":0},null,11,{"$f":"SUM(AJ502:AL502)+AE502","v":21.4},null,null,{"$f":"ROUND(AC502/(1-VLOOKUP(AF502,Group,2,FALSE)),2)","v":21.4},{"$f":"IF(VLOOKUP(AF502,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ502,1)-AJ502,2),Round,2,FALSE)+VLOOKUP(AF502,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF502,Group,7,FALSE)=\"\",0,ROUND(AJ502-0.04999,1)-AJ502+AM502)","v":0},{"$f":"IF(VLOOKUP(AF502,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF502,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"2.56\" x 7.87\" x 5/16\"",null,"Field (Decorative Pattern)",null,null,null,"Oval",null,null,null,null,"4.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA503,AG503)","v":21.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA503*(1-W503)+0.004999,2)","v":21.45},null,"",21.45,{"$f":"+W503","v":0},{"$f":"+X503","v":21.45},{"$f":"(AG503-AC503)/AG503","v":0},null,11,{"$f":"SUM(AJ503:AL503)+AE503","v":21.45},null,null,{"$f":"ROUND(AC503/(1-VLOOKUP(AF503,Group,2,FALSE)),2)","v":21.45},{"$f":"IF(VLOOKUP(AF503,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ503,1)-AJ503,2),Round,2,FALSE)+VLOOKUP(AF503,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF503,Group,7,FALSE)=\"\",0,ROUND(AJ503-0.04999,1)-AJ503+AM503)","v":0},{"$f":"IF(VLOOKUP(AF503,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF503,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"WOODRIDGE - Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNWO",null,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:","Ash          Cypress          Oak"]
[]
[null,"Field Tile - MLW",null,null,"18\" x 48\" x 5/16\"",null,"Field",null,null,null,null," ",null,null,null,"18.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA509,AG509)","v":17.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA509*(1-W509)+0.004999,2)","v":17.5},null,"",17.5,{"$f":"+W509","v":0},{"$f":"+X509","v":17.5},{"$f":"(AG509-AC509)/AG509","v":0},null,11,{"$f":"SUM(AJ509:AL509)+AE509","v":17.5},null,null,{"$f":"ROUND(AC509/(1-VLOOKUP(AF509,Group,2,FALSE)),2)","v":17.5},{"$f":"IF(VLOOKUP(AF509,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ509,1)-AJ509,2),Round,2,FALSE)+VLOOKUP(AF509,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF509,Group,7,FALSE)=\"\",0,ROUND(AJ509-0.04999,1)-AJ509+AM509)","v":0},{"$f":"IF(VLOOKUP(AF509,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF509,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"ZAHARA - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNZA",null,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:","Ice          Mist          Pistachio          Twilight          White"]
[]
[null,"Field Tile - MLW",null,null,"5.5\" x 8\" x 5/16\"",null,"Field - Arabesque",null,null,null,null,null,null,null,null,"5.51 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA515,AG515)","v":31.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA515*(1-W515)+0.004999,2)","v":31.3},null,"new",31.3,{"$f":"+W515","v":0},{"$f":"+X515","v":31.3},{"$f":"(AG515-AC515)/AG515","v":0},null,11,{"$f":"SUM(AJ515:AL515)+AE515","v":31.3},null,null,{"$f":"ROUND(AC515/(1-VLOOKUP(AF515,Group,2,FALSE)),2)","v":31.3},{"$f":"IF(VLOOKUP(AF515,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ515,1)-AJ515,2),Round,2,FALSE)+VLOOKUP(AF515,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF515,Group,7,FALSE)=\"\",0,ROUND(AJ515-0.04999,1)-AJ515+AM515)","v":0},{"$f":"IF(VLOOKUP(AF515,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF515,Group,7,FALSE))","v":""},null,"X"]
[]
[]
[null,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
[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."]
["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,-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":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page"]
[]
[]
["Product","Direct Website Link"]

{"sheet":"Changes","index":4,"n_rows":132,"n_cols":3,"rows_kept":132,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
["2021-04-01","Artista","Porcelain"]
["2021-04-01","Brique","Porcelain"]
["2021-04-01","Cadence","Porcelain"]
["2021-04-01","Cambridge","Ceramic"]
["2021-04-01","Camden","Ceramic"]
["2021-04-01","Charleston","Porcelain"]
["2021-04-01","Cotto Brick","Porcelain"]
["2021-04-01","Empire","Ceramic"]
["2021-04-01","Heavy Metal","Porcelain"]
["2021-04-01","Metro","Ceramic"]
["2021-04-01","Nola","Porcelain"]
["2021-04-01","Piazza","Ceramic"]
["2021-04-01","Piccadilly","Recycled Glass"]
["2021-04-01","Quadrant","Ceramic"]
["2021-04-01","Rainforest","Ceramic"]
["2021-04-01","Shaftwood","Porcelain"]
["2021-04-01","Slate","Natural Stone"]
["2021-04-01","Stella","Porcelain"]
["2021-04-01","Urban","Porcelain"]
["2021-10-01","Alloy","Porcelain Field Tile and Mosaics."]
["2021-10-01","Andalucia","Porcelain 8\" x 8\" Decorative Field Tile."]
["2021-10-01","Cava","Porcelain 6\" x 23.6\" Wall Panels."]
["2021-10-01","Chelsea","Porcelain 2\" x 10\" Field Tile."]
["2021-10-01","Contempo","Ceramic 2\" x 4\" Field Tile."]
["2021-10-01","Cubist","Porcelain 4\" x 4\" on 13\" x 13\" Wall Panels."]
["2021-10-01","Etruscan","Porcelain 10\" x 10\" Field and Decorative Field Tile."]
["2021-10-01","Heirloom","Porcelain."]
["2021-10-01","Kingston Wood","Porcelain."]
["2021-10-01","Limestone","Natural Stone."]
["2021-10-01","Mantra","Porcelain."]
["2021-10-01","Marble","Natural Stone."]
["2021-10-01","Marrakesh","Porcelain."]
["2021-10-01","Nola Black","Porcelain."]
["2021-10-01","Nomad","Porcelain."]
["2021-10-01","Ocean","Ceramic."]
["2021-10-01","Onyx","Porcelain."]
["2021-10-01","Pacific","Porcelain."]
["2021-10-01","Pastiche","Ceramic."]
["2021-10-01","Quarry","Porcelain."]
["2022-02-28","Chiclet","Porcelain Floor & Wall Mosaics."]
["2022-02-28","Moroccan","Porcelain."]
["2022-02-28","Plume","Ceramic."]
["2022-02-28","Petrified Wood","Porcelain."]
["2022-02-28","Pyramid","Ceramic."]
["2022-02-28","Sedona","Ceramic."]
["2022-05-11","Mayfair","Ceramic."]
["2023-07-12","Gatsby","Porcelain."]
["2023-07-12","Gesso","Porcelain."]
["2023-07-12","Heirloom","Porcelain."]
["2023-07-12","Limerick","Porcelain."]
["2023-07-12","Malibu","Porcelain."]
["2023-07-12","Momentum","Ceramic."]
["2023-07-12","Stone Classics","Porcelain."]
["2023-07-12","Terracotta","Porcelain."]
["2023-07-12","Valencia","Porcelain Floor & Ceramic Wall."]
["2023-07-12","Woodridge","Ceramic."]
["2023-11-03","Hampstead","Porcelain."]
["2023-11-03","Hudson Brick","Porcelain."]
["2023-11-03","Normandy","Porcelain."]
["2023-11-03","Portofino","Porcelain."]
["2024-10-10","Atlanta Brick","Porcelain Floor & Wall Tile."]
["2024-10-10","Grand Canyon","Ceramic Wall Tile."]
["2024-10-10","Havana","Ceramic Wall Tile."]
["2024-10-10","Italia","Porcelain Floor & Wall Tile."]
["2024-10-10","Marmol","Porcelain Floor & Wall Tile."]
["2024-10-10","Vintage","Ceramic Wall Tile."]
["2025-04-02","Caliza","Ceramic."]
["2025-04-02","Gibraltar","Porcelain."]
["2025-04-02","Italia","Colors Florence Beige, Florence Gray, Milan Beige, Milan Gray and Venice added."]
["2025-04-02","Slate","Versailles Pattern added to color Black Blizzard only."]
["2025-04-02","Vintage","2.56\" x 7.87\" x 5/16\" Flat Field Tile format added."]
["2025-09-04","Luxor","Ceramic Wall Tile."]
["2025-09-04","Milton","Ceramic Wall Tile."]
["2025-09-04","Milton Ridge","Ceramic Wall Tile."]
["2025-09-04","Zahara","Porcelain Floor & Wall"]
["2025-12-10","Barcelona","Porcelain Floor & Wall."]
["2025-12-10","Nami","Porcelain Wall."]
["2025-12-10","Tarragona","Porcelain Floor & Wall."]
[]
[]
[]
["Discontinued Products"]
["2022-01-27","Cadence","Color Coal Black 7\" x 8\" Hex Field Tile, 4.3\" x 4.3\" Lines, 8.8\" x 8.8\" Rows, 3\" x 17.7\" Tread and 7\" x 8\" Hex Multi Decorative Field Tile only.  Color Sky Blue 3\" x 17.7\" Field Tile  and 8.8\" x 8.8\" Rows Decorative Field Tile only.  All formats in color Storm Gray.  Color Tarnished White 4.3\" x 4.3\" Snakeskin Decorative Field Tile only."]
["2022-01-27","Cambridge","3\" x 12\" Picket Field Tile only in all colors."]
["2022-01-27","Contempo","Entire Series."]
["2022-01-27","Cubist","Entire Series."]
["2022-01-27","Etruscan","Entire Series."]
["2022-01-27","Heavy Metal","Entire Series."]
["2022-01-27","Shaftwood","Entire Series."]
["2022-02-04","Brique","Entire Series."]
["2022-02-04","Heirloom","Entire Series."]
["2022-03-25","Cambridge","Entire Series."]
["2022-03-25","Marble","All formats in color Hawthorne White (Honed) only."]
["2023-02-15","Mantra","Entire Series."]
["2023-02-15","Ocean","Entire Series."]
["2023-06-09","Alloy","3\" Hexagon Mosaic only in all colors."]
["2023-06-09","Limestone","3\" Hexagon Mosaic only in all colors."]
["2023-06-09","Marble","3\" Hexagon Mosaic only in all colors."]
["2023-06-09","Slate","3\" Hexagon Mosaic only in all colors."]
["2023-11-03","Marble","4\" x 12\" Field Tile format only in color White Venatino in both the Honed and the Polished surfaces."]
["2024-02-15","Cadence","Color Coal Black 4.3\" x 8.8\", 3\" x 17.7\" and 8.8\" x 17.7\" Field Tile formats only.  All formats in color Sky Blue.  Color Tarnished White 7\" x 8\" Hex Field Tile format, 3\" x 17.7\" Tread and 7\" x 8\" Hex Multi Decorative Patterns only. "]
["2024-02-15","Camden","4\" x 12\" x 5/16\" Decorative Mix in colors Pearl and White."]
["2024-02-15","Charleston","Colors Montagu and Wentworth only in all formats."]
["2024-02-15","Marrakesh","Entire Series."]
["2024-02-15","Nola","8\" x 8\" x 1/4\" Field Tile format only in colors Gray and White."]
["2024-02-15","Petrified Wood","Entire Series."]
["2024-07-17","Heirloom","Entire Series."]
["2024-11-06","Piccadilly","Due to ongoing issues with the consistency of the mounting of this hexagon mosaic, we will be pulling it from the market."]
["2024-12-02","Mayfair","Entire Series."]
["2025-01-28","Cadence","All formats in color Tarnished White only."]
["2025-01-28","Camden","Entire Series."]
["2025-01-28","Limestone","3\" x 8\", 6\" x 12\", 12\" x 12\" and 12\" x 24\" Field Tile formats only in colors Faro (Honed), Orval (Honed) and St. Bernardus (Honed). "]
["2025-01-28","Marble","3\" x 8\", 6\" x 12\", 12\" x 12\", 12\" x 24\" and 18\" x 36\" Field Tile formats only in color White Venatino (Honed)."]
["2025-01-28","Metro","Entire Series."]
["2025-01-28","Pastiche","Entire Series."]
["2025-01-28","Pyramid","Entire Series."]
["2025-04-02","Limestone","4\" x 12\" and 6\" x 24\" Field Tile, 2\" x 2\" Mosaic, Small Herringbone Mosaic, 12\" Chair Rail and 5/8\" x 12\" Pencil formats only in colors Faro (Honed), Orval (Honed) and St. Bernardus (Honed). "]
["2025-04-02","Marble","Color White Venatino (Honed) in all formats and finishes."]
["2025-09-04","Cava","Entire Series."]
["2025-09-04","Empire","Entire Series."]
["2025-10-06","Rainforest","Entire Series."]
["2025-12-10","Cadence","Entire Series.  (Discontinued by Manufacturer)"]
["2025-12-10","Onyx","Entire Series.  (Discontinued by Manufacturer)"]
[]
[]
[]
["Changes"]
["2025-12-10","Quadrant","Packaging is changing from 11.00 SF/CTN to 5.50 SF/CTN as inventory with old packaging is depleted."]