Spreadsheet: 766102d1643750564-remove-duplicates-similar-but-not-exact-delete-duplicate
Sheet: LPS-P-1

Time | in |  |  | this is what I will keep, the first time the car was logged within a 5 minute window
 | G447
 | gaj447
 | gam250
 | gax922
 | gaz59
 | gm238
2022-01-11 08:52:30.100000 | gsg957
 | h1613
 | h1613
 | h1714 |  |  |  | h1714
 | h1714 |  |  |  | h2013
 | h2013
 | h2013
 | H3255
 | h3350
 | h4273
 | h5999
 | H6540
 | h7218
 | H7932 | this shows me the same car license plate was registered at 6:41am and came back at 7:59am |  |  | H7932
 | h7932 |  |  |  | h7932
 | h7932
 | h7932
 | h7932
 | h8381 |  |  |  | h8381
 | h8391
 | h9244
 | HA101
 | HA509
 | ha509
 | HAA500
 | hae667
 | [NAME]
 | HAG167
 | hag825
 | hag825
 | haj675
 | haj679
 | HAJ725
 | hak235
 | hak235
 | hak335
 | hak379
 | hak379
 | hal13
 | hal153
 | ham699
 | ham779
 | HAM781
 | HAN111
 | han111
2022-01-11 08:52:40.105000 | han111
 | han284
 | han284
 | han396
 | han396
 | HAN472
 | [NAME]
 | hao723
 | has524
 | has524
 | has69
 | has69
 | hau109
 | haw595
 | haw675
 | HL890
 | hs101
 | HV544
 | hv544
 | hv678
 | hv678
 | hz365
 | p102
 | P1093
 | P1093
 | p1093
 | p1183
 | p1227
 | p1261
 | p1276
 | p1277
 | P1287
 | p1375
 | P1444
 | p1444
 | p148
 | p1481
 | p1486
 | p1486
 | p1500
 | p1509
 | p158
 | p1584
 | p1584
 | P1620
 | p1653
 | P1660
 | P1663
 | p1669
 | P1703
 | [NAME]
 | p1730
 | p1730
2022-01-11 08:56:50.230000 | p1736
 | p1736
 | P1795
 | P1842
 | p1907
 | P191
 | P1911
 | P1965
 | p1972
 | p1972
 | p2109
 | p2109
 | P2110
 | p2110
 | p2111
 | P2131
 | p2131
 | p2146
 | p2146
 | p215
 | p2156
 | p2156
 | p2189
 | p2189
2022-01-11 08:57:30.250000 | p2264
 | p2264
 | p2265
 | p2265
 | p2310
 | p2310
 | p2313
 | p2314
 | p2324
 | P2369
 | p2396
 | p2433
 | p2460
 | P2547
 | p2547
 | p2552
 | p2589
 | p2589
 | P2710
 | p2710
 | p2725
 | p2725
 | p2795
 | p3026
 | p3026
 | p3067
 | p3068
 | p3081
 | p3081
 | p3090
 | p3090
 | p3118
 | p3118
 | P3130
 | p3130
 | p3130
 | p3184
2022-01-11 08:49:40.015000 | P322
 | p3222
 | p3274
 | P3317
 | p3317
 | p3324
2022-01-11 08:52:30 | P333
 | P3348
 | p3348
 | p3353
 | p3354
 | p3354
 | p3356
 | p337
 | P3370
 | p3396
 | p3396
 | P3536
 | p3536
 | P3567
 | P358
 | P358
 | P3593
 | p3595
 | p3599
 | P3646
 | p3646
 | p3646
 | p3713
 | p3752
 | p3752
 | P3901
 | p3901
 | p3935
 | p3983
 | p4028
 | p4028
 | p403
 | p4035
 | p4035
 | p4046
 | p4046
2022-01-11 08:51:30.070000 | p4067
 | p4067
 | p4100
 | p4135
 | P4140
 | p4140
 | P417
 | p4234
 | P4249
