{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["दिशानिर्देश","MASTERDATA","GA55","EXTRA DEDUCATION","OLD TAX REGIME","NEW TAX REGIME"],"not_rendered":{"images":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"दिशानिर्देश","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"merged":[[0,1,0,16],[1,2,1,16],[2,2,2,16],[3,2,3,16],[4,2,4,16],[5,2,5,16],[6,2,6,16],[7,2,7,16],[8,2,8,16],[9,0,9,17],[10,0,10,17]]}
[null,"उपयोग के दिशानिर्देश"]
[null,1,"इस वर्कबुक पर कार्य करते समय फॉन्ट समस्या हो तो KrutiDev 010 व DevLys 010 इनस्टॉल करे वर्क बुक के फॉन्ट काम करने लगेंगे "]
[null,2,"MASTER DATA SHEET की सभी पूर्तियां करनी अनिवार्य है |"]
[null,3,"मोबाइल में उपयोग हेतु WPS OFFICE APPLICATION काम में ले, अन्यथा वर्कबुक ठीक प्रकार से काम नही करेगी |"]
[null,4," मास्टर डाटा शीट में अपना वेतन व व्यक्तिगत जानकारी भरें व GA55 से विवरण का मिलान कर लेंवें विसंगति होने पर GA55 में मेन्यूल सुधार कर लेंवें |"]
[null,5,"EXTRA DEDUCATION शीट में वेतन के अतिरिक्त आय, विभिन्न कटौतियाँ, विभिन्न जमा राशि / छूट, वेतन के अलावा काटा गया आयकर आदि विवरण लिखा जाना है ।"]
[null,6,"OLD TAX REGIME व NEW TAX REGIME वाली शीट पूर्णतया लॉक है इसमें कुछ भी लिखने की अनुमति नही है जो भी सुधार करना हो GA55 व EXTRA DEDUCATION वाली शीटमें करे |"]
[null,7,"GA55 व TAX SHEETS को पेपर साइज़ A4 पर सेट किया हुआ है, OLD TAX REGIME OR NEW TAX REGIME में से जिसमे फायदा हो उसे चुने व उसका प्रिंट ले लेंवें |"]
[]
["यह प्रोग्राम राजस्थान के शिक्षकों के अनुरूप बनाई गया है \nसुनील कुमार महावर, अध्यापक राप्रावि वेलु का खेत ,सायरा,(उदयपुर)\nकिसी भी प्रकार की समस्या / सुझाव के लिए ईमेल करें-sk969019@gmail.com"]
["You Tube:- DIGITAL GURUJI HELP "]

{"sheet":"MASTERDATA","index":1,"n_rows":35,"n_cols":12,"rows_kept":35,"merged":[[0,1,0,6],[0,7,15,7],[1,1,1,6],[2,3,2,6],[14,1,14,6]]}
[null,"MASTER DATA FORM",{"$nulls":5},"                                                                  हमारे यू - ट्यूब चैनल को सबस्क्राइब अवश्य करें व साथ ही नोटिफिकेशन बेल को भी दबाये ताकि     नवीनतम अपडेट्स आप तक पहुँच सकें                                                             DIGITALGURUJI HELP"]
[null,"कार्मिक की व्यक्तिगत जानकारी "]
[null,1,"कार्यालय का नाम:-","GOVT. SR. SEC. SCHOOL, RAWACHH, BLOCK-SAYARA,UDAIPUR RAJ."]
[null,2,"कार्यालय का TAN NO.:-","SHSHP888N",13,"DDO का नाम:-","S.KUMAR "]
[null,3,"कार्मिक का नाम:-","SUNIL KUMAR MAHAWAR",14,"कार्मिक का  पद:-","TEACHER"]
[null,4,"कार्मिक का PAN NO.:-","DFGHJ1234H",15,"कार्मिक का A/C NO.:-",1210100012901]
[null,5,"SI नंबर:-","XXXXXX",16,"राज्य बीमा मासिक कटौती राशि:-",5000]
[null,6,"GPF NO.:-","RJUDXXXXXXX",17,"कार्मिक का मोबाईल नंबर:-","99XXXXXXXXX"]
[null,7,"मार्च 2022 का मूल वेतन:-",36900,18,"मार्च 2022 की HRA दर",{"v":0.09,"d":"9%"}]
[null,8,"पे लेवल :-","L10",19,"GPF की मासिक कटौती:-",2850]
[null,9,"क्या आपने वित्तीय वर्ष 2022-23 मे समर्पित लिया है?","NO",20,"यदि हाँ, तो समर्पित बिल माह:-","NA",{"$nulls":4},"L1"]
[null,10,"क्या आपको बोनस मिला है ?","YES",21,"क्या आपने RGHS कटौती का विकल्प लिया है ?","YES",{"$nulls":3},"YES","L2"]
[null,11,"दुर्घटना बीमा प्रीमियम राशि:-",null,22,"क्या हितकारी निधि की कटौती करनी है ?","NO",{"$nulls":3},"NO","L3"]
[null,12,"क्या आप वरिष्ट नागरिक (60-80) आयु वर्ग में आते है ?","NO",23,"शहरी क्षतिपूर्ती भत्ता (CCA) :-","NA",null,null,"NA","NA","L4"]
[null," NOTE:-  इस वर्क बुक को तैयार करने मे पूर्ण सावधानी बरती गयी है, यदि फिर भी कोई विसंगति होती है तो, विभागीय आदेश ही मान्य होंगे, जिसका उत्तरदायित्व शीट तैयार करने वाले का नही होगा |",{"$nulls":7},{"v":0.09,"d":"9%"},"2022-03-22","L5"]
[null,null,"https://youtu.be/7a0Kds6wPcg  ",{"$nulls":6},{"v":0.18,"d":"18%"},"2022-04-22","L6"]
[{"$nulls":7},"JJJJJJ",null,"NA","2022-05-22","L7"]
[{"$nulls":9},320,"2022-06-22","L8"]
[{"$nulls":9},620,"2022-07-22","L9"]
[{"$nulls":9},1000,"2022-08-22","L10"]
[{"$nulls":10},"2022-09-22","L11"]
[{"$nulls":10},"2022-10-22","L12"]
[{"$nulls":10},"2022-11-22","L13"]
[{"$nulls":10},"2022-12-22","L14"]
[{"$nulls":10},"2022-01-23","L15"]
[{"$nulls":10},"2022-02-23","L16"]
[{"$nulls":11},"L17"]
[{"$nulls":11},"L18"]
[{"$nulls":11},"L19"]
[{"$nulls":11},"L20"]
[{"$nulls":11},"L21"]
[{"$nulls":11},"L22"]
[{"$nulls":11},"L23"]
[{"$nulls":11},"L24"]
[{"$nulls":11},"L25"]

{"sheet":"GA55","index":2,"n_rows":30,"n_cols":28,"rows_kept":30,"merged":[[1,2,1,27],[2,2,2,27],[4,3,4,9],[4,10,4,11],[4,12,4,14],[4,18,4,21],[4,24,4,25],[4,26,4,27],[5,3,5,9],[5,10,5,11],[5,12,5,13],[5,17,5,18],[5,19,5,22],[5,24,5,25],[5,26,5,27],[29,13,29,15]]}
[]
[null,null,{"$f":"MASTERDATA!D3","v":"GOVT. SR. SEC. SCHOOL, RAWACHH, BLOCK-SAYARA,UDAIPUR RAJ."}]
[null,null,"Salary and Deduction Detail for FY : 2022-23"]
[]
[null,null,"Name :",{"$f":"MASTERDATA!D5","v":"SUNIL KUMAR MAHAWAR"},{"$nulls":6},"PAN :",null,{"$f":"MASTERDATA!D6","v":"DFGHJ1234H"},{"$nulls":4},"TAN:",{"$f":"MASTERDATA!D4","v":"SHSHP888N"},{"$nulls":5},"Bank A/c :",null,{"$f":"MASTERDATA!G6","v":1210100012901}]
[null,null,"     Post :",{"$f":"IF(MASTERDATA!G5=\"\",\"\",CONCATENATE(MASTERDATA!G5,\" \",\"(\",MASTERDATA!D10,\")\"))","v":"TEACHER (L10)"},{"$nulls":6},"SI No :",null,{"$f":"MASTERDATA!D7","v":"XXXXXX"},{"$nulls":4},{"$f":"MASTERDATA!C8","v":"GPF NO.:-"},null,{"$f":"IF(MASTERDATA!D8=\"\",\"\",MASTERDATA!D8)","v":"RJUDXXXXXXX"},{"$nulls":4},"Mobile No. :",null,{"$f":"MASTERDATA!G8","v":"99XXXXXXXXX"}]
[null,null,"Month","Basic Pay","Dearness Pay","Leave  Pay","Spl. Pay","D.A.","H.R.A.","Washing Allow.","ROP (If any, put the value in minus)",{"$f":"IF(MASTERDATA!G14=\"NA\",\"Other Allowance\",\"CCA\")","v":"Other Allowance"},"Other Allowance","Gross  Salary","GPF/GPF2004","GPF LOAN","SI","SI LOAN + INT","RGHS / RPMF","LIC","Group Insurance  \nAccidental","Income Tax / TDS","Hitkari Nidhi","Other Deduction","Other Deduction","Total\nDeduction","Net Payment","Bill No. - Date \n/ \nTV No. - Date"]
[null,3,"2022-03-01",{"$f":"MASTERDATA!D9","v":36900},0,0,0,{"$f":"ROUND(31%*D8,0)","v":11439},{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D8,0),ROUND(0.18*D8,0)))","v":3321},null,null,{"$f":"IF(MASTERDATA!G14=\"NA\",\"\",MASTERDATA!G14)","v":""},null,{"$f":"SUM(D8:M8)","v":51660},null,0,{"$f":"MASTERDATA!G7","v":5000},0,330,null,0,2500,null,"",null,{"$f":"SUM(O8:Y8)","v":{"v":7830,"d":"7,830"}},{"$f":"N8-Z8","v":{"v":43830,"d":"43,830"}}]
[null,4,"2022-04-01",{"$f":"D8","v":36900},0,0,0,{"$f":"ROUND(34%*D9,0)","v":12546},{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D9,0),ROUND(0.18*D9,0)))","v":3321},0,0,{"$f":"IF(L$8=L77,0,L8)","v":0},null,52767,{"$f":"O8","v":0},0,{"$f":"Q8","v":5000},0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D9<18001,265,IF(D9<33501,440,IF(D9<54001,658,875))))","v":658},{"$f":"T8","v":0},null,{"$f":"V8","v":2500},null,"",0,{"$f":"SUM(O9:Y9)","v":{"v":8158,"d":"8,158"}},{"v":44609,"d":"44,609"}]
[null,5,"2022-05-01",{"$f":"D9","v":36900},0,0,0,{"$f":"ROUND(34%*D10,0)","v":12546},{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D10,0),ROUND(0.18*D10,0)))","v":3321},0,0,{"$f":"IF(L$8=0,0,L9)","v":0},"",52767,{"$f":"O11*2","v":5700},0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D10<18001,265,IF(D10<33501,440,IF(D10<54001,658,875))))","v":658},0,0,{"$f":"V9","v":2500},null,"",0,{"v":13858,"d":"13,858"},{"v":38909,"d":"38,909"}]
[null,6,"2022-06-01",{"$f":"D10","v":36900},0,0,0,12546,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D11,0),ROUND(0.18*D11,0)))","v":3321},0,0,0,"",52767,{"$f":"MASTERDATA!G10","v":2850},0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D11<18001,265,IF(D11<33501,440,IF(D11<54001,658,875))))","v":658},0,0,2500,null,"",0,{"v":11008,"d":"11,008"},{"v":41759,"d":"41,759"}]
[null,7,"2022-07-01",{"$f":"MROUND(ROUND(1.03*D11,0),100)","v":38000},0,0,0,12920,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D12,0),ROUND(0.18*D12,0)))","v":3420},0,0,0,"",54340,2850,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D12<18001,265,IF(D12<33501,440,IF(D12<54001,658,875))))","v":658},0,0,2500,null,"",0,{"v":11008,"d":"11,008"},{"v":43332,"d":"43,332"}]
[null,8,"2022-08-01",{"$f":"D12","v":38000},0,0,0,12920,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D13,0),ROUND(0.18*D13,0)))","v":3420},0,0,0,"",54340,5000,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D13<18001,265,IF(D13<33501,440,IF(D13<54001,658,875))))","v":658},0,0,2500,null,"",0,{"v":13158,"d":"13,158"},{"v":41182,"d":"41,182"}]
[null,9,"2022-09-01",38000,0,0,0,{"$f":"ROUND(34%*D14,0)","v":12920},{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D14,0),ROUND(0.18*D14,0)))","v":3420},0,0,0,"",54340,5000,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D14<18001,265,IF(D14<33501,440,IF(D14<54001,658,875))))","v":658},0,0,2500,null,"",0,{"v":13158,"d":"13,158"},{"v":41182,"d":"41,182"}]
[null,10,"2022-10-01",38000,0,0,0,{"$f":"ROUND(38%*D15,0)","v":14440},{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D15,0),ROUND(0.18*D15,0)))","v":3420},0,0,null,"",{"$f":"SUM(D15:M15)","v":55860},5000,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D15<18001,265,IF(D15<33501,440,IF(D15<54001,658,875))))","v":658},0,0,2500,null,"",0,{"v":13158,"d":"13,158"},{"v":42702,"d":"42,702"}]
[null,11,"2022-11-01",38000,0,0,0,{"$f":"ROUND(38%*D16,0)","v":14440},{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D16,0),ROUND(0.18*D16,0)))","v":3420},0,0,0,"",55860,5000,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D16<18001,265,IF(D16<33501,440,IF(D16<54001,658,875))))","v":658},0,0,2500,null,"",0,{"v":13158,"d":"13,158"},{"v":42702,"d":"42,702"}]
[null,12,"2022-12-01",38000,0,0,0,14440,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D17,0),ROUND(0.18*D17,0)))","v":3420},0,0,0,"",55860,5000,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D17<18001,265,IF(D17<33501,440,IF(D17<54001,658,875))))","v":658},0,0,2500,{"$f":"IF(MASTERDATA!G13=\"NO\",0,IF(500,250))","v":0},"",0,{"v":13158,"d":"13,158"},{"v":42702,"d":"42,702"}]
[null,1,"2023-01-01",38000,0,0,0,14440,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D18,0),ROUND(0.18*D18,0)))","v":3420},0,0,0,"",55860,5000,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D18<18001,265,IF(D18<33501,440,IF(D18<54001,658,875))))","v":658},0,0,2500,null,"",0,{"v":13158,"d":"13,158"},{"v":42702,"d":"42,702"}]
[null,2,"2023-02-01",38000,0,0,0,14440,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=9%,ROUND(0.09*D19,0),ROUND(0.18*D19,0)))","v":3420},0,0,0,"",55860,5000,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D19<18001,265,IF(D19<33501,440,IF(D19<54001,658,875))))","v":658},0,0,2500,null,"",0,{"v":13158,"d":"13,158"},{"v":42702,"d":"42,702"}]
[null,null,"Salary Arrear",{"$nulls":10},0,{"$nulls":9},"",null,0,0]
[null,null,"Surender\n2022-23",{"$nulls":10},0,{"$nulls":9},"",null,0,0]
[null,null,"Bonus\n2022-23",{"$f":"IF(MASTERDATA!D12=\"YES\",6774,0)","v":6774},{"$nulls":9},6774,{"$f":"IF(D22=0,0,ROUND(D22*25%,0))","v":1694},0,{"$nulls":7},"",null,{"v":1694,"d":"1,694"},{"$f":"N22-Z22","v":{"v":5080,"d":"5,080"}}]
[null,null,"DA Arrear 1/22 to 3/22",{"$nulls":4},{"$f":"D8*3%+D9*3%+D10*3%","v":3321},{"$nulls":3},"",null,3321,{"$f":"N23","v":3321},0,{"$nulls":7},"",null,{"v":3321,"d":"3,321"},0]
[null,null,"DA Arrear 7/22 to 9/22",{"$nulls":4},{"$f":"D12*4%+D13*4%+D14*4%","v":4560},{"$nulls":5},4560,{"$f":"N24","v":4560},{"$nulls":8},"",null,{"v":4560,"d":"4,560"},0]
[null,null,"Other 1",{"$nulls":10},0,{"$nulls":9},"",null,{"$f":"SUM(O25:Y25)","v":0},0]
[null,null,"TOTAL",{"$f":"SUM(D8:D25)","v":{"v":458374,"d":"458,374"}},0,0,0,{"v":167918,"d":"167,918"},{"v":40644,"d":"40,644"},0,0,0,0,{"v":666936,"d":"666,936"},{"v":55975,"d":"55,975"},0,{"v":60000,"d":"60,000"},0,{"v":7568,"d":"7,568"},0,0,{"v":30000,"d":"30,000"},0,0,0,{"v":153543,"d":"153,543"},{"v":513393,"d":"513,393"}]
[]
[]
[{"$nulls":4},"Signature of Employee",{"$nulls":21},"Signature of DDO"]
[{"$nulls":4},{"$f":"MASTERDATA!D5","v":"SUNIL KUMAR MAHAWAR"},{"$nulls":8},"digitalgurujihelp",{"$nulls":12},{"$f":"MASTERDATA!G4","v":"S.KUMAR "}]

