Excel
pie18k
excel.xlsxCallData
| Call Hour | Reason | Dept | Call Length | Satisfaction Rating | Call Day | On Hold | Issue | Grade | Weekday |
| Public_Affairs | Y | ||||||||
| Call Hour | Reason | Dept | Call Length | Satisfaction Rating | Call Day | On Hold | Issue | Grade | Weekday |
| 8 | 2 | Accounting | 6 | 4.5 | 4 | Y | Internet | D | Wednesday |
| 16 | 1 | Public_Affairs | 6.7 | 3.7 | 5 | Y | Frozen screen | F | Thursday |
| 15 | 2 | Accounting | 5.5 | 5.9 | 1 | N | Internet | D | Sunday |
| 3 | 1 | Public_Affairs | 3.7 | 9.2 | 2 | N | Frozen screen | A+ | Monday |
| 21 | 1 | Admissions | 6.5 | 5.9 | 1 | N | Banner | D | Sunday |
| 15 | 3 | Public_Affairs | 8.8 | 6 | 3 | N | Other | C | Tuesday |
| 22 | 1 | Human_Resources | 6.3 | 6.4 | 4 | N | Blackboard | C | Wednesday |
| 12 | 2 | Admissions | 2 | 7.2 | 2 | Y | Intranet | C | Monday |
| 19 | 3 | Accounting | 5.4 | 7.6 | 6 | N | C | Friday | |
| 15 | 1 | Financial_Aid | 5.9 | 4.2 | 5 | Y | Internet | D | Thursday |
| 19 | 1 | Public_Affairs | 3.3 | 9.2 | 3 | N | Frozen screen | A+ | Tuesday |
| 14 | 2 | Accounting | 4.9 | 5.1 | 3 | N | Internet | D | Tuesday |
| 12 | 4 | Public_Affairs | 4 | 5.9 | 5 | N | D | Thursday | |
| 20 | 2 | Public_Affairs | 4.3 | 8.2 | 2 | N | Voicemail | B | Monday |
| 14 | 2 | Public_Affairs | 5.3 | 6.7 | 5 | N | Voicemail | C | Thursday |
| 11 | 2 | Public_Affairs | 5.1 | 6.8 | 5 | N | Voicemail | C | Thursday |
| 15 | 1 | Admissions | 3.5 | 6.5 | 2 | Y | Banner | C | Monday |
| 16 | 1 | Admissions | 5.4 | 8.4 | 6 | N | Banner | B | Friday |
| 10 | 2 | Public_Affairs | 3.6 | 6.8 | 5 | Y | Voicemail | C | Thursday |
| 15 | 2 | Admissions | 7.2 | 4.2 | 7 | Y | Intranet | D | Saturday |
| 1 | 2 | Public_Affairs | 3.3 | 9.9 | 7 | N | Voicemail | A+ | Saturday |
| 9 | 3 | Admissions | 6.3 | 8.3 | 6 | N | Blackboard | B | Friday |
| 13 | 2 | Public_Affairs | 2.6 | 6.5 | 4 | Y | Voicemail | C | Wednesday |
| 20 | 3 | Admissions | 7.2 | 6.6 | 5 | N | Blackboard | C | Thursday |
| 17 | 2 | Admissions | 1.8 | 7.5 | 2 | N | Intranet | C | Monday |
| 11 | 1 | Admissions | 2.5 | 8.3 | 1 | N | Banner | B | Sunday |
| 14 | 2 | Admissions | 4.7 | 6.6 | 2 | N | Intranet | C | Monday |
| 17 | 3 | Public_Affairs | 7.6 | 5.3 | 3 | N | Other | D | Tuesday |
| 21 | 1 | Financial_Aid | 5.7 | 5.4 | 7 | Y | Internet | D | Saturday |
| 16 | 1 | Public_Affairs | 3 | 6.7 | 5 | Y | Frozen screen | C | Thursday |
| 2 | 1 | Admissions | 3.7 | 9.4 | 4 | N | Banner | A+ | Wednesday |
| 13 | 1 | Accounting | 1.5 | 7.8 | 1 | N | Blackboard | C | Sunday |
| 11 | 3 | Public_Affairs | 3.3 | 9.3 | 1 | N | Other | A+ | Sunday |
| 18 | 3 | Admissions | 4.4 | 5.4 | 5 | Y | Blackboard | D | Thursday |
| 20 | 2 | Accounting | 5 | 4 | 1 | Y | Internet | D | Sunday |
| 23 | 2 | Public_Affairs | 3.2 | 8 | 3 | Y | Voicemail | B | Tuesday |
| 8 | 1 | Public_Affairs | 4.5 | 4.9 | 5 | Y | Frozen screen | D | Thursday |
| 8 | 2 | Admissions | 8.1 | 4.1 | 4 | Y | Intranet | D | Wednesday |
| 5 | 1 | Human_Resources | 6.5 | 6.2 | 4 | N | Blackboard | C | Wednesday |
| 21 | 1 | Public_Affairs | 5.7 | 8.5 | 6 | N | Frozen screen | B | Friday |
| 20 | 2 | Admissions | 4.5 | 5.6 | 7 | N | Intranet | D | Saturday |
| 19 | 3 | Admissions | 4.8 | 9 | 2 | N | Blackboard | A+ | Monday |
| 4 | 1 | Admissions | 5.9 | 8.2 | 4 | N | Banner | B | Wednesday |
| 22 | 2 | Admissions | 4.4 | 4.5 | 7 | Y | Intranet | D | Saturday |
| 20 | 1 | Public_Affairs | 3.2 | 9.4 | 7 | N | Frozen screen | A+ | Saturday |
| 20 | 3 | Admissions | 4 | 3.8 | 3 | Y | Blackboard | F | Tuesday |
| 16 | 4 | Financial_Aid | 4.9 | 6.5 | 2 | N | Internet | C | Monday |
| 11 | 1 | Public_Affairs | 5.7 | 6.2 | 5 | Y | Frozen screen | C | Thursday |
| 7 | 2 | Public_Affairs | 5 | 9.9 | 5 | N | Voicemail | A+ | Thursday |
| 12 | 2 | Public_Affairs | 4.6 | 8.8 | 4 | N | Voicemail | B | Wednesday |
| 16 | 1 | Financial_Aid | 3.5 | 8.3 | 1 | N | Internet | B | Sunday |
| 20 | 2 | Public_Affairs | 5.7 | 7.1 | 1 | N | Voicemail | C | Sunday |
| 14 | 4 | Admissions | 4 | 6.1 | 2 | N | C | Monday | |
| 12 | 1 | Admissions | 3.1 | 9.6 | 5 | N | Banner | A+ | Thursday |
| 6 | 2 | Admissions | 3.5 | 10 | 7 | N | Intranet | A+ | Saturday |
| 17 | 2 | Admissions | 2.7 | 8.1 | 1 | N | Intranet | B | Sunday |
| 21 | 2 | Human_Resources | 5 | 5 | 7 | Y | Electrical | D | Saturday |
| 6 | 4 | Admissions | 2.7 | 7.7 | 3 | N | C | Tuesday | |
| 20 | 2 | Public_Affairs | 6.1 | 6.7 | 6 | N | Voicemail | C | Friday |
| 20 | 1 | Admissions | 6 | 4.4 | 1 | Y | Banner | D | Sunday |
| 22 | 2 | Public_Affairs | 4.7 | 8.1 | 3 | N | Voicemail | B | Tuesday |
| 3 | 1 | Public_Affairs | 5.3 | 5 | 4 | Y | Frozen screen | D | Wednesday |
| 9 | 1 | Admissions | 3.4 | 8.9 | 6 | N | Banner | B | Friday |
| 13 | 2 | Accounting | 4.9 | 6.3 | 2 | Y | Internet | C | Monday |
| 23 | 1 | Accounting | 5.5 | 7.2 | 3 | N | Blackboard | C | Tuesday |
| 24 | 2 | Admissions | 4.5 | 7.1 | 3 | N | Intranet | C | Tuesday |
| 10 | 3 | Admissions | 7.3 | 3.8 | 6 | Y | Blackboard | F | Friday |
| 20 | 4 | Human_Resources | 4.5 | 6.5 | 1 | N | Intranet | C | Sunday |
| 9 | 3 | Human_Resources | 5.8 | 4.9 | 2 | Y | Internet | D | Monday |
| 14 | 2 | Accounting | 4.2 | 7.6 | 3 | N | Internet | C | Tuesday |
| 11 | 1 | Human_Resources | 3.8 | 10 | 5 | N | Blackboard | A+ | Thursday |
| 18 | 2 | Public_Affairs | 4.5 | 8.1 | 2 | N | Voicemail | B | Monday |
| 20 | 2 | Admissions | 3.5 | 10 | 2 | N | Intranet | A+ | Monday |
| 6 | 2 | Accounting | 1.4 | 9.5 | 4 | N | Internet | A+ | Wednesday |
| 6 | 2 | Admissions | 3.8 | 10 | 2 | N | Intranet | A+ | Monday |
| 13 | 1 | Accounting | 4.5 | 6.1 | 2 | N | Blackboard | C | Monday |
| 21 | 1 | Accounting | 4.6 | 6.8 | 3 | N | Blackboard | C | Tuesday |
| 23 | 1 | Admissions | 4.5 | 6.6 | 5 | Y | Banner | C | Thursday |
| 10 | 1 | Admissions | 2.6 | 7.3 | 4 | Y | Banner | C | Wednesday |
| 19 | 1 | Public_Affairs | 6.3 | 7.7 | 1 | N | Frozen screen | C | Sunday |
| 13 | 3 | Admissions | 1.3 | 8.8 | 4 | N | Blackboard | B | Wednesday |
| 18 | 2 | Human_Resources | 4.9 | 5.5 | 2 | N | Electrical | D | Monday |
| 18 | 2 | Human_Resources | 4.8 | 5.4 | 6 | Y | Electrical | D | Friday |
| 12 | 2 | Accounting | 3.9 | 8 | 1 | N | Internet | B | Sunday |
| 19 | 2 | Accounting | 6.8 | 6.6 | 4 | Y | Internet | C | Wednesday |
| 11 | 1 | Public_Affairs | 6.2 | 8.7 | 7 | N | Frozen screen | B | Saturday |
| 4 | 4 | Human_Resources | 5 | 6.2 | 2 | N | Intranet | C | Monday |
| 24 | 3 | Human_Resources | 2.4 | 8.1 | 6 | N | Internet | B | Friday |
| 21 | 2 | Accounting | 6.8 | 6 | 4 | N | Internet | C | Wednesday |
| 12 | 3 | Human_Resources | 3.1 | 8.3 | 6 | N | Internet | B | Friday |
| 14 | 2 | Human_Resources | 3.2 | 7.4 | 1 | N | Electrical | C | Sunday |
| 14 | 3 | Admissions | 7.8 | 6.9 | 1 | N | Blackboard | C | Sunday |
| 9 | 3 | Admissions | 5.4 | 4.8 | 2 | N | Blackboard | D | Monday |
| 14 | 2 | Public_Affairs | 6.6 | 5.8 | 6 | Y | Voicemail | D | Friday |
| 12 | 3 | Admissions | 3.5 | 8.6 | 5 | Y | Blackboard | B | Thursday |
| 19 | 3 | Human_Resources | 5.7 | 7.2 | 3 | N | Internet | C | Tuesday |
| 4 | 1 | Public_Affairs | 6.3 | 6.5 | 5 | N | Frozen screen | C | Thursday |
| 8 | 3 | Admissions | 8.3 | 6 | 6 | N | Blackboard | C | Friday |
| 7 | 2 | Human_Resources | 4 | 7.2 | 6 | N | Electrical | C | Friday |
| 1 | 2 | Human_Resources | 4.8 | 7.7 | 4 | N | Electrical | C | Wednesday |
| 11 | 1 | Accounting | 3.1 | 9.8 | 6 | N | Blackboard | A+ | Friday |
| 15 | 2 | Accounting | 5 | 4.6 | 3 | Y | Internet | D | Tuesday |
| 10 | 1 | Public_Affairs | 5.5 | 8.9 | 5 | N | Frozen screen | B | Thursday |
| 12 | 1 | Admissions | 5.2 | 5 | 7 | Y | Banner | D | Saturday |
| 9 | 2 | Public_Affairs | 4.6 | 8.9 | 1 | N | Voicemail | B | Sunday |
| 5 | 3 | Admissions | 2.2 | 7.3 | 1 | Y | Blackboard | C | Sunday |
| 20 | 4 | Accounting | 6.1 | 7.8 | 6 | N | C | Friday | |
| 24 | 1 | Accounting | 4.4 | 8.3 | 4 | N | Blackboard | B | Wednesday |
| 20 | 3 | Admissions | 6 | 4.7 | 5 | Y | Blackboard | D | Thursday |
| 9 | 3 | Financial_Aid | 3.9 | 10 | 7 | N | Intranet | A+ | Saturday |
| 10 | 3 | Accounting | 5.2 | 7.2 | 2 | N | C | Monday | |
| 14 | 2 | Accounting | 4.6 | 5.5 | 3 | N | Internet | D | Tuesday |
| 22 | 4 | Accounting | 6.5 | 8.3 | 3 | N | B | Tuesday | |
| 15 | 3 | Financial_Aid | 7.1 | 5.1 | 1 | Y | Intranet | D | Sunday |
| 2 | 4 | Financial_Aid | 6.3 | 6.6 | 7 | N | Internet | C | Saturday |
| 10 | 1 | Admissions | 4.5 | 8.5 | 4 | N | Banner | B | Wednesday |
| 2 | 1 | Admissions | 7.4 | 6.4 | 5 | N | Banner | C | Thursday |
| 18 | 3 | Financial_Aid | 5.4 | 6.9 | 5 | N | Intranet | C | Thursday |
| 23 | 1 | Financial_Aid | 5.3 | 5 | 2 | Y | Internet | D | Monday |
&F
Lists
| Department | Public Affairs | Human Resources | Admissions | Accounting | Financial Aid | |||
| Public Affairs | 1 | Frozen screen | Blackboard | Banner | Blackboard | Internet | ||
| Human Resources | 2 | Voicemail | Electrical | Intranet | Internet | Blackboard | ||
| Admissions | 3 | Other | Internet | Blackboard | Intranet | |||
| Accounting | 4 | Intranet | Internet | |||||
| Financial Aid | ||||||||
| Day of Week | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | |
| Financial Aid | ||||||||
| Satisfaction Rating | Grade | |||||||
| 0 | F | |||||||
| 4 | D | |||||||
| 6 | C | |||||||
| 8 | B | |||||||
| 9 | A+ |
&F
CallCenterReport
| Call Center Report | |||||||||
| Department | Financial_Aid Your Office: Public_Affairs Human_Resources Admissions Accounting Financial_Aid Student_Life |
||||||||
| Issues | # Calls on Issue | # On Hold | Status | ||||||
| 1 | Internet | 4 | 3 | Check Hold Issue | |||||
| 2 | Blackboard | 0 | 0 | ||||||
| 3 | Intranet | 3 | 1 | ||||||
| 4 | Internet | 2 | 0 | ||||||
| Department | Average Call Length | Total Calls | Below C | Notes | Longest Call | 8.8 | |||
| Public_Affairs | 4.947 | 32 | 6 | Department | Public_Affairs | ||||
| Human_Resources | 4.653 | 15 | 4 | Score | 6 | ||||
| Admissions | 4.637 | 41 | 12 | Explore Issues | |||||
| Accounting | 4.809 | 22 | 6 | ||||||
| Financial_Aid | 5.333 | 9 | 4 | ||||||
| Call Hour | Reason | Dept | Call Length | Satisfaction Rating | Call Day | On Hold | Issue | Grade | Weekday |
| Y | Friday | ||||||||
| Satisfaction Rating | Call Length | ||||||||
| Count | 3.0 | 3.0 | |||||||
| Average | 5.0 | 6.2 | |||||||
| Sum | 15.0 | 18.7 | |||||||
| Max | 5.8 | 7.3 | |||||||
| Min | 3.8 | 4.8 |
&F
1
2
3
4
5
6
7
8
A
B
C
Call Hour
Reason
Dept
Public_Affairs
