Spreadsheet: 541785d1507553092-conditional-formatting-for-daily-average-for-analysts-cond-formatting
Sheet: Sheet1

 |  |  |  |  | Daily Incident Resolution Tracker by Engineer
 |  |  | Total resolved | Average Resolved per Day | 2017-01-03 00:00:00 | 2017-01-04 00:00:00 | 2017-01-05 00:00:00 | 2017-01-06 00:00:00 | 2017-01-09 00:00:00 | 2017-01-10 00:00:00 | 2017-01-11 00:00:00 | 2017-01-12 00:00:00 | 2017-01-13 00:00:00 | 2017-01-16 00:00:00 | 2017-01-17 00:00:00 | 2017-01-18 00:00:00 | 2017-01-19 00:00:00 | 2017-01-20 00:00:00 | 2017-01-23 00:00:00 | 2017-01-24 00:00:00 | 2017-01-25 00:00:00 | 2017-01-26 00:00:00 | 2017-01-27 00:00:00 | 2017-01-30 00:00:00 | 2017-01-31 00:00:00 | 2017-02-02 00:00:00 | 2017-02-03 00:00:00 | 2017-02-06 00:00:00 | 2017-02-07 00:00:00 | 2017-02-08 00:00:00 | 2017-02-09 00:00:00 | 2017-02-10 00:00:00 | 2017-02-13 00:00:00 | 2017-02-14 00:00:00 | 2017-02-15 00:00:00
 |  | Overall Open Incident Volume
 |  | Agent1 |  |  | 12 | 18 | 18 | 9 | 10 | 15 | 13 | 11 | 7 | 18 | 13 | 8 | 13 | 16 | N/A | N/A | N/A | N/A | N/A | 11 | 12 | 12 | 11 | N/A | N/A | N/A | N/A | N/A | N/A | 10 | 9
 |  | Agent2 |  |  | 29 | 10 | 9 | 5 | 9 | 12 | 10 | 15 | N/A | 8 | 10 | 15 | 12 | 12 | N/A | N/A | N/A | N/A | N/A | 19 | 9 | 3 | 7 | N/A | N/A | N/A | N/A | N/A | 15 | N/A | 13
12 |  | Agent3 |  |  | 35 | 17 | 27 | 33 | 22 | 18 | 22 | 19 | 12 | 26 | 17 | N/A | N/A | N/A | 24 | 36 | 36 | 23 | 25 | 20 | 17 | 12 | 12 | 22 | 17 | 22 | 18 | 18 | 22 | 17 | 17
 |  | Agent4 |  |  | 30 | 29 | 19 | 18 | 17 | 15 | N/A | 12 | 20 | 13 | 23 | 20 | 14 | 17 | 16 | 20 | 28 | 25 | 18 | 31 | 22 | 15 | 12 | 32 | 1 | 1 | 27 | 17 | 19 | 18 | 16
 |  | Agent5 |  |  | 17 | 15 | 11 | 12 | 20 | 18 | 17 | 14 | 12 | 20 | 12 | 17 | 16 | 24 | 20 | 27 | 24 | 15 | 24 | 12 | 19 | 11 | 17 | 19 | 18 | 14 | 27 | 9 | 17 | 11 | 29
 |  | Agent6 |  |  | 3 | 26 | 13 | 10 | 19 | 20 | N/A | 17 | 15 | 9 | 9 | 9 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 18 | 15 | 12 | 12 | N/A | N/A | N/A | N/A | N/A | 25 | 13 | 16
 |  | Agent7 |  |  | N/A | N/A | N/A | N/A | 20 | 12 | 11 | 8 | 20 | 12 | 5 | 14 | 8 | 20 | 27 | N/A | N/A | 15 | 16 | 9 | 10 | 13 | 12 | 18 | 11 | 21 | 5 | 11 | 16 | 14 | 21
 |  | Agent8 |  |  | 18 | 18 | 20 | 12 | 17 | 14 | 9 | 14 | 19 | 13 | 16 | 12 | 10 | 10 | N/A | N/A | N/A | N/A | N/A | 18 | 12 | 14 | 12 | N/A | N/A | N/A | N/A | N/A | 15 | 12 | 17
 |  | Agent9 |  |  | 4 | 2 | 5 | 11 | 2 | 7 | 1 | 5 | 1 | 1 | 1 | 4 | 2 | 0 | 5 | 17 | 5 | N/A | N/A | 0 | 3 | 0 | 1 | 6 | 5 | N/A | N/A | 0 | 1 | 1 | 2
 |  | Agent10 |  |  | 40 | 3 | N/A | 14 | 29 | 25 | 28 | 26 | 13 | 19 | 21 | 28 | 21 | 19 | 19 | N/A | N/A | 24 | 34 | N/A | N/A | 18 | 21 | 30 | 31 | 28 | 31 | 19 | 24 | 15 | 27
 |  | Agent11 |  |  | 21 | 18 | 13 | 8 | 22 | 23 | 21 | 15 | 19 | 13 | 15 | 16 | 12 | 16 | 23 | 17 | 27 | 14 | 14 | 19 | 20 | 14 | 14 | 18 | 11 | 15 | 11 | 6 | 16 | 15 | 9
 |  | Agent13 |  |  | 7 | 1 | 11 | 13 | 12 | 14 | 13 | 24 | 16 | 22 | 11 | 13 | 24 | 23 | 26 | 23 | 28 | 23 | 26 | 14 | 14 | 8 | 13 | 31 | 30 | 19 | 21 | 9 | 25 | 22 | 12
 |  | Agent14 |  |  | 21 | 13 | 22 | 1 | 8 | 3 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | N/A | N/A | N/A
 |  | Agent15 |  |  | 0
 |  | Agent16 |  |  | 5 | 1 | 25 | 12 | 17 | 35 | 32 | 11 | 14 | 21 | 22 | 26 | 13 | 21 | 26 | 41 | 32 | 17 | 20 | N/A | 20 | 17 | 12 | 21 | 16 | 21 | 25 | 18 | 30 | 14 | 27