Reports
The Custom Reports feature allows for the use of a third-party, web-based reporting tool (for example, Crystal Reports Enterprise and SQL Server Reporting Service) to create reports that are custom to the specific needs of the utility’s installation of Command Center.
Use the following procedure to view custom reports in Command Center:
1.From Command Center Home, click Reporting > View Custom Reports to display the View Custom Reports window.
Figure 10 - 1. The View Custom Reports Window
2.In the View Custom Reports window click the New button to display the Manage Custom Reports window.
Figure 10 - 2. The Manage Custom Reports Window
3.Enter a Report Name for the new custom report.
4.Enter the Report Location for the new custom report.
NOTE: A web-based reporting tool must already be in place in order for Command Center to access the selected report’s URL.
5.Select a Role from the drop-down menu. By selecting a certain role, the new custom report will only be available to users listed in that role group.
6.Click the Save button to create a link to the custom report and display the View Custom Reports window, which will display the new custom report.
Figure 10 - 3. Viewing the New Custom Report
7.From Command Center Home, click Reporting > Custom Reports and select the desired custom report to view it.
NOTE: For more information on establishing URL access to reports created by web-based reporting tools, please refer to the manufacturer-provided documentation.
The Deployment Status Report enables users to monitor the find process when endpoints are being deployed on a system.
1.Click Network > Deployment Status to display the Deployment Status report window.
Figure 10 - 4. Deployment Status Window
2.(Multi-Tenancy users only) Click System Tenant and select a tenant group.
3.Choose the Selection Criteria:
Select All.
...or...
Collector. Select the desired collector from the drop-down menu.
4.Select an endpoint type radio button. Options will vary based on Command Center licenses.
•Electric
•Gas
•Water
5.Enter a Date Range.
Enter a Start Date and End Date. Click 
to view and use the calendar for date selection.
6.Click the OK button to display the Deployment Status Report.
Figure 10 - 5. RF Deployment Status Report
The Deployment Status report displays a graph representing 14 days of installation statistics and a chart. Time periods longer than 14 days may be selected, but will not be presented on the graph due to space limitations. By clicking on a specific date, each endpoint registering that day displays installation, registered, normal and reading status for this date. Information on the report is updated as the information is received by Command Center on a rolling seven day basis. Installation information is populated from the Installation File Import process. Registered and Normal status updates are based on receipt of the two registration requests from the endpoints. Readings are based on the first reading received from the endpoint. Average deployment time is based on the time it takes to go from installed to normal.
7.Click on the Date link to display the Gridstream Meters Deployed By Day report.
Figure 10 - 6. RF Meters Deployed by Day
The Installation Status Report is intended to be used by utilities during mass deployment. It can be used as an installation tool to determine how many meters have been installed over a specified time frame and of those meters how many have been discovered, how many have moved to normal status, how many are sending readings, and how many have sent readings in the past 24 hours.
Following is the procedure for viewing the Installation Status report:
1.From Command Center, select Network > Installation Status. The Installation Status window will open.
Figure 10 - 7. Installation Status
2.Selection Criteria. Select All to view results for all collectors in the system
...or...
Select the desired collector from the drop down box to view results for only that collector.
3.Select the Electric endpoint type radio button.
4.Date Range. Enter a Start Date and End Date. Select the Calendar icon to view a calendar and make date selections if needed.
5.Click OK. The Installation Status report will be displayed, shown in Figure 10 - 8.
Figure 10 - 8. RF Installation Status Report
The following information is displayed in the report:
•Day. This number will increment for each day the used has selected to display.
•Date. This will display the dates selected in generation of the report. Click the date link to view a list of all meters deployed on the selected date.
•Daily Installed. This will display the number of endpoints installed for that particular day. The daily installed data is imported into Command Center via the Installation File.
•Discovered. Of the total number of meters installed on the summary date, the total number of those that have transitioned into a Discovered state and the percentage (Discovered meters/Installed meters).
•Normal. Of the number of meters installed on the summary date, the total of those meters that have transitioned to a normal state at that point in time and the percentage (Normal meters/Installed meters).
•Readings. Of the total number of meters installed on that day, the number of those meters that have sent in a billable reading packet, and the percentage (meters that have sent a billable reading packet/total meters installed on that day).
•Readings past 24 Hours. Of the meters that were installed on that day, the total number of meters that sent in a billable readings packet in the last 24 hours (from the point the report was generated) and the percentage (meters that sent in a billable readings packet in the last 24 hours/total meters installed on that day).
•Cumulative installed. The total number of meters that have been installed up to that date.
•Normal. The total cumulative number of meters that have transitioned to Normal status up to that date.
The color-coded bar graph displays the following deployment information:
•Cumulative number of meters installed for each date (Grey).
•Current number of meters that have transitioned to Normal status (Green).
•Number of installed meters that have sent in a billable reading in the last 24 hours (Blue).
The Command History Report will display all commands issued during a specified time period.
1.From Command Center Home, click Reporting > Command History Report. The Command History Report window will open.
Figure 10 - 9. Command History Report
2.Select Go to Today.
...or...
3.Select the date you wish to view from the calendar. You can use the forward and backward arrow to move to a different day. Click View.
Figure 10 - 10. Command Summary
4.Click the plus sign by the collector name to expand the report field.
5.Report information includes:
•Command Type. Name of command issued.
•Total Successful. Total number of successful commands issued.
•Total Unsuccessful. Total number of unsuccessful commands issued.
•Total Expected. Total number of expected commands.
•Success %. Percent of successful commands issued.
•Unsuccessful %. Percent of unsuccessful commands issued.
•Command Issued. Date the command was issued.
•Latest Response. The date of the latest response was received.
•Endpoint Model. Endpoint Model name.
•Encryption Mode. Type of encryption.
•Group Command ID. Group Command ID number.
Information displayed in the Daily Reads Status Report consists of a snap shot of system information.
The Daily Reads Status Report is used for system diagnostics and provides a day-by-day report of the system’s status for the selected time period.
1.Select Reporting > Daily Reads Status Report.
The Daily Reads Status Report window will open.
Figure 10 - 11. Daily Reads Status Report
2.Select from the following Selection Criteria to base the report on:
•All. Select the All radio button to select all meters in the organization.
•All RF.
•All Cellular
•Collector. Select the Collector radio button and then select a Collector from the drop-down list to include the meters associated with the selected Collector in the report.
3.Select a Date Range from the following:
•Quick Select. Choose a time frame from the drop-down list
...or...
•Start Date/End Date. Select the start date radio button and enter Start Date and End Date. If necessary, select the calendar icon to generate a calendar from which to select dates.
4.Click the Submit button to generate the Daily Overall Summary report.
Figure 10 - 12. Daily Overall Summary
The report displays the following categories.
•Date. Displays the date the reading was taken.
Click the date link to view the Overall Summary by Collector.
Figure 10 - 13. Overall Summary by Collector
•Total Endpoints. Displays the total number of endpoints reporting on the collector.
NOTE: Columns may not sum to Total Endpoints due to dynamic state transitions.
•Daily Billable. Displays the number of endpoints for which readings were considered billable on that day.
•% Daily Billable. Displays the percentage of Total Endpoint for which the system has billable reads.
•Expected Interval Data. Displays the number of interval readings expected from the total endpoints. This number is dependent on the number of channels the meter has been programmed to record.
•Received Interval Data. Displays the actual number of interval reads received.
•% Interval Data Received. Displays the percentage of interval reads received from the total endpoints.
1.Click the Interval Data Summary link to view the Daily Interval Summary Report.
Figure 10 - 14. Daily Interval Data Summary
NOTE: Both register and interval data is pushed to Command Center several times a day. It is the responsibility of Command Center to recognize the missing data and collect it from the endpoints. Gap Analysis is based on determining gaps as data is received. If Command Center identifies a gap, a command requesting the missing data is sent to the endpoint.
Following are the details of the Interval Data Summary report.
•Date. Reading date.
•Total Endpoints. This value is the total number of endpoints in the system or the collector as of the selected date. This total includes all endpoints in Normal or Lost status.
•Expected Readings. This value is the total number of readings expected from endpoints on the selected date.
•Published Readings. This value is the total number of regular readings actually returned by endpoints on the selected date.
•Retrieved Readings. This value is the total number of gap readings retrieved readings on the selected date.
•Total Readings. This value is the sum of published readings and retrieved readings on the selected date.
•% Published. This value is Published Readings/Total Expected Readings. The result indicates the percentage of readings that were obtained via the normal mesh process.
•% Retrieved. This value is Retrieved Readings/Total Expected Readings. The result indicates the percentage of total readings that were obtained through the retrieval process.
•% Total. This value is Total Readings/Expected Readings.
•Gap Meters. This value indicates the total number of meters where there are gaps between readings on the selected date.
1.Click the Readings Summary link to view the Readings Summary Report.
Figure 10 - 15. Readings Summary
Following are the details of the Readings Summary report:
•Date. Reading Date.
•Total Endpoints. This value is the total number of endpoints in the system or for the selected collector.
•Expected Readings. This value is the expected ID readings from all the endpoints on the selected day.
•Received Readings. This value is the number of regular readings received from the endpoints on the selected day.
•% Received. This value is Received Readings/Expected Readings. The result indicates the percentage of readings received versus readings expected.
•Daily Billable. This value indicates the total number of endpoints from which a billable reading has been received on the selected date.
•% Billable. This value is the Daily Billable/Total Endpoints. The result indicates the percentage of total endpoints that have provided billable readings on the selected date.
The Endpoint Data Export window provides the user with the ability to export electric endpoint data to an Excel Spreadsheet. The user should first select the endpoint type, then select the status from a drop-down list containing statuses available for the selected endpoint type.
NOTE: Minimum system requirements of Microsoft Office 2002/XP or Office 2003 are required.
1.Click Reporting > Endpoint Data Export > Endpoint Data Export.
The Endpoint Data Export window will open.
Figure 10 - 16. Endpoint Data Export Window
2.Select the Data Extract type from the drop-down list.
3.Select a Collector from its drop-down list.
4.Select an Endpoint Status from its drop-down list.
5.Select an Endpoint Type from its drop-down list.
6.Select a Configuration Group from its drop-down list.
7.Select a Firmware Version from its drop-down list.
8.Select either the CSV or XLS radio button.
9.Click the OK button to generate the report.
10.Select Open in the Internet Explorer dialog box.
The spreadsheet will open (partial window shown).
Figure 10 - 17. Excel Spreadsheet
NOTE: It may be necessary to scroll horizontally to view all headers.
|
Meter |
Endpoint ID |
Collector |
Firmware Version |
|
Kh |
Channel/Frequency |
Configuration Group |
Hardware Model |
|
Status Code |
Last kWh |
Last Billable Read |
Momentary |
|
Last Found (PLC Only) |
Date Deployed |
Dials |
Max kW(TS1) |
|
Max kW (TS2) |
Max kW (PLX) |
Phase (PLC) |
Signal Quality (PLC) |
|
Downstream% (PLC) |
Usage Violation (in days) |
Billing Cycle |
Customer ID |
|
Map Location |
Service Location |
Account Number |
Feeder |
|
Revenue Class |
Momentary Event Int Count (PLC) |
Sustained Interruption Count (PLC |
Momentary Event Int. Count (PLX) |
|
Sustained Interruption Count (PLX) |
Latitude |
Longitude |
Pole # |
|
Meter Position |
Custom 1 |
Custom 2 |
Layer |
|
Address |
City |
State |
Zip |
|
Installation Date |
Status Group |
ZigBee Firmware Version |
Initial Installation Date |
|
Time Zone |
Seal Number 1 |
Seal Number 2 |
Multiplier |
|
Demand Multiplier |
Line Section |
Grid Location |
Customer Last Name |
|
Form |
Base |
Class |
WAN Address |
|
DCW Version |
Meter Firmware Version |
Last Status Changed |
Security Status Code |
|
High Speed |
Reactive Capable |
Reactive Enabled |
Reactive Mode |
|
RowNo |
Meter Program ID |
Tenant Group |
|
Scheduled Endpoint Data Export Report
The Scheduled Endpoint Data Export window provides the user with the ability to set a schedule for the export of electric endpoint data to an Excel Spreadsheet. See the previous section for a description of the exported data.
1.Click Reporting > Endpoint Data Export > Scheduled Endpoint Data Export.
The Scheduled Endpoint Data Export window will open.
Figure 10 - 18. Scheduled Endpoint Data Export Window
2.To view Scheduled Endpoint Data Exports:
a.Select the View Criteria.
•Choose the Quick Select radio button and choose a criterion from the drop-down.
...or...
•Choose the Start Date and End Date radio button and enter the desired date range. If necessary, select the calendar icon to generate a calendar from which to select the desired dates.
b.Click the View button to display a list of Scheduled Endpoint Data Exports.
3.To create a Scheduled Endpoint Data Export click the New button which displays the New Scheduled Endpoint Data Export window.
Figure 10 - 19. New Scheduled Endpoint Data Export Window
4.Select the Data Extract type from the drop-down list.
5.Select a Collector from its drop-down list.
6.Select an Endpoint Status from its drop-down list.
7.Select an Endpoint Type from its drop-down list.
8.Select a Configuration Group from its drop-down list.
9.Select a Firmware Version from its drop-down list.
10.Select either the CSV or XLS radio button.
11.Enter the Output File Name and path to which the file must be saved.
12.Set up the Schedule of the Endpoint Data Export by choosing one of the following options:
•Immediately
...or...
•On specified dates
i.Specify one or more dates separated by commas or semicolons in the text box. Most standard date formats are acceptable. If you use a date format that includes a comma, separate the dates with a semicolon.
ii.Select or enter the Time at which the export should occur.
...or...
•Recurring
i.Click the calendar icon to select a start date. If you want to change the specified start time, highlight the hour and type a different hour or use the up and down arrows to change the hour. Highlight the minutes and type different minutes or use the up and down arrows to change the minutes. To select AM or PM, click the AM icon to toggle between AM and PM.
ii.Click the Show Recurrence Options link to expand the window to display the recurrence options.
The Recurrence Options window expansion displays the following options. Click the corresponding radio button to make your selection.
•Do not repeat. The export will occur once.
•Repeat every day. The export will occur daily.
•Repeat every [1-2-3-4] week(s) on Sunday through Saturday. The export can be set to repeat every 1, 2, 3, or 4 weeks on any, or all, of the days of the week.
•Repeat on day [ ] of each month. The export can be set to repeat on the same date of each month. Enter a number from 1 to 31.
•Repeat [ ] day(s) before the end of each month. The export can be set to repeat every month on a specified number of days before the last day of the month.
If you elect to repeat the export, the following two options are also available.
•Repeat until [ ]. The export can be set to repeat until the user specified date by clicking the calendar icon and selecting the end date. To change the end time, highlight the hour and type a different hour. Highlight the minutes and type different minutes. To select AM or PM, click the AM icon to toggle between AM and PM.
•Repeat forever. The export can be set to repeat forever unless or until you change the end date.
13.Click the Save button to initiate the Scheduled Endpoint Data Export on the selected date.
The Phase Voltage Report displays phase voltage, demand data, gyrbox, and register status data. It provides up to the minute diagnostic information.
1.Select Reporting > Phase Voltage Report to display the Phase Voltage Report page.
Figure 10 - 20. Phase Voltage Report
2.Enter a Meter Number or click the Find Meter icon to search for a meter.
3.Select one of the following report methods:
•Date Range. Enter a Start Date and an End Date to generate a report for a particular date range. The default start date is seven days prior to the end date. Up to seven days of data may be viewed at one time.
•Latest Read. Select to view the most recent data returned by the meter on which to base the report.
•On-demand Read. Select to issue an on-demand read command to the endpoint for up to the minute results.
4.Click the OK button to display the Phase Voltage Report for your selected meter.
Figure 10 - 21. Phase Voltage Report - Date Range
Phase Voltage Report - Date Range
The following data is displayed on the Phase Voltage Report - Date Range:
NOTE: The data displayed will vary dependent on meter model.
•Navigation Bar. Use the navigation functions to view the available data per read date.
Figure 10 - 22. Navigation Bar
•Phase Diagram and Chart. Graphically displays the phase values and current per phase. Move the pointer over any of the graph information or graph legend to interact with the information. Graph information changes by using the navigation bar.
Figure 10 - 23. Phase Diagram
•Demand Data. The data will vary dependent on meter model. Move the pointer over any data point to view information.
Figure 10 - 24. Demand Chart
•Events Chart. Displays event types per day. Move the pointer over the graph items to view the number of events.
Figure 10 - 25. Demand Chart
Phase Voltage Report - Latest Read/On-Demand Read
The following data is displayed on the Phase Voltage Report/Latest Read:
•Instantaneous Data. Displays graphically the instantaneously values and current per phase.
Figure 10 - 26. Instantaneous Data
•Demand Data. The data will vary dependent on meter model.
Figure 10 - 27. Demand Data
•Diagnostics Configuration. The Gyrbox continually monitors for equipment failures, poor loading conditions, poor power quality, and tampering.
Figure 10 - 28. Diagnostic Configuration
The table below describes the diagnostics for the Landis+Gyr FOCUS AX, these will vary depending on meter model.
NOTE: Diagnostics Configuration will vary dependent on meter model. Refer to meter manufacturer documentation for detailed descriptions.
|
D1: Voltage Phase Angle |
Checks for proper phase relationships of voltage, incorrect polarity of voltage, internal meter measurement malfunction, and faulty site wiring. |
|
D2: Voltage Phase Deviation |
Verifies loss of phase voltage, incorrect phase voltage, shorted voltage transformer winding, and incorrect voltage transformer ratio by detecting differences between phase voltage magnitudes. |
|
D2: Voltage Deviation Threshold |
Displays the tolerance range of voltage deviation programmed into the meter. |
|
D3: Inactive Phase Current |
This check makes sure that the service is maintaining an acceptable current level and is expected to detect current diversion and an open or shorted CT circuit. |
|
D3: Phase A/B/C Current Threshold |
Displays a minimum Phase A/B/C current threshold programmed into the meter. |
|
D4: Current Phase Angle |
Verifies that the elements are sensing and receiving the correct current for each phase of the service and indicates poor load power factor system conditions. |
|
D4: Displacement Angle (Leading & Lagging) |
Indicate the maximum displacement, in degrees, of the current phasors from the corresponding voltage phasors. If a displacement greater than these values is measured for any phase, an error is indicated. |
|
D6: Current Imbalance |
Compares the current of each phase with the other phases. If the ratio between any phase current and the average of all phase currents exceeds a programmable percentage, then this diagnostic flag is tripped. |
|
D6: Current Imbalance Threshold |
Displays current imbalance Threshold programmed into the meter. |
|
D7: Energy Polarity |
Checks for reverse energy flow of one or more phases. If the energy polarity (watts) for any phase is negative, an error will be indicated. This check is not performed if Phase A voltage is missing. |
•Register Status. The register status displays data derived from testing the meter.
Table 10 - 3 “FOCUS AX Register Status”, provides a description of the FOCUS AX Register Status.
Figure 10 - 29. Register Status
NOTE: Register Status will vary dependent on meter model. Refer to meter manufacturer documentation for detailed descriptions.
|
Memory Failure |
Displays a Yes or No depending on whether or not there was a memory/load profile error. |
|
Demand Overflow |
Displays a Yes or No depending on whether or not the overload value is equaled to or exceeded demand. |
|
Stuck Switch Flag |
Displays a Yes or No depending on whether or not the scroll switch is in active mode for one of the following: over six minutes, test mode switch is in active mode for six minutes after exiting test mode or scroll switch is in active mode for six minutes. |
|
Unsafe Power Failure |
Displays a Yes or No depending on whether or not the meter experienced proper power down. |
|
Phase Error |
Displays a Yes or No depending on whether or not the meter experienced proper power down. The FOCUS AX is powered from Phase A, a phase is considered lost at a programmable percentage of the nominal voltage. |
|
Measurement Diag. |
Displays a Yes or No depending on whether or not there was a problem and the meter is out of calibration. |
|
Low Battery |
Displays a Yes or No depending on whether or not the battery check is successful (a weak or missing battery has been detected during periodic testing). |
The Phase Voltage Report displays phase voltage, gyrbox, and register status data. This report is available for the FOCUS AX, S4e, Elster and GE kV2c. It provides up to the minute diagnostic information.
1.Select Reporting > Phase Voltage Report to display the Phase Voltage Report window.
Figure 10 - 30. Phase Voltage Report
2.Enter a Meter Number or click 
to search for a meter.
3.Select one of the following filters:
•Latest Read. Select to view the most recent data returned by the meter on which to base the report.
•On Demand Read. Select to issue an on-demand read command to the endpoint for up to the minute results.
•Date Range. Enter a Start Date and an End Date to generate a report for a particular date range. The default start date is seven days prior to the end date. Up to seven days of data may be viewed at one time.
4.Click the OK button to display the Phase Voltage Report for your selected meter.
Figure 10 - 31. Phase Voltage Report - Date Range
The following data is displayed on the Phase Voltage Report - Date Range:
•Navigation Bar. Use the navigation functions to view the available data per read date.
Figure 10 - 32. Navigation Bar
•Phase Diagram and Chart. Graphically displays the phase values and current per phase. Move the pointer over any of the graph information or graph legend to interact with the information. Graph information changes by using the navigation bar.
Figure 10 - 33. Phase Diagram
•Demand Data. The data will vary dependent on meter model. Move the pointer over any data point to view information.
Figure 10 - 34. Demand Chart
•Events Chart. Displays event types per day. Move the pointer over the graph items to view the number of events.
Figure 10 - 35. Demand Chart
The Service History report assists a utility’s customer service representative in dealing with consumer complaints related to the energy usage and service quality for a given billing period. The Service History report cannot exceed 35 days.
1.From Command Center Home, click Reporting > Service History to display the Service History window.
Figure 10 - 36. Service History
2.Enter the desired meter number in the Meter Number field or click the Find a Meter icon to enter alternate search criteria to locate the meter.
3.Select the Show Interruptions check box if desired.
4.Select the Apply Multiplier (Demand and Usage) check box if desired.
5.Enter the desired Start Date. If necessary, select the calendar icon and select a date.
6.Enter the desired End Date. If necessary, select the calendar icon and select a date.
NOTE: The report cannot exceed 35 days in length.
7.Select the Show Interpolated Data check box to make Command Center average (interpolate) usage for missing readings. If not selected, missing reads will simply be shown as gaps in the reported data.
8.Click the OK button to generate the Service History report.
Figure 10 - 37. Service History Report
The Service History report displays the following categories:
Account Information
•Account. Displays the customer’s account number.
•Service Location. Displays the customer’s service location.
•Customer ID. Displays the customer’s identification number.
•Date Range. Displays the selected date range of the report.
•Address. Displays the customer’s address (if applicable).
•Recent Meter Read. Displays the most recent meter reading stored in the database regardless of the selected date range.
•Date of Recent Usage. Displays the date of the Recent Meter Read.
•Billing Cycle. Displays the billing cycle type.
Usage Information
The report is displayed in chart format displaying the range of dates for the report and the kWh used on each date.
•Usage Date. Displays each day and date in the report range.
•Meter Reading. Displays the meter reading for each day of the report.
•Usage (kWh). Displays the kWh usage for each day of the report.
•Maximum Demand (kW). Displays the maximum demand usage on a given day.
•Maximum Demand Time. Displays the time of day that the maximum demand occurred.
9.Click the printer icon in the upper-right corner of the report to view a printer friendly version of the report. Use your browser’s print function to print the report.
...or...
10.Click the Mail this report icon in the upper-right corner of the report to send a copy of this report via e-mail to a chosen recipient.
11.Enter the recipient’s e-mail address in the To field.
12.Type a message in the Message field if desired.
13.Click the Send button to send the report via e-mail.
The Usage report is used to generate reports to analyze the reading data and to calculate the usage for a selected meter number or customer account number. This report can be run as a reference in a billing dispute.
1.From Command Center Home, click Reporting > Usage Report > Electric to display the Electric Usage Report window.
Figure 10 - 38. Usage Report Window
2.Enter the desired meter number in the Meter Number field or click the Find a Meter icon to enter alternate search criteria to locate the meter.
3.Select the Show Time of Use Data check box to show the time of use data on the report if desired.
4.Select the Apply Multiplier (Demand/Usage) check box if desired.
5.Select a Date format from the following:
•Quick Select. Choose a time frame from the drop-down list
...or...
•Start Date. Enter the desired Start and End Dates. If necessary select the calendar icon to generate a calendar from which to select dates.
6.Click the Submit button to generate the Electric Usage report.
NOTE: Gaps in available information (a reading is not available for a particular day) will be noted by an asterisk in the column next to the day before the missing reading and next to the day after the missing reading.
Figure 10 - 39. Electricity Usage Report
7.Use the Previous page or Next page arrows to view additional report pages if necessary.
8.Click the down arrow to Select a format to save to, and print from, and select either Excel or Acrobat (PDF) file.
NOTE: Printing from the browser is not supported. Landis+Gyr recommends exporting the file to Acrobat or Excel and then printing the report.
Overall Electricity Usage Report
The Overall Electricity Usage report allows your Engineering staff to display the total energy consumption data across your customers.
1.From Command Center Home, click Reporting > Usage Report > Electric Overall to display the Overall Electricity Usage Report window.
Figure 10 - 40. Overall Electricity Usage Report window
2.Choose from the following Selection Criteria on which to base the report:
•All. Select the All radio button to include all collectors in the report.
...or...
•Collector. Select the Collector radio button and then choose a Collector from the drop-down list to include only the selected Collector in the report.
3.(Optional) Select Apply Multiplier (Demand and Usage) if you would like the data to include a multiplier.
4.Select a Date Range from the following:
•Quick Select. Choose a time frame from the drop-down list
...or...
•Start Date. Enter the desired Start and End Dates. If necessary select the calendar icon to generate a calendar from which to select dates.
5.From the Group data by drop-down list choose either Day, Week, or Month.
6.Click the OK button to generate the Overall Electricity Usage report.
Figure 10 - 41. Overall Electricity Usage Report
The report displays the following fields:
•Total Usage (in MWh). The number of Megawatt hours used by all meters.
•Total Meters. The total number of meters.
•Average Collector Daily Usage. Average number of Megawatt hourse used per collector per day.
7.Click the Excel icon to export report results to an Excel spreadsheet.
8.Click the Printer icon to print the report results immediately.
High Usage / High Demand Usage Report
The High Usage Meters report allows you to identify the meters that are consuming high energy or demand.
1.From Command Center Home, click Reporting > Usage Report > High Usage / High Demand to display the High Usage / High Demand window.
Figure 10 - 42. High Usage/High Demand window
2.Choose from the following Selection Criteria on which to base the report:
•All. Select the All radio button to include all collectors in the report.
...or...
•Collector. Select the Collector radio button and then choose a Collector from the drop-down list to include only the selected Collector in the report.
3.Select either the Usage or Demand report type.
4.From the Show top x % of meters drop-down list, select a percentage (options range from 1%-10% in 1% increments).
5.(Optional) Select Apply Multiplier (Demand and Usage) if you would like the data to include a multiplier.
6.Select a Date Range from the following:
•Quick Select. Choose a time frame from the drop-down list
...or...
•Start Date. Enter the desired Start and End Dates. If necessary select the calendar icon to generate a calendar from which to select dates.
7.Click the OK button to generate the High Usage / High Demand report.
Figure 10 - 43. High Usage/High Demand Report
The High Usage / High Demand report displays the following information:
•Meter Number. Click the meter number link to view the Endpoint Information Window for the meter
•Type. Displays the endpoint type.
•Total Usage or Total Demand. Click the Total Usage/Total Demand link to view the Service History Report for the selected meter for the selected date.
•Organization Secondary Identifier. Displays the default secondary identifier as selected for the organization on the Organization Settings window. This could be the Customer Number, Account Number, Service Location, or Map Location.
8.Click the Excel icon to export report results to an Excel spreadsheet.
9.Click the Printer icon to print the report results immediately.
The Virtual Disconnect Report is intended to be used by utility personnel (usually Customer Service staff) as a tool to easily identify energy consumption at locations where zero usage is expected. This report can be accessed from the Dashboard or run from the Reports menu by Customer Service personnel when necessary to investigate unexpected kWh usage. Meters that are members of Disconnected or Zero Usage status groups that have reported kWh usage will be flagged on this report.
1.From Command Center Home, click Reporting > Virtual Disconnect Report to display the Virtual Disconnect Report window.
Figure 10 - 44. Virtual Disconnect Report Window
2.Select from the following options to base the report on:
•All. Select the All radio button to select all meters in the organization.
•Zero Electric Usage Group. Select the Zero Electric Usage Group radio button and then select a zero electric usage group from the drop-down list to base the report on.
•Disconnected Group. Select the Disconnected Group radio button and then select a disconnected group from the drop-down list to base the report on.
3.Click the OK button to generate the Virtual Disconnect Report.
Figure 10 - 45. Virtual Disconnect Report
The report displays the following information:
•The report heading displays the organization setting threshold for virtual disconnect usage.
•Meter number. Click on any meter number link to view the Endpoint Properties report for that meter.
•Group Type. Displays the usage monitoring group or zero usage group type:
•DIS - Disconnected
•ZU - denotes Zero Usage
•Organization Secondary Identifier. Displays the OSI (service location, account number, map location, or customer number) that was designated in the Organization Information window.
•Disconnect Date. Displays the date the meter was added to the usage group.
•Reading Date. Displays the date the endpoint reported usage.
•Usage. Displays the kWh usage to date since the disconnect date. Click any of the kWh links to view the usage report.
•Actions
•Click 
to view the Usage Report organized chronologically from the disconnect date.
•Click the Reset Virtual Disconnect Date icon to reset the virtual disconnect date. This will reset the meter’s group membership date to the current date, and remove the meter from the Virtual Disconnect Report.
•Click the Delete icon to remove the meter from either the disconnected status group or the zero usage status group.
NOTE: Click on any column header links to sort the columns in ascending or descending order.
4.Click the Print icon to print a formatted copy of the report.
From Command Center Home, click Reporting > Validation Group Report and select the desired alert to display the report.Alerts will vary depending on Command Center license activation.
|
Name |
Description |
|---|---|
|
Momentary Interruptions Alert |
Number of momentary interruptions exceed user configurable threshold. |
|
Monthly Usage Threshold Alert |
This alert helps the utility identity the meters that have exceeded the allowable monthly kWh usage. |
|
Sustained Interruptions Threshold Alert |
Number of sustained interruptions exceed user configurable threshold. |
|
Total Usage Threshold Alert |
This alert identifies the meters that have exceeded their allowable usage defined in their respective validation groups. |
|
Unexpected Demand (kW) Alert |
This alert identifies meters where the kW demand that report large jumps in demand between consecutive days. |
|
Voltage Threshold Alert |
This alert identifies the number of meters that have reported voltages that has dropped below or climbed above the configured threshold. |
|
Demand Threshold Alert |
Demand Threshold exceeds established boundaries. |
|
Daily Usage Alert |
This alert identifies the number of endpoints that have reported kWh in excess of the established daily kWh usage threshold. |
|
Residential Interval Threshold Alert |
This alert identifies the number of endpoints that have reported interval usage in excess of the interval data supported by the meter model. |
|
Commercial Interval Threshold Alert |
This alert identifies the number of endpoints that have reported interval usage in excess of the interval data supported by the meter model. |
|
Gas Meters with Suspect Readings |
This alert identifies gas meters that reported suspect readings. |
|
Unexpected Load Side Voltage Alert |
Meter assumed to be disconnected has reported Load side voltage indicating a potential case of tamper. |
|
Pressure Threshold Alert |
This alert identifies meters that have pressure threshold beyond established boundaries. |
NOTE: The Device Radio Statistics report is available with the NMM license and “Enable Endpoint Statistics Collection” must be selected in System Settings.
The Device Radio Statistics report allows the user to generate a report that can be useful in monitoring network traffic between Command Center and the network device radios (Collectors, Routers, Mesh Extenders).
Following is the procedure for generating the Device Radio Statistics Report:
1.From Command Center home, select Reporting > Device Radio Statistics Report. The Device Radio Statistics window will open.
Figure 10 - 47. Device Radio Statistics Report
2.Select Device Types. Select from the following options to filter report results:
•All. Select All to generate the report for all devices in the system
•Device Type. Select a device type from the drop down list to generate the report for the selected devices.
3.Date Range. Select a date range from the following options:
•Quick Select. Choose a date range from the drop down box.
•Start Date/End Date. Enter the desired start and end dates. If needed, select the calendar icon to generate a calendar from which to select dates.
4.Click OK. The Device Radio Packet Statistics report will open.
Figure 10 - 48. Device Radio Packet Statistics
The Device Radio Statistics report can be viewed on window or exported to Excel. Both versions provide the same information with the following columns:
•Date. Date of statistics collected for the listed device radio.
•Model Type.Device model.
•Collector. Collector through which the device radio is connected in the RF mesh network.
•Endpoint S/N. Serial number of the device radio.
•Inbound Packet. Total number of inbound packets routed through the radio.
•Outbound Packet. Total number of outbound packets routed through the radio.
•Outbound Transmit Baud Rate. Average baud rate utilized for transmitting outbound packets.
•Inbound Transmit Baud Rate. Average baud rate utilized for transmitting inbound packets.
•Outbound Receive Baud Rate. Average Baud rate with which outbound packets where received.
•Inbound Receive Baud Rate. Average Baud rate with which inbound packets where received.
NOTE: All Baud rate values are an average for that recorded day. A baud rate of '0' indicates that within that day the radio did not transmit an outgoing packets or receive incomings packets, respectively. If Geo Routing is enabled, the Inbound Transmit Baud Rate can be a non 0 value for a collector radio.
Message Communication Statistics Report
NOTE: The Message Communication Statistics report is available with the NMM license and “Enable Message Communication Statistics Collection” must be selected in System Settings.
The Message Communication Statistics Report provides the ability to view message statistics to identify network performance latency issues of individual endpoints.
Following is the procedure for generating the Message Communication Statistics Report:
1.From Command Center home, select Reporting > Message Communication Statistics Report. The Device Radio Statistics window will open.
Figure 10 - 49. Message Communication Statistics Report
2.Selection Criteria. Select from the following options to filter the report results:
•Collector. Select a collector from the drop down box.
•Electric Meter. Enter an electric meter number. If needed, select the search icon to search for the meter number through alternate criteria.
3.Select Report Output Type. Select from the following options.
•CSV
•Excel Spreadsheet
4.Date Range. Select a date range from the following options:
•Quick Select. Choose a date range from the drop down box.
•Start Date/End Date. Enter the desired start and end dates. If needed, select the calendar icon to generate a calendar from which to select dates.
5.Click OK to generate the Message Communication Statistics Report.
Figure 10 - 50. Message Communication Statistics Report.
The following data is displayed in the report:
•Date. The date of the report.
•Average Hops. Indicates the averages number of hops to the collector on the specified date.
•Min Hops. Indicates the smallest number of hops to the collector on the specified date.
•Max Hops. Indicates the largest number of hops to the collector on the specified date.
•Standard Deviation Hops. Indicates the standard deviation (how much variation there is from the average).
•Average TTL. Indicates the average Time to Live
•Min TTL. Indicates the minimum Time to Live
•Max TTL. Indicates the maximum Time to Live
The Meter Configuration Summary report displays various meter programs and their properties.
1.From Command Center Home, click Reporting > Meter Configuration Summary to display the Meter Configuration Summary page.
Figure 10 - 51. Meter Configuration Summary
The following data is displayed in the report:
•Meter Program Name. Displays the Meter Program Name. Some regions do not identify meter programs by name. In those cases, they will be identified by N/A (Meter Program CRC Value), such as N/A (12345).
•Meter Program ID. Displays the Meter Program ID if applicable.
•End Device Model.
•Number of LP Sets. Displays the number of Load Profile Sets.
•Export Meter List. Spreadsheet displays the endpoints for the Meter Program CRC.
2.Click on a Meter Program Name link to open the Device Configuration Properties window.
Figure 10 - 52. Device Configuration Properties