2022-01-11 08:55:50.200000 | [NAME]
 | p4313
 | p4345
 | p4345
 | P4384
 | p4435
 | p4493
 | p4493
 | p4544
 | p4572
 | p4572
 | p4625
 | p4699
 | p4699
 | p4714
 | p4758
 | p4783
 | p4810
 | p4810
 | p4854
 | p489
 | p490
 | p490
 | p4909
 | p505
 | p5063
 | p5069
 | p5069
 | p5090
 | P512
 | p512
 | p5133
 | p5138
 | p5138
 | p517
 | p520
 | p520
 | p5251
 | p5265
 | p5265
 | P5310
 | p5370
 | p5370
 | p5410
 | p5410
 | p5446
 | p5501
 | P5511
 | p5521
 | p5521
 | p554
 | p554
 | P5555
 | p5572
 | p5572
 | p5616
 | P5639
 | p5639
 | P5644
 | p5644
 | P5816
 | p5816
 | p5835
 | p5883
 | p591
 | p591
 | p5936
 | p607
 | p621
 | p6326
 | P6392
 | p64
 | p64
 | P6407
 | P641
 | p641
 | p6414
 | p6414
 | p6466
 | P647
 | p6483
 | p6483
 | p6534
 | p6584
 | p6584
 | p663
 | p663
 | P6643
 | p6651
 | p6651
 | p6652
 | P6700
 | p6778
 | p6778
 | P6779
 | p6779
 | P6793
 | p6795
 | P6801
 | p6801
 | P6830
 | p6830
 | p6830
 | P6856
 | p69
 | p69
 | p691
 | p6921
 | P6935
 | p6935
 | p6935
 | p6959
 | p6989
 | P7047
 | p705
 | p705
 | P706
 | [NAME]
 | p7071
 | P7090
2022-01-11 08:57:10.240000 | p7195
 | p7195
 | p72225
 | P7225
 | P734
 | p734
 | p7348
 | p736
 | p7451
 | p7451
 | p7527
 | p7541
 | p7541
 | P7612
 | P7612
 | P764
 | p7653
 | p7679
 | p7679
 | p7721
 | P7733
 | p7778
 | p7820
 | p7955
 | p7955
 | p7972
 | p7972
 | p798
 | p798
 | P8173
 | p8176
 | P8190
 | p8190
 | p821
 | p8225
2022-01-11 08:55:30.190000 | p8251
 | p8255
 | p8327
 | p8328
 | p8328
2022-01-11 08:56:20.215000 | p8337
 | p8337
 | P8338
 | p8338
 | p8346
 | p8413
 | p8413
 | p8428
 | p8478
 | p8509
 | P851
 | p851
 | p8512
 | p8512
 | p853
 | p8556
 | p864
 | p8721
 | P875
 | p8780
 | P8788
 | p8894
 | p8910
2022-01-11 08:53:00.115000 | [NAME]
 | [NAME]
 | [NAME]
 | p9042
 | p9044
 | p9044
 | P9064
 | p9070
 | p9081
 | p9081
 | p9081
 | p9081
 | p9154
 | p9154
 | p9190
 | p9190
 | p9195
 | p9195
 | P9271
 | p9320
 | p9320
 | P9334
 | p9401
 | P9600
 | p9600
 | p9616
 | p9616
 | p964
 | P966
 | p966
 | p9675
 | p9675
 | P9765
2022-01-11 08:56:10 | P9789
2022-01-11 08:51:20.065000 | p981
 | p9846
 | p9920
 | p9932
 | p9932
 | Pa0233
 | pa429
 | PA518
 | pa518
 | pa527
 | pa618
 | pa676
 | pa677
 | pa707
 | pa707
 | pa882
 | PA969
 | pa969
 | PAA331
 | paa379
 | PAA391
 | paa391
 | paa408
 | PAA572
 | paa572
 | paa651
 | paa810
 | paa810
 | paa82
 | paa827
 | paa827
 | paa830
 | Paa90
 | paaa408
 | PAB101
 | PAB111
 | pab111
 | pab220
 | pab298
 | PAB312
 | pab426
 | pab426
 | pab485
 | pab514
 | pab514
 | pab69
 | pab821
 | pab838
 | pab838
 | pab850
 | pab933
 | pab933
 | pac123
 | pac184
 | pac184
 | PAC231
 | pac231
 | pac251
 | pac251
 | pac320
 | pac329
 | pac382
 | PAc396
 | pac401
 | pac424
 | pac482
 | pac535
 | pac597
 | PAC656
 | pac656
 | pac662
 | pac682
 | pac69
 | pac690
 | pac690
 | pac722
 | pac79
 | pac808
 | pac808
 | pac99
 | pac998
 | pad141
 | pad141
 | pad173
 | pad173
 | pad285
 | pad285
 | pad449
 | pad484
 | pad484
 | PAD515
 | pad515
 | pad662
 | pad707
 | [NAME]
 | [NAME]
 | pad804
 | pad84
 | pad862
 | PAD98
