Spreadsheet: 41472d1239948240-creating-an-automatic-report-from-multiple-filtered-fields-from-multiple-worksheets-excel-forum-spreadsheet
Sheet: department xyz

Travel Booker's Initals | Travel reference No. | Surname | Given name | Type of Travel | Travel From Date | Travel to Date | Details | Job Number | Activity Code | Value on itinerary | Invoiced Value | Invoice Number | Difference in $
JS PS | 374 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 90190B | 802 | 106.23 | 106.23 | IINVC2018 | 0
 |  |  |  | Car Hire | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 90190B | 802 | 140.24 | 165.09 | IINVC2019 | 24.85
JS PS | 375 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 90190B | 802 | 108.18 | 121.68 | IINVC2064 | 13.5
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 90190B | 802 | 92.6 | 92.59 | IINVC2062 | -0.009999999999990905
 |  |  |  | Car Hire | 2009-03-03 00:00:00 | 2009-03-04 00:00:00 |  | 90190B | 802 | 96.66 | 384.66 | IINVC2063 | 288
JS PS | 376 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 90190B | 802 | 108.18 | 121.68 | IINVC2066 | 13.5
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 90190B | 802 | 92.6 | 92.59 | IINVC2065 | -0.009999999999990905
JS PS | 377 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 90190B | 802 | 326.23 | 339.73 | IINVC2035 | 13.5
JS PS | 378 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 90190B | 802 | 108.18 | 121.68 | IINVC2068 | 13.5
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 90190B | 802 | 92.6 | 92.59 | IINVC2067 | -0.009999999999990905
 |  |  |  | Car Hire | 2009-03-03 00:00:00 | 2009-03-04 00:00:00 |  | 90190B | 802 | 96.66 | 405 | IINVC2688 | 308.34
JS PS | 379 |  |  | Flight | 2009-03-03 00:00:00 |  |  | 90190B | 802 | 108.18 | 121.68 | IINVC2070 | 13.5
 |  |  |  | Flight | 2009-03-14 00:00:00 |  |  | 90190B | 802 | 92.6 | 92.59 | IINVC2069 | -0.009999999999990905
 |  |  |  | Flight | 2009-03-14 00:00:00 |  |  | 90190B | 803 | 92.59 | 92.59 | IINVC2679 | 0
JS PS | 380 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-14 00:00:00 |  | 90190B | 802 | 185.32 | 198.82 | IINVC2002 | 13.5
 |  |  |  | Car Hire | 2009-03-03 00:00:00 | 2009-03-04 00:00:00 |  | 90190B | 802 | 96.66 | 395.72 | IINVC2003 | 299.06
JS PS | 381 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 90190B | 802 | 185.32 | 198.82 | IINVC2039 | 13.5
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 90190B | 802 | 316.96 | 330.46 | IINVC2037 | 13.5
 |  |  |  | Car Hire | 2009-03-03 00:00:00 | 2009-03-04 00:00:00 |  | 90190B | 802 | 96.66 | 248.04 | IINVC2038 | 151.38
JS PS | 382 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 90190B | 802 | 188.05 | 188.04 | IINVC2023 | -0.01000000000001933
 |  |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-14 00:00:00 |  | 90190B | 802 | 194.41 | 207.91 | IINVC2025 | 13.5
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 90190B | 802 | 138.05 | 138.04 | IINVC2024 | -0.01000000000001933
JS PS | 383 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 405.18 | 405.18 | IINVC2009 | 0
 |  |  |  | Car Hire | 2009-03-13 00:00:00 | 2009-03-14 00:00:00 |  | 90190B | 802 | 96.66 | 386.04 | IINVC2010 | 289.38
JS PS | 384 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 405.18 | 405.18 | IINVC2011 | 0
JS PS | 385 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 90190B | 802 | 179.86 | 179.86 | IINVC2073 | 0
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 154.42 | 154.42 | IINVC2071 | 0
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 94.41 | 94.41 | IINVC2074 | 0
JS PS | 386 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 90190B | 802 | 106.23 | 106.23 | IINVC2054 | 0
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 94.41 | 94.41 | IINVC2055 | 0
 |  |  |  | Car Hire | 2009-03-13 00:00:00 | 2009-03-14 00:00:00 |  | 90190B | 802 | 96.66 | 278 | JINVC0069 | 181.34
