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

{"sheet":"Instructions","index":0,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Schluter Kerdi-Board"]
["File as","S"]
["Product Code","N"]
["CCTD Effective Date","10/1/25"]
[]
[]
[]
["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":"N"},0,"  This is a \"NET\" price list.  0% is the discount for this spreadsheet"]
[]
[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,null," "]
[null,1,null,"Board - Stock",null,"No",0]
[null,2,null,"Board - Non-Stock",null,"No",0]
[null,3,null,"Accessories",null,"No",0]
[null,4,null,0,null,"No",0]
[null,5,null,0,null,"No",0]
[null,6,null,0,null,"No",0]
[null,7,null,0,null,"No",0]
[]
["If you want to manually adjust your price list, hit \"F5\" and go to \"Customer_Cost\" to manually adjust pricing."]
["You can enter a value in the column labeled \"Adj.\" to change your price manually."]
[]
[null,"Click on \"Your Price Calculation\" to set the print area for your personal cost calculation report."]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Your Price List\" to set the print area for your personal price list."]
[null,"Then you can send it to print"]
[null,null,null,null,null,null,null,"Yes"]
[]
["If you have any questions on how to best use this spreadsheet, please feel free to contact"]
["Jim Vogel at (800) 422-6860, ext. 4201 or via e-mail at jimvogel@cctd.com"]

