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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141

	updated on 07.06.2009
	FILL ONLY THREE YELLOW CELL
	SELECT YOUR OLD PAY SCALE CODE					17		INSTRUCTION -1
	NO OF INCREMENT IN OLD SCALE					1		INSTRUCTION-2			inc	25	26	27	28	29	inc	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24
	MONTH OF INCREMENT(SELECT 1-12)					1		INSTRUCTION-3			0	12750	14300	15000	16400	17400	0	2550	2610	2650	2750	3050	3200	3685	4000	4300	4500	5000	5300	5500	5700	5900	6500	6500	7000	7500	8000	9100	9650	10000	12000
	PERSONAL PAY (IF ANY )ON 01.01.2006					0		INSTRUCTION-4			1	13125	14700	15400	16850	17900	1	2605	2670	2715	2820	3125	3285	3770	4100	4400	4625	5150	5450	5675	5875	6100	6700	6700	7225	7750	8275	9375	10025	10325	12375
	FILL"1"IF OPT FOR SCALE ON 31.12.95					0		INSTRUCTION-5
											2	13500	15100	15800	17300	18400	2	2660	2730	2780	2890	3200	3370	3855	4200	4500	4750	5300	5600	5850	6050	6300	6900	6900	7450	8000	8550	9650	10400	10650	12750
	YOU HAVE SELECTED										3	13875	15500	16200	17750	18900	3	2720	2790	2845	2960	3275	3455	3940	4300	4600	4875	5450	5750	6025	6225	6500	7100	7100	7675	8250	8825	9925	10775	10975	13125
	OLD PAY SCALE CODE					S-16					4	14250	15900	16600	18200	19400	4	2780	2850	2910	3030	3350	3540	4025	4400	4700	5000	5600	5900	6200	6400	6700	7300	7300	7900	8500	9100	10200	11150	11300	13500
	OLD PAY SCALE RANGE					6500-200-11100					5	14625	16300	17000	18650	19900	5	2840	2910	2975	3100	3425	3625	4110	4500	4800	5125	5750	6050	6375	6575	6900	7500	7500	8125	8750	9375	10475	11525	11625	13875
	BASIC PAY AS ON 01.01.2006					6700					6	15000	16700	17400	19100	20400	6	2900	2970	3040	3170	3500	3710	4195	4600	4900	5250	5900	6200	6550	6750	7100	7700	7700	8350	9000	9650	10750	11900	11950	14250
	INCREMENTS IN OLD PAYSCALE					1					7	15375	17100	17800	19550	20900	7	2960	3030	3105	3240	3575	3795	4280	4700	5000	5375	6050	6350	6725	6925	7300	7900	7900	8575	9250	9925	11025	12275	12275	14625
	BASIC PAY IN			1	2006	6700					8	15750	17500	18200	20000	21400	8	3020	3090	3170	3310	3650	3880	4365	4800	5100	5500	6200	6500	6900	7100	7500	8100	8100	8800	9500	10200	11300	12650	12600	15000
	BASIC PAY IN			1	2007	6900					9	16125	17900	18600	20450	21900	9	3080	3150	3235	3380	3725	3965	4450	4900	5200	5625	6350	6650	7075	7275	7700	8300	8300	9025	9750	10475	11575	13025	12925	15375
	BASIC PAY IN			1	2008	7100					10	16500	18300	19000	20900	22400	10	3140	3215	3300	3450	3800	4050	4535	5000	5300	5750	6500	6800	7250	7450	7900	8500	8500	9250	10000	10750	11850	13400	13250	15750
	BASIC PAY IN			1	2009	7300					11	16875	18700	19400	21350	22900	11	3200	3280	3370	3520	3875	4135	4620	5100	5400	5875	6650	6950	7425	7625	8100	8700	8700	9475	10250	11025	12125	13775	13575	16125
											12	17250	19100	19800	21800	23400	12	3260	3345	3440	3590	3950	4220	4705	5200	5500	6000	6800	7100	7600	7800	8300	8900	8900	9700	10500	11300	12400	14150	13900	16500
	YOUR NEW PAY DETAILS ARE										13	17625	19500	20200	22250	23900	13	3320	3410	3510	3660	4030	4305	4790	5300	5600	6125	6950	7250	7775	7975	8500	9100	9100	9925	10750	11575	12675	14525	14225	16875
	NEW PAY BAND RANGE					9300-34800					14	18000	19900	20600	22700	24400	14	3380	3475	3580	3730	4110	4390	4875	5400	5700	6250	7100	7400	7950	8150	8700	9300	9300	10150	11000	11850	12950	14900	14550	17250
	NEW PAY BAND					PB-2					15	18375	20300	21000	23150	24900	15	3440	3540	3650	3800	4190	4475	4960	5500	5800	6375	7250	7550	8125	8325	8900	9500	9500	10375	11250	12125	13225	15275	14875	17625
	NEW PAY IN PAY BAND					12470					16	18750	20700	21400	23600	25400	16	3500	3605	3720	3875	4270	4560	5045	5600	5900	6500	7400	7700	8300	8500	9100	9700	9700	10600	11500	12400	13500	15650	15200	18000
	GRADE PAY					4700					17	19125	21100	21800	24050	25900	17	3560	3670	3790	3950	4350	4645	5130	5700	6000	6625	7550	7850	8475	8675	9300	9900	9900	10825	11750	12675	13775	16025	15525	18375
	BASIC PAY AS ON 01.01.2006					17170					18	19500	21500	22200	24500	26400	18	3620	3735	3860	4025	4430	4730	5215	5800	6100	6750	7700	8000	8650	8850	9500	10100	10100	11050	12000	12950	14050	16400	15850	18750
	BASIC PAY AS ON 31.05.2009					18780					19	19875	21900	22600	24950	26900	19	3680	3800	3930	4100	4510	4815	5300	5900	6200	6875	7850	8150	8825	9025	9700	10300	10300	11275	12250	13225	14325	16775	16175	19125
	ARREARS (1/06TO 12/06)(NOTIONAL)					55536					20	20250	22300	23000	25400	27400	20	3740	3865	4000	4175	4590	4900	5385	6000	6300	7000	8000	8300	9000	9200	9900	10500	10500	11500	12500	13500	14600	17150	16500	19500
	ARREARS (1/07 TO 5/09)					138620					21	20625	22700	23400	25850	27900	21	3800	3930	4070	4250	4670	4985	5470	6100	6400	7125	8150	8450	9175	9375	10100	10700	10700	11725	12750	13775	14875	17525	16825	19875
	INTERIM ARREAR SANCTIONED					53874		arrears received < shown, by Rs.		3285	22	21000	23100	23800	26300	28400	22	3860	3995	4140	4325	4750	5070	5555	6200	6500	7250	8300	8600	9350	9550	10300	10900	10900	11950	13000	14050	15150	17900	17150	20250
	(3 MONTH BASIC+DP+ADA)							SEE NOTE BELOW			23	21375	23500	24200	26750	28900	23	3920	4060	4210	4400	4830	5155	5640	6300	6600	7375	8450	8750	9525	9725	10500	11100	11100	12175	13250	14325	15425	18275	17475	20625
	BALANCE ARREAR					84746					24	21750	23900	24600	27200	29400	24	3980	4125	4280	4475	4910	5240	5725	6400	6700	7500	8600	8900	9700	9900	10700	11300	11300	12400	13500	14600	15700	18650	17800	21000
	IST INSTALLMENT IN 09-10					28248
	IIND INSTALLMENT IN 10-11					28249												2006	2007	2008	2009	2010
	IIND INSTALLMENT IN 11-12					28249											1	2605	2660	2720	2780	2840	2550
																	2	2670	2730	2790	2850	2910	2610
	MONTH	DRAWN				DUE			ARREAR								3	2715	2780	2845	2910	2975	2650
		BASIC+spay	DP	DA	TOTAL	BASIC PAY	DA	TOTAL									4	2820	2890	2960	3030	3100	2750
