Challenge #203: Everyone loves a toll booth

[AYXAcademy]

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].

Source: GIPHY

[Aaron_Harter]

I was not able to match the total time result... looking forward to seeing some other solutions:

Spoiler

*edit at 1 PM CST to add video of solution design:

Spoiler

[Blake]

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. 

Spoiler

I have included a .yxdb with the times/tolls that I calculated. 

[RolandSchubert]

It looks like the time doesn't quite fit in the result ...

Spoiler

[rmassambane]

Spoiler

It isn't the same as the official answer...but it's mine. 😃

[abrouwer]

My time calculation isn't calculating the total time correctly, but my solution is attached.

Spoiler

[OllieClarke]

I disagree with how the times were totalled (as some others do too it seems)

Spoiler

The solution seemed to ignore the final toll time, which my method included as the driver is still on the road up until then

Here's my solution

Spoiler

Spoiler

[JORGE4900]

Just like everyone else, the time does not match. However, I believe that the calculation is correct.

Spoiler

[hbraunius]

My solution attached.

I also had a hard time matching with the answer set. I have two outputs, one that matches and one I think is more accurate.

[sonyakasenkramer]

I agree with previous posters about the time calculation.

Spoiler