DA ready Recknor software FINAL.xlsx

	A	C	D	E	G	H	I	K	L	M	N	R	S	T	U	V	W	Z	AA	AB	AD	AE	AF	AG	AK
1	DA READY RECKNOR TABLE WITH SALARY PARTICULAR DETAILS, CPS NET CASH												Prepared by Ramzan Ali, 949436244, 9494362266 visit us www.Guruvu.In	OLD EARNINGS ( www.Guruvu.In )					NEW EARNINGS		HIKED	14	CPS 10%	CPS 90%	GPF 100%
2	From July 2016 to August 2017 DA @3.68%													New BP	Old DA	HRA	GROSS	NDA	New GROSS	DA	MONTHS	Ded	NET	NET
4	GPF NET MONTHS NET:	0	New DA=	0.22008	Total Months	NOTE:	NDA=NEW DA, ODA=OLD DA, OBP=OLD BASIC PAY, NBP= NEW BASIC PAY,OGROSS=OLD GROSS, NGROSS=NEW GROSS							39160	7182	4699.2	51041	8618.3328	52478	1436.3328	20108.6592	2011	18098	0
5	Enter HRA:	0.12	Old DA=	0.1834	14	NOTE:								40270	7386	4832.4	52488	8862.6216	53965	1476.6216	20672.7024	2067	18605	0
7	OLD EARNINGS					NEW EARNINGS		HIKED	14	CPS 10%	CPS 90%	GPF 100%		42490	7793	5098.8	55382	9351.1992	56940	1558.1992	21814.7888	2181	19633	0
8	New BP	Old DA	HRA		GROSS	New DA	N.Gross	DA	MONTHS	Ded	NET	NET		43680	8011	5241.6	56933	9613.0944	58535	1602.0944	22429.3216	2243	20186	0
9	14170	2599	1700.4	Prepared by Ramzan Ali, 9494362244, 9494362266 visit us www.Guruvu.In	18469	3118.5336	18989	519.5336	7273.4704	727	6546	0		44870	8229	5384.4	58483	9874.9896	60129	1645.9896	23043.8544	2304	20739	0
10	14600	2678	1752		19030	3213.168	19565	535.168	7492.352	749	6743	0		46060	8447	5527.2	60034	10136.8848	61724	1689.8848	23658.3872	2366	21293	0
11	15030	2757	1803.6		19591	3307.8024	20141	550.8024	7711.2336	771	6940	0		47330	8680	5679.6	61690	10416.3864	63426	1736.3864	24309.4096	2431	21878	0
12	15460	2835	1855.2		20150	3402.4368	20718	567.4368	7944.1152	794	7150	0		48600	8913	5832	63345	10695.888	65128	1782.888	24960.432	2496	22464	0
13	15930	2922	1911.6		20764	3505.8744	21347	583.8744	8174.2416	817	7357	0		49870	9146	5984.4	65000	10975.3896	66830	1829.3896	25611.4544	2561	23050	0
14	16400	3008	1968		21376	3609.312	21977	601.312	8418.368	842	7577	0		51230	9396	6147.6	66774	11274.6984	68652	1878.6984	26301.7776	2630	23672	0
15	16870	3094	2024.4		21988	3712.7496	22607	618.7496	8662.4944	866	7796	0		52590	9645	6310.8	68546	11574.0072	70475	1929.0072	27006.1008	2701	24305	0
16	17380	3187	2085.6		22653	3824.9904	23291	637.9904	8931.8656	893	8039	0		53950	9894	6474	70318	11873.316	72297	1979.316	27710.424	2771	24939	0
17	17890	3281	2146.8		23318	3937.2312	23974	656.2312	9187.2368	919	8269	0		55410	10162	6649.2	72221	12194.6328	74254	2032.6328	28456.8592	2846	25611	0
18	18400	3375	2208		23983	4049.472	24657	674.472	9442.608	944	8498	0		56870	10430	6824.4	74124	12515.9496	76210	2085.9496	29203.2944	2920	26283	0
19	18950	3475	2274		24699	4170.516	25395	695.516	9737.224	974	8764	0		58330	10698	6999.6	76028	12837.2664	78167	2139.2664	29949.7296	2995	26955	0
20	19500	3576	2340		25416	4291.56	26132	715.56	10017.84	1002	9016	0		59890	10984	7186.8	78061	13180.5912	80257	2196.5912	30752.2768	3075	27677	0
21	20050	3677	2406		26133	4412.604	26869	735.604	10298.456	1030	9269	0		61450	11270	7374	80094	13523.916	82348	2253.916	31554.824	3155	28399	0
22	20640	3785	2476.8		26902	4542.4512	27659	757.4512	10604.3168	1060	9544	0		63010	11556	7561.2	82127	13867.2408	84438	2311.2408	32357.3712	3236	29122	0
23	21230	3894	2547.6		27672	4672.2984	28450	778.2984	10896.1776	1090	9807	0		64670	11860	7760.4	84290	14232.5736	86663	2372.5736	33216.0304	3322	29894	0
24	21820	4002	2618.4		28440	4802.1456	29241	800.1456	11202.0384	1120	10082	0		66330	12165	7959.6	86455	14597.9064	88888	2432.9064	34060.6896	3406	30655	0
25	22460	4119	2695.2		29274	4942.9968	30098	823.9968	11535.9552	1154	10382	0		67990	12469	8158.8	88618	14963.2392	91112	2494.2392	34919.3488	3492	31427	0
26	23100	4237	2772		30109	5083.848	30956	846.848	11855.872	1186	10670	0		69750	12792	8370	90912	15350.58	93471	2558.58	35820.12	3582	32238	0
27	23740	4237	2848.8		30826	5224.6992	31813	987.6992	13827.7888	1383	12445	0		71510	13115	8581.2	93206	15737.9208	95829	2622.9208	36720.8912	3672	33049	0
28	24440	4482	2932.8		31855	5378.7552	32752	896.7552	12554.5728	1255	11299	0		73270	13438	8792.4	95500	16125.2616	98188	2687.2616	37621.6624	3762	33859	0
29	25140	4611	3016.8		32768	5532.8112	33690	921.8112	12905.3568	1291	11615	0		75150	13783	9018	97951	16539.012	100707	2756.012	38584.168	3858	34726	0
30	25840	4739	3100.8		33680	5686.8672	34628	947.8672	13270.1408	1327	11943	0		77030	14127	9243.6	100401	16952.7624	103226	2825.7624	39560.6736	3956	35605	0
31	26600	4878	3192		34670	5854.128	35646	976.128	13665.792	1367	12299	0		78910	14472	9469.2	102851	17366.5128	105746	2894.5128	40523.1792	4052	36471	0
32	27360	5018	3283.2		35661	6021.3888	36665	1003.3888	14047.4432	1405	12643	0		80930	14843	9711.6	105485	17811.0744	108453	2968.0744	41553.0416	4155	37398	0
33	28120	5157	3374.4		36651	6188.6496	37683	1031.6496	14443.0944	1444	12999	0		82950	15213	9954	108117	18255.636	111160	3042.636	42596.904	4260	38337	0
34	28940	5308	3472.8		37721	6369.1152	38782	1061.1152	14855.6128	1486	13370	0		84970	15583	10196.4	110749	18700.1976	113867	3117.1976	43640.7664	4364	39277	0
35	29760	5458	3571.2		38789	6549.5808	39881	1091.5808	15282.1312	1528	13754	0		87130	15980	10455.6	113566	19175.5704	116761	3195.5704	44737.9856	4474	40264	0
36	30580	5608	3669.6		39858	6730.0464	40980	1122.0464	15708.6496	1571	14138	0		89290	16376	10714.8	116381	19650.9432	119656	3274.9432	45849.2048	4585	41264	0
37	31460	5770	3775.2		41005	6923.7168	42159	1153.7168	16152.0352	1615	14537	0		91420	16766	10970.4	119156	20119.7136	122510	3353.7136	46951.9904	4695	42257	0
38	32340	5931	3880.8		42152	7117.3872	43338	1186.3872	16609.4208	1661	14948	0		93780	17199	11253.6	122233	20639.1024	125673	3440.1024	48161.4336	4816	43345	0
39	33220	6093	3986.4		43299	7311.0576	44517	1218.0576	17052.8064	1705	15348	0		96110	17627	11533.2	125270	21151.8888	128795	3524.8888	49348.4432	4935	44414	0
40	34170	6267	4100.4		44537	7520.1336	45791	1253.1336	17543.8704	1754	15789	0		98440	18054	11812.8	128307	21664.6752	131917	3610.6752	50549.4528	5055	45495	0
41	35120	6441	4214.4		45775	7729.2096	47064	1288.2096	18034.9344	1803	16231	0		100770	18481	12092.4	131343	22177.4616	135040	3696.4616	51750.4624	5175	46575	0
42	36070	6615	4328.4		47013	7938.2856	48337	1323.2856	18525.9984	1853	16673	0		103290	18943	12394.8	134628	22732.0632	138417	3789.0632	53046.8848	5305	47742	0
43	37100	6804	4452		48356	8164.968	49717	1360.968	19053.552	1905	17148	0		105810	19406	12697.2	137913	23286.6648	141794	3880.6648	54329.3072	5433	48896	0
44	38130	6993	4575.6		49699	8391.6504	51097	1398.6504	19581.1056	1958	17623	0		108330	19868	12999.6	141198	23841.2664	145171	3973.2664	55625.7296	5563	50063	0
45
46
47
48
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