THE CALCULATION TOOL POSTED IN THIS POST HAS BEEN RIGOROUSLY TESTED FOR ACCURACY AND IS HELPFUL TO KNOW YOUR REVISED PENSION AND TOTAL ARREARS WITHOUT ANY MATHEMATICAL CALCULATION  BY THE VETERANS.

The OROP-2 letter with tables  has been issued today the 20th Jan 23 by Mod DESW, ( DOWNLOAD OR READ THE COMPLETE LETTER HERE BY CLICKING ), Table No 1 is separately posted in this post for ease of knowing  revised basic pension and arrears.  The detailed on the applicability of this letter is also given in the succeeding paras after the TOOL. Please note your basic revised and pre-revised basic pension from the tables and then use the on line TOOL following instructions carefully to know your revised pension based on DA, age factor and disability percentage as in Jan 2023 and the total arrears you are entitled to up to 31 Dec 2023 instantly WITHOUT EVEN A SINGLE MATHEMATICAL CALCULATION by you.

We are happy to design and share this on line tool for our members to know their OROP arrears based on their data and OROP-2 tables without any mathematics.Your particulars ie IC No, Rank, Name, DOB, DOC, DOR, Basic Pension as on Jun 2019 and Revised pension as per Tables when issued and the Disability Percentage are required to be overwritten in the GREEN Cells. The default entries will get replaced it self alternatively if needed first delete them and then type  your data.

The tool has been designed to auto calculate your AGE FACTOR based on your Date of Birth (DOB) which must be entered in the date format as 11-JUN-1945. It does not accept any other format of date, and would show erroneous results. 

     Once you enter the DOB correctly your age today as also on other days will appear under results down to No, of days. In case date is not in the format the age  results will not be seen. 

     The rates of DA as applicable for the 42 months and age and disability enhancement in pension gets auto calculated to display the final figures of arrears from Jul 19 to Dec 2022.. 

     Your DATA gets deleted once the browser is closed, the tool reverts to its default entries. The TOOL works OK on Mb Phones and tablets as well but best on laptops with MS Office.CALCULATION -TOOL— Be patient Tool-loading may take little time based on the configuration of your computer/phone and the internet speed. It has been fully tested on 17 JAN 2023 for on line operations.
https://onedrive.live.com/embed?resid=F5352D9F7BBF0771%21135&authkey=%21AG0lcYTeqM2jgZM&em=2&wdAllowInteractivity=False&AllowTyping=True&ActiveCell=%27Sheet2%27!E8&Item=%27Sheet2%27!C3%3AI21&wdInConfigurator=True&wdInConfigurator=True&edesNext=false&edrtees6=false&resen=false&ed1JS=false
IMPORTANT — In case it takes too long do use another device or clean up your  browser. Please npte that the tool is fully functional on line and has been tested by many of our members.
Only the Green Cells here are editable, all other cells containing formulas and codes are protected. After all the Green cells are filled up Press ENTER or click any where else, the Total Arrears are displayed instantly giving their break down. Based on the Basic Pension your total monthly pension to incl Age and disability as in Jan 2023 is also displayed duly auto calculated.
The revised tables as applicable to all ranks are given in the MoD letter mentioned above however the table No 1 for commissioned offrs other than the medicos is posted below for ready reference.

Some important points shared by our esteemed veteran--The OROP Equalization Tables are issued by DESW and the Banks will commence payment of Arrears and revised pension on receipt of PCDA Circular by them
Applicability of OROP2 Policy LetterThe provisions of this letter shall be applicable to all pensioners/family pensioners who had been retired/ discharged/invalided out from service/died in service or after retirement in the rank of Commissioned Officers, Honorary Commissioned Officers, JCOS/ORs and Nom Combatants (Enrolled) of Army, Navy, Air Force, Defence Security Corps, Territorial Army & Ex-State Forces and are in receipt of pension/family pension as on 01.07.2019 (except pensioners retired after previous OROP revision on premature retirement byown request).
The provisions of this letter, however, do not apply to UK/HKSRA/KCIO pensioner Pakistan & Burma Army pensioners, Reservist pensioners and pensioners in receipt of Ex-gratia payments and pensioners retired after previous OROP revision on premature retirement/own request (as provided in para 4 of MoD letter dated 07.11.2015). 
It is provided in para-2.6 of MoD letter dated 04.01.2023 that the pensioners retired on 01.07.2014 on premature retirement on own request are not eligible for benefits of OROP. 
For wider coverage, following may be useful
Table 1 – page 12, for officers less Medical Table 2 – page 15 for Medical officersTable 21 – page 53 for family pensioners less medical Table 22 – page 55 for medical family pensioners
OROP-1 EXTRACT TABLESFor convenience of veterans who are in receipt  of the OROP (July 2015) pension the OROP-1  tables are given below as such the Pre-revised basic pension is  the basic Pension in this table applicable to your QS multiplied by 2.57. The family pensioner who are getting ordinary family pension get 60% of the retiring pension.

On implementation our OROP pension was multiplied by 2.57 which is the basic we are getting since Jan 2016

ACCURACY OF CALCULATIONS 
 The TOOL has been extensively tested for various scenarios, It has been a hard task to auto calculate first the AGE for each month and then assign the Enhancement Factor specially where the age slab changes within 42 months. 
WE URGE & REQUEST our valued members to kindly try their hand and intimate any errors or your suggestions that they may may have.
SPLITTING ARREARS to past years for REBATE in Income Tax, we will include the table here once the PCDA(P) Circular is issued.