The age profiling tool available on this page is an Excel spreadsheet developed by the UK Working Longer Group. It contains formulas which translate raw data into a graphic output.
How to use the tool
It is important to gather age profile data on an organisational, departmental or team by team basis, so that analysis can identify where actions are most needed. You will require basic data on the number of people you employ and the number of joiners and leavers in each age group. The tool shows the age groups you should seek data on.
Analyse the data
The tool allows you to plot the numbers of staff currently in post, and numbers of leavers and joiners for each age group. You need to overwrite the example data in blue to give results for your organisation. The tool then indicates future patterns for your organisation.
Data required
You need to include at least one year’s worth of data. However, we recommend using average data from a number of years to ensure your results are stable. For example, if you were to use data from just one year, and have a far higher number of joiners than leavers in one age group in that year, this may lead to unrealistically high future predictions for that age group.
The graph included within the tool shows how you can use an age profile projection to see what your organisation’s profile would look like over time if no changes were made. The tool is a static model in that it does not forecast actual outcomes, but suggests possible patterns.