2022-01-11 08:54:10.150000 | pae132
 | pae132
 | [NAME]
 | pae199
 | pae265
 | pae41
 | Pae461
 | pae461
2022-01-11 08:50:50.050000 | pae488
 | pae670
 | PAE878
 | [NAME]
 | pae89
 | pae892
2022-01-11 08:50:10.030000 | PAE895
 | pae895
 | Pae922
 | PAE927
 | pae927
 | [NAME]
 | pae984
 | paf14
 | paf2
 | paf2
 | paf215
 | paf230
 | paf259
 | paf426
 | paf426
 | paf439
 | paf439
 | paf518
 | PAF638
 | paf638
 | paf689
 | paf805
 | paf876
 | paf876
 | paf889
 | PAF961
 | [NAME]
 | pag19
 | PAG205
 | pag273
 | pag301
 | pag301
 | pag308
 | Pag317
 | pag437
 | pag437
 | pag459
 | pag459
 | pag48
 | pag5
 | pag508
 | pag508
 | pag708
 | pag708
 | PAG740
 | pag740
 | pag773
2022-01-11 08:53:50.140000 | pag777
 | PAG79
 | PAG827
 | pag934
 | PAG940
 | paj114
 | paj220
 | paj308
 | PAJ33
 | PAJ344
 | paj344
 | PAJ370
 | PAJ373
 | paj373
 | paj373
 | paj539
 | paj579
 | paj589
 | paj631
 | paj631
 | PAJ665
 | paj665
 | paj680
 | paj691
 | paj713
 | paj746
 | paj746
 | PAJ75
 | paj75
 | paj75
 | paj85
 | paj902
 | paj902
 | Paj952
 | PAJ96
 | PAK113
 | pak183
 | pak277
 | pak334
 | pak35
 | pak366
 | pak390
 | pak390
 | pak468
 | pak468
2022-01-11 08:50:00.025000 | PAK575
 | pak674
 | PAK686
 | PAK687
 | pak7
 | pak72
 | pak72
 | pak722
 | pak728
 | pak753
 | PAK839
 | pak839
 | pak839
 | pak861
 | pak928
 | pak936
 | pak936
 | pal102
 | pal102
 | pal111
 | [NAME]
 | [NAME]
 | [NAME]
 | PAL176
 | pal176
 | pal205
 | pal266
 | pal312
 | [NAME]
 | [NAME]
 | pal42
2022-01-11 08:57:20.245000 | pal45
 | pal453
 | pal453
 | PAL47
 | pal527
 | pal527
 | pal559
 | pal651
 | pal655
 | pal655
 | pal699
 | pal699
 | pal712
 | pal712
 | PAL744
 | [NAME]
 | [NAME]
 | pal783
 | pal790
 | pal808
 | pal830
 | PAL839
 | pal845
2022-01-11 08:54:40.165000 | pal852
 | pal852
 | [NAME]
 | pal930
 | pal943
 | [NAME]
 | pal955
 | pam123
 | pam123
 | pam125
 | pam129
 | pam145
2022-01-11 08:53:40 | Pam15
 | pam154
 | pam154
 | pam16
 | pam16
 | PAM264
 | pam319
 | pam319
 | pam374
 | pam477
 | Pam478
 | pam478
2022-01-11 08:49:10 | pam547
 | PAM566
 | pam569
 | pam592
 | pam592
 | pam663
 | pam832
 | pam841
 | PAM9
 | pam9
