NP_EX19_6a_FirstLastName_1
expmen
NP_EX19_6a_Smith_1.xlsxDocumentation
| New Perspectives Excel 2019 | Module 6: SAM Project 1a | |
| Oval Lake Hospital | |
| MANAGING YOUR DATA WITH DATA TOOLS | |
| Author: | Jumah Saleh |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Cancer Center
| Oval Lake Hospital | |||||
| Patients Admitted 2021-2023 | |||||
| Department | Admission | Service | 2021 | 2022 | 2023 |
| Cancer Center | Inpatient | Diagnosis | 2,252 | 1,914 | 1,550 |
| Cancer Center | Outpatient | Other | 841 | 891 | 1,149 |
| Cancer Center | Inpatient | Other | 592 | 704 | 866 |
| Cancer Center | Outpatient | Imaging | 3,923 | 3,335 | 2,935 |
| Cancer Center | Outpatient | Surgery | 653 | 627 | 558 |
| Cancer Center | Inpatient | Surgery | 7,894 | 6,631 | 6,565 |
| Cancer Center | Outpatient | Consultation | 1,288 | 1,649 | 1,814 |
| Cancer Center | Inpatient | Hospice | 81 | 92 | 107 |
Cardiac Care
| Oval Lake Hospital | |||||
| Patients Admitted 2021-2023 | |||||
| Department | Admission | Service | 2021 | 2022 | 2023 |
| Cardiac Care | Inpatient | Surgery | 18,904 | 16,636 | 18,632 |
| Cardiac Care | Outpatient | Consultation | 3,190 | 3,350 | 4,121 |
| Cardiac Care | Inpatient | Diagnosis | 7,803 | 9,910 | 12,189 |
| Cardiac Care | Outpatient | Other | 1,788 | 1,842 | 2,247 |
| Cardiac Care | Outpatient | Imaging | 4,502 | 5,673 | 5,786 |
| Cardiac Care | Outpatient | Surgery | 525 | 525 | 488 |
| Cardiac Care | Inpatient | Hospice | 44 | 51 | 48 |
Maternity
| Oval Lake Hospital | |||||
| Patients Admitted 2021-2023 | |||||
| Department | Admission | Service | 2021 | 2022 | 2023 |
| Maternity | Delivery | Natural | 3,396 | 4,279 | 4,921 |
| Maternity | Inpatient | Non-maternity | 1,322 | 1,408 | 1,296 |
| Maternity | Inpatient | Other | 226 | 287 | 339 |
| Maternity | Outpatient | Imaging | 7,795 | 8,964 | 7,440 |
| Maternity | Outpatient | Consultation | 5,208 | 5,781 | 6,128 |
| Maternity | Outpatient | Other | 2,253 | 2,298 | 2,873 |
| Maternity | Inpatient | Procedure | 1,252 | 1,189 | 1,213 |
| Maternity | Outpatient | Surgery | 285 | 259 | 298 |
| Maternity | Delivery | Surgical | 5,084 | 5,033 | 5,234 |
| Maternity | Inpatient | Pre-labor | 556 | 428 | 496 |
Psychiatric
| Oval Lake Hospital | |||||
| Patients Admitted 2021-2023 | |||||
| Department | Admission | Service | 2021 | 2022 | 2023 |
| Psychiatric | Outpatient | Other | 6,256 | 5,881 | 6,587 |
| Psychiatric | Inpatient | Diagnosis | 1,803 | 1,857 | 1,523 |
| Psychiatric | Inpatient | Other | 628 | 754 | 618 |
| Psychiatric | Inpatient | Substance | 884 | 972 | 902 |
| Psychiatric | Outpatient | Labs | 3,893 | 3,620 | 4,018 |
| Psychiatric | Outpatient | Other | 6,256 | 5,881 | 6,587 |
| Psychiatric | Outpatient | Therapy | 10,051 | 9,548 | 10,789 |
| Psychiatric | Inpatient | Surgery | 51 | 44 | 44 |
| Psychiatric | Outpatient | Imaging | 523 | 450 | 518 |
| Psychiatric | Inpatient | 3-day hold | 796 | 812 | 918 |
All Departments
| Oval Lake Hospital | |||||
| Patients Admitted 2021-2023 | |||||
| Department | Admission | Service | 2021 | 2022 | 2023 |
| Cancer Center | Inpatient | Diagnosis | 2,252 | 1,914 | 1,550 |
| Cancer Center | Inpatient | Hospice | 81 | 92 | 107 |
| Cancer Center | Inpatient | Other | 592 | 704 | 866 |
| Cancer Center | Inpatient | Surgery | 7,894 | 6,631 | 6,565 |
| Cancer Center | Outpatient | Consultation | 1,288 | 1,649 | 1,814 |
| Cancer Center | Outpatient | Imaging | 3,923 | 3,335 | 2,935 |
| Cancer Center | Outpatient | Other | 841 | 891 | 1,149 |
| Cancer Center | Outpatient | Surgery | 653 | 627 | 558 |
| Cardiac Care | Inpatient | Diagnosis | 7,803 | 9,910 | 12,189 |
| Cardiac Care | Inpatient | Hospice | 44 | 51 | 48 |
| Cardiac Care | Inpatient | Other | 2,855 | 3,540 | 3,752 |
| Cardiac Care | Inpatient | Surgery | 18,904 | 16,636 | 18,632 |
| Cardiac Care | Outpatient | Consultation | 3,190 | 3,350 | 4,121 |
| Cardiac Care | Outpatient | Imaging | 4,502 | 5,673 | 5,786 |
| Cardiac Care | Outpatient | Other | 1,788 | 1,842 | 2,247 |
| Cardiac Care | Outpatient | Surgery | 525 | 525 | 488 |
| Maternity | Delivery | Natural | 3,396 | 4,279 | 4,921 |
| Maternity | Delivery | Surgical | 5,084 | 5,033 | 5,234 |
| Maternity | Inpatient | Non-maternity | 1,322 | 1,408 | 1,296 |
| Maternity | Inpatient | Other | 226 | 287 | 339 |
| Maternity | Inpatient | Pre-labor | 556 | 428 | 496 |
| Maternity | Inpatient | Procedure | 1,252 | 1,189 | 1,213 |
| Maternity | Outpatient | Consultation | 5,208 | 5,781 | 6,128 |
| Maternity | Outpatient | Imaging | 7,795 | 8,964 | 7,440 |
| Maternity | Outpatient | Other | 2,253 | 2,298 | 2,873 |
| Maternity | Outpatient | Surgery | 285 | 259 | 298 |
| Psychiatric | Inpatient | 3-day hold | 796 | 812 | 918 |
| Psychiatric | Inpatient | Diagnosis | 1,803 | 1,857 | 1,523 |
| Psychiatric | Inpatient | Other | 628 | 754 | 618 |
| Psychiatric | Inpatient | Substance | 884 | 972 | 902 |
| Psychiatric | Inpatient | Surgery | 51 | 44 | 44 |
| Psychiatric | Outpatient | Imaging | 523 | 450 | 518 |
| Psychiatric | Outpatient | Labs | 3,893 | 3,620 | 4,018 |
| Psychiatric | Outpatient | Other | 6,256 | 5,881 | 6,587 |
| Psychiatric | Outpatient | Therapy | 10,051 | 9,548 | 10,789 |
| Total Admissions |
