6_CPC_ARREARS WITHOUT MACP

	A	B	C	D	E	F	G	H	I	J
1	THIS CALCULATION IS FOR THOSE NOT GETTING MACP ON SEPTEMBER 2008
2	ENTER THE NEW FIXATION COLUMN AND OLD FIXATION COLUMN ONLY. DON’T MODIFY ANY OTHER FIELDS PLEASE
3
4		NEWFIXATION	4800	DA JUL06	2%	DAJAN10	35%	OLD FIXATION	4700
5		INCREMENT	3%	DAJAN07	6%	DAJUL10	45%
6				DAJUL07	9%	DAJAN11	51%
7				DAJAN08	12%	DAJUL11	58%
8				DAJUL08	16%	DAJAN12	65%
9				DAJAN09	22%
10				DAJUL09	27%
11
12		ARREAR AMT	18892
13	MONTH	PRESENT	DUE				DRAWN			DIFFERENCE
14		BASIC	DA	HRA	TOTAL	BASIC	DA	HRA	TOTAL	AMOUNT
15	Jan-06	11330	-	1133	12463	11150	-	1115	12265	198
16	Feb-06	11330	-	1133	12463	11150	-	1115	12265	198
17	Mar-06	11330	-	1133	12463	11150	-	1115	12265	198
18	Apr-06	11330	-	1133	12463	11150	-	1115	12265	198
19	May-06	11330	-	1133	12463	11150	-	1115	12265	198
20	Jun-06	11330	-	1133	12463	11150	-	1115	12265	198
21	Jul-06	11670	233	1167	13070	11490	230	1149	12869	201
22	Aug-06	11670	233	1167	13070	11490	230	1149	12869	201
23	Sep-06	11670	233	1167	13070	11490	230	1149	12869	201
24	Oct-06	11670	233	1167	13070	11490	230	1149	12869	201
25	Nov-06	11670	233	1167	13070	11490	230	1149	12869	201
26	Dec-06	11670	233	1167	13070	11490	230	1149	12869	201
27	Jan-07	11670	700	1167	13537	11490	689	1149	13328	209
28	Feb-07	11670	700	1167	13537	11490	689	1149	13328	209
29	Mar-07	11670	700	1167	13537	11490	689	1149	13328	209
30	Apr-07	11670	700	1167	13537	11490	689	1149	13328	209
31	May-07	11670	700	1167	13537	11490	689	1149	13328	209
32	Jun-07	11670	700	1167	13537	11490	689	1149	13328	209
33	Jul-07	12020	1082	1202	14304	11840	1066	1184	14090	214
34	Aug-07	12020	1082	1202	14304	11840	1066	1184	14090	214
35	Sep-07	12020	1082	1202	14304	11840	1066	1184	14090	214
36	Oct-07	12020	1082	1202	14304	11840	1066	1184	14090	214
37	Nov-07	12020	1082	1202	14304	11840	1066	1184	14090	214
38	Dec-07	12020	1082	1202	14304	11840	1066	1184	14090	214
39	Jan-08	12020	1442	1202	14664	11840	1421	1184	14445	219
40	Feb-08	12020	1442	1202	14664	11840	1421	1184	14445	219
41	Mar-08	12020	1442	1202	14664	11840	1421	1184	14445	219
42	Apr-08	12020	1442	1202	14664	11840	1421	1184	14445	219
43	May-08	12020	1442	1202	14664	11840	1421	1184	14445	219
44	Jun-08	12020	1442	1202	14664	11840	1421	1184	14445	219
45	Jul-08	12380	1981	1238	15599	12200	1952	1220	15372	227
46	Aug-08	12380	1981	1238	15599	12200	1952	1220	15372	227
47	Sep-08	12380	1981	1238	15599	12200	1952	1220	15372	227
48	Oct-08	12380	1981	1238	15599	12200	1952	1220	15372	227
49	Nov-08	12380	1981	1238	15599	12200	1952	1220	15372	227
50	Dec-08	12380	1981	1238	15599	12200	1952	1220	15372	227
51	Jan-09	12380	2724	1238	16342	12200	2684	1220	16104	238
52	Feb-09	12380	2724	1238	16342	12200	2684	1220	16104	238
53	Mar-09	12380	2724	1238	16342	12200	2684	1220	16104	238
54	Apr-09	12380	2724	1238	16342	12200	2684	1220	16104	238
55	May-09	12380	2724	1238	16342	12200	2684	1220	16104	238
56	Jun-09	12380	2724	1238	16342	12200	2684	1220	16104	238
57	Jul-09	12760	3445	1276	17481	12570	3394	1257	17221	260
58	Aug-09	12760	3445	1276	17481	12570	3394	1257	17221	260
59	Sep-09	12760	3445	1276	17481	12570	3394	1257	17221	260
60	Oct-09	12760	3445	1276	17481	12570	3394	1257	17221	260
61	Nov-09	12760	3445	1276	17481	12570	3394	1257	17221	260
62	Dec-09	12760	3445	1276	17481	12570	3394	1257	17221	260
63	Jan-10	12760	4466	1276	18502	12570	4400	1257	18227	275
64	Feb-10	12760	4466	1276	18502	12570	4400	1257	18227	275
65	Mar-10	12760	4466	1276	18502	12570	4400	1257	18227	275
66	Apr-10	12760	4466	1276	18502	12570	4400	1257	18227	275
67	May-10	12760	4466	1276	18502	12570	4400	1257	18227	275
68	Jun-10	12760	4466	1276	18502	12570	4400	1257	18227	275
69	Jul-10	13150	5918	1315	20383	12950	5828	1295	20073	310
70	Aug-10	13150	5918	1315	20383	12950	5828	1295	20073	310
71	Sep-10	13150	5918	1315	20383	12950	5828	1295	20073	310
72	Oct-10	13150	5918	1315	20383	12950	5828	1295	20073	310
73	Nov-10	13150	5918	1315	20383	12950	5828	1295	20073	310
74	Dec-10	13150	5918	1315	20383	12950	5828	1295	20073	310
75	Jan-11	13150	6707	1315	21172	12950	6605	1295	20850	322
76	Feb-11	13150	6707	1315	21172	12950	6605	1295	20850	322
77	Mar-11	13150	6707	1315	21172	12950	6605	1295	20850	322
78	Apr-11	13150	6707	1315	21172	12950	6605	1295	20850	322
79	May-11	13150	6707	1315	21172	12950	6605	1295	20850	322
80	Jun-11	13150	6707	1315	21172	12950	6605	1295	20850	322
81	Jul-11	13550	7859	1355	22764	13340	7737	1334	22411	353
82	Aug-11	13550	7859	1355	22764	13340	7737	1334	22411	353
83	Sep-11	13550	7859	1355	22764	13340	7737	1334	22411	353
84	Oct-11	13550	7859	1355	22764	13340	7737	1334	22411	353
85	Nov-11	13550	7859	1355	22764	13340	7737	1334	22411	353
86	Dec-11	13550	7859	1355	22764	13340	7737	1334	22411	353
87	Jan-12	13550	8808	1355	23713	13340	8671	1334	23345	368
88	Feb-12	13550	8808	1355	23713	13340	8671	1334	23345	368
89			TOTAL		1249112				1230220	18892
90
91
92		IF PARTICIPATED IN STRIKE THEN PLEASE DEDUCT THE AMOUNT MANUALLY AFTER PRINTOUT