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

{"sheet":"Instructions","index":0,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Edimax"]
["File as","E"]
["Product Code","B"]
["CCTD Effective Date","5/1/25"," "]
[]
[]
[]
["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,null,null,"  "]
[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 - 5/1/25"}]
[]
[]
[]
[]
["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":"5/1/25"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-04-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,"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.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA26*(1-W26)+0.004999,2)","v":10.55},null,"YES",10.55,{"$f":"+W26","v":0},{"$f":"+X26","v":10.55},{"$f":"(AG26-AC26)/AG26","v":0},null,1,{"$f":"SUM(AJ26:AL26)+AE26","v":10.55},null,null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":10.55},{"$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.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.55,null,"YES",10.55,0,10.55,0,null,1,10.55,null,null,10.55,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.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA28*(1-W28)+0.004999,2)","v":8.75},null,"YES",8.75,{"$f":"+W28","v":0},{"$f":"+X28","v":8.75},{"$f":"(AG28-AC28)/AG28","v":0},null,1,{"$f":"SUM(AJ28:AL28)+AE28","v":8.75},null,null,{"$f":"ROUND(AC28/(1-VLOOKUP(AF28,Group,2,FALSE)),2)","v":8.75},{"$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.350000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},18.350000000000001,null,"YES",18.350000000000001,0,18.350000000000001,0,null,1,18.350000000000001,null,null,18.350000000000001,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.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":31.5},null,"YES",31.5,{"$f":"+W32","v":0},{"$f":"+X32","v":31.5},{"$f":"(AG32-AC32)/AG32","v":0},null,3,{"$f":"SUM(AJ32:AL32)+AE32","v":31.5},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":31.5},{"$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":26},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA34*(1-W34)+0.004999,2)","v":26},null,"YES",26,{"$f":"+W34","v":0},{"$f":"+X34","v":26},{"$f":"(AG34-AC34)/AG34","v":0},null,3,{"$f":"SUM(AJ34:AL34)+AE34","v":26},null,null,{"$f":"ROUND(AC34/(1-VLOOKUP(AF34,Group,2,FALSE)),2)","v":26},{"$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 (Esagonale) - Texture",null,null,null,null,null,null,"0.70 SF/SHT","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA35,AG35)","v":87.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":87.5},null,"YES",87.5,{"$f":"+W35","v":0},{"$f":"+X35","v":87.5},{"$f":"(AG35-AC35)/AG35","v":0},null,3,{"$f":"SUM(AJ35:AL35)+AE35","v":87.5},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":87.5},{"$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.799999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":38.799999999999997},null,"YES",38.799999999999997,{"$f":"+W36","v":0},{"$f":"+X36","v":38.799999999999997},{"$f":"(AG36-AC36)/AG36","v":0},null,3,{"$f":"SUM(AJ36:AL36)+AE36","v":38.799999999999997},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":38.799999999999997},{"$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.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":15.05},null,"YES",15.05,{"$f":"+W38","v":0},{"$f":"+X38","v":15.05},{"$f":"(AG38-AC38)/AG38","v":0},null,2,{"$f":"SUM(AJ38:AL38)+AE38","v":15.05},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":15.05},{"$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 (Ottagono)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA42,AG42)","v":49.4},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA42*(1-W42)+0.004999,2)","v":49.4},null,"YES",49.4,{"$f":"+W42","v":0},{"$f":"+X42","v":49.4},{"$f":"(AG42-AC42)/AG42","v":0},null,3,{"$f":"SUM(AJ42:AL42)+AE42","v":49.4},null,null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":49.4},{"$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":26},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA46*(1-W46)+0.004999,2)","v":26},null,"YES",26,{"$f":"+W46","v":0},{"$f":"+X46","v":26},{"$f":"(AG46-AC46)/AG46","v":0},null,3,{"$f":"SUM(AJ46:AL46)+AE46","v":26},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":26},{"$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.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA52*(1-W52)+0.004999,2)","v":10.5},null,"YES",10.5,{"$f":"+W52","v":0},{"$f":"+X52","v":10.5},{"$f":"(AG52-AC52)/AG52","v":0},null,1,{"$f":"SUM(AJ52:AL52)+AE52","v":10.5},null,null,{"$f":"ROUND(AC52/(1-VLOOKUP(AF52,Group,2,FALSE)),2)","v":10.5},{"$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.55,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.55,null,"YES",10.55,0,10.55,0,null,1,10.55,null,null,10.55,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.9,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.9,null,"YES",7.9,0,7.9,0,null,1,7.9,null,null,7.9,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.1999999999999993,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.1999999999999993,null,"YES",8.1999999999999993,0,8.1999999999999993,0,null,1,8.1999999999999993,null,null,8.1999999999999993,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.25,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":9.25},null,"YES",9.25,{"$f":"+W56","v":0},{"$f":"+X56","v":9.25},{"$f":"(AG56-AC56)/AG56","v":0},null,1,{"$f":"SUM(AJ56:AL56)+AE56","v":9.25},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":9.25},{"$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.1999999999999993,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.1999999999999993,null,"YES",9.1999999999999993,0,9.1999999999999993,0,null,1,9.1999999999999993,null,null,9.1999999999999993,0,0,"",null,"X"]
[null,"Field Tile",null,null,"48\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA58,AG58)","v":11},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11,null,"new",11,0,11,0,null,1,11,null,null,11,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,"Field",null,"Circles Decorative",null,null,null,null,null,null,"11.62 SF/CTN","Stock","b",{"$f":"IF(Suggested=\"Yes\",AA60,AG60)","v":8.5500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA60*(1-W60)+0.004999,2)","v":8.5500000000000007},null,"YES",8.5500000000000007,{"$f":"+W60","v":0},{"$f":"+X60","v":8.5500000000000007},{"$f":"(AG60-AC60)/AG60","v":0},null,3,{"$f":"SUM(AJ60:AL60)+AE60","v":8.5500000000000007},null,null,{"$f":"ROUND(AC60/(1-VLOOKUP(AF60,Group,2,FALSE)),2)","v":8.5500000000000007},{"$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.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA62*(1-W62)+0.004999,2)","v":25.85},null,"YES",25.85,{"$f":"+W62","v":0},{"$f":"+X62","v":25.85},{"$f":"(AG62-AC62)/AG62","v":0},null,3,{"$f":"SUM(AJ62:AL62)+AE62","v":25.85},null,null,{"$f":"ROUND(AC62/(1-VLOOKUP(AF62,Group,2,FALSE)),2)","v":25.85},{"$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.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},56.8,null,"YES",56.8,0,56.8,0,null,3,56.8,null,null,56.8,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,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":24.55},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":24.55},null,"YES",24.55,{"$f":"+W65","v":0},{"$f":"+X65","v":24.55},{"$f":"(AG65-AC65)/AG65","v":0},null,2,{"$f":"SUM(AJ65:AL65)+AE65","v":24.55},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":24.55},{"$f":"IF(VLOOKUP(AF65,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ65,1)-AJ65,2),Round,2,FALSE)+VLOOKUP(AF65,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",0,ROUND(AJ65-0.04999,1)-AJ65+AM65)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF65,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) Available in color White only.",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\",AA74,AG74)","v":10.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA74*(1-W74)+0.004999,2)","v":10.4},null,"",10.4,{"$f":"+W74","v":0},{"$f":"+X74","v":10.4},{"$f":"(AG74-AC74)/AG74","v":0},null,1,{"$f":"SUM(AJ74:AL74)+AE74","v":10.4},null,null,{"$f":"ROUND(AC74/(1-VLOOKUP(AF74,Group,2,FALSE)),2)","v":10.4},{"$f":"IF(VLOOKUP(AF74,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ74,1)-AJ74,2),Round,2,FALSE)+VLOOKUP(AF74,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",0,ROUND(AJ74-0.04999,1)-AJ74+AM74)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF74,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\",AA75,AG75)","v":10.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA75*(1-W75)+0.004999,2)","v":10.55},null,"YES",10.55,{"$f":"+W75","v":0},{"$f":"+X75","v":10.55},{"$f":"(AG75-AC75)/AG75","v":0},null,1,{"$f":"SUM(AJ75:AL75)+AE75","v":10.55},null,null,{"$f":"ROUND(AC75/(1-VLOOKUP(AF75,Group,2,FALSE)),2)","v":10.55},{"$f":"IF(VLOOKUP(AF75,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ75,1)-AJ75,2),Round,2,FALSE)+VLOOKUP(AF75,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF75,Group,7,FALSE)=\"\",0,ROUND(AJ75-0.04999,1)-AJ75+AM75)","v":0},{"$f":"IF(VLOOKUP(AF75,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF75,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\",AA76,AG76)","v":10.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.55,null,"YES",10.55,0,10.55,0,null,1,10.55,null,null,10.55,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\",AA77,AG77)","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,"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\",AA78,AG78)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":8.8000000000000007},null,"YES",8.8000000000000007,{"$f":"+W78","v":0},{"$f":"+X78","v":8.8000000000000007},{"$f":"(AG78-AC78)/AG78","v":0},null,1,{"$f":"SUM(AJ78:AL78)+AE78","v":8.8000000000000007},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":8.8000000000000007},{"$f":"IF(VLOOKUP(AF78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ78,1)-AJ78,2),Round,2,FALSE)+VLOOKUP(AF78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",0,ROUND(AJ78-0.04999,1)-AJ78+AM78)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF78,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\",AA80,AG80)","v":18.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},18.45,null,"YES",18.45,0,18.45,0,null,1,18.45,null,null,18.45,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\",AA82,AG82)","v":25.95},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":25.95},null,"YES",25.95,{"$f":"+W82","v":0},{"$f":"+X82","v":25.95},{"$f":"(AG82-AC82)/AG82","v":0},null,3,{"$f":"SUM(AJ82:AL82)+AE82","v":25.95},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":25.95},{"$f":"IF(VLOOKUP(AF82,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ82,1)-AJ82,2),Round,2,FALSE)+VLOOKUP(AF82,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",0,ROUND(AJ82-0.04999,1)-AJ82+AM82)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF82,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,"6 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA83,AG83)","v":37.200000000000003},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},37.200000000000003,null,"YES",37.200000000000003,0,37.200000000000003,0,null,3,37.200000000000003,null,null,37.200000000000003,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 10\"",null,"Mosaic",null,"Picket",null,null,null,null,null,null,"9 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA84,AG84)","v":60.45},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":60.45},null,"YES",60.45,{"$f":"+W84","v":0},{"$f":"+X84","v":60.45},{"$f":"(AG84-AC84)/AG84","v":0},null,3,{"$f":"SUM(AJ84:AL84)+AE84","v":60.45},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":60.45},{"$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 12\"",null,"Mosaic",null,"Shell",null,null,null,null,null,null,null,"Stock","b",{"$f":"IF(Suggested=\"Yes\",AA85,AG85)","v":57},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},57,null,"YES",57,0,57,0,null,3,57,null,null,57,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"2\" x 16\"",null,"Bullnose",null,null,null,null,null,null,null,null,"20 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA87,AG87)","v":15.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA87*(1-W87)+0.004999,2)","v":15.05},null,"YES",15.05,{"$f":"+W87","v":0},{"$f":"+X87","v":15.05},{"$f":"(AG87-AC87)/AG87","v":0},null,2,{"$f":"SUM(AJ87:AL87)+AE87","v":15.05},null,null,{"$f":"ROUND(AC87/(1-VLOOKUP(AF87,Group,2,FALSE)),2)","v":15.05},{"$f":"IF(VLOOKUP(AF87,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ87,1)-AJ87,2),Round,2,FALSE)+VLOOKUP(AF87,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF87,Group,7,FALSE)=\"\",0,ROUND(AJ87-0.04999,1)-AJ87+AM87)","v":0},{"$f":"IF(VLOOKUP(AF87,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF87,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA91,AG91)","v":10.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":10.8},null,"",10.8,{"$f":"+W91","v":0},{"$f":"+X91","v":10.8},{"$f":"(AG91-AC91)/AG91","v":0},null,3,{"$f":"SUM(AJ91:AL91)+AE91","v":10.8},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":10.8},{"$f":"IF(VLOOKUP(AF91,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ91,1)-AJ91,2),Round,2,FALSE)+VLOOKUP(AF91,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",0,ROUND(AJ91-0.04999,1)-AJ91+AM91)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF91,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA92,AG92)","v":10.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":10.95},null,"YES",10.95,{"$f":"+W92","v":0},{"$f":"+X92","v":10.95},{"$f":"(AG92-AC92)/AG92","v":0},null,3,{"$f":"SUM(AJ92:AL92)+AE92","v":10.95},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":10.95},{"$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,"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\",AA93,AG93)","v":10.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA93*(1-W93)+0.004999,2)","v":10.95},null,"YES",10.95,0,10.95,0,null,3,10.95,null,null,10.95,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\",AA95,AG95)","v":25.95},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA95*(1-W95)+0.004999,2)","v":25.95},null,"YES",25.95,{"$f":"+W95","v":0},{"$f":"+X95","v":25.95},{"$f":"(AG95-AC95)/AG95","v":0},null,3,{"$f":"SUM(AJ95:AL95)+AE95","v":25.95},null,null,{"$f":"ROUND(AC95/(1-VLOOKUP(AF95,Group,2,FALSE)),2)","v":25.95},{"$f":"IF(VLOOKUP(AF95,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ95,1)-AJ95,2),Round,2,FALSE)+VLOOKUP(AF95,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",0,ROUND(AJ95-0.04999,1)-AJ95+AM95)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF95,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,"6 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA96,AG96)","v":37.200000000000003},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA96*(1-W96)+0.004999,2)","v":37.200000000000003},null,"YES",37.200000000000003,0,37.200000000000003,0,null,3,37.200000000000003,null,null,37.200000000000003,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\",AA106,AG106)","v":7.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":7.5},null,"YES",7.5,{"$f":"+W106","v":0},{"$f":"+X106","v":7.5},{"$f":"(AG106-AC106)/AG106","v":0},null,1,{"$f":"SUM(AJ106:AL106)+AE106","v":7.5},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":7.5},{"$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,"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\",AA107,AG107)","v":7.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.6,null,"YES",7.6,0,7.6,0,null,1,7.6,null,null,7.6,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA108,AG108)","v":8.1999999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.1999999999999993,null,"YES",8.1999999999999993,0,8.1999999999999993,0,null,1,8.1999999999999993,null,null,8.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",null,null,{"$f":"IF(Suggested=\"Yes\",AA109,AG109)","v":9.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.1,null,"YES",9.1,0,9.1,0,null,1,9.1,null,null,9.1,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\",AA111,AG111)","v":25.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA111*(1-W111)+0.004999,2)","v":25.85},null,"YES",25.85,{"$f":"+W111","v":0},{"$f":"+X111","v":25.85},{"$f":"(AG111-AC111)/AG111","v":0},null,3,{"$f":"SUM(AJ111:AL111)+AE111","v":25.85},null,null,{"$f":"ROUND(AC111/(1-VLOOKUP(AF111,Group,2,FALSE)),2)","v":25.85},{"$f":"IF(VLOOKUP(AF111,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ111,1)-AJ111,2),Round,2,FALSE)+VLOOKUP(AF111,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",0,ROUND(AJ111-0.04999,1)-AJ111+AM111)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF111,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 13\"",null,"Mosaic",null,"3\" Hex (Esa)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA112,AG112)","v":42.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},42.65,null,"YES",42.65,0,42.65,0,null,3,42.65,null,null,42.65,0,0,"",null,"X"]
[]
[null,null,"SYMPHONY - High Definition 3D Technology Glazed Porcelain",null,null,null,null,null,null,null,null,null," ",null,null,null,null,"Item # Lookup:","EDSY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Moon          Persian          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,"11.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA118,AG118)","v":10.050000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA118*(1-W118)+0.004999,2)","v":10.050000000000001},null,"new",10.050000000000001,{"$f":"+W118","v":0},{"$f":"+X118","v":10.050000000000001},{"$f":"(AG118-AC118)/AG118","v":0},null,1,{"$f":"SUM(AJ118:AL118)+AE118","v":10.050000000000001},null,null,{"$f":"ROUND(AC118/(1-VLOOKUP(AF118,Group,2,FALSE)),2)","v":10.050000000000001},{"$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,"Field Tile",null,null,"8\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"6.89 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA119,AG119)","v":10.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA119*(1-W119)+0.004999,2)","v":10.35},null,"new",10.35,{"$f":"+W119","v":0},{"$f":"+X119","v":10.35},{"$f":"(AG119-AC119)/AG119","v":0},null,1,{"$f":"SUM(AJ119:AL119)+AE119","v":10.35},null,null,{"$f":"ROUND(AC119/(1-VLOOKUP(AF119,Group,2,FALSE)),2)","v":10.35},{"$f":"IF(VLOOKUP(AF119,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ119,1)-AJ119,2),Round,2,FALSE)+VLOOKUP(AF119,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",0,ROUND(AJ119-0.04999,1)-AJ119+AM119)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF119,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\",AA120,AG120)","v":7.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA120*(1-W120)+0.004999,2)","v":7.75},null,"new",7.75,{"$f":"+W120","v":0},{"$f":"+X120","v":7.75},{"$f":"(AG120-AC120)/AG120","v":0},null,1,{"$f":"SUM(AJ120:AL120)+AE120","v":7.75},null,null,{"$f":"ROUND(AC120/(1-VLOOKUP(AF120,Group,2,FALSE)),2)","v":7.75},{"$f":"IF(VLOOKUP(AF120,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ120,1)-AJ120,2),Round,2,FALSE)+VLOOKUP(AF120,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",0,ROUND(AJ120-0.04999,1)-AJ120+AM120)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF120,Group,7,FALSE))","v":""},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\",AA121,AG121)","v":7.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.75,null,"new",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 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.49 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA122,AG122)","v":9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9,null,"new",9,0,9,0,null,1,9,null,null,9,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 24\"",null,"Field",null,"Ocean Decorative",null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA124,AG124)","v":9.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA124*(1-W124)+0.004999,2)","v":9.9},null,"new",9.9,{"$f":"+W124","v":0},{"$f":"+X124","v":9.9},{"$f":"(AG124-AC124)/AG124","v":0},null,3,{"$f":"SUM(AJ124:AL124)+AE124","v":9.9},null,null,{"$f":"ROUND(AC124/(1-VLOOKUP(AF124,Group,2,FALSE)),2)","v":9.9},{"$f":"IF(VLOOKUP(AF124,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ124,1)-AJ124,2),Round,2,FALSE)+VLOOKUP(AF124,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",0,ROUND(AJ124-0.04999,1)-AJ124+AM124)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF124,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"24\" x 48\"",null,"Field",null,"Ocean Decorative",null,null,null,null,null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA125,AG125)","v":11.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA125*(1-W125)+0.004999,2)","v":11.9},null,"new",11.9,{"$f":"+W125","v":0},{"$f":"+X125","v":11.9},{"$f":"(AG125-AC125)/AG125","v":0},null,3,{"$f":"SUM(AJ125:AL125)+AE125","v":11.9},null,null,{"$f":"ROUND(AC125/(1-VLOOKUP(AF125,Group,2,FALSE)),2)","v":11.9},{"$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,"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\",AA127,AG127)","v":25.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA127*(1-W127)+0.004999,2)","v":25.85},null,"new",25.85,{"$f":"+W127","v":0},{"$f":"+X127","v":25.85},{"$f":"(AG127-AC127)/AG127","v":0},null,3,{"$f":"SUM(AJ127:AL127)+AE127","v":25.85},null,null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":25.85},{"$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,"Decos",null,null,"12\" x 12-1/4\"",null,"Mosaic",null,"Chevron",null,null,null,null,null,null,"9 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA128,AG128)","v":38.799999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},38.799999999999997,null,"new",38.799999999999997,0,38.799999999999997,0,null,3,38.799999999999997,null,null,38.799999999999997,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Crisp (1\" x 6\")",null,null,null,null,null,null,"9 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA129,AG129)","v":38.549999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},38.549999999999997,null,"new",38.549999999999997,0,38.549999999999997,0,null,3,38.549999999999997,null,null,38.549999999999997,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,"13 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA131,AG131)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA131*(1-W131)+0.004999,2)","v":24.35},null,"new",24.35,{"$f":"+W131","v":0},{"$f":"+X131","v":24.35},{"$f":"(AG131-AC131)/AG131","v":0},null,2,{"$f":"SUM(AJ131:AL131)+AE131","v":24.35},null,null,{"$f":"ROUND(AC131/(1-VLOOKUP(AF131,Group,2,FALSE)),2)","v":24.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,"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":13,"n_cols":2,"rows_kept":13,"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"]
["Symphony","https://www.edimaxastor.it/collection/114/symphony"]

{"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"]
["2024-10-09","Golden Age","48\" x 48\" Field Tile format added and is available in color White only."]
["2025-06-01","Symohony","High Definition 3D Technology 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."]