{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["For Help","Basic Data","Exemp.(HRA+Other) & Other incom","GA-55","New Regime Calc. Report","Old Regime Calc. Report","OLD REGIME","Itax Calculate For All Emp."],"not_rendered":{"images":1,"external_links":1,"defined_names":7,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"For Help","index":0,"n_rows":14,"n_cols":8,"rows_kept":14,"merged":[[0,0,0,8],[1,1,1,2],[1,3,1,7],[2,6,14,6],[3,0,14,0],[3,3,4,3],[3,7,6,7],[3,8,14,8],[4,1,11,1],[7,3,12,5],[8,7,10,7],[12,1,13,1],[12,7,13,7],[13,3,13,5]]}
[]
[null,"FOR HELP CLICK HERE→\n(PLEASE SUBSCRIBE MY YOUTUBE CHANNEL)",null,"Click Here For Help Video"]
[]
[null,"आवश्यक निर्देश :- ",null,"आयकर गणना प्रपत्र देखें","→","As New Regime"]
[null,"1- सबसे पहले Basic Data शीट में सफ़ेद सेल्स में कार्मिक से जुड़े विद्यालय,स्वयं कार्मिक तथा वेतन सम्बंधित विवरण फिल करें.\n2- Basic Data भरने के पश्चात Exemp.(HRA+Other) & Other income वाली शीट में HRA अतिरिक्त आय, कटौतियां आदि भरें. (हालाँकि नियमानुसार HRA की गणना स्वतः की हुई मिलेगी फिर भी आपसे जुड़े DDO के निर्देशानुसार इसे बदल भी सकते है.)\n3- Basic Data एंट्री के साथ ही आपको GA-55 तैयार मिलेगा जो कि पूर्णत: अनलॉक है आप Pay Man./Pri Pay Man. से निकाले ऑनलाइन GA-55 रिपोर्ट से भली भांति मिलान कर आवश्यकतानुसार बदलाव भी कर सकते हैं.\n4- उक्त कार्य पूर्ण करने के बाद आपके सामने कार्मिक से जुडी पुरानी तथा नई कर व्यवस्था (Old Tax Regime/New Tax Regime)  के अनुसार आयकर गणना प्रपत्र का प्रिंट ले सकते हैं.\n",null,null,"→","As Old Regime"]
[]
[{"$nulls":3},"GA55 देखें","→","Click Here"]
[]
[{"$nulls":7},"Creator:-\nUmmed Tarad"]
[]
[]
[{"$nulls":7},"(GSSS RAIMALWADA, BAPINI-PHALODI)"]
[null,"नोट :- हालाँकि इस प्रोग्राम को बनाते समय पूर्ण सावधानी के साथ तैयार किया गया है. मानवीय भूल सहज है. यदि किसी भी प्रकार की कोई समस्या, शंका तथा आपत्ति की स्थिति में आप अपने विवेक को प्रमुखता दें. ",{"$nulls":5},"Email Id-ummedtrdedu@gmail.com"]
[{"$nulls":3},"Updated On 02-11-2025"]

{"sheet":"Basic Data","index":1,"n_rows":20,"n_cols":17,"rows_kept":20,"merged":[[0,0,20,0],[0,1,0,16],[0,17,20,17],[1,1,1,16],[2,1,2,16],[3,1,3,16],[4,1,4,5],[4,6,4,11],[4,12,4,13],[4,14,4,15],[5,1,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[6,1,6,16],[7,1,7,16],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,8,8,10],[8,14,8,15],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,8,9,10],[9,14,9,15],[10,1,10,15],[11,1,13,1],[11,2,11,10],[11,11,11,16],[12,2,13,2],[12,7,12,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],[12,15,13,15],[12,16,13,16],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[14,14,15,14],[14,15,15,15],[14,16,15,16],[16,1,16,16],[17,1,17,16],[18,13,18,16],[19,13,19,16],[20,1,20,16]]}
[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's Detail"]
[null,"DDO Office Name :-",{"$nulls":4},"Govt. Sr. School Raimalwada",{"$nulls":5},"DDO Code :-",null,12345,null,"F.Y."]
[null,"District :-",{"$nulls":4},"Phalodi",null,"TAN No. :-",null,"JDHG09250D",null,"DDO Name :-",{"$nulls":3},"2025-26"]
[]
[null,"Employee Personal & Salary Details"]
[null,"Employee Name",null,"Employee Service Type",null,"Employee ID",null,"Designation","Posting Place Name",null,null,"Pay Matrix Level","Basic Pay (March-25)","PAN No.","Account Number",null,"Employee Age\n(Less 60=A, Between 60&80=B, Above 80=C)"]
[null,"a",null,"Subordinate",null,"rjjo20212251115",null,"Teacher",{"$f":"G5","v":"Govt. Sr. School Raimalwada"},null,null,{"v":10,"d":"L-10"},{"v":49700,"d":"₹ 49,700"},"ABCDE1234F",null,null,"A"]
[]
[null,"Employee Status (Regular/ Probation)","Extra Paid Status",{"$nulls":8},"Deducted Amount"]
[null,null,"Bonus Amount","DA Paid ","DA Paid ","DA Arear","DA Arear","Surrender",null,"Washing All.","Handi. All.","GPF/GPF-2004 ","SI","SI Loan","LIC","RGHS","GIS"]
[{"$nulls":3},"From Jan-25","From Jul-25","Jan-25 to Mar-25","Jul-25 to Sep-25","Claimed (Yes/No)","Month"]
[null,"Regular",{"$f":"IF(OR(B15=\"Probation\",D10=\"state Service\",L10>=13),0,6774)","v":{"v":6774,"d":"₹ 6,774"}},{"v":0.55,"d":"55%"},{"v":0.58,"d":"58%"},"YES","YES","NO","2025-09-01","NO","NO",{"v":2850,"d":"₹ 2,850"},{"v":5000,"d":"₹ 5,000"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":650,"d":"₹ 650"},{"v":2100,"d":"₹ 2,100"}]
[{"$nulls":7},"Surr. Arr. Deposit in\n(Cash/GPF)","Cash"]
[]
[null,"Deducted Income Tax "]
[null,"2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","Extra TDS Deposited \n(Via Challan etc)"]
[null,{"v":2000,"d":"₹ 2,000"},{"$f":"B20","v":{"v":2000,"d":"₹ 2,000"}},{"v":2000,"d":"₹ 2,000"},{"v":2000,"d":"₹ 2,000"},{"v":2000,"d":"₹ 2,000"},{"v":2000,"d":"₹ 2,000"},{"v":2000,"d":"₹ 2,000"},{"v":2000,"d":"₹ 2,000"},{"v":2000,"d":"₹ 2,000"},{"v":2000,"d":"₹ 2,000"},{"v":2000,"d":"₹ 2,000"},{"v":2000,"d":"₹ 2,000"},{"$f":"SUM('Exemp.(HRA+Other) & Other incom'!Q7:Q10)","v":{"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":"'GA-55'!B1","v":"Office: Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
["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 Data'!B10","v":"a"},null,{"$f":"'Basic Data'!H10","v":"Teacher"},{"$f":"'Basic Data'!I10","v":"Govt. Sr. School Raimalwada"},{"$f":"SUM('GA-55'!F9:F20,'GA-55'!F28,'GA-55'!F29)","v":608400},{"$f":"SUM('GA-55'!G23,'GA-55'!G22,'GA-55'!G9:G20,'GA-55'!G28:G29)","v":348896},{"$f":"E4+F4","v":957296},{"$f":"ROUNDUP((G4*0.1),0)","v":95730},{"$f":"SUM('GA-55'!H9:H20,'GA-55'!H28:H29)","v":60840},{"$f":"ROUNDUP((I4+H4),-1)","v":156570},{"$f":"IF(T4>I4,I4,T4)","v":60840},{"$f":"ROUNDUP((M4*12),-1)","v":156600},{"$f":"IF(H4>100000,0,ROUNDUP(J4/12,-1))","v":13050},{"$f":"ROUNDUP((M4*3),-1)","v":39150},{"$nulls":5},{"$f":"IF(AND(M4=0,H4>100000),0,IF(AND(M4>0,L4>H4),(L4-H4),0))","v":60870}]
["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 Data'!Q10","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 अधिकतम/80 TTB-अधिकतम 50000)",null,{"v":0,"d":"₹ 0.00"}]
[2,"व्यवसाय कर धारा 16 (ii) के अंतर्गत अधिकतम 5000 रूपये",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,16,"अन्य जमा राशी (80 C धारा के अंतर्गत)",null,{"v":0,"d":"₹ 0.00"}]
[3,"गृहकर",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,17,"धारा 80CCC - पेंशन प्लान हेतु अंशदान (NPS के अतिरिक्त)",null,{"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,"इक्विटी लिंक सेविंग स्कीम",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":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"GA-55","index":3,"n_rows":32,"n_cols":37,"rows_kept":32,"merged":[[0,1,0,28],[0,29,31,29],[1,2,1,19],[1,20,1,26],[1,27,1,28],[2,1,2,4],[2,5,2,8],[2,9,2,14],[2,15,2,17],[2,19,2,25],[2,26,2,28],[3,1,3,28],[4,1,4,4],[4,5,4,8],[4,9,4,14],[4,15,4,17],[4,19,4,25],[4,26,4,28],[5,1,5,28],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,6,14],[6,15,6,27],[6,28,7,28],[20,1,20,2],[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,4],[31,1,31,14],[31,15,31,28]]}
[null,{"$f":"CONCATENATE(\"Office:\",\" \",'Basic Data'!G5,\" \",\"(\",'Basic Data'!M5,'Basic Data'!O5,\")\")","v":"Office: Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
[null,null,"                                                                                               Employee GA-55 (For Itax Calculation)",{"$nulls":17},"Financial Year :-",{"$nulls":6},{"$f":"'Basic Data'!Q6","v":"2025-26"}]
[null,"Employee Name :-",{"$nulls":3},{"$f":"'Basic Data'!B10","v":"a"},{"$nulls":3},"Designation :-",{"$nulls":5},{"$f":"'Basic Data'!H10","v":"Teacher"},{"$nulls":3},"Employee ID :-",{"$nulls":6},{"$f":"'Basic Data'!F10","v":"rjjo20212251115"}]
[]
[null,"PAN No. :-",{"$nulls":3},{"$f":"'Basic Data'!N10","v":"ABCDE1234F"},{"$nulls":3},"Pay Matrix Level :-",{"$nulls":5},{"$f":"'Basic Data'!L10","v":{"v":10,"d":"L-10"}},{"$nulls":3},"Account Number :-",{"$nulls":6},{"$f":"'Basic Data'!O10","v":0}]
[]
[null,"Sr. No.","Month","TV Number","TV Date","Allowance",{"$nulls":9},"Deductions",{"$nulls":12},"Net Payment"]
[{"$nulls":5},"Basic","DA","HRA","DP","Washing All.","Handi. All.","ROP\n(If any)","Other-1","Other-2","Groce Amount","GPF/ GPF-2004","SI","SIL","RGHS","LIC","GIS","HBA","CmCorona Relief","Hitkari Nidhi","Other-1","Other-2","Income Tax","Total Deductions"]
[null,1,"2025-03-01",null,null,{"$f":"'Basic Data'!M10","v":49700},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F9*0.53,0)","v":26341},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F9*0.1,0)","v":4970},null,{"$f":"IF('Basic Data'!J15=\"Yes\",180,0)","v":0},{"$f":"IF('Basic Data'!K15=\"Yes\",1200,0)","v":0},{"$nulls":3},{"$f":"SUM(F9:N9)","v":81011},{"$f":"'Basic Data'!L15","v":2850},{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},{"$f":"'Basic Data'!N15","v":0},{"$f":"'Basic Data'!P15","v":650},{"$f":"'Basic Data'!O15","v":0},{"$nulls":6},{"$f":"'Basic Data'!$B20","v":2000},{"$f":"SUM(P9:AA9)","v":10500},{"$f":"O9-AB9","v":70511},null,null,{"$f":"IF(C9='Basic Data'!$I$15,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AF9=\"Yes\",ROUND(F9/2,0),0)","v":0},{"$f":"IF(AF9=\"Yes\",ROUND(G9/2,0),0)","v":0},{"$f":"IF(AF9=\"Yes\",(F9+G9)/2,0)","v":0}]
[null,2,"2025-04-01",null,null,{"$f":"F9","v":49700},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F10*'Basic Data'!$D$15,0)","v":{"v":27335.000000000004,"d":"27335"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F10*0.1,0)","v":4970},{"$f":"I9","v":0},{"$f":"J9","v":0},{"$f":"K9","v":0},null,{"$f":"M9","v":0},{"$f":"N9","v":0},{"$f":"SUM(F10:N10)","v":82005},{"$f":"P9","v":2850},{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},{"$f":"R9","v":0},{"$f":"S9","v":650},{"$f":"T9","v":0},{"$f":"'Basic Data'!Q15","v":2100},{"$nulls":4},{"$f":"Z9","v":0},{"$f":"'Basic Data'!$C20","v":2000},{"$f":"SUM(P10:AA10)","v":12600},{"$f":"O10-AB10","v":69405},null,null,{"$f":"IF(C10='Basic Data'!$I$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":0},{"$f":"IF(AF10=\"Yes\",(F10+G10)/2,0)","v":0}]
[null,3,"2025-05-01",null,null,{"$f":"F10","v":49700},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F11*'Basic Data'!$D$15,0)","v":{"v":27335.000000000004,"d":"27335"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F11*0.1,0)","v":4970},{"$f":"I10","v":0},{"$f":"J10","v":0},0,null,{"$f":"M10","v":0},{"$f":"N10","v":0},82005,2850,{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},0,650,0,{"$f":"U9","v":0},{"$nulls":4},0,{"$f":"'Basic Data'!D20","v":2000},10500,71505,null,null,{"$f":"IF(C11='Basic Data'!$I$15,\"Yes\",\"No\")","v":"No"},0,0,0]
[null,4,"2025-06-01",null,null,49700,{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F12*'Basic Data'!$D$15,0)","v":{"v":27335.000000000004,"d":"27335"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F12*0.1,0)","v":4970},0,0,0,null,0,0,82005,2850,{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},0,650,0,{"$f":"U11","v":0},{"$nulls":4},0,{"$f":"'Basic Data'!E20","v":2000},10500,71505,null,null,{"$f":"IF(C12='Basic Data'!$I$15,\"Yes\",\"No\")","v":"No"},0,0,0]
[null,5,"2025-07-01",null,null,{"$f":"IF('Basic Data'!B15=\"Regular\",ROUND(F12*103%,-2),'GA-55'!F12)","v":51200},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F13*'Basic Data'!$D$15,0)","v":{"v":28160.000000000004,"d":"28160"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F13*0.1,0)","v":5120},0,0,0,null,0,0,84480,2850,{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},0,650,0,0,{"$nulls":4},0,{"$f":"'Basic Data'!F20","v":2000},10500,73980,null,null,{"$f":"IF(C13='Basic Data'!$I$15,\"Yes\",\"No\")","v":"No"},0,0,0,{"$f":"IF(AF13=\"yes\",(F13*0.03/2),0)","v":0},{"$f":"IF($AF13=\"Yes\",ROUND(AH13*0.04,0),0)","v":0}]
[null,6,"2025-08-01",null,null,{"$f":"F13","v":51200},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F14*'Basic Data'!$D$15,0)","v":{"v":28160.000000000004,"d":"28160"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F14*0.1,0)","v":5120},0,0,0,null,0,0,84480,2850,{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},0,650,0,0,{"$nulls":4},0,{"$f":"'Basic Data'!G20","v":2000},10500,73980,null,null,{"$f":"IF(C14='Basic Data'!$I$15,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AF14=\"Yes\",ROUND(F14/2,0),0)","v":0},0,0,{"$f":"IF(AF14=\"yes\",(F14*0.03/2),0)","v":0},{"$f":"IF($AF14=\"Yes\",ROUND(AH14*0.04,0),0)","v":0}]
[null,7,"2025-09-01",null,null,{"$f":"F14","v":51200},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F15*'Basic Data'!$D$15,0)","v":{"v":28160.000000000004,"d":"28160"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F15*0.1,0)","v":5120},0,0,0,null,0,0,84480,2850,{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},0,650,0,0,{"$nulls":4},0,{"$f":"'Basic Data'!H20","v":2000},10500,73980,null,null,{"$f":"IF(C15='Basic Data'!$I$15,\"Yes\",\"No\")","v":"Yes"},25600,14080,39680,{"$f":"IF(AF15=\"yes\",(F15*0.03/2),0)","v":768},{"$f":"IF($AF15=\"Yes\",ROUND(AH15*0.03,0),0)","v":422}]
[null,8,"2025-10-01",null,null,51200,{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F16*'Basic Data'!$E$15,0)","v":{"v":29695.999999999996,"d":"29696"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F16*0.1,0)","v":5120},0,0,0,null,0,0,86016,2850,{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},0,650,0,0,{"$nulls":4},0,{"$f":"'Basic Data'!I20","v":2000},10500,75516,null,null,{"$f":"IF(C16='Basic Data'!$I$15,\"Yes\",\"No\")","v":"No"},0,0,0]
[null,9,"2025-11-01",null,null,51200,{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F17*'Basic Data'!$E$15,0)","v":{"v":29695.999999999996,"d":"29696"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F17*0.1,0)","v":5120},0,0,0,null,0,0,86016,2850,{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},0,650,0,0,{"$nulls":4},0,{"$f":"'Basic Data'!J20","v":2000},10500,75516,null,null,{"$f":"IF(C17='Basic Data'!$I$15,\"Yes\",\"No\")","v":"No"},0,0,0]
[null,10,"2025-12-01",null,null,51200,{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F18*'Basic Data'!$E$15,0)","v":{"v":29695.999999999996,"d":"29696"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F18*0.1,0)","v":5120},0,0,0,null,0,0,86016,2850,{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},0,650,0,0,null,null,{"$f":"IF('Basic Data'!D10=\"State Service\",500,250)","v":250},null,0,{"$f":"'Basic Data'!K20","v":2000},10750,75266,null,null,{"$f":"IF(C18='Basic Data'!$I$15,\"Yes\",\"No\")","v":"No"},0,0,0]
[null,11,"2026-01-01",null,null,51200,{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F19*'Basic Data'!$E$15,0)","v":{"v":29695.999999999996,"d":"29696"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F19*0.1,0)","v":5120},0,0,0,null,0,0,86016,2850,{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},0,650,0,0,{"$nulls":4},0,{"$f":"'Basic Data'!L20","v":2000},10500,75516,null,null,{"$f":"IF(C19='Basic Data'!$I$15,\"Yes\",\"No\")","v":"No"},0,0,0]
[null,12,"2026-02-01",null,null,51200,{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F20*'Basic Data'!$E$15,0)","v":{"v":29695.999999999996,"d":"29696"}},{"$f":"IF('Basic Data'!$B$15=\"Regular\",'GA-55'!F20*0.1,0)","v":5120},0,0,0,null,0,0,86016,2850,{"$f":"IF('Basic Data'!$B$15=\"Probation\",\"\",'Basic Data'!$M$15)","v":5000},0,650,{"$f":"T19","v":0},0,{"$nulls":4},0,{"$f":"'Basic Data'!M20","v":2000},10500,75516,null,null,{"$f":"IF(C20='Basic Data'!$I$15,\"Yes\",\"No\")","v":"No"},0,0,0]
[null,"Bonus",{"$nulls":11},{"$f":"IF('Basic Data'!L10>=13,0,'Basic Data'!C15)","v":6774},6774,{"$f":"ROUND(O21*25/100,0)","v":1694},{"$nulls":11},1694,5080,{"$nulls":3},{"$f":"SUM(AG9:AG20)","v":25600},{"$f":"SUM(AH9:AH20)","v":14080},39680,768,{"$f":"SUM(AK9:AK20)","v":422}]
[null,"DA (Jan-25 to Mar-25)",{"$nulls":4},{"$f":"IF('Basic Data'!F15=\"yes\",ROUND('Basic Data'!M10*0.02*3,0),0)","v":2982},{"$nulls":7},2982,{"$f":"O22","v":2982},{"$nulls":11},2982,0]
[null,"DA (Jul-25 to  Sep-25)",{"$nulls":4},{"$f":"IF(AND('Basic Data'!E15>'Basic Data'!D15,'Basic Data'!G15=\"yes\"),ROUND(F13*0.03*3,0),0)","v":4608},{"$nulls":7},4608,{"$f":"O23","v":4608},{"$nulls":11},4608,0]
[null,"Surrender",{"$nulls":3},{"$f":"IF('Basic Data'!H15=\"Yes\",AG21,0)","v":0},{"$f":"IF('Basic Data'!H15=\"Yes\",AH21,0)","v":0},{"$nulls":7},0,{"$nulls":12},0,0]
[null,"Surrender Arrear",{"$nulls":4},{"$f":"IF('Basic Data'!H15=\"Yes\",AJ21,0)","v":0},{"$nulls":7},0,{"$f":"IF('Basic Data'!I16=\"Cash\",\"\",G25)","v":""},{"$nulls":11},0,0]
[null,"Other-2",{"$nulls":12},0,{"$nulls":12},0,0]
[null,"Surr. Arear",{"$nulls":4},{"$f":"IF('Basic Data'!I15=\"Yes\",AJ21,0)","v":0},{"$nulls":7},0,{"$f":"O27","v":0},{"$nulls":11},0,0]
[null,"Sal. Arrear-1",{"$nulls":5},{"$f":"IF('Basic Data'!Q20=\"Yes\",'GA-55'!F13*0.01*4,\"\")","v":""},{"$nulls":6},0,{"$nulls":12},0,0]
[null,"Sal. Arrear-2",{"$nulls":12},0,{"$nulls":12},0,0]
[null,"Sal. Arrear-3",{"$nulls":12},0,{"$nulls":12},0,0]
[null,"Total",{"$nulls":3},{"$f":"SUM(F9:F30)","v":608400},{"$f":"SUM(G9:G30)","v":348896},{"$f":"SUM(H9:H30)","v":60840},{"$f":"SUM(I9:I30)","v":0},{"$f":"SUM(J9:J30)","v":0},{"$f":"SUM(K9:K30)","v":0},{"$f":"SUM(L9:L30)","v":0},{"$f":"SUM(M9:M30)","v":0},{"$f":"SUM(N9:N30)","v":6774},{"$f":"SUM(O9:O30)","v":1024910},{"$f":"SUM(P9:P30)","v":43484},{"$f":"SUM(Q9:Q30)","v":60000},{"$f":"SUM(R9:R30)","v":0},{"$f":"SUM(S9:S30)","v":7800},{"$f":"SUM(T9:T30)","v":0},{"$f":"SUM(U9:U30)","v":2100},{"$f":"SUM(V9:V30)","v":0},{"$f":"SUM(W9:W30)","v":0},{"$f":"SUM(X9:X30)","v":250},{"$f":"SUM(Y9:Y30)","v":0},{"$f":"SUM(Z9:Z30)","v":0},{"$f":"SUM(AA9:AA30)","v":24000},{"$f":"SUM(AB9:AB30)","v":137634},{"$f":"SUM(AC9:AC30)","v":887276}]
[null,{"$f":"CONCATENATE(\"Siganture of Employee\", \"(\",'Basic Data'!B10,\")\")","v":"Siganture of Employee(a)"},{"$nulls":13},{"$f":"CONCATENATE(\"Signature of DDO\",\" \",\"(\",'Basic Data'!O6,\")\")","v":"Signature of DDO ()"}]

