User talk:G nageshreddy

CM W.ING DAYS=LOOKUP(F5,{1,2,3,4,5,6,7,8,9,10,11,12},{31,28,31,30,31,30,31,31,30,31,30,31}) LOP FOR NJ=IF(I5="Y",IF(G5>=$B$1,(G5-$B$1),0),0) LM WORKING DAYS=LOOKUP(F5,{1,2,3,4,5,6,7,8,9,10,11,12},{31,31,28,31,30,31,30,31,31,30,31,30,31}) LM WORKED DAYS=IF(I5="Y",IF(G5<=$B$1,$B$1-G5,0),0)-IF(I5="Y",IF(G5<=$B$2,$B$2-G5,0)) LM ED DAYS 1=LOOKUP(F5,{1,2,3,4,5,6,7,8,9,10,11,12},{30,31,31,28,31,30,31,30,31,31,30,31,30}) LM ING DAYS 2=IF(I5="Y",IF(G5<=$B$2,$B$2-G5,0),0)

PT==IF(M5="KN",IF(DY5<=2999,0,IF(DY5<=4999,0,IF(DY5<=7999,0,IF(DY5<=9999,0,IF(DY5<=14999,150,200))))),0)+IF(M5="TN",IF(DY5<=3499,0,IF(DY5<=4999,13,IF(DY5<=7499,33,IF(DY5<=9999,65,IF(DY5<=12499,98,130))))),0)+IF(M5="MP",IF(DY5<=10000,0,IF(DY5<=12500,83,IF(DY5<=15000,125,208))),0)+IF(M5="BHU",IF(DY5<=5000,0,IF(DY5<=6000,30,IF(DY5<=8000,50,IF(DY5<=10000,75,IF(DY5<=15000,100,IF(DY5<=20000,150,200)))))),0)+IF(M5="HYD",IF(DY5<=5000,0,IF(DY5<=6000,60,IF(DY5<=10000,80,IF(DY5<=15000,100,IF(DY5<=20000,150,200))))),0) PT Mum==IF(M5="MH",IF(DY5<=2000,0,IF(DY5<=2500,0,IF(DY5<=3500,0,IF(DY5<=5000,0,IF(DY5<=10000,175,200))))),0)

Phil Health Monthly Salary Bracket	From	To	Salary Base (SB)	Personal Share (PS) (PS=SBx1.25%)(Employee Share)	Employer Share (ES=PS)	Total Monthly Contribution 1	1	4999.99	4,000.00	50	50	100 2	5000	5,999.99	5,000.00	62.5	62.5	125 3	6000	6,999.99	6,000.00	75	75	150 4	7000	7,999.99	7,000.00	87.5	87.5	175 5	8000	8,999.99	8,000.00	100	100	200 6	9000	9,999.99	9,000.00	112.5	112.5	225 7	10000	10,999.99	10,000.00	125	125	250 8	11000	11,999.99	11,000.00	137.5	137.5	275 9	12000	12,999.99	12,000.00	150	150	300 10	13000	13,999.99	13,000.00	162.5	162.5	325 11	14000	14,999.99	14,000.00	175	175	350 12	15000	15,999.99	15,000.00	187.5	187.5	375 13	16000	16,999.99	16,000.00	200	200	400 14	17000	17,999.99	17,000.00	212.5	212.5	425 15	18000	18,999.99	18,000.00	225	225	450 16	19000	19,999.99	19,000.00	237.5	237.5	475 17	20000	999999	20,000.00	250	250	500

SSS Contribution Employer BRACKET	From	To	Employee	SS	EC I 	1000.00	1249.99	33.3	70.7	10 II 	1250.00	1749.99	50	106	10 III 	1750.00	2,249.99	66.7	141.3	10 IV 	2250.00	2,749.99	83.3	176.7	10 V 	2750.00	3,249.99	100	212	10 VI 	3250.00	3,749.99	116.7	247.3	10 VII 	3750.00	4,249.99	133.3	282.7	10 VIII 	4250.00	4,749.99	150	318	10 IX 	4750.00	5249.99	166.7	353.3	10 X 	5250.00	5,749.99	183.3	388.7	10 XI 	5750.00	6,249.99	200	424	10 XII 	6250.00	6,749.99	216.7	459.3	10 XIII 	6750.00	7,249.99	233.3	494.7	10 XIV 	7250.00	7,749.99	250	530	10 XV 	7750.00	8,249.99	266.7	565.3	10 XVI 	8250.00	8,749.99	283.3	600.7	10 XVII 	8750.00	9,249.99	300	636	10 XVIII 	9250.00	9,749.99	316.7	671.3	10 XIX 	9750.00	10,249.99	333.3	706.7	10 XX 	10250.00	10,749.99	350	742	10 XXI 	10750.00	11,249.99	366.7	777.3	10 XXII 	11250.00	11,749.99	383.3	812.7	10 XXIII 	11750.00	12,249.99	400	848	10 XXIV 	12250.00	12,749.99	416.7	883.3	10 XXV 	12750.00	13,249.99	433.3	918.7	10 XXVI 	13250.00	13,749.99	450	954	10 XXVII 	13750.00	14,249.99	466.7	989.3	10 XXVIII 	14250.00	14,749.99	483.3	1024.7	10 XXIX 	14750.00	99999999999	500	1060	30

