Spreadsheet: 46008d1244788840-find-value-matching-multiple-text-criteria-and-max-date-686614_wemmenh
Sheet: Trx

Destination | Date | Description | Currency | Trx Type | Foreign trx Amount | Real Exchange Rate | Derived Exch. Rate | Actual Native Amount Known | Native trx Amount | Final
01. Kopenhagen Airport | 2009-01-05 00:00:00 | 1 | DKK | Daily Expenses | 54.5 | 0.1368807339449541 | 0.1368807339449541 | yes | 7.46 | 7.459999999999999
02. St. Petersburg | 2009-01-05 00:00:00 | 3 | RUB | Daily Expenses | 432.2 | 0.02602961591855622 | 0.02602961591855622 | yes | 11.25 | 11.25
02. St. Petersburg | 2009-01-05 00:00:00 | 4 | RUB | Withdrawal | 2000 | 0.02604 | 0.02604 | yes | 52.08 | 52.08
02. St. Petersburg | 2009-01-06 00:00:00 | 5 | RUB | Withdrawal | 8000 | 0.025 | 0.025 | yes | 200 | 200
02. St. Petersburg | 2009-01-07 00:00:00 | 6 | RUB | Durables | 2338 | 0.02568006843455945 | 0.02568006843455945 | yes | 60.04 | 60.04
02. St. Petersburg | 2009-01-07 00:00:00 | 7 | RUB | Durables | 5500 |  | 0.02568006843455945 | no | x | 141.240376390077
04. Moscow | 2009-01-08 00:00:00 | 9 | RUB | Withdrawal | 1800 |  | 0.02568006843455945 | no | x | 46.22412318220701
04. Moscow | 2009-01-08 00:00:00 | 10 | RUB | Daily Expenses | 133.5 | 0.02546816479400749 | 0.02546816479400749 | yes | 3.4 | 3.4
04. Moscow | 2009-01-08 00:00:00 | 11 | RUB | Daily Expenses | 278 | 0.02586330935251799 | 0.02586330935251799 | yes | 7.19 | 7.19
04. Moscow | 2009-01-08 00:00:00 | 12 | RUB | Durables | 280 |  | 0.02586330935251799 | no | x | 7.241726618705036
04. Moscow | 2009-01-09 00:00:00 | 13 | RUB | Withdrawal | 4000 | 0.0252475 | 0.0252475 | yes | 100.99 | 100.99
06. Irkutsk/Lake Baikal | 2009-01-10 00:00:00 | 15 | RUB | Withdrawal | 2500 |  | 0.0252475 | no | x | 63.11875
06. Irkutsk/Lake Baikal | 2009-01-13 00:00:00 | 16 | RUB | Withdrawal | 3000 | 0.02467333333333333 | 0.02467333333333333 | yes | 74.02 | 74.02
06. Irkutsk/Lake Baikal | 2009-01-14 00:00:00 | 17 | RUB | Withdrawal | 1500 | 0.02440666666666667 | 0.02440666666666667 | yes | 36.61 | 36.61
06. Irkutsk/Lake Baikal | 2009-01-15 00:00:00 | 18 | RUB | Withdrawal | 4000 | 0.0241425 | 0.0241425 | yes | 96.57 | 96.57
08. Ulaanbaator | 2009-01-18 00:00:00 | 20 | MNT | Withdrawal | 25000 | 0.00076 | 0.00076 | yes | 19 | 19
08. Ulaanbaator | 2009-01-18 00:00:00 | 21 | MNT | Withdrawal | 30000 | 0.0005690000000000001 | 0.0005690000000000001 | yes | 17.07 | 17.07
08. Ulaanbaator | 2009-01-19 00:00:00 | 22 | MNT | Withdrawal | 15000 | 0.0005693333333333333 | 0.0005693333333333333 | yes | 8.54 | 8.54
08. Ulaanbaator | 2009-01-19 00:00:00 | 23 | MNT | Daily Expenses | 21680 | 0.0005738007380073801 | 0.0005738007380073801 | yes | 12.44 | 12.44
08. Ulaanbaator | 2009-01-21 00:00:00 | 24 | MNT | Withdrawal | 40000 | 0.00058525 | 0.00058525 | yes | 23.41 | 23.41
08. Ulaanbaator | 2009-01-21 00:00:00 | 25 | MNT | Daily Expenses | 45203 | 0.0005864655000774286 | 0.0005864655000774286 | yes | 26.51 | 26.51000000000001
10. Beijing | 2009-01-23 00:00:00 | 27 | CNY | Withdrawal | 500 | 0.11518 | 0.11518 | yes | 57.59 | 57.59
10. Beijing | 2009-01-24 00:00:00 | 28 | CNY | Withdrawal | 1000 | 0.11635 | 0.11635 | yes | 116.35 | 116.35
10. Beijing | 2009-01-24 00:00:00 | 29 | CNY | Daily Expenses | 119 | 0.1163025210084034 | 0.1163025210084034 | yes | 13.84 | 13.84
10. Beijing | 2009-01-26 00:00:00 | 30 | CNY | Travel Support | 100 |  | 0.1163025210084034 | no | x | 11.63025210084034
10. Beijing | 2009-01-26 00:00:00 | 31 | CNY | Daily Expenses | 200 | 0.1144 | 0.1144 | yes | 22.88 | 22.88
10. Beijing | 2009-01-26 00:00:00 | 32 | CNY | Withdrawal | 900 | 0.1159888888888889 | 0.1159888888888889 | yes | 104.39 | 104.39
10. Beijing | 2009-01-28 00:00:00 | 33 | CNY | Daily Expenses | 58 | 0.1146551724137931 | 0.1146551724137931 | yes | 6.65 | 6.65
10. Beijing | 2009-01-28 00:00:00 | 34 | CNY | Withdrawal | 900 | 0.1127555555555556 | 0.1127555555555556 | yes | 101.48 | 101.48
10. Beijing | 2009-01-28 00:00:00 | 35 | CNY | Durables | 900 |  | 0.1127555555555556 | no | x | 101.48
10. Beijing | 2009-01-29 00:00:00 | 36 | CNY | Withdrawal | 1500 | 0.11278 | 0.11278 | yes | 169.17 | 169.17
10. Beijing | 2009-01-29 00:00:00 | 37 | CNY | Withdrawal | 1500 | 0.1121066666666667 | 0.1121066666666667 | yes | 168.16 | 168.16
10. Beijing | 2009-01-29 00:00:00 | 38 | CNY | Withdrawal | 1500 | 0.1121066666666667 | 0.1121066666666667 | yes | 168.16 | 168.16
10. Beijing | 2009-01-29 00:00:00 | 39 | CNY | Durables | 3200 |  | 0.1121066666666667 | no | x | 358.7413333333333
10. Beijing | 2009-01-29 00:00:00 | 40 | CNY | Travel Support |  | 0 | 0 | yes | 68.11 | 0
10. Beijing | 2009-01-30 00:00:00 | 41 | CNY | Daily Expenses | 30 | 0.1163333333333333 | 0.1163333333333333 | yes | 3.49 | 3.49
10. Beijing | 2009-02-01 00:00:00 | 42 | CNY | Withdrawal | 900 | 0.1158444444444444 | 0.1158444444444444 | yes | 104.26 | 104.26
10. Beijing | 2009-02-01 00:00:00 | 43 | CNY | Durables | 200 |  | 0.1158444444444444 | no | x | 23.16888888888889
10. Beijing | 2009-02-01 00:00:00 | 44 | CNY | Daily Expenses | 85.9 | 0.1164144353899884 | 0.1164144353899884 | yes | 10 | 10
10. Beijing | 2009-02-01 00:00:00 | 45 | CNY | Withdrawal | 900 | 0.1158444444444444 | 0.1158444444444444 | yes | 104.26 | 104.26
10. Beijing | 2009-02-02 00:00:00 | 46 | CNY | Daily Expenses | 75 | 0.1168 | 0.1168 | yes | 8.76 | 8.76
10. Beijing | 2009-02-03 00:00:00 | 47 | CNY | Withdrawal | 900 | 0.1168222222222222 | 0.1168222222222222 | yes | 105.14 | 105.14
10. Beijing | 2009-02-03 00:00:00 | 48 | CNY | Travel Support | 90 |  | 0.1168222222222222 | no | x | 10.514
10. Beijing | 2009-02-04 00:00:00 | 49 | CNY | Withdrawal | 1500 | 0.1157933333333333 | 0.1157933333333333 | yes | 173.69 | 173.69
10. Beijing | 2009-02-04 00:00:00 | 50 | CNY | Travel Support | 508 |  | 0.1157933333333333 | no | x | 58.82301333333334
10. Beijing | 2009-02-04 00:00:00 | 51 | EUR | Durables | 122.58 | 1 | 1 | yes | 122.58 | 122.58
10. Beijing | 2009-02-04 00:00:00 | 52 | CNY | Transport | 240 |  | 0.1157933333333333 | no | x | 27.7904
10. Beijing | 2009-02-04 00:00:00 | 53 | CNY | Transport | 26 |  | 0.1157933333333333 | no | x | 3.010626666666667
10. Beijing | 2009-02-05 00:00:00 | 54 | CNY | Travel Support | 71 |  | 0.1157933333333333 | no | x | 8.221326666666666