Customer Management System

There are tons of systems out there trying to improve business processes of utility companies in general or electric companies in specific.

The key is still doing the re-engineering process well and the application system will just a tool to follow the processes. I put some of my thoughts about Electric Management System in this blog. Feel free to read and comment.

Friday, August 10, 2007

Simple Data Gathering Audit: Using Excel

A good Data Gathering Management System enable the system to track the time when data is gathered in the field. Of course this time stamp is obtained if only the surveyors are using hand held / HHU / PDA / TPA / Pocket PC during data gathering. Based on this information, the supervisor can extract the data together with its time stamp. Daily the supervisor should check the time stamp.

Example of data:
Data Date&Time
1,S:John D:Data1 T:Jul 28 2007 10:10AM
2,S:John D:Data2 T:Jul 28 2007 10:13AM
3,S:John D:Data3 T:Jul 28 2007 10:16AM
4,S:John D:Data4 T:Jul 28 2007 10:18AM
5,S:John D:Data5 T:Jul 28 2007 10:22AM

Supervisor can check the time of first data gathered, last data gathered, and all data in between. This can give better reasons for supervisor to question the surveyors with poor performance. Questions like:
1. Why you reach the first property/data in 2 hours?
2. Why you take a looooooong break during lunch?
3. Why you did not come directly to the office after finishing the last property/data?

No comments: