{"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":16,"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","Questech"]
["File as","Q"]
["Product Code","B"]
["CCTD Effective Date","5/1/22 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"B"}]
[]
[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,null,null,null,null,null,null," "]
[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,"Switch Plates",null,"No",0]
[null,5,null,"Fixtures",null,"No",0]
[null,6,null,"Niches",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":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[[5,0,5,10],[50,0,50,10],[52,0,52,10],[2,5,2,10]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'Q' - Questech"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 5/1/22 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[]
["1",null,"Dorset Collection CAST METAL - Decoratives - Classics"]
["1",null,"Dorset Collection CAST METAL - Mosaics"]
["1-2",null,"Dorset Collection CITY SCAPE - Cast Metal Linear Field"]
["2",null,"Dorset Collection CLASSIC METAL TILE - Cast Metal Field, Mosaics & Liners"]
["2",null,"Dorset Collection HIGH RELIEF LINER - Cast Stone Decorative"]
["2",null,"Dorset Collection JOLLY LINER - Cast Metal Decorative"]
[3,null,"Dorset Collection JOLLY LINER - Cast Stone Decorative"]
[3,null,"Dorset Collection GEO - Cast Metal Bath Accessories"]
[3,null,"Dorset Collection GEO - Cast Metal Retrofit Bath Accessories"]
[3,null,"Dorset Collection GEO - Cast Stone Bath Accessories"]
[3,null,"Dorset Collection GEO - Cast Stone Retrofit Bath Accessories"]
[4,null,"Dorset Collection METRO - Cast Metal Bath Accessories"]
[4,null,"Dorset Collection METRO - Cast Metal Retrofit Bath Accessories"]
[4,null,"Dorset Collection METRO - Cast Stone Bath Accessories"]
[4,null,"Dorset Collection METRO - Cast Stone Retrofit Bath Accessories"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"All Questech products are permanently protected by Q-Seal, a revolutionary lifetime sealer.  ",null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Q-Seal keeps your tiles and accessories looking as beautiful as the day they were installed."]
[null,null,"         *Guaranteed to be water and stain resistant for as long as you own your home."]
[null,null,"         *Features \"Ultra-Fresh\" antimicrobial protection that inhibits stain and odor-causing mold & mildew."]
[null,null,"         *Worry free cleaning; use Laticrete Stonetech products or any household cleaner."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":372,"n_cols":41,"rows_kept":372,"cut":false,"hidden":false,"merged":[[361,3,361,4],[18,2,18,19],[17,14,17,15],[356,2,356,19],[358,2,358,19],[20,2,20,19],[21,2,21,19],[10,14,10,15],[9,14,9,19],[9,22,9,23],[9,25,9,32],[14,13,15,19],[13,30,13,32],[12,22,12,23],[12,14,12,19]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA1*(1-W1)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W1","v":0},0.05,{"$f":"(AG1-AC1)/AG1","v":0},null,1,{"$f":"SUM(AJ1:AL1)+AE1","v":0.05},null,null,{"$f":"ROUND(AC1/(1-VLOOKUP(AF1,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF1,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ1,1)-AJ1,2),Round,2,FALSE)+VLOOKUP(AF1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",0,ROUND(AJ1-0.04999,1)-AJ1+AM1)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF1,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA2,AG2)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},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":"B"},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,"Switch Plates",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},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,"Fixtures",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},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,"Niches",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},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,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,7,0,null,null,0,0,0,"",null,"X"]
[null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","a",1000,"ABC",null,null,0.1,1000,null,"ABC",1000,0.1,1000,0.1,10,null,1000,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price List",null,null,null,null,null,null,null,"Cust. Cost",null,null,"Customer Cost Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",AA11,AG11)","v":"List Price"},"U/M","Code",null,"Disc.","Net",null,"Chg","List Price","Disc","Act. Cost","GP%","Adj.","Group","Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'Q' - Questech"},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":"5/1/22 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-07-19"},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 'B'"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$C$8=\"\",\"\",Instructions!$C$8)","v":""},null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"+S$11","v":"List Price"},"U/M",{"$f":"+U$11","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$11","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$11","v":"Group"},"Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,"ALL ITEMS MARKED WITH PACKAGING QUANTITY ARE SOLD IN MULTIPLES OF THAT QUANTITY ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"The Dorset Collection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"To order, indicate the item number followed by the color number, i.e. MD403-021 (Soho Field 021 Antique Bronze), M1D210-068 ( Clover Dot 068 Wrought Iron)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"CAST METAL - Decoratives - Classics",null,null,null,null,null,null," "," "," "," ",null,null,null,null,"Item # Lookup:","QCCM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","021 Antique Bronze",null,null,"  070 Dark Oil Rubbed Bronze",null,null,null,null,null,null,null,null,null,null,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,"024 Brushed Nickel",null,null,"  068 Wrought Iron",null,null,null,null,null,null,null,null,null,null,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,"4\" x 4\"",null,"MD403",null,null,null,"Soho Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA29,AG29)","v":8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA29*(1-W29)+0.004999,2)","v":8},null,"",8,{"$f":"+W29","v":0},{"$f":"+X29","v":8},{"$f":"(AG29-AC29)/AG29","v":0},null,3,{"$f":"SUM(AJ29:AL29)+AE29","v":8},null,null,{"$f":"ROUND(AC29/(1-VLOOKUP(AF29,Group,2,FALSE)),2)","v":8},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 4\"",null,"M1D213",null,null,null,"Clover Deco",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA31,AG31)","v":18.899999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":18.899999999999999},null,"",18.899999999999999,{"$f":"+W31","v":0},{"$f":"+X31","v":18.899999999999999},{"$f":"(AG31-AC31)/AG31","v":0},null,3,{"$f":"SUM(AJ31:AL31)+AE31","v":18.899999999999999},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":18.899999999999999},{"$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,"Decos",null,null,"2\" x 2\"",null,"M1D210",null,null,null,"Clover Dot",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA32,AG32)","v":9.9499999999999993},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":9.9499999999999993},null,"",9.9499999999999993,{"$f":"+W32","v":0},{"$f":"+X32","v":9.9499999999999993},{"$f":"(AG32-AC32)/AG32","v":0},null,3,{"$f":"SUM(AJ32:AL32)+AE32","v":9.9499999999999993},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":9.9499999999999993},{"$f":"IF(VLOOKUP(AF32,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ32,1)-AJ32,2),Round,2,FALSE)+VLOOKUP(AF32,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",0,ROUND(AJ32-0.04999,1)-AJ32+AM32)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF32,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,"Decos",null,null,"2\" x 2\"",null,"M1D211",null,null,null,"Damask Dot",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA34,AG34)","v":9.9499999999999993},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA34*(1-W34)+0.004999,2)","v":9.9499999999999993},null,"",9.9499999999999993,{"$f":"+W34","v":0},{"$f":"+X34","v":9.9499999999999993},{"$f":"(AG34-AC34)/AG34","v":0},null,3,{"$f":"SUM(AJ34:AL34)+AE34","v":9.9499999999999993},null,null,{"$f":"ROUND(AC34/(1-VLOOKUP(AF34,Group,2,FALSE)),2)","v":9.9499999999999993},{"$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,"2\" x 12\"",null,"M1L208",null,null,null,"Damask Border",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA35,AG35)","v":30.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":30.6},null,"",30.6,{"$f":"+W35","v":0},{"$f":"+X35","v":30.6},{"$f":"(AG35-AC35)/AG35","v":0},null,3,{"$f":"SUM(AJ35:AL35)+AE35","v":30.6},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":30.6},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1/2\" x 12\"",null,"ML400",null,null,null,"Soho Listel",null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA37,AG37)","v":7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":7},null,"",7,{"$f":"+W37","v":0},7,{"$f":"(AG37-AC37)/AG37","v":0},null,3,{"$f":"SUM(AJ37:AL37)+AE37","v":7},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":7},{"$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,"Decos",null,null,"1/2\" x 12\"",null,"ML401",null,null,null,"Soho Pencil",null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA38,AG38)","v":8.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":8.75},null,"",8.75,0,8.75,{"$f":"(AG38-AC38)/AG38","v":0},null,3,{"$f":"SUM(AJ38:AL38)+AE38","v":8.75},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":8.75},{"$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,"Decos",null,null,"3/4\" x 12\"",null,"ML402",null,null,null,"Soho Pencil",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA39,AG39)","v":12.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA39*(1-W39)+0.004999,2)","v":12.65},null,"",12.65,0,12.65,{"$f":"(AG39-AC39)/AG39","v":0},null,3,{"$f":"SUM(AJ39:AL39)+AE39","v":12.65},null,null,{"$f":"ROUND(AC39/(1-VLOOKUP(AF39,Group,2,FALSE)),2)","v":12.65},{"$f":"IF(VLOOKUP(AF39,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ39,1)-AJ39,2),Round,2,FALSE)+VLOOKUP(AF39,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF39,Group,7,FALSE)=\"\",0,ROUND(AJ39-0.04999,1)-AJ39+AM39)","v":0},{"$f":"IF(VLOOKUP(AF39,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF39,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1\" x 12\"",null,"M1L001",null,null,null,"Classic Liner",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA41,AG41)","v":12.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA41*(1-W41)+0.004999,2)","v":12.7},null,"",12.7,{"$f":"+W41","v":0},{"$f":"+X41","v":12.7},{"$f":"(AG41-AC41)/AG41","v":0},null,3,{"$f":"SUM(AJ41:AL41)+AE41","v":12.7},null,null,{"$f":"ROUND(AC41/(1-VLOOKUP(AF41,Group,2,FALSE)),2)","v":12.7},{"$f":"IF(VLOOKUP(AF41,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ41,1)-AJ41,2),Round,2,FALSE)+VLOOKUP(AF41,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF41,Group,7,FALSE)=\"\",0,ROUND(AJ41-0.04999,1)-AJ41+AM41)","v":0},{"$f":"IF(VLOOKUP(AF41,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF41,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"2\" x 12\"",null,"M1L004",null,null,null,"Classic Ogee",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA42,AG42)","v":31.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA42*(1-W42)+0.004999,2)","v":31.3},null,"",31.3,{"$f":"+W42","v":0},{"$f":"+X42","v":31.3},{"$f":"(AG42-AC42)/AG42","v":0},null,3,{"$f":"SUM(AJ42:AL42)+AE42","v":31.3},null,null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":31.3},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1\" x 12\"",null,"M1L205",null,null,null,"Dome Liner",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA44,AG44)","v":12.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA44*(1-W44)+0.004999,2)","v":12.65},null,"",12.65,{"$f":"+W44","v":0},{"$f":"+X44","v":12.65},{"$f":"(AG44-AC44)/AG44","v":0},null,3,{"$f":"SUM(AJ44:AL44)+AE44","v":12.65},null,null,{"$f":"ROUND(AC44/(1-VLOOKUP(AF44,Group,2,FALSE)),2)","v":12.65},{"$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,"2\" x 12\"",null,"M1L204",null,null,null,"Dome Ogee",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA45,AG45)","v":30.95},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA45*(1-W45)+0.004999,2)","v":30.95},null,"",30.95,{"$f":"+W45","v":0},{"$f":"+X45","v":30.95},{"$f":"(AG45-AC45)/AG45","v":0},null,3,{"$f":"SUM(AJ45:AL45)+AE45","v":30.95},null,null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":30.95},{"$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,"Decos",null,null,"1\" x 12\"",null,"M1L207",null,null,null,"Dot Liner",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA47,AG47)","v":12.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA47*(1-W47)+0.004999,2)","v":12.6},null,"",12.6,{"$f":"+W47","v":0},{"$f":"+X47","v":12.6},{"$f":"(AG47-AC47)/AG47","v":0},null,3,{"$f":"SUM(AJ47:AL47)+AE47","v":12.6},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":12.6},{"$f":"IF(VLOOKUP(AF47,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ47,1)-AJ47,2),Round,2,FALSE)+VLOOKUP(AF47,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF47,Group,7,FALSE)=\"\",0,ROUND(AJ47-0.04999,1)-AJ47+AM47)","v":0},{"$f":"IF(VLOOKUP(AF47,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF47,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"3\" x 12\"",null,"M1L203",null,null,null,"Laurel Border",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA49,AG49)","v":42.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA49*(1-W49)+0.004999,2)","v":42.9},null,"",42.9,{"$f":"+W49","v":0},{"$f":"+X49","v":42.9},{"$f":"(AG49-AC49)/AG49","v":0},null,3,{"$f":"SUM(AJ49:AL49)+AE49","v":42.9},null,null,{"$f":"ROUND(AC49/(1-VLOOKUP(AF49,Group,2,FALSE)),2)","v":42.9},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1/2\" x 12\"",null,"M1L200",null,null,null,"Rope Listel",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA51,AG51)","v":8.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA51*(1-W51)+0.004999,2)","v":8.65},null,"",8.65,{"$f":"+W51","v":0},8.65,{"$f":"(AG51-AC51)/AG51","v":0},null,3,{"$f":"SUM(AJ51:AL51)+AE51","v":8.65},null,null,{"$f":"ROUND(AC51/(1-VLOOKUP(AF51,Group,2,FALSE)),2)","v":8.65},{"$f":"IF(VLOOKUP(AF51,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ51,1)-AJ51,2),Round,2,FALSE)+VLOOKUP(AF51,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF51,Group,7,FALSE)=\"\",0,ROUND(AJ51-0.04999,1)-AJ51+AM51)","v":0},{"$f":"IF(VLOOKUP(AF51,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF51,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"1\" x 12\"",null,"M1L201",null,null,null,"Rope Liner",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA52,AG52)","v":12.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA52*(1-W52)+0.004999,2)","v":12.6},null,"",12.6,0,12.6,{"$f":"(AG52-AC52)/AG52","v":0},null,3,{"$f":"SUM(AJ52:AL52)+AE52","v":12.6},null,null,{"$f":"ROUND(AC52/(1-VLOOKUP(AF52,Group,2,FALSE)),2)","v":12.6},{"$f":"IF(VLOOKUP(AF52,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ52,1)-AJ52,2),Round,2,FALSE)+VLOOKUP(AF52,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF52,Group,7,FALSE)=\"\",0,ROUND(AJ52-0.04999,1)-AJ52+AM52)","v":0},{"$f":"IF(VLOOKUP(AF52,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF52,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"2\" x 12\"",null,"M1L202",null,null,null,"Rope Ogee",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA53,AG53)","v":30.95},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA53*(1-W53)+0.004999,2)","v":30.95},null,"",30.95,0,30.95,{"$f":"(AG53-AC53)/AG53","v":0},null,3,{"$f":"SUM(AJ53:AL53)+AE53","v":30.95},null,null,{"$f":"ROUND(AC53/(1-VLOOKUP(AF53,Group,2,FALSE)),2)","v":30.95},{"$f":"IF(VLOOKUP(AF53,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ53,1)-AJ53,2),Round,2,FALSE)+VLOOKUP(AF53,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",0,ROUND(AJ53-0.04999,1)-AJ53+AM53)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF53,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"CAST METAL - Mosaics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCCM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","002 Antique Bronze          003 Brushed Nickel          001 Wrought Iron",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"11-3/4\" x 11-3/4\"",null,"MOSA100",null,null,null,"Starlite - 1\" x 1\"",null,null,null,null,"0.96 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA59,AG59)","v":116.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA59*(1-W59)+0.004999,2)","v":116.1},null,"",116.1,{"$f":"+W59","v":0},{"$f":"+X59","v":116.1},{"$f":"(AG59-AC59)/AG59","v":0},null,3,{"$f":"SUM(AJ59:AL59)+AE59","v":116.1},null,null,{"$f":"ROUND(AC59/(1-VLOOKUP(AF59,Group,2,FALSE)),2)","v":116.1},{"$f":"IF(VLOOKUP(AF59,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ59,1)-AJ59,2),Round,2,FALSE)+VLOOKUP(AF59,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",0,ROUND(AJ59-0.04999,1)-AJ59+AM59)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF59,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","006 Antique Bronze Blend         004 Dark Oil Rubbed Bronze Blend",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"005 Brushed Nickel Blend          ",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"10-11/16\" x 10-11/16\"",null,"MOSA200",null,null,null,"Twill - 1\" x 2\" Brickjoint",null,null,null,null,"0.80 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA64,AG64)","v":96.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":96.65},null,"",96.65,{"$f":"+W64","v":0},{"$f":"+X64","v":96.65},{"$f":"(AG64-AC64)/AG64","v":0},null,3,{"$f":"SUM(AJ64:AL64)+AE64","v":96.65},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":96.65},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","009 Antique Bronze Blend          007 Dark Oil Rubbed Bronze Blend",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"008 Brushed Nickel Blend          ",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"11-3/4\" x 10-5/8\"",null,"MOSA300",null,null,null,"Vista - 1/2\" x 4\" Linear Brick",null,null,null,null,"0.87 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA69,AG69)","v":105.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA69*(1-W69)+0.004999,2)","v":105.25},null,"",105.25,{"$f":"+W69","v":0},{"$f":"+X69","v":105.25},{"$f":"(AG69-AC69)/AG69","v":0},null,3,{"$f":"SUM(AJ69:AL69)+AE69","v":105.25},null,null,{"$f":"ROUND(AC69/(1-VLOOKUP(AF69,Group,2,FALSE)),2)","v":105.25},{"$f":"IF(VLOOKUP(AF69,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ69,1)-AJ69,2),Round,2,FALSE)+VLOOKUP(AF69,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF69,Group,7,FALSE)=\"\",0,ROUND(AJ69-0.04999,1)-AJ69+AM69)","v":0},{"$f":"IF(VLOOKUP(AF69,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF69,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"CITY SCAPE - Cast Metal Linear Field",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCCI",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,"Burnished Finish",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","002 Bronze (Eggshell)",null,null,null,null,"  003 Copper (Eggshell)",null,null,"         068 Iron (Eggshell)",null,null,null,null,null,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,"024 Brushed Nickel (Eggshell)",null,null,null,null,"  040 Gold (Eggshell)",null,null,null,null,null,null,null,null,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,"4\" x 8\"",null,"TILE504",null,null,null,"Burnished Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA78,AG78)","v":22.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":22.3},null,"",22.3,{"$f":"+W78","v":0},22.3,{"$f":"(AG78-AC78)/AG78","v":0},null,3,{"$f":"SUM(AJ78:AL78)+AE78","v":22.3},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":22.3},{"$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,"Decos",null,null,"4\" x 12\"",null,"TILE505",null,null,null,"Burnished Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA79,AG79)","v":33.049999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA79*(1-W79)+0.004999,2)","v":33.049999999999997},null,"",33.049999999999997,0,33.049999999999997,{"$f":"(AG79-AC79)/AG79","v":0},null,3,{"$f":"SUM(AJ79:AL79)+AE79","v":33.049999999999997},null,null,{"$f":"ROUND(AC79/(1-VLOOKUP(AF79,Group,2,FALSE)),2)","v":33.049999999999997},{"$f":"IF(VLOOKUP(AF79,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ79,1)-AJ79,2),Round,2,FALSE)+VLOOKUP(AF79,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF79,Group,7,FALSE)=\"\",0,ROUND(AJ79-0.04999,1)-AJ79+AM79)","v":0},{"$f":"IF(VLOOKUP(AF79,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF79,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"2\" x 18\"",null,"TILE503",null,null,null,"Burnished Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA80,AG80)","v":24.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA80*(1-W80)+0.004999,2)","v":24.8},null,"",24.8,0,24.8,{"$f":"(AG80-AC80)/AG80","v":0},null,3,{"$f":"SUM(AJ80:AL80)+AE80","v":24.8},null,null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":24.8},{"$f":"IF(VLOOKUP(AF80,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ80,1)-AJ80,2),Round,2,FALSE)+VLOOKUP(AF80,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",0,ROUND(AJ80-0.04999,1)-AJ80+AM80)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF80,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"4\" x 18\"",null,"TILE506",null,null,null,"Burnished Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA81,AG81)","v":49.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA81*(1-W81)+0.004999,2)","v":49.8},null,"",49.8,0,49.8,{"$f":"(AG81-AC81)/AG81","v":0},null,3,{"$f":"SUM(AJ81:AL81)+AE81","v":49.8},null,null,{"$f":"ROUND(AC81/(1-VLOOKUP(AF81,Group,2,FALSE)),2)","v":49.8},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"12\" x 18\"",null,"TILE501",null,null,null,"Burnished Panel",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA83,AG83)","v":108.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA83*(1-W83)+0.004999,2)","v":108.2},null,"",108.2,{"$f":"+W83","v":0},{"$f":"+X83","v":108.2},{"$f":"(AG83-AC83)/AG83","v":0},null,3,{"$f":"SUM(AJ83:AL83)+AE83","v":108.2},null,null,{"$f":"ROUND(AC83/(1-VLOOKUP(AF83,Group,2,FALSE)),2)","v":108.2},{"$f":"IF(VLOOKUP(AF83,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ83,1)-AJ83,2),Round,2,FALSE)+VLOOKUP(AF83,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF83,Group,7,FALSE)=\"\",0,ROUND(AJ83-0.04999,1)-AJ83+AM83)","v":0},{"$f":"IF(VLOOKUP(AF83,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF83,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"1\" x 18\"",null,"TILE502",null,null,null,"Burnished Bullnose",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA85,AG85)","v":31.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA85*(1-W85)+0.004999,2)","v":31.6},null,"",31.6,{"$f":"+W85","v":0},{"$f":"+X85","v":31.6},{"$f":"(AG85-AC85)/AG85","v":0},null,2,{"$f":"SUM(AJ85:AL85)+AE85","v":31.6},null,null,{"$f":"ROUND(AC85/(1-VLOOKUP(AF85,Group,2,FALSE)),2)","v":31.6},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","070 Dark Oil Rubbed Bronze (Eggshell)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"4\" x 8\"",null,"TILE516",null,null,null,"Burnished Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA89,AG89)","v":22.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":22.3},null,"",22.3,{"$f":"+W89","v":0},22.3,{"$f":"(AG89-AC89)/AG89","v":0},null,3,{"$f":"SUM(AJ89:AL89)+AE89","v":22.3},null,null,{"$f":"ROUND(AC89/(1-VLOOKUP(AF89,Group,2,FALSE)),2)","v":22.3},{"$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,"Decos",null,null,"4\" x 12\"",null,"TILE517",null,null,null,"Burnished Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA90,AG90)","v":33.049999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA90*(1-W90)+0.004999,2)","v":33.049999999999997},null,"",33.049999999999997,0,33.049999999999997,{"$f":"(AG90-AC90)/AG90","v":0},null,3,{"$f":"SUM(AJ90:AL90)+AE90","v":33.049999999999997},null,null,{"$f":"ROUND(AC90/(1-VLOOKUP(AF90,Group,2,FALSE)),2)","v":33.049999999999997},{"$f":"IF(VLOOKUP(AF90,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ90,1)-AJ90,2),Round,2,FALSE)+VLOOKUP(AF90,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,7,FALSE)=\"\",0,ROUND(AJ90-0.04999,1)-AJ90+AM90)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF90,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"2\" x 18\"",null,"TILE515",null,null,null,"Burnished Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA91,AG91)","v":24.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":24.8},null,"",24.8,0,24.8,{"$f":"(AG91-AC91)/AG91","v":0},null,3,{"$f":"SUM(AJ91:AL91)+AE91","v":24.8},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":24.8},{"$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,"Decos",null,null,"4\" x 18\"",null,"TILE518",null,null,null,"Burnished Field",null,null,null,null," ",null,null,{"$f":"IF(Suggested=\"Yes\",AA92,AG92)","v":49.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":49.8},null,"",49.8,0,49.8,{"$f":"(AG92-AC92)/AG92","v":0},null,3,{"$f":"SUM(AJ92:AL92)+AE92","v":49.8},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":49.8},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"12\" x 18\"",null,"TILE513",null,null,null,"Burnished Panel",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA94,AG94)","v":108.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA94*(1-W94)+0.004999,2)","v":108.2},null,"",108.2,{"$f":"+W94","v":0},{"$f":"+X94","v":108.2},{"$f":"(AG94-AC94)/AG94","v":0},null,3,{"$f":"SUM(AJ94:AL94)+AE94","v":108.2},null,null,{"$f":"ROUND(AC94/(1-VLOOKUP(AF94,Group,2,FALSE)),2)","v":108.2},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"1\" x 18\"",null,"TILE514",null,null,null,"Burnished Bullnose",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA96,AG96)","v":31.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA96*(1-W96)+0.004999,2)","v":31.6},null,"",31.6,{"$f":"+W96","v":0},{"$f":"+X96","v":31.6},{"$f":"(AG96-AC96)/AG96","v":0},null,2,{"$f":"SUM(AJ96:AL96)+AE96","v":31.6},null,null,{"$f":"ROUND(AC96/(1-VLOOKUP(AF96,Group,2,FALSE)),2)","v":31.6},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Hammered Finish",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","002 Bronze (Polished)",null,null,null,null," 003 Copper (Polished)",null,null,null,null,null,null,null,null,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,"024 Brushed Nickel (Polished)",null,null,null,null," 068 Iron (Polished)",null,null,null,null,null,null,null,null,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,"4\" x 8\"",null,"TILE510",null,null,null,"Hammered Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA103,AG103)","v":22.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA103*(1-W103)+0.004999,2)","v":22.3},null,"",22.3,{"$f":"+W103","v":0},22.3,{"$f":"(AG103-AC103)/AG103","v":0},null,3,{"$f":"SUM(AJ103:AL103)+AE103","v":22.3},null,null,{"$f":"ROUND(AC103/(1-VLOOKUP(AF103,Group,2,FALSE)),2)","v":22.3},{"$f":"IF(VLOOKUP(AF103,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ103,1)-AJ103,2),Round,2,FALSE)+VLOOKUP(AF103,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF103,Group,7,FALSE)=\"\",0,ROUND(AJ103-0.04999,1)-AJ103+AM103)","v":0},{"$f":"IF(VLOOKUP(AF103,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF103,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"4\" x 12\"",null,"TILE511",null,null,null,"Hammered Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA104,AG104)","v":33.049999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA104*(1-W104)+0.004999,2)","v":33.049999999999997},null,"",33.049999999999997,0,33.049999999999997,{"$f":"(AG104-AC104)/AG104","v":0},null,3,{"$f":"SUM(AJ104:AL104)+AE104","v":33.049999999999997},null,null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":33.049999999999997},{"$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,"Decos",null,null,"2\" x 18\"",null,"TILE509",null,null,null,"Hammered Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA105,AG105)","v":24.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA105*(1-W105)+0.004999,2)","v":24.8},null,"",24.8,0,24.8,{"$f":"(AG105-AC105)/AG105","v":0},null,3,{"$f":"SUM(AJ105:AL105)+AE105","v":24.8},null,null,{"$f":"ROUND(AC105/(1-VLOOKUP(AF105,Group,2,FALSE)),2)","v":24.8},{"$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,"Decos",null,null,"4\" x 18\"",null,"TILE512",null,null,null,"Hammered Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA106,AG106)","v":49.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":49.8},null,"",49.8,0,49.8,{"$f":"(AG106-AC106)/AG106","v":0},null,3,{"$f":"SUM(AJ106:AL106)+AE106","v":49.8},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":49.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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"12\" x 18\"",null,"TILE507",null,null,null,"Hammered Panel",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA108,AG108)","v":108.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA108*(1-W108)+0.004999,2)","v":108.2},null,"",108.2,{"$f":"+W108","v":0},{"$f":"+X108","v":108.2},{"$f":"(AG108-AC108)/AG108","v":0},null,3,{"$f":"SUM(AJ108:AL108)+AE108","v":108.2},null,null,{"$f":"ROUND(AC108/(1-VLOOKUP(AF108,Group,2,FALSE)),2)","v":108.2},{"$f":"IF(VLOOKUP(AF108,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ108,1)-AJ108,2),Round,2,FALSE)+VLOOKUP(AF108,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",0,ROUND(AJ108-0.04999,1)-AJ108+AM108)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF108,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"1\" x 18\"",null,"TILE508",null,null,null,"Hammered Bullnose",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA110,AG110)","v":31.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA110*(1-W110)+0.004999,2)","v":31.6},null,"",31.6,{"$f":"+W110","v":0},{"$f":"+X110","v":31.6},{"$f":"(AG110-AC110)/AG110","v":0},null,2,{"$f":"SUM(AJ110:AL110)+AE110","v":31.6},null,null,{"$f":"ROUND(AC110/(1-VLOOKUP(AF110,Group,2,FALSE)),2)","v":31.6},{"$f":"IF(VLOOKUP(AF110,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ110,1)-AJ110,2),Round,2,FALSE)+VLOOKUP(AF110,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",0,ROUND(AJ110-0.04999,1)-AJ110+AM110)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF110,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"continued on next page",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"CITY SCAPE - Cast Metal Linear Field - continued",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCCI",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,"Water Finish",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","002 Bronze (Eggshell)",null,null,null,null,"  042 Brushed Gold (Eggshell)",null,null,null,null,null,null,null,null,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,"024 Brushed Nickel (Eggshell)",null,null,null,null,"  068 Iron (Eggshell)",null,null,null,null,null,null,null,null,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,"4\" x 8\"",null,"TILE498",null,null,null,"Water Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA120,AG120)","v":22.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA120*(1-W120)+0.004999,2)","v":22.3},null,"",22.3,{"$f":"+W120","v":0},22.3,{"$f":"(AG120-AC120)/AG120","v":0},null,3,{"$f":"SUM(AJ120:AL120)+AE120","v":22.3},null,null,{"$f":"ROUND(AC120/(1-VLOOKUP(AF120,Group,2,FALSE)),2)","v":22.3},{"$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,"Decos",null,null,"4\" x 12\"",null,"TILE499",null,null,null,"Water Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA121,AG121)","v":33.049999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA121*(1-W121)+0.004999,2)","v":33.049999999999997},null,"",33.049999999999997,0,33.049999999999997,{"$f":"(AG121-AC121)/AG121","v":0},null,3,{"$f":"SUM(AJ121:AL121)+AE121","v":33.049999999999997},null,null,{"$f":"ROUND(AC121/(1-VLOOKUP(AF121,Group,2,FALSE)),2)","v":33.049999999999997},{"$f":"IF(VLOOKUP(AF121,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ121,1)-AJ121,2),Round,2,FALSE)+VLOOKUP(AF121,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",0,ROUND(AJ121-0.04999,1)-AJ121+AM121)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF121,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"2\" x 18\"",null,"TILE497",null,null,null,"Water Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA122,AG122)","v":24.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA122*(1-W122)+0.004999,2)","v":24.8},null,"",24.8,0,24.8,{"$f":"(AG122-AC122)/AG122","v":0},null,3,{"$f":"SUM(AJ122:AL122)+AE122","v":24.8},null,null,{"$f":"ROUND(AC122/(1-VLOOKUP(AF122,Group,2,FALSE)),2)","v":24.8},{"$f":"IF(VLOOKUP(AF122,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ122,1)-AJ122,2),Round,2,FALSE)+VLOOKUP(AF122,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,7,FALSE)=\"\",0,ROUND(AJ122-0.04999,1)-AJ122+AM122)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF122,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"4\" x 18\"",null,"TILE500",null,null,null,"Water Field",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA123,AG123)","v":49.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA123*(1-W123)+0.004999,2)","v":49.8},null,"",49.8,0,49.8,{"$f":"(AG123-AC123)/AG123","v":0},null,3,{"$f":"SUM(AJ123:AL123)+AE123","v":49.8},null,null,{"$f":"ROUND(AC123/(1-VLOOKUP(AF123,Group,2,FALSE)),2)","v":49.8},{"$f":"IF(VLOOKUP(AF123,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ123,1)-AJ123,2),Round,2,FALSE)+VLOOKUP(AF123,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",0,ROUND(AJ123-0.04999,1)-AJ123+AM123)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF123,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,"Decos",null,null,"12\" x 18\"",null,"TILE495",null,null,null,"Water Panel",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA125,AG125)","v":108.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA125*(1-W125)+0.004999,2)","v":108.2},null,"",108.2,{"$f":"+W125","v":0},{"$f":"+X125","v":108.2},{"$f":"(AG125-AC125)/AG125","v":0},null,3,{"$f":"SUM(AJ125:AL125)+AE125","v":108.2},null,null,{"$f":"ROUND(AC125/(1-VLOOKUP(AF125,Group,2,FALSE)),2)","v":108.2},{"$f":"IF(VLOOKUP(AF125,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ125,1)-AJ125,2),Round,2,FALSE)+VLOOKUP(AF125,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",0,ROUND(AJ125-0.04999,1)-AJ125+AM125)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF125,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"1\" x 18\"",null,"TILE496",null,null,null,"Water Bullnose",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA127,AG127)","v":31.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA127*(1-W127)+0.004999,2)","v":31.6},null,"",31.6,{"$f":"+W127","v":0},{"$f":"+X127","v":31.6},{"$f":"(AG127-AC127)/AG127","v":0},null,2,{"$f":"SUM(AJ127:AL127)+AE127","v":31.6},null,null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":31.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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","Burnished and Water Finishes can be used on Light Commercial Floors and the Hammered Finish can be used on Residential Floors.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"CLASSIC METAL TILE - Cast Metal Field, Mosaics & Liners",null,null,null,null,null,null,null,null,null," ",null,null,null,null,"Item # Lookup:","QCCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","002 Bronze (Eggshell)",null,null,null,null,"   042 Aztec Gold (Eggshell)",null,null,null,null,null,null,null,null,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,"024 Brushed Nickel (Eggshell)",null,null,null,null,"  086 Graphite (Matte)",null,null,null,null,null,null,null,null,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,"4\" x 4\"",null,"TILE868",null,null,null,"Field Tile",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA136,AG136)","v":8.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA136*(1-W136)+0.004999,2)","v":8.35},null,"",8.35,{"$f":"+W136","v":0},8.35,{"$f":"(AG136-AC136)/AG136","v":0},null,3,{"$f":"SUM(AJ136:AL136)+AE136","v":8.35},null,null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":8.35},{"$f":"IF(VLOOKUP(AF136,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ136,1)-AJ136,2),Round,2,FALSE)+VLOOKUP(AF136,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",0,ROUND(AJ136-0.04999,1)-AJ136+AM136)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF136,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"3\" x 9\"",null,"TILE867",null,null,null,"Subway Tile ",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA137,AG137)","v":19.350000000000001},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA137*(1-W137)+0.004999,2)","v":19.350000000000001},null,"",19.350000000000001,0,19.350000000000001,{"$f":"(AG137-AC137)/AG137","v":0},null,3,{"$f":"SUM(AJ137:AL137)+AE137","v":19.350000000000001},null,null,{"$f":"ROUND(AC137/(1-VLOOKUP(AF137,Group,2,FALSE)),2)","v":19.350000000000001},{"$f":"IF(VLOOKUP(AF137,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ137,1)-AJ137,2),Round,2,FALSE)+VLOOKUP(AF137,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",0,ROUND(AJ137-0.04999,1)-AJ137+AM137)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF137,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"4\" x 12\"",null,"TILE866",null,null,null,"Subway Tile ",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA138,AG138)","v":34.049999999999997},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA138*(1-W138)+0.004999,2)","v":34.049999999999997},null,"",34.049999999999997,0,34.049999999999997,{"$f":"(AG138-AC138)/AG138","v":0},null,3,{"$f":"SUM(AJ138:AL138)+AE138","v":34.049999999999997},null,null,{"$f":"ROUND(AC138/(1-VLOOKUP(AF138,Group,2,FALSE)),2)","v":34.049999999999997},{"$f":"IF(VLOOKUP(AF138,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ138,1)-AJ138,2),Round,2,FALSE)+VLOOKUP(AF138,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF138,Group,7,FALSE)=\"\",0,ROUND(AJ138-0.04999,1)-AJ138+AM138)","v":0},{"$f":"IF(VLOOKUP(AF138,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF138,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,"Decos",null,null,"11-5/8\" x 12\"",null,"MOSA910",null,null,null,"Picket Mosaic",null,null,null,null,"0.96 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA140,AG140)","v":102.45},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA140*(1-W140)+0.004999,2)","v":102.45},null,"",102.45,{"$f":"+W140","v":0},{"$f":"+X140","v":102.45},{"$f":"(AG140-AC140)/AG140","v":0},null,3,{"$f":"SUM(AJ140:AL140)+AE140","v":102.45},null,null,{"$f":"ROUND(AC140/(1-VLOOKUP(AF140,Group,2,FALSE)),2)","v":102.45},{"$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,"Decos",null,null,"10\" x 10-1/4\"",null,"MOSA900",null,null,null,"Scallop Mosaic",null,null,null,null,"0.71 SF/Sheet",null,null,{"$f":"IF(Suggested=\"Yes\",AA141,AG141)","v":68.95},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA141*(1-W141)+0.004999,2)","v":68.95},null,"",68.95,{"$f":"+W141","v":0},{"$f":"+X141","v":68.95},{"$f":"(AG141-AC141)/AG141","v":0},null,3,{"$f":"SUM(AJ141:AL141)+AE141","v":68.95},null,null,{"$f":"ROUND(AC141/(1-VLOOKUP(AF141,Group,2,FALSE)),2)","v":68.95},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1/2\" x 12\"",null,"TILE700",null,null,null,"Jolly",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA143,AG143)","v":8.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA143*(1-W143)+0.004999,2)","v":8.5},null,"",8.5,{"$f":"+W143","v":0},{"$f":"+X143","v":8.5},{"$f":"(AG143-AC143)/AG143","v":0},null,3,{"$f":"SUM(AJ143:AL143)+AE143","v":8.5},null,null,{"$f":"ROUND(AC143/(1-VLOOKUP(AF143,Group,2,FALSE)),2)","v":8.5},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","002 Bronze (Eggshell)          024 Brushed Nickel (Eggshell)          042 Aztec Gold (Eggshell)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1/2\" x 12\"",null,"ML401",null,null,null,"Soho Pencil",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA147,AG147)","v":8.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA147*(1-W147)+0.004999,2)","v":8.85},null,"",8.85,{"$f":"+W147","v":0},{"$f":"+X147","v":8.85},{"$f":"(AG147-AC147)/AG147","v":0},null,3,{"$f":"SUM(AJ147:AL147)+AE147","v":8.85},null,null,{"$f":"ROUND(AC147/(1-VLOOKUP(AF147,Group,2,FALSE)),2)","v":8.85},{"$f":"IF(VLOOKUP(AF147,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ147,1)-AJ147,2),Round,2,FALSE)+VLOOKUP(AF147,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,7,FALSE)=\"\",0,ROUND(AJ147-0.04999,1)-AJ147+AM147)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF147,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","086 Graphite (Matte)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1/2\" x 12\"",null,"ML826",null,null,null,"Soho Pencil",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA151,AG151)","v":8.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA151*(1-W151)+0.004999,2)","v":8.85},null,"",8.85,{"$f":"+W151","v":0},{"$f":"+X151","v":8.85},{"$f":"(AG151-AC151)/AG151","v":0},null,3,{"$f":"SUM(AJ151:AL151)+AE151","v":8.85},null,null,{"$f":"ROUND(AC151/(1-VLOOKUP(AF151,Group,2,FALSE)),2)","v":8.85},{"$f":"IF(VLOOKUP(AF151,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ151,1)-AJ151,2),Round,2,FALSE)+VLOOKUP(AF151,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,7,FALSE)=\"\",0,ROUND(AJ151-0.04999,1)-AJ151+AM151)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF151,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,"HIGH RELIEF LINER - Cast Stone Decorative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCHL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","67 Bright White (Matte)",null,null,null,"    12 Gray (Matte)",null,null,null,null,null,null,null,null,null,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,"23 Bright White (Polished)",null,null,null,"    21 Gray (Polished)",null,null,null,null,null,null,null,null,null,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,"1/2\" x 12\"",null,"SL828",null,null,null,"Cornice Pencil",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA158,AG158)","v":8.5500000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA158*(1-W158)+0.004999,2)","v":8.5500000000000007},null,"",8.5500000000000007,{"$f":"+W158","v":0},8.5500000000000007,{"$f":"(AG158-AC158)/AG158","v":0},null,3,{"$f":"SUM(AJ158:AL158)+AE158","v":8.5500000000000007},null,null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":8.5500000000000007},{"$f":"IF(VLOOKUP(AF158,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ158,1)-AJ158,2),Round,2,FALSE)+VLOOKUP(AF158,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",0,ROUND(AJ158-0.04999,1)-AJ158+AM158)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF158,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"3/4\" x 12\"",null,"SL825",null,null,null,"Linear Liner",null,null,null,null,null,null,null,11.3,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11.3,null,"",11.3,0,11.3,0,null,3,11.3,null,null,11.3,0,0,"",null,"X"]
[null,"Decos",null,null,"1/2\" x 12\"",null,"SL827",null,null,null,"Linear Pencil",null,null,null,null,null,null,null,8.5500000000000007,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5500000000000007,null,"",8.5500000000000007,0,8.5500000000000007,0,null,3,8.5500000000000007,null,null,8.5500000000000007,0,0,"",null,"X"]
[null,"Decos",null,null,"2\" x 12\"",null,"SL823",null,null,null,"Liner Chair Rail",null,null,null,null,null,null,null,20.8,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},20.8,null,"",20.8,0,20.8,0,null,3,20.8,null,null,20.8,0,0,"",null,"X"]
[null,"Decos",null," ","1/2\" x 12\"",null,"SL829",null,null,null,"Nail Head Pencil",null,null,null,null,null,null,null,8.5500000000000007,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5500000000000007,null,"",8.5500000000000007,0,8.5500000000000007,0,null,3,8.5500000000000007,null,null,8.5500000000000007,0,0,"",null,"X"]
[null,"Decos",null,null,"3/4\" x 12\"",null,"SL824",null,null,null,"Soho Bullnose",null,null,null,null,null,null,null,11.25,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11.25,null,"",11.25,0,11.25,0,null,3,11.25,null,null,11.25,0,0,"",null,"X"]
[null,"Decos",null,null,"1/2\" x 12\"",null,"SL826",null,null,null,"Soho Pencil",null,null,null,null,null,"Stock",null,8.5500000000000007,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5500000000000007,null,"",8.5500000000000007,0,8.5500000000000007,0,null,3,8.5500000000000007,null,null,8.5500000000000007,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","086 Graphite (Matte)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1/2\" x 12\"",null,"ML828",null,null,null,"Cornice Pencil",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA168,AG168)","v":8.5500000000000007},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA168*(1-W168)+0.004999,2)","v":8.5500000000000007},null,"",8.5500000000000007,{"$f":"+W168","v":0},8.5500000000000007,{"$f":"(AG168-AC168)/AG168","v":0},null,3,{"$f":"SUM(AJ168:AL168)+AE168","v":8.5500000000000007},null,null,{"$f":"ROUND(AC168/(1-VLOOKUP(AF168,Group,2,FALSE)),2)","v":8.5500000000000007},{"$f":"IF(VLOOKUP(AF168,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ168,1)-AJ168,2),Round,2,FALSE)+VLOOKUP(AF168,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",0,ROUND(AJ168-0.04999,1)-AJ168+AM168)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF168,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"3/4\" x 12\"",null,"ML825",null,null,null,"Linear Liner",null,null,null,null,null,null,null,11.3,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11.3,null,"",11.3,0,11.3,0,null,3,11.3,null,null,11.3,0,0,"",null,"X"]
[null,"Decos",null,null,"1/2\" x 12\"",null,"ML827",null,null,null,"Linear Pencil",null,null,null,null,null,null,null,8.5500000000000007,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5500000000000007,null,"",8.5500000000000007,0,8.5500000000000007,0,null,3,8.5500000000000007,null,null,8.5500000000000007,0,0,"",null,"X"]
[null,"Decos",null,null,"2\" x 12\"",null,"ML823",null,null,null,"Liner Chair Rail",null,null,null,null,null,null,null,20.8,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},20.8,null,"",20.8,0,20.8,0,null,3,20.8,null,null,20.8,0,0,"",null,"X"]
[null,"Decos",null,null,"1/2\" x 12\"",null,"ML829",null,null,null,"Nail Head Pencil",null,null,null,null,null,null,null,8.5500000000000007,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5500000000000007,null,"",8.5500000000000007,0,8.5500000000000007,0,null,3,8.5500000000000007,null,null,8.5500000000000007,0,0,"",null,"X"]
[null,"Decos",null,null,"3/4\" x 12\"",null,"ML824",null,null,null,"Soho Bullnose",null,null,null,null,null,null,null,11.25,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11.25,null,"",11.25,0,11.25,0,null,3,11.25,null,null,11.25,0,0,"",null,"X"]
[null,"Decos",null,null,"1/2\" x 12\"",null,"ML826",null,null,null,"Soho Pencil",null,null,null,null,null,"Stock",null,8.5500000000000007,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5500000000000007,null,"",8.5500000000000007,0,8.5500000000000007,0,null,3,8.5500000000000007,null,null,8.5500000000000007,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"JOLLY LINER - Cast Metal Decorative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCJL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","042011 Aztec Gold (Eggshell)",null,null,null,null," 024001 Brushed Nickel (Polished)",null,null,null,"          039011 Titanium (Eggshell)",null,null,null,null,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,"002011 Bronze (Eggshell)",null,null,null,null," 003011 Copper (Eggshell)",null,null,null,"          039001 Titanium (Polished)",null,null,null,null,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,"002001 Bronze (Polished)",null,null,null,null," 003001 Copper (Polished)",null,null,null,"          068011 Wrought Iron (Eggshell)",null,null,null,null,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,"024011 Brushed Nickel (Eggshell)",null,null,null,null," 040011 Gold (Eggshell)",null,null,null,"          068001 Wrought Iron (Polished)",null,null,null,null,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,"1/2\" x 12\"",null,"TILE700",null,null,null,"Jolly - 1/4\" Round",null,null,null,null,null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",AA183,AG183)","v":9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":9},null,"",9,{"$f":"+W183","v":0},{"$f":"+X183","v":9},{"$f":"(AG183-AC183)/AG183","v":0},null,3,{"$f":"SUM(AJ183:AL183)+AE183","v":9},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":9},{"$f":"IF(VLOOKUP(AF183,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ183,1)-AJ183,2),Round,2,FALSE)+VLOOKUP(AF183,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",0,ROUND(AJ183-0.04999,1)-AJ183+AM183)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF183,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","070003 Oil Rubbed Bronze (Bright Satin)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1/2\" x 12\"",null,"TILE701",null,null,null,"Jolly - 1/4\" Round",null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA187,AG187)","v":9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA187*(1-W187)+0.004999,2)","v":9},null,"",9,{"$f":"+W187","v":0},{"$f":"+X187","v":9},{"$f":"(AG187-AC187)/AG187","v":0},null,3,{"$f":"SUM(AJ187:AL187)+AE187","v":9},null,null,{"$f":"ROUND(AC187/(1-VLOOKUP(AF187,Group,2,FALSE)),2)","v":9},{"$f":"IF(VLOOKUP(AF187,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ187,1)-AJ187,2),Round,2,FALSE)+VLOOKUP(AF187,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",0,ROUND(AJ187-0.04999,1)-AJ187+AM187)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF187,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","A highly innovative finishing touch for tile installations including porcelain, stone, metal and glass.  Designed for versatility,",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"the Jolly can be used as a liner, cap, mosaic element or deco accent.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"a) Stocked in the (Eggshell) colors only, except color 042011 Aztec Gold (Eggshell).",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"JOLLY LINER - Cast Stone Decorative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCJL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","67 Bright White (Matte)",null,null,null,"    03 Sand (Matte)",null,null,"           25 White (Matte)",null,null,null,null,null,null,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,"23 Bright White (Polished)",null,null,null,"    26 Sand (Polished)",null,null,"           13 White (Polished)",null,null,null,null,null,null,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,"12 Gray (Matte)",null,null,null,"    01 Travertine (Matte)",null,null,null,null,null,null,null,null,null,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,"21 Gray (Polished)",null,null,null,"    27 Travertine (Polished)",null,null,null,null,null,null,null,null,null,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,"1/2\" x 12\"",null,"SL700",null,null,null,"Jolly - 1/4\" Round",null,null,null,null,null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",AA200,AG200)","v":9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA200*(1-W200)+0.004999,2)","v":9},null,"",9,{"$f":"+W200","v":0},{"$f":"+X200","v":9},{"$f":"(AG200-AC200)/AG200","v":0},null,3,{"$f":"SUM(AJ200:AL200)+AE200","v":9},null,null,{"$f":"ROUND(AC200/(1-VLOOKUP(AF200,Group,2,FALSE)),2)","v":9},{"$f":"IF(VLOOKUP(AF200,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ200,1)-AJ200,2),Round,2,FALSE)+VLOOKUP(AF200,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF200,Group,7,FALSE)=\"\",0,ROUND(AJ200-0.04999,1)-AJ200+AM200)","v":0},{"$f":"IF(VLOOKUP(AF200,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF200,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","086 Graphite (Bright Satin)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1/2\" x 12\"",null,"TILE700",null,null,null,"Jolly - 1/4\" Round",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA204,AG204)","v":9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA204*(1-W204)+0.004999,2)","v":9},null,"",9,{"$f":"+W204","v":0},{"$f":"+X204","v":9},{"$f":"(AG204-AC204)/AG204","v":0},null,3,{"$f":"SUM(AJ204:AL204)+AE204","v":9},null,null,{"$f":"ROUND(AC204/(1-VLOOKUP(AF204,Group,2,FALSE)),2)","v":9},{"$f":"IF(VLOOKUP(AF204,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ204,1)-AJ204,2),Round,2,FALSE)+VLOOKUP(AF204,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF204,Group,7,FALSE)=\"\",0,ROUND(AJ204-0.04999,1)-AJ204+AM204)","v":0},{"$f":"IF(VLOOKUP(AF204,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF204,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","A highly innovative finishing touch for tile installations including porcelain, stone, metal and glass.  Designed for versatility,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null," ",null,null,"the Jolly can be used as a liner, cap, mosaic element or deco accent."]
[null,null,null,null,"a) Stocked in the (Polished) colors only except color 23 Bright White (Polished).",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"GEO - Cast Metal Bath Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","024 Brushed Nickel          070 Dark Oil Rubbed Bronze",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"SBA194",null,null,null,"5\" Corner Soap Dish",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA214,AG214)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA214*(1-W214)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W214","v":0},30.05,{"$f":"(AG214-AC214)/AG214","v":0},null,5,{"$f":"SUM(AJ214:AL214)+AE214","v":30.05},null,null,{"$f":"ROUND(AC214/(1-VLOOKUP(AF214,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF214,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ214,1)-AJ214,2),Round,2,FALSE)+VLOOKUP(AF214,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF214,Group,7,FALSE)=\"\",0,ROUND(AJ214-0.04999,1)-AJ214+AM214)","v":0},{"$f":"IF(VLOOKUP(AF214,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF214,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"SBA193",null,null,null,"8\" Corner Shelf",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA215,AG215)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA215*(1-W215)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG215-AC215)/AG215","v":0},null,5,{"$f":"SUM(AJ215:AL215)+AE215","v":48},null,null,{"$f":"ROUND(AC215/(1-VLOOKUP(AF215,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF215,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ215,1)-AJ215,2),Round,2,FALSE)+VLOOKUP(AF215,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF215,Group,7,FALSE)=\"\",0,ROUND(AJ215-0.04999,1)-AJ215+AM215)","v":0},{"$f":"IF(VLOOKUP(AF215,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF215,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"SBA196",null,null,null,"5\" Footrest",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA216,AG216)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA216*(1-W216)+0.004999,2)","v":30.05},null,"",30.05,0,30.05,{"$f":"(AG216-AC216)/AG216","v":0},null,5,{"$f":"SUM(AJ216:AL216)+AE216","v":30.05},null,null,{"$f":"ROUND(AC216/(1-VLOOKUP(AF216,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF216,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ216,1)-AJ216,2),Round,2,FALSE)+VLOOKUP(AF216,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",0,ROUND(AJ216-0.04999,1)-AJ216+AM216)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF216,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","042 Aztec Gold          002 Bronze          091 Copper",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"MBA194",null,null,null,"5\" Corner Soap Dish",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA220,AG220)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA220*(1-W220)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W220","v":0},30.05,{"$f":"(AG220-AC220)/AG220","v":0},null,5,{"$f":"SUM(AJ220:AL220)+AE220","v":30.05},null,null,{"$f":"ROUND(AC220/(1-VLOOKUP(AF220,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF220,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ220,1)-AJ220,2),Round,2,FALSE)+VLOOKUP(AF220,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF220,Group,7,FALSE)=\"\",0,ROUND(AJ220-0.04999,1)-AJ220+AM220)","v":0},{"$f":"IF(VLOOKUP(AF220,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF220,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"MBA193",null,null,null,"8\" Corner Shelf",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA221,AG221)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA221*(1-W221)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG221-AC221)/AG221","v":0},null,5,{"$f":"SUM(AJ221:AL221)+AE221","v":48},null,null,{"$f":"ROUND(AC221/(1-VLOOKUP(AF221,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF221,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ221,1)-AJ221,2),Round,2,FALSE)+VLOOKUP(AF221,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF221,Group,7,FALSE)=\"\",0,ROUND(AJ221-0.04999,1)-AJ221+AM221)","v":0},{"$f":"IF(VLOOKUP(AF221,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF221,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"MBA196",null,null,null,"5\" Footrest",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA222,AG222)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA222*(1-W222)+0.004999,2)","v":30.05},null,"",30.05,0,30.05,{"$f":"(AG222-AC222)/AG222","v":0},null,5,{"$f":"SUM(AJ222:AL222)+AE222","v":30.05},null,null,{"$f":"ROUND(AC222/(1-VLOOKUP(AF222,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF222,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ222,1)-AJ222,2),Round,2,FALSE)+VLOOKUP(AF222,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF222,Group,7,FALSE)=\"\",0,ROUND(AJ222-0.04999,1)-AJ222+AM222)","v":0},{"$f":"IF(VLOOKUP(AF222,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF222,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"GEO - Cast Metal Retrofit Bath Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","024 Brushed Nickel          070 Dark Oil Rubbed Bronze",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"SBA184",null,null,null,"5\" Corner Soap Dish",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA228,AG228)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA228*(1-W228)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W228","v":0},30.05,{"$f":"(AG228-AC228)/AG228","v":0},null,5,{"$f":"SUM(AJ228:AL228)+AE228","v":30.05},null,null,{"$f":"ROUND(AC228/(1-VLOOKUP(AF228,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF228,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ228,1)-AJ228,2),Round,2,FALSE)+VLOOKUP(AF228,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF228,Group,7,FALSE)=\"\",0,ROUND(AJ228-0.04999,1)-AJ228+AM228)","v":0},{"$f":"IF(VLOOKUP(AF228,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF228,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"SBA183",null,null,null,"8\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA229,AG229)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA229*(1-W229)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG229-AC229)/AG229","v":0},null,5,{"$f":"SUM(AJ229:AL229)+AE229","v":48},null,null,{"$f":"ROUND(AC229/(1-VLOOKUP(AF229,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF229,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ229,1)-AJ229,2),Round,2,FALSE)+VLOOKUP(AF229,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",0,ROUND(AJ229-0.04999,1)-AJ229+AM229)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF229,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"SBA186",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA230,AG230)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA230*(1-W230)+0.004999,2)","v":30.05},null,"",30.05,0,30.05,{"$f":"(AG230-AC230)/AG230","v":0},null,5,{"$f":"SUM(AJ230:AL230)+AE230","v":30.05},null,null,{"$f":"ROUND(AC230/(1-VLOOKUP(AF230,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF230,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ230,1)-AJ230,2),Round,2,FALSE)+VLOOKUP(AF230,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF230,Group,7,FALSE)=\"\",0,ROUND(AJ230-0.04999,1)-AJ230+AM230)","v":0},{"$f":"IF(VLOOKUP(AF230,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF230,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","042 Aztec Gold          002 Bronze          091 Copper",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"MBA184",null,null,null,"5\" Corner Soap Dish",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA234,AG234)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA234*(1-W234)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W234","v":0},30.05,{"$f":"(AG234-AC234)/AG234","v":0},null,5,{"$f":"SUM(AJ234:AL234)+AE234","v":30.05},null,null,{"$f":"ROUND(AC234/(1-VLOOKUP(AF234,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF234,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ234,1)-AJ234,2),Round,2,FALSE)+VLOOKUP(AF234,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF234,Group,7,FALSE)=\"\",0,ROUND(AJ234-0.04999,1)-AJ234+AM234)","v":0},{"$f":"IF(VLOOKUP(AF234,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF234,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"MBA183",null," ",null,"8\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA235,AG235)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA235*(1-W235)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG235-AC235)/AG235","v":0},null,5,{"$f":"SUM(AJ235:AL235)+AE235","v":48},null,null,{"$f":"ROUND(AC235/(1-VLOOKUP(AF235,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF235,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ235,1)-AJ235,2),Round,2,FALSE)+VLOOKUP(AF235,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF235,Group,7,FALSE)=\"\",0,ROUND(AJ235-0.04999,1)-AJ235+AM235)","v":0},{"$f":"IF(VLOOKUP(AF235,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF235,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"MBA186",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA236,AG236)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA236*(1-W236)+0.004999,2)","v":30.05},null,"",30.05,0,30.05,{"$f":"(AG236-AC236)/AG236","v":0},null,5,{"$f":"SUM(AJ236:AL236)+AE236","v":30.05},null,null,{"$f":"ROUND(AC236/(1-VLOOKUP(AF236,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF236,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ236,1)-AJ236,2),Round,2,FALSE)+VLOOKUP(AF236,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",0,ROUND(AJ236-0.04999,1)-AJ236+AM236)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF236,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,"GEO - Cast Stone Bath Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","67 Bright White (Matte)",null,null,null,"    12 Gray (Matte)",null,null,"    13 White (Polished)",null,null,null,null,null,null,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,"23 Bright White (Polished)",null,null,null,"    21 Gray (Polished)",null,null,null,null,null,null,null,null,null,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,"62 Cool Gray (Polished)",null,null,null,"    03 Sand (Matte)",null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"SBA194",null,null,null,"5\" Corner Soap Dish",null,null,null,null,null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",AA244,AG244)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA244*(1-W244)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W244","v":0},24.35,{"$f":"(AG244-AC244)/AG244","v":0},null,5,{"$f":"SUM(AJ244:AL244)+AE244","v":24.35},null,null,{"$f":"ROUND(AC244/(1-VLOOKUP(AF244,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF244,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ244,1)-AJ244,2),Round,2,FALSE)+VLOOKUP(AF244,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF244,Group,7,FALSE)=\"\",0,ROUND(AJ244-0.04999,1)-AJ244+AM244)","v":0},{"$f":"IF(VLOOKUP(AF244,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF244,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"SBA193",null,null,null,"8\" Corner Shelf",null,null,null,null,null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",AA245,AG245)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA245*(1-W245)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG245-AC245)/AG245","v":0},null,5,{"$f":"SUM(AJ245:AL245)+AE245","v":38.85},null,null,{"$f":"ROUND(AC245/(1-VLOOKUP(AF245,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF245,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ245,1)-AJ245,2),Round,2,FALSE)+VLOOKUP(AF245,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF245,Group,7,FALSE)=\"\",0,ROUND(AJ245-0.04999,1)-AJ245+AM245)","v":0},{"$f":"IF(VLOOKUP(AF245,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF245,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"10\" Radius",null,"SBA195",null,null,null,"10\" Corner Shelf",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA246,AG246)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA246*(1-W246)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG246-AC246)/AG246","v":0},null,5,{"$f":"SUM(AJ246:AL246)+AE246","v":52.8},null,null,{"$f":"ROUND(AC246/(1-VLOOKUP(AF246,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF246,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ246,1)-AJ246,2),Round,2,FALSE)+VLOOKUP(AF246,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF246,Group,7,FALSE)=\"\",0,ROUND(AJ246-0.04999,1)-AJ246+AM246)","v":0},{"$f":"IF(VLOOKUP(AF246,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF246,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"SBA196",null,null,null,"5\" Footrest",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA247,AG247)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA247*(1-W247)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG247-AC247)/AG247","v":0},null,5,{"$f":"SUM(AJ247:AL247)+AE247","v":24.35},null,null,{"$f":"ROUND(AC247/(1-VLOOKUP(AF247,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF247,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ247,1)-AJ247,2),Round,2,FALSE)+VLOOKUP(AF247,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF247,Group,7,FALSE)=\"\",0,ROUND(AJ247-0.04999,1)-AJ247+AM247)","v":0},{"$f":"IF(VLOOKUP(AF247,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF247,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","086 Graphite (Matte)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"MBA194",null,null,null,"5\" Corner Soap Dish",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA251,AG251)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA251*(1-W251)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W251","v":0},24.35,{"$f":"(AG251-AC251)/AG251","v":0},null,5,{"$f":"SUM(AJ251:AL251)+AE251","v":24.35},null,null,{"$f":"ROUND(AC251/(1-VLOOKUP(AF251,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF251,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ251,1)-AJ251,2),Round,2,FALSE)+VLOOKUP(AF251,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF251,Group,7,FALSE)=\"\",0,ROUND(AJ251-0.04999,1)-AJ251+AM251)","v":0},{"$f":"IF(VLOOKUP(AF251,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF251,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"MBA193",null,null,null,"8\" Corner Shelf",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA252,AG252)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA252*(1-W252)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG252-AC252)/AG252","v":0},null,5,{"$f":"SUM(AJ252:AL252)+AE252","v":38.85},null,null,{"$f":"ROUND(AC252/(1-VLOOKUP(AF252,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF252,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ252,1)-AJ252,2),Round,2,FALSE)+VLOOKUP(AF252,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF252,Group,7,FALSE)=\"\",0,ROUND(AJ252-0.04999,1)-AJ252+AM252)","v":0},{"$f":"IF(VLOOKUP(AF252,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF252,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"10\" Radius",null,"MBA195",null,null,null,"10\" Corner Shelf",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA253,AG253)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA253*(1-W253)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG253-AC253)/AG253","v":0},null,5,{"$f":"SUM(AJ253:AL253)+AE253","v":52.8},null,null,{"$f":"ROUND(AC253/(1-VLOOKUP(AF253,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF253,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ253,1)-AJ253,2),Round,2,FALSE)+VLOOKUP(AF253,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF253,Group,7,FALSE)=\"\",0,ROUND(AJ253-0.04999,1)-AJ253+AM253)","v":0},{"$f":"IF(VLOOKUP(AF253,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF253,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"MBA196",null,null,null,"5\" Footrest",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA254,AG254)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA254*(1-W254)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG254-AC254)/AG254","v":0},null,5,{"$f":"SUM(AJ254:AL254)+AE254","v":24.35},null,null,{"$f":"ROUND(AC254/(1-VLOOKUP(AF254,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF254,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ254,1)-AJ254,2),Round,2,FALSE)+VLOOKUP(AF254,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF254,Group,7,FALSE)=\"\",0,ROUND(AJ254-0.04999,1)-AJ254+AM254)","v":0},{"$f":"IF(VLOOKUP(AF254,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF254,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Note:","a) Stocked in color 23 Bright White (Polished) 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,"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,"GEO - Cast Stone Retrofit Bath Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","67 Bright White (Matte)",null,null,null,"    12 Gray (Matte)",null,null,"    13 White (Polished)",null,null,null,null,null,null,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,"23 Bright White (Polished)",null,null,null,"    21 Gray (Polished)",null,null,null,null,null,null,null,null,null,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,"62 Cool Gray (Polished)",null,null,null,"    03 Sand (Matte)",null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"SBA184",null,null,null,"5\" Corner Soap Dish",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA264,AG264)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA264*(1-W264)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W264","v":0},24.35,{"$f":"(AG264-AC264)/AG264","v":0},null,5,{"$f":"SUM(AJ264:AL264)+AE264","v":24.35},null,null,{"$f":"ROUND(AC264/(1-VLOOKUP(AF264,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF264,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ264,1)-AJ264,2),Round,2,FALSE)+VLOOKUP(AF264,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF264,Group,7,FALSE)=\"\",0,ROUND(AJ264-0.04999,1)-AJ264+AM264)","v":0},{"$f":"IF(VLOOKUP(AF264,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF264,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"SBA183",null,null,null,"8\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA265,AG265)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA265*(1-W265)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG265-AC265)/AG265","v":0},null,5,{"$f":"SUM(AJ265:AL265)+AE265","v":38.85},null,null,{"$f":"ROUND(AC265/(1-VLOOKUP(AF265,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF265,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ265,1)-AJ265,2),Round,2,FALSE)+VLOOKUP(AF265,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF265,Group,7,FALSE)=\"\",0,ROUND(AJ265-0.04999,1)-AJ265+AM265)","v":0},{"$f":"IF(VLOOKUP(AF265,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF265,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"10\" Radius",null,"SBA185",null,null,null,"10\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA266,AG266)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA266*(1-W266)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG266-AC266)/AG266","v":0},null,5,{"$f":"SUM(AJ266:AL266)+AE266","v":52.8},null,null,{"$f":"ROUND(AC266/(1-VLOOKUP(AF266,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF266,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ266,1)-AJ266,2),Round,2,FALSE)+VLOOKUP(AF266,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF266,Group,7,FALSE)=\"\",0,ROUND(AJ266-0.04999,1)-AJ266+AM266)","v":0},{"$f":"IF(VLOOKUP(AF266,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF266,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"SBA186",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA267,AG267)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA267*(1-W267)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG267-AC267)/AG267","v":0},null,5,{"$f":"SUM(AJ267:AL267)+AE267","v":24.35},null,null,{"$f":"ROUND(AC267/(1-VLOOKUP(AF267,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF267,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ267,1)-AJ267,2),Round,2,FALSE)+VLOOKUP(AF267,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF267,Group,7,FALSE)=\"\",0,ROUND(AJ267-0.04999,1)-AJ267+AM267)","v":0},{"$f":"IF(VLOOKUP(AF267,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF267,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","086 Graphite (Matte)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"MBA184",null,null,null,"5\" Corner Soap Dish",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA271,AG271)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA271*(1-W271)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W271","v":0},24.35,{"$f":"(AG271-AC271)/AG271","v":0},null,5,{"$f":"SUM(AJ271:AL271)+AE271","v":24.35},null,null,{"$f":"ROUND(AC271/(1-VLOOKUP(AF271,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF271,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ271,1)-AJ271,2),Round,2,FALSE)+VLOOKUP(AF271,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF271,Group,7,FALSE)=\"\",0,ROUND(AJ271-0.04999,1)-AJ271+AM271)","v":0},{"$f":"IF(VLOOKUP(AF271,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF271,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"MBA183",null,null,null,"8\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA272,AG272)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA272*(1-W272)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG272-AC272)/AG272","v":0},null,5,{"$f":"SUM(AJ272:AL272)+AE272","v":38.85},null,null,{"$f":"ROUND(AC272/(1-VLOOKUP(AF272,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF272,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ272,1)-AJ272,2),Round,2,FALSE)+VLOOKUP(AF272,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF272,Group,7,FALSE)=\"\",0,ROUND(AJ272-0.04999,1)-AJ272+AM272)","v":0},{"$f":"IF(VLOOKUP(AF272,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF272,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"10\" Radius",null,"MBA185",null,null,null,"10\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA273,AG273)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA273*(1-W273)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG273-AC273)/AG273","v":0},null,5,{"$f":"SUM(AJ273:AL273)+AE273","v":52.8},null,null,{"$f":"ROUND(AC273/(1-VLOOKUP(AF273,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF273,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ273,1)-AJ273,2),Round,2,FALSE)+VLOOKUP(AF273,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF273,Group,7,FALSE)=\"\",0,ROUND(AJ273-0.04999,1)-AJ273+AM273)","v":0},{"$f":"IF(VLOOKUP(AF273,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF273,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"MBA186",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA274,AG274)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA274*(1-W274)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG274-AC274)/AG274","v":0},null,5,{"$f":"SUM(AJ274:AL274)+AE274","v":24.35},null,null,{"$f":"ROUND(AC274/(1-VLOOKUP(AF274,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF274,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ274,1)-AJ274,2),Round,2,FALSE)+VLOOKUP(AF274,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF274,Group,7,FALSE)=\"\",0,ROUND(AJ274-0.04999,1)-AJ274+AM274)","v":0},{"$f":"IF(VLOOKUP(AF274,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF274,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"METRO - Cast Metal Bath Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","024 Brushed Nickel          070 Dark Oil Rubbed Bronze",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"SBA112",null,null,null,"5\" Corner Soap Dish",null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA280,AG280)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA280*(1-W280)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W280","v":0},30.05,{"$f":"(AG280-AC280)/AG280","v":0},null,5,{"$f":"SUM(AJ280:AL280)+AE280","v":30.05},null,null,{"$f":"ROUND(AC280/(1-VLOOKUP(AF280,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF280,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ280,1)-AJ280,2),Round,2,FALSE)+VLOOKUP(AF280,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF280,Group,7,FALSE)=\"\",0,ROUND(AJ280-0.04999,1)-AJ280+AM280)","v":0},{"$f":"IF(VLOOKUP(AF280,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF280,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"SBA114",null,null,null,"8\" Corner Shelf",null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA281,AG281)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA281*(1-W281)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG281-AC281)/AG281","v":0},null,5,{"$f":"SUM(AJ281:AL281)+AE281","v":48},null,null,{"$f":"ROUND(AC281/(1-VLOOKUP(AF281,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF281,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ281,1)-AJ281,2),Round,2,FALSE)+VLOOKUP(AF281,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF281,Group,7,FALSE)=\"\",0,ROUND(AJ281-0.04999,1)-AJ281+AM281)","v":0},{"$f":"IF(VLOOKUP(AF281,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF281,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"SBA120",null,null,null,"5\" Footrest",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA282,AG282)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA282*(1-W282)+0.004999,2)","v":30.05},null,"",30.05,0,30.05,{"$f":"(AG282-AC282)/AG282","v":0},null,5,{"$f":"SUM(AJ282:AL282)+AE282","v":30.05},null,null,{"$f":"ROUND(AC282/(1-VLOOKUP(AF282,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF282,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ282,1)-AJ282,2),Round,2,FALSE)+VLOOKUP(AF282,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF282,Group,7,FALSE)=\"\",0,ROUND(AJ282-0.04999,1)-AJ282+AM282)","v":0},{"$f":"IF(VLOOKUP(AF282,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF282,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","042 Aztec Gold          002 Bronze          091 Copper",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"MBA112",null,null,null,"5\" Corner Soap Dish",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA286,AG286)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA286*(1-W286)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W286","v":0},30.05,{"$f":"(AG286-AC286)/AG286","v":0},null,5,{"$f":"SUM(AJ286:AL286)+AE286","v":30.05},null,null,{"$f":"ROUND(AC286/(1-VLOOKUP(AF286,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF286,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ286,1)-AJ286,2),Round,2,FALSE)+VLOOKUP(AF286,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF286,Group,7,FALSE)=\"\",0,ROUND(AJ286-0.04999,1)-AJ286+AM286)","v":0},{"$f":"IF(VLOOKUP(AF286,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF286,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"MBA114",null,null,null,"8\" Corner Shelf",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA287,AG287)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA287*(1-W287)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG287-AC287)/AG287","v":0},null,5,{"$f":"SUM(AJ287:AL287)+AE287","v":48},null,null,{"$f":"ROUND(AC287/(1-VLOOKUP(AF287,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF287,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ287,1)-AJ287,2),Round,2,FALSE)+VLOOKUP(AF287,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF287,Group,7,FALSE)=\"\",0,ROUND(AJ287-0.04999,1)-AJ287+AM287)","v":0},{"$f":"IF(VLOOKUP(AF287,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF287,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"MBA120",null,null,null,"5\" Footrest",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA288,AG288)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA288*(1-W288)+0.004999,2)","v":30.05},null,"",30.05,0,30.05,{"$f":"(AG288-AC288)/AG288","v":0},null,5,{"$f":"SUM(AJ288:AL288)+AE288","v":30.05},null,null,{"$f":"ROUND(AC288/(1-VLOOKUP(AF288,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF288,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ288,1)-AJ288,2),Round,2,FALSE)+VLOOKUP(AF288,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF288,Group,7,FALSE)=\"\",0,ROUND(AJ288-0.04999,1)-AJ288+AM288)","v":0},{"$f":"IF(VLOOKUP(AF288,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF288,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"METRO - Cast Metal Retrofit Bath Accessories",null,null,null,null,null,null,null,null,null," ",null,null,null,null,"Item # Lookup:","QCBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","024 Brushed Nickel          070 Dark Oil Rubbed Bronze",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"SBA156",null,null,null,"5\" Corner Soap Dish",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA294,AG294)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA294*(1-W294)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W294","v":0},30.05,{"$f":"(AG294-AC294)/AG294","v":0},null,5,{"$f":"SUM(AJ294:AL294)+AE294","v":30.05},null,null,{"$f":"ROUND(AC294/(1-VLOOKUP(AF294,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF294,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ294,1)-AJ294,2),Round,2,FALSE)+VLOOKUP(AF294,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF294,Group,7,FALSE)=\"\",0,ROUND(AJ294-0.04999,1)-AJ294+AM294)","v":0},{"$f":"IF(VLOOKUP(AF294,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF294,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"SBA154",null,null,null,"8\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA295,AG295)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA295*(1-W295)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG295-AC295)/AG295","v":0},null,5,{"$f":"SUM(AJ295:AL295)+AE295","v":48},null,null,{"$f":"ROUND(AC295/(1-VLOOKUP(AF295,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF295,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ295,1)-AJ295,2),Round,2,FALSE)+VLOOKUP(AF295,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF295,Group,7,FALSE)=\"\",0,ROUND(AJ295-0.04999,1)-AJ295+AM295)","v":0},{"$f":"IF(VLOOKUP(AF295,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF295,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"SBA158",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA296,AG296)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA296*(1-W296)+0.004999,2)","v":30.05},null,"",30.05,0,30.05,{"$f":"(AG296-AC296)/AG296","v":0},null,5,{"$f":"SUM(AJ296:AL296)+AE296","v":30.05},null,null,{"$f":"ROUND(AC296/(1-VLOOKUP(AF296,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF296,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ296,1)-AJ296,2),Round,2,FALSE)+VLOOKUP(AF296,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF296,Group,7,FALSE)=\"\",0,ROUND(AJ296-0.04999,1)-AJ296+AM296)","v":0},{"$f":"IF(VLOOKUP(AF296,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF296,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","042 Aztec Gold          002 Bronze          091 Copper",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"SBA156",null,null,null,"5\" Corner Soap Dish",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA300,AG300)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA300*(1-W300)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W300","v":0},30.05,{"$f":"(AG300-AC300)/AG300","v":0},null,5,{"$f":"SUM(AJ300:AL300)+AE300","v":30.05},null,null,{"$f":"ROUND(AC300/(1-VLOOKUP(AF300,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF300,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ300,1)-AJ300,2),Round,2,FALSE)+VLOOKUP(AF300,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF300,Group,7,FALSE)=\"\",0,ROUND(AJ300-0.04999,1)-AJ300+AM300)","v":0},{"$f":"IF(VLOOKUP(AF300,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF300,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"SBA154",null,null,null,"8\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA301,AG301)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA301*(1-W301)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG301-AC301)/AG301","v":0},null,5,{"$f":"SUM(AJ301:AL301)+AE301","v":48},null,null,{"$f":"ROUND(AC301/(1-VLOOKUP(AF301,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF301,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ301,1)-AJ301,2),Round,2,FALSE)+VLOOKUP(AF301,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF301,Group,7,FALSE)=\"\",0,ROUND(AJ301-0.04999,1)-AJ301+AM301)","v":0},{"$f":"IF(VLOOKUP(AF301,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF301,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"SBA158",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA302,AG302)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA302*(1-W302)+0.004999,2)","v":30.05},null,"",30.05,0,30.05,{"$f":"(AG302-AC302)/AG302","v":0},null,5,{"$f":"SUM(AJ302:AL302)+AE302","v":30.05},null,null,{"$f":"ROUND(AC302/(1-VLOOKUP(AF302,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF302,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ302,1)-AJ302,2),Round,2,FALSE)+VLOOKUP(AF302,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF302,Group,7,FALSE)=\"\",0,ROUND(AJ302-0.04999,1)-AJ302+AM302)","v":0},{"$f":"IF(VLOOKUP(AF302,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF302,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"METRO - Cast Stone Bath Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","086 Graphite (Matte)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"MBA112",null,null,null,"5\" Corner Soap Dish",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA308,AG308)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA308*(1-W308)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W308","v":0},24.35,{"$f":"(AG308-AC308)/AG308","v":0},null,5,{"$f":"SUM(AJ308:AL308)+AE308","v":24.35},null,null,{"$f":"ROUND(AC308/(1-VLOOKUP(AF308,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF308,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ308,1)-AJ308,2),Round,2,FALSE)+VLOOKUP(AF308,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF308,Group,7,FALSE)=\"\",0,ROUND(AJ308-0.04999,1)-AJ308+AM308)","v":0},{"$f":"IF(VLOOKUP(AF308,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF308,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"MBA114",null,null,null,"8\" Corner Shelf",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA309,AG309)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA309*(1-W309)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG309-AC309)/AG309","v":0},null,5,{"$f":"SUM(AJ309:AL309)+AE309","v":38.85},null,null,{"$f":"ROUND(AC309/(1-VLOOKUP(AF309,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF309,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ309,1)-AJ309,2),Round,2,FALSE)+VLOOKUP(AF309,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF309,Group,7,FALSE)=\"\",0,ROUND(AJ309-0.04999,1)-AJ309+AM309)","v":0},{"$f":"IF(VLOOKUP(AF309,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF309,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"10\" Radius",null,"MBA116",null,null,null,"10\" Corner Shelf",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA310,AG310)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA310*(1-W310)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG310-AC310)/AG310","v":0},null,5,{"$f":"SUM(AJ310:AL310)+AE310","v":52.8},null,null,{"$f":"ROUND(AC310/(1-VLOOKUP(AF310,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF310,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ310,1)-AJ310,2),Round,2,FALSE)+VLOOKUP(AF310,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF310,Group,7,FALSE)=\"\",0,ROUND(AJ310-0.04999,1)-AJ310+AM310)","v":0},{"$f":"IF(VLOOKUP(AF310,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF310,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"MBA120",null,null,null,"5\" Footrest",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA311,AG311)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA311*(1-W311)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG311-AC311)/AG311","v":0},null,5,{"$f":"SUM(AJ311:AL311)+AE311","v":24.35},null,null,{"$f":"ROUND(AC311/(1-VLOOKUP(AF311,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF311,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ311,1)-AJ311,2),Round,2,FALSE)+VLOOKUP(AF311,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF311,Group,7,FALSE)=\"\",0,ROUND(AJ311-0.04999,1)-AJ311+AM311)","v":0},{"$f":"IF(VLOOKUP(AF311,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF311,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","12 Gray (Matte)          67 Bright White (Matte)          03 Sand (Matte)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"SBA112",null,null,null,"5\" Corner Soap Dish",null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA315,AG315)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA315*(1-W315)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W315","v":0},24.35,{"$f":"(AG315-AC315)/AG315","v":0},null,5,{"$f":"SUM(AJ315:AL315)+AE315","v":24.35},null,null,{"$f":"ROUND(AC315/(1-VLOOKUP(AF315,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF315,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ315,1)-AJ315,2),Round,2,FALSE)+VLOOKUP(AF315,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF315,Group,7,FALSE)=\"\",0,ROUND(AJ315-0.04999,1)-AJ315+AM315)","v":0},{"$f":"IF(VLOOKUP(AF315,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF315,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"SBA114",null,null,null,"8\" Corner Shelf",null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA316,AG316)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA316*(1-W316)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG316-AC316)/AG316","v":0},null,5,{"$f":"SUM(AJ316:AL316)+AE316","v":38.85},null,null,{"$f":"ROUND(AC316/(1-VLOOKUP(AF316,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF316,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ316,1)-AJ316,2),Round,2,FALSE)+VLOOKUP(AF316,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF316,Group,7,FALSE)=\"\",0,ROUND(AJ316-0.04999,1)-AJ316+AM316)","v":0},{"$f":"IF(VLOOKUP(AF316,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF316,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"10\" Radius",null,"SBA116",null,null,null,"10\" Corner Shelf",null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA317,AG317)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA317*(1-W317)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG317-AC317)/AG317","v":0},null,5,{"$f":"SUM(AJ317:AL317)+AE317","v":52.8},null,null,{"$f":"ROUND(AC317/(1-VLOOKUP(AF317,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF317,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ317,1)-AJ317,2),Round,2,FALSE)+VLOOKUP(AF317,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF317,Group,7,FALSE)=\"\",0,ROUND(AJ317-0.04999,1)-AJ317+AM317)","v":0},{"$f":"IF(VLOOKUP(AF317,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF317,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"SBA120",null,null,null,"5\" Footrest",null,null,null,null,null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",AA318,AG318)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA318*(1-W318)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG318-AC318)/AG318","v":0},null,5,{"$f":"SUM(AJ318:AL318)+AE318","v":24.35},null,null,{"$f":"ROUND(AC318/(1-VLOOKUP(AF318,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF318,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ318,1)-AJ318,2),Round,2,FALSE)+VLOOKUP(AF318,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF318,Group,7,FALSE)=\"\",0,ROUND(AJ318-0.04999,1)-AJ318+AM318)","v":0},{"$f":"IF(VLOOKUP(AF318,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF318,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","23 Bright White (Polished)",null,null,null,"    21 Gray (Polished)",null,null,null,null,null,null,null,null,null,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,"62 Cool Gray (Polished)",null,null,null,"    13 White (Polished)",null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"SBA113",null,null,null,"5\" Corner Soap Dish",null,null,null,null,null,"Stock","b",{"$f":"IF(Suggested=\"Yes\",AA323,AG323)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA323*(1-W323)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W323","v":0},24.35,{"$f":"(AG323-AC323)/AG323","v":0},null,5,{"$f":"SUM(AJ323:AL323)+AE323","v":24.35},null,null,{"$f":"ROUND(AC323/(1-VLOOKUP(AF323,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF323,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ323,1)-AJ323,2),Round,2,FALSE)+VLOOKUP(AF323,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF323,Group,7,FALSE)=\"\",0,ROUND(AJ323-0.04999,1)-AJ323+AM323)","v":0},{"$f":"IF(VLOOKUP(AF323,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF323,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"SBA115",null,null,null,"8\" Corner Shelf",null,null,null,null,null,"Stock","b",{"$f":"IF(Suggested=\"Yes\",AA324,AG324)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA324*(1-W324)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG324-AC324)/AG324","v":0},null,5,{"$f":"SUM(AJ324:AL324)+AE324","v":38.85},null,null,{"$f":"ROUND(AC324/(1-VLOOKUP(AF324,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF324,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ324,1)-AJ324,2),Round,2,FALSE)+VLOOKUP(AF324,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF324,Group,7,FALSE)=\"\",0,ROUND(AJ324-0.04999,1)-AJ324+AM324)","v":0},{"$f":"IF(VLOOKUP(AF324,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF324,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"10\" Radius",null,"SBA117",null,null,null,"10\" Corner Shelf",null,null,null,null,null,"Stock","b",{"$f":"IF(Suggested=\"Yes\",AA325,AG325)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA325*(1-W325)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG325-AC325)/AG325","v":0},null,5,{"$f":"SUM(AJ325:AL325)+AE325","v":52.8},null,null,{"$f":"ROUND(AC325/(1-VLOOKUP(AF325,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF325,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ325,1)-AJ325,2),Round,2,FALSE)+VLOOKUP(AF325,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF325,Group,7,FALSE)=\"\",0,ROUND(AJ325-0.04999,1)-AJ325+AM325)","v":0},{"$f":"IF(VLOOKUP(AF325,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF325,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"SBA121",null,null,null,"5\" Footrest",null,null,null,null,null,"Stock","c",{"$f":"IF(Suggested=\"Yes\",AA326,AG326)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA326*(1-W326)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG326-AC326)/AG326","v":0},null,5,{"$f":"SUM(AJ326:AL326)+AE326","v":24.35},null,null,{"$f":"ROUND(AC326/(1-VLOOKUP(AF326,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF326,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ326,1)-AJ326,2),Round,2,FALSE)+VLOOKUP(AF326,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF326,Group,7,FALSE)=\"\",0,ROUND(AJ326-0.04999,1)-AJ326+AM326)","v":0},{"$f":"IF(VLOOKUP(AF326,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF326,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","a) Stocked in color 12 Gray (Matte) 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,"X"]
[null,null,null,null,"b) Not stocked in color 62 Cool Gray (Polished).",null,null,null,null,null,"c) Stocked in color 23 Bright White (Polished) 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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"METRO - Cast Stone Retrofit Bath Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","QCBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","67 Bright White (Matte)",null,null,null,"    12 Gray (Matte)",null,null,"    13 White (Polished)",null,null,null,null,null,null,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,"23 Bright White (Polished)",null,null,null,"    21 Gray (Polished)",null,null,null,null,null,null,null,null,null,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,"62 Cool Gray (Polished)",null,null,null,"    03 Sand (Matte)",null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"SBA157",null,null,null,"5\" Corner Soap Dish",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA337,AG337)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA337*(1-W337)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W337","v":0},24.35,{"$f":"(AG337-AC337)/AG337","v":0},null,5,{"$f":"SUM(AJ337:AL337)+AE337","v":24.35},null,null,{"$f":"ROUND(AC337/(1-VLOOKUP(AF337,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF337,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ337,1)-AJ337,2),Round,2,FALSE)+VLOOKUP(AF337,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF337,Group,7,FALSE)=\"\",0,ROUND(AJ337-0.04999,1)-AJ337+AM337)","v":0},{"$f":"IF(VLOOKUP(AF337,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF337,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"SBA155",null,null,null,"8\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA338,AG338)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA338*(1-W338)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG338-AC338)/AG338","v":0},null,5,{"$f":"SUM(AJ338:AL338)+AE338","v":38.85},null,null,{"$f":"ROUND(AC338/(1-VLOOKUP(AF338,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF338,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ338,1)-AJ338,2),Round,2,FALSE)+VLOOKUP(AF338,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF338,Group,7,FALSE)=\"\",0,ROUND(AJ338-0.04999,1)-AJ338+AM338)","v":0},{"$f":"IF(VLOOKUP(AF338,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF338,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"10\" Radius",null,"SBA153",null,null,null,"10\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA339,AG339)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA339*(1-W339)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG339-AC339)/AG339","v":0},null,5,{"$f":"SUM(AJ339:AL339)+AE339","v":52.8},null,null,{"$f":"ROUND(AC339/(1-VLOOKUP(AF339,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF339,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ339,1)-AJ339,2),Round,2,FALSE)+VLOOKUP(AF339,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF339,Group,7,FALSE)=\"\",0,ROUND(AJ339-0.04999,1)-AJ339+AM339)","v":0},{"$f":"IF(VLOOKUP(AF339,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF339,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"SBA159",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA340,AG340)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA340*(1-W340)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG340-AC340)/AG340","v":0},null,5,{"$f":"SUM(AJ340:AL340)+AE340","v":24.35},null,null,{"$f":"ROUND(AC340/(1-VLOOKUP(AF340,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF340,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ340,1)-AJ340,2),Round,2,FALSE)+VLOOKUP(AF340,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF340,Group,7,FALSE)=\"\",0,ROUND(AJ340-0.04999,1)-AJ340+AM340)","v":0},{"$f":"IF(VLOOKUP(AF340,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF340,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","086 Graphite (Matte)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fixtures",null,null,"5\" Radius",null,"MBA157",null,null,null,"5\" Corner Soap Dish",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA344,AG344)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA344*(1-W344)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W344","v":0},24.35,{"$f":"(AG344-AC344)/AG344","v":0},null,5,{"$f":"SUM(AJ344:AL344)+AE344","v":24.35},null,null,{"$f":"ROUND(AC344/(1-VLOOKUP(AF344,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF344,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ344,1)-AJ344,2),Round,2,FALSE)+VLOOKUP(AF344,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF344,Group,7,FALSE)=\"\",0,ROUND(AJ344-0.04999,1)-AJ344+AM344)","v":0},{"$f":"IF(VLOOKUP(AF344,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF344,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"MBA155",null,null,null,"8\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA345,AG345)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA345*(1-W345)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG345-AC345)/AG345","v":0},null,5,{"$f":"SUM(AJ345:AL345)+AE345","v":38.85},null,null,{"$f":"ROUND(AC345/(1-VLOOKUP(AF345,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF345,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ345,1)-AJ345,2),Round,2,FALSE)+VLOOKUP(AF345,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF345,Group,7,FALSE)=\"\",0,ROUND(AJ345-0.04999,1)-AJ345+AM345)","v":0},{"$f":"IF(VLOOKUP(AF345,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF345,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"10\" Radius",null,"MBA153",null,null,null,"10\" Corner Shelf",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA346,AG346)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA346*(1-W346)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG346-AC346)/AG346","v":0},null,5,{"$f":"SUM(AJ346:AL346)+AE346","v":52.8},null,null,{"$f":"ROUND(AC346/(1-VLOOKUP(AF346,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF346,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ346,1)-AJ346,2),Round,2,FALSE)+VLOOKUP(AF346,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF346,Group,7,FALSE)=\"\",0,ROUND(AJ346-0.04999,1)-AJ346+AM346)","v":0},{"$f":"IF(VLOOKUP(AF346,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF346,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"5\" x 5\"",null,"MBA159",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA347,AG347)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA347*(1-W347)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG347-AC347)/AG347","v":0},null,5,{"$f":"SUM(AJ347:AL347)+AE347","v":24.35},null,null,{"$f":"ROUND(AC347/(1-VLOOKUP(AF347,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF347,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ347,1)-AJ347,2),Round,2,FALSE)+VLOOKUP(AF347,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF347,Group,7,FALSE)=\"\",0,ROUND(AJ347-0.04999,1)-AJ347+AM347)","v":0},{"$f":"IF(VLOOKUP(AF347,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF347,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,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
[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":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page","www.questech.com"]
[]
[]
["Product","Direct Website Link"]
["Dorset Collection"]

{"sheet":"Changes","index":4,"n_rows":86,"n_cols":3,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
["2008-05-01","Fusion","Stone-Metal-Cast Color"]
["2008-05-01","Minted Metals","Oil Rubbed Finish"]
["2008-05-01","StoneShadow","Antique Relief"]
["2008-05-01","Portico Bath Accessories","Portico Post Set"]
["2008-05-01","Portico Bath Accessories","Portico 28\" Towel Bar"]
["2008-05-01","Portico Bath Accessories","Portico Paper Holder Set"]
["2009-11-01","Sculptured Metal"]
["2011-04-01","Portico Bath Accessories","Added colors Sand and Sahara"]
["2011-04-01","Cast Stone Switch Plates","Added colors Sand and Sahara"]
["2011-07-07","Cast Metal","New Colors & Decoratives added."]
["2011-07-07","Cast Metal Mosaics","Sarlite 1\" x 1\", Twill 1' x 2\" Brickjoint & Vista 1/2\" x 4\" Linear Brick."]
["2011-07-07","Cast Stone  ","New Colors & Decoratives added."]
["2011-07-07","Natural Stone","8 colors added with 3 sizes of field, 2 sizes of mosaics, Pencil & Cornice liners."]
["2012-05-17","Switch Plates - Cast Metal Magnetic"]
["2014-05-12","City Scape","Cast Metal Linear Field Tiles and Bullnose available in Burnished, Hammered and Water Finishes."]
["2014-05-12","Metro","Cast Metal and Cast Stone Bath Accessories."]
["2015-04-29","Metro","Cast Metal & Cast Stone Retrofit Bath Accessories"]
["2015-11-12","Jolly Liner","Cast Metal 1/2\" x 12\" Jolly available in 12 finishes and can be used as a liner, cap, mosaic element or deco accent."]
["2017-06-01","4 Shades of Gray","Decoratives"]
["2017-06-01","Grout Ready Niches","12\" x 12\" pre-finished niches in 4 colors and 4 designs."]
["2017-06-01","Jolly Liner","Cast Stone 1/2\" x 12\" Jolly available in 8 finishes and can be used as a liner, cap, mosaic element or deco accent."]
["2019-04-17","HIGH RELIEF LINER Cast Stone","There are 7 designs in 5 colors available."]
["2019-04-17","METRO Cast Stone Bath Accessories","The following colors have been added to all formats:  67 Bright White (Matte), 23 Bright White (Polished), 086 Graphite (Matte) and 21 Gray (Polished). "]
["2019-04-17","METRO Cast Stone Retrofit Bath Accessories","The following colors have been added to all formats:  67 Bright White (Matte), 23 Bright White (Polished), 086 Graphite (Matte) and 21 Gray (Polished). "]
["2019-04-17","GEO Cast Metal Bath Accessories","New accessories with a modern contemporary design."]
["2019-04-17","GEO Cast Metal Retrofit Bath Accessories","New accessories with a modern contemporary design."]
["2019-04-17","GEO Cast Stone Bath Accessories","New accessories with a modern contemporary design."]
["2019-04-17","GEO Cast Stone Retrofit Bath Accessories","New accessories with a modern contemporary design."]
["2021-08-26","Classic Metal Tile","Cast Metal Field, Mosaics & Liners."]
["2022-03-30","Jolly Liner - Cast Stone Decorative","Colors 67 Bright White (Matte), 23 Bright White (Polished) and 086 Graphite (Bright Satin) added. "]
["2022-03-30","Jolly Liner - Cast Metal Decorative","Color 042011 Aztec Gold (Eggshell) added."]
["2022-03-30","GEO Cast Metal Bath Accessories","Colors 042 Aztec Gold, 002 Bronze and 091 Copper added."]
["2022-03-30","GEO Cast Metal Retrofit Bath Accessories","Colors 042 Aztec Gold, 002 Bronze and 091 Copper added."]
["2022-03-30","GEO Cast Stone Bath Accessories","Color 62 Cool Gray (Polished) added."]
["2022-03-30","GEO Cast Stone Retrofit Bath Accessories","Color 62 Cool Gray (Polished) added."]
["2022-03-30","METRO Cast Metal Bath Accessories","Colors 042 Aztec Gold, 002 Bronze and 091 Copper added."]
["2022-03-30","METRO Cast Metal Retrofit Bath Accessories","Colors 042 Aztec Gold, 002 Bronze and 091 Copper added."]
["2022-03-30","METRO Cast Stone Bath Accessories","Color 62 Cool Gray (Polished) added."]
["2022-03-30","METRO Cast Stone Retrofit Bath Accessories","Color 62 Cool Gray (Polished) added."]
[]
[" "]
[]
["Discontinued Products"]
["2009-01-05","S1L125S - Noche & Travertine","Classic Stop/Outside Corner"]
["2009-01-05","S1L125T - Noche & Travertine","Classic Turn"]
["2009-01-05","S1L126S - Noche & Travertine","Classic Stop/Outside Corner"]
["2009-01-05","S1L126T - Noche & Travertine","Classic Turn"]
["2009-01-05","S1L127S - Noche & Travertine","Classic Ogee Stop/Outside Corner"]
["2009-01-05","S1L127T - Noche & Travertine","Classic Ogee Turn"]
["2009-01-05","S1L128S - Noche & Travertine","Classic Ogee Stop/Outside Corner"]
["2009-01-05","S1L128T - Noche & Travertine","Classic Ogee Turn"]
["2009-01-05","S1L101S - Noche & Travertine","Rope Stop/Outside Corner"]
["2009-01-05","S1L101T - Noche & Travertine","Rope Turn"]
["2009-01-05","S1L102S - Noche & Travertine","Fluted Stop/Outside Corner"]
["2009-01-05","S1L102T - Noche & Travertine","Fluted Turn"]
["2009-01-05","S1L103S - Noche & Travertine","Rope Ogee Stop/Outside Corner"]
["2009-01-05","S1L103T - Noche & Travertine","Rope Ogee Turn"]
["2009-01-05","S1L104S - Noche & Travertine","Cameo Ogee Stop/Outside Corner"]
["2009-01-05","S1L104T - Noche & Travertine","Cameo Ogee Turn"]
["2009-01-05","S1L105S - Noche & Travertine","Fruit Cameo Stop/Outside Corner"]
["2009-01-05","S1L106S - Noche & Travertine","Fiddlehead Stop/Outside Corner"]
["2011-07-07","CAST METAL","Colors 057 Aspen Silver and 058 Mesa Bronze.  Also the following decoratives:  Classic Field, Classic Dot, Fiddlehead Dot, Fiddlehead Deco, Fiddlehead Liner, Fiddlehead Mural, Fluted Liner, Fruit Bowl Mural, Pinwheel Dot, Pinwheel Deco, 1-1/4\"x12\" Rope Liner & 2-1/2\"x12\" Rope Ogee.     "]
["2011-07-07","CAST STONE","The following decoratives:  2-1/2\" x 12\" Cameo Ogee, 1-1/2\" x 12\" Classic Liner, 2-1/2\" x 12\" Classic Ogee, Fiddlehead Deco, Fiddlehead Liner, Fiddlehead Murals, Floral Dot, Fruit Cameo Deco, Fruit Cameo Liner, Fruit Bowl Murals, Fluted Liner, Pinwheel Dot, Pinwheel Deco, Rosette Dot & Rosette Deco.   "]
["2011-07-07","CAST STONE - Floor Accents","All items."]
["2011-07-07","FUSION","All items."]
["2012-11-19","Q-Seal Natural Stone","All colors and formats.  (Bianco Vero, Crema Castilla Honed, Crema Castilla Tumbled, Jerusalem Gold Honed, Tuscan Silver Honed, Villa Classica Tumbled, Villa Constatine Tumbled and Villa Mocha Tumbled.) "]
["2014-12-11","Stone Shadow","Entire Series."]
["2015-10-02","Minted Metals","Entire Series."]
["2015-10-02","Sculptured Metal","Entire Series."]
["2016-10-28","Natural Stone","Entire Series."]
["2017-06-01","CAST STONE - Decoratives - Classics","Entire Series."]
["2017-06-01","CAST STONE - Portico Bath Accessories","Entire Series."]
["2017-06-01","SWITCH PLATES - Cast Metal Magnetic","Entire Series."]
["2017-11-15","Cast Stone Decoratives/Classics","Entire Series."]
["2017-11-15","Cast Stone Portico Bath Accessories","Entire Series."]
["2017-11-15","Switch Plates Cast Metal Magnetic","Entire Series."]
["2019-04-17","METRO Cast Metal Bath Accessories","SBA118 5\" Wall Soap Dish in all colors."]
["2019-04-17","METRO Cast Stone Bath Accessories","Colors 02 Noche and 01 Travertine in all formats.  5\" Wall Soap Dish and 2\" Shower Hook only in all colors."]
["2019-04-17","METRO Cast Stone Retrofit Bath Accessories","Colors 02 Noche and 01 Travertine in all formats."]
["2019-04-17","SWITCH PLATES Cast Stone","Entire Series."]
["2021-08-26","4 Shades of Gray","Entire Series."]
["2021-08-26","Grout Ready Niches","All Cast Metal and Cast Stone Grout Ready Niches."]