{"sheet":"EXTRA DEDUCATION","index":3,"n_rows":20,"n_cols":7,"rows_kept":20,"merged":[[0,0,0,6],[1,0,1,6]]}
["वेतन के अलावा अन्य आय, कटौतियाँ, एवं छूट का विवरण "]
[{"$f":"MASTERDATA!D5& \",          \"&'GA55'!D6&\"         PAN- \"&'GA55'!T6","v":"SUNIL KUMAR MAHAWAR,          TEACHER (L10)         PAN- RJUDXXXXXXX"}]
[]
[1,"मकान किराया भत्ता (छूट जो लेनी है) HRA",0,null,19,"स्टेण्डर्ड डिडेक्शन रूपये  50,000 (अधिकतम) धारा 16 (ia)",{"v":50000,"d":"50,000"}]
[2,"मनोरंजन भता धारा 16 (ii) (Entertainment A\\llowance)",0,null,20,"बचत खाते (All Saving Accounts) की जमा राशि पर प्राप्त ब्याज",0]
[3,"व्यवयाय कर धारा 16 (iii) के अन्तगर्त (Business tax)",0,null,21,"FD (Bank/ Post Office) आदि अन्य जमा राशि पर प्राप्त कुल ब्याज (PPF को छोड़कर)",0]
[4,"गृह सम्पति से प्राप्त किराया - आय ",0,null,22,"ब्याज के अलावा अन्य आय (विभिन्न स्त्रो़त्र से) ",0]
[5,"गृहकर (House Tax)",0,null,23,"अन्य मद में जमा करायी गयी राशि यदि कोई हो तो (धारा 80C के अन्तर्गत) ",0]
[6,"गृह ऋण किस्त मूलधन (12 Month) HBA Premium",0,null,24,"धारा 80CCC पेंशन प्लान हेतु अंशदान (NPS के अलावा)",0]
[7,"गृह ऋण किस्त ब्याज (12 Month) HBA Interest",0,null,25,"स्थगित वार्षिकी (Defferred Anniuty)",0]
[8,"जीवन बीमा प्रीमियम (जो वेतन से नही काटा गया) LIC",0,null,26,"धारा 10(14) के अन्तर्गत भत्ते जो कर मुक्त है",0]
[9,"पीएलआई (Postal Life Insurance) PLI",0,null,27,"धारा 80D -चिकित्सा बीमा प्रीमियम (सामान्य 25000, वरिष्ठ नागरिक 50000)",0]
[10,"टयूशन फीस (Tution Fees)",0,null,28,"धारा 80DD-विकलांग आश्रितों के चिकित्सा उपचार (विकलांगता 40%-75000, 80%-125000)",0]
[11,"यू एल आई पी  (ULIP) / वार्षिक प्लान  ",0,null,29,"धारा 80DDB- विशिष्ट रोगों के उपचार हेतु कटौती (सामान्य 40000, वरिष्ठ नागरिक 1 लाख)",0]
[12,"राष्ट्रीय बचत पत्र (NSC)",0,null,30,"धारा 80E- उच्च शिक्षा हेतु लिए ऋण का ब्याज",0]
[13,"राष्ट्रीय बचत पत्र पर अदत ब्याज (NSC Interest)",0,null,31,"धारा 80G-धर्मार्थ संस्थाओं आदि को दिये दान (क श्रेणी 100%, एवं ख श्रेणी 50%)",0]
[14,"लोक भविष्य निधि (PPF)",0,null,32,"धारा 80U- स्थाई शारीरिक विकलांगता (अधिकतम 75000, 80% विकलांगता 125000)",0]
[15,"राष्ट्रीय बचत स्कीम (NSS)",0,null,33,"धारा 80GGA- अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास हेतु दिया गया दान",0]
[16,"सुकन्या समृद्धि योजना (SSY)",0,null,34,"धारा 89 के अन्तर्गत राहत",0]
[17,"इक्विटी लिंक सेविंग स्कीम (Equaty Link Saving Scheme)",0,null,35,"वेतन बिल के अलावा जमा कराया गया आयकर (TDS)",0]

