Zoho Sheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66

New Sixth PC Arrears and New Pay Calculator (up to Pay Band 2)
(Based on Pay Commission report approved by Cabinet on 14.08.08)

									DA rate	%
Enter Old Basic Pay as on 1-1-06				9925		Now you can change DA Rate			Jul-2006	2
Enter New Grade Pay				4800		Get grade pay			Jan-2007	6
Enter New HRA rate of your city				20		%			Jul-2007	9
Enter Month of Old increment				4			(1 to 12)		Jan-2008	12
Enter old Increment amount				225					July-08	16
Are you staying in quarters				No			(Yes/No)
Enter New TA amount				800		(3200/1600/800/600/400)
Enter old HRA Rate				15.0		%	(30 or 15 or 7.5 or 5)
As per approved 6CPC report merger ratio and increment (annual) are 1.86 times and 3% respectively. This Calculator has been updated to that extent

	FIXED	GRADE	TOTAL	DA	Total Pay	PAY DRAWN				Arrears
Jan-06	18470	4800	23270	0	23270	9925	4963	3573	18461	4809	Err:510	1	1
Feb-06	18470	4800	23270	0	23270	9925	4963	3573	18461	4809	Err:510	1	2
Mar-06	18470	4800	23270	0	23270	9925	4963	3573	18461	4809	Err:510	1	3
Apr-06	18470	4800	23270	0	23270	10150	5075	3654	18879	4391	Err:510	0	4
May-06	18470	4800	23270	0	23270	10150	5075	3654	18879	4391	Err:510	1	5
Jun-06	18470	4800	23270	0	23270	10150	5075	3654	18879	4391	Err:510	1	6
Jul-06	19168	4800	23968	479	24447	10150	5075	4415	19640	4807	1	1	7
Aug-06	19168	4800	23968	479	24447	10150	5075	4415	19640	4807		1	8
Sep-06	19168	4800	23968	479	24447	10150	5075	4415	19640	4807		1	9
Oct-06	19168	4800	23968	479	24447	10150	5075	4415	19640	4807		1	10
Nov-06	19168	4800	23968	479	24447	10150	5075	4415	19640	4807		1	11
Dec-06	19168	4800	23968	479	24447	10150	5075	4415	19640	4807		1	12
Jan-07	19168	4800	23968	1438	25406	10150	5075	5329	20554	4852		1	1
Feb-07	19168	4800	23968	1438	25406	10150	5075	5329	20554	4852		1	2
Mar-07	19168	4800	23968	1438	25406	10150	5075	5329	20554	4852		1	3
Apr-07	19168	4800	23968	1438	25406	10375	5188	5447	21010	4396		0	4
May-07	19168	4800	23968	1438	25406	10375	5188	5447	21010	4396		1	5
Jun-07	19168	4800	23968	1438	25406	10375	5188	5447	21010	4396		1	6
Jul-07	19887	4800	24687	2222	26909	10375	5188	6381	21944	4965		1	7
Aug-07	19887	4800	24687	2222	26909	10375	5188	6381	21944	4965		1	8
Sep-07	19887	4800	24687	2222	26909	10375	5188	6381	21944	4965		1	9
Oct-07	19887	4800	24687	2222	26909	10375	5188	6381	21944	4965		1	10
Nov-07	19887	4800	24687	2222	26909	10375	5188	6381	21944	4965		1	11
Dec-07	19887	4800	24687	2222	26909	10375	5188	6381	21944	4965		1	12
Jan-08	19887	4800	24687	2962	27649	10375	5188	7315	22878	4771		1	1
Feb-08	19887	4800	24687	2962	27649	10375	5188	7315	22878	4771		1	2
Mar-08	19887	4800	24687	2962	27649	10375	5188	7315	22878	4771		1	3
Apr-08	19887	4800	24687	2962	27649	10600	5300	7473	23373	4276		0	4
May-08	19887	4800	24687	2962	27649	10600	5300	7473	23373	4276		1	5
Jun-08	19887	4800	24687	2962	27649	10600	5300	7473	23373	4276		1	6
Jul-08	20628	4800	25428	4068	29496	10600	5300	7473	23373	6123		1	7
Aug-08	20628	4800	25428	4068	29496	10600	5300	7473	23373	6123		1	8
	620736	153600	774336	50742	825078	329075	164545	178095	671715	153363
Expected Pay as on Sept-2008									Arrears
FIXED	GRADE	TOTAL	DA	Total	TA	HRA	GROSS	Ist Installment		61345
20628	4800	25428	4068	29496	928	5086	35510	2nd Installment		92018

Sheet1

Sheet2