clemenson Excel

Past&Projected

Clemenson Imaging
Patient Count and Hours Tracking
Past and Projected Values, 2013–2017
Month	Image	Patients	Total Hours	# of Employees
Jan 2013	MRI	500	1800	4
Feb 2013	Ultrasonography	750	2400	5
Mar 2013	MRI	1000	3000	3
Apr 2013	CT Scan	500	1800	4
May 2013	MRI	750	2400	3
Jun 2013	Ultrasonography	1000	3000	4
Jul 2013	Angiography	1000	3000	2
Aug 2013	CT Scan	750	1800	2
Sep 2013	MRI	500	2400	2
Oct 2013	Ultrasonography	1000	2400	5
Nov 2013	Angiography	750	2400	4
Dec 2013	CT Scan	500	2400	3
Jan 2014	MRI	1000	1800	2
Feb 2014	Ultrasonography	1000	3000	3
Mar 2014	Angiography	500	3000	4
Apr 2014	CT Scan	750	1800	2
May 2014	MRI	750	2400	2
Jun 2014	Ultrasonography	750	3000	3
Jul 2014	Angiography	500	3000	3
Aug 2014	CT Scan	1000	1800	4
Sep 2014	MRI	750	1800	5
Oct 2014	Ultrasonography	750	2400	5
Nov 2014	Angiography	1000	2400	3
Dec 2014	CT Scan	750	2400	4
Jan 2015	MRI	500	2400	3
Feb 2015	Ultrasonography	1000	1800	4
Mar 2015	Angiography	1000	1800	3
Apr 2015	CT Scan	1000	1800	5
May 2015	MRI	750	3000	5
Jun 2015	Ultrasonography	750	3000	2
Jul 2015	Angiography	500	3000	3
Aug 2015	CT Scan	500	2400	3
Sep 2015	MRI	750	1800	4
Oct 2015	Ultrasonography	1000	2400	4
Nov 2015	Angiography	1000	2400	5
Dec 2015	CT Scan	500	2400	2
Jan 2016	MRI	750	3000	3
Feb 2016	Ultrasonography	750	3000	4
Mar 2016	Angiography	1000	3000	3
Apr 2016	CT Scan	500	2400	3
May 2016	MRI	750	2400	2
Jun 2016	Ultrasonography	750	2400	3
Jul 2016	Angiography	1000	3000	4
Aug 2016	CT Scan	750	2400	3
Sep 2016	MRI	750	2400	4
Oct 2016	Ultrasonography	750	3000	4
Nov 2016	Angiography	1000	3000	3
Dec 2016	CT Scan	500	1800	4
Jan 2017	MRI	1000	1800	3
Feb 2017	Ultrasonography	1000	1800	2
Mar 2017	Angiography	1000	2400	3
Apr 2017	CT Scan	750	2400	2
May 2017	MRI	750	3000	4
Jun 2017	Ultrasonography	1000	3000	2
Jul 2017	Angiography	1000	3000	3
Aug 2017	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

1

2

3

4

5

6

7

8

A

B

C

Patient Count and Hours Tracking

Past and Projected Values, 2013

–

2017

Month

Image

Patients

Jan 2013

MRI

500

Feb 2013

Ultrasonography

750

Mar 2013

MRI

1000

Apr 2013

CT Scan

500

Clemenson Imaging