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

	Sixth Pay Commission Arrears Calculation with Promotion / Cadre Review



Read the
Instruction in F81


		Employee Code :										Fifth Pay Commission		Sixth Pay Commission
		Name of the Employee :		:					Pay Scale			S-10 (5500-175-9000)		PB2 (8700-34800)
		Designation :		:					Basic Pay from Pay Scale :			5500		8700
		Pay Scale as on Jan'06 :		:	S-10 (5500-175-9000)				Increment :			175		4200	(Grade Pay)
		No. of Increments. as on Jan'06 :			0				Basic Pay on Jan - 2006			5500		9570
		Increment Month :			January				Dearness Pay			2750		4200	(Grade Pay)
		Enter New HRA rate :		:	0	%
		Enter Travelling Allowance :			0				Change of Scale on Promotion			0		0.0
									Basic Pay from Pay Scale			0.0		0.0
		Change of Scale on Promotion :			0				Increment :			0.0		0.0	(Grade Pay)
		Enter Basic Pay on Promotion/C.R :			0				Basic Pay on Promotion/C.R			0		0
		Enter Increment Month :			N/A				Dearness Pay			0		0	(Grade Pay)


		Pay Due									Pay Drawn							Total
		Month & Year	Fixed	Grade Pay	B.P.+G.P	D.A.	P.Tax	Total	Grand Total		Basic Pay	D.P.	B.P.+D.P	D.A	P.Tax	Total	Grand Total	Arrears
	1	Jan - 06	9570	4200	13770	0		13770	13770		5500	2750	8250	1980		10230	10230	3540	0	1
	2	Feb - 06	9570	4200	13770	0		13770	13770		5500	2750	8250	1980		10230	10230	3540	1	1
	3	Mar - 06	9570	4200	13770	0		13770	13770		5500	2750	8250	1980		10230	10230	3540	1	1
	4	Apr - 06	9570	4200	13770	0		13770	13770		5500	2750	8250	1980		10230	10230	3540	1	1
	5	May - 06	9570	4200	13770	0		13770	13770		5500	2750	8250	1980		10230	10230	3540	1	1
	6	Jun - 06	9570	4200	13770	0		13770	13770		5500	2750	8250	1980		10230	10230	3540	1	1
	7	Jul - 06	9914	4200	14114	0		14114	14114		5500	2750	8250	2393		10643	10643	3471	1	1
	8	Aug - 06	9914	4200	14114	0		14114	14114		5500	2750	8250	2393		10643	10643	3471	1	1
	9	Sep - 06	9914	4200	14114	0		14114	14114		5500	2750	8250	2393		10643	10643	3471	1	1
	10	Oct - 06	9914	4200	14114	0		14114	14114		5500	2750	8250	2393		10643	10643	3471	1	1
	11	Nov - 06	9914	4200	14114	0		14114	14114		5500	2750	8250	2393		10643	10643	3471	1	1
	12	Dec - 06	9914	4200	14114	0		14114	14114		5500	2750	8250	2393		10643	10643	3471	1	1
	13	Jan - 07	9914	4200	14114	847		14961	14961		5675	2838	8513	2980		11493	11493	3468	0	1
	14	Feb - 07	9914	4200	14114	847		14961	14961		5675	2838	8513	2980		11493	11493	3468	1	1
	15	Mar - 07	9914	4200	14114	847		14961	14961		5675	2838	8513	2980		11493	11493	3468	1	1
	16	Apr - 07	9914	4200	14114	847		14961	14961		5675	2838	8513	2980		11493	11493	3468	1	1
	17	May - 07	9914	4200	14114	847		14961	14961		5675	2838	8513	2980		11493	11493	3468	1	1
	18	Jun - 07	9914	4200	14114	847		14961	14961		5675	2838	8513	2980		11493	11493	3468	1	1
	19	Jul - 07	10267	4200	14467	1736		16203	16203		5675	2838	8513	3490		12003	12003	4200	1	1
	20	Aug - 07	10267	4200	14467	1736		16203	16203		5675	2838	8513	3490		12003	12003	4200	1	1
	21	Sep - 07	10267	4200	14467	1736		16203	16203		5675	2838	8513	3490		12003	12003	4200	1	1
	22	Oct - 07	10267	4200	14467	1736		16203	16203		5675	2838	8513	3490		12003	12003	4200	1	1
	23	Nov - 07	10267	4200	14467	1736		16203	16203		5675	2838	8513	3490		12003	12003	4200	1	1
	24	Dec - 07	10267	4200	14467	1736		16203	16203		5675	2838	8513	3490		12003	12003	4200	1	1
	25	Jan - 08	10267	4200	14467	2604		17071	17071		5850	2925	8775	4124		12899	12899	4172	0	1
	26	Feb - 08	10267	4200	14467	2604		17071	17071		5850	2925	8775	4124		12899	12899	4172	1	1
	27	Mar - 08	10267	4200	14467	2604		17071	17071		5850	2925	8775	4124		12899	12899	4172	1	1
	28	Apr - 08	10267	4200	14467	2604		17071	17071		5850	2925	8775	4124		12899	12899	4172	1	1
	29	May - 08	10267	4200	14467	2604		17071	17071		5850	2925	8775	4124		12899	12899	4172	1	1
	30	Jun - 08	10267	4200	14467	2604		17071	17071		5850	2925	8775	4124		12899	12899	4172	1	1
	31	Jul - 08	10629	4200	14829	3114		17943	17943		5850	2925	8775	4300		13075	13075	4868	1	1
	32	Aug - 08	10629	4200	14829	3114		17943	17943		5850	2925	8775	4300		13075	13075	4868	1	1
	33	Sep - 08	10629	4200	14829	3114		17943	17943		5850	2925	8775	4300		13075	13075	4868	1	1
	34	Oct - 08	10629	4200	14829	3114		17943	17943		5850	2925	8775	4300		13075	13075	4868	1	1
	35	Nov - 08	10629	4200	14829	3114		17943	17943		5850	2925	8775	4300		13075	13075	4868	1	1
	36	Dec - 08	10629	4200	14829	3114		17943	17943		5850	2925	8775	4300		13075	13075	4868	1	1
		upto Apr-08	279058	117600	396658	25914	0	422572	422572	0	157500	78756	236256	81554	0	317810	317810	104762

		Dearness Allowance rates
		Jan-06	Jul-06	Jan-07	Jul-07	Jan-08	Jul-08						B.PAY	G.PAY	DA	TA	HRA	GROSS
		24	29	35	41	47	49						10267	4200	2604	0	0	17071
		0	0	6	12	18	21






