Calculation of pensionable pay

The calculation of pensionable pay spreadsheet calculates the final years pensionable pay for monthly paid employees.


This is to assist you with pensionable pay calculations. It will not cover every circumstance but should assist with the majority of calculations.

The worksheet has been password protected therefore you will only be able to enter information in the input cells, all of which are shown in white. If you tab from one white field it will take you to the next one. When using the spreadsheet please refer to the notes as these guide you through each section.

If you have any problems when using the spreadsheet please contact us, tel: 01629 539250 or email: pensions@derbyshire.gov.uk

Related documents

The following document is in Portable Document Format (PDF). You can download software to view PDF documents for free from the Adobe website (opens in a new window)

The following document is in Excel format. You can download software to view Excel documents for free from the Excel viewer page (opens in a new window) of the Microsoft website.