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
etc...

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?