2022-01-11 08:49:50.020000 | PAM960
 | pan109
 | pan109
 | pan165
 | pan165
 | PAN170
 | pan181
 | pan237
 | Pan242
 | pan253
 | pan320
 | pan339
 | pan343
 | pan343
 | pan414
 | pan414
 | pan434
 | pan526
 | pan526
 | pan579
 | pan579
 | pan582
 | PAN624
 | pan624
 | pan659
 | pan659
 | pan660
 | PAN687
 | pan723
 | pan725
 | pan763
 | pan763
 | pan833
 | pan833
 | [NAME]
 | pan943
 | pan943
 | PAN95
 | pan95
 | pan95
 | PAN974
 | [NAME]
 | pan978
 | PAN996
 | pao126
 | pao158
 | [NAME]
 | pao202
 | pao202
 | pao21
 | pao21
 | PAO216
 | pao216
 | pao29
 | pao313
 | pao336
 | pao345
 | pao35
 | pao35
 | pao350
 | pao350
 | Pao440
 | [NAME]
 | [NAME]
 | [NAME]
2022-01-11 08:51:00.055000 | pao493
 | pao493
 | pao509
 | pao558
 | pao635
 | pao635
 | pao64
 | pao713
 | pao736
 | pao739
 | pao769
 | pao796
 | pao818
 | pao818
 | pao824
 | pao840
 | pao875
 | pao875
 | pao882
2022-01-11 08:52:00.085000 | pao884
 | pao935
 | pao935
 | pao988
 | pap100
 | pap181
 | pap243
 | Pap243
2022-01-11 08:50:40.045000 | pap246
 | pap26
 | pap303
 | pap325
 | pap330
 | pap34
 | pap368
 | pap375
 | pap375
 | pap43
 | [NAME]
 | [NAME]
 | Pap5
 | [NAME]
 | pap522
 | pap595
 | pap595
 | pap61
 | PAP613
 | Pap666
 | pap701
 | pap701
 | pap761
2022-01-11 08:49:00 | pap842
 | pap853
 | pap903
 | PAP912
 | pas107
 | PAS139
 | pas139
 | Pas154
 | pas194
 | pas194
 | pas228
 | pas228
 | pas2310
 | pas239
 | pas239
 | pas243
 | pas243
2022-01-11 08:50:30.040000 | pas311
 | PAS314
 | pas314
 | pas314
 | PAS38
 | pas40
 | PAS422
 | pas437
 | pas509
 | pas514
 | pas550
 | pas621
 | pas708
 | pas740
 | pas788
 | pas798
 | pas802
 | pas802
 | PAS832
 | pas832
 | pas832
 | pas832
 | pas862
 | pas867
 | pas942
 | pas942
 | [NAME]
 | pau169
 | pau178
 | PAU216
 | pau232
 | pau252
 | pau252
2022-01-11 08:56:30.220000 | pau288
 | pau288
 | PAU369
 | pau369
 | Pau369
 | pau369
 | pau420
 | pau420
 | pau487
 | PAU497
 | pau58
 | pau581
 | pau586
 | pau586
 | pau589
 | PAU603
 | pau674
 | pau695
 | pau695
 | pau697
 | pau72
 | pau72
 | pau732
 | pau784
 | pau858
 | pau895
 | PAU963
 | pau963
 | pav101
 | pav109
 | pav11
 | pav11
 | pav112
 | pav121
 | pav121
 | Pav146
 | pav146
 | pav192
 | pav211
 | [NAME]
 | PAV23
 | pav239
 | pav292
 | pav292
 | pav292
 | PAV325
 | pav380
 | PAV382
 | pav382
 | pav382
 | pav393
 | pav393
 | pav398
 | Pav406
 | pav42
 | pav427
 | pav506
 | pav506
 | pav647
 | pav647
 | pav654
 | PAV688
 | pav702
 | PAV712
 | pav762
 | PAV790
 | pav802
 | pav807
 | pav837
 | paw112
 | paw180
 | paw181
2022-01-11 08:51:40.075000 | paw191
2022-01-11 08:53:10 | Paw191
 | [NAME]
 | [NAME]
 | paw303
 | paw344
 | Paw385
 | paw385
2022-01-11 08:56:40.225000 | paw385
 | paw385
 | paw41
 | paw435
 | paw483
 | paw483
 | PAW49
 | paw49
 | paw50
 | Paw504
 | Paw517
 | Paw525
 | paw528
 | PAW550
 | paw550
 | paw5p
 | paw601
 | paw609
 | paw64
 | paw640
 | PAW753
 | paw84
 | paw86
 | paw86
 | paw911
 | PAW930
 | paw930
 | paw94
 | paw944
 | paw944
 | paw990
 | pax 189
 | pax217
 | pax219
 | PAX259
 | pax277
