{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Changes"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Bati Orient"]
["File as","B"]
["Product Code","N"]
["CCTD Effective Date","2/1/23"]
[]
[]
[]
["Enter your Company Name",null,"In-House Distribution Only"]
[]
[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":"N"}]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0]
[null,2,null,"Trim",null,"No",0]
[null,3,null,"Decos",null,"No",0]
[null,4,null,0,null,"No",0]
[null,5,null,0,null,"No",0,null,null,null," "]
[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 'B' - Bati Orient"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 2/1/23"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This price list is available electronically on an Excel spreadsheet.  If you would like to obtain a copy, please email Conestoga Tile at service@cctd.com."]
[]
["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":110,"n_cols":41,"rows_kept":110,"cut":false,"hidden":false,"merged":[[12,14,12,19],[9,14,9,19],[95,2,95,19],[92,2,92,19],[14,13,15,19],[10,14,10,15],[99,3,99,4],[18,2,18,19],[17,14,17,15],[90,2,90,19],[13,30,13,32],[9,22,9,23],[9,25,9,32],[12,22,12,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},"SF",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA1*(1-W1)+0.004999,2)","v":0},null,"new",0,{"$f":"+W1","v":0},0,{"$f":"(AG1-AC1)/AG1","v":{"$error":"#DIV/0!"}},null,1,{"$f":"SUM(AJ1:AL1)+AE1","v":0},null,null,{"$f":"ROUND(AC1/(1-VLOOKUP(AF1,Group,2,FALSE)),2)","v":0},{"$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},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,2,0,null,null,0,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":"N"},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":"N"},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":"N"},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":"N"},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":"N"},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":"Net Price"},"U/M","Code",null,"Disc.","Net",null,"Chg","Net 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 'B' - Bati Orient"},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":"2/1/23"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-01-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":"In-House Distribution 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,"X"]
[null,null,{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code 'N'"},null,null,null,null,null,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":"In-House Distribution Only"},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":"Net Price"},"U/M",{"$f":"+U$11","v":"Code"},null,"Disc.","Net",null,"Chg","Net 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,"PRICING LISTED IS NET PRICING. TRADE DISCOUNTS DO NOT APPLY.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"WASHBASINS",null,null,null,null,null,null," ",null," ",null,null,null,null,null,"Item # Lookup:","BOWB",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,"Glazed Lava Washbasins",null,null,null,null,null,null,null," ",null,null,null,null,null,null,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,"Ethnic Bowl Washbasins:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Decos",null,null,"20\" x 5\"",null,"Washbasin",null,null,null,"LABL01 - Azur Blue (Glazed Interior)",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA27,AG27)","v":1795.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA27*(1-W27)+0.004999,2)","v":1795.7},null,"YES",1795.7,{"$f":"+W27","v":0},1795.7,{"$f":"(AG27-AC27)/AG27","v":0},null,3,{"$f":"SUM(AJ27:AL27)+AE27","v":1795.7},null,null,{"$f":"ROUND(AC27/(1-VLOOKUP(AF27,Group,2,FALSE)),2)","v":1795.7},{"$f":"IF(VLOOKUP(AF27,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ27,1)-AJ27,2),Round,2,FALSE)+VLOOKUP(AF27,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF27,Group,7,FALSE)=\"\",0,ROUND(AJ27-0.04999,1)-AJ27+AM27)","v":0},{"$f":"IF(VLOOKUP(AF27,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF27,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"20\" x 5\"",null,"Washbasin",null,null,null,"LAFA01 - Beige (Glazed Interior)",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA28,AG28)","v":1795.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA28*(1-W28)+0.004999,2)","v":1795.7},null,"YES",1795.7,0,1795.7,{"$f":"(AG28-AC28)/AG28","v":0},null,3,{"$f":"SUM(AJ28:AL28)+AE28","v":1795.7},null,null,{"$f":"ROUND(AC28/(1-VLOOKUP(AF28,Group,2,FALSE)),2)","v":1795.7},{"$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,"Decos",null,null,"20\" x 5\"",null,"Washbasin",null,null,null,"LANO01 - Ebony (Glazed Interior)",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA29,AG29)","v":1795.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA29*(1-W29)+0.004999,2)","v":1795.7},null,"YES",1795.7,0,1795.7,{"$f":"(AG29-AC29)/AG29","v":0},null,3,{"$f":"SUM(AJ29:AL29)+AE29","v":1795.7},null,null,{"$f":"ROUND(AC29/(1-VLOOKUP(AF29,Group,2,FALSE)),2)","v":1795.7},{"$f":"IF(VLOOKUP(AF29,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ29,1)-AJ29,2),Round,2,FALSE)+VLOOKUP(AF29,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF29,Group,7,FALSE)=\"\",0,ROUND(AJ29-0.04999,1)-AJ29+AM29)","v":0},{"$f":"IF(VLOOKUP(AF29,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF29,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"20\" x 5\"",null,"Washbasin",null,null,null,"LATA01 - Taupe (Glazed Interior)",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA30,AG30)","v":1795.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA30*(1-W30)+0.004999,2)","v":1795.7},null,"YES",1795.7,0,1795.7,{"$f":"(AG30-AC30)/AG30","v":0},null,3,{"$f":"SUM(AJ30:AL30)+AE30","v":1795.7},null,null,{"$f":"ROUND(AC30/(1-VLOOKUP(AF30,Group,2,FALSE)),2)","v":1795.7},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Ethnic Cylindric Washbasins:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Decos",null,null,"20\" x 4\"",null,"Washbasin",null,null,null,"LABL02 - Azur Blue (Glazed Interior)",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA34,AG34)","v":1796.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA34*(1-W34)+0.004999,2)","v":1796.5},null,"YES",1796.5,{"$f":"+W34","v":0},1796.5,{"$f":"(AG34-AC34)/AG34","v":0},null,3,{"$f":"SUM(AJ34:AL34)+AE34","v":1796.5},null,null,{"$f":"ROUND(AC34/(1-VLOOKUP(AF34,Group,2,FALSE)),2)","v":1796.5},{"$f":"IF(VLOOKUP(AF34,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ34,1)-AJ34,2),Round,2,FALSE)+VLOOKUP(AF34,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF34,Group,7,FALSE)=\"\",0,ROUND(AJ34-0.04999,1)-AJ34+AM34)","v":0},{"$f":"IF(VLOOKUP(AF34,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF34,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"20\" x 4\"",null,"Washbasin",null,null,null,"LAFA02 - Beige (Glazed Interior)",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA35,AG35)","v":1796.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":1796.5},null,"YES",1796.5,0,1796.5,{"$f":"(AG35-AC35)/AG35","v":0},null,3,{"$f":"SUM(AJ35:AL35)+AE35","v":1796.5},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":1796.5},{"$f":"IF(VLOOKUP(AF35,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ35,1)-AJ35,2),Round,2,FALSE)+VLOOKUP(AF35,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",0,ROUND(AJ35-0.04999,1)-AJ35+AM35)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF35,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"20\" x 4\"",null,"Washbasin",null,null,null,"LANO02 - Ebony (Glazed Interior)",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA36,AG36)","v":1796.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":1796.5},null,"YES",1796.5,0,1796.5,{"$f":"(AG36-AC36)/AG36","v":0},null,3,{"$f":"SUM(AJ36:AL36)+AE36","v":1796.5},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":1796.5},{"$f":"IF(VLOOKUP(AF36,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ36,1)-AJ36,2),Round,2,FALSE)+VLOOKUP(AF36,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF36,Group,7,FALSE)=\"\",0,ROUND(AJ36-0.04999,1)-AJ36+AM36)","v":0},{"$f":"IF(VLOOKUP(AF36,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF36,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"20\" x 4\"",null,"Washbasin",null,null,null,"LATA02 - Taupe (Glazed Interior)",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA37,AG37)","v":1796.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":1796.5},null,"YES",1796.5,0,1796.5,{"$f":"(AG37-AC37)/AG37","v":0},null,3,{"$f":"SUM(AJ37:AL37)+AE37","v":1796.5},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":1796.5},{"$f":"IF(VLOOKUP(AF37,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ37,1)-AJ37,2),Round,2,FALSE)+VLOOKUP(AF37,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",0,ROUND(AJ37-0.04999,1)-AJ37+AM37)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF37,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Marble Washbasins",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Ethnic Washbasins:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Decos",null,null,"16-1/4\" x 6\"",null,"Washbasin",null,null,null,"MABL54 - White",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA43,AG43)","v":820.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA43*(1-W43)+0.004999,2)","v":820.05},null,"YES",820.05,{"$f":"+W43","v":0},820.05,{"$f":"(AG43-AC43)/AG43","v":0},null,3,{"$f":"SUM(AJ43:AL43)+AE43","v":820.05},null,null,{"$f":"ROUND(AC43/(1-VLOOKUP(AF43,Group,2,FALSE)),2)","v":820.05},{"$f":"IF(VLOOKUP(AF43,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ43,1)-AJ43,2),Round,2,FALSE)+VLOOKUP(AF43,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF43,Group,7,FALSE)=\"\",0,ROUND(AJ43-0.04999,1)-AJ43+AM43)","v":0},{"$f":"IF(VLOOKUP(AF43,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF43,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"16-1/4\" x 6\"",null,"Washbasin",null,null,null,"MAGR45 - Grey",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA44,AG44)","v":820.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA44*(1-W44)+0.004999,2)","v":820.05},null,"YES",820.05,0,820.05,{"$f":"(AG44-AC44)/AG44","v":0},null,3,{"$f":"SUM(AJ44:AL44)+AE44","v":820.05},null,null,{"$f":"ROUND(AC44/(1-VLOOKUP(AF44,Group,2,FALSE)),2)","v":820.05},{"$f":"IF(VLOOKUP(AF44,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ44,1)-AJ44,2),Round,2,FALSE)+VLOOKUP(AF44,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",0,ROUND(AJ44-0.04999,1)-AJ44+AM44)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF44,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"16-1/4\" x 6\"",null,"Washbasin",null,null,null,"MANO39 - Black",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA45,AG45)","v":966.6},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA45*(1-W45)+0.004999,2)","v":966.6},null,"YES",966.6,0,966.6,{"$f":"(AG45-AC45)/AG45","v":0},null,3,{"$f":"SUM(AJ45:AL45)+AE45","v":966.6},null,null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":966.6},{"$f":"IF(VLOOKUP(AF45,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ45,1)-AJ45,2),Round,2,FALSE)+VLOOKUP(AF45,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF45,Group,7,FALSE)=\"\",0,ROUND(AJ45-0.04999,1)-AJ45+AM45)","v":0},{"$f":"IF(VLOOKUP(AF45,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF45,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,"Striped Washbasins:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Decos",null,null,"16-3/8\" x 4-3/4\"",null,"Washbasin",null,null,null,"MABL73 - White",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA49,AG49)","v":791.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA49*(1-W49)+0.004999,2)","v":791.35},null,"YES",791.35,{"$f":"+W49","v":0},{"$f":"+X49","v":791.35},{"$f":"(AG49-AC49)/AG49","v":0},null,3,{"$f":"SUM(AJ49:AL49)+AE49","v":791.35},null,null,{"$f":"ROUND(AC49/(1-VLOOKUP(AF49,Group,2,FALSE)),2)","v":791.35},{"$f":"IF(VLOOKUP(AF49,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ49,1)-AJ49,2),Round,2,FALSE)+VLOOKUP(AF49,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF49,Group,7,FALSE)=\"\",0,ROUND(AJ49-0.04999,1)-AJ49+AM49)","v":0},{"$f":"IF(VLOOKUP(AF49,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF49,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"16-3/8\" x 4-3/4\"",null,"Washbasin",null,null,null,"MANO55 - Black",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA50,AG50)","v":791.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA50*(1-W50)+0.004999,2)","v":791.35},null,"YES",791.35,{"$f":"+W50","v":0},{"$f":"+X50","v":791.35},{"$f":"(AG50-AC50)/AG50","v":0},null,3,{"$f":"SUM(AJ50:AL50)+AE50","v":791.35},null,null,{"$f":"ROUND(AC50/(1-VLOOKUP(AF50,Group,2,FALSE)),2)","v":791.35},{"$f":"IF(VLOOKUP(AF50,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ50,1)-AJ50,2),Round,2,FALSE)+VLOOKUP(AF50,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF50,Group,7,FALSE)=\"\",0,ROUND(AJ50-0.04999,1)-AJ50+AM50)","v":0},{"$f":"IF(VLOOKUP(AF50,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF50,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,"Petrified Wood Washbasin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Decos",null,null,"Max 28\" x 6\"",null,"Washbasin",null,null,null,"BOBO02 - Petrified Wood (Various Shapes)",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA54,AG54)","v":2004.25},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA54*(1-W54)+0.004999,2)","v":2004.25},null,"YES",2004.25,{"$f":"+W54","v":0},{"$f":"+X54","v":2004.25},{"$f":"(AG54-AC54)/AG54","v":0},null,3,{"$f":"SUM(AJ54:AL54)+AE54","v":2004.25},null,null,{"$f":"ROUND(AC54/(1-VLOOKUP(AF54,Group,2,FALSE)),2)","v":2004.25},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Rock Washbasin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Decos",null,null,"Max 24\" x 6\"",null,"Washbasin",null,null," ","MAGR46 - Rock (Various Shapes)",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA58,AG58)","v":776.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA58*(1-W58)+0.004999,2)","v":776.4},null,"YES",776.4,{"$f":"+W58","v":0},{"$f":"+X58","v":776.4},{"$f":"(AG58-AC58)/AG58","v":0},null,3,{"$f":"SUM(AJ58:AL58)+AE58","v":776.4},null,null,{"$f":"ROUND(AC58/(1-VLOOKUP(AF58,Group,2,FALSE)),2)","v":776.4},{"$f":"IF(VLOOKUP(AF58,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ58,1)-AJ58,2),Round,2,FALSE)+VLOOKUP(AF58,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF58,Group,7,FALSE)=\"\",0,ROUND(AJ58-0.04999,1)-AJ58+AM58)","v":0},{"$f":"IF(VLOOKUP(AF58,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF58,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,"Washbasins with Pedestal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Conical Washbasins with Hammered Pedestal",null,null,null,null,null,null,null,null,null," ",null,null,null,null,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,"Decos",null,null,"16\" x 36\"",null,"Washbasin",null,null,null,"MABL29 - White",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA64,AG64)","v":1807.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":1807.35},null,"YES",1807.35,{"$f":"+W64","v":0},1807.35,{"$f":"(AG64-AC64)/AG64","v":0},null,3,{"$f":"SUM(AJ64:AL64)+AE64","v":1807.35},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":1807.35},{"$f":"IF(VLOOKUP(AF64,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ64,1)-AJ64,2),Round,2,FALSE)+VLOOKUP(AF64,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",0,ROUND(AJ64-0.04999,1)-AJ64+AM64)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF64,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"16\" x 36\"",null,"Washbasin",null,null,null,"MAGR29 - Grey",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":1807.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":1807.35},null,"YES",1807.35,0,1807.35,{"$f":"(AG65-AC65)/AG65","v":0},null,3,{"$f":"SUM(AJ65:AL65)+AE65","v":1807.35},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":1807.35},{"$f":"IF(VLOOKUP(AF65,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ65,1)-AJ65,2),Round,2,FALSE)+VLOOKUP(AF65,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",0,ROUND(AJ65-0.04999,1)-AJ65+AM65)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF65,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"16\" x 36\"",null,"Washbasin",null,null,null,"MANO29 - Black",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":2041.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA66*(1-W66)+0.004999,2)","v":2041.9},null,"YES",2041.9,0,2041.9,{"$f":"(AG66-AC66)/AG66","v":0},null,3,{"$f":"SUM(AJ66:AL66)+AE66","v":2041.9},null,null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":2041.9},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Conical Washbasins with Striped Pedestal",null,null,null,null,null,null,null,null,null," ",null,null,null,null,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,"Decos",null,null,"16\" x 36\"",null,"Washbasin",null,null,null,"MABL30 - White",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA70,AG70)","v":1807.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA70*(1-W70)+0.004999,2)","v":1807.35},null,"YES",1807.35,{"$f":"+W70","v":0},1807.35,{"$f":"(AG70-AC70)/AG70","v":0},null,3,{"$f":"SUM(AJ70:AL70)+AE70","v":1807.35},null,null,{"$f":"ROUND(AC70/(1-VLOOKUP(AF70,Group,2,FALSE)),2)","v":1807.35},{"$f":"IF(VLOOKUP(AF70,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ70,1)-AJ70,2),Round,2,FALSE)+VLOOKUP(AF70,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF70,Group,7,FALSE)=\"\",0,ROUND(AJ70-0.04999,1)-AJ70+AM70)","v":0},{"$f":"IF(VLOOKUP(AF70,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF70,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"16\" x 36\"",null,"Washbasin",null,null,null,"MAGR30 - Grey",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA71,AG71)","v":1807.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":1807.35},null,"YES",1807.35,0,1807.35,{"$f":"(AG71-AC71)/AG71","v":0},null,3,{"$f":"SUM(AJ71:AL71)+AE71","v":1807.35},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":1807.35},{"$f":"IF(VLOOKUP(AF71,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ71,1)-AJ71,2),Round,2,FALSE)+VLOOKUP(AF71,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",0,ROUND(AJ71-0.04999,1)-AJ71+AM71)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF71,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"16\" x 36\"",null,"Washbasin",null,null,null,"MANO30 - Black",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA72,AG72)","v":2041.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA72*(1-W72)+0.004999,2)","v":2041.9},null,"YES",2041.9,0,2041.9,{"$f":"(AG72-AC72)/AG72","v":0},null,3,{"$f":"SUM(AJ72:AL72)+AE72","v":2041.9},null,null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":2041.9},{"$f":"IF(VLOOKUP(AF72,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ72,1)-AJ72,2),Round,2,FALSE)+VLOOKUP(AF72,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",0,ROUND(AJ72-0.04999,1)-AJ72+AM72)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF72,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Square Washbasins with Striped Trapezoidal Pedestal",null,null,null,null,null,null,null,null,null," ",null,null,null,null,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,"Decos",null,null,"16\" x 16\" x 36\"",null,"Washbasin",null,null,null,"MABL48 - White",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA76,AG76)","v":1807.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":1807.35},null,"YES",1807.35,{"$f":"+W76","v":0},1807.35,{"$f":"(AG76-AC76)/AG76","v":0},null,3,{"$f":"SUM(AJ76:AL76)+AE76","v":1807.35},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":1807.35},{"$f":"IF(VLOOKUP(AF76,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ76,1)-AJ76,2),Round,2,FALSE)+VLOOKUP(AF76,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",0,ROUND(AJ76-0.04999,1)-AJ76+AM76)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF76,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"16\" x 16\" x 36\"",null,"Washbasin",null,null,null,"MAGR40 - Grey",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA77,AG77)","v":1807.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":1807.35},null,"YES",1807.35,0,1807.35,{"$f":"(AG77-AC77)/AG77","v":0},null,3,{"$f":"SUM(AJ77:AL77)+AE77","v":1807.35},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":1807.35},{"$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,"16\" x 16\" x 36\"",null,"Washbasin",null,null,null,"MANO36 - Black",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA78,AG78)","v":2041.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":2041.9},null,"YES",2041.9,0,2041.9,{"$f":"(AG78-AC78)/AG78","v":0},null,3,{"$f":"SUM(AJ78:AL78)+AE78","v":2041.9},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":2041.9},{"$f":"IF(VLOOKUP(AF78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ78,1)-AJ78,2),Round,2,FALSE)+VLOOKUP(AF78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",0,ROUND(AJ78-0.04999,1)-AJ78+AM78)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF78,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Square Reconstituted Washbasin with Striped Trapezoidal Pedestal",null,null,null,null,null,null,null,null,null," ",null,null,null,null,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,"Decos",null,null,"16-1/2\" x 16-1/2\" x 32\"",null,"Washbasin",null,null,null,"PIMI03 White w/Black Stripes",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA82,AG82)","v":2001.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":2001.05},null,"YES",2001.05,{"$f":"+W82","v":0},{"$f":"+X82","v":2001.05},{"$f":"(AG82-AC82)/AG82","v":0},null,3,{"$f":"SUM(AJ82:AL82)+AE82","v":2001.05},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":2001.05},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null," ",null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.  If you would like to obtain a copy, please email Conestoga Tile at service@cctd.com.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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."]
[]
["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","http://usa.bati-orient-import.com/us/home"]
[]
[]
["Product","Direct Website Link"]

{"sheet":"Changes","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
["2015-12-23","Glazed Lava Washbasins","20\" x 5\" Ethnic Bowl Washbasins available in glazed interior colors Azur Blue, Beige, Ebony & Taupe.  20\" x 4\" Ethnic Cylindric Washbasins available in glazed interior colors Azur Blue, Beige, Ebony & Taupe."]
["2016-06-06","Washbasins with Pedestal","PIMI03 White w/Black Stripes, 16-1/2\" x 16-1/2\" x 32\" Square Reconstituted Washbasin with Striped Trapezoidal Pedestal."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Discontinued Products"]