A solution to last week's challenge can be found here!
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].
I was able to get the same solution as what is given but I think that the methodology used to get it is off. The "total time" driven by each driver seems to have the last value dropped/not added to the total.
The container in yellow shows how to solve for the given solution, the containers above the yellow one give what I think is the "true" answer.
I have included a .yxdb with the times/tolls that I calculated.
My time calculation isn't calculating the total time correctly, but my solution is attached.
Just like everyone else, the time does not match. However, I believe that the calculation is correct.
