Skip to main content

DA CALCULATION SHEET

DA CALCULATION SHEET 

DA CALCULATION SHEET WITH INPUTS OF CPI(I-W) BASE YEAR 2001=100

We are proud to be the first to formulate the DA Table. 

We are aware of the fact that a number of you are very keen on learning how to calculate the Dearness Allowance. Hence, we created this table. At a stage, we ourselves were surprised by the response that it had received. Let us see, in detail, how DA is calculated. The calculations are very easy.  First is the month. Then comes the CPI (IW) Base Year 2001=100 and the relevant data. In the next column, you have the sum total of all the 12 months, i.e., the total of the declared AIPCIN numbers for the past 12 months. Next comes the division of the sum total by 12. 

The next step is the most crucial one. You will have to find out by how much it exceeds 115.76. You will have to calculate the excess as percentage of 115.76. 

(12 Monthly Average) – 115.76 
-----------------------------------    X 100  =  Percentage increase in prices (ignore decimals)
                     115.76

The table has been created to easily understand the formula...

M /Year
B.Y. 2001=100
Total of 12 Months
12 Months Average
% Increase over
115.763
App. DA
DA %
Jan-06
119
116.08
0.32
0.28
Feb-06
119
116.58
0.82
0.71
Mar-06
119
117.08
1.32
1.14
Apr-06
120
117.58
1.82
1.57
May-06
121
118.17
2.41
2.08
Jun-06
123
721
118.92
3.16
2.73
2
Jul-06
124
119.58
3.82
3.3
Aug-06
124
120.16
4.4
3.8
Sep-06
125
120.83
5.07
4.38
Oct-06
127
121.58
5.82
5.03
Nov-06
127
122.25
6.49
5.61
Dec-06
127
1475
122.92
7.16
6.18
6
Jan-07
127
1483
123.58
7.82
6.76
Feb-07
128
1492
124.33
8.57
7.41
Mar-07
127
1500
125
9.24
7.98
Apr-07
128
1508
125.67
9.91
8.56
May-07
129
1516
126.33
10.57
9.13
Jun-07
130
1523
126.92
11.16
9.64
9
Jul-07
132
1531
127.58
11.82
10.21
Aug-07
133
1540
128.33
12.57
10.86
Sep-07
133
1548
129
13.24
11.44
Oct-07
134
1555
129.58
13.82
11.94
Nov-07
134
1562
130.17
14.41
12.44
Dec-07
134
1569
130.75
14.99
12.95
12
Jan-08
134
1576
131.33
15.57
13.45
Feb-08
135
1583
131.92
16.16
13.96
Mar-08
137
1593
132.75
16.99
14.68
Apr-08
138
1603
133.58
17.82
15.4
May
2008
139
1613
Jun
2008
140
1623
135.25
16.84
16
July
2008
143
1634
Aug
2008
145
1646
Sep
2008
146
1659
Oct
2008
148
1673
Nov
2008
148
1687
Dec
2008
147
1700
141.67
22.38
22
Jan
2009
148
1714
Feb
2009
148
1727
Mar
2009
148
1738
Apr
2009
150
1750
May
2009
151
1762
June
2009
153
1775
147.92
27.78
27
July
2009
160
1792
149.33
29
Aug
2009
162
1809
150.75
30.23
Sep
2009
163
1826
152.17
31.45
Oct
2009
165
1843
153.58
32.67
Nov
2009
168
1863
155.25
34.11
Dec
2009
169
1885
157.08
35.7
35
Jan
2010
172
1909
159.08
37.42
Feb
2010
170
1931
160.92
39.01
Mar
2010
170
1953
162.75
40.59
Apr
2010
170
1973
164.42
42.03
May
2010
172
1994
166.17
43.54
Jun
2010
174
2015
167.92
40.05
45
July
2010
178
2033
169.42
46.35
August
2010
178
2049
170.75
47.5
Sep
2010
179
2065
172.08
48.65
Oct
2010
181
2081
173.42
49.81
Nov
2010
182
2095
174.58
50.81
Dec
2010
185
2111
175.92
51.97
51
Jan
2011
188
2127
177.25
53.12
Feb
2011
185
2142
178.5
54.2
Mar
2011
185
2157
179.75
55.28
Apr
2011
186
2173
181.08
56.43
May
2011
187
2188
182.33
57.51
Jun
2011
189
2203
183.58
58.59
58
July
2011
193
2218
184.83
59.67
August
2011
194
2234
186.17
60.82
Sep
2011
197
2252
187.67
62.12
Oct
2011
198
2269
189.08
63.34
Nov
2011
199
2286
190.5
64.56
Dec
2011
197
2298
191.5
65.43
65
Jan
2012
198
2308
192.33
66.15
Feb
2012
199
2322
193.5
67.15
Mar
2012
201
2338
194.83
68.31
Apr
2012
205
2357
196.42
69.67
May
2012
206
2376
198
71.04
Jun
2012
208
2395
199.58
72.41
72
Jul
2012
212
2414
201.17
73.78
August
2012
214
2434
202.83
75.22
Sep
2012
215
2452
204.33
76.51
Oct
2012
217
2471
205.92
77.88
Nov
2012
218
2490
207.5
79.25
Dec
2012
219
2512
209.33
80.83
80
Jan
2013
221
2535
211.25
82.49
Feb
2013
223
2559
213.25
84.22
Mar
2013
224
2582
215.17
85.87
Apr
2013
226
2603
216.92
87.38
May
2013
228
2625
218.75
88.97
Jun
2013
231
2648
220.67
90.62
90
Jul
2013
235
2671
222.58
92.28
Aug
2013
237
2694
224.5
93.93
Sep
2013
238
2717
226.42
95.59
Oct
2013
241
2741
228.42
97.32
Nov
2013
243
2766
230.5
99.12
Dec
2013
239
2786
232.17
100.56
100
Jan
2014
237
2802
233.5
101.71
Feb
2014
238
2817
234.75
102.79
Mar
2014
239
2832
236
103.87
Apr
2014
242
2848
237.33
105.02
May
2014
244
2864
238.67
106.17
Jun
2014
246
2879
239.92
107.25
107
Jul
2014
252
2896
241.33
108.47
Aug
2014
253
2912
242.67
109.63
Sep
2014
253
2927
243.92
110.71
Oct
2014
253
2939
244.92
111.57
Nov
2014
253
2949
245.75
112.29
Dec
2014
253
2963
246.92
113.29
113
Jan
2015
254
2980
248.33
114.52
Feb
2015
253
2995
249.58
115.6
Mar
2015
254
3010
250.83
116.68
Apr
2015
256
3024
252
117.69
May
2015
258
3038
253.17
118.69
Jun
2015
261
3053
254.42
119.77
119
Jul
2015
263
3064
255.33
120.56
Aug
2015
264
3075
256.25
121.36
Sep
2015
266
3088
257.33
122.29
Oct
2015
269
3104
258.67
123.44
Nov
2015
270
3121
260.08
124.67
Dec
2015
269
3137
261.42
125.82
125

