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

{"sheet":"Instructions","index":0,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Edimax"]
["File as","E"]
["Product Code","B"]
["CCTD Effective Date","7/1/24 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"B"}]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0]
[null,2,null,"Trim",null,"No",0]
[null,3,null,"Decos",null,"No",0]
[null,4,null,0,null,"No",0]
[null,5,null,0,null,"No",0]
[null,6,null,0,null,"No",0]
[null,7,null,0,null,"No",0]
[]
["If you want to manually adjust your price list, hit \"F5\" and go to \"Customer_Cost\" to manually adjust pricing."]
["You can enter a value in the column labeled \"Adj.\" to change your price manually."]
[]
[null,"Click on \"Your Price Calculation\" to set the print area for your personal cost calculation report."]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Your Price List\" to set the print area for your personal price list."]
[null,"Then you can send it to print"]
[null,null,null,null,null,null,null,"Yes"]
[]
["If you have any questions on how to best use this spreadsheet, please feel free to contact"]
["Jim Vogel at (800) 422-6860, ext. 4201 or via e-mail at jimvogel@cctd.com"]

{"sheet":"Index","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,0,5,10],[48,0,48,10],[50,0,50,10],[2,5,2,10],[3,4,3,7]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'E' - Edimax"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 7/1/24 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":185,"n_cols":41,"rows_kept":185,"cut":false,"hidden":false,"merged":[[9,25,9,32],[12,22,12,23],[9,22,9,23],[170,2,170,19],[169,2,169,19],[167,2,167,19],[13,30,13,32],[14,13,15,19],[12,14,12,19],[10,14,10,15],[165,2,165,19],[9,14,9,19],[174,3,174,4],[18,2,18,19],[17,14,17,15],[19,2,19,19],[168,2,168,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\",AA1,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\",AA2,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\",AA3,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,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 'E' - Edimax"},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":"7/1/24 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-09-24"},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,"CONCERT - High Definition 3D Technology Glazed Porcelain",null,null,null,null,null,null,null,null,null," ",null,null,null,null,"Item # Lookup:","EDCO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Black          White"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"5\" x 5 \"",null,"Field",null,null,null,null,null,null,null,null,"7.27 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA26,AG26)","v":10.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA26*(1-W26)+0.004999,2)","v":10.35},null,"",10.35,{"$f":"+W26","v":0},{"$f":"+X26","v":10.35},{"$f":"(AG26-AC26)/AG26","v":0},null,1,{"$f":"SUM(AJ26:AL26)+AE26","v":10.35},null,null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":10.35},{"$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,"5\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"7.83 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA27,AG27)","v":10.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.4,null,"",10.4,0,10.4,0,null,1,10.4,null,null,10.4,0,0,"",null,"X"]
[null,"Field Tile",null,null,"16\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"10.33 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA28,AG28)","v":8.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA28*(1-W28)+0.004999,2)","v":8.65},null,"",8.65,{"$f":"+W28","v":0},{"$f":"+X28","v":8.65},{"$f":"(AG28-AC28)/AG28","v":0},null,1,{"$f":"SUM(AJ28:AL28)+AE28","v":8.65},null,null,{"$f":"ROUND(AC28/(1-VLOOKUP(AF28,Group,2,FALSE)),2)","v":8.65},{"$f":"IF(VLOOKUP(AF28,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ28,1)-AJ28,2),Round,2,FALSE)+VLOOKUP(AF28,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF28,Group,7,FALSE)=\"\",0,ROUND(AJ28-0.04999,1)-AJ28+AM28)","v":0},{"$f":"IF(VLOOKUP(AF28,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF28,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"6\" x 7\"",null,"Field - 6\" Hex",null,null,null,null,null,null,null,null,"3.91 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA30,AG30)","v":18.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},18.2,null,"",18.2,0,18.2,0,null,1,18.2,null,null,18.2,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"6\" x 7\"",null,"Deco",null,"6\" Hex with Gold Line",null,null,null,null,null,null,"20 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA32,AG32)","v":31.45},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":31.45},null,"",31.45,{"$f":"+W32","v":0},{"$f":"+X32","v":31.45},{"$f":"(AG32-AC32)/AG32","v":0},null,3,{"$f":"SUM(AJ32:AL32)+AE32","v":31.45},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":31.45},{"$f":"IF(VLOOKUP(AF32,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ32,1)-AJ32,2),Round,2,FALSE)+VLOOKUP(AF32,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",0,ROUND(AJ32-0.04999,1)-AJ32+AM32)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF32,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA34,AG34)","v":25.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA34*(1-W34)+0.004999,2)","v":25.9},null,"",25.9,{"$f":"+W34","v":0},{"$f":"+X34","v":25.9},{"$f":"(AG34-AC34)/AG34","v":0},null,3,{"$f":"SUM(AJ34:AL34)+AE34","v":25.9},null,null,{"$f":"ROUND(AC34/(1-VLOOKUP(AF34,Group,2,FALSE)),2)","v":25.9},{"$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,"10\" x 10\"",null,"Mosaic",null,"2\" Hex - Texture",null,null,"Esagonale",null,null,null,"0.70 SF/SHT","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA35,AG35)","v":87.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":87.2},null,"",87.2,{"$f":"+W35","v":0},{"$f":"+X35","v":87.2},{"$f":"(AG35-AC35)/AG35","v":0},null,3,{"$f":"SUM(AJ35:AL35)+AE35","v":87.2},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":87.2},{"$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,"Chevron",null,null,null,null,null,null,"9 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA36,AG36)","v":38.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":38.65},null,"",38.65,{"$f":"+W36","v":0},{"$f":"+X36","v":38.65},{"$f":"(AG36-AC36)/AG36","v":0},null,3,{"$f":"SUM(AJ36:AL36)+AE36","v":38.65},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":38.65},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\" x 16\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA38,AG38)","v":15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":15},null,"",15,{"$f":"+W38","v":0},{"$f":"+X38","v":15},{"$f":"(AG38-AC38)/AG38","v":0},null,2,{"$f":"SUM(AJ38:AL38)+AE38","v":15},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":15},{"$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,null,null,"Colors:","Black w/ White Dot          White w/ Black Dot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"3\" Octagon & Dot",null,null,"Ottagono",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA42,AG42)","v":49},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA42*(1-W42)+0.004999,2)","v":49},null,"",49,{"$f":"+W42","v":0},{"$f":"+X42","v":49},{"$f":"(AG42-AC42)/AG42","v":0},null,3,{"$f":"SUM(AJ42:AL42)+AE42","v":49},null,null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":49},{"$f":"IF(VLOOKUP(AF42,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ42,1)-AJ42,2),Round,2,FALSE)+VLOOKUP(AF42,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF42,Group,7,FALSE)=\"\",0,ROUND(AJ42-0.04999,1)-AJ42+AM42)","v":0},{"$f":"IF(VLOOKUP(AF42,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF42,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:","Black/White"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Chess 2\" x 2\"",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA46,AG46)","v":25.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA46*(1-W46)+0.004999,2)","v":25.9},null,"",25.9,{"$f":"+W46","v":0},{"$f":"+X46","v":25.9},{"$f":"(AG46-AC46)/AG46","v":0},null,3,{"$f":"SUM(AJ46:AL46)+AE46","v":25.9},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":25.9},{"$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,"X"]
[null,null,"GOLDEN AGE - High Definition 3D Technology Glazed Porcelain",null,null,null,null,null,null,null,null,null," ",null,null,null,null,"Item # Lookup:","EDGO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Grey          White"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"2\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA52,AG52)","v":10.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA52*(1-W52)+0.004999,2)","v":10.35},null,"",10.35,{"$f":"+W52","v":0},{"$f":"+X52","v":10.35},{"$f":"(AG52-AC52)/AG52","v":0},null,1,{"$f":"SUM(AJ52:AL52)+AE52","v":10.35},null,null,{"$f":"ROUND(AC52/(1-VLOOKUP(AF52,Group,2,FALSE)),2)","v":10.35},{"$f":"IF(VLOOKUP(AF52,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ52,1)-AJ52,2),Round,2,FALSE)+VLOOKUP(AF52,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF52,Group,7,FALSE)=\"\",0,ROUND(AJ52-0.04999,1)-AJ52+AM52)","v":0},{"$f":"IF(VLOOKUP(AF52,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF52,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"6\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"13.56 SF/CTN","Stock",null,10.4,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.4,null,"",10.4,0,10.4,0,null,1,10.4,null,null,10.4,0,0,"",null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,7.75,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.75,null,"",7.75,0,7.75,0,null,1,7.75,null,null,7.75,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN",null,null,8.0500000000000007,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.0500000000000007,null,"",8.0500000000000007,0,8.0500000000000007,0,null,1,8.0500000000000007,null,null,8.0500000000000007,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,9.1,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":9.1},null,"",9.1,{"$f":"+W56","v":0},{"$f":"+X56","v":9.1},{"$f":"(AG56-AC56)/AG56","v":0},null,1,{"$f":"SUM(AJ56:AL56)+AE56","v":9.1},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":9.1},{"$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,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN",null,null,9.0500000000000007,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.0500000000000007,null,"",9.0500000000000007,0,9.0500000000000007,0,null,1,9.0500000000000007,null,null,9.0500000000000007,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"2\" x 12\"",null,"Field",null,"Decorative",null,null,"Discontinued 9/24/24",null,null,null,"12.01 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA59,AG59)","v":10.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA59*(1-W59)+0.004999,2)","v":10.65},null,"",10.65,{"$f":"+W59","v":0},{"$f":"+X59","v":10.65},{"$f":"(AG59-AC59)/AG59","v":0},null,3,{"$f":"SUM(AJ59:AL59)+AE59","v":10.65},null,null,{"$f":"ROUND(AC59/(1-VLOOKUP(AF59,Group,2,FALSE)),2)","v":10.65},{"$f":"IF(VLOOKUP(AF59,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ59,1)-AJ59,2),Round,2,FALSE)+VLOOKUP(AF59,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",0,ROUND(AJ59-0.04999,1)-AJ59+AM59)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF59,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 24\"",null,"Field",null,"Circles Decorative",null,null,null,null,null,null,"11.62 SF/CTN","Stock","b",{"$f":"IF(Suggested=\"Yes\",AA60,AG60)","v":8.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA60*(1-W60)+0.004999,2)","v":8.4},null,"",8.4,{"$f":"+W60","v":0},{"$f":"+X60","v":8.4},{"$f":"(AG60-AC60)/AG60","v":0},null,3,{"$f":"SUM(AJ60:AL60)+AE60","v":8.4},null,null,{"$f":"ROUND(AC60/(1-VLOOKUP(AF60,Group,2,FALSE)),2)","v":8.4},{"$f":"IF(VLOOKUP(AF60,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ60,1)-AJ60,2),Round,2,FALSE)+VLOOKUP(AF60,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF60,Group,7,FALSE)=\"\",0,ROUND(AJ60-0.04999,1)-AJ60+AM60)","v":0},{"$f":"IF(VLOOKUP(AF60,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF60,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA62,AG62)","v":25.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA62*(1-W62)+0.004999,2)","v":25.7},null,"",25.7,{"$f":"+W62","v":0},{"$f":"+X62","v":25.7},{"$f":"(AG62-AC62)/AG62","v":0},null,3,{"$f":"SUM(AJ62:AL62)+AE62","v":25.7},null,null,{"$f":"ROUND(AC62/(1-VLOOKUP(AF62,Group,2,FALSE)),2)","v":25.7},{"$f":"IF(VLOOKUP(AF62,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ62,1)-AJ62,2),Round,2,FALSE)+VLOOKUP(AF62,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF62,Group,7,FALSE)=\"\",0,ROUND(AJ62-0.04999,1)-AJ62+AM62)","v":0},{"$f":"IF(VLOOKUP(AF62,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF62,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Shell",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA63,AG63)","v":56.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},56.65,null,"",56.65,0,56.65,0,null,3,56.65,null,null,56.65,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Triangles",null,null,"Discontinued 9/24/24",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA64,AG64)","v":45.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":45.6},null,"",45.6,{"$f":"+W64","v":0},{"$f":"+X64","v":45.6},{"$f":"(AG64-AC64)/AG64","v":0},null,3,{"$f":"SUM(AJ64:AL64)+AE64","v":45.6},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":45.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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA66,AG66)","v":24.45},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA66*(1-W66)+0.004999,2)","v":24.45},null,"",24.45,{"$f":"+W66","v":0},{"$f":"+X66","v":24.45},{"$f":"(AG66-AC66)/AG66","v":0},null,2,{"$f":"SUM(AJ66:AL66)+AE66","v":24.45},null,null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":24.45},{"$f":"IF(VLOOKUP(AF66,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ66,1)-AJ66,2),Round,2,FALSE)+VLOOKUP(AF66,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",0,ROUND(AJ66-0.04999,1)-AJ66+AM66)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF66,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) There are 4 different decorative designs and they are randomly packaged in each carton."]
[null,null,null,null,"b) Stocked in color White only."]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"HOME - Glazed Porcelain",null,null,null,null,null,null,null,null,null," ",null,null,null,null,"Item # Lookup:","EDHO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Amber Peach",null,"Dark Peat",null,"Red Flame"]
[null,null,null,null,"Blue Lagoon",null,"Golden Sun",null,"White Pastel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"8\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"6.89 SF/CTN","Stock","b",{"$f":"IF(Suggested=\"Yes\",AA76,AG76)","v":10.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":10.4},null,"",10.4,{"$f":"+W76","v":0},{"$f":"+X76","v":10.4},{"$f":"(AG76-AC76)/AG76","v":0},null,1,{"$f":"SUM(AJ76:AL76)+AE76","v":10.4},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":10.4},{"$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,"4\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"10.33 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",AA77,AG77)","v":10.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":10.4},null,"",10.4,{"$f":"+W77","v":0},{"$f":"+X77","v":10.4},{"$f":"(AG77-AC77)/AG77","v":0},null,1,{"$f":"SUM(AJ77:AL77)+AE77","v":10.4},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":10.4},{"$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,"8\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"10.33 SF/CTN","Stock","b",{"$f":"IF(Suggested=\"Yes\",AA78,AG78)","v":10.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.4,null,"",10.4,0,10.4,0,null,1,10.4,null,null,10.4,0,0,"",null,"X"]
[null,"Field Tile",null,null,"16\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"10.33 SF/CTN","Stock","b",{"$f":"IF(Suggested=\"Yes\",AA79,AG79)","v":8.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.65,null,"",8.65,0,8.65,0,null,1,8.65,null,null,8.65,0,0,"",null,"X"]
[null,"Field Tile",null,null,"16\" x 16\"",null,"Field - Anti-Slip",null,null,null,null,null,null,null,null,"10.33 SF/CTN",null,"c",{"$f":"IF(Suggested=\"Yes\",AA80,AG80)","v":8.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA80*(1-W80)+0.004999,2)","v":8.65},null,"",8.65,{"$f":"+W80","v":0},{"$f":"+X80","v":8.65},{"$f":"(AG80-AC80)/AG80","v":0},null,1,{"$f":"SUM(AJ80:AL80)+AE80","v":8.65},null,null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":8.65},{"$f":"IF(VLOOKUP(AF80,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ80,1)-AJ80,2),Round,2,FALSE)+VLOOKUP(AF80,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",0,ROUND(AJ80-0.04999,1)-AJ80+AM80)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF80,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile",null,null,"7\" x 6\"",null,"Field - Hex",null,null,null,null,null,null,null,null,"3.91 SF/CTN","Stock","b",{"$f":"IF(Suggested=\"Yes\",AA82,AG82)","v":18.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},18.3,null,"",18.3,0,18.3,0,null,1,18.3,null,null,18.3,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,null,"Stock","b",{"$f":"IF(Suggested=\"Yes\",AA84,AG84)","v":25.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":25.8},null,"",25.8,{"$f":"+W84","v":0},{"$f":"+X84","v":25.8},{"$f":"(AG84-AC84)/AG84","v":0},null,3,{"$f":"SUM(AJ84:AL84)+AE84","v":25.8},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":25.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,"12\" x 13\"",null,"Mosaic",null,"3\" Hex (Esa)",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA85,AG85)","v":37.049999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},37.049999999999997,null,"",37.049999999999997,0,37.049999999999997,0,null,3,37.049999999999997,null,null,37.049999999999997,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 10\"",null,"Mosaic",null,"Picket",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA86,AG86)","v":60.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA86*(1-W86)+0.004999,2)","v":60.3},null,"",60.3,{"$f":"+W86","v":0},{"$f":"+X86","v":60.3},{"$f":"(AG86-AC86)/AG86","v":0},null,3,{"$f":"SUM(AJ86:AL86)+AE86","v":60.3},null,null,{"$f":"ROUND(AC86/(1-VLOOKUP(AF86,Group,2,FALSE)),2)","v":60.3},{"$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,"Shell",null,null,null,null,null,null,null,"Stock","b",{"$f":"IF(Suggested=\"Yes\",AA87,AG87)","v":56.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},56.85,null,"",56.85,0,56.85,0,null,3,56.85,null,null,56.85,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"2\" x 16\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA89,AG89)","v":15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":15},null,"",15,{"$f":"+W89","v":0},{"$f":"+X89","v":15},{"$f":"(AG89-AC89)/AG89","v":0},null,2,{"$f":"SUM(AJ89:AL89)+AE89","v":15},null,null,{"$f":"ROUND(AC89/(1-VLOOKUP(AF89,Group,2,FALSE)),2)","v":15},{"$f":"IF(VLOOKUP(AF89,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ89,1)-AJ89,2),Round,2,FALSE)+VLOOKUP(AF89,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,7,FALSE)=\"\",0,ROUND(AJ89-0.04999,1)-AJ89+AM89)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF89,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Decorative Majolica",null,null,null," "]
[]
[null,"Decos",null,null,"8\" x 8\"",null,"Field",null,"Majolica Decorative",null,null,null,null,null,null,"6.89 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA93,AG93)","v":10.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA93*(1-W93)+0.004999,2)","v":10.8},null,"",10.8,{"$f":"+W93","v":0},{"$f":"+X93","v":10.8},{"$f":"(AG93-AC93)/AG93","v":0},null,3,{"$f":"SUM(AJ93:AL93)+AE93","v":10.8},null,null,{"$f":"ROUND(AC93/(1-VLOOKUP(AF93,Group,2,FALSE)),2)","v":10.8},{"$f":"IF(VLOOKUP(AF93,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ93,1)-AJ93,2),Round,2,FALSE)+VLOOKUP(AF93,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",0,ROUND(AJ93-0.04999,1)-AJ93+AM93)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF93,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"4\" x 16\"",null,"Field",null,"Majolica Decorative",null,null,null,null,null,null,"10.33 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA94,AG94)","v":10.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA94*(1-W94)+0.004999,2)","v":10.8},null,"",10.8,{"$f":"+W94","v":0},{"$f":"+X94","v":10.8},{"$f":"(AG94-AC94)/AG94","v":0},null,3,{"$f":"SUM(AJ94:AL94)+AE94","v":10.8},null,null,{"$f":"ROUND(AC94/(1-VLOOKUP(AF94,Group,2,FALSE)),2)","v":10.8},{"$f":"IF(VLOOKUP(AF94,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ94,1)-AJ94,2),Round,2,FALSE)+VLOOKUP(AF94,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",0,ROUND(AJ94-0.04999,1)-AJ94+AM94)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF94,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"16\" x 16\"",null,"Field",null,"Majolica Decorative",null,null,null,null,null,null,"10.33 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA95,AG95)","v":10.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA95*(1-W95)+0.004999,2)","v":10.8},null,"",10.8,0,10.8,0,null,3,10.8,null,null,10.8,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\" Majolica Decorative",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA97,AG97)","v":25.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA97*(1-W97)+0.004999,2)","v":25.8},null,"",25.8,{"$f":"+W97","v":0},{"$f":"+X97","v":25.8},{"$f":"(AG97-AC97)/AG97","v":0},null,3,{"$f":"SUM(AJ97:AL97)+AE97","v":25.8},null,null,{"$f":"ROUND(AC97/(1-VLOOKUP(AF97,Group,2,FALSE)),2)","v":25.8},{"$f":"IF(VLOOKUP(AF97,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ97,1)-AJ97,2),Round,2,FALSE)+VLOOKUP(AF97,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",0,ROUND(AJ97-0.04999,1)-AJ97+AM97)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF97,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 13\"",null,"Mosaic",null,"3\" Hex (Esa) Majolica Decorative",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA98,AG98)","v":37.049999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA98*(1-W98)+0.004999,2)","v":37.049999999999997},null,"",37.049999999999997,0,37.049999999999997,0,null,3,37.049999999999997,null,null,37.049999999999997,0,0,"",null,"X"]
[]
[null,null,null,"Notes:","a) Stocked in color White Pastel only."]
[null,null,null,null,"b) Stocked in all colors except Amber Peach."]
[null,null,null,null,"c) Not available in color White Pastel."]
[]
[null,null,"MORE - High Definition 3D Technology Glazed Porcelain",null,null,null,null,null,null,null,null,null," ",null,null,null,null,"Item # Lookup:","EDMO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Milk          Nut          Sage          Sunset"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA108,AG108)","v":7.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA108*(1-W108)+0.004999,2)","v":7.35},null,"",7.35,{"$f":"+W108","v":0},{"$f":"+X108","v":7.35},{"$f":"(AG108-AC108)/AG108","v":0},null,1,{"$f":"SUM(AJ108:AL108)+AE108","v":7.35},null,null,{"$f":"ROUND(AC108/(1-VLOOKUP(AF108,Group,2,FALSE)),2)","v":7.35},{"$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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"11.72 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA109,AG109)","v":7.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.35,null,"",7.35,0,7.35,0,null,1,7.35,null,null,7.35,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA110,AG110)","v":8.0500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.0500000000000007,null,"",8.0500000000000007,0,8.0500000000000007,0,null,1,8.0500000000000007,null,null,8.0500000000000007,0,0,"",null,"X"]
[null,"Field Tile",null,null,"18\" x 30\"",null,"Field",null,null,null,"Discontinued 8/23/24",null,null,null,null,"14.78 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA111,AG111)","v":8.6999999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.6999999999999993,null,"",8.6999999999999993,0,8.6999999999999993,0,null,1,8.6999999999999993,null,null,8.6999999999999993,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\",AA112,AG112)","v":8.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.9499999999999993,null,"",8.9499999999999993,0,8.9499999999999993,0,null,1,8.9499999999999993,null,null,8.9499999999999993,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA114,AG114)","v":25.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA114*(1-W114)+0.004999,2)","v":25.7},null,"",25.7,{"$f":"+W114","v":0},{"$f":"+X114","v":25.7},{"$f":"(AG114-AC114)/AG114","v":0},null,3,{"$f":"SUM(AJ114:AL114)+AE114","v":25.7},null,null,{"$f":"ROUND(AC114/(1-VLOOKUP(AF114,Group,2,FALSE)),2)","v":25.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 13\"",null,"Mosaic",null,"3\" Hex (Esa)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA115,AG115)","v":42.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},42.5,null,"",42.5,0,42.5,0,null,3,42.5,null,null,42.5,0,0,"",null,"X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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."]
[null,null,"The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing"]
[null,null,"department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom."]
[null,null,"Print out individual price list for each series that can be attached to the back of your sample boards for easy reference."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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","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,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page","https://www.edimaxastor.it/"]
[]
[]
["Product","Direct Website Link"]
["Concert","https://www.edimaxastor.it/collection/93/concert"]
["Golden Age","https://www.edimaxastor.it/collection/94/golden-age"]
["Home","https://www.edimaxastor.it/collection/108/home"]
["More","https://www.edimaxastor.it/collection/97/more"]

{"sheet":"Changes","index":4,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,2,1,2]]}
["Date",null,"Description"]
["Announced","Series"]
[]
["New Products"]
["2022-03-01","More","High Definition 3D Technology Glazed Porcelain"]
["2022-03-01","Golden Age","High Definition Glazed Porcelain"]
["2023-12-14","Concert","High Definition 3D Technology Glazed Porcelain"]
["2024-07-01","Home","Glazed Porcelain"]
[]
[]
[]
[]
[]
[]
[]
["Discontinued Products"]
["2024-08-23","More","18\" x 30\" Field Tile format only in all colors."]
["2024-09-24","Golden Age","2\" x 12\" Decorative Field and Triangles Mosaic only in all colors."]