Hi friends.
After receiving many feedbacks from our members and others, I have developed my pensions papers of Superannuation case with some new looks and adding many more features.
Hope it will be much helpful for you and you will like it.
Please enable macro to run the programme.
This worksheets will calculate the” period of service, date of retirement, date of starting pension & family pension, date and amount of next increment, amount of pension & family pension, gratuity, C.V.P., and all related calculations for superannuation case only. I have created separate worksheets for Death case and revised case and will post them here shortly. This excel utility will also prepare Single Comprehensive Form + all other pension papers including forwarding letter. Just fill the yellow cells properly and leave the red cells. The red cells are autometic. Fill the loan forms mannually as the same is not auto generated. Please note that this excel utility is based on the DCRB Rules as updated time to time and in view of Rules laid down in W.B.S. (ROPA), 2009 and it can calculate the pension before two years of retirement.
