{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Basic Profile","GA-55","Other Deduction","Tax Old Regime","Tax New Regime","Form 16","HRA Receipt"],"not_rendered":{"macros":1,"defined_names":341},"read":"whole","date_system":"1900"}

{"sheet":"Basic Profile","index":0,"n_rows":109,"n_cols":22,"rows_kept":109,"merged":[[0,0,0,17],[1,0,1,17],[2,0,2,9],[2,10,2,13],[2,14,2,17],[3,0,3,9],[3,10,3,13],[3,14,3,17],[4,0,4,9],[4,10,4,13],[4,14,4,17],[5,0,5,1],[5,2,5,13],[5,14,5,15],[5,16,5,17],[6,0,8,0],[6,1,6,6],[6,7,6,17],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,7,8,7],[7,8,8,8],[7,9,7,10],[7,11,8,11],[7,12,8,12],[7,13,8,13],[7,14,8,14],[7,15,8,15],[7,16,8,16],[7,17,8,17]]}
["INCOME TAX CALCULATOR 2021-22"]
["vk;dj x.kuk izi= 2021&22"]
["1- bl 'khV dks mi;ksx djus ds fy, KRUTIDEV-10 o DEVLYS-10 dks dEI;wVj esa INSTALL djsaA",{"$nulls":9},"DDO NAME",{"$nulls":3},"HANUMAN SAHAY"]
["2- GA-55 'khV dks t#j psd djsaa] vk;dj] thou chek] vkfn dh jkf'k esa ;fn fdlh ekg esa vUrj gksus ijA",{"$nulls":9},"DDO FATHER NAME",{"$nulls":3},"GULLA RAM"]
[{"$nulls":10},"DDO DESIGNATION",{"$nulls":3},"PRINCIPAL"]
["OFFICE NAME",null,"GOVT. SR. SECONDARY SCHOOL, DILOD HATHI, ATRU BARAN",{"$nulls":11},"TAN NUMBER",null,"XXXX9987D"]
["S.N.","EMPLOYEE BASIC DETAIL'S",{"$nulls":5},"PAYMENT DETAIL'S"]
[null,"Employee Name","Designation","Pan Number","GPF/NPS","Bank Ac/No.","Mobile Number","MARCH BASIC","HRA","SURRENDER 2020-21",null,"BONUS","jkT; chek   S.I.","thou chek   L.I.C.","nq?kZVuk chek  GIS","fgrdkjh fu/kh","ITAX","RGHS",null,"GPF","Yes",{"v":0.08,"d":"8%"}]
[{"$nulls":9},"YES/NO","MONTH",{"$nulls":8},"NPS","No",{"v":0.16,"d":"16%"}]
[1,"PARMANAND MEGHWAL","SR. TEACHER","ASQPM6311H","NPS",2225617763,9784379510,45100,{"v":0.08,"d":"8%"},"Yes",5,"Yes",3000,0,220,250,0,0]
[2,"HANUMAN SAHAY","PRICIPAL","AASDF6677K","NPS",123456789,9786534334,67200,{"v":0.08,"d":"8%"},"No",5,"No",5000,5641,700,500,3000,440,null,"Yes",1]
[3,{"$nulls":18},"No",2]
[4,{"$nulls":19},3]
[5,{"$nulls":19},4]
[6,{"$nulls":19},5]
[7,{"$nulls":19},6]
[8,{"$nulls":19},7]
[9,{"$nulls":19},8]
[10,{"$nulls":19},9]
[11,{"$nulls":19},10]
[12,{"$nulls":19},11]
[13,{"$nulls":19},12]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"GA-55","index":1,"n_rows":37,"n_cols":29,"rows_kept":37,"merged":[[0,2,4,2],[1,3,1,22],[1,25,1,26],[2,3,2,10],[2,11,2,12],[2,13,2,22],[2,23,2,24],[3,3,3,12],[3,15,3,16],[3,17,3,22],[3,25,3,26],[4,3,4,28],[5,3,5,28],[6,3,6,28],[7,2,8,2],[7,3,8,7],[7,8,7,10],[7,11,7,14],[7,15,7,16],[7,17,7,19],[7,20,7,21],[7,22,7,24],[7,25,7,26],[7,27,7,28],[8,8,8,24],[8,25,8,26],[8,27,8,28],[38,2,38,28]]}
[null,null,"USE KRUTIDEV &             DEVLYS 10 FONT"]
[{"$nulls":3},";fn vki 01-01-2004 dks ;k mlds i'pkr fu;qDr dkfeZd gSa rks Drop Down Menu esa ls \"Yes\" pqusa] vU;Fkk \"No\" pqusaA ",{"$nulls":21},{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,5,0)","v":"NPS"},null,null,"HRA"]
[{"$nulls":3},"D;k vkius lefiZr osru fy;k gS \\",{"$nulls":7},{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,10,0)","v":"Yes"},null,";fn gk¡ rks ftl ekg esa fcy cuk mldk Øekad pqusaA",{"$nulls":9},{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,11,0)","v":5}]
[{"$nulls":3},"D;k vki ofj\"B ukxfjd Js.kh ¼60-80 vk;qoxZ½ esa vkrs gS \\",{"$nulls":11},"No",null,"D;k vkius cksul feyk gS \\",{"$nulls":7},{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,12,0)","v":"Yes"},null,null,{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,9,0)","v":{"v":0.08,"d":"8%"}}]
[]
[null,null,"S.N.",{"$f":"'Basic Profile'!C6","v":"GOVT. SR. SECONDARY SCHOOL, DILOD HATHI, ATRU BARAN"}]
[null,null,1,"INCOME TAX CALCULATION (GA-55) 2021-22"]
[null,null,"NAME :",{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,2,0)","v":"PARMANAND MEGHWAL"},{"$nulls":4},"DESIGNATION",null,null,{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,3,0)","v":"SR. TEACHER"},{"$nulls":3},"PAN N0.",null,{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,4,0)","v":"ASQPM6311H"},null,null,"TAN NO.",null,{"$f":"'Basic Profile'!Q6","v":"XXXX9987D"},null,null,"A/C NO.",null,{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,6,0)","v":2225617763}]
[{"$nulls":8},"RAJTEACHERS.NET",{"$nulls":16},"MOB NO.",null,{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,7,0)","v":9784379510}]
[null,null,"Month","Basic Pay","Dearness Pay","Leave  Pay","Spl. Pay","D.A.","H.R.A.","Washing Allow.","ROP (If any, put the value in minus)","Other Allowance 1","Other Allowance 2","Gross  Salary",{"$f":"IF(Z2=\"GPF\",\"GPF\",\"Emp. C.Pen.F.\")","v":"Emp. C.Pen.F."},{"$f":"IF(Z2=\"No\",\"GPF LOAN\",\"\")","v":""},"SI","SI LOAN + INT","RPMF/RGHS","LIC","Group Insurance  \nAccidental","HBA Premium","HBA Interest","Income Tax / TDS","GPF 2004","HITKARI NIDHI","Total\nDeduction","Net Payment","Bill No. & T.V. No."]
[null,3,"2021-03-01",{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,8,0)","v":45100},0,0,0,{"$f":"ROUND(17%*D11,0)","v":7667},{"$f":"IF($AC$4=16%,ROUND(0.16*D11,0),ROUND(0.08*D11,0))","v":3608},0,0,0,0,{"$f":"SUM(D11:M11)","v":56375},{"$f":"IF($Z$2=\"NPS\",ROUND((D11+H11)*0.1,0),IF($Z$2=\"GPF\",IF(D11<23101,1450,IF(D11<28501,1625,IF(D11<38501,2100,IF(D11<51501,2850,IF(D11<62001,3575,IF(D11<72001,4200,IF(D11<80001,4800,IF(D11<116001,6150,IF(D11<167001,8900,10500))))))))),0))","v":5277},0,{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,13,0)","v":3000},0,{"$f":"IF($Z$2=\"gpf\",IF(D11<18001,265,IF(D11<33501,440,IF(D11<54001,658,875))),0)","v":0},{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,14,0)","v":0},0,null,null,{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,17,0)","v":0},null,null,{"$f":"SUM(O11:Z11)","v":{"v":8277,"d":"8277.00"}},{"$f":"N11-AA11","v":{"v":48098,"d":"48098.00"}}]
[null,4,"2021-04-01",{"$f":"D11","v":45100},{"$f":"IF(E$11=0,0,ROUND(D12/2,0))","v":0},{"$f":"IF(F$11=0,0,F11)","v":0},0,{"$f":"ROUND(17%*D12,0)","v":7667},{"$f":"IF($AC$4=16%,ROUND(0.16*D12,0),ROUND(0.08*D12,0))","v":3608},{"$f":"IF(J$11=0,0,J11)","v":0},{"$f":"IF(K$11=0,0,K11)","v":0},0,{"$f":"IF(M$11=0,0,M11)","v":0},{"$f":"SUM(D12:M12)","v":56375},{"$f":"IF($Z$2=\"NPS\",ROUND((D12+H12)*0.1,0),IF($Z$2=\"GPF\",IF(D12<23101,1450,IF(D12<28501,1625,IF(D12<38501,2100,IF(D12<51501,2850,IF(D12<62001,3575,IF(D12<72001,4200,IF(D12<80001,4800,IF(D12<116001,6150,IF(D12<167001,8900,10500))))))))),0))","v":5277},{"$f":"P11","v":0},{"$f":"Q11","v":3000},{"$f":"R11","v":0},{"$f":"IF($Z$2=\"gpf\",IF(D12<18001,265,IF(D12<33501,440,IF(D12<54001,658,875))),0)","v":0},{"$f":"T11","v":0},{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,15,0)","v":{"v":220,"d":"220.00"}},{"$f":"V11","v":0},0,{"$f":"X11","v":0},0,null,{"v":8497,"d":"8497.00"},{"v":47878,"d":"47878.00"}]
[null,5,"2021-05-01",45100,{"$f":"IF($E$11=0,0,ROUND(D13/2,0))","v":0},0,0,7667,3608,null,{"$f":"IF(K$11=0,0,K12)","v":0},{"$f":"IF(L$11=0,0,L12)","v":0},0,56375,5277,{"$f":"P12","v":0},{"$f":"Q12","v":3000},{"$f":"R12","v":0},0,{"$f":"T12","v":0},0,0,0,0,{"$f":"Y12","v":0},null,{"v":8277,"d":"8277.00"},{"v":48098,"d":"48098.00"}]
[null,6,"2021-06-01",45100,0,0,0,7667,3608,0,0,0,0,56375,5277,0,3000,0,0,0,0,0,0,0,{"$f":"Y13","v":0},null,{"v":8277,"d":"8277.00"},{"v":48098,"d":"48098.00"}]
[null,7,"2021-07-01",{"$f":"MROUND(ROUND(1.03*D14,0),100)","v":46500},0,{"$f":"IF(F$11=0,0,F14)","v":0},{"$f":"IF(G$11=0,0,G14)","v":0},{"$f":"ROUND(28%*D15,0)","v":13020},3720,{"$f":"IF(J$11=0,0,J14)","v":0},{"$f":"IF(K$11=0,0,K14)","v":0},{"$f":"IF(L$11=0,0,L14)","v":0},{"$f":"IF(M$11=0,0,M14)","v":0},63240,5952,{"$f":"P14","v":0},{"$f":"Q14","v":3000},{"$f":"R14","v":0},{"$f":"IF($Z$2=\"gpf\",IF(D15<18001,265,IF(D15<33501,440,IF(D15<54001,658,875))),VLOOKUP(C7,'Basic Profile'!A10:R109,18,0))","v":0},{"$f":"T14","v":0},0,{"$f":"V14","v":0},{"$f":"W14","v":0},{"$f":"X14","v":0},0,null,{"v":8952,"d":"8952.00"},{"v":54288,"d":"54288.00"}]
[null,8,"2021-08-01",{"$f":"D15","v":46500},0,0,0,{"$f":"ROUND(28%*D16,0)","v":13020},{"$f":"IF($AC$4=16%,ROUND(0.18*D16,0),ROUND(0.09*D16,0))","v":4185},0,0,0,0,63705,5952,0,3000,0,{"$f":"IF($Z$2=\"gpf\",IF(D15<18001,265,IF(D15<33501,440,IF(D15<54001,658,875))),VLOOKUP(C7,'Basic Profile'!A10:R109,18,0))","v":0},0,0,0,0,0,0,null,{"v":8952,"d":"8952.00"},{"v":54753,"d":"54753.00"}]
[null,9,"2021-09-01",46500,0,0,0,13020,4185,0,0,0,0,63705,5952,0,3000,0,{"$f":"IF($Z$2=\"gpf\",IF(D15<18001,265,IF(D15<33501,440,IF(D15<54001,658,875))),VLOOKUP(C7,'Basic Profile'!A10:R109,18,0))","v":0},0,0,0,0,0,0,null,{"v":8952,"d":"8952.00"},{"v":54753,"d":"54753.00"}]
[null,10,"2021-10-01",46500,0,{"$f":"IF(F$11=0,0,F17)","v":0},{"$f":"IF(G$11=0,0,G17)","v":0},{"$f":"ROUND(31%*D18,0)","v":14415},4185,0,0,0,0,65100,6092,0,3000,0,{"$f":"IF($Z$2=\"gpf\",IF(D15<18001,265,IF(D15<33501,440,IF(D15<54001,658,875))),VLOOKUP(C7,'Basic Profile'!A10:R109,18,0))","v":0},0,0,0,0,0,0,null,{"v":9092,"d":"9092.00"},{"v":56008,"d":"56008.00"}]
[null,11,"2021-11-01",46500,0,{"$f":"IF(F$11=0,0,F18)","v":0},0,{"$f":"ROUND(31%*D19,0)","v":14415},4185,0,0,0,0,65100,6092,0,3000,0,{"$f":"IF($Z$2=\"gpf\",IF(D15<18001,265,IF(D15<33501,440,IF(D15<54001,658,875))),VLOOKUP(C7,'Basic Profile'!A10:R109,18,0))","v":0},0,0,0,0,0,0,null,{"v":9092,"d":"9092.00"},{"v":56008,"d":"56008.00"}]
[null,12,"2021-12-01",46500,0,{"$f":"IF(F$11=0,0,F19)","v":0},0,14415,4185,0,0,0,0,65100,6092,0,3000,0,{"$f":"IF($Z$2=\"gpf\",IF(D15<18001,265,IF(D15<33501,440,IF(D15<54001,658,875))),VLOOKUP(C7,'Basic Profile'!A10:R109,18,0))","v":0},0,0,0,0,0,0,{"$f":"VLOOKUP(C7,'Basic Profile'!A10:R109,16,0)","v":250},{"v":9342,"d":"9342.00"},{"v":55758,"d":"55758.00"}]
[null,1,"2022-01-01",46500,0,{"$f":"IF(F$11=0,0,F20)","v":0},0,14415,4185,0,0,0,0,65100,6092,0,3000,0,{"$f":"IF($Z$2=\"gpf\",IF(D15<18001,265,IF(D15<33501,440,IF(D15<54001,658,875))),VLOOKUP(C7,'Basic Profile'!A10:R109,18,0))","v":0},0,0,0,0,0,0,null,{"v":9092,"d":"9092.00"},{"v":56008,"d":"56008.00"}]
[null,2,"2022-02-01",46500,0,{"$f":"IF(F$11=0,0,F21)","v":0},0,14415,4185,0,0,0,0,65100,6092,0,3000,0,{"$f":"IF($Z$2=\"gpf\",IF(D15<18001,265,IF(D15<33501,440,IF(D15<54001,658,875))),VLOOKUP(C7,'Basic Profile'!A10:R109,18,0))","v":0},0,0,0,0,0,0,null,{"v":9092,"d":"9092.00"},{"v":56008,"d":"56008.00"}]
[null,null,"DA Arrear",{"$nulls":4},{"$f":"(ROUND(31%*D15,0)-ROUND(28%*D15,0))*3","v":4185},{"$nulls":5},{"$f":"H23","v":4185},{"$f":"IF($Z$2=\"NPS\",ROUND((ROUND(31%*D15,0)-ROUND(28%*D15,0))*10%,0)*3,IF($Z$2=\"GPF\",H23,0))","v":420},{"$nulls":4},0,{"$nulls":4},{"$f":"IF($Z$2=\"NPS\",N23-O23,IF($Z$2=\"GPF\",0))","v":3765},null,{"v":4185,"d":"4185.00"},{"v":0,"d":"0.00"}]
[null,null,"HRA Arrear ",{"$nulls":5},{"$f":"IF($AC$4=16%,ROUND(0.02*D15,0),ROUND(0.01*D15,0))","v":465},{"$nulls":4},465,{"$nulls":12},{"v":0,"d":"0.00"},{"v":465,"d":"465.00"}]
[null,null,"Surrender",{"$f":"IF(L3=\"NO\",0,IF(X3=3,D22,VLOOKUP(X3,B11:D22,3,FALSE)))/2","v":22550},{"$nulls":3},{"$f":"IF(AND(X3>3,X3<7),ROUND(17%*D25,0),ROUND(28%*D25,0))","v":3834},{"$nulls":5},26384,{"$nulls":12},{"v":0,"d":"0.00"},{"v":26384,"d":"26384.00"}]
[null,null,"Bonus",{"$f":"IF(Z4=\"Yes\",6774,0)","v":6774},{"$nulls":9},6774,{"$f":"IF($Z$2=\"Yes\",0,IF($Z$2=\"No\",D26/2,0))","v":0},{"$nulls":9},{"$f":"IF($Z$2=\"GPF\",0,IF($Z$2=\"NPS\",D26/2,0))","v":3387},null,{"v":3387,"d":"3387.00"},{"v":3387,"d":"3387.00"}]
[null,null,"Fixation Arrear",{"$nulls":10},0,{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Salary Arrear 1",{"$nulls":10},0,{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Salary Arrear 2",{"$nulls":10},0,{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Salary Arrear 3",{"$nulls":10},0,{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Other ",null,0,0,{"$nulls":7},0,{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"TOTAL",{"$f":"SUM(D11:D31)","v":581724},0,0,0,149822,47912,0,0,0,0,779458,69844,0,36000,0,0,0,{"v":220,"d":"220.00"},0,0,0,7152,250,{"v":113466,"d":"113466.00"},{"v":665992,"d":"665992.00"}]
[]
[]
[]
[]
[{"$nulls":4},"Signature of Employee",{"$nulls":22},"Signature of DDO"]

{"sheet":"Other Deduction","index":2,"n_rows":21,"n_cols":122,"rows_kept":21,"merged":[[0,0,0,5],[1,0,1,5],[8,5,10,5],[13,5,15,5],[16,5,17,5],[18,0,18,1],[19,0,19,1],[20,0,20,5]]}
["osru ds vfrfjDr dVkSfr;k¡] vk;@tek jkf'k ,oa NwV dk fooj.k"]
[{"$f":"'GA-55'!D8& \" ,   \" &'GA-55'!K8&\"                         PAN-  \"&'GA-55'!P8","v":"PARMANAND MEGHWAL ,                            PAN-  PAN N0."}]
["1- edku fdjk;k HkRrk ¼ NwV tks ysuh gS½",{"v":0,"d":"0.00"},null,"17- cpr [kkrs dh tek jkf'k ij izkIr C;kt (80 TTA/80 TTB) gsrq",{"v":0,"d":"0.00"},"BASIC+D.A.",{"$nulls":115},"UPS Kuhada Khurd"]
["2- euksjatu Hkrk /kkjk 16 ¼ii½ ds vUrxZr ",{"v":0,"d":"0.00"},null,"18- vU; vk; ¼,Q Mh ij C;kt] vU; C;kt ;k vU; L=ks+= ls vk; vkfn dk ;ksx½",{"v":0,"d":"0.00"},{"$f":"'GA-55'!N32-'GA-55'!I32","v":731546}]
["3- O;o;k; dj /kkjk 16 ¼iii½ ds vUrxrZ ",{"v":0,"d":"0.00"},null,"19- vU; tek jkf'k ¼/kkjk 80 lh ds vUrxZr½",{"v":0,"d":"0.00"},"Taxable Amt"]
["4- x`g lEifr ls izkIr fdjk;k & vk;",{"v":0,"d":"0.00"},null,"20- /kkjk 80CCC - isa'ku Iyku gsrq va'knku ¼,u-ih-,l- ds avykok½",{"v":0,"d":"0.00"},{"$f":"'Tax Old Regime'!Q47","v":616240}]
["5- x`gdj ",{"v":0,"d":"0.00"},null,"21- /kkjk 80CCD(1B) -uohu isa'ku ;kstuk esa vfrfjDr va'knku ¼vf/kdre :- 50]000½",{"v":0,"d":"0.00"},"Tax Deposited"]
["6- x`g _.k fdLr ewy ¼tks osru ls ugha dkVk x;k½",{"v":0,"d":"0.00"},null,"22- /kkjk 80D - fpfdRlk chek izhfe;e ¼lkekU; 25000] ofj\"B ukxfjd 50000½",{"v":0,"d":"0.00"},{"$f":"'GA-55'!X32","v":{"v":0,"d":"0.00"}}]
["7- x`g _.k fdLr C;kt ¼tks osru ls ugha dkVk x;k½",{"v":0,"d":"0.00"},null,"23- /kkjk 80DD - fodykax vkfJrksa ds fpfdRlk mipkj¼vf/kdre 75000] 80% fodykaxrk 125000½",{"v":0,"d":"0.00"},"Rebate Under Section\n80C, 80CCC, 80CCD(1)"]
["8- thou chek izhfe;e ¼tks osru ls ugh dkVk x;k½ LIC",{"v":0,"d":"0.00"},null,"24- /kkjk 80DDB - fof'k\"V jksxksa ds mipkj gsrq dVkSrh ¼lkekU; 40000] ofj\"B ukxfjd 1 yk[k½",{"v":0,"d":"0.00"},{"$nulls":116},"UPS Banediya Charnan"]
["9- ih-,y-vkbZ- (PLI)",{"v":0,"d":"0.00"},null,"25- /kkjk 80E - mPp f'k{kk gsrq fy, _.k dk C;kt ¼/kkjk 80E½",{"v":0,"d":"0.00"},{"$nulls":116},"UPS Laxmipura Dhakaran"]
["10- V;w'ku Qhl (Tution Fees)",{"v":0,"d":"0.00"},null,"26- /kkjk 80G - /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼d Js.kh 100% ,oa [k Js.kh 50%½",{"v":0,"d":"0.00"},{"$f":"'Tax Old Regime'!Q31","v":113216},{"$nulls":115},"UPS Pathraj Kala"]
["11- ;w- ,y- vkbZ- ih-@okf\"kZd Iyku",{"v":0,"d":"0.00"},null,"27- /kkjk 80U - LFkkbZ 'kkjhfjd fodykaxrk ¼vf/kdre 75000] 80% fodykaxrk 125000½",{"v":0,"d":"0.00"}]
["12- jk\"Vªh; cpr i= (NSC)",{"v":0,"d":"0.00"},null,"28- /kkjk 80 GGA - vuqeksfnr oSKkfud]lkekftd]xzkeh.k fodkl vkfn gsrq fn;k x;k nku",{"v":0,"d":"0.00"},"edku fdjk;k NwV ds fy, jlhn dh vko';drk",{"$nulls":115},"PS Aarampura"]
["13- jk\"Vªh; cpr i= ij vnr C;kt",{"v":0,"d":"0.00"},null,"29- bfDoVh fyad lsfoax Ldhe",{"v":0,"d":"0.00"},{"$nulls":116},"UPS Laxmipura Dhakaran"]
["14- yksd Hkfo\"; fuf/k (PPF)",{"v":0,"d":"0.00"},null,"30- LFkfxr okf\"kZdh",{"v":0,"d":"0.00"},{"$nulls":116},"UPS Raghunathpura"]
["15- jk\"Vªh; cpr Ldhe",{"v":0,"d":"0.00"},null,"31- jkgr /kkjk 89 ds rgr ",{"v":0,"d":"0.00"},{"$f":"IF(B3>=1,(F4*10%+B3),0)","v":{"v":0,"d":"0.00"}},{"$nulls":115},"UPS Manda"]
["16- lqdU;k le`f) ;kstuk (SSY)",{"v":0,"d":"0.00"},null,"32- osru fcy ds vykok tek djk;k x;k aavk;dj (TDS)",{"v":0,"d":"0.00"},{"$nulls":116},"UPS Sandla"]
[{"$f":"'Tax Old Regime'!B63","v":"Income Tax Payable"},null,null,{"$f":"'Tax Old Regime'!Q63","v":{"v":37178,"d":"37178.00"}},"HRA",{"$f":"'GA-55'!I32","v":{"v":47912,"d":"47912.00"}},{"$nulls":115},"UPS Ramsinghpura"]
[{"$f":"\"Total Rebate of (US 80C, 80CCC,80CCD(1)) =  \"&'Tax Old Regime'!Q31","v":"Total Rebate of (US 80C, 80CCC,80CCD(1)) =  113216"},null,null,{"$f":"\"Investable Amount = \"&(150000-'Tax Old Regime'!Q31)","v":"Investable Amount = 36784"},{"$nulls":117},"GSS Ganeshganj"]
["WWW.RAJTEACHERS.NET "]

{"sheet":"Tax Old Regime","index":3,"n_rows":65,"n_cols":17,"rows_kept":65,"merged":[[0,1,0,16],[1,1,1,16],[2,2,2,3],[2,4,2,9],[2,11,2,13],[2,15,2,16],[3,2,3,14],[4,2,4,14],[5,2,5,14],[6,1,8,1],[6,2,6,11],[6,12,6,14],[6,15,7,16],[7,2,7,11],[7,12,7,14],[8,2,8,11],[8,12,8,14],[9,2,9,14],[10,1,12,1],[10,2,10,9],[10,10,10,11],[10,12,10,14],[10,15,12,16],[11,2,12,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[11,12,11,14],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,2,13,14],[14,2,14,14],[15,2,15,14],[16,2,16,14],[17,1,33,1],[17,2,17,16],[18,2,18,16],[19,3,19,6],[19,10,19,12],[19,15,29,16],[20,3,20,6],[20,10,20,12],[21,3,21,6],[21,10,21,12],[22,3,22,6],[22,10,22,12],[23,3,23,6],[23,10,23,12],[24,3,24,6],[24,10,24,12],[25,3,25,6],[25,10,25,12],[26,3,26,6],[26,10,26,12],[27,3,27,6],[27,10,27,12],[28,3,28,6],[28,10,28,12],[29,2,29,12],[30,2,30,14],[31,2,31,14],[32,2,32,14],[33,2,33,14],[34,1,43,1],[34,2,34,16],[35,2,35,14],[36,2,36,14],[37,2,37,14],[38,2,38,14],[39,2,39,14],[40,2,40,14],[41,2,41,14],[42,2,42,14],[43,2,43,14],[44,2,44,14],[45,2,45,14],[46,2,46,14],[47,1,57,1],[47,2,47,16],[48,2,48,6],[48,7,48,10],[48,11,48,14],[49,2,49,4],[49,5,49,6],[49,7,49,9],[49,11,49,13],[50,2,50,4],[50,5,50,6],[50,7,50,9],[50,11,50,13],[51,2,51,4],[51,5,51,6],[51,7,51,9],[51,11,51,13],[52,2,52,4],[52,5,52,6],[52,7,52,9],[52,11,52,13],[53,2,53,14],[54,2,54,14],[55,2,55,14],[56,2,56,14],[57,2,57,14],[58,2,58,14],[59,2,59,14],[60,1,61,1],[60,2,61,4],[60,5,60,8],[60,9,60,10],[60,12,60,13],[60,15,60,16],[61,5,61,8],[61,9,61,10],[61,12,61,13],[61,15,61,16],[62,1,62,14],[66,2,68,16],[69,11,75,16],[74,3,74,9]]}
[null,{"$f":"'GA-55'!D6","v":"GOVT. SR. SECONDARY SCHOOL, DILOD HATHI, ATRU BARAN"}]
[null,"vk;dj x.kuk izi= o\"kZ 2021&2022 ¼dj fu/kkZj.k o\"kZ 2022&2023½"]
[null,1,"uke deZpkjh %",null,{"$f":"'GA-55'!D8","v":"PARMANAND MEGHWAL"},{"$nulls":5}," in %",{"$f":"'GA-55'!L8","v":"SR. TEACHER"},null,null,"PAN :",{"$f":"'GA-55'!R8","v":"ASQPM6311H"}]
[null,2,"vk; %  o\"kZ&2021&22 esa izkIr dqy osru ¼ dj ;ksX; lqfo/kkvksa ds eqY; lfgr ½",{"$nulls":12},"#-",{"$f":"IF('GA-55'!Z2=\"GPF\",'GA-55'!N32,('GA-55'!N32+'GA-55'!O32))","v":{"v":849302,"d":"849302.00"}}]
[null,3,"x`g fdjk;k] /kkjk 10¼13&A½ ds vUrxrZ ,oa /kkjk 10¼14½ds vUrxrZ vU; Hkrs tks dj eqDÙk gSA",{"$nulls":12},"#-",{"$f":"'Other Deduction'!B3","v":{"v":0,"d":"0.00"}}]
[null,4,"                                                              'ks\"k ¼2&3½",{"$nulls":12},"#-",{"$f":"Q4-Q5","v":{"v":849302,"d":"849302.00"}}]
[null,5," ¼i½ euksjatu Hkrk /kkjk 16 ¼ii½ ds vUrxrZ ¼ vf/kdre lhek : 5000 ½",{"$nulls":9},{"$f":"'Other Deduction'!B4","v":{"v":0,"d":"0.00"}}]
[null,null," ¼ii½ O;o;k; dj /kkjk 16 ¼iii½ ds vUrxrZ ",{"$nulls":9},{"$f":"'Other Deduction'!B5","v":{"v":0,"d":"0.00"}}]
[null,null," ¼iiI½ LVs.MMZ fMMsD'ku (Standard Deduction)  50]000 ¼vf/kdre½",{"$nulls":9},{"$f":"IF(Q6<50000,Q6,50000)","v":{"v":50000,"d":"50000.00"}},null,null,"#-",{"$f":"SUM(M7:O9)","v":{"v":50000,"d":"50000.00"}}]
[null,6,"                                                           'ks\"k ¼4&5½",{"$nulls":12},"#-",{"$f":"Q6-Q9","v":{"v":799302,"d":"799302.00"}}]
[null,7,"¼v½x`g lEifr ls vk;%¼1½ Loa; ds mi;ksx esa &'kwU;",{"$nulls":7},"¼2½ izkIr fdjk;k #-",null,{"$f":"'Other Deduction'!B6","v":{"v":0,"d":"0.00"}}]
[null,null,"¼c½ ?kVk;sa ",null," fdjk;s dk 30%",null,null," x`g _.k ij C;kt",null,null," x`gdj ",null,"  ;ksx 7¼c½"]
[{"$nulls":4},{"$f":"ROUND(M11*0.3,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(('GA-55'!W32+'Other Deduction'!B9)>200000,200000,('GA-55'!W32+'Other Deduction'!B9))","v":{"v":0,"d":"0.00"}},null,null,{"$f":"'Other Deduction'!B7","v":{"v":0,"d":"0.00"}},null,{"$f":"E13+H13+K13","v":{"v":0,"d":"0.00"}}]
[null,null,"                                                          'ks\"k &@$¼7¼v½ ,oa ;ksx 7¼c½ dk½  ",{"$nulls":12},"#-",{"$f":"M11-M13","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                             dqy 'ks\"k &@$¼6,oa 7½",{"$nulls":12},"#-",{"$f":"Q10+Q14","v":{"v":799302,"d":"799302.00"}}]
[null,9,"vU; vk;",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E3+'Other Deduction'!E4","v":{"v":0,"d":"0.00"}}]
[null,10,"ldy vk;                                                            ;ksx ¼8$9½",{"$nulls":12},"#-",{"$f":"Q15+Q16","v":{"v":799302,"d":"799302.00"}}]
[null,11,"?kVkb;s dVkSSfr;k¡ %& /kkjk US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) vf/kdre lhek 1]50]000@& ¼/kkjk 80CCE ½ ] ¼/kkjk 80CCD (2), ds vykok"]
[null,null,"(i)","jkT; chek ¼SI)",{"$nulls":3},"#-",{"$f":"'GA-55'!Q32","v":{"v":36000,"d":"36000.00"}},"(xi)","ljdkjh isa'ku ;kstuk esa va'knku ECPF\nvf/kdre osru dk 10%¼/kkjk 80ccd½",null,null,"#-",{"$f":"IF('GA-55'!Z2=\"NPS\",'GA-55'!O32-Q33,0)","v":{"v":69844,"d":"69844.00"}}]
[null,null,"(ii)","thou chek izhfe;e ¼LIC)",{"$nulls":3},"#-",{"$f":"'GA-55'!T32+'Other Deduction'!B10","v":{"v":0,"d":"0.00"}},"(xii)","isa'ku Iyku gsrq va'knku¼/kkjk 80ccc½",null,null,"#-",{"$f":"'Other Deduction'!E6","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)","jk\"Vªh; cpr i= ¼NSC)",{"$nulls":3},"#-",{"$f":"'Other Deduction'!B14","v":{"v":0,"d":"0.00"}},"(xiii)","jk\"Vªh; cpr i= ij vnr C;kt",null,null,"#-",{"$f":"'Other Deduction'!B15","v":{"v":0,"d":"0.00"}}]
[null,null,"(iv)","yksd Hkfo\"; fuf/k ¼PPF)",{"$nulls":3},"#-",{"$f":"'Other Deduction'!B16","v":{"v":0,"d":"0.00"}},"(xiv)","V;w'ku Qhl ",null,null,"#-",{"$f":"'Other Deduction'!B12","v":{"v":0,"d":"0.00"}}]
[null,null,"(v)","jk\"Vªh; cpr Ldhe ¼NSS)",{"$nulls":3},"#-",{"$f":"'Other Deduction'!B17","v":{"v":0,"d":"0.00"}},"(xv)","bfDoVh fyad lsfoax Ldhe",null,null,"#-",{"$f":"'Other Deduction'!E15","v":{"v":0,"d":"0.00"}}]
[null,null,"(vi)","lkekU; izko/kk;h fuf/k ¼GPF)",{"$nulls":3},"#-",{"$f":"IF('GA-55'!Z2=\"No\",'GA-55'!O32,0)","v":{"v":0,"d":"0.00"}},"(xvi)","LFkfxr okf\"kZdh ¼Defferred Annuty)",null,null,"#-",{"$f":"'Other Deduction'!E16","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","lkewfgd chek izhfe;e ¼G.Ins.)",{"$nulls":3},"#-",{"$f":"'GA-55'!U12","v":{"v":220,"d":"220.00"}},"(xvii)","ih-,y-vkbZ- ¼PLI)",null,null,"#-",{"$f":"'Other Deduction'!B11","v":{"v":0,"d":"0.00"}}]
[null,null,"(viii)",";w- ,y- vkbZ- ih-@okf\"kZd Iyku",{"$nulls":3},"#-",{"$f":"'Other Deduction'!B13","v":{"v":0,"d":"0.00"}},"(xviii)","vU; tekjkf'k ¼/kkjk 80 lh ds vUrxZr½",null,null,"#-",{"$f":"'Other Deduction'!E5","v":{"v":0,"d":"0.00"}}]
[null,null,"(ix)","x`g _.k fdLr ¼HBA Premium)",{"$nulls":3},"#-",{"$f":"'GA-55'!V32+'Other Deduction'!B8","v":{"v":0,"d":"0.00"}},"(xix)","lqdU;k le`f) ;kstuk esa tek jkf'k",null,null,"#-",{"$f":"'Other Deduction'!B18","v":{"v":0,"d":"0.00"}}]
[null,null,"(x)","lkekU; izko/kk;h fuf/k ¼GPF)",{"$nulls":3},"#-",{"$f":"IF('GA-55'!Z2=\"NPS\",'GA-55'!Y32,0)","v":{"v":7152,"d":"7152.00"}},"(xx)","vU;"]
[null,null,";ksx ( i ls xviii )",{"$nulls":10},"#-",{"$f":"SUM(I20:I29)+SUM(O20:O29)","v":{"v":113216,"d":"113216.00"}}]
[null,null,"                        vf/kdre dVkSrh dh jkf'k 1-50 yk[k #i, rd",{"$nulls":12},"#-",{"$f":"IF(O30<150001,ROUND(O30,0),150000)","v":{"v":113216,"d":"113216.00"}}]
[null,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",{"$nulls":13},{"$f":"IF('GA-55'!Z2=\"NPS\",'GA-55'!O32,0)","v":{"v":69844,"d":"69844.00"}}]
[null,null,"(C) ?kVkb;s & /kkjk 80CCD (1B) uohu isa'ku ;kstuk esa vfrfjDr va'knku ¼vf/kdre :- 50]000)",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E7","v":{"v":0,"d":"0.00"}}]
[null,null,";ksx 11(A+B+C)      ",{"$nulls":12},"#-",{"$f":"SUM(Q31:Q33)","v":{"v":183060,"d":"183060.00"}}]
[null,12," vU; dVkSfr;k¡"]
[null,null,"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½",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E8","v":{"v":0,"d":"0.00"}}]
[null,null,"2- /kkjk 80DD fodykax vkfJrksa ds fpfdRlk mipkj ¼vf/kdre 75]000 rFkk 80% ;k vf/kd fodykaxrk 125]000½",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E9","v":{"v":0,"d":"0.00"}}]
[null,null,"3- /kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E10","v":{"v":0,"d":"0.00"}}]
[null,null,"4- /kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E11","v":{"v":0,"d":"0.00"}}]
[null,null,"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½",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E12","v":{"v":0,"d":"0.00"}}]
[null,null,"6- /kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E13","v":{"v":0,"d":"0.00"}}]
[null,null,"7- /kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA) (80 TTB - aofj\"B ukxfjd vf/kdre C;kt 50000:-½",{"$nulls":12},"#-",{"$f":"IF('GA-55'!P4=\"Yes\",IF('Other Deduction'!E3<50001,'Other Deduction'!E3,50000),IF('Other Deduction'!E3<10001,'Other Deduction'!E3,10000))","v":{"v":0,"d":"0.00"}}]
[null,null,"8- /kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E14","v":{"v":0,"d":"0.00"}}]
[null,null,"dqy ;ksx 12 ¼ 1 ls 6 rd ½",{"$nulls":12},"#-",{"$f":"SUM(Q36:Q43)","v":{"v":0,"d":"0.00"}}]
[null,13,"dqy dVkSrh ( 11 + 12)",{"$nulls":12},"#-",{"$f":"Q34+Q44","v":{"v":183060,"d":"183060.00"}}]
[null,14,"dj ;ksX; vk; ( 10 - 13 )",{"$nulls":12},"#-",{"$f":"(Q17-Q45)","v":{"v":616242,"d":"616242.00"}}]
[null,15,"dqy vk; dh jkf'k dks lEiw.kZ djuk ¼ nl ds xq.kd esa ½ /kkjk 288A",{"$nulls":12},"#-",{"$f":"ROUND(Q46,-1)","v":{"v":616240,"d":"616240.00"}}]
[null,16," vk;dj dh x.kuk  mijksDr dkWye 15 ds vk/kkj ij"]
[null,null,",d O;fDr dj nkrk",{"$nulls":4},"ofj\"B ukxfjd ¼60 ls 80 o\"kZ rd½",{"$nulls":3},"80 o\"kZ ;k vf/kd vk;q"]
[null,null,"2,50,000 rd",null,null,"Nil",null,"3,00,000 rd",null,null,"Nil",{"$nulls":4},"#-",{"v":0,"d":"0.00"}]
[null,null,"2,50,001-5,00,000",null,null,{"v":0.05,"d":"5%"},null,"3,00,001-5,00,000",null,null,{"v":0.05,"d":"5%"},"5,00,000 rd",null,null,"Nil","#-",{"$f":"ROUND(IF('GA-55'!P4=\"No\",IF(Q47<250001,0,IF(Q47>500000,12500,((Q47-250000)*0.05))),IF(Q47<300001,0,IF(Q47>500000,10000,((Q47-300000)*0.05)))),0)","v":{"v":12500,"d":"12500.00"}}]
[null,null,"5,00,001-10,00,000",null,null,{"v":0.2,"d":"20%"},null,"5,00,001-10,00,000",null,null,{"v":0.2,"d":"20%"},"5,00,001-10,00,000",null,null,{"v":0.2,"d":"20%"},"#-",{"$f":"IF(Q47<500001,0,IF(Q47>1000000,100000,((Q47-500000)*0.2)))","v":{"v":23248,"d":"23248.00"}}]
[null,null,"10,00,000 ls vf/kd",null,null,{"v":0.3,"d":"30%"},null,"10,00,000 ls vf/kd",null,null,{"v":0.3,"d":"30%"},"10,00,000 ls vf/kd",null,null,{"v":0.3,"d":"30%"},"#-",{"$f":"IF(Q47<1000001,0,((Q47-1000000)*0.3))","v":{"v":0,"d":"0.00"}}]
[null,null,"¼1½ ;ksx vk;dj",{"$nulls":12},"#-",{"$f":"SUM(Q50:Q53)","v":{"v":35748,"d":"35748.00"}}]
[null,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½",{"$nulls":12},"#-",{"$f":"IF(Q47>500000,0,IF(Q54<12501,Q54,12500))","v":{"v":0,"d":"0.00"}}]
[null,null,"¼3½ 'ks\"k vk;dj ¼1&2½",{"$nulls":12},"#-",{"$f":"Q54-Q55","v":{"v":35748,"d":"35748.00"}}]
[null,null,"¼4½ f'k{kk midj 2% ,oa mPp f'k{kk ds fy, vf/kHkkj 2%  (;ksx 4%)",{"$nulls":12},"#-",{"$f":"ROUND(Q56*0.04,0)","v":{"v":1430,"d":"1430.00"}}]
[null,null,"                                                             dqy vk;dj ¼3$4½",{"$nulls":12},"#-",{"$f":"SUM(Q56:Q57)","v":{"v":37178,"d":"37178.00"}}]
[null,17,"?kVkb;s  %& jkgr /kkjk 89 ds rgr ",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E17","v":{"v":0,"d":"0.00"}}]
[null,18,"dqy 'ks\"k vk;dj",{"$nulls":12},"#-",{"$f":"Q58-Q59","v":{"v":37178,"d":"37178.00"}}]
[null,19," vk;dj dVkSrh\n dk fooj.k",null,null,"flrEcj 2021\nrd  :i;s",{"$nulls":3},"fnlEcj 2021\nrd  :i;s",null,"tuojh 2022\nrd :i;s","Qjojh 2022\nrd  :i;s",null,"Vh-Mh-,l-\n:Ik;s",";ksx dkWye 19 "]
[{"$nulls":5},{"$f":"SUM('GA-55'!X11:X17)","v":0},{"$nulls":3},{"$f":"SUM('GA-55'!X18:X20)","v":0},null,{"$f":"'GA-55'!X21","v":0},{"$f":"'GA-55'!X22","v":0},null,{"$f":"SUM('GA-55'!X23:X31)+'Other Deduction'!E18","v":0},{"$f":"F62+J62+L62+M62+O62","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(Q60>P62,\"Income Tax Payable\",IF(Q60<P62,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},{"$nulls":13},"#-",{"$f":"IF(Q60>P62,Q60-P62,P62-Q60)","v":{"v":37178,"d":"37178.00"}}]
[]
[{"$nulls":4},"gLrk{kj dkfeZd"]

{"sheet":"Tax New Regime","index":4,"n_rows":68,"n_cols":17,"rows_kept":68,"merged":[[0,1,0,16],[1,1,1,16],[2,2,2,3],[2,4,2,9],[2,11,2,13],[2,15,2,16],[3,2,3,14],[4,2,4,14],[5,2,5,14],[6,1,8,1],[6,2,6,11],[6,12,6,14],[6,15,7,16],[7,2,7,11],[7,12,7,14],[8,2,8,11],[8,12,8,14],[9,2,9,14],[10,1,12,1],[10,2,10,9],[10,10,10,11],[10,12,10,14],[10,15,12,16],[11,2,12,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[11,12,11,14],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,2,13,14],[14,2,14,14],[15,2,15,14],[16,2,16,14],[17,1,33,1],[17,2,17,16],[18,2,18,16],[19,3,19,6],[19,10,19,12],[19,15,29,16],[20,3,20,6],[20,10,20,12],[21,3,21,6],[21,10,21,12],[22,3,22,6],[22,10,22,12],[23,3,23,6],[23,10,23,12],[24,3,24,6],[24,10,24,12],[25,3,25,6],[25,10,25,12],[26,3,26,6],[26,10,26,12],[27,3,27,6],[27,10,27,12],[28,3,28,6],[28,10,28,12],[29,2,29,12],[30,2,30,14],[31,2,31,14],[32,2,32,14],[33,2,33,14],[34,1,43,1],[34,2,34,16],[35,2,35,14],[36,2,36,14],[37,2,37,14],[38,2,38,14],[39,2,39,14],[40,2,40,14],[41,2,41,14],[42,2,42,14],[43,2,43,14],[44,2,44,14],[45,2,45,14],[46,2,46,14],[47,1,60,1],[47,2,47,16],[48,2,48,6],[48,7,48,10],[48,11,48,14],[49,2,49,4],[49,5,49,6],[49,7,49,9],[49,11,49,13],[50,2,50,4],[50,5,50,6],[50,7,50,9],[50,11,50,13],[51,2,51,4],[51,5,51,6],[51,7,51,9],[51,11,51,13],[52,2,52,4],[52,5,52,6],[52,7,52,9],[52,11,52,13],[53,2,53,4],[53,5,53,6],[53,7,53,9],[53,11,53,13],[54,2,54,4],[54,5,54,6],[54,7,54,9],[54,11,54,13],[55,2,55,4],[55,5,55,6],[55,7,55,9],[55,11,55,13],[56,2,56,14],[57,2,57,14],[58,2,58,14],[59,2,59,14],[60,2,60,14],[61,2,61,14],[62,2,62,14],[63,1,64,1],[63,2,64,4],[63,5,63,8],[63,9,63,10],[63,12,63,13],[63,15,63,16],[64,5,64,8],[64,9,64,10],[64,12,64,13],[64,15,64,16],[65,1,65,14],[69,2,71,16],[72,11,78,16],[77,3,77,9]]}
[null,{"$f":"'GA-55'!D6","v":"GOVT. SR. SECONDARY SCHOOL, DILOD HATHI, ATRU BARAN"}]
[null,"vk;dj x.kuk izi= o\"kZ 2021&2022 ¼dj fu/kkZj.k o\"kZ 2022&2023½"]
[null,1,"uke deZpkjh %",null,{"$f":"'GA-55'!D8","v":"PARMANAND MEGHWAL"},{"$nulls":5}," in %",{"$f":"'GA-55'!L8","v":"SR. TEACHER"},null,null,"PAN :",{"$f":"'GA-55'!R8","v":"ASQPM6311H"}]
[null,2,"vk; %  o\"kZ&2021&22 esa izkIr dqy osru ¼ dj ;ksX; lqfo/kkvksa ds eqY; lfgr ½",{"$nulls":12},"#-",{"$f":"IF('GA-55'!Z2=\"No\",'GA-55'!N32,('GA-55'!N32+'GA-55'!O32))","v":{"v":849302,"d":"849302.00"}}]
[null,3,"x`g fdjk;k] /kkjk 10¼13&A½ ds vUrxrZ ,oa /kkjk 10¼14½ds vUrxrZ vU; Hkrs tks dj eqDÙk gSA",{"$nulls":12},"#-",{"v":0,"d":"0.00"}]
[null,4,"                                                              'ks\"k ¼2&3½",{"$nulls":12},"#-",{"$f":"Q4-Q5","v":{"v":849302,"d":"849302.00"}}]
[null,5," ¼i½euksjatu Hkrk /kkjk 16 ¼ii½ ds vUrxrZ ¼ vf/kdre lhek : 5000 ½",{"$nulls":9},{"$f":"'Other Deduction'!B4","v":{"v":0,"d":"0.00"}}]
[null,null," ¼ii½ O;o;k; dj /kkjk 16 ¼iii½ ds vUrxrZ ",{"$nulls":9},{"$f":"'Other Deduction'!B5","v":{"v":0,"d":"0.00"}}]
[null,null," ¼iiI½ LVs.MMZ fMMsD'ku (Standard Deduction)  50]000 ¼vf/kdre½",{"$nulls":9},{"v":0,"d":"0.00"},null,null,"#-",{"$f":"SUM(M7:O9)","v":{"v":0,"d":"0.00"}}]
[null,6,"                                                           'ks\"k ¼4&5½",{"$nulls":12},"#-",{"$f":"Q6-Q9","v":{"v":849302,"d":"849302.00"}}]
[null,7,"¼v½x`g lEifr ls vk;%¼1½ Loa; ds mi;ksx esa &'kwU;",{"$nulls":7},"¼2½ izkIr fdjk;k #-",null,{"v":0,"d":"0.00"}]
[null,null,"¼c½ ?kVk;sa ",null," fdjk;s dk 30%",null,null," x`g _.k ij C;kt",null,null," x`gdj ",null,"  ;ksx 7¼c½"]
[{"$nulls":4},{"$f":"ROUND(M11*0.3,0)","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"},null,null,{"$f":"'Other Deduction'!B7","v":{"v":0,"d":"0.00"}},null,{"$f":"E13+H13+K13","v":{"v":0,"d":"0.00"}}]
[null,null,"                                                          'ks\"k &@$¼7¼v½ ,oa ;ksx 7¼c½ dk½  ",{"$nulls":12},"#-",{"$f":"M11-M13","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                             dqy 'ks\"k &@$¼6,oa 7½",{"$nulls":12},"#-",{"$f":"Q10+Q14","v":{"v":849302,"d":"849302.00"}}]
[null,9,"vU; vk;",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E3+'Other Deduction'!E4","v":{"v":0,"d":"0.00"}}]
[null,10,"ldy vk;                                                            ;ksx ¼8$9½",{"$nulls":12},"#-",{"$f":"Q15+Q16","v":{"v":849302,"d":"849302.00"}}]
[null,11,"?kVkb;s dVkSSfr;k¡ %& /kkjk US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) vf/kdre lhek 1]50]000@& ¼/kkjk 80CCE ½ ] ¼/kkjk 80CCD (2), ds vykok"]
[null,null,"(i)","jkT; chek ¼SI)",{"$nulls":3},"#-",{"$f":"'GA-55'!Q32","v":{"v":36000,"d":"36000.00"}},"(xi)","ljdkjh isa'ku ;kstuk esa va'knku ECPF\nvf/kdre osru dk 10%¼/kkjk 80ccd½",null,null,"#-",{"$f":"IF('GA-55'!Z2=\"NPS\",'GA-55'!O32-Q33,0)","v":{"v":69844,"d":"69844.00"}}]
[null,null,"(ii)","thou chek izhfe;e ¼LIC)",{"$nulls":3},"#-",{"$f":"'GA-55'!T32+'Other Deduction'!B10","v":{"v":0,"d":"0.00"}},"(xii)","isa'ku Iyku gsrq va'knku¼/kkjk 80ccc½",null,null,"#-",{"$f":"'Other Deduction'!E6","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)","jk\"Vªh; cpr i= ¼NSC)",{"$nulls":3},"#-",{"$f":"'Other Deduction'!B14","v":{"v":0,"d":"0.00"}},"(xiii)","jk\"Vªh; cpr i= ij vnr C;kt",null,null,"#-",{"$f":"'Other Deduction'!B15","v":{"v":0,"d":"0.00"}}]
[null,null,"(iv)","yksd Hkfo\"; fuf/k ¼PPF)",{"$nulls":3},"#-",{"$f":"'Other Deduction'!B16","v":{"v":0,"d":"0.00"}},"(xiv)","V;w'ku Qhl ",null,null,"#-",{"$f":"'Other Deduction'!B12","v":{"v":0,"d":"0.00"}}]
[null,null,"(v)","jk\"Vªh; cpr Ldhe ¼NSS)",{"$nulls":3},"#-",{"$f":"'Other Deduction'!B17","v":{"v":0,"d":"0.00"}},"(xv)","bfDoVh fyad lsfoax Ldhe",null,null,"#-",{"$f":"'Other Deduction'!E15","v":{"v":0,"d":"0.00"}}]
[null,null,"(vi)","lkekU; izko/kk;h fuf/k ¼GPF)",{"$nulls":3},"#-",{"$f":"IF('GA-55'!Z2=\"No\",'GA-55'!O32,0)","v":{"v":0,"d":"0.00"}},"(xvi)","LFkfxr okf\"kZdh ¼Defferred Annuty)",null,null,"#-",{"$f":"'Other Deduction'!E16","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","lkewfgd chek izhfe;e ¼G.Ins.)",{"$nulls":3},"#-",{"$f":"'GA-55'!U12","v":{"v":220,"d":"220.00"}},"(xvii)","ih-,y-vkbZ- ¼PLI)",null,null,"#-",{"$f":"'Other Deduction'!B11","v":{"v":0,"d":"0.00"}}]
[null,null,"(viii)",";w- ,y- vkbZ- ih-@okf\"kZd Iyku",{"$nulls":3},"#-",{"$f":"'Other Deduction'!B13","v":{"v":0,"d":"0.00"}},"(xviii)","vU; tekjkf'k ¼/kkjk 80 lh ds vUrxZr½",null,null,"#-",{"$f":"'Other Deduction'!E5","v":{"v":0,"d":"0.00"}}]
[null,null,"(ix)","x`g _.k fdLr ¼HBA Premium)",{"$nulls":3},"#-",{"$f":"'GA-55'!V32+'Other Deduction'!B8","v":{"v":0,"d":"0.00"}},"(xix)","lqdU;k le`f) ;kstuk esa tek jkf'k",null,null,"#-",{"$f":"'Other Deduction'!B18","v":{"v":0,"d":"0.00"}}]
[null,null,"(x)","lkekU; izko/kk;h fuf/k ¼GPF)",{"$nulls":3},"#-",{"$f":"IF('GA-55'!Z2=\"NPS\",'GA-55'!Y32,0)","v":{"v":7152,"d":"7152.00"}},"(xx)","vU;"]
[null,null,";ksx ( i ls xviii )",{"$nulls":10},"#-",{"$f":"SUM(I20:I29)+SUM(O20:O29)","v":{"v":113216,"d":"113216.00"}}]
[null,null,"                        vf/kdre dVkSrh dh jkf'k 1-50 yk[k #i, rd",{"$nulls":12},"#-",{"v":0,"d":"0.00"}]
[null,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",{"$nulls":13},{"$f":"IF('GA-55'!Z2=\"NPS\",'GA-55'!O32,0)","v":{"v":69844,"d":"69844.00"}}]
[null,null,"(C) ?kVkb;s & /kkjk 80CCD (1B) uohu isa'ku ;kstuk esa vfrfjDr va'knku ¼vf/kdre :- 50]000)",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E7","v":{"v":0,"d":"0.00"}}]
[null,null,";ksx 11(A+B+C)      ",{"$nulls":12},"#-",{"$f":"SUM(Q31:Q33)","v":{"v":69844,"d":"69844.00"}}]
[null,12," vU; dVkSfr;k¡"]
[null,null,"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½",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E8","v":{"v":0,"d":"0.00"}}]
[null,null,"2- /kkjk 80DD fodykax vkfJrksa ds fpfdRlk mipkj ¼vf/kdre 75]000 rFkk 80% ;k vf/kd fodykaxrk 125]000½",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E9","v":{"v":0,"d":"0.00"}}]
[null,null,"3- /kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E10","v":{"v":0,"d":"0.00"}}]
[null,null,"4- /kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E11","v":{"v":0,"d":"0.00"}}]
[null,null,"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½",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E12","v":{"v":0,"d":"0.00"}}]
[null,null,"6- /kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E13","v":{"v":0,"d":"0.00"}}]
[null,null,"7- /kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA) (80 TTB - aofj\"B ukxfjd vf/kdre C;kt 50000:-½",{"$nulls":12},"#-",{"$f":"IF('GA-55'!P4=\"Yes\",IF('Other Deduction'!E3<50001,'Other Deduction'!E3,50000),IF('Other Deduction'!E3<10001,'Other Deduction'!E3,10000))","v":{"v":0,"d":"0.00"}}]
[null,null,"8- /kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E14","v":{"v":0,"d":"0.00"}}]
[null,null,"dqy ;ksx 12 ¼ 1 ls 6 rd ½",{"$nulls":12},"#-",{"$f":"SUM(Q36:Q43)","v":{"v":0,"d":"0.00"}}]
[null,13,"dqy dVkSrh ( 11 + 12)",{"$nulls":12},"#-",{"$f":"Q34+Q44","v":{"v":69844,"d":"69844.00"}}]
[null,14,"dj ;ksX; vk; ( 10 - 13 )",{"$nulls":12},"#-",{"$f":"(Q17-Q45)","v":{"v":779458,"d":"779458.00"}}]
[null,15,"dqy vk; dh jkf'k dks lEiw.kZ djuk ¼ nl ds xq.kd esa ½ /kkjk 288A",{"$nulls":12},"#-",{"$f":"ROUND(Q46,-1)","v":{"v":779460,"d":"779460.00"}}]
[null,16," vk;dj dh x.kuk  mijksDr dkWye 15 ds vk/kkj ij"]
[null,null,",d O;fDr dj nkrk",{"$nulls":4},"ofj\"B ukxfjd ¼60 ls 80 o\"kZ rd½",{"$nulls":3},"80 o\"kZ ;k vf/kd vk;q"]
[null,null,"2,50,000 rd",null,null,"Nil",null,"3,00,000 rd",null,null,"Nil","3,00,000 rd",null,null,"Nil","#-",{"v":0,"d":"0.00"}]
[null,null,"2,50,001-5,00,000",null,null,{"v":0.05,"d":"5%"},null,"2,50,001-5,00,000",null,null,{"v":0.05,"d":"5%"},"5,00,000 rd",null,null,{"v":0.05,"d":"5%"},"#-",{"$f":"ROUND(IF('GA-55'!P4=\"No\",IF(Q47<250001,0,IF(Q47>500000,12500,((Q47-250000)*0.05))),IF(Q47<300001,0,IF(Q47>500000,10000,((Q47-300000)*0.05)))),0)","v":{"v":12500,"d":"12500.00"}}]
[null,null,"5,00,001-7,50,000",null,null,{"v":0.1,"d":"10%"},null,"5,00,001-7,50,000",null,null,{"v":0.1,"d":"10%"},"5,00,001-7,50,000",null,null,{"v":0.1,"d":"10%"},"#-",{"$f":"IF(Q47<500001,0,IF(Q47>750000,25000,((Q47-500000)*0.1)))","v":{"v":25000,"d":"25000.00"}}]
[null,null,"7,50,001-10,00,000",null,null,{"v":0.15,"d":"15%"},null,"7,50,001-10,00,000",null,null,{"v":0.15,"d":"15%"},"7,50,001-10,00,000",null,null,{"v":0.15,"d":"15%"},null,{"$f":"IF(Q47<750001,0,IF(Q47>1000000,37500,((Q47-750000)*0.15)))","v":{"v":4419,"d":"4419.00"}}]
[null,null,"10,00,001-12,50,000",null,null,{"v":0.2,"d":"20%"},null,"10,00,001-12,50,000",null,null,{"v":0.2,"d":"20%"},"10,00,001-12,50,000",null,null,{"v":0.2,"d":"20%"},null,{"$f":"IF(Q47<1000001,0,IF(Q47>1250000,50000,((Q47-1000000)*0.2)))","v":{"v":0,"d":"0.00"}}]
[null,null,"12,50,001-15,00.000",null,null,{"v":0.25,"d":"25%"},null,"12,50,001-15,00.000",null,null,{"v":0.25,"d":"25%"},"12,50,001-15,00.000",null,null,{"v":0.25,"d":"25%"},null,{"$f":"IF(Q47<1250001,0,IF(Q47>1500000,62500,((Q47-1250000)*0.25)))","v":{"v":0,"d":"0.00"}}]
[null,null,"15,00,001 ls vf/kd",null,null,{"v":0.3,"d":"30%"},null,"15,00,001 ls vf/kd",null,null,{"v":0.3,"d":"30%"},"15,00,001 ls vf/kd",null,null,{"v":0.3,"d":"30%"},"#-",{"$f":"IF(Q47<1500001,0,((Q47-1500000)*0.3))","v":{"v":0,"d":"0.00"}}]
[null,null,"¼1½ ;ksx vk;dj",{"$nulls":12},"#-",{"$f":"SUM(Q50:Q56)","v":{"v":41919,"d":"41919.00"}}]
[null,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½",{"$nulls":12},"#-",{"$f":"IF(Q47>500000,0,IF(Q57<12501,Q57,12500))","v":{"v":0,"d":"0.00"}}]
[null,null,"¼3½ 'ks\"k vk;dj ¼1&2½",{"$nulls":12},"#-",{"$f":"Q57-Q58","v":{"v":41919,"d":"41919.00"}}]
[null,null,"¼4½ f'k{kk midj 2% ,oa mPp f'k{kk ds fy, vf/kHkkj 2%  (;ksx 4%)",{"$nulls":12},"#-",{"$f":"ROUND(Q59*0.04,0)","v":{"v":1677,"d":"1677.00"}}]
[null,null,"                                                             dqy vk;dj ¼3$4½",{"$nulls":12},"#-",{"$f":"SUM(Q59:Q60)","v":{"v":43596,"d":"43596.00"}}]
[null,17,"?kVkb;s  %& jkgr /kkjk 89 ds rgr ",{"$nulls":12},"#-",{"$f":"'Other Deduction'!E17","v":{"v":0,"d":"0.00"}}]
[null,18,"dqy 'ks\"k vk;dj",{"$nulls":12},"#-",{"$f":"Q61-Q62","v":{"v":43596,"d":"43596.00"}}]
[null,19," vk;dj dVkSrh\n dk fooj.k",null,null,"flrEcj 2021\nrd  :i;s",{"$nulls":3},"fnlEcj 2021\nrd  :i;s",null,"tuojh 2022\nrd :i;s","Qjojh 2022\nrd  :i;s",null,"Vh-Mh-,l-\n:Ik;s",";ksx dkWye 19 "]
[{"$nulls":5},{"$f":"SUM('GA-55'!X11:X17)","v":0},{"$nulls":3},{"$f":"SUM('GA-55'!X18:X20)","v":0},null,{"$f":"'GA-55'!X21","v":0},{"$f":"'GA-55'!X22","v":0},null,{"$f":"SUM('GA-55'!X23:X31)+'Other Deduction'!E18","v":0},{"$f":"F65+J65+L65+M65+O65","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(Q63>P65,\"Income Tax Payable\",IF(Q63<P65,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},{"$nulls":13},"#-",{"$f":"IF(Q63>P65,Q63-P65,P65-Q63)","v":{"v":43596,"d":"43596.00"}}]
[]
[{"$nulls":4},"gLrk{kj dkfeZd"]

{"sheet":"Form 16","index":5,"n_rows":157,"n_cols":12,"rows_kept":157,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11],[4,0,4,11],[5,0,5,5],[5,6,5,11],[6,0,6,5],[6,6,6,11],[7,0,7,5],[7,6,7,11],[8,0,9,5],[8,6,9,11],[10,0,10,2],[10,3,10,5],[10,6,10,11],[11,0,11,2],[11,3,11,5],[11,6,11,11],[12,3,14,5],[12,6,12,8],[12,9,12,11],[13,6,13,7],[13,9,14,11],[14,6,14,7],[16,0,16,1],[16,2,16,4],[16,5,16,6],[16,7,16,9],[16,10,16,11],[17,0,17,1],[17,2,17,4],[17,5,17,6],[17,7,17,9],[17,10,17,11],[18,0,18,1],[18,2,18,4],[18,5,18,6],[18,7,18,9],[18,10,18,11],[19,0,19,1],[19,2,19,4],[19,5,19,6],[19,7,19,9],[19,10,19,11],[20,0,20,1],[20,2,20,4],[20,5,20,6],[20,7,20,9],[20,10,20,11],[21,0,21,1],[21,2,21,4],[21,5,21,6],[21,7,21,9],[21,10,21,11],[22,0,22,11],[23,1,23,3],[23,4,23,11],[24,1,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[26,1,26,3],[26,6,26,7],[26,8,26,9],[27,1,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[28,1,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[36,1,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[37,1,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[38,1,38,3],[38,4,38,5],[38,6,38,7],[38,8,38,9],[39,1,39,3],[40,1,40,3],[40,4,40,5],[40,6,40,7],[40,8,40,9],[42,0,42,11],[43,1,43,3],[43,4,43,11],[44,1,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[46,1,46,3],[46,6,46,7],[46,8,46,9],[47,1,47,3],[47,6,47,7],[47,8,47,9],[48,1,48,3],[48,6,48,7],[48,8,48,9],[49,1,49,3],[49,6,49,7],[49,8,49,9],[50,1,50,3],[50,6,50,7],[50,8,50,9],[51,1,51,3],[51,6,51,7],[51,8,51,9],[52,1,52,3],[52,6,52,7],[52,8,52,9],[53,1,53,3],[53,6,53,7],[53,8,53,9],[54,1,54,3],[54,6,54,7],[54,8,54,9],[55,1,55,3],[55,6,55,7],[55,8,55,9],[56,1,56,3],[56,6,56,7],[56,8,56,9],[57,1,57,3],[57,6,57,7],[57,8,57,9],[58,1,58,3],[58,6,58,7],[58,8,58,9],[59,1,59,3],[60,1,60,3],[60,4,60,5],[60,6,60,11],[61,0,61,11],[62,1,62,3],[62,6,62,8],[63,0,63,2],[63,9,63,10],[64,0,64,4],[65,0,66,11],[67,0,67,1],[68,0,68,11],[69,0,69,11],[70,0,70,11],[71,0,71,11],[72,0,72,6],[73,0,73,11],[74,0,74,11],[75,0,75,11],[76,0,76,11],[77,0,77,11],[78,0,78,4],[81,0,81,11],[82,0,82,11],[89,9,89,10],[92,0,92,6],[93,0,93,6],[94,9,94,10],[108,6,110,7],[108,8,110,9],[108,10,110,11],[109,0,109,3],[111,6,111,7],[111,8,111,9],[111,10,111,11],[112,2,112,4],[112,6,112,7],[112,8,112,9],[112,10,112,11],[113,2,113,4],[113,6,113,7],[113,8,113,9],[113,10,113,11],[114,2,114,4],[114,6,114,7],[114,8,114,9],[114,10,114,11],[115,2,115,4],[115,6,115,7],[115,8,115,9],[115,10,115,11],[116,6,116,7],[116,8,116,9],[116,10,116,11],[117,6,117,7],[117,8,117,9],[117,10,117,11],[118,2,118,4],[118,6,118,7],[118,8,118,9],[118,10,118,11],[119,6,119,7],[119,8,119,9],[119,10,119,11],[120,6,120,7],[120,8,120,9],[120,10,120,11],[121,6,121,7],[121,8,121,9],[121,10,121,11],[124,6,124,7],[124,8,124,9],[124,10,124,11],[125,6,125,7],[125,8,125,9],[125,10,125,11],[128,8,128,9],[128,10,128,11],[129,2,129,4],[129,6,129,7],[129,8,129,9],[129,10,129,11],[130,2,130,4],[130,6,130,7],[130,8,130,9],[130,10,130,11],[131,2,131,4],[131,6,131,7],[131,8,131,9],[131,10,131,11],[132,6,132,7],[132,8,132,9],[132,10,132,11],[133,10,133,11],[134,10,134,11],[136,10,136,11],[137,10,137,11],[138,10,138,11],[139,10,139,11],[140,10,140,11],[141,10,141,11],[142,10,142,11],[143,10,143,11],[144,10,144,11],[145,0,145,11],[146,1,146,3],[146,6,146,8],[147,0,147,2],[148,0,148,11],[153,5,153,11],[154,5,154,11],[155,0,155,2],[155,7,155,11],[156,0,156,2],[156,7,156,11],[157,5,157,11]]}
["FORM NO.16"]
["[See rule 31 (1) (a)]"]
["Part A"]
["Certificate under section 203 of the Income Tax Act, 1961 for tax deducted"]
["at source from income chargeable under the head  “ Salaries “"]
["Name and address of the employer",{"$nulls":5},"Name and Designation of the employee"]
[{"$f":"'Basic Profile'!O3","v":"HANUMAN SAHAY"},{"$nulls":5},{"$f":"'GA-55'!D8","v":"PARMANAND MEGHWAL"}]
[{"$f":"'Basic Profile'!O5","v":"PRINCIPAL"},{"$nulls":5},{"$f":"'GA-55'!L8","v":"SR. TEACHER"}]
[{"$f":"'Basic Profile'!C6","v":"GOVT. SR. SECONDARY SCHOOL, DILOD HATHI, ATRU BARAN"},{"$nulls":5},{"$f":"'GA-55'!D6","v":"GOVT. SR. SECONDARY SCHOOL, DILOD HATHI, ATRU BARAN"}]
[]
["PAN of the Deducter",null,null,"TAN of the Deducter",null,null,"PAN of the Employee"]
[{"$nulls":3},{"$f":"'Basic Profile'!Q6","v":"XXXX9987D"},null,null,{"$f":"'GA-55'!R8","v":"ASQPM6311H"}]
["TDS Circle where annual",{"$nulls":5},"PERIOD",null,null,"Assessment Year"]
["return / statement under",{"$nulls":5},"FROM",null,"TO","2022-23"]
["section 206 is to be filed",{"$nulls":5},"01.04.2021",null,"31.03.2022"]
["Smmary of amount Paid/credited and tax Deducted at source thereon in respect of the Employee"]
["Quarter(s)",null,"Receipt Numbersof Original Quaterly Statements of TDS Under Sub-Section (3) of Section 200",null,null,"Amount Paid cridited",null,"      Amount of Tax Deducted     (Rs)",null,null,"Amount of Tax Deposited / Remitted                               (Rs)"]
["Quarter 1",{"$nulls":4},{"$f":"SUM('GA-55'!N11+'GA-55'!N12+'GA-55'!N13)","v":169125},null,{"$f":"SUM('GA-55'!X11:X13)","v":0},null,null,{"$f":"H18","v":0}]
["Quarter 2",{"$nulls":4},{"$f":"SUM('GA-55'!N14+'GA-55'!N15+'GA-55'!N16+'GA-55'!N24)","v":183785},null,{"$f":"SUM('GA-55'!X14:X16)","v":0},null,null,{"$f":"H19","v":0}]
["Quarter 3",{"$nulls":4},{"$f":"SUM('GA-55'!N17+'GA-55'!N18+'GA-55'!N19+'GA-55'!N26)","v":200679},null,{"$f":"SUM('GA-55'!X17:X19)","v":0},null,null,{"$f":"H20","v":0}]
["Quarter 4",{"$nulls":4},{"$f":"SUM('GA-55'!N20+'GA-55'!N21+'GA-55'!N22+'GA-55'!N23+'GA-55'!N25+'GA-55'!N27+'GA-55'!N228+'GA-55'!N29+'GA-55'!N30+'GA-55'!N31)","v":225869},null,{"$f":"SUM('GA-55'!X20:X31)","v":0},null,null,{"$f":"H21","v":0}]
["Total",{"$nulls":4},{"$f":"SUM(F18:F21)","v":779458},null,{"$f":"SUM(H18:H21)","v":0},null,null,{"$f":"SUM(K18:K21)","v":0}]
["I.DETAILS TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT THROUGH BOOK ADJUSTMENT"]
["S.No","Tax Deposited In Respect",null,null,"Book Identification Number (BIN)"]
[null,"of the deducter",null,null,"Receipt Numbers of",null,"DDO Serial No in",null,"Date Of Transfer",null,"Status of Maching"]
[null,null,"(Rs)",null,"Form No.24G",null,"Form No.24G",null,"Form No.24G",null,"with Form.No 24G"]
[{"$nulls":8},"(dd/mm/yyyy)"]
[1,{"$f":"'GA-55'!X11","v":0}]
[2,{"$f":"'GA-55'!X12","v":0}]
[3,{"$f":"'GA-55'!X13","v":0}]
[4,{"$f":"'GA-55'!X14","v":0}]
[5,{"$f":"'GA-55'!X15","v":0}]
[6,{"$f":"'GA-55'!X16","v":0}]
[7,{"$f":"'GA-55'!X17","v":0}]
[8,{"$f":"'GA-55'!X18","v":0}]
[9,{"$f":"'GA-55'!X19","v":0}]
[10,{"$f":"'GA-55'!X20","v":0}]
[11,{"$f":"'GA-55'!X21","v":0}]
[12,{"$f":"'GA-55'!X22","v":0}]
[13,{"$f":"SUM('GA-55'!X23+'GA-55'!X24+'GA-55'!X25+'GA-55'!X26+'GA-55'!X27+'GA-55'!X28+'GA-55'!X29+'GA-55'!X30+'GA-55'!X31)","v":0}]
["Total (Rs)",{"$f":"SUM(B28:B40)","v":0}]
[]
["II.DETAILS TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT THROUGH BOOK CHALLANA"]
["S.No","Tax Deposited In Respect",null,null,"Book Identification Number (CIN)"]
[null,"of the deducter",null,null,"BRS Code of  the ",null,"Date on Which",null,"Challana Serial",null,"Status of Maching"]
[null,null,"(Rs)",null,"Bank Branch",null,"Tax Deposited",null,"Number",null,"with Form.No 24G"]
[{"$nulls":6},"(dd/mm/yyyy)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
["Total (Rs)",{"$f":"SUM(B48:D59)","v":0}]
["Verification"]
["I,",{"$f":"A7","v":"HANUMAN SAHAY"},null,null,"Son/Doughter of ",null,{"$f":"'Basic Profile'!O4","v":"GULLA RAM"},null,null,"  Working In the Capacity Of"]
[{"$f":"A8","v":"PRINCIPAL"},null,null,"(Designation) do hereby certify that a sum  of Rs.",{"$nulls":4},{"$f":"H22","v":0},"(in words)"]
[{"$f":"SpellNumber(I64)","v":0},{"$nulls":4},"has beeen deducted at source and paid to the credit of the Central Government."]
[" I further certify that the information given  above is true and correct based on the book of accounts, documents and TDS Statements, TDS Deposited and other available records."]
[]
["Notes :"]
["1.  Government deductors to fill information in item I if tax is paid without production of an income-tax challan and in item II if tax ."]
["        is paid accompanied by an income-tax challan"]
["2.  Non-Government deductors to fill information in item II."]
["3.  The deductor shall furnish the address of  the Commissioner of  Income-tax (TDS) having jurisdiction as regards TDS "]
["     statements of the assessee."]
["4.  If an assessee is employed under one employer only during the year, certificate in Form No. 16 issued for the quarter ending on"]
["      31st March of the financial year shall contain the details of tax deducted and deposited for all the quarters of the financial year."]
["5.  If  an  assessee  is  employed  under  more  than  one  employer  during  the  year,  each  of  the employers shall issue Part "]
["      A of the certificate in Form No. 16 pertaining to the period for which such assessee was employed with each of the employers."]
["    Part B (Annexure) of the certificate in Form No.16 may be issued by each of the employers or the last employer at the"]
["    option of the assessee."]
["6.  In items I and II, in column for tax deposited in respect of deductee, furnish total amount of TDS and education cess.\""]
[]
["Part B"]
["DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
["1. Gross Salary *"]
[null,"( a ) Salary as per provisions contained in section 17 (1)",{"$nulls":6},{"$f":"'Tax Old Regime'!Q4","v":849302}]
[null,"( b ) Value of perquisites under section 17 (2)"]
[null,"        (as per Form No. 12 BA, wherever applicable)"]
[null,"( c ) Profits in lieu of Salary under section 17 (3)"]
[null,"        (as per Form No. 12 BA, wherever applicable)"]
[null,"( d ) Total",{"$nulls":7},{"$f":"I85+I86+I87+I88+I89","v":849302}]
[]
["2. Less : Allowance to the extent exempt under section 10"]
["a)HRA",{"$nulls":7},{"$f":"'Tax Old Regime'!Q5","v":0}]
["b)Other"]
["3. Balance (1-2)",{"$nulls":8},{"$f":"J90-I93-I94","v":849302}]
[]
["4. Deductions :          "]
[null,"(a) Standard deduction",{"$nulls":3},"Rs.",50000]
[null,"(b) Entertainment allowance",{"$nulls":3},"Rs.",0]
[null,"(c) Tax on Employment",{"$nulls":3},"Rs.",0]
["5. Aggregate of 4 (a to c)",{"$nulls":7},50000]
[]
["6. Income chargeable under the Head ‘Salaries’(3-5)",{"$nulls":10},{"$f":"IF(AND((J95>50000)),(J95-I101),0)","v":799302}]
[]
["7. Add. : Any other income reported by the employee"]
[null,"Less:-  Loss From House Properties",{"$nulls":9},{"$f":"'Other Deduction'!B9","v":0}]
[]
["8. Gross total income  (6+7)",{"$nulls":10},{"$f":"L103+L105-L106","v":799302}]
[{"$nulls":6},"Gross Amount",null,"Qualifying Amt.",null,"Deductible Amt."]
["9. Deductions Under Chapter VIA    "]
["A.","Sections 80C,80CC and 80CCD1"]
["(a)","Section 80C"]
[null,"(i)","GPF/NPS ",null,null,"Rs.",{"$f":"'GA-55'!O32","v":69844},null,{"$f":"G113","v":69844},null,{"$f":"I113","v":69844}]
[null,"(ii)","STATE INSURANCE",null,null,"Rs.",{"$f":"'GA-55'!Q32","v":36000},null,36000,null,36000]
[null,"(iii)","LIC",null,null,"Rs.",{"$f":"'GA-55'!T32+'Other Deduction'!B10","v":0},null,0,null,0]
[null,"(iv)","Group Ins.",null,null,"Rs.",{"$f":"'GA-55'!U32","v":220},null,220,null,220]
[null,"(v)","GPF 2004",null,null,"Rs.",{"$f":"'Tax Old Regime'!I29","v":7152},null,7152,null,7152]
[null,"(vi)","House Loan Installment",null,null,"Rs.",{"$f":"'Tax Old Regime'!I28","v":0},null,0,null,0]
[null,"(vii)","Others",null,null,"Rs.",{"$f":"'Tax Old Regime'!I22+'Tax Old Regime'!I23+'Tax Old Regime'!I24+'Tax Old Regime'!I27+'Tax Old Regime'!O21+'Tax Old Regime'!O22+'Tax Old Regime'!O23+'Tax Old Regime'!O24+'Tax Old Regime'!O25+'Tax Old Regime'!O26+'Tax Old Regime'!O27+'Tax Old Regime'!O28+'Tax Old Regime'!O29","v":0},null,0,null,0]
["(b)","Section 80CCC",{"$nulls":3},"Rs.",0,null,0,null,0]
["(c)","Section 80CCD",{"$nulls":3},"Rs.",0,null,0,null,0]
["Aggregate amount deductible under the three sections ",{"$nulls":5},{"$f":"SUM(G113:G121)","v":113216},null,{"$f":"SUM(I113:I121)","v":113216},null,{"$f":"IF(SUM(K113:L119)>150000,150000,SUM(K113:L119))","v":113216}]
["i.e.80C, 80CCC and 80CCD"]
[]
["(d)","Section 80CCD2",{"$nulls":3},"Rs.",{"$f":"IF('GA-55'!Z2=\"Yes\",'GA-55'!O32,0)","v":0},null,{"$f":"G125","v":0},null,{"$f":"I125","v":0}]
["(e)","Section 80CCD (1B)",{"$nulls":3},"Rs.",{"$f":"'Tax Old Regime'!Q33","v":0},null,{"$f":"G126","v":0},null,{"$f":"I126","v":0}]
[]
["B.","Other Sections ( e.g. 80E, 80G, 80TTA etc) Under Chapter VIA"]
[{"$nulls":6},"Gross Amount",null,"Qualifying Amt.",null,"Deductible Amt."]
[null,"(i)","vU; dVkSfr;ka",null,null,"Rs.",{"$f":"SUM('Tax Old Regime'!Q36:Q43)","v":0},null,{"$f":"G130","v":0},null,{"$f":"I130","v":0}]
[null,"(ii)",{"$nulls":3},"Rs.",null,null,{"$f":"G131","v":0},null,{"$f":"I131","v":0}]
[null,"(iii)",{"$nulls":3},"Rs.",null,null,{"$f":"G132","v":0},null,{"$f":"I132","v":0}]
["10. Aggregate of deductible amount under chapter VI-A",{"$nulls":9},{"$f":"K122+K125+K126+K130+K131+K132","v":113216},0]
[]
["11. Total Income (8-10 )",{"$nulls":9},{"$f":"'Tax Old Regime'!Q47","v":616240}]
[]
["12. Tax on Total Income ",{"$nulls":9},{"$f":"'Tax Old Regime'!Q54","v":35748}]
["13. Rebate U/S 87a",{"$nulls":9},{"$f":"'Tax Old Regime'!Q55","v":0}]
["14. Tax Payable on total income (12-13)",{"$nulls":9},{"$f":"K137-K138","v":35748}]
["15.Education & Health Cess 4%",{"$nulls":9},{"$f":"'Tax Old Regime'!Q57","v":1430}]
["16. Tax payable (14+15)",{"$nulls":9},{"$f":"'Tax Old Regime'!Q58","v":37178}]
["17. Relife Under Section 89 (attach details)",{"$nulls":9},{"$f":"'Tax Old Regime'!Q59","v":0}]
["18. Tax payable (16-17)",{"$nulls":9},{"$f":"'Tax Old Regime'!Q60","v":37178}]
["19.Tax Deducted at source U/S 192"]
["20. Tax payable / refundable (17-18)",{"$nulls":9},{"$f":"'Tax Old Regime'!Q63","v":37178}]
["Verification"]
["I,",{"$f":"A7","v":"HANUMAN SAHAY"},null,null,"Son/Doughter of ",null,{"$f":"G63","v":"GULLA RAM"},null,null,"  Working In the Capacity Of"]
[{"$f":"A8","v":"PRINCIPAL"},null,null,"(Designation) do hereby certify that the information given  above is true  correct based on the "]
["book of accounts, documents and TDS Statements, TDS Deposited and other available records."]
[]
[]
[]
[]
[{"$nulls":5},"                                    Signature & Seal"]
[]
["Place:",{"$nulls":4},"Full Name  ",null,{"$f":"'Basic Profile'!#REF!","v":{"$error":"#REF!"}}]
["Date:",{"$nulls":4},"Designation",null,{"$f":"'Basic Profile'!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"HRA Receipt","index":6,"n_rows":24,"n_cols":9,"rows_kept":24,"merged":[[0,0,0,9],[1,0,2,9],[6,2,6,9],[7,2,7,5],[7,6,7,9],[8,2,8,9],[9,4,9,9],[10,1,10,3],[10,5,10,9],[11,1,11,2],[11,3,11,5],[13,2,13,3],[15,2,15,3],[17,7,17,9],[18,7,18,9],[19,8,19,9],[20,7,20,9],[21,7,22,9],[23,7,23,8]]}
["RECEIPT OF HOUSE RENT"]
["(Under section 1 (13-A) of Income Tax Act)"]
[]
[]
[{"$nulls":8},"Date :-"]
[]
[null,"I Owner "]
[null,null,"Received with Thanks from Sri/Smt. ",{"$nulls":3},"---------------------------------------------------------------------------------------------"]
[null,"Address-","---------------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"The sum of ","Rs.="]
[null,"Towards the House Rent @  Rs. ="]
[null,"Per Month From :-",null,"April 2020 To March 2021"]
[]
[null,"Rs.  =  "]
[]
[null,"Date:-",{"$f":"J5","v":"00:00:00"}]
[]
[{"$nulls":7},"(Signature of House Owner)"]
[{"$nulls":7},"(Affix Revenue Stamp of Rs.1/-) \n"]
[{"$nulls":7},"Name-"]
[{"$nulls":7},"ADDRESS"]
[]
[]
[{"$nulls":7},"PAN NUMBER"]