{"sheet":"New Regime Calc. Report","index":4,"n_rows":73,"n_cols":41,"rows_kept":73,"merged":[[0,0,73,0],[0,1,0,16],[0,17,73,17],[0,19,0,20],[0,21,74,21],[1,1,1,12],[1,13,1,16],[1,19,6,20],[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],[7,18,9,18],[7,19,9,19],[7,20,9,20],[7,23,9,25],[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],[11,18,13,18],[11,19,13,19],[11,20,13,20],[11,23,13,25],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,2,13,14],[14,2,14,14],[14,19,14,20],[15,1,17,1],[15,2,17,2],[15,4,15,14],[15,19,74,20],[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,37,14],[36,15,37,15],[36,16,37,16],[38,2,39,14],[38,15,39,15],[38,16,39,16],[40,2,41,14],[40,15,41,15],[40,16,41,16],[42,2,43,14],[42,15,43,15],[42,16,43,16],[44,2,44,14],[45,2,45,14],[46,2,46,14],[47,2,47,14],[48,1,65,1],[48,2,48,16],[49,2,49,7],[49,8,49,9],[49,10,49,11],[49,12,49,14],[50,2,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,14],[51,2,51,7],[51,8,51,9],[51,10,51,11],[51,12,51,14],[52,2,52,7],[52,8,52,9],[52,10,52,11],[52,12,52,14],[53,2,53,7],[53,8,53,9],[53,10,53,11],[53,12,53,14],[54,2,54,7],[54,8,54,9],[54,10,54,11],[54,12,54,14],[55,2,55,7],[55,8,55,9],[55,10,55,11],[55,12,55,14],[56,2,56,7],[56,8,56,9],[56,10,56,11],[56,12,56,14],[56,26,57,26],[56,27,57,27],[56,28,57,28],[56,29,57,29],[56,30,57,30],[57,2,57,14],[57,37,57,40],[58,2,58,14],[59,2,59,14],[60,2,60,14],[60,29,64,29],[61,2,61,14],[62,2,62,14],[63,2,63,14],[64,2,64,14],[64,30,70,30],[65,2,65,14],[66,2,66,14],[67,1,68,1],[67,2,67,14],[68,2,68,14],[69,1,71,1],[69,2,71,2],[69,3,69,4],[69,5,69,7],[69,12,69,13],[69,15,69,16],[70,3,70,4],[70,5,70,7],[70,12,70,13],[71,3,71,10],[71,11,71,14],[71,26,71,28],[72,1,73,9],[72,10,73,16]]}
[null,{"$f":"'Exemp.(HRA+Other) & Other incom'!A1","v":"Office: Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
[null,"Income Tax Calculation F.Y. 2025-26 (A.Y.2026-27)",{"$nulls":11},"New Tax Regime",{"$nulls":5},"Comparison of Itax calculation in Old and New Tax Regime"]
[null,1,"कर्मचारी का नाम :-",null,{"$f":"'GA-55'!F3","v":"a"},{"$nulls":5},"पद :-",{"$f":"'GA-55'!P3","v":"Teacher"},null,null,"PAN :",{"$f":"'GA-55'!F5","v":"ABCDE1234F"}]
[null,2,"आय:वर्ष 2025-26 में कुल प्राप्त वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"Rs.",{"$f":"'GA-55'!O31","v":{"v":1024910,"d":"1024910.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":1024910,"d":"1024910.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":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(U8>U12,\"n\",\"y\")","v":"n"},"Tax Calculate by Old Tax Regime",{"$f":"'Old Regime Calc. Report'!Q66","v":{"v":77170,"d":"₹ 77,170.00"}}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction)-अधिकतम 75,000",{"$nulls":9},{"v":75000,"d":"75000.00"},null,null,"Rs.",{"$f":"M7+M8+M9","v":{"v":75000,"d":"75000.00"}}]
[null,6,"                                                             शेष (4-5)",{"$nulls":12},"Rs.",{"$f":"Q6-Q9","v":{"v":949910,"d":"949910.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":5},{"$f":"IF(U12>U8,\"n\",\"y\")","v":"y"},"Tax Calculate by New Tax Regime",{"$f":"Q69","v":{"v":0,"d":"₹ 0.00"}}]
[{"$nulls":4},{"$f":"ROUND(M11*0.3,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":949910,"d":"949910.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":949910,"d":"949910.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\",'GA-55'!Q31,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\",'GA-55'!T31+'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\",'GA-55'!P31,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\",'GA-55'!U31,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. An employer's contribution to the NPS up to 10% (14% of Govt. employees) of an employer's basic pay plus DA is allowed \n                                                                                                                                                                                                      as U/s 80 CCD(2)",{"$nulls":12},"Rs.",{"v":0,"d":"0.00"}]
[]
[null,null,"2. Any amount paid or deposited to the Agniveer Corpus Fund under the newly proposed \n                                                                                                                                                                                                      as U/s 80 CCH",{"$nulls":12},"Rs.",{"v":0,"d":"0.00"}]
[]
[{"$nulls":23},">300000",">600000",">900000",">1200000",">1500000"]
[{"$nulls":23},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,IF($Q$48>1000000,3,IF($Q$48>700000,4,IF($Q$48>300000,5,0)))))","v":4},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,IF($Q$48>900000,3,IF($Q$48>600000,4,0))))","v":3},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,IF($Q$48>900000,3,0)))","v":3},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,0))","v":0},{"$f":"IF($Q$48>1500000,1,0)","v":0}]
[{"$nulls":22},"A",{"$f":"IF(X42>=5,ROUND(($Q$48-300000)*0.05,0),IF(X42=0,0,15000))","v":15000},{"$f":"IF(Y42>=4,ROUND(($Q$48-600000)*0.1,0),IF(Y42=0,0,30000))","v":30000},{"$f":"IF(Z42>=3,ROUND(($Q$48-900000)*0.15,0),IF(Z42=0,0,45000))","v":7487},{"$f":"IF(AA42>=2,ROUND(($Q$48-1200000)*0.2,0),IF(AA42=0,0,60000))","v":0},{"$f":"IF(AB42>0,ROUND(($Q$48-1500000)*0.3,0),0)","v":0}]
[]
[null,null,"कुल योग 12",{"$nulls":12},"Rs.",{"$f":"SUM(Q37:Q44)","v":{"v":0,"d":"0.00"}}]
[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":949910,"d":"949910.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288A",{"$nulls":12},"Rs.",{"$f":"ROUND(Q47,-1)","v":{"v":949910,"d":"949910.00"}}]
[null,16,"उपरोक्त बिंदु 15 के आधार पर आयकर की गणना "]
[null,null,"Income Slab",{"$nulls":5},"सामान्य करदाता",null,"वरिष्ठ नागरिक (आयु 60 से 80 वर्ष)",null,"81 वर्ष या अधिक आयु "]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,000 तक\",\"4,00,000 तक\")","v":"4,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,null,"Rs.",{"$f":"AD71","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,001 से 3,00,000 तक\",\"4,00,001 से 8,00,000 तक\")","v":"4,00,001 से 8,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"5% (With Tx Reb.US 87A up to 12 Lakh)\")","v":"5% (With Tx Reb.US 87A up to 12 Lakh)"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5%(With Tx Reb.US 87A up to 12 Lakh)\")","v":"5%(With Tx Reb.US 87A up to 12 Lakh)"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tx Reb.US 87A up to 12 Lakh)\")","v":"5% (With Tx Reb.US 87A up to 12 Lakh)"},null,null,"Rs.",{"$f":"AD70","v":{"v":20000,"d":"20000.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"3,00,001 से 5,00,000 तक\",\"8,00,001 से 12,00,000 तक\")","v":"8,00,001 से 12,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tx Reb.US 87A up to 12 Lakh)\")","v":"10% (With Tx Reb.US 87A up to 12 Lakh)"},null,{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10%(With Tx Reb.US 87A up to 12 Lakh)\")","v":"10%(With Tx Reb.US 87A up to 12 Lakh)"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"10% (With Tx Reb.US 87A up to 12 Lakh)\")","v":"10% (With Tx Reb.US 87A up to 12 Lakh)"},null,null,"Rs.",{"$f":"AD69","v":{"v":14991,"d":"14991.00"}},{"$nulls":6},">400000",">800000",">1200000",">1600000",">2000000",">2400000",">5000000",">10000000","Surcharge",{"$nulls":3},{"$f":"IF(Q48>50000000,5,IF(Q48>20000000,4,IF(Q48>10000000,3,IF(Q48>5000000,2,IF(Q48>1200000,1,0)))))","v":0},{"$f":"IF(AJ53=1,Q48-1200000,0)","v":0},{"$f":"IF(AJ53=2,Q48-5000000,0)","v":0},{"$f":"IF($AJ$53=3,$Q$48-10000000,0)","v":0},{"$f":"IF($AJ$53=3,$Q$48-20000000,0)","v":0},{"$f":"IF($AJ$53=3,$Q$48-50000000,0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"5,00,001 से 10,00,000 तक\",\"12,00,001 से 16,00,000 तक\")","v":"12,00,001 से 16,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"15%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"15%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"15%"},null,null,"Rs.",{"$f":"AD68","v":{"v":0,"d":"0.00"}},{"$nulls":6},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>2400000,3,IF($Q$48>2000000,4,IF($Q$48>1600000,5,IF($Q$48>1200000,6,IF($Q$48>800000,7,IF($Q$48>400000,8,0))))))))","v":7},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>2400000,3,IF($Q$48>2000000,4,IF($Q$48>1600000,5,IF($Q$48>1200000,6,IF($Q$48>800000,7,0)))))))","v":7},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>2400000,3,IF($Q$48>2000000,4,IF($Q$48>1600000,5,IF($Q$48>1200000,6,0))))))","v":0},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>2400000,3,IF($Q$48>2000000,4,IF($Q$48>1600000,5,0)))))","v":0},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>2400000,3,IF($Q$48>2000000,4,0))))","v":0},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>2400000,3,0)))","v":0},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,0))","v":0},{"$f":"IF($Q$48>10000000,1,0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"10,00,001 अथवा इससे ऊपर\",\"16,00,001 से 20,00,000 तक\")","v":"16,00,001 से 20,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"20%"},null,null,"Rs.",{"$f":"AD67","v":{"v":0,"d":"0.00"}},{"$nulls":5},"A",{"$f":"IF(X54>=8,($Q$48-400000)*0.05,IF(X54=0,0,20000))","v":20000},{"$f":"IF(Y54>=7,($Q$48-800000)*0.1,IF(Y54=0,0,40000))","v":14991},{"$f":"IF(Z54>=6,($Q$48-1200000)*0.15,IF(Z54=0,0,60000))","v":0},{"$f":"IF(AA54>=5,ROUND(($Q$48-1600000)*0.2,0),IF(AA54=0,0,80000))","v":0},{"$f":"IF(AB54>=4,ROUND(($Q$48-2000000)*0.25,0),IF(AB54=0,0,100000))","v":0},{"$f":"IF(AC54=0,0,ROUND((Q48-2400000)*0.3,0))","v":0},{"$f":"IF(OR(AE54>=1,AD54=0),0,ROUND((Q48-1500000)*0.3,0))","v":0},{"$f":"IF(AE54>=1,ROUND(($Q$48-1500000)*0.3,0),0)","v":0},{"$f":"IF(Q48>20000000,AI55*0.25,IF(Q48>10000000,AI55*0.15,IF(Q48>5000000,AI55*0.1,0)))","v":0},null,null,{"$f":"SUM(AD72:AE72)","v":34991},null,{"$f":"IF(AND(AJ53=1,AK53<=AI55),AK53,IF(AND(AJ53=2,AL53<=AI58),AL53+1200000,IF(AND(AJ53=3,AM53<=AI59),AL53+2970000+AM55,0)))","v":0},{"$f":"ROUND(AL53*0.1,0)","v":0},{"$f":"ROUND(AM53*0.15,0)","v":0},{"$f":"ROUND(AN53*0.25,0)","v":0},{"$f":"ROUND(AO53*0.37,0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"-------\",\"20,00,001 से 24,00,000 तक\")","v":"20,00,001 से 24,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"25%\")","v":"25%"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"25%\")","v":"25%"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"25%\")","v":"25%"},null,null,"Rs.",{"$f":"AD66","v":{"v":0,"d":"0.00"}},{"$nulls":17},{"$f":"IF(AI55<60000,0,60000)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"-------\",\"24,00,001 तथा इससे ऊपर\")","v":"24,00,001 तथा इससे ऊपर"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"30%"},null,null,{"$f":"IF(Q48<5000000,\"\",\"Rs.\")","v":""},{"$f":"AD61","v":{"v":0,"d":"0.00"}},{"$nulls":9},"Total Taxable Income",{"$f":"Q48","v":{"v":949910,"d":"949910.00"}},"Diff.","Itax","Surcharge"]
[null,null,"(1) योग आयकर",{"$nulls":12},"Rs.",{"$f":"ROUND(SUM(Q51:Q57),0)","v":{"v":34991,"d":"34991.00"}},{"$nulls":6},{"$f":"IF(Q48>1200000,(Q48-1200000),0)","v":0},{"$nulls":10},{"$f":"IF(AI55<1200000,0,AI55-1200000)","v":0},null,{"$f":"IF(AND(AK55>0,AJ53=1),AK55,IF(AND(AK55>0,AJ53=2),AK55,IF(AND(AK55>0,AJ53=3),AK55,AI55)))","v":34991},{"$f":"SUM(AL55:AO55)","v":0}]
[null,null,"87 A",{"$nulls":12},"Rs.",{"$f":"IF(Q48<=1200000,Q58,0)","v":{"v":34991,"d":"34991.00"}},{"$nulls":6},{"$f":"IF(X58<60000,Q58-X58,0)","v":34991},{"$nulls":10},{"$f":"IF(AI55<2970000,0,AI55-2970000)","v":0}]
[null,null,"115 BAC",{"$nulls":12},"Rs.",{"$f":"IF(Q48<=1200000,0,X59)","v":{"v":0,"d":"0.00"}}]
[null,null,"(2)  छूट धारा 87 (A) (नई स्लैब में 12 लाख की कर योग्य आय पर 60000/- तक राहत) \n        Or 115 BAC  (Marginal Relief) (नई स्लैब में कर योग्य आय कर से न्यून होने की स्थिति में)",{"$nulls":12},"Rs.",{"$f":"SUM(Q59:Q60)","v":{"v":34991,"d":"34991.00"}},{"$nulls":9},"Above 5 Crore",{"$f":"IF($AB$57>50000000,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AB61=\"Yes\",($AB$57-50000000),0)","v":0},{"$f":"IF(AND(AB65=\"Yes\",AC65>0),ROUND(AC65*0.3,0),0)","v":0},{"$f":"IF(AB61=\"Yes\",ROUND(AC61*0.37,0),0)","v":0}]
[null,null,"(3) शेष आयकर (1-2) {87 (A)  के तहत राहत अथवा Marginal Relief  के पश्चात}",{"$nulls":12},"Rs.",{"$f":"ROUND(Q58-Q61,0)","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"ROUND(Q47,-1)","v":{"v":949910,"d":"949910.00"}},null,"Above 2 Crore",{"$f":"IF($AB$57>20000000,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AB62=\"Yes\",($AB$57-20000000),0)","v":0},null,{"$f":"IF(AND(AB62=\"Yes\",AB61=\"Yes\"),0,ROUND(AC62*0.25,0))","v":0}]
[null,null,"(4) अधिभार (Surcharge)  {50 लाख 1 रु.से 1 करोड़ तक आय के कर पर 10%,1 करोड़ 1 रु.से 2 करोड़ तक आय के कर पर 15%, \n                                                         2 करोड़ 1 रु.से 5 करोड़ तक आय के कर पर 25% तथा 5 करोड़ से ऊपरी आय के कर पर 37%}",{"$nulls":12},"Rs.",{"$f":"AE72","v":{"v":0,"d":"0.00"}},{"$nulls":9},"Above 1 Crore",{"$f":"IF($AB$57>10000000,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AB63=\"Yes\",($AB$57-10000000),0)","v":0},null,{"$f":"IF(AND(AB63=\"Yes\",AB62=\"Yes\"),0,ROUND(AC63*0.15,0))","v":0}]
[null,null,"(5) अधिभार (Surcharge) को मिलाकर आयकर (3+4)",{"$nulls":12},"Rs.",{"$f":"SUM(Q62:Q63)","v":{"v":0,"d":"0.00"}},{"$nulls":9},"Above 50 Lac",{"$f":"IF($AB$57>5000000,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AB64=\"Yes\",($AB$57-5000000),0)","v":0},null,{"$f":"IF(AND(AB64=\"Yes\",AB63=\"Yes\"),0,ROUND(AC64*0.1,0))","v":0}]
[null,null,"(6) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q64*0.04,0)","v":{"v":0,"d":"0.00"}},{"$nulls":9},"Above 24 Lac",{"$f":"IF($AB$57>2400000,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AB65=\"Yes\",($AB$57-2400000),0)","v":0},null,0]
[null,null,"कुल आयकर (5+6)",{"$nulls":12},"Rs.",{"$f":"SUM(Q64:Q65)","v":{"v":0,"d":"0.00"}},{"$nulls":9},"Above 20 Lac",{"$f":"IF($AB$57>2000000,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AB66=\"Yes\",($AB$57-2000000),0)","v":0},{"$f":"IF(AND(AB66=\"Yes\",AC65>0),100000,ROUND(AC66*0.25,0))","v":0}]
[null,17,"घटाइए :- धारा 89 के अंतर्गत राहत Rule 21A(2)",{"$nulls":12},"Rs.",{"v":0,"d":"0.00"},{"$nulls":9},"Above 16 Lac",{"$f":"IF($AB$57>1600000,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AB67=\"Yes\",($AB$57-1600000),0)","v":0},{"$f":"IF(AND(AB67=\"Yes\",AC66>0),80000,ROUND(AC67*0.2,0))","v":0}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"Rs.",{"$f":"Q66-Q67","v":{"v":0,"d":"0.00"}},{"$nulls":9},"Above 12 Lac",{"$f":"IF($AB$57>1200000,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AB68=\"Yes\",($AB$57-1200000),0)","v":0},{"$f":"IF(AND(AB68=\"Yes\",AC67>0),60000,ROUND(AC68*0.15,0))","v":0}]
[null,null,"कुल शेष आयकर की राशि (दस के गुणक में)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q68,-1)","v":{"v":0,"d":"0.00"}},{"$nulls":9},"Above 8 Lac",{"$f":"IF($AB$57>800000,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(AB69=\"Yes\",($AB$57-800000),0)","v":149910},{"$f":"IF(AND(AB69=\"Yes\",AC68>0),40000,ROUND(AC69*0.1,0))","v":14991}]
[null,19,"आयकर कटौती का विवरण","Itax deducted Till Jun-2025 (First Quarter)",null,"Itax deducted \nJuly-25 to Sep.-25\n(Second Quarter)",null,null,"Itax deducted Oct-25 to Dec.-25 (Third Quarter)","Itax Deducted/Dedctable by Dec.25 Salary","Itax Deducted/Dedctable by Jan-26 Salary","Itax Deducted/Dedctable by Feb-26 Salary","Itax Deducted addition to Salary ",null,"Itax submitted by other means","बिंदु 19 का योग ",{"$nulls":10},"Above 4 Lac",{"$f":"IF($AB$57>400000,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(AB70=\"Yes\",($AB$57-400000),0)","v":549910},{"$f":"IF(AND(AB70=\"Yes\",AC69>0),20000,ROUND(AC70*0.05,0))","v":20000}]
[{"$nulls":3},{"$f":"SUM('GA-55'!AA9:AA11)","v":6000},null,{"$f":"SUM('GA-55'!AA12:AA14)","v":6000},null,null,{"$f":"SUM('GA-55'!AA15:AA17)","v":6000},{"$f":"'GA-55'!AA18","v":2000},{"$f":"'GA-55'!AA19","v":2000},{"$f":"'GA-55'!AA20","v":2000},{"$f":"SUM('GA-55'!AA21:AA30)","v":0},null,{"$f":"'Basic Data'!N20","v":0},"Rs.",{"$f":"SUM(D71:O71)","v":{"v":24000,"d":"24000.00"}},{"$nulls":9},"Below 4 Lac",{"$f":"IF($AB$57<=400000,\"Yes\",\"No\")","v":"No"},"-----",0]
[{"$nulls":3},"Income Tax Refundable/Payble\nHere Refundable figure Show Positive & Green Color and Payble figure Show Negative & Red Colour ",{"$nulls":7},{"$f":"IF(Q71>Q69,\"(Refundable)\",\"(Payble)\")","v":"(Refundable)"},{"$nulls":3},"Rs.",{"$f":"Q71-Q69","v":{"v":24000,"d":"24000.00"}},{"$nulls":9},"Total",null,null,{"$f":"SUM(AD61:AD71)","v":34991},{"$f":"SUM(AE61:AE71)","v":0}]
[null,{"$f":"'GA-55'!B32","v":"Siganture of Employee(a)"},{"$nulls":8},{"$f":"'GA-55'!P32","v":"Signature of DDO ()"}]

