Call-Center-Dashboard.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Call Id	Date	Agent	Department	Answered (Y/N)	Resolved	Speed of Answer	AvgTalkDuration	Satisfaction rating	WEEK	DATE2	WEEKDAY
2	ID0001	01/01/2015 9:12	Diane	Washing Machine	Y	Y	109	12:02:23 am	3	1	1/1/2015	5
3	ID0002	01/01/2015 9:12	Becky	Air Conditioner	Y	N	70	12:04:02 am	3	1	1/1/2015	5
4	ID0003	01/01/2015 9:47	Stewart	Washing Machine	Y	Y	10	12:02:11 am	3	1	1/1/2015	5
5	ID0004	01/01/2015 9:47	Greg	Washing Machine	Y	Y	53	12:00:37 am	2	1	1/1/2015	5
6	ID0005	01/01/2015 10:00	Becky	Toaster	Y	Y	95	12:01:00 am	3	1	1/1/2015	5
7	ID0006	01/01/2015 10:00	Stewart	Air Conditioner	N	N				1	1/1/2015	5
8	ID0007	01/01/2015 10:22	Diane	Toaster	Y	Y	24	12:03:40 am	2	1	1/1/2015	5
9	ID0008	01/01/2015 10:22	Diane	Toaster	Y	Y	22	12:00:38 am	4	1	1/1/2015	5
10	ID0009	01/01/2015 11:13	Greg	Fridge	Y	Y	15	12:06:38 am	4	1	1/1/2015	5
11	ID0010	01/01/2015 11:13	Jim	Television	Y	Y	78	12:01:04 am	3	1	1/1/2015	5
12	ID0011	01/01/2015 11:15	Joe	Toaster	N	N				1	1/1/2015	5
13	ID0012	01/01/2015 11:15	Greg	Toaster	Y	Y	50	12:00:32 am	4	1	1/1/2015	5
14	ID0013	01/01/2015 11:52	Joe	Toaster	Y	Y	84	12:03:34 am	3	1	1/1/2015	5
15	ID0014	01/01/2015 11:52	Martha	Washing Machine	Y	Y	89	12:05:44 am	3	1	1/1/2015	5
16	ID0015	01/01/2015 11:55	Becky	Fridge	Y	Y	48	12:03:47 am	4	1	1/1/2015	5
17	ID0016	01/01/2015 11:55	Becky	Fridge	Y	Y	63	12:05:26 am	2	1	1/1/2015	5
18	ID0017	01/01/2015 11:57	Greg	Air Conditioner	Y	Y	45	12:05:32 am	5	1	1/1/2015	5
19	ID0018	01/01/2015 11:57	Becky	Fridge	N	N				1	1/1/2015	5
20	ID0019	01/01/2015 12:01	Jim	Television	N	N				1	1/1/2015	5
21	ID0020	01/01/2015 12:01	Jim	Washing Machine	Y	Y	101	12:02:27 am	3	1	1/1/2015	5
22	ID0021	01/01/2015 12:02	Jim	Air Conditioner	Y	Y	74	12:05:22 am	5	1	1/1/2015	5
23	ID0022	01/01/2015 12:02	Dan	Fridge	Y	Y	89	12:05:50 am	5	1	1/1/2015	5
24	ID0023	01/01/2015 12:02	Martha	Air Conditioner	N	N				1	1/1/2015	5
25	ID0024	01/01/2015 12:02	Joe	Air Conditioner	Y	Y	68	12:05:25 am	2	1	1/1/2015	5
26	ID0025	01/01/2015 12:30	Diane	Television	Y	Y	97	12:04:09 am	3	1	1/1/2015	5
27	ID0026	01/01/2015 12:30	Dan	Toaster	N	N				1	1/1/2015	5
28	ID0027	01/01/2015 12:40	Joe	Television	Y	Y	39	12:04:00 am	3	1	1/1/2015	5
29	ID0028	01/01/2015 12:40	Martha	Washing Machine	Y	Y	51	12:02:34 am	4	1	1/1/2015	5
30	ID0029	01/01/2015 12:40	Joe	Air Conditioner	Y	Y	106	12:02:09 am	4	1	1/1/2015	5
31	ID0030	01/01/2015 12:40	Stewart	Television	Y	Y	107	12:05:55 am	3	1	1/1/2015	5
32	ID0031	01/01/2015 13:24	Joe	Fridge	Y	Y	22	12:05:08 am	3	1	1/1/2015	5
33	ID0032	01/01/2015 13:24	Joe	Television	Y	Y	122	12:02:08 am	4	1	1/1/2015	5
34	ID0033	01/01/2015 13:33	Diane	Air Conditioner	Y	Y	57	12:06:49 am	3	1	1/1/2015	5
35	ID0034	01/01/2015 13:33	Jim	Toaster	Y	N	53	12:01:44 am	2	1	1/1/2015	5
36	ID0035	01/01/2015 13:42	Becky	Television	Y	Y	119	12:01:31 am	5	1	1/1/2015	5
37	ID0036	01/01/2015 13:42	Diane	Television	N	N				1	1/1/2015	5
38	ID0037	01/01/2015 13:42	Martha	Air Conditioner	Y	N	20	12:01:12 am	2	1	1/1/2015	5
39	ID0038	01/01/2015 13:42	Joe	Air Conditioner	Y	Y	52	12:00:36 am	3	1	1/1/2015	5
40	ID0039	01/01/2015 14:38	Stewart	Washing Machine	Y	Y	74	12:06:41 am	1	1	1/1/2015	5
41	ID0040	01/01/2015 14:38	Greg	Air Conditioner	Y	Y	49	12:02:29 am	3	1	1/1/2015	5
42	ID0041	01/01/2015 14:47	Jim	Air Conditioner	Y	Y	27	12:02:09 am	5	1	1/1/2015	5
43	ID0042	01/01/2015 14:47	Greg	Washing Machine	Y	Y	100	12:04:54 am	5	1	1/1/2015	5
44	ID0043	01/01/2015 14:47	Diane	Air Conditioner	Y	Y	45	12:06:21 am	3	1	1/1/2015	5
45	ID0044	01/01/2015 14:47	Becky	Toaster	Y	Y	98	12:03:14 am	5	1	1/1/2015	5
46	ID0045	01/01/2015 15:44	Diane	Fridge	Y	Y	25	12:05:13 am	5	1	1/1/2015	5
47	ID0046	01/01/2015 15:44	Jim	Washing Machine	N	N				1	1/1/2015	5
48	ID0047	01/01/2015 17:13	Dan	Fridge	Y	Y	107	12:02:22 am	3	1	1/1/2015	5
49	ID0048	01/01/2015 17:13	Martha	Washing Machine	N	N				1	1/1/2015	5
50	ID0049	01/01/2015 17:25	Joe	Air Conditioner	Y	Y	104	12:03:35 am	5	1	1/1/2015	5
51	ID0050	01/01/2015 17:25	Dan	Air Conditioner	N	N				1	1/1/2015	5
52	ID0051	01/01/2015 17:35	Martha	Washing Machine	N	N				1	1/1/2015	5
53	ID0052	01/01/2015 17:35	Jim	Fridge	N	N				1	1/1/2015	5
54	ID0053	01/01/2015 17:36	Stewart	Toaster	Y	Y	13	12:01:15 am	5	1	1/1/2015	5
55	ID0054	01/01/2015 17:36	Dan	Toaster	Y	Y	119	12:02:32 am	5	1	1/1/2015	5
56	ID0055	01/01/2015 17:44	Becky	Television	Y	Y	35	12:01:19 am	3	1	1/1/2015	5
57	ID0056	01/01/2015 17:44	Dan	Television	Y	Y	83	12:06:45 am	4	1	1/1/2015	5
58	ID0057	01/01/2015 17:57	Jim	Air Conditioner	Y	Y	48	12:02:52 am	2	1	1/1/2015	5
59	ID0058	01/01/2015 17:57	Stewart	Fridge	Y	Y	45	12:03:23 am	5	1	1/1/2015	5
60	ID0059	02/01/2015 9:05	Dan	Air Conditioner	Y	Y	65	12:06:00 am	5	1	2/1/2015	6
61	ID0060	02/01/2015 9:05	Dan	Washing Machine	Y	Y	50	12:04:26 am	3	1	2/1/2015	6
62	ID0061	02/01/2015 9:18	Diane	Television	Y	Y	17	12:06:15 am	3	1	2/1/2015	6
63	ID0062	02/01/2015 9:18	Joe	Air Conditioner	N	N				1	2/1/2015	6
64	ID0063	02/01/2015 9:20	Dan	Television	Y	Y	96	12:06:46 am	1	1	2/1/2015	6
65	ID0064	02/01/2015 9:20	Stewart	Television	Y	Y	90	12:06:23 am	3	1	2/1/2015	6
66	ID0065	02/01/2015 9:38	Jim	Washing Machine	Y	Y	98	12:06:25 am	2	1	2/1/2015	6
67	ID0066	02/01/2015 9:38	Diane	Air Conditioner	Y	N	90	12:01:23 am	4	1	2/1/2015	6
68	ID0067	02/01/2015 10:04	Jim	Washing Machine	Y	Y	98	12:05:49 am	5	1	2/1/2015	6
69	ID0068	02/01/2015 10:04	Jim	Washing Machine	Y	Y	70	12:03:12 am	5	1	2/1/2015	6
70	ID0069	02/01/2015 10:33	Diane	Washing Machine	Y	Y	69	12:04:45 am	4	1	2/1/2015	6
71	ID0070	02/01/2015 10:33	Diane	Fridge	N	N				1	2/1/2015	6
72	ID0071	02/01/2015 11:08	Joe	Air Conditioner	Y	Y	120	12:02:11 am	4	1	2/1/2015	6
73	ID0072	02/01/2015 11:08	Stewart	Fridge	Y	Y	113	12:05:51 am	5	1	2/1/2015	6
74	ID0073	02/01/2015 11:26	Greg	Toaster	Y	N	10	12:02:19 am	5	1	2/1/2015	6
75	ID0074	02/01/2015 11:26	Becky	Washing Machine	Y	Y	122	12:04:53 am	1	1	2/1/2015	6
76	ID0075	02/01/2015 11:42	Stewart	Air Conditioner	Y	N	125	12:01:38 am	3	1	2/1/2015	6
77	ID0076	02/01/2015 11:42	Diane	Fridge	N	N				1	2/1/2015	6
78	ID0077	02/01/2015 11:47	Martha	Air Conditioner	Y	Y	33	12:06:38 am	2	1	2/1/2015	6
79	ID0078	02/01/2015 11:47	Dan	Washing Machine	Y	Y	51	12:06:22 am	2	1	2/1/2015	6
80	ID0079	02/01/2015 11:54	Becky	Washing Machine	Y	Y	58	12:03:28 am	3	1	2/1/2015	6
81	ID0080	02/01/2015 11:54	Dan	Fridge	Y	Y	121	12:04:47 am	5	1	2/1/2015	6
82	ID0081	02/01/2015 12:00	Diane	Fridge	Y	Y	118	12:02:06 am	4	1	2/1/2015	6
83	ID0082	02/01/2015 12:00	Greg	Toaster	Y	Y	52	12:06:56 am	4	1	2/1/2015	6
84	ID0083	02/01/2015 12:20	Stewart	Fridge	Y	Y	55	12:04:44 am	3	1	2/1/2015	6
85	ID0084	02/01/2015 12:20	Dan	Washing Machine	Y	Y	68	12:05:59 am	4	1	2/1/2015	6
86	ID0085	02/01/2015 12:41	Becky	Air Conditioner	Y	Y	106	12:04:22 am	5	1	2/1/2015	6
87	ID0086	02/01/2015 12:41	Martha	Air Conditioner	Y	Y	32	12:04:36 am	3	1	2/1/2015	6
88	ID0087	02/01/2015 12:44	Jim	Toaster	N	N				1	2/1/2015	6
89	ID0088	02/01/2015 12:44	Martha	Fridge	Y	N	45	12:01:26 am	4	1	2/1/2015	6
90	ID0089	02/01/2015 12:59	Joe	Air Conditioner	Y	Y	119	12:03:32 am	4	1	2/1/2015	6
91	ID0090	02/01/2015 12:59	Dan	Television	N	N				1	2/1/2015	6
92	ID0091	02/01/2015 13:03	Jim	Washing Machine	Y	Y	46	12:05:41 am	1	1	2/1/2015	6
93	ID0092	02/01/2015 13:03	Stewart	Air Conditioner	Y	Y	101	12:01:28 am	3	1	2/1/2015	6
94	ID0093	02/01/2015 13:04	Jim	Air Conditioner	Y	Y	56	12:02:52 am	3	1	2/1/2015	6
95	ID0094	02/01/2015 13:04	Becky	Air Conditioner	Y	Y	80	12:00:53 am	3	1	2/1/2015	6
96	ID0095	02/01/2015 13:13	Diane	Television	Y	Y	24	12:01:36 am	3	1	2/1/2015	6
97	ID0096	02/01/2015 13:13	Stewart	Toaster	Y	Y	113	12:03:54 am	2	1	2/1/2015	6
98	ID0097	02/01/2015 13:20	Greg	Washing Machine	Y	Y	19	12:02:03 am	4	1	2/1/2015	6
99	ID0098	02/01/2015 13:20	Martha	Television	N	N				1	2/1/2015	6
100	ID0099	02/01/2015 13:20	Dan	Washing Machine	Y	Y	45	12:06:37 am	3	1	2/1/2015	6