For any query, ask here: Excel Utility
Last Updated On: 16.07.2021
This utility 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.
This will also prepare Modified Single Comprehensive Form + all other pension papers including forwarding letter as per the latest Memorandum No. 40-F(Pen) dated 02.02.2021.
Just fill the green cells properly and leave the red cells. The red cells are automatic. Fill the loan forms manually as the same is not auto generated. Please note that this utility is based on the DCRB Rules as updated time to time and in view of Rules laid down in WBS(ROPA), 2019 and it can calculate the pension before two years of retirement. Please feel free to post your feedback in our forum section.
Prepared by: Sri Somnath Das, Judicial Department, Katwa, Burdwan.