Spreadsheet: 71354d1272018262-conditional-formatting-forum-log
Sheet: LOG OF PATIENTS

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D/C Team |  |  | EMI |  | Y | Active |  | Funded
 |  |  |  |  |  |  |  |  | LOG OF CHC ASSESSMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DN's |  |  | Palliative |  | N | Non-Active |  | Rejected
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMI |  |  | [NAME]
Today's Date: |  | 2010-04-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hospital
* |  |  |  |  |  |  |  |  |  |  |  |  |  | * |  |  | * |  | * |  | * |  | * |  | *
Active | PATIENT ID | PATIENT NAME | PATIENT DoB |  | DATE CHC REC'D | CHC REC'D FROM | ASSESSORS NAME | CHC CRITERIA | RECEIPT LETTER SENT |  | DATE OF LOCAL QA | PASSED LOCAL QA? | DATE REQ'D FURTHER INFO | DAYS LAPSED SINCE REQ | DATE LAST CHASED INFO | DATE REC'D INFO | DAYS TO OBTAIN INFO |  | DATE OF LOCALITY CASE REVIEW |  | DATE OF QAP | OUTCOME OF QAP | TOTAL DAYS TAKEN |  | 1st REVIEW DATE DUE | REVIEW LETTER SENT | DATE REVIEW ACTIONED
Active | 123456 | Mr [NAME] | 1920-01-01 00:00:00 |  | 2010-04-01 00:00:00 | Hospital | [NAME] | [NAME] | 2010-04-01 00:00:00 |  | 2010-04-03 00:00:00 | N | 2010-04-05 00:00:00 | 18 | 2010-04-20 00:00:00 | 2010-04-21 00:00:00 | 16 |  | 2010-04-21 00:00:00 |  | 2010-04-22 00:00:00 | Funded | 21 |  | 2011-04-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  | 2010-04-22 00:00:00 |  |  |  | 2011-04-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  | 2010-04-05 00:00:00 |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  | 2010-04-20 00:00:00 |  | 15 |  | 2011-04-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -40291 |  |  | 0 |  |  |  |  |  | 0