JS PS | 387 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 212.45 | 212.45 | IINVC2012 | 0
JS PS | 388 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 212.45 | 212.45 | IINVC2013 | 0
 |  |  |  | Car Hire | 2009-03-13 00:00:00 | 2009-03-14 00:00:00 |  | 90190B | 802 | 96.66 | 365.43 | IINVC2014 | 268.77
JS PS | 389 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 212.45 | 212.45 | IINVC2015 | 0
JS PS | 390 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 212.45 | 212.45 | IINVC2016 | 0
JS PS | 391 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 90190B | 802 | 106.23 | 106.23 | IINVC1955 | 0
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 94.41 | 94.41 | IINVC1958 | 0
 |  |  |  | Car Hire | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 90190B | 802 | 160 |  |  | -160
 |  |  |  | Car Hire | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 90190B | 802 | 140.24 | 164.87 | IINVC1957 | 24.63
 |  |  |  | Flight |  |  |  | 90190B | 802 | 40.91 | 40.91 | IINVC2020 | 0
JS PS | 392 |  |  | Car Hire | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 27026/90195 | 802 | 144.54 | 175.73 | IINVC2007 | 31.19
JS PS | 393 |  |  | Car Hire | 2009-03-02 00:00:00 | 2009-03-03 00:00:00 |  | 27026/90195 | 802 | 71.76 | 66.6 | IINVC2008 | -5.160000000000011
JS PS | 394 |  |  | accommodation | 2009-03-01 00:00:00 | 2009-03-02 00:00:00 |  | 27PR | 6165 | 101.36 | 159.23 | IINVC2049 | 57.87
 |  |  |  | accommodation | 2009-03-02 00:00:00 | 2009-03-09 00:00:00 |  | 27PR | 6165 | 382.5 | 563.82 | IINVC2050 | 181.32
 |  |  |  | accommodation | 2009-03-09 00:00:00 | 2009-03-10 00:00:00 |  | 27PR | 6165 | 159.55 |  |  | -159.55
JS PS | 395 |  |  | accommodation | 2009-03-01 00:00:00 | 2009-03-02 00:00:00 |  | 27PR | 6165 | 101.36 | 119.27 | IINVC2046 | 17.91
 |  |  |  | accommodation | 2009-03-02 00:00:00 | 2009-03-09 00:00:00 |  | 27PR | 6165 | 382.5 | 563.82 | IINVC2050 | 181.32
 |  |  |  | accommodation | 2009-03-09 00:00:00 | 2009-03-11 00:00:00 |  | 27PR | 6165 | 304.1 | 330 | IINVC2048 | 25.9
JS PS | 396 |  |  | accommodation | 2009-03-01 00:00:00 | 2009-03-02 00:00:00 |  | 27PR | 6165 | 101.36 | 151.5 | IINVC2044 | 50.14
 |  |  |  | accommodation | 2009-03-02 00:00:00 | 2009-03-08 00:00:00 |  | 27PR | 6165 | 585 | 905.14 | IINVC2045 | 320.14
JS PS | 397 |  |  | Car Hire | 2009-03-03 00:00:00 | 2009-03-04 00:00:00 |  | 91006B | 802 | 96.66 | 322.34 | IINVC2076 | 225.68
 |  |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 91006B | 802 | 115.32 | 115.32 | IINVC2077 | 0
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 258.05 | 258.05 | IINVC2075 | 0
JS PS | 398 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 91006B | 802 | 115.32 | 115.32 | IINVC2079 | 0
 |  |  |  | Flight | 2009-03-12 00:00:00 | 2009-03-12 00:00:00 |  | 91006B | 802 | 310.77 | 310.77 | IINVC2078 | 0
JS PS | 399 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-14 00:00:00 |  | 91006B | 802 | 248.82 | 248.82 | IINVC2021 | 0
JS PS | 400 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 91006B | 802 | 130.77 | 130.77 | IINVC2111 | 0
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 91006B | 802 | 422.18 | 422.18 | IINVC2109 | 0
JS PS | 401 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 91006B | 802 | 121.68 | 121.68 | IINVC2059 | 0
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 91006B | 802 | 115.32 | 115.32 | IINVC2056 | 0
 |  |  |  | Car Hire | 2009-03-03 00:00:00 | 2009-03-04 00:00:00 |  | 91006B | 802 | 96.66 | 334.88 | IINVC2162 | 238.22
