{"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","Novabell"]
["File as","N"]
["Product Code","B"]
["CCTD Effective Date","11/1/24 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"B"}]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0,null,null," "]
[null,2,null,"Trim",null,"No",0]
[null,3,null,"Decos",null,"No",0]
[null,4,null,0,null,"No",0,null,null,null,"  "]
[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/24 (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,"Extra",null,"Glazed Porcelain"]
[2,null,"Michelangelo (Disc. 10/23/24)",null,"Glazed Porcelain"]
[2,null,"Sovereign",null,"Glazed Porcelain"]
[2,null,"Urbe",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":195,"n_cols":41,"rows_kept":195,"cut":false,"hidden":false,"merged":[[14,13,15,19],[10,14,10,15],[9,14,9,19],[180,2,180,19],[184,3,184,4],[18,2,18,19],[17,14,17,15],[19,2,19,19],[178,2,178,19],[9,25,9,32],[12,22,12,23],[9,22,9,23],[13,30,13,32],[12,14,12,19]]}
[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/24 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-11-04"},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,"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":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA26*(1-W26)+0.004999,2)","v":8.8000000000000007},null,"",8.8000000000000007,{"$f":"+W26","v":0},8.8000000000000007,{"$f":"(AG26-AC26)/AG26","v":0},null,1,{"$f":"SUM(AJ26:AL26)+AE26","v":8.8000000000000007},null,null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":8.8000000000000007},{"$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":6.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},6.95,null,"",6.95,0,6.95,0,null,1,6.95,null,null,6.95,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":14.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.65,null,"",14.65,0,14.65,0,null,1,14.65,null,null,14.65,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":7.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.2,null,"",7.2,0,7.2,0,null,1,7.2,null,null,7.2,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":7.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.4,null,"",7.4,0,7.4,0,null,1,7.4,null,null,7.4,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":7.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.55,null,"",7.55,0,7.55,0,null,1,7.55,null,null,7.55,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":7.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.85,null,"",7.85,0,7.85,0,null,1,7.85,null,null,7.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 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'!AA34,'Price List'!AG34)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA34*(1-W34)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W34","v":0},18.7,{"$f":"(AG34-AC34)/AG34","v":0},null,3,{"$f":"SUM(AJ34:AL34)+AE34","v":18.7},null,null,{"$f":"ROUND(AC34/(1-VLOOKUP(AF34,Group,2,FALSE)),2)","v":18.7},{"$f":"IF(VLOOKUP(AF34,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ34,1)-AJ34,2),Round,2,FALSE)+VLOOKUP(AF34,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF34,Group,7,FALSE)=\"\",0,ROUND(AJ34-0.04999,1)-AJ34+AM34)","v":0},{"$f":"IF(VLOOKUP(AF34,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF34,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'!AA35,'Price List'!AG35)","v":42},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":42},null,"",42,0,42,{"$f":"(AG35-AC35)/AG35","v":0},null,3,{"$f":"SUM(AJ35:AL35)+AE35","v":42},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":42},{"$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) - Dark Mix (O-B-RG)",null,null,null,null,"mesh-mounted",null,"9.68 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA36,'Price List'!AG36)","v":42},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":42},null,"",42,0,42,{"$f":"(AG36-AC36)/AG36","v":0},null,3,{"$f":"SUM(AJ36:AL36)+AE36","v":42},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":42},{"$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) - Light Mix (SM-S-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":42},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":42},null,"",42,0,42,{"$f":"(AG37-AC37)/AG37","v":0},null,3,{"$f":"SUM(AJ37:AL37)+AE37","v":42},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":42},{"$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 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'!AA38,'Price List'!AG38)","v":26.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":26.3},null,"",26.3,0,26.3,{"$f":"(AG38-AC38)/AG38","v":0},null,3,{"$f":"SUM(AJ38:AL38)+AE38","v":26.3},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":26.3},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA40,'Price List'!AG40)","v":16.850000000000001},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA40*(1-W40)+0.004999,2)","v":16.850000000000001},null,"",16.850000000000001,{"$f":"+W40","v":0},{"$f":"+X40","v":16.850000000000001},{"$f":"(AG40-AC40)/AG40","v":0},null,2,{"$f":"SUM(AJ40:AL40)+AE40","v":16.850000000000001},null,null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":16.850000000000001},{"$f":"IF(VLOOKUP(AF40,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ40,1)-AJ40,2),Round,2,FALSE)+VLOOKUP(AF40,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,7,FALSE)=\"\",0,ROUND(AJ40-0.04999,1)-AJ40+AM40)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF40,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'!AA45,'Price List'!AG45)","v":33.049999999999997},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA45*(1-W45)+0.004999,2)","v":33.049999999999997},null,"",33.049999999999997,{"$f":"+W45","v":0},{"$f":"+X45","v":33.049999999999997},{"$f":"(AG45-AC45)/AG45","v":0},null,3,{"$f":"SUM(AJ45:AL45)+AE45","v":33.049999999999997},null,null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":33.049999999999997},{"$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,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'!AA54,'Price List'!AG54)","v":6.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA54*(1-W54)+0.004999,2)","v":6.95},null,"",6.95,{"$f":"+W54","v":0},{"$f":"+X54","v":6.95},{"$f":"(AG54-AC54)/AG54","v":0},null,1,{"$f":"SUM(AJ54:AL54)+AE54","v":6.95},null,null,{"$f":"ROUND(AC54/(1-VLOOKUP(AF54,Group,2,FALSE)),2)","v":6.95},{"$f":"IF(VLOOKUP(AF54,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ54,1)-AJ54,2),Round,2,FALSE)+VLOOKUP(AF54,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF54,Group,7,FALSE)=\"\",0,ROUND(AJ54-0.04999,1)-AJ54+AM54)","v":0},{"$f":"IF(VLOOKUP(AF54,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF54,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA56,'Price List'!AG56)","v":53},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":53},null,"",53,{"$f":"+W56","v":0},{"$f":"+X56","v":53},{"$f":"(AG56-AC56)/AG56","v":0},null,3,{"$f":"SUM(AJ56:AL56)+AE56","v":53},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":53},{"$f":"IF(VLOOKUP(AF56,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ56,1)-AJ56,2),Round,2,FALSE)+VLOOKUP(AF56,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",0,ROUND(AJ56-0.04999,1)-AJ56+AM56)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF56,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"EXTRA - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","NVEX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Select          Onice Bianco          ",null,"         Pulpis Beige"]
[null,null,null,null,"Onice Bianco",null,"         Pulpis Grey"]
[]
[null,"Field Tile",null,"Natural:","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'!AA63,'Price List'!AG63)","v":9.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA63*(1-W63)+0.004999,2)","v":9.5},null,"",9.5,{"$f":"+W63","v":0},{"$f":"+X63","v":9.5},{"$f":"(AG63-AC63)/AG63","v":0},null,1,{"$f":"SUM(AJ63:AL63)+AE63","v":9.5},null,null,{"$f":"ROUND(AC63/(1-VLOOKUP(AF63,Group,2,FALSE)),2)","v":9.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,"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'!AA64,'Price List'!AG64)","v":6.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},6.95,null,"",6.95,0,6.95,0,null,1,6.95,null,null,6.95,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'!AA65,'Price List'!AG65)","v":7.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.4,null,"",7.4,0,7.4,0,null,1,7.4,null,null,7.4,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'!AA66,'Price List'!AG66)","v":8.3000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.3000000000000007,null,"",8.3000000000000007,0,8.3000000000000007,0,null,1,8.3000000000000007,null,null,8.3000000000000007,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,".97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA68,'Price List'!AG68)","v":17.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA68*(1-W68)+0.004999,2)","v":17.2},null,"",17.2,{"$f":"+W68","v":0},{"$f":"+X68","v":17.2},{"$f":"(AG68-AC68)/AG68","v":0},null,3,{"$f":"SUM(AJ68:AL68)+AE68","v":17.2},null,null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":17.2},{"$f":"IF(VLOOKUP(AF68,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ68,1)-AJ68,2),Round,2,FALSE)+VLOOKUP(AF68,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",0,ROUND(AJ68-0.04999,1)-AJ68+AM68)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF68,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"11\" x 11\"",null,"Mosaic",null,"Lisca",null,null,null,null,null,null,"8.40 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA69,'Price List'!AG69)","v":23.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},23.4,null,"",23.4,0,23.4,0,null,3,23.4,null,null,23.4,0,0,"",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'!AA71,'Price List'!AG71)","v":15.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W71","v":0},{"$f":"+X71","v":15.3},{"$f":"(AG71-AC71)/AG71","v":0},null,2,{"$f":"SUM(AJ71:AL71)+AE71","v":15.3},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF71,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ71,1)-AJ71,2),Round,2,FALSE)+VLOOKUP(AF71,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",0,ROUND(AJ71-0.04999,1)-AJ71+AM71)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF71,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Calacatta Select          Onice Bianco          ",null,"          Onice Bianco",null,null,null,"Pulpis Grey"]
[null,null,null,null,"Marquina Shiny",null,"          Pulpis Beige",null,null,null,"Scenic White"]
[]
[null,"Field Tile",null,"Polished:","4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"9.04 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA76,'Price List'!AG76)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":10.85},null,"",10.85,{"$f":"+W76","v":0},{"$f":"+X76","v":10.85},{"$f":"(AG76-AC76)/AG76","v":0},null,1,{"$f":"SUM(AJ76:AL76)+AE76","v":10.85},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF76,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ76,1)-AJ76,2),Round,2,FALSE)+VLOOKUP(AF76,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",0,ROUND(AJ76-0.04999,1)-AJ76+AM76)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF76,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA77,'Price List'!AG77)","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 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA78,'Price List'!AG78)","v":9.4499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.4499999999999993,null,"",9.4499999999999993,0,9.4499999999999993,0,null,1,9.4499999999999993,null,null,9.4499999999999993,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","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA79,'Price List'!AG79)","v":10.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.4,null,"",10.4,0,10.4,0,null,1,10.4,null,null,10.4,0,0,"",null,"X"]
[null,"Field Tile",null,null,"36\" x 36\"",null,"Field",null,null,"       DISCONTINUED 11/4/2024",null,null,null,null,null,"17.43 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA80,'Price List'!AG80)","v":10.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA80*(1-W80)+0.004999,2)","v":10.95},null,"",10.95,{"$f":"+W80","v":0},{"$f":"+X80","v":10.95},{"$f":"(AG80-AC80)/AG80","v":0},null,1,{"$f":"SUM(AJ80:AL80)+AE80","v":10.95},null,null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":10.95},{"$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,"Field Tile",null,null,"36\" x 72\"",null,"Field",null,null,"       DISCONTINUED 11/4/2024",null,null,null,null,null,"17.43 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA81,'Price List'!AG81)","v":11.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11.65,null,"",11.65,0,11.65,0,null,1,11.65,null,null,11.65,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,"9.70 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA83,'Price List'!AG83)","v":18.850000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA83*(1-W83)+0.004999,2)","v":18.850000000000001},null,"",18.850000000000001,{"$f":"+W83","v":0},{"$f":"+X83","v":18.850000000000001},{"$f":"(AG83-AC83)/AG83","v":0},null,3,{"$f":"SUM(AJ83:AL83)+AE83","v":18.850000000000001},null,null,{"$f":"ROUND(AC83/(1-VLOOKUP(AF83,Group,2,FALSE)),2)","v":18.850000000000001},{"$f":"IF(VLOOKUP(AF83,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ83,1)-AJ83,2),Round,2,FALSE)+VLOOKUP(AF83,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF83,Group,7,FALSE)=\"\",0,ROUND(AJ83-0.04999,1)-AJ83+AM83)","v":0},{"$f":"IF(VLOOKUP(AF83,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF83,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"11.8\" x 11.4\"",null,"Mosaic",null,"Chevron",null,null,null,null,null,null,"6.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA84,'Price List'!AG84)","v":34.700000000000003},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},34.700000000000003,null,"",34.700000000000003,0,34.700000000000003,0,null,3,34.700000000000003,null,null,34.700000000000003,0,0,"",null,"X"]
[null,"Decos",null,null,"15.7\" x 13.8\"",null,"Mosaic",null,"Esagona Hex",null,null,null,null,null,null,"1.44 SF/Sheet","Stock","c",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA85,'Price List'!AG85)","v":39.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA85*(1-W85)+0.004999,2)","v":39.85},null,"",39.85,{"$f":"+W85","v":0},{"$f":"+X85","v":39.85},{"$f":"(AG85-AC85)/AG85","v":0},null,3,{"$f":"SUM(AJ85:AL85)+AE85","v":39.85},null,null,{"$f":"ROUND(AC85/(1-VLOOKUP(AF85,Group,2,FALSE)),2)","v":39.85},{"$f":"IF(VLOOKUP(AF85,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ85,1)-AJ85,2),Round,2,FALSE)+VLOOKUP(AF85,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",0,ROUND(AJ85-0.04999,1)-AJ85+AM85)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF85,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Intreccio Basketweave",null,null,null,null,null,null,".97 SF/Sheet","Stock","c",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA86,'Price List'!AG86)","v":26.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},26.1,null,"",26.1,0,26.1,0,null,3,26.1,null,null,26.1,0,0,"",null,"X"]
[null,"Decos",null,null,"11\" x 11\"",null,"Mosaic",null,"Lisca Herringbone",null,null,null,null,null,null,".84 SF/Sheet","Stock","c",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA87,'Price List'!AG87)","v":24.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},24.95,null,"",24.95,0,24.95,0,null,3,24.95,null,null,24.95,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Pinwheel Basket",null,null,null,null,null,null,"9.70 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA88,'Price List'!AG88)","v":26.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA88*(1-W88)+0.004999,2)","v":26.1},null,"",26.1,{"$f":"+W88","v":0},{"$f":"+X88","v":26.1},{"$f":"(AG88-AC88)/AG88","v":0},null,3,{"$f":"SUM(AJ88:AL88)+AE88","v":26.1},null,null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":26.1},{"$f":"IF(VLOOKUP(AF88,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ88,1)-AJ88,2),Round,2,FALSE)+VLOOKUP(AF88,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",0,ROUND(AJ88-0.04999,1)-AJ88+AM88)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF88,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 15\"",null,"Mosaic",null,"Round Arch",null,null,null,null,null,null,"7.26 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA89,'Price List'!AG89)","v":37.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":37.15},null,"",37.15,{"$f":"+W89","v":0},{"$f":"+X89","v":37.15},{"$f":"(AG89-AC89)/AG89","v":0},null,3,{"$f":"SUM(AJ89:AL89)+AE89","v":37.15},null,null,{"$f":"ROUND(AC89/(1-VLOOKUP(AF89,Group,2,FALSE)),2)","v":37.15},{"$f":"IF(VLOOKUP(AF89,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ89,1)-AJ89,2),Round,2,FALSE)+VLOOKUP(AF89,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,7,FALSE)=\"\",0,ROUND(AJ89-0.04999,1)-AJ89+AM89)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF89,Group,7,FALSE))","v":""},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'!AA91,'Price List'!AG91)","v":17.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":17.05},null,"",17.05,{"$f":"+W91","v":0},{"$f":"+X91","v":17.05},{"$f":"(AG91-AC91)/AG91","v":0},null,2,{"$f":"SUM(AJ91:AL91)+AE91","v":17.05},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":17.05},{"$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,null,null,"Notes:","a) Not stocked in color Scenic White."]
[null,null,null,null,"b) Not available in color Onice Bianco."]
[null,null,null,null,"c) Not stocked in colors Marquina Shiny and Scenic White."]
[]
[null,null,"MICHELANGELO - Glazed Porcelain",null,null,null,null,null,null,"       DISCONTINUED 10/23/2024",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'!AA101,'Price List'!AG101)","v":8.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA101*(1-W101)+0.004999,2)","v":8.9},null,"",8.9,{"$f":"+W101","v":0},{"$f":"+X101","v":8.9},{"$f":"(AG101-AC101)/AG101","v":0},null,1,{"$f":"SUM(AJ101:AL101)+AE101","v":8.9},null,null,{"$f":"ROUND(AC101/(1-VLOOKUP(AF101,Group,2,FALSE)),2)","v":8.9},{"$f":"IF(VLOOKUP(AF101,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ101,1)-AJ101,2),Round,2,FALSE)+VLOOKUP(AF101,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",0,ROUND(AJ101-0.04999,1)-AJ101+AM101)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF101,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",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'!AA102,'Price List'!AG102)","v":6.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA102*(1-W102)+0.004999,2)","v":6.95},null,"",6.95,{"$f":"+W102","v":0},{"$f":"+X102","v":6.95},{"$f":"(AG102-AC102)/AG102","v":0},null,1,{"$f":"SUM(AJ102:AL102)+AE102","v":6.95},null,null,{"$f":"ROUND(AC102/(1-VLOOKUP(AF102,Group,2,FALSE)),2)","v":6.95},{"$f":"IF(VLOOKUP(AF102,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ102,1)-AJ102,2),Round,2,FALSE)+VLOOKUP(AF102,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",0,ROUND(AJ102-0.04999,1)-AJ102+AM102)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF102,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA104,'Price List'!AG104)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA104*(1-W104)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W104","v":0},{"$f":"+X104","v":18.7},{"$f":"(AG104-AC104)/AG104","v":0},null,3,{"$f":"SUM(AJ104:AL104)+AE104","v":18.7},null,null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":18.7},{"$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,"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'!AA105,'Price List'!AG105)","v":20.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA105*(1-W105)+0.004999,2)","v":20.3},null,"",20.3,{"$f":"+W105","v":0},{"$f":"+X105","v":20.3},{"$f":"(AG105-AC105)/AG105","v":0},null,3,{"$f":"SUM(AJ105:AL105)+AE105","v":20.3},null,null,{"$f":"ROUND(AC105/(1-VLOOKUP(AF105,Group,2,FALSE)),2)","v":20.3},{"$f":"IF(VLOOKUP(AF105,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ105,1)-AJ105,2),Round,2,FALSE)+VLOOKUP(AF105,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",0,ROUND(AJ105-0.04999,1)-AJ105+AM105)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF105,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'!AA107,'Price List'!AG107)","v":15.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA107*(1-W107)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W107","v":0},{"$f":"+X107","v":15.3},{"$f":"(AG107-AC107)/AG107","v":0},null,2,{"$f":"SUM(AJ107:AL107)+AE107","v":15.3},null,null,{"$f":"ROUND(AC107/(1-VLOOKUP(AF107,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF107,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ107,1)-AJ107,2),Round,2,FALSE)+VLOOKUP(AF107,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF107,Group,7,FALSE)=\"\",0,ROUND(AJ107-0.04999,1)-AJ107+AM107)","v":0},{"$f":"IF(VLOOKUP(AF107,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF107,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'!AA109,'Price List'!AG109)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA109*(1-W109)+0.004999,2)","v":10.85},null,"",10.85,{"$f":"+W109","v":0},10.85,{"$f":"(AG109-AC109)/AG109","v":0},null,1,{"$f":"SUM(AJ109:AL109)+AE109","v":10.85},null,null,{"$f":"ROUND(AC109/(1-VLOOKUP(AF109,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF109,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ109,1)-AJ109,2),Round,2,FALSE)+VLOOKUP(AF109,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF109,Group,7,FALSE)=\"\",0,ROUND(AJ109-0.04999,1)-AJ109+AM109)","v":0},{"$f":"IF(VLOOKUP(AF109,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF109,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'!AA110,'Price List'!AG110)","v":9.5500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA110*(1-W110)+0.004999,2)","v":9.5500000000000007},null,"",9.5500000000000007,0,9.5500000000000007,{"$f":"(AG110-AC110)/AG110","v":0},null,1,{"$f":"SUM(AJ110:AL110)+AE110","v":9.5500000000000007},null,null,{"$f":"ROUND(AC110/(1-VLOOKUP(AF110,Group,2,FALSE)),2)","v":9.5500000000000007},{"$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,"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'!AA111,'Price List'!AG111)","v":11.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA111*(1-W111)+0.004999,2)","v":11.3},null,"",11.3,0,11.3,{"$f":"(AG111-AC111)/AG111","v":0},null,1,{"$f":"SUM(AJ111:AL111)+AE111","v":11.3},null,null,{"$f":"ROUND(AC111/(1-VLOOKUP(AF111,Group,2,FALSE)),2)","v":11.3},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA113,'Price List'!AG113)","v":22.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA113*(1-W113)+0.004999,2)","v":22.15},null,"",22.15,{"$f":"+W113","v":0},22.15,{"$f":"(AG113-AC113)/AG113","v":0},null,3,{"$f":"SUM(AJ113:AL113)+AE113","v":22.15},null,null,{"$f":"ROUND(AC113/(1-VLOOKUP(AF113,Group,2,FALSE)),2)","v":22.15},{"$f":"IF(VLOOKUP(AF113,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ113,1)-AJ113,2),Round,2,FALSE)+VLOOKUP(AF113,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",0,ROUND(AJ113-0.04999,1)-AJ113+AM113)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF113,Group,7,FALSE))","v":""},null,"X"]
[null,"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'!AA114,'Price List'!AG114)","v":40.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA114*(1-W114)+0.004999,2)","v":40.15},null,"",40.15,0,40.15,{"$f":"(AG114-AC114)/AG114","v":0},null,3,{"$f":"SUM(AJ114:AL114)+AE114","v":40.15},null,null,{"$f":"ROUND(AC114/(1-VLOOKUP(AF114,Group,2,FALSE)),2)","v":40.15},{"$f":"IF(VLOOKUP(AF114,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ114,1)-AJ114,2),Round,2,FALSE)+VLOOKUP(AF114,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF114,Group,7,FALSE)=\"\",0,ROUND(AJ114-0.04999,1)-AJ114+AM114)","v":0},{"$f":"IF(VLOOKUP(AF114,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF114,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'!AA115,'Price List'!AG115)","v":34.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA115*(1-W115)+0.004999,2)","v":34.1},null,"",34.1,0,34.1,{"$f":"(AG115-AC115)/AG115","v":0},null,3,{"$f":"SUM(AJ115:AL115)+AE115","v":34.1},null,null,{"$f":"ROUND(AC115/(1-VLOOKUP(AF115,Group,2,FALSE)),2)","v":34.1},{"$f":"IF(VLOOKUP(AF115,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ115,1)-AJ115,2),Round,2,FALSE)+VLOOKUP(AF115,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,7,FALSE)=\"\",0,ROUND(AJ115-0.04999,1)-AJ115+AM115)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF115,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'!AA117,'Price List'!AG117)","v":17.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA117*(1-W117)+0.004999,2)","v":17.05},null,"",17.05,{"$f":"+W117","v":0},{"$f":"+X117","v":17.05},{"$f":"(AG117-AC117)/AG117","v":0},null,2,{"$f":"SUM(AJ117:AL117)+AE117","v":17.05},null,null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":17.05},{"$f":"IF(VLOOKUP(AF117,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ117,1)-AJ117,2),Round,2,FALSE)+VLOOKUP(AF117,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",0,ROUND(AJ117-0.04999,1)-AJ117+AM117)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF117,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA121,'Price List'!AG121)","v":8.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA121*(1-W121)+0.004999,2)","v":8.9},null,"",8.9,{"$f":"+W121","v":0},{"$f":"+X121","v":8.9},{"$f":"(AG121-AC121)/AG121","v":0},null,1,{"$f":"SUM(AJ121:AL121)+AE121","v":8.9},null,null,{"$f":"ROUND(AC121/(1-VLOOKUP(AF121,Group,2,FALSE)),2)","v":8.9},{"$f":"IF(VLOOKUP(AF121,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ121,1)-AJ121,2),Round,2,FALSE)+VLOOKUP(AF121,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",0,ROUND(AJ121-0.04999,1)-AJ121+AM121)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF121,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'!AA122,'Price List'!AG122)","v":6.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA122*(1-W122)+0.004999,2)","v":6.95},null,"",6.95,{"$f":"+W122","v":0},{"$f":"+X122","v":6.95},{"$f":"(AG122-AC122)/AG122","v":0},null,1,{"$f":"SUM(AJ122:AL122)+AE122","v":6.95},null,null,{"$f":"ROUND(AC122/(1-VLOOKUP(AF122,Group,2,FALSE)),2)","v":6.95},{"$f":"IF(VLOOKUP(AF122,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ122,1)-AJ122,2),Round,2,FALSE)+VLOOKUP(AF122,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,7,FALSE)=\"\",0,ROUND(AJ122-0.04999,1)-AJ122+AM122)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF122,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA124,'Price List'!AG124)","v":18.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA124*(1-W124)+0.004999,2)","v":18.7},null,"",18.7,{"$f":"+W124","v":0},{"$f":"+X124","v":18.7},{"$f":"(AG124-AC124)/AG124","v":0},null,3,{"$f":"SUM(AJ124:AL124)+AE124","v":18.7},null,null,{"$f":"ROUND(AC124/(1-VLOOKUP(AF124,Group,2,FALSE)),2)","v":18.7},{"$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,"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'!AA126,'Price List'!AG126)","v":15.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA126*(1-W126)+0.004999,2)","v":15.3},null,"",15.3,{"$f":"+W126","v":0},{"$f":"+X126","v":15.3},{"$f":"(AG126-AC126)/AG126","v":0},null,2,{"$f":"SUM(AJ126:AL126)+AE126","v":15.3},null,null,{"$f":"ROUND(AC126/(1-VLOOKUP(AF126,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF126,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ126,1)-AJ126,2),Round,2,FALSE)+VLOOKUP(AF126,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",0,ROUND(AJ126-0.04999,1)-AJ126+AM126)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF126,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA128,'Price List'!AG128)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA128*(1-W128)+0.004999,2)","v":10.85},null,"",10.85,{"$f":"+W128","v":0},10.85,{"$f":"(AG128-AC128)/AG128","v":0},null,1,{"$f":"SUM(AJ128:AL128)+AE128","v":10.85},null,null,{"$f":"ROUND(AC128/(1-VLOOKUP(AF128,Group,2,FALSE)),2)","v":10.85},{"$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":9.5500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA129*(1-W129)+0.004999,2)","v":9.5500000000000007},null,"",9.5500000000000007,0,9.5500000000000007,{"$f":"(AG129-AC129)/AG129","v":0},null,1,{"$f":"SUM(AJ129:AL129)+AE129","v":9.5500000000000007},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":9.5500000000000007},{"$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,"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'!AA130,'Price List'!AG130)","v":11.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA130*(1-W130)+0.004999,2)","v":11.3},null,"",11.3,0,11.3,{"$f":"(AG130-AC130)/AG130","v":0},null,1,{"$f":"SUM(AJ130:AL130)+AE130","v":11.3},null,null,{"$f":"ROUND(AC130/(1-VLOOKUP(AF130,Group,2,FALSE)),2)","v":11.3},{"$f":"IF(VLOOKUP(AF130,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ130,1)-AJ130,2),Round,2,FALSE)+VLOOKUP(AF130,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,7,FALSE)=\"\",0,ROUND(AJ130-0.04999,1)-AJ130+AM130)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF130,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'!AA132,'Price List'!AG132)","v":17.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA132*(1-W132)+0.004999,2)","v":17.05},null,"",17.05,{"$f":"+W132","v":0},{"$f":"+X132","v":17.05},{"$f":"(AG132-AC132)/AG132","v":0},null,2,{"$f":"SUM(AJ132:AL132)+AE132","v":17.05},null,null,{"$f":"ROUND(AC132/(1-VLOOKUP(AF132,Group,2,FALSE)),2)","v":17.05},{"$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,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'!AA136,'Price List'!AG136)","v":9.5500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA136*(1-W136)+0.004999,2)","v":9.5500000000000007},null,"",9.5500000000000007,{"$f":"+W136","v":0},{"$f":"+X136","v":9.5500000000000007},{"$f":"(AG136-AC136)/AG136","v":0},null,1,{"$f":"SUM(AJ136:AL136)+AE136","v":9.5500000000000007},null,null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":9.5500000000000007},{"$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,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,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:","Avorio          Beige          Grigio Chiaro          Antracite & Tabacco (DISCONTINUED 11/4/24)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA142,'Price List'!AG142)","v":9.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA142*(1-W142)+0.004999,2)","v":9.15},null,"",9.15,{"$f":"+W142","v":0},{"$f":"+X142","v":9.15},{"$f":"(AG142-AC142)/AG142","v":0},null,1,{"$f":"SUM(AJ142:AL142)+AE142","v":9.15},null,null,{"$f":"ROUND(AC142/(1-VLOOKUP(AF142,Group,2,FALSE)),2)","v":9.15},{"$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,"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'!AA143,'Price List'!AG143)","v":7.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.05,null,"",7.05,0,7.05,0,null,1,7.05,null,null,7.05,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'!AA144,'Price List'!AG144)","v":7.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.2,null,"",7.2,0,7.2,0,null,1,7.2,null,null,7.2,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,"       DISCONTINUED 11/4/2024",null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA145,'Price List'!AG145)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA147,'Price List'!AG147)","v":9.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.4,null,"",9.4,0,9.4,0,null,1,9.4,null,null,9.4,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'!AA148,'Price List'!AG148)","v":7.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.8,null,"",7.8,0,7.8,0,null,1,7.8,null,null,7.8,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'!AA149,'Price List'!AG149)","v":7.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.65,null,"",7.65,0,7.65,0,null,1,7.65,null,null,7.65,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'!AA151,'Price List'!AG151)","v":25.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA151*(1-W151)+0.004999,2)","v":25.9},null,"",25.9,{"$f":"+W151","v":0},{"$f":"+X151","v":25.9},{"$f":"(AG151-AC151)/AG151","v":0},null,3,{"$f":"SUM(AJ151:AL151)+AE151","v":25.9},null,null,{"$f":"ROUND(AC151/(1-VLOOKUP(AF151,Group,2,FALSE)),2)","v":25.9},{"$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,"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'!AA152,'Price List'!AG152)","v":8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA152*(1-W152)+0.004999,2)","v":8},null,"",8,{"$f":"+W152","v":0},{"$f":"+X152","v":8},{"$f":"(AG152-AC152)/AG152","v":0},null,3,{"$f":"SUM(AJ152:AL152)+AE152","v":8},null,null,{"$f":"ROUND(AC152/(1-VLOOKUP(AF152,Group,2,FALSE)),2)","v":8},{"$f":"IF(VLOOKUP(AF152,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ152,1)-AJ152,2),Round,2,FALSE)+VLOOKUP(AF152,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",0,ROUND(AJ152-0.04999,1)-AJ152+AM152)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF152,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA154,'Price List'!AG154)","v":19.600000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA154*(1-W154)+0.004999,2)","v":19.600000000000001},null,"",19.600000000000001,{"$f":"+W154","v":0},19.600000000000001,{"$f":"(AG154-AC154)/AG154","v":0},null,3,{"$f":"SUM(AJ154:AL154)+AE154","v":19.600000000000001},null,null,{"$f":"ROUND(AC154/(1-VLOOKUP(AF154,Group,2,FALSE)),2)","v":19.600000000000001},{"$f":"IF(VLOOKUP(AF154,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ154,1)-AJ154,2),Round,2,FALSE)+VLOOKUP(AF154,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",0,ROUND(AJ154-0.04999,1)-AJ154+AM154)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF154,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'!AA155,'Price List'!AG155)","v":18.850000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA155*(1-W155)+0.004999,2)","v":18.850000000000001},null,"",18.850000000000001,0,18.850000000000001,{"$f":"(AG155-AC155)/AG155","v":0},null,3,{"$f":"SUM(AJ155:AL155)+AE155","v":18.850000000000001},null,null,{"$f":"ROUND(AC155/(1-VLOOKUP(AF155,Group,2,FALSE)),2)","v":18.850000000000001},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA157,'Price List'!AG157)","v":7.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":7.2},null,"",7.2,{"$f":"+W157","v":0},{"$f":"+X157","v":7.2},{"$f":"(AG157-AC157)/AG157","v":0},null,2,{"$f":"SUM(AJ157:AL157)+AE157","v":7.2},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":7.2},{"$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,"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'!AA158,'Price List'!AG158)","v":23.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA158*(1-W158)+0.004999,2)","v":23.6},null,"",23.6,{"$f":"+W158","v":0},{"$f":"+X158","v":23.6},{"$f":"(AG158-AC158)/AG158","v":0},null,2,{"$f":"SUM(AJ158:AL158)+AE158","v":23.6},null,null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":23.6},{"$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,null,null,"Notes:","a) Not available in color 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,"URBE - Glazed Porcelain",null,null,null,null,null,null,null," "," "," ",null,null,null,null,"Item # Lookup:","NVUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Cream          Silver          White 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,"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'!AA166,'Price List'!AG166)","v":9.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":9.5},null,"",9.5,{"$f":"+W166","v":0},{"$f":"+X166","v":9.5},{"$f":"(AG166-AC166)/AG166","v":0},null,1,{"$f":"SUM(AJ166:AL166)+AE166","v":9.5},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":9.5},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ166,1)-AJ166,2),Round,2,FALSE)+VLOOKUP(AF166,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",0,ROUND(AJ166-0.04999,1)-AJ166+AM166)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF166,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"13.56 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA167,'Price List'!AG167)","v":5.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},5.95,null,"",5.95,0,5.95,0,null,1,5.95,null,null,5.95,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'!AA168,'Price List'!AG168)","v":6.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},6.4,null,"",6.4,0,6.4,0,null,1,6.4,null,null,6.4,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'!AA169,'Price List'!AG169)","v":7.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.15,null,"",7.15,0,7.15,0,null,1,7.15,null,null,7.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,"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'!AA171,'Price List'!AG171)","v":17.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA171*(1-W171)+0.004999,2)","v":17.5},null,"",17.5,{"$f":"+W171","v":0},{"$f":"+X171","v":17.5},{"$f":"(AG171-AC171)/AG171","v":0},null,3,{"$f":"SUM(AJ171:AL171)+AE171","v":17.5},null,null,{"$f":"ROUND(AC171/(1-VLOOKUP(AF171,Group,2,FALSE)),2)","v":17.5},{"$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,"Decos",null,null,"12\" x 13.3\"",null,"Mosaic",null,"3\" Hexagon",null,"mesh-mounted",null,null,null,null,"1.10 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA172,'Price List'!AG172)","v":34.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA172*(1-W172)+0.004999,2)","v":34.35},null,"",34.35,{"$f":"+W172","v":0},{"$f":"+X172","v":34.35},{"$f":"(AG172-AC172)/AG172","v":0},null,3,{"$f":"SUM(AJ172:AL172)+AE172","v":34.35},null,null,{"$f":"ROUND(AC172/(1-VLOOKUP(AF172,Group,2,FALSE)),2)","v":34.35},{"$f":"IF(VLOOKUP(AF172,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ172,1)-AJ172,2),Round,2,FALSE)+VLOOKUP(AF172,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",0,ROUND(AJ172-0.04999,1)-AJ172+AM172)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF172,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Basket Weave",null,"mesh-mounted (0.97 SF/Sheet)",null,null,null,null,"9.70 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA173,'Price List'!AG173)","v":18.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA173*(1-W173)+0.004999,2)","v":18.95},null,"",18.95,{"$f":"+W173","v":0},{"$f":"+X173","v":18.95},{"$f":"(AG173-AC173)/AG173","v":0},null,3,{"$f":"SUM(AJ173:AL173)+AE173","v":18.95},null,null,{"$f":"ROUND(AC173/(1-VLOOKUP(AF173,Group,2,FALSE)),2)","v":18.95},{"$f":"IF(VLOOKUP(AF173,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ173,1)-AJ173,2),Round,2,FALSE)+VLOOKUP(AF173,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF173,Group,7,FALSE)=\"\",0,ROUND(AJ173-0.04999,1)-AJ173+AM173)","v":0},{"$f":"IF(VLOOKUP(AF173,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF173,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"11\" x 11\"",null,"Mosaic",null,"Herringbone",null,"mesh-mounted",null,null,null,null,"0.84 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA174,'Price List'!AG174)","v":25.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},25.1,null,"",25.1,0,25.1,0,null,3,25.1,null,null,25.1,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,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
[null,null,"The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom.  Print out individual price list for each series that can be attached to the back of your sample boards for easy reference."]
[]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[]
[null,null,null,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2,null,null,null,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/"]
["EXTRA","https://www.novabell.it/en/collections/extra/"]
["MICHELANGELO (DISC 10/23/24)","https://www.novabell.it/en/collections/imperial-michelangelo/"]
["SOVEREIGN","https://www.novabell.it/en/collections/sovereign/"]
["URBE"]

{"sheet":"Changes","index":4,"n_rows":33,"n_cols":4,"rows_kept":33,"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"]
["2024-02-01","Extra","Glazed Porcelain"]
["2024-09-01","Urbe","Glazed Porcelain"]
[]
[]
["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) - Disc. by Novabell 12/31/24!"]
["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)"]
["2024-09-05","Aspen","8\" x 48\" Field Tile format only in all colors."]
["2024-09-05","Sovereign","2\" x 4\" 3D and 3\" x 3\" 3D Mosaics only in all colors."]
["2024-10-23","Michelangelo","Entire Series.  (Discontinued by Novabell)"]
["2024-11-04","Extra","36\" x 36\" and 36\" x 72\" Field Tile formats only in all colors.","  (Discontinued by Novabell)"]
["2024-11-04","Sovereign","24\" x 48\" Field Tile format only in all colors.  Colors Antracite and Tabacco only in all formats.","  (Discontinued by Novabell)"]