Spreadsheet: 157378d1337711757-comparing-two-data-sets-that-dont-line-up-on-a-line-to-line-basis-copy-of-may-2-2-
Sheet: may 2

WorkDate | Vend Ref# | CCCharge |  |  |  | Date | LEM Number | Total
2012-05-02 00:00:00 | P064565 | 271.16 |  |  |  | 2012-05-02 00:00:00 | P064565 | 502.84
2012-05-02 00:00:00 | P064565 | 231.68 |  |  |  | 2012-05-02 00:00:00 | P064565 | 184.64
2012-05-02 00:00:00 | P064565 | 184.64 |  |  |  |  | P064565 Total
 | P064565 Total |  |  |  |  | 2012-05-02 00:00:00 | P064566 | 92.32
2012-05-02 00:00:00 | P064566 | 135.58 |  |  |  | 2012-05-02 00:00:00 | P064566 | 251.42
2012-05-02 00:00:00 | P064566 | 115.84 |  |  |  |  | P064566 Total
2012-05-02 00:00:00 | P064566 | 92.32 |  |  |  | 2012-05-02 00:00:00 | P064567 | 184.64
 | P064566 Total |  |  |  |  | 2012-05-02 00:00:00 | P064567 | 502.84
2012-05-02 00:00:00 | P064567 | 271.16 |  |  |  |  | P064567 Total
2012-05-02 00:00:00 | P064567 | 231.68 |  |  |  | 2012-05-02 00:00:00 | P064568 | 251.42
2012-05-02 00:00:00 | P064567 | 184.64 |  |  |  | 2012-05-02 00:00:00 | P064568 | 92.32
 | P064567 Total |  |  |  |  |  | P064568 Total
2012-05-02 00:00:00 | P064568 | 135.58 |  |  |  | 2012-05-02 00:00:00 | P064569 | 1626.96
2012-05-02 00:00:00 | P064568 | 115.84 |  |  |  | 2012-05-02 00:00:00 | P064569 | 553.92
2012-05-02 00:00:00 | P064568 | 92.32 |  |  |  |  | P064569 Total
 | P064568 Total |  |  |  |  | 2012-05-02 00:00:00 | P064570 | 553.92
2012-05-02 00:00:00 | P064569 | 813.48 |  |  |  | 2012-05-02 00:00:00 | P064570 | 1508.52
2012-05-02 00:00:00 | P064569 | 813.48 |  |  |  |  | P064570 Total
2012-05-02 00:00:00 | P064569 | 553.92 |  |  |  | 2012-05-02 00:00:00 | [NAME] | 553.92
 | P064569 Total |  |  |  |  | 2012-05-02 00:00:00 | [NAME] | 1508.52
2012-05-02 00:00:00 | P064570 | 813.48 |  |  |  |  | P064571 Total
2012-05-02 00:00:00 | P064570 | 695.04 |  |  |  | 2012-05-02 00:00:00 | P064572 | 1508.52
2012-05-02 00:00:00 | P064570 | 553.92 |  |  |  | 2012-05-02 00:00:00 | P064572 | 1981.92
 | P064570 Total |  |  |  |  |  | P064572 Total
2012-05-02 00:00:00 | [NAME] | 813.48 |  |  |  | 2012-05-02 00:00:00 | P064574 | 1658.43
2012-05-02 00:00:00 | [NAME] | 695.04 |  |  |  | 2012-05-02 00:00:00 | P064574 | 1981.92
2012-05-02 00:00:00 | [NAME] | 553.92 |  |  |  |  | P064574 Total
 | P064571 Total |  |  |  |  | 2012-05-02 00:00:00 | P064577 | 2008.8
2012-05-02 00:00:00 | P064572 | 813.48 |  |  |  | 2012-05-02 00:00:00 | P064577 | 3830.52
2012-05-02 00:00:00 | P064572 | 695.04 |  |  |  |  | P064577 Total
2012-05-02 00:00:00 | P064572 | 1981.92 |  |  |  | 2012-05-02 00:00:00 | P064578 | 264
 | P064572 Total |  |  |  |  | 2012-05-02 00:00:00 | P064578 | 406.74
