Delete readings & peaks

Follow

In this article, we will explain how to delete readings and peaks in DEXCell Energy Manager:

  1. Delete readings
  2. Deleting Peaks
    1. Single spikes: Eliminate readings
    2. Using the Manual Readings App to remove a "Spike" due to a jump in the readings that is maintained
  3. Understanding and solving peaks

 

1. Delete readings

  1. Log in as a superadmin or Admin into your DEXCell EM account.
  2. Go to "Settings" and click on "Gateways"01_95942a24268351320d36d8ec67a06f955b0be99561c74df5fa2a265d9b3dc4f3.png
  3. Select your gateway and click on the "Delete Readings" tab.02_dd48e82be42b20e9d224dc73890b04d797c0a3cab7650814343ac59c3b8b948b.png
  4.  Chose de Device which you want to delete the readings. Select the  Parameter you want to delete data. Under "available frequencies" dropdown, you will need to select if you want to delete basic data (for example, 402 parameter) or the discrete one (for example, 40201). Take into account, that there will appear the "basic" readings sent by the datalogger. So if you are sending 402 data, you will only be available to delete 402 data. If you are sending directly 15 min electrical energy (the interval data), you will be only available to delete the data for this frequency. 
  5. Select also a condition if you want (as a filter) and a time range. Press on "View" button. 
  6. Now, you will see all the data corresponding to this period of time
  7. Now select all readings you want to delete and press "Delete". In the case of want to delete a high number of readings, change the reading items to view in lists, following this article03_9ef42ee68e5c5e4fc030fd16019cbf37922d4202576349ad1078d8be4c1fe253.png



- Parameters will automatically be recalculated after deleting any reading.
- It's not allowed to delete more than 6 months of data at once

You can choose all readings from a page by clicking on the top checker from reading table.

 

 

 


2. Deleting Peaks

Sometimes we find irregularities, or “peaks” in our data that are the result of incorrect values sent by meters. These can be caused by an erroneous reading (and whose value is not maintained in time) that we can eliminate using Delete Readings from a gateway, or they can be due to a jump in a reading in the counter, when we have accumulated readings, which maintain the value in time. Here is how to solve each case.

 

2.1 Single spikes: Eliminate readings

In case of having readings that distort the analysis, the Delete Readings tab can be useful to eliminate some "spikes" that we have obtained from our devices by mistake or to eliminate a series of erroneous readings. Normally, the peaks are produced as a result of an erroneous value being sent by the meter that we have installed. Because of this, we have to eliminate those non-real data that appear in our account.

To delete a reading, log in to the DEXCell Energy Manager with as a SuperAdmin user.



In order to delete a peak, follow these steps:

  1. Go to the "Settings" menu and go to "Gateways"
  2. Click on "Delete Readings" tab
  3. Then, select the device which you detect a wrong value and select its corresponding dates. You can use a condition to filter more the searching
  4. Select the wrong readings and click on "Delete"
  5. Now, the peak has not to appear.
  6. If not, go to Parameters > Calculated Parameters and try to recalculate the corresponding calculated parameter

2.2 Using the Manual Readings App to remove a "Spike" due to a jump in the readings that is maintained

In case of a jump in the reading whose value is maintained, the readings cannot be eliminated as shown previously, since the peak would be moved in time. In this case, the consumption for the period in which the reading jumps must be set to 0, so that the peak does not appear.

For this, once the approximate period in which the peak occurs through the graph is identified:

To identify the exact moment when the peak occurs, you must follow the following steps:

  • Go to the "Settings" menu and access the "Gateways" section.
    Go to the "Delete Readings" tab

 

In this example, the peak occurs between 7:00 and 07:15 on 19/11/2018.

The readings that must be corrected are therefore the ones that correspond to the value before the peak, 19/11/2018 07:00. Taking note of this moment you can set the consumption reading to 0 for each frequency for which you need to perform analysis through the Manual Readings app.

Following the steps described in this article about the Manual Readings app, the corresponding gateway is configured.  

Once the gateway is configured as required by the application, you can select the location and the parameter and you can insert readings with 0 value for each frequency (Quarterly: 15 minutes, Half hour: 30 minutes, Hourly: Hours, etc. ...) as seen in this caption:

Once the reading is imported, if you wait for about 5 minutes, the peak for that frequency in the consumption graph will have disappeared. In the example, the quarter-hour frequency has been used. The process must be repeated for each frequency that is causing problems.

 

 

 

3. Understanding and solving peaks

Normally, analyzers we have installed in our facility or the fiscal meters, are going to send the Energy data in a cumulative and incremental way, representing how many we have consumed for a specific period of time. Although, we can obtain from the datalogger some outliers causing peaks in the hourly curves and making the representation in DEXCell Energy Manager erroneous. For more information about Active Energy and its representation, click on the following support article: Understanding Active Energy

For that, we should understand all the possible errors and how to solve them. Then, we are going to explain the most habitual cases which cause peaks and how to deal with them:

  1. Peak caused by an outlier
  2. Welcome peak
  3. Negative jump on the Active Energy value I
  4. Negative jump on the Active Energy value II
  5. Positive jump on the Active Energy value
  6. Increase and decrease of the Active Energy value

 

3.1 Peak caused by an outlier 

Sometimes, gateways installed can send some outliers which differs from the cumulated curve of the Active Energy. We can receive a lower or higher value and cause a negative or positive peak on DEXCell Energy Manager graphs.  

