{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Changes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":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","Fiandre"]
["File as","F"]
["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,null,"  "]
[null,4,null,"Stock - Field Tile",null,"No",0]
[null,5,null,"Stock - Trim",null,"No",0]
[null,6,null,"Stock - Decos",null,"No",0]
[null,7,null,"Import - Field Tile",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":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[5,0,5,10],[47,0,47,10],[49,0,49,10],[2,5,2,10]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'F' - Fiandre"}]
[]
[]
[{"$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,"French Clay",null,"Glazed Porcelain"]
[1,null,"LOL",null,"Glazed Ceramic"]
[1,null,"May",null,"Glazed Ceramic"]
[1,null,"Royal Marble",null,"Glazed Porcelain"]
[2,null,"Royal Marble Maximum",null,"6mm Glazed Porcelain"]
[2,null,"Shellstone",null,"Glazed Porcelain"]
[2,null,"Shen",null,"Glazed Porcelain"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":188,"n_cols":41,"rows_kept":188,"cut":false,"hidden":false,"merged":[[177,3,177,4],[19,2,19,19],[18,14,18,15],[174,2,174,18],[172,2,172,19],[112,3,112,18],[11,14,11,15],[10,14,10,19],[13,14,13,19],[15,13,16,19],[10,22,10,23],[10,25,10,32],[14,30,14,32],[13,22,13,23]]}
[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,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,"Stock - Field Tile",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,"SF/CTN",null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,4,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Stock - Trim",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,5,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Stock - 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,6,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import - Field Tile",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA7,'Price List'!AG7)","v":0.05},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,7,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import - Deco & Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA8,'Price List'!AG8)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA8*(1-W8)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W8","v":0},{"$f":"+X8","v":0.05},{"$f":"(AG8-AC8)/AG8","v":0},null,7,{"$f":"SUM(AJ8:AL8)+AE8","v":0.05},null,null,{"$f":"ROUND(AC8/(1-VLOOKUP(AF8,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF8,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ8,1)-AJ8,2),Round,2,FALSE)+VLOOKUP(AF8,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF8,Group,7,FALSE)=\"\",0,ROUND(AJ8-0.04999,1)-AJ8+AM8)","v":0},{"$f":"IF(VLOOKUP(AF8,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF8,Group,7,FALSE))","v":""},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\",AA12,AG12)","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 'F' - Fiandre"},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$12","v":"List Price"},"U/M",{"$f":"+U$12","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$12","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$12","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,"X"]
[null,null,"FRENCH CLAY - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","FIFC",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:","Bronzage          Café          Fume          Lumiere          Sombre",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Floor:","12\" x 24\"",null,"Field",null,null,"Matte Rectified ",null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA26,AG26)","v":8.6},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA26*(1-W26)+0.004999,2)","v":8.6},null,"YES",8.6,{"$f":"+W26","v":0},{"$f":"+X26","v":8.6},{"$f":"(AG26-AC26)/AG26","v":0},null,1,{"$f":"SUM(AJ26:AL26)+AE26","v":8.6},null,null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":8.6},{"$f":"IF(VLOOKUP(AF26,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ26,1)-AJ26,2),Round,2,FALSE)+VLOOKUP(AF26,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF26,Group,7,FALSE)=\"\",0,ROUND(AJ26-0.04999,1)-AJ26+AM26)","v":0},{"$f":"IF(VLOOKUP(AF26,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF26,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"3\" x 6\"","Matte",null,null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA28,AG28)","v":30.55},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA28*(1-W28)+0.004999,2)","v":30.55},null,"",30.55,{"$f":"+W28","v":0},{"$f":"+X28","v":30.55},{"$f":"(AG28-AC28)/AG28","v":0},null,3,{"$f":"SUM(AJ28:AL28)+AE28","v":30.55},null,null,{"$f":"ROUND(AC28/(1-VLOOKUP(AF28,Group,2,FALSE)),2)","v":30.55},{"$f":"IF(VLOOKUP(AF28,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ28,1)-AJ28,2),Round,2,FALSE)+VLOOKUP(AF28,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF28,Group,7,FALSE)=\"\",0,ROUND(AJ28-0.04999,1)-AJ28+AM28)","v":0},{"$f":"IF(VLOOKUP(AF28,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF28,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,"Matte",null,null,null,null,null,"16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA30,AG30)","v":18.45},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA30*(1-W30)+0.004999,2)","v":18.45},null,"YES",18.45,{"$f":"+W30","v":0},{"$f":"+X30","v":18.45},{"$f":"(AG30-AC30)/AG30","v":0},null,2,{"$f":"SUM(AJ30:AL30)+AE30","v":18.45},null,null,{"$f":"ROUND(AC30/(1-VLOOKUP(AF30,Group,2,FALSE)),2)","v":18.45},{"$f":"IF(VLOOKUP(AF30,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ30,1)-AJ30,2),Round,2,FALSE)+VLOOKUP(AF30,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF30,Group,7,FALSE)=\"\",0,ROUND(AJ30-0.04999,1)-AJ30+AM30)","v":0},{"$f":"IF(VLOOKUP(AF30,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF30,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"6\" x 12\"",null,"Cove Base",null,null,"Matte",null,null,null,null,null,"8 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA31,AG31)","v":25.2},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":25.2},null,"",25.2,{"$f":"+W31","v":0},{"$f":"+X31","v":25.2},{"$f":"(AG31-AC31)/AG31","v":0},null,2,{"$f":"SUM(AJ31:AL31)+AE31","v":25.2},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":25.2},{"$f":"IF(VLOOKUP(AF31,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ31,1)-AJ31,2),Round,2,FALSE)+VLOOKUP(AF31,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",0,ROUND(AJ31-0.04999,1)-AJ31+AM31)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF31,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"LOL - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","FILO",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:","Acquamarine",null,"   Grey",null,"     White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Blue",null,"   Red",null,"     Yellow",null,null,null,null,null,null,null,null,null,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\"",null,"Field",null,null,"Glossy",null,null,null,null,null,"6.89 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA38,AG38)","v":11.8},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":11.8},null,"YES",11.8,{"$f":"+W38","v":0},{"$f":"+X38","v":11.8},{"$f":"(AG38-AC38)/AG38","v":0},null,1,{"$f":"SUM(AJ38:AL38)+AE38","v":11.8},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":11.8},{"$f":"IF(VLOOKUP(AF38,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ38,1)-AJ38,2),Round,2,FALSE)+VLOOKUP(AF38,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,7,FALSE)=\"\",0,ROUND(AJ38-0.04999,1)-AJ38+AM38)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF38,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Acquamarine          Yellow",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"4\" x 8\"",null,"Deco   LOL",null,null,null,null,null,null,null,null,"6.89 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA42,AG42)","v":12.2},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA42*(1-W42)+0.004999,2)","v":12.2},null,"YES",12.2,{"$f":"+W42","v":0},{"$f":"+X42","v":12.2},{"$f":"(AG42-AC42)/AG42","v":0},null,3,{"$f":"SUM(AJ42:AL42)+AE42","v":12.2},null,null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":12.2},{"$f":"IF(VLOOKUP(AF42,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ42,1)-AJ42,2),Round,2,FALSE)+VLOOKUP(AF42,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF42,Group,7,FALSE)=\"\",0,ROUND(AJ42-0.04999,1)-AJ42+AM42)","v":0},{"$f":"IF(VLOOKUP(AF42,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF42,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,null,"Joy Deco's:",null,"Art          Dott          Flo          Key          Leaf          Mya",null,null,null,null,null,null,null,null,null,null,null,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,"4\" x 8\"",null,"Deco",null,null,null,null,null,null,null,null,"6.89 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",AA46,AG46)","v":12.2},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA46*(1-W46)+0.004999,2)","v":12.2},null,"YES",12.2,{"$f":"+W46","v":0},{"$f":"+X46","v":12.2},{"$f":"(AG46-AC46)/AG46","v":0},null,3,{"$f":"SUM(AJ46:AL46)+AE46","v":12.2},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":12.2},{"$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,null,null,"Notes:","a) Random packaging.",null,null,null,"b) Extended Lead Time - approximately 8-10 weeks."]
[]
[null,null,"MAY - Glazed Ceramic Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","FIMY",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:","Amber","Bordeaux",null,null,"            Graphite",null,"         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,"X"]
[null,null,null,null,"Azure","Brown",null,null,"            Grey",null,"         White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Beige","Fern",null,null,"            Olive",null,null,null,null,null,null,null,null,null,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\"",null,"Field",null,null,null,null,null,null,null,null,"6.89 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA56,AG56)","v":10.35},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":10.35},null,"YES",10.35,{"$f":"+W56","v":0},{"$f":"+X56","v":10.35},{"$f":"(AG56-AC56)/AG56","v":0},null,1,{"$f":"SUM(AJ56:AL56)+AE56","v":10.35},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":10.35},{"$f":"IF(VLOOKUP(AF56,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ56,1)-AJ56,2),Round,2,FALSE)+VLOOKUP(AF56,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",0,ROUND(AJ56-0.04999,1)-AJ56+AM56)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF56,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Colors:","Amber          Brown          Graphite          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,"Decos",null,null,"4\" x 8\"",null,"Deco - May",null,null,null,null,null,null,null,null,"6.89 SF/CTN",null,"a,b",{"$f":"IF(Suggested=\"Yes\",AA60,AG60)","v":10.7},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA60*(1-W60)+0.004999,2)","v":10.7},null,"YES",10.7,{"$f":"+W60","v":0},{"$f":"+X60","v":10.7},{"$f":"(AG60-AC60)/AG60","v":0},null,3,{"$f":"SUM(AJ60:AL60)+AE60","v":10.7},null,null,{"$f":"ROUND(AC60/(1-VLOOKUP(AF60,Group,2,FALSE)),2)","v":10.7},{"$f":"IF(VLOOKUP(AF60,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ60,1)-AJ60,2),Round,2,FALSE)+VLOOKUP(AF60,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF60,Group,7,FALSE)=\"\",0,ROUND(AJ60-0.04999,1)-AJ60+AM60)","v":0},{"$f":"IF(VLOOKUP(AF60,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF60,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,null,"More Deco's:","Band Beige",null,null,null,"Box White",null,"   Frame Beige",null,"         Key White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,"Band White",null,null,null,"Flo Beige",null,"   Frame White",null,"         Wave Beige",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,"Box Beige",null,null,null,"Flo White",null,"   Key Beige",null,"         Wave White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,"Decos",null,null,"4\" x 8\"",null,"Deco - More",null,null,null,null,null,null,null,null,"6.89 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":10.7},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA66*(1-W66)+0.004999,2)","v":10.7},null,"YES",10.7,{"$f":"+W66","v":0},{"$f":"+X66","v":10.7},{"$f":"(AG66-AC66)/AG66","v":0},null,3,{"$f":"SUM(AJ66:AL66)+AE66","v":10.7},null,null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":10.7},{"$f":"IF(VLOOKUP(AF66,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ66,1)-AJ66,2),Round,2,FALSE)+VLOOKUP(AF66,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",0,ROUND(AJ66-0.04999,1)-AJ66+AM66)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF66,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,null,"Sleek Deco's:","Aida Beige",null,null,null,"Dao White",null,"      Lace Beige",null,"           Less White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,"Aida White",null,null,null,"Dash Beige",null,"      Lace White",null,"           Net Beige",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,"Dao Beige",null,null,null,"Dash White",null,"      Less Beige",null,"           Net White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,"Decos",null,null,"4\" x 8\"",null,"Deco - Sleek",null,null,null,null,null,null,null,null,"6.89 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",AA72,AG72)","v":10.7},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA72*(1-W72)+0.004999,2)","v":10.7},null,"YES",10.7,{"$f":"+W72","v":0},{"$f":"+X72","v":10.7},{"$f":"(AG72-AC72)/AG72","v":0},null,3,{"$f":"SUM(AJ72:AL72)+AE72","v":10.7},null,null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":10.7},{"$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,"Notes:","a) Random packaging.",null,null,null,"b) Extended Lead Time - approximately 8-10 weeks."]
[]
[null,null,"ROYAL MARBLE - Rectified Glazed Porcelain",null,null,null,null,null,null,null,null,null," ",null,null,null,null,"Item # Lookup:","FIRM",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:","Royal Beige",null,"  Royal Charcoal",null,null,null,"    Royal Light",null,null,null,null,null,null,null,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,"Royal Black",null,"  Royal Grey Cross Cut",null,null,null,"    Royal White"]
[]
[null,"Stock - Field Tile",null,null,"12\" x 24\" x 8mm",null,"Field",null,null,null,"Honed",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA81,AG81)","v":8.6999999999999993},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA81*(1-W81)+0.004999,2)","v":8.6999999999999993},null,"YES",8.6999999999999993,{"$f":"+W81","v":0},{"$f":"+X81","v":8.6999999999999993},{"$f":"(AG81-AC81)/AG81","v":0},null,4,{"$f":"SUM(AJ81:AL81)+AE81","v":8.6999999999999993},null,null,{"$f":"ROUND(AC81/(1-VLOOKUP(AF81,Group,2,FALSE)),2)","v":8.6999999999999993},{"$f":"IF(VLOOKUP(AF81,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ81,1)-AJ81,2),Round,2,FALSE)+VLOOKUP(AF81,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF81,Group,7,FALSE)=\"\",0,ROUND(AJ81-0.04999,1)-AJ81+AM81)","v":0},{"$f":"IF(VLOOKUP(AF81,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF81,Group,7,FALSE))","v":""},null,"X"]
[null,"Stock - Field Tile",null,null,"24\" x 48\" x 8mm",null,"Field",null,null,null,"Honed",null,null,null,null,"31.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA82,AG82)","v":9.5500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":9.5500000000000007},null,"YES",9.5500000000000007,{"$f":"+W82","v":0},{"$f":"+X82","v":9.5500000000000007},{"$f":"(AG82-AC82)/AG82","v":0},null,4,{"$f":"SUM(AJ82:AL82)+AE82","v":9.5500000000000007},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":9.5500000000000007},{"$f":"IF(VLOOKUP(AF82,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ82,1)-AJ82,2),Round,2,FALSE)+VLOOKUP(AF82,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",0,ROUND(AJ82-0.04999,1)-AJ82+AM82)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF82,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\" x 8mm",null,"Mosaic",null,"1\" x 2\" Brick",null,"Honed",null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA84,AG84)","v":35.5},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":35.5},null,"YES",35.5,{"$f":"+W84","v":0},35.5,{"$f":"(AG84-AC84)/AG84","v":0},null,3,{"$f":"SUM(AJ84:AL84)+AE84","v":35.5},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":35.5},{"$f":"IF(VLOOKUP(AF84,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ84,1)-AJ84,2),Round,2,FALSE)+VLOOKUP(AF84,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",0,ROUND(AJ84-0.04999,1)-AJ84+AM84)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF84,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"10\" x 12\" x 8mm",null,"Mosaic",null,"2\" x 2\" Hexagon",null,"Honed",null," ",null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA85,AG85)","v":58.15},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA85*(1-W85)+0.004999,2)","v":58.15},null,"YES",58.15,0,58.15,{"$f":"(AG85-AC85)/AG85","v":0},null,3,{"$f":"SUM(AJ85:AL85)+AE85","v":58.15},null,null,{"$f":"ROUND(AC85/(1-VLOOKUP(AF85,Group,2,FALSE)),2)","v":58.15},{"$f":"IF(VLOOKUP(AF85,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ85,1)-AJ85,2),Round,2,FALSE)+VLOOKUP(AF85,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",0,ROUND(AJ85-0.04999,1)-AJ85+AM85)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF85,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\" x 8mm",null,"Mosaic",null,"2\" x 2\"",null,"Honed",null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA86,AG86)","v":29.15},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA86*(1-W86)+0.004999,2)","v":29.15},null,"",29.15,0,29.15,{"$f":"(AG86-AC86)/AG86","v":0},null,3,{"$f":"SUM(AJ86:AL86)+AE86","v":29.15},null,null,{"$f":"ROUND(AC86/(1-VLOOKUP(AF86,Group,2,FALSE)),2)","v":29.15},{"$f":"IF(VLOOKUP(AF86,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ86,1)-AJ86,2),Round,2,FALSE)+VLOOKUP(AF86,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",0,ROUND(AJ86-0.04999,1)-AJ86+AM86)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF86,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"4\" x 24\" x 8mm",null,"Bullnose",null,null,null,"Honed",null,null,null,null,"16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA88,AG88)","v":11.65},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA88*(1-W88)+0.004999,2)","v":11.65},null,"YES",11.65,{"$f":"+W88","v":0},{"$f":"+X88","v":11.65},{"$f":"(AG88-AC88)/AG88","v":0},null,2,{"$f":"SUM(AJ88:AL88)+AE88","v":11.65},null,null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":11.65},{"$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,"Trim",null,null,"6\" x 12\" x 8mm",null,"Cove Base",null,null,null,"Honed",null,null,null,null,"8 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA89,AG89)","v":21.05},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":21.05},null,"YES",21.05,{"$f":"+W89","v":0},{"$f":"+X89","v":21.05},{"$f":"(AG89-AC89)/AG89","v":0},null,2,{"$f":"SUM(AJ89:AL89)+AE89","v":21.05},null,null,{"$f":"ROUND(AC89/(1-VLOOKUP(AF89,Group,2,FALSE)),2)","v":21.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,"Stock - Field Tile",null,null,"12\" x 24\" x 8mm",null,"Field",null,null,null,"Polished",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA91,AG91)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":12.95},null,"",12.95,{"$f":"+W91","v":0},{"$f":"+X91","v":12.95},{"$f":"(AG91-AC91)/AG91","v":0},null,4,{"$f":"SUM(AJ91:AL91)+AE91","v":12.95},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":12.95},{"$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,"Stock - Field Tile",null,null,"24\" x 48\" x 8mm",null,"Field",null,null,null,"Polished",null,null,null,null,"31.00 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA92,AG92)","v":13.45},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":13.45},null,"",13.45,{"$f":"+W92","v":0},{"$f":"+X92","v":13.45},{"$f":"(AG92-AC92)/AG92","v":0},null,4,{"$f":"SUM(AJ92:AL92)+AE92","v":13.45},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":13.45},{"$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,"Decos",null,null,"12\" x 12\" x 8mm",null,"Mosaic",null,"1\" x 2\" Brick",null,"Polished",null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA94,AG94)","v":38.049999999999997},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA94*(1-W94)+0.004999,2)","v":38.049999999999997},null,"YES",38.049999999999997,{"$f":"+W94","v":0},38.049999999999997,{"$f":"(AG94-AC94)/AG94","v":0},null,3,{"$f":"SUM(AJ94:AL94)+AE94","v":38.049999999999997},null,null,{"$f":"ROUND(AC94/(1-VLOOKUP(AF94,Group,2,FALSE)),2)","v":38.049999999999997},{"$f":"IF(VLOOKUP(AF94,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ94,1)-AJ94,2),Round,2,FALSE)+VLOOKUP(AF94,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",0,ROUND(AJ94-0.04999,1)-AJ94+AM94)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF94,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"10\" x 12\" x 8mm",null,"Mosaic",null,"2\" x 2\" Hexagon",null,"Polished",null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA95,AG95)","v":63.2},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA95*(1-W95)+0.004999,2)","v":63.2},null,"YES",63.2,0,63.2,{"$f":"(AG95-AC95)/AG95","v":0},null,3,{"$f":"SUM(AJ95:AL95)+AE95","v":63.2},null,null,{"$f":"ROUND(AC95/(1-VLOOKUP(AF95,Group,2,FALSE)),2)","v":63.2},{"$f":"IF(VLOOKUP(AF95,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ95,1)-AJ95,2),Round,2,FALSE)+VLOOKUP(AF95,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",0,ROUND(AJ95-0.04999,1)-AJ95+AM95)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF95,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\" x 8mm",null,"Mosaic",null,"2\" x 2\"",null,"Polished",null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA96,AG96)","v":31.7},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA96*(1-W96)+0.004999,2)","v":31.7},null,"YES",31.7,0,31.7,{"$f":"(AG96-AC96)/AG96","v":0},null,3,{"$f":"SUM(AJ96:AL96)+AE96","v":31.7},null,null,{"$f":"ROUND(AC96/(1-VLOOKUP(AF96,Group,2,FALSE)),2)","v":31.7},{"$f":"IF(VLOOKUP(AF96,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ96,1)-AJ96,2),Round,2,FALSE)+VLOOKUP(AF96,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",0,ROUND(AJ96-0.04999,1)-AJ96+AM96)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF96,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"4\" x 24\" x 8mm",null,"Bullnose",null,null,null,"Polished",null,null,null,null,"16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA98,AG98)","v":14.15},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA98*(1-W98)+0.004999,2)","v":14.15},null,"",14.15,{"$f":"+W98","v":0},{"$f":"+X98","v":14.15},{"$f":"(AG98-AC98)/AG98","v":0},null,2,{"$f":"SUM(AJ98:AL98)+AE98","v":14.15},null,null,{"$f":"ROUND(AC98/(1-VLOOKUP(AF98,Group,2,FALSE)),2)","v":14.15},{"$f":"IF(VLOOKUP(AF98,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ98,1)-AJ98,2),Round,2,FALSE)+VLOOKUP(AF98,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",0,ROUND(AJ98-0.04999,1)-AJ98+AM98)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF98,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"ROYAL MARBLE MAXIMUM - 6mm Rectified Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","FIRM",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:","Royal Charcoal          Royal White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,"Stock - Field Tile",null,null,"30\" x 60\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"36.33 SF/Slab",null,"a",{"$f":"IF(Suggested=\"Yes\",AA104,AG104)","v":23.55},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA104*(1-W104)+0.004999,2)","v":23.55},null,"YES",23.55,{"$f":"+W104","v":0},{"$f":"+X104","v":23.55},{"$f":"(AG104-AC104)/AG104","v":0},null,4,{"$f":"SUM(AJ104:AL104)+AE104","v":23.55},null,null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":23.55},{"$f":"IF(VLOOKUP(AF104,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ104,1)-AJ104,2),Round,2,FALSE)+VLOOKUP(AF104,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",0,ROUND(AJ104-0.04999,1)-AJ104+AM104)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF104,Group,7,FALSE))","v":""},null,"X"]
[null,"Stock - Field Tile",null,null,"60\" x 60\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"24.22 SF/Slab",null,"a",{"$f":"IF(Suggested=\"Yes\",AA105,AG105)","v":29.6},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA105*(1-W105)+0.004999,2)","v":29.6},null,"YES",29.6,0,29.6,{"$f":"(AG105-AC105)/AG105","v":0},null,4,{"$f":"SUM(AJ105:AL105)+AE105","v":29.6},null,null,{"$f":"ROUND(AC105/(1-VLOOKUP(AF105,Group,2,FALSE)),2)","v":29.6},{"$f":"IF(VLOOKUP(AF105,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ105,1)-AJ105,2),Round,2,FALSE)+VLOOKUP(AF105,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",0,ROUND(AJ105-0.04999,1)-AJ105+AM105)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF105,Group,7,FALSE))","v":""},null,"X"]
[null,"Stock - Field Tile",null,null,"60\" x 120\" x 6mm",null,"Field",null,null,null,"Polished",null,null,null,null,"48.44 SF/Slab",null,"a",{"$f":"IF(Suggested=\"Yes\",AA106,AG106)","v":30.8},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":30.8},null,"",30.8,0,30.8,{"$f":"(AG106-AC106)/AG106","v":0},null,4,{"$f":"SUM(AJ106:AL106)+AE106","v":30.8},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":30.8},{"$f":"IF(VLOOKUP(AF106,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ106,1)-AJ106,2),Round,2,FALSE)+VLOOKUP(AF106,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",0,ROUND(AJ106-0.04999,1)-AJ106+AM106)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF106,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Large Panel Porcelain will also involve additional packaging & freight charges depending on sizes and quantities."]
[null,null,null,null,"See below for these additional charges.  120\" panels are always subject to additional freight charges based on project quantity."]
[]
[null,null,null,null,null,null,null,null,null,null,"Large Panel Packaging & Freight Charges"]
[]
[null,null,null,"Large Panel Porcelain will also involve additional packaging & freight charges depending on sizes and quantities.  See below for these additional charges.  120\" panels are always subject to additional freight charges based on project quantity."]
[]
[null,null,null,null,null,"Size",null,null,null,null,"Total Pieces per Crate",null,null,"Description"]
[]
[null,"Stock - Field Tile",null,null,null,null,"30\" x 60\" x 6mm",null,null,null,52,null,null,"Big Crate",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA117,AG117)","v":144},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA117*(1-W117)+0.004999,2)","v":144},null,"new",144,{"$f":"+W117","v":0},{"$f":"+X117","v":144},{"$f":"(AG117-AC117)/AG117","v":0},null,4,{"$f":"SUM(AJ117:AL117)+AE117","v":144},null,null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":144},{"$f":"IF(VLOOKUP(AF117,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ117,1)-AJ117,2),Round,2,FALSE)+VLOOKUP(AF117,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",0,ROUND(AJ117-0.04999,1)-AJ117+AM117)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF117,Group,7,FALSE))","v":""},null,"X"]
[null,"Stock - Field Tile",null,null,null,null,"60\" x 60\" x 6mm",null,null,null,24,null,null,"Crate",null,null,null,null,240,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},240,null,"new",240,0,240,0,null,4,240,null,null,240,0,0,"",null,"X"]
[null,"Stock - Field Tile",null,null,null,null,"60\" x 120\" x 6mm",null,null,null,12,null,null,"Crate",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA119,AG119)","v":288},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA119*(1-W119)+0.004999,2)","v":288},null,"new",288,{"$f":"+W119","v":0},{"$f":"+X119","v":288},{"$f":"(AG119-AC119)/AG119","v":0},null,4,{"$f":"SUM(AJ119:AL119)+AE119","v":288},null,null,{"$f":"ROUND(AC119/(1-VLOOKUP(AF119,Group,2,FALSE)),2)","v":288},{"$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,"Stock - Field Tile",null,null,null,null,"60\" x 120\" x 6mm",null,null,null,"25 to 50",null,null,"A-Frame",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA120,AG120)","v":546},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA120*(1-W120)+0.004999,2)","v":546},null,"new",546,{"$f":"+W120","v":0},{"$f":"+X120","v":546},{"$f":"(AG120-AC120)/AG120","v":0},null,4,{"$f":"SUM(AJ120:AL120)+AE120","v":546},null,null,{"$f":"ROUND(AC120/(1-VLOOKUP(AF120,Group,2,FALSE)),2)","v":546},{"$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,null,"SHELLSTONE - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","FISH",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:","Shellamber",null,"   Shellbone",null,null,"   Shellgrey",null,null,null,null,null,null,null,null,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,"Shellblue",null,"   Shellgreen",null,null,"   Shellearth"]
[]
[null,"Stock - Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,"Honed",null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA127,AG127)","v":8.6},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA127*(1-W127)+0.004999,2)","v":8.6},null,"YES",8.6,{"$f":"+W127","v":0},{"$f":"+X127","v":8.6},{"$f":"(AG127-AC127)/AG127","v":0},null,4,{"$f":"SUM(AJ127:AL127)+AE127","v":8.6},null,null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":8.6},{"$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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Multicolor 1\" x 2\" Brick Random Mix",null,null,null,null,"Honed",null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA129,AG129)","v":50.05},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA129*(1-W129)+0.004999,2)","v":50.05},null,"YES",50.05,{"$f":"+W129","v":0},{"$f":"+X129","v":50.05},{"$f":"(AG129-AC129)/AG129","v":0},null,3,{"$f":"SUM(AJ129:AL129)+AE129","v":50.05},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":50.05},{"$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 12\"",null,"Mosaic",null,"2\" x 2\"","Honed",null,null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA130,AG130)","v":33.700000000000003},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA130*(1-W130)+0.004999,2)","v":33.700000000000003},null,"YES",33.700000000000003,{"$f":"+W130","v":0},{"$f":"+X130","v":33.700000000000003},{"$f":"(AG130-AC130)/AG130","v":0},null,3,{"$f":"SUM(AJ130:AL130)+AE130","v":33.700000000000003},null,null,{"$f":"ROUND(AC130/(1-VLOOKUP(AF130,Group,2,FALSE)),2)","v":33.700000000000003},{"$f":"IF(VLOOKUP(AF130,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ130,1)-AJ130,2),Round,2,FALSE)+VLOOKUP(AF130,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,7,FALSE)=\"\",0,ROUND(AJ130-0.04999,1)-AJ130+AM130)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF130,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"3\" x 12\"",null,"Bullnose",null,null,"Honed",null,null,null,null,null,"15 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA132,AG132)","v":7.45},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA132*(1-W132)+0.004999,2)","v":7.45},null,"",7.45,{"$f":"+W132","v":0},{"$f":"+X132","v":7.45},{"$f":"(AG132-AC132)/AG132","v":0},null,2,{"$f":"SUM(AJ132:AL132)+AE132","v":7.45},null,null,{"$f":"ROUND(AC132/(1-VLOOKUP(AF132,Group,2,FALSE)),2)","v":7.45},{"$f":"IF(VLOOKUP(AF132,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ132,1)-AJ132,2),Round,2,FALSE)+VLOOKUP(AF132,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",0,ROUND(AJ132-0.04999,1)-AJ132+AM132)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF132,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"6\" x 12\"",null,"Cove Base",null,null,"Honed",null,null,null,null,null,"8 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA133,AG133)","v":25.15},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA133*(1-W133)+0.004999,2)","v":25.15},null,"YES",25.15,{"$f":"+W133","v":0},{"$f":"+X133","v":25.15},{"$f":"(AG133-AC133)/AG133","v":0},null,2,{"$f":"SUM(AJ133:AL133)+AE133","v":25.15},null,null,{"$f":"ROUND(AC133/(1-VLOOKUP(AF133,Group,2,FALSE)),2)","v":25.15},{"$f":"IF(VLOOKUP(AF133,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ133,1)-AJ133,2),Round,2,FALSE)+VLOOKUP(AF133,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",0,ROUND(AJ133-0.04999,1)-AJ133+AM133)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF133,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"SHEN - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","FISN",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:","Balance Grey",null,"      Essence",null,null,"    Natural",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Bamboo",null,"      Graylake",null,null,"    White Shades",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,"Rectified",null,null,null,null,null,"15.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA140,AG140)","v":8.6},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA140*(1-W140)+0.004999,2)","v":8.6},null,"YES",8.6,{"$f":"+W140","v":0},8.6,{"$f":"(AG140-AC140)/AG140","v":0},null,1,{"$f":"SUM(AJ140:AL140)+AE140","v":8.6},null,null,{"$f":"ROUND(AC140/(1-VLOOKUP(AF140,Group,2,FALSE)),2)","v":8.6},{"$f":"IF(VLOOKUP(AF140,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ140,1)-AJ140,2),Round,2,FALSE)+VLOOKUP(AF140,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",0,ROUND(AJ140-0.04999,1)-AJ140+AM140)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF140,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,"Rectified",null,null,null,null,null,"31.67 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA141,AG141)","v":10.199999999999999},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA141*(1-W141)+0.004999,2)","v":10.199999999999999},null,"",10.199999999999999,0,10.199999999999999,{"$f":"(AG141-AC141)/AG141","v":0},null,1,{"$f":"SUM(AJ141:AL141)+AE141","v":10.199999999999999},null,null,{"$f":"ROUND(AC141/(1-VLOOKUP(AF141,Group,2,FALSE)),2)","v":10.199999999999999},{"$f":"IF(VLOOKUP(AF141,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ141,1)-AJ141,2),Round,2,FALSE)+VLOOKUP(AF141,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,7,FALSE)=\"\",0,ROUND(AJ141-0.04999,1)-AJ141+AM141)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF141,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,"5 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA143,AG143)","v":34.049999999999997},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA143*(1-W143)+0.004999,2)","v":34.049999999999997},null,"YES",34.049999999999997,{"$f":"+W143","v":0},{"$f":"+X143","v":34.049999999999997},{"$f":"(AG143-AC143)/AG143","v":0},null,3,{"$f":"SUM(AJ143:AL143)+AE143","v":34.049999999999997},null,null,{"$f":"ROUND(AC143/(1-VLOOKUP(AF143,Group,2,FALSE)),2)","v":34.049999999999997},{"$f":"IF(VLOOKUP(AF143,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ143,1)-AJ143,2),Round,2,FALSE)+VLOOKUP(AF143,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",0,ROUND(AJ143-0.04999,1)-AJ143+AM143)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF143,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"4\" x 24\"",null,"Bullnose",null,null,null,null,null,null,null,null,"16 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA145,AG145)","v":15.75},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA145*(1-W145)+0.004999,2)","v":15.75},null,"YES",15.75,{"$f":"+W145","v":0},{"$f":"+X145","v":15.75},{"$f":"(AG145-AC145)/AG145","v":0},null,2,{"$f":"SUM(AJ145:AL145)+AE145","v":15.75},null,null,{"$f":"ROUND(AC145/(1-VLOOKUP(AF145,Group,2,FALSE)),2)","v":15.75},{"$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,"Trim",null,null,"6\" x 12\"",null,"Cove Base",null,null,null,null,null,null,null,null,"8 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA146,AG146)","v":25.15},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA146*(1-W146)+0.004999,2)","v":25.15},null,"YES",25.15,{"$f":"+W146","v":0},{"$f":"+X146","v":25.15},{"$f":"(AG146-AC146)/AG146","v":0},null,2,{"$f":"SUM(AJ146:AL146)+AE146","v":25.15},null,null,{"$f":"ROUND(AC146/(1-VLOOKUP(AF146,Group,2,FALSE)),2)","v":25.15},{"$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,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[null,null,null," "]
[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,null,null," "]
[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":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page","http://www.granitifiandre.com/"]
[]
[]
["Product","Direct Website Link"]
["French Clay","http://www.granitifiandre.com/porcelain-tile/made-in-usa/french-clay/"]
["LOL"]
["May"]
["Royal Marble","https://www.granitifiandre.com/porcelain-tile/royal-marble"]
["Royal Marble Maximum","https://www.granitifiandre.com/porcelain-slab/royal-marble-maximum"]
["Shellstone","http://www.granitifiandre.com/porcelain-tile/made-in-usa/shellstone/",null,"  "]
["Shen","http://www.granitifiandre.com/porcelain-tile/made-in-usa/shen/"]

