Spreadsheet: 494343d1482336417-conditional-formatting-with-multiple-criteria-team-full-stats-record-editable-v2
Sheet: June

 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
 | 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-06-01 00:00:00 | 2016-06-02 00:00:00 | 2016-06-03 00:00:00 | 2016-06-04 00:00:00 | 2016-06-05 00:00:00 | 2016-06-06 00:00:00 | 2016-06-07 00:00:00 | 2016-06-08 00:00:00 | 2016-06-09 00:00:00 | 2016-06-10 00:00:00 | 2016-06-11 00:00:00 | 2016-06-12 00:00:00 | 2016-06-13 00:00:00 | 2016-06-14 00:00:00 | 2016-06-15 00:00:00 | 2016-06-16 00:00:00 | 2016-06-17 00:00:00 | 2016-06-18 00:00:00 | 2016-06-19 00:00:00 | 2016-06-20 00:00:00 | 2016-06-21 00:00:00 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-06-24 00:00:00 | 2016-06-25 00:00:00 | 2016-06-26 00:00:00 | 2016-06-27 00:00:00 | 2016-06-28 00:00:00 | 2016-06-29 00:00:00 | 2016-06-30 00:00:00
Duration EO in Backoffice - In Minutes
Name |  |  | 2016-06-01 00:00:00 | 2016-06-02 00:00:00 | 2016-06-03 00:00:00 | 2016-06-04 00:00:00 | 2016-06-05 00:00:00 | 2016-06-06 00:00:00 | 2016-06-07 00:00:00 | 2016-06-08 00:00:00 | 2016-06-09 00:00:00 | 2016-06-10 00:00:00 | 2016-06-11 00:00:00 | 2016-06-12 00:00:00 | 2016-06-13 00:00:00 | 2016-06-14 00:00:00 | 2016-06-15 00:00:00 | 2016-06-16 00:00:00 | 2016-06-17 00:00:00 | 2016-06-18 00:00:00 | 2016-06-19 00:00:00 | 2016-06-20 00:00:00 | 2016-06-21 00:00:00 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-06-24 00:00:00 | 2016-06-25 00:00:00 | 2016-06-26 00:00:00 | 2016-06-27 00:00:00 | 2016-06-28 00:00:00 | 2016-06-29 00:00:00 | 2016-06-30 00:00:00
Average Minutes Per Item
Name |  |  | 2016-06-01 00:00:00 | 2016-06-02 00:00:00 | 2016-06-03 00:00:00 | 2016-06-04 00:00:00 | 2016-06-05 00:00:00 | 2016-06-06 00:00:00 | 2016-06-07 00:00:00 | 2016-06-08 00:00:00 | 2016-06-09 00:00:00 | 2016-06-10 00:00:00 | 2016-06-11 00:00:00 | 2016-06-12 00:00:00 | 2016-06-13 00:00:00 | 2016-06-14 00:00:00 | 2016-06-15 00:00:00 | 2016-06-16 00:00:00 | 2016-06-17 00:00:00 | 2016-06-18 00:00:00 | 2016-06-19 00:00:00 | 2016-06-20 00:00:00 | 2016-06-21 00:00:00 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-06-24 00:00:00 | 2016-06-25 00:00:00 | 2016-06-26 00:00:00 | 2016-06-27 00:00:00 | 2016-06-28 00:00:00 | 2016-06-29 00:00:00 | 2016-06-30 00:00:00
Productivity Per Hour
Name |  |  | 2016-06-01 00:00:00 | 2016-06-02 00:00:00 | 2016-06-03 00:00:00 | 2016-06-04 00:00:00 | 2016-06-05 00:00:00 | 2016-06-06 00:00:00 | 2016-06-07 00:00:00 | 2016-06-08 00:00:00 | 2016-06-09 00:00:00 | 2016-06-10 00:00:00 | 2016-06-11 00:00:00 | 2016-06-12 00:00:00 | 2016-06-13 00:00:00 | 2016-06-14 00:00:00 | 2016-06-15 00:00:00 | 2016-06-16 00:00:00 | 2016-06-17 00:00:00 | 2016-06-18 00:00:00 | 2016-06-19 00:00:00 | 2016-06-20 00:00:00 | 2016-06-21 00:00:00 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-06-24 00:00:00 | 2016-06-25 00:00:00 | 2016-06-26 00:00:00 | 2016-06-27 00:00:00 | 2016-06-28 00:00:00 | 2016-06-29 00:00:00 | 2016-06-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