{"sheet":"OLD TAX REGIME","index":4,"n_rows":66,"n_cols":16,"rows_kept":66,"merged":[[0,1,0,13],[0,14,1,16],[1,1,1,13],[2,2,2,3],[2,4,2,9],[2,11,2,13],[2,15,2,16],[3,2,3,14],[3,15,3,16],[4,2,4,14],[4,15,4,16],[5,2,5,14],[5,15,5,16],[6,1,9,1],[6,2,6,11],[6,12,6,14],[6,15,8,16],[7,2,7,11],[7,12,7,14],[8,2,8,11],[8,12,8,14],[9,2,9,14],[9,15,9,16],[10,2,10,14],[10,15,10,16],[11,1,13,1],[11,2,11,9],[11,10,11,11],[11,12,11,14],[11,15,13,16],[12,2,13,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,4,13,6],[13,7,13,9],[13,10,13,11],[13,12,13,14],[14,2,14,14],[14,15,14,16],[15,2,15,14],[15,15,15,16],[16,2,16,14],[16,15,16,16],[17,2,17,14],[17,15,17,16],[18,1,33,1],[18,2,18,16],[19,2,19,16],[20,3,20,6],[20,7,20,8],[20,9,21,9],[20,10,21,12],[20,13,21,14],[20,15,29,16],[21,3,21,6],[21,7,21,8],[22,3,22,6],[22,7,22,8],[22,10,22,12],[22,13,22,14],[23,3,23,6],[23,7,23,8],[23,10,23,12],[23,13,23,14],[24,3,24,6],[24,7,24,8],[24,10,24,12],[24,13,24,14],[25,3,25,6],[25,7,25,8],[25,10,25,12],[25,13,25,14],[26,3,26,6],[26,7,26,8],[26,10,26,12],[26,13,26,14],[27,3,27,6],[27,7,27,8],[27,9,28,14],[28,3,28,6],[28,7,28,8],[29,3,29,6],[29,7,29,8],[29,10,29,12],[29,13,29,14],[30,2,30,14],[30,15,30,16],[31,2,31,14],[31,15,31,16],[32,2,32,14],[32,15,32,16],[33,2,33,14],[33,15,33,16],[34,1,44,1],[34,2,34,16],[35,2,35,14],[35,15,35,16],[36,2,36,14],[36,15,36,16],[37,2,37,14],[37,15,37,16],[38,2,38,14],[38,15,38,16],[39,2,39,14],[39,15,39,16],[40,2,40,14],[40,15,40,16],[41,2,41,14],[41,15,41,16],[42,2,42,14],[42,15,42,16],[43,2,43,14],[43,15,43,16],[44,2,44,14],[44,15,44,16],[45,2,45,14],[45,15,45,16],[46,2,46,14],[46,15,46,16],[47,2,47,14],[47,15,47,16],[48,1,58,1],[48,2,48,16],[49,2,49,6],[49,7,49,10],[49,11,49,14],[49,15,49,16],[50,2,50,4],[50,5,50,6],[50,7,50,9],[50,11,50,13],[50,15,50,16],[51,2,51,4],[51,5,51,6],[51,7,51,9],[51,11,51,13],[51,15,51,16],[52,2,52,4],[52,5,52,6],[52,7,52,9],[52,11,52,13],[52,15,52,16],[53,2,53,4],[53,5,53,6],[53,7,53,9],[53,11,53,13],[53,15,53,16],[54,2,54,14],[54,15,54,16],[55,2,55,14],[55,15,55,16],[56,2,56,14],[56,15,56,16],[57,2,57,14],[57,15,57,16],[58,2,58,14],[58,15,58,16],[59,2,59,14],[59,15,59,16],[60,2,60,14],[60,15,60,16],[61,1,62,1],[61,2,62,4],[61,5,61,8],[61,9,61,10],[61,12,61,13],[61,15,61,16],[62,5,62,8],[62,9,62,10],[62,12,62,13],[62,15,62,16],[63,1,63,14],[63,15,63,16],[69,11,75,16],[74,3,74,9]]}
[null,{"$f":"MASTERDATA!D3","v":"GOVT. SR. SEC. SCHOOL, RAWACHH, BLOCK-SAYARA,UDAIPUR RAJ."},{"$nulls":12},"Old Tax Regime"]
[null,"आयकर गणना प्रपत्र वर्ष 2022-23 (कर निर्धारण वर्ष 2023-24)"]
[null,1,"नाम कर्मचारी :",null,{"$f":"MASTERDATA!D5","v":"SUNIL KUMAR MAHAWAR"},{"$nulls":5}," पदनाम :",{"$f":"'GA55'!D6","v":"TEACHER (L10)"},null,null,"PAN :",{"$f":"MASTERDATA!D6","v":"DFGHJ1234H"}]
[null,2,"आय :  वित्तिय वर्ष 2022-23 में प्राप्त कुल वेतन ( कर योग्य सुविधाओं के मुल्य सहित )",{"$nulls":12},{"$f":"'GA55'!N26","v":{"v":666936,"d":"₹ 666,936"}}]
[null,3,"गृह किराया, धारा 10 (13A) के अन्तगर्त एवं धारा 10 (14) के अन्तगर्त अन्य भते जो कर मुक्त्त है ।",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!C4+'EXTRA DEDUCATION'!G11","v":0}]
[null,4,"शेष (2-3)",{"$nulls":12},{"$f":"P4-P5","v":{"v":666936,"d":"₹ 666,936"}}]
[null,5,"(i) स्टेण्डर्ड डिडेक्शन (Standerd Deduction) Rs.50,000 (अधिकतम) धारा 16(ia)",{"$nulls":9},{"$f":"IF('EXTRA DEDUCATION'!G4=0,0,(IF(AND(P6>50000,'EXTRA DEDUCATION'!G4=50000),50000,P6)))","v":{"v":50000,"d":"50000.00"}}]
[null,null,"(ii) मनोरंजन भता धारा 16 (ii) के अन्तर्गत (अधिकतम सीमा रू 5,000)",{"$nulls":9},{"$f":"'EXTRA DEDUCATION'!C5","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii) व्यवसाय कर धारा 16 (iii) के अन्तर्गत",{"$nulls":9},{"$f":"'EXTRA DEDUCATION'!C6","v":{"v":0,"d":"0.00"}}]
[null,null,"योग (5)",{"$nulls":12},{"$f":"SUM(M7:O9)","v":{"v":50000,"d":"₹ 50,000"}}]
[null,6,"शेष (4-5)",{"$nulls":12},{"$f":"P6-P10","v":{"v":616936,"d":"₹ 616,936"}}]
[null,7,"(अ) गृह सम्पति से आयः (1) स्वंय के उपयोग में - शून्य",{"$nulls":7},"(2) प्राप्त किराया रुपये ",null,{"$f":"'EXTRA DEDUCATION'!C7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटायें ",null," किराये का 30%",null,null," गृह ऋण पर ब्याज ",null,null," गृहकर  ",null,"  योग 7 (ब)"]
[{"$nulls":4},{"$f":"ROUND(M12*0.3,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF('EXTRA DEDUCATION'!C10>200000,200000,'EXTRA DEDUCATION'!C10)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"'EXTRA DEDUCATION'!C8","v":{"v":0,"d":"0.00"}},null,{"$f":"E14+H14+K14","v":{"v":0,"d":"0.00"}}]
[null,null,"शेष -/+  7 (अ) एवं योग 7(ब)  ",{"$nulls":12},{"$f":"M12-M14","v":0}]
[null,8,"कुल शेष - / + (6 एवं 7)",{"$nulls":12},{"$f":"P11+P15","v":{"v":616936,"d":"₹ 616,936"}}]
[null,9,"अन्य आय ",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G7","v":0}]
[null,10,"सकल आय                                                                                                           योग (8+9) ",{"$nulls":12},{"$f":"P16+P17","v":{"v":616936,"d":"₹ 616,936"}}]
[null,11,"घटाइये कटौतियाँ:- धारा US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1,50,000 /- (धारा 80CCE ) , ¼धारा 80CCD (2), के अलावा"]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},{"$f":"'GA55'!Q26","v":{"v":60000,"d":"₹ 60,000"}},null,"(xi)","पी एल आई (PLI)",null,null,{"$f":"'EXTRA DEDUCATION'!C12","v":0}]
[null,null,"(ii)","जीवन बीमा प्रीमियम (LIC)",{"$nulls":3},{"$f":"'GA55'!T26+'EXTRA DEDUCATION'!C11","v":0}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C15","v":0},null,"(xii)","इक्विटी लिंक सेविंग स्कीम",null,null,{"$f":"'EXTRA DEDUCATION'!C20","v":0}]
[null,null,"(iv)","लोक भविष्य निधि  (PPF)",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C17","v":0},null,"(xiii)","राष्ट्रीय बचत पत्र पर अदत ब्याज",null,null,{"$f":"'EXTRA DEDUCATION'!C16","v":0}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम (NSS)",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C18","v":0},null,"(xiv)","टयूशन फीस  ",null,null,{"$f":"'EXTRA DEDUCATION'!C13","v":0}]
[null,null,"(vi)","Gen.Provident Fund (GPF)",{"$nulls":3},{"$f":"'GA55'!O26","v":{"v":55975,"d":"₹ 55,975"}},null,"(xv)","स्थगित वार्षिकी  (Defferred Annuty)",null,null,{"$f":"'EXTRA DEDUCATION'!G10","v":0}]
[null,null,"(vii)","सामूहिक बीमा प्रीमियम (G.Ins.)",{"$nulls":3},{"$f":"'GA55'!U26","v":0},null,"(xvi)","अन्य जमा राशि (धारा 80 सी के अन्तर्गत)",null,null,{"$f":"'EXTRA DEDUCATION'!G8","v":0}]
[null,null,"(viii)","यू एल आई पी / वार्षिक प्लान",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C14","v":0}]
[null,null,"(ix)","गृह ऋण किस्त (HBA Premium)",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C9","v":0}]
[null,null,"(x)","सुकन्या समृद्धि योजना में जमा राशि",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C19","v":0},null,"(xvii)","योग ( i से xviii )",null,null,{"$f":"SUM(H21:I30)+SUM(N21:O27)","v":{"v":115975,"d":"₹ 115,975"}}]
[null,null,"अधिकतम कटौती की राशि 1.5 लाख रुपए तक ",{"$nulls":12},{"$f":"IF(N30<150001,ROUND(N30,0),150000)","v":{"v":115975,"d":"₹ 115,975"}}]
[null,null,"(B) घटाइये - धारा 80CCD(2) नियोक्ता द्वारा पेंशन अंशदान की राशि (अधिकतम वेतन का 10%) पृथक से छूट",{"$nulls":12},0]
[null,null,"(C) घटाइये - धारा 80CCD(1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रू. 50,000)",{"$nulls":12},0]
[null,null,"योग  11(A+B+C)      ",{"$nulls":12},{"$f":"SUM(P31:Q33)","v":{"v":115975,"d":"₹ 115,975"}}]
[null,12," अन्य कटौतियाँ"]
[null,null,"1- धारा 80D चिकित्सा बीमा प्रीमियम (स्वयं,पति / पत्नी व बच्चों के लिए रू 25000, माता-पिता के लिए रू 25000, सीनियर सिटीजन रू 50,000)",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G12","v":0}]
[null,null,"2- धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता 125,000)",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G13","v":0}]
[null,null,"3- धारा 80DDB विशिष्ट रोंगों के उपचार हेतु कटौती (अधिकतम रू 40000, सीनियर सिटीजन हेतु रू 100,000)",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G14","v":0}]
[null,null,"4- धारा 80E उच्च शिक्षा हेतु लिए ऋण का ब्याज",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G15","v":0}]
[null,null,"5- धारा 80G धर्मार्थ संस्थाओं आदि को दिये दान (क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G16","v":0}]
[null,null,"6- धारा 80U स्थाई रूप से शारीरिक असमर्थतता की दशा में (अधिकतम 75,000 तथा 80% या अधिक विकलांगता 125,000)",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G17","v":0}]
[null,null,"7- धारा 80TTA बचत खाते पर ब्याज की अधिकतम छूट रू 10,000          U/S 194(IA)",{"$nulls":12},{"$f":"IF(MASTERDATA!D14=\"Yes\",0,IF('EXTRA DEDUCATION'!G5>10000,10000,'EXTRA DEDUCATION'!G5))","v":0}]
[null,null,"8- धारा 80TTB - aवरिष्ठ नागरिकों को सभी प्रकार के ब्याज पर अधिकतम छूट-  50,000 रू       U/S 194(A)",{"$nulls":12},{"$f":"IF(MASTERDATA!D14=\"NO\",0,IF('EXTRA DEDUCATION'!G6<50001,'EXTRA DEDUCATION'!G6,50000))","v":0}]
[null,null,"9- धारा 80GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G18","v":0}]
[null,null,"कुल योग 12 (1 से  9 तक)",{"$nulls":12},{"$f":"SUM(P36:Q44)","v":0}]
[null,13,"कुल कटौती ( 11 + 12)",{"$nulls":12},{"$f":"P34+P45","v":{"v":115975,"d":"₹ 115,975"}}]
[null,14,"कर योग्य आय ( 10 - 13 )",{"$nulls":12},{"$f":"(P18-P46)","v":{"v":500961,"d":"₹ 500,961"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना ( दस के गुणक में ) धारा 288 A",{"$nulls":12},{"$f":"ROUND(P47,-1)","v":{"v":500960,"d":"₹ 500,960"}}]
[null,16," आयकर की गणना उपरोक्त कालम 15 के आधार पर"]
[null,null,"एक व्यक्ति कर दाता",{"$nulls":4},"वरिष्ठ नागरिक (60 से 80 वर्ष तक)",{"$nulls":3},"80 वर्ष या अधिक आयु"]
[null,null,"2,50,000 तक",null,null,"Nil",null,"3,00,000 तक",null,null,"Nil",{"$nulls":4},0]
[null,null,"2,50,001-5,00,000",null,null,{"v":0.05,"d":"5%"},null,"3,00,001-5,00,000",null,null,{"v":0.05,"d":"5%"},"5,00,000 तक",null,null,"Nil",{"$f":"ROUND(IF(MASTERDATA!$D$14=\"NO\",IF(P48<250001,0,IF(P48>500000,12500,((P48-250000)*0.05))),IF(P48<300001,0,IF(P48>500000,10000,((P48-300000)*0.05)))),0)","v":{"v":12500,"d":"₹ 12,500"}}]
[null,null,"5,00,001-10,00,000",null,null,{"v":0.2,"d":"20%"},null,"5,00,001-10,00,000",null,null,{"v":0.2,"d":"20%"},"5,00,001-10,00,000",null,null,{"v":0.2,"d":"20%"},{"$f":"IF(P48<500001,0,IF(P48>1000000,100000,((P48-500000)*0.2)))","v":{"v":192,"d":"₹ 192"}}]
[null,null,"10,00,000 से अधिक",null,null,{"v":0.3,"d":"30%"},null,"10,00,000 से अधिक",null,null,{"v":0.3,"d":"30%"},"10,00,000 से अधिक",null,null,{"v":0.3,"d":"30%"},{"$f":"IF(P48<1000001,0,((P48-1000000)*0.3))","v":0}]
[null,null,"(1) योग आयकर",{"$nulls":12},{"$f":"SUM(P51:Q54)","v":{"v":12692,"d":"₹ 12,692"}}]
[null,null,"(2) छूट धारा 87 A (2.50 लाख से 5 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रू. 12,500 तक)",{"$nulls":12},{"$f":"IF(P48>500000,0,IF(P55<12501,P55,12500))","v":0}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},{"$f":"P55-P56","v":{"v":12692,"d":"₹ 12,692"}}]
[null,null,"(4) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2%   ( योग 4% )",{"$nulls":12},{"$f":"ROUND(P57*0.04,0)","v":{"v":508,"d":"₹ 508"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":12},{"$f":"SUM(P57:Q58)","v":{"v":13200,"d":"₹ 13,200"}}]
[null,17,"घटाइये :- राहत धारा 89 के तहत  ",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G19","v":0}]
[null,18,"कुल शेष आयकर",{"$nulls":12},{"$f":"P59-P60","v":{"v":13200,"d":"₹ 13,200"}}]
[null,19,"आयकर कटौती\n का विवरण",null,null,"सितम्बर 2022 तक  रूपये",{"$nulls":3},"अक्टूबर से दिसम्बर 2022 रूपये  ",null,"जनवरी 2023\nरूपये","फरवरी 2023\nरूपये",null,"टीडीएस\nरूपये","कुल टैक्स कटौती\nयोग कॉलम 19"]
[{"$nulls":5},{"$f":"SUM('GA55'!V8:V14)","v":17500},{"$nulls":3},{"$f":"SUM('GA55'!V15:V17)","v":7500},null,{"$f":"'GA55'!V18","v":2500},{"$f":"'GA55'!V19","v":2500},null,{"$f":"'GA55'!V26+'EXTRA DEDUCATION'!G20","v":30000},{"$f":"O63","v":{"v":30000,"d":"₹ 30,000"}}]
[null,{"$f":"IF(P61>P63,\"Income Tax Payable (OLD TAX REGIME)\",IF(P61<P63,\"Income Tax Refundable (OLD TAX REGIME)\",\"Income Tax Payable/Refundable (OLD TAX REGIME)\"))","v":"Income Tax Refundable (OLD TAX REGIME)"},{"$nulls":13},{"$f":"P61-P63","v":{"v":-16800,"d":"₹ -16,800"}}]
[]
[{"$nulls":4},"Signature of Employee",{"$nulls":9},"Signature of DDO"]

{"sheet":"NEW TAX REGIME","index":5,"n_rows":57,"n_cols":16,"rows_kept":57,"merged":[[0,1,0,13],[0,14,1,16],[1,1,1,13],[2,2,2,3],[2,4,2,9],[2,11,2,13],[2,15,2,16],[3,2,3,14],[3,15,3,16],[4,2,4,14],[4,15,4,16],[5,2,5,14],[5,15,5,16],[6,1,9,1],[6,2,6,11],[6,12,6,14],[6,15,8,16],[7,2,7,11],[7,12,7,14],[8,2,8,11],[8,12,8,14],[9,2,9,14],[9,15,9,16],[10,2,10,14],[10,15,10,16],[11,1,13,1],[11,2,11,9],[11,10,11,11],[11,12,11,14],[11,15,13,16],[12,2,13,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,4,13,6],[13,7,13,9],[13,10,13,11],[13,12,13,14],[14,2,14,14],[14,15,14,16],[15,2,15,14],[15,15,15,16],[16,2,16,14],[16,15,16,16],[17,2,17,14],[17,15,17,16],[18,1,20,1],[18,2,18,16],[19,2,19,14],[19,15,19,16],[20,2,20,14],[20,15,20,16],[21,1,31,1],[21,2,21,16],[22,2,22,14],[22,15,22,16],[23,2,23,14],[23,15,23,16],[24,2,24,14],[24,15,24,16],[25,2,25,14],[25,15,25,16],[26,2,26,14],[26,15,26,16],[27,2,27,14],[27,15,27,16],[28,2,28,14],[28,15,28,16],[29,2,29,14],[29,15,29,16],[30,2,30,14],[30,15,30,16],[31,2,31,14],[31,15,31,16],[32,2,32,14],[32,15,32,16],[33,2,33,14],[33,15,33,16],[34,2,34,14],[34,15,34,16],[35,1,48,1],[35,2,35,16],[36,2,36,6],[36,7,36,10],[36,11,36,14],[36,15,36,16],[37,2,37,4],[37,5,37,6],[37,7,37,9],[37,11,37,13],[37,15,37,16],[38,2,38,4],[38,5,38,6],[38,7,38,9],[38,11,38,13],[38,15,38,16],[39,2,39,4],[39,5,39,6],[39,7,39,9],[39,11,39,13],[39,15,39,16],[40,2,40,4],[40,5,40,6],[40,7,40,9],[40,11,40,13],[40,15,40,16],[41,2,41,4],[41,5,41,6],[41,7,41,9],[41,11,41,13],[41,15,41,16],[42,2,42,4],[42,5,42,6],[42,7,42,9],[42,11,42,13],[42,15,42,16],[43,2,43,4],[43,5,43,6],[43,7,43,9],[43,11,43,13],[43,15,43,16],[44,2,44,14],[44,15,44,16],[45,2,45,14],[45,15,45,16],[46,2,46,14],[46,15,46,16],[47,2,47,14],[47,15,47,16],[48,2,48,14],[48,15,48,16],[49,2,49,14],[49,15,49,16],[50,2,50,14],[50,15,50,16],[51,1,52,1],[51,2,52,4],[51,5,51,8],[51,9,51,10],[51,12,51,13],[51,15,51,16],[52,5,52,8],[52,9,52,10],[52,12,52,13],[52,15,52,16],[53,1,53,14],[53,15,53,16]]}
[null,{"$f":"MASTERDATA!D3","v":"GOVT. SR. SEC. SCHOOL, RAWACHH, BLOCK-SAYARA,UDAIPUR RAJ."},{"$nulls":12},"New Tax Regime"]
[null,"आयकर गणना प्रपत्र वर्ष 2022-23 (कर निर्धारण वर्ष 2023-24)"]
[null,1,"नाम कर्मचारी :",null,{"$f":"MASTERDATA!D5","v":"SUNIL KUMAR MAHAWAR"},{"$nulls":5}," पदनाम :",{"$f":"'GA55'!D6","v":"TEACHER (L10)"},null,null,"PAN :",{"$f":"MASTERDATA!D6","v":"DFGHJ1234H"}]
[null,2,"आय :  वित्तिय वर्ष 2022-23 में प्राप्त कुल वेतन ( कर योग्य सुविधाओं के मुल्य सहित )",{"$nulls":12},{"$f":"'OLD TAX REGIME'!P4","v":{"v":666936,"d":"₹ 666,936"}}]
[null,3,"गृह किराया, धारा 10 (13A) के अन्तगर्त एवं धारा 10 (14) के अन्तगर्त अन्य भते जो कर मुक्त्त है ।",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G11","v":0}]
[null,4,"                                                              शेष (2-3)",{"$nulls":12},{"$f":"P4-P5","v":{"v":666936,"d":"₹ 666,936"}}]
[null,5,"(i) स्टेण्डर्ड डिडेक्शन (Standerd Deduction) Rs.50,000 (अधिकतम) धारा 16(ia)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,null,"(ii) मनोरंजन भता धारा 16 (ii) के अन्तर्गत (अधिकतम सीमा रू 5,000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,null,"(iii) व्यवसाय कर धारा 16 (iii) के अन्तर्गत",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,null,"योग (5)",{"$nulls":12},{"$f":"SUM(M7:O9)","v":0}]
[null,6,"शेष (4-5)",{"$nulls":12},{"$f":"P6-P10","v":{"v":666936,"d":"₹ 666,936"}}]
[null,7,"(अ) गृह सम्पति से आयः (1) स्वंय के उपयोग में - शून्य",{"$nulls":7},"(2) प्राप्त किराया रुपये ",null,{"$f":"'EXTRA DEDUCATION'!C7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटायें ",null," किराये का 30%",null,null," गृह ऋण पर ब्याज ",null,null," गृहकर  ",null,"  योग 7 (ब)"]
[{"$nulls":4},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,null,"शेष -/+  7 (अ) एवं योग 7(ब)  ",{"$nulls":12},{"$f":"M12","v":0}]
[null,8," कुल शेष - / + (6 ,oa 7½",{"$nulls":12},{"$f":"P11+P15","v":{"v":666936,"d":"₹ 666,936"}}]
[null,9,"अन्य आय ",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G7","v":0}]
[null,10,"सकल आय                                                                                                                 योग (8+9) ",{"$nulls":12},{"$f":"P16+P17","v":{"v":666936,"d":"₹ 666,936"}}]
[null,11,"घटाइये कटौतियाँ:-"]
[null,null,"(A) धारा  US 80C, 80CCC,80CCD (1) अधिकतम कटौती की राशि ",{"$nulls":12},0]
[null,null,"योग  11(A+B+C)      ",{"$nulls":12},{"$f":"SUM(P20:Q20)","v":0}]
[null,12," अन्य कटौतियाँ"]
[null,null,"1- धारा 80D चिकित्सा बीमा प्रीमियम (स्वयं,पति / पत्नी व बच्चों के लिए रू 25000, माता-पिता के लिए रू 25000, सीनियर सिटीजन रू 50,000)",{"$nulls":12},0]
[null,null,"2- धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता 125,000)",{"$nulls":12},0]
[null,null,"3- धारा 80DDB विशिष्ट रोंगों के उपचार हेतु कटौती (अधिकतम रू 40000, सीनियर सिटीजन हेतु रू 100,000)",{"$nulls":12},0]
[null,null,"4- धारा 80E उच्च शिक्षा हेतु लिए ऋण का ब्याज",{"$nulls":12},0]
[null,null,"5- धारा 80G धर्मार्थ संस्थाओं आदि को दिये दान (क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)",{"$nulls":12},0]
[null,null,"6- धारा 80U स्थाई रूप से शारीरिक असमर्थतता की दशा में (अधिकतम 75,000 तथा 80% या अधिक विकलांगता 125,000)",{"$nulls":12},0]
[null,null,"7- धारा 80TTA बचत खाते पर ब्याज की अधिकतम छूट रू 10,000          U/S 194(IA)",{"$nulls":12},0]
[null,null,"8- धारा 80TTB - aवरिष्ठ नागरिकों को सभी प्रकार के ब्याज पर अधिकतम छूट-  50,000 रू       U/S 194(A)",{"$nulls":12},0]
[null,null,"9- धारा 80GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},0]
[null,null,"कुल योग 12 (1 से  9 तक)",{"$nulls":12},{"$f":"SUM(Q23:Q31)","v":0}]
[null,13,"कुल कटौती ( 11 + 12)",{"$nulls":12},{"$f":"P21+P32","v":0}]
[null,14,"कर योग्य आय ( 10 - 13 )",{"$nulls":12},{"$f":"(P18-P33)","v":{"v":666936,"d":"₹ 666,936"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना ( दस के गुणक में ) धारा 288 A",{"$nulls":12},{"$f":"ROUND(P34,-1)","v":{"v":666940,"d":"₹ 666,940"}}]
[null,16," आयकर की गणना उपरोक्त कालम 15 के आधार पर"]
[null,null,"80 वर्ष या अधिक आयु",{"$nulls":4},"वरिष्ठ नागरिक (60 से 80 वर्ष तक)",{"$nulls":3},"एक व्यक्ति कर दाता (आयु 60 वर्ष तक)"]
[null,null,"3,00,000 तक",null,null,"Nil",null,"3,00,000 तक",null,null,"Nil","2,50,000  तक",null,null,"Nil",0]
[null,null,"3,00,001-5,00,000",null,null,{"v":0.05,"d":"5%"},null,"3,00,001-5,00,000",null,null,{"v":0.05,"d":"5%"},"2,50,001-5,00,000",null,null,{"v":0.05,"d":"5%"},{"$f":"ROUND(IF(MASTERDATA!$D$14=\"NO\",IF(P35<250001,0,IF(P35>500000,12500,((P35-250000)*0.05))),IF(P35<300001,0,IF(P35>500000,10000,((P35-300000)*0.05)))),0)","v":{"v":12500,"d":"₹ 12,500"}}]
[null,null,"5,00,001-7,50,000",null,null,{"v":0.1,"d":"10%"},null,"5,00,001-7,50,000",null,null,{"v":0.1,"d":"10%"},"5,00,001-7,50,000",null,null,{"v":0.1,"d":"10%"},{"$f":"IF(P35<500001,0,IF(P35>750000,25000,((P35-500000)*0.1)))","v":{"v":16694,"d":"₹ 16,694"}}]
[null,null,"7,50,001 - 10,00,000",null,null,{"v":0.15,"d":"15%"},null,"7,50,001 - 10,00,000",null,null,{"v":0.15,"d":"15%"},"7,50,001 - 10,00,000",null,null,{"v":0.15,"d":"15%"},{"$f":"IF(P35<750001,0,IF(P35>1000000,37500,((P35-750000)*0.15)))","v":0}]
[null,null,"10,00,001 - 12,50,000",null,null,{"v":0.2,"d":"20%"},null,"10,00,001 - 12,50,000",null,null,{"v":0.2,"d":"20%"},"10,00,001 - 12,50,000",null,null,{"v":0.2,"d":"20%"},{"$f":"IF(P35<1000001,0,IF(P35>1250000,50000,((P35-1000000)*0.2)))","v":0}]
[null,null,"12,50,001 - 15,00,000",null,null,{"v":0.25,"d":"25%"},null,"12,50,001 - 15,00,000",null,null,{"v":0.25,"d":"25%"},"12,50,001 - 15,00,000",null,null,{"v":0.25,"d":"25%"},{"$f":"IF(P35<1250001,0,IF(P35>1500000,62500,((P35-1250000)*0.25)))","v":0}]
[null,null,"15,00,000 से अधिक",null,null,{"v":0.3,"d":"30%"},null,"15,00,000 से अधिक",null,null,{"v":0.3,"d":"30%"},"15,00,000 से अधिक",null,null,{"v":0.3,"d":"30%"},{"$f":"IF(P35<1500001,0,(P35-1500000)*0.3)","v":0}]
[null,null,"(1) योग आयकर",{"$nulls":12},{"$f":"SUM(P38:Q44)","v":{"v":29194,"d":"₹ 29,194"}}]
[null,null,"(2) छूट धारा 87 A (2.50 लाख से 5 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रू. 12,500 तक)",{"$nulls":12},{"$f":"IF(P35>500000,0,IF(P45<12501,P45,12500))","v":0}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},{"$f":"P45-P46","v":{"v":29194,"d":"₹ 29,194"}}]
[null,null,"(4) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2%   ( योग 4% )",{"$nulls":12},{"$f":"ROUND(P47*0.04,0)","v":{"v":1168,"d":"₹ 1,168"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":12},{"$f":"SUM(P47:Q48)","v":{"v":30362,"d":"₹ 30,362"}}]
[null,17,"घटाइये :- राहत धारा 89 के तहत  ",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G19","v":0}]
[null,18,"कुल शेष आयकर",{"$nulls":12},{"$f":"P49-P50","v":{"v":30362,"d":"₹ 30,362"}}]
[null,19,"आयकर कटौती\n का विवरण",null,null,"सितम्बर 2022 तक  रूपये",{"$nulls":3},"अक्टूबर से दिसम्बर 2022 रूपये  ",null,"जनवरी 2023\nरूपये","फरवरी 2023\nरूपये",null,"टीडीएस\nरूपये","कुल टैक्स कटौती\nयोग कॉलम 19"]
[{"$nulls":5},{"$f":"SUM('GA55'!V8:V14)","v":17500},{"$nulls":3},{"$f":"SUM('GA55'!V15:V17)","v":7500},null,{"$f":"'GA55'!V18","v":2500},{"$f":"'GA55'!V19","v":2500},null,{"$f":"'GA55'!V26+'EXTRA DEDUCATION'!G20","v":30000},{"$f":"O53","v":{"v":30000,"d":"₹ 30,000"}}]
[null,{"$f":"IF(P51>P53,\"Income Tax Payable (NEW TAX REGIME)\",IF(P51<P53,\"Income Tax Refundable (NEW TAX REGIME)\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable (NEW TAX REGIME)"},{"$nulls":13},{"$f":"P51-P53","v":{"v":362,"d":"₹ 362"}}]
[]
[]
[{"$nulls":4},"Signature of Employee",{"$nulls":9},"Signature of DDO"]