Every youth program I've worked with runs on a tracker spreadsheet, and every tracker spreadsheet silently drops kids. Harbor Youth Collective and its Compass Fellows mentoring program are fictional (so is every name below), but their messy Google Sheet is a faithful recreation of the real thing — and this demo shows the way out of it.
Harbor Youth Collective tracks every fellow in a Google Sheet. Every site has its own tabs, its own color codes, and its own idea of what "active" means. Names get typo'd, mentors fall through the cracks, and nobody notices a stalled fellow until a check-in call three months late.
One shared database, one definition of "active," and an import wizard that reads a messy spreadsheet, explains every decision it makes, and flags anything that needs a human to look at it.
A roster everyone can filter and trust, a page for each fellow with a real timeline, and a dashboard that shows exactly which sites and fellows need attention this week — with a one-click board report.