Spreadsheet: 689917d1596738430-conditional-formatting-formula-for-multiple-conditions-matching-testconditional-format-2
Sheet: Follow-Up Monitoring

Employee Monitoring for COVID 19 |  |  |  |  | Work Locations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee  Information |  |  |  |  | Household Information |  |  |  |  | Screen for Return to Work
Employee Last Name | Employee First Name | Employee DOB | Employee Supervisor | OLD work locations (do not use) | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | Known Work Exposure | Date of Onset of Symptoms | Employee Test Date | Employee Result | Monitoring Type (Active/ Passive) | Employee Counseling Date | Monitoring Start Date | [NAME] | Test Date | Result |  |  | Date Screened | Result | Date Screened | Result
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | No |  | 2020-06-26 00:00:00 | positive | passive | 2020-06-26 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | No | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | negative | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | No | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | negative | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | No | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | negative | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | No | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | negative | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | No | 2020-06-29 00:00:00 | 2020-07-02 00:00:00 | negative | passive | 2020-07-02 00:00:00 | 2020-06-29 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | no | 2020-07-04 00:00:00 | 2020-07-06 00:00:00 | negative | passive | 2020-07-06 00:00:00 | 2020-07-04 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | Unknown | 2020-07-01 00:00:00 | 2020-07-06 00:00:00 | negative | passive | 2020-07-06 00:00:00 | 2020-07-01 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  | no | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | positive | passive | 2020-07-08 00:00:00 | 2020-07-07 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Yes | N/A | 2020-07-15 00:00:00 | negative | passive | 2020-07-15 00:00:00 | 2020-07-13 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Yes | N/A | 2020-07-15 00:00:00 | positive | passive | 2020-07-15 00:00:00 | 2020-07-13 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | yes | N/A | 2020-07-15 00:00:00 | negative | passive | 2020-07-15 00:00:00 | 2020-07-13 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | no | 2020-07-17 00:00:00 | 2020-07-20 00:00:00 | positive | passive | 2020-07-20 00:00:00 | 2020-07-17 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | no | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | positive | passive | 2020-07-20 00:00:00 | 2020-07-16 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | no | 2020-07-11 00:00:00 | 2020-07-20 00:00:00 | positive | passive | 2020-07-20 00:00:00 | 2020-07-11 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | yes | N/A | exp 7/16 | not tested | passive | 2020-07-20 00:00:00 | 2020-07-16 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | no | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | negative | passive | 2020-07-17 00:00:00 | 2020-07-17 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | yes | N/A | exp 7/16 | not tested | passive | 2020-07-20 00:00:00 | 2020-07-16 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | yes | 2020-07-17 00:00:00 | 2020-07-20 00:00:00 | negative | passive | 2020-07-20 00:00:00 | 2020-07-17 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  | no | 2020-07-14 00:00:00 | 2020-07-21 00:00:00 | negative | passive | 2020-07-21 00:00:00 | 2020-07-14 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | yes | 2020-07-21 00:00:00 | 2020-07-27 00:00:00 | negative | passive | 2020-07-27 00:00:00 | 2020-07-21 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | yes | 2020-07-25 00:00:00 | 2020-07-27 00:00:00 | negative | passive | 2020-07-27 00:00:00 | 2020-07-25 00:00:00
Test Person | 1 |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | no | 2020-07-20 00:00:00 | 2020-07-25 00:00:00 | positive | passive | 2020-07-29 00:00:00 | 2020-07-20 00:00:00
Test Person | 1 |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no | 2020-07-22 00:00:00 | 2020-07-28 00:00:00 | negative | passive | 2020-07-29 00:00:00 | 2020-07-22 00:00:00
Test Person | 1 |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | no | 2020-07-27 00:00:00 | 2020-07-27 00:00:00 | negative | passive | 2020-07-27 00:00:00 | 2020-07-27 00:00:00
Test Person | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | no | 2020-07-30 00:00:00 | 2020-08-03 00:00:00 | positive | passive | 2020-08-03 00:00:00 | 2020-07-30 00:00:00
Test Person | 1 |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  | no | 2020-08-01 00:00:00 | 2020-08-01 00:00:00 | negative | passive | 2020-08-01 00:00:00 | 2020-08-01 00:00:00
Test Person | 1 |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  | 2020-08-03 00:00:00 | 2020-08-03 00:00:00 | negative | passive | 2020-08-05 00:00:00 | 2020-08-03 00:00:00