Ouvrir la rubrique avec les liens de navigation

Environmental & Risk Management / Energy Management / Business Process Owner Facilities

Inputting and Processing Meter Readings

Use the Process Meter Readings task to import data that provides meter readings (in kWh) by date and time. You import this data either manually or using the Data transfer action. This data is stored in the BAS Data - Clean Numeric table. The data must then be processed before it can be reported on.

Inputting data by data transfer

The Process Meter Readings view contains a standard DATA action to enable transfer of data to the BAS Data - Clean Numeric table. To access the DATA action:

1. Select the Process Meter Readings task, and then click View Data in the row for a Data Point in the Select Data Point grid.
2. Click the DATA action button in the Clean Data pane (the top-right of the view.)
3. Do one of the following:
   • To obtain a template for data inputting, choose Transfer Out. Modify the template, and then use the DATA action to import the data by selecting Transfer In.
   • If you have your file already prepared, click Transfer In and select the file.

Inputting data by hand

At times, you might want to enter data by hand. This is more likely if data collection is infrequent, such as once per month.

To input a single data reading,

1. Select the Process Meter Readings task, and select View Data in the row for a data point.

   The Clean Data section now shows data for that data point.

2. Click Add in the top-right corner of the Clean Data pane.

   The Edit Clean Data form appears..

3. Enter the reading date, time and value.
4. Do one of the following:
   • To have the application calculate the Consumption value during data processing, leave the Consumption value as zero.
   • To manually enter the Consumption value, enter a value and set the Processing Status to Manual.

   Note: If you enter a non-zero Consumption value, the Processing Status will automatically be saved as Manual. This will prevent the Consumption value from being overwritten when the data is processed. If ever you wish to revert to automatic calculation of the Consumption value, reset the value to zero and change the status to “Not Processed.” See Editing a Data Reading.

5. Click Save.

Processing Meter Readings

The Select Month grid in the bottom-left pane displays each month of data with a Processing Summary of ‘Not Processed’ or ‘Processing Completed’ for that month. A green check mark indicates that the data has been processed successfully.

When new data is imported into the BAS Data – Clean Numeric table, either manually or by data transfer, the month in which that data occurs will have a Processing Summary of ‘Not Processed.’ You can then choose to Process the data by one of three methods.

• Click the Process All panel action to process all months for the selected Data Point
• Click the per-row Process button to process the data records for a specific month
• Enable the Process Data Scheduled Workflow rule to run daily updates on the BAS Data – Clean Numeric table. When the workflow rules runs, it processes any unprocessed data in that table. The scheduled workflow rule runs on all data points and selects for any months that are flagged as ‘Not Processed’. It then processes the data in those unprocessed months.

How adding or editing data records resets the Processing Summary

Upon saving a new or edited data record or deleting a record, the Processing Summary of each affected month is reset. This is to ensure that any changes made to the data that affect final reporting of aggregates are flagged for reprocessing.

• The month that the saved / deleted record occurs in will be flagged as ‘Not Processed’.
• If the record occurred on the first of the month, then the previous month will also be flagged as ‘Not Processed’.
• If the record occurred on the last of the month, then the next month, if existing, will be flagged as ‘Not Processed’.

About data anomalies

Data anomalies are any conditions that are suspiciously high or low. Anomalies can include negative deltas between readings that are commonly the result of meter “flips” that occur when the meter’s counter reaches its maximum value and starts again at 0.. If negative values are not truly anomalous, as might be the case when you sell some energy back to the utility provider, then you should set the negative consumption value manually following the procedure described above. See Inputting data by hand.

After data processing occurs, the application marks negative values as anomalies. You can examine these anomalies, and edit them as needed.

Note: Other anomalous conditions may exist, for example, suspiciously high or low (but non-negative) values can be identified via inspecting data in the table or examining chart reports.

Effects of processing a month's data

Processing a specific month’s data for a Data Point does the following:

1. Computes the Consumption values (the delta between a meter reading and the previous meter reading) for all data in the month and for the first record in the subsequent month, if this record exists.
   1. The consumption value is not overwritten when a data reading has been manually marked with a Processing Status of Manual. See Editing a Data Reading.
   2. If a negative consumption value is computed, then the data record is set to Processing Status ‘Anomaly,’ and the negative consumption value is substituted with the previous reading’s consumption value. You should examine these anomalies to see if they are valid, or are the result of a meter flip. See ' Inputting data by hand'
   3. Records not marked as ‘Manual’ or ‘Anomaly’ are set to the Processing Status ‘Processed.’
