Spreadsheet: 776940d1650011524-un-text-numbers-in-filtered-data-test-filter
Sheet: Contracts

OFFICE | REZ. END | CONTRACT | PLATE NO | PICK UP TIME | DROP OFF TIME | TOLLS | +  %18 | CHARGED | DIFF. | COMMENT | Plate No Change
AAA | 2022-02-01 00:00:00 | 21306823 | 34DZC915 | 2022-01-12 13:51:43 | 2022-01-27 12:14:37 | 0 | 0 | 0 | 0 |  | yes
AAA | 2022-02-01 00:00:00 | 21306823 | 34DZD754 | 2022-01-27 12:14:38 | 2022-02-01 12:49:58 | 0 | 0 | 0 | 0 |  | yes
AAA | 2022-02-07 00:00:00 | 21385850 | 34DZA573 | 2022-01-28 10:08:48 | 2022-02-07 13:06:12 | 94.25 | 111.22 | 111.9 | 0
AAA | 2022-02-10 00:00:00 | 21252973 | 34EAY791 | 2022-01-13 13:39:57 | 2022-01-15 11:50:18 | 13 | 15.34 | 0 | -15.34 |  | yes
AAA | 2022-02-10 00:00:00 | 21252973 | 34EAY849 | 2022-01-15 11:50:19 | 2022-02-14 13:46:52 | 84.5 | 99.71 | 0 | -99.71 |  | yes
AAA | 2022-02-10 00:00:00 | 21407394 | 34EVF674 | 2022-01-31 13:06:17 | 2022-02-09 10:19:14 | 19 | 22.42 | NP | 0 | ZACH
AAA | 2022-02-10 00:00:00 | 21420264 | 34DZE958 | 2022-02-06 11:43:54 | 2022-02-10 15:03:29 | 0 | 0 | 0 | 0
AAA | 2022-02-22 00:00:00 | 21286472 | 34EAY847 | 2022-01-25 16:19:04 | 2022-02-24 16:47:06 | 1038.75 | 1225.73 | 1396.5 | 170.77
BBB | 2022-02-02 00:00:00 | 21375083 | 34DYM974 | 2022-01-30 11:04:17 | 2022-02-02 13:29:47 | 0 | 0 | 0 | 0
BBB | 2022-02-02 00:00:00 | 21387235 | 34BEF674 | 2022-01-31 13:07:04 | 2022-02-02 09:43:07 | 0 | 0 | NP | 0 | REMY
BBB | 2022-02-07 00:00:00 | 21320073 | 34DYN994 | 2022-02-04 15:42:45 | 2022-02-07 15:33:56 | 0 | 0 | 0 | 0
BBB | 2022-02-07 00:00:00 | 21346376 | 34EAY708 | 2022-01-20 09:42:59 | 2022-02-07 09:56:04 | 22 | 25.96 | 25.96 | 0
CCC | 2022-02-02 00:00:00 | 21340955 | 34DZE958 | 2022-01-22 13:17:20 | 2022-02-02 10:59:59 | 0 | 0 | 0 | 0
CCC | 2022-02-02 00:00:00 | 21386309 | 34DZE265 | 2022-01-26 10:58:55 | 2022-02-02 10:22:06 | 5.75 | 6.79 | 0 | -6.79
CCC | 2022-02-03 00:00:00 | 21412720 | 34EAY850 | 2022-02-01 16:39:42 | 2022-02-03 11:57:22 | 14.5 | 17.11 | 35 | 17.89
CCC | 2022-02-03 00:00:00 | 21416078 | 34EVE777 | 2022-02-02 12:11:32 | 2022-02-03 08:58:23 | 0 | 0 | NP | 0 | STAN
CCC | 2022-02-04 00:00:00 | 21412133 | 34EVF647 | 2022-02-03 14:04:45 | 2022-02-04 08:47:40 | 0 | 0 | NP | 0 | STAN
CCC | 2022-02-27 00:00:00 | 21479392 | 34EAY850 | 2022-02-16 07:49:16 | 2022-02-27 06:20:40 | 106.5 | 125.67 | 126 | 0
CCC | 2022-02-27 00:00:00 | 21491230 | 34EVE777 | 2022-02-20 09:39:39 | 2022-02-27 14:03:27 | 0 | 0 | 0 | 0
DDD | 2022-02-01 00:00:00 | 21363068 | 34EAY820 | 2022-01-20 09:12:39 | 2022-02-01 13:35:09 | 335 | 395.3 | 396.48 | 0
DDD | 2022-02-01 00:00:00 | 21378774 | 34CBB394 | 2022-01-24 08:38:33 | 2022-02-01 07:38:32 | 0 | 0 | 0 | 0
DDD | 2022-02-01 00:00:00 | 21399018 | 34DYP055 | 2022-01-29 13:11:40 | 2022-02-01 14:48:04 | 0 | 0 | 0 | 0
DDD | 2022-02-01 00:00:00 | 21400877 | 34DYM071 | 2022-01-30 11:23:32 | 2022-02-01 16:02:04 | 19.5 | 23.01 | 23.01 | 0
DDD | 2022-02-18 00:00:00 | 21456238 | 34DYN110 | 2022-02-12 07:48:59 | 2022-02-19 07:53:52 | 29.5 | 34.81 | 11.8 | -23.01
DDD | 2022-02-19 00:00:00 | 21363276 | 34DZD196 | 2022-02-04 11:14:47 | 2022-02-19 09:52:51 | 797.25 | 940.76 | 940.76 | 0
DDD | 2022-02-20 00:00:00 | 21374125 | 34DZD310 | 2022-01-23 11:27:49 | 2022-02-20 13:01:34 | 0 | 0 | 0 | 0
EEE | 2022-02-01 00:00:00 | 21308722 | 34DZD645 | 2022-01-06 14:21:04 | 2022-02-02 15:09:24 | 211.25 | 249.28 | 266 | 16.72
EEE | 2022-02-01 00:00:00 | 21311591 | 34EVF059 | 2022-01-23 18:56:17 | 2022-02-01 13:22:03 | 184 | 217.12 | 177 | -40.12
EEE | 2022-02-01 00:00:00 | 21345450 | 34DZA215 | 2022-01-27 15:34:07 | 2022-02-01 16:10:00 | 665 | 784.7 | 796 | 0
EEE | 2022-02-28 00:00:00 | 21354809 | 34DYZ460 | 2022-02-19 10:05:49 | 2022-02-28 11:09:40 | 131.75 | 155.47 | 203.5 | 48.03
EEE | 2022-02-28 00:00:00 | 21408074 | 34EVF102 | 2022-01-31 15:59:48 | 2022-03-01 07:07:45 | 79.5 | 93.81 | 94.4 | 0
EEE | 2022-02-28 00:00:00 | 21455577 | 34DZA136 | 2022-02-12 15:06:49 | 2022-02-28 11:12:12 | 163.5 | 192.93 | 193 | 0
FFF | 2022-02-08 00:00:00 | 21330254 | 34DZA939 | 2022-01-11 14:19:35 | 2022-01-24 13:13:35 | 449.25 | 530.12 | 477.87 | 0 |  | yes
FFF | 2022-02-08 00:00:00 | 21330254 | 34DZA823 | 2022-01-24 13:13:36 | 2022-02-10 15:51:41 | 814.5 | 961.11 | 866.38 | 0 |  | yes
FFF | 2022-02-27 00:00:00 | 21507624 | 34DZE329 | 2022-02-23 08:17:19 | 2022-02-27 15:45:20 | 696.5 | 821.87 | 814.2 | 0
FFF | 2022-02-27 00:00:00 | 21522974 | 34DYP088 | 2022-02-26 18:43:53 | 2022-02-27 20:38:01 | 45.25 | 53.4 | 53.4 | 0
FFF | 2022-02-28 00:00:00 | 21411074 | 34DZF150 | 2022-02-17 16:49:55 | 2022-02-28 08:15:53 | 642.25 | 757.86 | 688.82 | 0
FFF | 2022-02-28 00:00:00 | 21413462 | 34DYN598 | 2022-02-25 18:54:39 | 2022-02-28 19:59:58 | 23 | 27.14 | 18 | -9.14
FFF | 2022-02-28 00:00:00 | 21438007 | 34DZD335 | 2022-02-25 12:53:28 | 2022-02-28 12:18:03 | 52 | 61.36 | 53.7 | 0
FFF | 2022-02-28 00:00:00 | 21438720 | 34EVE922 | 2022-02-07 16:54:39 | 2022-02-09 18:19:36 | 39.5 | 46.61 | 30.33 | -16.28 |  | yes
FFF | 2022-02-28 00:00:00 | 21438720 | 34DYN417 | 2022-02-09 18:19:37 | 2022-02-21 13:44:00 | 247 | 291.46 | 189.67 | -101.79 |  | yes
FFF | 2022-02-28 00:00:00 | 21493822 | 34EVF010 | 2022-02-21 19:21:49 | 2022-02-26 19:52:44 | 223.5 | 263.73 | 252 | 0
FFF | 2022-02-28 00:00:00 | 21515174 | 34DZD334 | 2022-02-24 13:59:21 | 2022-02-28 09:21:00 | 218 | 257.24 | 203.25 | -53.99000000000001