Download User Documentation as a Word document (271KB)  

Current Revision 1.4 1/15/04

Cooper Power Systems Report Generator

 Created by Custom Computer Systems

This application automatically take the data reported by Cooper Power Systems smart devices and gives you a convenient method of generating reports on how your system is performing.  You simply select a date or date range, the substation and the feeders you want included in the report.  All tabs are automatically populated with the data for your selection.  You can print the reported data or have Excel automatically generate graphs of the data collected.

Statistics Tab

Date Range - This check box selects where you are going to get the statistics for one month or a range of months.  If it is not checked, you do not see the End Month and Year pull downs.

Substation - This pull down displays all Substations that are in the database.  Selecting a substation will change the list of Feeders to select from.

Feeders - This is a list of all the Feeders that are in the database for the selected Substation.  You select or de-select a feeder for reporting by clicking in the check box in front of the Feeder name.

Select All and Clear All - These buttons allow you to select all Feeders in the list or de-select all Feeders in the list.

List Details By Feeder - This option will display the details for all stats by feeder as displayed above.

List Details By Statistic - This option will display the details for feeders by stat as displayed below.

To Notepad - This button will take the results displayed into Notepad where you can print or save the file.  The file name is always Report.txt so if you want to save it, you must name it something else.

To Excel - This button will take the results and automatically create graphs of the data in Excel.  See next page for an example of what the output looks like.  You can print the graphs or save the Excel Workbook.  The file name is always Report.xls so if you want to save it, you must name it something else.

 Excel Output Example - Details Sheet

This is the Details sheet that is automatically generated when you hit the To Excel button.  There are separate tabs at the bottom of the sheet for each of the graphs that are automatically generated.

Excel Output Example - SAIFI Graph

Below is an example of the bar graph that automatically gets generated.  Each statistic, SAIFI, SAIDI, MAIFI and MAIFIe have their own graphs.

Fault Stats Tab

All controls on this tab function the same as on the Statistics Tab.  The only difference is the Fault data is displayed.

Device Data Tab

All controls function the same as on the Statistics tab.  This display shows you the data that was collected from the selected devices for the date range specified.

Manual Data Tab

You manually enter data for dumb devices (fused taps).  The data entered here is added to the appropriate stats.  By clicking on an item in the display list, the data is placed in the appropriate boxes above.  You can use this to speed entry by clicking on a similar occurrence and modifying the data, then click the Save button.

Substation - This pull down allow you to select a Substation.  When a Substation is selected, the display below changes to only show entries from that substation.  It also populates the Feeder pull down with the Feeders on that Substation. 

Feeder - This pull down allow you to select a Feeder.  When a Feeder is selected, the display below changes to only show entries from that Feeder.  It also populates the Tap Name pull down with the Taps on that Feeder.  If the Tap you want to enter a fault on is not in the list, simply type the name in the box and it will be added.

Show All - This button will display all manually enter data for all substations starting with the most recent.

Calculations

Calculating monthly SAIFI, SAIDI, MAIFI, MAIFIE and Customers for each selected feeder.

1. Find first record in database for the selected month and year for selected feeder.
2. Calculate how many days are involved in the between this record and the previous record for the selected feeder.
3. Calculate a daily value for each stat.
4. Add to the total stats, for the selected feeder, the daily value times the number of days between records in the selected month.
5. If this record is in next month - Go to step 8.
6. Get next record for the selected feeder.
7. Go back to step 2.
8. Get all manually entered data for selected feeder in the selected month.
9. For each record, calculate ((number of customers effected/total customers on feeder)/total customers on feeder) and add this to the appropriate stat.

Calculating total SAIFI, SAIDI, MAIFI, MAIFIE and Customers for each selected feeder.

The monthly total values for each stat are added together.  The number of Customers stat is an average of each month in the selected range.

Calculating total SAIFI, SAIDI, MAIFI, MAIFIE and Customers for ALL selected feeders.

For the selected range, the total SAIFI, SAIDI, MAIFI and MAIFIE for each selected feeder is multiplied by the total Customers on that feeder.  These values, for all selected feeders, are added together and divided by the total Customers (on all selected feeders) to give the total SAIFI, SAIDI, MAIFI and MAIFIE for all selected feeders.  

Send mail to david@davidhagemann.com with questions or comments about this web site.
Copyright © 2003 Custom Computer Systems
Last modified: October 19, 2007