Image 1 of 1
Image 1 of 1
Image 1 of 1
Image 1 of 1
Headcount planning in a spreadsheet without structure creates more confusion than clarity. This dashboard gives HR and leadership a clean, connected view of where the team is and where it is going.
Current Headcount sheet: full employee register by department, function, level, employment type, location, and cost centre. Hiring Plan sheet: open roles with priority colour-coding, target start dates, approval status, JD readiness, and hiring manager. Dashboard sheet: automatically aggregates current headcount, approved open roles, pending roles, and total planned headcount — then breaks them down by department.
FAQS
Q What are the three sheets and how do they connect?
Current Headcount: the employee register showing every person by department, function, level, employment type, location, and cost centre. Hiring Plan: the open role tracker with priority colour-coding (Critical/High/Medium/Low), target start dates, approval status, and hiring manager. Dashboard: automatically aggregates from both sheets to show current headcount, approved open roles, pending roles, and total planned headcount — broken down by department.
Q How does the priority colour-coding work?
Each open role in the Hiring Plan is assigned a priority: Critical (red — a blocking gap), High (amber — material impact if not filled on schedule), Medium (blue — important but not urgent), or Low (green — in plan but not time-sensitive). The priority cell is automatically colour-coded when you enter the priority text. This gives leadership a fast visual read on hiring urgency without needing to read every row.
Q Can this be used for budget and finance conversations?
Yes. The Dashboard is designed to provide the headcount data that Finance needs for people cost modelling — current headcount by department and planned headcount including open roles. For more detailed financial modelling, the data from this dashboard feeds naturally into a people cost model in a separate financial spreadsheet.
Q How does this connect to the Workforce Planning Framework?
The Workforce Planning Framework (sold as a Word document) provides the strategic planning methodology. The Headcount Planning Dashboard provides the operational tracking tool. The Framework tells you what headcount you need and why; the Dashboard tracks what you have and what you are hiring for.
Headcount planning in a spreadsheet without structure creates more confusion than clarity. This dashboard gives HR and leadership a clean, connected view of where the team is and where it is going.
Current Headcount sheet: full employee register by department, function, level, employment type, location, and cost centre. Hiring Plan sheet: open roles with priority colour-coding, target start dates, approval status, JD readiness, and hiring manager. Dashboard sheet: automatically aggregates current headcount, approved open roles, pending roles, and total planned headcount — then breaks them down by department.
FAQS
Q What are the three sheets and how do they connect?
Current Headcount: the employee register showing every person by department, function, level, employment type, location, and cost centre. Hiring Plan: the open role tracker with priority colour-coding (Critical/High/Medium/Low), target start dates, approval status, and hiring manager. Dashboard: automatically aggregates from both sheets to show current headcount, approved open roles, pending roles, and total planned headcount — broken down by department.
Q How does the priority colour-coding work?
Each open role in the Hiring Plan is assigned a priority: Critical (red — a blocking gap), High (amber — material impact if not filled on schedule), Medium (blue — important but not urgent), or Low (green — in plan but not time-sensitive). The priority cell is automatically colour-coded when you enter the priority text. This gives leadership a fast visual read on hiring urgency without needing to read every row.
Q Can this be used for budget and finance conversations?
Yes. The Dashboard is designed to provide the headcount data that Finance needs for people cost modelling — current headcount by department and planned headcount including open roles. For more detailed financial modelling, the data from this dashboard feeds naturally into a people cost model in a separate financial spreadsheet.
Q How does this connect to the Workforce Planning Framework?
The Workforce Planning Framework (sold as a Word document) provides the strategic planning methodology. The Headcount Planning Dashboard provides the operational tracking tool. The Framework tells you what headcount you need and why; the Dashboard tracks what you have and what you are hiring for.