JS PS | 402 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 91006B | 802 | 121.68 | 121.68 | IINVC2060 | 0
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 91006B | 802 | 115.32 | 115.32 | IINVC2057 | 0
JS PS | 403 |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 91006B | 802 | 121.8 | 121.68 | IINVC2061 | -0.1199999999999903
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 91006B | 802 | 115.32 | 115.32 | IINVC2058 | 0
JS PS | 404 |  |  | Car Hire | 2009-03-13 00:00:00 | 2009-03-14 00:00:00 |  | 91006B | 802 | 96.66 | 325.49 | IINVC2095 | 228.83
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 130.77 | 130.77 | IIMVC2096 | 0
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 106.23 | 106.23 | IIMVC2094 | 0
JS PS | 405 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 91006B | 802 | 106.23 | 106.23 | IINVC2085 | 0
 |  |  |  | Flight | 2009-03-11 00:00:00 | 2009-03-11 00:00:00 |  | 91006B | 802 | 142.59 | 142.59 | IINVC2084 | 0
JS PS | 406 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 212.45 | 212.45 | IINVC2027 | 0
JS PS | 407 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 221.55 | 221.55 | IINVC2028 | 0
 |  |  |  | Car Hire | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 91006B | 802 | 214.19 |  |  | -214.19
 |  |  |  | Car Hire | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 277.8 |  |  | -277.8
JS PS | 408 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 91006B | 802 | 115.32 | 115.32 | IINVC2089 | 0
 |  |  |  | Flight | 2009-03-11 00:00:00 | 2009-03-11 00:00:00 |  | 91006B | 802 | 142.59 | 142.59 | IINVC2088 | 0
JS PS | 409 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 91006B | 802 | 115.32 | 115.32 | IINVC2092 | 0
 |  |  |  | Car Hire | 2009-03-13 00:00:00 | 2009-03-14 00:00:00 |  | 91006B | 802 | 96.66 | 252.23 | IINVC2091 | 155.57
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 307.91 | 307.91 | IINVC2090 | 0
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 94.41 | 94.41 | IINVC2093 | 0
JS PS | 410 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 91006B | 802 | 115.32 | 115.32 | IINVC2105 | 0
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 94.41 | 94.42 | IINVC2120 | 0.01000000000000512
JS PS | 411 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 91006B | 802 | 115.32 | 115.32 | IINVC2117 | 0
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 94.41 | 94.43 | IINVC2121 | 0.02000000000001023
JS PS | 412 |  |  | Flight | 2009-03-04 00:00:00 | 2009-03-04 00:00:00 |  | 91006B | 802 | 115.32 | 115.32 | IINVC2118 | 0
 |  |  |  | Flight | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | 91006B | 802 | 94.41 | 94.41 | IINVC2122 | 0
JS PS | 413 |  |  | Car Hire | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 91006B | 802 | 221.48 | 221.48 | IINVC2098 | 0
 |  |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-03 00:00:00 |  | 91006B | 802 | 130.77 | 130.77 | IINVC2100 | 0
 |  |  |  | Car Hire | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 91006B | 802 | 258.43 | 296.12 | IINVC2099 | 37.69
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 91006B | 802 | 133.5 | 133.5 | IINVC2097 | 0
JS PS | 414 |  |  | Car Hire | 2009-03-03 00:00:00 | 2009-03-04 00:00:00 |  | 27026/90195 | 802 | 147.79 | 147.28 | IINVC2172 | -0.5099999999999909
 |  |  |  | accommodation | 2009-03-03 00:00:00 | 2009-03-04 00:00:00 |  | 27026/90195 | 802 | 177.73 |  |  | -177.73
 |  |  |  | Flight | 2009-03-03 00:00:00 | 2009-03-04 00:00:00 |  | 27026/90195 | 802 | 317.91 | 317.91 | IINVC2170 | 0
