C:\Users\abrou\AppData\Local\Temp\Engine_3232_4d9a4fe65d6e4e45bd41105ee762afa2_\Engine_9908_f22d09a0afae48e280f8706491151de6_.yxdb
Single
Profile
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #202
The input file below contains data on the toll stops of different vehicles (identified by plate_id). The Text Input contains the toll for driving a Segment between two toll booths. For example, it costs $2.25 to drive between toll booth 1 and tool booth 2 (1,2). Plates are tracked to identify the toll booths they pass and the time between toll boths.
Calculate the total tolls and time spent on the road per [plate_id].
C:\Users\abrou\Downloads\Challenge_203_start_file\MockTrafficDataForMCNFP.csv
28591
,
False
254
False
True
DoubleQuotes
1
MockTrafficDataForMCNFP.csv
1,2
2.25
1,3
2.25
2,5
3.00
2,4
1.75
5,6
2.25
4,5
2.75
4,6
2.25
3,5
1.75
3,4
3.00
Segment Tolls
137FA90
6.25
102
137ZA90
6.25
124
19UUA56
6.25
33
19UUA65
7.5
67
19UUA66
13.75
105
19UUA8F
13.75
177
19UUA9F
27.75
383
19UYA42
6.25
11
19VDE1F
18.75
244
19VDE2E
6.25
37
19VDE3F
6.25
111
19XFA1E
12.5
149
19XFA1F
6.25
56
19XFB4F
26.75
222
1B3CB7H
15.25
112
1B3CC1F
6.25
119
1B3CC4F
6.25
84
1B3CC5F
6.25
97
1C3BCBF
9
75
1C3CC5F
9
57
1C3CCBA
6.25
41
1C3CCBC
16.5
145
1C3CDFB
6.25
48
1C3CDZA
6.25
109
1C4AJWA
6.25
44
1C4NJCB
6.25
108
1C4RDHE
6.25
30
1C4RDJA
16.5
189
1C4RDJD
7.5
69
1C4RDJE
6.25
26
1C4SDHC
25.5
189
1C6RD6F
6.25
39
1C6RD6P
6.25
101
1C6RD7N
6.25
112
1C6RD7P
6.25
134
1D4PT6G
6.25
111
1D4PT7G
6.25
117
1D4PU5G
6.25
116
1D4PU6G
6.25
50
1D4RD3G
6.25
38
1D4RE4G
6.25
110
1D4SD6G
6.25
41
1D7CE2G
10.25
103
1D7CW2B
6.25
25
1D7CW7G
9
82
1D7RB1C
13.75
183
1D7RB1G
12.5
79
1D7RE3B
9
63
1D7RV1C
6.25
109
1D7RW2G
6.25
76
1D7RW3B
7.5
81
1D7RW3G
15.25
181
1FA6P0H
6.25
117
1FADP3E
7.5
71
1FADP5C
24
266
1FAHP3E
6.25
113
1FBAX2C
7.5
70
1FBNE3B
6.25
37
1FBSS3B
6.25
35
1FM5K7B
6.25
33
1FMCU0D
7.5
64
1FMCU4K
16.5
123
1FMCU9C
7.5
70
1FMEU8F
6.25
92
1FMHK7B
6.25
46
1FMJK1G
6.25
27
1FMJK1H
6.25
44
1FMJK1J
7.5
84
1FMJU1F
22.75
235
1FMJU1H
9
61
1FMJU1K
6.25
116
1FT7W2A
6.25
102
1FTEW1C
42.75
471
1FTEX1C
64.25
684
1FTEX1E
21.5
314
1FTFW1E
18.75
239
1FTKR1A
6.25
20
1FTMF1C
12.5
91
1FTMF1E
29
383
1FTNF2B
6.25
127
1FTNS2E
6.25
38
1FTSW2A
7.5
83
1FTSW2B
12.5
164
1FTSX2A
6.25
51
1FTWF3B
13.75
113
1FTWF3C
6.25
107
1FTWF3D
12.5
166
1FTWW3A
22.75
318
1FTWW3B
6.25
41
1FTWW3C
12.5
66
1FTWW3D
9
79
1FTWX3B
6.25
47
1G4CW54
12.5
79
1G4GA5E
15.25
143
1G4GA5G
9
56
1G4GB5G
6.25
42
1G4GC5G
13.75
202
1G4GD5E
7.5
57
1G4GD5G
9
79
1G4GE5G
7.5
54
1G4GF5E
12.5
244
1G4GG5G
10.25
98
1G4HC5E
6.25
104
1G4HP52
12.5
143
1G4HP57
6.25
51
1G4HR54
7.5
83
1G4HR57
6.25
47
1G4PN5S
12.5
85
1G4PP5S
6.25
125
1G4PR5S
6.25
103
1G4PS5S
6.25
102
1G4PT5S
12.5
152
1G6AA5R
18.75
326
1G6AB5R
6.25
91
1G6AC5S
15.25
129
1G6AE5S
10.25
93
1G6AH5R
9
71
1G6AH5S
9
58
1G6AJ1R
6.25
49
1G6AJ5S
6.25
87
1G6AK5S
25
218
1G6AL5S
6.25
35
1G6AM1R
6.25
128
1G6AS5S
6.25
102
1G6AU5S
6.25
119
1G6AV5S
6.25
121
1G6AY5S
6.25
41
1G6D25E
9
62
1G6DA8E
12.5
234
1G6DC8E
20.5
197
1G6DE5E
6.25
91
1G6DE8E
6.25
124
1G6DF8E
16.5
147
1G6DG1E
9
79
1G6DG8E
10.25
93
1G6DH8E
6.25
42
1G6DJ1E
6.25
113
1G6DJ57
15.25
121
1G6DJ5E
6.25
106
1G6DJ8E
6.25
98
1G6DK8E
6.25
119
1G6DL5E
12.5
255
1G6DL8E
15.25
97
1G6DM1E
6.25
104
1G6DM57
7.5
82
1G6DM5E
6.25
100
1G6DM8E
12.5
219
1G6DN57
6.25
35
1G6DP1E
12.5
97
1G6DP57
7.5
68
1G6DP5E
12.5
81
1G6DP8E
6.25
114
1G6DR57
6.25
38
1G6DS1E
10.25
101
1G6DS8E
15.25
182
1G6DT57
25.5
283
1G6DU6E
6.25
44
1G6DV5E
6.25
31
1G6DV8E
6.25
127
1G6DW67
6.25
121
1G6DX6E
7.5
85
1G6EL12
15.25
123
1G6ET12
6.25
36
1G6KA5E
6.25
43
1G6KD57
40
430
1G6KE57
12.5
179
1G6KF57
12.5
83
1G6KS54
6.25
39
1G6KY54
6.25
38
1G6YX36
15.25
177
1GD01ZC
12.5
151
1GD02ZC
12.5
153
1GD11ZC
30.5
240
1GD21ZC
18.75
311
1GD22ZC
10.25
102
1GD311C
6.25
47
1GD322C
6.25
39
1GD422C
7.5
47
1GKKRNE
12.5
79
1GKLRKE
6.25
31
1GKS1AE
6.25
99
1GKS1FE
9
82
1GKS1FF
6.25
52
1GKS1GE
7.5
90
1GKS1HE
6.25
103
1GKS1KE
7.5
62
1GKS2FE
6.25
129
1GKUCFD
7.5
53
1GKUCGE
6.25
26
1GT022C
6.25
45
1GT02ZC
6.25
119
1GTC5LF
6.25
107
1GTC5MF
6.25
32
1GTG5BE
6.25
31
1GTN1TE
10.25
76
1GTN1UE
7.5
93
1GTN2TE
6.25
108
1GTPCTE
6.25
117
1GYEC63
12.5
72
1GYFC53
6.25
38
1GYFK16
6.25
44
1GYFK23
6.25
86
1GYFK43
10.25
108
1GYFK56
9
74
1GYFK66
9
53
1GYS3BE
7.5
42
1GYS3CE
6.25
36
1GYS3FE
7.5
65
1GYS3HE
6.25
41
1GYS3JE
6.25
93
1GYS4CE
6.25
42
1GYS4DE
7.5
63
1GYS4EE
7.5
91
1GYS4HK
6.25
50
1GYS4JE
16.5
146
1GYS4JK
6.25
93
1GYS4KE
9
55
1GYS4MK
6.25
30
1GYS4NK
6.25
39
1GYS4RK
6.25
43
1GYUCCE
6.25
24
1GYUCJE
16.5
209
1GYUKEE
7.5
88
1GYUKJE
6.25
86
1HGCP2E
6.25
114
1HGCR6F
9
56
1J4AA2D
9
74
1J4NF1G
6.25
100
1J4PN2G
9
78
1J4PR4G
6.25
26
1J4RG4G
6.25
40
1LNHL9D
6.25
35
1LNHL9E
6.25
96
1N4AB7A
27.5
215
1N4AL2A
13.75
210
1N4AL3A
6.25
111
1N6AA0C
58
571
1N6AA0E
19.25
144
1N6AD0C
38.75
376
1N6AF0K
6.25
46
1N6AF0L
21.5
234
1N6BF0K
33.75
389
1NXBU4E
12.5
154
1VWAH7A
22.75
275
1VWAP7A
12.5
77
1YVHZ8B
26.25
259
1ZVBP8A
12.5
236
2B3CA2C
6.25
35
2B3CA5C
7.5
94
2C3CA2C
6.25
117
2C3CA4C
6.25
116
2C3CA9C
9
57
2C3CCAA
10.25
81
2C3CCAB
12.5
146
2C3CCAK
6.25
51
2C3CCAR
9
72
2C3CCAS
15.25
121
2C3CDXC
16.5
145
2C3CDXH
9
65
2C3CDXJ
9
64
2C3CDYB
12.5
147
2C3CDZA
9
47
2C3CDZB
9
77
2C4JRGA
6.25
45
2C4RDGB
22.75
167
2C4RDGC
12.5
126
2C4RVAA
6.25
127
2D4RN5D
10.25
87
2FMDK3K
12.5
200
2FMDK4G
6.25
50
2FMPK3J
6.25
35
2G4GK5E
9
67
2G4GN5E
16.5
150
2G4GR5E
16.5
202
2G4GS5E
10.25
85
2G4GT5G
6.25
128
2G4GU5G
7.5
82
2G4GW5E
9
58
2G4GX5G
13.75
121
2G4WB52
9
77
2G4WD55
6.25
103
2G4WD56
10.25
86
2G4WD58
12.5
62
2G4WE58
6.25
93
2G4WF55
6.25
120
2G4WS55
7.5
77
2G61N5S
13.75
172
2G61R5S
13.75
171
2G61S5S
6.25
136
2G61U5S
7.5
76
2G61W5S
6.25
112
2GKALME
16.5
192
2HNYB1H
6.25
103
2HNYD18
7.5
75
2HNYD28
41.5
379
2HNYD2H
18.75
193
2LMHJ5A
6.25
41
2LMHJ5F
9
74
2T1BPRH
15.25
168
2T1BU4E
19.25
170
2T1BURH
41.5
420
2T1KE4E
20
218
2T2BK1B
13.75
109
2T3BF4D
12.5
143
2T3BFRE
7.5
71
3C3CFFA
6.25
35
3C3CFFC
7.5
66
3C3CFFD
6.25
41
3C3CFFE
6.25
41
3C3CFFJ
13.75
179
3C4PDCE
24
210
3C4PDCG
6.25
107
3C4PDDB
6.25
39
3C4PDDD
6.25
105
3C4PDDG
20
206
3C63D2E
6.25
118
3C63D2G
9
77
3C63D3K
7.5
92
3C63D3L
6.25
44
3C63D3N
6.25
120
3C63DRB
13.75
167
3C63DRH
6.25
43
3C63DRN
6.25
127
3C6JD7A
9
58
3C6JR6C
12.5
167
3C6TD5D
6.25
85
3D4PG9F
13.75
192
3D4PH6F
16.5
185
3D4PH7F
6.25
111
3D73M3C
6.25
80
3D73M4C
24.25
156
3D73M4E
6.25
115
3D73M4H
10.25
98
3D73Y3C
18.75
168
3D73Y3H
12.5
87
3D73Y4C
13.75
114
3D7JB1E
12.5
212
3D7JV1E
6.25
97
3D7LP2E
6.25
43
3D7TP2C
21.5
205
3D7TT2C
38
455
3D7TT2H
6.25
104
3FA6P0D
16.5
188
3FA6P0S
6.25
45
3FAHP0C
10.25
87
3FAHP0J
6.25
34
3G5DB03
6.25
114
3GTU1YE
18.75
293
3GTU2YE
12.5
79
3GYEK63
9
87
3GYFK52
6.25
121
3GYFK62
15.25
179
3GYFNBE
12.5
152
3GYFNDE
6.25
47
3GYFNEE
15.25
185
3GYFNFE
6.25
44
3GYT4LE
6.25
49
3GYT4ME
6.25
43
3GYT4NE
6.25
38
3LN6L2G
16.5
139
3LN6L2L
6.25
45
3MZBM1K
6.25
33
3MZBM1L
12.5
177
3N1AB6A
20
217
3N1AB7A
22.75
172
3N1CE2C
6.25
116
3N1CN7A
45
568
3N6CM0K
25.5
197
3TMJU4G
6.25
35
3VW1K7A
16.5
185
3VW217A
9
56
3VW467A
12.5
149
3VW4A7A
10.25
82
3VW507A
22.75
309
3VW517A
15.25
163
3VW8S7A
18.75
347
3VWJP7A
6.25
31
3VWJX7A
6.25
35
3VWML7A
12.5
71
4A31K2D
7.5
52
4A31K3D
21.5
200
4A37L2E
6.25
34
4A4JM2A
6.25
40
4JGBF2F
22.75
194
4JGCB2F
7.5
62
4JGDA0E
9
66
4JGDA2E
7.5
82
4T1BB3E
6.25
41
4T1BD1E
16.5
198
4T1BD1F
27.75
283
4T1BF1F
28
233
4T1BF3E
13.75
126
4T1BK1E
13.75
191
4T1BK3D
6.25
50
4T3BA3B
9
75
4USBT33
7.5
54
4USBT53
6.25
120
4USBU53
10.25
84
4USCN33
6.25
100
4USDU53
6.25
45
55SWF4J
6.25
130
5BZAF0A
7.5
76
5BZBF0A
16.5
182
5FNRL3H
7.5
88
5FNYF3H
21.5
197
5FPYK1F
12.5
170
5FRYD3H
31.25
260
5FRYD4H
12.5
140
5GADT13
6.25
41
5GADX33
7.5
65
5GAER13
6.25
135
5GAEV13
12.5
145
5GAKRBK
12.5
203
5GAKRCE
6.25
37
5GAKRDK
6.25
92
5GAKVDK
7.5
87
5GALVBE
7.5
91
5GALVCE
9
73
5GNRNJE
6.25
116
5J6TF1H
12.5
147
5J6TF2H
7.5
47
5J6YH1H
10.25
120
5J8TB1H
6.25
119
5J8TB2H
10.25
99
5J8TB3H
16.5
129
5J8TB4H
49
504
5LMJJ2H
9
85
5LMJJ3J
7.5
75
5N1AA0N
18.75
308
5N1AN0N
35.75
307
5N1AR1N
12.5
139
5N1AR2M
21.25
174
5N1AT2M
15.25
107
5N1AZ2M
25.5
249
5N1CR2M
7.5
86
5NPDH4A
6.25
100
5NPE24A
6.25
56
5NPEB4A
12.5
166
5TDBCRF
6.25
124
5TDBW5G
6.25
29
5TDDK3D
13.75
107
5TDDK4C
6.25
41
5TFAW5F
15.25
190
5TFBW5F
6.25
128
5TFBY5F
6.25
89
5TFCM5F
7.5
95
5UXFA13
7.5
87
5UXFA93
12.5
181
5UXFB93
7.5
62
5UXFE8C
9
60
5UXFG43
6.25
33
5UXWX7C
6.25
116
5UXXW3C
6.25
113
5UXZV4C
21.5
225
5UXZV8C
6.25
107
5UXZW0C
6.25
48
5XXGM4A
15.25
117
5XYKT3A
9
64
5YMGZ0C
12.5
206
JA32U1F
9
81
JA32X8H
12.5
78
JA4AS2A
12.5
94
JH4CL95
29
294
JH4CU26
6.25
86
JH4CU2E
12.5
225
JH4CU2F
12.5
146
JH4DB76
9
78
JH4DC23
10.25
107
JH4DC43
6.25
104
JH4DC44
6.25
45
JH4DC53
42.5
355
JH4DC54
20
143
JH4KA96
15.25
104
JH4KB16
20
233
JH4NA12
12.5
147
JH4NA21
26.25
243
JHMFA3F
12.5
69
JHMFB4F
6.25
98
JHMZE2H
7.5
93
JHMZF1C
29
237
JHMZF1D
6.25
112
JM1BL1L
6.25
41
JM1CW2B
6.25
116
JM1DE1H
29
295
JM1GJ1T
7.5
88
JM1NC2E
15.25
114
JM1NC2J
6.25
122
JM1NC2L
6.25
104
JM1NC2M
7.5
52
JM1NC2P
9
74
JM3KE2B
19.25
174
JM3TB2B
6.25
39
JN1AJ0H
12.5
137
JN1AY1A
24
198
JN1AZ4E
45
636
JN1BV7A
13.75
169
JN1BY0A
7.5
68
JN1BY1P
16.5
114
JN1CV6A
20
227
JN1CV6E
20
211
JN1CV6F
25
289
JN8AE2K
27.75
181
JN8AF5M
55.25
462
JN8AS5M
12.5
204
JN8AZ1M
12.5
170
JN8AZ2K
31.25
418
JN8AZ2N
6.25
35
JTDBT4K
6.25
38
JTDJTUD
6.25
105
JTDKDTB
45
745
JTDKN3D
33.75
424
JTDKTUD
13.75
206
JTDZN3E
33
302
JTEBU4B
18.75
96
JTEBU5J
43
379
JTHBB1B
6.25
28
JTHBE1K
9
75
JTHBE5C
7.5
87
JTHBK1E
6.25
134
JTHBK1G
9
88
JTHBL1E
13.75
195
JTHBL5E
6.25
38
JTHBP5C
21.5
212
JTHDU1E
9
80
JTHFE2C
15.25
106
JTHKD5B
16.5
140
JTJBC1B
30.25
310
JTJBM7F
25
187
KL4CJBS
9
84
KL4CJES
6.25
29
KL4CJHS
15.25
192
KM8JT3A
6.25
113
KM8NU4C
6.25
113
KMHDB8A
7.5
91
KMHEC4A
13.75
134
KMHFC4D
7.5
74
KMHFG4J
12.5
171
KMHGC4D
29
248
KMHGH4J
6.25
113
KMHHT6K
37.5
441
KMHTC6A
41.5
403
KNADH4A
24
218
KNADH5A
10.25
95
KNADM4A
6.25
131
KNAFT4A
12.5
140
KNAFU6A
12.5
237
KNAFX5A
6.25
34
KNAGG4A
6.25
105
KNAGM4A
6.25
138
KNALW4D
6.25
110
KNDJT2A
9
48
KNDMA5C
7.5
81
KNDMG4C
6.25
103
KNDPB3A
6.25
40
ML32A3H
6.25
105
NM0KS7D
9
73
SAJWA2G
7.5
75
SAJWA4F
9
57
SAJWA4G
6.25
102
SAJWA4H
6.25
116
SALAB2D
6.25
28
SALAB2V
6.25
37
SALAG2D
12.5
154
SALCT2B
9
72
SALFR2B
13.75
173
SALGS2T
6.25
34
SALVP1B
7.5
68
SALVP2B
6.25
112
SALWG2V
6.25
32
SCBBB7Z
6.25
36
SCBBP93
10.25
80
SCBBR53
6.25
53
SCBBR9Z
6.25
111
SCBCR63
12.5
133
SCBDC47
6.25
128
SCBDC4B
6.25
115
SCBEC9Z
6.25
35
SCBET9Z
6.25
90
SCBFH7Z
9
52
SCBGC3Z
6.25
38
SCBGU3Z
6.25
123
SCBLC43
24
229
SCBLC47
6.25
34
SCBLE37
6.25
118
SCBLE47
6.25
32
SCBLF34
13.75
118
SCBLF44
16.5
160
SCFAB05
7.5
66
SCFAD22
6.25
38
SCFBF03
21.5
251
SCFBF04
9
59
SCFEBBA
6.25
38
SCFEBBB
24.25
251
SCFEBBE
6.25
34
SCFEFBB
21.5
251
SCFFDAB
6.25
46
SCFFDCB
9
60
SCFFDCC
18.75
185
SCFHDDA
6.25
51
SCFPDCG
7.5
61
TRUDD38
9
51
TRURD38
7.5
83
TRUSC28
6.25
116
TRUTC28
7.5
53
TRUVD38
6.25
105
TRUWT28
20
248
VNKJTUD
6.25
29
WA1AGAF
7.5
56
WA1AY94
10.25
79
WA1CFBF
6.25
25
WA1CGAF
9
62
WA1CGBF
6.25
35
WA1CKBF
6.25
41
WA1CM74
7.5
74
WA1CMAF
13.75
114
WA1CYAF
6.25
134
WA1DGAF
12.5
163
WA1DGBF
9
49
WA1DMAF
16.5
203
WA1EFCF
10.25
105
WA1EV74
9
80
WA1EV94
6.25
26
WA1EY74
10.25
104
WA1KK98
6.25
108
WA1LFAF
17.75
137
WA1LGAF
6.25
120
WA1LGBF
6.25
31
WA1LKAF
6.25
128
WA1LMAF
7.5
70
WA1LMBF
6.25
44
WA1UFAF
12.5
64
WA1VFAF
6.25
53
WA1VKBF
7.5
93
WA1VMAF
6.25
48
WA1VMBF
6.25
110
WA1WGAF
12.5
167
WA1WKBF
10.25
100
WA1WMAF
13.75
132
WA1WMBF
6.25
114
WA1YD64
7.5
71
WAU2GBF
6.25
35
WAU4FAF
7.5
75
WAU4GAF
9
65
WAUAF48
10.25
93
WAUAF68
6.25
88
WAUAF78
22.75
221
WAUAFAF
26.75
256
WAUAT48
6.25
106
WAUAVAF
15.25
194
WAUBF78
24
196
WAUBF98
15
151
WAUBFAF
12.5
146
WAUBGAF
6.25
108
WAUBH64
6.25
55
WAUBNBF
6.25
47
WAUBT48
7.5
89
WAUBVAF
6.25
36
WAUCFAF
33.75
333
WAUCH74
6.25
37
WAUCVAF
6.25
129
WAUDF48
6.25
47
WAUDF68
6.25
95
WAUDF78
12.5
226
WAUDF98
9
81
WAUDFAF
31.75
226
WAUDFBF
13.75
175
WAUDG68
6.25
126
WAUDG78
6.25
104
WAUDGAF
12.5
153
WAUDGBF
16.5
229
WAUDH78
18.75
286
WAUDK78
9
54
WAUDL54
6.25
47
WAUDV94
6.25
38
WAUEF98
15
168
WAUEFAF
55.25
503
WAUEFBF
18
129
WAUEG78
6.25
47
WAUEH48
6.25
130
WAUEH78
13.75
115
WAUEKAF
12.5
204
WAUEL74
6.25
26
WAUET48
12.5
255
WAUFEAF
7.5
84
WAUFFAF
21.5
261
WAUFFBF
15.25
114
WAUFMBF
6.25
118
WAUGGAF
12.5
150
WAUGGBF
7.5
56
WAUGL58
15.25
113
WAUGL68
6.25
47
WAUGL98
31.75
274
WAUGN94
9
60
WAUGU54
9
63
WAUHE78
6.25
120
WAUHF78
6.25
110
WAUHF98
29
372
WAUHFAF
28.75
311
WAUJC68
25.5
187
WAUJF98
9
81
WAUJFAF
6.25
109
WAUJGAF
6.25
30
WAUJGBF
6.25
41
WAUJT68
7.5
62
WAUKD98
9
63
WAUKF98
6.25
92
WAUKFBF
18
167
WAUKGBF
6.25
90
WAUKH78
18.75
262
WAUKH98
12.5
81
WAULC58
6.25
43
WAULC68
6.25
113
WAULD54
6.25
137
WAULFAF
6.25
44
WAULK78
6.25
96
WAULK98
12.5
128
WAULT58
47.75
444
WAULT64
9
97
WAULT68
6.25
129
WAULV44
6.25
104
WAULVBF
6.25
124
WAUMF68
12.5
120
WAUMFAF
58.25
706
WAUMGAF
6.25
27
WAUMGBF
7.5
55
WAUMK78
6.25
56
WAUMR94
10.25
95
WAUNE78
6.25
31
WAUNF68
7.5
71
WAUNF78
15.25
184
WAUNF98
6.25
26
WAUPFAF
6.25
28
WAUPL58
6.25
78
WAUR2AF
6.25
35
WAURD68
6.25
99
WAURGAF
7.5
88
WAURVAF
20
307
WAUSF78
6.25
113
WAUSF98
20
130
WAUSFAF
6.25
38
WAUSG78
6.25
95
WAUSH74
6.25
35
WAUSH78
12.5
250
WAUSH94
6.25
35
WAUSH98
10.25
99
WAUUL58
10.25
78
WAUUL78
20
140
WAUVC58
13.75
167
WAUVC68
12.5
121
WAUVF98
6.25
48
WAUVFAF
6.25
96
WAUVT58
18.75
274
WAUVT68
12.5
75
WAUVVAF
15.25
178
WAUWFAF
9
61
WAUWFBF
6.25
119
WAUWG94
7.5
56
WAUWKAF
6.25
38
WAUXU64
12.5
95
WAUYGAF
6.25
29
WAUYGBF
6.25
127
WBA1F7C
6.25
105
WBA3A5C
12.5
96
WBA3A9C
6.25
38
WBA3B3C
6.25
97
WBA3B3G
7.5
88
WBA3B5C
6.25
26
WBA3B5G
10.25
102
WBA3B9C
15.25
193
WBA3B9G
10.25
100
WBA3C1C
12.5
94
WBA3C3C
6.25
46
WBA3C3G
6.25
29
WBA3D3C
6.25
39
WBA3N3C
6.25
119
WBA3N5C
10.25
102
WBA3R1C
15.25
104
WBA3T1C
10.25
98
WBA3T3C
6.25
34
WBA3T7C
6.25
107
WBA3V5C
6.25
118
WBA3V7C
6.25
95
WBA3X9C
9
62
WBA4A5C
10.25
94
WBA5B1C
6.25
96
WBA5M0C
6.25
80
WBA5M6C
9
78
WBA6A0C
6.25
37
WBA6B2C
13.75
122
WBAAN37
10.25
97
WBAAV33
7.5
84
WBAAV53
6.25
27
WBAAX13
7.5
71
WBAAZ33
6.25
106
WBABD33
6.25
33
WBABS53
6.25
106
WBABV13
7.5
86
WBABW33
6.25
110
WBABW53
6.25
31
WBADN53
16.5
172
WBADT43
9
85
WBADT53
7.5
87
WBADW3C
6.25
119
WBADW7C
6.25
129
WBADX1C
6.25
116
WBADX7C
6.25
44
WBAEB53
9
61
WBAEH13
6.25
101
WBAEK13
12.5
105
WBAEK73
15.25
110
WBAEN33
15
123
WBAEP33
15.25
185
WBAEU33
13.75
161
WBAEV33
13.75
181
WBAEV53
9
67
WBAEW53
7.5
47
WBAFA53
6.25
96
WBAFR7C
18
144
WBAFR9C
10.25
94
WBAFU9C
6.25
107
WBAFV3C
6.25
49
WBAGH03
9
81
WBAGK93
6.25
108
WBAGL63
6.25
53
WBAGL83
9
83
WBAGN63
6.25
117
WBAHN03
7.5
74
WBAHN83
6.25
122
WBAKB0C
6.25
87
WBAKE5C
10.25
84
WBAKG7C
6.25
94
WBAKP9C
6.25
97
WBALL5C
12.5
74
WBALW7C
10.25
105
WBALX3C
7.5
65
WBALZ3C
6.25
32
WBANE53
6.25
38
WBANF33
6.25
121
WBANN73
6.25
94
WBANU53
6.25
37
WBANU5C
16.5
146
WBANV13
6.25
35
WBANV93
7.5
74
WBAPH5C
13.75
168
WBAPH77
9
57
WBAPH7C
6.25
105
WBAPH7G
7.5
55
WBAPK5C
13.75
213
WBAPL33
10.25
77
WBAPN73
9
63
WBASN0C
6.25
106
WBASP0C
13.75
163
WBAUC7C
6.25
31
WBAUN13
15.25
184
WBAUN1C
6.25
37
WBAUN7C
27.5
298
WBAUN93
6.25
113
WBAUP9C
6.25
123
WBAUT9C
6.25
37
WBAVA33
6.25
41
WBAVB33
6.25
44
WBAVC53
29
262
WBAVC73
6.25
48
WBAVT13
6.25
93
WBAVT73
7.5
62
WBAWB33
7.5
56
WBAWB73
13.75
192
WBAWC3C
7.5
88
WBAWC7C
6.25
42
WBAWL13
6.25
40
WBAWR33
9
82
WBAXA5C
6.25
121
WBAXH5C
6.25
56
WBAYA8C
9
81
WBAYB6C
6.25
31
WBAYE8C
9
61
WBAYG6C
6.25
120
WBAYP9C
6.25
32
WBS3C9C
15
152
WBSBL93
22.75
336
WBSDE93
7.5
81
WBSKG9C
6.25
47
WBXPA93
12.5
194
WBXPC93
6.25
114
WDBWK5J
10.25
78
WDCGG0E
6.25
32
WDCYC3H
31.75
319
WDCYC7D
9
87
WDDDJ7C
6.25
119
WDDEJ7G
6.25
31
WDDEJ7H
9
61
WDDEJ9E
6.25
109
WDDGF4H
82
876
WDDGF5E
10.25
80
WDDHF0E
6.25
120
WDDHF2E
12.5
152
WDDHF5K
6.25
51
WDDHF7G
6.25
113
WDDJK6F
6.25
99
WDDLJ6H
10.25
105
WDDLJ9B
6.25
116
WDDNG7B
6.25
113
WDDNG9F
6.25
127
WDDPK4H
18.75
229
WP0AA2A
45
545
WP0AB2A
18.75
322
WP0AD2A
10.25
98
WP0CA2A
13.75
89
WP1AE2A
21.25
204
WUADUAF
30.5
303
WUARU98
6.25
43
WUAUUAF
19.25
158
WUAW2AF
6.25
54
WUAW2BF
15.25
193
WUAYU48
6.25
90
WVGAV3A
9
67
WVGAV7A
18.75
162
WVGEF9B
15.25
162
WVGEP9B
9
49
WVGFF9B
6.25
38
WVWAA7A
7.5
55
WVWAB7A
17.75
144
WVWAN7A
20
257
WVWAP7A
6.25
107
WVWBN7A
9
81
WVWED7A
6.25
109
YV126MF
29
291
YV1382M
16.5
163
YV140MA
9
67
YV1672M
15.25
120
YV1902F
12.5
153
YV1952A
7.5
66
YV1960B
18
137
YV1982B
6.25
118
YV426MD
7.5
72
YV4902D
12.5
62
YV4940B
6.25
50
YV4952C
13.75
168
ZHWGU6B
7.5
73
time_node_1
HH:mm:ss
time_node_1_0
Convert time_node_1 From:
HH:mm:ss
time_node_2
HH:mm:ss
time_node_2_0
Convert time_node_2 From:
HH:mm:ss
time_node_3
HH:mm:ss
time_node_3_0
Convert time_node_3 From:
HH:mm:ss
time_node_4
HH:mm:ss
time_node_4_0
Convert time_node_4 From:
HH:mm:ss
time_node_5
HH:mm:ss
time_node_5_0
Convert time_node_5 From:
HH:mm:ss
time_node_6
HH:mm:ss
time_node_6_0
Convert time_node_6 From:
HH:mm:ss
Remove
Suffix
_0
Warn
Segment
Last
C:\Users\abrou\AppData\Local\Temp\Engine_3232_4d9a4fe65d6e4e45bd41105ee762afa2_\Engine_9908_11804fbc661a4b58971a049ba39b961f_.yxdb
Single
Profile
Warn
Simple
IsNotNull
Value
True
fixed
2020-02-18 13:09:02
0
2020-02-18 13:09:02
2020-02-18 13:09:02
!IsNull([Value])
id
Trip
V_String
6
NULL
[Row-1:Name]+","+[Name]
[Row-1:Name]+","+[Name]
Out
C:\Users\abrou\AppData\Local\Temp\Engine_3232_4d9a4fe65d6e4e45bd41105ee762afa2_\Engine_9908_ba7678b8adc34044b7041e6a9bd187a4_.yxdb
Single
Profile
Old
C:\Users\abrou\AppData\Local\Temp\Engine_5164_a55dbc358efb49e1b4d9e3145f0c3b0a_\Engine_9908_01c32ec4bb714637a75e423d3041eff3_.yxdb
Single
Profile
All
_Delta_1
Suffix
DateTimeDiff([_CurrentField_],[time_node_1],"min")
DateTimeDiff([_CurrentField_],[time_node_1],"min")
All
_Delta_2
Suffix
DateTimeDiff([_CurrentField_],[time_node_2],"min")
DateTimeDiff([_CurrentField_],[time_node_2],"min")
All
_Delta_3
Suffix
DateTimeDiff([_CurrentField_],[time_node_3],"min")
DateTimeDiff([_CurrentField_],[time_node_3],"min")
All
_Delta_4
Suffix
DateTimeDiff([_CurrentField_],[time_node_4],"min")
DateTimeDiff([_CurrentField_],[time_node_4],"min")
All
_Delta_5
Suffix
DateTimeDiff([_CurrentField_],[time_node_5],"min")
DateTimeDiff([_CurrentField_],[time_node_5],"min")
Total Time = [time_node_2_Delta_1]+[time_node_3_Delta_1]+[time_node_4_Delta_2]+[...
"time_node_2_Delta_1","time_node_3_Delta_1","time_node_4_Delta_2","time_node_5_Delta_2","time_node_4_Delta_3","time_node_5_Delta_3","time_node_5_Delta_4","time_node_6_Delta_4","time_node_6_Delta_5"
True
True
True
False
False
False
False
False
False
upper
C:\Users\abrou\AppData\Local\Temp\Engine_5164_a55dbc358efb49e1b4d9e3145f0c3b0a_\Engine_9908_ddf82e681f2b4fcc93cd7fd1138d4eb8_.yxdb
Single
Profile
Horizontal
Challenge_202_solution_file - AJB