{"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":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Nuheat"]
["File as","N"]
["Product Code","N"]
["CCTD Effective Date","5/1/22"]
[]
[]
[]
["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,null,null,null,null,null," "]
[]
[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,"Mats",null,"No",0]
[null,2,null,"Thermostats",null,"No",0,null,null,null,"  "]
[null,3,null,"Misc.",null,"No",0]
[null,4,null,"Stocked Mats",null,"No",0]
[null,5,null,"Stocked Thermostats",null,"No",0]
[null,6,null,"Stocked Misc.",null,"No",0]
[null,7,null,"Stocked Heat Mats",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]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'N' - Nuheat"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 5/1/22"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
["1",null,"Cable Kits"]
[1,null,"Controls"]
[2,null,"Membrane"]
["2",null,"Nuheat Cable to Nuheat Membrane Pillar Coverage Chart"]
["2-3",null,"Mesh"]
[3,null,"Custom Mats"]
["3-4",null,"120 Volt Standard Mats"]
["4-5",null,"240 Volt Standard Mats"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":398,"n_cols":41,"rows_kept":398,"cut":false,"hidden":false,"merged":[[103,2,103,13],[169,2,169,14],[186,6,186,7],[186,8,186,9],[186,10,186,11],[186,12,186,14],[191,6,191,7],[191,8,191,9],[191,10,191,11],[191,12,191,14],[189,6,189,7],[189,8,189,9],[189,10,189,11],[189,12,189,14],[190,6,190,7],[190,8,190,9],[190,10,190,11],[190,12,190,14],[187,6,187,7],[187,8,187,9],[184,6,184,7],[184,8,184,9],[184,10,184,11],[184,12,184,14],[188,10,188,11],[188,12,188,14],[187,10,187,11],[187,12,187,14],[188,6,188,7],[188,8,188,9],[185,6,185,7],[185,8,185,9],[185,10,185,11],[185,12,185,14],[182,6,182,7],[182,8,182,9],[182,10,182,11],[182,12,182,14],[183,6,183,7],[183,8,183,9],[179,10,179,11],[179,12,179,14],[180,6,180,7],[180,8,180,9],[180,10,180,11],[180,12,180,14],[183,10,183,11],[183,12,183,14],[181,6,181,7],[181,8,181,9],[181,10,181,11],[181,12,181,14],[179,6,179,7],[179,8,179,9],[176,6,176,7],[176,8,176,9],[176,10,176,11],[176,12,176,14],[177,6,177,7],[177,8,177,9],[177,10,177,11],[177,12,177,14],[178,6,178,7],[178,8,178,9],[178,10,178,11],[178,12,178,14],[174,6,174,7],[174,8,174,9],[174,10,174,11],[174,12,174,14],[175,6,175,7],[175,8,175,9],[175,10,175,11],[175,12,175,14],[171,6,171,7],[171,8,171,9],[171,10,171,11],[171,12,171,14],[161,6,161,7],[161,8,161,9],[173,6,173,7],[173,8,173,9],[173,10,173,11],[173,12,173,14],[156,8,156,9],[156,10,156,11],[156,12,156,14],[157,6,157,7],[157,8,157,9],[157,10,157,11],[157,12,157,14],[158,6,158,7],[158,8,158,9],[158,10,158,11],[158,12,158,14],[13,30,13,32],[9,22,9,23],[9,25,9,32],[12,22,12,23],[10,14,10,15],[12,14,12,19],[242,2,242,14],[315,2,315,14],[17,14,17,15],[108,6,108,7],[107,8,107,9],[152,12,152,14],[166,12,166,14],[165,6,165,7],[165,8,165,9],[165,10,165,11],[165,12,165,14],[163,6,163,7],[154,6,154,7],[154,8,154,9],[154,10,154,11],[154,12,154,14],[155,6,155,7],[155,8,155,9],[108,8,108,9],[107,10,107,11],[108,10,108,11],[112,8,112,9],[112,10,112,11],[387,3,387,4],[20,2,20,19],[9,14,9,19],[381,2,381,19],[383,2,383,19],[14,13,15,19],[19,2,19,19],[105,6,105,11],[107,6,107,7],[163,8,163,9],[163,10,163,11],[163,12,163,14],[164,6,164,7],[164,8,164,9],[164,10,164,11],[164,12,164,14],[159,6,159,7],[159,8,159,9],[155,10,155,11],[113,6,113,7],[110,6,110,7],[110,8,110,9],[110,10,110,11],[111,6,111,7],[111,8,111,9],[111,10,111,11],[113,8,113,9],[113,10,113,11],[112,6,112,7],[116,6,116,7],[116,8,116,9],[116,10,116,11],[117,6,117,7],[117,8,117,9],[117,10,117,11],[114,6,114,7],[114,8,114,9],[114,10,114,11],[115,6,115,7],[115,8,115,9],[115,10,115,11],[120,6,120,7],[120,8,120,9],[120,10,120,11],[121,6,121,7],[121,8,121,9],[121,10,121,11],[118,6,118,7],[118,8,118,9],[118,10,118,11],[119,6,119,7],[119,8,119,9],[119,10,119,11],[125,6,125,11],[131,6,131,7],[131,8,131,9],[131,10,131,11],[127,6,127,7],[128,6,128,7],[127,8,127,9],[122,6,122,7],[122,8,122,9],[122,10,122,11],[123,6,123,7],[123,8,123,9],[123,10,123,11],[128,8,128,9],[127,10,127,11],[128,10,128,11],[132,6,132,7],[132,8,132,9],[132,10,132,11],[133,6,133,7],[133,8,133,9],[133,10,133,11],[130,6,130,7],[130,8,130,9],[130,10,130,11],[136,6,136,7],[136,8,136,9],[136,10,136,11],[137,6,137,7],[137,8,137,9],[137,10,137,11],[138,6,138,7],[138,8,138,9],[134,6,134,7],[134,8,134,9],[134,10,134,11],[135,6,135,7],[135,8,135,9],[135,10,135,11],[138,10,138,11],[139,6,139,7],[145,6,145,7],[145,8,145,9],[143,6,143,7],[143,8,143,9],[143,10,143,11],[140,6,140,7],[140,8,140,9],[140,10,140,11],[141,6,141,7],[141,8,141,9],[141,10,141,11],[142,6,142,7],[142,8,142,9],[142,10,142,11],[139,8,139,9],[139,10,139,11],[147,6,147,7],[147,8,147,9],[147,10,147,11],[144,6,144,7],[144,8,144,9],[144,10,144,11],[146,8,146,9],[146,10,146,11],[146,6,146,7],[145,10,145,11],[194,2,194,19],[148,6,148,7],[148,8,148,9],[148,10,148,11],[152,10,152,11],[166,10,166,11],[152,6,152,7],[166,6,166,7],[152,8,152,9],[166,8,166,9],[159,10,159,11],[159,12,159,14],[160,6,160,7],[160,8,160,9],[160,10,160,11],[160,12,160,14],[161,10,161,11],[161,12,161,14],[162,6,162,7],[162,8,162,9],[162,10,162,11],[162,12,162,14],[155,12,155,14],[156,6,156,7]]}
[null,"Mats",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":8.0500000000000007},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA1*(1-W1)+0.004999,2)","v":8.0500000000000007},null,"new",8.0500000000000007,{"$f":"+W1","v":0},8.0500000000000007,{"$f":"(AG1-AC1)/AG1","v":0},null,1,{"$f":"SUM(AJ1:AL1)+AE1","v":8.0500000000000007},null,null,{"$f":"ROUND(AC1/(1-VLOOKUP(AF1,Group,2,FALSE)),2)","v":8.0500000000000007},{"$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,"Thermostats",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,2,0,null,null,0,0,0,"",null,"X"]
[null,"Misc.",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,"Stocked Mats",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,"Stocked Thermostats",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,"Stocked Misc.",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,"Stocked Heat Mats",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,7,0,null,null,0,0,0,"",null,"X"]
[null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","a",1000,"ABC",null,null,0.1,1000,null,"ABC",1000,0.1,1000,0.1,10,null,1000,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price List",null,null,null,null,null,null,null,"Cust. Cost",null,null,"Customer Cost Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",AA11,AG11)","v":"Net Price"},"U/M","Code",null,"Disc.","Net",null,"Chg","Net Price","Disc","Act. Cost","GP%","Adj.","Group","Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'N' - Nuheat"},null,null,null,null,null,null,null,"Cost",null,null,null,null,null,null,null,null,null,"Retail Price Calculations",null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Instructions!B4","v":"5/1/22"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2022-12-05"},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,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"+S$11","v":"Net Price"},"U/M",{"$f":"+U$11","v":"Code"},null,"Disc.","Net",null,"Chg","Net Price",{"$f":"+AB$11","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$11","v":"Group"},"Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[]
[null,null,"PRICING LISTED IS NET PRICING. TRADE DISCOUNTS DO NOT APPLY.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"CABLE KITS",null,null,null,null,null,null,null," ",null," ",null,null,null,null,null,null,null,null,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,"120 Volt Cable Kits",null,null,"SQ/FT Range",null,"Amps",null,"Length (ft)",null,null,null,null,null,null,"Item # Lookup:","NUN1C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Stocked Mats",null,null,"N1C008",null,8,null,0.7400000000000001,null,29,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA26,AG26)","v":191.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA26*(1-W26)+0.004999,2)","v":191.8},null,"",191.8,{"$f":"+W26","v":0},{"$f":"+X26","v":191.8},{"$f":"(AG26-AC26)/AG26","v":0},null,4,{"$f":"SUM(AJ26:AL26)+AE26","v":191.8},null,null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":191.8},{"$f":"IF(VLOOKUP(AF26,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ26,1)-AJ26,2),Round,2,FALSE)+VLOOKUP(AF26,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF26,Group,7,FALSE)=\"\",0,ROUND(AJ26-0.04999,1)-AJ26+AM26)","v":0},{"$f":"IF(VLOOKUP(AF26,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF26,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Mats",null,null,"N1C012",null,12,null,1.2199999999999998,null,47,null,null,null,null,null,"Stock",null,199.95,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},199.95,null,"",199.95,0,199.95,0,null,4,199.95,null,null,199.95,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C015",null,15,null,1.4,null,57,null,null,null,null,null,"Stock",null,224.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},224.3,null,"",224.3,0,224.3,0,null,4,224.3,null,null,224.3,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C025",null,25,null,2.5399999999999996,null,98,null,null,null,null,null,"Stock",null,256.85000000000002,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},256.85000000000002,null,"",256.85000000000002,0,256.85000000000002,0,null,4,256.85000000000002,null,null,256.85000000000002,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C030",null,30,null,2.9,null,120,null,null,null,null,null,"Stock",null,273.05,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},273.05,null,"",273.05,0,273.05,0,null,4,273.05,null,null,273.05,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C040",null,40,null,3.7,null,148,null,null,null,null,null,"Stock",null,305.55,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},305.55,null,"",305.55,0,305.55,0,null,4,305.55,null,null,305.55,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C050",null,50,null,4.7,null,188,null,null,null,null,null,"Stock",null,338.05,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},338.05,null,"",338.05,0,338.05,0,null,4,338.05,null,null,338.05,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C060",null,60,null,6.01,null,234,null,null,null,null,null,"Stock",null,378.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},378.75,null,"",378.75,0,378.75,0,null,4,378.75,null,null,378.75,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C070",null,70,null,6.7,null,265,null,null,null,null,null,"Stock",null,402.1,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},402.1,null,"",402.1,0,402.1,0,null,4,402.1,null,null,402.1,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C080",null,80,null,7.9,null,318,null,null,null,null,null,"Stock",null,443.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},443.75,null,"",443.75,0,443.75,0,null,4,443.75,null,null,443.75,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C085",null,85,null,8.5,null,334,null,null,null,null,null,"Stock",null,460,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},460,null,"",460,0,460,0,null,4,460,null,null,460,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C095",null,95,null,9.6999999999999993,null,377,null,null,null,null,null,"Stock",null,492.5,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},492.5,null,"",492.5,0,492.5,0,null,4,492.5,null,null,492.5,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C110",null,110,null,10.8,null,423,null,null,null,null,null,"Stock",null,549.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},549.35,null,"",549.35,0,549.35,0,null,4,549.35,null,null,549.35,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N1C120",null,120,null,12.15,null,474,null,null,null,null,null,"Stock",null,575.54999999999995,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},575.54999999999995,null,"",575.54999999999995,0,575.54999999999995,0,null,4,575.54999999999995,null,null,575.54999999999995,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"240 Volt Cable Kits",null,null,"SQ/FT Range",null,"Amps",null,"Length (ft)",null,null,null,null,null,null,"Item # Lookup:","NUN2C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Mats",null,null,"N2C015",null,15,null,0.71,null,56,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA43,AG43)","v":217.6},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA43*(1-W43)+0.004999,2)","v":217.6},null,"",217.6,{"$f":"+W43","v":0},217.6,{"$f":"(AG43-AC43)/AG43","v":0},null,1,{"$f":"SUM(AJ43:AL43)+AE43","v":217.6},null,null,{"$f":"ROUND(AC43/(1-VLOOKUP(AF43,Group,2,FALSE)),2)","v":217.6},{"$f":"IF(VLOOKUP(AF43,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ43,1)-AJ43,2),Round,2,FALSE)+VLOOKUP(AF43,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF43,Group,7,FALSE)=\"\",0,ROUND(AJ43-0.04999,1)-AJ43+AM43)","v":0},{"$f":"IF(VLOOKUP(AF43,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF43,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Mats",null,null,"N2C020",null,20,null,0.9,null,80,null,null,null,null,null,null,null,232.45,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},232.45,null,"",232.45,0,232.45,{"$f":"(AG44-AC44)/AG44","v":0},null,4,{"$f":"SUM(AJ44:AL44)+AE44","v":232.45},null,null,{"$f":"ROUND(AC44/(1-VLOOKUP(AF44,Group,2,FALSE)),2)","v":232.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,"Mats",null,null,"N2C025",null,25,null,1.3050000000000004,null,102,null," ",null,null,null,null,null,267.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},267.75,null,"",267.75,0,267.75,{"$f":"(AG45-AC45)/AG45","v":0},null,1,{"$f":"SUM(AJ45:AL45)+AE45","v":267.75},null,null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":267.75},{"$f":"IF(VLOOKUP(AF45,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ45,1)-AJ45,2),Round,2,FALSE)+VLOOKUP(AF45,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF45,Group,7,FALSE)=\"\",0,ROUND(AJ45-0.04999,1)-AJ45+AM45)","v":0},{"$f":"IF(VLOOKUP(AF45,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF45,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Mats",null,null,"N2C035",null,35,null,1.7,null,136,null,null,null,null,null,null,null,297.45,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},297.45,null,"",297.45,0,297.45,{"$f":"(AG46-AC46)/AG46","v":0},null,4,{"$f":"SUM(AJ46:AL46)+AE46","v":297.45},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":297.45},{"$f":"IF(VLOOKUP(AF46,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ46,1)-AJ46,2),Round,2,FALSE)+VLOOKUP(AF46,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",0,ROUND(AJ46-0.04999,1)-AJ46+AM46)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF46,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"N2C045",null,45,null,2.2000000000000002,null,178,null,null,null,null,null,null,null,336.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},336.75,null,"",336.75,0,336.75,{"$f":"(AG47-AC47)/AG47","v":0},null,1,{"$f":"SUM(AJ47:AL47)+AE47","v":336.75},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":336.75},{"$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,"Stocked Mats",null,null,"N2C055",null,55,null,2.6,null,207,null,null,null,null,null,null,null,346.2,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},346.2,null,"",346.2,{"$f":"+W48","v":0},346.2,{"$f":"(AG48-AC48)/AG48","v":0},null,4,{"$f":"SUM(AJ48:AL48)+AE48","v":346.2},null,null,{"$f":"ROUND(AC48/(1-VLOOKUP(AF48,Group,2,FALSE)),2)","v":346.2},{"$f":"IF(VLOOKUP(AF48,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ48,1)-AJ48,2),Round,2,FALSE)+VLOOKUP(AF48,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF48,Group,7,FALSE)=\"\",0,ROUND(AJ48-0.04999,1)-AJ48+AM48)","v":0},{"$f":"IF(VLOOKUP(AF48,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF48,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"N2C065",null,65,null,3.1,null,250,null,null,null,null,null,null,null,393.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},393.35,null,"",393.35,0,393.35,0,null,1,393.35,null,null,393.35,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N2C070",null,70,null,3.5,null,277,null," ",null,null,null,"Stock",null,403.15,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},403.15,null,"",403.15,0,403.15,0,null,4,403.15,null,null,403.15,0,0,"",null,"X"]
[null,"Mats",null,null,"N2C085",null,85,null,4.3,null,334.09359917117871,null,null,null,null,null,null,null,454.4,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},454.4,null,"",454.4,0,454.4,0,null,1,454.4,null,null,454.4,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N2C090",null,90,null,4.625,null,358,null,null,null,null,null,"Stock",null,473.2,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},473.2,null,"",473.2,0,473.2,0,null,4,473.2,null,null,473.2,0,0,"",null,"X"]
[null,"Mats",null,null,"N2C100",null,100,null,5,null,393.03544608572611,null,null,null,null,null,null,null,511.2,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},511.2,null,"",511.2,0,511.2,0,null,1,511.2,null,null,511.2,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N2C120",null,120,null,5.9,null,472,null,null,null,null,null,"Stock",null,575.4,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},575.4,null,"",575.4,0,575.4,0,null,4,575.4,null,null,575.4,0,0,"",null,"X"]
[null,"Mats",null,null,"N2C135",null,135,null,6.8,null,529,null,null,null,null,null,null,null,600.5,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},600.5,null,"",600.5,0,600.5,0,null,1,600.5,null,null,600.5,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N2C145",null,145,null,7.1,null,561,null,null,null,null,null,"Stock",null,630.70000000000005,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},630.70000000000005,null,"",630.70000000000005,{"$f":"+W56","v":0},{"$f":"+X56","v":630.70000000000005},0,null,4,630.70000000000005,null,null,630.70000000000005,0,0,"",null,"X"]
[null,"Mats",null,null,"N2C160",null,160,null,8,null,630,null,null,null," ",null,null,null,673.5,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},673.5,null,"",673.5,0,673.5,0,null,1,673.5,null,null,673.5,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N2C170",null,170,null,8.6,null,664.59197866400359,null,null,null,null,null,"Stock",null,687.65,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},687.65,null,"",687.65,0,687.65,0,null,4,687.65,null,null,687.65,0,0,"",null,"X"]
[null,"Mats",null,null,"N2C190",null,190,null,9.6,null,757,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA59,AG59)","v":787.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},787.15,null,"",787.15,0,787.15,0,null,1,787.15,null,null,787.15,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N2C215",null,215,null,10.8,null,849,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA60,'Price List'!AG60)","v":833.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},833.95,null,"",833.95,0,833.95,0,null,4,833.95,null,null,833.95,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"N2C240",null,240,null,12.1,null,953.05290870449187,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA61,'Price List'!AG61)","v":931.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},931.45,null,"",931.45,0,931.45,0,null,4,931.45,null,null,931.45,0,0,"",null,"X"]
[]
[null,null,null,"Cable Kit 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,null,null,null,"X"]
[null,"Misc.",null,null,"AC0040",null,"Cable Repair Kit",null,null,null,null,null,null,null,null,null,null,"a",{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":37.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":37.15},null,"",37.15,{"$f":"+W65","v":0},{"$f":"+X65","v":37.15},{"$f":"(AG65-AC65)/AG65","v":0},null,3,{"$f":"SUM(AJ65:AL65)+AE65","v":37.15},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":37.15},{"$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,null,"Notes:","Can be used in showers & sauna's.  Lead Wire cannot be extended on Cable Kits.  (11 LF Lead Wire in Kits)"]
[null,null,null,null,"Energy Efficient only 12 Watts per Square Foot.  (same as Nuheat Mats)  Can be used with 120V or 240V systems."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"CONTROLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","NU",null,null,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,"Stocked Thermostats",null,null,"120V or 240V",null,"AC0057",null,"ELEMENT Non-Programmable Dual Voltage Thermostat",null,null,null,null,null,null,null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",AA72,AG72)","v":128.80000000000001},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA72*(1-W72)+0.004999,2)","v":128.80000000000001},null,"",128.80000000000001,{"$f":"+W72","v":0},128.80000000000001,{"$f":"(AG72-AC72)/AG72","v":0},null,5,{"$f":"SUM(AJ72:AL72)+AE72","v":128.80000000000001},null,null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":128.80000000000001},{"$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,"Stocked Thermostats",null,null,"120V or 240V",null,"AC0056",null,"HOME Programmable Dual Voltage Touchscreen Thermostat",null,null,null,null,null,null,null,"Stock","b",207.5,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA73*(1-W73)+0.004999,2)","v":207.5},null,"",207.5,0,207.5,{"$f":"(AG73-AC73)/AG73","v":0},null,5,{"$f":"SUM(AJ73:AL73)+AE73","v":207.5},null,null,{"$f":"ROUND(AC73/(1-VLOOKUP(AF73,Group,2,FALSE)),2)","v":207.5},{"$f":"IF(VLOOKUP(AF73,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ73,1)-AJ73,2),Round,2,FALSE)+VLOOKUP(AF73,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF73,Group,7,FALSE)=\"\",0,ROUND(AJ73-0.04999,1)-AJ73+AM73)","v":0},{"$f":"IF(VLOOKUP(AF73,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF73,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Thermostats",null,null,"120V or 240V",null,"AC0055",null,"SIGNATURE WiFi enabled Programmable Dual Voltage Thermostat",null,null,null,null,null,null,null,"Stock",null,263.89999999999998,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA74*(1-W74)+0.004999,2)","v":263.89999999999998},null,"",263.89999999999998,0,263.89999999999998,{"$f":"(AG74-AC74)/AG74","v":0},null,5,{"$f":"SUM(AJ74:AL74)+AE74","v":263.89999999999998},null,null,{"$f":"ROUND(AC74/(1-VLOOKUP(AF74,Group,2,FALSE)),2)","v":263.89999999999998},{"$f":"IF(VLOOKUP(AF74,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ74,1)-AJ74,2),Round,2,FALSE)+VLOOKUP(AF74,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",0,ROUND(AJ74-0.04999,1)-AJ74+AM74)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF74,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,"X"]
[null,"Stocked Misc.",null,null,"120 Volt",null,"AC0016",null,"Lead Wire Repair Kit",null,null,null,null,null,null,null,null,"c",95.6,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":95.6},null,"",95.6,{"$f":"+W76","v":0},95.6,{"$f":"(AG76-AC76)/AG76","v":0},null,6,{"$f":"SUM(AJ76:AL76)+AE76","v":95.6},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":95.6},{"$f":"IF(VLOOKUP(AF76,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ76,1)-AJ76,2),Round,2,FALSE)+VLOOKUP(AF76,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",0,ROUND(AJ76-0.04999,1)-AJ76+AM76)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF76,Group,7,FALSE))","v":""},null,"X"]
[null,"Misc.",null,null,"120 Volt",null,"AC0006",null,"Relay 120V Input & Load Relay 25 Amps",null,null,null,null,null,null,null,null,null,72.95,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":72.95},null,"",72.95,{"$f":"+W77","v":0},{"$f":"+X77","v":72.95},{"$f":"(AG77-AC77)/AG77","v":0},null,3,{"$f":"SUM(AJ77:AL77)+AE77","v":72.95},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":72.95},{"$f":"IF(VLOOKUP(AF77,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ77,1)-AJ77,2),Round,2,FALSE)+VLOOKUP(AF77,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",0,ROUND(AJ77-0.04999,1)-AJ77+AM77)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF77,Group,7,FALSE))","v":""},null,"X"]
[null,"Misc.",null,null,"120 Volt",null,"AC0012",null,"Extra Lead Length",null,null,null,null,null,null,null,null,"d",8.85,"LF",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":8.85},null,"",8.85,0,8.85,{"$f":"(AG78-AC78)/AG78","v":0},null,3,{"$f":"SUM(AJ78:AL78)+AE78","v":8.85},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":8.85},{"$f":"IF(VLOOKUP(AF78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ78,1)-AJ78,2),Round,2,FALSE)+VLOOKUP(AF78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",0,ROUND(AJ78-0.04999,1)-AJ78+AM78)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF78,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Stocked Misc.",null,null,"240 Volt",null,"AC0017",null,"Lead Wire Repair Kit",null,null,null,null,null,null,null,null,"c",95.6,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA80*(1-W80)+0.004999,2)","v":95.6},null,"",95.6,{"$f":"+W80","v":0},95.6,{"$f":"(AG80-AC80)/AG80","v":0},null,6,{"$f":"SUM(AJ80:AL80)+AE80","v":95.6},null,null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":95.6},{"$f":"IF(VLOOKUP(AF80,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ80,1)-AJ80,2),Round,2,FALSE)+VLOOKUP(AF80,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",0,ROUND(AJ80-0.04999,1)-AJ80+AM80)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF80,Group,7,FALSE))","v":""},null,"X"]
[null,"Misc.",null,null,"240 Volt",null,"AC0007",null,"Relay 240V Input & Load Relay 25 Amps",null,null,null,null,null,null,null,null,null,72.95,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA81*(1-W81)+0.004999,2)","v":72.95},null,"",72.95,0,72.95,{"$f":"(AG81-AC81)/AG81","v":0},null,3,{"$f":"SUM(AJ81:AL81)+AE81","v":72.95},null,null,{"$f":"ROUND(AC81/(1-VLOOKUP(AF81,Group,2,FALSE)),2)","v":72.95},{"$f":"IF(VLOOKUP(AF81,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ81,1)-AJ81,2),Round,2,FALSE)+VLOOKUP(AF81,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF81,Group,7,FALSE)=\"\",0,ROUND(AJ81-0.04999,1)-AJ81+AM81)","v":0},{"$f":"IF(VLOOKUP(AF81,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF81,Group,7,FALSE))","v":""},null,"X"]
[null,"Misc."," "," ","240 Volt",null,"AC0013",null,"Extra Lead Length",null,null,null,null,null,null,null,null,"d",8.85,"LF",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},8.85,null,"",8.85,0,8.85,{"$f":"(AG82-AC82)/AG82","v":0},null,3,{"$f":"SUM(AJ82:AL82)+AE82","v":8.85},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":8.85},{"$f":"IF(VLOOKUP(AF82,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ82,1)-AJ82,2),Round,2,FALSE)+VLOOKUP(AF82,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",0,ROUND(AJ82-0.04999,1)-AJ82+AM82)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF82,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Misc.",null,null,null,null,"AC0014",null,"Heating Wire Repair Kit",null,null,null,null,null,null,null,null,"e",31.15,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},31.15,null,"",31.15,{"$f":"+W84","v":0},31.15,{"$f":"(AG84-AC84)/AG84","v":0},null,3,{"$f":"SUM(AJ84:AL84)+AE84","v":31.15},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":31.15},{"$f":"IF(VLOOKUP(AF84,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ84,1)-AJ84,2),Round,2,FALSE)+VLOOKUP(AF84,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",0,ROUND(AJ84-0.04999,1)-AJ84+AM84)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF84,Group,7,FALSE))","v":""},null,"X"]
[null,"Misc.",null,null,null,null,"AC0100",null,"MatSense Pro Electric Fault Indicator",null,null,null,null,"Discontinued 5/17/22",null,null,"Stock",null,25.2,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},25.2,null,"",25.2,0,25.2,{"$f":"(AG85-AC85)/AG85","v":0},null,3,{"$f":"SUM(AJ85:AL85)+AE85","v":25.2},null,null,{"$f":"ROUND(AC85/(1-VLOOKUP(AF85,Group,2,FALSE)),2)","v":25.2},{"$f":"IF(VLOOKUP(AF85,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ85,1)-AJ85,2),Round,2,FALSE)+VLOOKUP(AF85,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",0,ROUND(AJ85-0.04999,1)-AJ85+AM85)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF85,Group,7,FALSE))","v":""},null,"X"]
[null,"Misc.",null,null,null,null,"AC0200",null,"Install Pro Alarm Fault Indicator",null,null,null,null,null,null,null,"Stock",null,27.6,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},27.6,null,"new",27.6,0,27.6,{"$f":"(AG86-AC86)/AG86","v":0},null,3,{"$f":"SUM(AJ86:AL86)+AE86","v":27.6},null,null,{"$f":"ROUND(AC86/(1-VLOOKUP(AF86,Group,2,FALSE)),2)","v":27.6},{"$f":"IF(VLOOKUP(AF86,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ86,1)-AJ86,2),Round,2,FALSE)+VLOOKUP(AF86,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",0,ROUND(AJ86-0.04999,1)-AJ86+AM86)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF86,Group,7,FALSE))","v":""},null,"X"]
[null,"Misc.",null," ",null,null,"AC0008",null,"Floor Sensing Probe",null,null,null,null,null,null,null,null,"f",29.95,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},29.95,null,"",29.95,0,29.95,{"$f":"(AG87-AC87)/AG87","v":0},null,3,{"$f":"SUM(AJ87:AL87)+AE87","v":29.95},null,null,{"$f":"ROUND(AC87/(1-VLOOKUP(AF87,Group,2,FALSE)),2)","v":29.95},{"$f":"IF(VLOOKUP(AF87,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ87,1)-AJ87,2),Round,2,FALSE)+VLOOKUP(AF87,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF87,Group,7,FALSE)=\"\",0,ROUND(AJ87-0.04999,1)-AJ87+AM87)","v":0},{"$f":"IF(VLOOKUP(AF87,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF87,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,"X"]
[null,null,null,"Notes:","a) Dual voltage compatibility suitable for tile/stone, laminate and engineered wood floors."]
[null,null,null,null,"b) Dual voltage compatibility, for tile and stone with a temperature limiting (82°F) feature for laminate and engineered wood floors."]
[null,null,null,null,"c) Contains 10 LF of lead wire for 120V or 240V.",null,null,null,null,"d) Can be added to standard mats at the factory, up to 22 feet.  Available only in 2 LF increments."]
[null,null,null,null,"e) For on-site repair of damaged mats.",null,null,null,null,"f) Allows tile completion if thermostat is backordered."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"MEMBRANE - Uncoupling & Integrated Floor Heating Underlayment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","NUME, NUPR",null,null,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,"Stocked Heat Mats",null,null,"NUMEM054",null,"Nuheat Membrane - Small Roll ",null,null,null,"3' 3\" x 16.50'",null,null,"(54 SF Coverage)",null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA96,AG96)","v":121.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA96*(1-W96)+0.004999,2)","v":121.1},null,"",121.1,{"$f":"+W96","v":0},121.1,{"$f":"(AG96-AC96)/AG96","v":0},null,7,{"$f":"SUM(AJ96:AL96)+AE96","v":121.1},null,null,{"$f":"ROUND(AC96/(1-VLOOKUP(AF96,Group,2,FALSE)),2)","v":121.1},{"$f":"IF(VLOOKUP(AF96,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ96,1)-AJ96,2),Round,2,FALSE)+VLOOKUP(AF96,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",0,ROUND(AJ96-0.04999,1)-AJ96+AM96)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF96,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Heat Mats",null,null,"NUMEM161",null,"Nuheat Membrane - Large Roll",null,null,null,"3' 3\" x 49.50'",null,null,"(161 SF Coverage)",null,null,"Stock",null,339.05,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA97*(1-W97)+0.004999,2)","v":339.05},null,"",339.05,0,339.05,{"$f":"(AG97-AC97)/AG97","v":0},null,7,{"$f":"SUM(AJ97:AL97)+AE97","v":339.05},null,null,{"$f":"ROUND(AC97/(1-VLOOKUP(AF97,Group,2,FALSE)),2)","v":339.05},{"$f":"IF(VLOOKUP(AF97,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ97,1)-AJ97,2),Round,2,FALSE)+VLOOKUP(AF97,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",0,ROUND(AJ97-0.04999,1)-AJ97+AM97)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF97,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Heat Mats",null,null,"NUMEM250",null,"Nuheat Membrane Sheet",null,null,null,"3' 3\" x 3' 3\"",null,null,"(10 SF/Sheet Coverage)",null,null,"Stock",null,21.7,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA98*(1-W98)+0.004999,2)","v":21.7},null,"",21.7,0,21.7,{"$f":"(AG98-AC98)/AG98","v":0},null,7,{"$f":"SUM(AJ98:AL98)+AE98","v":21.7},null,null,{"$f":"ROUND(AC98/(1-VLOOKUP(AF98,Group,2,FALSE)),2)","v":21.7},{"$f":"IF(VLOOKUP(AF98,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ98,1)-AJ98,2),Round,2,FALSE)+VLOOKUP(AF98,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",0,ROUND(AJ98-0.04999,1)-AJ98+AM98)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF98,Group,7,FALSE))","v":""},null,"X"]
[null,"Misc.",null,null,"NUMEM250PS",null,"Peel & Stick Membrane Sheet",null,null,null,"3' 3\" x 3' 3\"",null,null,"(10 SF/Sheet Coverage)",null,"25 Sheets/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA99,AG99)","v":29.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA99*(1-W99)+0.004999,2)","v":29.75},null,"",29.75,{"$f":"+W99","v":0},{"$f":"+X99","v":29.75},{"$f":"(AG99-AC99)/AG99","v":0},null,3,{"$f":"SUM(AJ99:AL99)+AE99","v":29.75},null,null,{"$f":"ROUND(AC99/(1-VLOOKUP(AF99,Group,2,FALSE)),2)","v":29.75},{"$f":"IF(VLOOKUP(AF99,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ99,1)-AJ99,2),Round,2,FALSE)+VLOOKUP(AF99,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,7,FALSE)=\"\",0,ROUND(AJ99-0.04999,1)-AJ99+AM99)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF99,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,"X","X"]
[null,"Misc.",null,null,"PRBPE 1505",null,"Waterproofing Seam Tape",null,null,null,"6\" x 16'",null,null,null,null,null,null,null,26.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA101*(1-W101)+0.004999,2)","v":26.75},null,"",26.75,{"$f":"+W101","v":0},{"$f":"+X101","v":26.75},{"$f":"(AG101-AC101)/AG101","v":0},null,3,{"$f":"SUM(AJ101:AL101)+AE101","v":26.75},null,null,{"$f":"ROUND(AC101/(1-VLOOKUP(AF101,Group,2,FALSE)),2)","v":26.75},{"$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,"Misc.",null,null,"PRBPE 1530",null,"Waterproofing Seam Tape ",null,null,null,"6\" x 98'",null,null,null,null,null,null,null,120.6,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA102*(1-W102)+0.004999,2)","v":120.6},null,"",120.6,{"$f":"+W102","v":0},{"$f":"+X102","v":120.6},{"$f":"(AG102-AC102)/AG102","v":0},null,3,{"$f":"SUM(AJ102:AL102)+AE102","v":120.6},null,null,{"$f":"ROUND(AC102/(1-VLOOKUP(AF102,Group,2,FALSE)),2)","v":120.6},{"$f":"IF(VLOOKUP(AF102,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ102,1)-AJ102,2),Round,2,FALSE)+VLOOKUP(AF102,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",0,ROUND(AJ102-0.04999,1)-AJ102+AM102)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF102,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,"NUHEAT CABLE to NUHEAT MEMBRANE PILLAR COVERAGE CHART",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"120 Volt Cable Kits",null,null,"Coverage (Square Feet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"3 Pillars",null,"2/3/2 Pillars",null,"2 Pillars"]
[null,null,null,null,null,null,"10 Watts/SF",null,"12 Watts/SF",null,"15 Watts/SF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C008",null,9,null,8,null,6]
[null,null,null,null,"N1C012",null,14,null,12,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C015",null,17,null,15,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C025",null,30,null,25,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null," ","N1C030",null,36,null,31,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C040",null,45,null,38,null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C050",null,57,null,48,null,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C060",null,71,null,60,null,49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C070",null,81,null,68,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null," ","N1C080",null,97,null,82,null,66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C085",null,102,null,86,null,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C095",null,115,null,97,null,78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C110",null,129,null,109,null,88,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N1C120",null,145,null,122,null,98,null,null,null,null,null,null,null,null,null,null,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,"240 Volt Cable Kits",null,null,"Coverage (Square Feet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"3 Pillars",null,"2/3/2 Pillars",null,"2 Pillars"]
[null,null,null,null,null,null,"10 Watts/SF",null,"12 Watts/SF",null,"15 Watts/SF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C015",null,17,null,14,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C020",null,24,null,21,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C025",null,31,null,26,null,21]
[null,null,null,null,"N2C035",null,41,null,35,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C045",null,54,null,46,null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C055",null,63,null,53,null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null," ","N2C065",null,76,null,64,null,52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C070",null,84,null,71,null,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C085",null,102,null,86,null,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C090",null,109,null,92,null,74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C100",null,120,null,101,null,82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null," ","N2C120",null,145,null,121,null,98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C135",null,162,null,136,null,110,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C145",null,172,null,144,null,116,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C160",null,193,null,162,null,131,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C170",null,204,null,171,null,138,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C190",null,233,null,195,null,157,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C215",null,261,null,219,null,176,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"N2C240",null,293,null,246,null,198]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"MESH - Floor Heating System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"120 Volt Cable Kits",null,null,"SQ/FT Range*",null,"Amps",null,"Dimensions",null,"Power Output (Watts)",null,null,null,null,"Item # Lookup:","NUN1M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Mats",null,null,"N1M012",null,12,null,1.2,null,"20\" x 8'",null,139,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA155,AG155)","v":201.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA155*(1-W155)+0.004999,2)","v":201.15},null,"",201.15,{"$f":"+W155","v":0},{"$f":"+X155","v":201.15},{"$f":"(AG155-AC155)/AG155","v":0},null,1,{"$f":"SUM(AJ155:AL155)+AE155","v":201.15},null,null,{"$f":"ROUND(AC155/(1-VLOOKUP(AF155,Group,2,FALSE)),2)","v":201.15},{"$f":"IF(VLOOKUP(AF155,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ155,1)-AJ155,2),Round,2,FALSE)+VLOOKUP(AF155,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF155,Group,7,FALSE)=\"\",0,ROUND(AJ155-0.04999,1)-AJ155+AM155)","v":0},{"$f":"IF(VLOOKUP(AF155,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF155,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"N1M015",null,15,null,1.4,null,"20\" x 9'",null,170,null,null,null,null,null,220.5,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},220.5,null,"",220.5,0,220.5,0,null,1,220.5,null,null,220.5,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M025",null,25,null,2.5,null,"20\" x 15'",null,300,null,null,null,null,null,278.39999999999998,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},278.39999999999998,null,"",278.39999999999998,0,278.39999999999998,0,null,1,278.39999999999998,null,null,278.39999999999998,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M030",null,30,null,2.9,null,"20\" x 19'",null,344,null,null,null,null,null,317.05,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},317.05,null,"",317.05,0,317.05,0,null,1,317.05,null,null,317.05,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M040",null,40,null,3.7,null,"20\" x 23'",null,442,null,null,null,null,null,394.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},394.3,null,"",394.3,0,394.3,0,null,1,394.3,null,null,394.3,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M050",null,50,null,4.7,null,"20\" x 29'",null,563,null,null,null,null,null,461.9,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},461.9,null,"",461.9,0,461.9,0,null,1,461.9,null,null,461.9,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M060",null,60,null,6,null,"20\" x 36'",null,720,null,null,null,null,null,544.9,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},544.9,null,"",544.9,0,544.9,0,null,1,544.9,null,null,544.9,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M070",null,70,null,6.7,null,"20\" x 41'",null,809,null,null,null,null,null,598.1,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},598.1,null,"",598.1,0,598.1,0,null,1,598.1,null,null,598.1,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M080",null,80,null,7.9,null,"20\" x 49'",null,947,null,null,null,null,null,672.85,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},672.85,null,"",672.85,0,672.85,0,null,1,672.85,null,null,672.85,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M085",null,85,null,8.5,null,"20\" x 52'",null,1022,null,null,null,null,null,698.05,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},698.05,null,"",698.05,0,698.05,0,null,1,698.05,null,null,698.05,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M095",null,95,null,9.6999999999999993,null,"20\" x 58'",null,1161,null,null,null,null,null,745.85,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},745.85,null,"",745.85,0,745.85,0,null,1,745.85,null,null,745.85,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M110",null,110,null,10.8,null,"20\" x 65'",null,1299,null,null,null,null,null,931.8,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},931.8,null,"",931.8,0,931.8,0,null,1,931.8,null,null,931.8,0,0,"",null,"X"]
[null,"Mats",null,null,"N1M120",null,120,null,12.2,null,"20\" x 73'",null,1461,null,null,null,null,null,1006.55,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1006.55,null,"",1006.55,0,1006.55,0,null,1,1006.55,null,null,1006.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,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,"MESH - Floor Heating System - continued",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"240 Volt Cable Kits",null,null,"SQ/FT Range*",null,"Amps",null,"Dimensions",null,"Power Output (Watts)",null,null,null,null,"Item # Lookup:","NUN2M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Mats",null,null,"N2M015",null,15,null,0.7,null,"20\" x 9'",null,165,null,null,"Discontinued 12/5/22",null,null,{"$f":"IF(Suggested=\"Yes\",AA174,AG174)","v":220.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA174*(1-W174)+0.004999,2)","v":220.5},null,"",220.5,{"$f":"+W174","v":0},{"$f":"+X174","v":220.5},{"$f":"(AG174-AC174)/AG174","v":0},null,1,{"$f":"SUM(AJ174:AL174)+AE174","v":220.5},null,null,{"$f":"ROUND(AC174/(1-VLOOKUP(AF174,Group,2,FALSE)),2)","v":220.5},{"$f":"IF(VLOOKUP(AF174,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ174,1)-AJ174,2),Round,2,FALSE)+VLOOKUP(AF174,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF174,Group,7,FALSE)=\"\",0,ROUND(AJ174-0.04999,1)-AJ174+AM174)","v":0},{"$f":"IF(VLOOKUP(AF174,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF174,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"N2M020",null,20,null,0.9,null,"20\" x13'",null,224,null,null,"Discontinued 12/5/22",null,null,249.45,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},249.45,null,"",249.45,0,249.45,0,null,1,249.45,null,null,249.45,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M025",null,25,null,1.3,null,"20\" x 16'",null,302,null,null,"Discontinued 12/5/22",null,null,278.39999999999998,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},278.39999999999998,null,"",278.39999999999998,0,278.39999999999998,0,null,1,278.39999999999998,null,null,278.39999999999998,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M035",null,35,null,1.7,null,"20\" x 21'",null,403,null,null,"Discontinued 12/5/22",null,null,367,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},367,null,"",367,0,367,0,null,1,367,null,null,367,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M045",null,45,null,2.2000000000000002,null,"20\" x 28'",null,523,null,null,"Discontinued 12/5/22",null,null,442.55,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},442.55,null,"",442.55,0,442.55,0,null,1,442.55,null,null,442.55,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M055",null,55,null,2.6,null,"20\" x 32'",null,632,null,null,"Discontinued 12/5/22",null,null,502.45,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},502.45,null,"",502.45,0,502.45,0,null,1,502.45,null,null,502.45,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M065",null,65,null,3.1,null,"20\" x 39'",null,742,null,null,"Discontinued 12/5/22",null,null,585.95000000000005,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},585.95000000000005,null,"",585.95000000000005,0,585.95000000000005,0,null,1,585.95000000000005,null,null,585.95000000000005,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M070",null,70,null,3.5,null,"20\" x 43'",null,842,null,null,"Discontinued 12/5/22",null,null,598.1,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},598.1,null,"",598.1,0,598.1,0,null,1,598.1,null,null,598.1,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M085",null,85,null,4.3,null,"20\" x 52'",null,1020,null,null,"Discontinued 12/5/22",null,null,698.05,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},698.05,null,"",698.05,0,698.05,0,null,1,698.05,null,null,698.05,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M090",null,90,null,4.5999999999999996,null,"20\" x 55'",null,1102,null,null,"Discontinued 12/5/22",null,null,722.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},722.35,null,"",722.35,0,722.35,0,null,1,722.35,null,null,722.35,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M100",null,100,null,5,null,"20\" x 61'",null,1211,null,null,"Discontinued 12/5/22",null,null,769.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},769.3,null,"",769.3,0,769.3,0,null,1,769.3,null,null,769.3,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M120",null,120,null,5.9,null,"20\" x 73'",null,1427,null,null,"Discontinued 12/5/22",null,null,1006.55,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1006.55,null,"",1006.55,0,1006.55,0,null,1,1006.55,null,null,1006.55,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M135",null,135,null,6.8,null,"20\" x 82'",null,1621,null,null,"Discontinued 12/5/22",null,null,1103.05,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1103.05,null,"",1103.05,0,1103.05,0,null,1,1103.05,null,null,1103.05,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M145",null,145,null,7.1,null,"20\" x 87'",null,1704,null,null,"Discontinued 12/5/22",null,null,1213.4000000000001,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1213.4000000000001,null,"",1213.4000000000001,{"$f":"+W187","v":0},{"$f":"+X187","v":1213.4000000000001},{"$f":"(AG187-AC187)/AG187","v":0},null,1,{"$f":"SUM(AJ187:AL187)+AE187","v":1213.4000000000001},null,null,{"$f":"ROUND(AC187/(1-VLOOKUP(AF187,Group,2,FALSE)),2)","v":1213.4000000000001},{"$f":"IF(VLOOKUP(AF187,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ187,1)-AJ187,2),Round,2,FALSE)+VLOOKUP(AF187,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",0,ROUND(AJ187-0.04999,1)-AJ187+AM187)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF187,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"N2M160",null,160,null,8,null,"20\" x 97'",null,1914,null,null,"Discontinued 12/5/22",null,null,1312.45,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1312.45,null,"",1312.45,0,1312.45,0,null,1,1312.45,null,null,1312.45,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M170",null,170,null,8.6,null,"20\" x 102'",null,2054,null,null,"Discontinued 12/5/22",null,null,1384.6,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1384.6,null,"",1384.6,0,1384.6,0,null,1,1384.6,null,null,1384.6,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M190",null,190,null,9.6,null,"20\" x 117'",null,2314,null,null,"Discontinued 12/5/22",null,null,1530.55,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1530.55,null,"",1530.55,0,1530.55,0,null,1,1530.55,null,null,1530.55,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M215",null,215,null,10.8,null,"20\" x 131'",null,2589,null,null,"Discontinued 12/5/22",null,null,1731.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1731.3,null,"",1731.3,0,1731.3,0,null,1,1731.3,null,null,1731.3,0,0,"",null,"X"]
[null,"Mats",null,null,"N2M240",null,240,null,12.1,null,"20\" x 147'",null,2905,null,null,"Discontinued 12/5/22",null,null,1931.2,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1931.2,null,"",1931.2,0,1931.2,0,null,1,1931.2,null,null,1931.2,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Note:","* Square foot coverage based on square room with 2\" unheated border."]
[]
[null,null,"CUSTOM MATS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Contact Customer Service for a custom mat configuration (controls would not be included)."]
[null,null,null,"Accurate drawings and measurements would be needed to receive a quote."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Nuheat Mats can now be used in Wet areas and can also be used as a heating alternative.  All Standard Mats have 10 feet of lead wire.  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Areas not heated:",null,"Kitchen Cabinets/Appliances - 2 SF for every foot in length",null,null,null,null,null,null,null,null,"Toilet - 5 SF"]
[null,null,null,null,null,"Bathroom Cabinets/Vanity - 1-1/2 SF for every foot in length",null,null,null,null,null,null,null,null,"Forced Air Duct - 1 SF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"120 VOLT STANDARD MATS",null,null,null,null,null,"Amps",null,null," "," ",null,null,null,null,"Item # Lookup:","NUF",null,null,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,"Stocked Mats",null,null,"40\" x 27\"",null,"F1006",null,0.8,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA208,AG208)","v":213.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA208*(1-W208)+0.004999,2)","v":213.9},null,"",213.9,{"$f":"+W208","v":0},213.9,{"$f":"(AG208-AC208)/AG208","v":0},null,4,{"$f":"SUM(AJ208:AL208)+AE208","v":213.9},null,null,{"$f":"ROUND(AC208/(1-VLOOKUP(AF208,Group,2,FALSE)),2)","v":213.9},{"$f":"IF(VLOOKUP(AF208,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ208,1)-AJ208,2),Round,2,FALSE)+VLOOKUP(AF208,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF208,Group,7,FALSE)=\"\",0,ROUND(AJ208-0.04999,1)-AJ208+AM208)","v":0},{"$f":"IF(VLOOKUP(AF208,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF208,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Mats",null,null,"40\" x 32\"",null,"F1008",null,0.9,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA209,AG209)","v":231.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA209*(1-W209)+0.004999,2)","v":231.85},null,"",231.85,0,231.85,{"$f":"(AG209-AC209)/AG209","v":0},null,4,{"$f":"SUM(AJ209:AL209)+AE209","v":231.85},null,null,{"$f":"ROUND(AC209/(1-VLOOKUP(AF209,Group,2,FALSE)),2)","v":231.85},{"$f":"IF(VLOOKUP(AF209,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ209,1)-AJ209,2),Round,2,FALSE)+VLOOKUP(AF209,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,7,FALSE)=\"\",0,ROUND(AJ209-0.04999,1)-AJ209+AM209)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF209,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Mats",null,null,"40\" x 40\"",null,"F1010",null,1.1000000000000001,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA210,AG210)","v":248.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA210*(1-W210)+0.004999,2)","v":248.4},null,"",248.4,0,248.4,{"$f":"(AG210-AC210)/AG210","v":0},null,4,{"$f":"SUM(AJ210:AL210)+AE210","v":248.4},null,null,{"$f":"ROUND(AC210/(1-VLOOKUP(AF210,Group,2,FALSE)),2)","v":248.4},{"$f":"IF(VLOOKUP(AF210,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ210,1)-AJ210,2),Round,2,FALSE)+VLOOKUP(AF210,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF210,Group,7,FALSE)=\"\",0,ROUND(AJ210-0.04999,1)-AJ210+AM210)","v":0},{"$f":"IF(VLOOKUP(AF210,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF210,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Mats",null,null,"40\" x 48\"",null,"F1012",null,1.3,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA211,AG211)","v":260.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA211*(1-W211)+0.004999,2)","v":260.5},null,"",260.5,0,260.5,{"$f":"(AG211-AC211)/AG211","v":0},null,4,{"$f":"SUM(AJ211:AL211)+AE211","v":260.5},null,null,{"$f":"ROUND(AC211/(1-VLOOKUP(AF211,Group,2,FALSE)),2)","v":260.5},{"$f":"IF(VLOOKUP(AF211,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ211,1)-AJ211,2),Round,2,FALSE)+VLOOKUP(AF211,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF211,Group,7,FALSE)=\"\",0,ROUND(AJ211-0.04999,1)-AJ211+AM211)","v":0},{"$f":"IF(VLOOKUP(AF211,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF211,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Mats",null,null,"48\" x 24\"",null,"F1206",null,0.8,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA213,AG213)","v":221.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA213*(1-W213)+0.004999,2)","v":221.15},null,"",221.15,{"$f":"+W213","v":0},221.15,{"$f":"(AG213-AC213)/AG213","v":0},null,1,{"$f":"SUM(AJ213:AL213)+AE213","v":221.15},null,null,{"$f":"ROUND(AC213/(1-VLOOKUP(AF213,Group,2,FALSE)),2)","v":221.15},{"$f":"IF(VLOOKUP(AF213,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ213,1)-AJ213,2),Round,2,FALSE)+VLOOKUP(AF213,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF213,Group,7,FALSE)=\"\",0,ROUND(AJ213-0.04999,1)-AJ213+AM213)","v":0},{"$f":"IF(VLOOKUP(AF213,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF213,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Mats",null,null,"48\" x 30\"",null,"F1208",null,1,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA214,AG214)","v":242.2},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA214*(1-W214)+0.004999,2)","v":242.2},null,"",242.2,0,242.2,{"$f":"(AG214-AC214)/AG214","v":0},null,4,{"$f":"SUM(AJ214:AL214)+AE214","v":242.2},null,null,{"$f":"ROUND(AC214/(1-VLOOKUP(AF214,Group,2,FALSE)),2)","v":242.2},{"$f":"IF(VLOOKUP(AF214,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ214,1)-AJ214,2),Round,2,FALSE)+VLOOKUP(AF214,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF214,Group,7,FALSE)=\"\",0,ROUND(AJ214-0.04999,1)-AJ214+AM214)","v":0},{"$f":"IF(VLOOKUP(AF214,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF214,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Mats",null,null,"48\" x 36\"",null,"F1209",null,1.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA215,AG215)","v":250.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA215*(1-W215)+0.004999,2)","v":250.3},null,"",250.3,0,250.3,{"$f":"(AG215-AC215)/AG215","v":0},null,4,{"$f":"SUM(AJ215:AL215)+AE215","v":250.3},null,null,{"$f":"ROUND(AC215/(1-VLOOKUP(AF215,Group,2,FALSE)),2)","v":250.3},{"$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,"Stocked Mats",null,null,"48\" x 48\"",null,"F1212",null,1.6,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA216,AG216)","v":286.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA216*(1-W216)+0.004999,2)","v":286.7},null,"",286.7,0,286.7,{"$f":"(AG216-AC216)/AG216","v":0},null,4,{"$f":"SUM(AJ216:AL216)+AE216","v":286.7},null,null,{"$f":"ROUND(AC216/(1-VLOOKUP(AF216,Group,2,FALSE)),2)","v":286.7},{"$f":"IF(VLOOKUP(AF216,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ216,1)-AJ216,2),Round,2,FALSE)+VLOOKUP(AF216,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",0,ROUND(AJ216-0.04999,1)-AJ216+AM216)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF216,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Stocked Mats",null,null,"60\" x 24\"",null,"F1506",null,1,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA218,AG218)","v":242.2},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA218*(1-W218)+0.004999,2)","v":242.2},null,"",242.2,{"$f":"+W218","v":0},{"$f":"+X218","v":242.2},{"$f":"(AG218-AC218)/AG218","v":0},null,4,{"$f":"SUM(AJ218:AL218)+AE218","v":242.2},null,null,{"$f":"ROUND(AC218/(1-VLOOKUP(AF218,Group,2,FALSE)),2)","v":242.2},{"$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,"Stocked Mats",null,null,"60\" x 30\"",null,"F1508",null,1.3,null,null,null,null,null,null,null,null,null,250.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},250.35,null,"",250.35,0,250.35,0,null,4,250.35,null,null,250.35,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"60\" x 36\"",null,"F1509",null,1.5,null,null,null,null,null,null,null,null,null,277.7,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},277.7,null,"",277.7,0,277.7,0,null,4,277.7,null,null,277.7,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"60\" x 42\"",null,"F1510",null,1.8,null,null,null,null,null,null,null,null,null,298.05,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},298.05,null,"",298.05,0,298.05,0,null,4,298.05,null,null,298.05,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"60\" x 48\"",null,"F1512",null,2,null,null,null,null,null,null,null,null,null,311.35000000000002,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},311.35000000000002,null,"",311.35000000000002,0,311.35000000000002,0,null,4,311.35000000000002,null,null,311.35000000000002,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"60\" x 60\"",null,"F1515",null,2.5,null,null,null,null,null,null,null,null,null,345.5,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},345.5,null,"",345.5,0,345.5,0,null,4,345.5,null,null,345.5,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,"Mats",null,null,"72\" x 24\"",null,"F1806",null,1.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA225,AG225)","v":250.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA225*(1-W225)+0.004999,2)","v":250.3},null,"",250.3,{"$f":"+W225","v":0},{"$f":"+X225","v":250.3},{"$f":"(AG225-AC225)/AG225","v":0},null,1,{"$f":"SUM(AJ225:AL225)+AE225","v":250.3},null,null,{"$f":"ROUND(AC225/(1-VLOOKUP(AF225,Group,2,FALSE)),2)","v":250.3},{"$f":"IF(VLOOKUP(AF225,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ225,1)-AJ225,2),Round,2,FALSE)+VLOOKUP(AF225,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF225,Group,7,FALSE)=\"\",0,ROUND(AJ225-0.04999,1)-AJ225+AM225)","v":0},{"$f":"IF(VLOOKUP(AF225,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF225,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Mats",null,null,"72\" x 30\"",null,"F1808",null,1.5,null,null,null,null,null,null,null,null,null,277.7,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},277.7,null,"",277.7,0,277.7,0,null,4,277.7,null,null,277.7,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"72\" x 36\"",null,"F1809",null,1.8,null,null,null,null,null,null,null,null,null,301.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},301.3,null,"",301.3,0,301.3,0,null,4,301.3,null,null,301.3,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"72\" x 42\"",null,"F1810",null,2.1,null,null,null,null,null,null,null,null,null,315.10000000000002,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},315.10000000000002,null,"",315.10000000000002,0,315.10000000000002,0,null,4,315.10000000000002,null,null,315.10000000000002,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"72\" x 48\"",null,"F1812",null,2.4,null,null,null,null,null,null,null,null,null,338.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},338.75,null,"",338.75,0,338.75,0,null,4,338.75,null,null,338.75,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"72\" x 60\"",null,"F1815",null,3,null,null,null,null,null,null,null,null,null,370.8,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},370.8,null,"",370.8,0,370.8,0,null,4,370.8,null,null,370.8,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"72\" x 72\"",null,"F1818",null,3.6,null,null,null,null,null,null,null,null,null,410.9,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},410.9,null,"",410.9,0,410.9,0,null,4,410.9,null,null,410.9,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,"Mats",null,null,"84\" x 24\"",null,"F2106",null,1.4,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA233,AG233)","v":267.60000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA233*(1-W233)+0.004999,2)","v":267.60000000000002},null,"",267.60000000000002,{"$f":"+W233","v":0},{"$f":"+X233","v":267.60000000000002},{"$f":"(AG233-AC233)/AG233","v":0},null,1,{"$f":"SUM(AJ233:AL233)+AE233","v":267.60000000000002},null,null,{"$f":"ROUND(AC233/(1-VLOOKUP(AF233,Group,2,FALSE)),2)","v":267.60000000000002},{"$f":"IF(VLOOKUP(AF233,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ233,1)-AJ233,2),Round,2,FALSE)+VLOOKUP(AF233,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF233,Group,7,FALSE)=\"\",0,ROUND(AJ233-0.04999,1)-AJ233+AM233)","v":0},{"$f":"IF(VLOOKUP(AF233,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF233,Group,7,FALSE))","v":""},null,"X"]
[null,"Stocked Mats",null,null,"84\" x 30\"",null,"F2108",null,1.8,null,null,null,null,null,null,null,null,null,298.05,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},298.05,null,"",298.05,0,298.05,0,null,4,298.05,null,null,298.05,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"84\" x 36\"",null,"F2109",null,2.1,null,null,null,null,null,null,null,null,null,315.10000000000002,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},315.10000000000002,null,"",315.10000000000002,0,315.10000000000002,0,null,4,315.10000000000002,null,null,315.10000000000002,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"84\" x 42\"",null,"F2110",null,2.5,null,null,null,null,null,null,null,null,null,342.4,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},342.4,null,"",342.4,0,342.4,0,null,4,342.4,null,null,342.4,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"84\" x 48\"",null,"F2112",null,2.8,null,null,null,null,null,null,null,null,null,362.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},362.35,null,"",362.35,0,362.35,0,null,4,362.35,null,null,362.35,0,0,"",null,"X"]
[null,"Mats",null,null,"84\" x 60\"",null,"F2115",null,3.5,null,null,null,null,null,null,null,null,null,400.4,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},400.4,null,"",400.4,0,400.4,0,null,1,400.4,null,null,400.4,0,0,"",null,"X"]
[null,"Mats",null,null,"84\" x 72\"",null,"F2118",null,4.2,null,null,null,null,null,null,null,null,null,473.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},473.35,null,"",473.35,0,473.35,0,null,1,473.35,null,null,473.35,0,0,"",null,"X"]
[null,"Mats",null,null,"84\" x 84\"",null,"F2121",null,4.9000000000000004,null,null,null,null,null,null,null,null,null,550,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},550,null,"",550,0,550,0,null,1,550,null,null,550,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"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,"120 VOLT STANDARD MATS - continued",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","NUF",null,null,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,"Mats",null,null,"96\" x 24\"",null,"F2506",null,1.6,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA245,AG245)","v":286.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA245*(1-W245)+0.004999,2)","v":286.7},null,"",286.7,{"$f":"+W245","v":0},{"$f":"+X245","v":286.7},{"$f":"(AG245-AC245)/AG245","v":0},null,1,{"$f":"SUM(AJ245:AL245)+AE245","v":286.7},null,null,{"$f":"ROUND(AC245/(1-VLOOKUP(AF245,Group,2,FALSE)),2)","v":286.7},{"$f":"IF(VLOOKUP(AF245,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ245,1)-AJ245,2),Round,2,FALSE)+VLOOKUP(AF245,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF245,Group,7,FALSE)=\"\",0,ROUND(AJ245-0.04999,1)-AJ245+AM245)","v":0},{"$f":"IF(VLOOKUP(AF245,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF245,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"96\" x 30\"",null,"F2508",null,2,null,null,null,null,null,null,null,null,null,311.35000000000002,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},311.35000000000002,null,"",311.35000000000002,0,311.35000000000002,0,null,1,311.35000000000002,null,null,311.35000000000002,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"96\" x 36\"",null,"F2509",null,2.4,null,null,null,null,null,null,null,null,null,338.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},338.75,null,"",338.75,0,338.75,0,null,4,338.75,null,null,338.75,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"96\" x 42\"",null,"F2510",null,2.8,null,null,null,null,null,null,null,null,null,362.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},362.35,null,"",362.35,0,362.35,0,null,4,362.35,null,null,362.35,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"96\" x 48\"",null,"F2512",null,3.2,null,null,null,null,null,null,null,null,null,376.95,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},376.95,null,"",376.95,0,376.95,0,null,4,376.95,null,null,376.95,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"96\" x 60\"",null,"F2515",null,4,null,null,null,null,null,null,null,null,null,451.2,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},451.2,null,"",451.2,0,451.2,0,null,4,451.2,null,null,451.2,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"96\" x 72\"",null,"F2518",null,4.8,null,null,null,null,null,null,null,null,null,538.95000000000005,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},538.95000000000005,null,"",538.95000000000005,0,538.95000000000005,0,null,4,538.95000000000005,null,null,538.95000000000005,0,0,"",null,"X"]
[null,"Mats",null,null,"96\" x 84\"",null,"F2521",null,5.6,null,null,null,null,null,null,null,null,null,626.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},626.35,null,"",626.35,0,626.35,0,null,1,626.35,null,null,626.35,0,0,"",null,"X"]
[null,"Mats",null,null,"96\" x 96\"",null,"F2525",null,6.4,null,null,null,null,null,null,null,null,null,712.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},712.3,null,"",712.3,0,712.3,0,null,1,712.3,null,null,712.3,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Mats",null,null,"108\" x 24\"",null,"F2706",null,1.8,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA255,AG255)","v":301.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA255*(1-W255)+0.004999,2)","v":301.3},null,"",301.3,{"$f":"+W255","v":0},{"$f":"+X255","v":301.3},{"$f":"(AG255-AC255)/AG255","v":0},null,1,{"$f":"SUM(AJ255:AL255)+AE255","v":301.3},null,null,{"$f":"ROUND(AC255/(1-VLOOKUP(AF255,Group,2,FALSE)),2)","v":301.3},{"$f":"IF(VLOOKUP(AF255,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ255,1)-AJ255,2),Round,2,FALSE)+VLOOKUP(AF255,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",0,ROUND(AJ255-0.04999,1)-AJ255+AM255)","v":0},{"$f":"IF(VLOOKUP(AF255,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF255,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"108\" x 30\"",null,"F2708",null,2.2999999999999998,null,null,null,null,null,null,null,null,null,327.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},327.75,null,"",327.75,0,327.75,0,null,1,327.75,null,null,327.75,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"108\" x 36\"",null,"F2709",null,2.7,null,null,null,null,null,null,null,null,null,357.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},357.3,null,"",357.3,0,357.3,0,null,4,357.3,null,null,357.3,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 42\"",null,"F2710",null,3.2,null,null,null,null,null,null,null,null,null,375.9,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},375.9,null,"",375.9,0,375.9,0,null,1,375.9,null,null,375.9,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"108\" x 48\"",null,"F2712",null,3.6,null,null,null,null,null,null,null,null,null,410.9,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},410.9,null,"",410.9,0,410.9,0,null,4,410.9,null,null,410.9,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"108\" x 60\"",null,"F2715",null,4.5,null,null,null,null,null,null,null,null,null,505.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},505.75,null,"",505.75,0,505.75,0,null,4,505.75,null,null,505.75,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 72\"",null,"F2718",null,5.4,null,null,null,null,null,null,null,null,null,604.25,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},604.25,null,"",604.25,0,604.25,0,null,1,604.25,null,null,604.25,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 84\"",null,"F2721",null,6.3,null,null,null,null,null,null,null,null,null,702.45,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},702.45,null,"",702.45,0,702.45,0,null,1,702.45,null,null,702.45,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 96\"",null,"F2725",null,7.2,null,null,null,null,null,null,null,null,null,798.95,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},798.95,null,"",798.95,0,798.95,0,null,1,798.95,null,null,798.95,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 108\"",null,"F2727",null,8.1,null,null,null,null,null,null,null,null,null,896.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},896.3,null,"",896.3,0,896.3,0,null,1,896.3,null,null,896.3,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Mats",null,null,"118\" x 24\"",null,"F3006",null,2,null,null,null," ",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA266,AG266)","v":309.60000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA266*(1-W266)+0.004999,2)","v":309.60000000000002},null,"",309.60000000000002,{"$f":"+W266","v":0},{"$f":"+X266","v":309.60000000000002},{"$f":"(AG266-AC266)/AG266","v":0},null,1,{"$f":"SUM(AJ266:AL266)+AE266","v":309.60000000000002},null,null,{"$f":"ROUND(AC266/(1-VLOOKUP(AF266,Group,2,FALSE)),2)","v":309.60000000000002},{"$f":"IF(VLOOKUP(AF266,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ266,1)-AJ266,2),Round,2,FALSE)+VLOOKUP(AF266,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF266,Group,7,FALSE)=\"\",0,ROUND(AJ266-0.04999,1)-AJ266+AM266)","v":0},{"$f":"IF(VLOOKUP(AF266,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF266,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"118\" x 30\"",null,"F3008",null,2.5,null,null,null,null,null,null,null,null,null,342.6,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},342.6,null,"",342.6,0,342.6,0,null,1,342.6,null,null,342.6,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"118\" x 36\"",null,"F3009",null,3,null,null,null,null,null,null,null,null,null,369.15,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},369.15,null,"",369.15,0,369.15,0,null,4,369.15,null,null,369.15,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"118\" x 42\"",null,"F3010",null,3.4,null,null,null,null,null,null,null,null,null,394.5,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},394.5,null,"",394.5,0,394.5,0,null,4,394.5,null,null,394.5,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"118\" x 48\"",null,"F3012",null,3.9,null,null,null,null,null,null,null,null,null,444.55,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},444.55,null,"",444.55,0,444.55,0,null,4,444.55,null,null,444.55,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"118\" x 60\"",null,"F3015",null,4.9000000000000004,null,null,null,null,null,null,null,null,null,551.85,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},551.85,null,"",551.85,0,551.85,0,null,4,551.85,null,null,551.85,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"118\" x 72\"",null,"F3018",null,5.9,null,null,null,null,null,null,null,null,null,658.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},658.35,null,"",658.35,0,658.35,0,null,4,658.35,null,null,658.35,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 84\"",null,"F3021",null,6.9,null,null,null,null,null,null,null,null,null,765.45,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},765.45,null,"",765.45,0,765.45,0,null,1,765.45,null,null,765.45,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"118\" x 96\"",null,"F3025",null,7.9,null,null,null,null,null,null,null,null,null,870.7,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},870.7,null,"",870.7,0,870.7,0,null,4,870.7,null,null,870.7,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 108\"",null,"F3027",null,8.9,null,null,null,null,null,null,null,null,null,976.9,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},976.9,null,"",976.9,0,976.9,0,null,1,976.9,null,null,976.9,0,0,"",null,"X"]
[null,"Stocked Mats",null,null,"118\" x 116\"",null,"F3030",null,9.5,null,null,null,null,null,null,null,null,null,1046.8499999999999,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1046.8499999999999,null,"",1046.8499999999999,0,1046.8499999999999,0,null,4,1046.8499999999999,null,null,1046.8499999999999,0,0,"",null,"X"]
[]
[null,"Mats",null,null,"32\" x 32\"",null,"F032032-S",null,0.7,null,"Shower Mat",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA278,AG278)","v":207.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA278*(1-W278)+0.004999,2)","v":207.75},null,"",207.75,0,207.75,0,null,1,207.75,null,null,207.75,0,0,"",null,"X"]
[]
[null,null,null,"Notes:","Nuheat Mats can now be used in Wet areas and can also be used as a heating alternative.  All Standard Mats have 10 feet of lead wire.  "]
[]
[null,null,"240 VOLT STANDARD MATS",null,null,null,null,null,"Amps",null,null,null,null,null,null,null,null,"Item # Lookup:","NUG",null,null,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,"Mats",null,null,"60\" x 36\"",null,"G1509",null,0.8,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA284,AG284)","v":277.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA284*(1-W284)+0.004999,2)","v":277.7},null,"",277.7,{"$f":"+W284","v":0},277.7,{"$f":"(AG284-AC284)/AG284","v":0},null,1,{"$f":"SUM(AJ284:AL284)+AE284","v":277.7},null,null,{"$f":"ROUND(AC284/(1-VLOOKUP(AF284,Group,2,FALSE)),2)","v":277.7},{"$f":"IF(VLOOKUP(AF284,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ284,1)-AJ284,2),Round,2,FALSE)+VLOOKUP(AF284,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF284,Group,7,FALSE)=\"\",0,ROUND(AJ284-0.04999,1)-AJ284+AM284)","v":0},{"$f":"IF(VLOOKUP(AF284,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF284,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"60\" x 42\"",null,"G1510",null,0.9,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA285,AG285)","v":298.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA285*(1-W285)+0.004999,2)","v":298.05},null,"",298.05,0,298.05,{"$f":"(AG285-AC285)/AG285","v":0},null,1,{"$f":"SUM(AJ285:AL285)+AE285","v":298.05},null,null,{"$f":"ROUND(AC285/(1-VLOOKUP(AF285,Group,2,FALSE)),2)","v":298.05},{"$f":"IF(VLOOKUP(AF285,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ285,1)-AJ285,2),Round,2,FALSE)+VLOOKUP(AF285,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF285,Group,7,FALSE)=\"\",0,ROUND(AJ285-0.04999,1)-AJ285+AM285)","v":0},{"$f":"IF(VLOOKUP(AF285,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF285,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"60\" x 48\"",null,"G1512",null,1,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA286,AG286)","v":311.35000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA286*(1-W286)+0.004999,2)","v":311.35000000000002},null,"",311.35000000000002,0,311.35000000000002,{"$f":"(AG286-AC286)/AG286","v":0},null,1,{"$f":"SUM(AJ286:AL286)+AE286","v":311.35000000000002},null,null,{"$f":"ROUND(AC286/(1-VLOOKUP(AF286,Group,2,FALSE)),2)","v":311.35000000000002},{"$f":"IF(VLOOKUP(AF286,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ286,1)-AJ286,2),Round,2,FALSE)+VLOOKUP(AF286,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF286,Group,7,FALSE)=\"\",0,ROUND(AJ286-0.04999,1)-AJ286+AM286)","v":0},{"$f":"IF(VLOOKUP(AF286,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF286,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"60\" x 60\"",null,"G1515",null,1.3,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA287,AG287)","v":345.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA287*(1-W287)+0.004999,2)","v":345.5},null,"",345.5,0,345.5,{"$f":"(AG287-AC287)/AG287","v":0},null,1,{"$f":"SUM(AJ287:AL287)+AE287","v":345.5},null,null,{"$f":"ROUND(AC287/(1-VLOOKUP(AF287,Group,2,FALSE)),2)","v":345.5},{"$f":"IF(VLOOKUP(AF287,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ287,1)-AJ287,2),Round,2,FALSE)+VLOOKUP(AF287,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF287,Group,7,FALSE)=\"\",0,ROUND(AJ287-0.04999,1)-AJ287+AM287)","v":0},{"$f":"IF(VLOOKUP(AF287,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF287,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Mats",null,null,"72\" x 30\"",null,"G1808",null,0.8,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA289,AG289)","v":277.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA289*(1-W289)+0.004999,2)","v":277.7},null,"",277.7,{"$f":"+W289","v":0},{"$f":"+X289","v":277.7},{"$f":"(AG289-AC289)/AG289","v":0},null,1,{"$f":"SUM(AJ289:AL289)+AE289","v":277.7},null,null,{"$f":"ROUND(AC289/(1-VLOOKUP(AF289,Group,2,FALSE)),2)","v":277.7},{"$f":"IF(VLOOKUP(AF289,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ289,1)-AJ289,2),Round,2,FALSE)+VLOOKUP(AF289,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF289,Group,7,FALSE)=\"\",0,ROUND(AJ289-0.04999,1)-AJ289+AM289)","v":0},{"$f":"IF(VLOOKUP(AF289,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF289,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"72\" x 36\"",null,"G1809",null,0.9,null,null,null,null,null,null,null,null,null,301.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},301.3,null,"",301.3,0,301.3,0,null,1,301.3,null,null,301.3,0,0,"",null,"X"]
[null,"Mats",null,null,"72\" x 42\"",null,"G1810",null,1.1000000000000001,null,null,null,null,null,null,null,null,null,315.10000000000002,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},315.10000000000002,null,"",315.10000000000002,0,315.10000000000002,0,null,1,315.10000000000002,null,null,315.10000000000002,0,0,"",null,"X"]
[null,"Mats",null,null,"72\" x 48\"",null,"G1812",null,1.2,null,null,null,null,null,null,null,null,null,338.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},338.75,null,"",338.75,0,338.75,0,null,1,338.75,null,null,338.75,0,0,"",null,"X"]
[null,"Mats",null,null,"72\" x 60\"",null,"G1815",null,1.5,null,null,null,null,null,null,null,null,null,370.8,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},370.8,null,"",370.8,0,370.8,0,null,1,370.8,null,null,370.8,0,0,"",null,"X"]
[null,"Mats",null,null,"72\" x 72\"",null,"G1818",null,1.8,null,null,null,null,null,null,null,null,null,410.9,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},410.9,null,"",410.9,0,410.9,0,null,1,410.9,null,null,410.9,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,"Mats",null,null,"84\" x 24\"",null,"G2106",null,0.7,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA296,AG296)","v":267.60000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA296*(1-W296)+0.004999,2)","v":267.60000000000002},null,"",267.60000000000002,{"$f":"+W296","v":0},{"$f":"+X296","v":267.60000000000002},{"$f":"(AG296-AC296)/AG296","v":0},null,1,{"$f":"SUM(AJ296:AL296)+AE296","v":267.60000000000002},null,null,{"$f":"ROUND(AC296/(1-VLOOKUP(AF296,Group,2,FALSE)),2)","v":267.60000000000002},{"$f":"IF(VLOOKUP(AF296,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ296,1)-AJ296,2),Round,2,FALSE)+VLOOKUP(AF296,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF296,Group,7,FALSE)=\"\",0,ROUND(AJ296-0.04999,1)-AJ296+AM296)","v":0},{"$f":"IF(VLOOKUP(AF296,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF296,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"84\" x 30\"",null,"G2108",null,0.9,null,null,null,null,null,null,null,null,null,298.05,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},298.05,null,"",298.05,0,298.05,0,null,1,298.05,null,null,298.05,0,0,"",null,"X"]
[null,"Mats",null,null,"84\" x 36\"",null,"G2109",null,1.1000000000000001,null,null,null,null,null,null,null,null,null,315.10000000000002,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},315.10000000000002,null,"",315.10000000000002,0,315.10000000000002,0,null,1,315.10000000000002,null,null,315.10000000000002,0,0,"",null,"X"]
[null,"Mats",null,null,"84\" x 42\"",null,"G2110",null,1.2,null,null,null,null,null,null,null,null,null,342.4,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},342.4,null,"",342.4,0,342.4,0,null,1,342.4,null,null,342.4,0,0,"",null,"X"]
[null,"Mats",null,null,"84\" x 48\"",null,"G2112",null,1.4,null,null,null,null,null,null,null,null,null,362.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},362.35,null,"",362.35,0,362.35,0,null,1,362.35,null,null,362.35,0,0,"",null,"X"]
[null,"Mats",null,null,"84\" x 60\"",null,"G2115",null,1.8,null,null,null,null,null,null,null,null,null,400.4,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},400.4,null,"",400.4,0,400.4,0,null,1,400.4,null,null,400.4,0,0,"",null,"X"]
[null,"Mats",null,null,"84\" x 72\"",null,"G2118",null,2.1,null,null,null,null,null,null,null,null,null,473.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},473.35,null,"",473.35,0,473.35,0,null,1,473.35,null,null,473.35,0,0,"",null,"X"]
[null,"Mats",null,null,"84\" x 84\"",null,"G2121",null,2.5,null,null,null,null,null,null,null,null,null,550,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},550,null,"",550,0,550,0,null,1,550,null,null,550,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,"Mats",null,null,"96\" x 24\"",null,"G2506",null,0.8,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA305,AG305)","v":286.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA305*(1-W305)+0.004999,2)","v":286.7},null,"",286.7,{"$f":"+W305","v":0},{"$f":"+X305","v":286.7},{"$f":"(AG305-AC305)/AG305","v":0},null,1,{"$f":"SUM(AJ305:AL305)+AE305","v":286.7},null,null,{"$f":"ROUND(AC305/(1-VLOOKUP(AF305,Group,2,FALSE)),2)","v":286.7},{"$f":"IF(VLOOKUP(AF305,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ305,1)-AJ305,2),Round,2,FALSE)+VLOOKUP(AF305,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF305,Group,7,FALSE)=\"\",0,ROUND(AJ305-0.04999,1)-AJ305+AM305)","v":0},{"$f":"IF(VLOOKUP(AF305,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF305,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"96\" x 30\"",null,"G2508",null,1,null,null,null,null,null,null,null,null,null,311.35000000000002,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},311.35000000000002,null,"",311.35000000000002,0,311.35000000000002,0,null,1,311.35000000000002,null,null,311.35000000000002,0,0,"",null,"X"]
[null,"Mats",null,null,"96\" x 36\"",null,"G2509",null,1.2,null,null,null,null,null,null,null,null,null,338.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},338.75,null,"",338.75,0,338.75,0,null,1,338.75,null,null,338.75,0,0,"",null,"X"]
[null,"Mats",null,null,"96\" x 42\"",null,"G2510",null,1.4,null,null,null,null,null,null,null,null,null,362.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},362.35,null,"",362.35,0,362.35,0,null,1,362.35,null,null,362.35,0,0,"",null,"X"]
[null,"Mats",null,null,"96\" x 48\"",null,"G2512",null,1.6,null,null,null,null,null,null,null,null,null,376.95,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},376.95,null,"",376.95,0,376.95,0,null,1,376.95,null,null,376.95,0,0,"",null,"X"]
[null,"Mats",null,null,"96\" x 60\"",null,"G2515",null,2,null,null,null,null,null,null,null,null,null,451.2,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},451.2,null,"",451.2,0,451.2,0,null,1,451.2,null,null,451.2,0,0,"",null,"X"]
[null,"Mats",null,null,"96\" x 72\"",null,"G2518",null,2.4,null,null,null,null,null,null,null,null,null,538.95000000000005,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},538.95000000000005,null,"",538.95000000000005,0,538.95000000000005,0,null,1,538.95000000000005,null,null,538.95000000000005,0,0,"",null,"X"]
[null,"Mats",null,null,"96\" x 84\"",null,"G2521",null,2.8,null,null,null,null,null,null,null,null,null,626.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},626.35,null,"",626.35,0,626.35,0,null,1,626.35,null,null,626.35,0,0,"",null,"X"]
[null,"Mats",null,null,"96\" x 96\"",null,"G2525",null,3.2,null,null,null,null,null,null,null,null,null,712.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},712.3,null,"",712.3,0,712.3,0,null,1,712.3,null,null,712.3,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"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,"240 VOLT STANDARD MATS - continued",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","NUG",null,null,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,"Mats",null,null,"108\" x 24\"",null,"G2706",null,0.9,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA318,AG318)","v":301.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA318*(1-W318)+0.004999,2)","v":301.3},null,"",301.3,{"$f":"+W318","v":0},{"$f":"+X318","v":301.3},{"$f":"(AG318-AC318)/AG318","v":0},null,1,{"$f":"SUM(AJ318:AL318)+AE318","v":301.3},null,null,{"$f":"ROUND(AC318/(1-VLOOKUP(AF318,Group,2,FALSE)),2)","v":301.3},{"$f":"IF(VLOOKUP(AF318,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ318,1)-AJ318,2),Round,2,FALSE)+VLOOKUP(AF318,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF318,Group,7,FALSE)=\"\",0,ROUND(AJ318-0.04999,1)-AJ318+AM318)","v":0},{"$f":"IF(VLOOKUP(AF318,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF318,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"108\" x 30\"",null,"G2708",null,1.1000000000000001,null,null,null,null,null,null,null,null,null,327.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},327.75,null,"",327.75,0,327.75,0,null,1,327.75,null,null,327.75,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 36\"",null,"G2709",null,1.4,null,null,null,null,null,null,null,null,null,357.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},357.3,null,"",357.3,0,357.3,0,null,1,357.3,null,null,357.3,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 42\"",null,"G2710",null,1.6,null,null,null,null,null,null,null,null,null,375.9,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},375.9,null,"",375.9,0,375.9,0,null,1,375.9,null,null,375.9,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 48\"",null,"G2712",null,1.8,null,null,null,null,null,null,null,null,null,410.9,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},410.9,null,"",410.9,0,410.9,0,null,1,410.9,null,null,410.9,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 60\"",null,"G2715",null,2.2999999999999998,null,null,null,null,null,null,null,null,null,505.75,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},505.75,null,"",505.75,0,505.75,0,null,1,505.75,null,null,505.75,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 72\"",null,"G2718",null,2.7,null,null,null,null,null,null,null,null,null,604.25,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},604.25,null,"",604.25,0,604.25,0,null,1,604.25,null,null,604.25,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 84\"",null,"G2721",null,3.2,null,null,null,null,null,null,null,null,null,702.45,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},702.45,null,"",702.45,0,702.45,0,null,1,702.45,null,null,702.45,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 96\"",null,"G2725",null,3.6,null,null,null,null,null,null,null,null,null,798.95,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},798.95,null,"",798.95,0,798.95,0,null,1,798.95,null,null,798.95,0,0,"",null,"X"]
[null,"Mats",null,null,"108\" x 108\"",null,"G2727",null,4.0999999999999996,null,null,null,null,null,null,null,null,null,896.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},896.3,null,"",896.3,0,896.3,0,null,1,896.3,null,null,896.3,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Mats",null,null,"118\" x 24\"",null,"G3006",null,1,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA329,AG329)","v":309.60000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA329*(1-W329)+0.004999,2)","v":309.60000000000002},null,"",309.60000000000002,{"$f":"+W329","v":0},{"$f":"+X329","v":309.60000000000002},{"$f":"(AG329-AC329)/AG329","v":0},null,1,{"$f":"SUM(AJ329:AL329)+AE329","v":309.60000000000002},null,null,{"$f":"ROUND(AC329/(1-VLOOKUP(AF329,Group,2,FALSE)),2)","v":309.60000000000002},{"$f":"IF(VLOOKUP(AF329,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ329,1)-AJ329,2),Round,2,FALSE)+VLOOKUP(AF329,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF329,Group,7,FALSE)=\"\",0,ROUND(AJ329-0.04999,1)-AJ329+AM329)","v":0},{"$f":"IF(VLOOKUP(AF329,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF329,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"118\" x 30\"",null,"G3008",null,1.2,null,null,null,null,null,null,null,null,null,342.6,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},342.6,null,"",342.6,0,342.6,0,null,1,342.6,null,null,342.6,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 36\"",null,"G3009",null,1.5,null,null,null,null,null,null,null,null,null,369.15,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},369.15,null,"",369.15,0,369.15,0,null,1,369.15,null,null,369.15,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 42\"",null,"G3010",null,1.7,null,null,null,null,null,null,null,null,null,394.5,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},394.5,null,"",394.5,0,394.5,0,null,1,394.5,null,null,394.5,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 48\"",null,"G3012",null,2,null,null,null,null,null,null,null,null,null,444.55,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},444.55,null,"",444.55,0,444.55,0,null,1,444.55,null,null,444.55,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 60\"",null,"G3015",null,2.5,null,null,null,null,null,null,null,null,null,551.85,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},551.85,null,"",551.85,0,551.85,0,null,1,551.85,null,null,551.85,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 72\"",null,"G3018",null,3,null,null,null,null,null,null,null,null,null,658.35,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},658.35,null,"",658.35,0,658.35,0,null,1,658.35,null,null,658.35,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 84\"",null,"G3021",null,3.4,null,null,null,null,null,null,null,null,null,765.45,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},765.45,null,"",765.45,0,765.45,0,null,1,765.45,null,null,765.45,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 96\"",null,"G3025",null,3.9," ",null,null,null,null,null,null,null,null,870.7,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},870.7,null,"",870.7,0,870.7,0,null,1,870.7,null,null,870.7,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 108\"",null,"G3027",null,4.4000000000000004," ",null,null,null,null,null,null,null,null,976.9,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},976.9,null,"",976.9,0,976.9,0,null,1,976.9,null,null,976.9,0,0,"",null,"X"]
[null,"Mats",null,null,"118\" x 116\"",null,"G3030",null,4.8,null,null,null,null,null,null,null,null,null,1046.8499999999999,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1046.8499999999999,null,"",1046.8499999999999,0,1046.8499999999999,0,null,1,1046.8499999999999,null,null,1046.8499999999999,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,"Mats",null,null,"144\" x 36\"",null,"G144036",null,1.8,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA341,AG341)","v":410.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA341*(1-W341)+0.004999,2)","v":410.9},null,"",410.9,{"$f":"+W341","v":0},410.9,{"$f":"(AG341-AC341)/AG341","v":0},null,1,{"$f":"SUM(AJ341:AL341)+AE341","v":410.9},null,null,{"$f":"ROUND(AC341/(1-VLOOKUP(AF341,Group,2,FALSE)),2)","v":410.9},{"$f":"IF(VLOOKUP(AF341,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ341,1)-AJ341,2),Round,2,FALSE)+VLOOKUP(AF341,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF341,Group,7,FALSE)=\"\",0,ROUND(AJ341-0.04999,1)-AJ341+AM341)","v":0},{"$f":"IF(VLOOKUP(AF341,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF341,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"144\" x 60\"",null,"G144060",null,3,null,null,null,null,null,null,null,null,null,669.4,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},669.4,null,"",669.4,0,669.4,0,null,1,669.4,null,null,669.4,0,0,"",null,"X"]
[null,"Mats",null,null,"144\" x 72\"",null,"G144072",null,3.6,null,null,null,null,null,null,null,null,null,798.95,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},798.95,null,"",798.95,0,798.95,0,null,1,798.95,null,null,798.95,0,0,"",null,"X"]
[null,"Mats",null,null,"144\" x 96\"",null,"G144096",null,4.8,null,null,null,null,null,null,null,null,null,1057.2,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1057.2,null,"",1057.2,0,1057.2,0,null,1,1057.2,null,null,1057.2,0,0,"",null,"X"]
[null,"Mats",null,null,"144\" x 108\"",null,"G144108",null,5.4,null,null,null,null,null,null,null,null,null,1184.3,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1184.3,null,"",1184.3,0,1184.3,0,null,1,1184.3,null,null,1184.3,0,0,"",null,"X"]
[null,"Mats",null,null,"144\" x 120\"",null,"G144120",null,6,null,null,null,null,null,null,null,null,null,1310.45,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1310.45,null,"",1310.45,0,1310.45,0,null,1,1310.45,null,null,1310.45,0,0,"",null,"X"]
[null,"Mats",null,null,"144\" x 140\"",null,"G144140",null,7,null,null,null,null,null,null,null,null,null,1519.7,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1519.7,null,"",1519.7,0,1519.7,0,null,1,1519.7,null,null,1519.7,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,"Mats",null,null,"168\" x 96\"",null,"G168096",null,5.6,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA349,AG349)","v":1225.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA349*(1-W349)+0.004999,2)","v":1225.75},null,"",1225.75,{"$f":"+W349","v":0},1225.75,{"$f":"(AG349-AC349)/AG349","v":0},null,1,{"$f":"SUM(AJ349:AL349)+AE349","v":1225.75},null,null,{"$f":"ROUND(AC349/(1-VLOOKUP(AF349,Group,2,FALSE)),2)","v":1225.75},{"$f":"IF(VLOOKUP(AF349,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ349,1)-AJ349,2),Round,2,FALSE)+VLOOKUP(AF349,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF349,Group,7,FALSE)=\"\",0,ROUND(AJ349-0.04999,1)-AJ349+AM349)","v":0},{"$f":"IF(VLOOKUP(AF349,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF349,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"168\" x 108\"",null,"G168108",null,6.3,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA350,AG350)","v":1373.25},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA350*(1-W350)+0.004999,2)","v":1373.25},null,"",1373.25,0,1373.25,{"$f":"(AG350-AC350)/AG350","v":0},null,1,{"$f":"SUM(AJ350:AL350)+AE350","v":1373.25},null,null,{"$f":"ROUND(AC350/(1-VLOOKUP(AF350,Group,2,FALSE)),2)","v":1373.25},{"$f":"IF(VLOOKUP(AF350,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ350,1)-AJ350,2),Round,2,FALSE)+VLOOKUP(AF350,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF350,Group,7,FALSE)=\"\",0,ROUND(AJ350-0.04999,1)-AJ350+AM350)","v":0},{"$f":"IF(VLOOKUP(AF350,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF350,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"168\" x 120\"",null,"G168120",null,7,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA351,AG351)","v":1519.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA351*(1-W351)+0.004999,2)","v":1519.7},null,"",1519.7,0,1519.7,{"$f":"(AG351-AC351)/AG351","v":0},null,1,{"$f":"SUM(AJ351:AL351)+AE351","v":1519.7},null,null,{"$f":"ROUND(AC351/(1-VLOOKUP(AF351,Group,2,FALSE)),2)","v":1519.7},{"$f":"IF(VLOOKUP(AF351,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ351,1)-AJ351,2),Round,2,FALSE)+VLOOKUP(AF351,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF351,Group,7,FALSE)=\"\",0,ROUND(AJ351-0.04999,1)-AJ351+AM351)","v":0},{"$f":"IF(VLOOKUP(AF351,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF351,Group,7,FALSE))","v":""},null,"X"]
[null,"Mats",null,null,"168\" x 140\"",null,"G168140",null,8.1999999999999993,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA352,AG352)","v":1762.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA352*(1-W352)+0.004999,2)","v":1762.45},null,"",1762.45,0,1762.45,{"$f":"(AG352-AC352)/AG352","v":0},null,1,{"$f":"SUM(AJ352:AL352)+AE352","v":1762.45},null,null,{"$f":"ROUND(AC352/(1-VLOOKUP(AF352,Group,2,FALSE)),2)","v":1762.45},{"$f":"IF(VLOOKUP(AF352,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ352,1)-AJ352,2),Round,2,FALSE)+VLOOKUP(AF352,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF352,Group,7,FALSE)=\"\",0,ROUND(AJ352-0.04999,1)-AJ352+AM352)","v":0},{"$f":"IF(VLOOKUP(AF352,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF352,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,"Mats",null,null,"240\" x 120\"",null,"G240120",null,10,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA354,AG354)","v":2133.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA354*(1-W354)+0.004999,2)","v":2133.75},null,"",2133.75,{"$f":"+W354","v":0},{"$f":"+X354","v":2133.75},{"$f":"(AG354-AC354)/AG354","v":0},null,1,{"$f":"SUM(AJ354:AL354)+AE354","v":2133.75},null,null,{"$f":"ROUND(AC354/(1-VLOOKUP(AF354,Group,2,FALSE)),2)","v":2133.75},{"$f":"IF(VLOOKUP(AF354,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ354,1)-AJ354,2),Round,2,FALSE)+VLOOKUP(AF354,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF354,Group,7,FALSE)=\"\",0,ROUND(AJ354-0.04999,1)-AJ354+AM354)","v":0},{"$f":"IF(VLOOKUP(AF354,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF354,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:","Nuheat Mats can now be used in Wet areas and can also be used as a heating alternative.  All Standard Mats have 10 feet of lead wire.  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"This price list is available electronically on an Excel spreadsheet 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,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,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":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page","http://www.nuheat.com/"]
[]
[]
["Product","Direct Website Link"]

