Spreadsheet: 84745d1284742307-two-way-lookup-option-explicit-test
Sheet: Sheet1

 | Date | Total Calls | Total Answered | Total  Abandon | Total Holds | ASA | Percent  Aban | Percent  Answered | Total Handle Time | Talk Time | After Call Work | Average Hold time based on ACD calls | Average  Hold Time based on Hold calls | Outbound Calls |  |  | Date | Type
 | 09/01/2010 | 1432 | 1404 | 28 | 68 | 00:28 | 0.01955307262569832 | 0.8376068376068376 | 09:47 | 09:11 | 00:32 | 00:05 | 01:36 | 287 |  |  | 09/01/2010 | Total Calls | Date
 | [NAME] | 1278 | 1215 | 63 | 44 | 00:55 | 0.04929577464788732 | 0.7580246913580246 | 09:51 | 09:18 | 00:28 | 00:05 | 02:26 | 130 |  |  | 09/01/2010 | Total Answered | Total Calls
 | 09/03/2010 | 1032 | 1016 | 16 | 47 | 00:17 | 0.01550387596899225 | 0.9192913385826772 | 10:15 | 09:36 | 00:36 | 00:04 | 01:20 | 202 |  |  | [NAME] | Total Calls | 09/01/2010
 | [NAME] | 85 | 85 | 0 | 5 | 00:07 | 0 | 0.9764705882352941 | 07:23 | 06:58 | 00:21 | 00:04 | 01:00 | 10 |  |  | [NAME] | Total Answered | 1432
 | 09/05/2010 | 51 | 50 | 1 | 2 | 00:16 | 0.0196078431372549 | 0.94 | 08:05 | 07:40 | 00:24 | 00:01 | 00:16 | 4 |  |  | 09/03/2010 | Total Calls | [NAME]
 | [NAME] | 65 | 63 | 2 | 1 | 00:10 | 0.03076923076923077 | 0.9682539682539683 | 09:10 | 08:40 | 00:22 | 00:08 | 08:01 | 3 |  |  | 09/03/2010 | Total Answered | 1278
 | 09/07/2010 | 1504 | 1485 | 19 | 81 | 00:19 | 0.01263297872340425 | 0.9272727272727272 | 10:01 | 09:24 | 00:33 | 00:04 | 01:12 | 316 |  |  | [NAME] | Total Calls | 09/03/2010
 | 09/08/2010 | 1392 | 1323 | 69 | 83 | 00:32 | 0.04956896551724138 | 0.8329554043839759 | 10:35 | 09:53 | 00:38 | 00:04 | 01:10 | 329 |  |  | [NAME] | Total Answered | 1032
 | 09/09/2010 | 1742 | 1391 | 351 | 58 | 01:46 | 0.2014925373134328 | 0.6671459381739756 | 09:45 | 09:08 | 00:35 | 00:02 | 00:53 | 222 |  |  | 09/05/2010 | Total Calls | [NAME]
 | 09/10/2010 | 1426 | 1293 | 133 | 53 | 00:50 | 0.09326788218793829 | 0.802784222737819 | 09:47 | 09:07 | 00:37 | 00:04 | 01:29 | 257 |  |  | 09/05/2010 | Total Answered | 85
 | 09/11/2010 | 151 | 143 | 8 | 4 | 00:24 | 0.05298013245033113 | 0.8951048951048951 | 08:29 | 08:06 | 00:22 | 00:01 | 00:24 | 19 |  |  | [NAME] | Total Calls | 09/05/2010
 | [NAME] | 76 | 74 | 2 | 1 | 00:08 | 0.02631578947368421 | 0.9864864864864865 | 08:00 | 07:37 | 00:22 | 00:00 | 00:03 | 15 |  |  | [NAME] | Total Answered | 51
 | 09/13/2010 | 1768 | 1629 | 139 | 84 | 00:40 | 0.07861990950226244 | 0.7679558011049724 | 10:24 | 09:49 | 00:32 | 00:03 | 00:57 | 286 |  |  | 09/07/2010 | Total Calls | [NAME]
 | 09/14/2010 | 1408 | 1343 | 65 | 57 | 00:25 | 0.04616477272727273 | 0.8689501116902457 | 10:31 | 09:55 | 00:34 | 00:02 | 00:48 | 304 |  |  | 09/07/2010 | Total Answered | 65
 | 09/15/2010 | 1254 | 1227 | 27 | 53 | 00:10 | 0.0215311004784689 | 0.9511002444987775 | 10:35 | 10:00 | 00:30 | 00:06 | 02:09 | 359 |  |  | 09/08/2010 | Total Calls | 09/07/2010
 | 09/16/2010 | 1116 | 1059 | 57 | 42 | 00:22 | 0.0510752688172043 | 0.8838526912181303 | 10:09 | 09:38 | 00:27 | 00:04 | 01:42 | 245 |  |  | 09/08/2010 | Total Answered | 1504
 | TOTAL | 15780 | 14800 | 980 | 683 | 00:37 | 0.06210392902408111 | 0.8370945945945946 | 10:06 | 09:30 | 00:33 | 00:04 | 01:22 | 2988 |  |  | 09/09/2010 | Total Calls | 09/08/2010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/09/2010 | Total Answered | 1392
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/10/2010 | Total Calls | 09/09/2010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/10/2010 | Total Answered | 1742
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/11/2010 | Total Calls | 09/10/2010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/11/2010 | Total Answered | 1426
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Total Calls | 09/11/2010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Total Answered | 151
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/13/2010 | Total Calls | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/13/2010 | Total Answered | 76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/14/2010 | Total Calls | 09/13/2010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/14/2010 | Total Answered | 1768
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/15/2010 | Total Calls | 09/14/2010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/15/2010 | Total Answered | 1408
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/16/2010 | Total Calls | 09/15/2010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09/16/2010 | Total Answered | 1254