Headcount and Attrition Analysis
Understand turnover with careful definitions.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Build an attrition analysis workbook. Employee table (ID, department, start date, end date, reason category): [EMPLOYEE_TABLE]. Period to analyse: [PERIOD]. Definition of voluntary and involuntary leavers: [DEFINITIONS]. Provide formulas for headcount at the start and end of each month, average headcount, leavers, attrition rate by month and by department, and tenure at exit with groupings. Add a rolling twelve-month rate and a flag for small departments where percentages are unstable. Remove names from the analysis sheet and explain how to protect the data. Include a reminder that employee data is sensitive and handling rules vary by place [VERIFY] for [JURISDICTION], and an interpretation guide that avoids drawing conclusions about individuals. Add a section that compares attrition by tenure band and manager group only where group sizes are large enough to protect anonymity, and a rule for suppressing small groups. Do not assume my business structure or tax status. Ask for them if they matter, mark dependent points [VERIFY], and suggest I confirm them with an accountant in [JURISDICTION].
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.