{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Intro","User Guide","Packages","Report Packages","Data"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Intro","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,11,21,17],[21,3,21,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Costing Monitoring Equipment for a Longitudinal Energy Survey:"]
[null,null,null,"Cost Calculator"]
[]
[]
[]
[null,null,null,"Worksheets",null,"Overview"]
[null,null,null,"User guide",null,"Instructions on using the Cost Calculator",null,null,null,null,null,"\nThis tool was put together by Cambridge Architectural Research and Loughborough University under contract to DECC, the Department of Energy and Climate Change.  It allows you to choose packages of monitoring equipment for a longitudinal energy survey."]
[null,null,null,"Packages",null,"Choose packages suitable for the variables you want to monitor"]
[null,null,null,"Report Packages",null,"Examine the recommended packages we put forward in our Report"]
[null,null,null,"Data",null,"See information about all the monitoring devices we included"]

{"sheet":"User Guide","index":1,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[[26,2,27,2],[45,2,46,2],[42,2,43,2],[48,2,49,2],[32,2,33,2],[35,2,36,2],[23,2,24,2],[2,1,2,4],[17,2,18,2],[20,2,21,2],[8,2,9,2],[11,2,12,2],[14,2,15,2]]}
[null,"Cost Calculator: User guide"]
[]
[null,"The Cost Calculator was designed by Cambridge Architectural Research and Loughborough University as part of DECC's work in support of a possible longitudinal UK energy survey."]
[]
[]
[null,"Packages worksheet"]
[null,"To view the packages that meet your needs, simply follow these six steps:"]
[]
[null,null,1]
[null,null,null,"Select how many homes you want to include in the survey, and how long you plan to run the survey. (Green cells and buttons are for users to change. It's best not to change other cells.)"]
[]
[null,null,2]
[null,null,null,"Choose whether your homes all have internet access, or if you need another way to draw data from homes."]
[]
[null,null,3]
[null,null,null,"Choose the variables you need to include in your survey from the drop-down list."]
[]
[null,null,4]
[null,null,null,"Choose 'Use Smart Meters' if you want to take advantage of smart meters that have been installed as part of your survey."]
[]
[null,null,5]
[null,null,null,"Hit 'Generate packages' to see all combinations of devices that would meet your needs, with costs and technical details in the table from Row 25."]
[]
[null,null,6]
[null,null,null,"The 'number per home' column is generated automatically based on your choices. If you want to monitor temperature in two rooms, choose 'temperature' twice in the variables list."]
[]
[null,null,7]
[null,null,null,"You can delete packages either by deleting your choice of variables, or by choosing new variables to monitor."]
[]
[null,"Report Packages worksheet"]
[null,"To examine the recommended packages we proposed in the Report accompanying this Calculator:"]
[]
[null,null,1]
[null,null,null,"Simply scroll up or down through the four recommended packages."]
[]
[null,null,2]
[null,null,null,"Click the '+' at the top-right of the sheet, above Column AO, to view more information about the devices."]
[]
[]
[null,"Data worksheet"]
[null,"To examine all the devices we selected:"]
[]
[null,null,1]
[null,null,null,"If you wish to see the raw data, with descriptions and costs for all devices, you may do this in the 'Data' sheet."]
[]
[null,null,2]
[null,null,null," If you wish to add data to the sheet, you can do so using the 'Add new row' button. Please be sure to complete Column AN onwards so the 'Packages' sheet still works."]
[]
[null,null,3]
[null,null,null,"If you wish to delete data from the sheet, you can use the 'Delete row' button in the same way."]

