The data completeness feature allows users to track to and monitor data input by activity/meter over time. The system runs a scan the checks for completeness of data. Users can set the scan to run for a certain period and the results will show whether data is Missing, Up to Date, Overdue or Waiting to be updated.
Non Interval data is all non half hourly data so this covers waste, transport, non half hourly meter data, refrigeration etc...
To set up mass data completeness settings across your activities follow the steps below:
Step 1: To begin, navigate to the GHG Activities screen by selecting the Data Management menu icon at the top of the screen and clicking on GHG activities from the drop down. Once on the GHG Activities screen click on the "Settings" button above the chart as shown below. Bulk Activity Settings button is available on the GHG Activities screen, Meters Screen, and Transport screen. Users can go to any of these screens to use the Bulk Settings feature. For this example the GHG activities screen is used.
A - Data Completeness
B - Anomaly Testing
C - Email Reminders and Alerts
Select A to configure bulk data completeness settings for Non Interval Data meters.
Step 3: On the next screen click on the > symbol beside (B) Non-Interval Data - Data Completeness to set up Non-Interval Data scanning.
Step 4: Next tick the box beside the question ‘Enable Data Completeness for this Activity’ to turn on scanning. If you wanted to turn off scanning untick the box.
Next complete the settings for Data Completeness. Next complete the settings for Data Completeness.
Detailed Descriptions below:
B – How often do you expect the data owner to enter/upload data for the Activity?
Options include: Daily, Weekly, Monthly, Yearly, Every Two Weeks, Every Two Months, Quarterly and Four Weekly.
C - Number of days after the current period when the scan should run?
The number of days before scanning after a quarter ends or year ends to give users time to input the data. For example after a quarter ends give users a week to input data, so 7 days would be inputted.
D - There should be at least one data point in each.
Options include: Day, Week, Month, Year, Two Weeks, Two Months, Four Weeks.
I expect at least one data point in each day, week, month, etc.? This option means that you expect at least one item of data to be entered for the selected period. For example, you expect at least one record to be added to this activity each month e.g. gas, and electricity bills, water, waste etc.
E - There should be a point for each individual day: Options Yes/No
Do you expect data to be entered for this activity for each day? By setting this to yes, then the software knows that it is to expect at least one data point for every day in the period selected in item (C) above.
If item C is selected to Monthly, and if D is set to "Yes" then the software will check that every day in that month has some data associated with it. This is particularly useful for bill validation and metered data. If set to "No" then the software will just check that each Month has at least one record of data in it.
F - The first scan will occur on: Choose Date.
The scan will check for data completeness in the data from this date to the present.
Scan historic data also? Select Yes/No
If you select yes a Date Period selector will appear and you must choose a historical start date to start scanning. If yes input the date, the scan will check data completeness in historical data from this date to the present. This is a once off scan and the system will not continually scan historical data.
Step 5: On the next screen users will select the meters they wish to apply/turn off the Non Interval data completeness settings to. There is an activity table that shows all activities in the system if you wish to apply settings to all activities click continue.
If you wish to filter this list use the three filters at the top A (company), B (All Activity Types) and C (All Countries) to determine what activities you wish to mass apply the data completeness settings to.
A - Company: By org structure for example apply data completeness settings to all activities assigned to a certain building
B - By activity types: select a specific activity type for example Air Transport and apply these settings to all air transport activities in the system.
C - All Countries: for example select United Kingdom and apply settings to all UK activities.
These filters can be used together to determine what activities the user wishes to apply settings to. For example select Activity Type: Purchased Used and Electricity and Country type France to apply settings to all electricity activities in France.
Click Finish (D) when you have selected the activities you wish to mass apply the data completeness settings to.
Step 6: The data completeness settings for the selected Non Interval meters are now being setup, once completed users will receive an email in of completion. Click close to finish the process. The system will now scan all half hourly upload data files that are upload via the bulk or multi upload and provide the results in the Data Completeness section under the Analysis icon.