

Team Wilson Rides
A weekly worksheet that shows a senior ride program how new volunteers and new riders change its room to serve.
Wilson Rides gives Wilson County seniors 55+ who no longer or seldom drive a way to get to medical appointments, the grocery store, the pharmacy, the polls, and more, and also offers free rides to veterans.
How many seniors it can bring on from its waiting list depends on how many volunteer drivers are available, and today that math is worked out by hand each month.
This project builds a simple calculator that lets a scheduler enter the month's volunteer numbers and see how many new riders the organization can safely take on, so more seniors get rides without overloading drivers.
The team's showcase: their solution to the brief above.
Wilson Rides gives adults 55 and over in Wilson County rides to medical visits and errands, with volunteer drivers. Their question: "We added five drivers this week. How many people can we take off the waiting list?" They answered it with a rule of thumb: 2.5 riders per new volunteer.
What we found: We analyzed a year of their trip records to see what each change uses or adds. Rides given matched rides requested every month, so the records can't show spare room. A new driver gives about 3 one-way rides a month in their first months, and a new rider takes about 3, so one new driver covers about one new rider. A dialysis rider uses the room of about 6 non-dialysis riders. Last year 60 drivers started. The old rule would have allowed 150 riders; the measured rate gives about 60; they actually took on 67.
What we built: A Google Sheet the staff can fill in once a week, in about 5 minutes: drivers who started or stopped, riders added or who left, and the open rides for next week from their scheduling software. A small ledger at the top adds it up over the last 3 months: room added by drivers, room used by riders, and the change. It reports data neutrally and leaves the decision to staff. The open-rides count is the weekly strain check; the scheduler can watch it over time as a sign of strain. A Settings tab holds the five rates with their sources, and a "How we got the rates" tab recalculates each one from the counts, so anyone can check it.
Why a spreadsheet: No budget, no developer, nothing to install. They can open, read and change every formula. We considered an AI forecaster and chose not to build one: it would have the same blind spot, give answers that can drift, and potentially send rider data outside the organization.
What's next: hand the Sheet over to a Wilson Rides account. Refresh the rates once a year/periodically.