NEEV
Products · 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

Contact
Transit adminSample data
Transit's Today Staff Scans on sample data: each QR scan with bus, staff name, boarding point and boarding time.Transit's staff scans for today on sample data: each person's bus, boarding point and boarding time, scanned by QR code.
  1. 01Which stops is Bus 01 skipping today, and which bus picks them up?
  2. 02Which buses came in late this morning, and by how much?
  3. 03Who actually got on which bus today?
01

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

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

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

Three places. One question.

  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.
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
02

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

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

Transit adminSample data
Transit's Late Buses screen on sample data: inbound buses that arrived after their shift's time, by shift, with gate and minutes late.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.
Before

One register. Every morning.

  1. Find the gate register.
  2. Read the guard's handwriting.
  3. Check each time against its shift.
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
03

Who actually got on which bus today?

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

Transit adminSample data
Transit's Today Staff Scans on sample data: each QR scan with bus, staff name, boarding point and boarding time.Transit's staff scans for today on sample data: each person's bus, boarding point and boarding time, scanned by QR code.
Before

A stack of paper. One question.

  1. Collect the attendance sheets from each bus.
  2. Type them into the workbook.
  3. Chase the ones that went missing.
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

See Transit on your own work.

Email us for a walkthrough.

StudioContact