Hi
This worksheets will calculate the” period of service, date of retirement, date of starting revised pension & revised family pension, amount of revised pension & revised family pension, revised gratuity, revised C.V.P., and all related calculations for revised pension case only.
It will also prepare Single Comprehensive Form + all other revised pension papers including forwarding letter. Just fill the yellow cells properly and leave the red cells. The red cells are automatic. 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 . Use this for revised case only, I have prepared separate excel tools for Superannuation and death case. For further assistant feel free to write to som.bindas@yahoo.com. Please dont forget to leave your comments. Your feedback is exigent.