JL PS | 415 |  |  | accommodation | 2009-03-04 00:00:00 | 2009-03-05 00:00:00 |  | 91006B | 805 | 228.18 | 228.18 | IINVC2649 | 0
JS PS | 416 |  |  | Flight | 2009-03-08 00:00:00 | 2009-03-08 00:00:00 |  | 91006B | 802 | 534.42 | 534.41 | IINVC2345 | -0.009999999999990905
JS PS | 417 |  |  | Flight | 2009-08-08 00:00:00 | 2009-03-08 00:00:00 |  | 91006B | 802 | 227.15 | 227.14 | IINVC2346 | -0.01000000000001933
JL PS | 418 |  |  | Flight | 2009-03-05 00:00:00 | 2009-03-06 00:00:00 |  | 27PR | 6220 | PAID BY CREDIT |  |  | #N/A
 |  |  |  | Car Hire | 2009-03-05 00:00:00 | 2009-03-05 00:00:00 |  | 27PR | 6220 | 92.35 | 108.34 | IINVC2351 | 15.99
 |  |  |  | Car Hire | 2009-03-05 00:00:00 | 2009-03-06 00:00:00 |  | 27PR | 6220 | 96.66 | 253.19 | IINVC2352 | 156.53
 |  |  |  | Accommodation | 2009-03-05 00:00:00 | 2009-03-06 00:00:00 |  | 27PR | 6220 | 155.91 | 212 | IINVC2350 | 56.09
JL PS | 419 |  |  | Flight | 2009-03-05 00:00:00 | 2009-03-05 00:00:00 |  | 27PR | 6220 | PAID BY CREDIT |  |  | #N/A
 |  |  |  | Car Hire | 2009-03-05 00:00:00 | 2009-06-04 00:00:00 |  | 27PR | 6220 | 6314 |  |  | -6314
 |  |  |  | Accommodation | 2009-03-05 00:00:00 | 2009-03-06 00:00:00 |  | 27PR | 6220 | 155.91 | 212 | IINVC2385 | 56.09
JS PS | 420 |  |  | Flight | 2009-03-06 00:00:00 | 2009-03-08 00:00:00 |  | 27150/814 | 802 | 367 | 367 | IINVC2481 | 0
 |  |  |  | Car Hire | 2009-03-06 00:00:00 | 2009-03-08 00:00:00 |  | 27150/814 | 802 | 260.61 | 194.9 | IINVC2482 | -65.71
JS PS | 421 |  |  | Flight | 2009-03-09 00:00:00 | 2009-03-11 00:00:00 |  | 27PR | 6220 | 964.9 | 964.91 | IINVC2459 | 0.009999999999990905
 |  |  |  | Flight | 2009-03-11 00:00:00 | 2009-03-11 00:00:00 |  | 27PR | 6220 | PAID BY CREDIT |  |  | #N/A
 |  |  |  | Car Hire | 2009-03-09 00:00:00 | 2009-03-11 00:00:00 |  | 27PR | 6220 | 190.12 | 197.33 | IINVC2453 | 7.210000000000008
 |  |  |  | accommodation | 2009-03-09 00:00:00 | 2009-03-11 00:00:00 |  | 27PR | 6220 | 262.27 |  |  | -262.27
JS PS | 422 |  |  | Flight | 2009-03-10 00:00:00 | 2009-03-23 00:00:00 |  | 27026/90195 | 802 | 370.64 | 370.64 | IINVC2456 | 0
 |  |  |  | accommodation | 2009-03-23 00:00:00 | 2009-03-24 00:00:00 |  | 27026/90195 | 805 | 130.91 |  |  | -130.91
JS PS | 423 |  |  | Flight | 2009-03-12 00:00:00 | 2009-03-15 00:00:00 |  | 27PR | 6220 | 382.73 | 382.72 | IINVC2718 | -0.009999999999990905
 |  |  |  | Car Hire | 2009-03-12 00:00:00 | 2009-03-15 00:00:00 |  | 27PR | 6220 | 532.59 | 534.15 | IINVC2720 | 1.559999999999945
 |  |  |  | accommodation | 2009-03-12 00:00:00 | 2009-03-15 00:00:00 |  | 27PR | 6220 | 465 |  |  | -465
