Spreadsheet: 137633d1327285644-date-range-check-sched-comp-test
Sheet: Sheet1

wonum | actstart | actfinish | schedstart | schedfinish | Compliance Yes / No | Percent of Jobs that Are completed with date range
1 | 2012-01-04 14:40:00 | 2012-01-04 14:40:00 | 2011-12-14 13:56:00 | 2011-12-16 08:00:00
2 |  |  | 2011-12-16 13:02:00 | 2011-12-20 08:00:00
3 |  |  | 2011-12-20 12:08:00 | 2011-12-21 08:00:00
4 |  |  | 2011-12-21 11:41:00 | 2011-12-22 08:00:00
5 | 2011-12-09 10:43:00 | 2011-12-09 10:43:00 | 2011-12-22 11:14:00 | 2011-12-23 08:00:00
6 | 2011-11-11 06:40:00 | 2011-12-09 15:09:00 | 2011-12-23 11:29:00 | 2011-12-23 14:29:00
7 | 2011-12-30 08:11:00 | 2012-01-20 14:42:00 | 2011-12-02 09:29:00 | 2011-12-05 09:02:00
8 |  |  | 2011-12-23 10:50:00 | 2011-12-26 08:00:00
9 | 2011-12-08 07:16:00 | 2011-12-16 15:15:00 | 2011-12-08 14:12:00 | 2011-12-09 07:48:00
10 |  |  | 2011-12-26 10:23:00 | 2011-12-27 09:56:00
11 |  |  | 2011-12-27 09:56:00 | 2011-12-28 09:29:00
12 |  |  | 2011-12-28 09:29:00 | 2011-12-29 09:02:00
13 |  |  | 2011-12-29 09:02:00 | 2011-12-30 08:35:00
14 | 2011-11-04 11:19:00 | 2011-12-16 12:38:00 | 2011-12-29 09:29:00 | 2011-12-29 12:29:00
15 | 2011-11-23 08:57:00 |  | 2011-12-07 08:08:00 | 2011-12-09 07:17:00
16 | 2011-11-09 10:44:00 | 2011-12-13 07:13:00 | 2011-12-09 15:17:00 | 2011-12-12 14:50:00
17 | 2011-12-07 12:10:00 | 2011-12-07 12:10:00 | 2011-12-08 07:41:00 | 2011-12-09 07:17:00
18 | 2011-12-15 07:12:00 | 2011-12-15 15:30:00 | 2011-12-16 11:29:00 | 2011-12-16 13:29:00
19 | 2011-12-29 11:11:00 | 2012-01-20 14:40:00 | 2011-12-05 09:02:00 | 2011-12-06 08:35:00
20 |  |  | 2011-12-16 13:29:00 | 2011-12-16 15:29:00
21 | 2011-11-24 07:48:00 | 2011-11-30 08:46:00 | 2011-12-12 14:50:00 | 2011-12-13 14:23:00
22 | 2011-10-21 14:45:00 | 2011-12-23 07:30:00 | 2011-12-07 09:01:00 | 2011-12-07 11:01:00
23 | 2011-12-13 13:46:00 | 2011-12-13 14:35:00 | 2011-12-13 07:48:00 | 2011-12-13 13:48:00
24 | 2011-11-23 11:28:00 |  | 2011-12-09 07:17:00 | 2011-12-09 15:17:00
25 |  |  | 2011-12-06 08:35:00 | 2011-12-07 08:08:00
26 | 2011-11-10 09:06:00 | 2011-11-16 11:55:00 | 2011-12-07 08:08:00 | 2011-12-08 07:41:00
27 | 2011-12-13 10:32:00 | 2011-12-13 12:27:00 | 2011-12-13 15:48:00 | 2011-12-14 10:48:00
28 | 2011-11-18 13:30:00 | 2011-12-06 12:07:00 | 2011-12-05 12:32:00 | 2011-12-05 14:32:00
29 | 2011-12-09 06:47:00 | 2011-12-09 09:33:00 | 2011-12-02 08:59:00 | 2011-12-02 14:59:00
30 |  |  | 2011-12-02 14:59:00 | 2011-12-05 12:29:00
31 | 2012-01-05 09:19:00 | 2012-01-05 10:20:00 | 2011-12-05 12:29:00 | 2011-12-06 09:59:00
32 |  |  | 2011-12-06 09:59:00 | 2011-12-07 07:29:00
33 |  |  | 2011-12-07 07:29:00 | 2011-12-07 13:29:00
34 |  |  | 2011-12-07 13:29:00 | 2011-12-08 11:29:00
35 | 2011-12-12 12:48:00 | 2011-12-13 10:31:00 | 2011-12-08 11:29:00 | 2011-12-09 08:59:00
36 |  |  | 2011-12-09 08:59:00 | 2011-12-09 14:59:00
37 | 2011-12-22 14:14:00 | 2011-12-23 11:14:00 | 2011-12-09 14:59:00 | 2011-12-12 10:29:00
38 | 2011-12-02 07:57:00 | 2011-12-02 11:23:00 | 2011-12-12 10:29:00 | 2011-12-12 14:29:00
39 | 2011-11-22 06:41:00 | 2011-11-22 09:01:00 | 2011-12-12 14:29:00 | 2011-12-13 07:59:00
40 | 2011-11-25 15:35:00 | 2011-11-25 15:35:00 | 2011-12-13 07:59:00 | 2011-12-13 09:59:00
41 | 2011-11-24 13:50:00 | 2011-11-24 15:10:00 | 2011-12-13 09:59:00 | 2011-12-13 11:59:00
42 | 2011-11-28 10:55:00 | 2011-11-28 13:30:00 | 2011-12-14 09:29:00 | 2011-12-14 11:29:00