{"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":8,"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","2/1/24"," "]
[]
[]
[]
["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,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 - 2/1/24"}]
[]
[]
[]
[]
["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-3",null,"Michelangelo",null,"Glazed Porcelain"]
[2,null,"Sovereign",null,"Glazed Porcelain"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
["The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom.  Print out individual price list for each series that can be attached to the back of your sample boards for easy reference."]

{"sheet":"Price List","index":2,"n_rows":196,"n_cols":41,"rows_kept":196,"cut":false,"hidden":false,"merged":[[9,25,9,32],[12,22,12,23],[9,22,9,23],[13,30,13,32],[12,14,12,19],[185,3,185,4],[18,2,18,19],[17,14,17,15],[19,2,19,19],[181,2,181,19],[14,13,15,19],[10,14,10,15],[9,14,9,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":"2/1/24"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-01-02"},null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!C8=\"\",\"\",+Instructions!C8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code 'B'"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$C$8=\"\",\"\",Instructions!$C$8)","v":""},null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"+S$11","v":"List Price"},"U/M",{"$f":"+U$11","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$11","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$11","v":"Group"},"Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,"ALL ITEMS MARKED WITH PACKAGING QUANTITY ARE SOLD IN MULTIPLES OF THAT QUANTITY ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"NON-Stock ITEMS - MINIMUM 6-8 WEEK DELIVERY"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"ASPEN - Glazed Porcelain",null,null,null,null,null,null,null," "," "," ",null,null,null,null,"Item # Lookup:","NVAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Basalt          Oxide          Rock Grey          Sand Moon          Snow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"9.04 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA26,'Price List'!AG26)","v":9.5500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA26*(1-W26)+0.004999,2)","v":9.5500000000000007},null,"YES",9.5500000000000007,{"$f":"+W26","v":0},9.5500000000000007,{"$f":"(AG26-AC26)/AG26","v":0},null,1,{"$f":"SUM(AJ26:AL26)+AE26","v":9.5500000000000007},null,null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":9.5500000000000007},{"$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.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.1,null,"YES",7.1,0,7.1,0,null,1,7.1,null,null,7.1,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":16.100000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},16.100000000000001,null,"YES",16.100000000000001,0,16.100000000000001,0,null,1,16.100000000000001,null,null,16.100000000000001,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.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 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.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.65,null,"YES",7.65,0,7.65,0,null,1,7.65,null,null,7.65,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.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,"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":9.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.5,null,"YES",9.5,0,9.5,0,null,1,9.5,null,null,9.5,0,0,"",null,"X"]
[null,"Field Tile",null,null,"8\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"10.33 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA33,'Price List'!AG33)","v":8.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA33*(1-W33)+0.004999,2)","v":8.85},null,"YES",8.85,{"$f":"+W33","v":0},{"$f":"+X33","v":8.85},{"$f":"(AG33-AC33)/AG33","v":0},null,1,{"$f":"SUM(AJ33:AL33)+AE33","v":8.85},null,null,{"$f":"ROUND(AC33/(1-VLOOKUP(AF33,Group,2,FALSE)),2)","v":8.85},{"$f":"IF(VLOOKUP(AF33,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ33,1)-AJ33,2),Round,2,FALSE)+VLOOKUP(AF33,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",0,ROUND(AJ33-0.04999,1)-AJ33+AM33)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF33,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,"mesh-mounted",null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA35,'Price List'!AG35)","v":20.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":20.6},null,"YES",20.6,{"$f":"+W35","v":0},20.6,{"$f":"(AG35-AC35)/AG35","v":0},null,3,{"$f":"SUM(AJ35:AL35)+AE35","v":20.6},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":20.6},{"$f":"IF(VLOOKUP(AF35,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ35,1)-AJ35,2),Round,2,FALSE)+VLOOKUP(AF35,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",0,ROUND(AJ35-0.04999,1)-AJ35+AM35)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF35,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Pebble (Sassi)",null,null,null,null,"mesh-mounted",null,"9.68 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA36,'Price List'!AG36)","v":49.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":49.95},null,"YES",49.95,0,49.95,{"$f":"(AG36-AC36)/AG36","v":0},null,3,{"$f":"SUM(AJ36:AL36)+AE36","v":49.95},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":49.95},{"$f":"IF(VLOOKUP(AF36,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ36,1)-AJ36,2),Round,2,FALSE)+VLOOKUP(AF36,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF36,Group,7,FALSE)=\"\",0,ROUND(AJ36-0.04999,1)-AJ36+AM36)","v":0},{"$f":"IF(VLOOKUP(AF36,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF36,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Pebble (Sassi) - Dark Mix (O-B-RG)",null,null,null,null,"mesh-mounted",null,"9.68 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA37,'Price List'!AG37)","v":49.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":49.95},null,"YES",49.95,0,49.95,{"$f":"(AG37-AC37)/AG37","v":0},null,3,{"$f":"SUM(AJ37:AL37)+AE37","v":49.95},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":49.95},{"$f":"IF(VLOOKUP(AF37,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ37,1)-AJ37,2),Round,2,FALSE)+VLOOKUP(AF37,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",0,ROUND(AJ37-0.04999,1)-AJ37+AM37)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF37,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Pebble (Sassi) - Light Mix (SM-S-RG)",null,null,null,null,"mesh-mounted",null,"9.68 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA38,'Price List'!AG38)","v":49.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":49.95},null,"YES",49.95,0,49.95,{"$f":"(AG38-AC38)/AG38","v":0},null,3,{"$f":"SUM(AJ38:AL38)+AE38","v":49.95},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":49.95},{"$f":"IF(VLOOKUP(AF38,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ38,1)-AJ38,2),Round,2,FALSE)+VLOOKUP(AF38,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,7,FALSE)=\"\",0,ROUND(AJ38-0.04999,1)-AJ38+AM38)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF38,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 24\"",null,"Mosaic",null,"Brick (Mattoncino)",null,null,null,null,"mesh-mounted",null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA39,'Price List'!AG39)","v":27.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA39*(1-W39)+0.004999,2)","v":27.8},null,"YES",27.8,0,27.8,{"$f":"(AG39-AC39)/AG39","v":0},null,3,{"$f":"SUM(AJ39:AL39)+AE39","v":27.8},null,null,{"$f":"ROUND(AC39/(1-VLOOKUP(AF39,Group,2,FALSE)),2)","v":27.8},{"$f":"IF(VLOOKUP(AF39,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ39,1)-AJ39,2),Round,2,FALSE)+VLOOKUP(AF39,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF39,Group,7,FALSE)=\"\",0,ROUND(AJ39-0.04999,1)-AJ39+AM39)","v":0},{"$f":"IF(VLOOKUP(AF39,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF39,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA41,'Price List'!AG41)","v":18.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA41*(1-W41)+0.004999,2)","v":18.7},null,"YES",18.7,{"$f":"+W41","v":0},{"$f":"+X41","v":18.7},{"$f":"(AG41-AC41)/AG41","v":0},null,2,{"$f":"SUM(AJ41:AL41)+AE41","v":18.7},null,null,{"$f":"ROUND(AC41/(1-VLOOKUP(AF41,Group,2,FALSE)),2)","v":18.7},{"$f":"IF(VLOOKUP(AF41,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ41,1)-AJ41,2),Round,2,FALSE)+VLOOKUP(AF41,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF41,Group,7,FALSE)=\"\",0,ROUND(AJ41-0.04999,1)-AJ41+AM41)","v":0},{"$f":"IF(VLOOKUP(AF41,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF41,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Basalt/Rock Grey",null,null," Rock Grey/Basalt",null,null,null,"         Snow/Rock Grey"]
[null,null,null,null,"Oxide/Sand Moon",null,null," Sand Moon/Rock Grey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Basketweave (Trama)",null,null,null,null,"mesh-mounted",null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA46,'Price List'!AG46)","v":36.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA46*(1-W46)+0.004999,2)","v":36.75},null,"YES",36.75,{"$f":"+W46","v":0},{"$f":"+X46","v":36.75},{"$f":"(AG46-AC46)/AG46","v":0},null,3,{"$f":"SUM(AJ46:AL46)+AE46","v":36.75},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":36.75},{"$f":"IF(VLOOKUP(AF46,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ46,1)-AJ46,2),Round,2,FALSE)+VLOOKUP(AF46,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",0,ROUND(AJ46-0.04999,1)-AJ46+AM46)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF46,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Note:","a) Stocked in colors Rock Grey, Sand Moon and Snow only.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"BRICKUP - Glazed Porcelain - 3D Brick Ledgerstone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","NVBR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Ocean Ardesia",null,"            Ocean Grey",null,null,null,null," Ocean White"]
[null,null,null,null,"Ocean Beige",null,"            Ocean Mix Quarzite"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"6-5/16\" x 15-3/4\"",null,"Field - Ledgerstone",null,null,null,null,null,null,null,null,"10.33 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA55,'Price List'!AG55)","v":7.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA55*(1-W55)+0.004999,2)","v":7.55},null,"YES",7.55,{"$f":"+W55","v":0},{"$f":"+X55","v":7.55},{"$f":"(AG55-AC55)/AG55","v":0},null,1,{"$f":"SUM(AJ55:AL55)+AE55","v":7.55},null,null,{"$f":"ROUND(AC55/(1-VLOOKUP(AF55,Group,2,FALSE)),2)","v":7.55},{"$f":"IF(VLOOKUP(AF55,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ55,1)-AJ55,2),Round,2,FALSE)+VLOOKUP(AF55,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF55,Group,7,FALSE)=\"\",0,ROUND(AJ55-0.04999,1)-AJ55+AM55)","v":0},{"$f":"IF(VLOOKUP(AF55,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF55,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"6-5/16\" x 11\" x 5-1/2\"",null,"Corner",null,null,null,null,null,null,null,null,"6 EA/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA57,'Price List'!AG57)","v":59.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA57*(1-W57)+0.004999,2)","v":59.2},null,"YES",59.2,{"$f":"+W57","v":0},{"$f":"+X57","v":59.2},{"$f":"(AG57-AC57)/AG57","v":0},null,3,{"$f":"SUM(AJ57:AL57)+AE57","v":59.2},null,null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":59.2},{"$f":"IF(VLOOKUP(AF57,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ57,1)-AJ57,2),Round,2,FALSE)+VLOOKUP(AF57,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",0,ROUND(AJ57-0.04999,1)-AJ57+AM57)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF57,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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'!AA64,'Price List'!AG64)","v":9.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":9.6},null,"new",9.6,{"$f":"+W64","v":0},{"$f":"+X64","v":9.6},{"$f":"(AG64-AC64)/AG64","v":0},null,1,{"$f":"SUM(AJ64:AL64)+AE64","v":9.6},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":9.6},{"$f":"IF(VLOOKUP(AF64,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ64,1)-AJ64,2),Round,2,FALSE)+VLOOKUP(AF64,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",0,ROUND(AJ64-0.04999,1)-AJ64+AM64)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF64,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA65,'Price List'!AG65)","v":6.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},6.9,null,"new",6.9,0,6.9,0,null,1,6.9,null,null,6.9,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'!AA66,'Price List'!AG66)","v":7.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.15,null,"new",7.15,0,7.15,0,null,1,7.15,null,null,7.15,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'!AA67,'Price List'!AG67)","v":8.0500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.0500000000000007,null,"new",8.0500000000000007,0,8.0500000000000007,0,null,1,8.0500000000000007,null,null,8.0500000000000007,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'!AA69,'Price List'!AG69)","v":17.149999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA69*(1-W69)+0.004999,2)","v":17.149999999999999},null,"new",17.149999999999999,{"$f":"+W69","v":0},{"$f":"+X69","v":17.149999999999999},{"$f":"(AG69-AC69)/AG69","v":0},null,3,{"$f":"SUM(AJ69:AL69)+AE69","v":17.149999999999999},null,null,{"$f":"ROUND(AC69/(1-VLOOKUP(AF69,Group,2,FALSE)),2)","v":17.149999999999999},{"$f":"IF(VLOOKUP(AF69,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ69,1)-AJ69,2),Round,2,FALSE)+VLOOKUP(AF69,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF69,Group,7,FALSE)=\"\",0,ROUND(AJ69-0.04999,1)-AJ69+AM69)","v":0},{"$f":"IF(VLOOKUP(AF69,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF69,Group,7,FALSE))","v":""},null,"X"]
[null,"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'!AA70,'Price List'!AG70)","v":23.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},23.35,null,"new",23.35,0,23.35,0,null,3,23.35,null,null,23.35,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'!AA72,'Price List'!AG72)","v":15.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA72*(1-W72)+0.004999,2)","v":15.25},null,"new",15.25,{"$f":"+W72","v":0},{"$f":"+X72","v":15.25},{"$f":"(AG72-AC72)/AG72","v":0},null,2,{"$f":"SUM(AJ72:AL72)+AE72","v":15.25},null,null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":15.25},{"$f":"IF(VLOOKUP(AF72,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ72,1)-AJ72,2),Round,2,FALSE)+VLOOKUP(AF72,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",0,ROUND(AJ72-0.04999,1)-AJ72+AM72)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF72,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'!AA77,'Price List'!AG77)","v":10.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":10.8},null,"new",10.8,{"$f":"+W77","v":0},{"$f":"+X77","v":10.8},{"$f":"(AG77-AC77)/AG77","v":0},null,1,{"$f":"SUM(AJ77:AL77)+AE77","v":10.8},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":10.8},{"$f":"IF(VLOOKUP(AF77,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ77,1)-AJ77,2),Round,2,FALSE)+VLOOKUP(AF77,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",0,ROUND(AJ77-0.04999,1)-AJ77+AM77)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF77,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'!AA78,'Price List'!AG78)","v":8.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.9499999999999993,null,"new",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'!AA79,'Price List'!AG79)","v":9.1999999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.1999999999999993,null,"new",9.1999999999999993,0,9.1999999999999993,0,null,1,9.1999999999999993,null,null,9.1999999999999993,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA80,'Price List'!AG80)","v":10},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10,null,"new",10,0,10,0,null,1,10,null,null,10,0,0,"",null,"X"]
[null,"Field Tile",null,null,"36\" x 36\"",null,"Field",null,null,null,null,null,null,null,null,"17.43 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA81,'Price List'!AG81)","v":10.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA81*(1-W81)+0.004999,2)","v":10.9},null,"new",10.9,{"$f":"+W81","v":0},{"$f":"+X81","v":10.9},{"$f":"(AG81-AC81)/AG81","v":0},null,1,{"$f":"SUM(AJ81:AL81)+AE81","v":10.9},null,null,{"$f":"ROUND(AC81/(1-VLOOKUP(AF81,Group,2,FALSE)),2)","v":10.9},{"$f":"IF(VLOOKUP(AF81,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ81,1)-AJ81,2),Round,2,FALSE)+VLOOKUP(AF81,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF81,Group,7,FALSE)=\"\",0,ROUND(AJ81-0.04999,1)-AJ81+AM81)","v":0},{"$f":"IF(VLOOKUP(AF81,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF81,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"36\" x 72\"",null,"Field",null,null,null,null,null,null,null,null,"17.43 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA82,'Price List'!AG82)","v":11.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11.6,null,"new",11.6,0,11.6,0,null,1,11.6,null,null,11.6,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'!AA84,'Price List'!AG84)","v":18.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":18.8},null,"new",18.8,{"$f":"+W84","v":0},{"$f":"+X84","v":18.8},{"$f":"(AG84-AC84)/AG84","v":0},null,3,{"$f":"SUM(AJ84:AL84)+AE84","v":18.8},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":18.8},{"$f":"IF(VLOOKUP(AF84,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ84,1)-AJ84,2),Round,2,FALSE)+VLOOKUP(AF84,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",0,ROUND(AJ84-0.04999,1)-AJ84+AM84)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF84,Group,7,FALSE))","v":""},null,"X"]
[null,"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'!AA85,'Price List'!AG85)","v":34.700000000000003},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},34.700000000000003,null,"new",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'!AA86,'Price List'!AG86)","v":39.799999999999997},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA86*(1-W86)+0.004999,2)","v":39.799999999999997},null,"new",39.799999999999997,{"$f":"+W86","v":0},{"$f":"+X86","v":39.799999999999997},{"$f":"(AG86-AC86)/AG86","v":0},null,3,{"$f":"SUM(AJ86:AL86)+AE86","v":39.799999999999997},null,null,{"$f":"ROUND(AC86/(1-VLOOKUP(AF86,Group,2,FALSE)),2)","v":39.799999999999997},{"$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 12\"",null,"Mosaic",null,"Intreccio Basketweave",null,null,null,null,null,null,".97 SF/Sheet","Stock","c",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA87,'Price List'!AG87)","v":26.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"new",26.05,0,26.05,0,null,3,26.05,null,null,26.05,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'!AA88,'Price List'!AG88)","v":24.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},24.9,null,"new",24.9,0,24.9,0,null,3,24.9,null,null,24.9,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'!AA89,'Price List'!AG89)","v":26.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":26.05},null,"new",26.05,{"$f":"+W89","v":0},{"$f":"+X89","v":26.05},{"$f":"(AG89-AC89)/AG89","v":0},null,3,{"$f":"SUM(AJ89:AL89)+AE89","v":26.05},null,null,{"$f":"ROUND(AC89/(1-VLOOKUP(AF89,Group,2,FALSE)),2)","v":26.05},{"$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,"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'!AA90,'Price List'!AG90)","v":37.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA90*(1-W90)+0.004999,2)","v":37.1},null,"new",37.1,{"$f":"+W90","v":0},{"$f":"+X90","v":37.1},{"$f":"(AG90-AC90)/AG90","v":0},null,3,{"$f":"SUM(AJ90:AL90)+AE90","v":37.1},null,null,{"$f":"ROUND(AC90/(1-VLOOKUP(AF90,Group,2,FALSE)),2)","v":37.1},{"$f":"IF(VLOOKUP(AF90,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ90,1)-AJ90,2),Round,2,FALSE)+VLOOKUP(AF90,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,7,FALSE)=\"\",0,ROUND(AJ90-0.04999,1)-AJ90+AM90)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF90,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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'!AA92,'Price List'!AG92)","v":17},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":17},null,"new",17,{"$f":"+W92","v":0},{"$f":"+X92","v":17},{"$f":"(AG92-AC92)/AG92","v":0},null,2,{"$f":"SUM(AJ92:AL92)+AE92","v":17},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":17},{"$f":"IF(VLOOKUP(AF92,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ92,1)-AJ92,2),Round,2,FALSE)+VLOOKUP(AF92,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",0,ROUND(AJ92-0.04999,1)-AJ92+AM92)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF92,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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,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'!AA102,'Price List'!AG102)","v":8.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA102*(1-W102)+0.004999,2)","v":8.9499999999999993},null,"YES",8.9499999999999993,{"$f":"+W102","v":0},{"$f":"+X102","v":8.9499999999999993},{"$f":"(AG102-AC102)/AG102","v":0},null,1,{"$f":"SUM(AJ102:AL102)+AE102","v":8.9499999999999993},null,null,{"$f":"ROUND(AC102/(1-VLOOKUP(AF102,Group,2,FALSE)),2)","v":8.9499999999999993},{"$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,"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'!AA103,'Price List'!AG103)","v":7.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA103*(1-W103)+0.004999,2)","v":7.35},null,"YES",7.35,{"$f":"+W103","v":0},{"$f":"+X103","v":7.35},{"$f":"(AG103-AC103)/AG103","v":0},null,1,{"$f":"SUM(AJ103:AL103)+AE103","v":7.35},null,null,{"$f":"ROUND(AC103/(1-VLOOKUP(AF103,Group,2,FALSE)),2)","v":7.35},{"$f":"IF(VLOOKUP(AF103,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ103,1)-AJ103,2),Round,2,FALSE)+VLOOKUP(AF103,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF103,Group,7,FALSE)=\"\",0,ROUND(AJ103-0.04999,1)-AJ103+AM103)","v":0},{"$f":"IF(VLOOKUP(AF103,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF103,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA105,'Price List'!AG105)","v":20.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA105*(1-W105)+0.004999,2)","v":20.65},null,"YES",20.65,{"$f":"+W105","v":0},{"$f":"+X105","v":20.65},{"$f":"(AG105-AC105)/AG105","v":0},null,3,{"$f":"SUM(AJ105:AL105)+AE105","v":20.65},null,null,{"$f":"ROUND(AC105/(1-VLOOKUP(AF105,Group,2,FALSE)),2)","v":20.65},{"$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,"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'!AA106,'Price List'!AG106)","v":22.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":22.45},null,"YES",22.45,{"$f":"+W106","v":0},{"$f":"+X106","v":22.45},{"$f":"(AG106-AC106)/AG106","v":0},null,3,{"$f":"SUM(AJ106:AL106)+AE106","v":22.45},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":22.45},{"$f":"IF(VLOOKUP(AF106,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ106,1)-AJ106,2),Round,2,FALSE)+VLOOKUP(AF106,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",0,ROUND(AJ106-0.04999,1)-AJ106+AM106)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF106,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"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'!AA108,'Price List'!AG108)","v":18.55},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA108*(1-W108)+0.004999,2)","v":18.55},null,"YES",18.55,{"$f":"+W108","v":0},{"$f":"+X108","v":18.55},{"$f":"(AG108-AC108)/AG108","v":0},null,2,{"$f":"SUM(AJ108:AL108)+AE108","v":18.55},null,null,{"$f":"ROUND(AC108/(1-VLOOKUP(AF108,Group,2,FALSE)),2)","v":18.55},{"$f":"IF(VLOOKUP(AF108,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ108,1)-AJ108,2),Round,2,FALSE)+VLOOKUP(AF108,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",0,ROUND(AJ108-0.04999,1)-AJ108+AM108)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF108,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'!AA110,'Price List'!AG110)","v":11.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA110*(1-W110)+0.004999,2)","v":11.85},null,"YES",11.85,{"$f":"+W110","v":0},11.85,{"$f":"(AG110-AC110)/AG110","v":0},null,1,{"$f":"SUM(AJ110:AL110)+AE110","v":11.85},null,null,{"$f":"ROUND(AC110/(1-VLOOKUP(AF110,Group,2,FALSE)),2)","v":11.85},{"$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,"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'!AA111,'Price List'!AG111)","v":9.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA111*(1-W111)+0.004999,2)","v":9.9499999999999993},null,"YES",9.9499999999999993,0,9.9499999999999993,{"$f":"(AG111-AC111)/AG111","v":0},null,1,{"$f":"SUM(AJ111:AL111)+AE111","v":9.9499999999999993},null,null,{"$f":"ROUND(AC111/(1-VLOOKUP(AF111,Group,2,FALSE)),2)","v":9.9499999999999993},{"$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,"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'!AA112,'Price List'!AG112)","v":12.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA112*(1-W112)+0.004999,2)","v":12.35},null,"YES",12.35,0,12.35,{"$f":"(AG112-AC112)/AG112","v":0},null,1,{"$f":"SUM(AJ112:AL112)+AE112","v":12.35},null,null,{"$f":"ROUND(AC112/(1-VLOOKUP(AF112,Group,2,FALSE)),2)","v":12.35},{"$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,"Intreccio",null,null,"mesh-mounted",null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA114,'Price List'!AG114)","v":24.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA114*(1-W114)+0.004999,2)","v":24.5},null,"YES",24.5,{"$f":"+W114","v":0},24.5,{"$f":"(AG114-AC114)/AG114","v":0},null,3,{"$f":"SUM(AJ114:AL114)+AE114","v":24.5},null,null,{"$f":"ROUND(AC114/(1-VLOOKUP(AF114,Group,2,FALSE)),2)","v":24.5},{"$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,"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'!AA115,'Price List'!AG115)","v":48.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA115*(1-W115)+0.004999,2)","v":48.9},null,"YES",48.9,0,48.9,{"$f":"(AG115-AC115)/AG115","v":0},null,3,{"$f":"SUM(AJ115:AL115)+AE115","v":48.9},null,null,{"$f":"ROUND(AC115/(1-VLOOKUP(AF115,Group,2,FALSE)),2)","v":48.9},{"$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,"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'!AA116,'Price List'!AG116)","v":38.549999999999997},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA116*(1-W116)+0.004999,2)","v":38.549999999999997},null,"YES",38.549999999999997,0,38.549999999999997,{"$f":"(AG116-AC116)/AG116","v":0},null,3,{"$f":"SUM(AJ116:AL116)+AE116","v":38.549999999999997},null,null,{"$f":"ROUND(AC116/(1-VLOOKUP(AF116,Group,2,FALSE)),2)","v":38.549999999999997},{"$f":"IF(VLOOKUP(AF116,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ116,1)-AJ116,2),Round,2,FALSE)+VLOOKUP(AF116,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",0,ROUND(AJ116-0.04999,1)-AJ116+AM116)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF116,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA118,'Price List'!AG118)","v":20.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA118*(1-W118)+0.004999,2)","v":20.75},null,"YES",20.75,{"$f":"+W118","v":0},{"$f":"+X118","v":20.75},{"$f":"(AG118-AC118)/AG118","v":0},null,2,{"$f":"SUM(AJ118:AL118)+AE118","v":20.75},null,null,{"$f":"ROUND(AC118/(1-VLOOKUP(AF118,Group,2,FALSE)),2)","v":20.75},{"$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,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'!AA122,'Price List'!AG122)","v":8.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA122*(1-W122)+0.004999,2)","v":8.9499999999999993},null,"YES",8.9499999999999993,{"$f":"+W122","v":0},{"$f":"+X122","v":8.9499999999999993},{"$f":"(AG122-AC122)/AG122","v":0},null,1,{"$f":"SUM(AJ122:AL122)+AE122","v":8.9499999999999993},null,null,{"$f":"ROUND(AC122/(1-VLOOKUP(AF122,Group,2,FALSE)),2)","v":8.9499999999999993},{"$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,"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'!AA123,'Price List'!AG123)","v":7.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA123*(1-W123)+0.004999,2)","v":7.35},null,"YES",7.35,{"$f":"+W123","v":0},{"$f":"+X123","v":7.35},{"$f":"(AG123-AC123)/AG123","v":0},null,1,{"$f":"SUM(AJ123:AL123)+AE123","v":7.35},null,null,{"$f":"ROUND(AC123/(1-VLOOKUP(AF123,Group,2,FALSE)),2)","v":7.35},{"$f":"IF(VLOOKUP(AF123,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ123,1)-AJ123,2),Round,2,FALSE)+VLOOKUP(AF123,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",0,ROUND(AJ123-0.04999,1)-AJ123+AM123)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF123,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA125,'Price List'!AG125)","v":20.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA125*(1-W125)+0.004999,2)","v":20.65},null,"YES",20.65,{"$f":"+W125","v":0},{"$f":"+X125","v":20.65},{"$f":"(AG125-AC125)/AG125","v":0},null,3,{"$f":"SUM(AJ125:AL125)+AE125","v":20.65},null,null,{"$f":"ROUND(AC125/(1-VLOOKUP(AF125,Group,2,FALSE)),2)","v":20.65},{"$f":"IF(VLOOKUP(AF125,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ125,1)-AJ125,2),Round,2,FALSE)+VLOOKUP(AF125,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",0,ROUND(AJ125-0.04999,1)-AJ125+AM125)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF125,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'!AA127,'Price List'!AG127)","v":18.55},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA127*(1-W127)+0.004999,2)","v":18.55},null,"YES",18.55,{"$f":"+W127","v":0},{"$f":"+X127","v":18.55},{"$f":"(AG127-AC127)/AG127","v":0},null,2,{"$f":"SUM(AJ127:AL127)+AE127","v":18.55},null,null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":18.55},{"$f":"IF(VLOOKUP(AF127,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ127,1)-AJ127,2),Round,2,FALSE)+VLOOKUP(AF127,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",0,ROUND(AJ127-0.04999,1)-AJ127+AM127)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF127,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA129,'Price List'!AG129)","v":11.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA129*(1-W129)+0.004999,2)","v":11.85},null,"YES",11.85,{"$f":"+W129","v":0},11.85,{"$f":"(AG129-AC129)/AG129","v":0},null,1,{"$f":"SUM(AJ129:AL129)+AE129","v":11.85},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":11.85},{"$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,"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'!AA130,'Price List'!AG130)","v":9.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA130*(1-W130)+0.004999,2)","v":9.9499999999999993},null,"YES",9.9499999999999993,0,9.9499999999999993,{"$f":"(AG130-AC130)/AG130","v":0},null,1,{"$f":"SUM(AJ130:AL130)+AE130","v":9.9499999999999993},null,null,{"$f":"ROUND(AC130/(1-VLOOKUP(AF130,Group,2,FALSE)),2)","v":9.9499999999999993},{"$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,"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'!AA131,'Price List'!AG131)","v":12.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA131*(1-W131)+0.004999,2)","v":12.35},null,"YES",12.35,0,12.35,{"$f":"(AG131-AC131)/AG131","v":0},null,1,{"$f":"SUM(AJ131:AL131)+AE131","v":12.35},null,null,{"$f":"ROUND(AC131/(1-VLOOKUP(AF131,Group,2,FALSE)),2)","v":12.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA133,'Price List'!AG133)","v":20.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA133*(1-W133)+0.004999,2)","v":20.75},null,"YES",20.75,{"$f":"+W133","v":0},{"$f":"+X133","v":20.75},{"$f":"(AG133-AC133)/AG133","v":0},null,2,{"$f":"SUM(AJ133:AL133)+AE133","v":20.75},null,null,{"$f":"ROUND(AC133/(1-VLOOKUP(AF133,Group,2,FALSE)),2)","v":20.75},{"$f":"IF(VLOOKUP(AF133,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ133,1)-AJ133,2),Round,2,FALSE)+VLOOKUP(AF133,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",0,ROUND(AJ133-0.04999,1)-AJ133+AM133)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF133,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA137,'Price List'!AG137)","v":10.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA137*(1-W137)+0.004999,2)","v":10.1},null,"YES",10.1,{"$f":"+W137","v":0},{"$f":"+X137","v":10.1},{"$f":"(AG137-AC137)/AG137","v":0},null,1,{"$f":"SUM(AJ137:AL137)+AE137","v":10.1},null,null,{"$f":"ROUND(AC137/(1-VLOOKUP(AF137,Group,2,FALSE)),2)","v":10.1},{"$f":"IF(VLOOKUP(AF137,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ137,1)-AJ137,2),Round,2,FALSE)+VLOOKUP(AF137,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",0,ROUND(AJ137-0.04999,1)-AJ137+AM137)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF137,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"SOVEREIGN - Glazed Porcelain",null,null,null,null,null,null,null," "," "," ",null,null,null,null,"Item # Lookup:","NVSO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Antracite",null,"  Beige",null,null,"        Tabacco"]
[null,null,null,null,"Avorio",null,"  Grigio Chiaro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"4\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"9.04 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA144,'Price List'!AG144)","v":9.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA144*(1-W144)+0.004999,2)","v":9.9},null,"YES",9.9,{"$f":"+W144","v":0},{"$f":"+X144","v":9.9},{"$f":"(AG144-AC144)/AG144","v":0},null,1,{"$f":"SUM(AJ144:AL144)+AE144","v":9.9},null,null,{"$f":"ROUND(AC144/(1-VLOOKUP(AF144,Group,2,FALSE)),2)","v":9.9},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ144,1)-AJ144,2),Round,2,FALSE)+VLOOKUP(AF144,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",0,ROUND(AJ144-0.04999,1)-AJ144+AM144)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF144,Group,7,FALSE))","v":""},null,"X"]
[null,"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'!AA145,'Price List'!AG145)","v":7.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.95,null,"YES",7.95,0,7.95,0,null,1,7.95,null,null,7.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'!AA146,'Price List'!AG146)","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 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA147,'Price List'!AG147)","v":10.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.75,null,"YES",10.75,0,10.75,0,null,1,10.75,null,null,10.75,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"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'!AA149,'Price List'!AG149)","v":11.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11.7,null,"YES",11.7,0,11.7,0,null,1,11.7,null,null,11.7,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'!AA150,'Price List'!AG150)","v":8.4499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.4499999999999993,null,"YES",8.4499999999999993,0,8.4499999999999993,0,null,1,8.4499999999999993,null,null,8.4499999999999993,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'!AA151,'Price List'!AG151)","v":8.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5,null,"YES",8.5,0,8.5,0,null,1,8.5,null,null,8.5,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'!AA153,'Price List'!AG153)","v":28.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA153*(1-W153)+0.004999,2)","v":28.7},null,"YES",28.7,{"$f":"+W153","v":0},{"$f":"+X153","v":28.7},{"$f":"(AG153-AC153)/AG153","v":0},null,3,{"$f":"SUM(AJ153:AL153)+AE153","v":28.7},null,null,{"$f":"ROUND(AC153/(1-VLOOKUP(AF153,Group,2,FALSE)),2)","v":28.7},{"$f":"IF(VLOOKUP(AF153,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ153,1)-AJ153,2),Round,2,FALSE)+VLOOKUP(AF153,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",0,ROUND(AJ153-0.04999,1)-AJ153+AM153)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF153,Group,7,FALSE))","v":""},null,"X"]
[null,"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'!AA154,'Price List'!AG154)","v":9.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA154*(1-W154)+0.004999,2)","v":9.4},null,"YES",9.4,{"$f":"+W154","v":0},{"$f":"+X154","v":9.4},{"$f":"(AG154-AC154)/AG154","v":0},null,3,{"$f":"SUM(AJ154:AL154)+AE154","v":9.4},null,null,{"$f":"ROUND(AC154/(1-VLOOKUP(AF154,Group,2,FALSE)),2)","v":9.4},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!AA156,'Price List'!AG156)","v":21.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA156*(1-W156)+0.004999,2)","v":21.75},null,"YES",21.75,{"$f":"+W156","v":0},21.75,{"$f":"(AG156-AC156)/AG156","v":0},null,3,{"$f":"SUM(AJ156:AL156)+AE156","v":21.75},null,null,{"$f":"ROUND(AC156/(1-VLOOKUP(AF156,Group,2,FALSE)),2)","v":21.75},{"$f":"IF(VLOOKUP(AF156,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ156,1)-AJ156,2),Round,2,FALSE)+VLOOKUP(AF156,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",0,ROUND(AJ156-0.04999,1)-AJ156+AM156)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF156,Group,7,FALSE))","v":""},null,"X"]
[null,"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'!AA157,'Price List'!AG157)","v":20.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":20.95},null,"YES",20.95,0,20.95,{"$f":"(AG157-AC157)/AG157","v":0},null,3,{"$f":"SUM(AJ157:AL157)+AE157","v":20.95},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":20.95},{"$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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 4\" 3D",null,"mesh-mounted (0.97 SF/Sheet)",null,null,null,null,"5.82 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA158,'Price List'!AG158)","v":48.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA158*(1-W158)+0.004999,2)","v":48.35},null,"YES",48.35,0,48.35,{"$f":"(AG158-AC158)/AG158","v":0},null,3,{"$f":"SUM(AJ158:AL158)+AE158","v":48.35},null,null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":48.35},{"$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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"3\" x 3\" 3D",null,"mesh-mounted (0.97 SF/Sheet)",null,null,null,null,"5.82 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA159,'Price List'!AG159)","v":47.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA159*(1-W159)+0.004999,2)","v":47.55},null,"YES",47.55,0,47.55,{"$f":"(AG159-AC159)/AG159","v":0},null,3,{"$f":"SUM(AJ159:AL159)+AE159","v":47.55},null,null,{"$f":"ROUND(AC159/(1-VLOOKUP(AF159,Group,2,FALSE)),2)","v":47.55},{"$f":"IF(VLOOKUP(AF159,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ159,1)-AJ159,2),Round,2,FALSE)+VLOOKUP(AF159,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",0,ROUND(AJ159-0.04999,1)-AJ159+AM159)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF159,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"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'!AA161,'Price List'!AG161)","v":7.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA161*(1-W161)+0.004999,2)","v":7.9},null,"YES",7.9,{"$f":"+W161","v":0},{"$f":"+X161","v":7.9},{"$f":"(AG161-AC161)/AG161","v":0},null,2,{"$f":"SUM(AJ161:AL161)+AE161","v":7.9},null,null,{"$f":"ROUND(AC161/(1-VLOOKUP(AF161,Group,2,FALSE)),2)","v":7.9},{"$f":"IF(VLOOKUP(AF161,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ161,1)-AJ161,2),Round,2,FALSE)+VLOOKUP(AF161,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",0,ROUND(AJ161-0.04999,1)-AJ161+AM161)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF161,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'!AA162,'Price List'!AG162)","v":19},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA162*(1-W162)+0.004999,2)","v":19},null,"YES",19,{"$f":"+W162","v":0},{"$f":"+X162","v":19},{"$f":"(AG162-AC162)/AG162","v":0},null,2,{"$f":"SUM(AJ162:AL162)+AE162","v":19},null,null,{"$f":"ROUND(AC162/(1-VLOOKUP(AF162,Group,2,FALSE)),2)","v":19},{"$f":"IF(VLOOKUP(AF162,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ162,1)-AJ162,2),Round,2,FALSE)+VLOOKUP(AF162,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF162,Group,7,FALSE)=\"\",0,ROUND(AJ162-0.04999,1)-AJ162+AM162)","v":0},{"$f":"IF(VLOOKUP(AF162,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF162,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","a) Not available in color Tabacco.",null,null,null,null,"b) Not available in colors Anthracite and Tabacco."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[]
[null,null,null,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2,null,null,null,null," "]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":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/"]
["MICHELANGELO","https://www.novabell.it/en/collections/imperial-michelangelo/"]
["SOVEREIGN","https://www.novabell.it/en/collections/sovereign/"]

{"sheet":"Changes","index":4,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,2,1,2]]}
["Date",null,"Description"]
["Announced","Series"]
[]
["New Products"]
["2016-04-01","Imperial","Glazed Porcelain"]
["2017-03-06","Imperial","Added colors Calacatta Beige and Nero Imperiale."]
["2017-03-06","Materia","Glazed Porcelain"]
["2018-02-01","Deco","Glazed Porcelain"]
["2018-02-01","Sovereign","Glazed Porcelain"]
["2018-02-01","Venice","Glazed Porcelain - Named Imperial Venice on Novabell's Website"]
["2019-03-12","Michelangelo","Glazed Porcelain - Named Imperial Michelangelo on Novabell's Website"]
["2021-01-01","Aspen","Glazed Porcelain"]
["2021-01-01","Brickup","Glazed Porcelain - 3D Brick"]
["2024-02-01","Extra","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)"]
["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)"]