JS PS | 424 |  |  | Flight | 2009-03-09 00:00:00 |  |  | 27PR | 6220 | 147.14 | 147.14 | IINVC2866 | 0
 |  |  |  | Flight | 2009-03-23 00:00:00 |  |  | 27PR | 6220 | 130.77 | 130.77 | IINVC2869 | 0
 |  |  |  | Car Hire | 2009-03-09 00:00:00 | 2009-03-23 00:00:00 |  | 27PR | 6220 | 865.83 | 815.08 | IINVC2868 | -50.75
 |  |  |  | accommodation | 2009-03-09 00:00:00 | 2009-03-12 00:00:00 |  | 27PR | 6220 | 301.36 | 327 | IINVC2867 | 25.64
 |  |  |  | accommodation | 2009-03-12 00:00:00 | 2009-03-23 00:00:00 |  | 27PR | 6220 | 1214.99 |  |  | -1214.99
JS PS | 425 |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 27026/90195 | 802 | 107.14 | 107.14 | IINVC2717 | 0
 |  |  |  | Flight | 2009-03-15 00:00:00 | 2009-03-28 00:00:00 |  | 27026/90195 | 802 | 397.64 | 397.64 | IINVC2712 | 0
 |  |  |  |  |  |  |  | 27026/90195 | 802 | 190 | 190 | IINVC3583 | 0
 |  |  |  | Car Hire | 2009-03-14 00:00:00 | 2009-03-15 00:00:00 |  | 27026/90195 | 802 | 791.4 | 303.57 | IINVC2715 | -487.83
 |  |  |  | Car Hire | 2009-03-15 00:00:00 | 2009-03-28 00:00:00 |  | 27026/90195 | 802 | 1192.28 |  |  | -1192.28
 |  |  |  | accommodation | 2009-03-14 00:00:00 | 2009-03-19 00:00:00 |  | 27026/90195 | 805 | 765 |  |  | -765
 |  |  |  | accommodation | 2009-03-19 00:00:00 | 2009-03-20 00:00:00 |  | 27026/90195 | 805 | 100.91 |  |  | -100.91
JS PS | 426 |  |  | Flight | 2009-03-14 00:00:00 |  |  | 27PR | 6220 | 103.5 | 103.5 | IINVC2861 | 0
JS PS | 427 |  |  | Car Hire | 2009-03-06 00:00:00 | 2009-03-27 00:00:00 |  | 27152/744 | 6220 | 2270.82 |  |  | -2270.82
JS PS | 428 |  |  | Flight | 2009-03-17 00:00:00 | 2009-03-20 00:00:00 |  | 27PR | 6753 | 249.73 | 249.72 | JINVC1139 | -0.009999999999990905
 |  |  |  | Car Hire | 2009-03-17 00:00:00 | 2009-03-20 00:00:00 |  | 27PR | 6753 | 165 | 269.13 | IINVC2879 | 104.13
 |  |  |  | accommodation | 2009-03-17 00:00:00 | 2009-03-20 00:00:00 |  | 27PR | 6753 | 407.73 | 574.64 | IINVC2878 | 166.91
JS PS | 429 |  |  | Flight | 2009-03-09 00:00:00 |  |  | 90190B | 802 | 372.59 | 372.59 | IINVC2692 | 0
 |  |  |  | Car Hire | 2009-03-09 00:00:00 | 2009-03-15 00:00:00 |  | 90190B | 802 | 689.03 | 812.55 | IINVC2693 | 123.52
JS PS | 430 |  |  | accommodation | 2009-03-09 00:00:00 | 2009-03-11 00:00:00 |  | 27PE | 6220 | 187.73 | 101.63 | IINVC3646 | -86.1
JS PS | 431 |  |  | Flight | 2009-03-10 00:00:00 | 2009-03-11 00:00:00 |  | 27026/90195 | 802 | 337.92 | 337.92 | IINVC2915 | 0
 |  |  |  | Car Hire | 2009-03-10 00:00:00 | 2009-03-11 00:00:00 |  | 27026/90195 | 802 | 147.79 | 158.74 | IINVC2917 | 10.95
 |  |  |  | accommodation | 2009-03-10 00:00:00 | 2009-03-11 00:00:00 |  | 27026/90195 | 805 | 174.09 | 192.27 | IINVC2916 | 18.18
JL PS | 432 |  |  | Flight | 2009-03-11 00:00:00 |  |  | 27026/90195 | 802 | 461.42 | 461.42 | IINVC3076 | 0
 |  |  |  | Flight | 2009-03-11 00:00:00 |  |  | 27026/90195 | 802 | 461.42 | 461.42 | IINVC3077 | 0
