6pc Calculator Trial Copy

1 Use Excel 2002 and above 2 Keep the macro security at medium 3 only for those joined before 1/1/2006 4 NPA etc not considered 5 Only one promotion (max) assumed 6 Enter the basic on 1/1/2006 including promotion and increment on 1/1/2006 7 Fixation assumed at the beginning of month except in case of promotion 8 In case of fixation month = promotion month, fixation assumed to be on promotion date 9 Two increments have been calculated on old Grade Pay if promotion on 1st july 10 Please do not insert rows or columns in sheet "Output" 11 Use manual entry of increments very cautiously . All 3 increments needs to be filled up 12 The calculation for promotion month shows proportionate figures of basics and grade pays 13 depending upon the date of promotion Only upto S-30 scale 14 In case of deferred promotion , arrear to be reduced manually for greater pay drawn till actual promotion and defered promotion

Click to Run the Calculator

actual promotion and

SIXTH PAY COMMISSION - PAY AND ARREAR CALCULATOR CHANDESHWAR SINGH OLD SCALE (UPGRADED) NEW SCALE (UPGRADED) 1-Jan-06 S-19 (10000-325-15200) PB-3 (15600-39100) - GP 6600 PROMO NA NAME

BASIC

GP

PBAND

BASIC 22230

GP 6600

PBAND PB-3

PAY ON THE DATE OF PROMOTION

DATE

NA

PAY ON THE DATE OF DEFERED PROMOTION

DATE

NA

FIXATION OF PAY DATE 1-Jan-06

Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08

Basic(O) DP 11950 11950 11950 12275 12275 12275 12275 12275 12275 12275 12275 12275 12275 12275 12275 12600 12600 12600 12600 12600 12600 12600 12600 12600 12600 12600 12600 12925 12925 12925 12925 12925 398975

Sep 08

AMOUNTS UNDER DA Basic(N) GP(N) DA 5975 4302 22230 6600 5975 4302 22230 6600 5975 4302 22230 6600 6138 4419 22230 6600 6138 4419 22230 6600 6138 4419 22230 6600 6138 5340 23100 6600 6138 5340 23100 6600 6138 5340 23100 6600 6138 5340 23100 6600 6138 5340 23100 6600 6138 5340 23100 6600 6138 6445 23100 6600 6138 6445 23100 6600 6138 6445 23100 6600 6300 6615 23100 6600 6300 6615 23100 6600 6300 6615 23100 6600 6300 7749 24000 6600 6300 7749 24000 6600 6300 7749 24000 6600 6300 7749 24000 6600 6300 7749 24000 6600 6300 7749 24000 6600 6300 8883 24000 6600 6300 8883 24000 6600 6300 8883 24000 6600 6463 9112 24000 6600 6463 9112 24000 6600 6463 9112 24000 6600 6463 9112 24920 6600 6463 9112 24920 6600

HRA % TA

199496 216086 814557 30 3200

Basic GP 24920

748420

211200

DA 6600

0 0 0 0 0 0 594 594 594 594 594 594 1782 1782 1782 1782 1782 1782 2754 2754 2754 2754 2754 2754 3672 3672 3672 3672 3672 3672 5043 5043

62898 1022518 HRA

5043

9456 Gross

ARREAR 6603 6603 6603 5998 5998 5998 6541 6541 6541 6541 6541 6541 6624 6624 6624 5967 5967 5967 6705 6705 6705 6705 6705 6705 6489 6489 6489 5772 5772 5772 8063 8063

207961 TA 3712

49731