{"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":12,"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,"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,null,null,null," "]
[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":370,"n_cols":41,"rows_kept":370,"cut":false,"hidden":false,"merged":[[10,14,10,15],[9,14,9,19],[9,22,9,23],[9,25,9,32],[13,30,13,32],[12,22,12,23],[12,14,12,19],[359,3,359,4],[18,2,18,19],[17,14,17,15],[354,2,354,19],[356,2,356,19],[20,2,20,19],[21,2,21,19],[14,13,15,19]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"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":"2024-02-28"},null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!C8=\"\",\"\",+Instructions!C8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code '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,"  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,"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,null,null,{"$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,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,{"$f":"IF(Suggested=\"Yes\",AA199,AG199)","v":9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA199*(1-W199)+0.004999,2)","v":9},null,"",9,{"$f":"+W199","v":0},{"$f":"+X199","v":9},{"$f":"(AG199-AC199)/AG199","v":0},null,3,{"$f":"SUM(AJ199:AL199)+AE199","v":9},null,null,{"$f":"ROUND(AC199/(1-VLOOKUP(AF199,Group,2,FALSE)),2)","v":9},{"$f":"IF(VLOOKUP(AF199,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ199,1)-AJ199,2),Round,2,FALSE)+VLOOKUP(AF199,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF199,Group,7,FALSE)=\"\",0,ROUND(AJ199-0.04999,1)-AJ199+AM199)","v":0},{"$f":"IF(VLOOKUP(AF199,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF199,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\",AA203,AG203)","v":9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA203*(1-W203)+0.004999,2)","v":9},null,"",9,{"$f":"+W203","v":0},{"$f":"+X203","v":9},{"$f":"(AG203-AC203)/AG203","v":0},null,3,{"$f":"SUM(AJ203:AL203)+AE203","v":9},null,null,{"$f":"ROUND(AC203/(1-VLOOKUP(AF203,Group,2,FALSE)),2)","v":9},{"$f":"IF(VLOOKUP(AF203,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ203,1)-AJ203,2),Round,2,FALSE)+VLOOKUP(AF203,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF203,Group,7,FALSE)=\"\",0,ROUND(AJ203-0.04999,1)-AJ203+AM203)","v":0},{"$f":"IF(VLOOKUP(AF203,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF203,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA212,AG212)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA212*(1-W212)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W212","v":0},30.05,{"$f":"(AG212-AC212)/AG212","v":0},null,5,{"$f":"SUM(AJ212:AL212)+AE212","v":30.05},null,null,{"$f":"ROUND(AC212/(1-VLOOKUP(AF212,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF212,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ212,1)-AJ212,2),Round,2,FALSE)+VLOOKUP(AF212,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF212,Group,7,FALSE)=\"\",0,ROUND(AJ212-0.04999,1)-AJ212+AM212)","v":0},{"$f":"IF(VLOOKUP(AF212,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF212,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\",AA213,AG213)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA213*(1-W213)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG213-AC213)/AG213","v":0},null,5,{"$f":"SUM(AJ213:AL213)+AE213","v":48},null,null,{"$f":"ROUND(AC213/(1-VLOOKUP(AF213,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF213,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ213,1)-AJ213,2),Round,2,FALSE)+VLOOKUP(AF213,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF213,Group,7,FALSE)=\"\",0,ROUND(AJ213-0.04999,1)-AJ213+AM213)","v":0},{"$f":"IF(VLOOKUP(AF213,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF213,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\",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA218,AG218)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA218*(1-W218)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W218","v":0},30.05,{"$f":"(AG218-AC218)/AG218","v":0},null,5,{"$f":"SUM(AJ218:AL218)+AE218","v":30.05},null,null,{"$f":"ROUND(AC218/(1-VLOOKUP(AF218,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF218,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ218,1)-AJ218,2),Round,2,FALSE)+VLOOKUP(AF218,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",0,ROUND(AJ218-0.04999,1)-AJ218+AM218)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF218,Group,7,FALSE))","v":""},null,"X"]
[null,"Fixtures",null,null,"8\" Radius",null,"MBA193",null,null,null,"8\" Corner Shelf",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA219,AG219)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA219*(1-W219)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG219-AC219)/AG219","v":0},null,5,{"$f":"SUM(AJ219:AL219)+AE219","v":48},null,null,{"$f":"ROUND(AC219/(1-VLOOKUP(AF219,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF219,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ219,1)-AJ219,2),Round,2,FALSE)+VLOOKUP(AF219,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF219,Group,7,FALSE)=\"\",0,ROUND(AJ219-0.04999,1)-AJ219+AM219)","v":0},{"$f":"IF(VLOOKUP(AF219,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF219,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\",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA226,AG226)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA226*(1-W226)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W226","v":0},30.05,{"$f":"(AG226-AC226)/AG226","v":0},null,5,{"$f":"SUM(AJ226:AL226)+AE226","v":30.05},null,null,{"$f":"ROUND(AC226/(1-VLOOKUP(AF226,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF226,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ226,1)-AJ226,2),Round,2,FALSE)+VLOOKUP(AF226,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF226,Group,7,FALSE)=\"\",0,ROUND(AJ226-0.04999,1)-AJ226+AM226)","v":0},{"$f":"IF(VLOOKUP(AF226,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF226,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\",AA227,AG227)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA227*(1-W227)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG227-AC227)/AG227","v":0},null,5,{"$f":"SUM(AJ227:AL227)+AE227","v":48},null,null,{"$f":"ROUND(AC227/(1-VLOOKUP(AF227,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF227,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ227,1)-AJ227,2),Round,2,FALSE)+VLOOKUP(AF227,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF227,Group,7,FALSE)=\"\",0,ROUND(AJ227-0.04999,1)-AJ227+AM227)","v":0},{"$f":"IF(VLOOKUP(AF227,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF227,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\",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA232,AG232)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA232*(1-W232)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W232","v":0},30.05,{"$f":"(AG232-AC232)/AG232","v":0},null,5,{"$f":"SUM(AJ232:AL232)+AE232","v":30.05},null,null,{"$f":"ROUND(AC232/(1-VLOOKUP(AF232,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF232,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ232,1)-AJ232,2),Round,2,FALSE)+VLOOKUP(AF232,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF232,Group,7,FALSE)=\"\",0,ROUND(AJ232-0.04999,1)-AJ232+AM232)","v":0},{"$f":"IF(VLOOKUP(AF232,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF232,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\",AA233,AG233)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA233*(1-W233)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG233-AC233)/AG233","v":0},null,5,{"$f":"SUM(AJ233:AL233)+AE233","v":48},null,null,{"$f":"ROUND(AC233/(1-VLOOKUP(AF233,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF233,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ233,1)-AJ233,2),Round,2,FALSE)+VLOOKUP(AF233,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF233,Group,7,FALSE)=\"\",0,ROUND(AJ233-0.04999,1)-AJ233+AM233)","v":0},{"$f":"IF(VLOOKUP(AF233,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF233,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\",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA242,AG242)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA242*(1-W242)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W242","v":0},24.35,{"$f":"(AG242-AC242)/AG242","v":0},null,5,{"$f":"SUM(AJ242:AL242)+AE242","v":24.35},null,null,{"$f":"ROUND(AC242/(1-VLOOKUP(AF242,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF242,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ242,1)-AJ242,2),Round,2,FALSE)+VLOOKUP(AF242,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF242,Group,7,FALSE)=\"\",0,ROUND(AJ242-0.04999,1)-AJ242+AM242)","v":0},{"$f":"IF(VLOOKUP(AF242,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF242,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\",AA243,AG243)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA243*(1-W243)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG243-AC243)/AG243","v":0},null,5,{"$f":"SUM(AJ243:AL243)+AE243","v":38.85},null,null,{"$f":"ROUND(AC243/(1-VLOOKUP(AF243,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF243,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ243,1)-AJ243,2),Round,2,FALSE)+VLOOKUP(AF243,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF243,Group,7,FALSE)=\"\",0,ROUND(AJ243-0.04999,1)-AJ243+AM243)","v":0},{"$f":"IF(VLOOKUP(AF243,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF243,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\",AA244,AG244)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA244*(1-W244)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG244-AC244)/AG244","v":0},null,5,{"$f":"SUM(AJ244:AL244)+AE244","v":52.8},null,null,{"$f":"ROUND(AC244/(1-VLOOKUP(AF244,Group,2,FALSE)),2)","v":52.8},{"$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,"5\" x 5\"",null,"SBA196",null,null,null,"5\" Footrest",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA245,AG245)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA245*(1-W245)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG245-AC245)/AG245","v":0},null,5,{"$f":"SUM(AJ245:AL245)+AE245","v":24.35},null,null,{"$f":"ROUND(AC245/(1-VLOOKUP(AF245,Group,2,FALSE)),2)","v":24.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA249,AG249)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA249*(1-W249)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W249","v":0},24.35,{"$f":"(AG249-AC249)/AG249","v":0},null,5,{"$f":"SUM(AJ249:AL249)+AE249","v":24.35},null,null,{"$f":"ROUND(AC249/(1-VLOOKUP(AF249,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF249,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ249,1)-AJ249,2),Round,2,FALSE)+VLOOKUP(AF249,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF249,Group,7,FALSE)=\"\",0,ROUND(AJ249-0.04999,1)-AJ249+AM249)","v":0},{"$f":"IF(VLOOKUP(AF249,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF249,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\",AA250,AG250)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA250*(1-W250)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG250-AC250)/AG250","v":0},null,5,{"$f":"SUM(AJ250:AL250)+AE250","v":38.85},null,null,{"$f":"ROUND(AC250/(1-VLOOKUP(AF250,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF250,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ250,1)-AJ250,2),Round,2,FALSE)+VLOOKUP(AF250,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF250,Group,7,FALSE)=\"\",0,ROUND(AJ250-0.04999,1)-AJ250+AM250)","v":0},{"$f":"IF(VLOOKUP(AF250,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF250,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\",AA251,AG251)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA251*(1-W251)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG251-AC251)/AG251","v":0},null,5,{"$f":"SUM(AJ251:AL251)+AE251","v":52.8},null,null,{"$f":"ROUND(AC251/(1-VLOOKUP(AF251,Group,2,FALSE)),2)","v":52.8},{"$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,"5\" x 5\"",null,"MBA196",null,null,null,"5\" Footrest",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA252,AG252)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA252*(1-W252)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG252-AC252)/AG252","v":0},null,5,{"$f":"SUM(AJ252:AL252)+AE252","v":24.35},null,null,{"$f":"ROUND(AC252/(1-VLOOKUP(AF252,Group,2,FALSE)),2)","v":24.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA262,AG262)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA262*(1-W262)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W262","v":0},24.35,{"$f":"(AG262-AC262)/AG262","v":0},null,5,{"$f":"SUM(AJ262:AL262)+AE262","v":24.35},null,null,{"$f":"ROUND(AC262/(1-VLOOKUP(AF262,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF262,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ262,1)-AJ262,2),Round,2,FALSE)+VLOOKUP(AF262,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF262,Group,7,FALSE)=\"\",0,ROUND(AJ262-0.04999,1)-AJ262+AM262)","v":0},{"$f":"IF(VLOOKUP(AF262,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF262,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\",AA263,AG263)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA263*(1-W263)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG263-AC263)/AG263","v":0},null,5,{"$f":"SUM(AJ263:AL263)+AE263","v":38.85},null,null,{"$f":"ROUND(AC263/(1-VLOOKUP(AF263,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF263,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ263,1)-AJ263,2),Round,2,FALSE)+VLOOKUP(AF263,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF263,Group,7,FALSE)=\"\",0,ROUND(AJ263-0.04999,1)-AJ263+AM263)","v":0},{"$f":"IF(VLOOKUP(AF263,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF263,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\",AA264,AG264)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA264*(1-W264)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG264-AC264)/AG264","v":0},null,5,{"$f":"SUM(AJ264:AL264)+AE264","v":52.8},null,null,{"$f":"ROUND(AC264/(1-VLOOKUP(AF264,Group,2,FALSE)),2)","v":52.8},{"$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,"5\" x 5\"",null,"SBA186",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA265,AG265)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA265*(1-W265)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG265-AC265)/AG265","v":0},null,5,{"$f":"SUM(AJ265:AL265)+AE265","v":24.35},null,null,{"$f":"ROUND(AC265/(1-VLOOKUP(AF265,Group,2,FALSE)),2)","v":24.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA269,AG269)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA269*(1-W269)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W269","v":0},24.35,{"$f":"(AG269-AC269)/AG269","v":0},null,5,{"$f":"SUM(AJ269:AL269)+AE269","v":24.35},null,null,{"$f":"ROUND(AC269/(1-VLOOKUP(AF269,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF269,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ269,1)-AJ269,2),Round,2,FALSE)+VLOOKUP(AF269,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF269,Group,7,FALSE)=\"\",0,ROUND(AJ269-0.04999,1)-AJ269+AM269)","v":0},{"$f":"IF(VLOOKUP(AF269,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF269,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\",AA270,AG270)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA270*(1-W270)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG270-AC270)/AG270","v":0},null,5,{"$f":"SUM(AJ270:AL270)+AE270","v":38.85},null,null,{"$f":"ROUND(AC270/(1-VLOOKUP(AF270,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF270,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ270,1)-AJ270,2),Round,2,FALSE)+VLOOKUP(AF270,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF270,Group,7,FALSE)=\"\",0,ROUND(AJ270-0.04999,1)-AJ270+AM270)","v":0},{"$f":"IF(VLOOKUP(AF270,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF270,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\",AA271,AG271)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA271*(1-W271)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG271-AC271)/AG271","v":0},null,5,{"$f":"SUM(AJ271:AL271)+AE271","v":52.8},null,null,{"$f":"ROUND(AC271/(1-VLOOKUP(AF271,Group,2,FALSE)),2)","v":52.8},{"$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,"5\" x 5\"",null,"MBA186",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA272,AG272)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA272*(1-W272)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG272-AC272)/AG272","v":0},null,5,{"$f":"SUM(AJ272:AL272)+AE272","v":24.35},null,null,{"$f":"ROUND(AC272/(1-VLOOKUP(AF272,Group,2,FALSE)),2)","v":24.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA278,AG278)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA278*(1-W278)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W278","v":0},30.05,{"$f":"(AG278-AC278)/AG278","v":0},null,5,{"$f":"SUM(AJ278:AL278)+AE278","v":30.05},null,null,{"$f":"ROUND(AC278/(1-VLOOKUP(AF278,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF278,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ278,1)-AJ278,2),Round,2,FALSE)+VLOOKUP(AF278,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF278,Group,7,FALSE)=\"\",0,ROUND(AJ278-0.04999,1)-AJ278+AM278)","v":0},{"$f":"IF(VLOOKUP(AF278,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF278,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\",AA279,AG279)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA279*(1-W279)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG279-AC279)/AG279","v":0},null,5,{"$f":"SUM(AJ279:AL279)+AE279","v":48},null,null,{"$f":"ROUND(AC279/(1-VLOOKUP(AF279,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF279,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ279,1)-AJ279,2),Round,2,FALSE)+VLOOKUP(AF279,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF279,Group,7,FALSE)=\"\",0,ROUND(AJ279-0.04999,1)-AJ279+AM279)","v":0},{"$f":"IF(VLOOKUP(AF279,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF279,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\",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA284,AG284)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA284*(1-W284)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W284","v":0},30.05,{"$f":"(AG284-AC284)/AG284","v":0},null,5,{"$f":"SUM(AJ284:AL284)+AE284","v":30.05},null,null,{"$f":"ROUND(AC284/(1-VLOOKUP(AF284,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF284,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ284,1)-AJ284,2),Round,2,FALSE)+VLOOKUP(AF284,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF284,Group,7,FALSE)=\"\",0,ROUND(AJ284-0.04999,1)-AJ284+AM284)","v":0},{"$f":"IF(VLOOKUP(AF284,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF284,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\",AA285,AG285)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA285*(1-W285)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG285-AC285)/AG285","v":0},null,5,{"$f":"SUM(AJ285:AL285)+AE285","v":48},null,null,{"$f":"ROUND(AC285/(1-VLOOKUP(AF285,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF285,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ285,1)-AJ285,2),Round,2,FALSE)+VLOOKUP(AF285,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF285,Group,7,FALSE)=\"\",0,ROUND(AJ285-0.04999,1)-AJ285+AM285)","v":0},{"$f":"IF(VLOOKUP(AF285,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF285,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\",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA292,AG292)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA292*(1-W292)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W292","v":0},30.05,{"$f":"(AG292-AC292)/AG292","v":0},null,5,{"$f":"SUM(AJ292:AL292)+AE292","v":30.05},null,null,{"$f":"ROUND(AC292/(1-VLOOKUP(AF292,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF292,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ292,1)-AJ292,2),Round,2,FALSE)+VLOOKUP(AF292,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF292,Group,7,FALSE)=\"\",0,ROUND(AJ292-0.04999,1)-AJ292+AM292)","v":0},{"$f":"IF(VLOOKUP(AF292,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF292,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\",AA293,AG293)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA293*(1-W293)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG293-AC293)/AG293","v":0},null,5,{"$f":"SUM(AJ293:AL293)+AE293","v":48},null,null,{"$f":"ROUND(AC293/(1-VLOOKUP(AF293,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF293,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ293,1)-AJ293,2),Round,2,FALSE)+VLOOKUP(AF293,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF293,Group,7,FALSE)=\"\",0,ROUND(AJ293-0.04999,1)-AJ293+AM293)","v":0},{"$f":"IF(VLOOKUP(AF293,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF293,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\",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA298,AG298)","v":30.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA298*(1-W298)+0.004999,2)","v":30.05},null,"",30.05,{"$f":"+W298","v":0},30.05,{"$f":"(AG298-AC298)/AG298","v":0},null,5,{"$f":"SUM(AJ298:AL298)+AE298","v":30.05},null,null,{"$f":"ROUND(AC298/(1-VLOOKUP(AF298,Group,2,FALSE)),2)","v":30.05},{"$f":"IF(VLOOKUP(AF298,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ298,1)-AJ298,2),Round,2,FALSE)+VLOOKUP(AF298,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF298,Group,7,FALSE)=\"\",0,ROUND(AJ298-0.04999,1)-AJ298+AM298)","v":0},{"$f":"IF(VLOOKUP(AF298,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF298,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\",AA299,AG299)","v":48},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA299*(1-W299)+0.004999,2)","v":48},null,"",48,0,48,{"$f":"(AG299-AC299)/AG299","v":0},null,5,{"$f":"SUM(AJ299:AL299)+AE299","v":48},null,null,{"$f":"ROUND(AC299/(1-VLOOKUP(AF299,Group,2,FALSE)),2)","v":48},{"$f":"IF(VLOOKUP(AF299,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ299,1)-AJ299,2),Round,2,FALSE)+VLOOKUP(AF299,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF299,Group,7,FALSE)=\"\",0,ROUND(AJ299-0.04999,1)-AJ299+AM299)","v":0},{"$f":"IF(VLOOKUP(AF299,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF299,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\",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA306,AG306)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA306*(1-W306)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W306","v":0},24.35,{"$f":"(AG306-AC306)/AG306","v":0},null,5,{"$f":"SUM(AJ306:AL306)+AE306","v":24.35},null,null,{"$f":"ROUND(AC306/(1-VLOOKUP(AF306,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF306,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ306,1)-AJ306,2),Round,2,FALSE)+VLOOKUP(AF306,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF306,Group,7,FALSE)=\"\",0,ROUND(AJ306-0.04999,1)-AJ306+AM306)","v":0},{"$f":"IF(VLOOKUP(AF306,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF306,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\",AA307,AG307)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA307*(1-W307)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG307-AC307)/AG307","v":0},null,5,{"$f":"SUM(AJ307:AL307)+AE307","v":38.85},null,null,{"$f":"ROUND(AC307/(1-VLOOKUP(AF307,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF307,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ307,1)-AJ307,2),Round,2,FALSE)+VLOOKUP(AF307,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF307,Group,7,FALSE)=\"\",0,ROUND(AJ307-0.04999,1)-AJ307+AM307)","v":0},{"$f":"IF(VLOOKUP(AF307,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF307,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\",AA308,AG308)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA308*(1-W308)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG308-AC308)/AG308","v":0},null,5,{"$f":"SUM(AJ308:AL308)+AE308","v":52.8},null,null,{"$f":"ROUND(AC308/(1-VLOOKUP(AF308,Group,2,FALSE)),2)","v":52.8},{"$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,"5\" x 5\"",null,"MBA120",null,null,null,"5\" Footrest",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA309,AG309)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA309*(1-W309)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG309-AC309)/AG309","v":0},null,5,{"$f":"SUM(AJ309:AL309)+AE309","v":24.35},null,null,{"$f":"ROUND(AC309/(1-VLOOKUP(AF309,Group,2,FALSE)),2)","v":24.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA313,AG313)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA313*(1-W313)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W313","v":0},24.35,{"$f":"(AG313-AC313)/AG313","v":0},null,5,{"$f":"SUM(AJ313:AL313)+AE313","v":24.35},null,null,{"$f":"ROUND(AC313/(1-VLOOKUP(AF313,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF313,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ313,1)-AJ313,2),Round,2,FALSE)+VLOOKUP(AF313,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF313,Group,7,FALSE)=\"\",0,ROUND(AJ313-0.04999,1)-AJ313+AM313)","v":0},{"$f":"IF(VLOOKUP(AF313,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF313,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\",AA314,AG314)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA314*(1-W314)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG314-AC314)/AG314","v":0},null,5,{"$f":"SUM(AJ314:AL314)+AE314","v":38.85},null,null,{"$f":"ROUND(AC314/(1-VLOOKUP(AF314,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF314,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ314,1)-AJ314,2),Round,2,FALSE)+VLOOKUP(AF314,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF314,Group,7,FALSE)=\"\",0,ROUND(AJ314-0.04999,1)-AJ314+AM314)","v":0},{"$f":"IF(VLOOKUP(AF314,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF314,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\",AA315,AG315)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA315*(1-W315)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG315-AC315)/AG315","v":0},null,5,{"$f":"SUM(AJ315:AL315)+AE315","v":52.8},null,null,{"$f":"ROUND(AC315/(1-VLOOKUP(AF315,Group,2,FALSE)),2)","v":52.8},{"$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,"5\" x 5\"",null,"SBA120",null,null,null,"5\" Footrest",null,null,null,null,null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",AA316,AG316)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA316*(1-W316)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG316-AC316)/AG316","v":0},null,5,{"$f":"SUM(AJ316:AL316)+AE316","v":24.35},null,null,{"$f":"ROUND(AC316/(1-VLOOKUP(AF316,Group,2,FALSE)),2)","v":24.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA321,AG321)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA321*(1-W321)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W321","v":0},24.35,{"$f":"(AG321-AC321)/AG321","v":0},null,5,{"$f":"SUM(AJ321:AL321)+AE321","v":24.35},null,null,{"$f":"ROUND(AC321/(1-VLOOKUP(AF321,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF321,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ321,1)-AJ321,2),Round,2,FALSE)+VLOOKUP(AF321,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF321,Group,7,FALSE)=\"\",0,ROUND(AJ321-0.04999,1)-AJ321+AM321)","v":0},{"$f":"IF(VLOOKUP(AF321,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF321,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\",AA322,AG322)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA322*(1-W322)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG322-AC322)/AG322","v":0},null,5,{"$f":"SUM(AJ322:AL322)+AE322","v":38.85},null,null,{"$f":"ROUND(AC322/(1-VLOOKUP(AF322,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF322,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ322,1)-AJ322,2),Round,2,FALSE)+VLOOKUP(AF322,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF322,Group,7,FALSE)=\"\",0,ROUND(AJ322-0.04999,1)-AJ322+AM322)","v":0},{"$f":"IF(VLOOKUP(AF322,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF322,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\",AA323,AG323)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA323*(1-W323)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG323-AC323)/AG323","v":0},null,5,{"$f":"SUM(AJ323:AL323)+AE323","v":52.8},null,null,{"$f":"ROUND(AC323/(1-VLOOKUP(AF323,Group,2,FALSE)),2)","v":52.8},{"$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,"5\" x 5\"",null,"SBA121",null,null,null,"5\" Footrest",null,null,null,null,null,"Stock","c",{"$f":"IF(Suggested=\"Yes\",AA324,AG324)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA324*(1-W324)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG324-AC324)/AG324","v":0},null,5,{"$f":"SUM(AJ324:AL324)+AE324","v":24.35},null,null,{"$f":"ROUND(AC324/(1-VLOOKUP(AF324,Group,2,FALSE)),2)","v":24.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA335,AG335)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA335*(1-W335)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W335","v":0},24.35,{"$f":"(AG335-AC335)/AG335","v":0},null,5,{"$f":"SUM(AJ335:AL335)+AE335","v":24.35},null,null,{"$f":"ROUND(AC335/(1-VLOOKUP(AF335,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF335,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ335,1)-AJ335,2),Round,2,FALSE)+VLOOKUP(AF335,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF335,Group,7,FALSE)=\"\",0,ROUND(AJ335-0.04999,1)-AJ335+AM335)","v":0},{"$f":"IF(VLOOKUP(AF335,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF335,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\",AA336,AG336)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA336*(1-W336)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG336-AC336)/AG336","v":0},null,5,{"$f":"SUM(AJ336:AL336)+AE336","v":38.85},null,null,{"$f":"ROUND(AC336/(1-VLOOKUP(AF336,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF336,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ336,1)-AJ336,2),Round,2,FALSE)+VLOOKUP(AF336,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF336,Group,7,FALSE)=\"\",0,ROUND(AJ336-0.04999,1)-AJ336+AM336)","v":0},{"$f":"IF(VLOOKUP(AF336,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF336,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\",AA337,AG337)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA337*(1-W337)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG337-AC337)/AG337","v":0},null,5,{"$f":"SUM(AJ337:AL337)+AE337","v":52.8},null,null,{"$f":"ROUND(AC337/(1-VLOOKUP(AF337,Group,2,FALSE)),2)","v":52.8},{"$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,"5\" x 5\"",null,"SBA159",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA338,AG338)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA338*(1-W338)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG338-AC338)/AG338","v":0},null,5,{"$f":"SUM(AJ338:AL338)+AE338","v":24.35},null,null,{"$f":"ROUND(AC338/(1-VLOOKUP(AF338,Group,2,FALSE)),2)","v":24.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA342,AG342)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA342*(1-W342)+0.004999,2)","v":24.35},null,"",24.35,{"$f":"+W342","v":0},24.35,{"$f":"(AG342-AC342)/AG342","v":0},null,5,{"$f":"SUM(AJ342:AL342)+AE342","v":24.35},null,null,{"$f":"ROUND(AC342/(1-VLOOKUP(AF342,Group,2,FALSE)),2)","v":24.35},{"$f":"IF(VLOOKUP(AF342,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ342,1)-AJ342,2),Round,2,FALSE)+VLOOKUP(AF342,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF342,Group,7,FALSE)=\"\",0,ROUND(AJ342-0.04999,1)-AJ342+AM342)","v":0},{"$f":"IF(VLOOKUP(AF342,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF342,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\",AA343,AG343)","v":38.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA343*(1-W343)+0.004999,2)","v":38.85},null,"",38.85,0,38.85,{"$f":"(AG343-AC343)/AG343","v":0},null,5,{"$f":"SUM(AJ343:AL343)+AE343","v":38.85},null,null,{"$f":"ROUND(AC343/(1-VLOOKUP(AF343,Group,2,FALSE)),2)","v":38.85},{"$f":"IF(VLOOKUP(AF343,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ343,1)-AJ343,2),Round,2,FALSE)+VLOOKUP(AF343,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF343,Group,7,FALSE)=\"\",0,ROUND(AJ343-0.04999,1)-AJ343+AM343)","v":0},{"$f":"IF(VLOOKUP(AF343,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF343,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\",AA344,AG344)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA344*(1-W344)+0.004999,2)","v":52.8},null,"",52.8,0,52.8,{"$f":"(AG344-AC344)/AG344","v":0},null,5,{"$f":"SUM(AJ344:AL344)+AE344","v":52.8},null,null,{"$f":"ROUND(AC344/(1-VLOOKUP(AF344,Group,2,FALSE)),2)","v":52.8},{"$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,"5\" x 5\"",null,"MBA159",null,null,null,"5\" Footrest",null,null,"(Retrofit)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA345,AG345)","v":24.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA345*(1-W345)+0.004999,2)","v":24.35},null,"",24.35,0,24.35,{"$f":"(AG345-AC345)/AG345","v":0},null,5,{"$f":"SUM(AJ345:AL345)+AE345","v":24.35},null,null,{"$f":"ROUND(AC345/(1-VLOOKUP(AF345,Group,2,FALSE)),2)","v":24.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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."]