Spreadsheet: 195051d1353409066-multiple-dates-gantt-gantt-test-multiple-dates
Sheet: gantt

I:\SHARE\audits\Audit Tools in Excel\Gant-Template.xls
 |  |  |  |  | 1 | a | 1 | b | 2 | c | 2 | d | 3 | e | 3 | f | 4 | g | 4 | h | 5 | i |  |  | j | k | 5 | L | 6 | m | 6 | n | 7 | o | 7 | p | 8 | q | 8 | r | 9 | s | 9 | t | 10 | u | 10
 |  |  |  | Patient Details | Admitted date |  | Discharge Date |  | Admitted date |  | Discharge Date |  | Admitted date |  | Discharge Date |  | Admitted date |  | Discharge Date |  | Admitted date |  |  | First Positive Date |  |  | Discharge Date |  | Admitted date |  | Discharge Date |  | Admitted date |  | Discharge Date |  | Admitted date |  | Discharge Date |  | Admitted date |  | Discharge Date |  | Admitted date |  | Discharge Date
 | 2011-03-23 00:00:00 | 0 | 0 | PATIENT 1 | 2011-03-14 00:00:00 | 0 | 2011-03-14 00:00:00 | 0 | 2011-03-14 00:00:00 | 1 | 2011-03-15 00:00:00 | 0 | 2011-03-15 00:00:00 | 2 | 2011-03-17 00:00:00 | 0 | 2011-03-17 00:00:00 | 6 | 2011-03-23 00:00:00 | 0 | 2011-03-23 00:00:00 | 11 | 2011-04-03 00:00:00 | 2011-04-03 00:00:00 | 1 | 15 | 2011-04-19 00:00:00 | -40652 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 2011-03-14 00:00:00 | 0 | 0 | PATIENT 2 | 2011-03-14 00:00:00 | 0 | 2011-03-14 00:00:00 | 0 | 2011-03-14 00:00:00 | 0 | 2011-03-14 00:00:00 | 0 | 2011-03-14 00:00:00 | 0 | 2011-03-14 00:00:00 | 0 | 2011-03-14 00:00:00 | 0 | 2011-03-14 00:00:00 | 0 | 2011-03-14 00:00:00 | 23 | 2011-04-06 00:00:00 | 2011-04-06 00:00:00 | 1 | 15 | 2011-04-22 00:00:00 | -40655 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 2011-03-08 00:00:00 | 0 | 0 | PATIENT 3 | 2011-03-08 00:00:00 | 0 | 2011-03-08 00:00:00 | 0 | 2011-03-08 00:00:00 | 0 | 2011-03-08 00:00:00 | 0 | 2011-03-08 00:00:00 | 0 | 2011-03-08 00:00:00 | 0 | 2011-03-08 00:00:00 | 0 | 2011-03-08 00:00:00 | 0 | 2011-03-08 00:00:00 | 36 | 2011-04-13 00:00:00 | 2011-04-13 00:00:00 | 1 | 56 | 2011-06-09 00:00:00 | 0 | 2011-06-09 00:00:00 | 25 | 2011-07-04 00:00:00 | 1 | 2011-07-05 00:00:00 | 0 | 2011-07-05 00:00:00 | 0 | 2011-07-05 00:00:00 | 504 | 2012-11-20 00:00:00 | -41233 |  | 0 |  | 0 |  | 0
 | 2011-04-13 00:00:00 | 0 | 0 | PATIENT 4 | 2011-03-16 00:00:00 | 1 | 2011-03-17 00:00:00 | 0 | 2011-03-17 00:00:00 | 1 | 2011-03-18 00:00:00 | 0 | 2011-03-18 00:00:00 | 24 | 2011-04-11 00:00:00 | 0 | 2011-04-11 00:00:00 | 2 | 2011-04-13 00:00:00 | 0 | 2011-04-13 00:00:00 | 2 | 2011-04-15 00:00:00 | 2011-04-15 00:00:00 | 1 | 20 | 2011-05-06 00:00:00 | 11 | 2011-05-17 00:00:00 | 28 | 2011-06-14 00:00:00 | -40708 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 2011-04-16 00:00:00 | 0 | 0 | PATIENT 5 | 2011-04-15 00:00:00 | 0 | 2011-04-15 00:00:00 | 0 | 2011-04-15 00:00:00 | 0 | 2011-04-15 00:00:00 | 0 | 2011-04-15 00:00:00 | 0 | 2011-04-15 00:00:00 | 0 | 2011-04-15 00:00:00 | 1 | 2011-04-16 00:00:00 | 0 | 2011-04-16 00:00:00 | 5 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 1 | 5 | 2011-04-27 00:00:00 | 0 | 2011-04-27 00:00:00 | 0 | 2011-04-27 00:00:00 | 0 | 2011-04-27 00:00:00 | 0 | 2011-04-27 00:00:00 | -40660 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 2011-03-26 00:00:00 | 0 | 0 | PATIENT 6 | 2011-03-26 00:00:00 | 0 | 2011-03-26 00:00:00 | 0 | 2011-03-26 00:00:00 | 0 | 2011-03-26 00:00:00 | 0 | 2011-03-26 00:00:00 | 0 | 2011-03-26 00:00:00 | 0 | 2011-03-26 00:00:00 | 0 | 2011-03-26 00:00:00 | 0 | 2011-03-26 00:00:00 | 31 | 2011-04-26 00:00:00 | 2011-04-26 00:00:00 | 1 | 2 | 2011-04-29 00:00:00 | -40662 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 2011-04-06 00:00:00 | 0 | 0 | PATIENT 7 | 2011-03-09 00:00:00 | 0 | 2011-03-09 00:00:00 | 0 | 2011-03-09 00:00:00 | 7 | 2011-03-16 00:00:00 | 0 | 2011-03-16 00:00:00 | 3 | 2011-03-19 00:00:00 | 0 | 2011-03-19 00:00:00 | 18 | 2011-04-06 00:00:00 | 0 | 2011-04-06 00:00:00 | 20 | 2011-04-26 00:00:00 | 2011-04-26 00:00:00 | 1 | 17 | 2011-05-14 00:00:00 | -40677 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0