Skills & Availability Finder: Stop Guessing Who to Staff

The problem this kills

A new piece of work lands and the question is always the same: who can do this, and who is actually free to do it? So you open the skills spreadsheet, then the allocation tracker, then you ping three team leads, then you discover the person you wanted is already booked solid through the window you needed them for. By the time you've cross-referenced who has the skill, at what level, and who has any hours left, half a day is gone — and you've still only checked the people you happened to think of.

Staffing turns into a guessing game played from memory. The strong, available people get overlooked because nobody held the whole picture in their head, and the same overloaded few get tapped again because they're top of mind. Meanwhile the data you need is already sitting in your skills matrix and your availability sheet — it's just never been put side by side and ranked. You do not need to be a developer to build the thing that does that.

What you'll build

A simple internal web tool for whoever owns staffing. You import two things: your skills matrix (each person, each skill, and their level) and your allocations/availability (who's booked on what, and when). Then you enter a piece of work — the skills it needs and the dates it spans — and the tool does the cross-referencing for you. It finds the people who have the required skills, checks who actually has capacity in that window, and returns a ranked candidate list, weighting skill level, availability, and (optionally) rate. It flags people who technically qualify but are already near their work-in-progress or capacity limit. The staffing owner reviews the ranking, approves a pick behind a hard human gate, and the tool records a soft-book and exports a clean assignment CSV in the exact columns your system expects.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — how staffing works today and who owns it, the systems and spreadsheets behind your skills and availability data, the exact names you use for skills and skill levels, how you measure capacity (hours, days, percent allocated), your real ranking priorities, and the messy edge cases like part-timers, contractors, and people split across projects. It reads a short spec back to you for a thumbs-up, then builds the tool around your answers instead of a generic template. From there it walks the agent through the data model, the two CSV imports, the matching-and-ranking engine, the candidate review screen, the human approval gate, the soft-book record, and the assignment export. Every step ends with a ready-to-copy prompt.

The governance it includes (this is the point)

This isn't a toy. The plan builds in the controls a real resourcing function needs: login so only your team can use it, row-level security so people only see their own organization's data, a complete audit trail of every search, approval, and soft-book (who, what, when, and why), a hard human-approval gate so nothing is booked until the staffing owner signs off — the AI ranks, a person decides — and duplicate guards so the same person can't be soft-booked to the same piece of work twice. The whole tool exists to make a careful human staffing call fast and defensible.

Who it's for

Resource managers, staffing coordinators, and delivery leads who own who-goes-on-what and are tired of cross-referencing two spreadsheets and a dozen Slack pings to fill one slot. If you can describe what makes someone a good fit for a job in your world, you can build this.

You've got this — open the plan, paste the first prompt, and you'll be ranking your first real candidate list this weekend.