2. Computes hourly and daily aggregates of data for the selected month, and for the first record in the subsequent month.

   Note: Hourly aggregates are only computed for data that is less than a year old, as a safe guard against prohibitively long processing times, and because most strategic decisions with interest in hourly data will focus on recent data.

3. Computes weekly, monthly, quarterly, and yearly aggregates of data for the entire time period spanned by the data collected for that data point.

Adding Data Points Including Measurement Scope and linking to Vendor Meter

A data point refers to a meter. You enter data points and the specific area (measurement scope) the meter covers. The measurement scope may be a single floor of a building, or it could be an entire building. Alternatively, the measurement scope could be a single piece of equipment.

To define a meter:

1. Select the Process Meter Readings task, and select Add in the Select Data Point pane.

   The Define Meter, Measurement Scope and Link to Vendor Meter form appears.

   

2. Enter the following details as needed for the data point:

   Data Point Name: Enter a name that identifies the meter.

   Bill Type: Select ELECTRICITY – CONSUMPTION or ELECTRICITY - POWER

   Equipment Code: Enter the equipment code for the meter if you have entered the meter as one of your equipment assets.

   Sampling Interval (seconds): Enter the interval at which the meter takes measurements. You enter this for your reference.

   Area Measured (Manual Entry). Manually enter the area covered by the data point when you do not want to use a measured area calculated by the system. If this area has a value, it is used in place of the calculated area.

   Is this a Virtual Meter? Select Yes if this data point represents a combination of two or more meters. Otherwise, leave this to No.

   Meters to Include / Exclude: If this is a virtual meter, select the Meters to Include and the Meters to Exclude from the lists.

   Data Point Description: Enter a description that describes the purpose of this meter, such as" Meter reads to correspond with utility bills."

   The Measurement Units defaults to KWH for Energy / Consumption meters, or KW for Energy / Demand meters, as these are currently the only supported measurement units.

   The Data Point ID is system-generated.

3. Click Save.

   The Define Measurement Scope form appears.

   

4. Enter the following to define the measurement scope for this meter.

   Zone: Code: A particular area on a floor that is covered by this meter. Zones are associated with your critical facility systems. Clicking on the Zone Select Value button opens a dialog which allows you to select an existing zone or add a new zone to the Zones table.

   Equipment Code: If this meter is measuring energy consumption or demand for a piece of equipment, select the Equipment Code by selecting from the list. When you select equipment, its location is filled in for you.

   Otherwise, select the Site / Building / Floor / Room to describe the location for this meter.

5. Click Save.

   When the form is saved, the total usable area for the location you select is saved in the Area Measured field of the Data Point. If you have not entered a value for the Area Measured (Manual Entry), then the Area Measured is used.

   The form expands to show the Link Meter with a Utility Vendor's Meter section.

   

6. Enter the following to link this meter to a vendor's meter. Linking to a vendor's meter enables you to track billing discrepancies by correlating the Vendor Meter ID listed on the bill with the Data Point which makes the same measurement internally.

   Vendor Account Code / Vendor Code. Select the vendor and the vendor account that this meter is associated with.

   Vendor Meter ID: Select the Vendor Meter ID used by the utility company. EDI feeds contain this Vendor Meter ID field .

7. Click Save.

Editing information for a data point

 You can edit information for data points by clicking the pencil edit icon in the row for the data point in the Select Data Point grid. For example, you can change the Sampling Interval, or Area Measured.

Editing a Data Reading

At times, you might determine that the computed consumption value does not appear realistic, and may wish to edit the Consumption value by hand.

To edit a data reading that has been previously inputted by hand or by data transfer:

1. From the Process Meter Readings task, select a data point in the Select Data Point pane.
2. In the Select Month pane, select the month that includes the data reading you want to edit.
3. In the Clean Data pane, click the reading that you want to edit.

   The Edit Clean Data form appears.

4. Do one of the following:
   • If you wish to override the calculated Consumption value, enter a new Consumption value and set the Processing Status to 'Manual.' This will prevent your changes from being overwritten if the data is re-processed.
   • If the data has previously been processed, but you wish to mark the record for re-processing, set the Consumption value to zero and then set the Processing Status to ‘Not Processed’.
5. Click Save.