Spreadsheet: 56483d1256662285-data-validation-with-filter-test_lob
Sheet: Master

PCGPO | LOB | Wgt | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | YTD-Prior | YTD- Current | WGT Vol- Prior | [NAME] | FINAL Vol F2008 | WGT FINAL Vol F2008 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  |  |  |  |  |  | 2
DTO_HIS | ONE | 1 | 10368 | 10329 | 10283 | 10214 | 10226 | 10151 | 10083 | 10100 | 12150 | 12209 | 12237 | 12241 | 12249 | 12263 | 12219 | 12237 | 12236 | 12086 | 12067 | 11936 | 11865 | 11843 | 11849 | 11834 | 11857 | 11870 | 11822 | 11818 | 11719 | 11592 | 11417 | 11388 | 11371 | 11440 | 11551 | 11786 | 132850 | 127845 | 132850 | 127845 | 144684 | 144684 | 3
ITC | ONE | 1 | 136 | 136 | 137 | 138 | 130 | 130 | 131 | 127 | 125 | 124 | 125 | 126 | 130 | 130 | 130 | 130 | 130 | 131 | 131 | 131 | 131 | 131 | 137 | 137 | 136 | 135 | 131 | 131 | 131 | 131 | 129 | 129 | 129 | 130 | 131 | 134 | 1442 | 1443 | 1442 | 1443 | 1579 | 1579 | 4
HIS | ONE | 1 | 16845 | 16965 | 17145 | 17355 | 17469 | 17769 | 18530 | 18592 | 18172 | 18295 | 18377 | 18732 | 18657 | 18804 | 18462 | 18576 | 18117 | 18348 | 18545 | 18699 | 18899 | 18824 | 19102 | 18819 | 18848 | 18906 | 19006 | 19074 | 19161 | 19195 | 19296 | 19464 | 19659 | 19748 | 19940 | 20346 | 205033 | 212297 | 205033 | 212297 | 223852 | 223852 | 5
DTO_HIS | Spare | 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 | 6
DTO_HIS | Spare | 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 | 7
DTO_HIS | Spare | 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 | 8
DTO_HIS | Spare | 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 | 9
DTO_HIS | Spare | 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 | 10
DTO_HIS | Spare | 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 | 11
ADP | ONE | 1 | 78382.02297296122 | 63451.37806682851 | 70936 | 81203 | 88117 | 78888 | 89632 | 84981 | 72710 | 76530 | 61867 | 76928 | 81564 | 66612 | 86276 | 68603 | 74702 | 69186 | 73517 | 73555 | 78592 | 76258 | 93434 | 114255 | 84694 | 96184 | 70249 | 68637 | 84415 | 66878 | 71769 | 72333 | 66308 | 65620 | 76299 | 68189 | 842299 | 823386 | 842299 | 823386 | 956554 | 956554 | 12
ADP | TWO | 1 | 465836 | 392294 | 533276 | 429040 | 440264 | 457890 | 459519 | 445404 | 459044 | 392967 | 340810 | 611442 | 542102 | 472984 | 597815 | 445208 | 510696 | 611283 | 546029 | 777586 | 585195 | 412634 | 558329 | 637657 | 575428 | 452146 | 600969 | 365042 | 549537 | 529609 | 464953 | 643824 | 449391 | 396671 | 370176 | 410017 | 6059861 | 5397746 | 6059861 | 5397746 | 6697518 | 6697518 | 13
ADP | THREE | 1 | 230521 | 183587 | 223290 | 231595 | 218790 | 214163 | 221774 | 191467 | 212644 | 226271 | 174321 | 255575 | 258787 | 197933 | 294554 | 224606 | 250163 | 271327 | 275662 | 284706 | 274045 | 213845 | 337604 | 413316 | 306813 | 285316 | 294557 | 281670 | 387983 | 388117 | 428432 | 406272 | 348827 | 369561 | 411426 | 382856 | 2883232 | 3908974 | 2883232 | 3908974 | 3296548 | 3296548 | 14
ADP | FOUR | 1 | 13963 | 10270 | 16128 | 13366 | 11470 | 10773 | 12344 | 18928 | 21168 | 18483 | 22267 | 17315 | 19890 | 17382 | 18259 | 17329 | 14964 | 18706 | 13810 | 27314 | 18727 | 16894 | 22043 | 26595 | 25338 | 24963 | 14507 | 18136 | 16869 | 13647 | 25365 | 16174 | 16696 | 17598 | 24350 | 18298 | 205318 | 213643 | 205318 | 213643 | 231913 | 231913 | 15
ADP | FIVE | 1 | 24 | 32 | 29 | 37 | 19 | 18 | 56 | 36 | 35 | 31 | 26 | 37 | 54 | 19 | 32 | 19 | 19 | 71 | 40 | 48 | 64 | 15 | 26 | 42 | 14 | 9 | 0 | 0 | 7 | 14 | 0 | 0 | 35 | 25 | 17 | 26 | 407 | 121 | 407 | 121 | 449 | 449 | 16
ADP | ONE | 1 | 239839.0067725909 | 181842.1152277831 | 263827.04 | 262707.3100000001 | 296797.1 | 250966.565 | 347280.3800000001 | 330930.25 | 348139.905 | 393249.3550000001 | 310395.66 | 456923.325 | 493090.19 | 362603.425 | 581003.305 | 428996.9450000001 | 532622.7150000001 | 458801.305 | 481583.475 | 471181.53 | 537695.8250000001 | 441333.6400000001 | 716879.82 | 826215.7750000001 | 541387.265 | 577226.465 | 458956.96 | 457752.735 | 566298.595 | 468494.425 | 502170.9000000001 | 405653 | 354026 | 330654 | 76299 | 68189 | 5505792.175000001 | 4738919.345000001 | 5505792.175000001 | 4738919.345000001 | 6332007.950000001 | 6332007.950000001 | 17
ADP | FIVE | 1 | 413903.4535809018 | 346753.1379310345 | 487012 | 386634 | 394250 | 425055 | 416939 | 385173 | 413266 | 346740 | 280835 | 570742 | 493719 | 428868 | 546259 | 394060 | 467014 | 558867 | 503686 | 701173 | 538542 | 376927 | 510910 | 582128 | 530840 | 397928 | 543541 | 318261 | 503744 | 496251 | 419568 | 664705 | 416775 | 369681 | 370176 | 410017 | 5520025 | 5031470 | 5520025 | 5031470 | 6102153 | 6102153 | 18
ADP | THREE | 1 | 226366 | 180502 | 218467 | 226279 | 215069 | 210341 | 215551 | 182096 | 206246 | 221197 | 170566 | 251208 | 254882 | 194122 | 290393 | 221746 | 247307 | 265987 | 271834 | 277935 | 268153 | 208952 | 332529 | 405932 | 301133 | 279933 | 290552 | 278218 | 385443 | 386877 | 426901 | 418611 | 346627 | 367139 | 411426 | 382856 | 2833840 | 3892860 | 2833840 | 3892860 | 3239772 | 3239772 | 19
ADP | TWO | 1 | 10880 | 7718 | 13481 | 10674 | 8971 | 8360 | 9704 | 14859 | 18310 | 15279 | 16908 | 14488 | 69493 | 68971 | 80859 | 122155 | 69690 | 88454 | 124261 | 83888 | 83768 | 64324 | 123725 | 129925 | 64203 | 81779 | 76345 | 86119 | 59120 | 66135 | 82668 | 112125 | 125886 | 111764 | 24350 | 18298 | 979588 | 890494 | 979588 | 890494 | 1109513 | 1109513 | 20
ADP | FOUR | 1 | 20 | 24 | 24 | 31 | 15 | 17 | 46 | 26 | 29 | 24 | 19 | 35 | 49 | 15 | 21 | 19 | 16 | 65 | 32 | 40 | 52 | 11 | 20 | 40 | 7 | 5 | 3 | 5 | 7 | 10 | 21 | 9 | 27 | 25 | 17 | 26 | 340 | 136 | 340 | 136 | 380 | 380 | 21
ADP | SIX | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6531 | 4910 | 6011 | 4585 | 6556 | 5554 | 5818 | 5634 | 5732 | 5038 | 6202 | 6951 | 5652 | 6275 | 5100 | 5245 | 6044 | 6503 | 7898 | 9594 | 10522 | 9393 | 0 | 0 | 62571 | 72226 | 62571 | 72226 | 69522 | 69522 | 22
ADP | ONE | 1 | 72148 | 72401 | 72503 | 67308 | 79003 | 67063 | 79370 | 90417 | 73012 | 76003 | 75791 | 78206 | 91543.775 | 80363.825 | 98441.7 | 88281.1 | 102642.375 | 98416.05 | 82094.025 | 91078.625 | 82293.3 | 65585.725 | 93814.675 | 96220.8 | 77921.875 | 78754.625 | 89458.2 | 75966.825 | 85652.6 | 96235.125 | 77084 | 92845 | 74969 | 61553 | 76299 | 68189 | 974555.1750000002 | 886739.25 | 974555.1750000002 | 886739.25 | 1070775.975 | 1070775.975 | 23
ADP | ONE | 1 | 52613 | 47446 | 48362 | 44426 | 48158 | 34769 | 44628 | 62453 | 47643 | 48215 | 61942 | 42838 | 168701.83125 | 144927.61875 | 193676.275 | 183287.075 | 301166.28125 | 184483.2875 | 148375.01875 | 195360.46875 | 161228.225 | 115935.54375 | 225951.00625 | 169030.35 | 137617 | 154893 | 287679.8 | 141653.8 | 147652.4 | 333356 | 136990 | 227324 | 141596 | 115983 | 370176 | 410017 | 2023092.63125 | 2194921 | 2023092.63125 | 2194921 | 2192122.98125 | 2192122.98125 | 24
ADP | TWO | 1 | 5247 | 4006 | 6065 | 6383 | 4919 | 4778 | 7365 | 10512 | 7450 | 6249 | 4814 | 5563 | 20108.8 | 23991.1 | 23311.6 | 20940.8 | 36447.5 | 23464.4 | 18264.7 | 22770.5 | 21182.4 | 15491.3 | 28082.9 | 22710.4 | 18630.5 | 19163.5 | 34018.6 | 16662.1 | 17301.8 | 40780.5 | 14655 | 27034.5 | 17333.2 | 14568.9 | 411426 | 382856 | 254056 | 631574.6 | 254056 | 631574.6 | 276766.4 | 276766.4 | 25
ADP | THREE | 1 | 3083 | 2552 | 2647 | 2692 | 2499 | 2413 | 2640 | 4069 | 2858 | 3204 | 5359 | 2827 | 2432 | 2107 | 2568 | 2338 | 2647 | 2317 | 3348 | 3132 | 2139 | 1982 | 2582 | 2782 | 2211 | 2514 | 2678 | 2760 | 2671 | 2531 | 4101 | 2773 | 2669 | 2298 | 24350 | 18298 | 27592 | 51556 | 27592 | 51556 | 30374 | 30374 | 26
ADP | FOUR | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 819 | 770 | 1096 | 1019 | 1984 | 1014 | 816 | 913 | 882 | 613 | 1372 | 866 | 720 | 776 | 1787 | 735 | 775 | 2331 | 2797 | 5611 | 3352 | 2720 | 17 | 26 | 11298 | 21621 | 11298 | 21621 | 12164 | 12164 | 27
ADP | ONE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 52050 | 53061 | 61802 | 50535 | 69400 | 82481 | 69720 | 62212 | 71884 | 54586 | 74387 | 87598 | 65929 | 65066 | 65636 | 64602 | 71790 | 64009 | 84445 | 74545 | 61679 | 58665 | 76299 | 68189 | 702118 | 752665 | 702118 | 752665 | 789716 | 789716 | 28
ADP | ONE | 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 | 29