Showing posts with label Excel Tools. Show all posts
Showing posts with label Excel Tools. Show all posts

Friday, 29 April 2022

Admin

PLI Premium Calculator 2.0

 

Download Latest version of PLI Premium Calculator 2.0


 Instructions:


Enable Macros  for better results











Saturday, 16 December 2017

Admin

Pension Arrears Calculator for Pre-2016 Pension Revision Cases

Pension Arrears Calculator for Pre-2016 Pension Revision Cases

A simple excel tool to Calculate Arrears of Pre-2016 Pension Revision cases



Download Link


Wednesday, 23 August 2017

Admin

Pension Calculator for Pre-2016 Pensioners-Excel Tool

Pension Calculator in excel format for Pre-2016 Pensioners


Pension Calculator for Pre-2016 Pensioners & Family Pensioners  based on 7 CPC recommendation  as per O.M. No- NO.38/37/2016-P&PW(A) dated 12th May, 2017.

Prepared by: Shri Pravin N Patil, Accountant Jalgaon HO-425001






Instructions
(To use this tool)







Special thanks to Mr. Pravin Patil from team "DOP Accountant"

Friday, 12 August 2016

Admin

7th Pay Commission Calculator (for use of DDOs with option to print Pay fixation statment for Service Book & arrears calculation report)

7th Pay Commission Calculator (for use of DDOs with option to print Pay fixation statement for Service Book & arrears calculation report).









Link 2 (For SIFY network)


Special Thanks to Shri. M.Dhamotharan, email : dhamotharan@outlook.com

Saturday, 6 August 2016

Admin

Pension Calculator as per 7th Pay Commission


  • Excel utility prepared by Pravin Patil Accountant Jalgaon HO(MH) to know your pensionary benefits in 7th CPC.
  • With this Pension calculator you cal calculate pension, retirement gratuity, commutation value & leave encashment on retirement.
  • Applicable to only those who are retired after 01.01.2016 or due for retirement.











CLICK HERE to download orders.

CLICK HERE to download resolution on 7th CPC


Admin

EASY TOOL TO PREPARE PAY FIXATION STATEMENT - FOR ACCOUNT BRANCH USE ONLY

EASY TOOL TO PREPARE PAY FIXATION STATEMENT - FOR ACCOUNT BRANCH USE

  • It contains two files, one word (Annexure) and one excel (Data entry).
  • Instructions document is also given.
  • Read instructions carefully and then start work.
  • If still, any problem persists, contact on dopacctt1@gmail.com
  • Unzip the file given.


Google drive link to download zip file. LINK 1



Friday, 29 July 2016

Admin

7th CPC PAY CALCULATOR IN EXCEL V - 2.0 : UPDATED ON 28/07/2016

7th CPC PAY CALCULATOR IN EXCEL UPDATED ON  28/07/2016.

Following changes are made in updated Excel Calculator.


  • Option to select CPF/GPF Employee is given. 
  • Total Arrears Amount is now included.




USE MS OFFICE 2007 AND ABOVE FOR BETTER RESULTS



  • All the calculations in the Calculator are as per CCS Revised Pay Rules - 2016.
  • Due care is taken for Correctness of the data.Still, if you find some queries, kindly email on dopacctt1@gmail.com.
  • Your suggestions are valuable to update Calculator.


CLICK HERE to download Calculator from Google Drive link.

If you are finding any difficulties in downloading Calculator (specially due to Sify network issue, comment your email ID below. Calculator will be sent by email.



Tuesday, 26 July 2016

Admin

7th CPC PAY CALCULATOR - EXCEL FILE

7th CPC PAY CALCULATOR - EXCEL FILE



Google drive link to download Excel Calculator is given below.




If you find any difficulty in downloading Excel file, comment your email ID. Excel file will be sent by email.

Feel free to give your valuable suggestions. It will help to update Calculator.

Excel Calculator as per Revised Pay Rules 2016.


CLICK HERE to Download Revised Pay Rules.