2022-01-11 08:53:30.130000 | [NAME]
 | [NAME]
2022-01-11 08:49:30.010000 | PAX308
 | pax320
 | pax339
 | PAX364
 | Pax39
 | Pax39
 | pax39
 | pax39
 | pax396
 | pax477
 | pax50
 | pax53
 | pax58
 | pax636
 | pax652
 | pax652
 | Pax659
 | pax659
 | PAX662
 | pax662
 | pax686
 | pax686
 | Pax70
 | pax700
 | pax700
 | pax736
 | pax763
 | pax785
 | pax785
 | pax822
 | pax841
 | pax841
2022-01-11 08:54:00.145000 | pax875
 | pax875
 | pax877
 | [NAME]
 | pax993
 | paz38
 | paz51
 | Paz67
 | paz68
 | Pb234
 | pb300
 | pb485
 | PB53
 | pb53
 | PB555
 | PB656
 | pb656
 | pb71
 | pb884
 | pb884
 | pc22
 | pc22
2022-01-11 08:54:30.160000 | pc225
 | pc29
 | pc363
 | [NAME]
 | pc525
 | pc525
 | pc682
 | pc720
 | pc91
 | pc932
 | pd293
 | pd627
 | Pd855
 | pd864
 | pe28
 | pe28
 | Pf17
 | Pf43
 | pf43
2022-01-11 08:56:00.205000 | pf484
 | pf484
 | pf718
 | pf991
 | pf991
 | pg205
 | pg205
 | PG525
 | PG557
 | PG717
 | Pj304
 | pj92
 | Pk104
 | pk104
 | PK255
 | pk255
 | pk295
 | pk312
 | PK409
 | pk409
 | pk588
 | pk717
 | pk717
 | pk728
 | pk83
 | pk925
 | pl106
 | pl106
 | PL336
 | pl336
 | pl443
 | pl470
 | pl557
 | pl557
 | PL58
 | pl58
 | pl661
 | PL696
 | pl855
 | pl855
 | pl927
 | pl932
 | pl932
 | pm2
 | pm333
 | pm724
 | pm90
 | pm90
 | pm952
 | PN195
 | pn261
 | pn332
 | pn679
 | pn81
2022-01-11 08:53:10.120000 | pn86
 | po0279
 | po241
 | po310
 | po310
 | PO337
 | po379
 | po379
 | po51
 | PO689
 | po855
 | pp380
 | pp380
2022-01-11 08:52:20.095000 | pp396
 | pp444
 | pp485
 | pp485
 | [NAME]
 | ps226
 | ps226
 | Ps264
 | ps264
 | Ps304
 | ps304
 | ps39
 | ps39
 | ps417
 | ps417
 | ps417
 | ps47
 | ps47
 | PS476
 | pS509
 | Ps574
 | ps655
 | PS781
 | ps789
2022-01-11 08:57:50.260000 | ps798
 | PS803
 | ps803
 | [NAME]
 | [NAME]
 | psn846
 | psp325
 | psu467
 | pu123
 | pu395
 | pu40
 | pu428
 | pu463
 | Pu466
 | pu512
 | pu512
 | PU721
 | pu721
 | PU750
 | pu750
 | pu750
 | pu799
 | [NAME]
 | pu88
 | pu88
 | pv304
 | pv312
 | pv312
 | pv423
 | pv423
 | pv684
 | pv731
 | pv731
 | pv803
 | pv803
 | pv853
 | pw145
 | pw2
 | pw2
2022-01-11 08:56:10.210000 | pw250
 | pw250
 | pw281
 | pw281
 | pw376
 | pw376
 | PW437
 | pw437
 | pw770
 | PW861
 | pw861
 | pw861
 | pw868
 | pw876
 | PW888
 | pw999
 | pw999
 | px189
 | px251
 | px254
 | PX32
 | px389
 | px389
 | px417
 | px932
 | pz136
 | pz136
 | [NAME]
 | PZ256
 | pz27
 | pz271
 | pz349
 | pz349
 | pz464
 | pz464
 | pz470
 | [NAME]
 | PZ55
 | pz60
 | PZ68
 | pz921
 | pz921
 | [NAME]
 | SL137
 | sl137
 | sl190
 | sl190
 | sl25
 | SL329
 | sl329
 | sl329
