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

	updated on 07.06.2009
	FILL ONLY THREE YELLOW CELL
	SELECT YOUR OLD PAY SCALE CODE					11		INSTRUCTION -1
	NO OF INCREMENT IN OLD SCALE					8		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					240		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
										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-11				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					5000-150-8000				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					6200				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					8				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	6200				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	6350				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	6500				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	6650				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					11980				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					4200				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					16180				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					17700				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)					49470				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)					127007				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					50847				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)									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					76160				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					25386
	IIND INSTALLMENT IN 10-11					25387
	IIND INSTALLMENT IN 11-12					25387										1	3020	3080	3140	3200	3260
																2	3090	3150	3215	3280	3345
	MONTH	DRAWN				DUE			ARREAR							3	3170	3235	3300	3370	3440
		BASIC+spay	DP	DA	TOTAL	BASIC PAY	DA	TOTAL								4	3310	3380	3450	3520	3590
1	Jan-06	6440	3220	2318	11978	16180	0	16180	4202							5	3650	3725	3800	3875	3950
2	Feb-06	6440	3220	2318	11978	16180	0	16180	4202							6	3880	3965	4050	4135	4220
3	Mar-06	6440	3220	2318	11978	16180	0	16180	4202							7	4365	4450	4535	4620	4705
4	Apr-06	6440	3220	2318	11978	16180	0	16180	4202							8	4800	4900	5000	5100	5200
5	May-06	6440	3220	2318	11978	16180	0	16180	4202							9	5100	5200	5300	5400	5500
6	Jun-06	6440	3220	2318	11978	16180	0	16180	4202							10	5500	5625	5750	5875	6000
7	Jul-06	6440	3220	2801	12461	16180	324	16504	4043							11	6200	6350	6500	6650	6800
8	Aug-06	6440	3220	2801	12461	16180	324	16504	4043							12	6500	6650	6800	6950	7100
9	Sep-06	6440	3220	2801	12461	16180	324	16504	4043							13	6900	7075	7250	7425	7600
10	Oct-06	6440	3220	2801	12461	16180	324	16504	4043							14	7100	7275	7450	7625	7800
11	Nov-06	6440	3220	2801	12461	16180	324	16504	4043							15	7500	7700	7900	8100	8300
12	Dec-06	6440	3220	2801	12461	16180	324	16504	4043							16	8100	8300	8500	8700	8900
1	Jan-07	6590	3295	3460	13345	16670	1000	17670	4325							17	8100	8300	8500	8700	8900
2	Feb-07	6590	3295	3460	13345	16670	1000	17670	4325							18	8800	9025	9250	9475	9700
3	Mar-07	6590	3295	3460	13345	16670	1000	17670	4325							19	9500	9750	10000	10250	10500
4	Apr-07	6590	3295	3460	13345	16670	1000	17670	4325							20	10200	10475	10750	11025	11300
5	May-07	6590	3295	3460	13345	16670	1000	17670	4325							21	11300	11575	11850	12125	12400
6	Jun-07	6590	3295	3460	13345	16670	1000	17670	4325							22	12650	13025	13400	13775	14150
7	Jul-07	6590	3295	4053	13938	16670	1500	18170	4232							23	12600	12925	13250	13575	13900
8	Aug-07	6590	3295	4053	13938	16670	1500	18170	4232							24	15000	15375	15750	16125	16500
9	Sep-07	6590	3295	4053	13938	16670	1500	18170	4232							25	15750	16125	16500	16875	17250
10	Oct-07	6590	3295	4053	13938	16670	1500	18170	4232							26	17500	17900	18300	18700	19100
11	Nov-07	6590	3295	4053	13938	16670	1500	18170	4232							27	18200	18600	19000	19400	19800
12	Dec-07	6590	3295	4053	13938	16670	1500	18170	4232							28	20000	20450	20900	21350	21800
1	Jan-08	6740	3370	4752	14862	17180	2062	19242	4380							29	21400	21900	22400	22900	23400
2	Feb-08	6740	3370	4752	14862	17180	2062	19242	4380
3	Mar-08	6740	3370	4752	14862	17180	2062	19242	4380							14300	37400
4	Apr-08	6740	3370	4752	14862	17180	2062	19242	4380							14700	37400
5	May-08	6740	3370	4752	14862	17180	2062	19242	4380							15000	39690
6	Jun-08	6740	3370	4752	14862	17180	2062	19242	4380							15100	38530
7	Jul-08	6740	3370	5459	15569	17180	2749	19929	4360							15400	39690
8	Aug-08	6740	3370	5459	15569	17180	2749	19929	4360							15500	38530
9	Sep-08	6740	3370	5459	15569	17180	2749	19929	4360							15800	40890
10	Oct-08	6740	3370	5459	15569	17180	2749	19929	4360							15900	39690
11	Nov-08	6740	3370	5459	15569	17180	2749	19929	4360							16200	40890
12	Dec-08	6740	3370	5459	15569	17180	2749	19929	4360							16300	39690
1	Jan-09	6890	3445	6614	16949	17700	3894	21594	4645							16400	39690
2	Feb-09	6890	3445	6614	16949	17700	3894	21594	4645							16400	39690
3	Mar-09	6890	3445	6614	16949	17700	3894	21594	4645							16600	42120
4	Apr-09	6890	3445	6614	16949	17700	3894	21594	4645							16700	40890
5	May-09	6890	3445	6614	16949	17700	3894	21594	4645							16850	40890
	TOTAL	194410	97205	139414	431029	494700	63336	558036	127007							16850	40890
																17000	42120
																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