{"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","Ape"]
["File as","A"]
["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,4,null,0,null,"No",0,null,null," "]
[null,5,null,0,null,"No",0,null,null,null," "]
[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":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[[5,0,5,10],[50,0,50,10],[52,0,52,10],[2,5,2,10],[3,4,3,7],[10,4,10,8],[11,4,11,8],[12,4,12,8]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'A' - Ape"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 5/1/25"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type"]
["1",null,"Acquarella",null,"Glazed Ceramic Wall"]
["1",null,"Altea",null,"Glazed Ceramic Wall"]
[1,null,"Calacatta Slow",null,"Glazed Ceramic Wall & Glazed Porcelain Floor"]
[1,null,"Calpe",null,"Glazed Ceramic Wall"]
[1,null,"Dynamic",null,"Glazed Ceramic Wall"]
[1,null,"Fado",null,"Glazed Ceramic Wall"]
[1,null,"Grunge",null,"Glazed Ceramic Wall"]
[1,null,"Hamptons",null,"Glazed Ceramic Wall"]
[1,null,"Hefesto",null,"Glazed Ceramic Wall"]
[1,null,"Lautia",null,"Glazed Ceramic Wall"]
[2,null,"Magnetism",null,"Glazed Ceramic Wall & Glazed Porcelain Floor"]
[2,null,"Manacor",null,"Glazed Ceramic Wall"]
[2,null,"Memories",null,"Glazed Ceramic Wall"]
[2,null,"Murus",null,"Glazed Porcelain Wall"]
[2,null,"Onyx Slow",null,"Glazed Ceramic Wall & Glazed Porcelain Floor"]
[2,null,"Pim Pam Pum",null,"Glazed Ceramic Wall"]
[2,null,"Savannah",null,"Glazed Ceramic Wall"]
[2,null,"Seville",null,"Glazed Ceramic Wall"]
[2,null,"Switch",null,"Glazed Ceramic Wall & Glazed Porcelain Floor"]
[2,null,"Toscana",null,"Glazed Porcelain"]
[3,null,"Verona",null,"Glazed Ceramic Wall & Glazed Porcelain Floor"]
[3,null,"Vintage",null,"Glazed Ceramic Wall"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":310,"n_cols":39,"rows_kept":310,"cut":false,"hidden":false,"merged":[[289,2,289,17],[9,12,9,17],[18,2,18,17],[17,12,17,13],[19,2,19,17],[10,12,10,13],[292,2,292,17],[9,23,9,30],[12,20,12,21],[9,20,9,21],[294,2,294,17],[293,2,293,17],[291,2,291,17],[13,28,13,30],[14,12,15,17],[12,12,12,17]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",Y1,AE1)","v":0.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y1*(1-U1)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+U1","v":0},0.05,{"$f":"(AE1-AA1)/AE1","v":0},null,1,{"$f":"SUM(AH1:AJ1)+AC1","v":0.05},null,null,{"$f":"ROUND(AA1/(1-VLOOKUP(AD1,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AD1,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH1,1)-AH1,2),Round,2,FALSE)+VLOOKUP(AD1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD1,Group,7,FALSE)=\"\",0,ROUND(AH1-0.04999,1)-AH1+AK1)","v":0},{"$f":"IF(VLOOKUP(AD1,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD1,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",Y2,AE2)","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,{"$f":"IF(Suggested=\"Yes\",Y3,AE3)","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,{"$f":"IF(Suggested=\"Yes\",'Price List'!Y4,'Price List'!AE4)","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,{"$f":"IF(Suggested=\"Yes\",'Price List'!Y5,'Price List'!AE5)","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,{"$f":"IF(Suggested=\"Yes\",'Price List'!Y6,'Price List'!AE6)","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,{"$f":"IF(Suggested=\"Yes\",'Price List'!Y7,'Price List'!AE7)","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,"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,"X"]
[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,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",Y11,AE11)","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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'A' - Ape"},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,{"$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,null,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,{"$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,"X"]
[null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"+Q$11","v":"List Price"},"U/M",{"$f":"+S$11","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+Z$11","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AD$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,"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,"X"]
[null,null,"ACQUARELLA - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APAC"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Blue          Graphite          Grey          Light Green          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,"X"]
[null,"Field Tile",null,null,"3\" x 12\"",null,"Field",null,null,null,null,null,null,"10.76 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y26,AE26)","v":6.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y26*(1-U26)+0.004999,2)","v":6.5},null,"YES",6.5,{"$f":"+U26","v":0},{"$f":"+V26","v":6.5},{"$f":"(AE26-AA26)/AE26","v":0},null,1,{"$f":"SUM(AH26:AJ26)+AC26","v":6.5},null,null,{"$f":"ROUND(AA26/(1-VLOOKUP(AD26,Group,2,FALSE)),2)","v":6.5},{"$f":"IF(VLOOKUP(AD26,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH26,1)-AH26,2),Round,2,FALSE)+VLOOKUP(AD26,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD26,Group,7,FALSE)=\"\",0,ROUND(AH26-0.04999,1)-AH26+AK26)","v":0},{"$f":"IF(VLOOKUP(AD26,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD26,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"8\" x 8\"",null,"Field - Deco Incision",null,null,null,null,null,null,"10.76 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y27,AE27)","v":6.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},6.5,null,"YES",6.5,0,6.5,0,null,1,6.5,null,null,6.5,0,0,"",null,"X"]
[]
[null,null,null,"Note:","a) 8\"x8\" Deco Incision Field Tile has 25 pieces per carton."]
[]
[null,null,"ALTEA - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APAL"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Ivory          Sky          Taupe          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,"X"]
[null,"Field Tile",null,"Gloss:","3\" x 12\"",null,"Field",null,null,null,null,null,null,"10.76 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y35,AE35)","v":6.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y35*(1-U35)+0.004999,2)","v":6.8},null,"YES",6.8,{"$f":"+U35","v":0},{"$f":"+V35","v":6.8},{"$f":"(AE35-AA35)/AE35","v":0},null,1,{"$f":"SUM(AH35:AJ35)+AC35","v":6.8},null,null,{"$f":"ROUND(AA35/(1-VLOOKUP(AD35,Group,2,FALSE)),2)","v":6.8},{"$f":"IF(VLOOKUP(AD35,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH35,1)-AH35,2),Round,2,FALSE)+VLOOKUP(AD35,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD35,Group,7,FALSE)=\"\",0,ROUND(AH35-0.04999,1)-AH35+AK35)","v":0},{"$f":"IF(VLOOKUP(AD35,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD35,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,"X"]
[null,"Decos",null,null,"0.6\" x 12\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y37,AE37)","v":9.3000000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y37*(1-U37)+0.004999,2)","v":9.3000000000000007},null,"YES",9.3000000000000007,{"$f":"+U37","v":0},{"$f":"+V37","v":9.3000000000000007},{"$f":"(AE37-AA37)/AE37","v":0},null,3,{"$f":"SUM(AH37:AJ37)+AC37","v":9.3000000000000007},null,null,{"$f":"ROUND(AA37/(1-VLOOKUP(AD37,Group,2,FALSE)),2)","v":9.3000000000000007},{"$f":"IF(VLOOKUP(AD37,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH37,1)-AH37,2),Round,2,FALSE)+VLOOKUP(AD37,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD37,Group,7,FALSE)=\"\",0,ROUND(AH37-0.04999,1)-AH37+AK37)","v":0},{"$f":"IF(VLOOKUP(AD37,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD37,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CALACATTA SLOW - Glazed Ceramic Wall & Glazed Porcelain Floor",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APCS"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Calacatta Slow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"3\" x 12\"",null,"Field",null,null,null,null,null,null,"10.76 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y43,AE43)","v":6.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y43*(1-U43)+0.004999,2)","v":6.5},null,"YES",6.5,{"$f":"+U43","v":0},{"$f":"+V43","v":6.5},{"$f":"(AE43-AA43)/AE43","v":0},null,1,{"$f":"SUM(AH43:AJ43)+AC43","v":6.5},null,null,{"$f":"ROUND(AA43/(1-VLOOKUP(AD43,Group,2,FALSE)),2)","v":6.5},{"$f":"IF(VLOOKUP(AD43,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH43,1)-AH43,2),Round,2,FALSE)+VLOOKUP(AD43,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD43,Group,7,FALSE)=\"\",0,ROUND(AH43-0.04999,1)-AH43+AK43)","v":0},{"$f":"IF(VLOOKUP(AD43,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD43,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"5.5\" x 6.3\"",null,"Field - Hex",null,null,null,null,null,null,"3.55 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y44,AE44)","v":9.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.85,null,"YES",9.85,0,9.85,0,null,1,9.85,null,null,9.85,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"0.6\" x 12\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y46,AE46)","v":9.3000000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.3000000000000007,null,"YES",9.3000000000000007,0,9.3000000000000007,0,null,3,9.3000000000000007,null,null,9.3000000000000007,0,0,"",null,"X"]
[]
[null,null,null,"Note:","a) Glazed Porcelain and may be used on floor applications."]
[]
[null,null,"CALPE - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APCA"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Ivory          Sky          Taupe          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,"X"]
[null,"Field Tile",null,"Matte:","3\" x 12\"",null,"Field",null,null,null,null,null,null,"10.76 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y54,AE54)","v":6.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y54*(1-U54)+0.004999,2)","v":6.8},null,"YES",6.8,{"$f":"+U54","v":0},{"$f":"+V54","v":6.8},{"$f":"(AE54-AA54)/AE54","v":0},null,1,{"$f":"SUM(AH54:AJ54)+AC54","v":6.8},null,null,{"$f":"ROUND(AA54/(1-VLOOKUP(AD54,Group,2,FALSE)),2)","v":6.8},{"$f":"IF(VLOOKUP(AD54,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH54,1)-AH54,2),Round,2,FALSE)+VLOOKUP(AD54,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD54,Group,7,FALSE)=\"\",0,ROUND(AH54-0.04999,1)-AH54+AK54)","v":0},{"$f":"IF(VLOOKUP(AD54,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD54,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,"X"]
[null,"Decos",null,null,"0.6\" x 12\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y56,AE56)","v":9.3000000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y56*(1-U56)+0.004999,2)","v":9.3000000000000007},null,"YES",9.3000000000000007,{"$f":"+U56","v":0},{"$f":"+V56","v":9.3000000000000007},{"$f":"(AE56-AA56)/AE56","v":0},null,3,{"$f":"SUM(AH56:AJ56)+AC56","v":9.3000000000000007},null,null,{"$f":"ROUND(AA56/(1-VLOOKUP(AD56,Group,2,FALSE)),2)","v":9.3000000000000007},{"$f":"IF(VLOOKUP(AD56,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH56,1)-AH56,2),Round,2,FALSE)+VLOOKUP(AD56,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD56,Group,7,FALSE)=\"\",0,ROUND(AH56-0.04999,1)-AH56+AK56)","v":0},{"$f":"IF(VLOOKUP(AD56,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD56,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Packaging is changing from 5.38 SF/CTN to 10.76 SF/CTN as inventory with old packaging is depleted."]
[]
[null,null,"DYNAMIC - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APDY"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Celeste          Coral          Mostaza          Neutro          Pearl          Skylight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"3\" x 12\"",null,"Field",null,null,null,null,null,null,"5.38 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y64,AE64)","v":10.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y64*(1-U64)+0.004999,2)","v":10.7},null,"YES",10.7,{"$f":"+U64","v":0},{"$f":"+V64","v":10.7},{"$f":"(AE64-AA64)/AE64","v":0},null,1,{"$f":"SUM(AH64:AJ64)+AC64","v":10.7},null,null,{"$f":"ROUND(AA64/(1-VLOOKUP(AD64,Group,2,FALSE)),2)","v":10.7},{"$f":"IF(VLOOKUP(AD64,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH64,1)-AH64,2),Round,2,FALSE)+VLOOKUP(AD64,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD64,Group,7,FALSE)=\"\",0,ROUND(AH64-0.04999,1)-AH64+AK64)","v":0},{"$f":"IF(VLOOKUP(AD64,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD64,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"6\" x 7\" ",null,"Field - Scales (Escamas)",null,null,null,null,null,null,"5.38 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y65,AE65)","v":15.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y65*(1-U65)+0.004999,2)","v":15.6},null,"YES",15.6,0,15.6,0,null,1,15.6,null,null,15.6,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"0.6\" x 12\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",Y67,AE67)","v":9.3000000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y67*(1-U67)+0.004999,2)","v":9.3000000000000007},null,"YES",9.3000000000000007,{"$f":"+U67","v":0},{"$f":"+V67","v":9.3000000000000007},{"$f":"(AE67-AA67)/AE67","v":0},null,3,{"$f":"SUM(AH67:AJ67)+AC67","v":9.3000000000000007},null,null,{"$f":"ROUND(AA67/(1-VLOOKUP(AD67,Group,2,FALSE)),2)","v":9.3000000000000007},{"$f":"IF(VLOOKUP(AD67,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH67,1)-AH67,2),Round,2,FALSE)+VLOOKUP(AD67,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD67,Group,7,FALSE)=\"\",0,ROUND(AH67-0.04999,1)-AH67+AK67)","v":0},{"$f":"IF(VLOOKUP(AD67,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD67,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Crackle Finish, seal prior to grouting."]
[]
[null,null,"FADO - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APFA"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Acqua          Beige          Grey          Sky          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,"X"]
[null,"Field Tile",null,null,"5\" x 5\"",null,"Field",null,null,null,null,null,null,"5.38 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y75,AE75)","v":8.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y75*(1-U75)+0.004999,2)","v":8.65},null,"YES",8.65,{"$f":"+U75","v":0},{"$f":"+V75","v":8.65},{"$f":"(AE75-AA75)/AE75","v":0},null,1,{"$f":"SUM(AH75:AJ75)+AC75","v":8.65},null,null,{"$f":"ROUND(AA75/(1-VLOOKUP(AD75,Group,2,FALSE)),2)","v":8.65},{"$f":"IF(VLOOKUP(AD75,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH75,1)-AH75,2),Round,2,FALSE)+VLOOKUP(AD75,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD75,Group,7,FALSE)=\"\",0,ROUND(AH75-0.04999,1)-AH75+AK75)","v":0},{"$f":"IF(VLOOKUP(AD75,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD75,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"2.5\" x 15.6\"",null,"Field",null,null,null,null,null,null,"10.76 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y76,AE76)","v":8.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.9499999999999993,null,"YES",8.9499999999999993,0,8.9499999999999993,0,null,1,8.9499999999999993,null,null,8.9499999999999993,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,"X"]
[null,"Decos",null,null,"5\" x 5\"",null,"Deco Field",null,"Amalia",null,null,null,null,"5.38 SF/CTN","Stock","b",{"$f":"IF(Suggested=\"Yes\",Y78,AE78)","v":9.6999999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y78*(1-U78)+0.004999,2)","v":9.6999999999999993},null,"YES",9.6999999999999993,{"$f":"+U78","v":0},{"$f":"+V78","v":9.6999999999999993},{"$f":"(AE78-AA78)/AE78","v":0},null,3,{"$f":"SUM(AH78:AJ78)+AC78","v":9.6999999999999993},null,null,{"$f":"ROUND(AA78/(1-VLOOKUP(AD78,Group,2,FALSE)),2)","v":9.6999999999999993},{"$f":"IF(VLOOKUP(AD78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH78,1)-AH78,2),Round,2,FALSE)+VLOOKUP(AD78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD78,Group,7,FALSE)=\"\",0,ROUND(AH78-0.04999,1)-AH78+AK78)","v":0},{"$f":"IF(VLOOKUP(AD78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD78,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"5\" x 5\"",null,"Deco Field",null,"Carmo",null,null,null,null,"5.38 SF/CTN","Stock","b",9.6999999999999993,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y79*(1-U79)+0.004999,2)","v":9.6999999999999993},null,"YES",9.6999999999999993,{"$f":"+U79","v":0},{"$f":"+V79","v":9.6999999999999993},{"$f":"(AE79-AA79)/AE79","v":0},null,3,{"$f":"SUM(AH79:AJ79)+AC79","v":9.6999999999999993},null,null,{"$f":"ROUND(AA79/(1-VLOOKUP(AD79,Group,2,FALSE)),2)","v":9.6999999999999993},{"$f":"IF(VLOOKUP(AD79,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH79,1)-AH79,2),Round,2,FALSE)+VLOOKUP(AD79,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD79,Group,7,FALSE)=\"\",0,ROUND(AH79-0.04999,1)-AH79+AK79)","v":0},{"$f":"IF(VLOOKUP(AD79,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD79,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"5\" x 5\"",null,"Deco Field",null,"Mariza",null,null,null,null,"5.38 SF/CTN","Stock","b",9.6999999999999993,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.6999999999999993,null,"YES",9.6999999999999993,0,9.6999999999999993,0,null,3,9.6999999999999993,null,null,9.6999999999999993,0,0,"",null,"X"]
[null,"Decos",null,null,"5\" x 5\"",null,"Deco Field",null,"Moura",null,null,null,null,"5.38 SF/CTN","Stock","b",9.6999999999999993,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.6999999999999993,null,"YES",9.6999999999999993,0,9.6999999999999993,0,null,3,9.6999999999999993,null,null,9.6999999999999993,0,0,"",null,"X"]
[null,"Decos",null,null,"5\" x 5\"",null,"Deco Field",null,"Pontes",null,null,null,null,"5.38 SF/CTN","Stock","b",9.6999999999999993,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.6999999999999993,null,"YES",9.6999999999999993,0,9.6999999999999993,0,null,3,9.6999999999999993,null,null,9.6999999999999993,0,0,"",null,"X"]
[null,"Decos",null,null,"5\" x 5\"",null,"Deco Field",null,"Tavares",null,null,null,null,"5.38 SF/CTN","Stock","b",9.6999999999999993,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.6999999999999993,null,"YES",9.6999999999999993,0,9.6999999999999993,0,null,3,9.6999999999999993,null,null,9.6999999999999993,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"0.6\" x 5\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y85,AE85)","v":7.45},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y85*(1-U85)+0.004999,2)","v":7.45},null,"YES",7.45,{"$f":"+U85","v":0},{"$f":"+V85","v":7.45},{"$f":"(AE85-AA85)/AE85","v":0},null,2,{"$f":"SUM(AH85:AJ85)+AC85","v":7.45},null,null,{"$f":"ROUND(AA85/(1-VLOOKUP(AD85,Group,2,FALSE)),2)","v":7.45},{"$f":"IF(VLOOKUP(AD85,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH85,1)-AH85,2),Round,2,FALSE)+VLOOKUP(AD85,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD85,Group,7,FALSE)=\"\",0,ROUND(AH85-0.04999,1)-AH85+AK85)","v":0},{"$f":"IF(VLOOKUP(AD85,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD85,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Packaging is changing from 10.76 SF/CTN to 11.08 SF/CTN as inventory with old packaging is depleted."]
[null,null,null,null,"b) 30 pieces per carton."]
[]
[null,null,"GRUNGE - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APGR"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Aqua          Blue          Grey          Iron          Oxid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"3\" x 12\"",null,"Field",null,null,null,null,null,null,"4.84 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y94,AE94)","v":8.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y94*(1-U94)+0.004999,2)","v":8.9},null,"YES",8.9,{"$f":"+U94","v":0},{"$f":"+V94","v":8.9},{"$f":"(AE94-AA94)/AE94","v":0},null,1,{"$f":"SUM(AH94:AJ94)+AC94","v":8.9},null,null,{"$f":"ROUND(AA94/(1-VLOOKUP(AD94,Group,2,FALSE)),2)","v":8.9},{"$f":"IF(VLOOKUP(AD94,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH94,1)-AH94,2),Round,2,FALSE)+VLOOKUP(AD94,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD94,Group,7,FALSE)=\"\",0,ROUND(AH94-0.04999,1)-AH94+AK94)","v":0},{"$f":"IF(VLOOKUP(AD94,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD94,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,"X"]
[null,"Decos",null,null,"0.6\" x 12\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y96,AE96)","v":9.3000000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y96*(1-U96)+0.004999,2)","v":9.3000000000000007},null,"YES",9.3000000000000007,{"$f":"+U96","v":0},{"$f":"+V96","v":9.3000000000000007},{"$f":"(AE96-AA96)/AE96","v":0},null,3,{"$f":"SUM(AH96:AJ96)+AC96","v":9.3000000000000007},null,null,{"$f":"ROUND(AA96/(1-VLOOKUP(AD96,Group,2,FALSE)),2)","v":9.3000000000000007},{"$f":"IF(VLOOKUP(AD96,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH96,1)-AH96,2),Round,2,FALSE)+VLOOKUP(AD96,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD96,Group,7,FALSE)=\"\",0,ROUND(AH96-0.04999,1)-AH96+AK96)","v":0},{"$f":"IF(VLOOKUP(AD96,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD96,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,"X"]
[null,null,"HAMPTONS - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APHA"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Cherry          Mist          Night          Snow          Victorian Green"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Glossy:","2\" x 6\"",null,"Field - Arabasque",null,null,"Havens",null,null,null,"5.38 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y102,AE102)","v":16.149999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y102*(1-U102)+0.004999,2)","v":16.149999999999999},null,"YES",16.149999999999999,{"$f":"+U102","v":0},{"$f":"+V102","v":16.149999999999999},{"$f":"(AE102-AA102)/AE102","v":0},null,1,{"$f":"SUM(AH102:AJ102)+AC102","v":16.149999999999999},null,null,{"$f":"ROUND(AA102/(1-VLOOKUP(AD102,Group,2,FALSE)),2)","v":16.149999999999999},{"$f":"IF(VLOOKUP(AD102,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH102,1)-AH102,2),Round,2,FALSE)+VLOOKUP(AD102,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD102,Group,7,FALSE)=\"\",0,ROUND(AH102-0.04999,1)-AH102+AK102)","v":0},{"$f":"IF(VLOOKUP(AD102,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD102,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"2\" x 7\"",null,"Field - Picket",null,null,"Gin",null,null,null,"5.81 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y103,AE103)","v":16.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},16.05,null,"YES",16.05,0,16.05,0,null,1,16.05,null,null,16.05,0,0,"",null,"X"]
[]
[null,null,"HEFESTO - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APHE"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Anthracite          Bronze          Gold"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5\" x 10\"",null,"Field",null,null,null,null,null,null,"5.06 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y109,AE109)","v":34.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y109*(1-U109)+0.004999,2)","v":34.15},null,"YES",34.15,{"$f":"+U109","v":0},{"$f":"+V109","v":34.15},{"$f":"(AE109-AA109)/AE109","v":0},null,1,{"$f":"SUM(AH109:AJ109)+AC109","v":34.15},null,null,{"$f":"ROUND(AA109/(1-VLOOKUP(AD109,Group,2,FALSE)),2)","v":34.15},{"$f":"IF(VLOOKUP(AD109,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH109,1)-AH109,2),Round,2,FALSE)+VLOOKUP(AD109,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD109,Group,7,FALSE)=\"\",0,ROUND(AH109-0.04999,1)-AH109+AK109)","v":0},{"$f":"IF(VLOOKUP(AD109,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD109,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","Hefesto Series can be used as an accent with the Magnetism Series."]
[]
[null,null,"LAUTIA - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APLA"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Acqua          Anthracite          Blue          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,"X"]
[null,"Field Tile",null,null,"3\" x 6\"",null,"Field",null,null,null,null,null,null,"5.38 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y117,AE117)","v":5.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y117*(1-U117)+0.004999,2)","v":5.95},null,"YES",5.95,{"$f":"+U117","v":0},{"$f":"+V117","v":5.95},{"$f":"(AE117-AA117)/AE117","v":0},null,1,{"$f":"SUM(AH117:AJ117)+AC117","v":5.95},null,null,{"$f":"ROUND(AA117/(1-VLOOKUP(AD117,Group,2,FALSE)),2)","v":5.95},{"$f":"IF(VLOOKUP(AD117,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH117,1)-AH117,2),Round,2,FALSE)+VLOOKUP(AD117,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD117,Group,7,FALSE)=\"\",0,ROUND(AH117-0.04999,1)-AH117+AK117)","v":0},{"$f":"IF(VLOOKUP(AD117,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD117,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"MAGNETISM - Glazed Ceramic Wall & Glazed Porcelain Floor",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APMG"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Blue          Corten          Graphite          Green          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,"X"]
[null,"Field Tile",null,null,"2.5\" x 10\"",null,"Field",null,null,null,null,null,null,"5.06 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y123,AE123)","v":8.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y123*(1-U123)+0.004999,2)","v":8.9499999999999993},null,"YES",8.9499999999999993,{"$f":"+U123","v":0},{"$f":"+V123","v":8.9499999999999993},{"$f":"(AE123-AA123)/AE123","v":0},null,1,{"$f":"SUM(AH123:AJ123)+AC123","v":8.9499999999999993},null,null,{"$f":"ROUND(AA123/(1-VLOOKUP(AD123,Group,2,FALSE)),2)","v":8.9499999999999993},{"$f":"IF(VLOOKUP(AD123,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH123,1)-AH123,2),Round,2,FALSE)+VLOOKUP(AD123,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD123,Group,7,FALSE)=\"\",0,ROUND(AH123-0.04999,1)-AH123+AK123)","v":0},{"$f":"IF(VLOOKUP(AD123,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD123,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"5.5\" x 6.3\"",null,"Field - Hex",null,null,null,null,null,null,"4.52 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y124,AE124)","v":10.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y124*(1-U124)+0.004999,2)","v":10.25},null,"YES",10.25,{"$f":"+U124","v":0},{"$f":"+V124","v":10.25},{"$f":"(AE124-AA124)/AE124","v":0},null,1,{"$f":"SUM(AH124:AJ124)+AC124","v":10.25},null,null,{"$f":"ROUND(AA124/(1-VLOOKUP(AD124,Group,2,FALSE)),2)","v":10.25},{"$f":"IF(VLOOKUP(AD124,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH124,1)-AH124,2),Round,2,FALSE)+VLOOKUP(AD124,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD124,Group,7,FALSE)=\"\",0,ROUND(AH124-0.04999,1)-AH124+AK124)","v":0},{"$f":"IF(VLOOKUP(AD124,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD124,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","Magnetism Series can be used as an accent with the Hefesto Series."]
[null,null,null,null,"a) Glazed Porcelain and may be used on floor applications."]
[]
[null,null,"MANACOR - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APMA"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Acqua          Blue          Green          Grey          Navy          Night          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,"X"]
[null,"Field Tile",null,null,"5\" x 5\"",null,"Field",null,null,null,null,null,null,"4.41 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y133,AE133)","v":9.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y133*(1-U133)+0.004999,2)","v":9.35},null,"YES",9.35,{"$f":"+U133","v":0},{"$f":"+V133","v":9.35},{"$f":"(AE133-AA133)/AE133","v":0},null,1,{"$f":"SUM(AH133:AJ133)+AC133","v":9.35},null,null,{"$f":"ROUND(AA133/(1-VLOOKUP(AD133,Group,2,FALSE)),2)","v":9.35},{"$f":"IF(VLOOKUP(AD133,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH133,1)-AH133,2),Round,2,FALSE)+VLOOKUP(AD133,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD133,Group,7,FALSE)=\"\",0,ROUND(AH133-0.04999,1)-AH133+AK133)","v":0},{"$f":"IF(VLOOKUP(AD133,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD133,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"5\" x 5\"",null,"Field - Deco Drach (Circle)",null,null,null,null,null,null,"4.20 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y134,AE134)","v":10.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y134*(1-U134)+0.004999,2)","v":10.3},null,"YES",10.3,{"$f":"+U134","v":0},{"$f":"+V134","v":10.3},{"$f":"(AE134-AA134)/AE134","v":0},null,1,{"$f":"SUM(AH134:AJ134)+AC134","v":10.3},null,null,{"$f":"ROUND(AA134/(1-VLOOKUP(AD134,Group,2,FALSE)),2)","v":10.3},{"$f":"IF(VLOOKUP(AD134,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH134,1)-AH134,2),Round,2,FALSE)+VLOOKUP(AD134,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD134,Group,7,FALSE)=\"\",0,ROUND(AH134-0.04999,1)-AH134+AK134)","v":0},{"$f":"IF(VLOOKUP(AD134,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD134,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"5\" x 5\"",null,"Field - Deco Petra (Raised Pyramid)",null,null,null,null,null,null,"4.20 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y135,AE135)","v":10.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y135*(1-U135)+0.004999,2)","v":10.3},null,"YES",10.3,{"$f":"+U135","v":0},{"$f":"+V135","v":10.3},{"$f":"(AE135-AA135)/AE135","v":0},null,1,{"$f":"SUM(AH135:AJ135)+AC135","v":10.3},null,null,{"$f":"ROUND(AA135/(1-VLOOKUP(AD135,Group,2,FALSE)),2)","v":10.3},{"$f":"IF(VLOOKUP(AD135,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH135,1)-AH135,2),Round,2,FALSE)+VLOOKUP(AD135,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD135,Group,7,FALSE)=\"\",0,ROUND(AH135-0.04999,1)-AH135+AK135)","v":0},{"$f":"IF(VLOOKUP(AD135,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD135,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) 5\" x 5\" Deco Field Tile has 28 pieces per carton."]
[]
[null,null,"MEMORIES - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APME"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Acqua          Mist          Night          Smoke          Victorian Green          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,"X"]
[null,"Field Tile",null,"Glossy:","2.5\" x 5\"",null,"Field - Rectangle",null,null,"Memories",null,null,null,"5.38 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y143,AE143)","v":10.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y143*(1-U143)+0.004999,2)","v":10.55},null,"YES",10.55,{"$f":"+U143","v":0},{"$f":"+V143","v":10.55},{"$f":"(AE143-AA143)/AE143","v":0},null,1,{"$f":"SUM(AH143:AJ143)+AC143","v":10.55},null,null,{"$f":"ROUND(AA143/(1-VLOOKUP(AD143,Group,2,FALSE)),2)","v":10.55},{"$f":"IF(VLOOKUP(AD143,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH143,1)-AH143,2),Round,2,FALSE)+VLOOKUP(AD143,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD143,Group,7,FALSE)=\"\",0,ROUND(AH143-0.04999,1)-AH143+AK143)","v":0},{"$f":"IF(VLOOKUP(AD143,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD143,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"5\" x 5\"",null,"Field - Scales",null,null,"Smiles",null,null,null,"3.55 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y144,AE144)","v":14.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},14.7,null,"YES",14.7,0,14.7,0,null,1,14.7,null,null,14.7,0,0,"",null,"X"]
[null,"Field Tile",null,null,"4\" x 6\"",null,"Field - Diamond",null,null,"Looks",null,null,null,"5.38 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y145,AE145)","v":15.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.15,null,"YES",15.15,0,15.15,0,null,1,15.15,null,null,15.15,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"0.6\" x 12\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y147,AE147)","v":7.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y147*(1-U147)+0.004999,2)","v":7.5},null,"YES",7.5,{"$f":"+U147","v":0},{"$f":"+V147","v":7.5},{"$f":"(AE147-AA147)/AE147","v":0},null,2,{"$f":"SUM(AH147:AJ147)+AC147","v":7.5},null,null,{"$f":"ROUND(AA147/(1-VLOOKUP(AD147,Group,2,FALSE)),2)","v":7.5},{"$f":"IF(VLOOKUP(AD147,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH147,1)-AH147,2),Round,2,FALSE)+VLOOKUP(AD147,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD147,Group,7,FALSE)=\"\",0,ROUND(AH147-0.04999,1)-AH147+AK147)","v":0},{"$f":"IF(VLOOKUP(AD147,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD147,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"MURUS - Glazed Porcelain Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APMU"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Griseo          Nix          Nocta          Oceanum          Terra          Viridi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Glossy:","3\" x 11\"",null,"Field",null,null,null,null,null,null,"10.55 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y153,AE153)","v":9.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y153*(1-U153)+0.004999,2)","v":9.25},null,"YES",9.25,{"$f":"+U153","v":0},{"$f":"+V153","v":9.25},{"$f":"(AE153-AA153)/AE153","v":0},null,1,{"$f":"SUM(AH153:AJ153)+AC153","v":9.25},null,null,{"$f":"ROUND(AA153/(1-VLOOKUP(AD153,Group,2,FALSE)),2)","v":9.25},{"$f":"IF(VLOOKUP(AD153,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH153,1)-AH153,2),Round,2,FALSE)+VLOOKUP(AD153,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD153,Group,7,FALSE)=\"\",0,ROUND(AH153-0.04999,1)-AH153+AK153)","v":0},{"$f":"IF(VLOOKUP(AD153,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD153,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Packaging is changing from 10.55 SF/CTN to 6.35 SF/CTN as inventory with old packaging is depleted."]
[]
[null,null,"ONYX SLOW - Glazed Ceramic Wall & Glazed Porcelain Floor",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APOS"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Onyx Slow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"3\" x 12\"",null,"Field",null,null,null,null,null,null,"10.76 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y161,AE161)","v":6.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y161*(1-U161)+0.004999,2)","v":6.45},null,"YES",6.45,{"$f":"+U161","v":0},{"$f":"+V161","v":6.45},{"$f":"(AE161-AA161)/AE161","v":0},null,1,{"$f":"SUM(AH161:AJ161)+AC161","v":6.45},null,null,{"$f":"ROUND(AA161/(1-VLOOKUP(AD161,Group,2,FALSE)),2)","v":6.45},{"$f":"IF(VLOOKUP(AD161,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH161,1)-AH161,2),Round,2,FALSE)+VLOOKUP(AD161,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD161,Group,7,FALSE)=\"\",0,ROUND(AH161-0.04999,1)-AH161+AK161)","v":0},{"$f":"IF(VLOOKUP(AD161,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD161,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"5.5\" x 6.3\"",null,"Field - Hex",null,null,null,null,null,null,"3.55 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y162,AE162)","v":9.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.85,null,"YES",9.85,0,9.85,0,null,1,9.85,null,null,9.85,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"0.6\" x 12\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y164,AE164)","v":9.3000000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y164*(1-U164)+0.004999,2)","v":9.3000000000000007},null,"YES",9.3000000000000007,{"$f":"+U164","v":0},{"$f":"+V164","v":9.3000000000000007},{"$f":"(AE164-AA164)/AE164","v":0},null,3,{"$f":"SUM(AH164:AJ164)+AC164","v":9.3000000000000007},null,null,{"$f":"ROUND(AA164/(1-VLOOKUP(AD164,Group,2,FALSE)),2)","v":9.3000000000000007},{"$f":"IF(VLOOKUP(AD164,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH164,1)-AH164,2),Round,2,FALSE)+VLOOKUP(AD164,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD164,Group,7,FALSE)=\"\",0,ROUND(AH164-0.04999,1)-AH164+AK164)","v":0},{"$f":"IF(VLOOKUP(AD164,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD164,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Glazed Porcelain and may be used on floor applications."]
[]
[null,null,"PIM PAM PUM - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APPP"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Blue          Cream          Grey          Moss          Night          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,"X"]
[null,"Field Tile",null,"Glossy:","4\" x 12\"",null,"Field - Pum",null,null,null,null,null,null,"5.81 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y172,AE172)","v":8.4499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y172*(1-U172)+0.004999,2)","v":8.4499999999999993},null,"YES",8.4499999999999993,{"$f":"+U172","v":0},{"$f":"+V172","v":8.4499999999999993},{"$f":"(AE172-AA172)/AE172","v":0},null,1,{"$f":"SUM(AH172:AJ172)+AC172","v":8.4499999999999993},null,null,{"$f":"ROUND(AA172/(1-VLOOKUP(AD172,Group,2,FALSE)),2)","v":8.4499999999999993},{"$f":"IF(VLOOKUP(AD172,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH172,1)-AH172,2),Round,2,FALSE)+VLOOKUP(AD172,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD172,Group,7,FALSE)=\"\",0,ROUND(AH172-0.04999,1)-AH172+AK172)","v":0},{"$f":"IF(VLOOKUP(AD172,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD172,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"4\" x 12\"",null,"Field - Deco Incision - Pim",null,null,null,null,null,null,"5.81 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y173,AE173)","v":12.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y173*(1-U173)+0.004999,2)","v":12.65},null,"YES",12.65,{"$f":"+U173","v":0},{"$f":"+V173","v":12.65},{"$f":"(AE173-AA173)/AE173","v":0},null,1,{"$f":"SUM(AH173:AJ173)+AC173","v":12.65},null,null,{"$f":"ROUND(AA173/(1-VLOOKUP(AD173,Group,2,FALSE)),2)","v":12.65},{"$f":"IF(VLOOKUP(AD173,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH173,1)-AH173,2),Round,2,FALSE)+VLOOKUP(AD173,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD173,Group,7,FALSE)=\"\",0,ROUND(AH173-0.04999,1)-AH173+AK173)","v":0},{"$f":"IF(VLOOKUP(AD173,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD173,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile",null,"Matte:","4\" x 12\"",null,"Field - Deco Incision - Pam",null,null,null,null,null,null,"5.81 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",Y175,AE175)","v":12.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y175*(1-U175)+0.004999,2)","v":12.65},null,"YES",12.65,{"$f":"+U175","v":0},{"$f":"+V175","v":12.65},{"$f":"(AE175-AA175)/AE175","v":0},null,1,{"$f":"SUM(AH175:AJ175)+AC175","v":12.65},null,null,{"$f":"ROUND(AA175/(1-VLOOKUP(AD175,Group,2,FALSE)),2)","v":12.65},{"$f":"IF(VLOOKUP(AD175,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH175,1)-AH175,2),Round,2,FALSE)+VLOOKUP(AD175,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD175,Group,7,FALSE)=\"\",0,ROUND(AH175-0.04999,1)-AH175+AK175)","v":0},{"$f":"IF(VLOOKUP(AD175,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD175,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) 4\"x12\" Deco Incision Field Tile has 18 pieces per carton."]
[]
[null,null,"SAVANNAH - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APSA"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Berilo          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,"X"]
[null,"Field Tile",null,null,"4\" x 4\"",null,"Field",null,null,null,null,null,null,"5.38 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y183,AE183)","v":10.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y183*(1-U183)+0.004999,2)","v":10.45},null,"YES",10.45,{"$f":"+U183","v":0},{"$f":"+V183","v":10.45},{"$f":"(AE183-AA183)/AE183","v":0},null,1,{"$f":"SUM(AH183:AJ183)+AC183","v":10.45},null,null,{"$f":"ROUND(AA183/(1-VLOOKUP(AD183,Group,2,FALSE)),2)","v":10.45},{"$f":"IF(VLOOKUP(AD183,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH183,1)-AH183,2),Round,2,FALSE)+VLOOKUP(AD183,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD183,Group,7,FALSE)=\"\",0,ROUND(AH183-0.04999,1)-AH183+AK183)","v":0},{"$f":"IF(VLOOKUP(AD183,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD183,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"2\" x 10\"",null,"Field",null,null,null,null,null,null,"6.46 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y184,AE184)","v":11.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y184*(1-U184)+0.004999,2)","v":11.4},null,"YES",11.4,{"$f":"+U184","v":0},{"$f":"+V184","v":11.4},{"$f":"(AE184-AA184)/AE184","v":0},null,1,{"$f":"SUM(AH184:AJ184)+AC184","v":11.4},null,null,{"$f":"ROUND(AA184/(1-VLOOKUP(AD184,Group,2,FALSE)),2)","v":11.4},{"$f":"IF(VLOOKUP(AD184,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH184,1)-AH184,2),Round,2,FALSE)+VLOOKUP(AD184,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD184,Group,7,FALSE)=\"\",0,ROUND(AH184-0.04999,1)-AH184+AK184)","v":0},{"$f":"IF(VLOOKUP(AD184,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD184,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,".6\" x 10\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y186,AE186)","v":10.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y186*(1-U186)+0.004999,2)","v":10.1},null,"YES",10.1,{"$f":"+U186","v":0},{"$f":"+V186","v":10.1},{"$f":"(AE186-AA186)/AE186","v":0},null,2,{"$f":"SUM(AH186:AJ186)+AC186","v":10.1},null,null,{"$f":"ROUND(AA186/(1-VLOOKUP(AD186,Group,2,FALSE)),2)","v":10.1},{"$f":"IF(VLOOKUP(AD186,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH186,1)-AH186,2),Round,2,FALSE)+VLOOKUP(AD186,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD186,Group,7,FALSE)=\"\",0,ROUND(AH186-0.04999,1)-AH186+AK186)","v":0},{"$f":"IF(VLOOKUP(AD186,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD186,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"SEVILLE - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APSE"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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          Bone          Green          Grey          Honey          Indigo          Snow          Turquoise"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 4\"",null,"Field",null,null,null,null,null,null,"5.38 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y192,AE192)","v":8.1999999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y192*(1-U192)+0.004999,2)","v":8.1999999999999993},null,"YES",8.1999999999999993,{"$f":"+U192","v":0},{"$f":"+V192","v":8.1999999999999993},{"$f":"(AE192-AA192)/AE192","v":0},null,1,{"$f":"SUM(AH192:AJ192)+AC192","v":8.1999999999999993},null,null,{"$f":"ROUND(AA192/(1-VLOOKUP(AD192,Group,2,FALSE)),2)","v":8.1999999999999993},{"$f":"IF(VLOOKUP(AD192,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH192,1)-AH192,2),Round,2,FALSE)+VLOOKUP(AD192,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD192,Group,7,FALSE)=\"\",0,ROUND(AH192-0.04999,1)-AH192+AK192)","v":0},{"$f":"IF(VLOOKUP(AD192,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD192,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"2.5\" x 8\"",null,"Field",null,null,null,null,null,null,"5.38 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y193,AE193)","v":8.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y193*(1-U193)+0.004999,2)","v":8.25},null,"YES",8.25,{"$f":"+U193","v":0},{"$f":"+V193","v":8.25},{"$f":"(AE193-AA193)/AE193","v":0},null,1,{"$f":"SUM(AH193:AJ193)+AC193","v":8.25},null,null,{"$f":"ROUND(AA193/(1-VLOOKUP(AD193,Group,2,FALSE)),2)","v":8.25},{"$f":"IF(VLOOKUP(AD193,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH193,1)-AH193,2),Round,2,FALSE)+VLOOKUP(AD193,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD193,Group,7,FALSE)=\"\",0,ROUND(AH193-0.04999,1)-AH193+AK193)","v":0},{"$f":"IF(VLOOKUP(AD193,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD193,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,"X"]
[null,"Decos",null,null,"0.5\" x 8\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y195,AE195)","v":6.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y195*(1-U195)+0.004999,2)","v":6.2},null,"YES",6.2,{"$f":"+U195","v":0},{"$f":"+V195","v":6.2},{"$f":"(AE195-AA195)/AE195","v":0},null,3,{"$f":"SUM(AH195:AJ195)+AC195","v":6.2},null,null,{"$f":"ROUND(AA195/(1-VLOOKUP(AD195,Group,2,FALSE)),2)","v":6.2},{"$f":"IF(VLOOKUP(AD195,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH195,1)-AH195,2),Round,2,FALSE)+VLOOKUP(AD195,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD195,Group,7,FALSE)=\"\",0,ROUND(AH195-0.04999,1)-AH195+AK195)","v":0},{"$f":"IF(VLOOKUP(AD195,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD195,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"SWITCH - Glazed Ceramic Wall & Glazed Porcelain Floor",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APSW"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Blue          Dark Blue          Graphite          Grey          Victorian Green          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,"X"]
[null,"Field Tile",null,"Matte:","2\" x 10\"",null,"Field - Picket",null,null,null,null,null,null,"2.37 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y201,AE201)","v":10.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y201*(1-U201)+0.004999,2)","v":10.35},null,"YES",10.35,{"$f":"+U201","v":0},{"$f":"+V201","v":10.35},{"$f":"(AE201-AA201)/AE201","v":0},null,1,{"$f":"SUM(AH201:AJ201)+AC201","v":10.35},null,null,{"$f":"ROUND(AA201/(1-VLOOKUP(AD201,Group,2,FALSE)),2)","v":10.35},{"$f":"IF(VLOOKUP(AD201,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH201,1)-AH201,2),Round,2,FALSE)+VLOOKUP(AD201,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD201,Group,7,FALSE)=\"\",0,ROUND(AH201-0.04999,1)-AH201+AK201)","v":0},{"$f":"IF(VLOOKUP(AD201,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD201,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,"X"]
[null,"Decos",null,null,"0.6\" x 12\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y203,AE203)","v":9.3000000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y203*(1-U203)+0.004999,2)","v":9.3000000000000007},null,"YES",9.3000000000000007,{"$f":"+U203","v":0},{"$f":"+V203","v":9.3000000000000007},{"$f":"(AE203-AA203)/AE203","v":0},null,3,{"$f":"SUM(AH203:AJ203)+AC203","v":9.3000000000000007},null,null,{"$f":"ROUND(AA203/(1-VLOOKUP(AD203,Group,2,FALSE)),2)","v":9.3000000000000007},{"$f":"IF(VLOOKUP(AD203,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH203,1)-AH203,2),Round,2,FALSE)+VLOOKUP(AD203,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD203,Group,7,FALSE)=\"\",0,ROUND(AH203-0.04999,1)-AH203+AK203)","v":0},{"$f":"IF(VLOOKUP(AD203,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD203,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile",null,"Gloss:","2.5\" x 5\"",null,"Field",null,null,null,null,null,null,"4.88 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y205,AE205)","v":9.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y205*(1-U205)+0.004999,2)","v":9.25},null,"YES",9.25,{"$f":"+U205","v":0},{"$f":"+V205","v":9.25},{"$f":"(AE205-AA205)/AE205","v":0},null,1,{"$f":"SUM(AH205:AJ205)+AC205","v":9.25},null,null,{"$f":"ROUND(AA205/(1-VLOOKUP(AD205,Group,2,FALSE)),2)","v":9.25},{"$f":"IF(VLOOKUP(AD205,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH205,1)-AH205,2),Round,2,FALSE)+VLOOKUP(AD205,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD205,Group,7,FALSE)=\"\",0,ROUND(AH205-0.04999,1)-AH205+AK205)","v":0},{"$f":"IF(VLOOKUP(AD205,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD205,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"2\" x 10\"",null,"Field - Picket",null,null,null,null,null,null,"2.37 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y206,AE206)","v":10.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y206*(1-U206)+0.004999,2)","v":10.35},null,"YES",10.35,0,10.35,0,null,1,10.35,null,null,10.35,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,"X"]
[null,"Decos",null,null,"0.6\" x 12\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y208,AE208)","v":9.3000000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y208*(1-U208)+0.004999,2)","v":9.3000000000000007},null,"YES",9.3000000000000007,{"$f":"+U208","v":0},{"$f":"+V208","v":9.3000000000000007},{"$f":"(AE208-AA208)/AE208","v":0},null,3,{"$f":"SUM(AH208:AJ208)+AC208","v":9.3000000000000007},null,null,{"$f":"ROUND(AA208/(1-VLOOKUP(AD208,Group,2,FALSE)),2)","v":9.3000000000000007},{"$f":"IF(VLOOKUP(AD208,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH208,1)-AH208,2),Round,2,FALSE)+VLOOKUP(AD208,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD208,Group,7,FALSE)=\"\",0,ROUND(AH208-0.04999,1)-AH208+AK208)","v":0},{"$f":"IF(VLOOKUP(AD208,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD208,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"TOSCANA - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APTO"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Ash          Cotton          Ghost Green          Herb          Lake Blue"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5\" x 8\"",null,"Field",null,null,null,null,null,null,"3.87 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y214,AE214)","v":8.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y214*(1-U214)+0.004999,2)","v":8.6},null,"YES",8.6,{"$f":"+U214","v":0},{"$f":"+V214","v":8.6},{"$f":"(AE214-AA214)/AE214","v":0},null,1,{"$f":"SUM(AH214:AJ214)+AC214","v":8.6},null,null,{"$f":"ROUND(AA214/(1-VLOOKUP(AD214,Group,2,FALSE)),2)","v":8.6},{"$f":"IF(VLOOKUP(AD214,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH214,1)-AH214,2),Round,2,FALSE)+VLOOKUP(AD214,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD214,Group,7,FALSE)=\"\",0,ROUND(AH214-0.04999,1)-AH214+AK214)","v":0},{"$f":"IF(VLOOKUP(AD214,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD214,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","a) Packaging is changing from 3.77 SF/CTN to 3.87 SF/CTN as inventory with old packaging is depleted."]
[]
[null,null,"VERONA - Glazed Ceramic Wall & Glazed Porcelain Floor",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APVE"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,"Field Tile",null,null,"3\" x 12\"",null,"Field",null,null,null,null,null,null,"4.84 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y222,AE222)","v":6.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y222*(1-U222)+0.004999,2)","v":6.7},null,"YES",6.7,{"$f":"+U222","v":0},{"$f":"+V222","v":6.7},{"$f":"(AE222-AA222)/AE222","v":0},null,1,{"$f":"SUM(AH222:AJ222)+AC222","v":6.7},null,null,{"$f":"ROUND(AA222/(1-VLOOKUP(AD222,Group,2,FALSE)),2)","v":6.7},{"$f":"IF(VLOOKUP(AD222,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH222,1)-AH222,2),Round,2,FALSE)+VLOOKUP(AD222,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD222,Group,7,FALSE)=\"\",0,ROUND(AH222-0.04999,1)-AH222+AK222)","v":0},{"$f":"IF(VLOOKUP(AD222,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD222,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"5.5\" x 6.3\"",null,"Field - Hexagon",null,null,null,null,null,null,"4.52 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y223,AE223)","v":9.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.6,null,"YES",9.6,0,9.6,0,null,1,9.6,null,null,9.6,0,0,"",null,"X"]
[null,"Field Tile",null,null,"8\" x 8\"",null,"Field - Octagon",null,null,null,null,null,null,"10.76 SF/CTN","Stock","a,b",{"$f":"IF(Suggested=\"Yes\",Y224,AE224)","v":7.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y224*(1-U224)+0.004999,2)","v":7.55},null,"YES",7.55,{"$f":"+U224","v":0},{"$f":"+V224","v":7.55},{"$f":"(AE224-AA224)/AE224","v":0},null,1,{"$f":"SUM(AH224:AJ224)+AC224","v":7.55},null,null,{"$f":"ROUND(AA224/(1-VLOOKUP(AD224,Group,2,FALSE)),2)","v":7.55},{"$f":"IF(VLOOKUP(AD224,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH224,1)-AH224,2),Round,2,FALSE)+VLOOKUP(AD224,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD224,Group,7,FALSE)=\"\",0,ROUND(AH224-0.04999,1)-AH224+AK224)","v":0},{"$f":"IF(VLOOKUP(AD224,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD224,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,"X"]
[null,"Decos",null,null,"0.6\" x 12\"",null,"Pencil Bullnose (Edge Stick)",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y226,AE226)","v":9.8000000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y226*(1-U226)+0.004999,2)","v":9.8000000000000007},null,"YES",9.8000000000000007,{"$f":"+U226","v":0},{"$f":"+V226","v":9.8000000000000007},{"$f":"(AE226-AA226)/AE226","v":0},null,3,{"$f":"SUM(AH226:AJ226)+AC226","v":9.8000000000000007},null,null,{"$f":"ROUND(AA226/(1-VLOOKUP(AD226,Group,2,FALSE)),2)","v":9.8000000000000007},{"$f":"IF(VLOOKUP(AD226,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH226,1)-AH226,2),Round,2,FALSE)+VLOOKUP(AD226,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD226,Group,7,FALSE)=\"\",0,ROUND(AH226-0.04999,1)-AH226+AK226)","v":0},{"$f":"IF(VLOOKUP(AD226,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD226,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,"X"]
[null,null,null,"Color:","Black"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1.5\" x 1.5\"",null,"Dot (Taco Firenze)       (to be used with 8\" x 8\" Octagon)       ",null,null,null,null,null,null,"26 PCS/CTN","Stock","a,c",{"$f":"IF(Suggested=\"Yes\",Y230,AE230)","v":0.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y230*(1-U230)+0.004999,2)","v":0.5},null,"YES",0.5,{"$f":"+U230","v":0},{"$f":"+V230","v":0.5},{"$f":"(AE230-AA230)/AE230","v":0},null,3,{"$f":"SUM(AH230:AJ230)+AC230","v":0.5},null,null,{"$f":"ROUND(AA230/(1-VLOOKUP(AD230,Group,2,FALSE)),2)","v":0.5},{"$f":"IF(VLOOKUP(AD230,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH230,1)-AH230,2),Round,2,FALSE)+VLOOKUP(AD230,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD230,Group,7,FALSE)=\"\",0,ROUND(AH230-0.04999,1)-AH230+AK230)","v":0},{"$f":"IF(VLOOKUP(AD230,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD230,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Glazed Porcelain and may be used on floor applications."]
[null,null,null,null,"b) Available in color White only.",null,null,null,"c) Need 2.25 dots per SF of 8\" x 8\" octagon field tile."]
[]
[null,null,"VINTAGE - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","APVI"]
[null,null,"   ",null,null,null,null,null,null,null,null,null,null,null,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:","Graphite          Ivory          Lake          Natural          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,"X"]
[null,"Field Tile",null,null,"3\" x 6\"",null,"Field",null,null,null,null,null,null,"5.38 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y239,AE239)","v":6.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y239*(1-U239)+0.004999,2)","v":6.95},null,"YES",6.95,{"$f":"+U239","v":0},{"$f":"+V239","v":6.95},{"$f":"(AE239-AA239)/AE239","v":0},null,1,{"$f":"SUM(AH239:AJ239)+AC239","v":6.95},null,null,{"$f":"ROUND(AA239/(1-VLOOKUP(AD239,Group,2,FALSE)),2)","v":6.95},{"$f":"IF(VLOOKUP(AD239,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH239,1)-AH239,2),Round,2,FALSE)+VLOOKUP(AD239,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD239,Group,7,FALSE)=\"\",0,ROUND(AH239-0.04999,1)-AH239+AK239)","v":0},{"$f":"IF(VLOOKUP(AD239,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD239,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"4\" x 8\"",null,"Field - Elongated Hex (Hextra)",null,null,null,null,null,null,"5.38 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",Y240,AE240)","v":8.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y240*(1-U240)+0.004999,2)","v":8.5},null,"YES",8.5,{"$f":"+U240","v":0},{"$f":"+V240","v":8.5},{"$f":"(AE240-AA240)/AE240","v":0},null,1,{"$f":"SUM(AH240:AJ240)+AC240","v":8.5},null,null,{"$f":"ROUND(AA240/(1-VLOOKUP(AD240,Group,2,FALSE)),2)","v":8.5},{"$f":"IF(VLOOKUP(AD240,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH240,1)-AH240,2),Round,2,FALSE)+VLOOKUP(AD240,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD240,Group,7,FALSE)=\"\",0,ROUND(AH240-0.04999,1)-AH240+AK240)","v":0},{"$f":"IF(VLOOKUP(AD240,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD240,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"3\" x 12\"",null,"Field",null,null,null,null,null,null,"10.76 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",Y241,AE241)","v":6.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y241*(1-U241)+0.004999,2)","v":6.8},null,"YES",6.8,{"$f":"+U241","v":0},{"$f":"+V241","v":6.8},{"$f":"(AE241-AA241)/AE241","v":0},null,1,{"$f":"SUM(AH241:AJ241)+AC241","v":6.8},null,null,{"$f":"ROUND(AA241/(1-VLOOKUP(AD241,Group,2,FALSE)),2)","v":6.8},{"$f":"IF(VLOOKUP(AD241,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH241,1)-AH241,2),Round,2,FALSE)+VLOOKUP(AD241,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD241,Group,7,FALSE)=\"\",0,ROUND(AH241-0.04999,1)-AH241+AK241)","v":0},{"$f":"IF(VLOOKUP(AD241,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD241,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,"X"]
[null,"Trim",null,null,"3\" x 12\"",null,"Bullnose",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",Y243,AE243)","v":8.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y243*(1-U243)+0.004999,2)","v":8.75},null,"YES",8.75,{"$f":"+U243","v":0},{"$f":"+V243","v":8.75},{"$f":"(AE243-AA243)/AE243","v":0},null,2,{"$f":"SUM(AH243:AJ243)+AC243","v":8.75},null,null,{"$f":"ROUND(AA243/(1-VLOOKUP(AD243,Group,2,FALSE)),2)","v":8.75},{"$f":"IF(VLOOKUP(AD243,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH243,1)-AH243,2),Round,2,FALSE)+VLOOKUP(AD243,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD243,Group,7,FALSE)=\"\",0,ROUND(AH243-0.04999,1)-AH243+AK243)","v":0},{"$f":"IF(VLOOKUP(AD243,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD243,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Not available in colors Lake and Natural."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"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,"Trim",null,null,null,null,"2023 Tabletop Display",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",Y299,AE299)","v":143.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($Y299*(1-U299)+0.004999,2)","v":143.65},null,"new",143.65,{"$f":"+U299","v":0},{"$f":"+V299","v":143.65},{"$f":"(AE299-AA299)/AE299","v":0},null,2,{"$f":"SUM(AH299:AJ299)+AC299","v":143.65},null,null,{"$f":"ROUND(AA299/(1-VLOOKUP(AD299,Group,2,FALSE)),2)","v":143.65},{"$f":"IF(VLOOKUP(AD299,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AH299,1)-AH299,2),Round,2,FALSE)+VLOOKUP(AD299,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AD299,Group,7,FALSE)=\"\",0,ROUND(AH299-0.04999,1)-AH299+AK299)","v":0},{"$f":"IF(VLOOKUP(AD299,Group,7,FALSE)=\"\",\"\",VLOOKUP(AD299,Group,7,FALSE))","v":""},null,"X"]
[]
[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":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","https://www.conestogatile.com/"]
[]
["Manufacturer's Home Page","https://www.apegrupo.com/en/products/"]
[]
[]
["Product","Direct Website Link"]
["Acquarella","https://www.apegrupo.com/en/products/acquarella/"]
["Altea","https://www.apegrupo.com/en/products/altea/"]
["Calacatta Slow","https://www.apegrupo.com/en/products/calacatta-slow/"]
["Calpe","https://www.apegrupo.com/en/products/calpe/"]
["Dynamic","https://www.apegrupo.com/en/products/dynamic/"]
["Fado","https://www.apegrupo.com/en/products/fado/"]
["Grunge","https://www.apegrupo.com/en/products/grunge/"]
["Hamptons","https://www.apegrupo.com/en/products/hamptons/"]
["Hefesto","https://www.apegrupo.com/en/products/hefesto/"]
["Lautia","https://www.apegrupo.com/en/products/lautia/"]
["Magnetism","https://www.apegrupo.com/en/products/magnetism/"]
["Manacor","https://www.apegrupo.com/en/products/manacor/"]
["Memories","https://www.apegrupo.com/en/products/memories/"]
["Murus","https://www.apegrupo.com/en/products/murus/"]
["Onyx Slow","https://www.apegrupo.com/en/products/onyx-slow/"]
["Pim Pam Pum","https://www.apegrupo.com/en/products/pim-pam-pum/"]
["Savannah","https://www.apegrupo.com/en/products/savannah/"]
["Seville","https://www.apegrupo.com/en/products/seville/"]
["Switch","https://www.apegrupo.com/en/products/switch/"]
["Toscana","https://www.apegrupo.com/en/products/toscana/"]
["Verona","https://www.apegrupo.com/en/products/verona/"]
["Vintage","https://www.apegrupo.com/en/products/vintage/"]

