Agile-Productivity-Dashboard1.xlsx

	B	C	D	E	F	H
1

2	PRODUCTIVITY DASHBOARD
3	TEAM CLIENT CONTACT HOURS	TEAM CLIENT CONTACT HOURS GOAL		TEAM AVERAGE		CLIENT CONTACT HOURS PER REP
4	TEAM CLIENT CONTACT HOURS	TEAM CLIENT CONTACT HOURS GOAL		TEAM AVERAGE
5	744	750		101%
6
7	TIME OVER 1 WEEK
8	REP		TOTAL CLIENT CONTACT HOURS	CLIENT CONTACT HOURS GOAL	% OF GOAL REACHED
9	Rep 1		30	30	100%
10	Rep 2		30	30	100%
11	Rep 3		34	30	113%
12	Rep 4		34	30	113%
13	Rep 5		34	30	113%
14	Rep 6		26	30	87%
15	Rep 7		25	30	83%
16	Rep 8		31	30	103%
17	Rep 9		29	30	97%
18	Rep 10		30	30	100%	ABONDONED CALLS PER REP
19	Rep 11		29	30	97%
20	Rep 12		24	30	80%
21	Rep 13		32	30	107%
22	Rep 14		31	30	103%
23	Rep 15		31	30	103%
24	Rep 16		27	30	90%
25	Rep 17		31	30	103%
26	Rep 18		24	30	80%
27	Rep 19		32	30	107%
28	Rep 20		28	30	93%
29	Rep 21		30	30	100%
30	Rep 22		28	30	93%
31	Rep 23		34	30	113%
32	Rep 24		27	30	90%
33	Rep 25		33	30	110%
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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100