Tin TIN Slabs Report for Year/Month-2011/1 As on Year/Month-2012/4 "SL NO." "Start Value"	"End Value"	"Deduction Percentage"	"Deduction Fixed Amou" Z	 Zero Exemption 1	0.00	416.99	5.00	0.00 2	417.00	1249.99	10.00	20.83 3	1250.00	2916.99	15.00	104.17 4	2917.00	5832.99	20.00	354.17 5	5833.00	10416.99	25.00	937.50 6	10417.00	20832.99	30.00	2083.33 7	20833.00	999999999.00	32.00	5208.33 S	 Single 8	0.00	2082.99	0.00	0.00 9	2083.00	2499.99	5.00	0.00 10	2500.00	3332.99	10.00	20.83 11	3333.00	4999.99	15.00	104.17 12	5000.00	7916.99	20.00	354.17 13	7917.00	12499.99	25.00	937.50 14	12500.00	22916.99	30.00	2083.33 15	22917.00	9999999999.00	32.00	5208.33 S1	 Single 1 Dependent 16	0.00	3124.99	0.00	0.00 17	3125.00	3541.99	5.00	0.00 18	3542.00	4374.99	10.00	20.83 19	4375.00	6041.99	15.00	104.17 20	6042.00	8957.99	20.00	354.17 21	8958.00	13541.99	25.00	937.50 22	13542.00	23957.99	30.00	2083.33 23	23958.00	99999999.00	32.00	5208.33 S2	 Single 2 Dependents 24	0.00	4166.99	0.00	0.00 25	4167.00	4582.99	5.00	0.00 26	4583.00	5416.99	10.00	20.83 27	5417.00	7082.99	15.00	104.17 28	7083.00	9999.99	20.00	354.17 29	10000.00	14582.99	25.00	937.50 30	14583.00	24999.99	30.00	2083.33 31	25000.00	999999999.00	32.00	5208.33 S3	 Single 3 Dependents 32	0.00	5207.99	0.00	0.00 33	5208.00	5624.99	5.00	0.00 34	5625.00	6457.99	10.00	20.83 35	6458.00	8124.99	15.00	104.17 36	8125.00	11041.99	20.00	354.17 37	11042.00	15624.99	25.00	937.50 38	15625.00	26041.99	30.00	2083.33 39	26042.00	99999999.00	32.00	5208.33 S4	 Single 4 Dependents 40	0.00	6249.99	0.00	0.00 41	6250.00	6666.99	5.00	0.00 42	6667.00	7499.99	10.00	20.83 43	7500.00	9166.99	15.00	104.17 44	9167.00	12082.99	20.00	354.17 45	12083.00	16666.99	25.00	937.50 46	16667.00	27082.99	30.00	2083.33 47	27083.00	99999999.00	32.00	5208.33 ME	 Married Employee 48	0.00	2082.99	0.00	0.00 49	2083.00	2499.99	5.00	0.00 50	2500.00	3332.99	10.00	20.83 51	3333.00	4999.99	15.00	104.17 52	5000.00	7916.99	20.00	354.17 53	7917.00	12499.99	25.00	937.50 54	12500.00	22916.99	30.00	2083.33 55	22917.00	999999999.00	32.00	5208.33 ME1	 Married with 1 Dependent 56	0.00	3124.99	0.00	0.00 57	3125.00	3541.99	5.00	0.00 58	3542.00	4374.99	10.00	20.83 59	4375.00	6041.99	15.00	104.17 60	6042.00	8957.99	20.00	354.17 61	8958.00	13541.99	25.00	937.50 62	13542.00	23957.99	30.00	2083.33 63	23958.00	99999999.00	32.00	5208.33 ME2	 Married with 2 Dependents 64	0.00	4166.99	0.00	0.00 65	4167.00	4582.99	5.00	0.00 66	4583.00	5416.99	10.00	20.83 67	5417.00	7082.99	15.00	104.17 68	7083.00	9999.99	20.00	354.17 69	10000.00	14582.99	25.00	937.50 70	14583.00	24999.99	30.00	2083.33 71	25000.00	999999999.00	32.00	5208.33 ME3	 Married with 3 Dependents 72	0.00	5207.99	0.00	0.00 73	5208.00	5624.99	5.00	0.00 74	5625.00	6457.99	10.00	20.83 75	6458.00	8124.99	15.00	104.17 76	8125.00	11041.99	20.00	354.17 77	11042.00	15624.99	25.00	937.50 78	15625.00	26041.99	30.00	2083.33 79	26042.00	99999999.00	32.00	5208.33 ME4	 Married with 3 Dependents 80	0.00	6249.99	0.00	0.00 81	6250.00	6666.99	5.00	0.00 82	6667.00	7499.99	10.00	20.83 83	7500.00	9166.99	15.00	104.17 84	9167.00	12082.99	20.00	354.17 85	12083.00	16666.99	25.00	937.50 86	16667.00	27082.99	30.00	2083.33 87	27083.00	9999999999.00	32.00	5208.33