{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Changes"],"not_rendered":{"charts":0,"images":1,"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":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Imagery Mosaics"]
["File as","I"]
["Product Code","D"]
["CCTD Effective Date","7/1/23 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+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,null,"  "]
[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],[3,4,3,7]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'I' - Imagery Mosaics"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 7/1/23 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":170,"n_cols":41,"rows_kept":170,"cut":false,"hidden":false,"merged":[[9,25,9,32],[12,22,12,23],[10,14,10,15],[13,30,13,32],[9,22,9,23],[12,14,12,19],[9,14,9,19],[159,3,159,4],[18,2,18,19],[17,14,17,15],[151,2,151,19],[14,13,15,19],[155,2,155,19],[153,2,153,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.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,3,0.05,null,null,0.05,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$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 'I' - Imagery Mosaics"},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":"7/1/23 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-04-10"},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,"IMAGERY MOSAICS (Mesh-Mounted)",null,null,null,null,null,null,null," ",null," ",null,null,null,null,"Item # Lookup:","TGIM",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,"Decos",null,null,"12\" x 11-3/4\"",null,"Mosaic",null,"ALH-3",null,null,"Nickel",null,null,"2\" Hexagon",null,"(0.97 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA23,AG23)","v":35.25},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA23*(1-W23)+0.004999,2)","v":35.25},null,"",35.25,{"$f":"+W23","v":0},{"$f":"+X23","v":35.25},{"$f":"(AG23-AC23)/AG23","v":0},null,3,{"$f":"SUM(AJ23:AL23)+AE23","v":35.25},null,null,{"$f":"ROUND(AC23/(1-VLOOKUP(AF23,Group,2,FALSE)),2)","v":35.25},{"$f":"IF(VLOOKUP(AF23,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ23,1)-AJ23,2),Round,2,FALSE)+VLOOKUP(AF23,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF23,Group,7,FALSE)=\"\",0,ROUND(AJ23-0.04999,1)-AJ23+AM23)","v":0},{"$f":"IF(VLOOKUP(AF23,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF23,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 11-3/4\"",null,"Mosaic",null,"ALH-4",null,null,"Platinum",null,null,"2\" Hexagon",null,"(0.97 SF/SHEET)",null,35.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},35.25,null,"",35.25,0,35.25,0,null,3,35.25,null,null,35.25,0,0,"",null,"X"]
[null,"Decos",null,null,"11-5/8\" x 11-3/4\"",null,"Mosaic",null,"ATG-IJ-01",null,null,"Shimmer",null,null,"1\" Random Strips",null,"(0.94 SF/SHEET)",null,31.2,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},31.2,null,"",31.2,0,31.2,0,null,3,31.2,null,null,31.2,0,0,"",null,"X"]
[null,"Decos",null,null,"11-5/8\" x 11-3/4\"",null,"Mosaic",null,"ATG-IJ-02",null,null,"Mystic",null,null,"1\" Random Strips",null,"(0.94 SF/SHEET)",null,31.2,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},31.2,null,"",31.2,0,31.2,0,null,3,31.2,null,null,31.2,0,0,"",null,"X"]
[null,"Decos",null,null,"11-5/8\" x 11-3/4\"",null,"Mosaic",null,"ATG-IJ-04",null,null,"Tiger’s Eye",null,null,"1\" Random Strips",null,"(0.94 SF/SHEET)",null,31.2,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},31.2,null,"",31.2,0,31.2,0,null,3,31.2,null,null,31.2,0,0,"",null,"X"]
[null,"Decos",null,null,"10-5/8\" x 9-3/8\"",null,"Mosaic",null,"AT-GR",null,null,"Greis",null,null,"2\" Lantern",null,"(0.69 SF/SHEET)",null,16.600000000000001,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},16.600000000000001,null,"",16.600000000000001,0,16.600000000000001,0,null,3,16.600000000000001,null,null,16.600000000000001,0,0,"",null,"X"]
[null,"Decos",null,null,"10-5/8\" x 9-3/8\"",null,"Mosaic",null,"AT-TP",null,null,"Taupe",null,null,"2\" Lantern",null,"(0.69 SF/SHEET)",null,16.600000000000001,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},16.600000000000001,null,"",16.600000000000001,0,16.600000000000001,0,null,3,16.600000000000001,null,null,16.600000000000001,0,0,"",null,"X"]
[null,"Decos",null,null,"10-5/8\" x 9-3/8\"",null,"Mosaic",null,"AT-WH",null,null,"Polar",null,null,"2\" Lantern",null,"(0.69 SF/SHEET)",null,16.600000000000001,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},16.600000000000001,null,"",16.600000000000001,0,16.600000000000001,0,null,3,16.600000000000001,null,null,16.600000000000001,0,0,"",null,"X"]
[null,"Decos",null,null,"11-7/8\" x 11-7/8\"",null,"Mosaic",null,"BK-102",null,null,"Luminous",null,null,"Groutless Basketweave",null,"(0.97 SF/SHEET)",null,35.299999999999997,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},35.299999999999997,null,"",35.299999999999997,0,35.299999999999997,0,null,3,35.299999999999997,null,null,35.299999999999997,0,0,"",null,"X"]
[null,"Decos",null,null,"11-7/8\" x 11-7/8\"",null,"Mosaic",null,"BK-103",null,null,"Aztec",null,null,"Groutless Basketweave",null,"(0.97 SF/SHEET)",null,35.299999999999997,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},35.299999999999997,null,"",35.299999999999997,0,35.299999999999997,0,null,3,35.299999999999997,null,null,35.299999999999997,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/8\" x 11-1/4\"",null,"Mosaic",null,"CARRHEX",null,null,"Tenor",null,null,"1\" Hexagon",null,"(0.88 SF/SHEET)",null,32.9,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},32.9,null,"",32.9,0,32.9,0,null,3,32.9,null,null,32.9,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 10-1/4\"",null,"Mosaic",null,"CARRLANT",null,null,"Avalanche",null,null,"2\" Lantern",null,"(0.77 SF/SHEET)",null,40.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},40.4,null,"",40.4,0,40.4,0,null,3,40.4,null,null,40.4,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/8\" x 11-1/4\"",null,"Mosaic",null,"CREMAHEX",null,null,"Soprano",null,null,"1\" Hexagon",null,"(0.88 SF/SHEET)",null,32.9,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},32.9,null,"",32.9,0,32.9,0,null,3,32.9,null,null,32.9,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 10-1/4\"",null,"Mosaic",null,"CREMALANT",null,null,"Opaline",null,null,"2\" Lantern",null,"(0.77 SF/SHEET)",null,40.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},40.4,null,"",40.4,0,40.4,0,null,3,40.4,null,null,40.4,0,0,"",null,"X"]
[null,"Decos",null,null,"10-5/8\" x 12\"",null,"Mosaic",null,"DTR-ML",null,null,"Dark Travertine",null,null,"Mini Ledger",null,"(0.88 SF/SHEET)",null,28.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},28.05,null,"",28.05,0,28.05,0,null,3,28.05,null,null,28.05,0,0,"",null,"X"]
[null,"Field Tile",null,null,"4\" x 12\"",null,"Field",null,"GM-06-412",null,null,"Arctic White",null,null,null,null,"3 PCS/SF",null,25.55,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},25.55,null,"",25.55,0,25.55,0,null,1,25.55,null,null,25.55,0,0,"",null,"X"]
[null,"Field Tile",null,null,"4\" x 12\"",null,"Field",null,"GM-07-412",null,null,"Rain",null,null,null,null,"3 PCS/SF",null,22.85,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},22.85,null,"",22.85,0,22.85,0,null,1,22.85,null,null,22.85,0,0,"",null,"X"]
[null,"Field Tile",null,null,"4\" x 12\"",null,"Field",null,"GM-08-412",null,null,"Smoke",null,null,null,null,"3 PCS/SF",null,22.85,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},22.85,null,"",22.85,0,22.85,0,null,1,22.85,null,null,22.85,0,0,"",null,"X"]
[null,"Field Tile",null,null,"4\" x 12\"",null,"Field",null,"GM-09-412",null,null,"Graphite",null,null,null,null,"3 PCS/SF",null,22.85,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},22.85,null,"",22.85,0,22.85,0,null,1,22.85,null,null,22.85,0,0,"",null,"X"]
[null,"Decos"," ",null,"12\" x 11-3/4\"",null,"Mosaic",null,"IJ-GS03-5/8",null,null,"Brilliance",null,null,"5/8\" Random Strips",null,"(0.97 SF/SHEET)",null,31.2,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},31.2,null,"",31.2,0,31.2,0,null,3,31.2,null,null,31.2,0,0,"",null,"X"]
[null,"Decos"," ",null,"12\" x 11-3/4\"",null,"Mosaic",null,"IJ-GSL-01-5/8",null,null,"Sparkle",null,null,"5/8\" Random Strips",null,"(0.97 SF/SHEET)",null,31.2,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},31.2,null,"",31.2,0,31.2,0,null,3,31.2,null,null,31.2,0,0,"",null,"X"]
[null,"Decos",null,null,"11\" x 12-1/4\"",null,"Mosaic",null,"IMG BWL01-2",null,null,"Almond",null,null,"Water Jet Leaf",null,"(0.93 SF/SHEET)",null,48.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},48.8,null,"",48.8,0,48.8,0,null,3,48.8,null,null,48.8,0,0,"",null,"X"]
[null,"Decos",null,null,"11\" x 12-1/4\"",null,"Mosaic",null,"IMG BWL01-5",null,null,"Gray",null,null,"Water Jet Leaf",null,"(0.93 SF/SHEET)",null,48.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},48.8,null,"",48.8,0,48.8,0,null,3,48.8,null,null,48.8,0,0,"",null,"X"]
[null,"Decos",null,null,"11\" x 12-1/4\"",null,"Mosaic",null,"IMG BWL01-7",null,null,"White",null,null,"Water Jet Leaf",null,"(0.93 SF/SHEET)",null,48.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},48.8,null,"",48.8,0,48.8,0,null,3,48.8,null,null,48.8,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 10-1/4\"",null,"Mosaic",null,"IMG WJ CREAM-01",null,null,"Cream",null,null,"Water Jet 2\" Lantern",null,"(0.77 SF/SHEET)",null,47.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},47.4,null,"",47.4,0,47.4,0,null,3,47.4,null,null,47.4,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 10-1/4\"",null,"Mosaic",null,"IMG WJ DK GRAY",null,null,"Dark Gray",null,null,"Water Jet 2\" Lantern",null,"(0.77 SF/SHEET)",null,47.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},47.4,null,"",47.4,0,47.4,0,null,3,47.4,null,null,47.4,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 10-1/4\"",null,"Mosaic",null,"IMG WJ LT GRAY",null,null,"Lite Gray",null,null,"Water Jet 2\" Lantern",null,"(0.77 SF/SHEET)",null,47.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},47.4,null,"",47.4,0,47.4,0,null,3,47.4,null,null,47.4,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 10-1/4\"",null,"Mosaic",null,"IMG WJ-RED-01",null,null,"Red",null,null,"Water Jet 2\" Lantern",null,"(0.77 SF/SHEET)",null,50.55,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},50.55,null,"",50.55,0,50.55,0,null,3,50.55,null,null,50.55,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 10-1/4\"",null,"Mosaic",null,"IMG WJ-SWH-01",null,null,"White",null,null,"Water Jet 2\" Lantern",null,"(0.77 SF/SHEET)",null,50.55,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},50.55,null,"",50.55,0,50.55,0,null,3,50.55,null,null,50.55,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 10-1/4\"",null,"Mosaic",null,"IMG WJ-SWH-01F",null,null,"Frosted White",null,null,"Water Jet 2\" Lantern",null,"(0.77 SF/SHEET)",null,50.55,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},50.55,null,"",50.55,0,50.55,0,null,3,50.55,null,null,50.55,0,0,"",null,"X"]
[null,"Decos",null,null,"12-1/4\" x 11-1/4\"",null,"Mosaic",null,"IMG-CAL038",null,null,"Jupiter",null,null,"3/8\", 5/8\", 1\" Random Strips",null,"(0.95 SF/SHEET)",null,30.9,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},30.9,null,"",30.9,0,30.9,0,null,3,30.9,null,null,30.9,0,0,"",null,"X"]
[null,"Decos",null,null,"12-1/4\" x 11-1/4\"",null,"Mosaic",null,"IMG-CAL039",null,null,"Saturn",null,null,"3/8\", 5/8\", 1\" Random Strips",null,"(0.95 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA54,AG54)","v":30.9},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA54*(1-W54)+0.004999,2)","v":30.9},null,"",30.9,{"$f":"+W54","v":0},{"$f":"+X54","v":30.9},{"$f":"(AG54-AC54)/AG54","v":0},null,3,{"$f":"SUM(AJ54:AL54)+AE54","v":30.9},null,null,{"$f":"ROUND(AC54/(1-VLOOKUP(AF54,Group,2,FALSE)),2)","v":30.9},{"$f":"IF(VLOOKUP(AF54,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ54,1)-AJ54,2),Round,2,FALSE)+VLOOKUP(AF54,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF54,Group,7,FALSE)=\"\",0,ROUND(AJ54-0.04999,1)-AJ54+AM54)","v":0},{"$f":"IF(VLOOKUP(AF54,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF54,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12-1/4\" x 11-1/4\"",null,"Mosaic",null,"IMG-CAL040",null,null,"Neptune",null,null,"3/8\", 5/8\", 1\" Random Strips",null,"(0.95 SF/SHEET)",null,30.9,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},30.9,null,"",30.9,0,30.9,0,null,3,30.9,null,null,30.9,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-3/4\"",null,"Mosaic",null,"IMGCBS-304",null,null,"Santa Fe",null,null,"1\" x 1\"",null,"(0.95 SF/SHEET)",null,26.7,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.7,null,"",26.7,0,26.7,0,null,3,26.7,null,null,26.7,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 11-3/4\"",null,"Mosaic",null,"IMGGSF-1040-RS",null,null,"Crescent Ridge",null,null,"5/8\" Random Strips",null,"(0.97 SF/SHEET)",null,28.1,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},28.1,null,"",28.1,0,28.1,0,null,3,28.1,null,null,28.1,0,0,"",null,"X"]
[null,"Decos",null,null,"12-1/4\" x 11-1/8\"",null,"Mosaic",null,"IMG-SHBG",null,null,"Shell Beige",null,null,"3/8\" Mini Brick",null,"(0.94 SF/SHEET)",null,35.5,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},35.5,null,"",35.5,0,35.5,0,null,3,35.5,null,null,35.5,0,0,"",null,"X"]
[null,"Decos",null,null,"12-1/4\" x 11-1/8\"",null,"Mosaic",null,"IMG-SHGR",null,null,"Shell Gray",null,null,"3/8\" Mini Brick",null,"(0.94 SF/SHEET)",null,35.5,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},35.5,null,"",35.5,0,35.5,0,null,3,35.5,null,null,35.5,0,0,"",null,"X"]
[null,"Decos",null,null,"12-1/4\" x 11-1/8\"",null,"Mosaic",null,"IMG-SHWH",null,null,"Shell White",null,null,"3/8\" Mini Brick",null,"(0.94 SF/SHEET)",null,35.5,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},35.5,null,"",35.5,0,35.5,0,null,3,35.5,null,null,35.5,0,0,"",null,"X"]
[null,"Decos",null,null,"10-5/8\" x 13\"",null,"Mosaic",null,"IMGSSIM-W-DF",null,null,"Cascade",null,null,"5/8\" Random Strips",null,"(0.95 SF/SHEET)",null,28.1,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},28.1,null,"",28.1,0,28.1,0,null,3,28.1,null,null,28.1,0,0,"",null,"X"]
[null,"Decos",null,null,"10-5/8\" x 13\"",null,"Mosaic",null,"IMGSSIM-W-PB",null,null,"Gladstone",null,null,"5/8\" Random Strips",null,"(0.95 SF/SHEET)",null,28.1,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},28.1,null,"",28.1,0,28.1,0,null,3,28.1,null,null,28.1,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"IMGWSG-1699",null,null,"Artesia",null,null,"3/4\" x 3/4\"",null,"(1.00 SF/SHEET)",null,26.7,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.7,null,"",26.7,0,26.7,0,null,3,26.7,null,null,26.7,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 11-3/4\"",null,"Mosaic",null,"IMGWSG-7600-RS",null,null,"Whitehorse",null,null,"5/8\" Random Strips",null,"(0.97 SF/SHEET)",null,28.1,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},28.1,null,"",28.1,0,28.1,0,null,3,28.1,null,null,28.1,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-1/2\"",null,"Mosaic",null,"J-1",null,null,"Glacier",null,null,"Random Rectangle",null,"(0.93 SF/SHEET)",null,24.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},24.4,null,"",24.4,0,24.4,0,null,3,24.4,null,null,24.4,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-1/2\"",null,"Mosaic",null,"J-2",null,null,"Eclipse",null,null,"Random Rectangle",null,"(0.93 SF/SHEET)",null,24.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},24.4,null,"",24.4,0,24.4,0,null,3,24.4,null,null,24.4,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-1/2\"",null,"Mosaic",null,"J-4",null,null,"Desert",null,null,"Random Rectangle",null,"(0.93 SF/SHEET)",null,24.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},24.4,null,"",24.4,0,24.4,0,null,3,24.4,null,null,24.4,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 11-3/4\"",null,"Mosaic",null,"JAH-5",null,null,"Diamond",null,null,"2\" Hexagon",null,"(0.97 SF/SHEET)",null,35.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},35.25,null,"",35.25,0,35.25,0,null,3,35.25,null,null,35.25,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-3/4\"",null,"Mosaic",null,"PM-9801",null,null,"Bohemian",null,null,"2\" x 4\" Brick",null,"(0.95 SF/SHEET)",null,20.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},20.05,null,"",20.05,0,20.05,0,null,3,20.05,null,null,20.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-3/4\"",null,"Mosaic",null,"PM-9803",null,null,"Metropolitan",null,null,"2\" x 4\" Brick",null,"(0.95 SF/SHEET)",null,20.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},20.05,null,"",20.05,0,20.05,0,null,3,20.05,null,null,20.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-3/4\"",null,"Mosaic",null,"PM-9805-1",null,null,"Arcadian",null,null,"2\" x 4\" Brick",null,"(0.95 SF/SHEET)",null,20.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},20.05,null,"",20.05,0,20.05,0,null,3,20.05,null,null,20.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-3/4\"",null,"Mosaic",null,"PM-9806",null,null,"Neoteric",null,null,"2\" x 4\" Brick",null,"(0.95 SF/SHEET)",null,20.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},20.05,null,"",20.05,0,20.05,0,null,3,20.05,null,null,20.05,0,0,"",null,"X"]
[null,"Decos",null,null,"12-3/4\" x 12-1/4\"",null,"Mosaic",null,"TFCT-5",null,null,"Carrara",null,null,"2\" Hexagon",null,"(1.08 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA73,AG73)","v":36.65},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA73*(1-W73)+0.004999,2)","v":36.65},null,"new",36.65,{"$f":"+W73","v":0},{"$f":"+X73","v":36.65},{"$f":"(AG73-AC73)/AG73","v":0},null,3,{"$f":"SUM(AJ73:AL73)+AE73","v":36.65},null,null,{"$f":"ROUND(AC73/(1-VLOOKUP(AF73,Group,2,FALSE)),2)","v":36.65},{"$f":"IF(VLOOKUP(AF73,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ73,1)-AJ73,2),Round,2,FALSE)+VLOOKUP(AF73,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF73,Group,7,FALSE)=\"\",0,ROUND(AJ73-0.04999,1)-AJ73+AM73)","v":0},{"$f":"IF(VLOOKUP(AF73,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF73,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12-3/4\" x 12-1/4\"",null,"Mosaic",null,"TFCT-6",null,null,"Wooden White",null,null,"2\" Hexagon",null,"(1.08 SF/SHEET)",null,36.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},36.25,null,"new",36.25,0,36.25,0,null,3,36.25,null,null,36.25,0,0,"",null,"X"]
[null,"Decos",null,null,"12-3/4\" x 12-3/4\"",null,"Mosaic",null,"TFCT-11",null,null,"Carrara",null,null,"Fan",null,"(1.12 SF/SHEET)",null,40,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},40,null,"new",40,0,40,0,null,3,40,null,null,40,0,0,"",null,"X"]
[null,"Decos",null,null,"12-3/4\" x 12-3/4\"",null,"Mosaic",null,"TFCT-12",null,null,"Wooden White",null,null,"Fan",null,"(1.12 SF/SHEET)",null,39.75,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},39.75,null,"new",39.75,0,39.75,0,null,3,39.75,null,null,39.75,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-1/2\"",null,"Mosaic",null,"TFCT-14",null,null,"Carrara",null,null,"Leaf",null,"(0.93 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA77,AG77)","v":36},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":36},null,"new",36,{"$f":"+W77","v":0},{"$f":"+X77","v":36},{"$f":"(AG77-AC77)/AG77","v":0},null,3,{"$f":"SUM(AJ77:AL77)+AE77","v":36},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":36},{"$f":"IF(VLOOKUP(AF77,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ77,1)-AJ77,2),Round,2,FALSE)+VLOOKUP(AF77,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",0,ROUND(AJ77-0.04999,1)-AJ77+AM77)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF77,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-1/2\"",null,"Mosaic",null,"TFCT-15",null,null,"Wooden White",null,null,"Leaf",null,"(0.93 SF/SHEET)",null,35.75,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},35.75,null,"new",35.75,0,35.75,0,null,3,35.75,null,null,35.75,0,0,"",null,"X"]
[null,"Decos",null,null,"10-5/8\" x 12\"",null,"Mosaic",null,"TR-ML",null,null,"Light Travertine",null,null,"Mini Ledger",null,"(0.88 SF/SHEET)",null,28.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},28.05,null,"",28.05,0,28.05,0,null,3,28.05,null,null,28.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-7/8\" x 11-7/8\"",null,"Mosaic",null,"WG-BW",null,null,"Oyster",null,null,"Groutless Basketweave",null,"(0.97 SF/SHEET)",null,35.299999999999997,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},35.299999999999997,null,"",35.299999999999997,0,35.299999999999997,0,null,3,35.299999999999997,null,null,35.299999999999997,0,0,"",null,"X"]
[null,"Decos",null,null,"10-5/8\" x 12\"",null,"Mosaic",null,"WG-ML",null,null,"Wooden Gray",null,null,"Mini Ledger",null,"(0.88 SF/SHEET)",null,28.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},28.05,null,"",28.05,0,28.05,0,null,3,28.05,null,null,28.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/8\" x 11-1/4\"",null,"Mosaic",null,"WOODGRHEX",null,null,"Alto",null,null,"1\" Hexagon",null,"(0.88 SF/SHEET)",null,32.9,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},32.9,null,"",32.9,0,32.9,0,null,3,32.9,null,null,32.9,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 10-1/4\"",null,"Mosaic",null,"WOODGRLANT",null,null,"Phantom",null,null,"2\" Lantern",null,"(0.77 SF/SHEET)",null,40.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},40.4,null,"",40.4,0,40.4,0,null,3,40.4,null,null,40.4,0,0,"",null,"X"]
[null,"Decos"," ",null,"11-5/8\" x 11-3/4\"",null,"Mosaic",null,"YYQ-011-5/8",null,null,"Blizzard",null,null,"5/8\" Random Strips",null,"(0.94 SF/SHEET)",null,31.2,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},31.2,null,"",31.2,0,31.2,0,null,3,31.2,null,null,31.2,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,"REFLECTIONS - Glass Tile & Mosaics (Mesh-Mounted)",null,null,null,null,null,null,null,null,null,null," ",null,null,null,"Item # Lookup:","TGTR",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,"Decos",null,null,"11-3/4\" x 12-3/4\"",null,"Mosaic ",null,null,"16DS1-RS",null,null,"Skyland",null,"Random Bars",null,"(1.04 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA88,AG88)","v":26.6},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA88*(1-W88)+0.004999,2)","v":26.6},null,"",26.6,{"$f":"+W88","v":0},{"$f":"+X88","v":26.6},{"$f":"(AG88-AC88)/AG88","v":0},null,3,{"$f":"SUM(AJ88:AL88)+AE88","v":26.6},null,null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":26.6},{"$f":"IF(VLOOKUP(AF88,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ88,1)-AJ88,2),Round,2,FALSE)+VLOOKUP(AF88,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",0,ROUND(AJ88-0.04999,1)-AJ88+AM88)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF88,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12-3/4\"",null,"Mosaic",null,null,"16DS2-RS",null,null,"Elko",null,"Random Bars",null,"(1.04 SF/SHEET)",null,26.6,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.6,null,"",26.6,0,26.6,0,null,3,26.6,null,null,26.6,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12-3/4\"",null,"Mosaic ",null,null,"16DS4-RS",null,null,"Wadsworth",null,"Random Bars",null,"(1.04 SF/SHEET)",null,26.6,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.6,null,"",26.6,0,26.6,0,null,3,26.6,null,null,26.6,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12-3/4\"",null,"Mosaic ",null,null,"16DS8-RS",null,null,"Fallon ",null,"Random Bars",null,"(1.04 SF/SHEET)",null,26.6,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.6,null,"",26.6,0,26.6,0,null,3,26.6,null,null,26.6,0,0,"",null,"X"]
[null,"Field Tile",null,null,"3\" x 6\"",null,"Field",null,null,"16GM0636",null,null,"Arctic White",null,null,null,"8 PCS/SF",null,26.6,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.6,null,"",26.6,0,26.6,0,null,1,26.6,null,null,26.6,0,0,"",null,"X"]
[null,"Field Tile",null,null,"3\" x 6\"",null,"Field",null,null,"16GM0736",null,null,"Rain",null,null,null,"8 PCS/SF",null,26.6,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.6,null,"",26.6,0,26.6,0,null,1,26.6,null,null,26.6,0,0,"",null,"X"]
[null,"Field Tile",null,null,"3\" x 6\"",null,"Field",null,null,"16GM0836",null,null,"Smoke",null,null,null,"8 PCS/SF",null,26.6,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.6,null,"",26.6,0,26.6,0,null,1,26.6,null,null,26.6,0,0,"",null,"X"]
[null,"Field Tile",null,null,"3\" x 6\"",null,"Field",null,null,"16GM0936",null,null,"Graphite ",null,null,null,"8 PCS/SF",null,26.6,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.6,null,"",26.6,0,26.6,0,null,1,26.6,null,null,26.6,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic ",null,null,"16GS01-M4",null,null,"Bianco Mix",null,"5/8\" x 5/8\"",null,"(1.00 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16GS01-ML",null,null,"Bianco Mix",null,"5/8\" x 3\"",null,"(0.97 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic ",null,null,"16GS03-M4",null,null,"Grey Mix",null,"5/8\" x 5/8\"",null,"(1.00 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16GS03-ML",null,null,"Grey Mix",null,"5/8\" x 3\"",null,"(0.97 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic ",null,null,"16GS09D-M4",null,null,"Chocolate Mix",null,"5/8\" x 5/8\"",null,"(1.00 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16GS09D-ML",null,null,"Chocolate Mix",null,"5/8\" x 3\"",null,"(0.97 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-3/4\"",null,"Mosaic ",null,null,"16GS10D-ML",null,null,"Mocha Mix",null,"5/8\" x 3\"",null,"(0.95 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic ",null,null,"16GS12-M4",null,null,"Ecru Mix",null,"5/8\" x 5/8\"",null,"(1.00 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16GS12-ML",null,null,"Ecru Mix",null,"5/8\" x 3\"",null,"(0.97 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-3/4\"",null,"Mosaic ",null,null,"16GSL01-RS",null,null,"Multi Grigio",null,"1\" Random",null,"(0.95 SF/SHEET)",null,26.3,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.3,null,"",26.3,0,26.3,0,null,3,26.3,null,null,26.3,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-3/4\"",null,"Mosaic ",null,null,"16GSL02-RS",null,null,"Golden Sand Earth",null,"1\" Random",null,"(0.95 SF/SHEET)",null,26.3,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.3,null,"",26.3,0,26.3,0,null,3,26.3,null,null,26.3,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16GSL1050-RS",null,null,"Sandstone",null,"5/8\" Random",null,"(0.97 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic ",null,null,"16GSL1060-M4",null,null,"Riverstone",null,"5/8\" x 5/8\"",null,"(1.00 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16GSL1060-RS",null,null,"Riverstone",null,"5/8\" Random",null,"(0.97 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-3/4\"",null,"Mosaic ",null,null,"16GSL1070-M4",null,null,"Greystone",null,"5/8\" x 5/8\"",null,"(0.95 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16GSL1070-RS",null,null,"Greystone",null,"5/8\" Random",null,"(0.97 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-3/4\"",null,"Mosaic ",null,null,"16GSL1080-M4",null,null,"Chocolate Quartz",null,"5/8\" x 5/8\"",null,"(0.95 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16GSL1080-RS",null,null,"Chocolate Quartz",null,"5/8\" Random",null,"(0.97 SF/SHEET)",null,26.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.05,null,"",26.05,0,26.05,0,null,3,26.05,null,null,26.05,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16GSM1181-RS",null,null,"Three Rivers",null,"5/8\" Random",null,"(0.97 SF/SHEET)",null,29.5,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.5,null,"",29.5,0,29.5,0,null,3,29.5,null,null,29.5,0,0,"",null,"X"]
[null,"Decos",null,null,"11-7/8\" x 11-7/8\"",null,"Mosaic ",null,null,"16GSM1201-M4",null,null,"White Hall",null,"5/8\" x 5/8\"",null,"(0.97 SF/SHEET)",null,29.5,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.5,null,"",29.5,0,29.5,0,null,3,29.5,null,null,29.5,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16GSM1201-RS",null,null,"White Hall",null,"5/8\" Random",null,"(0.97 SF/SHEET)",null,29.5,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.5,null,"",29.5,0,29.5,0,null,3,29.5,null,null,29.5,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16HKS44-RS",null,null,"Metallics Chocolate",null,"5/8\" Random",null,"(0.97 SF/SHEET)",null,29.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.8,null,"",29.8,0,29.8,0,null,3,29.8,null,null,29.8,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16HKS56-RS",null,null,"Metallics Tan",null,"5/8\" Random",null,"(0.97 SF/SHEET)",null,29.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.8,null,"",29.8,0,29.8,0,null,3,29.8,null,null,29.8,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 12\"",null,"Mosaic ",null,null,"16HKS59-RS",null,null,"Metallics Black",null,"5/8\" Random",null,"(0.97 SF/SHEET)",null,29.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.8,null,"",29.8,0,29.8,0,null,3,29.8,null,null,29.8,0,0,"",null,"X"]
[null,"Field Tile",null,null,"4\" x 12\"",null,"Field",null,null,"16R4412ROCKY",null,null,"Rocky",null,null,null,"3 PCS/SF",null,26.9,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.9,null,"",26.9,0,26.9,0,null,1,26.9,null,null,26.9,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 12-1/2\"",null,"Mosaic ",null,null,"16R4LINKHAKI",null,null,"Khaki Linear",null,"1\" Random",null,"(0.94 SF/SHEET)",null,26.3,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.3,null,"",26.3,0,26.3,0,null,3,26.3,null,null,26.3,0,0,"",null,"X"]
[null,"Decos",null,null,"10-7/8\" x 12-1/2\"",null,"Mosaic ",null,null,"16R4LINRIVER",null,null,"River Linear",null,"1\" Random",null,"(0.94 SF/SHEET)",null,26.3,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},26.3,null,"",26.3,0,26.3,0,null,3,26.3,null,null,26.3,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic ",null,null,"W-4",null,null,"Ripple Grey",null,"2\" x 6\"",null,null,null,22.55,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},22.55,null,"",22.55,0,22.55,0,null,3,22.55,null,null,22.55,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic ",null,null,"W-6",null,null,"Ripple Cream",null,"2\" x 6\"",null,null,null,22.55,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},22.55,null,"",22.55,0,22.55,0,null,3,22.55,null,null,22.55,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic ",null,null,"W-8",null,null,"Ripple White",null,"2\" x 6\"",null,null,null,22.55,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},22.55,null,"",22.55,0,22.55,0,null,3,22.55,null,null,22.55,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,"TERRA GREEN RECYCLED - Recycled Glass Mosaics (Mesh-Mounted)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","TGRE",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,"Decos",null,null,"12\" x 11-1/4\"",null,"Mosaic ",null,"18FBGBRL – Carrara",null,null,"Carrara Barrel Matte",null,null,"Micro Crystal Barrels",null,"(0.93 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA129,AG129)","v":29.25},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA129*(1-W129)+0.004999,2)","v":29.25},null,"",29.25,{"$f":"+W129","v":0},{"$f":"+X129","v":29.25},{"$f":"(AG129-AC129)/AG129","v":0},null,3,{"$f":"SUM(AJ129:AL129)+AE129","v":29.25},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":29.25},{"$f":"IF(VLOOKUP(AF129,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ129,1)-AJ129,2),Round,2,FALSE)+VLOOKUP(AF129,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",0,ROUND(AJ129-0.04999,1)-AJ129+AM129)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF129,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 11-1/4\"",null,"Mosaic ",null,"18FBGBRL – Grey",null,null,"Grey Barrel Matte",null,null,"Micro Crystal Barrels",null,"(0.93 SF/SHEET)",null,29.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.25,null,"",29.25,0,29.25,0,null,3,29.25,null,null,29.25,0,0,"",null,"X"]
[null,"Decos",null,null,"11-1/4\" x 11-1/4\"",null,"Mosaic ",null,"18FBGPB-Beige-R",null,null,"Beige Pebble Matte",null,null,"Micro Crystal Pebbles",null,"(0.87 SF/SHEET)",null,32.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},32.25,null,"",32.25,0,32.25,0,null,3,32.25,null,null,32.25,0,0,"",null,"X"]
[null,"Decos",null,null,"11-1/4\" x 11-1/4\"",null,"Mosaic ",null,"18FBGPB-Black-R",null,null,"Black Pebble Matte",null,null,"Micro Crystal Pebbles",null,"(0.87 SF/SHEET)",null,32.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},32.25,null,"",32.25,0,32.25,0,null,3,32.25,null,null,32.25,0,0,"",null,"X"]
[32.25,"Decos",null,null,"11-1/4\" x 11-1/4\"",null,"Mosaic ",null,"18FBGPB-Carrara-R",null,null,"Carrara Pebble Matte",null,null,"Micro Crystal Pebbles",null,"(0.87 SF/SHEET)",null,32.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},32.25,null,"",32.25,0,32.25,0,null,3,32.25,null,null,32.25,0,0,"",null,"X"]
[null,"Decos",null,null,"11-1/4\" x 11-1/4\"",null,"Mosaic ",null,"18FBGPB-Grey-R",null,null,"Grey Pebble Matte",null,null,"Micro Crystal Pebbles",null,"(0.87 SF/SHEET)",null,32.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},32.25,null,"",32.25,0,32.25,0,null,3,32.25,null,null,32.25,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-1/4\"",null,"Mosaic ",null,"19FBGPR30-C3",null,null,"Large Penny Round Grey",null,null,"Penny Rounds",null,"(0.91 SF/SHEET)",null,29.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.25,null,"",29.25,0,29.25,0,null,3,29.25,null,null,29.25,0,0,"",null,"X"]
[null,"Decos",null,null,"11-3/4\" x 11-1/4\"",null,"Mosaic ",null,"20FBGPR30-Carrara",null,null,"Large Penny Round Carrara",null,null,"Penny Rounds",null,"(0.91 SF/SHEET)",null,29.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.25,null,"",29.25,0,29.25,0,null,3,29.25,null,null,29.25,0,0,"",null,"X"]
[null,"Decos",null,null,"10-1/4\" x 11-3/4\"",null,"Mosaic ",null,"RCGSTP01-73HEX",null,null,"Recycled Glass Hex",null,null,"3\" Hexagons",null,"(0.83 SF/SHEET)",null,29.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.4,null,"",29.4,0,29.4,0,null,3,29.4,null,null,29.4,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 11-3/4\"",null,"Mosaic ",null,"RCGSTP-01NH",null,null,"Recycled Glass Picket",null,null,"Pickets",null,"(0.97 SF/SHEET)",null,29.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.25,null,"",29.25,0,29.25,0,null,3,29.25,null,null,29.25,0,0,"",null,"X"]
[null,"Decos",null,null,"10-1/4\" x 11-3/4\"",null,"Mosaic ",null,"RCGSTP05-73HEX",null,null,"Recycled Glass Hex",null,null,"3\" Hexagons",null,"(0.83 SF/SHEET)",null,29.4,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.4,null,"",29.4,0,29.4,0,null,3,29.4,null,null,29.4,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 11-3/4\"",null,"Mosaic ",null,"RCGSTP-05NH",null,null,"Recycled Glass Picket",null,null,"Pickets",null,"(0.97 SF/SHEET)",null,29.25,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},29.25,null,"",29.25,0,29.25,0,null,3,29.25,null,null,29.25,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,"WATER JET COLLECTION - Marble Water Jet Cut Mosaics (Mesh-Mounted)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","TGWJ",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,"Decos",null,null,"12-1/4\" x 12-1/2\"",null,"Mosaic ",null,"AP-203-BLK",null,"White, Carrara & Marquise Elongated Multi Size Hex",null,null,null,null,null,"(1.06 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA144,AG144)","v":48.35},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA144*(1-W144)+0.004999,2)","v":48.35},null,"",48.35,{"$f":"+W144","v":0},48.35,{"$f":"(AG144-AC144)/AG144","v":0},null,3,{"$f":"SUM(AJ144:AL144)+AE144","v":48.35},null,null,{"$f":"ROUND(AC144/(1-VLOOKUP(AF144,Group,2,FALSE)),2)","v":48.35},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ144,1)-AJ144,2),Round,2,FALSE)+VLOOKUP(AF144,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",0,ROUND(AJ144-0.04999,1)-AJ144+AM144)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF144,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"11-3/4\" x 10-7/8\"",null,"Mosaic ",null,"AP-210",null,"Carrara Marble Elongated Hex",null,null,null,null,null,"(0.88 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA145,AG145)","v":47.45},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA145*(1-W145)+0.004999,2)","v":47.45},null,"",47.45,0,47.45,{"$f":"(AG145-AC145)/AG145","v":0},null,3,{"$f":"SUM(AJ145:AL145)+AE145","v":47.45},null,null,{"$f":"ROUND(AC145/(1-VLOOKUP(AF145,Group,2,FALSE)),2)","v":47.45},{"$f":"IF(VLOOKUP(AF145,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ145,1)-AJ145,2),Round,2,FALSE)+VLOOKUP(AF145,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",0,ROUND(AJ145-0.04999,1)-AJ145+AM145)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF145,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"11-7/8\" x 11-3/8\"",null,"Mosaic ",null,"AP-214",null,"Carrara Clipped Corners w/White & Gray Diamond Inserts",null,null,null,null,null,"(0.93 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA146,AG146)","v":48.05},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA146*(1-W146)+0.004999,2)","v":48.05},null,"",48.05,0,48.05,{"$f":"(AG146-AC146)/AG146","v":0},null,3,{"$f":"SUM(AJ146:AL146)+AE146","v":48.05},null,null,{"$f":"ROUND(AC146/(1-VLOOKUP(AF146,Group,2,FALSE)),2)","v":48.05},{"$f":"IF(VLOOKUP(AF146,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ146,1)-AJ146,2),Round,2,FALSE)+VLOOKUP(AF146,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",0,ROUND(AJ146-0.04999,1)-AJ146+AM146)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF146,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic ",null,"AP-217",null,"Carrara & White Stone Multi Size Box Design",null,null,null,null,null,"(1.00 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA147,AG147)","v":48.2},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA147*(1-W147)+0.004999,2)","v":48.2},null,"",48.2,0,48.2,{"$f":"(AG147-AC147)/AG147","v":0},null,3,{"$f":"SUM(AJ147:AL147)+AE147","v":48.2},null,null,{"$f":"ROUND(AC147/(1-VLOOKUP(AF147,Group,2,FALSE)),2)","v":48.2},{"$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,"Decos",null,null,"10-3/16\" x 12\"",null,"Mosaic ",null,"AP-226-1",null,"Carrara Marble Triangles Multi Cut",null,null,null,null,null,"(0.84 SF/SHEET)",null,{"$f":"IF(Suggested=\"Yes\",AA148,AG148)","v":48.05},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA148*(1-W148)+0.004999,2)","v":48.05},null,"",48.05,0,48.05,{"$f":"(AG148-AC148)/AG148","v":0},null,3,{"$f":"SUM(AJ148:AL148)+AE148","v":48.05},null,null,{"$f":"ROUND(AC148/(1-VLOOKUP(AF148,Group,2,FALSE)),2)","v":48.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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"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.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[]
[null,null,null,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","http://www.conestogatile.com/"]
[]
["Manufacturer's Home Page"]
[]
[]
["Product","Direct Website Link"]

{"sheet":"Changes","index":4,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[null,null," "]
["New Products"]
["2012-05-14","TERRA CLASSIC ACCENTS","FLEUR DI LIS Decorative Accents"]
["2012-05-14","TERRA KRYSTAL"]
["2015-06-08","Imagery Mosaics"]
["2016-09-08","Imagery Mosaics","Several mosaic patterns added:  2\" x 4\" Brick 4MM ink jet printed glass mosaic, Basketweave groutless natural stone mosaic, 1\" Hexagon natural stone mosaic, 2\" Hexagon glass & natural stone mosaic, 2\" Lantern Pattern natural stone mosaic, 2\" Lantern Pattern glazed porcelain mosaic, 5/8\" Random Strips ink jet printed glass and natural stone mosaic, 1\" Random Strips ink jet printed glass mosaic & Random Rectangle Pattern textured glass and natural stone mosaic. "]
["2016-09-08","Reflections VII","1\" x 4\", Random Block and Random Bars Mosaic patterns. "]
["2017-04-05","Reflections VII","After putting out the new Reflections VII Series in September of 2016, Terra Green decided to redesign the entire series.  All original colors and mosaics have been replaced."]
["2018-08-22","Reflections","2\" x 6\" Brick Textured Glass Mosaic format added and are available in colors Ripple Cream, Ripple Grey & Ripple White."]
["2018-08-22","Imagery Mosaics","Leaf Pattern Mosaic added and is available in colors Almond, Gray & White."]
["2020-07-07","Reflections","3 Random Pebble Mosaics added:  Beige Pebble (18FBGPB-Beige), Carrara Pebble (18FBGPB-Carrara) & Grey Pebble )18FBGPB-Grey)."]
["2022-06-30","Imagery Mosaics","Terra Green Recycled Glass Mosaics added."]
["2023-06-29","Imagery Mosaics","Water Jet Collection consisting of five Stone/Marble Water Jet Mosaics."]
["2025-04-07","Imagery Mosaics","2\" Hexagon, Fan, and Leaf Natural Stone Mosaics have been added.  They are available in two colors, Carrara and Wooden White."]
[]
[]
[]
["Discontinued Products"]
["2012-05-14","TERRA REFLECTIONS","Medley, Solids & Tumbled in all colors."]
["2015-06-08","Terra Basics","Entire Series."]
["2015-06-08","Terra Classic","Entire Series."]
["2015-06-08","Terra Classic Accents","Entire Series."]
["2015-06-08","Terra Contempo","Entire Series."]
["2015-06-08","Terra Krystal","Entire Series."]
["2015-06-08","Terra Onyx","Entire Series."]
["2015-06-08","Terra Ornamental Iron Collection","Entire Series."]
["2015-06-08","Terra Stainless Steel","Entire Series."]
["2015-06-08","Terra Traffic","Entire Series."]
["2017-04-05","Reflections VII","After putting out the new Reflections VII Series in September of 2016, Terra Green decided to redesign the entire series.  All original colors and mosaics have been replaced."]
["2018-02-07","Reflections I","3\" x 6\" Field Tile format in colors Earth, Khaki, Saddle and Tan only.  5/8\" x 5/8\" Glass & Stone Mix Mosaic format in color Castano Mocha Mix only."]
["2018-02-07","Reflections II","Color Copper Harbor in all Mosaic formats.  5/8\" x 5/8\" Glass & Slate Mix Mosaic format in color Sandstone only.  5/8\" x 5/8\" Glass & Metal Mix Mosaic format in color Three Rivers only."]
["2018-02-07","Reflections III","Colors Golden Sand Tan and Multi Volcano in all Mosaic formats.  1\" x 1\" Glass & Slate Mix Mosaic format in colors Golden Sand Earth and Multi Grigio only. "]
["2018-02-07","Reflections IV","1\" x 1\" Mosaic format in all colors. 1\" Random Strips Mosaic format in colors Beach Sand, Camouflage, Grizzly Bear and Sugar Cane.  4\" x 12\" Listello in colors Blanche, Cola, Rye, Sepia and Tawny."]
["2018-02-07","Reflections V","Entire Series."]
["2018-02-07","Reflections VI","Colors Metallics Blue Grey, Metallics Grey and Metallics White in all Mosaic formats.  5/8\" x 5/8\" Glass & Metal Mix Mosaic format in all colors."]
["2018-02-07","Reflections VII","Random Bars Glass Mix Mosaic format in colors Carlin, Genoa and Lyon only.  Random Bars Glass & Metal/Stone Mix Mosaic format in colors Preston and Sparks only."]
["2020-07-07","Imagery Mosaics","GM-02-412 Khaki 4\" x 12\" Field, IMGWSG-6600 Pueblo Mosaic and IMGWSG-6800 Durango Mosaic."]
[]
[]
[]
["Changes"]
["2018-02-07","Reflections","Terra Reflections Reflections I, Reflections II, Reflections III, Reflections IV, Reflections V, Reflections VI and Reflections VII all will now be known simply as \"Reflections\"."]
["2018-08-22","n/a","The name of this price list is now known as \"Imagery Mosaics\" and will no longer be known as \"Terra Green\"."]
["2023-07-20","Terra Green Recycled"]