This powershell script generates a timecard from a set of CSV datafiles generated by the An App A Day TimeManagment program.
The input is a bunch of CSV data files and the output is a timecard such as:
Start processing file: TimeManagement 2009MAR03.csv
Start processing file: TimeManagement.csv
Fill empty days from 3/13/2009 to 3/15/2009
Force Change data From: 3/3/2009 11:53:11 AM 3/3/2009 1:18:12 PM 01:25:01 to 10:00 AM 6:00 PM
Force Change data From: 3/13/2009 11:56:26 AM 3/13/2009 5:59:43 PM 06:03:17 to 9:30 AM 6:00 PM
Total Processing time 6.28 seconds for 16,619 valid csv entries and 623 unknown entries.
Start Timecard
03/01/2009 -
03/02/2009 07:38:19 Hours 10:50 AM-7:28 PM 1 HR lunch
03/03/2009 07:00:00 Hours 10:00 AM-6:00 PM 1 HR lunch
03/04/2009 05:31:47 Hours 10:32 AM-5:03 PM 1 HR lunch
03/05/2009 06:29:37 Hours 10:39 AM-6:09 PM 1 HR lunch
03/06/2009 05:16:34 Hours 10:29 AM-4:45 PM 1 HR lunch
03/07/2009 -
03/08/2009 -
03/09/2009 08:20:59 Hours 10:26 AM-7:47 PM 1 HR lunch
03/10/2009 06:25:30 Hours 10:08 AM-5:33 PM 1 HR lunch
03/11/2009 07:14:26 Hours 11:00 AM-7:14 PM 1 HR lunch
03/12/2009 05:45:33 Hours 11:17 AM-6:02 PM 1 HR lunch
03/13/2009 07:30:00 Hours 9:30 AM-6:00 PM 1 HR lunch
03/14/2009 ?
03/15/2009 ?
Total Time this period is 67.2 hours for 10 days. Average 6.7 hours per day.
Projected: Total Hours 70.6, Total Pay $1,764.33, Take Home $1,369.12
End Timecard
More info: http://codeblog.theg2.net/2009/03/powershell-script-for-processing.html
More info: http://www.anappaday.com/downloads/2006/09/day-2-time-management.html