04_f672c0f45306dcd182f3c338fc23a8264f64147ea53f1153298683d367f0edba.png05_4fb2156eb3ff50d2be8c1ba09d7d146b42c1be40c7df5e924ac1f7efd0312950.png
  • Result:

06_169f9c9013e3b68c9655c9be238733b22170021717070cc49937b3cfdfbaeac6.png07_c6460c534291d8070982da82f34f0c6ece6f3c85ea6da40fc3e4eb50a5c6e0d8.png

  • Solution: delete the outlier on the "Delete readings" menu. We remind that we must delete the outlier on the Active Energy parameter (402) not from the discrete values. 

 

3.2 Welcome peak

Probably our meters start sending data with some cumulative value and don't start sending from 0, because they were installed on the facility some time ago. That should cause a jump in the first reading.

08_d5b574833a160babb20f58224974a6b507dfc840e02664ac24869aab593e206b.png

 
  • Result:

09_4b5b704636d24d9bb77007e59e6ace532e80e5ec29c469a4e31c0730adf13429.png

  • Solution: In order to solve this welcome peak, we just have to "Recalculate" the "Active Energy" values. For that, we go to Settings > Parameters and recalculate the corresponding device from the date we have found the peak.

 

3.3 Negative jump on the Active Energy value I

Active Energy values must be cumulated. In the case that the fiscal meter makes a reset (automatically or manually), it should starts by 0 in order to avoid negative peaks.  We may encounter some situations where the fiscal meter makes a reset or change its value and don't start by 0 and still incrementing after that value.  
10_100cdb3690985861a92fea9fb159f989275f36ce0b70b73e4914ae0b9cbc008e.png
 
  • Result:

11_fce9e9c973e788362f378c59beeb6a236a793eb64a33e8c5c813f662ffd9b0c2.png

  • Solution: in this case, the best option is to treat existing data before the peak. So, we will have to modify the previous data from the peak and make coincides the last value before the peak with the first value after the peak. The steps we have to follow are the following: 
     
    • Download the Active Energy readings in Excel
    • Treat the data in order to avoid the peak. In the previous example, the best option is to divide the cumulated consumption into 2 smaller increments in order to match the values. In that case, the  curve look likes as follows:12_4b83fa5225973d6a4991c8983b9042afb8736538960bc3368a1c285817712a7d.png
    • Delete the wrong readings 
    • Import new data on Excel using the DEXCell Energy Manager template. 


3.4 Negative jump on the Active Energy value II

Active Energy values must be cumulated. In the case that the fiscal meter makes a reset (automatically or manually), it should starts by 0 in order to avoid negative peaks.  We may encounter some situations where the fiscal meter makes a reset or change its value and don't start by 0 and still incrementing for a period of time and then makes a new reset.  

13_1c0533bff39beb5b9d2c87569fc8367781ebb524773119e246edf573adfcb9e6.png

​ 

  • Result:

14fce9e9c973e788362f378c59beeb6a236a793eb64a33e8c5c813f662ffd9b0c2.png

  • Solution: in this case, as we have a reset near the peak, solve this peak is easiest. What we have to do is to make start from 0 the data between the peak and the reset.  The steps we have to follow are the following: 
    • Download Active Energy readings in Excel
    • Treat the data in order to avoid the peak. In the previous example, we will have to make the data set from 0 subtracting the jump value of the Active Energy to all the readings.15_e4d0fbaadd0524926a35d7b0316f9e390dd935fb0ce58bced8e44fc66da77032.png

       

    • Delete the wrong readings 
    • Import new data on Excel using the DEXCell Energy Manager template. 



3.5 Positive jump on the Active Energy value

Active Energy values must be cumulated. We can find that the fiscal meter sends cumulated data correctly, but suddenly it starts counting with a higher value and starts growing again from that value.
 
16_92a05e5acea2ec777db74434df40238740f3fd2784d363b5caa4506c7792585d.png 
  • Result:

17_169f9c9013e3b68c9655c9be238733b22170021717070cc49937b3cfdfbaeac6.png

 
 
  • Solution: in this case, the best solution is to modify the data received before the peak. We will have to modify the data in order to make coincides the last value before the peak with the first reading after the peak. That means, try to put to the same height both series of data. The steps to follow are:  
    • Download Active Energy readings in Excel
    • Treat the data in order to avoid the peak. In the last example, we should take into account if we previously have data or not. 
      • If we don't have historical data, we just increment the values adding the "jump" value. Then, we will have to recalculate to avoid a "Welcome peak".   18_4fdfd728638cddeceafc6dbe1e86dc9b7025468e78a4d81d231477165cc8cd72.png
      • In the case that we have historical data, we should create a new set of data which start from 0 using the previous values. That means, we will need to make start the curve many kWh behind as the value of the jump on the Active Energy.       19_132231578fa0ec80eccc5314386ac348e586da85c20a5a3bba21df698550bf87.png                                               
    • Delete the wrong readings 
    • Import new data on Excel using the DEXCell Energy Manager template. 
 

3.6 Increase and decrease of the Active Energy value

In this case, the data starts growing but the values can slightly decrease (ex: for the meters that monitors both consumption and production of energy). This situation will produce negative values. 
 
20_057fea48740045e6a965fff0c5536cc12fcb30af251ec55dcaafddec6dce8312.png
  • Result:

21_b70b1aa25a9a101c191574d245c2ba377d90ee085c0da420e67cb54c43c64013.png

 

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.