JL PS | 433 |  |  | accommodation | 2009-03-11 00:00:00 | 2009-03-13 00:00:00 |  | 27PR | 6517 | 260.45 |  |  | -260.45
 |  |  |  | accommodation | 2009-03-11 00:00:00 | 2009-03-13 00:00:00 |  | 27PR | 6517 | 260.45 | 303.27 | IINVC3196 | 42.82
JS PS | 434 |  |  | Car Hire | 2009-03-13 00:00:00 | 2003-03-14 00:00:00 |  | 27150/814 | 802 | 210.72 | 222.17 | IINVC3165 | 11.45
 |  |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-14 00:00:00 |  | 27150/814 | 802 | 200.77 | 200.77 | IINVC3164 | 0
JS PS | 435 |  |  | Flight | 2009-03-14 00:00:00 | 2009-03-23 00:00:00 |  | 27150/814 | 802 | 277 | 277 | IINVC3161 | 0
 |  |  |  | Car Hire | 2009-03-23 00:00:00 | 2009-03-23 00:00:00 |  | 27150/814 | 802 | 227.83 |  |  | -227.83
 |  |  |  | Flight | 2009-03-23 00:00:00 | 2009-03-23 00:00:00 |  | 27150/814 | 802 | 185.45 |  |  | -185.45
JS PS | 436 |  |  | Car Hire | 2009-03-11 00:00:00 | 2009-03-18 00:00:00 |  | 27PR | 6220 | 856.58 | 647.02 | IINVC3195 | -209.56
 |  |  |  | accommodation | 2009-03-11 00:00:00 | 2009-03-13 00:00:00 |  | 27PR | 6220 | 145.91 | 234.55 | IINVC3193 | 88.64
 |  |  |  | Accommodation | 2009-03-13 00:00:00 | 2009-03-18 00:00:00 |  | 27PR | 6220 | 565 | 597.91 | IINVC3194 | 32.91
JS PS | 437 |  |  | Flight | 2009-03-23 00:00:00 | 2009-03-27 00:00:00 |  | DRS012 | 8336 | 443.36 | 443.36 | IINVC3642 | 0
 |  |  |  | Flight | 2009-03-23 00:00:00 | 2009-03-27 00:00:00 |  | DRS012 | 8336 | 443.36 | 443.36 | IINVC3637 | 0
 |  |  |  | Car Hire | 2009-03-23 00:00:00 | 2009-03-27 00:00:00 |  | DRS012 | 8336 | 339.59 | 401.55 |  | 61.96
 |  |  |  | Accommodation | 2009-03-23 00:00:00 | 2009-03-27 00:00:00 |  | DRS012 | 8337 | 702.27 |  |  | -702.27
 |  |  |  | Accommodation | 2009-03-23 00:00:00 | 2009-03-27 00:00:00 |  | DRS012 | 8337 | 702.27 |  |  | -702.27
JL PS | 438 |  |  | Car Hire | 2009-03-16 00:00:00 | 2009-03-17 00:00:00 |  | 27026/90195 | 802 | 140.24 | 136.1 | IINVC3170 | -4.140000000000015
JL PS | 439 |  |  | Car Hire | 2009-03-16 00:00:00 | 2009-03-17 00:00:00 |  | 27026/90195 | 802 | 73.47 | 248.47 | IINVC3443 | 175
JS PS | 440 |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 103.5 | 103.5 | IINVC3442 | 0
 |  |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 167.15 | 167.15 | IINVC3441 | 0
 |  |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 103.5 | 103.5 | IINVC3426 | 0
 |  |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 167.15 | 167.15 | IINVC3425 | 0
JS PS | 441 |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 103.5 | 103.5 | IINVC3417 | 0
 |  |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 94.41 | 94.41 | IINVC3148 | 0
