Spreadsheet: 48659d1247877222-choosing-specific-constrained-cells-from-a-separate-sheet-help
Sheet: Sheet1

orderid | regionid | systemid | stationid | typeid | bid | price | minvolume | volremain | volenter | issued | duration | range | reportedby | reportedtime
914412146 | 10000042 | 30003394 | 60001363 | 18 | 1 | 1.12 | 1 | 6438252 | 10000000 | 2009-04-30 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:47:26.05
914412146 | 10000042 | 30003394 | 60001363 | 18 | 1 | 1.12 | 1 | 6438252 | 10000000 | 2009-04-30 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:50:27.02
1199581964 | 10000042 | 30003437 | 60005023 | 18 | 1 | 1.1299 | 1 | 952014 | 1000000 | 2009-07-12 00:00:00.00 | 90:00:00:00.00 | 4 | 0 | 2009-07-16 19:47:26.05
1199581964 | 10000042 | 30003437 | 60005023 | 18 | 1 | 1.1299 | 1 | 952014 | 1000000 | 2009-07-12 00:00:00.00 | 90:00:00:00.00 | 4 | 0 | 2009-07-16 19:50:27.02
990451292 | 10000030 | 30002510 | 60004588 | 18 | 1 | 2.24 | 1 | 2021802 | 2500000 | 2009-05-07 00:00:00.00 | 90:00:00:00.00 | 40 | 0 | 2009-07-16 19:38:25.46
1195955987 | 10000030 | 30002526 | 60004615 | 18 | 1 | 2.25 | 1 | 100000 | 100000 | 2009-07-10 00:00:00.00 | 90:00:00:00.00 | 40 | 0 | 2009-07-16 19:38:25.45
1197302939 | 10000030 | 30002510 | 60004588 | 18 | 1 | 2.55 | 1 | 78579 | 100000 | 2009-07-11 00:00:00.00 | 90:00:00:00.00 | 40 | 0 | 2009-07-16 19:38:25.45
1194156760 | 10000042 | 30003416 | 60005377 | 18 | 1 | 10 | 1 | 278732 | 499999 | 2009-07-08 00:00:00.00 | 90:00:00:00.00 | 2 | 0 | 2009-07-16 19:47:26.04
1194156760 | 10000042 | 30003416 | 60005377 | 18 | 1 | 10 | 1 | 278732 | 499999 | 2009-07-08 00:00:00.00 | 90:00:00:00.00 | 2 | 0 | 2009-07-16 19:50:27.02
1163406044 | 10000042 | 30003377 | 60006442 | 18 | 1 | 16.01 | 1 | 2436941 | 2500000 | 2009-06-14 00:00:00.00 | 90:00:00:00.00 | 0 | 0 | 2009-07-16 19:47:26.04
1163496283 | 10000042 | 30003400 | 60005332 | 18 | 1 | 16.01 | 1 | 919912 | 1000000 | 2009-06-14 00:00:00.00 | 90:00:00:00.00 | 1 | 0 | 2009-07-16 19:47:26.04
1163406044 | 10000042 | 30003377 | 60006442 | 18 | 1 | 16.01 | 1 | 2436941 | 2500000 | 2009-06-14 00:00:00.00 | 90:00:00:00.00 | 0 | 0 | 2009-07-16 19:50:27.02
1163496283 | 10000042 | 30003400 | 60005332 | 18 | 1 | 16.01 | 1 | 919912 | 1000000 | 2009-06-14 00:00:00.00 | 90:00:00:00.00 | 1 | 0 | 2009-07-16 19:50:27.02
1189039884 | 10000042 | 30003443 | 60006076 | 18 | 1 | 21.7 | 5 | 259799 | 285715 | 2009-07-04 00:00:00.00 | 30:00:00:00.00 | 0 | 0 | 2009-07-16 19:47:26.04
1189039884 | 10000042 | 30003443 | 60006076 | 18 | 1 | 21.7 | 5 | 259799 | 285715 | 2009-07-04 00:00:00.00 | 30:00:00:00.00 | 0 | 0 | 2009-07-16 19:50:27.01
953044658 | 10000042 | 30003400 | 60005335 | 18 | 1 | 22 | 1 | 1483963 | 2000000 | 2009-05-01 00:00:00.00 | 90:00:00:00.00 | 0 | 0 | 2009-07-16 19:47:26.03
1190231777 | 10000042 | 30003458 | 60004711 | 18 | 1 | 22 | 1 | 953388 | 2000000 | 2009-07-05 00:00:00.00 | 90:00:00:00.00 | 1 | 0 | 2009-07-16 19:47:26.04
953044658 | 10000042 | 30003400 | 60005335 | 18 | 1 | 22 | 1 | 1483963 | 2000000 | 2009-05-01 00:00:00.00 | 90:00:00:00.00 | 0 | 0 | 2009-07-16 19:50:27.01
1190231777 | 10000042 | 30003458 | 60004711 | 18 | 1 | 22 | 1 | 953388 | 2000000 | 2009-07-05 00:00:00.00 | 90:00:00:00.00 | 1 | 0 | 2009-07-16 19:50:27.01
1168325964 | 10000030 | 30002518 | 60015053 | 18 | 1 | 22.01 | 10 | 545805 | 750000 | 2009-07-14 00:00:00.00 | 30:00:00:00.00 | 10 | 0 | 2009-07-16 19:38:25.45
1175184160 | 10000030 | 30002545 | 60004759 | 18 | 1 | 22.31 | 1 | 9991 | 10000 | 2009-06-23 00:00:00.00 | 90:00:00:00.00 | 1 | 0 | 2009-07-16 19:38:25.45
1165297563 | 10000042 | 30003468 | 60014794 | 18 | 1 | 22.38 | 1 | 80209 | 100000 | 2009-06-15 00:00:00.00 | 90:00:00:00.00 | 3 | 0 | 2009-07-16 19:47:26.03
1182263471 | 10000042 | 30003468 | 60014794 | 18 | 1 | 22.38 | 1 | 50000 | 50000 | 2009-06-29 00:00:00.00 | 90:00:00:00.00 | 3 | 0 | 2009-07-16 19:47:26.03
1165297563 | 10000042 | 30003468 | 60014794 | 18 | 1 | 22.38 | 1 | 80209 | 100000 | 2009-06-15 00:00:00.00 | 90:00:00:00.00 | 3 | 0 | 2009-07-16 19:50:27.01
1182263471 | 10000042 | 30003468 | 60014794 | 18 | 1 | 22.38 | 1 | 50000 | 50000 | 2009-06-29 00:00:00.00 | 90:00:00:00.00 | 3 | 0 | 2009-07-16 19:50:27.01
1195808345 | 10000030 | 30002531 | 60014791 | 18 | 1 | 22.5 | 1 | 296831 | 300000 | 2009-07-15 00:00:00.00 | 30:00:00:00.00 | 1 | 0 | 2009-07-16 19:38:25.45
1203696005 | 10000042 | 30002072 | 60012628 | 18 | 1 | 23.17 | 1 | 100000 | 100000 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:47:26.03
1203697741 | 10000042 | 30002074 | 60012625 | 18 | 1 | 23.17 | 1 | 100000 | 100000 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:47:26.03
1203697922 | 10000042 | 30002069 | 60012622 | 18 | 1 | 23.17 | 1 | 100000 | 100000 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:47:26.03
1203696005 | 10000042 | 30002072 | 60012628 | 18 | 1 | 23.17 | 1 | 100000 | 100000 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:50:27.00
1203697741 | 10000042 | 30002074 | 60012625 | 18 | 1 | 23.17 | 1 | 100000 | 100000 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:50:27.00
1203697922 | 10000042 | 30002069 | 60012622 | 18 | 1 | 23.17 | 1 | 100000 | 100000 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:50:27.00
1197268879 | 10000042 | 30003387 | 60007417 | 18 | 1 | 24 | 85581 | 85581 | 85581 | 2009-07-11 00:00:00.00 | 30:00:00:00.00 | 1 | 0 | 2009-07-16 19:47:26.02
1197269222 | 10000042 | 30003387 | 60007417 | 18 | 1 | 24 | 85581 | 85581 | 85581 | 2009-07-11 00:00:00.00 | 30:00:00:00.00 | 1 | 0 | 2009-07-16 19:47:26.02
1197268879 | 10000042 | 30003387 | 60007417 | 18 | 1 | 24 | 85581 | 85581 | 85581 | 2009-07-11 00:00:00.00 | 30:00:00:00.00 | 1 | 0 | 2009-07-16 19:50:26.99
1197269222 | 10000042 | 30003387 | 60007417 | 18 | 1 | 24 | 85581 | 85581 | 85581 | 2009-07-11 00:00:00.00 | 30:00:00:00.00 | 1 | 0 | 2009-07-16 19:50:27.00
1203170846 | 10000042 | 30003396 | 60004942 | 18 | 1 | 24.2 | 1 | 499906 | 500000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | 1 | 0 | 2009-07-16 19:47:26.02
1203170846 | 10000042 | 30003396 | 60004942 | 18 | 1 | 24.2 | 1 | 499906 | 500000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | 1 | 0 | 2009-07-16 19:50:26.99
1173717015 | 10000030 | 30002510 | 60004588 | 18 | 1 | 25.11 | 1 | 230334 | 1700000 | 2009-06-26 00:00:00.00 | 90:00:00:00.00 | 2 | 0 | 2009-07-16 19:38:25.45
1169165681 | 10000030 | 30002507 | 60009121 | 18 | 1 | 25.2 | 1 | 129724 | 333000 | 2009-06-27 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:38:25.44
1184113901 | 10000030 | 30002507 | 60004591 | 18 | 1 | 25.64 | 1 | 232331 | 1000000 | 2009-07-09 00:00:00.00 | 90:00:00:00.00 | 0 | 0 | 2009-07-16 19:38:25.44
1198984741 | 10000030 | 30012547 | 60015037 | 18 | 1 | 25.77 | 1000 | 1000000 | 1000000 | 2009-07-12 00:00:00.00 | 90:00:00:00.00 | 3 | 0 | 2009-07-16 19:38:25.44
1171244929 | 10000030 | 30002526 | 60004615 | 18 | 1 | 25.8 | 1 | 55508 | 1000000 | 2009-07-12 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:38:25.44
1200728377 | 10000030 | 30002513 | 60010066 | 18 | 1 | 25.88 | 1 | 1000000 | 1000000 | 2009-07-13 00:00:00.00 | 90:00:00:00.00 | 0 | 0 | 2009-07-16 19:38:25.44
1196037970 | 10000030 | 30002507 | 60005728 | 18 | 1 | 25.97 | 1 | 682699 | 1000000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | 5 | 0 | 2009-07-16 19:38:25.44
1202851242 | 10000030 | 30002568 | 60010291 | 18 | 1 | 25.98 | 1 | 7144452 | 10000000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | 4 | 0 | 2009-07-16 19:38:25.43
1160507953 | 10000030 | 30002505 | 60014779 | 18 | 1 | 26 | 1 | 5844019 | 10000000 | 2009-07-09 00:00:00.00 | 90:00:00:00.00 | 3 | 0 | 2009-07-16 19:38:25.43
1195818269 | 10000030 | 30002526 | 60004615 | 18 | 1 | 26 | 1 | 61924 | 400000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:38:25.43
1195819407 | 10000030 | 30002507 | 60004591 | 18 | 1 | 26 | 1 | 362855 | 400000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:38:25.43
1179471829 | 10000030 | 30002510 | 60004588 | 18 | 1 | 26.01 | 1 | 4115557 | 5000000 | 2009-07-01 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:38:25.43
1175567218 | 10000030 | 30002545 | 60005056 | 18 | 1 | 26.03 | 1 | 483723 | 500000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:38:25.42
1122509785 | 10000042 | 30003449 | 60004501 | 18 | 1 | 26.6 | 1 | 546346 | 1000000 | 2009-05-15 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:47:26.01
1122509785 | 10000042 | 30003449 | 60004501 | 18 | 1 | 26.6 | 1 | 546346 | 1000000 | 2009-05-15 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:50:26.99
1194887624 | 10000030 | 30002549 | 60006055 | 18 | 0 | 27.03 | 1 | 22876 | 23875 | 2009-07-09 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:38:25.40
1172970916 | 10000042 | 30003393 | 60000040 | 18 | 1 | 27.23 | 1 | 295802 | 750000 | 2009-07-02 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:47:26.01
1172970916 | 10000042 | 30003393 | 60000040 | 18 | 1 | 27.23 | 1 | 295802 | 750000 | 2009-07-02 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:50:26.99
1198854310 | 10000030 | 30002543 | 60010048 | 18 | 0 | 27.46 | 1 | 61005 | 61005 | 2009-07-12 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:38:25.42
1203634580 | 10000042 | 30003377 | 60006442 | 18 | 0 | 27.71 | 1 | 57739 | 58738 | 2009-07-16 00:00:00.00 | 7:00:00:00.00 | 32767 | 0 | 2009-07-16 19:47:25.99
1203634580 | 10000042 | 30003377 | 60006442 | 18 | 0 | 27.71 | 1 | 57739 | 58738 | 2009-07-16 00:00:00.00 | 7:00:00:00.00 | 32767 | 0 | 2009-07-16 19:50:26.96
1190211657 | 10000042 | 30003419 | 60003499 | 18 | 0 | 27.8 | 1 | 7122 | 7122 | 2009-07-05 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:47:25.99
1190211657 | 10000042 | 30003419 | 60003499 | 18 | 0 | 27.8 | 1 | 7122 | 7122 | 2009-07-05 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:50:26.97
1174463838 | 10000042 | 30003389 | 60006088 | 18 | 1 | 27.85 | 1 | 643906 | 1000000 | 2009-07-12 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:47:26.01
1201293697 | 10000042 | 30003412 | 60005428 | 18 | 1 | 27.85 | 1 | 200743 | 1000000 | 2009-07-14 00:00:00.00 | 90:00:00:00.00 | 0 | 0 | 2009-07-16 19:47:26.01
1203030954 | 10000042 | 30003412 | 60005428 | 18 | 1 | 27.85 | 1 | 1000000 | 1000000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | 0 | 0 | 2009-07-16 19:47:26.01
1174463838 | 10000042 | 30003389 | 60006088 | 18 | 1 | 27.85 | 1 | 643906 | 1000000 | 2009-07-12 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:50:26.98
1201293697 | 10000042 | 30003412 | 60005428 | 18 | 1 | 27.85 | 1 | 200743 | 1000000 | 2009-07-14 00:00:00.00 | 90:00:00:00.00 | 0 | 0 | 2009-07-16 19:50:26.98
1203030954 | 10000042 | 30003412 | 60005428 | 18 | 1 | 27.85 | 1 | 1000000 | 1000000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | 0 | 0 | 2009-07-16 19:50:26.99
1196014827 | 10000042 | 30002053 | 60005686 | 18 | 1 | 27.9 | 1 | 8581 | 100000 | 2009-07-10 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:47:26.00
1196014827 | 10000042 | 30002053 | 60005686 | 18 | 1 | 27.9 | 1 | 8581 | 100000 | 2009-07-10 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:50:26.98
1204005264 | 10000042 | 30002075 | 60007288 | 18 | 1 | 27.91 | 1 | 1999403 | 2000000 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | 4 | 0 | 2009-07-16 19:47:26.00
1204005264 | 10000042 | 30002075 | 60007288 | 18 | 1 | 27.91 | 1 | 1999403 | 2000000 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | 4 | 0 | 2009-07-16 19:50:26.98
1203051051 | 10000042 | 30003413 | 60005416 | 18 | 1 | 27.92 | 1 | 530545 | 800000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:47:26.00
1203683159 | 10000042 | 30003412 | 60005428 | 18 | 1 | 27.92 | 1 | 799720 | 800000 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:47:26.00
1203051051 | 10000042 | 30003413 | 60005416 | 18 | 1 | 27.92 | 1 | 530545 | 800000 | 2009-07-15 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:50:26.97
1203683159 | 10000042 | 30003412 | 60005428 | 18 | 1 | 27.92 | 1 | 799720 | 800000 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | -1 | 0 | 2009-07-16 19:50:26.98
1148578254 | 10000030 | 30002546 | 60004750 | 18 | 0 | 28 | 1 | 24626 | 62727 | 2009-06-03 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:38:25.42
1203754917 | 10000030 | 30002543 | 60004756 | 18 | 0 | 29 | 1 | 523252 | 523252 | 2009-07-16 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:38:25.42
1170929577 | 10000042 | 30002053 | 60005686 | 18 | 0 | 29 | 1 | 9396 | 24136 | 2009-06-20 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:47:25.99
1170929577 | 10000042 | 30002053 | 60005686 | 18 | 0 | 29 | 1 | 9396 | 24136 | 2009-06-20 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:50:26.97
1140096555 | 10000030 | 30002513 | 60010072 | 18 | 0 | 29.01 | 1 | 53302 | 58233 | 2009-05-27 00:00:00.00 | 90:00:00:00.00 | 32767 | 0 | 2009-07-16 19:38:25.42
1203416787 | 10000042 | 30003441 | 60014803 | 18 | 0 | 30.12 | 1 | 52 | 52 | 2009-07-15 00:00:00.00 | 1:00:00:00.00 | 32767 | 0 | 2009-07-16 19:47:26.00
1203416787 | 10000042 | 30003441 | 60014803 | 18 | 0 | 30.12 | 1 | 52 | 52 | 2009-07-15 00:00:00.00 | 1:00:00:00.00 | 32767 | 0 | 2009-07-16 19:50:26.97