{"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","10/1/25 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"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,"  "]
[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 - 10/1/25 (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"]
["1-2",null,"Sovereign Disc (10/29/2025)",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":186,"n_cols":41,"rows_kept":186,"cut":false,"hidden":false,"merged":[[12,14,12,19],[175,3,175,4],[18,2,18,19],[17,14,17,15],[19,2,19,19],[169,2,169,19],[14,13,15,19],[10,14,10,15],[9,14,9,19],[171,2,171,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":"10/1/25 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-10-29"},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":9.3000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA26*(1-W26)+0.004999,2)","v":9.3000000000000007},null,"YES",9.3000000000000007,{"$f":"+W26","v":0},9.3000000000000007,{"$f":"(AG26-AC26)/AG26","v":0},null,1,{"$f":"SUM(AJ26:AL26)+AE26","v":9.3000000000000007},null,null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":9.3000000000000007},{"$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":7.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.2,null,"YES",7.2,0,7.2,0,null,1,7.2,null,null,7.2,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":15.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.5,null,"YES",15.5,0,15.5,0,null,1,15.5,null,null,15.5,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.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.6,null,"YES",7.6,0,7.6,0,null,1,7.6,null,null,7.6,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.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.85,null,"YES",7.85,0,7.85,0,null,1,7.85,null,null,7.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,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA31,'Price List'!AG31)","v":8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8,null,"YES",8,0,8,0,null,1,8,null,null,8,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":8.3000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.3000000000000007,null,"YES",8.3000000000000007,0,8.3000000000000007,0,null,1,8.3000000000000007,null,null,8.3000000000000007,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":19.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA34*(1-W34)+0.004999,2)","v":19.75},null,"YES",19.75,{"$f":"+W34","v":0},19.75,{"$f":"(AG34-AC34)/AG34","v":0},null,3,{"$f":"SUM(AJ34:AL34)+AE34","v":19.75},null,null,{"$f":"ROUND(AC34/(1-VLOOKUP(AF34,Group,2,FALSE)),2)","v":19.75},{"$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":44.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":44.35},null,"YES",44.35,0,44.35,{"$f":"(AG35-AC35)/AG35","v":0},null,3,{"$f":"SUM(AJ35:AL35)+AE35","v":44.35},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":44.35},{"$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":44.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":44.35},null,"YES",44.35,0,44.35,{"$f":"(AG36-AC36)/AG36","v":0},null,3,{"$f":"SUM(AJ36:AL36)+AE36","v":44.35},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":44.35},{"$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":44.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":44.35},null,"YES",44.35,0,44.35,{"$f":"(AG37-AC37)/AG37","v":0},null,3,{"$f":"SUM(AJ37:AL37)+AE37","v":44.35},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":44.35},{"$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":27.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":27.8},null,"YES",27.8,0,27.8,{"$f":"(AG38-AC38)/AG38","v":0},null,3,{"$f":"SUM(AJ38:AL38)+AE38","v":27.8},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":27.8},{"$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,"15 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA40,'Price List'!AG40)","v":17.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA40*(1-W40)+0.004999,2)","v":17.8},null,"YES",17.8,{"$f":"+W40","v":0},{"$f":"+X40","v":17.8},{"$f":"(AG40-AC40)/AG40","v":0},null,2,{"$f":"SUM(AJ40:AL40)+AE40","v":17.8},null,null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":17.8},{"$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":34.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA45*(1-W45)+0.004999,2)","v":34.9},null,"YES",34.9,{"$f":"+W45","v":0},{"$f":"+X45","v":34.9},{"$f":"(AG45-AC45)/AG45","v":0},null,3,{"$f":"SUM(AJ45:AL45)+AE45","v":34.9},null,null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":34.9},{"$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":7.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA54*(1-W54)+0.004999,2)","v":7.4},null,"YES",7.4,{"$f":"+W54","v":0},{"$f":"+X54","v":7.4},{"$f":"(AG54-AC54)/AG54","v":0},null,1,{"$f":"SUM(AJ54:AL54)+AE54","v":7.4},null,null,{"$f":"ROUND(AC54/(1-VLOOKUP(AF54,Group,2,FALSE)),2)","v":7.4},{"$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":55.95},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":55.95},null,"YES",55.95,{"$f":"+W56","v":0},{"$f":"+X56","v":55.95},{"$f":"(AG56-AC56)/AG56","v":0},null,3,{"$f":"SUM(AJ56:AL56)+AE56","v":55.95},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":55.95},{"$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":10.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA63*(1-W63)+0.004999,2)","v":10.1},null,"YES",10.1,{"$f":"+W63","v":0},{"$f":"+X63","v":10.1},{"$f":"(AG63-AC63)/AG63","v":0},null,1,{"$f":"SUM(AJ63:AL63)+AE63","v":10.1},null,null,{"$f":"ROUND(AC63/(1-VLOOKUP(AF63,Group,2,FALSE)),2)","v":10.1},{"$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":7.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.2,null,"YES",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'!AA65,'Price List'!AG65)","v":7.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.8,null,"YES",7.8,0,7.8,0,null,1,7.8,null,null,7.8,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.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.8000000000000007,null,"YES",8.8000000000000007,0,8.8000000000000007,0,null,1,8.8000000000000007,null,null,8.8000000000000007,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":18.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA68*(1-W68)+0.004999,2)","v":18.2},null,"YES",18.2,{"$f":"+W68","v":0},{"$f":"+X68","v":18.2},{"$f":"(AG68-AC68)/AG68","v":0},null,3,{"$f":"SUM(AJ68:AL68)+AE68","v":18.2},null,null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":18.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":24.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},24.75,null,"YES",24.75,0,24.75,0,null,3,24.75,null,null,24.75,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":16.149999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":16.149999999999999},null,"YES",16.149999999999999,{"$f":"+W71","v":0},{"$f":"+X71","v":16.149999999999999},{"$f":"(AG71-AC71)/AG71","v":0},null,2,{"$f":"SUM(AJ71:AL71)+AE71","v":16.149999999999999},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":16.149999999999999},{"$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":11.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":11.5},null,"YES",11.5,{"$f":"+W76","v":0},{"$f":"+X76","v":11.5},{"$f":"(AG76-AC76)/AG76","v":0},null,1,{"$f":"SUM(AJ76:AL76)+AE76","v":11.5},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":11.5},{"$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":9.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.35,null,"YES",9.35,0,9.35,0,null,1,9.35,null,null,9.35,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":10},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10,null,"YES",10,0,10,0,null,1,10,null,null,10,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":11},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11,null,"YES",11,0,11,0,null,1,11,null,null,11,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'!AA81,'Price List'!AG81)","v":19.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA81*(1-W81)+0.004999,2)","v":19.95},null,"YES",19.95,{"$f":"+W81","v":0},{"$f":"+X81","v":19.95},{"$f":"(AG81-AC81)/AG81","v":0},null,3,{"$f":"SUM(AJ81:AL81)+AE81","v":19.95},null,null,{"$f":"ROUND(AC81/(1-VLOOKUP(AF81,Group,2,FALSE)),2)","v":19.95},{"$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,"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'!AA82,'Price List'!AG82)","v":36.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},36.65,null,"YES",36.65,0,36.65,0,null,3,36.65,null,null,36.65,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","b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA83,'Price List'!AG83)","v":42.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA83*(1-W83)+0.004999,2)","v":42.1},null,"YES",42.1,{"$f":"+W83","v":0},{"$f":"+X83","v":42.1},{"$f":"(AG83-AC83)/AG83","v":0},null,3,{"$f":"SUM(AJ83:AL83)+AE83","v":42.1},null,null,{"$f":"ROUND(AC83/(1-VLOOKUP(AF83,Group,2,FALSE)),2)","v":42.1},{"$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,"12\" x 12\"",null,"Mosaic",null,"Intreccio Basketweave",null,null,null,null,null,null,".97 SF/Sheet","Stock","b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA84,'Price List'!AG84)","v":27.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},27.55,null,"YES",27.55,0,27.55,0,null,3,27.55,null,null,27.55,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","b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA85,'Price List'!AG85)","v":26.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},26.35,null,"YES",26.35,0,26.35,0,null,3,26.35,null,null,26.35,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'!AA86,'Price List'!AG86)","v":27.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA86*(1-W86)+0.004999,2)","v":27.55},null,"YES",27.55,{"$f":"+W86","v":0},{"$f":"+X86","v":27.55},{"$f":"(AG86-AC86)/AG86","v":0},null,3,{"$f":"SUM(AJ86:AL86)+AE86","v":27.55},null,null,{"$f":"ROUND(AC86/(1-VLOOKUP(AF86,Group,2,FALSE)),2)","v":27.55},{"$f":"IF(VLOOKUP(AF86,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ86,1)-AJ86,2),Round,2,FALSE)+VLOOKUP(AF86,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",0,ROUND(AJ86-0.04999,1)-AJ86+AM86)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF86,Group,7,FALSE))","v":""},null,"X"]
[null,"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'!AA87,'Price List'!AG87)","v":39.200000000000003},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA87*(1-W87)+0.004999,2)","v":39.200000000000003},null,"YES",39.200000000000003,{"$f":"+W87","v":0},{"$f":"+X87","v":39.200000000000003},{"$f":"(AG87-AC87)/AG87","v":0},null,3,{"$f":"SUM(AJ87:AL87)+AE87","v":39.200000000000003},null,null,{"$f":"ROUND(AC87/(1-VLOOKUP(AF87,Group,2,FALSE)),2)","v":39.200000000000003},{"$f":"IF(VLOOKUP(AF87,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ87,1)-AJ87,2),Round,2,FALSE)+VLOOKUP(AF87,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF87,Group,7,FALSE)=\"\",0,ROUND(AJ87-0.04999,1)-AJ87+AM87)","v":0},{"$f":"IF(VLOOKUP(AF87,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF87,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'!AA89,'Price List'!AG89)","v":18},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":18},null,"YES",18,{"$f":"+W89","v":0},{"$f":"+X89","v":18},{"$f":"(AG89-AC89)/AG89","v":0},null,2,{"$f":"SUM(AJ89:AL89)+AE89","v":18},null,null,{"$f":"ROUND(AC89/(1-VLOOKUP(AF89,Group,2,FALSE)),2)","v":18},{"$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,null,null,"Notes:","a) Not stocked in color Scenic White."]
[null,null,null,null,"b) Not stocked in colors Marquina Shiny and Scenic White."]
[]
[null,null,"SOVEREIGN - Glazed Porcelain",null,null,null,null,null,null,null,"DISCONTINUED 10/29/25",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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA98,'Price List'!AG98)","v":9.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA98*(1-W98)+0.004999,2)","v":9.65},null,"YES",9.65,{"$f":"+W98","v":0},{"$f":"+X98","v":9.65},{"$f":"(AG98-AC98)/AG98","v":0},null,1,{"$f":"SUM(AJ98:AL98)+AE98","v":9.65},null,null,{"$f":"ROUND(AC98/(1-VLOOKUP(AF98,Group,2,FALSE)),2)","v":9.65},{"$f":"IF(VLOOKUP(AF98,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ98,1)-AJ98,2),Round,2,FALSE)+VLOOKUP(AF98,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",0,ROUND(AJ98-0.04999,1)-AJ98+AM98)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF98,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'!AA99,'Price List'!AG99)","v":7.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.45,null,"YES",7.45,0,7.45,0,null,1,7.45,null,null,7.45,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'!AA100,'Price List'!AG100)","v":7.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.6,null,"YES",7.6,0,7.6,0,null,1,7.6,null,null,7.6,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'!AA102,'Price List'!AG102)","v":9.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.9499999999999993,null,"YES",9.9499999999999993,0,9.9499999999999993,0,null,1,9.9499999999999993,null,null,9.9499999999999993,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'!AA103,'Price List'!AG103)","v":8.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.25,null,"YES",8.25,0,8.25,0,null,1,8.25,null,null,8.25,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'!AA104,'Price List'!AG104)","v":8.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.1,null,"YES",8.1,0,8.1,0,null,1,8.1,null,null,8.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,"continued on next page"]
[null,null,"SOVEREIGN - Glazed Porcelain - continued",null,null,null,null,null,null,null,"DISCONTINUED 10/29/25",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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA111,'Price List'!AG111)","v":27.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA111*(1-W111)+0.004999,2)","v":27.35},null,"YES",27.35,{"$f":"+W111","v":0},{"$f":"+X111","v":27.35},{"$f":"(AG111-AC111)/AG111","v":0},null,3,{"$f":"SUM(AJ111:AL111)+AE111","v":27.35},null,null,{"$f":"ROUND(AC111/(1-VLOOKUP(AF111,Group,2,FALSE)),2)","v":27.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,"16\" x 32\"",null,"Deco Dune",null,null,null,"(3.44 SF/Piece)",null,null,null,null,"10.32 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA112,'Price List'!AG112)","v":8.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA112*(1-W112)+0.004999,2)","v":8.5},null,"YES",8.5,{"$f":"+W112","v":0},{"$f":"+X112","v":8.5},{"$f":"(AG112-AC112)/AG112","v":0},null,3,{"$f":"SUM(AJ112:AL112)+AE112","v":8.5},null,null,{"$f":"ROUND(AC112/(1-VLOOKUP(AF112,Group,2,FALSE)),2)","v":8.5},{"$f":"IF(VLOOKUP(AF112,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ112,1)-AJ112,2),Round,2,FALSE)+VLOOKUP(AF112,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",0,ROUND(AJ112-0.04999,1)-AJ112+AM112)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF112,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA114,'Price List'!AG114)","v":20.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA114*(1-W114)+0.004999,2)","v":20.7},null,"YES",20.7,{"$f":"+W114","v":0},20.7,{"$f":"(AG114-AC114)/AG114","v":0},null,3,{"$f":"SUM(AJ114:AL114)+AE114","v":20.7},null,null,{"$f":"ROUND(AC114/(1-VLOOKUP(AF114,Group,2,FALSE)),2)","v":20.7},{"$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 12\"",null,"Mosaic",null,"2\" x 2\"",null,"mesh-mounted",null,null,null,null,"9.70 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA115,'Price List'!AG115)","v":19.899999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA115*(1-W115)+0.004999,2)","v":19.899999999999999},null,"YES",19.899999999999999,0,19.899999999999999,{"$f":"(AG115-AC115)/AG115","v":0},null,3,{"$f":"SUM(AJ115:AL115)+AE115","v":19.899999999999999},null,null,{"$f":"ROUND(AC115/(1-VLOOKUP(AF115,Group,2,FALSE)),2)","v":19.899999999999999},{"$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,"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'!AA117,'Price List'!AG117)","v":7.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA117*(1-W117)+0.004999,2)","v":7.6},null,"YES",7.6,{"$f":"+W117","v":0},{"$f":"+X117","v":7.6},{"$f":"(AG117-AC117)/AG117","v":0},null,2,{"$f":"SUM(AJ117:AL117)+AE117","v":7.6},null,null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":7.6},{"$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,"Trim",null,null,"2.8\" x 32\"",null,"Bullnose",null,null,null,null,null,null,null,null,"8 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA118,'Price List'!AG118)","v":24.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA118*(1-W118)+0.004999,2)","v":24.9},null,"YES",24.9,{"$f":"+W118","v":0},{"$f":"+X118","v":24.9},{"$f":"(AG118-AC118)/AG118","v":0},null,2,{"$f":"SUM(AJ118:AL118)+AE118","v":24.9},null,null,{"$f":"ROUND(AC118/(1-VLOOKUP(AF118,Group,2,FALSE)),2)","v":24.9},{"$f":"IF(VLOOKUP(AF118,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ118,1)-AJ118,2),Round,2,FALSE)+VLOOKUP(AF118,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",0,ROUND(AJ118-0.04999,1)-AJ118+AM118)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF118,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,"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'!AA124,'Price List'!AG124)","v":10.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA124*(1-W124)+0.004999,2)","v":10.1},null,"YES",10.1,{"$f":"+W124","v":0},{"$f":"+X124","v":10.1},{"$f":"(AG124-AC124)/AG124","v":0},null,1,{"$f":"SUM(AJ124:AL124)+AE124","v":10.1},null,null,{"$f":"ROUND(AC124/(1-VLOOKUP(AF124,Group,2,FALSE)),2)","v":10.1},{"$f":"IF(VLOOKUP(AF124,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ124,1)-AJ124,2),Round,2,FALSE)+VLOOKUP(AF124,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",0,ROUND(AJ124-0.04999,1)-AJ124+AM124)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF124,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",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'!AA125,'Price List'!AG125)","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'!AA126,'Price List'!AG126)","v":6.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},6.75,null,"YES",6.75,0,6.75,0,null,1,6.75,null,null,6.75,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'!AA127,'Price List'!AG127)","v":7.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.6,null,"YES",7.6,0,7.6,0,null,1,7.6,null,null,7.6,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'!AA129,'Price List'!AG129)","v":18.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA129*(1-W129)+0.004999,2)","v":18.5},null,"YES",18.5,{"$f":"+W129","v":0},{"$f":"+X129","v":18.5},{"$f":"(AG129-AC129)/AG129","v":0},null,3,{"$f":"SUM(AJ129:AL129)+AE129","v":18.5},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":18.5},{"$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,"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'!AA130,'Price List'!AG130)","v":36.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA130*(1-W130)+0.004999,2)","v":36.25},null,"YES",36.25,{"$f":"+W130","v":0},{"$f":"+X130","v":36.25},{"$f":"(AG130-AC130)/AG130","v":0},null,3,{"$f":"SUM(AJ130:AL130)+AE130","v":36.25},null,null,{"$f":"ROUND(AC130/(1-VLOOKUP(AF130,Group,2,FALSE)),2)","v":36.25},{"$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,"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'!AA131,'Price List'!AG131)","v":20},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA131*(1-W131)+0.004999,2)","v":20},null,"YES",20,{"$f":"+W131","v":0},{"$f":"+X131","v":20},{"$f":"(AG131-AC131)/AG131","v":0},null,3,{"$f":"SUM(AJ131:AL131)+AE131","v":20},null,null,{"$f":"ROUND(AC131/(1-VLOOKUP(AF131,Group,2,FALSE)),2)","v":20},{"$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,"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'!AA132,'Price List'!AG132)","v":26.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},26.55,null,"YES",26.55,0,26.55,0,null,3,26.55,null,null,26.55,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null," "]
[]
[]
[null,null,null," "]
[]
[]
[null,null,null," "]
[]
[]
[null,null,null," "]
[]
[]
[null,null,null," "]
[]
[]
[null,null,null," "]
[]
[]
[null,null,null," "]
[]
[]
[null,null,null," "]
[]
[]
[null,null,null," "]
[]
[]
[null,null,null," "]
[]
[]
[null,null,null," "]
[]
[]
[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":13,"n_cols":2,"rows_kept":13,"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/"]
["SOVEREIGN","https://www.novabell.it/en/collections/sovereign/"]
["URBE"]

{"sheet":"Changes","index":4,"n_rows":34,"n_cols":4,"rows_kept":34,"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)"]
["2025-10-29","Sovereign","Entire Series.  (Discontinued by Novabell)","  (Discontinued by Novabell)"]