{"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":14,"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","1/1/23 (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,null,null,null,null,null," "]
[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 - 1/1/23 (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,"Prestige",null,"Glazed Porcelain Floor & Wall"]
[2,null,"Suite",null,"Glazed Porcelain Floor & Wall"]
[2,null,"True",null,"Glazed Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "]
[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":192,"n_cols":40,"rows_kept":192,"cut":false,"hidden":false,"merged":[[10,14,10,15],[178,2,178,19],[9,25,9,32],[12,22,12,23],[9,22,9,23],[9,14,9,19],[176,2,176,19],[13,30,13,32],[181,3,181,4],[18,2,18,19],[17,14,17,15],[12,14,12,19],[14,13,15,19]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"SF",{"$f":"+Instructions!$B$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":"1/1/23 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-04-28"},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"},"Act. Cost","GP%","Adj.",{"$f":"+AF$11","v":"Group"},"Price",null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,"ALL ITEMS MARKED WITH PACKAGING QUANTITY ARE SOLD IN MULTIPLES OF THAT QUANTITY ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"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":9.5},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA25*(1-W25),2)","v":9.5},null,"new",9.5,{"$f":"+W25","v":0},{"$f":"+X25","v":9.5},{"$f":"(AG25-AC25)/AG25","v":0},null,1,{"$f":"SUM(AI25:AK25)+AE25","v":9.5},null,{"$f":"ROUND(AC25/(1-VLOOKUP(AF25,Group,2,FALSE)),2)","v":9.5},{"$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,6.1,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.1,null,"new",6.1,0,6.1,0,null,1,6.1,null,6.1,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,7.05,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},7.05,null,"new",7.05,0,7.05,0,null,1,7.05,null,7.05,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":23.5},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA29*(1-W29),2)","v":23.5},null,"new",23.5,{"$f":"+W29","v":0},{"$f":"+X29","v":23.5},{"$f":"(AG29-AC29)/AG29","v":0},null,3,{"$f":"SUM(AI29:AK29)+AE29","v":23.5},null,{"$f":"ROUND(AC29/(1-VLOOKUP(AF29,Group,2,FALSE)),2)","v":23.5},{"$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":26.95},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},26.95,null,"new",26.95,0,26.95,0,null,3,26.95,null,26.95,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":13.85},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA32*(1-W32),2)","v":13.85},null,"new",13.85,{"$f":"+W32","v":0},{"$f":"+X32","v":13.85},{"$f":"(AG32-AC32)/AG32","v":0},null,2,{"$f":"SUM(AI32:AK32)+AE32","v":13.85},null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":13.85},{"$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.9},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA38*(1-W38),2)","v":10.9},null,"new",10.9,{"$f":"+W38","v":0},{"$f":"+X38","v":10.9},{"$f":"(AG38-AC38)/AG38","v":0},null,1,{"$f":"SUM(AI38:AK38)+AE38","v":10.9},null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":10.9},{"$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,6.9,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.9,null,"new",6.9,0,6.9,0,null,1,6.9,null,6.9,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,7.4,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},7.4,null,"new",7.4,0,7.4,0,null,1,7.4,null,7.4,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":25.3},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA42*(1-W42),2)","v":25.3},null,"new",25.3,{"$f":"+W42","v":0},{"$f":"+X42","v":25.3},{"$f":"(AG42-AC42)/AG42","v":0},null,3,{"$f":"SUM(AI42:AK42)+AE42","v":25.3},null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":25.3},{"$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,26.8,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},26.8,null,"new",26.8,0,26.8,0,null,3,26.8,null,26.8,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.9},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA45*(1-W45),2)","v":7.9},null,"new",7.9,{"$f":"+W45","v":0},{"$f":"+X45","v":7.9},{"$f":"(AG45-AC45)/AG45","v":0},null,2,{"$f":"SUM(AI45:AK45)+AE45","v":7.9},null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":7.9},{"$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":6.3},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA51*(1-W51),2)","v":6.3},null,"new",6.3,{"$f":"+W51","v":0},{"$f":"+X51","v":6.3},{"$f":"(AG51-AC51)/AG51","v":0},null,1,{"$f":"SUM(AI51:AK51)+AE51","v":6.3},null,{"$f":"ROUND(AC51/(1-VLOOKUP(AF51,Group,2,FALSE)),2)","v":6.3},{"$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":21.05},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA53*(1-W53),2)","v":21.05},null,"new",21.05,{"$f":"+W53","v":0},{"$f":"+X53","v":21.05},{"$f":"(AG53-AC53)/AG53","v":0},null,3,{"$f":"SUM(AI53:AK53)+AE53","v":21.05},null,{"$f":"ROUND(AC53/(1-VLOOKUP(AF53,Group,2,FALSE)),2)","v":21.05},{"$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,26.95,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},26.95,null,"new",26.95,0,26.95,0,null,3,26.95,null,26.95,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.05},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA56*(1-W56),2)","v":13.05},null,"new",13.05,{"$f":"+W56","v":0},{"$f":"+X56","v":13.05},{"$f":"(AG56-AC56)/AG56","v":0},null,2,{"$f":"SUM(AI56:AK56)+AE56","v":13.05},null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":13.05},{"$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,null,{"$f":"IF(Suggested=\"Yes\",AA62,AG62)","v":6.9},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA62*(1-W62),2)","v":6.9},null,"new",6.9,{"$f":"+W62","v":0},{"$f":"+X62","v":6.9},{"$f":"(AG62-AC62)/AG62","v":0},null,1,{"$f":"SUM(AI62:AK62)+AE62","v":6.9},null,{"$f":"ROUND(AC62/(1-VLOOKUP(AF62,Group,2,FALSE)),2)","v":6.9},{"$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,7.4,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},7.4,null,"new",7.4,0,7.4,0,null,1,7.4,null,7.4,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,8,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},8,null,"new",8,0,8,0,null,1,8,null,8,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 24\"",null,"Field - Deco Accessory - Rectified",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":7.75},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA66*(1-W66),2)","v":7.75},null,"new",7.75,{"$f":"+W66","v":0},{"$f":"+X66","v":7.75},{"$f":"(AG66-AC66)/AG66","v":0},null,3,{"$f":"SUM(AI66:AK66)+AE66","v":7.75},null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":7.75},{"$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 - Deco Accessory - Rectified",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,null,8.3000000000000007,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},8.3000000000000007,null,"new",8.3000000000000007,0,8.3000000000000007,0,null,3,8.3000000000000007,null,8.3000000000000007,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,21,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA69*(1-W69),2)","v":21},null,"new",21,{"$f":"+W69","v":0},{"$f":"+X69","v":21},{"$f":"(AG69-AC69)/AG69","v":0},null,3,{"$f":"SUM(AI69:AK69)+AE69","v":21},null,21,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 28\"",null,"Mosaic",null,"Muretto A+B",null,null,null,"1.94 sf/sheet",null,null,"7.76 SF/CTN",null,null,26.95,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},26.95,null,"new",26.95,0,26.95,0,null,3,26.95,null,26.95,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.05},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA72*(1-W72),2)","v":13.05},null,"new",13.05,{"$f":"+W72","v":0},{"$f":"+X72","v":13.05},{"$f":"(AG72-AC72)/AG72","v":0},null,2,{"$f":"SUM(AI72:AK72)+AE72","v":13.05},null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":13.05},{"$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,10.199999999999999,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA74*(1-W74),2)","v":10.199999999999999},null,"new",10.199999999999999,{"$f":"+W74","v":0},{"$f":"+X74","v":10.199999999999999},{"$f":"(AG74-AC74)/AG74","v":0},null,1,{"$f":"SUM(AI74:AK74)+AE74","v":10.199999999999999},null,{"$f":"ROUND(AC74/(1-VLOOKUP(AF74,Group,2,FALSE)),2)","v":10.199999999999999},{"$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,"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\",AA80,AG80)","v":7.1},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA80*(1-W80),2)","v":7.1},null,"new",7.1,{"$f":"+W80","v":0},{"$f":"+X80","v":7.1},{"$f":"(AG80-AC80)/AG80","v":0},null,1,{"$f":"SUM(AI80:AK80)+AE80","v":7.1},null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":7.1},{"$f":"IF(VLOOKUP(AF80,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI80,1)-AI80,2),Round,2,FALSE)+VLOOKUP(AF80,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",0,ROUND(AI80-0.04999,1)-AI80+AL80)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF80,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\",AA82,AG82)","v":25.1},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA82*(1-W82),2)","v":25.1},null,"new",25.1,{"$f":"+W82","v":0},{"$f":"+X82","v":25.1},{"$f":"(AG82-AC82)/AG82","v":0},null,3,{"$f":"SUM(AI82:AK82)+AE82","v":25.1},null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":25.1},{"$f":"IF(VLOOKUP(AF82,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI82,1)-AI82,2),Round,2,FALSE)+VLOOKUP(AF82,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",0,ROUND(AI82-0.04999,1)-AI82+AL82)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF82,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\",AA88,AG88)","v":6.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA88*(1-W88),2)","v":6.35},null,"new",6.35,{"$f":"+W88","v":0},{"$f":"+X88","v":6.35},{"$f":"(AG88-AC88)/AG88","v":0},null,1,{"$f":"SUM(AI88:AK88)+AE88","v":6.35},null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":6.35},{"$f":"IF(VLOOKUP(AF88,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI88,1)-AI88,2),Round,2,FALSE)+VLOOKUP(AF88,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",0,ROUND(AI88-0.04999,1)-AI88+AL88)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF88,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,6.8,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.8,null,"new",6.8,0,6.8,0,null,1,6.8,null,6.8,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,7.35,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},7.35,null,"new",7.35,0,7.35,0,null,1,7.35,null,7.35,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\",AA92,AG92)","v":23.5},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA92*(1-W92),2)","v":23.5},null,"new",23.5,{"$f":"+W92","v":0},{"$f":"+X92","v":23.5},{"$f":"(AG92-AC92)/AG92","v":0},null,3,{"$f":"SUM(AI92:AK92)+AE92","v":23.5},null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":23.5},{"$f":"IF(VLOOKUP(AF92,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI92,1)-AI92,2),Round,2,FALSE)+VLOOKUP(AF92,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",0,ROUND(AI92-0.04999,1)-AI92+AL92)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF92,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\",AA94,AG94)","v":7.25},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA94*(1-W94),2)","v":7.25},null,"new",7.25,{"$f":"+W94","v":0},{"$f":"+X94","v":7.25},{"$f":"(AG94-AC94)/AG94","v":0},null,2,{"$f":"SUM(AI94:AK94)+AE94","v":7.25},null,{"$f":"ROUND(AC94/(1-VLOOKUP(AF94,Group,2,FALSE)),2)","v":7.25},{"$f":"IF(VLOOKUP(AF94,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI94,1)-AI94,2),Round,2,FALSE)+VLOOKUP(AF94,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",0,ROUND(AI94-0.04999,1)-AI94+AL94)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF94,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\",AA98,AG98)","v":7},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA98*(1-W98),2)","v":7},null,"new",7,{"$f":"+W98","v":0},{"$f":"+X98","v":7},{"$f":"(AG98-AC98)/AG98","v":0},null,1,{"$f":"SUM(AI98:AK98)+AE98","v":7},null,{"$f":"ROUND(AC98/(1-VLOOKUP(AF98,Group,2,FALSE)),2)","v":7},{"$f":"IF(VLOOKUP(AF98,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI98,1)-AI98,2),Round,2,FALSE)+VLOOKUP(AF98,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",0,ROUND(AI98-0.04999,1)-AI98+AL98)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF98,Group,7,FALSE))","v":""},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\",AA104,AG104)","v":6.4},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA104*(1-W104),2)","v":6.4},null,"new",6.4,{"$f":"+W104","v":0},{"$f":"+X104","v":6.4},{"$f":"(AG104-AC104)/AG104","v":0},null,1,{"$f":"SUM(AI104:AK104)+AE104","v":6.4},null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":6.4},{"$f":"IF(VLOOKUP(AF104,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI104,1)-AI104,2),Round,2,FALSE)+VLOOKUP(AF104,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",0,ROUND(AI104-0.04999,1)-AI104+AL104)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF104,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,7.75,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},7.75,null,"new",7.75,0,7.75,0,null,1,7.75,null,7.75,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\",AA107,AG107)","v":21.05},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA107*(1-W107),2)","v":21.05},null,"new",21.05,{"$f":"+W107","v":0},{"$f":"+X107","v":21.05},{"$f":"(AG107-AC107)/AG107","v":0},null,3,{"$f":"SUM(AI107:AK107)+AE107","v":21.05},null,{"$f":"ROUND(AC107/(1-VLOOKUP(AF107,Group,2,FALSE)),2)","v":21.05},{"$f":"IF(VLOOKUP(AF107,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI107,1)-AI107,2),Round,2,FALSE)+VLOOKUP(AF107,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF107,Group,7,FALSE)=\"\",0,ROUND(AI107-0.04999,1)-AI107+AL107)","v":0},{"$f":"IF(VLOOKUP(AF107,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF107,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,"8 EA/CTN",null,null,18,"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},18,null,"new",18,0,18,0,null,3,18,null,18,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\",AA110,AG110)","v":13.05},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA110*(1-W110),2)","v":13.05},null,"new",13.05,{"$f":"+W110","v":0},{"$f":"+X110","v":13.05},{"$f":"(AG110-AC110)/AG110","v":0},null,2,{"$f":"SUM(AI110:AK110)+AE110","v":13.05},null,{"$f":"ROUND(AC110/(1-VLOOKUP(AF110,Group,2,FALSE)),2)","v":13.05},{"$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,"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\",AA112,AG112)","v":10.95},"SF","G",null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA112*(1-W112),2)","v":10.95},null,"new",10.95,{"$f":"+W112","v":0},{"$f":"+X112","v":10.95},{"$f":"(AG112-AC112)/AG112","v":0},null,4,{"$f":"SUM(AI112:AK112)+AE112","v":10.95},null,{"$f":"ROUND(AC112/(1-VLOOKUP(AF112,Group,2,FALSE)),2)","v":10.95},{"$f":"IF(VLOOKUP(AF112,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI112,1)-AI112,2),Round,2,FALSE)+VLOOKUP(AF112,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",0,ROUND(AI112-0.04999,1)-AI112+AL112)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF112,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,15.25,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},15.25,null,"new",15.25,0,15.25,0,null,1,15.25,null,15.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\",AA115,AG115)","v":24.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA115*(1-W115),2)","v":24.15},null,"new",24.15,{"$f":"+W115","v":0},{"$f":"+X115","v":24.15},{"$f":"(AG115-AC115)/AG115","v":0},null,3,{"$f":"SUM(AI115:AK115)+AE115","v":24.15},null,{"$f":"ROUND(AC115/(1-VLOOKUP(AF115,Group,2,FALSE)),2)","v":24.15},{"$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,"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\",AA117,AG117)","v":14.85},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA117*(1-W117),2)","v":14.85},null,"new",14.85,{"$f":"+W117","v":0},{"$f":"+X117","v":14.85},{"$f":"(AG117-AC117)/AG117","v":0},null,2,{"$f":"SUM(AI117:AK117)+AE117","v":14.85},null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":14.85},{"$f":"IF(VLOOKUP(AF117,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI117,1)-AI117,2),Round,2,FALSE)+VLOOKUP(AF117,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",0,ROUND(AI117-0.04999,1)-AI117+AL117)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF117,Group,7,FALSE))","v":""},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",null,null,null,null,null,null,null,null,"6.67 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA123,AG123)","v":8.6999999999999993},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA123*(1-W123),2)","v":8.6999999999999993},null,"new",8.6999999999999993,{"$f":"+W123","v":0},{"$f":"+X123","v":8.6999999999999993},{"$f":"(AG123-AC123)/AG123","v":0},null,1,{"$f":"SUM(AI123:AK123)+AE123","v":8.6999999999999993},null,{"$f":"ROUND(AC123/(1-VLOOKUP(AF123,Group,2,FALSE)),2)","v":8.6999999999999993},{"$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,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.82 SF/CTN",null,null,6.85,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.85,null,"new",6.85,0,6.85,0,null,1,6.85,null,6.85,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.9,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.9,null,"new",6.9,0,6.9,0,null,1,6.9,null,6.9,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\",AA127,AG127)","v":21.95},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA127*(1-W127),2)","v":21.95},null,"new",21.95,{"$f":"+W127","v":0},{"$f":"+X127","v":21.95},{"$f":"(AG127-AC127)/AG127","v":0},null,3,{"$f":"SUM(AI127:AK127)+AE127","v":21.95},null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":21.95},{"$f":"IF(VLOOKUP(AF127,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI127,1)-AI127,2),Round,2,FALSE)+VLOOKUP(AF127,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",0,ROUND(AI127-0.04999,1)-AI127+AL127)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF127,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\",AA129,AG129)","v":6.7},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA129*(1-W129),2)","v":6.7},null,"new",6.7,{"$f":"+W129","v":0},{"$f":"+X129","v":6.7},{"$f":"(AG129-AC129)/AG129","v":0},null,2,{"$f":"SUM(AI129:AK129)+AE129","v":6.7},null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":6.7},{"$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,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,"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\",AA135,AG135)","v":6.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA135*(1-W135),2)","v":6.35},null,"new",6.35,{"$f":"+W135","v":0},{"$f":"+X135","v":6.35},{"$f":"(AG135-AC135)/AG135","v":0},null,1,{"$f":"SUM(AI135:AK135)+AE135","v":6.35},null,{"$f":"ROUND(AC135/(1-VLOOKUP(AF135,Group,2,FALSE)),2)","v":6.35},{"$f":"IF(VLOOKUP(AF135,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI135,1)-AI135,2),Round,2,FALSE)+VLOOKUP(AF135,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",0,ROUND(AI135-0.04999,1)-AI135+AL135)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF135,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"18\" x 36\" x 10mm",null,"Field",null,null,"DISCONTINUED 4/28/23",null,null,null,null,null,"13.46 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA136,AG136)","v":7.9},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},7.9,null,"new",7.9,0,7.9,0,null,1,7.9,null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":7.9},{"$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,"Field Tile",null,null,"18\" x 36\" x 10mm",null,"Field - Rectified",null,null,"DISCONTINUED 4/28/23",null,null,null,null,null,"13.13 SF/CTN",null,null,8.25,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},8.25,null,"new",8.25,0,8.25,0,null,1,8.25,null,8.25,0,0,"",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\",AA139,AG139)","v":21.8},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA139*(1-W139),2)","v":21.8},null,"new",21.8,{"$f":"+W139","v":0},{"$f":"+X139","v":21.8},{"$f":"(AG139-AC139)/AG139","v":0},null,3,{"$f":"SUM(AI139:AK139)+AE139","v":21.8},null,{"$f":"ROUND(AC139/(1-VLOOKUP(AF139,Group,2,FALSE)),2)","v":21.8},{"$f":"IF(VLOOKUP(AF139,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI139,1)-AI139,2),Round,2,FALSE)+VLOOKUP(AF139,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",0,ROUND(AI139-0.04999,1)-AI139+AL139)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF139,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\",AA141,AG141)","v":6.75},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA141*(1-W141),2)","v":6.75},null,"new",6.75,{"$f":"+W141","v":0},{"$f":"+X141","v":6.75},{"$f":"(AG141-AC141)/AG141","v":0},null,2,{"$f":"SUM(AI141:AK141)+AE141","v":6.75},null,{"$f":"ROUND(AC141/(1-VLOOKUP(AF141,Group,2,FALSE)),2)","v":6.75},{"$f":"IF(VLOOKUP(AF141,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI141,1)-AI141,2),Round,2,FALSE)+VLOOKUP(AF141,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,7,FALSE)=\"\",0,ROUND(AI141-0.04999,1)-AI141+AL141)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF141,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",10.199999999999999,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA143*(1-W143),2)","v":10.199999999999999},null,"new",10.199999999999999,{"$f":"+W143","v":0},{"$f":"+X143","v":10.199999999999999},{"$f":"(AG143-AC143)/AG143","v":0},null,1,{"$f":"SUM(AI143:AK143)+AE143","v":10.199999999999999},null,{"$f":"ROUND(AC143/(1-VLOOKUP(AF143,Group,2,FALSE)),2)","v":10.199999999999999},{"$f":"IF(VLOOKUP(AF143,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI143,1)-AI143,2),Round,2,FALSE)+VLOOKUP(AF143,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",0,ROUND(AI143-0.04999,1)-AI143+AL143)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF143,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null," ","Notes:","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\",AA152,AG152)","v":7.1},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA152*(1-W152),2)","v":7.1},null,"new",7.1,{"$f":"+W152","v":0},{"$f":"+X152","v":7.1},{"$f":"(AG152-AC152)/AG152","v":0},null,1,{"$f":"SUM(AI152:AK152)+AE152","v":7.1},null,{"$f":"ROUND(AC152/(1-VLOOKUP(AF152,Group,2,FALSE)),2)","v":7.1},{"$f":"IF(VLOOKUP(AF152,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI152,1)-AI152,2),Round,2,FALSE)+VLOOKUP(AF152,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",0,ROUND(AI152-0.04999,1)-AI152+AL152)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF152,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\",AA158,AG158)","v":7.1},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA158*(1-W158),2)","v":7.1},null,"new",7.1,{"$f":"+W158","v":0},{"$f":"+X158","v":7.1},{"$f":"(AG158-AC158)/AG158","v":0},null,1,{"$f":"SUM(AI158:AK158)+AE158","v":7.1},null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":7.1},{"$f":"IF(VLOOKUP(AF158,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI158,1)-AI158,2),Round,2,FALSE)+VLOOKUP(AF158,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",0,ROUND(AI158-0.04999,1)-AI158+AL158)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF158,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,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,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,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,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":19,"n_cols":10,"rows_kept":19,"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"]
["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":25,"n_cols":3,"rows_kept":25,"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"]
[]
[" "," "]
[" "," "]
["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," "]