Spreadsheet: 148527d1333456687-request-for-suggestions-about-how-best-to-display-some-information-patient-infection-record
Sheet: Sheet1

Patient name | Date of admission | Date of discharge | Total nights in hospital | No of days with infection | Total days infections by | Input infection code daily |  |  |  | Man Flu = 1 |  | Scurvy = 2 |  | [NAME] finger nail = 3
 | Admission |  |  |  | 34 | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00 | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-14 00:00:00 | 2012-04-15 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-20 00:00:00 | 2012-04-21 00:00:00 | 2012-04-22 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-28 00:00:00 | 2012-04-29 00:00:00 | 2012-04-30 00:00:00 | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-03 00:00:00 | 2012-05-04 00:00:00 | 2012-05-05 00:00:00 | 2012-05-06 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00 | 2012-05-12 00:00:00 | 2012-05-13 00:00:00 | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-16 00:00:00 | 2012-05-17 00:00:00 | 2012-05-18 00:00:00 | 2012-05-19 00:00:00 | 2012-05-20 00:00:00 | 2012-05-21 00:00:00 | 2012-05-22 00:00:00 | 2012-05-23 00:00:00 | 2012-05-24 00:00:00 | 2012-05-25 00:00:00 | 2012-05-26 00:00:00 | 2012-05-27 00:00:00 | 2012-05-28 00:00:00 | 2012-05-29 00:00:00 | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-01 00:00:00 | 2012-06-02 00:00:00 | 2012-06-03 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 2012-06-09 00:00:00 | 2012-06-10 00:00:00 | 2012-06-11 00:00:00 | 2012-06-12 00:00:00 | 2012-06-13 00:00:00 | 2012-06-14 00:00:00 | 2012-06-15 00:00:00 | 2012-06-16 00:00:00 | 2012-06-17 00:00:00 | 2012-06-18 00:00:00 | 2012-06-19 00:00:00 | 2012-06-20 00:00:00 | 2012-06-21 00:00:00 | 2012-06-22 00:00:00 | 2012-06-23 00:00:00 | 2012-06-24 00:00:00 | 2012-06-25 00:00:00 | 2012-06-26 00:00:00 | 2012-06-27 00:00:00 | 2012-06-28 00:00:00 | 2012-06-29 00:00:00 | 2012-06-30 00:00:00 | 2012-07-01 00:00:00 | 2012-07-02 00:00:00 | 2012-07-03 00:00:00 | 2012-07-04 00:00:00 | 2012-07-05 00:00:00 | 2012-07-06 00:00:00 | 2012-07-07 00:00:00 | 2012-07-08 00:00:00 | 2012-07-09 00:00:00 | 2012-07-10 00:00:00 | 2012-07-11 00:00:00 | 2012-07-12 00:00:00 | 2012-07-13 00:00:00 | 2012-07-14 00:00:00 | 2012-07-15 00:00:00 | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00 | 2012-07-21 00:00:00 | 2012-07-22 00:00:00 | 2012-07-23 00:00:00 | 2012-07-24 00:00:00 | 2012-07-25 00:00:00 | 2012-07-26 00:00:00 | 2012-07-27 00:00:00 | 2012-07-28 00:00:00 | 2012-07-29 00:00:00 | 2012-07-30 00:00:00 | 2012-07-31 00:00:00
 |  |  |  |  | Ward | 10 | 16 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Beaky | 2012-03-29 00:00:00 |  | 5 | 2 | 2 | 2 | 2
[NAME] | 2012-03-27 00:00:00 |  | 7 | 2 | 6 | 2 | 2
[NAME] | 2012-03-27 00:00:00 |  | 7 | 3 | 1 | 1 | 1 | 1
[NAME] | 2012-03-31 00:00:00 |  | 3 | 2 | 5 |  | 1 | 1
[NAME] | 2012-03-28 00:00:00 |  | 6 | 2 | 4 | 1 | 1
George | 2012-04-01 00:00:00 |  | 2 | 2 | 5 | 1 | 1
[NAME] | 2012-03-29 00:00:00 |  | 5 | 2 | 4 | 3 | 3
[NAME] | 2012-03-28 00:00:00 |  | 6 | 2 | 6 |  | 1 | 1
Jones | 2012-04-02 00:00:00 |  | 1 | 2 | 3 | 2 | 2
[NAME] | 2012-04-02 00:00:00 |  | 1 | 2 | 5 |  | 2 | 2
Titch | 2012-03-26 00:00:00 | 2012-04-02 00:00:00 | 7 | 1 | 5 | 3
Mick | 2012-03-27 00:00:00 |  | 7 | 2 | 3 | 3 | 3
[NAME] | 2012-03-30 00:00:00 |  | 4 | 2 | 4 |  | 1 | 1
Ringo | 2012-03-30 00:00:00 |  | 4 | 2 | 2 |  | 1 | 1
[NAME] | 2012-03-31 00:00:00 |  | 3 | 2 | 2 |  | 2 | 2
Smith | 2012-04-01 00:00:00 | 2012-04-03 00:00:00 | 2 | 2 | 2 | 1 | 1
[NAME] | 2012-03-28 00:00:00 |  | 6 | 2 | 1 |  | 2 | 2