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

{"sheet":"Instructions","index":0,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Lungarno"]
["File as","L"]
["Product Code","G"]
["CCTD Effective Date","1/1/25 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"G"}]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0,null,null,null,"  "]
[null,2,null,"Glass & Trim",null,"No",0]
[null,3,null,"Decos",null,"No",0]
[null,4,null,0,null,"No",0]
[null,5,null,0,null,"No",0]
[null,6,null,0,null,"No",0]
[null,7,null,0,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":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[5,0,5,10],[50,0,50,10],[52,0,52,10],[2,5,2,10],[3,4,3,7],[10,2,10,4],[10,8,10,10]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'L' - Lungarno"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 1/1/25 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,null,null,null,null,"Product Type"]
[1,null,"Artisan",null,null,null,null,null,"Glass Wall Mosaics"]
[1,null,"Back To Basics",null,null,null,null,null,"Glazed Ceramic Wall"]
[1,null,"Beat",null,null,null,null,null,"Glazed Ceramic Wall"]
[1,null,"Botanicals",null,null,null,null,null,"Pressed Glass Mosaics",null,null,null," "]
[1,null,"Carrollton",null,null,null,null,null,"Glazed Porcelain Floor"]
[1,null,"Carrollton",null,null,null,null,null,"Glazed Ceramic Wall"]
[2,null,"Carrollton",null,null,null,null,null,"Glazed Porcelain Mosaics"]
[2,null,"Casablanca",null,null,null,null,null,"Glazed Porcelain Floor"]
[2,null,"Casablanca",null,null,null,null,null,"Glazed Ceramic Wall"]
[2,null,"Classics 2.0",null,null,null,null,null,"Glazed Porcelain Floor"]
[2,null,"Classics 2.0",null,null,null,null,null,"Glazed Ceramic Wall"]
[2,null,"Coastline",null,null,null,null,null,"Glass Wall Mosaics"]
[2,null,"Disk",null,null,null,null,null,"Glazed Porcelain"]
[2,null,"Durstone",null,null,null,null,null,"Glazed Porcelain"]
[2,null,"Elements",null,null,null,null,null,"Unglazed Full Body Porcelain Mosaics"]
[3,null,"Finish Line",null,null,null,null,null,"Glazed Porcelain Mosaics"]
[3,null,"Jolly",null,null,null,null,null,"Glazed Ceramic Wall"]
[3,null,"Linea",null,null,null,null,null,"Glazed Ceramic Wall"]
[3,null,"London Metro",null,null,null,null,null,"Glazed Ceramic Wall"]
[3,null,"Marrakesh",null,null,null,null,null,"Glazed Porcelain Floor & Glazed Ceramic Wall"]
[3,null,"Massa Marble",null,null,null,null,null,"Glazed Porcelain Floor & Undulated Glazed Ceramic Wall"]
[3,null,"Melody",null,null,null,null,null,"Glazed Ceramic Wall"]
[3,null,"MidMod",null,null,null,null,null,"Glazed Porcelain"]
[3,null,"Multiforma",null,null,null,null,null,"Glazed Porcelain"]
[4,null,"Natural Elements",null,null,null,null,null,"Stone & Glass Wall Mosaics"]
[4,null,"Northern Lights",null,null,null,null,null,"Glass Mosaics"]
[4,null,"Organic Strands",null,null,null,null,null,"Glass Mosaics"]
[4,null,"Pure",null,null,null,null,null,"Glazed Porcelain"]
[4,null,"Retrospectives",null,null,null,null,null,"Glazed Porcelain Floor & Glazed Ceramic Wall"]
[4,null,"Simple Stone",null,null,null,null,null,"Glass Mosaics"]
[5,null,"Urban Textures Contempo",null,null,null,null,null,"Glass Wall Tile & Mosaics"]
[5,null,"Zellige Classique",null,null,null,null,null,"Glazed Terracotta"]
[]
[]
[]
[]
[]
[]
[]
["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":466,"n_cols":41,"rows_kept":466,"cut":false,"hidden":false,"merged":[[9,14,9,19],[10,14,10,15],[14,13,15,19],[12,14,12,19],[9,25,9,32],[13,30,13,32],[9,22,9,23],[12,22,12,23],[449,2,449,19],[451,2,451,19],[455,3,455,4],[18,2,18,19],[17,14,17,15]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"SF",{"$f":"+Instructions!$B$3","v":"G"},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,"Glass & Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA2,AG2)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,2,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,3,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,4,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,5,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,6,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,7,0,null,null,0,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,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",AA11,AG11)","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 'L' - Lungarno"},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":"1/1/25 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-01-27"},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 'G'"},null,null,null,null,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$11","v":"List Price"},"U/M",{"$f":"+U$11","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$11","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$11","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,"ARTISAN - Glass Wall Mosaics",null,null,null,null,null,null,null," "," "," ",null,null,null,null,"Item # Lookup:","LUAR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Carrara          Grigio          Onyx          Travertine",null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"11.25\" x 11.25\"",null,"Mosaic",null,"2\" Hexagon",null,null,"(Mesh-Mounted)",null,null,null,"0.87 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA25,AG25)","v":23.7},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA25*(1-W25)+0.004999,2)","v":23.7},null,"",23.7,{"$f":"+W25","v":0},{"$f":"+X25","v":23.7},{"$f":"(AG25-AC25)/AG25","v":0},null,2,{"$f":"SUM(AJ25:AL25)+AE25","v":23.7},null,null,{"$f":"ROUND(AC25/(1-VLOOKUP(AF25,Group,2,FALSE)),2)","v":23.7},{"$f":"IF(VLOOKUP(AF25,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ25,1)-AJ25,2),Round,2,FALSE)+VLOOKUP(AF25,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF25,Group,7,FALSE)=\"\",0,ROUND(AJ25-0.04999,1)-AJ25+AM25)","v":0},{"$f":"IF(VLOOKUP(AF25,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF25,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"BACK TO BASICS - Glazed Ceramic Wall",null,null,null,null,null,null," "," ",null,null,null,null,null,null,"Item # Lookup:","LUBB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Bianco Gloss",null,"    Cipria Gloss",null,null,"    Tortora Gloss",null,null,null,null,null,null,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,"Bianco Matte",null,"    Perla Gloss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"2\" x 10\"",null,"Field",null,null,null,null,null,null,null,null,"4.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA32,AG32)","v":11.3},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":11.3},null,"",11.3,{"$f":"+W32","v":0},{"$f":"+X32","v":11.3},{"$f":"(AG32-AC32)/AG32","v":0},null,1,{"$f":"SUM(AJ32:AL32)+AE32","v":11.3},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":11.3},{"$f":"IF(VLOOKUP(AF32,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ32,1)-AJ32,2),Round,2,FALSE)+VLOOKUP(AF32,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",0,ROUND(AJ32-0.04999,1)-AJ32+AM32)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF32,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"1/2\" x 10\"",null,"Jolly",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA34,AG34)","v":12.2},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},12.2,null,"",12.2,0,12.2,0,null,2,12.2,null,null,12.2,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Ceruleo Gloss",null,"    Muschio Gloss",null,null,"              Senape Gloss",null,null,null,null,null,null,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,"Fango Gloss",null,"    Rosa Antico Gloss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"2\" x 10\"",null,"Field",null,null,null,null,null,null,null,null,"4.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA39,AG39)","v":12.8},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA39*(1-W39)+0.004999,2)","v":12.8},null,"",12.8,{"$f":"+W39","v":0},{"$f":"+X39","v":12.8},{"$f":"(AG39-AC39)/AG39","v":0},null,1,{"$f":"SUM(AJ39:AL39)+AE39","v":12.8},null,null,{"$f":"ROUND(AC39/(1-VLOOKUP(AF39,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF39,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ39,1)-AJ39,2),Round,2,FALSE)+VLOOKUP(AF39,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF39,Group,7,FALSE)=\"\",0,ROUND(AJ39-0.04999,1)-AJ39+AM39)","v":0},{"$f":"IF(VLOOKUP(AF39,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF39,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"1/2\" x 10\"",null,"Jolly",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA41,AG41)","v":12.65},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA41*(1-W41)+0.004999,2)","v":12.65},null,"",12.65,{"$f":"+W41","v":0},{"$f":"+X41","v":12.65},{"$f":"(AG41-AC41)/AG41","v":0},null,2,{"$f":"SUM(AJ41:AL41)+AE41","v":12.65},null,null,{"$f":"ROUND(AC41/(1-VLOOKUP(AF41,Group,2,FALSE)),2)","v":12.65},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Nero Gloss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"2\" x 10\"",null,"Field",null,null,null,null,null,null,null,null,"4.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA45,AG45)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA45*(1-W45)+0.004999,2)","v":13.55},null,"",13.55,{"$f":"+W45","v":0},{"$f":"+X45","v":13.55},{"$f":"(AG45-AC45)/AG45","v":0},null,1,{"$f":"SUM(AJ45:AL45)+AE45","v":13.55},null,null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF45,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ45,1)-AJ45,2),Round,2,FALSE)+VLOOKUP(AF45,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF45,Group,7,FALSE)=\"\",0,ROUND(AJ45-0.04999,1)-AJ45+AM45)","v":0},{"$f":"IF(VLOOKUP(AF45,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF45,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"1/2\" x 10\"",null,"Jolly",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA47,AG47)","v":13.1},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA47*(1-W47)+0.004999,2)","v":13.1},null,"",13.1,{"$f":"+W47","v":0},{"$f":"+X47","v":13.1},{"$f":"(AG47-AC47)/AG47","v":0},null,2,{"$f":"SUM(AJ47:AL47)+AE47","v":13.1},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":13.1},{"$f":"IF(VLOOKUP(AF47,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ47,1)-AJ47,2),Round,2,FALSE)+VLOOKUP(AF47,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF47,Group,7,FALSE)=\"\",0,ROUND(AJ47-0.04999,1)-AJ47+AM47)","v":0},{"$f":"IF(VLOOKUP(AF47,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF47,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"BEAT - Glazed Ceramic Wall",null,null,null,null,null,null," "," ",null,null,null,null,null,null,"Item # Lookup:","LUBE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Cinnamon Satin          Lemonade Satin          Ultramarine Satin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"2\" x 8\"",null,"Field",null,"Flat",null,null,null,null,null,null,"5.40 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA53,AG53)","v":13.1},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA53*(1-W53)+0.004999,2)","v":13.1},null,"",13.1,{"$f":"+W53","v":0},{"$f":"+X53","v":13.1},{"$f":"(AG53-AC53)/AG53","v":0},null,1,{"$f":"SUM(AJ53:AL53)+AE53","v":13.1},null,null,{"$f":"ROUND(AC53/(1-VLOOKUP(AF53,Group,2,FALSE)),2)","v":13.1},{"$f":"IF(VLOOKUP(AF53,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ53,1)-AJ53,2),Round,2,FALSE)+VLOOKUP(AF53,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",0,ROUND(AJ53-0.04999,1)-AJ53+AM53)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF53,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"2\" x 8\"",null,"Field",null,"Charleston",null,null,null,null,null,null,"4.75 SF/CTN",null,"b,c",{"$f":"IF(Suggested=\"Yes\",AA55,AG55)","v":15.35},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA55*(1-W55)+0.004999,2)","v":15.35},null,"",15.35,{"$f":"+W55","v":0},{"$f":"+X55","v":15.35},{"$f":"(AG55-AC55)/AG55","v":0},null,2,{"$f":"SUM(AJ55:AL55)+AE55","v":15.35},null,null,{"$f":"ROUND(AC55/(1-VLOOKUP(AF55,Group,2,FALSE)),2)","v":15.35},{"$f":"IF(VLOOKUP(AF55,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ55,1)-AJ55,2),Round,2,FALSE)+VLOOKUP(AF55,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF55,Group,7,FALSE)=\"\",0,ROUND(AJ55-0.04999,1)-AJ55+AM55)","v":0},{"$f":"IF(VLOOKUP(AF55,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF55,Group,7,FALSE))","v":""},null,"X"]
[null,"Glass & Trim",null,null,"2\" x 8\"",null,"Field",null,"Dixie",null,null,null,null,null,null,"4.75 SF/CTN",null,"b,d",{"$f":"IF(Suggested=\"Yes\",AA56,AG56)","v":15.35},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":15.35},null,"",15.35,{"$f":"+W56","v":0},{"$f":"+X56","v":15.35},{"$f":"(AG56-AC56)/AG56","v":0},null,2,{"$f":"SUM(AJ56:AL56)+AE56","v":15.35},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":15.35},{"$f":"IF(VLOOKUP(AF56,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ56,1)-AJ56,2),Round,2,FALSE)+VLOOKUP(AF56,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",0,ROUND(AJ56-0.04999,1)-AJ56+AM56)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF56,Group,7,FALSE))","v":""},null,"X"]
[null,"Glass & Trim",null,null,"2\" x 8\"",null,"Field",null,"Swing",null,null,null,null,null,null,"4.75 SF/CTN",null,"b,c",{"$f":"IF(Suggested=\"Yes\",AA57,AG57)","v":15.35},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA57*(1-W57)+0.004999,2)","v":15.35},null,"",15.35,{"$f":"+W57","v":0},{"$f":"+X57","v":15.35},{"$f":"(AG57-AC57)/AG57","v":0},null,2,{"$f":"SUM(AJ57:AL57)+AE57","v":15.35},null,null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":15.35},{"$f":"IF(VLOOKUP(AF57,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ57,1)-AJ57,2),Round,2,FALSE)+VLOOKUP(AF57,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",0,ROUND(AJ57-0.04999,1)-AJ57+AM57)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF57,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Glass & Trim",null,null,"1/2\" x 10\"",null,"Jolly",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA59,AG59)","v":12.65},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA59*(1-W59)+0.004999,2)","v":12.65},null,"",12.65,{"$f":"+W59","v":0},{"$f":"+X59","v":12.65},{"$f":"(AG59-AC59)/AG59","v":0},null,2,{"$f":"SUM(AJ59:AL59)+AE59","v":12.65},null,null,{"$f":"ROUND(AC59/(1-VLOOKUP(AF59,Group,2,FALSE)),2)","v":12.65},{"$f":"IF(VLOOKUP(AF59,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ59,1)-AJ59,2),Round,2,FALSE)+VLOOKUP(AF59,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",0,ROUND(AJ59-0.04999,1)-AJ59+AM59)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF59,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Milk Gloss          Milk Satin          Powder Satin          Sage Satin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"2\" x 8\"",null,"Field",null,"Flat",null,null,null,null,null,null,"5.40 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA63,AG63)","v":11.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA63*(1-W63)+0.004999,2)","v":11.5},null,"",11.5,{"$f":"+W63","v":0},{"$f":"+X63","v":11.5},{"$f":"(AG63-AC63)/AG63","v":0},null,1,{"$f":"SUM(AJ63:AL63)+AE63","v":11.5},null,null,{"$f":"ROUND(AC63/(1-VLOOKUP(AF63,Group,2,FALSE)),2)","v":11.5},{"$f":"IF(VLOOKUP(AF63,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ63,1)-AJ63,2),Round,2,FALSE)+VLOOKUP(AF63,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF63,Group,7,FALSE)=\"\",0,ROUND(AJ63-0.04999,1)-AJ63+AM63)","v":0},{"$f":"IF(VLOOKUP(AF63,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF63,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"2\" x 8\"",null,"Field",null,"Charleston",null,null,null,null,null,null,"4.75 SF/CTN",null,"b,c",{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":13.7},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":13.7},null,"",13.7,{"$f":"+W65","v":0},{"$f":"+X65","v":13.7},{"$f":"(AG65-AC65)/AG65","v":0},null,2,{"$f":"SUM(AJ65:AL65)+AE65","v":13.7},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":13.7},{"$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,"Glass & Trim",null,null,"2\" x 8\"",null,"Field",null,"Dixie",null,null,null,null,null,null,"4.75 SF/CTN",null,"b,d",13.7,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},13.7,null,"",13.7,0,13.7,0,null,2,13.7,null,null,13.7,0,0,"",null,"X"]
[null,"Glass & Trim",null,null,"2\" x 8\"",null,"Field",null,"Swing",null,null,null,null,null,null,"4.75 SF/CTN",null,"b,c",13.7,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},13.7,null,"",13.7,0,13.7,0,null,2,13.7,null,null,13.7,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"1/2\" x 10\"",null,"Jolly",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA69,AG69)","v":11.9},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA69*(1-W69)+0.004999,2)","v":11.9},null,"",11.9,{"$f":"+W69","v":0},{"$f":"+X69","v":11.9},{"$f":"(AG69-AC69)/AG69","v":0},null,2,{"$f":"SUM(AJ69:AL69)+AE69","v":11.9},null,null,{"$f":"ROUND(AC69/(1-VLOOKUP(AF69,Group,2,FALSE)),2)","v":11.9},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","a) Packaging is changing to 6.46 SF/CTN as inventories of the old packaging is depleted.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"b) Check with Customer Service to be sure which SF/CTN packaging you will be receiving.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"c) Packaging is changing to 5.16 SF/CTN as inventories of the old packaging is depleted.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"d) Packaging is changing to 6.13 SF/CTN as inventories of the old packaging is depleted.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"BOTANICALS - Pressed Glass Mosaics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUBO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Ainsley          Bryn          Calla          Daphne          Elowen          Freya",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"11.73\" x 10.20\"",null,"Mosaic",null,"3\" Hexagon",null,null,null,null,null,null,"0.83 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA80,AG80)","v":21.9},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA80*(1-W80)+0.004999,2)","v":21.9},null,"",21.9,{"$f":"+W80","v":0},{"$f":"+X80","v":21.9},{"$f":"(AG80-AC80)/AG80","v":0},null,2,{"$f":"SUM(AJ80:AL80)+AE80","v":21.9},null,null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":21.9},{"$f":"IF(VLOOKUP(AF80,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ80,1)-AJ80,2),Round,2,FALSE)+VLOOKUP(AF80,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",0,ROUND(AJ80-0.04999,1)-AJ80+AM80)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF80,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"CARROLLTON - Glazed Porcelain Floor & Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUCA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Biscuit          Charcoal          Gray          Khaki          Sand          White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile","     Floor:",null,"9\" x 10\" Hexagon",null,"Field",null,null,null,"Matte",null,null,null,null,"8.07 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA86,AG86)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA86*(1-W86)+0.004999,2)","v":10.85},null,"",10.85,{"$f":"+W86","v":0},{"$f":"+X86","v":10.85},{"$f":"(AG86-AC86)/AG86","v":0},null,1,{"$f":"SUM(AJ86:AL86)+AE86","v":10.85},null,null,{"$f":"ROUND(AC86/(1-VLOOKUP(AF86,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF86,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ86,1)-AJ86,2),Round,2,FALSE)+VLOOKUP(AF86,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",0,ROUND(AJ86-0.04999,1)-AJ86+AM86)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF86,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Biscuit Gloss          Gray Gloss          White Gloss          White Matte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile","     Wall:",null,"2\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"11.10 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",AA90,AG90)","v":5.6},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA90*(1-W90)+0.004999,2)","v":5.6},null,"",5.6,{"$f":"+W90","v":0},{"$f":"+X90","v":5.6},{"$f":"(AG90-AC90)/AG90","v":0},null,1,{"$f":"SUM(AJ90:AL90)+AE90","v":5.6},null,null,{"$f":"ROUND(AC90/(1-VLOOKUP(AF90,Group,2,FALSE)),2)","v":5.6},{"$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,"Field Tile",null,null,"3\" x 6\"",null,"Field",null,null,null,null,null,null,null,null,"16.50 SF/CTN",null,null,4.45,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":4.45},null,"",4.45,{"$f":"+W91","v":0},4.45,{"$f":"(AG91-AC91)/AG91","v":0},null,1,{"$f":"SUM(AJ91:AL91)+AE91","v":4.45},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":4.45},{"$f":"IF(VLOOKUP(AF91,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ91,1)-AJ91,2),Round,2,FALSE)+VLOOKUP(AF91,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",0,ROUND(AJ91-0.04999,1)-AJ91+AM91)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF91,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"3\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"15.00 SF/CTN",null,"c",4.75,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":4.75},null,"",4.75,0,4.75,{"$f":"(AG92-AC92)/AG92","v":0},null,1,{"$f":"SUM(AJ92:AL92)+AE92","v":4.75},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":4.75},{"$f":"IF(VLOOKUP(AF92,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ92,1)-AJ92,2),Round,2,FALSE)+VLOOKUP(AF92,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",0,ROUND(AJ92-0.04999,1)-AJ92+AM92)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF92,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"13.33 SF/CTN","Stock","d",4.45,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA93*(1-W93)+0.004999,2)","v":4.45},null,"",4.45,0,4.45,{"$f":"(AG93-AC93)/AG93","v":0},null,1,{"$f":"SUM(AJ93:AL93)+AE93","v":4.45},null,null,{"$f":"ROUND(AC93/(1-VLOOKUP(AF93,Group,2,FALSE)),2)","v":4.45},{"$f":"IF(VLOOKUP(AF93,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ93,1)-AJ93,2),Round,2,FALSE)+VLOOKUP(AF93,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",0,ROUND(AJ93-0.04999,1)-AJ93+AM93)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF93,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"4\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"11.11 SF/CTN",null,null,4.45,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA94*(1-W94)+0.004999,2)","v":4.45},null,"",4.45,0,4.45,{"$f":"(AG94-AC94)/AG94","v":0},null,1,{"$f":"SUM(AJ94:AL94)+AE94","v":4.45},null,null,{"$f":"ROUND(AC94/(1-VLOOKUP(AF94,Group,2,FALSE)),2)","v":4.45},{"$f":"IF(VLOOKUP(AF94,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ94,1)-AJ94,2),Round,2,FALSE)+VLOOKUP(AF94,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",0,ROUND(AJ94-0.04999,1)-AJ94+AM94)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF94,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"3\" x 6\"",null,"Bullnose - (3\" Edge)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA96,AG96)","v":3.5},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA96*(1-W96)+0.004999,2)","v":3.5},null,"",3.5,{"$f":"+W96","v":0},{"$f":"+X96","v":3.5},{"$f":"(AG96-AC96)/AG96","v":0},null,2,{"$f":"SUM(AJ96:AL96)+AE96","v":3.5},null,null,{"$f":"ROUND(AC96/(1-VLOOKUP(AF96,Group,2,FALSE)),2)","v":3.5},{"$f":"IF(VLOOKUP(AF96,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ96,1)-AJ96,2),Round,2,FALSE)+VLOOKUP(AF96,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",0,ROUND(AJ96-0.04999,1)-AJ96+AM96)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF96,Group,7,FALSE))","v":""},null,"X"]
[null,"Glass & Trim",null,null,"3\" x 6\"",null,"Bullnose - (6\" Edge)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA97,AG97)","v":3.5},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA97*(1-W97)+0.004999,2)","v":3.5},null,"",3.5,{"$f":"+W97","v":0},{"$f":"+X97","v":3.5},{"$f":"(AG97-AC97)/AG97","v":0},null,2,{"$f":"SUM(AJ97:AL97)+AE97","v":3.5},null,null,{"$f":"ROUND(AC97/(1-VLOOKUP(AF97,Group,2,FALSE)),2)","v":3.5},{"$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,"Glass & Trim",null,null,"4\" x 12\"",null,"Bullnose - (4\" Edge)",null,null,null,null,null,null,null,null,null,null,"e",5.25,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},5.25,null,"",5.25,0,5.25,0,null,2,5.25,null,null,5.25,0,0,"",null,"X"]
[null,"Glass & Trim",null,null,"4\" x 12\"",null,"Bullnose - (12\" Edge)",null,null,null,null,null,null,null,null,null,"Stock","d",5.25,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},5.25,null,"",5.25,0,5.25,0,null,2,5.25,null,null,5.25,0,0,"",null,"X"]
[null,"Glass & Trim",null,null,"4\" x 16\"",null,"Bullnose - (16\" Edge)",null,null,null,null,null,null,null,null,null,null,null,6.75,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},6.75,null,"",6.75,0,6.75,0,null,2,6.75,null,null,6.75,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Charcoal Gloss          Khaki Gloss          Sand Gloss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile","     Wall:",null,"4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"13.33 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA104,AG104)","v":5.05},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA104*(1-W104)+0.004999,2)","v":5.05},null,"",5.05,{"$f":"+W104","v":0},{"$f":"+X104","v":5.05},{"$f":"(AG104-AC104)/AG104","v":0},null,1,{"$f":"SUM(AJ104:AL104)+AE104","v":5.05},null,null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":5.05},{"$f":"IF(VLOOKUP(AF104,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ104,1)-AJ104,2),Round,2,FALSE)+VLOOKUP(AF104,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",0,ROUND(AJ104-0.04999,1)-AJ104+AM104)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF104,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"4\" x 12\"",null,"Bullnose - (12\" Edge)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA106,AG106)","v":5.5},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":5.5},null,"",5.5,{"$f":"+W106","v":0},{"$f":"+X106","v":5.5},{"$f":"(AG106-AC106)/AG106","v":0},null,2,{"$f":"SUM(AJ106:AL106)+AE106","v":5.5},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":5.5},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","See Jolly Series for 1/2\" x 12\" Universal Jolly that coordinates with colors Charcoal Gloss, White Gloss and White Matte.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"a) Packaging is changing to 9.08 SF/CTN as inventories of the old packaging is depleted.  Check with Customer Service to be",null,null,null,null,null,null,null,null,null,null,null,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,"sure which SF/CTN packaging you will be receiving.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"b) Not available in color White Matte.",null,null,null,null,null,"c) Available in color White Gloss 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,"X"]
[null,null,null,null,"d) Stocked in colors White Gloss & White Matte only.",null,null,null,null,null,"e) Available in colors White Gloss & White Matte 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,"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,"CARROLLTON - Glazed Porcelain Mosaics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUCA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Biscuit Gloss",null,"      Gray Gloss",null,null,"     Sand Gloss",null,null,null,null,null,null,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,"Charcoal Gloss",null,"      Khaki Gloss",null,null,"     White Gloss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"10\" x 12\"",null,"Mosaic",null,null,"1\" Hexagon",null,"(Mesh-Mounted)",null,null,null,"0.80 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA119,AG119)","v":10.8},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA119*(1-W119)+0.004999,2)","v":10.8},null,"",10.8,{"$f":"+W119","v":0},{"$f":"+X119","v":10.8},{"$f":"(AG119-AC119)/AG119","v":0},null,2,{"$f":"SUM(AJ119:AL119)+AE119","v":10.8},null,null,{"$f":"ROUND(AC119/(1-VLOOKUP(AF119,Group,2,FALSE)),2)","v":10.8},{"$f":"IF(VLOOKUP(AF119,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ119,1)-AJ119,2),Round,2,FALSE)+VLOOKUP(AF119,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",0,ROUND(AJ119-0.04999,1)-AJ119+AM119)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF119,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Biscuit Matte",null,"      Gray Matte",null,null,"     Sand Matte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Charcoal Matte",null,"      Khaki Matte",null,null,"     White Matte",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"Glass & Trim",null,null,"11\" x 13\"",null,"Mosaic",null,null,"2\" Hexagon",null,"(Mesh-Mounted)",null,null,null,"0.96 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA124,AG124)","v":10.15},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA124*(1-W124)+0.004999,2)","v":10.15},null,"",10.15,{"$f":"+W124","v":0},{"$f":"+X124","v":10.15},{"$f":"(AG124-AC124)/AG124","v":0},null,2,{"$f":"SUM(AJ124:AL124)+AE124","v":10.15},null,null,{"$f":"ROUND(AC124/(1-VLOOKUP(AF124,Group,2,FALSE)),2)","v":10.15},{"$f":"IF(VLOOKUP(AF124,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ124,1)-AJ124,2),Round,2,FALSE)+VLOOKUP(AF124,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",0,ROUND(AJ124-0.04999,1)-AJ124+AM124)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF124,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Biscuit Matte          Gray Matte          White Matte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Glass & Trim",null,null,"12\" x 12\"",null,"Mosaic",null,null,"2\" x 2\"",null,"(Mesh-Mounted)",null,null,null,"0.98 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA128,AG128)","v":8.65},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA128*(1-W128)+0.004999,2)","v":8.65},null,"",8.65,{"$f":"+W128","v":0},{"$f":"+X128","v":8.65},{"$f":"(AG128-AC128)/AG128","v":0},null,2,{"$f":"SUM(AJ128:AL128)+AE128","v":8.65},null,null,{"$f":"ROUND(AC128/(1-VLOOKUP(AF128,Group,2,FALSE)),2)","v":8.65},{"$f":"IF(VLOOKUP(AF128,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ128,1)-AJ128,2),Round,2,FALSE)+VLOOKUP(AF128,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",0,ROUND(AJ128-0.04999,1)-AJ128+AM128)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF128,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"CASABLANCA - Glazed Porcelain Floor & Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUCB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Cloud White          Ocean Blue          Pearl Gray",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile","     Floor:",null,"5.5\" x 6\" Hexagon",null,"Field",null,null,null,"Matte",null,null,null,null,"5.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA134,AG134)","v":23.45},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA134*(1-W134)+0.004999,2)","v":23.45},null,"",23.45,{"$f":"+W134","v":0},{"$f":"+X134","v":23.45},{"$f":"(AG134-AC134)/AG134","v":0},null,1,{"$f":"SUM(AJ134:AL134)+AE134","v":23.45},null,null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":23.45},{"$f":"IF(VLOOKUP(AF134,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ134,1)-AJ134,2),Round,2,FALSE)+VLOOKUP(AF134,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",0,ROUND(AJ134-0.04999,1)-AJ134+AM134)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF134,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Champagne          Emerald          Ocean Blue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"5.5\" x 6\" Hexagon",null,"Field - Flower Deco",null,null,null,"Matte",null,null,null,null,"5.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA138,AG138)","v":24.25},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA138*(1-W138)+0.004999,2)","v":24.25},null,"",24.25,{"$f":"+W138","v":0},{"$f":"+X138","v":24.25},{"$f":"(AG138-AC138)/AG138","v":0},null,2,{"$f":"SUM(AJ138:AL138)+AE138","v":24.25},null,null,{"$f":"ROUND(AC138/(1-VLOOKUP(AF138,Group,2,FALSE)),2)","v":24.25},{"$f":"IF(VLOOKUP(AF138,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ138,1)-AJ138,2),Round,2,FALSE)+VLOOKUP(AF138,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF138,Group,7,FALSE)=\"\",0,ROUND(AJ138-0.04999,1)-AJ138+AM138)","v":0},{"$f":"IF(VLOOKUP(AF138,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF138,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Champagne          Cloud White          Pearl Gray",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile","     Wall:",null,"2\" x 6\"",null,"Field",null,null,null,"Gloss",null,null,null,null,"5.35 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA142,AG142)","v":40.65},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA142*(1-W142)+0.004999,2)","v":40.65},null,"",40.65,{"$f":"+W142","v":0},{"$f":"+X142","v":40.65},{"$f":"(AG142-AC142)/AG142","v":0},null,1,{"$f":"SUM(AJ142:AL142)+AE142","v":40.65},null,null,{"$f":"ROUND(AC142/(1-VLOOKUP(AF142,Group,2,FALSE)),2)","v":40.65},{"$f":"IF(VLOOKUP(AF142,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ142,1)-AJ142,2),Round,2,FALSE)+VLOOKUP(AF142,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF142,Group,7,FALSE)=\"\",0,ROUND(AJ142-0.04999,1)-AJ142+AM142)","v":0},{"$f":"IF(VLOOKUP(AF142,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF142,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Emerald          Ocean Blue          Saffron",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"2\" x 6\"",null,"Field",null,null,null,"Gloss",null,null,null,null,"5.35 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA146,AG146)","v":46.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA146*(1-W146)+0.004999,2)","v":46.5},null,"",46.5,{"$f":"+W146","v":0},{"$f":"+X146","v":46.5},{"$f":"(AG146-AC146)/AG146","v":0},null,1,{"$f":"SUM(AJ146:AL146)+AE146","v":46.5},null,null,{"$f":"ROUND(AC146/(1-VLOOKUP(AF146,Group,2,FALSE)),2)","v":46.5},{"$f":"IF(VLOOKUP(AF146,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ146,1)-AJ146,2),Round,2,FALSE)+VLOOKUP(AF146,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",0,ROUND(AJ146-0.04999,1)-AJ146+AM146)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF146,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","a) 3D Field Tile consists of 3 pieces of different thicknesses and there are 22 pieces of each thickness in each carton.  Must be",null,null,null,null,null,null,null,null,null,null,null,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,"installed without grout.  Not to be used in wet areas such as shower walls.  Glaze on the Wall Tile can Crackle over time.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Lungarno recommends tiles to be sealed prior to installation with Laticrete Stontech BulletProof Sealer.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"CLASSICS 2.0 - Glazed Porcelain Floor & Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUC2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Calacatta Lincoln          Macael White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,"Floor:","12\" x 24\"",null,"Field",null,null,null,null,"Matte/Rectified",null,null,null,"9.68 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA156,AG156)","v":5.7},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA156*(1-W156)+0.004999,2)","v":5.7},null,"",5.7,{"$f":"+W156","v":0},{"$f":"+X156","v":5.7},{"$f":"(AG156-AC156)/AG156","v":0},null,1,{"$f":"SUM(AJ156:AL156)+AE156","v":5.7},null,null,{"$f":"ROUND(AC156/(1-VLOOKUP(AF156,Group,2,FALSE)),2)","v":5.7},{"$f":"IF(VLOOKUP(AF156,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ156,1)-AJ156,2),Round,2,FALSE)+VLOOKUP(AF156,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",0,ROUND(AJ156-0.04999,1)-AJ156+AM156)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF156,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,"Matte/Rectified",null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA157,AG157)","v":6.8},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":6.8},null,"",6.8,{"$f":"+W157","v":0},{"$f":"+X157","v":6.8},{"$f":"(AG157-AC157)/AG157","v":0},null,1,{"$f":"SUM(AJ157:AL157)+AE157","v":6.8},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":6.8},{"$f":"IF(VLOOKUP(AF157,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ157,1)-AJ157,2),Round,2,FALSE)+VLOOKUP(AF157,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",0,ROUND(AJ157-0.04999,1)-AJ157+AM157)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF157,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"9\" x 10\" Hexagon",null,"Field",null,null,null,null,"Matte/Rectified",null,null,null,"9.08 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA158,AG158)","v":10},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA158*(1-W158)+0.004999,2)","v":10},null,"",10,{"$f":"+W158","v":0},{"$f":"+X158","v":10},{"$f":"(AG158-AC158)/AG158","v":0},null,1,{"$f":"SUM(AJ158:AL158)+AE158","v":10},null,null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":10},{"$f":"IF(VLOOKUP(AF158,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ158,1)-AJ158,2),Round,2,FALSE)+VLOOKUP(AF158,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",0,ROUND(AJ158-0.04999,1)-AJ158+AM158)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF158,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Glass & Trim",null,null,"12.44\" x 11.57\"",null,"Mosaic",null,"1\" Pennyround",null,null,"Matte",null,"(Mesh-Mounted)",null,"1.00 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA160,AG160)","v":15.55},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},15.55,null,"",15.55,0,15.55,0,null,2,15.55,null,null,15.55,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,"Polished/Rectified",null,null,null,"9.68 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA162,AG162)","v":5.7},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA162*(1-W162)+0.004999,2)","v":5.7},null,"",5.7,{"$f":"+W162","v":0},{"$f":"+X162","v":5.7},{"$f":"(AG162-AC162)/AG162","v":0},null,1,{"$f":"SUM(AJ162:AL162)+AE162","v":5.7},null,null,{"$f":"ROUND(AC162/(1-VLOOKUP(AF162,Group,2,FALSE)),2)","v":5.7},{"$f":"IF(VLOOKUP(AF162,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ162,1)-AJ162,2),Round,2,FALSE)+VLOOKUP(AF162,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF162,Group,7,FALSE)=\"\",0,ROUND(AJ162-0.04999,1)-AJ162+AM162)","v":0},{"$f":"IF(VLOOKUP(AF162,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF162,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,"Polished/Rectified",null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA163,AG163)","v":6.8},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},6.8,null,"",6.8,0,6.8,0,null,1,6.8,null,null,6.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Calacatta Lincoln          Macael White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,"Wall:","3\" x 12\"",null,"Field",null,null,null,null,"Satin",null,null,null,"12.11 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA167,AG167)","v":6.25},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},6.25,null,"",6.25,0,6.25,0,null,1,6.25,null,null,6.25,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"1/2\" x 12\"",null,"Jolly",null,null,null,null,"Satin",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA169,AG169)","v":4.9000000000000004},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},4.9000000000000004,null,"",4.9000000000000004,0,4.9000000000000004,0,null,2,4.9000000000000004,null,null,4.9000000000000004,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"12.40\" x 10.83\"",null,"Mosaic",null,"1\" x 3\" Herringbone",null,null,"Glossy",null,null,null,"0.93 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA171,AG171)","v":14.85},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA171*(1-W171)+0.004999,2)","v":14.85},null,"",14.85,{"$f":"+W171","v":0},{"$f":"+X171","v":14.85},{"$f":"(AG171-AC171)/AG171","v":0},null,2,{"$f":"SUM(AJ171:AL171)+AE171","v":14.85},null,null,{"$f":"ROUND(AC171/(1-VLOOKUP(AF171,Group,2,FALSE)),2)","v":14.85},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"COASTLINE - Glass Wall Mosaics",null,null,null,null,null,null,null," "," "," ",null,null,null,null,"Item # Lookup:","LUCO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Big Sur          La Jolla          Monterey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"9.84\" x 12.13\"",null,"Mosaic",null,"2\" Lantern",null,null,"(Mesh-Mounted)",null,null,null,"0.82 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA177,AG177)","v":25.75},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA177*(1-W177)+0.004999,2)","v":25.75},null,"",25.75,{"$f":"+W177","v":0},{"$f":"+X177","v":25.75},{"$f":"(AG177-AC177)/AG177","v":0},null,2,{"$f":"SUM(AJ177:AL177)+AE177","v":25.75},null,null,{"$f":"ROUND(AC177/(1-VLOOKUP(AF177,Group,2,FALSE)),2)","v":25.75},{"$f":"IF(VLOOKUP(AF177,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ177,1)-AJ177,2),Round,2,FALSE)+VLOOKUP(AF177,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",0,ROUND(AJ177-0.04999,1)-AJ177+AM177)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF177,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"DISK - Glazed Porcelain",null,null,null,null,null,null,null," ",null,null,null,null,null,null,"Item # Lookup:","LUDI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Anthracite          Beige          Brown          Grey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,"Rectified",null,null,null,null,null,"11.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA183,AG183)","v":11.1},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":11.1},null,"",11.1,{"$f":"+W183","v":0},11.1,{"$f":"(AG183-AC183)/AG183","v":0},null,1,{"$f":"SUM(AJ183:AL183)+AE183","v":11.1},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":11.1},{"$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,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,"Rectified",null,null,null,null,null,"11.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA184,AG184)","v":11.1},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA184*(1-W184)+0.004999,2)","v":11.1},null,"",11.1,0,11.1,{"$f":"(AG184-AC184)/AG184","v":0},null,1,{"$f":"SUM(AJ184:AL184)+AE184","v":11.1},null,null,{"$f":"ROUND(AC184/(1-VLOOKUP(AF184,Group,2,FALSE)),2)","v":11.1},{"$f":"IF(VLOOKUP(AF184,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ184,1)-AJ184,2),Round,2,FALSE)+VLOOKUP(AF184,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",0,ROUND(AJ184-0.04999,1)-AJ184+AM184)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF184,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"36\" x 36\"",null,"Field",null,null,"Rectified",null,null,null,null,null,"17.44 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA185,AG185)","v":13.7},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA185*(1-W185)+0.004999,2)","v":13.7},null,"",13.7,0,13.7,{"$f":"(AG185-AC185)/AG185","v":0},null,1,{"$f":"SUM(AJ185:AL185)+AE185","v":13.7},null,null,{"$f":"ROUND(AC185/(1-VLOOKUP(AF185,Group,2,FALSE)),2)","v":13.7},{"$f":"IF(VLOOKUP(AF185,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ185,1)-AJ185,2),Round,2,FALSE)+VLOOKUP(AF185,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF185,Group,7,FALSE)=\"\",0,ROUND(AJ185-0.04999,1)-AJ185+AM185)","v":0},{"$f":"IF(VLOOKUP(AF185,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF185,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"14\" x 16\" Hexagon",null,"Field",null,null,null,null,null,null,null,null,"10.07 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA186,AG186)","v":13},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA186*(1-W186)+0.004999,2)","v":13},null,"",13,0,13,{"$f":"(AG186-AC186)/AG186","v":0},null,1,{"$f":"SUM(AJ186:AL186)+AE186","v":13},null,null,{"$f":"ROUND(AC186/(1-VLOOKUP(AF186,Group,2,FALSE)),2)","v":13},{"$f":"IF(VLOOKUP(AF186,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ186,1)-AJ186,2),Round,2,FALSE)+VLOOKUP(AF186,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF186,Group,7,FALSE)=\"\",0,ROUND(AJ186-0.04999,1)-AJ186+AM186)","v":0},{"$f":"IF(VLOOKUP(AF186,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF186,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"11.80\" x 11.80\"",null,"Mosaic",null,"2\" x 2\"",null,null,"(Mesh-Mounted)",null,null,null,"0.97 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA188,AG188)","v":22.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA188*(1-W188)+0.004999,2)","v":22.4},null,"",22.4,{"$f":"+W188","v":0},{"$f":"+X188","v":22.4},{"$f":"(AG188-AC188)/AG188","v":0},null,2,{"$f":"SUM(AJ188:AL188)+AE188","v":22.4},null,null,{"$f":"ROUND(AC188/(1-VLOOKUP(AF188,Group,2,FALSE)),2)","v":22.4},{"$f":"IF(VLOOKUP(AF188,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ188,1)-AJ188,2),Round,2,FALSE)+VLOOKUP(AF188,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF188,Group,7,FALSE)=\"\",0,ROUND(AJ188-0.04999,1)-AJ188+AM188)","v":0},{"$f":"IF(VLOOKUP(AF188,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF188,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"DURSTONE - Glazed Porcelain",null,null,null,null,null,null,null," ",null,null,null,null,null,null,"Item # Lookup:","LUDU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Taupe          White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,"Matte/Rectified",null,null," ",null,null,"9.68 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA194,AG194)","v":5.4},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA194*(1-W194)+0.004999,2)","v":5.4},null,"",5.4,{"$f":"+W194","v":0},{"$f":"+X194","v":5.4},{"$f":"(AG194-AC194)/AG194","v":0},null,1,{"$f":"SUM(AJ194:AL194)+AE194","v":5.4},null,null,{"$f":"ROUND(AC194/(1-VLOOKUP(AF194,Group,2,FALSE)),2)","v":5.4},{"$f":"IF(VLOOKUP(AF194,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ194,1)-AJ194,2),Round,2,FALSE)+VLOOKUP(AF194,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF194,Group,7,FALSE)=\"\",0,ROUND(AJ194-0.04999,1)-AJ194+AM194)","v":0},{"$f":"IF(VLOOKUP(AF194,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF194,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,"Matte/Rectified",null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA195,AG195)","v":6.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA195*(1-W195)+0.004999,2)","v":6.5},null,"",6.5,{"$f":"+W195","v":0},{"$f":"+X195","v":6.5},{"$f":"(AG195-AC195)/AG195","v":0},null,1,{"$f":"SUM(AJ195:AL195)+AE195","v":6.5},null,null,{"$f":"ROUND(AC195/(1-VLOOKUP(AF195,Group,2,FALSE)),2)","v":6.5},{"$f":"IF(VLOOKUP(AF195,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ195,1)-AJ195,2),Round,2,FALSE)+VLOOKUP(AF195,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF195,Group,7,FALSE)=\"\",0,ROUND(AJ195-0.04999,1)-AJ195+AM195)","v":0},{"$f":"IF(VLOOKUP(AF195,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF195,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,"Antislip/Rectified",null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA197,AG197)","v":7.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA197*(1-W197)+0.004999,2)","v":7.95},null,"",7.95,{"$f":"+W197","v":0},{"$f":"+X197","v":7.95},{"$f":"(AG197-AC197)/AG197","v":0},null,1,{"$f":"SUM(AJ197:AL197)+AE197","v":7.95},null,null,{"$f":"ROUND(AC197/(1-VLOOKUP(AF197,Group,2,FALSE)),2)","v":7.95},{"$f":"IF(VLOOKUP(AF197,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ197,1)-AJ197,2),Round,2,FALSE)+VLOOKUP(AF197,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF197,Group,7,FALSE)=\"\",0,ROUND(AJ197-0.04999,1)-AJ197+AM197)","v":0},{"$f":"IF(VLOOKUP(AF197,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF197,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","a) Packaging is changing to 11.62 SF/CTN as inventories of the old packaging is depleted.  Check with Customer Service to be",null,null,null,null,null,null,null,null,null,null,null,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,"sure which SF/CTN packaging you will be receiving.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"ELEMENTS - Unglazed Full Body Porcelain Mosaics",null,null,null,null,null,null,null,null,null," ",null,null,null,null,"Item # Lookup:","LUEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Carbon          Lead          Oxygen          Platinum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"12.32\" x 11.38\"",null,"Mosaic",null,"1\" Penny Round",null,null,"Matte",null,"(Mesh-Mounted)",null,"0.97 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA206,AG206)","v":13.15},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA206*(1-W206)+0.004999,2)","v":13.15},null,"",13.15,{"$f":"+W206","v":0},{"$f":"+X206","v":13.15},{"$f":"(AG206-AC206)/AG206","v":0},null,2,{"$f":"SUM(AJ206:AL206)+AE206","v":13.15},null,null,{"$f":"ROUND(AC206/(1-VLOOKUP(AF206,Group,2,FALSE)),2)","v":13.15},{"$f":"IF(VLOOKUP(AF206,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ206,1)-AJ206,2),Round,2,FALSE)+VLOOKUP(AF206,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF206,Group,7,FALSE)=\"\",0,ROUND(AJ206-0.04999,1)-AJ206+AM206)","v":0},{"$f":"IF(VLOOKUP(AF206,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF206,Group,7,FALSE))","v":""},null,"X"]
[null,"Glass & Trim",null,null,"12.68\" x 10.98\"",null,"Mosaic",null,"2\" Hexagon",null,null,"Matte",null,"(Mesh-Mounted)",null,"0.96 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA207,AG207)","v":13.2},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA207*(1-W207)+0.004999,2)","v":13.2},null,"",13.2,{"$f":"+W207","v":0},{"$f":"+X207","v":13.2},{"$f":"(AG207-AC207)/AG207","v":0},null,2,{"$f":"SUM(AJ207:AL207)+AE207","v":13.2},null,null,{"$f":"ROUND(AC207/(1-VLOOKUP(AF207,Group,2,FALSE)),2)","v":13.2},{"$f":"IF(VLOOKUP(AF207,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ207,1)-AJ207,2),Round,2,FALSE)+VLOOKUP(AF207,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF207,Group,7,FALSE)=\"\",0,ROUND(AJ207-0.04999,1)-AJ207+AM207)","v":0},{"$f":"IF(VLOOKUP(AF207,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF207,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"FINISH LINE - Glazed Porcelain Mosaics (Mesh-Mounted)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUFL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Glossy Black          Matte Black",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"12\" x 12\"",null,"Mosaic",null,null,"Penny Round",null,null,null,null,null,"1.00 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA213,AG213)","v":12.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA213*(1-W213)+0.004999,2)","v":12.05},null,"",12.05,{"$f":"+W213","v":0},{"$f":"+X213","v":12.05},{"$f":"(AG213-AC213)/AG213","v":0},null,2,{"$f":"SUM(AJ213:AL213)+AE213","v":12.05},null,null,{"$f":"ROUND(AC213/(1-VLOOKUP(AF213,Group,2,FALSE)),2)","v":12.05},{"$f":"IF(VLOOKUP(AF213,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ213,1)-AJ213,2),Round,2,FALSE)+VLOOKUP(AF213,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF213,Group,7,FALSE)=\"\",0,ROUND(AJ213-0.04999,1)-AJ213+AM213)","v":0},{"$f":"IF(VLOOKUP(AF213,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF213,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Glossy White          Matte White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"12\" x 12\"",null,"Mosaic",null,null,"Penny Round",null,null,null,null,null,"1.00 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA217,AG217)","v":10.55},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA217*(1-W217)+0.004999,2)","v":10.55},null,"",10.55,{"$f":"+W217","v":0},{"$f":"+X217","v":10.55},{"$f":"(AG217-AC217)/AG217","v":0},null,2,{"$f":"SUM(AJ217:AL217)+AE217","v":10.55},null,null,{"$f":"ROUND(AC217/(1-VLOOKUP(AF217,Group,2,FALSE)),2)","v":10.55},{"$f":"IF(VLOOKUP(AF217,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ217,1)-AJ217,2),Round,2,FALSE)+VLOOKUP(AF217,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF217,Group,7,FALSE)=\"\",0,ROUND(AJ217-0.04999,1)-AJ217+AM217)","v":0},{"$f":"IF(VLOOKUP(AF217,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF217,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"JOLLY - Ceramic Wall Universal Jolly",null,null,null,null,null,null," "," ",null,null,null,null,null,null,"Item # Lookup:","LUJO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Charcoal Gloss          Light Grey Gloss          White Gloss          White Matte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Glass & Trim",null,null,"1/2\" x 12\"",null,"Jolly (Universal)",null,null,null,null,null,null,null,null,null,null,"a",{"$f":"IF(Suggested=\"Yes\",AA223,AG223)","v":6.95},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA223*(1-W223)+0.004999,2)","v":6.95},null,"",6.95,{"$f":"+W223","v":0},{"$f":"+X223","v":6.95},{"$f":"(AG223-AC223)/AG223","v":0},null,2,{"$f":"SUM(AJ223:AL223)+AE223","v":6.95},null,null,{"$f":"ROUND(AC223/(1-VLOOKUP(AF223,Group,2,FALSE)),2)","v":6.95},{"$f":"IF(VLOOKUP(AF223,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ223,1)-AJ223,2),Round,2,FALSE)+VLOOKUP(AF223,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF223,Group,7,FALSE)=\"\",0,ROUND(AJ223-0.04999,1)-AJ223+AM223)","v":0},{"$f":"IF(VLOOKUP(AF223,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF223,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Note:","a) Colors Charcoal Gloss, White Gloss and White Matte coordinate with Carrolton Series colors Charcoal Gloss, White Gloss and White Matte.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"LINEA - Glazed Ceramic Wall",null,null,null,null,null,null," "," ",null,null,null,null,null,null,"Item # Lookup:","LULI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Ardesia","Ghiaccio",null,null,"          Prussia",null,"         Terracotta",null,null,null,null,null,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,"Cenere","Moka",null,null,"          Sabbia",null,"         Verde Menta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"3\" x 12\"",null,"Field",null,null,"Glossy",null,null,null,null,null,"10.78 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA232,AG232)","v":11.6},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA232*(1-W232)+0.004999,2)","v":11.6},null,"",11.6,{"$f":"+W232","v":0},{"$f":"+X232","v":11.6},{"$f":"(AG232-AC232)/AG232","v":0},null,1,{"$f":"SUM(AJ232:AL232)+AE232","v":11.6},null,null,{"$f":"ROUND(AC232/(1-VLOOKUP(AF232,Group,2,FALSE)),2)","v":11.6},{"$f":"IF(VLOOKUP(AF232,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ232,1)-AJ232,2),Round,2,FALSE)+VLOOKUP(AF232,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF232,Group,7,FALSE)=\"\",0,ROUND(AJ232-0.04999,1)-AJ232+AM232)","v":0},{"$f":"IF(VLOOKUP(AF232,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF232,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"2\" x 20\"",null,"Field",null,null,"Glossy",null,null,null,null,null,"5.38 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA233,AG233)","v":16.649999999999999},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA233*(1-W233)+0.004999,2)","v":16.649999999999999},null,"",16.649999999999999,{"$f":"+W233","v":0},{"$f":"+X233","v":16.649999999999999},{"$f":"(AG233-AC233)/AG233","v":0},null,1,{"$f":"SUM(AJ233:AL233)+AE233","v":16.649999999999999},null,null,{"$f":"ROUND(AC233/(1-VLOOKUP(AF233,Group,2,FALSE)),2)","v":16.649999999999999},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Glass & Trim",null,null,"1/2\" x 12\"",null,"Jolly",null,null,"Glossy",null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA235,AG235)","v":15.1},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA235*(1-W235)+0.004999,2)","v":15.1},null,"",15.1,{"$f":"+W235","v":0},{"$f":"+X235","v":15.1},{"$f":"(AG235-AC235)/AG235","v":0},null,2,{"$f":"SUM(AJ235:AL235)+AE235","v":15.1},null,null,{"$f":"ROUND(AC235/(1-VLOOKUP(AF235,Group,2,FALSE)),2)","v":15.1},{"$f":"IF(VLOOKUP(AF235,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ235,1)-AJ235,2),Round,2,FALSE)+VLOOKUP(AF235,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF235,Group,7,FALSE)=\"\",0,ROUND(AJ235-0.04999,1)-AJ235+AM235)","v":0},{"$f":"IF(VLOOKUP(AF235,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF235,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Ardesia","Ghiaccio",null,null,"          Prussia",null,"         Terracotta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"3\" x 12\"",null,"Field",null,null,"Matte",null,null,null,null,null,"10.78 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA239,AG239)","v":11.6},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA239*(1-W239)+0.004999,2)","v":11.6},null,"",11.6,{"$f":"+W239","v":0},{"$f":"+X239","v":11.6},{"$f":"(AG239-AC239)/AG239","v":0},null,1,{"$f":"SUM(AJ239:AL239)+AE239","v":11.6},null,null,{"$f":"ROUND(AC239/(1-VLOOKUP(AF239,Group,2,FALSE)),2)","v":11.6},{"$f":"IF(VLOOKUP(AF239,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ239,1)-AJ239,2),Round,2,FALSE)+VLOOKUP(AF239,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF239,Group,7,FALSE)=\"\",0,ROUND(AJ239-0.04999,1)-AJ239+AM239)","v":0},{"$f":"IF(VLOOKUP(AF239,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF239,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"1/2\" x 12\"",null,"Jolly",null,null,"Matte",null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA241,AG241)","v":15.1},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA241*(1-W241)+0.004999,2)","v":15.1},null,"",15.1,{"$f":"+W241","v":0},{"$f":"+X241","v":15.1},{"$f":"(AG241-AC241)/AG241","v":0},null,2,{"$f":"SUM(AJ241:AL241)+AE241","v":15.1},null,null,{"$f":"ROUND(AC241/(1-VLOOKUP(AF241,Group,2,FALSE)),2)","v":15.1},{"$f":"IF(VLOOKUP(AF241,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ241,1)-AJ241,2),Round,2,FALSE)+VLOOKUP(AF241,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF241,Group,7,FALSE)=\"\",0,ROUND(AJ241-0.04999,1)-AJ241+AM241)","v":0},{"$f":"IF(VLOOKUP(AF241,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF241,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"LONDON METRO - Glazed Ceramic Wall",null,null,null,null,null,null," "," ",null,null,null,null,null,null,"Item # Lookup:","LULM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Greenwich Mist          Hampstead Dew          Mayfair White          Soho Grey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"3\" x 12\"",null,"Field",null,null,"Satin",null,null,null,null,null,"12.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA247,AG247)","v":5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA247*(1-W247)+0.004999,2)","v":5},null,"",5,{"$f":"+W247","v":0},{"$f":"+X247","v":5},{"$f":"(AG247-AC247)/AG247","v":0},null,1,{"$f":"SUM(AJ247:AL247)+AE247","v":5},null,null,{"$f":"ROUND(AC247/(1-VLOOKUP(AF247,Group,2,FALSE)),2)","v":5},{"$f":"IF(VLOOKUP(AF247,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ247,1)-AJ247,2),Round,2,FALSE)+VLOOKUP(AF247,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF247,Group,7,FALSE)=\"\",0,ROUND(AJ247-0.04999,1)-AJ247+AM247)","v":0},{"$f":"IF(VLOOKUP(AF247,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF247,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"3\" x 12\"",null,"Bullnose",null,null,"Satin",null,null,"Discontinued 1/27/25",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA249,AG249)","v":4.8},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA249*(1-W249)+0.004999,2)","v":4.8},null,"",4.8,{"$f":"+W249","v":0},{"$f":"+X249","v":4.8},{"$f":"(AG249-AC249)/AG249","v":0},null,2,{"$f":"SUM(AJ249:AL249)+AE249","v":4.8},null,null,{"$f":"ROUND(AC249/(1-VLOOKUP(AF249,Group,2,FALSE)),2)","v":4.8},{"$f":"IF(VLOOKUP(AF249,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ249,1)-AJ249,2),Round,2,FALSE)+VLOOKUP(AF249,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF249,Group,7,FALSE)=\"\",0,ROUND(AJ249-0.04999,1)-AJ249+AM249)","v":0},{"$f":"IF(VLOOKUP(AF249,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF249,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"MARRAKESH - Glazed Porcelain Floor & Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUMA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Bahia          Macaal          Melah          Rubeli",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile","     Floor:",null,"8\" x 8\"",null,"Field - Decorative",null,null,null,"Matte",null,null,null,null,"5.60 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA255,AG255)","v":18.899999999999999},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA255*(1-W255)+0.004999,2)","v":18.899999999999999},null,"",18.899999999999999,{"$f":"+W255","v":0},{"$f":"+X255","v":18.899999999999999},{"$f":"(AG255-AC255)/AG255","v":0},null,1,{"$f":"SUM(AJ255:AL255)+AE255","v":18.899999999999999},null,null,{"$f":"ROUND(AC255/(1-VLOOKUP(AF255,Group,2,FALSE)),2)","v":18.899999999999999},{"$f":"IF(VLOOKUP(AF255,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ255,1)-AJ255,2),Round,2,FALSE)+VLOOKUP(AF255,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",0,ROUND(AJ255-0.04999,1)-AJ255+AM255)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF255,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Berber Black",null,"     Meknes Marine",null,null,"           Sidi Salt",null,null,null,null,null,null,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,"Medina Green",null,"     Sahara White",null,null,"           Tantan Beige",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile","     Wall:",null,"4\" x 4\"",null,"Field",null,null,null,"Gloss",null,null,null,null,"4.73 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA260,AG260)","v":22.85},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA260*(1-W260)+0.004999,2)","v":22.85},null,"",22.85,{"$f":"+W260","v":0},{"$f":"+X260","v":22.85},{"$f":"(AG260-AC260)/AG260","v":0},null,1,{"$f":"SUM(AJ260:AL260)+AE260","v":22.85},null,null,{"$f":"ROUND(AC260/(1-VLOOKUP(AF260,Group,2,FALSE)),2)","v":22.85},{"$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,"Field Tile",null,null,"2.5\" x 8\"",null,"Field",null,null,null,"Gloss",null,null,null,null,"5.17 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA261,AG261)","v":22.85},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA261*(1-W261)+0.004999,2)","v":22.85},null,"",22.85,{"$f":"+W261","v":0},{"$f":"+X261","v":22.85},{"$f":"(AG261-AC261)/AG261","v":0},null,1,{"$f":"SUM(AJ261:AL261)+AE261","v":22.85},null,null,{"$f":"ROUND(AC261/(1-VLOOKUP(AF261,Group,2,FALSE)),2)","v":22.85},{"$f":"IF(VLOOKUP(AF261,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ261,1)-AJ261,2),Round,2,FALSE)+VLOOKUP(AF261,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF261,Group,7,FALSE)=\"\",0,ROUND(AJ261-0.04999,1)-AJ261+AM261)","v":0},{"$f":"IF(VLOOKUP(AF261,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF261,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"1\" x 8\"",null,"Bullnose",null,null,null,"Gloss",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA263,AG263)","v":20.149999999999999},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA263*(1-W263)+0.004999,2)","v":20.149999999999999},null,"",20.149999999999999,{"$f":"+W263","v":0},{"$f":"+X263","v":20.149999999999999},{"$f":"(AG263-AC263)/AG263","v":0},null,2,{"$f":"SUM(AJ263:AL263)+AE263","v":20.149999999999999},null,null,{"$f":"ROUND(AC263/(1-VLOOKUP(AF263,Group,2,FALSE)),2)","v":20.149999999999999},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"MASSA MARBLE - Glazed Porcelain Floor & Undulated Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUMC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Calacatta Oro          Carrara",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile","     Floor:",null,"9\" x 10\" Hexagon",null,"Field",null,null,null,null,null,null,null,null,"8.06 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA269,AG269)","v":12.3},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA269*(1-W269)+0.004999,2)","v":12.3},null,"",12.3,{"$f":"+W269","v":0},{"$f":"+X269","v":12.3},{"$f":"(AG269-AC269)/AG269","v":0},null,1,{"$f":"SUM(AJ269:AL269)+AE269","v":12.3},null,null,{"$f":"ROUND(AC269/(1-VLOOKUP(AF269,Group,2,FALSE)),2)","v":12.3},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","a) Packaging for color Carrara is changing from 9.08 SF/CTN to 8.06 SF/CTN as inventories of the old packaging is depleted.",null,null,null,null,null,null,null,null,null,null,null,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,"Check with Customer Service to be sure which SF/CTN packaging you will be receiving.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"MELODY - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Easton White          Eme Ash          Lyric Blue          Mint Grey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"5\" x 5\"",null,"Field",null,null,null,"Glossy",null,null,null,null,"5.40 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA278,AG278)","v":18.25},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA278*(1-W278)+0.004999,2)","v":18.25},null,"",18.25,{"$f":"+W278","v":0},{"$f":"+X278","v":18.25},{"$f":"(AG278-AC278)/AG278","v":0},null,1,{"$f":"SUM(AJ278:AL278)+AE278","v":18.25},null,null,{"$f":"ROUND(AC278/(1-VLOOKUP(AF278,Group,2,FALSE)),2)","v":18.25},{"$f":"IF(VLOOKUP(AF278,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ278,1)-AJ278,2),Round,2,FALSE)+VLOOKUP(AF278,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF278,Group,7,FALSE)=\"\",0,ROUND(AJ278-0.04999,1)-AJ278+AM278)","v":0},{"$f":"IF(VLOOKUP(AF278,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF278,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"5\" x 5\"",null,"Field - Audrey Décor",null,null,null,"Glossy",null,null,null,null,"5.40 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA280,AG280)","v":21.4},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA280*(1-W280)+0.004999,2)","v":21.4},null,"",21.4,{"$f":"+W280","v":0},{"$f":"+X280","v":21.4},{"$f":"(AG280-AC280)/AG280","v":0},null,2,{"$f":"SUM(AJ280:AL280)+AE280","v":21.4},null,null,{"$f":"ROUND(AC280/(1-VLOOKUP(AF280,Group,2,FALSE)),2)","v":21.4},{"$f":"IF(VLOOKUP(AF280,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ280,1)-AJ280,2),Round,2,FALSE)+VLOOKUP(AF280,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF280,Group,7,FALSE)=\"\",0,ROUND(AJ280-0.04999,1)-AJ280+AM280)","v":0},{"$f":"IF(VLOOKUP(AF280,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF280,Group,7,FALSE))","v":""},null,"X"]
[null,"Glass & Trim",null,null,"5\" x 5\"",null,"Field - Chloe Décor",null,null,null,"Glossy",null,null,null,null,"5.40 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA281,AG281)","v":21.4},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA281*(1-W281)+0.004999,2)","v":21.4},null,"",21.4,{"$f":"+W281","v":0},{"$f":"+X281","v":21.4},{"$f":"(AG281-AC281)/AG281","v":0},null,2,{"$f":"SUM(AJ281:AL281)+AE281","v":21.4},null,null,{"$f":"ROUND(AC281/(1-VLOOKUP(AF281,Group,2,FALSE)),2)","v":21.4},{"$f":"IF(VLOOKUP(AF281,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ281,1)-AJ281,2),Round,2,FALSE)+VLOOKUP(AF281,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF281,Group,7,FALSE)=\"\",0,ROUND(AJ281-0.04999,1)-AJ281+AM281)","v":0},{"$f":"IF(VLOOKUP(AF281,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF281,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Glass & Trim",null,null,"1/2\" x 10\"",null,"Geometric Jolly",null,null,null,"Glossy",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA283,AG283)","v":20.399999999999999},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},20.399999999999999,null,"",20.399999999999999,0,20.399999999999999,0,null,2,20.399999999999999,null,null,20.399999999999999,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"MIDMOD - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUMM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Celeste          Citrine          Oat          Salt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"12.17\" x 13.31\"",null,"Mosaic",null,null,"1.25\" Disks",null,"(Mesh-Mounted)",null,null,null,"1.12 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA289,AG289)","v":14.85},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA289*(1-W289)+0.004999,2)","v":14.85},null,"",14.85,{"$f":"+W289","v":0},{"$f":"+X289","v":14.85},{"$f":"(AG289-AC289)/AG289","v":0},null,2,{"$f":"SUM(AJ289:AL289)+AE289","v":14.85},null,null,{"$f":"ROUND(AC289/(1-VLOOKUP(AF289,Group,2,FALSE)),2)","v":14.85},{"$f":"IF(VLOOKUP(AF289,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ289,1)-AJ289,2),Round,2,FALSE)+VLOOKUP(AF289,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF289,Group,7,FALSE)=\"\",0,ROUND(AJ289-0.04999,1)-AJ289+AM289)","v":0},{"$f":"IF(VLOOKUP(AF289,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF289,Group,7,FALSE))","v":""},null,"X"]
[null,"Glass & Trim"," ",null,"11.54\" x 11.65\"",null,"Mosaic",null,null,"1\" x 6\" Bars",null,"(Mesh-Mounted)",null,null,null,"0.93 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA290,AG290)","v":16.7},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA290*(1-W290)+0.004999,2)","v":16.7},null,"",16.7,{"$f":"+W290","v":0},{"$f":"+X290","v":16.7},{"$f":"(AG290-AC290)/AG290","v":0},null,2,{"$f":"SUM(AJ290:AL290)+AE290","v":16.7},null,null,{"$f":"ROUND(AC290/(1-VLOOKUP(AF290,Group,2,FALSE)),2)","v":16.7},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"MULTIFORMA - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUMU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Ardesia","Ghiaccio",null,null,"          Sabbia",null,null,null,null,null,null,null,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,"Cenere","Prussia",null,null,"          Terracotta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"36\" x 36\"",null,"Field",null,null,"Rectified",null,null,null,null,null,"17.44 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA297,AG297)","v":13.7},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA297*(1-W297)+0.004999,2)","v":13.7},null,"",13.7,{"$f":"+W297","v":0},{"$f":"+X297","v":13.7},{"$f":"(AG297-AC297)/AG297","v":0},null,1,{"$f":"SUM(AJ297:AL297)+AE297","v":13.7},null,null,{"$f":"ROUND(AC297/(1-VLOOKUP(AF297,Group,2,FALSE)),2)","v":13.7},{"$f":"IF(VLOOKUP(AF297,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ297,1)-AJ297,2),Round,2,FALSE)+VLOOKUP(AF297,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF297,Group,7,FALSE)=\"\",0,ROUND(AJ297-0.04999,1)-AJ297+AM297)","v":0},{"$f":"IF(VLOOKUP(AF297,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF297,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"NATURAL ELEMENTS - Stone & Glass Wall Mosaics (Mesh-Mounted)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUNA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Skyline",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"12\" x 10-7/8\"",null,"Mosaic",null,null,"Chevron",null,null,null,null,null,"0.90 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA303,AG303)","v":39.200000000000003},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA303*(1-W303)+0.004999,2)","v":39.200000000000003},null,"",39.200000000000003,{"$f":"+W303","v":0},{"$f":"+X303","v":39.200000000000003},{"$f":"(AG303-AC303)/AG303","v":0},null,2,{"$f":"SUM(AJ303:AL303)+AE303","v":39.200000000000003},null,null,{"$f":"ROUND(AC303/(1-VLOOKUP(AF303,Group,2,FALSE)),2)","v":39.200000000000003},{"$f":"IF(VLOOKUP(AF303,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ303,1)-AJ303,2),Round,2,FALSE)+VLOOKUP(AF303,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF303,Group,7,FALSE)=\"\",0,ROUND(AJ303-0.04999,1)-AJ303+AM303)","v":0},{"$f":"IF(VLOOKUP(AF303,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF303,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Cashmere",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"11-1/8\" x 9-3/4\"",null,"Mosaic",null,null,"Cube",null,null,null,null,null,"0.75 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA307,AG307)","v":37.35},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA307*(1-W307)+0.004999,2)","v":37.35},null,"",37.35,{"$f":"+W307","v":0},{"$f":"+X307","v":37.35},{"$f":"(AG307-AC307)/AG307","v":0},null,2,{"$f":"SUM(AJ307:AL307)+AE307","v":37.35},null,null,{"$f":"ROUND(AC307/(1-VLOOKUP(AF307,Group,2,FALSE)),2)","v":37.35},{"$f":"IF(VLOOKUP(AF307,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ307,1)-AJ307,2),Round,2,FALSE)+VLOOKUP(AF307,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF307,Group,7,FALSE)=\"\",0,ROUND(AJ307-0.04999,1)-AJ307+AM307)","v":0},{"$f":"IF(VLOOKUP(AF307,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF307,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Blue Heron          Mink",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"11-1/8\" x 11-7/8\"",null,"Mosaic",null,null,"Hexagon Leaves",null,null,null,null,null,"0.91 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA311,AG311)","v":39.1},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA311*(1-W311)+0.004999,2)","v":39.1},null,"",39.1,{"$f":"+W311","v":0},{"$f":"+X311","v":39.1},{"$f":"(AG311-AC311)/AG311","v":0},null,2,{"$f":"SUM(AJ311:AL311)+AE311","v":39.1},null,null,{"$f":"ROUND(AC311/(1-VLOOKUP(AF311,Group,2,FALSE)),2)","v":39.1},{"$f":"IF(VLOOKUP(AF311,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ311,1)-AJ311,2),Round,2,FALSE)+VLOOKUP(AF311,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF311,Group,7,FALSE)=\"\",0,ROUND(AJ311-0.04999,1)-AJ311+AM311)","v":0},{"$f":"IF(VLOOKUP(AF311,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF311,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Dove          Lace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"12\" x 11-3/4\"",null,"Mosaic",null,null,"Leaves",null,null,null,null,null,"0.97 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA315,AG315)","v":51.25},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA315*(1-W315)+0.004999,2)","v":51.25},null,"",51.25,{"$f":"+W315","v":0},{"$f":"+X315","v":51.25},{"$f":"(AG315-AC315)/AG315","v":0},null,2,{"$f":"SUM(AJ315:AL315)+AE315","v":51.25},null,null,{"$f":"ROUND(AC315/(1-VLOOKUP(AF315,Group,2,FALSE)),2)","v":51.25},{"$f":"IF(VLOOKUP(AF315,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ315,1)-AJ315,2),Round,2,FALSE)+VLOOKUP(AF315,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF315,Group,7,FALSE)=\"\",0,ROUND(AJ315-0.04999,1)-AJ315+AM315)","v":0},{"$f":"IF(VLOOKUP(AF315,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF315,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Mist          Snowfall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"11-1/8\" x 11-7/8\"",null,"Mosaic",null,null,"Teardrop",null,null,null,null,null,"0.91 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA319,AG319)","v":39.299999999999997},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA319*(1-W319)+0.004999,2)","v":39.299999999999997},null,"",39.299999999999997,{"$f":"+W319","v":0},{"$f":"+X319","v":39.299999999999997},{"$f":"(AG319-AC319)/AG319","v":0},null,2,{"$f":"SUM(AJ319:AL319)+AE319","v":39.299999999999997},null,null,{"$f":"ROUND(AC319/(1-VLOOKUP(AF319,Group,2,FALSE)),2)","v":39.299999999999997},{"$f":"IF(VLOOKUP(AF319,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ319,1)-AJ319,2),Round,2,FALSE)+VLOOKUP(AF319,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF319,Group,7,FALSE)=\"\",0,ROUND(AJ319-0.04999,1)-AJ319+AM319)","v":0},{"$f":"IF(VLOOKUP(AF319,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF319,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"NORTHERN LIGHTS - Glass Mosaics (Mesh-Mounted) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUNO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Asteroid          Cosmos          Galaxy          Moon          Neptune",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"10.20\" x 8.90\"",null,"Mosaic",null,null,"Hex Wheel",null,"Matte",null,null,null,"0.63 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA325,AG325)","v":23.75},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA325*(1-W325)+0.004999,2)","v":23.75},null,"",23.75,{"$f":"+W325","v":0},{"$f":"+X325","v":23.75},{"$f":"(AG325-AC325)/AG325","v":0},null,2,{"$f":"SUM(AJ325:AL325)+AE325","v":23.75},null,null,{"$f":"ROUND(AC325/(1-VLOOKUP(AF325,Group,2,FALSE)),2)","v":23.75},{"$f":"IF(VLOOKUP(AF325,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ325,1)-AJ325,2),Round,2,FALSE)+VLOOKUP(AF325,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF325,Group,7,FALSE)=\"\",0,ROUND(AJ325-0.04999,1)-AJ325+AM325)","v":0},{"$f":"IF(VLOOKUP(AF325,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF325,Group,7,FALSE))","v":""},null,"X"]
[null,"Glass & Trim",null,null,"11.60\" x 11.10\"",null,"Mosaic",null,null,"Raindrop",null,"Glossy & Matte",null,null,null,"0.90 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA326,AG326)","v":28.95},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA326*(1-W326)+0.004999,2)","v":28.95},null,"",28.95,{"$f":"+W326","v":0},{"$f":"+X326","v":28.95},{"$f":"(AG326-AC326)/AG326","v":0},null,2,{"$f":"SUM(AJ326:AL326)+AE326","v":28.95},null,null,{"$f":"ROUND(AC326/(1-VLOOKUP(AF326,Group,2,FALSE)),2)","v":28.95},{"$f":"IF(VLOOKUP(AF326,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ326,1)-AJ326,2),Round,2,FALSE)+VLOOKUP(AF326,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF326,Group,7,FALSE)=\"\",0,ROUND(AJ326-0.04999,1)-AJ326+AM326)","v":0},{"$f":"IF(VLOOKUP(AF326,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF326,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"ORGANIC STRANDS - Glass Mosaics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Beige          Grey          Ivory          Light Grey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"9-3/4\" x 12-1/8\"",null,"Mosaic",null,null,"2\" Lantern",null,"(Mesh-Mounted)",null,null,null,"0.82 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA332,AG332)","v":24.25},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA332*(1-W332)+0.004999,2)","v":24.25},null,"",24.25,{"$f":"+W332","v":0},{"$f":"+X332","v":24.25},{"$f":"(AG332-AC332)/AG332","v":0},null,2,{"$f":"SUM(AJ332:AL332)+AE332","v":24.25},null,null,{"$f":"ROUND(AC332/(1-VLOOKUP(AF332,Group,2,FALSE)),2)","v":24.25},{"$f":"IF(VLOOKUP(AF332,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ332,1)-AJ332,2),Round,2,FALSE)+VLOOKUP(AF332,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF332,Group,7,FALSE)=\"\",0,ROUND(AJ332-0.04999,1)-AJ332+AM332)","v":0},{"$f":"IF(VLOOKUP(AF332,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF332,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"PURE - Rectified Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUPU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Jet Black",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,"Matte",null,null,null,null,null,"10.52 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA338,AG338)","v":11.3},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA338*(1-W338)+0.004999,2)","v":11.3},null,"",11.3,{"$f":"+W338","v":0},{"$f":"+X338","v":11.3},{"$f":"(AG338-AC338)/AG338","v":0},null,1,{"$f":"SUM(AJ338:AL338)+AE338","v":11.3},null,null,{"$f":"ROUND(AC338/(1-VLOOKUP(AF338,Group,2,FALSE)),2)","v":11.3},{"$f":"IF(VLOOKUP(AF338,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ338,1)-AJ338,2),Round,2,FALSE)+VLOOKUP(AF338,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF338,Group,7,FALSE)=\"\",0,ROUND(AJ338-0.04999,1)-AJ338+AM338)","v":0},{"$f":"IF(VLOOKUP(AF338,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF338,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,"Matte",null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA339,AG339)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA339*(1-W339)+0.004999,2)","v":8.8000000000000007},null,"",8.8000000000000007,{"$f":"+W339","v":0},{"$f":"+X339","v":8.8000000000000007},{"$f":"(AG339-AC339)/AG339","v":0},null,1,{"$f":"SUM(AJ339:AL339)+AE339","v":8.8000000000000007},null,null,{"$f":"ROUND(AC339/(1-VLOOKUP(AF339,Group,2,FALSE)),2)","v":8.8000000000000007},{"$f":"IF(VLOOKUP(AF339,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ339,1)-AJ339,2),Round,2,FALSE)+VLOOKUP(AF339,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF339,Group,7,FALSE)=\"\",0,ROUND(AJ339-0.04999,1)-AJ339+AM339)","v":0},{"$f":"IF(VLOOKUP(AF339,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF339,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,"Matte",null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA340,AG340)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA340*(1-W340)+0.004999,2)","v":8.8000000000000007},null,"",8.8000000000000007,{"$f":"+W340","v":0},{"$f":"+X340","v":8.8000000000000007},{"$f":"(AG340-AC340)/AG340","v":0},null,1,{"$f":"SUM(AJ340:AL340)+AE340","v":8.8000000000000007},null,null,{"$f":"ROUND(AC340/(1-VLOOKUP(AF340,Group,2,FALSE)),2)","v":8.8000000000000007},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,"Polished",null,null,null,null,null,"10.52 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA342,AG342)","v":11.3},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA342*(1-W342)+0.004999,2)","v":11.3},null,"",11.3,{"$f":"+W342","v":0},{"$f":"+X342","v":11.3},{"$f":"(AG342-AC342)/AG342","v":0},null,1,{"$f":"SUM(AJ342:AL342)+AE342","v":11.3},null,null,{"$f":"ROUND(AC342/(1-VLOOKUP(AF342,Group,2,FALSE)),2)","v":11.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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,"Polished",null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA343,AG343)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},8.8000000000000007,null,"",8.8000000000000007,0,8.8000000000000007,0,null,1,8.8000000000000007,null,null,8.8000000000000007,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,"Polished",null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA344,AG344)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA344*(1-W344)+0.004999,2)","v":8.8000000000000007},null,"",8.8000000000000007,{"$f":"+W344","v":0},{"$f":"+X344","v":8.8000000000000007},{"$f":"(AG344-AC344)/AG344","v":0},null,1,{"$f":"SUM(AJ344:AL344)+AE344","v":8.8000000000000007},null,null,{"$f":"ROUND(AC344/(1-VLOOKUP(AF344,Group,2,FALSE)),2)","v":8.8000000000000007},{"$f":"IF(VLOOKUP(AF344,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ344,1)-AJ344,2),Round,2,FALSE)+VLOOKUP(AF344,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF344,Group,7,FALSE)=\"\",0,ROUND(AJ344-0.04999,1)-AJ344+AM344)","v":0},{"$f":"IF(VLOOKUP(AF344,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF344,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Frost White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,"Matte",null,null,null,null,null,"10.52 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA348,AG348)","v":8.25},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA348*(1-W348)+0.004999,2)","v":8.25},null,"",8.25,{"$f":"+W348","v":0},{"$f":"+X348","v":8.25},{"$f":"(AG348-AC348)/AG348","v":0},null,1,{"$f":"SUM(AJ348:AL348)+AE348","v":8.25},null,null,{"$f":"ROUND(AC348/(1-VLOOKUP(AF348,Group,2,FALSE)),2)","v":8.25},{"$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",null,null,"12\" x 24\"",null,"Field",null,null,"Matte",null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA349,AG349)","v":7.15},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA349*(1-W349)+0.004999,2)","v":7.15},null,"",7.15,{"$f":"+W349","v":0},{"$f":"+X349","v":7.15},{"$f":"(AG349-AC349)/AG349","v":0},null,1,{"$f":"SUM(AJ349:AL349)+AE349","v":7.15},null,null,{"$f":"ROUND(AC349/(1-VLOOKUP(AF349,Group,2,FALSE)),2)","v":7.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",null,null,"24\" x 24\"",null,"Field",null,null,"Matte",null,null,null,null,null,"15.49 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA350,AG350)","v":7.15},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA350*(1-W350)+0.004999,2)","v":7.15},null,"",7.15,{"$f":"+W350","v":0},{"$f":"+X350","v":7.15},{"$f":"(AG350-AC350)/AG350","v":0},null,1,{"$f":"SUM(AJ350:AL350)+AE350","v":7.15},null,null,{"$f":"ROUND(AC350/(1-VLOOKUP(AF350,Group,2,FALSE)),2)","v":7.15},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,"Polished",null,null,null,null,null,"10.52 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA352,AG352)","v":8.25},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA352*(1-W352)+0.004999,2)","v":8.25},null,"",8.25,{"$f":"+W352","v":0},{"$f":"+X352","v":8.25},{"$f":"(AG352-AC352)/AG352","v":0},null,1,{"$f":"SUM(AJ352:AL352)+AE352","v":8.25},null,null,{"$f":"ROUND(AC352/(1-VLOOKUP(AF352,Group,2,FALSE)),2)","v":8.25},{"$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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,"Polished",null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA353,AG353)","v":7.15},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA353*(1-W353)+0.004999,2)","v":7.15},null,"",7.15,{"$f":"+W353","v":0},{"$f":"+X353","v":7.15},{"$f":"(AG353-AC353)/AG353","v":0},null,1,{"$f":"SUM(AJ353:AL353)+AE353","v":7.15},null,null,{"$f":"ROUND(AC353/(1-VLOOKUP(AF353,Group,2,FALSE)),2)","v":7.15},{"$f":"IF(VLOOKUP(AF353,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ353,1)-AJ353,2),Round,2,FALSE)+VLOOKUP(AF353,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF353,Group,7,FALSE)=\"\",0,ROUND(AJ353-0.04999,1)-AJ353+AM353)","v":0},{"$f":"IF(VLOOKUP(AF353,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF353,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,"Polished",null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA354,AG354)","v":7.15},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA354*(1-W354)+0.004999,2)","v":7.15},null,"",7.15,{"$f":"+W354","v":0},{"$f":"+X354","v":7.15},{"$f":"(AG354-AC354)/AG354","v":0},null,1,{"$f":"SUM(AJ354:AL354)+AE354","v":7.15},null,null,{"$f":"ROUND(AC354/(1-VLOOKUP(AF354,Group,2,FALSE)),2)","v":7.15},{"$f":"IF(VLOOKUP(AF354,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ354,1)-AJ354,2),Round,2,FALSE)+VLOOKUP(AF354,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF354,Group,7,FALSE)=\"\",0,ROUND(AJ354-0.04999,1)-AJ354+AM354)","v":0},{"$f":"IF(VLOOKUP(AF354,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF354,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,"Polished",null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA355,AG355)","v":8.5500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA355*(1-W355)+0.004999,2)","v":8.5500000000000007},null,"",8.5500000000000007,{"$f":"+W355","v":0},{"$f":"+X355","v":8.5500000000000007},{"$f":"(AG355-AC355)/AG355","v":0},null,1,{"$f":"SUM(AJ355:AL355)+AE355","v":8.5500000000000007},null,null,{"$f":"ROUND(AC355/(1-VLOOKUP(AF355,Group,2,FALSE)),2)","v":8.5500000000000007},{"$f":"IF(VLOOKUP(AF355,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ355,1)-AJ355,2),Round,2,FALSE)+VLOOKUP(AF355,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF355,Group,7,FALSE)=\"\",0,ROUND(AJ355-0.04999,1)-AJ355+AM355)","v":0},{"$f":"IF(VLOOKUP(AF355,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF355,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","a) Packaging is changing to 15.50 SF/CTN as inventories of the old packaging is depleted.  Check with Customer Service to be",null,null,null,null,null,null,null,null,null,null,null,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,"sure which SF/CTN packaging you will be receiving.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"RETROSPECTIVES - Glazed Porcelain Floor & Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Covent Gardens          Notting Hill          Royal Blues",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,"Floor:","8\" x 8\"",null,"Field",null,null,"Matte",null,null,null,null,null,"5.60 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",AA364,AG364)","v":15.6},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA364*(1-W364)+0.004999,2)","v":15.6},null,"",15.6,{"$f":"+W364","v":0},{"$f":"+X364","v":15.6},{"$f":"(AG364-AC364)/AG364","v":0},null,1,{"$f":"SUM(AJ364:AL364)+AE364","v":15.6},null,null,{"$f":"ROUND(AC364/(1-VLOOKUP(AF364,Group,2,FALSE)),2)","v":15.6},{"$f":"IF(VLOOKUP(AF364,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ364,1)-AJ364,2),Round,2,FALSE)+VLOOKUP(AF364,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF364,Group,7,FALSE)=\"\",0,ROUND(AJ364-0.04999,1)-AJ364+AM364)","v":0},{"$f":"IF(VLOOKUP(AF364,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF364,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Enchanted Mist          Notting Hill          Royal Garden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,"Wall:","3\" x 6\"",null,"Field",null,null,"Gloss",null,null,null,null,null,"5.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA368,AG368)","v":15.7},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA368*(1-W368)+0.004999,2)","v":15.7},null,"",15.7,{"$f":"+W368","v":0},{"$f":"+X368","v":15.7},{"$f":"(AG368-AC368)/AG368","v":0},null,1,{"$f":"SUM(AJ368:AL368)+AE368","v":15.7},null,null,{"$f":"ROUND(AC368/(1-VLOOKUP(AF368,Group,2,FALSE)),2)","v":15.7},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Glass & Trim",null,null,"1\" x 6\"",null,"Bullnose",null,null,"Gloss",null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA370,AG370)","v":11.6},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA370*(1-W370)+0.004999,2)","v":11.6},null,"",11.6,{"$f":"+W370","v":0},{"$f":"+X370","v":11.6},{"$f":"(AG370-AC370)/AG370","v":0},null,2,{"$f":"SUM(AJ370:AL370)+AE370","v":11.6},null,null,{"$f":"ROUND(AC370/(1-VLOOKUP(AF370,Group,2,FALSE)),2)","v":11.6},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Note:","a) Stocked in color Covent Gardens 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,"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,"SIMPLE STONE - Glass Mosaics",null,null,null,null,null,null,null," "," "," ",null,null,null,null,"Item # Lookup:","LUSS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Bianco          Nero          Oro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"12.24\" x 11.02\"",null,"Mosaic",null,"Chevron",null,null,"(Mesh-Mounted)",null,null,null,"0.93 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA378,AG378)","v":27.7},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA378*(1-W378)+0.004999,2)","v":27.7},null,"",27.7,{"$f":"+W378","v":0},27.7,{"$f":"(AG378-AC378)/AG378","v":0},null,2,{"$f":"SUM(AJ378:AL378)+AE378","v":27.7},null,null,{"$f":"ROUND(AC378/(1-VLOOKUP(AF378,Group,2,FALSE)),2)","v":27.7},{"$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,"Glass & Trim",null,null,"12.13\" x 12.13\"",null,"Mosaic",null,"Pebble",null,null,"(Mesh-Mounted)",null,null,null,"1.02 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA379,AG379)","v":27.7},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA379*(1-W379)+0.004999,2)","v":27.7},null,"",27.7,0,27.7,{"$f":"(AG379-AC379)/AG379","v":0},null,2,{"$f":"SUM(AJ379:AL379)+AE379","v":27.7},null,null,{"$f":"ROUND(AC379/(1-VLOOKUP(AF379,Group,2,FALSE)),2)","v":27.7},{"$f":"IF(VLOOKUP(AF379,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ379,1)-AJ379,2),Round,2,FALSE)+VLOOKUP(AF379,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF379,Group,7,FALSE)=\"\",0,ROUND(AJ379-0.04999,1)-AJ379+AM379)","v":0},{"$f":"IF(VLOOKUP(AF379,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF379,Group,7,FALSE))","v":""},null,"X"]
[null,"Glass & Trim",null,null,"12.32\" x 11.42\"",null,"Mosaic",null,"Pennyround",null,null,"(Mesh-Mounted)",null,null,null,"0.97 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA380,AG380)","v":27.7},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA380*(1-W380)+0.004999,2)","v":27.7},null,"",27.7,0,27.7,{"$f":"(AG380-AC380)/AG380","v":0},null,2,{"$f":"SUM(AJ380:AL380)+AE380","v":27.7},null,null,{"$f":"ROUND(AC380/(1-VLOOKUP(AF380,Group,2,FALSE)),2)","v":27.7},{"$f":"IF(VLOOKUP(AF380,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ380,1)-AJ380,2),Round,2,FALSE)+VLOOKUP(AF380,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF380,Group,7,FALSE)=\"\",0,ROUND(AJ380-0.04999,1)-AJ380+AM380)","v":0},{"$f":"IF(VLOOKUP(AF380,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF380,Group,7,FALSE))","v":""},null,"X"]
[null,"Glass & Trim",null,null,"9.90\" x 12.91\"",null,"Mosaic",null,"Triangle",null,null,"(Mesh-Mounted)",null,null,null,"0.89 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA381,AG381)","v":29.35},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA381*(1-W381)+0.004999,2)","v":29.35},null,"",29.35,0,29.35,{"$f":"(AG381-AC381)/AG381","v":0},null,2,{"$f":"SUM(AJ381:AL381)+AE381","v":29.35},null,null,{"$f":"ROUND(AC381/(1-VLOOKUP(AF381,Group,2,FALSE)),2)","v":29.35},{"$f":"IF(VLOOKUP(AF381,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ381,1)-AJ381,2),Round,2,FALSE)+VLOOKUP(AF381,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF381,Group,7,FALSE)=\"\",0,ROUND(AJ381-0.04999,1)-AJ381+AM381)","v":0},{"$f":"IF(VLOOKUP(AF381,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF381,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"URBAN TEXTURES CONTEMPO - Glass Wall Tile & Mosaics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUUC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","UTC01 Bright White",null,null,null," UTC04 Ash",null,null,"UTC07 Bottle",null,null,null,null,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,"UTC02 Ivory",null,null,null," UTC05 Gray",null,null,"UTC08 Sky Blue",null,null,null," ",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,"UTC03 Beige",null,null,null," UTC06 Graphite",null,null,"UTC09 Smoke",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"3\" x 6\"",null,"Field",null,null,"(8 PCS/SF)",null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA389,AG389)","v":1.9},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA389*(1-W389)+0.004999,2)","v":1.9},null,"",1.9,{"$f":"+W389","v":0},{"$f":"+X389","v":1.9},{"$f":"(AG389-AC389)/AG389","v":0},null,2,{"$f":"SUM(AJ389:AL389)+AE389","v":1.9},null,null,{"$f":"ROUND(AC389/(1-VLOOKUP(AF389,Group,2,FALSE)),2)","v":1.9},{"$f":"IF(VLOOKUP(AF389,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ389,1)-AJ389,2),Round,2,FALSE)+VLOOKUP(AF389,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF389,Group,7,FALSE)=\"\",0,ROUND(AJ389-0.04999,1)-AJ389+AM389)","v":0},{"$f":"IF(VLOOKUP(AF389,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF389,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Glass & Trim",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 4\" Brick",null,null,"(Mesh-Mounted)",null,null,null,"1.00 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA391,AG391)","v":13.25},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA391*(1-W391)+0.004999,2)","v":13.25},null,"",13.25,{"$f":"+W391","v":0},{"$f":"+X391","v":13.25},{"$f":"(AG391-AC391)/AG391","v":0},null,2,{"$f":"SUM(AJ391:AL391)+AE391","v":13.25},null,null,{"$f":"ROUND(AC391/(1-VLOOKUP(AF391,Group,2,FALSE)),2)","v":13.25},{"$f":"IF(VLOOKUP(AF391,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ391,1)-AJ391,2),Round,2,FALSE)+VLOOKUP(AF391,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF391,Group,7,FALSE)=\"\",0,ROUND(AJ391-0.04999,1)-AJ391+AM391)","v":0},{"$f":"IF(VLOOKUP(AF391,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF391,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","Use Non-sanded grout only.  Acceptable grouts would be Laticrete PermaColor Select NS Base Unsanded Grout,",null,null,null,null,null,null,null,null,null,null,null,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,"SpectraLock or their 1600 Series Unsanded grout.",null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"ZELLIGE CLASSIQUE - Glazed Terracotta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LUZC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Al Hamra",null,"Blue City",null,"           Lambswool             Sahara Rose",null,null,null,null,null,null,null,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,"Atlas White",null,"Gris Perle",null,"           Mint Tea",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"4\" x 4\"",null,"Field",null,null,null,null,null,null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA401,AG401)","v":33.549999999999997},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA401*(1-W401)+0.004999,2)","v":33.549999999999997},null,"",33.549999999999997,{"$f":"+W401","v":0},{"$f":"+X401","v":33.549999999999997},{"$f":"(AG401-AC401)/AG401","v":0},null,1,{"$f":"SUM(AJ401:AL401)+AE401","v":33.549999999999997},null,null,{"$f":"ROUND(AC401/(1-VLOOKUP(AF401,Group,2,FALSE)),2)","v":33.549999999999997},{"$f":"IF(VLOOKUP(AF401,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ401,1)-AJ401,2),Round,2,FALSE)+VLOOKUP(AF401,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF401,Group,7,FALSE)=\"\",0,ROUND(AJ401-0.04999,1)-AJ401+AM401)","v":0},{"$f":"IF(VLOOKUP(AF401,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF401,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"2\" x 6\"",null,"Field",null,null,null,null,null,null,null,null,"8.07 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA402,AG402)","v":34.200000000000003},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA402*(1-W402)+0.004999,2)","v":34.200000000000003},null,"",34.200000000000003,{"$f":"+W402","v":0},{"$f":"+X402","v":34.200000000000003},{"$f":"(AG402-AC402)/AG402","v":0},null,1,{"$f":"SUM(AJ402:AL402)+AE402","v":34.200000000000003},null,null,{"$f":"ROUND(AC402/(1-VLOOKUP(AF402,Group,2,FALSE)),2)","v":34.200000000000003},{"$f":"IF(VLOOKUP(AF402,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ402,1)-AJ402,2),Round,2,FALSE)+VLOOKUP(AF402,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF402,Group,7,FALSE)=\"\",0,ROUND(AJ402-0.04999,1)-AJ402+AM402)","v":0},{"$f":"IF(VLOOKUP(AF402,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF402,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Glass & Trim",null,null,"11-1/4\" x 11-1/4\"",null,"Mosaic",null,null,"Art",null,"(Atlas White)",null,null,null,"0.88 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA404,AG404)","v":55.9},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA404*(1-W404)+0.004999,2)","v":55.9},null,"",55.9,{"$f":"+W404","v":0},55.9,{"$f":"(AG404-AC404)/AG404","v":0},null,2,{"$f":"SUM(AJ404:AL404)+AE404","v":55.9},null,null,{"$f":"ROUND(AC404/(1-VLOOKUP(AF404,Group,2,FALSE)),2)","v":55.9},{"$f":"IF(VLOOKUP(AF404,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ404,1)-AJ404,2),Round,2,FALSE)+VLOOKUP(AF404,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF404,Group,7,FALSE)=\"\",0,ROUND(AJ404-0.04999,1)-AJ404+AM404)","v":0},{"$f":"IF(VLOOKUP(AF404,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF404,Group,7,FALSE))","v":""},null,"X"]
[null,"Glass & Trim",null,null,"13-1/4\" x 14-1/4\"",null,"Mosaic",null,null,"Chouari",null,"(Atlas White/Blanc/Gris Perle)",null,null,null,"1.31 SF/Sheet",null,null,56,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},56,null,"",56,0,56,0,null,2,56,null,null,56,0,0,"",null,"X"]
[null,"Glass & Trim",null,null,"10-1/2\" x 10\"",null,"Mosaic",null,null,"Papillon",null,"(Al Hamra)",null,null,null,"0.73 SF/Sheet",null,null,84.25,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},84.25,null,"",84.25,0,84.25,0,null,2,84.25,null,null,84.25,0,0,"",null,"X"]
[null,"Glass & Trim",null,null,"11-13/16\" x 11-13/16\"",null,"Mosaic",null,null,"Star & Cross",null,"(Atlas White/Lambswool)",null,null,null,"0.97 SF/Sheet",null,null,84.8,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},84.8,null,"",84.8,0,84.8,0,null,2,84.8,null,null,84.8,0,0,"",null,"X"]
[null,"Glass & Trim",null,null,"10\" x 10\"",null,"Mosaic",null,null,"Starburst",null,"(Atlas White)",null,null,null,"0.69 SF/Sheet",null,null,84.15,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},84.15,null,"",84.15,0,84.15,0,null,2,84.15,null,null,84.15,0,0,"",null,"X"]
[null,"Glass & Trim",null,null,"12\" x 12\"",null,"Mosaic",null,null,"Tapis",null,"(Atlas White/Sahara Rose)",null,null,null,"1.00 SF/Sheet",null,null,55.9,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},55.9,null,"",55.9,0,55.9,0,null,2,55.9,null,null,55.9,0,0,"",null,"X"]
[null,"Glass & Trim",null,null,"9\" x 11-3/4\"",null,"Mosaic",null,null,"Triangle",null,"(Atlas White)",null,null,null,"0.73 SF/Sheet",null,null,84.4,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},84.4,null,"",84.4,0,84.4,0,null,2,84.4,null,null,84.4,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"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,null,null,null,null,null,null,null,null," "]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"," "]
[]
["ConestogaTile's Website","https://www.conestogatile.com/"]
[]
["Manufacturer's Home Page","http://www.lungarnoceramics.com/"]
[]
[]
["Product","Direct Website Link"]
["Artisan","https://style-access.com/artisan/"]
["Back to Basics","https://style-access.com/back-to-basics/"]
["Beat","https://style-access.com/beat/"]
["Botanicals","https://style-access.com/botanicals/"]
["Carrollton","https://style-access.com/carrollton-2/"]
["Casablanca","https://style-access.com/casablanca/"]
["Classics 2.0","https://style-access.com/classics-ii/"]
["Coastline","https://style-access.com/coastline/"]
["Disk","https://style-access.com/disk/"]
["Durstone","https://style-access.com/durstone/"]
["Elements","https://style-access.com/elements/"]
["Finish Line","https://style-access.com/finish-line/"]
["Jolly"]
["Linea","https://style-access.com/linea/"]
["London Metro","https://style-access.com/london-metro/"]
["Marrakesh","https://style-access.com/marrakesh/"]
["Massa Marble","https://style-access.com/massa-marble/"]
["Melody","https://style-access.com/melody/"]
["MidMod","https://style-access.com/midmod/"]
["Multiforma","https://style-access.com/multiforma-3/"]
["Natural Elements","https://style-access.com/natural-elements/"]
["Northern Lights","https://style-access.com/northern-lights/"]
["Organic Strands","https://style-access.com/organic-strands/"]
["Pure","https://style-access.com/pure-2/"]
["Retrospectives","https://style-access.com/retrospectives/",null,null,null,null," "]
["Simple Stone","https://style-access.com/simple-stone/"]
["Urban Textures Contempo","https://style-access.com/urban-texture-contempo/"]
["Zellige Classique","https://style-access.com/zellige-classique/"]

