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

New pay Calculator-PB 3 and above based on approved 6CPC report
See the live calculator at http://www.GConnect.in						DA rate	%	Incorporated with the changes such as annual increment of 3%, and merger ratio of 1.86 of basic pay as on 1.1.2006		You can change DA Rates
Enter Old Basic Pay as on 1-1-06				20900		Jul-2006	2
Enter New Grade Pay				5400		Jan-2007	6
Enter New HRA rate of your city (%)				20		Jul-2007	9
Enter Month of Old increment (1 to 12)				4		Jan-2008	12
Enter old Increment amount				500		July-2008	16
Are you staying in quarters (YES/NO)				NO	If you belong to following pre-revised Scale Enter the Number mentioned against each. For Other Pay Scales Enter 0					1
Enter New TA amount (3200/1600)				1600
Enter old HRA Rate (%)				15.0
18400-500-22400 (S-29)			1	24050-650-26000 (S-32)			3
16400-450-20900 (S-27)			2	26000 (Fixed) (Apex Scale)			4
					1
	FIXED	GRADE	Basic	DA	Total	PAY DRAWN				Arrears
Jan-06	46620	5400	52020	0	52020	20900	10450	7524	38874	13146			1
Feb-06	46620	5400	52020	0	52020	20900	10450	7524	38874	13146	123	1	2
Mar-06	46620	5400	52020	0	52020	20900	10450	7524	38874	13146		1	3
Apr-06	46620	5400	52020	0	52020	21400	10700	7704	39804	12216		1	4
May-06	46620	5400	52020	0	52020	21400	10700	7704	39804	12216		0	5
Jun-06	46620	5400	52020	0	52020	21400	10700	7704	39804	12216		1	6
Jul-06	48181	5400	53581	1072	54653	21400	10700	9309	41409	13244		1	7
Aug-06	48181	5400	53581	1072	54653	21400	10700	9309	41409	13244		1	8
Sep-06	48181	5400	53581	1072	54653	21400	10700	9309	41409	13244		1	9
Oct-06	48181	5400	53581	1072	54653	21400	10700	9309	41409	13244		1	10
Nov-06	48181	5400	53581	1072	54653	21400	10700	9309	41409	13244		1	11
Dec-06	48181	5400	53581	1072	54653	21400	10700	9309	41409	13244		1	12
Jan-07	48181	5400	53581	3215	56796	21400	10700	11235	43335	13461		1	1
Feb-07	48181	5400	53581	3215	56796	21400	10700	11235	43335	13461		1	2
Mar-07	48181	5400	53581	3215	56796	21400	10700	11235	43335	13461		1	3
Apr-07	48181	5400	53581	3215	56796	21900	10950	11498	44348	12448		1	4
May-07	48181	5400	53581	3215	56796	21900	10950	11498	44348	12448		0	5
Jun-07	48181	5400	53581	3215	56796	21900	10950	11498	44348	12448		1	6
Jul-07	49788	5400	55188	4967	60155	21900	10950	13469	46319	13836		1	7
Aug-07	49788	5400	55188	4967	60155	21900	10950	13469	46319	13836		1	8
Sep-07	49788	5400	55188	4967	60155	21900	10950	13469	46319	13836		1	9
Oct-07	49788	5400	55188	4967	60155	21900	10950	13469	46319	13836		1	10
Nov-07	49788	5400	55188	4967	60155	21900	10950	13469	46319	13836		1	11
Dec-07	49788	5400	55188	4967	60155	21900	10950	13469	46319	13836		1	12
Jan-08	49788	5400	55188	6623	61811	21900	10950	15440	48290	13521		1	1
Feb-08	49788	5400	55188	6623	61811	21900	10950	15440	48290	13521		1	2
Mar-08	49788	5400	55188	6623	61811	21900	10950	15440	48290	13521		1	3
Apr-08	49788	5400	55188	6623	61811	22400	11200	15792	49392	12419		1	4
May-08	49788	5400	55188	6623	61811	22400	11200	15792	49392	12419		0	5
Jun-08	49788	5400	55188	6623	61811	22400	11200	15792	49392	12419		1	6
Jul-08	51444	5400	56844	9095	65939	22400	11200	15792	49392	16547		1	7
Aug-08	51444	5400	56844	9095	65939	22400	11200	15792	49392	16547		1	8
Total	1558236	172800	1731036	113452	1844488	694300	347150	375831	1417281	427207		1
Expected Pay as on Sept-2008								Arrears
FIXED	GRADE	TOTAL	DA	Total	TA	HRA	GROSS	First Installment		170883
51444	5400	56844	9095	65939	1856	11369	79164	Second Installment		256324

Sheet1

Sheet3

Sheet2