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