(29 Sep 2015, 5:39 pm)Andreos1 wrote Got to admire the work you put into these DaveyB.
Must have taken you hours!
To be honest, the actual production ain't too bad. It's more working the following out that's a bit of a headache:
- Morning Peak Time runs.
- Afternoon Peak Time runs.
- Evening and Sunday journeys.
- Total PVR.
The times where they don't change much can be done in bulk using =REF+TIME(hh,mm,ss) etc. The afternoon peak times were the ones that gave me the most headaches working out what to do with the 310s as although I didn't want to dock the full PM NCL bound journeys to half hourly, I wanted to try and keep the 309 / 310 relatively frequent in the afternoons unlike now where they're being cut upto every 30-35 minutes between Norham Rd and Newcastle as well as between Blyth and Cobalt. Also, there were some daft times of the 309 that I wanted to stamp out such as:
- No buses to Cobalt for 8am starts unless waiting around for 30 mimutes (excluding X39).
- 25 minute gap on Saturday mornings.
- Journey that positions from Blyth to Newcastle as a 309 then takes the 1930 310 to Shields.
- Journey leaving Whitley Bay Cemetery at 2228 on a Sunday night? (Who would want to use that!)
- Later journey to Blyth on a Saturday than what there is on a Monday to Friday evening.