Mike Hyde's Special Projects

Special Projects

This page was developed to show interested individuals some of the special projects I have created while working in the Electric Cooperative Industry. Maybe something on here will give someone ideas on a project they would like to work on. Please feel free to let me know if you have any comments or questions. I will add more as time permits.
If you would like to be notified when I make changes to these pages, just let me know. Please email me, I am really interested in hearing what you have to say, both good and bad

Thanks, Mike

Reports

Most of these reoports are being rewritten, if there is no compatible solution in our new CIS system.

Report NameOn-requestScheduledWeb basedEmailedDescription
Abnormal Usage ReportNoYesNoDaily
1300
This report show all locations that used less than 0 and over 500 kWh the previous day. This report helps find meter that have reset, reversed or mysteriously deviated from a normal usage pattern.
Blink ReportNoYesNoDaily
1300
This report shows all locations that experienced a blink the previous day.
Daily Member Usage AlertNoYesNoDaily 1300 An email, sent to members, showing them their usage for the previous day, the hi and low temperatures for that day, and a dollar cost of that usage.
DSI StatusYesNoYesNo This report shows all DSI's, and provides a one-click link to ping all of them and view the ping results.
Failed Meter ReadYesNoYesYes Emailed to Operations and TNS Operators when a meter fails to read, when read using either the Map or web application..
Hourly Account AuditNoYesNoDaily 0100 This report lists any meters that are supposed to be reading hourly (As set in the CIS) that are not setup correctly in TWACS.
Hourly Usage Member AlertNoYesNoDaily 1400 An email, sent to members, showing them their usage for the previous day, by hour in a graph.
Inactive Locations with Usage NoYesNoDaily
1300
This report show all locations that are set as inactive in the CIS, but had usage the previous day. This report helps find tampers, SO's that may have gotten "Misplaced."
Incomplete 911 AddressNoYesNoDaily 0100 This report lists all locations in the CIS that have an incomplete 911 Address. This is emailed to the IT Dept, CSR's and the Mapping group.
LCT StatusYesNoYesNo This report shows all LCT's, and provides a one-click link to ping all of them and view the ping results.
Meters with Cycle 0NoYesNoDaily 0100 This report lists all meters in TWACS that have a cycle of 0.
Meter Tamper HistoryYesNoYesNo Show list of all accounts in CIS with the tamper flag set
Aclara devices - One Location, Multiple PathsYesYesYesDaily
1300
This shows a location, with more than one device, where the devices are reporting a different path.
Outage Alert NotificationNoYesNoYes Emailed to Duty Supervisors and Managers when outage count changes. The check is made every 4 minutes
Tax DistrictsNoYesNoDaily 0100 This report lists any accounts where the tax districts are not set.
Weekly Usage Member AlertNoYesNoFridays
1430
An email, sent to members, showing them their usage for the past 30 in a graph, with the high and low temperature for that day.

Presentations