6_CPC_ARREARS FOR MACP

	A	B	C	D	E	F	G	H	I	J
1	THIS CALCULATION IS FOR THOSE 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	5000	DA JUL06	2%	DAJAN10	35%	OLD FIXATION	4900
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	21086
13	MONTH	PRESENT	DUE				DRAWN			DIFFERENCE
14		BASIC	DA	HRA	TOTAL	BASIC	DA	HRA	TOTAL	AMOUNT
15	Jan-06	11700	-	1170	12870	11520	-	1152	12672	198
16	Feb-06	11700	-	1170	12870	11520	-	1152	12672	198
17	Mar-06	11700	-	1170	12870	11520	-	1152	12672	198
18	Apr-06	11700	-	1170	12870	11520	-	1152	12672	198
19	May-06	11700	-	1170	12870	11520	-	1152	12672	198
20	Jun-06	11700	-	1170	12870	11520	-	1152	12672	198
21	Jul-06	12060	241	1206	13507	11870	237	1187	13294	213
22	Aug-06	12060	241	1206	13507	11870	237	1187	13294	213
23	Sep-06	12060	241	1206	13507	11870	237	1187	13294	213
24	Oct-06	12060	241	1206	13507	11870	237	1187	13294	213
25	Nov-06	12060	241	1206	13507	11870	237	1187	13294	213
26	Dec-06	12060	241	1206	13507	11870	237	1187	13294	213
27	Jan-07	12060	724	1206	13990	11870	712	1187	13769	221
28	Feb-07	12060	724	1206	13990	11870	712	1187	13769	221
29	Mar-07	12060	724	1206	13990	11870	712	1187	13769	221
30	Apr-07	12060	724	1206	13990	11870	712	1187	13769	221
31	May-07	12060	724	1206	13990	11870	712	1187	13769	221
32	Jun-07	12060	724	1206	13990	11870	712	1187	13769	221
33	Jul-07	12430	1119	1243	14792	12230	1101	1223	14554	238
34	Aug-07	12430	1119	1243	14792	12230	1101	1223	14554	238
35	Sep-07	12430	1119	1243	14792	12230	1101	1223	14554	238
36	Oct-07	12430	1119	1243	14792	12230	1101	1223	14554	238
37	Nov-07	12430	1119	1243	14792	12230	1101	1223	14554	238
38	Dec-07	12430	1119	1243	14792	12230	1101	1223	14554	238
39	Jan-08	12430	1492	1243	15165	12230	1468	1223	14921	244
40	Feb-08	12430	1492	1243	15165	12230	1468	1223	14921	244
41	Mar-08	12430	1492	1243	15165	12230	1468	1223	14921	244
42	Apr-08	12430	1492	1243	15165	12230	1468	1223	14921	244
43	May-08	12430	1492	1243	15165	12230	1468	1223	14921	244
44	Jun-08	12430	1492	1243	15165	12230	1468	1223	14921	244
45	Jul-08	12810	2050	1281	16141	12600	2016	1260	15876	265
46	Aug-08	12810	2050	1281	16141	12600	2016	1260	15876	265
47	Sep-08	13600	2176	1360	17136	13380	2141	1338	16859	277
48	Oct-08	13600	2176	1360	17136	13380	2141	1338	16859	277
49	Nov-08	13600	2176	1360	17136	13380	2141	1338	16859	277
50	Dec-08	13600	2176	1360	17136	13380	2141	1338	16859	277
51	Jan-09	13600	2992	1360	17952	13380	2944	1338	17662	290
52	Feb-09	13600	2992	1360	17952	13380	2944	1338	17662	290
53	Mar-09	13600	2992	1360	17952	13380	2944	1338	17662	290
54	Apr-09	13600	2992	1360	17952	13380	2944	1338	17662	290
55	May-09	13600	2992	1360	17952	13380	2944	1338	17662	290
56	Jun-09	13600	2992	1360	17952	13380	2944	1338	17662	290
57	Jul-09	14010	3783	1401	19194	13790	3723	1379	18892	302
58	Aug-09	14010	3783	1401	19194	13790	3723	1379	18892	302
59	Sep-09	14010	3783	1401	19194	13790	3723	1379	18892	302
60	Oct-09	14010	3783	1401	19194	13790	3723	1379	18892	302
61	Nov-09	14010	3783	1401	19194	13790	3723	1379	18892	302
62	Dec-09	14010	3783	1401	19194	13790	3723	1379	18892	302
63	Jan-10	14010	4904	1401	20315	13790	4827	1379	19996	319
64	Feb-10	14010	4904	1401	20315	13790	4827	1379	19996	319
65	Mar-10	14010	4904	1401	20315	13790	4827	1379	19996	319
66	Apr-10	14010	4904	1401	20315	13790	4827	1379	19996	319
67	May-10	14010	4904	1401	20315	13790	4827	1379	19996	319
68	Jun-10	14010	4904	1401	20315	13790	4827	1379	19996	319
69	Jul-10	14430	6494	1443	22367	14210	6395	1421	22026	341
70	Aug-10	14430	6494	1443	22367	14210	6395	1421	22026	341
71	Sep-10	14430	6494	1443	22367	14210	6395	1421	22026	341
72	Oct-10	14430	6494	1443	22367	14210	6395	1421	22026	341
73	Nov-10	14430	6494	1443	22367	14210	6395	1421	22026	341
74	Dec-10	14430	6494	1443	22367	14210	6395	1421	22026	341
75	Jan-11	14430	7359	1443	23232	14210	7247	1421	22878	354
76	Feb-11	14430	7359	1443	23232	14210	7247	1421	22878	354
77	Mar-11	14430	7359	1443	23232	14210	7247	1421	22878	354
78	Apr-11	14430	7359	1443	23232	14210	7247	1421	22878	354
79	May-11	14430	7359	1443	23232	14210	7247	1421	22878	354
80	Jun-11	14430	7359	1443	23232	14210	7247	1421	22878	354
81	Jul-11	14870	8625	1487	24982	14640	8491	1464	24595	387
82	Aug-11	14870	8625	1487	24982	14640	8491	1464	24595	387
83	Sep-11	14870	8625	1487	24982	14640	8491	1464	24595	387
84	Oct-11	14870	8625	1487	24982	14640	8491	1464	24595	387
85	Nov-11	14870	8625	1487	24982	14640	8491	1464	24595	387
86	Dec-11	14870	8625	1487	24982	14640	8491	1464	24595	387
87	Jan-12	14870	9666	1487	26023	14640	9516	1464	25620	403
88	Feb-12	14870	9666	1487	26023	14640	9516	1464	25620	403
89			TOTAL		1343068				1321982	21086
90
91
92		IF PARTICIPATED IN STRIKE THEN PLEASE DEDUCT THE AMOUNT MANUALLY AFTER PRINTOUT