2012-05-02 00:00:00 | P064574 | 813.48 |  |  |  |  | P064578 Total
2012-05-02 00:00:00 | P064574 | 81.48 |  |  |  | 2012-05-02 00:00:00 | P064579 | 264
2012-05-02 00:00:00 | P064574 | 1981.92 |  |  |  | 2012-05-02 00:00:00 | P064579 | 406.74
2012-05-02 00:00:00 | P064574 | 695.04 |  |  |  |  | P064579 Total
2012-05-02 00:00:00 | P064574 | 68.43 |  |  |  | 2012-05-02 00:00:00 | P064580 | 1123.2
 | P064574 Total |  |  |  |  | 2012-05-02 00:00:00 | P064580 | 2322
2012-05-02 00:00:00 | P064577 | 813.48 |  |  |  |  | P064580 Total
2012-05-02 00:00:00 | P064577 | 695.04 |  |  |  | 2012-05-02 00:00:00 | P064582 | 2240
2012-05-02 00:00:00 | P064577 | 813.48 |  |  |  | 2012-05-02 00:00:00 | P064582 | 2514.2
2012-05-02 00:00:00 | P064577 | 695.04 |  |  |  |  | P064582 Total
2012-05-02 00:00:00 | P064577 | 813.48 |  |  |  | 2012-05-02 00:00:00 | P064583 | 1508.52
2012-05-02 00:00:00 | P064577 | 740.4 |  |  |  | 2012-05-02 00:00:00 | P064583 | 859.2
2012-05-02 00:00:00 | P064577 | 740.4 |  |  |  |  | P064583 Total
2012-05-02 00:00:00 | P064577 | 528 |  |  |  | 2012-05-02 00:00:00 | P064590 | 1397.6
 | P064577 Total |  |  |  |  | 2012-05-02 00:00:00 | P064590 | 3192.1
2012-05-02 00:00:00 | P064578 | 406.74 |  |  |  |  | P064590 Total
2012-05-02 00:00:00 | P064578 | 264 |  |  |  | 2012-05-02 00:00:00 | P064592 | 1508.52
 | P064578 Total |  |  |  |  | 2012-05-02 00:00:00 | P064592 | 1123.2
2012-05-02 00:00:00 | P064579 | 406.74 |  |  |  |  | P064592 Total
2012-05-02 00:00:00 | P064579 | 264 |  |  |  | 2012-05-02 00:00:00 | P064593 | 836.64
 | P064579 Total |  |  |  |  | 2012-05-02 00:00:00 | P064593 | 1237.36
2012-05-02 00:00:00 | P064580 | 813.48 |  |  |  |  | P064593 Total
2012-05-02 00:00:00 | P064580 | 695.04 |  |  |  | 2012-05-02 00:00:00 | P064597 | 553.92
2012-05-02 00:00:00 | P064580 | 813.48 |  |  |  | 2012-05-02 00:00:00 | P064597 | 1508.52
2012-05-02 00:00:00 | P064580 | 595.2 |  |  |  |  | P064597 Total
2012-05-02 00:00:00 | P064580 | 528 |  |  |  | 2012-05-02 00:00:00 | P064598 | 2418.1
 | P064580 Total |  |  |  |  | 2012-05-02 00:00:00 | P064598 | 1552.56
2012-05-02 00:00:00 | P064582 | 677.9 |  |  |  |  | P064598 Total
2012-05-02 00:00:00 | P064582 | 579.2 |  |  |  | 2012-05-02 00:00:00 | P064599 | 2240
2012-05-02 00:00:00 | P064582 | 579.2 |  |  |  | 2012-05-02 00:00:00 | P064599 | 2514.2
2012-05-02 00:00:00 | P064582 | 677.9 |  |  |  |  | P064599 Total
2012-05-02 00:00:00 | P064582 | 440 |  |  |  | 2012-05-02 00:00:00 | P065601 | 927.84
 | P064582 Total |  |  |  |  | 2012-05-02 00:00:00 | P065601 | 1372.94
2012-05-02 00:00:00 | P064583 | 813.48 |  |  |  |  | P065601 Total
2012-05-02 00:00:00 | P064583 | 695.04 |  |  |  | 2012-05-02 00:00:00 | P065603 | 1508.52
2012-05-02 00:00:00 | P064583 | 595.2 |  |  |  | 2012-05-02 00:00:00 | P065603 | 553.92
2012-05-02 00:00:00 | P064583 | 264 |  |  |  |  | P065603 Total
 | P064583 Total |  |  |  |  | 2012-05-02 00:00:00 | P065605 | 1005.68