{"sheet":"Changes","index":4,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
["2008-09-04","Cable Kits","Adding Cable Kits to pricelist and Cable Repair Kit"]
["2008-12-05","Controls","SOLO Dual Voltage Programmable Thermostat"]
["2009-03-18","Controls","Tempo Dual Voltage Non-Programmable Thermostat"]
["2010-05-01","240 VOLT STANDARD MATS","12 larger sized mats introduced"]
["2014-03-10","Controls","SIGNATURE WiFi enabled Dual Voltage Programmable Thermostat"]
["2014-11-20","Controls","HOME Touchscreen Programmable Dual-Voltage Thermostat (replacing the SOLO thermostat)"]
["2014-11-20","Controls","Element Non-Programmable Dual-Voltage Thermostat (replacing the Tempo thermostat)"]
["2015-08-27","QuickNet","Floor Heating Mats"]
["2016-12-13","Membrane","Uncoupling & Integrated Floor Heating Underlayment."]
["2016-12-13","Mesh","The modifiable mesh solution with 13, 120V kits & 19, 240V kits."]
["2017-12-01","Membrane","3' 3\" x 3' 3\" Nuheat Membrane Sheets added, 10 SF per sheet."]
["2022-01-07","Membrane","#NUMEM250PS 3' 3\" x 3' 3\" Nuheat Peel & Stick Membrane Sheets added, 10 SF per sheet."]
["2022-05-17","Controls","AC0200 Install Pro Alarm Fault Indicator that features a louder alarm tone, longer operating time and easily replaceable 9-volt battery (included).  (Replacing the AC0100 MatSense Pro Electric Fault Indicator.)"]
[]
[]
[]
[]
[]
["Discontinued Products"]
["2009-03-18","Controls","Dimmer Switch"]
["2009-03-18","Controls","NDG6110 110V Tile & Stone Floor Heating Regulator"]
["2009-03-18","Controls","NDG6220 220V Tile & Stone Floor Heating Regulator"]
["2009-03-18","Controls","NTG5110 110V Programmable Tile & Stone Floor-Sensing Thermostat"]
["2009-03-18","Controls","NTG5110L 110V Laminate/Engineered Wood Floor Thermostat (82F)"]
["2009-03-18","Controls","NTG5220 220V Programmable Tile & Stone Floor-Sensing Thermostat"]
["2009-03-18","Controls","NTG5220L 220V Laminate/Engineered Wood Floor Thermostat (82F)"]
["2011-06-23","Controls","HMY110 Harmony Series Thermostat 120 Volt Double Gang Box"]
["2011-06-23","Controls","HMY220 Harmony Series Thermostat 240 Volt Double Gang Box"]
["2014-11-20","Controls","SOLO Dual Voltage Programmable Thermostat and Tempo Non-Programmable Dual Voltage Thermostat."]
["2016-11-04","Controls","Harmony Programmable Dual Voltage Thermostat."]
["2016-12-13","Quicknet Floor Heating","Entire Series."]
["2022-05-17","Controls","AC0100 MatSense Pro Electric Fault Indicator.  (Being replaced with the AC0200 Install Pro Alarm Fault Indicator.)"]
["2022-12-05","Mesh","All 240V modifiable mesh kits."]