NEEV
Projects · Bus and fleet operators

Transit

Routes, stops and daily changes for operators running college and staff buses — in two languages, on the driver's phone.

In daily use on a university campus
Problem 1 of 3

Which stops is Bus 01 skipping today, and which bus picks them up?

To answer it today
  1. Open route final (2).xlsx.
  2. Read last night's WhatsApp group for changes.
  3. Ring the driver, because you still aren't sure.

TodayThree places. One question.

NowOn the bus itself: which stop moved, and to which bus.

Transit's temporary edits on sample data: Bus 01 with Genda Circle moved to Bus 09 and Chhani Jakatnaka added from Bus 04.
route final (2).xlsx4 tabs · last edited 23:47
C7fx=VLOOKUP(B7,'Copy of route final'!A:C,3,0)
ABCDE1BusStopTimeDriverNote21Stop A6:45Driver 131Stop B6.55Driver 141Stop C07:05Driver 151Stop D7:12driver 161stop a6:45Driver 1pasted twice?71Stop E#REF!Driver 18TEMPtoday stop C offtell parents
Sheet1routeroute finalCopy of route final

Three places. One question.

route final (2).xlsx4 tabs · last edited 23:47
C7fx=VLOOKUP(B7,'Copy of route final'!A:C,3,0)
ABCDE1BusStopTimeDriverNote21Stop A6:45Driver 131Stop B6.55Driver 141Stop C07:05Driver 151Stop D7:12driver 161stop a6:45Driver 1pasted twice?71Stop E#REF!Driver 18TEMPtoday stop C offtell parents
Sheet1routeroute finalCopy of route final
To answer it now

On the bus itself: which stop moved, and to which bus.

Transit adminSample data
Transit's temporary edits for Bus 01 on sample data: Genda Circle removed and moved to Bus 09, Chhani Jakatnaka added from Bus 04.
Problem 2 of 3

Which buses came in late this morning, and by how much?

To answer it today
  1. Find the gate register.
  2. Read the guard's handwriting.
  3. Check each time against its shift.

TodayOne register. Every morning.

NowEvery late bus, by shift, with how late and at which gate.

Transit's Late Buses screen on sample data: inbound buses that arrived after their shift's time, by shift, with gate and minutes late.
Gate register Oct.xlsxtyped up from the paper one
B7fx=D7-"07:30"
ABCDE1BusLateShiftInNote211111st7:413422first7.52traffic?4719ADM8:19am52gen9:06guard forgot6913gen8:5874#VALUE!1stillegiblesame bus twice?
OctSepguard 2

One register. Every morning.

Gate register Oct.xlsxtyped up from the paper one
B7fx=D7-"07:30"
ABCDE1BusLateShiftInNote211111st7:413422first7.52traffic?4719ADM8:19am52gen9:06guard forgot6913gen8:5874#VALUE!1stillegiblesame bus twice?
OctSepguard 2
To answer it now

Every late bus, by shift, with how late and at which gate.

Transit adminSample data
Transit's late buses on sample data: Bus 11 eleven minutes late and Bus 04 twenty-two minutes late on the first shift, Bus 07 nineteen minutes late on ADM/Medical.
Problem 3 of 3

Who actually got on which bus today?

To answer it today
  1. Collect the attendance sheets from each bus.
  2. Type them into the workbook.
  3. Chase the ones that went missing.

TodayA stack of paper. One question.

NowEvery boarding scanned at the door, with the stop and the time.

Transit's Today Staff Scans on sample data: each QR scan with bus, staff name, boarding point and boarding time.
Bus attendance wk 40.xlsx6 of 9 buses handed in
B6fx=COUNTIF(B:B,"Bus 1")
ABCD1NameBusStopNote2Asha P.1Akota3Rohan M4Karelibaug4KavyaBus 1Race Course5I. Sheikh9?not on sheet6#N/Abus 6 sheet lost
MonTueWedmissing

A stack of paper. One question.

Bus attendance wk 40.xlsx6 of 9 buses handed in
B6fx=COUNTIF(B:B,"Bus 1")
ABCD1NameBusStopNote2Asha P.1Akota3Rohan M4Karelibaug4KavyaBus 1Race Course5I. Sheikh9?not on sheet6#N/Abus 6 sheet lost
MonTueWedmissing
To answer it now

Every boarding scanned at the door, with the stop and the time.

Transit adminSample data
Transit's staff scans for today on sample data: each person's bus, boarding point and boarding time, scanned by QR code.

Your version of this question.

Different trade, same shape: something you already know, spread across files that don't agree with each other.

StudioTalk to us