I have designed a hardware solution to acquire values from 5 current sensors. I have 2 current sensors on my mains (L1 and L2) where the values are added(0-100A), 2 current sensors that are placed on 240VAC circuits (0-50A) and 1 current sensor that is placed on a 120VAC circuit (0-15A). This allows me to measure my overall instantaneous power consumption, the power consumption of my electric house heater and my water heater (each on their own 240VAC circuits) and the 120VAC circuit of my kitchen (lights, fridge, microwave, etc...).
The 5 current values are acquired as a digital value from 0 to 4095 and then the power is calculated from the voltage reading. For the main power consumption, the values are added. They are then inserted in a MySQL table where the fields are as follows:
The values here are in instantaneous power and they are inserted through a php script where I send a http get request with the sensors values passed as parameters in the http request.
Therefore, here is my question:
I am not very good in computer sciences and I have some difficulties understanding if EmonCMS is what I need. I wanted to have one graph showing the last 24 hours of power consumption and one graph / indicator / dial showing the cumulative power usage for the chosen period. I would also like to have other graphs showing different periods and different averages, but the first two indicators are the ones I really need.
So, can I use my MySQL table as a data source for the EmonCMS dashboard, and is that dashboard customizable enough for my needs?
Thank you for your time.
Also, if my question is not clear enough or I have not provided enough information about my project or my needs, I will gladly follow up with clarifications.
EmonCMS IoT Dashboard without OpenEnergyMonitor hardware
Submitted by Mrtowelie on Fri, 01/04/2016 - 01:03Hello all,
I have designed a hardware solution to acquire values from 5 current sensors. I have 2 current sensors on my mains (L1 and L2) where the values are added(0-100A), 2 current sensors that are placed on 240VAC circuits (0-50A) and 1 current sensor that is placed on a 120VAC circuit (0-15A). This allows me to measure my overall instantaneous power consumption, the power consumption of my electric house heater and my water heater (each on their own 240VAC circuits) and the 120VAC circuit of my kitchen (lights, fridge, microwave, etc...).
The 5 current values are acquired as a digital value from 0 to 4095 and then the power is calculated from the voltage reading. For the main power consumption, the values are added. They are then inserted in a MySQL table where the fields are as follows:
Index, SensorMain,Sensor240_1,Sensor240_2,Sensor120_1, Timestamp
The values here are in instantaneous power and they are inserted through a php script where I send a http get request with the sensors values passed as parameters in the http request.
Therefore, here is my question:
I am not very good in computer sciences and I have some difficulties understanding if EmonCMS is what I need. I wanted to have one graph showing the last 24 hours of power consumption and one graph / indicator / dial showing the cumulative power usage for the chosen period. I would also like to have other graphs showing different periods and different averages, but the first two indicators are the ones I really need.
So, can I use my MySQL table as a data source for the EmonCMS dashboard, and is that dashboard customizable enough for my needs?
Thank you for your time.
Also, if my question is not clear enough or I have not provided enough information about my project or my needs, I will gladly follow up with clarifications.