{"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":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Novabell"]
["File as","N"]
["Product Code","B"]
["CCTD Effective Date","11/1/22 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"B"}]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0]
[null,2,null,"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":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,0,5,10],[48,0,48,10],[50,0,50,10],[2,5,2,10],[3,4,3,7]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'N' - Novabell"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 11/1/22 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[1,null,"Aspen",null,"Glazed Porcelain"]
[1,null,"Brickup",null,"Glazed Porcelain"]
[1,null,"Imperial",null,"Glazed Porcelain"]
[2,null,"Materia",null,"Glazed Porcelain"]
[2,null,"Michelangelo",null,"Glazed Porcelain"]
[2,null,"Sovereign",null,"Glazed Porcelain"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":209,"n_cols":41,"rows_kept":209,"cut":false,"hidden":false,"merged":[[12,14,12,19],[198,3,198,4],[18,2,18,19],[17,14,17,15],[19,2,19,19],[194,2,194,19],[14,13,15,19],[10,14,10,15],[9,14,9,19],[9,25,9,32],[12,22,12,23],[9,22,9,23],[13,30,13,32]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA1,'Price List'!AG1)","v":0.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA1*(1-W1)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W1","v":0},0.05,{"$f":"(AG1-AC1)/AG1","v":0},null,1,{"$f":"SUM(AJ1:AL1)+AE1","v":0.05},null,null,{"$f":"ROUND(AC1/(1-VLOOKUP(AF1,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF1,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ1,1)-AJ1,2),Round,2,FALSE)+VLOOKUP(AF1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",0,ROUND(AJ1-0.04999,1)-AJ1+AM1)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF1,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA2,'Price List'!AG2)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,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,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA3,'Price List'!AG3)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,3,0.05,null,null,0.05,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA4,'Price List'!AG4)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"B"},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,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA5,'Price List'!AG5)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"B"},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,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA6,'Price List'!AG6)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"B"},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,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA7,'Price List'!AG7)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"B"},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 'N' - Novabell"},null,null,null,null,null,null,null,"Cost",null,null,null,null,null,null,null,null,null,"Retail Price Calculations",null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Instructions!B4","v":"11/1/22 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-09-15"},null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!C8=\"\",\"\",+Instructions!C8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code 'B'"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$C$8=\"\",\"\",Instructions!$C$8)","v":""},null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"+S$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,"NON-Stock ITEMS - MINIMUM 6-8 WEEK DELIVERY"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,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,"ASPEN - Glazed Porcelain",null,null,null,null,null,null,null," "," "," ",null,null,null,null,"Item # Lookup:","NVAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Basalt          Oxide          Rock Grey          Sand Moon          Snow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 12\"",null,"Field",null,null,null,null,null,null,null,null,"9.04 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA26,'Price List'!AG26)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA26*(1-W26)+0.004999,2)","v":10.85},null,"",10.85,{"$f":"+W26","v":0},10.85,{"$f":"(AG26-AC26)/AG26","v":0},null,1,{"$f":"SUM(AJ26:AL26)+AE26","v":10.85},null,null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF26,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ26,1)-AJ26,2),Round,2,FALSE)+VLOOKUP(AF26,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF26,Group,7,FALSE)=\"\",0,ROUND(AJ26-0.04999,1)-AJ26+AM26)","v":0},{"$f":"IF(VLOOKUP(AF26,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF26,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null," ",null,null,null,"13.56 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA27,'Price List'!AG27)","v":8.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.35,null,"",8.35,0,8.35,0,null,1,8.35,null,null,8.35,0,0,"",null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field - Provenzale",null,null,null,null,null,null,null,null,"9.17 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA28,'Price List'!AG28)","v":17.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},17.3,null,"",17.3,0,17.3,0,null,1,17.3,null,null,17.3,0,0,"",null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field - Struttura Grooves",null,null,null,null,null,null,null,null,"13.56 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA29,'Price List'!AG29)","v":9.0500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.0500000000000007,null,"",9.0500000000000007,0,9.0500000000000007,0,null,1,9.0500000000000007,null,null,9.0500000000000007,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA30,'Price List'!AG30)","v":8.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.9499999999999993,null,"",8.9499999999999993,0,8.9499999999999993,0,null,1,8.9499999999999993,null,null,8.9499999999999993,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA31,'Price List'!AG31)","v":10.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.1,null,"",10.1,0,10.1,0,null,1,10.1,null,null,10.1,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field - Struttura Grooves",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA32,'Price List'!AG32)","v":10.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.8,null,"",10.8,0,10.8,0,null,1,10.8,null,null,10.8,0,0,"",null,"X"]
[null,"Field Tile",null,null,"8\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"10.33 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA33,'Price List'!AG33)","v":10.199999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA33*(1-W33)+0.004999,2)","v":10.199999999999999},null,"",10.199999999999999,{"$f":"+W33","v":0},{"$f":"+X33","v":10.199999999999999},{"$f":"(AG33-AC33)/AG33","v":0},null,1,{"$f":"SUM(AJ33:AL33)+AE33","v":10.199999999999999},null,null,{"$f":"ROUND(AC33/(1-VLOOKUP(AF33,Group,2,FALSE)),2)","v":10.199999999999999},{"$f":"IF(VLOOKUP(AF33,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ33,1)-AJ33,2),Round,2,FALSE)+VLOOKUP(AF33,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",0,ROUND(AJ33-0.04999,1)-AJ33+AM33)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF33,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,"mesh-mounted",null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA35,'Price List'!AG35)","v":21.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":21.9},null,"",21.9,{"$f":"+W35","v":0},21.9,{"$f":"(AG35-AC35)/AG35","v":0},null,3,{"$f":"SUM(AJ35:AL35)+AE35","v":21.9},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":21.9},{"$f":"IF(VLOOKUP(AF35,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ35,1)-AJ35,2),Round,2,FALSE)+VLOOKUP(AF35,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",0,ROUND(AJ35-0.04999,1)-AJ35+AM35)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF35,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Pebble (Sassi)",null,null,null,null,"mesh-mounted",null,"9.68 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA36,'Price List'!AG36)","v":50.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":50.55},null,"",50.55,0,50.55,{"$f":"(AG36-AC36)/AG36","v":0},null,3,{"$f":"SUM(AJ36:AL36)+AE36","v":50.55},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":50.55},{"$f":"IF(VLOOKUP(AF36,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ36,1)-AJ36,2),Round,2,FALSE)+VLOOKUP(AF36,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF36,Group,7,FALSE)=\"\",0,ROUND(AJ36-0.04999,1)-AJ36+AM36)","v":0},{"$f":"IF(VLOOKUP(AF36,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF36,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Pebble (Sassi) - Dark Mix (O-B-RG)",null,null,null,null,"mesh-mounted",null,"9.68 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA37,'Price List'!AG37)","v":50.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":50.55},null,"",50.55,0,50.55,{"$f":"(AG37-AC37)/AG37","v":0},null,3,{"$f":"SUM(AJ37:AL37)+AE37","v":50.55},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":50.55},{"$f":"IF(VLOOKUP(AF37,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ37,1)-AJ37,2),Round,2,FALSE)+VLOOKUP(AF37,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",0,ROUND(AJ37-0.04999,1)-AJ37+AM37)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF37,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Pebble (Sassi) - Light Mix (SM-S-RG)",null,null,null,null,"mesh-mounted",null,"9.68 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA38,'Price List'!AG38)","v":50.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":50.55},null,"",50.55,0,50.55,{"$f":"(AG38-AC38)/AG38","v":0},null,3,{"$f":"SUM(AJ38:AL38)+AE38","v":50.55},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":50.55},{"$f":"IF(VLOOKUP(AF38,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ38,1)-AJ38,2),Round,2,FALSE)+VLOOKUP(AF38,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,7,FALSE)=\"\",0,ROUND(AJ38-0.04999,1)-AJ38+AM38)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF38,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 24\"",null,"Mosaic",null,"Brick (Mattoncino)",null,null,null,null,"mesh-mounted",null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA39,'Price List'!AG39)","v":29},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA39*(1-W39)+0.004999,2)","v":29},null,"",29,0,29,{"$f":"(AG39-AC39)/AG39","v":0},null,3,{"$f":"SUM(AJ39:AL39)+AE39","v":29},null,null,{"$f":"ROUND(AC39/(1-VLOOKUP(AF39,Group,2,FALSE)),2)","v":29},{"$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,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA41,'Price List'!AG41)","v":19.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA41*(1-W41)+0.004999,2)","v":19.3},null,"",19.3,{"$f":"+W41","v":0},{"$f":"+X41","v":19.3},{"$f":"(AG41-AC41)/AG41","v":0},null,2,{"$f":"SUM(AJ41:AL41)+AE41","v":19.3},null,null,{"$f":"ROUND(AC41/(1-VLOOKUP(AF41,Group,2,FALSE)),2)","v":19.3},{"$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,"Colors:","Basalt/Rock Grey",null,null," Rock Grey/Basalt",null,null,null,"         Snow/Rock Grey"]
[null,null,null,null,"Oxide/Sand Moon",null,null," Sand Moon/Rock 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,null,null,null,null,null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Basketweave (Trama)",null,null,null,null,"mesh-mounted",null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA46,'Price List'!AG46)","v":37.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA46*(1-W46)+0.004999,2)","v":37.85},null,"",37.85,{"$f":"+W46","v":0},{"$f":"+X46","v":37.85},{"$f":"(AG46-AC46)/AG46","v":0},null,3,{"$f":"SUM(AJ46:AL46)+AE46","v":37.85},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":37.85},{"$f":"IF(VLOOKUP(AF46,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ46,1)-AJ46,2),Round,2,FALSE)+VLOOKUP(AF46,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",0,ROUND(AJ46-0.04999,1)-AJ46+AM46)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF46,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 colors Rock Grey, Sand Moon and Snow 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,"BRICKUP - Glazed Porcelain - 3D Brick Ledgerstone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","NVBR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Ocean Ardesia",null,"            Ocean Grey",null,null,null,null," Ocean White"]
[null,null,null,null,"Ocean Beige",null,"            Ocean Mix Quarzite"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"6-5/16\" x 15-3/4\"",null,"Field - Ledgerstone",null,null,null,null,null,null,null,null,"10.33 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA55,'Price List'!AG55)","v":8.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA55*(1-W55)+0.004999,2)","v":8.6},null,"",8.6,{"$f":"+W55","v":0},{"$f":"+X55","v":8.6},{"$f":"(AG55-AC55)/AG55","v":0},null,1,{"$f":"SUM(AJ55:AL55)+AE55","v":8.6},null,null,{"$f":"ROUND(AC55/(1-VLOOKUP(AF55,Group,2,FALSE)),2)","v":8.6},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"6-5/16\" x 11\" x 5-1/2\"",null,"Corner",null,null,null,null,null,null,null,null,"6 EA/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA57,'Price List'!AG57)","v":59.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA57*(1-W57)+0.004999,2)","v":59.65},null,"",59.65,{"$f":"+W57","v":0},{"$f":"+X57","v":59.65},{"$f":"(AG57-AC57)/AG57","v":0},null,3,{"$f":"SUM(AJ57:AL57)+AE57","v":59.65},null,null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":59.65},{"$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,"IMPERIAL - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","NVIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Beige",null,"         Crema",null,null,"            Statuario"]
[null,null,null,null,"Calacatta Bianco",null,"         Nero Imperiale"]
[]
[null,"Field Tile",null,"Lappato:","4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"9.04 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",AA64,AG64)","v":11.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":11.95},null,"",11.95,{"$f":"+W64","v":0},11.95,{"$f":"(AG64-AC64)/AG64","v":0},null,1,{"$f":"SUM(AJ64:AL64)+AE64","v":11.95},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":11.95},{"$f":"IF(VLOOKUP(AF64,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ64,1)-AJ64,2),Round,2,FALSE)+VLOOKUP(AF64,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",0,ROUND(AJ64-0.04999,1)-AJ64+AM64)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF64,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock","a",11.95,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11.95,null,"",11.95,0,11.95,0,null,1,11.95,null,null,11.95,0,0,"",null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock","a",9.9499999999999993,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.9499999999999993,null,"",9.9499999999999993,0,9.9499999999999993,0,null,1,9.9499999999999993,null,null,9.9499999999999993,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock","b",10.95,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.95,null,"",10.95,0,10.95,0,null,1,10.95,null,null,10.95,0,0,"",null,"X"]
[null,"Field Tile",null,null,"12\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock","b",13.85,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},13.85,null,"",13.85,0,13.85,0,null,1,13.85,null,null,13.85,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN",null,null,12.95,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},12.95,null,"",12.95,0,12.95,0,null,1,12.95,null,null,12.95,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"1\" x 1\"",null,null,"mesh-mounted (0.96 SF/Sheet)",null,null,null,"10 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA71,AG71)","v":32.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":32.75},null,"",32.75,{"$f":"+W71","v":0},32.75,{"$f":"(AG71-AC71)/AG71","v":0},null,3,{"$f":"SUM(AJ71:AL71)+AE71","v":32.75},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":32.75},{"$f":"IF(VLOOKUP(AF71,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ71,1)-AJ71,2),Round,2,FALSE)+VLOOKUP(AF71,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",0,ROUND(AJ71-0.04999,1)-AJ71+AM71)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF71,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,"mesh-mounted (0.96 SF/Sheet)",null,null,null,"10 EA/CTN",null,null,21.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},21.05,null,"",21.05,0,21.05,0,null,3,21.05,null,null,21.05,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Basketweave (Intreccio)",null,null,"mesh-mounted (0.96 SF/Sheet)",null,null,null,null,"Stock","a,c",22.5,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},22.5,null,"",22.5,0,22.5,0,null,3,22.5,null,null,22.5,0,0,"",null,"X"]
[null,"Decos",null,null,"10\" x 12\"",null,"Mosaic",null,"Chevron",null,null,"mesh-mounted (0.79 SF/Sheet)",null,null,null,null,"Stock","a,c",21.45,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},21.45,null,"",21.45,0,21.45,0,null,3,21.45,null,null,21.45,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 10\"",null,"Mosaic",null,"Hexagon",null,null,"mesh-mounted (0.78 SF/Sheet)",null,null,null,null,"Stock","a,c",24.55,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},24.55,null,"",24.55,0,24.55,0,null,3,24.55,null,null,24.55,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 13\"",null,"Mosaic",null,"Provenzale",null,null,"mesh-mounted (1.04 SF/Sheet)",null,null,null,null,"Stock","a,d",32.6,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},32.6,null,"",32.6,0,32.6,0,null,3,32.6,null,null,32.6,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Spacco",null,null,"mesh-mounted (0.96 SF/Sheet)",null,null,null,"10 EA/CTN",null,null,41.75,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},41.75,null,"",41.75,0,41.75,0,null,3,41.75,null,null,41.75,0,0,"",null,"X"]
[]
[null,"Trim",null,"Lappato:","3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock","a,e",{"$f":"IF(Suggested=\"Yes\",AA79,AG79)","v":19.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA79*(1-W79)+0.004999,2)","v":19.7},null,"",19.7,{"$f":"+W79","v":0},{"$f":"+X79","v":19.7},{"$f":"(AG79-AC79)/AG79","v":0},null,2,{"$f":"SUM(AJ79:AL79)+AE79","v":19.7},null,null,{"$f":"ROUND(AC79/(1-VLOOKUP(AF79,Group,2,FALSE)),2)","v":19.7},{"$f":"IF(VLOOKUP(AF79,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ79,1)-AJ79,2),Round,2,FALSE)+VLOOKUP(AF79,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF79,Group,7,FALSE)=\"\",0,ROUND(AJ79-0.04999,1)-AJ79+AM79)","v":0},{"$f":"IF(VLOOKUP(AF79,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF79,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,"Shiny:","1\" x 12\"",null,"Liner",null,"Sigaro",null,null,null,null,null,null,"6 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA81,AG81)","v":25.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA81*(1-W81)+0.004999,2)","v":25.9},null,"",25.9,{"$f":"+W81","v":0},{"$f":"+X81","v":25.9},{"$f":"(AG81-AC81)/AG81","v":0},null,3,{"$f":"SUM(AJ81:AL81)+AE81","v":25.9},null,null,{"$f":"ROUND(AC81/(1-VLOOKUP(AF81,Group,2,FALSE)),2)","v":25.9},{"$f":"IF(VLOOKUP(AF81,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ81,1)-AJ81,2),Round,2,FALSE)+VLOOKUP(AF81,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF81,Group,7,FALSE)=\"\",0,ROUND(AJ81-0.04999,1)-AJ81+AM81)","v":0},{"$f":"IF(VLOOKUP(AF81,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF81,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","BEING DISCONTINUED - CHECK STOCK WITH CUSTOMER SERVICE."]
[null,null,null,null,"a) Not stocked in color Nero Imperiale.",null,null,null,null,"d) Color Nero Imperiale must be purchased in full cartons of 5 EA/CTN only."]
[null,null,null,null,"b) Stocked in color Calacatta Bianco only.",null,null,null,null,"e) Color Nero Imperiale must be purchased in full cartons of 15 EA/CTN only."]
[null,null,null,null,"c) Color Nero Imperiale must be purchased in full cartons of 10 EA/CTN 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,null,null,"X"]
[null,null,"MATERIA - Glazed Porcelain",null,null,null,null,null,null,"DISCONTINUED 9/15/23",null,null,null,null,null,null,null,"Item # Lookup:","NVMA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Blue","Ghiaccio",null,null,"         Mud",null,"         Rosso"]
[null,null,null,null,"Chiaro","Grigio",null,null,"         Rosato"]
[]
[null,"Field Tile",null,null,"2-3/8\" x 10\"",null,"Field",null,null,null,null,null,null,null,null,"5.49 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA93,'Price List'!AG93)","v":9.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA93*(1-W93)+0.004999,2)","v":9.5},null,"",9.5,{"$f":"+W93","v":0},{"$f":"+X93","v":9.5},{"$f":"(AG93-AC93)/AG93","v":0},null,1,{"$f":"SUM(AJ93:AL93)+AE93","v":9.5},null,null,{"$f":"ROUND(AC93/(1-VLOOKUP(AF93,Group,2,FALSE)),2)","v":9.5},{"$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,"6\" x 6\"",null,"Field",null,null,null,null,null,null,null,null,"8.26 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA94,'Price List'!AG94)","v":7.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA94*(1-W94)+0.004999,2)","v":7.7},null,"",7.7,{"$f":"+W94","v":0},{"$f":"+X94","v":7.7},{"$f":"(AG94-AC94)/AG94","v":0},null,1,{"$f":"SUM(AJ94:AL94)+AE94","v":7.7},null,null,{"$f":"ROUND(AC94/(1-VLOOKUP(AF94,Group,2,FALSE)),2)","v":7.7},{"$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,"Field Tile",null,null,"6\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"8.26 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA95,'Price List'!AG95)","v":7.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.7,null,"",7.7,0,7.7,0,null,1,7.7,null,null,7.7,0,0,"",null,"X"]
[null,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"13.73 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA96,'Price List'!AG96)","v":7.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.75,null,"",7.75,0,7.75,0,null,1,7.75,null,null,7.75,0,0,"",null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"13.77 SF/CTN",null,"b,c",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA97,'Price List'!AG97)","v":7.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.7,null,"",7.7,0,7.7,0,null,1,7.7,null,null,7.7,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.84 SF/CTN",null,"b,c,d",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA98,'Price List'!AG98)","v":8.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.6,null,"",8.6,0,8.6,0,null,1,8.6,null,null,8.6,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,"mesh-mounted",null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA100,'Price List'!AG100)","v":22.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA100*(1-W100)+0.004999,2)","v":22.05},null,"",22.05,{"$f":"+W100","v":0},{"$f":"+X100","v":22.05},{"$f":"(AG100-AC100)/AG100","v":0},null,3,{"$f":"SUM(AJ100:AL100)+AE100","v":22.05},null,null,{"$f":"ROUND(AC100/(1-VLOOKUP(AF100,Group,2,FALSE)),2)","v":22.05},{"$f":"IF(VLOOKUP(AF100,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ100,1)-AJ100,2),Round,2,FALSE)+VLOOKUP(AF100,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF100,Group,7,FALSE)=\"\",0,ROUND(AJ100-0.04999,1)-AJ100+AM100)","v":0},{"$f":"IF(VLOOKUP(AF100,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF100,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 11\"",null,"Mosaic",null,"Provenzale",null,null,"mesh-mounted",null,null,null,"4.50 SF/CTN","Stock","e,f",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA101,'Price List'!AG101)","v":33.549999999999997},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA101*(1-W101)+0.004999,2)","v":33.549999999999997},null,"",33.549999999999997,{"$f":"+W101","v":0},{"$f":"+X101","v":33.549999999999997},{"$f":"(AG101-AC101)/AG101","v":0},null,3,{"$f":"SUM(AJ101:AL101)+AE101","v":33.549999999999997},null,null,{"$f":"ROUND(AC101/(1-VLOOKUP(AF101,Group,2,FALSE)),2)","v":33.549999999999997},{"$f":"IF(VLOOKUP(AF101,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ101,1)-AJ101,2),Round,2,FALSE)+VLOOKUP(AF101,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",0,ROUND(AJ101-0.04999,1)-AJ101+AM101)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF101,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"2-1/4\" x 12\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA103,'Price List'!AG103)","v":8.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA103*(1-W103)+0.004999,2)","v":8.1},null,"",8.1,{"$f":"+W103","v":0},{"$f":"+X103","v":8.1},{"$f":"(AG103-AC103)/AG103","v":0},null,2,{"$f":"SUM(AJ103:AL103)+AE103","v":8.1},null,null,{"$f":"ROUND(AC103/(1-VLOOKUP(AF103,Group,2,FALSE)),2)","v":8.1},{"$f":"IF(VLOOKUP(AF103,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ103,1)-AJ103,2),Round,2,FALSE)+VLOOKUP(AF103,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF103,Group,7,FALSE)=\"\",0,ROUND(AJ103-0.04999,1)-AJ103+AM103)","v":0},{"$f":"IF(VLOOKUP(AF103,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF103,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"continued on next page"]
[null,null,"MATERIA - Glazed Porcelain - continued",null,null,null,null,null,null,null,"DISCONTINUED 9/15/23",null,null,null,null,null,null,"Item # Lookup:","NVMA"]
[]
[null,null,null,"Color:","Vietri Mix"]
[]
[null,"Decos",null,null,"2\" x 2\"",null,"Deco Tozzeto",null,null,null,null,"6 patterns per carton",null,null,null,"6 EA/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA110,'Price List'!AG110)","v":10.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA110*(1-W110)+0.004999,2)","v":10.35},null,"",10.35,{"$f":"+W110","v":0},10.35,{"$f":"(AG110-AC110)/AG110","v":0},null,3,{"$f":"SUM(AJ110:AL110)+AE110","v":10.35},null,null,{"$f":"ROUND(AC110/(1-VLOOKUP(AF110,Group,2,FALSE)),2)","v":10.35},{"$f":"IF(VLOOKUP(AF110,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ110,1)-AJ110,2),Round,2,FALSE)+VLOOKUP(AF110,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",0,ROUND(AJ110-0.04999,1)-AJ110+AM110)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF110,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"6\" x 6\"",null,"Deco",null,null,null,null,"4 patterns per carton",null,null,null,"4 EA/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA111,'Price List'!AG111)","v":22.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA111*(1-W111)+0.004999,2)","v":22.35},null,"",22.35,0,22.35,{"$f":"(AG111-AC111)/AG111","v":0},null,3,{"$f":"SUM(AJ111:AL111)+AE111","v":22.35},null,null,{"$f":"ROUND(AC111/(1-VLOOKUP(AF111,Group,2,FALSE)),2)","v":22.35},{"$f":"IF(VLOOKUP(AF111,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ111,1)-AJ111,2),Round,2,FALSE)+VLOOKUP(AF111,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",0,ROUND(AJ111-0.04999,1)-AJ111+AM111)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF111,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Deco",null,null,null,null,"4 patterns per carton",null,null,null,"4 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA112,'Price List'!AG112)","v":44.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA112*(1-W112)+0.004999,2)","v":44.25},null,"",44.25,0,44.25,{"$f":"(AG112-AC112)/AG112","v":0},null,3,{"$f":"SUM(AJ112:AL112)+AE112","v":44.25},null,null,{"$f":"ROUND(AC112/(1-VLOOKUP(AF112,Group,2,FALSE)),2)","v":44.25},{"$f":"IF(VLOOKUP(AF112,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ112,1)-AJ112,2),Round,2,FALSE)+VLOOKUP(AF112,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",0,ROUND(AJ112-0.04999,1)-AJ112+AM112)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF112,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Cold (coordinates w/Blue, Ghiaccio & Grigio)          Warm (coordinates w/Chiaro & Rosso)"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Deco Patch Mix",null,null,null,null,null,null,null,null,"13.73 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA116,'Price List'!AG116)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA116*(1-W116)+0.004999,2)","v":8.8000000000000007},null,"",8.8000000000000007,{"$f":"+W116","v":0},{"$f":"+X116","v":8.8000000000000007},{"$f":"(AG116-AC116)/AG116","v":0},null,3,{"$f":"SUM(AJ116:AL116)+AE116","v":8.8000000000000007},null,null,{"$f":"ROUND(AC116/(1-VLOOKUP(AF116,Group,2,FALSE)),2)","v":8.8000000000000007},{"$f":"IF(VLOOKUP(AF116,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ116,1)-AJ116,2),Round,2,FALSE)+VLOOKUP(AF116,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",0,ROUND(AJ116-0.04999,1)-AJ116+AM116)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF116,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Not available in colors Blue, Grigio and Mud.",null,null,null,null,null,"b) Not available in colors Blue, Ghiaccio, Grigio and Mud."]
[null,null,null,null,"c) 12\" x 24\" & 24\" x 24\" can not be used in a pattern with smaller shapes because thickness is different."]
[null,null,null,null,"d) The 24\" x 24\" Field Tile format is transitioning from 10.5mm to 9mm in thickness as inventories of the old thickness"]
[null,null,null,null,"are depleted.  Packaging of the 24\" x 24\" x 9mm Field Tile will be 11.62 SF/CTN."]
[null,null,null,null,"e) Stocked in colors Chiaro, Rosato and Rosso.",null,null,null,null,null,"f) Not available in colors Ghiaccio, Grigio and Mud.  Blue is special order.",null,null,null,null,null,null,null,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,"MICHELANGELO - Glazed Porcelain",null,null,null,null,null,null,null,null," "," ",null,null,null,null,"Item # Lookup:","NVMI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Bianco Arabescato"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Natural:","3\" x 12\"",null,"Field",null,null,null,null,null,null,null,null," 6.78 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA128,'Price List'!AG128)","v":9.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA128*(1-W128)+0.004999,2)","v":9.75},null,"",9.75,{"$f":"+W128","v":0},{"$f":"+X128","v":9.75},{"$f":"(AG128-AC128)/AG128","v":0},null,1,{"$f":"SUM(AJ128:AL128)+AE128","v":9.75},null,null,{"$f":"ROUND(AC128/(1-VLOOKUP(AF128,Group,2,FALSE)),2)","v":9.75},{"$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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA129,'Price List'!AG129)","v":8.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA129*(1-W129)+0.004999,2)","v":8.35},null,"",8.35,{"$f":"+W129","v":0},{"$f":"+X129","v":8.35},{"$f":"(AG129-AC129)/AG129","v":0},null,1,{"$f":"SUM(AJ129:AL129)+AE129","v":8.35},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":8.35},{"$f":"IF(VLOOKUP(AF129,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ129,1)-AJ129,2),Round,2,FALSE)+VLOOKUP(AF129,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",0,ROUND(AJ129-0.04999,1)-AJ129+AM129)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF129,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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,"mesh-mounted",null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA131,'Price List'!AG131)","v":21.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA131*(1-W131)+0.004999,2)","v":21.95},null,"",21.95,{"$f":"+W131","v":0},{"$f":"+X131","v":21.95},{"$f":"(AG131-AC131)/AG131","v":0},null,3,{"$f":"SUM(AJ131:AL131)+AE131","v":21.95},null,null,{"$f":"ROUND(AC131/(1-VLOOKUP(AF131,Group,2,FALSE)),2)","v":21.95},{"$f":"IF(VLOOKUP(AF131,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ131,1)-AJ131,2),Round,2,FALSE)+VLOOKUP(AF131,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,7,FALSE)=\"\",0,ROUND(AJ131-0.04999,1)-AJ131+AM131)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF131,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Intreccio",null,null,"mesh-mounted",null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA132,'Price List'!AG132)","v":23.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA132*(1-W132)+0.004999,2)","v":23.6},null,"",23.6,{"$f":"+W132","v":0},{"$f":"+X132","v":23.6},{"$f":"(AG132-AC132)/AG132","v":0},null,3,{"$f":"SUM(AJ132:AL132)+AE132","v":23.6},null,null,{"$f":"ROUND(AC132/(1-VLOOKUP(AF132,Group,2,FALSE)),2)","v":23.6},{"$f":"IF(VLOOKUP(AF132,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ132,1)-AJ132,2),Round,2,FALSE)+VLOOKUP(AF132,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",0,ROUND(AJ132-0.04999,1)-AJ132+AM132)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF132,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA134,'Price List'!AG134)","v":19.149999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA134*(1-W134)+0.004999,2)","v":19.149999999999999},null,"",19.149999999999999,{"$f":"+W134","v":0},{"$f":"+X134","v":19.149999999999999},{"$f":"(AG134-AC134)/AG134","v":0},null,2,{"$f":"SUM(AJ134:AL134)+AE134","v":19.149999999999999},null,null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":19.149999999999999},{"$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,"Field Tile",null,"Polished:","3\" x 12\"",null,"Field",null,null,null,null,null,null,null,null," 6.78 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA136,'Price List'!AG136)","v":13.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA136*(1-W136)+0.004999,2)","v":13.15},null,"",13.15,{"$f":"+W136","v":0},13.15,{"$f":"(AG136-AC136)/AG136","v":0},null,1,{"$f":"SUM(AJ136:AL136)+AE136","v":13.15},null,null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":13.15},{"$f":"IF(VLOOKUP(AF136,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ136,1)-AJ136,2),Round,2,FALSE)+VLOOKUP(AF136,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",0,ROUND(AJ136-0.04999,1)-AJ136+AM136)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF136,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA137,'Price List'!AG137)","v":10.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA137*(1-W137)+0.004999,2)","v":10.7},null,"",10.7,0,10.7,{"$f":"(AG137-AC137)/AG137","v":0},null,1,{"$f":"SUM(AJ137:AL137)+AE137","v":10.7},null,null,{"$f":"ROUND(AC137/(1-VLOOKUP(AF137,Group,2,FALSE)),2)","v":10.7},{"$f":"IF(VLOOKUP(AF137,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ137,1)-AJ137,2),Round,2,FALSE)+VLOOKUP(AF137,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",0,ROUND(AJ137-0.04999,1)-AJ137+AM137)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF137,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA138,'Price List'!AG138)","v":13.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA138*(1-W138)+0.004999,2)","v":13.75},null,"",13.75,0,13.75,{"$f":"(AG138-AC138)/AG138","v":0},null,1,{"$f":"SUM(AJ138:AL138)+AE138","v":13.75},null,null,{"$f":"ROUND(AC138/(1-VLOOKUP(AF138,Group,2,FALSE)),2)","v":13.75},{"$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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Intreccio",null,null,"mesh-mounted",null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA140,'Price List'!AG140)","v":25.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA140*(1-W140)+0.004999,2)","v":25.65},null,"",25.65,{"$f":"+W140","v":0},25.65,{"$f":"(AG140-AC140)/AG140","v":0},null,3,{"$f":"SUM(AJ140:AL140)+AE140","v":25.65},null,null,{"$f":"ROUND(AC140/(1-VLOOKUP(AF140,Group,2,FALSE)),2)","v":25.65},{"$f":"IF(VLOOKUP(AF140,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ140,1)-AJ140,2),Round,2,FALSE)+VLOOKUP(AF140,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",0,ROUND(AJ140-0.04999,1)-AJ140+AM140)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF140,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"10\" x 10\"",null,"Mosaic",null,"Losanga",null,null,"mesh-mounted",null,null,null,"0.73 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA141,'Price List'!AG141)","v":50.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA141*(1-W141)+0.004999,2)","v":50.15},null,"",50.15,0,50.15,{"$f":"(AG141-AC141)/AG141","v":0},null,3,{"$f":"SUM(AJ141:AL141)+AE141","v":50.15},null,null,{"$f":"ROUND(AC141/(1-VLOOKUP(AF141,Group,2,FALSE)),2)","v":50.15},{"$f":"IF(VLOOKUP(AF141,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ141,1)-AJ141,2),Round,2,FALSE)+VLOOKUP(AF141,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,7,FALSE)=\"\",0,ROUND(AJ141-0.04999,1)-AJ141+AM141)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF141,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 13\"",null,"Mosaic",null,"Zig-Zag",null,null,"mesh-mounted",null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA142,'Price List'!AG142)","v":39.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA142*(1-W142)+0.004999,2)","v":39.75},null,"",39.75,0,39.75,{"$f":"(AG142-AC142)/AG142","v":0},null,3,{"$f":"SUM(AJ142:AL142)+AE142","v":39.75},null,null,{"$f":"ROUND(AC142/(1-VLOOKUP(AF142,Group,2,FALSE)),2)","v":39.75},{"$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,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA144,'Price List'!AG144)","v":21.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA144*(1-W144)+0.004999,2)","v":21.3},null,"",21.3,{"$f":"+W144","v":0},{"$f":"+X144","v":21.3},{"$f":"(AG144-AC144)/AG144","v":0},null,2,{"$f":"SUM(AJ144:AL144)+AE144","v":21.3},null,null,{"$f":"ROUND(AC144/(1-VLOOKUP(AF144,Group,2,FALSE)),2)","v":21.3},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ144,1)-AJ144,2),Round,2,FALSE)+VLOOKUP(AF144,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",0,ROUND(AJ144-0.04999,1)-AJ144+AM144)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF144,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Grigio Visone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Natural:","3\" x 12\"",null,"Field",null,null,null,null,null,null,null,null," 6.78 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA148,'Price List'!AG148)","v":9.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA148*(1-W148)+0.004999,2)","v":9.75},null,"",9.75,{"$f":"+W148","v":0},{"$f":"+X148","v":9.75},{"$f":"(AG148-AC148)/AG148","v":0},null,1,{"$f":"SUM(AJ148:AL148)+AE148","v":9.75},null,null,{"$f":"ROUND(AC148/(1-VLOOKUP(AF148,Group,2,FALSE)),2)","v":9.75},{"$f":"IF(VLOOKUP(AF148,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ148,1)-AJ148,2),Round,2,FALSE)+VLOOKUP(AF148,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",0,ROUND(AJ148-0.04999,1)-AJ148+AM148)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF148,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA149,'Price List'!AG149)","v":8.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA149*(1-W149)+0.004999,2)","v":8.35},null,"",8.35,{"$f":"+W149","v":0},{"$f":"+X149","v":8.35},{"$f":"(AG149-AC149)/AG149","v":0},null,1,{"$f":"SUM(AJ149:AL149)+AE149","v":8.35},null,null,{"$f":"ROUND(AC149/(1-VLOOKUP(AF149,Group,2,FALSE)),2)","v":8.35},{"$f":"IF(VLOOKUP(AF149,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ149,1)-AJ149,2),Round,2,FALSE)+VLOOKUP(AF149,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",0,ROUND(AJ149-0.04999,1)-AJ149+AM149)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF149,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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,"mesh-mounted",null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA151,'Price List'!AG151)","v":21.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA151*(1-W151)+0.004999,2)","v":21.95},null,"",21.95,{"$f":"+W151","v":0},{"$f":"+X151","v":21.95},{"$f":"(AG151-AC151)/AG151","v":0},null,3,{"$f":"SUM(AJ151:AL151)+AE151","v":21.95},null,null,{"$f":"ROUND(AC151/(1-VLOOKUP(AF151,Group,2,FALSE)),2)","v":21.95},{"$f":"IF(VLOOKUP(AF151,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ151,1)-AJ151,2),Round,2,FALSE)+VLOOKUP(AF151,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,7,FALSE)=\"\",0,ROUND(AJ151-0.04999,1)-AJ151+AM151)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF151,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,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA153,'Price List'!AG153)","v":19.149999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA153*(1-W153)+0.004999,2)","v":19.149999999999999},null,"",19.149999999999999,{"$f":"+W153","v":0},{"$f":"+X153","v":19.149999999999999},{"$f":"(AG153-AC153)/AG153","v":0},null,2,{"$f":"SUM(AJ153:AL153)+AE153","v":19.149999999999999},null,null,{"$f":"ROUND(AC153/(1-VLOOKUP(AF153,Group,2,FALSE)),2)","v":19.149999999999999},{"$f":"IF(VLOOKUP(AF153,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ153,1)-AJ153,2),Round,2,FALSE)+VLOOKUP(AF153,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",0,ROUND(AJ153-0.04999,1)-AJ153+AM153)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF153,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Polished:","3\" x 12\"",null,"Field",null,null,null,null,null,null,null,null," 6.78 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA155,'Price List'!AG155)","v":13.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA155*(1-W155)+0.004999,2)","v":13.15},null,"",13.15,{"$f":"+W155","v":0},13.15,{"$f":"(AG155-AC155)/AG155","v":0},null,1,{"$f":"SUM(AJ155:AL155)+AE155","v":13.15},null,null,{"$f":"ROUND(AC155/(1-VLOOKUP(AF155,Group,2,FALSE)),2)","v":13.15},{"$f":"IF(VLOOKUP(AF155,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ155,1)-AJ155,2),Round,2,FALSE)+VLOOKUP(AF155,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF155,Group,7,FALSE)=\"\",0,ROUND(AJ155-0.04999,1)-AJ155+AM155)","v":0},{"$f":"IF(VLOOKUP(AF155,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF155,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA156,'Price List'!AG156)","v":10.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA156*(1-W156)+0.004999,2)","v":10.7},null,"",10.7,0,10.7,{"$f":"(AG156-AC156)/AG156","v":0},null,1,{"$f":"SUM(AJ156:AL156)+AE156","v":10.7},null,null,{"$f":"ROUND(AC156/(1-VLOOKUP(AF156,Group,2,FALSE)),2)","v":10.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,null,null,null,null,"15.49 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA157,'Price List'!AG157)","v":13.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":13.75},null,"",13.75,0,13.75,{"$f":"(AG157-AC157)/AG157","v":0},null,1,{"$f":"SUM(AJ157:AL157)+AE157","v":13.75},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":13.75},{"$f":"IF(VLOOKUP(AF157,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ157,1)-AJ157,2),Round,2,FALSE)+VLOOKUP(AF157,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",0,ROUND(AJ157-0.04999,1)-AJ157+AM157)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF157,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA159,'Price List'!AG159)","v":21.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA159*(1-W159)+0.004999,2)","v":21.3},null,"",21.3,{"$f":"+W159","v":0},{"$f":"+X159","v":21.3},{"$f":"(AG159-AC159)/AG159","v":0},null,2,{"$f":"SUM(AJ159:AL159)+AE159","v":21.3},null,null,{"$f":"ROUND(AC159/(1-VLOOKUP(AF159,Group,2,FALSE)),2)","v":21.3},{"$f":"IF(VLOOKUP(AF159,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ159,1)-AJ159,2),Round,2,FALSE)+VLOOKUP(AF159,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",0,ROUND(AJ159-0.04999,1)-AJ159+AM159)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF159,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Spaccatella"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Polished:","12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA163,'Price List'!AG163)","v":11.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA163*(1-W163)+0.004999,2)","v":11.3},null,"",11.3,{"$f":"+W163","v":0},{"$f":"+X163","v":11.3},{"$f":"(AG163-AC163)/AG163","v":0},null,1,{"$f":"SUM(AJ163:AL163)+AE163","v":11.3},null,null,{"$f":"ROUND(AC163/(1-VLOOKUP(AF163,Group,2,FALSE)),2)","v":11.3},{"$f":"IF(VLOOKUP(AF163,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ163,1)-AJ163,2),Round,2,FALSE)+VLOOKUP(AF163,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF163,Group,7,FALSE)=\"\",0,ROUND(AJ163-0.04999,1)-AJ163+AM163)","v":0},{"$f":"IF(VLOOKUP(AF163,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF163,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,"X"]
[null,null,"SOVEREIGN - Glazed Porcelain",null,null,null,null,null,null,null," "," "," ",null,null,null,null,"Item # Lookup:","NVSO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Antracite",null,"  Beige",null,null,"        Tabacco"]
[null,null,null,null,"Avorio",null,"  Grigio Chiaro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 12\"",null,"Field",null,null,null,null,null,null,null,null,"9.04 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA170,'Price List'!AG170)","v":11.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA170*(1-W170)+0.004999,2)","v":11.25},null,"",11.25,{"$f":"+W170","v":0},{"$f":"+X170","v":11.25},{"$f":"(AG170-AC170)/AG170","v":0},null,1,{"$f":"SUM(AJ170:AL170)+AE170","v":11.25},null,null,{"$f":"ROUND(AC170/(1-VLOOKUP(AF170,Group,2,FALSE)),2)","v":11.25},{"$f":"IF(VLOOKUP(AF170,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ170,1)-AJ170,2),Round,2,FALSE)+VLOOKUP(AF170,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",0,ROUND(AJ170-0.04999,1)-AJ170+AM170)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF170,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"13.56 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA171,'Price List'!AG171)","v":9.1999999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.1999999999999993,null,"",9.1999999999999993,0,9.1999999999999993,0,null,1,9.1999999999999993,null,null,9.1999999999999993,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA172,'Price List'!AG172)","v":8.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.9,null,"",8.9,0,8.9,0,null,1,8.9,null,null,8.9,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA173,'Price List'!AG173)","v":12.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},12.15,null,"",12.15,0,12.15,0,null,1,12.15,null,null,12.15,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,"5\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"3.36 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA175,'Price List'!AG175)","v":13},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},13,null,"",13,0,13,0,null,1,13,null,null,13,0,0,"",null,"X"]
[null,"Field Tile",null,null,"16\" x 32\"",null,"Field",null,null,null,null,null,null,null,null,"13.77 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA176,'Price List'!AG176)","v":9.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.75,null,"",9.75,0,9.75,0,null,1,9.75,null,null,9.75,0,0,"",null,"X"]
[null,"Field Tile",null,null,"32\" x 32\"",null,"Field",null,null,null,null,null,null,null,null,"13.77 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA177,'Price List'!AG177)","v":9.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.85,null,"",9.85,0,9.85,0,null,1,9.85,null,null,9.85,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,"Decos",null,null,"12\" x 24\"",null,"Deco Muretto",null,null,null,null,null,null,null,null,"7.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA179,'Price List'!AG179)","v":29.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA179*(1-W179)+0.004999,2)","v":29.8},null,"",29.8,{"$f":"+W179","v":0},{"$f":"+X179","v":29.8},{"$f":"(AG179-AC179)/AG179","v":0},null,3,{"$f":"SUM(AJ179:AL179)+AE179","v":29.8},null,null,{"$f":"ROUND(AC179/(1-VLOOKUP(AF179,Group,2,FALSE)),2)","v":29.8},{"$f":"IF(VLOOKUP(AF179,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ179,1)-AJ179,2),Round,2,FALSE)+VLOOKUP(AF179,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",0,ROUND(AJ179-0.04999,1)-AJ179+AM179)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF179,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"16\" x 32\"",null,"Deco Dune",null,null,null,"(3.44 SF/Piece)",null,null,null,null,"10.32 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA180,'Price List'!AG180)","v":10.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA180*(1-W180)+0.004999,2)","v":10.75},null,"",10.75,{"$f":"+W180","v":0},{"$f":"+X180","v":10.75},{"$f":"(AG180-AC180)/AG180","v":0},null,3,{"$f":"SUM(AJ180:AL180)+AE180","v":10.75},null,null,{"$f":"ROUND(AC180/(1-VLOOKUP(AF180,Group,2,FALSE)),2)","v":10.75},{"$f":"IF(VLOOKUP(AF180,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ180,1)-AJ180,2),Round,2,FALSE)+VLOOKUP(AF180,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF180,Group,7,FALSE)=\"\",0,ROUND(AJ180-0.04999,1)-AJ180+AM180)","v":0},{"$f":"IF(VLOOKUP(AF180,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF180,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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"1\" x 1\"",null,"mesh-mounted (0.97 SF/Sheet)",null,null,null,null,"9.70 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA182,'Price List'!AG182)","v":22.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA182*(1-W182)+0.004999,2)","v":22.5},null,"",22.5,{"$f":"+W182","v":0},22.5,{"$f":"(AG182-AC182)/AG182","v":0},null,3,{"$f":"SUM(AJ182:AL182)+AE182","v":22.5},null,null,{"$f":"ROUND(AC182/(1-VLOOKUP(AF182,Group,2,FALSE)),2)","v":22.5},{"$f":"IF(VLOOKUP(AF182,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ182,1)-AJ182,2),Round,2,FALSE)+VLOOKUP(AF182,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",0,ROUND(AJ182-0.04999,1)-AJ182+AM182)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF182,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,"mesh-mounted",null,null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA183,'Price List'!AG183)","v":21.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":21.65},null,"",21.65,0,21.65,{"$f":"(AG183-AC183)/AG183","v":0},null,3,{"$f":"SUM(AJ183:AL183)+AE183","v":21.65},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":21.65},{"$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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 4\" 3D",null,"mesh-mounted (0.97 SF/Sheet)",null,null,null,null,"5.82 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA184,'Price List'!AG184)","v":49.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA184*(1-W184)+0.004999,2)","v":49.5},null,"",49.5,0,49.5,{"$f":"(AG184-AC184)/AG184","v":0},null,3,{"$f":"SUM(AJ184:AL184)+AE184","v":49.5},null,null,{"$f":"ROUND(AC184/(1-VLOOKUP(AF184,Group,2,FALSE)),2)","v":49.5},{"$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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"3\" x 3\" 3D",null,"mesh-mounted (0.97 SF/Sheet)",null,null,null,null,"5.82 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA185,'Price List'!AG185)","v":48.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA185*(1-W185)+0.004999,2)","v":48.65},null,"",48.65,0,48.65,{"$f":"(AG185-AC185)/AG185","v":0},null,3,{"$f":"SUM(AJ185:AL185)+AE185","v":48.65},null,null,{"$f":"ROUND(AC185/(1-VLOOKUP(AF185,Group,2,FALSE)),2)","v":48.65},{"$f":"IF(VLOOKUP(AF185,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ185,1)-AJ185,2),Round,2,FALSE)+VLOOKUP(AF185,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF185,Group,7,FALSE)=\"\",0,ROUND(AJ185-0.04999,1)-AJ185+AM185)","v":0},{"$f":"IF(VLOOKUP(AF185,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF185,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"2.8\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,"15 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA187,'Price List'!AG187)","v":8.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA187*(1-W187)+0.004999,2)","v":8.5},null,"",8.5,{"$f":"+W187","v":0},{"$f":"+X187","v":8.5},{"$f":"(AG187-AC187)/AG187","v":0},null,2,{"$f":"SUM(AJ187:AL187)+AE187","v":8.5},null,null,{"$f":"ROUND(AC187/(1-VLOOKUP(AF187,Group,2,FALSE)),2)","v":8.5},{"$f":"IF(VLOOKUP(AF187,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ187,1)-AJ187,2),Round,2,FALSE)+VLOOKUP(AF187,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",0,ROUND(AJ187-0.04999,1)-AJ187+AM187)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF187,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"2.8\" x 32\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA188,'Price List'!AG188)","v":19.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA188*(1-W188)+0.004999,2)","v":19.75},null,"",19.75,{"$f":"+W188","v":0},{"$f":"+X188","v":19.75},{"$f":"(AG188-AC188)/AG188","v":0},null,2,{"$f":"SUM(AJ188:AL188)+AE188","v":19.75},null,null,{"$f":"ROUND(AC188/(1-VLOOKUP(AF188,Group,2,FALSE)),2)","v":19.75},{"$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,null,"Notes:","a) Not available in color Tabacco.",null,null,null,null,"b) Not available in colors Anthracite and Tabacco."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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."]
[]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[]
[null,null,null,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2,null,null,null,null," "]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","http://www.cctd.com/index.php"]
[]
["Manufacturer's Home Page","https://www.novabell.it/en/"]
[]
[]
["Product","Direct Website Link"]
["ASPEN","https://www.novabell.it/en/collections/20496/"]
["BRICKUP","https://www.novabell.it/en/collections/brickup/"]
["IMPERIAL","https://www.novabell.it/en/collections/imperial/"]
["MATERIA","https://www.novabell.it/en/collections/materia/"]
["MICHELANGELO","https://www.novabell.it/en/collections/imperial-michelangelo/"]
["SOVEREIGN","https://www.novabell.it/en/collections/sovereign/"]