JS PS | 442 |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 103.5 | 103.5 | IINVC3419 | 0
JS PS | 443 |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 103.5 | 103.5 | IINVC3420 | 0
JS PS | 444 |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 103.5 | 103.5 | IINVC3421 | 0
JS PS | 445 |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 103.5 | 103.5 | IINVC3422 | 0
JS PS | 446 |  |  | Flight | 2009-03-24 00:00:00 |  |  | 90190B | 802 | 103.5 | 103.5 | IINVC3423 | 0
JS PS | 447 |  |  | accommodation | 2009-03-17 00:00:00 | 2009-03-20 00:00:00 |  | 27PR | 6517 | 287.73 | 397.77 | JINVC0853 | 110.04
JS PS | 448 |  |  | accommodation | 2009-03-18 00:00:00 | 2009-03-20 00:00:00 |  | 27PR | 6517 |  |  |  | 0
JL PS | 449 |  |  | Flight | 2009-03-15 00:00:00 | 2009-03-15 00:00:00 |  | 90199B | 802 | 294.41 | 294.41 | IINVC3613 | 0
JL PS | 450 |  |  | Flight | 2009-03-17 00:00:00 | 2009-03-17 00:00:00 |  | 90199B | 802 | 103.5 | 103.5 | IINVC3614 | 0
 |  |  |  | Flight | 2009-03-17 00:00:00 | 2009-03-17 00:00:00 |  | 90199B | 802 | 103.5 | 103.5 | IINVC3615 | 0
JL PS | 452 |  |  | Flight | 2009-03-18 00:00:00 |  |  | 90190B | 802 | 312.59 | 312.59 | IINVC3789 | 0
JS PS | 453 |  |  | Flight | 2009-03-17 00:00:00 | 2009-03-20 00:00:00 |  | 27PR | 6220 | 294.27 | 294.27 | IINVC3803 | 0
 |  |  |  | accommodation | 2009-03-17 00:00:00 | 2009-03-20 00:00:00 |  | 27PR | 6220 | 315 |  |  | -315
JS PS | 454 |  |  | Flight | 2009-03-26 00:00:00 | 2009-04-05 00:00:00 |  | 27026/90195 | 802 | 581 | 581 | JINVC0001 | 0
 |  |  |  | Flight | 2009-04-05 00:00:00 | 2009-04-05 00:00:00 |  | 27026/90195 | 802 | 322.56 | 322.56 | JINVC0002 | 0
JS PS | 455 |  |  | Flight | 2009-04-05 00:00:00 |  |  | 27PR | 6517 | 280.75 | 280.74 | JINVC0099 | -0.009999999999990905
 |  |  |  | Flight | 2009-04-05 00:00:00 |  |  | 27PR | 6517 | 178.05 | 178.04 | JINVC0101 | -0.01000000000001933
 |  |  |  | accommodation | 2009-04-05 00:00:00 | 2009-04-10 00:00:00 |  | 27PR | 6517 | 652.5 |  |  | -652.5
 |  |  |  | Car Hire | 2009-04-05 00:00:00 | 2009-04-10 00:00:00 |  | 27PR | 6517 | 401.76 |  |  | -401.76
JS PS | 456 |  |  | Flight | 2009-03-17 00:00:00 | 2009-03-17 00:00:00 |  | 27026/90195 | 802 | 276.78 | 281.46 | IINVC3632 | 4.680000000000007
 |  |  |  | Flight | 2009-03-18 00:00:00 | 2009-03-23 00:00:00 |  | 27026/90195 | 802 | 536.91 | 546.27 | IINVC3634 | 9.360000000000014
 |  |  |  | accommodation | 2009-03-23 00:00:00 | 2009-03-24 00:00:00 |  | 27026/90195 | 805 | 130.91 |  |  | -130.91
JS PS | 457 |  |  | Car Hire | 2009-03-18 00:00:00 | 2009-03-19 00:00:00 |  | 27151/790 | 802 | 111.78 | 251.83 | JINVC0166 | 140.05
JS PS | 458 |  |  | Flight | 2009-03-23 00:00:00 |  |  | 27PR | 6220 | 322.59 |  |  | -322.59
 |  |  |  | Car Hire | 2009-03-23 00:00:00 | 2009-03-25 00:00:00 |  | 27PR | 6220 | 385.96 |  |  | -385.96
 |  |  |  | accommodation | 2009-03-23 00:00:00 | 2009-03-25 00:00:00 |  | 27PR | 6220 | 185 |  |  | -185
 |  |  |  | Flight |  | 2009-03-25 00:00:00 |  | 27PR | 6220 | 164.42 |  |  | -164.42
JS PS | 459 |  |  | Flight | 2009-03-23 00:00:00 | 2009-04-07 00:00:00 |  | 27026/90195 | 802 | 299.73 | 299.73 | [NAME] | 0
 |  |  |  | accommodation | 2009-03-23 00:00:00 | 2009-03-24 00:00:00 |  | 27026/90195 | 805 | 130.91 |  |  | -130.91