{"sheet":"Changes","index":4,"n_rows":120,"n_cols":4,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
["2014-12-24","Butcher Block","Glazed Porcelain"]
["2014-12-24","French Clay","Glazed Porcelain Floor"]
["2014-12-24","French Clay","Glazed Ceramic Wall"]
["2014-12-24","Link","Unglazed Porcelain"]
["2014-12-24","Metropolis","Glazed Porcelain"]
["2014-12-24","New Marmi","Unglazed Porcelain"]
["2014-12-24","New Stone","Unglazed Porcelain"]
["2014-12-24","Nihon","Glazed Porcelain"]
["2014-12-24","Origins","Unglazed Porcelain"]
["2014-12-24","Shellstone","Glazed Porcelain"]
["2014-12-24","Silk Road","Glazed Porcelain"]
["2014-12-24","Unicolor","Glazed Porcelain"]
["2015-06-29","Harmony","Glazed Porcelain"]
["2015-06-29","Maximum","Thin Porcelain"]
["2016-08-08","Designer Woods","Glazed Porcelain"]
["2016-08-08","G Stone","Unglazed Porcelain"]
["2016-08-08","Maze","Glazed Porcelain"]
["2016-08-08","New Marmi","12\" x 24\" Honed Brick Mosaic and 12\" x 12\" Honed Stair Tread added to series."]
["2016-08-08","Shellstone","Multicolor 1\" x 2\" Brick Random Mix Mosaic added to series."]
["2016-08-08","Silk Road","2\" x 2\" Mosaic added and is available in color Wild Silk only.  6\" x 12\" Cove Base added and is available in both Soft Silk and Wild Silk colors. "]
["2017-05-31","Approach","Glazed Porcelain"]
["2017-05-31","Desire","Glazed Porcelain Floor & Glazed Ceramic Wall"]
["2017-05-31","LOL","Glazed Ceramic Wall"]
["2017-05-31","Marble Lab","Glazed Porcelain"]
["2017-05-31","Maximum","New Marmi colors added and are available in select formats:  Marmi Calacatta Elite, Marmi Calacatta Light, Marmi Glam Bronze, Marmi Pietra Grey, Marmi Premium White, Marmi Premium White A, Marmi Premium White B and Marmi Quarzo Greige.  Pre-polished finish added to Mega and HG. Resin colors in select formats.  Colors Agata Azzurra B, C, E & G and Frapuccino A, B, C & D added to the Precious Stones Colors."]
["2017-05-31","MAY","Glazed Ceramic Wall"]
["2017-05-31","Tao","Glazed Porcelain"]
["2017-05-31","Westloop","Glazed Porcelain"]
["2018-06-07","Dwood 2.0","Glazed Porcelain"]
["2018-06-07","Maximum","Colors Eminent Wood Brown, Eminent Wood Grey and Dark Marquina added."]
["2018-06-07","Tao","9\" x 36\" and 18\" x 36\" Field Tile formats added in both Honed and Semi-Polished finishes.  (Replacing the 8\" x 48\" and 24\" x 48\" Field Tile formats.)  Color Black added and is available in all formats."]
["2019-06-27","Maximum","Colors Eminent Wood Brown, Eminent Wood Grey, Marmi Glam Bronze and Marmi Pietra Grey now available in the Satin finish."]
["2019-06-27","Royal Marble","Glazed Porcelain, available in both 6mm and 8mm thicknesses."]
["2020-09-11","Core Shade","Glazed Porcelain."]
["2020-09-11","Fahrenheit","Glazed Porcelain."]
["2020-09-11","Marble Lab","Colors Atlantic Grey and Nero Marquina added to series."]
["2020-09-11","Maximum","Several Colors and Field Tile formats added."]
["2021-08-27","Maximum","New Marmi color added and is available in select formats:  Marmi Marbre De Savoie."]
["2021-10-01","Marble Lab","Colors Arabescato Orobico and Calacatta Bellissimo added to the collection.  Matte Field Tile and Stair Tread formats added."]
["2021-10-01","Maximum","Colors Aster Rusty, Il Veneziano Seminato Beige, Il Veneziano Seminato Candido, Il Veneziano Seminato Nero, Marmi Calacatta Dorato, Marmi Deep Emperador, Marmi Ethereal Travertino, Marmi Finest Estremoz, Marmi Pure Calacatta, Pietre Luna Limestone, Pietre Quarzite Vals and Pietre Roccia Di Lucca added to the collection."]
[]
[]
[]
["Discontinued Products"]
["2016-08-08","Butcher Block","4\" x 12\" Bullnose format."]
["2016-08-08","Link","Entire Series."]
["2016-08-08","Metropolis","24\" x 24\" Field Tile format in all colors."]
["2016-08-08","New Marmi","Colors Dark Gray, Partenon, Taupe Gray and Toros Black in all formats."]
["2016-08-08","New Stone","Color Carbone in all formats, 6\" x 24\" Field Tile and 6\" x 12\" Bullnose formats in all colors."]
["2016-08-08","Nihon","2\" x 24\" Field Tile format in all colors."]
["2016-08-08","Origins","12\" x 12\" Polished Field Tile format in all colors."]
["2016-08-08","Silk Road","Colors Natural Silk and Raw Silk in all formats."]
["2017-05-31","Maximum","Color Marmi Michelangelo Statuario in all formats. Colors Natura Bistro, Natura Castagno, Natura Cenere, Natura Frassino and Natura Magnolia in all formats. "]
["2017-11-17","Nihon","Color Goma in all formats.  24\" x 24\" Field Tile format in all colors."]
["2017-12-15","Butcher Block","Entire Series."]
["2017-12-15","French Clay","24\" x 24\" Brilliant finish Field Tile format in all colors."]
["2017-12-15","Metropolis","Color Noir in all formats."]
["2017-12-15","Nihon","Color Tatami in all formats."]
["2017-12-15","Origins","Entire Series."]
["2017-12-15","Shellstone","18\" x 36\" Field Tile format in all colors."]
["2017-12-15","Silk Road","24\" x 24\" Field Tile format in all colors."]
["2018-03-29","Nihon","2\" x 2\" and Bamboo Mosaic in all colors and the Multicolor 1\" x 2\" Brick Random Mix Mosaic."]
["2018-06-07","Approach","Colors Light Gray and Sand in all formats."]
["2018-06-07","Designer Woods","Entire Series."]
["2018-06-07","Maximum","Colors Aster Uranus and Marmi Quarzo Greige in all formats.  Colors Marmi Premium White/A Honed and Marmi Premium White/B Honed in the 120\" x 60\" x 6mm format.  Color Marmi Royal Marfil in the 40\" x 40\" x 6mm, 60\" x 40\" x 6mm & 120\" x 40\" x 6mm Field Tile formats in both the Honed and Polished finishes."]
["2018-06-07","Tao","8\" x 48\" and 24\" x 48\" Field Tile formats in all colors & finishes.  (Replaced with the 9\" x 36\" and 18\" x 36\" Field Tile formats.)  Colors Dark Grey and Taupe in all formats and finishes.  12\" x 24\" Multisize Honed Mosaic in all colors."]
["2019-03-08","Maze","Entire Series."]
["2019-03-08","Nihon","Entire Series."]
["2019-06-27","Maximum","Colors HQ.Resin Cinder Resin, HQ.Resin Dark Resin,HQ.Resin Grey Resin & HQ.Resin White Resin in the Pre-polished surface only in all formats."]
["2019-06-27","New Stone","Entire Series."]
["2019-06-27","Shellstone","All colors and formats in the Flamed surface only."]
["2020-06-12","Approach","Entire Series.","Discontinued by Fiandre"]
["2020-06-12","DWood 2.0","Entire Series.","Discontinued by Fiandre"]
["2020-06-12","Silk Road","Entire Series.","Discontinued by Fiandre"]
["2020-06-12","Tao","Entire Series.","Discontinued by Fiandre"]
["2020-06-12","West Loop","Entire Series.","Discontinued by Fiandre"]
["2020-09-11","Desire","8\" x 48\" and 12\" x 48\" Field Tile formats only in all colors & finishes.","Discontinued by Fiandre"]
["2020-09-11","G Stone","Entire Series.","Discontinued by Fiandre"]
["2020-09-11","Maximum Aster","30\" x 15\" x 6mm, 30\" x 30\" x 6mm, 60\" x 30\" x 6mm, 60\" x 60\" x 6mm & 120\" x 60\" x 6mm Field Tile formats in all Aster colors; Aster Mercury, Aster Moon & Aster Venus.","Discontinued by Fiandre"]
["2020-09-11","Maximum Marmi","Color Marmi Nero Supremo in all fomats.","Discontinued by Fiandre"]
["2021-08-27","Desire","All Glazed Ceramic Wall Tile formats; 8\" x 8\", 4\" x 12\" and 8\" x 24\" Field Tile and all Deco's in these sizes.","Discontinued by Fiandre"]
["2021-09-08","Desire","Entire Series.  (All remaining Glazed Porcelain Floor formats.)","Discontinued by CCTD"]
["2021-10-01","Maximum","Colors Marmi Atlantic Grey, Marmi Calacatta Elite, Marmi Grey Beauty, Marmi Soft Onyx and Rock Salt Pink Rock Salt in all fomats.  All Precious Stones colors and formats.  40\" x 40\" x 6mm and 100\" x 40\" x 6mm formats in colors Marmi Calacatta Bellissimo, Marmi Pietra Grey and Marmi Premium White in both Honed and Polished formats.","Discontinued by Fiandre"]
["2021-10-01","Marble Lab","Colors Bianco Striato and Nero Portoro only in all formats.","Discontinued by Fiandre"]
["2021-10-01","Royal Marble","30\" x 60\" x 6mm, 60\" x 60\" x 6mm and 60\" x 120\" x 6mm Honed Finish only in all colors.","Discontinued by Fiandre"]
["2022-04-11","Marble Lab","Colors Atlantic Grey, Calacatta Elite, Noble Ecru and Quarzo Greige only in all formats.","Discontinued by Fiandre"]
["(3/16/2022","Desire","Entire Series.","Discontinued by Fiandre)"]
["2022-07-25","French Clay","24\" x 24\" Field Tile format only in all colors.","Discontinued by Fiandre"]
["2022-07-25","Royal Marble","24\" x 24\" Field Tile format only in all colors & finishes.","Discontinued by Fiandre"]
["2022-08-24","French Clay","12\" x 24\" Brilliant finish Field Tile, 3\" x 6\" Mosaic Brilliant finish & 3\" x 24\" Bullnose Brilliant finish formats only in all colors.","Discontinued by Fiandre"]
["2022-08-24","Metropolis","Entire Series.","Discontinued by Fiandre"]
["2022-08-24","New Marmi","Entire Series.","Discontinued by Fiandre"]
["2022-08-24","Shen","12\" x 48\" Field Tile format only in all colors.","Discontinued by Fiandre"]
["2022-08-24","Unicolor","12\" x 12\" Field Tile format only in all colors.","Discontinued by Fiandre"]
["2022-08-24","Maximum (Aster)","Color Aster Rusty only in all formats.","Discontinued by Fiandre"]
["2022-08-24","Maximum (Eminent Wood)","All colors, formats and finishes.","Discontinued by Fiandre"]
["2022-08-24","Maximum (Marmi)","Colors Azul Macaubus, Finest Estremoz and Royal Marfil only in all formats and finishes.","Discontinued by Fiandre"]
["2022-08-24","Maximum (Rock Salt)","All colors, formats and finishes.","Discontinued by Fiandre"]
["2023-01-17","French Clay","4\" x 12\" Wall Field Tile and 4\" x 12\" Wall Bullnose formats only in all colors.","Discontinued by Fiandre"]
["2023-01-17","Unicolor","Entire Series.","Discontinued by Fiandre"]
["2023-11-20","Core Shade","All formats in the Slate finish only.","Discontinued by Fiandre"]
["2023-11-20","Marble Lab","12\" x 24\" Field Tile format in all colors and finishes.","Discontinued by Fiandre"]
["2023-11-20","Maximum (Agata)","Color Atena only in all formats.","Discontinued by Fiandre"]
["2023-11-20","Maximum (Marmi)","Color Imperial White only in all formats. Colors Calacatta and Taxos only in the 40\" x 40\" x 6mm, 60\" x 40\" x 6mm and 120\" x 40\" x 6mm Field Tile formats only in both the Honed and Polished (Bright) finishes.","Discontinued by Fiandre"]
["2023-11-20","Shen","8\" x 48\" Field Tile format only in all colors.","Discontinued by Fiandre"]
["2024-05-29","Core Shade","Entire Series."]
["2024-05-29","Fahrenheit","Entire Series."]
["2024-05-29","Marble Lab","Entire Series."]
["2024-05-29","Maximum","Entire Series."]
["2024-05-29","Royal Marble Maximum","Colors Royal Beige, Royal Black, Royal Grey Cross Cut and Royal Light only in all the 6mm thick formats."]
[]
[]
[]
["Changes:"]
["2016-04-08","Harmony","Name of series has changed to Shen."]
["2017-06-08","Nihon","Packaging will be changing for the 4\" x 24\" Field Tile format from 9.09 SF/CTN to 11.68 SF/CTN as inventory with old packaging is depleted.  "]