{"sheet":"Changes","index":4,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,2,1,2]]}
["Date",null,"Description"]
["Announced","Series"]
[]
["New Products"]
["2016-04-01","Imperial","Glazed Porcelain"]
["2017-03-06","Imperial","Added colors Calacatta Beige and Nero Imperiale."]
["2017-03-06","Materia","Glazed Porcelain"]
["2018-02-01","Deco","Glazed Porcelain"]
["2018-02-01","Sovereign","Glazed Porcelain"]
["2018-02-01","Venice","Glazed Porcelain - Named Imperial Venice on Novabell's Website"]
["2019-03-12","Michelangelo","Glazed Porcelain - Named Imperial Michelangelo on Novabell's Website"]
["2021-01-01","Aspen","Glazed Porcelain"]
["2021-01-01","Brickup","Glazed Porcelain - 3D Brick"]
[]
[]
[]
[]
["Discontinued Products"]
["2018-11-26","Imperial","In the \"Silk\" finish only, all formats in colors Calacatta Beige, Cappuccino and Nero Imperiale. "]
["2019-08-27","Imperial","In the \"Silk\" finish only, all formats in colors Calacatta Beige and Cappuccino."]
["2019-10-28","Materia","12\" x 24\" & 24\" x 24\" Field Tile formats in colors Ghiaccio and Grigio only."]
["2020-12-04","Imperial","In the \"Silk\" finish only, all formats in colors Crema and Nero Imperiale."]
["2020-12-04","Materia","2-3/8\" x 10\" Field Tile format in colors Blue, Grigio and Mud only."]
["2021-11-24","Imperial","All formats in the \"Silk\" finish.  Colors Cappuccino, Grigio Imperiale and London Grey in all formats and finishes.  Cassettone mosaic in all colors. "]
["2022-08-22","Deco","Entire Series.  (Discontinued by CCTD)"]
["2022-08-22","Venice","Entire Series.  (Discontinued by CCTD)"]
["2022-10-17","Imperial","Entire Series.  (Discontinued by Novabell)"]
["2023-09-15","Materia","Entire Series.  (Discontinued by CCTD)"]