JS PS | 460 |  |  | Flight | 2009-03-26 00:00:00 |  |  | 27026/90195 | 802 | 92.59 | 92.59 | [NAME] | 0
 |  |  |  | Flight | 2009-03-26 00:00:00 |  |  | 27026/90195 | 802 | 108.95 | 108.95 | [NAME] | 0
 |  |  |  | accommodation | 2009-03-25 00:00:00 | 2009-03-26 00:00:00 |  | 27026/90195 | 802 | 132.27 |  |  | -132.27
JS PS | 461 |  |  | Car Hire | 2009-03-30 00:00:00 | 2009-03-31 00:00:00 |  | 27026/90195 | 802 | 71.76 |  |  | -71.76
JS PS | 462 |  |  | Car Hire | 2009-03-31 00:00:00 | 2009-03-31 00:00:00 |  | 27026/90195 | 802 | 144.54 |  |  | -144.54
JS PS | 463 |  |  | Flight | 2009-03-31 00:00:00 |  |  | 27026/90195 | 802 | 177.14 | 177.14 | JINVC0289 | 0
JS PS | 464 |  |  | Flight | 2009-03-22 00:00:00 | 2009-03-31 00:00:00 |  | 27PR | 6220 | 216.09 | 216.09 | JINVC0391 | 0
JS PS | 465 |  |  | accommodation | 2009-03-25 00:00:00 | 2009-04-13 00:00:00 |  | 27PR | 6220 | 1345 |  |  | -1345
 |  |  |  | Car Hire | 2009-03-25 00:00:00 | 2009-04-13 00:00:00 |  | 27PR | 6220 | 2194.47 |  |  | -2194.47
JS PS | 466 |  |  | Car Hire | 2009-03-23 00:00:00 | 2009-03-23 00:00:00 |  | 90190B | 802 | 333.49 |  |  | -333.49
JL PS | 467 |  |  | Car Hire | 2009-03-20 00:00:00 | 2009-03-20 00:00:00 |  | 27141/814 | 6220 | 210.72 |  |  | -210.72
 |  |  |  | Flight | 2009-03-20 00:00:00 | 2009-03-20 00:00:00 |  | 27141/814 | 6220 | 225.32 | 235.78 | JINVC0455 | 10.46
JS PS | 468 |  |  | Flight | 2009-03-23 00:00:00 |  |  | 91006B | 802 | 272.59 | 272.59 | JINVC0653 | 0
JS PS | 469 |  |  | Flight | 2009-03-23 00:00:00 |  |  | 91006B | 802 | 94.41 | 94.41 | JINVC0662 | 0
JS PS | 470 |  |  | Flight | 2009-03-23 00:00:00 | 2009-03-25 00:00:00 |  | 27026/90195 | 802 | 590.5 | 577 | JINVC0597 | -13.5
 |  |  |  | Car Hire | 2009-03-23 00:00:00 | 2009-03-25 00:00:00 |  | 27026/90195 | 802 | 285.96 |  |  | -285.96
 |  |  |  | accommodation | 2009-03-23 00:00:00 | 2009-03-25 00:00:00 |  | 27026/90195 | 805 | 215 |  |  | -215
JE PS | 471 |  |  | Flight | 2009-03-23 00:00:00 | 2009-03-23 00:00:00 |  | 27150/814 | 802 | 200.77 | 200.05 | JINVC0600 | -0.7199999999999989
JS PS | 472 |  |  | Flight | 2009-03-31 00:00:00 |  |  | 27PR | 6220 | 74.41 | 74.4 | JINVC0751 | -0.009999999999990905
 |  |  |  | Flight |  | 2009-04-04 00:00:00 |  | 27PR | 6220 | 167.14 | 167.14 | JINVC0753 | 0
 |  |  |  | accommodation | 2009-03-31 00:00:00 | 2009-04-04 00:00:00 |  | 27PR | 6220 | 665.9 |  |  | -665.9
JS PS | 473 |  |  | accommodation | 2009-03-31 00:00:00 | 2009-04-03 00:00:00 |  | 27PR | 6220 | 503.18 |  |  | -503.18