Introduction
The different kind of meters you have installed in your facility could send data discretely or cumulatively.
Usually, Energy data will be sent in a cumulated way. The Energy Platform can work with both values, but it should be clear what represents each type of parameters.
Let's put an example of a fiscal meter. The facility will have an energy meter which will cumulate a numerical value according to the consumed kWh. This value indicates what the fiscal meter has consumed from the beginning. In order to know how much energy we have consumed on a specific time interval (such as 15 min), we should make the difference between two consecutive quarters of an hour.
So, if Active Energy values are the following:
- 01/01/2018 at 15:00 --> 422283,16 kWh
- 01/01/2018 at 15:15 --> 422309,47 kWh
That means that in this specific 15min, we have consumed 26,31 kWh (which is the difference between both quarters). So, from 15:00 to 15:15 we have consumed 26,31 kWh.
That is the reason why we need to understand that these values are aggregated incrementally. Otherwise, in the calculation of the discrete value, we would obtain negative values or peaks.
Sometimes, the all meter will download quarter-hourly data in a daily way (for example, calling to the fiscal meter daily), so each set of data will start from 0.
In the case of inserting accumulated data (basic data, 402 in the case of active energy), the platform will automatically distribute the consumption between two consecutive dates within the same month. For example, if we have the data from 01/01/2022 and the next one is from 23/01/2022, the consumption between these two dates will be evenly distributed. However, this property can only be applied to dates within the same month.
Import historical data from Excel
If we want to import historical data or fill some gaps with data in the case our data logger had a problem and couldn't send the data, we should keep in mind how we are going to import these data.
- If we are going to import cumulated Active Energy data, we must import it using the 402 parameters. The Energy Platform will calculate automatically the discrete parameters (15 min, h, d, s and m)
- In the case we want to import directly the discrete parameters, we must indicate the sampling frequency. That is, if our readings are quarter hourly, we have to use the 40201 parameter. If our data is hourly, we will have to use the 40211 parameter. And so on. For more information about any other frequency, click here.
Common mistakes
- Import discrete data using the 402 parameter. This will make the Energy Platform to calculate the quarter hourly differences and the obtained values will be negatives. because it expected cumulated data.
- Import Active Energy data (cumulated) into a discrete parameter, such as 40201. This will show on analysis menus cumulated energy, and not the discrete one, which is what we have to work on.
- Import data without taking into account the previous cumulated data into the platform. This will make appear a positive or negative peak.
Inserting three-phase Active Energy
It may also be of interesting, how to import the active energy in the case of a three-phase installation.
For inserting three-phase Active Energy in the platform, 3 devices are used, one per phase and with various parameters. More information on the parameters and devices can be found in their respective articles.
A three-phase meter/network analyser measures the current and voltage of each phase and then does the sum. Most meters, if they are three-phase, only send a 402 that includes the three phases, but they give you the other values for each phase.
In addition, there are some meters (like Socomec) that can measure three-phase and/or single-phase, so you could have one 402 (three-phase) or 3 402s (single phase).