2012-05-02 00:00:00 | P064590 | 677.9 |  |  |  | 2012-05-02 00:00:00 | P065605 | 369.28
2012-05-02 00:00:00 | P064590 | 579.2 |  |  |  |  | P065605 Total
2012-05-02 00:00:00 | P064590 | 579.2 |  |  |  | 2012-05-02 00:00:00 | P065606 | 754.26
2012-05-02 00:00:00 | P064590 | 677.9 |  |  |  | 2012-05-02 00:00:00 | P065606 | 276.96
2012-05-02 00:00:00 | P064590 | 677.9 |  |  |  |  | P065606 Total
2012-05-02 00:00:00 | P064590 | 496 |  |  |  | 2012-05-02 00:00:00 | P065607 | 774
2012-05-02 00:00:00 | P064590 | 440 |  |  |  |  | P065607 Total
2012-05-02 00:00:00 | P064590 | 461.6 |  |  |  | 2012-05-02 00:00:00 | P065608 | 387
 | P064590 Total |  |  |  |  |  | P065608 Total
2012-05-02 00:00:00 | P064592 | 813.48 |  |  |  | 2012-05-02 00:00:00 | P065609 | 1268.4
2012-05-02 00:00:00 | P064592 | 695.04 |  |  |  | 2012-05-02 00:00:00 | P065609 | 1626.96
2012-05-02 00:00:00 | P064592 | 595.2 |  |  |  |  | P065609 Total
2012-05-02 00:00:00 | P064592 | 528 |  |  |  | 2012-05-02 00:00:00 | P065610 | 754.26
 | P064592 Total |  |  |  |  | 2012-05-02 00:00:00 | P065610 | 276.96
2012-05-02 00:00:00 | P064593 | 271.16 |  |  |  |  | P065610 Total
2012-05-02 00:00:00 | P064593 | 231.68 |  |  |  | 2012-05-02 00:00:00 | P065611 | 5555.52
2012-05-02 00:00:00 | P064593 | 271.16 |  |  |  |  | P065611 Total
2012-05-02 00:00:00 | P064593 | 231.68 |  |  |  | 2012-05-02 00:00:00 | P065612 | 2880.4
2012-05-02 00:00:00 | P064593 | 231.68 |  |  |  |  | P065612 Total
2012-05-02 00:00:00 | P064593 | 660.64 |  |  |  | 2012-05-02 00:00:00 | P065613 | 1449.3
2012-05-02 00:00:00 | P064593 | 176 |  |  |  | 2012-05-02 00:00:00 | P065613 | 990.96
 | P064593 Total |  |  |  |  |  | P065613 Total
2012-05-02 00:00:00 | P064597 | 813.48 |  |  |  | 2012-05-02 00:00:00 | P065631 | 184.64
2012-05-02 00:00:00 | P064597 | 695.04 |  |  |  | 2012-05-02 00:00:00 | P065631 | 502.84
2012-05-02 00:00:00 | P064597 | 553.92 |  |  |  |  | P065631 Total
 | P064597 Total |  |  |  |  | 2012-05-02 00:00:00 | P065638 | 774
2012-05-02 00:00:00 | P064598 | 406.74 |  |  |  | 2012-05-02 00:00:00 | P065638 | 374.4
2012-05-02 00:00:00 | P064598 | 347.52 |  |  |  |  | P065638 Total
2012-05-02 00:00:00 | P064598 | 677.9 |  |  |  | 2012-05-02 00:00:00 | P065639 | 251.42
2012-05-02 00:00:00 | P064598 | 579.2 |  |  |  | 2012-05-02 00:00:00 | P065639 | 92.32
2012-05-02 00:00:00 | P064598 | 406.74 |  |  |  |  | P065639 Total
2012-05-02 00:00:00 | P064598 | 990.96 |  |  |  | 2012-05-02 00:00:00 | [NAME] | 734.52
2012-05-02 00:00:00 | P064598 | 297.6 |  |  |  |  | P065652 Total
2012-05-02 00:00:00 | P064598 | 264 |  |  |  | 2012-05-02 00:00:00 | P065653 | 251.42
 | P064598 Total |  |  |  |  |  | P065653 Total
2012-05-02 00:00:00 | P064599 | 677.9 |  |  |  | 2012-05-02 00:00:00 | P065654 | 251.42
2012-05-02 00:00:00 | P064599 | 677.9 |  |  |  |  | P065654 Total
2012-05-02 00:00:00 | P064599 | 579.2
2012-05-02 00:00:00 | P064599 | 579.2
2012-05-02 00:00:00 | P064599 | 440
 | P064599 Total
