Programe Developed by S.ANTONY ANBARASU ,PGT(Phy),Arasunilaipalayam Uploaded by C.Ramasamy PGT(phy), Thiruparaithurai 1)Enter U R Basic Pay+PP as on 1-1-2006= 2) Enter U r Increment Amount 2) Enter u R Grade Pay 3) Enter the 3 months arrear drawn
5500 175 4300 40000
Enter the data above and directly goto your increment date worksheet and find u r pay as on 1-5-09 & arrears
11925
d by S.ANTONY ANBARASU ,PGT(Phy),Arasunilaipalayam
ploaded by C.Ramasamy PGT(phy), Thiruparaithurai
o your increment date worksheet and find u r pay as on 1-5-09 & arrears
PAY
Due Rs.
Drawn Rs.
Diff. Rs
Arrears RS.
From 1-1-2006 to 30-6-2006 Pay as on 1-1-2006 ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 24%
14970
5500
Total From 1-7-2006 to Pay as on 1-7-2006 31-12-2006
14970
2750 1980 10230
( Dearnes Pay Dearnes Allowance @ 29% Dearnes Allowance @ 2%
14970
Total From 1-1-2007 to Pay as on 1-1-2007 30-6-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%
Total From Pay as 1-7-2007 on 1-7-2007to 31-12-2007 ( Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%
Total From Pay as 1-1-2008 on 1-1-2008to 30-6-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%
Total From Pay as 1-7-2008 on 1-7-2008to 31-12-2008 ( Dearnes Pay Dearnes Allowance @ 54% Dearnes Allowance @ 16%
Total From 1-1-2009 to Pay as on 1-1-2009 30-5-2009 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%
Total
4740
28440 (notional)
4626
27756 (NOTIONAL)
4852
29112
4805
28830
4898
29388
4918
29508
5149
25745
5500 2750 2393
299 15269
10643
15420
5675 2838 2980
925 16345 15420
11493 5675 2838 3490
1388 16808
12003
15890
5850 2925 4124
1907 17797 15890
12899 5850 2925 4739
2542 18432
13514
16370
6025 3013 5784
3601 19971
14822
Arrears From: From 1-1-2007 to 30-6-2007 From 1-7-2007 to 31-12-2007 From 1-1-2008 to 30-6-2008 From 1-7-2008 to 31-12-2008 From 1-1-2009 to 30-5-2009
29112 28830 29388 29508 25745 142583
Interim arrears Sanctioned (3 months basic Pay + Dearnes Pay + Dearnes allowance.) Balance Amount Due
40000 102583
Arrears Payment in 3 instalments First Instalment 2009-10 Second Instalement 2010-11 Third and Final instalement 2011-12
34195 34194 34194
34194 102582 1
PAY From 1-1-2006 to 31-3-2006
Due Rs.
Drawn Rs.
Pay as on 1-1-2006 Dearnes Pay Dearnes Allowance @ 24%
14530
Total From 1-4-2006 to 30-6-2006
14530
5500 2750 1980 10230
14970
5675
14970
2838 2043 10556
Pay as on 1-4-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 24%
Total From 1-7-2006 to 31-12-2006 Pay as on 1-7-2007 ( Dearnes Pay Dearnes Allowance @ 29% Dearnes Allowance @ 2%
Total From 1-1-2007 to 31-3-2007 Pay as on 1-1-2007 Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%
Total From 1-4-2007 to 30-6-2007 Pay as on 1-4-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%
Total From 1-7-2007 to 31-12-2007 Pay as on 1-7-2007 ( Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%
Total From 1-1-2008 to 31-3-2008 Pay as on 1-1-2008 Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%
Total From 1-4-2008 to 30-6-2008 Pay as on 1-4-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%
Total From 1-7-2008 to 31-12-2008
14970
299 15269 14970
Diff. Rs
Arrears RS.
4300
12900 (notional)
4414
13242 (NOTIONAL)
4287
25722 notional
4375
13125
4499
13497
4435
26610
4371
13113
4511
13533
5675 2838 2469 10982 5675 2838 2980
898 15868
11493
15420
5850 2925 3071
925 16345
15420
1388 16808 15420
11846
5850 2925 3598 12373 5850 2925 4124
1850 17270
12899
15890
6025 3013 4248
1907 17797
13286
Pay as on 1-7-2008 ( Dearnes Pay Dearnes Allowance @ 54% Dearnes Allowance @ 16%
TOTAL From 1-1-2009 to 30-3-2009 Pay as on 1-1-2009 Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%
Total From 1-4-2009 to 30-5-2009 Pay as on 1-4-2009 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%
Total
15890
2542 18432
6025 3013 4881 13919
15890
4513
27078
4564
13692
4719
9438
6025 3013 5784
3496 19386
14822
16370
6200 3100 5952
3601 19971
15252
Arrears From:
130086
From 1-1-2007 to 30-6-2007 From 1-7-2007 to 31-12-2007 From 1-1-2008 to 30-6-2008 From 1-7-2008 to 31-12-2008 From 1-1-2009 to 30-5-2009
26622 26610 26646 27078 23130
Total Interim arrears Sanctioned (3 months basic Pay + Dearnes Pay + Dearnes allowance.) Balance Amount Due
Arrears Payment in 3 instalments First Instalment 2009-10 Second Instalement 2010-11 Third and Final instalement 2011-12
130086 40000 90086 30028 30029 30029
30029 90087 -1
F
Due Rs.
PAY
Drawn Difference Arrears Rs. Rs RS.
From 1-1-2006 to 30-6-2006 Pay as on 1-1-2006 Dearnes Pay Dearnes Allowance @ 24%
Total
14530
5500 2750 1980
14530
10230
14970
5675
4300
25800 (notional)
4287
25722 (NOTIONAL)
4375
26250
4435
26610
4371
26226
4513
27078
4564
22820
From 1-7-2006 to 31-12-2006 Pay as on 1-7-2006 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 29% Dearnes Allowance @ 2%
Total
2838 2469 299
15269
10982
14970
5675 2838 2980
From 1-1-2007 to 30-6-2007 Pay as on 1-1-2007 ( Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%
Total
898
15868
11493
15420
5850
From 1-7-2007 to 31-12-2007 Pay as on 1-7-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%
Total
2925 3598 1388
16808
12373
15420
5850 2925 4124
From 1-1-2008 to 30-6-2008 Pay as on 1-1-2008 ( Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%
Total
1850
17270
12899
15890
6025
From 1-7-2008 to 31-12-2008 Pay as on 1-7-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 54% Dearnes Allowance @ 16%
Total From 1-1-2009 to 30-5-2009 Pay as on 1-1-2009 ( Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%
Total
3013 4881 2542
18432
13919
15890
6025 3013 5784
3496
19386
14822
Arrears From: From 1-1-2007 to 30-6-2007 From 1-7-2007 to 31-12-2007 From 1-1-2008 to 30-6-2008 From 1-7-2008 to 31-12-2008 From 1-1-2009 to 30-5-2009
26250 26610 26226 27078 22820
Total Interim arrears Sanctioned (3 months basic Pay + Dearnes Pay + Dearnes allowance.) Balance Amount Due
Arrears Payment in 3 instalments First Instalment 2009-10 Second Instalement 2010-11 Third and Final instalement 2011-12
128984 40000 88984
29662 29661 29661
29661 88983 1
PAY From 1-1-2006 to 30-6-2006 Pay as on 1-1-2006 Dearnes Pay Dearnes Allowance @ 24%
Total
Due Rs.
Drawn Rs.
14530
5500 2750 1980
14530
10230
14530
5500 2750 2393
Differen ce Arrears Rs RS.
4300
25800 (notional)
4178
12534 (notional)
4287
12861
4375
26250
3944
11832
4064
12192
3984
23904
From 1-7-2006 to 30-09-2006 Pay as on 1-7-2007 ( Dearnes Pay Dearnes Allowance @ 29% Dearnes Allowance @ 2%
Total
291
14821
10643
14970
5675
From 1-10-2006 to 31-12-2006 Pay as on 1-10-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 29% Dearnes Allowance @ 2%
Total
2838 2469 299
15269
10982
14970
5675 2838 2980
From 1-1-2007 to 30-6-2007 Pay as on 1-1-2007 ( Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%
Total
898
15868
11493
14970
5850
From 1-7-2007 to 30-10-2007 Pay as on 1-7-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%
Total
2925 3598 1347
16317
12373
15420
6025
From 1-10-2007 to 31-12-2007 Pay as on 1-10-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%
Total
3013 3706 1388
16808
12744
15420
6025 3013 4248
From 1-1-2008 to 30-6-2008 Pay as on 1-1-2008 ( Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%
Total
1850
17270
13286
From 1-7-2008 to 30-09-2008 Pay as on 1-7-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 54% Dearnes Allowance @ 16%
Total From Pay as 1-10-2008 on 1-10-2008to 31-12-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @54% Dearnes Allowance @ 16%
Total
15420
6025 3013 4881
2467
17887
13919
15890
6200
3968
11904
4110
12330
4134
20670
119082
119082
3100 5022 2542
18432
14322
15890
6200 3100 5952
From 1-1-2009 to 30-5-2009 Pay as on 1-7-2007 ( Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%
Total
3496
19386
15252
Arrears From: From 1-1-2007 to 30-6-2007 From 1-7-2007 to 31-12-2007 From 1-1-2008 to 30-6-2008 From 1-7-2008 to 31-12-2008 From 1-1-2009 to 30-5-2009
26250 24024 23904 24234 20670
Total Interim arrears Sanctioned (3 months basic Pay + Dearnes Pay + Dearnes allowance.)
40000
Balance Amount Due
79082
Arrears Payment in 3 instalments First Instalment 2009-10
26360
Second Instalement 2010-11
26361
Third and Final instalement 2011-12
26361
26361 79083 -1
PAY From 1-6-2006 to 30-6-2006
Due Rs.
Pay as on 1-6-2006 Dearnes Pay Dearnes Allowance @ 24%
14530
Total From 1-7-2006 to 31-12-2006
14530
Pay as on 1-7-2006 ( Dearnes Pay Dearnes Allowance @ 24%
14530
Total From 1-1-2007 to 31-3-2007
14530
Pay as on 1-1-2007 Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%
14530
Total From 1-4-2007 to 30-6-2007 Pay as on 1-4-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%
Total From 1-7-2007 to 31-12-2007 Pay as on 1-7-2007 ( Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%
Total From 1-1-2008 to 31-3-2008 Pay as on 1-1-2008 Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%
Total From 1-4-2008 to 30-6-2008 Pay as on 1-4-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%
Total
Drawn Rs.
Diff. Rs
Arrears RS.
5500 2750 1980 10230
4300
4300 (notional)
5500 2750 1980 10230
4300
25800 (NOTIONAL)
4264
12792
4375
13125
4314
25884
4252
12756
4371
13113
4373
26238
5500 2750 2888
872 15402
11138
14970
5675 2838 2980
898 15868
14970
1347 16317 14970
11493
5675 2838 3490 12003 5675 2838 4001
1796 16766
12514
15420
5850 2925 4124
1850 17270
12899
From 1-7-2008 to 31-12-2008 Pay as on 1-7-2008 ( Dearnes Pay Dearnes Allowance @ 54% Dearnes Allowance @ 16%
TOTAL
15420
2467 17887
5850 2925 4739 13514
From 1-1-2009 to 30-3-2009 Pay as on 1-1-2009 Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%
Total From 1-4-2009 to 30-5-2009 Pay as on 1-4-2009 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%
Total
15420
5850 2925 5616
3392 18812
14391
15890
6025
4421
13263
4564
9128
3013 5784 3496 19386
14822
Arrears From:
126299
From 1-1-2007 to 30-3-2007 From 1-4-2007 to 30-6-2007 From 1-7-2007 to 31-12-2007 From 1-1-2008 to 31-3-2008 From 1-4-2008 to 30-6-2008 From 1-7-2008 to 31-12-2008 From 1-1-2008 to 30-3-2008 From 1-4-2009 to 30-5-2009
12792 13125 25884 12756 13113 26238 13263 9128
Total
Interim arrears Sanctioned ic Pay + Dearnes Pay + Dearnes allowance.) Balance Amount Due
126299 40000 86299
Arrears Payment in 3 instalments First Instalment 2009-10 Second Instalement 2010-11 Third and Final instalement 2011-12
28767 28766 28766
28766 86298 1