DA Calculation as per 7th CPC

Month
Year
CPI(IW)
BY2001=100
12 Months
Total
12 Months
Average
Increased Over 261.42
DA %
Jan-16
269 
3152 
262.67 
0.48 
Feb-16
267
3166
263.33
0.92
Mar-16
268
3180
265.00
1.37
Apr-16
271
3195
266.25
1.85
May-16
275
3212
267.67
2.39
Jun-16
277
3228
269.00
2.90
2
Jul-16
280
3245
270.42
3.44
Aug-16
278
3259
271.58
3.89
Sep-16
277
3270
272.05
4.24
Oct-16
278
3279
273.25
4.53
Nov-16
277
3286
273.83
4.75
Dec-16
275
3292
274.33
4.94
4
Jan-17
274
3297
274.75
5.10
Feb-17
274
3304
275.33
5.33
Mar-17
275
3311
275.92
5.55
Apr-17
277
3317
276.41
5.74
May-17
278
3320
276.66
5.84
Jun-17
280
3323
276.91
5.93
5
Jul-17
285
3328
277.33
6.10
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17



Comments

Popular Posts

Expected Dearness Allowance (DA) from July 2020 Calculator

Expected DA from July 2020 Calculator Expected Dearness Allowance from July 2020 Calculator with the input of AICPIN. The calculation of Dearness allowance with effect from 1st July 2020 begins with the AICPIN (January 2020) of this year. We provide here a simple online tool (not excel sheet format) to predict the percentage of additional DA and DR with the input of imaginary AICPIN. Click to Calculate DA from July 2020

