Spreadsheet: 494450d1482400535-conditional-formatting-with-multiple-criteria-team-full-stats-record-editable-v2
Sheet: April

 | OTM
 | Name |  | Team Quality Checks |  |  |  |  |  |  |  |  | Rating |  | Accreditation QA MTD |  |  |  | BAU QA MTD |  |  |  | Team Total MTD
 |  |  | Acc/BAU | Call | Written | Call | Written | Call | Written | Call | Written |  |  | Result | Ammount | % |  | Result | Ammount | % |  | Result | Ammount | %
Acc | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Pass |  |  |  | Pass |  |  |  | Pass
BAU | 2 |  |  |  |  |  |  |  |  |  |  |  |  | Rec |  |  |  | Rec |  |  |  | Rec
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | AR |  |  |  | AR |  |  |  | AR
Pass | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass Total
Rec | 5
AR | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overall Pass
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
 | Total
 |  | Acc pass | Acc Rec | Acc AR | Total Pas | All Total | BAU Pass | BAU Rec | BAU AR | Total Pas | All Total
 | Total's
Number of Items Worked
Name |  |  | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-06 00:00:00 | 2016-04-07 00:00:00 | 2016-04-08 00:00:00 | 2016-04-09 00:00:00 | 2016-04-10 00:00:00 | 2016-04-11 00:00:00 | 2016-04-12 00:00:00 | 2016-04-13 00:00:00 | 2016-04-14 00:00:00 | 2016-04-15 00:00:00 | 2016-04-16 00:00:00 | 2016-04-17 00:00:00 | 2016-04-18 00:00:00 | 2016-04-19 00:00:00 | 2016-04-20 00:00:00 | 2016-04-21 00:00:00 | 2016-04-22 00:00:00 | 2016-04-23 00:00:00 | 2016-04-24 00:00:00 | 2016-04-25 00:00:00 | 2016-04-26 00:00:00 | 2016-04-27 00:00:00 | 2016-04-28 00:00:00 | 2016-04-29 00:00:00 | 2016-04-30 00:00:00
Duration EO in Backoffice - In Minutes
Name |  |  | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-06 00:00:00 | 2016-04-07 00:00:00 | 2016-04-08 00:00:00 | 2016-04-09 00:00:00 | 2016-04-10 00:00:00 | 2016-04-11 00:00:00 | 2016-04-12 00:00:00 | 2016-04-13 00:00:00 | 2016-04-14 00:00:00 | 2016-04-15 00:00:00 | 2016-04-16 00:00:00 | 2016-04-17 00:00:00 | 2016-04-18 00:00:00 | 2016-04-19 00:00:00 | 2016-04-20 00:00:00 | 2016-04-21 00:00:00 | 2016-04-22 00:00:00 | 2016-04-23 00:00:00 | 2016-04-24 00:00:00 | 2016-04-25 00:00:00 | 2016-04-26 00:00:00 | 2016-04-27 00:00:00 | 2016-04-28 00:00:00 | 2016-04-29 00:00:00 | 2016-04-30 00:00:00
Average Minutes Per Item
Name |  |  | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-06 00:00:00 | 2016-04-07 00:00:00 | 2016-04-08 00:00:00 | 2016-04-09 00:00:00 | 2016-04-10 00:00:00 | 2016-04-11 00:00:00 | 2016-04-12 00:00:00 | 2016-04-13 00:00:00 | 2016-04-14 00:00:00 | 2016-04-15 00:00:00 | 2016-04-16 00:00:00 | 2016-04-17 00:00:00 | 2016-04-18 00:00:00 | 2016-04-19 00:00:00 | 2016-04-20 00:00:00 | 2016-04-21 00:00:00 | 2016-04-22 00:00:00 | 2016-04-23 00:00:00 | 2016-04-24 00:00:00 | 2016-04-25 00:00:00 | 2016-04-26 00:00:00 | 2016-04-27 00:00:00 | 2016-04-28 00:00:00 | 2016-04-29 00:00:00 | 2016-04-30 00:00:00
Productivity Per Hour
Name |  |  | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-06 00:00:00 | 2016-04-07 00:00:00 | 2016-04-08 00:00:00 | 2016-04-09 00:00:00 | 2016-04-10 00:00:00 | 2016-04-11 00:00:00 | 2016-04-12 00:00:00 | 2016-04-13 00:00:00 | 2016-04-14 00:00:00 | 2016-04-15 00:00:00 | 2016-04-16 00:00:00 | 2016-04-17 00:00:00 | 2016-04-18 00:00:00 | 2016-04-19 00:00:00 | 2016-04-20 00:00:00 | 2016-04-21 00:00:00 | 2016-04-22 00:00:00 | 2016-04-23 00:00:00 | 2016-04-24 00:00:00 | 2016-04-25 00:00:00 | 2016-04-26 00:00:00 | 2016-04-27 00:00:00 | 2016-04-28 00:00:00 | 2016-04-29 00:00:00 | 2016-04-30 00:00:00
Total
Productivity Stats MTD |  |  |  |  |  |  |  |  | Team CFT Data
Name |  | [NAME] |  | Duration |  | Av Min Per | Per Hr |  | Name |  | Avg. speak time |  | [NAME]. speak time |  | Avg. Wrap-up |  | (AHT) | Call Shape
Team Total |  |  |  |  |  |  |  |  | Total
Daily Stats Update & Focus for the day
 |  |  |  |  | Focus for Today
 |  |  |  |  | OTM Plans for Today
 |  |  |  |  | Comments About the Below Data
Team CFT Data For Yesterday |  |  |  |  |  |  |  |  |  |  | Productivity MTD |  |  |  | QA Stats MTD |  |  |  |  | Pause Data For Yesterday
Name |  |  | Avg. speak time |  | [NAME]. speak time |  | Avg. Wrap-up |  | (AHT) | Call Shape | [NAME] |  | Average Per Hour |  | Pass' | Rec's | AR's | % MTD | Team | Name | Logged In | Pause-type |  | Time in pause-type |  | In Mins