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.7