Hi,
I have a table in PowerPivot of some 500 000 rows with different vehicle departure times, including deviations from schedule. There are a number of different route IDs (PathIdent), each route has a number of destinations (Location) where the vehicle stops. For each route there are also a number of voyages, maybe but not for sure with the same departure time (Departure). There are no voyage numbers but all rows for each voyage has the same planned departure date(Departure).
I would like to show deviation per route and location over time to determine where in the schedule we lose time. To do that I need to index each destination within each route so that I can sort them. The question – how do I do that in a PowerPivot table looking like the example below?
Brgds,
Caj
<tbody>
</tbody>
I have a table in PowerPivot of some 500 000 rows with different vehicle departure times, including deviations from schedule. There are a number of different route IDs (PathIdent), each route has a number of destinations (Location) where the vehicle stops. For each route there are also a number of voyages, maybe but not for sure with the same departure time (Departure). There are no voyage numbers but all rows for each voyage has the same planned departure date(Departure).
I would like to show deviation per route and location over time to determine where in the schedule we lose time. To do that I need to index each destination within each route so that I can sort them. The question – how do I do that in a PowerPivot table looking like the example below?
Brgds,
Caj
| PathIdent | Departure | PathDepLoc | Location | LocationStatus | TimeAtLocation | Deviation |
| 41761 | 2012-05-11 18:00 | HTG | Ros | Departure | 2012-05-11 18:27 | 0 |
| 41761 | 2012-05-11 18:00 | HTG | Tsg | Departure | 2012-05-11 19:03 | 0 |
| 41761 | 2012-05-11 18:00 | HTG | Åd | Departure | 2012-05-11 19:29 | 0 |
| 41615 | 2012-05-11 18:00 | KIL | Gms | Arrival | 2012-05-11 18:19 | -10 |
| 41615 | 2012-05-11 18:00 | KIL | Kil | Departure | 2012-05-11 18:00 | -12 |
| 41615 | 2012-05-11 18:00 | KIL | El | Departure | 2012-05-11 18:11 | -10 |
| 41761 | 2012-05-11 18:00 | HTG | Htg | Departure | 2012-05-11 18:00 | -58 |
| 41761 | 2012-05-11 18:00 | HTG | Fsm | Arrival | 2012-05-11 19:59 | 17 |
| 41720 | 2012-05-11 18:26 | SUC | Töv | Departure | 2012-05-11 18:37 | -168 |
| 41720 | 2012-05-11 18:26 | SUC | Vm | Departure | 2012-05-11 18:47 | -172 |
| 41720 | 2012-05-11 18:26 | SUC | To | Departure | 2012-05-11 19:19 | -173 |
| 41720 | 2012-05-11 18:26 | SUC | Nsö | Departure | 2012-05-11 18:54 | -172 |
| 41720 | 2012-05-11 18:26 | SUC | Åg | Departure | 2012-05-11 19:45 | -170 |
| 41720 | 2012-05-11 18:26 | SUC | Visk | Departure | 2012-05-11 19:16 | -174 |
| 41720 | 2012-05-11 18:26 | SUC | Åggb | Arrival | 2012-05-11 19:48 | -170 |
| 41720 | 2012-05-11 18:26 | SUC | Std | Departure | 2012-05-11 19:07 | -173 |
| 41720 | 2012-05-11 18:26 | SUC | Ft | Departure | 2012-05-11 19:26 | -174 |
| 41720 | 2012-05-11 18:26 | SUC | Jbg | Departure | 2012-05-11 19:30 | -173 |
| 41720 | 2012-05-11 18:26 | SUC | Ei | Departure | 2012-05-11 19:35 | -172 |
| 41720 | 2012-05-11 18:26 | SUC | Suc | Departure | 2012-05-11 18:26 | 0 |
| 41720 | 2012-05-11 18:26 | SUC | Vm | Arrival | 2012-05-11 18:42 | 0 |
| 41674 | 2012-05-11 20:15 | GMS | Gms | Departure | 2012-05-11 20:15 | 0 |
| 41674 | 2012-05-11 20:15 | GMS | El | Departure | 2012-05-11 20:24 | 0 |
| 41674 | 2012-05-11 20:15 | GMS | Kil | Arrival | 2012-05-11 20:32 | 0 |
<tbody>
</tbody>
