{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["For Help","Basic Deta","Exemp.(HRA+Other) & Other incom","Table (Income-Deduction)","Income Tax Cal. Report","Form-16","OLD REGIME","NEW REGIME","10 E Us 89(1) ","HRA Receipt"],"not_rendered":{"images":2,"external_links":1,"defined_names":7,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"For Help","index":0,"n_rows":8,"n_cols":7,"rows_kept":8,"merged":[[0,0,0,7],[1,0,8,0],[1,2,8,2],[1,3,2,3],[1,4,8,5],[1,6,4,6],[1,7,8,7]]}
["For other States(NPS Deduction) Updated On 19-02-2023"]
[null,"←:: सहायतार्थ बिंदु ::→",null,"आयकर गणना प्रपत्र देखें"]
[null,"1- सबसे पहले Basic Data शीट में सफ़ेद सेल्स में कार्मिक से जुड़े विद्यालय,स्वयं कार्मिक तथा वेतन सम्बंधित विवरण फिल करें. यहाँ भत्ते तथा कटौतियों के विषय आप अपनी सुविधानुसार बदल सकते हो."]
[null,"2- Basic Data भरने के पश्चात Exemp.(HRA+Other) & Other income वाली शीट में HRA अतिरिक्त आय, कटौतियां आदि भरें. (हालाँकि नियमानुसार HRA की गणना स्वतः की हुई मिलेगी फिर भी आपसे जुड़े DDO के निर्देशानुसार इसे बदल भी सकते है.)"]
[null,"3- Basic Data एंट्री के साथ ही आपको GA-55 तैयार मिलेगा जो कि पूर्णत: अनलॉक है आप Pay Man./Pri Pay Man. से निकाले ऑनलाइन GA-55 रिपोर्ट से भली भांति मिलान कर आवश्यकतानुसार बदलाव भी कर सकते हैं.",null,"Form-16 देखें"]
[null,"5- यदि गत वर्षों के बकाया वेतन का इस वर्ष आयकर की कटौती के साथ भुगतान किया गया है, तो आप आवश्यक फॉर्म-10E भी 10 E Us 89(1) शीट में तैयार कर धारा 89(1) के तहत प्राप्य छूट को आयकर गणना प्रपत्र, फॉर्म-16 में अंकित कर सकते हो.",{"$nulls":4},"Ummed Tarad"]
[null,"4- उक्त कार्य पूर्ण करने के बाद आपके सामने कार्मिक से जुडी पुरानी तथा नई कर व्यवस्था (Old Tax Regime/New Tax Regime)  के अनुसार आयकर गणना प्रपत्र, फॉर्म-16, HRA से जुडी आवश्यक रिसिप्ट तैयार है, प्रिंट ले सकते हैं.",null,"HRA  Receipt देखें",null,null,"Teacher (GSSS Raimalwada, Jodhpur)"]
[null,"नोट :- हालाँकि इस प्रोग्राम को बनाते समय पूर्ण सावधानी के साथ तैयार किया गया है. मानवीय भूल सहज है. यदि किसी भी प्रकार की कोई समस्या, शंका तथा आपत्ति की स्थिति में आप अपने विवेक को प्रमुखता दें. ",{"$nulls":4},"Mob.-9166973141      Email Id-ummedtrdedu@gmail.com"]

{"sheet":"Basic Deta","index":1,"n_rows":19,"n_cols":15,"rows_kept":19,"merged":[[0,0,19,0],[0,1,0,14],[0,15,19,15],[1,1,1,14],[2,1,2,14],[3,1,3,14],[4,1,4,3],[4,4,4,9],[4,10,4,11],[4,12,4,13],[5,1,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[6,1,6,13],[7,1,7,14],[8,1,8,2],[8,3,8,4],[8,6,8,8],[8,12,8,13],[9,1,9,2],[9,3,9,4],[9,6,9,8],[9,12,9,13],[10,1,10,13],[11,1,13,1],[11,2,11,8],[11,9,11,14],[12,5,12,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,14,13,14],[15,1,15,14],[16,1,16,14],[17,13,17,14],[18,13,18,14],[19,1,19,13]]}
[null,"PREPARED BY :- UMMED TARAD (TEACHER, GSSS RAIMALWADA-BAPINI, JODHPUR)"]
[null,"Mobile Number-9166973141, Email ID-ummedtrdedu@gmail.com"]
[null,"Deta Entry For School and Employee"]
[null,"School Details"]
[null,"DPO (Estt.)Office :-",null,null,"District Education Officer, Education Department Primary Education of Bihar",{"$nulls":5},"DPO Name :-",null,"SHARIQUE ASHRAF",null,"F.Y."]
[null,"Treasury :-",null,null,"BUXAR",null,"TAN No. :-",{"$nulls":3},"DPO Father's Name :-",{"$nulls":3},"2022-23"]
[]
[null,"Employee Personal & Salary Details"]
[null,"Employee Name",null,"Employee ID",null,"Designation","Posting Place Name",null,null,"Basic Pay (March-22)","Basic Pay (Jan-23)","PAN No.","Account Number",null,"Employee Age (Less 60=A, Between 60&80=B, Above 80=C)"]
[null,"SHAHID ALI",null,123,null,"Block Teacher","M.S. BASUDHAR",null,null,{"v":28660,"d":"₹ 28,660"},{"$f":"ROUNDUP(J10*1.03,-1)+10","v":{"v":29530,"d":"₹ 29,530"}},"BFHPA0762G",742781203,null,"A"]
[]
[null,"Employee Status (Regular/ Probation)","Extra Paid Status",{"$nulls":6},"Deducted Amount"]
[null,null,"Bonus Amount","DA ","DA ","Surrender",null,"Medical All.","Extra","EPF/Montholy Invest in Future Plan ","GIS/Group Ins.","Contri. To Contributory Pension Scheme (80CCC)","LIC","GROUP L.I.C.","गृ.नि.अ. की किस्तों की वसूली/पेशाकर"]
[{"$nulls":3},"Jan-22 to Mar-22","Jul-22 to Sep-22","Claimed (Yes/No)","Month"]
[null,"Regular",{"v":0,"d":"₹ 0"},"YES","YES","NO","2022-12-01",{"v":1000,"d":"₹ 1,000"},{"v":0,"d":"₹ 0"},{"v":1800,"d":"₹ 1,800"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":1000,"d":"₹ 1,000"}]
[]
[null,"Income Tax Deduction"]
[null,"2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","Extra TDS Deposited (Via Challan etc)"]
[null,{"v":0,"d":"₹ 0"},{"$f":"B19","v":{"v":0,"d":"₹ 0"}},{"$f":"C19","v":{"v":0,"d":"₹ 0"}},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"}]

{"sheet":"Exemp.(HRA+Other) & Other incom","index":2,"n_rows":26,"n_cols":16384,"rows_kept":26,"merged":[[0,0,0,16],[0,17,26,17],[1,0,1,16],[2,0,2,1],[3,0,3,1],[4,0,4,12],[4,13,4,16],[5,1,5,10],[5,11,5,12],[6,1,6,10],[6,11,6,12],[7,1,7,10],[7,11,7,12],[8,2,8,10],[8,11,8,12],[9,2,9,10],[9,11,9,12],[10,0,10,16],[11,1,11,10],[11,11,11,12],[11,14,11,15],[12,1,12,10],[12,11,12,12],[12,14,12,15],[13,1,13,10],[13,11,13,12],[13,14,13,15],[14,1,14,10],[14,11,14,12],[14,14,14,15],[15,1,15,10],[15,11,15,12],[15,14,15,15],[16,1,16,10],[16,11,16,12],[16,14,16,15],[17,1,17,10],[17,11,17,12],[17,14,17,15],[18,1,18,10],[18,11,18,12],[18,14,18,15],[19,1,19,10],[19,11,19,12],[19,14,19,15],[20,1,20,10],[20,11,20,12],[20,14,20,15],[21,1,21,10],[21,11,21,12],[21,14,21,15],[22,1,22,10],[22,11,22,12],[22,14,22,15],[23,1,23,10],[23,11,23,12],[23,14,23,15],[24,1,24,10],[24,11,24,12],[24,14,24,15],[25,1,25,10],[25,11,25,12],[25,14,25,15],[26,0,26,16]]}
[{"$f":"'Table (Income-Deduction)'!B1","v":"District Education Officer, Education Department Primary Education of Bihar"}]
["HRA CALCULATION"]
["Employee Name",null,"Post","Posted Place","Basic","DA","Total",{"v":0.1,"d":"10%"},"PAID HRA",null,"HRA Rebate (Rs.)","Yearly HRA Recipt (Rs.)","Per Month HRA Reciept","Quartly Amount For HRA Reciept","House Owner Name","House Owner Adress","House Owner PAN Number"]
[{"$f":"'Basic Deta'!B10","v":"SHAHID ALI"},null,{"$f":"'Basic Deta'!F10","v":"Block Teacher"},{"$f":"'Basic Deta'!G10","v":"M.S. BASUDHAR"},{"$f":"SUM('Table (Income-Deduction)'!F10:F21,'Table (Income-Deduction)'!F29,'Table (Income-Deduction)'!F30)","v":345660},{"$f":"SUM('Table (Income-Deduction)'!G24,'Table (Income-Deduction)'!G23,'Table (Income-Deduction)'!G10:G21,'Table (Income-Deduction)'!G29:G30)","v":128482},{"$f":"E4+F4","v":474142},{"$f":"ROUNDUP((G4*0.1),0)","v":47415},{"$f":"SUM('Table (Income-Deduction)'!H10:H21,'Table (Income-Deduction)'!H29:H30)","v":13822},{"$f":"ROUNDUP((I4+H4),-1)","v":61240},{"$f":"IF(T4>I4,I4,T4)","v":13822},{"$f":"ROUNDUP((M4*12),-1)","v":61320},{"$f":"IF(H4>100000,0,ROUNDUP(J4/12,-1))","v":5110},{"$f":"ROUNDUP((M4*3),-1)","v":15330},{"$nulls":5},{"$f":"IF(AND(M4=0,H4>100000),0,IF(AND(M4>0,L4>H4),(L4-H4),0))","v":13905}]
["Extra income",{"$nulls":12},"Deposit income tax other than salary"]
["Sr. No.","Area of Income",{"$nulls":9},"Amount",null,"Date","Challan Number","BSR Code","Amount"]
[1,"गृह सम्पति से प्राप्त किराया-आय",{"$nulls":9},0,{"$nulls":4},0]
[2,"अन्य आय (बैंक/एफडी में जमा ब्याज/अन्य ब्याज आदि का योग",{"$nulls":9},0,{"$nulls":4},0,{"$nulls":16366},{"$f":"IF(L8>50000,\"B\",\"A\")","v":"A"}]
[3,"अन्य आय","(-----------------------------------------------------)",{"$nulls":8},0,{"$nulls":4},0,{"$nulls":16366},{"$f":"'Basic Deta'!O10","v":"A"}]
[4,"अन्य आय","(-----------------------------------------------------)",{"$nulls":8},0,{"$nulls":4},0,{"$nulls":16366},{"$f":"CONCATENATE(XFD8,XFD9)","v":"AA"}]
["Extra exemptions"]
["Sr. No.","Area of Exemption",{"$nulls":9},"Amout",null,"Sr. No.","Area of Exemption",null,"Amount"]
[1,"मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत अधिकतम 5000 रूपये",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,15,"बचत खाते की जमा राशी पर प्राप्त ब्याज में छूट (80 TTA-10000 अधिकतम)",null,{"v":0,"d":"₹ 0.00"}]
[2,"व्यवसाय/पेशाकर धारा 16 (ii) के अंतर्गत अधिकतम 5000 रूपये",{"$nulls":9},{"$f":"'Table (Income-Deduction)'!U32","v":{"v":1000,"d":"₹ 1,000.00"}},null,16,"बचत खाते की जमा राशी पर प्राप्त ब्याज में छूट (TTB-अधिकतम 50000)",null,{"v":0,"d":"₹ 0.00"}]
[3,"गृहकर",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,17,"धारा 80CCC - पेंशन प्लान हेतु अंशदान (NPS के अतिरिक्त)",null,{"$f":"'Table (Income-Deduction)'!R32","v":{"v":0,"d":"₹ 0.00"}}]
[4,"गृह ऋण किश्त मूल (जो वेतन से नहीं काटा गया)",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,18,"धारा 80CCD(1B) -नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम 50,000 अधिकतम)",null,{"v":0,"d":"₹ 0.00"}]
[5,"गृह ऋण किश्त ब्याज (जो वेतन से नहीं काटा गया)",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,19,"धारा 80D - चिकित्सा बीमा प्रीमियम (सामान्य 25,000, वरिष्ठ नागरिक 50,000)",null,{"v":0,"d":"₹ 0.00"}]
[6,"जीवन बिमा प्रीमियम (जो वेतन से नहीं काटा गया) LIC",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,20,"धारा 80DD - विकलांग आश्रितों का चिकित्सा उपचार (अधिकतम 75,000,  80%विक्लांगता 1,25,000)",null,{"v":0,"d":"₹ 0.00"}]
[7,"पी.एल.आई. PLI",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,21,"धारा 80DDB -विशिष्ठ रोगों के उपचार हेतु कटौती (सामान्य 40,000 एवं वरिष्ठ नागरिक 1 लाख)",null,{"v":0,"d":"₹ 0.00"}]
[8,"ट्यूशन फी",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,22,"धारा 80E - उच्च शिक्षा हेतु लिए ऋण पर ब्याज (धारा 80E)",null,{"v":0,"d":"₹ 0.00"}]
[9,"UPLI/वार्षिक प्लान",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,23,"धारा 80G -धर्मार्थ संस्थाओं को दिए दान (श्रेणी 'क' 100% एवं श्रेणी 'ख' 50%) ",null,{"v":0,"d":"₹ 0.00"}]
[10,"राष्ट्रीय बचत पत्र (NSC)",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,24,"धारा 80U -स्थाई शारीरिक विक्लांगता  (अधिकतम 75,000,  80%विक्लांगता 1,25,000)",null,{"v":0,"d":"₹ 0.00"}]
[11,"राष्ट्रीय बचत पत्र पर अदत ब्याज",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,25,"धारा 80 GGA -अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास आदि हेतु दिया गया दान",null,{"v":0,"d":"₹ 0.00"}]
[12,"लोक भविष्य निधि (PPF)",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,26,"इक्विटी लिंक सेविंग स्कीम/Mutual Fund",null,{"v":0,"d":"₹ 0.00"}]
[13,"राष्ट्रीय बचत स्कीम (NSS)",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,27,"स्थिगित वार्षिकी",null,{"v":0,"d":"₹ 0.00"}]
[14,"सुकन्या समृद्धि योजना",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,28,"धारा 89 के अंतर्गत राहत",null,{"$f":"'10 E Us 89(1) '!AR26","v":{"v":0,"d":"₹ 0.00"}}]

{"sheet":"Table (Income-Deduction)","index":3,"n_rows":33,"n_cols":37,"rows_kept":33,"merged":[[0,1,0,28],[0,29,32,29],[1,1,1,28],[2,2,2,19],[2,20,2,25],[2,26,2,28],[3,1,3,4],[3,5,3,8],[3,9,3,14],[3,15,3,17],[3,19,3,23],[3,24,3,28],[4,1,4,28],[5,1,5,4],[5,5,5,8],[5,9,5,14],[5,15,5,17],[5,19,5,24],[5,25,5,28],[6,1,6,28],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,7,14],[7,15,7,26],[7,27,8,27],[7,28,8,28],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,4],[32,1,32,14],[32,15,32,28]]}
[null,{"$f":"'Basic Deta'!E5","v":"District Education Officer, Education Department Primary Education of Bihar"}]
[null,{"$f":"IF('Basic Deta'!D10=0,0,CONCATENATE('Basic Deta'!G9,\"\",\":\",\"-\",\" \",'Basic Deta'!G10))","v":"Posting Place Name:- M.S. BASUDHAR"}]
[null,null," Employee Income and Deduction Details (For Itax Calculation)",{"$nulls":17},"Financial Year :-",{"$nulls":5},{"$f":"'Basic Deta'!O6","v":"2022-23"}]
[null,"Employee Name :-",{"$nulls":3},{"$f":"'Basic Deta'!B10","v":"SHAHID ALI"},{"$nulls":3},"Designation :-",{"$nulls":5},{"$f":"'Basic Deta'!F10","v":"Block Teacher"},{"$nulls":3},{"$f":"IF('Basic Deta'!D10>0,\"Employee ID :-\",\"Posting Place:-\")","v":"Employee ID :-"},{"$nulls":4},{"$f":"IF('Basic Deta'!D10>0,'Basic Deta'!D10,'Basic Deta'!G10)","v":123}]
[]
[null,"PAN No. (Treasury) :-",{"$nulls":3},{"$f":"CONCATENATE('Basic Deta'!L10,\" \",\"(\",'Basic Deta'!E6,\")\")","v":"BFHPA0762G (BUXAR)"},{"$nulls":13},"Account Number :-",{"$nulls":5},{"$f":"'Basic Deta'!M10","v":742781203}]
[]
[null,"Sr. No.","Month","TV Number","TV Date","Allowance",{"$nulls":9},"Deductions",{"$nulls":11},"Net Payment","Income Tax"]
[{"$nulls":5},"Basic","DA","HRA","DP",{"$f":"'Basic Deta'!H13","v":"Medical All."},{"$f":"'Basic Deta'!I13","v":"Extra"},"Other-2","Other-1","Other-3","Groce Amount",{"$f":"'Basic Deta'!J13","v":"EPF/Montholy Invest in Future Plan "},{"$f":"'Basic Deta'!K13","v":"GIS/Group Ins."},{"$f":"'Basic Deta'!L13","v":"Contri. To Contributory Pension Scheme (80CCC)"},{"$f":"'Basic Deta'!M13","v":"LIC"},{"$f":"'Basic Deta'!N13","v":"GROUP L.I.C."},{"$f":"'Basic Deta'!O13","v":"गृ.नि.अ. की किस्तों की वसूली/पेशाकर"},"Other-1","Other-2","Other-3","Other-4","Other-5","Total Deductions"]
[null,1,"2022-03-01",null,null,{"$f":"'Basic Deta'!J10","v":28660},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F10*31/100,0),0)","v":8885},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F10*0.04,0))","v":1146},null,{"$f":"'Basic Deta'!H15","v":1000},{"$f":"'Basic Deta'!I15","v":0},{"$nulls":3},{"$f":"SUM(F10:N10)","v":39691},{"$f":"'Basic Deta'!J15","v":1800},{"$f":"'Basic Deta'!K15","v":0},{"$f":"'Basic Deta'!L15","v":0},{"$f":"'Basic Deta'!M15","v":0},{"$f":"'Basic Deta'!N15","v":0},0,{"$f":"'Basic Deta'!L15","v":0},{"$f":"'Basic Deta'!K15","v":0},{"$nulls":3},{"$f":"SUM(P10:Z10)","v":1800},{"$f":"O10-AA10","v":37891},{"$f":"'Basic Deta'!B19","v":0},null,null,{"$f":"IF(C10='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AF10=\"Yes\",ROUND(F10/2,0),0)","v":0},{"$f":"IF(AF10=\"Yes\",ROUND(G10/2,0),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(AF10=\"Yes\",(F10+G10)/2,0)","v":0},{"$f":"IF(AF10=\"yes\",(AI10+(F10*0.03/2)),0)","v":0},{"$f":"IF($AF10=\"Yes\",ROUND(AH10*0.03,0),0)","v":{"v":0,"d":"0.00"}}]
[null,2,"2022-04-01",null,null,{"$f":"F10","v":28660},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F11*34/100,0),0)","v":9744},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F11*0.04,0))","v":1146},{"$f":"I10","v":0},{"$f":"J10","v":1000},{"$f":"K10","v":0},null,null,{"$f":"N10","v":0},{"$f":"SUM(F11:N11)","v":40550},{"$f":"P10","v":1800},{"$f":"Q10","v":0},{"$f":"R10","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(P11:Z11)","v":1800},{"$f":"O11-AA11","v":38750},{"$f":"'Basic Deta'!C19","v":0},null,null,{"$f":"IF(C11='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,3,"2022-05-01",null,null,{"$f":"F11","v":28660},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F12*34/100,0),0)","v":9744},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F12*0.04,0))","v":1146},{"$f":"I11","v":0},1000,0,null,{"$f":"M11","v":0},{"$f":"N11","v":0},{"$f":"SUM(F12:N12)","v":40550},{"$f":"P11","v":1800},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P12:Z12)","v":1800},{"$f":"O12-AA12","v":38750},{"$f":"'Basic Deta'!D19","v":0},null,null,{"$f":"IF(C12='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,4,"2022-06-01",null,null,28660,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F13*34/100,0),0)","v":9744},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F13*0.04,0))","v":1146},0,1000,0,null,0,0,{"$f":"SUM(F13:N13)","v":40550},1800,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P13:Z13)","v":1800},{"$f":"O13-AA13","v":38750},{"$f":"'Basic Deta'!E19","v":0},null,null,{"$f":"IF(C13='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,5,"2022-07-01",null,null,28660,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F14*34/100,0),0)","v":9744},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F14*0.04,0))","v":1146},0,1000,0,null,0,0,{"$f":"SUM(F14:N14)","v":40550},1800,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P14:Z14)","v":1800},{"$f":"O14-AA14","v":38750},{"$f":"'Basic Deta'!F19","v":0},null,null,{"$f":"IF(C14='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0,{"$f":"IF(AF14=\"yes\",(F14*0.04/2),0)","v":0},{"$f":"IF($AF14=\"Yes\",ROUND(AH14*0.04,0),0)","v":{"v":0,"d":"0.00"}}]
[null,6,"2022-08-01",null,null,28660,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F15*34/100,0),0)","v":9744},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F15*0.04,0))","v":1146},0,{"$f":"J14","v":1000},0,null,0,0,{"$f":"SUM(F15:N15)","v":40550},1800,0,0,0,0,0,0,{"$f":"W14","v":0},0,0,0,{"$f":"SUM(P15:Z15)","v":1800},{"$f":"O15-AA15","v":38750},{"$f":"'Basic Deta'!G19","v":0},null,null,{"$f":"IF(C15='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0,{"$f":"IF(AF15=\"yes\",(F15*0.04/2),0)","v":0},{"$f":"IF($AF15=\"Yes\",ROUND(AH15*0.04,0),0)","v":{"v":0,"d":"0.00"}}]
[null,7,"2022-09-01",null,null,28660,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F16*34/100,0),0)","v":9744},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F16*0.04,0))","v":1146},0,1000,0,null,0,0,{"$f":"SUM(F16:N16)","v":40550},1800,0,0,0,0,{"$f":"'Basic Deta'!O15","v":1000},0,0,0,0,0,{"$f":"SUM(P16:Z16)","v":2800},{"$f":"O16-AA16","v":37750},{"$f":"'Basic Deta'!H19","v":0},null,null,{"$f":"IF(C16='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0,{"$f":"IF(AF16=\"yes\",(F16*0.04/2),0)","v":0},{"$f":"IF($AF16=\"Yes\",ROUND(AH16*0.04,0),0)","v":{"v":0,"d":"0.00"}}]
[null,8,"2022-10-01",null,null,28660,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F17*38/100,0),0)","v":10891},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F17*0.04,0))","v":1146},0,1000,0,null,0,0,{"$f":"SUM(F17:N17)","v":41697},1800,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P17:Z17)","v":1800},{"$f":"O17-AA17","v":39897},{"$f":"'Basic Deta'!I19","v":0},null,null,{"$f":"IF(C17='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,9,"2022-11-01",null,null,28660,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F18*38/100,0),0)","v":10891},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F18*0.04,0))","v":1146},0,1000,0,null,0,0,{"$f":"SUM(F18:N18)","v":41697},1800,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P18:Z18)","v":1800},{"$f":"O18-AA18","v":39897},{"$f":"'Basic Deta'!J19","v":0},null,null,{"$f":"IF(C18='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,10,"2022-12-01",null,null,28660,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F19*38/100,0),0)","v":10891},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F19*0.04,0))","v":1146},0,1000,0,null,0,0,{"$f":"SUM(F19:N19)","v":41697},1800,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P19:Z19)","v":1800},{"$f":"O19-AA19","v":39897},{"$f":"'Basic Deta'!K19","v":0},null,null,{"$f":"IF(C19='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"Yes"},14330,{"v":5446,"d":"5446.00"},{"v":19775.5,"d":"19776"}]
[null,11,"2023-01-01",null,null,{"$f":"'Basic Deta'!K10","v":29530},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F20*38/100,0),0)","v":11221},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F20*0.04,0))","v":1181},0,1000,0,null,0,0,{"$f":"SUM(F20:N20)","v":42932},1800,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P20:Z20)","v":1800},{"$f":"O20-AA20","v":41132},{"$f":"'Basic Deta'!L19","v":0},null,null,{"$f":"IF(C20='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,12,"2023-02-01",null,null,{"$f":"F20","v":29530},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F21*38/100,0),0)","v":11221},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",ROUND('Table (Income-Deduction)'!F21*0.04,0))","v":1181},0,1000,0,null,0,0,{"$f":"SUM(F21:N21)","v":42932},1800,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P21:Z21)","v":1800},{"$f":"O21-AA21","v":41132},{"$f":"'Basic Deta'!M19","v":0},null,null,{"$f":"IF(C21='Basic Deta'!$G$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,"Bonus",{"$nulls":11},{"$f":"IF('Basic Deta'!J10>=13,0,'Basic Deta'!C15)","v":0},{"$f":"SUM(F22:N22)","v":0},{"$f":"ROUND(O22*25/100,0)","v":0},{"$nulls":10},{"$f":"SUM(P22:Z22)","v":0},{"$f":"O22-AA22","v":0},0,{"$nulls":3},{"$f":"SUM(AG10:AG21)","v":14330},{"$f":"SUM(AH10:AH21)","v":5446},{"v":19775.5,"d":"19776"},0,{"$f":"SUM(AK10:AK21)","v":{"v":0,"d":"0.00"}}]
[null,"DA (Jan-22 to Mar-22)",{"$nulls":4},{"$f":"IF('Basic Deta'!D15=\"yes\",ROUND((G11-G10)*3,0),0)","v":2577},{"$nulls":7},{"$f":"SUM(F23:N23)","v":2577},0,{"$nulls":10},{"$f":"SUM(P23:Z23)","v":0},{"$f":"O23-AA23","v":2577},0]
[null,"DA (Jul-22 to  Sep-22)",{"$nulls":4},{"$f":"IF('Basic Deta'!E15=\"yes\",ROUND((G17-G16)*3,0),0)","v":3441},{"$nulls":7},{"$f":"SUM(F24:N24)","v":3441},0,{"$nulls":10},{"$f":"SUM(P24:Z24)","v":0},{"$f":"O24-AA24","v":3441},0]
[null,"Surrender",{"$nulls":3},{"$f":"IF('Basic Deta'!F15=\"Yes\",AG22,0)","v":0},{"$f":"IF('Basic Deta'!F15=\"Yes\",AH22,0)","v":0},{"$nulls":7},{"$f":"SUM(F25:N25)","v":0},{"$nulls":11},{"$f":"SUM(P25:Z25)","v":0},{"$f":"O25-AA25","v":0},0]
[null,"Surrender Arrear",{"$nulls":4},{"$f":"IF('Basic Deta'!F15=\"Yes\",AK22,0)","v":0},{"$nulls":7},{"$f":"SUM(F26:N26)","v":0},{"$f":"G26","v":0},{"$nulls":10},{"$f":"SUM(P26:Z26)","v":0},{"$f":"O26-AA26","v":0},0]
[null,"Other-2",{"$nulls":12},{"$f":"SUM(F27:N27)","v":0},{"$nulls":11},{"$f":"SUM(P27:Z27)","v":0},{"$f":"O27-AA27","v":0},0]
[null,"Surr. Arear",{"$nulls":4},{"$f":"IF('Basic Deta'!G15=\"Yes\",AJ22,0)","v":0},{"$nulls":7},{"$f":"SUM(F28:N28)","v":0},{"$f":"O28","v":0},{"$nulls":10},{"$f":"SUM(P28:Z28)","v":0},{"$f":"O28-AA28","v":0},0]
[null,"Sal. Arrear-1",{"$nulls":12},{"$f":"SUM(F29:N29)","v":0},{"$nulls":11},{"$f":"SUM(P29:Z29)","v":0},{"$f":"O29-AA29","v":0},0]
[null,"Sal. Arrear-2",{"$nulls":12},{"$f":"SUM(F30:N30)","v":0},{"$nulls":11},{"$f":"SUM(P30:Z30)","v":0},{"$f":"O30-AA30","v":0},0]
[null,"Sal. Arrear-3",{"$nulls":12},{"$f":"SUM(F31:N31)","v":0},{"$nulls":11},{"$f":"SUM(P31:Z31)","v":0},{"$f":"O31-AA31","v":0},0]
[null,"Total",{"$nulls":3},{"$f":"SUM(F10:F31)","v":345660},{"$f":"SUM(G10:G31)","v":128482},{"$f":"SUM(H10:H31)","v":13822},{"$f":"SUM(I10:I31)","v":0},{"$f":"SUM(J10:J31)","v":12000},{"$f":"SUM(K10:K31)","v":0},{"$f":"SUM(L10:L31)","v":0},{"$f":"SUM(M10:M31)","v":0},{"$f":"SUM(N10:N31)","v":0},{"$f":"SUM(O10:O31)","v":499964},{"$f":"SUM(P10:P31)","v":21600},{"$f":"SUM(Q10:Q31)","v":0},{"$f":"SUM(R10:R31)","v":0},{"$f":"SUM(S10:S31)","v":0},{"$f":"SUM(T10:T31)","v":0},{"$f":"SUM(U10:U31)","v":1000},{"$f":"SUM(V10:V31)","v":0},{"$f":"SUM(W10:W31)","v":0},{"$f":"SUM(X10:X31)","v":0},{"$f":"SUM(Y10:Y31)","v":0},{"$f":"SUM(Z10:Z31)","v":0},{"$f":"SUM(AA10:AA31)","v":22600},{"$f":"SUM(AB10:AB31)","v":477364},{"$f":"SUM(AC10:AC31)","v":0}]
[null,"Siganture of Employee",{"$nulls":13},{"$f":"CONCATENATE(\"Signature of DPO\",\" \",\"(\",'Basic Deta'!M6,\")\")","v":"Signature of DPO ()"}]

{"sheet":"Income Tax Cal. Report","index":4,"n_rows":69,"n_cols":42,"rows_kept":69,"merged":[[0,0,69,0],[0,1,0,11],[0,12,0,18],[0,19,69,19],[0,21,0,27],[0,28,1048575,28],[1,1,1,9],[1,10,1,12],[1,15,1,18],[1,21,6,27],[2,2,2,3],[2,4,2,8],[2,10,2,13],[2,15,2,18],[3,2,3,16],[4,2,4,16],[5,2,5,16],[6,1,8,1],[6,2,6,11],[6,12,6,16],[6,17,7,18],[7,2,7,11],[7,12,7,16],[7,20,9,20],[7,21,9,24],[7,25,9,27],[8,2,8,11],[8,12,8,16],[9,2,9,16],[10,1,12,1],[10,2,10,9],[10,10,10,11],[10,12,10,16],[10,17,12,18],[10,21,10,27],[11,2,12,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[11,12,11,16],[11,20,13,20],[11,21,13,24],[11,25,13,27],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,16],[13,2,13,16],[14,2,14,16],[14,21,14,27],[15,1,17,1],[15,2,17,2],[15,4,15,16],[15,21,17,24],[15,25,17,27],[16,4,16,16],[17,4,17,16],[18,2,18,16],[19,2,19,16],[20,1,35,1],[20,2,20,18],[21,2,21,18],[22,3,22,5],[22,9,22,10],[22,17,31,18],[23,3,23,5],[23,9,23,10],[24,3,24,5],[24,9,24,10],[25,3,25,5],[25,9,25,10],[26,3,26,5],[26,9,26,10],[27,3,27,5],[27,9,27,10],[28,3,28,5],[28,9,28,10],[29,3,29,5],[29,9,29,10],[30,3,30,5],[30,9,30,10],[31,2,31,12],[32,2,32,16],[33,2,33,16],[34,2,34,16],[35,2,35,16],[36,2,36,16],[37,1,44,1],[37,2,37,16],[38,2,38,16],[39,2,39,16],[40,2,40,16],[41,2,41,16],[42,2,42,16],[43,2,43,16],[44,2,44,16],[45,2,45,16],[46,2,46,16],[47,2,47,16],[48,1,61,1],[48,2,48,18],[49,2,49,6],[49,7,49,10],[49,11,49,16],[50,2,50,4],[50,5,50,6],[50,7,50,9],[50,11,50,15],[51,2,51,4],[51,5,51,6],[51,7,51,9],[51,11,51,15],[52,2,52,4],[52,5,52,6],[52,7,52,9],[52,11,52,15],[53,2,53,4],[53,5,53,6],[53,7,53,9],[53,11,53,15],[54,2,54,4],[54,5,54,6],[54,7,54,9],[54,11,54,15],[55,2,55,4],[55,5,55,6],[55,7,55,9],[55,11,55,15],[56,2,56,4],[56,5,56,6],[56,7,56,9],[56,11,56,15],[57,2,57,16],[58,2,58,16],[59,2,59,16],[60,2,60,16],[61,2,61,16],[62,2,62,16],[63,1,64,1],[63,2,63,16],[64,2,64,16],[65,1,67,1],[65,2,67,2],[65,3,65,4],[65,5,65,7],[65,10,65,11],[65,12,65,13],[65,15,65,16],[65,17,65,18],[66,3,66,4],[66,5,66,7],[66,10,66,11],[66,12,66,13],[66,15,66,16],[67,3,67,10],[67,11,67,16],[68,1,69,9],[68,10,69,18]]}
[null,{"$f":"'Exemp.(HRA+Other) & Other incom'!A1","v":"District Education Officer, Education Department Primary Education of Bihar"},{"$nulls":10},{"$f":"'Table (Income-Deduction)'!B2","v":"Posting Place Name:- M.S. BASUDHAR"}]
[null,{"$f":"CONCATENATE(\"Income Tax Calculation F.Y.\",\":-\", 'Basic Deta'!O6)","v":"Income Tax Calculation F.Y.:-2022-23"},{"$nulls":8},{"$f":"CONCATENATE(\"(\",\"A.Y.\",\":-\",AE4,\")\")","v":"(A.Y.:-2023-24)"},{"$nulls":4},{"$f":"Z16","v":"Old Tax Regime"},{"$nulls":5},"Comparison of Itax calculation in Old and New Tax Regime",{"$nulls":8},{"$f":"YEAR('Table (Income-Deduction)'!C10)","v":2022},{"$f":"AE2+1","v":2023}]
[null,1,"Taxpayer Name :-",null,{"$f":"'Table (Income-Deduction)'!F4","v":"SHAHID ALI"},{"$nulls":4},"पद :-",{"$f":"'Basic Deta'!F10","v":"Block Teacher"},{"$nulls":3},"PAN (Treasury):",{"$f":"'Table (Income-Deduction)'!F6","v":"BFHPA0762G (BUXAR)"},{"$nulls":14},{"$f":"YEAR('Table (Income-Deduction)'!C20)","v":2023},{"$f":"AE3+1-2000","v":24}]
[null,2,"आय:वर्ष 2022-23 में कुल प्राप्त वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Table (Income-Deduction)'!O32,('Table (Income-Deduction)'!O32-'Table (Income-Deduction)'!K32))","v":{"v":499964,"d":"499964.00"}},{"$nulls":11},{"$f":"CONCATENATE(AF2,\"-\",AF3)","v":"2023-24"}]
[null,3,"गृह किराया धारा 10 (13-A) के अंतर्गत एवं 10(14) के अंतर्गत वेतन भत्ते जो कर मुक्त है l",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!K4,0)","v":{"v":13822,"d":"13822.00"}}]
[null,4,"शेष (2-3)",{"$nulls":14},"Rs.",{"$f":"S4-S5","v":{"v":486142,"d":"486142.00"}}]
[null,5,"(i)  मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L13","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)  व्यवसाय/पेशाकर धारा 16 (iii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L14","v":{"v":1000,"d":"1000.00"}},{"$nulls":7},{"$f":"Z8-Z12","v":{"v":0,"d":"0.00"}},"Tax Calculate by Old Tax Regime",{"$nulls":3},{"$f":"'OLD REGIME'!Q65","v":{"v":0,"d":"₹ 0.00"}}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction)-अधिकतम 50,000",{"$nulls":9},{"v":50000,"d":"50000.00"},{"$nulls":4},"Rs.",{"$f":"IF(P2=\"old tax regime\",M7+M8+M9,0)","v":{"v":51000,"d":"51000.00"}}]
[null,6," शेष (4-5)",{"$nulls":14},"Rs.",{"$f":"S6-S9","v":{"v":435142,"d":"435142.00"}}]
[null,7,"(अ) गृह सम्पति से आय (1) स्वयं के उपयोग में शून्य ",{"$nulls":7},"(2) प्राप्त किराया ",null,{"$f":"'Exemp.(HRA+Other) & Other incom'!L7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटाइए",null,"किराये का 30%",null,null,"गृह ऋण पर ब्याज",null,null,"गृहकर",null,"योग 7 (ब)",{"$nulls":7},{"$f":"Z12-Z8","v":{"v":0,"d":"0.00"}},"Tax Calculate by New Tax Regime",{"$nulls":3},{"$f":"'NEW REGIME'!Q65","v":{"v":0,"d":"₹ 0.00"}}]
[{"$nulls":4},{"$f":"IF(P2=\"old tax regime\",ROUND(M11*0.3,0),0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L17,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L15,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"E13+H13+K13","v":{"v":0,"d":"0.00"}}]
[null,null,"                                                     शेष -/+  {7(अ) एवं योग 7(ब)} ",{"$nulls":14},"Rs.",{"$f":"M11-M13","v":{"v":0,"d":"0.00"}}]
[null,8,"कुल शेष -/+ (6 एवं 7)",{"$nulls":14},"Rs.",{"$f":"S10+S14","v":{"v":435142,"d":"435142.00"}}]
[null,9,"अन्य आय","9(i)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B8","v":"अन्य आय (बैंक/एफडी में जमा ब्याज/अन्य ब्याज आदि का योग"},{"$nulls":12},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!L8","v":{"v":0,"d":"0.00"}},null,null,"Your Choice®",{"$nulls":3},"Old Tax Regime"]
[{"$nulls":3},"9(ii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C9","v":"(-----------------------------------------------------)"},{"$nulls":13},{"$f":"'Exemp.(HRA+Other) & Other incom'!L9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(iii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C10","v":"(-----------------------------------------------------)"},{"$nulls":13},{"$f":"'Exemp.(HRA+Other) & Other incom'!L10","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल (बिंदु संख्या -9)",{"$nulls":15},{"$f":"S16+S17+S18","v":{"v":0,"d":"0.00"}}]
[null,10,"सकल आय                                                                                                                                                                                    योग (8+9)",{"$nulls":14},"Rs.",{"$f":"S15+S19","v":{"v":435142,"d":"435142.00"}}]
[null,11,"घटाइए कटौतियां :- धारा  US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1.50 लाख (धारा 80 CCE) के अलावा "]
[null,null,"(i)",{"$f":"'Table (Income-Deduction)'!P9","v":"EPF/Montholy Invest in Future Plan "},null,null,"Rs.",{"$f":"IF(Z16=\"old tax regime\",'Table (Income-Deduction)'!P32,0)","v":{"v":21600,"d":"21600.00"}},"(x)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B16","v":"गृह ऋण किश्त मूल (जो वेतन से नहीं काटा गया)"},null,"Rs.",{"$f":"IF(Z16=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L16,0)","v":{"v":0,"d":"0.00"}},"(xix)",{"$f":"'Exemp.(HRA+Other) & Other incom'!O24","v":"इक्विटी लिंक सेविंग स्कीम/Mutual Fund"},"Rs.",{"$f":"IF(Z16=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q24,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)",{"$f":"'Table (Income-Deduction)'!Q9","v":"GIS/Group Ins."},null,null,"Rs.",{"$f":"IF(Z16=\"old tax regime\",'Table (Income-Deduction)'!Q32,0)","v":{"v":0,"d":"0.00"}},"(xi)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B19","v":"पी.एल.आई. PLI"},null,"Rs.",{"$f":"IF($Z$16=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L19,0)","v":{"v":0,"d":"0.00"}},"(xx)",{"$f":"'Exemp.(HRA+Other) & Other incom'!O25","v":"स्थिगित वार्षिकी"},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q25,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)",{"$f":"'Table (Income-Deduction)'!R9","v":"Contri. To Contributory Pension Scheme (80CCC)"},null,null,"Rs.",{"$f":"IF(Z16=\"old tax regime\",'Table (Income-Deduction)'!R32,0)","v":{"v":0,"d":"0.00"}},"(xii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B20","v":"ट्यूशन फी"},null,"Rs.",{"$f":"IF($Z$16=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L20,0)","v":{"v":0,"d":"0.00"}},"(xxi)",null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,"(iv)",{"$f":"'Table (Income-Deduction)'!S9","v":"LIC"},null,null,"Rs.",{"$f":"IF(Z16=\"old tax regime\",'Table (Income-Deduction)'!S32+'Exemp.(HRA+Other) & Other incom'!L18,0)","v":{"v":0,"d":"0.00"}},"(xiii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B21","v":"UPLI/वार्षिक प्लान"},null,"Rs.",{"$f":"IF($Z$16=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L21,0)","v":{"v":0,"d":"0.00"}},"(xxii)",null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,"(v)",{"$f":"'Table (Income-Deduction)'!T9","v":"GROUP L.I.C."},null,null,"Rs.",{"$f":"IF(Z16=\"old tax regime\",'Table (Income-Deduction)'!T32,0)","v":{"v":0,"d":"0.00"}},"(xv)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B22","v":"राष्ट्रीय बचत पत्र (NSC)"},null,"Rs.",{"$f":"IF($Z$16=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L22,0)","v":{"v":0,"d":"0.00"}},"(xxiii)",null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,"(vi)",{"$f":"'Table (Income-Deduction)'!U9","v":"गृ.नि.अ. की किस्तों की वसूली/पेशाकर"},null,null,"Rs.",{"$f":"IF('Table (Income-Deduction)'!U32='Exemp.(HRA+Other) & Other incom'!L14,0,IF(Z16=\"old tax regime\",'Table (Income-Deduction)'!U32,0))","v":{"v":0,"d":"0.00"}},"(xiv)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B23","v":"राष्ट्रीय बचत पत्र पर अदत ब्याज"},null,"Rs.",{"$f":"IF($Z$16=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L23,0)","v":{"v":0,"d":"0.00"}},"(xxiv)",null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,"(vii)",{"$f":"'Table (Income-Deduction)'!V9","v":"Other-1"},null,null,"Rs.",{"$f":"IF(Z16=\"old tax regime\",'Table (Income-Deduction)'!V32,0)","v":{"v":0,"d":"0.00"}},"(xvi)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B24","v":"लोक भविष्य निधि (PPF)"},null,"Rs.",{"$f":"IF($Z$16=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L24,0)","v":{"v":0,"d":"0.00"}},"(xxv)",null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,"(viii)",{"$f":"'Table (Income-Deduction)'!W9","v":"Other-2"},null,null,"Rs.",{"$f":"IF(Z16=\"old tax regime\",'Table (Income-Deduction)'!W32,0)","v":{"v":0,"d":"0.00"}},"(xvii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B25","v":"राष्ट्रीय बचत स्कीम (NSS)"},null,"Rs.",{"$f":"IF($Z$16=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L25,0)","v":{"v":0,"d":"0.00"}},"(xxvi)",null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,"(ix)",{"$f":"'Table (Income-Deduction)'!X9","v":"Other-3"},null,null,"Rs.",{"$f":"IF(Z16=\"old tax regime\",'Table (Income-Deduction)'!X32,0)","v":{"v":0,"d":"0.00"}},"(xviii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B26","v":"सुकन्या समृद्धि योजना"},null,"Rs.",{"$f":"IF($Z$16=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L26,0)","v":{"v":0,"d":"0.00"}},"(xxvii)",null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,"योग (i से xvii तक)",{"$nulls":12},"Rs.",{"$f":"SUM(H23:H31,M23:M31,Q23:Q31)","v":{"v":21600,"d":"21600.00"}}]
[null,null,"                      अधिकतम कटौती की राशि  1.50 लाख रूपये तक",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"new tax regime\",0,IF(Q32>=150000,150000,Q32))","v":{"v":21600,"d":"21600.00"}}]
[null,null,"(B) घटाइए - धारा 80CCD (2) नियोक्ता द्वारा नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम वेतन का 14%) अधिकतम",{"$nulls":14},"Rs.",{"v":0,"d":"0.00"}]
[null,null,"(C) घटाइए - धारा 80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु.50,000)",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q16,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"योग 11(A+B+C)      ",{"$nulls":14},"Rs.",{"$f":"SUM(S33:S35)","v":{"v":21600,"d":"21600.00"}}]
[null,12,"1. धारा 80D - चिकित्सा बीमा प्रीमियम {स्वयं/पति/पत्नी  हेतु 25,000 माता/पिता हेतु 25,000, वरिष्ठ नागरिक 50,000}",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q17,0)","v":{"v":0,"d":"0.00"}}]
[null,"अन्य कटौतियां","2. धारा 80DD - विकलांग आश्रितों का चिकित्सा उपचार (अधिकतम 75,000,  80% या अधिक विक्लांगता 1,25,000)",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q18,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"3. धारा 80DDB -विशिष्ठ रोगों के उपचार हेतु कटौती (सामान्य 40,000 एवं वरिष्ठ नागरिक 1 लाख)",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"4. धारा 80E - उच्च शिक्षा हेतु लिए ऋण पर ब्याज (धारा 80E)",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"5. धारा 80G -धर्मार्थ संस्थाओं को दिए दान (श्रेणी 'क' 100% एवं श्रेणी 'ख' 50%) ",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q21,0)","v":{"v":0,"d":"0.00"}},{"$nulls":16},">250000",">300000",">500000",">1000000"]
[null,null,"6. धारा 80U -स्थाई शारीरिक विक्लांगता की दशा में (अधिकतम 75,000 तथा अधिनियम 1995 के अनुसार 80% विक्लांगता 1,25,000)",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q22,0)","v":{"v":0,"d":"0.00"}},{"$nulls":16},{"$f":"IF($S$48>1000000,1,IF($S$48>500000,2,IF($S$48>300000,3,IF($S$48>250000,4,0))))","v":3},{"$f":"IF($S$48>1000000,1,IF($S$48>500000,2,IF($S$48>300000,3,0)))","v":3},{"$f":"IF($S$48>1000000,1,IF($S$48>500000,2,0))","v":0},{"$f":"IF($S$48>1000000,1,0)","v":0}]
[null,null,"7. अधिनियम 1995 के अनुसार धारा 80 TTA के तहत बचत खाते की जमा राशी पर प्राप्त ब्याज में छूट 10000 (80 TTB-वरिष्ठ नागरिक अधिकतम 50,000)",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",MAX('Exemp.(HRA+Other) & Other incom'!Q13:'Exemp.(HRA+Other) & Other incom'!Q14),0)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"A",{"$f":"IF(AJ42>=3,ROUND((S48-250000)*0.05,0),IF(AJ42=0,0,12500))","v":8177},0,{"$f":"IF($AL$42=2,($S$48-500000)*0.2,IF($AL$42=1,100000,0))","v":0},{"$f":"IF($AM$42>0,($S$48-1000000)*0.3,0)","v":0}]
[null,null,"8. धारा 80 GGA -अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":14},"Rs.",{"$f":"IF(P2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q23,0)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"B",{"v":0,"d":"0.00"},{"$f":"IF(AK42=3,ROUND((S48-300000)*0.05,0),IF(AK42=0,0,10000))","v":5677},{"$f":"IF($AL$42=2,($S$48-500000)*0.2,IF($AL$42=1,100000,0))","v":0},{"$f":"IF($AM$42>0,($S$48-1000000)*0.3,0)","v":0}]
[null,null,"कुल योग 12 (1 से 8)",{"$nulls":14},"Rs.",{"$f":"SUM(S37:S44)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"C",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF($AL$42=2,($S$48-500000)*0.2,IF($AL$42=1,100000,0))","v":0},{"$f":"IF($AM$42>0,($S$48-1000000)*0.3,0)","v":0}]
[null,13,"कुल कटौती (11 एवं 12)",{"$nulls":14},"Rs.",{"$f":"S36+S45","v":{"v":21600,"d":"21600.00"}}]
[null,14,"कर योग्य आय (10-13)",{"$nulls":14},"Rs.",{"$f":"S20-S46","v":{"v":413542,"d":"413542.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288A",{"$nulls":14},"Rs.",{"$f":"ROUND(S47,-1)","v":{"v":413540,"d":"413540.00"}},{"$nulls":13},{"$f":"IF(P2=\"Old tax regime\",\"A\",\"B\")","v":"A"},{"$f":"'Basic Deta'!O10","v":"A"},{"$f":"CONCATENATE(AG48,AH48)","v":"AA"}]
[null,16,"उपरोक्त बिंदु 15 के आधार पर आयकर की गणना "]
[null,null,"सामान्य करदाता",{"$nulls":4},"वरिष्ठ नागरिक (आयु 60 से 80 वर्ष)",{"$nulls":3},"80 वर्ष या अधिक आयु "]
[null,null,{"$f":"IF($P$2=\"old tax regime\",\"2,50,000 तक\",\"2,50,000 तक\")","v":"2,50,000 तक"},null,null,"Nil",null,{"$f":"IF($P$2=\"old tax regime\",\"3,00,000 तक\",\"3,00,000 तक\")","v":"3,00,000 तक"},null,null,"Nil",{"$f":"IF($P$2=\"old tax regime\",\"----\",\"3,00,000 तक\")","v":"----"},{"$nulls":4},{"$f":"IF($P$2=\"Old tax regime\",\"----\",\"Nil\")","v":"----"},"Rs.",{"v":0,"d":"0.00"}]
[null,null,"2,50,001-5,00,000",null,null,{"v":0.05,"d":"5%"},null,"3,00,001-5,00,000",null,null,{"v":0.05,"d":"5%"},{"$f":"IF($P$2=\"old tax regime\",\"5,00,000 तक\",\"3,00,001-5,00,000\")","v":"5,00,000 तक"},{"$nulls":4},{"$f":"IF(P2=\"Old tax regime\",\"Nil\",\"5%\")","v":"Nil"},"Rs.",{"$f":"IF($AI$48=\"AA\",AJ43,IF($AI$48=\"AB\",AK44,IF($AI$48=\"BA\",AJ55,IF($AI$48=\"BB\",AK56,IF($AI$48=\"BC\",AK57,0)))))","v":{"v":8177,"d":"8177.00"}}]
[null,null,{"$f":"IF($P$2=\"old tax regime\",\"5,00,001-10,00,000\",\"5,00,001-7,50,000\")","v":"5,00,001-10,00,000"},null,null,{"$f":"IF(P2=\"Old tax regime\",\"20%\",\"10%\")","v":"20%"},null,{"$f":"IF($P$2=\"old tax regime\",\"5,00,001-10,00,000\",\"5,00,001-7,50,000\")","v":"5,00,001-10,00,000"},null,null,{"$f":"IF(P2=\"Old tax regime\",\"20%\",\"10%\")","v":"20%"},{"$f":"IF($P$2=\"old tax regime\",\"5,00,001-10,00,000\",\"5,00,001-7,50,000\")","v":"5,00,001-10,00,000"},{"$nulls":4},{"$f":"IF(P2=\"Old tax regime\",\"20%\",\"10%\")","v":"20%"},"Rs.",{"$f":"IF($AI$48=\"AA\",AL43,IF($AI$48=\"AB\",AL44,IF($AI$48=\"AC\",AL45,IF($AI$48=\"BA\",AL55,IF($AI$48=\"BB\",AL56,IF($AI$48=\"BC\",AL57,0))))))","v":{"v":0,"d":"0.00"}},{"$nulls":16},">250000",">300000",">500000",">750000",">1000000",">1250000",">1500000"]
[null,null,{"$f":"IF($P$2=\"old tax regime\",\"10,00,000 से अधिक\",\"7,50,001-10,00,000\")","v":"10,00,000 से अधिक"},null,null,{"$f":"IF(P2=\"Old tax regime\",\"30%\",\"15%\")","v":"30%"},null,{"$f":"IF($P$2=\"old tax regime\",\"10,00,000 से अधिक\",\"7,50,001-10,00,000\")","v":"10,00,000 से अधिक"},null,null,{"$f":"IF(P2=\"Old tax regime\",\"30%\",\"15%\")","v":"30%"},{"$f":"IF($P$2=\"old tax regime\",\"10,00,000 से अधिक\",\"7,50,001-10,00,000\")","v":"10,00,000 से अधिक"},{"$nulls":4},{"$f":"IF(P2=\"Old tax regime\",\"30%\",\"15%\")","v":"30%"},"Rs.",{"$f":"IF($AI$48=\"AA\",AM43,IF($AI$48=\"AB\",AM44,IF($AI$48=\"AC\",AM45,IF($AI$48=\"BA\",AM55,IF($AI$48=\"BB\",AM56,IF($AI$48=\"BC\",AM57,0))))))","v":{"v":0,"d":"0.00"}},{"$nulls":16},{"$f":"IF($S$48>1500000,1,IF($S$48>1250000,2,IF($S$48>1000000,3,IF($S$48>750000,4,IF($S$48>500000,5,IF($S$48>300000,6,IF($S$48>250000,7,0)))))))","v":6},{"$f":"IF($S$48>1500000,1,IF($S$48>1250000,2,IF($S$48>1000000,3,IF($S$48>750000,4,IF($S$48>500000,5,IF($S$48>300000,6,0))))))","v":6},{"$f":"IF($S$48>1500000,1,IF($S$48>1250000,2,IF($S$48>1000000,3,IF($S$48>750000,4,IF($S$48>500000,5,0)))))","v":0},{"$f":"IF($S$48>1500000,1,IF($S$48>1250000,2,IF($S$48>1000000,3,IF($S$48>750000,4,0))))","v":0},{"$f":"IF($S$48>1500000,1,IF($S$48>1250000,2,IF($S$48>1000000,3,0)))","v":0},{"$f":"IF($S$48>1500000,1,IF($S$48>1250000,2,0))","v":0},{"$f":"IF($S$48>1500000,1,0)","v":0}]
[null,null,{"$f":"IF($P$2=\"old tax regime\",\"----\",\"10,00,001-12,50,000\")","v":"----"},null,null,{"$f":"IF(P2=\"Old tax regime\",\"----\",\"20%\")","v":"----"},null,{"$f":"IF($P$2=\"old tax regime\",\"----\",\"10,00,001-12,50,000\")","v":"----"},null,null,{"$f":"IF(P2=\"Old tax regime\",\"----\",\"20%\")","v":"----"},{"$f":"IF($P$2=\"old tax regime\",\"----\",\"10,00,001-12,50,000\")","v":"----"},{"$nulls":4},{"$f":"IF(P2=\"Old tax regime\",\"----\",\"20%\")","v":"----"},"Rs.",{"$f":"IF($AG$48=\"a\",0,AN55)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"A",{"$f":"IF(AJ54>=6,ROUND(($S$48-250000)*0.05,0),IF(AJ54=0,0,12500))","v":8177},0,{"$f":"IF($AL$54=5,ROUND(($S$48-500000)*0.1,0),IF($AL$54<=4,IF($AL$54=0,0,25000)))","v":0},{"$f":"IF($AM$54=4,ROUND(($S$48-750000)*0.15,0),IF($AM$54<=3,IF($AM$54=0,0,37500)))","v":0},{"$f":"IF($AN$54=3,ROUND(($S$48-1000000)*0.2,0),IF($AN$54<=2,IF($AN$54=0,0,50000)))","v":0},{"$f":"IF($AO$54=2,ROUND(($S$48-1250000)*0.25,0),IF($AO$54<=1,IF($AO$54=0,0,62500)))","v":0},{"$f":"IF($AP$54>0,ROUND(($S$48-1500000)*0.3,0),0)","v":0}]
[null,null,{"$f":"IF($P$2=\"old tax regime\",\"----\",\"12,50,001-15,00,000\")","v":"----"},null,null,{"$f":"IF(P2=\"Old tax regime\",\"----\",\"25%\")","v":"----"},null,{"$f":"IF($P$2=\"old tax regime\",\"----\",\"12,50,001-15,00,000\")","v":"----"},null,null,{"$f":"IF(P2=\"Old tax regime\",\"----\",\"25%\")","v":"----"},{"$f":"IF($P$2=\"old tax regime\",\"----\",\"12,50,001-15,00,000\")","v":"----"},{"$nulls":4},{"$f":"IF(P2=\"Old tax regime\",\"----\",\"25%\")","v":"----"},"Rs.",{"$f":"IF($AG$48=\"a\",0,AO55)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"B",0,{"$f":"IF(AK54=6,ROUND(($S$48-300000)*0.05,0),IF(AK54=0,0,10000))","v":5677},{"$f":"IF($AL$54=5,ROUND(($S$48-500000)*0.1,0),IF($AL$54<=4,IF($AL$54=0,0,25000)))","v":0},{"$f":"IF($AM$54=4,ROUND(($S$48-750000)*0.15,0),IF($AM$54<=3,IF($AM$54=0,0,37500)))","v":0},{"$f":"IF($AN$54=3,ROUND(($S$48-1000000)*0.2,0),IF($AN$54<=2,IF($AN$54=0,0,50000)))","v":0},{"$f":"IF($AO$54=2,ROUND(($S$48-1250000)*0.25,0),IF($AO$54<=1,IF($AO$54=0,0,62500)))","v":0},{"$f":"IF($AP$54>0,ROUND(($S$48-1500000)*0.3,0),0)","v":0}]
[null,null,{"$f":"IF($P$2=\"old tax regime\",\"----\",\"15,00,000 से अधिक\")","v":"----"},null,null,{"$f":"IF(P2=\"Old tax regime\",\"----\",\"30%\")","v":"----"},null,{"$f":"IF($P$2=\"old tax regime\",\"----\",\"15,00,000 से अधिक\")","v":"----"},null,null,{"$f":"IF(P2=\"Old tax regime\",\"----\",\"30%\")","v":"----"},{"$f":"IF($P$2=\"old tax regime\",\"----\",\"15,00,000 से अधिक\")","v":"----"},{"$nulls":4},{"$f":"IF(P2=\"Old tax regime\",\"----\",\"30%\")","v":"----"},"Rs.",{"$f":"IF($AG$48=\"a\",0,AP55)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"C",0,{"$f":"IF(AK54=6,ROUND(($S$48-300000)*0.05,0),IF(AK54=0,0,10000))","v":5677},{"$f":"IF($AL$54=5,ROUND(($S$48-500000)*0.1,0),IF($AL$54<=4,IF($AL$54=0,0,25000)))","v":0},{"$f":"IF($AM$54=4,ROUND(($S$48-750000)*0.15,0),IF($AM$54<=3,IF($AM$54=0,0,37500)))","v":0},{"$f":"IF($AN$54=3,ROUND(($S$48-1000000)*0.2,0),IF($AN$54<=2,IF($AN$54=0,0,50000)))","v":0},{"$f":"IF($AO$54=2,ROUND(($S$48-1250000)*0.25,0),IF($AO$54<=1,IF($AO$54=0,0,62500)))","v":0},{"$f":"IF($AP$54>0,ROUND(($S$48-1500000)*0.3,0),0)","v":0}]
[null,null,"(1) योग आयकर",{"$nulls":14},"Rs.",{"$f":"SUM(S51:S57)","v":{"v":8177,"d":"8177.00"}}]
[null,null,"(2) छूट धारा 87 (A) (2.50 लाख से 5.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रूपये 12,500 तक)",{"$nulls":14},"Rs.",{"$f":"IF(S48<=500000,S52,0)","v":{"v":8177,"d":"8177.00"}}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":14},"Rs.",{"$f":"S58-S59","v":{"v":0,"d":"0.00"}}]
[null,null,"(4) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":14},"Rs.",{"$f":"ROUND(S60*0.04,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":14},"Rs.",{"$f":"S60+S61","v":{"v":0,"d":"0.00"}}]
[null,17,"घटाइए :- धारा 89 के अंतर्गत राहत Rule 21A(2)",{"$nulls":14},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!Q26","v":{"v":0,"d":"0.00"}}]
[null,18,"कुल शेष आयकर",{"$nulls":14},"Rs.",{"$f":"S62-S63","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल शेष आयकर की राशि (दस के गुणक में)",{"$nulls":14},"Rs.",{"$f":"ROUND(S64,-1)","v":{"v":0,"d":"0.00"}}]
[null,19,"आयकर कटौती का विवरण","Itax deducted Till Jun-2022 (First Quarter)",null,"Itax deducted  July-22 to Sep.-22      (Second Quarter)",null,null,"Itax deducted Oct-22 to Dec.-22 (Third Quarter)","Itax Deducted/ Dedctable by Dec.22 Salary","Itax Deducted/ Dedctable by Jan-23 Salary",null,"Itax Deducted/ Dedctable by Feb-23 Salary",null,"Itax Deducted addition to Salary ","Itax submitted by other means",null,"बिंदु 19 का योग "]
[{"$nulls":3},{"$f":"SUM('Table (Income-Deduction)'!AC10:AC12)","v":0},null,{"$f":"SUM('Table (Income-Deduction)'!AC13:AC15)","v":0},null,null,{"$f":"SUM('Table (Income-Deduction)'!AC16:AC18)","v":0},{"$f":"'Table (Income-Deduction)'!AC19","v":0},{"$f":"'Table (Income-Deduction)'!AC20","v":0},null,{"$f":"'Table (Income-Deduction)'!AC21","v":0},null,{"$f":"SUM('Table (Income-Deduction)'!AC22:AC31)","v":0},{"$f":"'Basic Deta'!N19","v":0},null,"Rs.",{"$f":"SUM(D67:P67)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Income Tax Refundable/Payble",{"$nulls":7},{"$f":"IF(S67>S65,\"(Refundable)\",\"(Payble)\")","v":"(Payble)"},{"$nulls":5},"Rs.",{"$f":"S67-S65","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"'Table (Income-Deduction)'!B33","v":"Siganture of Employee"},{"$nulls":8},{"$f":"'Table (Income-Deduction)'!P33","v":"Signature of DPO ()"}]

{"sheet":"Form-16","index":5,"n_rows":164,"n_cols":29,"rows_kept":164,"merged":[[0,0,0,13],[1,0,157,0],[1,1,2,6],[1,7,2,12],[1,13,157,13],[3,1,3,6],[3,7,3,12],[4,7,5,12],[6,1,6,12],[7,1,7,8],[7,9,7,10],[8,1,8,6],[8,7,8,12],[9,1,12,6],[9,7,10,12],[11,7,12,12],[13,1,13,3],[13,4,13,6],[13,7,13,12],[14,1,14,3],[14,4,14,6],[14,7,14,12],[15,4,17,6],[15,7,15,9],[15,10,15,12],[16,7,16,8],[16,10,17,12],[17,7,17,8],[19,1,19,2],[19,3,19,5],[19,6,19,7],[19,8,19,10],[19,11,19,12],[20,1,20,2],[20,3,20,5],[20,6,20,7],[20,8,20,10],[20,11,20,12],[21,1,21,2],[21,3,21,5],[21,6,21,7],[21,8,21,10],[21,11,21,12],[22,1,22,2],[22,3,22,5],[22,6,22,7],[22,8,22,10],[22,11,22,12],[23,1,23,2],[23,3,23,5],[23,6,23,7],[23,8,23,10],[23,11,23,12],[24,1,24,2],[24,3,24,5],[24,6,24,7],[24,8,24,10],[24,11,24,12],[25,1,25,12],[26,2,26,4],[26,5,26,12],[27,2,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[29,2,29,4],[29,7,29,8],[29,9,29,10],[30,2,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[31,2,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[32,2,32,4],[32,11,32,12],[33,2,33,4],[33,11,33,12],[34,2,34,4],[34,11,34,12],[35,2,35,4],[35,11,35,12],[36,2,36,4],[36,11,36,12],[37,2,37,4],[37,11,37,12],[38,2,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[39,2,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[40,2,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[41,2,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[42,2,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[44,1,44,12],[45,2,45,4],[45,5,45,12],[46,2,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[48,2,48,4],[48,7,48,8],[48,9,48,10],[49,2,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[50,2,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[51,2,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[52,2,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[53,2,53,4],[53,5,53,6],[53,7,53,12],[54,1,54,12],[55,2,55,4],[55,7,55,9],[56,1,56,3],[57,1,57,5],[58,1,59,12],[60,1,60,2],[61,1,61,12],[62,1,62,12],[63,1,63,12],[64,1,64,12],[65,1,65,7],[66,1,66,12],[67,1,67,12],[68,1,68,12],[69,1,69,12],[70,1,70,12],[71,1,71,5],[74,1,74,12],[75,1,75,12],[82,10,82,11],[85,1,85,7],[86,1,86,7],[87,10,87,11],[102,1,102,4],[103,9,103,10],[104,7,104,8],[104,9,104,10],[104,11,104,12],[105,3,105,5],[105,7,105,8],[105,9,105,10],[105,11,105,12],[106,3,106,5],[106,7,106,8],[106,9,106,10],[106,11,106,12],[107,3,107,5],[107,7,107,8],[107,9,107,10],[107,11,107,12],[108,3,108,5],[108,7,108,8],[108,9,108,10],[108,11,108,12],[109,3,109,5],[109,7,109,8],[109,9,109,10],[109,11,109,12],[110,3,110,5],[110,7,110,8],[110,9,110,10],[110,11,110,12],[111,3,111,5],[111,7,111,8],[111,9,111,10],[111,11,111,12],[112,3,112,5],[112,7,112,8],[112,9,112,10],[112,11,112,12],[113,3,113,5],[113,7,113,8],[113,9,113,10],[113,11,113,12],[114,3,114,5],[114,7,114,8],[114,9,114,10],[114,11,114,12],[115,1,115,6],[117,7,117,8],[117,9,117,10],[117,11,117,12],[118,7,118,8],[118,9,118,10],[118,11,118,12],[121,9,121,10],[122,3,122,5],[122,7,122,8],[122,9,122,10],[122,11,122,12],[123,3,123,5],[123,7,123,8],[123,9,123,10],[123,11,123,12],[124,3,124,5],[124,7,124,8],[124,9,124,10],[124,11,124,12],[125,3,125,5],[125,7,125,8],[125,9,125,10],[125,11,125,12],[126,3,126,5],[126,7,126,8],[126,9,126,10],[126,11,126,12],[127,3,127,5],[127,7,127,8],[127,9,127,10],[127,11,127,12],[128,1,129,6],[128,12,129,12],[130,1,130,6],[130,7,130,8],[130,9,130,10],[130,11,130,12],[131,11,131,12],[132,1,132,6],[140,1,141,6],[141,9,141,10],[143,9,143,10],[144,1,144,12],[145,2,145,4],[145,7,145,9],[146,1,146,3],[147,1,147,12],[152,6,152,12],[153,6,153,12],[154,2,154,5],[154,7,154,8],[154,9,154,10],[155,2,155,5],[155,7,155,8],[155,9,155,10],[157,1,157,12]]}
[]
[null,"FORM NO.16",{"$nulls":5},"T.D.S."]
[{"$nulls":21},"(i)",{"$f":"AC3","v":1},{"$f":"VLOOKUP($V3,'Income Tax Cal. Report'!$C$23:$H$31,2,0)","v":"EPF/Montholy Invest in Future Plan "},{"$f":"VLOOKUP($V3,'Income Tax Cal. Report'!$C$23:$H$31,6,0)","v":21600},null,{"$f":"IF(Y3>0,1,0)","v":1},{"$f":"AA3","v":1},{"$f":"IF(AB3>0,1,0)","v":1}]
[null,"[See rule 31 (1) (a)]",{"$nulls":5},"Part A",{"$nulls":13},"(ii)",{"$f":"AC4","v":0},{"$f":"VLOOKUP($V4,'Income Tax Cal. Report'!$C$23:$H$31,2,0)","v":"GIS/Group Ins."},{"$f":"VLOOKUP($V4,'Income Tax Cal. Report'!$C$23:$H$31,6,0)","v":0},null,{"$f":"IF(Y4>0,1,0)","v":0},{"$f":"AA4+AB3","v":1},{"$f":"IF(AB4>AB3,1+AB3,0)","v":0}]
[{"$nulls":7},"Certificate under section 203 of the Income Tax Act, 1961 for tax deducted at source from income chargeable under the head  “ Salaries “",{"$nulls":13},"(iii)",0,{"$f":"VLOOKUP($V5,'Income Tax Cal. Report'!$C$23:$H$31,2,0)","v":"Contri. To Contributory Pension Scheme (80CCC)"},{"$f":"VLOOKUP($V5,'Income Tax Cal. Report'!$C$23:$H$31,6,0)","v":0},null,0,{"$f":"AA5+AB4","v":1},{"$f":"IF(AB5>AB4,1+AB4,0)","v":0}]
[{"$nulls":21},"(iv)",0,{"$f":"VLOOKUP($V6,'Income Tax Cal. Report'!$C$23:$H$31,2,0)","v":"LIC"},{"$f":"VLOOKUP($V6,'Income Tax Cal. Report'!$C$23:$H$31,6,0)","v":0},null,0,{"$f":"AA6+AB5","v":1},0]
[null,{"$f":"CONCATENATE(\"Calculation as per\",\"  \",'Income Tax Cal. Report'!Z16)","v":"Calculation as per  Old Tax Regime"},{"$nulls":19},"(v)",0,{"$f":"VLOOKUP($V7,'Income Tax Cal. Report'!$C$23:$H$31,2,0)","v":"GROUP L.I.C."},{"$f":"VLOOKUP($V7,'Income Tax Cal. Report'!$C$23:$H$31,6,0)","v":0},null,0,{"$f":"AA7+AB6","v":1},{"$f":"IF(AB7>AB6,1+AB6,0)","v":0}]
[{"$nulls":9},"Tax Payer Age Group:-",null,null,{"$f":"IF('Basic Deta'!O10=\"A\",\"Under 60 Yrs.\",IF('Basic Deta'!O10=\"B\",\"Between 60&80 Yrs.\",\"Above 80 Yrs.\"))","v":"Under 60 Yrs."},{"$nulls":8},"(vi)",0,{"$f":"VLOOKUP($V8,'Income Tax Cal. Report'!$C$23:$H$31,2,0)","v":"गृ.नि.अ. की किस्तों की वसूली/पेशाकर"},{"$f":"VLOOKUP($V8,'Income Tax Cal. Report'!$C$23:$H$31,6,0)","v":0},null,0,{"$f":"AA8+AB7","v":1},{"$f":"IF(AB8>AB7,1+AB7,0)","v":0}]
[null,"Name and address of the employer",{"$nulls":5},"Name and Designation of the employee",{"$nulls":13},"(vii)",{"$f":"AC9","v":0},{"$f":"VLOOKUP($V9,'Income Tax Cal. Report'!$C$23:$H$31,2,0)","v":"Other-1"},{"$f":"VLOOKUP($V9,'Income Tax Cal. Report'!$C$23:$H$31,6,0)","v":0},null,0,{"$f":"AA9+AB7","v":1},{"$f":"IF(AB9>AB7,1+AB7,0)","v":0}]
[null,{"$f":"CONCATENATE('Exemp.(HRA+Other) & Other incom'!A1)","v":"District Education Officer, Education Department Primary Education of Bihar"},{"$nulls":5},{"$f":"CONCATENATE('Exemp.(HRA+Other) & Other incom'!A4,\"  \",\"(\",'Exemp.(HRA+Other) & Other incom'!C4,\")\")","v":"SHAHID ALI  (Block Teacher)"},{"$nulls":13},"(viii)",0,{"$f":"VLOOKUP($V10,'Income Tax Cal. Report'!$C$23:$H$31,2,0)","v":"Other-2"},{"$f":"VLOOKUP($V10,'Income Tax Cal. Report'!$C$23:$H$31,6,0)","v":0},null,0,{"$f":"AA10+AB9","v":1},{"$f":"IF(AB10>AB9,1+AB9,0)","v":0}]
[{"$nulls":21},"(ix)",0,{"$f":"VLOOKUP($V11,'Income Tax Cal. Report'!$C$23:$H$31,2,0)","v":"Other-3"},{"$f":"VLOOKUP($V11,'Income Tax Cal. Report'!$C$23:$H$31,6,0)","v":0},null,0,{"$f":"AA11+AB10","v":1},{"$f":"IF(AB11>AB10,1+AB10,0)","v":0}]
[{"$nulls":7},{"$f":"CONCATENATE('Basic Deta'!G9,\":-\",'Basic Deta'!G10)","v":"Posting Place Name:-M.S. BASUDHAR"},{"$nulls":13},"(x)",0,{"$f":"VLOOKUP($V12,'Income Tax Cal. Report'!$I$23:$M$31,2,0)","v":"गृह ऋण किश्त मूल (जो वेतन से नहीं काटा गया)"},{"$f":"VLOOKUP($V12,'Income Tax Cal. Report'!$I$23:$M$31,5,0)","v":0},null,0,{"$f":"AA12+AB11","v":1},{"$f":"IF(AB12>AB11,1+AB11,0)","v":0}]
[{"$nulls":21},"(xi)",0,{"$f":"VLOOKUP($V13,'Income Tax Cal. Report'!$I$23:$M$31,2,0)","v":"पी.एल.आई. PLI"},{"$f":"VLOOKUP($V13,'Income Tax Cal. Report'!$I$23:$M$31,5,0)","v":0},null,0,1,0]
[null,"PAN of the Deducter",null,null,"TAN of the Deducter",null,null,"PAN of the Employee",{"$nulls":9},{"$f":"I25","v":0},{"$nulls":3},"(xii)",0,{"$f":"VLOOKUP($V14,'Income Tax Cal. Report'!$I$23:$M$31,2,0)","v":"ट्यूशन फी"},{"$f":"VLOOKUP($V14,'Income Tax Cal. Report'!$I$23:$M$31,5,0)","v":0},null,0,1,0]
[{"$nulls":4},{"$f":"'Basic Deta'!I6","v":0},null,null,{"$f":"'Basic Deta'!L10","v":"BFHPA0762G"},{"$nulls":9},{"$f":"C43","v":0},{"$nulls":3},"(xiii)",0,{"$f":"VLOOKUP($V15,'Income Tax Cal. Report'!$I$23:$M$31,2,0)","v":"UPLI/वार्षिक प्लान"},{"$f":"VLOOKUP($V15,'Income Tax Cal. Report'!$I$23:$M$31,5,0)","v":0},null,0,1,0]
[null,"TDS Circle where annual",{"$nulls":5},"PERIOD",null,null,"Assessment Year",{"$nulls":6},{"$f":"C54","v":0},{"$nulls":3},"(xv)",0,{"$f":"VLOOKUP($V16,'Income Tax Cal. Report'!$I$23:$M$31,2,0)","v":"राष्ट्रीय बचत पत्र (NSC)"},{"$f":"VLOOKUP($V16,'Income Tax Cal. Report'!$I$23:$M$31,5,0)","v":0},null,0,1,0]
[null,"return / statement under",{"$nulls":5},"FROM",null,"TO",{"$f":"'Income Tax Cal. Report'!AE4","v":"2023-24"},{"$nulls":6},{"$f":"SUM(R14:R16)","v":0},{"$nulls":3},"(xiv)",0,{"$f":"VLOOKUP($V17,'Income Tax Cal. Report'!$I$23:$M$31,2,0)","v":"राष्ट्रीय बचत पत्र पर अदत ब्याज"},{"$f":"VLOOKUP($V17,'Income Tax Cal. Report'!$I$23:$M$31,5,0)","v":0},null,0,1,0]
[null,"section 206 is to be filed",{"$nulls":5},{"$f":"'Table (Income-Deduction)'!C11","v":"2022-04-01"},null,{"$f":"EOMONTH('Table (Income-Deduction)'!C21,0)+31","v":"2023-03-31"},{"$nulls":11},"(xvi)",0,{"$f":"VLOOKUP($V18,'Income Tax Cal. Report'!$I$23:$M$31,2,0)","v":"लोक भविष्य निधि (PPF)"},{"$f":"VLOOKUP($V18,'Income Tax Cal. Report'!$I$23:$M$31,5,0)","v":0},null,0,1,0]
[null,"Smmary of amount Paid/credited and tax Deducted at source thereon in respect of the Employee",{"$nulls":19},"(xvii)",0,{"$f":"VLOOKUP($V19,'Income Tax Cal. Report'!$I$23:$M$31,2,0)","v":"राष्ट्रीय बचत स्कीम (NSS)"},{"$f":"VLOOKUP($V19,'Income Tax Cal. Report'!$I$23:$M$31,5,0)","v":0},null,0,1,0]
[null,"Quarter(s)",null,"Receipt Numbersof Original Quaterly Statements of TDS Under Sub-Section (3) of Section 200",null,null,"Amount Paid cridited",null,"      Amount of Tax Deducted     (Rs)",null,null,"Amount of Tax Deposited / Remitted                               (Rs)",{"$nulls":9},"(xviii)",0,{"$f":"VLOOKUP($V20,'Income Tax Cal. Report'!$I$23:$M$31,2,0)","v":"सुकन्या समृद्धि योजना"},{"$f":"VLOOKUP($V20,'Income Tax Cal. Report'!$I$23:$M$31,5,0)","v":0},null,0,1,0]
[null,"Quarter 1",{"$nulls":6},{"$f":"'Income Tax Cal. Report'!D67","v":0},null,null,{"$f":"I21","v":0},{"$nulls":9},"(xix)",0,{"$f":"VLOOKUP($V21,'Income Tax Cal. Report'!$N$23:$Q$31,2,0)","v":"इक्विटी लिंक सेविंग स्कीम/Mutual Fund"},{"$f":"VLOOKUP($V21,'Income Tax Cal. Report'!$N$23:$Q$31,4,0)","v":0}]
[null,"Quarter 2",{"$nulls":6},{"$f":"'Income Tax Cal. Report'!F67","v":0},null,null,{"$f":"I22","v":0},{"$nulls":9},"(xx)",0,{"$f":"VLOOKUP($V22,'Income Tax Cal. Report'!$N$23:$Q$31,2,0)","v":"स्थिगित वार्षिकी"},{"$f":"VLOOKUP($V22,'Income Tax Cal. Report'!$N$23:$Q$31,4,0)","v":0}]
[null,"Quarter 3",{"$nulls":6},{"$f":"'Income Tax Cal. Report'!I67","v":0},null,null,{"$f":"I23","v":0},{"$nulls":9},"(xxi)",0,{"$f":"VLOOKUP($V23,'Income Tax Cal. Report'!$N$23:$Q$31,2,0)","v":0},{"$f":"VLOOKUP($V23,'Income Tax Cal. Report'!$N$23:$Q$31,4,0)","v":0}]
[null,"Quarter 4",{"$nulls":6},{"$f":"'Income Tax Cal. Report'!J67+'Income Tax Cal. Report'!K67+'Income Tax Cal. Report'!L67+'Income Tax Cal. Report'!M67","v":0},null,null,{"$f":"I24","v":0},{"$nulls":9},"(xxii)",0,{"$f":"VLOOKUP($V24,'Income Tax Cal. Report'!$N$23:$Q$31,2,0)","v":0},{"$f":"VLOOKUP($V24,'Income Tax Cal. Report'!$N$23:$Q$31,4,0)","v":0}]
[null,"Total",{"$nulls":4},{"$f":"SUM(G21:H24)","v":0},null,{"$f":"SUM(I21:K24)","v":0},null,null,{"$f":"SUM(L21:M24)","v":0},{"$nulls":9},"(xxiii)",0,{"$f":"VLOOKUP($V25,'Income Tax Cal. Report'!$N$23:$Q$31,2,0)","v":0},{"$f":"VLOOKUP($V25,'Income Tax Cal. Report'!$N$23:$Q$31,4,0)","v":0}]
[null,"I.DETAILS TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT THROUGH BOOK ADJUSTMENT",{"$nulls":19},"(xxiv)",0,{"$f":"VLOOKUP($V26,'Income Tax Cal. Report'!$N$23:$Q$31,2,0)","v":0},{"$f":"VLOOKUP($V26,'Income Tax Cal. Report'!$N$23:$Q$31,4,0)","v":0}]
[null,"S.No","Tax Deposited In Respect",null,null,"Book Identification Number (BIN)",{"$nulls":15},"(xxv)",0,{"$f":"VLOOKUP($V27,'Income Tax Cal. Report'!$N$23:$Q$31,2,0)","v":0},{"$f":"VLOOKUP($V27,'Income Tax Cal. Report'!$N$23:$Q$31,4,0)","v":0}]
[null,null,"of the deducter",null,null,"Receipt Numbers of",null,"DDO Serial No in",null,"Date Of Transfer",null,"Status of Maching",{"$nulls":9},"(xxvi)",0,{"$f":"VLOOKUP($V28,'Income Tax Cal. Report'!$N$23:$Q$31,2,0)","v":0},{"$f":"VLOOKUP($V28,'Income Tax Cal. Report'!$N$23:$Q$31,4,0)","v":0}]
[{"$nulls":3},"(Rs)",null,"Form No.24G",null,"Form No.24G",null,"Form No.24G",null,"with Form.No 24G",{"$nulls":9},"(xxvii)",0,{"$f":"VLOOKUP($V29,'Income Tax Cal. Report'!$N$23:$Q$31,2,0)","v":0},{"$f":"VLOOKUP($V29,'Income Tax Cal. Report'!$N$23:$Q$31,4,0)","v":0}]
[{"$nulls":9},"(dd/mm/yyyy)"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,"Total (Rs)",{"$f":"SUM(C31:E42)","v":0}]
[]
[null,"II.DETAILS TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT THROUGH BOOK CHALLAN"]
[null,"S.No","Tax Deposited In Respect",null,null,"Book Identification Number (CIN)"]
[null,null,"of the deducter",null,null,"BRS Code of  the ",null,"Date on Which",null,"Challana Serial",null,"Status of Maching"]
[{"$nulls":3},"(Rs)",null,"Bank Branch",null,"Tax Deposited",null,"Number",null,"with Form.No 24G"]
[{"$nulls":7},"(dd/mm/yyyy)"]
[null,1,{"$f":"'Exemp.(HRA+Other) & Other incom'!Q7","v":0},null,null,{"$f":"'Exemp.(HRA+Other) & Other incom'!P7","v":0},null,{"$f":"'Exemp.(HRA+Other) & Other incom'!N7","v":"00:00:00"},null,{"$f":"'Exemp.(HRA+Other) & Other incom'!O7","v":0},null,{"$f":"IF(C50>0,\"Matched\",0)","v":0}]
[null,2,{"$f":"'Exemp.(HRA+Other) & Other incom'!Q8","v":0},null,null,{"$f":"'Exemp.(HRA+Other) & Other incom'!P8","v":0},null,{"$f":"'Exemp.(HRA+Other) & Other incom'!N8","v":"00:00:00"},null,{"$f":"'Exemp.(HRA+Other) & Other incom'!O8","v":0},null,{"$f":"IF(C51>0,\"Matched\",0)","v":0}]
[null,3,{"$f":"'Exemp.(HRA+Other) & Other incom'!Q9","v":0},null,null,{"$f":"'Exemp.(HRA+Other) & Other incom'!P9","v":0},null,{"$f":"'Exemp.(HRA+Other) & Other incom'!N9","v":"00:00:00"},null,{"$f":"'Exemp.(HRA+Other) & Other incom'!O9","v":0},null,0]
[null,4,{"$f":"'Exemp.(HRA+Other) & Other incom'!Q10","v":0},null,null,{"$f":"'Exemp.(HRA+Other) & Other incom'!P10","v":0},null,{"$f":"'Exemp.(HRA+Other) & Other incom'!N10","v":"00:00:00"},null,{"$f":"'Exemp.(HRA+Other) & Other incom'!O10","v":0},null,0]
[null,"Total (Rs)",{"$f":"SUM(C50:E53)","v":0}]
[null,"Verification"]
[null,"I,",{"$f":"'Basic Deta'!M5","v":"SHARIQUE ASHRAF"},null,null,"Son/Doughter of ",null,{"$f":"'Basic Deta'!M6","v":0},null,null,"  Working In the Capacity Of"]
[null,"DPO (Estt.)",null,null,"(Designation) do hereby certify that a sum  of Rs.",{"$nulls":4},{"$f":"'Income Tax Cal. Report'!S67","v":0},"(in words)"]
[{"$nulls":6},"has beeen deducted at source and paid to the credit of the Central Government."]
[null," I further certify that the information given  above is true and correct based on the book of accounts, documents and TDS Statements, TDS Deposited and other available records."]
[]
[null,"Notes :"]
[null,"1.  Government deductors to fill information in item I if tax is paid without production of an income-tax challan and in item II if tax ."]
[null,"        is paid accompanied by an income-tax challan"]
[null,"2.  Non-Government deductors to fill information in item II."]
[null,"3.  The deductor shall furnish the address of  the Commissioner of  Income-tax (TDS) having jurisdiction as regards TDS "]
[null,"     statements of the assessee."]
[null,"4.  If an assessee is employed under one employer only during the year, certificate in Form No. 16 issued for the quarter ending on"]
[null,"      31st March of the financial year shall contain the details of tax deducted and deposited for all the quarters of the financial year."]
[null,"5.  If  an  assessee  is  employed  under  more  than  one  employer  during  the  year,  each  of  the employers shall issue Part "]
[null,"      A of the certificate in Form No. 16 pertaining to the period for which such assessee was employed with each of the employers."]
[null,"    Part B (Annexure) of the certificate in Form No.16 may be issued by each of the employers or the last employer at the"]
[null,"    option of the assessee."]
[null,"6.  In items I and II, in column for tax deposited in respect of deductee, furnish total amount of TDS and education cess.\""]
[]
[null,"Part B"]
[null,"DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
[null,"1. Gross Salary *"]
[null,null,"( a ) Salary as per provisions contained in section 17 (1)",{"$nulls":6},{"$f":"'Income Tax Cal. Report'!S4","v":{"v":499964,"d":"₹ 499,964.00"}}]
[null,null,"( b ) Value of perquisites under section 17 (2)"]
[null,null,"        (as per Form No. 12 BA, wherever applicable)"]
[null,null,"( c ) Profits in lieu of Salary under section 17 (3)"]
[null,null,"        (as per Form No. 12 BA, wherever applicable)"]
[null,null,"( d ) Total",{"$nulls":7},{"$f":"+J82+J80+J78","v":{"v":499964,"d":"₹ 499,964.00"}}]
[]
[null,"2. Less : Allowance to the extent exempt under section 10"]
[null,"a) HRA {U/s 10 (13-A)}",{"$nulls":7},{"$f":"'Income Tax Cal. Report'!S5","v":{"v":13822,"d":"₹ 13,822.00"}}]
[null,"b)"]
[null,"3. Balance (1-2)",{"$nulls":8},{"$f":"+K83-J85-J86-J87","v":{"v":486142,"d":"₹ 486,142.00"}}]
[]
[null,"4. Deductions :          ",{"$nulls":15},{"$f":"IF('Income Tax Cal. Report'!Z16=\"New tax regime\",0,'Income Tax Cal. Report'!S9)","v":{"v":51000,"d":"51000.00"}}]
[null,null,"(a) Standard deduction",{"$nulls":3},"Rs.",{"$f":"R90-R91","v":{"v":50000,"d":"₹ 50,000.00"}},{"$nulls":9},{"$f":"IF('Income Tax Cal. Report'!Z16=\"New tax regime\",0,'Income Tax Cal. Report'!M7+'Income Tax Cal. Report'!M8)","v":{"v":1000,"d":"1000.00"}}]
[null,null,"(b) Entertainment allowance",{"$nulls":3},"Rs.",{"$f":"R91","v":{"v":1000,"d":"₹ 1,000.00"}}]
[null,null,"(c) Tax on Employment",{"$nulls":3},"Rs.",0]
[null,"5. Aggregate of 4 (a to c)",{"$nulls":7},{"$f":"+H91+H92+H93","v":{"v":51000,"d":"₹ 51,000.00"}}]
[]
[null,"6. Income chargeable under the Head ‘Salaries’(3-5)",{"$nulls":10},{"$f":"IF(AND((K88>50000)),(K88-J94),0)","v":{"v":435142,"d":"₹ 435,142.00"}}]
[]
[null,"7. Add. : Any other income reported by the employee",{"$nulls":10},{"$f":"'Income Tax Cal. Report'!M11","v":{"v":0,"d":"₹ 0.00"}}]
[null,null,"Less:-  Loss From House Properties",{"$nulls":9},{"$f":"'Income Tax Cal. Report'!M13","v":{"v":0,"d":"₹ 0.00"}}]
[]
[null,"8. Gross total income  (6+7)",{"$nulls":10},{"$f":"+M96+M98-M99","v":{"v":435142,"d":"₹ 435,142.00"}}]
[]
[null,"9. Deductions Under Chapter VIA    "]
[null,"A.","Sections 80C,80CC and 80CCD",{"$nulls":4},"Gross Amount",null,"Qualifying Amt.",null,"Deductible Amt.","Deductible Amt"]
[null,"(a)","Sections 80C,80CC and 80CCD(1)"]
[null,1,"(i)",{"$f":"IFERROR(VLOOKUP($B106,$W$3:$Y$29,2,0),\"--\")","v":"EPF/Montholy Invest in Future Plan "},null,null,"Rs.",{"$f":"IFERROR(VLOOKUP($B106,$W$3:$Y$29,3,0),\"--\")","v":{"v":21600,"d":"₹ 21,600.00"}},null,{"$f":"+H106","v":{"v":21600,"d":"₹ 21,600.00"}},null,{"$f":"J106","v":{"v":21600,"d":"₹ 21,600.00"}}]
[null,2,"(ii)",{"$f":"IFERROR(VLOOKUP(B107,$W$3:$Y$29,2,0),\"--\")","v":"--"},null,null,"Rs.",{"$f":"IFERROR(VLOOKUP($B107,$W$3:$Y$29,3,0),\"--\")","v":"--"},null,"--",null,"--"]
[null,3,"(iii)","--",null,null,"Rs.","--",null,"--",null,"--"]
[null,4,"(iv)","--",null,null,"Rs.","--",null,"--",null,"--"]
[null,5,"(v)","--",null,null,"Rs.","--",null,"--",null,"--"]
[null,6,"(vi)","--",null,null,"Rs.","--",null,"--",null,"--"]
[null,7,"(vii)","--",null,null,"Rs.","--",null,{"$f":"+H112","v":"--"},null,{"$f":"J112","v":"--"}]
[null,8,"(viii)","--",null,null,"Rs.","--",null,"--",null,"--"]
[null,9,"(ix)","--",null,null,"Rs.","--",null,"--",null,"--"]
[null,10,"(xi)","--",null,null,"Rs.","--",null,"--",null,"--"]
[null,"Aggregate amount deductible under the three sections i.e.80C, 80CCC and 80CCD (Max. 1.50 Lac)",{"$nulls":10},{"$f":"IF(SUM(L106:M111)>150000,150000,SUM(L106:M111))","v":{"v":21600,"d":"₹ 21,600.00"}}]
[]
[null,"(b)","Section 80CCD (2)",{"$nulls":3},"Rs.",{"$f":"'Income Tax Cal. Report'!S34","v":{"v":0,"d":"₹ 0.00"}},null,{"$f":"+H118","v":{"v":0,"d":"₹ 0.00"}},null,{"$f":"J118","v":{"v":0,"d":"₹ 0.00"}}]
[null,"(c)","Section 80CCD (1B)",{"$nulls":3},"Rs.",{"$f":"'Income Tax Cal. Report'!S35","v":{"v":0,"d":"₹ 0.00"}},null,{"$f":"+H119","v":{"v":0,"d":"₹ 0.00"}},null,{"$f":"IF(J119>50000,50000,J119)","v":{"v":0,"d":"₹ 0.00"}}]
[]
[null,"B.","Other Sections ( e.g. 80E, 80G, 80TTA etc) Under Chapter VIA"]
[{"$nulls":7},"Gross Amount",null,"Qualifying Amt.",null,"Deductible Amt.","Deductible Amt"]
[null,1,"(i)",{"$f":"IFERROR(VLOOKUP(B106,$Q$157:$X$164,8,0),\"--\")","v":"--"},null,null,"Rs.",{"$f":"IFERROR(VLOOKUP(B106,$Q$157:$X$164,3,0),\"0\")","v":"0"},null,{"$f":"+H123","v":"0"},null,{"$f":"J123","v":"0"}]
[null,2,"(ii)",{"$f":"IFERROR(VLOOKUP(B107,$Q$157:$X$164,8,0),\"--\")","v":"--"},null,null,"Rs.",{"$f":"IFERROR(VLOOKUP(B107,$Q$157:$X$164,3,0),\"0\")","v":"0"},null,"0",null,"0"]
[null,3,"(iii)","--",null,null,"Rs.","0",null,"0",null,"0"]
[null,4,"(iv)","--",null,null,"Rs.","0",null,"0",null,"0"]
[null,5,"(v)","--",null,null,"Rs.","0",null,"0",null,"0"]
[null,6,"(vi)","--",null,null,"Rs.","0",null,"0",null,"0"]
[null,"Aggregate amount deductible under the three sections i.e.80E, 80G, 80TTA ",{"$nulls":10},{"$f":"IF(SUM(L123:M128)>150000,150000,SUM(L123:M128))","v":{"v":0,"d":"₹ 0.00"}}]
[]
[null,"10. Aggregate of deductible amount under chapter VI-A (A+B)",{"$nulls":9},{"$f":"M116+L118+L119+M129","v":{"v":21600,"d":"₹ 21,600.00"}},{"$f":"SUM(K105:K116)","v":{"v":0,"d":"₹ 0.00"}}]
[]
[null,"11. Total Taxable Income (8-10 ) Nearest Decimal Figure (U/s 288A)",{"$nulls":10},{"$f":"'Income Tax Cal. Report'!S48","v":{"v":413540,"d":"₹ 413,540.00"}}]
[]
[null,"12. Tax on total Income ",{"$nulls":10},{"$f":"'Income Tax Cal. Report'!S58","v":{"v":8177,"d":"₹ 8,177.00"}}]
[null,"13. Rebate U/S 87a",{"$nulls":10},{"$f":"'Income Tax Cal. Report'!S59","v":{"v":8177,"d":"₹ 8,177.00"}},null,null,"(i)",{"$f":"W136","v":1},{"$f":"VLOOKUP(P136,'Income Tax Cal. Report'!C23:I31,2,0)","v":"EPF/Montholy Invest in Future Plan "},{"$f":"VLOOKUP(P136,'Income Tax Cal. Report'!C23:I31,7,0)","v":"(x)"},null,{"$f":"IF(S136>0,1,0)","v":1},{"$f":"U136","v":1},{"$f":"IF(V136>V122,1,0)","v":1}]
[null,"14. Tax Payable on total income (12-13)",{"$nulls":10},{"$f":"IF((M135-M136)>0,(M135-M136),0)","v":{"v":0,"d":"₹ 0.00"}},null,null,"(ii)",{"$f":"W137","v":2},{"$f":"VLOOKUP(P137,'Income Tax Cal. Report'!C24:I32,2,0)","v":"GIS/Group Ins."},{"$f":"VLOOKUP(P137,'Income Tax Cal. Report'!C24:I32,7,0)","v":"(xi)"},null,{"$f":"IF(S137>0,1,0)","v":1},{"$f":"U137+V136","v":2},{"$f":"IF(V137>V136,1+V136,0)","v":2}]
[null,"15.Education & Health Cess 4%",{"$nulls":10},{"$f":"M137*4%","v":{"v":0,"d":"₹ 0.00"}},null,null,"(iii)",3,{"$f":"VLOOKUP(P138,'Income Tax Cal. Report'!C25:I33,2,0)","v":"Contri. To Contributory Pension Scheme (80CCC)"},{"$f":"VLOOKUP(P138,'Income Tax Cal. Report'!C25:I33,7,0)","v":"(xii)"},null,1,{"$f":"U138+V137","v":3},{"$f":"IF(V138>V137,1+V137,0)","v":3}]
[null,"16. Tax payable (14+15)",{"$nulls":10},{"$f":"M137+M138","v":{"v":0,"d":"₹ 0.00"}},null,null,"(iv)",4,{"$f":"VLOOKUP(P139,'Income Tax Cal. Report'!C26:I34,2,0)","v":"LIC"},{"$f":"VLOOKUP(P139,'Income Tax Cal. Report'!C26:I34,7,0)","v":"(xiii)"},null,1,{"$f":"U139+V138","v":4},4]
[null,"17. Relife Under Section 89 (attach details)",{"$nulls":10},{"$f":"'Income Tax Cal. Report'!S63","v":{"v":0,"d":"₹ 0.00"}},null,null,"(v)",5,{"$f":"VLOOKUP(P140,'Income Tax Cal. Report'!C27:I35,2,0)","v":"GROUP L.I.C."},{"$f":"VLOOKUP(P140,'Income Tax Cal. Report'!C27:I35,7,0)","v":"(xv)"},null,1,{"$f":"U140+V139","v":5},{"$f":"IF(V140>V139,1+V139,0)","v":5}]
[null,"18. Tax payable (16-17)",{"$nulls":10},{"$f":"M139-M140","v":{"v":0,"d":"₹ 0.00"}},null,null,"(vi)",6,{"$f":"VLOOKUP(P141,'Income Tax Cal. Report'!C28:I36,2,0)","v":"गृ.नि.अ. की किस्तों की वसूली/पेशाकर"},{"$f":"VLOOKUP(P141,'Income Tax Cal. Report'!C28:I36,7,0)","v":"(xiv)"},null,1,{"$f":"U141+V140","v":6},6]
[{"$nulls":9}," Nearest Decimal Figure",null,null,{"$f":"ROUND(M141,-1)","v":{"v":0,"d":"₹ 0.00"}}]
[null,"19.Tax Deducted at source U/S 192",{"$nulls":10},{"$f":"'Income Tax Cal. Report'!S67","v":{"v":0,"d":"₹ 0.00"}},null,null,"(vii)",7,{"$f":"VLOOKUP(P143,'Income Tax Cal. Report'!C29:I37,2,0)","v":"Other-1"},{"$f":"VLOOKUP(P143,'Income Tax Cal. Report'!C29:I37,7,0)","v":"(xvi)"},null,1,{"$f":"U143+V141","v":7},{"$f":"IF(V143>V141,1+V141,0)","v":7}]
[null,"20. Tax payable / refundable (17-18)",{"$nulls":7},{"$f":"IF(M144>0,\"(Payble)\",\"Refundable\")","v":"Refundable"},null,null,{"$f":"M142-M143","v":{"v":0,"d":"₹ 0.00"}},null,null,"(viii)",8,{"$f":"VLOOKUP(P144,'Income Tax Cal. Report'!C30:I38,2,0)","v":"Other-2"},{"$f":"VLOOKUP(P144,'Income Tax Cal. Report'!C30:I38,7,0)","v":"(xvii)"},null,1,{"$f":"U144+V143","v":8},8]
[null,"Verification",{"$nulls":13},"(ix)",9,{"$f":"VLOOKUP(P145,'Income Tax Cal. Report'!C31:I39,2,0)","v":"Other-3"},{"$f":"VLOOKUP(P145,'Income Tax Cal. Report'!C31:I39,7,0)","v":"(xviii)"},null,1,{"$f":"U145+V144","v":9},{"$f":"IF(V145>V144,1+V144,0)","v":9}]
[null,"I,",{"$f":"C56","v":"SHARIQUE ASHRAF"},null,null,"Son/Doughter of ",null,{"$f":"H56","v":0},null,null,"  Working In the Capacity Of",{"$nulls":4},"(x)",{"$error":"#N/A"},{"$f":"VLOOKUP(P146,'Income Tax Cal. Report'!J23:Q31,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P146,'Income Tax Cal. Report'!J23:Q31,6,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B57","v":"DPO (Estt.)"},null,null,"(Designation) do hereby certify that the information given  above is true  correct based on the ",{"$nulls":10},"(xi)",{"$error":"#N/A"},{"$f":"VLOOKUP(P147,'Income Tax Cal. Report'!J24:Q32,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P147,'Income Tax Cal. Report'!J24:Q32,6,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"book of accounts, documents and TDS Statements, TDS Deposited and other available records.",{"$nulls":13},"(xii)",{"$error":"#N/A"},{"$f":"VLOOKUP(P148,'Income Tax Cal. Report'!J25:Q33,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P148,'Income Tax Cal. Report'!J25:Q33,6,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":15},"(xiii)",{"$error":"#N/A"},{"$f":"VLOOKUP(P149,'Income Tax Cal. Report'!J26:Q34,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P149,'Income Tax Cal. Report'!J26:Q34,6,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":15},"(xv)",{"$error":"#N/A"},{"$f":"VLOOKUP(P150,'Income Tax Cal. Report'!J27:Q35,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P150,'Income Tax Cal. Report'!J27:Q35,6,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":15},"(xiv)",{"$error":"#N/A"},{"$f":"VLOOKUP(P151,'Income Tax Cal. Report'!J28:Q36,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P151,'Income Tax Cal. Report'!J28:Q36,6,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":15},"(xvi)",{"$error":"#N/A"},{"$f":"VLOOKUP(P152,'Income Tax Cal. Report'!J29:Q37,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P152,'Income Tax Cal. Report'!J29:Q37,6,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":6},"                                    Signature & Seal of the person responsible",{"$nulls":8},"(xvii)",{"$error":"#N/A"},{"$f":"VLOOKUP(P153,'Income Tax Cal. Report'!J30:Q38,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P153,'Income Tax Cal. Report'!J30:Q38,6,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":6},"                                     for deduction of tax",{"$nulls":8},"(xviii)",{"$error":"#N/A"},{"$f":"VLOOKUP(P154,'Income Tax Cal. Report'!J31:Q39,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P154,'Income Tax Cal. Report'!J31:Q39,6,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Place:",{"$f":"'Basic Deta'!E5","v":"District Education Officer, Education Department Primary Education of Bihar"},{"$nulls":3},"                                 ________________________________","                Full Name       :",null,{"$f":"C146","v":"SHARIQUE ASHRAF"}]
[null,"Date:",{"$f":"TODAY()","v":"2023-02-19"},{"$nulls":4},"               Designation    :",null,{"$f":"B147","v":"DPO (Estt.)"}]
[{"$nulls":16},{"$f":"W157","v":0},{"$f":"'Income Tax Cal. Report'!C37","v":"1. धारा 80D - चिकित्सा बीमा प्रीमियम {स्वयं/पति/पत्नी  हेतु 25,000 माता/पिता हेतु 25,000, वरिष्ठ नागरिक 50,000}"},{"$f":"'Income Tax Cal. Report'!S37","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(S157>0,1,0)","v":0},{"$f":"U157","v":0},{"$f":"IF(V157>V156,1,0)","v":0},"U/s 80 D-Medical Premium"]
[{"$nulls":16},{"$f":"W158","v":0},{"$f":"'Income Tax Cal. Report'!C38","v":"2. धारा 80DD - विकलांग आश्रितों का चिकित्सा उपचार (अधिकतम 75,000,  80% या अधिक विक्लांगता 1,25,000)"},{"$f":"'Income Tax Cal. Report'!S38","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(S158>0,1,0)","v":0},{"$f":"U158+V157","v":0},{"$f":"IF(V158>V157,1+V157,0)","v":0},"U/s 80 DD"]
[{"$nulls":16},0,{"$f":"'Income Tax Cal. Report'!C39","v":"3. धारा 80DDB -विशिष्ठ रोगों के उपचार हेतु कटौती (सामान्य 40,000 एवं वरिष्ठ नागरिक 1 लाख)"},{"$f":"'Income Tax Cal. Report'!S39","v":{"v":0,"d":"0.00"}},null,0,{"$f":"U159+V158","v":0},{"$f":"IF(V159>V158,1+V158,0)","v":0},"U/s 80 DDB"]
[{"$nulls":16},0,{"$f":"'Income Tax Cal. Report'!C40","v":"4. धारा 80E - उच्च शिक्षा हेतु लिए ऋण पर ब्याज (धारा 80E)"},{"$f":"'Income Tax Cal. Report'!S40","v":{"v":0,"d":"0.00"}},null,0,{"$f":"U160+V159","v":0},0,"U/s 80 E-Higher Education"]
[{"$nulls":16},0,{"$f":"'Income Tax Cal. Report'!C41","v":"5. धारा 80G -धर्मार्थ संस्थाओं को दिए दान (श्रेणी 'क' 100% एवं श्रेणी 'ख' 50%) "},{"$f":"'Income Tax Cal. Report'!S41","v":{"v":0,"d":"0.00"}},null,0,{"$f":"U161+V160","v":0},0,"U/s 80 G-Donation"]
[{"$nulls":16},0,{"$f":"'Income Tax Cal. Report'!C42","v":"6. धारा 80U -स्थाई शारीरिक विक्लांगता की दशा में (अधिकतम 75,000 तथा अधिनियम 1995 के अनुसार 80% विक्लांगता 1,25,000)"},{"$f":"'Income Tax Cal. Report'!S42","v":{"v":0,"d":"0.00"}},null,0,{"$f":"U162+V161","v":0},0,"U/s 80 U-Permanent Disability"]
[{"$nulls":16},0,{"$f":"'Income Tax Cal. Report'!C43","v":"7. अधिनियम 1995 के अनुसार धारा 80 TTA के तहत बचत खाते की जमा राशी पर प्राप्त ब्याज में छूट 10000 (80 TTB-वरिष्ठ नागरिक अधिकतम 50,000)"},{"$f":"'Income Tax Cal. Report'!S43","v":{"v":0,"d":"0.00"}},null,0,{"$f":"U163+V162","v":0},0,"U/s 80 TTA/80 TTB-Saving Interest"]
[{"$nulls":16},0,{"$f":"'Income Tax Cal. Report'!C44","v":"8. धारा 80 GGA -अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास आदि हेतु दिया गया दान"},{"$f":"'Income Tax Cal. Report'!S44","v":{"v":0,"d":"0.00"}},null,0,0,0,"U/s 80 GGA"]

{"sheet":"OLD REGIME","index":6,"n_rows":69,"n_cols":29,"rows_kept":69,"hidden":true,"merged":[[0,0,69,0],[0,1,0,16],[0,17,69,17],[1,1,1,12],[1,13,1,16],[2,2,2,3],[2,4,2,9],[2,11,2,13],[2,15,2,16],[3,2,3,14],[4,2,4,14],[5,2,5,14],[6,1,8,1],[6,2,6,11],[6,12,6,14],[6,15,7,16],[7,2,7,11],[7,12,7,14],[8,2,8,11],[8,12,8,14],[9,2,9,14],[10,1,12,1],[10,2,10,9],[10,10,10,11],[10,12,10,14],[10,15,12,16],[11,2,12,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[11,12,11,14],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,2,13,14],[14,2,14,14],[15,1,17,1],[15,2,17,2],[15,4,15,14],[16,4,16,14],[17,4,17,14],[18,2,18,14],[19,2,19,14],[20,1,34,1],[20,2,20,16],[21,2,21,16],[22,3,22,6],[22,10,22,12],[22,15,31,16],[23,3,23,6],[23,10,23,12],[24,3,24,6],[24,10,24,12],[25,3,25,6],[25,10,25,12],[26,3,26,6],[26,10,26,12],[27,3,27,6],[27,10,27,12],[28,3,28,6],[28,10,28,12],[29,3,29,6],[29,10,29,12],[30,3,30,6],[30,10,30,12],[31,2,31,12],[32,2,32,14],[33,2,33,14],[34,2,34,14],[35,1,44,1],[35,2,35,16],[36,2,36,14],[37,2,37,14],[38,2,38,14],[39,2,39,14],[40,2,40,14],[41,2,41,14],[42,2,42,14],[43,2,43,14],[44,2,44,14],[45,2,45,14],[46,2,46,14],[47,2,47,14],[48,1,61,1],[48,2,48,16],[49,2,49,6],[49,7,49,10],[49,11,49,14],[50,2,50,4],[50,5,50,6],[50,7,50,9],[50,11,50,13],[51,2,51,4],[51,5,51,6],[51,7,51,9],[51,11,51,13],[52,2,52,4],[52,5,52,6],[52,7,52,9],[52,11,52,13],[53,2,53,4],[53,5,53,6],[53,7,53,9],[53,11,53,13],[54,2,54,4],[54,5,54,6],[54,7,54,9],[54,11,54,13],[55,2,55,4],[55,5,55,6],[55,7,55,9],[55,11,55,13],[56,2,56,4],[56,5,56,6],[56,7,56,9],[56,11,56,13],[57,2,57,14],[58,2,58,14],[59,2,59,14],[60,2,60,14],[61,2,61,14],[62,2,62,14],[63,1,64,1],[63,2,63,14],[64,2,64,14],[65,1,67,1],[65,2,67,2],[65,3,65,4],[65,5,65,7],[65,12,65,13],[65,15,65,16],[66,3,66,4],[66,5,66,7],[66,12,66,13],[67,3,67,10],[67,11,67,14],[68,1,69,9],[68,10,69,16]]}
[null,{"$f":"'Exemp.(HRA+Other) & Other incom'!A1","v":"District Education Officer, Education Department Primary Education of Bihar"}]
[null,"Income Tax Calculation F.Y. 2022-22 (A.Y.2023-24)",{"$nulls":11},"Old Tax Regime"]
[null,1,"कर्मचारी का नाम :-",null,{"$f":"'Table (Income-Deduction)'!F4","v":"SHAHID ALI"},{"$nulls":5},"पद :-",{"$f":"'Table (Income-Deduction)'!P4","v":"Block Teacher"},null,null,"PAN :",{"$f":"'Table (Income-Deduction)'!F6","v":"BFHPA0762G (BUXAR)"}]
[null,2,"आय:वर्ष 2022-23 में कुल प्राप्त वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"Rs.",{"$f":"'Table (Income-Deduction)'!O32","v":{"v":499964,"d":"499964.00"}}]
[null,3,"गृह किराया धारा 10 (13-A) के अंतर्गत एवं 10(14) के अंतर्गत वेतन भत्ते जो कर मुक्त है l",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!K4,0)","v":{"v":13822,"d":"13822.00"}}]
[null,4,"                                                             शेष (2-3)",{"$nulls":12},"Rs.",{"$f":"Q4-Q5","v":{"v":486142,"d":"486142.00"}}]
[null,5,"(i)  मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L13","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)  व्यवसाय कर धारा 16 (iii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L14","v":{"v":1000,"d":"1000.00"}}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction)-अधिकतम 50,000",{"$nulls":9},{"v":50000,"d":"50000.00"},null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",M7+M8+M9,0)","v":{"v":51000,"d":"51000.00"}}]
[null,6,"                                                             शेष (4-5)",{"$nulls":12},"Rs.",{"$f":"Q6-Q9","v":{"v":435142,"d":"435142.00"}}]
[null,7,"(अ) गृह सम्पति से आय (1) स्वयं के उपयोग में शून्य ",{"$nulls":7},"(2) प्राप्त किराया ",null,{"$f":"'Exemp.(HRA+Other) & Other incom'!L7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटाइए",null,"किराये का 30%",null,null,"गृह ऋण पर ब्याज",null,null,"गृहकर",null,"योग 7 (ब)"]
[{"$nulls":4},{"$f":"IF(N2=\"old tax regime\",ROUND(M11*0.3,0),0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L17,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L15,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"E13+H13+K13","v":{"v":0,"d":"0.00"}}]
[null,null,"                                                     शेष -/+  {7(अ) एवं योग 7(ब)} ",{"$nulls":12},"Rs.",{"$f":"M11-M13","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                             कुल शेष -/+ (6 एवं 7)",{"$nulls":12},"Rs.",{"$f":"Q10+Q14","v":{"v":435142,"d":"435142.00"}}]
[null,9,"अन्य आय","9(i)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B8","v":"अन्य आय (बैंक/एफडी में जमा ब्याज/अन्य ब्याज आदि का योग"},{"$nulls":10},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!L8","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(ii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C9","v":"(-----------------------------------------------------)"},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!L9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(iii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C10","v":"(-----------------------------------------------------)"},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!L10","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल (बिंदु संख्या -9)",{"$nulls":13},{"$f":"Q16+Q17+Q18","v":{"v":0,"d":"0.00"}}]
[null,10,"सकल आय                                                                                                                                       योग (8+9)",{"$nulls":12},"Rs.",{"$f":"Q15+Q19","v":{"v":435142,"d":"435142.00"}}]
[null,11,"घटाइए कटौतियां :- धारा  US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1.50 लाख (धारा 80 CCE) के अलावा "]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Table (Income-Deduction)'!Q32,0)","v":{"v":0,"d":"0.00"}},"(x)","पेंशन प्लान हेतु अंशदान (धारा 80CCC)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q15,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)","जीवन बीमा प्रीमियम (LIC)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Table (Income-Deduction)'!T32+'Exemp.(HRA+Other) & Other incom'!L18,0)","v":{"v":0,"d":"0.00"}},"(xi)","राष्ट्रीय बचत पत्र पर अदत ब्याज",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L23,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L22,0)","v":{"v":0,"d":"0.00"}},"(xii)","ट्यूशन फी",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L24,0)","v":{"v":0,"d":"0.00"}},"(xiii)","इक्विटी लिंक सेविंग स्कीम",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q24,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम  (NSS)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L25,0)","v":{"v":0,"d":"0.00"}},"(xv)","स्थिगित वार्षिकी (Defferred Annuty)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q25,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vi)","GPF/GPF 2004",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Table (Income-Deduction)'!P32,0)","v":{"v":21600,"d":"21600.00"}},"(xiv)","पी.एल.आई. (PLI)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","सामूहिक दुर्घटना बीमा (GIS)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Table (Income-Deduction)'!U32,0)","v":{"v":1000,"d":"1000.00"}},"(xvi)","अन्य जमा राशी (80 C धारा के अंतर्गत)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q14,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(viii)","UPLI/वार्षिक प्लान",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L21,0)","v":{"v":0,"d":"0.00"}},"(xvii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L26,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ix)","गृह ऋण किश्त(HBA Premium)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L16,0)","v":{"v":0,"d":"0.00"}},"(xviii)",{"$nulls":3},"Rs."]
[null,null,"योग (i से xvii तक)",{"$nulls":10},"Rs.",{"$f":"SUM(O23:O31,I23:I31)","v":{"v":22600,"d":"22600.00"}}]
[null,null,"                      अधिकतम कटौती की राशि  1.50 लाख रूपये तक",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"new tax regime\",0,IF(O32>=150000,150000,O32))","v":{"v":22600,"d":"22600.00"}}]
[null,null,"(B) घटाइए - धारा 80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु.50,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q16,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"योग 11(A+B+C)      ",{"$nulls":12},"Rs.",{"$f":"Q33+Q34","v":{"v":22600,"d":"22600.00"}}]
[null,12,"अन्य कटौतियां"]
[null,null,"1. धारा 80D - चिकित्सा बीमा प्रीमियम {स्वयं/पति/पत्नी  हेतु 25,000 माता/पिता हेतु 25,000, वरिष्ठ नागरिक 50,000}",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q17,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"2. धारा 80DD - विकलांग आश्रितों का चिकित्सा उपचार (अधिकतम 75,000,  80% या अधिक विक्लांगता 1,25,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q18,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"3. धारा 80DDB -विशिष्ठ रोगों के उपचार हेतु कटौती (सामान्य 40,000 एवं वरिष्ठ नागरिक 1 लाख)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"4. धारा 80E - उच्च शिक्षा हेतु लिए ऋण पर ब्याज (धारा 80E)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"5. धारा 80G -धर्मार्थ संस्थाओं को दिए दान (श्रेणी 'क' 100% एवं श्रेणी 'ख' 50%) ",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q21,0)","v":{"v":0,"d":"0.00"}},{"$nulls":5},">250000",">300000",">500000",">1000000"]
[null,null,"6. धारा 80U -स्थाई शारीरिक विक्लांगता की दशा में (अधिकतम 75,000 तथा अधिनियम 1995 के अनुसार 80% विक्लांगता 1,25,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q22,0)","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,IF($Q$48>250000,4,0))))","v":3},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,0)))","v":3},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,0))","v":0},{"$f":"IF($Q$48>1000000,1,0)","v":0}]
[null,null,"7. अधिनियम 1995 के अनुसार धारा 80 TTA के तहत बचत खाते की जमा राशी पर प्राप्त ब्याज में छूट 10000 (80 TTB-वरिष्ठ नागरिक अधिकतम 50,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q13,0)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"A",{"$f":"IF(W42>=3,ROUND((Q48-250000)*0.05,0),IF(W42=0,0,12500))","v":8127},0,{"$f":"IF($Y$42=2,($Q$48-500000)*0.2,IF($Y$42=1,100000,0))","v":0},{"$f":"IF($Z$42>0,($Q$48-1000000)*0.3,0)","v":0}]
[null,null,"8. धारा 80 GGA -अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q23,0)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"B",{"v":0,"d":"0.00"},{"$f":"IF(X42=3,ROUND((Q48-300000)*0.05,0),IF(X42=0,0,10000))","v":5627},{"$f":"IF($Y$42=2,($Q$48-500000)*0.2,IF($Y$42=1,100000,0))","v":0},{"$f":"IF($Z$42>0,($Q$48-1000000)*0.3,0)","v":0}]
[null,null,"कुल योग 12 (1 से 8)",{"$nulls":12},"Rs.",{"$f":"SUM(Q37:Q44)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"C",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,0]
[null,13,"कुल कटौती (11 एवं 12)",{"$nulls":12},"Rs.",{"$f":"Q35+Q45","v":{"v":22600,"d":"22600.00"}}]
[null,14,"कर योग्य आय (10-13)",{"$nulls":12},"Rs.",{"$f":"Q20-Q46","v":{"v":412542,"d":"412542.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288A",{"$nulls":12},"Rs.",{"$f":"ROUND(Q47,-1)","v":{"v":412540,"d":"412540.00"}},null,null,{"$f":"IF(N2=\"Old tax regime\",\"A\",\"B\")","v":"A"},{"$f":"'Basic Deta'!O10","v":"A"},{"$f":"CONCATENATE(T48,U48)","v":"AA"}]
[null,16,"उपरोक्त बिंदु 15 के आधार पर आयकर की गणना "]
[null,null,"सामान्य करदाता",{"$nulls":4},"वरिष्ठ नागरिक (आयु 60 से 80 वर्ष)",{"$nulls":3},"80 वर्ष या अधिक आयु "]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,000 तक\",\"2,50,000 तक\")","v":"2,50,000 तक"},null,null,"Nil",null,{"$f":"IF($N$2=\"old tax regime\",\"3,00,000 तक\",\"3,00,000 तक\")","v":"3,00,000 तक"},null,null,"Nil",{"$f":"IF($N$2=\"old tax regime\",\"----\",\"3,00,000 तक\")","v":"----"},null,null,{"$f":"IF($N$2=\"Old tax regime\",\"----\",\"Nil\")","v":"----"},"Rs.",{"v":0,"d":"0.00"}]
[null,null,"2,50,001-5,00,000",null,null,{"v":0.05,"d":"5%"},null,"3,00,001-5,00,000",null,null,{"v":0.05,"d":"5%"},{"$f":"IF($N$2=\"old tax regime\",\"5,00,000 तक\",\"3,00,001-5,00,000\")","v":"5,00,000 तक"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"Nil\",\"5%\")","v":"Nil"},"Rs.",{"$f":"IF($V$48=\"AA\",W43,IF($V$48=\"AB\",X44,IF($V$48=\"BA\",W55,IF($V$48=\"BB\",X56,IF($V$48=\"BC\",X57,0)))))","v":{"v":8127,"d":"8127.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"5,00,001-10,00,000\",\"5,00,001-7,50,000\")","v":"5,00,001-10,00,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"20%\",\"10%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"5,00,001-10,00,000\",\"5,00,001-7,50,000\")","v":"5,00,001-10,00,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"20%\",\"10%\")","v":"20%"},{"$f":"IF($N$2=\"old tax regime\",\"5,00,001-10,00,000\",\"5,00,001-7,50,000\")","v":"5,00,001-10,00,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"20%\",\"10%\")","v":"20%"},"Rs.",{"$f":"IF($V$48=\"AA\",Y43,IF($V$48=\"AB\",Y44,IF($V$48=\"AC\",Y45,IF($V$48=\"BA\",Y55,IF($V$48=\"BB\",Y56,IF($V$48=\"BC\",Y57,0))))))","v":{"v":0,"d":"0.00"}},{"$nulls":5},">250000",">300000",">500000",">750000",">1000000",">1250000",">1500000"]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"10,00,000 से अधिक\",\"7,50,001-10,00,000\")","v":"10,00,000 से अधिक"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"30%\",\"15%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"10,00,000 से अधिक\",\"7,50,001-10,00,000\")","v":"10,00,000 से अधिक"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"30%\",\"15%\")","v":"30%"},{"$f":"IF($N$2=\"old tax regime\",\"10,00,000 से अधिक\",\"7,50,001-10,00,000\")","v":"10,00,000 से अधिक"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"30%\",\"15%\")","v":"30%"},"Rs.",{"$f":"IF($V$48=\"AA\",Z43,IF($V$48=\"AB\",Z44,IF($V$48=\"AC\",Z45,IF($V$48=\"BA\",Z55,IF($V$48=\"BB\",Z56,IF($V$48=\"BC\",Z57,0))))))","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,IF($Q$48>1000000,3,IF($Q$48>750000,4,IF($Q$48>500000,5,IF($Q$48>300000,6,IF($Q$48>250000,7,0)))))))","v":6},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,IF($Q$48>1000000,3,IF($Q$48>750000,4,IF($Q$48>500000,5,IF($Q$48>300000,6,0))))))","v":6},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,IF($Q$48>1000000,3,IF($Q$48>750000,4,IF($Q$48>500000,5,0)))))","v":0},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,IF($Q$48>1000000,3,IF($Q$48>750000,4,0))))","v":0},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,IF($Q$48>1000000,3,0)))","v":0},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,0))","v":0},{"$f":"IF($Q$48>1500000,1,0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"10,00,001-12,50,000\")","v":"----"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"20%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"10,00,001-12,50,000\")","v":"----"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"20%\")","v":"----"},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"10,00,001-12,50,000\")","v":"----"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"20%\")","v":"----"},"Rs.",{"$f":"IF($T$48=\"a\",0,AA55)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"A",{"$f":"IF(W54>=6,ROUND(($Q$48-250000)*0.05,0),IF(W54=0,0,12500))","v":8127},0,{"$f":"IF($Y$54=5,($Q$48-500000)*0.1,IF($Y$54<=4,IF($Y$54=0,0,25000)))","v":0},{"$f":"IF($Z$54=4,($Q$48-750000)*0.15,IF($Z$54<=3,IF($Z$54=0,0,37500)))","v":0},{"$f":"IF($AA$54=3,($Q$48-1000000)*0.2,IF($AA$54<=2,IF($AA$54=0,0,50000)))","v":0},{"$f":"IF($AB$54=2,($Q$48-1250000)*0.25,IF($AB$54<=1,IF($AB$54=0,0,62500)))","v":0},{"$f":"IF($AC$54>0,($Q$48-1500000)*0.3,0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"12,50,001-15,00,000\")","v":"----"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"25%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"12,50,001-15,00,000\")","v":"----"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"25%\")","v":"----"},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"12,50,001-15,00,000\")","v":"----"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"25%\")","v":"----"},"Rs.",{"$f":"IF($T$48=\"a\",0,AB55)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"B",0,{"$f":"IF(X54=6,ROUND(($Q$48-300000)*0.05,0),IF(X54=0,0,10000))","v":5627},{"$f":"IF($Y$54=5,($Q$48-500000)*0.1,IF($Y$54<=4,IF($Y$54=0,0,25000)))","v":0},{"$f":"IF($Z$54=4,($Q$48-750000)*0.15,IF($Z$54<=3,IF($Z$54=0,0,37500)))","v":0},{"$f":"IF($AA$54=3,($Q$48-1000000)*0.2,IF($AA$54<=2,IF($AA$54=0,0,50000)))","v":0},{"$f":"IF($AB$54=2,($Q$48-1250000)*0.25,IF($AB$54<=1,IF($AB$54=0,0,62500)))","v":0},{"$f":"IF($AC$54>0,($Q$48-1500000)*0.3,0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,000 से अधिक\")","v":"----"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"30%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,000 से अधिक\")","v":"----"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"30%\")","v":"----"},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,000 से अधिक\")","v":"----"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"30%\")","v":"----"},"Rs.",{"$f":"IF($T$48=\"a\",0,AC55)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"C",0,{"$f":"IF(X54=6,ROUND(($Q$48-300000)*0.05,0),IF(X54=0,0,10000))","v":5627},0,0,0,0,0]
[null,null,"(1) योग आयकर",{"$nulls":12},"Rs.",{"$f":"SUM(Q51:Q57)","v":{"v":8127,"d":"8127.00"}}]
[null,null,"(2) छूट धारा 87 (A) (2.50 लाख से 5.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रूपये 12,500 तक)",{"$nulls":12},"Rs.",{"$f":"IF(Q48<=500000,Q52,0)","v":{"v":8127,"d":"8127.00"}}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},"Rs.",{"$f":"Q58-Q59","v":{"v":0,"d":"0.00"}}]
[null,null,"(4) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q60*0.04,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":12},"Rs.",{"$f":"Q60+Q61","v":{"v":0,"d":"0.00"}}]
[null,17,"घटाइए :- धारा 89 के अंतर्गत राहत Rule 21A(2)",{"$nulls":12},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!Q26","v":{"v":0,"d":"0.00"}}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"Rs.",{"$f":"Q62-Q63","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल शेष आयकर की राशि (दस के गुणक में)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q64,-1)","v":{"v":0,"d":"0.00"}}]
[null,19,"आयकर कटौती का विवरण","Itax deducted Till Jun-2022 (First Quarter)",null,"Itax deducted  July-22 to Sep.-22      (Second Quarter)",null,null,"Itax deducted Oct-22 to Dec.-22 (Third Quarter)","Itax Deducted/Dedctable by Dec.22 Salary","Itax Deducted/Dedctable by Jan-23 Salary","Itax Deducted/Dedctable by Feb-23 Salary","Itax Deducted addition to Salary ",null,"Itax submitted by other means","बिंदु 19 का योग "]
[{"$nulls":3},{"$f":"SUM('Table (Income-Deduction)'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUM('Table (Income-Deduction)'!#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('Table (Income-Deduction)'!#REF!)","v":{"$error":"#REF!"}},{"$f":"'Table (Income-Deduction)'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Table (Income-Deduction)'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Table (Income-Deduction)'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM('Table (Income-Deduction)'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"'Basic Deta'!N19","v":0},"Rs.",{"$f":"SUM(D67:O67)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Income Tax Refundable/Payble",{"$nulls":7},{"$f":"IF(Q67>Q65,\"(Refundable)\",\"(Payble)\")","v":{"$error":"#REF!"}},{"$nulls":3},"Rs.",{"$f":"Q67-Q65","v":{"$error":"#REF!"}}]
[null,{"$f":"'Table (Income-Deduction)'!B33","v":"Siganture of Employee"},{"$nulls":8},{"$f":"'Table (Income-Deduction)'!P33","v":"Signature of DPO ()"}]

{"sheet":"NEW REGIME","index":7,"n_rows":69,"n_cols":40,"rows_kept":69,"hidden":true,"merged":[[0,0,69,0],[0,1,0,16],[0,17,69,17],[1,1,1,12],[1,13,1,16],[2,2,2,3],[2,4,2,9],[2,11,2,13],[2,15,2,16],[3,2,3,14],[4,2,4,14],[5,2,5,14],[6,1,8,1],[6,2,6,11],[6,12,6,14],[6,15,7,16],[7,2,7,11],[7,12,7,14],[8,2,8,11],[8,12,8,14],[9,2,9,14],[10,1,12,1],[10,2,10,9],[10,10,10,11],[10,12,10,14],[10,15,12,16],[11,2,12,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[11,12,11,14],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,2,13,14],[14,2,14,14],[15,1,17,1],[15,2,17,2],[15,4,15,14],[16,4,16,14],[17,4,17,14],[18,2,18,14],[19,2,19,14],[20,1,34,1],[20,2,20,16],[21,2,21,16],[22,3,22,6],[22,10,22,12],[22,15,31,16],[23,3,23,6],[23,10,23,12],[24,3,24,6],[24,10,24,12],[25,3,25,6],[25,10,25,12],[26,3,26,6],[26,10,26,12],[27,3,27,6],[27,10,27,12],[28,3,28,6],[28,10,28,12],[29,3,29,6],[29,10,29,12],[30,3,30,6],[30,10,30,12],[31,2,31,12],[32,2,32,14],[33,2,33,14],[34,2,34,14],[35,1,44,1],[35,2,35,16],[36,2,36,14],[37,2,37,14],[38,2,38,14],[39,2,39,14],[40,2,40,14],[41,2,41,14],[42,2,42,14],[43,2,43,14],[44,2,44,14],[45,2,45,14],[46,2,46,14],[47,2,47,14],[48,1,61,1],[48,2,48,16],[49,2,49,6],[49,7,49,10],[49,11,49,14],[50,2,50,4],[50,5,50,6],[50,7,50,9],[50,11,50,13],[51,2,51,4],[51,5,51,6],[51,7,51,9],[51,11,51,13],[52,2,52,4],[52,5,52,6],[52,7,52,9],[52,11,52,13],[53,2,53,4],[53,5,53,6],[53,7,53,9],[53,11,53,13],[54,2,54,4],[54,5,54,6],[54,7,54,9],[54,11,54,13],[55,2,55,4],[55,5,55,6],[55,7,55,9],[55,11,55,13],[56,2,56,4],[56,5,56,6],[56,7,56,9],[56,11,56,13],[57,2,57,14],[58,2,58,14],[59,2,59,14],[60,2,60,14],[61,2,61,14],[62,2,62,14],[63,1,64,1],[63,2,63,14],[64,2,64,14],[65,1,67,1],[65,2,67,2],[65,3,65,4],[65,5,65,7],[65,12,65,13],[65,15,65,16],[66,3,66,4],[66,5,66,7],[66,12,66,13],[67,3,67,10],[67,11,67,14],[68,1,69,9],[68,10,69,16]]}
[null,{"$f":"'Exemp.(HRA+Other) & Other incom'!A1","v":"District Education Officer, Education Department Primary Education of Bihar"}]
[null,"Income Tax Calculation F.Y. 2022-22 (A.Y.2023-24)",{"$nulls":11},"New Tax Regime"]
[null,1,"कर्मचारी का नाम :-",null,{"$f":"'Table (Income-Deduction)'!F4","v":"SHAHID ALI"},{"$nulls":5},"पद :-",{"$f":"'Table (Income-Deduction)'!P4","v":"Block Teacher"},null,null,"PAN :",{"$f":"'Table (Income-Deduction)'!F6","v":"BFHPA0762G (BUXAR)"}]
[null,2,"आय:वर्ष 2022-23 में कुल प्राप्त वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"Rs.",{"$f":"'Table (Income-Deduction)'!O32","v":{"v":499964,"d":"499964.00"}}]
[null,3,"गृह किराया धारा 10 (13-A) के अंतर्गत एवं 10(14) के अंतर्गत वेतन भत्ते जो कर मुक्त है l",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!K4,0)","v":{"v":0,"d":"0.00"}}]
[null,4,"                                                             शेष (2-3)",{"$nulls":12},"Rs.",{"$f":"Q4-Q5","v":{"v":499964,"d":"499964.00"}}]
[null,5,"(i)  मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L13","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)  व्यवसाय कर धारा 16 (iii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L14","v":{"v":1000,"d":"1000.00"}}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction)-अधिकतम 50,000",{"$nulls":9},{"v":50000,"d":"50000.00"},null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",M7+M8+M9,0)","v":{"v":0,"d":"0.00"}}]
[null,6,"                                                             शेष (4-5)",{"$nulls":12},"Rs.",{"$f":"Q6-Q9","v":{"v":499964,"d":"499964.00"}}]
[null,7,"(अ) गृह सम्पति से आय (1) स्वयं के उपयोग में शून्य ",{"$nulls":7},"(2) प्राप्त किराया ",null,{"$f":"'Exemp.(HRA+Other) & Other incom'!L7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटाइए",null,"किराये का 30%",null,null,"गृह ऋण पर ब्याज",null,null,"गृहकर",null,"योग 7 (ब)"]
[{"$nulls":4},{"$f":"IF(N2=\"old tax regime\",ROUND(M11*0.3,0),0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L17,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L15,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"E13+H13+K13","v":{"v":0,"d":"0.00"}}]
[null,null,"                                                     शेष -/+  {7(अ) एवं योग 7(ब)} ",{"$nulls":12},"Rs.",{"$f":"M11-M13","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                             कुल शेष -/+ (6 एवं 7)",{"$nulls":12},"Rs.",{"$f":"Q10+Q14","v":{"v":499964,"d":"499964.00"}}]
[null,9,"अन्य आय","9(i)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B8","v":"अन्य आय (बैंक/एफडी में जमा ब्याज/अन्य ब्याज आदि का योग"},{"$nulls":10},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!L8","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(ii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C9","v":"(-----------------------------------------------------)"},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!L9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(iii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C10","v":"(-----------------------------------------------------)"},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!L10","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल (बिंदु संख्या -9)",{"$nulls":13},{"$f":"Q16+Q17+Q18","v":{"v":0,"d":"0.00"}}]
[null,10,"सकल आय                                                                                                                                       योग (8+9)",{"$nulls":12},"Rs.",{"$f":"Q15+Q19","v":{"v":499964,"d":"499964.00"}}]
[null,11,"घटाइए कटौतियां :- धारा  US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1.50 लाख (धारा 80 CCE) के अलावा "]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Table (Income-Deduction)'!Q32,0)","v":{"v":0,"d":"0.00"}},"(x)","पेंशन प्लान हेतु अंशदान (धारा 80CCC)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q15,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)","जीवन बीमा प्रीमियम (LIC)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Table (Income-Deduction)'!T32+'Exemp.(HRA+Other) & Other incom'!L18,0)","v":{"v":0,"d":"0.00"}},"(xi)","राष्ट्रीय बचत पत्र पर अदत ब्याज",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L23,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L22,0)","v":{"v":0,"d":"0.00"}},"(xii)","ट्यूशन फी",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L24,0)","v":{"v":0,"d":"0.00"}},"(xiii)","इक्विटी लिंक सेविंग स्कीम",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q24,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम  (NSS)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L25,0)","v":{"v":0,"d":"0.00"}},"(xv)","स्थिगित वार्षिकी (Defferred Annuty)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q25,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vi)","GPF/GPF 2004",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Table (Income-Deduction)'!P32,0)","v":{"v":0,"d":"0.00"}},"(xiv)","पी.एल.आई. (PLI)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","सामूहिक दुर्घटना बीमा (GIS)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Table (Income-Deduction)'!U32,0)","v":{"v":0,"d":"0.00"}},"(xvi)","अन्य जमा राशी (80 C धारा के अंतर्गत)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q14,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(viii)","UPLI/वार्षिक प्लान",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L21,0)","v":{"v":0,"d":"0.00"}},"(xvii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L26,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ix)","गृह ऋण किश्त(HBA Premium)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L16,0)","v":{"v":0,"d":"0.00"}},"(xviii)",{"$nulls":3},"Rs."]
[null,null,"योग (i से xvii तक)",{"$nulls":10},"Rs.",{"$f":"SUM(O23:O31,I23:I31)","v":{"v":0,"d":"0.00"}}]
[null,null,"                      अधिकतम कटौती की राशि  1.50 लाख रूपये तक",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"new tax regime\",0,IF(O32>=150000,150000,O32))","v":{"v":0,"d":"0.00"}}]
[null,null,"(B) घटाइए - धारा 80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु.50,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q16,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"योग 11(A+B+C)      ",{"$nulls":12},"Rs.",{"$f":"Q33+Q34","v":{"v":0,"d":"0.00"}}]
[null,12,"अन्य कटौतियां"]
[null,null,"1. धारा 80D - चिकित्सा बीमा प्रीमियम {स्वयं/पति/पत्नी  हेतु 25,000 माता/पिता हेतु 25,000, वरिष्ठ नागरिक 50,000}",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q17,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"2. धारा 80DD - विकलांग आश्रितों का चिकित्सा उपचार (अधिकतम 75,000,  80% या अधिक विक्लांगता 1,25,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q18,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"3. धारा 80DDB -विशिष्ठ रोगों के उपचार हेतु कटौती (सामान्य 40,000 एवं वरिष्ठ नागरिक 1 लाख)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"4. धारा 80E - उच्च शिक्षा हेतु लिए ऋण पर ब्याज (धारा 80E)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"5. धारा 80G -धर्मार्थ संस्थाओं को दिए दान (श्रेणी 'क' 100% एवं श्रेणी 'ख' 50%) ",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q21,0)","v":{"v":0,"d":"0.00"}},{"$nulls":5},">250000",">300000",">500000",">1000000"]
[null,null,"6. धारा 80U -स्थाई शारीरिक विक्लांगता की दशा में (अधिकतम 75,000 तथा अधिनियम 1995 के अनुसार 80% विक्लांगता 1,25,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q22,0)","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,IF($Q$48>250000,4,0))))","v":3},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,0)))","v":3},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,0))","v":0},{"$f":"IF($Q$48>1000000,1,0)","v":0}]
[null,null,"7. अधिनियम 1995 के अनुसार धारा 80 TTA के तहत बचत खाते की जमा राशी पर प्राप्त ब्याज में छूट 10000 (80 TTB-वरिष्ठ नागरिक अधिकतम 50,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q13,0)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"A",{"$f":"IF(W42>=3,ROUND((Q48-250000)*0.05,0),IF(W42=0,0,12500))","v":12498},0,{"$f":"IF($Y$42=2,($Q$48-500000)*0.2,IF($Y$42=1,100000,0))","v":0},{"$f":"IF($Z$42>0,($Q$48-1000000)*0.3,0)","v":0}]
[null,null,"8. धारा 80 GGA -अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q23,0)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"B",{"v":0,"d":"0.00"},{"$f":"IF(X42=3,ROUND((Q48-300000)*0.05,0),IF(X42=0,0,10000))","v":9998},{"$f":"IF($Y$42=2,($Q$48-500000)*0.2,IF($Y$42=1,100000,0))","v":0},{"$f":"IF($Z$42>0,($Q$48-1000000)*0.3,0)","v":0}]
[null,null,"कुल योग 12 (1 से 8)",{"$nulls":12},"Rs.",{"$f":"SUM(Q37:Q44)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"C",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,0]
[null,13,"कुल कटौती (11 एवं 12)",{"$nulls":12},"Rs.",{"$f":"Q35+Q45","v":{"v":0,"d":"0.00"}}]
[null,14,"कर योग्य आय (10-13)",{"$nulls":12},"Rs.",{"$f":"Q20-Q46","v":{"v":499964,"d":"499964.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288A",{"$nulls":12},"Rs.",{"$f":"ROUND(Q47,-1)","v":{"v":499960,"d":"499960.00"}},null,null,{"$f":"IF(N2=\"Old tax regime\",\"A\",\"B\")","v":"B"},{"$f":"'Basic Deta'!O10","v":"A"},{"$f":"CONCATENATE(T48,U48)","v":"BA"}]
[null,16,"उपरोक्त बिंदु 15 के आधार पर आयकर की गणना "]
[null,null,"सामान्य करदाता",{"$nulls":4},"वरिष्ठ नागरिक (आयु 60 से 80 वर्ष)",{"$nulls":3},"80 वर्ष या अधिक आयु "]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,000 तक\",\"2,50,000 तक\")","v":"2,50,000 तक"},null,null,"Nil",null,{"$f":"IF($N$2=\"old tax regime\",\"3,00,000 तक\",\"3,00,000 तक\")","v":"3,00,000 तक"},null,null,"Nil",{"$f":"IF($N$2=\"old tax regime\",\"----\",\"3,00,000 तक\")","v":"3,00,000 तक"},null,null,{"$f":"IF($N$2=\"Old tax regime\",\"----\",\"Nil\")","v":"Nil"},"Rs.",{"v":0,"d":"0.00"}]
[null,null,"2,50,001-5,00,000",null,null,{"v":0.05,"d":"5%"},null,"3,00,001-5,00,000",null,null,{"v":0.05,"d":"5%"},{"$f":"IF($N$2=\"old tax regime\",\"5,00,000 तक\",\"3,00,001-5,00,000\")","v":"3,00,001-5,00,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"Nil\",\"5%\")","v":"5%"},"Rs.",{"$f":"IF($V$48=\"AA\",W43,IF($V$48=\"AB\",X44,IF($V$48=\"BA\",AH55,IF($V$48=\"BB\",AI56,IF($V$48=\"BC\",AI57,0)))))","v":{"v":12498,"d":"12498.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"5,00,001-10,00,000\",\"5,00,001-7,50,000\")","v":"5,00,001-7,50,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"20%\",\"10%\")","v":"10%"},null,{"$f":"IF($N$2=\"old tax regime\",\"5,00,001-10,00,000\",\"5,00,001-7,50,000\")","v":"5,00,001-7,50,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"20%\",\"10%\")","v":"10%"},{"$f":"IF($N$2=\"old tax regime\",\"5,00,001-10,00,000\",\"5,00,001-7,50,000\")","v":"5,00,001-7,50,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"20%\",\"10%\")","v":"10%"},"Rs.",{"$f":"IF($V$48=\"AA\",Y43,IF($V$48=\"AB\",Y44,IF($V$48=\"AC\",Y45,IF($V$48=\"BA\",AJ55,IF($V$48=\"BB\",AJ56,IF($V$48=\"BC\",AJ57,0))))))","v":{"v":0,"d":"0.00"}},{"$nulls":16},">250000",">300000",">500000",">750000",">1000000",">1250000",">1500000"]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"10,00,000 से अधिक\",\"7,50,001-10,00,000\")","v":"7,50,001-10,00,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"30%\",\"15%\")","v":"15%"},null,{"$f":"IF($N$2=\"old tax regime\",\"10,00,000 से अधिक\",\"7,50,001-10,00,000\")","v":"7,50,001-10,00,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"30%\",\"15%\")","v":"15%"},{"$f":"IF($N$2=\"old tax regime\",\"10,00,000 से अधिक\",\"7,50,001-10,00,000\")","v":"7,50,001-10,00,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"30%\",\"15%\")","v":"15%"},"Rs.",{"$f":"IF($V$48=\"AA\",Z43,IF($V$48=\"AB\",Z44,IF($V$48=\"AC\",Z45,IF($V$48=\"BA\",AK55,IF($V$48=\"BB\",AK56,IF($V$48=\"BC\",AK57,0))))))","v":{"v":0,"d":"0.00"}},{"$nulls":16},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,IF($Q$48>1000000,3,IF($Q$48>750000,4,IF($Q$48>500000,5,IF($Q$48>300000,6,IF($Q$48>250000,7,0)))))))","v":6},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,IF($Q$48>1000000,3,IF($Q$48>750000,4,IF($Q$48>500000,5,IF($Q$48>300000,6,0))))))","v":6},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,IF($Q$48>1000000,3,IF($Q$48>750000,4,IF($Q$48>500000,5,0)))))","v":0},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,IF($Q$48>1000000,3,IF($Q$48>750000,4,0))))","v":0},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,IF($Q$48>1000000,3,0)))","v":0},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1250000,2,0))","v":0},{"$f":"IF($Q$48>1500000,1,0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"10,00,001-12,50,000\")","v":"10,00,001-12,50,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"20%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"10,00,001-12,50,000\")","v":"10,00,001-12,50,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"20%\")","v":"20%"},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"10,00,001-12,50,000\")","v":"10,00,001-12,50,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"20%\")","v":"20%"},"Rs.",{"$f":"IF($T$48=\"a\",0,AL55)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"A",{"$f":"IF(AH54>=6,ROUND(($Q$48-250000)*0.05,0),IF(AH54=0,0,12500))","v":12498},0,{"$f":"IF($AJ$54=5,ROUND(($Q$48-500000)*0.1,0),IF($AJ$54<=4,IF($AJ$54=0,0,25000)))","v":0},{"$f":"IF($AK$54=4,ROUND(($Q$48-750000)*0.15,0),IF($AK$54<=3,IF($AK$54=0,0,37500)))","v":0},{"$f":"IF($AL$54=3,ROUND(($Q$48-1000000)*0.2,0),IF($AL$54<=2,IF($AL$54=0,0,50000)))","v":0},{"$f":"IF($AM$54=2,ROUND(($Q$48-1250000)*0.25,0),IF($AM$54<=1,IF($AM$54=0,0,62500)))","v":0},{"$f":"IF($AN$54>0,ROUND(($Q$48-1500000)*0.3,0),0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"12,50,001-15,00,000\")","v":"12,50,001-15,00,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"25%\")","v":"25%"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"12,50,001-15,00,000\")","v":"12,50,001-15,00,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"25%\")","v":"25%"},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"12,50,001-15,00,000\")","v":"12,50,001-15,00,000"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"25%\")","v":"25%"},"Rs.",{"$f":"IF($T$48=\"a\",0,AM55)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"B",0,{"$f":"IF(AI54=6,ROUND(($Q$48-300000)*0.05,0),IF(AI54=0,0,10000))","v":9998},{"$f":"IF($AJ$54=5,ROUND(($Q$48-500000)*0.1,0),IF($AJ$54<=4,IF($AJ$54=0,0,25000)))","v":0},{"$f":"IF($AK$54=4,ROUND(($Q$48-750000)*0.15,0),IF($AK$54<=3,IF($AK$54=0,0,37500)))","v":0},{"$f":"IF($AL$54=3,ROUND(($Q$48-1000000)*0.2,0),IF($AL$54<=2,IF($AL$54=0,0,50000)))","v":0},{"$f":"IF($AM$54=2,ROUND(($Q$48-1250000)*0.25,0),IF($AM$54<=1,IF($AM$54=0,0,62500)))","v":0},{"$f":"IF($AN$54>0,ROUND(($Q$48-1500000)*0.3,0),0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,000 से अधिक\")","v":"15,00,000 से अधिक"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"30%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,000 से अधिक\")","v":"15,00,000 से अधिक"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"30%\")","v":"30%"},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,000 से अधिक\")","v":"15,00,000 से अधिक"},null,null,{"$f":"IF(N2=\"Old tax regime\",\"----\",\"30%\")","v":"30%"},"Rs.",{"$f":"IF($T$48=\"a\",0,AN55)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"C",0,{"$f":"IF(AI54=6,ROUND(($Q$48-300000)*0.05,0),IF(AI54=0,0,10000))","v":9998},{"$f":"IF($AJ$54=5,ROUND(($Q$48-500000)*0.1,0),IF($AJ$54<=4,IF($AJ$54=0,0,25000)))","v":0},{"$f":"IF($AK$54=4,ROUND(($Q$48-750000)*0.15,0),IF($AK$54<=3,IF($AK$54=0,0,37500)))","v":0},{"$f":"IF($AL$54=3,ROUND(($Q$48-1000000)*0.2,0),IF($AL$54<=2,IF($AL$54=0,0,50000)))","v":0},{"$f":"IF($AM$54=2,ROUND(($Q$48-1250000)*0.25,0),IF($AM$54<=1,IF($AM$54=0,0,62500)))","v":0},{"$f":"IF($AN$54>0,ROUND(($Q$48-1500000)*0.3,0),0)","v":0}]
[null,null,"(1) योग आयकर",{"$nulls":12},"Rs.",{"$f":"SUM(Q51:Q57)","v":{"v":12498,"d":"12498.00"}}]
[null,null,"(2) छूट धारा 87 (A) (2.50 लाख से 5.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रूपये 12,500 तक)",{"$nulls":12},"Rs.",{"$f":"IF(Q48<=500000,Q52,0)","v":{"v":12498,"d":"12498.00"}}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},"Rs.",{"$f":"Q58-Q59","v":{"v":0,"d":"0.00"}}]
[null,null,"(4) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q60*0.04,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":12},"Rs.",{"$f":"Q60+Q61","v":{"v":0,"d":"0.00"}}]
[null,17,"घटाइए :- धारा 89 के अंतर्गत राहत Rule 21A(2)",{"$nulls":12},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!Q26","v":{"v":0,"d":"0.00"}}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"Rs.",{"$f":"Q62-Q63","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल शेष आयकर की राशि (दस के गुणक में)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q64,-1)","v":{"v":0,"d":"0.00"}}]
[null,19,"आयकर कटौती का विवरण","Itax deducted Till Jun-2022 (First Quarter)",null,"Itax deducted  July-22 to Sep.-22      (Second Quarter)",null,null,"Itax deducted Oct-22 to Dec.-22 (Third Quarter)","Itax Deducted/Dedctable by Dec.22 Salary","Itax Deducted/Dedctable by Jan-23 Salary","Itax Deducted/Dedctable by Feb-23 Salary","Itax Deducted addition to Salary ",null,"Itax submitted by other means","बिंदु 19 का योग "]
[{"$nulls":3},{"$f":"SUM('Table (Income-Deduction)'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUM('Table (Income-Deduction)'!#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('Table (Income-Deduction)'!#REF!)","v":{"$error":"#REF!"}},{"$f":"'Table (Income-Deduction)'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Table (Income-Deduction)'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Table (Income-Deduction)'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM('Table (Income-Deduction)'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"'Basic Deta'!N19","v":0},"Rs.",{"$f":"SUM(D67:O67)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Income Tax Refundable/Payble",{"$nulls":7},{"$f":"IF(Q67>Q65,\"(Refundable)\",\"(Payble)\")","v":{"$error":"#REF!"}},{"$nulls":3},"Rs.",{"$f":"Q67-Q65","v":{"$error":"#REF!"}}]
[null,{"$f":"'Table (Income-Deduction)'!B33","v":"Siganture of Employee"},{"$nulls":8},{"$f":"'Table (Income-Deduction)'!P33","v":"Signature of DPO ()"}]

{"sheet":"10 E Us 89(1) ","index":8,"n_rows":46,"n_cols":58,"rows_kept":46,"merged":[[0,6,0,38],[0,39,45,40],[0,41,2,43],[0,50,45,50],[0,51,0,57],[1,0,7,0],[1,1,1,2],[1,3,1,4],[1,6,1,38],[1,51,1,57],[2,1,2,2],[2,3,2,4],[2,6,2,38],[2,51,2,57],[3,1,3,2],[3,3,3,4],[3,6,10,6],[3,7,10,7],[3,8,10,8],[3,9,10,9],[3,10,10,10],[3,11,10,11],[3,12,10,12],[3,13,10,13],[3,14,10,14],[3,15,10,15],[3,16,10,16],[3,17,10,17],[3,18,10,18],[3,19,10,19],[3,20,10,20],[3,21,10,21],[3,22,10,22],[3,23,10,23],[3,24,10,24],[3,25,10,25],[3,26,10,26],[3,27,10,27],[3,28,10,28],[3,29,10,29],[3,30,10,30],[3,31,10,31],[3,32,10,32],[3,33,10,33],[3,36,10,36],[3,37,10,37],[3,38,10,38],[3,41,3,43],[3,51,4,57],[4,1,4,2],[4,3,4,4],[4,41,4,43],[5,1,5,2],[5,41,5,43],[5,51,5,57],[6,1,6,2],[6,43,8,43],[6,46,8,46],[6,49,8,49],[6,51,7,55],[6,56,7,57],[7,1,7,2],[8,0,17,0],[8,1,8,2],[8,51,9,55],[8,56,9,57],[9,1,9,2],[9,43,10,43],[10,1,10,3],[10,51,10,55],[10,56,10,57],[11,43,12,43],[11,51,11,57],[12,51,12,57],[13,43,15,43],[13,46,15,46],[13,49,15,49],[13,51,13,56],[14,51,29,51],[14,52,16,52],[14,53,16,56],[14,57,16,57],[16,43,17,43],[17,52,20,52],[17,53,20,56],[17,57,20,57],[18,43,20,43],[21,43,23,43],[21,52,26,52],[21,53,26,56],[21,57,26,57],[22,6,45,38],[27,41,45,43],[27,52,29,52],[27,53,29,56],[27,57,29,57],[30,51,31,51],[30,52,31,52],[30,53,31,56],[30,57,31,57],[32,51,34,57],[35,56,35,57],[36,51,37,57],[39,53,39,54],[39,55,39,57],[40,52,43,57],[44,52,44,53],[44,54,44,55],[44,56,45,57],[45,52,45,53],[45,54,45,55]]}
[]
[" धारा 89 के अंतर्गत राहत         ↆ","1. If adopted for new tax regime in FY 2022-23 (Yes or No)",null,{"$f":"IF('Income Tax Cal. Report'!Z16=\"Old tax regime\",\"No\",\"Yes\")","v":"No"},null,null,"TABLE -A",{"$nulls":44},"FORM 10E"]
[null,"2. Relief Claimed in the  Assessment Year ",null,"2023-24",null,null,"[See Item 7 of Annexure-I]",{"$nulls":44},"[See Rule 21AA]"]
[null,"3. Name of the Employee",null,{"$f":"'Form-16'!H10","v":"SHAHID ALI  (Block Teacher)"},null,null,"Previous Year(s)","Total income of the relevent previous year","500000>250000","1000000<>500000",">1000000","750000<500000","1000000<750000","1250000<>1000000","1500000<>1250001",">1500000","Tax (Old)","Tax (New)","Itax+Cess (OLD)","Itax+Cess (NEW)","Salary received in arrears or advance relating to the relevant previous year as mentioned in column (1)","Total income (as increased by salary received in arrears or advance) of the relevant previous year as mentioned in column (1)[Add columns (2) and (3)]","500000>250000","1000000<>500000",">1000000","750000<500000","1000000<750000","1250000<>1000000","1500000<>1250001",">1500000","Tax (Old)","Tax (New)","Itax+Cess (OLD)","Itax+Cess (NEW)",null,null,"Tax on total income as per column (2)","Tax on total income as per column (4)","Difference in tax [Amount under column (6) minus amount under column (5)]",null,null,"ANNEXURE-I",{"$nulls":9},"Form  for  furnishing  particulars  of  income  under  section  192(2A)  for  the year ending 31st March, 2023 claiming relief under section 89(1) by a Government servant or an employee in a [company,co-operative society, local authority ,university, institution, association or body]"]
[null,"3. Address of the Employee",null,{"$f":"'Exemp.(HRA+Other) & Other incom'!D4","v":"M.S. BASUDHAR"},{"$nulls":37},"[See item 2 of Form No, 10E]"]
[null,"5. PAN of the Employee",null,null,{"$f":"'Basic Deta'!L10","v":"BFHPA0762G"},{"$nulls":36},"ARREARS OR ADVANCE SALARY"]
[null,"6. Date of Birth (dd/mm/yyyy)",{"$nulls":39},1,"Total Income",{"$f":"AR12-AR10","v":{"v":413540,"d":"413,540"}},{"$f":"IF(AR7>500000,250000,IF(AR7>250000,AR7-250000,0))","v":{"v":163540,"d":"163,540"}},{"$f":"IF(AS7>=250000,ROUND(AS7*0.05,0),0)","v":0},{"$f":"ROUND(SUM(AT7:AT9)*1.04,0)","v":0},{"$f":"IF(AR7>500000,250000,IF(AR7>250000,AR7-250000,0))","v":{"v":163540,"d":"163,540"}},{"$f":"IF(AV7>=250000,ROUND(AV7*0.05,0),0)","v":0},{"$f":"ROUND(SUM(AW7:AW12)*1.04,0)","v":0},null,"1. Name and address of the Employee",{"$nulls":4},{"$f":"CONCATENATE('Form-16'!H10,\"-\",'Form-16'!H12)","v":"SHAHID ALI  (Block Teacher)-Posting Place Name:-M.S. BASUDHAR"}]
[null,"7. Gander",null,null,"Male",{"$nulls":37},"(Excluding salary received in arrears or advance)",null,{"$f":"IF(AR7>1000000,500000,IF(AR7>500000,AR7-500000,0))","v":0},{"$f":"ROUND(AS8*0.2,0)","v":0},null,{"$f":"IF(AR7>750000,250000,IF(AR7>500000,AR7-500000,0))","v":0},{"$f":"ROUND(AV8*0.1,0)","v":0}]
[{"$f":"AR26","v":{"v":0,"d":"₹ 0.00"}},"8. Residential Status (Assumed to be Resident)",null,null,"Resident",{"$nulls":39},{"$f":"IF(AR7>1000000,AR7-1000000,0)","v":0},{"$f":"ROUND(AS9*0.3,0)","v":0},null,{"$f":"IF(AR7>1000000,250000,IF(AR7>750000,AR7-750000,0))","v":0},{"$f":"ROUND(AV9*0.15,0)","v":0},null,null,"2. Permanent Account Number",{"$nulls":4},{"$f":"'Form-16'!H15","v":"BFHPA0762G"}]
[null,"9. Total Taxable Income including Arrear Received in FY 2022-23",null,null,{"$f":"'Income Tax Cal. Report'!S48","v":{"v":413540,"d":"413,540"}},{"$nulls":36},2,"Salary received in arrear or advance",{"$f":"U22","v":0},{"$nulls":3},{"$f":"IF(AR7>1250000,250000,IF(AR7>1000000,AR7-1000000,0))","v":0},{"$f":"ROUND(AV10*0.2,0)","v":0}]
[null,"10. Year-wise Breakup of Arrears received and taxable income ",{"$nulls":45},{"$f":"IF(AR7>1500000,250000,IF(AR7>1250000,AR7-1250000,0))","v":0},{"$f":"ROUND(AV11*0.25,0)","v":0},null,null,"3. Residential Status"]
[null,"Financial Year","Taxable Income of the relevant F.Y. without the arrears or advance (Rs.)","Amount of Arrears/Advance  received against each Financial Year (Rs.)",null,null,1,2,{"$nulls":12},3,"4 [2+3]",{"$nulls":14},5,6,7,null,null,3,"Total Income",{"$f":"E10","v":{"v":413540,"d":"413,540"}},{"$nulls":3},{"$f":"IF(AR7>1500000,AR7-1500000,0)","v":0},{"$f":"ROUND(AV12*0.3,0)","v":0},null,null,"Particulars of Income referred to in rule 21A of the Income Tax Rules, 1962 during the previous year relevant to the"]
[null,"2021-22",{"$nulls":4},{"$f":"B13","v":"2021-22"},{"$f":"C13","v":0},{"$f":"IF(H13>500000,250000,IF(H13>250000,H13-250000,0))","v":0},{"$f":"IF(H13>1000000,500000,IF(H13>500000,H13-500000,0))","v":0},{"$f":"IF(H13>1000000,H13-1000000,0)","v":0},{"$f":"IF(H13>750000,250000,IF(H13>500000,H13-500000,0))","v":0},{"$f":"IF(H13>1000000,250000,IF(H13>750000,H13-750000,0))","v":0},{"$f":"IF(H13>1250000,250000,IF(H13>1000000,H13-1000000,0))","v":0},{"$f":"IF(H13>1500000,250000,IF(H13>1250000,H13-1500000,0))","v":0},{"$f":"IF(H13>1500000,H13-1500000,0)","v":0},{"$f":"ROUND(I13*0.05,0)+ROUND(J13*0.2,0)+ROUND(K13*0.3,0)","v":0},{"$f":"ROUND(I13*0.05,0)+ROUND(L13*0.1,0)+ROUND(M13*0.15,0)+ROUND(N13*0.2,0)+ROUND(O13*0.25,0)+ROUND(P13*0.3,0)","v":0},{"$f":"ROUND(Q13*1.04,-1)","v":0},{"$f":"ROUND(R13*1.04,-1)","v":0},{"$f":"D13","v":0},{"$f":"H13+U13","v":0},{"$f":"IF(V13>500000,250000,IF(V13>250000,V13-250000,0))","v":0},{"$f":"IF(V13>1000000,500000,IF(V13>500000,V13-500000,0))","v":0},{"$f":"IF(V13>1000000,V13-1000000,0)","v":0},{"$f":"IF(V13>750000,250000,IF(V13>500000,V13-500000,0))","v":0},{"$f":"IF(V13>1000000,250000,IF(V13>750000,V13-750000,0))","v":0},{"$f":"IF(V13>1250000,250000,IF(V13>1000000,V13-1000000,0))","v":0},{"$f":"IF(V13>1500000,250000,IF(V13>1250000,V13-1500000,0))","v":0},{"$f":"IF(V13>1500000,V13-1500000,0)","v":0},{"$f":"ROUND(W13*0.05,0)+ROUND(X13*0.2,0)+ROUND(Y13*0.3,0)","v":0},{"$f":"ROUND(W13*0.05,0)+ROUND(Z13*0.1,0)+ROUND(AA13*0.15,0)+ROUND(AB13*0.2,0)+ROUND(AC13*0.25,0)+ROUND(AD13*0.3,0)","v":0},{"$f":"ROUND(AE13*1.04,-1)","v":0},{"$f":"ROUND(AF13*1.04,-1)","v":0},{"$f":"IF($D$2=\"NO\",S13,T13)","v":0},{"$f":"IF($D$2=\"NO\",AG13,AH13)","v":0},{"$f":"IF(AI13<=12500,0,AI13)","v":0},{"$f":"IF(AK13<=12500,0,AJ13)","v":0},{"$f":"AL13-AK13","v":0},{"$nulls":3},"(As increased by salary received in arrears or advance)",{"$nulls":8},"Assessment Year : 2023-24"]
[null,"2020-21",{"$nulls":4},"2020-21",0,{"$f":"IF(H14>500000,250000,IF(H14>250000,H14-250000,0))","v":0},{"$f":"IF(H14>1000000,500000,IF(H14>500000,H14-500000,0))","v":0},0,{"$f":"IF(H14>750000,250000,IF(H14>500000,H14-500000,0))","v":0},{"$f":"IF(H14>1000000,250000,IF(H14>750000,H14-750000,0))","v":0},{"$f":"IF(H14>1250000,250000,IF(H14>1000000,H14-1000000,0))","v":0},{"$f":"IF(H14>1500000,250000,IF(H14>1250000,H14-1500000,0))","v":0},{"$f":"IF(H14>1500000,H14-1500000,0)","v":0},0,{"$f":"ROUND(I14*0.05,0)+ROUND(L14*0.1,0)+ROUND(M14*0.15,0)+ROUND(N14*0.2,0)+ROUND(O14*0.25,0)+ROUND(P14*0.3,0)","v":0},{"$f":"ROUND(Q14*1.04,-1)","v":0},{"$f":"ROUND(R14*1.04,-1)","v":0},{"$f":"D14","v":0},0,{"$f":"IF(V14>500000,250000,IF(V14>250000,V14-250000,0))","v":0},{"$f":"IF(V14>1000000,500000,IF(V14>500000,V14-500000,0))","v":0},0,{"$f":"IF(V14>750000,250000,IF(V14>500000,V14-500000,0))","v":0},{"$f":"IF(V14>1000000,250000,IF(V14>750000,V14-750000,0))","v":0},{"$f":"IF(V14>1250000,250000,IF(V14>1000000,V14-1000000,0))","v":0},{"$f":"IF(V14>1500000,250000,IF(V14>1250000,V14-1500000,0))","v":0},{"$f":"IF(V14>1500000,V14-1500000,0)","v":0},0,{"$f":"ROUND(W14*0.05,0)+ROUND(Z14*0.1,0)+ROUND(AA14*0.15,0)+ROUND(AB14*0.2,0)+ROUND(AC14*0.25,0)+ROUND(AD14*0.3,0)","v":0},{"$f":"ROUND(AE14*1.04,-1)","v":0},{"$f":"ROUND(AF14*1.04,-1)","v":0},{"$f":"IF($D$2=\"NO\",S14,T14)","v":0},{"$f":"IF($D$2=\"NO\",AG14,AH14)","v":0},{"$f":"IF(AI14<=12500,0,AI14)","v":0},{"$f":"IF(AK14<=12500,0,AJ14)","v":0},{"$f":"AL14-AK14","v":0},{"$nulls":4},{"$f":"IF(D2=\"No\",AU14,AX14)","v":0},{"$f":"IF(AR12>500000,250000,IF(AR12>250000,AR12-250000,0))","v":{"v":163540,"d":"163,540"}},{"$f":"IF(AS14>=250000,ROUND(AS14*0.05,0),0)","v":0},{"$f":"ROUND(SUM(AT14:AT16)*1.04,0)","v":0},{"$f":"IF(AR12>500000,250000,IF(AR12>250000,AR12-250000,0))","v":{"v":163540,"d":"163,540"}},{"$f":"IF(AV14>=250000,ROUND(AV14*0.05,0),0)","v":0},{"$f":"ROUND(SUM(AW14:AW19)*1.04,0)","v":0},{"$nulls":7},"Amount (Rs.)"]
[null,"2019-20",{"$nulls":4},"2019-20",0,0,0,0,0,{"$nulls":4},0,null,{"$f":"ROUND(Q15*1.04,-1)","v":0},null,0,0,0,0,0,0,{"$nulls":4},0,null,{"$f":"ROUND(AE15*1.04,-1)","v":0},null,{"$f":"S15","v":0},{"$f":"AG15","v":0},0,0,0,null,null,4,"Tax on total income (as per item 3)",null,{"$f":"IF(AR12>1000000,500000,IF(AR12>500000,AR12-500000,0))","v":0},{"$f":"ROUND(AS15*0.2,0)","v":0},null,{"$f":"IF(AR12>750000,250000,IF(AR12>500000,AR12-500000,0))","v":0},{"$f":"ROUND(AV15*0.1,0)","v":0},null,null,1,"(a)","Salary  received  in  arrears  or  in advance in  accordance  with the provisions of sub rule (2) of rule 21A",{"$nulls":3},{"$f":"AR14","v":0}]
[null,"2018-19",{"$nulls":4},"2018-19",0,0,0,0,{"$nulls":5},0,null,{"$f":"ROUND(Q16*1.04,-1)","v":0},null,{"$f":"D16","v":0},0,0,0,0,0,{"$nulls":4},0,null,{"$f":"ROUND(AE16*1.04,-1)","v":0},null,0,0,0,0,0,{"$nulls":5},{"$f":"IF(AR12>1000000,AR12-1000000,0)","v":0},{"$f":"ROUND(AS16*0.3,0)","v":0},null,{"$f":"IF(AR12>1000000,250000,IF(AR12>750000,AR12-750000,0))","v":0},{"$f":"ROUND(AV16*0.15,0)","v":0}]
[null,"2017-18",{"$nulls":4},"2017-18",0,0,0,0,{"$nulls":5},0,null,{"$f":"ROUND(Q17*1.03,-1)","v":0},null,0,0,0,0,0,0,{"$nulls":4},0,null,{"$f":"ROUND(AE17*1.03,-1)","v":0},null,0,0,{"$f":"IF(AI17<=2500,0,AI17)","v":0},{"$f":"IF(AK17<=2500,0,AJ17)","v":0},0,null,null,5,"Tax on total income (as per item 1)",{"$f":"IF(D2=\"NO\",AU7,AX7)","v":0},{"$nulls":3},{"$f":"IF(AR12>1250000,250000,IF(AR12>1000000,AR12-1000000,0))","v":0},{"$f":"ROUND(AV17*0.2,0)","v":0}]
[null,"2016-17",{"$nulls":4},"2016-17",0,0,{"$f":"IF(H18>1000000,500000,IF(H18>500000,H18-500000,0))","v":0},0,{"$nulls":5},0,null,{"$f":"ROUND(Q18*1.03,-1)","v":0},null,0,0,0,0,0,{"$nulls":5},0,null,{"$f":"ROUND(AE18*1.03,-1)","v":0},null,0,0,{"$f":"IF(AI18<=5000,0,IF(AI18>5000,AI18-5000))","v":0},{"$f":"IF(AJ18<=5000,0,IF(AJ18>5000,AJ18-5000))","v":0},0,{"$nulls":8},{"$f":"IF(AR12>1500000,250000,IF(AR12>1250000,AR12-1250000,0))","v":0},{"$f":"ROUND(AV18*0.25,0)","v":0},{"$nulls":3},"(b)","Payment  in  the  nature  of gratuity in respect of past services, exteding over a period of not less than 5 years in advance in accordance with the provisions of sub rule (3) of rule 21A",{"$nulls":3},"Not Applicable"]
[null,"2015-16",{"$nulls":4},"2015-16",0,{"$f":"IF(H19>500000,200000,IF(H19>300000,H19-300000,0))","v":0},{"$f":"IF(H19>1000000,500000,IF(H19>500000,H19-500000,0))","v":0},{"$f":"IF(J19>0,20000+(J19*0.2),0)","v":0},{"$f":"IF(H19>1000000,H19-1000000,0)","v":0},{"$f":"IF(L19>0,120000+(L19*0.3),0)","v":0},{"$nulls":3},{"$f":"ROUND(I19*0.1,0)+K19+M19","v":0},null,{"$f":"ROUND(Q19*1.03,-1)","v":0},null,0,0,{"$f":"IF(V19>500000,200000,IF(V19>300000,V19-300000,0))","v":0},0,{"$f":"IF(X19>0,20000+(X19*0.2),0)","v":0},{"$f":"IF(V19>1000000,V19-1000000,0)","v":0},{"$f":"IF(Z19>0,120000+(Z19*0.3),0)","v":0},{"$nulls":3},{"$f":"ROUND(W19*0.1,0)+Y19+AA19","v":0},null,{"$f":"ROUND(AE19*1.03,-1)","v":0},null,0,0,{"$f":"IF(AI19<=2000,0,IF(AI19>2000,AI19-2000))","v":0},0,0,null,null,6,"Tax on salary received in arrears or advance",{"$f":"AR14-AR17","v":0},{"$nulls":3},{"$f":"IF(AR12>1500000,AR12-1500000,0)","v":0},{"$f":"ROUND(AV19*0.3,0)","v":0}]
[null,"2014-15",{"$nulls":4},"2014-15",0,{"$f":"IF(H20>500000,250000,IF(H20>250000,H20-250000,0))","v":0},{"$f":"IF(H20>1000000,500000,IF(H20>500000,H20-500000,0))","v":0},{"$f":"IF(J20>0,25000+(J20*0.2),0)","v":0},{"$f":"IF(H20>1000000,H20-1000000,0)","v":0},{"$f":"IF(L20>0,125000+(L20*0.3),0)","v":0},{"$nulls":3},{"$f":"ROUND(I20*0.1,0)+K20+M20","v":0},null,{"$f":"ROUND(Q20*1.03,-1)","v":0},null,0,0,{"$f":"IF(V20>500000,250000,IF(V20>250000,V20-250000,0))","v":0},{"$f":"IF(V20>1000000,500000,IF(V20>500000,V20-500000,0))","v":0},{"$f":"IF(X20>0,25000+(X20*0.2),0)","v":0},{"$f":"IF(V20>1000000,V20-1000000,0)","v":0},{"$f":"IF(Z20>0,125000+(Z20*0.3),0)","v":0},{"$nulls":3},{"$f":"ROUND(W20*0.1,0)+Y20+AA20","v":0},null,{"$f":"ROUND(AE20*1.03,-1)","v":0},null,0,0,0,0,0,{"$nulls":3},"(Difference between item 4 and item 5)"]
[null,"2013-14",{"$nulls":4},"2013-14",0,{"$f":"IF(H21>500000,300000,IF(H21>200000,H21-200000,0))","v":0},0,{"$f":"IF(H21>1000000,H21-1000000,0)","v":0},{"$nulls":5},{"$f":"ROUND(I21*0.1,0)+ROUND(J21*0.2,0)+ROUND(K21*0.3,0)","v":0},null,{"$f":"ROUND(Q21*1.03,-1)","v":0},null,0,0,{"$f":"IF(V21>500000,300000,IF(V21>200000,V21-200000,0))","v":0},0,{"$f":"IF(V21>1000000,V21-1000000,0)","v":0},{"$nulls":5},{"$f":"ROUND(W21*0.1,0)+ROUND(X21*0.2,0)+ROUND(Y21*0.3,0)","v":0},null,{"$f":"ROUND(AE21*1.03,-1)","v":0},null,0,0,0,0,0]
[null,"Total",{"$f":"SUM(C6:C21)","v":0},{"$f":"SUM(D6:D21)","v":0},null,null,"Total",{"$f":"SUM(H13:H21)","v":0},{"$nulls":12},{"$f":"SUM(U13:U21)","v":0},{"$f":"SUM(V13:V21)","v":0},{"$nulls":14},{"$f":"SUM(AK13:AK21)","v":0},0,{"$f":"SUM(AM13:AM21)","v":0},null,null,7,"Tax Computed in accordance with Table \"A\"",{"$f":"AM22","v":0},{"$nulls":8},"(c) ","Payment   in   the   nature  of  compensation  from   the  employer  or  former employer   at   or  in  connection   with   termination   of  employment   after continuous service of not less than 3 years or where the unexpired portion of term  of  employment  is  also  not  less  than 3  years  in accordance with the provisions of sub rule (4) of rule 21A",{"$nulls":3},"Not Applicable"]
[{"$nulls":42},"(Brought from column 7 of Table \"A\")"]
[]
[{"$nulls":41},8,"Relief under section 89(1)"]
[{"$nulls":42},"(Indicate the difference between the amounts mentioned ",{"$f":"AR19-AR22","v":0}]
[{"$nulls":42},"against item 6 and 7)"]
[{"$nulls":52},"(d)","Payment  in  commutation  of  pension  in  accordance  with the provisions of sub rule (5) of rule 21A",{"$nulls":3},"Not Applicable"]
[]
[]
[{"$nulls":51},2,null,"Detailed particulars of payments referred to above may be given in Annexure I, II, III or IV, as the case may be."]
[]
[]
[]
[]
[{"$nulls":56},"Signature of the employee"]
[{"$nulls":51},"Verification"]
[]
[]
[{"$nulls":52},"I",{"$f":"'Basic Deta'!M6","v":0},null,"do hereby declare that what is stated above is true to the best "]
[{"$nulls":52},"of my knowledge and belief."]
[]
[]
[]
[{"$nulls":52},"Place: ",null,{"$f":"'Exemp.(HRA+Other) & Other incom'!A1","v":"District Education Officer, Education Department Primary Education of Bihar"}]
[{"$nulls":52},"Dated:",null,{"$f":"TODAY()","v":"2023-02-19"}]

{"sheet":"HRA Receipt","index":9,"n_rows":82,"n_cols":23,"rows_kept":82,"merged":[[0,0,0,22],[1,0,47,0],[1,2,1,10],[1,11,47,11],[1,12,47,12],[1,14,1,22],[1,23,47,23],[2,1,2,10],[2,13,2,22],[3,1,3,10],[3,13,3,22],[4,1,4,7],[4,8,4,9],[4,13,4,19],[4,20,4,21],[5,1,23,1],[5,3,5,10],[5,13,23,13],[5,15,5,22],[6,3,6,6],[6,7,6,9],[6,15,6,18],[6,19,6,21],[7,3,7,10],[7,15,7,22],[8,2,8,5],[8,6,8,10],[8,14,8,17],[8,18,8,22],[9,2,9,5],[9,6,9,10],[9,14,9,17],[9,18,9,22],[10,2,10,3],[10,4,10,10],[10,14,10,15],[10,16,10,22],[11,2,11,10],[11,14,11,22],[12,3,12,4],[12,5,12,10],[12,15,12,16],[12,17,12,22],[13,2,13,10],[13,14,13,22],[14,3,14,4],[14,5,14,10],[14,15,14,16],[14,17,14,22],[15,2,15,10],[15,14,15,22],[16,2,23,5],[16,6,16,10],[16,14,23,17],[16,18,16,22],[17,6,17,10],[17,18,17,22],[18,6,18,7],[18,8,18,10],[18,18,18,19],[18,20,18,22],[19,6,19,10],[19,18,19,22],[20,6,21,10],[20,18,21,22],[22,6,22,8],[22,9,22,10],[22,18,22,20],[22,21,22,22],[23,6,23,10],[23,18,23,22],[24,1,24,10],[24,13,24,22],[25,2,25,10],[25,14,25,22],[26,1,26,10],[26,13,26,22],[27,1,27,10],[27,13,27,22],[28,1,28,7],[28,8,28,9],[28,13,28,19],[28,20,28,21],[29,1,47,1],[29,3,29,10],[29,13,47,13],[29,15,29,22],[30,3,30,6],[30,7,30,9],[30,15,30,18],[30,19,30,21],[31,3,31,10],[31,15,31,22],[32,2,32,5],[32,6,32,10],[32,14,32,17],[32,18,32,22],[33,2,33,5],[33,6,33,10],[33,14,33,17],[33,18,33,22],[34,2,34,3],[34,4,34,10],[34,14,34,15],[34,16,34,22],[35,2,35,10],[35,14,35,22],[36,3,36,4],[36,5,36,10],[36,15,36,16],[36,17,36,22],[37,2,37,10],[37,14,37,22],[38,3,38,4],[38,5,38,10],[38,15,38,16],[38,17,38,22],[39,2,39,10],[39,14,39,22],[40,2,47,5],[40,6,40,10],[40,14,47,17],[40,18,40,22],[41,6,41,10],[41,18,41,22],[42,6,42,7],[42,8,42,10],[42,18,42,19],[42,20,42,22],[43,6,43,10],[43,18,43,22],[44,6,45,10],[44,18,45,22],[46,6,46,8],[46,9,46,10],[46,18,46,20],[46,21,46,22],[47,6,47,10],[47,18,47,22],[48,0,58,23],[59,0,59,22],[59,23,83,47],[60,2,60,10],[60,14,60,22],[61,1,61,10],[61,13,61,22],[62,1,62,10],[62,13,62,22],[63,1,63,7],[63,8,63,9],[63,13,63,19],[63,20,63,21],[64,1,82,1],[64,3,64,10],[64,13,82,13],[64,15,64,22],[65,3,65,6],[65,7,65,9],[65,15,65,18],[65,19,65,21],[66,3,66,10],[66,15,66,22],[67,2,67,5],[67,6,67,10],[67,14,67,17],[67,18,67,22],[68,2,68,5],[68,6,68,10],[68,14,68,17],[68,18,68,22],[69,2,69,3],[69,4,69,10],[69,14,69,15],[69,16,69,22],[70,2,70,10],[70,14,70,22],[71,3,71,4],[71,5,71,10],[71,15,71,16],[71,17,71,22],[72,2,72,10],[72,14,72,22],[73,3,73,4],[73,5,73,10],[73,15,73,16],[73,17,73,22],[74,2,74,10],[74,14,74,22],[75,2,82,5],[75,6,75,10],[75,14,82,17],[75,18,75,22],[76,6,76,10],[76,18,76,22],[77,6,77,7],[77,8,77,10],[77,18,77,19],[77,20,77,22],[78,6,78,10],[78,18,78,22],[79,6,80,10],[79,18,80,22],[81,6,81,8],[81,9,81,10],[81,18,81,20],[81,21,81,22],[82,6,82,10],[82,18,82,22],[83,0,83,22]]}
[]
[null,1,"RECEIPT OF HOUSE RENT",{"$nulls":10},2,"RECEIPT OF HOUSE RENT"]
[null,"(Under section 1 (13-A) of Income Tax Act)",{"$nulls":11},"(Under section 1 (13-A) of Income Tax Act)"]
[]
[{"$nulls":8},"Date :-",{"$nulls":11},"Date :-"]
[null,null,"I Owner ",{"$f":"'Exemp.(HRA+Other) & Other incom'!$O$4","v":0},{"$nulls":10},"I Owner ",{"$f":"'Exemp.(HRA+Other) & Other incom'!$O$4","v":0}]
[{"$nulls":3},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$A$4","v":"SHAHID ALI"},null,null,{"$f":"CONCATENATE(\"(\",'Exemp.(HRA+Other) & Other incom'!$C$4,\")\")","v":"(Block Teacher)"},{"$nulls":4},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$A$4","v":"SHAHID ALI"},null,null,{"$f":"CONCATENATE(\"(\",'Exemp.(HRA+Other) & Other incom'!$C$4,\")\")","v":"(Block Teacher)"}]
[null,null,"Address-",{"$f":"'Basic Deta'!$G$10","v":"M.S. BASUDHAR"},{"$nulls":10},"Address-",{"$f":"'Basic Deta'!$G$10","v":"M.S. BASUDHAR"}]
[null,null,"The sum of  (Quarterly) ",{"$nulls":3},{"$f":"G10*3","v":{"v":15330,"d":"Rs. 15330"}},{"$nulls":7},"The sum of  (Quarterly) ",{"$nulls":3},{"$f":"G10*3","v":{"v":15330,"d":"Rs. 15330"}}]
[null,null,"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$M$4","v":{"v":5110,"d":"Rs. 5110"}},{"$nulls":7},"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$M$4","v":{"v":5110,"d":"Rs. 5110"}}]
[null,null,"Per Month From :-",null,"1 April, 2022 To 30 June, 2022",{"$nulls":9},"Per Month From :-",null,"1 July, 2022 To 30 Sep., 2022"]
[]
[null,null,"Rs.  =  ",{"$f":"G9","v":15330},{"$nulls":10},"Rs.  =  ",{"$f":"G9","v":15330}]
[]
[null,null,"Date:-",{"$f":"K5","v":"00:00:00"},{"$nulls":10},"Date:-",{"$f":"K5","v":"00:00:00"}]
[]
[{"$nulls":6},"(Signature of House Owner)",{"$nulls":11},"(Signature of House Owner)"]
[{"$nulls":6},"(Affix Revenue Stamp of Rs.1/-) \n",{"$nulls":11},"(Affix Revenue Stamp of Rs.1/-) \n"]
[{"$nulls":6},"Name-",null,{"$f":"D6","v":0},{"$nulls":9},"Name-",null,{"$f":"D6","v":0}]
[{"$nulls":6},"ADDRESS",{"$nulls":11},"ADDRESS"]
[{"$nulls":6},{"$f":"'Exemp.(HRA+Other) & Other incom'!$P$4","v":0},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!$P$4","v":0}]
[]
[{"$nulls":6},"PAN NUMBER",null,null,{"$f":"'Exemp.(HRA+Other) & Other incom'!$Q$4","v":0},{"$nulls":8},"PAN NUMBER",null,null,{"$f":"'Exemp.(HRA+Other) & Other incom'!$Q$4","v":0}]
[]
[]
[null,3,"RECEIPT OF HOUSE RENT",{"$nulls":10},4,"RECEIPT OF HOUSE RENT"]
[null,"(Under section 1 (13-A) of Income Tax Act)",{"$nulls":11},"(Under section 1 (13-A) of Income Tax Act)"]
[]
[{"$nulls":8},"Date :-",{"$nulls":11},"Date :-"]
[null,null,"I Owner ",{"$f":"'Exemp.(HRA+Other) & Other incom'!$O$4","v":0},{"$nulls":10},"I Owner ",{"$f":"'Exemp.(HRA+Other) & Other incom'!$O$4","v":0}]
[{"$nulls":3},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$A$4","v":"SHAHID ALI"},null,null,{"$f":"CONCATENATE(\"(\",'Exemp.(HRA+Other) & Other incom'!$C$4,\")\")","v":"(Block Teacher)"},{"$nulls":4},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$A$4","v":"SHAHID ALI"},null,null,{"$f":"CONCATENATE(\"(\",'Exemp.(HRA+Other) & Other incom'!$C$4,\")\")","v":"(Block Teacher)"}]
[null,null,"Address-",{"$f":"'Basic Deta'!$G$10","v":"M.S. BASUDHAR"},{"$nulls":10},"Address-",{"$f":"'Basic Deta'!$G$10","v":"M.S. BASUDHAR"}]
[null,null,"The sum of  (Quarterly) ",{"$nulls":3},{"$f":"G34*3","v":{"v":15330,"d":"Rs. 15330"}},{"$nulls":7},"The sum of  (Quarterly) ",{"$nulls":3},{"$f":"S34*3","v":{"v":15330,"d":"Rs. 15330"}}]
[null,null,"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$M$4","v":{"v":5110,"d":"Rs. 5110"}},{"$nulls":7},"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$M$4","v":{"v":5110,"d":"Rs. 5110"}}]
[null,null,"Per Month From :-",null,"1 Oct., 2022 To 31 Dec., 2022",{"$nulls":9},"Per Month From :-",null,"1 Jan., 2023 To 31 March, 2023"]
[]
[null,null,"Rs.  =  ",{"$f":"G33","v":15330},{"$nulls":10},"Rs.  =  ",{"$f":"S33","v":15330}]
[]
[null,null,"Date:-",{"$f":"K29","v":"00:00:00"},{"$nulls":10},"Date:-",{"$f":"W29","v":"00:00:00"}]
[]
[{"$nulls":6},"(Signature of House Owner)",{"$nulls":11},"(Signature of House Owner)"]
[{"$nulls":6},"(Affix Revenue Stamp of Rs.1/-) \n",{"$nulls":11},"(Affix Revenue Stamp of Rs.1/-) \n"]
[{"$nulls":6},"Name-",null,{"$f":"D30","v":0},{"$nulls":9},"Name-",null,{"$f":"P30","v":0}]
[{"$nulls":6},"ADDRESS",{"$nulls":11},"ADDRESS"]
[{"$nulls":6},{"$f":"'Exemp.(HRA+Other) & Other incom'!$P$4","v":0},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!$P$4","v":0}]
[]
[{"$nulls":6},"PAN NUMBER",null,null,{"$f":"'Exemp.(HRA+Other) & Other incom'!$Q$4","v":0},{"$nulls":8},"PAN NUMBER",null,null,{"$f":"'Exemp.(HRA+Other) & Other incom'!$Q$4","v":0}]
{"$rows_empty":13}
[null,1,"RECEIPT OF HOUSE RENT",{"$nulls":10},2,"RECEIPT OF HOUSE RENT"]
[null,"(Under section 1 (13-A) of Income Tax Act)",{"$nulls":11},"(Under section 1 (13-A) of Income Tax Act)"]
[]
[{"$nulls":8},"Date :-",{"$nulls":11},"Date :-"]
[null,null,"I Owner ",{"$f":"'Exemp.(HRA+Other) & Other incom'!$O$4","v":0},{"$nulls":10},"I Owner ",{"$f":"'Exemp.(HRA+Other) & Other incom'!$O$4","v":0}]
[{"$nulls":3},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$A$4","v":"SHAHID ALI"},null,null,{"$f":"CONCATENATE(\"(\",'Exemp.(HRA+Other) & Other incom'!$C$4,\")\")","v":"(Block Teacher)"},{"$nulls":4},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$A$4","v":"SHAHID ALI"},null,null,{"$f":"CONCATENATE(\"(\",'Exemp.(HRA+Other) & Other incom'!$C$4,\")\")","v":"(Block Teacher)"}]
[null,null,"Address-",{"$f":"'Basic Deta'!$G$10","v":"M.S. BASUDHAR"},{"$nulls":10},"Address-",{"$f":"'Basic Deta'!$G$10","v":"M.S. BASUDHAR"}]
[null,null,"The sum of  (Yearly) ",{"$nulls":3},{"$f":"G69*12","v":{"v":61320,"d":"Rs. 61320"}},{"$nulls":7},"The sum of  (Yearly) ",{"$nulls":3},{"$f":"G69*12","v":{"v":61320,"d":"Rs. 61320"}}]
[null,null,"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$M$4","v":{"v":5110,"d":"Rs. 5110"}},{"$nulls":7},"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'Exemp.(HRA+Other) & Other incom'!$M$4","v":{"v":5110,"d":"Rs. 5110"}}]
[null,null,"Per Month From :-",null,"1 April, 2022 To 31 March, 2023",{"$nulls":9},"Per Month From :-",null,{"$f":"E70","v":"1 April, 2022 To 31 March, 2023"}]
[]
[null,null,"Rs.  =  ",{"$f":"G68","v":61320},{"$nulls":10},"Rs.  =  ",{"$f":"G68","v":61320}]
[]
[null,null,"Date:-",{"$f":"K64","v":"00:00:00"},{"$nulls":10},"Date:-",{"$f":"K64","v":"00:00:00"}]
[]
[{"$nulls":6},"(Signature of House Owner)",{"$nulls":11},"(Signature of House Owner)"]
[{"$nulls":6},"(Affix Revenue Stamp of Rs.1/-) \n",{"$nulls":11},"(Affix Revenue Stamp of Rs.1/-) \n"]
[{"$nulls":6},"Name-",null,{"$f":"D65","v":0},{"$nulls":9},"Name-",null,{"$f":"D65","v":0}]
[{"$nulls":6},"ADDRESS",{"$nulls":11},"ADDRESS"]
[{"$nulls":6},{"$f":"'Exemp.(HRA+Other) & Other incom'!$P$4","v":0},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!$P$4","v":0}]
[]
[{"$nulls":6},"PAN NUMBER",null,null,{"$f":"'Exemp.(HRA+Other) & Other incom'!$Q$4","v":0},{"$nulls":8},"PAN NUMBER",null,null,{"$f":"'Exemp.(HRA+Other) & Other incom'!$Q$4","v":0}]