{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Changes"],"not_rendered":{"charts":0,"images":3,"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":9,"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/25 (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."]
[]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0]
[null,2,null,"Trim",null,"No",0]
[null,3,null,"Decos",null,"No",0,null," "]
[null,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 - 1/1/25 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[1,null,"Contemporary",null,"Color-Body Glazed Porcelain"]
[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,"Playlist+",null,"Glazed Porcelain Floor & Wall"]
[2,null,"Prestige",null,"Glazed Porcelain Floor & Wall",null,null,null,null,null,null,null,null," "]
[2,null,"Suite",null,"Glazed Porcelain Floor & Wall"]
[2,null,"Wood Trend",null,"Glazed Porcelain Floor"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,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":"1/1/25 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-02-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,"CONTEMPORARY - Color-Body Glazed Porcelain w/ Microban",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNCN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Chic White          Edge Gray          Mod Beige          NU Taupe          Vogue Dark Gray",null,null,null,null,null,null,null,null,null,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,"Soft",null,null,null,null,null,"15.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA25,AG25)","v":5.5},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA25*(1-W25),2)","v":5.5},null,"",5.5,{"$f":"+W25","v":0},{"$f":"+X25","v":5.5},{"$f":"(AG25-AC25)/AG25","v":0},null,1,{"$f":"SUM(AI25:AK25)+AE25","v":5.5},null,{"$f":"ROUND(AC25/(1-VLOOKUP(AF25,Group,2,FALSE)),2)","v":5.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,"36\" x 36\"",null,"Field - Rectified",null,null,"Soft",null,null,null,null,null,"17.40 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA26,AG26)","v":7.9},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA26*(1-W26),2)","v":7.9},null,"",7.9,{"$f":"+W26","v":0},{"$f":"+X26","v":7.9},{"$f":"(AG26-AC26)/AG26","v":0},null,1,{"$f":"SUM(AI26:AK26)+AE26","v":7.9},null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":7.9},{"$f":"IF(VLOOKUP(AF26,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI26,1)-AI26,2),Round,2,FALSE)+VLOOKUP(AF26,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF26,Group,7,FALSE)=\"\",0,ROUND(AI26-0.04999,1)-AI26+AL26)","v":0},{"$f":"IF(VLOOKUP(AF26,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF26,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field - Rectified",null,null,"Soft",null,null,null,null,null,"15.39 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,"Field Tile",null,null,"24\" x 48\"",null,"Field - Rectified",null,null,"Leather",null,null,null,null,null,"15.39 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA28,AG28)","v":7.55},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA28*(1-W28),2)","v":7.55},null,"",7.55,{"$f":"+W28","v":0},{"$f":"+X28","v":7.55},{"$f":"(AG28-AC28)/AG28","v":0},null,1,{"$f":"SUM(AI28:AK28)+AE28","v":7.55},null,{"$f":"ROUND(AC28/(1-VLOOKUP(AF28,Group,2,FALSE)),2)","v":7.55},{"$f":"IF(VLOOKUP(AF28,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI28,1)-AI28,2),Round,2,FALSE)+VLOOKUP(AF28,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF28,Group,7,FALSE)=\"\",0,ROUND(AI28-0.04999,1)-AI28+AL28)","v":0},{"$f":"IF(VLOOKUP(AF28,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF28,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"4\" x 21\"",null,"Field - Chevron - Rectified",null,null,"   Soft",null,null,null,null,null,"4.42 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA30,AG30)","v":42.55},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA30*(1-W30),2)","v":42.55},null,"",42.55,{"$f":"+W30","v":0},{"$f":"+X30","v":42.55},{"$f":"(AG30-AC30)/AG30","v":0},null,3,{"$f":"SUM(AI30:AK30)+AE30","v":42.55},null,{"$f":"ROUND(AC30/(1-VLOOKUP(AF30,Group,2,FALSE)),2)","v":42.55},{"$f":"IF(VLOOKUP(AF30,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI30,1)-AI30,2),Round,2,FALSE)+VLOOKUP(AF30,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF30,Group,7,FALSE)=\"\",0,ROUND(AI30-0.04999,1)-AI30+AL30)","v":0},{"$f":"IF(VLOOKUP(AF30,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF30,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 24\"",null,"Field - Rectified - Cool Mix Deco Accessory",null,null,null,null,null,"Soft",null,null,"15.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA31,AG31)","v":5.7},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA31*(1-W31),2)","v":5.7},null,"",5.7,{"$f":"+W31","v":0},{"$f":"+X31","v":5.7},{"$f":"(AG31-AC31)/AG31","v":0},null,3,{"$f":"SUM(AI31:AK31)+AE31","v":5.7},null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":5.7},{"$f":"IF(VLOOKUP(AF31,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI31,1)-AI31,2),Round,2,FALSE)+VLOOKUP(AF31,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",0,ROUND(AI31-0.04999,1)-AI31+AL31)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF31,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 24\"",null,"Field - Rectified - Warm Mix Deco Accessory",null,null,null,null,null,"Soft",null,null,"15.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA32,AG32)","v":5.7},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA32*(1-W32),2)","v":5.7},null,"",5.7,{"$f":"+W32","v":0},{"$f":"+X32","v":5.7},{"$f":"(AG32-AC32)/AG32","v":0},null,3,{"$f":"SUM(AI32:AK32)+AE32","v":5.7},null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":5.7},{"$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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\" Basketweave",null,null,"Soft",".97 sf/sheet",null,null,"4.84 SF/CTN",null,null,25.65,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},25.65,null,"",25.65,0,25.65,0,null,3,25.65,null,25.65,0,0,"",null,"X"]
[]
[null,"Trim",null,null,"4\" x 24\"",null,"Bullnose",null,null,"Soft",null,null,null,null,null,"16 EA/CTN",null,null,13.9,"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},13.9,null,"",13.9,0,13.9,0,null,2,13.9,null,13.9,0,0,"",null,"X"]
[]
[null,null,null,"Colors:","Chic White          Edge Gray          Mod Beige",null,null,null,null,null,null,null,null,null,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,"24\" x 24\" x 20mm",null,"Field - Rectified",null,null,"Anti-Slip",null,null,null,null,null,"7.79 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA40,AG40)","v":11.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA40*(1-W40),2)","v":11.35},null,"",11.35,{"$f":"+W40","v":0},{"$f":"+X40","v":11.35},{"$f":"(AG40-AC40)/AG40","v":0},null,1,{"$f":"SUM(AI40:AK40)+AE40","v":11.35},null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":11.35},{"$f":"IF(VLOOKUP(AF40,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI40,1)-AI40,2),Round,2,FALSE)+VLOOKUP(AF40,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,7,FALSE)=\"\",0,ROUND(AI40-0.04999,1)-AI40+AL40)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF40,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,"12\" x 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA46,AG46)","v":5.95},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA46*(1-W46),2)","v":5.95},null,"",5.95,{"$f":"+W46","v":0},{"$f":"+X46","v":5.95},{"$f":"(AG46-AC46)/AG46","v":0},null,1,{"$f":"SUM(AI46:AK46)+AE46","v":5.95},null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":5.95},{"$f":"IF(VLOOKUP(AF46,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI46,1)-AI46,2),Round,2,FALSE)+VLOOKUP(AF46,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",0,ROUND(AI46-0.04999,1)-AI46+AL46)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF46,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\" Basketweave",null,null,null,".97 sf/sheet",null,null,"4.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA48,AG48)","v":26.65},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA48*(1-W48),2)","v":26.65},null,"",26.65,{"$f":"+W48","v":0},{"$f":"+X48","v":26.65},{"$f":"(AG48-AC48)/AG48","v":0},null,3,{"$f":"SUM(AI48:AK48)+AE48","v":26.65},null,{"$f":"ROUND(AC48/(1-VLOOKUP(AF48,Group,2,FALSE)),2)","v":26.65},{"$f":"IF(VLOOKUP(AF48,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI48,1)-AI48,2),Round,2,FALSE)+VLOOKUP(AF48,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF48,Group,7,FALSE)=\"\",0,ROUND(AI48-0.04999,1)-AI48+AL48)","v":0},{"$f":"IF(VLOOKUP(AF48,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF48,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\",AA51,AG51)","v":7.85},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA51*(1-W51),2)","v":7.85},null,"",7.85,{"$f":"+W51","v":0},{"$f":"+X51","v":7.85},{"$f":"(AG51-AC51)/AG51","v":0},null,2,{"$f":"SUM(AI51:AK51)+AE51","v":7.85},null,{"$f":"ROUND(AC51/(1-VLOOKUP(AF51,Group,2,FALSE)),2)","v":7.85},{"$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,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\",AA57,AG57)","v":5.4},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA57*(1-W57),2)","v":5.4},null,"",5.4,{"$f":"+W57","v":0},{"$f":"+X57","v":5.4},{"$f":"(AG57-AC57)/AG57","v":0},null,1,{"$f":"SUM(AI57:AK57)+AE57","v":5.4},null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":5.4},{"$f":"IF(VLOOKUP(AF57,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI57,1)-AI57,2),Round,2,FALSE)+VLOOKUP(AF57,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",0,ROUND(AI57-0.04999,1)-AI57+AL57)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF57,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\",AA59,AG59)","v":22.2},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA59*(1-W59),2)","v":22.2},null,"",22.2,{"$f":"+W59","v":0},{"$f":"+X59","v":22.2},{"$f":"(AG59-AC59)/AG59","v":0},null,3,{"$f":"SUM(AI59:AK59)+AE59","v":22.2},null,{"$f":"ROUND(AC59/(1-VLOOKUP(AF59,Group,2,FALSE)),2)","v":22.2},{"$f":"IF(VLOOKUP(AF59,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI59,1)-AI59,2),Round,2,FALSE)+VLOOKUP(AF59,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",0,ROUND(AI59-0.04999,1)-AI59+AL59)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF59,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.2,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},28.2,null,"",28.2,0,28.2,0,null,3,28.2,null,28.2,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\",AA62,AG62)","v":13.55},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA62*(1-W62),2)","v":13.55},null,"",13.55,{"$f":"+W62","v":0},{"$f":"+X62","v":13.55},{"$f":"(AG62-AC62)/AG62","v":0},null,2,{"$f":"SUM(AI62:AK62)+AE62","v":13.55},null,{"$f":"ROUND(AC62/(1-VLOOKUP(AF62,Group,2,FALSE)),2)","v":13.55},{"$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,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\",AA68,AG68)","v":5.85},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA68*(1-W68),2)","v":5.85},null,"",5.85,{"$f":"+W68","v":0},{"$f":"+X68","v":5.85},{"$f":"(AG68-AC68)/AG68","v":0},null,1,{"$f":"SUM(AI68:AK68)+AE68","v":5.85},null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":5.85},{"$f":"IF(VLOOKUP(AF68,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI68,1)-AI68,2),Round,2,FALSE)+VLOOKUP(AF68,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",0,ROUND(AI68-0.04999,1)-AI68+AL68)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF68,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.6,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.6,null,"",6.6,0,6.6,0,null,1,6.6,null,6.6,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.3,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},7.3,null,"",7.3,0,7.3,0,null,1,7.3,null,7.3,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,"a",{"$f":"IF(Suggested=\"Yes\",AA72,AG72)","v":6.75},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA72*(1-W72),2)","v":6.75},null,"",6.75,{"$f":"+W72","v":0},{"$f":"+X72","v":6.75},{"$f":"(AG72-AC72)/AG72","v":0},null,3,{"$f":"SUM(AI72:AK72)+AE72","v":6.75},null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":6.75},{"$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,"Decos",null,null,"24\" x 24\"",null,"Field - Rectified - Deco Accessory",null,null,null,null,null,null,null,null,"15.61 SF/CTN",null,"a",7.6,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},7.6,null,"",7.6,0,7.6,0,null,3,7.6,null,7.6,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($AA75*(1-W75),2)","v":22.1},null,"",22.1,{"$f":"+W75","v":0},{"$f":"+X75","v":22.1},{"$f":"(AG75-AC75)/AG75","v":0},null,3,{"$f":"SUM(AI75:AK75)+AE75","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.35,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},28.35,null,"",28.35,0,28.35,0,null,3,28.35,null,28.35,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\",AA78,AG78)","v":13.45},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA78*(1-W78),2)","v":13.45},null,"",13.45,{"$f":"+W78","v":0},{"$f":"+X78","v":13.45},{"$f":"(AG78-AC78)/AG78","v":0},null,2,{"$f":"SUM(AI78:AK78)+AE78","v":13.45},null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":13.45},{"$f":"IF(VLOOKUP(AF78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI78,1)-AI78,2),Round,2,FALSE)+VLOOKUP(AF78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",0,ROUND(AI78-0.04999,1)-AI78+AL78)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF78,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.45,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA80*(1-W80),2)","v":10.45},null,"",10.45,{"$f":"+W80","v":0},{"$f":"+X80","v":10.45},{"$f":"(AG80-AC80)/AG80","v":0},null,1,{"$f":"SUM(AI80:AK80)+AE80","v":10.45},null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":10.45},{"$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,null," ","Note:","a) 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\",AA88,AG88)","v":6.2},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA88*(1-W88),2)","v":6.2},null,"",6.2,{"$f":"+W88","v":0},{"$f":"+X88","v":6.2},{"$f":"(AG88-AC88)/AG88","v":0},null,1,{"$f":"SUM(AI88:AK88)+AE88","v":6.2},null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":6.2},{"$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,"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\",AA90,AG90)","v":26.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA90*(1-W90),2)","v":26.35},null,"",26.35,{"$f":"+W90","v":0},{"$f":"+X90","v":26.35},{"$f":"(AG90-AC90)/AG90","v":0},null,3,{"$f":"SUM(AI90:AK90)+AE90","v":26.35},null,{"$f":"ROUND(AC90/(1-VLOOKUP(AF90,Group,2,FALSE)),2)","v":26.35},{"$f":"IF(VLOOKUP(AF90,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI90,1)-AI90,2),Round,2,FALSE)+VLOOKUP(AF90,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,7,FALSE)=\"\",0,ROUND(AI90-0.04999,1)-AI90+AL90)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF90,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\",AA96,AG96)","v":5.45},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA96*(1-W96),2)","v":5.45},null,"",5.45,{"$f":"+W96","v":0},{"$f":"+X96","v":5.45},{"$f":"(AG96-AC96)/AG96","v":0},null,1,{"$f":"SUM(AI96:AK96)+AE96","v":5.45},null,{"$f":"ROUND(AC96/(1-VLOOKUP(AF96,Group,2,FALSE)),2)","v":5.45},{"$f":"IF(VLOOKUP(AF96,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI96,1)-AI96,2),Round,2,FALSE)+VLOOKUP(AF96,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",0,ROUND(AI96-0.04999,1)-AI96+AL96)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF96,Group,7,FALSE))","v":""},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\",AA98,AG98)","v":24.85},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA98*(1-W98),2)","v":24.85},null,"",24.85,{"$f":"+W98","v":0},{"$f":"+X98","v":24.85},{"$f":"(AG98-AC98)/AG98","v":0},null,3,{"$f":"SUM(AI98:AK98)+AE98","v":24.85},null,{"$f":"ROUND(AC98/(1-VLOOKUP(AF98,Group,2,FALSE)),2)","v":24.85},{"$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,"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\",AA100,AG100)","v":7.15},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA100*(1-W100),2)","v":7.15},null,"",7.15,{"$f":"+W100","v":0},{"$f":"+X100","v":7.15},{"$f":"(AG100-AC100)/AG100","v":0},null,2,{"$f":"SUM(AI100:AK100)+AE100","v":7.15},null,{"$f":"ROUND(AC100/(1-VLOOKUP(AF100,Group,2,FALSE)),2)","v":7.15},{"$f":"IF(VLOOKUP(AF100,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI100,1)-AI100,2),Round,2,FALSE)+VLOOKUP(AF100,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF100,Group,7,FALSE)=\"\",0,ROUND(AI100-0.04999,1)-AI100+AL100)","v":0},{"$f":"IF(VLOOKUP(AF100,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF100,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\",AA104,AG104)","v":6.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA104*(1-W104),2)","v":6.15},null,"",6.15,{"$f":"+W104","v":0},{"$f":"+X104","v":6.15},{"$f":"(AG104-AC104)/AG104","v":0},null,1,{"$f":"SUM(AI104:AK104)+AE104","v":6.15},null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":6.15},{"$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,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\",AA113,AG113)","v":9.5500000000000007},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA113*(1-W113),2)","v":9.5500000000000007},null,"",9.5500000000000007,{"$f":"+W113","v":0},{"$f":"+X113","v":9.5500000000000007},{"$f":"(AG113-AC113)/AG113","v":0},null,1,{"$f":"SUM(AI113:AK113)+AE113","v":9.5500000000000007},null,{"$f":"ROUND(AC113/(1-VLOOKUP(AF113,Group,2,FALSE)),2)","v":9.5500000000000007},{"$f":"IF(VLOOKUP(AF113,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI113,1)-AI113,2),Round,2,FALSE)+VLOOKUP(AF113,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",0,ROUND(AI113-0.04999,1)-AI113+AL113)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF113,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\",AA114,AG114)","v":9.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA114*(1-W114),2)","v":9.35},null,"",9.35,{"$f":"+W114","v":0},{"$f":"+X114","v":9.35},{"$f":"(AG114-AC114)/AG114","v":0},null,1,{"$f":"SUM(AI114:AK114)+AE114","v":9.35},null,{"$f":"ROUND(AC114/(1-VLOOKUP(AF114,Group,2,FALSE)),2)","v":9.35},{"$f":"IF(VLOOKUP(AF114,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI114,1)-AI114,2),Round,2,FALSE)+VLOOKUP(AF114,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF114,Group,7,FALSE)=\"\",0,ROUND(AI114-0.04999,1)-AI114+AL114)","v":0},{"$f":"IF(VLOOKUP(AF114,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF114,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\",AA118,AG118)","v":9.9},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA118*(1-W118),2)","v":9.9},null,"",9.9,{"$f":"+W118","v":0},{"$f":"+X118","v":9.9},{"$f":"(AG118-AC118)/AG118","v":0},null,3,{"$f":"SUM(AI118:AK118)+AE118","v":9.9},null,{"$f":"ROUND(AC118/(1-VLOOKUP(AF118,Group,2,FALSE)),2)","v":9.9},{"$f":"IF(VLOOKUP(AF118,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI118,1)-AI118,2),Round,2,FALSE)+VLOOKUP(AF118,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",0,ROUND(AI118-0.04999,1)-AI118+AL118)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF118,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,"PLAYLIST+ - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNPP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Ambient White",null,"         Gothic Grey",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,"         Grunge Greige",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,null,null,null,"Folk Green",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," ",null,null,null,"X"]
[]
[null,"Field Tile",null,"Soft:","12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"18.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA128,AG128)","v":4.75},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA128*(1-W128),2)","v":4.75},null,"",4.75,{"$f":"+W128","v":0},{"$f":"+X128","v":4.75},{"$f":"(AG128-AC128)/AG128","v":0},null,1,{"$f":"SUM(AI128:AK128)+AE128","v":4.75},null,{"$f":"ROUND(AC128/(1-VLOOKUP(AF128,Group,2,FALSE)),2)","v":4.75},{"$f":"IF(VLOOKUP(AF128,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI128,1)-AI128,2),Round,2,FALSE)+VLOOKUP(AF128,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",0,ROUND(AI128-0.04999,1)-AI128+AL128)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF128,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,".97 sf/sheet",null,null,"4.85 SF/CTN",null,null,21.45,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},21.45,null,"",21.45,0,21.45,0,null,3,21.45,null,21.45,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\",AA132,AG132)","v":13.55},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA132*(1-W132),2)","v":13.55},null,"",13.55,{"$f":"+W132","v":0},{"$f":"+X132","v":13.55},{"$f":"(AG132-AC132)/AG132","v":0},null,2,{"$f":"SUM(AI132:AK132)+AE132","v":13.55},null,{"$f":"ROUND(AC132/(1-VLOOKUP(AF132,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF132,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI132,1)-AI132,2),Round,2,FALSE)+VLOOKUP(AF132,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",0,ROUND(AI132-0.04999,1)-AI132+AL132)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF132,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\",AA138,AG138)","v":5.95},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA138*(1-W138),2)","v":5.95},null,"",5.95,{"$f":"+W138","v":0},{"$f":"+X138","v":5.95},{"$f":"(AG138-AC138)/AG138","v":0},null,1,{"$f":"SUM(AI138:AK138)+AE138","v":5.95},null,{"$f":"ROUND(AC138/(1-VLOOKUP(AF138,Group,2,FALSE)),2)","v":5.95},{"$f":"IF(VLOOKUP(AF138,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI138,1)-AI138,2),Round,2,FALSE)+VLOOKUP(AF138,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF138,Group,7,FALSE)=\"\",0,ROUND(AI138-0.04999,1)-AI138+AL138)","v":0},{"$f":"IF(VLOOKUP(AF138,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF138,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.61 SF/CTN",null,"a",6.75,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.75,null,"",6.75,0,6.75,0,null,1,6.75,null,6.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\",AA141,AG141)","v":21.4},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA141*(1-W141),2)","v":21.4},null,"",21.4,{"$f":"+W141","v":0},{"$f":"+X141","v":21.4},{"$f":"(AG141-AC141)/AG141","v":0},null,3,{"$f":"SUM(AI141:AK141)+AE141","v":21.4},null,{"$f":"ROUND(AC141/(1-VLOOKUP(AF141,Group,2,FALSE)),2)","v":21.4},{"$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,"Decos",null,null,"4\" x 21\"",null,"Field",null,"Chevron",null,null,null,".55 sf/piece",null,null,"4.40 SF/CTN",null,"b",42.5,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},42.5,null,"YES",42.5,0,42.5,0,null,3,42.5,null,42.5,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\",AA144,AG144)","v":13},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA144*(1-W144),2)","v":13},null,"",13,{"$f":"+W144","v":0},{"$f":"+X144","v":13},{"$f":"(AG144-AC144)/AG144","v":0},null,2,{"$f":"SUM(AI144:AK144)+AE144","v":13},null,{"$f":"ROUND(AC144/(1-VLOOKUP(AF144,Group,2,FALSE)),2)","v":13},{"$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,"Lux:","12\" x 24\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"17.44 SF/CTN","Stock","c",{"$f":"IF(Suggested=\"Yes\",AA146,AG146)","v":8.3000000000000007},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA146*(1-W146),2)","v":8.3000000000000007},null,"",8.3000000000000007,{"$f":"+W146","v":0},{"$f":"+X146","v":8.3000000000000007},{"$f":"(AG146-AC146)/AG146","v":0},null,1,{"$f":"SUM(AI146:AK146)+AE146","v":8.3000000000000007},null,{"$f":"ROUND(AC146/(1-VLOOKUP(AF146,Group,2,FALSE)),2)","v":8.3000000000000007},{"$f":"IF(VLOOKUP(AF146,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI146,1)-AI146,2),Round,2,FALSE)+VLOOKUP(AF146,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",0,ROUND(AI146-0.04999,1)-AI146+AL146)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF146,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.61 SF/CTN",null,"d",9.3000000000000007,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},9.3000000000000007,null,"",9.3000000000000007,0,9.3000000000000007,0,null,1,9.3000000000000007,null,9.3000000000000007,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\",AA149,AG149)","v":24.5},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA149*(1-W149),2)","v":24.5},null,"",24.5,{"$f":"+W149","v":0},{"$f":"+X149","v":24.5},{"$f":"(AG149-AC149)/AG149","v":0},null,3,{"$f":"SUM(AI149:AK149)+AE149","v":24.5},null,{"$f":"ROUND(AC149/(1-VLOOKUP(AF149,Group,2,FALSE)),2)","v":24.5},{"$f":"IF(VLOOKUP(AF149,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI149,1)-AI149,2),Round,2,FALSE)+VLOOKUP(AF149,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",0,ROUND(AI149-0.04999,1)-AI149+AL149)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF149,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\",AA151,AG151)","v":14.85},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA151*(1-W151),2)","v":14.85},null,"",14.85,{"$f":"+W151","v":0},{"$f":"+X151","v":14.85},{"$f":"(AG151-AC151)/AG151","v":0},null,2,{"$f":"SUM(AI151:AK151)+AE151","v":14.85},null,{"$f":"ROUND(AC151/(1-VLOOKUP(AF151,Group,2,FALSE)),2)","v":14.85},{"$f":"IF(VLOOKUP(AF151,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI151,1)-AI151,2),Round,2,FALSE)+VLOOKUP(AF151,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,7,FALSE)=\"\",0,ROUND(AI151-0.04999,1)-AI151+AL151)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF151,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null," ","Notes:","a) Packaging is changing from 15.50 SF/CTN to 15.61 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) 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," ",null,"c) Packaging is changing from 17.44 SF/CTN to 15.62 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,"d) Packaging is changing from 15.50 SF/CTN to 15.61 SF/CTN and to 15.39 SF/CTN as inventory with",null,null,null,null,null,null,null,null,null,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,"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,"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\",AA163,AG163)","v":8.5},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA163*(1-W163),2)","v":8.5},null,"",8.5,{"$f":"+W163","v":0},{"$f":"+X163","v":8.5},{"$f":"(AG163-AC163)/AG163","v":0},null,1,{"$f":"SUM(AI163:AK163)+AE163","v":8.5},null,{"$f":"ROUND(AC163/(1-VLOOKUP(AF163,Group,2,FALSE)),2)","v":8.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,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.82 SF/CTN",null,null,6,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6,null,"",6,0,6,0,null,1,6,null,6,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.1,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.1,null,"",6.1,0,6.1,0,null,1,6.1,null,6.1,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\",AA167,AG167)","v":23.2},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA167*(1-W167),2)","v":23.2},null,"",23.2,{"$f":"+W167","v":0},{"$f":"+X167","v":23.2},{"$f":"(AG167-AC167)/AG167","v":0},null,3,{"$f":"SUM(AI167:AK167)+AE167","v":23.2},null,{"$f":"ROUND(AC167/(1-VLOOKUP(AF167,Group,2,FALSE)),2)","v":23.2},{"$f":"IF(VLOOKUP(AF167,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI167,1)-AI167,2),Round,2,FALSE)+VLOOKUP(AF167,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF167,Group,7,FALSE)=\"\",0,ROUND(AI167-0.04999,1)-AI167+AL167)","v":0},{"$f":"IF(VLOOKUP(AF167,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF167,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\",AA169,AG169)","v":6.55},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA169*(1-W169),2)","v":6.55},null,"",6.55,{"$f":"+W169","v":0},{"$f":"+X169","v":6.55},{"$f":"(AG169-AC169)/AG169","v":0},null,2,{"$f":"SUM(AI169:AK169)+AE169","v":6.55},null,{"$f":"ROUND(AC169/(1-VLOOKUP(AF169,Group,2,FALSE)),2)","v":6.55},{"$f":"IF(VLOOKUP(AF169,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI169,1)-AI169,2),Round,2,FALSE)+VLOOKUP(AF169,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF169,Group,7,FALSE)=\"\",0,ROUND(AI169-0.04999,1)-AI169+AL169)","v":0},{"$f":"IF(VLOOKUP(AF169,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF169,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 will be",null,null,null,null,null,null,null,null,null,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,"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,"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\",AA178,AG178)","v":6.2},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA178*(1-W178),2)","v":6.2},null,"",6.2,{"$f":"+W178","v":0},{"$f":"+X178","v":6.2},{"$f":"(AG178-AC178)/AG178","v":0},null,1,{"$f":"SUM(AI178:AK178)+AE178","v":6.2},null,{"$f":"ROUND(AC178/(1-VLOOKUP(AF178,Group,2,FALSE)),2)","v":6.2},{"$f":"IF(VLOOKUP(AF178,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI178,1)-AI178,2),Round,2,FALSE)+VLOOKUP(AF178,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF178,Group,7,FALSE)=\"\",0,ROUND(AI178-0.04999,1)-AI178+AL178)","v":0},{"$f":"IF(VLOOKUP(AF178,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF178,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,"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"]
["Contemporary","https://www.panaria.us/collection/contemporary"]
["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","https://www.panaria.us/collection/playlist"]
["Playlist+"]
["Prestige","https://www.panaria.us/collection/prestige"]
["Suite","https://www.panaria.us/collection/suite"]
["Wood Trend","https://www.panaria.us/collection/wood-trend"]

{"sheet":"Changes","index":4,"n_rows":34,"n_cols":3,"rows_kept":34,"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-08","Playlist","Glazed Porcelain"]
["2024-08-21","Contemporary","Color-Body Glazed Porcelain"]
["2025-01-01","Playlist+","Glazed Porcelain"]
[]
[" "," "]
[" "," "]
["Discontinued Products"]
["2023-04-28","True","18\" x 36\" x 10mm Pressed and Rectified Field Tile formats only in all colors."]
["2024-08-21","Connect","Entire Series."]
["2024-08-21","Craft","8\" x 24\" and 24\" x 24\" Field Tile formats only in all colors."]
["2024-08-21","Metropolitan","24\" x 24\" Pressed and Rectified Field Tile formats only in all colors."]
["2024-08-21","True","Entire Series."]
["2024-08-21","Wood You","Entire Series."]
[]
[" "," "]
[" "," "]
["Changes"]
["2023-01-03","Prestige","Packaging for the 12\" x 24\" Soft finish only Field Tile format has changed to 15.61 SF/CTN."]
["2024-07-08","Suite","The 4\" x 12\" Field Tile format is changing from a pressed to a rectified edge.  Packaging for the rectified version will be 6.12 SF/CTN as inventory with the pressed format is depleted."]
[null,null," "]