Spreadsheet: 544826d1509042934-conditional-formatting-based-on-date-and-time-queue-template
Sheet: OLD6.24.15

Belk | Total | Oldest |  | 6+ Days
Escalation | 10 | 2015-06-22 00:00:00 |  | 5 Days
Customer Service | 496 | 2015-06-06 00:00:00 |  | 4 Days
[NAME] | 234 | 2015-05-14 00:00:00 |  | 3 Days
Accommodations | 181 | 2015-06-06 00:00:00 |  | 0-2 Days
[NAME] | 145 | 2015-06-18 00:00:00
Call Backs | 0
Sr Sup Callback | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
ACE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GNC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PBS AV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PBS HV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dollar General | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RadioShack | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mattel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
iRobot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Escalation Queues | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
ACE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2015-06-23 00:00:00
GNC | 7 | 4 | 1 | 0 | 1 | 1 | 0 | 0 | 2015-06-13 00:00:00 | 2015-06-22 00:00:00
PBS AV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PBS HV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dollar General | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2015-06-22 00:00:00
RadioShack | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mattel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
iRobot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2015-06-10 00:00:00 | 2015-06-01 00:00:00
Customer Service | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
ACE Issues | 238 | 122 | 3 | 0 | 4 | 107 | 1 | 1 | 2015-05-14 00:00:00 | 2015-06-02 00:00:00
GNC | 42 | 23 | 6 | 1 | 3 | 7 | 2 | 0 | 2015-06-09 00:00:00 | 2015-06-20 00:00:00
PBS AV | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2015-06-24 00:00:00 | 2015-06-24 00:00:00
PBS HV | 36 | 19 | 1 | 0 | 2 | 4 | 10 | 0 | 2015-06-02 00:00:00 | 2015-06-05 00:00:00
Dollar General | 5 | 2 | 0 | 2 | 0 | 0 | 1 | 0 | 2015-06-10 00:00:00 | 2015-06-21 00:00:00
RadioShack | 12 | 10 | 0 | 1 | 0 | 0 | 1 | 0 | 2015-05-26 00:00:00 | 2015-06-07 00:00:00
Mattel | 12 | 10 | 0 | 1 | 0 | 0 | 1 | 0 | 2015-05-28 00:00:00 | 2015-06-03 00:00:00
iRobot | 8 | 6 | 0 | 0 | 0 | 0 | 2 | 0 | 2015-06-19 00:00:00 | 2015-06-19 00:00:00
Reship | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
GNC | 122 | 115 | 1 | 0 | 2 | 0 | 0 | 4 | 2015-06-15 00:00:00 | 2015-06-18 00:00:00
PBS AV | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 2015-06-07 00:00:00 | 2015-06-10 00:00:00
PBS HV | 39 | 39 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2015-06-17 00:00:00
Dollar General | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 2015-06-18 00:00:00 | 2015-06-22 00:00:00
Mattel | 8 | 4 | 0 | 0 | 4 | 0 | 0 | 0 | 2015-06-09 00:00:00 | 2015-06-09 00:00:00
iRobot | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2015-06-22 00:00:00
Pickup | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
ACE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GNC | 41 | 35 | 0 | 0 | 0 | 0 | 6 | 0 | 2015-06-15 00:00:00 | 2015-06-15 00:00:00
PBS AV | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2015-05-11 00:00:00
PBS HV | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2015-06-22 00:00:00
Dollar General | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2015-06-22 00:00:00
RadioShack | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2015-06-08 00:00:00
Mattel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
iRobot | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2015-06-22 00:00:00
Canadian Returns | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
PBS HV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mattel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
iRobot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
GNC Claims | 49 | 49 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2015-06-19 00:00:00
PBS Statement Request | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0