Pay Matrix Table for All State and Central Govt Employees PDF Download

Latest Pay Matrix Table for Govt Employees PDF Download Compilation of all State and Central Government Pay Matrix Table PDF with easy download option: Pay Matrix Table for Civilian Employees PDF Download Pay Matrix Table for Defence Personnel PDF Download Maharashtra Govt 7th Pay Commission Notification Pay Matrix PDF Maharashtra Govt Gazette Seventh Pay Maharashtra Govt State Pay Committee Pay Matrix Table for MNS Officers PDF Download Pay Matrix Table for Tamil Nadu PDF Download Pay Matrix Table for (10th Pay Revision) Kerala PDF Download Pay Matrix Table for Odisha PDF Download Pay Matrix Table for West Bengal PDF Download Pay Matrix Table for Madhya Pradesh PDF Download Pay Matrix Table for Uttar Pradesh PDF Download Pay Matrix Table for Gujarat PDF Download Pay Matrix Table for Delhi PDF Download Pay Matrix Table for J&K PDF Download Pay Matrix Table for Chhattisgarh PDF Download Pay Matrix Table for Jharkhand PDF Download Pay Matrix Table for Rajasthan PDF

DA Arrears Loss Calculator from Jan 2020 to June 2021

DA  Loss in Salary Calculator for the period of January 2020 to June 2021  for Central Government Employees Additional DA Freeze (Temporarily Suspended) for Central Govt employees for eighteen months between January 2020 and June 2021. July 2020 DA & January 2021 DA Calculation The Cabinet Committee already approved to increase 4% additional DA from January 2020 on the basis of Consumer Price Index (CPI). The next installment from July 2020 is expected to increase by 4% additionally. And another installment will also be expected to hike by 4% with effect from 1st January 2021. The below-expected DA list, which is used in our software tool for your information; Click to Calculate Your Arrears for 18 Months

Attendance of Central Government Officers and Employees in Lockdown Period due to Covid-19 Pandemic – DoPT Order 14 June 2021

Attendance of Central Government Officers and Employees in Lockdown Period due to Covid-19 Pandemic – DoPT Order 14 June 2021 F.No.11013/9/2014-Estt.A-III Government of India Ministry of Personnel, Public Grievances and Pensions Department of Personnel & Training North Block, New Delhi Dated the 14th June 2021 Office Memorandum Subject: Preventive measures to contain the spread of Novel Coronavirus (COVID-19) – Attendance of Central Government officials regarding The undersigned is directed to refer this Department’s OMs of even number dated the 6th May 2021 and 28th May 2021, mandating the Secretaries/HoDs of the Ministries/Departments/Offices to regulate the attendance of their Staff, keeping in view the COVID-positive cases and functional requirements in their offices. These orders are currently in operation till 15th June 2021 or until further orders, whichever is earlier. In view of the fact that number of COVID cases and positivity rate have reduced considerably, the matter h

CCS (CCA) RULES - Resignation from Service procedure

CENTRAL CIVIL SERVICES (CCA) RULES, 1965 CCS (CCA) RULES - Resignation from Service (12) Resignation from Service procedure in respect of :- Instructions have been issued from time to time on the subject of resignation. These instructions have now been consolidated for facility of reference and guidance of all the Ministry/Departments of the Government of India. 1. Resignation is an intimation in writing sent to the competent authority by the incumbent of a post, of his intention or proposal to resign the office/post either immediately or from a future specified date. A resignation has to be clear and unconditional. 2. it is not in the interest of Government to retain an unwilling Government servant in service. The general rule, therefore, is that a resignation of a Government servant from service should be accepted, except in the circumstances indicated below :- (i) Where the Government servant concerned is engaged on work of