2012-05-02 00:00:00 | P065601 | 542.32
2012-05-02 00:00:00 | P065601 | 463.36
2012-05-02 00:00:00 | P065601 | 135.58
2012-05-02 00:00:00 | P065601 | 231.68
2012-05-02 00:00:00 | P065601 | 352
 | P065601 Total
2012-05-02 00:00:00 | P065603 | 813.48
2012-05-02 00:00:00 | P065603 | 695.04
2012-05-02 00:00:00 | P065603 | 553.92
 | P065603 Total
2012-05-02 00:00:00 | P065605 | 542.32
2012-05-02 00:00:00 | P065605 | 463.36
2012-05-02 00:00:00 | P065605 | 369.28
 | P065605 Total
2012-05-02 00:00:00 | P065606 | 406.74
2012-05-02 00:00:00 | P065606 | 347.52
2012-05-02 00:00:00 | P065606 | 276.96
 | P065606 Total
2012-05-02 00:00:00 | P065607 | 135.58
2012-05-02 00:00:00 | P065607 | 115.84
2012-05-02 00:00:00 | P065607 | 115.84
2012-05-02 00:00:00 | P065607 | 135.58
2012-05-02 00:00:00 | P065607 | 135.58
2012-05-02 00:00:00 | P065607 | 135.58
 | P065607 Total
2012-05-02 00:00:00 | P065608 | 135.58
2012-05-02 00:00:00 | P065608 | 115.84
2012-05-02 00:00:00 | P065608 | 135.58
 | P065608 Total
2012-05-02 00:00:00 | P065609 | 813.48
2012-05-02 00:00:00 | P065609 | 813.48
2012-05-02 00:00:00 | P065609 | 740.4
2012-05-02 00:00:00 | P065609 | 528
 | P065609 Total
2012-05-02 00:00:00 | P065610 | 406.74
2012-05-02 00:00:00 | P065610 | 347.52
2012-05-02 00:00:00 | P065610 | 276.96
 | P065610 Total
2012-05-02 00:00:00 | P065611 | 925.92
2012-05-02 00:00:00 | P065611 | 925.92
2012-05-02 00:00:00 | P065611 | 925.92
2012-05-02 00:00:00 | P065611 | 925.92
2012-05-02 00:00:00 | P065611 | 925.92
2012-05-02 00:00:00 | P065611 | 925.92
 | P065611 Total
2012-05-02 00:00:00 | P065612 | 746.6
2012-05-02 00:00:00 | P065612 | 740.6
2012-05-02 00:00:00 | P065612 | 696.6
2012-05-02 00:00:00 | P065612 | 696.6
 | P065612 Total
2012-05-02 00:00:00 | P065613 | 406.74
2012-05-02 00:00:00 | P065613 | 347.52
2012-05-02 00:00:00 | P065613 | 347.52
2012-05-02 00:00:00 | P065613 | 347.52
2012-05-02 00:00:00 | P065613 | 990.96
 | P065613 Total
2012-05-02 00:00:00 | P065631 | 271.16
2012-05-02 00:00:00 | P065631 | 231.68
2012-05-02 00:00:00 | P065631 | 184.64
 | P065631 Total
2012-05-02 00:00:00 | P065638 | 271.16
2012-05-02 00:00:00 | P065638 | 231.68
2012-05-02 00:00:00 | P065638 | 271.16
2012-05-02 00:00:00 | P065638 | 198.4
2012-05-02 00:00:00 | P065638 | 176
 | P065638 Total
2012-05-02 00:00:00 | P065639 | 135.58
2012-05-02 00:00:00 | P065639 | 115.84
2012-05-02 00:00:00 | P065639 | 92.32
 | P065639 Total
2012-05-02 00:00:00 | [NAME] | 135.58
2012-05-02 00:00:00 | [NAME] | 115.84
2012-05-02 00:00:00 | [NAME] | 115.84
2012-05-02 00:00:00 | [NAME] | 115.84
2012-05-02 00:00:00 | [NAME] | 135.58
2012-05-02 00:00:00 | [NAME] | 115.84
 | P065652 Total
2012-05-02 00:00:00 | P065653 | 115.84
2012-05-02 00:00:00 | P065653 | 135.58
 | P065653 Total
2012-05-02 00:00:00 | P065654 | 135.58
2012-05-02 00:00:00 | P065654 | 115.84
 | P065654 Total
 | Grand Total
 |  | 1800
 |  | 1800
 |  | 575.84