Spreadsheet: 154631d1336498585-sumproduct-would-it-help-to-gather-daily-average-and-daily-total-from-other-sheet-to-edit22
Sheet: Category1

Email address | Date | SCORE | The advisor's attitude | The advisor's expertise in [NAME] products | The advisor's understanding of your query | TEXT | Category | Type | Action done | Incident #
email address1 | 2012-04-18 06:54:00 | 19 | 5 | 4 | 5
email address1 | 2012-04-18 21:05:00 | 6 | 1 | 1 | 1
email address1 | 2012-04-18 11:39:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-18 14:50:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-18 18:07:00 | 12 | 3 | 3 | 3
email address1 | 2012-04-18 12:17:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-18 11:05:00 | 14 | 1 | 4 | 4 | text1
email address1 | 2012-04-18 09:53:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-18 12:40:00 | 17 | 5 | 4 | 5 | text2
email address1 | 2012-04-18 12:46:00 | 6 | 2 | 2 | 2 | text 3
email address1 | 2012-04-18 19:13:00 | 16 | 5 | 3 | 5 | text4
email address1 | 2012-04-18 10:11:00 | 14 | 2 | 3 | 4
email address1 | 2012-04-18 09:50:00 | 17 | 5 | 5 | 4 | text5
email address1 | 2012-04-18 00:23:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-18 19:32:00 | 17 | 4 | 4 | 4
email address1 | 2012-04-18 11:27:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-18 19:21:00 | 6 | 3 | 2 | 1 | text6
email address1 | 2012-04-18 13:26:00 | 3 | 1 | 1 | 1
email address1 | 2012-04-18 23:27:00 | 18 | 5 | 3 | 5 | text7
email address1 | 2012-04-18 20:20:00 | 16 | 4 | 4 | 3 | text7
email address1 | 2012-04-18 23:49:00 | 20 | 5 | 5 | 5 | text7
email address1 | 2012-04-18 00:59:00 | 20 | 5 | 5 | 5 | text7
email address1 | 2012-04-18 14:58:00 | 20 | 5 | 5 | 5 | text7
email address1 | 2012-04-18 08:39:00 | 16 | 5 | 3 | 5 | text7
email address1 | 2012-04-18 16:32:00 | 20 | 5 | 5 | 5 | text7
email address1 | 2012-04-18 12:04:00 | 17 | 4 | 4 | 4
email address1 | 2012-04-18 17:13:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-18 15:20:00 | 17 | 4 | 4 | 4
email address1 | 2012-04-18 19:01:00 | 13 | 4 | 3 | 3 | [NAME]
email address1 | 2012-04-18 12:06:00 | 18 | 5 | 5 | 5 | [NAME]
email address1 | 2012-04-18 19:47:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-18 02:35:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-18 01:12:00 | 17 | 4 | 4 | 4 | text
email address1 | 2012-04-19 14:59:00 | 18 | 5 | 5 | 5
email address1 | 2012-04-19 14:22:00 | 15 | 4 | 3 | 3
email address1 | 2012-04-19 07:03:00 | 10 | 3 | 1 | 1 | [NAME]
email address1 | 2012-04-19 16:25:00 | 4 | 2 | 1 | 1 | [NAME] |  |  |  | 120420-006962
email address1 | 2012-04-19 09:04:00 | 16 | 5 | 4 | 4 | [NAME]
email address1 | 2012-04-19 23:48:00 | 20 | 5 | 5 | 5 | [NAME]
email address1 | 2012-04-19 11:12:00 | 20 | 5 | 5 | 5 | [NAME]
email address1 | 2012-04-19 09:25:00 | 16 | 4 | 3 | 4 | [NAME]
email address1 | 2012-04-19 17:23:00 | 3 | 1 | 1 | 1 | [NAME]
email address1 | 2012-04-19 15:40:00 | 20 | 5 | 5 | 5 | [NAME]
email address1 | 2012-04-19 10:45:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-19 01:18:00 | 20 | 5 | 5 | 5 | text10
email address1 | 2012-04-19 08:49:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-19 10:39:00 | 14 | 4 | 3 | 4 | text10
email address1 | 2012-04-19 15:24:00 | 19 | 5 | 4 | 5 | text10
email address1 | 2012-04-19 11:36:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-19 19:02:00 | 20 | 5 | 5 | 5 | text10
email address1 | 2012-04-19 17:11:00 | 16 | 5 | 4 | 4 | text10
email address1 | 2012-04-19 12:14:00 | 18 | 5 | 3 | 5 | No.
email address1 | 2012-04-19 05:53:00 | 18 | 5 | 5 | 5
email address1 | 2012-04-19 19:08:00 | 11 | 4 | 2 | 2 | text10
email address1 | 2012-04-19 00:48:00 | 18 | 5 | 5 | 5 | text10
email address1 | 2012-04-19 06:21:00 | 20 | 5 | 5 | 5 | text10
email address1 | 2012-04-19 13:34:00 | 20 | 5 | 5 | 5 | text10
email address1 | 2012-04-19 08:40:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-19 11:29:00 | 12 | 3 | 3 | 3 | text10
email address1 | 2012-04-20 05:50:00 | 9 | 2 | 2 | 2 | text10
email address1 | 2012-04-20 19:27:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-20 15:05:00 | 4 | 2 | 1 | 1 | text10
email address1 | 2012-04-20 17:20:00 | 18 | 5 | 4 | 4
email address1 | 2012-04-20 14:27:00 | 15 | 4 | 3 | 3 | text10
email address1 | 2012-04-20 23:01:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-21 16:05:00 | 20 | 5 | 5 | 5 | text10
email address1 | 2012-04-21 10:03:00 | 20 | 5 | 5 | 5
email address1 | 2012-04-21 11:32:00 | 9 | 3 | 3 | 3 | text10
email address1 | 2012-04-22 08:41:00 | 3 | 1 | 1 | 1 | text10 |  |  |  | 120424-004708
email address1 | 2012-04-22 19:55:00 | 7 | 3 | 1 | 3 | text10 |  |  |  | 120424-004889
email address1 | 2012-04-23 19:00:00 | 17 | 4 | 4 | 4 |  |  |  |  | 120424-002697
email address1 | 2012-04-23 12:07:00 | 20 | 5 | 5 | 5 | ok
email address1 | 2012-04-24 10:35:00 | 7 | 1 | 2 | 1 | text10
email address1 | 25/04/2012 12:08 AM | 14 | 4 | 2 | 5 |  | Partially
email address1 | 25/04/2012 03:35 PM | 17 | 4 | 4 | 4 | text10 | Yes
email address1 | 26/04/2012 12:07 PM | 3 | 1 | 1 | 1 | text10 | No
email address1 | 27/04/2012 12:24 AM | 3 | 1 | 1 | 1 | text10 | No
email address1 | 30/04/2012 04:07 PM | 8 | 1 | 1 | 1 | text10 | Yes