09-27-2023, 01:27 PM
(09-16-2023, 03:57 PM)tomh009 Wrote: Pre-pandemic, peak monthly LRT ridership was 410K in November 2019, which equates to roughly 14K boardings per day.
See the Power BI dashboard here:
https://www.grt.ca/en/about-grt/performa...sures.aspx
That's the average daily boardings over a month if you don't differentiate between week days, Saturdays, and Sundays/holidays.
Thanks to past email conversations with Blair Allen, a good rule of thumb is to count Saturdays as 60-75% of a weekday and Sundays and holidays as 40-50% of a weekday.
For ease of calculation in a spreadsheet where I can use functions to get the number of weekdays, Saturdays, and Sundays but not holidays, I do Nᵥᵥ*1 + Nₛ*2/3 + Nₕ/2 and then subtract 2/3 for a holiday and I am no more than +/- 0.5 days off.
In Google Sheets that becomes
=NETWORKDAYS($D2,$E2)+NETWORKDAYS.INTL($D2,$E2, "1111101")*(2/3)+NETWORKDAYS.INTL($D2,$E2, "1111110")*0.5-2/3
For November 2019 that's 25.667 days and 530,000 / 25.667 = ~20,649 weekday riders. The +/-0.5 day error would make that a range of 20,254 to 21,059.
I keep track of the numbers (and have been for several years).
https://docs.google.com/spreadsheets/d/1...sjEnTmPhGY
LRT boardings bottomed out in January 2021, similarly recovering in fits and starts. There obviously wasn't a full year of LRT data before the pandemic, but so far I have no reason to believe that it will not follow the broadly U-shaped pattern of GRT with highs in January & November and a low in August.
Bus boardings bottomed out in April 2020 and have recovered in fits and starts, and appear to have resumed the "traditional" yearly curve in August 2022.
As of July, we are at +8.82% relative to the same point in 2019. GRT's stats update are close to 3 months behind, as of late being don at the end of the third full week in the month for M-2.