M. Dhandapani
Assistant Director (Computer)
National Silkworm Seed Organisation
Central Silk Board
Madiwala, B.T.M. Layout
BANGALORE - 560 068
Phone : 080-26282412
E-Mail : dhandapani_muthu@yahoo.com

					Instructions for calculating the Sixth Pay arrears

					1. Set the Macro Security in Ms-Excel to Low once only

								Tools

								Macros

								Security

								Click Low (recommended)

								Click Ok

					2. Save and Exit the file. Reopen the file again.


					3. Enter the Information from C9 to C16 and check your Basic Pay on
					January 2006 i.e. M13

					4. If there is no Promotion / Cadre Review from January 2006 to till month
					press the Command Button ( Calculate arrear ) available on Column A20

					5. In case of Promotion / Cadre Review i.e. after January 2006 enter the information
					from C18 to C20 and press the command button (Calculate arrear) and also press the
					corresponding Month and Year of promotion buttons available A26 to A60

					6. The Print Sheet buttons prints this sheet to your default printer.

					7. You can undo the calculation using the Calculate arrear button. It calculates arrear basing on the
					Information C9 to C16 only.

					8. Columns C61 to S61 contains the sum from Jan'06 to Apr'08. User can sum the data for
					next months using =Sum(D25.. D ) and drag upto S61.

					9. Dearness Allowance rate can be changed as per the Pay Commission recommendation.

PayArrear

PBand