{"sheet":"Changes","index":4,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,2,1,2]]}
["Date",null,"Description"]
["Announced","Series"]
[]
["New Products"]
["2020-07-01","Altea","Glazed Ceramic Wall"]
["2020-07-01","Calpe","Glazed Ceramic Wall"]
["2020-07-01","Dynamic","Glazed Ceramic Wall"]
["2020-07-01","Grunge","Glazed Ceramic Wall"]
["2020-07-01","Switch","Glazed Ceramic Wall"]
["2020-07-01","Vintage","Glazed Ceramic Wall"]
["2021-08-30","Fado","Glazed Ceramic Wall"]
["2021-08-30","Hamptons","Glazed Ceramic Wall"]
["2021-08-30","Memories","Glazed Ceramic Wall"]
["2021-08-30","Murus","Glazed Ceramic Wall"]
["2023-01-01","Calacatta Slow","Glazed Ceramic Wall & Glazed Porcelain Floor"]
["2023-01-01","Onyx Slow","Glazed Ceramic Wall & Glazed Porcelain Floor"]
["2023-01-01","Savannah","Glazed Ceramic Wall"]
["2023-01-01","Seville","Glazed Ceramic Wall"]
["2023-01-01","Toscana","Glazed Ceramic Wall"]
["2023-01-01","Verona","Glazed Ceramic Wall & Glazed Porcelain Floor"]
["2024-08-01","Acquarella","Glazed Ceramic Wall"]
["2024-08-01","Hefesto","Glazed Ceramic Wall"]
["2024-08-01","Lautia","Glazed Ceramic Wall"]
["2024-08-01","Magnetism","Glazed Ceramic Wall & Glazed Porcelain Floor"]
["2024-08-01","Manacor","Glazed Ceramic Wall"]
["2024-08-01","Pim Pam Pum","Glazed Ceramic Wall"]
[]
["Discontinued Products"]
["2023-04-06","Vintage","6\" x 6\" Field Tile format only in all colors."]
["2024-04-30","Verona","8\" x 8\" Octagon Field Tile format in color Grey only."]
["2024-04-30","Vintage","4\" x 8\" Elongated Hex (Hextra) Field Tile format in colors Grey and Lake only."]
["2024-11-26","Toscana","5\" x 6\" Hex Field Tile format only in all colors due to production issues.  "]
["2025-02-12","Vintage","Colors Black and Grey only in all formats.  4\" x 8\" Elongated Hex (Hextra) Field Tile format in color Natural only."]
["2025-03-03","Altea","Color Grey only in all formats."]
["2025-03-03","Calpe","Color Grey only in all formats."]
["2025-03-03","Switch","4\" Hexagon Field only in all colors."]
["2025-03-14","Hamptons","4\" x 5\" Kirk Triangle Field in all colors.  Colors Acqua and Smoke only in all formats."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Changes"]
["2023-03-28","Toscana","It has been learned that the tile in this series is a Glazed Porcelain.  The only place Ape does not recommend its installation is in very high traffic areas like malls etc.."]
["2023-05-19","Altea","The 3\" x 12\" Field Tile packaging is changing from 5.38 SF/CTN to 10.76 SF/CTN as inventory with old packaging is depleted."]
["2023-05-19","Murus","The 3\" x 11\" Field Tile packaging is changing from 10.55 SF/CTN to 6.35 SF/CTN as inventory with old packaging is depleted."]