Spreadsheet: 76957d1277400665-consolidating-rows-sample-data
Sheet: Same Day Report login (2)

 |  | Int |  | Calls | Calls | Calls | Calls | Calls |  | ATT | ATT |  | Avg | Login | Login | Login | Login | Login | Hand | Hand | % | % | % | Avg | Avg | Avg | # | # | # | # | # | # | Login | Wait | Dial | Ring | Hold | ACW | NR | TT | TT | TT | TT | TT | TT
included in report | Date | (EST) | TOTAL | Inb | Outb | Int | Cons | Unk | AHT | Inb | Outb | CPH | Agent | %Wait | %Occ | %Hold | %ACW | %NR | %Hold | %ACW | Xfer | XferIn | Conf | Hold | ACW | NR | Hold | ACW | NR | Xfer | XferIn | Conf | Secs | Secs | Secs | Secs | Secs | Secs | Secs | TTL | Inb | Outb | Int | Cons | Unk
 | 2010-06-17 00:00:00 | 400 | 2010-06-17 04:00:00 | 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
 | 2010-06-17 00:00:00 | 415 | 2010-06-17 04:00:00 | 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
 | 2010-06-17 00:00:00 | 430 | 2010-06-17 04:30:00 | 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
 | 2010-06-17 00:00:00 | 445 | 2010-06-17 04:30:00 | 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
 | 2010-06-17 00:00:00 | 500 | 2010-06-17 05:00:00 | 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
 | 2010-06-17 00:00:00 | 515 | 2010-06-17 05:00:00 | 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
 | 2010-06-17 00:00:00 | 530 | 2010-06-17 05:30:00 | 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
 | 2010-06-17 00:00:00 | 545 | 2010-06-17 05:30:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 | 0.322 | 0 | 0 | 0 | 0.678 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51.3 | 0 | 0 | 3 | 0 | 0 | 0 | 227 | 73 | 0 | 0 | 0 | 0 | 154 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-17 00:00:00 | 600 | 2010-06-17 06:00:00 | 2 | 0 | 0 | 0 | 0 | 417.5 | 370 | 0 | 4.5 | 7.73 | 0.771 | 0.122 | 0.014 | 0 | 0.106 | 0.114 | 0 | 0 | 0 | 0 | 47.5 | 0 | 46.3 | 2 | 0 | 16 | 0 | 0 | 0 | 6958 | 5368 | 0 | 14 | 95 | 0 | 741 | 740 | 740 | 0 | 0 | 0 | 0
 | 2010-06-17 00:00:00 | 615 | 2010-06-17 06:00:00 | 9 | 0 | 0 | 0 | 0 | 221.3 | 199.7 | 0 | 10.5 | 8 | 0.572 | 0.28 | 0.027 | 0 | 0.148 | 0.098 | 0 | 0 | 0 | 0 | 195 | 0 | 118.6 | 1 | 0 | 9 | 0 | 0 | 0 | 7200 | 4118 | 0 | 23 | 195 | 0 | 1067 | 1797 | 1797 | 0 | 0 | 0 | 0
 | 2010-06-17 00:00:00 | 630 | 2010-06-17 06:30:00 | 16 | 0 | 0 | 0 | 0 | 143 | 143 | 0 | 19.7 | 8 | 0.595 | 0.323 | 0 | 0 | 0.082 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 32.7 | 0 | 0 | 18 | 0 | 0 | 0 | 7200 | 4283 | 0 | 41 | 0 | 0 | 588 | 2288 | 2288 | 0 | 0 | 0 | 0
 | 2010-06-17 00:00:00 | 645 | 2010-06-17 06:30:00 | 20 | 0 | 0 | 0 | 0 | 184.4 | 181.9 | 0 | 12.8 | 8.42 | 0.259 | 0.495 | 0.007 | 0 | 0.246 | 0.014 | 0 | 0 | 0 | 0 | 10.2 | 0 | 74.6 | 5 | 0 | 25 | 0 | 0 | 0 | 7579 | 1964 | 10 | 52 | 51 | 0 | 1865 | 3637 | 3637 | 0 | 0 | 0 | 0
 | 2010-06-17 00:00:00 | 700 | 2010-06-17 07:00:00 | 22 | 0 | 3 | 1 | 0 | 192.5 | 186.3 | 0 | 14 | 9.75 | 0.354 | 0.494 | 0.015 | 0 | 0.151 | 0.032 | 0 | 0.04 | 0 | 0 | 68 | 0 | 47.4 | 2 | 0 | 28 | 1 | 0 | 0 | 8777 | 3110 | 24 | 43 | 136 | 0 | 1327 | 4137 | 4098 | 0 | 37 | 2 | 0
 | 2010-06-17 00:00:00 | 715 | 2010-06-17 07:00:00 | 23 | 0 | 1 | 7 | 0 | 195.5 | 182.3 | 0 | 12.7 | 10 | 0.274 | 0.516 | 0.008 | 0 | 0.21 | 0.016 | 0 | 0 | 0 | 0.042 | 8.3 | 0 | 72.8 | 9 | 0 | 26 | 0 | 0 | 1 | 9000 | 2464 | 12 | 65 | 75 | 0 | 1892 | 4492 | 4193 | 0 | 70 | 229 | 0
 | 2010-06-17 00:00:00 | 730 | 2010-06-17 07:30:00 | 31 | 1 | 0 | 1 | 0 | 165.6 | 160.5 | 136 | 16.8 | 9.63 | 0.207 | 0.619 | 0.015 | 0 | 0.174 | 0.024 | 0 | 0.031 | 0 | 0.031 | 32.3 | 0 | 44.3 | 4 | 0 | 34 | 1 | 0 | 1 | 8668 | 1796 | 0 | 67 | 129 | 0 | 1506 | 5170 | 4975 | 136 | 0 | 59 | 0
 | 2010-06-17 00:00:00 | 745 | 2010-06-17 07:30:00 | 28 | 1 | 0 | 1 | 0 | 170.6 | 171.7 | 70 | 14.2 | 10.11 | 0.192 | 0.552 | 0 | 0 | 0.256 | 0 | 0 | 0 | 0 | 0.034 | 2 | 0 | 77.7 | 1 | 0 | 30 | 0 | 0 | 1 | 9102 | 1751 | 2 | 71 | 2 | 0 | 2330 | 4946 | 4808 | 70 | 0 | 68 | 0
 | 2010-06-17 00:00:00 | 800 | 2010-06-17 08:00:00 | 42 | 0 | 0 | 1 | 0 | 184.5 | 171.1 | 0 | 11.7 | 18.01 | 0.201 | 0.484 | 0.031 | 0 | 0.315 | 0.065 | 0 | 0.048 | 0 | 0.024 | 55.6 | 0 | 91.3 | 9 | 0 | 56 | 2 | 0 | 1 | 16213 | 3255 | 0 | 94 | 500 | 0 | 5114 | 7250 | 7186 | 0 | 0 | 64 | 0
 | 2010-06-17 00:00:00 | 815 | 2010-06-17 08:00:00 | 52 | 0 | 0 | 19 | 0 | 205.5 | 179.7 | 0 | 12.7 | 19.75 | 0.17 | 0.608 | 0.045 | 0 | 0.222 | 0.074 | 0 | 0.038 | 0 | 0.058 | 24.9 | 0 | 77.3 | 32 | 0 | 51 | 2 | 0 | 3 | 17773 | 3027 | 0 | 116 | 796 | 0 | 3942 | 9892 | 9344 | 0 | 0 | 548 | 0
 | 2010-06-17 00:00:00 | 830 | 2010-06-17 08:30:00 | 52 | 0 | 1 | 33 | 0 | 213.4 | 196.9 | 0 | 13.3 | 20 | 0.219 | 0.627 | 0.03 | 0 | 0.154 | 0.049 | 0 | 0.019 | 0 | 0.057 | 15.1 | 0 | 48.7 | 36 | 0 | 57 | 1 | 0 | 3 | 18000 | 3937 | 15 | 118 | 542 | 0 | 2774 | 10614 | 10240 | 0 | 59 | 315 | 0
 | 2010-06-17 00:00:00 | 845 | 2010-06-17 08:30:00 | 62 | 0 | 0 | 16 | 0 | 212 | 192.7 | 0 | 13.2 | 21.13 | 0.113 | 0.698 | 0.036 | 0 | 0.189 | 0.052 | 0 | 0.081 | 0 | 0.048 | 29.9 | 0 | 56.1 | 23 | 0 | 64 | 5 | 0 | 3 | 19017 | 2153 | 0 | 130 | 688 | 0 | 3591 | 12455 | 11948 | 0 | 0 | 507 | 0
 | 2010-06-17 00:00:00 | 900 | 2010-06-17 09:00:00 | 66 | 0 | 0 | 2 | 0 | 197.5 | 187.3 | 0 | 12.7 | 24.85 | 0.167 | 0.59 | 0.025 | 0 | 0.244 | 0.044 | 0 | 0.045 | 0 | 0 | 63.2 | 0 | 73.7 | 9 | 0 | 74 | 3 | 0 | 0 | 22364 | 3726 | 0 | 152 | 569 | 0 | 5454 | 12463 | 12363 | 0 | 0 | 100 | 0
 | 2010-06-17 00:00:00 | 915 | 2010-06-17 09:00:00 | 64 | 0 | 4 | 22 | 0 | 258.1 | 228.6 | 0 | 11.2 | 26 | 0.121 | 0.723 | 0.053 | 0 | 0.156 | 0.074 | 0 | 0.029 | 0 | 0.074 | 30.1 | 0 | 53.6 | 41 | 0 | 68 | 2 | 0 | 5 | 23400 | 2831 | 0 | 168 | 1233 | 0 | 3642 | 15526 | 14631 | 0 | 242 | 653 | 0
 | 2010-06-17 00:00:00 | 930 | 2010-06-17 09:30:00 | 77 | 0 | 0 | 17 | 0 | 232.3 | 211.3 | 0 | 12.2 | 28 | 0.099 | 0.716 | 0.041 | 0 | 0.185 | 0.058 | 0 | 0.052 | 0 | 0.026 | 31.6 | 0 | 56.8 | 33 | 0 | 82 | 4 | 0 | 2 | 25200 | 2498 | 0 | 156 | 1044 | 0 | 4661 | 16841 | 16270 | 0 | 0 | 571 | 0
 | 2010-06-17 00:00:00 | 945 | 2010-06-17 09:30:00 | 77 | 1 | 0 | 5 | 0 | 197.4 | 186.7 | 46 | 12.2 | 29.67 | 0.141 | 0.583 | 0.031 | 0 | 0.277 | 0.054 | 0 | 0.026 | 0 | 0.038 | 52 | 0 | 83 | 16 | 0 | 89 | 2 | 0 | 3 | 26701 | 3760 | 0 | 161 | 832 | 0 | 7385 | 14563 | 14373 | 46 | 0 | 144 | 0
 | 2010-06-17 00:00:00 | 1000 | 2010-06-17 10:00:00 | 74 | 0 | 1 | 14 | 0 | 218.8 | 202.2 | 0 | 12 | 30.74 | 0.2 | 0.592 | 0.033 | 0 | 0.208 | 0.056 | 0 | 0.027 | 0 | 0.04 | 34.7 | 0 | 68.5 | 26 | 0 | 84 | 2 | 0 | 3 | 27666 | 5530 | 12 | 167 | 903 | 0 | 5752 | 15302 | 14961 | 25 | 17 | 299 | 0
 | 2010-06-17 00:00:00 | 1015 | 2010-06-17 10:00:00 | 69 | 1 | 0 | 3 | 0 | 246.8 | 228.7 | 34 | 10.5 | 31.02 | 0.139 | 0.624 | 0.046 | 0 | 0.237 | 0.074 | 0 | 0.043 | 0 | 0.043 | 85.8 | 0 | 87 | 15 | 0 | 76 | 3 | 0 | 3 | 27922 | 3883 | 0 | 148 | 1287 | 0 | 6613 | 15991 | 15778 | 34 | 0 | 179 | 0
 | 2010-06-17 00:00:00 | 1030 | 2010-06-17 10:30:00 | 57 | 0 | 0 | 2 | 0 | 274.6 | 248.9 | 0 | 9.4 | 28.6 | 0.151 | 0.613 | 0.048 | 0 | 0.236 | 0.079 | 0 | 0.018 | 0 | 0.035 | 82.1 | 0 | 92 | 15 | 0 | 66 | 1 | 0 | 2 | 25743 | 3894 | 0 | 127 | 1231 | 0 | 6069 | 14422 | 14186 | 0 | 0 | 236 | 0
 | 2010-06-17 00:00:00 | 1045 | 2010-06-17 10:30:00 | 65 | 0 | 0 | 3 | 0 | 228.9 | 216.8 | 0 | 11.1 | 25.15 | 0.072 | 0.662 | 0.027 | 0 | 0.267 | 0.041 | 0 | 0.046 | 0 | 0.031 | 43.4 | 0 | 82.7 | 14 | 0 | 73 | 3 | 0 | 2 | 22638 | 1624 | 0 | 100 | 608 | 0 | 6036 | 14270 | 14090 | 0 | 0 | 180 | 0