{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["GA 55A","Tax Calculaton Old","Tax Calculaton New","Summary"],"not_rendered":{"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"GA 55A","index":0,"n_rows":31,"n_cols":33,"rows_kept":31,"merged":[[0,0,0,24],[1,0,1,24],[3,1,3,3],[3,5,3,7],[3,9,3,10],[3,11,3,12],[3,13,3,16],[3,17,3,19],[3,20,3,21],[3,23,3,24],[4,1,4,3],[4,5,4,7],[4,9,4,10],[4,11,4,12],[4,13,4,16],[4,17,4,19],[4,20,4,22],[30,0,30,2],[30,6,30,19],[30,23,30,24]]}
["Office of the Principal DIET Kuchaman City (Nagaur)"]
["Salary and Deduction Detail for FY : 2021-22"]
[]
["नाम कर्मचारी-","Ashwini Kumar Sharma",null,null,"पद-","Lecturer",null,null,"लेवल-","L-12",null,"Employee ID-",null,"RJNA201228008021",{"$nulls":3},"मार्च का बेसिक-",null,null,{"v":34800,"d":"34800.00"},null,"TAN No.","ABCD1234E"]
["पैन नं.-","AAAA9456A",null,null,"Mobile-",9166023711,null,null,"SI No.-",123456,null,"GPF/PRAN No.-",null,12345678910,{"$nulls":3},"बैंक खाता सं.-",null,null,1234567891011,null,null,"IS NPS","YES"]
["Month & Year","Basic Pay","DA","HRA","Washing Allow.","Handicaped Allowance","CCA Allowance","Govt.- NPS","Gross Salary","SIP","GPF","Emp -NPS","GPF Loan","RPMF","SI Loan","GIS","LIC","COVIS-19","GPF 2004","Hitkari Nidhi","Govt.- NPS","ITAX","Total Deduction","NET Payment","Bill No./ Dte"]
["2021-03-01",{"$f":"IF(U4=\"\",\"\",U4)","v":{"v":34800,"d":"34,800"}},{"$f":"ROUND(IF(B7=\"\",0,B7*17%),0)","v":{"v":5916,"d":"5,916"}},{"$f":"ROUND(IF(B7=\"\",0,B7*8%),0)","v":{"v":2784,"d":"2,784"}},0,0,0,{"$f":"L7","v":{"v":4072,"d":"4,072"}},{"$f":"SUM(B7:H7)","v":{"v":47572,"d":"47,572"}},{"v":3000,"d":"3,000"},null,{"$f":"IF($Y$5=\"YES\",ROUND((B7+C7)*0.1,0),0)","v":{"v":4072,"d":"4,072"}},0,{"$f":"IF($Y$5=\"No\",IF(B7<18001,265,IF(B7<33501,440,IF(B7<54001,658,875))),0)","v":0},0,null,{"v":1919,"d":"1,919"},{"$nulls":3},{"$f":"L7","v":{"v":4072,"d":"4,072"}},null,{"$f":"SUM(J7:V7)","v":{"v":13063,"d":"13,063"}},{"$f":"I7-W7","v":{"v":34509,"d":"34,509"}}]
["2021-04-01",{"$f":"B7","v":{"v":34800,"d":"34,800"}},{"$f":"ROUND(IF(B8=\"\",0,B8*17%),0)","v":{"v":5916,"d":"5,916"}},{"$f":"ROUND(IF(B8=\"\",0,B8*8%),0)","v":{"v":2784,"d":"2,784"}},{"$f":"E7","v":0},{"$f":"F7","v":0},{"$f":"G7","v":0},{"$f":"L8","v":{"v":4072,"d":"4,072"}},{"v":47572,"d":"47,572"},{"$f":"J7","v":{"v":3000,"d":"3,000"}},{"$f":"K7","v":0},{"v":4072,"d":"4,072"},{"$f":"M7","v":0},{"$f":"IF($Y$5=\"No\",IF(B8<18001,265,IF(B8<33501,440,IF(B8<54001,658,875))),0)","v":0},{"$f":"O7","v":0},220,{"$f":"Q7","v":{"v":1919,"d":"1,919"}},{"$nulls":3},{"$f":"L8","v":{"v":4072,"d":"4,072"}},{"$f":"V7","v":0},{"v":13283,"d":"13,283"},{"v":34289,"d":"34,289"}]
["2021-05-01",{"$f":"B8","v":{"v":34800,"d":"34,800"}},{"$f":"ROUND(IF(B9=\"\",0,B9*17%),0)","v":{"v":5916,"d":"5,916"}},{"$f":"ROUND(IF(B9=\"\",0,B9*8%),0)","v":{"v":2784,"d":"2,784"}},0,0,0,{"v":4072,"d":"4,072"},{"v":47572,"d":"47,572"},{"v":3000,"d":"3,000"},0,{"v":4072,"d":"4,072"},0,{"$f":"IF($Y$5=\"No\",IF(B9<18001,265,IF(B9<33501,440,IF(B9<54001,658,875))),0)","v":0},0,null,{"v":1919,"d":"1,919"},{"$nulls":3},{"v":4072,"d":"4,072"},0,{"v":13063,"d":"13,063"},{"v":34509,"d":"34,509"}]
["2021-06-01",{"$f":"B9","v":{"v":34800,"d":"34,800"}},{"$f":"ROUND(IF(B10=\"\",0,B10*17%),0)","v":{"v":5916,"d":"5,916"}},{"$f":"ROUND(IF(B10=\"\",0,B10*8%),0)","v":{"v":2784,"d":"2,784"}},0,0,0,{"v":4072,"d":"4,072"},{"v":47572,"d":"47,572"},{"v":3000,"d":"3,000"},0,{"v":4072,"d":"4,072"},0,{"$f":"IF($Y$5=\"No\",IF(B10<18001,265,IF(B10<33501,440,IF(B10<54001,658,875))),0)","v":0},0,null,{"v":1919,"d":"1,919"},{"$nulls":3},{"v":4072,"d":"4,072"},0,{"v":13063,"d":"13,063"},{"v":34509,"d":"34,509"}]
["2021-07-01",{"$f":"MROUND(B10*1.03,100)","v":{"v":35800,"d":"35,800"}},{"$f":"ROUND(IF(B11=\"\",0,B11*28%),0)","v":{"v":10024,"d":"10,024"}},{"$f":"ROUND(IF(B11=\"\",0,B11*8%),0)","v":{"v":2864,"d":"2,864"}},0,0,0,{"v":4582,"d":"4,582"},{"v":53270,"d":"53,270"},{"v":3000,"d":"3,000"},0,{"v":4582,"d":"4,582"},0,{"$f":"IF($Y$5=\"No\",IF(B11<18001,265,IF(B11<33501,440,IF(B11<54001,658,875))),IF($Y$5=\"NO\",0,IF(B11<18001,135,IF(B11<33501,220,IF(B11<54001,330,440)))))","v":330},0,null,{"v":1919,"d":"1,919"},{"$nulls":3},{"v":4582,"d":"4,582"},0,{"v":14413,"d":"14,413"},{"v":38857,"d":"38,857"},{"$nulls":6},{"$f":"ROUND(B11*3%,0)","v":1074},{"$f":"ROUND(AE11*10%,0)","v":107},{"$f":"AE11-AF11","v":967}]
["2021-08-01",{"$f":"B11","v":{"v":35800,"d":"35,800"}},{"$f":"ROUND(IF(B12=\"\",0,B12*28%),0)","v":{"v":10024,"d":"10,024"}},{"$f":"ROUND(IF(B12=\"\",0,B12*9%),0)","v":{"v":3222,"d":"3,222"}},0,0,0,{"v":4582,"d":"4,582"},{"v":53628,"d":"53,628"},{"v":3000,"d":"3,000"},0,{"v":4582,"d":"4,582"},0,330,0,null,{"v":1919,"d":"1,919"},{"$nulls":3},{"v":4582,"d":"4,582"},0,{"v":14413,"d":"14,413"},{"v":39215,"d":"39,215"},{"$nulls":6},{"$f":"ROUND(B12*3%,0)","v":1074},{"$f":"ROUND(AE12*10%,0)","v":107},{"$f":"AE12-AF12","v":967}]
["2021-09-01",{"v":35800,"d":"35,800"},{"$f":"ROUND(IF(B13=\"\",0,B13*28%),0)","v":{"v":10024,"d":"10,024"}},{"v":3222,"d":"3,222"},0,0,0,{"v":4582,"d":"4,582"},{"v":53628,"d":"53,628"},{"v":3000,"d":"3,000"},0,{"v":4582,"d":"4,582"},0,330,0,null,{"v":1919,"d":"1,919"},{"$nulls":3},{"v":4582,"d":"4,582"},0,{"v":14413,"d":"14,413"},{"v":39215,"d":"39,215"},{"$nulls":6},1074,107,967]
["2021-10-01",{"v":35800,"d":"35,800"},{"$f":"ROUND(IF(B14=\"\",0,B14*31%),0)","v":{"v":11098,"d":"11,098"}},{"v":3222,"d":"3,222"},0,0,0,{"v":4690,"d":"4,690"},{"v":54810,"d":"54,810"},{"v":3000,"d":"3,000"},0,{"v":4690,"d":"4,690"},0,330,0,null,{"v":1919,"d":"1,919"},{"$nulls":3},{"v":4690,"d":"4,690"},0,{"v":14629,"d":"14,629"},{"v":40181,"d":"40,181"}]
["2021-11-01",{"v":35800,"d":"35,800"},{"$f":"ROUND(IF(B15=\"\",0,B15*31%),0)","v":{"v":11098,"d":"11,098"}},{"v":3222,"d":"3,222"},0,0,0,{"v":4690,"d":"4,690"},{"v":54810,"d":"54,810"},{"v":3000,"d":"3,000"},0,{"v":4690,"d":"4,690"},0,330,0,null,{"v":1919,"d":"1,919"},{"$nulls":3},{"v":4690,"d":"4,690"},0,{"v":14629,"d":"14,629"},{"v":40181,"d":"40,181"}]
["2021-12-01",{"v":35800,"d":"35,800"},{"$f":"ROUND(IF(B16=\"\",0,B16*31%),0)","v":{"v":11098,"d":"11,098"}},{"v":3222,"d":"3,222"},0,0,0,{"v":4690,"d":"4,690"},{"v":54810,"d":"54,810"},{"v":3000,"d":"3,000"},0,{"v":4690,"d":"4,690"},0,330,0,null,{"v":1919,"d":"1,919"},null,null,250,{"v":4690,"d":"4,690"},0,{"v":14879,"d":"14,879"},{"v":39931,"d":"39,931"}]
["2022-01-01",{"v":35800,"d":"35,800"},{"$f":"ROUND(IF(B17=\"\",0,B17*31%),0)","v":{"v":11098,"d":"11,098"}},{"v":3222,"d":"3,222"},0,0,0,{"v":4690,"d":"4,690"},{"v":54810,"d":"54,810"},{"v":3000,"d":"3,000"},0,{"v":4690,"d":"4,690"},0,330,0,null,{"v":1919,"d":"1,919"},{"$nulls":3},{"v":4690,"d":"4,690"},0,{"v":14629,"d":"14,629"},{"v":40181,"d":"40,181"}]
["2022-02-01",{"v":35800,"d":"35,800"},{"$f":"ROUND(IF(B18=\"\",0,B18*31%),0)","v":{"v":11098,"d":"11,098"}},{"v":3222,"d":"3,222"},0,0,0,{"v":4690,"d":"4,690"},{"v":54810,"d":"54,810"},{"v":3000,"d":"3,000"},0,{"v":4690,"d":"4,690"},0,330,0,null,{"v":1919,"d":"1,919"},{"$nulls":3},{"v":4690,"d":"4,690"},0,{"v":14629,"d":"14,629"},{"v":40181,"d":"40,181"}]
["HRA Arrear July 2021",null,null,{"$f":"ROUND(1%*B11,0)","v":358},{"$nulls":3},{"$f":"L19","v":0},358,{"$nulls":11},0,null,0,358]
["Bonus",{"v":6774,"d":"6,774"},{"$nulls":5},0,{"v":6774,"d":"6,774"},null,{"$f":"IF($Y$5=\"No\",ROUND($B$20*50%,0),0)","v":0},{"$nulls":7},{"$f":"IF($Y$5=\"YES\",ROUND($B$20*50%,0),0)","v":{"v":3387,"d":"3,387"}},null,0,null,{"v":3387,"d":"3,387"},{"v":3387,"d":"3,387"}]
["Surrender",{"$nulls":6},0,0,{"$nulls":11},0,null,0,0]
["DA Arrear",null,{"$f":"ROUND(B11*3%,0)*3","v":{"v":3222,"d":"3,222"}},{"$nulls":4},321,{"v":3543,"d":"3,543"},null,{"$f":"IF(Y5=\"NO\",ROUND(B11*3%,0)*3,0)","v":0},{"$f":"IF($Y$5=\"YES\",SUM(AF11:AF13),0)","v":321},{"$nulls":6},{"$f":"IF(Y5=\"YES\",SUM(AG11:AG13),0)","v":{"v":2901,"d":"2,901"}},null,321,null,{"v":3543,"d":"3,543"},0]
["Fixation Arrear",{"$nulls":6},0,0,null,null,{"$f":"IF($Y$5=\"YES\",ROUND((B23+C23)*0.1,0),0)","v":0},{"$nulls":8},0,null,0,0]
["March 2020 Due Salary",{"v":12232,"d":"12,232"},{"$nulls":5},{"v":1223,"d":"1,223"},{"v":13455,"d":"13,455"},null,null,{"v":1223,"d":"1,223"},{"$nulls":8},{"v":1223,"d":"1,223"},null,{"v":2446,"d":"2,446"},{"v":11009,"d":"11,009"}]
["Salary Arrear1",{"$nulls":6},0,0,null,null,0,{"$nulls":8},0,null,0,0]
["Salary Arrear2",{"$nulls":6},0,0,null,null,0,{"$nulls":8},0,null,0,0]
["Other",{"$nulls":6},0,0,null,null,0,{"$nulls":8},0,null,0,0]
["Total",{"$f":"SUM(B7:B27)","v":{"v":444606,"d":"444,606"}},{"$f":"SUM(C7:C27)","v":{"v":112448,"d":"112,448"}},{"v":36912,"d":"36,912"},0,0,0,{"v":55028,"d":"55,028"},{"v":648994,"d":"648,994"},{"v":36000,"d":"36,000"},0,{"v":55028,"d":"55,028"},0,{"v":2640,"d":"2,640"},0,220,{"v":23028,"d":"23,028"},0,{"v":6288,"d":"6,288"},250,{"v":55028,"d":"55,028"},0,{"v":178482,"d":"178,482"},{"v":470512,"d":"470,512"}]
[]
[]
["Signature Of Employee",{"$nulls":5},"Prepared By Ashwini Kumar : 9166023711 www.ashwinisharma.com",{"$nulls":16},"Signature Of DDO"]

{"sheet":"Tax Calculaton Old","index":1,"n_rows":66,"n_cols":13,"rows_kept":66,"merged":[[0,0,0,12],[1,0,1,12],[2,1,2,2],[2,3,2,7],[2,9,2,10],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,0,9,0],[6,1,6,10],[6,12,8,12],[7,1,7,10],[8,1,8,10],[9,1,9,11],[10,1,10,11],[11,0,14,0],[11,1,11,6],[11,7,11,9],[11,10,11,11],[11,12,13,12],[12,1,13,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,11],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,11],[14,1,14,11],[15,1,15,11],[16,1,16,11],[17,1,17,11],[18,1,18,12],[19,1,19,12],[20,2,20,4],[20,5,20,6],[20,8,20,10],[20,12,29,12],[21,2,21,4],[21,5,21,6],[21,8,21,10],[22,2,22,4],[22,5,22,6],[22,8,22,10],[23,2,23,4],[23,5,23,6],[23,8,23,10],[24,2,24,4],[24,5,24,6],[24,8,24,10],[25,2,25,4],[25,5,25,6],[25,8,25,10],[26,2,26,4],[26,5,26,6],[26,8,26,10],[27,2,27,4],[27,5,27,6],[27,8,27,10],[28,2,28,4],[28,5,28,6],[28,7,29,7],[28,8,29,10],[28,11,29,11],[29,2,29,4],[29,5,29,6],[30,1,30,11],[31,2,31,11],[32,2,32,11],[33,1,33,11],[34,1,34,11],[35,2,35,11],[36,2,36,11],[37,2,37,11],[38,2,38,11],[39,2,39,11],[40,2,40,11],[41,2,41,11],[42,2,42,11],[43,2,43,11],[44,1,44,11],[45,1,45,11],[46,1,46,11],[47,1,47,11],[48,1,48,11],[49,1,49,4],[49,5,49,8],[49,9,49,11],[50,1,50,3],[50,5,50,7],[50,9,50,10],[51,1,51,3],[51,5,51,7],[51,9,51,10],[52,1,52,3],[52,5,52,7],[52,9,52,10],[53,1,53,3],[53,5,53,7],[53,9,53,10],[54,2,54,11],[55,2,55,11],[56,2,56,11],[57,2,57,11],[58,1,58,11],[59,1,59,11],[60,1,60,11],[61,0,62,0],[61,1,62,2],[61,3,61,4],[61,5,61,6],[61,7,61,8],[61,9,61,10],[62,3,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[63,0,63,11],[65,0,65,3],[65,5,65,10],[65,11,65,12]]}
[{"$f":"'GA 55A'!A1","v":"Office of the Principal DIET Kuchaman City (Nagaur)"}]
["आयकर गणना प्रपत्र वर्ष 2021-22"]
[1,"नाम कर्मचारी",null,{"$f":"IF('GA 55A'!B4=\"\",\"\",'GA 55A'!B4)","v":"Ashwini Kumar Sharma"},{"$nulls":4},"पद",{"$f":"IF('GA 55A'!F4=\"\",\"\",'GA 55A'!F4)","v":"Lecturer"},null,"पैन नं.",{"$f":"IF('GA 55A'!B5=\"\",\"\",'GA 55A'!B5)","v":"AAAA9456A"}]
[2,"आय वर्ष 2020-21 में प्राप्त कुल वेतन -",{"$nulls":10},{"$f":"IF('GA 55A'!I28=\"\",\"\",'GA 55A'!I28)","v":{"v":648994,"d":"648994.00"}}]
[3,"गृह किराया, धारा 10 (13-A) के अंतर्गत एवं धारा 10 (14) के अंतर्गत अन्य भत्ते जो कर मुक्त है -",{"$nulls":10},{"v":0,"d":"0.00"}]
[4,"शेष (2-3)",{"$nulls":10},{"$f":"M4-M5","v":{"v":648994,"d":"648994.00"}}]
[5,"(I)Standard Deduction Maxium 50000 धारा 16 (i a)",{"$nulls":9},{"$f":"IF($M$6>50000,50000,$M$6)","v":{"v":50000,"d":"50000.00"}}]
[null,"(II)मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत Maxium 5000",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,"(III)वयवसाय कर धारा 16 (iii) के अंतर्गत",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,"योग 5",{"$nulls":10},{"$f":"SUM(L7:L9)","v":{"v":50000,"d":"50000.00"}}]
[6,"शेष (4-5)",{"$nulls":10},{"$f":"M6-M10","v":{"v":598994,"d":"598994.00"}}]
[7,"(अ) गृह सम्पति से आय (1) स्वयं के उपयोग में शून्य",{"$nulls":5},"(2) प्राप्त किराया रूपये",null,null,{"v":0,"d":"0.00"}]
[null,"(ब) घटाइए",null,"किराये का 30%",null,"गृह ऋण पर ब्याज",null,"गृह कर",null,"योग 7 (ब)"]
[{"$nulls":3},{"$f":"ROUND($K$12*0.3,0)","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"$f":"SUM(D14:I14)","v":{"v":0,"d":"0.00"}}]
[null,"शेष - / + (7(अ) एवं 7 (ब) का)",{"$nulls":10},{"$f":"$K$12-$J$14","v":{"v":0,"d":"0.00"}}]
[8,"कुल शेष - / + (6 एवं 7)",{"$nulls":10},{"$f":"$M$11+$M$15","v":{"v":598994,"d":"598994.00"}}]
[9,"अन्य आय",{"$nulls":10},{"v":0,"d":"0.00"}]
[10,"सकल आय (योग 8+9)",{"$nulls":10},{"$f":"SUM(M16:M17)","v":{"v":598994,"d":"598994.00"}}]
[11,"कटौतिया घटाइए - धारा US 80C, 80CCC, 80CCD(1)"]
[null,"(A) अधिकतम सीमा 150000 (धारा 80CCE), धारा 80CCD(2) के अलावा"]
[null,1,"राज्य बीमा (SI)",null,null,{"$f":"'GA 55A'!$J$28","v":{"v":36000,"d":"36000.00"}},null,11,"EPEF (80CCD1)",null,null,{"$f":"IF('GA 55A'!$Y$5=\"Yes\",'GA 55A'!L28-M33,0)","v":{"v":55028,"d":"55028.00"}}]
[null,2,"LIC",null,null,{"$f":"'GA 55A'!Q28","v":{"v":23028,"d":"23028.00"}},null,12,"पेंशन प्लान हेतु अंशदान धारा (80CCC)",null,null,{"v":0,"d":"0.00"}]
[null,3,"GPF / GPF 2004",null,null,{"$f":"'GA 55A'!K28+'GA 55A'!S28","v":{"v":6288,"d":"6288.00"}},null,13,"राष्ट्रीय बचत पत्र पर ब्याज",null,null,{"v":0,"d":"0.00"}]
[null,4,"राष्ट्रीय बचत पत्र (NSC)",null,null,{"v":0,"d":"0.00"},null,14,"ट्यूशन फीस",null,null,{"v":0,"d":"0.00"}]
[null,5,"लोक भविष्य निधि (PPF)",null,null,{"v":0,"d":"0.00"},null,15,"इक्विटी लिंक सेविंग स्कीम",null,null,{"v":0,"d":"0.00"}]
[null,6,"राष्ट्रीय बचत स्कीम (NSS)",null,null,{"v":0,"d":"0.00"},null,16,"Defferred Annuty",null,null,{"v":0,"d":"0.00"}]
[null,7,"GIS",null,null,{"$f":"'GA 55A'!P28","v":{"v":220,"d":"220.00"}},null,17,"PLI",null,null,{"v":0,"d":"0.00"}]
[null,8,"ULIP / वार्षिक प्लान",null,null,{"v":0,"d":"0.00"},null,18,"धारा 80C के अंतर्गत अन्य जमा राशि",null,null,{"v":0,"d":"0.00"}]
[null,9,"Home Loan Premium",null,null,{"v":0,"d":"0.00"},null,19,"योग 1 से 18 तक",null,null,{"$f":"SUM(F21:G30,L21:L28)","v":{"v":120564,"d":"120564.00"}}]
[null,10,"सुकन्या योजना में जमा",null,null,{"v":0,"d":"0.00"}]
[null,"अधिकतम कटौती राशि रूपए 150000 तक ",{"$nulls":10},{"$f":"IF($L$29<150001,ROUND($L$29,0),150000)","v":{"v":120564,"d":"120564.00"}}]
[null,"(B)","घटाइए धारा 80CCD (2) नियोक्ता द्वारा पेंशन अंशदान की राशि (अधिकतम वेतन का 10%)",{"$nulls":9},{"$f":"IF('GA 55A'!$Y$5=\"Yes\",'GA 55A'!L28,0)","v":{"v":55028,"d":"55028.00"}}]
[null,"(C)","घटाइए धारा 80CCD (1B)नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रूपए 50000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,"योग 11 (A+B+C)",{"$nulls":10},{"$f":"SUM(M31:M33)","v":{"v":175592,"d":"175592.00"}}]
[12,"अन्य कटौतिया"]
[null,1,"धारा 80 D, चिकित्सा बीमा प्रीमियम (स्वयं,पति/पत्नी व बच्चों के लिए रू 25000, माता-पिता के लिए रू 25000,सीनियर सिटीजन रू 50000)",{"$nulls":9},{"$f":"'GA 55A'!N28","v":{"v":2640,"d":"2640.00"}}]
[null,2,"धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता 125,000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,3,"धारा 80 DB विशिष्ट रोंगों के उपचार हेतु कटौती (अधिकतम रू 40,000, सीनियर सिटीजन हेतु रू 100,000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,4,"धारा 80 E उच्च शिक्षा हेतु लिए ऋण का ब्याज",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,5,"धारा 80 G धर्मार्थ संस्थाओं आदि को दिये दान ( क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,6,"धारा 80 U स्थाई रूप से शारीरिक असमर्थतता की दशा में (अधिकतम 75,000 तथा  अधिनियम 1995के अनुसार 125,000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,7,"धारा 80 TTA बचत खाते पर ब्याज की अधिकतम छूट रू. 10,000  U/S 194(IA)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,8,"धारा 80 TTB वरिष्ठ नागरिकों को सभी प्रकार के ब्याज पर अधिकतम छूट-  50000 रू.  U/S 194(A)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,9,"धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,"योग 12 (1 to 9)",{"$nulls":10},{"$f":"SUM(M36:M44)","v":{"v":2640,"d":"2640.00"}}]
[13,"कुल कटौती (11+12)",{"$nulls":10},{"$f":"SUM(M34,M45)","v":{"v":178232,"d":"178232.00"}}]
[14,"कर योग्य आय (10-13)",{"$nulls":10},{"$f":"$M$18-$M$46","v":{"v":420762,"d":"420762.00"}}]
[15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288 A ",{"$nulls":10},{"$f":"ROUND($M$47,-1)","v":{"v":420760,"d":"420760.00"}}]
[16,"आयकर की गणना"]
[null,"एक व्यक्ति कर दाता ",{"$nulls":3},"वरिष्ठ नागरिक (60 से 80 वर्ष)",{"$nulls":3},"80 वर्ष या अधिक आयु"]
[null,"250000 तक",null,null,"NIL","300000 तक",null,null,"NIL",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"250001 से 50000 तक",null,null,{"v":0.05,"d":"5%"},"300001 से 50000 तक",null,null,{"v":0.05,"d":"5%"},"50000 तक",null,"NIL",{"$f":"ROUND(IF(M48<250001,0,IF(M48>500000,12500,((M48-250000)*0.05))),0)","v":{"v":8538,"d":"8538.00"}}]
[null,"500001 से 1000000 तक",null,null,{"v":0.2,"d":"20%"},"500001 से 1000000 तक",null,null,{"v":0.2,"d":"20%"},"500001 से 1000000 तक",null,{"v":0.2,"d":"20%"},{"$f":"IF(M48<500001,0,IF(M48>1000000,100000,((M48-500000)*0.2)))","v":{"v":0,"d":"0.00"}}]
[null,"1000001 से अधिक",null,null,{"v":0.3,"d":"30%"},"1000001 से अधिक",null,null,{"v":0.3,"d":"30%"},"1000001 से अधिक",null,{"v":0.3,"d":"30%"},{"$f":"IF(M48<1000001,0,((M48-1000000)*0.3))","v":{"v":0,"d":"0.00"}}]
[null,1,"योग आयकर",{"$nulls":9},{"$f":"SUM(M51:M54)","v":{"v":8538,"d":"8538.00"}}]
[null,2,"छूट घारा 87(A) (2.50 लाख से 5 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रू. 12500 तक)",{"$nulls":9},{"$f":"IF(M48>500000,0,IF(M55<12501,M55,12500))","v":{"v":8538,"d":"8538.00"}}]
[null,3,"शेष आयकर (1-2)",{"$nulls":9},{"$f":"M55-M56","v":{"v":0,"d":"0.00"}}]
[null,4,"शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2%  (योग 4%)",{"$nulls":9},{"$f":"ROUND(M57*0.04,0)","v":{"v":0,"d":"0.00"}}]
[null,"कुल आयकर (3+4)",{"$nulls":10},{"$f":"SUM(M57:M58)","v":{"v":0,"d":"0.00"}}]
[17,"घटाइये :- राहत धारा 89 के तहत",{"$nulls":10},{"v":0,"d":"0.00"}]
[18,"कुल शेष आयकर",{"$nulls":10},{"$f":"M59-M60","v":{"v":0,"d":"0.00"}}]
[19,"आयकर कटौती का विवरण",null,"सितम्बर   2021 तक",null,"अक्टूबर से दिसम्बर 2021 तक",null,"जनवरी 2022",null,"फ़रवरी 2022",null,"टी.डी.एस.","कुल टैक्स कटौती (योग कॉलम 19)"]
[{"$nulls":3},{"$f":"SUM('GA 55A'!V7:V13)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55A'!V14:V16)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55A'!V17)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55A'!V18)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55A'!$V$19:$V$27)","v":{"v":0,"d":"0.00"}},{"$f":"SUM($D$63:$L$63)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(M61>M63,\"Income Tax Payable\",IF(M61<M63,\"Income Tax Refundable\",\"Income Tax No Need\"))","v":"Income Tax No Need"},{"$nulls":11},{"$f":"M61-M63","v":{"v":0,"d":"0.00"}}]
[]
["Signature Of Employee",{"$nulls":4},"Prepared By Ashwini Kumar : 9166023711 www.ashwinisharma.com",{"$nulls":5},"Signature Of DDO"]

{"sheet":"Tax Calculaton New","index":2,"n_rows":58,"n_cols":13,"rows_kept":58,"merged":[[0,0,0,12],[1,0,1,12],[2,1,2,2],[2,3,2,7],[2,9,2,10],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,0,9,0],[6,1,6,10],[6,12,8,12],[7,1,7,10],[8,1,8,10],[9,1,9,11],[10,1,10,11],[11,0,14,0],[11,1,11,6],[11,7,11,9],[11,10,11,11],[11,12,13,12],[12,1,13,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,11],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,11],[14,1,14,11],[15,1,15,11],[16,1,16,11],[17,1,17,11],[18,1,18,12],[19,1,19,11],[20,1,20,11],[21,1,21,11],[22,1,22,11],[23,1,23,11],[24,2,24,11],[25,2,25,11],[26,2,26,11],[27,2,27,11],[28,2,28,11],[29,2,29,11],[30,2,30,11],[31,2,31,11],[32,2,32,11],[33,1,33,11],[34,1,34,11],[35,1,35,11],[36,1,36,11],[37,1,37,11],[38,1,38,4],[38,5,38,8],[38,9,38,11],[39,1,39,3],[39,5,39,7],[39,9,39,10],[40,1,40,3],[40,5,40,7],[40,9,40,10],[41,1,41,3],[41,5,41,7],[41,9,41,10],[42,1,42,3],[42,5,42,7],[42,9,42,10],[43,1,43,3],[43,5,43,7],[43,9,43,10],[44,1,44,3],[44,5,44,7],[44,9,44,10],[45,1,45,3],[45,5,45,7],[45,9,45,10],[46,2,46,11],[47,2,47,11],[48,2,48,11],[49,2,49,11],[50,1,50,11],[51,1,51,11],[52,1,52,11],[53,0,54,0],[53,1,54,2],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[55,0,55,11],[57,0,57,3],[57,11,57,12]]}
[{"$f":"'Tax Calculaton Old'!A1","v":"Office of the Principal DIET Kuchaman City (Nagaur)"}]
["आयकर गणना प्रपत्र वर्ष 2021-22"]
[1,"नाम कर्मचारी",null,{"$f":"'Tax Calculaton Old'!D3","v":"Ashwini Kumar Sharma"},{"$nulls":4},"पद",{"$f":"'Tax Calculaton Old'!J3","v":"Lecturer"},null,"पैन नं.",{"$f":"'Tax Calculaton Old'!M3","v":"AAAA9456A"}]
[2,"आय वर्ष 2020-21 में प्राप्त कुल वेतन -",{"$nulls":10},{"$f":"'Tax Calculaton Old'!M4","v":{"v":648994,"d":"648994.00"}}]
[3,"गृह किराया, धारा 10 (13-A) के अंतर्गत एवं धारा 10 (14) के अंतर्गत अन्य भत्ते जो कर मुक्त है -",{"$nulls":10},{"$f":"'Tax Calculaton Old'!M5","v":{"v":0,"d":"0.00"}}]
[4,"शेष (2-3)",{"$nulls":10},{"$f":"M4-M5","v":{"v":648994,"d":"648994.00"}}]
[5,"(I)Standard Deduction Maxium 50000 धारा 16 (i a)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,"(II)मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत Maxium 5000",{"$nulls":9},{"$f":"'Tax Calculaton Old'!L8","v":{"v":0,"d":"0.00"}}]
[null,"(III)वयवसाय कर धारा 16 (iii) के अंतर्गत",{"$nulls":9},{"$f":"'Tax Calculaton Old'!L9","v":{"v":0,"d":"0.00"}}]
[null,"योग 5",{"$nulls":10},{"$f":"SUM(L7:L9)","v":{"v":0,"d":"0.00"}}]
[6,"शेष (4-5)",{"$nulls":10},{"$f":"M6-M10","v":{"v":648994,"d":"648994.00"}}]
[7,"(अ) गृह सम्पति से आय (1) स्वयं के उपयोग में शून्य",{"$nulls":5},"(2) प्राप्त किराया रूपये",null,null,{"v":0,"d":"0.00"}]
[null,"(ब) घटाइए",null,"किराये का 30%",null,"गृह ऋण पर ब्याज",null,"गृह कर",null,"योग 7 (ब)"]
[{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"$f":"SUM(D14:I14)","v":{"v":0,"d":"0.00"}}]
[null,"शेष - / + (7(अ) एवं 7 (ब) का)",{"$nulls":10},{"$f":"$K$12+$J$14","v":{"v":0,"d":"0.00"}}]
[8,"कुल शेष - / + (6 एवं 7)",{"$nulls":10},{"$f":"$M$11-$M$15","v":{"v":648994,"d":"648994.00"}}]
[9,"अन्य आय",{"$nulls":10},{"$f":"'Tax Calculaton Old'!M17","v":{"v":0,"d":"0.00"}}]
[10,"सकल आय (योग 8+9)",{"$nulls":10},{"$f":"SUM(M16:M17)","v":{"v":648994,"d":"648994.00"}}]
[11,"कटौतिया घटाइए - धारा US 80C, 80CCC, 80CCD(1)"]
[null,"(A) धारा  US 80C, 80CCC, 80CCD(1) अधिकतम कटौती की राशि",{"$nulls":10},{"v":0,"d":"0.00"}]
[null,"(B) धारा 80CCD(2) नियोक्ता द्वारा पेंशन अंशदान की राशि (अधिकतम वेतन का 10% पृथक से छूट)",{"$nulls":10},{"$f":"IF('GA 55A'!$Y$5=\"Yes\",'GA 55A'!L28,0)","v":{"v":55028,"d":"55028.00"}}]
[null,"(C) धारा 80CCD(1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रू. 50,000)",{"$nulls":10},{"$f":"'Tax Calculaton Old'!M33","v":{"v":0,"d":"0.00"}}]
[null,"योग 11 (A+B+C)",{"$nulls":10},{"$f":"SUM(M20:M22)","v":{"v":55028,"d":"55028.00"}}]
[12,"अन्य कटौतिया"]
[null,1,"धारा 80 D, चिकित्सा बीमा प्रीमियम (स्वयं,पति/पत्नी व बच्चों के लिए रू 25000, माता-पिता के लिए रू 25000,सीनियर सिटीजन रू 50000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,2,"धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80ः या अधिक विकलांगता 125,000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,3,"धारा 80 DB विशिष्ट रोंगों के उपचार हेतु कटौती (अधिकतम रू 40,000, सीनियर सिटीजन हेतु रू 100,000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,4,"धारा 80 E उच्च शिक्षा हेतु लिए ऋण का ब्याज",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,5,"धारा 80 G धर्मार्थ संस्थाओं आदि को दिये दान ( क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,6,"धारा 80 U स्थाई रूप से शारीरिक असमर्थतता की दशा में (अधिकतम 75,000 तथा  अधिनियम 1995के अनुसार 125,000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,7,"धारा 80 TTA बचत खाते पर ब्याज की अधिकतम छूट रू. 10,000  U/S 194(IA)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,8,"धारा 80 TTB वरिष्ठ नागरिकों को सभी प्रकार के ब्याज पर अधिकतम छूट-  50000 रू.  U/S 194(A)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,9,"धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,"योग 12 (1 to 9)",{"$nulls":10},{"$f":"SUM(M25:M33)","v":{"v":0,"d":"0.00"}}]
[13,"कुल कटौती (11+12)",{"$nulls":10},{"$f":"SUM($M$23+$M$34)","v":{"v":55028,"d":"55028.00"}}]
[14,"कर योग्य आय (10-13)",{"$nulls":10},{"$f":"$M$18-$M$35","v":{"v":593966,"d":"593966.00"}}]
[15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288 A ",{"$nulls":10},{"$f":"ROUND($M$36,-1)","v":{"v":593970,"d":"593970.00"}}]
[16,"आयकर की गणना"]
[null,"एक व्यक्ति कर दाता ",{"$nulls":3},"वरिष्ठ नागरिक (60 से 80 वर्ष)",{"$nulls":3},"80 वर्ष या अधिक आयु"]
[null,"250000 तक",null,null,"NIL","300000 तक",null,null,"NIL",null,null,"NIL",{"v":0,"d":"0.00"}]
[null,"250001 से 500000 तक",null,null,{"v":0.05,"d":"5%"},"300001 से 500000 तक",null,null,{"v":0.05,"d":"5%"},"50000 तक",null,{"v":0.05,"d":"5%"},{"$f":"ROUND(IF(M37<250001,0,IF(M37>500000,12500,((M37-250000)*0.05))),0)","v":{"v":12500,"d":"12500.00"}}]
[null,"500001 से 750000 तक",null,null,{"v":0.1,"d":"10%"},"500001 से 750000 तक",null,null,{"v":0.1,"d":"10%"},"500001 से 1000000 तक",null,{"v":0.1,"d":"10%"},{"$f":"ROUND(IF(M37<500001,0,IF(M37>750000,25000,((M37-500000)*0.1))),0)","v":{"v":9397,"d":"9397.00"}}]
[null,"750001 से 1000000 तक",null,null,{"v":0.15,"d":"15%"},"750001 से 1000000 तक",null,null,{"v":0.15,"d":"15%"},"1000001 से अधिक",null,{"v":0.15,"d":"15%"},{"$f":"ROUND(IF(M37<750001,0,IF(M37>1000000,37500,((M37-750000)*0.15))),0)","v":{"v":0,"d":"0.00"}}]
[null,"1000001 से 1250000 तक",null,null,{"v":0.2,"d":"20%"},"1000001 से 1250000 तक",null,null,{"v":0.2,"d":"20%"},"1000001 से अधिक",null,{"v":0.2,"d":"20%"},{"$f":"ROUND(IF(M37<1000001,0,IF(M37>1250000,50000,((M37-1000000)*0.2))),0)","v":{"v":0,"d":"0.00"}}]
[null,"1250000 से 1500000 तक",null,null,{"v":0.25,"d":"25%"},"1250000 से 1500000 तक",null,null,{"v":0.25,"d":"25%"},"1000001 से अधिक",null,{"v":0.25,"d":"25%"},{"$f":"ROUND(IF(M37<1250001,0,IF(M37>1500000,62500,((M37-1250000)*0.25))),0)","v":{"v":0,"d":"0.00"}}]
[null,"1500000  से अधिक",null,null,{"v":0.3,"d":"30%"},"1500000  से अधिक",null,null,{"v":0.3,"d":"30%"},"1500000  से अधिक",null,{"v":0.3,"d":"30%"},{"$f":"ROUND(IF(M37<1500001,0,(M37-1500000)*0.3),0)","v":{"v":0,"d":"0.00"}}]
[null,1,"योग आयकर",{"$nulls":9},{"$f":"SUM(M40:M46)","v":{"v":21897,"d":"21897.00"}}]
[null,2,"छूट घारा 87(A) (2.50 लाख से 5 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रू. 12500 तक)",{"$nulls":9},{"$f":"IF(M37>500000,0,IF(M47<12501,M47,12500))","v":{"v":0,"d":"0.00"}}]
[null,3,"शेष आयकर (1-2)",{"$nulls":9},{"$f":"M47-M48","v":{"v":21897,"d":"21897.00"}}]
[null,4,"शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2%  (योग 4%)",{"$nulls":9},{"$f":"ROUND(M49*0.04,0)","v":{"v":876,"d":"876.00"}}]
[null,"कुल आयकर (3+4)",{"$nulls":10},{"$f":"SUM(M49:M50)","v":{"v":22773,"d":"22773.00"}}]
[17,"घटाइये :- राहत धारा 89 के तहत",{"$nulls":10},{"$f":"'Tax Calculaton Old'!M60","v":{"v":0,"d":"0.00"}}]
[18,"कुल शेष आयकर",{"$nulls":10},{"$f":"M51-M52","v":{"v":22773,"d":"22773.00"}}]
[19,"आयकर कटौती का विवरण",null,"सितम्बर   2021 तक",null,"अक्टूबर से दिसम्बर 2021 तक",null,"जनवरी 2022",null,"फ़रवरी 2022",null,"टी.डी.एस.","कुल टैक्स कटौती (योग कॉलम 19)"]
[{"$nulls":3},{"$f":"SUM('GA 55A'!V7:V13)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55A'!V14:V16)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55A'!V17)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55A'!V18)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55A'!$V$19:$V$27)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D55:L55)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(M53>M55,\"Income Tax Payable\",IF(M53<M55,\"Income Tax Refundable\",\"Income Tax No Need\"))","v":"Income Tax Payable"},{"$nulls":11},{"$f":"M53-M55","v":{"v":22773,"d":"22773.00"}}]
[]
["Signature Of Employee",{"$nulls":10},"Signature Of DDO"]

{"sheet":"Summary","index":3,"n_rows":11,"n_cols":9,"rows_kept":11,"merged":[[0,0,0,4],[2,1,2,4],[7,0,7,1],[7,2,7,4],[8,0,8,1],[8,2,8,4],[9,0,9,1],[9,2,9,4],[10,0,10,1],[10,2,10,4]]}
[{"$f":"'GA 55A'!A1","v":"Office of the Principal DIET Kuchaman City (Nagaur)"}]
[]
["Name Of Employee",{"$f":"'GA 55A'!B4","v":"Ashwini Kumar Sharma"}]
[]
["Gross Pay","Taxable Amt","Tax Deposit","Rebate Under Section 80C, 80CCC, 80CCD(1)","मकान किराया छूट के लिए रसीद की आवश्यकता"]
[{"$f":"'Tax Calculaton Old'!$M$4","v":{"v":648994,"d":"648994.00"}},{"$f":"'Tax Calculaton Old'!M48","v":{"v":420760,"d":"420760.00"}},{"$f":"'Tax Calculaton Old'!M63","v":{"v":0,"d":"0.00"}},{"$f":"'Tax Calculaton Old'!M31","v":{"v":120564,"d":"120564.00"}},{"$f":"IF(I6=0,0,ROUND(0.1*H6,0)+I6)","v":{"v":90395,"d":"90395.00"}},null,null,{"$f":"SUM('GA 55A'!B7:C18)","v":{"v":534826,"d":"534,826"}},{"$f":"'GA 55A'!D28","v":{"v":36912,"d":"36,912"}}]
[]
["TAX Position (Old Tax Scheme)",null,{"$f":"'Tax Calculaton Old'!A64&\" = \"&'Tax Calculaton Old'!M64","v":"Income Tax No Need = 0"}]
["TAX Position (New Tax Scheme)",null,{"$f":"'Tax Calculaton New'!A56&\" = \"&'Tax Calculaton New'!M56","v":"Income Tax Payable = 22773"}]
["Total Rebate Under Section 80C, 80CCC, 80CCD(1)",null,{"$f":"'Tax Calculaton Old'!M31","v":{"v":120564,"d":"120564.00"}}]
["Investable Amount",null,{"$f":"150000-C10","v":{"v":29436,"d":"29436.00"}}]