In my post on the previousRow logic I applied the logic that all columns can be perceived as lists and that we have access to all values via their positions written as Nth() in this list. Additionally we have access to items on row level making use of a RowIndex.
We continue this logic and apply it to TimeTables. We calculate first the duration between stops (which differs from standard calculations). We compare values based on previous rows. Secondly we create a running total over well defined parts.
From a technical point of view it is relevant to understand that a “Coda cell” can contain multiple lists. This in contrast with a spreadsheet. So not only is a cell part of a list (as an item in a list), but this cell can contain other lists. This logic permits a more advanced usage of a previousRow logic.
How do we set up a time table in a spreadsheet?
Below the calculation in Excel. You link the two cells and that is it. You see the time between the two breaks if we relate B11 and B4. It takes you 5 seconds and you see the result. That is very fast compared to the Coda calculation I am about to show.
