Spreadsheet: 767392d1644438058-end-date-from-multiple-criteria-and-rows-max-of-audit-date
Sheet: Sheet1

Audit Date | Area Audited | location  (vicinity) | Finding | - | Comment / Details | Initial Date | C/O Close out date | AWO or  CAPA # | AWO or [NAME] to | AWO or CAPA Closed | Date Closed | Comment / Action to be taken
2021-11-10 00:00:00 | WC1 | C1F1 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-11-10 00:00:00 | WC1 | C1F10 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-11-10 00:00:00 | WC1 | C1F11 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-11-10 00:00:00 | WC1 | C1F2 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | Area Audited | location  (vicinity) | Finding | Initial Date | Max of Audit Date
2021-11-10 00:00:00 | WC1 | C1F3 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | WC1 | C1F1 | Fan Cleaning | 2021-11-10 00:00:00 | 2022-01-27 00:00:00
2021-11-10 00:00:00 | WC1 | [NAME] | [NAME] and Brittle Plastics | - | Broken reflector on conveyor | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | WC1 | C1F10 | Fan Cleaning | 2021-11-10 00:00:00 | 2022-01-27 00:00:00
2021-11-10 00:00:00 | WC1 | Pallet Stacking Station | Non GMP repair | - | Putty knife used to shim table leg | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | WC1 | C1F11 | Fan Cleaning | 2021-11-10 00:00:00 | 2022-01-27 00:00:00
2021-12-17 00:00:00 | WC1 | C1F1 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | WC1 | C1F2 | Fan Cleaning | 2021-11-10 00:00:00 | 2022-01-27 00:00:00
2021-12-17 00:00:00 | WC1 | C1F10 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | WC1 | C1F3 | Fan Cleaning | 2021-11-10 00:00:00 | 2022-01-27 00:00:00
2021-12-17 00:00:00 | WC1 | C1F11 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | WC1 | [NAME] | [NAME] and Brittle Plastics | 2021-11-10 00:00:00 | 2022-01-27 00:00:00
2021-12-17 00:00:00 | WC1 | C1F2 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | WC1 | Pallet Stacking Station | Non GMP repair | 2021-11-10 00:00:00 | 2022-01-27 00:00:00
2021-12-17 00:00:00 | WC1 | C1F3 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | WC2 | C1F1 | Fan Cleaning | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2021-12-17 00:00:00 | WC1 | [NAME] | [NAME] and Brittle Plastics | - | Broken reflector on conveyor | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | WC2 | C1F10 | Fan Cleaning | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2021-12-17 00:00:00 | WC1 | Pallet Stacking Station | Non GMP repair | - | Putty knife used to shim table leg | 2021-11-10 00:00:00 | C/O |  |  |  |  |  |  | WC2 | C1F11 | Fan Cleaning | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-27 00:00:00 | WC1 | C1F1 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | 2022-01-27 00:00:00 |  |  |  |  |  |  | WC2 | C1F2 | Fan Cleaning | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-27 00:00:00 | WC1 | C1F10 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | 2022-01-27 00:00:00 |  |  |  |  |  |  | WC2 | C1F3 | Fan Cleaning | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-27 00:00:00 | WC1 | C1F11 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | 2022-01-27 00:00:00 |  |  |  |  |  |  | WC2 | [NAME] | [NAME] and Brittle Plastics | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-27 00:00:00 | WC1 | C1F2 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | 2022-01-27 00:00:00 |  |  |  |  |  |  | WC2 | Pallet Stacking Station | Non GMP repair | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-27 00:00:00 | WC1 | C1F3 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | 2022-01-27 00:00:00 |  |  |  |  |  |  | Grand Total |  |  |  | 2022-01-28 00:00:00
2022-01-27 00:00:00 | WC1 | [NAME] | [NAME] and Brittle Plastics | - | Broken reflector on conveyor | 2021-11-10 00:00:00 | 2022-01-27 00:00:00
2022-01-27 00:00:00 | WC1 | Pallet Stacking Station | Non GMP repair | - | Putty knife used to shim table leg | 2021-11-10 00:00:00 | 2022-01-27 00:00:00
2021-11-10 00:00:00 | WC2 | C1F1 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-11-10 00:00:00 | WC2 | C1F10 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-11-10 00:00:00 | WC2 | C1F11 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-11-10 00:00:00 | WC2 | C1F2 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-11-10 00:00:00 | WC2 | C1F3 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-11-10 00:00:00 | WC2 | [NAME] | [NAME] and Brittle Plastics | - | Broken reflector on conveyor | 2021-11-10 00:00:00 | C/O
2021-11-10 00:00:00 | WC2 | Pallet Stacking Station | Non GMP repair | - | Putty knife used to shim table leg | 2021-11-10 00:00:00 | C/O
2021-12-17 00:00:00 | WC2 | C1F1 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-12-17 00:00:00 | WC2 | C1F10 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-12-17 00:00:00 | WC2 | C1F11 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-12-17 00:00:00 | WC2 | C1F2 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-12-17 00:00:00 | WC2 | C1F3 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | C/O
2021-12-17 00:00:00 | WC2 | [NAME] | [NAME] and Brittle Plastics | - | Broken reflector on conveyor | 2021-11-10 00:00:00 | C/O
2021-12-17 00:00:00 | WC2 | Pallet Stacking Station | Non GMP repair | - | Putty knife used to shim table leg | 2021-11-10 00:00:00 | C/O
2022-01-28 00:00:00 | WC2 | C1F1 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-28 00:00:00 | WC2 | C1F10 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-28 00:00:00 | WC2 | C1F11 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-28 00:00:00 | WC2 | C1F2 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-28 00:00:00 | WC2 | C1F3 | Fan Cleaning | - | Needs quarterly cleaning | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-28 00:00:00 | WC2 | [NAME] | [NAME] and Brittle Plastics | - | Broken reflector on conveyor | 2021-11-10 00:00:00 | 2022-01-28 00:00:00
2022-01-28 00:00:00 | WC2 | Pallet Stacking Station | Non GMP repair | - | Putty knife used to shim table leg | 2021-11-10 00:00:00 | 2022-01-28 00:00:00