{"sheet":"Old Regime Calc. Report","index":5,"n_rows":70,"n_cols":39,"rows_kept":70,"merged":[[0,0,70,0],[0,1,0,16],[0,17,70,17],[0,19,0,25],[1,1,1,9],[1,10,1,12],[1,13,1,16],[1,19,6,25],[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],[7,18,9,18],[7,19,9,22],[7,23,9,25],[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],[10,19,10,25],[11,2,12,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[11,12,11,14],[11,18,13,18],[11,19,13,22],[11,23,13,25],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,2,13,14],[14,2,14,14],[14,19,14,25],[15,1,17,1],[15,2,17,2],[15,4,15,14],[15,19,71,25],[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,62,1],[48,2,48,16],[49,2,49,7],[49,8,49,9],[49,10,49,11],[49,12,49,14],[50,2,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,14],[51,2,51,7],[51,8,51,9],[51,10,51,11],[51,12,51,14],[52,2,52,7],[52,8,52,9],[52,10,52,11],[52,12,52,14],[53,2,53,7],[53,8,53,9],[53,10,53,11],[53,12,53,14],[54,2,54,7],[54,8,54,9],[54,10,54,11],[54,12,54,14],[55,2,55,7],[55,8,55,9],[55,10,55,11],[55,12,55,14],[56,2,56,14],[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,2,63,14],[64,1,65,1],[64,2,64,14],[65,2,65,14],[66,1,68,1],[66,2,68,2],[66,3,66,4],[66,5,66,7],[66,12,66,13],[66,15,66,16],[67,3,67,4],[67,5,67,7],[67,12,67,13],[68,3,68,10],[68,11,68,14],[69,1,70,9],[69,10,70,16]]}
[null,{"$f":"'Exemp.(HRA+Other) & Other incom'!A1","v":"Office: Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
[null,{"$f":"CONCATENATE(\"Income Tax Calculation F.Y.\",\":-\", 'Basic Data'!Q6)","v":"Income Tax Calculation F.Y.:-2025-26"},{"$nulls":8},{"$f":"CONCATENATE(\"(\",\"A.Y.\",\":-\",AC4,\")\")","v":"(A.Y.:-2026-27)"},null,null,"Old Tax Regime",{"$nulls":5},"Comparison of Itax calculation in Old and New Tax Regime",{"$nulls":8},{"$f":"YEAR('GA-55'!C9)","v":2025},{"$f":"AC2+1","v":2026}]
[null,1,"कर्मचारी का नाम :-",null,{"$f":"'GA-55'!F3","v":"a"},{"$nulls":5},"पद :-",{"$f":"'GA-55'!P3","v":"Teacher"},null,null,"PAN :",{"$f":"'GA-55'!F5","v":"ABCDE1234F"},{"$nulls":12},{"$f":"YEAR('GA-55'!C19)","v":2026},{"$f":"AC3+1-2000","v":27}]
[null,2,"आय:वर्ष 2025-26 में कुल प्राप्त वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"Rs.",{"$f":"'GA-55'!O31","v":{"v":1024910,"d":"1024910.00"}},{"$nulls":11},{"$f":"CONCATENATE(AD2,\"-\",AD3)","v":"2026-27"}]
[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":60840,"d":"60840.00"}}]
[null,4,"                                                             शेष (2-3)",{"$nulls":12},"Rs.",{"$f":"Q4-Q5","v":{"v":964070,"d":"964070.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":0,"d":"0.00"}},{"$nulls":5},{"$f":"X8-X12","v":{"v":77170,"d":"77170.00"}},"Tax Calculate by Old Tax Regime",{"$nulls":3},{"$f":"Q66","v":{"v":77170,"d":"₹ 77,170.00"}}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction)-अधिकतम 50,000",{"$nulls":9},{"v":50000,"d":"50000.00"},null,null,"Rs.",{"$f":"M7+M8+M9","v":{"v":50000,"d":"50000.00"}}]
[null,6,"                                                             शेष (4-5)",{"$nulls":12},"Rs.",{"$f":"Q6-Q9","v":{"v":914070,"d":"914070.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":5},{"$f":"X12-X8","v":{"v":-77170,"d":"-77170.00"}},"Tax Calculate by New Tax Regime",{"$nulls":3},{"$f":"'New Regime Calc. Report'!Q69","v":{"v":0,"d":"₹ 0.00"}}]
[{"$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":914070,"d":"914070.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":914070,"d":"914070.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\",'GA-55'!Q31,0)","v":{"v":60000,"d":"60000.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\",'GA-55'!T31+'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\",'GA-55'!P31,0)","v":{"v":43484,"d":"43484.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\",'GA-55'!U31,0)","v":{"v":2100,"d":"2100.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":105584,"d":"105584.00"}}]
[null,null,"                      अधिकतम कटौती की राशि  1.50 लाख रूपये तक",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"new tax regime\",0,IF(O32>=150000,150000,O32))","v":{"v":105584,"d":"105584.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":105584,"d":"105584.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":16},">250000",">300000",">500000",">1000000",null,"Surcharge"]
[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":16},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,IF($Q$48>250000,4,0))))","v":2},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,0)))","v":2},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,0))","v":2},{"$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":15},"A",{"$f":"IF(AH42>=1,2500,0)","v":2500},{"$f":"IF(AI42=3,ROUND((Q48-300000)*0.05,0),IF(AI42=0,0,10000))","v":10000},{"$f":"IF($AJ$42=2,($Q$48-500000)*0.2,IF($AJ$42=1,100000,0))","v":61698},{"$f":"IF($AK$42>0,($Q$48-1000000)*0.3,0)","v":0},{"$f":"SUM(AH43:AK43)","v":74198},{"$f":"IF($Q$48>50000000,AL43*0.37,IF($Q$48>20000000,AL43*0.25,IF($Q$48>10000000,Y65*0.15,IF($Q$48>5000000,Y65*0.1,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":15},"B",{"v":0,"d":"0.00"},{"$f":"IF(AI42=3,ROUND((Q48-300000)*0.05,0),IF(AI42=0,0,10000))","v":10000},{"$f":"IF($AJ$42=2,($Q$48-500000)*0.2,IF($AJ$42=1,100000,0))","v":61698},{"$f":"IF($AK$42>0,($Q$48-1000000)*0.3,0)","v":0},{"$f":"SUM(AH44:AK44)","v":71698},{"$f":"IF($Q$48>50000000,AL44*0.37,IF($Q$48>20000000,AL44*0.25,IF($Q$48>10000000,Y66*0.15,IF($Q$48>5000000,Y66*0.1,0))))","v":0}]
[null,null,"कुल योग 12 (1 से 8)",{"$nulls":12},"Rs.",{"$f":"SUM(Q37:Q44)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"C",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF($AJ$42=2,($Q$48-500000)*0.2,IF($AJ$42=1,100000,0))","v":61698},{"$f":"IF($AK$42>0,($Q$48-1000000)*0.3,0)","v":0},61698,{"$f":"IF($Q$48>50000000,AL45*0.37,IF($Q$48>20000000,AL45*0.25,IF($Q$48>10000000,Y67*0.15,IF($Q$48>5000000,Y67*0.1,0))))","v":0}]
[null,13,"कुल कटौती (11 एवं 12)",{"$nulls":12},"Rs.",{"$f":"Q35+Q45","v":{"v":105584,"d":"105584.00"}}]
[null,14,"कर योग्य आय (10-13)",{"$nulls":12},"Rs.",{"$f":"Q20-Q46","v":{"v":808486,"d":"808486.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288A",{"$nulls":12},"Rs.",{"$f":"ROUND(Q47,-1)","v":{"v":808490,"d":"808490.00"}},{"$nulls":13},{"$f":"IF(N2=\"Old tax regime\",\"O\",\"N\")","v":"O"},{"$f":"'Basic Data'!Q10","v":"A"},{"$f":"CONCATENATE(AE48,AF48)","v":"OA"}]
[null,16,"उपरोक्त बिंदु 15 के आधार पर आयकर की गणना "]
[null,null,"Income Slab",{"$nulls":5},"सामान्य करदाता",null,"वरिष्ठ नागरिक (आयु 60 से 80 वर्ष)",null,"81 वर्ष या अधिक आयु "]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,000 तक\",\"4,00,000 तक\")","v":"2,50,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,001 से 3,00,000 तक\",\"4,00,001 से 8,00,000 तक\")","v":"2,50,001 से 3,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"Nil"},null,null,"Rs.",{"$f":"IF(OR($AG$48=\"NA\",$AG$48=\"NB\",$AG$48=\"NC\"),AH55,IF($AG$48=\"OA\",AH43,IF($AG$48=\"OB\",AH44,IF($AG$48=\"OC\",AH45,0))))","v":{"v":2500,"d":"2500.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"3,00,001 से 5,00,000 तक\",\"8,00,001 से 12,00,000 तक\")","v":"3,00,001 से 5,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"Nil"},null,null,"Rs.",{"$f":"IF(OR($AG$48=\"NA\",$AG$48=\"NB\",$AG$48=\"NC\"),AI55,IF($AG$48=\"OA\",AI43,IF($AG$48=\"OB\",AI44,IF($AG$48=\"OC\",AI45,0))))","v":{"v":10000,"d":"10000.00"}},{"$nulls":16},">300000",">600000",">900000",">1200000",">1500000"]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"5,00,001 से 10,00,000 तक\",\"12,00,001 से 16,00,000 तक\")","v":"5,00,001 से 10,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,null,"Rs.",{"$f":"IF(OR($AG$48=\"NA\",$AG$48=\"NB\",$AG$48=\"NC\"),AJ55,IF($AG$48=\"OA\",AJ43,IF($AG$48=\"OB\",AJ44,IF($AG$48=\"OC\",AJ45,0))))","v":{"v":61698,"d":"61698.00"}},{"$nulls":16},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,IF($Q$48>900000,3,IF($Q$48>600000,4,IF($Q$48>300000,5,0)))))","v":4},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,IF($Q$48>900000,3,IF($Q$48>600000,4,0))))","v":4},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,IF($Q$48>900000,3,0)))","v":0},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,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,00,001 से 15,00,000 तक\")","v":"10,00,001 अथवा इससे ऊपर"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,null,"Rs.",{"$f":"IF(OR($AG$48=\"NA\",$AG$48=\"NB\",$AG$48=\"NC\"),AK55,IF($AG$48=\"OA\",AK43,IF($AG$48=\"OB\",AK44,IF($AG$48=\"OC\",AK45,0))))","v":{"v":0,"d":"0.00"}},{"$nulls":15},"A",{"$f":"IF(AH54>=5,ROUND(($Q$48-300000)*0.05,0),IF(AH54=0,0,15000))","v":15000},{"$f":"IF(AI54>=4,ROUND(($Q$48-600000)*0.1,0),IF(AI54=0,0,30000))","v":20849},{"$f":"IF($AJ$54>=3,ROUND(($Q$48-900000)*0.15,0),IF($AJ$54=0,0,45000))","v":0},{"$f":"IF($AK$54>=2,ROUND(($Q$48-1200000)*0.2,0),IF($AK$54=0,0,60000))","v":0},{"$f":"IF($AL$54>0,ROUND(($Q$48-1500000)*0.3,0),0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,001 अथवा इससे ऊपर\")","v":"----"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,null,"Rs.",{"$f":"IF($AE$48=\"O\",0,AL55)","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":10000},{"$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}]
[null,null,"(1) योग आयकर",{"$nulls":12},"Rs.",{"$f":"SUM(Q51:Q56)","v":{"v":74198,"d":"74198.00"}}]
[null,null,"(2) छूट धारा 87 (A) (पुरानी स्लैब में 5 लाख की कर योग्य आय पर छुट अधिकतम रु. 12500/- व नई स्लैब में 12 लाख की कर योग्य आय पर 60000/- तक राहत)",{"$nulls":12},"Rs.",{"$f":"IF(AND(AE48=\"o\",Q57<=12500),Q57,IF(AND(AE48=\"n\",Q57<=25000),Q57,0))","v":{"v":0,"d":"0.00"}}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},"Rs.",{"$f":"Q57-Q58","v":{"v":74198,"d":"74198.00"}}]
[null,null,"(4) अधिभार (Surcharge)  {50 लाख 1 रु.से 1 करोड़ तक आय के कर पर 10%,1 करोड़ 1 रु.से 2 करोड़ तक आय के कर पर 15%, \n                                                         2 करोड़ 1 रु.से 5 करोड़ तक आय के कर पर 25% तथा 5 करोड़ से ऊपरी आय के कर पर 37%}",{"$nulls":12},"Rs.",{"$f":"'New Regime Calc. Report'!Q63","v":{"v":0,"d":"0.00"}}]
[null,null,"(5) अधिभार (Surcharge) को मिलाकर आयकर (3+4)",{"$nulls":12},"Rs.",{"$f":"SUM(Q59:Q60)","v":{"v":74198,"d":"74198.00"}}]
[null,null,"(6) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q59*0.04,0)","v":{"v":2968,"d":"2968.00"}}]
[null,null,"कुल आयकर (5+6)",{"$nulls":12},"Rs.",{"$f":"Q61+Q62","v":{"v":77166,"d":"77166.00"}}]
[null,17,"घटाइए :- धारा 89 के अंतर्गत राहत Rule 21A(2)",{"$nulls":12},"Rs.",{"v":0,"d":"0.00"}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"Rs.",{"$f":"Q63-Q64","v":{"v":77166,"d":"77166.00"}}]
[null,null,"कुल शेष आयकर की राशि (दस के गुणक में)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q65,-1)","v":{"v":77170,"d":"77170.00"}}]
[null,19,"आयकर कटौती का विवरण","Itax deducted Till Jun-25 (First Quarter)",null,"Itax deducted  July-25 to Sep-25\n (Second Quarter)",null,null,"Itax deducted Oct-25 to Dec-25\n(Third Quarter)","Itax Deducted/Dedctable by Dec-25 Salary","Itax Deducted/Dedctable by Jan-26 Salary","Itax Deducted/Dedctable by Feb-26 Salary","Itax Deducted addition to Salary ",null,"Itax submitted by other means","बिंदु 19 का योग "]
[{"$nulls":3},{"$f":"SUM('GA-55'!AA9:AA11)","v":6000},null,{"$f":"SUM('GA-55'!AA12:AA14)","v":6000},null,null,{"$f":"SUM('GA-55'!AA15:AA17)","v":6000},{"$f":"'GA-55'!AA18","v":2000},{"$f":"'GA-55'!AA19","v":2000},{"$f":"'GA-55'!AA20","v":2000},{"$f":"SUM('GA-55'!AA21:AA30)","v":0},null,{"$f":"'Basic Data'!N20","v":0},"Rs.",{"$f":"SUM(D68:O68)","v":{"v":24000,"d":"24000.00"}}]
[{"$nulls":3},"Income Tax Refundable/Payble\nHere Refundable figure Show Positive & Green Color and Payble figure Show Negative & Red Colour ",{"$nulls":7},{"$f":"IF(Q68>Q66,\"(Refundable)\",\"(Payble)\")","v":"(Payble)"},{"$nulls":3},"Rs.",{"$f":"Q68-Q66","v":{"v":-53170,"d":"-53170.00"}}]
[null,{"$f":"'GA-55'!B32","v":"Siganture of Employee(a)"},{"$nulls":8},{"$f":"'GA-55'!P32","v":"Signature of DDO ()"}]

{"sheet":"OLD REGIME","index":6,"n_rows":68,"n_cols":26,"rows_kept":68,"hidden":true,"merged":[[0,0,68,0],[0,1,0,16],[0,17,68,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,60,1],[48,2,48,16],[49,2,49,7],[49,8,49,9],[49,10,49,11],[49,12,49,14],[50,2,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,14],[51,2,51,7],[51,8,51,9],[51,10,51,11],[51,12,51,14],[52,2,52,7],[52,8,52,9],[52,10,52,11],[52,12,52,14],[53,2,53,7],[53,8,53,9],[53,10,53,11],[53,12,53,14],[54,2,54,7],[54,8,54,9],[54,10,54,11],[54,12,54,14],[55,2,55,7],[55,8,55,9],[55,10,55,11],[55,12,55,14],[56,2,56,14],[57,2,57,14],[58,2,58,14],[59,2,59,14],[60,2,60,14],[61,2,61,14],[62,1,63,1],[62,2,62,14],[63,2,63,14],[64,1,66,1],[64,2,66,2],[64,3,64,4],[64,5,64,7],[64,12,64,13],[64,15,64,16],[65,3,65,4],[65,5,65,7],[65,12,65,13],[66,3,66,10],[66,11,66,14],[67,1,68,9],[67,10,68,16]]}
[null,{"$f":"'Exemp.(HRA+Other) & Other incom'!A1","v":"Office: Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
[null,"Income Tax Calculation F.Y. 2024-25 (A.Y.2025-26)",{"$nulls":11},"Old Tax Regime"]
[null,1,"कर्मचारी का नाम :-",null,{"$f":"'GA-55'!F3","v":"a"},{"$nulls":5},"पद :-",{"$f":"'GA-55'!P3","v":"Teacher"},null,null,"PAN :",{"$f":"'GA-55'!F5","v":"ABCDE1234F"}]
[null,2,"आय:वर्ष 2024-25 में कुल प्राप्त वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"Rs.",{"$f":"'GA-55'!O31","v":{"v":1024910,"d":"1024910.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":60840,"d":"60840.00"}}]
[null,4,"                                                             शेष (2-3)",{"$nulls":12},"Rs.",{"$f":"Q4-Q5","v":{"v":964070,"d":"964070.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":0,"d":"0.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":50000,"d":"50000.00"}}]
[null,6,"                                                             शेष (4-5)",{"$nulls":12},"Rs.",{"$f":"Q6-Q9","v":{"v":914070,"d":"914070.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":914070,"d":"914070.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":914070,"d":"914070.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\",'GA-55'!Q31,0)","v":{"v":60000,"d":"60000.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\",'GA-55'!T31+'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\",'GA-55'!P31,0)","v":{"v":43484,"d":"43484.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\",'GA-55'!U31,0)","v":{"v":2100,"d":"2100.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":105584,"d":"105584.00"}}]
[null,null,"                      अधिकतम कटौती की राशि  1.50 लाख रूपये तक",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"new tax regime\",0,IF(O32>=150000,150000,O32))","v":{"v":105584,"d":"105584.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":105584,"d":"105584.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":2},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,0)))","v":2},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,0))","v":2},{"$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>=1,2500,0)","v":2500},{"$f":"IF(X42=3,ROUND((Q48-300000)*0.05,0),IF(X42=0,0,10000))","v":10000},{"$f":"IF(Y42=2,($Q$48-500000)*0.2,IF(Y42=1,100000,0))","v":61698},{"$f":"IF(Z42>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":10000},{"$f":"IF(Y42=2,($Q$48-500000)*0.2,IF(Y42=1,100000,0))","v":61698},{"$f":"IF(Z42>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"},{"$f":"IF(Y42=2,($Q$48-500000)*0.2,IF(Y42=1,100000,0))","v":61698},{"$f":"IF(Z42>0,($Q$48-1000000)*0.3,0)","v":0}]
[null,13,"कुल कटौती (11 एवं 12)",{"$nulls":12},"Rs.",{"$f":"Q35+Q45","v":{"v":105584,"d":"105584.00"}}]
[null,14,"कर योग्य आय (10-13)",{"$nulls":12},"Rs.",{"$f":"Q20-Q46","v":{"v":808486,"d":"808486.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288A",{"$nulls":12},"Rs.",{"$f":"ROUND(Q47,-1)","v":{"v":808490,"d":"808490.00"}},null,null,{"$f":"'Old Regime Calc. Report'!AF48","v":"A"},{"$f":"'Basic Data'!F10","v":"rjjo20212251115"},{"$f":"CONCATENATE(T48,U48)","v":"Arjjo20212251115"}]
[null,16,"उपरोक्त बिंदु 15 के आधार पर आयकर की गणना "]
[null,null,"Income Slab",{"$nulls":5},"सामान्य करदाता",null,"वरिष्ठ नागरिक (आयु 60 से 80 वर्ष)",null,"81 वर्ष या अधिक आयु "]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,000 तक\",\"3,00,000 तक\")","v":"2,50,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,001 से 3,00,000 तक\",\"3,00,001 से 6,00,000 तक\")","v":"2,50,001 से 3,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"Nil"},null,null,"Rs.",{"$f":"IF(T48=\"a\",W43,IF(T48=\"B\",W44,W45))","v":{"v":2500,"d":"2500.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"3,00,001 से 5,00,000 तक\",\"6,00,001 से 9,00,000 तक\")","v":"3,00,001 से 5,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"Nil"},null,null,"Rs.",{"$f":"IF(T48=\"a\",X43,IF(T48=\"B\",X44,X45))","v":{"v":10000,"d":"10000.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"5,00,001 से 10,00,000 तक\",\"9,00,001 से 12,00,000 तक\")","v":"5,00,001 से 10,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,null,"Rs.",{"$f":"IF(T48=\"a\",Y43,IF(T48=\"B\",Y44,Y45))","v":{"v":61698,"d":"61698.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"10,00,001 अथवा इससे ऊपर\",\"12,00,001 से 15,00,000 तक\")","v":"10,00,001 अथवा इससे ऊपर"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,null,"Rs.",{"$f":"IF(T48=\"a\",Z43,IF(T48=\"B\",Z44,Z45))","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,001 अथवा इससे ऊपर\")","v":"----"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,"(1) योग आयकर",{"$nulls":12},"Rs.",{"$f":"SUM(Q51:Q56)","v":{"v":74198,"d":"74198.00"}}]
[null,null,"(2) छूट धारा 87 (A) (2.50 लाख से 5.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रूपये 12,500 तक)",{"$nulls":12},"Rs.",{"$f":"IF(Q57<=12500,Q57,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},"Rs.",{"$f":"Q57-Q58","v":{"v":74198,"d":"74198.00"}}]
[null,null,"(4) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q59*0.04,0)","v":{"v":2968,"d":"2968.00"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":12},"Rs.",{"$f":"Q59+Q60","v":{"v":77166,"d":"77166.00"}}]
[null,17,"घटाइए :- धारा 89 के अंतर्गत राहत Rule 21A(2)",{"$nulls":12},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!Q26","v":{"$error":"#REF!"}}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"Rs.",{"$f":"Q61-Q62","v":{"$error":"#REF!"}}]
[null,null,"कुल शेष आयकर की राशि (दस के गुणक में)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q63,-1)","v":{"$error":"#REF!"}}]
[null,19,"आयकर कटौती का विवरण","Itax deducted Till Jun-2024 (First Quarter)",null,"Itax deducted  July-24 to Sep.-24      (Second Quarter)",null,null,"Itax deducted Oct-24 to Dec.-24 (Third Quarter)","Itax Deducted/Dedctable by Dec.24 Salary","Itax Deducted/Dedctable by Jan-25 Salary","Itax Deducted/Dedctable by Feb-25 Salary","Itax Deducted addition to Salary ",null,"Itax submitted by other means","बिंदु 19 का योग "]
[{"$nulls":3},{"$f":"SUM('GA-55'!AA9:AA11)","v":6000},null,{"$f":"SUM('GA-55'!AA12:AA14)","v":6000},null,null,{"$f":"SUM('GA-55'!AA15:AA17)","v":6000},{"$f":"'GA-55'!AA18","v":2000},{"$f":"'GA-55'!AA19","v":2000},{"$f":"'GA-55'!AA20","v":2000},{"$f":"SUM('GA-55'!AA21:AA30)","v":0},null,{"$f":"'Basic Data'!N20","v":0},"Rs.",{"$f":"SUM(D66:O66)","v":{"v":24000,"d":"24000.00"}}]
[{"$nulls":3},"Income Tax Refundable/Payble",{"$nulls":7},{"$f":"IF(Q66>Q64,\"(Refundable)\",\"(Payble)\")","v":{"$error":"#REF!"}},{"$nulls":3},"Rs.",{"$f":"Q66-Q64","v":{"$error":"#REF!"}}]
[null,{"$f":"'GA-55'!B32","v":"Siganture of Employee(a)"},{"$nulls":8},{"$f":"'GA-55'!P32","v":"Signature of DDO ()"}]

{"sheet":"Itax Calculate For All Emp.","index":7,"n_rows":106,"n_cols":54,"rows_kept":106,"hidden":true,"merged":[[0,2,5,2],[0,3,0,40],[0,41,106,41],[1,3,1,40],[2,3,2,40],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,14,3,20],[3,21,3,29],[3,30,4,30],[3,31,3,33],[3,34,3,36],[3,37,4,37],[3,39,4,40],[5,31,5,33],[5,39,5,40],[5,42,5,47],[5,48,5,53],[6,2,105,2],[106,3,106,36]]}
[{"$nulls":3},"Prepared By :- Ummed Tarad (GSSS Raimalwada) (Updated On 20-10-2023)"]
[{"$nulls":3},{"$f":"CONCATENATE('Basic Data'!G5,\" \",\"(\",'Basic Data'!M5,'Basic Data'!O5,\")\")","v":"Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
[{"$nulls":3},"Tax Calculation For All Employee For F.Y. 2024-25 (A.Y. 2025-26)"]
[{"$nulls":3},"Sr. No.","Name Of Employee","Total Income \n(As GA-55 Gross Salary)","HRA Examption","Examption Uder Home Loan","Examption U/S VI [80 C/80 CCC/ 80CCD(1)] Up To 1.5 Lac","Exapmtion U/S 80 CCD(1B) Up To 50000","Exapmtion U/S 80 D/80 DD/80/ 80DDB ","Exapmtion U/S 80 G","NET TAXABLE INCOME (For Old Tax Regime)\n","NET TAXABLE INCOME (For New Tax Regime)","Income Tax\n(OLD TAX REGIME)",{"$nulls":6},"Income Tax \n(NEW TAX REGIME)",{"$nulls":8},"CHOICE (Old Rate/New Rate)","जन.-2025 के वेतन तक की गई Itax कटौती",null,null,"अग्रिम शेष माह में की जाने वाली Itax कटौती",null,null,"Total Deductable Itax",null,"Payble (P), Refundable (R) Itax"]
[{"$nulls":12},"[Colmn 3-{4+5+6+-8+9}-Stand.Ded.50000]","[Colmn 3-Stand.Ded.75000]","2.5 Lac to 5 Lac","5 Lac to 10 Lac",">10 Lac","Total","Edu. Cess (4%)","Grand Total","Round Up Value of Total Itax","3 Lac to 7 Lac","7 Lac to 10 Lac","10 Lac to 12 Lac","12 Lac to 15 Lac",">15 Lac","Total","Edu. Cess (4%)","Grand Total","Round Up Value of Total Itax",null,"From Salary","Via Challan","Total",{"$f":"IF(AF4=\"नव.-2024 के वेतन तक की गई Itax कटौती\",\"Dec-24\",0)","v":"00:00:00"},{"$f":"IF(AF4=\"नव.-2024 के वेतन तक की गई Itax कटौती\",\"Jan-25\",0)","v":"00:00:00"},"2025-02-01"]
[{"$nulls":3},1,2,3,4,5,6,7,8,9,10,11,10,11,12,13,14,15,12,17,18,19,20,21,22,23,24,13,14,15,null,null,16,17,18,19,null,20,null,null,"old",{"$nulls":5},"new"]
[{"$f":"MIN(U7,AD7)","v":51800},{"$f":"IF(F7=0,0,IF(OR(U7=0,AD7=0),\"NT\",0))","v":0},null,1,"A",1072452,32000,0,150000,0,0,0,{"$f":"F7-50000-G7-H7-I7-J7-K7-L7","v":840452},{"$f":"F7-75000","v":997452},{"$f":"IF(M7<250000,0,IF(M7>500000,12500,IF(M7<500000,ROUND((M7-250000)*0.05,0),0)))","v":12500},{"$f":"IF(M7<500000,0,IF(M7>1000000,100000,ROUND((M7-500000)*0.2,0)))","v":68090},{"$f":"IF(M7<1000000,0,ROUND((M7-1000000)*0.3,0))","v":0},{"$f":"IF(F7=\"\",\"\",IF(SUM(O7:Q7)<=12500,0,SUM(O7:Q7)))","v":80590},{"$f":"IF(R7=\"\",\"\",ROUND(R7*0.04,0))","v":3224},{"$f":"IF(R7=\"\",\"\",R7+S7)","v":83814},{"$f":"IF(R7=\"\",\"\",ROUNDUP(T7,-2))","v":83900},{"$f":"IF(N7>700000,20000,IF(N7>300000,(N7-300000)*0.05,0))","v":20000},{"$f":"IF(N7>1000000,30000,IF(N7>700000,(N7-700000)*0.1,0))","v":29745.2},{"$f":"IF(N7>1200000,45000,IF(N7>1000000,(N7-1000000)*0.15,0))","v":0},{"$f":"IF(N7>1500000,60000,IF(N7>1200000,(N7-1200000)*0.2,0))","v":0},{"$f":"IF(N7<1500000,0,(N7-1500000)*0.3)","v":0},{"$f":"IF(F7=\"\",\"\",IF(SUM(V7:Z7)<=25000,0,IF((N7-700000)<SUM(V7:Z7),(N7-700000),(SUM(V7:Z7)))))","v":49745.2},{"$f":"IF(F7=\"\",\"\",ROUND(AA7*0.04,0))","v":1990},{"$f":"IF(F7=\"\",\"\",(AA7+AB7))","v":51735.2},{"$f":"IF(F7=\"\",\"\",ROUNDUP(AC7,-2))","v":51800},{"$f":"IF(F7=\"\",\"\",IF(F7=\"\",\"\",IF(U7=0,0,IF(U7>AD7,\"New Regime\",\"Old Regime\"))))","v":"New Regime"},35000,null,{"$f":"AF7+AG7","v":35000},{"$f":"IF(OR(U7=0,AD7=0),0,IF(AE7=\"Old Regime\",AQ7,AW7))","v":0},{"$f":"IF(OR(U7=0,AD7=0),0,IF(AE7=\"Old Regime\",AR7,AX7))","v":0},{"$f":"IF(OR(U7=0,AD7=0),0,IF(AE7=\"Old Regime\",AS7,AY7))","v":17000},{"$f":"AI7+AJ7+AK7","v":17000},{"$f":"MIN(U7,AD7)","v":51800},{"$f":"IF(AM7<=12500,-AH7,AM7-(AH7+AL7))","v":-200},{"$f":"IF(AN7=0,0,IF(AN7>0,\"(P)\",\"(R)\"))","v":"(R)"},null,{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(U7<=12500,0,IF(AH7>U7,0,ROUNDUP((U7-AH7)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(U7<=12500,0,IF(AH7>T7,0,ROUNDUP((U7-AH7)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",ROUNDUP((T7-AH7),-3),IF(T7<=12500,0,IF(AH7>T7,0,ROUNDUP((T7-AH7)/3,-3))))","v":49000},{"$f":"ROUNDUP(AQ7+AR7+AS7,-3)","v":49000},{"$f":"AT7+AH7","v":84000},{"$f":"AU7-U7","v":100},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(AD7<=12500,0,IF(AH7>AD7,0,ROUNDUP((AD7-AH7)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(AD7<=12500,0,IF(AH7>AD7,0,ROUNDUP((AD7-AH7)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",ROUNDUP((AD7-AH7),-3),IF(AD7<=12500,0,IF(AH7>AD7,0,ROUNDUP((AD7-AH7)/3,-3))))","v":17000},{"$f":"ROUNDUP(AW7+AX7+AY7,-3)","v":17000},{"$f":"AZ7+AH7","v":52000},{"$f":"BA7-AD7","v":200}]
[{"$f":"MIN(U8,AD8)","v":0},"NT",null,2,"B",777200,{"$nulls":6},{"$f":"F8-50000-G8-H8-I8-J8-K8-L8","v":727200},{"$f":"F8-75000","v":702200},{"$f":"IF(M8<250000,0,IF(M8>500000,12500,IF(M8<500000,ROUND((M8-250000)*0.05,0),0)))","v":12500},{"$f":"IF(M8<500000,0,IF(M8>1000000,100000,ROUND((M8-500000)*0.2,0)))","v":45440},{"$f":"IF(M8<1000000,0,ROUND((M8-1000000)*0.3,0))","v":0},57940,{"$f":"IF(R8=\"\",\"\",ROUND(R8*0.04,0))","v":2318},{"$f":"IF(R8=\"\",\"\",R8+S8)","v":60258},{"$f":"IF(R8=\"\",\"\",ROUNDUP(T8,-2))","v":60300},{"$f":"IF(N8>700000,20000,IF(N8>300000,(N8-300000)*0.05,0))","v":20000},{"$f":"IF(N8>1000000,30000,IF(N8>700000,(N8-700000)*0.1,0))","v":220},{"$f":"IF(N8>1200000,45000,IF(N8>1000000,(N8-1000000)*0.15,0))","v":0},{"$f":"IF(N8>1500000,60000,IF(N8>1200000,(N8-1200000)*0.2,0))","v":0},{"$f":"IF(N8<1500000,0,(N8-1500000)*0.3)","v":0},{"$f":"IF(F8=\"\",\"\",IF(SUM(V8:Z8)<=25000,0,IF((N8-700000)<SUM(V8:Z8),(N8-700000),(SUM(V8:Z8)))))","v":0},0,0,0,"New Regime",null,null,{"$f":"AF8+AG8","v":0},{"$f":"IF(OR(U8=0,AD8=0),0,IF(AE8=\"Old Regime\",AQ8,AW8))","v":0},{"$f":"IF(OR(U8=0,AD8=0),0,IF(AE8=\"Old Regime\",AR8,AX8))","v":0},{"$f":"IF(OR(U8=0,AD8=0),0,IF(AE8=\"Old Regime\",AS8,AY8))","v":0},{"$f":"AI8+AJ8+AK8","v":0},{"$f":"MIN(U8,AD8)","v":0},{"$f":"IF(AM8<=12500,-AH8,AM8-(AH8+AL8))","v":0},{"$f":"IF(AN8=0,0,IF(AN8>0,\"(P)\",\"(R)\"))","v":0},null,{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(U8<=12500,0,IF(AH8>U8,0,ROUNDUP((U8-AH8)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(U8<=12500,0,IF(AH8>T8,0,ROUNDUP((U8-AH8)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",ROUNDUP((T8-AH8),-3),IF(T8<=12500,0,IF(AH8>T8,0,ROUNDUP((T8-AH8)/3,-3))))","v":61000},{"$f":"ROUNDUP(AQ8+AR8+AS8,-3)","v":61000},{"$f":"AT8+AH8","v":61000},{"$f":"AU8-U8","v":700},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(AD8<=12500,0,IF(AH8>AD8,0,ROUNDUP((AD8-AH8)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(AD8<=12500,0,IF(AH8>AD8,0,ROUNDUP((AD8-AH8)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",ROUNDUP((AD8-AH8),-3),IF(AD8<=12500,0,IF(AH8>AD8,0,ROUNDUP((AD8-AH8)/3,-3))))","v":0},{"$f":"ROUNDUP(AW8+AX8+AY8,-3)","v":0},{"$f":"AZ8+AH8","v":0},{"$f":"BA8-AD8","v":0}]
[28200,0,null,3,"C",845545,{"$nulls":6},795545,770545,12500,59109,0,71609,2864,74473,74500,20000,7054.5,0,0,0,27054.5,1082,28136.5,28200,"New Regime",null,null,0,0,0,29000,29000,28200,-800,"(R)",null,0,0,75000,75000,75000,500,0,0,29000,29000,29000,800]
[0,0,null,4,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,5,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,6,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,7,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,8,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,9,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,10,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,11,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,12,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,13,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,14,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,15,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,16,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,17,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,18,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,19,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,20,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,21,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,22,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,23,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,24,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,25,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,26,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,27,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,28,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,29,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,30,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,31,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,32,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,{"$f":"IF(F39=0,0,IF(OR(U39=0,AD39=0),\"NT\",0))","v":0},null,33,{"$nulls":8},-50000,-75000,0,0,0,{"$f":"IF(F39=\"\",\"\",IF(SUM(O39:Q39)<=12500,0,SUM(O39:Q39)))","v":""},"","","",0,0,0,0,0,"",{"$f":"IF(F39=\"\",\"\",ROUND(AA39*0.04,0))","v":""},{"$f":"IF(F39=\"\",\"\",(AA39+AB39))","v":""},{"$f":"IF(F39=\"\",\"\",ROUNDUP(AC39,-2))","v":""},{"$f":"IF(F39=\"\",\"\",IF(F39=\"\",\"\",IF(U39=0,0,IF(U39>AD39,\"New Regime\",\"Old Regime\"))))","v":""},null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,34,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,35,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,36,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,37,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,38,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,null,39,{"$nulls":8},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,{"$f":"IF(F71=0,0,IF(OR(U71=0,AD71=0),\"NT\",0))","v":0},{"$nulls":10},-50000,-75000,0,0,0,{"$f":"IF(F71=\"\",\"\",IF(SUM(O71:Q71)<=12500,0,SUM(O71:Q71)))","v":""},"","","",0,0,0,0,0,"",{"$f":"IF(F71=\"\",\"\",ROUND(AA71*0.04,0))","v":""},{"$f":"IF(F71=\"\",\"\",(AA71+AB71))","v":""},{"$f":"IF(F71=\"\",\"\",ROUNDUP(AC71,-2))","v":""},{"$f":"IF(F71=\"\",\"\",IF(F71=\"\",\"\",IF(U71=0,0,IF(U71>AD71,\"New Regime\",\"Old Regime\"))))","v":""},null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$f":"MIN(U72,AD72)","v":0},0,{"$nulls":10},{"$f":"F72-50000-G72-H72-I72-J72-K72-L72","v":-50000},{"$f":"F72-75000","v":-75000},{"$f":"IF(M72<250000,0,IF(M72>500000,12500,IF(M72<500000,ROUND((M72-250000)*0.05,0),0)))","v":0},{"$f":"IF(M72<500000,0,IF(M72>1000000,100000,ROUND((M72-500000)*0.2,0)))","v":0},{"$f":"IF(M72<1000000,0,ROUND((M72-1000000)*0.3,0))","v":0},"",{"$f":"IF(R72=\"\",\"\",ROUND(R72*0.04,0))","v":""},{"$f":"IF(R72=\"\",\"\",R72+S72)","v":""},{"$f":"IF(R72=\"\",\"\",ROUNDUP(T72,-2))","v":""},{"$f":"IF(N72>700000,20000,IF(N72>300000,(N72-300000)*0.05,0))","v":0},{"$f":"IF(N72>1000000,30000,IF(N72>700000,(N72-700000)*0.1,0))","v":0},{"$f":"IF(N72>1200000,45000,IF(N72>1000000,(N72-1000000)*0.15,0))","v":0},{"$f":"IF(N72>1500000,60000,IF(N72>1200000,(N72-1200000)*0.2,0))","v":0},{"$f":"IF(N72<1500000,0,(N72-1500000)*0.3)","v":0},{"$f":"IF(F72=\"\",\"\",IF(SUM(V72:Z72)<=25000,0,IF((N72-700000)<SUM(V72:Z72),(N72-700000),(SUM(V72:Z72)))))","v":""},"","","","",null,null,{"$f":"AF72+AG72","v":0},{"$f":"IF(OR(U72=0,AD72=0),0,IF(AE72=\"Old Regime\",AQ72,AW72))","v":0},{"$f":"IF(OR(U72=0,AD72=0),0,IF(AE72=\"Old Regime\",AR72,AX72))","v":0},{"$f":"IF(OR(U72=0,AD72=0),0,IF(AE72=\"Old Regime\",AS72,AY72))","v":{"$error":"#VALUE!"}},{"$f":"AI72+AJ72+AK72","v":{"$error":"#VALUE!"}},{"$f":"MIN(U72,AD72)","v":0},{"$f":"IF(AM72<=12500,-AH72,AM72-(AH72+AL72))","v":0},{"$f":"IF(AN72=0,0,IF(AN72>0,\"(P)\",\"(R)\"))","v":0},null,{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(U72<=12500,0,IF(AH72>U72,0,ROUNDUP((U72-AH72)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(U72<=12500,0,IF(AH72>T72,0,ROUNDUP((U72-AH72)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",ROUNDUP((T72-AH72),-3),IF(T72<=12500,0,IF(AH72>T72,0,ROUNDUP((T72-AH72)/3,-3))))","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AQ72+AR72+AS72,-3)","v":{"$error":"#VALUE!"}},{"$f":"AT72+AH72","v":{"$error":"#VALUE!"}},{"$f":"AU72-U72","v":{"$error":"#VALUE!"}},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(AD72<=12500,0,IF(AH72>AD72,0,ROUNDUP((AD72-AH72)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",0,IF(AD72<=12500,0,IF(AH72>AD72,0,ROUNDUP((AD72-AH72)/3,-3))))","v":0},{"$f":"IF($AF$4=\"जन.-2025 के वेतन तक की गई Itax कटौती\",ROUNDUP((AD72-AH72),-3),IF(AD72<=12500,0,IF(AH72>AD72,0,ROUNDUP((AD72-AH72)/3,-3))))","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AW72+AX72+AY72,-3)","v":{"$error":"#VALUE!"}},{"$f":"AZ72+AH72","v":{"$error":"#VALUE!"}},{"$f":"BA72-AD72","v":{"$error":"#VALUE!"}}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,{"$f":"IF(F103=\"\",\"\",IF(SUM(O103:Q103)<=12500,0,SUM(O103:Q103)))","v":""},"","","",0,0,0,0,0,"",{"$f":"IF(F103=\"\",\"\",ROUND(AA103*0.04,0))","v":""},{"$f":"IF(F103=\"\",\"\",(AA103+AB103))","v":""},{"$f":"IF(F103=\"\",\"\",ROUNDUP(AC103,-2))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=\"\",\"\",IF(U103=0,0,IF(U103>AD103,\"New Regime\",\"Old Regime\"))))","v":""},null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[0,0,{"$nulls":10},-50000,-75000,0,0,0,"","","","",0,0,0,0,0,"","","","","",null,null,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,null,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]