Expected DA w.e.f., Jan 2013 and Calculation thereof : Central Govt Employees

A B C D
Month Points DA
1 Jan 2012 198 66.15
2 Feb 2012 199 67.15
3 Mar 2012 201 68.31
4 Apr 2012 205 69.67
5 May 2012 206 71.04
6 Jun 2012 208 72.41
7 Jul 2012 212 73.78
8 Aug 2012 214 75.22
9 Sep 2012 215 76.51
10 Oct 2012 217 77.88
11 Nov 2012 218 80.07
12 Dec 2012 219 80.82922292





i.e., Average from Jan 2012 to Dec 2012
198, 199, 201, 205, 206, 208, 212, 214, 215, 217, 218 and 219 = 209.3333










=209.3333-115.763 X 100

                 115.763












Expected DA w.e.f., Jan 2013 :  80% or 81%





Formula for DA in excel :- 

=SUM((AVERAGE(C1:C11)-115.763)/115.763)*100
Expected DA w.e.f., Jan 2013 :  80% or 81%

Comments

Anonymous said…
Hi there i am kavin, its my first time to commentіng anyplаce, ωhen i геаd
this рiece of writing і thought i сοuld also cгeаte comment ԁue to thіs bгilliant piece of ωritіng.


Review my blοg post build a healthy brain
my page - brain health supplements

Popular posts from this blog

Re-designate the posts of LDC/UDC and Assistant in Central Secretariat