Excel 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
A B C D E F G H I J
Row Labels Sum of Total Hours Sum of Patients
Angiography 35,400 11,250
CT Scan 30,000 9,250
MRI 35,400 11,250
Ultrasonography 36,600 12,250
Grand Total 137,400 44,000
0 10,000 20,000 30,000 40,000 50,000 60,000
Angiography
CT Scan
MRI
Ultrasonography
Sum of Total Hours
Sum of Patients
Values
Image
SOLUTION SAMPLE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
A B C D E
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
Clemenson Imaging
SOLUTION SAMPLE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
A B C D E F G H I J K
Patient Count and Hours Tracking
Past and Projected Values, 2013 –2017 Extract Range
Month Image Patients Total Hours
# of
Employees Month Image Patients Total Hours
# of
Employees Jan 2013 MRI 500 1800 4 Apr 2015 CT Scan 1000 1800 5 Feb 2013 Ultrasonography 750 2400 5 Aug 2015 CT Scan 500 2400 3 Mar 2013 MRI 1000 3000 3 Dec 2015 CT Scan 500 2400 2 Apr 2013 CT Scan 500 1800 4 Apr 2016 CT Scan 500 2400 3
May 2013 MRI 750 2400 3 Aug 2016 CT Scan 750 2400 3 Jun 2013 Ultrasonography 1000 3000 4 Dec 2016 CT Scan 500 1800 4 Jul 2013 Angiography 1000 3000 2 Jan 2017 MRI 1000 1800 3
Aug 2013 CT Scan 750 1800 2 Apr 2017 CT Scan 750 2400 2 Sep 2013 MRI 500 2400 2 ####### MRI 750 3000 4 Oct 2013 Ultrasonography 1000 2400 5 Aug 2017 CT Scan 500 2400 3
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
Clemenson Imaging
SOLUTION SAMPLE
1
2
3
4
A B C D E
Criteria Range
Month Image Patients Total Hours
# of
Employees >12/31/16 mri
>12/31/14 ct scan
SOLUTION SAMPLE
1
2
3
4
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
36
37
A B C D
Clemenson Imaging Expense Report Information
Last Name First Name Date Amount Allen Average $692 Bashir Atef 1/1/2016 $635 Bashir Atef 2/1/2016 $575 Bashir Atef 3/1/2016 $655 Bashir Atef 4/1/2016 $655 Bashir Atef 5/1/2016 $655 Bashir Atef 6/1/2016 $655 Bashir Average $638 Gabrys Elizabeth 1/1/2016 $555 Gabrys Elizabeth 2/1/2016 $635 Gabrys Elizabeth 3/1/2016 $765 Gabrys Elizabeth 4/1/2016 $765 Gabrys Elizabeth 5/1/2016 $765 Gabrys Elizabeth 6/1/2016 $765 Gabrys Average $708 Gomez Paola 1/1/2016 $845 Gomez Paola 2/1/2016 $435 Gomez Paola 3/1/2016 $535 Gomez Paola 4/1/2016 $535 Gomez Paola 5/1/2016 $535 Gomez Paola 6/1/2016 $535 Gomez Average $570 McAllister Average $586 Grand Average $633
SOLUTION SAMPLE