Spreadsheet: 46702d1245644310-data-analysis-of-dates-splits-and-segments-of-dept-codes-sample
Sheet: Raw

Extract the number of outstanding unique [NAME]. No. (column "L"), and the value of those Order Numbers (column "I"), summarised by distribtion codes (first two digets of column "K") and by older than 60 days and between 30 and 60 days against delivery date in column "M". If an [NAME]. No. is split (e.g. cells [NAME] and L24), the [NAME]. No. counts as once for each Distribution code.The raw data is unlikely to exceed 1,000 lines. |  |  |  | Number of unique orders, and values of unique orders split by distribution code and by date values
 |  |  | Distribution code: | 20- | 21- | 22- | 23- | 24- | 24- | 26- | 27-
 | Number of Ord. No. before |  | 2009-04-19 00:00:00
 | number of [NAME]. No. between | 2009-04-20 00:00:00 | 2009-05-20 00:00:00
 | Value of orders before |  | 2009-04-19 00:00:00
 | Value of orders between | 2009-04-20 00:00:00 | 2009-05-20 00:00:00
Date | 2009-06-19 00:00:00
Type | Line No. | Supp. Accnt. | Description | Purch. Accnt. | Unit Cost | Quantity | Tax Value | Value | Status | Distribution Code | [NAME]. No. | Delivery Date | Doc. No.
ORD | 1 | ABCDE | Description 1 | 77325 | 213 | 1 | 21.3 | 234.3 | C | 20-000000-580-2 | 12569 | 2009-06-05 00:00:00 | 12569
ORD | 20 | ABDFE | Description Another | 78610 | 5000 | 0.69 | 347.53 | 3822.69 | C | 20-000000-580-2 | 11154 | 2009-05-29 00:00:00 | 11154
ORD | 6 | ABDEF | Description Yet More | 77505 | 27272.78 | 0.04 | 109.42 | 1203.59 | C | 20-000000-580-1 | 6341 | 2009-04-30 00:00:00 | 6341
ORD | 2 | SBEJR | Description Again | 78040 | 220 | 1 | 22 | 242 | C | 20-000000-580-2 | 12075 | 2009-04-29 00:00:00 | 12075
ORD | 2 | DJEIF | Description Etc. | 78040 | 220 | 1 | 22 | 242 | C | 20-000000-580-1 | 12076 | 2009-04-29 00:00:00 | 12076
ORD | 5 | DJHEKED | Description 2 | 78010 | 452.65 | 1 | 45.26 | 497.91 | C | 20-000000-580-2 | 12099 | 2009-04-28 00:00:00 | 12099
ORD | 1 | SDFSADF | Description Another | 77710 | 15 | 1 | 1.5 | 16.5 | C | 20-000000-580-2 | 11838 | 2009-04-24 00:00:00 | 11838
ORD | 2 | ASDF | Description Yet More | 77710 | 15 | 1 | 1.5 | 16.5 | C | 20-000000-580-2 | 11560 | 2009-04-17 00:00:00 | 11560
ORD | 1 | EWR | Description Again | 78040 | 540 | 1 | 54 | 594 | C | 20-000000-580-1 | 12126 | 2009-04-15 00:00:00 | 12126
ORD | 13 | SDFSADF | Description Etc. | 77715 | 2500 | 0.14 | 35 | 385 | C | 20-000000-580-1 | 6112 | 2009-04-10 00:00:00 | 6112
ORD | 12 | DJEIF | Description 3 | 78610 | 45000 | 0.13 | 574.74 | 6322.26 | C | 20-000000-580-2 | 9971 | 2009-03-31 00:00:00 | 9971
ORD | 1 | DJHEKED | Description Another | 78535 | 67.81 | 6 | 40.69 | 447.55 | C | 20-004057-540-2 | 9546 | 2009-02-27 00:00:00 | 9546
ORD | 9 | SDFSADF | Description Yet More | 78040 | 235 | 1 | 23.5 | 258.5 | C | 23-000000-580-1 | 9546 | 2008-12-03 00:00:00 | 9391
ORD | 11 | ASDF | Description Again | 77705 | 1400 | 0.56 | 78.64 | 865.03 | C | 23-000000-580-2 | 7847 | 2009-06-30 00:00:00 | 7847
ORD | 8 | EWR | Description Etc. | 77345 | 100 | 0.23 | 2.32 | 25.44 | C | 23-000000-580-2 | 10312 | 2009-06-30 00:00:00 | 10312
ORD | 14 | ETWERT | Description 4 | 76530 | 56.91 | 2 | 11.38 | 125.2 | C | 23-000000-580-1 | 10699 | 2009-06-30 00:00:00 | 10699
ORD | 13 | DJEIF | Description Another | 76530 | 37.94 | 38 | 144.17 | 1585.89 | C | 23-000000-580-1 | 10699 | 2009-06-30 00:00:00 | 10699
ORD | 12 | DJHEKED | Description Yet More | 76530 | 56.91 | 3.5 | 19.92 | 219.11 | C | 23-000000-580-1 | 10699 | 2009-06-30 00:00:00 | 10699
ORD | 11 | SDFSADF | Description Again | 76530 | 37.94 | 38 | 144.17 | 1585.89 | C | 23-000000-580-1 | 10699 | 2009-06-30 00:00:00 | 10699
ORD | 13 | ASDF | Description Etc. | 78030 | 7 | 0 | 0 | 0 | C | 23-000000-580-2 | 11126 | 2009-06-30 00:00:00 | 11126
ORD | 12 | EWR | Description 5 | 78030 | 373.64 | 0 | 0 | 0 | C | 23-000000-580-2 | 11126 | 2009-06-30 00:00:00 | 11126
ORD | 27 | DJEIF | Description Another | 77625 | 110 | 0.79 | 8.73 | 95.93 | C | 23-000000-580-2 | 11486 | 2009-06-30 00:00:00 | 11486
ORD | 12 | DJHEKED | Description Yet More | 76530 | 1550 | 4.41 | 683.94 | 7523.31 | C | 23-000000-580-2 | 11772 | 2009-06-30 00:00:00 | 11772
ORD | 3 | SDFSADF | Description Again | 78100 | 22900 | 0.88 | 2010 | 22110 | C | 23-000000-580-1 | 12110 | 2009-06-30 00:00:00 | 12110
ORD | 1 | ASDF | Description Etc. | 77325 | 235 | 1 | 23.5 | 258.5 | C | 23-000000-580-2 | 12778 | 2009-06-30 00:00:00 | 12778
ORD | 5 | EWR | Description 6 | 20050 | 605.61 | 1 | 60.56 | 666.17 | C | 23-000000-580-1 | 12926 | 2009-06-30 00:00:00 | 12926
ORD | 4 | ETWERT | Description Another | 20050 | 605.61 | 1 | 60.56 | 666.17 | C | 23-000000-580-2 | 12926 | 2009-06-30 00:00:00 | 12926
ORD | 3 | SDFSADF | Description Yet More | 20050 | 258.05 | 4 | 103.22 | 1135.42 | C | 23-000000-580-2 | 12927 | 2009-06-30 00:00:00 | 12927
ORD | 1 | WER | Description Again | 78000 | 657.17 | 1 | 65.72 | 722.89 | C | 23-000000-580-2 | 13019 | 2009-06-30 00:00:00 | 13019
ORD | 2 | SF | Description Etc. | 78040 | 1050 | 1 | 105 | 1155 | C | 23-000000-580-2 | 13019 | 2009-06-30 00:00:00 | 13019
ORD | 1 | CTNTEXPRE | Description 7 | 78600 | 4815 | 1 | 481.5 | 5296.5 | C | 23-000000-580-2 | 11123 | 2009-07-31 00:00:00 | 11123
ORD | 1 | WER | Description Another | 78600 | 810 | 1 | 81 | 891 | C | 23-000000-580-2 | 11793 | 2009-07-31 00:00:00 | 11793
ORD | 1 | WER | Description Yet More | 78100 | 10480 | 1 | 1048 | 11528 | C | 23-000000-580-2 | 11837 | 2009-07-31 00:00:00 | 11837
ORD | 1 | SDFSADF | Description Again | 76705 | 358.09 | 1 | 35.81 | 393.9 | C | 23-000000-580-1 | 13020 | 2009-07-31 00:00:00 | 13020
ORD | 2 | G | Description Etc. | 78040 | 500 | 1 | 50 | 550 | C | 24-000000-580-1 | 13020 | 2009-07-31 00:00:00 | 13020
ORD | 9 | TY | Description 8 | 77505 | 464 | 0.6 | 27.74 | 305.38 | C | 24-000000-580-1 | 7848 | 2009-08-31 00:00:00 | 7848
ORD | 10 | RTY | Description Another | 77505 | 464 | 0 | 0 | 0 | C | 24-000000-580-1 | 7848 | 2009-08-31 00:00:00 | 7848
ORD | 3 | [NAME] | Description Yet More | 78010 | 5580 | 0.66 | 369.21 | 4061.31 | C | 24-000000-580-2 | 12090 | 2009-09-30 00:00:00 | 12090
ORD | 2 | UYERTYWERT | Description Again | 78010 | 27.9 | 5 | 0 | 139.5 | C | 24-000000-580-2 | 12093 | 2009-09-30 00:00:00 | 12093
ORD | 5 | [NAME] | Description Etc. | 78030 | 2613.65 | 1.19 | 310.83 | 3419.21 | C | 24-000000-580-2 | 12101 | 2009-09-30 00:00:00 | 12101
ORD | 1 | WERT | Description 9 | 78030 | 7 | 6 | 4.2 | 46.2 | C | 24-000000-580-2 | 12122 | 2009-09-30 00:00:00 | 12122
ORD | 4 | WE | Description Another | 77610 | 1500 | 1 | 150 | 1650 | C | 24-000000-580-2 | 12949 | 2009-09-30 00:00:00 | 12949
ORD | 7 | TW | Description Yet More | 77720 | 750 | 0.8 | 59.88 | 658.62 | C | 24-000000-580-2 | 12949 | 2009-09-30 00:00:00 | 12949
ORD | 3 | EWR | Description Again | 77720 | 1000 | 1 | 100 | 1100 | C | 24-000000-580-2 | 12949 | 2009-09-30 00:00:00 | 12949
ORD | 6 | SDFSADF | Description Etc. | 77610 | 1000 | 0.87 | 0 | 874.68 | C | 24-000000-580-2 | 12949 | 2009-09-30 00:00:00 | 12949
ORD | 1 | DJEIF | Description 10 | 77715 | 3000 | 1 | 300 | 3300 | C | 24-000000-580-2 | 12949 | 2009-09-30 00:00:00 | 12949
ORD | 3 | DJHEKED | Description Another | 77500 | 2000 | 0.34 | 68.4 | 752.4 | C | 24-000000-580-2 | 11973 | 2009-10-30 00:00:00 | 11973
ORD | 3 | SDFSADF | Description Yet More | 77615 | 90 | 4 | 0 | 360 | C | 24-000000-580-2 | 12172 | 2009-10-30 00:00:00 | 12172
ORD | 1 | ASDF | Description Again | 78030 | 418.7 | 6 | 251.22 | 2763.42 | C | 24-000000-580-2 | 12441 | 2009-10-30 00:00:00 | 12441
ORD | 3 | EWR | Description Etc. | 76830 | 380.64 | 4 | 152.26 | 1674.82 | C | 24-000000-580-2 | 12815 | 2009-12-31 00:00:00 | 12815
ORD | 2 | ETWERT | Description 11 | 77105 | 25000 | 0.68 | 1700 | 18700 | C | 24-000000-580-2 | 12919 | 2009-12-31 00:00:00 | 12919
ORD | 3 | DJEIF | Description Another | 77100 | 15000 | 4.16 | 6243.75 | 68681.25 | C | 24-000000-580-2 | 12973 | 2009-12-31 00:00:00 | 12973
ORD | 26 | DJHEKED | Description Yet More | 76005 | 40 | 1 | 4 | 44 | C | 21-004030-510-2 | 2621 | 2007-07-30 00:00:00 | 2621
ORD | 41 | SDFSADF | Description Again | 76005 | 20 | 1 | 2 | 22 | C | 21-004030-510-2 | 2621 | 2007-07-30 00:00:00 | 2621
ORD | 4 | ASDF | Description Etc. | 20140 | 1690 | 1 | 169 | 1859 | C | 21-004030-510-2 | 2621 | 2007-07-30 00:00:00 | 2621
ORD | 10 | EWR | Description 12 | 76005 | 100 | 1 | 10 | 110 | C | 21-004030-510-2 | 2621 | 2007-07-30 00:00:00 | 2621
ORD | 56 | DJEIF | Description Another | 76005 | 12 | 3 | 3.6 | 39.6 | C | 21-004030-510-2 | 2621 | 2007-07-30 00:00:00 | 2621
ORD | 27 | DJHEKED | Description Yet More | 76005 | 50 | 1 | 5 | 55 | C | 21-004030-510-2 | 2621 | 2007-07-30 00:00:00 | 2621
ORD | 13 | SDFSADF | Description Again | 76005 | 74 | 1 | 7.4 | 81.4 | C | 21-004030-510-2 | 2621 | 2007-08-30 00:00:00 | 2621
ORD | 14 | ASDF | Description Etc. | 76005 | 40 | 1 | 4 | 44 | C | 21-004030-510-2 | 2621 | 2007-08-30 00:00:00 | 2621
ORD | 4 | EWR | Description 13 | 20120 | 1070 | 1 | 107 | 1177 | C | 21-004030-510-2 | 2938 | 2007-07-31 00:00:00 | 2938
ORD | 3 | ETWERT | Description Another | 20120 | 945 | 2 | 189 | 2079 | C | 21-004030-510-2 | 2938 | 2007-07-31 00:00:00 | 2938
ORD | 7 | SDFSADF | Description Yet More | 20120 | 82 | 12 | 98.4 | 1082.4 | C | 21-004030-510-2 | 2938 | 2007-07-31 00:00:00 | 2938
ORD | 1 | WER | Description Again | 20120 | 788 | 12 | 945.6 | 10401.6 | C | 21-004030-510-2 | 2938 | 2007-07-31 00:00:00 | 2938
ORD | 1 | SF | Description Etc. | 20050 | 100 | 1 | 10 | 110 | C | 21-004030-510-2 | 4212 | 2007-11-30 00:00:00 | 4212
ORD | 1 | CTNTEXPRE | Description 14 | 76005 | 214.95 | 5 | 107.47 | 1182.22 | C | 21-004035-510-2 | 4750 | 2008-01-25 00:00:00 | 4750
ORD | 1 | WER | Description Another | 20050 | 1000 | 1 | 100 | 1100 | C | 21-004030-510-2 | 4892 | 2008-01-31 00:00:00 | 4892
ORD | 3 | WER | Description Yet More | 76100 | 6020 | 1 | 602 | 6622 | C | 21-000000-510-2 | 9315 | 2009-03-27 00:00:00 | 9315
ORD | 4 | SDFSADF | Description Again | 76100 | 6020 | 1 | 602 | 6622 | C | 21-000000-510-2 | 9315 | 2009-03-27 00:00:00 | 9315
ORD | 2 | G | Description Etc. | 76100 | 6020 | 1 | 602 | 6622 | C | 21-000000-510-2 | 9315 | 2009-03-27 00:00:00 | 9315
ORD | 3 | TY | Description 15 | 76100 | 2224 | 1.36 | 302 | 3322 | C | 21-000000-510-2 | 9679 | 2009-03-31 00:00:00 | 9679
ORD | 5 | RTY | Description Another | 76100 | 228 | 1 | 22.8 | 250.8 | C | 21-000000-510-2 | 9716 | 2009-03-27 00:00:00 | 9716
ORD | 4 | [NAME] | Description Yet More | 76100 | 176 | 1 | 17.6 | 193.6 | C | 21-000000-510-2 | 10250 | 2009-03-31 00:00:00 | 10250
ORD | 5 | UYERTYWERT | Description Again | 76100 | 189 | 1 | 18.9 | 207.9 | C | 22-000000-510-2 | 10250 | 2009-03-31 00:00:00 | 10250
ORD | 1 | EWR | Description Etc. | 76100 | 356 | 13 | 462.8 | 5090.8 | C | 22-000000-510-2 | 10263 | 2009-05-29 00:00:00 | 10263
ORD | 8 | SDFSADF | Description 16 | 76100 | 248 | 4.59 | 113.9 | 1252.9 | C | 22-000000-510-2 | 10263 | 2009-05-29 00:00:00 | 10263
ORD | 3 | DJEIF | Description Another | 76100 | 178 | 1.92 | 34.2 | 376.2 | C | 22-000000-510-2 | 10277 | 2009-05-29 00:00:00 | 10277
ORD | 4 | DJHEKED | Description Yet More | 76100 | 25 | 2 | 5 | 55 | C | 22-000000-510-2 | 10277 | 2009-05-29 00:00:00 | 10277
ORD | 5 | SDFSADF | Description Again | 76100 | 216 | 1 | 21.6 | 237.6 | C | 22-000000-510-2 | 10279 | 2009-05-29 00:00:00 | 10279
ORD | 6 | ASDF | Description Etc. | 76100 | 218 | 0 | 0 | 0 | C | 22-000000-510-2 | 10281 | 2009-05-29 00:00:00 | 10281
ORD | 3 | EWR | Description 17 | 76100 | 773 | 6.66 | 514.5 | 5659.5 | C | 22-000000-510-2 | 10340 | 2009-05-29 00:00:00 | 10340
ORD | 22 | ETWERT | Description Another | 76100 | 2124 | 1.56 | 331.9 | 3650.9 | C | 22-000000-510-2 | 10342 | 2009-05-29 00:00:00 | 10342
ORD | 1 | DJEIF | Description Yet More | 76100 | 2224 | 4 | 889.6 | 9785.6 | C | 22-000000-510-2 | 10343 | 2009-05-29 00:00:00 | 10343
ORD | 4 | DJHEKED | Description Again | 76100 | 2224 | 3.21 | 714.4 | 7858.4 | C | 22-000000-510-2 | 10343 | 2009-05-29 00:00:00 | 10343
ORD | 3 | SDFSADF | Description Etc. | 76100 | 2224 | 4 | 889.6 | 9785.6 | C | 22-000000-510-2 | 10343 | 2009-05-29 00:00:00 | 10343
ORD | 4 | ASDF | Description 18 | 76100 | 558.5 | 2.53 | 141.46 | 1556.06 | C | 22-000000-510-2 | 10344 | 2009-05-29 00:00:00 | 10344
ORD | 20 | EWR | Description Another | 76100 | 25 | 21 | 52.5 | 577.5 | C | 22-000000-510-2 | 10651 | 2009-05-29 00:00:00 | 10651
ORD | 1 | DJEIF | Description Yet More | 76100 | 50 | 12 | 60 | 660 | C | 22-000000-510-2 | 10742 | 2009-03-27 00:00:00 | 10742
ORD | 2 | DJHEKED | Description Again | 76100 | 25 | 4 | 10 | 110 | C | 22-000000-510-2 | 10742 | 2009-03-27 00:00:00 | 10742
ORD | 2 | SDFSADF | Description Etc. | 76100 | 21 | 13 | 27.3 | 300.3 | C | 22-000000-510-2 | 10961 | 2009-04-24 00:00:00 | 10961
ORD | 3 | ASDF | Description 19 | 76100 | 20 | 4 | 8 | 88 | C | 22-000000-510-2 | 10961 | 2009-04-24 00:00:00 | 10961
ORD | 1 | EWR | Description Another | 76100 | 50 | 13 | 65 | 715 | C | 22-000000-510-2 | 10961 | 2009-04-24 00:00:00 | 10961
ORD | 4 | ETWERT | Description Yet More | 76100 | 356 | 6.11 | 217.4 | 2391.4 | C | 22-000000-510-2 | 10962 | 2009-04-24 00:00:00 | 10962
ORD | 6 | SDFSADF | Description Again | 76100 | 368 | 2.21 | 81.5 | 896.5 | C | 23-000000-510-2 | 11070 | 2009-05-29 00:00:00 | 11070
ORD | 10 | WER | Description Etc. | 76100 | 368 | 0.24 | 9 | 99 | C | 23-000000-510-2 | 11070 | 2009-05-29 00:00:00 | 11070
ORD | 27 | SF | Description 20 | 76105 | 50 | 4.68 | 23.4 | 257.4 | C | 23-000000-510-2 | 11168 | 2009-04-30 00:00:00 | 11168
ORD | 28 | CTNTEXPRE | Description Another | 76105 | 25 | 10 | 25 | 275 | C | 23-000000-510-2 | 11168 | 2009-04-30 00:00:00 | 11168
ORD | 15 | WER | Description Yet More | 76105 | 324 | 5 | 162 | 1782 | C | 23-000000-510-2 | 11168 | 2009-04-30 00:00:00 | 11168
ORD | 18 | WER | Description Again | 76105 | 378 | 8 | 302.4 | 3326.4 | C | 23-000000-510-2 | 11168 | 2009-04-30 00:00:00 | 11168
ORD | 19 | SDFSADF | Description Etc. | 76105 | 270 | 8 | 216 | 2376 | C | 23-000000-510-2 | 11168 | 2009-04-30 00:00:00 | 11168
ORD | 26 | G | Description 21 | 76105 | 21 | 9 | 18.9 | 207.9 | C | 23-000000-510-2 | 11168 | 2009-04-30 00:00:00 | 11168
ORD | 25 | TY | Description Another | 76105 | 324 | 8 | 259.2 | 2851.2 | C | 23-000000-510-2 | 11168 | 2009-04-30 00:00:00 | 11168
ORD | 1 | RTY | Description Yet More | 78535 | 1672 | 2 | 334.4 | 3678.4 | C | 23-000000-530-2 | 11457 | 2009-04-03 00:00:00 | 11457
ORD | 1 | [NAME] | Description Again | 77100 | 90 | 8 | 72 | 792 | C | 23-004030-510-2 | 11519 | 2009-04-30 00:00:00 | 11519
ORD | 1 | UYERTYWERT | Description Etc. | 78535 | 422.1 | 3 | 126.63 | 1392.93 | C | 23-000000-510-2 | 11639 | 2009-04-10 00:00:00 | 11639
ORD | 7 | EWR | Description 22 | 76905 | 6696.39 | 0.44 | 294.63 | 3240.93 | C | 23-000000-510-2 | 11687 | 2009-05-31 00:00:00 | 11687
ORD | 2 | SDFSADF | Description Another | 78535 | 26.1 | 1 | 2.61 | 28.71 | C | 23-000000-530-2 | 11695 | 2009-04-14 00:00:00 | 11695
ORD | 2 | DJEIF | Description Yet More | 78535 | 16.25 | 5 | 8.12 | 89.38 | C | 23-000000-530-2 | 11697 | 2009-04-16 00:00:00 | 11697
ORD | 11 | DJHEKED | Description Again | 78535 | 15.46 | 0 | 0 | 0 | C | 23-000000-530-2 | 11797 | 2009-04-20 00:00:00 | 11797
ORD | 1 | SDFSADF | Description Etc. | 76105 | 150 | 1 | 15 | 165 | C | 23-000000-510-2 | 11814 | 2009-04-20 00:00:00 | 11814
ORD | 4 | ASDF | Description 23 | 78535 | 23.58 | 3 | 7.07 | 77.81 | C | 23-000000-530-2 | 11820 | 2009-04-20 00:00:00 | 11820
ORD | 1 | EWR | Description Another | 77100 | 3060 | 1 | 306 | 3366 | C | 23-004090-510-2 | 11890 | 2009-04-20 00:00:00 | 11890
ORD | 1 | ETWERT | Description Yet More | 76105 | 88 | 15 | 132 | 1452 | C | 23-000000-510-2 | 11918 | 2009-05-29 00:00:00 | 11918
ORD | 2 | DJEIF | Description Again | 78500 | 12 | 3 | 3.6 | 39.6 | C | 21-000000-530-2 | 11999 | 2009-04-29 00:00:00 | 11999
ORD | 1 | DJHEKED | Description Etc. | 78500 | 20 | 3 | 6 | 66 | C | 21-000000-530-2 | 11999 | 2009-04-29 00:00:00 | 11999
ORD | 3 | SDFSADF | Description 24 | 78500 | 14 | 3 | 4.2 | 46.2 | C | 21-000000-530-2 | 11999 | 2009-04-29 00:00:00 | 11999
ORD | 4 | ASDF | Description Another | 78500 | 135 | 2 | 27 | 297 | C | 21-000000-530-2 | 11999 | 2009-04-29 00:00:00 | 11999
ORD | 1 | EWR | Description Yet More | 78500 | 1552 | 1 | 155.2 | 1707.2 | C | 21-000000-530-2 | 12001 | 2009-04-30 00:00:00 | 12001
ORD | 5 | DJEIF | Description Again | 78535 | 216 | 3 | 64.8 | 712.8 | C | 21-000000-530-2 | 12054 | 2009-05-06 00:00:00 | 12054
ORD | 1 | DJHEKED | Description Etc. | 74005 | 0.17 | 19000 | 316.35 | 3479.85 | C | 21-000000-510-2 | 12168 | 2009-05-02 00:00:00 | 12168
ORD | 1 | SDFSADF | Description 25 | 78535 | 9.14 | 150 | 137.1 | 1508.1 | C | 21-000000-530-2 | 12174 | 2009-05-05 00:00:00 | 12174
ORD | 1 | ASDF | Description Another | 78535 | 252.5 | 20 | 505 | 5555 | C | 21-000000-530-2 | 12309 | 2009-05-15 00:00:00 | 12309
ORD | 1 | EWR | Description Yet More | 78535 | 34.96 | 50 | 174.8 | 1922.8 | C | 21-000000-530-2 | 12310 | 2009-05-08 00:00:00 | 12310
ORD | 1 | ETWERT | Description Again | 78535 | 650 | 5 | 325 | 3575 | C | 21-000000-530-2 | 12313 | 2009-05-15 00:00:00 | 12313
ORD | 2 | SDFSADF | Description Etc. | 78535 | 99.4 | 10 | 99.4 | 1093.4 | C | 21-000000-530-2 | 12313 | 2009-05-15 00:00:00 | 12313
ORD | 1 | WER | Description 26 | 78535 | 15 | 10 | 15 | 165 | C | 21-000000-530-2 | 12331 | 2009-05-15 00:00:00 | 12331
ORD | 1 | SF | Description Another | 78535 | 34.96 | 48 | 167.81 | 1845.89 | C | 21-000000-530-2 | 12361 | 2009-05-13 00:00:00 | 12361
ORD | 3 | CTNTEXPRE | Description Yet More | 78535 | 1104.89 | 2 | 220.98 | 2430.76 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 2 | WER | Description Again | 78535 | 1059.16 | 4 | 423.66 | 4660.3 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 6 | WER | Description Etc. | 78535 | 132.19 | 3 | 39.66 | 436.23 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 10 | SDFSADF | Description 27 | 78535 | 250 | 10 | 250 | 2750 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 11 | G | Description Another | 78535 | 462 | 5 | 231 | 2541 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 4 | TY | Description Yet More | 78535 | 253.21 | 3 | 75.96 | 835.59 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 9 | RTY | Description Again | 78535 | 38.84 | 20 | 77.68 | 854.48 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 5 | [NAME] | Description Etc. | 78535 | 246.7 | 3 | 74.01 | 814.11 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 7 | UYERTYWERT | Description 28 | 78535 | 274.64 | 3 | 82.39 | 906.31 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 1 | EWR | Description Another | 78535 | 2056.74 | 2 | 411.35 | 4524.83 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 8 | SDFSADF | Description Yet More | 78535 | 246.7 | 2 | 49.34 | 542.74 | C | 21-000000-530-2 | 12379 | 2009-05-22 00:00:00 | 12379
ORD | 2 | DJEIF | Description Again | 77710 | 50 | 1 | 5 | 55 | C | 26-000000-530-2 | 12436 | 2009-05-22 00:00:00 | 12436
ORD | 1 | DJHEKED | Description Etc. | 78535 | 450 | 3 | 135 | 1485 | C | 26-000000-530-2 | 12436 | 2009-05-22 00:00:00 | 12436
ORD | 1 | SDFSADF | Description 29 | 78535 | 3150 | 1 | 315 | 3465 | C | 26-000000-531-2 | 12452 | 2009-05-29 00:00:00 | 12452
ORD | 2 | ASDF | Description Another | 77710 | 760 | 1 | 76 | 836 | C | 26-000000-531-2 | 12452 | 2009-05-29 00:00:00 | 12452
ORD | 1 | EWR | Description Yet More | 20040 | 1471 | 1 | 147.1 | 1618.1 | C | 26-000000-510-2 | 12453 | 2009-05-29 00:00:00 | 12453
ORD | 2 | ETWERT | Description Again | 78535 | 71.91 | 6 | 43.15 | 474.61 | C | 26-000000-510-2 | 12468 | 2009-05-30 00:00:00 | 12468
ORD | 1 | DJEIF | Description Etc. | 78535 | 249.52 | 2 | 49.9 | 548.94 | C | 26-000000-510-2 | 12468 | 2009-05-30 00:00:00 | 12468
ORD | 1 | DJHEKED | Description 30 | 78500 | 5373.25 | 1 | 537.32 | 5910.57 | C | 26-000000-530-2 | 12518 | 2009-05-20 00:00:00 | 12518
ORD | 2 | SDFSADF | Description Another | 78500 | 5373.25 | 1 | 537.32 | 5910.57 | C | 26-000000-530-2 | 12518 | 2009-05-20 00:00:00 | 12518
ORD | 1 | ASDF | Description Yet More | 78500 | 95 | 8 | 76 | 836 | C | 26-000000-530-2 | 12534 | 2009-05-26 00:00:00 | 12534
ORD | 2 | EWR | Description Again | 78500 | 100 | 1 | 10 | 110 | C | 26-000000-530-2 | 12534 | 2009-05-26 00:00:00 | 12534
ORD | 1 | DJEIF | Description Etc. | 78500 | 360 | 1 | 36 | 396 | C | 26-000000-530-2 | 12555 | 2009-05-27 00:00:00 | 12555
ORD | 2 | DJHEKED | Description 31 | 77005 | 6.15 | 15 | 9.22 | 101.47 | C | 26-000000-510-2 | 12556 | 2009-05-21 00:00:00 | 12556
ORD | 1 | SDFSADF | Description Another | 77005 | 29.15 | 1 | 2.92 | 32.07 | C | 26-000000-510-2 | 12556 | 2009-05-29 00:00:00 | 12556
ORD | 2 | ASDF | Description Yet More | 78515 | 310 | 1 | 31 | 341 | C | 26-000000-531-2 | 12672 | 2009-06-01 00:00:00 | 12672
ORD | 1 | EWR | Description Again | 78515 | 2016 | 1 | 201.6 | 2217.6 | C | 26-000000-531-2 | 12672 | 2009-06-01 00:00:00 | 12672
ORD | 2 | ETWERT | Description Etc. | 77500 | 18.1 | 0 | 0 | 0 | C | 26-000000-510-2 | 12685 | 2009-06-03 00:00:00 | 12685
ORD | 1 | SDFSADF | Description 32 | 74009 | 4.95 | 1400 | 693 | 7623 | C | 26-000000-510-2 | 12695 | 2009-06-03 00:00:00 | 12695
ORD | 2 | WER | Description Another | 78535 | 250 | 10 | 250 | 2750 | C | 26-000000-530-2 | 12704 | 2009-06-05 00:00:00 | 12704
ORD | 1 | SF | Description Yet More | 78535 | 80 | 20 | 160 | 1760 | C | 26-000000-530-2 | 12704 | 2009-06-05 00:00:00 | 12704
ORD | 1 | CTNTEXPRE | Description Again | 77500 | 48.79 | 4 | 19.52 | 214.68 | C | 26-000000-510-2 | 12705 | 2009-06-03 00:00:00 | 12705
ORD | 1 | WER | Description Etc. | 78500 | 13098 | 1 | 1309.8 | 14407.8 | C | 26-000000-530-2 | 12711 | 2009-05-29 00:00:00 | 12711
ORD | 1 | WER | Description 33 | 78505 | 420.3 | 1 | 42.03 | 462.33 | C | 26-000000-531-2 | 12741 | 2009-06-02 00:00:00 | 12741
ORD | 1 | SDFSADF | Description Another | 78500 | 1800 | 1 | 180 | 1980 | C | 26-000000-530-2 | 12777 | 2009-06-05 00:00:00 | 12777
ORD | 1 | G | Description Yet More | 78500 | 19500 | 1 | 1950 | 21450 | C | 26-000000-530-2 | 12800 | 2009-06-17 00:00:00 | 12800
ORD | 2 | TY | Description Again | 78535 | 12.77 | 2 | 2.55 | 28.09 | C | 26-000000-530-2 | 12808 | 2009-06-09 00:00:00 | 12808
ORD | 1 | RTY | Description Etc. | 78535 | 18.4 | 2 | 3.68 | 40.48 | C | 26-000000-530-2 | 12808 | 2009-06-09 00:00:00 | 12808
ORD | 1 | [NAME] | Description 34 | 78500 | 80 | 10 | 80 | 880 | C | 26-000000-530-2 | 12836 | 2009-06-10 00:00:00 | 12836
ORD | 1 | UYERTYWERT | Description Another | 78500 | 3200 | 1 | 320 | 3520 | C | 26-000000-530-2 | 12864 | 2009-06-10 00:00:00 | 12864
ORD | 1 | EWR | Description Yet More | 78535 | 108 | 8 | 86.4 | 950.4 | C | 26-000000-530-2 | 12934 | 2009-06-18 00:00:00 | 12934
ORD | 1 | SDFSADF | Description Again | 74013 | 541 | 25 | 1352.5 | 14877.5 | C | 26-000000-510-2 | 12962 | 2009-06-18 00:00:00 | 12962
ORD | 2 | DJEIF | Description Etc. | 74005 | 0.17 | 81.08 | 1.35 | 14.85 | C | 26-000000-510-2 | 12976 | 2009-06-16 00:00:00 | 12976
ORD | 6 | DJHEKED | Description 35 | 78535 | 40.94 | 2 | 8.19 | 90.07 | C | 26-000000-531-2 | 12991 | 2009-06-18 00:00:00 | 12991
ORD | 4 | SDFSADF | Description Another | 78535 | 35.54 | 2 | 7.11 | 78.19 | C | 26-000000-531-2 | 12991 | 2009-06-18 00:00:00 | 12991
ORD | 3 | ASDF | Description Yet More | 78535 | 9.28 | 2 | 1.86 | 20.42 | C | 26-000000-531-2 | 12991 | 2009-06-18 00:00:00 | 12991
ORD | 1 | EWR | Description Again | 78535 | 5.42 | 10 | 5.42 | 59.62 | C | 26-000000-531-2 | 12991 | 2009-06-18 00:00:00 | 12991
ORD | 5 | ETWERT | Description Etc. | 78535 | 46 | 1 | 4.6 | 50.6 | C | 26-000000-531-2 | 12991 | 2009-06-18 00:00:00 | 12991
ORD | 2 | DJEIF | Description 36 | 78535 | 5.94 | 12 | 7.13 | 78.41 | C | 26-000000-531-2 | 12991 | 2009-06-18 00:00:00 | 12991
ORD | 1 | DJHEKED | Description Another | 78535 | 1020 | 2 | 204 | 2244 | C | 26-000000-530-2 | 13011 | 2009-06-16 00:00:00 | 13011
ORD | 1 | SDFSADF | Description Yet More | 74022 | 412.54 | 25 | 1031.35 | 11344.85 | C | 26-000000-510-2 | 12972 | 2009-06-19 00:00:00 | 12972
ORD | 3 | ASDF | Description Again | 78535 | 2.91 | 5 | 1.46 | 16.01 | C | 26-000000-530-2 | 13009 | 2009-06-19 00:00:00 | 13009
ORD | 2 | EWR | Description Etc. | 78535 | 9.97 | 5 | 4.98 | 54.83 | C | 26-000000-530-2 | 13009 | 2009-06-19 00:00:00 | 13009
ORD | 1 | DJEIF | Description 37 | 78535 | 8.58 | 10 | 8.58 | 94.38 | C | 26-000000-530-2 | 13009 | 2009-06-19 00:00:00 | 13009
ORD | 2 | DJHEKED | Description Another | 78535 | 80 | 40 | 320 | 3520 | C | 26-000000-510-2 | 13010 | 2009-06-19 00:00:00 | 13010
ORD | 3 | SDFSADF | Description Yet More | 78535 | 217 | 20 | 434 | 4774 | C | 26-000000-510-2 | 13010 | 2009-06-19 00:00:00 | 13010
ORD | 5 | ASDF | Description Again | 78535 | 66 | 30 | 198 | 2178 | C | 27-000000-510-2 | 13010 | 2009-06-19 00:00:00 | 13010
ORD | 1 | EWR | Description Etc. | 78535 | 80 | 40 | 320 | 3520 | C | 27-000000-510-2 | 13010 | 2009-06-19 00:00:00 | 13010
ORD | 6 | ETWERT | Description 38 | 78535 | 66 | 30 | 198 | 2178 | C | 27-000000-510-2 | 13010 | 2009-06-19 00:00:00 | 13010
ORD | 2 | SDFSADF | Description Another | 78535 | 1225 | 2 | 245 | 2695 | C | 27-000000-530-2 | 13011 | 2009-06-19 00:00:00 | 13011
ORD | 4 | WER | Description Yet More | 78535 | 27.8 | 30 | 83.4 | 917.4 | C | 27-000000-510-2 | 13012 | 2009-06-19 00:00:00 | 13012
ORD | 3 | SF | Description Again | 78535 | 46.5 | 20 | 93 | 1023 | C | 27-000000-510-2 | 13012 | 2009-06-19 00:00:00 | 13012
ORD | 2 | CTNTEXPRE | Description Etc. | 78535 | 34.25 | 20 | 68.5 | 753.5 | C | 27-000000-510-2 | 13012 | 2009-06-19 00:00:00 | 13012
ORD | 5 | WER | Description 39 | 78535 | 36.3 | 30 | 108.9 | 1197.9 | C | 27-000000-510-2 | 13012 | 2009-06-19 00:00:00 | 13012
ORD | 7 | WER | Description Another | 78535 | 145 | 10 | 145 | 1595 | C | 27-000000-510-2 | 13012 | 2009-06-19 00:00:00 | 13012
ORD | 1 | SDFSADF | Description Yet More | 78535 | 84.9 | 20 | 169.8 | 1867.8 | C | 27-000000-510-2 | 13012 | 2009-06-19 00:00:00 | 13012
ORD | 6 | G | Description Again | 78535 | 38.15 | 20 | 76.3 | 839.3 | C | 27-000000-510-2 | 13012 | 2009-06-19 00:00:00 | 13012
ORD | 2 | TY | Description Etc. | 78535 | 3905 | 3 | 1171.5 | 12886.5 | C | 27-000000-530-2 | 13040 | 2009-06-19 00:00:00 | 13040
ORD | 3 | RTY | Description 40 | 78535 | 2730 | 3 | 819 | 9009 | C | 27-000000-530-2 | 13040 | 2009-06-19 00:00:00 | 13040
ORD | 1 | [NAME] | Description Another | 78535 | 3807 | 3 | 1142.1 | 12563.1 | C | 27-000000-530-2 | 13040 | 2009-06-19 00:00:00 | 13040
ORD | 1 | UYERTYWERT | Description Yet More | 74000 | 221 | 19 | 419.9 | 4618.9 | C | 27-000000-510-2 | 13028 | 2009-06-22 00:00:00 | 13028
ORD | 1 | EWR | Description Again | 74013 | 541 | 25 | 1352.5 | 14877.5 | C | 27-000000-510-2 | 13041 | 2009-06-23 00:00:00 | 13041
ORD | 1 | SDFSADF | Description Etc. | 74013 | 541 | 25 | 1352.5 | 14877.5 | C | 27-000000-510-2 | 13042 | 2009-06-25 00:00:00 | 13042
ORD | 1 | DJEIF | Description 41 | 76105 | 737 | 8 | 589.6 | 6485.6 | C | 27-000000-510-2 | 11993 | 2009-06-26 00:00:00 | 11993
ORD | 2 | DJHEKED | Description Another | 76100 | 487 | 2 | 97.4 | 1071.4 | C | 27-000000-510-2 | 12040 | 2009-06-26 00:00:00 | 12040
ORD | 5 | SDFSADF | Description Yet More | 76100 | 25 | 2 | 5 | 55 | C | 27-000000-510-2 | 12040 | 2009-06-26 00:00:00 | 12040
ORD | 3 | ASDF | Description Again | 76100 | 406 | 2 | 81.2 | 893.2 | C | 27-000000-510-2 | 12040 | 2009-06-26 00:00:00 | 12040
ORD | 1 | EWR | Description Etc. | 76100 | 487 | 2 | 97.4 | 1071.4 | C | 23-000000-510-2 | 12040 | 2009-06-26 00:00:00 | 12040
ORD | 4 | ETWERT | Description 42 | 76100 | 50 | 2 | 10 | 110 | C | 23-000000-510-2 | 12040 | 2009-06-26 00:00:00 | 12040
ORD | 3 | DJEIF | Description Another | 76105 | 100 | 16.17 | 161.7 | 1778.7 | C | 23-000000-510-2 | 12107 | 2009-06-26 00:00:00 | 12107
ORD | 7 | DJHEKED | Description Yet More | 76100 | 162 | 1 | 16.2 | 178.2 | C | 23-000000-510-2 | 12155 | 2009-06-26 00:00:00 | 12155
ORD | 9 | SDFSADF | Description Again | 76100 | 75 | 1 | 7.5 | 82.5 | C | 23-000000-510-2 | 12155 | 2009-06-26 00:00:00 | 12155
ORD | 11 | ASDF | Description Etc. | 76100 | 486 | 1 | 48.6 | 534.6 | C | 23-000000-510-2 | 12155 | 2009-06-26 00:00:00 | 12155
ORD | 10 | EWR | Description 43 | 76100 | 75 | 1 | 7.5 | 82.5 | C | 23-000000-510-2 | 12155 | 2009-06-26 00:00:00 | 12155
ORD | 8 | DJEIF | Description Another | 76100 | 75 | 1 | 7.5 | 82.5 | C | 23-000000-510-2 | 12155 | 2009-06-26 00:00:00 | 12155
ORD | 12 | DJHEKED | Description Yet More | 76100 | 25 | 1.08 | 2.7 | 29.7 | C | 23-000000-510-2 | 12155 | 2009-06-26 00:00:00 | 12155
ORD | 4 | SDFSADF | Description Again | 78535 | 217 | 20 | 434 | 4774 | C | 23-000000-510-2 | 13010 | 2009-06-26 00:00:00 | 13010
ORD | 1 | ASDF | Description Etc. | 78535 | 1214 | 2 | 242.8 | 2670.8 | C | 23-000000-530-2 | 13024 | 2009-06-26 00:00:00 | 13024
ORD | 5 | EWR | Description 44 | 78535 | 328 | 2 | 65.6 | 721.6 | C | 23-000000-530-2 | 13024 | 2009-06-26 00:00:00 | 13024
ORD | 6 | ETWERT | Description Another | 78535 | 250 | 2 | 50 | 550 | C | 23-000000-530-2 | 13024 | 2009-06-26 00:00:00 | 13024
ORD | 7 | SDFSADF | Description Yet More | 78535 | 928 | 2 | 185.6 | 2041.6 | C | 23-000000-530-2 | 13024 | 2009-06-26 00:00:00 | 13024
ORD | 3 | WER | Description Again | 78535 | 135 | 4 | 54 | 594 | C | 23-000000-530-2 | 13024 | 2009-06-26 00:00:00 | 13024
ORD | 2 | SF | Description Etc. | 78535 | 985 | 2 | 197 | 2167 | C | 23-000000-530-2 | 13024 | 2009-06-26 00:00:00 | 13024
ORD | 4 | CTNTEXPRE | Description 45 | 78535 | 571 | 2 | 114.2 | 1256.2 | C | 23-000000-530-2 | 13024 | 2009-06-26 00:00:00 | 13024
ORD | 22 | WER | Description Another | 76100 | 2421 | 0.16 | 38.5 | 423.5 | C | 23-000000-510-2 | 8514 | 2009-06-30 00:00:00 | 8514
ORD | 20 | WER | Description Yet More | 76100 | 2421 | 0.72 | 175.2 | 1927.2 | C | 23-000000-510-2 | 8514 | 2009-06-30 00:00:00 | 8514
ORD | 14 | SDFSADF | Description Again | 76100 | 632.62 | 0.63 | 39.7 | 436.7 | C | 23-000000-510-2 | 8535 | 2009-06-30 00:00:00 | 8535
ORD | 24 | G | Description Etc. | 76100 | 632.62 | 2.38 | 150.82 | 1659.02 | C | 23-000000-510-2 | 8535 | 2009-06-30 00:00:00 | 8535
ORD | 20 | TY | Description 46 | 76100 | 632.62 | 1.2 | 76.11 | 837.2 | C | 23-000000-510-2 | 8535 | 2009-06-30 00:00:00 | 8535