Mike Hyde's Special Projects

NNEC Data Auditor

The NNEC Data Auditor is a set of programs that were created to verify data integrity within and between various systems at NNEC.

Abnormal Usage Report

This report shows abnormal usages. These are usage that are reported as less than 0 kWh, or more than 400 kWh. This report will show the net metering members, and the larger consumption users. This report is run twice a day after the daily reads are loaded into the CIS. The first run is to show what lwas loaded into CIS from the AMR system. The second run is after some erratic reads,have been corrected by the "Fix Abnormal Reads.asp" script.
Contents of "AbnormalUsageReport.bat."

:: The following are daily audit scripts that perform some data integrity checks.
::
"c:\program files\internet explorer\iexplore.exe" www.insidennec.com/NNECDAS/scheduledjobs/Abnormal Usage Report.asp?Mode=B
exit

Abnormal Usage Fix

This is a script that runs in an attempt to correct erratic AMR reading by the TWACS AMR system. It replaces any reads reported as "OK" by the AMR system, but that calculates a daily usage of less trhan 400 kWh or more than 400 kWh for any Rate 100 Account. The script sends an email for each record modified in the CIS, so all actions are logged. This is currently run at 12:55 PM, every day.
Contents of "\\NNEC03\c\inetpub\wwwroot\nnecdas\batchfiles\FixAbnormalReads.bat."

:: FixAbnormalReads.bat :: "c:\program files\internet explorer\iexplore.exe" http://www.insidennec.com/NNECDAS/ScheduledJobs/FixAbnormalReads.asp exit

Blink Report

This report shows locations that had 2 or more blinks. The blinks are reported by the TWACS AMR system, and transferred to the CIS along with the billing reads. The blinks are stored in the BLPBLINK file in the Daffron CIS.
This is a scheduled job on NNEC03, "Blink Report" that runs "C:\Inetpub\wwwroot\NNECDAS\BatchFiles\Blink Report.bat" every day at 1:10 PM.

The blinks can also be viewed in the CIS, by pressing Shift-F6, while in Customer Inquiry.

CRC Disconnect List

This report shows locations that are disconnected. It runs, via a scheduled job, at 4:30 and 5:00 PM by executing c:\inetpub\ComputerRoom\CRC\Disconects.bat file on \\NNEC03. It also create 2 files. The first file "c:\inetpub\wwwroot\computerroom\crc\crcdisc.txt" gets copied to "d:\CRC-CIC\disconnects\crcdisc.txt" for CRC. The second file, c:\inetpub\wwwroot\computerroom\crc\NonPayForDisspatch.txt" gets copied to "m:\Milsoft\Billing\NonPayForDisspatch.txt" for Milsoft.

Daily kWh Total

This report shows the total kWh sold by day, based off of the AMR meter readings. This data is obtained by adding all the daily usages, by type, after tthey are loaded into the CIS. Those totals, are stored in a Access database "\\NNEC03\c\inetpub\wwwroot\database\Intranet.mdb" for tracking.
This is a Windows scheduled job, "Daily Usage Summary Job" runs "C:\Inetpub\wwwroot\NNECDAS\BatchFiles\Daily Usage Summary.bat" every day at 12:57 PM.
Contents of Daily Usage Summary.bat.
Sample Daily kWh Total eMail:

Daily Variance Report

This report shows locations that did not have usage in the past day, but had usage in the last billed month. It is currently emailed each day to the VP of IT & Customer Service and the General Manager. The report is also viewable from the NNECDAS toolbar.

Delinquent Report

This report is run just prior to each Board Meetinmg, to verify that no employees are delinquent.

Devices With No Protective Devices in AMR Report

This report shows devices in the AMR system that do not have a protective device. This report gets emailed to the computer room each week day morning. There is a scheduled job which attempts to correct these, based off of the "\\nnec03\c\inetpub\wwwroot\nnecdas\meter protective device_fromDB.asp" script that is run daily.

DRU's in CIS Not In AMR Report

This report looks for DRU's that are in the CIS system, and are not in AMR. This report gets emailed to the computrer room each week day morning.

DRU's in AMR Not In CIS Report

This report looks for DRU's that are in the AMR system, but are not in the CIS system. This report gets emailed to the computer room each week day morning. Hopefully there are none.

DSIs in AMR not on CIS Report

This report looks for DSI's that are in the AMR system, and are not in CIS. This report gets emailed to the computrer room each week day morning.

DSIs in CIS not in AMR Report

This report looks for DSI's that are in the CIS system, but are not in AMR. This report gets emailed to the computer room each week day morning.

Incomplete 911 Address Report

This report shows accounts where the address is not a street address. This report gets emailed to the computer room each week day morning.

Inactive Locations with Usage Report

This report shows locations that are marjked inactive in the CIS, but had usage. This could either be a tamper, or sometimes a leaking boot. This report gets emailed to the computer room each week day morning.

Large Power Wrong Book Report

LP Accounts Report

MANS Hourly Report

This report shows accounts that are not set to read hourly in the AMR system. Clicking on the "fix" link will auomatically run a SQL in the AMR system to set the reads to hourly. This report gets emailed to the computer room each week day morning.

Meters in CIS not in AMR Report

This report shows meters that are in the CIS system, but are not in the AMR system. This report gets emailed to the computrer room each week day morning.

Meters with Cycle of 0 Report

This report shows the meters tin the TWACS AMR system that have a cycle of 0. This report should always be blank because the read jobs in the TWACS system are by cycle. A meter with a cycle of 0 will never be read by the AMR system.

Multiple Paths one Location Report

This is a report that shows devices in the TWACS AMR system that are at the same location, but are reading or replying from different paths. This is still unexplainable at this time.

Outstanding Service Orders Report

This report shows the Open Service Orders that are in the CIS. They are grouped by type, and the color code reflects the number of service Orders open for that type. This report gets emailed to the computer room each week day morning.

Stat 6 Accounts with Credit Balance Report

This report shows Stat 6 accounts that have a credit balance. This report gets emailed to the computer room each week day morning.

Street Light Wrong Rate Report

This report shows accounts where the street light rate is incorrect. This report gets emailed to the computer room each week day morning.

Tax Counties Report

This report shows accounts where the tax district may be invalid. This report gets emailed to the computer room each week day morning.

Undiscoverable Meters Report

This report shows the meters that have been entered into the AMR system, but for whatever reason, have not been discovered (Searched in). This report gets emailed to the computrer room each week day morning.

Update Protective Devices in AMR

This is a script that updated the protective device field in the AMR system, from the protective device table in the "\\nnec03\wwwroot\database\nnecdas.mdb" database. This updates by location (premise ID) to update any devices that have been changed (Meters, DSI's, DRU's, LCT's).