1	Jan-06	6700	3350	2412	12462	17170	0	17170	4708								5	3125	3200	3275	3350	3425	3050
2	Feb-06	6700	3350	2412	12462	17170	0	17170	4708								6	3285	3370	3455	3540	3625	3200
3	Mar-06	6700	3350	2412	12462	17170	0	17170	4708								7	3770	3855	3940	4025	4110	3685
4	Apr-06	6700	3350	2412	12462	17170	0	17170	4708								8	4100	4200	4300	4400	4500	4000
5	May-06	6700	3350	2412	12462	17170	0	17170	4708								9	4400	4500	4600	4700	4800	4300
6	Jun-06	6700	3350	2412	12462	17170	0	17170	4708								10	4625	4750	4875	5000	5125	4500
7	Jul-06	6700	3350	2915	12965	17170	343	17513	4548								11	5150	5300	5450	5600	5750	5000
8	Aug-06	6700	3350	2915	12965	17170	343	17513	4548								12	5450	5600	5750	5900	6050	5300
9	Sep-06	6700	3350	2915	12965	17170	343	17513	4548								13	5675	5850	6025	6200	6375	5500
10	Oct-06	6700	3350	2915	12965	17170	343	17513	4548								14	5875	6050	6225	6400	6575	5700
11	Nov-06	6700	3350	2915	12965	17170	343	17513	4548								15	6100	6300	6500	6700	6900	5900
12	Dec-06	6700	3350	2915	12965	17170	343	17513	4548								16	6700	6900	7100	7300	7500	6500
1	Jan-07	6900	3450	3622	13972	17690	1061	18751	4779								17	6700	6900	7100	7300	7500	6500
2	Feb-07	6900	3450	3622	13972	17690	1061	18751	4779								18	7225	7450	7675	7900	8125	7000
3	Mar-07	6900	3450	3622	13972	17690	1061	18751	4779								19	7750	8000	8250	8500	8750	7500
4	Apr-07	6900	3450	3622	13972	17690	1061	18751	4779								20	8275	8550	8825	9100	9375	8000
5	May-07	6900	3450	3622	13972	17690	1061	18751	4779								21	9375	9650	9925	10200	10475	9100
6	Jun-07	6900	3450	3622	13972	17690	1061	18751	4779								22	10025	10400	10775	11150	11525	9650
7	Jul-07	6900	3450	4244	14594	17690	1592	19282	4688								23	10325	10650	10975	11300	11625	10000
8	Aug-07	6900	3450	4244	14594	17690	1592	19282	4688								24	12375	12750	13125	13500	13875	12000
9	Sep-07	6900	3450	4244	14594	17690	1592	19282	4688								25	13125	13500	13875	14250	14625	12750
10	Oct-07	6900	3450	4244	14594	17690	1592	19282	4688								26	14700	15100	15500	15900	16300	14300
11	Nov-07	6900	3450	4244	14594	17690	1592	19282	4688								27	15400	15800	16200	16600	17000	15000
12	Dec-07	6900	3450	4244	14594	17690	1592	19282	4688								28	16850	17300	17750	18200	18650	16400
1	Jan-08	7100	3550	5006	15656	18230	2188	20418	4762								29	17900	18400	18900	19400	19900	17400
2	Feb-08	7100	3550	5006	15656	18230	2188	20418	4762
3	Mar-08	7100	3550	5006	15656	18230	2188	20418	4762								14300	37400
4	Apr-08	7100	3550	5006	15656	18230	2188	20418	4762								14700	37400
5	May-08	7100	3550	5006	15656	18230	2188	20418	4762								15000	39690
6	Jun-08	7100	3550	5006	15656	18230	2188	20418	4762								15100	38530
7	Jul-08	7100	3550	5751	16401	18230	2917	21147	4746								15400	39690
8	Aug-08	7100	3550	5751	16401	18230	2917	21147	4746								15500	38530
9	Sep-08	7100	3550	5751	16401	18230	2917	21147	4746								15800	40890
10	Oct-08	7100	3550	5751	16401	18230	2917	21147	4746								15900	39690
11	Nov-08	7100	3550	5751	16401	18230	2917	21147	4746								16200	40890
12	Dec-08	7100	3550	5751	16401	18230	2917	21147	4746								16300	39690
1	Jan-09	7300	3650	7008	17958	18780	4132	22912	4954								16400	39690
2	Feb-09	7300	3650	7008	17958	18780	4132	22912	4954								16400	39690
3	Mar-09	7300	3650	7008	17958	18780	4132	22912	4954								16600	42120
4	Apr-09	7300	3650	7008	17958	18780	4132	22912	4954								16700	40890
5	May-09	7300	3650	7008	17958	18780	4132	22912	4954								16850	40890
	TOTAL	204500	102250	146778	453528	524940	67208	592148	138620								16850	40890
																	17000	42120
	Note:	arrears rs.	3285	on account of 10% Da increase from Jan 2009 has ben included in
		Interim arrears but same is yet to be received By many of you.															17100	40890
	(KINDLY REPORT AN ERROR ON GUPTARAJIN2002 AT THE RATE YAHOO.CO.IN																17300	40890
																	17300	40890
																	17400	43390
																	17400	42120
																	17500	42120
																	17750	42120
																	17750	42120
																	17800	43390
																	17900	42120
																	17900	42120
																	18200	44700
																	18200	42120
																	18200	42120
																	18300	43390
																	18400	43390
																	18600	44700
																	18650	43390
																	18650	43390
																	18700	43390
																	18900	43390
																	19000	44700
																	19100	44700
																	19100	43390
																	19100	43390
																	19400	46050
																	19400	44700
																	19500	44700
																	19550	44700
																	19550	44700
																	19800	46050
																	19900	44700
																	20000	44700
																	20000	44700
																	20400	46050
																	20450	46050
																	20450	46050
																	20900	46050
																	20900	46050
																	20900	46050
																	21350	47440
																	21350	47440
																	21400	47440
																	21800	47440
																	21900	47440
																	22250	48870

FILL UR DATA

new pay bands