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

{"sheet":"Instructions","index":0,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Concerti"]
["File as","C"]
["Product Code","B"]
["CCTD Effective Date","11/1/24 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"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,null,null,null,"  "]
[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 - 11/1/24 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[1,null,"Alloy",null,"Porcelain",null,3,null,"Momentum",null,"Ceramic"]
[1,null,"Andalucia",null,"Porcelain",null,3,null,"Moroccan",null,"Porcelain"]
[1,null,"Artista",null,"Porcelain",null,4,null,"Nola",null,"Porcelain"]
[1,null,"Atlanta Brick",null,"Porcelain",null,4,null,"Nola Black",null,"Porcelain"]
[1,null,"Cadence",null,"Porcelain",null,4,null,"Nomad",null,"Porcelain"]
[1,null,"Camden",null,"Ceramic",null,4,null,"Normandy",null,"Porcelain"]
[1,null,"Cava",null,"Porcelain",null,4,null,"Onyx",null,"Porcelain"]
[1,null,"Charleston",null,"Porcelain",null,4,null,"Pacific",null,"Porcelain"]
[1,null,"Chelsea",null,"Porcelain",null,4,null,"Pastiche",null,"Ceramic"]
[1,null,"Chiclet",null,"Porcelain",null,4,null,"Piazza",null,"Ceramic"]
[1,null,"Cotto Brick",null,"Porcelain",null,4,null,"Piccadilly (Disc. 11/6/24)",null,"Recycled Glass"]
[1,null,"Empire",null,"Ceramic",null,4,null,"Plume",null,"Ceramic"]
[1,null,"Gatsby",null,"Porcelain",null,4,null,"Portofino",null,"Porcelain"]
[2,null,"Gesso",null,"Porcelain",null,4,null,"Pyramid",null,"Ceramic"]
[2,null,"Grand Canyon",null,"Ceramic",null,4,null,"Quadrant",null,"Ceramic"]
[2,null,"Hampstead",null,"Porcelain",null,5,null,"Quarry",null,"Porcelain"]
[2,null,"Havana",null,"Ceramic",null,5,null,"Rainforest",null,"Ceramic"]
[2,null,"Hudson Brick",null,"Porcelain",null,5,null,"Sedona",null,"Ceramic"]
[2,null,"Italia Pisa",null,"Porcelain",null,5,null,"Slate",null,"Natural Stone"]
[2,null,"Kingston Wood",null,"Porcelain",null,5,null,"Stella",null,"Porcelain"]
[2,null,"Limerick",null,"Ceramic",null,5,null,"Stone Classics",null,"Porcelain"]
["2-3",null,"Limestone",null,"Natural Stone",null,5,null,"Terracotta",null,"Porcelain"]
[3,null,"Malibu",null,"Porcelain",null,6,null,"Urban",null,"Porcelain"]
[3,null,"Marble",null,"Natural Stone",null,6,null,"Valencia",null,"Porcelain & Ceramic"]
[3,null,"Marmol",null,"Porcelain",null,6,null,"Vintage",null,"Ceramic"]
[3,null,"Mayfair (Disc. 12/2/24)",null,"Ceramic",null,6,null,"Woodridge",null,"Ceramic"]
[3,null,"Metro",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":596,"n_cols":41,"rows_kept":596,"cut":false,"hidden":false,"merged":[[582,2,582,19],[20,13,21,19],[585,3,585,4],[24,2,24,19],[23,14,23,15],[580,2,580,19],[19,30,19,32],[16,14,16,15],[15,14,15,19],[15,22,15,23],[15,25,15,32],[18,22,18,23],[18,14,18,19]]}
[null,"Decos - T",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA1*(1-W1)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W1","v":0},0.05,{"$f":"(AG1-AC1)/AG1","v":0},null,1,{"$f":"SUM(AJ1:AL1)+AE1","v":0.05},null,null,{"$f":"ROUND(AC1/(1-VLOOKUP(AF1,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF1,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ1,1)-AJ1,2),Round,2,FALSE)+VLOOKUP(AF1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",0,ROUND(AJ1-0.04999,1)-AJ1+AM1)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF1,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - A",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,2,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Trim - A",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,3,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos - A",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,4,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Field Tile - Turkey",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,5,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Trim - Turkey",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,6,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos - Turkey",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,7,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA8*(1-W8)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W8","v":0},0.05,{"$f":"(AG8-AC8)/AG8","v":0},null,8,{"$f":"SUM(AJ8:AL8)+AE8","v":0.05},null,null,{"$f":"ROUND(AC8/(1-VLOOKUP(AF8,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF8,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ8,1)-AJ8,2),Round,2,FALSE)+VLOOKUP(AF8,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF8,Group,7,FALSE)=\"\",0,ROUND(AJ8-0.04999,1)-AJ8+AM8)","v":0},{"$f":"IF(VLOOKUP(AF8,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF8,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim - MLW Stone",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,9,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos - MLW Stone",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,10,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Field Tile - MLW",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA11,AG11)","v":0.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,{"$f":"+W11","v":0},0.05,0,null,11,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Trim - MLW",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA12,AG12)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,12,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos - MLW",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA13,AG13)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,13,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","a",1000,"ABC",null,null,0.1,1000,null,"ABC",1000,0.1,1000,0.1,10,null,1000,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price List",null,null,null,null,null,null,null,"Cust. Cost",null,null,"Customer Cost Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null," ",null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",AA17,AG17)","v":"List Price"},"U/M","Code",null,"Disc.","Net",null,"Chg","List Price","Disc","Act. Cost","GP%","Adj.","Group","Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'C' - Concerti"},null,null,null,null,null,null,null,"Cost",null,null,null,null,null,null,null,null,null,"Retail Price Calculations",null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Instructions!B4","v":"11/1/24 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-12-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\"",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,null,"Color:","Tarnished White"]
[]
[null,"Field Tile - MLW",null,null,"4.3\" x 8.8\"",null,"Field",null,null,null,null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA64,AG64)","v":15.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":15.35},null,"",15.35,{"$f":"+W64","v":0},15.35,{"$f":"(AG64-AC64)/AG64","v":0},null,11,{"$f":"SUM(AJ64:AL64)+AE64","v":15.35},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":15.35},{"$f":"IF(VLOOKUP(AF64,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ64,1)-AJ64,2),Round,2,FALSE)+VLOOKUP(AF64,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",0,ROUND(AJ64-0.04999,1)-AJ64+AM64)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF64,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"3\" x 17.7\"",null,"Field",null,null,null,null,null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":19.350000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":19.350000000000001},null,"",19.350000000000001,0,19.350000000000001,{"$f":"(AG65-AC65)/AG65","v":0},null,11,{"$f":"SUM(AJ65:AL65)+AE65","v":19.350000000000001},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":19.350000000000001},{"$f":"IF(VLOOKUP(AF65,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ65,1)-AJ65,2),Round,2,FALSE)+VLOOKUP(AF65,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",0,ROUND(AJ65-0.04999,1)-AJ65+AM65)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF65,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"8.8\" x 17.7\"",null,"Field",null,null,null,null,null,null,null,null,"10.87 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":13.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA66*(1-W66)+0.004999,2)","v":13.8},null,"",13.8,0,13.8,{"$f":"(AG66-AC66)/AG66","v":0},null,11,{"$f":"SUM(AJ66:AL66)+AE66","v":13.8},null,null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":13.8},{"$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,"4.3\" x 4.3\"",null,"Field (Decorative Pattern)",null,null,null,"Lanes",null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA68,AG68)","v":16.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA68*(1-W68)+0.004999,2)","v":16.55},null,"",16.55,{"$f":"+W68","v":0},16.55,{"$f":"(AG68-AC68)/AG68","v":0},null,11,{"$f":"SUM(AJ68:AL68)+AE68","v":16.55},null,null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":16.55},{"$f":"IF(VLOOKUP(AF68,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ68,1)-AJ68,2),Round,2,FALSE)+VLOOKUP(AF68,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",0,ROUND(AJ68-0.04999,1)-AJ68+AM68)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF68,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"4.3\" x 8.8\"",null,"Field (Decorative Pattern)",null,null,null,"Canvas",null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA69,AG69)","v":15.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA69*(1-W69)+0.004999,2)","v":15.95},null,"",15.95,0,15.95,{"$f":"(AG69-AC69)/AG69","v":0},null,11,{"$f":"SUM(AJ69:AL69)+AE69","v":15.95},null,null,{"$f":"ROUND(AC69/(1-VLOOKUP(AF69,Group,2,FALSE)),2)","v":15.95},{"$f":"IF(VLOOKUP(AF69,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ69,1)-AJ69,2),Round,2,FALSE)+VLOOKUP(AF69,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF69,Group,7,FALSE)=\"\",0,ROUND(AJ69-0.04999,1)-AJ69+AM69)","v":0},{"$f":"IF(VLOOKUP(AF69,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF69,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CAMDEN - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNCD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Blue",null,"Gray",null,"        Pearl",null,"    White"]
[null,null,null,null,"Crème",null,"Olive",null,"        Tea"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 12\" x 1/4\"",null,"Field",null,null,null,null,null,null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA76,AG76)","v":11.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":11.1},null,"",11.1,{"$f":"+W76","v":0},{"$f":"+X76","v":11.1},{"$f":"(AG76-AC76)/AG76","v":0},null,11,{"$f":"SUM(AJ76:AL76)+AE76","v":11.1},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":11.1},{"$f":"IF(VLOOKUP(AF76,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ76,1)-AJ76,2),Round,2,FALSE)+VLOOKUP(AF76,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",0,ROUND(AJ76-0.04999,1)-AJ76+AM76)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF76,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA78,AG78)","v":9.1999999999999993},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":9.1999999999999993},null,"",9.1999999999999993,{"$f":"+W78","v":0},{"$f":"+X78","v":9.1999999999999993},{"$f":"(AG78-AC78)/AG78","v":0},null,12,{"$f":"SUM(AJ78:AL78)+AE78","v":9.1999999999999993},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":9.1999999999999993},{"$f":"IF(VLOOKUP(AF78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ78,1)-AJ78,2),Round,2,FALSE)+VLOOKUP(AF78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",0,ROUND(AJ78-0.04999,1)-AJ78+AM78)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF78,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA84,AG84)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":13.5},null,"",13.5,{"$f":"+W84","v":0},{"$f":"+X84","v":13.5},{"$f":"(AG84-AC84)/AG84","v":0},null,11,{"$f":"SUM(AJ84:AL84)+AE84","v":13.5},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF84,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ84,1)-AJ84,2),Round,2,FALSE)+VLOOKUP(AF84,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",0,ROUND(AJ84-0.04999,1)-AJ84+AM84)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF84,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA90,AG90)","v":13.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA90*(1-W90)+0.004999,2)","v":13.95},null,"",13.95,{"$f":"+W90","v":0},{"$f":"+X90","v":13.95},{"$f":"(AG90-AC90)/AG90","v":0},null,11,{"$f":"SUM(AJ90:AL90)+AE90","v":13.95},null,null,{"$f":"ROUND(AC90/(1-VLOOKUP(AF90,Group,2,FALSE)),2)","v":13.95},{"$f":"IF(VLOOKUP(AF90,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ90,1)-AJ90,2),Round,2,FALSE)+VLOOKUP(AF90,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,7,FALSE)=\"\",0,ROUND(AJ90-0.04999,1)-AJ90+AM90)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF90,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA97,AG97)","v":18.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA97*(1-W97)+0.004999,2)","v":18.05},null,"",18.05,{"$f":"+W97","v":0},{"$f":"+X97","v":18.05},{"$f":"(AG97-AC97)/AG97","v":0},null,11,{"$f":"SUM(AJ97:AL97)+AE97","v":18.05},null,null,{"$f":"ROUND(AC97/(1-VLOOKUP(AF97,Group,2,FALSE)),2)","v":18.05},{"$f":"IF(VLOOKUP(AF97,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ97,1)-AJ97,2),Round,2,FALSE)+VLOOKUP(AF97,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",0,ROUND(AJ97-0.04999,1)-AJ97+AM97)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF97,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\",AA99,AG99)","v":24.15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA99*(1-W99)+0.004999,2)","v":24.15},null,"",24.15,{"$f":"+W99","v":0},{"$f":"+X99","v":24.15},{"$f":"(AG99-AC99)/AG99","v":0},null,12,{"$f":"SUM(AJ99:AL99)+AE99","v":24.15},null,null,{"$f":"ROUND(AC99/(1-VLOOKUP(AF99,Group,2,FALSE)),2)","v":24.15},{"$f":"IF(VLOOKUP(AF99,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ99,1)-AJ99,2),Round,2,FALSE)+VLOOKUP(AF99,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,7,FALSE)=\"\",0,ROUND(AJ99-0.04999,1)-AJ99+AM99)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF99,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA106,AG106)","v":27.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":27.7},null,"",27.7,{"$f":"+W106","v":0},{"$f":"+X106","v":27.7},{"$f":"(AG106-AC106)/AG106","v":0},null,13,{"$f":"SUM(AJ106:AL106)+AE106","v":27.7},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":27.7},{"$f":"IF(VLOOKUP(AF106,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ106,1)-AJ106,2),Round,2,FALSE)+VLOOKUP(AF106,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",0,ROUND(AJ106-0.04999,1)-AJ106+AM106)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF106,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA112,AG112)","v":16.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA112*(1-W112)+0.004999,2)","v":16.5},null,"",16.5,{"$f":"+W112","v":0},{"$f":"+X112","v":16.5},{"$f":"(AG112-AC112)/AG112","v":0},null,11,{"$f":"SUM(AJ112:AL112)+AE112","v":16.5},null,null,{"$f":"ROUND(AC112/(1-VLOOKUP(AF112,Group,2,FALSE)),2)","v":16.5},{"$f":"IF(VLOOKUP(AF112,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ112,1)-AJ112,2),Round,2,FALSE)+VLOOKUP(AF112,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",0,ROUND(AJ112-0.04999,1)-AJ112+AM112)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF112,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - 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\",AA113,AG113)","v":16.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA113*(1-W113)+0.004999,2)","v":16.5},null,"",16.5,{"$f":"+W113","v":0},{"$f":"+X113","v":16.5},{"$f":"(AG113-AC113)/AG113","v":0},null,11,{"$f":"SUM(AJ113:AL113)+AE113","v":16.5},null,null,{"$f":"ROUND(AC113/(1-VLOOKUP(AF113,Group,2,FALSE)),2)","v":16.5},{"$f":"IF(VLOOKUP(AF113,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ113,1)-AJ113,2),Round,2,FALSE)+VLOOKUP(AF113,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",0,ROUND(AJ113-0.04999,1)-AJ113+AM113)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF113,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA119,AG119)","v":15.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA119*(1-W119)+0.004999,2)","v":15.95},null,"",15.95,{"$f":"+W119","v":0},{"$f":"+X119","v":15.95},{"$f":"(AG119-AC119)/AG119","v":0},null,11,{"$f":"SUM(AJ119:AL119)+AE119","v":15.95},null,null,{"$f":"ROUND(AC119/(1-VLOOKUP(AF119,Group,2,FALSE)),2)","v":15.95},{"$f":"IF(VLOOKUP(AF119,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ119,1)-AJ119,2),Round,2,FALSE)+VLOOKUP(AF119,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",0,ROUND(AJ119-0.04999,1)-AJ119+AM119)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF119,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"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\",AA123,AG123)","v":17.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA123*(1-W123)+0.004999,2)","v":17.45},null,"",17.45,{"$f":"+W123","v":0},{"$f":"+X123","v":17.45},{"$f":"(AG123-AC123)/AG123","v":0},null,11,{"$f":"SUM(AJ123:AL123)+AE123","v":17.45},null,null,{"$f":"ROUND(AC123/(1-VLOOKUP(AF123,Group,2,FALSE)),2)","v":17.45},{"$f":"IF(VLOOKUP(AF123,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ123,1)-AJ123,2),Round,2,FALSE)+VLOOKUP(AF123,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",0,ROUND(AJ123-0.04999,1)-AJ123+AM123)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF123,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA127,AG127)","v":26.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA127*(1-W127)+0.004999,2)","v":26.9},null,"",26.9,{"$f":"+W127","v":0},{"$f":"+X127","v":26.9},{"$f":"(AG127-AC127)/AG127","v":0},null,11,{"$f":"SUM(AJ127:AL127)+AE127","v":26.9},null,null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":26.9},{"$f":"IF(VLOOKUP(AF127,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ127,1)-AJ127,2),Round,2,FALSE)+VLOOKUP(AF127,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",0,ROUND(AJ127-0.04999,1)-AJ127+AM127)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF127,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA133,AG133)","v":14.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA133*(1-W133)+0.004999,2)","v":14.7},null,"",14.7,{"$f":"+W133","v":0},{"$f":"+X133","v":14.7},{"$f":"(AG133-AC133)/AG133","v":0},null,11,{"$f":"SUM(AJ133:AL133)+AE133","v":14.7},null,null,{"$f":"ROUND(AC133/(1-VLOOKUP(AF133,Group,2,FALSE)),2)","v":14.7},{"$f":"IF(VLOOKUP(AF133,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ133,1)-AJ133,2),Round,2,FALSE)+VLOOKUP(AF133,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",0,ROUND(AJ133-0.04999,1)-AJ133+AM133)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF133,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"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\",AA135,AG135)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA135*(1-W135)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W135","v":0},{"$f":"+X135","v":15.3},{"$f":"(AG135-AC135)/AG135","v":0},null,11,{"$f":"SUM(AJ135:AL135)+AE135","v":15.3},null,null,{"$f":"ROUND(AC135/(1-VLOOKUP(AF135,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF135,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ135,1)-AJ135,2),Round,2,FALSE)+VLOOKUP(AF135,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",0,ROUND(AJ135-0.04999,1)-AJ135+AM135)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF135,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA136,AG136)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA136*(1-W136)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W136","v":0},{"$f":"+X136","v":15.3},{"$f":"(AG136-AC136)/AG136","v":0},null,11,{"$f":"SUM(AJ136:AL136)+AE136","v":15.3},null,null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF136,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ136,1)-AJ136,2),Round,2,FALSE)+VLOOKUP(AF136,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",0,ROUND(AJ136-0.04999,1)-AJ136+AM136)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF136,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA137,AG137)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA137*(1-W137)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W137","v":0},{"$f":"+X137","v":15.3},{"$f":"(AG137-AC137)/AG137","v":0},null,11,{"$f":"SUM(AJ137:AL137)+AE137","v":15.3},null,null,{"$f":"ROUND(AC137/(1-VLOOKUP(AF137,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF137,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ137,1)-AJ137,2),Round,2,FALSE)+VLOOKUP(AF137,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",0,ROUND(AJ137-0.04999,1)-AJ137+AM137)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF137,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA143,AG143)","v":18},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA143*(1-W143)+0.004999,2)","v":18},null,"",18,{"$f":"+W143","v":0},{"$f":"+X143","v":18},{"$f":"(AG143-AC143)/AG143","v":0},null,11,{"$f":"SUM(AJ143:AL143)+AE143","v":18},null,null,{"$f":"ROUND(AC143/(1-VLOOKUP(AF143,Group,2,FALSE)),2)","v":18},{"$f":"IF(VLOOKUP(AF143,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ143,1)-AJ143,2),Round,2,FALSE)+VLOOKUP(AF143,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",0,ROUND(AJ143-0.04999,1)-AJ143+AM143)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF143,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA150,AG150)","v":15.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA150*(1-W150)+0.004999,2)","v":15.05},null,"",15.05,{"$f":"+W150","v":0},{"$f":"+X150","v":15.05},{"$f":"(AG150-AC150)/AG150","v":0},null,11,{"$f":"SUM(AJ150:AL150)+AE150","v":15.05},null,null,{"$f":"ROUND(AC150/(1-VLOOKUP(AF150,Group,2,FALSE)),2)","v":15.05},{"$f":"IF(VLOOKUP(AF150,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ150,1)-AJ150,2),Round,2,FALSE)+VLOOKUP(AF150,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF150,Group,7,FALSE)=\"\",0,ROUND(AJ150-0.04999,1)-AJ150+AM150)","v":0},{"$f":"IF(VLOOKUP(AF150,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF150,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\",AA157,AG157)","v":14.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":14.45},null,"",14.45,{"$f":"+W157","v":0},{"$f":"+X157","v":14.45},{"$f":"(AG157-AC157)/AG157","v":0},null,11,{"$f":"SUM(AJ157:AL157)+AE157","v":14.45},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":14.45},{"$f":"IF(VLOOKUP(AF157,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ157,1)-AJ157,2),Round,2,FALSE)+VLOOKUP(AF157,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",0,ROUND(AJ157-0.04999,1)-AJ157+AM157)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF157,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA165,AG165)","v":14.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA165*(1-W165)+0.004999,2)","v":14.6},null,"",14.6,{"$f":"+W165","v":0},{"$f":"+X165","v":14.6},{"$f":"(AG165-AC165)/AG165","v":0},null,11,{"$f":"SUM(AJ165:AL165)+AE165","v":14.6},null,null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":14.6},{"$f":"IF(VLOOKUP(AF165,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ165,1)-AJ165,2),Round,2,FALSE)+VLOOKUP(AF165,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",0,ROUND(AJ165-0.04999,1)-AJ165+AM165)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF165,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"ITALIA PISA - 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,null,null,"Color:","Italia 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\",AA171,AG171)","v":20.149999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA171*(1-W171)+0.004999,2)","v":20.149999999999999},null,"",20.149999999999999,{"$f":"+W171","v":0},{"$f":"+X171","v":20.149999999999999},{"$f":"(AG171-AC171)/AG171","v":0},null,11,{"$f":"SUM(AJ171:AL171)+AE171","v":20.149999999999999},null,null,{"$f":"ROUND(AC171/(1-VLOOKUP(AF171,Group,2,FALSE)),2)","v":20.149999999999999},{"$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,"Item # Lookup:","CNLI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Color:","Faro (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"6.80 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA189,AG189)","v":17.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA189*(1-W189)+0.004999,2)","v":17.8},null,"",17.8,{"$f":"+W189","v":0},17.8,{"$f":"(AG189-AC189)/AG189","v":0},null,8,{"$f":"SUM(AJ189:AL189)+AE189","v":17.8},null,null,{"$f":"ROUND(AC189/(1-VLOOKUP(AF189,Group,2,FALSE)),2)","v":17.8},{"$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,"4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,"a",28.25,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},28.25,null,"",28.25,0,28.25,0,null,8,28.25,null,null,28.25,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,17.8,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},17.8,null,"",17.8,0,17.8,0,null,8,17.8,null,null,17.8,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,17.100000000000001,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},17.100000000000001,null,"",17.100000000000001,0,17.100000000000001,0,null,8,17.100000000000001,null,null,17.100000000000001,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA193,AG193)","v":28.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA193*(1-W193)+0.004999,2)","v":28.7},null,"",28.7,{"$f":"+W193","v":0},{"$f":"+X193","v":28.7},{"$f":"(AG193-AC193)/AG193","v":0},null,8,{"$f":"SUM(AJ193:AL193)+AE193","v":28.7},null,null,{"$f":"ROUND(AC193/(1-VLOOKUP(AF193,Group,2,FALSE)),2)","v":28.7},{"$f":"IF(VLOOKUP(AF193,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ193,1)-AJ193,2),Round,2,FALSE)+VLOOKUP(AF193,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF193,Group,7,FALSE)=\"\",0,ROUND(AJ193-0.04999,1)-AJ193+AM193)","v":0},{"$f":"IF(VLOOKUP(AF193,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF193,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"12.00 SF/CTN",null,null,19.55,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},19.55,null,"",19.55,0,19.55,0,null,8,19.55,null,null,19.55,0,0,"",null,"X"]
[]
[null,"Decos - MLW Stone",null,null,"13.75\" x 13.75\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(1.36 SF/Sheet)",null,null,"6.80 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA196,AG196)","v":53.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA196*(1-W196)+0.004999,2)","v":53.4},null,"",53.4,{"$f":"+W196","v":0},{"$f":"+X196","v":53.4},{"$f":"(AG196-AC196)/AG196","v":0},null,10,{"$f":"SUM(AJ196:AL196)+AE196","v":53.4},null,null,{"$f":"ROUND(AC196/(1-VLOOKUP(AF196,Group,2,FALSE)),2)","v":53.4},{"$f":"IF(VLOOKUP(AF196,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ196,1)-AJ196,2),Round,2,FALSE)+VLOOKUP(AF196,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF196,Group,7,FALSE)=\"\",0,ROUND(AJ196-0.04999,1)-AJ196+AM196)","v":0},{"$f":"IF(VLOOKUP(AF196,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF196,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\",AA197,AG197)","v":58.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA197*(1-W197)+0.004999,2)","v":58.8},null,"",58.8,0,58.8,{"$f":"(AG197-AC197)/AG197","v":0},null,10,{"$f":"SUM(AJ197:AL197)+AE197","v":58.8},null,null,{"$f":"ROUND(AC197/(1-VLOOKUP(AF197,Group,2,FALSE)),2)","v":58.8},{"$f":"IF(VLOOKUP(AF197,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ197,1)-AJ197,2),Round,2,FALSE)+VLOOKUP(AF197,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF197,Group,7,FALSE)=\"\",0,ROUND(AJ197-0.04999,1)-AJ197+AM197)","v":0},{"$f":"IF(VLOOKUP(AF197,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF197,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW Stone",null,null,"12\"",null,"Chair Rail",null,null,null," ",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA199,AG199)","v":20.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA199*(1-W199)+0.004999,2)","v":20.9},null,"",20.9,{"$f":"+W199","v":0},{"$f":"+X199","v":20.9},{"$f":"(AG199-AC199)/AG199","v":0},null,9,{"$f":"SUM(AJ199:AL199)+AE199","v":20.9},null,null,{"$f":"ROUND(AC199/(1-VLOOKUP(AF199,Group,2,FALSE)),2)","v":20.9},{"$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,"Trim - MLW Stone",null,null,"5/8\" x 12\"",null,"Pencil",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA200,AG200)","v":15.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA200*(1-W200)+0.004999,2)","v":15.9},null,"",15.9,0,15.9,{"$f":"(AG200-AC200)/AG200","v":0},null,9,{"$f":"SUM(AJ200:AL200)+AE200","v":15.9},null,null,{"$f":"ROUND(AC200/(1-VLOOKUP(AF200,Group,2,FALSE)),2)","v":15.9},{"$f":"IF(VLOOKUP(AF200,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ200,1)-AJ200,2),Round,2,FALSE)+VLOOKUP(AF200,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF200,Group,7,FALSE)=\"\",0,ROUND(AJ200-0.04999,1)-AJ200+AM200)","v":0},{"$f":"IF(VLOOKUP(AF200,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF200,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Color:","Orval (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"6.80 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA204,AG204)","v":23.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA204*(1-W204)+0.004999,2)","v":23.1},null,"",23.1,{"$f":"+W204","v":0},{"$f":"+X204","v":23.1},{"$f":"(AG204-AC204)/AG204","v":0},null,8,{"$f":"SUM(AJ204:AL204)+AE204","v":23.1},null,null,{"$f":"ROUND(AC204/(1-VLOOKUP(AF204,Group,2,FALSE)),2)","v":23.1},{"$f":"IF(VLOOKUP(AF204,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ204,1)-AJ204,2),Round,2,FALSE)+VLOOKUP(AF204,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF204,Group,7,FALSE)=\"\",0,ROUND(AJ204-0.04999,1)-AJ204+AM204)","v":0},{"$f":"IF(VLOOKUP(AF204,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF204,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,"a",31.85,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},31.85,null,"",31.85,0,31.85,0,null,8,31.85,null,null,31.85,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,21.95,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},21.95,null,"",21.95,0,21.95,0,null,8,21.95,null,null,21.95,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,22.55,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},22.55,null,"",22.55,0,22.55,0,null,8,22.55,null,null,22.55,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA208,AG208)","v":32.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA208*(1-W208)+0.004999,2)","v":32.1},null,"",32.1,{"$f":"+W208","v":0},{"$f":"+X208","v":32.1},{"$f":"(AG208-AC208)/AG208","v":0},null,8,{"$f":"SUM(AJ208:AL208)+AE208","v":32.1},null,null,{"$f":"ROUND(AC208/(1-VLOOKUP(AF208,Group,2,FALSE)),2)","v":32.1},{"$f":"IF(VLOOKUP(AF208,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ208,1)-AJ208,2),Round,2,FALSE)+VLOOKUP(AF208,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF208,Group,7,FALSE)=\"\",0,ROUND(AJ208-0.04999,1)-AJ208+AM208)","v":0},{"$f":"IF(VLOOKUP(AF208,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF208,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"12.00 SF/CTN",null,null,24.4,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},24.4,null,"",24.4,0,24.4,0,null,8,24.4,null,null,24.4,0,0,"",null,"X"]
[]
[null,"Decos - MLW Stone",null,null,"13.75\" x 13.75\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(1.36 SF/Sheet)",null,null,"6.80 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA211,AG211)","v":60.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA211*(1-W211)+0.004999,2)","v":60.35},null,"",60.35,{"$f":"+W211","v":0},60.35,{"$f":"(AG211-AC211)/AG211","v":0},null,10,{"$f":"SUM(AJ211:AL211)+AE211","v":60.35},null,null,{"$f":"ROUND(AC211/(1-VLOOKUP(AF211,Group,2,FALSE)),2)","v":60.35},{"$f":"IF(VLOOKUP(AF211,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ211,1)-AJ211,2),Round,2,FALSE)+VLOOKUP(AF211,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF211,Group,7,FALSE)=\"\",0,ROUND(AJ211-0.04999,1)-AJ211+AM211)","v":0},{"$f":"IF(VLOOKUP(AF211,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF211,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA212,AG212)","v":63.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA212*(1-W212)+0.004999,2)","v":63.05},null,"",63.05,0,63.05,{"$f":"(AG212-AC212)/AG212","v":0},null,10,{"$f":"SUM(AJ212:AL212)+AE212","v":63.05},null,null,{"$f":"ROUND(AC212/(1-VLOOKUP(AF212,Group,2,FALSE)),2)","v":63.05},{"$f":"IF(VLOOKUP(AF212,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ212,1)-AJ212,2),Round,2,FALSE)+VLOOKUP(AF212,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF212,Group,7,FALSE)=\"\",0,ROUND(AJ212-0.04999,1)-AJ212+AM212)","v":0},{"$f":"IF(VLOOKUP(AF212,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF212,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW Stone",null,null,"12\"",null,"Chair Rail",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA214,AG214)","v":24.55},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA214*(1-W214)+0.004999,2)","v":24.55},null,"",24.55,{"$f":"+W214","v":0},{"$f":"+X214","v":24.55},{"$f":"(AG214-AC214)/AG214","v":0},null,9,{"$f":"SUM(AJ214:AL214)+AE214","v":24.55},null,null,{"$f":"ROUND(AC214/(1-VLOOKUP(AF214,Group,2,FALSE)),2)","v":24.55},{"$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,"Trim - MLW Stone",null,null,"5/8\" x 12\"",null,"Pencil",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA215,AG215)","v":17.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA215*(1-W215)+0.004999,2)","v":17.7},null,"",17.7,{"$f":"+W215","v":0},{"$f":"+X215","v":17.7},{"$f":"(AG215-AC215)/AG215","v":0},null,9,{"$f":"SUM(AJ215:AL215)+AE215","v":17.7},null,null,{"$f":"ROUND(AC215/(1-VLOOKUP(AF215,Group,2,FALSE)),2)","v":17.7},{"$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,"Color:","St. Bernardus (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"6.80 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA219,AG219)","v":19.100000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA219*(1-W219)+0.004999,2)","v":19.100000000000001},null,"",19.100000000000001,{"$f":"+W219","v":0},{"$f":"+X219","v":19.100000000000001},{"$f":"(AG219-AC219)/AG219","v":0},null,8,{"$f":"SUM(AJ219:AL219)+AE219","v":19.100000000000001},null,null,{"$f":"ROUND(AC219/(1-VLOOKUP(AF219,Group,2,FALSE)),2)","v":19.100000000000001},{"$f":"IF(VLOOKUP(AF219,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ219,1)-AJ219,2),Round,2,FALSE)+VLOOKUP(AF219,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF219,Group,7,FALSE)=\"\",0,ROUND(AJ219-0.04999,1)-AJ219+AM219)","v":0},{"$f":"IF(VLOOKUP(AF219,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF219,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,"a",28.25,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},28.25,null,"",28.25,0,28.25,0,null,8,28.25,null,null,28.25,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,19.25,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},19.25,null,"",19.25,0,19.25,0,null,8,19.25,null,null,19.25,0,0,"",null,"X"]
[]
[null,null,"continued on next page"]
[null,null,"LIMESTONE - Natural Stone - continued",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CNLI"]
[]
[null,null,null,"Color:","St. Bernardus (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"6.80 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA228,AG228)","v":19.100000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA228*(1-W228)+0.004999,2)","v":19.100000000000001},null,"",19.100000000000001,{"$f":"+W228","v":0},{"$f":"+X228","v":19.100000000000001},{"$f":"(AG228-AC228)/AG228","v":0},null,8,{"$f":"SUM(AJ228:AL228)+AE228","v":19.100000000000001},null,null,{"$f":"ROUND(AC228/(1-VLOOKUP(AF228,Group,2,FALSE)),2)","v":19.100000000000001},{"$f":"IF(VLOOKUP(AF228,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ228,1)-AJ228,2),Round,2,FALSE)+VLOOKUP(AF228,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF228,Group,7,FALSE)=\"\",0,ROUND(AJ228-0.04999,1)-AJ228+AM228)","v":0},{"$f":"IF(VLOOKUP(AF228,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF228,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone"," ",null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,19.100000000000001,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},19.100000000000001,null,"",19.100000000000001,0,19.100000000000001,0,null,8,19.100000000000001,null,null,19.100000000000001,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA230,AG230)","v":29.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA230*(1-W230)+0.004999,2)","v":29.55},null,"",29.55,{"$f":"+W230","v":0},{"$f":"+X230","v":29.55},{"$f":"(AG230-AC230)/AG230","v":0},null,8,{"$f":"SUM(AJ230:AL230)+AE230","v":29.55},null,null,{"$f":"ROUND(AC230/(1-VLOOKUP(AF230,Group,2,FALSE)),2)","v":29.55},{"$f":"IF(VLOOKUP(AF230,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ230,1)-AJ230,2),Round,2,FALSE)+VLOOKUP(AF230,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF230,Group,7,FALSE)=\"\",0,ROUND(AJ230-0.04999,1)-AJ230+AM230)","v":0},{"$f":"IF(VLOOKUP(AF230,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF230,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"12.00 SF/CTN",null,null,21.95,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},21.95,null,"",21.95,0,21.95,0,null,8,21.95,null,null,21.95,0,0,"",null,"X"]
[]
[null,"Decos - MLW Stone",null,null,"13.75\" x 13.75\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(1.36 SF/Sheet)",null,null,"6.80 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA233,AG233)","v":54.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA233*(1-W233)+0.004999,2)","v":54.6},null,"",54.6,{"$f":"+W233","v":0},54.6,{"$f":"(AG233-AC233)/AG233","v":0},null,10,{"$f":"SUM(AJ233:AL233)+AE233","v":54.6},null,null,{"$f":"ROUND(AC233/(1-VLOOKUP(AF233,Group,2,FALSE)),2)","v":54.6},{"$f":"IF(VLOOKUP(AF233,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ233,1)-AJ233,2),Round,2,FALSE)+VLOOKUP(AF233,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF233,Group,7,FALSE)=\"\",0,ROUND(AJ233-0.04999,1)-AJ233+AM233)","v":0},{"$f":"IF(VLOOKUP(AF233,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF233,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\",AA234,AG234)","v":58.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA234*(1-W234)+0.004999,2)","v":58.8},null,"",58.8,0,58.8,{"$f":"(AG234-AC234)/AG234","v":0},null,10,{"$f":"SUM(AJ234:AL234)+AE234","v":58.8},null,null,{"$f":"ROUND(AC234/(1-VLOOKUP(AF234,Group,2,FALSE)),2)","v":58.8},{"$f":"IF(VLOOKUP(AF234,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ234,1)-AJ234,2),Round,2,FALSE)+VLOOKUP(AF234,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF234,Group,7,FALSE)=\"\",0,ROUND(AJ234-0.04999,1)-AJ234+AM234)","v":0},{"$f":"IF(VLOOKUP(AF234,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF234,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW Stone",null,null,"12\"",null,"Chair Rail",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA236,AG236)","v":24.55},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA236*(1-W236)+0.004999,2)","v":24.55},null,"",24.55,{"$f":"+W236","v":0},{"$f":"+X236","v":24.55},{"$f":"(AG236-AC236)/AG236","v":0},null,9,{"$f":"SUM(AJ236:AL236)+AE236","v":24.55},null,null,{"$f":"ROUND(AC236/(1-VLOOKUP(AF236,Group,2,FALSE)),2)","v":24.55},{"$f":"IF(VLOOKUP(AF236,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ236,1)-AJ236,2),Round,2,FALSE)+VLOOKUP(AF236,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",0,ROUND(AJ236-0.04999,1)-AJ236+AM236)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF236,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim - MLW Stone",null,null,"5/8\" x 12\"",null,"Pencil",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA237,AG237)","v":17.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA237*(1-W237)+0.004999,2)","v":17.7},null,"",17.7,{"$f":"+W237","v":0},{"$f":"+X237","v":17.7},{"$f":"(AG237-AC237)/AG237","v":0},null,9,{"$f":"SUM(AJ237:AL237)+AE237","v":17.7},null,null,{"$f":"ROUND(AC237/(1-VLOOKUP(AF237,Group,2,FALSE)),2)","v":17.7},{"$f":"IF(VLOOKUP(AF237,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ237,1)-AJ237,2),Round,2,FALSE)+VLOOKUP(AF237,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF237,Group,7,FALSE)=\"\",0,ROUND(AJ237-0.04999,1)-AJ237+AM237)","v":0},{"$f":"IF(VLOOKUP(AF237,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF237,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Special Order - approximately 3-4 weeks.",null,null,null,null,null,"b) Minimum purchase is 13.60 SF, (2 cartons)."]
[]
[null,null,"MALIBU - Porcelain Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNML",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Blue             Gray             Lime             Taupe             White"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 12\"",null,"Field",null,null,"Ripple",null,null,null,null,null,"5.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA245,AG245)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA245*(1-W245)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W245","v":0},{"$f":"+X245","v":18.7},{"$f":"(AG245-AC245)/AG245","v":0},null,11,{"$f":"SUM(AJ245:AL245)+AE245","v":18.7},null,null,{"$f":"ROUND(AC245/(1-VLOOKUP(AF245,Group,2,FALSE)),2)","v":18.7},{"$f":"IF(VLOOKUP(AF245,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ245,1)-AJ245,2),Round,2,FALSE)+VLOOKUP(AF245,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF245,Group,7,FALSE)=\"\",0,ROUND(AJ245-0.04999,1)-AJ245+AM245)","v":0},{"$f":"IF(VLOOKUP(AF245,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF245,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"4\" x 12\"",null,"Field",null,null,"Wave",null,null,null,null,null,"5.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA246,AG246)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA246*(1-W246)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W246","v":0},{"$f":"+X246","v":18.7},{"$f":"(AG246-AC246)/AG246","v":0},null,11,{"$f":"SUM(AJ246:AL246)+AE246","v":18.7},null,null,{"$f":"ROUND(AC246/(1-VLOOKUP(AF246,Group,2,FALSE)),2)","v":18.7},{"$f":"IF(VLOOKUP(AF246,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ246,1)-AJ246,2),Round,2,FALSE)+VLOOKUP(AF246,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF246,Group,7,FALSE)=\"\",0,ROUND(AJ246-0.04999,1)-AJ246+AM246)","v":0},{"$f":"IF(VLOOKUP(AF246,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF246,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"MARBLE - Natural Stone",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNMA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Color:","White Venatino (Honed)"]
[]
[null,"Field Tile - MLW Stone",null,null,"3\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"5.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA252,AG252)","v":26.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA252*(1-W252)+0.004999,2)","v":26.7},null,"",26.7,{"$f":"+W252","v":0},{"$f":"+X252","v":26.7},{"$f":"(AG252-AC252)/AG252","v":0},null,8,{"$f":"SUM(AJ252:AL252)+AE252","v":26.7},null,null,{"$f":"ROUND(AC252/(1-VLOOKUP(AF252,Group,2,FALSE)),2)","v":26.7},{"$f":"IF(VLOOKUP(AF252,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ252,1)-AJ252,2),Round,2,FALSE)+VLOOKUP(AF252,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF252,Group,7,FALSE)=\"\",0,ROUND(AJ252-0.04999,1)-AJ252+AM252)","v":0},{"$f":"IF(VLOOKUP(AF252,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF252,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"3\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"7.50 SF/CTN",null,null,26.25,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},26.25,null,"",26.25,0,26.25,0,null,8,26.25,null,null,26.25,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"5.00 SF/CTN",null,null,27.1,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},27.1,null,"",27.1,0,27.1,0,null,8,27.1,null,null,27.1,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA255,AG255)","v":23.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA255*(1-W255)+0.004999,2)","v":23.95},null,"",23.95,{"$f":"+W255","v":0},{"$f":"+X255","v":23.95},{"$f":"(AG255-AC255)/AG255","v":0},null,8,{"$f":"SUM(AJ255:AL255)+AE255","v":23.95},null,null,{"$f":"ROUND(AC255/(1-VLOOKUP(AF255,Group,2,FALSE)),2)","v":23.95},{"$f":"IF(VLOOKUP(AF255,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ255,1)-AJ255,2),Round,2,FALSE)+VLOOKUP(AF255,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",0,ROUND(AJ255-0.04999,1)-AJ255+AM255)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF255,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,"a",35.1,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},35.1,null,"",35.1,0,35.1,0,null,8,35.1,null,null,35.1,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"12.00 SF/CTN",null,null,24.8,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},24.8,null,"",24.8,0,24.8,0,null,8,24.8,null,null,24.8,0,0,"",null,"X"]
[null,"Field Tile - MLW Stone",null,null,"18\" x 36\"",null,"Field",null,null,null,null,null,null,null,null,"4.50 SF/PC",null,null,{"$f":"IF(Suggested=\"Yes\",AA258,AG258)","v":31.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA258*(1-W258)+0.004999,2)","v":31.1},null,"",31.1,{"$f":"+W258","v":0},{"$f":"+X258","v":31.1},{"$f":"(AG258-AC258)/AG258","v":0},null,8,{"$f":"SUM(AJ258:AL258)+AE258","v":31.1},null,null,{"$f":"ROUND(AC258/(1-VLOOKUP(AF258,Group,2,FALSE)),2)","v":31.1},{"$f":"IF(VLOOKUP(AF258,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ258,1)-AJ258,2),Round,2,FALSE)+VLOOKUP(AF258,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF258,Group,7,FALSE)=\"\",0,ROUND(AJ258-0.04999,1)-AJ258+AM258)","v":0},{"$f":"IF(VLOOKUP(AF258,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF258,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos - MLW Stone",null,null,"13.75\" x 13.75\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(1.36 SF/Sheet)",null,null,"6.80 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA260,AG260)","v":61.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA260*(1-W260)+0.004999,2)","v":61.55},null,"",61.55,{"$f":"+W260","v":0},61.55,{"$f":"(AG260-AC260)/AG260","v":0},null,10,{"$f":"SUM(AJ260:AL260)+AE260","v":61.55},null,null,{"$f":"ROUND(AC260/(1-VLOOKUP(AF260,Group,2,FALSE)),2)","v":61.55},{"$f":"IF(VLOOKUP(AF260,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ260,1)-AJ260,2),Round,2,FALSE)+VLOOKUP(AF260,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF260,Group,7,FALSE)=\"\",0,ROUND(AJ260-0.04999,1)-AJ260+AM260)","v":0},{"$f":"IF(VLOOKUP(AF260,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF260,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\",AA261,AG261)","v":67.099999999999994},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA261*(1-W261)+0.004999,2)","v":67.099999999999994},null,"",67.099999999999994,0,67.099999999999994,{"$f":"(AG261-AC261)/AG261","v":0},null,10,{"$f":"SUM(AJ261:AL261)+AE261","v":67.099999999999994},null,null,{"$f":"ROUND(AC261/(1-VLOOKUP(AF261,Group,2,FALSE)),2)","v":67.099999999999994},{"$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,"Trim - MLW Stone",null,null,"12\"",null,"Chair Rail",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA263,AG263)","v":44.15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA263*(1-W263)+0.004999,2)","v":44.15},null,"",44.15,{"$f":"+W263","v":0},44.15,{"$f":"(AG263-AC263)/AG263","v":0},null,9,{"$f":"SUM(AJ263:AL263)+AE263","v":44.15},null,null,{"$f":"ROUND(AC263/(1-VLOOKUP(AF263,Group,2,FALSE)),2)","v":44.15},{"$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,"Trim - MLW Stone",null,null,"5/8\" x 12\"",null,"Pencil",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA264,AG264)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA264*(1-W264)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG264-AC264)/AG264","v":0},null,9,{"$f":"SUM(AJ264:AL264)+AE264","v":24.35},null,null,{"$f":"ROUND(AC264/(1-VLOOKUP(AF264,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF264,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ264,1)-AJ264,2),Round,2,FALSE)+VLOOKUP(AF264,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF264,Group,7,FALSE)=\"\",0,ROUND(AJ264-0.04999,1)-AJ264+AM264)","v":0},{"$f":"IF(VLOOKUP(AF264,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF264,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim - MLW Stone",null,null,"5\" x 12\"",null,"Base",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA265,AG265)","v":60},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA265*(1-W265)+0.004999,2)","v":60},null,"",60,0,60,{"$f":"(AG265-AC265)/AG265","v":0},null,9,{"$f":"SUM(AJ265:AL265)+AE265","v":60},null,null,{"$f":"ROUND(AC265/(1-VLOOKUP(AF265,Group,2,FALSE)),2)","v":60},{"$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,null,"Color:","White Venatino (Polished)"]
[]
[null,"Field Tile - MLW Stone",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA269,AG269)","v":23.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA269*(1-W269)+0.004999,2)","v":23.95},null,"",23.95,{"$f":"+W269","v":0},23.95,{"$f":"(AG269-AC269)/AG269","v":0},null,8,{"$f":"SUM(AJ269:AL269)+AE269","v":23.95},null,null,{"$f":"ROUND(AC269/(1-VLOOKUP(AF269,Group,2,FALSE)),2)","v":23.95},{"$f":"IF(VLOOKUP(AF269,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ269,1)-AJ269,2),Round,2,FALSE)+VLOOKUP(AF269,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF269,Group,7,FALSE)=\"\",0,ROUND(AJ269-0.04999,1)-AJ269+AM269)","v":0},{"$f":"IF(VLOOKUP(AF269,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF269,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA270,AG270)","v":36.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA270*(1-W270)+0.004999,2)","v":36.25},null,"",36.25,0,36.25,{"$f":"(AG270-AC270)/AG270","v":0},null,8,{"$f":"SUM(AJ270:AL270)+AE270","v":36.25},null,null,{"$f":"ROUND(AC270/(1-VLOOKUP(AF270,Group,2,FALSE)),2)","v":36.25},{"$f":"IF(VLOOKUP(AF270,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ270,1)-AJ270,2),Round,2,FALSE)+VLOOKUP(AF270,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF270,Group,7,FALSE)=\"\",0,ROUND(AJ270-0.04999,1)-AJ270+AM270)","v":0},{"$f":"IF(VLOOKUP(AF270,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF270,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW Stone",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"12.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA271,AG271)","v":24.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA271*(1-W271)+0.004999,2)","v":24.8},null,"",24.8,0,24.8,{"$f":"(AG271-AC271)/AG271","v":0},null,8,{"$f":"SUM(AJ271:AL271)+AE271","v":24.8},null,null,{"$f":"ROUND(AC271/(1-VLOOKUP(AF271,Group,2,FALSE)),2)","v":24.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,"Decos - MLW Stone",null,null,"13.75\" x 13.75\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(1.36 SF/Sheet)",null,null,"6.80 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA273,AG273)","v":61.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA273*(1-W273)+0.004999,2)","v":61.55},null,"",61.55,{"$f":"+W273","v":0},61.55,{"$f":"(AG273-AC273)/AG273","v":0},null,10,{"$f":"SUM(AJ273:AL273)+AE273","v":61.55},null,null,{"$f":"ROUND(AC273/(1-VLOOKUP(AF273,Group,2,FALSE)),2)","v":61.55},{"$f":"IF(VLOOKUP(AF273,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ273,1)-AJ273,2),Round,2,FALSE)+VLOOKUP(AF273,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF273,Group,7,FALSE)=\"\",0,ROUND(AJ273-0.04999,1)-AJ273+AM273)","v":0},{"$f":"IF(VLOOKUP(AF273,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF273,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\",AA274,AG274)","v":67.099999999999994},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA274*(1-W274)+0.004999,2)","v":67.099999999999994},null,"",67.099999999999994,0,67.099999999999994,{"$f":"(AG274-AC274)/AG274","v":0},null,10,{"$f":"SUM(AJ274:AL274)+AE274","v":67.099999999999994},null,null,{"$f":"ROUND(AC274/(1-VLOOKUP(AF274,Group,2,FALSE)),2)","v":67.099999999999994},{"$f":"IF(VLOOKUP(AF274,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ274,1)-AJ274,2),Round,2,FALSE)+VLOOKUP(AF274,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF274,Group,7,FALSE)=\"\",0,ROUND(AJ274-0.04999,1)-AJ274+AM274)","v":0},{"$f":"IF(VLOOKUP(AF274,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF274,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Special Order - approximately 3-4 weeks.",null,null,null,null,null,"b) Minimum purchase is 13.60 SF, (2 cartons)."]
[]
[null,null,"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\",AA282,AG282)","v":30},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA282*(1-W282)+0.004999,2)","v":30},null,"",30,{"$f":"+W282","v":0},30,{"$f":"(AG282-AC282)/AG282","v":0},null,11,{"$f":"SUM(AJ282:AL282)+AE282","v":30},null,null,{"$f":"ROUND(AC282/(1-VLOOKUP(AF282,Group,2,FALSE)),2)","v":30},{"$f":"IF(VLOOKUP(AF282,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ282,1)-AJ282,2),Round,2,FALSE)+VLOOKUP(AF282,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF282,Group,7,FALSE)=\"\",0,ROUND(AJ282-0.04999,1)-AJ282+AM282)","v":0},{"$f":"IF(VLOOKUP(AF282,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF282,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"6\" x 6\" x 5/16\"",null,"Field - Cross",null,null,null,null,null,null,null,null,"6.31 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA283,AG283)","v":29.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA283*(1-W283)+0.004999,2)","v":29.8},null,"",29.8,0,29.8,{"$f":"(AG283-AC283)/AG283","v":0},null,11,{"$f":"SUM(AJ283:AL283)+AE283","v":29.8},null,null,{"$f":"ROUND(AC283/(1-VLOOKUP(AF283,Group,2,FALSE)),2)","v":29.8},{"$f":"IF(VLOOKUP(AF283,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ283,1)-AJ283,2),Round,2,FALSE)+VLOOKUP(AF283,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF283,Group,7,FALSE)=\"\",0,ROUND(AJ283-0.04999,1)-AJ283+AM283)","v":0},{"$f":"IF(VLOOKUP(AF283,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF283,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"6\" x 6\" x 5/16\"",null,"Field - Star",null,null,null,null,null,null,null,null,"4.21 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA284,AG284)","v":30.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA284*(1-W284)+0.004999,2)","v":30.2},null,"",30.2,0,30.2,{"$f":"(AG284-AC284)/AG284","v":0},null,11,{"$f":"SUM(AJ284:AL284)+AE284","v":30.2},null,null,{"$f":"ROUND(AC284/(1-VLOOKUP(AF284,Group,2,FALSE)),2)","v":30.2},{"$f":"IF(VLOOKUP(AF284,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ284,1)-AJ284,2),Round,2,FALSE)+VLOOKUP(AF284,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF284,Group,7,FALSE)=\"\",0,ROUND(AJ284-0.04999,1)-AJ284+AM284)","v":0},{"$f":"IF(VLOOKUP(AF284,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF284,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"MAYFAIR - Ceramic",null,null,null,null,null,null,null,"Discontinued 12/2/24",null,null,null,null,null,null,"Item # Lookup:","CNMF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Cream          Gray          White"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 5\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"5.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA290,AG290)","v":18.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA290*(1-W290)+0.004999,2)","v":18.2},null,"",18.2,{"$f":"+W290","v":0},18.2,{"$f":"(AG290-AC290)/AG290","v":0},null,11,{"$f":"SUM(AJ290:AL290)+AE290","v":18.2},null,null,{"$f":"ROUND(AC290/(1-VLOOKUP(AF290,Group,2,FALSE)),2)","v":18.2},{"$f":"IF(VLOOKUP(AF290,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ290,1)-AJ290,2),Round,2,FALSE)+VLOOKUP(AF290,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF290,Group,7,FALSE)=\"\",0,ROUND(AJ290-0.04999,1)-AJ290+AM290)","v":0},{"$f":"IF(VLOOKUP(AF290,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF290,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"5\" x 5\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA291,AG291)","v":18.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA291*(1-W291)+0.004999,2)","v":18.3},null,"",18.3,0,18.3,{"$f":"(AG291-AC291)/AG291","v":0},null,11,{"$f":"SUM(AJ291:AL291)+AE291","v":18.3},null,null,{"$f":"ROUND(AC291/(1-VLOOKUP(AF291,Group,2,FALSE)),2)","v":18.3},{"$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,"Field Tile - MLW",null,null,"2.5\" x 6\" x 5/16\"",null,"Field - Picket",null,null,null,null,null,null,null,null,"5.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA292,AG292)","v":19.149999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA292*(1-W292)+0.004999,2)","v":19.149999999999999},null,"",19.149999999999999,0,19.149999999999999,{"$f":"(AG292-AC292)/AG292","v":0},null,11,{"$f":"SUM(AJ292:AL292)+AE292","v":19.149999999999999},null,null,{"$f":"ROUND(AC292/(1-VLOOKUP(AF292,Group,2,FALSE)),2)","v":19.149999999999999},{"$f":"IF(VLOOKUP(AF292,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ292,1)-AJ292,2),Round,2,FALSE)+VLOOKUP(AF292,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF292,Group,7,FALSE)=\"\",0,ROUND(AJ292-0.04999,1)-AJ292+AM292)","v":0},{"$f":"IF(VLOOKUP(AF292,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF292,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"METRO - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Blue          Gray          White"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 12\" x 1/4\"",null,"Field",null,null,null,null," ",null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA298,AG298)","v":11.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA298*(1-W298)+0.004999,2)","v":11.9},null,"",11.9,{"$f":"+W298","v":0},{"$f":"+X298","v":11.9},{"$f":"(AG298-AC298)/AG298","v":0},null,11,{"$f":"SUM(AJ298:AL298)+AE298","v":11.9},null,null,{"$f":"ROUND(AC298/(1-VLOOKUP(AF298,Group,2,FALSE)),2)","v":11.9},{"$f":"IF(VLOOKUP(AF298,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ298,1)-AJ298,2),Round,2,FALSE)+VLOOKUP(AF298,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF298,Group,7,FALSE)=\"\",0,ROUND(AJ298-0.04999,1)-AJ298+AM298)","v":0},{"$f":"IF(VLOOKUP(AF298,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF298,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 12\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,"Bastille"," ",null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA300,AG300)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA300*(1-W300)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W300","v":0},12.8,{"$f":"(AG300-AC300)/AG300","v":0},null,11,{"$f":"SUM(AJ300:AL300)+AE300","v":12.8},null,null,{"$f":"ROUND(AC300/(1-VLOOKUP(AF300,Group,2,FALSE)),2)","v":12.8},{"$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,"Field Tile - MLW",null,null,"4\" x 12\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,"Concorde",null,null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA301,AG301)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA301*(1-W301)+0.004999,2)","v":12.8},null,"",12.8,0,12.8,{"$f":"(AG301-AC301)/AG301","v":0},null,11,{"$f":"SUM(AJ301:AL301)+AE301","v":12.8},null,null,{"$f":"ROUND(AC301/(1-VLOOKUP(AF301,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF301,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ301,1)-AJ301,2),Round,2,FALSE)+VLOOKUP(AF301,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF301,Group,7,FALSE)=\"\",0,ROUND(AJ301-0.04999,1)-AJ301+AM301)","v":0},{"$f":"IF(VLOOKUP(AF301,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF301,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"4\" x 12\" x 1/4\"",null,"Field (Decorative Pattern)",null,null,null,"Louvre"," ",null,null,null,"10.98 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA302,AG302)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA302*(1-W302)+0.004999,2)","v":12.8},null,"",12.8,0,12.8,{"$f":"(AG302-AC302)/AG302","v":0},null,11,{"$f":"SUM(AJ302:AL302)+AE302","v":12.8},null,null,{"$f":"ROUND(AC302/(1-VLOOKUP(AF302,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF302,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ302,1)-AJ302,2),Round,2,FALSE)+VLOOKUP(AF302,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF302,Group,7,FALSE)=\"\",0,ROUND(AJ302-0.04999,1)-AJ302+AM302)","v":0},{"$f":"IF(VLOOKUP(AF302,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF302,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\",AA304,AG304)","v":9.1999999999999993},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA304*(1-W304)+0.004999,2)","v":9.1999999999999993},null,"",9.1999999999999993,{"$f":"+W304","v":0},{"$f":"+X304","v":9.1999999999999993},{"$f":"(AG304-AC304)/AG304","v":0},null,12,{"$f":"SUM(AJ304:AL304)+AE304","v":9.1999999999999993},null,null,{"$f":"ROUND(AC304/(1-VLOOKUP(AF304,Group,2,FALSE)),2)","v":9.1999999999999993},{"$f":"IF(VLOOKUP(AF304,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ304,1)-AJ304,2),Round,2,FALSE)+VLOOKUP(AF304,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF304,Group,7,FALSE)=\"\",0,ROUND(AJ304-0.04999,1)-AJ304+AM304)","v":0},{"$f":"IF(VLOOKUP(AF304,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF304,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA310,AG310)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA310*(1-W310)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W310","v":0},{"$f":"+X310","v":18.7},{"$f":"(AG310-AC310)/AG310","v":0},null,11,{"$f":"SUM(AJ310:AL310)+AE310","v":18.7},null,null,{"$f":"ROUND(AC310/(1-VLOOKUP(AF310,Group,2,FALSE)),2)","v":18.7},{"$f":"IF(VLOOKUP(AF310,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ310,1)-AJ310,2),Round,2,FALSE)+VLOOKUP(AF310,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF310,Group,7,FALSE)=\"\",0,ROUND(AJ310-0.04999,1)-AJ310+AM310)","v":0},{"$f":"IF(VLOOKUP(AF310,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF310,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\",AA316,AG316)","v":16.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA316*(1-W316)+0.004999,2)","v":16.45},null,"",16.45,{"$f":"+W316","v":0},16.45,{"$f":"(AG316-AC316)/AG316","v":0},null,11,{"$f":"SUM(AJ316:AL316)+AE316","v":16.45},null,null,{"$f":"ROUND(AC316/(1-VLOOKUP(AF316,Group,2,FALSE)),2)","v":16.45},{"$f":"IF(VLOOKUP(AF316,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ316,1)-AJ316,2),Round,2,FALSE)+VLOOKUP(AF316,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF316,Group,7,FALSE)=\"\",0,ROUND(AJ316-0.04999,1)-AJ316+AM316)","v":0},{"$f":"IF(VLOOKUP(AF316,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF316,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA322,AG322)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA322*(1-W322)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W322","v":0},12.8,{"$f":"(AG322-AC322)/AG322","v":0},null,11,{"$f":"SUM(AJ322:AL322)+AE322","v":12.8},null,null,{"$f":"ROUND(AC322/(1-VLOOKUP(AF322,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF322,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ322,1)-AJ322,2),Round,2,FALSE)+VLOOKUP(AF322,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF322,Group,7,FALSE)=\"\",0,ROUND(AJ322-0.04999,1)-AJ322+AM322)","v":0},{"$f":"IF(VLOOKUP(AF322,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF322,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\",AA328,AG328)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA328*(1-W328)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W328","v":0},{"$f":"+X328","v":12.8},{"$f":"(AG328-AC328)/AG328","v":0},null,11,{"$f":"SUM(AJ328:AL328)+AE328","v":12.8},null,null,{"$f":"ROUND(AC328/(1-VLOOKUP(AF328,Group,2,FALSE)),2)","v":12.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,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\",AA334,AG334)","v":18.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA334*(1-W334)+0.004999,2)","v":18.8},null,"",18.8,{"$f":"+W334","v":0},{"$f":"+X334","v":18.8},{"$f":"(AG334-AC334)/AG334","v":0},null,11,{"$f":"SUM(AJ334:AL334)+AE334","v":18.8},null,null,{"$f":"ROUND(AC334/(1-VLOOKUP(AF334,Group,2,FALSE)),2)","v":18.8},{"$f":"IF(VLOOKUP(AF334,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ334,1)-AJ334,2),Round,2,FALSE)+VLOOKUP(AF334,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF334,Group,7,FALSE)=\"\",0,ROUND(AJ334-0.04999,1)-AJ334+AM334)","v":0},{"$f":"IF(VLOOKUP(AF334,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF334,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\",AA340,AG340)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA340*(1-W340)+0.004999,2)","v":13.55},null,"",13.55,{"$f":"+W340","v":0},13.55,{"$f":"(AG340-AC340)/AG340","v":0},null,11,{"$f":"SUM(AJ340:AL340)+AE340","v":13.55},null,null,{"$f":"ROUND(AC340/(1-VLOOKUP(AF340,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF340,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ340,1)-AJ340,2),Round,2,FALSE)+VLOOKUP(AF340,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF340,Group,7,FALSE)=\"\",0,ROUND(AJ340-0.04999,1)-AJ340+AM340)","v":0},{"$f":"IF(VLOOKUP(AF340,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF340,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\",AA341,AG341)","v":14.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA341*(1-W341)+0.004999,2)","v":14.75},null,"",14.75,0,14.75,{"$f":"(AG341-AC341)/AG341","v":0},null,11,{"$f":"SUM(AJ341:AL341)+AE341","v":14.75},null,null,{"$f":"ROUND(AC341/(1-VLOOKUP(AF341,Group,2,FALSE)),2)","v":14.75},{"$f":"IF(VLOOKUP(AF341,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ341,1)-AJ341,2),Round,2,FALSE)+VLOOKUP(AF341,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF341,Group,7,FALSE)=\"\",0,ROUND(AJ341-0.04999,1)-AJ341+AM341)","v":0},{"$f":"IF(VLOOKUP(AF341,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF341,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\",AA342,AG342)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA342*(1-W342)+0.004999,2)","v":15.3},null,"",15.3,0,15.3,{"$f":"(AG342-AC342)/AG342","v":0},null,11,{"$f":"SUM(AJ342:AL342)+AE342","v":15.3},null,null,{"$f":"ROUND(AC342/(1-VLOOKUP(AF342,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF342,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ342,1)-AJ342,2),Round,2,FALSE)+VLOOKUP(AF342,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF342,Group,7,FALSE)=\"\",0,ROUND(AJ342-0.04999,1)-AJ342+AM342)","v":0},{"$f":"IF(VLOOKUP(AF342,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF342,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA348,AG348)","v":15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA348*(1-W348)+0.004999,2)","v":15},null,"",15,{"$f":"+W348","v":0},15,{"$f":"(AG348-AC348)/AG348","v":0},null,11,{"$f":"SUM(AJ348:AL348)+AE348","v":15},null,null,{"$f":"ROUND(AC348/(1-VLOOKUP(AF348,Group,2,FALSE)),2)","v":15},{"$f":"IF(VLOOKUP(AF348,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ348,1)-AJ348,2),Round,2,FALSE)+VLOOKUP(AF348,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF348,Group,7,FALSE)=\"\",0,ROUND(AJ348-0.04999,1)-AJ348+AM348)","v":0},{"$f":"IF(VLOOKUP(AF348,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF348,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\",AA349,AG349)","v":13.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA349*(1-W349)+0.004999,2)","v":13.15},null,"",13.15,0,13.15,{"$f":"(AG349-AC349)/AG349","v":0},null,11,{"$f":"SUM(AJ349:AL349)+AE349","v":13.15},null,null,{"$f":"ROUND(AC349/(1-VLOOKUP(AF349,Group,2,FALSE)),2)","v":13.15},{"$f":"IF(VLOOKUP(AF349,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ349,1)-AJ349,2),Round,2,FALSE)+VLOOKUP(AF349,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF349,Group,7,FALSE)=\"\",0,ROUND(AJ349-0.04999,1)-AJ349+AM349)","v":0},{"$f":"IF(VLOOKUP(AF349,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF349,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\",AA350,AG350)","v":15.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA350*(1-W350)+0.004999,2)","v":15.4},null,"",15.4,0,15.4,{"$f":"(AG350-AC350)/AG350","v":0},null,11,{"$f":"SUM(AJ350:AL350)+AE350","v":15.4},null,null,{"$f":"ROUND(AC350/(1-VLOOKUP(AF350,Group,2,FALSE)),2)","v":15.4},{"$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",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\",AA352,AG352)","v":31.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA352*(1-W352)+0.004999,2)","v":31.15},null,"",31.15,{"$f":"+W352","v":0},{"$f":"+X352","v":31.15},{"$f":"(AG352-AC352)/AG352","v":0},null,13,{"$f":"SUM(AJ352:AL352)+AE352","v":31.15},null,null,{"$f":"ROUND(AC352/(1-VLOOKUP(AF352,Group,2,FALSE)),2)","v":31.15},{"$f":"IF(VLOOKUP(AF352,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ352,1)-AJ352,2),Round,2,FALSE)+VLOOKUP(AF352,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF352,Group,7,FALSE)=\"\",0,ROUND(AJ352-0.04999,1)-AJ352+AM352)","v":0},{"$f":"IF(VLOOKUP(AF352,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF352,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA358,AG358)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA358*(1-W358)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W358","v":0},{"$f":"+X358","v":12.8},{"$f":"(AG358-AC358)/AG358","v":0},null,11,{"$f":"SUM(AJ358:AL358)+AE358","v":12.8},null,null,{"$f":"ROUND(AC358/(1-VLOOKUP(AF358,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF358,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ358,1)-AJ358,2),Round,2,FALSE)+VLOOKUP(AF358,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF358,Group,7,FALSE)=\"\",0,ROUND(AJ358-0.04999,1)-AJ358+AM358)","v":0},{"$f":"IF(VLOOKUP(AF358,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF358,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,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\",AA362,AG362)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA362*(1-W362)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W362","v":0},12.8,{"$f":"(AG362-AC362)/AG362","v":0},null,11,{"$f":"SUM(AJ362:AL362)+AE362","v":12.8},null,null,{"$f":"ROUND(AC362/(1-VLOOKUP(AF362,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF362,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ362,1)-AJ362,2),Round,2,FALSE)+VLOOKUP(AF362,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF362,Group,7,FALSE)=\"\",0,ROUND(AJ362-0.04999,1)-AJ362+AM362)","v":0},{"$f":"IF(VLOOKUP(AF362,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF362,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PASTICHE - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Glinting Gray          Lustrous Blue          Opalescent White          Radiant Pink"]
[]
[null,"Field Tile - MLW",null,null,"2.5\" x 10\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"5.38 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA368,AG368)","v":16.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA368*(1-W368)+0.004999,2)","v":16.5},null,"",16.5,{"$f":"+W368","v":0},{"$f":"+X368","v":16.5},{"$f":"(AG368-AC368)/AG368","v":0},null,11,{"$f":"SUM(AJ368:AL368)+AE368","v":16.5},null,null,{"$f":"ROUND(AC368/(1-VLOOKUP(AF368,Group,2,FALSE)),2)","v":16.5},{"$f":"IF(VLOOKUP(AF368,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ368,1)-AJ368,2),Round,2,FALSE)+VLOOKUP(AF368,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF368,Group,7,FALSE)=\"\",0,ROUND(AJ368-0.04999,1)-AJ368+AM368)","v":0},{"$f":"IF(VLOOKUP(AF368,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF368,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim - MLW",null,null,"2.5\" x 10\" x 5/16\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA370,AG370)","v":10.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA370*(1-W370)+0.004999,2)","v":10.85},null,"",10.85,{"$f":"+W370","v":0},{"$f":"+X370","v":10.85},{"$f":"(AG370-AC370)/AG370","v":0},null,12,{"$f":"SUM(AJ370:AL370)+AE370","v":10.85},null,null,{"$f":"ROUND(AC370/(1-VLOOKUP(AF370,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF370,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ370,1)-AJ370,2),Round,2,FALSE)+VLOOKUP(AF370,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF370,Group,7,FALSE)=\"\",0,ROUND(AJ370-0.04999,1)-AJ370+AM370)","v":0},{"$f":"IF(VLOOKUP(AF370,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF370,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Each carton contains a random assortment of 5 patterns and a solid tile, approximately 2/3rd solid tiles and 1/3rd decorative tiles."]
[]
[null,null,"PIAZZA - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNPA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Brown             Gray             White"]
[]
[null,"Field Tile - MLW",null,null,"6\" x 6\" x 5/16\"",null,"Field",null,null,null,null,null,null,null,null,"11.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA378,AG378)","v":14.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA378*(1-W378)+0.004999,2)","v":14.65},null,"",14.65,{"$f":"+W378","v":0},{"$f":"+X378","v":14.65},{"$f":"(AG378-AC378)/AG378","v":0},null,11,{"$f":"SUM(AJ378:AL378)+AE378","v":14.65},null,null,{"$f":"ROUND(AC378/(1-VLOOKUP(AF378,Group,2,FALSE)),2)","v":14.65},{"$f":"IF(VLOOKUP(AF378,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ378,1)-AJ378,2),Round,2,FALSE)+VLOOKUP(AF378,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF378,Group,7,FALSE)=\"\",0,ROUND(AJ378-0.04999,1)-AJ378+AM378)","v":0},{"$f":"IF(VLOOKUP(AF378,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF378,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PICCADILLY - Recycled Glass",null,null,null,null,null,null,null,"Discontinued 11/6/24",null,null,null," ",null,null,"Item # Lookup:","CNPI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Black",null,"Grey",null,"         Pink",null,"  Turquoise"]
[null,null,null,null,"Blue",null,"Khaki",null,"         Sand",null,"  White"]
[null,null,null,null,"Burgundy",null,"Mustard",null,"         Taupe"]
[]
[null,"Decos - MLW",null,null,"12.6\" x 11.42\" x 1/8\"",null,"Mosaic",null,null,"2\" Hexagon",null,null,"(0.98 SF/Sheet)",null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA386,AG386)","v":29.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA386*(1-W386)+0.004999,2)","v":29.65},null,"",29.65,{"$f":"+W386","v":0},{"$f":"+X386","v":29.65},{"$f":"(AG386-AC386)/AG386","v":0},null,13,{"$f":"SUM(AJ386:AL386)+AE386","v":29.65},null,null,{"$f":"ROUND(AC386/(1-VLOOKUP(AF386,Group,2,FALSE)),2)","v":29.65},{"$f":"IF(VLOOKUP(AF386,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ386,1)-AJ386,2),Round,2,FALSE)+VLOOKUP(AF386,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF386,Group,7,FALSE)=\"\",0,ROUND(AJ386-0.04999,1)-AJ386+AM386)","v":0},{"$f":"IF(VLOOKUP(AF386,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF386,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA394,AG394)","v":22.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA394*(1-W394)+0.004999,2)","v":22.55},null,"",22.55,{"$f":"+W394","v":0},{"$f":"+X394","v":22.55},{"$f":"(AG394-AC394)/AG394","v":0},null,11,{"$f":"SUM(AJ394:AL394)+AE394","v":22.55},null,null,{"$f":"ROUND(AC394/(1-VLOOKUP(AF394,Group,2,FALSE)),2)","v":22.55},{"$f":"IF(VLOOKUP(AF394,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ394,1)-AJ394,2),Round,2,FALSE)+VLOOKUP(AF394,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF394,Group,7,FALSE)=\"\",0,ROUND(AJ394-0.04999,1)-AJ394+AM394)","v":0},{"$f":"IF(VLOOKUP(AF394,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF394,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA396,AG396)","v":9.9499999999999993},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA396*(1-W396)+0.004999,2)","v":9.9499999999999993},null,"",9.9499999999999993,{"$f":"+W396","v":0},{"$f":"+X396","v":9.9499999999999993},{"$f":"(AG396-AC396)/AG396","v":0},null,12,{"$f":"SUM(AJ396:AL396)+AE396","v":9.9499999999999993},null,null,{"$f":"ROUND(AC396/(1-VLOOKUP(AF396,Group,2,FALSE)),2)","v":9.9499999999999993},{"$f":"IF(VLOOKUP(AF396,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ396,1)-AJ396,2),Round,2,FALSE)+VLOOKUP(AF396,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF396,Group,7,FALSE)=\"\",0,ROUND(AJ396-0.04999,1)-AJ396+AM396)","v":0},{"$f":"IF(VLOOKUP(AF396,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF396,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA403,AG403)","v":15.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA403*(1-W403)+0.004999,2)","v":15.65},null,"",15.65,{"$f":"+W403","v":0},{"$f":"+X403","v":15.65},{"$f":"(AG403-AC403)/AG403","v":0},null,11,{"$f":"SUM(AJ403:AL403)+AE403","v":15.65},null,null,{"$f":"ROUND(AC403/(1-VLOOKUP(AF403,Group,2,FALSE)),2)","v":15.65},{"$f":"IF(VLOOKUP(AF403,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ403,1)-AJ403,2),Round,2,FALSE)+VLOOKUP(AF403,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF403,Group,7,FALSE)=\"\",0,ROUND(AJ403-0.04999,1)-AJ403+AM403)","v":0},{"$f":"IF(VLOOKUP(AF403,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF403,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PYRAMID - Ceramic",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNPY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Blue             Dark Grey             Ivory             Khaki             Light Grey             White"]
[]
[null,"Field Tile - MLW",null,null,"4\" x 5\" x 1/4\"",null,"Field - Triangle",null,null,null,null,null,null,null,null,"2.64 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA409,AG409)","v":24.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA409*(1-W409)+0.004999,2)","v":24.2},null,"",24.2,{"$f":"+W409","v":0},{"$f":"+X409","v":24.2},{"$f":"(AG409-AC409)/AG409","v":0},null,11,{"$f":"SUM(AJ409:AL409)+AE409","v":24.2},null,null,{"$f":"ROUND(AC409/(1-VLOOKUP(AF409,Group,2,FALSE)),2)","v":24.2},{"$f":"IF(VLOOKUP(AF409,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ409,1)-AJ409,2),Round,2,FALSE)+VLOOKUP(AF409,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF409,Group,7,FALSE)=\"\",0,ROUND(AJ409-0.04999,1)-AJ409+AM409)","v":0},{"$f":"IF(VLOOKUP(AF409,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF409,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA411,AG411)","v":12.95},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA411*(1-W411)+0.004999,2)","v":12.95},null,"",12.95,{"$f":"+W411","v":0},{"$f":"+X411","v":12.95},{"$f":"(AG411-AC411)/AG411","v":0},null,12,{"$f":"SUM(AJ411:AL411)+AE411","v":12.95},null,null,{"$f":"ROUND(AC411/(1-VLOOKUP(AF411,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF411,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ411,1)-AJ411,2),Round,2,FALSE)+VLOOKUP(AF411,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF411,Group,7,FALSE)=\"\",0,ROUND(AJ411-0.04999,1)-AJ411+AM411)","v":0},{"$f":"IF(VLOOKUP(AF411,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF411,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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\",AA417,AG417)","v":14.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA417*(1-W417)+0.004999,2)","v":14.5},null,"",14.5,{"$f":"+W417","v":0},{"$f":"+X417","v":14.5},{"$f":"(AG417-AC417)/AG417","v":0},null,11,{"$f":"SUM(AJ417:AL417)+AE417","v":14.5},null,null,{"$f":"ROUND(AC417/(1-VLOOKUP(AF417,Group,2,FALSE)),2)","v":14.5},{"$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,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\",AA424,AG424)","v":13.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA424*(1-W424)+0.004999,2)","v":13.85},null,"",13.85,{"$f":"+W424","v":0},{"$f":"+X424","v":13.85},{"$f":"(AG424-AC424)/AG424","v":0},null,11,{"$f":"SUM(AJ424:AL424)+AE424","v":13.85},null,null,{"$f":"ROUND(AC424/(1-VLOOKUP(AF424,Group,2,FALSE)),2)","v":13.85},{"$f":"IF(VLOOKUP(AF424,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ424,1)-AJ424,2),Round,2,FALSE)+VLOOKUP(AF424,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF424,Group,7,FALSE)=\"\",0,ROUND(AJ424-0.04999,1)-AJ424+AM424)","v":0},{"$f":"IF(VLOOKUP(AF424,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF424,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\",AA430,AG430)","v":19.100000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA430*(1-W430)+0.004999,2)","v":19.100000000000001},null,"",19.100000000000001,{"$f":"+W430","v":0},{"$f":"+X430","v":19.100000000000001},{"$f":"(AG430-AC430)/AG430","v":0},null,11,{"$f":"SUM(AJ430:AL430)+AE430","v":19.100000000000001},null,null,{"$f":"ROUND(AC430/(1-VLOOKUP(AF430,Group,2,FALSE)),2)","v":19.100000000000001},{"$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,"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\",AA437,AG437)","v":16},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA437*(1-W437)+0.004999,2)","v":16},null,"",16,{"$f":"+W437","v":0},16,{"$f":"(AG437-AC437)/AG437","v":0},null,11,{"$f":"SUM(AJ437:AL437)+AE437","v":16},null,null,{"$f":"ROUND(AC437/(1-VLOOKUP(AF437,Group,2,FALSE)),2)","v":16},{"$f":"IF(VLOOKUP(AF437,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ437,1)-AJ437,2),Round,2,FALSE)+VLOOKUP(AF437,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF437,Group,7,FALSE)=\"\",0,ROUND(AJ437-0.04999,1)-AJ437+AM437)","v":0},{"$f":"IF(VLOOKUP(AF437,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF437,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA438,AG438)","v":16.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA438*(1-W438)+0.004999,2)","v":16.25},null,"",16.25,0,16.25,{"$f":"(AG438-AC438)/AG438","v":0},null,11,{"$f":"SUM(AJ438:AL438)+AE438","v":16.25},null,null,{"$f":"ROUND(AC438/(1-VLOOKUP(AF438,Group,2,FALSE)),2)","v":16.25},{"$f":"IF(VLOOKUP(AF438,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ438,1)-AJ438,2),Round,2,FALSE)+VLOOKUP(AF438,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF438,Group,7,FALSE)=\"\",0,ROUND(AJ438-0.04999,1)-AJ438+AM438)","v":0},{"$f":"IF(VLOOKUP(AF438,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF438,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\",AA439,AG439)","v":16.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA439*(1-W439)+0.004999,2)","v":16.8},null,"",16.8,0,16.8,{"$f":"(AG439-AC439)/AG439","v":0},null,11,{"$f":"SUM(AJ439:AL439)+AE439","v":16.8},null,null,{"$f":"ROUND(AC439/(1-VLOOKUP(AF439,Group,2,FALSE)),2)","v":16.8},{"$f":"IF(VLOOKUP(AF439,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ439,1)-AJ439,2),Round,2,FALSE)+VLOOKUP(AF439,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF439,Group,7,FALSE)=\"\",0,ROUND(AJ439-0.04999,1)-AJ439+AM439)","v":0},{"$f":"IF(VLOOKUP(AF439,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF439,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\",AA441,AG441)","v":10.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA441*(1-W441)+0.004999,2)","v":10.7},null,"",10.7,{"$f":"+W441","v":0},{"$f":"+X441","v":10.7},{"$f":"(AG441-AC441)/AG441","v":0},null,12,{"$f":"SUM(AJ441:AL441)+AE441","v":10.7},null,null,{"$f":"ROUND(AC441/(1-VLOOKUP(AF441,Group,2,FALSE)),2)","v":10.7},{"$f":"IF(VLOOKUP(AF441,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ441,1)-AJ441,2),Round,2,FALSE)+VLOOKUP(AF441,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF441,Group,7,FALSE)=\"\",0,ROUND(AJ441-0.04999,1)-AJ441+AM441)","v":0},{"$f":"IF(VLOOKUP(AF441,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF441,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\",AA449,AG449)","v":14.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA449*(1-W449)+0.004999,2)","v":14.75},null,"",14.75,{"$f":"+W449","v":0},{"$f":"+X449","v":14.75},{"$f":"(AG449-AC449)/AG449","v":0},null,8,{"$f":"SUM(AJ449:AL449)+AE449","v":14.75},null,null,{"$f":"ROUND(AC449/(1-VLOOKUP(AF449,Group,2,FALSE)),2)","v":14.75},{"$f":"IF(VLOOKUP(AF449,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ449,1)-AJ449,2),Round,2,FALSE)+VLOOKUP(AF449,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF449,Group,7,FALSE)=\"\",0,ROUND(AJ449-0.04999,1)-AJ449+AM449)","v":0},{"$f":"IF(VLOOKUP(AF449,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF449,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,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,"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,"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\",AA462,AG462)","v":55.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA462*(1-W462)+0.004999,2)","v":55.05},null,"",55.05,{"$f":"+W462","v":0},{"$f":"+X462","v":55.05},{"$f":"(AG462-AC462)/AG462","v":0},null,10,{"$f":"SUM(AJ462:AL462)+AE462","v":55.05},null,null,{"$f":"ROUND(AC462/(1-VLOOKUP(AF462,Group,2,FALSE)),2)","v":55.05},{"$f":"IF(VLOOKUP(AF462,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ462,1)-AJ462,2),Round,2,FALSE)+VLOOKUP(AF462,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF462,Group,7,FALSE)=\"\",0,ROUND(AJ462-0.04999,1)-AJ462+AM462)","v":0},{"$f":"IF(VLOOKUP(AF462,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF462,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\",AA463,AG463)","v":32.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA463*(1-W463)+0.004999,2)","v":32.25},null,"",32.25,{"$f":"+W463","v":0},32.25,{"$f":"(AG463-AC463)/AG463","v":0},null,10,{"$f":"SUM(AJ463:AL463)+AE463","v":32.25},null,null,{"$f":"ROUND(AC463/(1-VLOOKUP(AF463,Group,2,FALSE)),2)","v":32.25},{"$f":"IF(VLOOKUP(AF463,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ463,1)-AJ463,2),Round,2,FALSE)+VLOOKUP(AF463,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF463,Group,7,FALSE)=\"\",0,ROUND(AJ463-0.04999,1)-AJ463+AM463)","v":0},{"$f":"IF(VLOOKUP(AF463,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF463,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos - MLW Stone",null,null,"12\" x 12\"",null,"Mosaic",null,null,"Large Herringbone",null,null,"(1.00 SF/Sheet)",null,null,"10.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA464,AG464)","v":51.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA464*(1-W464)+0.004999,2)","v":51.75},null,"",51.75,{"$f":"+W464","v":0},{"$f":"+X464","v":51.75},{"$f":"(AG464-AC464)/AG464","v":0},null,10,{"$f":"SUM(AJ464:AL464)+AE464","v":51.75},null,null,{"$f":"ROUND(AC464/(1-VLOOKUP(AF464,Group,2,FALSE)),2)","v":51.75},{"$f":"IF(VLOOKUP(AF464,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ464,1)-AJ464,2),Round,2,FALSE)+VLOOKUP(AF464,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF464,Group,7,FALSE)=\"\",0,ROUND(AJ464-0.04999,1)-AJ464+AM464)","v":0},{"$f":"IF(VLOOKUP(AF464,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF464,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA465,AG465)","v":55.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA465*(1-W465)+0.004999,2)","v":55.5},null,"",55.5,0,55.5,{"$f":"(AG465-AC465)/AG465","v":0},null,10,{"$f":"SUM(AJ465:AL465)+AE465","v":55.5},null,null,{"$f":"ROUND(AC465/(1-VLOOKUP(AF465,Group,2,FALSE)),2)","v":55.5},{"$f":"IF(VLOOKUP(AF465,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ465,1)-AJ465,2),Round,2,FALSE)+VLOOKUP(AF465,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF465,Group,7,FALSE)=\"\",0,ROUND(AJ465-0.04999,1)-AJ465+AM465)","v":0},{"$f":"IF(VLOOKUP(AF465,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF465,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\",AA469,AG469)","v":14.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA469*(1-W469)+0.004999,2)","v":14.75},null,"",14.75,{"$f":"+W469","v":0},{"$f":"+X469","v":14.75},{"$f":"(AG469-AC469)/AG469","v":0},null,8,{"$f":"SUM(AJ469:AL469)+AE469","v":14.75},null,null,{"$f":"ROUND(AC469/(1-VLOOKUP(AF469,Group,2,FALSE)),2)","v":14.75},{"$f":"IF(VLOOKUP(AF469,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ469,1)-AJ469,2),Round,2,FALSE)+VLOOKUP(AF469,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF469,Group,7,FALSE)=\"\",0,ROUND(AJ469-0.04999,1)-AJ469+AM469)","v":0},{"$f":"IF(VLOOKUP(AF469,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF469,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,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,"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,"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\",AA481,AG481)","v":55.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA481*(1-W481)+0.004999,2)","v":55.05},null,"",55.05,{"$f":"+W481","v":0},{"$f":"+X481","v":55.05},{"$f":"(AG481-AC481)/AG481","v":0},null,10,{"$f":"SUM(AJ481:AL481)+AE481","v":55.05},null,null,{"$f":"ROUND(AC481/(1-VLOOKUP(AF481,Group,2,FALSE)),2)","v":55.05},{"$f":"IF(VLOOKUP(AF481,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ481,1)-AJ481,2),Round,2,FALSE)+VLOOKUP(AF481,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF481,Group,7,FALSE)=\"\",0,ROUND(AJ481-0.04999,1)-AJ481+AM481)","v":0},{"$f":"IF(VLOOKUP(AF481,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF481,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos - MLW Stone",null,null,"13.75\" x 13.75\"",null,"Mosaic",null,null,"2\" x 2\"",null,null,"(1.36 SF/Sheet)",null,null,"6.80 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA482,AG482)","v":54.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA482*(1-W482)+0.004999,2)","v":54.9},null,"",54.9,{"$f":"+W482","v":0},54.9,{"$f":"(AG482-AC482)/AG482","v":0},null,10,{"$f":"SUM(AJ482:AL482)+AE482","v":54.9},null,null,{"$f":"ROUND(AC482/(1-VLOOKUP(AF482,Group,2,FALSE)),2)","v":54.9},{"$f":"IF(VLOOKUP(AF482,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ482,1)-AJ482,2),Round,2,FALSE)+VLOOKUP(AF482,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF482,Group,7,FALSE)=\"\",0,ROUND(AJ482-0.04999,1)-AJ482+AM482)","v":0},{"$f":"IF(VLOOKUP(AF482,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF482,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\",AA483,AG483)","v":55.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA483*(1-W483)+0.004999,2)","v":55.5},null,"",55.5,0,55.5,{"$f":"(AG483-AC483)/AG483","v":0},null,10,{"$f":"SUM(AJ483:AL483)+AE483","v":55.5},null,null,{"$f":"ROUND(AC483/(1-VLOOKUP(AF483,Group,2,FALSE)),2)","v":55.5},{"$f":"IF(VLOOKUP(AF483,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ483,1)-AJ483,2),Round,2,FALSE)+VLOOKUP(AF483,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF483,Group,7,FALSE)=\"\",0,ROUND(AJ483-0.04999,1)-AJ483+AM483)","v":0},{"$f":"IF(VLOOKUP(AF483,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF483,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Special Order - approximately 3-4 weeks.",null,null,null,null,null,"b) Minimum purchase is 13.60 SF, (2 cartons)."]
[]
[null,null,"STELLA - Porcelain",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Black             Tan             White"]
[]
[null,"Field Tile - MLW",null,null,"8\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"10.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA491,AG491)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA491*(1-W491)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W491","v":0},{"$f":"+X491","v":12.8},{"$f":"(AG491-AC491)/AG491","v":0},null,11,{"$f":"SUM(AJ491:AL491)+AE491","v":12.8},null,null,{"$f":"ROUND(AC491/(1-VLOOKUP(AF491,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF491,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ491,1)-AJ491,2),Round,2,FALSE)+VLOOKUP(AF491,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF491,Group,7,FALSE)=\"\",0,ROUND(AJ491-0.04999,1)-AJ491+AM491)","v":0},{"$f":"IF(VLOOKUP(AF491,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF491,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\",AA493,AG493)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA493*(1-W493)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W493","v":0},{"$f":"+X493","v":12.8},{"$f":"(AG493-AC493)/AG493","v":0},null,11,{"$f":"SUM(AJ493:AL493)+AE493","v":12.8},null,null,{"$f":"ROUND(AC493/(1-VLOOKUP(AF493,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF493,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ493,1)-AJ493,2),Round,2,FALSE)+VLOOKUP(AF493,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF493,Group,7,FALSE)=\"\",0,ROUND(AJ493-0.04999,1)-AJ493+AM493)","v":0},{"$f":"IF(VLOOKUP(AF493,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF493,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\",AA500,AG500)","v":14},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA500*(1-W500)+0.004999,2)","v":14},null,"",14,{"$f":"+W500","v":0},{"$f":"+X500","v":14},{"$f":"(AG500-AC500)/AG500","v":0},null,11,{"$f":"SUM(AJ500:AL500)+AE500","v":14},null,null,{"$f":"ROUND(AC500/(1-VLOOKUP(AF500,Group,2,FALSE)),2)","v":14},{"$f":"IF(VLOOKUP(AF500,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ500,1)-AJ500,2),Round,2,FALSE)+VLOOKUP(AF500,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF500,Group,7,FALSE)=\"\",0,ROUND(AJ500-0.04999,1)-AJ500+AM500)","v":0},{"$f":"IF(VLOOKUP(AF500,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF500,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA506,AG506)","v":14.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA506*(1-W506)+0.004999,2)","v":14.2},null,"",14.2,{"$f":"+W506","v":0},{"$f":"+X506","v":14.2},{"$f":"(AG506-AC506)/AG506","v":0},null,11,{"$f":"SUM(AJ506:AL506)+AE506","v":14.2},null,null,{"$f":"ROUND(AC506/(1-VLOOKUP(AF506,Group,2,FALSE)),2)","v":14.2},{"$f":"IF(VLOOKUP(AF506,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ506,1)-AJ506,2),Round,2,FALSE)+VLOOKUP(AF506,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF506,Group,7,FALSE)=\"\",0,ROUND(AJ506-0.04999,1)-AJ506+AM506)","v":0},{"$f":"IF(VLOOKUP(AF506,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF506,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA512,AG512)","v":18.350000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA512*(1-W512)+0.004999,2)","v":18.350000000000001},null,"",18.350000000000001,{"$f":"+W512","v":0},18.350000000000001,{"$f":"(AG512-AC512)/AG512","v":0},null,11,{"$f":"SUM(AJ512:AL512)+AE512","v":18.350000000000001},null,null,{"$f":"ROUND(AC512/(1-VLOOKUP(AF512,Group,2,FALSE)),2)","v":18.350000000000001},{"$f":"IF(VLOOKUP(AF512,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ512,1)-AJ512,2),Round,2,FALSE)+VLOOKUP(AF512,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF512,Group,7,FALSE)=\"\",0,ROUND(AJ512-0.04999,1)-AJ512+AM512)","v":0},{"$f":"IF(VLOOKUP(AF512,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF512,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\",AA513,AG513)","v":17.899999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA513*(1-W513)+0.004999,2)","v":17.899999999999999},null,"",17.899999999999999,0,17.899999999999999,{"$f":"(AG513-AC513)/AG513","v":0},null,11,{"$f":"SUM(AJ513:AL513)+AE513","v":17.899999999999999},null,null,{"$f":"ROUND(AC513/(1-VLOOKUP(AF513,Group,2,FALSE)),2)","v":17.899999999999999},{"$f":"IF(VLOOKUP(AF513,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ513,1)-AJ513,2),Round,2,FALSE)+VLOOKUP(AF513,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF513,Group,7,FALSE)=\"\",0,ROUND(AJ513-0.04999,1)-AJ513+AM513)","v":0},{"$f":"IF(VLOOKUP(AF513,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF513,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\",AA514,AG514)","v":17.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA514*(1-W514)+0.004999,2)","v":17.05},null,"",17.05,0,17.05,{"$f":"(AG514-AC514)/AG514","v":0},null,11,{"$f":"SUM(AJ514:AL514)+AE514","v":17.05},null,null,{"$f":"ROUND(AC514/(1-VLOOKUP(AF514,Group,2,FALSE)),2)","v":17.05},{"$f":"IF(VLOOKUP(AF514,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ514,1)-AJ514,2),Round,2,FALSE)+VLOOKUP(AF514,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF514,Group,7,FALSE)=\"\",0,ROUND(AJ514-0.04999,1)-AJ514+AM514)","v":0},{"$f":"IF(VLOOKUP(AF514,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF514,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\",AA516,AG516)","v":21.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA516*(1-W516)+0.004999,2)","v":21.35},null,"",21.35,{"$f":"+W516","v":0},{"$f":"+X516","v":21.35},{"$f":"(AG516-AC516)/AG516","v":0},null,11,{"$f":"SUM(AJ516:AL516)+AE516","v":21.35},null,null,{"$f":"ROUND(AC516/(1-VLOOKUP(AF516,Group,2,FALSE)),2)","v":21.35},{"$f":"IF(VLOOKUP(AF516,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ516,1)-AJ516,2),Round,2,FALSE)+VLOOKUP(AF516,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF516,Group,7,FALSE)=\"\",0,ROUND(AJ516-0.04999,1)-AJ516+AM516)","v":0},{"$f":"IF(VLOOKUP(AF516,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF516,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\",AA518,AG518)","v":19.399999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA518*(1-W518)+0.004999,2)","v":19.399999999999999},null,"",19.399999999999999,{"$f":"+W518","v":0},{"$f":"+X518","v":19.399999999999999},{"$f":"(AG518-AC518)/AG518","v":0},null,12,{"$f":"SUM(AJ518:AL518)+AE518","v":19.399999999999999},null,null,{"$f":"ROUND(AC518/(1-VLOOKUP(AF518,Group,2,FALSE)),2)","v":19.399999999999999},{"$f":"IF(VLOOKUP(AF518,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ518,1)-AJ518,2),Round,2,FALSE)+VLOOKUP(AF518,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF518,Group,7,FALSE)=\"\",0,ROUND(AJ518-0.04999,1)-AJ518+AM518)","v":0},{"$f":"IF(VLOOKUP(AF518,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF518,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"VALENCIA - Porcelain Floor & Ceramic Wall",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","CNVA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,"Colors:","Chalk          Dove          Natural          White Gloss"]
[]
[null,"Field Tile - MLW",null,"Floor:","6\" x 6\"",null,"Field - Cross",null,null,null,null,null,null,null,null,"6.14 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA524,AG524)","v":29.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA524*(1-W524)+0.004999,2)","v":29.85},null,"",29.85,{"$f":"+W524","v":0},{"$f":"+X524","v":29.85},{"$f":"(AG524-AC524)/AG524","v":0},null,11,{"$f":"SUM(AJ524:AL524)+AE524","v":29.85},null,null,{"$f":"ROUND(AC524/(1-VLOOKUP(AF524,Group,2,FALSE)),2)","v":29.85},{"$f":"IF(VLOOKUP(AF524,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ524,1)-AJ524,2),Round,2,FALSE)+VLOOKUP(AF524,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF524,Group,7,FALSE)=\"\",0,ROUND(AJ524-0.04999,1)-AJ524+AM524)","v":0},{"$f":"IF(VLOOKUP(AF524,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF524,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile - MLW",null,null,"6\" x 6\"",null,"Field - Star",null,null,null,null,null,null,null,null,"4.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA525,AG525)","v":30.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA525*(1-W525)+0.004999,2)","v":30.2},null,"",30.2,{"$f":"+W525","v":0},{"$f":"+X525","v":30.2},{"$f":"(AG525-AC525)/AG525","v":0},null,11,{"$f":"SUM(AJ525:AL525)+AE525","v":30.2},null,null,{"$f":"ROUND(AC525/(1-VLOOKUP(AF525,Group,2,FALSE)),2)","v":30.2},{"$f":"IF(VLOOKUP(AF525,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ525,1)-AJ525,2),Round,2,FALSE)+VLOOKUP(AF525,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF525,Group,7,FALSE)=\"\",0,ROUND(AJ525-0.04999,1)-AJ525+AM525)","v":0},{"$f":"IF(VLOOKUP(AF525,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF525,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\",AA527,AG527)","v":17.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA527*(1-W527)+0.004999,2)","v":17.8},null,"",17.8,{"$f":"+W527","v":0},{"$f":"+X527","v":17.8},{"$f":"(AG527-AC527)/AG527","v":0},null,11,{"$f":"SUM(AJ527:AL527)+AE527","v":17.8},null,null,{"$f":"ROUND(AC527/(1-VLOOKUP(AF527,Group,2,FALSE)),2)","v":17.8},{"$f":"IF(VLOOKUP(AF527,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ527,1)-AJ527,2),Round,2,FALSE)+VLOOKUP(AF527,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF527,Group,7,FALSE)=\"\",0,ROUND(AJ527-0.04999,1)-AJ527+AM527)","v":0},{"$f":"IF(VLOOKUP(AF527,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF527,Group,7,FALSE))","v":""},null,"X"]
[]
[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 (Decorative Pattern)",null,null,null,"Crystal",null,null,null,null,"5.39 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA533,AG533)","v":20.399999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA533*(1-W533)+0.004999,2)","v":20.399999999999999},null,"",20.399999999999999,{"$f":"+W533","v":0},{"$f":"+X533","v":20.399999999999999},{"$f":"(AG533-AC533)/AG533","v":0},null,11,{"$f":"SUM(AJ533:AL533)+AE533","v":20.399999999999999},null,null,{"$f":"ROUND(AC533/(1-VLOOKUP(AF533,Group,2,FALSE)),2)","v":20.399999999999999},{"$f":"IF(VLOOKUP(AF533,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ533,1)-AJ533,2),Round,2,FALSE)+VLOOKUP(AF533,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF533,Group,7,FALSE)=\"\",0,ROUND(AJ533-0.04999,1)-AJ533+AM533)","v":0},{"$f":"IF(VLOOKUP(AF533,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF533,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\",AA534,AG534)","v":20.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA534*(1-W534)+0.004999,2)","v":20.5},null,"",20.5,{"$f":"+W534","v":0},{"$f":"+X534","v":20.5},{"$f":"(AG534-AC534)/AG534","v":0},null,11,{"$f":"SUM(AJ534:AL534)+AE534","v":20.5},null,null,{"$f":"ROUND(AC534/(1-VLOOKUP(AF534,Group,2,FALSE)),2)","v":20.5},{"$f":"IF(VLOOKUP(AF534,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ534,1)-AJ534,2),Round,2,FALSE)+VLOOKUP(AF534,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF534,Group,7,FALSE)=\"\",0,ROUND(AJ534-0.04999,1)-AJ534+AM534)","v":0},{"$f":"IF(VLOOKUP(AF534,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF534,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\",AA540,AG540)","v":16.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA540*(1-W540)+0.004999,2)","v":16.7},null,"",16.7,{"$f":"+W540","v":0},{"$f":"+X540","v":16.7},{"$f":"(AG540-AC540)/AG540","v":0},null,11,{"$f":"SUM(AJ540:AL540)+AE540","v":16.7},null,null,{"$f":"ROUND(AC540/(1-VLOOKUP(AF540,Group,2,FALSE)),2)","v":16.7},{"$f":"IF(VLOOKUP(AF540,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ540,1)-AJ540,2),Round,2,FALSE)+VLOOKUP(AF540,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF540,Group,7,FALSE)=\"\",0,ROUND(AJ540-0.04999,1)-AJ540+AM540)","v":0},{"$f":"IF(VLOOKUP(AF540,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF540,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":120,"n_cols":3,"rows_kept":120,"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 Pisa","Porcelain Floor & Wall Tile."]
["2024-10-10","Marmol","Porcelain Floor & Wall Tile."]
["2024-10-10","Vintage","Ceramic Wall Tile."]
[]
[]
[]
["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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Changes"]