Spreadsheet: 233800d1367933221-take-certain-data-from-invoice-xls-and-show-on-different-sheet-april-2013-wex-invoice-solution
Sheet: UNKNOWN

 | Group | UNKNOWN
 |  | Card Number | Vehicle Card Department | Customer Vehicle ID | Transaction Date | Transaction Time | Unit Cost | Fuel Cost | Net Cost (=)
 | 1 | 0306 - 1 | DIR | 809 | 2013-04-22 00:00:00 | 13:32:34 | 3.26 | 52.67 | 49.71
 | 2 | 0306 - 1 | DIR | 809 | 2013-04-19 00:00:00 | 08:21:43 | 3.4 | 41 | 38.79
 | 3 | 0306 - 1 | DIR | 809 | 2013-04-15 00:00:00 | 14:03:55 | 3.4 | 43.2 | 40.87
 | 4 | 0306 - 1 | DIR | 809 | 2013-04-24 00:00:00 | 15:31:05 | 3.34 | 68.5 | 64.75
 | 5 | 0306 - 1 | DIR | 809 | 2013-04-18 00:00:00 | 11:05:46 | 3.28 | 97.06 | 91.64
 | 6 | 0306 - 1 | DIR | 809 | 2013-04-10 00:00:00 | 07:53:00 | 3.47 | 65 | 61.57
 | 7 | 0304 - 1 | MKT | 807 | 2013-04-11 00:00:00 | 17:02:00 | 3.54 | 84.09 | 79.74
 | 8 | 0304 - 1 | MKT | 807 | 2013-04-22 00:00:00 | 17:26:00 | 3.49 | 84.49 | 80.06
 | 9 | 0304 - 1 | MKT | 807 | 2013-04-29 00:00:00 | 07:44:00 | 3.49 | 79.59 | 75.42
 | 10 | 0303 - 1 | MKT | 806 | 2013-04-10 00:00:00 | 13:50:13 | 3.32 | 44.9 | 42.42
 | 11 | 0303 - 1 | MKT | 806 | 2013-04-09 00:00:00 | 13:34:18 | 3.28 | 60.15 | 56.79
 | 12 | 0303 - 1 | MKT | 806 | 2013-04-08 00:00:00 | 07:23:00 | 3.38 | 41.95 | 39.68
 | 13 | 0303 - 1 | MKT | 806 | 2013-04-29 00:00:00 | 08:37:25 | 3.31 | 38.45 | 36.32
 | 14 | 0303 - 1 | MKT | 806 | 2013-04-04 00:00:00 | 14:15:00 | 3.54 | 63.4 | 60.12
 | 15 | 0303 - 1 | MKT | 806 | 2013-04-18 00:00:00 | 12:29:34 | 3.21 | 38.8 | 36.59
 | 16 | 0303 - 1 | MKT | 806 | 2013-04-17 00:00:00 | 17:50:27 | 3.3 | 43.15 | 40.76
 | 17 | 0303 - 1 | MKT | 806 | 2013-04-16 00:00:00 | 07:35:00 | 3.33 | 23.7 | 22.4
 | 18 | 0303 - 1 | MKT | 806 | 2013-04-15 00:00:00 | 12:16:39 | 3.54 | 39 | 36.98
 | 19 | 0303 - 1 | MKT | 806 | 2013-04-24 00:00:00 | 06:48:54 | 3.49 | 59.1 | 56
 | 20 | 0301 - 1 | MKT | 804 | 2013-04-09 00:00:00 | 17:04:32 | 3.5 | 51.42 | 48.73
 | 21 | 0301 - 1 | MKT | 804 | 2013-04-08 00:00:00 | 17:13:13 | 3.5 | 68.82 | 65.22
 | 22 | 0301 - 1 | MKT | 804 | 2013-04-01 00:00:00 | 18:11:48 | 3.6 | 60.85 | 57.76
 | 23 | 0299 - 1 | FSF | 802 | 2013-04-19 00:00:00 | 10:33:04 | 3.4 | 52.35 | 49.53
 | 24 | 0299 - 1 | FSF | 802 | 2013-04-10 00:00:00 | 10:43:35 | 3.46 | 85.45 | 80.93
 | 25 | 0298 - 1 | PEST | 801 | 2013-04-25 00:00:00 | 18:31:00 | 3.4 | 78.45 | 74.23
 | 26 | 0298 - 1 | PEST | 801 | 2013-04-05 00:00:00 | 13:17:24 | 3.36 | 66.9 | 63.26
 | 27 | 0298 - 1 | PEST | 801 | 2013-04-19 00:00:00 | 08:14:03 | 3.4 | 80.91 | 76.55
 | 28 | 0297 - 1 | ENT | 800 | 2013-04-05 00:00:00 | 14:37:36 | 3.46 | 86.6 | 82.02
 | 29 | 0294 - 1 | APR | 797 | 2013-04-11 00:00:00 | 14:55:00 | 3.48 | 35.8 | 33.92
 | 30 | 0294 - 1 | APR | 797 | 2013-04-09 00:00:00 | 19:37:08 | 3.43 | 38.02 | 35.99
 | 31 | 0294 - 1 | APR | 797 | 2013-04-03 00:00:00 | 14:18:25 | 3.5 | 44.48 | 42.15
 | 32 | 0290 - 1 | ENT | 793 | 2013-04-09 00:00:00 | 14:15:08 | 3.26 | 36.09 | 34.06
 | 33 | 0290 - 1 | ENT | 793 | 2013-04-09 00:00:00 | 10:05:48 | 3.36 | 63.45 | 59.99
 | 34 | 0289 - 1 | APR | 792 | 2013-04-02 00:00:00 | 07:02:31 | 3.46 | 72.68 | 68.83
 | 35 | 0288 - 1 | APR | 791 | 2013-04-17 00:00:00 | 15:56:10 | 3.4 | 87.25 | 82.55
 | 36 | 0287 - 1 | SCS | 790 | 2013-04-03 00:00:00 | 10:50:02 | 3.5 | 81.6 | 77.33
 | 37 | 0287 - 1 | SCS | 790 | 2013-04-29 00:00:00 | 16:58:41 | 3.3 | 51.1 | 48.27
 | 38 | 0285 - 1 | SCS | 796 | 2013-04-10 00:00:00 | 12:27:00 | 3.99 | 53 | 46.98
 | 39 | 0285 - 1 | SCS | 796 | 2013-04-24 00:00:00 | 15:29:15 | 3.9 | 53 | 49.7
 | 40 | 0273 - 1 | DIR | 784 | 2013-04-15 00:00:00 | 09:37:00 | 3.43 | 29.35 | 27.78
 | 41 | 0273 - 1 | DIR | 784 | 2013-04-19 00:00:00 | 11:10:03 | 3.4 | 25.88 | 24.49
 | 42 | 0273 - 1 | DIR | 784 | 2013-04-11 00:00:00 | 11:44:43 | 3.4 | 42.2 | 39.93
 | 43 | 0273 - 1 | DIR | 784 | 2013-04-18 00:00:00 | 15:30:00 | 3.58 | 29.41 | 27.91
 | 44 | 0273 - 1 | DIR | 784 | 2013-04-15 00:00:00 | 13:12:23 | 3.4 | 19.55 | 18.5
 | 45 | 0273 - 1 | DIR | 784 | 2013-04-29 00:00:00 | 14:04:08 | 3.3 | 19.42 | 18.34
 | 46 | 0273 - 1 | DIR | 784 | 2013-04-25 00:00:00 | 08:21:28 | 3.4 | 26.6 | 25.17
 | 47 | 0273 - 1 | DIR | 784 | 2013-04-22 00:00:00 | 05:56:04 | 3.24 | 26.8 | 25.29
 | 48 | 0273 - 1 | DIR | 784 | 2013-04-22 00:00:00 | 12:08:00 | 3.33 | 25.42 | 24.02
 | 49 | 0273 - 1 | DIR | 784 | 2013-04-24 00:00:00 | 06:33:00 | 3.36 | 19.26 | 18.21
 | 50 | 0272 - 1 | DIR | 783 | 2013-04-15 00:00:00 | 09:45:51 | 3.2 | 30.2 | 28.47
 | 51 | 0272 - 1 | DIR | 783 | 2013-04-28 00:00:00 | 12:34:54 | 3.14 | 30.45 | 28.68
 | 52 | 0272 - 1 | DIR | 783 | 2013-04-26 00:00:00 | 06:29:34 | 3.25 | 30.15 | 28.45
 | 53 | 0272 - 1 | DIR | 783 | 2013-04-15 00:00:00 | 16:46:13 | 3.29 | 32.65 | 30.83
 | 54 | 0272 - 1 | DIR | 783 | 2013-04-12 00:00:00 | 08:20:59 | 3.29 | 43.45 | 41.03
 | 55 | 0270 - 1 | FSF | 781 | 2013-04-16 00:00:00 | 14:17:31 | 3.6 | 70.08 | 66.52
 | 56 | 0270 - 1 | FSF | 781 | 2013-04-25 00:00:00 | 12:09:00 | 3.09 | 63.18 | 59.44
 | 57 | 0269 - 1 | PEST | 780 | 2013-04-08 00:00:00 | 09:03:50 | 3.5 | 76.48 | 72.48
 | 58 | 0269 - 1 | PEST | 780 | 2013-04-12 00:00:00 | 15:19:58 | 3.86 | 77.34 | 73.67
 | 59 | 0269 - 1 | PEST | 780 | 2013-04-16 00:00:00 | 16:42:32 | 3.36 | 72.53 | 68.58
 | 60 | 0269 - 1 | PEST | 780 | 2013-04-12 00:00:00 | 09:10:00 | 3.25 | 53.7 | 50.68
 | 61 | 0269 - 1 | PEST | 780 | 2013-04-26 00:00:00 | 08:21:21 | 3.4 | 70.77 | 66.96
 | 62 | 0268 - 1 | PEST | 779 | 2013-04-17 00:00:00 | 09:19:00 | 3.16 | 48.53 | 45.72
 | 63 | 0268 - 1 | PEST | 779 | 2013-04-26 00:00:00 | 12:38:13 | 3.38 | 75.84 | 71.73
 | 64 | 0268 - 1 | PEST | 779 | 2013-04-22 00:00:00 | 06:47:03 | 3.44 | 72.07 | 68.23
 | 65 | 0268 - 1 | PEST | 779 | 2013-04-24 00:00:00 | 10:54:00 | 3.4 | 72.8 | 68.88
 | 66 | 0268 - 1 | PEST | 779 | 2013-04-15 00:00:00 | 11:18:00 | 3.2 | 68.2 | 64.3
 | 67 | 0268 - 1 | PEST | 779 | 2013-04-03 00:00:00 | 08:44:00 | 3.6 | 37.48 | 35.57
 | 68 | 0268 - 1 | PEST | 779 | 2013-04-30 00:00:00 | 12:14:38 | 3.2 | 57.28 | 54
 | 69 | 0268 - 1 | PEST | 779 | 2013-04-03 00:00:00 | 13:03:51 | 3.7 | 75.34 | 71.61
 | 70 | 0266 - 1 | DAIRY | 777 | 2013-04-09 00:00:00 | 17:56:02 | 3.33 | 71.34 | 67.42
 | 71 | 0266 - 1 | DAIRY | 777 | 2013-04-02 00:00:00 | 19:14:01 | 3.39 | 51.77 | 48.97
 | 72 | 0266 - 1 | DAIRY | 777 | 2013-04-01 00:00:00 | 08:50:38 | 3.5 | 72.96 | 69.14
 | 73 | 0265 - 1 | DIR | 776 | 2013-04-29 00:00:00 | 15:48:40 | 3.3 | 37.43 | 35.35
 | 74 | 0265 - 1 | DIR | 776 | 2013-04-01 00:00:00 | 15:06:57 | 3.5 | 25.02 | 23.71
 | 75 | 0265 - 1 | DIR | 776 | 2013-04-15 00:00:00 | 17:29:43 | 3.5 | 52.68 | 49.92
 | 76 | 0265 - 1 | DIR | 776 | 2013-04-25 00:00:00 | 08:29:00 | 3.33 | 34.81 | 32.9
 | 77 | 0265 - 1 | DIR | 776 | 2013-04-22 00:00:00 | 16:05:40 | 3.26 | 34.12 | 32.2
 | 78 | 0264 - 1 | DIR | 775 | 2013-04-29 00:00:00 | 13:14:42 | 3.3 | 25.91 | 24.47
 | 79 | 0264 - 1 | DIR | 775 | 2013-04-10 00:00:00 | 15:21:00 | 3.38 | 30.8 | 29.13
 | 80 | 0264 - 1 | DIR | 775 | 2013-04-24 00:00:00 | 14:59:00 | 3.22 | 30.02 | 28.31
 | 81 | 0264 - 1 | DIR | 775 | 2013-04-22 00:00:00 | 15:44:08 | 3.26 | 46.17 | 43.58
 | 82 | 0264 - 1 | DIR | 775 | 2013-04-12 00:00:00 | 12:03:00 | 3.45 | 33.05 | 31.3
 | 83 | 0263 - 1 | MKT | 774 | 2013-04-01 00:00:00 | 15:18:00 | 3.6 | 77.01 | 73.1
 | 84 | 0263 - 1 | MKT | 774 | 2013-04-23 00:00:00 | 12:42:00 | 3.28 | 82.01 | 77.43
 | 85 | 0263 - 1 | MKT | 774 | 2013-04-03 00:00:00 | 10:14:36 | 3.42 | 80 | 75.72
 | 86 | 0259 - 1 | FSF | 770 | 2013-04-29 00:00:00 | 10:46:00 | 3.44 | 63.1 | 59.74
 | 87 | 0259 - 1 | FSF | 770 | 2013-04-10 00:00:00 | 10:59:56 | 3.3 | 75.1 | 70.93
 | 88 | 0259 - 1 | FSF | 770 | 2013-04-04 00:00:00 | 12:53:45 | 3.34 | 64.35 | 60.82
 | 89 | 0259 - 1 | FSF | 770 | 2013-04-02 00:00:00 | 09:24:14 | 3.4 | 46 | 43.52
 | 90 | 0259 - 1 | FSF | 770 | 2013-04-17 00:00:00 | 16:13:00 | 3.44 | 73 | 69.12
 | 91 | 0259 - 1 | FSF | 770 | 2013-04-23 00:00:00 | 15:33:00 | 3.44 | 68.05 | 64.43
 | 92 | 0257 - 1 | DAIRY | 768 | 2013-04-30 00:00:00 | 12:41:35 | 3.3 | 74.47 | 70.34
 | 93 | 0257 - 1 | DAIRY | 768 | 2013-04-11 00:00:00 | 11:53:06 | 3.4 | 64.81 | 61.32
 | 94 | 0257 - 1 | DAIRY | 768 | 2013-04-01 00:00:00 | 10:48:47 | 3.5 | 71.24 | 67.51
 | 95 | 0257 - 1 | DAIRY | 768 | 2013-04-27 00:00:00 | 09:01:28 | 3.3 | 80.35 | 75.89
 | 96 | 0257 - 1 | DAIRY | 768 | 2013-04-05 00:00:00 | 10:28:28 | 3.6 | 84.78 | 80.47
 | 97 | 0257 - 1 | DAIRY | 768 | 2013-04-17 00:00:00 | 11:46:02 | 3.28 | 64.01 | 60.44
 | 98 | 0252 - 1 | APR | 759 | 2013-04-25 00:00:00 | 18:21:00 | 3.36 | 60.76 | 57.45
 | 99 | 0252 - 1 | APR | 759 | 2013-04-16 00:00:00 | 20:20:11 | 3.28 | 48.52 | 45.81
 | 100 | 0252 - 1 | APR | 759 | 2013-04-15 00:00:00 | 19:31:09 | 3.29 | 44.81 | 42.32