Spreadsheet: 169666d1343017019-conditional-formatting-based-on-distance-from-median-value-excel-2010-conditional-format-based-on-median
Sheet: HLS - 2012

DIRECT |  |  |  | 2012-03-01 00:00:00 | 2012-03-02 00:00:00 | 2012-03-03 00:00:00 | 2012-03-04 00:00:00 | Weekly Total
Home Loan Sepcialists
Hotline Total Logged in Time
Calls Offered |  |  |  | 7 | 8 | 5
Calls Answered |  |  |  | 1 | 1 | 0
AHT |  |  |  | 30628 | 223
Handle Time Talk Time |  |  |  | 1828 | 219
Handle Time ACW |  |  |  | 28800 | 4
Available Time
Off Huntline Time
Leads
Total Leads Contacted
AHT for Leads
Loan Applications
Retention Team
Leads
Total Leads Contacted
Conversion
Loan Variations Team
Hotline Total Logged in Time
Calls Offered
Calls Answered
AHT
Handle Time Talk Time
Handle Time ACW
Available Time
Off Huntline Time
Leads
Total Leads Contacted
AHT for Leads
Veriation Applications
DIRECT | 2012-03-05 00:00:00 | 2012-03-06 00:00:00 | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 2012-03-09 00:00:00 | 2012-03-10 00:00:00 | 2012-03-11 00:00:00 | Weekly Total
Home Loan Sepcialists
Hotline Total Logged in Time
Calls Offered | 29 | 35 | 34 | 38 | 32 | 1
Calls Answered | 26 | 24 | 24 | 32 | 22 | 1
AHT | 1512 | 1838 | 2083 | 1655 | 1501 | 29296
Handle Time Talk Time | 974 | 975 | 1142 | 823 | 1013 | 496
Handle Time ACW | 508 | 841 | 915 | 799 | 484 | 28800
Available Time
Off Huntline Time
Leads
Total Leads Contacted
AHT for Leads
Loan Applications
Retention Team
Leads
Total Leads Contacted
Conversion
Loan Variations Team
Hotline Total Logged in Time
Calls Offered
Calls Answered
AHT
Handle Time Talk Time
Handle Time ACW
Available Time
Off Huntline Time
Leads
Total Leads Contacted
AHT for Leads
Veriation Applications
DIRECT | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-16 00:00:00 | 2012-03-17 00:00:00 | 2012-03-18 00:00:00 | Weekly Total
Home Loan Sepcialists
Hotline Total Logged in Time
Calls Offered | 34 | 34 | 32 | 26 | 29 | 2 | 1
Calls Answered | 31 | 20 | 26 | 20 | 17 | 0 | 0
AHT | 1582 | 1313 | 1577 | 2076 | 1600
Handle Time Talk Time | 767 | 774 | 1050 | 1181 | 1134
Handle Time ACW | 802 | 530 | 518 | 880 | 460
Available Time
Off Huntline Time
Leads
Total Leads Contacted
AHT for Leads
Loan Applications
Retention Team
Leads
Total Leads Contacted
Conversion
Loan Variations Team
Hotline Total Logged in Time
Calls Offered
Calls Answered
AHT
Handle Time Talk Time
Handle Time ACW
Available Time
Off Huntline Time
Leads
Total Leads Contacted
AHT for Leads
Veriation Applications
DIRECT | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00 | 2012-03-25 00:00:00 | Weekly Total
Home Loan Sepcialists
Hotline Total Logged in Time
Calls Offered | 45 | 30 | 41 | 31 | 27 | 1 | 0
Calls Answered | 28 | 19 | 26 | 20 | 18 | 0 | 0
AHT | 1509 | 2056 | 1445 | 1790 | 2908
Handle Time Talk Time | 983 | 1150 | 673 | 1055 | 1015
Handle Time ACW | 522 | 897 | 757 | 736 | 1878
Available Time
Off Huntline Time
Leads
Total Leads Contacted
AHT for Leads
Loan Applications
Retention Team
Leads
Total Leads Contacted
Conversion
Loan Variations Team
Hotline Total Logged in Time
Calls Offered
Calls Answered
AHT
Handle Time Talk Time
Handle Time ACW
Available Time
Off Huntline Time
Leads
Total Leads Contacted
AHT for Leads
Veriation Applications
DIRECT | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00 | 2012-04-01 00:00:00 | Weekly Total
Home Loan Sepcialists
Hotline Total Logged in Time
Calls Offered | 24
Calls Answered | 16
AHT | 1301
Handle Time Talk Time | 742
Handle Time ACW | 559
Available Time
Off Huntline Time
Leads
Total Leads Contacted
AHT for Leads
Loan Applications
Retention Team
Leads
Total Leads Contacted
Conversion
Loan Variations Team
Hotline Total Logged in Time
Calls Offered
Calls Answered
AHT
Handle Time Talk Time
Handle Time ACW
Available Time
Off Huntline Time
Leads
Total Leads Contacted
AHT for Leads
Veriation Applications
 |  |  |  | 2012-05-21 00:00:00
 |  |  | HLS Transfer Answered | 15
 |  |  | Total Calls Answered | 15
 |  |  | HLS Transfer Offered | 15
 |  |  | Total Calls Offered | 15
 |  |  | Outbound Attempts | 314
 |  |  | SVL Combined | 0.7333333333333333
 |  |  | AHT Combined | 3896.2
 |  |  | Aban Rate | 0
 |  |  | ASA: | 207.2
 |  |  | [NAME]: | 1 day, 2:43:00