Spreadsheet: 808689d1670589162-problems-with-if-and-and-formula-test-report
Sheet: Raw Data

First name | Last name | [NAME] | Job Title | Organization | Activity Name | Status | Enrollment Date | Completion date | Coupon Code | Column1 | Enrolled Week Beginning | Completed Week Beginning | Week Number Enroll | Week Number Complete | No of Days to [NAME] | No of Weeks to complete
[NAME] | Noble | [EMAIL] |  | HC-1 | L 101: Introduction to Health Care Leadership | Satisfied and Completed | 2022-11-04 06:03:00 | 2022-11-04 07:35:00 | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | L 101: Introduction to Health Care Leadership | Satisfied and Completed | 2022-11-07 07:30:00 | 2022-11-07 09:38:00 | 58895
[NAME] | McDonald | [EMAIL] | Senior Regional Director | HC-1 | L 101: Introduction to Health Care Leadership | In Progress | 2022-11-09 12:48:00 |  | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | L 101: Introduction to Health Care Leadership | Satisfied and Completed | 2022-11-17 04:41:00 | 2022-11-29 03:47:00 | 58895
[NAME] | McGurk | [EMAIL] | Regional Quality Improvement Lead |  | L 101: Introduction to Health Care Leadership | In Progress | 2022-11-21 06:53:00 |  | 58895
JULIE | THOMPSON | [EMAIL] | REGIONAL QUALITY IMPROVEMENT LEAD |  | L 101: Introduction to Health Care Leadership | In Progress | 2022-11-23 09:40:00 |  | 58895
Ian | Watt | [EMAIL] |  |  | L 101: Introduction to Health Care Leadership | Satisfied and Completed | 2022-12-06 11:21:00 | 2022-12-06 13:06:00 | 58895
[NAME] | [NAME] | [EMAIL] | Regional Quality Improvement Lead |  | L 101: Introduction to Health Care Leadership | Satisfied and Completed | 2022-11-24 09:50:00 | 2022-11-24 10:18:00 | 58895
Nicole | Sowe | [EMAIL] | Turnaround Manager |  | L 101: Introduction to Health Care Leadership | Enrolled | 2022-11-24 11:35:00 |  | 58895
Heather | Leighton | [EMAIL] | Area Director |  | L 101: Introduction to Health Care Leadership | Enrolled | 2022-11-25 10:31:00 |  | 58895
Rose | Watson | [EMAIL] | Regional Quality Improvement Lead |  | L 101: Introduction to Health Care Leadership | In Progress | 2022-11-28 07:47:00 |  | 58895
[NAME] | [NAME] | [NAME] | Turn Around Manager |  | L 101: Introduction to Health Care Leadership | In Progress | 2022-12-01 12:43:00 |  | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | L 101: Introduction to Health Care Leadership | Enrolled | 2022-12-05 11:53:00 |  | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | PFC 101: Introduction to Patient-Centered Care | Satisfied and Completed | 2022-11-07 09:42:00 | 2022-11-28 04:18:00 | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | PFC 101: Introduction to Patient-Centered Care | Satisfied and Completed | 2022-11-21 10:15:00 | 2022-11-30 09:48:00 | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | PFC 101: Introduction to Patient-Centered Care | In Progress | 2022-11-29 06:17:00 |  | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | PFC 101: Introduction to Patient-Centered Care | Enrolled | 2022-12-05 11:55:00 |  | 58895
Ian | Watt | [EMAIL] |  |  | PFC 101: Introduction to Patient-Centered Care | Satisfied and Completed | 2022-12-06 13:11:00 | 2022-12-06 14:02:00 | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | PS 101: Introduction to Patient Safety | Satisfied and Completed | 2022-11-07 09:42:00 | 2022-11-28 08:03:00 | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | PS 101: Introduction to Patient Safety | Satisfied and Completed | 2022-11-21 10:15:00 | 2022-11-28 12:05:00 | 58895
[NAME] | [NAME] | [EMAIL] | Regional Quality Improvement Lead |  | PS 101: Introduction to Patient Safety | In Progress | 2022-11-24 10:43:00 |  | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | PS 101: Introduction to Patient Safety | Enrolled | 2022-11-29 06:17:00 |  | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | PS 101: Introduction to Patient Safety | Enrolled | 2022-12-05 11:56:00 |  | 58895
Ian | Watt | [EMAIL] |  |  | PS 101: Introduction to Patient Safety | Satisfied and Completed | 2022-12-07 01:46:00 | 2022-12-07 03:23:00 | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | PS 102: From Error to Harm | Satisfied and Completed | 2022-11-07 09:43:00 | 2022-11-28 09:15:00 | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | PS 102: From Error to Harm | Enrolled | 2022-11-29 06:18:00 |  | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | PS 102: From Error to Harm | Satisfied and Completed | 2022-11-30 09:52:00 | 2022-12-05 09:23:00 | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | PS 102: From Error to Harm | Enrolled | 2022-12-05 11:56:00 |  | 58895
Ian | Watt | [EMAIL] |  |  | PS 102: From Error to Harm | Satisfied and Completed | 2022-12-07 03:24:00 | 2022-12-07 05:41:00 | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | PS 103: Human Factors and Safety | Satisfied and Completed | 2022-11-07 09:44:00 | 2022-11-29 09:03:00 | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | PS 103: Human Factors and Safety | Satisfied and Completed | 2022-11-29 05:13:00 | 2022-11-29 10:38:00 | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | PS 103: Human Factors and Safety | Enrolled | 2022-11-29 06:18:00 |  | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | PS 103: Human Factors and Safety | Enrolled | 2022-12-05 11:57:00 |  | 58895
Ian | Watt | [EMAIL] |  |  | PS 103: Human Factors and Safety | Satisfied and Completed | 2022-12-07 03:25:00 | 2022-12-07 07:10:00 | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | PS 104: Teamwork and Communication | Satisfied and Completed | 2022-11-07 09:44:00 | 2022-12-01 09:09:00 | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | PS 104: Teamwork and Communication | Enrolled | 2022-11-29 06:18:00 |  | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | PS 104: Teamwork and Communication | Satisfied and Completed | 2022-11-30 09:53:00 | 2022-12-06 06:42:00 | 58895
Gillian | Black | [EMAIL] | Area Director |  | PS 104: Teamwork and Communication | In Progress | 2022-12-01 11:21:00 |  | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | PS 104: Teamwork and Communication | Enrolled | 2022-12-05 11:57:00 |  | 58895
Ian | Watt | [EMAIL] |  |  | PS 104: Teamwork and Communication | Satisfied and Completed | 2022-12-07 03:26:00 | 2022-12-07 08:13:00 | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | PS 105: Responding to Adverse Events | Satisfied and Completed | 2022-11-07 09:44:00 | 2022-12-06 09:39:00 | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | PS 105: Responding to Adverse Events | Enrolled | 2022-11-29 06:19:00 |  | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | PS 105: Responding to Adverse Events | Satisfied and Completed | 2022-11-30 09:55:00 | 2022-12-06 11:28:00 | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | PS 105: Responding to Adverse Events | Enrolled | 2022-12-05 11:57:00 |  | 58895
Ian | Watt | [EMAIL] |  |  | PS 105: Responding to Adverse Events | Satisfied and Completed | 2022-12-07 08:15:00 | 2022-12-07 10:05:00 | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | QI 101: Introduction to Health Care Improvement | Satisfied and Completed | 2022-11-01 11:23:00 | 2022-11-02 11:48:00 | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | QI 101: Introduction to Health Care Improvement | Satisfied and Completed | 2022-11-07 09:44:00 | 2022-12-07 06:14:00 | 58895
Maxine | Smedley | [EMAIL] | Managing Director |  | QI 101: Introduction to Health Care Improvement | Enrolled | 2022-11-25 06:27:00 |  | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | QI 101: Introduction to Health Care Improvement | Enrolled | 2022-11-29 06:19:00 |  | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | QI 101: Introduction to Health Care Improvement | Enrolled | 2022-12-05 11:58:00 |  | 58895
Ian | Watt | [EMAIL] |  |  | QI 101: Introduction to Health Care Improvement | In Progress | 2022-12-07 10:08:00 |  | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | QI 102: How to Improve with the Model for Improvement | Satisfied and Completed | 2022-11-07 09:44:00 | 2022-12-07 11:08:00 | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | QI 102: How to Improve with the Model for Improvement | Satisfied and Completed | 2022-11-16 04:10:00 | 2022-11-21 08:37:00 | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | QI 102: How to Improve with the Model for Improvement | Enrolled | 2022-11-29 06:19:00 |  | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | QI 102: How to Improve with the Model for Improvement | Enrolled | 2022-12-05 11:58:00 |  | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | QI 103: Testing and Measuring Changes with PDSA Cycles | Enrolled | 2022-11-07 09:45:00 |  | 58895
Maxine | Smedley | [EMAIL] | Managing Director |  | QI 103: Testing and Measuring Changes with PDSA Cycles | Enrolled | 2022-11-25 06:28:00 |  | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | QI 103: Testing and Measuring Changes with PDSA Cycles | Enrolled | 2022-11-29 06:20:00 |  | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | QI 103: Testing and Measuring Changes with PDSA Cycles | Satisfied and Completed | 2022-11-30 09:50:00 | 2022-11-30 11:08:00 | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | QI 103: Testing and Measuring Changes with PDSA Cycles | Enrolled | 2022-12-05 11:59:00 |  | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | QI 104: Interpreting Data: Run Charts, Control Charts, and Other Measurement Tools | Enrolled | 2022-11-07 09:45:00 |  | 58895
Maxine | Smedley | [EMAIL] | Managing Director |  | QI 104: Interpreting Data: Run Charts, Control Charts, and Other Measurement Tools | Enrolled | 2022-11-25 06:28:00 |  | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | QI 104: Interpreting Data: Run Charts, Control Charts, and Other Measurement Tools | Enrolled | 2022-11-29 06:20:00 |  | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | QI 104: Interpreting Data: Run Charts, Control Charts, and Other Measurement Tools | Satisfied and Completed | 2022-11-30 09:50:00 | 2022-12-01 09:25:00 | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | QI 104: Interpreting Data: Run Charts, Control Charts, and Other Measurement Tools | Enrolled | 2022-12-05 11:59:00 |  | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | QI 105: Leading Quality Improvement | Enrolled | 2022-11-07 09:45:00 |  | 58895
Rose | Watson | [EMAIL] | Regional Quality Improvement Lead |  | QI 105: Leading Quality Improvement | Enrolled | 2022-11-28 07:44:00 |  | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | QI 105: Leading Quality Improvement | Enrolled | 2022-11-29 06:20:00 |  | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | QI 105: Leading Quality Improvement | Satisfied and Completed | 2022-11-30 09:54:00 | 2022-12-01 12:05:00 | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | QI 105: Leading Quality Improvement | Enrolled | 2022-12-05 11:53:00 |  | 58895
Maxine | Smedley | [EMAIL] | Managing Director |  | QI 201: Planning for Spread: From Local Improvements to System-Wide Change | Enrolled | 2022-11-25 06:27:00 |  | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | TA 101: Introduction to the Triple Aim for Populations | Satisfied and Completed | 2022-11-03 11:24:00 | 2022-12-07 11:11:00 | 58895
[NAME] | [NAME] | [EMAIL] | Quality Improvement Manager | HC-1 | TA 101: Introduction to the Triple Aim for Populations | Enrolled | 2022-11-07 09:45:00 |  | 58895
[NAME] | Kowaliczek | [EMAIL] | General Site Manager |  | TA 101: Introduction to the Triple Aim for Populations | Enrolled | 2022-11-29 06:20:00 |  | 58895
[NAME] | Jenks | [EMAIL] | Dementia Care Manager |  | TA 101: Introduction to the Triple Aim for Populations | Enrolled | 2022-12-05 12:00:00 |  | 58895
[NAME] | Noble | [EMAIL] |  | HC-1 | IHI Open School Basic Certificate Program | Satisfied and Completed | 2022-12-07 11:11:00 | 2022-12-07 11:11:00 | 58895