{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["INTRO","Data Entry","Salary","Assesment","Master","HRA","NSC INTT","RULES"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INTRO","index":0,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,18,0],[0,1,0,3],[1,3,19,3],[19,0,19,2],[13,2,17,2],[1,1,1,2],[2,1,2,2],[4,1,4,2]]}
[]
[null,"INCOME TAX ASSESMENT FOR FINANCIAL YEAR 2020-21"]
[null,"HOW TO USE   "]
[null,null,"राजस्थान राज्य कर्मचारियों के  लिए आयकर आकलन   बाबत इस UTILITY का प्रयोग किया जा सकता है । FILE को SAVE करने के लिए अपनी सुविधा से नाम देकर SAVE AS से Excel Macro- Enable Workbook के रूप में Save करें। file को open करते समय Enable Macro करें।यह excel utility केवल मात्र राज्य कार्मिको के income tax assesment के लिए सहायतार्थ तैयार की गई है ।यद्यपि इसे तैयार करने में पूर्ण सावधानी बरती गई है फिर भी किसी भूल चूक के लिए तैयार कर्ता उत्तरदायी नहीं है । किसी भी गणना के लिए त्रुटि पाए जाने पर आयकर विभाग के नियम मान्य होंगे  किसी प्रकार की तकनीकी कमी पाए जाने पर नीचे दिये गए EMAIL द्वारा अवगत कराने का श्रम करावे।(PLEASE USE LATEST VERSION OF THAT IS  OFFICE 2010 AND ABOVE FOR BEST RESULT)"]
[null,"   1. First Enable Macro whenever open file                    2.Install Devlys 010 Hindi font in your computer for view Assesment Sheet"]
[null,"1. Data Entry Sheet :-","Details शीट में कार्मिक की सामान्य सूचना,वेतन भत्ते ,कटौतियों और वेतन से एवं सामान्य आयकर छूट हेतु जमा का विवरण संबन्धित कॉलम में भरना है।शीट में महत्वपूर्ण स्थान पर आवश्यक निर्देश दिये गए है।वेतन से income tax कटौती को आपको manually MONTHLY भरना है।"]
[null,"2. SALARY SHEET","सर्वप्रथम Refresh Salary बटन पर क्लिक कर आप द्वारा Data Entry शीट में भरे data अनुसार सैलरी शीट तैयार हो जाएगी ।यदि कोई बदलाव अपेक्षित है तो शीट मे आपकी आवश्यकता अनुसार कर सकते है।Refresh Salary बटन को क्लिक करने पर पुनः प्रारम्भिक अवस्था मे आ जाएगी । WHITE सेल में आवश्यकता अनुसार प्रविष्टि कर सकते है ।अन्य भत्ते एवं कटौती आप SALARY SHEET में MANUALLY कर सकते है।इसका प्रिंट लेना है ।"]
[null,"3. Assesment  sheet","Assesment  Sheet Auto generate है।आप OLD REGIME या NEW REGIME में से किसी एक का चुनाव option बटन  करे और आपके चुनाव अनुसार Assesment form  रिपोर्ट तैयार प्राप्त करे । OLD REGIME या NEW REGIME में तुलनात्मक कौनसा चुनाव आपके लिए बेहतर की रिपोर्ट भी आप COMAPARISSION के द्वारा देख सकते है।इसका प्रिंट लेना है।"]
[null,"4. HRA SHEET ","यदि आप complete  year के लिए HRA छूट के लिए पात्र नहीं है और   Partially HRA की छूट लेना चाहते है तो इस शीट में जिन महीनों के लिए छूट प्राप्त करना चाहते है उनके सामने \"YES\" चुने और Data Entry Sheet मे Dropdown से \"Partially\" चुने तथा Data Entry Sheet में B15 cell मे आप द्वारा भुगतान किए गए किराये की राशि भरे। नियमानुसार छूट Auto generate हो जाएगी।आप द्वारा अधिकतम छूट के लिए कितने किराए की रसीद आवश्यक है भी Auto Generate हो जाएगी।"]
[null,"5. NSC INT.","आप ने यदि NSC में निवेश कर रखा है तो प्र्तिवर्ष अर्जित ब्याज की गणना के लिए इस शीट का प्रयोग कर सकते है।आप ने जिस अवधि में NSC खरीदा है उसके सबंधित कॉलम में जिस अवधि का ब्याज गणना करना चाहते है NSC की राशि लिखे ।समस्त ब्याज का योग N15 cell मे Auto generate हो जाएगी जिसकी प्रविष्टि Data Entry Sheet में D40 cell में करे।"]
[null,"Disclaimer: -","All care has been taken to keep the information upto date and correct and is for educational purpose only. You are encouraged to consult your Accountant or Advisor before taking any decesion based on this calculator"]
[]
[null,null,"                                  सुधार हेतु सुझाव  आमंत्रित  है "]
[]
[]
[]
[]
[]
[null,null,"                                         joshihansraj72@gmail.com"]
[]
[null,"UPDATED 14-11-2020"]
[null,"UPADTES:-","1.BONUS AS PAR GOVERNMENT NEW ORDER"]
[null,null,"2.CM CORONA RELIEF FUND DEDUCTION OPTION INCLUDED AS PAR GOVERNMENT ORDER"]
[null,"UPDATED 30-11-2020","INCOME TAX DEDUCTION IN SALARY FILL IN DATA ENTRY SHEET"]
[null,null,"GPF 2004 DEDUCTION AUTO INCULDE IN 80C "]
[null,"UPDATED 06-12-2020","IF ASSESSEE PAY SI PREMIUM UPTO NEXT TWO SLAB THAN FILL OPTION PROVIDE IN DATA ENTRY SHEET"]
[null,"UPDATED 11-12-2020","1.RECTIFIED EN ERROR IN SALARY SHEET(COLUMN Z RESOLVED ISSUE GPF AMOUNT WAS NOT ADDING IN SUM)  "]
[null,null,"2. NEW FEATURES ADDED :- US 80 TTA, 80TTB, 80D AND 80DDB AMOUNT AUTOMATIC CALCULATED FOR INDIVIDUAL AND SENIOR CITIZEN AS PAR RULE OF IT. "]
[null,"UPDATE 13-11-2020","RECTIFIED ERROR :-  #VALUE ERROR IN SURRENDER IF CHOOSE NO OPTION HAS BEEN RESOLVED"]
[]
[null,"UPDATE 17-12-2020","1  80CCD(1B) AUTOMATIC SPLIT FROM 80CCD(1) (80 CCD1 की राशि को 80CCD(1B) लाभ लेने के लिए ऑटोमैटिक विभाजित कर ASSESMENT करने की सुविधा)"]
[null,null,"2  UNLOCK AND LOCK BUTTON PROVIDE IN SALARY SHEET FOR EDIT IN SALARY SHEET IF REQUIRE"]
[null,null,"3   नियमों की स्पष्टता के अभाव में जीपीएफ़ 2004 की बोनस राशि को 80c में जोड़ने/ नहीं जोड़ने का विकल्प"]
[null,null,"4 SALARY SHEET को EDITABLE किया गया है एवं REFRESH बटन द्वारा डिफ़ाल्ट डाटा प्राप्ति सुविधा का विस्तार किया "]
[null,"UPDATE 23-12-2020","1 ASSESMENT SHEET CONVERT IN UNICODE FONT "]
[null,null,"2  ERROR IN COMPARISION SECTION IN ASSESMENT SHEET WHENEVER TAXABLE INCOME MORE THAN 1500000 RECTIFIED"]
[null,"UPDATE 24-12-2020","1 UPDATED FOR ALL INDIA SERVICES"]
[null,"UPDATED 02-01-2021","1 IN NEW REGIME CALCULATION INCOME FROM HOUSE PROPERTY RELATED ISSUE RESOLVED."]
[null,null,"2 ON THE DEMAND OF USERS CM CORONA  RELIEF FUND COLUMN IN SALARY SHEET HAS BEEN UNLOCKED . NOW ANYONE CAN CHANGE AMOUNT AS PAR NEED."]
[]
[null,"IMPORTANT INFORMATION"," IF YOU FIND THAT CM CORONA FUND DEDUCTION IS NOT BEING SHOWN CORRECT , PLEASE CHECK CADER AND PAY LEVAL IN DATA ENTRY SHEET AND MAKE IT CORRECT"]

{"sheet":"Data Entry","index":1,"n_rows":49,"n_cols":43,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,16,47,18],[48,16,48,18],[45,16,45,18],[47,2,48,4],[47,5,48,6],[44,1,44,20],[2,39,2,42],[3,39,3,40],[4,39,4,40],[5,39,5,40],[6,39,6,40],[7,39,7,40],[8,39,8,40],[9,39,9,40],[13,18,13,20],[13,1,13,3],[11,23,11,25],[7,11,7,15],[7,16,7,20],[5,2,5,5],[3,1,3,20],[7,7,7,8],[1,1,2,20],[10,1,10,20],[13,10,13,17],[12,1,12,3],[12,10,12,20],[4,2,4,5],[4,6,4,8],[4,13,4,15],[4,16,4,19],[4,9,4,12],[5,9,5,20],[6,2,6,5],[6,6,6,8],[6,9,6,10],[5,6,5,8],[6,17,6,18],[13,6,13,9],[12,4,12,5],[12,6,12,7],[12,8,12,9],[38,16,38,18],[30,6,30,15],[30,16,30,18],[31,6,31,15],[31,16,31,18],[32,16,32,18],[33,6,33,15],[15,1,15,20],[16,2,16,3],[16,8,16,9],[35,1,35,3],[32,13,32,14],[36,1,36,3],[37,1,37,3],[33,16,33,18],[34,6,34,15],[34,16,34,18],[35,6,35,15],[35,16,35,18],[36,6,36,15],[36,16,36,18],[37,6,37,15],[37,16,37,18],[32,6,32,8],[39,6,39,8],[39,9,39,11],[39,12,39,14],[23,5,38,5],[23,19,38,20],[39,1,39,5],[30,1,30,3],[22,1,22,20],[23,1,23,3],[23,6,23,15],[23,16,23,18],[24,6,24,15],[24,16,24,18],[26,1,26,3],[27,1,27,3],[28,1,28,3],[38,1,38,3],[25,6,25,15],[25,16,25,18],[26,6,26,15],[26,16,26,18],[27,16,27,18],[32,1,32,3],[38,6,38,15],[19,10,20,14],[29,6,29,15],[21,10,21,20],[29,16,29,18],[19,5,19,9],[20,8,20,9],[19,2,19,4],[29,1,29,3],[19,1,21,1],[24,1,25,3],[24,4,25,4],[19,15,20,15],[19,16,20,17],[28,16,28,18],[27,13,27,14],[27,11,27,12],[27,6,27,9],[41,5,41,6],[6,11,6,16],[42,5,42,6],[41,14,41,15],[42,14,42,15],[40,1,40,20],[19,18,20,19],[14,13,14,18],[9,2,9,5],[9,6,9,10],[14,19,14,20],[11,2,11,3],[33,1,33,3],[17,5,17,6],[17,2,17,3],[17,8,17,9],[16,10,16,12],[16,13,16,20],[34,1,34,3],[20,5,20,6],[21,5,21,6],[21,8,21,9],[31,1,31,3],[32,10,32,11],[47,10,48,12],[47,14,47,15],[48,14,48,15],[47,13,48,13],[17,30,17,36],[28,6,28,15],[11,4,11,7],[7,2,7,5],[7,9,7,10],[18,1,18,20],[11,8,11,9],[11,10,11,15],[11,16,11,20],[8,2,8,5],[8,6,8,10],[8,11,8,20],[16,5,16,6],[9,11,9,19],[14,8,14,10],[14,11,14,12],[13,4,13,5],[14,4,14,6],[3,30,7,33],[2,26,3,26]]}
[]
[null,"INCOME TAX ASSESMENT FOR FINANCIAL YEAR 2020-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI PREMIUM FROM SALARY"]
[null,"GENERAL INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"CADER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAY RANGE",null,"2018-03-01","2020-03-01"]
[null,"NAME OF EMPLOYEE","HANS RAJ JOSHI",null,null,null,"EMPLOYEE ID",null,null,"RJGA99999999999",null,null,null,"PAN NO",null,null,"XXXXX1234X",null,null,null,null,null,3,null,"All India Services",null,null,"L-1",1,null,null,null,null,null,null,null,null,null,null,"UPTO 22000",null,500,800]
[null,"Designation","PRINCIPAL",null,null,null,"OFFICE",null,null,"GOVT. GIRLS SR.SEC.SCHOOL ANUPGARH",null,null,null,null,null,null,null,null,null,null,null,null,4,null,"State Service",null,null,"L-2",2,null,null,null,null,null,null,null,null,null,null,"22001 TO 28500",null,700,1200]
[null,"CADER","State Service",null,null,null,"PAY LEVAL",null,null,"L-23",null,"आप NPS के सदस्य है तो Yes\" नहीं तो  \"No\" चुने",null,null,null,null,null,"No",null,null,null,null,5,null,"Subordinate",null,null,"L-3",3,null,null,null,null,null,null,null,null,null,null,"28501TO 46500",null,1300,2200]
[null,"Mobile No",9461424525,null,null,null,"DOB","1972-08-12",null,"TAN NO",null,null,null,null,null,null,null,null,null,null,null,null,6,null,"Ministrial",null,null,"L-4",4,null,null,null,null,null,null,null,null,null,null,"46501 TO 72000",null,1800,3000]
[null,"TAX DEDUCTOR'S DESIGNATION","PRINCIPAL",null,null,null,"TAX DEDUCTOR'S OFFICE ADDRESS",null,null,null,null,"GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR",null,null,null,null,null,null,null,null,null,null,7,null,"Class IV",null,null,"L-5",5,null,null,null,null,null,null,null,null,null,null,"ABOVE 72000",null,3000,5000]
[null,"YOUR BANK ACCOUNT NUMBER",null,null,null,null,"YOUR BANK BRANCH NAME",null,null,null,null,"ABC",null,null,null,null,null,null,null,null,null,null,8,null,"Yes",null,null,"L-6",6,null,null,null,null,null,null,null,null,null,null,"MAXIMUM",null,4000,7000]
[null,"Pay and Allowances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"No",null,null,"L-7",7]
[null,"        मूल  वेतन (मार्च 2020 का)      ( 7वें वेतन आयोग अनुसार ) F",75700,null,"मूल वेतन में परिवर्तन (एसीपी या अन्य कारण ,INCREAMENT के अलावा) का माह क्रमांक",null,null,null,null,null,"fn, x, ekg ds fy, ewy osru \n",null,null,null,null,null,null,null,null,null,null,null,10,"CCA",null,null,null,"L-8",8]
[null,"HRA का भुगतान उठाया है तो \"Yes \" अन्यथा \"No\" ड्रॉपडाउन से चुने                                    ",null,null,"Yes",null,"HRA दर",null,0.08,null,"अन्य कोई भत्ता अगर आपको मिलता है तो Salary शीट में Manualy भरे",null,null,null,null,null,null,null,null,null,null,null,11,"CITY",">23100","<=23100",null,"L-9",9]
[null,"CCA का भुगतान उठाया है तो \"Yes \" अन्यथा \"No\" ड्रॉपडाउन से चुने ",null,null,"No ",null,"CCA लागू है तो CITY SELECT करें ",null,null,null,"JODHPUR",null,null,null,null,null,null,null,{"$f":"Master!G7","v":0},null,null,null,12,"JAIPUR(U)",1000,620,null,"L-10",10]
[null,"SURRENDER OF PL का भुगतान उठाया है तो \"Yes\",अन्यथा \"No\" चुने व जिस माह में भुगतान लिया है का क्रमांक चुने  \n","Yes",8,"बोनस मिला है  तो \"Yes\"अन्यथा  \"No\" चुने",null,null,"No","fdrus ekg ds fy, cksul feyk",null,null,12,null," ARE YOU EMPLOYEE FROM MEDICAL DEP.,JUDICIARY DEP.POLICE CONSTABLE, CLASS IV,L-1 TO L-4",null,null,null,null,null,null,null,null,1,"JODHPUR",620,320,null,"L-11",11]
[null,"EXEMPATIONS FROM INCOME TAX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"BIKANER",620,320,null,"L-12",12,null,null,"YES"]
[null,"FOR HRA EXEMPTION\n ( मकान किराये का वास्तविक भुगतान )",null,null,"HRA exemption amount","Yearly",null,{"$f":"IF(F17=\"Yearly\",Master!E27,Master!H27)","v":0},"Rent receipt required for max. HRA exemption",null,{"$f":"IF(F17=\"Yearly\",Master!E26,Master!H26)","v":174882},null,null,"IF YOU ARE NOT ELIGIBLE TO GET HRA EXEMPTION FOR COMPLETE YEAR THEN CHOOSE \"PARTIALLY\" OTHERWISE \"Yearly\"",null,null,null,null,null,null,null,null,null,"AJMER",620,320,null,"L-13",13,null,null,"NO"]
[null,"धारा 10(14) के अन्तर्गत अन्य भत्ते ",null,null,"मनोरंजन भत्ता धारा 16(iii) के अंतर्गत ",null,null,"व्यवसाय कर धारा 16(iii) के अंतर्गत ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KOTA",620,320,null,"L-14",14,null,"क्या आप CM CORONA RELIEF FUND में कटौती करवाना चाहते है ?                            यदि हाँ तो माह का चयन करे "]
[null,"ARREARS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-15",15]
[null,"यदि आपको चालू वित्त वर्ष में कोई Arrear मिला है तो Arrear 1/Arrear 2 में दर्ज करें ","Arrear 1",null,null,"Arrear 2",null,null,null,null,"यदि  आपने 2019-20 मे Surrender leave का भुगतान उठाया है तो \"Yes\" चुने व माह जिसमे भुगतान उठाया का क्रमांक लिखे ",null,null,null,null,"No","माह क्रमांक",null,8,null,null,null,null,null,null,null,null,"L-16",16]
[null,null,"राशि ","TDS","NPS/GPF Deduction","राशि ",null,"TDS","NPS/GPF Deduction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-17",17]
[null,null,null,null,null,null,null,null,null,null,"यदि आपने अन्य कोई एरिअर का भुगतान उठाया है तो CHECK & EDIT शीट के अंतिम Unlocked पंक्ति में लिखे ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-18",18]
[null,"osru ds vfrfjDr dVkSfr;k¡] vk;@tek jkf'k ,oa NwV dk fooj.k",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-19",19]
[null," बचत खाते  की जमाराशि पर अर्जित ब्याज धारा (80TTA )  ",null,null,5000,null," जीवन बीमा प्रीमियम -LIC (जो वेतन से काटा गया )",null,null,null,null,null,null,null,null,null,469,null,null,null,null,null,null,null,null,null,null,"L-20",20]
[null," वरिष्ठ नागरिकों को बचत खाते एवं स्थायी जमा खाते से प्राप्त ब्याज धारा (80TTB)  ",null,null,null,null,"अन्य स्रोत से आय (FD पर ब्याज इत्यादि समस्त अन्य आय का योग )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-21",21]
[null,null,null,null,null,null,"अन्य जमा राशि (धारा 80 C के अंतर्गत ) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-22",22]
[null," गृह सम्पति से आय - किराया ",null,null,264000,null,"धारा 80 CCC के अंतर्गत-पेंशन प्लान हेतु अंशदान (एनपीएस के अलावा ) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-23",23]
[null," गृह कर  ",null,null,10000,null,"धारा 80 CCD(1B) के अंतर्गत-NPS मे अतिरिक्त अंशदान  ",null,null,null,null,"SPLIT FROM 80CCD(1) ",null,{"$f":"IFERROR(IF(N48=\"YES\",Q48,0),0)","v":0},null,"योग",{"$f":"IF(SUM(K28+N28)>50000,50000,SUM(K28+N28))","v":0},null,null,null,null,null,null,null,null,null,null,"L-24",24]
[null," गृह ऋण मूल (जो वेतन से नहीं काटा गया )",null,null,40000,null,"धारा 80D -चिकित्सा बीमा प्रीमियम (सामान्य 25000,वरिष्ठ नागरिक 50000) "]
[null," गृह ऋण ब्याज  (जो वेतन से नहीं काटा गया )",null,null,30000,null,"धारा 80DD -विकलांग आश्रितों के चिकित्सा उपचार  (सामान्य 75000,80% से अधिक विकलांगता पर 125000) "]
[null," जीवन बीमा प्रीमियम -LIC (जो वेतन से नहीं काटा गया )",null,null,6163,null,"धारा 80DDB -विशिष्ट रोगों के  उपचार हेतु   (अधिकतम 40000,वरिष्ठ नागरिक 100000) "]
[null," पी.एल.आई . (PLI )",null,null,null,null," धारा 80E - उच्च शिक्षा हेतु ऋण का  ब्याज "]
[null,"ट्यूशन फीस  (Tution Fees)",null,null,60000,null,"धारा 80G -धर्मार्थ संस्थाओं को दिये दान",null,null,"श्रेणी  100%",null,null,"श्रेणी - 50%",null,null,"योग",{"$f":"ROUND(N33*50%,0)+K33","v":0}]
[null,"ULIP/वार्षिक प्लान ",null,null,null,null,"धारा 80 U -स्थायी शारीरिक विकलांगता (साधारण 75000, 80% से अधिक के मामले में 125000)"]
[null,"राष्ट्रीय बचत पत्र  (NSC)",null,null,null,null,"धारा 80 GGA -अनुमोदित वैज्ञानिक ,सामाजिक ग्रामीण विकास हेतु दिया गया दान "]
[null,"राष्ट्रीय बचत पत्र  (NSC) से प्राप्त ब्याज ",null,null,null,null,"इक्विटी लिंक सविंग स्कीम में निवेश "]
[null,"लोक भविष्य निधि (PPF) में निवेश ",null,null,1000,null,"स्थगित वार्षिकी "]
[null,"राष्ट्रीय बचत स्कीम  (NSS) में निवेश ",null,null,null,null,"धारा 89 के तहत राहत "]
[null,"सुकन्या समृद्धि योजना  में जमा  ",null,null,null,null,"वेतन बिल के अलावा जमा कराया गया TDS"]
[]
[null," वेतन से माहवार आयकर कटौती विवरण "]
[null,"MONTH NAME","MARCH","APRIL","MAY","JUNE",null,"JULY","AUGUST","SEPT","OCT","NOV","DEC","JAN","FEB"]
[null,"TDS",null,3000,3000,3000,null,3000,3000,12000,12000,12000,12000,12000,12000]
[]
[null," वेतन से माहवार राज्य बीमा कटौती आगे में की दो स्लैब तक अंशदान का विवरण "]
[null," "]
[]
[null,null,"यदि आप राज्य बीमा की अंशदान दो स्लैब आगे तक करते है तो \"YES\" का चयन करे और प्रीमियम  भरे अन्यथा \"NO\" चुने प्रीमियम को खाली छोड़े",null,null,"YES",null,"अंशदान",null,null,"यदि आप NPS की अंशदान 80CCD(1) को SPLIT कर 80CCD 1(B) का लाभ लेना चाहते है तो \"YES\" का चयन करे  अन्यथा \"NO\" ",null,null,"YES","80CCD(1B)  SPLIT FROM 80CCD1",null,{"$f":"IF(N48=\"YES\",Master!T31,0)","v":0}]
[null,null,null,null,null,null,null,7000,null,null,null,null,null,null,"संशोधित 80CCD(1)",null,{"$f":"IF(N48=\"YES\",Master!T30,0)","v":0}]

{"sheet":"Salary","index":2,"n_rows":32,"n_cols":16384,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,22,30,26],[5,8,5,10],[4,11,4,13],[13,34,13,35],[14,34,14,35],[15,34,15,35],[16,34,16,35],[17,34,17,35],[29,7,29,10],[6,1,6,11],[6,12,6,28],[9,34,9,37],[10,34,10,35],[11,34,11,35],[12,34,12,35],[28,1,28,2],[4,24,4,25],[5,4,5,6],[5,11,5,12],[0,4,0,11],[1,1,1,28],[2,1,2,28],[3,1,3,28],[4,1,4,4],[4,5,4,10],[4,14,4,17],[4,18,4,19],[4,20,4,23],[4,26,4,27],[0,14,0,28]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"आप अपनी आवश्यकता अनुसार सैलरी शीट की UNLOCKED CELL मे बदलाव कर सकते है तथा REFRESH SALARY बटन पर क्लिक कर पुनः प्रारम्भिक स्थिति मे आ सकते है। ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cader"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Service",null,null,"ALLOWANCES"]
[null,{"$f":"Master!AI3","v":"OFFICE OF THE PRINCIPAL GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subordinate",null,null,"CCA"]
[null,{"$f":"Master!AI4","v":" SALARY STATEMENT FOR FINANCIAL YEAR 2020-21"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ministrial",null,null,"WASHING ALLOWANCE"]
[null,"Name of the Employee",null,null,null,{"$f":"IF('Data Entry'!C5=\"\",\"\",'Data Entry'!C5)","v":"HANS RAJ JOSHI"},null,null,null,null,null,"Designation",null,null,{"$f":"IF('Data Entry'!$C$6=\"\",\"\",'Data Entry'!$C$6)","v":"PRINCIPAL"},null,null,null,"PAN ",null,{"$f":"IF('Data Entry'!Q5=\"\",\"\",'Data Entry'!Q5)","v":"XXXXX1234X"},null,null,null,"Date of Birth",null,{"$f":"IF('Data Entry'!H8=\"\",\"\",'Data Entry'!H8)","v":"1972-08-12"},null,null,null,null,null,null,null,null,null,null,null,"Class IV",null,null,"HANDICAPTED ALLWANCE"]
[null,"Employee ID",null,null,{"$f":"IF('Data Entry'!J5=\"\",\"\",'Data Entry'!J5)","v":"RJGA99999999999"},null,null,"Cader",{"$f":"IF('Data Entry'!C7=\"\",\"\",'Data Entry'!C7)","v":"State Service"},null,null,"Employee Type",null,{"$f":"IF('Data Entry'!R7=\"\",\"\",IF('Data Entry'!R7=\"Yes\",\"NPS\",\"OPS\"))","v":"OPS"},null,null,null,null,null,null,null,null,null,null,"Pay leval",{"$f":"IF('Data Entry'!J7=\"\",\"\",'Data Entry'!J7)","v":"L-23"},"Pay March",{"$f":"Master!$AH$10","v":75700},null,null,null,null,null,null,null,null,null,null,null,null,null,"ANY OTHER"]
[null,"PAY & ALLOWANCES",null,null,null,null,null,null,null,null,null,null,"DEDUCTIONS"]
[null,"SN","MONTH","BASIC","DA","HRA","CCA","Bonus","ANY OTHER","ANY OTHER","ARREAR","Gross Salary",{"$f":"IF('Data Entry'!R7=\"YES\",\"NPS\",\"GPF\")","v":"GPF"},"GPF 2004","SIP","SI LOAN","GPF LOAN","HBA","HBA INT","LIC","RPMF","GIS","CM CORONA RELIEF","INCOME TAX","ANY OTHER","Total Deduction","Net paid Amount","BILL NO","TV NO"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,{"$f":"Master!BA9","v":0},20,21,22,23,24,25,26,27,28]
[null,1,{"$f":"Master!AJ10","v":"2020-03-01"},{"$f":"Master!AK10","v":36629},{"$f":"Master!D7","v":6227},{"$f":"Master!E7","v":2930},{"$f":"Master!$H$5","v":0},null,null,null,null,{"$f":"ROUND((D10+E10+F10+G10+H10+I10+J10+K10),0)","v":45786},{"$f":"Master!S7","v":0},null,{"$f":"Master!T7","v":0},null,null,null,null,{"$f":"'Data Entry'!Q24","v":469},{"$f":"Master!P7","v":800},null,{"$f":"Master!W21","v":12210},{"$f":"'Data Entry'!C43","v":0},null,{"$f":"M10+N10+O10+P10+Q10+R10+S10+T10+U10+V10+W10+X10+Y10","v":13479},{"$f":"L10-Z10","v":32307},null,null,null,null,null,null,null,"SI PREMIUM FROM SALARY"]
[null,2,"2020-04-01",{"$f":"Master!AH11","v":75700},{"$f":"Master!D8","v":12869},{"$f":"Master!E8","v":6056},{"$f":"Master!G8","v":0},null,null,null,null,{"$f":"ROUND((D11+E11+F11+G11+H11+I11+J11+K11),0)","v":94625},{"$f":"Master!S8","v":"4800"},null,{"$f":"Master!T8","v":7000},null,null,null,null,{"$f":"T10","v":469},{"$f":"Master!P8","v":800},220,null,{"$f":"'Data Entry'!D43","v":3000},{"$f":"Y10","v":0},16289,{"$f":"L11-Z11","v":78336},null,null,null,null,null,null,null,"PAY RANGE",null,"2018-03-01","2020-03-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Master!AG11","v":"2020-04-01"}]
[null,3,"2020-05-01",{"$f":"Master!AH12","v":75700},{"$f":"Master!D9","v":12869},{"$f":"Master!E9","v":6056},{"$f":"Master!G9","v":0},null,null,null,null,94625,{"$f":"Master!S9","v":"4800"},null,{"$f":"Master!T9","v":14000},null,null,null,null,469,{"$f":"Master!P9","v":950},null,null,{"$f":"'Data Entry'!E43","v":3000},0,23219,71406,null,null,null,null,null,null,null,"UPTO 22000",null,500,800]
[null,4,"2020-06-01",{"$f":"Master!AH13","v":75700},{"$f":"Master!D10","v":12869},{"$f":"Master!E10","v":6056},{"$f":"Master!G10","v":0},null,null,null,null,94625,{"$f":"Master!S10","v":"4800"},null,{"$f":"Master!T10","v":7000},null,null,null,null,469,{"$f":"Master!P10","v":875},null,null,{"$f":"'Data Entry'!F43","v":3000},0,16144,78481,null,null,null,null,null,null,null,"22001 TO 28500",null,700,1200]
[null,5,"2020-07-01",{"$f":"Master!AH14","v":78000},{"$f":"Master!D11","v":13260},{"$f":"Master!E11","v":6240},{"$f":"Master!G11","v":0},null,null,null,null,97500,{"$f":"Master!S11","v":"4800"},null,{"$f":"Master!T11","v":7000},null,null,null,null,469,{"$f":"Master!P11","v":875},null,null,{"$f":"'Data Entry'!H43","v":3000},0,16144,81356,null,null,null,null,null,null,null,"28501TO 46500",null,1300,2200]
[null,6,"2020-08-01",{"$f":"Master!AH15","v":78000},{"$f":"Master!D12","v":13260},{"$f":"Master!E12","v":6240},{"$f":"Master!G12","v":0},null,null,null,null,97500,{"$f":"Master!S12","v":"4800"},null,{"$f":"Master!T12","v":7000},null,null,null,null,469,{"$f":"Master!P12","v":875},null,null,{"$f":"'Data Entry'!I43","v":3000},0,16144,81356,null,null,null,null,null,null,null,"46501 TO 72000",null,1800,3000]
[null,7,"2020-09-01",{"$f":"Master!AH16","v":78000},{"$f":"Master!D13","v":13260},{"$f":"Master!E13","v":6240},{"$f":"Master!G13","v":0},null,null,null,null,97500,{"$f":"Master!S13","v":"4800"},null,{"$f":"Master!T13","v":7000},null,null,null,null,469,{"$f":"Master!P13","v":875},null,{"$f":"Master!W22","v":6500},{"$f":"'Data Entry'!J43","v":12000},0,31644,65856,null,null,null,null,null,null,null,"ABOVE 72000",null,3000,5000]
[null,8,"2020-10-01",{"$f":"Master!AH17","v":78000},{"$f":"Master!D14","v":13260},{"$f":"Master!E14","v":6240},{"$f":"Master!G14","v":0},null,null,null,null,97500,{"$f":"Master!S14","v":"4800"},null,{"$f":"Master!T14","v":7000},null,null,null,null,469,{"$f":"Master!P14","v":875},null,{"$f":"Master!W23","v":6290},{"$f":"'Data Entry'!K43","v":12000},0,31434,66066,null,null,null,null,null,null,null,"MAXIMUM",null,4000,7000]
[null,9,"2020-11-01",{"$f":"Master!AH18","v":78000},{"$f":"Master!D15","v":13260},{"$f":"Master!E15","v":6240},{"$f":"Master!G15","v":0},null,null,null,null,97500,{"$f":"Master!S15","v":"4800"},null,{"$f":"Master!T15","v":7000},null,null,null,null,469,{"$f":"Master!P15","v":875},null,{"$f":"Master!W24","v":6500},{"$f":"'Data Entry'!L43","v":12000},0,31644,65856,null,null,null,null,null,null,null,"NO DEDUCTION",null,0,0]
[null,10,"2020-12-01",{"$f":"Master!AH19","v":78000},{"$f":"Master!D16","v":13260},{"$f":"Master!E16","v":6240},{"$f":"Master!G16","v":0},null,null,null,null,97500,{"$f":"Master!S16","v":"4800"},null,{"$f":"Master!T16","v":7000},null,null,null,null,469,{"$f":"Master!P16","v":875},null,{"$f":"Master!W25","v":6290},{"$f":"'Data Entry'!M43","v":12000},0,31434,66066]
[null,11,"2021-01-01",{"$f":"Master!AH20","v":78000},{"$f":"Master!D17","v":13260},{"$f":"Master!E17","v":6240},{"$f":"Master!G17","v":0},null,null,null,null,97500,{"$f":"Master!S17","v":"4800"},null,{"$f":"Master!T17","v":7000},null,null,null,null,469,{"$f":"Master!P17","v":875},null,{"$f":"Master!W26","v":6290},{"$f":"'Data Entry'!N43","v":12000},0,31434,66066]
[null,12,"2021-02-01",{"$f":"Master!AH21","v":78000},{"$f":"Master!D18","v":13260},{"$f":"Master!E18","v":6240},{"$f":"Master!G18","v":0},null,null,null,null,97500,{"$f":"Master!S18","v":"4800"},null,{"$f":"Master!T18","v":7000},null,null,null,null,{"$f":"T20","v":469},{"$f":"Master!P18","v":875},null,{"$f":"Master!W27","v":6964},{"$f":"'Data Entry'!O43","v":12000},0,32108,65392]
[null,13,"SURRENDER",{"$f":"Master!M6","v":39000},{"$f":"Master!N6","v":6630},null,null,null,null,null,null,45630,null,null,null,null,null,null,null,null,null,null,null,null,null,0,45630]
[null,14,"D.A.7/19 -12/19",null,{"$f":"Master!K36","v":22710},null,null,null,null,null,null,22710,{"$f":"Master!L36","v":22710},null,null,null,null,null,null,null,null,null,null,null,null,22710,0]
[null,15,"D.A.1/20 -2/20",null,{"$f":"Master!K39","v":7570},null,null,null,null,null,null,7570,{"$f":"Master!L39","v":7570},null,null,null,null,null,null,null,null,null,null,null,null,7570,0]
[null,16,"BONUS",null,null,null,null,{"$f":"Master!L3","v":0},null,null,null,0,{"$f":"IF(N6=\"OPS\",Master!M3,0)","v":0},{"$f":"IF(N6=\"NPS\",Master!M3,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,17,"ARREAR 1",null,null,null,null,null,null,null,{"$f":"Master!J21","v":0},0,{"$f":"'Data Entry'!E22","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!D22","v":0},null,0,0]
[null,18,"ARREAR 2",null,null,null,null,null,null,null,{"$f":"Master!M21","v":0},0,{"$f":"'Data Entry'!I22","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!H22","v":0},null,0,0]
[null,19,"ANY OTHER",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"TOTAL",null,{"$f":"SUM(D10:D28)","v":926729},{"$f":"SUM(E10:E28)","v":187824},{"$f":"SUM(F10:F28)","v":71018},{"$f":"SUM(G10:G28)","v":0},{"$f":"SUM(H10:H28)","v":0},{"$f":"I10+I11+I12+I13+I14+I15+I16+I17+I18+I19+I20+I21+I22+I23+I24+I25+I26+I27+I28","v":0},0,0,1185571,83080,0,84000,0,0,0,0,5628,10425,220,51044,87000,0,321397,864174]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!C9","v":"PRINCIPAL"}]
[null,null,null,null,"हस्ताक्षर कार्मिक",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!L9","v":"GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR"}]

{"sheet":"Assesment","index":3,"n_rows":69,"n_cols":23,"rows_kept":69,"cut":false,"hidden":false,"merged":[[25,20,27,20],[36,1,45,1],[1,19,2,20],[68,6,68,16],[68,2,68,5],[10,2,10,14],[8,2,8,11],[8,12,8,14],[9,2,9,11],[26,3,26,6],[26,10,26,12],[23,3,23,6],[23,10,23,12],[16,2,16,14],[18,2,18,14],[65,15,65,16],[66,5,66,8],[66,9,66,10],[66,12,66,13],[66,15,66,16],[67,1,67,14],[64,2,64,14],[65,1,66,1],[65,2,66,4],[19,1,34,1],[20,2,20,16],[21,3,21,6],[21,10,21,12],[21,15,30,16],[22,3,22,6],[22,10,22,12],[29,3,29,6],[29,10,29,12],[30,2,30,12],[31,2,31,14],[32,2,32,14],[33,2,33,14],[19,15,19,16],[7,1,9,1],[7,2,7,11],[7,12,7,14],[14,2,14,14],[15,2,15,14],[4,2,4,14],[5,2,5,14],[6,2,6,14],[9,12,9,14],[12,12,12,14],[65,5,65,8],[65,9,65,10],[35,2,35,16],[45,2,45,14],[46,2,46,14],[47,2,47,14],[48,2,48,14],[36,3,36,14],[44,3,44,14],[65,12,65,13],[63,2,63,14],[53,5,53,7],[54,5,54,7],[37,3,37,14],[38,3,38,14],[41,3,41,14],[42,3,42,14],[43,3,43,14],[24,10,24,12],[25,3,25,6],[49,1,62,1],[52,2,52,3],[53,2,53,3],[50,2,50,11],[50,12,50,14],[49,2,49,14],[56,2,57,11],[52,9,52,11],[51,12,51,13],[52,12,52,13],[53,12,53,13],[54,12,54,13],[55,12,55,13],[56,12,56,13],[54,2,54,3],[51,5,51,8],[53,9,53,10],[54,9,54,10],[55,2,55,3],[55,5,55,7],[55,9,55,10],[51,9,51,11],[57,12,57,13],[62,2,62,14],[51,2,51,4],[52,5,52,7],[58,2,58,14],[59,2,59,14],[60,2,60,14],[61,2,61,14],[3,11,3,13],[19,2,19,14],[17,2,17,14],[12,2,13,3],[28,3,28,6],[28,10,28,12],[27,3,27,6],[27,10,27,12],[24,3,24,6],[25,10,25,12],[39,3,39,14],[40,3,40,14],[34,2,34,14],[13,4,13,6],[13,7,13,9],[13,10,13,11],[0,0,0,17],[14,19,15,21],[12,19,13,19],[12,20,13,21],[1,16,2,16],[1,1,1,15],[6,19,7,20],[6,21,7,21],[10,19,11,19],[4,19,5,21],[11,12,11,14],[3,15,3,16],[11,15,13,16],[7,15,8,16],[13,12,13,14],[11,1,13,1],[11,2,11,9],[11,10,11,11],[12,4,12,6],[12,7,12,9],[12,10,12,11],[2,1,2,14],[3,2,3,3],[3,4,3,9]]}
[]
[null,{"$f":"Salary!B3","v":"OFFICE OF THE PRINCIPAL GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($W$2=1,\"OLD REGIME\",\"NEW REGIME\")","v":"NEW REGIME"},null,null,null,null,null,2]
[null,"आयकर गणना  प्रपत्र वर्ष 2020-21 (कर निर्धारण वर्ष 2021-22)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P51","v":"2"}]
[null,1,"नाम कार्मिक ",null,{"$f":"'Data Entry'!C5","v":"HANS RAJ JOSHI"},null,null,null,null,null,"पद",{"$f":"'Data Entry'!C6","v":"PRINCIPAL"},null,null,"PAN :",{"$f":"'Data Entry'!Q5","v":"XXXXX1234X"}]
[null,2,"आय : वर्ष 2020-21 में प्राप्त कुल वेतन (कर योग्य सुविधाओं के मूल्य सहित )",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"IF('Data Entry'!$R$7=\"NO\",Salary!$L$29,SUM(Salary!$L$29,Salary!$M$29))","v":1185571},null,null,"COMPARISION"]
[null,3,"गृह किराया, धारा 10(13-।) के अन्तर्गत एवं धारा 10(14)के अन्तगर्त अन्य भते जो कर मुक्त्त है",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"IF($P$3=\"1\",-SUM('Data Entry'!$H$17,'Data Entry'!$C$18),0)","v":0}]
[null,4,"                                                              शेष (2-3)",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"$Q$5+$Q$6","v":1185571},null,null,"OLD REGIME",null,"NEW REGIME"]
[null,5," (i)मनोरंजन भता धारा 16 (ii) के अन्तगर्त ( अधिकतम सीमा रू 5000 )",null,null,null,null,null,null,null,null,null,{"$f":"IF($P$3=\"1\",'Data Entry'!F18,0)","v":0}]
[null,null," (ii) व्यवयाय कर धारा 16 (iii) के अन्तगर्त",null,null,null,null,null,null,null,null,null,{"$f":"IF($P$3=\"1\",'Data Entry'!I18,0)","v":0},null,null,null,null,null,null,"TAX",{"$f":"Master!R97","v":136299},{"$f":"Master!S97","v":153843}]
[null,null," (iii) स्टेण्डर्ड डिडेक्शन(Standard Deduction)  50,000 (अधिकतम)",null,null,null,null,null,null,null,null,null,{"$f":"IF($P$3=\"1\",MIN($Q$7,50000),0)","v":0},null,null,"रु.",{"$f":"-SUM(M8:O10)","v":0},null,null,"CESS 4%",{"$f":"ROUND(U9*4%,0)","v":5452},{"$f":"ROUND(V9*4%,0)","v":6154}]
[null,6,"                                                          शेष (4-5)",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"Q7+Q10","v":1185571},null,null,"TOTAL",{"$f":"SUM(U9:U10)","v":141751},{"$f":"SUM(V9:V10)","v":159997}]
[null,7,"(अ)गृह सम्पति से आय : (1) स्वंय के उपयोग में    -शून्य",null,null,null,null,null,null,null,"(2) प्राप्त किराया रु.",null,{"$f":"'Data Entry'!E27","v":264000}]
[null,null,"(ब) घटायें ",null,"  किराये का 30%",null,null," गृह ऋण पर ब्याज ",null,null," गृहकर  ",null,"  योग 7(ब) ",null,null,null,null,null,null,"DIFFERENCE",{"$f":"U11-V11","v":-18246}]
[null,null,null,null,{"$f":"IF(OR($P$3=\"1\",$P$3=\"2\"),ROUND((M12-K14)*0.3,0),0)","v":76200},null,null,{"$f":"IF($P$3=\"1\",IF((Salary!$S$29+'Data Entry'!E30)>200000,200000,(Salary!$S$29+'Data Entry'!E30)),0)","v":0},null,null,{"$f":"IF(OR($P$3=\"1\",$P$3=\"2\"),'Data Entry'!E28,0)","v":10000},null,{"$f":"E14+H14+K14","v":86200}]
[null,null,"                                                         शेष -/+ (7(अ) एवं योग 7(ब) का)       ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"M12-M14","v":177800},null,null,{"$f":"IF(U11<V11,\"OLD REGIME IS BEST OPTION FOR YOU\",\"NEW REGIME IS BEST FOR YOU\")","v":"OLD REGIME IS BEST OPTION FOR YOU"}]
[null,null,"                                                              कुल शेष -/+ (6एवं 7)       ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"Q11+Q15","v":1363371}]
[null,8,"बचत खाते पर ब्याज ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"'Data Entry'!E24+'Data Entry'!E25","v":5000}]
[null,9,"अन्य आय ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"'Data Entry'!Q25","v":0},null,null,null,null,1]
[null,10,"सकल आय                                                            योग (8+9)",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"Q16+Q17","v":1368371}]
[null,11,"घटाइये कटौतियाँ:- धारा  US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1,50,000/- (धारा  80CCE ] (धारा 80CCD (2)) के अलावा "]
[null,null,"(i)","राज्य बीमा  (SI)",null,null,null,"रु.",{"$f":"IF($P$3=\"1\",Salary!$O$29,0)","v":0},"(x)","सरकारी पेंशन योजना में अंशदान  ECPF\nअधिकतम वेतन का 10% {धारा 80CCD(1) }",null,null,"रु.",{"$f":"IF('Data Entry'!$R$7=\"NO\",0,IF($P$3=\"2\",0,IF('Data Entry'!N48=\"YES\",'Data Entry'!Q49,Salary!$M$29)))","v":0}]
[null,null,"(ii)","जीवन बीमा प्रीमियम(LIC)",null,null,null,"रु.",{"$f":"IF($P$3=\"1\",Salary!$T$29+'Data Entry'!E31,0)","v":0},"(xi)","पेंशन प्लान हेतु अंशदान (धारा 80CCC)",null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!Q27,0)","v":0}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",null,null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!E35,0)","v":0},"(xii)","राष्ट्रीय बचत पत्र पर अदत ब्याज ",null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!E36,0)","v":0}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",null,null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!E37,0)","v":0},"(xiii)","टयूशन फीस",null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!E33,0)","v":0}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम (NSS)",null,null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!E38,0)","v":0},"(xiv)","इक्विटी लिंक सेविंग स्कीम",null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!Q36,0)","v":0},null,null,null,null,null,"GPF 2004 में जमा बोनस को 80C में लाभ लेने हेतु जोड़ना है तो YES अन्यथा NO का चयन करें"]
[null,null,"(vi)",{"$f":"IF('Data Entry'!R7=\"NO\",\"सामान्य प्रावधायी  निधि (GPF)\",\"जीपीएफ 2004\")","v":"सामान्य प्रावधायी  निधि (GPF)"},null,null,null,"रु.",{"$f":"IF(AND($P$3=\"1\",'Data Entry'!R7=\"NO\"),Salary!$M$29,IF(AND(Assesment!$P$3=\"1\",'Data Entry'!R7=\"YES\",U29=\"YES\"),Salary!N29,0))","v":0},"(xv)","स्थगित वार्षिकी (Defferred Annuty)",null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!Q37,0)","v":0}]
[null,null,"(vii)","सामूहिक बीमा प्रीमियम (G.Ins.)",null,null,null,"रु.",{"$f":"IF($P$3=\"1\",Salary!$V$29,0)","v":0},"(xvi)","पी.एल.आई. ¼PLI)",null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!E32,0)","v":0}]
[null,null,"(viii)","यू. एल. आई. पी./वार्षिक प्लान",null,null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!E34,0)","v":0},"(xvii)","अन्य जमाराशि (धारा 80 सी के अन्तर्गत) ",null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!Q26,0)","v":0},null,null,null,null,null,"YES"]
[null,null,"(ix)","गृह ऋण किस्त ¼HBA Premium)",null,null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!E29+Salary!$R$29,0)","v":0},"(xviii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!E39,0)","v":0}]
[null,null,"योग  [(i) से  (xviii)]",null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"SUM(I22:I30)+SUM(O22:O30)","v":0}]
[null,null,"                        अधिकतम कटौती की राशि 1.50 लाख रुपए तक",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"IF(O31<150001,ROUND(O31,0),150000)","v":0}]
[null,null,"(B) घटाइये- धारा 80CCD(2) नियोक्ता द्वारा पेंशन अंशदान की राशि (अधिकतम वेतन का 10% पृथक से छूट)",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"IF(AND('Data Entry'!R7=\"Yes\"),Salary!$M$29,0)","v":0}]
[null,null,"(C) घटाइये -धारा 80 CCD(1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रू. 50,000)",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!Q28,0)","v":0}]
[null,null,"योग 11(A+B+C)      ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"SUM(Q32:Q34)","v":0}]
[null,12," अन्य कटौतियाँ"]
[null,null,1,"धारा 80 D ,चिकित्सा बीमा प्रीमियम (स्वयं,पति/पत्नी व बच्चों के लिए रू 25000, माता-पिता के लिए रू 25000,सीनियर सिटीजन रू 50000)",null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"IF($P$3=\"1\",Master!R74,0)","v":0}]
[null,null,2,"धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80%या अधिक विकलांगता 125,000)   ",null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!Q30,0)","v":0}]
[null,null,3,"धारा 80DDB विशिष्ट रोंगों के उपचार हेतु कटौती (अधिकतम रू 40,000, सीनियर सिटीजन हेतु रू 100,000)","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","रु.",{"$f":"IF($P$3=\"1\",Master!R76,0)","v":0}]
[null,null,4,"धारा 80E उच्च शिक्षा हेतु लिए ऋण का ब्याज ","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!Q32,0)","v":0}]
[null,null,5,"धारा 80G धर्मार्थ संस्थाओं आदि को दिये दान ( क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!Q33+Salary!$W$29,0)","v":0}]
[null,null,6,"धारा 80U स्थाई रूप से शारीरिक असमर्थतता की दशा में (अधिकतम 75,000 तथा  अधिनियम 1995के अनुसार 125,000)","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!Q34,0)","v":0}]
[null,null,7,"धारा 80 TTA बचत खाते पर अधिकतम ब्याज रू. 10,000  ","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","रु.",{"$f":"IF($P$3=\"1\",Master!R80,0)","v":0}]
[null,null,8,"धारा 80 TTB वरिष्ठ नागरिकों को सभी ब्याज पर अधिकतम 50000रू.","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","रु.",{"$f":"IF($P$3=\"1\",Master!R81,0)","v":0}]
[null,null,9,"धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान ","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","रु.",{"$f":"IF($P$3=\"1\",'Data Entry'!Q35,0)","v":0}]
[null,null,"कुल योग 12 ( 1 से 9 तक ) ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"SUM(Q37:Q45)","v":0}]
[null,13,"कुल कटौती (11+12)",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"Q35+Q46","v":0}]
[null,14,"कर योग्य आय(10-13))",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"Q19-Q47","v":1368371}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना ( दस के गुणक में ) धारा 288A",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"ROUND(Q48,-1)","v":1368370}]
[null,16," आयकर की गणना  उपरोक्त कॉलम 15 के आधार पर "]
[null,null,"1.OLD REGIME",null,null,null,null,null,null,null,null,null,"2.NEW REGIME",null,null,{"$f":"IF($Q$51=\"OLD REGIME\",\"1\",\"2\")","v":"2"},{"$f":"Q2","v":"NEW REGIME"}]
[null,null,"एक व्यक्ति कर दाता",null,null,"वरिष्ठ नागरिक (60 से 80 वर्ष तक)",null,null,null,"80 वर्ष या अधिक आयु",null,null,"0    - 2,50,000 ",null,0,null,{"$f":"IF($P$51=\"1\",\"\",IF($P$51=\"1\",Master!R90,Master!S90))","v":0}]
[null,null,"250000 तक ",null,"Nil","3,00,000 तक",null,null,"Nil",null,null,null,"2,50,001 - 5,00,000",null,0.05,"रु.",{"$f":"IF($P$51=\"1\",Master!R91,Master!S91)","v":12500}]
[null,null,"2,50,001-5,00,000",null,0.05,"3,00,001-5,00,000",null,null,0.05,"5,00,000 तक",null,"Nil","5,00,001 -  7,50,000",null,0.1,"रु.",{"$f":"IF($P$51=\"1\",Master!R92,Master!S92)","v":25000}]
[null,null,"5,00,001-10,00,000",null,0.2,"5,00,001-10,00,000",null,null,0.2,"5,00,001-10,00,000",null,0.2,"7,50,001 - 10,00,000",null,0.15,"रु.",{"$f":"IF($P$51=\"1\",Master!R93,Master!S93)","v":37500}]
[null,null,"10,00,000 से अधिक",null,0.3,"10,00,000 से अधिक",null,null,0.3,"10,00,000 से अधिक",null,0.3,"10,00,001- 12,50,000",null,0.2,"रु.",{"$f":"IF($P$51=\"1\",Master!R94,Master!S94)","v":50000}]
[null,null,null,null,null,null,null,null,null,null,null,null,"12,50,001- 15,00,000",null,0.25,"रु.",{"$f":"IF($P$51=\"1\",\"\",IF($P$51=\"1\",Master!R95,Master!S95))","v":28843}]
[null,null,null,null,null,null,null,null,null,null,null,null," Above 15,00,000",null,0.3,"रु.",{"$f":"IF($P$51=\"1\",\"\",IF($P$51=\"1\",Master!R96,Master!S96))","v":0}]
[null,null,"(1) योग आयकर ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"SUM(Q53:Q58)","v":153843}]
[null,null,"(2) छूट घारा 87(।) (2.50 लाख से 5.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रू. 12500 तक)   ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"IF(Q49>500000,0,IF(Q59<12501,Q59,12500))","v":0}]
[null,null,"(3) शेष आयकर (1-2) ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"Q59-Q60","v":153843}]
[null,null,"(4) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2%  (योग 4%)  ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"ROUND(Q61*0.04,0)","v":6154}]
[null,null,"                                                             कुल आयकर (3+4)",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"SUM(Q61:Q62)","v":159997}]
[null,17,"                                                             घटाइये :- राहत धारा 89 के तहत ",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"IF('Data Entry'!Q38=\"\",0,'Data Entry'!Q38)","v":0}]
[null,18,"                                                            कुल शेष आयकर",null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"Q63-Q64","v":159997}]
[null,19,"स्रोत पर आयकर कटौती\n का विवरण",null,null,"सितम्बर 2020\nतक  रूपये",null,null,null,"दिसम्बर 2020\nतक  रूपये",null,"जनवरी 2021","फरवरी 2021",null,"टी .डी.एस.एरियर आदि से\nरूपये","TDS योग"]
[null,null,null,null,null,{"$f":"SUM(Salary!X10:X16)","v":27000},null,null,null,{"$f":"SUM(Salary!X17:X19)","v":36000},null,{"$f":"SUM(Salary!X20)","v":12000},{"$f":"SUM(Salary!X21)","v":12000},null,{"$f":"SUM(Salary!X22:X28)","v":0},{"$f":"SUM(F67,J67,L67,M67,O67)","v":87000}]
[null,{"$f":"IF(Q65>P67,\"Income Tax Payable\",IF(Q65<P67,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},null,null,null,null,null,null,null,null,null,null,null,null,null,"रु.",{"$f":"IF(Q65>P67,Q65-P67,P67-Q65)","v":72997}]
[null,null,"हस्ताक्षर कार्मिक "]

{"sheet":"Master","index":4,"n_rows":100,"n_cols":57,"rows_kept":100,"cut":false,"hidden":true,"merged":[[91,4,91,6],[91,13,91,14],[23,4,23,6],[25,2,25,3],[25,4,25,6],[20,4,20,6],[49,1,50,2],[49,3,49,5],[50,3,50,5],[50,6,50,8],[26,2,26,3],[26,4,26,6],[40,1,40,2],[50,13,50,15],[50,9,50,10],[39,0,39,15],[27,2,27,6],[49,9,49,10],[49,6,49,8],[44,0,46,0],[44,1,44,10],[81,1,81,15],[49,13,49,15],[48,0,50,0],[10,34,10,35],[18,21,18,22],[86,9,86,16],[40,16,40,17],[41,1,41,15],[42,1,42,15],[43,1,43,15],[61,9,61,13],[53,1,53,15],[55,1,55,15],[54,1,54,15],[46,13,46,15],[82,1,82,15],[80,1,80,13],[74,1,74,15],[14,26,14,27],[15,26,15,27],[16,21,16,22],[45,13,45,15],[77,1,77,15],[64,2,64,5],[51,1,51,15],[52,1,52,15],[48,16,50,17],[8,26,8,29],[9,26,9,27],[10,26,10,27],[11,26,11,27],[12,26,12,27],[13,26,13,27],[5,26,5,27],[6,26,6,27],[0,0,0,18],[3,11,3,14],[1,15,2,16],[1,17,2,17],[4,15,4,17],[3,26,3,27],[1,21,1,25],[1,26,1,30],[2,21,2,23],[2,24,2,25],[2,26,2,27],[4,26,4,27],[4,3,5,3],[4,2,5,2],[48,1,48,8],[48,9,48,10],[48,13,48,15],[76,1,76,15],[95,13,95,14],[87,13,87,16],[90,0,90,1],[91,0,91,1],[92,0,92,1],[93,0,93,1],[94,4,94,6],[94,8,94,9],[94,13,94,14],[92,4,92,6],[92,13,92,14],[93,4,93,6],[87,1,87,10],[88,1,88,3],[89,13,89,14],[93,13,93,14],[90,4,90,6],[89,9,89,12],[89,4,89,8],[79,0,80,0],[56,0,71,0],[56,1,56,17],[57,1,57,17],[78,1,78,15],[79,1,79,15],[75,1,75,15],[64,9,64,13],[61,2,61,5],[63,2,63,5],[63,9,63,13],[60,2,60,5],[60,9,60,13],[58,2,58,5],[58,16,67,17],[59,2,59,5],[59,9,59,13],[18,9,18,11],[18,12,18,14],[46,1,46,10],[72,1,72,17],[73,1,73,15],[23,1,23,3],[22,1,22,3],[21,1,21,3],[20,1,20,3],[22,4,22,6],[21,4,21,6],[24,4,24,6],[27,11,27,12],[19,2,19,3],[27,16,27,18],[44,13,44,15],[45,1,45,10],[29,17,29,18],[30,17,30,18],[26,16,26,18],[25,17,25,20],[44,16,45,17],[58,9,58,13],[19,4,19,6],[99,1,99,15],[97,6,97,16],[47,1,47,15],[96,14,96,16],[83,1,83,15],[84,1,84,15],[85,1,85,15],[68,1,68,15],[69,1,69,15],[70,1,70,15],[71,1,71,15],[65,2,65,5],[65,9,65,13],[66,2,66,5],[66,9,66,13],[67,1,67,13],[62,2,62,5],[62,9,62,13],[91,9,91,10],[92,9,92,10],[90,9,90,10],[90,13,90,14],[93,9,93,10],[94,0,94,1]]}
["Master Sheet"]
[null,null,null,null,"EMPLOYEE TYPE",null,{"$f":"Salary!N6","v":"OPS"},null,{"$f":"'Data Entry'!H8","v":"1972-08-12"},null,null,"Bonus",{"$f":"'Data Entry'!H15","v":"No"},"Bonus months",{"$f":"'Data Entry'!L15","v":12}," EMPLOYEE FROM MEDICAL DEP.,JUDICIARY DEP.POLICE CONSTABLE OR CLASS IV(L-1 TO L-4)",null,false,null,null,null,null,null,null,null,null,"rpmf"]
[null,{"$f":"'Data Entry'!C5","v":"HANS RAJ JOSHI"},null,{"$f":"'Data Entry'!C6","v":"PRINCIPAL"},{"$f":"'Data Entry'!C7","v":"State Service"},null,{"$f":"'Data Entry'!J7","v":"L-23"},{"$f":"'Data Entry'!J5","v":"RJGA99999999999"},{"$f":"'Data Entry'!Q5","v":"XXXXX1234X"},null,"HRA exemption",{"$f":"IF(M2=\"No\",0,ROUND((6774*O2/12),0))","v":0},{"$f":"ROUND(L3*75%,0)","v":0},{"$f":"L3-M3","v":0},null,null,null,null,null,null,null,null,null,null,"deduction",null,"PAY RANGE",null,"2019-04-01","2020-04-01","ded","DIFFERENCE",null,null,{"$f":"CONCATENATE('Data Entry'!$G$6&\" OF THE \"&'Data Entry'!$C$9&\" \"&'Data Entry'!$L$9)","v":"OFFICE OF THE PRINCIPAL GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR"}]
[null,{"$f":"AH10","v":75700},null,null,"HRA",null,"CCA","MARCH CCA","CPF",null,"SURRENDER","surrender  2020-21",null,null,null,null,null,null,null,null,null,null,"2017-10-01","2018-03-01",{"$f":"IF(Salary!$D$11<23001,1450,IF(Salary!$D$11<28001,1625,IF(Salary!$D$11<38501,2100,IF(Salary!$D$11<51501,2850,IF(Salary!$D$11<62001,3575,IF(Salary!$D$11<72001,4200,IF(Salary!$D$11<80001,4800)))))))","v":4800},{"$f":"IF(Salary!$D$11<116001,6150,IF(Salary!$D$11<167001,8900,10500))","v":6150},"UP TO   18000",null,242,265,{"$f":"IF($G$2=\"OPS\",IF(Salary!$AB$6<18001,265,IF(Salary!$AB$6<33501,440,IF(Salary!$AB$6<54001,658,875))),\"\")","v":875},{"$f":"AD4-AC4","v":23},null,null," SALARY STATEMENT FOR FINANCIAL YEAR 2020-21"]
[null,null,"Salary","DA17%",{"$f":"'Data Entry'!E13","v":"Yes"},null,{"$f":"'Data Entry'!E14","v":"No "},{"$f":"IF($R$2=TRUE,$G$7,IF($Y$18=\"State Service\",ROUND($G$7*15/31,0),IF(AND($Y$18=\"Subordinate\",AND(AL8<=9,AL8>=5)),ROUND($G$7/31*22,0),IF(AND($Y$18=\"Subordinate\",$Z$18>9),ROUND($G$7/31*15,0),IF($Y$18=\"Ministrial\",ROUND($G$7/31*22,0),$G$7)))))","v":0},null,null,null,"month","pay","da","total","DEDUCTION",null,null,null,null,null,null,500,1450,null,null,"18001 TO 33500",null,402,440,null,{"$f":"AD5-AC5","v":38}]
[null,"Month",null,null,{"$f":"'Data Entry'!I13","v":0.08},null,{"$f":"'Data Entry'!K14","v":"JODHPUR"},null,"GROSS SALARY",null,null,{"$f":"IF('Data Entry'!C15=\"Yes\",'Data Entry'!$D$15,\"\")","v":8},{"$f":"IF(L6=\"\",0,IF(ISNA(ROUND(VLOOKUP($L$6,Master!$A$7:$D$18,3,0)/2,0)),0,ROUND(VLOOKUP($L$6,Master!$A$7:$D$18,3,0)/2,0)))","v":39000},{"$f":"IF(M6=\"\",\"\",ROUND(M6*17%,0))","v":6630},{"$f":"SUM(M6:N6)","v":45630},"RPMF","GPF1","GPF2","NPS","SI","SI",null,650,1625,null,null,"33501 TO 54000",null,602,658,null,56]
[3,"march",{"$f":"Salary!D10","v":36629},{"$f":"ROUND(C7*17%,0)","v":6227},{"$f":"IF($E$5=\"Yes\",ROUND(C7*$E$6,0),0)","v":2930},null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C7>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L10","v":45786},null,null,null,null,null,null,{"$f":"IF(AND($G$2=\"OPS\",AH10>0),IF(AH10<=18000,242,IF(AH10<=33500,402,IF(AH10<=54000,602,800))),0)","v":800},null,null,{"$f":"IF($G$2=\"NPS\",ROUND((C7+D7)*10%,0),R7)","v":0},0,null,null,1100,2100,null,null,"54001 & ABOVE",null,800,875,null,75]
[4,"april",{"$f":"Salary!D11","v":75700},{"$f":"ROUND(C8*17%,0)","v":12869},{"$f":"IF($E$5=\"Yes\",ROUND(C8*$E$6,0),0)","v":6056},null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C8>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L11","v":94625},null,null,null,null,null,null,{"$f":"IF(AND($G$2=\"OPS\",AH11>0),IF(AH11<=18000,242,IF(AH11<=33500,402,IF(AH11<=54000,602,800))),0)","v":800},{"$f":"IF(C8>80000,\"6150\",IF(C8>72000,\"4800\",IF(C8>62000,\"4200\",IF(C8>51500,\"3575\",IF(C8>38500,\"2850\",IF(C8>28500,\"2100\",IF(C8>23100,\"1625\",IF(C8>17700,\"1450\",\"0\"))))))))","v":"4800"},{"$f":"IF(C8>167000,\"10500\",IF(C8>116000,\"8900\",Q8))","v":"4800"},{"$f":"IF($G$2=\"NPS\",ROUND((C8+D8)*10%,0),R8)","v":"4800"},{"$f":"AE10","v":7000},null,null,1450,2850,null,null,null,null,null,null,null,null,null,null,"ACP MONTH","pay after acp"]
[5,"may",{"$f":"Salary!D12","v":75700},{"$f":"ROUND(C9*17%,0)","v":12869},6056,null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C9>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L12","v":94625},null,null,null,null,null,null,{"$f":"IF(AND($G$2=\"OPS\",AH10>0),IF(AH12<=18000,288,IF(AH12<=33500,478,IF(AH12<=54000,714,950))),0)","v":950},{"$f":"IF(C9>72000,\"4800\",IF(C9>62000,\"4200\",IF(C9>51500,\"3575\",IF(C9>38500,\"2850\",IF(C9>28500,\"2100\",IF(C9>23100,\"1625\",IF(C9>17700,\"1450\",\"0\")))))))","v":"4800"},{"$f":"IF(C9>167000,\"10500\",IF(C9>116000,\"8900\",IF(C9>80000,\"6150\",Q9)))","v":"4800"},"4800",{"$f":"AE10*2","v":14000},null,null,2100,3575,null,null,"SI PREMIUM FROM SALARY",null,null,null,null,null,"MONTH","BASIC",{"$f":"'Data Entry'!I12","v":0},{"$f":"IF(OR('Data Entry'!I12=\"\",'Data Entry'!Q12=\"\"),\"\",'Data Entry'!$Q$12)","v":""},null,"L-1",1]
[6,"june",{"$f":"Salary!D13","v":75700},12869,6056,null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C10>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L13","v":94625},null,null,null,null,null,null,{"$f":"IF(AND($G$2=\"OPS\",AH10>0),IF(AH13<=18000,265,IF(AH13<=33500,440,IF(AH13<=54000,658,875))),0)","v":875},"4800","4800","4800",{"$f":"AE10","v":7000},null,null,3300,4200,null,null,"PAY RANGE",null,"2018-03-01","2020-03-01",{"$f":"IF('Data Entry'!F48=\"YES\",'Data Entry'!H49,IF(Salary!$AB$6<22001,800,IF(Salary!$AB$6<28501,1200,IF(Salary!$AB$6<46501,2200,IF(Salary!$AB$6<72001,3000,5000)))))","v":7000},{"$f":"ROW(AF10)-7","v":3},"2020-03-01",{"$f":"IF($AI$9=ROW(AG10)-7,'Data Entry'!$Q$12,'Data Entry'!$C$12)","v":75700},"march basic","2020-03-01",{"$f":"IF($R$2=TRUE,$AH$10,IF($Y$18=\"State Service\",ROUND($AH$10*15/31,0),IF(AND($Y$18=\"Subordinate\",AND(Z18<=9,Z18>=5)),ROUND($AH$10/31*22,0),IF(AND($Y$18=\"Subordinate\",$Z$18>9),ROUND($AH$10/31*15,0),IF($Y$18=\"Ministrial\",ROUND($AH$10/31*22,0),$AH$10)))))","v":36629},"L-2",2]
[7,"july",{"$f":"Salary!D14","v":78000},13260,6240,null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C11>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L14","v":97500},null,null,null,null,null,null,875,"4800","4800","4800",{"$f":"T10","v":7000},null,null,4100,4800,null,null,"UPTO 22000",null,500,800,null,{"$f":"ROW(AF11)-7","v":4},"2020-04-01",{"$f":"IF($AI$9=ROW(AG11)-7,'Data Entry'!$Q$12,AH10)","v":75700},null,null,null,"L-3",3]
[8,"august",{"$f":"Salary!D15","v":78000},13260,6240,null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C12>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L15","v":97500},null,null,null,null,null,null,875,"4800","4800","4800",7000,null,null,5200,6150,null,null,"22001 TO 28500",null,700,1200,null,5,"2020-05-01",{"$f":"IF($AI$9=ROW(AG12)-7,'Data Entry'!$Q$12,AH11)","v":75700},null,null,null,"L-4",4]
[9,"september",{"$f":"Salary!D16","v":78000},13260,6240,null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C13>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L16","v":97500},null,null,null,null,null,null,875,"4800","4800","4800",7000,null,null,5700,8900,null,null,"28501TO 46500",null,1300,2200,null,6,"2020-06-01",{"$f":"IF($AI$9=ROW(AG13)-7,'Data Entry'!$Q$12,AH12)","v":75700},null,null,null,"L-5",5]
[10,"october",{"$f":"Salary!D17","v":78000},13260,6240,null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C14>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L17","v":97500},null,null,null,null,null,null,875,"4800","4800","4800",7000,null,null,6200,10500,null,null,"46501 TO 72000",null,1800,3000,null,7,"2020-07-01",{"$f":"IF($AI$9=ROW(AG14)-7,'Data Entry'!$Q$12,MROUND(AH13*103%,100))","v":78000},null,null,null,"L-6",6]
[11,"november",{"$f":"Salary!D18","v":78000},13260,6240,null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C15>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L18","v":97500},null,null,null,null,null,null,875,"4800","4800","4800",7000,null,null,null,null,null,null,"ABOVE 72000",null,3000,5000,null,8,"2020-08-01",{"$f":"IF($AI$9=ROW(AG15)-7,'Data Entry'!$Q$12,AH14)","v":78000},null,null,null,"L-7",7]
[12,"december",{"$f":"Salary!D19","v":78000},13260,6240,null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C16>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L19","v":97500},null,null,null,null,null,null,875,"4800","4800","4800",7000,null,null,null,null,null,null,"MAXIMUM",null,4000,7000,null,9,"2020-09-01",{"$f":"IF($AI$9=ROW(AG16)-7,'Data Entry'!$Q$12,AH15)","v":78000},null,null,null,"L-8",8]
[1,"january",{"$f":"Salary!D20","v":78000},13260,6240,null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C17>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L20","v":97500},null,null,null,null,null,null,875,"4800","4800","4800",7000,null,"CM CORONA RELIEF",null,1,"cader","Pay Leval",null,null,null,null,null,10,"2020-10-01",{"$f":"IF($AI$9=ROW(AG17)-7,'Data Entry'!$Q$12,AH16)","v":78000},null,null,null,"L-9",9]
[2,"february",{"$f":"Salary!D21","v":78000},13260,6240,null,{"$f":"IFERROR(IF($G$5=\"Yes\",IF('Data Entry'!$K$14=\"\",0,IF(C18>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0),\"\")","v":0},null,{"$f":"Salary!L21","v":97500},null,null,null,null,null,null,875,"4800","4800","4800",7000,null,null,null,null,{"$f":"'Data Entry'!C7","v":"State Service"},{"$f":"VLOOKUP('Data Entry'!$J$7,AL9:AM32,2,0)","v":23},null,null,null,null,null,11,"2020-11-01",{"$f":"IF($AI$9=ROW(AG18)-7,'Data Entry'!$Q$12,AH17)","v":78000},null,null,null,"L-10",10]
[null,null,null,null,null,"WHOLE YEAR",null,"PARTIALY",null,"arrear1",null,null,"arrear2",null,null,null,null,"cca","PAY>23100","PAY=<23100",null,"cm corona relief",null,null,null,null,null,null,null,null,null,12,"2020-12-01",{"$f":"IF($AI$9=ROW(AG19)-7,'Data Entry'!$Q$12,AH18)","v":78000},null,null,null,"L-11",11]
[null,null,"वेतन (PAY+DA)",null,{"$f":"ROUND(SUM(Salary!D10:D21,Salary!E10:E21),0)","v":1038643},null,null,{"$f":"ROUND(HRA!$D$18,0)","v":1038643},null,"राशि ","TDS",{"$f":"IF(J2=\"Yes\",\"NPS\",\"GPS\")","v":"GPS"},"राशि ","TDS",{"$f":"IF(J2=\"Yes\",\"NPS\",\"GPF\")","v":"GPF"},null,null,"JAIPUR(U)",1000,620,null,"month","deduction",null,null,null,null,null,null,null,null,13,"2021-01-01",{"$f":"IF($AI$9=ROW(AG20)-7,'Data Entry'!$Q$12,AH19)","v":78000},null,null,null,"L-12",12]
["A","HRA RECEIVED",null,null,{"$f":"SUM(Salary!F10:F21)","v":71018},null,null,{"$f":"HRA!E18","v":71018},null,{"$f":"'Data Entry'!C22","v":0},{"$f":"'Data Entry'!D22","v":0},{"$f":"'Data Entry'!E22","v":0},{"$f":"'Data Entry'!F22","v":0},{"$f":"'Data Entry'!H22","v":0},{"$f":"'Data Entry'!H22","v":0},null,null,"JODHPUR",620,320,null,"2020-03-01",{"$f":"IF(OR($Y$18=\"All India Services\",$Y$18=\"State Service\"),ROUND(AH10/31*5,0),IF(AND($Y$18=\"Subordinate\",$Z$18>9),ROUND(AH10/31*3,0),IF(AND($Y$18=\"Subordinate\",OR(Z18>4,Z18<10)),ROUND(AH10/31*2,0),IF($Y$18=\"Ministrial\",ROUND(AH10/31*2,0),IF(OR($Y$18=\"Class IV\",$Z$18<5),ROUND(AH10/31*1,0))))))","v":12210},null,null,"IF(C8>167000,\"10500\",IF(C8>116000,\"8900\",Q8",null,null,null,null,null,14,"2021-02-01",{"$f":"IF($AI$9=ROW(AG21)-7,'Data Entry'!$Q$12,AH20)","v":78000},null,null,null,"L-13",13]
[null,"10% of SALARY(PAY+DA)",null,null,{"$f":"ROUND(E20*10%,0)","v":103864},null,null,{"$f":"ROUND(HRA!$D$18*10%,0)","v":103864},null,null,null,null,null,null,null,null,"March","AJMER",620,320,null,"sep",{"$f":"IF($R$2=TRUE,0,IF(OR($Y$18=\"Class IV\",$Z$18<5),0,IF(OR($Y$18=\"All India Services\",$Y$18=\"State Service\"),ROUND(Salary!L16/30*2,0),ROUND(Salary!L16/30,0))))","v":6500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-14",14]
[null,"RENT PAID ANNUALY",null,null,{"$f":"'Data Entry'!C17","v":0},null,null,{"$f":"'Data Entry'!C17","v":0},null,null,null,null,null,null,null,null,"April","BIKANER",620,320,null,"oct",{"$f":"IF($R$2=TRUE,0,IF(OR($Y$18=\"Class IV\",$Z$18<5),0,IF(OR($Y$18=\"All India Services\",$Y$18=\"State Service\"),ROUND(Salary!L17/31*2,0),ROUND(Salary!L17/31,0))))","v":6290},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-15",15]
["B","Rent paid ( Annual )-10% of Salary received ( Basic + DA )",null,null,{"$f":"$E$23-$E$22","v":-103864},null,null,{"$f":"H23-H22","v":-103864},null,null,null,null,null,null,null,null,"May","KOTA",620,320,null,"nov",{"$f":"IF($R$2=TRUE,0,IF($X$17=2,0,IF(X24=FALSE,0,IF(OR($Y$18=\"Class IV\",$Z$18<5),0,IF(OR($Y$18=\"All India Services\",$Y$18=\"State Service\"),ROUND(Salary!L18/30*2,0),ROUND(Salary!L18/30,0))))))","v":6500},true,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-16",16]
["C","40% OF PAY",{"$f":"HRA!J5","v":"NON METRO"},null,{"$f":"IF($C$25=\"METRO\",ROUND(E20*50%,0),ROUND(E20*40%,0))","v":415457},null,null,{"$f":"ROUND(HRA!$D$18*40%,0)","v":415457},null,null,null,null,null,null,null,null,null,null,null,null,null,"dec",{"$f":"IF($R$2=TRUE,0,IF($X$17=2,0,IF(X25=FALSE,0,IF(OR($Y$18=\"Class IV\",$Z$18<5),0,IF(OR($Y$18=\"All India Services\",$Y$18=\"State Service\"),ROUND(Salary!L19/31*2,0),ROUND(Salary!L19/31,0))))))","v":6290},true,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-17",17]
[null,null,"HRA rent receipt req",null,{"$f":"$E$21+$E$22","v":174882},null,null,{"$f":"H22+H21","v":174882},null,null,null,null,null,null,null,null,null,"80CCD(1B)",null,null,null,"jan",{"$f":"IF($R$2=TRUE,0,IF($X$17=2,0,IF(X26=FALSE,0,IF(OR($Y$18=\"Class IV\",$Z$18<5),0,IF(OR($Y$18=\"All India Services\",$Y$18=\"State Service\"),ROUND(Salary!L20/31*2,0),ROUND(Salary!L20/31,0))))))","v":6290},true,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-18",18]
[null,null,"HRA exemption",null,{"$f":"IF($E$24>0,MIN($E$21,$E$24,$E$25),0)","v":0},null,null,{"$f":"IF($H$24>0,MIN($H$21,$H$24,$H$25),0)","v":0},null,null,null,null,null,null,null,null,"SUM OF 80C",null,null,{"$f":"H59+H60+H61+H62+H63+H64+H65+H66+H67+P60+P61+P62+P63+P64+P65+P66+P67+R70","v":280091},null,"feb",{"$f":"IF($R$2=TRUE,0,IF($X$17=2,0,IF(X27=FALSE,0,IF(OR($Y$18=\"Class IV\",$Z$18<5),0,IF(OR($Y$18=\"All India Services\",$Y$18=\"State Service\"),ROUND(Salary!L21/28*2,0),ROUND(Salary!L21/28,0))))))","v":6964},true,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-19",19]
[null,{"$f":"IF('Data Entry'!R7=\"Yes\",\"NPS\",\"OPS\")","v":"OPS"},"DA ARREAR",null,null,null,null,"surrender 2019-20 arrear",null,"month",{"$f":"IF('Data Entry'!P20=\"Yes\",'Data Entry'!S20,0)","v":0},"total",null,null,null,null,"80CCD(1B) ADDITIONAL",null,null,{"$f":"IF('Data Entry'!K28>50000,50000,'Data Entry'!K28)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-20",20]
[null,null,"MONTH","PAY","DA5%",null,null,"PAY","DA5%",null,"total","GPF/nps","CASH",null,null,null,"80CCD 1",{"$f":"R70","v":0},"80C EXCEED 1.5LAC",{"$f":"IF(G2=\"OPS\",0,IF(T27>150000,T27-150000,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-21",21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,7,"2019-07-01",{"$f":"'Data Entry'!C12","v":75700},{"$f":"ROUND(D30*5%,0)","v":3785},null,null,{"$f":"IF($K$28=B30,ROUND(D30/2,0),0)","v":0},{"$f":"ROUND(H30*5%,0)","v":0},null,{"$f":"E30+I30","v":3785},{"$f":"IF($B$28=\"OPS\",K30,ROUND(K30*10%,0))","v":3785},{"$f":"K30-L30","v":0},null,null,null,null,"REVISED 80CCD1",null,{"$f":"IFERROR(SUM(R29)-'Data Entry'!Q48,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-22",22]
[null,8,"2019-08-01",{"$f":"D30","v":75700},3785,null,null,{"$f":"IF($K$28=B31,ROUND(D31/2,0),0)","v":0},{"$f":"ROUND(H31*5%,0)","v":0},null,3785,{"$f":"IF($B$28=\"OPS\",K31,ROUND(K31*10%,0))","v":3785},0,null,null,null,null,"80CCD(1B) SPLIT FROM 80CCD1",null,{"$f":"IF(OR('Data Entry'!R7=\"NO\",T27<150000),0,IF(R29>=T29,MIN((50000-T28),T29),MIN(R29,50000-T28)))","v":0},null,null,"T29>50000,50000-T28,U29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-23",23]
[null,9,"2019-09-01",{"$f":"D31","v":75700},3785,null,null,0,0,null,3785,3785,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L-24",24]
[null,10,"2019-10-01",{"$f":"D32","v":75700},3785,null,null,0,0,null,3785,3785,0]
[null,11,"2019-11-01",{"$f":"D33","v":75700},3785,null,null,0,0,null,3785,3785,0]
[null,12,"2019-12-01",{"$f":"D34","v":75700},3785,null,null,0,0,null,3785,3785,0]
[null,null,"TOTAL(7/19-12/19)",null,{"$f":"SUM(E30:E35)","v":22710},null,null,{"$f":"SUM(H30:H35)","v":0},0,null,22710,22710,0]
[null,1,"2020-01-01",{"$f":"D30","v":75700},{"$f":"ROUND(D37*5%,0)","v":3785},null,null,0,0,null,{"$f":"E37+I37","v":3785},3785,{"$f":"K37-L37","v":0}]
[null,2,"2020-02-01",{"$f":"D31","v":75700},{"$f":"ROUND(D38*5%,0)","v":3785},null,null,0,0,null,{"$f":"E38+I38","v":3785},3785,{"$f":"K38-L38","v":0},null,null,null,null,"OLD","NEW"]
[null,null,"TOTAL(1/20-2/20)",null,{"$f":"SUM(E37:E38)","v":7570},null,null,{"$f":"SUM(H37:H38)","v":0},0,null,7570,7570,0]
["vk;dj x.kuk izi= o\"kZ 2019&2020¼dj fu/kkZj.k o\"kZ 2020&2021½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"OLD REGIME","NEW REGIME"]
[1,"uke deZpkjh %",null,null,null,null,null,null,null," in %",null,null,null,null,null,"PAN :",{"$f":"'Data Entry'!L41","v":0}]
[2,"vk; %  o\"kZ&2019&20 esa izkIr dqy osru ¼ dj ;ksX; lqfo/kkvksa ds eqY; lfgr ½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"IF('Data Entry'!$R$7=\"NO\",Salary!L29,SUM(Salary!L29,Salary!M29))","v":1185571},{"$f":"IF('Data Entry'!$R$7=\"NO\",Salary!L29,SUM(Salary!L29,Salary!M29))","v":1185571}]
[3,"x`g fdjk;k] /kkjk 10¼13&A½ ds vUrxrZ ,oa /kkjk 10¼14½ds vUrxrZ vU; Hkrs tks dj eqDÙk gSA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"-SUM('Data Entry'!$H$17,'Data Entry'!$C$18)","v":0},0]
[4,"                                                              'ks\"k ¼2&3½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"$R$42+$R$43","v":1185571},{"$f":"$R$42+$R$43","v":1185571}]
[5," ¼i½euksjatu Hkrk /kkjk 16 ¼ii½ ds vUrxrZ ¼ vf/kdre lhek : 5000 ½",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!F18","v":0},null,null,null,null,0]
[null," ¼ii½ O;o;k; dj /kkjk 16 ¼iii½ ds vUrxrZ ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!I18","v":0},null,null,null,null,0]
[null," ¼iiI½ LVs.MMZ fMMsD'ku (Standard Deduction)  50]000 ¼vf/kdre½",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN($R$44,50000)","v":50000},null,null,"#-",{"$f":"-SUM(N45:P47)","v":-50000},0]
[6,"                                                           'ks\"k ¼4&5½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"R44+R47","v":1135571},{"$f":"S44-S45-S46-S47","v":1185571}]
[7,"¼v½x`g lEifr ls vk;%¼1½ Loa; ds mi;ksx esa &'kwU;",null,null,null,null,null,null,null,"¼2½ izkIr fdjk;k #-",null,null,null,{"$f":"'Data Entry'!E27","v":264000}]
[null,"¼c½ ?kVk;sa ",null," fdjk;s dk 30%",null,null," x`g _.k ij C;kt",null,null," x`gdj ",null,null,null,"  ;ksx 7¼c½"]
[null,null,null,{"$f":"ROUND(N49*0.3,0)","v":79200},null,null,{"$f":"IF((Salary!S29+'Data Entry'!E30)>200000,200000,(Salary!S29+'Data Entry'!E30))","v":30000},null,null,{"$f":"'Data Entry'!E28","v":10000},null,null,null,{"$f":"D51+G51+J51","v":119200}]
[null,"                                                          'ks\"k &@$¼7¼v½ ,oa ;ksx 7¼c½ dk½  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"N49-N51","v":144800},{"$f":"N49-D51-J51","v":174800}]
[null,"                                                             dqy 'ks\"k &@$¼6,oa 7½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"R48+R52","v":1280371},{"$f":"S48+S52","v":1360371}]
[8,"cpr [kkrs ij C;kt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Data Entry'!$E$24+'Data Entry'!$E$25","v":5000},{"$f":"'Data Entry'!$E$24+'Data Entry'!$E$25","v":5000}]
[9,"vU; vk;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!$Q$25","v":0},{"$f":"'Data Entry'!$Q$25","v":0}]
[10,"ldy vk;                                                            ;ksx ¼8$9½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"R53+R54+R55","v":1285371},{"$f":"S53+S54+S55","v":1365371}]
[11,"?kVkb;s dVkSSfr;k¡ %& /kkjk US 80C, 80CCC,80CCD (1)"]
[null,"(A) vf/kdre lhek 1]50]000@& ¼/kkjk 80CCE ½ ] ¼/kkjk 80CCD (2), ds vykok"]
[null,"(i)","jkT; chek ¼SI)",null,null,null,"#-",{"$f":"Salary!O29","v":84000},"(x)","ljdkjh isa'ku ;kstuk esa va'knku ECPF\nvf/kdre osru dk 10%¼/kkjk 80ccd½",null,null,null,null,"#-",{"$f":"IF(AND($G$2=\"NPS\",'Data Entry'!$N$48=\"YES\"),T30,IF($G$2=\"NPS\",Salary!$M$29,0))","v":0}]
[null,"(ii)","thou chek izhfe;e ¼LIC)",null,null,null,"#-",{"$f":"Salary!T29+'Data Entry'!E31","v":11791},"(xi)","isa'ku Iyku gsrq va'knku¼/kkjk 80ccc½",null,null,null,null,"#-",{"$f":"'Data Entry'!Q27","v":0}]
[null,"(iii)","jk\"Vªh; cpr i= ¼NSC)",null,null,null,"#-",{"$f":"'Data Entry'!E35","v":0},"(xii)","jk\"Vªh; cpr i= ij vnr C;kt",null,null,null,null,"#-",{"$f":"'Data Entry'!E36","v":0}]
[null,"(iv)","yksd Hkfo\"; fuf/k ¼PPF)",null,null,null,"#-",{"$f":"'Data Entry'!E37","v":1000},"(xiii)","V;w'ku Qhl ",null,null,null,null,"#-",{"$f":"'Data Entry'!E33","v":60000}]
[null,"(v)","jk\"Vªh; cpr Ldhe ¼NSS)",null,null,null,"#-",{"$f":"'Data Entry'!E38","v":0},"(xiv)","bfDoVh fyad lsfoax Ldhe",null,null,null,null,"#-",{"$f":"'Data Entry'!Q36","v":0}]
[null,"(vi)","lkekU; izko/kk;h fuf/k ¼GPF)/GPF2004",null,null,null,"#-",{"$f":"IF($G$2=\"OPS\",Salary!M29,IF(Assesment!U29=\"YES\",Salary!N29,0))","v":83080},"(xv)","LFkfxr okf\"kZdh ¼Defferred Annuty)",null,null,null,null,"#-",{"$f":"'Data Entry'!Q37","v":0}]
[null,"(vii)","lkewfgd chek izhfe;e ¼G.Ins.)",null,null,null,"#-",{"$f":"Salary!V29","v":220},"(xvi)","ih-,y-vkbZ- ¼PLI)",null,null,null,null,"#-",{"$f":"'Data Entry'!E32","v":0}]
[null,"(viii)",";w- ,y- vkbZ- ih-@okf\"kZd Iyku",null,null,null,"#-",{"$f":"'Data Entry'!E34","v":0},"(xvii)","vU; tekjkf'k ¼/kkjk 80 lh ds vUrxZr½",null,null,null,null,"#-",{"$f":"'Data Entry'!Q26","v":0}]
[null,"(ix)","x`g _.k fdLr ¼HBA Premium)",null,null,null,"#-",{"$f":"Salary!R29+'Data Entry'!E29","v":40000},"(xviii)","lqdU;k le`f) ;kstuk esa tek jkf'k",null,null,null,null,"#-",{"$f":"'Data Entry'!E39","v":0}]
[null,";ksx ( i ls xviii )",null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"SUM(H59:H67)+SUM(P59:P67)","v":280091}]
[null,"                        vf/kdre dVkSrh dh jkf'k 1-50 yk[k #i, rd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"IF(P68<150001,ROUND(P68,0),150000)","v":150000},0]
[null,"(B) ?kVkb;s& /kkjk 80CCD(2) fu;ksDrk }kjk isa'ku va'knku dh jkf'k ¼vf/kdre osru dk 10%) i`Fkd ls NwV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$2=\"NPS\",Salary!M29,0)","v":0},{"$f":"R70","v":0}]
[null,"(C) ?kVkb;s & /kkjk 80CCD (1B) uohu isa'ku ;kstuk esa vfrfjDr va'knku ¼vf/kdre :- 50]000)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Data Entry'!Q28","v":0},0]
[null,";ksx 11(A+B+C)      ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"SUM(R69:R71)","v":150000},{"$f":"SUM(S69:S71)","v":0}]
[null," vU; dVkSfr;k¡"]
[12,"1-/kkjk 80 D ,fpfdRlk chek izhfe;e ¼Lo;a]ifr@iRuh o cPpksa ds fy, : 25000] ekrk&firk ds fy, : 25000]lhfu;j flVhtu : 50000½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"IF('Data Entry'!Q29=\"\",0,IF(M89=1,MIN('Data Entry'!Q29,25000),MIN('Data Entry'!Q29,50000)))","v":0},0]
[13,"2- /kkjk 80DD fodykax vkfJrksa ds fpfdRlk mipkj ¼vf/kdre 75]000 rFkk 80% ;k vf/kd fodykaxrk 125]000½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Data Entry'!Q30","v":0},0]
[14,"3- /kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"IF('Data Entry'!Q31=\"\",0,IF(Master!M89=1,MIN('Data Entry'!Q31,40000),MIN('Data Entry'!Q31,100000)))","v":0},0]
[15,"4- /kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Data Entry'!Q32","v":0},0]
[16,"5- /kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Data Entry'!Q33+Salary!W29","v":51044},0]
[17,"6- /kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Data Entry'!Q34","v":0},0]
[18,"7- /kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"IF('Data Entry'!E24=\"\",0,IF(M89=1,MIN('Data Entry'!E24,10000),0))","v":5000},0]
[null,"8- /kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data Entry'!E25=\"\",0,IF(M89=1,0,MIN('Data Entry'!E25,50000)))","v":0},0]
[19,"9- /kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Data Entry'!Q35","v":0},0]
[null,"dqy ;ksx  ¼ 12 ls 19 rd ½",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"SUM(R74:R82)","v":56044},{"$f":"SUM(S74:S82)","v":0}]
[20,"dqy dVkSrh ( 11 + 12 TO19)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"R72+R83","v":206044},{"$f":"S72+S83","v":0}]
[21,"dj ;ksX; vk; ( 10 - 13 )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"R56-R84","v":1079327},{"$f":"S56-S84","v":1365371}]
[15,"dqy vk; dh jkf'k dks lEiw.kZ djuk ¼ nl ds xq.kd esa ½ /kkjk 288A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"ROUND(R85,-1)","v":1079330},{"$f":"ROUND(S85,-1)","v":1365370}]
[null,null,null,null,null,null,null,null,null,{"$f":"Assesment!C49","v":"कुल आय की राशि को सम्पूर्ण करना ( दस के गुणक में ) धारा 288A"}]
[null,"OLD REGIME",null,null,null,null,null,null,null,null,null,null,null,"NEW REGIME",null,null,null,"OLD REGIME","NEW REGIME"]
[null,",d O;fDr dj nkrk",null,null,null,null,null,null,null,null,"category for tax calculation",null,1,null,null,null,"AMOUNT",{"$f":"R86","v":1079330},{"$f":"S86","v":1365370}]
[null,null,"AMOUNT",null,"ofj\"B ukxfjd ¼60 ls 80 o\"kZ rd½",null,null,null,null,"80 o\"kZ ;k vf/kd vk;q",null,null,null,"0    - 2,50,000 ",null,0,{"$f":"IF($S$89>250000,250000,$S$89)","v":250000},null,{"$f":"ROUND(Q90*P90,0)","v":0}]
["2,50,000 rd",null,{"$f":"IF($R$89>250000,250000,$R$89)","v":250000},0,"3,00,000 rd",null,null,{"$f":"IF($R$89>300000,300000,$R$89)","v":300000},0,null,null,null,null,"2,50,001 - 5,00,000",null,0.05,{"$f":"IF($S$89>500000,250000,IF($S$89>250000,$S$89-250000,0))","v":250000},{"$f":"IF($M$89=1,C91*D91,IF($M$89=2,H91*I91,L91*M91))","v":0},{"$f":"ROUND(Q91*P91,0)","v":12500}]
["2,50,001-5,00,000",null,{"$f":"IF($R$89>500000,250000,IF($R$89>250000,$R$89-250000,0))","v":250000},0.05,"3,00,001-5,00,000",null,null,{"$f":"IF($R$89>500000,200000,IF($R$89>300000,$R$89-300000,0))","v":200000},0.05,"5,00,000 rd",null,{"$f":"IF($R$89>500000,500000,$R$89)","v":500000},0,"5,00,001 -  7,50,000",null,0.1,{"$f":"IF($S$89>750000,250000,IF($S$89>500000,$S$89-500000,0))","v":250000},{"$f":"IF($M$89=1,C92*D92,IF($M$89=2,H92*I92,L92*M92))","v":12500},25000]
["5,00,001-10,00,000",null,{"$f":"IF($R$89>1000000,500000,IF($R$89>500000,$R$89-500000,0))","v":500000},0.2,"5,00,001-10,00,000",null,null,{"$f":"IF($R$89>1000000,500000,IF($R$89>500000,$R$89-500000,0))","v":500000},0.2,"5,00,001-10,00,000",null,{"$f":"IF($R$89>1000000,500000,IF($R$89>500000,$R$89-500000,0))","v":500000},0.2,"7,50,001 - 10,00,000",null,0.15,{"$f":"IF($S$89>1000000,250000,IF($S$89>750000,$S$89-750000,0))","v":250000},100000,37500]
["10,00,000 ls vf/kd",null,{"$f":"IF($R$89>1000000,IF($R$89>1000000,$R$89-1000000,0),0)","v":79330},0.3,"10,00,000 ls vf/kd",null,null,{"$f":"IF($R$89>1000000,IF($R$89>1000000,$R$89-1000000,0),0)","v":79330},0.3,"10,00,000 ls vf/kd",null,{"$f":"IF($R$89>1000000,IF($R$89>1000000,$R$89-1000000,0),0)","v":79330},0.3,"10,00,001- 12,50,000",null,0.2,{"$f":"IF($S$89>1250000,250000,IF($S$89>1000000,$S$89-1000000,0))","v":250000},23799,{"$f":"ROUND(Q94*P94,0)","v":50000}]
["TOTAL",null,{"$f":"SUM(C91:C94)","v":1079330},null,null,null,null,{"$f":"SUM(H91:H94)","v":1079330},null,null,null,{"$f":"SUM(L91:L94)","v":1079330},null,"12,50,001- 15,00,000",null,0.25,{"$f":"IF($S$89>1500000,250000,IF($S$89>1250000,$S$89-1250000,0))","v":115370},null,28843]
[null,null,null,null,null,null,null,null,null,null,null,null,null," Above 15,00,000",null,0.3,{"$f":"IF($S$89>1500000,IF($S$89>1500000,$S$89-1500000,0),0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL TAX",null,null,{"$f":"SUM(R91:R95)","v":136299},{"$f":"SUM(S91:S96)","v":153843}]
[null,null,null,null,null,null,"NwV ?kkjk 87¼A½ ¼2-50 yk[k ls 5-00 yk[k rd dh dj ;ksX; vk; ij vk;dj dh NwV vf/kdre :- 12500 rd½",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$85<=500000,IF($R$97<12500,$R$97,12500),0)","v":0},{"$f":"IF($S$85<=500000,IF($S$97<12500,$S$97,12500),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NET TAX",null,{"$f":"R97-R98","v":136299},{"$f":"S97","v":153843}]
[null,"¼2½ NwV ?kkjk 87¼A½ ¼2-50 yk[k ls 5-00 yk[k rd dh dj ;ksX; vk; ij vk;dj dh NwV vf/kdre :- 12500 rd½"]

{"sheet":"HRA","index":5,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,6,13,10],[4,11,5,12],[8,6,8,10],[18,1,19,7],[2,5,2,11],[3,1,3,2],[10,7,10,10],[11,7,11,10],[6,6,6,11],[9,7,9,10],[12,7,12,10],[7,9,7,10]]}
[]
[]
[null,null,null,null,null,"HRA EXEMPTION CALCULATOR"]
[null,"PARTIALY HRA"]
[null,"MONTHS","\"YES\"/NO","PAY+DA","HRA",null,null,null,"CITY TYPE","NON METRO",null,"IF YOU ARE NOT ELIGIBLE TO GET HRA EXEMPTION FOR COMPLETE YEAR THEN CHOOSE PARTIALLY FROM Data Entry SHEET"]
[null,"MARCH 20 ","YES",{"$f":"IF(C6=\"YES\",SUM(Salary!D10:E10),0)","v":42856},{"$f":"IF(C6=\"YES\",Salary!F10,0)","v":2930},null,null,"Choose Metro for Delhi,Mumbai,Chennai,Kolkata and for others Non Metro"]
[null,"APRIL 20","YES",{"$f":"IF(C7=\"YES\",SUM(Salary!D11:E11),0)","v":88569},{"$f":"IF(C7=\"YES\",Salary!F11,0)","v":6056},null,"HRA exempted from income tax ",null,null,null,null,null,{"$f":"'Data Entry'!F17","v":"Yearly"}]
[null,"MAY 20","YES",{"$f":"IF(C8=\"YES\",SUM(Salary!D12:E12),0)","v":88569},{"$f":"IF(C8=\"YES\",Salary!F12,0)","v":6056},null,null,null,null,"वेतन (PAY+DA)",null,{"$f":"IF($M$7=\"Yearly\",Master!E20,\"-\")","v":1038643},{"$f":"IF($M$7=\"Partially\",Master!H20,\"-\")","v":"-"}]
[null,"JUNE 20","YES",{"$f":"IF(C9=\"YES\",SUM(Salary!D13:E13),0)","v":88569},{"$f":"IF(C9=\"YES\",Salary!F13,0)","v":6056},null,"Details",null,null,null,null,{"$f":"IF(M7=\"Yearly\",\"Complete year HRA exemption\",\"-\")","v":"Complete year HRA exemption"},{"$f":"IF(M7=\"Partially\",\"Partial HRA exemption\",\"-\")","v":"-"}]
[null,"JULY 20","YES",{"$f":"IF(C10=\"YES\",SUM(Salary!D14:E14),0)","v":91260},{"$f":"IF(C10=\"YES\",Salary!F14,0)","v":6240},null,null,"मकान किराया का वास्तविक भुगतान ",null,null,null,{"$f":"IF(M7=\"Yearly\",'Data Entry'!C17,\"-\")","v":0},{"$f":"IF(M7=\"Partially\",'Data Entry'!C17,\"-\")","v":"-"}]
[null,"AUGUST 20","YES",{"$f":"IF(C11=\"YES\",SUM(Salary!D15:E15),0)","v":91260},{"$f":"IF(C11=\"YES\",Salary!F15,0)","v":6240},null,"A","प्राप्त मकान किराया भत्ता (HRA)",null,null,null,{"$f":"IF(M7=\"Yearly\",Master!E21,\"-\")","v":71018},{"$f":"IF(M7=\"Partially\",E18,\"-\")","v":"-"}]
[null,"SEPTEMBER 20","YES",{"$f":"IF(C12=\"YES\",SUM(Salary!D16:E16),0)","v":91260},{"$f":"IF(C12=\"YES\",Salary!F16,0)","v":6240},null,"B","वेतन (मूल +मंहगाई भत्ता ) के 10% से अधिक मकान किराया  भुगतान की राशि ",null,null,null,{"$f":"IF(M7=\"Yearly\",IF(Master!$E$24>0,Master!$E$24,0),\"-\")","v":0},{"$f":"IF(M7=\"Partially\",IF(Master!$H$24>0,Master!$H$24,0),\"-\")","v":"-"}]
[null,"OCTOBER 20","YES",{"$f":"IF(C13=\"YES\",SUM(Salary!D17:E17),0)","v":91260},{"$f":"IF(C13=\"YES\",Salary!F17,0)","v":6240},null,"C",{"$f":"IF(J5=\"NON METRO\",\"वेतन (मूल +मंहगाई भत्ता ) का  40%\",\"वेतन (मूल +मंहगाई भत्ता ) का  50%\")","v":"वेतन (मूल +मंहगाई भत्ता ) का  40%"},null,null,null,{"$f":"IF(M7=\"Yearly\",IF(Master!$E$25>0,Master!$E$25,0),\"-\")","v":415457},{"$f":"IF(M7=\"Partially\",IF(Master!$E$25>0,Master!$E$25,0),\"-\")","v":"-"}]
[null,"NOVEMBER 20","YES",{"$f":"IF(C14=\"YES\",SUM(Salary!D18:E18),0)","v":91260},{"$f":"IF(C14=\"YES\",Salary!F18,0)","v":6240},null,"HRA exemption amount from Income Tax(Minimum amongA,B,C)",null,null,null,null,{"$f":"IF(M7=\"Yearly\",Master!$E$27,\"-\")","v":0},{"$f":"MIN(M11,M12,M15)","v":0}]
[null,"DECEMBER 20","YES",{"$f":"IF(C15=\"YES\",SUM(Salary!D19:E19),0)","v":91260},{"$f":"IF(C15=\"YES\",Salary!F19,0)","v":6240}]
[null,"JANUARY 21","YES",{"$f":"IF(C16=\"YES\",SUM(Salary!D20:E20),0)","v":91260},{"$f":"IF(C16=\"YES\",Salary!F20,0)","v":6240}]
[null,"FEBRUARY 21","YES",{"$f":"IF(C17=\"YES\",SUM(Salary!D21:E21),0)","v":91260},{"$f":"IF(C17=\"YES\",Salary!F21,0)","v":6240}]
[null,null,null,{"$f":"SUM(D6:D17)","v":1038643},{"$f":"SUM(E6:E17)","v":71018}]
[null,"IF YOU ARE NOT ELIGIBLE TO GET HRA EXEMPTION FOR COMPLETE YEAR THEN CHOOSE PARTIALLY HRA \"YES\" FROM DROPDOWN"]

{"sheet":"NSC INTT","index":6,"n_rows":28,"n_cols":21,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,19,3,20],[13,1,13,7],[14,1,16,1],[1,0,1,20],[2,1,2,20],[2,0,3,0],[14,10,14,12],[14,13,14,14],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[16,9,16,18],[15,4,15,5],[15,2,15,3],[15,6,15,7],[14,2,14,7]]}
[]
["NSC INTEREST CALCULATION\n(GIVE AMOUNT, PERIOD-WISE)"]
["PURCHASE PERIOD","Time of Purchase of NSC-(VIII Issue)"]
[null,"During 2012-13",null,"During 2013-14 to 2015-16",null,"During 01-04-2016 to30-09-2016",null,"During 01-10-2016 to31-03-2017",null,"During 01-04-2017 to30-06-2017",null,"During 01-07-2017 to31-12-2017",null,"During 01-01-2018 to30-09-2018",null,"During 01-10-2018 to30-06-2019",null,"During 01-07-2019 to11-12-2019",null,"During 12-12-2019 to31-03-2020"]
["Period (in years)","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest"]
["1st year",null,{"$f":"B6*8.78%","v":0},100,{"$f":"D6*8.68%","v":8.68},null,{"$f":"F6*8.1%","v":0},null,{"$f":"H6*8%","v":0},null,{"$f":"J6*7.9%","v":0},null,{"$f":"L6*7.8%","v":0},null,{"$f":"N6*7.6%","v":0},100,{"$f":"P6*8%","v":8},100,{"$f":"R6*7.9%","v":7.9},100,{"$f":"T6*7.9%","v":7.9}]
["2nd year",null,{"$f":"B7*9.56%","v":0},null,{"$f":"D7*9.43%","v":0},null,{"$f":"F7*8.76%","v":0},null,{"$f":"H7*8.64%","v":0},5000,{"$f":"J7*8.52%","v":426},null,{"$f":"L7*8.41%","v":0},100,{"$f":"N7*8.18%","v":8.18},null,{"$f":"P7*8.64%","v":0},null,{"$f":"R7*8.52%","v":0},null,{"$f":"T7*8.52%","v":0}]
["3rd year",null,{"$f":"B8*10.4%","v":0},null,{"$f":"D8*10.25%","v":0},null,{"$f":"F8*9.46%","v":0},100,{"$f":"H8*9.33%","v":9.33},100,{"$f":"J8*9.2%","v":9.1999999999999993},null,{"$f":"L8*9.06%","v":0},null,{"$f":"N8*8.8%","v":0},null,{"$f":"P8*9.33%","v":0},null,{"$f":"R8*9.2%","v":0},null,{"$f":"T8*9.2%","v":0}]
["4th year",null,{"$f":"B9*11.31%","v":0},100,{"$f":"D9*11.14%","v":11.14},100,{"$f":"F9*10.23%","v":10.23},null,{"$f":"H9*10.08%","v":0},null,{"$f":"J9*9.92%","v":0},null,{"$f":"L9*9.77%","v":0},null,{"$f":"N9*9.47%","v":0},null,{"$f":"P9*10.08%","v":0},null,{"$f":"R9*9.33%","v":0},null,{"$f":"T9*9.92%","v":0}]
["5th year",100,{"$f":"B10*12.3%","v":12.3},null,{"$f":"D10*12.11%","v":0},null,{"$f":"F10*11.06%","v":0},null,{"$f":"H10*10.88%","v":0},null,{"$f":"J10*10.71%","v":0},null,{"$f":"L10*10.53%","v":0},null,{"$f":"N10*10.19%","v":0},null,{"$f":"P10*10.88%","v":0},null,{"$f":"R10*10.74%","v":0},null,{"$f":"T10*10.7%","v":0}]
["Total",null,{"$f":"SUM(C6:C10)","v":12.3},null,{"$f":"SUM(E6:E10)","v":19.82},null,{"$f":"SUM(G6:G10)","v":10.23},null,{"$f":"SUM(I6:I10)","v":9.33},null,{"$f":"SUM(K6:K10)","v":435.2},null,{"$f":"SUM(M6:M10)","v":0},null,{"$f":"SUM(O6:O10)","v":8.18},null,{"$f":"SUM(Q6:Q10)","v":8},null,{"$f":"SUM(S6:S10)","v":7.9},null,{"$f":"SUM(U6:U10)","v":7.9}]
[]
[]
[null,"Time of Purchase of NSC-(IX Issue)"]
[null,"Year for which interest accuues","When Investment made",null,null,null,null,null,null,null,"INTEREST ACCURED ON NSC",null,null,{"$f":"SUM(C11,E11,G11,I11,K11,M11,O11,Q11,S11,S11,U11,D28,F28,H28,)","v":598.72}]
[null,null,"Before April 1,2012",null,"During 2012-13",null,"On or after 01-04-2013"]
[null,null,"Amount","Interest","Amount","Interest","Amount","Interest",null,"NOTE :- Fill amount of purchased NSC in respective period "]
[null,"1st year",100,{"$f":"C18*8.89%","v":8.89},null,{"$f":"E18*9.1%","v":0},null,{"$f":"G18*8.99%","v":0}]
[null,"2nd year",200,{"$f":"C19*9.68%","v":19.36},null,{"$f":"E19*9.93%","v":0},null,{"$f":"G19*9.8%","v":0}]
[null,"3rd year",null,{"$f":"C20*10.54%","v":0},null,{"$f":"E20*10.83%","v":0},null,{"$f":"G20*10.68%","v":0}]
[null,"4th year",null,{"$f":"C21*11.48%","v":0},null,{"$f":"E21*11.81%","v":0},null,{"$f":"G21*11.64%","v":0}]
[null,"5th year",100,{"$f":"C22*12.5%","v":12.5},null,{"$f":"E22*12.89%","v":0},null,{"$f":"G22*12.69%","v":0}]
[null,"6th year",null,{"$f":"C23*13.61%","v":0},null,{"$f":"E23*14.06%","v":0},null,{"$f":"G23*13.83%","v":0}]
[null,"7th year",null,{"$f":"C24*14.82%","v":0},null,{"$f":"E24*15.34%","v":0},100,{"$f":"G24*15.08%","v":15.079999999999998}]
[null,"8th year",100,{"$f":"C25*16.13%","v":16.13},null,{"$f":"E25*16.74%","v":0},null,{"$f":"G25*16.43%","v":0}]
[null,"9th year",null,{"$f":"C26*17.57%","v":0},null,{"$f":"E26*18.26%","v":0},null,{"$f":"G26*17.91%","v":0}]
[null,"10th year",null,{"$f":"C27*19.13%","v":0},null,{"$f":"E27*19.92%","v":0},null,{"$f":"G27*19.52%","v":0}]
[null,"Total",null,{"$f":"SUM(D18:D27)","v":56.879999999999995},null,{"$f":"SUM(F18:F27)","v":0},null,{"$f":"SUM(H18:H27)","v":15.079999999999998}]

{"sheet":"RULES","index":7,"n_rows":129,"n_cols":2,"rows_kept":129,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["                  Brief detail of Information and RULES for(Rates,Deductions,Exemption etc.)                                                                             ( Mini Ready Reckoner)"]
[null,"  Select and click any rule to know the brief detail about the taxation Rules & Informations."]
[1,"New Tax  Rates  for Financial-Year 2020-21, Assessment Year 2021-2022 in Old and New Regime"]
[2,"Some  Exempted Receipts / Special allowances &  Perquisite which are not chargable to tax in Old regime"]
[3,"Some Exempted Income ( to be shown while Return filing) "]
[4,"T A X   R U L E S  &  O T H E R   U S E F U L   I N F O R M A T I O N S"]
["I","HRA exemption-u/s 10(13A)"]
["II","Standard deduction u/s 16 (1a) instead of Transport allowance and Medical Reimbursement"]
["III","Reimbursement of Medical bills "]
["IV"," u/s(5) LTA  Exemption "]
["V","Deduction u/s 24  and Relief u/s 80EE or 80EEA on interest on housing loan."]
["VI","u/s 80CCE & 80CCD Maximum Exemption "]
["VII","Rajiv Gandhi Equity Savings Scheme "]
["VIII","u/s 80D Medical Insurance"]
["IX","u/s 80DD Deduction in respect of medical treatment of handicapped dependents"]
["X","u/s 80DDB Deduction in respect of medical treatment for specified ailments or diseases"]
["XI","u/s 80E Interest repayment on education loan"]
["XII","u/s 80G Donations given for certain charities "]
["XIII","u/s 80GG If Assesse is not getting  HRA,  but living in rented house,"]
["XIV","u/s 80U If assesse have a permanent physical disability "]
["XV","u/s 80TTA/80TTB Deduction on interest Income."]
[5," KNOW MORE about DEDUCTION under Section 80-C"]
["a","Qualifying Investments u/s 80CCE"]
["b","Provident Fund (PF) & Voluntary Provident Fund (VPF) "]
["c","Life Insurance Premiums & Unit linked Insurance Plan (ULIP)"]
["d","Public Provident Fund (PPF):"]
["e","National Savings Certificate (NSC):"]
["f","Home Loan Principal Repayment & Stamp Duty and Registration Charges for a home "]
["g","Tuition  fees  for 2 children "]
["h","Equity Linked Savings Scheme (ELSS)"]
["i","5-Yr bank fixed deposits (FDs)  or 5-Yr post office time deposit (POTD)"]
["j","Pension Funds or Pension Policies "]
["k","Sukanya Samridhi Account"]
["l","Infrastructure Bonds: NABARD rural bonds:"]
["m","Senior Citizen Savings Scheme 2004 (SCSS)"]
[6,"Allowed Deductions & Exemptions under New Income Tax Regime "]
[null,"         TAX  RATES  as per Old Regime --   for Financial Year 2020-21 & Assesment Year 2021-22  "]
[null,"                                                For Individual (MALE & FEMALE)  ASSESSE  "]
[null,"   Net Income Range                                                   Income Tax Rates"]
[null,"  Up to ₹ 2,50,000                                                                    NIL"]
[null,"  ₹ 2,50,001 to ₹ 5,00,000                                       5% on Total Income (-) ₹ 2,50,000"]
[null,"  ₹ 5,00,001 to ₹ 10,00,000                                ₹12,500+20% of Total Income (-) ₹5,00,000"]
[null,"  More than ₹ 10.00,000                                   ₹1,12,500+30% of Total Income (-) ₹10,00,000"]
[null,"Note- (u/s 87A- A rebate upto ₹ 12500/-  for assessee with Income range upto ₹ 5,00,00 will be available in Both Old & New Regime) )"]
[null,"     For SENIOR CITIZEN  ASSESSE (Above 60 Year ) attaining the age during the year "]
[null,"       Net Income Range                                              Income Tax Rates"]
[null,"    Up to  ₹3,00,000                                                           NIL"]
[null,"    ₹3,00,001 to 5,00,000                                                            5% of Total Income(-) ₹3,00,000"]
[null,"    ₹5,00,001 to 10,00,000                                         ₹10,000 +20% of Total Income (-) ₹5,00,000"]
[null,"    More than ₹10.00,000                                       ₹1,10,000 +30% of Total Income (-) ₹10,00,000"]
[null,"Note- (u/s 87A- A rebate upto ₹ 10000/-  for assessee with Income range upto ₹ 5,00,000)"]
[null,"    For VERY SENIOR CITIZEN  ASSESSE (Above 80 Year ) attaining the age during the year "]
[null,"      Net Income Range                                              Income Tax Rates"]
[null,"    Up to ₹5,00,000                                                           NIL"]
[null,"    ₹5,00,001 to ₹10,00,000                                         20% of Total Income (-) ₹10,00,000"]
[null,"    More than ₹10,00,000                                         ₹1,00,000 +30% of Total Income (-) ₹10,00,000"]
["Back ↑    ","Note: 1. Education and Health Cess is 4% of income tax from all Assesse. (as per Finance Act 2018)                                                                                                                                                           .        2. Surcharge on income tax @10% for income above ₹50 Lakh & 15% for income above ₹1crore  "]
[null,"           TAX  RATES as per New Regime -  for financial Year 2020-21 & Assesment Year 2021-22  ( The new scheme is optional in nature )"]
[null,"For Individual (>60Yrs)., Sr. Citizen (60+Yrs.) & Very Sr. Citizen (80+Yrs.) ASSESSE  "]
[null,"Up to – 250000 – Nil"]
[null,"  ₹ 2,50,001 to ₹ 5,00,000                                                 5% on Total Income (-) ₹2,50,000 "]
[null,"  ₹ 5,00,001 to ₹ 7,50,000                                   ₹12,500+10% of Total Income (-) ₹5,00,000"]
[null,"  ₹ 7,50,001 to ₹ 10,00,000                                 ₹37,500+15% of Total Income (-) ₹7,50,000"]
[null,"  ₹ 10,00,001 to ₹ 12,50,000                               ₹75,000+20% of Total Income (-) ₹10,00,000"]
[null,"  ₹ 12,50,001 to ₹ 15,00,000                            ₹1,25,000+25% of Total Income (-) ₹12,50,000"]
[null,"  ₹ 15,00,001 & above                                    ₹1,87,500+30% of Total Income (-) ₹15,00,000"]
["Back ↑    ","Note- (u/s 87A- A rebate upto ₹ 12500/-  for assessee with Income range upto ₹ 5,00,00 will be available in Both Old & New Regime) )"]
[]
[null," Some  Exempted Receipts /Special allowances &  Perquisite which are not chargable to tax are  "]
[null," Exempted Receipts - 1.  L.T.A (as per Rule)                                                            "]
["Back ↑    ","Special allowances Exempted u/s 10(14)                                                                                                                                                                                                                                                                      1. Uniform Allowance (granted to meet the expenditure incurred on purchase or maintenance of uniform to be worn during performance of Official Duty)                                                                                            2. Helper Allowance ( granted to meet exependiture incurred on helper for performance of official duty)                                                                                                                                                                                 3. Academic Allowance (granted for encouraging academic, research & training pursuits) including Newspaper, Generals etc.)                                                                                                                              4. Children Education Allowance ( ₹100 P.M. per child / (₹300 for hostel expenditure) Max of 2 children)                                                                                                                                                             5. Convayance allowance ( granted to meet the expenditure incurred on convayance, while performing official duty.                                                                                                                                                 .   ( Expenditure incured for covering journey between office and residence is not treated as expenditure in performance of official duty. ) "]
[null," Deduction available u/s -16                                                                                                                                                                                                                                                                          1.Standard deduction of  Rs. 50000/- is granted to all salaried employee.whenever Transport allowance and Medical reimbursement are abolished                                                                                                      2. Entertainment allowance (for Govt Employees) Max  ₹5000/-                                                                                                                                                                                                                           3. Professional tax - Professional tax paid by employeer is deducted from Gross salary."]
[null," Perquisite not chargable to tax"]
[null," Free food and beverage 1. Food and non-alcoholic beverages provided in working hours in remote area or an offshore instalation are exempted to tax                                                                                                                                    2. Tea, coffee or non-alcoholic beverages and snaks in working hours are tax free perquisites.                                                                                                                                                                                                                                                            3. Meals (Lunch and / or dinner) in office hours is not taxable. If cost to the employeris  ₹50 (or Less) per meal.  "]
[null," Some Exempted Income are ( to be shown while Return filing) "]
[null,"         1.  Withdrawal / Maturity / Interest received from PF,PPF,Sukanya Samridhi Account, Life Insurance policy, Agriculture. (Max up to ₹5000/- )"]
[null,"         2    Long Term Capital Gain From Shares"]
[null,"         3.   Interest on Saving Bank & Post Office A/c up to  ₹ 10,000/- ( Sec-80TTE) for Individual "]
[null,"         4.   Interest on Saving Bank & Post Office A/c, FD, RD etc up to  ₹ 50,000/- (Sec-80TTE) for Sr. Citizen "]
[null,"Please Note :"]
[null,"(i) Interest earned from all sources are to be included. All interest income (including saving Bank A/C (above ₹10,000 for Individual & ₹50,000 for Sr. Citizen )"]
["Back ↑    ","(II) As per clarification from IT department, all perquisites such as rent-free accommodation, company provided car, free or concessional education facilities, employee stock option plan, free club membership, company provided credit card, gift vouchers, meal coupons, hotel stay beyond 15 days, are fully taxable. "]
["Back ↑    ","T A X   R U L E S  &  O T H E R   U S E F U L   I N F O R M A T I O N S  for"]
["I"," House Rent Allowance exemption-10(13A) = Least amount of anyone (i) 40% of Salary (50%, if house situated in Mumbai, Calcutta, Delhi or Madras)                                                                                                                                                                                                                                   .                                                                                                             or (ii) Actual HRA Recived                                                                                                                                                                                                                                                        .                                                                                                             or (iii) Rent paid minus 10% of salary * Salary= Basic + DA (if part of retirement benefit) + Turnover based Commission                                              Note i. Fully Taxable, if HRA is received by an employee who is living in his own house or if he does not pay any rent                                                                                                                                                          ii. It is mandatory for employee to report PAN of the landlord to the employer if rent paid is more than ₹ 1,00,000 [Circular No. 08 /2013 dated 10th October, 2013]. (In case the landlord does not have PAN, employee should submit a declaration stating the same along with the landlord’s details.)"]
["II       ","Standard deduction of  ₹50000/- is allowed to all salaried employee. In Finace act 2019 standard deduction of Rs. 50,000/- has allowed to all salaried employees.                                              But Transport allowance  & Medical Reimburement are abolished. Whenever an exemption of  up to ₹3200/- per month is cotinue for disabled employees (Blind and Handicapped employees) .                                                                                                                                                                                                                                                                                                                                                                                                        Transport Allowance is granted to an employee to meet expenditure on commuting between place of residence and place of duty"]
["III","Reimbursement of Medical bills has withdrawan and not allowed from finance act 2018. Now it has become a part of Standard deduction of Rs. 50,000/-"]
["IV"," u/s(5) LTA is exempt to the tune of economy class Train/ Air /Recognised public Transport fare for the family to any destination in India, by the shortest route.                                                                                                                   LTA can be claimed twice in a block of 4 calendar year. The current block is from 01.01.2018 to 31.12.2021. For claim, it is must to provide originals tickets etc."]
["   V(a) New Change"," u/s 24 and 80 EE/ 80EEA There is an Exemption for interest on housing loan.(for Self occupied Residence). If the loan was taken before Apr 1, 1999 exemption is limited to ₹30,000/- per year. If the loan was taken after Apr 1, 1999 exemption is limited to ₹2,00,000/- per year if the house is self-occupied;                                                                                                                                                                 \nThis exemption is available on accrual basis, which means if interest has accrued, you can claim exemption, irrespective of whether you've paid it or not.                                                                  80EE - In finance bill 2016 (an additional rebate of ₹.50.000/- was given to those assesse, who purchase self ocupied single house and loan has sanctioned between 01/04/2016 to 31/03/2018 with maximum value of ₹ 50 Lacs and sanctioned home loan up to 35 Lacs.). The deduction is allowed untill the loan is repaid.                                                                                                                              Sec 80EEA - In Finance bill 2019 ( a new rebate for purchase first house has been introduced to extend the tax benefit upto Rs. 1,50,000/- for affordable house of stamp duty valued up to               Rs. 45 Lacs and loan sanctioned during the period 01/04/2019 to 31/03.2021)                                                                                                                                            "]
["      (b)","If you have rented out your house, Whole the interest will be eligible for deduction. (after deducting property tax and standard maintenance expenses from rent recived). But maximum interest allowed for deduction is 2,00,000/- only and rest of interest will be adjust while filing of ITR as carryforward of losses."]
["VI","u/s 80CCE- Maximum Exemption up to  ₹1,50,000/-  Investments up to ₹1.5 lac in PF, VPF, PPF, Employee contribution in NPS,Insurance Premium, Housing loan principal repayment, NSC, ELSS, long term bank Fixed Deposit, Post Office Term Deposit, etc. are deductible from the taxable income. There is no limit on individual items, (for example) all 1.5 lac can be invested in NSC or PPF etc.  "]
["VII                                                                                                                                                                     ","u/s 80CCD(1):  Contribution to NPS (by Employee) The Finance Act, 2015 provides that, The contribution made by the employee to the NPS will be subject to the limit of ₹1,50,000.(Sec 80CCE)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Section 80CCD (2):  Contribution to NPS (by Employer) - Contribution made by the Central Government or any other employer to NPS shall be excluded while computing the limit of Rs1,50,000 Deduction available for the amount paid or deposited by the employer of the assessee in a pension scheme notified or as may be notified by the Central Government subject to a maximum of 10% of salary in the financial year.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Section 80CCD(1B): Additional depoisiting to New Pension Scheme (NPS) account in Banks/PO  - It will provide an additional deduction of upto ₹ 50,000 over and above the limit of ₹ 1.50 lakh in respect of contributions made to NPS account.\n\n\n"]
["VIII","u/s 80CCG - Rajiv Gandhi Equity Savings Scheme exemption has been abolished in Fianance Act 2017. "]
["IX     ","u/s 80D Medical Insurance Premiums+ Critical Insurance cover Premiuma +Health checkup+ CGHS/ SGHS contributions                                                                                                                                (Mediclaim Insurance & Critical illness Cover from health Insurance Co. or Life Insurance Co. with contribution in CGHS/SGHS & Preventive Health Check upto INR.5000/-) for Self Family & Parents <60 Yrs. or Sr. Citizen. For Very Sr. Citizen abobe 80 Yrs. Expenses on medical treatment.                                                                                                                                                                                                                                                                                           Premium & Health checkup  is exempt up to                                                                                                                                                                                                                                                                                                               1.₹. 25000/- for Self & Family less than 60Yrs.                                                                                                                                                                                                                                                                                 2.₹ 50000/- for Self, Family & Parents below 60 Yrs  (25000/-+25000/-)                                                                                                                                                                                                                               3. ₹ 75000/ for Self, Family & Parents Sr. Citizen –  (25000/-+50000/-)                                                                                                                                                                                                                                                                  4. ₹ 50000/- sr. Citizen above 60 Yrs Self & Family                       "]
["X    ","u/s 80DD Deduction in respect of medical treatment of handicapped dependents is limited to ₹75,000/- per year if the disability is less than 80% and Rs1,25,000/- per year if the disability is more than 80%"]
["XI      ","u/s 80DDB Deduction in respect of medical treatment for specified ailments or diseases for the assesse or dependent can be claimed up to ₹40,000/- per year. If the person being treated is a senior citizen (Age 60+), the exemption can go up to ₹1,00,000/- but any amount received under Medical Insurance Policy will be reduced from the amount of deduction allowed.                                     The Diseases and ailments specified under rule 11DD are.                                                                                                                                                                                                                         (1) Neurological diseases being demetia, dystonia musculorum deformans, motor neuron disease, ataxia, chorea, hemiballismus, aphasia and parkisons disease, (2) cancer, (3) AIDS, (4)Chronic renal failure, (5) hemophilia, and (6) thalassaemia.                                                                                                                                                                                                                                                                                  Note:The assessee will be required to obtain a prescription/Certificate from a specialist doctor whether from Govt or Pvt. for the purpose of availing this deduction. "]
["XII","u/s 80E Interest repayment on education loan (taken for higher education from a university of self & dependents) is completely tax exempt"]
["XIII","u/s 80G Donations given for certain charities are tax exempt.NGO,Trust etc. are exempt to the tune of 50%, whereas Govt funds are 100%.                                                                                                                                                               u/s 80GGA - Donations for scientific, social or statistical research or rural development programme or for carrying out an eligible project or scheme or National Urban Poverty Eradication Fund u/s                                                               80GGC -Donation to any political party/electoral trust   "]
["XIV         New","u/s 80GG If you are not getting  HRA, but living in rented house, an exemption is available. This will be calculated as minimum of (25% of total income or rent paid - 10% of total income or ₹ 60,000/- per year)"]
["XV","u/s 80U who suffers from not less than 40 per cent of any disability is eligible for deduction to the extent of ₹ 75,000/- and in case of severe disability to the extent of ₹ 1,25,000/-"]
["XVI","u/s 80TTA/80TTB introduced through Finance Act, 2012. Section 80TTA provides a deduction of up to ₹10,000 on income from interest on saving bank accounts to Individual asessee and                                                                                                                                                                                                                                                                                                      Sec 80TTB introduced through Finance Act, 2018. Which provides a deduction of up to ₹50,000 on income from interest Income from bank & Post Offices ( Savings,FD, RD, MIS,SCSS etc. ) to Sr. Citizen asessee "]
["Back ↑    ","                                       KNOW MORE about DEDUCTION under Section 80-C and chapter VIA "]
[null,"Section 80C of the Income Tax Act allows certain investments and expenditure to be deduct from total income - One must plan investments well and spread it out across the various instruments specified under this section to avail maximum tax benefit. There are no sub-limits and is irrespective of how much you earn and under which tax bracket you fall. Most of the Income Tax payee try to save tax by saving under Section 80C of the Income Tax Act.  However, it is important to know the Section in total. so that one can make best use of the options available for deduction under income tax Act. One important point to note that one can not only save tax by undertaking the specified investments, but some expenditure which you normally incur can also give you the tax exemptions.\n\n\n\n\n"]
["Back ↑    ","                                         Qualifying Investments u/s 80CCE are"]
["a","Provident Fund (PF) & Voluntary Provident Fund (VPF) PF is automatically deducted from your salary. your contribution [12% of Basic] (i.e., employee’s contribution) is counted towards section 80C investments. You also have the option to contribute additional amounts through voluntary contributions (VPF). Current rate of interest is 8.5% per annum (p.a.) and is tax-free.\n\n\n\n\n"]
["b","Life Insurance Premiums: Any amount that you pay towards life insurance premium in Life Insurance Corporation (LIC) or any other Insurance CO.for yourself, your spouse or your children can also be included in Section 80C deduction. If you are paying premium for more than one insurance policy, all the premiums will be included. also premium paid for ULIP will also be treated as Premium paid for Life Insurance Policies.                                                                                                                                                                                                                        Unit linked Insurance Plan : ULIP stands for Unit linked Saving Schemes. ULIPs cover Life insurance with benefits of equity investments.They have attracted the attention of investors and tax-savers not only because they help us save tax but they also perform well to give decent returns in the long-term.\nIMP : Total Amount Received at Maturity, Survival Benefits, , Withdrawl in Insurance Policies is Tax Free and fully exempteed u/s 10(10D)."]
["c","Public Provident Fund (PPF): Among all the assured returns small saving schemes, Public Provident Fund (PPF) is one of the best. Current rate of interest is 8% tax-free and the normal maturity period is 15 years Minimum amount of contribution is ₹500 and maximum is ₹1,50,000.(New Change) from Finance Act  2014\n\n"]
["d","National Savings Certificate (NSC): National Savings Certificate (NSC) is a 5-Yr small savings instrument eligible for section 80C tax benefit. Rate of interest is  8.58% compounded half-yearly, i.e. If you invest ₹100, it becomes ₹150.90 after five years. The interest accrued every year is liable to tax (i.e. to be included in your taxable income) but the interest is also deemed to be reinvested and thus eligible for section 80C deduction."]
["e","Home Loan Principal Repayment & Stamp Duty and Registration Charges for a home Loan The Equated Monthly Installment (EMI) that you pay every month to repay your home loan consists of two components – Principal and Interest.The principal component of the EMI qualifies for deduction under Sec 80C. Even the interest component can save you significant income tax – but that would be under Section 24 of the Income Tax Act. The amount you pay as stamp duty when you buy a house, and the amount you pay for the registration of the documents of the house can be claimed as deduction under section 80C in the year of purchase of the house.\n\n"]
["f","Tuition  fees  for 2 children  Apart form the above major investments expenses for children’s education (Only Tution Fee (for which you need receipts)), can be claimed as deductions under Sec 80C.\n\n\n\n\n"]
["g","Equity Linked Savings Scheme (ELSS): There are some mutual fund (MF) schemes specially created for offering you tax savings, and these are called Equity Linked Savings Scheme, or ELSS. The investments that you make in ELSS are eligible for deduction under Sec 80C.\n\n"]
["h","5-Yr bank fixed deposits (FDs): Tax-saving fixed deposits (FDs) of scheduled banks with tenure of 5 years are also entitled for section 80C deduction.                                                                                             5-Yr post office time deposit (POTD) scheme: POTDs are similar to bank fixed deposits. Although available for varying time duration like one year, two year, three year and five year, only 5-Yr post-office time deposit (POTD) – which currently offers 7.5 per cent rate of interest –qualifies for tax saving under section 80C. Effective rate works out to be 7.71% per annum (p.a.) as the rate of interest is compounded quarterly but paid annually. The Interest is entirely taxable.\n\n\n\n"]
["i","Pension Funds or Pension Policies – Section 80CCC: This section – Sec 80CCC – stipulates that an investment in pension funds is eligible for deduction from your income. Section 80CCC investment limit is clubbed with the limit of Section 80C – it means that the total deduction available for 80CCC and 80C is ₹1.5 Lakh.This also means that your investment in pension funds upto ₹1.5 Lakh can be claimed as deduction u/s 80CCC. However, as mentioned earlier, the total deduction u/s 80C and 80CCC can not exceed  ₹1.5 Lakh.\n\n\n"]
["j","Infrastructure Bonds: These are also popularly called Infra Bonds. These are issued by infrastructure companies, and not the government. The amount that you invest in these bonds can also be included in Sec 80C deductions.                                                                                                                                                                \nNABARD rural bonds: There are two types of Bonds issued by NABARD (National Bank for Agriculture and Rural Development): NABARD Rural Bonds and Bhavishya Nirman Bonds (BNB). Out of these two, only NABARD Rural Bonds qualify under section 80C.\n\n"]
["k","Senior Citizen Savings Scheme 2004 (SCSS): A recent addition to section 80C list, Senior Citizen Savings Scheme (SCSS) is the most lucrative scheme among all the small savings schemes but is meant only for senior citizens. Current rate of interest is 9% per annum payable quarterly. Please note that the interest is payable quarterly instead of compounded quarterly. Thus, unclaimed interest on these deposits won’t earn any further interest. Interest income is chargeable to tax.\n\n\n\n"]
["l","Sukanya Samridhi Account : Contribution made in a financial year in Sukanya Samriddhi Account will also be eligible for income tax exemption under Section 80C up to a maximum of ₹ 1,50,000/-  "]
[]
["Back ↑    ","Allowed Deductions & Exemptions under New Income Tax Regime "]
[null,"1. Deduction under sub-section (2) of section 80CCD (employer contribution on account of employee in notified pension scheme) if added in Gross salary"]
[null,"2.Transport Allowance granted to Divyang Employee for commute between place of residence and duty"]
[]
[null,"The income tax Exemption on following incomes still available in the new regime "]
[null,"·         Death-cum-retirement benefit"]
[null,"·         Commutations of pensions"]
[null,"·         Leave encashment on retirement"]
[null,"·         Amount received on VRS up to Rs 5 lakh"]
[null,"·         Employee Provident Fund money"]
[null,"·         Money received as scholarship for education"]
[null,"·         Cash received as awards constituted in public interest"]
[null,"·         Short-term withdrawals and maturity amount from the National Pension Scheme"]