Skills and Roles Capacity Planner

Skills & Roles Capacity Planner

Know who can do what, who is stretched, and where the gaps are — in one workbook.

Most capacity tools tell you how busy people are. This one tells you whether you have the right skills in the first place. Rate every person against every skill, map skills to roles, and the workbook shows you role coverage, single points of failure, and where a resignation would hurt.

What's inside

• Skills matrix — rate each person against each skill, with proficiency levels you define
• Role coverage — which roles are properly covered and which rest on one person
• Capacity vs demand — planned work against available hours, so overload shows before it bites
• Gap analysis — the skills you are short of, ranked
• Development planning — who to train in what, and the coverage it would buy you
• Dashboard — the whole picture on one screen, updating automatically

How it works

Enter your people and skills on the setup sheets. Everything else calculates. No macros, no add-ins, no subscription — a normal Excel file that opens on any version of Excel and keeps working forever.

Built in Australia from more than twenty years of program delivery experience. Instant download, yours to keep, use it on as many projects as you like.