{"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":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Metropolitan"]
["File as","M"]
["Product Code","D"]
["CCTD Effective Date","8/1/24"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"D"}]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0]
[null,2,null,"Trim",null,"No",0]
[null,3,null,"Decos",null,"No",0]
[null,4,null,0,null,"No",0]
[null,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":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,0,5,10],[48,0,48,10],[50,0,50,10],[2,5,2,10]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'M' - Metropolitan"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 8/1/24"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[1,null,"Down To Earth"]
[1,null,"Metrobrick"]
[1,null,"Metro Tread"]
["1-2",null,"Quarry Basics"]
[3,null,"Royal Thin Brick"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":284,"n_cols":41,"rows_kept":284,"cut":false,"hidden":false,"merged":[[9,14,9,19],[12,22,12,23],[13,30,13,32],[9,25,9,32],[9,22,9,23],[270,2,270,19],[10,14,10,15],[12,14,12,19],[273,3,273,4],[268,2,268,19],[18,2,18,19],[17,14,17,15],[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$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA1*(1-W1)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W1","v":0},0.05,{"$f":"(AG1-AC1)/AG1","v":0},null,1,{"$f":"SUM(AJ1:AL1)+AE1","v":0.05},null,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(AJ1,1)-AJ1,2),Round,2,FALSE)+VLOOKUP(AF1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",0,ROUND(AJ1-0.04999,1)-AJ1+AM1)","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,{"$f":"IF(Suggested=\"Yes\",AA2,AG2)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,2,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,3,0,null,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",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,4,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,5,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,6,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,7,0,null,null,0,0,0,"",null,"X"]
[null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","a",1000,"ABC",null,null,0.1,1000,null,"ABC",1000,0.1,1000,0.1,10,null,1000,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'M' - Metropolitan"},null,null,null,null,null,null,null,"Cost",null,null,null,null,null,null,null,null,null,"Retail Price Calculations",null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Instructions!B4","v":"8/1/24"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-06-28"},null,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!C8=\"\",\"\",+Instructions!C8)","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,null,"X"]
[null,null,{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code 'D'"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$C$8=\"\",\"\",Instructions!$C$8)","v":""},null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,null,"X"]
[null,null,"DOWN TO EARTH",null,null,null," ",null," ",null," "," ",null,null,null,null,null,"Item # Lookup:","MTDO",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,null,"X"]
[null,null,null,"Colors:","155 Cobblestone          255 Desert Floor          350 Red Paver          458 Bedrock",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"4\" x 8\" x 1/2\"",null,"Field",null,null,null,"Velour Texture",null,null,null,null,"7.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA25,AG25)","v":8.5500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA25*(1-W25)+0.004999,2)","v":8.5500000000000007},null,"YES",8.5500000000000007,{"$f":"+W25","v":0},{"$f":"+X25","v":8.5500000000000007},{"$f":"(AG25-AC25)/AG25","v":0},null,1,{"$f":"SUM(AJ25:AL25)+AE25","v":8.5500000000000007},null,null,{"$f":"ROUND(AC25/(1-VLOOKUP(AF25,Group,2,FALSE)),2)","v":8.5500000000000007},{"$f":"IF(VLOOKUP(AF25,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ25,1)-AJ25,2),Round,2,FALSE)+VLOOKUP(AF25,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF25,Group,7,FALSE)=\"\",0,ROUND(AJ25-0.04999,1)-AJ25+AM25)","v":0},{"$f":"IF(VLOOKUP(AF25,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF25,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,null,"X"]
[null,null,null,"Notes:","Trim is not available.  Use corresponding QuarryBasics Trim.  Trim colors to use:  for 155 Cobblestone, 255 Desert 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,"X"]
[null,null,null,null,"and 350 Red Paver use complementary color, and for 458 Bedrock use 108 Chestnut Brown.",null,null,null,null,null,null,null,null,null,null,null,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,"Recycled Content (Pre-consumer):  155 Cobblestone 23%, 255 Desert Floor 19%, 350 Red Paver 18% and 458 Bedrock 23%.",null,null,null,null,null,null,null,null,null,null,null,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,"(Percentages based on most current data.)",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,null,"METROBRICK",null,null,null,null,null,null,null," ",null,null,null,null,null,null,"Item # Lookup:","MTMB",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,null,"X"]
[null,null,null,"Colors:","105 Fieldstone",null,"       350 Main Street Flashed",null,null,null,"          507 Empire",null,null,null,null,null,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,"310 Main Street",null,"       458 Brownstone Flashed",null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"2-1/4\" x 7-5/8\" x 5/8\"",null,"Field",null,null,null,"Wire Cut Finish",null,null,null,null,"7.58 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA37,AG37)","v":12.9},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":12.9},null,"YES",12.9,{"$f":"+W37","v":0},{"$f":"+X37","v":12.9},{"$f":"(AG37-AC37)/AG37","v":0},null,1,{"$f":"SUM(AJ37:AL37)+AE37","v":12.9},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":12.9},{"$f":"IF(VLOOKUP(AF37,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ37,1)-AJ37,2),Round,2,FALSE)+VLOOKUP(AF37,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",0,ROUND(AJ37-0.04999,1)-AJ37+AM37)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF37,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,null,"X"]
[null,"Trim",null,null,"2-1/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"90° Corner",null,null,null,"Wire Cut Finish",null,null,null,null,"24 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA39,AG39)","v":6.5},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA39*(1-W39)+0.004999,2)","v":6.5},null,"YES",6.5,{"$f":"+W39","v":0},{"$f":"+X39","v":6.5},{"$f":"(AG39-AC39)/AG39","v":0},null,2,{"$f":"SUM(AJ39:AL39)+AE39","v":6.5},null,null,{"$f":"ROUND(AC39/(1-VLOOKUP(AF39,Group,2,FALSE)),2)","v":6.5},{"$f":"IF(VLOOKUP(AF39,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ39,1)-AJ39,2),Round,2,FALSE)+VLOOKUP(AF39,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF39,Group,7,FALSE)=\"\",0,ROUND(AJ39-0.04999,1)-AJ39+AM39)","v":0},{"$f":"IF(VLOOKUP(AF39,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF39,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"2-1/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"Edge Cap",null,null,null,"Wire Cut Finish",null,null,null,null,"10 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA40,AG40)","v":16.75},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA40*(1-W40)+0.004999,2)","v":16.75},null,"YES",16.75,{"$f":"+W40","v":0},{"$f":"+X40","v":16.75},{"$f":"(AG40-AC40)/AG40","v":0},null,2,{"$f":"SUM(AJ40:AL40)+AE40","v":16.75},null,null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":16.75},{"$f":"IF(VLOOKUP(AF40,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ40,1)-AJ40,2),Round,2,FALSE)+VLOOKUP(AF40,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,7,FALSE)=\"\",0,ROUND(AJ40-0.04999,1)-AJ40+AM40)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF40,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,null,"X"]
[null,null,null,"Colors:","320 Schoolhouse Red          365 Schoolhouse Red Flashed          505 Monument",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"2-1/4\" x 7-5/8\" x 5/8\"",null,"Field",null,null,null,"Smooth Finish or Wire Cut Finish",null,null,null,null,"7.58 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA44,AG44)","v":12.9},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA44*(1-W44)+0.004999,2)","v":12.9},null,"YES",12.9,{"$f":"+W44","v":0},{"$f":"+X44","v":12.9},{"$f":"(AG44-AC44)/AG44","v":0},null,1,{"$f":"SUM(AJ44:AL44)+AE44","v":12.9},null,null,{"$f":"ROUND(AC44/(1-VLOOKUP(AF44,Group,2,FALSE)),2)","v":12.9},{"$f":"IF(VLOOKUP(AF44,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ44,1)-AJ44,2),Round,2,FALSE)+VLOOKUP(AF44,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",0,ROUND(AJ44-0.04999,1)-AJ44+AM44)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF44,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,null,"X"]
[null,"Trim",null,null,"2-1/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"90° Corner",null,null,null,"Smooth Finish or Wire Cut Finish",null,null,null,null,"24 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA46,AG46)","v":6.5},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA46*(1-W46)+0.004999,2)","v":6.5},null,"YES",6.5,{"$f":"+W46","v":0},{"$f":"+X46","v":6.5},{"$f":"(AG46-AC46)/AG46","v":0},null,2,{"$f":"SUM(AJ46:AL46)+AE46","v":6.5},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":6.5},{"$f":"IF(VLOOKUP(AF46,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ46,1)-AJ46,2),Round,2,FALSE)+VLOOKUP(AF46,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",0,ROUND(AJ46-0.04999,1)-AJ46+AM46)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF46,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"2-1/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"Edge Cap",null,null,null,"Smooth Finish or Wire Cut Finish",null,null,null,null,"10 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA47,AG47)","v":16.75},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA47*(1-W47)+0.004999,2)","v":16.75},null,"YES",16.75,{"$f":"+W47","v":0},{"$f":"+X47","v":16.75},{"$f":"(AG47-AC47)/AG47","v":0},null,2,{"$f":"SUM(AJ47:AL47)+AE47","v":16.75},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":16.75},{"$f":"IF(VLOOKUP(AF47,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ47,1)-AJ47,2),Round,2,FALSE)+VLOOKUP(AF47,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF47,Group,7,FALSE)=\"\",0,ROUND(AJ47-0.04999,1)-AJ47+AM47)","v":0},{"$f":"IF(VLOOKUP(AF47,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF47,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,null,"X"]
[null,null,null,"Color:","710 Charcoal",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"2-1/4\" x 7-5/8\" x 5/8\"",null,"Field",null,null,null,"Smooth or Wire Cut Finish",null,null,null,null,"7.58 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA51,AG51)","v":15.5},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA51*(1-W51)+0.004999,2)","v":15.5},null,"YES",15.5,{"$f":"+W51","v":0},{"$f":"+X51","v":15.5},{"$f":"(AG51-AC51)/AG51","v":0},null,1,{"$f":"SUM(AJ51:AL51)+AE51","v":15.5},null,null,{"$f":"ROUND(AC51/(1-VLOOKUP(AF51,Group,2,FALSE)),2)","v":15.5},{"$f":"IF(VLOOKUP(AF51,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ51,1)-AJ51,2),Round,2,FALSE)+VLOOKUP(AF51,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF51,Group,7,FALSE)=\"\",0,ROUND(AJ51-0.04999,1)-AJ51+AM51)","v":0},{"$f":"IF(VLOOKUP(AF51,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF51,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,null,"X"]
[null,"Trim",null,null,"2-1/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"90° Corner",null,null,null,"Smooth or Wire Cut Finish",null,null,null,null,"24 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA53,AG53)","v":7.95},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA53*(1-W53)+0.004999,2)","v":7.95},null,"YES",7.95,{"$f":"+W53","v":0},{"$f":"+X53","v":7.95},{"$f":"(AG53-AC53)/AG53","v":0},null,2,{"$f":"SUM(AJ53:AL53)+AE53","v":7.95},null,null,{"$f":"ROUND(AC53/(1-VLOOKUP(AF53,Group,2,FALSE)),2)","v":7.95},{"$f":"IF(VLOOKUP(AF53,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ53,1)-AJ53,2),Round,2,FALSE)+VLOOKUP(AF53,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",0,ROUND(AJ53-0.04999,1)-AJ53+AM53)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF53,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,null,"X"]
[null,null,null,"Colors:","Fast Ship Blend 1          Fast Ship Blend 3          Fast Ship Blend 5          Fast Ship Blend 7",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"2-1/4\" x 7-5/8\" x 5/8\"",null,"Field",null,null,null,"Wire Cut Finish",null,null,null,null,"7.58 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA57,AG57)","v":16.05},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA57*(1-W57)+0.004999,2)","v":16.05},null,"YES",16.05,{"$f":"+W57","v":0},{"$f":"+X57","v":16.05},{"$f":"(AG57-AC57)/AG57","v":0},null,1,{"$f":"SUM(AJ57:AL57)+AE57","v":16.05},null,null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":16.05},{"$f":"IF(VLOOKUP(AF57,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ57,1)-AJ57,2),Round,2,FALSE)+VLOOKUP(AF57,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",0,ROUND(AJ57-0.04999,1)-AJ57+AM57)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF57,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,null,"X"]
[null,"Trim",null,null,"2-1/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"90° Corner",null,null,null,"Wire Cut Finish",null,null,null,null,"24 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA59,AG59)","v":8.1999999999999993},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA59*(1-W59)+0.004999,2)","v":8.1999999999999993},null,"YES",8.1999999999999993,{"$f":"+W59","v":0},{"$f":"+X59","v":8.1999999999999993},{"$f":"(AG59-AC59)/AG59","v":0},null,2,{"$f":"SUM(AJ59:AL59)+AE59","v":8.1999999999999993},null,null,{"$f":"ROUND(AC59/(1-VLOOKUP(AF59,Group,2,FALSE)),2)","v":8.1999999999999993},{"$f":"IF(VLOOKUP(AF59,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ59,1)-AJ59,2),Round,2,FALSE)+VLOOKUP(AF59,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",0,ROUND(AJ59-0.04999,1)-AJ59+AM59)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF59,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,null,"X"]
[null,null,null,"Colors:","Fast Ship Blend 2          Fast Ship Blend 4          Fast Ship Blend 6",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"2-1/4\" x 7-5/8\" x 5/8\"",null,"Field",null,null,null,"Wire Cut Finish",null,null,null,null,"7.58 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA63,AG63)","v":15.7},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA63*(1-W63)+0.004999,2)","v":15.7},null,"YES",15.7,{"$f":"+W63","v":0},{"$f":"+X63","v":15.7},{"$f":"(AG63-AC63)/AG63","v":0},null,1,{"$f":"SUM(AJ63:AL63)+AE63","v":15.7},null,null,{"$f":"ROUND(AC63/(1-VLOOKUP(AF63,Group,2,FALSE)),2)","v":15.7},{"$f":"IF(VLOOKUP(AF63,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ63,1)-AJ63,2),Round,2,FALSE)+VLOOKUP(AF63,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF63,Group,7,FALSE)=\"\",0,ROUND(AJ63-0.04999,1)-AJ63+AM63)","v":0},{"$f":"IF(VLOOKUP(AF63,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF63,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,null,"X"]
[null,"Trim",null,null,"2-1/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"90° Corner",null,null,null,"Wire Cut Finish",null,null,null,null,"24 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":8},null,"YES",8,{"$f":"+W65","v":0},{"$f":"+X65","v":8},{"$f":"(AG65-AC65)/AG65","v":0},null,2,{"$f":"SUM(AJ65:AL65)+AE65","v":8},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":8},{"$f":"IF(VLOOKUP(AF65,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ65,1)-AJ65,2),Round,2,FALSE)+VLOOKUP(AF65,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",0,ROUND(AJ65-0.04999,1)-AJ65+AM65)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF65,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,null,"X"]
[null,null,null,"Additional Wax Option Charges:",null,null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"2-1/4\" x 7-5/8\" x 5/8\"",null,"Field - Waxed",null,null,null,"Wire Cut Finish",null,null,null,null,"7.58 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA69,AG69)","v":1.9},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA69*(1-W69)+0.004999,2)","v":1.9},null,"YES",1.9,{"$f":"+W69","v":0},{"$f":"+X69","v":1.9},{"$f":"(AG69-AC69)/AG69","v":0},null,1,{"$f":"SUM(AJ69:AL69)+AE69","v":1.9},null,null,{"$f":"ROUND(AC69/(1-VLOOKUP(AF69,Group,2,FALSE)),2)","v":1.9},{"$f":"IF(VLOOKUP(AF69,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ69,1)-AJ69,2),Round,2,FALSE)+VLOOKUP(AF69,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF69,Group,7,FALSE)=\"\",0,ROUND(AJ69-0.04999,1)-AJ69+AM69)","v":0},{"$f":"IF(VLOOKUP(AF69,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF69,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,null,"X"]
[null,"Trim",null,null,"2-1/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"90° Corner - Waxed",null,null,null,"Wire Cut Finish",null,null,null,null,"24 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA71,AG71)","v":1.35},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":1.35},null,"YES",1.35,{"$f":"+W71","v":0},{"$f":"+X71","v":1.35},{"$f":"(AG71-AC71)/AG71","v":0},null,2,{"$f":"SUM(AJ71:AL71)+AE71","v":1.35},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":1.35},{"$f":"IF(VLOOKUP(AF71,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ71,1)-AJ71,2),Round,2,FALSE)+VLOOKUP(AF71,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",0,ROUND(AJ71-0.04999,1)-AJ71+AM71)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF71,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"2-1/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"Edge Cap - Waxed",null,null,null,"Wire Cut Finish",null,null,null,null,"10 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA72,AG72)","v":1.35},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA72*(1-W72)+0.004999,2)","v":1.35},null,"YES",1.35,{"$f":"+W72","v":0},{"$f":"+X72","v":1.35},{"$f":"(AG72-AC72)/AG72","v":0},null,2,{"$f":"SUM(AJ72:AL72)+AE72","v":1.35},null,null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":1.35},{"$f":"IF(VLOOKUP(AF72,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ72,1)-AJ72,2),Round,2,FALSE)+VLOOKUP(AF72,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",0,ROUND(AJ72-0.04999,1)-AJ72+AM72)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF72,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,null,"X"]
[null,null,"METRO TREAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MT0",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,null,"X"]
[null,null,null,"Color:","75T Pewter",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"6\" x 6\" x 1/2\"",null,"Field",null,null,null,null,null,null,null,null,"7.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA78,AG78)","v":10.65},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":10.65},null,"YES",10.65,{"$f":"+W78","v":0},{"$f":"+X78","v":10.65},{"$f":"(AG78-AC78)/AG78","v":0},null,1,{"$f":"SUM(AJ78:AL78)+AE78","v":10.65},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":10.65},{"$f":"IF(VLOOKUP(AF78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ78,1)-AJ78,2),Round,2,FALSE)+VLOOKUP(AF78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",0,ROUND(AJ78-0.04999,1)-AJ78+AM78)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF78,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,null,"X"]
[null,null,null,"Notes:","a) Trim is not available.  Use QUARRYBASICS Clear Tones (Smooth Finish) color 705 Pewter for color for 75T Pewter.",null,null,null,null,null,null,null,null,null,null,null,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,"Recycled Content (Pre-consumer):  75T Pewter 23%.  (Percentages based on most current data.)",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,null,"QUARRYBASICS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MT0",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,null,"X"]
[null,null,null,"Clear Tones (Smooth Finish)",null,null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,null,null,"Color:","108 Chestnut Brown",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"6\" x 6\" x 1/2\"",null,"Field",null,null,null,null,null,null,null,null,"7.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA89,AG89)","v":7.05},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":7.05},null,"YES",7.05,{"$f":"+W89","v":0},{"$f":"+X89","v":7.05},{"$f":"(AG89-AC89)/AG89","v":0},null,1,{"$f":"SUM(AJ89:AL89)+AE89","v":7.05},null,null,{"$f":"ROUND(AC89/(1-VLOOKUP(AF89,Group,2,FALSE)),2)","v":7.05},{"$f":"IF(VLOOKUP(AF89,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ89,1)-AJ89,2),Round,2,FALSE)+VLOOKUP(AF89,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,7,FALSE)=\"\",0,ROUND(AJ89-0.04999,1)-AJ89+AM89)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF89,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,null,"X"]
[null,"Trim",null,null,"3-5/8\" x 7-5/8\" x 1/2\"",null,"Q1485",null,null,"Bullnose",null,null,null,null,null,"12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA91,AG91)","v":4.5},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":4.5},null,"YES",4.5,{"$f":"+W91","v":0},4.5,{"$f":"(AG91-AC91)/AG91","v":0},null,2,{"$f":"SUM(AJ91:AL91)+AE91","v":4.5},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":4.5},{"$f":"IF(VLOOKUP(AF91,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ91,1)-AJ91,2),Round,2,FALSE)+VLOOKUP(AF91,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",0,ROUND(AJ91-0.04999,1)-AJ91+AM91)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF91,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"3-5/8\" x 7-5/8\" x 1/2\"",null,"Q1485L",null,null,"Bullnose Corner - Left",null,null,null,null,null,"12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA92,AG92)","v":7.25},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":7.25},null,"YES",7.25,0,7.25,{"$f":"(AG92-AC92)/AG92","v":0},null,2,{"$f":"SUM(AJ92:AL92)+AE92","v":7.25},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":7.25},{"$f":"IF(VLOOKUP(AF92,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ92,1)-AJ92,2),Round,2,FALSE)+VLOOKUP(AF92,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",0,ROUND(AJ92-0.04999,1)-AJ92+AM92)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF92,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"3-5/8\" x 7-5/8\" x 1/2\"",null,"Q1485R",null,null,"Bullnose Corner - Right",null,null,null,null,null,"12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA93,AG93)","v":7.25},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA93*(1-W93)+0.004999,2)","v":7.25},null,"YES",7.25,0,7.25,{"$f":"(AG93-AC93)/AG93","v":0},null,2,{"$f":"SUM(AJ93:AL93)+AE93","v":7.25},null,null,{"$f":"ROUND(AC93/(1-VLOOKUP(AF93,Group,2,FALSE)),2)","v":7.25},{"$f":"IF(VLOOKUP(AF93,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ93,1)-AJ93,2),Round,2,FALSE)+VLOOKUP(AF93,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",0,ROUND(AJ93-0.04999,1)-AJ93+AM93)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF93,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,null,"X"]
[null,null,null,"Round Top Cove Base:",null,null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565",null,null,"Cove Base",null,null,null,null,null,"14 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA97,AG97)","v":4.2},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA97*(1-W97)+0.004999,2)","v":4.2},null,"YES",4.2,{"$f":"+W97","v":0},4.2,{"$f":"(AG97-AC97)/AG97","v":0},null,2,{"$f":"SUM(AJ97:AL97)+AE97","v":4.2},null,null,{"$f":"ROUND(AC97/(1-VLOOKUP(AF97,Group,2,FALSE)),2)","v":4.2},{"$f":"IF(VLOOKUP(AF97,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ97,1)-AJ97,2),Round,2,FALSE)+VLOOKUP(AF97,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",0,ROUND(AJ97-0.04999,1)-AJ97+AM97)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF97,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565L",null," ","Cove Base Outside Corner - Left",null,null,null,null,null,"14 PCS/CTN",null,null,7.95,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},7.95,null,"YES",7.95,0,7.95,0,null,2,7.95,null,null,7.95,0,0,"",null,"X"]
[null,"Trim",null," ","6\" x 6\" x 1/2\"",null,"Q3565R",null,null,"Cove Base Outside Corner - Right",null,null,null,null,null,"14 PCS/CTN",null,null,7.95,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},7.95,null,"YES",7.95,0,7.95,0,null,2,7.95,null,null,7.95,0,0,"",null,"X"]
[null,"Trim"," "," ","6\" x 6\" x 1/2\"",null,"Q3565B",null,null,"Cove Base Inside Corner",null,null,null,null,null,"14 PCS/CTN",null,null,10.199999999999999,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},10.199999999999999,null,"YES",10.199999999999999,0,10.199999999999999,0,null,2,10.199999999999999,null,null,10.199999999999999,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 7-5/8\" x 1/2\"",null,"Q3585",null,null,"Cove Base",null,null,null,null,null,"14 PCS/CTN",null,null,4.8499999999999996,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},4.8499999999999996,null,"YES",4.8499999999999996,{"$f":"+W101","v":0},4.8499999999999996,0,null,2,4.8499999999999996,null,null,4.8499999999999996,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 7-5/8\" x 1/2\"",null,"Q3585L",null," ","Cove Base Outside Corner - Left",null,null,null,null,null,"14 PCS/CTN",null,null,9,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},9,null,"YES",9,0,9,0,null,2,9,null,null,9,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 7-5/8\" x 1/2\"",null,"Q3585R",null,null,"Cove Base Outside Corner - Right",null,null,null,null,null,"14 PCS/CTN",null,null,9,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},9,null,"YES",9,0,9,0,null,2,9,null,null,9,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","705 Pewter",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"6\" x 6\" x 1/2\"",null,"Field",null,null,null,null,null,null,null,null,"7.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA107,AG107)","v":9.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA107*(1-W107)+0.004999,2)","v":9.85},null,"YES",9.85,{"$f":"+W107","v":0},{"$f":"+X107","v":9.85},{"$f":"(AG107-AC107)/AG107","v":0},null,1,{"$f":"SUM(AJ107:AL107)+AE107","v":9.85},null,null,{"$f":"ROUND(AC107/(1-VLOOKUP(AF107,Group,2,FALSE)),2)","v":9.85},{"$f":"IF(VLOOKUP(AF107,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ107,1)-AJ107,2),Round,2,FALSE)+VLOOKUP(AF107,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF107,Group,7,FALSE)=\"\",0,ROUND(AJ107-0.04999,1)-AJ107+AM107)","v":0},{"$f":"IF(VLOOKUP(AF107,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF107,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,null,"X"]
[null,null,"continued on next page",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"QUARRYBASICS - continued",null,null,null,null,null,null,null," ",null,null,null,null,null,null,"Item # Lookup:","MT0",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,null,"X"]
[null,null,null,"Clear Tones (Smooth Finish)",null,null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,null,null,"Round Top Cove Base:",null,null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,null,null,"Color:","705 Pewter",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565",null,null,"Cove Base",null,null,null,null,null,"14 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA118,AG118)","v":5.05},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA118*(1-W118)+0.004999,2)","v":5.05},null,"YES",5.05,{"$f":"+W118","v":0},5.05,{"$f":"(AG118-AC118)/AG118","v":0},null,2,{"$f":"SUM(AJ118:AL118)+AE118","v":5.05},null,null,{"$f":"ROUND(AC118/(1-VLOOKUP(AF118,Group,2,FALSE)),2)","v":5.05},{"$f":"IF(VLOOKUP(AF118,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ118,1)-AJ118,2),Round,2,FALSE)+VLOOKUP(AF118,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",0,ROUND(AJ118-0.04999,1)-AJ118+AM118)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF118,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565L",null," ","Cove Base Outside Corner - Left",null,null,null,null,null,"14 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA119,AG119)","v":9.65},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA119*(1-W119)+0.004999,2)","v":9.65},null,"YES",9.65,0,9.65,{"$f":"(AG119-AC119)/AG119","v":0},null,2,{"$f":"SUM(AJ119:AL119)+AE119","v":9.65},null,null,{"$f":"ROUND(AC119/(1-VLOOKUP(AF119,Group,2,FALSE)),2)","v":9.65},{"$f":"IF(VLOOKUP(AF119,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ119,1)-AJ119,2),Round,2,FALSE)+VLOOKUP(AF119,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",0,ROUND(AJ119-0.04999,1)-AJ119+AM119)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF119,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565R",null,null,"Cove Base Outside Corner - Right",null,null,null,null,null,"14 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA120,AG120)","v":9.65},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA120*(1-W120)+0.004999,2)","v":9.65},null,"YES",9.65,0,9.65,{"$f":"(AG120-AC120)/AG120","v":0},null,2,{"$f":"SUM(AJ120:AL120)+AE120","v":9.65},null,null,{"$f":"ROUND(AC120/(1-VLOOKUP(AF120,Group,2,FALSE)),2)","v":9.65},{"$f":"IF(VLOOKUP(AF120,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ120,1)-AJ120,2),Round,2,FALSE)+VLOOKUP(AF120,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",0,ROUND(AJ120-0.04999,1)-AJ120+AM120)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF120,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565B",null,null,"Cove Base Inside Corner",null,null,null,null,null,"14 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA121,AG121)","v":12.4},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA121*(1-W121)+0.004999,2)","v":12.4},null,"",12.4,0,12.4,{"$f":"(AG121-AC121)/AG121","v":0},null,2,{"$f":"SUM(AJ121:AL121)+AE121","v":12.4},null,null,{"$f":"ROUND(AC121/(1-VLOOKUP(AF121,Group,2,FALSE)),2)","v":12.4},{"$f":"IF(VLOOKUP(AF121,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ121,1)-AJ121,2),Round,2,FALSE)+VLOOKUP(AF121,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",0,ROUND(AJ121-0.04999,1)-AJ121+AM121)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF121,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,null,"X"]
[null,null,null,"Color:","710 Raven",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"6\" x 6\" x 1/2\"",null,"Field",null,null,null,null,null,null,null,null,"7.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA125,AG125)","v":15.4},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA125*(1-W125)+0.004999,2)","v":15.4},null,"YES",15.4,{"$f":"+W125","v":0},15.4,{"$f":"(AG125-AC125)/AG125","v":0},null,1,{"$f":"SUM(AJ125:AL125)+AE125","v":15.4},null,null,{"$f":"ROUND(AC125/(1-VLOOKUP(AF125,Group,2,FALSE)),2)","v":15.4},{"$f":"IF(VLOOKUP(AF125,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ125,1)-AJ125,2),Round,2,FALSE)+VLOOKUP(AF125,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",0,ROUND(AJ125-0.04999,1)-AJ125+AM125)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF125,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"4\" x 8\" x 1/2\"",null,"Field",null,null," "," ",null,null,null,null,"7.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA126,AG126)","v":15.8},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA126*(1-W126)+0.004999,2)","v":15.8},null,"YES",15.8,0,15.8,{"$f":"(AG126-AC126)/AG126","v":0},null,1,{"$f":"SUM(AJ126:AL126)+AE126","v":15.8},null,null,{"$f":"ROUND(AC126/(1-VLOOKUP(AF126,Group,2,FALSE)),2)","v":15.8},{"$f":"IF(VLOOKUP(AF126,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ126,1)-AJ126,2),Round,2,FALSE)+VLOOKUP(AF126,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",0,ROUND(AJ126-0.04999,1)-AJ126+AM126)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF126,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile"," ",null,"8\" x 8\" x 1/2\"",null,"Field",null,null,null,null,null,null,null,null,"7.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA127,AG127)","v":15.2},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA127*(1-W127)+0.004999,2)","v":15.2},null,"YES",15.2,0,15.2,{"$f":"(AG127-AC127)/AG127","v":0},null,1,{"$f":"SUM(AJ127:AL127)+AE127","v":15.2},null,null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":15.2},{"$f":"IF(VLOOKUP(AF127,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ127,1)-AJ127,2),Round,2,FALSE)+VLOOKUP(AF127,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",0,ROUND(AJ127-0.04999,1)-AJ127+AM127)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF127,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,null,"X"]
[null,null,null,"Round Top Cove Base:",null,null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565",null,null,"Cove Base",null,null,null,null,null,"14 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA131,AG131)","v":6.4},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA131*(1-W131)+0.004999,2)","v":6.4},null,"",6.4,0,6.4,{"$f":"(AG131-AC131)/AG131","v":0},null,2,{"$f":"SUM(AJ131:AL131)+AE131","v":6.4},null,null,{"$f":"ROUND(AC131/(1-VLOOKUP(AF131,Group,2,FALSE)),2)","v":6.4},{"$f":"IF(VLOOKUP(AF131,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ131,1)-AJ131,2),Round,2,FALSE)+VLOOKUP(AF131,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,7,FALSE)=\"\",0,ROUND(AJ131-0.04999,1)-AJ131+AM131)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF131,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565L",null," ","Cove Base Outside Corner - Left",null,null,null,null,null,"14 PCS/CTN",null,null,12.5,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},12.5,null,"YES",12.5,{"$f":"+W132","v":0},{"$f":"+X132","v":12.5},0,null,2,12.5,null,null,12.5,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565R",null,null,"Cove Base Outside Corner - Right",null,null,null,null,null,"14 PCS/CTN",null,null,12.5,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},12.5,null,"YES",12.5,{"$f":"+W133","v":0},{"$f":"+X133","v":12.5},0,null,2,12.5,null,null,12.5,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565B",null,null,"Cove Base Inside Corner",null,null,null,null,null,"14 PCS/CTN",null,null,16.100000000000001,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},16.100000000000001,null,"YES",16.100000000000001,0,16.100000000000001,0,null,2,16.100000000000001,null,null,16.100000000000001,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 7-5/8\" x 1/2\"",null,"Q3585",null,null,"Cove Base",null,null,null,null,null,"14 PCS/CTN",null,null,7.35,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},7.35,null,"YES",7.35,0,7.35,0,null,2,7.35,null,null,7.35,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 7-5/8\" x 1/2\"",null,"Q3585L",null," ","Cove Base Outside Corner - Left",null,null,null,null,null,"14 PCS/CTN",null,null,14.1,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},14.1,null,"YES",14.1,0,14.1,0,null,2,14.1,null,null,14.1,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 7-5/8\" x 1/2\"",null,"Q3585R",null,null,"Cove Base Outside Corner - Right",null,null,null,null,null,"14 PCS/CTN",null,null,14.1,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},14.1,null,"YES",14.1,0,14.1,0,null,2,14.1,null,null,14.1,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","Recycled Content (Pre-consumer):  108 Chestnut Brown 18%, 705 Pewter 23% & 710 Raven 22%.",null,null,null,null,null,null,null,null,null,null,null,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,"(Percentages based on most current data.)",null,null,null,null,null,null,null,null,null,null,null,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,"QUARRYBASICS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MT0",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,null,"X"]
[null,null,null,"Ironspot",null,null,null,null,null,null,null,null,"   ",null,null,null,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,null,"X"]
[null,null,null,"Color:","31IS Mayflower Red",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"6\" x 6\" x 1/2\"",null,"Field",null,null,null,"Matte",null,null,null,null,"7.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA147,AG147)","v":7.1},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA147*(1-W147)+0.004999,2)","v":7.1},null,"YES",7.1,{"$f":"+W147","v":0},{"$f":"+X147","v":7.1},{"$f":"(AG147-AC147)/AG147","v":0},null,1,{"$f":"SUM(AJ147:AL147)+AE147","v":7.1},null,null,{"$f":"ROUND(AC147/(1-VLOOKUP(AF147,Group,2,FALSE)),2)","v":7.1},{"$f":"IF(VLOOKUP(AF147,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ147,1)-AJ147,2),Round,2,FALSE)+VLOOKUP(AF147,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,7,FALSE)=\"\",0,ROUND(AJ147-0.04999,1)-AJ147+AM147)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF147,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"8\" x 8\" x 1/2\"",null,"Field",null,null,null,"Matte",null,null,null,null,"7.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA148,AG148)","v":7.05},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA148*(1-W148)+0.004999,2)","v":7.05},null,"new",7.05,0,7.05,{"$f":"(AG148-AC148)/AG148","v":0},null,1,{"$f":"SUM(AJ148:AL148)+AE148","v":7.05},null,null,{"$f":"ROUND(AC148/(1-VLOOKUP(AF148,Group,2,FALSE)),2)","v":7.05},{"$f":"IF(VLOOKUP(AF148,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ148,1)-AJ148,2),Round,2,FALSE)+VLOOKUP(AF148,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",0,ROUND(AJ148-0.04999,1)-AJ148+AM148)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF148,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,null,"X"]
[null,null,null,"Color:","15IS Buckskin          57IS Puritan 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,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,null,"X"]
[null,"Field Tile",null,null,"6\" x 6\" x 1/2\"",null,"Field",null,null,null,"Matte",null,null,null,null,"7.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA152,AG152)","v":7.3},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA152*(1-W152)+0.004999,2)","v":7.3},null,"YES",7.3,{"$f":"+W152","v":0},{"$f":"+X152","v":7.3},{"$f":"(AG152-AC152)/AG152","v":0},null,1,{"$f":"SUM(AJ152:AL152)+AE152","v":7.3},null,null,{"$f":"ROUND(AC152/(1-VLOOKUP(AF152,Group,2,FALSE)),2)","v":7.3},{"$f":"IF(VLOOKUP(AF152,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ152,1)-AJ152,2),Round,2,FALSE)+VLOOKUP(AF152,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",0,ROUND(AJ152-0.04999,1)-AJ152+AM152)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF152,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"8\" x 8\" x 1/2\"",null,"Field",null,null,null,"Matte",null,null,null,null,"7.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA153,AG153)","v":7.25},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA153*(1-W153)+0.004999,2)","v":7.25},null,"new",7.25,0,7.25,{"$f":"(AG153-AC153)/AG153","v":0},null,1,{"$f":"SUM(AJ153:AL153)+AE153","v":7.25},null,null,{"$f":"ROUND(AC153/(1-VLOOKUP(AF153,Group,2,FALSE)),2)","v":7.25},{"$f":"IF(VLOOKUP(AF153,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ153,1)-AJ153,2),Round,2,FALSE)+VLOOKUP(AF153,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",0,ROUND(AJ153-0.04999,1)-AJ153+AM153)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF153,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,null,"X"]
[null,null,null,"Colors:","15IS Buckskin          31IS Mayflower Red          57IS Puritan 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,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,null,"X"]
[null,"Trim",null,null,"3-5/8\" x 7-5/8\" x 1/2\"",null,"Q1485",null,null,"Bullnose",null,null,null,null,null,"12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA157,AG157)","v":4.5},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":4.5},null,"YES",4.5,{"$f":"+W157","v":0},{"$f":"+X157","v":4.5},{"$f":"(AG157-AC157)/AG157","v":0},null,2,{"$f":"SUM(AJ157:AL157)+AE157","v":4.5},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":4.5},{"$f":"IF(VLOOKUP(AF157,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ157,1)-AJ157,2),Round,2,FALSE)+VLOOKUP(AF157,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",0,ROUND(AJ157-0.04999,1)-AJ157+AM157)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF157,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"3-5/8\" x 7-5/8\" x 1/2\"",null,"Q1485L",null,null,"Bullnose Corner - Left",null,null,null,null,null,"12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA158,AG158)","v":7.25},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA158*(1-W158)+0.004999,2)","v":7.25},null,"YES",7.25,0,7.25,{"$f":"(AG158-AC158)/AG158","v":0},null,2,{"$f":"SUM(AJ158:AL158)+AE158","v":7.25},null,null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":7.25},{"$f":"IF(VLOOKUP(AF158,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ158,1)-AJ158,2),Round,2,FALSE)+VLOOKUP(AF158,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",0,ROUND(AJ158-0.04999,1)-AJ158+AM158)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF158,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"3-5/8\" x 7-5/8\" x 1/2\"",null,"Q1485R",null,null,"Bullnose Corner - Right",null,null,null,null,null,"12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA159,AG159)","v":7.25},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA159*(1-W159)+0.004999,2)","v":7.25},null,"YES",7.25,0,7.25,{"$f":"(AG159-AC159)/AG159","v":0},null,2,{"$f":"SUM(AJ159:AL159)+AE159","v":7.25},null,null,{"$f":"ROUND(AC159/(1-VLOOKUP(AF159,Group,2,FALSE)),2)","v":7.25},{"$f":"IF(VLOOKUP(AF159,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ159,1)-AJ159,2),Round,2,FALSE)+VLOOKUP(AF159,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",0,ROUND(AJ159-0.04999,1)-AJ159+AM159)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF159,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,null,"X"]
[null,null,null,"Round Top Cove Base:",null,null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565",null,null,"Cove Base",null,null,null,null,null,"14 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA163,AG163)","v":4.2},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA163*(1-W163)+0.004999,2)","v":4.2},null,"YES",4.2,{"$f":"+W163","v":0},{"$f":"+X163","v":4.2},{"$f":"(AG163-AC163)/AG163","v":0},null,2,{"$f":"SUM(AJ163:AL163)+AE163","v":4.2},null,null,{"$f":"ROUND(AC163/(1-VLOOKUP(AF163,Group,2,FALSE)),2)","v":4.2},{"$f":"IF(VLOOKUP(AF163,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ163,1)-AJ163,2),Round,2,FALSE)+VLOOKUP(AF163,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF163,Group,7,FALSE)=\"\",0,ROUND(AJ163-0.04999,1)-AJ163+AM163)","v":0},{"$f":"IF(VLOOKUP(AF163,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF163,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"6\" x 6\" x 1/2\"",null,"Q3565L",null," ","Cove Base Outside Corner - Left",null,null,null,null,null,"14 PCS/CTN",null,null,7.95,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},7.95,null,"YES",7.95,0,7.95,0,null,2,7.95,null,null,7.95,0,0,"",null,"X"]
[null,"Trim",null," ","6\" x 6\" x 1/2\"",null,"Q3565R",null,null,"Cove Base Outside Corner - Right",null,null,null,null,null,"14 PCS/CTN",null,null,7.95,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},7.95,null,"YES",7.95,0,7.95,0,null,2,7.95,null,null,7.95,0,0,"",null,"X"]
[null,"Trim"," "," ","6\" x 6\" x 1/2\"",null,"Q3565B",null,null,"Cove Base Inside Corner",null,null,null,null,null,"14 PCS/CTN",null,null,10.199999999999999,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},10.199999999999999,null,"YES",10.199999999999999,0,10.199999999999999,0,null,2,10.199999999999999,null,null,10.199999999999999,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 7-5/8\" x 1/2\"",null,"Q3585",null,null,"Cove Base",null,null,null,null,null,"14 PCS/CTN",null,null,4.8499999999999996,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},4.8499999999999996,null,"YES",4.8499999999999996,0,4.8499999999999996,0,null,2,4.8499999999999996,null,null,4.8499999999999996,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 7-5/8\" x 1/2\"",null,"Q3585L",null," ","Cove Base Outside Corner - Left",null,null,null,null,null,"14 PCS/CTN",null,null,9,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},9,null,"YES",9,0,9,0,null,2,9,null,null,9,0,0,"",null,"X"]
[null,"Trim",null,null,"6\" x 7-5/8\" x 1/2\"",null,"Q3585R",null,null,"Cove Base Outside Corner - Right",null,null,null,null,null,"14 PCS/CTN",null,null,9,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},9,null,"YES",9,0,9,0,null,2,9,null,null,9,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","Recycled Content (Pre-consumer):  15IS Buckskin 23%, 31IS Mayflower Red 18% & 57IS Puritan Gray 23%.",null,null,null,null,null,null,null,null,null,null,null,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,"(Percentages based on most current data.)",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,null,"QUARRYBASICS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MT0",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,null,"X"]
[null,null,null,"XA Abrasive",null,null,null,null,null,null,null,null,null,null,null,null,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,"XA Abrasive combines two slip resisting additives, silicon carbide embedded in the surface combined with a through-the-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,null,null,"X"]
[null,null,null,null,"metallic additive, to create a one-of-a-kind slip resisting tile with a Dynamic Coefficient of Friction ≥ 0.70.",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,null,null,"Color:","31XA Mayflower Red",null,null,null,null,null," "," ",null,null,null,null,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,"Field Tile",null,null,"6\" x 6\" x 1/2\"",null,"Field",null,null,null,null,null,null,null,null,"7.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA183,AG183)","v":7.3},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":7.3},null,"YES",7.3,{"$f":"+W183","v":0},{"$f":"+X183","v":7.3},{"$f":"(AG183-AC183)/AG183","v":0},null,1,{"$f":"SUM(AJ183:AL183)+AE183","v":7.3},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":7.3},{"$f":"IF(VLOOKUP(AF183,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ183,1)-AJ183,2),Round,2,FALSE)+VLOOKUP(AF183,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",0,ROUND(AJ183-0.04999,1)-AJ183+AM183)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF183,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"8\" x 8\" x 1/2\"",null,"Field",null,null,null,null,null,null,null,null,"7.10 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA184,AG184)","v":7.25},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA184*(1-W184)+0.004999,2)","v":7.25},null,"YES",7.25,{"$f":"+W184","v":0},{"$f":"+X184","v":7.25},{"$f":"(AG184-AC184)/AG184","v":0},null,1,{"$f":"SUM(AJ184:AL184)+AE184","v":7.25},null,null,{"$f":"ROUND(AC184/(1-VLOOKUP(AF184,Group,2,FALSE)),2)","v":7.25},{"$f":"IF(VLOOKUP(AF184,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ184,1)-AJ184,2),Round,2,FALSE)+VLOOKUP(AF184,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",0,ROUND(AJ184-0.04999,1)-AJ184+AM184)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF184,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,null,"X"]
[null,null,null,"Color:","15XA Buckskin          57XA Puritan 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,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,"Field Tile",null,null,"6\" x 6\" x 1/2\"",null,"Field",null,null,null,null,null,null,null,null,"7.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA188,AG188)","v":7.5},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA188*(1-W188)+0.004999,2)","v":7.5},null,"YES",7.5,{"$f":"+W188","v":0},{"$f":"+X188","v":7.5},{"$f":"(AG188-AC188)/AG188","v":0},null,1,{"$f":"SUM(AJ188:AL188)+AE188","v":7.5},null,null,{"$f":"ROUND(AC188/(1-VLOOKUP(AF188,Group,2,FALSE)),2)","v":7.5},{"$f":"IF(VLOOKUP(AF188,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ188,1)-AJ188,2),Round,2,FALSE)+VLOOKUP(AF188,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF188,Group,7,FALSE)=\"\",0,ROUND(AJ188-0.04999,1)-AJ188+AM188)","v":0},{"$f":"IF(VLOOKUP(AF188,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF188,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"8\" x 8\" x 1/2\"",null,"Field",null,null,null,null,null,null,null,null,"7.10 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA189,AG189)","v":7.45},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA189*(1-W189)+0.004999,2)","v":7.45},null,"YES",7.45,{"$f":"+W189","v":0},{"$f":"+X189","v":7.45},{"$f":"(AG189-AC189)/AG189","v":0},null,1,{"$f":"SUM(AJ189:AL189)+AE189","v":7.45},null,null,{"$f":"ROUND(AC189/(1-VLOOKUP(AF189,Group,2,FALSE)),2)","v":7.45},{"$f":"IF(VLOOKUP(AF189,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ189,1)-AJ189,2),Round,2,FALSE)+VLOOKUP(AF189,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",0,ROUND(AJ189-0.04999,1)-AJ189+AM189)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF189,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,null,"X"]
[null,null,null,"Notes:","a) Trim is not available.  Use Ironspot colors.  Trim colors to use:  for 15XA Buckskin use 15IS Buckskin, for 31XA Mayflower Red",null,null,null,null,null,null,null,null,null,null,null,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,"use 31IS Mayflower Red & for 57XA Puritan Gray use 57IS Puritan 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,null,null,"X"]
[null,null,null,null,"Recycled Content (Pre-consumer):  15XA Buckskin 23%, 31XA Mayflower Red 18% & 57XA Puritan Gray 23%.",null,null,null,null,null,null,null,null,null,null,null,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,"(Percentages based on most current data.)",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,null,"ROYAL THIN BRICK (Tumbled Thin Brick)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","MTRO",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,null,"X"]
[null,null,null,"Colors:","101 Newbury",null,"   220 Park",null,null,null," 350 Arlington Flashed",null,null,null,null,null,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,"105 Beacon",null,"   250 Charles Flashed",null,null,null," 458 Hawthorn Flashed",null,null,null,null,null,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,"107 Tremont",null,"   310 Cambridge",null,null,null," 505 Congress",null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"2-3/4\" x 7-5/8\" x 5/8\"",null,"Field",null,null,null,"Wire Cut/Distressed Edge",null,null,null,null,"6.94 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA202,AG202)","v":14.1},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA202*(1-W202)+0.004999,2)","v":14.1},null,"YES",14.1,{"$f":"+W202","v":0},{"$f":"+X202","v":14.1},{"$f":"(AG202-AC202)/AG202","v":0},null,1,{"$f":"SUM(AJ202:AL202)+AE202","v":14.1},null,null,{"$f":"ROUND(AC202/(1-VLOOKUP(AF202,Group,2,FALSE)),2)","v":14.1},{"$f":"IF(VLOOKUP(AF202,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ202,1)-AJ202,2),Round,2,FALSE)+VLOOKUP(AF202,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF202,Group,7,FALSE)=\"\",0,ROUND(AJ202-0.04999,1)-AJ202+AM202)","v":0},{"$f":"IF(VLOOKUP(AF202,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF202,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,null,"X"]
[null,"Trim",null,null,"2-3/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"90° Corner",null,null,null,"Wire Cut/Distressed Edge",null,null,null,null,"16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA204,AG204)","v":6.5},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA204*(1-W204)+0.004999,2)","v":6.5},null,"YES",6.5,{"$f":"+W204","v":0},{"$f":"+X204","v":6.5},{"$f":"(AG204-AC204)/AG204","v":0},null,2,{"$f":"SUM(AJ204:AL204)+AE204","v":6.5},null,null,{"$f":"ROUND(AC204/(1-VLOOKUP(AF204,Group,2,FALSE)),2)","v":6.5},{"$f":"IF(VLOOKUP(AF204,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ204,1)-AJ204,2),Round,2,FALSE)+VLOOKUP(AF204,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF204,Group,7,FALSE)=\"\",0,ROUND(AJ204-0.04999,1)-AJ204+AM204)","v":0},{"$f":"IF(VLOOKUP(AF204,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF204,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,null,"X"]
[null,null,null,"Color:","710 Hanover",null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"2-3/4\" x 7-5/8\" x 5/8\"",null,"Field",null,null,null,"Wire Cut/Distressed Edge",null,null,null,null,"6.94 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA208,AG208)","v":18.399999999999999},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA208*(1-W208)+0.004999,2)","v":18.399999999999999},null,"YES",18.399999999999999,{"$f":"+W208","v":0},{"$f":"+X208","v":18.399999999999999},{"$f":"(AG208-AC208)/AG208","v":0},null,1,{"$f":"SUM(AJ208:AL208)+AE208","v":18.399999999999999},null,null,{"$f":"ROUND(AC208/(1-VLOOKUP(AF208,Group,2,FALSE)),2)","v":18.399999999999999},{"$f":"IF(VLOOKUP(AF208,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ208,1)-AJ208,2),Round,2,FALSE)+VLOOKUP(AF208,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF208,Group,7,FALSE)=\"\",0,ROUND(AJ208-0.04999,1)-AJ208+AM208)","v":0},{"$f":"IF(VLOOKUP(AF208,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF208,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,null,"X"]
[null,"Trim",null,null,"2-3/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"90° Corner",null,null,null,"Wire Cut/Distressed Edge",null,null,null,null,"16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA210,AG210)","v":9.5},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA210*(1-W210)+0.004999,2)","v":9.5},null,"",9.5,{"$f":"+W210","v":0},{"$f":"+X210","v":9.5},{"$f":"(AG210-AC210)/AG210","v":0},null,2,{"$f":"SUM(AJ210:AL210)+AE210","v":9.5},null,null,{"$f":"ROUND(AC210/(1-VLOOKUP(AF210,Group,2,FALSE)),2)","v":9.5},{"$f":"IF(VLOOKUP(AF210,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ210,1)-AJ210,2),Round,2,FALSE)+VLOOKUP(AF210,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF210,Group,7,FALSE)=\"\",0,ROUND(AJ210-0.04999,1)-AJ210+AM210)","v":0},{"$f":"IF(VLOOKUP(AF210,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF210,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,null,"X"]
[null,null,null,"Color Blends:",null,null,null,null,null,null,null,null,null,null,null,null,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,"R01 Concord",null,"        R03 Federal",null,null,"          R05 Lexington",null,null,null,null,null,null,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,"R02 Hampshire",null,"        R04 Berkeley",null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"2-3/4\" x 7-5/8\" x 5/8\"",null,"Field",null,null,null,"Wire Cut/Distressed Edge",null,null,null,null,"6.94 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA216,AG216)","v":15.4},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA216*(1-W216)+0.004999,2)","v":15.4},null,"YES",15.4,{"$f":"+W216","v":0},{"$f":"+X216","v":15.4},{"$f":"(AG216-AC216)/AG216","v":0},null,1,{"$f":"SUM(AJ216:AL216)+AE216","v":15.4},null,null,{"$f":"ROUND(AC216/(1-VLOOKUP(AF216,Group,2,FALSE)),2)","v":15.4},{"$f":"IF(VLOOKUP(AF216,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ216,1)-AJ216,2),Round,2,FALSE)+VLOOKUP(AF216,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",0,ROUND(AJ216-0.04999,1)-AJ216+AM216)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF216,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,null,"X"]
[null,"Trim",null,null,"2-3/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"90° Corner",null,null,null,"Wire Cut/Distressed Edge",null,null,null,null,"16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA218,AG218)","v":7.1},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA218*(1-W218)+0.004999,2)","v":7.1},null,"YES",7.1,{"$f":"+W218","v":0},{"$f":"+X218","v":7.1},{"$f":"(AG218-AC218)/AG218","v":0},null,2,{"$f":"SUM(AJ218:AL218)+AE218","v":7.1},null,null,{"$f":"ROUND(AC218/(1-VLOOKUP(AF218,Group,2,FALSE)),2)","v":7.1},{"$f":"IF(VLOOKUP(AF218,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ218,1)-AJ218,2),Round,2,FALSE)+VLOOKUP(AF218,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",0,ROUND(AJ218-0.04999,1)-AJ218+AM218)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF218,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,null,"X"]
[null,null,null,"Additional Wax Option Charges:",null,null,null,null,null,null,null,null,null,null,null,null,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,null,"X"]
[null,"Field Tile",null,null,"2-3/4\" x 7-5/8\" x 5/8\"",null,"Field - Waxed",null,null,null,"Wire Cut/Distressed Edge",null,null,null,null,"7.58 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA222,AG222)","v":2.0499999999999998},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA222*(1-W222)+0.004999,2)","v":2.0499999999999998},null,"YES",2.0499999999999998,{"$f":"+W222","v":0},{"$f":"+X222","v":2.0499999999999998},{"$f":"(AG222-AC222)/AG222","v":0},null,1,{"$f":"SUM(AJ222:AL222)+AE222","v":2.0499999999999998},null,null,{"$f":"ROUND(AC222/(1-VLOOKUP(AF222,Group,2,FALSE)),2)","v":2.0499999999999998},{"$f":"IF(VLOOKUP(AF222,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ222,1)-AJ222,2),Round,2,FALSE)+VLOOKUP(AF222,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF222,Group,7,FALSE)=\"\",0,ROUND(AJ222-0.04999,1)-AJ222+AM222)","v":0},{"$f":"IF(VLOOKUP(AF222,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF222,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,null,"X"]
[null,"Trim",null,null,"2-3/4\" x 3-5/8\" x 7-5/8\" x 5/8\"",null,"90° Corner - Waxed",null,null,null,"Wire Cut/Distressed Edge",null,null,null,null,"24 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA224,AG224)","v":1.5},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA224*(1-W224)+0.004999,2)","v":1.5},null,"YES",1.5,{"$f":"+W224","v":0},{"$f":"+X224","v":1.5},{"$f":"(AG224-AC224)/AG224","v":0},null,2,{"$f":"SUM(AJ224:AL224)+AE224","v":1.5},null,null,{"$f":"ROUND(AC224/(1-VLOOKUP(AF224,Group,2,FALSE)),2)","v":1.5},{"$f":"IF(VLOOKUP(AF224,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ224,1)-AJ224,2),Round,2,FALSE)+VLOOKUP(AF224,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF224,Group,7,FALSE)=\"\",0,ROUND(AJ224-0.04999,1)-AJ224+AM224)","v":0},{"$f":"IF(VLOOKUP(AF224,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF224,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,null,"X"]
[null,null,null,"Note:","Recycled Content (Pre-consumer):  23%.  (Percentages based on most current data.) ",null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,"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,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,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."]
["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,null,null," "," "]
[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":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page","www.metroceramics.com"]
[]
[]
["Product","Direct Website Link"]
["Down to Earth","http://www.metroceramics.com/down-to-earth-product-page/"]
["MetroBrick","http://www.metroceramics.com/metrobrick-product-page/"]
["Metro Tread","http://www.metroceramics.com/metro-tread-ouarry-tile/"]
["QuarryBasics Clear Tones","http://www.metroceramics.com/quarrybasics-product-page/"]
["QuarryBasics XA Abrasive","http://www.metroceramics.com/site/page.php?id=329&searchFor=xa abrasive"]
["Royal Thin Brick","https://www.metroceramics.com/royal-thin-brick-product-page/"]

{"sheet":"Changes","index":4,"n_rows":52,"n_cols":3,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,2,1,2],[0,0,1,0],[0,1,1,1]]}
["Date Announced","Series","Description"]
[]
["New Products"]
["2008-12-01","DOWN TO EARTH","3 Textures specific to size."]
["2008-12-01","ENVIROQUARRY","Pre-consumer recycled content of over 60%."]
["2013-01-15","QUARRYBASICS","Abrasive Colors (Abrasive Finish)"]
["2014-11-04","MetroBrick","Architectural Thin Brick available in 4 colors and consists of a Field Tile, 90° Corner and an Edge Cap."]
["2014-11-04","QuarryBasics","Clear Tones Color 710 Raven added and is available in 6\" x 6\" x 1/2\", 4\" x 8\" x 1/2\" and 8\" x 8\" x 1/2\" Field Tile sizes only.  (No Trim is available)"]
["2015-10-06","Metro Pavers","6\" x 9 x 3/4\" Paver available in Color 310 Mayflower Red. "]
["2015-10-06","QuarryBasics","Clear Tones Color 710 Raven.  The following 6\" x 6\" Trim shapes added:  Round Top Cove Base Q3565, Q3565L Left Corner, Q3565R Right Corner and Q3565B Inside Corner."]
["2016-10-27","QuarryBasics XA Abrasive","XA Abrasive combines two slip resisting additives to create a one-of-a-kind slip resisting tile with a DCOF rating of > .70.  (XA Abrasive will replace both QuarryBasics Abrasive Colors as well as QuarryBasics X Colors.)"]
["2018-11-29","Royal Thin Brick","Tumbled wire-cut thin brick."]
["2019-12-13","MetroBrick","Colors 320 Schoolhouse Red and 365 Schoolhouse Red Flashed added and are available in Smooth or Wire Cut Finishes.  Color 505 Monument now also available in the Smooth Finish.  Seven Fast Ship Blends added and are only available in the Wire Cut Finish."]
["2019-12-13","QuarryBasics","Q3585 Round Top Cove Base , Q3585L and Q3585R Round Top Cove Base Corners are now available in color 710 Raven."]
["2021-11-28","MetroTread","Color 75T Pewter added and is available in the 6\" x 6\" Field Tile format."]
["2021-11-28","QuarryBasics Clear Tones","Color 705 Pewter added and is available in the 6\" x 6\" Field Tile, Q3565 Cove Base, Q3565 L & R Left and Right Cove Base Outside Corners and the Q3565B Inside Corner formats."]
["2023-01-09","QuarryBasics XA Abrasive","Q1485 Bullnose and Q1485L and Q1485R Left and Right Bullnose Corners added."]
["2023-04-05","QuarryBasics Ironspot","Available in color 57IS Puritan Gray in the 6\" x 6\" format."]
["2023-05-11","QuarryBasics Ironspot","Color 31IS Mayflower Red added and is available in the 6\" x 6\" Field Tile format.  Also Round Top Cove Base and Bullnose trim added in both Ironspot colors, 31IS Mayflower Red and 57IS Puritan Gray."]
["2024-06-26","QuarryBasics Ironspot","Color 15IS Buckskin and the 8\" x 8\" Field Tile format added."]
[]
[]
[]
["Discontinued Products"]
["2016-10-27","QuarryBasics Abrasive Colors","Entire Line being discontinued/phased out and being replaced with the XA Abrasive line."]
["2016-10-27","QuarryBasics X Colors","Entire Line being discontinued/phased out and being replaced with the XA Abrasive line."]
["2019-12-13","QuarryBasics","Clear Tones colors 101 Oyster Bay, 105 Buckskin, 107 Boulevard, 108 Chestnut Brown, 205 Adobe, 220 Auburn and 505 Plaza Gray are no longer available in the 4\" x 8\" x 1/2\" Field Tile format.  XA Abrasive colors 15XA Buckskin and 18XA Chestnut Brown are no longer available in the 4\" x 8\" x 1/2\" Field Tile format.  These products can still be produced as special order however minimum order quantities and extended lead times will apply.  "]
["2019-12-13","Somerset (Flashed)","Entire Line although Somerset products can still be produced as special order however minimum order quantities and extended lead times will apply."]
["2021-03-03","QuarryBasics Clear Tones","Colors 101 Oyster Bay, 205 Adobe and 220 Auburn in all formats."]
["2022-09-09","Metro Pavers","Entire Series."]
["2022-09-09","Metro Tread","Color 15T Buckskin in all formats."]
["2022-09-09","QuarryBasics Clear Tones","Color 107 Boulevard in all formats.  8\" x 8\" x 1/2\" Field Tile format in colors 105 Buckskin and 108 Chestnut Brown only.  The following Trim formats in all colors:  Q1665 Bullnose, Q1665C Bullnose Corner, Q1485T Ribbed Stairtread, Q8485 Transition Tile, Q3485 Round Top Cove Base, Q3485L and Q3485R Left and Right Round Top Cove Base Corners, Q3566 Flat Top Cove Base, Q3566L and Q3566R Left and Right Flat Top Cove Base Corners and Q3566B Flat Top Cove Base Inside Corner."]
["2022-09-09","QuarryBasics XA Abrasive","Colors 15XA Buckskin and 18XA Chestnut Brown in all formats.  4\" x 8\" x 1/2\" Field Tile format in all colors.  Trim formats Q1665 Bullnose, Q1665C Bullnose Corner in all colors."]
["2023-01-09","QuarryBasics Clear Tones","Colors 505 Plaza Gray and 507 Puritan Gray in all formats."]
["2023-04-05","QuarryBasics Clear Tones","Color 105 Buckskin in all formats."]
["2023-05-11","Metro Tread","Colors 31T Mayflower Red and 57T Puritan Gray only in all formats."]
["2023-05-11","QuarryBasics Clear Tones","Color 310 Mayflower Red only in all formats."]
[]
[]
[]
[]
[]
[]
[]
["Changes"]
[null,"Eco Quarry","Special order items.  Call for pricing and lead times."]
[null,"Metro E.S.Q.","Special order items.  Call for pricing and lead times."]
[null,"Metro Pavers"," 31A Mayflower Red Abrasive is a Special order item.  Call for pricing and lead times."]
[null,"4\" x 4\" Field","Special order items.  Call for pricing and lead times."]
["2014-11-04","EnviroQuarry","Changed to Special Order.  Call for pricing and lead times."]
["2016-10-27","MetroBrick","Items available in their \"Fast Ship\" program have changed and are now shown on our updated price list."]
["2021-03-03","Down to Earth","4\" x 12\" x 1/2\" Slate Texture and 6\" x 9\" x 1/2\" Stone Texture Field Tile has been changed to Special Order Only.  Call Customer Service for minimum order quantities, pricing and lead time."]