{"sheet":"Packages","index":2,"n_rows":132,"n_cols":39,"rows_kept":132,"cut":false,"hidden":false,"merged":[[25,10,25,13],[24,31,24,34],[52,1,52,3],[58,1,58,3],[24,35,24,37],[24,4,24,5],[24,6,24,7],[24,10,24,14],[24,15,24,16],[24,19,24,21],[24,17,24,18],[24,22,24,24],[24,25,24,30],[10,1,10,2],[29,1,29,3],[24,1,24,3],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[125,1,125,3],[32,1,32,3],[38,1,38,3],[45,1,45,3],[64,1,64,3],[72,1,72,3],[79,1,79,3],[86,1,86,3],[92,1,92,3],[99,1,99,3],[105,1,105,3],[112,1,112,3],[119,1,119,3]]}
[]
[null,"MONITORING DETAILS",null,null,null,null,"PROJECT DETAILS"]
[null,"Select up to 12 variables to be monitored in each home, using the drop down boxes below.",null,null,null,null,"Enter the size and duration of your project in the green cells below."]
[null,"Variables can be added multiple times, where several rooms will be monitored in each home."]
[null,{"$f":"IF(SUM(Data!AV6:DK6)>6,\"Note: Check that the data logger(s) can cope with the number of sensors\",\"\")","v":""},null,null,null,null,"No. of Homes Monitored",1000]
[null,"Temperature",null,null,null,null,"Monitoring Period (yrs)",2]
[null,"Temperature",null,null,null,null,"Internet Available?","No"]
[null,"Temperature",null,null,null,null,"Use Smart Meters?","No"]
[null,"Electricity"]
[null,"gas"]
[]
[null,"Electricity"]
[null,"Gas"]
[null,"Individual Appliance",null,null,null,null,null,null,null,0]
[null,"Multiple Appliances"]
[null,"PV",null,null,null,null,null,null,null,100000]
[null,"Temperature"]
[null,"Humidity"]
[null,"Light"]
[null,"Noise"]
[null,"Ventilation"]
[null,"Occupancy"]
[null,"CO2"]
[null,{"$f":"IF(AND(Data!BC8>0,Data!AV8=0),\"Note: Electrical metering is required if 'Multiple Appliances' are selected\",\"\")","v":""}]
[null,"PACKAGE",null,null,"PRODUCT",null,"SENSOR",null,"NUMBER","PREREQUISITES","COSTS",null,null,null,null,"CONNECTIONS",null,"DATA STORAGE",null,"MISC",null,null,"POWER",null,null,"DATA COLLECTION",null,null,null,null,null,"INSTALLATION",null,null,null,"MAINTENANCE",null,null,"NOTES"]
[null,"YEAR 1 COST (equipment +installation)","ONGOING ANNUAL COST (maintenance +replacement)","TOTAL COST (over whole study)","FAMILY","NAME","TYPE","DETAIL","PER HOME",null,"CAPITAL COST",null,null,null,"ANNUAL","WAN","LAN","LOCAL STORAGE","METHOD OF DATA EXTRACT","DIMENSIONS","FIXING ","COMMUNICATION WITH SMART METERS","TYPE","CLAIMED BATTERY LIFE","REMOTE BATTERY LOW LEVEL INDICATOR","REPORTING INTERVAL","TEMP ACCURACY","TEMP RANGE","TEMP RESOLUTION","HUMIDITY ACCURACY","CO2 ACCURACY","INSTALLATION ISSUES","INSTALL TIME RESEARCHER","INSTALL AND COMMISSION TIME GAS","INSTALL TIME ELECTRICIAN","MAINTENANCE CHECK TIME","BATTERY CHANGE TIME","ANNUAL REPLACEMENT RATE"]
[null,null,null,null,null,null,null,null,null,null,"INDIVIDUAL","BULK 1000 UNITS","BULK 5000 UNITS","BULK 10,000 UNITS"]
[null,"£/home","£/home per yr","£/home",null,null,null,null,null,null,"£/unit","£/unit","£/unit","£/unit","£/unit per yr",null,null,null,null,"mm"]
[null,"-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
[]
[]
[null,"PACKAGE 1"]
[null,683.67000000000007,119.77500000000001,803.45]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]
[null,142.19999999999999,12,154.19999999999999,"Zigbee HA","ZigBee HA Single Phase Power Clamp","Sensor","Electricity (clamp)",1,"Zigbee HA Gateway",120,"Not found","Not found","Not found",null,"n/a","Zigbee","n/a","n/a","Not found","Not found",null,"din rail","Not found","Not found","Not found","n/a","n/a","n/a","n/a","n/a",null,5,"-",15,"-","-",0.1]
[null,225.29999999999998,19.200000000000003,244.5,"Zigbee HA","ZigBee  multisensor ZHOT101","Sensor","Occupancy, Temperature & Light Sensor",3,"Zigbee HA Gateway",64,"Not found","Not found","Not found","n/a","n/a","Zigbee","n/a","n/a","106 x 61 x 54","free standing or use self adhesive pads?",null,"Battery CR123","5 yrs hourly reporting","Not found","Not found"," ± 0.5°C","0 to +50°C"," 0.1°C","n/a","n/a",null,10,"-","-","-","-",0.1]
[null,276.17,48.575000000000003,324.74,"Zigbee HA","Greenbox zigbee data logger ZC-GB-EM-UK","Logger","logger only",1,"Ethernet or sim card for GPRS",485.75,242.87,194.28,145.71,"n/a","Ethernet & GPRS","Zigbee","4Gb","FTP/EMAIL CSV","152 x 128 x 40","Din Rail",null,null,null,"Not found","min every 5 minutes","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,"PACKAGE 2"]
[null,680.22,129.97499999999999,810.2]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]
[null,142.19999999999999,12,154.19999999999999,"Zigbee HA","ZigBee HA Single Phase Power Clamp","Sensor","Electricity (clamp)",1,"Zigbee HA Gateway",120,"Not found","Not found","Not found",null,"n/a","Zigbee","n/a","n/a","Not found","Not found",null,"din rail","Not found","Not found","Not found","n/a","n/a","n/a","n/a","n/a",null,5,"-",15,"-","-",0.1]
[null,71.650000000000006,16.600000000000001,88.25,"Zigbee HA","ZigBee magnetic sensor ZHMS101","Sensor","Open close doors and windows\nTemperature",1,"Zigbee HA Gateway",55,"Not found","Not found","Not found","n/a","n/a","Zigbee","n/a","n/a","65 x 25 x 17 sensor\n65 x 17 x 17 magnet","screws or self adhesive pads",null,"Battery 2 x AAA","2 years reporting every 2 mins","Not found","Not found","Not found","0 to +50°C"," 0.1°C","n/a","n/a",null,15,"-","-","-",10,0.1]
[null,150.19999999999999,12.8,163,"Zigbee HA","ZigBee  multisensor ZHOT101","Sensor","Occupancy, Temperature & Light Sensor",2,"Zigbee HA Gateway",64,"Not found","Not found","Not found","n/a","n/a","Zigbee","n/a","n/a","106 x 61 x 54","free standing or use self adhesive pads?",null,"Battery CR123","5 yrs hourly reporting","Not found","Not found"," ± 0.5°C","0 to +50°C"," 0.1°C","n/a","n/a",null,10,"-","-","-","-",0.1]
[null,276.17,48.575000000000003,324.74,"Zigbee HA","Greenbox zigbee data logger ZC-GB-EM-UK","Logger","logger only",1,"Ethernet or sim card for GPRS",485.75,242.87,194.28,145.71,"n/a","Ethernet & GPRS","Zigbee","4Gb","FTP/EMAIL CSV","152 x 128 x 40","Din Rail",null,null,null,"Not found","min every 5 minutes","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,"PACKAGE 3"]
[null,679.62,161.92500000000001,841.55]
[null,158.25,61.350000000000009,219.60000000000002,"HOBO","HOBO UA001 08","Sensor","External Temperature (Waterproof)",3,"A HOBOware Software Starter Kit, HOBO BASE-U-1 Optic Base Station (£63) and Coupler",38,36.1,34.200000000000003,32.299999999999997,"n/a","n/a","n/a","8K  memory\n6.5K  readings","Data download via Optic USB (IR) Base Station and\nPendant Coupler","58 x 33 x 23","Integral eyelet (3mm hole) for easy mounting &\nsecuring",null,"Battery","1 year ","Not found","32 sec to 4 hours","0.47ºC at 25ºC","-20° to 70°C","0.1°C ","n/a","n/a",null,15,"-","-",5,10,0.1,"Programmable Start time/date or Trigger Start onsite with magnet"]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]
[null,142.19999999999999,12,154.19999999999999,"Zigbee HA","ZigBee HA Single Phase Power Clamp","Sensor","Electricity (clamp)",1,"Zigbee HA Gateway",120,"Not found","Not found","Not found",null,"n/a","Zigbee","n/a","n/a","Not found","Not found",null,"din rail","Not found","Not found","Not found","n/a","n/a","n/a","n/a","n/a",null,5,"-",15,"-","-",0.1]
[null,276.17,48.575000000000003,324.74,"Zigbee HA","Greenbox zigbee data logger ZC-GB-EM-UK","Logger","logger only",1,"Ethernet or sim card for GPRS",485.75,242.87,194.28,145.71,"n/a","Ethernet & GPRS","Zigbee","4Gb","FTP/EMAIL CSV","152 x 128 x 40","Din Rail",null,null,null,"Not found","min every 5 minutes","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,63,0,63,"HOBO","A HOBOware Software Starter Kit, HOBO BASE-U-1 Optic Base Station (£63) and Coupler","Logger",null,1,"HOBO sensors",63,"Not found","Not found","Not found"]
[null,"PACKAGE 4"]
[null,699.27,153.97500000000002,853.25]
[null,240.89999999999998,53.400000000000006,294.29999999999995,"HOBO","HOBO UX100-001","All-in-one","Room Temperature",3,"HOBOware  (PC software)",67,63.65,60.3,56.95,"n/a","n/a","n/a","128 KB\n84,650 measurements","PC software and usb connector","36.6 x 59.4 x 15.2","Built-in magnets\nCommand strip\nDouble sided tape\nHook and Loop strap to mount to curved surface",null,"Battery","1 year @ log rate of 1 min and sampling interval of 15secs or >","Not found","1 sec to 18 hours","±0.21°C from 0° to 50°C","-20° to 70°C","0.024°C ","n/a","n/a","-",15,"-","-",5,5,0.1,"Reported monitioring interval drift, 5min interval can drift from 3 to 7 mins\nSoftware Pro £88\nSoftware Lite £40"]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]
[null,142.19999999999999,12,154.19999999999999,"Zigbee HA","ZigBee HA Single Phase Power Clamp","Sensor","Electricity (clamp)",1,"Zigbee HA Gateway",120,"Not found","Not found","Not found",null,"n/a","Zigbee","n/a","n/a","Not found","Not found",null,"din rail","Not found","Not found","Not found","n/a","n/a","n/a","n/a","n/a",null,5,"-",15,"-","-",0.1]
[null,276.17,48.575000000000003,324.74,"Zigbee HA","Greenbox zigbee data logger ZC-GB-EM-UK","Logger","logger only",1,"Ethernet or sim card for GPRS",485.75,242.87,194.28,145.71,"n/a","Ethernet & GPRS","Zigbee","4Gb","FTP/EMAIL CSV","152 x 128 x 40","Din Rail",null,null,null,"Not found","min every 5 minutes","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,"PACKAGE 5"]
[null,680.95,174.05,855]
[null,62.2,24.55,86.75,"Eltek","Eltek GC62 Pulse Counter","Sensor","Pulse counter transmitter from elec or gas but does not  have approval for Zone 2 Atex",1,"PR01 + RX250AL Logger",190,40,30,25,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Plug 6v-9v DC or\nBattery ","logging interval  > 5 mins then 2 years\n4 x LR6 AA","Not found","1 sec to 4 hours\n250 pulses per second \nmax 65,000 pulses per logging interval","n/a","n/a","n/a","n/a","n/a","Not atex zone 2 approved",10,10,"-","-",5,0.1,"Max 65,000 pulses per logging interval"]
[null,68.849999999999994,3,71.849999999999994,"Eltek","PRO1 (alernative would be the elsetr, which you add in series and has 2 pulse out options)","Sensor","Circuited based  - Energy pulse electric meter",1,"Eltek GC62 and RX250AL logger",30,30,20,15,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","1 unit wide din rail device","Fastened to exisiting unit inside or would have to add additional unit",null,"n/a","n/a","Not found",null,"n/a","n/a","n/a","n/a","n/a","Must be installed by qualified electrical engineer\nrequires technical understanding for set up eg set   = Maximum (32500)\n = Value per pulse (0.5Wh)",5,"-",30,"-","-",0.1]
[null,216.60000000000002,61.5,278.10000000000002,"Eltek","EltekGC10 without display","Sensor","Temperature, humidity",3,"RX250AL Logger",205,50,32,27,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Battery ","5 years","Not found","30 sec to 4 hours","±0.4°C (+5 to +40°C) \n±1.0°C (-20 to +80°C)","-30 to 65°C","0.1°C ","±2% (10 to 90%RH)\n±4% (0 to 100%RH)","n/a","Large case",20,"-","-","-","-",0.1,"Choose of white or metal colour"]
[null,333.3,85,418.3,"Eltek","RX250AL logger","Logger","Logger only",1,"Darca software",850,300,120,100,"n/a","3g modem with SIM built in  to logger /GSM/to PC via serial","Prop. (433 MHz)","250,000 readings","3rd party website or database set up specifically by Eltek (cost to this)","180 x 120 x 60","metal bracket that screws on to the wall and holds the logger - Eltek can make more screw",null,"plug","Backup battery 24 hours","Not found","30 sec to 4 hours","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,"PACKAGE 6"]
[null,693.87,163.42500000000001,857.3]
[null,105.5,40.900000000000006,146.4,"HOBO","HOBO UA001 08","Sensor","External Temperature (Waterproof)",2,"A HOBOware Software Starter Kit, HOBO BASE-U-1 Optic Base Station (£63) and Coupler",38,36.1,34.200000000000003,32.299999999999997,"n/a","n/a","n/a","8K  memory\n6.5K  readings","Data download via Optic USB (IR) Base Station and\nPendant Coupler","58 x 33 x 23","Integral eyelet (3mm hole) for easy mounting &\nsecuring",null,"Battery","1 year ","Not found","32 sec to 4 hours","0.47ºC at 25ºC","-20° to 70°C","0.1°C ","n/a","n/a",null,15,"-","-",5,10,0.1,"Programmable Start time/date or Trigger Start onsite with magnet"]
[null,67,21.950000000000003,88.95,"HOBO","HOBO UA001 64","Sensor","External Temperature (Waterproof)",1,"A HOBOware Software Starter Kit, HOBO BASE-U-1 Optic Base Station (£63) and Coupler",53,50.35,47.7,45.05,"n/a","n/a","n/a"," 64K memory\n 52K readings","Data download via Optic USB (IR) Base Station and\nPendant Coupler","58 x 33 x 23","Integral eyelet (3mm hole) for easy mounting &\nsecuring",null,"Battery","1 year ","Not found","33 sec to 4 hours","0.47ºC at 25ºC","-20° to 70°C","0.1°C ","n/a","n/a",null,15,"-","-",5,10,0.1,"Programmable Start time/date or Trigger Start onsite with magnet"]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]
[null,142.19999999999999,12,154.19999999999999,"Zigbee HA","ZigBee HA Single Phase Power Clamp","Sensor","Electricity (clamp)",1,"Zigbee HA Gateway",120,"Not found","Not found","Not found",null,"n/a","Zigbee","n/a","n/a","Not found","Not found",null,"din rail","Not found","Not found","Not found","n/a","n/a","n/a","n/a","n/a",null,5,"-",15,"-","-",0.1]
[null,276.17,48.575000000000003,324.74,"Zigbee HA","Greenbox zigbee data logger ZC-GB-EM-UK","Logger","logger only",1,"Ethernet or sim card for GPRS",485.75,242.87,194.28,145.71,"n/a","Ethernet & GPRS","Zigbee","4Gb","FTP/EMAIL CSV","152 x 128 x 40","Din Rail",null,null,null,"Not found","min every 5 minutes","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,63,0,63,"HOBO","A HOBOware Software Starter Kit, HOBO BASE-U-1 Optic Base Station (£63) and Coupler","Logger",null,1,"HOBO sensors",63,"Not found","Not found","Not found"]
[null,"PACKAGE 7"]
[null,685.95,175.55,861.5]
[null,62.2,24.55,86.75,"Eltek","Eltek GC62 Pulse Counter","Sensor","Pulse counter transmitter from elec or gas but does not  have approval for Zone 2 Atex",1,"PR01 + RX250AL Logger",190,40,30,25,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Plug 6v-9v DC or\nBattery ","logging interval  > 5 mins then 2 years\n4 x LR6 AA","Not found","1 sec to 4 hours\n250 pulses per second \nmax 65,000 pulses per logging interval","n/a","n/a","n/a","n/a","n/a","Not atex zone 2 approved",10,10,"-","-",5,0.1,"Max 65,000 pulses per logging interval"]
[null,68.849999999999994,3,71.849999999999994,"Eltek","PRO1 (alernative would be the elsetr, which you add in series and has 2 pulse out options)","Sensor","Circuited based  - Energy pulse electric meter",1,"Eltek GC62 and RX250AL logger",30,30,20,15,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","1 unit wide din rail device","Fastened to exisiting unit inside or would have to add additional unit",null,"n/a","n/a","Not found",null,"n/a","n/a","n/a","n/a","n/a","Must be installed by qualified electrical engineer\nrequires technical understanding for set up eg set   = Maximum (32500)\n = Value per pulse (0.5Wh)",5,"-",30,"-","-",0.1]
[null,77.2,22,99.2,"Eltek","Eltek GD10 (with display) \n","Sensor","Temperature, humidity",1,"RX250AL Logger",220,55,35,30,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Battery ","5 years","Not found","30 sec to 4 hours","±0.4°C (+5 to +40°C) \n±1.0°C (-20 to +80°C)","-30 to 65°C","0.1°C ","±2% (10 to 90%RH)\n±4% (0 to 100%RH)","n/a","Large case",20,"-","-","-","-",0.1,"Choose of white or metal colour"]
[null,144.4,41,185.4,"Eltek","EltekGC10 without display","Sensor","Temperature, humidity",2,"RX250AL Logger",205,50,32,27,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Battery ","5 years","Not found","30 sec to 4 hours","±0.4°C (+5 to +40°C) \n±1.0°C (-20 to +80°C)","-30 to 65°C","0.1°C ","±2% (10 to 90%RH)\n±4% (0 to 100%RH)","n/a","Large case",20,"-","-","-","-",0.1,"Choose of white or metal colour"]
[null,333.3,85,418.3,"Eltek","RX250AL logger","Logger","Logger only",1,"Darca software",850,300,120,100,"n/a","3g modem with SIM built in  to logger /GSM/to PC via serial","Prop. (433 MHz)","250,000 readings","3rd party website or database set up specifically by Eltek (cost to this)","180 x 120 x 60","metal bracket that screws on to the wall and holds the logger - Eltek can make more screw",null,"plug","Backup battery 24 hours","Not found","30 sec to 4 hours","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,"PACKAGE 8"]
[null,710.67000000000007,155.17500000000001,865.85]
[null,160.6,35.6,196.2,"HOBO","HOBO UX100-001","All-in-one","Room Temperature",2,"HOBOware  (PC software)",67,63.65,60.3,56.95,"n/a","n/a","n/a","128 KB\n84,650 measurements","PC software and usb connector","36.6 x 59.4 x 15.2","Built-in magnets\nCommand strip\nDouble sided tape\nHook and Loop strap to mount to curved surface",null,"Battery","1 year @ log rate of 1 min and sampling interval of 15secs or >","Not found","1 sec to 18 hours","±0.21°C from 0° to 50°C","-20° to 70°C","0.024°C ","n/a","n/a","-",15,"-","-",5,5,0.1,"Reported monitioring interval drift, 5min interval can drift from 3 to 7 mins\nSoftware Pro £88\nSoftware Lite £40"]
[null,91.7,19,110.7,"HOBO","HOBO UX100-003","All-in-one","Room Temperature, \nHumidity",1,"HOBOware  (PC software)",79,75.05,71.099999999999994,67.150000000000006,"n/a","n/a","n/a","128 KB\n84,650 measurements","PC software and usb connector","36.6 x 84.8 x 15.2","Built-in magnets\nCommand strip\nDouble sided tape\nHook and Loop strap to mount to curved surface",null,"Battery","1 year @ log rate of 1 min and sampling interval of 15secs or >","Not found","1 sec to 18 hours","±0.21°C from 0° to 50°C","-20° to 70°C","0.024°C ","±3.5% from 25% to 85%","n/a","-",15,"-","-",5,5,0.1,"Reported monitoring interval drift, 5min interval can drift from 3 to 7 mins\nSoftware Pro £88\nSoftware Lite £40"]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]
[null,142.19999999999999,12,154.19999999999999,"Zigbee HA","ZigBee HA Single Phase Power Clamp","Sensor","Electricity (clamp)",1,"Zigbee HA Gateway",120,"Not found","Not found","Not found",null,"n/a","Zigbee","n/a","n/a","Not found","Not found",null,"din rail","Not found","Not found","Not found","n/a","n/a","n/a","n/a","n/a",null,5,"-",15,"-","-",0.1]
[null,276.17,48.575000000000003,324.74,"Zigbee HA","Greenbox zigbee data logger ZC-GB-EM-UK","Logger","logger only",1,"Ethernet or sim card for GPRS",485.75,242.87,194.28,145.71,"n/a","Ethernet & GPRS","Zigbee","4Gb","FTP/EMAIL CSV","152 x 128 x 40","Din Rail",null,null,null,"Not found","min every 5 minutes","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,"PACKAGE 9"]
[null,712.05,183.05,895.1]
[null,68.849999999999994,3,71.849999999999994,"Eltek","PRO1 (alernative would be the elsetr, which you add in series and has 2 pulse out options)","Sensor","Circuited based  - Energy pulse electric meter",1,"Eltek GC62 and RX250AL logger",30,30,20,15,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","1 unit wide din rail device","Fastened to exisiting unit inside or would have to add additional unit",null,"n/a","n/a","Not found",null,"n/a","n/a","n/a","n/a","n/a","Must be installed by qualified electrical engineer\nrequires technical understanding for set up eg set   = Maximum (32500)\n = Value per pulse (0.5Wh)",5,"-",30,"-","-",0.1]
[null,93.300000000000011,33.549999999999997,126.85,"Eltek","Eltek GC62EX pulse counter","Sensor","Energy pulse for gas and electricity meters",1,"Electricity monitoring requires a PR01  monitor to connect to the gas meter part of this transmitter AND a  RX250AL Logger",280,60,40,35,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Battery lithuim"," 1 year logging every 5 mins could be greater if longer logging interval\nReplace only with Eltek battery","Not found","250 pulses per second \nmax 65,000 pulses per logging interval","n/a","n/a","n/a","n/a","n/a",null,10,"uncertain",20,"-",5,0.1,"Self-certified to Atex zone 2 requirement of IGEM /7A communication 1731. Can be installed by enginner, was used by Eon, who accepted this.\nBest to confirm with IGEM if  electricity and gas can be relayed using one transmitter."]
[null,216.60000000000002,61.5,278.10000000000002,"Eltek","EltekGC10 without display","Sensor","Temperature, humidity",3,"RX250AL Logger",205,50,32,27,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Battery ","5 years","Not found","30 sec to 4 hours","±0.4°C (+5 to +40°C) \n±1.0°C (-20 to +80°C)","-30 to 65°C","0.1°C ","±2% (10 to 90%RH)\n±4% (0 to 100%RH)","n/a","Large case",20,"-","-","-","-",0.1,"Choose of white or metal colour"]
[null,333.3,85,418.3,"Eltek","RX250AL logger","Logger","Logger only",1,"Darca software",850,300,120,100,"n/a","3g modem with SIM built in  to logger /GSM/to PC via serial","Prop. (433 MHz)","250,000 readings","3rd party website or database set up specifically by Eltek (cost to this)","180 x 120 x 60","metal bracket that screws on to the wall and holds the logger - Eltek can make more screw",null,"plug","Backup battery 24 hours","Not found","30 sec to 4 hours","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,"PACKAGE 10"]
[null,741.06999999999994,158.375,899.45]
[null,160.6,35.6,196.2,"HOBO","HOBO UX100-001","All-in-one","Room Temperature",2,"HOBOware  (PC software)",67,63.65,60.3,56.95,"n/a","n/a","n/a","128 KB\n84,650 measurements","PC software and usb connector","36.6 x 59.4 x 15.2","Built-in magnets\nCommand strip\nDouble sided tape\nHook and Loop strap to mount to curved surface",null,"Battery","1 year @ log rate of 1 min and sampling interval of 15secs or >","Not found","1 sec to 18 hours","±0.21°C from 0° to 50°C","-20° to 70°C","0.024°C ","n/a","n/a","-",15,"-","-",5,5,0.1,"Reported monitioring interval drift, 5min interval can drift from 3 to 7 mins\nSoftware Pro £88\nSoftware Lite £40"]
[null,122.10000000000001,22.200000000000003,144.30000000000001,"HOBO","HOBO UX100-011","All-in-one","Room Temperature, \nHumidity",1,"HOBOware  (PC software)",111,105.45,99.9,94.35,"n/a","n/a","n/a","128 KB\n84,650 measurements","PC software and usb connector","36.6 x 84.8 x 15.2","Built-in magnets\nCommand strip\nDouble sided tape\nHook and Loop strap to mount to curved surface",null,"Battery","1 year @ log rate of 1 min and sampling interval of 15secs or >","Not found","n/a","±0.21°C from 0° to 50°C","-20° to 70°C","0.024°C ","±2.5% from 10% to 90%","n/a","-",15,"-","-",5,5,0.1,"Software Pro £88\nSoftware Lite £40"]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]
[null,142.19999999999999,12,154.19999999999999,"Zigbee HA","ZigBee HA Single Phase Power Clamp","Sensor","Electricity (clamp)",1,"Zigbee HA Gateway",120,"Not found","Not found","Not found",null,"n/a","Zigbee","n/a","n/a","Not found","Not found",null,"din rail","Not found","Not found","Not found","n/a","n/a","n/a","n/a","n/a",null,5,"-",15,"-","-",0.1]
[null,276.17,48.575000000000003,324.74,"Zigbee HA","Greenbox zigbee data logger ZC-GB-EM-UK","Logger","logger only",1,"Ethernet or sim card for GPRS",485.75,242.87,194.28,145.71,"n/a","Ethernet & GPRS","Zigbee","4Gb","FTP/EMAIL CSV","152 x 128 x 40","Din Rail",null,null,null,"Not found","min every 5 minutes","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,"PACKAGE 11"]
[null,821.90000000000009,125.625,947.53]
[null,52.650000000000006,4.5,57.15,"Radio-tech","Radio-tech ecochirp","Sensor","Electricity (pulse)",1,"Radio-tech Wi5",45,36,32.4,30.78,"n/a","n/a","434MHz,","n/a","n/a","55 x 67 x 180","Clamp - Mounting bracket","ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,250.95000000000002,23.625,274.56,"Radio-tech","Radio-tech ecosense surface","Sensor","Wall Temperature",3,"Radio-tech Wi5",78.75,67,63,59,"n/a","n/a","434MHz,","n/a","n/a","Not found",null,"ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","0.3C","Not found","Not found","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,478.3,57.5,535.79999999999995,"Radio-tech","Radio-tech Wi5","Logger","Central data concentrator logger and transmitter",1,"Third party FTP (sim card)",575,445,400,380,"n/a","ethernet or GPRS","434MHz,","2GB","Configurable to 3rd party website by the the company, have own front end Portal for viewing the data and can export from this. Can store and make accessible. ","220 x 200 x 45","Wall mountable","No","Plug","back up battery 24 hours for logging only, need mains for transmission.","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",30,"n/a","n/a",0,"n/a",0.1,"GPRS sim card cost of the SIM tariff, bulk of 2 or 5 years"]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]
[null,"PACKAGE 12"]
[null,780.95,201.05,982]
[null,62.2,24.55,86.75,"Eltek","Eltek GC62 Pulse Counter","Sensor","Pulse counter transmitter from elec or gas but does not  have approval for Zone 2 Atex",1,"PR01 + RX250AL Logger",190,40,30,25,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Plug 6v-9v DC or\nBattery ","logging interval  > 5 mins then 2 years\n4 x LR6 AA","Not found","1 sec to 4 hours\n250 pulses per second \nmax 65,000 pulses per logging interval","n/a","n/a","n/a","n/a","n/a","Not atex zone 2 approved",10,10,"-","-",5,0.1,"Max 65,000 pulses per logging interval"]
[null,68.849999999999994,3,71.849999999999994,"Eltek","PRO1 (alernative would be the elsetr, which you add in series and has 2 pulse out options)","Sensor","Circuited based  - Energy pulse electric meter",1,"Eltek GC62 and RX250AL logger",30,30,20,15,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","1 unit wide din rail device","Fastened to exisiting unit inside or would have to add additional unit",null,"n/a","n/a","Not found",null,"n/a","n/a","n/a","n/a","n/a","Must be installed by qualified electrical engineer\nrequires technical understanding for set up eg set   = Maximum (32500)\n = Value per pulse (0.5Wh)",5,"-",30,"-","-",0.1]
[null,144.4,41,185.4,"Eltek","EltekGC10 without display","Sensor","Temperature, humidity",2,"RX250AL Logger",205,50,32,27,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Battery ","5 years","Not found","30 sec to 4 hours","±0.4°C (+5 to +40°C) \n±1.0°C (-20 to +80°C)","-30 to 65°C","0.1°C ","±2% (10 to 90%RH)\n±4% (0 to 100%RH)","n/a","Large case",20,"-","-","-","-",0.1,"Choose of white or metal colour"]
[null,172.2,47.5,219.7,"Eltek","Eltek GW47 CO2 sensor","Sensor","CO2, \nTemperature,\nHumdity",1,"RX250AL Logger",475,150,100,90,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Wall mounting screw on a backplate",null,"plug","Backup battery 100 hours","Not found","30 sec to 4 hours","±0.4°C (+5 to +40°C) \n±1.0°C (-20 to +80°C)","-30 to 65°C","0.1°C ","±2% (10 to 90%RH)\n±4% (0 to 100%RH)","±50ppm","Needs plug, large case",20,"-","-","-","-",0.1]
[null,333.3,85,418.3,"Eltek","RX250AL logger","Logger","Logger only",1,"Darca software",850,300,120,100,"n/a","3g modem with SIM built in  to logger /GSM/to PC via serial","Prop. (433 MHz)","250,000 readings","3rd party website or database set up specifically by Eltek (cost to this)","180 x 120 x 60","metal bracket that screws on to the wall and holds the logger - Eltek can make more screw",null,"plug","Backup battery 24 hours","Not found","30 sec to 4 hours","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,"PACKAGE 13"]
[null,864.90000000000009,131.75,996.65]
[null,52.650000000000006,4.5,57.15,"Radio-tech","Radio-tech ecochirp","Sensor","Electricity (pulse)",1,"Radio-tech Wi5",45,36,32.4,30.78,"n/a","n/a","434MHz,","n/a","n/a","55 x 67 x 180","Clamp - Mounting bracket","ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,126.65,14,140.65,"Radio-tech","Radio-tech ecosense internal","Sensor","Room Temperature, Humidity",1,"Radio-tech Wi5",140,110,99,94.05,"n/a","n/a","434MHz,","n/a","n/a","Not found",null,"ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","0.3C","-20 C to 65 C","Not found",1.7999999999999999E-2,"n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,167.3,15.75,183.04,"Radio-tech","Radio-tech ecosense surface","Sensor","Wall Temperature",2,"Radio-tech Wi5",78.75,67,63,59,"n/a","n/a","434MHz,","n/a","n/a","Not found",null,"ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","0.3C","Not found","Not found","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,478.3,57.5,535.79999999999995,"Radio-tech","Radio-tech Wi5","Logger","Central data concentrator logger and transmitter",1,"Third party FTP (sim card)",575,445,400,380,"n/a","ethernet or GPRS","434MHz,","2GB","Configurable to 3rd party website by the the company, have own front end Portal for viewing the data and can export from this. Can store and make accessible. ","220 x 200 x 45","Wall mountable","No","Plug","back up battery 24 hours for logging only, need mains for transmission.","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",30,"n/a","n/a",0,"n/a",0.1,"GPRS sim card cost of the SIM tariff, bulk of 2 or 5 years"]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]
[null,"PACKAGE 14"]
[null,910.08,96.781000000000006,1006.86]
[null,128.18,11.156000000000001,139.34,"Radio-tech","Radio-tech ecochirp","Sensor","Gas (pulse)",1,"Radio-tech Wi5",111.56,105.98,100.4,94.82,"n/a","n/a","434MHz,","n/a","n/a","Not found","Mounting bracket","ASL Holdings system company have a CAD and do bespoke systems","Battery","10years","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","Ecosafe VHF versin available in Zone 2 Atex acreditation",5,15,"n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,52.650000000000006,4.5,57.15,"Radio-tech","Radio-tech ecochirp","Sensor","Electricity (pulse)",1,"Radio-tech Wi5",45,36,32.4,30.78,"n/a","n/a","434MHz,","n/a","n/a","55 x 67 x 180","Clamp - Mounting bracket","ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,250.95000000000002,23.625,274.56,"Radio-tech","Radio-tech ecosense surface","Sensor","Wall Temperature",3,"Radio-tech Wi5",78.75,67,63,59,"n/a","n/a","434MHz,","n/a","n/a","Not found",null,"ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","0.3C","Not found","Not found","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,478.3,57.5,535.79999999999995,"Radio-tech","Radio-tech Wi5","Logger","Central data concentrator logger and transmitter",1,"Third party FTP (sim card)",575,445,400,380,"n/a","ethernet or GPRS","434MHz,","2GB","Configurable to 3rd party website by the the company, have own front end Portal for viewing the data and can export from this. Can store and make accessible. ","220 x 200 x 45","Wall mountable","No","Plug","back up battery 24 hours for logging only, need mains for transmission.","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",30,"n/a","n/a",0,"n/a",0.1,"GPRS sim card cost of the SIM tariff, bulk of 2 or 5 years"]
[null,"PACKAGE 15"]
[null,875.90000000000009,133.15,1009.05]
[null,52.650000000000006,4.5,57.15,"Radio-tech","Radio-tech ecochirp","Sensor","Electricity (pulse)",1,"Radio-tech Wi5",45,36,32.4,30.78,"n/a","n/a","434MHz,","n/a","n/a","55 x 67 x 180","Clamp - Mounting bracket","ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,137.65,15.4,153.05000000000001,"Radio-tech","Radio-tech ecosense external","Sensor","External Temperature, Humidity",1,"Radio-tech Wi5",154,121,108.9,103.45,"n/a","n/a","434MHz,","n/a","n/a","Not found",null,"ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","0.3C","-20 C to 65 C","Not found",1.7999999999999999E-2,"n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,167.3,15.75,183.04,"Radio-tech","Radio-tech ecosense surface","Sensor","Wall Temperature",2,"Radio-tech Wi5",78.75,67,63,59,"n/a","n/a","434MHz,","n/a","n/a","Not found",null,"ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","0.3C","Not found","Not found","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says"]
[null,478.3,57.5,535.79999999999995,"Radio-tech","Radio-tech Wi5","Logger","Central data concentrator logger and transmitter",1,"Third party FTP (sim card)",575,445,400,380,"n/a","ethernet or GPRS","434MHz,","2GB","Configurable to 3rd party website by the the company, have own front end Portal for viewing the data and can export from this. Can store and make accessible. ","220 x 200 x 45","Wall mountable","No","Plug","back up battery 24 hours for logging only, need mains for transmission.","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",30,"n/a","n/a",0,"n/a",0.1,"GPRS sim card cost of the SIM tariff, bulk of 2 or 5 years"]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]

{"sheet":"Report Packages","index":3,"n_rows":53,"n_cols":40,"rows_kept":53,"cut":false,"hidden":false,"merged":[[13,32,13,35],[13,36,13,38],[46,1,46,10],[47,1,47,2],[13,16,13,17],[13,18,13,19],[14,11,14,14],[13,1,13,3],[13,4,13,5],[13,6,13,7],[13,11,13,15],[32,1,32,2],[18,1,18,3],[21,1,21,10],[27,1,27,10],[22,1,22,2],[39,1,39,10],[40,1,40,2],[13,20,13,22],[13,23,13,25],[13,26,13,31],[28,1,28,2],[31,1,31,10]]}
[]
[null,"Electricity"]
[null,"Gas",null,null,null,null,null,null,null,null,0]
[null,"Appliances"]
[null,"PV",null,null,null,null,null,null,null,null,100000]
[null,"Temperature"]
[null,"Humidity"]
[null,"Light"]
[null,"Noise"]
[null,"Ventilation"]
[null,"Occupancy"]
[null,"CO2"]
[]
[null,"PACKAGE",null,null,"PRODUCT",null,"SENSOR",null,"NUMBER","TOTAL","PREREQUISITES","COSTS",null,null,null,null,"CONNECTIONS",null,"DATA STORAGE",null,"MISC",null,null,"POWER",null,null,"DATA COLLECTION",null,null,null,null,null,"INSTALLATION",null,null,null,"MAINTENANCE",null,null,"NOTES"]
[null,"YEAR 1 COST PER HOME (EQUIPMENT+       INSTALLATION*)","ONGOING YEARLY COST PER HOME (MAINTENANCE+       REPLACEMENT)","TOTAL COST PER HOME (WHOLE STUDY)","FAMILY","NAME","TYPE","DETAIL","PER HOME","COST",null,"CAPITAL COST",null,null,null,"ANNUAL","WAN","LAN","LOCAL STORAGE","METHOD OF DATA EXTRACT","DIMENSIONS","FIXING ","COMMUNICATION WITH SMART METERS","TYPE","CLAIMED BATTERY LIFE","REMOTE BATTERY LOW LEVEL INDICATOR","REPORTING INTERVAL","TEMP ACCURACY","TEMP RANGE","TEMP RESOLUTION","HUMIDITY ACCURACY","CO2 ACCURACY","INSTALLATION ISSUES","INSTALL TIME RESEARCHER","INSTALL AND COMMISSION TIME GAS","INSTALL TIME ELECTRICIAN","MAINTENANCE CHECK TIME","BATTERY CHANGE TIME","ANNUAL REPLACEMENT RATE"]
[null,null,null,null,null,null,null,null,null,null,null,"INDIVIDUAL","BULK 1000 UNITS","BULK 5000 UNITS","BULK 10,000 UNITS"]
[null,"£","£","£",null,null,null,null,null,null,null,"£/unit","£/unit","£/unit","£/unit","£/unit per yr",null,null,null,null,"mm"]
[null,"-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
[]
[]
[null,"PACKAGE 1a - MINIMUM MONITORING - INTERNET AVAILABLE"]
[null,"PACKAGE 1a"]
[null,{"$f":"B25+B26+B27","v":192.10000000000002},{"$f":"C25+C26+C27","v":15},{"$f":"D25+D26+D27","v":207.10000000000002}]
[null,77.650000000000006,7.5,85.15,{"$f":"Data!F21","v":"Current Cost"},{"$f":"Data!G21","v":"Current Cost Gateway, Transmitter and CT clamp"},{"$f":"Data!H21","v":"Sensor"},{"$f":"Data!I21","v":"Electricity (clamp) only 95% accuracy"},1,{"$f":"Data!K21","v":75},{"$f":"Data!J21","v":"The Gateway"},{"$f":"Data!K21","v":75},{"$f":"Data!L21","v":61},{"$f":"Data!M21","v":54},{"$f":"Data!N21","v":49},{"$f":"Data!O21","v":"n/a"},{"$f":"Data!P21","v":"n/a"},{"$f":"Data!Q21","v":"Prop. (433 MHz)"},{"$f":"Data!R21","v":"n/a"},{"$f":"Data!S21","v":"n/a"},{"$f":"Data!T21","v":"120 x 70 x 30"},{"$f":"Data!U21","v":"Clamp"},{"$f":"Data!V21","v":"n/a"},{"$f":"Data!W21","v":"Battery"},{"$f":"Data!X21","v":"7 years"},{"$f":"Data!Y21","v":"Low battery level sent by gateway"},{"$f":"Data!Z21","v":"6 secs or adjustable to longer period current standard every 5 mins"},{"$f":"Data!AA21","v":"n/a"},{"$f":"Data!AB21","v":"n/a"},{"$f":"Data!AC21","v":"n/a"},{"$f":"Data!AD21","v":"n/a"},{"$f":"Data!AE21","v":"n/a"},{"$f":"Data!AF21","v":"-"},{"$f":"Data!AG21","v":15},{"$f":"Data!AH21","v":"n/a"},{"$f":"Data!AI21","v":"n/a"},{"$f":"Data!AJ21","v":"-"},{"$f":"Data!AK21","v":"Householder can replace battery\nGateway send battery  level information"},{"$f":"Data!AL21","v":0.1},{"$f":"Data!AM21","v":"Usually every 5 minutes, but can adjust to as low as 6 second resolution, or higher, as requested before distribution."}]
[null,81.150000000000006,7.5,88.65,{"$f":"Data!F26","v":"Current Cost"},{"$f":"Data!G26","v":"Current Cost Temperature sensor"},{"$f":"Data!H26","v":"Sensor"},{"$f":"Data!I26","v":"Temperature"},3,null,{"$f":"Data!J26","v":"The Gateway"},{"$f":"Data!K26","v":25},{"$f":"Data!L26","v":21.5},{"$f":"Data!M26","v":19.5},{"$f":"Data!N26","v":17.5},{"$f":"Data!O26","v":"n/a"},{"$f":"Data!P26","v":"n/a"},{"$f":"Data!Q26","v":"Prop. (433 MHz)"},{"$f":"Data!R26","v":"n/a"},{"$f":"Data!S26","v":"n/a"},{"$f":"Data!T26","v":"70 x 65 x 25"},{"$f":"Data!U26","v":"Free standing"},{"$f":"Data!V26","v":"n/a"},{"$f":"Data!W26","v":"Battery "},{"$f":"Data!X26","v":"2 years"},{"$f":"Data!Y26","v":"Low battery level sent by gateway"},{"$f":"Data!Z26","v":"1 minute"},{"$f":"Data!AA26","v":"±0.5°C"},{"$f":"Data!AB26","v":"-20 to 60°C"},{"$f":"Data!AC26","v":"0.5°C "},{"$f":"Data!AD26","v":"n/a"},{"$f":"Data!AE26","v":"n/a"},{"$f":"Data!AF26","v":"-"},{"$f":"Data!AG26","v":5},{"$f":"Data!AH26","v":"-"},{"$f":"Data!AI26","v":"n/a"},{"$f":"Data!AJ26","v":"-"},{"$f":"Data!AK26","v":"Householder can replace battery\nGateway send battery  level information"},{"$f":"Data!AL26","v":0.1},{"$f":"Data!AM26","v":"Usually every 5 minutes, but can adjust to as low as 6 second resolution, or higher, as requested before distribution."}]
[null,33.300000000000004,0,33.299999999999997,{"$f":"Data!F27","v":"Current Cost"},{"$f":"Data!G27","v":"The Gateway"},{"$f":"Data!H27","v":"Logger"},{"$f":"Data!I27","v":"Send the data straight to Decc or current cost or third party api"},1,null,{"$f":"Data!J27","v":"Internet connected house"},{"$f":"Data!K27","v":"Comes as part of the CT or optismart transmitter/sensor"},{"$f":"Data!L27","v":"Comes as part of the CT or optismart transmitter/sensor"},{"$f":"Data!M27","v":"Comes as part of the CT or optismart transmitter/sensor"},{"$f":"Data!N27","v":"Comes as part of the CT or optismart transmitter/sensor"},{"$f":"Data!O27","v":"n/a as long as data going to 3rd party"},{"$f":"Data!P27","v":"Ethernet"},{"$f":"Data!Q27","v":"Prop. (433 MHz)"},{"$f":"Data!R27","v":"36 hours data storage, depending on resolution of data"},{"$f":"Data!S27","v":"3rd party website or own IP address or CurrentCost could host it a cost would be involved."},{"$f":"Data!T27","v":"110 x 22 x 80"},{"$f":"Data!U27","v":"Free standing"},{"$f":"Data!V27","v":"They have started one but put on hold until smart meter role out actually happens"},{"$f":"Data!W27","v":"Plug"},{"$f":"Data!X27","v":"no back up battery"},{"$f":"Data!Y27","v":"n/a"},{"$f":"Data!Z27","v":"6 secs or adjustable to longer period current standard every 5 mins"},{"$f":"Data!AA27","v":"n/a"},{"$f":"Data!AB27","v":"n/a"},{"$f":"Data!AC27","v":"n/a"},{"$f":"Data!AD27","v":"Future humidity sensor planned or would develop on request, cost would be the same as for the temperature sensor"},{"$f":"Data!AE27","v":"Future CO2 sensor planned or would develp on request"},{"$f":"Data!AF27","v":"-"},{"$f":"Data!AG27","v":30},{"$f":"Data!AH27","v":"-"},{"$f":"Data!AI27","v":"n/a"},{"$f":"Data!AJ27","v":"-"},{"$f":"Data!AK27","v":"n/a"},{"$f":"Data!AL27","v":0.1},{"$f":"Data!AM27","v":"Usually every 5 minutes, but can adjust to as low as 6 second resolution, or higher, as requested before distribution."}]
[null,"PACKAGE 1b - MINIMUM MONITORING - NO INTERNET"]
[null,"PACKAGE 1b"]
[null,{"$f":"B31","v":240.89999999999998},{"$f":"C31","v":53.400000000000006},{"$f":"D31","v":294.29999999999995}]
[null,240.89999999999998,53.400000000000006,294.29999999999995,{"$f":"Data!F38","v":"HOBO"},{"$f":"Data!G38","v":"HOBO UX100-001"},{"$f":"Data!H38","v":"All-in-one"},{"$f":"Data!I38","v":"Room Temperature"},3,null,{"$f":"Data!J38","v":"HOBOware  (PC software)"},{"$f":"Data!K38","v":67},{"$f":"Data!L38","v":63.65},{"$f":"Data!M38","v":60.3},{"$f":"Data!N38","v":56.95},{"$f":"Data!O38","v":"n/a"},{"$f":"Data!P38","v":"n/a"},{"$f":"Data!Q38","v":"n/a"},{"$f":"Data!R38","v":"128 KB\n84,650 measurements"},{"$f":"Data!S38","v":"PC software and usb connector"},{"$f":"Data!T38","v":"36.6 x 59.4 x 15.2"},{"$f":"Data!U38","v":"Built-in magnets\nCommand strip\nDouble sided tape\nHook and Loop strap to mount to curved surface"},{"$f":"Data!V38","v":0},{"$f":"Data!W38","v":"Battery"},{"$f":"Data!X38","v":"1 year @ log rate of 1 min and sampling interval of 15secs or >"},{"$f":"Data!Y38","v":"Not found"},{"$f":"Data!Z38","v":"1 sec to 18 hours"},{"$f":"Data!AA38","v":"±0.21°C from 0° to 50°C"},{"$f":"Data!AB38","v":"-20° to 70°C"},{"$f":"Data!AC38","v":"0.024°C "},{"$f":"Data!AD38","v":"n/a"},{"$f":"Data!AE38","v":"n/a"},{"$f":"Data!AF38","v":"-"},{"$f":"Data!AG38","v":15},{"$f":"Data!AH38","v":"-"},{"$f":"Data!AI38","v":"-"},{"$f":"Data!AJ38","v":5},{"$f":"Data!AK38","v":5},{"$f":"Data!AL38","v":0.1},{"$f":"Data!AM38","v":"Reported monitioring interval drift, 5min interval can drift from 3 to 7 mins\nSoftware Pro £88\nSoftware Lite £40"}]
[null,"PACKAGE 2a - MEDIUM-PRIORITY VARIABLES - NO SMART METERS, WITH INTERNET"]
[null,"PACKAGE 2a"]
[null,{"$f":"SUM(B35:B39)","v":414.56},{"$f":"SUM(C35:C39)","v":93.850000000000009},{"$f":"SUM(D35:D39)","v":508.40999999999997}]
[null,40,40,80,{"$f":"Data!F54","v":"Smart Monitoring Systems"},{"$f":"Data!G54","v":"AMR"},{"$f":"Data!H54","v":"All-in-one"},{"$f":"Data!I54","v":"Gas (pulse)"},1,null,{"$f":"Data!J54","v":"none"},{"$f":"Data!K54","v":"No charge for device, which still belongs to Smart Monitoring Systems"},{"$f":"Data!L54","v":"No charge for device, which still belongs to Smart Monitoring Systems"},{"$f":"Data!M54","v":"No charge for device, which still belongs to Smart Monitoring Systems"},{"$f":"Data!N54","v":"No charge for device, which still belongs to Smart Monitoring Systems"},{"$f":"Data!O54","v":40},{"$f":"Data!P54","v":"GPRS"},{"$f":"Data!Q54","v":"n/a"},{"$f":"Data!R54","v":"n/a"},{"$f":"Data!S54","v":"3rd party email "},{"$f":"Data!T54","v":"n/a"},{"$f":"Data!U54","v":"Replacement meter"},{"$f":"Data!V54","v":0},{"$f":"Data!W54","v":"Not found"},{"$f":"Data!X54","v":"Not found"},{"$f":"Data!Y54","v":"Not found"},{"$f":"Data!Z54","v":"30 mins"},{"$f":"Data!AA54","v":"n/a"},{"$f":"Data!AB54","v":"n/a"},{"$f":"Data!AC54","v":"n/a"},{"$f":"Data!AD54","v":"n/a"},{"$f":"Data!AE54","v":"n/a"},{"$f":"Data!AF54","v":"Carried out by Smart metering company charge £40 per year this includes installation cost"},{"$f":"Data!AG54","v":0},{"$f":"Data!AH54","v":0},{"$f":"Data!AI54","v":0},{"$f":"Data!AJ54","v":0},{"$f":"Data!AK54","v":"n/a"},{"$f":"Data!AL54","v":0.1},{"$f":"Data!AM54","v":"Fitted own meters"}]
[null,87.55,7.6000000000000005,95.15,{"$f":"Data!F64","v":"Zwave"},{"$f":"Data!G64","v":"Aeon Labs Clamp Power Meter one (100A)"},{"$f":"Data!H64","v":"Sensor"},{"$f":"Data!I64","v":"Electricity mains "},1,null,{"$f":"Data!J64","v":"Vera edge"},{"$f":"Data!K64","v":76},{"$f":"Data!L64","v":59.8},{"$f":"Data!M64","v":54.72},{"$f":"Data!N64","v":54.72},{"$f":"Data!O64","v":"n/a"},{"$f":"Data!P64","v":"n/a"},{"$f":"Data!Q64","v":"Zwave 868.42MHz"},{"$f":"Data!R64","v":"n/a"},{"$f":"Data!S64","v":"n/a"},{"$f":"Data!T64","v":"108 x 67 x 30mm"},{"$f":"Data!U64","v":"n/a"},{"$f":"Data!V64","v":0},{"$f":"Data!W64","v":"plug"},{"$f":"Data!X64","v":"n/a"},{"$f":"Data!Y64","v":"Not found"},{"$f":"Data!Z64","v":"instant  (W) accumulated (KWh)"},{"$f":"Data!AA64","v":"n/a"},{"$f":"Data!AB64","v":"n/a"},{"$f":"Data!AC64","v":"n/a"},{"$f":"Data!AD64","v":"n/a"},{"$f":"Data!AE64","v":"n/a"},{"$f":"Data!AF64","v":"will need mains supply available next to the meter"},{"$f":"Data!AG64","v":10},{"$f":"Data!AH64","v":"n/a"},{"$f":"Data!AI64","v":15},{"$f":"Data!AJ64","v":"-"},{"$f":"Data!AK64","v":"n/a"},{"$f":"Data!AL64","v":0.1},{"$f":"Data!AM64","v":"install time for electrician is to fit an electricity socket near the meter "}]
[null,134.25,31.35,165.60000000000002,{"$f":"Data!F60","v":"Zwave"},{"$f":"Data!G60","v":"Aeon MultiSensor (AEOEZW074)"},{"$f":"Data!H60","v":"Sensor"},{"$f":"Data!I60","v":"Temperature,humidity, light and motion"},3,null,{"$f":"Data!J60","v":"Vera Edge"},{"$f":"Data!K60","v":49},{"$f":"Data!L60","v":39.200000000000003},{"$f":"Data!M60","v":35.28},{"$f":"Data!N60","v":35.28},{"$f":"Data!O60","v":"n/a"},{"$f":"Data!P60","v":"n/a"},{"$f":"Data!Q60","v":"Zwave 868Mhz"},{"$f":"Data!R60","v":"n/a"},{"$f":"Data!S60","v":"n/a"},{"$f":"Data!T60","v":"75 (dia) x 57"},{"$f":"Data!U60","v":"Bracket "},{"$f":"Data!V60","v":0},{"$f":"Data!W60","v":"Plug USB power supply not supplied or Battery"},{"$f":"Data!X60","v":"1 year"},{"$f":"Data!Y60","v":"Not found"},{"$f":"Data!Z60","v":"reporting configurable\nsample 2 secs to 18 hours"},{"$f":"Data!AA60","v":"not known"},{"$f":"Data!AB60","v":"-20  to +50°C"},{"$f":"Data!AC60","v":" ± 1°C"},{"$f":"Data!AD60","v":"±5%"},{"$f":"Data!AE60","v":"n/a"},{"$f":"Data!AF60","v":0},{"$f":"Data!AG60","v":5},{"$f":"Data!AH60","v":"n/a"},{"$f":"Data!AI60","v":"n/a"},{"$f":"Data!AJ60","v":"-"},{"$f":"Data!AK60","v":5},{"$f":"Data!AL60","v":0.1},{"$f":"Data!AM60","v":"IP43 wet and dry conditions"}]
[null,146.76,14.9,161.66,{"$f":"Data!F63","v":"Zwave"},{"$f":"Data!G63","v":"Vera Edge (Zwave Plus 500 Series)"},{"$f":"Data!H63","v":"Logger"},{"$f":"Data!I63","v":"Logger only"},1,null,{"$f":"Data!J63","v":"Zwave sensors, Internet connected house"},{"$f":"Data!K63","v":149},{"$f":"Data!L63","v":113.46},{"$f":"Data!M63","v":102.11},{"$f":"Data!N63","v":102.11},{"$f":"Data!O63","v":"n/a"},{"$f":"Data!P63","v":"ethernet"},{"$f":"Data!Q63","v":"Z-Wave:"},{"$f":"Data!R63","v":"Flash Memory: 128 MB\nRAM Memory: 128 MB"},{"$f":"Data!S63","v":"API for data upload"},{"$f":"Data!T63","v":"116 x 95 x 44mm"},{"$f":"Data!U63","v":"Free standing"},{"$f":"Data!V63","v":0},{"$f":"Data!W63","v":"Plug"},{"$f":"Data!X63","v":"back up battery 4 x AA"},{"$f":"Data!Y63","v":"Not found"},{"$f":"Data!Z63","v":"n/a"},{"$f":"Data!AA63","v":"n/a"},{"$f":"Data!AB63","v":"n/a"},{"$f":"Data!AC63","v":"n/a"},{"$f":"Data!AD63","v":"n/a"},{"$f":"Data!AE63","v":"n/a"},{"$f":"Data!AF63","v":"uk plug adaptor needed (provided)"},{"$f":"Data!AG63","v":30},{"$f":"Data!AH63","v":"n/a"},{"$f":"Data!AI63","v":"n/a"},{"$f":"Data!AJ63","v":"-"},{"$f":"Data!AK63","v":"n/a"},{"$f":"Data!AL63","v":0.1},{"$f":"Data!AM63","v":"Researcher from Defacto says very reliable"}]
[null,6,"-",{"$f":"B39","v":6},"-","Extension cable",null,null,1]
[null,"PACKAGE 2b - MEDIUM-PRIORITY VARIABLES - NO SMART METERS, NO INTERNET"]
[null,"PACKAGE 2b"]
[null,{"$f":"SUM(B43:B46)","v":683.67000000000007},{"$f":"SUM(C43:C46)","v":119.77500000000001},{"$f":"SUM(D43:D46)","v":803.44}]
[null,40,40,80,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)",1,"PR01 + RX250AL Logger","none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters"]
[null,142.19999999999999,12,154.19999999999999,"Zigbee HA","ZigBee HA Single Phase Power Clamp","Sensor","Electricity (clamp)",3,"RX250AL Logger","Zigbee HA Gateway",120,"Not found","Not found","Not found",null,"n/a","Zigbee","n/a","n/a","Not found","Not found",null,"din rail","Not found","Not found","Not found","n/a","n/a","n/a","n/a","n/a",null,5,"-",15,"-","-",0.1]
[null,225.29999999999998,19.200000000000003,244.5,"Zigbee HA","ZigBee  multisensor ZHOT101","Sensor","Occupancy, Temperature & Light Sensor",null,null,"Zigbee HA Gateway",64,"Not found","Not found","Not found","n/a","n/a","Zigbee","n/a","n/a","106 x 61 x 54","free standing or use self adhesive pads?",null,"Battery CR123","5 yrs hourly reporting","Not found","Not found"," ± 0.5°C","0 to +50°C"," 0.1°C","n/a","n/a",null,10,"-","-","-","-",0.1]
[null,276.17,48.575000000000003,324.74,"Zigbee HA","Greenbox zigbee data logger ZC-GB-EM-UK","Logger","logger only",1,"Darca software","Ethernet or sim card for GPRS",485.75,242.87,194.28,145.71,"n/a","Ethernet & GPRS","Zigbee","4Gb","FTP/EMAIL CSV","152 x 128 x 40","Din Rail",null,null,null,"Not found","min every 5 minutes","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1]
[null,"PACKAGE 3 - MEDIUM-PRIORITY VARIABLES - WITH SMART METERS"]
[null,"PACKAGE 3"]
[null,{"$f":"SUM(B50:B51)","v":265.89999999999998},{"$f":"SUM(C50:C51)","v":53.400000000000006},{"$f":"SUM(D50:D51)","v":319.29999999999995}]
[null,240.89999999999998,53.400000000000006,294.29999999999995,{"$f":"Data!F39","v":"HOBO"},{"$f":"Data!G39","v":"HOBO UX100-003"},{"$f":"Data!H39","v":"All-in-one"},{"$f":"Data!I39","v":"Room Temperature, \nHumidity"},3,null,{"$f":"Data!J39","v":"HOBOware  (PC software)"},{"$f":"Data!K39","v":79},{"$f":"Data!L39","v":75.05},{"$f":"Data!M39","v":71.099999999999994},{"$f":"Data!N39","v":67.150000000000006},{"$f":"Data!O39","v":"n/a"},{"$f":"Data!P39","v":"n/a"},{"$f":"Data!Q39","v":"n/a"},{"$f":"Data!R39","v":"128 KB\n84,650 measurements"},{"$f":"Data!S39","v":"PC software and usb connector"},{"$f":"Data!T39","v":"36.6 x 84.8 x 15.2"},{"$f":"Data!U39","v":"Built-in magnets\nCommand strip\nDouble sided tape\nHook and Loop strap to mount to curved surface"},{"$f":"Data!V39","v":0},{"$f":"Data!W39","v":"Battery"},{"$f":"Data!X39","v":"1 year @ log rate of 1 min and sampling interval of 15secs or >"},{"$f":"Data!Y39","v":"Not found"},{"$f":"Data!Z39","v":"1 sec to 18 hours"},{"$f":"Data!AA39","v":"±0.21°C from 0° to 50°C"},{"$f":"Data!AB39","v":"-20° to 70°C"},{"$f":"Data!AC39","v":"0.024°C "},{"$f":"Data!AD39","v":"±3.5% from 25% to 85%"},{"$f":"Data!AE39","v":"n/a"},{"$f":"Data!AF39","v":"-"},{"$f":"Data!AG39","v":15},{"$f":"Data!AH39","v":"-"},{"$f":"Data!AI39","v":"-"},{"$f":"Data!AJ39","v":5},{"$f":"Data!AK39","v":5},{"$f":"Data!AL39","v":0.1},{"$f":"Data!AM39","v":"Reported monitoring interval drift, 5min interval can drift from 3 to 7 mins\nSoftware Pro £88\nSoftware Lite £40"}]
[null,25,0,25,"Consumer access device","Electricity and gas through smart meter and CAD","Sensor","Electricity mains, gas",1,null,null,25,25,25,25,"n/a","n/a","Zigbee","unknown","From 3rd party logging service ","unknown","unknown","Yes","Unknown","Unknown","Unknown","Electricity 10 second, gas 30 minutes","n/a","n/a","n/a","n/a","n/a","Unknown","n/a","n/a","n/a",null,null,"n/a","There are no devices of this type available yet. **The cost here is an ESTIMATED cost, unlike other figures in the table.**"]
[]
[null,"*Assuming installer costs of £500/day"]

{"sheet":"Data","index":4,"n_rows":69,"n_cols":216,"rows_kept":69,"cut":false,"hidden":false,"merged":[[14,19,14,21],[14,22,14,24],[14,25,14,30],[14,31,14,34],[14,35,14,37],[14,17,14,18],[14,5,14,6],[14,7,14,8],[14,10,14,14],[15,10,15,13],[14,15,14,16]]}
[]
[null,null,null,"COLUMN USE","Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Space for more Data",null,null,null,null,"Background Data"]
[null,null,null,"COLUMN",5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TARGET",{"$f":"COUNTIF(Packages!$E$6:$E$11,AV17)+COUNTIF(Packages!$B$6:$B$11,AV17)","v":1},{"$f":"COUNTIF(Packages!$E$6:$E$11,AW17)+COUNTIF(Packages!$B$6:$B$11,AW17)","v":0},{"$f":"COUNTIF(Packages!$E$6:$E$11,AX17)+COUNTIF(Packages!$B$6:$B$11,AX17)","v":0},{"$f":"COUNTIF(Packages!$E$6:$E$11,AY17)+COUNTIF(Packages!$B$6:$B$11,AY17)","v":3},{"$f":"COUNTIF(Packages!$E$6:$E$11,AZ17)+COUNTIF(Packages!$B$6:$B$11,AZ17)","v":0},{"$f":"COUNTIF(Packages!$E$6:$E$11,BA17)+COUNTIF(Packages!$B$6:$B$11,BA17)","v":1},{"$f":"COUNTIF(Packages!$E$6:$E$11,BB17)+COUNTIF(Packages!$B$6:$B$11,BB17)","v":0},{"$f":"COUNTIF(Packages!$E$6:$E$11,BC17)+COUNTIF(Packages!$B$6:$B$11,BC17)","v":0},{"$f":"COUNTIF(Packages!$E$6:$E$11,BD17)+COUNTIF(Packages!$B$6:$B$11,BD17)","v":0},{"$f":"COUNTIF(Packages!$E$6:$E$11,BE17)+COUNTIF(Packages!$B$6:$B$11,BE17)","v":0},{"$f":"COUNTIF(Packages!$E$6:$E$11,BF17)+COUNTIF(Packages!$B$6:$B$11,BF17)","v":0},{"$f":"COUNTIF(Packages!$E$6:$E$11,BG17)+COUNTIF(Packages!$B$6:$B$11,BG17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"END?",{"$f":"SUM(AV11:BG11)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT",{"$f":"SUMPRODUCT($CX$20:$CX$69,AV$20:AV$69)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN",{"$f":"MIN(DB20:DB69)","v":80.000000000339995},null,"MAX",{"$f":"MAX(DG20:DG69)","v":0}]
[null,null,null,"MAX TOOLS",{"$f":"MAX(E20:E69)-1","v":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,null,null,null,null,null,null,null,null,null,null,null,null,"LEFT?",{"$f":"IF(AV8-AV9>0,1,0)","v":1},0,0,1,0,1,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEXT",{"$f":"IFERROR(MATCH(DB10,DB20:DB69,0)-1,0)","v":34},null,"LOCATION",{"$f":"MATCH(DE10,DG20:DG69,0)-1","v":1}]
[null,null,null,"NO. HOMES",{"$f":"Packages!H5","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXCESS?",{"$f":"IF(AV9-AV8>0,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INCL?","INCL?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance/Installation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEST",{"$f":"MAX(DM16:HH16)","v":15}]
[null,null,null,"NO. YEARS",{"$f":"Packages!H6","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIGHT?",{"$f":"IF(AND(AV9=AV8,AV9<>0),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Packages!H7=\"Yes\",1,0)","v":0},{"$f":"IF(Packages!H8=\"Yes\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,1.1100000000000001,null,null,null,"Note: The tiny value is added to the cost to simplify checking for duplicates in the system",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ONGOING COST PER HOME",{"$f":"IF(DM21=\"\",\"-\",SUMPRODUCT(DM20:DM69,$CS$20:$CS$69))","v":174.05},183.05,175.55,201.05,161.92500000000001,163.42500000000001,153.97500000000002,155.17500000000001,158.375,96.781000000000006,125.625,133.15,131.75,119.77500000000001,129.97499999999999,119.77500000000001,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(ES21=\"\",\"-\",SUMPRODUCT(ES20:ES69,$CS$20:$CS$69))","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(FY21=\"\",\"-\",SUMPRODUCT(FY20:FY69,$CS$20:$CS$69))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£/minute",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YEAR 1 COST PER HOME",{"$f":"IF(DM21=\"\",\"-\",SUMPRODUCT(DM20:DM69,$CR$20:$CR$69))","v":680.95},712.05,685.95,780.95,679.62,693.87,699.27,710.67000000000007,741.06999999999994,910.08,821.90000000000009,875.90000000000009,864.90000000000009,683.67000000000007,680.22,683.67000000000007,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(ES21=\"\",\"-\",SUMPRODUCT(ES20:ES69,$CR$20:$CR$69))","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(FY21=\"\",\"-\",SUMPRODUCT(FY20:FY69,$CR$20:$CR$69))","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,null,null,"REF","PRODUCT",null,"SENSOR",null,"PREREQUISITES","COSTS",null,null,null,null,"CONNECTIONS",null,"DATA STORAGE",null,"MISC",null,null,"POWER",null,null,"DATA COLLECTION",null,null,null,null,null,"INSTALLATION",null,null,null,"MAINTENANCE",null,null,"NOTES",null,null,null,null,null,"ORGANISED DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PREREQUISITE SENSORS/LOGGERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INELIGIBLE DUE TO REQUIRED SYSTEMS",null,null,null,null,null,null,null,"COST BREAKDOWN",null,null,null,null,null,null,null,null,null,null,null,null,null,"GROWING THE PACKAGES",null,null,null,null,null,null,"REMOVING EXCESS SENSORS",null,null,null,null,null,null,"UNIQUE",1,{"$f":"IF(COUNTIF($DM17:DN17,DN17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DO17,DO17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DP17,DP17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DQ17,DQ17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DR17,DR17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DS17,DS17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DT17,DT17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DU17,DU17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DV17,DV17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DW17,DW17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DX17,DX17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DY17,DY17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:DZ17,DZ17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:EA17,EA17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:EB17,EB17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EC17,EC17)=1,1,0)","v":1},{"$f":"IF(COUNTIF($DM17:ED17,ED17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EE17,EE17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EF17,EF17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EG17,EG17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EH17,EH17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EI17,EI17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EJ17,EJ17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EK17,EK17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EL17,EL17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EM17,EM17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EN17,EN17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EO17,EO17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EP17,EP17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EQ17,EQ17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:ER17,ER17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:ES17,ES17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:ET17,ET17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EU17,EU17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EV17,EV17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EW17,EW17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EX17,EX17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EY17,EY17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:EZ17,EZ17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FA17,FA17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FB17,FB17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FC17,FC17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FD17,FD17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FE17,FE17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FF17,FF17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FG17,FG17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FH17,FH17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FI17,FI17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FJ17,FJ17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FK17,FK17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FL17,FL17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FM17,FM17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FN17,FN17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FO17,FO17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FP17,FP17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FQ17,FQ17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FR17,FR17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FS17,FS17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FT17,FT17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FU17,FU17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FV17,FV17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FW17,FW17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FX17,FX17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FY17,FY17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:FZ17,FZ17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GA17,GA17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GB17,GB17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GC17,GC17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GD17,GD17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GE17,GE17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GF17,GF17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GG17,GG17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GH17,GH17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GI17,GI17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GJ17,GJ17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GK17,GK17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GL17,GL17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GM17,GM17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GN17,GN17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GO17,GO17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GP17,GP17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GQ17,GQ17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GR17,GR17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GS17,GS17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GT17,GT17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GU17,GU17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GV17,GV17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GW17,GW17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GX17,GX17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GY17,GY17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:GZ17,GZ17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:HA17,HA17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:HB17,HB17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:HC17,HC17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:HD17,HD17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:HE17,HE17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:HF17,HF17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:HG17,HG17)=1,1,0)","v":0},{"$f":"IF(COUNTIF($DM17:HH17,HH17)=1,1,0)","v":0}]
[null,null,null,null,"-","FAMILY","NAME","TYPE","DETAIL","-","CAPITAL COST",null,null,null,"ANNUAL","WAN","LAN","LOCAL STORAGE","METHOD OF DATA EXTRACT","DIMENSIONS","FIXING ","COMMUNICATION WITH SMART METERS","TYPE","CLAIMED BATTERY LIFE","REMOTE BATTERY LOW LEVEL INDICATOR","REPORTING INTERVAL","TEMP ACCURACY","TEMP RANGE","TEMP RESOLUTION","HUMIDITY ACCURACY","CO2 ACCURACY","INSTALLATION ISSUES","INSTALL TIME RESEARCHER","INSTALL AND COMMISSION TIME GAS","INSTALL TIME ELECTRICIAN","MAINTENANCE CHECK TIME","BATTERY CHANGE TIME","ANNUAL REPLACEMENT RATE","-",null,null,null,null,null,"TYPE",null,"SENSOR COVERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAIN",null,"ALTERNATIVE 1",null,"ALTERNATIVE 2",null,"ALTERNATIVE 3",null,"ALTERNATIVE 4",null,"NUMBER","VBA","OPTION",null,null,null,null,null,"INTERNET","SMART METER",null,null,"INELIGIBLE?",null,null,null,"COST DATA",null,null,null,"COST PER UNIT",null,null,"INSTALL TIME","OVERALL COST PER UNIT",null,null,null,null,null,"VBA BIT","COST","POTENTIAL",null,null,null,null,"EXCESS",null,null,null,null,null,null,"RANK",{"$f":"IFERROR(RANK(DM17,$DM$17:$HH$17,0),0)","v":11},{"$f":"IFERROR(RANK(DN17,$DM$17:$HH$17,0),0)","v":7},9,4,13,10,12,8,6,2,5,1,3,15,14,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(RANK(FZ17,$DM$17:$HH$17,0),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"-","-","-","-","-","-","INDIVIDUAL","BULK 1000","BULK 5000","BULK 10000","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,null,null,"Sensor","Logger","-","Electricity","Individual Appliance","CO2","Temperature","Humidity","Gas","Noise","Multiple Appliances","Occupancy","Light","Ventilation","PV",null,null,"SENSOR 1","SENSOR 2","SENSOR 1","SENSOR 2","SENSOR 1","SENSOR 2","SENSOR 1","SENSOR 2","SENSOR 1","SENSOR 2","-","OPTION","REF 1","REF 2","ROW 1","ROW 2",null,null,"-","-",null,null,"ITSELF","INCL PREREQ",null,null,"INDIVIDUAL","BULK 1000","BULK 5000","BULK 10000","CAPITAL COST","ANNUAL COST","ANNUAL REPLACEMENT","PER HOME","YEAR 1","ONGOING ANNUAL","TOTAL OVER STUDY","TOTAL",null,null,"CURRENT","PREREQ","SENSE","COST","COST PER ADDITIONAL SENSE",null,null,"RANK","PREREQ",null,null,null,null,null,"TOTAL COST PER HOME",{"$f":"IF(DM21=\"\",\"-\",SUMPRODUCT(DM20:DM69,$CU$20:$CU$69))","v":855.00000000067007},895.10000000068999,861.50000000065995,982.00000000067996,841.54500000201006,857.29500000202006,853.24500000161993,865.84500000163007,899.44500000163998,1006.86100000181,947.52500000188002,1009.05000000186,996.65000000187001,803.44500000222001,810.19500000221001,803.44500000222001,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(ES21=\"\",\"-\",SUMPRODUCT(ES20:ES69,$CU$20:$CU$69))","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(FY21=\"\",\"-\",SUMPRODUCT(FY20:FY69,$CU$20:$CU$69))","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,null,"UNITS","-","-","-","-","-","-","£/unit","£/unit","£/unit","£/unit","£/unit per yr","-","-","-","-","mm","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,"-","-","-","-","-","-","-","-",null,null,"-","-","-","-","-","-",null,null,"-","-",null,null,"-","-",null,null,"-","-","-","-","-","-","-","-","-","-","-","-",null,null,"NO. TOOLS","-","-","-","-",null,null,"-","USE",null,null,null,null,null,"UNNEEDED","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,null,"BACKGROUND","-","-","-","-","-","-",1,1000,5000,10000,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BL19:BM19)>0,1,0)+IF(SUM(BN19:BO19)>0,1,0)+IF(SUM(BP19:BQ19)>0,1,0)+IF(SUM(BJ19:BK19)>0,1,0)+IF(SUM(BR19:BS19)>0,1,0)","v":0},1,{"$f":"INDEX($BJ19:$BS19,0,($BU19*2)-1)","v":0},{"$f":"INDEX($BJ19:$BS19,0,($BU19*2))","v":0},{"$f":"IF(BV19=0,0,MATCH(BV19,$E$20:$E$69,0)-1)","v":0},{"$f":"IF(BW19=0,0,MATCH(BW19,$E$20:$E$69,0)-1)","v":0},null,null,{"$f":"IF(OR(AND(ISERROR(FIND(\"INTERNET\",UPPER(J19))),UPPER(P19)<>\"ETHERNET\"),CB$13=1),0,1)","v":0},{"$f":"IF(OR(CC$13=1,ISERROR(FIND(\"SMART METER\",UPPER(F19)))),0,1)","v":0},null,null,{"$f":"CB19+CC19","v":0},{"$f":"IF(IF(BV19>0,SUMIFS($CF$20:$CF$69,$E$20:$E$69,BV19),0)+IF(BW19>0,SUMIFS($CF$20:$CF$69,$E$20:$E$69,BW19),0)+CF19>0,1,0)","v":0},null,null,{"$f":"IF(ISNUMBER(K19),K19,0)","v":1},{"$f":"IF(ISNUMBER(L19),L19,CJ19)","v":1000},{"$f":"IF(ISNUMBER(M19),M19,CK19)","v":5000},{"$f":"IF(ISNUMBER(N19),N19,CL19)","v":10000},{"$f":"INDEX($CJ19:$CM19,0,MATCH($E$12,$CJ$19:$CM$19,1))","v":1000},{"$f":"IF(ISNUMBER(O19),O19,0)","v":0},{"$f":"IF(ISNUMBER(AL19),AL19,0)","v":0},{"$f":"SUMIF(AG19:AI19,\">0\")/60","v":0},{"$f":"CN19+(CQ19*60*$CQ$13)+CO19","v":1000},{"$f":"CO19+(CJ19*CP19)+(SUMIF(AJ19:AK19,\">0\")*$CQ$13)","v":0},{"$f":"CR19+(CS19*($E$13-1))","v":1000},{"$f":"CT19+(E19/(100000000*$E$12))","v":{"$error":"#VALUE!"}},null,null,0,{"$f":"SUMIFS($CU$20:$CU$69,$E$20:$E$69,$BV19,$CX$20:$CX$69,\"<>1\")+SUMIFS($CU$20:$CU$69,$E$20:$E$69,$BW19,$CX$20:$CX$69,\"<>1\")","v":0},{"$f":"IF(CG19=0,SUMPRODUCT(AV19:BG19,AV$11:BG$11),0)","v":0},{"$f":"IF(CZ19<>0,CU19+CY19,\"-\")","v":"-"},{"$f":"IF(CZ19<>0,DA19/CZ19,\"-\")","v":"-"},null,null,{"$f":"IF(AND($CX19>0,SUMPRODUCT($AV19:$BG19,$AV$12:$BG$12)>0,SUMPRODUCT($AV19:$BG19,$AV$13:$BG$13)=0),$CU19,0)","v":0},{"$f":"SUMIFS($CX$20:$CX$69,$BV$20:$BV$69,$E19,$DE$20:$DE$69,0)+SUMIFS($CX$20:$CX$69,$BW$20:$BW$69,$E19,$DE$20:$DE$69,0)","v":0},{"$f":"IF(DF19=0,DE19,0)","v":0},null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,null,null,1,"Current Cost","Current Cost Gateway, Transmitter and CT clamp","Sensor","Electricity (clamp) only 95% accuracy","The Gateway",75,61,54,49,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","120 x 70 x 30","Clamp","n/a","Battery","7 years","Low battery level sent by gateway","6 secs or adjustable to longer period current standard every 5 mins","n/a","n/a","n/a","n/a","n/a","-",15,"n/a","n/a","-","Householder can replace battery\nGateway send battery  level information",0.1,"Usually every 5 minutes, but can adjust to as low as 6 second resolution, or higher, as requested before distribution.",null,null,null,null,null,1,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,null,null,null,null,null,null,null,1,1,7,0,{"$f":"IF(BV21=0,0,MATCH(BV21,$E$20:$E$69,0)-1)","v":7},{"$f":"IF(BW21=0,0,MATCH(BW21,$E$20:$E$69,0)-1)","v":0},null,null,{"$f":"IF(OR(AND(ISERROR(FIND(\"INTERNET\",UPPER(J21))),UPPER(P21)<>\"ETHERNET\"),CB$13=1),0,1)","v":0},{"$f":"IF(OR(CC$13=1,ISERROR(FIND(\"SMART METER\",UPPER(F21)))),0,1)","v":0},null,null,{"$f":"CB21+CC21","v":0},{"$f":"IF(IF(BV21>0,SUMIFS($CF$20:$CF$69,$E$20:$E$69,BV21),0)+IF(BW21>0,SUMIFS($CF$20:$CF$69,$E$20:$E$69,BW21),0)+CF21>0,1,0)","v":1},null,null,{"$f":"IF(ISNUMBER(K21),K21,0)","v":75},{"$f":"IF(ISNUMBER(L21),L21,CJ21)","v":61},{"$f":"IF(ISNUMBER(M21),M21,CK21)","v":54},{"$f":"IF(ISNUMBER(N21),N21,CL21)","v":49},{"$f":"INDEX($CJ21:$CM21,0,MATCH($E$12,$CJ$19:$CM$19,1))","v":61},{"$f":"IF(ISNUMBER(O21),O21,0)","v":0},{"$f":"IF(ISNUMBER(AL21),AL21,0)","v":0.1},{"$f":"SUMIF(AG21:AI21,\">0\")/60","v":0.25},{"$f":"CN21+(CQ21*60*$CQ$13)+CO21","v":77.650000000000006},{"$f":"CO21+(CJ21*CP21)+(SUMIF(AJ21:AK21,\">0\")*$CQ$13)","v":7.5},{"$f":"CR21+(CS21*($E$13-1))","v":85.15},{"$f":"CT21+(E21/(100000000*$E$12))","v":85.15000000001001},null,null,0,{"$f":"SUMIFS($CU$20:$CU$69,$E$20:$E$69,$BV21,$CX$20:$CX$69,\"<>1\")+SUMIFS($CU$20:$CU$69,$E$20:$E$69,$BW21,$CX$20:$CX$69,\"<>1\")","v":33.300000000070007},{"$f":"IF(CG21=0,SUMPRODUCT(AV21:BG21,AV$11:BG$11),0)","v":0},{"$f":"IF(CZ21<>0,CU21+CY21,\"-\")","v":"-"},{"$f":"IF(CZ21<>0,DA21/CZ21,\"-\")","v":"-"},null,null,{"$f":"IF(AND($CX21>0,SUMPRODUCT($AV21:$BG21,$AV$12:$BG$12)>0,SUMPRODUCT($AV21:$BG21,$AV$13:$BG$13)=0),$CU21,0)","v":0},{"$f":"SUMIFS($CX$20:$CX$69,$BV$20:$BV$69,$E21,$DE$20:$DE$69,0)+SUMIFS($CX$20:$CX$69,$BW$20:$BW$69,$E21,$DE$20:$DE$69,0)","v":0},{"$f":"IF(DF21=0,DE21,0)","v":0},null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,2,"Current Cost","Current Cost  Gateway  with Optismart and transmitter ","Sensor","Electricity (pulse) 99.9% accuracy\nGas (pulse) 99.9% accuracy","The Gateway",85,71,64,59,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","80 x 30 x 30","Stick on meter and box sits alongside","n/a","Battery ","2 years","Low battery level sent by gateway","6 secs or adjustable to longer period current standard every 5 mins","n/a","n/a","n/a","n/a","n/a","Not Atex approved, Current Cost say not needed for domestic residences refer to Not by Tom Kane in email",15,15,"n/a","-","Householder can replace battery\nGateway send battery  level information",0.1,"Usually every 5 minutes, but can adjust to as low as 6 second resolution, or higher, as requested before distribution.",null,null,null,null,null,1,null,null,1,null,null,null,null,1,null,null,null,null,null,null,null,null,7,0,null,null,null,null,null,null,null,null,1,1,7,0,7,0,null,null,0,0,null,null,0,1,null,null,85,71,64,59,71,0,0.1,0.5,{"$f":"CN22+(CQ22*60*$CQ$13)+CO22","v":104.30000000000001},{"$f":"CO22+(CJ22*CP22)+(SUMIF(AJ22:AK22,\">0\")*$CQ$13)","v":8.5},{"$f":"CR22+(CS22*($E$13-1))","v":112.80000000000001},{"$f":"CT22+(E22/(100000000*$E$12))","v":112.80000000002001},null,null,0,33.300000000070007,{"$f":"IF(CG22=0,SUMPRODUCT(AV22:BG22,AV$11:BG$11),0)","v":0},"-",{"$f":"IF(CZ22<>0,DA22/CZ22,\"-\")","v":"-"},null,null,{"$f":"IF(AND($CX22>0,SUMPRODUCT($AV22:$BG22,$AV$12:$BG$12)>0,SUMPRODUCT($AV22:$BG22,$AV$13:$BG$13)=0),$CU22,0)","v":0},0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3,"Current Cost","Current Cost PV OptiSmart transmitter","Sensor","PV","The Gateway",27,23,20.5,19,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","80 x 30 x 30","Stick on meter and box sits alongside","n/a","Battery ","2 years","Low battery level sent by gateway","6 secs or adjustable to longer period current standard every 5 mins","n/a","n/a","n/a","n/a","n/a","-",15,"n/a","n/a",null,"Householder can replace battery\nGateway send battery  level information",0.1,"Usually every 5 minutes, but can adjust to as low as 6 second resolution, or higher, as requested before distribution.",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,7,0,null,null,null,null,null,null,null,null,1,1,7,0,7,0,null,null,0,0,null,null,0,1,null,null,27,23,20.5,19,23,0,0.1,0.25,39.650000000000006,2.7,42.350000000000009,42.350000000030008,null,null,0,33.300000000070007,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4,"Current Cost","CurrentCost IAM","Sensor","Plug - Indiviudal Appliance","The Gateway",17.5,15,14,12.5,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","63 x 126 x 50","n/a","n/a","plug","n/a","Low battery level sent by gateway","6 secs or adjustable to longer period current standard every 5 mins","n/a","n/a","n/a","n/a","n/a","-",5,"-","n/a","-","Householder can replace battery\nGateway send battery  level information",0.1,"Usually every 5 minutes, but can adjust to as low as 6 second resolution, or higher, as requested before distribution.",null,null,null,null,null,1,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,null,null,null,null,null,null,null,1,1,7,0,7,0,null,null,0,0,null,null,0,1,null,null,17.5,15,14,12.5,15,0,0.1,8.3333333333333329E-2,20.55,1.75,22.3,22.300000000040001,null,null,0,33.300000000070007,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,5,"Current Cost","Current Cost GaSmart transmitter","Sensor","Gas ","The Gateway",35,29,25,22,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","80 x 30 x 30","Stick on meter and box sits alongside","n/a","Battery ","2 years","Low battery level sent by gateway","30 seconds","n/a","n/a","n/a","n/a","n/a","Not Atex approved, Current Cost say not needed for domestic residences refer to Not by Tom Kane in email",15,10,"n/a","-","Householder can replace battery\nGateway send battery  level information",0.1,"Usually every 5 minutes, but can adjust to as low as 6 second resolution, or higher, as requested before distribution.",null,null,null,null,null,1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,7,0,null,null,null,null,null,null,null,null,1,1,7,0,7,0,null,null,0,0,null,null,0,1,null,null,35,29,25,22,29,0,0.1,0.41666666666666669,56.75,3.5,60.25,60.250000000050001,null,null,0,33.300000000070007,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,6,"Current Cost","Current Cost Temperature sensor","Sensor","Temperature","The Gateway",25,21.5,19.5,17.5,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","70 x 65 x 25","Free standing","n/a","Battery ","2 years","Low battery level sent by gateway","1 minute","±0.5°C","-20 to 60°C","0.5°C ","n/a","n/a","-",5,"-","n/a","-","Householder can replace battery\nGateway send battery  level information",0.1,"Usually every 5 minutes, but can adjust to as low as 6 second resolution, or higher, as requested before distribution.",null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,7,0,null,null,null,null,null,null,null,null,1,1,7,0,7,0,null,null,0,0,null,null,0,1,null,null,25,21.5,19.5,17.5,21.5,0,0.1,8.3333333333333329E-2,27.05,2.5,29.55,29.550000000059999,null,null,0,33.300000000070007,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,7,"Current Cost","The Gateway","Logger","Send the data straight to Decc or current cost or third party api","Internet connected house","Comes as part of the CT or optismart transmitter/sensor","Comes as part of the CT or optismart transmitter/sensor","Comes as part of the CT or optismart transmitter/sensor","Comes as part of the CT or optismart transmitter/sensor","n/a as long as data going to 3rd party","Ethernet","Prop. (433 MHz)","36 hours data storage, depending on resolution of data","3rd party website or own IP address or CurrentCost could host it a cost would be involved.","110 x 22 x 80","Free standing","They have started one but put on hold until smart meter role out actually happens","Plug","no back up battery","n/a","6 secs or adjustable to longer period current standard every 5 mins","n/a","n/a","n/a","Future humidity sensor planned or would develop on request, cost would be the same as for the temperature sensor","Future CO2 sensor planned or would develp on request","-",30,"-","n/a","-","n/a",0.1,"Usually every 5 minutes, but can adjust to as low as 6 second resolution, or higher, as requested before distribution.",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,1,0,null,null,1,1,null,null,0,0,0,0,0,0,0.1,0.5,33.300000000000004,0,33.300000000000004,33.300000000070007,null,null,0,0,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,8,"Eltek","Eltek GC62 Pulse Counter","Sensor","Pulse counter transmitter from elec or gas but does not  have approval for Zone 2 Atex","PR01 + RX250AL Logger",190,40,30,25,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Plug 6v-9v DC or\nBattery ","logging interval  > 5 mins then 2 years\n4 x LR6 AA","Not found","1 sec to 4 hours\n250 pulses per second \nmax 65,000 pulses per logging interval","n/a","n/a","n/a","n/a","n/a","Not atex zone 2 approved",10,10,"-","-",5,0.1,"Max 65,000 pulses per logging interval",null,null,null,null,null,1,null,null,1,null,null,null,null,1,null,null,null,null,null,null,null,null,9,14,null,null,null,null,null,null,null,null,1,1,9,14,9,14,null,null,0,0,null,null,0,0,null,null,190,40,30,25,40,0,0.1,0.33333333333333331,62.2,24.55,86.75,86.750000000079993,null,null,0,490.15000000023002,2,576.90000000031,288.450000000155,null,null,0,0,0,null,null,null,null,null,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,9,"Eltek","PRO1 (alernative would be the elsetr, which you add in series and has 2 pulse out options)","Sensor","Circuited based  - Energy pulse electric meter","Eltek GC62 and RX250AL logger",30,30,20,15,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","1 unit wide din rail device","Fastened to exisiting unit inside or would have to add additional unit",null,"n/a","n/a","Not found",null,"n/a","n/a","n/a","n/a","n/a","Must be installed by qualified electrical engineer\nrequires technical understanding for set up eg set   = Maximum (32500)\n = Value per pulse (0.5Wh)",5,"-",30,"-","-",0.1,null,null,null,null,null,null,1,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,8,14,null,null,null,null,null,null,null,null,1,1,8,14,8,14,null,null,0,0,null,null,0,0,null,null,30,30,20,15,30,0,0.1,0.58333333333333337,68.849999999999994,3,71.849999999999994,71.850000000089992,null,null,0,505.05000000022,1,576.90000000031,576.90000000031,null,null,0,0,0,null,null,null,null,null,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,10,"Eltek","Eltek GC62EX pulse counter","Sensor","Energy pulse for gas and electricity meters","Electricity monitoring requires a PR01  monitor to connect to the gas meter part of this transmitter AND a  RX250AL Logger",280,60,40,35,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Battery lithuim"," 1 year logging every 5 mins could be greater if longer logging interval\nReplace only with Eltek battery","Not found","250 pulses per second \nmax 65,000 pulses per logging interval","n/a","n/a","n/a","n/a","n/a",null,10,"uncertain",20,"-",5,0.1,"Self-certified to Atex zone 2 requirement of IGEM /7A communication 1731. Can be installed by enginner, was used by Eon, who accepted this.\nBest to confirm with IGEM if  electricity and gas can be relayed using one transmitter.",null,null,null,null,null,1,null,null,1,null,null,null,null,1,null,null,null,null,null,null,null,null,9,14,null,null,null,null,null,null,null,null,1,1,9,14,9,14,null,null,0,0,null,null,0,0,null,null,280,60,40,35,60,0,0.1,0.5,93.300000000000011,33.549999999999997,126.85000000000001,126.85000000010001,null,null,0,490.15000000023002,2,617.00000000033003,308.50000000016502,null,null,0,0,0,null,null,null,null,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,11,"Eltek","Eltek GD10 (with display) \n","Sensor","Temperature, humidity","RX250AL Logger",220,55,35,30,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Battery ","5 years","Not found","30 sec to 4 hours","±0.4°C (+5 to +40°C) \n±1.0°C (-20 to +80°C)","-30 to 65°C","0.1°C ","±2% (10 to 90%RH)\n±4% (0 to 100%RH)","n/a","Large case",20,"-","-","-","-",0.1,"Choose of white or metal colour",null,null,null,null,null,1,null,null,null,null,null,1,1,null,null,null,null,null,null,null,null,null,14,0,null,null,null,null,null,null,null,null,1,1,14,0,14,0,null,null,0,0,null,null,0,0,null,null,220,55,35,30,55,0,0.1,0.33333333333333331,77.2,22,99.2,99.200000000110009,null,null,0,418.30000000014002,1,517.50000000025,517.50000000025,null,null,0,0,0,null,null,null,null,null,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,12,"Eltek","EltekGC10 without display","Sensor","Temperature, humidity","RX250AL Logger",205,50,32,27,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Bracket to hold to wall and tamper proof",null,"Battery ","5 years","Not found","30 sec to 4 hours","±0.4°C (+5 to +40°C) \n±1.0°C (-20 to +80°C)","-30 to 65°C","0.1°C ","±2% (10 to 90%RH)\n±4% (0 to 100%RH)","n/a","Large case",20,"-","-","-","-",0.1,"Choose of white or metal colour",null,null,null,null,null,1,null,null,null,null,null,1,1,null,null,null,null,null,null,null,null,null,14,0,null,null,null,null,null,null,null,null,1,1,14,0,14,0,null,null,0,0,null,null,0,0,null,null,205,50,32,27,50,0,0.1,0.33333333333333331,72.2,20.5,92.7,92.700000000119999,null,null,0,418.30000000014002,1,511.00000000026,511.00000000026,null,null,0,0,0,null,null,null,null,null,3,3,2,2,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,13,"Eltek","Eltek GW47 CO2 sensor","Sensor","CO2, \nTemperature,\nHumdity","RX250AL Logger",475,150,100,90,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","78 x 41 footprint","Wall mounting screw on a backplate",null,"plug","Backup battery 100 hours","Not found","30 sec to 4 hours","±0.4°C (+5 to +40°C) \n±1.0°C (-20 to +80°C)","-30 to 65°C","0.1°C ","±2% (10 to 90%RH)\n±4% (0 to 100%RH)","±50ppm","Needs plug, large case",20,"-","-","-","-",0.1,null,null,null,null,null,null,1,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,14,0,null,null,null,null,null,null,null,null,1,1,14,0,14,0,null,null,0,0,null,null,0,0,null,null,475,150,100,90,150,0,0.1,0.33333333333333331,172.2,47.5,219.7,219.70000000012999,null,null,0,418.30000000014002,1,638.00000000027001,638.00000000027001,null,null,0,0,0,null,null,null,null,null,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,14,"Eltek","RX250AL logger","Logger","Logger only","Darca software",850,300,120,100,"n/a","3g modem with SIM built in  to logger /GSM/to PC via serial","Prop. (433 MHz)","250,000 readings","3rd party website or database set up specifically by Eltek (cost to this)","180 x 120 x 60","metal bracket that screws on to the wall and holds the logger - Eltek can make more screw",null,"plug","Backup battery 24 hours","Not found","30 sec to 4 hours","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,0,0,null,null,0,0,null,null,850,300,120,100,300,0,0.1,0.5,333.3,85,418.3,418.30000000014002,null,null,0,0,0,"-","-",null,null,0,0,0,null,null,null,null,null,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,15,"Eltek","Individual appliance plug","Sensor","IAM including transmitter","RX250AL Logger",250,50,30,25,"n/a","n/a","Prop. (433 MHz)","n/a","n/a","50 x 90 x 35","plug in",null,"plug","n/a","Not found","30 sec to 4 hours","n/a","n/a","n/a","n/a","n/a",null,5,"-","-","-","-",0.1,null,null,null,null,null,null,1,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,14,0,null,null,null,null,null,null,null,null,1,1,14,0,14,0,null,null,0,0,null,null,0,0,null,null,250,50,30,25,50,0,0.1,8.3333333333333329E-2,55.55,25,80.55,80.550000000149993,null,null,0,418.30000000014002,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,16,"HOBO","HOBO UA001 08","Sensor","External Temperature (Waterproof)","A HOBOware Software Starter Kit, HOBO BASE-U-1 Optic Base Station (£63) and Coupler",38,{"$f":"K36-(K36*5/100)","v":36.1},{"$f":"K36-(K36*10/100)","v":34.200000000000003},{"$f":"K36-(K36*15/100)","v":32.299999999999997},"n/a","n/a","n/a","8K  memory\n6.5K  readings","Data download via Optic USB (IR) Base Station and\nPendant Coupler","58 x 33 x 23","Integral eyelet (3mm hole) for easy mounting &\nsecuring",null,"Battery","1 year ","Not found","32 sec to 4 hours","0.47ºC at 25ºC","-20° to 70°C","0.1°C ","n/a","n/a",null,15,"-","-",5,10,0.1,"Programmable Start time/date or Trigger Start onsite with magnet",null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,45,0,null,null,null,null,null,null,null,null,1,1,45,0,45,0,null,null,0,0,null,null,0,0,null,null,38,36.1,34.200000000000003,32.299999999999997,36.1,0,0.1,0.25,52.75,20.450000000000003,73.2,73.200000000160003,null,null,0,63.000000000450001,1,136.20000000061,136.20000000061,null,null,0,0,0,null,null,null,null,null,0,0,0,0,3,2,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,17,"HOBO","HOBO UA001 64","Sensor","External Temperature (Waterproof)","A HOBOware Software Starter Kit, HOBO BASE-U-1 Optic Base Station (£63) and Coupler",53,{"$f":"K37-(K37*5/100)","v":50.35},{"$f":"K37-(K37*10/100)","v":47.7},{"$f":"K37-(K37*15/100)","v":45.05},"n/a","n/a","n/a"," 64K memory\n 52K readings","Data download via Optic USB (IR) Base Station and\nPendant Coupler","58 x 33 x 23","Integral eyelet (3mm hole) for easy mounting &\nsecuring",null,"Battery","1 year ","Not found","33 sec to 4 hours","0.47ºC at 25ºC","-20° to 70°C","0.1°C ","n/a","n/a",null,15,"-","-",5,10,0.1,"Programmable Start time/date or Trigger Start onsite with magnet",null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,45,0,null,null,null,null,null,null,null,null,1,1,45,0,45,0,null,null,0,0,null,null,0,0,null,null,53,50.35,47.7,45.05,50.35,0,0.1,0.25,67,21.950000000000003,88.95,88.950000000170007,null,null,0,63.000000000450001,1,151.95000000062001,151.95000000062001,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,18,"HOBO","HOBO UX100-001","All-in-one","Room Temperature","HOBOware  (PC software)",67,{"$f":"K38-(K38*5/100)","v":63.65},{"$f":"K38-(K38*10/100)","v":60.3},{"$f":"K38-(K38*15/100)","v":56.95},"n/a","n/a","n/a","128 KB\n84,650 measurements","PC software and usb connector","36.6 x 59.4 x 15.2","Built-in magnets\nCommand strip\nDouble sided tape\nHook and Loop strap to mount to curved surface",null,"Battery","1 year @ log rate of 1 min and sampling interval of 15secs or >","Not found","1 sec to 18 hours","±0.21°C from 0° to 50°C","-20° to 70°C","0.024°C ","n/a","n/a","-",15,"-","-",5,5,0.1,"Reported monitioring interval drift, 5min interval can drift from 3 to 7 mins\nSoftware Pro £88\nSoftware Lite £40",null,null,null,null,null,1,1,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,0,0,null,null,0,0,null,null,67,63.65,60.3,56.95,63.65,0,0.1,0.25,80.3,17.8,98.1,98.100000000179989,null,null,0,0,1,98.100000000179989,98.100000000179989,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,3,2,2,0,0,0,0,0,0,0]
[null,null,null,null,19,"HOBO","HOBO UX100-003","All-in-one","Room Temperature, \nHumidity","HOBOware  (PC software)",79,{"$f":"K39-(K39*5/100)","v":75.05},{"$f":"K39-(K39*10/100)","v":71.099999999999994},{"$f":"K39-(K39*15/100)","v":67.150000000000006},"n/a","n/a","n/a","128 KB\n84,650 measurements","PC software and usb connector","36.6 x 84.8 x 15.2","Built-in magnets\nCommand strip\nDouble sided tape\nHook and Loop strap to mount to curved surface",null,"Battery","1 year @ log rate of 1 min and sampling interval of 15secs or >","Not found","1 sec to 18 hours","±0.21°C from 0° to 50°C","-20° to 70°C","0.024°C ","±3.5% from 25% to 85%","n/a","-",15,"-","-",5,5,0.1,"Reported monitoring interval drift, 5min interval can drift from 3 to 7 mins\nSoftware Pro £88\nSoftware Lite £40",null,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,0,0,null,null,0,0,null,null,79,75.05,71.099999999999994,67.150000000000006,75.05,0,0.1,0.25,91.7,19,110.7,110.70000000019,null,null,0,0,1,110.70000000019,110.70000000019,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0]
[null,null,null,null,20,"HOBO","HOBO UX100-011","All-in-one","Room Temperature, \nHumidity","HOBOware  (PC software)",111,{"$f":"K40-(K40*5/100)","v":105.45},{"$f":"K40-(K40*10/100)","v":99.9},{"$f":"K40-(K40*15/100)","v":94.35},"n/a","n/a","n/a","128 KB\n84,650 measurements","PC software and usb connector","36.6 x 84.8 x 15.2","Built-in magnets\nCommand strip\nDouble sided tape\nHook and Loop strap to mount to curved surface",null,"Battery","1 year @ log rate of 1 min and sampling interval of 15secs or >","Not found","n/a","±0.21°C from 0° to 50°C","-20° to 70°C","0.024°C ","±2.5% from 10% to 90%","n/a","-",15,"-","-",5,5,0.1,"Software Pro £88\nSoftware Lite £40",null,null,null,null,null,1,1,null,null,null,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,0,0,null,null,0,0,null,null,111,105.45,99.9,94.35,105.45,0,0.1,0.25,122.10000000000001,22.200000000000003,144.30000000000001,144.30000000020001,null,null,0,0,1,144.30000000020001,144.30000000020001,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0]
[null,null,null,null,21,"Magpeye","Magpeye Ferro","Sensor","Gas (mechanical) Atex approved","Data logger or BMS digital uploads data to cloud",159.75,{"$f":"K41-(K41*18/100)","v":130.995},{"$f":"K41-(K41*21/100)","v":126.2025},{"$f":"K41-(K41*26/100)","v":118.215},"n/a","n/a","Hard wired to the gateway or hardwired to interface to give a modbus signal","n/a","CSV","65x82x30","Self adhesive pads reader  head, Device screwed to the wall",null,"Battery ","10 years","n/a","1 sec to 273 hrs","n/a","n/a","n/a","n/a","n/a","Atex approval must not cut output wire ",5,30,"n/a","-","-",0.1,"Reads the numerical disc/dial on the gas meter\n99% accuracy\nNot suitable for smart meter",null,null,null,null,null,1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,11,14,null,null,null,null,null,null,null,null,1,1,11,14,11,14,null,null,0,0,null,null,0,0,null,null,159.75,130.995,126.2025,118.215,130.995,0,0.1,0.58333333333333337,169.845,15.975000000000001,185.82,185.82000000021,null,null,0,517.50000000025,1,703.32000000046003,703.32000000046003,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,22,"Magpeye","Magpeye Opto","Sensor","Gas (pulse) Atex approved","Data logger or BMS digital uploads data to cloud",159.75,{"$f":"K42-(K42*18/100)","v":130.995},{"$f":"K42-(K42*21/100)","v":126.2025},{"$f":"K42-(K42*26/100)","v":118.215},"n/a","n/a","Hard wired to the gateway or hardwired to interface to give a modbus signal","n/a","CSV","65x82x30","Self adhesive pads reader  head, Device screwed to the wall",null,"Battery ","10 years","n/a","1 sec to 273 hrs","n/a","n/a","n/a","n/a","n/a","Atex approval must not cut output wire ",5,30,"n/a","-","-",0.1,"Reads the numerical disc/dial on the gas meter\n99% accuracy\nNot suitable for smart meter",null,null,null,null,null,1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,11,14,null,null,null,null,null,null,null,null,1,1,11,14,11,14,null,null,0,0,null,null,0,0,null,null,159.75,130.995,126.2025,118.215,130.995,0,0.1,0.58333333333333337,169.845,15.975000000000001,185.82,185.82000000022001,null,null,0,517.50000000025,1,703.32000000047003,703.32000000047003,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,23,"Netatmo","Netatmo weather station","All-in-one","External monitor  Temperature and humidity  and Internal monitor (room) temperature, humidity, CO2 and noise","Internet-connected house",139,{"$f":"K43-(K43*20/100)","v":111.2},{"$f":"K43-(K43*20/100)","v":111.2},{"$f":"K43-(K43*25/100)","v":104.25},"n/a","ethernet","wifi 2.4GHz\nrange 100m","n/a","3rd party website & public API","Indoor  - 45 x 45 x 155\noutdoor - 45 x 45 x105","free standing or nail to wall for outside monitor",null,"2 x AAA batteries outside monitor, indoor usb wall adaptor","1 year","n/a","trigger"," +- 0.3°C","Indoor 0°C to 50°C\nOutdoor -40°C to 65°C ","0.1°C ","±3%","± 50ppm or ± 5%","Amazon reviewer  - Cons Sometimes disconnect for no reason and require resetting\nSome readings slightly off on the sensors,  Pros, works over a good distance, netatmo calibrate it, temp spot on to their mercury thermometer",10,"n/a","-","-",null,0.1,null,null,null,null,null,null,1,1,null,null,null,1,1,1,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,1,0,null,null,1,1,null,null,139,111.2,111.2,104.25,111.2,0,0.1,0.16666666666666666,122.30000000000001,13.9,136.20000000000002,136.20000000023001,null,null,0,0,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,24,"Netatmo","Netatmo weather station additional  Internal monitors (room)","All-in-one","Temperature, humidity, CO2 and noise","Internet-connected house",59,{"$f":"K44-(K44*20/100)","v":47.2},{"$f":"K44-(K44*20/100)","v":47.2},{"$f":"K44-(K44*25/100)","v":44.25},"n/a","n/a","wifi 2.4GHz\nrange 100m","n/a","n/a",null,"free standing",null,"Battery only","1 year","n/a","trigger"," +- 0.3°C","Indoor 0°C to 50°C","0.1°C ","±3%","± 50ppm or ± 5%",null,10,"n/a",null,null,null,null,null,null,null,null,null,null,1,1,null,null,null,1,1,1,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,1,0,null,null,1,1,null,null,59,47.2,47.2,44.25,47.2,0,0,0.16666666666666666,58.300000000000004,0,58.300000000000004,58.300000000240004,null,null,0,0,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,25,"Radio-tech","Radio-tech CO2 sensor","Sensor","CO2","Radio-tech Wi5",117.5,94.5,85.05,80.790000000000006,"n/a","n/a","434MHz, ","n/a","n/a","Not found","wall mount","ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","Not found","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says",null,null,null,null,null,1,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,33,0,null,null,null,null,null,null,null,null,1,1,33,0,33,0,null,null,0,0,null,null,0,0,null,null,117.5,94.5,85.05,80.790000000000006,94.5,0,0.1,0.25,111.15,11.75,122.9,122.90000000025,null,null,0,535.80000000032999,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,26,"Radio-tech","Radio-tech door/window sensor","Sensor","Contact","Radio-tech Wi5",80,70,65,60,"n/a","n/a","434MHz,","n/a","n/a","Not found","self adhesive pads","ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,33,0,null,null,null,null,null,null,null,null,1,1,33,0,33,0,null,null,0,0,null,null,0,0,null,null,80,70,65,60,70,0,0.1,0.25,86.65,8,94.65,94.650000000260007,null,null,0,535.80000000032999,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,27,"Radio-tech","Radio-tech ecochirp","Sensor","Gas (pulse)","Radio-tech Wi5",111.56,105.98,100.4,94.82,"n/a","n/a","434MHz,","n/a","n/a","Not found","Mounting bracket","ASL Holdings system company have a CAD and do bespoke systems","Battery","10years","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","Ecosafe VHF versin available in Zone 2 Atex acreditation",5,15,"n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says",null,null,null,null,null,1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,33,0,null,null,null,null,null,null,null,null,1,1,33,0,33,0,null,null,0,0,null,null,0,0,null,null,111.56,105.98,100.4,94.82,105.98,0,0.1,0.33333333333333331,128.18,11.156000000000001,139.33600000000001,139.33600000027002,null,null,0,535.80000000032999,1,675.13600000060001,675.13600000060001,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0]
[null,null,null,null,28,"Radio-tech","Radio-tech ecochirp","Sensor","Electricity (pulse)","Radio-tech Wi5",45,36,32.4,30.78,"n/a","n/a","434MHz,","n/a","n/a","55 x 67 x 180","Clamp - Mounting bracket","ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says",null,null,null,null,null,1,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0,null,null,null,null,null,null,null,null,1,1,33,0,33,0,null,null,0,0,null,null,0,0,null,null,45,36,32.4,30.78,36,0,0.1,0.25,52.650000000000006,4.5,57.150000000000006,57.150000000280002,null,null,0,535.80000000032999,1,592.95000000060998,592.95000000060998,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0]
[null,null,null,null,29,"Radio-tech","Radio-tech ecosense external","Sensor","External Temperature, Humidity","Radio-tech Wi5",154,121,108.9,103.45,"n/a","n/a","434MHz,","n/a","n/a","Not found",null,"ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","0.3C","-20 C to 65 C","Not found",1.7999999999999999E-2,"n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says",null,null,null,null,null,1,null,null,null,null,null,1,1,null,null,null,null,null,null,null,null,null,33,0,null,null,null,null,null,null,null,null,1,1,33,0,33,0,null,null,0,0,null,null,0,0,null,null,154,121,108.9,103.45,121,0,0.1,0.25,137.65,15.4,153.05000000000001,153.05000000029,null,null,0,535.80000000032999,1,688.85000000061996,688.85000000061996,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,30,"Radio-tech","Radio-tech ecosense internal","Sensor","Room Temperature, Humidity","Radio-tech Wi5",140,110,99,94.05,"n/a","n/a","434MHz,","n/a","n/a","Not found",null,"ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","0.3C","-20 C to 65 C","Not found",1.7999999999999999E-2,"n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says",null,null,null,null,null,1,null,null,null,null,null,1,1,null,null,null,null,null,null,null,null,null,33,0,null,null,null,null,null,null,null,null,1,1,33,0,33,0,null,null,0,0,null,null,0,0,null,null,140,110,99,94.05,110,0,0.1,0.25,126.65,14,140.65,140.6500000003,null,null,0,535.80000000032999,1,676.45000000062998,676.45000000062998,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,null,null,null,31,"Radio-tech","Radio-tech ecosense surface","Sensor","Wall Temperature","Radio-tech Wi5",78.75,67,63,59,"n/a","n/a","434MHz,","n/a","n/a","Not found",null,"ASL Holdings system company have a CAD and do bespoke systems","Battery"," 5 years","Reports battery levels via gateway","1 min to 24 hours","0.3C","Not found","Not found","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says",null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,33,0,null,null,null,null,null,null,null,null,1,1,33,0,33,0,null,null,0,0,null,null,0,0,null,null,78.75,67,63,59,67,0,0.1,0.25,83.65,7.875,91.525000000000006,91.525000000310001,null,null,0,535.80000000032999,1,627.32500000063999,627.32500000063999,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,3,3,2,2,0,0,0]
[null,null,null,null,32,"Radio-tech","Radio-tech motion sensor","Sensor","Motion","Radio-tech Wi5",120,100,95,90,"n/a","n/a","434MHz,","n/a","n/a","Not found",null,"ASL Holdings system company have a CAD and do bespoke systems","Battery","Not found","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",15,"n/a","n/a",0,"Return to HMW for change",0.1,"Strict on battery life so expect to give what it says",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,33,0,null,null,null,null,null,null,null,null,1,1,33,0,33,0,null,null,0,0,null,null,0,0,null,null,120,100,95,90,100,0,0.1,0.25,116.65,12,128.65,128.65000000032001,null,null,0,535.80000000032999,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,33,"Radio-tech","Radio-tech Wi5","Logger","Central data concentrator logger and transmitter","Third party FTP (sim card)",575,445,400,380,"n/a","ethernet or GPRS","434MHz,","2GB","Configurable to 3rd party website by the the company, have own front end Portal for viewing the data and can export from this. Can store and make accessible. ","220 x 200 x 45","Wall mountable","No","Plug","back up battery 24 hours for logging only, need mains for transmission.","Reports battery levels via gateway","1 min to 24 hours","n/a","n/a","n/a","n/a","n/a","plug and play with some wifi setup programming",30,"n/a","n/a",0,"n/a",0.1,"GPRS sim card cost of the SIM tariff, bulk of 2 or 5 years",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,{"$f":"IF(OR(AND(ISERROR(FIND(\"INTERNET\",UPPER(J53))),UPPER(P53)<>\"ETHERNET\"),CB$13=1),0,1)","v":0},{"$f":"IF(OR(CC$13=1,ISERROR(FIND(\"SMART METER\",UPPER(F53)))),0,1)","v":0},null,null,0,0,null,null,{"$f":"IF(ISNUMBER(K53),K53,0)","v":575},{"$f":"IF(ISNUMBER(L53),L53,CJ53)","v":445},{"$f":"IF(ISNUMBER(M53),M53,CK53)","v":400},{"$f":"IF(ISNUMBER(N53),N53,CL53)","v":380},{"$f":"INDEX($CJ53:$CM53,0,MATCH($E$12,$CJ$19:$CM$19,1))","v":445},{"$f":"IF(ISNUMBER(O53),O53,0)","v":0},{"$f":"IF(ISNUMBER(AL53),AL53,0)","v":0.1},{"$f":"SUMIF(AG53:AI53,\">0\")/60","v":0.5},478.3,57.5,535.79999999999995,535.80000000032999,null,null,0,0,0,{"$f":"IF(CZ53<>0,CU53+CY53,\"-\")","v":"-"},"-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0]
[null,null,null,null,34,"Smart Monitoring Systems","AMR","All-in-one","Gas (pulse)","none","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems","No charge for device, which still belongs to Smart Monitoring Systems",40,"GPRS","n/a","n/a","3rd party email ","n/a","Replacement meter",null,"Not found","Not found","Not found","30 mins","n/a","n/a","n/a","n/a","n/a","Carried out by Smart metering company charge £40 per year this includes installation cost",0,0,0,0,"n/a",0.1,"Fitted own meters",null,null,null,null,null,1,1,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,0,40,0.1,0,40,40,80,80.000000000339995,null,null,0,0,1,80.000000000339995,80.000000000339995,null,null,0,0,0,null,null,null,null,null,0,0,0,0,1,1,1,1,1,0,1,1,1,1,1,1]
[null,null,null,null,35,"Zigbee HA","ZigBee HA Single Phase Power Clamp","Sensor","Electricity (clamp)","Zigbee HA Gateway",120,"Not found","Not found","Not found",null,"n/a","Zigbee","n/a","n/a","Not found","Not found",null,"din rail","Not found","Not found","Not found","n/a","n/a","n/a","n/a","n/a",null,5,"-",15,"-","-",0.1,null,null,null,null,null,null,1,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0,null,null,null,null,null,null,null,null,1,1,39,0,39,0,null,null,0,0,null,null,0,0,null,null,120,120,120,120,120,0,0.1,0.33333333333333331,142.19999999999999,12,154.19999999999999,154.20000000035,null,null,0,324.74500000039001,1,478.94500000074004,478.94500000074004,null,null,0,0,0,null,null,null,null,null,0,0,0,0,1,1,1,1,1,0,0,0,0,1,1,1]
[null,null,null,null,36,"Zigbee HA","Zigbee Smartplug ZHWR202-UK","Sensor","Individual appliance","Zigbee HA Gateway",81,"Not found","Not found","Not found","n/a","n/a","Zigbee","n/a","n/a","106 x 61 x 54 ","Plugs in to wall",null,"Plug","n/a","Not found","trigger","n/a","n/a","n/a","n/a","n/a",null,5,"-","-","-","-",0.1,null,null,null,null,null,null,1,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,39,0,null,null,null,null,null,null,null,null,1,1,39,0,39,0,null,null,0,0,null,null,0,0,null,null,81,81,81,81,81,0,0.1,8.3333333333333329E-2,86.55,8.1,94.649999999999991,94.650000000359995,null,null,0,324.74500000039001,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,37,"Zigbee HA","ZigBee magnetic sensor ZHMS101","Sensor","Open close doors and windows\nTemperature","Zigbee HA Gateway",55,"Not found","Not found","Not found","n/a","n/a","Zigbee","n/a","n/a","65 x 25 x 17 sensor\n65 x 17 x 17 magnet","screws or self adhesive pads",null,"Battery 2 x AAA","2 years reporting every 2 mins","Not found","Not found","Not found","0 to +50°C"," 0.1°C","n/a","n/a",null,15,"-","-","-",10,0.1,null,null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,null,null,1,null,null,null,39,0,null,null,null,null,null,null,null,null,1,1,39,0,39,0,null,null,0,0,null,null,0,0,null,null,55,55,55,55,55,0,0.1,0.25,71.650000000000006,16.600000000000001,88.25,88.250000000369994,null,null,0,324.74500000039001,1,412.99500000076,412.99500000076,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,null,null,null,38,"Zigbee HA","ZigBee  multisensor ZHOT101","Sensor","Occupancy, Temperature & Light Sensor","Zigbee HA Gateway",64,"Not found","Not found","Not found","n/a","n/a","Zigbee","n/a","n/a","106 x 61 x 54","free standing or use self adhesive pads?",null,"Battery CR123","5 yrs hourly reporting","Not found","Not found"," ± 0.5°C","0 to +50°C"," 0.1°C","n/a","n/a",null,10,"-","-","-","-",0.1,null,null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,1,1,null,null,null,null,39,0,null,null,null,null,null,null,null,null,1,1,39,0,39,0,null,null,0,0,null,null,0,0,null,null,64,64,64,64,64,0,0.1,0.16666666666666666,75.099999999999994,6.4,81.5,81.500000000379998,null,null,0,324.74500000039001,1,406.24500000077001,406.24500000077001,null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,3,2,3]
[null,null,null,null,39,"Zigbee HA","Greenbox zigbee data logger ZC-GB-EM-UK","Logger","logger only","Ethernet or sim card for GPRS",485.75,242.87,194.28,145.71,"n/a","Ethernet & GPRS","Zigbee","4Gb","FTP/EMAIL CSV","152 x 128 x 40","Din Rail",null,null,null,"Not found","min every 5 minutes","n/a","n/a","n/a","n/a","n/a",null,30,"-","-","-","-",0.1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,0,0,null,null,0,0,null,null,485.75,242.87,194.28,145.71,242.87,0,0.1,0.5,276.17,48.575000000000003,324.745,324.74500000039001,null,null,0,0,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,1,1,1,1,1,0,0,0,0,1,1,1]
[null,null,null,null,40,"Zwave","Aeon MultiSensor (AEOEZW074)","Sensor","Temperature,humidity, light and motion","Vera Edge",49,39.200000000000003,35.28,35.28,"n/a","n/a","Zwave 868Mhz","n/a","n/a","75 (dia) x 57","Bracket ",null,"Plug USB power supply not supplied or Battery","1 year","Not found","reporting configurable\nsample 2 secs to 18 hours","not known","-20  to +50°C"," ± 1°C","±5%","n/a",null,5,"n/a","n/a","-",5,0.1,"IP43 wet and dry conditions",null,null,null,null,null,1,null,null,null,null,null,1,1,null,null,null,1,1,null,null,null,null,43,0,null,null,null,null,null,null,null,null,1,1,43,0,43,0,null,null,0,0,null,null,0,1,null,null,49,39.200000000000003,35.28,35.28,39.200000000000003,0,0.1,8.3333333333333329E-2,44.75,10.450000000000001,55.2,55.200000000400003,null,null,0,161.66000000042999,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,41,"Zwave","TKB TZ88 UK Home Zwave smart plug","Sensor","Plug - Indiviudal Appliance","Vera Edge",38,30.4,27.36,27.36,"n/a","n/a","Zwave 868.4 MHz","n/a","n/a","50 x 50 x 18mm","n/a",null,"Plug","n/a","Not found","reporting configurable\nsample 2 secs to 18 hours","n/a","n/a","n/a","n/a","n/a",null,5,"n/a","n/a","-","n/a",0.1,null,null,null,null,null,null,1,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,43,0,null,null,null,null,null,null,null,null,1,1,43,0,43,0,null,null,0,0,null,null,0,1,null,null,38,30.4,27.36,27.36,30.4,0,0.1,8.3333333333333329E-2,35.950000000000003,3.8000000000000003,39.75,39.750000000409997,null,null,0,161.66000000042999,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,42,"Zwave"," Philio Multisensor - PIR / Light / Temp - Gen5","Sensor","Temperature, light, motion","Vera Edge",49,39.200000000000003,35.28,35.28,"n/a","n/a","Zwave 868.42MHz - v6.02","n/a","n/a","96 x 28 x 23","self adhesive pads",null,"Battery 1 x CR 123A","2 years ","Not found","reporting configurable\nsample 2 secs to 18 hours","Not found","-10 to +70°C","Not found","n/a","n/a",null,5,"n/a","n/a","-",5,0.1,"One review on Domotics website says temp seems to be recording high",null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,1,1,null,null,null,null,43,0,null,null,null,null,null,null,null,null,1,1,43,0,43,0,null,null,0,0,null,null,0,1,null,null,49,39.200000000000003,35.28,35.28,39.200000000000003,0,0.1,8.3333333333333329E-2,44.75,10.450000000000001,55.2,55.200000000420005,null,null,0,161.66000000042999,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,43,"Zwave","Vera Edge (Zwave Plus 500 Series)","Logger","Logger only","Zwave sensors, Internet connected house",149,113.46,102.11,102.11,"n/a","ethernet","Z-Wave:","Flash Memory: 128 MB\nRAM Memory: 128 MB","API for data upload","116 x 95 x 44mm","Free standing",null,"Plug","back up battery 4 x AA","Not found","n/a","n/a","n/a","n/a","n/a","n/a","uk plug adaptor needed (provided)",30,"n/a","n/a","-","n/a",0.1,"Researcher from Defacto says very reliable",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,1,0,null,null,1,1,null,null,149,113.46,102.11,102.11,113.46,0,0.1,0.5,146.76,14.9,161.66,161.66000000042999,null,null,0,0,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,44,"Zwave","Aeon Labs Clamp Power Meter one (100A)","Sensor","Electricity mains ","Vera edge",76,59.8,54.72,54.72,"n/a","n/a","Zwave 868.42MHz","n/a","n/a","108 x 67 x 30mm","n/a",null,"plug","n/a","Not found","instant  (W) accumulated (KWh)","n/a","n/a","n/a","n/a","n/a","will need mains supply available next to the meter",10,"n/a",15,"-","n/a",0.1,"install time for electrician is to fit an electricity socket near the meter ",null,null,null,null,null,1,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0,null,null,null,null,null,null,null,null,1,1,43,0,43,0,null,null,0,0,null,null,0,1,null,null,76,59.8,54.72,54.72,59.8,0,0.1,0.41666666666666669,87.55,7.6000000000000005,95.149999999999991,95.150000000439988,null,null,0,161.66000000042999,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,45,"HOBO","A HOBOware Software Starter Kit, HOBO BASE-U-1 Optic Base Station (£63) and Coupler","Logger",null,"HOBO sensors",63,"Not found","Not found","Not found",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,0,0,null,null,0,0,null,null,63,63,63,63,63,0,0,0,63,0,63,63.000000000450001,null,null,0,0,0,"-","-",null,null,0,0,0,null,null,null,null,null,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,47,"Smart meters","Gas through DCC","Sensor","Gas",null,"n/a","n/a","n/a","n/a",25,"n/a","n/a","n/a","from Data Communications Company","n/a","n/a",null,null,null,null,"30 minutes","n/a","n/a","n/a","n/a","n/a","n/a",null,"n/a","n/a",null,null,"n/a","Data provided through the planned Data Communications Company. Charges are unknown, ESTIMATED here at £25 per home.",null,null,null,null,null,1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,0,1,null,null,1,1,null,null,0,0,0,0,0,25,0,0,25,25,50,50.000000000470003,null,null,0,0,0,"-",{"$f":"IF(CZ66<>0,DA66/CZ66,\"-\")","v":"-"},null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,48,"Smart meters","Electricity through DCC","Sensor","Electricity mains ",null,"n/a","n/a","n/a","n/a",25,"n/a","n/a","n/a","from Data Communications Company","n/a","n/a",null,null,null,null,"30 minutes","n/a","n/a","n/a","n/a","n/a","n/a",null,"n/a","n/a",null,null,"n/a","Data provided through the planned Data Communications Company. Charges are unknown, ESTIMATED here at £25 per home.",null,null,null,null,null,1,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,null,null,0,1,null,null,1,1,null,null,0,0,0,0,0,25,0,0,25,25,50,50.00000000048,null,null,0,0,0,"-",{"$f":"IF(CZ67<>0,DA67/CZ67,\"-\")","v":"-"},null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,49,"Smart meters","Electricity and gas through smart meter and CAD","Sensor","Electricity mains, gas",null,25,25,25,25,"n/a","n/a","Zigbee","unknown","From 3rd party logging service ","unknown","unknown","Yes","Unknown","Unknown","Unknown","Electricity 10 second, gas 30 minutes","n/a","n/a","n/a","n/a","n/a","Unknown","n/a","n/a","n/a",null,null,"n/a","There are no devices of this type available yet. **The cost here is an ESTIMATED cost, unlike other figures in the table.**",null,null,null,null,null,1,null,null,1,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BL68:BM68)>0,1,0)+IF(SUM(BN68:BO68)>0,1,0)+IF(SUM(BP68:BQ68)>0,1,0)+IF(SUM(BJ68:BK68)>0,1,0)+IF(SUM(BR68:BS68)>0,1,0)","v":0},1,{"$f":"INDEX($BJ68:$BS68,0,($BU68*2)-1)","v":0},{"$f":"INDEX($BJ68:$BS68,0,($BU68*2))","v":0},0,0,null,null,0,1,null,null,1,1,null,null,25,25,25,25,25,0,0,0,25,0,25,25.000000000490001,null,null,0,0,0,"-",{"$f":"IF(CZ68<>0,DA68/CZ68,\"-\")","v":"-"},null,null,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]