{"sheet":"Index","index":1,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,0,5,10],[49,0,49,10],[51,0,51,10],[2,5,2,10],[3,4,3,7]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'S' - Schluter Kerdi-Board"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 10/1/25"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[null,null,"Boards"]
["1",null,"KERDI-BOARD"]
["1",null,"KERDI-BOARD - V"]
["1",null,"KERDI-BOARD - E"]
["1",null,"KERDI-BOARD - U"]
["1",null,"KERDI-BOARD - KIT"]
[null,null,"Accessories"]
["1",null,"KERDI-BOARD - ZW"]
[2,null,"KERDI-BOARD - ZC"]
[2,null,"KERDI-BOARD - ZA"]
[2,null,"KERDI-BOARD - ZB"]
[2,null,"KERDI-BOARD - ZFP"]
[2,null,"KERDI-BOARD - ZSD"]
[2,null,"KERDI-BOARD - ZT"]
[3,null,"KERDI-BOARD - ZS"]
[3,null,"KERDI-BOARD - ZT/ -ZS"]
["3",null,"KERDI-BOARD - ZDK"]
["3",null,"KERDI-BOARD - ZSA"]
[null,null,"Benches"]
["3",null,"KERDI-BOARD-SB"]
[null,null,"Shower Curb"]
["3",null,"KERDI-BOARD-SC"]
[null,null,"Niches"]
["3",null,"KERDI-BOARD-SN"]
[3,null,"KERDI-BOARD-SNLT w/ LIPROTEC LED LIGHTING"]
[null,null,"KERDI-BOARD-SNLT Cables"]
[4,null,"LIPROTEC-CW"]
[null,null,"KERDI-BOARD-SNLT Drivers"]
[4,null,"LIPROTEC-ECX"]
[4,null,"LIPROTEC-ECD"]
[4,null,"DESIGN-NICHE"]
[]
[]
[]
[]
[]
[]
[]
["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":349,"n_cols":41,"rows_kept":349,"cut":false,"hidden":false,"merged":[[20,2,20,19],[14,13,15,19],[338,3,338,4],[18,2,18,19],[17,14,17,15],[330,2,330,19],[202,2,202,19],[215,2,215,19],[268,2,268,19],[257,2,257,19],[9,25,9,32],[12,22,12,23],[334,2,334,19],[332,2,332,19],[10,14,10,15],[9,14,9,19],[9,22,9,23],[12,13,12,19],[84,2,84,19],[22,2,22,19],[227,2,227,19],[13,30,13,32]]}
[null,"Board - Stock",null,null,"Size",null,"Thickness",null,null,"Description",null,null,null,null,null,"Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},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,"Board - Non-Stock",null,null,"Size",null,"Thickness",null,null,"Description",null,null,null,null,null,"Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA2,AG2)","v":0.05},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},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,"Accessories",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,3,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,4,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,5,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,6,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,7,0,null,null,0,0,0,"",null,"X"]
[null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","a",1000,"ABC",null,null,0.1,1000,null,"ABC",1000,0.1,1000,0.1,10,null,1000,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price List",null,null,null,null,null,null,null,"Cust. Cost",null,null,"Customer Cost Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Sizes & Shapes",null,null,null,null,null,null,null,"Schluter Part #",null,null,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",AA11,AG11)","v":"Net Price"},"U/M","Code",null,"Disc.","Net",null,"Chg","Net Price","Disc","Act. Cost","GP%","Adj.","Group","Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'S' - Schluter Kerdi-Board"},null,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":"10/1/25"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-08-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 'N'"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$C$8=\"\",\"\",Instructions!$C$8)","v":""},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,"Schluter Part #",null,null,"Full Carton",null,"Stock","Note",{"$f":"+S$11","v":"Net Price"},"U/M",{"$f":"+U$11","v":"Code"},null,"Disc.","Net",null,"Chg","Net Price",{"$f":"+AB$11","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$11","v":"Group"},"Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,"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,"PRICING LISTED IS NET PRICING. TRADE DISCOUNTS DO NOT APPLY.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"BOARDS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"KERDI-BOARD",null,null,null,null,null,"  ",null," ",null," ",null,null,null,null,"Item # Lookup:","SHKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Multifunctional tile substrate and building panel, which can also be used for creating bonded waterproofing assemblies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"with tile coverings.  It consists of an extruded polystyrene foam panel, with a special reinforcement material on both",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"sides and fleece webbing for effective anchoring in thin-set mortar.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,"32\" x 48\"",null,"1/2\" thickness",null,null,null,null,"KB121220812",null,null,null,"144 Sheets/Pallet",null,null,{"$f":"IF(Suggested=\"Yes\",AA31,AG31)","v":36.5},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":36.5},null,"YES",36.5,{"$f":"+W31","v":0},{"$f":"+X31","v":36.5},{"$f":"(AG31-AC31)/AG31","v":0},null,2,{"$f":"SUM(AJ31:AL31)+AE31","v":36.5},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":36.5},{"$f":"IF(VLOOKUP(AF31,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ31,1)-AJ31,2),Round,2,FALSE)+VLOOKUP(AF31,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",0,ROUND(AJ31-0.04999,1)-AJ31+AM31)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF31,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Board - Non-Stock",null,null,"48\" x 64\"",null,"3/16\" thickness",null,null,null,null,"KB512201625",null,null,null," 10 Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA33,AG33)","v":66.599999999999994},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA33*(1-W33)+0.004999,2)","v":66.599999999999994},null,"YES",66.599999999999994,{"$f":"+W33","v":0},{"$f":"+X33","v":66.599999999999994},{"$f":"(AG33-AC33)/AG33","v":0},null,2,{"$f":"SUM(AJ33:AL33)+AE33","v":66.599999999999994},null,null,{"$f":"ROUND(AC33/(1-VLOOKUP(AF33,Group,2,FALSE)),2)","v":66.599999999999994},{"$f":"IF(VLOOKUP(AF33,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ33,1)-AJ33,2),Round,2,FALSE)+VLOOKUP(AF33,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",0,ROUND(AJ33-0.04999,1)-AJ33+AM33)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF33,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"48\" x 64\"",null,"3/8\" thickness",null,null,null,null,"KB912201625",null,null,null,"8 Sheets/Bundle",null,null,70.3,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},70.3,null,"YES",70.3,0,70.3,0,null,2,70.3,null,null,70.3,0,0,"",null,"X"]
[null,"Board - Stock",null,null,"48\" x 64\"",null,"1/2\" thickness",null,null,null,null,"KB1212201625",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA35,AG35)","v":69.599999999999994},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},69.599999999999994,null,"YES",69.599999999999994,0,69.599999999999994,0,null,1,69.599999999999994,null,null,69.599999999999994,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,"Board - Non-Stock",null,null,"48\" x 96\"",null,"3/16\" thickness",null,null,null,null,"KB512202440",null,null,null,"6 Sheets/Bundle",null,null,99.95,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},99.95,null,"YES",99.95,0,99.95,0,null,2,99.95,null,null,99.95,0,0,"",null,"X"]
[null,"Board - Non-Stock",null,null,"48\" x 96\"",null,"3/8\" thickness",null,null,null,null,"KB912202440",null,null,null,"5 Sheets/Bundle",null,null,105.4,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},105.4,null,"YES",105.4,0,105.4,0,null,2,105.4,null,null,105.4,0,0,"",null,"X"]
[null,"Board - Stock",null,null,"48\" x 96\"",null,"1/2\" thickness",null,null,null,null,"KB1212202440",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA39,AG39)","v":104.55},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},104.55,null,"YES",104.55,0,104.55,0,null,1,104.55,null,null,104.55,0,0,"",null,"X"]
[null,"Board - Non-Stock",null,null,"48\" x 96\"",null,"5/8\" thickness",null,null,null,null,"KB1512202440",null,null,null,"65 Sheets/Pallet",null,null,{"$f":"IF(Suggested=\"Yes\",AA40,AG40)","v":124.75},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},124.75,null,"YES",124.75,0,124.75,0,null,2,124.75,null,null,124.75,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,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"3/4\" thickness",null,null," ",null,"KB196252440",null,null,null,"6 Sheets/Bundle",null,null,61.45,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},61.45,null,"YES",61.45,0,61.45,0,null,2,61.45,null,null,61.45,0,0,"",null,"X"]
[null,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"1\" thickness",null,null,null,null,"KB256252440",null,null,null,"4 Sheets/Bundle",null,null,65,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},65,null,"YES",65,0,65,0,null,2,65,null,null,65,0,0,"",null,"X"]
[null,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"1-1/2\" thickness",null,null,null,null,"KB386252440",null,null,null,"3 Sheets/Bundle",null,null,75.400000000000006,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},75.400000000000006,null,"YES",75.400000000000006,0,75.400000000000006,0,null,2,75.400000000000006,null,null,75.400000000000006,0,0,"",null,"X"]
[null,"Board - Stock",null,null,"24-1/2\" x 96\"",null,"2\" thickness",null,null,null,null,"KB506252440",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA45,AG45)","v":80.25},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},80.25,null,"YES",80.25,0,80.25,0,null,1,80.25,null,null,80.25,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Board - Non-Stock",null,null,"48\" x 120\"",null,"5/8\" thickness",null,null,null,null,"KB1512203050",null,null,null,"See Note",null,"a",{"$f":"IF(Suggested=\"Yes\",AA47,AG47)","v":156.05000000000001},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA47*(1-W47)+0.004999,2)","v":156.05000000000001},null,"YES",156.05000000000001,{"$f":"+W47","v":0},{"$f":"+X47","v":156.05000000000001},{"$f":"(AG47-AC47)/AG47","v":0},null,2,{"$f":"SUM(AJ47:AL47)+AE47","v":156.05000000000001},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":156.05000000000001},{"$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,null,null,"Notes:","a) Special Order Only.  Contact customer service for lead time and any quantity restrictions.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"KERDI-BOARD - V",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Vertically grooved substrate and building panel for creating curved elements.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"3/4\" thickness",null,null,null,null,"KB196252440V",null,null,null,"6 Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA55,AG55)","v":72.5},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA55*(1-W55)+0.004999,2)","v":72.5},null,"YES",72.5,{"$f":"+W55","v":0},72.5,{"$f":"(AG55-AC55)/AG55","v":0},null,2,{"$f":"SUM(AJ55:AL55)+AE55","v":72.5},null,null,{"$f":"ROUND(AC55/(1-VLOOKUP(AF55,Group,2,FALSE)),2)","v":72.5},{"$f":"IF(VLOOKUP(AF55,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ55,1)-AJ55,2),Round,2,FALSE)+VLOOKUP(AF55,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF55,Group,7,FALSE)=\"\",0,ROUND(AJ55-0.04999,1)-AJ55+AM55)","v":0},{"$f":"IF(VLOOKUP(AF55,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF55,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"1\" thickness",null,null,null,null,"KB256252440V",null,null,null,"4 Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA56,AG56)","v":79.099999999999994},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":79.099999999999994},null,"YES",79.099999999999994,0,79.099999999999994,{"$f":"(AG56-AC56)/AG56","v":0},null,2,{"$f":"SUM(AJ56:AL56)+AE56","v":79.099999999999994},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":79.099999999999994},{"$f":"IF(VLOOKUP(AF56,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ56,1)-AJ56,2),Round,2,FALSE)+VLOOKUP(AF56,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",0,ROUND(AJ56-0.04999,1)-AJ56+AM56)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF56,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"1-1/2\" thickness",null,null,null,null,"KB386252440V",null,null,null,"3 Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA57,AG57)","v":87.9},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA57*(1-W57)+0.004999,2)","v":87.9},null,"YES",87.9,0,87.9,{"$f":"(AG57-AC57)/AG57","v":0},null,2,{"$f":"SUM(AJ57:AL57)+AE57","v":87.9},null,null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":87.9},{"$f":"IF(VLOOKUP(AF57,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ57,1)-AJ57,2),Round,2,FALSE)+VLOOKUP(AF57,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",0,ROUND(AJ57-0.04999,1)-AJ57+AM57)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF57,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"2\" thickness",null,null,null,null,"KB506252440V",null,null,null,"3 Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA58,AG58)","v":97.45},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA58*(1-W58)+0.004999,2)","v":97.45},null,"YES",97.45,0,97.45,{"$f":"(AG58-AC58)/AG58","v":0},null,2,{"$f":"SUM(AJ58:AL58)+AE58","v":97.45},null,null,{"$f":"ROUND(AC58/(1-VLOOKUP(AF58,Group,2,FALSE)),2)","v":97.45},{"$f":"IF(VLOOKUP(AF58,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ58,1)-AJ58,2),Round,2,FALSE)+VLOOKUP(AF58,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF58,Group,7,FALSE)=\"\",0,ROUND(AJ58-0.04999,1)-AJ58+AM58)","v":0},{"$f":"IF(VLOOKUP(AF58,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF58,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"KERDI-BOARD - E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"L-Shaped panel used to create corners, pipe or column coverings",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB",null,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,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"3/4\" thickness",null,null,null,null,"KB196252440E",null,null,null,"6 Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA64,AG64)","v":77.95},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":77.95},null,"YES",77.95,{"$f":"+W64","v":0},{"$f":"+X64","v":77.95},{"$f":"(AG64-AC64)/AG64","v":0},null,2,{"$f":"SUM(AJ64:AL64)+AE64","v":77.95},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":77.95},{"$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,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"1\" thickness",null,null,null,null,"KB256252440E",null,null,null,"4 Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":83},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":83},null,"YES",83,{"$f":"+W65","v":0},{"$f":"+X65","v":83},{"$f":"(AG65-AC65)/AG65","v":0},null,2,{"$f":"SUM(AJ65:AL65)+AE65","v":83},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":83},{"$f":"IF(VLOOKUP(AF65,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ65,1)-AJ65,2),Round,2,FALSE)+VLOOKUP(AF65,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",0,ROUND(AJ65-0.04999,1)-AJ65+AM65)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF65,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"KERDI-BOARD - U",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"U-Shaped panel used to create pipe or column coverings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"3/4\" thickness; u = 7-7/8\"",null,null,null,null,"KB196252440U20",null,null,null,"6 Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA71,AG71)","v":97.15},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":97.15},null,"YES",97.15,{"$f":"+W71","v":0},{"$f":"+X71","v":97.15},{"$f":"(AG71-AC71)/AG71","v":0},null,2,{"$f":"SUM(AJ71:AL71)+AE71","v":97.15},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":97.15},{"$f":"IF(VLOOKUP(AF71,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ71,1)-AJ71,2),Round,2,FALSE)+VLOOKUP(AF71,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",0,ROUND(AJ71-0.04999,1)-AJ71+AM71)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF71,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"24-1/2\" x 96\"",null,"3/4\" thickness; u = 11-13/16\"",null,null,null,null,"KB196252440U30",null,null,null,"6 Sheets/Bundle",null,null,{"$f":"IF(Suggested=\"Yes\",AA72,AG72)","v":97.15},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA72*(1-W72)+0.004999,2)","v":97.15},null,"YES",97.15,{"$f":"+W72","v":0},{"$f":"+X72","v":97.15},{"$f":"(AG72-AC72)/AG72","v":0},null,2,{"$f":"SUM(AJ72:AL72)+AE72","v":97.15},null,null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":97.15},{"$f":"IF(VLOOKUP(AF72,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ72,1)-AJ72,2),Round,2,FALSE)+VLOOKUP(AF72,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",0,ROUND(AJ72-0.04999,1)-AJ72+AM72)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF72,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"KERDI-BOARD - KIT",null,null,null,null,null,null," ",null,null,null,null,null,null,null,"Item # Lookup:","SHKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"The Schluter KERDI-BOARD-KIT contains KERDI-BOARD panels and all the other components necessary to create a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"fully waterproof and vapor tight tile application around bathtubs and acrylic shower bases, all in one convenient package.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,null,null,"Kerdi-Board Kit",null,null,null,null,"KBKIT",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA79,AG79)","v":593.25},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA79*(1-W79)+0.004999,2)","v":593.25},null,"YES",593.25,{"$f":"+W79","v":0},{"$f":"+X79","v":593.25},{"$f":"(AG79-AC79)/AG79","v":0},null,2,{"$f":"SUM(AJ79:AL79)+AE79","v":593.25},null,null,{"$f":"ROUND(AC79/(1-VLOOKUP(AF79,Group,2,FALSE)),2)","v":593.25},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Kit includes 8 ea. 38\" x 48\" x 1/2\" KERDI-BOARD Panels. (Total coverage = 101 SF),  1 ea. 5\" x 98' 5\" roll KERDI-BAND waterproofing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"strip, 2 ea. Pipe Seals (1/2\" & 3/4\"), 1 ea. Mixing Valve Seal (4-1/2\"), 140 ea. KERDI-BOARD-ZT/-ZS Screws & Washers & 2 ea. 9.8 oz.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"tubes KERDI-FIX Bright White sealant.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"KERDI-BOARD - ZW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Stainless steel angle profile with two trapezoid perforated anchoring legs.  It is used to fasten and stabilize structures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"made of Kerdi-Board panels.  It is attached to the substrate with either screws or thin-set mortar.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Accessories",null,null,"6\" length",null,"1-3/16\" x 1-3/16\" Angle",null,null,null,null,"KBZW30E/15",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA92,AG92)","v":1.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":1.55},null,"YES",1.55,{"$f":"+W92","v":0},{"$f":"+X92","v":1.55},{"$f":"(AG92-AC92)/AG92","v":0},null,3,{"$f":"SUM(AJ92:AL92)+AE92","v":1.55},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":1.55},{"$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,"Accessories",null,null,"8' 2-1/2\" length",null,"1-3/16\" x 1-3/16\" Angle",null,null,null,null,"KBZW30E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA93,AG93)","v":22.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},22.7,null,"YES",22.7,{"$f":"+W93","v":0},{"$f":"+X93","v":22.7},{"$f":"(AG93-AC93)/AG93","v":0},null,3,{"$f":"SUM(AJ93:AL93)+AE93","v":22.7},null,null,{"$f":"ROUND(AC93/(1-VLOOKUP(AF93,Group,2,FALSE)),2)","v":22.7},{"$f":"IF(VLOOKUP(AF93,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ93,1)-AJ93,2),Round,2,FALSE)+VLOOKUP(AF93,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",0,ROUND(AJ93-0.04999,1)-AJ93+AM93)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF93,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,"KERDI-BOARD - ZC",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB, SHEKB, SHVKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Brushed Stainless Steel, U-Shaped profile with ONE perforated anchoring leg.  It is used to finish edges of countertops,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"vanities, and similar structures.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Accessories",null,null,"8' 2-1/2\" length",null,"1-1/2\" width",null,null,null,null,"KBZC38EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA100,AG100)","v":53.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},53.7,null,"YES",53.7,{"$f":"+W100","v":0},{"$f":"+X100","v":53.7},{"$f":"(AG100-AC100)/AG100","v":0},null,3,{"$f":"SUM(AJ100:AL100)+AE100","v":53.7},null,null,{"$f":"ROUND(AC100/(1-VLOOKUP(AF100,Group,2,FALSE)),2)","v":53.7},{"$f":"IF(VLOOKUP(AF100,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ100,1)-AJ100,2),Round,2,FALSE)+VLOOKUP(AF100,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF100,Group,7,FALSE)=\"\",0,ROUND(AJ100-0.04999,1)-AJ100+AM100)","v":0},{"$f":"IF(VLOOKUP(AF100,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF100,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"8' 2-1/2\" length",null,"2\" width",null,null,null,null,"KBZC50EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA101,AG101)","v":58.65},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},58.65,null,"YES",58.65,{"$f":"+W101","v":0},{"$f":"+X101","v":58.65},{"$f":"(AG101-AC101)/AG101","v":0},null,3,{"$f":"SUM(AJ101:AL101)+AE101","v":58.65},null,null,{"$f":"ROUND(AC101/(1-VLOOKUP(AF101,Group,2,FALSE)),2)","v":58.65},{"$f":"IF(VLOOKUP(AF101,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ101,1)-AJ101,2),Round,2,FALSE)+VLOOKUP(AF101,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",0,ROUND(AJ101-0.04999,1)-AJ101+AM101)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF101,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,"Accessories",null,null,"1-1/2\"",null,"Outside Corner for ZC Profile",null,null,null,null,"E/KBZC38EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA103,AG103)","v":19.350000000000001},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},19.350000000000001,null,"YES",19.350000000000001,{"$f":"+W103","v":0},{"$f":"+X103","v":19.350000000000001},{"$f":"(AG103-AC103)/AG103","v":0},null,3,{"$f":"SUM(AJ103:AL103)+AE103","v":19.350000000000001},null,null,{"$f":"ROUND(AC103/(1-VLOOKUP(AF103,Group,2,FALSE)),2)","v":19.350000000000001},{"$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,"Accessories",null,null,"2\"",null,"Outside Corner for ZC Profile",null,null,null,null,"E/KBZC50EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA104,AG104)","v":19.350000000000001},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},19.350000000000001,null,"YES",19.350000000000001,{"$f":"+W104","v":0},{"$f":"+X104","v":19.350000000000001},{"$f":"(AG104-AC104)/AG104","v":0},null,3,{"$f":"SUM(AJ104:AL104)+AE104","v":19.350000000000001},null,null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":19.350000000000001},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Accessories",null,null,"3/4\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ19EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA106,AG106)","v":6.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},6.1,null,"YES",6.1,{"$f":"+W106","v":0},6.1,{"$f":"(AG106-AC106)/AG106","v":0},null,3,{"$f":"SUM(AJ106:AL106)+AE106","v":6.1},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":6.1},{"$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,"Accessories",null,null,"1\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ25EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA107,AG107)","v":6.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},6.1,null,"YES",6.1,0,6.1,{"$f":"(AG107-AC107)/AG107","v":0},null,3,{"$f":"SUM(AJ107:AL107)+AE107","v":6.1},null,null,{"$f":"ROUND(AC107/(1-VLOOKUP(AF107,Group,2,FALSE)),2)","v":6.1},{"$f":"IF(VLOOKUP(AF107,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ107,1)-AJ107,2),Round,2,FALSE)+VLOOKUP(AF107,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF107,Group,7,FALSE)=\"\",0,ROUND(AJ107-0.04999,1)-AJ107+AM107)","v":0},{"$f":"IF(VLOOKUP(AF107,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF107,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"1-1/2\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ38EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA108,AG108)","v":6.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},6.1,null,"YES",6.1,0,6.1,{"$f":"(AG108-AC108)/AG108","v":0},null,3,{"$f":"SUM(AJ108:AL108)+AE108","v":6.1},null,null,{"$f":"ROUND(AC108/(1-VLOOKUP(AF108,Group,2,FALSE)),2)","v":6.1},{"$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,"Accessories",null,null,"2\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ50EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA109,AG109)","v":6.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},6.1,null,"YES",6.1,0,6.1,{"$f":"(AG109-AC109)/AG109","v":0},null,3,{"$f":"SUM(AJ109:AL109)+AE109","v":6.1},null,null,{"$f":"ROUND(AC109/(1-VLOOKUP(AF109,Group,2,FALSE)),2)","v":6.1},{"$f":"IF(VLOOKUP(AF109,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ109,1)-AJ109,2),Round,2,FALSE)+VLOOKUP(AF109,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF109,Group,7,FALSE)=\"\",0,ROUND(AJ109-0.04999,1)-AJ109+AM109)","v":0},{"$f":"IF(VLOOKUP(AF109,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF109,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,"Accessories",null,null,"3/4\"",null,"Inside Connector for ZC & ZA",null,null,null,null,"V/KBZI19E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA111,AG111)","v":3.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.8,null,"YES",3.8,{"$f":"+W111","v":0},3.8,{"$f":"(AG111-AC111)/AG111","v":0},null,3,{"$f":"SUM(AJ111:AL111)+AE111","v":3.8},null,null,{"$f":"ROUND(AC111/(1-VLOOKUP(AF111,Group,2,FALSE)),2)","v":3.8},{"$f":"IF(VLOOKUP(AF111,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ111,1)-AJ111,2),Round,2,FALSE)+VLOOKUP(AF111,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",0,ROUND(AJ111-0.04999,1)-AJ111+AM111)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF111,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"1\"",null,"Inside Connector for ZC & ZA",null,null,null,null,"V/KBZI25E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA112,AG112)","v":3.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.8,null,"YES",3.8,0,3.8,{"$f":"(AG112-AC112)/AG112","v":0},null,3,{"$f":"SUM(AJ112:AL112)+AE112","v":3.8},null,null,{"$f":"ROUND(AC112/(1-VLOOKUP(AF112,Group,2,FALSE)),2)","v":3.8},{"$f":"IF(VLOOKUP(AF112,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ112,1)-AJ112,2),Round,2,FALSE)+VLOOKUP(AF112,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",0,ROUND(AJ112-0.04999,1)-AJ112+AM112)","v":0},{"$f":"IF(VLOOKUP(AF112,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF112,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"1-1/2\"",null,"Inside Connector for ZC & ZA",null,null,null,null,"V/KBZI38E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA113,AG113)","v":3.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.8,null,"YES",3.8,0,3.8,{"$f":"(AG113-AC113)/AG113","v":0},null,3,{"$f":"SUM(AJ113:AL113)+AE113","v":3.8},null,null,{"$f":"ROUND(AC113/(1-VLOOKUP(AF113,Group,2,FALSE)),2)","v":3.8},{"$f":"IF(VLOOKUP(AF113,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ113,1)-AJ113,2),Round,2,FALSE)+VLOOKUP(AF113,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",0,ROUND(AJ113-0.04999,1)-AJ113+AM113)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF113,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"2\"",null,"Inside Connector for ZC & ZA",null,null,null,null,"V/KBZI50E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA114,AG114)","v":3.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.8,null,"YES",3.8,0,3.8,{"$f":"(AG114-AC114)/AG114","v":0},null,3,{"$f":"SUM(AJ114:AL114)+AE114","v":3.8},null,null,{"$f":"ROUND(AC114/(1-VLOOKUP(AF114,Group,2,FALSE)),2)","v":3.8},{"$f":"IF(VLOOKUP(AF114,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ114,1)-AJ114,2),Round,2,FALSE)+VLOOKUP(AF114,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF114,Group,7,FALSE)=\"\",0,ROUND(AJ114-0.04999,1)-AJ114+AM114)","v":0},{"$f":"IF(VLOOKUP(AF114,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF114,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,"KERDI-BOARD - ZA",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB, SHEKB, SHVKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Brushed Stainless Steel, U-Shaped profile with TWO perforated anchoring legs.  It is used to finish visible edges of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"partition walls and shelves.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Accessories",null,null,"8' 2-1/2\" length",null,"3/4\" width",null,null,null,null,"KBZA19EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA121,AG121)","v":45.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},45.55,null,"YES",45.55,{"$f":"+W121","v":0},45.55,{"$f":"(AG121-AC121)/AG121","v":0},null,3,{"$f":"SUM(AJ121:AL121)+AE121","v":45.55},null,null,{"$f":"ROUND(AC121/(1-VLOOKUP(AF121,Group,2,FALSE)),2)","v":45.55},{"$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,"Accessories",null,null,"8' 2-1/2\" length",null,"1\" width",null,null,null,null,"KBZA25EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA122,AG122)","v":49.2},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},49.2,null,"YES",49.2,0,49.2,{"$f":"(AG122-AC122)/AG122","v":0},null,3,{"$f":"SUM(AJ122:AL122)+AE122","v":49.2},null,null,{"$f":"ROUND(AC122/(1-VLOOKUP(AF122,Group,2,FALSE)),2)","v":49.2},{"$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,"Accessories",null,null,"8' 2-1/2\" length",null,"1-1/2\" width",null,null,null,null,"KBZA38EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA123,AG123)","v":53.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},53.7,null,"YES",53.7,0,53.7,{"$f":"(AG123-AC123)/AG123","v":0},null,3,{"$f":"SUM(AJ123:AL123)+AE123","v":53.7},null,null,{"$f":"ROUND(AC123/(1-VLOOKUP(AF123,Group,2,FALSE)),2)","v":53.7},{"$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,"Accessories",null,null,"8' 2-1/2\" length",null,"2\" width",null,null,null,null,"KBZA50EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA124,AG124)","v":58.65},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},58.65,null,"YES",58.65,0,58.65,{"$f":"(AG124-AC124)/AG124","v":0},null,3,{"$f":"SUM(AJ124:AL124)+AE124","v":58.65},null,null,{"$f":"ROUND(AC124/(1-VLOOKUP(AF124,Group,2,FALSE)),2)","v":58.65},{"$f":"IF(VLOOKUP(AF124,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ124,1)-AJ124,2),Round,2,FALSE)+VLOOKUP(AF124,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",0,ROUND(AJ124-0.04999,1)-AJ124+AM124)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF124,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,"Accessories",null,null,"1-1/2\"",null,"Outside Corner for ZA Profile",null,null,null,null,"E/KBZA38EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA126,AG126)","v":19.350000000000001},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},19.350000000000001,null,"YES",19.350000000000001,{"$f":"+W126","v":0},{"$f":"+X126","v":19.350000000000001},{"$f":"(AG126-AC126)/AG126","v":0},null,3,{"$f":"SUM(AJ126:AL126)+AE126","v":19.350000000000001},null,null,{"$f":"ROUND(AC126/(1-VLOOKUP(AF126,Group,2,FALSE)),2)","v":19.350000000000001},{"$f":"IF(VLOOKUP(AF126,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ126,1)-AJ126,2),Round,2,FALSE)+VLOOKUP(AF126,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",0,ROUND(AJ126-0.04999,1)-AJ126+AM126)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF126,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"2\"",null,"Outside Corner for ZA Profile",null,null,null,null,"E/KBZA50EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA127,AG127)","v":19.350000000000001},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},19.350000000000001,null,"YES",19.350000000000001,{"$f":"+W127","v":0},{"$f":"+X127","v":19.350000000000001},{"$f":"(AG127-AC127)/AG127","v":0},null,3,{"$f":"SUM(AJ127:AL127)+AE127","v":19.350000000000001},null,null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":19.350000000000001},{"$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,"Accessories",null,null,"3/4\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ19EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA129,AG129)","v":6.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},6.1,null,"YES",6.1,{"$f":"+W129","v":0},6.1,{"$f":"(AG129-AC129)/AG129","v":0},null,3,{"$f":"SUM(AJ129:AL129)+AE129","v":6.1},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":6.1},{"$f":"IF(VLOOKUP(AF129,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ129,1)-AJ129,2),Round,2,FALSE)+VLOOKUP(AF129,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",0,ROUND(AJ129-0.04999,1)-AJ129+AM129)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF129,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"1\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ25EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA130,AG130)","v":6.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},6.1,null,"YES",6.1,0,6.1,{"$f":"(AG130-AC130)/AG130","v":0},null,3,{"$f":"SUM(AJ130:AL130)+AE130","v":6.1},null,null,{"$f":"ROUND(AC130/(1-VLOOKUP(AF130,Group,2,FALSE)),2)","v":6.1},{"$f":"IF(VLOOKUP(AF130,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ130,1)-AJ130,2),Round,2,FALSE)+VLOOKUP(AF130,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,7,FALSE)=\"\",0,ROUND(AJ130-0.04999,1)-AJ130+AM130)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF130,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"1-1/2\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ38EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA131,AG131)","v":6.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},6.1,null,"YES",6.1,0,6.1,{"$f":"(AG131-AC131)/AG131","v":0},null,3,{"$f":"SUM(AJ131:AL131)+AE131","v":6.1},null,null,{"$f":"ROUND(AC131/(1-VLOOKUP(AF131,Group,2,FALSE)),2)","v":6.1},{"$f":"IF(VLOOKUP(AF131,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ131,1)-AJ131,2),Round,2,FALSE)+VLOOKUP(AF131,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,7,FALSE)=\"\",0,ROUND(AJ131-0.04999,1)-AJ131+AM131)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF131,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"2\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ50EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA132,AG132)","v":6.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},6.1,null,"YES",6.1,0,6.1,{"$f":"(AG132-AC132)/AG132","v":0},null,3,{"$f":"SUM(AJ132:AL132)+AE132","v":6.1},null,null,{"$f":"ROUND(AC132/(1-VLOOKUP(AF132,Group,2,FALSE)),2)","v":6.1},{"$f":"IF(VLOOKUP(AF132,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ132,1)-AJ132,2),Round,2,FALSE)+VLOOKUP(AF132,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",0,ROUND(AJ132-0.04999,1)-AJ132+AM132)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF132,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Accessories",null,null,"3/4\"",null,"Inside Connector for ZC & ZA",null,null,null,null,"V/KBZI19E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA134,AG134)","v":3.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.8,null,"YES",3.8,{"$f":"+W134","v":0},3.8,{"$f":"(AG134-AC134)/AG134","v":0},null,3,{"$f":"SUM(AJ134:AL134)+AE134","v":3.8},null,null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":3.8},{"$f":"IF(VLOOKUP(AF134,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ134,1)-AJ134,2),Round,2,FALSE)+VLOOKUP(AF134,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",0,ROUND(AJ134-0.04999,1)-AJ134+AM134)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF134,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"1\"",null,"Inside Connector for ZC & ZA",null,null,null,null,"V/KBZI25E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA135,AG135)","v":3.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.8,null,"YES",3.8,0,3.8,{"$f":"(AG135-AC135)/AG135","v":0},null,3,{"$f":"SUM(AJ135:AL135)+AE135","v":3.8},null,null,{"$f":"ROUND(AC135/(1-VLOOKUP(AF135,Group,2,FALSE)),2)","v":3.8},{"$f":"IF(VLOOKUP(AF135,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ135,1)-AJ135,2),Round,2,FALSE)+VLOOKUP(AF135,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",0,ROUND(AJ135-0.04999,1)-AJ135+AM135)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF135,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"1-1/2\"",null,"Inside Connector for ZC & ZA",null,null,null,null,"V/KBZI38E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA136,AG136)","v":3.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.8,null,"YES",3.8,0,3.8,{"$f":"(AG136-AC136)/AG136","v":0},null,3,{"$f":"SUM(AJ136:AL136)+AE136","v":3.8},null,null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":3.8},{"$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,"Accessories",null,null,"2\"",null,"Inside Connector for ZC & ZA",null,null,null,null,"V/KBZI50E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA137,AG137)","v":3.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.8,null,"YES",3.8,0,3.8,{"$f":"(AG137-AC137)/AG137","v":0},null,3,{"$f":"SUM(AJ137:AL137)+AE137","v":3.8},null,null,{"$f":"ROUND(AC137/(1-VLOOKUP(AF137,Group,2,FALSE)),2)","v":3.8},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"KERDI-BOARD - ZB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Stainless Steel, U-Shaped profile with THREE perforated anchoring legs.  It is used to fasten and stabilize partition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"walls and other structures made of Kerdi-Board panels.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Accessories",null,null,"8' 2-1/2\" length",null,"3/4\" width",null,null,null,null,"KBZB19E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA144,AG144)","v":39.299999999999997},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},39.299999999999997,null,"YES",39.299999999999997,{"$f":"+W144","v":0},39.299999999999997,{"$f":"(AG144-AC144)/AG144","v":0},null,3,{"$f":"SUM(AJ144:AL144)+AE144","v":39.299999999999997},null,null,{"$f":"ROUND(AC144/(1-VLOOKUP(AF144,Group,2,FALSE)),2)","v":39.299999999999997},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ144,1)-AJ144,2),Round,2,FALSE)+VLOOKUP(AF144,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",0,ROUND(AJ144-0.04999,1)-AJ144+AM144)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF144,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"8' 2-1/2\" length",null,"1\" width",null,null,null,null,"KBZB25E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA145,AG145)","v":42.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},42.4,null,"YES",42.4,0,42.4,{"$f":"(AG145-AC145)/AG145","v":0},null,3,{"$f":"SUM(AJ145:AL145)+AE145","v":42.4},null,null,{"$f":"ROUND(AC145/(1-VLOOKUP(AF145,Group,2,FALSE)),2)","v":42.4},{"$f":"IF(VLOOKUP(AF145,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ145,1)-AJ145,2),Round,2,FALSE)+VLOOKUP(AF145,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",0,ROUND(AJ145-0.04999,1)-AJ145+AM145)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF145,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"8' 2-1/2\" length",null,"1-1/2\" width",null,null,null,null,"KBZB38E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA146,AG146)","v":45.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},45.9,null,"YES",45.9,0,45.9,{"$f":"(AG146-AC146)/AG146","v":0},null,3,{"$f":"SUM(AJ146:AL146)+AE146","v":45.9},null,null,{"$f":"ROUND(AC146/(1-VLOOKUP(AF146,Group,2,FALSE)),2)","v":45.9},{"$f":"IF(VLOOKUP(AF146,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ146,1)-AJ146,2),Round,2,FALSE)+VLOOKUP(AF146,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",0,ROUND(AJ146-0.04999,1)-AJ146+AM146)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF146,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"8' 2-1/2\" length",null,"2\" width",null,null,null,null,"KBZB50E",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA147,AG147)","v":50.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},50.35,null,"YES",50.35,0,50.35,{"$f":"(AG147-AC147)/AG147","v":0},null,3,{"$f":"SUM(AJ147:AL147)+AE147","v":50.35},null,null,{"$f":"ROUND(AC147/(1-VLOOKUP(AF147,Group,2,FALSE)),2)","v":50.35},{"$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,"KERDI-BOARD - ZFP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Flat Plastic profile, which is adhered behind the Kerdi-Board-ZA U-Shaped profile to improve fastening of hardware",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"with screws."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Accessories",null,null,"8' 2-1/2\" length",null,"1-3/8\" width Flat Plastic",null,null,null,null,"KBZFP35",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA154,AG154)","v":9.9499999999999993},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA154*(1-W154)+0.004999,2)","v":9.9499999999999993},null,"YES",9.9499999999999993,{"$f":"+W154","v":0},{"$f":"+X154","v":9.9499999999999993},{"$f":"(AG154-AC154)/AG154","v":0},null,3,{"$f":"SUM(AJ154:AL154)+AE154","v":9.9499999999999993},null,null,{"$f":"ROUND(AC154/(1-VLOOKUP(AF154,Group,2,FALSE)),2)","v":9.9499999999999993},{"$f":"IF(VLOOKUP(AF154,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ154,1)-AJ154,2),Round,2,FALSE)+VLOOKUP(AF154,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",0,ROUND(AJ154-0.04999,1)-AJ154+AM154)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF154,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,"KERDI-BOARD - ZSD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Anchors used to provide additional mechanical attachment of Kerdi-Board when the bond between the thin-set mortar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"and the substrate is questionable.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Accessories",null,null,"3-1/2\"",null,"Stainless Steel Anchor",null,null,null,null,"KBZSD90E",null,null,null,"25 Anchors/Box",null,null,{"$f":"IF(Suggested=\"Yes\",AA161,AG161)","v":26.2},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA161*(1-W161)+0.004999,2)","v":26.2},null,"YES",26.2,{"$f":"+W161","v":0},{"$f":"+X161","v":26.2},{"$f":"(AG161-AC161)/AG161","v":0},null,3,{"$f":"SUM(AJ161:AL161)+AE161","v":26.2},null,null,{"$f":"ROUND(AC161/(1-VLOOKUP(AF161,Group,2,FALSE)),2)","v":26.2},{"$f":"IF(VLOOKUP(AF161,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ161,1)-AJ161,2),Round,2,FALSE)+VLOOKUP(AF161,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",0,ROUND(AJ161-0.04999,1)-AJ161+AM161)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF161,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"4-5/16\"",null,"Stainless Steel Anchor",null,null,null,null,"KBZSD110E",null,null,null,"25 Anchors/Box",null,null,{"$f":"IF(Suggested=\"Yes\",AA162,AG162)","v":30.25},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA162*(1-W162)+0.004999,2)","v":30.25},null,"YES",30.25,{"$f":"+W162","v":0},{"$f":"+X162","v":30.25},{"$f":"(AG162-AC162)/AG162","v":0},null,3,{"$f":"SUM(AJ162:AL162)+AE162","v":30.25},null,null,{"$f":"ROUND(AC162/(1-VLOOKUP(AF162,Group,2,FALSE)),2)","v":30.25},{"$f":"IF(VLOOKUP(AF162,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ162,1)-AJ162,2),Round,2,FALSE)+VLOOKUP(AF162,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF162,Group,7,FALSE)=\"\",0,ROUND(AJ162-0.04999,1)-AJ162+AM162)","v":0},{"$f":"IF(VLOOKUP(AF162,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF162,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,"Accessories",null,null,"3-1/2\"",null,"Galvanized Steel Anchor",null,null,null,null,"KBZSD90Z",null,null,null,"25 Anchors/Box",null,null,{"$f":"IF(Suggested=\"Yes\",AA164,AG164)","v":14.1},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA164*(1-W164)+0.004999,2)","v":14.1},null,"YES",14.1,{"$f":"+W164","v":0},{"$f":"+X164","v":14.1},{"$f":"(AG164-AC164)/AG164","v":0},null,3,{"$f":"SUM(AJ164:AL164)+AE164","v":14.1},null,null,{"$f":"ROUND(AC164/(1-VLOOKUP(AF164,Group,2,FALSE)),2)","v":14.1},{"$f":"IF(VLOOKUP(AF164,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ164,1)-AJ164,2),Round,2,FALSE)+VLOOKUP(AF164,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,7,FALSE)=\"\",0,ROUND(AJ164-0.04999,1)-AJ164+AM164)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF164,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"4-5/16\"",null,"Galvanized Steel Anchor",null,null,null,null,"KBZSD110Z",null,null,null,"25 Anchors/Box",null,null,{"$f":"IF(Suggested=\"Yes\",AA165,AG165)","v":16.2},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA165*(1-W165)+0.004999,2)","v":16.2},null,"YES",16.2,{"$f":"+W165","v":0},{"$f":"+X165","v":16.2},{"$f":"(AG165-AC165)/AG165","v":0},null,3,{"$f":"SUM(AJ165:AL165)+AE165","v":16.2},null,null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":16.2},{"$f":"IF(VLOOKUP(AF165,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ165,1)-AJ165,2),Round,2,FALSE)+VLOOKUP(AF165,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",0,ROUND(AJ165-0.04999,1)-AJ165+AM165)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF165,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,"KERDI-BOARD - ZT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Galvanized steel washers used to fasten Kerdi-Board to stud framing.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Accessories",null,null,"1-1/4\"",null,"Galvanized Steel Washer",null,null,null,null,"KBZT32Z",null,null,null,"100 Washers/Box","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA171,AG171)","v":10.4},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA171*(1-W171)+0.004999,2)","v":10.4},null,"YES",10.4,{"$f":"+W171","v":0},{"$f":"+X171","v":10.4},{"$f":"(AG171-AC171)/AG171","v":0},null,3,{"$f":"SUM(AJ171:AL171)+AE171","v":10.4},null,null,{"$f":"ROUND(AC171/(1-VLOOKUP(AF171,Group,2,FALSE)),2)","v":10.4},{"$f":"IF(VLOOKUP(AF171,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ171,1)-AJ171,2),Round,2,FALSE)+VLOOKUP(AF171,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF171,Group,7,FALSE)=\"\",0,ROUND(AJ171-0.04999,1)-AJ171+AM171)","v":0},{"$f":"IF(VLOOKUP(AF171,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF171,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"1-1/4\"",null,"Galvanized Steel Washer",null,null,null,null,"KBZT32Z/L",null,null,null,"1000 Washers/Box",null,null,{"$f":"IF(Suggested=\"Yes\",AA172,AG172)","v":86.2},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA172*(1-W172)+0.004999,2)","v":86.2},null,"YES",86.2,{"$f":"+W172","v":0},{"$f":"+X172","v":86.2},{"$f":"(AG172-AC172)/AG172","v":0},null,3,{"$f":"SUM(AJ172:AL172)+AE172","v":86.2},null,null,{"$f":"ROUND(AC172/(1-VLOOKUP(AF172,Group,2,FALSE)),2)","v":86.2},{"$f":"IF(VLOOKUP(AF172,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ172,1)-AJ172,2),Round,2,FALSE)+VLOOKUP(AF172,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",0,ROUND(AJ172-0.04999,1)-AJ172+AM172)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF172,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,"KERDI-BOARD - ZS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Screws used to fasten Kerdi-Board to stud framing with the corresponding washers.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Accessories",null,null,"1-5/8\"",null,"Wood Screws",null,null,null," ","KBZS35G",null,null,null,"200 Screws/Box","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA178,AG178)","v":14.2},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA178*(1-W178)+0.004999,2)","v":14.2},null,"YES",14.2,{"$f":"+W178","v":0},14.2,{"$f":"(AG178-AC178)/AG178","v":0},null,3,{"$f":"SUM(AJ178:AL178)+AE178","v":14.2},null,null,{"$f":"ROUND(AC178/(1-VLOOKUP(AF178,Group,2,FALSE)),2)","v":14.2},{"$f":"IF(VLOOKUP(AF178,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ178,1)-AJ178,2),Round,2,FALSE)+VLOOKUP(AF178,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF178,Group,7,FALSE)=\"\",0,ROUND(AJ178-0.04999,1)-AJ178+AM178)","v":0},{"$f":"IF(VLOOKUP(AF178,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF178,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"2\"",null,"Wood Screws",null,null,null,null,"KBZS55G",null,null,null,"100 Screws/Box",null,null,{"$f":"IF(Suggested=\"Yes\",AA179,AG179)","v":10.4},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA179*(1-W179)+0.004999,2)","v":10.4},null,"YES",10.4,0,10.4,{"$f":"(AG179-AC179)/AG179","v":0},null,3,{"$f":"SUM(AJ179:AL179)+AE179","v":10.4},null,null,{"$f":"ROUND(AC179/(1-VLOOKUP(AF179,Group,2,FALSE)),2)","v":10.4},{"$f":"IF(VLOOKUP(AF179,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ179,1)-AJ179,2),Round,2,FALSE)+VLOOKUP(AF179,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",0,ROUND(AJ179-0.04999,1)-AJ179+AM179)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF179,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"3\"",null,"Wood Screws",null,null,null,null,"KBZS75G",null,null,null,"100 Screws/Box",null,null,{"$f":"IF(Suggested=\"Yes\",AA180,AG180)","v":15.85},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA180*(1-W180)+0.004999,2)","v":15.85},null,"YES",15.85,0,15.85,{"$f":"(AG180-AC180)/AG180","v":0},null,3,{"$f":"SUM(AJ180:AL180)+AE180","v":15.85},null,null,{"$f":"ROUND(AC180/(1-VLOOKUP(AF180,Group,2,FALSE)),2)","v":15.85},{"$f":"IF(VLOOKUP(AF180,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ180,1)-AJ180,2),Round,2,FALSE)+VLOOKUP(AF180,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF180,Group,7,FALSE)=\"\",0,ROUND(AJ180-0.04999,1)-AJ180+AM180)","v":0},{"$f":"IF(VLOOKUP(AF180,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF180,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,"KERDI-BOARD - ZT/ -ZS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Screws and Galvanized steel washers used to fasten Kerdi-Board to stud framing.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Accessories",null,null,"1-1/4\" / 1-5/8\"",null,"Washer / Screw Set",null,null,null,null,"KBZS35GT32Z",null,null,null,"40 Sets/Box",null,null,{"$f":"IF(Suggested=\"Yes\",AA186,AG186)","v":11.85},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA186*(1-W186)+0.004999,2)","v":11.85},null,"YES",11.85,{"$f":"+W186","v":0},{"$f":"+X186","v":11.85},{"$f":"(AG186-AC186)/AG186","v":0},null,3,{"$f":"SUM(AJ186:AL186)+AE186","v":11.85},null,null,{"$f":"ROUND(AC186/(1-VLOOKUP(AF186,Group,2,FALSE)),2)","v":11.85},{"$f":"IF(VLOOKUP(AF186,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ186,1)-AJ186,2),Round,2,FALSE)+VLOOKUP(AF186,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF186,Group,7,FALSE)=\"\",0,ROUND(AJ186-0.04999,1)-AJ186+AM186)","v":0},{"$f":"IF(VLOOKUP(AF186,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF186,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"1-1/4\" / 1-5/8\"",null,"Washer / Screw Set",null,null,null,null,"KBZS35GT32Z100",null,null,null,"100 Sets/Box",null,null,{"$f":"IF(Suggested=\"Yes\",AA187,AG187)","v":22.3},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA187*(1-W187)+0.004999,2)","v":22.3},null,"YES",22.3,{"$f":"+W187","v":0},{"$f":"+X187","v":22.3},{"$f":"(AG187-AC187)/AG187","v":0},null,3,{"$f":"SUM(AJ187:AL187)+AE187","v":22.3},null,null,{"$f":"ROUND(AC187/(1-VLOOKUP(AF187,Group,2,FALSE)),2)","v":22.3},{"$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,"KERDI-BOARD - ZDK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Double-sided adhesive tape used to attach Kerdi-Board panels in joint areas.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Accessories",null,null,"33' length",null,"1/2\" width Double-Sided Tape",null,null,null,null,"KBZDK12/10M",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA193,AG193)","v":8.6999999999999993},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA193*(1-W193)+0.004999,2)","v":8.6999999999999993},null,"YES",8.6999999999999993,{"$f":"+W193","v":0},8.6999999999999993,{"$f":"(AG193-AC193)/AG193","v":0},null,3,{"$f":"SUM(AJ193:AL193)+AE193","v":8.6999999999999993},null,null,{"$f":"ROUND(AC193/(1-VLOOKUP(AF193,Group,2,FALSE)),2)","v":8.6999999999999993},{"$f":"IF(VLOOKUP(AF193,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ193,1)-AJ193,2),Round,2,FALSE)+VLOOKUP(AF193,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF193,Group,7,FALSE)=\"\",0,ROUND(AJ193-0.04999,1)-AJ193+AM193)","v":0},{"$f":"IF(VLOOKUP(AF193,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF193,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"33' length",null,"3/4\" width Double-Sided Tape",null,null,null,null,"KBZDK19/10M",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA194,AG194)","v":13.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA194*(1-W194)+0.004999,2)","v":13.45},null,"YES",13.45,0,13.45,{"$f":"(AG194-AC194)/AG194","v":0},null,3,{"$f":"SUM(AJ194:AL194)+AE194","v":13.45},null,null,{"$f":"ROUND(AC194/(1-VLOOKUP(AF194,Group,2,FALSE)),2)","v":13.45},{"$f":"IF(VLOOKUP(AF194,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ194,1)-AJ194,2),Round,2,FALSE)+VLOOKUP(AF194,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF194,Group,7,FALSE)=\"\",0,ROUND(AJ194-0.04999,1)-AJ194+AM194)","v":0},{"$f":"IF(VLOOKUP(AF194,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF194,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"33' length",null,"1-3/16\" width Double-Sided Tape",null,null,null,null,"KBZDK30/10M",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA195,AG195)","v":21.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA195*(1-W195)+0.004999,2)","v":21.1},null,"YES",21.1,0,21.1,{"$f":"(AG195-AC195)/AG195","v":0},null,3,{"$f":"SUM(AJ195:AL195)+AE195","v":21.1},null,null,{"$f":"ROUND(AC195/(1-VLOOKUP(AF195,Group,2,FALSE)),2)","v":21.1},{"$f":"IF(VLOOKUP(AF195,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ195,1)-AJ195,2),Round,2,FALSE)+VLOOKUP(AF195,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF195,Group,7,FALSE)=\"\",0,ROUND(AJ195-0.04999,1)-AJ195+AM195)","v":0},{"$f":"IF(VLOOKUP(AF195,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF195,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,"KERDI-BOARD - ZSA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Adhesive tape for reinforcing the joint areas of Kerdi-Board panels.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Accessories",null,null,"148' length",null,"4\" width Reinforcement Tape",null,null,null,null,"KBZSA100/45M",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA201,AG201)","v":15.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA201*(1-W201)+0.004999,2)","v":15.45},null,"YES",15.45,{"$f":"+W201","v":0},{"$f":"+X201","v":15.45},{"$f":"(AG201-AC201)/AG201","v":0},null,3,{"$f":"SUM(AJ201:AL201)+AE201","v":15.45},null,null,{"$f":"ROUND(AC201/(1-VLOOKUP(AF201,Group,2,FALSE)),2)","v":15.45},{"$f":"IF(VLOOKUP(AF201,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ201,1)-AJ201,2),Round,2,FALSE)+VLOOKUP(AF201,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF201,Group,7,FALSE)=\"\",0,ROUND(AJ201-0.04999,1)-AJ201+AM201)","v":0},{"$f":"IF(VLOOKUP(AF201,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF201,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"Benches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"KERDI-BOARD-SB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"A prefabricated shower bench made of KERDI-BOARD that is designed to integrate with the Schluter Shower System.  The bench is ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"lightweight, stable, and load bearing.  It features a sloped surface to prevent the accumulation of water.  KERDI-BOARD-SB is quick and",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"easy to install, waterproof and ready to tile.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,"16\" x 16\" x 20\" ",null,"Shower Bench - Triangular",null,null,null,null,"KBSB410TA",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA211,AG211)","v":139.19999999999999},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA211*(1-W211)+0.004999,2)","v":139.19999999999999},null,"YES",139.19999999999999,{"$f":"+W211","v":0},139.19999999999999,{"$f":"(AG211-AC211)/AG211","v":0},null,2,{"$f":"SUM(AJ211:AL211)+AE211","v":139.19999999999999},null,null,{"$f":"ROUND(AC211/(1-VLOOKUP(AF211,Group,2,FALSE)),2)","v":139.19999999999999},{"$f":"IF(VLOOKUP(AF211,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ211,1)-AJ211,2),Round,2,FALSE)+VLOOKUP(AF211,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF211,Group,7,FALSE)=\"\",0,ROUND(AJ211-0.04999,1)-AJ211+AM211)","v":0},{"$f":"IF(VLOOKUP(AF211,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF211,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"24\" x 24\" x 20\" ",null,"Shower Bench - Triangular",null,null,null,null,"KBSB610TA",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA212,AG212)","v":180.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA212*(1-W212)+0.004999,2)","v":180.3},null,"YES",180.3,{"$f":"+W212","v":0},{"$f":"+X212","v":180.3},{"$f":"(AG212-AC212)/AG212","v":0},null,2,{"$f":"SUM(AJ212:AL212)+AE212","v":180.3},null,null,{"$f":"ROUND(AC212/(1-VLOOKUP(AF212,Group,2,FALSE)),2)","v":180.3},{"$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,"Board - Non-Stock",null,null,"38\" x 11-1/2\" x 20\" ",null,"Shower Bench - Rectangular",null,null,null,null,"KBSB290970RA",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA213,AG213)","v":225.65},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA213*(1-W213)+0.004999,2)","v":225.65},null,"YES",225.65,0,225.65,{"$f":"(AG213-AC213)/AG213","v":0},null,2,{"$f":"SUM(AJ213:AL213)+AE213","v":225.65},null,null,{"$f":"ROUND(AC213/(1-VLOOKUP(AF213,Group,2,FALSE)),2)","v":225.65},{"$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,"Board - Non-Stock",null,null,"48\" x 16\" x 20\" ",null,"Shower Bench - Rectangular",null,null,null,null,"KBSB4101220RA",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA214,AG214)","v":294.10000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA214*(1-W214)+0.004999,2)","v":294.10000000000002},null,"YES",294.10000000000002,0,294.10000000000002,{"$f":"(AG214-AC214)/AG214","v":0},null,2,{"$f":"SUM(AJ214:AL214)+AE214","v":294.10000000000002},null,null,{"$f":"ROUND(AC214/(1-VLOOKUP(AF214,Group,2,FALSE)),2)","v":294.10000000000002},{"$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,"Shower Curb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"KERDI-BOARD-SC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"A prefabricated shower curb made of KERDI-BOARD that is designed to integrate with the Schluter Shower System.  The curb is ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"lightweight, stable, and load bearing.  It can be used in conjunction with the KERDI-SHOWER-ST prefabricated shower tray as well as ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"in mortar bed applications.  KERDI-BOARD-SC is quick and easy to install, waterproof and ready to tile.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,"38\" x 6\" x 4-1/2\"",null,"Shower Curb",null,null,null,null,"KBSC115150970",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA224,AG224)","v":53.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA224*(1-W224)+0.004999,2)","v":53.15},null,"YES",53.15,{"$f":"+W224","v":0},53.15,{"$f":"(AG224-AC224)/AG224","v":0},null,2,{"$f":"SUM(AJ224:AL224)+AE224","v":53.15},null,null,{"$f":"ROUND(AC224/(1-VLOOKUP(AF224,Group,2,FALSE)),2)","v":53.15},{"$f":"IF(VLOOKUP(AF224,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ224,1)-AJ224,2),Round,2,FALSE)+VLOOKUP(AF224,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF224,Group,7,FALSE)=\"\",0,ROUND(AJ224-0.04999,1)-AJ224+AM224)","v":0},{"$f":"IF(VLOOKUP(AF224,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF224,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"48\" x 6\" x 4-1/2\"",null,"Shower Curb",null,null,null,null,"KBSC1151501220",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA225,AG225)","v":57.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA225*(1-W225)+0.004999,2)","v":57.95},null,"YES",57.95,0,57.95,{"$f":"(AG225-AC225)/AG225","v":0},null,2,{"$f":"SUM(AJ225:AL225)+AE225","v":57.95},null,null,{"$f":"ROUND(AC225/(1-VLOOKUP(AF225,Group,2,FALSE)),2)","v":57.95},{"$f":"IF(VLOOKUP(AF225,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ225,1)-AJ225,2),Round,2,FALSE)+VLOOKUP(AF225,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF225,Group,7,FALSE)=\"\",0,ROUND(AJ225-0.04999,1)-AJ225+AM225)","v":0},{"$f":"IF(VLOOKUP(AF225,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF225,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"60\" x 6\" x 4-1/2\"",null,"Shower Curb",null,null,null,null,"KBSC1151501524",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA226,AG226)","v":84.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA226*(1-W226)+0.004999,2)","v":84.9},null,"YES",84.9,0,84.9,{"$f":"(AG226-AC226)/AG226","v":0},null,2,{"$f":"SUM(AJ226:AL226)+AE226","v":84.9},null,null,{"$f":"ROUND(AC226/(1-VLOOKUP(AF226,Group,2,FALSE)),2)","v":84.9},{"$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,null,"Niches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"KERDI-BOARD-SN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB12SN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Prefabricated shower niches made of KERDI-BOARD that can be installed in both KERDI and KERDI-BOARD wall assemblies.  The",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"shower niche features a 1/2\" thick by 2\" wide integrated bonding flange.  Each niche includes 1- Kerdi-Band waterproofing frame used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"to seal seams with minimal build-up & 8-sets Kerdi-Board-ZT/ZTS screws & washers for fastening Kerdi-Board panel to stud framing.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,"12\" x 6\"",null,"Shower Niche",null,null,null,null,"KB12SN305152AF",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA236,AG236)","v":52.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA236*(1-W236)+0.004999,2)","v":52.7},null,"YES",52.7,{"$f":"+W236","v":0},52.7,{"$f":"(AG236-AC236)/AG236","v":0},null,2,{"$f":"SUM(AJ236:AL236)+AE236","v":52.7},null,null,{"$f":"ROUND(AC236/(1-VLOOKUP(AF236,Group,2,FALSE)),2)","v":52.7},{"$f":"IF(VLOOKUP(AF236,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ236,1)-AJ236,2),Round,2,FALSE)+VLOOKUP(AF236,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",0,ROUND(AJ236-0.04999,1)-AJ236+AM236)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF236,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"12\" x 12\"",null,"Shower Niche",null,null,null,null,"KB12SN305305AF",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA237,AG237)","v":63.2},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA237*(1-W237)+0.004999,2)","v":63.2},null,"YES",63.2,0,63.2,{"$f":"(AG237-AC237)/AG237","v":0},null,2,{"$f":"SUM(AJ237:AL237)+AE237","v":63.2},null,null,{"$f":"ROUND(AC237/(1-VLOOKUP(AF237,Group,2,FALSE)),2)","v":63.2},{"$f":"IF(VLOOKUP(AF237,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ237,1)-AJ237,2),Round,2,FALSE)+VLOOKUP(AF237,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF237,Group,7,FALSE)=\"\",0,ROUND(AJ237-0.04999,1)-AJ237+AM237)","v":0},{"$f":"IF(VLOOKUP(AF237,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF237,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"12\" x 20\"",null,"Shower Niche",null,null,null,null,"KB12SN305508AF",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA238,AG238)","v":85.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA238*(1-W238)+0.004999,2)","v":85.55},null,"YES",85.55,0,85.55,{"$f":"(AG238-AC238)/AG238","v":0},null,2,{"$f":"SUM(AJ238:AL238)+AE238","v":85.55},null,null,{"$f":"ROUND(AC238/(1-VLOOKUP(AF238,Group,2,FALSE)),2)","v":85.55},{"$f":"IF(VLOOKUP(AF238,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ238,1)-AJ238,2),Round,2,FALSE)+VLOOKUP(AF238,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF238,Group,7,FALSE)=\"\",0,ROUND(AJ238-0.04999,1)-AJ238+AM238)","v":0},{"$f":"IF(VLOOKUP(AF238,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF238,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock"," ",null,"12\" x 28\"",null,"Shower Niche",null,null,null,null,"KB12SN305711AF",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA239,AG239)","v":102.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA239*(1-W239)+0.004999,2)","v":102.15},null,"YES",102.15,0,102.15,{"$f":"(AG239-AC239)/AG239","v":0},null,2,{"$f":"SUM(AJ239:AL239)+AE239","v":102.15},null,null,{"$f":"ROUND(AC239/(1-VLOOKUP(AF239,Group,2,FALSE)),2)","v":102.15},{"$f":"IF(VLOOKUP(AF239,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ239,1)-AJ239,2),Round,2,FALSE)+VLOOKUP(AF239,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF239,Group,7,FALSE)=\"\",0,ROUND(AJ239-0.04999,1)-AJ239+AM239)","v":0},{"$f":"IF(VLOOKUP(AF239,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF239,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"KERDI-BOARD-SNLT w/ LIPROTEC LED LIGHTING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKB12SNLT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"KERDI-BOARD-SNLT is a prefabricated shower niche made of KERDI-BOARD that incorporates a mounting profile with a diffused",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"LED light strip.  It features a pre-installed waterproof connection box to ensure the electrical connection is code-compliant.  The KERDI-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"BOARD-SNLT can be installed in both KERDI and KERDI-BOARD wall assemblies.  The shower niche features a 1/2\" -thick by 2\" -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"wide integrated bonding flange and is available in 3 sizes designed for a vertical installation and 2 sizes designed for a horizontal install-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"ation.  The mounting profile is made of anodized aluminum with a satin finish (AE).  It is 11.8\" long to fit along the top of the niche and",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"features a cut out designed to pass the cable.  The LED light strip is encased in a silicone tube that provides an evenly diffused line of light",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"and nests into the mounting profile.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,"12\" x 12\"",null,"Shower Niche w/LIPROTEC LED Lighting",null,null,null,null,null,"KB12SNLT1WWF",null,null,null,null,"a",{"$f":"IF(Suggested=\"Yes\",AA251,AG251)","v":241.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA251*(1-W251)+0.004999,2)","v":241.1},null,"YES",241.1,{"$f":"+W251","v":0},{"$f":"+X251","v":241.1},{"$f":"(AG251-AC251)/AG251","v":0},null,2,{"$f":"SUM(AJ251:AL251)+AE251","v":241.1},null,null,{"$f":"ROUND(AC251/(1-VLOOKUP(AF251,Group,2,FALSE)),2)","v":241.1},{"$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,"Board - Non-Stock",null,null,"12\" x 20\"",null,"Shower Niche w/LIPROTEC LED Lighting",null,null,null,null,null,"KB12SNLT2WWF",null,null,null,null,"a",{"$f":"IF(Suggested=\"Yes\",AA252,AG252)","v":255.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA252*(1-W252)+0.004999,2)","v":255.5},null,"YES",255.5,{"$f":"+W252","v":0},{"$f":"+X252","v":255.5},{"$f":"(AG252-AC252)/AG252","v":0},null,2,{"$f":"SUM(AJ252:AL252)+AE252","v":255.5},null,null,{"$f":"ROUND(AC252/(1-VLOOKUP(AF252,Group,2,FALSE)),2)","v":255.5},{"$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,"Board - Non-Stock",null,null,"12\" x 28\"",null,"Shower Niche w/LIPROTEC LED Lighting",null,null,null,null,null,"KB12SNLT3WWF",null,null,null,null,"a",279.14999999999998,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},279.14999999999998,null,"YES",279.14999999999998,0,279.14999999999998,0,null,2,279.14999999999998,null,null,279.14999999999998,0,0,"",null,"X"]
[null,"Board - Non-Stock",null,null,"20\" x 12\"",null,"Shower Niche w/LIPROTEC LED Lighting",null,null,null,null,null,"KB12SNLT4WWF",null,null,null,null,"b",274,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},274,null,"YES",274,0,274,0,null,2,274,null,null,274,0,0,"",null,"X"]
[null,"Board - Non-Stock",null,null,"28\" x 12\"",null,"Shower Niche w/LIPROTEC LED Lighting",null,null,null,null,null,"KB12SNLT5WWF",null,null,null,null,"b",{"$f":"IF(Suggested=\"Yes\",AA255,AG255)","v":342.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA255*(1-W255)+0.004999,2)","v":342.55},null,"YES",342.55,{"$f":"+W255","v":0},{"$f":"+X255","v":342.55},{"$f":"(AG255-AC255)/AG255","v":0},null,2,{"$f":"SUM(AJ255:AL255)+AE255","v":342.55},null,null,{"$f":"ROUND(AC255/(1-VLOOKUP(AF255,Group,2,FALSE)),2)","v":342.55},{"$f":"IF(VLOOKUP(AF255,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ255,1)-AJ255,2),Round,2,FALSE)+VLOOKUP(AF255,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",0,ROUND(AJ255-0.04999,1)-AJ255+AM255)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF255,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) For Vertical Installation only. ",null,null,null,null,"b) For Horizontal Installation 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,"X"]
[null,null,"KERDI-BOARD-SNLT Cables:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"LIPROTEC-CW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKBLTCW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"LIPROTEC-CW cables feature a pre-installed waterproof snap-in gland for a secure connection to the top of the niche, and",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"connectors to attach the LED strip.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,"13' 1-1/2\"",null,"Cable Kit",null,null,"20AWG",null,null,"LTCW/4M",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA265,AG265)","v":37.950000000000003},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA265*(1-W265)+0.004999,2)","v":37.950000000000003},null,"YES",37.950000000000003,{"$f":"+W265","v":0},{"$f":"+X265","v":37.950000000000003},{"$f":"(AG265-AC265)/AG265","v":0},null,2,{"$f":"SUM(AJ265:AL265)+AE265","v":37.950000000000003},null,null,{"$f":"ROUND(AC265/(1-VLOOKUP(AF265,Group,2,FALSE)),2)","v":37.950000000000003},{"$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,"Board - Non-Stock",null,null,"26' 3\"",null,"Cable Kit",null,null,"20AWG",null,null,"LTCW/8M",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA266,AG266)","v":61.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA266*(1-W266)+0.004999,2)","v":61.55},null,"YES",61.55,{"$f":"+W266","v":0},{"$f":"+X266","v":61.55},{"$f":"(AG266-AC266)/AG266","v":0},null,2,{"$f":"SUM(AJ266:AL266)+AE266","v":61.55},null,null,{"$f":"ROUND(AC266/(1-VLOOKUP(AF266,Group,2,FALSE)),2)","v":61.55},{"$f":"IF(VLOOKUP(AF266,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ266,1)-AJ266,2),Round,2,FALSE)+VLOOKUP(AF266,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF266,Group,7,FALSE)=\"\",0,ROUND(AJ266-0.04999,1)-AJ266+AM266)","v":0},{"$f":"IF(VLOOKUP(AF266,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF266,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"49' 2-1/2\"",null,"Cable Kit",null,null,"20AWG",null,null,"LTCW/15M",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA267,AG267)","v":107.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA267*(1-W267)+0.004999,2)","v":107.15},null,"YES",107.15,{"$f":"+W267","v":0},{"$f":"+X267","v":107.15},{"$f":"(AG267-AC267)/AG267","v":0},null,2,{"$f":"SUM(AJ267:AL267)+AE267","v":107.15},null,null,{"$f":"ROUND(AC267/(1-VLOOKUP(AF267,Group,2,FALSE)),2)","v":107.15},{"$f":"IF(VLOOKUP(AF267,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ267,1)-AJ267,2),Round,2,FALSE)+VLOOKUP(AF267,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF267,Group,7,FALSE)=\"\",0,ROUND(AJ267-0.04999,1)-AJ267+AM267)","v":0},{"$f":"IF(VLOOKUP(AF267,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF267,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"KERDI-BOARD-SNLT Drivers:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"LIPROTEC-ECX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKBLTEC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"LIPROTEC-ECX is an all-in-one LED power supply and in-wall dimmer switch that eliminates compatibility issues between",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"drivers and dimmer switches.  Input:  120V AC, Output:  24V DC, Power:  60W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,null,null,"LED Driver and Dimmer Switch",null,null,null,null,null,"LTECX1W",null,null,null,null,null,206.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},206.3,null,"YES",206.3,0,206.3,0,null,2,206.3,null,null,206.3,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,"LIPROTEC-ECD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKBLTEC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"LIPROTEC-ECD is an in-line dimmable driver that is hard wired into your electrical.  It is compatible with a range of popular",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"dimmer switches, allowing you to have matching light switches throughout your bathroom.  Input:  120V AC,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Output:  24V DC, Power:  24W ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,null,null,"Dimmable LED Driver Direct Wire",null,null,null,null,null,"LTECD1W",null,null,null,null,null,126.85,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},126.85,null,"YES",126.85,0,126.85,0,null,2,126.85,null,null,126.85,0,0,"",null,"X"]
[]
[null,null,"DESIGN-NICHE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SHKBDNA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"DESIGN-NICHE is a prefabricated niche made of powder-coated aluminum to create storage space for any wall area.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"It requires no tile, saving time while providing a clean, modern look.  The adjustable frame fits any tile thickness for a flush",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"installation or can be installed with a reveal edge for a stylish design. It is available in three different sizes, five TRENDLINE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"colors, and has the versatility to be installed horizontally or vertically.  DESIGN-NICHE includes an adjustable anodized",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"aluminum frame, precut KERDI-BAND frame, adjustable nuts, foam spacers and KERDI-FIX single-component sealing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"and bonding compound for waterproof applications.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Matte Black (MGS)          Matte White (MBW)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,"12\" x 12\"",null,"Shower Niche Kit",null,null,null,null,"DNA1---",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA297,AG297)","v":267.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA297*(1-W297)+0.004999,2)","v":267.95},null,"YES",267.95,{"$f":"+W297","v":0},{"$f":"+X297","v":267.95},{"$f":"(AG297-AC297)/AG297","v":0},null,2,{"$f":"SUM(AJ297:AL297)+AE297","v":267.95},null,null,{"$f":"ROUND(AC297/(1-VLOOKUP(AF297,Group,2,FALSE)),2)","v":267.95},{"$f":"IF(VLOOKUP(AF297,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ297,1)-AJ297,2),Round,2,FALSE)+VLOOKUP(AF297,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF297,Group,7,FALSE)=\"\",0,ROUND(AJ297-0.04999,1)-AJ297+AM297)","v":0},{"$f":"IF(VLOOKUP(AF297,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF297,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"12\" x 24\"",null,"Shower Niche Kit",null,null,null,null,"DNA2---",null,null,null,null,null,null,362.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},362.75,null,"YES",362.75,0,362.75,0,null,2,362.75,null,null,362.75,0,0,"",null,"X"]
[null,"Board - Non-Stock",null,null,"12\" x 48\"",null,"Shower Niche Kit",null,null,null,null,"DNA3---",null,null,null,null,null,null,474.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},474.75,null,"YES",474.75,0,474.75,0,null,2,474.75,null,null,474.75,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,"Colors:","Dark Anthracite (TSDA)          Griege (TSBG)          Ivory (TSI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Board - Non-Stock",null,null,"12\" x 12\"",null,"Shower Niche Kit",null,null,null,null,"DNA1---",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA303,AG303)","v":275.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA303*(1-W303)+0.004999,2)","v":275.7},null,"YES",275.7,{"$f":"+W303","v":0},{"$f":"+X303","v":275.7},{"$f":"(AG303-AC303)/AG303","v":0},null,2,{"$f":"SUM(AJ303:AL303)+AE303","v":275.7},null,null,{"$f":"ROUND(AC303/(1-VLOOKUP(AF303,Group,2,FALSE)),2)","v":275.7},{"$f":"IF(VLOOKUP(AF303,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ303,1)-AJ303,2),Round,2,FALSE)+VLOOKUP(AF303,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF303,Group,7,FALSE)=\"\",0,ROUND(AJ303-0.04999,1)-AJ303+AM303)","v":0},{"$f":"IF(VLOOKUP(AF303,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF303,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"12\" x 24\"",null,"Shower Niche Kit",null,null,null,null,"DNA2---",null,null,null,null,null,null,370.5,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},370.5,null,"YES",370.5,0,370.5,0,null,2,370.5,null,null,370.5,0,0,"",null,"X"]
[null,"Board - Non-Stock",null,null,"12\" x 48\"",null,"Shower Niche Kit",null,null,null,null,"DNA3---",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA305,AG305)","v":482.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA305*(1-W305)+0.004999,2)","v":482.5},null,"YES",482.5,{"$f":"+W305","v":0},{"$f":"+X305","v":482.5},{"$f":"(AG305-AC305)/AG305","v":0},null,2,{"$f":"SUM(AJ305:AL305)+AE305","v":482.5},null,null,{"$f":"ROUND(AC305/(1-VLOOKUP(AF305,Group,2,FALSE)),2)","v":482.5},{"$f":"IF(VLOOKUP(AF305,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ305,1)-AJ305,2),Round,2,FALSE)+VLOOKUP(AF305,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF305,Group,7,FALSE)=\"\",0,ROUND(AJ305-0.04999,1)-AJ305+AM305)","v":0},{"$f":"IF(VLOOKUP(AF305,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF305,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) To complete part number replace hyphens with color code.  Example DNA1---, Matte Black # is:  DNA1MGS.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom.  Print out individual price list for each series that can be attached to the back of your sample boards for easy reference.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom.  Print out individual price list for each series that can be attached to the back of your sample boards for easy reference.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[]
[null,null,null,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","http://www.cctd.com/index.php"]
[]
["Manufacturer's Home Page","http://www.schluter.com/"]
[]
[]
["Product","Direct Website Link"]
["KERDI-BOARD","http://www.schluterkerdiboard.com/"]
["KERDI-BOARD-SB","http://www.schluter.com/schluter-us/en_US/Building-Panels/KERDI-BOARD-Panels/Schluter%C2%AE-KERDI-BOARD-SB/p/KERDI_BOARD-SB"]
["KERDI-BOARD-SC","http://www.schluter.com/schluter-us/en_US/Building-Panels/KERDI-BOARD-Panels/Schluter%C2%AE-KERDI-BOARD-SC/p/KERDI_BOARD-SC"]
["KERDI-BOARD-SN","http://www.schluter.com/schluter-us/en_US/Building-Panels/KERDI-BOARD-Panels/Schluter®-KERDI-BOARD-SN/p/KERDI_BOARD-SN"]
["KERDI-BOARD-SNLT","https://www.schluter.com/schluter-us/en_US/kerdi-board-snlt-led-shower-niche"]
["DESIGN-NICHE"]
[null,null,null,null,null," "]

{"sheet":"Changes","index":4,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
["2012-09-25","KERDI-BOARD","KB121220812 32\" x 48\" x 1/2\""]
["2012-09-25","KERDI-BOARD- ZT","KBZT32Z/L 1-1/4\" Galvanized Steel Washer 1000 Washers/Box "]
["2012-10-22","KERDI-BOARD","KB1512202440 48\" x 96\" x 5/8\""]
["2012-10-22","KERDI-BOARD","KB1512203050 48\" x 120\" x 5/8\""]
["2016-06-07","KERDI-BOARD-SB","Shower Benches made of KERDI-BOARD:  KBSB410TA 22-5/8\" x 16\" Triangular, KBSB610TA 34\" x 24\" Triangular, KBSB290970RA 38\" x 11-1/2\" Rectangular & KBSB4101220RA 48\" x 16\" Rectangular."]
["2016-06-07","KERDI-BOARD-SC","Shower Curbs made of KERDI-BOARD available in 2 sizes, 38\" x 6\" x 4-1/2\" and 48\" x 6\" x 4-1/2\"."]
["2018-05-14","KERDI-BOARD-KIT","KBKIT Kerdi-Board waterproofing kit for tub and shower walls."]
["2018-05-14","KERDI-BOARD-ZT/-ZS","KBZS35GT32Z100 Washer and Screw Set, 100 Sets/Box."]
["2019-03-01","KERDI-BOARD-SC","Shower Curb size added:  60\" x 6\" x 4-1/2\" KBSC1151501524."]
["2023-09-22","KERDI-BOARD-SNLT","KERDI-BOARD-SNLT is a prefabricated shower niche made of KERDI-BOARD that incorporates a mounting profile with a diffused LED light strip."]
["2023-09-22","LIPROTEC-ECX","LIPROTEC-ECX is an all-in-one LED power supply and in-wall dimmer switch that eliminates compatibility issues between drivers and dimmer switches."]
["2023-09-22","LIPROTEC-ECD","LIPROTEC-ECD is an in-line dimmable driver that is hard wired into your electrical.  It is compatible with a range of popular dimmer switches, allowing you to have matching light switches throughout your bathroom."]
["2023-09-22","LIPROTEC-CW","LIPROTEC-CW cables feature a pre-installed waterproof snap-in gland for a secure connection to the top of the niche, and connectors to attach the LED strip."]
["2025-03-01","KERDI-BOARD-SNLT","Horizontal Installation Niches w/Liprotec LED lighting added, sizes are 20\" x 12\" and 28\" x 12\"."]
["2025-04-07","DESIGN-NICHE","DESIGN-NICHE is a prefabricated niche made of powder-coated aluminum to create storage space for any wall area. Its adjustable frame fits any tile thickness for a flush installation or can be installed with a reveal edge for a stylish design. It is available in three different sizes, five TRENDLINE colors, and has the versatility to be installed horizontally or vertically.  DESIGN-NICHE includes an adjustable anodized aluminum frame, precut KERDI-BAND frame and KERDI-FIX single-component sealing and bonding compound for waterproof applications."]
[]
[]
[" "]
[]
[]
[]
[]
["Discontinued Products"]
["2012-09-25","KERDI-BOARD - V","KB96252440V 24-1/2\" x 96\" x 3/8\""]
["2012-09-25","KERDI-BOARD - V","KB126252440V 24-1/2\" x 96\" x 1/2\""]
["2012-09-25","KERDI-BOARD - E","KB126252440E 24-1/2\" x 96\" x 1/2\""]
["2016-06-07","KERDI-SHOWER-SB","All Polystyrene shower benches:  SB41, SB2981, SB29107, SB29122, SB4181 & SB41122.  "]
["2017-12-31","KERDI-SHOWER-SB","All Polystyrene shower benches:  SB41, SB2981, SB29107, SB29122, SB4181 & SB41122.  "]
[]
[" "]
[]
["Changes"]
["2017-05-03","KERDI-SHOWER-SB","Schluter has brought back all the Polystyrene Shower Benches that they had previously discontinued and will continue to produce them only for the remainder of this year:  SB41, SB2981, SB29107, SB29122, SB4181 & SB41122.  "]
["2023-01-18","KERDI-BOARD panels in 1/2\" thickness","All 1/2\" KERDI-BOARD panels, in all formats, are now available for order.  KB121220812 32\" x 48\" x 1/2\" must however be purchased in full pallets of 144 Sheets/Pallet."]
["2023-01-18","KERDI-BOARD panels in 3/16\" and 3/8\" thicknesses","KERDI-BOARD 3/16\" and 3/8\" thick panels are once again available for order in both the 48\" x 64 \" and 48\" x 96\" formats."]
["2023-01-18","KERDI-BOARD panels in 5/8\" thickness","KERDI-BOARD 5/8\" thick panels in 48\" x 96\" format are now available.  KB1512202440 48\" x 96\" x 5/8\" must however be purchased in full pallets of 60 Sheets/Pallet.  KB1512203050 48\" x 120\" x 5/8\" is Special Order Only and Schluter customer service needs to be contacted for lead time and any quantity restrictions."]
["2024-08-16","KERDI-BOARD-SN","To facilitate the installation process and minimize build-up when waterproofing the seams, Schluter is introducing the following new components to the Kerdi-Board-SN shower niches:  1- Kerdi-Band waterproofing frame used to seal seams with minimal build-up & 8-sets Kerdi-Board-ZT/ZTS screws & washers for fastening Kerdi-Board panel to stud framing."]
["2024-09-27","KERDI-BOARD","KB386252440, 24-1/2\" x 96\" x 1-1/2\" thickness is no longer being \"Stocked\". "]
["2025-04-07","KERDI-BOARD-SNLT","Niches in the vertical format will soon include the KERDI-BAND waterproofing frame, screws, and washers.  The prefabricated shelf will no longer be included.  Please note the new item codes for these products will end in \"F\"."]