Headcount Summary
Live from Google Sheets · Headcount Summary by SMT
Total Employees
Current headcount
Hires Since April 1
New employees
Attrition Since April 1
Departed employees
Future Attrition
Projected departures
Top Line Target
…
Employee Activity
FTE · Click row to drill| SMT Leader | Start HC | Attrition | Hires | Current HC | Future Att. | Future Hires | Future HC | Open Reqs | Proj. HC | Top Line | Avail. to Hire | Pend. Reqs | Attainment |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||||||
Total Contingent Workers
Current headcount
CW Hires Since April 1
New CW
CW Attrition Since April 1
Departed CW
Current Combined Workforce
Current EE + Current CW
Future Combined Workforce
Future EE HC + Future CW HC
Contingent Worker Activity
CW · Click row to drill| SMT Leader | Start HC | Attrition | Hires | Current HC | Future Att. | Future Hires | Future HC | Open Reqs | Proj. HC |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
Employee Headcount by SMT
EE Attainment vs Top Line
Employee Detail
Full-time employee headcount · Live from Google Sheets
Total Employees
Current headcount
Hires Since April 1
New employees
Attrition Since April 1
Departed
Future Attrition
Projected departures
Net Change Since April 1
Hires minus attrition
Headcount by SMT
Click to drill| SMT Leader | Start HC | Attrition | Hires | Current HC | Top Line | Avail. | Attainment |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Headcount by Location
Click to drill| Location | Employees | % of Total | Distribution |
|---|---|---|---|
| Loading… | |||
Top Line Attainment & Headroom
| SMT Leader | Current HC | Top Line | Open Reqs | Pending Reqs | Available to Hire | Net Headroom | Capacity Used |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Movement Since April 1
Hires Since April 1 by SMT
Attrition Since April 1 by SMT
Contingent Worker Detail
Contingent worker headcount · Live from Google Sheets
Total CW
Current headcount
Hires Since April 1
New CW
Attrition Since April 1
Departed CW
Future Attrition
Projected departures
Future Hires
Incoming CW
Headcount by SMT
Click to drill| SMT Leader | Start HC | Attrition | Hires | Current HC | Future Att. | Future Hires | Future HC |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
CW Headcount by SMT
CW Movement Since April 1
Headcount by Location
Click to drill| Location | CW Count | % of Total | Distribution |
|---|---|---|---|
| Loading… | |||
Open & Pending Requisitions
Sourced from GH Open Job Detail · Filtered to active roles only
Total Open Roles
Active requisitions
Employee Roles
FTE openings
CW Roles
Contingent openings
New Headcount
Net-new roles
Backfills
Replacement roles
Open Roles by SMT
Click to drill| SMT Leader | EE Roles | CW Roles | Total | New HC | Backfill | Distribution |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Open Roles by People Business Partner
Click to drill| People Business Partner | EE Roles | CW Roles | Total | New HC | Backfill | Distribution |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Open Roles by Location
Click to drill| Location | EE Roles | CW Roles | Total | Distribution |
|---|---|---|---|---|
| Loading… | ||||
All Open Roles
Full List · Click to drill| Job Title | SMT | PBP | Location | Type | Category | Target Hire Date |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Pending Requisitions
Sourced from SmartSheetsTotal Pending Reqs
All statuses
Approved
Not yet in GH
Pending Approval
In review
Waiting to Review
Not yet reviewed
Sent Back
Returned for changes
Pending Reqs by SMT
Click to drill| SMT Leader | Pending Reqs | Distribution |
|---|---|---|
| Loading… | ||
Pending Reqs by People Business Partner
Click to drill| People Business Partner | Pending Reqs | Distribution |
|---|---|---|
| Loading… | ||
Pending Reqs by Location
Click to drill · Multi-location reqs counted in each| Location | Pending Reqs | Distribution |
|---|---|---|
| Loading… | ||
All Pending Reqs
Full List · Click to drill| Job Name | Status | Date Requested | Requested By | SMT | PBP | Location |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Pending Hires & Attrition
From Workday Pending Starts & Attrition Export · Live from Google Sheets
Pending Hires
EE + CW
Pending Attrition
EE + CW
Net Movement
Hires vs Departures
Pending Hires by SMT
Incoming · Click to drill| SMT Leader | Employee | Contingent Worker | Grand Total |
|---|---|---|---|
| Loading… | |||
Pending Hires by Location
Incoming| Location | Employee | Contingent Worker | Grand Total |
|---|---|---|---|
| Loading… | |||
Pending Attrition by SMT
Departures · Click to drill| SMT Leader | Employee | Contingent Worker | Grand Total |
|---|---|---|---|
| Loading… | |||
Pending Attrition by Location
Departures| Location | Employee | Contingent Worker | Grand Total |
|---|---|---|---|
| Loading… | |||
Pending Hires vs Attrition by SMT
Data Mapping
Where each metric comes from and how it is calculated
Targets
SMT Leader headcount targets · FY start date · Editable and saved to Google Sheets
| SMT Leader | EE Starting HC | Top Line Target | CW Starting HC | |
|---|---|---|---|---|
| Loading… | ||||
| Total | ||||