Alert close - icon Fill 1 Copy 10 Untitled-1 tt copy 3 Untitled-1 Untitled-1 tt copy 3 Fill 1 Copy 10 menu Group 3 Group 3 Copy 3 Group 3 Copy Page 1 Group 2 Group 2 Skip to content

We're planning essential maintenance on Sunday 22 July 2018 between 8am and noon, which may impact the website. We apologise for any problems this may cause.

close alert bar

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