{"sheet":"Changes","index":4,"n_rows":217,"n_cols":4,"rows_kept":217,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[null," "]
["New Products"]
[]
["2014-04-01","BRIDGES","Glass & Stone Wall Mosaics"]
["2014-04-01","COUNTRY CLUB","Glazed Porcelain"]
["2014-04-01","EPIC","Rectified Unglazed Porcelain"]
["2014-04-01","FINISH LINE","Rectified Unglazed Porcelain"]
["2014-04-01","GYPSEA","Glass Wall Mosaics"]
["2014-04-01","MATISSE","Glazed Porcelain"]
["2014-04-01","PICASSO","Rectified Glazed Porcelain"]
["2014-04-01","RIALTO","Glass Wall Mosaics"]
["2014-04-01","SHABBYWOOD","Rectified Glazed Porcelain"]
["2014-04-01","SLATE MEDLEY","Slate & Glass Mosaics"]
["2014-04-01","STONE MEDLEY","Stone & Glass Mosaics"]
["2014-04-01","TUNDRA","Glass & Marble Wall Mosaics"]
["2014-04-01","URBAN TEXTURES","Glass Wall Mosaics"]
["2014-10-23","Bayou","Glazed Porcelain"]
["2014-10-23","Camelia","Glazed Porcelain"]
["2014-10-23","Coastal","Glazed Porcelain"]
["2014-10-23","Laguna","Glazed Porcelain"]
["2014-10-23","Marble Medley","Stone Mosaics"]
["2014-10-23","Metalbax","Glazed Porcelain"]
["2014-10-23","Shiro","Glazed Porcelain"]
["2014-10-23","Titan","Unglazed Porcelain"]
["2014-10-23","Urban Textures","Glazed Ceramic Wall"]
["2015-10-15","Carrara","Glazed Porcelain"]
["2015-10-15","Rhone","Glazed Porcelain"]
["2015-10-15","Urban Classics","Glazed Ceramic Wall"]
["2015-10-15","Urban Textures (Glass)","2\" x 12\" Field Tile, 3/4\" x 12\" Pencils Mosaic, 2\" x 10\" Chevron Listello and 2\" x 4\" Brick Joint Mosaic added. "]
["2015-10-15","Urban Textures (Ceramic)","4\" x 16\" Field Tile and 4\" x 16\" Bullnose available with 4\" Edge or 16\" Edge added to all colors. "]
["2015-10-15","Urban Textures (Porcelain)","Glazed Porcelain Mosaics"]
["2015-10-15","Bristol Studios Design - Brushstrokes","Glazed Ceramic Wall Mosaics"]
["2015-10-15","Bristol Studios Design - Cosmic","Glazed Ceramic Wall & Mosaics"]
["2015-10-15","Bristol Studios Design - Dots and Decos","Glazed Ceramic Wall Mosaics"]
["2015-10-15","Bristol Studios Design - Lumiere","Glass Wall Mosaics"]
["2015-10-15","Bristol Studios Design - Midnight Mosaic","Glazed Ceramic Wall Mosaics"]
["2015-10-15","Bristol Studios Design - Pure White","Glazed Ceramic Wall"]
["2015-10-15","Bristol Studios Design - Sculpted","Glazed Ceramic Wall"]
["2015-10-15","Bristol Studios Design - Truly Solid Glass","Glass Mosaics"]
["2016-05-24","Artisan","Glass Wall Mosaics"]
["2016-05-24","Disk","Glazed Porcelain"]
["2016-05-24","Finish Line (Unglazed Porcelain)","Color Nautica White added."]
["2016-05-24","Finish Line","Glazed Ceramic Wall"]
["2016-05-24","Finish Line","Mosaics"]
["2016-05-24","Natural Elements","Stone & Glass Wall Mosaics"]
["2016-05-24","Rainstone","Glazed Porcelain"]
["2016-05-24","Stoneway","Glazed Porcelain"]
["2016-05-24","Urban Textures Contempo","Thin Format Glass Wall Tile & Mosaics"]
["2017-05-30","Finish Line (Mosaics)","Glazed Porcelain Multi-Mosaic pattern added in color Black and color White only."]
["2017-05-30","Metallic Mosaics","Glazed Porcelain Wall Mosaics."]
["2017-05-30","Notting Hill","Glazed Ceramic Wall."]
["2017-05-30","Organic Strands","Glazed Porcelain."]
["2017-05-30","Truly Solid Glass","Colors Chocolate, Dusk, Fawn, Latte and Mocha added. "]
["2017-05-30","Urban Textures (Glazed Ceramic Wall)","Color UT1014 Cool Gray Glossy added.  2\" x 8\" & 3\" x 6\" Field Tile and other Trim formats added to select colors."]
["2017-05-30","Urban Textures (Porcelain Mosaics)","Color Cool Gray Matte added.  1\" x 1\" Mosaics added and are available in select colors.  2\" x 2\" Format and five Trim Formats added and are available in colors Cool Gray Matte, Ivory Matte and White Matte only."]
["2017-10-23","Retrospectives (formally known as Notting Hill)","Two colors, Enchanted White and Royal Garden have been added to this series that was originally known as Notting Hill."]
["2018-01-31","Silk Origins","Glazed Ceramic Wall"]
["2018-01-31","Urban Textures (Glazed Ceramic Wall)","3\" x 6 \" Field Tile, S4639 Bullnose - (3\" Edge) and S4369 Bullnose - (6\" Edge) now available in color UT1003 White Matte. "]
["2018-06-28","Classics","Rectified Glazed Porcelain."]
["2018-06-28","Finish Line (Glazed Ceramic Wall)","Colors Flint, Silken Gray and Vanilla added and are available in the 3\" x 12\" Field (Undulated) and 1/2\" x 12\" Quarter Round Pencil formats."]
["2018-06-28","Organic Strands","2\" Lantern Mosaic added and is available in all colors."]
["2018-06-28","Pure","Rectified Glazed Porcelain."]
["2018-06-28","Retrospectives","8\" x 8\" Field Tile added and is available in colors Covent Gardens, Notting Hill and Royal Blues."]
["2019-06-28","Anchor","Glazed Porcelain."]
["2019-06-28","Classics","Color Venetian Gray added.  2\" Hexagon Mosaic added to all colors in the Matte finish only."]
["2019-06-28","Coastline","Glass Wall Mosaics."]
["2019-06-28","Finish Line (Mosaics)","Penny Round Mosaic Colors added:  Flint (Matte), Silken (Matte) & Vanilla (Matte). "]
["2019-06-28","Impressions","Glazed Porcelain."]
["2019-06-28","Pure","24\" x 48\" format added."]
["2019-06-28","Sicily","Glazed Porcelain."]
["2019-06-28","Simple Stone","Glass Mosaics."]
["2020-04-08","Carrollton","Glazed Ceramic Wall.  (Similar to the Discontinued Urban Textures Glazed Ceramic Wall Series.)"]
["2020-04-08","Massa Carrara","Glazed Porcelain Floor & Undulated Glazed Ceramic Wall"]
["2020-04-08","Seasons","Glazed Porcelain Floor & Undulated Glazed Ceramic Wall."]
["2020-05-26","Pure","12\" x 24\" and 24\" x 24\" Matte finish Field Tile formats added."]
["2020-09-11","Carrollton","2\" x 8\" Glazed Ceramic Wall tile format added to colors Biscuit Gloss, Gray Gloss and White Gloss only."]
["2020-09-11","Massa Carrara","32\" x 32\" Glazed Porcelain Floor tile format added."]
["2021-01-18","Carrollton","24\" x 24\" and 9\" x 10\" Hexagon Glazed Porcelain Matte Floor tile formats added and are available in all colors."]
["2021-01-18","Casablanca","Glazed Porcelain Floor & Glazed Ceramic Wall."]
["2021-01-18","Elements","Unglazed Full Body Porcelain Mosaics."]
["2021-01-18","Linea","Glazed Ceramic Wall."]
["2021-01-18","London Metro","Glazed Ceramic Wall."]
["2021-01-18","Marrakesh","Glazed Porcelain Floor & Glazed Ceramic Wall."]
["2021-01-18","Massa Carrara (Now known as Massa Marble)","Series now known as \"Massa Marble\".  Color Calacatta Oro added and is available in all formats."]
["2021-01-18","Northern Lights","Glass Mosaics."]
["2021-01-18","Simple Stone","Triangle Mosaic added and is available in all colors."]
["2021-06-09","Carrollton","Glazed Porcelain Mosaics added to line."]
["2022-05-25","Disk","36\" x 36\" Rectified Field Tile format added."]
["2022-05-25","Jolly","Ceramic Wall Universal Jolly available in colors Charcoal Gloss, Light Grey Gloss, White Gloss and White Matte."]
["2022-05-25","Multiforma","Glazed Porcelatin 36\" x 36\" Rectified Field Tile."]
["2022-05-25","Original Wall","Glazed Ceramic Wall."]
["2022-05-25","Royal","Glazed Porcelatin 36\" x 36\" Rectified Field Tile."]
["2022-10-12","Original Wall","3\" x 6\", 3\" x 12\" and 4\" x 16\" Field Tile formats added and a 3\" x 6\" Bullnose - (3\" Edge) format added."]
["2023-03-06","Botanicals","Pressed Glass Mosaics."]
["2023-03-06","Carrollton (Wall)","3\" x 6\" Bullnose - (3\" Edge), 4\" x 12\" Bullnose - (4\" Edge) and 4\" x 16\" Bullnose - (4\" Edge) in all colors are once again available."]
["2023-03-06","Classics 2.0","Rectified Glazed Porcelain."]
["2023-03-06","Durstone","Rectified Glazed Porcelain."]
["2023-03-06","Melody","Glazed Ceramic Wall."]
["2023-03-06","Pure","Rectified Glazed Porcelain.  Back now after being transitioned to a new factory with the color Black added to select formats."]
["2023-03-06","Simple Stone","Pebble Mosaic format added and is available in all colors."]
["2023-07-10","Zellige Classique","Glazed Terracotta."]
["2023-09-27","Carrollton (Wall)","4\" x 12\" Bullnose - (4\" Edge) is available again in colors White Gloss and White Matte."]
["2024-05-29","Back To Basics","Glazed Ceramic 2\" x 10\" subway tiles in 11 colors."]
["2024-05-29","Beat","Glazed Ceramic 2\" x 8\" 3D subway tiles in 6 colors with 4 shapes each."]
["2024-05-29","Carrollton","Glazed Ceramic 3\" x 12\" Field Tile format added and is available in color White Gloss only."]
["2024-05-29","MidMod","Glazed Porcelain 1\" x 6\" Bars Mosaic and 1-1/4\" Disks Mosaic."]
[]
[]
[]
["Discontinued Products"]
[]
["2014-10-23","Country Club","Entire Series."]
["2016-05-24","Bridges","Entire Series."]
["2016-05-24","Cosmic","Colors Comet, Milky Way and Venus in all formats.  4\" x 4\" Field Tile, 2\" x 4\" Chair Rail and 0.6\" x 4\" Quarter Round in all colors. "]
["2016-05-24","Dots And Decos","Entire Series."]
["2016-05-24","Epic","Entire Series."]
["2016-05-24","Lumiere","Entire Series."]
["2016-05-24","Pure White","Entire Series."]
["2016-05-24","Rialto","Entire Series."]
["2016-05-24","Sculpted","Entire Series."]
["2016-05-24","Truly Solid Glass","Colors Chocolate, Dusk, Fawn, Latte and Mocha in all formats."]
["2016-10-18","Matisse","Entire Series."]
["2016-10-18","Metalbax","Entire Series."]
["2016-10-18","Titan","Entire Series."]
["2016-10-18","Tundra","Entire Series."]
["2016-10-18","Urban Textures (Porcelain)","1\" x 1\" Glazed Porcelain Mosaics only in all colors."]
["2017-05-30","Urban Textures (Glass Wall Tile & Mosaics)","2\" x 4\" Brick Joint (Interlocking) Mosaics in all colors; UT1101 White, UT1102 Ivory, UT1105 Gray, UT1107 Beige and UT1111 Graphite."]
["2017-09-28","Truly Solid Glass","Colors Chocolate, Dusk, Fawn, Latte and Mocha only in all formats."]
["2017-11-08","Picasso","6\" x 24\" Field Tile format only in all colors."]
["2017-12-20","Camelia","Entire Series."]
["2017-12-20","Coastal","Entire Series."]
["2017-12-20","Cosmic","Entire Series."]
["2017-12-20","Marble Medley","Color L05 Nero Marquina in all formats."]
["2017-12-20","Picasso","Colors LC02 Bisque, LC05 Adobe & LC06 Chestnut in all formats.  24\" x 24\" Field Tile & Random Linear Mosaic formats in all colors."]
["2017-12-20","Shiro","Entire Series."]
["2018-02-22","Midnight Mosaic","Entire Series."]
["2018-02-22","Rhone","9.6\" x 11\" Hexagon Field in color Lyon only."]
["2018-02-22","Truly Solid Glass","Entire Series."]
["2018-02-22","Urban Textures (Glass Wall Tile & Mosaics (Mesh-Mounted)","1\" x 1\" Mosaic format in all colors. "]
["2018-02-22","Urban Textures (Glazed Porcelain Mosaics)","1\" x 1\" Mosaic format in all colors."]
["2018-06-05","Finish Line (Rectified Unglazed Porcelain)","12\" x 12\" Field Tile format in all colors and finishes."]
["2018-06-28","Brushstrokes (BRISTOL STUDIOS DESIGN by Lungarno)","Entire Series."]
["2018-06-28","Finish Line (Rectified Unglazed Porcelain)","Color Nautica White in all formats."]
["2018-06-28","Rhone","Entire Series."]
["2018-11-07","Bayou","Entire Series."]
["2018-11-07","Laguna","Entire Series."]
["2019-06-28","Metallic Mosaics","Entire Series."]
["2019-06-28","Shabbywood","Entire Series."]
["2019-09-12","Urban Textures (Glazed Ceramic Wall)","2\" x 8\" Field Tile, S4829 2\" x 8\" Bullnose (2\" Edge) & S4289 2\" x 8\" Bullnose (8\" Edge) formats in all colors. (Colors UT1001 White Glossy, UT1002 Ivory Glossy & UT1014 Cool Gray Glossy.)"]
["2020-02-04","Carrara","Entire Series."]
["2020-02-04","Silk Origins","Entire Series."]
["2020-04-08","Finish Line - Glazed Ceramic Wall","7\" x 8\" Hexagon Undulated Field Tile format in all colors."]
["2020-04-08","Finish Line - Mosaics","Glass & Stone 1\" x 4\" Stacked Press Blend Mosaic in all colors."]
["2020-04-08","Finish Line - Rectified Unglazed Porcelain","Entire Series."]
["2020-04-08","Marble Medley","Entire Series."]
["2020-04-08","Picasso","Entire Series."]
["2020-04-08","Slate Medley","Entire Series."]
["2020-04-08","Stone Medley","Entire Series."]
["2020-04-08","Urban Classics","All Bullnose formats in all colors and the 10\" x 12\" Matte Cube Mosaic in all colors."]
["2020-04-08","Urban Textures - Glass Wall Tile & Mosaics","Entire Series."]
["2020-04-08","Urban Textures - Glazed Ceramic Wall","Entire Series.  (For similar items please see the new Carrollton Series.)"]
["2020-05-26","Finish Line - Mosaics","Glazed Porcelain Multi Mosaic in all colors."]
["2020-05-26","Urban Classics","3\" x 6\" Field Tile format in all colors."]
["2020-05-26","Urban Textures (Glazed Porcelain Mosaics)","All 2\" x 2\" Trim formats in all colors:  S886 Bullnose, SC886 Bullnose Corner, S832 Stretcher, C833 Cove Base and SC813 Cove Base Outside Corner."]
["2021-01-04","Gypsea","Entire Series.","(Discontinued by Lungarno)"]
["2021-06-02","Finish Line - Mosaics","Glass & Stone 1\" x 4\" Stacked Press Blend Mosaic in all colors."]
["2022-01-07","Urban Textures - Glazed Porcelain Mosaics","Entire Series.  (For similar items please see the new Carrollton Series.)"]
["2022-05-25","Anchor","Entire Series.","Being transitioned to new factories."]
["2022-05-25","Classics","Entire Series.","Being transitioned to new factories."]
["2022-05-25","Impressions","Entire Series.","Being transitioned to new factories."]
["2022-05-25","Linea","1/2\" x 12\" Jolly in colors Ghiaccio Glossy and Ghiaccio Matte only."]
["2022-05-25","Pure","Entire Series.","Being transitioned to new factories."]
["2022-05-25","Sicily","Entire Series.","Being transitioned to new factories."]
["2022-05-25","Urban Classics","Entire Series.","(Discontinued by Lungarno)"]
["2022-06-23","Finish Line (Glazed Ceramic Wall)","Entire Series. (3\" x 12\" Glossy Field (Undulated) and the 1/2\" x 12\" Glossy Quarter Round Pencil formats in all colors.)","(Discontinued by Lungarno)"]
["2022-10-12","Carrollton (Wall)","3\" x 6\" Bullnose - (3\" Edge) in color White Gloss only.","(Discontinued by Lungarno)"]
["2022-10-12","Finish Line (Rectified Glazed Porcelain)","Color Black Forest in all formats and finishes only.","(Discontinued by Lungarno)"]
["2022-10-17","Carrollton (Wall)","3\" x 6\" Bullnose - (3\" Edge), 4\" x 12\" Bullnose - (4\" Edge) and 4\" x 16\" Bullnose - (4\" Edge) in all colors.  All bullnose formats in color Gray Gloss only.","(Discontinued by Lungarno)"]
["2023-03-06","Nuance","Entire Series.","(Discontinued by Lungarno)"]
["2023-03-06","Original Wall","3\" x 6\" Field Tile and 3\" x 6\" Bullnose formats only in all colors.","(Discontinued by Lungarno)"]
["2023-07-10","Carrollton (Wall)","4\" x 12\" Bullnose - (4\" Edge) and 4\" x 16\" Bullnose - (4\" Edge) only in all colors.","(Discontinued by Lungarno)"]
["2023-07-10","Finish Line (Rectified Glazed Porcelain)","Color Alpine White in all formats and finishes only.","(Discontinued by Lungarno)"]
["2023-07-10","Finish Line (Mosaics)","Obsidian Metallic and Pearl Metallic 2\" Hexagon Mosaics only.","(Discontinued by Lungarno)"]
["2023-07-10","Massa Marble","32\" x 32\" Field Tile format only in all colors.","(Discontinued by Lungarno)"]
["2023-07-10","Organic Strands","12\" x 24\" Field Tile format in colors Ivory and Light Grey only.","(Discontinued by Lungarno)"]
["2023-07-10","Rainstone","Entire Series.","(Discontinued by Lungarno)"]
["2023-07-10","Seasons","4\" x 4\" Equinox Deco in color Winter only.  1/2\" x 12\" Jolly format in colors Spring and Summer only.","(Discontinued by Lungarno)"]
["2023-09-27","Carrollton (Floor)","24\" x 24\" Field Tile format only in all colors.","(Discontinued by Lungarno)"]
["2023-09-27","Organic Strands","12\" x 24\" and 24\" x 24\" Field Tile formats only in all colors.","(Discontinued by Lungarno)"]
["2023-09-27","Original Wall","4\" x 12\" and 4\" x 16\" Field Tile formats and 4\" x 12\" Bullnose only in all colors.","(Discontinued by Lungarno)"]
["2023-09-27","Seasons","8\" x 8\" Eclipse Field Tile only.","(Discontinued by Lungarno)"]
["2024-05-13","Seasons","Entire Series.","(Discontinued by Lungarno)"]
["2024-05-13","Stoneway","Entire Series.","(Discontinued by Lungarno)"]
["2024-05-15","Stone Reserve","Entire Series.","(Discontinued by Lungarno)"]
["2024-12-09","Finish Line - Glazed Porcelain Mosaics","Penny Round Mosaic in colors Flint (Matte), Silken Gray (Matte) and Vanilla (Matte) only.","(Discontinued by Lungarno)"]
["2024-12-09","Massa Marble","3\" x 6\"and 6\" x 6\" Field Tile, and 3\" x 6\" Bullnose formats only in all colors.","(Discontinued by Lungarno)"]
["2024-12-09","Royal","Entire Series.","(Discontinued by Lungarno)"]
["2024-12-09","Original Wall","Entire Series.","(Discontinued by Lungarno)"]
["2025-01-27","London Metro","3\" x 12\" Bullnose format only in all colors.","(Discontinued by Lungarno)"]
[]
[]
[]
["Changes"]
["2017-05-30","Urban Textures Contempo","3\" x 6\" Field Tile is now being sold by the individual piece.  (Previously was sold by the square foot, 10.00 SF/CTN.)"]
["2017-10-23","Notting Hill","This series has been renamed \"Retrospectives\".  Originally Notting Hill consisted of only one color of the same name but now colors Enchanted White and Royal Garden have been added."]
["2018-02-22","Metallic Mosaics","The Diamond and Trapezoid mosaics have been renamed from \"Bronze\" to \"Steel\".  (Change is in color name only.)"]
["2019-01-10","Retrospectives","Notified by Lungarno of a packaging correction on the 3\" x 6\" Field Tile.  There is 5.50 SF/CTN instead of 5.72 SF/CTN previously noted."]
["2019-06-21","Classics","Color name Carrara changed to Italian Carrara."]
["2020-02-04","Finish Line - Glazed Ceramic Wall","Packaging is changing in the 3\" x 12\" Field (Undulated) format from 13.00 SF/CTN to 11.00 SF/CTN as inventory with old packaging is depleted."]
["2020-05-26","Finish Line - Mosaics","The Glass & Stone 1\" x 4\" Stacked Press Blend Mosaic in all colors is still current.  (Mistakenly announced as discontinued on 4/8/20.)"]
["2020-05-26","Finish Line - Rectified Unglazed Porcelain","12\" x 24\" and 24\" x 24\" Field Tile formats and the 3\" x 12\" Bullnose format in both the Unpolished & Polished finishes are back.  These items were discontinued due to no longer being produced by manufacturer in China due to high tariffs.  Lungarno has now found a new manufacturer outside of China and production has begun once again.  All of the 3\" x 12\" Bullnose formats however will not be made at the new factory and are considered Special Order Only and Customer Service would need to be called for minimum order requirement, pricing & lead time."]
["2020-05-26","Urban Classics","Packaging is changing for the 8\" x 24\" Field Tile format from 16.00 SF/CTN to 10.67 SF/CTN as inventory with old packaging is depleted."]
["2024-09-27","Retrospectives","\"Stocked\" in the 8\" x 8\" Field Tile format in color Covent Gardens only."]
[]
[" "]