Spreadsheet: 680155d1590822872-mapping-five-fields-from-smaller-data-set-to-larger-data-set-based-on-criterias-lms-report-27052020-with-pq
Sheet: LMS Report

Seq No | Journey No | [NAME] | Driver Production Incentive | Plan No | Vehicle Inspection No | Journey Created Date | Journey Start Date | Journey Close Date | Journey Actual Start Time | Journey Actual End Time | Journey Manager | Vehicle No | Trailer No | Driver ID | Driver Name | Planned / Actual Distance (Km) | Planned / Actual Duration (HH:MM) | Seatbelt violation count | Speed violation count | Harsh brake count | Driver START/STOP inside fence | Event Type
1 | PL/014049 | Journey Closed | P6 | PL/014049 | INS/002407 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 15:39:41 | 27/05/2020 16:06:13 |  | 50478A |  | 952444 | HITESH LALJI HIRANI | 25.761/35.641 | 00:30/00:26 | 0 | 0 | 0 | N/Y | DRIVE
2 | PL/014053 | Journey Closed | P6 | PL/014053 | INS/002407 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 14:47:01 | 27/05/2020 15:29:36 |  | 50478A |  | 952444 | HITESH LALJI HIRANI | 29.293/30.604 | 00:37/00:43 | 0 | 0 | 0 | Y/Y | DRIVE
3 | PL/014044 | Journey Closed | P8 | PL/014044 | INS/002408 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 11:28:45 | 27/05/2020 11:34:10 |  | 76732W |  | 942779 | BIRBAL YADAV | 3.819/3.855 | 00:05/00:05 | 0 | 0 | 0 | N/Y | DRIVE
4 | PL/014043 | Journey Closed | P0 | PL/014043 | INS/002410 | 27/05/2020 | 27/05/2020 | 28/05/2020 | 27/05/2020 17:32:20 | 27/05/2020 17:34:16 |  | 8927HK |  | 613390 | NAJEEB MUBARAK NASIB AL QURAINI | 25.288/ | 00:21/00:01 | 0 | 0 | 0 | CL-NA/N | DRIVE
5 | PL/014038 | Journey Closed | P8 | PL/014038 | INS/002404 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 [NAME] | 27/05/2020 08:40:16 |  | 90851H |  | 941868 | [NAME] RATHOD | 4.426/4.824 | 00:08/00:08 | 0 | 0 | 0 | CL-NA/N | DRIVE
6 | PL/014031 | Journey Closed | P7 | PL/014031 | INS/002403 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 06:50:19 | 27/05/2020 06:59:21 |  | 82722B |  | 952444 | HITESH LALJI HIRANI | 8.295/8.192 | 00:10/00:09 | 0 | 0 | 0 | Y/Y | DRIVE
7 | PL/014054 | Journey Closed | P7 | PL/014054 | INS/002404 | 27/05/2020 | 27/05/2020 | 28/05/2020 | 27/05/2020 17:03:36 | 27/05/2020 17:15:53 |  | 90851H |  | 941868 | [NAME] RATHOD | 8.676/8.921 | 00:17/00:12 | 0 | 0 | 0 | Y/N | DRIVE
8 | PL/014062 | Journey Closed | P0 | PL/014062 | INS/002193 | 27/05/2020 | 27/05/2020 | 28/05/2020 | 27/05/2020 21:49:35 | 27/05/2020 22:12:01 |  | 2413HW |  | 937496 | SHANTILAL PREMJI PATEL | 2.243/3.738 | 00:05/00:23 | 0 | 0 | 0 | N/Y | DRIVE
9 | [NAME] | Journey Closed | P7 | [NAME] | INS/002193 | 27/05/2020 | 27/05/2020 | 28/05/2020 | 27/05/2020 18:18:45 | 27/05/2020 18:33:23 |  | 2413HW |  | 937496 | SHANTILAL PREMJI PATEL | 6.683/5.017 | 00:09/00:15 | 0 | 0 | 0 | N/Y | DRIVE
10 | PL/014059 | Journey Closed | P8 | PL/014059 | INS/002411 | 27/05/2020 | 27/05/2020 | 28/05/2020 | 27/05/2020 16:33:21 | 27/05/2020 16:47:53 |  | 53936H |  | 942184 | TRUSHAR VASANTBHAI RATHOD | 30.508/15.067 | 00:30/00:15 | 0 | 0 | 0 | Y/N | DRIVE
11 | PL/014032 | Journey Closed | P7 | PL/014032 | INS/002405 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 07:09:22 | 27/05/2020 07:17:05 |  | 32153R |  | 943696 | SUSANTA KUMAR SANTOSH DAS | 15.782/5.208 | 00:09/00:09 | 0 | 0 | 0 | Y/N | DRIVE
12 | PL/014042 | Journey Closed | P6 | PL/014042 | INS/002406 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 11:05:23 | 27/05/2020 11:14:28 |  | 6647H |  | 937661 | RAJU ALAKUNTA | 13.953/8.769 | 00:16/00:09 | 0 | 0 | 0 | Y/N | DRIVE
13 | PL/014055 | Journey Closed | P7 | PL/014055 | INS/002408 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 15:47:04 | 27/05/2020 16:03:32 |  | 76732W |  | 942779 | BIRBAL YADAV | [NAME] | 00:10/00:17 | 0 | 0 | 0 | Y/Y | DRIVE
14 | PL/014041 | Journey Closed | P8 | PL/014041 | INS/002405 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 10:24:37 | 27/05/2020 10:36:15 |  | 32153R |  | 943696 | SUSANTA KUMAR SANTOSH DAS | 5.178/5.195 | 00:50/00:12 | 0 | 0 | 0 | Y/Y | DRIVE
15 | [NAME] | Journey Closed | P6 | [NAME] | INS/002403 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 06:27:53 | 27/05/2020 06:35:03 |  | 82722B |  | 952444 | HITESH LALJI HIRANI | 4.247/5.544 | 00:08/00:08 | 0 | 0 | 0 | Y/N | DRIVE
16 | PL/014037 | Journey Closed | P8 | PL/014037 | INS/002406 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 08:21:32 | 27/05/2020 08:27:59 |  | 6647H |  | 937661 | RAJU ALAKUNTA | 4.243/3.851 | 00:07/00:08 | 0 | 0 | 0 | N/Y | DRIVE
17 | PL/014040 | Journey Closed | P7 | PL/014040 | INS/002407 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 10:28:07 | 27/05/2020 [NAME] |  | 50478A |  | 927446 | RANCHHOD KARSHAN CHHANGA | 26.731/26.391 | 00:23/00:23 | 0 | 0 | 0 | Y/N | DRIVE
18 | PL/014050 | Journey Closed | P8 | PL/014050 | INS/002408 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 15:24:09 | 27/05/2020 15:39:03 |  | 76732W |  | 942779 | BIRBAL YADAV | 17.244/17.218 | 00:19/00:15 | 0 | 0 | 0 | N/Y | DRIVE
19 | PL/014036 | Journey Closed | P7 | PL/014036 | INS/002407 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 08:20:48 | 27/05/2020 08:33:45 |  | 50478A |  | 927446 | RANCHHOD KARSHAN CHHANGA | 12.498/14.062 | 00:13/00:13 | 0 | 0 | 0 | Y/N | DRIVE
20 | PL/014047 | Journey Closed | P8 | PL/014047 | INS/002409 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 [NAME] | 27/05/2020 15:02:10 |  | 2605HW |  | 927446 | RANCHHOD KARSHAN CHHANGA | 3.813/3.843 | 00:05/00:05 | 0 | 0 | 0 | Y/Y | DRIVE
21 | PL/014048 | Journey Closed | P8 | PL/014048 | INS/002405 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 15:00:40 | 27/05/2020 15:17:13 |  | 32153R |  | 943696 | SUSANTA KUMAR SANTOSH DAS | 11.269/9.166 | 00:35/00:18 | 0 | 0 | 0 | N/Y | DRIVE
22 | PL/014060 | Journey Closed | P0 | PL/014060 | INS/002406 | 27/05/2020 | 27/05/2020 | 28/05/2020 | 27/05/2020 16:34:01 | 27/05/2020 17:03:36 |  | 6647H |  | 937661 | RAJU ALAKUNTA | [NAME] | 00:10/00:31 | 0 | 0 | 0 | Y/Y | DRIVE
23 | PL/014046 | Journey Closed | P8 | PL/014046 | INS/002406 | 27/05/2020 | 27/05/2020 | 28/05/2020 | 27/05/2020 17:30:28 | 27/05/2020 17:35:28 |  | 6647H |  | 937661 | RAJU ALAKUNTA | 4.161/4.122 | 00:07/00:05 | 0 | 0 | 0 | Y/Y | DRIVE
24 | PL/014033 | Journey Closed | P7 | PL/014033 | INS/002405 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 07:51:32 | 27/05/2020 08:00:36 |  | 32153R |  | 943696 | SUSANTA KUMAR SANTOSH DAS | 4.427/4.267 | 00:10/00:10 | 0 | 0 | 0 | Y/Y | DRIVE
25 | PL/014056 | Journey Closed | P0 | PL/014056 | INS/002405 | 27/05/2020 | 27/05/2020 | 28/05/2020 | 27/05/2020 16:23:41 | 27/05/2020 17:08:29 |  | 32153R |  | 943696 | SUSANTA KUMAR SANTOSH DAS | 17.559/17.746 | 00:17/00:46 | 0 | 0 | 0 | Y/N | DRIVE
26 | PL/014057 | Journey Closed | P0 | PL/014057 | INS/002406 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 15:52:07 | 27/05/2020 16:08:36 |  | 6647H |  | 937661 | RAJU ALAKUNTA | 3.053/3.232 | 00:04/00:16 | 0 | 0 | 0 | Y/Y | DRIVE
27 | PL/014051 | Journey Closed | P7 | PL/014051 | INS/002411 | 27/05/2020 | 27/05/2020 | 28/05/2020 | 27/05/2020 18:42:23 | 27/05/2020 18:59:29 |  | 53936H |  | 942184 | TRUSHAR VASANTBHAI RATHOD | 17.823/16.685 | 00:15/00:18 | 0 | 0 | 0 | N/N | DRIVE
28 | PL/014035 | Journey Closed | P7 | PL/014035 | INS/002406 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 07:28:21 | 27/05/2020 08:01:24 |  | 6647H |  | 937661 | RAJU ALAKUNTA | 7.817/7.324 | 00:20/00:34 | 0 | 0 | 0 | Y/Y | DRIVE
29 | PL/014029 | Journey Closed | P7 | PL/014029 | INS/002404 | 27/05/2020 | 27/05/2020 | 27/05/2020 | 27/05/2020 07:10:29 | 27/05/2020 07:20:47 |  | 90851H |  | 941868 | [NAME] RATHOD | 9.244/6.674 | 00:10/00:10 | 0 | 0 | 0 | Y/Y | DRIVE
30 | PL/013143 | [NAME] |  | PL/013143 | INS/002193 | 27/05/2020 |  |  |  |  |  | 2413HW |  | 943279 | BHAVESHKUMAR ARVIND RAMANI | 0/ | 0/0 |  |  |  |  | DRIVE