{"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":8,"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","5/1/25"]
[]
[]
[]
["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,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 - 5/1/25"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[1,null,"Alloy",null,"Porcelain",null,2,null,"Marmol",null,"Porcelain"]
[1,null,"Andalucia",null,"Porcelain",null,2,null,"Momentum",null,"Ceramic"]
[1,null,"Artista",null,"Porcelain",null,3,null,"Moroccan",null,"Porcelain"]
[1,null,"Atlanta Brick",null,"Porcelain",null,3,null,"Nola",null,"Porcelain"]
[1,null,"Cadence",null,"Porcelain",null,3,null,"Nola Black",null,"Porcelain"]
[1,null,"Caliza",null,"Ceramic",null,3,null,"Nomad",null,"Porcelain"]
[1,null,"Cava",null,"Porcelain",null,3,null,"Normandy",null,"Porcelain"]
[1,null,"Charleston",null,"Porcelain",null,3,null,"Onyx",null,"Porcelain"]
[1,null,"Chelsea",null,"Porcelain",null,3,null,"Pacific",null,"Porcelain"]
[1,null,"Chiclet",null,"Porcelain",null,3,null,"Piazza",null,"Ceramic"]
[1,null,"Cotto Brick",null,"Porcelain",null,3,null,"Plume",null,"Ceramic"]
[1,null,"Empire",null,"Ceramic",null,3,null,"Portofino",null,"Porcelain"]
[1,null,"Gatsby",null,"Porcelain",null,3,null,"Quadrant",null,"Ceramic"]
[1,null,"Gesso",null,"Porcelain",null,3,null,"Quarry",null,"Porcelain"]
[2,null,"Gibraltar",null,"Porcelain",null,3,null,"Rainforest",null,"Ceramic"]
[2,null,"Grand Canyon",null,"Ceramic",null,4,null,"Sedona",null,"Ceramic"]
[2,null,"Hampstead",null,"Porcelain",null,4,null,"Slate",null,"Natural Stone"]
[2,null,"Havana",null,"Ceramic",null,4,null,"Stella",null,"Porcelain"]
[2,null,"Hudson Brick",null,"Porcelain",null,4,null,"Stone Classics",null,"Porcelain"]
[2,null,"Italia",null,"Porcelain",null,4,null,"Terracotta",null,"Porcelain"]
[2,null,"Kingston Wood",null,"Porcelain",null,5,null,"Urban",null,"Porcelain"]
[2,null,"Limerick",null,"Ceramic",null,5,null,"Valencia",null,"Porcelain & Ceramic"]
[2,null,"Limestone",null,"Natural Stone",null,5,null,"Vintage",null,"Ceramic"]
[2,null,"Malibu",null,"Porcelain",null,5,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":489,"n_cols":41,"rows_kept":489,"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],[475,2,475,19],[20,13,21,19],[478,3,478,4],[24,2,24,19],[23,14,23,15],[473,2,473,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":"5/1/25"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-04-02"},null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!C8=\"\",\"\",+Instructions!C8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code '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.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA33*(1-W33)+0.004999,2)","v":56.6},null,"",56.6,{"$f":"+W33","v":0},{"$f":"+X33","v":56.6},{"$f":"(AG33-AC33)/AG33","v":0},null,13,{"$f":"SUM(AJ33:AL33)+AE33","v":56.6},null,null,{"$f":"ROUND(AC33/(1-VLOOKUP(AF33,Group,2,FALSE)),2)","v":56.6},{"$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          Marbella          Seville"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA41,AG41)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA41*(1-W41)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W41","v":0},{"$f":"+X41","v":12.8},{"$f":"(AG41-AC41)/AG41","v":0},null,11,{"$f":"SUM(AJ41:AL41)+AE41","v":12.8},null,null,{"$f":"ROUND(AC41/(1-VLOOKUP(AF41,Group,2,FALSE)),2)","v":12.8},{"$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 (Decorative Pattern)",null,null,null," ",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA48,AG48)","v":13.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA48*(1-W48)+0.004999,2)","v":13.1},null,"",13.1,{"$f":"+W48","v":0},{"$f":"+X48","v":13.1},{"$f":"(AG48-AC48)/AG48","v":0},null,11,{"$f":"SUM(AJ48:AL48)+AE48","v":13.1},null,null,{"$f":"ROUND(AC48/(1-VLOOKUP(AF48,Group,2,FALSE)),2)","v":13.1},{"$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,"ATLANTA BRICK - Porcelain",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNAT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Buckhead          Midtown          Morningside          Westside"]
[]
[null,"Field Tile - MLW",null,null,"3\" x 11\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"10.87 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA54,AG54)","v":13.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA54*(1-W54)+0.004999,2)","v":13.85},null,"",13.85,{"$f":"+W54","v":0},{"$f":"+X54","v":13.85},{"$f":"(AG54-AC54)/AG54","v":0},null,11,{"$f":"SUM(AJ54:AL54)+AE54","v":13.85},null,null,{"$f":"ROUND(AC54/(1-VLOOKUP(AF54,Group,2,FALSE)),2)","v":13.85},{"$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,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,"8.8\" x 8.8\"",null,"Field (Decorative Pattern)",null,null,null,"Alley",null,null,null,null,"10.87 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA60,AG60)","v":14.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA60*(1-W60)+0.004999,2)","v":14.35},null,"",14.35,{"$f":"+W60","v":0},{"$f":"+X60","v":14.35},{"$f":"(AG60-AC60)/AG60","v":0},null,11,{"$f":"SUM(AJ60:AL60)+AE60","v":14.35},null,null,{"$f":"ROUND(AC60/(1-VLOOKUP(AF60,Group,2,FALSE)),2)","v":14.35},{"$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,"CALIZA - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNCZ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Capri          Perla"]
[]
[null,"Field Tile - MLW",null,null,"18\" x 48\" x 5/16\"",null,"Field - Carved",null,null,null,null," ",null,null,null,"18.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":16.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA66*(1-W66)+0.004999,2)","v":16.7},null,"new",16.7,{"$f":"+W66","v":0},{"$f":"+X66","v":16.7},{"$f":"(AG66-AC66)/AG66","v":0},null,11,{"$f":"SUM(AJ66:AL66)+AE66","v":16.7},null,null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":16.7},{"$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,"Field Tile - MLW",null,null,"18\" x 48\" x 5/16\"",null,"Field - Scraped",null,null,null,null," ",null,null,null,"18.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA67,AG67)","v":16.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA67*(1-W67)+0.004999,2)","v":16.7},null,"new",16.7,{"$f":"+W67","v":0},{"$f":"+X67","v":16.7},{"$f":"(AG67-AC67)/AG67","v":0},null,11,{"$f":"SUM(AJ67:AL67)+AE67","v":16.7},null,null,{"$f":"ROUND(AC67/(1-VLOOKUP(AF67,Group,2,FALSE)),2)","v":16.7},{"$f":"IF(VLOOKUP(AF67,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ67,1)-AJ67,2),Round,2,FALSE)+VLOOKUP(AF67,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF67,Group,7,FALSE)=\"\",0,ROUND(AJ67-0.04999,1)-AJ67+AM67)","v":0},{"$f":"IF(VLOOKUP(AF67,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF67,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA73,AG73)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA73*(1-W73)+0.004999,2)","v":13.5},null,"",13.5,{"$f":"+W73","v":0},{"$f":"+X73","v":13.5},{"$f":"(AG73-AC73)/AG73","v":0},null,11,{"$f":"SUM(AJ73:AL73)+AE73","v":13.5},null,null,{"$f":"ROUND(AC73/(1-VLOOKUP(AF73,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF73,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ73,1)-AJ73,2),Round,2,FALSE)+VLOOKUP(AF73,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF73,Group,7,FALSE)=\"\",0,ROUND(AJ73-0.04999,1)-AJ73+AM73)","v":0},{"$f":"IF(VLOOKUP(AF73,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF73,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,"Color:","Cromwell"]
[]
[null,"Field Tile - MLW",null,null,"13\" x 13\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"10.79 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA79,AG79)","v":13.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA79*(1-W79)+0.004999,2)","v":13.95},null,"",13.95,{"$f":"+W79","v":0},{"$f":"+X79","v":13.95},{"$f":"(AG79-AC79)/AG79","v":0},null,11,{"$f":"SUM(AJ79:AL79)+AE79","v":13.95},null,null,{"$f":"ROUND(AC79/(1-VLOOKUP(AF79,Group,2,FALSE)),2)","v":13.95},{"$f":"IF(VLOOKUP(AF79,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ79,1)-AJ79,2),Round,2,FALSE)+VLOOKUP(AF79,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF79,Group,7,FALSE)=\"\",0,ROUND(AJ79-0.04999,1)-AJ79+AM79)","v":0},{"$f":"IF(VLOOKUP(AF79,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF79,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\",AA86,AG86)","v":18.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA86*(1-W86)+0.004999,2)","v":18.05},null,"",18.05,{"$f":"+W86","v":0},{"$f":"+X86","v":18.05},{"$f":"(AG86-AC86)/AG86","v":0},null,11,{"$f":"SUM(AJ86:AL86)+AE86","v":18.05},null,null,{"$f":"ROUND(AC86/(1-VLOOKUP(AF86,Group,2,FALSE)),2)","v":18.05},{"$f":"IF(VLOOKUP(AF86,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ86,1)-AJ86,2),Round,2,FALSE)+VLOOKUP(AF86,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",0,ROUND(AJ86-0.04999,1)-AJ86+AM86)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF86,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA88,AG88)","v":24.15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA88*(1-W88)+0.004999,2)","v":24.15},null,"",24.15,{"$f":"+W88","v":0},{"$f":"+X88","v":24.15},{"$f":"(AG88-AC88)/AG88","v":0},null,12,{"$f":"SUM(AJ88:AL88)+AE88","v":24.15},null,null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":24.15},{"$f":"IF(VLOOKUP(AF88,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ88,1)-AJ88,2),Round,2,FALSE)+VLOOKUP(AF88,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",0,ROUND(AJ88-0.04999,1)-AJ88+AM88)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF88,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA95,AG95)","v":27.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA95*(1-W95)+0.004999,2)","v":27.7},null,"",27.7,{"$f":"+W95","v":0},{"$f":"+X95","v":27.7},{"$f":"(AG95-AC95)/AG95","v":0},null,13,{"$f":"SUM(AJ95:AL95)+AE95","v":27.7},null,null,{"$f":"ROUND(AC95/(1-VLOOKUP(AF95,Group,2,FALSE)),2)","v":27.7},{"$f":"IF(VLOOKUP(AF95,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ95,1)-AJ95,2),Round,2,FALSE)+VLOOKUP(AF95,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",0,ROUND(AJ95-0.04999,1)-AJ95+AM95)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF95,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\",AA101,AG101)","v":16.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA101*(1-W101)+0.004999,2)","v":16.5},null,"",16.5,{"$f":"+W101","v":0},{"$f":"+X101","v":16.5},{"$f":"(AG101-AC101)/AG101","v":0},null,11,{"$f":"SUM(AJ101:AL101)+AE101","v":16.5},null,null,{"$f":"ROUND(AC101/(1-VLOOKUP(AF101,Group,2,FALSE)),2)","v":16.5},{"$f":"IF(VLOOKUP(AF101,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ101,1)-AJ101,2),Round,2,FALSE)+VLOOKUP(AF101,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",0,ROUND(AJ101-0.04999,1)-AJ101+AM101)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF101,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\",AA102,AG102)","v":16.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA102*(1-W102)+0.004999,2)","v":16.5},null,"",16.5,{"$f":"+W102","v":0},{"$f":"+X102","v":16.5},{"$f":"(AG102-AC102)/AG102","v":0},null,11,{"$f":"SUM(AJ102:AL102)+AE102","v":16.5},null,null,{"$f":"ROUND(AC102/(1-VLOOKUP(AF102,Group,2,FALSE)),2)","v":16.5},{"$f":"IF(VLOOKUP(AF102,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ102,1)-AJ102,2),Round,2,FALSE)+VLOOKUP(AF102,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",0,ROUND(AJ102-0.04999,1)-AJ102+AM102)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF102,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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 (Decorative Pattern)",null,null,null,null,null,null,null,null,"9.60 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA108,AG108)","v":15.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA108*(1-W108)+0.004999,2)","v":15.95},null,"",15.95,{"$f":"+W108","v":0},{"$f":"+X108","v":15.95},{"$f":"(AG108-AC108)/AG108","v":0},null,11,{"$f":"SUM(AJ108:AL108)+AE108","v":15.95},null,null,{"$f":"ROUND(AC108/(1-VLOOKUP(AF108,Group,2,FALSE)),2)","v":15.95},{"$f":"IF(VLOOKUP(AF108,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ108,1)-AJ108,2),Round,2,FALSE)+VLOOKUP(AF108,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",0,ROUND(AJ108-0.04999,1)-AJ108+AM108)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF108,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Color:","Tin"]
[]
[null,"Field Tile - MLW",null,null,"7.8\" x 7.8\" x 3/16\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"9.60 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA112,AG112)","v":17.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA112*(1-W112)+0.004999,2)","v":17.45},null,"",17.45,{"$f":"+W112","v":0},{"$f":"+X112","v":17.45},{"$f":"(AG112-AC112)/AG112","v":0},null,11,{"$f":"SUM(AJ112:AL112)+AE112","v":17.45},null,null,{"$f":"ROUND(AC112/(1-VLOOKUP(AF112,Group,2,FALSE)),2)","v":17.45},{"$f":"IF(VLOOKUP(AF112,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ112,1)-AJ112,2),Round,2,FALSE)+VLOOKUP(AF112,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",0,ROUND(AJ112-0.04999,1)-AJ112+AM112)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF112,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA116,AG116)","v":26.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA116*(1-W116)+0.004999,2)","v":26.9},null,"",26.9,{"$f":"+W116","v":0},{"$f":"+X116","v":26.9},{"$f":"(AG116-AC116)/AG116","v":0},null,11,{"$f":"SUM(AJ116:AL116)+AE116","v":26.9},null,null,{"$f":"ROUND(AC116/(1-VLOOKUP(AF116,Group,2,FALSE)),2)","v":26.9},{"$f":"IF(VLOOKUP(AF116,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ116,1)-AJ116,2),Round,2,FALSE)+VLOOKUP(AF116,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",0,ROUND(AJ116-0.04999,1)-AJ116+AM116)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF116,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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,null,"Natural",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA122,AG122)","v":14.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA122*(1-W122)+0.004999,2)","v":14.7},null,"",14.7,{"$f":"+W122","v":0},{"$f":"+X122","v":14.7},{"$f":"(AG122-AC122)/AG122","v":0},null,11,{"$f":"SUM(AJ122:AL122)+AE122","v":14.7},null,null,{"$f":"ROUND(AC122/(1-VLOOKUP(AF122,Group,2,FALSE)),2)","v":14.7},{"$f":"IF(VLOOKUP(AF122,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ122,1)-AJ122,2),Round,2,FALSE)+VLOOKUP(AF122,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,7,FALSE)=\"\",0,ROUND(AJ122-0.04999,1)-AJ122+AM122)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF122,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,"Diagonal",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA124,AG124)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA124*(1-W124)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W124","v":0},{"$f":"+X124","v":15.3},{"$f":"(AG124-AC124)/AG124","v":0},null,11,{"$f":"SUM(AJ124:AL124)+AE124","v":15.3},null,null,{"$f":"ROUND(AC124/(1-VLOOKUP(AF124,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF124,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ124,1)-AJ124,2),Round,2,FALSE)+VLOOKUP(AF124,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",0,ROUND(AJ124-0.04999,1)-AJ124+AM124)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF124,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,"Round",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA125,AG125)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA125*(1-W125)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W125","v":0},{"$f":"+X125","v":15.3},{"$f":"(AG125-AC125)/AG125","v":0},null,11,{"$f":"SUM(AJ125:AL125)+AE125","v":15.3},null,null,{"$f":"ROUND(AC125/(1-VLOOKUP(AF125,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF125,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ125,1)-AJ125,2),Round,2,FALSE)+VLOOKUP(AF125,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",0,ROUND(AJ125-0.04999,1)-AJ125+AM125)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF125,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,"Straight",null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA126,AG126)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA126*(1-W126)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W126","v":0},{"$f":"+X126","v":15.3},{"$f":"(AG126-AC126)/AG126","v":0},null,11,{"$f":"SUM(AJ126:AL126)+AE126","v":15.3},null,null,{"$f":"ROUND(AC126/(1-VLOOKUP(AF126,Group,2,FALSE)),2)","v":15.3},{"$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,"GIBRALTAR - Porcelain",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNGI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Beige             Blue             Gray             Terra             Turquoise             White"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 7\"",null,"Field - Amulet",null,null,null,null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA132,AG132)","v":30},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA132*(1-W132)+0.004999,2)","v":30},null,"new",30,{"$f":"+W132","v":0},{"$f":"+X132","v":30},{"$f":"(AG132-AC132)/AG132","v":0},null,11,{"$f":"SUM(AJ132:AL132)+AE132","v":30},null,null,{"$f":"ROUND(AC132/(1-VLOOKUP(AF132,Group,2,FALSE)),2)","v":30},{"$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,null,"GRAND CANYON - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNGR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Buff             Calcite             Mesquite             Sagebrush"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 10\" x 5/16\"",null,"Field",null," ",null,null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA138,AG138)","v":18},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA138*(1-W138)+0.004999,2)","v":18},null,"",18,{"$f":"+W138","v":0},{"$f":"+X138","v":18},{"$f":"(AG138-AC138)/AG138","v":0},null,11,{"$f":"SUM(AJ138:AL138)+AE138","v":18},null,null,{"$f":"ROUND(AC138/(1-VLOOKUP(AF138,Group,2,FALSE)),2)","v":18},{"$f":"IF(VLOOKUP(AF138,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ138,1)-AJ138,2),Round,2,FALSE)+VLOOKUP(AF138,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF138,Group,7,FALSE)=\"\",0,ROUND(AJ138-0.04999,1)-AJ138+AM138)","v":0},{"$f":"IF(VLOOKUP(AF138,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF138,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,"4.86 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA145,AG145)","v":15.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA145*(1-W145)+0.004999,2)","v":15.05},null,"",15.05,{"$f":"+W145","v":0},{"$f":"+X145","v":15.05},{"$f":"(AG145-AC145)/AG145","v":0},null,11,{"$f":"SUM(AJ145:AL145)+AE145","v":15.05},null,null,{"$f":"ROUND(AC145/(1-VLOOKUP(AF145,Group,2,FALSE)),2)","v":15.05},{"$f":"IF(VLOOKUP(AF145,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ145,1)-AJ145,2),Round,2,FALSE)+VLOOKUP(AF145,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",0,ROUND(AJ145-0.04999,1)-AJ145+AM145)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF145,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"HAVANA - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNHV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Bosque Verde",null,"       Deep Blue",null,null,"    Loden Green",null,"         Tierra Brown"]
[null,null,null,null,"Cerda Rosa",null,"       Gray",null,null,"    Mission Red",null,"         White"]
[]
[null,"Field Tile - MLW",null,null,"2\" x 16\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"10.77 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA152,AG152)","v":14.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA152*(1-W152)+0.004999,2)","v":14.45},null,"",14.45,{"$f":"+W152","v":0},{"$f":"+X152","v":14.45},{"$f":"(AG152-AC152)/AG152","v":0},null,11,{"$f":"SUM(AJ152:AL152)+AE152","v":14.45},null,null,{"$f":"ROUND(AC152/(1-VLOOKUP(AF152,Group,2,FALSE)),2)","v":14.45},{"$f":"IF(VLOOKUP(AF152,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ152,1)-AJ152,2),Round,2,FALSE)+VLOOKUP(AF152,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",0,ROUND(AJ152-0.04999,1)-AJ152+AM152)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF152,Group,7,FALSE))","v":""},null,"X"]
[]
[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\",AA160,AG160)","v":14.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA160*(1-W160)+0.004999,2)","v":14.6},null,"",14.6,{"$f":"+W160","v":0},{"$f":"+X160","v":14.6},{"$f":"(AG160-AC160)/AG160","v":0},null,11,{"$f":"SUM(AJ160:AL160)+AE160","v":14.6},null,null,{"$f":"ROUND(AC160/(1-VLOOKUP(AF160,Group,2,FALSE)),2)","v":14.6},{"$f":"IF(VLOOKUP(AF160,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ160,1)-AJ160,2),Round,2,FALSE)+VLOOKUP(AF160,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF160,Group,7,FALSE)=\"\",0,ROUND(AJ160-0.04999,1)-AJ160+AM160)","v":0},{"$f":"IF(VLOOKUP(AF160,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF160,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"ITALIA - Porcelain",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNIT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Color:","Pisa"]
[]
[null,"Field Tile - MLW",null,null,"24\" x 48\" x 5/16\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA166,AG166)","v":20.149999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":20.149999999999999},null,"",20.149999999999999,{"$f":"+W166","v":0},{"$f":"+X166","v":20.149999999999999},{"$f":"(AG166-AC166)/AG166","v":0},null,11,{"$f":"SUM(AJ166:AL166)+AE166","v":20.149999999999999},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":20.149999999999999},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ166,1)-AJ166,2),Round,2,FALSE)+VLOOKUP(AF166,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",0,ROUND(AJ166-0.04999,1)-AJ166+AM166)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF166,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Florence Beige",null,"       Milan Beige",null,null,"    Venice"]
[null,null,null,null,"Florence Gray",null,"       Milan Gray"]
[]
[null,"Field Tile - MLW",null,null,"24\" x 48\" x 5/16\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA171,AG171)","v":21.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA171*(1-W171)+0.004999,2)","v":21.3},null,"new",21.3,{"$f":"+W171","v":0},{"$f":"+X171","v":21.3},{"$f":"(AG171-AC171)/AG171","v":0},null,11,{"$f":"SUM(AJ171:AL171)+AE171","v":21.3},null,null,{"$f":"ROUND(AC171/(1-VLOOKUP(AF171,Group,2,FALSE)),2)","v":21.3},{"$f":"IF(VLOOKUP(AF171,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ171,1)-AJ171,2),Round,2,FALSE)+VLOOKUP(AF171,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF171,Group,7,FALSE)=\"\",0,ROUND(AJ171-0.04999,1)-AJ171+AM171)","v":0},{"$f":"IF(VLOOKUP(AF171,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF171,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\",AA177,AG177)","v":14.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA177*(1-W177)+0.004999,2)","v":14.65},null,"",14.65,{"$f":"+W177","v":0},{"$f":"+X177","v":14.65},{"$f":"(AG177-AC177)/AG177","v":0},null,11,{"$f":"SUM(AJ177:AL177)+AE177","v":14.65},null,null,{"$f":"ROUND(AC177/(1-VLOOKUP(AF177,Group,2,FALSE)),2)","v":14.65},{"$f":"IF(VLOOKUP(AF177,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ177,1)-AJ177,2),Round,2,FALSE)+VLOOKUP(AF177,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",0,ROUND(AJ177-0.04999,1)-AJ177+AM177)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF177,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA183,AG183)","v":12.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":12.45},null,"",12.45,{"$f":"+W183","v":0},{"$f":"+X183","v":12.45},{"$f":"(AG183-AC183)/AG183","v":0},null,11,{"$f":"SUM(AJ183:AL183)+AE183","v":12.45},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":12.45},{"$f":"IF(VLOOKUP(AF183,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ183,1)-AJ183,2),Round,2,FALSE)+VLOOKUP(AF183,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",0,ROUND(AJ183-0.04999,1)-AJ183+AM183)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF183,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"LIMESTONE - Natural Stone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CNLI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Color:","Faro (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"8\" x 16\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA189,AG189)","v":24.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA189*(1-W189)+0.004999,2)","v":24.45},null,"new",24.45,{"$f":"+W189","v":0},{"$f":"+X189","v":24.45},{"$f":"(AG189-AC189)/AG189","v":0},null,8,{"$f":"SUM(AJ189:AL189)+AE189","v":24.45},null,null,{"$f":"ROUND(AC189/(1-VLOOKUP(AF189,Group,2,FALSE)),2)","v":24.45},{"$f":"IF(VLOOKUP(AF189,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ189,1)-AJ189,2),Round,2,FALSE)+VLOOKUP(AF189,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",0,ROUND(AJ189-0.04999,1)-AJ189+AM189)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF189,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"16\" x 24\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA190,AG190)","v":24.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA190*(1-W190)+0.004999,2)","v":24.45},null,"new",24.45,{"$f":"+W190","v":0},{"$f":"+X190","v":24.45},{"$f":"(AG190-AC190)/AG190","v":0},null,8,{"$f":"SUM(AJ190:AL190)+AE190","v":24.45},null,null,{"$f":"ROUND(AC190/(1-VLOOKUP(AF190,Group,2,FALSE)),2)","v":24.45},{"$f":"IF(VLOOKUP(AF190,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ190,1)-AJ190,2),Round,2,FALSE)+VLOOKUP(AF190,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF190,Group,7,FALSE)=\"\",0,ROUND(AJ190-0.04999,1)-AJ190+AM190)","v":0},{"$f":"IF(VLOOKUP(AF190,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF190,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Color:","Orval (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"8\" x 16\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA194,AG194)","v":25.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA194*(1-W194)+0.004999,2)","v":25.75},null,"new",25.75,{"$f":"+W194","v":0},{"$f":"+X194","v":25.75},{"$f":"(AG194-AC194)/AG194","v":0},null,8,{"$f":"SUM(AJ194:AL194)+AE194","v":25.75},null,null,{"$f":"ROUND(AC194/(1-VLOOKUP(AF194,Group,2,FALSE)),2)","v":25.75},{"$f":"IF(VLOOKUP(AF194,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ194,1)-AJ194,2),Round,2,FALSE)+VLOOKUP(AF194,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF194,Group,7,FALSE)=\"\",0,ROUND(AJ194-0.04999,1)-AJ194+AM194)","v":0},{"$f":"IF(VLOOKUP(AF194,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF194,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"16\" x 24\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,25.75,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},25.75,null,"new",25.75,0,25.75,0,null,8,25.75,null,null,25.75,0,0,"",null,"X"]
[]
[null,null,null,"Color:","Chimay (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"8\" x 16\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA199,AG199)","v":30.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA199*(1-W199)+0.004999,2)","v":30.75},null,"new",30.75,{"$f":"+W199","v":0},{"$f":"+X199","v":30.75},{"$f":"(AG199-AC199)/AG199","v":0},null,8,{"$f":"SUM(AJ199:AL199)+AE199","v":30.75},null,null,{"$f":"ROUND(AC199/(1-VLOOKUP(AF199,Group,2,FALSE)),2)","v":30.75},{"$f":"IF(VLOOKUP(AF199,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ199,1)-AJ199,2),Round,2,FALSE)+VLOOKUP(AF199,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF199,Group,7,FALSE)=\"\",0,ROUND(AJ199-0.04999,1)-AJ199+AM199)","v":0},{"$f":"IF(VLOOKUP(AF199,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF199,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"16\" x 24\" x 5/8\"",null,"Field",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,30.75,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},30.75,null,"new",30.75,0,30.75,0,null,8,30.75,null,null,30.75,0,0,"",null,"X"]
[]
[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\",AA206,AG206)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA206*(1-W206)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W206","v":0},{"$f":"+X206","v":18.7},{"$f":"(AG206-AC206)/AG206","v":0},null,11,{"$f":"SUM(AJ206:AL206)+AE206","v":18.7},null,null,{"$f":"ROUND(AC206/(1-VLOOKUP(AF206,Group,2,FALSE)),2)","v":18.7},{"$f":"IF(VLOOKUP(AF206,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ206,1)-AJ206,2),Round,2,FALSE)+VLOOKUP(AF206,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF206,Group,7,FALSE)=\"\",0,ROUND(AJ206-0.04999,1)-AJ206+AM206)","v":0},{"$f":"IF(VLOOKUP(AF206,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF206,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\",AA207,AG207)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA207*(1-W207)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W207","v":0},{"$f":"+X207","v":18.7},{"$f":"(AG207-AC207)/AG207","v":0},null,11,{"$f":"SUM(AJ207:AL207)+AE207","v":18.7},null,null,{"$f":"ROUND(AC207/(1-VLOOKUP(AF207,Group,2,FALSE)),2)","v":18.7},{"$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,null,"MARMOL - Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNMR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Blanco          Marron"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 7\" x 5/16\"",null,"Field - Amulet",null,null,null,null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA213,AG213)","v":30},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA213*(1-W213)+0.004999,2)","v":30},null,"",30,{"$f":"+W213","v":0},30,{"$f":"(AG213-AC213)/AG213","v":0},null,11,{"$f":"SUM(AJ213:AL213)+AE213","v":30},null,null,{"$f":"ROUND(AC213/(1-VLOOKUP(AF213,Group,2,FALSE)),2)","v":30},{"$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,"Field Tile - MLW",null,null,"6\" x 6\" x 5/16\"",null,"Field - Cross",null,null,null,null,null,null,"(24 pcs. Per Carton)",null,"6.31 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA214,AG214)","v":29.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA214*(1-W214)+0.004999,2)","v":29.8},null,"",29.8,0,29.8,{"$f":"(AG214-AC214)/AG214","v":0},null,11,{"$f":"SUM(AJ214:AL214)+AE214","v":29.8},null,null,{"$f":"ROUND(AC214/(1-VLOOKUP(AF214,Group,2,FALSE)),2)","v":29.8},{"$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,"Field Tile - MLW",null,null,"6\" x 6\" x 5/16\"",null,"Field - Star",null,null,null,null,null,null,"(16 pcs. Per Carton)",null,"4.21 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA215,AG215)","v":30.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA215*(1-W215)+0.004999,2)","v":30.2},null,"",30.2,0,30.2,{"$f":"(AG215-AC215)/AG215","v":0},null,11,{"$f":"SUM(AJ215:AL215)+AE215","v":30.2},null,null,{"$f":"ROUND(AC215/(1-VLOOKUP(AF215,Group,2,FALSE)),2)","v":30.2},{"$f":"IF(VLOOKUP(AF215,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ215,1)-AJ215,2),Round,2,FALSE)+VLOOKUP(AF215,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF215,Group,7,FALSE)=\"\",0,ROUND(AJ215-0.04999,1)-AJ215+AM215)","v":0},{"$f":"IF(VLOOKUP(AF215,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF215,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) For the Cross and Star pattern, order equal amounts of each.  Example:  100 SF total needed, order 50 SF of the Cross and 50 SF of the Star patterns."]
[]
[null,null,"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\",AA223,AG223)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA223*(1-W223)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W223","v":0},{"$f":"+X223","v":18.7},{"$f":"(AG223-AC223)/AG223","v":0},null,11,{"$f":"SUM(AJ223:AL223)+AE223","v":18.7},null,null,{"$f":"ROUND(AC223/(1-VLOOKUP(AF223,Group,2,FALSE)),2)","v":18.7},{"$f":"IF(VLOOKUP(AF223,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ223,1)-AJ223,2),Round,2,FALSE)+VLOOKUP(AF223,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF223,Group,7,FALSE)=\"\",0,ROUND(AJ223-0.04999,1)-AJ223+AM223)","v":0},{"$f":"IF(VLOOKUP(AF223,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF223,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 (Decorative Pattern)",null,null,null,null,null,null,null,null,"5.54 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA229,AG229)","v":16.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA229*(1-W229)+0.004999,2)","v":16.45},null,"",16.45,{"$f":"+W229","v":0},16.45,{"$f":"(AG229-AC229)/AG229","v":0},null,11,{"$f":"SUM(AJ229:AL229)+AE229","v":16.45},null,null,{"$f":"ROUND(AC229/(1-VLOOKUP(AF229,Group,2,FALSE)),2)","v":16.45},{"$f":"IF(VLOOKUP(AF229,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ229,1)-AJ229,2),Round,2,FALSE)+VLOOKUP(AF229,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",0,ROUND(AJ229-0.04999,1)-AJ229+AM229)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF229,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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:","Dauphine          Lafayette          Magazine          Orleans          Toulouse"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA235,AG235)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA235*(1-W235)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W235","v":0},12.8,{"$f":"(AG235-AC235)/AG235","v":0},null,11,{"$f":"SUM(AJ235:AL235)+AE235","v":12.8},null,null,{"$f":"ROUND(AC235/(1-VLOOKUP(AF235,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF235,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ235,1)-AJ235,2),Round,2,FALSE)+VLOOKUP(AF235,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF235,Group,7,FALSE)=\"\",0,ROUND(AJ235-0.04999,1)-AJ235+AM235)","v":0},{"$f":"IF(VLOOKUP(AF235,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF235,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 (Decorative Pattern)",null,null,null,null,null,null,null,null,"8.66 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA241,AG241)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA241*(1-W241)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W241","v":0},{"$f":"+X241","v":12.8},{"$f":"(AG241-AC241)/AG241","v":0},null,11,{"$f":"SUM(AJ241:AL241)+AE241","v":12.8},null,null,{"$f":"ROUND(AC241/(1-VLOOKUP(AF241,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF241,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ241,1)-AJ241,2),Round,2,FALSE)+VLOOKUP(AF241,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF241,Group,7,FALSE)=\"\",0,ROUND(AJ241-0.04999,1)-AJ241+AM241)","v":0},{"$f":"IF(VLOOKUP(AF241,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF241,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 (Decorative Pattern)",null,null,null,null,null,null,null,null,"16.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA247,AG247)","v":18.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA247*(1-W247)+0.004999,2)","v":18.8},null,"",18.8,{"$f":"+W247","v":0},{"$f":"+X247","v":18.8},{"$f":"(AG247-AC247)/AG247","v":0},null,11,{"$f":"SUM(AJ247:AL247)+AE247","v":18.8},null,null,{"$f":"ROUND(AC247/(1-VLOOKUP(AF247,Group,2,FALSE)),2)","v":18.8},{"$f":"IF(VLOOKUP(AF247,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ247,1)-AJ247,2),Round,2,FALSE)+VLOOKUP(AF247,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF247,Group,7,FALSE)=\"\",0,ROUND(AJ247-0.04999,1)-AJ247+AM247)","v":0},{"$f":"IF(VLOOKUP(AF247,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF247,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA253,AG253)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA253*(1-W253)+0.004999,2)","v":13.55},null,"",13.55,{"$f":"+W253","v":0},13.55,{"$f":"(AG253-AC253)/AG253","v":0},null,11,{"$f":"SUM(AJ253:AL253)+AE253","v":13.55},null,null,{"$f":"ROUND(AC253/(1-VLOOKUP(AF253,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF253,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ253,1)-AJ253,2),Round,2,FALSE)+VLOOKUP(AF253,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF253,Group,7,FALSE)=\"\",0,ROUND(AJ253-0.04999,1)-AJ253+AM253)","v":0},{"$f":"IF(VLOOKUP(AF253,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF253,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA254,AG254)","v":14.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA254*(1-W254)+0.004999,2)","v":14.75},null,"",14.75,0,14.75,{"$f":"(AG254-AC254)/AG254","v":0},null,11,{"$f":"SUM(AJ254:AL254)+AE254","v":14.75},null,null,{"$f":"ROUND(AC254/(1-VLOOKUP(AF254,Group,2,FALSE)),2)","v":14.75},{"$f":"IF(VLOOKUP(AF254,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ254,1)-AJ254,2),Round,2,FALSE)+VLOOKUP(AF254,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF254,Group,7,FALSE)=\"\",0,ROUND(AJ254-0.04999,1)-AJ254+AM254)","v":0},{"$f":"IF(VLOOKUP(AF254,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF254,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\",AA255,AG255)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA255*(1-W255)+0.004999,2)","v":15.3},null,"",15.3,0,15.3,{"$f":"(AG255-AC255)/AG255","v":0},null,11,{"$f":"SUM(AJ255:AL255)+AE255","v":15.3},null,null,{"$f":"ROUND(AC255/(1-VLOOKUP(AF255,Group,2,FALSE)),2)","v":15.3},{"$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,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\",AA261,AG261)","v":15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA261*(1-W261)+0.004999,2)","v":15},null,"",15,{"$f":"+W261","v":0},15,{"$f":"(AG261-AC261)/AG261","v":0},null,11,{"$f":"SUM(AJ261:AL261)+AE261","v":15},null,null,{"$f":"ROUND(AC261/(1-VLOOKUP(AF261,Group,2,FALSE)),2)","v":15},{"$f":"IF(VLOOKUP(AF261,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ261,1)-AJ261,2),Round,2,FALSE)+VLOOKUP(AF261,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF261,Group,7,FALSE)=\"\",0,ROUND(AJ261-0.04999,1)-AJ261+AM261)","v":0},{"$f":"IF(VLOOKUP(AF261,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF261,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA262,AG262)","v":13.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA262*(1-W262)+0.004999,2)","v":13.15},null,"",13.15,0,13.15,{"$f":"(AG262-AC262)/AG262","v":0},null,11,{"$f":"SUM(AJ262:AL262)+AE262","v":13.15},null,null,{"$f":"ROUND(AC262/(1-VLOOKUP(AF262,Group,2,FALSE)),2)","v":13.15},{"$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",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\",AA263,AG263)","v":15.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA263*(1-W263)+0.004999,2)","v":15.4},null,"",15.4,0,15.4,{"$f":"(AG263-AC263)/AG263","v":0},null,11,{"$f":"SUM(AJ263:AL263)+AE263","v":15.4},null,null,{"$f":"ROUND(AC263/(1-VLOOKUP(AF263,Group,2,FALSE)),2)","v":15.4},{"$f":"IF(VLOOKUP(AF263,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ263,1)-AJ263,2),Round,2,FALSE)+VLOOKUP(AF263,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF263,Group,7,FALSE)=\"\",0,ROUND(AJ263-0.04999,1)-AJ263+AM263)","v":0},{"$f":"IF(VLOOKUP(AF263,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF263,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\",AA265,AG265)","v":31.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA265*(1-W265)+0.004999,2)","v":31.15},null,"",31.15,{"$f":"+W265","v":0},{"$f":"+X265","v":31.15},{"$f":"(AG265-AC265)/AG265","v":0},null,13,{"$f":"SUM(AJ265:AL265)+AE265","v":31.15},null,null,{"$f":"ROUND(AC265/(1-VLOOKUP(AF265,Group,2,FALSE)),2)","v":31.15},{"$f":"IF(VLOOKUP(AF265,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ265,1)-AJ265,2),Round,2,FALSE)+VLOOKUP(AF265,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF265,Group,7,FALSE)=\"\",0,ROUND(AJ265-0.04999,1)-AJ265+AM265)","v":0},{"$f":"IF(VLOOKUP(AF265,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF265,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA271,AG271)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA271*(1-W271)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W271","v":0},{"$f":"+X271","v":12.8},{"$f":"(AG271-AC271)/AG271","v":0},null,11,{"$f":"SUM(AJ271:AL271)+AE271","v":12.8},null,null,{"$f":"ROUND(AC271/(1-VLOOKUP(AF271,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF271,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ271,1)-AJ271,2),Round,2,FALSE)+VLOOKUP(AF271,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF271,Group,7,FALSE)=\"\",0,ROUND(AJ271-0.04999,1)-AJ271+AM271)","v":0},{"$f":"IF(VLOOKUP(AF271,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF271,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Carmel          Laguna          Lodi          Ojai"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA275,AG275)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA275*(1-W275)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W275","v":0},12.8,{"$f":"(AG275-AC275)/AG275","v":0},null,11,{"$f":"SUM(AJ275:AL275)+AE275","v":12.8},null,null,{"$f":"ROUND(AC275/(1-VLOOKUP(AF275,Group,2,FALSE)),2)","v":12.8},{"$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,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,"5.50 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA281,AG281)","v":14.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA281*(1-W281)+0.004999,2)","v":14.65},null,"",14.65,{"$f":"+W281","v":0},{"$f":"+X281","v":14.65},{"$f":"(AG281-AC281)/AG281","v":0},null,11,{"$f":"SUM(AJ281:AL281)+AE281","v":14.65},null,null,{"$f":"ROUND(AC281/(1-VLOOKUP(AF281,Group,2,FALSE)),2)","v":14.65},{"$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,null,null,"Note:","a) Packaging is changing from 11.00 SF/CTN to 5.50 SF/CTN as inventory with old packaging is depleted."]
[]
[null,null,"PLUME - Ceramic",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\",AA291,AG291)","v":22.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA291*(1-W291)+0.004999,2)","v":22.55},null,"",22.55,{"$f":"+W291","v":0},{"$f":"+X291","v":22.55},{"$f":"(AG291-AC291)/AG291","v":0},null,11,{"$f":"SUM(AJ291:AL291)+AE291","v":22.55},null,null,{"$f":"ROUND(AC291/(1-VLOOKUP(AF291,Group,2,FALSE)),2)","v":22.55},{"$f":"IF(VLOOKUP(AF291,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ291,1)-AJ291,2),Round,2,FALSE)+VLOOKUP(AF291,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF291,Group,7,FALSE)=\"\",0,ROUND(AJ291-0.04999,1)-AJ291+AM291)","v":0},{"$f":"IF(VLOOKUP(AF291,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF291,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\",AA293,AG293)","v":9.9499999999999993},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA293*(1-W293)+0.004999,2)","v":9.9499999999999993},null,"",9.9499999999999993,{"$f":"+W293","v":0},{"$f":"+X293","v":9.9499999999999993},{"$f":"(AG293-AC293)/AG293","v":0},null,12,{"$f":"SUM(AJ293:AL293)+AE293","v":9.9499999999999993},null,null,{"$f":"ROUND(AC293/(1-VLOOKUP(AF293,Group,2,FALSE)),2)","v":9.9499999999999993},{"$f":"IF(VLOOKUP(AF293,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ293,1)-AJ293,2),Round,2,FALSE)+VLOOKUP(AF293,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF293,Group,7,FALSE)=\"\",0,ROUND(AJ293-0.04999,1)-AJ293+AM293)","v":0},{"$f":"IF(VLOOKUP(AF293,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF293,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\",AA300,AG300)","v":15.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA300*(1-W300)+0.004999,2)","v":15.65},null,"",15.65,{"$f":"+W300","v":0},{"$f":"+X300","v":15.65},{"$f":"(AG300-AC300)/AG300","v":0},null,11,{"$f":"SUM(AJ300:AL300)+AE300","v":15.65},null,null,{"$f":"ROUND(AC300/(1-VLOOKUP(AF300,Group,2,FALSE)),2)","v":15.65},{"$f":"IF(VLOOKUP(AF300,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ300,1)-AJ300,2),Round,2,FALSE)+VLOOKUP(AF300,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF300,Group,7,FALSE)=\"\",0,ROUND(AJ300-0.04999,1)-AJ300+AM300)","v":0},{"$f":"IF(VLOOKUP(AF300,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF300,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\",AA306,AG306)","v":14.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA306*(1-W306)+0.004999,2)","v":14.5},null,"",14.5,{"$f":"+W306","v":0},{"$f":"+X306","v":14.5},{"$f":"(AG306-AC306)/AG306","v":0},null,11,{"$f":"SUM(AJ306:AL306)+AE306","v":14.5},null,null,{"$f":"ROUND(AC306/(1-VLOOKUP(AF306,Group,2,FALSE)),2)","v":14.5},{"$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,"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 - Hexagon",null,null,null,null,null,null,null,null,"9.04 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA313,AG313)","v":13.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA313*(1-W313)+0.004999,2)","v":13.85},null,"",13.85,{"$f":"+W313","v":0},{"$f":"+X313","v":13.85},{"$f":"(AG313-AC313)/AG313","v":0},null,11,{"$f":"SUM(AJ313:AL313)+AE313","v":13.85},null,null,{"$f":"ROUND(AC313/(1-VLOOKUP(AF313,Group,2,FALSE)),2)","v":13.85},{"$f":"IF(VLOOKUP(AF313,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ313,1)-AJ313,2),Round,2,FALSE)+VLOOKUP(AF313,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF313,Group,7,FALSE)=\"\",0,ROUND(AJ313-0.04999,1)-AJ313+AM313)","v":0},{"$f":"IF(VLOOKUP(AF313,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF313,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\",AA319,AG319)","v":19.100000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA319*(1-W319)+0.004999,2)","v":19.100000000000001},null,"",19.100000000000001,{"$f":"+W319","v":0},{"$f":"+X319","v":19.100000000000001},{"$f":"(AG319-AC319)/AG319","v":0},null,11,{"$f":"SUM(AJ319:AL319)+AE319","v":19.100000000000001},null,null,{"$f":"ROUND(AC319/(1-VLOOKUP(AF319,Group,2,FALSE)),2)","v":19.100000000000001},{"$f":"IF(VLOOKUP(AF319,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ319,1)-AJ319,2),Round,2,FALSE)+VLOOKUP(AF319,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF319,Group,7,FALSE)=\"\",0,ROUND(AJ319-0.04999,1)-AJ319+AM319)","v":0},{"$f":"IF(VLOOKUP(AF319,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF319,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA326,AG326)","v":16},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA326*(1-W326)+0.004999,2)","v":16},null,"",16,{"$f":"+W326","v":0},16,{"$f":"(AG326-AC326)/AG326","v":0},null,11,{"$f":"SUM(AJ326:AL326)+AE326","v":16},null,null,{"$f":"ROUND(AC326/(1-VLOOKUP(AF326,Group,2,FALSE)),2)","v":16},{"$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,"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\",AA327,AG327)","v":16.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA327*(1-W327)+0.004999,2)","v":16.25},null,"",16.25,0,16.25,{"$f":"(AG327-AC327)/AG327","v":0},null,11,{"$f":"SUM(AJ327:AL327)+AE327","v":16.25},null,null,{"$f":"ROUND(AC327/(1-VLOOKUP(AF327,Group,2,FALSE)),2)","v":16.25},{"$f":"IF(VLOOKUP(AF327,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ327,1)-AJ327,2),Round,2,FALSE)+VLOOKUP(AF327,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF327,Group,7,FALSE)=\"\",0,ROUND(AJ327-0.04999,1)-AJ327+AM327)","v":0},{"$f":"IF(VLOOKUP(AF327,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF327,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\",AA328,AG328)","v":16.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA328*(1-W328)+0.004999,2)","v":16.8},null,"",16.8,0,16.8,{"$f":"(AG328-AC328)/AG328","v":0},null,11,{"$f":"SUM(AJ328:AL328)+AE328","v":16.8},null,null,{"$f":"ROUND(AC328/(1-VLOOKUP(AF328,Group,2,FALSE)),2)","v":16.8},{"$f":"IF(VLOOKUP(AF328,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ328,1)-AJ328,2),Round,2,FALSE)+VLOOKUP(AF328,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF328,Group,7,FALSE)=\"\",0,ROUND(AJ328-0.04999,1)-AJ328+AM328)","v":0},{"$f":"IF(VLOOKUP(AF328,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF328,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\",AA330,AG330)","v":10.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA330*(1-W330)+0.004999,2)","v":10.7},null,"",10.7,{"$f":"+W330","v":0},{"$f":"+X330","v":10.7},{"$f":"(AG330-AC330)/AG330","v":0},null,12,{"$f":"SUM(AJ330:AL330)+AE330","v":10.7},null,null,{"$f":"ROUND(AC330/(1-VLOOKUP(AF330,Group,2,FALSE)),2)","v":10.7},{"$f":"IF(VLOOKUP(AF330,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ330,1)-AJ330,2),Round,2,FALSE)+VLOOKUP(AF330,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF330,Group,7,FALSE)=\"\",0,ROUND(AJ330-0.04999,1)-AJ330+AM330)","v":0},{"$f":"IF(VLOOKUP(AF330,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF330,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\",AA338,AG338)","v":14.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA338*(1-W338)+0.004999,2)","v":14.75},null,"",14.75,{"$f":"+W338","v":0},{"$f":"+X338","v":14.75},{"$f":"(AG338-AC338)/AG338","v":0},null,8,{"$f":"SUM(AJ338:AL338)+AE338","v":14.75},null,null,{"$f":"ROUND(AC338/(1-VLOOKUP(AF338,Group,2,FALSE)),2)","v":14.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,"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.85,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.85,null,"",14.85,0,14.85,0,null,8,14.85,null,null,14.85,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.7,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},25.7,null,"",25.7,0,25.7,0,null,8,25.7,null,null,25.7,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.85,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},13.85,null,"",13.85,0,13.85,0,null,8,13.85,null,null,13.85,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.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,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,14.45,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.45,null,"",14.45,0,14.45,0,null,8,14.45,null,null,14.45,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"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,"4.50 SF/PC",null,null,16.399999999999999,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},16.399999999999999,null,"",16.399999999999999,0,16.399999999999999,0,null,8,16.399999999999999,null,null,16.399999999999999,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"10\"",null,"Field - Hexagon",null,null,null,null,null,null,null,null,"6.00 SF/CTN",null,null,20.65,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},20.65,null,"YES",20.65,0,20.65,0,null,8,20.65,null,null,20.65,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"2-3/4\" x 11\"",null,"Field - Picket",null,null,null,null,null,null,null,null,"10.55 SF/CTN",null,null,17.55,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},17.55,null,"",17.55,0,17.55,0,null,8,17.55,null,null,17.55,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,null,null,"Field - Versailles Pattern",null,null,null,null,null,null,null,null,"8.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA350,AG350)","v":14.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA350*(1-W350)+0.004999,2)","v":14.35},null,"new",14.35,{"$f":"+W350","v":0},{"$f":"+X350","v":14.35},{"$f":"(AG350-AC350)/AG350","v":0},null,8,{"$f":"SUM(AJ350:AL350)+AE350","v":14.35},null,null,{"$f":"ROUND(AC350/(1-VLOOKUP(AF350,Group,2,FALSE)),2)","v":14.35},{"$f":"IF(VLOOKUP(AF350,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ350,1)-AJ350,2),Round,2,FALSE)+VLOOKUP(AF350,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF350,Group,7,FALSE)=\"\",0,ROUND(AJ350-0.04999,1)-AJ350+AM350)","v":0},{"$f":"IF(VLOOKUP(AF350,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF350,Group,7,FALSE))","v":""},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,"b",{"$f":"IF(Suggested=\"Yes\",AA352,AG352)","v":55.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA352*(1-W352)+0.004999,2)","v":55.05},null,"",55.05,{"$f":"+W352","v":0},{"$f":"+X352","v":55.05},{"$f":"(AG352-AC352)/AG352","v":0},null,10,{"$f":"SUM(AJ352:AL352)+AE352","v":55.05},null,null,{"$f":"ROUND(AC352/(1-VLOOKUP(AF352,Group,2,FALSE)),2)","v":55.05},{"$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,"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\",AA353,AG353)","v":32.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA353*(1-W353)+0.004999,2)","v":32.25},null,"",32.25,{"$f":"+W353","v":0},32.25,{"$f":"(AG353-AC353)/AG353","v":0},null,10,{"$f":"SUM(AJ353:AL353)+AE353","v":32.25},null,null,{"$f":"ROUND(AC353/(1-VLOOKUP(AF353,Group,2,FALSE)),2)","v":32.25},{"$f":"IF(VLOOKUP(AF353,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ353,1)-AJ353,2),Round,2,FALSE)+VLOOKUP(AF353,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF353,Group,7,FALSE)=\"\",0,ROUND(AJ353-0.04999,1)-AJ353+AM353)","v":0},{"$f":"IF(VLOOKUP(AF353,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF353,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,"b",{"$f":"IF(Suggested=\"Yes\",AA354,AG354)","v":51.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA354*(1-W354)+0.004999,2)","v":51.75},null,"",51.75,{"$f":"+W354","v":0},{"$f":"+X354","v":51.75},{"$f":"(AG354-AC354)/AG354","v":0},null,10,{"$f":"SUM(AJ354:AL354)+AE354","v":51.75},null,null,{"$f":"ROUND(AC354/(1-VLOOKUP(AF354,Group,2,FALSE)),2)","v":51.75},{"$f":"IF(VLOOKUP(AF354,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ354,1)-AJ354,2),Round,2,FALSE)+VLOOKUP(AF354,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF354,Group,7,FALSE)=\"\",0,ROUND(AJ354-0.04999,1)-AJ354+AM354)","v":0},{"$f":"IF(VLOOKUP(AF354,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF354,Group,7,FALSE))","v":""},null,"X"]
[null,"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,"b",{"$f":"IF(Suggested=\"Yes\",AA355,AG355)","v":55.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA355*(1-W355)+0.004999,2)","v":55.5},null,"",55.5,0,55.5,{"$f":"(AG355-AC355)/AG355","v":0},null,10,{"$f":"SUM(AJ355:AL355)+AE355","v":55.5},null,null,{"$f":"ROUND(AC355/(1-VLOOKUP(AF355,Group,2,FALSE)),2)","v":55.5},{"$f":"IF(VLOOKUP(AF355,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ355,1)-AJ355,2),Round,2,FALSE)+VLOOKUP(AF355,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF355,Group,7,FALSE)=\"\",0,ROUND(AJ355-0.04999,1)-AJ355+AM355)","v":0},{"$f":"IF(VLOOKUP(AF355,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF355,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Color:","Squall",null,null,null,null,null,null,null," "]
[]
[null,"Field Tile - MLW Stone",null,null,"4\" x 4\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA359,AG359)","v":14.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA359*(1-W359)+0.004999,2)","v":14.75},null,"",14.75,{"$f":"+W359","v":0},{"$f":"+X359","v":14.75},{"$f":"(AG359-AC359)/AG359","v":0},null,8,{"$f":"SUM(AJ359:AL359)+AE359","v":14.75},null,null,{"$f":"ROUND(AC359/(1-VLOOKUP(AF359,Group,2,FALSE)),2)","v":14.75},{"$f":"IF(VLOOKUP(AF359,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ359,1)-AJ359,2),Round,2,FALSE)+VLOOKUP(AF359,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF359,Group,7,FALSE)=\"\",0,ROUND(AJ359-0.04999,1)-AJ359+AM359)","v":0},{"$f":"IF(VLOOKUP(AF359,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF359,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.85,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.85,null,"",14.85,0,14.85,0,null,8,14.85,null,null,14.85,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.7,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},25.7,null,"",25.7,0,25.7,0,null,8,25.7,null,null,25.7,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.85,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},13.85,null,"",13.85,0,13.85,0,null,8,13.85,null,null,13.85,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.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,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 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,"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 - Hexagon",null,null,null,null,null,null,null,null,"6.00 SF/CTN",null,null,20.65,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},20.65,null,"YES",20.65,0,20.65,0,null,8,20.65,null,null,20.65,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"2-3/4\" x 11\"",null,"Field - Picket",null,null,null,null,null,null,null,null,"10.55 SF/CTN",null,"b",17.55,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},17.55,null,"",17.55,0,17.55,0,null,8,17.55,null,null,17.55,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\",AA371,AG371)","v":55.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA371*(1-W371)+0.004999,2)","v":55.05},null,"",55.05,{"$f":"+W371","v":0},{"$f":"+X371","v":55.05},{"$f":"(AG371-AC371)/AG371","v":0},null,10,{"$f":"SUM(AJ371:AL371)+AE371","v":55.05},null,null,{"$f":"ROUND(AC371/(1-VLOOKUP(AF371,Group,2,FALSE)),2)","v":55.05},{"$f":"IF(VLOOKUP(AF371,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ371,1)-AJ371,2),Round,2,FALSE)+VLOOKUP(AF371,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF371,Group,7,FALSE)=\"\",0,ROUND(AJ371-0.04999,1)-AJ371+AM371)","v":0},{"$f":"IF(VLOOKUP(AF371,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF371,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos - MLW Stone",null,null,"13.75\" x 13.75\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(1.36 SF/Sheet)",null,null,"6.80 SF/CTN",null,"a,c",{"$f":"IF(Suggested=\"Yes\",AA372,AG372)","v":54.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA372*(1-W372)+0.004999,2)","v":54.9},null,"",54.9,{"$f":"+W372","v":0},54.9,{"$f":"(AG372-AC372)/AG372","v":0},null,10,{"$f":"SUM(AJ372:AL372)+AE372","v":54.9},null,null,{"$f":"ROUND(AC372/(1-VLOOKUP(AF372,Group,2,FALSE)),2)","v":54.9},{"$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,"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\",AA373,AG373)","v":55.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA373*(1-W373)+0.004999,2)","v":55.5},null,"",55.5,0,55.5,{"$f":"(AG373-AC373)/AG373","v":0},null,10,{"$f":"SUM(AJ373:AL373)+AE373","v":55.5},null,null,{"$f":"ROUND(AC373/(1-VLOOKUP(AF373,Group,2,FALSE)),2)","v":55.5},{"$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,null,null,"Notes:","a) Special Order - approximately 3-4 weeks."]
[null,null,null,null,"b) Consists of the following sizes:  8\" x 8\", 2 pieces, 8\" x 16\", 1 piece, 16\" x 16\", 2 pieces and 16\" x 24\", 1 piece.  "]
[null,null,null,null,"c) Minimum purchase is 13.60 SF, (2 cartons)."]
[]
[null,null,"STELLA - Porcelain",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\",AA383,AG383)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA383*(1-W383)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W383","v":0},{"$f":"+X383","v":12.8},{"$f":"(AG383-AC383)/AG383","v":0},null,11,{"$f":"SUM(AJ383:AL383)+AE383","v":12.8},null,null,{"$f":"ROUND(AC383/(1-VLOOKUP(AF383,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF383,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ383,1)-AJ383,2),Round,2,FALSE)+VLOOKUP(AF383,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF383,Group,7,FALSE)=\"\",0,ROUND(AJ383-0.04999,1)-AJ383+AM383)","v":0},{"$f":"IF(VLOOKUP(AF383,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF383,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field - Star",null,null,null,null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA385,AG385)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA385*(1-W385)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W385","v":0},{"$f":"+X385","v":12.8},{"$f":"(AG385-AC385)/AG385","v":0},null,11,{"$f":"SUM(AJ385:AL385)+AE385","v":12.8},null,null,{"$f":"ROUND(AC385/(1-VLOOKUP(AF385,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF385,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ385,1)-AJ385,2),Round,2,FALSE)+VLOOKUP(AF385,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF385,Group,7,FALSE)=\"\",0,ROUND(AJ385-0.04999,1)-AJ385+AM385)","v":0},{"$f":"IF(VLOOKUP(AF385,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF385,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\",AA392,AG392)","v":14},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA392*(1-W392)+0.004999,2)","v":14},null,"",14,{"$f":"+W392","v":0},{"$f":"+X392","v":14},{"$f":"(AG392-AC392)/AG392","v":0},null,11,{"$f":"SUM(AJ392:AL392)+AE392","v":14},null,null,{"$f":"ROUND(AC392/(1-VLOOKUP(AF392,Group,2,FALSE)),2)","v":14},{"$f":"IF(VLOOKUP(AF392,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ392,1)-AJ392,2),Round,2,FALSE)+VLOOKUP(AF392,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF392,Group,7,FALSE)=\"\",0,ROUND(AJ392-0.04999,1)-AJ392+AM392)","v":0},{"$f":"IF(VLOOKUP(AF392,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF392,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\",AA398,AG398)","v":14.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA398*(1-W398)+0.004999,2)","v":14.2},null,"",14.2,{"$f":"+W398","v":0},{"$f":"+X398","v":14.2},{"$f":"(AG398-AC398)/AG398","v":0},null,11,{"$f":"SUM(AJ398:AL398)+AE398","v":14.2},null,null,{"$f":"ROUND(AC398/(1-VLOOKUP(AF398,Group,2,FALSE)),2)","v":14.2},{"$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,"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\",AA404,AG404)","v":18.350000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA404*(1-W404)+0.004999,2)","v":18.350000000000001},null,"",18.350000000000001,{"$f":"+W404","v":0},18.350000000000001,{"$f":"(AG404-AC404)/AG404","v":0},null,11,{"$f":"SUM(AJ404:AL404)+AE404","v":18.350000000000001},null,null,{"$f":"ROUND(AC404/(1-VLOOKUP(AF404,Group,2,FALSE)),2)","v":18.350000000000001},{"$f":"IF(VLOOKUP(AF404,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ404,1)-AJ404,2),Round,2,FALSE)+VLOOKUP(AF404,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF404,Group,7,FALSE)=\"\",0,ROUND(AJ404-0.04999,1)-AJ404+AM404)","v":0},{"$f":"IF(VLOOKUP(AF404,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF404,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\",AA405,AG405)","v":17.899999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA405*(1-W405)+0.004999,2)","v":17.899999999999999},null,"",17.899999999999999,0,17.899999999999999,{"$f":"(AG405-AC405)/AG405","v":0},null,11,{"$f":"SUM(AJ405:AL405)+AE405","v":17.899999999999999},null,null,{"$f":"ROUND(AC405/(1-VLOOKUP(AF405,Group,2,FALSE)),2)","v":17.899999999999999},{"$f":"IF(VLOOKUP(AF405,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ405,1)-AJ405,2),Round,2,FALSE)+VLOOKUP(AF405,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF405,Group,7,FALSE)=\"\",0,ROUND(AJ405-0.04999,1)-AJ405+AM405)","v":0},{"$f":"IF(VLOOKUP(AF405,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF405,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\",AA406,AG406)","v":17.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA406*(1-W406)+0.004999,2)","v":17.05},null,"",17.05,0,17.05,{"$f":"(AG406-AC406)/AG406","v":0},null,11,{"$f":"SUM(AJ406:AL406)+AE406","v":17.05},null,null,{"$f":"ROUND(AC406/(1-VLOOKUP(AF406,Group,2,FALSE)),2)","v":17.05},{"$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,"Field Tile - MLW",null,null,"4.5\" x 4.5\"",null,"Field (Decorative Pattern)",null,null,null,null,null,null,null,null,"5.42 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA408,AG408)","v":21.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA408*(1-W408)+0.004999,2)","v":21.35},null,"",21.35,{"$f":"+W408","v":0},{"$f":"+X408","v":21.35},{"$f":"(AG408-AC408)/AG408","v":0},null,11,{"$f":"SUM(AJ408:AL408)+AE408","v":21.35},null,null,{"$f":"ROUND(AC408/(1-VLOOKUP(AF408,Group,2,FALSE)),2)","v":21.35},{"$f":"IF(VLOOKUP(AF408,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ408,1)-AJ408,2),Round,2,FALSE)+VLOOKUP(AF408,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF408,Group,7,FALSE)=\"\",0,ROUND(AJ408-0.04999,1)-AJ408+AM408)","v":0},{"$f":"IF(VLOOKUP(AF408,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF408,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA410,AG410)","v":19.399999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA410*(1-W410)+0.004999,2)","v":19.399999999999999},null,"",19.399999999999999,{"$f":"+W410","v":0},{"$f":"+X410","v":19.399999999999999},{"$f":"(AG410-AC410)/AG410","v":0},null,12,{"$f":"SUM(AJ410:AL410)+AE410","v":19.399999999999999},null,null,{"$f":"ROUND(AC410/(1-VLOOKUP(AF410,Group,2,FALSE)),2)","v":19.399999999999999},{"$f":"IF(VLOOKUP(AF410,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ410,1)-AJ410,2),Round,2,FALSE)+VLOOKUP(AF410,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF410,Group,7,FALSE)=\"\",0,ROUND(AJ410-0.04999,1)-AJ410+AM410)","v":0},{"$f":"IF(VLOOKUP(AF410,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF410,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"VALENCIA - Porcelain Floor & Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNVA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Chalk          Dove          Natural          White Gloss"]
[]
[null,"Field Tile - MLW",null,"Floor:","6\" x 6\"",null,"Field - Cross",null,null,null,null,null,null,"(24 pcs. Per Carton)",null,"6.14 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA416,AG416)","v":29.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA416*(1-W416)+0.004999,2)","v":29.85},null,"",29.85,{"$f":"+W416","v":0},{"$f":"+X416","v":29.85},{"$f":"(AG416-AC416)/AG416","v":0},null,11,{"$f":"SUM(AJ416:AL416)+AE416","v":29.85},null,null,{"$f":"ROUND(AC416/(1-VLOOKUP(AF416,Group,2,FALSE)),2)","v":29.85},{"$f":"IF(VLOOKUP(AF416,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ416,1)-AJ416,2),Round,2,FALSE)+VLOOKUP(AF416,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF416,Group,7,FALSE)=\"\",0,ROUND(AJ416-0.04999,1)-AJ416+AM416)","v":0},{"$f":"IF(VLOOKUP(AF416,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF416,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"6\" x 6\"",null,"Field - Star",null,null,null,null,null,null,"(16 pcs. Per Carton)",null,"4.10 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA417,AG417)","v":30.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA417*(1-W417)+0.004999,2)","v":30.2},null,"",30.2,{"$f":"+W417","v":0},{"$f":"+X417","v":30.2},{"$f":"(AG417-AC417)/AG417","v":0},null,11,{"$f":"SUM(AJ417:AL417)+AE417","v":30.2},null,null,{"$f":"ROUND(AC417/(1-VLOOKUP(AF417,Group,2,FALSE)),2)","v":30.2},{"$f":"IF(VLOOKUP(AF417,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ417,1)-AJ417,2),Round,2,FALSE)+VLOOKUP(AF417,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF417,Group,7,FALSE)=\"\",0,ROUND(AJ417-0.04999,1)-AJ417+AM417)","v":0},{"$f":"IF(VLOOKUP(AF417,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF417,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\",AA419,AG419)","v":17.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA419*(1-W419)+0.004999,2)","v":17.8},null,"",17.8,{"$f":"+W419","v":0},{"$f":"+X419","v":17.8},{"$f":"(AG419-AC419)/AG419","v":0},null,11,{"$f":"SUM(AJ419:AL419)+AE419","v":17.8},null,null,{"$f":"ROUND(AC419/(1-VLOOKUP(AF419,Group,2,FALSE)),2)","v":17.8},{"$f":"IF(VLOOKUP(AF419,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ419,1)-AJ419,2),Round,2,FALSE)+VLOOKUP(AF419,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF419,Group,7,FALSE)=\"\",0,ROUND(AJ419-0.04999,1)-AJ419+AM419)","v":0},{"$f":"IF(VLOOKUP(AF419,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF419,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) For the Cross and Star pattern, order equal amounts of each.  Example:  100 SF total needed, order 50 SF of the Cross and 50 SF of the Star patterns."]
[]
[null,null,"VINTAGE - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNVI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Auburn          Blue          Green"]
[]
[null,"Field Tile - MLW",null,null,"2.56\" x 7.87\" x 5/16\"",null,"Field - Flat",null,null,null,null,null,null,null,null,"5.39 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA427,AG427)","v":19.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA427*(1-W427)+0.004999,2)","v":19.55},null,"new",19.55,{"$f":"+W427","v":0},{"$f":"+X427","v":19.55},{"$f":"(AG427-AC427)/AG427","v":0},null,11,{"$f":"SUM(AJ427:AL427)+AE427","v":19.55},null,null,{"$f":"ROUND(AC427/(1-VLOOKUP(AF427,Group,2,FALSE)),2)","v":19.55},{"$f":"IF(VLOOKUP(AF427,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ427,1)-AJ427,2),Round,2,FALSE)+VLOOKUP(AF427,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF427,Group,7,FALSE)=\"\",0,ROUND(AJ427-0.04999,1)-AJ427+AM427)","v":0},{"$f":"IF(VLOOKUP(AF427,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF427,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"2.56\" x 7.87\" x 5/16\"",null,"Field (Decorative Pattern)",null,null,null,"Crystal",null,null,null,null,"5.39 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA429,AG429)","v":20.399999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA429*(1-W429)+0.004999,2)","v":20.399999999999999},null,"",20.399999999999999,{"$f":"+W429","v":0},{"$f":"+X429","v":20.399999999999999},{"$f":"(AG429-AC429)/AG429","v":0},null,11,{"$f":"SUM(AJ429:AL429)+AE429","v":20.399999999999999},null,null,{"$f":"ROUND(AC429/(1-VLOOKUP(AF429,Group,2,FALSE)),2)","v":20.399999999999999},{"$f":"IF(VLOOKUP(AF429,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ429,1)-AJ429,2),Round,2,FALSE)+VLOOKUP(AF429,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF429,Group,7,FALSE)=\"\",0,ROUND(AJ429-0.04999,1)-AJ429+AM429)","v":0},{"$f":"IF(VLOOKUP(AF429,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF429,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"2.56\" x 7.87\" x 5/16\"",null,"Field (Decorative Pattern)",null,null,null,"Oval",null,null,null,null,"4.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA430,AG430)","v":20.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA430*(1-W430)+0.004999,2)","v":20.5},null,"",20.5,{"$f":"+W430","v":0},{"$f":"+X430","v":20.5},{"$f":"(AG430-AC430)/AG430","v":0},null,11,{"$f":"SUM(AJ430:AL430)+AE430","v":20.5},null,null,{"$f":"ROUND(AC430/(1-VLOOKUP(AF430,Group,2,FALSE)),2)","v":20.5},{"$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,"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\",AA436,AG436)","v":16.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA436*(1-W436)+0.004999,2)","v":16.7},null,"",16.7,{"$f":"+W436","v":0},{"$f":"+X436","v":16.7},{"$f":"(AG436-AC436)/AG436","v":0},null,11,{"$f":"SUM(AJ436:AL436)+AE436","v":16.7},null,null,{"$f":"ROUND(AC436/(1-VLOOKUP(AF436,Group,2,FALSE)),2)","v":16.7},{"$f":"IF(VLOOKUP(AF436,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ436,1)-AJ436,2),Round,2,FALSE)+VLOOKUP(AF436,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF436,Group,7,FALSE)=\"\",0,ROUND(AJ436-0.04999,1)-AJ436+AM436)","v":0},{"$f":"IF(VLOOKUP(AF436,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF436,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":134,"n_cols":3,"rows_kept":134,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
["2021-04-01","Artista","Porcelain"]
["2021-04-01","Brique","Porcelain"]
["2021-04-01","Cadence","Porcelain"]
["2021-04-01","Cambridge","Ceramic"]
["2021-04-01","Camden","Ceramic"]
["2021-04-01","Charleston","Porcelain"]
["2021-04-01","Cotto Brick","Porcelain"]
["2021-04-01","Empire","Ceramic"]
["2021-04-01","Heavy Metal","Porcelain"]
["2021-04-01","Metro","Ceramic"]
["2021-04-01","Nola","Porcelain"]
["2021-04-01","Piazza","Ceramic"]
["2021-04-01","Piccadilly","Recycled Glass"]
["2021-04-01","Quadrant","Ceramic"]
["2021-04-01","Rainforest","Ceramic"]
["2021-04-01","Shaftwood","Porcelain"]
["2021-04-01","Slate","Natural Stone"]
["2021-04-01","Stella","Porcelain"]
["2021-04-01","Urban","Porcelain"]
["2021-10-01","Alloy","Porcelain Field Tile and Mosaics."]
["2021-10-01","Andalucia","Porcelain 8\" x 8\" Decorative Field Tile."]
["2021-10-01","Cava","Porcelain 6\" x 23.6\" Wall Panels."]
["2021-10-01","Chelsea","Porcelain 2\" x 10\" Field Tile."]
["2021-10-01","Contempo","Ceramic 2\" x 4\" Field Tile."]
["2021-10-01","Cubist","Porcelain 4\" x 4\" on 13\" x 13\" Wall Panels."]
["2021-10-01","Etruscan","Porcelain 10\" x 10\" Field and Decorative Field Tile."]
["2021-10-01","Heirloom","Porcelain."]
["2021-10-01","Kingston Wood","Porcelain."]
["2021-10-01","Limestone","Natural Stone."]
["2021-10-01","Mantra","Porcelain."]
["2021-10-01","Marble","Natural Stone."]
["2021-10-01","Marrakesh","Porcelain."]
["2021-10-01","Nola Black","Porcelain."]
["2021-10-01","Nomad","Porcelain."]
["2021-10-01","Ocean","Ceramic."]
["2021-10-01","Onyx","Porcelain."]
["2021-10-01","Pacific","Porcelain."]
["2021-10-01","Pastiche","Ceramic."]
["2021-10-01","Quarry","Porcelain."]
["2022-02-28","Chiclet","Porcelain Floor & Wall Mosaics."]
["2022-02-28","Moroccan","Porcelain."]
["2022-02-28","Plume","Ceramic."]
["2022-02-28","Petrified Wood","Porcelain."]
["2022-02-28","Pyramid","Ceramic."]
["2022-02-28","Sedona","Ceramic."]
["2022-05-11","Mayfair","Ceramic."]
["2023-07-12","Gatsby","Porcelain."]
["2023-07-12","Gesso","Porcelain."]
["2023-07-12","Heirloom","Porcelain."]
["2023-07-12","Limerick","Porcelain."]
["2023-07-12","Malibu","Porcelain."]
["2023-07-12","Momentum","Ceramic."]
["2023-07-12","Stone Classics","Porcelain."]
["2023-07-12","Terracotta","Porcelain."]
["2023-07-12","Valencia","Porcelain Floor & Ceramic Wall."]
["2023-07-12","Woodridge","Ceramic."]
["2023-11-03","Hampstead","Porcelain."]
["2023-11-03","Hudson Brick","Porcelain."]
["2023-11-03","Normandy","Porcelain."]
["2023-11-03","Portofino","Porcelain."]
["2024-10-10","Atlanta Brick","Porcelain Floor & Wall Tile."]
["2024-10-10","Grand Canyon","Ceramic Wall Tile."]
["2024-10-10","Havana","Ceramic Wall Tile."]
["2024-10-10","Italia","Porcelain Floor & Wall Tile."]
["2024-10-10","Marmol","Porcelain Floor & Wall Tile."]
["2024-10-10","Vintage","Ceramic Wall Tile."]
["2025-03-12","Caliza","Ceramic."]
["2025-03-12","Gibraltar","Porcelain."]
["2025-03-12","Italia","Colors Florence Beige, Florence Gray, Milan Beige, Milan Gray and Venice added."]
["2025-03-12","Slate","Versailles Pattern added to color Black Blizzard only."]
["2025-03-12","Vintage","2.56\" x 7.87\" x 5/16\" Flat Field Tile format added."]
[]
[]
[]
["Discontinued Products"]
["2022-01-27","Cadence","Color Coal Black 7\" x 8\" Hex Field Tile, 4.3\" x 4.3\" Lines, 8.8\" x 8.8\" Rows, 3\" x 17.7\" Tread and 7\" x 8\" Hex Multi Decorative Field Tile only.  Color Sky Blue 3\" x 17.7\" Field Tile  and 8.8\" x 8.8\" Rows Decorative Field Tile only.  All formats in color Storm Gray.  Color Tarnished White 4.3\" x 4.3\" Snakeskin Decorative Field Tile only."]
["2022-01-27","Cambridge","3\" x 12\" Picket Field Tile only in all colors."]
["2022-01-27","Contempo","Entire Series."]
["2022-01-27","Cubist","Entire Series."]
["2022-01-27","Etruscan","Entire Series."]
["2022-01-27","Heavy Metal","Entire Series."]
["2022-01-27","Shaftwood","Entire Series."]
["2022-02-04","Brique","Entire Series."]
["2022-02-04","Heirloom","Entire Series."]
["2022-03-25","Cambridge","Entire Series."]
["2022-03-25","Marble","All formats in color Hawthorne White (Honed) only."]
["2023-02-15","Mantra","Entire Series."]
["2023-02-15","Ocean","Entire Series."]
["2023-06-09","Alloy","3\" Hexagon Mosaic only in all colors."]
["2023-06-09","Limestone","3\" Hexagon Mosaic only in all colors."]
["2023-06-09","Marble","3\" Hexagon Mosaic only in all colors."]
["2023-06-09","Slate","3\" Hexagon Mosaic only in all colors."]
["2023-11-03","Marble","4\" x 12\" Field Tile format only in color White Venatino in both the Honed and the Polished surfaces."]
["2024-02-15","Cadence","Color Coal Black 4.3\" x 8.8\", 3\" x 17.7\" and 8.8\" x 17.7\" Field Tile formats only.  All formats in color Sky Blue.  Color Tarnished White 7\" x 8\" Hex Field Tile format, 3\" x 17.7\" Tread and 7\" x 8\" Hex Multi Decorative Patterns only. "]
["2024-02-15","Camden","4\" x 12\" x 5/16\" Decorative Mix in colors Pearl and White."]
["2024-02-15","Charleston","Colors Montagu and Wentworth only in all formats."]
["2024-02-15","Marrakesh","Entire Series."]
["2024-02-15","Nola","8\" x 8\" x 1/4\" Field Tile format only in colors Gray and White."]
["2024-02-15","Petrified Wood","Entire Series."]
["2024-07-17","Heirloom","Entire Series."]
["2024-11-06","Piccadilly","Due to ongoing issues with the consistency of the mounting of this hexagon mosaic, we will be pulling it from the market."]
["2024-12-02","Mayfair","Entire Series."]
["2025-01-28","Cadence","All formats in color Tarnished White only."]
["2025-01-28","Camden","Entire Series."]
["2025-01-28","Limestone","3\" x 8\", 6\" x 12\", 12\" x 12\" and 12\" x 24\" Field Tile formats only in colors Faro (Honed), Orval (Honed) and St. Bernardus (Honed). "]
["2025-01-28","Marble","3\" x 8\", 6\" x 12\", 12\" x 12\", 12\" x 24\" and 18\" x 36\" Field Tile formats only in color White Venatino (Honed)."]
["2025-01-28","Metro","Entire Series."]
["2025-01-28","Pastiche","Entire Series."]
["2025-01-28","Pyramid","Entire Series."]
["2025-03-12","Limestone","4\" x 12\" and 6\" x 24\" Field Tile, 2\" x 2\" Mosaic, Small Herringbone Mosaic, 12\" Chair Rail and 5/8\" x 12\" Pencil formats only in colors Faro (Honed), Orval (Honed) and St. Bernardus (Honed). "]
["2025-03-12","Marble","Color White Venatino (Honed) in all formats and finishes."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Changes"]