2022-01-11 08:51:10.060000 | sl34
2022-01-11 08:55:40.195000 | sl5
 | sl57
 | sl57
 | t0749
 | t1131
 | t1131
 | T2211
 | t2782
 | t2782
 | [NAME]
 | T3710
 | t3710
 | t4034
 | t4034
 | t431
 | t431
 | t4429
 | t4429
 | t4570
 | t50
 | t50
 | t515
 | t5220
 | t5466
 | t5699
 | t5699
2022-01-11 08:55:20.185000 | t5758
 | t5917
 | t5917
 | t5986
 | t5986
2022-01-11 08:55:00.175000 | t6878
 | t6878
 | t6930
 | T693O
 | [NAME]
 | t7857
 | t7857
 | t8269
 | t8269
2022-01-11 08:50:20.035000 | T8397
 | t8397
 | T853
 | t853
 | T921
 | T9715
 | T9830
 | t9843
 | ta79
 | taa122
 | taa122
 | taa434
 | taa64
 | TAA676
 | TAB389
 | tab389
 | tab410
 | tab410
 | tab771
 | tab815
 | TAB966
 | tab966
 | tac135
 | tac135
 | tac166
 | [NAME]
 | [NAME]
 | tac786
 | tac786
 | [NAME]
 | tad486
 | tad904
 | tad904
 | tad995
 | tae24
 | tae42
 | tae992
 | tae992
 | [NAME]
2022-01-11 08:52:50.110000 | taf536
 | taf536
 | taf544
 | Taf802
 | TAG100
 | TAG530
 | tag737
 | tag824
 | taj365
 | TAJ52
 | TAK166
 | tak313
 | tak409
 | tak415
 | tak473
 | tak473
 | tak516
 | tak516
 | tak582
 | TAK650
 | tak650
 | tal238
 | tal238
 | TAL578
 | [NAME]
 | tal710
 | tal710
 | tam235
 | tam235
 | tam649
 | tam658
 | tam824
 | tam824
 | tan723
 | tan857
 | tan857
 | tan892
 | tan993
 | tan993
2022-01-11 08:57:40.255000 | tao398
 | tao398
 | tao418
 | tao700
 | tao700
 | tap139
 | tap139
 | [NAME]
 | [NAME]
 | TAP337
 | TAP767
 | tap767
 | TAP855
 | tap976
 | tas382
 | tas382
 | TAS768
2022-01-11 08:55:10.180000 | tau171
 | tau171
 | tau20
 | tau20
 | TAU263
 | tau263
 | Tau876
 | Tau900
 | tau900
 | taw290
 | TAW867
 | taw867
 | taw983
 | taw993
 | TAX271
 | tax597
2022-01-11 08:52:10.090000 | [NAME]
 | TAX650
2022-01-11 08:51:50.080000 | tb408
2022-01-11 08:53:30 | Tb408
 | tb611
 | tc365
 | TC74
 | td215
 | td625
 | Td949
 | td949
 | td949
2022-01-11 08:49:20.005000 | [NAME]
 | [NAME]
 | tg100
 | tg17
2022-01-11 08:54:50.170000 | [NAME]
 | [NAME]
 | TG224
 | tg224
 | [NAME]
 | TG99
 | th910
 | tk423
 | tk541
 | tk666
 | TK758
 | tk758
 | tm351
 | tn109
 | tn109
 | tn221
 | Tn494
 | Tn494
 | tn929
 | tn929
 | to210
 | to749
 | tp657
 | tp981
 | ts464
 | ts464
 | ts756
 | ts756
 | tsm649
 | tsp107
 | ttaf24
 | tu384
 | tv165
 | Tv367
 | tv455
2022-01-11 08:53:40.135000 | tv694
 | tv964
 | [NAME]
 | [NAME]
 | tw831
2022-01-11 08:57:00.235000 | tw914
 | tw914
 | tx297
 | Tx784
2022-01-11 08:53:20.125000 | tx831
 | tz493
 | tz493
2022-01-11 08:54:20.155000 | tz623
 | tz623
 | [NAME]
 | TZ819
 | TZ851