Spreadsheet: 110445d1307103187-automated-time-tracker-time-tracker-test
Sheet: Sheet1

DATE | JOB # | JOB NAME | TIME START | TIME FINISH | TIME USED | CODE ACTIVITY | ACTIVITY | REQUESTED BY |  |  | JOB NUMBER | JOB NAME | JOB TOTALS (HRS) | ALLOCATED (DAYS) | HOURS REMAINING | %AGE |  | ACTIVITYIES | CODES
2011-05-06 07:15:38 | 9045 | GENERAL DRAFTING | 2011-05-06 07:15:38 | 2011-05-06 08:48:07 | 1.541361111158039 |  |  |  |  |  | 9045 | GENERAL DRAFTING | 25.52771944430424 |  | -25.52771944430424 | -1 |  | PLATING | P
2011-05-06 08:48:07 | 6866 | CNBC | 2011-05-06 08:48:07 | 2011-05-06 09:17:39 | 0.4923361111432314 |  |  |  |  |  | 6866 | CNBC | 0.4923361111432314 | 12 | 95.50766388885677 | 193.9887441266145 |  | CNC PREP | CNC
2011-05-06 09:17:39 | 9045 | GENERAL DRAFTING | 2011-05-06 09:17:39 | 2011-05-06 14:32:15 | 5.243455555464607 |  |  |  |  |  | 1929 | LARK THEATRE RISERS | 0 | 5 | 40 | #N/A |  | DESIGNER CHANGES | DC
2011-05-06 14:32:15 | EOD | END OF DAY: DAILY HOURS | 2011-05-06 14:32:15 |  |  |  |  |  |  |  | 1925 | GOTHAM HALL EVENT | 0 | 8 | 64 | #N/A |  | PROJECT MANAGEMENT CHANGES | PC
 |  |  |  |  |  |  |  |  |  |  | 6877 | DR DREW | 0 | 10 | 80 | #N/A |  | MEETINGS | M
 |  |  |  |  |  |  |  |  |  |  | 1926 | LIBERTY HEAD | 0 | 7 | 56 | #N/A |  | DRAWING SCENERY | D
2011-05-09 07:21:07 | 9045 | GENERAL DRAFTING | 2011-05-09 07:21:07 | 2011-05-09 10:37:45 | 3.277163888909854 |  |  |  |  |  | 6884 | MTV WORLD STAGE | 0 | 5 | 40 | #N/A |  | [NAME] (9045) | MA
2011-05-09 10:37:45 | 1847 | P&G HERITAGE WALL | 2011-05-09 10:37:45 | 2011-05-09 14:23:35 | 3.763813888770528 |  |  |  |  |  | 1942 | VW LAUNCH | 0 |  | 0 | #N/A |  | [NAME] (9045) | R
2011-05-09 14:23:35 | EOD | END OF DAY: DAILY HOURS | 2011-05-09 14:23:35 |  |  |  |  |  |  |  | 1944 | KAI TRUSS JOB | 0 |  | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  | EOD | END OF DAY: DAILY HOURS | 0 |  | 0 | #N/A
2011-05-10 07:07:57 | 9045 | GENERAL DRAFTING | 2011-05-10 07:07:57 | 2011-05-10 14:29:38 | 7.361244444327895 |  |  |  |  |  | 6831 | RACHEL RAY | 0 |  | 0 | #N/A
2011-05-10 14:29:38 | EOD | END OF DAY: DAILY HOURS | 2011-05-10 14:29:38 |  |  |  |  |  |  |  | 1847 | P&G HERITAGE WALL | 10.39157222199719 |  | -10.39157222199719 | -1
 |  |  |  |  |  |  |  |  |  |  | 9050 | DRAWINGS FOR BID | 8.136994444357697 |  | -8.136994444357697 | -1
2011-05-11 07:05:44 | 9045 | GENERAL DRAFTING | 2011-05-11 07:05:45 | 2011-05-11 10:30:38 | 3.41494722221978 |  |  |  |  |  | 1951 | SPEED | #N/A | 5 | #N/A | #N/A
2011-05-11 10:30:38 | 1847 | P&G HERITAGE WALL | 2011-05-11 10:30:38 | 2011-05-11 14:31:59 | 4.022338888782542 |  |  |  |  |  | 6894 |  | 0 |  | 0 | #N/A
2011-05-11 14:31:59 | EOD | END OF DAY: DAILY HOURS | 2011-05-11 14:31:59 |  |  | 0 |  |  |  |  |  |  | 0 |  | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | #N/A
2011-05-12 07:14:38 | 9045 | GENERAL DRAFTING | 2011-05-12 07:14:38 | 2011-05-12 07:20:11 | 0.09249999996973202
2011-05-12 07:20:11 | 1847 | P&G HERITAGE WALL | 2011-05-12 07:20:11 | 2011-05-12 09:56:31 | 2.605419444444124
2011-05-12 09:56:31 | 9045 | GENERAL DRAFTING | 2011-05-12 09:56:31 | 2011-05-12 14:32:20 | 4.597047222254332
2011-05-12 14:32:20 | EOD | END OF DAY: DAILY HOURS | 2011-05-12 14:32:20 |  |  | 0
2011-05-13 07:00:37 | 9050 | DRAWINGS FOR BID | 2011-05-13 07:00:37 | 2011-05-13 15:08:50 | 8.136994444357697
2011-05-13 15:08:50 | 1951 | SPEED | 2011-05-13 15:08:50 | 2011-05-13 20:35:20 | 5.44169444439467
2011-05-13 20:35:20 | EOD | END OF DAY: DAILY HOURS | 2011-05-13 20:35:20 |  |  | 0
2011-05-14 13:53:08 | 1951 | SPEED | 11:00:00 | 2011-05-14 20:58:26 | 10
2011-05-14 20:58:26 | EOD | END OF DAY: DAILY HOURS | 2011-05-14 20:58:26 |  |  | 0
2011-05-16 07:14:05 | 1951 | SPEED | 2011-05-16 07:14:05 | 2011-05-16 17:16:07 | 10.03393333323766
2011-05-16 17:16:07 | EOD | END OF DAY: DAILY HOURS | 2011-05-16 17:16:07
2011-05-17 07:09:35 | 1951 | SPEED | 2011-05-17 07:09:35 | 2011-05-17 19:04:29 | 11.91511111106956
2011-05-17 19:04:29 | EOD | END OF DAY: DAILY HOURS | 2011-05-17 19:04:29 |  |  | 0
2011-05-18 07:23:13 | 1951 | SPEED | 2011-05-18 07:23:13 |  | #N/A
 |  | 0 |  |  | #N/A
 |  | 0 |  |  | #N/A
 |  | 0 |  |  | #N/A
 |  | 0 |  |  | #N/A
 |  | 0 |  |  | #N/A
 |  | 0 |  |  | #N/A
 |  | 0 |  |  | #N/A
 |  | 0 |  | 1900-01-01 00:00:00 | #N/A
 |  |  |  |  |  |  |  |  |  | 4A & 4B Complete | 0 |  | 52 HOUR ASSIGNED
 |  |  |  |  |  |  |  |  |  | 1hr under
 |  |  |  |  |  |  |  |  |  | 52 HRS |  | 6.5 DAYS = 1/2 DAY UNDER