Hello,
I have the following problem:
The following load script:
BusTimeTable:
Load *,
BusNumber&StartJourney&EndJourney as KeyBusPax;
Load * inline
[
BusNumber, StartJourney, EndJourney, FromStation, ToStation, Section
201, A, B, A, B, None
201, B, C, B, C, None
201, A, C, A, B, 1
201, A, C, B, C, 2
202, A, C, A, C, None];
Travellers:
Load Traveller,
BusNumber&StartJourney&EndJourney as KeyBusPax;
Load * inline
[
Traveller, BusNumber, StartJourney, EndJourney
Jim, 201, A, B
Tom, 201, A, B
John, 201, A, C
Jane, 201, B, C
Daniel, 202, A, C];
generates this table:
| Traveller | BusNumber | StartJourney | EndJourney | FromStation | ToStation |
| Daniel | 202 | A | C | A | C |
| Jane | 201 | B | C | B | C |
| Jim | 201 | A | B | A | B |
| John | 201 | A | C | A | B |
| John | 201 | A | C | B | C |
| Tom | 201 | A | B | A | B |
I would like to compute the maximum number of occupied seats on a given bus (e.g. BusNumber 201) for a given Journey (e.g StartJourney = A; EndJourney = C) as follows:
1) Get all the lines with StartJourney A, EndJourney C and BusNumber 201, and get all the sections FromStation - ToStation with this Journey A C :
- Station 1 FromStation A-ToStation B
- Station 2 FromStation B- ToStation C
3) For each section, compute the number of Travelers on this bus, regardless of the StartJourney and EndJourney A-C:
- Station 1 FromStation A-ToStation B : 3 (Jim, John, Tom)
- Station 2 FromStation B- ToStation C: 2 (Jane, John)
4) Compute the max of these sections above : Max (3,2) = 3
==> The maximum number of occupied seats on a given bus (e.g. BusNumber 201) for a given Journey (e.g StartJourney = A; EndJourney = C) = 3
Thanks a lot
Annick
