{"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":12,"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","8/1/23 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"B"}]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"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,null,null,null," "]
[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 - 8/1/23 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[1,null,"Alloy",null,"Porcelain",null,4,null,"Moroccan",null,"Porcelain"]
[1,null,"Andalucia",null,"Porcelain",null,4,null,"Nola",null,"Porcelain"]
[1,null,"Artista",null,"Porcelain",null,4,null,"Nola Black",null,"Porcelain"]
[1,null,"Cadence",null,"Porcelain",null,4,null,"Nomad",null,"Porcelain"]
[1,null,"Camden",null,"Ceramic",null,4,null,"Normandy",null,"Porcelain"]
[1,null,"Cava",null,"Porcelain",null,4,null,"Onyx",null,"Porcelain"]
[1,null,"Charleston",null,"Porcelain",null,4,null,"Pacific",null,"Porcelain"]
[1,null,"Chelsea",null,"Porcelain",null,4,null,"Pastiche",null,"Ceramic"]
[2,null,"Chiclet",null,"Porcelain",null,4,null,"Petrified Wood (Disc. 2/15/24)",null,"Porcelain"]
[2,null,"Cotto Brick",null,"Porcelain",null,5,null,"Piazza",null,"Ceramic"]
[2,null,"Empire",null,"Ceramic",null,5,null,"Piccadilly",null,"Recycled Glass"]
[2,null,"Gatsby",null,"Porcelain",null,5,null,"Plume",null,"Ceramic"]
[2,null,"Gesso",null,"Porcelain",null,5,null,"Portofino",null,"Porcelain"]
[2,null,"Hampstead",null,"Porcelain",null,5,null,"Pyramid",null,"Ceramic"]
[2,null,"Heirloom (Disc. 7/17/24)",null,"Porcelain",null,5,null,"Quadrant",null,"Ceramic"]
[2,null,"Hudson Brick",null,"Porcelain",null,5,null,"Quarry",null,"Porcelain"]
[2,null,"Kingston Wood",null,"Porcelain",null,5,null,"Rainforest",null,"Ceramic"]
[2,null,"Limerick",null,"Ceramic",null,5,null,"Sedona",null,"Ceramic"]
["2-3",null,"Limestone",null,"Natural Stone",null,"5-6",null,"Slate",null,"Natural Stone"]
[3,null,"Malibu",null,"Porcelain",null,6,null,"Stella",null,"Porcelain"]
[3,null,"Marble",null,"Natural Stone",null,6,null,"Stone Classics",null,"Porcelain"]
[3,null,"Marrakesh (Disc. 2/15/24)",null,"Porcelain",null,6,null,"Terracotta",null,"Porcelain"]
[3,null,"Mayfair",null,"Ceramic",null,6,null,"Urban",null,"Porcelain"]
[4,null,"Metro",null,"Ceramic",null,6,null,"Valencia",null,"Porcelain & Ceramic"]
[4,null,"Momentum",null,"Ceramic",null,6,null,"Woodridge",null,"Ceramic"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":600,"n_cols":41,"rows_kept":600,"cut":false,"hidden":false,"merged":[[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],[586,2,586,19],[20,13,21,19],[589,3,589,4],[24,2,24,19],[23,14,23,15],[584,2,584,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":"8/1/23 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-07-17"},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",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":18.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":18.8},null,"",18.8,{"$f":"+W31","v":0},{"$f":"+X31","v":18.8},{"$f":"(AG31-AC31)/AG31","v":0},null,11,{"$f":"SUM(AJ31:AL31)+AE31","v":18.8},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":18.8},{"$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":56.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA33*(1-W33)+0.004999,2)","v":56.55},null,"",56.55,{"$f":"+W33","v":0},{"$f":"+X33","v":56.55},{"$f":"(AG33-AC33)/AG33","v":0},null,13,{"$f":"SUM(AJ33:AL33)+AE33","v":56.55},null,null,{"$f":"ROUND(AC33/(1-VLOOKUP(AF33,Group,2,FALSE)),2)","v":56.55},{"$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",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          Marabella          Seville"]
[]
[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\",AA41,AG41)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA41*(1-W41)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W41","v":0},{"$f":"+X41","v":12.75},{"$f":"(AG41-AC41)/AG41","v":0},null,11,{"$f":"SUM(AJ41:AL41)+AE41","v":12.75},null,null,{"$f":"ROUND(AC41/(1-VLOOKUP(AF41,Group,2,FALSE)),2)","v":12.75},{"$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,"ARTISTA - Porcelain",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",null,null,null," ",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA48,AG48)","v":13.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA48*(1-W48)+0.004999,2)","v":13.05},null,"",13.05,{"$f":"+W48","v":0},{"$f":"+X48","v":13.05},{"$f":"(AG48-AC48)/AG48","v":0},null,11,{"$f":"SUM(AJ48:AL48)+AE48","v":13.05},null,null,{"$f":"ROUND(AC48/(1-VLOOKUP(AF48,Group,2,FALSE)),2)","v":13.05},{"$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,"CADENCE - Porcelain",null,null,null,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,"4.3\" x 8.8\"",null,"Field",null,null,null,null,"    Discontinued 2/15/24",null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA54,AG54)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA54*(1-W54)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W54","v":0},15.3,{"$f":"(AG54-AC54)/AG54","v":0},null,11,{"$f":"SUM(AJ54:AL54)+AE54","v":15.3},null,null,{"$f":"ROUND(AC54/(1-VLOOKUP(AF54,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF54,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ54,1)-AJ54,2),Round,2,FALSE)+VLOOKUP(AF54,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF54,Group,7,FALSE)=\"\",0,ROUND(AJ54-0.04999,1)-AJ54+AM54)","v":0},{"$f":"IF(VLOOKUP(AF54,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF54,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"3\" x 17.7\"",null,"Field",null,null,null,null,"    Discontinued 2/15/24",null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA55,AG55)","v":19.350000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA55*(1-W55)+0.004999,2)","v":19.350000000000001},null,"",19.350000000000001,0,19.350000000000001,{"$f":"(AG55-AC55)/AG55","v":0},null,11,{"$f":"SUM(AJ55:AL55)+AE55","v":19.350000000000001},null,null,{"$f":"ROUND(AC55/(1-VLOOKUP(AF55,Group,2,FALSE)),2)","v":19.350000000000001},{"$f":"IF(VLOOKUP(AF55,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ55,1)-AJ55,2),Round,2,FALSE)+VLOOKUP(AF55,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF55,Group,7,FALSE)=\"\",0,ROUND(AJ55-0.04999,1)-AJ55+AM55)","v":0},{"$f":"IF(VLOOKUP(AF55,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF55,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8.8\" x 17.7\"",null,"Field",null,null,null,null,"    Discontinued 2/15/24",null,null,null,"10.87 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA56,AG56)","v":13.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":13.75},null,"",13.75,0,13.75,{"$f":"(AG56-AC56)/AG56","v":0},null,11,{"$f":"SUM(AJ56:AL56)+AE56","v":13.75},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":13.75},{"$f":"IF(VLOOKUP(AF56,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ56,1)-AJ56,2),Round,2,FALSE)+VLOOKUP(AF56,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",0,ROUND(AJ56-0.04999,1)-AJ56+AM56)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF56,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Decorative Patterns:",null,null,null,null,null,null,null," "," "]
[]
[null,"Field Tile - MLW",null,null,"8.8\" x 8.8\"",null,"Field",null,null,"Alley",null,null,null,null,null,"10.87 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA60,AG60)","v":14.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA60*(1-W60)+0.004999,2)","v":14.3},null,"",14.3,{"$f":"+W60","v":0},{"$f":"+X60","v":14.3},{"$f":"(AG60-AC60)/AG60","v":0},null,11,{"$f":"SUM(AJ60:AL60)+AE60","v":14.3},null,null,{"$f":"ROUND(AC60/(1-VLOOKUP(AF60,Group,2,FALSE)),2)","v":14.3},{"$f":"IF(VLOOKUP(AF60,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ60,1)-AJ60,2),Round,2,FALSE)+VLOOKUP(AF60,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF60,Group,7,FALSE)=\"\",0,ROUND(AJ60-0.04999,1)-AJ60+AM60)","v":0},{"$f":"IF(VLOOKUP(AF60,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF60,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Color:","Sky Blue",null,null,null,null,null,null,"    Discontinued 2/15/24"]
[]
[null,"Field Tile - MLW",null,null,"4.3\" x 8.8\"",null,"Field",null,null,null,null,"    Discontinued 2/15/24",null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA64,AG64)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W64","v":0},15.3,{"$f":"(AG64-AC64)/AG64","v":0},null,11,{"$f":"SUM(AJ64:AL64)+AE64","v":15.3},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF64,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ64,1)-AJ64,2),Round,2,FALSE)+VLOOKUP(AF64,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",0,ROUND(AJ64-0.04999,1)-AJ64+AM64)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF64,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8.8\" x 17.7\"",null,"Field",null,null,null,null,"    Discontinued 2/15/24",null,null,null,"10.87 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":13.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":13.75},null,"",13.75,0,13.75,{"$f":"(AG65-AC65)/AG65","v":0},null,11,{"$f":"SUM(AJ65:AL65)+AE65","v":13.75},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":13.75},{"$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,"Field Tile - MLW",null,null,"7\" x 8\" Hex",null,"Field",null,null,null,null,"    Discontinued 2/15/24",null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":17.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA66*(1-W66)+0.004999,2)","v":17.3},null,"",17.3,0,17.3,{"$f":"(AG66-AC66)/AG66","v":0},null,11,{"$f":"SUM(AJ66:AL66)+AE66","v":17.3},null,null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":17.3},{"$f":"IF(VLOOKUP(AF66,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ66,1)-AJ66,2),Round,2,FALSE)+VLOOKUP(AF66,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",0,ROUND(AJ66-0.04999,1)-AJ66+AM66)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF66,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Decorative Patterns:",null,null,null,null,null,null," ",null," "]
[]
[null,"Field Tile - MLW",null,null,"4.3\" x 4.3\"",null,"Field",null,null,"Lines",null,"    Discontinued 2/15/24",null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA70,AG70)","v":16.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA70*(1-W70)+0.004999,2)","v":16.55},null,"",16.55,{"$f":"+W70","v":0},{"$f":"+X70","v":16.55},{"$f":"(AG70-AC70)/AG70","v":0},null,11,{"$f":"SUM(AJ70:AL70)+AE70","v":16.55},null,null,{"$f":"ROUND(AC70/(1-VLOOKUP(AF70,Group,2,FALSE)),2)","v":16.55},{"$f":"IF(VLOOKUP(AF70,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ70,1)-AJ70,2),Round,2,FALSE)+VLOOKUP(AF70,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF70,Group,7,FALSE)=\"\",0,ROUND(AJ70-0.04999,1)-AJ70+AM70)","v":0},{"$f":"IF(VLOOKUP(AF70,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF70,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8.8\" x 8.8\"",null,"Field",null,null,"Oragami",null,"    Discontinued 2/15/24",null,null,null,"10.87 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA71,AG71)","v":14.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":14.3},null,"",14.3,{"$f":"+W71","v":0},{"$f":"+X71","v":14.3},{"$f":"(AG71-AC71)/AG71","v":0},null,11,{"$f":"SUM(AJ71:AL71)+AE71","v":14.3},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":14.3},{"$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,null,"Color:","Tarnished White"]
[]
[null,"Field Tile - MLW",null,null,"4.3\" x 8.8\"",null,"Field",null,null,null,null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA75,AG75)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA75*(1-W75)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W75","v":0},15.3,{"$f":"(AG75-AC75)/AG75","v":0},null,11,{"$f":"SUM(AJ75:AL75)+AE75","v":15.3},null,null,{"$f":"ROUND(AC75/(1-VLOOKUP(AF75,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF75,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ75,1)-AJ75,2),Round,2,FALSE)+VLOOKUP(AF75,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF75,Group,7,FALSE)=\"\",0,ROUND(AJ75-0.04999,1)-AJ75+AM75)","v":0},{"$f":"IF(VLOOKUP(AF75,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF75,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"3\" x 17.7\"",null,"Field",null,null,null,null,null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA76,AG76)","v":19.350000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":19.350000000000001},null,"",19.350000000000001,0,19.350000000000001,{"$f":"(AG76-AC76)/AG76","v":0},null,11,{"$f":"SUM(AJ76:AL76)+AE76","v":19.350000000000001},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":19.350000000000001},{"$f":"IF(VLOOKUP(AF76,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ76,1)-AJ76,2),Round,2,FALSE)+VLOOKUP(AF76,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",0,ROUND(AJ76-0.04999,1)-AJ76+AM76)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF76,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8.8\" x 17.7\"",null,"Field",null,null,null,null,null,null,null,null,"10.87 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA77,AG77)","v":13.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":13.75},null,"",13.75,0,13.75,{"$f":"(AG77-AC77)/AG77","v":0},null,11,{"$f":"SUM(AJ77:AL77)+AE77","v":13.75},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":13.75},{"$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,"7\" x 8\" Hex",null,"Field",null,null,null,null,"    Discontinued 2/15/24",null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA78,AG78)","v":17.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":17.3},null,"",17.3,0,17.3,{"$f":"(AG78-AC78)/AG78","v":0},null,11,{"$f":"SUM(AJ78:AL78)+AE78","v":17.3},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":17.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,"Decorative Patterns:"]
[]
[null,"Field Tile - MLW",null,null,"4.3\" x 4.3\"",null,"Field",null,null,"Lanes",null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA82,AG82)","v":16.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":16.55},null,"",16.55,{"$f":"+W82","v":0},16.55,{"$f":"(AG82-AC82)/AG82","v":0},null,11,{"$f":"SUM(AJ82:AL82)+AE82","v":16.55},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":16.55},{"$f":"IF(VLOOKUP(AF82,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ82,1)-AJ82,2),Round,2,FALSE)+VLOOKUP(AF82,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",0,ROUND(AJ82-0.04999,1)-AJ82+AM82)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF82,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"4.3\" x 8.8\"",null,"Field",null,null,"Canvas",null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA83,AG83)","v":15.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA83*(1-W83)+0.004999,2)","v":15.9},null,"",15.9,0,15.9,{"$f":"(AG83-AC83)/AG83","v":0},null,11,{"$f":"SUM(AJ83:AL83)+AE83","v":15.9},null,null,{"$f":"ROUND(AC83/(1-VLOOKUP(AF83,Group,2,FALSE)),2)","v":15.9},{"$f":"IF(VLOOKUP(AF83,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ83,1)-AJ83,2),Round,2,FALSE)+VLOOKUP(AF83,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF83,Group,7,FALSE)=\"\",0,ROUND(AJ83-0.04999,1)-AJ83+AM83)","v":0},{"$f":"IF(VLOOKUP(AF83,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF83,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"3\" x 17.7\"",null,"Field",null,null,"Tread",null,"    Discontinued 2/15/24",null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA84,AG84)","v":19.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":19.8},null,"",19.8,0,19.8,{"$f":"(AG84-AC84)/AG84","v":0},null,11,{"$f":"SUM(AJ84:AL84)+AE84","v":19.8},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":19.8},{"$f":"IF(VLOOKUP(AF84,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ84,1)-AJ84,2),Round,2,FALSE)+VLOOKUP(AF84,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",0,ROUND(AJ84-0.04999,1)-AJ84+AM84)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF84,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"7\" x 8\" Hex",null,"Field",null,null,"Multi",null,"    Discontinued 2/15/24",null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA85,AG85)","v":16.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA85*(1-W85)+0.004999,2)","v":16.75},null,"",16.75,0,16.75,{"$f":"(AG85-AC85)/AG85","v":0},null,11,{"$f":"SUM(AJ85:AL85)+AE85","v":16.75},null,null,{"$f":"ROUND(AC85/(1-VLOOKUP(AF85,Group,2,FALSE)),2)","v":16.75},{"$f":"IF(VLOOKUP(AF85,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ85,1)-AJ85,2),Round,2,FALSE)+VLOOKUP(AF85,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",0,ROUND(AJ85-0.04999,1)-AJ85+AM85)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF85,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CAMDEN - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNCD",null,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",null,"Gray",null,"        Pearl",null,"    White"]
[null,null,null,null,"Crème",null,"Olive",null,"        Tea"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 12\" x 1/4\"",null,"Field",null,null,null,null,null,null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA92,AG92)","v":11.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":11.05},null,"",11.05,{"$f":"+W92","v":0},{"$f":"+X92","v":11.05},{"$f":"(AG92-AC92)/AG92","v":0},null,11,{"$f":"SUM(AJ92:AL92)+AE92","v":11.05},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":11.05},{"$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,"Decos - MLW",null,null,"4\" x 12\" x 5/16\"",null,"Field",null,null,"Decorative Mix",null,"    Discontinued 2/15/24",null,null,null,"10.98 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA94,AG94)","v":12.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA94*(1-W94)+0.004999,2)","v":12.1},null,"",12.1,{"$f":"+W94","v":0},{"$f":"+X94","v":12.1},{"$f":"(AG94-AC94)/AG94","v":0},null,13,{"$f":"SUM(AJ94:AL94)+AE94","v":12.1},null,null,{"$f":"ROUND(AC94/(1-VLOOKUP(AF94,Group,2,FALSE)),2)","v":12.1},{"$f":"IF(VLOOKUP(AF94,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ94,1)-AJ94,2),Round,2,FALSE)+VLOOKUP(AF94,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",0,ROUND(AJ94-0.04999,1)-AJ94+AM94)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF94,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA96,AG96)","v":9.1999999999999993},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA96*(1-W96)+0.004999,2)","v":9.1999999999999993},null,"",9.1999999999999993,{"$f":"+W96","v":0},{"$f":"+X96","v":9.1999999999999993},{"$f":"(AG96-AC96)/AG96","v":0},null,12,{"$f":"SUM(AJ96:AL96)+AE96","v":9.1999999999999993},null,null,{"$f":"ROUND(AC96/(1-VLOOKUP(AF96,Group,2,FALSE)),2)","v":9.1999999999999993},{"$f":"IF(VLOOKUP(AF96,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ96,1)-AJ96,2),Round,2,FALSE)+VLOOKUP(AF96,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",0,ROUND(AJ96-0.04999,1)-AJ96+AM96)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF96,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Available in colors Pearl and White only."]
[]
[null,null,"CAVA - Porcelain",null,null,null,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\",AA104,AG104)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA104*(1-W104)+0.004999,2)","v":13.5},null,"",13.5,{"$f":"+W104","v":0},{"$f":"+X104","v":13.5},{"$f":"(AG104-AC104)/AG104","v":0},null,11,{"$f":"SUM(AJ104:AL104)+AE104","v":13.5},null,null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF104,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ104,1)-AJ104,2),Round,2,FALSE)+VLOOKUP(AF104,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",0,ROUND(AJ104-0.04999,1)-AJ104+AM104)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF104,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CHARLESTON - Porcelain",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,"Colors:","Cromwell            (Colors Montagu and Wentworth - Discontinued 2/15/24)"]
[]
[null,"Field Tile - MLW",null,null,"13\" x 13\" x 1/4\"",null,"Field",null,null,null,null,null,null,null,null,"10.79 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA110,AG110)","v":13.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA110*(1-W110)+0.004999,2)","v":13.9},null,"",13.9,{"$f":"+W110","v":0},{"$f":"+X110","v":13.9},{"$f":"(AG110-AC110)/AG110","v":0},null,11,{"$f":"SUM(AJ110:AL110)+AE110","v":13.9},null,null,{"$f":"ROUND(AC110/(1-VLOOKUP(AF110,Group,2,FALSE)),2)","v":13.9},{"$f":"IF(VLOOKUP(AF110,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ110,1)-AJ110,2),Round,2,FALSE)+VLOOKUP(AF110,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",0,ROUND(AJ110-0.04999,1)-AJ110+AM110)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF110,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CHELSEA - Porcelain",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\",AA117,AG117)","v":18.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA117*(1-W117)+0.004999,2)","v":18.05},null,"",18.05,{"$f":"+W117","v":0},{"$f":"+X117","v":18.05},{"$f":"(AG117-AC117)/AG117","v":0},null,11,{"$f":"SUM(AJ117:AL117)+AE117","v":18.05},null,null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":18.05},{"$f":"IF(VLOOKUP(AF117,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ117,1)-AJ117,2),Round,2,FALSE)+VLOOKUP(AF117,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",0,ROUND(AJ117-0.04999,1)-AJ117+AM117)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF117,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA119,AG119)","v":24.15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA119*(1-W119)+0.004999,2)","v":24.15},null,"",24.15,{"$f":"+W119","v":0},{"$f":"+X119","v":24.15},{"$f":"(AG119-AC119)/AG119","v":0},null,12,{"$f":"SUM(AJ119:AL119)+AE119","v":24.15},null,null,{"$f":"ROUND(AC119/(1-VLOOKUP(AF119,Group,2,FALSE)),2)","v":24.15},{"$f":"IF(VLOOKUP(AF119,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ119,1)-AJ119,2),Round,2,FALSE)+VLOOKUP(AF119,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",0,ROUND(AJ119-0.04999,1)-AJ119+AM119)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF119,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CHICLET - Porcelain",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\",AA126,AG126)","v":27.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA126*(1-W126)+0.004999,2)","v":27.6},null,"",27.6,{"$f":"+W126","v":0},{"$f":"+X126","v":27.6},{"$f":"(AG126-AC126)/AG126","v":0},null,13,{"$f":"SUM(AJ126:AL126)+AE126","v":27.6},null,null,{"$f":"ROUND(AC126/(1-VLOOKUP(AF126,Group,2,FALSE)),2)","v":27.6},{"$f":"IF(VLOOKUP(AF126,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ126,1)-AJ126,2),Round,2,FALSE)+VLOOKUP(AF126,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",0,ROUND(AJ126-0.04999,1)-AJ126+AM126)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF126,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"COTTO BRICK - Porcelain",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\",AA132,AG132)","v":16.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA132*(1-W132)+0.004999,2)","v":16.45},null,"",16.45,{"$f":"+W132","v":0},{"$f":"+X132","v":16.45},{"$f":"(AG132-AC132)/AG132","v":0},null,11,{"$f":"SUM(AJ132:AL132)+AE132","v":16.45},null,null,{"$f":"ROUND(AC132/(1-VLOOKUP(AF132,Group,2,FALSE)),2)","v":16.45},{"$f":"IF(VLOOKUP(AF132,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ132,1)-AJ132,2),Round,2,FALSE)+VLOOKUP(AF132,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",0,ROUND(AJ132-0.04999,1)-AJ132+AM132)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF132,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\",AA133,AG133)","v":16.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA133*(1-W133)+0.004999,2)","v":16.45},null,"",16.45,{"$f":"+W133","v":0},{"$f":"+X133","v":16.45},{"$f":"(AG133-AC133)/AG133","v":0},null,11,{"$f":"SUM(AJ133:AL133)+AE133","v":16.45},null,null,{"$f":"ROUND(AC133/(1-VLOOKUP(AF133,Group,2,FALSE)),2)","v":16.45},{"$f":"IF(VLOOKUP(AF133,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ133,1)-AJ133,2),Round,2,FALSE)+VLOOKUP(AF133,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",0,ROUND(AJ133-0.04999,1)-AJ133+AM133)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF133,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"EMPIRE - Ceramic",null,null,null,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",null,null,null,null,null,null,null,null,"9.60 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA139,AG139)","v":15.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA139*(1-W139)+0.004999,2)","v":15.95},null,"",15.95,{"$f":"+W139","v":0},{"$f":"+X139","v":15.95},{"$f":"(AG139-AC139)/AG139","v":0},null,11,{"$f":"SUM(AJ139:AL139)+AE139","v":15.95},null,null,{"$f":"ROUND(AC139/(1-VLOOKUP(AF139,Group,2,FALSE)),2)","v":15.95},{"$f":"IF(VLOOKUP(AF139,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ139,1)-AJ139,2),Round,2,FALSE)+VLOOKUP(AF139,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",0,ROUND(AJ139-0.04999,1)-AJ139+AM139)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF139,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",null,null,null,null,null,null,null,null,"9.60 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA143,AG143)","v":17.399999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA143*(1-W143)+0.004999,2)","v":17.399999999999999},null,"",17.399999999999999,{"$f":"+W143","v":0},{"$f":"+X143","v":17.399999999999999},{"$f":"(AG143-AC143)/AG143","v":0},null,11,{"$f":"SUM(AJ143:AL143)+AE143","v":17.399999999999999},null,null,{"$f":"ROUND(AC143/(1-VLOOKUP(AF143,Group,2,FALSE)),2)","v":17.399999999999999},{"$f":"IF(VLOOKUP(AF143,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ143,1)-AJ143,2),Round,2,FALSE)+VLOOKUP(AF143,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",0,ROUND(AJ143-0.04999,1)-AJ143+AM143)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF143,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"GATSBY - Porcelain",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\",AA147,AG147)","v":26.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA147*(1-W147)+0.004999,2)","v":26.85},null,"",26.85,{"$f":"+W147","v":0},{"$f":"+X147","v":26.85},{"$f":"(AG147-AC147)/AG147","v":0},null,11,{"$f":"SUM(AJ147:AL147)+AE147","v":26.85},null,null,{"$f":"ROUND(AC147/(1-VLOOKUP(AF147,Group,2,FALSE)),2)","v":26.85},{"$f":"IF(VLOOKUP(AF147,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ147,1)-AJ147,2),Round,2,FALSE)+VLOOKUP(AF147,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,7,FALSE)=\"\",0,ROUND(AJ147-0.04999,1)-AJ147+AM147)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF147,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"GESSO - Porcelain",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,null,"8\" x 8\" x 1/4\"",null,"Field",null,null,"Natural",null,null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA153,AG153)","v":14.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA153*(1-W153)+0.004999,2)","v":14.7},null,"",14.7,{"$f":"+W153","v":0},{"$f":"+X153","v":14.7},{"$f":"(AG153-AC153)/AG153","v":0},null,11,{"$f":"SUM(AJ153:AL153)+AE153","v":14.7},null,null,{"$f":"ROUND(AC153/(1-VLOOKUP(AF153,Group,2,FALSE)),2)","v":14.7},{"$f":"IF(VLOOKUP(AF153,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ153,1)-AJ153,2),Round,2,FALSE)+VLOOKUP(AF153,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",0,ROUND(AJ153-0.04999,1)-AJ153+AM153)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF153,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Decorative Patterns:"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field",null,null,"Diagonal",null,null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA157,AG157)","v":15.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":15.25},null,"",15.25,{"$f":"+W157","v":0},{"$f":"+X157","v":15.25},{"$f":"(AG157-AC157)/AG157","v":0},null,11,{"$f":"SUM(AJ157:AL157)+AE157","v":15.25},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":15.25},{"$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",null,null,"Round",null,null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA158,AG158)","v":15.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA158*(1-W158)+0.004999,2)","v":15.25},null,"",15.25,{"$f":"+W158","v":0},{"$f":"+X158","v":15.25},{"$f":"(AG158-AC158)/AG158","v":0},null,11,{"$f":"SUM(AJ158:AL158)+AE158","v":15.25},null,null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":15.25},{"$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,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field",null,null,"Straight",null,null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA159,AG159)","v":15.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA159*(1-W159)+0.004999,2)","v":15.25},null,"",15.25,{"$f":"+W159","v":0},{"$f":"+X159","v":15.25},{"$f":"(AG159-AC159)/AG159","v":0},null,11,{"$f":"SUM(AJ159:AL159)+AE159","v":15.25},null,null,{"$f":"ROUND(AC159/(1-VLOOKUP(AF159,Group,2,FALSE)),2)","v":15.25},{"$f":"IF(VLOOKUP(AF159,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ159,1)-AJ159,2),Round,2,FALSE)+VLOOKUP(AF159,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",0,ROUND(AJ159-0.04999,1)-AJ159+AM159)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF159,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"HAMPSTEAD - Porcelain",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,null,"4.86 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA166,AG166)","v":15.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":15.05},null,"new",15.05,{"$f":"+W166","v":0},{"$f":"+X166","v":15.05},{"$f":"(AG166-AC166)/AG166","v":0},null,11,{"$f":"SUM(AJ166:AL166)+AE166","v":15.05},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":15.05},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ166,1)-AJ166,2),Round,2,FALSE)+VLOOKUP(AF166,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",0,ROUND(AJ166-0.04999,1)-AJ166+AM166)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF166,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"HEIRLOOM - Porcelain",null,null,null,null,null,null,"Discontinued 7/17/24",null,null,null," "," ",null,null,"Item # Lookup:","CNHE",null,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             Blanc             Gris             Noir"]
[]
[null,"Field Tile - MLW",null,null,"31.5\" x 31.5\"",null,"Field",null,null,null,null,null,null,null,null,"13.77 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA172,AG172)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA172*(1-W172)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W172","v":0},{"$f":"+X172","v":18.7},{"$f":"(AG172-AC172)/AG172","v":0},null,11,{"$f":"SUM(AJ172:AL172)+AE172","v":18.7},null,null,{"$f":"ROUND(AC172/(1-VLOOKUP(AF172,Group,2,FALSE)),2)","v":18.7},{"$f":"IF(VLOOKUP(AF172,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ172,1)-AJ172,2),Round,2,FALSE)+VLOOKUP(AF172,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",0,ROUND(AJ172-0.04999,1)-AJ172+AM172)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF172,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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,b",{"$f":"IF(Suggested=\"Yes\",AA174,AG174)","v":56.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA174*(1-W174)+0.004999,2)","v":56.65},null,"",56.65,{"$f":"+W174","v":0},{"$f":"+X174","v":56.65},{"$f":"(AG174-AC174)/AG174","v":0},null,13,{"$f":"SUM(AJ174:AL174)+AE174","v":56.65},null,null,{"$f":"ROUND(AC174/(1-VLOOKUP(AF174,Group,2,FALSE)),2)","v":56.65},{"$f":"IF(VLOOKUP(AF174,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ174,1)-AJ174,2),Round,2,FALSE)+VLOOKUP(AF174,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF174,Group,7,FALSE)=\"\",0,ROUND(AJ174-0.04999,1)-AJ174+AM174)","v":0},{"$f":"IF(VLOOKUP(AF174,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF174,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos - MLW",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,"b",{"$f":"IF(Suggested=\"Yes\",AA175,AG175)","v":60.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},60.7,null,"",60.7,0,60.7,0,null,13,60.7,null,null,60.7,0,0,"",null,"X"]
[]
[null,null,null,"Notes:","a) Minimum purchase is 13.60 SF, (2 cartons).",null,null,null,null,null,"b) Special Order - approximately 3-4 weeks."]
[]
[null,null,"HUDSON BRICK - Porcelain",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\",AA185,AG185)","v":14.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA185*(1-W185)+0.004999,2)","v":14.6},null,"new",14.6,{"$f":"+W185","v":0},{"$f":"+X185","v":14.6},{"$f":"(AG185-AC185)/AG185","v":0},null,11,{"$f":"SUM(AJ185:AL185)+AE185","v":14.6},null,null,{"$f":"ROUND(AC185/(1-VLOOKUP(AF185,Group,2,FALSE)),2)","v":14.6},{"$f":"IF(VLOOKUP(AF185,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ185,1)-AJ185,2),Round,2,FALSE)+VLOOKUP(AF185,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF185,Group,7,FALSE)=\"\",0,ROUND(AJ185-0.04999,1)-AJ185+AM185)","v":0},{"$f":"IF(VLOOKUP(AF185,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF185,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"KINGSTON WOOD - Porcelain",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\",AA191,AG191)","v":14.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA191*(1-W191)+0.004999,2)","v":14.6},null,"",14.6,{"$f":"+W191","v":0},{"$f":"+X191","v":14.6},{"$f":"(AG191-AC191)/AG191","v":0},null,11,{"$f":"SUM(AJ191:AL191)+AE191","v":14.6},null,null,{"$f":"ROUND(AC191/(1-VLOOKUP(AF191,Group,2,FALSE)),2)","v":14.6},{"$f":"IF(VLOOKUP(AF191,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ191,1)-AJ191,2),Round,2,FALSE)+VLOOKUP(AF191,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF191,Group,7,FALSE)=\"\",0,ROUND(AJ191-0.04999,1)-AJ191+AM191)","v":0},{"$f":"IF(VLOOKUP(AF191,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF191,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"LIMERICK - Ceramic",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\",AA197,AG197)","v":12.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA197*(1-W197)+0.004999,2)","v":12.4},null,"",12.4,{"$f":"+W197","v":0},{"$f":"+X197","v":12.4},{"$f":"(AG197-AC197)/AG197","v":0},null,11,{"$f":"SUM(AJ197:AL197)+AE197","v":12.4},null,null,{"$f":"ROUND(AC197/(1-VLOOKUP(AF197,Group,2,FALSE)),2)","v":12.4},{"$f":"IF(VLOOKUP(AF197,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ197,1)-AJ197,2),Round,2,FALSE)+VLOOKUP(AF197,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF197,Group,7,FALSE)=\"\",0,ROUND(AJ197-0.04999,1)-AJ197+AM197)","v":0},{"$f":"IF(VLOOKUP(AF197,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF197,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"LIMESTONE - Natural Stone",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,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"6.80 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA203,AG203)","v":17.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA203*(1-W203)+0.004999,2)","v":17.75},null,"",17.75,{"$f":"+W203","v":0},17.75,{"$f":"(AG203-AC203)/AG203","v":0},null,8,{"$f":"SUM(AJ203:AL203)+AE203","v":17.75},null,null,{"$f":"ROUND(AC203/(1-VLOOKUP(AF203,Group,2,FALSE)),2)","v":17.75},{"$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,"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",28.2,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},28.2,null,"",28.2,0,28.2,0,null,8,28.2,null,null,28.2,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,17.75,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},17.75,null,"",17.75,0,17.75,0,null,8,17.75,null,null,17.75,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,17.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},17.05,null,"",17.05,0,17.05,0,null,8,17.05,null,null,17.05,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,"a",{"$f":"IF(Suggested=\"Yes\",AA207,AG207)","v":28.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA207*(1-W207)+0.004999,2)","v":28.65},null,"",28.65,{"$f":"+W207","v":0},{"$f":"+X207","v":28.65},{"$f":"(AG207-AC207)/AG207","v":0},null,8,{"$f":"SUM(AJ207:AL207)+AE207","v":28.65},null,null,{"$f":"ROUND(AC207/(1-VLOOKUP(AF207,Group,2,FALSE)),2)","v":28.65},{"$f":"IF(VLOOKUP(AF207,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ207,1)-AJ207,2),Round,2,FALSE)+VLOOKUP(AF207,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF207,Group,7,FALSE)=\"\",0,ROUND(AJ207-0.04999,1)-AJ207+AM207)","v":0},{"$f":"IF(VLOOKUP(AF207,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF207,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"12.00 SF/CTN",null,null,19.5,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},19.5,null,"",19.5,0,19.5,0,null,8,19.5,null,null,19.5,0,0,"",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,b",{"$f":"IF(Suggested=\"Yes\",AA210,AG210)","v":53.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA210*(1-W210)+0.004999,2)","v":53.35},null,"",53.35,{"$f":"+W210","v":0},{"$f":"+X210","v":53.35},{"$f":"(AG210-AC210)/AG210","v":0},null,10,{"$f":"SUM(AJ210:AL210)+AE210","v":53.35},null,null,{"$f":"ROUND(AC210/(1-VLOOKUP(AF210,Group,2,FALSE)),2)","v":53.35},{"$f":"IF(VLOOKUP(AF210,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ210,1)-AJ210,2),Round,2,FALSE)+VLOOKUP(AF210,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF210,Group,7,FALSE)=\"\",0,ROUND(AJ210-0.04999,1)-AJ210+AM210)","v":0},{"$f":"IF(VLOOKUP(AF210,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF210,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA211,AG211)","v":58.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA211*(1-W211)+0.004999,2)","v":58.75},null,"",58.75,0,58.75,{"$f":"(AG211-AC211)/AG211","v":0},null,10,{"$f":"SUM(AJ211:AL211)+AE211","v":58.75},null,null,{"$f":"ROUND(AC211/(1-VLOOKUP(AF211,Group,2,FALSE)),2)","v":58.75},{"$f":"IF(VLOOKUP(AF211,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ211,1)-AJ211,2),Round,2,FALSE)+VLOOKUP(AF211,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF211,Group,7,FALSE)=\"\",0,ROUND(AJ211-0.04999,1)-AJ211+AM211)","v":0},{"$f":"IF(VLOOKUP(AF211,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF211,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW Stone",null,null,"12\"",null,"Chair Rail",null,null,null," ",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA213,AG213)","v":20.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA213*(1-W213)+0.004999,2)","v":20.9},null,"",20.9,{"$f":"+W213","v":0},{"$f":"+X213","v":20.9},{"$f":"(AG213-AC213)/AG213","v":0},null,9,{"$f":"SUM(AJ213:AL213)+AE213","v":20.9},null,null,{"$f":"ROUND(AC213/(1-VLOOKUP(AF213,Group,2,FALSE)),2)","v":20.9},{"$f":"IF(VLOOKUP(AF213,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ213,1)-AJ213,2),Round,2,FALSE)+VLOOKUP(AF213,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF213,Group,7,FALSE)=\"\",0,ROUND(AJ213-0.04999,1)-AJ213+AM213)","v":0},{"$f":"IF(VLOOKUP(AF213,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF213,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim - MLW Stone",null,null,"5/8\" x 12\"",null,"Pencil",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA214,AG214)","v":15.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA214*(1-W214)+0.004999,2)","v":15.9},null,"",15.9,0,15.9,{"$f":"(AG214-AC214)/AG214","v":0},null,9,{"$f":"SUM(AJ214:AL214)+AE214","v":15.9},null,null,{"$f":"ROUND(AC214/(1-VLOOKUP(AF214,Group,2,FALSE)),2)","v":15.9},{"$f":"IF(VLOOKUP(AF214,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ214,1)-AJ214,2),Round,2,FALSE)+VLOOKUP(AF214,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF214,Group,7,FALSE)=\"\",0,ROUND(AJ214-0.04999,1)-AJ214+AM214)","v":0},{"$f":"IF(VLOOKUP(AF214,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF214,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"continued on next page"]
[null,null,"LIMESTONE - Natural Stone - continued",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CNLI"]
[]
[null,null,null,"Color:","Orval (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"6.80 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA221,AG221)","v":23.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA221*(1-W221)+0.004999,2)","v":23.05},null,"",23.05,{"$f":"+W221","v":0},{"$f":"+X221","v":23.05},{"$f":"(AG221-AC221)/AG221","v":0},null,8,{"$f":"SUM(AJ221:AL221)+AE221","v":23.05},null,null,{"$f":"ROUND(AC221/(1-VLOOKUP(AF221,Group,2,FALSE)),2)","v":23.05},{"$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,"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",31.8,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},31.8,null,"",31.8,0,31.8,0,null,8,31.8,null,null,31.8,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,21.9,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},21.9,null,"",21.9,0,21.9,0,null,8,21.9,null,null,21.9,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,22.5,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},22.5,null,"",22.5,0,22.5,0,null,8,22.5,null,null,22.5,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,"a",{"$f":"IF(Suggested=\"Yes\",AA225,AG225)","v":32.049999999999997},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA225*(1-W225)+0.004999,2)","v":32.049999999999997},null,"",32.049999999999997,{"$f":"+W225","v":0},{"$f":"+X225","v":32.049999999999997},{"$f":"(AG225-AC225)/AG225","v":0},null,8,{"$f":"SUM(AJ225:AL225)+AE225","v":32.049999999999997},null,null,{"$f":"ROUND(AC225/(1-VLOOKUP(AF225,Group,2,FALSE)),2)","v":32.049999999999997},{"$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,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"12.00 SF/CTN",null,null,24.35,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},24.35,null,"",24.35,0,24.35,0,null,8,24.35,null,null,24.35,0,0,"",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,b",{"$f":"IF(Suggested=\"Yes\",AA228,AG228)","v":60.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA228*(1-W228)+0.004999,2)","v":60.3},null,"",60.3,{"$f":"+W228","v":0},60.3,{"$f":"(AG228-AC228)/AG228","v":0},null,10,{"$f":"SUM(AJ228:AL228)+AE228","v":60.3},null,null,{"$f":"ROUND(AC228/(1-VLOOKUP(AF228,Group,2,FALSE)),2)","v":60.3},{"$f":"IF(VLOOKUP(AF228,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ228,1)-AJ228,2),Round,2,FALSE)+VLOOKUP(AF228,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF228,Group,7,FALSE)=\"\",0,ROUND(AJ228-0.04999,1)-AJ228+AM228)","v":0},{"$f":"IF(VLOOKUP(AF228,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF228,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA229,AG229)","v":63},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA229*(1-W229)+0.004999,2)","v":63},null,"",63,0,63,{"$f":"(AG229-AC229)/AG229","v":0},null,10,{"$f":"SUM(AJ229:AL229)+AE229","v":63},null,null,{"$f":"ROUND(AC229/(1-VLOOKUP(AF229,Group,2,FALSE)),2)","v":63},{"$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,"Trim - MLW Stone",null,null,"12\"",null,"Chair Rail",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA231,AG231)","v":24.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA231*(1-W231)+0.004999,2)","v":24.5},null,"",24.5,{"$f":"+W231","v":0},{"$f":"+X231","v":24.5},{"$f":"(AG231-AC231)/AG231","v":0},null,9,{"$f":"SUM(AJ231:AL231)+AE231","v":24.5},null,null,{"$f":"ROUND(AC231/(1-VLOOKUP(AF231,Group,2,FALSE)),2)","v":24.5},{"$f":"IF(VLOOKUP(AF231,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ231,1)-AJ231,2),Round,2,FALSE)+VLOOKUP(AF231,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF231,Group,7,FALSE)=\"\",0,ROUND(AJ231-0.04999,1)-AJ231+AM231)","v":0},{"$f":"IF(VLOOKUP(AF231,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF231,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim - MLW Stone",null,null,"5/8\" x 12\"",null,"Pencil",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA232,AG232)","v":17.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA232*(1-W232)+0.004999,2)","v":17.7},null,"",17.7,{"$f":"+W232","v":0},{"$f":"+X232","v":17.7},{"$f":"(AG232-AC232)/AG232","v":0},null,9,{"$f":"SUM(AJ232:AL232)+AE232","v":17.7},null,null,{"$f":"ROUND(AC232/(1-VLOOKUP(AF232,Group,2,FALSE)),2)","v":17.7},{"$f":"IF(VLOOKUP(AF232,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ232,1)-AJ232,2),Round,2,FALSE)+VLOOKUP(AF232,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF232,Group,7,FALSE)=\"\",0,ROUND(AJ232-0.04999,1)-AJ232+AM232)","v":0},{"$f":"IF(VLOOKUP(AF232,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF232,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Color:","St. Bernardus (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"6.80 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA236,AG236)","v":19.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA236*(1-W236)+0.004999,2)","v":19.05},null,"",19.05,{"$f":"+W236","v":0},{"$f":"+X236","v":19.05},{"$f":"(AG236-AC236)/AG236","v":0},null,8,{"$f":"SUM(AJ236:AL236)+AE236","v":19.05},null,null,{"$f":"ROUND(AC236/(1-VLOOKUP(AF236,Group,2,FALSE)),2)","v":19.05},{"$f":"IF(VLOOKUP(AF236,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ236,1)-AJ236,2),Round,2,FALSE)+VLOOKUP(AF236,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",0,ROUND(AJ236-0.04999,1)-AJ236+AM236)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF236,Group,7,FALSE))","v":""},null,"X"]
[null,"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",28.2,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},28.2,null,"",28.2,0,28.2,0,null,8,28.2,null,null,28.2,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,19.2,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},19.2,null,"",19.2,0,19.2,0,null,8,19.2,null,null,19.2,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,19.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},19.05,null,"",19.05,0,19.05,0,null,8,19.05,null,null,19.05,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,"a",{"$f":"IF(Suggested=\"Yes\",AA240,AG240)","v":29.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA240*(1-W240)+0.004999,2)","v":29.5},null,"",29.5,{"$f":"+W240","v":0},{"$f":"+X240","v":29.5},{"$f":"(AG240-AC240)/AG240","v":0},null,8,{"$f":"SUM(AJ240:AL240)+AE240","v":29.5},null,null,{"$f":"ROUND(AC240/(1-VLOOKUP(AF240,Group,2,FALSE)),2)","v":29.5},{"$f":"IF(VLOOKUP(AF240,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ240,1)-AJ240,2),Round,2,FALSE)+VLOOKUP(AF240,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF240,Group,7,FALSE)=\"\",0,ROUND(AJ240-0.04999,1)-AJ240+AM240)","v":0},{"$f":"IF(VLOOKUP(AF240,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF240,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"12.00 SF/CTN",null,null,21.9,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},21.9,null,"",21.9,0,21.9,0,null,8,21.9,null,null,21.9,0,0,"",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,b",{"$f":"IF(Suggested=\"Yes\",AA243,AG243)","v":54.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA243*(1-W243)+0.004999,2)","v":54.55},null,"",54.55,{"$f":"+W243","v":0},54.55,{"$f":"(AG243-AC243)/AG243","v":0},null,10,{"$f":"SUM(AJ243:AL243)+AE243","v":54.55},null,null,{"$f":"ROUND(AC243/(1-VLOOKUP(AF243,Group,2,FALSE)),2)","v":54.55},{"$f":"IF(VLOOKUP(AF243,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ243,1)-AJ243,2),Round,2,FALSE)+VLOOKUP(AF243,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF243,Group,7,FALSE)=\"\",0,ROUND(AJ243-0.04999,1)-AJ243+AM243)","v":0},{"$f":"IF(VLOOKUP(AF243,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF243,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\",AA244,AG244)","v":58.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA244*(1-W244)+0.004999,2)","v":58.75},null,"",58.75,0,58.75,{"$f":"(AG244-AC244)/AG244","v":0},null,10,{"$f":"SUM(AJ244:AL244)+AE244","v":58.75},null,null,{"$f":"ROUND(AC244/(1-VLOOKUP(AF244,Group,2,FALSE)),2)","v":58.75},{"$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,"Trim - MLW Stone",null,null,"12\"",null,"Chair Rail",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA246,AG246)","v":24.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA246*(1-W246)+0.004999,2)","v":24.5},null,"",24.5,{"$f":"+W246","v":0},{"$f":"+X246","v":24.5},{"$f":"(AG246-AC246)/AG246","v":0},null,9,{"$f":"SUM(AJ246:AL246)+AE246","v":24.5},null,null,{"$f":"ROUND(AC246/(1-VLOOKUP(AF246,Group,2,FALSE)),2)","v":24.5},{"$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,"Trim - MLW Stone",null,null,"5/8\" x 12\"",null,"Pencil",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA247,AG247)","v":17.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA247*(1-W247)+0.004999,2)","v":17.7},null,"",17.7,{"$f":"+W247","v":0},{"$f":"+X247","v":17.7},{"$f":"(AG247-AC247)/AG247","v":0},null,9,{"$f":"SUM(AJ247:AL247)+AE247","v":17.7},null,null,{"$f":"ROUND(AC247/(1-VLOOKUP(AF247,Group,2,FALSE)),2)","v":17.7},{"$f":"IF(VLOOKUP(AF247,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ247,1)-AJ247,2),Round,2,FALSE)+VLOOKUP(AF247,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF247,Group,7,FALSE)=\"\",0,ROUND(AJ247-0.04999,1)-AJ247+AM247)","v":0},{"$f":"IF(VLOOKUP(AF247,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF247,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Special Order - approximately 3-4 weeks.",null,null,null,null,null,"b) Minimum purchase is 13.60 SF, (2 cartons)."]
[]
[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\",AA255,AG255)","v":18.649999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA255*(1-W255)+0.004999,2)","v":18.649999999999999},null,"",18.649999999999999,{"$f":"+W255","v":0},{"$f":"+X255","v":18.649999999999999},{"$f":"(AG255-AC255)/AG255","v":0},null,11,{"$f":"SUM(AJ255:AL255)+AE255","v":18.649999999999999},null,null,{"$f":"ROUND(AC255/(1-VLOOKUP(AF255,Group,2,FALSE)),2)","v":18.649999999999999},{"$f":"IF(VLOOKUP(AF255,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ255,1)-AJ255,2),Round,2,FALSE)+VLOOKUP(AF255,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",0,ROUND(AJ255-0.04999,1)-AJ255+AM255)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF255,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - 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\",AA256,AG256)","v":18.649999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA256*(1-W256)+0.004999,2)","v":18.649999999999999},null,"",18.649999999999999,{"$f":"+W256","v":0},{"$f":"+X256","v":18.649999999999999},{"$f":"(AG256-AC256)/AG256","v":0},null,11,{"$f":"SUM(AJ256:AL256)+AE256","v":18.649999999999999},null,null,{"$f":"ROUND(AC256/(1-VLOOKUP(AF256,Group,2,FALSE)),2)","v":18.649999999999999},{"$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,null,"MARBLE - Natural Stone",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNMA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Color:","White Venatino (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"5.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA262,AG262)","v":26.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA262*(1-W262)+0.004999,2)","v":26.65},null,"",26.65,{"$f":"+W262","v":0},{"$f":"+X262","v":26.65},{"$f":"(AG262-AC262)/AG262","v":0},null,8,{"$f":"SUM(AJ262:AL262)+AE262","v":26.65},null,null,{"$f":"ROUND(AC262/(1-VLOOKUP(AF262,Group,2,FALSE)),2)","v":26.65},{"$f":"IF(VLOOKUP(AF262,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ262,1)-AJ262,2),Round,2,FALSE)+VLOOKUP(AF262,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF262,Group,7,FALSE)=\"\",0,ROUND(AJ262-0.04999,1)-AJ262+AM262)","v":0},{"$f":"IF(VLOOKUP(AF262,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF262,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"3\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"7.50 SF/CTN",null,null,26.2,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},26.2,null,"",26.2,0,26.2,0,null,8,26.2,null,null,26.2,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"4\" x 12\"",null,"Field",null,null,"Discontinued 11/3/23",null,null,null,null,null,"10.00 SF/CTN",null,"a",34.200000000000003,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},34.200000000000003,null,"",34.200000000000003,0,34.200000000000003,0,null,8,34.200000000000003,null,null,34.200000000000003,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"5.00 SF/CTN",null,null,27.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},27.05,null,"",27.05,0,27.05,0,null,8,27.05,null,null,27.05,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,{"$f":"IF(Suggested=\"Yes\",AA266,AG266)","v":23.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA266*(1-W266)+0.004999,2)","v":23.9},null,"",23.9,{"$f":"+W266","v":0},{"$f":"+X266","v":23.9},{"$f":"(AG266-AC266)/AG266","v":0},null,8,{"$f":"SUM(AJ266:AL266)+AE266","v":23.9},null,null,{"$f":"ROUND(AC266/(1-VLOOKUP(AF266,Group,2,FALSE)),2)","v":23.9},{"$f":"IF(VLOOKUP(AF266,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ266,1)-AJ266,2),Round,2,FALSE)+VLOOKUP(AF266,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF266,Group,7,FALSE)=\"\",0,ROUND(AJ266-0.04999,1)-AJ266+AM266)","v":0},{"$f":"IF(VLOOKUP(AF266,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF266,Group,7,FALSE))","v":""},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,"a",35.049999999999997,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},35.049999999999997,null,"",35.049999999999997,0,35.049999999999997,0,null,8,35.049999999999997,null,null,35.049999999999997,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"12.00 SF/CTN",null,null,24.75,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},24.75,null,"",24.75,0,24.75,0,null,8,24.75,null,null,24.75,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,{"$f":"IF(Suggested=\"Yes\",AA269,AG269)","v":31.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA269*(1-W269)+0.004999,2)","v":31.05},null,"",31.05,{"$f":"+W269","v":0},{"$f":"+X269","v":31.05},{"$f":"(AG269-AC269)/AG269","v":0},null,8,{"$f":"SUM(AJ269:AL269)+AE269","v":31.05},null,null,{"$f":"ROUND(AC269/(1-VLOOKUP(AF269,Group,2,FALSE)),2)","v":31.05},{"$f":"IF(VLOOKUP(AF269,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ269,1)-AJ269,2),Round,2,FALSE)+VLOOKUP(AF269,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF269,Group,7,FALSE)=\"\",0,ROUND(AJ269-0.04999,1)-AJ269+AM269)","v":0},{"$f":"IF(VLOOKUP(AF269,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF269,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,b",{"$f":"IF(Suggested=\"Yes\",AA271,AG271)","v":61.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA271*(1-W271)+0.004999,2)","v":61.5},null,"",61.5,{"$f":"+W271","v":0},61.5,{"$f":"(AG271-AC271)/AG271","v":0},null,10,{"$f":"SUM(AJ271:AL271)+AE271","v":61.5},null,null,{"$f":"ROUND(AC271/(1-VLOOKUP(AF271,Group,2,FALSE)),2)","v":61.5},{"$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,"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\",AA272,AG272)","v":67.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA272*(1-W272)+0.004999,2)","v":67.05},null,"",67.05,0,67.05,{"$f":"(AG272-AC272)/AG272","v":0},null,10,{"$f":"SUM(AJ272:AL272)+AE272","v":67.05},null,null,{"$f":"ROUND(AC272/(1-VLOOKUP(AF272,Group,2,FALSE)),2)","v":67.05},{"$f":"IF(VLOOKUP(AF272,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ272,1)-AJ272,2),Round,2,FALSE)+VLOOKUP(AF272,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF272,Group,7,FALSE)=\"\",0,ROUND(AJ272-0.04999,1)-AJ272+AM272)","v":0},{"$f":"IF(VLOOKUP(AF272,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF272,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW Stone",null,null,"12\"",null,"Chair Rail",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA274,AG274)","v":44.15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA274*(1-W274)+0.004999,2)","v":44.15},null,"",44.15,{"$f":"+W274","v":0},44.15,{"$f":"(AG274-AC274)/AG274","v":0},null,9,{"$f":"SUM(AJ274:AL274)+AE274","v":44.15},null,null,{"$f":"ROUND(AC274/(1-VLOOKUP(AF274,Group,2,FALSE)),2)","v":44.15},{"$f":"IF(VLOOKUP(AF274,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ274,1)-AJ274,2),Round,2,FALSE)+VLOOKUP(AF274,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF274,Group,7,FALSE)=\"\",0,ROUND(AJ274-0.04999,1)-AJ274+AM274)","v":0},{"$f":"IF(VLOOKUP(AF274,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF274,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim - MLW Stone",null,null,"5/8\" x 12\"",null,"Pencil",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA275,AG275)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA275*(1-W275)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG275-AC275)/AG275","v":0},null,9,{"$f":"SUM(AJ275:AL275)+AE275","v":24.35},null,null,{"$f":"ROUND(AC275/(1-VLOOKUP(AF275,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF275,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ275,1)-AJ275,2),Round,2,FALSE)+VLOOKUP(AF275,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF275,Group,7,FALSE)=\"\",0,ROUND(AJ275-0.04999,1)-AJ275+AM275)","v":0},{"$f":"IF(VLOOKUP(AF275,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF275,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim - MLW Stone",null,null,"5\" x 12\"",null,"Base",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA276,AG276)","v":60},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA276*(1-W276)+0.004999,2)","v":60},null,"",60,0,60,{"$f":"(AG276-AC276)/AG276","v":0},null,9,{"$f":"SUM(AJ276:AL276)+AE276","v":60},null,null,{"$f":"ROUND(AC276/(1-VLOOKUP(AF276,Group,2,FALSE)),2)","v":60},{"$f":"IF(VLOOKUP(AF276,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ276,1)-AJ276,2),Round,2,FALSE)+VLOOKUP(AF276,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF276,Group,7,FALSE)=\"\",0,ROUND(AJ276-0.04999,1)-AJ276+AM276)","v":0},{"$f":"IF(VLOOKUP(AF276,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF276,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Color:","White Venatino (Polished)"]
[]
[null,"Field Tile - MLW Stone",null,null,"4\" x 12\"",null,"Field",null,null,"Discontinued 11/3/23",null,null,null,null,null,"10.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA280,AG280)","v":35.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA280*(1-W280)+0.004999,2)","v":35.65},null,"",35.65,{"$f":"+W280","v":0},35.65,{"$f":"(AG280-AC280)/AG280","v":0},null,8,{"$f":"SUM(AJ280:AL280)+AE280","v":35.65},null,null,{"$f":"ROUND(AC280/(1-VLOOKUP(AF280,Group,2,FALSE)),2)","v":35.65},{"$f":"IF(VLOOKUP(AF280,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ280,1)-AJ280,2),Round,2,FALSE)+VLOOKUP(AF280,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF280,Group,7,FALSE)=\"\",0,ROUND(AJ280-0.04999,1)-AJ280+AM280)","v":0},{"$f":"IF(VLOOKUP(AF280,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF280,Group,7,FALSE))","v":""},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,{"$f":"IF(Suggested=\"Yes\",AA281,AG281)","v":23.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA281*(1-W281)+0.004999,2)","v":23.9},null,"",23.9,0,23.9,{"$f":"(AG281-AC281)/AG281","v":0},null,8,{"$f":"SUM(AJ281:AL281)+AE281","v":23.9},null,null,{"$f":"ROUND(AC281/(1-VLOOKUP(AF281,Group,2,FALSE)),2)","v":23.9},{"$f":"IF(VLOOKUP(AF281,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ281,1)-AJ281,2),Round,2,FALSE)+VLOOKUP(AF281,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF281,Group,7,FALSE)=\"\",0,ROUND(AJ281-0.04999,1)-AJ281+AM281)","v":0},{"$f":"IF(VLOOKUP(AF281,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF281,Group,7,FALSE))","v":""},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,"a",{"$f":"IF(Suggested=\"Yes\",AA282,AG282)","v":36.200000000000003},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA282*(1-W282)+0.004999,2)","v":36.200000000000003},null,"",36.200000000000003,0,36.200000000000003,{"$f":"(AG282-AC282)/AG282","v":0},null,8,{"$f":"SUM(AJ282:AL282)+AE282","v":36.200000000000003},null,null,{"$f":"ROUND(AC282/(1-VLOOKUP(AF282,Group,2,FALSE)),2)","v":36.200000000000003},{"$f":"IF(VLOOKUP(AF282,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ282,1)-AJ282,2),Round,2,FALSE)+VLOOKUP(AF282,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF282,Group,7,FALSE)=\"\",0,ROUND(AJ282-0.04999,1)-AJ282+AM282)","v":0},{"$f":"IF(VLOOKUP(AF282,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF282,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",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\",AA283,AG283)","v":24.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA283*(1-W283)+0.004999,2)","v":24.75},null,"",24.75,0,24.75,{"$f":"(AG283-AC283)/AG283","v":0},null,8,{"$f":"SUM(AJ283:AL283)+AE283","v":24.75},null,null,{"$f":"ROUND(AC283/(1-VLOOKUP(AF283,Group,2,FALSE)),2)","v":24.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,"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,b",{"$f":"IF(Suggested=\"Yes\",AA285,AG285)","v":61.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA285*(1-W285)+0.004999,2)","v":61.5},null,"",61.5,{"$f":"+W285","v":0},61.5,{"$f":"(AG285-AC285)/AG285","v":0},null,10,{"$f":"SUM(AJ285:AL285)+AE285","v":61.5},null,null,{"$f":"ROUND(AC285/(1-VLOOKUP(AF285,Group,2,FALSE)),2)","v":61.5},{"$f":"IF(VLOOKUP(AF285,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ285,1)-AJ285,2),Round,2,FALSE)+VLOOKUP(AF285,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF285,Group,7,FALSE)=\"\",0,ROUND(AJ285-0.04999,1)-AJ285+AM285)","v":0},{"$f":"IF(VLOOKUP(AF285,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF285,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\",AA286,AG286)","v":67.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA286*(1-W286)+0.004999,2)","v":67.05},null,"",67.05,0,67.05,{"$f":"(AG286-AC286)/AG286","v":0},null,10,{"$f":"SUM(AJ286:AL286)+AE286","v":67.05},null,null,{"$f":"ROUND(AC286/(1-VLOOKUP(AF286,Group,2,FALSE)),2)","v":67.05},{"$f":"IF(VLOOKUP(AF286,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ286,1)-AJ286,2),Round,2,FALSE)+VLOOKUP(AF286,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF286,Group,7,FALSE)=\"\",0,ROUND(AJ286-0.04999,1)-AJ286+AM286)","v":0},{"$f":"IF(VLOOKUP(AF286,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF286,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Special Order - approximately 3-4 weeks.",null,null,null,null,null,"b) Minimum purchase is 13.60 SF, (2 cartons)."]
[]
[null,null,"MARRAKESH - Porcelain",null,null,null,null,null,null,"Discontinued 2/15/24",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:","Ash          Charcoal"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field",null,null,null,null," ",null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA294,AG294)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA294*(1-W294)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W294","v":0},{"$f":"+X294","v":12.75},{"$f":"(AG294-AC294)/AG294","v":0},null,11,{"$f":"SUM(AJ294:AL294)+AE294","v":12.75},null,null,{"$f":"ROUND(AC294/(1-VLOOKUP(AF294,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF294,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ294,1)-AJ294,2),Round,2,FALSE)+VLOOKUP(AF294,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF294,Group,7,FALSE)=\"\",0,ROUND(AJ294-0.04999,1)-AJ294+AM294)","v":0},{"$f":"IF(VLOOKUP(AF294,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF294,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field",null,null,"Decorative",null,null,null,null,null,"10.75 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA296,AG296)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA296*(1-W296)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W296","v":0},{"$f":"+X296","v":12.75},{"$f":"(AG296-AC296)/AG296","v":0},null,11,{"$f":"SUM(AJ296:AL296)+AE296","v":12.75},null,null,{"$f":"ROUND(AC296/(1-VLOOKUP(AF296,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF296,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ296,1)-AJ296,2),Round,2,FALSE)+VLOOKUP(AF296,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF296,Group,7,FALSE)=\"\",0,ROUND(AJ296-0.04999,1)-AJ296+AM296)","v":0},{"$f":"IF(VLOOKUP(AF296,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF296,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) This Decorative coordinates with both Ash or Charcoal Field Tiles."]
[]
[null,null,"MAYFAIR - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNMF",null,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:","Cream          Gray          White"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 5\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"5.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA304,AG304)","v":18.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA304*(1-W304)+0.004999,2)","v":18.2},null,"",18.2,{"$f":"+W304","v":0},18.2,{"$f":"(AG304-AC304)/AG304","v":0},null,11,{"$f":"SUM(AJ304:AL304)+AE304","v":18.2},null,null,{"$f":"ROUND(AC304/(1-VLOOKUP(AF304,Group,2,FALSE)),2)","v":18.2},{"$f":"IF(VLOOKUP(AF304,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ304,1)-AJ304,2),Round,2,FALSE)+VLOOKUP(AF304,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF304,Group,7,FALSE)=\"\",0,ROUND(AJ304-0.04999,1)-AJ304+AM304)","v":0},{"$f":"IF(VLOOKUP(AF304,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF304,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"5\" x 5\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA305,AG305)","v":18.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA305*(1-W305)+0.004999,2)","v":18.25},null,"",18.25,0,18.25,{"$f":"(AG305-AC305)/AG305","v":0},null,11,{"$f":"SUM(AJ305:AL305)+AE305","v":18.25},null,null,{"$f":"ROUND(AC305/(1-VLOOKUP(AF305,Group,2,FALSE)),2)","v":18.25},{"$f":"IF(VLOOKUP(AF305,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ305,1)-AJ305,2),Round,2,FALSE)+VLOOKUP(AF305,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF305,Group,7,FALSE)=\"\",0,ROUND(AJ305-0.04999,1)-AJ305+AM305)","v":0},{"$f":"IF(VLOOKUP(AF305,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF305,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"2.5\" x 6\" x 5/16\"",null,"Field",null,null,"Picket",null,null,null,null,null,"5.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA306,AG306)","v":19.100000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA306*(1-W306)+0.004999,2)","v":19.100000000000001},null,"",19.100000000000001,0,19.100000000000001,{"$f":"(AG306-AC306)/AG306","v":0},null,11,{"$f":"SUM(AJ306:AL306)+AE306","v":19.100000000000001},null,null,{"$f":"ROUND(AC306/(1-VLOOKUP(AF306,Group,2,FALSE)),2)","v":19.100000000000001},{"$f":"IF(VLOOKUP(AF306,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ306,1)-AJ306,2),Round,2,FALSE)+VLOOKUP(AF306,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF306,Group,7,FALSE)=\"\",0,ROUND(AJ306-0.04999,1)-AJ306+AM306)","v":0},{"$f":"IF(VLOOKUP(AF306,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF306,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"METRO - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNME",null,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             White"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 12\" x 1/4\"",null,"Field",null,null,null,null," ",null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA312,AG312)","v":11.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA312*(1-W312)+0.004999,2)","v":11.9},null,"",11.9,{"$f":"+W312","v":0},{"$f":"+X312","v":11.9},{"$f":"(AG312-AC312)/AG312","v":0},null,11,{"$f":"SUM(AJ312:AL312)+AE312","v":11.9},null,null,{"$f":"ROUND(AC312/(1-VLOOKUP(AF312,Group,2,FALSE)),2)","v":11.9},{"$f":"IF(VLOOKUP(AF312,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ312,1)-AJ312,2),Round,2,FALSE)+VLOOKUP(AF312,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF312,Group,7,FALSE)=\"\",0,ROUND(AJ312-0.04999,1)-AJ312+AM312)","v":0},{"$f":"IF(VLOOKUP(AF312,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF312,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Decorative Patterns:"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 12\" x 1/4\"",null,"Field",null,null,"Bastille",null," ",null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA316,AG316)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA316*(1-W316)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W316","v":0},12.75,{"$f":"(AG316-AC316)/AG316","v":0},null,11,{"$f":"SUM(AJ316:AL316)+AE316","v":12.75},null,null,{"$f":"ROUND(AC316/(1-VLOOKUP(AF316,Group,2,FALSE)),2)","v":12.75},{"$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,"4\" x 12\" x 1/4\"",null,"Field",null,null,"Concorde",null,null,null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA317,AG317)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA317*(1-W317)+0.004999,2)","v":12.75},null,"",12.75,0,12.75,{"$f":"(AG317-AC317)/AG317","v":0},null,11,{"$f":"SUM(AJ317:AL317)+AE317","v":12.75},null,null,{"$f":"ROUND(AC317/(1-VLOOKUP(AF317,Group,2,FALSE)),2)","v":12.75},{"$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,"Field Tile - MLW",null,null,"4\" x 12\" x 1/4\"",null,"Field",null,null,"Louvre",null," ",null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA318,AG318)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA318*(1-W318)+0.004999,2)","v":12.75},null,"",12.75,0,12.75,{"$f":"(AG318-AC318)/AG318","v":0},null,11,{"$f":"SUM(AJ318:AL318)+AE318","v":12.75},null,null,{"$f":"ROUND(AC318/(1-VLOOKUP(AF318,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF318,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ318,1)-AJ318,2),Round,2,FALSE)+VLOOKUP(AF318,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF318,Group,7,FALSE)=\"\",0,ROUND(AJ318-0.04999,1)-AJ318+AM318)","v":0},{"$f":"IF(VLOOKUP(AF318,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF318,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\",AA320,AG320)","v":9.1999999999999993},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA320*(1-W320)+0.004999,2)","v":9.1999999999999993},null,"",9.1999999999999993,{"$f":"+W320","v":0},{"$f":"+X320","v":9.1999999999999993},{"$f":"(AG320-AC320)/AG320","v":0},null,12,{"$f":"SUM(AJ320:AL320)+AE320","v":9.1999999999999993},null,null,{"$f":"ROUND(AC320/(1-VLOOKUP(AF320,Group,2,FALSE)),2)","v":9.1999999999999993},{"$f":"IF(VLOOKUP(AF320,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ320,1)-AJ320,2),Round,2,FALSE)+VLOOKUP(AF320,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF320,Group,7,FALSE)=\"\",0,ROUND(AJ320-0.04999,1)-AJ320+AM320)","v":0},{"$f":"IF(VLOOKUP(AF320,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF320,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"MOMENTUM - Ceramic",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\",AA326,AG326)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA326*(1-W326)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W326","v":0},{"$f":"+X326","v":18.7},{"$f":"(AG326-AC326)/AG326","v":0},null,11,{"$f":"SUM(AJ326:AL326)+AE326","v":18.7},null,null,{"$f":"ROUND(AC326/(1-VLOOKUP(AF326,Group,2,FALSE)),2)","v":18.7},{"$f":"IF(VLOOKUP(AF326,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ326,1)-AJ326,2),Round,2,FALSE)+VLOOKUP(AF326,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF326,Group,7,FALSE)=\"\",0,ROUND(AJ326-0.04999,1)-AJ326+AM326)","v":0},{"$f":"IF(VLOOKUP(AF326,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF326,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"MOROCCAN - Porcelain",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 - Patterned",null,null,null,null," ",null,null,null,"5.54 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA332,AG332)","v":16.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA332*(1-W332)+0.004999,2)","v":16.45},null,"",16.45,{"$f":"+W332","v":0},{"$f":"+X332","v":16.45},{"$f":"(AG332-AC332)/AG332","v":0},null,11,{"$f":"SUM(AJ332:AL332)+AE332","v":16.45},null,null,{"$f":"ROUND(AC332/(1-VLOOKUP(AF332,Group,2,FALSE)),2)","v":16.45},{"$f":"IF(VLOOKUP(AF332,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ332,1)-AJ332,2),Round,2,FALSE)+VLOOKUP(AF332,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF332,Group,7,FALSE)=\"\",0,ROUND(AJ332-0.04999,1)-AJ332+AM332)","v":0},{"$f":"IF(VLOOKUP(AF332,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF332,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"NOLA - Porcelain",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:","Gray          White",null,null,null,null,null,null,"    Discontinued 2/15/24"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field",null,null,null,null,"    Discontinued 2/15/24",null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA338,AG338)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA338*(1-W338)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W338","v":0},{"$f":"+X338","v":12.75},{"$f":"(AG338-AC338)/AG338","v":0},null,11,{"$f":"SUM(AJ338:AL338)+AE338","v":12.75},null,null,{"$f":"ROUND(AC338/(1-VLOOKUP(AF338,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF338,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ338,1)-AJ338,2),Round,2,FALSE)+VLOOKUP(AF338,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF338,Group,7,FALSE)=\"\",0,ROUND(AJ338-0.04999,1)-AJ338+AM338)","v":0},{"$f":"IF(VLOOKUP(AF338,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF338,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Decorative Patterns:"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field",null,null,"Dauphine",null,null,null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA342,AG342)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA342*(1-W342)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W342","v":0},12.75,{"$f":"(AG342-AC342)/AG342","v":0},null,11,{"$f":"SUM(AJ342:AL342)+AE342","v":12.75},null,null,{"$f":"ROUND(AC342/(1-VLOOKUP(AF342,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF342,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ342,1)-AJ342,2),Round,2,FALSE)+VLOOKUP(AF342,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF342,Group,7,FALSE)=\"\",0,ROUND(AJ342-0.04999,1)-AJ342+AM342)","v":0},{"$f":"IF(VLOOKUP(AF342,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF342,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field",null,null,"Lafayette",null,null,null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA343,AG343)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA343*(1-W343)+0.004999,2)","v":12.75},null,"",12.75,0,12.75,{"$f":"(AG343-AC343)/AG343","v":0},null,11,{"$f":"SUM(AJ343:AL343)+AE343","v":12.75},null,null,{"$f":"ROUND(AC343/(1-VLOOKUP(AF343,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF343,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ343,1)-AJ343,2),Round,2,FALSE)+VLOOKUP(AF343,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF343,Group,7,FALSE)=\"\",0,ROUND(AJ343-0.04999,1)-AJ343+AM343)","v":0},{"$f":"IF(VLOOKUP(AF343,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF343,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field",null,null,"Magazine",null,null,null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA344,AG344)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA344*(1-W344)+0.004999,2)","v":12.75},null,"",12.75,0,12.75,{"$f":"(AG344-AC344)/AG344","v":0},null,11,{"$f":"SUM(AJ344:AL344)+AE344","v":12.75},null,null,{"$f":"ROUND(AC344/(1-VLOOKUP(AF344,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF344,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ344,1)-AJ344,2),Round,2,FALSE)+VLOOKUP(AF344,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF344,Group,7,FALSE)=\"\",0,ROUND(AJ344-0.04999,1)-AJ344+AM344)","v":0},{"$f":"IF(VLOOKUP(AF344,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF344,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field",null,null,"Orleans",null,null,null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA345,AG345)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA345*(1-W345)+0.004999,2)","v":12.75},null,"",12.75,0,12.75,{"$f":"(AG345-AC345)/AG345","v":0},null,11,{"$f":"SUM(AJ345:AL345)+AE345","v":12.75},null,null,{"$f":"ROUND(AC345/(1-VLOOKUP(AF345,Group,2,FALSE)),2)","v":12.75},{"$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,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field",null,null,"Toulouse",null,null,null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA346,AG346)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA346*(1-W346)+0.004999,2)","v":12.75},null,"",12.75,0,12.75,{"$f":"(AG346-AC346)/AG346","v":0},null,11,{"$f":"SUM(AJ346:AL346)+AE346","v":12.75},null,null,{"$f":"ROUND(AC346/(1-VLOOKUP(AF346,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF346,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ346,1)-AJ346,2),Round,2,FALSE)+VLOOKUP(AF346,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF346,Group,7,FALSE)=\"\",0,ROUND(AJ346-0.04999,1)-AJ346+AM346)","v":0},{"$f":"IF(VLOOKUP(AF346,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF346,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"NOLA BLACK - Porcelain",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 - Patterned",null,null,null,null,null,null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA352,AG352)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA352*(1-W352)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W352","v":0},{"$f":"+X352","v":12.75},{"$f":"(AG352-AC352)/AG352","v":0},null,11,{"$f":"SUM(AJ352:AL352)+AE352","v":12.75},null,null,{"$f":"ROUND(AC352/(1-VLOOKUP(AF352,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF352,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ352,1)-AJ352,2),Round,2,FALSE)+VLOOKUP(AF352,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF352,Group,7,FALSE)=\"\",0,ROUND(AJ352-0.04999,1)-AJ352+AM352)","v":0},{"$f":"IF(VLOOKUP(AF352,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF352,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"NOMAD - Porcelain",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",null,null,null,null,null,null,null,null,"16.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA358,AG358)","v":18.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA358*(1-W358)+0.004999,2)","v":18.75},null,"",18.75,{"$f":"+W358","v":0},{"$f":"+X358","v":18.75},{"$f":"(AG358-AC358)/AG358","v":0},null,11,{"$f":"SUM(AJ358:AL358)+AE358","v":18.75},null,null,{"$f":"ROUND(AC358/(1-VLOOKUP(AF358,Group,2,FALSE)),2)","v":18.75},{"$f":"IF(VLOOKUP(AF358,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ358,1)-AJ358,2),Round,2,FALSE)+VLOOKUP(AF358,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF358,Group,7,FALSE)=\"\",0,ROUND(AJ358-0.04999,1)-AJ358+AM358)","v":0},{"$f":"IF(VLOOKUP(AF358,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF358,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"NORMANDY - Porcelain",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\",AA364,AG364)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA364*(1-W364)+0.004999,2)","v":13.5},null,"new",13.5,{"$f":"+W364","v":0},13.5,{"$f":"(AG364-AC364)/AG364","v":0},null,11,{"$f":"SUM(AJ364:AL364)+AE364","v":13.5},null,null,{"$f":"ROUND(AC364/(1-VLOOKUP(AF364,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF364,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ364,1)-AJ364,2),Round,2,FALSE)+VLOOKUP(AF364,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF364,Group,7,FALSE)=\"\",0,ROUND(AJ364-0.04999,1)-AJ364+AM364)","v":0},{"$f":"IF(VLOOKUP(AF364,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF364,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\",AA365,AG365)","v":14.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA365*(1-W365)+0.004999,2)","v":14.7},null,"new",14.7,0,14.7,{"$f":"(AG365-AC365)/AG365","v":0},null,11,{"$f":"SUM(AJ365:AL365)+AE365","v":14.7},null,null,{"$f":"ROUND(AC365/(1-VLOOKUP(AF365,Group,2,FALSE)),2)","v":14.7},{"$f":"IF(VLOOKUP(AF365,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ365,1)-AJ365,2),Round,2,FALSE)+VLOOKUP(AF365,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF365,Group,7,FALSE)=\"\",0,ROUND(AJ365-0.04999,1)-AJ365+AM365)","v":0},{"$f":"IF(VLOOKUP(AF365,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF365,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\",AA366,AG366)","v":15.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA366*(1-W366)+0.004999,2)","v":15.25},null,"new",15.25,0,15.25,{"$f":"(AG366-AC366)/AG366","v":0},null,11,{"$f":"SUM(AJ366:AL366)+AE366","v":15.25},null,null,{"$f":"ROUND(AC366/(1-VLOOKUP(AF366,Group,2,FALSE)),2)","v":15.25},{"$f":"IF(VLOOKUP(AF366,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ366,1)-AJ366,2),Round,2,FALSE)+VLOOKUP(AF366,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF366,Group,7,FALSE)=\"\",0,ROUND(AJ366-0.04999,1)-AJ366+AM366)","v":0},{"$f":"IF(VLOOKUP(AF366,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF366,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"ONYX - Porcelain",null,null,null,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\",AA372,AG372)","v":14.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA372*(1-W372)+0.004999,2)","v":14.95},null,"",14.95,{"$f":"+W372","v":0},14.95,{"$f":"(AG372-AC372)/AG372","v":0},null,11,{"$f":"SUM(AJ372:AL372)+AE372","v":14.95},null,null,{"$f":"ROUND(AC372/(1-VLOOKUP(AF372,Group,2,FALSE)),2)","v":14.95},{"$f":"IF(VLOOKUP(AF372,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ372,1)-AJ372,2),Round,2,FALSE)+VLOOKUP(AF372,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF372,Group,7,FALSE)=\"\",0,ROUND(AJ372-0.04999,1)-AJ372+AM372)","v":0},{"$f":"IF(VLOOKUP(AF372,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF372,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\",AA373,AG373)","v":13.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA373*(1-W373)+0.004999,2)","v":13.1},null,"",13.1,0,13.1,{"$f":"(AG373-AC373)/AG373","v":0},null,11,{"$f":"SUM(AJ373:AL373)+AE373","v":13.1},null,null,{"$f":"ROUND(AC373/(1-VLOOKUP(AF373,Group,2,FALSE)),2)","v":13.1},{"$f":"IF(VLOOKUP(AF373,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ373,1)-AJ373,2),Round,2,FALSE)+VLOOKUP(AF373,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF373,Group,7,FALSE)=\"\",0,ROUND(AJ373-0.04999,1)-AJ373+AM373)","v":0},{"$f":"IF(VLOOKUP(AF373,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF373,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\",AA374,AG374)","v":15.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA374*(1-W374)+0.004999,2)","v":15.35},null,"",15.35,0,15.35,{"$f":"(AG374-AC374)/AG374","v":0},null,11,{"$f":"SUM(AJ374:AL374)+AE374","v":15.35},null,null,{"$f":"ROUND(AC374/(1-VLOOKUP(AF374,Group,2,FALSE)),2)","v":15.35},{"$f":"IF(VLOOKUP(AF374,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ374,1)-AJ374,2),Round,2,FALSE)+VLOOKUP(AF374,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF374,Group,7,FALSE)=\"\",0,ROUND(AJ374-0.04999,1)-AJ374+AM374)","v":0},{"$f":"IF(VLOOKUP(AF374,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF374,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\",AA376,AG376)","v":31.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA376*(1-W376)+0.004999,2)","v":31.1},null,"",31.1,{"$f":"+W376","v":0},{"$f":"+X376","v":31.1},{"$f":"(AG376-AC376)/AG376","v":0},null,13,{"$f":"SUM(AJ376:AL376)+AE376","v":31.1},null,null,{"$f":"ROUND(AC376/(1-VLOOKUP(AF376,Group,2,FALSE)),2)","v":31.1},{"$f":"IF(VLOOKUP(AF376,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ376,1)-AJ376,2),Round,2,FALSE)+VLOOKUP(AF376,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF376,Group,7,FALSE)=\"\",0,ROUND(AJ376-0.04999,1)-AJ376+AM376)","v":0},{"$f":"IF(VLOOKUP(AF376,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF376,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PACIFIC - Porcelain",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\",AA382,AG382)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA382*(1-W382)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W382","v":0},{"$f":"+X382","v":12.75},{"$f":"(AG382-AC382)/AG382","v":0},null,11,{"$f":"SUM(AJ382:AL382)+AE382","v":12.75},null,null,{"$f":"ROUND(AC382/(1-VLOOKUP(AF382,Group,2,FALSE)),2)","v":12.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,null,null,"Decorative Patterns:"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field",null,null,"Carmel",null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA386,AG386)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA386*(1-W386)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W386","v":0},12.75,{"$f":"(AG386-AC386)/AG386","v":0},null,11,{"$f":"SUM(AJ386:AL386)+AE386","v":12.75},null,null,{"$f":"ROUND(AC386/(1-VLOOKUP(AF386,Group,2,FALSE)),2)","v":12.75},{"$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,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field",null,null,"Laguna",null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA387,AG387)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA387*(1-W387)+0.004999,2)","v":12.75},null,"",12.75,0,12.75,{"$f":"(AG387-AC387)/AG387","v":0},null,11,{"$f":"SUM(AJ387:AL387)+AE387","v":12.75},null,null,{"$f":"ROUND(AC387/(1-VLOOKUP(AF387,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF387,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ387,1)-AJ387,2),Round,2,FALSE)+VLOOKUP(AF387,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF387,Group,7,FALSE)=\"\",0,ROUND(AJ387-0.04999,1)-AJ387+AM387)","v":0},{"$f":"IF(VLOOKUP(AF387,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF387,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field",null,null,"Lodi",null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA388,AG388)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA388*(1-W388)+0.004999,2)","v":12.75},null,"",12.75,0,12.75,{"$f":"(AG388-AC388)/AG388","v":0},null,11,{"$f":"SUM(AJ388:AL388)+AE388","v":12.75},null,null,{"$f":"ROUND(AC388/(1-VLOOKUP(AF388,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF388,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ388,1)-AJ388,2),Round,2,FALSE)+VLOOKUP(AF388,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF388,Group,7,FALSE)=\"\",0,ROUND(AJ388-0.04999,1)-AJ388+AM388)","v":0},{"$f":"IF(VLOOKUP(AF388,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF388,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field",null,null,"Ojai",null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA389,AG389)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA389*(1-W389)+0.004999,2)","v":12.75},null,"",12.75,0,12.75,{"$f":"(AG389-AC389)/AG389","v":0},null,11,{"$f":"SUM(AJ389:AL389)+AE389","v":12.75},null,null,{"$f":"ROUND(AC389/(1-VLOOKUP(AF389,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF389,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ389,1)-AJ389,2),Round,2,FALSE)+VLOOKUP(AF389,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF389,Group,7,FALSE)=\"\",0,ROUND(AJ389-0.04999,1)-AJ389+AM389)","v":0},{"$f":"IF(VLOOKUP(AF389,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF389,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PASTICHE - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNPS",null,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:","Glinting Gray",null,"     Opalescent White"]
[null,null,null,null,"Lustrous Blue",null,"     Radiant Pink"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 10.2\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"5.38 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA396,AG396)","v":16.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA396*(1-W396)+0.004999,2)","v":16.5},null,"",16.5,{"$f":"+W396","v":0},{"$f":"+X396","v":16.5},{"$f":"(AG396-AC396)/AG396","v":0},null,11,{"$f":"SUM(AJ396:AL396)+AE396","v":16.5},null,null,{"$f":"ROUND(AC396/(1-VLOOKUP(AF396,Group,2,FALSE)),2)","v":16.5},{"$f":"IF(VLOOKUP(AF396,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ396,1)-AJ396,2),Round,2,FALSE)+VLOOKUP(AF396,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF396,Group,7,FALSE)=\"\",0,ROUND(AJ396-0.04999,1)-AJ396+AM396)","v":0},{"$f":"IF(VLOOKUP(AF396,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF396,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW",null,null,"2.5\" x 10.2\" x 5/16\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA398,AG398)","v":10.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA398*(1-W398)+0.004999,2)","v":10.85},null,"",10.85,{"$f":"+W398","v":0},{"$f":"+X398","v":10.85},{"$f":"(AG398-AC398)/AG398","v":0},null,12,{"$f":"SUM(AJ398:AL398)+AE398","v":10.85},null,null,{"$f":"ROUND(AC398/(1-VLOOKUP(AF398,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF398,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ398,1)-AJ398,2),Round,2,FALSE)+VLOOKUP(AF398,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF398,Group,7,FALSE)=\"\",0,ROUND(AJ398-0.04999,1)-AJ398+AM398)","v":0},{"$f":"IF(VLOOKUP(AF398,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF398,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Each carton contains a random assortment of 5 patterns and a solid tile, approximately 2/3rd solid tiles and 1/3rd decorative tiles."]
[]
[null,null,"PETRIFIED WOOD - Porcelain",null,null,null,null,null,null,"Discontinued 2/15/24",null,null,null,null," ",null,null,"Item # Lookup:","CNPW",null,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:","Ashen             Chestnut             Charred             Maple             Whitewood"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 16\"",null,"Field - Chevron",null,null,null,null,null,null,null,null,"10.33 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA406,AG406)","v":13.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA406*(1-W406)+0.004999,2)","v":13.9},null,"",13.9,{"$f":"+W406","v":0},{"$f":"+X406","v":13.9},{"$f":"(AG406-AC406)/AG406","v":0},null,11,{"$f":"SUM(AJ406:AL406)+AE406","v":13.9},null,null,{"$f":"ROUND(AC406/(1-VLOOKUP(AF406,Group,2,FALSE)),2)","v":13.9},{"$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,null,"PIAZZA - Ceramic",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,"11.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA412,AG412)","v":14.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA412*(1-W412)+0.004999,2)","v":14.6},null,"",14.6,{"$f":"+W412","v":0},{"$f":"+X412","v":14.6},{"$f":"(AG412-AC412)/AG412","v":0},null,11,{"$f":"SUM(AJ412:AL412)+AE412","v":14.6},null,null,{"$f":"ROUND(AC412/(1-VLOOKUP(AF412,Group,2,FALSE)),2)","v":14.6},{"$f":"IF(VLOOKUP(AF412,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ412,1)-AJ412,2),Round,2,FALSE)+VLOOKUP(AF412,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF412,Group,7,FALSE)=\"\",0,ROUND(AJ412-0.04999,1)-AJ412+AM412)","v":0},{"$f":"IF(VLOOKUP(AF412,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF412,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PICCADILLY - Recycled Glass",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNPI",null,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",null,"Grey",null,"         Pink",null,"  Turquoise"]
[null,null,null,null,"Blue",null,"Khaki",null,"         Sand",null,"  White"]
[null,null,null,null,"Burgundy",null,"Mustard",null,"         Taupe"]
[]
[null,"Decos - MLW",null,null,"12.6\" x 11.42\" x 1/8\"",null,"Mosaic",null,null,"2\" Hexagon",null,null,"(0.98 SF/Sheet)",null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA420,AG420)","v":29.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA420*(1-W420)+0.004999,2)","v":29.6},null,"",29.6,{"$f":"+W420","v":0},{"$f":"+X420","v":29.6},{"$f":"(AG420-AC420)/AG420","v":0},null,13,{"$f":"SUM(AJ420:AL420)+AE420","v":29.6},null,null,{"$f":"ROUND(AC420/(1-VLOOKUP(AF420,Group,2,FALSE)),2)","v":29.6},{"$f":"IF(VLOOKUP(AF420,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ420,1)-AJ420,2),Round,2,FALSE)+VLOOKUP(AF420,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF420,Group,7,FALSE)=\"\",0,ROUND(AJ420-0.04999,1)-AJ420+AM420)","v":0},{"$f":"IF(VLOOKUP(AF420,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF420,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PLUME - Ceramic",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\",AA428,AG428)","v":22.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA428*(1-W428)+0.004999,2)","v":22.55},null,"",22.55,{"$f":"+W428","v":0},{"$f":"+X428","v":22.55},{"$f":"(AG428-AC428)/AG428","v":0},null,11,{"$f":"SUM(AJ428:AL428)+AE428","v":22.55},null,null,{"$f":"ROUND(AC428/(1-VLOOKUP(AF428,Group,2,FALSE)),2)","v":22.55},{"$f":"IF(VLOOKUP(AF428,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ428,1)-AJ428,2),Round,2,FALSE)+VLOOKUP(AF428,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF428,Group,7,FALSE)=\"\",0,ROUND(AJ428-0.04999,1)-AJ428+AM428)","v":0},{"$f":"IF(VLOOKUP(AF428,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF428,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\",AA430,AG430)","v":9.9499999999999993},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA430*(1-W430)+0.004999,2)","v":9.9499999999999993},null,"",9.9499999999999993,{"$f":"+W430","v":0},{"$f":"+X430","v":9.9499999999999993},{"$f":"(AG430-AC430)/AG430","v":0},null,12,{"$f":"SUM(AJ430:AL430)+AE430","v":9.9499999999999993},null,null,{"$f":"ROUND(AC430/(1-VLOOKUP(AF430,Group,2,FALSE)),2)","v":9.9499999999999993},{"$f":"IF(VLOOKUP(AF430,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ430,1)-AJ430,2),Round,2,FALSE)+VLOOKUP(AF430,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF430,Group,7,FALSE)=\"\",0,ROUND(AJ430-0.04999,1)-AJ430+AM430)","v":0},{"$f":"IF(VLOOKUP(AF430,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF430,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PORTOFINO - Porcelain",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\",AA437,AG437)","v":15.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA437*(1-W437)+0.004999,2)","v":15.65},null,"new",15.65,{"$f":"+W437","v":0},{"$f":"+X437","v":15.65},{"$f":"(AG437-AC437)/AG437","v":0},null,11,{"$f":"SUM(AJ437:AL437)+AE437","v":15.65},null,null,{"$f":"ROUND(AC437/(1-VLOOKUP(AF437,Group,2,FALSE)),2)","v":15.65},{"$f":"IF(VLOOKUP(AF437,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ437,1)-AJ437,2),Round,2,FALSE)+VLOOKUP(AF437,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF437,Group,7,FALSE)=\"\",0,ROUND(AJ437-0.04999,1)-AJ437+AM437)","v":0},{"$f":"IF(VLOOKUP(AF437,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF437,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PYRAMID - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNPY",null,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             Dark Grey             Ivory             Khaki             Light Grey             White"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 5\" x 1/4\"",null,"Field",null,null,null,null,null,null,null,null,"2.64 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA443,AG443)","v":24.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA443*(1-W443)+0.004999,2)","v":24.15},null,"",24.15,{"$f":"+W443","v":0},{"$f":"+X443","v":24.15},{"$f":"(AG443-AC443)/AG443","v":0},null,11,{"$f":"SUM(AJ443:AL443)+AE443","v":24.15},null,null,{"$f":"ROUND(AC443/(1-VLOOKUP(AF443,Group,2,FALSE)),2)","v":24.15},{"$f":"IF(VLOOKUP(AF443,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ443,1)-AJ443,2),Round,2,FALSE)+VLOOKUP(AF443,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF443,Group,7,FALSE)=\"\",0,ROUND(AJ443-0.04999,1)-AJ443+AM443)","v":0},{"$f":"IF(VLOOKUP(AF443,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF443,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\",AA445,AG445)","v":12.95},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA445*(1-W445)+0.004999,2)","v":12.95},null,"",12.95,{"$f":"+W445","v":0},{"$f":"+X445","v":12.95},{"$f":"(AG445-AC445)/AG445","v":0},null,12,{"$f":"SUM(AJ445:AL445)+AE445","v":12.95},null,null,{"$f":"ROUND(AC445/(1-VLOOKUP(AF445,Group,2,FALSE)),2)","v":12.95},{"$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,null,"QUADRANT - Ceramic",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\",AA451,AG451)","v":14.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA451*(1-W451)+0.004999,2)","v":14.45},null,"",14.45,{"$f":"+W451","v":0},{"$f":"+X451","v":14.45},{"$f":"(AG451-AC451)/AG451","v":0},null,11,{"$f":"SUM(AJ451:AL451)+AE451","v":14.45},null,null,{"$f":"ROUND(AC451/(1-VLOOKUP(AF451,Group,2,FALSE)),2)","v":14.45},{"$f":"IF(VLOOKUP(AF451,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ451,1)-AJ451,2),Round,2,FALSE)+VLOOKUP(AF451,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF451,Group,7,FALSE)=\"\",0,ROUND(AJ451-0.04999,1)-AJ451+AM451)","v":0},{"$f":"IF(VLOOKUP(AF451,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF451,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"QUARRY - Porcelain",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",null,null,"Hexagon",null,null,null,null,null,"9.04 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA458,AG458)","v":13.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA458*(1-W458)+0.004999,2)","v":13.8},null,"",13.8,{"$f":"+W458","v":0},{"$f":"+X458","v":13.8},{"$f":"(AG458-AC458)/AG458","v":0},null,11,{"$f":"SUM(AJ458:AL458)+AE458","v":13.8},null,null,{"$f":"ROUND(AC458/(1-VLOOKUP(AF458,Group,2,FALSE)),2)","v":13.8},{"$f":"IF(VLOOKUP(AF458,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ458,1)-AJ458,2),Round,2,FALSE)+VLOOKUP(AF458,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF458,Group,7,FALSE)=\"\",0,ROUND(AJ458-0.04999,1)-AJ458+AM458)","v":0},{"$f":"IF(VLOOKUP(AF458,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF458,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"RAINFOREST - Ceramic",null,null,null,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\",AA464,AG464)","v":19.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA464*(1-W464)+0.004999,2)","v":19.05},null,"",19.05,{"$f":"+W464","v":0},{"$f":"+X464","v":19.05},{"$f":"(AG464-AC464)/AG464","v":0},null,11,{"$f":"SUM(AJ464:AL464)+AE464","v":19.05},null,null,{"$f":"ROUND(AC464/(1-VLOOKUP(AF464,Group,2,FALSE)),2)","v":19.05},{"$f":"IF(VLOOKUP(AF464,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ464,1)-AJ464,2),Round,2,FALSE)+VLOOKUP(AF464,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF464,Group,7,FALSE)=\"\",0,ROUND(AJ464-0.04999,1)-AJ464+AM464)","v":0},{"$f":"IF(VLOOKUP(AF464,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF464,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"SEDONA - Ceramic",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\",AA471,AG471)","v":15.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA471*(1-W471)+0.004999,2)","v":15.95},null,"",15.95,{"$f":"+W471","v":0},15.95,{"$f":"(AG471-AC471)/AG471","v":0},null,11,{"$f":"SUM(AJ471:AL471)+AE471","v":15.95},null,null,{"$f":"ROUND(AC471/(1-VLOOKUP(AF471,Group,2,FALSE)),2)","v":15.95},{"$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,"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\",AA472,AG472)","v":16.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA472*(1-W472)+0.004999,2)","v":16.2},null,"",16.2,0,16.2,{"$f":"(AG472-AC472)/AG472","v":0},null,11,{"$f":"SUM(AJ472:AL472)+AE472","v":16.2},null,null,{"$f":"ROUND(AC472/(1-VLOOKUP(AF472,Group,2,FALSE)),2)","v":16.2},{"$f":"IF(VLOOKUP(AF472,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ472,1)-AJ472,2),Round,2,FALSE)+VLOOKUP(AF472,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF472,Group,7,FALSE)=\"\",0,ROUND(AJ472-0.04999,1)-AJ472+AM472)","v":0},{"$f":"IF(VLOOKUP(AF472,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF472,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\",AA473,AG473)","v":16.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA473*(1-W473)+0.004999,2)","v":16.75},null,"",16.75,0,16.75,{"$f":"(AG473-AC473)/AG473","v":0},null,11,{"$f":"SUM(AJ473:AL473)+AE473","v":16.75},null,null,{"$f":"ROUND(AC473/(1-VLOOKUP(AF473,Group,2,FALSE)),2)","v":16.75},{"$f":"IF(VLOOKUP(AF473,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ473,1)-AJ473,2),Round,2,FALSE)+VLOOKUP(AF473,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF473,Group,7,FALSE)=\"\",0,ROUND(AJ473-0.04999,1)-AJ473+AM473)","v":0},{"$f":"IF(VLOOKUP(AF473,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF473,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\",AA475,AG475)","v":10.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA475*(1-W475)+0.004999,2)","v":10.7},null,"",10.7,{"$f":"+W475","v":0},{"$f":"+X475","v":10.7},{"$f":"(AG475-AC475)/AG475","v":0},null,12,{"$f":"SUM(AJ475:AL475)+AE475","v":10.7},null,null,{"$f":"ROUND(AC475/(1-VLOOKUP(AF475,Group,2,FALSE)),2)","v":10.7},{"$f":"IF(VLOOKUP(AF475,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ475,1)-AJ475,2),Round,2,FALSE)+VLOOKUP(AF475,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF475,Group,7,FALSE)=\"\",0,ROUND(AJ475-0.04999,1)-AJ475+AM475)","v":0},{"$f":"IF(VLOOKUP(AF475,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF475,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Available in color White only."]
[]
[null,null,"SLATE - Natural Stone",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\",AA483,AG483)","v":14.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA483*(1-W483)+0.004999,2)","v":14.75},null,"",14.75,{"$f":"+W483","v":0},{"$f":"+X483","v":14.75},{"$f":"(AG483-AC483)/AG483","v":0},null,8,{"$f":"SUM(AJ483:AL483)+AE483","v":14.75},null,null,{"$f":"ROUND(AC483/(1-VLOOKUP(AF483,Group,2,FALSE)),2)","v":14.75},{"$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,"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,14.75,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.75,null,"",14.75,0,14.75,0,null,8,14.75,null,null,14.75,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,14.8,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.8,null,"",14.8,0,14.8,0,null,8,14.8,null,null,14.8,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",25.65,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},25.65,null,"",25.65,0,25.65,0,null,8,25.65,null,null,25.65,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,13.4,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},13.4,null,"",13.4,0,13.4,0,null,8,13.4,null,null,13.4,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,13.8,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},13.8,null,"",13.8,0,13.8,0,null,8,13.8,null,null,13.8,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,14.35,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.35,null,"",14.35,0,14.35,0,null,8,14.35,null,null,14.35,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,14.4,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.4,null,"",14.4,0,14.4,0,null,8,14.4,null,null,14.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,14.9,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.9,null,"",14.9,0,14.9,0,null,8,14.9,null,null,14.9,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"18\" x 36\"",null,"Field",null,null,null,null,null,null,null,null,"9.00 SF/CTN",null,null,16.350000000000001,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},16.350000000000001,null,"",16.350000000000001,0,16.350000000000001,0,null,8,16.350000000000001,null,null,16.350000000000001,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"10\"",null,"Field",null,null,"Hexagon",null,null,null,null,null,"6.00 SF/CTN",null,null,25.65,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},25.65,null,"",25.65,0,25.65,0,null,8,25.65,null,null,25.65,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"2-3/4\" x 11\"",null,"Field",null,null,"Picket",null,null,null,null,null,"10.55 SF/CTN",null,null,17.5,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},17.5,null,"",17.5,0,17.5,0,null,8,17.5,null,null,17.5,0,0,"",null,"X"]
[]
[null,"Decos - MLW Stone",null,null,"15.5\" x 18\"",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\",AA496,AG496)","v":55},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA496*(1-W496)+0.004999,2)","v":55},null,"",55,{"$f":"+W496","v":0},{"$f":"+X496","v":55},{"$f":"(AG496-AC496)/AG496","v":0},null,10,{"$f":"SUM(AJ496:AL496)+AE496","v":55},null,null,{"$f":"ROUND(AC496/(1-VLOOKUP(AF496,Group,2,FALSE)),2)","v":55},{"$f":"IF(VLOOKUP(AF496,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ496,1)-AJ496,2),Round,2,FALSE)+VLOOKUP(AF496,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF496,Group,7,FALSE)=\"\",0,ROUND(AJ496-0.04999,1)-AJ496+AM496)","v":0},{"$f":"IF(VLOOKUP(AF496,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF496,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\",AA497,AG497)","v":32.200000000000003},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA497*(1-W497)+0.004999,2)","v":32.200000000000003},null,"",32.200000000000003,{"$f":"+W497","v":0},32.200000000000003,{"$f":"(AG497-AC497)/AG497","v":0},null,10,{"$f":"SUM(AJ497:AL497)+AE497","v":32.200000000000003},null,null,{"$f":"ROUND(AC497/(1-VLOOKUP(AF497,Group,2,FALSE)),2)","v":32.200000000000003},{"$f":"IF(VLOOKUP(AF497,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ497,1)-AJ497,2),Round,2,FALSE)+VLOOKUP(AF497,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF497,Group,7,FALSE)=\"\",0,ROUND(AJ497-0.04999,1)-AJ497+AM497)","v":0},{"$f":"IF(VLOOKUP(AF497,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF497,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\",AA498,AG498)","v":51.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA498*(1-W498)+0.004999,2)","v":51.7},null,"",51.7,{"$f":"+W498","v":0},{"$f":"+X498","v":51.7},{"$f":"(AG498-AC498)/AG498","v":0},null,10,{"$f":"SUM(AJ498:AL498)+AE498","v":51.7},null,null,{"$f":"ROUND(AC498/(1-VLOOKUP(AF498,Group,2,FALSE)),2)","v":51.7},{"$f":"IF(VLOOKUP(AF498,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ498,1)-AJ498,2),Round,2,FALSE)+VLOOKUP(AF498,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF498,Group,7,FALSE)=\"\",0,ROUND(AJ498-0.04999,1)-AJ498+AM498)","v":0},{"$f":"IF(VLOOKUP(AF498,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF498,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\",AA499,AG499)","v":55.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA499*(1-W499)+0.004999,2)","v":55.45},null,"",55.45,0,55.45,{"$f":"(AG499-AC499)/AG499","v":0},null,10,{"$f":"SUM(AJ499:AL499)+AE499","v":55.45},null,null,{"$f":"ROUND(AC499/(1-VLOOKUP(AF499,Group,2,FALSE)),2)","v":55.45},{"$f":"IF(VLOOKUP(AF499,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ499,1)-AJ499,2),Round,2,FALSE)+VLOOKUP(AF499,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF499,Group,7,FALSE)=\"\",0,ROUND(AJ499-0.04999,1)-AJ499+AM499)","v":0},{"$f":"IF(VLOOKUP(AF499,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF499,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"continued on next page"]
[null,null,"SLATE - Natural Stone - continued",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CNSL"]
[]
[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\",AA506,AG506)","v":14.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA506*(1-W506)+0.004999,2)","v":14.75},null,"",14.75,{"$f":"+W506","v":0},{"$f":"+X506","v":14.75},{"$f":"(AG506-AC506)/AG506","v":0},null,8,{"$f":"SUM(AJ506:AL506)+AE506","v":14.75},null,null,{"$f":"ROUND(AC506/(1-VLOOKUP(AF506,Group,2,FALSE)),2)","v":14.75},{"$f":"IF(VLOOKUP(AF506,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ506,1)-AJ506,2),Round,2,FALSE)+VLOOKUP(AF506,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF506,Group,7,FALSE)=\"\",0,ROUND(AJ506-0.04999,1)-AJ506+AM506)","v":0},{"$f":"IF(VLOOKUP(AF506,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF506,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,14.75,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.75,null,"",14.75,0,14.75,0,null,8,14.75,null,null,14.75,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,14.8,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.8,null,"",14.8,0,14.8,0,null,8,14.8,null,null,14.8,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",25.65,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},25.65,null,"",25.65,0,25.65,0,null,8,25.65,null,null,25.65,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,13.4,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},13.4,null,"",13.4,0,13.4,0,null,8,13.4,null,null,13.4,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,13.8,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},13.8,null,"",13.8,0,13.8,0,null,8,13.8,null,null,13.8,0,0,"",null,"X"]
[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,14.35,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.35,null,"",14.35,0,14.35,0,null,8,14.35,null,null,14.35,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,"a",26.15,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},26.15,null,"",26.15,0,26.15,0,null,8,26.15,null,null,26.15,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,14.9,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.9,null,"",14.9,0,14.9,0,null,8,14.9,null,null,14.9,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"10\"",null,"Field",null,null,"Hexagon",null,null,null,null,null,"6.00 SF/CTN",null,null,25.65,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},25.65,null,"",25.65,0,25.65,0,null,8,25.65,null,null,25.65,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"2-3/4\" x 11\"",null,"Field",null,null,"Picket",null,null,null,null,null,"10.55 SF/CTN",null,null,17.5,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},17.5,null,"",17.5,0,17.5,0,null,8,17.5,null,null,17.5,0,0,"",null,"X"]
[]
[null,"Decos - MLW Stone",null,null,"15.5\" x 18\"",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\",AA518,AG518)","v":55},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA518*(1-W518)+0.004999,2)","v":55},null,"",55,{"$f":"+W518","v":0},{"$f":"+X518","v":55},{"$f":"(AG518-AC518)/AG518","v":0},null,10,{"$f":"SUM(AJ518:AL518)+AE518","v":55},null,null,{"$f":"ROUND(AC518/(1-VLOOKUP(AF518,Group,2,FALSE)),2)","v":55},{"$f":"IF(VLOOKUP(AF518,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ518,1)-AJ518,2),Round,2,FALSE)+VLOOKUP(AF518,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF518,Group,7,FALSE)=\"\",0,ROUND(AJ518-0.04999,1)-AJ518+AM518)","v":0},{"$f":"IF(VLOOKUP(AF518,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF518,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,b",{"$f":"IF(Suggested=\"Yes\",AA519,AG519)","v":54.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA519*(1-W519)+0.004999,2)","v":54.85},null,"",54.85,{"$f":"+W519","v":0},54.85,{"$f":"(AG519-AC519)/AG519","v":0},null,10,{"$f":"SUM(AJ519:AL519)+AE519","v":54.85},null,null,{"$f":"ROUND(AC519/(1-VLOOKUP(AF519,Group,2,FALSE)),2)","v":54.85},{"$f":"IF(VLOOKUP(AF519,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ519,1)-AJ519,2),Round,2,FALSE)+VLOOKUP(AF519,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF519,Group,7,FALSE)=\"\",0,ROUND(AJ519-0.04999,1)-AJ519+AM519)","v":0},{"$f":"IF(VLOOKUP(AF519,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF519,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\",AA520,AG520)","v":55.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA520*(1-W520)+0.004999,2)","v":55.45},null,"",55.45,0,55.45,{"$f":"(AG520-AC520)/AG520","v":0},null,10,{"$f":"SUM(AJ520:AL520)+AE520","v":55.45},null,null,{"$f":"ROUND(AC520/(1-VLOOKUP(AF520,Group,2,FALSE)),2)","v":55.45},{"$f":"IF(VLOOKUP(AF520,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ520,1)-AJ520,2),Round,2,FALSE)+VLOOKUP(AF520,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF520,Group,7,FALSE)=\"\",0,ROUND(AJ520-0.04999,1)-AJ520+AM520)","v":0},{"$f":"IF(VLOOKUP(AF520,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF520,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Special Order - approximately 3-4 weeks.",null,null,null,null,null,"b) Minimum purchase is 13.60 SF, (2 cartons)."]
[]
[null,null,"STELLA - Porcelain",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\",AA528,AG528)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA528*(1-W528)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W528","v":0},{"$f":"+X528","v":12.75},{"$f":"(AG528-AC528)/AG528","v":0},null,11,{"$f":"SUM(AJ528:AL528)+AE528","v":12.75},null,null,{"$f":"ROUND(AC528/(1-VLOOKUP(AF528,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF528,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ528,1)-AJ528,2),Round,2,FALSE)+VLOOKUP(AF528,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF528,Group,7,FALSE)=\"\",0,ROUND(AJ528-0.04999,1)-AJ528+AM528)","v":0},{"$f":"IF(VLOOKUP(AF528,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF528,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field",null,null,"Star",null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA530,AG530)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA530*(1-W530)+0.004999,2)","v":12.75},null,"",12.75,{"$f":"+W530","v":0},{"$f":"+X530","v":12.75},{"$f":"(AG530-AC530)/AG530","v":0},null,11,{"$f":"SUM(AJ530:AL530)+AE530","v":12.75},null,null,{"$f":"ROUND(AC530/(1-VLOOKUP(AF530,Group,2,FALSE)),2)","v":12.75},{"$f":"IF(VLOOKUP(AF530,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ530,1)-AJ530,2),Round,2,FALSE)+VLOOKUP(AF530,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF530,Group,7,FALSE)=\"\",0,ROUND(AJ530-0.04999,1)-AJ530+AM530)","v":0},{"$f":"IF(VLOOKUP(AF530,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF530,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"STONE CLASSICS - Porcelain",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\",AA537,AG537)","v":14},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA537*(1-W537)+0.004999,2)","v":14},null,"",14,{"$f":"+W537","v":0},{"$f":"+X537","v":14},{"$f":"(AG537-AC537)/AG537","v":0},null,11,{"$f":"SUM(AJ537:AL537)+AE537","v":14},null,null,{"$f":"ROUND(AC537/(1-VLOOKUP(AF537,Group,2,FALSE)),2)","v":14},{"$f":"IF(VLOOKUP(AF537,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ537,1)-AJ537,2),Round,2,FALSE)+VLOOKUP(AF537,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF537,Group,7,FALSE)=\"\",0,ROUND(AJ537-0.04999,1)-AJ537+AM537)","v":0},{"$f":"IF(VLOOKUP(AF537,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF537,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"TERRACOTTA - Porcelain",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\",AA543,AG543)","v":14.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA543*(1-W543)+0.004999,2)","v":14.2},null,"",14.2,{"$f":"+W543","v":0},{"$f":"+X543","v":14.2},{"$f":"(AG543-AC543)/AG543","v":0},null,11,{"$f":"SUM(AJ543:AL543)+AE543","v":14.2},null,null,{"$f":"ROUND(AC543/(1-VLOOKUP(AF543,Group,2,FALSE)),2)","v":14.2},{"$f":"IF(VLOOKUP(AF543,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ543,1)-AJ543,2),Round,2,FALSE)+VLOOKUP(AF543,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF543,Group,7,FALSE)=\"\",0,ROUND(AJ543-0.04999,1)-AJ543+AM543)","v":0},{"$f":"IF(VLOOKUP(AF543,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF543,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"URBAN - Porcelain",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\",AA549,AG549)","v":18.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA549*(1-W549)+0.004999,2)","v":18.3},null,"",18.3,{"$f":"+W549","v":0},18.3,{"$f":"(AG549-AC549)/AG549","v":0},null,11,{"$f":"SUM(AJ549:AL549)+AE549","v":18.3},null,null,{"$f":"ROUND(AC549/(1-VLOOKUP(AF549,Group,2,FALSE)),2)","v":18.3},{"$f":"IF(VLOOKUP(AF549,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ549,1)-AJ549,2),Round,2,FALSE)+VLOOKUP(AF549,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF549,Group,7,FALSE)=\"\",0,ROUND(AJ549-0.04999,1)-AJ549+AM549)","v":0},{"$f":"IF(VLOOKUP(AF549,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF549,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\",AA550,AG550)","v":17.899999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA550*(1-W550)+0.004999,2)","v":17.899999999999999},null,"",17.899999999999999,0,17.899999999999999,{"$f":"(AG550-AC550)/AG550","v":0},null,11,{"$f":"SUM(AJ550:AL550)+AE550","v":17.899999999999999},null,null,{"$f":"ROUND(AC550/(1-VLOOKUP(AF550,Group,2,FALSE)),2)","v":17.899999999999999},{"$f":"IF(VLOOKUP(AF550,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ550,1)-AJ550,2),Round,2,FALSE)+VLOOKUP(AF550,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF550,Group,7,FALSE)=\"\",0,ROUND(AJ550-0.04999,1)-AJ550+AM550)","v":0},{"$f":"IF(VLOOKUP(AF550,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF550,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\",AA551,AG551)","v":17.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA551*(1-W551)+0.004999,2)","v":17.05},null,"",17.05,0,17.05,{"$f":"(AG551-AC551)/AG551","v":0},null,11,{"$f":"SUM(AJ551:AL551)+AE551","v":17.05},null,null,{"$f":"ROUND(AC551/(1-VLOOKUP(AF551,Group,2,FALSE)),2)","v":17.05},{"$f":"IF(VLOOKUP(AF551,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ551,1)-AJ551,2),Round,2,FALSE)+VLOOKUP(AF551,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF551,Group,7,FALSE)=\"\",0,ROUND(AJ551-0.04999,1)-AJ551+AM551)","v":0},{"$f":"IF(VLOOKUP(AF551,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF551,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"4.5\" x 4.5\"",null,"Field",null,null,"Decorative",null,null,null,null,null,"5.42 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA553,AG553)","v":21.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA553*(1-W553)+0.004999,2)","v":21.3},null,"",21.3,{"$f":"+W553","v":0},{"$f":"+X553","v":21.3},{"$f":"(AG553-AC553)/AG553","v":0},null,11,{"$f":"SUM(AJ553:AL553)+AE553","v":21.3},null,null,{"$f":"ROUND(AC553/(1-VLOOKUP(AF553,Group,2,FALSE)),2)","v":21.3},{"$f":"IF(VLOOKUP(AF553,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ553,1)-AJ553,2),Round,2,FALSE)+VLOOKUP(AF553,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF553,Group,7,FALSE)=\"\",0,ROUND(AJ553-0.04999,1)-AJ553+AM553)","v":0},{"$f":"IF(VLOOKUP(AF553,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF553,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\",AA555,AG555)","v":19.399999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA555*(1-W555)+0.004999,2)","v":19.399999999999999},null,"",19.399999999999999,{"$f":"+W555","v":0},{"$f":"+X555","v":19.399999999999999},{"$f":"(AG555-AC555)/AG555","v":0},null,12,{"$f":"SUM(AJ555:AL555)+AE555","v":19.399999999999999},null,null,{"$f":"ROUND(AC555/(1-VLOOKUP(AF555,Group,2,FALSE)),2)","v":19.399999999999999},{"$f":"IF(VLOOKUP(AF555,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ555,1)-AJ555,2),Round,2,FALSE)+VLOOKUP(AF555,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF555,Group,7,FALSE)=\"\",0,ROUND(AJ555-0.04999,1)-AJ555+AM555)","v":0},{"$f":"IF(VLOOKUP(AF555,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF555,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,null,null,"6.14 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA561,AG561)","v":29.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA561*(1-W561)+0.004999,2)","v":29.8},null,"",29.8,{"$f":"+W561","v":0},{"$f":"+X561","v":29.8},{"$f":"(AG561-AC561)/AG561","v":0},null,11,{"$f":"SUM(AJ561:AL561)+AE561","v":29.8},null,null,{"$f":"ROUND(AC561/(1-VLOOKUP(AF561,Group,2,FALSE)),2)","v":29.8},{"$f":"IF(VLOOKUP(AF561,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ561,1)-AJ561,2),Round,2,FALSE)+VLOOKUP(AF561,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF561,Group,7,FALSE)=\"\",0,ROUND(AJ561-0.04999,1)-AJ561+AM561)","v":0},{"$f":"IF(VLOOKUP(AF561,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF561,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"6\" x 6\"",null,"Field - Star",null,null,null,null,null,null,null,null,"4.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA562,AG562)","v":30.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA562*(1-W562)+0.004999,2)","v":30.2},null,"",30.2,{"$f":"+W562","v":0},{"$f":"+X562","v":30.2},{"$f":"(AG562-AC562)/AG562","v":0},null,11,{"$f":"SUM(AJ562:AL562)+AE562","v":30.2},null,null,{"$f":"ROUND(AC562/(1-VLOOKUP(AF562,Group,2,FALSE)),2)","v":30.2},{"$f":"IF(VLOOKUP(AF562,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ562,1)-AJ562,2),Round,2,FALSE)+VLOOKUP(AF562,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF562,Group,7,FALSE)=\"\",0,ROUND(AJ562-0.04999,1)-AJ562+AM562)","v":0},{"$f":"IF(VLOOKUP(AF562,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF562,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\",AA564,AG564)","v":17.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA564*(1-W564)+0.004999,2)","v":17.75},null,"",17.75,{"$f":"+W564","v":0},{"$f":"+X564","v":17.75},{"$f":"(AG564-AC564)/AG564","v":0},null,11,{"$f":"SUM(AJ564:AL564)+AE564","v":17.75},null,null,{"$f":"ROUND(AC564/(1-VLOOKUP(AF564,Group,2,FALSE)),2)","v":17.75},{"$f":"IF(VLOOKUP(AF564,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ564,1)-AJ564,2),Round,2,FALSE)+VLOOKUP(AF564,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF564,Group,7,FALSE)=\"\",0,ROUND(AJ564-0.04999,1)-AJ564+AM564)","v":0},{"$f":"IF(VLOOKUP(AF564,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF564,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"WOODRIDGE - Ceramic",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\",AA570,AG570)","v":16.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA570*(1-W570)+0.004999,2)","v":16.7},null,"",16.7,{"$f":"+W570","v":0},{"$f":"+X570","v":16.7},{"$f":"(AG570-AC570)/AG570","v":0},null,11,{"$f":"SUM(AJ570:AL570)+AE570","v":16.7},null,null,{"$f":"ROUND(AC570/(1-VLOOKUP(AF570,Group,2,FALSE)),2)","v":16.7},{"$f":"IF(VLOOKUP(AF570,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ570,1)-AJ570,2),Round,2,FALSE)+VLOOKUP(AF570,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF570,Group,7,FALSE)=\"\",0,ROUND(AJ570-0.04999,1)-AJ570+AM570)","v":0},{"$f":"IF(VLOOKUP(AF570,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF570,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":112,"n_cols":3,"rows_kept":112,"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."]
[]
[]
[]
["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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Changes"]