{"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":13,"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","4/1/23"]
[]
[]
[]
["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,1,null,"Board - Stock",null,"No",0]
[null,2,null,"Board - Non-Stock",null,"No",0]
[null,3,null,"Accessories",null,"No",0,null,null,null,null,null,"  "]
[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":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,0,5,10],[48,0,48,10],[50,0,50,10],[2,5,2,10],[3,4,3,7]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'S' - Schluter Kerdi-Board"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 4/1/23"}]
[]
[]
[]
[]
["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"]
["1-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"]
["2",null,"KERDI-BOARD - ZS"]
["2",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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":282,"n_cols":41,"rows_kept":282,"cut":false,"hidden":false,"merged":[[20,2,20,19],[14,13,15,19],[271,3,271,4],[18,2,18,19],[17,14,17,15],[263,2,263,19],[206,2,206,19],[219,2,219,19],[9,25,9,32],[12,22,12,23],[267,2,267,19],[265,2,265,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],[231,2,231,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":"4/1/23"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-03-01"},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,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":33},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":33},null,"YES",33,{"$f":"+W31","v":0},{"$f":"+X31","v":33},{"$f":"(AG31-AC31)/AG31","v":0},null,2,{"$f":"SUM(AJ31:AL31)+AE31","v":33},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":33},{"$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":59.85},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA33*(1-W33)+0.004999,2)","v":59.85},null,"YES",59.85,{"$f":"+W33","v":0},{"$f":"+X33","v":59.85},{"$f":"(AG33-AC33)/AG33","v":0},null,2,{"$f":"SUM(AJ33:AL33)+AE33","v":59.85},null,null,{"$f":"ROUND(AC33/(1-VLOOKUP(AF33,Group,2,FALSE)),2)","v":59.85},{"$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,63.15,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},63.15,null,"YES",63.15,0,63.15,0,null,2,63.15,null,null,63.15,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":62.35},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},62.35,null,"YES",62.35,0,62.35,0,null,1,62.35,null,null,62.35,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,89.7,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},89.7,null,"YES",89.7,0,89.7,0,null,2,89.7,null,null,89.7,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,94.65,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},94.65,null,"YES",94.65,0,94.65,0,null,2,94.65,null,null,94.65,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":93.5},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},93.5,null,"YES",93.5,0,93.5,0,null,1,93.5,null,null,93.5,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,"60 Sheets/Pallet",null,null,{"$f":"IF(Suggested=\"Yes\",AA40,AG40)","v":111.55},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},111.55,null,"YES",111.55,0,111.55,0,null,2,111.55,null,null,111.55,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,54.45,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},54.45,null,"YES",54.45,0,54.45,0,null,2,54.45,null,null,54.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,58.05,"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},58.05,null,"YES",58.05,0,58.05,0,null,2,58.05,null,null,58.05,0,0,"",null,"X"]
[null,"Board - Stock",null,null,"24-1/2\" x 96\"",null,"1-1/2\" thickness",null,null,null,null,"KB386252440",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA44,AG44)","v":63.45},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},63.45,null,"YES",63.45,{"$f":"+W44","v":0},{"$f":"+X44","v":63.45},{"$f":"(AG44-AC44)/AG44","v":0},null,1,{"$f":"SUM(AJ44:AL44)+AE44","v":63.45},null,null,{"$f":"ROUND(AC44/(1-VLOOKUP(AF44,Group,2,FALSE)),2)","v":63.45},{"$f":"IF(VLOOKUP(AF44,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ44,1)-AJ44,2),Round,2,FALSE)+VLOOKUP(AF44,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",0,ROUND(AJ44-0.04999,1)-AJ44+AM44)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF44,Group,7,FALSE))","v":""},null,"X"]
[null,"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":71.650000000000006},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},71.650000000000006,null,"YES",71.650000000000006,0,71.650000000000006,0,null,1,71.650000000000006,null,null,71.650000000000006,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":138.55000000000001},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA47*(1-W47)+0.004999,2)","v":138.55000000000001},null,"YES",138.55000000000001,{"$f":"+W47","v":0},{"$f":"+X47","v":138.55000000000001},{"$f":"(AG47-AC47)/AG47","v":0},null,2,{"$f":"SUM(AJ47:AL47)+AE47","v":138.55000000000001},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":138.55000000000001},{"$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":65.5},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA55*(1-W55)+0.004999,2)","v":65.5},null,"YES",65.5,{"$f":"+W55","v":0},65.5,{"$f":"(AG55-AC55)/AG55","v":0},null,2,{"$f":"SUM(AJ55:AL55)+AE55","v":65.5},null,null,{"$f":"ROUND(AC55/(1-VLOOKUP(AF55,Group,2,FALSE)),2)","v":65.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":71.5},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":71.5},null,"YES",71.5,0,71.5,{"$f":"(AG56-AC56)/AG56","v":0},null,2,{"$f":"SUM(AJ56:AL56)+AE56","v":71.5},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":71.5},{"$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":79.55},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA57*(1-W57)+0.004999,2)","v":79.55},null,"YES",79.55,0,79.55,{"$f":"(AG57-AC57)/AG57","v":0},null,2,{"$f":"SUM(AJ57:AL57)+AE57","v":79.55},null,null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":79.55},{"$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":88.25},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA58*(1-W58)+0.004999,2)","v":88.25},null,"YES",88.25,0,88.25,{"$f":"(AG58-AC58)/AG58","v":0},null,2,{"$f":"SUM(AJ58:AL58)+AE58","v":88.25},null,null,{"$f":"ROUND(AC58/(1-VLOOKUP(AF58,Group,2,FALSE)),2)","v":88.25},{"$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":70.45},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":70.45},null,"YES",70.45,{"$f":"+W64","v":0},{"$f":"+X64","v":70.45},{"$f":"(AG64-AC64)/AG64","v":0},null,2,{"$f":"SUM(AJ64:AL64)+AE64","v":70.45},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":70.45},{"$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":75.05},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":75.05},null,"YES",75.05,{"$f":"+W65","v":0},{"$f":"+X65","v":75.05},{"$f":"(AG65-AC65)/AG65","v":0},null,2,{"$f":"SUM(AJ65:AL65)+AE65","v":75.05},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":75.05},{"$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":87.7},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":87.7},null,"YES",87.7,{"$f":"+W71","v":0},{"$f":"+X71","v":87.7},{"$f":"(AG71-AC71)/AG71","v":0},null,2,{"$f":"SUM(AJ71:AL71)+AE71","v":87.7},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":87.7},{"$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":87.7},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA72*(1-W72)+0.004999,2)","v":87.7},null,"YES",87.7,{"$f":"+W72","v":0},{"$f":"+X72","v":87.7},{"$f":"(AG72-AC72)/AG72","v":0},null,2,{"$f":"SUM(AJ72:AL72)+AE72","v":87.7},null,null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":87.7},{"$f":"IF(VLOOKUP(AF72,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ72,1)-AJ72,2),Round,2,FALSE)+VLOOKUP(AF72,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",0,ROUND(AJ72-0.04999,1)-AJ72+AM72)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF72,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":536.70000000000005},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA79*(1-W79)+0.004999,2)","v":536.70000000000005},null,"YES",536.70000000000005,{"$f":"+W79","v":0},{"$f":"+X79","v":536.70000000000005},{"$f":"(AG79-AC79)/AG79","v":0},null,2,{"$f":"SUM(AJ79:AL79)+AE79","v":536.70000000000005},null,null,{"$f":"ROUND(AC79/(1-VLOOKUP(AF79,Group,2,FALSE)),2)","v":536.70000000000005},{"$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.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":1.4},null,"YES",1.4,{"$f":"+W92","v":0},{"$f":"+X92","v":1.4},{"$f":"(AG92-AC92)/AG92","v":0},null,3,{"$f":"SUM(AJ92:AL92)+AE92","v":1.4},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":1.4},{"$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":20.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},20.45,null,"YES",20.45,{"$f":"+W93","v":0},{"$f":"+X93","v":20.45},{"$f":"(AG93-AC93)/AG93","v":0},null,3,{"$f":"SUM(AJ93:AL93)+AE93","v":20.45},null,null,{"$f":"ROUND(AC93/(1-VLOOKUP(AF93,Group,2,FALSE)),2)","v":20.45},{"$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":48.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},48.35,null,"YES",48.35,{"$f":"+W100","v":0},{"$f":"+X100","v":48.35},{"$f":"(AG100-AC100)/AG100","v":0},null,3,{"$f":"SUM(AJ100:AL100)+AE100","v":48.35},null,null,{"$f":"ROUND(AC100/(1-VLOOKUP(AF100,Group,2,FALSE)),2)","v":48.35},{"$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":52.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},52.8,null,"YES",52.8,{"$f":"+W101","v":0},{"$f":"+X101","v":52.8},{"$f":"(AG101-AC101)/AG101","v":0},null,3,{"$f":"SUM(AJ101:AL101)+AE101","v":52.8},null,null,{"$f":"ROUND(AC101/(1-VLOOKUP(AF101,Group,2,FALSE)),2)","v":52.8},{"$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":17.399999999999999},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},17.399999999999999,null,"YES",17.399999999999999,{"$f":"+W103","v":0},{"$f":"+X103","v":17.399999999999999},{"$f":"(AG103-AC103)/AG103","v":0},null,3,{"$f":"SUM(AJ103:AL103)+AE103","v":17.399999999999999},null,null,{"$f":"ROUND(AC103/(1-VLOOKUP(AF103,Group,2,FALSE)),2)","v":17.399999999999999},{"$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":17.399999999999999},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},17.399999999999999,null,"YES",17.399999999999999,{"$f":"+W104","v":0},{"$f":"+X104","v":17.399999999999999},{"$f":"(AG104-AC104)/AG104","v":0},null,3,{"$f":"SUM(AJ104:AL104)+AE104","v":17.399999999999999},null,null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":17.399999999999999},{"$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":5.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},5.5,null,"YES",5.5,{"$f":"+W106","v":0},5.5,{"$f":"(AG106-AC106)/AG106","v":0},null,3,{"$f":"SUM(AJ106:AL106)+AE106","v":5.5},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":5.5},{"$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":5.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},5.5,null,"YES",5.5,0,5.5,{"$f":"(AG107-AC107)/AG107","v":0},null,3,{"$f":"SUM(AJ107:AL107)+AE107","v":5.5},null,null,{"$f":"ROUND(AC107/(1-VLOOKUP(AF107,Group,2,FALSE)),2)","v":5.5},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"continued on next page",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"KERDI-BOARD - ZC - continued",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,"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\",AA112,AG112)","v":5.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},5.5,null,"YES",5.5,0,5.5,{"$f":"(AG112-AC112)/AG112","v":0},null,3,{"$f":"SUM(AJ112:AL112)+AE112","v":5.5},null,null,{"$f":"ROUND(AC112/(1-VLOOKUP(AF112,Group,2,FALSE)),2)","v":5.5},{"$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,"2\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ50EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA113,AG113)","v":5.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},5.5,null,"YES",5.5,0,5.5,{"$f":"(AG113-AC113)/AG113","v":0},null,3,{"$f":"SUM(AJ113:AL113)+AE113","v":5.5},null,null,{"$f":"ROUND(AC113/(1-VLOOKUP(AF113,Group,2,FALSE)),2)","v":5.5},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA115,AG115)","v":3.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.4,null,"YES",3.4,{"$f":"+W115","v":0},3.4,{"$f":"(AG115-AC115)/AG115","v":0},null,3,{"$f":"SUM(AJ115:AL115)+AE115","v":3.4},null,null,{"$f":"ROUND(AC115/(1-VLOOKUP(AF115,Group,2,FALSE)),2)","v":3.4},{"$f":"IF(VLOOKUP(AF115,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ115,1)-AJ115,2),Round,2,FALSE)+VLOOKUP(AF115,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,7,FALSE)=\"\",0,ROUND(AJ115-0.04999,1)-AJ115+AM115)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF115,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\",AA116,AG116)","v":3.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.4,null,"YES",3.4,0,3.4,{"$f":"(AG116-AC116)/AG116","v":0},null,3,{"$f":"SUM(AJ116:AL116)+AE116","v":3.4},null,null,{"$f":"ROUND(AC116/(1-VLOOKUP(AF116,Group,2,FALSE)),2)","v":3.4},{"$f":"IF(VLOOKUP(AF116,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ116,1)-AJ116,2),Round,2,FALSE)+VLOOKUP(AF116,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",0,ROUND(AJ116-0.04999,1)-AJ116+AM116)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF116,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\",AA117,AG117)","v":3.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.4,null,"YES",3.4,0,3.4,{"$f":"(AG117-AC117)/AG117","v":0},null,3,{"$f":"SUM(AJ117:AL117)+AE117","v":3.4},null,null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":3.4},{"$f":"IF(VLOOKUP(AF117,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ117,1)-AJ117,2),Round,2,FALSE)+VLOOKUP(AF117,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",0,ROUND(AJ117-0.04999,1)-AJ117+AM117)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF117,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA118,AG118)","v":3.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.4,null,"YES",3.4,0,3.4,{"$f":"(AG118-AC118)/AG118","v":0},null,3,{"$f":"SUM(AJ118:AL118)+AE118","v":3.4},null,null,{"$f":"ROUND(AC118/(1-VLOOKUP(AF118,Group,2,FALSE)),2)","v":3.4},{"$f":"IF(VLOOKUP(AF118,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ118,1)-AJ118,2),Round,2,FALSE)+VLOOKUP(AF118,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",0,ROUND(AJ118-0.04999,1)-AJ118+AM118)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF118,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\",AA125,AG125)","v":41.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},41.05,null,"YES",41.05,{"$f":"+W125","v":0},41.05,{"$f":"(AG125-AC125)/AG125","v":0},null,3,{"$f":"SUM(AJ125:AL125)+AE125","v":41.05},null,null,{"$f":"ROUND(AC125/(1-VLOOKUP(AF125,Group,2,FALSE)),2)","v":41.05},{"$f":"IF(VLOOKUP(AF125,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ125,1)-AJ125,2),Round,2,FALSE)+VLOOKUP(AF125,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",0,ROUND(AJ125-0.04999,1)-AJ125+AM125)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF125,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA126,AG126)","v":44.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},44.3,null,"YES",44.3,0,44.3,{"$f":"(AG126-AC126)/AG126","v":0},null,3,{"$f":"SUM(AJ126:AL126)+AE126","v":44.3},null,null,{"$f":"ROUND(AC126/(1-VLOOKUP(AF126,Group,2,FALSE)),2)","v":44.3},{"$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,"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\",AA127,AG127)","v":48.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},48.3,null,"YES",48.3,0,48.3,{"$f":"(AG127-AC127)/AG127","v":0},null,3,{"$f":"SUM(AJ127:AL127)+AE127","v":48.3},null,null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":48.3},{"$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,"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\",AA128,AG128)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},52.8,null,"YES",52.8,0,52.8,{"$f":"(AG128-AC128)/AG128","v":0},null,3,{"$f":"SUM(AJ128:AL128)+AE128","v":52.8},null,null,{"$f":"ROUND(AC128/(1-VLOOKUP(AF128,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF128,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ128,1)-AJ128,2),Round,2,FALSE)+VLOOKUP(AF128,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",0,ROUND(AJ128-0.04999,1)-AJ128+AM128)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF128,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\",AA130,AG130)","v":17.399999999999999},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},17.399999999999999,null,"YES",17.399999999999999,{"$f":"+W130","v":0},{"$f":"+X130","v":17.399999999999999},{"$f":"(AG130-AC130)/AG130","v":0},null,3,{"$f":"SUM(AJ130:AL130)+AE130","v":17.399999999999999},null,null,{"$f":"ROUND(AC130/(1-VLOOKUP(AF130,Group,2,FALSE)),2)","v":17.399999999999999},{"$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,"2\"",null,"Outside Corner for ZA Profile",null,null,null,null,"E/KBZA50EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA131,AG131)","v":17.399999999999999},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},17.399999999999999,null,"YES",17.399999999999999,{"$f":"+W131","v":0},{"$f":"+X131","v":17.399999999999999},{"$f":"(AG131-AC131)/AG131","v":0},null,3,{"$f":"SUM(AJ131:AL131)+AE131","v":17.399999999999999},null,null,{"$f":"ROUND(AC131/(1-VLOOKUP(AF131,Group,2,FALSE)),2)","v":17.399999999999999},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA133,AG133)","v":5.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},5.5,null,"YES",5.5,{"$f":"+W133","v":0},5.5,{"$f":"(AG133-AC133)/AG133","v":0},null,3,{"$f":"SUM(AJ133:AL133)+AE133","v":5.5},null,null,{"$f":"ROUND(AC133/(1-VLOOKUP(AF133,Group,2,FALSE)),2)","v":5.5},{"$f":"IF(VLOOKUP(AF133,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ133,1)-AJ133,2),Round,2,FALSE)+VLOOKUP(AF133,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",0,ROUND(AJ133-0.04999,1)-AJ133+AM133)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF133,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA134,AG134)","v":5.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},5.5,null,"YES",5.5,0,5.5,{"$f":"(AG134-AC134)/AG134","v":0},null,3,{"$f":"SUM(AJ134:AL134)+AE134","v":5.5},null,null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":5.5},{"$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-1/2\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ38EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA135,AG135)","v":5.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},5.5,null,"YES",5.5,0,5.5,{"$f":"(AG135-AC135)/AG135","v":0},null,3,{"$f":"SUM(AJ135:AL135)+AE135","v":5.5},null,null,{"$f":"ROUND(AC135/(1-VLOOKUP(AF135,Group,2,FALSE)),2)","v":5.5},{"$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,"2\"",null,"Connector for ZC & ZA Profile",null,null,null,null,"V/KBZ50EB",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA136,AG136)","v":5.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},5.5,null,"YES",5.5,0,5.5,{"$f":"(AG136-AC136)/AG136","v":0},null,3,{"$f":"SUM(AJ136:AL136)+AE136","v":5.5},null,null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":5.5},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA138,AG138)","v":3.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.4,null,"YES",3.4,{"$f":"+W138","v":0},3.4,{"$f":"(AG138-AC138)/AG138","v":0},null,3,{"$f":"SUM(AJ138:AL138)+AE138","v":3.4},null,null,{"$f":"ROUND(AC138/(1-VLOOKUP(AF138,Group,2,FALSE)),2)","v":3.4},{"$f":"IF(VLOOKUP(AF138,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ138,1)-AJ138,2),Round,2,FALSE)+VLOOKUP(AF138,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF138,Group,7,FALSE)=\"\",0,ROUND(AJ138-0.04999,1)-AJ138+AM138)","v":0},{"$f":"IF(VLOOKUP(AF138,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF138,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA139,AG139)","v":3.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.4,null,"YES",3.4,0,3.4,{"$f":"(AG139-AC139)/AG139","v":0},null,3,{"$f":"SUM(AJ139:AL139)+AE139","v":3.4},null,null,{"$f":"ROUND(AC139/(1-VLOOKUP(AF139,Group,2,FALSE)),2)","v":3.4},{"$f":"IF(VLOOKUP(AF139,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ139,1)-AJ139,2),Round,2,FALSE)+VLOOKUP(AF139,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",0,ROUND(AJ139-0.04999,1)-AJ139+AM139)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF139,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\",AA140,AG140)","v":3.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.4,null,"YES",3.4,0,3.4,{"$f":"(AG140-AC140)/AG140","v":0},null,3,{"$f":"SUM(AJ140:AL140)+AE140","v":3.4},null,null,{"$f":"ROUND(AC140/(1-VLOOKUP(AF140,Group,2,FALSE)),2)","v":3.4},{"$f":"IF(VLOOKUP(AF140,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ140,1)-AJ140,2),Round,2,FALSE)+VLOOKUP(AF140,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",0,ROUND(AJ140-0.04999,1)-AJ140+AM140)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF140,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA141,AG141)","v":3.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},3.4,null,"YES",3.4,0,3.4,{"$f":"(AG141-AC141)/AG141","v":0},null,3,{"$f":"SUM(AJ141:AL141)+AE141","v":3.4},null,null,{"$f":"ROUND(AC141/(1-VLOOKUP(AF141,Group,2,FALSE)),2)","v":3.4},{"$f":"IF(VLOOKUP(AF141,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ141,1)-AJ141,2),Round,2,FALSE)+VLOOKUP(AF141,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,7,FALSE)=\"\",0,ROUND(AJ141-0.04999,1)-AJ141+AM141)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF141,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,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\",AA148,AG148)","v":35.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},35.35,null,"YES",35.35,{"$f":"+W148","v":0},35.35,{"$f":"(AG148-AC148)/AG148","v":0},null,3,{"$f":"SUM(AJ148:AL148)+AE148","v":35.35},null,null,{"$f":"ROUND(AC148/(1-VLOOKUP(AF148,Group,2,FALSE)),2)","v":35.35},{"$f":"IF(VLOOKUP(AF148,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ148,1)-AJ148,2),Round,2,FALSE)+VLOOKUP(AF148,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",0,ROUND(AJ148-0.04999,1)-AJ148+AM148)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF148,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\",AA149,AG149)","v":38.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},38.15,null,"YES",38.15,0,38.15,{"$f":"(AG149-AC149)/AG149","v":0},null,3,{"$f":"SUM(AJ149:AL149)+AE149","v":38.15},null,null,{"$f":"ROUND(AC149/(1-VLOOKUP(AF149,Group,2,FALSE)),2)","v":38.15},{"$f":"IF(VLOOKUP(AF149,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ149,1)-AJ149,2),Round,2,FALSE)+VLOOKUP(AF149,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",0,ROUND(AJ149-0.04999,1)-AJ149+AM149)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF149,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\",AA150,AG150)","v":41.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},41.3,null,"YES",41.3,0,41.3,{"$f":"(AG150-AC150)/AG150","v":0},null,3,{"$f":"SUM(AJ150:AL150)+AE150","v":41.3},null,null,{"$f":"ROUND(AC150/(1-VLOOKUP(AF150,Group,2,FALSE)),2)","v":41.3},{"$f":"IF(VLOOKUP(AF150,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ150,1)-AJ150,2),Round,2,FALSE)+VLOOKUP(AF150,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF150,Group,7,FALSE)=\"\",0,ROUND(AJ150-0.04999,1)-AJ150+AM150)","v":0},{"$f":"IF(VLOOKUP(AF150,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF150,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\",AA151,AG151)","v":45.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},45.35,null,"YES",45.35,0,45.35,{"$f":"(AG151-AC151)/AG151","v":0},null,3,{"$f":"SUM(AJ151:AL151)+AE151","v":45.35},null,null,{"$f":"ROUND(AC151/(1-VLOOKUP(AF151,Group,2,FALSE)),2)","v":45.35},{"$f":"IF(VLOOKUP(AF151,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ151,1)-AJ151,2),Round,2,FALSE)+VLOOKUP(AF151,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,7,FALSE)=\"\",0,ROUND(AJ151-0.04999,1)-AJ151+AM151)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF151,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"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\",AA158,AG158)","v":8.9499999999999993},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA158*(1-W158)+0.004999,2)","v":8.9499999999999993},null,"YES",8.9499999999999993,{"$f":"+W158","v":0},{"$f":"+X158","v":8.9499999999999993},{"$f":"(AG158-AC158)/AG158","v":0},null,3,{"$f":"SUM(AJ158:AL158)+AE158","v":8.9499999999999993},null,null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":8.9499999999999993},{"$f":"IF(VLOOKUP(AF158,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ158,1)-AJ158,2),Round,2,FALSE)+VLOOKUP(AF158,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",0,ROUND(AJ158-0.04999,1)-AJ158+AM158)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF158,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA165,AG165)","v":23.6},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA165*(1-W165)+0.004999,2)","v":23.6},null,"YES",23.6,{"$f":"+W165","v":0},{"$f":"+X165","v":23.6},{"$f":"(AG165-AC165)/AG165","v":0},null,3,{"$f":"SUM(AJ165:AL165)+AE165","v":23.6},null,null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":23.6},{"$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,"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\",AA166,AG166)","v":27.2},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":27.2},null,"YES",27.2,{"$f":"+W166","v":0},{"$f":"+X166","v":27.2},{"$f":"(AG166-AC166)/AG166","v":0},null,3,{"$f":"SUM(AJ166:AL166)+AE166","v":27.2},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":27.2},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ166,1)-AJ166,2),Round,2,FALSE)+VLOOKUP(AF166,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",0,ROUND(AJ166-0.04999,1)-AJ166+AM166)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF166,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\",AA168,AG168)","v":12.65},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA168*(1-W168)+0.004999,2)","v":12.65},null,"YES",12.65,{"$f":"+W168","v":0},{"$f":"+X168","v":12.65},{"$f":"(AG168-AC168)/AG168","v":0},null,3,{"$f":"SUM(AJ168:AL168)+AE168","v":12.65},null,null,{"$f":"ROUND(AC168/(1-VLOOKUP(AF168,Group,2,FALSE)),2)","v":12.65},{"$f":"IF(VLOOKUP(AF168,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ168,1)-AJ168,2),Round,2,FALSE)+VLOOKUP(AF168,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",0,ROUND(AJ168-0.04999,1)-AJ168+AM168)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF168,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA169,AG169)","v":14.6},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA169*(1-W169)+0.004999,2)","v":14.6},null,"YES",14.6,{"$f":"+W169","v":0},{"$f":"+X169","v":14.6},{"$f":"(AG169-AC169)/AG169","v":0},null,3,{"$f":"SUM(AJ169:AL169)+AE169","v":14.6},null,null,{"$f":"ROUND(AC169/(1-VLOOKUP(AF169,Group,2,FALSE)),2)","v":14.6},{"$f":"IF(VLOOKUP(AF169,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ169,1)-AJ169,2),Round,2,FALSE)+VLOOKUP(AF169,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF169,Group,7,FALSE)=\"\",0,ROUND(AJ169-0.04999,1)-AJ169+AM169)","v":0},{"$f":"IF(VLOOKUP(AF169,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF169,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\",AA175,AG175)","v":9.35},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA175*(1-W175)+0.004999,2)","v":9.35},null,"YES",9.35,{"$f":"+W175","v":0},{"$f":"+X175","v":9.35},{"$f":"(AG175-AC175)/AG175","v":0},null,3,{"$f":"SUM(AJ175:AL175)+AE175","v":9.35},null,null,{"$f":"ROUND(AC175/(1-VLOOKUP(AF175,Group,2,FALSE)),2)","v":9.35},{"$f":"IF(VLOOKUP(AF175,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ175,1)-AJ175,2),Round,2,FALSE)+VLOOKUP(AF175,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF175,Group,7,FALSE)=\"\",0,ROUND(AJ175-0.04999,1)-AJ175+AM175)","v":0},{"$f":"IF(VLOOKUP(AF175,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF175,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\",AA176,AG176)","v":77.650000000000006},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA176*(1-W176)+0.004999,2)","v":77.650000000000006},null,"YES",77.650000000000006,{"$f":"+W176","v":0},{"$f":"+X176","v":77.650000000000006},{"$f":"(AG176-AC176)/AG176","v":0},null,3,{"$f":"SUM(AJ176:AL176)+AE176","v":77.650000000000006},null,null,{"$f":"ROUND(AC176/(1-VLOOKUP(AF176,Group,2,FALSE)),2)","v":77.650000000000006},{"$f":"IF(VLOOKUP(AF176,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ176,1)-AJ176,2),Round,2,FALSE)+VLOOKUP(AF176,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF176,Group,7,FALSE)=\"\",0,ROUND(AJ176-0.04999,1)-AJ176+AM176)","v":0},{"$f":"IF(VLOOKUP(AF176,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF176,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\",AA182,AG182)","v":12.8},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA182*(1-W182)+0.004999,2)","v":12.8},null,"YES",12.8,{"$f":"+W182","v":0},12.8,{"$f":"(AG182-AC182)/AG182","v":0},null,3,{"$f":"SUM(AJ182:AL182)+AE182","v":12.8},null,null,{"$f":"ROUND(AC182/(1-VLOOKUP(AF182,Group,2,FALSE)),2)","v":12.8},{"$f":"IF(VLOOKUP(AF182,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ182,1)-AJ182,2),Round,2,FALSE)+VLOOKUP(AF182,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",0,ROUND(AJ182-0.04999,1)-AJ182+AM182)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF182,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\",AA183,AG183)","v":9.35},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":9.35},null,"YES",9.35,0,9.35,{"$f":"(AG183-AC183)/AG183","v":0},null,3,{"$f":"SUM(AJ183:AL183)+AE183","v":9.35},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":9.35},{"$f":"IF(VLOOKUP(AF183,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ183,1)-AJ183,2),Round,2,FALSE)+VLOOKUP(AF183,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",0,ROUND(AJ183-0.04999,1)-AJ183+AM183)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF183,Group,7,FALSE))","v":""},null,"X"]
[null,"Accessories",null,null,"3\"",null,"Wood Screws",null,null,null,null,"KBZS75G",null,null,null,"100 Screws/Box",null,null,{"$f":"IF(Suggested=\"Yes\",AA184,AG184)","v":14.3},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA184*(1-W184)+0.004999,2)","v":14.3},null,"YES",14.3,0,14.3,{"$f":"(AG184-AC184)/AG184","v":0},null,3,{"$f":"SUM(AJ184:AL184)+AE184","v":14.3},null,null,{"$f":"ROUND(AC184/(1-VLOOKUP(AF184,Group,2,FALSE)),2)","v":14.3},{"$f":"IF(VLOOKUP(AF184,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ184,1)-AJ184,2),Round,2,FALSE)+VLOOKUP(AF184,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",0,ROUND(AJ184-0.04999,1)-AJ184+AM184)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF184,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\",AA190,AG190)","v":10.65},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA190*(1-W190)+0.004999,2)","v":10.65},null,"YES",10.65,{"$f":"+W190","v":0},{"$f":"+X190","v":10.65},{"$f":"(AG190-AC190)/AG190","v":0},null,3,{"$f":"SUM(AJ190:AL190)+AE190","v":10.65},null,null,{"$f":"ROUND(AC190/(1-VLOOKUP(AF190,Group,2,FALSE)),2)","v":10.65},{"$f":"IF(VLOOKUP(AF190,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ190,1)-AJ190,2),Round,2,FALSE)+VLOOKUP(AF190,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF190,Group,7,FALSE)=\"\",0,ROUND(AJ190-0.04999,1)-AJ190+AM190)","v":0},{"$f":"IF(VLOOKUP(AF190,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF190,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\",AA191,AG191)","v":20.100000000000001},"BOX",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA191*(1-W191)+0.004999,2)","v":20.100000000000001},null,"YES",20.100000000000001,{"$f":"+W191","v":0},{"$f":"+X191","v":20.100000000000001},{"$f":"(AG191-AC191)/AG191","v":0},null,3,{"$f":"SUM(AJ191:AL191)+AE191","v":20.100000000000001},null,null,{"$f":"ROUND(AC191/(1-VLOOKUP(AF191,Group,2,FALSE)),2)","v":20.100000000000001},{"$f":"IF(VLOOKUP(AF191,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ191,1)-AJ191,2),Round,2,FALSE)+VLOOKUP(AF191,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF191,Group,7,FALSE)=\"\",0,ROUND(AJ191-0.04999,1)-AJ191+AM191)","v":0},{"$f":"IF(VLOOKUP(AF191,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF191,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\",AA197,AG197)","v":7.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA197*(1-W197)+0.004999,2)","v":7.8},null,"YES",7.8,{"$f":"+W197","v":0},7.8,{"$f":"(AG197-AC197)/AG197","v":0},null,3,{"$f":"SUM(AJ197:AL197)+AE197","v":7.8},null,null,{"$f":"ROUND(AC197/(1-VLOOKUP(AF197,Group,2,FALSE)),2)","v":7.8},{"$f":"IF(VLOOKUP(AF197,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ197,1)-AJ197,2),Round,2,FALSE)+VLOOKUP(AF197,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF197,Group,7,FALSE)=\"\",0,ROUND(AJ197-0.04999,1)-AJ197+AM197)","v":0},{"$f":"IF(VLOOKUP(AF197,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF197,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\",AA198,AG198)","v":12.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA198*(1-W198)+0.004999,2)","v":12.1},null,"YES",12.1,0,12.1,{"$f":"(AG198-AC198)/AG198","v":0},null,3,{"$f":"SUM(AJ198:AL198)+AE198","v":12.1},null,null,{"$f":"ROUND(AC198/(1-VLOOKUP(AF198,Group,2,FALSE)),2)","v":12.1},{"$f":"IF(VLOOKUP(AF198,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ198,1)-AJ198,2),Round,2,FALSE)+VLOOKUP(AF198,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF198,Group,7,FALSE)=\"\",0,ROUND(AJ198-0.04999,1)-AJ198+AM198)","v":0},{"$f":"IF(VLOOKUP(AF198,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF198,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\",AA199,AG199)","v":19.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA199*(1-W199)+0.004999,2)","v":19.05},null,"YES",19.05,0,19.05,{"$f":"(AG199-AC199)/AG199","v":0},null,3,{"$f":"SUM(AJ199:AL199)+AE199","v":19.05},null,null,{"$f":"ROUND(AC199/(1-VLOOKUP(AF199,Group,2,FALSE)),2)","v":19.05},{"$f":"IF(VLOOKUP(AF199,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ199,1)-AJ199,2),Round,2,FALSE)+VLOOKUP(AF199,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF199,Group,7,FALSE)=\"\",0,ROUND(AJ199-0.04999,1)-AJ199+AM199)","v":0},{"$f":"IF(VLOOKUP(AF199,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF199,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"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\",AA205,AG205)","v":13.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA205*(1-W205)+0.004999,2)","v":13.9},null,"YES",13.9,{"$f":"+W205","v":0},{"$f":"+X205","v":13.9},{"$f":"(AG205-AC205)/AG205","v":0},null,3,{"$f":"SUM(AJ205:AL205)+AE205","v":13.9},null,null,{"$f":"ROUND(AC205/(1-VLOOKUP(AF205,Group,2,FALSE)),2)","v":13.9},{"$f":"IF(VLOOKUP(AF205,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ205,1)-AJ205,2),Round,2,FALSE)+VLOOKUP(AF205,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF205,Group,7,FALSE)=\"\",0,ROUND(AJ205-0.04999,1)-AJ205+AM205)","v":0},{"$f":"IF(VLOOKUP(AF205,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF205,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\",AA215,AG215)","v":121.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA215*(1-W215)+0.004999,2)","v":121.5},null,"YES",121.5,{"$f":"+W215","v":0},121.5,{"$f":"(AG215-AC215)/AG215","v":0},null,2,{"$f":"SUM(AJ215:AL215)+AE215","v":121.5},null,null,{"$f":"ROUND(AC215/(1-VLOOKUP(AF215,Group,2,FALSE)),2)","v":121.5},{"$f":"IF(VLOOKUP(AF215,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ215,1)-AJ215,2),Round,2,FALSE)+VLOOKUP(AF215,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF215,Group,7,FALSE)=\"\",0,ROUND(AJ215-0.04999,1)-AJ215+AM215)","v":0},{"$f":"IF(VLOOKUP(AF215,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF215,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA216,AG216)","v":157.30000000000001},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA216*(1-W216)+0.004999,2)","v":157.30000000000001},null,"YES",157.30000000000001,{"$f":"+W216","v":0},{"$f":"+X216","v":157.30000000000001},{"$f":"(AG216-AC216)/AG216","v":0},null,2,{"$f":"SUM(AJ216:AL216)+AE216","v":157.30000000000001},null,null,{"$f":"ROUND(AC216/(1-VLOOKUP(AF216,Group,2,FALSE)),2)","v":157.30000000000001},{"$f":"IF(VLOOKUP(AF216,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ216,1)-AJ216,2),Round,2,FALSE)+VLOOKUP(AF216,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",0,ROUND(AJ216-0.04999,1)-AJ216+AM216)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF216,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA217,AG217)","v":193.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA217*(1-W217)+0.004999,2)","v":193.85},null,"YES",193.85,0,193.85,{"$f":"(AG217-AC217)/AG217","v":0},null,2,{"$f":"SUM(AJ217:AL217)+AE217","v":193.85},null,null,{"$f":"ROUND(AC217/(1-VLOOKUP(AF217,Group,2,FALSE)),2)","v":193.85},{"$f":"IF(VLOOKUP(AF217,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ217,1)-AJ217,2),Round,2,FALSE)+VLOOKUP(AF217,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF217,Group,7,FALSE)=\"\",0,ROUND(AJ217-0.04999,1)-AJ217+AM217)","v":0},{"$f":"IF(VLOOKUP(AF217,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF217,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\",AA218,AG218)","v":256.39999999999998},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA218*(1-W218)+0.004999,2)","v":256.39999999999998},null,"YES",256.39999999999998,0,256.39999999999998,{"$f":"(AG218-AC218)/AG218","v":0},null,2,{"$f":"SUM(AJ218:AL218)+AE218","v":256.39999999999998},null,null,{"$f":"ROUND(AC218/(1-VLOOKUP(AF218,Group,2,FALSE)),2)","v":256.39999999999998},{"$f":"IF(VLOOKUP(AF218,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ218,1)-AJ218,2),Round,2,FALSE)+VLOOKUP(AF218,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",0,ROUND(AJ218-0.04999,1)-AJ218+AM218)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF218,Group,7,FALSE))","v":""},null,"X"]
[]
[null,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\",AA228,AG228)","v":47.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA228*(1-W228)+0.004999,2)","v":47.95},null,"YES",47.95,{"$f":"+W228","v":0},47.95,{"$f":"(AG228-AC228)/AG228","v":0},null,2,{"$f":"SUM(AJ228:AL228)+AE228","v":47.95},null,null,{"$f":"ROUND(AC228/(1-VLOOKUP(AF228,Group,2,FALSE)),2)","v":47.95},{"$f":"IF(VLOOKUP(AF228,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ228,1)-AJ228,2),Round,2,FALSE)+VLOOKUP(AF228,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF228,Group,7,FALSE)=\"\",0,ROUND(AJ228-0.04999,1)-AJ228+AM228)","v":0},{"$f":"IF(VLOOKUP(AF228,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF228,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA229,AG229)","v":52.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA229*(1-W229)+0.004999,2)","v":52.3},null,"YES",52.3,0,52.3,{"$f":"(AG229-AC229)/AG229","v":0},null,2,{"$f":"SUM(AJ229:AL229)+AE229","v":52.3},null,null,{"$f":"ROUND(AC229/(1-VLOOKUP(AF229,Group,2,FALSE)),2)","v":52.3},{"$f":"IF(VLOOKUP(AF229,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ229,1)-AJ229,2),Round,2,FALSE)+VLOOKUP(AF229,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",0,ROUND(AJ229-0.04999,1)-AJ229+AM229)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF229,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA230,AG230)","v":76.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA230*(1-W230)+0.004999,2)","v":76.45},null,"YES",76.45,0,76.45,{"$f":"(AG230-AC230)/AG230","v":0},null,2,{"$f":"SUM(AJ230:AL230)+AE230","v":76.45},null,null,{"$f":"ROUND(AC230/(1-VLOOKUP(AF230,Group,2,FALSE)),2)","v":76.45},{"$f":"IF(VLOOKUP(AF230,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ230,1)-AJ230,2),Round,2,FALSE)+VLOOKUP(AF230,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF230,Group,7,FALSE)=\"\",0,ROUND(AJ230-0.04999,1)-AJ230+AM230)","v":0},{"$f":"IF(VLOOKUP(AF230,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF230,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"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,null,null,null,null,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.  The 12\" x 20\" and 12\" x 28\" niches include a prefabricated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 shelf that can be installed at any height to create separate compartments within the shower niche if desired.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"KB12SN305152A",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA240,AG240)","v":47.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA240*(1-W240)+0.004999,2)","v":47.55},null,"YES",47.55,{"$f":"+W240","v":0},47.55,{"$f":"(AG240-AC240)/AG240","v":0},null,2,{"$f":"SUM(AJ240:AL240)+AE240","v":47.55},null,null,{"$f":"ROUND(AC240/(1-VLOOKUP(AF240,Group,2,FALSE)),2)","v":47.55},{"$f":"IF(VLOOKUP(AF240,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ240,1)-AJ240,2),Round,2,FALSE)+VLOOKUP(AF240,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF240,Group,7,FALSE)=\"\",0,ROUND(AJ240-0.04999,1)-AJ240+AM240)","v":0},{"$f":"IF(VLOOKUP(AF240,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF240,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"12\" x 12\"",null,"Shower Niche",null,null,null,null,"KB12SN305305A",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA241,AG241)","v":57.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA241*(1-W241)+0.004999,2)","v":57.05},null,"YES",57.05,0,57.05,{"$f":"(AG241-AC241)/AG241","v":0},null,2,{"$f":"SUM(AJ241:AL241)+AE241","v":57.05},null,null,{"$f":"ROUND(AC241/(1-VLOOKUP(AF241,Group,2,FALSE)),2)","v":57.05},{"$f":"IF(VLOOKUP(AF241,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ241,1)-AJ241,2),Round,2,FALSE)+VLOOKUP(AF241,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF241,Group,7,FALSE)=\"\",0,ROUND(AJ241-0.04999,1)-AJ241+AM241)","v":0},{"$f":"IF(VLOOKUP(AF241,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF241,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"12\" x 20\"",null,"Shower Niche (1 Shelf Included)",null,null,null,null,"KB12SN305508A1",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA242,AG242)","v":77.2},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA242*(1-W242)+0.004999,2)","v":77.2},null,"YES",77.2,0,77.2,{"$f":"(AG242-AC242)/AG242","v":0},null,2,{"$f":"SUM(AJ242:AL242)+AE242","v":77.2},null,null,{"$f":"ROUND(AC242/(1-VLOOKUP(AF242,Group,2,FALSE)),2)","v":77.2},{"$f":"IF(VLOOKUP(AF242,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ242,1)-AJ242,2),Round,2,FALSE)+VLOOKUP(AF242,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF242,Group,7,FALSE)=\"\",0,ROUND(AJ242-0.04999,1)-AJ242+AM242)","v":0},{"$f":"IF(VLOOKUP(AF242,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF242,Group,7,FALSE))","v":""},null,"X"]
[null,"Board - Non-Stock",null,null,"12\" x 28\"",null,"Shower Niche (1 Shelf Included)",null,null,null,null,"KB12SN305711A1",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA243,AG243)","v":92.2},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA243*(1-W243)+0.004999,2)","v":92.2},null,"YES",92.2,0,92.2,{"$f":"(AG243-AC243)/AG243","v":0},null,2,{"$f":"SUM(AJ243:AL243)+AE243","v":92.2},null,null,{"$f":"ROUND(AC243/(1-VLOOKUP(AF243,Group,2,FALSE)),2)","v":92.2},{"$f":"IF(VLOOKUP(AF243,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ243,1)-AJ243,2),Round,2,FALSE)+VLOOKUP(AF243,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF243,Group,7,FALSE)=\"\",0,ROUND(AJ243-0.04999,1)-AJ243+AM243)","v":0},{"$f":"IF(VLOOKUP(AF243,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF243,Group,7,FALSE))","v":""},null,"X"]
[]
[]
[]
[null,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"]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Changes","index":4,"n_rows":33,"n_cols":3,"rows_kept":33,"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."]
[]
[]
[" "]
[]
[]
[]
[]
["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."]