{"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":10,"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","10/1/25"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+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,null,"  "]
[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 - 10/1/25"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[1,null,"Contemporary",null,"Colored-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,"Luxe Ensemble",null,"Colored-Body Glazed Porcelain"]
[2,null,"Metropolitan",null,"Glazed Porcelain Floor & Wall"]
[2,null,"Moondance",null,"Colored-Body Glazed Porcelain"]
[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," "]
[3,null,"Suite",null,"Glazed Porcelain Floor & Wall"]
[3,null,"Terrazzo",null,"Glazed Porcelain"]
[3,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":285,"n_cols":40,"rows_kept":285,"cut":false,"hidden":false,"merged":[[10,14,10,15],[271,2,271,19],[9,25,9,32],[12,22,12,23],[9,22,9,23],[9,14,9,19],[269,2,269,19],[13,30,13,32],[274,3,274,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":"10/1/25"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-09-04"},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,"X"]
[null,null,"CONTEMPORARY - Colored-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.7},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA25*(1-W25),2)","v":5.7},null,"YES",5.7,{"$f":"+W25","v":0},{"$f":"+X25","v":5.7},{"$f":"(AG25-AC25)/AG25","v":0},null,1,{"$f":"SUM(AI25:AK25)+AE25","v":5.7},null,{"$f":"ROUND(AC25/(1-VLOOKUP(AF25,Group,2,FALSE)),2)","v":5.7},{"$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":8.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA26*(1-W26),2)","v":8.15},null,"YES",8.15,{"$f":"+W26","v":0},{"$f":"+X26","v":8.15},{"$f":"(AG26-AC26)/AG26","v":0},null,1,{"$f":"SUM(AI26:AK26)+AE26","v":8.15},null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":8.15},{"$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.9,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.9,null,"YES",6.9,0,6.9,0,null,1,6.9,null,6.9,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.85},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA28*(1-W28),2)","v":7.85},null,"YES",7.85,{"$f":"+W28","v":0},{"$f":"+X28","v":7.85},{"$f":"(AG28-AC28)/AG28","v":0},null,1,{"$f":"SUM(AI28:AK28)+AE28","v":7.85},null,{"$f":"ROUND(AC28/(1-VLOOKUP(AF28,Group,2,FALSE)),2)","v":7.85},{"$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":44.2},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA30*(1-W30),2)","v":44.2},null,"YES",44.2,{"$f":"+W30","v":0},{"$f":"+X30","v":44.2},{"$f":"(AG30-AC30)/AG30","v":0},null,3,{"$f":"SUM(AI30:AK30)+AE30","v":44.2},null,{"$f":"ROUND(AC30/(1-VLOOKUP(AF30,Group,2,FALSE)),2)","v":44.2},{"$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.85},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA31*(1-W31),2)","v":5.85},null,"YES",5.85,{"$f":"+W31","v":0},{"$f":"+X31","v":5.85},{"$f":"(AG31-AC31)/AG31","v":0},null,3,{"$f":"SUM(AI31:AK31)+AE31","v":5.85},null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":5.85},{"$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.85},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA32*(1-W32),2)","v":5.85},null,"YES",5.85,{"$f":"+W32","v":0},{"$f":"+X32","v":5.85},{"$f":"(AG32-AC32)/AG32","v":0},null,3,{"$f":"SUM(AI32:AK32)+AE32","v":5.85},null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":5.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,"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,26.65,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},26.65,null,"YES",26.65,0,26.65,0,null,3,26.65,null,26.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,14.45,"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},14.45,null,"YES",14.45,0,14.45,0,null,2,14.45,null,14.45,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.75},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA40*(1-W40),2)","v":11.75},null,"YES",11.75,{"$f":"+W40","v":0},{"$f":"+X40","v":11.75},{"$f":"(AG40-AC40)/AG40","v":0},null,1,{"$f":"SUM(AI40:AK40)+AE40","v":11.75},null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":11.75},{"$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 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":6.2},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA46*(1-W46),2)","v":6.2},null,"YES",6.2,{"$f":"+W46","v":0},{"$f":"+X46","v":6.2},{"$f":"(AG46-AC46)/AG46","v":0},null,1,{"$f":"SUM(AI46:AK46)+AE46","v":6.2},null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":6.2},{"$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":27.7},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA48*(1-W48),2)","v":27.7},null,"YES",27.7,{"$f":"+W48","v":0},{"$f":"+X48","v":27.7},{"$f":"(AG48-AC48)/AG48","v":0},null,3,{"$f":"SUM(AI48:AK48)+AE48","v":27.7},null,{"$f":"ROUND(AC48/(1-VLOOKUP(AF48,Group,2,FALSE)),2)","v":27.7},{"$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,28.8,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},28.8,null,"YES",28.8,0,28.8,0,null,3,28.8,null,28.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\",AA51,AG51)","v":8.15},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA51*(1-W51),2)","v":8.15},null,"YES",8.15,{"$f":"+W51","v":0},{"$f":"+X51","v":8.15},{"$f":"(AG51-AC51)/AG51","v":0},null,2,{"$f":"SUM(AI51:AK51)+AE51","v":8.15},null,{"$f":"ROUND(AC51/(1-VLOOKUP(AF51,Group,2,FALSE)),2)","v":8.15},{"$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 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.6},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA57*(1-W57),2)","v":5.6},null,"YES",5.6,{"$f":"+W57","v":0},{"$f":"+X57","v":5.6},{"$f":"(AG57-AC57)/AG57","v":0},null,1,{"$f":"SUM(AI57:AK57)+AE57","v":5.6},null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":5.6},{"$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":23.05},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA59*(1-W59),2)","v":23.05},null,"YES",23.05,{"$f":"+W59","v":0},{"$f":"+X59","v":23.05},{"$f":"(AG59-AC59)/AG59","v":0},null,3,{"$f":"SUM(AI59:AK59)+AE59","v":23.05},null,{"$f":"ROUND(AC59/(1-VLOOKUP(AF59,Group,2,FALSE)),2)","v":23.05},{"$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,29.25,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},29.25,null,"YES",29.25,0,29.25,0,null,3,29.25,null,29.25,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":14.05},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA62*(1-W62),2)","v":14.05},null,"YES",14.05,{"$f":"+W62","v":0},{"$f":"+X62","v":14.05},{"$f":"(AG62-AC62)/AG62","v":0},null,2,{"$f":"SUM(AI62:AK62)+AE62","v":14.05},null,{"$f":"ROUND(AC62/(1-VLOOKUP(AF62,Group,2,FALSE)),2)","v":14.05},{"$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 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":4.95},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA68*(1-W68),2)","v":4.95},null,"YES",4.95,{"$f":"+W68","v":0},{"$f":"+X68","v":4.95},{"$f":"(AG68-AC68)/AG68","v":0},null,1,{"$f":"SUM(AI68:AK68)+AE68","v":4.95},null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":4.95},{"$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,5.75,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},5.75,null,"YES",5.75,0,5.75,0,null,1,5.75,null,5.75,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,6.6,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.6,null,"YES",6.6,0,6.6,0,null,1,6.6,null,6.6,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.2},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA72*(1-W72),2)","v":6.2},null,"YES",6.2,{"$f":"+W72","v":0},{"$f":"+X72","v":6.2},{"$f":"(AG72-AC72)/AG72","v":0},null,3,{"$f":"SUM(AI72:AK72)+AE72","v":6.2},null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":6.2},{"$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",6.8,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.8,null,"YES",6.8,0,6.8,0,null,3,6.8,null,6.8,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.7,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA75*(1-W75),2)","v":21.7},null,"YES",21.7,{"$f":"+W75","v":0},{"$f":"+X75","v":21.7},{"$f":"(AG75-AC75)/AG75","v":0},null,3,{"$f":"SUM(AI75:AK75)+AE75","v":21.7},null,21.7,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,27.35,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},27.35,null,"YES",27.35,0,27.35,0,null,3,27.35,null,27.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.35},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA78*(1-W78),2)","v":13.35},null,"YES",13.35,{"$f":"+W78","v":0},{"$f":"+X78","v":13.35},{"$f":"(AG78-AC78)/AG78","v":0},null,2,{"$f":"SUM(AI78:AK78)+AE78","v":13.35},null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":13.35},{"$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,null,"24\" x 24\" x 20mm",null,"Field",null,null,"Anti-Slip",null,null,null,null,null,"8.03 SF/CTN",null,"b",10.75,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA80*(1-W80),2)","v":10.75},null,"YES",10.75,{"$f":"+W80","v":0},{"$f":"+X80","v":10.75},{"$f":"(AG80-AC80)/AG80","v":0},null,1,{"$f":"SUM(AI80:AK80)+AE80","v":10.75},null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":10.75},{"$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,"b) No antimicrobial protection.",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",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.4},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA88*(1-W88),2)","v":6.4},null,"YES",6.4,{"$f":"+W88","v":0},{"$f":"+X88","v":6.4},{"$f":"(AG88-AC88)/AG88","v":0},null,1,{"$f":"SUM(AI88:AK88)+AE88","v":6.4},null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":6.4},{"$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":27.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA90*(1-W90),2)","v":27.35},null,"YES",27.35,{"$f":"+W90","v":0},{"$f":"+X90","v":27.35},{"$f":"(AG90-AC90)/AG90","v":0},null,3,{"$f":"SUM(AI90:AK90)+AE90","v":27.35},null,{"$f":"ROUND(AC90/(1-VLOOKUP(AF90,Group,2,FALSE)),2)","v":27.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,"LUXE ENSEMBLE - Colored-Body Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNLU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Camouflage          Quartzite          St. Denis*          Statuario          Taj Mahal",null,null,null,null,null,null,null,null,null,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,"15.62 SF/CTN","Stock",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,"new",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,"Field Tile",null,null,"36\" x 36\"",null,"Field",null,null,null,null,null,null,null,null,"17.40 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA97,AG97)","v":7.8},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA97*(1-W97),2)","v":7.8},null,"new",7.8,{"$f":"+W97","v":0},{"$f":"+X97","v":7.8},{"$f":"(AG97-AC97)/AG97","v":0},null,1,{"$f":"SUM(AI97:AK97)+AE97","v":7.8},null,{"$f":"ROUND(AC97/(1-VLOOKUP(AF97,Group,2,FALSE)),2)","v":7.8},{"$f":"IF(VLOOKUP(AF97,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI97,1)-AI97,2),Round,2,FALSE)+VLOOKUP(AF97,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",0,ROUND(AI97-0.04999,1)-AI97+AL97)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF97,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.39 SF/CTN","Stock",null,6.65,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.65,null,"new",6.65,0,6.65,0,null,1,6.65,null,6.65,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA100,AG100)","v":24.2},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA100*(1-W100),2)","v":24.2},null,"YES",24.2,{"$f":"+W100","v":0},{"$f":"+X100","v":24.2},{"$f":"(AG100-AC100)/AG100","v":0},null,3,{"$f":"SUM(AI100:AK100)+AE100","v":24.2},null,{"$f":"ROUND(AC100/(1-VLOOKUP(AF100,Group,2,FALSE)),2)","v":24.2},{"$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,"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\",AA102,AG102)","v":14.8},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA102*(1-W102),2)","v":14.8},null,"YES",14.8,{"$f":"+W102","v":0},{"$f":"+X102","v":14.8},{"$f":"(AG102-AC102)/AG102","v":0},null,2,{"$f":"SUM(AI102:AK102)+AE102","v":14.8},null,{"$f":"ROUND(AC102/(1-VLOOKUP(AF102,Group,2,FALSE)),2)","v":14.8},{"$f":"IF(VLOOKUP(AF102,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI102,1)-AI102,2),Round,2,FALSE)+VLOOKUP(AF102,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",0,ROUND(AI102-0.04999,1)-AI102+AL102)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF102,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile",null,"Lux:","12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA104,AG104)","v":7.95},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA104*(1-W104),2)","v":7.95},null,"new",7.95,{"$f":"+W104","v":0},{"$f":"+X104","v":7.95},{"$f":"(AG104-AC104)/AG104","v":0},null,1,{"$f":"SUM(AI104:AK104)+AE104","v":7.95},null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":7.95},{"$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,"36\" x 36\"",null,"Field",null,null,null,null,null,null,null,null,"17.40 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA105,AG105)","v":9.25},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA105*(1-W105),2)","v":9.25},null,"new",9.25,{"$f":"+W105","v":0},{"$f":"+X105","v":9.25},{"$f":"(AG105-AC105)/AG105","v":0},null,1,{"$f":"SUM(AI105:AK105)+AE105","v":9.25},null,{"$f":"ROUND(AC105/(1-VLOOKUP(AF105,Group,2,FALSE)),2)","v":9.25},{"$f":"IF(VLOOKUP(AF105,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI105,1)-AI105,2),Round,2,FALSE)+VLOOKUP(AF105,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",0,ROUND(AI105-0.04999,1)-AI105+AL105)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF105,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.39 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA106,AG106)","v":8.6},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA106*(1-W106),2)","v":8.6},null,"new",8.6,{"$f":"+W106","v":0},{"$f":"+X106","v":8.6},{"$f":"(AG106-AC106)/AG106","v":0},null,1,{"$f":"SUM(AI106:AK106)+AE106","v":8.6},null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":8.6},{"$f":"IF(VLOOKUP(AF106,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI106,1)-AI106,2),Round,2,FALSE)+VLOOKUP(AF106,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",0,ROUND(AI106-0.04999,1)-AI106+AL106)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF106,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,"Lux:","10\" x 15\"",null,"Mosaic","Diamond - Solid",null,null,null,null,"1.05 sf/sheet",null,null,"5.40 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA108,AG108)","v":50.75},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA108*(1-W108),2)","v":50.75},null,"new",50.75,{"$f":"+W108","v":0},{"$f":"+X108","v":50.75},{"$f":"(AG108-AC108)/AG108","v":0},null,3,{"$f":"SUM(AI108:AK108)+AE108","v":50.75},null,{"$f":"ROUND(AC108/(1-VLOOKUP(AF108,Group,2,FALSE)),2)","v":50.75},{"$f":"IF(VLOOKUP(AF108,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI108,1)-AI108,2),Round,2,FALSE)+VLOOKUP(AF108,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",0,ROUND(AI108-0.04999,1)-AI108+AL108)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF108,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"10\" x 15\"",null,"Mosaic","Diamond Mix (Color Mix of Statuario and St. Denis)    1.05 sf/sheet",null,null,null,null,null,null,null,"5.40 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA109,AG109)","v":50.75},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA109*(1-W109),2)","v":50.75},null,"new",50.75,{"$f":"+W109","v":0},{"$f":"+X109","v":50.75},{"$f":"(AG109-AC109)/AG109","v":0},null,3,{"$f":"SUM(AI109:AK109)+AE109","v":50.75},null,{"$f":"ROUND(AC109/(1-VLOOKUP(AF109,Group,2,FALSE)),2)","v":50.75},{"$f":"IF(VLOOKUP(AF109,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI109,1)-AI109,2),Round,2,FALSE)+VLOOKUP(AF109,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF109,Group,7,FALSE)=\"\",0,ROUND(AI109-0.04999,1)-AI109+AL109)","v":0},{"$f":"IF(VLOOKUP(AF109,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF109,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"7\" x 14\"",null,"Mosaic","Ingot Mix (Color Mix of Statuario, Taj Mahal, and St. Denis) 0.85 sf/sheet",null,null,null,null,null,null,null,"4.25 SF/CTN",null,null,54,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},54,null,"new",54,0,54,0,null,3,54,null,54,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\",AA112,AG112)","v":18.3},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA112*(1-W112),2)","v":18.3},null,"YES",18.3,{"$f":"+W112","v":0},{"$f":"+X112","v":18.3},{"$f":"(AG112-AC112)/AG112","v":0},null,2,{"$f":"SUM(AI112:AK112)+AE112","v":18.3},null,{"$f":"ROUND(AC112/(1-VLOOKUP(AF112,Group,2,FALSE)),2)","v":18.3},{"$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,null," ","Note:","*Color St. Denis is manufactured using standard body, not colored-body.",null,null,null,null,null,null,null,null,null,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,"METROPOLITAN - Glazed Porcelain Floor & Wall 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\",AA120,AG120)","v":5.65},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA120*(1-W120),2)","v":5.65},null,"YES",5.65,{"$f":"+W120","v":0},{"$f":"+X120","v":5.65},{"$f":"(AG120-AC120)/AG120","v":0},null,1,{"$f":"SUM(AI120:AK120)+AE120","v":5.65},null,{"$f":"ROUND(AC120/(1-VLOOKUP(AF120,Group,2,FALSE)),2)","v":5.65},{"$f":"IF(VLOOKUP(AF120,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI120,1)-AI120,2),Round,2,FALSE)+VLOOKUP(AF120,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",0,ROUND(AI120-0.04999,1)-AI120+AL120)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF120,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\",AA122,AG122)","v":25.75},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA122*(1-W122),2)","v":25.75},null,"YES",25.75,{"$f":"+W122","v":0},{"$f":"+X122","v":25.75},{"$f":"(AG122-AC122)/AG122","v":0},null,3,{"$f":"SUM(AI122:AK122)+AE122","v":25.75},null,{"$f":"ROUND(AC122/(1-VLOOKUP(AF122,Group,2,FALSE)),2)","v":25.75},{"$f":"IF(VLOOKUP(AF122,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI122,1)-AI122,2),Round,2,FALSE)+VLOOKUP(AF122,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,7,FALSE)=\"\",0,ROUND(AI122-0.04999,1)-AI122+AL122)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF122,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\",AA124,AG124)","v":7.4},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA124*(1-W124),2)","v":7.4},null,"YES",7.4,{"$f":"+W124","v":0},{"$f":"+X124","v":7.4},{"$f":"(AG124-AC124)/AG124","v":0},null,2,{"$f":"SUM(AI124:AK124)+AE124","v":7.4},null,{"$f":"ROUND(AC124/(1-VLOOKUP(AF124,Group,2,FALSE)),2)","v":7.4},{"$f":"IF(VLOOKUP(AF124,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI124,1)-AI124,2),Round,2,FALSE)+VLOOKUP(AF124,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",0,ROUND(AI124-0.04999,1)-AI124+AL124)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF124,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\",AA128,AG128)","v":6.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA128*(1-W128),2)","v":6.35},null,"YES",6.35,{"$f":"+W128","v":0},{"$f":"+X128","v":6.35},{"$f":"(AG128-AC128)/AG128","v":0},null,1,{"$f":"SUM(AI128:AK128)+AE128","v":6.35},null,{"$f":"ROUND(AC128/(1-VLOOKUP(AF128,Group,2,FALSE)),2)","v":6.35},{"$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,null,"MOONDANCE - Colored-Body Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNMD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Beige          Dark Gray          Gray          Taupe          White",null,null,null,null,null,null," "," ",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA134,AG134)","v":5.95},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA134*(1-W134),2)","v":5.95},null,"YES",5.95,{"$f":"+W134","v":0},{"$f":"+X134","v":5.95},{"$f":"(AG134-AC134)/AG134","v":0},null,1,{"$f":"SUM(AI134:AK134)+AE134","v":5.95},null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":5.95},{"$f":"IF(VLOOKUP(AF134,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI134,1)-AI134,2),Round,2,FALSE)+VLOOKUP(AF134,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",0,ROUND(AI134-0.04999,1)-AI134+AL134)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF134,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"36\" x 36\"",null,"Field",null,null,null,null,null,null,null,null,"17.40 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA135,AG135)","v":8.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA135*(1-W135),2)","v":8.35},null,"YES",8.35,{"$f":"+W135","v":0},{"$f":"+X135","v":8.35},{"$f":"(AG135-AC135)/AG135","v":0},null,1,{"$f":"SUM(AI135:AK135)+AE135","v":8.35},null,{"$f":"ROUND(AC135/(1-VLOOKUP(AF135,Group,2,FALSE)),2)","v":8.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,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.39 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA136,AG136)","v":7.95},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA136*(1-W136),2)","v":7.95},null,"YES",7.95,{"$f":"+W136","v":0},{"$f":"+X136","v":7.95},{"$f":"(AG136-AC136)/AG136","v":0},null,1,{"$f":"SUM(AI136:AK136)+AE136","v":7.95},null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":7.95},{"$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,"Decos",null,null,"12\" x 14\"",null,"Mosaic",null,"Trapezoid",null,null,null,"1.12 sf/sheet",null,null,"5.60 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA138,AG138)","v":45.5},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA138*(1-W138),2)","v":45.5},null,"YES",45.5,{"$f":"+W138","v":0},{"$f":"+X138","v":45.5},{"$f":"(AG138-AC138)/AG138","v":0},null,3,{"$f":"SUM(AI138:AK138)+AE138","v":45.5},null,{"$f":"ROUND(AC138/(1-VLOOKUP(AF138,Group,2,FALSE)),2)","v":45.5},{"$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,"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\",AA140,AG140)","v":14.8},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA140*(1-W140),2)","v":14.8},null,"YES",14.8,{"$f":"+W140","v":0},{"$f":"+X140","v":14.8},{"$f":"(AG140-AC140)/AG140","v":0},null,2,{"$f":"SUM(AI140:AK140)+AE140","v":14.8},null,{"$f":"ROUND(AC140/(1-VLOOKUP(AF140,Group,2,FALSE)),2)","v":14.8},{"$f":"IF(VLOOKUP(AF140,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI140,1)-AI140,2),Round,2,FALSE)+VLOOKUP(AF140,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",0,ROUND(AI140-0.04999,1)-AI140+AL140)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF140,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile",null,null,"24\" x 48\" x 20mm",null,"Field - Rectified",null,null,"Anti-Slip",null,null,null,null,null,"7.65 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA142,AG142)","v":11.95},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA142*(1-W142),2)","v":11.95},null,"YES",11.95,{"$f":"+W142","v":0},{"$f":"+X142","v":11.95},{"$f":"(AG142-AC142)/AG142","v":0},null,1,{"$f":"SUM(AI142:AK142)+AE142","v":11.95},null,{"$f":"ROUND(AC142/(1-VLOOKUP(AF142,Group,2,FALSE)),2)","v":11.95},{"$f":"IF(VLOOKUP(AF142,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI142,1)-AI142,2),Round,2,FALSE)+VLOOKUP(AF142,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF142,Group,7,FALSE)=\"\",0,ROUND(AI142-0.04999,1)-AI142+AL142)","v":0},{"$f":"IF(VLOOKUP(AF142,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF142,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\",AA151,AG151)","v":9.5500000000000007},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA151*(1-W151),2)","v":9.5500000000000007},null,"",9.5500000000000007,{"$f":"+W151","v":0},{"$f":"+X151","v":9.5500000000000007},{"$f":"(AG151-AC151)/AG151","v":0},null,1,{"$f":"SUM(AI151:AK151)+AE151","v":9.5500000000000007},null,{"$f":"ROUND(AC151/(1-VLOOKUP(AF151,Group,2,FALSE)),2)","v":9.5500000000000007},{"$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,"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\",AA152,AG152)","v":9.35},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA152*(1-W152),2)","v":9.35},null,"",9.35,{"$f":"+W152","v":0},{"$f":"+X152","v":9.35},{"$f":"(AG152-AC152)/AG152","v":0},null,1,{"$f":"SUM(AI152:AK152)+AE152","v":9.35},null,{"$f":"ROUND(AC152/(1-VLOOKUP(AF152,Group,2,FALSE)),2)","v":9.35},{"$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,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\",AA156,AG156)","v":9.9},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA156*(1-W156),2)","v":9.9},null,"",9.9,{"$f":"+W156","v":0},{"$f":"+X156","v":9.9},{"$f":"(AG156-AC156)/AG156","v":0},null,3,{"$f":"SUM(AI156:AK156)+AE156","v":9.9},null,{"$f":"ROUND(AC156/(1-VLOOKUP(AF156,Group,2,FALSE)),2)","v":9.9},{"$f":"IF(VLOOKUP(AF156,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI156,1)-AI156,2),Round,2,FALSE)+VLOOKUP(AF156,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",0,ROUND(AI156-0.04999,1)-AI156+AL156)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF156,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\",AA166,AG166)","v":4.9000000000000004},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA166*(1-W166),2)","v":4.9000000000000004},null,"YES",4.9000000000000004,{"$f":"+W166","v":0},{"$f":"+X166","v":4.9000000000000004},{"$f":"(AG166-AC166)/AG166","v":0},null,1,{"$f":"SUM(AI166:AK166)+AE166","v":4.9000000000000004},null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":4.9000000000000004},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI166,1)-AI166,2),Round,2,FALSE)+VLOOKUP(AF166,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",0,ROUND(AI166-0.04999,1)-AI166+AL166)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF166,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,22.3,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},22.3,null,"YES",22.3,0,22.3,0,null,3,22.3,null,22.3,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\",AA170,AG170)","v":14.05},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA170*(1-W170),2)","v":14.05},null,"YES",14.05,{"$f":"+W170","v":0},{"$f":"+X170","v":14.05},{"$f":"(AG170-AC170)/AG170","v":0},null,2,{"$f":"SUM(AI170:AK170)+AE170","v":14.05},null,{"$f":"ROUND(AC170/(1-VLOOKUP(AF170,Group,2,FALSE)),2)","v":14.05},{"$f":"IF(VLOOKUP(AF170,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI170,1)-AI170,2),Round,2,FALSE)+VLOOKUP(AF170,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",0,ROUND(AI170-0.04999,1)-AI170+AL170)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF170,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\",AA176,AG176)","v":6.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA176*(1-W176),2)","v":6.15},null,"YES",6.15,{"$f":"+W176","v":0},{"$f":"+X176","v":6.15},{"$f":"(AG176-AC176)/AG176","v":0},null,1,{"$f":"SUM(AI176:AK176)+AE176","v":6.15},null,{"$f":"ROUND(AC176/(1-VLOOKUP(AF176,Group,2,FALSE)),2)","v":6.15},{"$f":"IF(VLOOKUP(AF176,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI176,1)-AI176,2),Round,2,FALSE)+VLOOKUP(AF176,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF176,Group,7,FALSE)=\"\",0,ROUND(AI176-0.04999,1)-AI176+AL176)","v":0},{"$f":"IF(VLOOKUP(AF176,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF176,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","Stock","a,b",6.95,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.95,null,"YES",6.95,0,6.95,0,null,1,6.95,null,6.95,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\",AA179,AG179)","v":22.2},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA179*(1-W179),2)","v":22.2},null,"YES",22.2,{"$f":"+W179","v":0},{"$f":"+X179","v":22.2},{"$f":"(AG179-AC179)/AG179","v":0},null,3,{"$f":"SUM(AI179:AK179)+AE179","v":22.2},null,{"$f":"ROUND(AC179/(1-VLOOKUP(AF179,Group,2,FALSE)),2)","v":22.2},{"$f":"IF(VLOOKUP(AF179,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI179,1)-AI179,2),Round,2,FALSE)+VLOOKUP(AF179,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",0,ROUND(AI179-0.04999,1)-AI179+AL179)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF179,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"4\" x 21\"",null,"Field - Rectified",null,"Chevron",null,null,null,".55 sf/piece",null,null,"4.40 SF/CTN",null,"c,d",{"$f":"IF(Suggested=\"Yes\",AA180,AG180)","v":44.15},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA180*(1-W180),2)","v":44.15},null,"YES",44.15,{"$f":"+W180","v":0},{"$f":"+X180","v":44.15},{"$f":"(AG180-AC180)/AG180","v":0},null,3,{"$f":"SUM(AI180:AK180)+AE180","v":44.15},null,{"$f":"ROUND(AC180/(1-VLOOKUP(AF180,Group,2,FALSE)),2)","v":44.15},{"$f":"IF(VLOOKUP(AF180,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI180,1)-AI180,2),Round,2,FALSE)+VLOOKUP(AF180,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF180,Group,7,FALSE)=\"\",0,ROUND(AI180-0.04999,1)-AI180+AL180)","v":0},{"$f":"IF(VLOOKUP(AF180,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF180,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,"16 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA182,AG182)","v":13.45},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA182*(1-W182),2)","v":13.45},null,"YES",13.45,{"$f":"+W182","v":0},{"$f":"+X182","v":13.45},{"$f":"(AG182-AC182)/AG182","v":0},null,2,{"$f":"SUM(AI182:AK182)+AE182","v":13.45},null,{"$f":"ROUND(AC182/(1-VLOOKUP(AF182,Group,2,FALSE)),2)","v":13.45},{"$f":"IF(VLOOKUP(AF182,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI182,1)-AI182,2),Round,2,FALSE)+VLOOKUP(AF182,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",0,ROUND(AI182-0.04999,1)-AI182+AL182)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF182,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","e",{"$f":"IF(Suggested=\"Yes\",AA184,AG184)","v":8.6},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA184*(1-W184),2)","v":8.6},null,"YES",8.6,{"$f":"+W184","v":0},{"$f":"+X184","v":8.6},{"$f":"(AG184-AC184)/AG184","v":0},null,1,{"$f":"SUM(AI184:AK184)+AE184","v":8.6},null,{"$f":"ROUND(AC184/(1-VLOOKUP(AF184,Group,2,FALSE)),2)","v":8.6},{"$f":"IF(VLOOKUP(AF184,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI184,1)-AI184,2),Round,2,FALSE)+VLOOKUP(AF184,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",0,ROUND(AI184-0.04999,1)-AI184+AL184)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF184,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","Stock","a,b",9.6,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},9.6,null,"YES",9.6,0,9.6,0,null,1,9.6,null,9.6,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,"f",{"$f":"IF(Suggested=\"Yes\",AA187,AG187)","v":25.45},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA187*(1-W187),2)","v":25.45},null,"YES",25.45,{"$f":"+W187","v":0},{"$f":"+X187","v":25.45},{"$f":"(AG187-AC187)/AG187","v":0},null,3,{"$f":"SUM(AI187:AK187)+AE187","v":25.45},null,{"$f":"ROUND(AC187/(1-VLOOKUP(AF187,Group,2,FALSE)),2)","v":25.45},{"$f":"IF(VLOOKUP(AF187,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI187,1)-AI187,2),Round,2,FALSE)+VLOOKUP(AF187,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",0,ROUND(AI187-0.04999,1)-AI187+AL187)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF187,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,"16 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA189,AG189)","v":15.4},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA189*(1-W189),2)","v":15.4},null,"YES",15.4,{"$f":"+W189","v":0},{"$f":"+X189","v":15.4},{"$f":"(AG189-AC189)/AG189","v":0},null,2,{"$f":"SUM(AI189:AK189)+AE189","v":15.4},null,{"$f":"ROUND(AC189/(1-VLOOKUP(AF189,Group,2,FALSE)),2)","v":15.4},{"$f":"IF(VLOOKUP(AF189,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI189,1)-AI189,2),Round,2,FALSE)+VLOOKUP(AF189,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",0,ROUND(AI189-0.04999,1)-AI189+AL189)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF189,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,null,"b) Stocked in color Calacatta Gold only"]
[null,null," ",null,"c) 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,"d) Packaging is changing from 4.40 SF/CTN to 5.50 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,"The new packaging of 5.50 SF/CTN will contain 5 right arrows and 5 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,"e) 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,"f) Packaging is changing from 3.88 SF/CTN to 4.84 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,"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\",AA203,AG203)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA203*(1-W203),2)","v":8.8000000000000007},null,"YES",8.8000000000000007,{"$f":"+W203","v":0},{"$f":"+X203","v":8.8000000000000007},{"$f":"(AG203-AC203)/AG203","v":0},null,1,{"$f":"SUM(AI203:AK203)+AE203","v":8.8000000000000007},null,{"$f":"ROUND(AC203/(1-VLOOKUP(AF203,Group,2,FALSE)),2)","v":8.8000000000000007},{"$f":"IF(VLOOKUP(AF203,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI203,1)-AI203,2),Round,2,FALSE)+VLOOKUP(AF203,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF203,Group,7,FALSE)=\"\",0,ROUND(AI203-0.04999,1)-AI203+AL203)","v":0},{"$f":"IF(VLOOKUP(AF203,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF203,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.2,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.2,null,"YES",6.2,0,6.2,0,null,1,6.2,null,6.2,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.3,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},6.3,null,"YES",6.3,0,6.3,0,null,1,6.3,null,6.3,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\",AA207,AG207)","v":24.05},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA207*(1-W207),2)","v":24.05},null,"YES",24.05,{"$f":"+W207","v":0},{"$f":"+X207","v":24.05},{"$f":"(AG207-AC207)/AG207","v":0},null,3,{"$f":"SUM(AI207:AK207)+AE207","v":24.05},null,{"$f":"ROUND(AC207/(1-VLOOKUP(AF207,Group,2,FALSE)),2)","v":24.05},{"$f":"IF(VLOOKUP(AF207,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI207,1)-AI207,2),Round,2,FALSE)+VLOOKUP(AF207,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF207,Group,7,FALSE)=\"\",0,ROUND(AI207-0.04999,1)-AI207+AL207)","v":0},{"$f":"IF(VLOOKUP(AF207,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF207,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\",AA209,AG209)","v":6.8},"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA209*(1-W209),2)","v":6.8},null,"YES",6.8,{"$f":"+W209","v":0},{"$f":"+X209","v":6.8},{"$f":"(AG209-AC209)/AG209","v":0},null,2,{"$f":"SUM(AI209:AK209)+AE209","v":6.8},null,{"$f":"ROUND(AC209/(1-VLOOKUP(AF209,Group,2,FALSE)),2)","v":6.8},{"$f":"IF(VLOOKUP(AF209,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI209,1)-AI209,2),Round,2,FALSE)+VLOOKUP(AF209,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,7,FALSE)=\"\",0,ROUND(AI209-0.04999,1)-AI209+AL209)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF209,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,"TERRAZZO - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","PNTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,null,null,"Colors:","Grey          Smoke          Tortora          White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"X"]
[]
[null,"Field Tile",null,null,"36\" x 36\"",null,"Field - Rectified",null,null,null,null,null,null,null,null,"17.44 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA218,AG218)","v":9.25},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA218*(1-W218),2)","v":9.25},null,"",9.25,{"$f":"+W218","v":0},{"$f":"+X218","v":9.25},{"$f":"(AG218-AC218)/AG218","v":0},null,1,{"$f":"SUM(AI218:AK218)+AE218","v":9.25},null,{"$f":"ROUND(AC218/(1-VLOOKUP(AF218,Group,2,FALSE)),2)","v":9.25},{"$f":"IF(VLOOKUP(AF218,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI218,1)-AI218,2),Round,2,FALSE)+VLOOKUP(AF218,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",0,ROUND(AI218-0.04999,1)-AI218+AL218)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF218,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,{"$f":"IF(Suggested=\"Yes\",AA219,AG219)","v":8.6999999999999993},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA219*(1-W219),2)","v":8.6999999999999993},null,"",8.6999999999999993,{"$f":"+W219","v":0},{"$f":"+X219","v":8.6999999999999993},{"$f":"(AG219-AC219)/AG219","v":0},null,1,{"$f":"SUM(AI219:AK219)+AE219","v":8.6999999999999993},null,{"$f":"ROUND(AC219/(1-VLOOKUP(AF219,Group,2,FALSE)),2)","v":8.6999999999999993},{"$f":"IF(VLOOKUP(AF219,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI219,1)-AI219,2),Round,2,FALSE)+VLOOKUP(AF219,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF219,Group,7,FALSE)=\"\",0,ROUND(AI219-0.04999,1)-AI219+AL219)","v":0},{"$f":"IF(VLOOKUP(AF219,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF219,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,"4.85 SF/CTN",null,null,29.65,"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},29.65,null,"",29.65,0,29.65,0,null,3,29.65,null,29.65,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,15.95,"EA",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},15.95,null,"",15.95,0,15.95,0,null,2,15.95,null,15.95,0,0,"",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\",AA229,AG229)","v":6.4},"SF",{"$f":"+Instructions!$B$21","v":"G"},null,{"$f":"+Instructions!$C$21","v":0},{"$f":"ROUNDUP($AA229*(1-W229),2)","v":6.4},null,"YES",6.4,{"$f":"+W229","v":0},{"$f":"+X229","v":6.4},{"$f":"(AG229-AC229)/AG229","v":0},null,1,{"$f":"SUM(AI229:AK229)+AE229","v":6.4},null,{"$f":"ROUND(AC229/(1-VLOOKUP(AF229,Group,2,FALSE)),2)","v":6.4},{"$f":"IF(VLOOKUP(AF229,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AI229,1)-AI229,2),Round,2,FALSE)+VLOOKUP(AF229,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",0,ROUND(AI229-0.04999,1)-AI229+AL229)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF229,Group,7,FALSE))","v":""},null,"X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists.",null,null,null,null,null,null,null,null,null,null,null,null,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":22,"n_cols":10,"rows_kept":22,"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"]
["Luxe Ensemble"]
["Metropolitan","https://www.panaria.us/collection/metropolitan"]
["Moonstone"]
["Playlist","https://www.panaria.us/collection/playlist"]
["Playlist+","https://www.panaria.us/collection/playlistplus"]
["Prestige","https://www.panaria.us/collection/prestige"]
["Suite","https://www.panaria.us/collection/suite"]
["Terrazzo","https://www.panaria.us/collection/terrazzo"]
["Wood Trend","https://www.panaria.us/collection/wood-trend"]

{"sheet":"Changes","index":4,"n_rows":37,"n_cols":3,"rows_kept":37,"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"]
["2025-05-01","Terrazzo","Glazed Porcelain"]
["2025-06-26","Luxe Ensemble","Color-Body Glazed Porcelain"]
["2025-06-26","Moondance","Color-Body 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," "]