CGHS Hospital List 2021 All India PDF Download

 CGHS Panel Hospital List 2021 All India PDF Download Central Government Health Scheme (CGHS) is a cashless or low-cost medical scheme for Central Government employees, Pensioners, and their family members. The latest list of CGHS empanelled private hospitals for all CGHS cities in India is attached in PDF format. The list including Eye clinics, Dental Clinics, and Diagnostic centers and you can download the PDF list from the original link (cghs.gov.in). CGHS Agartala Hospital List 2021 PDF Download CGHS Ahmedabad Hospital List 2021 PDF Download CGHS Allahabad Hospital List 2021 PDF Download CGHS Bangalore Hospital List 2021 PDF Download CGHS Bhopal hospital List 2021 PDF Download CGHS Bhubaneswar Hospital List 2021 PDF Download CGHS Chandigarh Hospital List 2021 PDF Download CGHS Chennai Hospital List 2021 PDF Download CGHS Dehradun Hospital List 2021 PDF Download CGHS Delhi NCR Hospital List 2021 PDF Download CGHS Guwahati Hospital List 2021 PDF Download CGHS Hyderabad Hospital List

Dearness Relief (DR) Loss in Pension Calculator for Govt Pensioners

Dearness Relief (DR) Loss in Pension Calculator for Government Pensioners  After implemented an important order issued by the Finance Ministry under the title of “Freezing of Dearness Allowance and Dearness Relief” on 23rd April 2020, all Central Government pensioners including Railways are wishing to know their total contribution to the Govt. All Central Government pensioners are paid only 17% Dearness Relief (DR) of basic pension between January 2020 and June 2021. Let us see the loss of the DR month-wise report Click to Calculate Your Pension Arrears Amount for 18 Moths

New Commutation Table - How to calculate Gratuity and Pension - Terminal Benefits

New Commutation Table - How to calculate Gratuity and Pension - Terminal Benefits "For payment of commutation amount the Commission has noted that various factors suggest that the procedure of restoration of commuted amount after 15years appears to be more than fair. However the Commission has recommended the a new table (Annex.5.1.2) for calculation of commutation values." Age Factor Age Factor Age Factor 20 9.188 41 9.075 62 8.093 21 9.187 42 9.059 63 7.982 22 9.186 43 9.040 64 7.862 23 9.185 44 9.019 65 7.731 24 9.184 45 8.996 66 7.591 25 9.183 46 8.971 66 7.431 26 9.182 47 8.943 68 7.262 27 9.180 48 8.913 69 7.083 28 9.178 49 8.881 70 6.

Latest list of KV Schools in Tamil Nadu

Latest list of KV Schools in Tamil Nadu (Updated Jan 2017) Latest list of Kendriya Vidyalaya Schools in Tamil Nadu / Chennai Region is listed below with the detailed School information. The last given link is provided the respective link of the website and Google Map also... No. Institute Name Shifts Link 1 KENDRIYA VIDYALAYA AFS AVADI 1 Details 2 KENDRIYA VIDYALAYA AFS THANJAVUR 1 Details 3 KENDRIYA VIDYALAYA AIR FORCE STATION SULUR 1 Details 4 KENDRIYA VIDYALAYA ANNA NAGAR CHENNAI 1 Details 5 KENDRIYA VIDYALAYA ARAKKONAM 1 Details 6 KENDRIYA VIDYALAYA ARUVANKADU 1 Details 7 KENDRIYA VIDYALAYA ASHOK NAGAR    1 Details 8 KENDRIYA VIDYALAYA CISF RTC(A) THAKKOLAM 1 Details 9 KENDRIYA VIDYALAYA CLRI 1 Details 10 KENDRIYA VIDYALAYA COIMB

List of Closed Holidays for Central Government Offices & Employees 2022 PDF Download

Holidays to be observed in Central Government Offices during the year 2022 PDF Download Click Here to Download DoPT Holiday List 2022 PDF F.No.12/5/2021-JCA-2 Government of India Ministry of Personnel, Public Grievances and Pensions (Department of Personnel and Training) Establishment (JCA-2) Section North Block, New Delhi Dated the 8th June 2021 Office Memorandum Subject: Holidays to be observed in Central Government Offices during the year 2022 - reg. It has been decided that the holidays, as specified in Annexure-I to this O.M., will be observed in all the Administrative Offices of the Central Government located at Delhi/New Delhi during the year 2022. In addition, each employee will also be allowed to avail himself/herself of any two holidays to be chosen by him/her out of the list of Restricted Holidays specified at Annexure-II. 2. Central Government Administrative Offices located outside Delhi / New Delhi shall observe the following holidays compulsorily in addition to t