{"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":19,"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":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[6,2,6,7],[35,3,35,4]]}
["Manufacturer","Panaria"]
["Product Code","G","File as:","P"]
["CCTD Effective Date","4/1/24 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B2","v":"G"}]
[]
[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,"Italy",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":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[4,0,4,10],[49,0,49,10],[51,0,51,10]]}
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!D2&\"' - \"&Instructions!B1","v":"File 'P' - Panaria"}]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[{"$f":"\"Price List Index - \"&Instructions!B3","v":"Price List Index - 4/1/24 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[1,null,"Connect",null,"Glazed Porcelain Floor & Wall"]
[1,null,"Craft",null,"Glazed Porcelain Floor & Wall"]
[1,null,"Flow",null,"Glazed Porcelain Floor & Wall"]
[1,null,"Home",null,"Glazed Porcelain Floor & Wall"]
[1,null,"Life",null,"Glazed Porcelain Floor & Wall"]
[1,null,"Metropolitan",null,"Glazed Porcelain Floor & Wall"]
[2,null,"Playlist",null,"Glazed Porcelain Floor & Wall"]
[2,null,"Prestige",null,"Glazed Porcelain Floor & Wall"]
[2,null,"Suite",null,"Glazed Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "]
[2,null,"True",null,"Glazed Porcelain Floor & Wall"]
[2,null,"Wood Trend",null,"Glazed Porcelain Floor"]
[2,null,"Wood You",null,"Glazed Porcelain Floor & Wall"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
["This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
["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":200,"n_cols":40,"rows_kept":200,"cut":false,"hidden":false,"merged":[[189,3,189,4],[18,2,18,19],[17,14,17,15],[12,14,12,19],[14,13,15,19],[10,14,10,15],[186,2,186,19],[9,25,9,32],[12,22,12,23],[9,22,9,23],[9,14,9,19],[184,2,184,19],[13,30,13,32]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA1*(1-W1),2)","v":0.05},null,"new",0.05,{"$f":"+W1","v":0},0.05,{"$f":"(AG1-AC1)/AG1","v":0},null,1,{"$f":"SUM(AI1:AK1)+AE1","v":0.05},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(AI1,1)-AI1,2),Round,2,FALSE)+VLOOKUP(AF1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",0,ROUND(AI1-0.04999,1)-AI1+AL1)","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,0.05,"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},0.05,null,"new",0.05,0,0.05,0,null,2,0.05,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,0.05,"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},0.05,null,"new",0.05,0,0.05,0,null,3,0.05,null,0.05,0,0,"",null,"X"]
[null,"Italy",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,"SF/CTN",null,null,0.05,"SF","G",null,{"$f":"+Instructions!$C$21","v":0},0.05,null,"new",0.05,0,0.05,0,null,4,0.05,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,0,"EA","xx",null,{"$f":"+Instructions!$C$21","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,5,0,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA","xx",null,{"$f":"+Instructions!$C$21","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,6,0,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","G",null,{"$f":"+Instructions!$C$21","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,7,0,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,"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,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,"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,"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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!D2&\"' - \"&Instructions!B1","v":"File 'P' - Panaria"},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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Instructions!B3","v":"4/1/24 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-07-08"},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!C7=\"\",\"\",+Instructions!C7)","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,"X"]
[null,null,{"$f":"\"Product Code '\"&Instructions!B2&\"'\"","v":"Product Code 'G'"},null,null,null,null,null,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$7=\"\",\"\",Instructions!$C$7)","v":""},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,"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"},{"$f":"+AC$11","v":"Act. Cost"},{"$f":"+AD$11","v":"GP%"},{"$f":"+AE$11","v":"Adj."},{"$f":"+AF$11","v":"Group"},{"$f":"+AG$11","v":"Price"},null,{"$f":"+AI$11","v":"Calc Price"},{"$f":"+AJ$11","v":".05 Round"},{"$f":"+AK$11","v":"Cents"},{"$f":"+AL$11","v":"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,"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,"CONNECT - Glazed Porcelain Floor & Wall (High Definition Porcelain w/ Microban)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNCO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Akashi          Brooklyn          Forth          Harbour          Sospiri",null,null,null,null,null,null,null," ",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 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA25,AG25)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA25*(1-W25),2)","v":8.8000000000000007},null,"",8.8000000000000007,{"$f":"+W25","v":0},{"$f":"+X25","v":8.8000000000000007},{"$f":"(AG25-AC25)/AG25","v":0},null,1,{"$f":"SUM(AI25:AK25)+AE25","v":8.8000000000000007},null,{"$f":"ROUND(AC25/(1-VLOOKUP(AF25,Group,2,FALSE)),2)","v":8.8000000000000007},{"$f":"IF(VLOOKUP(AF25,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI25,1)-AI25,2),Round,2,FALSE)+VLOOKUP(AF25,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF25,Group,7,FALSE)=\"\",0,ROUND(AI25-0.04999,1)-AI25+AL25)","v":0},{"$f":"IF(VLOOKUP(AF25,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF25,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.82 SF/CTN","Stock",null,5.8,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},5.8,null,"",5.8,0,5.8,0,null,1,5.8,null,5.8,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.82 SF/CTN",null,null,6.2,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.2,null,"",6.2,0,6.2,0,null,1,6.2,null,6.2,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,".97 SF/SHEET","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA29,AG29)","v":24.75},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA29*(1-W29),2)","v":24.75},null,"",24.75,{"$f":"+W29","v":0},{"$f":"+X29","v":24.75},{"$f":"(AG29-AC29)/AG29","v":0},null,3,{"$f":"SUM(AI29:AK29)+AE29","v":24.75},null,{"$f":"ROUND(AC29/(1-VLOOKUP(AF29,Group,2,FALSE)),2)","v":24.75},{"$f":"IF(VLOOKUP(AF29,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI29,1)-AI29,2),Round,2,FALSE)+VLOOKUP(AF29,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF29,Group,7,FALSE)=\"\",0,ROUND(AI29-0.04999,1)-AI29+AL29)","v":0},{"$f":"IF(VLOOKUP(AF29,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF29,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 28\"",null,"Mosaic",null,"Muretto",null,null,null,"1.94 sf/sheet",null,null,"7.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA30,AG30)","v":28.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},28.15,null,"",28.15,0,28.15,0,null,3,28.15,null,28.15,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"4\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA32,AG32)","v":14.35},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA32*(1-W32),2)","v":14.35},null,"",14.35,{"$f":"+W32","v":0},{"$f":"+X32","v":14.35},{"$f":"(AG32-AC32)/AG32","v":0},null,2,{"$f":"SUM(AI32:AK32)+AE32","v":14.35},null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":14.35},{"$f":"IF(VLOOKUP(AF32,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI32,1)-AI32,2),Round,2,FALSE)+VLOOKUP(AF32,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",0,ROUND(AI32-0.04999,1)-AI32+AL32)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF32,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"CRAFT - Glazed Porcelain Floor & Wall (High Definition Porcelain w/ Microban)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNCR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Cotton          Quilt          Rope          Wool          Yarn",null,null,null,null,null,null," "," ",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 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"11.95 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA38,AG38)","v":10.25},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA38*(1-W38),2)","v":10.25},null,"",10.25,{"$f":"+W38","v":0},{"$f":"+X38","v":10.25},{"$f":"(AG38-AC38)/AG38","v":0},null,1,{"$f":"SUM(AI38:AK38)+AE38","v":10.25},null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":10.25},{"$f":"IF(VLOOKUP(AF38,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI38,1)-AI38,2),Round,2,FALSE)+VLOOKUP(AF38,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,7,FALSE)=\"\",0,ROUND(AI38-0.04999,1)-AI38+AL38)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF38,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,null,5.95,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},5.95,null,"",5.95,0,5.95,0,null,1,5.95,null,5.95,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,null,6.55,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.55,null,"",6.55,0,6.55,0,null,1,6.55,null,6.55,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Basketweave",null,null,null,".97 sf/sheet",null,null,"4.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA42,AG42)","v":26.65},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA42*(1-W42),2)","v":26.65},null,"",26.65,{"$f":"+W42","v":0},{"$f":"+X42","v":26.65},{"$f":"(AG42-AC42)/AG42","v":0},null,3,{"$f":"SUM(AI42:AK42)+AE42","v":26.65},null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":26.65},{"$f":"IF(VLOOKUP(AF42,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI42,1)-AI42,2),Round,2,FALSE)+VLOOKUP(AF42,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF42,Group,7,FALSE)=\"\",0,ROUND(AI42-0.04999,1)-AI42+AL42)","v":0},{"$f":"IF(VLOOKUP(AF42,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF42,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"10\" x 24\"",null,"Herringbone Modules A-B",null,null,null,null,null,".92 sf/sheet",null,null,"5.52 SF/CTN",null,null,27.7,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},27.7,null,"",27.7,0,27.7,0,null,3,27.7,null,27.7,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"3-1/8\" x 12\"",null,"Bullnose",null,null,null,null,null,null,null,null,"20 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA45,AG45)","v":7.85},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA45*(1-W45),2)","v":7.85},null,"",7.85,{"$f":"+W45","v":0},{"$f":"+X45","v":7.85},{"$f":"(AG45-AC45)/AG45","v":0},null,2,{"$f":"SUM(AI45:AK45)+AE45","v":7.85},null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":7.85},{"$f":"IF(VLOOKUP(AF45,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI45,1)-AI45,2),Round,2,FALSE)+VLOOKUP(AF45,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF45,Group,7,FALSE)=\"\",0,ROUND(AI45-0.04999,1)-AI45+AL45)","v":0},{"$f":"IF(VLOOKUP(AF45,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF45,Group,7,FALSE))","v":""},null,"X"]
[]
["r",null,"FLOW - Glazed Porcelain Floor & Wall (High Definition Porcelain w/ Microban)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNFL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Desert          Grey          Ice          Ivory          Natural",null,null,null,null,null,null," "," ",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 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.82 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA51,AG51)","v":5.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA51*(1-W51),2)","v":5.35},null,"",5.35,{"$f":"+W51","v":0},{"$f":"+X51","v":5.35},{"$f":"(AG51-AC51)/AG51","v":0},null,1,{"$f":"SUM(AI51:AK51)+AE51","v":5.35},null,{"$f":"ROUND(AC51/(1-VLOOKUP(AF51,Group,2,FALSE)),2)","v":5.35},{"$f":"IF(VLOOKUP(AF51,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI51,1)-AI51,2),Round,2,FALSE)+VLOOKUP(AF51,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF51,Group,7,FALSE)=\"\",0,ROUND(AI51-0.04999,1)-AI51+AL51)","v":0},{"$f":"IF(VLOOKUP(AF51,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF51,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2.5\" x 2.5\"",null,null,null,".97 sf/sheet",null,null,"3.88 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA53,AG53)","v":22.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA53*(1-W53),2)","v":22.15},null,"",22.15,{"$f":"+W53","v":0},{"$f":"+X53","v":22.15},{"$f":"(AG53-AC53)/AG53","v":0},null,3,{"$f":"SUM(AI53:AK53)+AE53","v":22.15},null,{"$f":"ROUND(AC53/(1-VLOOKUP(AF53,Group,2,FALSE)),2)","v":22.15},{"$f":"IF(VLOOKUP(AF53,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI53,1)-AI53,2),Round,2,FALSE)+VLOOKUP(AF53,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",0,ROUND(AI53-0.04999,1)-AI53+AL53)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF53,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 28\"",null,"Mosaic",null,"Muretto",null,null,null,"1.94 sf/sheet",null,null,"7.76 SF/CTN",null,null,28.15,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},28.15,null,"",28.15,0,28.15,0,null,3,28.15,null,28.15,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"4\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,"16 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA56,AG56)","v":13.5},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA56*(1-W56),2)","v":13.5},null,"",13.5,{"$f":"+W56","v":0},{"$f":"+X56","v":13.5},{"$f":"(AG56-AC56)/AG56","v":0},null,2,{"$f":"SUM(AI56:AK56)+AE56","v":13.5},null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF56,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI56,1)-AI56,2),Round,2,FALSE)+VLOOKUP(AF56,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",0,ROUND(AI56-0.04999,1)-AI56+AL56)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF56,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"HOME - Glazed Porcelain Floor & Wall (High Definition Porcelain w/ Microban)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNHO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Greige Range          Grey Range          White Range",null,null,null,null,null,null," "," ",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 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA62,AG62)","v":5.8},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA62*(1-W62),2)","v":5.8},null,"",5.8,{"$f":"+W62","v":0},{"$f":"+X62","v":5.8},{"$f":"(AG62-AC62)/AG62","v":0},null,1,{"$f":"SUM(AI62:AK62)+AE62","v":5.8},null,{"$f":"ROUND(AC62/(1-VLOOKUP(AF62,Group,2,FALSE)),2)","v":5.8},{"$f":"IF(VLOOKUP(AF62,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI62,1)-AI62,2),Round,2,FALSE)+VLOOKUP(AF62,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF62,Group,7,FALSE)=\"\",0,ROUND(AI62-0.04999,1)-AI62+AL62)","v":0},{"$f":"IF(VLOOKUP(AF62,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF62,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,null,6.55,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.55,null,"",6.55,0,6.55,0,null,1,6.55,null,6.55,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,null,7.25,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},7.25,null,"",7.25,0,7.25,0,null,1,7.25,null,7.25,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 24\"",null,"Field - Rectified - Deco Accessory",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":6.7},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA66*(1-W66),2)","v":6.7},null,"",6.7,{"$f":"+W66","v":0},{"$f":"+X66","v":6.7},{"$f":"(AG66-AC66)/AG66","v":0},null,3,{"$f":"SUM(AI66:AK66)+AE66","v":6.7},null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":6.7},{"$f":"IF(VLOOKUP(AF66,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI66,1)-AI66,2),Round,2,FALSE)+VLOOKUP(AF66,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",0,ROUND(AI66-0.04999,1)-AI66+AL66)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF66,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"24\" x 24\"",null,"Field - Rectified - Deco Accessory",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,"b",7.55,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},7.55,null,"",7.55,0,7.55,0,null,3,7.55,null,7.55,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2.5\" x 2.5\"",null,null,null,".97 sf/sheet",null,null,"3.88 SF/CTN",null,null,22.1,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA69*(1-W69),2)","v":22.1},null,"",22.1,{"$f":"+W69","v":0},{"$f":"+X69","v":22.1},{"$f":"(AG69-AC69)/AG69","v":0},null,3,{"$f":"SUM(AI69:AK69)+AE69","v":22.1},null,22.1,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 28\"",null,"Mosaic",null,"Muretto A+B Mix",null,null,null,"1.94 sf/sheet",null,null,"7.76 SF/CTN",null,null,28.3,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},28.3,null,"",28.3,0,28.3,0,null,3,28.3,null,28.3,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"3-3/4\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,"16 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA72,AG72)","v":13.45},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA72*(1-W72),2)","v":13.45},null,"",13.45,{"$f":"+W72","v":0},{"$f":"+X72","v":13.45},{"$f":"(AG72-AC72)/AG72","v":0},null,2,{"$f":"SUM(AI72:AK72)+AE72","v":13.45},null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":13.45},{"$f":"IF(VLOOKUP(AF72,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI72,1)-AI72,2),Round,2,FALSE)+VLOOKUP(AF72,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",0,ROUND(AI72-0.04999,1)-AI72+AL72)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF72,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile",null,"Outdoor:","24\" x 24\" x 2cm",null,"Field - Paver",null,null,null,null,null,null,null,null,"8.03 SF/CTN",null,null,11.2,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA74*(1-W74),2)","v":11.2},null,"",11.2,{"$f":"+W74","v":0},{"$f":"+X74","v":11.2},{"$f":"(AG74-AC74)/AG74","v":0},null,1,{"$f":"SUM(AI74:AK74)+AE74","v":11.2},null,{"$f":"ROUND(AC74/(1-VLOOKUP(AF74,Group,2,FALSE)),2)","v":11.2},{"$f":"IF(VLOOKUP(AF74,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI74,1)-AI74,2),Round,2,FALSE)+VLOOKUP(AF74,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",0,ROUND(AI74-0.04999,1)-AI74+AL74)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF74,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null," ","Notes:","a) Packaging is changing from 15.61 SF/CTN to 13.67 SF/CTN as inventory with old packaging is depleted.",null,null,null,null,null,null,null,null,null,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,"b) There are 6 different decorative designs and they are randomly packaged in each carton.",null,null,null,null,null,null,null,null,null,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,"LIFE - Glazed Porcelain Floor & Wall (High Definition Porcelain)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNLI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Bourbon          Hay          Polar          Smoke          Smooth",null,null,null,null,null,null," "," ",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 36\"",null,"Field",null,null,null,null,null,null,null,null,"13.94 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA83,AG83)","v":6.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA83*(1-W83),2)","v":6.15},null,"",6.15,{"$f":"+W83","v":0},{"$f":"+X83","v":6.15},{"$f":"(AG83-AC83)/AG83","v":0},null,1,{"$f":"SUM(AI83:AK83)+AE83","v":6.15},null,{"$f":"ROUND(AC83/(1-VLOOKUP(AF83,Group,2,FALSE)),2)","v":6.15},{"$f":"IF(VLOOKUP(AF83,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI83,1)-AI83,2),Round,2,FALSE)+VLOOKUP(AF83,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF83,Group,7,FALSE)=\"\",0,ROUND(AI83-0.04999,1)-AI83+AL83)","v":0},{"$f":"IF(VLOOKUP(AF83,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF83,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"10\" x 24\"",null,"Herringbone Modules A-B",null,null,null,null,null,".92 sf/sheet",null,null,"5.52 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA85,AG85)","v":26.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA85*(1-W85),2)","v":26.35},null,"",26.35,{"$f":"+W85","v":0},{"$f":"+X85","v":26.35},{"$f":"(AG85-AC85)/AG85","v":0},null,3,{"$f":"SUM(AI85:AK85)+AE85","v":26.35},null,{"$f":"ROUND(AC85/(1-VLOOKUP(AF85,Group,2,FALSE)),2)","v":26.35},{"$f":"IF(VLOOKUP(AF85,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI85,1)-AI85,2),Round,2,FALSE)+VLOOKUP(AF85,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",0,ROUND(AI85-0.04999,1)-AI85+AL85)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF85,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"METROPOLITAN - Glazed Porcelain Floor & Wall (High Definition Porcelain w/ Microban)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Fair          Infused          Solid          Stained",null,null,null,null,null,null," "," ",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 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.82 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA91,AG91)","v":5.45},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA91*(1-W91),2)","v":5.45},null,"",5.45,{"$f":"+W91","v":0},{"$f":"+X91","v":5.45},{"$f":"(AG91-AC91)/AG91","v":0},null,1,{"$f":"SUM(AI91:AK91)+AE91","v":5.45},null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":5.45},{"$f":"IF(VLOOKUP(AF91,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI91,1)-AI91,2),Round,2,FALSE)+VLOOKUP(AF91,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",0,ROUND(AI91-0.04999,1)-AI91+AL91)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF91,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.82 SF/CTN",null,null,5.95,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},5.95,null,"",5.95,0,5.95,0,null,1,5.95,null,5.95,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,null,6.5,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.5,null,"",6.5,0,6.5,0,null,1,6.5,null,6.5,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"3\" x 3\"",null,null,null,".96 sf/sheet",null,null,"3.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA95,AG95)","v":24.8},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA95*(1-W95),2)","v":24.8},null,"",24.8,{"$f":"+W95","v":0},{"$f":"+X95","v":24.8},{"$f":"(AG95-AC95)/AG95","v":0},null,3,{"$f":"SUM(AI95:AK95)+AE95","v":24.8},null,{"$f":"ROUND(AC95/(1-VLOOKUP(AF95,Group,2,FALSE)),2)","v":24.8},{"$f":"IF(VLOOKUP(AF95,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI95,1)-AI95,2),Round,2,FALSE)+VLOOKUP(AF95,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",0,ROUND(AI95-0.04999,1)-AI95+AL95)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF95,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3-1/8\" x 12\"",null,"Bullnose",null,null,null,null,null,null,null,null,"20 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA97,AG97)","v":7.15},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA97*(1-W97),2)","v":7.15},null,"",7.15,{"$f":"+W97","v":0},{"$f":"+X97","v":7.15},{"$f":"(AG97-AC97)/AG97","v":0},null,2,{"$f":"SUM(AI97:AK97)+AE97","v":7.15},null,{"$f":"ROUND(AC97/(1-VLOOKUP(AF97,Group,2,FALSE)),2)","v":7.15},{"$f":"IF(VLOOKUP(AF97,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI97,1)-AI97,2),Round,2,FALSE)+VLOOKUP(AF97,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",0,ROUND(AI97-0.04999,1)-AI97+AL97)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF97,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"      Mixed Colors: Dark Stripes (Suitable for Solid & Infused colors)          Light Stripes (Suitable for Fair & Stained colors)",null,null,null,null,null,null,null,null,null,null,null,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 24\"",null,"Field - Stripes",null,null,null,null,null,null,null,null,"15.82 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA101,AG101)","v":7.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA101*(1-W101),2)","v":7.15},null,"",7.15,{"$f":"+W101","v":0},{"$f":"+X101","v":7.15},{"$f":"(AG101-AC101)/AG101","v":0},null,1,{"$f":"SUM(AI101:AK101)+AE101","v":7.15},null,{"$f":"ROUND(AC101/(1-VLOOKUP(AF101,Group,2,FALSE)),2)","v":7.15},{"$f":"IF(VLOOKUP(AF101,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI101,1)-AI101,2),Round,2,FALSE)+VLOOKUP(AF101,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",0,ROUND(AI101-0.04999,1)-AI101+AL101)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF101,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"PLAYLIST - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNPL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Acoustic Amber",null,"         Gothic Grey",null,null,"         New-Age Terracotta",null,null,null,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,"Ambient White",null,"         Grunge Greige",null,null,"         Rhythm and Blues",null,null,null,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,"Classical Beige",null,"         Indie Rust",null,null,"         Ska 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,"X"]
[null,null,null,null,"Folk Green",null,"         Lounge Light Green",null,null,"         Synth 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,"X"]
[]
[null,"Field Tile",null,"Soft:","8\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"6.89 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA110,AG110)","v":9.5500000000000007},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA110*(1-W110),2)","v":9.5500000000000007},null,"new",9.5500000000000007,{"$f":"+W110","v":0},{"$f":"+X110","v":9.5500000000000007},{"$f":"(AG110-AC110)/AG110","v":0},null,1,{"$f":"SUM(AI110:AK110)+AE110","v":9.5500000000000007},null,{"$f":"ROUND(AC110/(1-VLOOKUP(AF110,Group,2,FALSE)),2)","v":9.5500000000000007},{"$f":"IF(VLOOKUP(AF110,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI110,1)-AI110,2),Round,2,FALSE)+VLOOKUP(AF110,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",0,ROUND(AI110-0.04999,1)-AI110+AL110)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF110,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"3\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"5.06 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA111,AG111)","v":9.3000000000000007},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA111*(1-W111),2)","v":9.3000000000000007},null,"new",9.3000000000000007,{"$f":"+W111","v":0},{"$f":"+X111","v":9.3000000000000007},{"$f":"(AG111-AC111)/AG111","v":0},null,1,{"$f":"SUM(AI111:AK111)+AE111","v":9.3000000000000007},null,{"$f":"ROUND(AC111/(1-VLOOKUP(AF111,Group,2,FALSE)),2)","v":9.3000000000000007},{"$f":"IF(VLOOKUP(AF111,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI111,1)-AI111,2),Round,2,FALSE)+VLOOKUP(AF111,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",0,ROUND(AI111-0.04999,1)-AI111+AL111)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF111,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Color Mix          Neutral Mix",null,null,null,null,null,null,null,null,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,"Soft:","8\" x 8\"",null,"Field - Accessory",null,null,null,null,null,null,null,null,"6.89 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA115,AG115)","v":9.85},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA115*(1-W115),2)","v":9.85},null,"new",9.85,{"$f":"+W115","v":0},{"$f":"+X115","v":9.85},{"$f":"(AG115-AC115)/AG115","v":0},null,3,{"$f":"SUM(AI115:AK115)+AE115","v":9.85},null,{"$f":"ROUND(AC115/(1-VLOOKUP(AF115,Group,2,FALSE)),2)","v":9.85},{"$f":"IF(VLOOKUP(AF115,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI115,1)-AI115,2),Round,2,FALSE)+VLOOKUP(AF115,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,7,FALSE)=\"\",0,ROUND(AI115-0.04999,1)-AI115+AL115)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF115,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null," ","Note:","a) Each carton contains a random mix of decorative patterns. ",null,null,null,null,null,null,null,null,null,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,"PRESTIGE - Glazed Porcelain Floor & Wall (w/ Microban)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNPR",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 Gold          Imperiale Grey          Onice Cream          Travertino 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,"X"]
[]
[null,"Field Tile",null,"Soft:","12\" x 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"15.61 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA123,AG123)","v":5.9},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA123*(1-W123),2)","v":5.9},null,"",5.9,{"$f":"+W123","v":0},{"$f":"+X123","v":5.9},{"$f":"(AG123-AC123)/AG123","v":0},null,1,{"$f":"SUM(AI123:AK123)+AE123","v":5.9},null,{"$f":"ROUND(AC123/(1-VLOOKUP(AF123,Group,2,FALSE)),2)","v":5.9},{"$f":"IF(VLOOKUP(AF123,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI123,1)-AI123,2),Round,2,FALSE)+VLOOKUP(AF123,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",0,ROUND(AI123-0.04999,1)-AI123+AL123)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF123,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,6.7,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.7,null,"",6.7,0,6.7,0,null,1,6.7,null,6.7,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,".97 SF/SHEET","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA126,AG126)","v":21.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA126*(1-W126),2)","v":21.35},null,"",21.35,{"$f":"+W126","v":0},{"$f":"+X126","v":21.35},{"$f":"(AG126-AC126)/AG126","v":0},null,3,{"$f":"SUM(AI126:AK126)+AE126","v":21.35},null,{"$f":"ROUND(AC126/(1-VLOOKUP(AF126,Group,2,FALSE)),2)","v":21.35},{"$f":"IF(VLOOKUP(AF126,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI126,1)-AI126,2),Round,2,FALSE)+VLOOKUP(AF126,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",0,ROUND(AI126-0.04999,1)-AI126+AL126)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF126,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"4\" x 24\"",null,"Field",null,"Chevron",null,null,null,".55 sf/piece",null,null,"4.40 SF/CTN",null,null,18.3,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},18.3,null,"",18.3,0,18.3,0,null,3,18.3,null,18.3,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"3-3/4\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA129,AG129)","v":12.95},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA129*(1-W129),2)","v":12.95},null,"",12.95,{"$f":"+W129","v":0},{"$f":"+X129","v":12.95},{"$f":"(AG129-AC129)/AG129","v":0},null,2,{"$f":"SUM(AI129:AK129)+AE129","v":12.95},null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF129,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI129,1)-AI129,2),Round,2,FALSE)+VLOOKUP(AF129,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",0,ROUND(AI129-0.04999,1)-AI129+AL129)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF129,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Italy",null,"Lux:","12\" x 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"17.44 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA131,AG131)","v":10.9},"SF","G",null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA131*(1-W131),2)","v":10.9},null,"",10.9,{"$f":"+W131","v":0},{"$f":"+X131","v":10.9},{"$f":"(AG131-AC131)/AG131","v":0},null,4,{"$f":"SUM(AI131:AK131)+AE131","v":10.9},null,{"$f":"ROUND(AC131/(1-VLOOKUP(AF131,Group,2,FALSE)),2)","v":10.9},{"$f":"IF(VLOOKUP(AF131,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI131,1)-AI131,2),Round,2,FALSE)+VLOOKUP(AF131,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,7,FALSE)=\"\",0,ROUND(AI131-0.04999,1)-AI131+AL131)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF131,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,14.25,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},14.25,null,"",14.25,0,14.25,0,null,1,14.25,null,14.25,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,".97 sf/sheet",null,null,"3.88 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA134,AG134)","v":24.45},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA134*(1-W134),2)","v":24.45},null,"",24.45,{"$f":"+W134","v":0},{"$f":"+X134","v":24.45},{"$f":"(AG134-AC134)/AG134","v":0},null,3,{"$f":"SUM(AI134:AK134)+AE134","v":24.45},null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":24.45},{"$f":"IF(VLOOKUP(AF134,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI134,1)-AI134,2),Round,2,FALSE)+VLOOKUP(AF134,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",0,ROUND(AI134-0.04999,1)-AI134+AL134)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF134,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3-3/4\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA136,AG136)","v":14.8},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA136*(1-W136),2)","v":14.8},null,"",14.8,{"$f":"+W136","v":0},{"$f":"+X136","v":14.8},{"$f":"(AG136-AC136)/AG136","v":0},null,2,{"$f":"SUM(AI136:AK136)+AE136","v":14.8},null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":14.8},{"$f":"IF(VLOOKUP(AF136,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI136,1)-AI136,2),Round,2,FALSE)+VLOOKUP(AF136,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",0,ROUND(AI136-0.04999,1)-AI136+AL136)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF136,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null," ","Note:","a) Each carton contains 4 right arrows and 4 left arrows.",null,null,null,null,null,null,null,null,null,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,"SUITE - Glazed Porcelain Floor & Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNSU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Arabesque          Ice White          Statue",null,null,null,null,null,null," "," ",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 - Rectified",null,null,null,null,null,null,null,null,"6.67 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA144,AG144)","v":8.4499999999999993},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA144*(1-W144),2)","v":8.4499999999999993},null,"",8.4499999999999993,{"$f":"+W144","v":0},{"$f":"+X144","v":8.4499999999999993},{"$f":"(AG144-AC144)/AG144","v":0},null,1,{"$f":"SUM(AI144:AK144)+AE144","v":8.4499999999999993},null,{"$f":"ROUND(AC144/(1-VLOOKUP(AF144,Group,2,FALSE)),2)","v":8.4499999999999993},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI144,1)-AI144,2),Round,2,FALSE)+VLOOKUP(AF144,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",0,ROUND(AI144-0.04999,1)-AI144+AL144)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF144,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.82 SF/CTN",null,null,5.95,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},5.95,null,"",5.95,0,5.95,0,null,1,5.95,null,5.95,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.82 SF/CTN",null,null,6.05,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.05,null,"",6.05,0,6.05,0,null,1,6.05,null,6.05,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"3\" x 3\"",null,null,null,".97 sf/sheet",null,null,"3.88 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA148,AG148)","v":23.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA148*(1-W148),2)","v":23.15},null,"",23.15,{"$f":"+W148","v":0},{"$f":"+X148","v":23.15},{"$f":"(AG148-AC148)/AG148","v":0},null,3,{"$f":"SUM(AI148:AK148)+AE148","v":23.15},null,{"$f":"ROUND(AC148/(1-VLOOKUP(AF148,Group,2,FALSE)),2)","v":23.15},{"$f":"IF(VLOOKUP(AF148,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI148,1)-AI148,2),Round,2,FALSE)+VLOOKUP(AF148,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",0,ROUND(AI148-0.04999,1)-AI148+AL148)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF148,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3-1/8\" x 12\"",null,"Bullnose",null,null,null,null,null,null,null,null,"20 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA150,AG150)","v":6.55},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA150*(1-W150),2)","v":6.55},null,"",6.55,{"$f":"+W150","v":0},{"$f":"+X150","v":6.55},{"$f":"(AG150-AC150)/AG150","v":0},null,2,{"$f":"SUM(AI150:AK150)+AE150","v":6.55},null,{"$f":"ROUND(AC150/(1-VLOOKUP(AF150,Group,2,FALSE)),2)","v":6.55},{"$f":"IF(VLOOKUP(AF150,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI150,1)-AI150,2),Round,2,FALSE)+VLOOKUP(AF150,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF150,Group,7,FALSE)=\"\",0,ROUND(AI150-0.04999,1)-AI150+AL150)","v":0},{"$f":"IF(VLOOKUP(AF150,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF150,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null," ","Note:","a) This item is changing from a pressed to a rectified edge.  Packaging for the rectified version",null,null,null,null,null,null,null,null,null,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,"will be 6.12 SF/CTN as inventory with the pressed format is depleted.",null,null,null,null,null,null,null,null,null,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,"TRUE - Glazed Porcelain Floor & Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNTR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Light Beige          Mild Grey          Soft Black          Warm 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,"X"]
[]
[null,"Field Tile",null,null,"12\" x 24\" x 9mm",null,"Field",null,null,null,null,null,null,null,null,"15.82 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA159,AG159)","v":5.45},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA159*(1-W159),2)","v":5.45},null,"",5.45,{"$f":"+W159","v":0},{"$f":"+X159","v":5.45},{"$f":"(AG159-AC159)/AG159","v":0},null,1,{"$f":"SUM(AI159:AK159)+AE159","v":5.45},null,{"$f":"ROUND(AC159/(1-VLOOKUP(AF159,Group,2,FALSE)),2)","v":5.45},{"$f":"IF(VLOOKUP(AF159,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI159,1)-AI159,2),Round,2,FALSE)+VLOOKUP(AF159,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",0,ROUND(AI159-0.04999,1)-AI159+AL159)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF159,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\" x 9mm",null,"Mosaic",null,"2.5\" x 2.5\"",null,null,null,".97 sf/sheet",null,null,"3.88 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA161,AG161)","v":22.95},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA161*(1-W161),2)","v":22.95},null,"",22.95,{"$f":"+W161","v":0},{"$f":"+X161","v":22.95},{"$f":"(AG161-AC161)/AG161","v":0},null,3,{"$f":"SUM(AI161:AK161)+AE161","v":22.95},null,{"$f":"ROUND(AC161/(1-VLOOKUP(AF161,Group,2,FALSE)),2)","v":22.95},{"$f":"IF(VLOOKUP(AF161,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI161,1)-AI161,2),Round,2,FALSE)+VLOOKUP(AF161,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",0,ROUND(AI161-0.04999,1)-AI161+AL161)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF161,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3-1/8\" x 12\" x 9mm",null,"Bullnose",null,null,null,null,null,null,null,null,"20 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA163,AG163)","v":6.5},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA163*(1-W163),2)","v":6.5},null,"",6.5,{"$f":"+W163","v":0},{"$f":"+X163","v":6.5},{"$f":"(AG163-AC163)/AG163","v":0},null,2,{"$f":"SUM(AI163:AK163)+AE163","v":6.5},null,{"$f":"ROUND(AC163/(1-VLOOKUP(AF163,Group,2,FALSE)),2)","v":6.5},{"$f":"IF(VLOOKUP(AF163,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI163,1)-AI163,2),Round,2,FALSE)+VLOOKUP(AF163,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF163,Group,7,FALSE)=\"\",0,ROUND(AI163-0.04999,1)-AI163+AL163)","v":0},{"$f":"IF(VLOOKUP(AF163,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF163,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile",null,"Pavers:","24\" x 24\" x 2cm",null,"Field - Anti-Slip Paver",null,null,null,null,null,null,null,null,"8.03 SF/CTN",null,"a",11.2,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA165*(1-W165),2)","v":11.2},null,"",11.2,{"$f":"+W165","v":0},{"$f":"+X165","v":11.2},{"$f":"(AG165-AC165)/AG165","v":0},null,1,{"$f":"SUM(AI165:AK165)+AE165","v":11.2},null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":11.2},{"$f":"IF(VLOOKUP(AF165,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI165,1)-AI165,2),Round,2,FALSE)+VLOOKUP(AF165,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",0,ROUND(AI165-0.04999,1)-AI165+AL165)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF165,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null," ","Note:","a) Not available in the color Soft 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,"X"]
[]
[null,null,"WOOD TREND - Glazed Porcelain Floor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNWO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Birch          Elm          Mahogany          Walnut Multi          White Oak",null,null,null,null,null,null,null,null,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 36\"",null,"Field",null,null,null,null,null,null,null,null,"13.94 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA173,AG173)","v":6.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA173*(1-W173),2)","v":6.15},null,"",6.15,{"$f":"+W173","v":0},{"$f":"+X173","v":6.15},{"$f":"(AG173-AC173)/AG173","v":0},null,1,{"$f":"SUM(AI173:AK173)+AE173","v":6.15},null,{"$f":"ROUND(AC173/(1-VLOOKUP(AF173,Group,2,FALSE)),2)","v":6.15},{"$f":"IF(VLOOKUP(AF173,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI173,1)-AI173,2),Round,2,FALSE)+VLOOKUP(AF173,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF173,Group,7,FALSE)=\"\",0,ROUND(AI173-0.04999,1)-AI173+AL173)","v":0},{"$f":"IF(VLOOKUP(AF173,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF173,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"WOOD YOU - Glazed Porcelain Floor & Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNWY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Bruno          Corda          Dolce          Fumo          Noce          Stucco",null,null,null,null,null,null,null,null,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 36\"",null,"Field",null,null,null,null,null,null,null,null,"13.94 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA179,AG179)","v":6.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA179*(1-W179),2)","v":6.15},null,"",6.15,{"$f":"+W179","v":0},{"$f":"+X179","v":6.15},{"$f":"(AG179-AC179)/AG179","v":0},null,1,{"$f":"SUM(AI179:AK179)+AE179","v":6.15},null,{"$f":"ROUND(AC179/(1-VLOOKUP(AF179,Group,2,FALSE)),2)","v":6.15},{"$f":"IF(VLOOKUP(AF179,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI179,1)-AI179,2),Round,2,FALSE)+VLOOKUP(AF179,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",0,ROUND(AI179-0.04999,1)-AI179+AL179)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF179,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[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,null,null,null,null,null,null,null,null,null,null,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"]
[]
[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":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[null,null,null," "]
["ConestogaTile's Website","www.conestogatile.com"]
[null,null,null,null,null,null,null,null,null," "]
["Manufacturer's Home Page","https://www.panaria.us/"]
[]
[]
["Product","Direct Website Link"]
["Connect","https://www.panaria.us/collection/connect"]
["Craft","https://www.panaria.us/collection/craft"]
["Flow","https://www.panaria.us/collection/flow"]
["Home","https://www.panaria.us/collection/home"]
["Life","https://www.panaria.us/collection/life"]
["Metropolitan","https://www.panaria.us/collection/metropolitan"]
["Playlist"]
["Prestige","https://www.panaria.us/collection/prestige"]
["Suite","https://www.panaria.us/collection/suite"]
["True","https://www.panaria.us/collection/true"]
["Wood Trend","https://www.panaria.us/collection/wood-trend"]
["Wood You","https://www.panaria.us/collection/wood-you"]

{"sheet":"Changes","index":4,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,2,1,2]]}
["Date",null,"Description"]
["Announced","Series"]
["New Products"]
["2023-01-01","Connect","Glazed Porcelain Floor & Wall"]
["2023-01-01","Craft","Glazed Porcelain Floor & Wall"]
["2023-01-01","Flow","Glazed Porcelain Floor & Wall"]
["2023-01-01","Home","Glazed Porcelain Floor & Wall"]
["2023-01-01","Life","Glazed Porcelain Floor & Wall"]
["2023-01-01","Metropolitan","Glazed Porcelain Floor & Wall"]
["2023-01-01","Prestige","Glazed Porcelain Floor & Wall"]
["2023-01-01","Suite","Glazed Porcelain Floor & Wall"]
["2023-01-01","True","Glazed Porcelain Floor & Wall"]
["2023-01-01","Wood Trend","Glazed Porcelain Floor"]
["2023-01-01","Wood You","Glazed Porcelain Floor & Wall"]
["2024-07-02","Playlist","Glazed Porcelain"]
[]
[" "," "]
[" "," "]
["Discontinued Products"]
["2023-04-28","True","18\" x 36\" x 10mm Pressed and Rectified Field Tile formats only in all colors."]
[]
[" "," "]
[" "," "]
["Changes"]
["2023-01-03","Prestige","Packaging for the 12\" x 24\" Soft finish only Field Tile format has changed to 15.61 SF/CTN."]
[null,null," "]