Spreadsheet: 37786d1235795090-convoluted-excel-sum-formula-issues-report_commission-workfilev2
Sheet: DATA

order_date | order_no | item | date_cancel | date_invoiced | invoice_no | amount | commission_amt | Commissionable | Comm_keyfield | Cancelled
2008-10-03 16:57:24 | 123456 | Part-12782 | NULL | 2008-10-06 16:56:15 | 1253524 | 212.91 | 15.96825 | 1010 | 1010Oct-08 | OK
2008-10-07 10:50:49 | 123457 | Part-12775 | NULL | 2008-10-07 10:56:05 | 1253566 | 157.32 | 7.866 | 9999 | 9999Oct-08 | OK | NOTE
2008-10-07 10:50:49 | 123458 | [NAME] | NULL | 2008-10-07 10:56:05 | 1253566 | 676.78 | 33.839 | 1010 | 1010Oct-08 | OK | Columns  in orange are how are program exports data.
2008-10-07 10:20:03 | 123459 | Part-12775 | NULL | 2008-10-07 16:05:04 | 1253647 | 347.34 | 26.0505 | 9999 | 9999Oct-08 | OK | I'd like to leave this data unchanged as it will need to be
2008-10-07 09:48:58 | 123460 | Part-12768 | NULL | 2008-10-07 16:50:11 | 1253684 | 1289.34 | 64.467 | 9999 | 9999Oct-08 | OK | quickly replaced to automate report on monthly basis.
2008-10-09 10:09:51 | 123461 | Part-12769 | NULL | 2008-10-09 10:11:02 | 1253919 | 140.22 | 7.011 | 9999 | 9999Oct-08 | OK
2008-10-09 10:09:51 | 123462 | Part-12774 | NULL | 2008-10-09 10:11:02 | 1253919 | 557.08 | 27.854 | 9999 | 9999Oct-08 | OK | NOTE
2008-10-09 10:09:51 | 123463 | Part-12782 | NULL | 2008-10-09 10:11:02 | 1253919 | 799.9 | 39.995 | 1010 | 1010Oct-08 | OK | Columns in gray are fields that can be created to generate
2008-10-08 16:02:09 | 123464 | Part-12768 | NULL | 2008-10-09 15:00:16 | 1254038 | 111.34 | 5.567 | 9999 | 9999Oct-08 | OK | data in summary worksheet.  Create additional columns
2008-10-09 14:48:53 | 123465 | Part-12782 | NULL | 2008-10-09 15:53:26 | 1254074 | 477.96 | 35.847 | 1010 | 1010Oct-08 | OK | as necessary to complete necessary formulas on summary.
2008-10-09 11:14:16 | 123467 | Part-12765 | NULL | 2008-10-09 15:55:17 | 1254077 | 283.86 | 14.193 | 9999 | 9999Oct-08 | OK
2008-10-09 11:14:16 | 123466 | Part-12768 | NULL | 2008-10-09 15:55:17 | 1254077 | 160.74 | 8.037 | 9999 | 9999Oct-08 | OK | NOTE
2008-10-10 13:49:26 | 123469 | Part-12771 | NULL | 2008-10-10 14:03:58 | 1254272 | 545.3 | 27.265 | 9999 | 9999Oct-08 | OK | I have to leave the date as is in column E as that is how
2008-10-10 13:49:26 | 123470 | Part-12785 | NULL | 2008-10-10 14:03:58 | 1254272 | 805.6 | 40.28 | 1010 | 1010Oct-08 | OK | our operating program pulls the data.  Maybe create another column
2008-10-10 13:49:26 | 123468 | Part-12782 | NULL | 2008-10-10 14:03:58 | 1254272 | 35.72 | 1.786 | 1010 | 1010Oct-08 | OK | in gray that converts the date to a range????
2008-10-10 15:56:14 | 123471 | Part-12784 | NULL | 2008-10-10 15:58:14 | 1254320 | 200.64 | 10.032 | 1010 | 1010Oct-08 | OK
2008-10-10 15:56:14 | 123472 | Part-12780 | NULL | 2008-10-10 15:58:14 | 1254320 | 239.78 | 11.989 | 1010 | 1010Oct-08 | OK
2008-10-10 15:58:58 | 123474 | Part-12781 | NULL | 2008-10-10 16:09:03 | 1254321 | 101.84 | 5.092 | 1010 | 1010Oct-08 | OK
2008-10-10 15:58:58 | 123475 | Part-12765 | NULL | 2008-10-10 16:09:03 | 1254321 | 205.2 | 10.26 | 9999 | 9999Oct-08 | OK
2008-10-10 15:58:58 | 123473 | Part-12778 | 2008-10-10 16:09:03 | 2008-10-10 16:09:03 | 1254321 | 28.12 | 1.406 | 1010 | 1010Oct-08 | CANCELLED
2008-10-10 14:04:26 | 123476 | [NAME] | NULL | 2008-10-10 16:31:04 | 1254328 | 579.88 | 28.994 | 1010 | 1010Oct-08 | OK
2008-10-16 11:20:14 | 123477 | Part-12780 | NULL | 2008-10-16 15:40:34 | 1255072 | 579.88 | 28.994 | 1010 | 1010Oct-08 | OK
2008-10-08 16:02:09 | 123478 | [NAME] | NULL | 2008-10-16 16:36:54 | 1255096 | NULL | NULL | 1010 | 1010Oct-08 | OK
2008-10-17 08:58:43 | 123479 | Part-12775 | NULL | 2008-10-17 15:41:59 | 1255260 | 232.8 | 11.64 | 9999 | 9999Oct-08 | OK
2008-10-17 08:58:43 | 123480 | Part-12777 | NULL | 2008-10-17 15:41:59 | 1255260 | 316 | 15.8 | 1010 | 1010Oct-08 | OK
2008-10-17 08:58:43 | 123481 | Part-12784 | NULL | 2008-10-17 15:41:59 | 1255260 | NULL | NULL | 1010 | 1010Oct-08 | OK
2008-10-20 11:23:40 | 123482 | Part-12778 | NULL | 2008-10-20 16:18:44 | 1255463 | 1698.5 | 127.3875 | 1010 | 1010Oct-08 | OK
2008-10-21 13:09:58 | 123484 | [NAME] | NULL | 2008-10-21 13:14:10 | 1255565 | 83.98 | 4.199 | 1010 | 1010Oct-08 | OK
2008-10-21 13:09:58 | 123483 | Part-12777 | NULL | 2008-10-21 13:14:10 | 1255565 | 24.7 | 1.235 | 1010 | 1010Oct-08 | OK
2008-10-21 13:03:07 | 123486 | Part-12776 | NULL | 2008-10-21 13:15:08 | 1255566 | 110.96 | 5.548 | 1010 | 1010Oct-08 | OK
2008-10-21 13:03:07 | 123488 | Part-12766 | NULL | 2008-10-21 13:15:08 | 1255566 | 307.8 | 15.39 | 9999 | 9999Oct-08 | OK
2008-10-21 13:03:07 | 123487 | Part-12784 | NULL | 2008-10-21 13:15:08 | 1255566 | 245.86 | 12.293 | 1010 | 1010Oct-08 | OK
2008-10-21 13:03:07 | 123489 | Part-12765 | NULL | 2008-10-21 13:15:08 | 1255566 | 2705.6 | 135.28 | 9999 | 9999Oct-08 | OK
2008-10-21 13:03:07 | 123485 | Part-12780 | NULL | 2008-10-21 13:15:08 | 1255566 | 84.36 | 4.218 | 1010 | 1010Oct-08 | OK
2008-10-21 13:03:07 | 123490 | Part-12780 | NULL | 2008-10-21 13:16:41 | 1255567 | 422.94 | 21.147 | 1010 | 1010Oct-08 | OK
2008-10-21 13:00:43 | 123491 | Part-12780 | NULL | 2008-10-21 17:03:16 | 1255644 | 83.98 | 4.199 | 1010 | 1010Oct-08 | OK
2008-10-22 11:07:51 | 123492 | Part-12776 | NULL | 2008-10-22 15:41:53 | 1255807 | 287.7 | 14.385 | 1010 | 1010Oct-08 | OK
2008-10-23 08:55:24 | 123493 | [NAME] | NULL | 2008-10-27 14:42:39 | 1256288 | 210 | 10.5 | 9999 | 9999Oct-08 | OK
2008-10-14 17:19:22 | 123494 | Part-12783 | NULL | 2008-10-28 11:34:58 | 1256391 | 371.28 | 27.846 | 1010 | 1010Oct-08 | OK
2008-10-29 15:53:17 | 123495 | Part-12768 | NULL | 2008-10-29 17:01:54 | 1256722 | 64.22 | 6.422 | 9999 | 9999Oct-08 | OK
2008-10-29 15:53:17 | 123496 | Part-12770 | NULL | 2008-10-29 17:01:54 | 1256722 | NULL | NULL | 9999 | 9999Oct-08 | OK
2008-10-07 17:24:25 | 123497 | Part-12769 | NULL | 2008-10-31 15:15:33 | 1257097 | 477.66 | 23.883 | 9999 | 9999Oct-08 | OK
2008-10-07 17:24:25 | 123498 | Part-12785 | NULL | 2008-10-31 15:15:33 | 1257097 | 1666.3 | 83.315 | 1010 | 1010Oct-08 | OK
2008-10-07 17:24:25 | 123499 | Part-12771 | NULL | 2008-10-31 15:15:33 | 1257097 | NULL | NULL | 9999 | 9999Oct-08 | OK
2008-10-07 17:24:25 | 123500 | [NAME] | NULL | 2008-10-31 15:15:33 | 1257097 | NULL | NULL | 1010 | 1010Oct-08 | OK
2008-10-07 17:20:36 | 123501 | Part-12786 | NULL | 2008-10-31 15:16:14 | 1257099 | 1666.3 | 83.315 | 1010 | 1010Oct-08 | OK
2008-10-07 17:20:36 | 123503 | Part-12772 | NULL | 2008-10-31 15:16:14 | 1257099 | NULL | NULL | 9999 | 9999Oct-08 | OK
2008-10-07 17:20:36 | 123502 | Part-12780 | NULL | 2008-10-31 15:16:14 | 1257099 | NULL | NULL | 1010 | 1010Oct-08 | OK
2008-10-07 17:20:36 | 123504 | Part-12770 | NULL | 2008-10-31 15:16:57 | 1257101 | 477.66 | 23.883 | 9999 | 9999Oct-08 | OK
2008-10-31 11:27:46 | 123518 | Part-12778 | NULL | 2008-10-31 15:51:28 | 1257121 | NULL | NULL | 1010 | 1010Oct-08 | OK
2008-10-31 11:27:46 | 123509 | Part-12765 | NULL | 2008-10-31 15:51:28 | 1257121 | 114.38 | 5.719 | 9999 | 9999Oct-08 | OK
2008-10-31 11:27:46 | 123505 | Part-12767 | NULL | 2008-10-31 15:51:28 | 1257121 | 83.6 | 4.18 | 9999 | 9999Oct-08 | OK
2008-10-31 11:27:46 | 123508 | Part-12768 | NULL | 2008-10-31 15:51:28 | 1257121 | 114.38 | 5.719 | 9999 | 9999Oct-08 | OK
2008-10-31 11:27:46 | 123510 | Part-12781 | NULL | 2008-10-31 15:51:28 | 1257121 | 123.5 | 6.175 | 1010 | 1010Oct-08 | OK
2008-10-31 11:27:46 | 123511 | Part-12765 | NULL | 2008-10-31 15:51:28 | 1257121 | 385.32 | 19.266 | 9999 | 9999Oct-08 | OK
2008-10-31 11:27:46 | 123514 | Part-12776 | NULL | 2008-10-31 15:51:28 | 1257121 | 629.28 | 31.464 | 1010 | 1010Oct-08 | OK
2008-10-31 11:27:46 | 123515 | Part-12778 | NULL | 2008-10-31 15:51:28 | 1257121 | 646.76 | 32.338 | 1010 | 1010Oct-08 | OK
2008-10-31 11:27:46 | 123516 | Part-12783 | NULL | 2008-10-31 15:51:28 | 1257121 | 799.9 | 39.995 | 1010 | 1010Oct-08 | OK
2008-10-31 11:27:46 | 123512 | Part-12786 | NULL | 2008-10-31 15:51:28 | 1257121 | 509.58 | 25.479 | 1010 | 1010Oct-08 | OK
2008-10-31 11:27:46 | 123513 | Part-12770 | NULL | 2008-10-31 15:51:28 | 1257121 | 608.76 | 30.438 | 9999 | 9999Oct-08 | OK
2008-10-31 11:27:46 | 123517 | Part-12772 | NULL | 2008-10-31 15:51:28 | 1257121 | 826.5 | 41.325 | 9999 | 9999Oct-08 | OK
2008-10-31 11:27:46 | 123506 | Part-12785 | NULL | 2008-10-31 15:51:28 | 1257121 | 47.5 | 4.75 | 1010 | 1010Oct-08 | OK
2008-10-31 11:27:46 | 123507 | Part-12786 | NULL | 2008-10-31 15:51:28 | 1257121 | 57 | 5.7 | 1010 | 1010Oct-08 | OK
2008-11-03 13:49:10 | 123519 | Part-12771 | NULL | 2008-11-03 16:09:50 | 1257279 | 202.92 | 10.146 | 9999 | 9999Nov-08 | OK
2008-10-31 11:27:46 | 123520 | Part-12766 | NULL | 2008-11-04 15:16:31 | 1257401 | 71.44 | 3.572 | 9999 | 9999Nov-08 | OK
2008-11-06 12:54:47 | 123521 | Part-12777 | NULL | 2008-11-06 12:59:41 | 1257762 | 171.38 | 8.569 | 1010 | 1010Nov-08 | OK
2008-11-06 12:54:47 | 123522 | Part-12783 | NULL | 2008-11-06 12:59:41 | 1257762 | 216.22 | 10.811 | 1010 | 1010Nov-08 | OK
2008-11-06 12:54:47 | 123523 | Part-12771 | NULL | 2008-11-06 12:59:41 | 1257762 | 370.12 | 18.506 | 9999 | 9999Nov-08 | OK
2008-11-06 12:54:47 | 123524 | Part-12767 | NULL | 2008-11-06 12:59:41 | 1257762 | 3655.98 | 182.799 | 9999 | 9999Nov-08 | OK
2008-11-06 15:01:15 | 123525 | Part-12769 | NULL | 2008-11-06 16:16:52 | 1257829 | 1945.32 | 145.899 | 9999 | 9999Nov-08 | OK
2008-11-07 16:29:55 | 123526 | Part-12767 | NULL | 2008-11-07 17:25:50 | 1258033 | 71.4 | 7.14 | 9999 | 9999Nov-08 | OK
2008-11-07 16:29:55 | 123527 | Part-12769 | NULL | 2008-11-07 17:25:50 | 1258033 | 141.96 | 14.196 | 9999 | 9999Nov-08 | OK
2008-11-07 10:14:01 | 123528 | Part-12784 | NULL | 2008-11-10 09:41:53 | 1258058 | 6262.02 | 313.101 | 1010 | 1010Nov-08 | OK
2008-11-10 10:25:28 | 123529 | Part-12782 | NULL | NULL | NULL | 591.36 | NULL | 1010 | 1010NULL | OK
2008-11-11 11:31:47 | 123530 | Part-12781 | NULL | 2008-11-11 11:37:31 | 1258353 | 226.48 | 11.324 | 1010 | 1010Nov-08 | OK
2008-11-11 11:31:47 | 123531 | Part-12777 | NULL | 2008-11-11 11:37:31 | 1258353 | 471.96 | 23.598 | 1010 | 1010Nov-08 | OK
2008-11-11 14:40:44 | 123532 | Part-12785 | NULL | 2008-11-11 16:23:19 | 1258476 | 3254.16 | 244.062 | 1010 | 1010Nov-08 | OK
2008-11-14 15:32:23 | 123533 | Part-12772 | NULL | 2008-11-17 15:35:39 | 1259282 | 602.7 | 45.2025 | 9999 | 9999Nov-08 | OK
2008-11-14 10:17:15 | 123534 | Part-12784 | NULL | 2008-11-17 15:36:32 | 1259283 | 799.9 | 39.995 | 1010 | 1010Nov-08 | OK
2008-11-18 12:43:13 | 123535 | Part-12781 | 2008-11-18 12:53:03 | 2008-11-18 12:53:03 | 1259387 | 239.78 | 11.989 | 1010 | 1010Nov-08 | CANCELLED
2008-11-18 13:05:19 | 123536 | Part-12774 | NULL | 2008-11-18 13:11:17 | 1259394 | 387.22 | 19.361 | 9999 | 9999Nov-08 | OK
2008-11-19 11:56:53 | 123537 | Part-12766 | NULL | 2008-11-19 12:23:48 | 1259498 | 1352.8 | 67.64 | 9999 | 9999Nov-08 | OK
2008-11-18 13:53:52 | 123538 | Part-12765 | NULL | 2008-11-19 14:30:59 | 1259509 | 115.5 | 11.55 | 9999 | 9999Nov-08 | OK
2008-11-20 11:44:33 | 123541 | Part-12770 | NULL | 2008-11-20 15:58:23 | 1259723 | 703.38 | 35.169 | 9999 | 9999Nov-08 | OK
2008-11-20 11:44:33 | 123540 | Part-12772 | NULL | 2008-11-20 15:58:23 | 1259723 | 1370 | 0 | 9999 | 9999Nov-08 | OK
2008-11-20 11:44:33 | 123539 | [NAME] | NULL | 2008-11-20 15:58:23 | 1259723 | 1740 | 0 | 9999 | 9999Nov-08 | OK
2008-11-21 16:23:19 | 123542 | Part-12766 | NULL | 2008-11-24 15:19:46 | 1260039 | NULL | NULL | 9999 | 9999Nov-08 | OK
2008-11-21 11:49:28 | 123543 | Part-12785 | NULL | 2008-11-24 15:20:53 | 1260040 | 337.6 | 16.88 | 1010 | 1010Nov-08 | OK
2008-11-20 11:44:33 | 123544 | Part-12771 | NULL | 2008-11-24 15:21:56 | 1260041 | 234.46 | 11.723 | 9999 | 9999Nov-08 | OK
2008-11-25 09:49:09 | 123545 | Part-12772 | NULL | 2008-11-25 16:05:24 | 1260251 | 187.72 | 9.386 | 9999 | 9999Nov-08 | OK
2008-10-09 11:40:00 | 123546 | Part-12772 | NULL | 2008-11-25 16:06:23 | 1260252 | 489.82 | 24.491 | 9999 | 9999Nov-08 | OK
2008-10-09 11:40:00 | 123547 | Part-12765 | NULL | 2008-11-25 16:06:23 | 1260252 | 1819.06 | 90.953 | 9999 | 9999Nov-08 | OK
2008-10-09 11:40:00 | 123548 | [NAME] | NULL | 2008-11-25 16:06:23 | 1260252 | NULL | NULL | 9999 | 9999Nov-08 | OK
2008-11-24 15:38:28 | 123549 | Part-12785 | NULL | 2008-11-25 17:13:16 | 1260281 | NULL | NULL | 1010 | 1010Nov-08 | OK
2008-12-01 11:18:16 | 123550 | Part-12785 | 2008-12-10 15:52:10 | 2008-12-03 17:42:17 | 1260936 | 120.84 | 6.042 | 1010 | 1010Dec-08 | CANCELLED
2008-12-04 08:51:23 | 123551 | Part-12766 | NULL | 2008-12-04 08:54:17 | 1260940 | 512.24 | 25.612 | 9999 | 9999Dec-08 | OK
2008-12-04 08:51:23 | 123552 | Part-12767 | NULL | 2008-12-04 08:54:17 | 1260940 | 1352.8 | 67.64 | 9999 | 9999Dec-08 | OK
2008-11-25 09:49:09 | 123553 | [NAME] | NULL | 2008-12-04 08:58:02 | 1260942 | 187.72 | 9.386 | 9999 | 9999Dec-08 | OK
2008-11-24 15:38:28 | 123554 | Part-12768 | NULL | 2008-12-04 08:58:56 | 1260944 | 1352.8 | 67.64 | 9999 | 9999Dec-08 | OK
2008-11-26 17:03:55 | 123556 | Part-12783 | NULL | 2008-12-04 09:01:01 | 1260946 | 88.92 | 4.446 | 1010 | 1010Dec-08 | OK
2008-11-26 17:03:55 | 123555 | Part-12766 | NULL | 2008-12-04 09:01:01 | 1260946 | 52.06 | 2.603 | 9999 | 9999Dec-08 | OK
2008-12-05 13:02:40 | 123557 | [NAME] | NULL | 2008-12-05 13:04:57 | 1261221 | 275.5 | 13.775 | 9999 | 9999Dec-08 | OK
2008-12-09 08:39:14 | 123558 | Part-12776 | NULL | 2008-12-09 08:41:06 | 1261463 | 221.16 | 11.058 | 1010 | 1010Dec-08 | OK
2008-12-09 11:55:47 | 123559 | Part-12777 | NULL | 2008-12-09 15:47:27 | 1261547 | 287.7 | 14.385 | 1010 | 1010Dec-08 | OK
2008-12-09 13:32:13 | 123560 | Part-12786 | NULL | 2008-12-09 17:24:13 | 1261577 | NULL | NULL | 1010 | 1010Dec-08 | OK
2008-12-10 11:12:56 | 123561 | Part-12769 | NULL | 2008-12-10 11:14:18 | 1261674 | 1352.8 | 67.64 | 9999 | 9999Dec-08 | OK
2008-12-08 17:00:48 | 123562 | Part-12786 | NULL | 2008-12-10 13:41:18 | 1261694 | NULL | NULL | 1010 | 1010Dec-08 | OK
2008-12-11 10:21:48 | 123564 | Part-12782 | NULL | 2008-12-11 10:25:16 | 1261797 | 101.84 | 5.092 | 1010 | 1010Dec-08 | OK
2008-12-11 10:21:48 | 123563 | Part-12776 | NULL | 2008-12-11 10:25:16 | 1261797 | 21.28 | 1.064 | 1010 | 1010Dec-08 | OK
2008-12-11 15:26:13 | 123566 | Part-12767 | NULL | 2008-12-11 16:39:46 | 1261895 | 615.6 | 30.78 | 9999 | 9999Dec-08 | OK
2008-12-11 15:26:13 | 123565 | Part-12781 | NULL | 2008-12-11 16:39:46 | 1261895 | 56.24 | 2.812 | 1010 | 1010Dec-08 | OK
2008-10-07 09:48:58 | 123567 | Part-12780 | NULL | 2008-12-15 09:10:55 | 1262129 | 14949.58 | 747.479 | 1010 | 1010Dec-08 | OK
2008-10-07 09:48:58 | 123568 | Part-12774 | NULL | 2008-12-15 09:10:55 | 1262129 | NULL | NULL | 9999 | 9999Dec-08 | OK
2008-12-11 16:46:35 | 123569 | Part-12783 | NULL | 2008-12-15 09:11:27 | 1262130 | 194.79 | 14.60925 | 1010 | 1010Dec-08 | OK
2008-12-16 14:50:11 | 123570 | Part-12770 | NULL | 2008-12-16 14:57:37 | 1262277 | 171.38 | 8.569 | 9999 | 9999Dec-08 | OK
2008-12-16 14:50:11 | 123571 | Part-12772 | NULL | 2008-12-16 14:57:37 | 1262277 | 370.12 | 18.506 | 9999 | 9999Dec-08 | OK
2008-12-15 15:18:51 | 123572 | Part-12775 | NULL | 2008-12-17 16:20:04 | 1262414 | 194.94 | 9.747 | 9999 | 9999Dec-08 | OK
2008-12-16 17:18:28 | 123576 | Part-12766 | NULL | 2008-12-17 16:48:15 | 1262434 | 851.58 | 42.579 | 9999 | 9999Dec-08 | OK
2008-12-16 17:18:28 | 123575 | Part-12767 | NULL | 2008-12-17 16:48:15 | 1262434 | 443.84 | 22.192 | 9999 | 9999Dec-08 | OK
2008-12-16 17:18:28 | 123573 | Part-12769 | NULL | 2008-12-17 16:48:15 | 1262434 | 321.48 | 16.074 | 9999 | 9999Dec-08 | OK
2008-12-16 17:18:28 | 123577 | Part-12771 | NULL | 2008-12-17 16:48:15 | 1262434 | 937.08 | 46.854 | 9999 | 9999Dec-08 | OK
2008-12-16 17:18:28 | 123574 | Part-12774 | NULL | 2008-12-17 16:48:15 | 1262434 | 375.44 | 18.772 | 9999 | 9999Dec-08 | OK
2008-12-16 17:18:28 | 123578 | Part-12775 | NULL | 2008-12-17 16:48:15 | 1262434 | 1282.5 | 64.125 | 9999 | 9999Dec-08 | OK
2008-12-15 14:29:26 | 123579 | [NAME] | NULL | 2008-12-18 10:44:31 | 1262457 | 545.3 | 27.265 | 9999 | 9999Dec-08 | OK
2008-12-11 14:32:16 | 123580 | [NAME] | NULL | 2008-12-29 14:50:11 | 1263166 | 489.82 | 24.491 | 9999 | 9999Dec-08 | OK
2008-12-11 14:32:16 | 123581 | Part-12781 | NULL | 2008-12-29 14:50:11 | 1263166 | NULL | NULL | 1010 | 1010Dec-08 | OK
2008-12-11 11:40:26 | 123582 | Part-12786 | NULL | 2008-12-29 15:06:19 | 1263167 | 350.74 | 17.537 | 1010 | 1010Dec-08 | OK
2008-12-11 11:40:26 | 123583 | Part-12771 | NULL | 2008-12-29 15:06:19 | 1263167 | 477.66 | 23.883 | 9999 | 9999Dec-08 | OK
2008-12-11 11:40:26 | 123584 | Part-12769 | NULL | 2008-12-29 15:06:19 | 1263167 | NULL | NULL | 9999 | 9999Dec-08 | OK
2008-12-11 11:40:26 | 123585 | Part-12770 | NULL | 2008-12-29 15:06:19 | 1263167 | NULL | NULL | 9999 | 9999Dec-08 | OK
2008-12-11 11:40:26 | 123586 | Part-12777 | NULL | 2008-12-29 15:06:19 | 1263167 | NULL | NULL | 1010 | 1010Dec-08 | OK
2008-12-11 11:40:26 | 123587 | Part-12778 | NULL | 2008-12-29 15:06:19 | 1263167 | NULL | NULL | 1010 | 1010Dec-08 | OK
2008-12-11 14:24:19 | 123588 | Part-12767 | NULL | 2008-12-29 15:07:22 | 1263168 | 2501.92 | 125.096 | 9999 | 9999Dec-08 | OK
2008-12-11 14:24:19 | 123589 | Part-12774 | NULL | 2008-12-29 15:07:22 | 1263168 | NULL | NULL | 9999 | 9999Dec-08 | OK
2008-10-07 17:20:36 | 123591 | Part-12775 | 2008-10-09 11:39:33 | NULL | NULL | NULL | NULL | 9999 | 9999NULL | CANCELLED
2008-10-07 17:24:25 | 123590 | Part-12774 | 2008-10-09 11:33:27 | NULL | NULL | NULL | NULL | 9999 | 9999NULL | CANCELLED
2008-10-09 11:40:00 | 123593 | Part-12778 | 2008-11-19 13:44:50 | NULL | NULL | NULL | NULL | 1010 | 1010NULL | CANCELLED
2008-10-21 13:03:07 | 123592 | Part-12781 | 2008-10-21 13:09:52 | NULL | NULL | NULL | NULL | 1010 | 1010NULL | CANCELLED
2008-11-21 11:49:28 | 123594 | Part-12768 | 2008-11-21 12:38:02 | NULL | NULL | NULL | NULL | 9999 | 9999NULL | CANCELLED
2008-12-11 11:40:26 | 123595 | Part-12782 | 2008-12-12 16:35:14 | NULL | NULL | NULL | NULL | 1010 | 1010NULL | CANCELLED