How to work on a spreed sheet document using the information given
Queen Mabella
Jennifer.Anderson-Clemenson-04.xlsxPast&Projected
| Clemenson Imaging | ||||
| Patient Count and Hours Tracking | ||||
| Past and Projected Values, 2017–2021 | ||||
| Month | Image | Patients | Total Hours | # of Employees |
| Jan 2017 | MRI | 500 | 1800 | 4 |
| Feb 2017 | Ultrasonography | 750 | 2400 | 5 |
| Mar 2017 | MRI | 1000 | 3000 | 3 |
| Apr 2017 | CT Scan | 500 | 1800 | 4 |
| May 2017 | MRI | 750 | 2400 | 3 |
| Jun 2017 | Ultrasonography | 1000 | 3000 | 4 |
| Jul 2017 | Angiography | 1000 | 3000 | 2 |
| Aug 2017 | CT Scan | 750 | 1800 | 2 |
| Sep 2017 | MRI | 500 | 2400 | 2 |
| Oct 2017 | Ultrasonography | 1000 | 2400 | 5 |
| Nov 2017 | Angiography | 750 | 2400 | 4 |
| Dec 2017 | CT Scan | 500 | 2400 | 3 |
| Jan 2018 | MRI | 1000 | 1800 | 2 |
| Feb 2018 | Ultrasonography | 1000 | 3000 | 3 |
| Mar 2018 | Angiography | 500 | 3000 | 4 |
| Apr 2018 | CT Scan | 750 | 1800 | 2 |
| May 2018 | MRI | 750 | 2400 | 2 |
| Jun 2018 | Ultrasonography | 750 | 3000 | 3 |
| Jul 2018 | Angiography | 500 | 3000 | 3 |
| Aug 2018 | CT Scan | 1000 | 1800 | 4 |
| Sep 2018 | MRI | 750 | 1800 | 5 |
| Oct 2018 | Ultrasonography | 750 | 2400 | 5 |
| Nov 2018 | Angiography | 1000 | 2400 | 3 |
| Dec 2018 | CT Scan | 750 | 2400 | 4 |
| Jan 2019 | MRI | 500 | 2400 | 3 |
| Feb 2019 | Ultrasonography | 1000 | 1800 | 4 |
| Mar 2019 | Angiography | 1000 | 1800 | 3 |
| Apr 2019 | CT Scan | 1000 | 1800 | 5 |
| May 2019 | MRI | 750 | 3000 | 5 |
| Jun 2019 | Ultrasonography | 750 | 3000 | 2 |
| Jul 2019 | Angiography | 500 | 3000 | 3 |
| Aug 2019 | CT Scan | 500 | 2400 | 3 |
| Sep 2019 | MRI | 750 | 1800 | 4 |
| Oct 2019 | Ultrasonography | 1000 | 2400 | 4 |
| Nov 2019 | Angiography | 1000 | 2400 | 5 |
| Dec 2019 | CT Scan | 500 | 2400 | 2 |
| Jan 2020 | MRI | 750 | 3000 | 3 |
| Feb 2020 | Ultrasonography | 750 | 3000 | 4 |
| Mar 2020 | Angiography | 1000 | 3000 | 3 |
| Apr 2020 | CT Scan | 500 | 2400 | 3 |
| May 2020 | MRI | 750 | 2400 | 2 |
| Jun 2020 | Ultrasonography | 750 | 2400 | 3 |
| Jul 2020 | Angiography | 1000 | 3000 | 4 |
| Aug 2020 | CT Scan | 750 | 2400 | 3 |
| Sep 2020 | MRI | 750 | 2400 | 4 |
| Oct 2020 | Ultrasonography | 750 | 3000 | 4 |
| Nov 2020 | Angiography | 1000 | 3000 | 3 |
| Dec 2020 | CT Scan | 500 | 1800 | 4 |
| Jan 2021 | MRI | 1000 | 1800 | 3 |
| Feb 2021 | Ultrasonography | 1000 | 1800 | 2 |
| Mar 2021 | Angiography | 1000 | 2400 | 3 |
| Apr 2021 | CT Scan | 750 | 2400 | 2 |
| May 2021 | MRI | 750 | 3000 | 4 |
| Jun 2021 | Ultrasonography | 1000 | 3000 | 2 |
| Jul 2021 | Angiography | 1000 | 3000 | 3 |
| Aug 2021 | CT Scan | 500 | 2400 | 3 |
Criteria
| Criteria Range | ||||
| Month | Image | Patients | Total Hours | # of Employees |
Expense Info
| Clemenson Imaging | |||
| Expense Report Information | |||
| Last Name | First Name | Date | Amount |
