Challenge #203: Everyone loves a toll booth

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

Challenge_203_start_file.yxzp

challenge_202_solution.yxzp

Parse

Join

Preparation

Advanced

Data Analysis

Intermediate

Transform

Accepted answers

All comments

Elias_Nordlinder

Here is my solution, good challenge!

Spoiler

Weekly_Challenge_203_EN.yxmd

SumedhaGarg

Hi all,

I think the time calculated in the solution is wrong. I manually calculated some of the time from answer sheet and they do not match. My total time is also not the most accurate as i have ignored the seconds difference otherwise its the most accurate i could get.

Challenge_203_sumedha.yxmd

Amin

Spoiler

Time unit: Minutes
Each record probably means a different day - that's something to be considered when solving this.

Good challenge!

Challenge_203_Aminyxmd.yxmd

suyash0807

Getting different answers too!

Challenge_203_start_file.yxzp

Another fun challenge!

Spoiler

Challenge_203_EW.yxzp

tferenc007

My Solution

Challenge_202_TF.yxzp

scoles0617

My solution:

Challenge_203_start_file.yxmd

Watermark

Spoiler

Challenge_203_MT_Solution.yxmd

davidhardister

Challenge_203_start_file.yxmd

leozhang2work

Spoiler

Challenge_203_LiuZhang.yxzp

alexnajm

Great challenge!

Spoiler

challenge_203_start_file_Alex Abi-Najm.PNG

Challenge_203_start_file_Alex Abi-Najm.yxmd

SylwiaDragon

Done

Challenge_203_SD.yxmd

mpennington

I'm not sure I agree on loving toll booths, but a fun problem, nevertheless.

Spoiler

Challenge_203_MP.yxmd

TonyAndriani

Reposting under my new user ID.

Challenge_203_TonyA.yxmd

binu_acs

solution attached

Challenge_203_solution_BV.yxmd

mmontgomery

Challenge #203

c_203.yxzp

JamesCharnley

Spoiler

Wasted a bunch of time hunting around rounding and floors of time to try and fit output before checking the comments to see others saying similar. Confident in the logic.

Challenge 203 Zipped.yxzp

DataNath

My solution to #203.

Spoiler

Challenge 203 completed.yxmd

ChrisMelck

Solved

Challenge_203_finish.yxmd

CHarrison

My solution

Challenge_203_start_file.yxzp

gabrielpereira

Solution

Challenge_203_Gabriel.yxmd

James_Driver9

Spoiler

Challenge_203_Complete.yxmd

ARussell34

Went back through to correct that if they were in-between nodes 1,2 and then 4,6 they were also in-between 2,4. I went back in to account for those instances to update the toll totals and found the solution.