{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Profile","Salary","IT calculation","us(89)1 Form","form10E","control10E","Form 16","control"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":6,"comments":1,"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":"Profile","index":0,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,12,2,21],[3,12,3,21],[5,14,5,17],[5,12,5,13],[4,12,4,14],[11,14,12,17],[9,14,9,17],[8,14,8,17],[7,0,7,5],[7,6,7,11],[16,0,16,1],[16,3,16,4],[16,6,16,7],[9,9,9,10],[10,0,10,1],[10,2,10,3],[9,0,9,1],[9,2,9,3],[9,4,9,7],[12,6,12,7],[10,8,10,10],[11,0,11,11],[10,4,10,5],[10,6,10,7],[12,0,12,3],[12,4,12,5],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,1],[3,2,3,5],[3,8,3,11],[3,6,3,7],[27,0,27,1],[17,0,17,1],[17,3,17,4],[17,6,17,7],[22,0,22,11],[25,0,25,1],[26,0,26,1],[18,3,18,4],[18,6,18,7],[19,0,19,1],[18,0,18,1],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[5,2,5,5],[6,0,6,1],[15,0,15,1],[15,3,15,4],[15,6,15,7],[8,0,8,11],[5,8,5,9],[6,8,6,9],[15,9,15,10],[6,2,6,5],[28,10,28,11],[28,0,28,2],[4,6,4,7],[1,14,1,17],[13,0,13,11],[14,0,14,1],[14,3,14,4],[14,6,14,7],[14,9,14,10],[5,6,5,7],[6,6,6,7],[4,8,4,11],[12,9,12,10],[4,0,4,1],[4,2,4,5],[5,0,5,1],[14,12,14,14],[14,15,14,17],[25,10,26,11],[27,3,27,5],[27,8,27,10],[27,6,27,7],[16,9,16,10],[25,8,26,8],[25,9,26,9],[18,9,18,10],[17,9,17,10],[19,3,19,4],[19,6,19,7],[19,9,19,10]]}
["vk;dj x.kuk izi= ys[kk o\"kZ 2021&22 dj fu/kkZj.k o\"kZ 2022&23"]
["Developed by kailash chandra sharma,Teacher L-1,GSSS-JEEWANA,Block-masuda                                                                                                       Dist.AJMER(Rajsthan)"]
["lkekU; tkudkjh",null,null,null,null,null,null,null,null,null,null,null,"Prog. Dev. By- KAILASH CHANDRA SHARMA, Contact:-klsharma1971@gmail.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,3]
["NAME",null,"KAILASH CHANDRA SHARMA",null,null,null,"BANK NAME",null,"BOB  BIJAINAGAR",null,null,null,"DOWNLOAD FROM MY WEB.http://ctorone.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4]
["DESGNATION",null,"TEACHER",null,null,null,"Bank Ac.No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPS",3,5]
["OFFICE NAME",null,"GSSS JEEWANA",null,null,null,"Tax Deductor Name",null,null,null,"PAN",null,null,null,"NPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GPF",4,6]
["PAN NUMBER",null,"BBWPK1528D",null,null,null,"Father's Name",null,null,null,"TAN",null,null,null,null,null,null,null,1,1,null,null,null,null,null,null,"REGULAR",null,null,null,null,null,"YES",5,7]
["TAX DEDUCTOR'S DESIGNATION"]
["INFORMATION ABOUT SALARY AND ALLOWANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,"CATEGORY OF EMPLOYEE",null,null,null,null,2,null,null,null,null,null,null,"RETIREMENT",null,null,null,null,null,"NO",6,8]
["SALARY IN MARCH 2021",null,36900,null,"ewy osru es dksbZ ifjorZu&ekg dk dzekad ns a¼tqykbZ dh osruo`f} ds vykok½",null,null,null,null,"fn;k x;k osru",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,9]
["PL Hkqxrku ysus okys ekg dk dzekad pqusA ugh fy;k rks [kkyh NksMsaA",null,null,null,"BONUS TAKEN          YES/NO",null,"YES",null,"fdrus ekg ds fy, cksul feyk",null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,10]
["OTHER INCOME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,11]
["INCOME OF HOUSE PROPERTY",null,null,null,null,null,"INTEREST OF FD",null,null,"OTHER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,12]
["INVESTMENTS VI A   ds vUrxZr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,1]
["REBATE US 89(1)",null,null,"LIC PREMIUM Direct",null,null,"LIC FROM Salary",null,null,"PLI",null,null,"D;k vkidks osru ihMh gsM ls feyrk gS ? GPF dkfeZd dks NO j[kuk gSA",null,null,"NO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,2,null,"YES"]
["US 80 CCD",null,null,"TUITION FEE:               2 CHILDREN",null,null,"HOUSE LOAN INTEREST",null,null,"HOME LOAN CAPITAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
["US 80 D",null,null,"US 80 E",null,null,"US 80 G",null,null,"US 80 CCD(1)B"]
["US 80 DD",null,null,"jk\"V~h; cpr i=",null,null,"lqdU;k le`f) ;kstuk",null,null,"US 80 CCC"]
["lkeqfgd nq?kZVuk chek",null,2100,"GPF 2004 dh jkf'k Hkjsa",null,null,"US 80 U",null,null,"US 80  TTA"]
["ULIP",null,null,"PPF",null,null,"BOND OF NABAED",null,null,"jk\"V~h; cpr i= ij vnRr C;kt"]
["MARCH","APRIL","MAY","JUNE","JULY","AUG","SEP","OCT","NOV","DEC","JAN","FEB"]
[]
["TAX DEDUCTED AT SOURCE"]
["MARCH","APRIL","MAY","JUNE","JULY","AUG","SEP","OCT","NOV","DEC","JAN","FEB"]
[0,0,0,0,0,0,0,0,0]
["AREAR 1 TDS",null,0,"QUARTER 1st",null,"QUARTER 2nd",null,"QUARTER 3rd",null,"QUARTER 4th"]
["AREAR  2 TDS",null,0]
["AREAR 3 TDS",null,0,"INCOME TAX BEFORE TDS",null,null,{"$f":"A25+B25+C25+D25+E25+F25+G25+H25+I25+J25+K25+L25+C26+C27+C28","v":0},null,"INCOME TAX AFTER TDS",null,null,{"$f":"AE28-G28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'IT calculation'!E47","v":0}]
["Receipt Numbers of Original statements of TDS under sub-section (3) of section 200",null,null,"QUARTER 1st",null,"QUARTER 2nd",null,"QUARTER 3rd",null,"QUARTER 4th"]

{"sheet":"Salary","index":1,"n_rows":36,"n_cols":27,"rows_kept":36,"cut":false,"hidden":false,"merged":[[26,0,26,11],[26,13,26,17],[26,21,26,26],[0,0,0,26],[1,0,1,6],[2,0,3,0],[2,1,3,1],[2,2,2,10],[2,11,2,23],[2,24,3,24],[2,25,3,25],[1,7,1,13],[1,14,1,25],[2,26,3,26],[32,0,32,24],[33,0,33,24],[34,0,34,24],[35,0,35,24],[28,10,30,19]]}
["osru o dVkSfr;ksa dk fooj.k 2021 & 2022"]
[{"$f":"Profile!C4","v":"KAILASH CHANDRA SHARMA"},null,null,null,null,null,null,{"$f":"Profile!C5","v":"TEACHER"},null,null,null,null,null,null,{"$f":"Profile!C6","v":"GSSS JEEWANA"}]
["dz- la-","ekg","osru tks fn;k x;k",null,null,null,null,null,null,null,null,"dVkSfr;ka tks dh x;h",null,null,null,null,null,null,null,null,null,null,null,null," 'kq} Hkqxrku dh x;h jkf'k","Vªstjh ckmpj ua-","Hkqxrku fn-"]
[null,null,"jfuax is cS.M o xzsM is"," Mh ,","HRA"," 'kgjh {friwfrZ HkÙkk","cksul","Govt.NPS","vU;","vU;",";ksx",{"$f":"Profile!O6","v":"NPS"},"th ih ,Q _.k","jkT; chek","dksjksuk fjyhQ Q.M","jkT; chek _.k","RGHS","L I C","GPF 2004","fgrdkjh fuf/k","Govt.NPS","vk; dj","lk nq ch",";ksx"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27]
[1,"ekpZ&21",{"$f":"control!D4","v":36900},{"$f":"control!E4","v":6273},{"$f":"control!G4","v":2952},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T4,0)","v":0},null,null,{"$f":"SUM(C6:J6)","v":46125},{"$f":"control!T4","v":4317},null,{"$f":"control!J4","v":2200},null,null,{"$f":"control!N4","v":0},{"$f":"Profile!I15","v":0},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T4,0)","v":0},{"$f":"control!B17","v":0},null,{"$f":"SUM(L6:W6)","v":6517},{"$f":"K6-X6","v":39608}]
[2,"vizsy&21",{"$f":"control!D5","v":36900},{"$f":"control!E5","v":6273},{"$f":"control!G5","v":2952},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T5,0)","v":0},null,null,{"$f":"SUM(C7:J7)","v":46125},{"$f":"control!T5","v":4317},null,{"$f":"control!J5","v":2200},null,null,{"$f":"control!N5","v":0},{"$f":"R6","v":0},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T5,0)","v":0},{"$f":"control!C17","v":0},{"$f":"Profile!C19","v":2100},{"$f":"SUM(L7:W7)","v":8617},{"$f":"K7-X7","v":37508}]
[3,"ebZ&21",{"$f":"control!D6","v":36900},{"$f":"control!E6","v":6273},{"$f":"control!G6","v":2952},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T6,0)","v":0},null,null,46125,{"$f":"control!T6","v":4317},null,{"$f":"control!J6","v":2200},null,null,{"$f":"control!N6","v":0},0,null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T6,0)","v":0},{"$f":"control!D17","v":0},null,6517,39608]
[4,"twu&21",{"$f":"control!D7","v":36900},{"$f":"control!E7","v":6273},{"$f":"control!G7","v":2952},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T7,0)","v":0},null,null,46125,{"$f":"control!T7","v":4317},null,{"$f":"control!J7","v":2200},null,null,{"$f":"control!N7","v":0},0,null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T7,0)","v":0},{"$f":"control!E17","v":0},null,6517,39608]
[5,"tqyk-&21",{"$f":"control!D8","v":38000},{"$f":"control!E8","v":10640},{"$f":"control!G8","v":3040},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T8,0)","v":0},null,null,51680,{"$f":"control!T8","v":4864},null,{"$f":"control!J8","v":2200},null,null,{"$f":"control!N8","v":0},0,null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T8,0)","v":0},{"$f":"control!F17","v":0},null,7064,44616]
[6,"vx-&21",{"$f":"control!D9","v":38000},{"$f":"control!E9","v":10640},{"$f":"control!G9","v":3420},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T9,0)","v":0},null,null,52060,{"$f":"control!T9","v":4864},null,{"$f":"control!J9","v":2200},null,null,{"$f":"control!N9","v":0},0,null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T9,0)","v":0},{"$f":"control!G17","v":0},null,7064,44996]
[7,"flr-&21",{"$f":"control!D10","v":38000},{"$f":"control!E10","v":10640},{"$f":"control!G10","v":3420},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T10,0)","v":0},null,null,52060,{"$f":"control!T10","v":4864},null,{"$f":"control!J10","v":2200},null,null,{"$f":"control!N10","v":0},0,null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T10,0)","v":0},{"$f":"control!H17","v":0},null,7064,44996]
[8,"vDVw-&21",{"$f":"control!D11","v":38000},{"$f":"control!E11","v":11780},{"$f":"control!G11","v":3420},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T11,0)","v":0},null,null,53200,{"$f":"control!T11","v":4978},null,{"$f":"control!J11","v":2200},null,null,{"$f":"control!N11","v":0},0,null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T11,0)","v":0},{"$f":"control!I17","v":0},null,7178,46022]
[9,"uc-&21",{"$f":"control!D12","v":38000},{"$f":"control!E12","v":11780},{"$f":"control!G12","v":3420},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T12,0)","v":0},null,null,53200,{"$f":"control!T12","v":4978},null,{"$f":"control!J12","v":2200},null,null,{"$f":"control!N12","v":0},0,null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T12,0)","v":0},{"$f":"control!J17","v":0},null,7178,46022]
[10,"fnl-&21",{"$f":"control!D13","v":38000},{"$f":"control!E13","v":11780},{"$f":"control!G13","v":3420},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T13,0)","v":0},null,null,53200,{"$f":"control!T13","v":4978},null,{"$f":"control!J13","v":2200},null,null,{"$f":"control!N13","v":0},0,null,{"$f":"control!P3","v":250},{"$f":"IF(Profile!$P$15=\"YES\",control!T13,0)","v":0},{"$f":"control!K17","v":0},null,7428,45772]
[11,"tu-&22",{"$f":"control!D14","v":38000},{"$f":"control!E14","v":11780},{"$f":"control!G14","v":3420},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T14,0)","v":0},null,null,53200,{"$f":"control!T14","v":4978},null,{"$f":"control!J14","v":2200},null,null,{"$f":"control!N14","v":0},0,null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T14,0)","v":0},{"$f":"control!L17","v":0},null,7178,46022]
[12,"Qj-&22",{"$f":"control!D15","v":38000},{"$f":"control!E15","v":11780},{"$f":"control!G15","v":3420},null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T15,0)","v":0},null,null,53200,{"$f":"control!T15","v":4978},null,{"$f":"control!J15","v":2200},null,null,{"$f":"control!N15","v":0},0,null,null,{"$f":"IF(Profile!$P$15=\"YES\",control!T15,0)","v":0},{"$f":"control!M17","v":0},null,7178,46022]
[13,"HRA,fj",null,null,{"$f":"control!J22","v":380},null,null,null,null,null,{"$f":"SUM(C18:J18)","v":380},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(L18:W18)","v":0},380]
[14,"Mh , ,fj",null,{"$f":"control!N22","v":3420},null,null,null,0,null,null,{"$f":"SUM(C19:J19)","v":3420},{"$f":"IF(Profile!O6=\"NPS\",ROUND((K19)*10%,0),IF(Profile!O6=\"GPF\",0))","v":342},null,null,null,null,null,null,{"$f":"IF(Profile!O6=\"NPS\",(K19-L19),0)","v":3078},null,null,null,null,{"$f":"SUM(L19:W19)","v":3420},0]
[15,"le- vo-",{"$f":"control!AE4","v":0},{"$f":"control!AF4","v":0},null,null,null,null,null,null,{"$f":"SUM(C20:J20)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"K20-X20","v":0}]
[16,"cksul",null,null,null,null,{"$f":"control!V5","v":6774},null,null,null,{"$f":"SUM(C21:J21)","v":6774},{"$f":"IF(Profile!O6=\"GPF\",K21/2,0)","v":0},null,null,null,null,null,null,{"$f":"IF(Profile!O6=\"NPS\",K21/2,0)","v":3387},null,null,null,null,3387,{"$f":"K21-X21","v":3387}]
[17,"ekpZ&20",0,0,0,0,0,0,0,0,{"$f":"SUM(C22:J22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(L22:W22)","v":0},{"$f":"K22-X22","v":0}]
[18,"fQDls ,fj",null,null,null,null,null,null,null,null,{"$f":"SUM(C23:J23)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L23:W23)","v":0},{"$f":"K23-X23","v":0}]
[19,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[20,";ksx",{"$f":"SUM(C6:C24)","v":451600},{"$f":"SUM(D6:D24)","v":119332},39168,0,6774,0,0,0,616874,57092,0,26400,0,0,0,0,6465,250,0,0,2100,92307,524567]
[]
["Prog. Dev. By- KAILASH CHANDRA SHARMA, Contact:-klsharma1971@gmail.com",null,null,null,null,null,null,null,null,null,null,null,null,"gLrk{kj deZpkjh ",null,null,null,null,null,null,null,"gLrk{kj vkgj.k o forj.k vf/kdkjh"]
[]
[]
[]
[]
[]
["HOW TO USE"]
["1- izksQkby 'khV ij okafNr fooj.k ;fn Hkj fy;k gS rks LVs.MMZ lSysjh 'khV tujsV djus ds fy, Åij fn;s x;s cVu 'Generate Salary Sheet' dks nckb;sA"]
["2. LVS.MMZ lSysjh 'khV izkIr djus ds Ik'pkr vki viuh O;fDrxr vko';drkvksa ds vuqlkj bles Modifications dj ldrs gSAtSls GPF o SI dh dVkSfr;ksa dk change dj ldrs gSAfdUrq /;ku jgs vkids }kjk ;fn bl 'khV ij dksbZ Hkh iforZu fd;k gS rks vc iqu% 'khV ij ekStwn cVu 'Generate Salary Sheet' dks ugha nck,a vU;Fkk vki }kjk fd, x, 'Modifications' lekIr gks tk,axsAftu dkWye o jkW ds ysoy dk dyj xzhu gS vki muds ysoy vko';drk gksus ij change dj ldrs gSA"]
["3- iqu% u, O;fDr ds fy, LVS.MMZ lSysjh 'khV tujsV djus ds fy, izksQkby ij fooj.k Hkjsa ,oa 'khV ij ekStwn cVu Generate Salary Sheet ' dks nck,aA fizaV dek.M nsus ls igys fizaV O;w vo'; ns[ksa- ,oa mlh ist dks fizaV djsa ftldh vkidks vko'krk gSA"]

{"sheet":"IT calculation","index":2,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[11,8,16,10],[11,7,16,7],[18,7,21,10],[6,7,6,10],[9,7,9,10],[4,0,4,2],[0,0,0,4],[2,1,2,2],[2,3,2,4],[3,1,3,2],[1,3,1,4],[1,0,1,1],[20,0,20,1],[5,0,5,2],[7,0,7,1],[7,4,8,4],[10,0,10,4],[13,0,13,3],[14,0,14,4],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[32,0,32,3],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,3],[25,0,25,1],[26,0,26,4],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[31,0,31,3],[45,0,45,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,3],[39,0,39,3],[42,0,42,1],[42,2,42,3],[43,0,43,2],[44,0,44,3],[46,0,46,3],[47,0,47,4],[54,0,54,3],[55,0,55,3],[56,0,56,3]]}
["vk;dj x.kuk i= ys[kk o\"kZ 2021&2022 dj fu/kkZj.k o\"kZ 2022&2023"]
[{"$f":"Profile!C4","v":"KAILASH CHANDRA SHARMA"},null,{"$f":"Profile!C5","v":"TEACHER"},{"$f":"Profile!C6","v":"GSSS JEEWANA"}]
[{"$f":"CONCATENATE(\"PAN:-   \",Profile!C7)","v":"PAN:-   BBWPK1528D"},{"$f":"CONCATENATE(\"Bank Ac.No.:-\",Profile!I5)","v":"Bank Ac.No.:-"},null,{"$f":"CONCATENATE(\"Name of Bank:-\",Profile!I4)","v":"Name of Bank:-BOB  BIJAINAGAR"}]
["1- osru en esa vk; ¼HkÙkksa lfgr½","(+ Govt. Contri. towards NPS)",null,null,{"$f":"IF(Profile!P15=\"YES\",(Salary!K25),IF(Profile!O6=\"NPS\",(Salary!K25+Salary!L25),Salary!K25))","v":673966}]
[";fn osru 150000 ls vf/kd gS rks /kkjk 17¼2½ ds varxZr izkIr lqfo/kk,a",null,null,0,{"$f":"E4+D5","v":673966}]
["LVs.MMZ fMMD'ku ",null,null,{"$f":"IF(control!S31=1,0,50000)","v":50000},{"$f":"IF(E5>D6,E5-D6,0)","v":623966}]
["?kVkb;s& dVkSfr;ka US10 (13 A)","0","US10 ",0,{"$f":"E6-(B7+D7)","v":623966}]
["2- ¼1½ v/;k; IV C ds varxr vk;% ¼1½ Lo;a ds mi;ksx esa 'kwU; ",null,"¼2½ izkIr fdjk;k",0]
["¼1½ x`gdj","(2) Standard Deduction","¼3½ _.k ij C;kt","¼4½ izkIr fdjk;k&¼;ksx 1 ls 3½"]
[0,0,{"$f":"Profile!I16","v":0},{"$f":"D8-(A10+B10+C10)","v":0},{"$f":"E7+IF(AND(D10<0,ABS(D10)>200000),\"-200000\",D10)","v":623966}]
["3- vU; óksrksa ls vk;%"]
["NSC ij C;kt","FDR ls C;kt","Bonds ls C;kt","cpr [kkrs ij C;kt","vU; vk;",null,null,null,"u, vFkok iqjkus VSDl flLVe dk p;u djs"]
[{"$f":"Profile!L13","v":0},{"$f":"Profile!I13","v":0},{"$f":"A13","v":0},{"$f":"E13","v":0},0]
["ldy dqy vk; ",null,null,null,{"$f":"E10+A13+B13+C13+D13+E13","v":623966}]
["v/;k; VI A ds vUrxZr dVkSfr;ka "]
[{"$f":"IF(Profile!O6=\"NPS\",\"GPF 2004\",\"GPF\")","v":"GPF 2004"},null,{"$f":"IF(control!S31=1,0,IF(Profile!O6=\"NPS\",Salary!S25,Salary!L25))","v":6465},"US 80CCD(1)",{"$f":"IF(Profile!O6=\"NPS\",Salary!L25,0)","v":57092}]
["S I",null,{"$f":"IF(control!S31=1,0,Salary!N25)","v":26400},"Tuition fee: 2 children",{"$f":"IF(control!S31=1,0,control!O9)","v":0}]
["LIC",null,{"$f":"IF(control!S31=1,0,control!K20)","v":0},"jk\"Vªh; cpr i= ",{"$f":"IF(control!S31=1,0,Profile!F18)","v":0}]
["Gr. Acc. Ins.",null,{"$f":"IF(control!S31=1,0,control!O3)","v":2100},"jk\"Vªh; cpr i= ij vnÙk C;kt",{"$f":"IF(control!S31=1,0,control!O10)","v":0},null,null,"xzhu dyj lsYl dks vko';drk gks rks esU;qvyh Hkj ys"]
["ULIP",null,{"$f":"IF(control!S31=1,0,control!O4)","v":0},"bfDoVh fyad lsfoax Ldhe",0]
["Hkou _.k iquHkqZxrku ",null,{"$f":"IF(control!S31=1,0,control!O5)","v":0},"LFkfxr okf\"kZdh",0]
["PPF",null,{"$f":"IF(control!S31=1,0,control!O6)","v":0},"LFkkbZ tek 5 o\"kZ",0]
["PLI",null,{"$f":"IF(control!S31=1,0,control!O7)","v":0},"lqdU;k le`f) ;kstuk",{"$f":"IF(control!S31=1,0,Profile!I18)","v":0}]
["NOTIFIED BOND OF NABARD",null,{"$f":"IF(control!S31=1,0,control!O8)","v":0},"US 80CCC",{"$f":"IF(control!S31=1,0,Profile!L18)","v":0}]
[{"$f":"CONCATENATE(\"TOTAL\",IF(control!S31=1,\"(excluding govt.contri. To NPS)\",\"\"))","v":"TOTAL"},null,null,null,{"$f":"C16+C17+C18+C19+C20+C21+C22+C23+E16+E17+E18+E19+E20+E21+E22+E23","v":92057}]
["Qualifying Amount US80CCE (Max Rs 150000/)",null,{"$f":"IF(control!S31=1,\"+US 80CCD(2)\",\"\")","v":""},{"$f":"CONCATENATE(IF(Profile!O6=\"NPS\",\"Rs.\",\"\"),IF(Profile!O6=\"NPS\",E16,\"\"))","v":"Rs.57092"},{"$f":"IF(E25<=150000,E25,150000)+IF(Profile!O6=\"NPS\",Salary!L25,\"0\")","v":149149}]
["vU; dVkSfr;ka "]
["US 80 EEA Max Rs 150000/",null,null,null,0]
["US 80D",null,null,null,{"$f":"Profile!C17","v":0}]
["US 80DD",null,null,null,{"$f":"Profile!C18","v":0}]
["US 80DDB  (Patient suffering from Cancer, AIDS, Chronical renal failure, Thalassaemia etc.)",null,null,null,0]
["US 80 E",null,null,null,{"$f":"Profile!F17","v":0}]
["US 80G",null,null,null,{"$f":"Profile!I17","v":0}]
["US 80GG ¼Hkqxrku fd, x, Hkou fdjk;s ds ckjs es dVkSrh] vf/kdre # 5000 rd½",null,null,null,0]
["US 80EE  ¼izFke vkoklh; ?kj gsrq fy, x, yksu ij C;kt dh vfrfjDr NwV] vf/kdre # 50000 rd½",null,null,null,0]
["US 80U",null,null,null,{"$f":"Profile!I19","v":0}]
["US 80 TTA",null,null,null,{"$f":"Profile!L19","v":0}]
["US 80 CCD (1B)",null,null,null,{"$f":"Profile!L17","v":0}]
["v/;k; VI A ds vUrxZr dqy dVkSfr;ka ",null,null,null,{"$f":"E26+E28+E29+E30+E31+E32+E33+E34+E35+E36+E37+E38","v":149149}]
["'kq) dj ;ksX; vk; ¼iw.kkZad esa½",null,null,null,{"$f":"ROUND((E14-E39),-1)","v":474820}]
["TAX FOR MEN",null,{"$f":"ROUND(IF(E40<=250000,0,IF(E40<=500000,(E40-250000)*0.05,IF(E40<=750000,12500+(E40-500000)*0.1,IF(E40<=1000000,37500+(E40-75000)*0.15,IF(E40<=1250000,75000+(E40-1000000)*0.2,IF(E40<=1500000,125000+(E40-1250000)*0.25,IF(E40>1500000,187500+(E40-1500000)*0.3,\"0\"))))))),0)","v":11241},{"$f":"IF(E40<=500000,C42,C41)","v":0},{"$f":"ROUND(IF(E40<=250000,0,IF(E40<=500000,(E40-250000)*0.05,IF(E40<=1000000,12500+(E40-500000)*0.2,IF(E40>1000000,112500+(E40-1000000)*0.3,\"0\")))),0)","v":11241}]
["Tax Credit, Max Rs 12500/",null,{"$f":"IF(AND(E40<=500000,C41>=12500),C41-12500,IF(AND(E40<=500000,C41<12500),0,C41))","v":0},null,{"$f":"IF(AND(E40<=500000,E41>=12500),E41-12500,IF(AND(E40<=500000,E41<12500),0,E41))","v":0}]
["dqy vk;dj ns;rk",null,"",null,{"$f":"IF(E40<=500000,E42,E41)","v":0}]
["fpfdRlk ,oa f'k{kk midj  4%",null,null,{"$f":"ROUND((E43*0.04),0)","v":0},{"$f":"D44","v":0}]
["dqy vk;dj",null,null,null,{"$f":"SUM(E43:E44)","v":0}]
["REBATE US 89 (1)",null,null,null,{"$f":"Profile!C15","v":0}]
["dqy dj ns;rk",null,null,null,{"$f":"E45-E46","v":0}]
["óksr ij gqbZ dVkSrh"]
["ekpZ 2021",{"$f":"control!B17","v":0},"flrEcj 2021",{"$f":"control!H17","v":0},"fQDls'ku ,fj;j ls VhMh,l"]
["vizsy 2021",{"$f":"control!C17","v":0},"vDVwcj 2021",{"$f":"control!I17","v":0},{"$f":"Profile!C26","v":0}]
["ebZ 2021",{"$f":"control!D17","v":0},"uoEcj 2021",{"$f":"control!J17","v":0},{"$f":"Profile!C27","v":0}]
["twu 2021",{"$f":"control!E17","v":0},"fnlEcj 2021",{"$f":"control!K17","v":0},{"$f":"Profile!C28","v":0}]
["tqykbZ 2021",{"$f":"control!F17","v":0},"tuojh 2022",{"$f":"control!L17","v":0}]
["vxLr 2021",{"$f":"control!G17","v":0},"Qjojh 2022",{"$f":"control!M17","v":0}]
["óksr ij gqbZ dqy dVkSrh",null,null,null,{"$f":"SUM(B49:B54)+SUM(D49:D54)+E50","v":0}]
["'ks\"k dj ns;rk ",null,null,null,{"$f":"IF(E47>E55,E47-E55,\"0\")","v":"0"}]
["dj fjQ.M",null,null,null,{"$f":"IF(E55>E47,E47-E55,\"0\")","v":"0"}]
[]
[]
["Prog. Dev. By:-Kailash chandra sharma, Contact:-klsharma1971@gmail.com",null,null,null,"gLrk{kj deZpkjh"]

{"sheet":"us(89)1 Form","index":3,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[18,0,18,10],[18,11,18,13],[11,16,17,19],[14,11,14,13],[15,0,15,10],[15,11,15,13],[16,0,16,10],[16,11,16,13],[17,0,17,10],[17,11,17,13],[13,0,13,10],[13,11,13,13],[14,0,14,10],[10,0,10,10],[10,11,10,13],[11,0,11,10],[11,11,11,13],[12,0,12,10],[12,11,12,13],[6,0,6,10],[6,11,6,13],[7,0,7,10],[7,11,7,13],[7,16,9,19],[8,0,8,10],[8,11,8,13],[9,0,9,10],[9,11,9,13],[3,0,3,2],[3,3,3,6],[3,7,3,10],[3,11,3,13],[3,16,5,19],[4,0,4,10],[4,11,4,13],[5,0,5,10],[5,11,5,13],[0,0,0,13],[0,16,1,19],[1,0,1,2],[1,3,1,13],[2,0,2,2],[2,3,2,13]]}
["CALCULATION OF RELIEF UNDER SECTION 89 (1)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Male",null,"1- loZizFke vius ,fj;j dks xr foÙkh; o\"kksZa ds vuqlkj foHkkftr djsaA"]
["NAME",null,null,{"$f":"Profile!C4","v":"KAILASH CHANDRA SHARMA"},null,null,null,null,null,null,null,null,null,null,"Female"]
["ADDRESS",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["PAN",null,null,null,null,null,null,"CATEGORY",null,null,null,null,null,null,null,null,"2- vc lEcfU/kr foÙkh; o\"kksZa ds QkWeZ 16 vFkok ITR ls dj ;ksX; vk; dks lEcfU/kr lsYl esa Hkjuk gSA"]
["FINANCIAL YEAR- 2015-16",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )"]
["Enter net taxable income for 2017-18 (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,489520]
["Enter arrears relates to 2017-18",null,null,null,null,null,null,null,null,null,null,0]
["FINANCIAL YEAR- 2016-17",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )",null,null,null,null,"3- dj ;ksX; vk; og vk; gS ftl ij ml foÙkh; o\"kZ esa fu/kkZfjr vk;dj nj ls vk;dj dh x.kuk dh tkrh gSA "]
["Enter net taxable income for 2018-19 (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,53009]
["Enter arrears relates to 2018-19",null,null,null,null,null,null,null,null,null,null,0]
["FINANCIAL YEAR- 2017-18",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )"]
["Enter net taxable income for 2019-20 (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,802296,null,null,null,null,"4- vc bl QkWeZ esa lEcfU/kr foÙkh; o\"kZ  dh dj ;ksX; vk; ,oa ml o\"kZ ls lEcfU/kr ,fj;j dh jkf'k HkjsaA /;ku jgs foÙkh; o\"kZ 2019&20 ds fy, Hkjh x;h dj ;ksX; vk; esa lEiw.kZ ,fj;j dh jkf'k tqMh gksA  izkIr NwV dh jkf'k dks 'profile' 'khV ij lsy C15 esa Rebate US89(1) esa HkjsaA "]
["Enter arrears relates to 2019-20",null,null,null,null,null,null,null,null,null,null,0]
["FINANCIAL YEAR- 2018-19",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )"]
["Enter net taxable income for 2020-21 (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,718752]
["Enter arrears relates to 2020-21",null,null,null,null,null,null,null,null,null,null,39548]
["FINANCIAL YEAR- 2019-20",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )"]
["Enter net taxable income for 2021-22 including entire arrears received (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,{"$f":"'IT calculation'!E40","v":474820}]

{"sheet":"form10E","index":4,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[15,1,15,2],[40,5,41,8],[37,0,37,8],[34,12,34,13],[35,0,35,1],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[35,10,35,11],[35,12,35,13],[34,0,34,1],[34,2,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[34,10,34,11],[32,12,32,13],[33,0,33,1],[33,2,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[32,0,32,1],[32,2,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[30,12,30,13],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[30,0,30,1],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[28,0,28,13],[29,0,29,1],[29,2,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[24,0,24,10],[24,11,24,13],[25,0,25,10],[25,11,25,13],[26,0,26,10],[26,11,26,13],[21,0,21,10],[21,11,21,13],[22,0,22,10],[22,11,22,13],[23,0,23,10],[23,11,23,13],[16,10,16,13],[18,0,18,13],[19,0,19,10],[19,11,19,13],[20,0,20,10],[20,11,20,13],[10,11,10,13],[11,0,11,10],[11,11,11,13],[12,0,12,13],[13,0,13,13],[0,0,0,13],[1,0,1,13],[2,0,2,2],[2,3,2,13],[4,10,4,13],[26,15,26,19],[2,15,5,18],[3,0,3,2],[3,3,3,13],[4,0,4,2],[4,3,4,7],[4,8,4,9],[8,0,8,10],[8,11,8,13],[5,0,5,13],[6,0,6,13],[7,0,7,10],[7,11,7,13],[9,0,9,10],[9,11,9,13],[10,0,10,10]]}
["FORM NO. 10 E (See rule 21AA)"]
["Form for furnishing particulars of income undr scetion 192(2A) for year ending 31st March 2020 for claiming relief under section 89(1) by a Government servant or an employee in a company, co-operative society, local authority, university, institution, association or body."]
["Name",null,null,{"$f":"Profile!C4","v":"KAILASH CHANDRA SHARMA"},null,null,null,null,null,null,null,null,null,null,null,"Prog. Dev. By- Kailash chandra sharma, Cont- Klsharma1971@gmail.com"]
["Address",null,null,{"$f":"'us(89)1 Form'!D3:N3","v":0}]
["PAN",null,null,{"$f":"Profile!C7","v":"BBWPK1528D"},null,null,null,null,"Status",null,"Indian Resident "]
[]
["Particulars of Income referred to in rule 21A of the Income tax Rules, 1962, during the previous year relevant to assessment year 2022-23"]
["1. (a) Salary received in arrears or in advance during 2021-22 in accordance with the provision of sub-rule (2) of rule 21A",null,null,null,null,null,null,null,null,null,null,{"$f":"'us(89)1 Form'!L7+'us(89)1 Form'!L10+'us(89)1 Form'!L13+'us(89)1 Form'!L16","v":39548}]
["(b) Payment in the nature of gratuity in respect of past services, extending over a period of not less than 5 years in accordance with the provisions of sub-rule (3) of rule 21A",null,null,null,null,null,null,null,null,null,null,"Not applicable "]
["(c) Payment in the nature of compensation from the employer or former employer at or in connection with termination of employment after continuous service of not less than 3 years in accordance with the provisions of sub-rule (4) of rule 21A",null,null,null,null,null,null,null,null,null,null,"Not applicable "]
["(d) Payment in commutation of pension in accordance with the provisions of sub-rule (5) of rule 21A",null,null,null,null,null,null,null,null,null,null,"Not applicable "]
["2. Detailed particulars of payments referred to above may be given in Annexure I, II, IIA, III or IV as the case may be ",null,null,null,null,null,null,null,null,null,null,"Annexure- I"]
["Verification "]
["I do hereby declare that what is stated above is true to the best of my knowledge and belief. Verified today "]
[]
["Date:"]
[null,null,null,null,null,null,null,null,null,null,"Signature of the employee"]
[]
["ANNEXURE - I"]
["1. Total net taxable Income excluding Salary received in Arrears or advance ",null,null,null,null,null,null,null,null,null,null,{"$f":"L22-L21","v":435272}]
["2. salary received in arrears or advance",null,null,null,null,null,null,null,null,null,null,{"$f":"L8","v":39548}]
["3. Total Income (as increased by salary received in arrears or advance) (Add item 1 and item 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"'us(89)1 Form'!L18","v":474820}]
["4. Tax on total income (as per item 3)",null,null,null,null,null,null,null,null,null,null,{"$f":"control10E!I2","v":13000}]
["5. Tax on total income (as per item 1)",null,null,null,null,null,null,null,null,null,null,{"$f":"control10E!I1","v":13000}]
["6. Tax on salary received in arrears or advance (Difference of item 4 and item 5)",null,null,null,null,null,null,null,null,null,null,{"$f":"L23-L24","v":0}]
["7. Tax computed in accordance with Table \"A\" (Brought from column 7 of Table \"A\")",null,null,null,null,null,null,null,null,null,null,{"$f":"M36","v":8226}]
["8. Relief under section 89 (1) (Indicate the difference between the amounts mentioned against items 6 and 7)",null,null,null,null,null,null,null,null,null,null,{"$f":"L25-L26","v":-8226},null,null,null,";g jkf'k Profile esa REBATE US 89(1) esa HkjsaA"]
[]
["TABLE \"A\"  (See item 7 of Annexure I)"]
["Previous Year(s)",null,"Total Net Taxable income of the relevant previous year ",null,"salary received in arrears or advance relating to the relevant previous year as mentioned in col. (1)",null,"Total income (as increased by salry received in arrears or advance) or the relevant previous year mentioned in col. (1) (Add col. 2 and 3)",null,"Tax on total income (as per col. 2)",null,"Tax on total income (as per col. 4)",null,"Difference in tax (Amount under col. 6 minus amount under col. 5)"]
[1,null,2,null,3,null,4,null,5,null,6,null,7]
["2017-18",null,{"$f":"'us(89)1 Form'!L6","v":489520},null,{"$f":"'us(89)1 Form'!L7","v":0},null,{"$f":"C32+E32","v":489520},null,{"$f":"control10E!I4","v":12335},null,{"$f":"control10E!I9","v":12335},null,{"$f":"K32-I32","v":0}]
["2018-19",null,{"$f":"'us(89)1 Form'!L9","v":53009},null,{"$f":"'us(89)1 Form'!L10","v":0},null,{"$f":"C33+E33","v":53009},null,{"$f":"control10E!I5","v":0},null,{"$f":"control10E!I10","v":0},null,{"$f":"K33-I33","v":0}]
["2019-20",null,{"$f":"'us(89)1 Form'!L12","v":802296},null,{"$f":"'us(89)1 Form'!L13","v":0},null,{"$f":"C34+E34","v":802296},null,{"$f":"control10E!I6","v":75878},null,{"$f":"control10E!I11","v":75878},null,{"$f":"K34-I34","v":0}]
["2020-21",null,{"$f":"'us(89)1 Form'!L15","v":718752},null,{"$f":"'us(89)1 Form'!L16","v":39548},null,{"$f":"C35+E35","v":758300},null,{"$f":"control10E!I7","v":58500},null,{"$f":"control10E!I12","v":66726},null,{"$f":"K35-I35","v":8226}]
["Total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M32+M33+M34+M35","v":8226}]
[]
["Prog. Dev. By- Kailash chandra sharma, Cont- Klsharma1971@gmail.com"]
[]
[]
[null,null,null,null,null,"http://ctorone.com"]

{"sheet":"control10E","index":5,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[[7,0,7,8],[2,0,2,8]]}
[null,{"$f":"form10E!L20","v":435272},"item 1",{"$f":"ROUND(B1,-1)","v":435270},{"$f":"IF(D1<=250000,0,IF(D1>250000,(250000)*0.05,0))","v":12500},{"$f":"IF(D1<=500000,0,IF(D1>500000,(D1-500000)*0.2,0))","v":0},{"$f":"E1+F1","v":12500},{"$f":"ROUND(G1*4/100,0)","v":500},{"$f":"G1+H1","v":13000}]
[null,{"$f":"form10E!L22","v":474820},"item 3",{"$f":"ROUND(B2,-1)","v":474820},{"$f":"IF(D2<=250000,0,IF(D2>250000,(250000)*0.05,0))","v":12500},{"$f":"IF(D2<=500000,0,IF(D2>500000,(D2-500000)*0.2,0))","v":0},{"$f":"E2+F2","v":12500},{"$f":"ROUND(G2*4/100,0)","v":500},{"$f":"G2+H2","v":13000}]
["colum -2"]
["17-18(2)",{"$f":"form10E!C32","v":489520},null,{"$f":"ROUND(B4,-1)","v":489520},{"$f":"ROUND(IF(D4<=250000,0,IF(D4<=500000,(D4-250000)*0.05,IF(D4<=75000,12500+(D4-500000)*0.1,IF(D4<=1000000,37500+(D4-75000)*0.15,IF(D4<=1250000,75000+(D4-1000000)*0.2,IF(D4<=1500000,125000+(D4-1250000)*0.25,IF(D4>1500000,187500+(D4-1500000)*0.3,\"0\"))))))),0)","v":11976},null,null,{"$f":"ROUND(E4*3/100,0)","v":359},{"$f":"E4+H4","v":12335}]
["18-19",{"$f":"form10E!C33","v":53009},null,53010,0,null,null,{"$f":"ROUND(E5*3/100,0)","v":0},{"$f":"E5+H5","v":0}]
["19-20",{"$f":"form10E!C34","v":802296},null,802300,{"$f":"IF(D6<=250000,0,IF(D6>250000,(250000)*0.05,0))","v":12500},{"$f":"IF(D6<=500000,0,IF(D6>500000,(D6-500000)*0.2,0))","v":60460},{"$f":"E6+F6","v":72960},{"$f":"ROUND(G6*4/100,0)","v":2918},{"$f":"G6+H6","v":75878}]
["20-21",{"$f":"form10E!C35","v":718752},null,718750,{"$f":"IF(D7<=250000,0,IF(D7>250000,(250000)*0.05,0))","v":12500},{"$f":"IF(D7<=500000,0,IF(D7>500000,(D7-500000)*0.2,0))","v":43750},{"$f":"E7+F7","v":56250},{"$f":"ROUND(G7*4/100,0)","v":2250},{"$f":"G7+H7","v":58500}]
["colum-4"]
["17-18(4)",{"$f":"form10E!G32","v":489520},null,{"$f":"ROUND(B9,-1)","v":489520},11976,null,null,{"$f":"ROUND(E9*3/100,0)","v":359},{"$f":"E9+H9","v":12335}]
["18-19",{"$f":"form10E!G33","v":53009},null,53010,{"$f":"ROUND(IF(D10<=250000,0,IF(D10<=500000,(D10-250000)*0.05,IF(D10<=75000,12500+(D10-500000)*0.1,IF(D10<=1000000,37500+(D10-75000)*0.15,IF(D10<=1250000,75000+(D10-1000000)*0.2,IF(D10<=1500000,125000+(D10-1250000)*0.25,IF(D10>1500000,187500+(D10-1500000)*0.3,\"0\"))))))),0)","v":0},null,null,{"$f":"ROUND(E10*3/100,0)","v":0},{"$f":"E10+H10","v":0}]
["19-20",{"$f":"form10E!G34","v":802296},null,802300,{"$f":"IF(D11<=250000,0,IF(D11>250000,(250000)*0.05,0))","v":12500},{"$f":"IF(D11<=500000,0,IF(D11>500000,(D11-500000)*0.2,0))","v":60460},{"$f":"E11+F11","v":72960},{"$f":"ROUND(G11*4/100,0)","v":2918},{"$f":"G11+H11","v":75878}]
["20-21",{"$f":"form10E!G35","v":758300},null,758300,{"$f":"IF(D12<=250000,0,IF(D12>250000,(250000)*0.05,0))","v":12500},{"$f":"IF(D12<=500000,0,IF(D12>500000,(D12-500000)*0.2,0))","v":51660},{"$f":"E12+F12","v":64160},{"$f":"ROUND(G12*4/100,0)","v":2566},{"$f":"G12+H12","v":66726}]

{"sheet":"Form 16","index":6,"n_rows":140,"n_cols":13,"rows_kept":140,"cut":false,"hidden":false,"merged":[[153,0,153,4],[137,0,137,1],[137,2,137,3],[137,5,137,10],[139,0,139,4],[67,2,67,3],[136,2,136,3],[133,0,133,10],[134,0,134,10],[135,0,135,1],[135,2,135,3],[135,4,135,10],[136,0,136,1],[136,4,136,10],[130,0,130,10],[131,1,131,3],[131,5,131,8],[131,9,131,10],[132,0,132,1],[132,2,132,4],[132,5,132,10],[128,0,128,4],[128,5,128,6],[128,7,128,8],[128,9,128,10],[129,0,129,4],[129,5,129,6],[129,7,129,8],[129,9,129,10],[126,0,126,4],[126,5,126,6],[126,7,126,8],[126,9,126,10],[127,0,127,4],[127,5,127,6],[127,7,127,8],[127,9,127,10],[124,0,124,4],[124,9,124,10],[125,0,125,4],[125,5,125,6],[125,7,125,8],[125,9,125,10],[122,0,122,4],[122,5,122,6],[122,7,122,8],[122,9,122,10],[123,0,123,4],[123,9,123,10],[120,0,120,4],[120,5,120,6],[120,7,120,8],[120,9,120,10],[121,0,121,4],[121,5,121,6],[121,7,121,8],[121,9,121,10],[118,0,118,4],[118,5,118,6],[118,7,118,8],[119,0,119,4],[119,5,119,6],[119,7,119,8],[109,5,109,6],[109,7,109,8],[116,0,116,4],[116,5,116,6],[116,7,116,8],[117,0,117,4],[117,5,117,6],[117,7,117,8],[114,0,114,4],[114,5,114,6],[114,7,114,8],[115,0,115,4],[115,5,115,6],[115,7,115,8],[109,9,109,10],[110,0,110,4],[110,5,110,6],[110,7,110,8],[110,9,119,10],[111,0,111,4],[111,5,111,6],[106,0,106,4],[106,5,106,6],[107,0,107,4],[107,5,107,6],[107,9,107,10],[108,0,108,4],[108,5,108,6],[108,7,108,8],[108,9,108,10],[111,7,111,8],[112,0,112,4],[112,5,112,6],[112,7,112,8],[113,0,113,4],[113,5,113,6],[113,7,113,8],[109,0,109,4],[102,0,102,4],[102,5,102,6],[103,0,103,4],[103,5,103,6],[103,9,106,10],[104,0,104,4],[104,5,104,6],[105,0,105,4],[105,5,105,6],[105,7,107,8],[94,7,104,8],[98,5,98,6],[99,0,99,4],[99,5,99,6],[100,0,100,4],[100,5,100,6],[101,0,101,4],[101,5,101,6],[94,0,94,4],[94,5,94,6],[95,0,95,4],[95,5,95,6],[96,0,96,4],[96,5,96,6],[97,0,97,4],[97,5,97,6],[98,0,98,4],[93,0,93,4],[93,5,93,6],[93,7,93,8],[93,9,93,10],[85,9,85,10],[86,0,86,4],[86,9,89,10],[87,0,87,3],[88,0,88,3],[89,0,89,3],[89,7,89,8],[84,7,84,8],[85,0,85,4],[85,7,88,8],[90,0,90,4],[90,7,92,8],[90,9,90,10],[91,0,91,4],[91,9,92,10],[92,0,92,4],[77,0,77,2],[77,3,77,4],[78,0,78,2],[79,0,79,2],[83,0,83,1],[83,2,83,4],[83,5,83,6],[84,0,84,4],[84,5,92,6],[70,0,70,10],[71,0,71,4],[71,5,71,6],[71,7,74,8],[71,9,84,10],[72,0,72,4],[72,5,72,6],[73,0,73,4],[73,5,73,6],[74,0,74,4],[79,5,79,6],[80,0,80,4],[80,5,81,6],[80,7,80,8],[81,0,81,4],[82,0,82,1],[82,2,82,4],[82,5,82,6],[74,5,74,6],[75,0,75,4],[75,5,78,6],[75,7,75,8],[76,0,76,4],[76,7,79,8],[67,0,67,1],[67,4,67,10],[68,0,68,1],[68,2,68,3],[68,5,68,10],[69,0,69,10],[63,2,63,6],[63,7,63,10],[64,0,64,10],[65,0,65,10],[66,0,66,1],[66,2,66,3],[66,4,66,10],[60,0,60,10],[61,1,61,3],[61,5,61,8],[61,9,61,10],[62,0,62,1],[62,2,62,4],[62,5,62,10],[58,1,58,2],[58,3,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[59,1,59,2],[59,3,59,10],[56,1,56,2],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[57,1,57,2],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[54,1,54,2],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[55,1,55,2],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[52,1,52,2],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[53,1,53,2],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[50,1,50,2],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[51,1,51,2],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[48,1,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[49,1,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[46,1,46,2],[46,3,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[47,1,47,2],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[44,1,44,2],[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[45,1,45,2],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[41,0,41,10],[42,0,43,0],[42,1,43,2],[42,3,42,10],[43,3,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[38,1,38,2],[38,5,38,7],[38,8,38,10],[39,1,39,2],[39,3,39,10],[40,0,40,10],[36,1,36,2],[36,5,36,7],[36,8,36,10],[37,1,37,2],[37,5,37,7],[37,8,37,10],[34,1,34,2],[34,5,34,7],[34,8,34,10],[35,1,35,2],[35,5,35,7],[35,8,35,10],[32,1,32,2],[32,5,32,7],[32,8,32,10],[33,1,33,2],[33,5,33,7],[33,8,33,10],[30,1,30,2],[30,5,30,7],[30,8,30,10],[31,1,31,2],[31,5,31,7],[31,8,31,10],[28,1,28,2],[28,5,28,7],[28,8,28,10],[29,1,29,2],[29,5,29,7],[29,8,29,10],[26,1,26,2],[26,5,26,7],[26,8,26,10],[27,1,27,2],[27,5,27,7],[27,8,27,10],[24,1,24,2],[24,5,24,7],[24,8,24,10],[25,1,25,2],[25,5,25,7],[25,8,25,10],[20,0,20,10],[21,0,21,10],[22,0,23,0],[22,1,23,2],[22,3,22,10],[23,5,23,7],[23,8,23,10],[18,1,18,3],[18,5,18,7],[18,8,18,10],[19,0,19,3],[19,5,19,7],[19,8,19,10],[15,18,16,19],[16,1,16,3],[16,5,16,7],[16,8,16,10],[17,1,17,3],[17,5,17,7],[17,8,17,10],[15,1,15,3],[15,5,15,7],[15,8,15,10],[15,12,16,13],[15,14,16,15],[15,16,16,17],[13,0,13,10],[14,1,14,3],[14,5,14,7],[14,8,14,10],[11,1,11,4],[11,5,12,6],[11,7,11,8],[11,9,11,10],[12,1,12,2],[12,7,12,8],[12,9,12,10],[9,0,9,2],[9,3,9,4],[9,5,9,7],[9,8,9,10],[10,0,10,4],[10,5,10,6],[10,7,10,10],[5,0,5,4],[5,5,5,10],[6,0,7,4],[6,5,6,10],[7,5,7,10],[8,0,8,2],[8,3,8,4],[8,5,8,7],[8,8,8,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,2],[4,3,4,4],[4,5,4,7],[4,8,4,10],[0,12,1,21],[2,12,4,21]]}
["FORM NO. 16",null,null,null,null,null,null,null,null,null,null,null,"Prog. Dev. By- KAILASH CHANDRA SHARMA, Contact:-klsharma1971@gmail.com"]
["[(See Rule 31(1)(a)]"]
["PART-A",null,null,null,null,null,null,null,null,null,null,null,"DOWNLOAD FROM MY WEB.http://ctorone.com"]
["Certificate uner section 203 of the income-tax act, 1961 for tax deducted at source on Salary."]
["Certificate No.",null,null,null,null,"Last Updated On"]
["Name and address of the employer",null,null,null,null,"Name and adress of the employee",null,null,null,null,null,null,"DOWNLOAD FROM MY WEB.http://ctorone.com"]
[{"$f":"Profile!C6","v":"GSSS JEEWANA"},null,null,null,null,{"$f":"Profile!C4","v":"KAILASH CHANDRA SHARMA"}]
[null,null,null,null,null,{"$f":"Profile!C5","v":"TEACHER"}]
["PAN of the Deductor",null,null,"TAN of Deductor",null,"PAN of the Employee",null,null,"Employee Ref No."]
[{"$f":"Profile!L6","v":0},null,null,{"$f":"Profile!L7","v":0},null,{"$f":"Profile!C7","v":"BBWPK1528D"}]
["CIT (TDS)",null,null,null,null,"Assess. Year",null,"Peroid with the Employer"]
["Adress","CIT (TDS), New Central Revenue Building, Statue Circle",null,null,null,"2022-23",null,"From",null,"To"]
["City","Jaipur",null,"PIN Code",302005,null,null,"01-4-2021",null,"31-03-2022"]
["Summary of amount paid/credited and tax deducted at source thereon in respect of the employee"]
["Quarters","Receipt Numbers of original quarterly statements of TDS under sub-secion (3) of section 200",null,null,"Amount paid/ credited","Amount of tax deducted (Rs.)",null,null,"Amount of tax deposited/ remitted (Rs.)"]
["Ist",{"$f":"Profile!E29","v":0},null,null,null,{"$f":"Profile!E26","v":0},null,null,{"$f":"F16","v":0}]
["IInd",{"$f":"Profile!G29","v":0},null,null,null,{"$f":"Profile!G26","v":0},null,null,{"$f":"F17","v":0}]
["IIIrd",{"$f":"Profile!I29","v":0},null,null,null,{"$f":"Profile!I26","v":0},null,null,{"$f":"F18","v":0}]
["IVth",{"$f":"Profile!K29","v":0},null,null,null,{"$f":"Profile!K26","v":0},null,null,{"$f":"F19","v":0}]
["TOTAL",null,null,null,{"$f":"SUM(E16:E19)","v":0},{"$f":"SUM(F16:F19)","v":0},null,null,{"$f":"SUM(I16:I19)","v":0}]
["I. Details of tax deducted and deposited in the Central Government account through book adjustment"]
["(The Deductor to provide payment-wise details of tax deducted and deposited with respect to the deductee)"]
["S.N.","Tax Deposited in respect of the deductee (Rs)",null,"Book identification number (BIN)"]
[null,null,null,"Receipt numbers of form No. 24G","DDO serial number in Form No. 24G","Date of transfer voucher (dd/mm/yyyy)",null,null,"Status of matching with Form No. 24G"]
[1,{"$f":"Salary!V6","v":0},null,{"$f":"IF([1]profile!B32=\"\",\"\",[1]profile!B32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!B33=\"\",\"\",[1]profile!B33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!B34=\"\",\"\",[1]profile!B34)","v":{"$error":"#REF!"}},null,null,{"$f":"IF(D25>\"0\",\"Yes\",\"\")","v":{"$error":"#REF!"}}]
[2,{"$f":"Salary!V7","v":0},null,{"$f":"IF([1]profile!C32=\"\",\"\",[1]profile!C32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!C33=\"\",\"\",[1]profile!C33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!C34=\"\",\"\",[1]profile!C34)","v":{"$error":"#REF!"}},null,null,{"$f":"IF(D26>\"0\",\"Yes\",\"\")","v":{"$error":"#REF!"}}]
[3,{"$f":"Salary!V8","v":0},null,{"$f":"IF([1]profile!D32=\"\",\"\",[1]profile!D32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!D33=\"\",\"\",[1]profile!D33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!D34=\"\",\"\",[1]profile!D34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[4,{"$f":"Salary!V9","v":0},null,{"$f":"IF([1]profile!E32=\"\",\"\",[1]profile!E32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!E33=\"\",\"\",[1]profile!E33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!E34=\"\",\"\",[1]profile!E34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[5,{"$f":"Salary!V10","v":0},null,{"$f":"IF([1]profile!F32=\"\",\"\",[1]profile!F32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!F33=\"\",\"\",[1]profile!F33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!F34=\"\",\"\",[1]profile!F34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[6,{"$f":"Salary!V11","v":0},null,{"$f":"IF([1]profile!G32=\"\",\"\",[1]profile!G32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!G33=\"\",\"\",[1]profile!G33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!G34=\"\",\"\",[1]profile!G34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[7,{"$f":"Salary!V12","v":0},null,{"$f":"IF([1]profile!H32=\"\",\"\",[1]profile!H32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!H33=\"\",\"\",[1]profile!H33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!H34=\"\",\"\",[1]profile!H34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[8,{"$f":"Salary!V13","v":0},null,{"$f":"IF([1]profile!I32=\"\",\"\",[1]profile!I32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!I33=\"\",\"\",[1]profile!I33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!I34=\"\",\"\",[1]profile!I34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[9,{"$f":"Salary!V14","v":0},null,{"$f":"IF([1]profile!J32=\"\",\"\",[1]profile!J32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!J33=\"\",\"\",[1]profile!J33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!J34=\"\",\"\",[1]profile!J34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[10,{"$f":"Salary!V15","v":0},null,{"$f":"IF([1]profile!K32=\"\",\"\",[1]profile!K32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!K33=\"\",\"\",[1]profile!K33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!K34=\"\",\"\",[1]profile!K34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[11,{"$f":"Salary!V16","v":0},null,{"$f":"IF([1]profile!M32=\"\",\"\",[1]profile!M32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!M33=\"\",\"\",[1]profile!M33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!M34=\"\",\"\",[1]profile!M34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[12,{"$f":"Salary!V17","v":0},null,{"$f":"IF([1]profile!O32=\"\",\"\",[1]profile!O32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!O33=\"\",\"\",[1]profile!O33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!O34=\"\",\"\",[1]profile!O34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[13,{"$f":"Salary!V18","v":0},null,{"$f":"IF([1]profile!Q32=\"\",\"\",[1]profile!Q32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!Q33=\"\",\"\",[1]profile!Q33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!Q34=\"\",\"\",[1]profile!Q34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[14,{"$f":"Salary!V19","v":0},null,{"$f":"IF([1]profile!S32=\"\",\"\",[1]profile!S32)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!S33=\"\",\"\",[1]profile!S33)","v":{"$error":"#REF!"}},{"$f":"IF([1]profile!S34=\"\",\"\",[1]profile!S34)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"}]
[15,null,null,null,null,null,null,null,""]
["Total",{"$f":"SUM(B25:B39)","v":0}]
["II. Details of Tax deducted and deposited in Central Government Account through Challan. "]
["(The deducter to provide payment-wise details of tax deducted and deposited with respect to the deductee)"]
["S.N.","Tax Deposited in respect on of the deductee (Rs)",null,"Challan identification number (CIN)"]
[null,null,null,"BSR code of the Bank Branch",null,"Date on which tax deposited (dd/mm/yyyy)",null,"Challan Serial Number",null,"Status of matching with OLTAS"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
["Total",{"$f":"SUM(B45:B59)","v":0}]
["Verification"]
["I",{"$f":"Profile!I6","v":0},null,null,"son/daughter of ",{"$f":"Profile!I7","v":0},null,null,null,"working in the "]
["capacity of ",null,{"$f":"Profile!G8","v":0},null,null,"(designation) do hereby certify that a sum of "]
["Rs",{"$f":"I20","v":0},{"$f":"SpellNumber($B$64)","v":{"$error":"#NAME?"}},null,null,null,null,"(in words) has been deducted "]
["and deposited to the credit of the Central Govt.. I further certify that the information given above is true, complete and "]
["correct and is based on the books of account, documents,TDS statement, TDS deposited and other available records."]
["Place"]
["Date",null,null,null,"Signature of person responsible for deduction of tax"]
["Designation",null,{"$f":"Profile!G8","v":0},null,"Full name",{"$f":"Profile!I6","v":0}]
["PART- B (Annexure)"]
["DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
["1. Gross salary"]
["(a) Salary as per provisions contained in section 17(1)",null,null,null,null,{"$f":"'IT calculation'!E4","v":673966}]
["(b) Value of perquisites u/s 17(2) (as per Form No. 12BA, wherever applicable)",null,null,null,null,{"$f":"'[1]I T cal.'!D5","v":0}]
["(c) Profits in lieu of salary under section 17(3) (as per Form No. 12BA, wherever applicable)",null,null,null,null,0]
["(d) Total",null,null,null,null,null,null,{"$f":"F73+F74+F75","v":673966}]
["2. Less: Allowance to the extent exempt u/s 10 House Rent Allowance"]
["Allowance",null,null,"Rs"]
["House Rent Allow. US10 (13 A)",null,null,{"$f":"IF(E79=\"0\",\"\",[1]salary!E25)","v":""},{"$f":"'[1]I T cal.'!B6","v":"0"}]
[{"$f":"'[1]I T cal.'!C6","v":"US10 "},null,null,{"$f":"'[1]I T cal.'!D6","v":0},{"$f":"'[1]I T cal.'!D6","v":0},{"$f":"E79+E80","v":0}]
["3. Balance (1 - 2)",null,null,null,null,null,null,{"$f":"H76-F80","v":673966}]
["4. Deductions:"]
["(a)",null,"Entertainment allowance",null,null,0]
["(b)",null,"Tax on employment",null,null,0]
["5. Aggregate of 4(a) and (b)",null,null,null,null,null,null,50000]
["6. Income chargeable under the head \"salaries\" (3-5)",null,null,null,null,null,null,null,null,{"$f":"H81-H85","v":623966}]
["7. Add: Any other income reported by employee "]
["Income",null,null,null,"Rs"]
["From House Property",null,null,null,{"$f":"'IT calculation'!D10","v":0}]
[{"$f":"CONCATENATE(IF('[1]I T cal.'!A12>0,\"NSC int,\",\"\"),IF('[1]I T cal.'!B12>0,\" FDR int,\",\"\"),IF('[1]I T cal.'!C12>0,\" Bonds,\",\"\"),IF('[1]I T cal.'!D12>0,\" SB a/c int,\",\"\"),IF('[1]I T cal.'!E12>0,\" Other income\",\"\"))","v":""},null,null,null,{"$f":"E89","v":0},null,null,{"$f":"E90","v":0}]
["8. Gross total income (6+7)",null,null,null,null,null,null,null,null,{"$f":"J86+H90","v":623966}]
["9. Deductions under Chapter VI A"]
["(A) Section 80C, 80CCC and 80CCD"]
["(a) Section 80C",null,null,null,null,null,null,"Gross Amount",null,"Deductible Amount"]
["G P F",null,null,null,null,{"$f":"'IT calculation'!C16","v":6465}]
["S I",null,null,null,null,{"$f":"'IT calculation'!C17","v":26400}]
["L I C + ULIP + PLI",null,null,null,null,{"$f":"'IT calculation'!C18+'IT calculation'!C20+'IT calculation'!C23","v":0}]
["Gr. Acc. Insurance",null,null,null,null,{"$f":"'IT calculation'!C19","v":2100}]
["Home loan capital",null,null,null,null,{"$f":"'IT calculation'!C21","v":0}]
["PPF",null,null,null,null,{"$f":"'IT calculation'!C22","v":0}]
["Notified Bond Of NABARD",null,null,null,null,{"$f":"'IT calculation'!C24","v":0}]
["Tuition Fee",null,null,null,null,{"$f":"'IT calculation'!E17","v":0}]
["NSC + Interest on NSC",null,null,null,null,{"$f":"'IT calculation'!E19","v":0}]
["Equity linked savings",null,null,null,null,0,null,null,null,{"$f":"IF([1]control!H4=TRUE,\"US 80CCE (Max limit) +US 80CCD(2)\",\"\")","v":""}]
["Deferred Annuity",null,null,null,null,0]
["Fixed Deposit",null,null,null,null,{"$f":"'IT calculation'!E22","v":0}]
["Sukanya Samriddhi Yojana",null,null,null,null,{"$f":"'IT calculation'!E23","v":0}]
["(b) Section 80CCC",null,null,null,null,{"$f":"'IT calculation'!E24","v":0},null,null,null,{"$f":"CONCATENATE(IF([1]control!H4=TRUE,\"(Rs.\",\"\"),IF([1]control!H4=TRUE,[1]salary!L25,\"\"),IF([1]control!H4=TRUE,\")\",\"\"))","v":""}]
["(c) Section 80CCD(1)",null,null,null,null,{"$f":"'IT calculation'!E16","v":57092},null,{"$f":"SUM(F95:F109)","v":92057},null,{"$f":"'IT calculation'!E26","v":149149}]
["(B) Other Sections under Chapter VIA",null,null,null,null,"Gross Amount",null,"Qualifying amount",null,"Deductible Amount"]
["U/S 80CCG",null,null,null,null,0,null,{"$f":"F111","v":0}]
["U/S 80D",null,null,null,null,{"$f":"'IT calculation'!E29","v":0},null,{"$f":"F112","v":0}]
["U/S 80DD",null,null,null,null,{"$f":"'IT calculation'!E30","v":0},null,0]
["U/S 80DDB",null,null,null,null,{"$f":"'IT calculation'!E31","v":0},null,0]
["U/S 80E",null,null,null,null,{"$f":"'IT calculation'!E32","v":0},null,0]
["U/S 80G",null,null,null,null,{"$f":"'IT calculation'!E33","v":0},null,0]
["U/S 80GG",null,null,null,null,{"$f":"'IT calculation'!E34","v":0},null,0]
["U/S 80EE",null,null,null,null,{"$f":"'IT calculation'!E35","v":0},null,0]
["U/S 80U",null,null,null,null,{"$f":"'IT calculation'!E36","v":0},null,0]
["US 80CCD (1B)",null,null,null,null,{"$f":"'IT calculation'!E38","v":0},null,0]
["US 80TTA",null,null,null,null,{"$f":"'IT calculation'!E37","v":0},null,0,null,{"$f":"ROUND((H111+H112+H113+H114+H115+H116+H117+H118+H119+H120+H121),0)","v":0}]
["10. Aggregate of deductible amount under chapter VIA ",null,null,null,null,null,null,null,null,{"$f":"ROUND((J109+J121),0)","v":149149}]
["11. Total income (8-10)",null,null,null,null,null,null,null,null,{"$f":"ROUND((J91-J122),-1)","v":474820}]
["Income tax for Men",null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(J123<=250000,0,IF(J123<=500000,(J123-250000)*0.05,IF(J123<=1000000,12500+(J123-500000)*0.2,IF(J123>1000000,112500+(J123-1000000)*0.3,\"0\")))),0)","v":11241}]
["Tax Credit, Max Rs 5000/",null,null,null,null,null,null,null,null,{"$f":"IF(AND(J123<=350000,J124>=2500),J124-2500,IF(AND(J123<=350000,J124<2500),0,J124))","v":11241}]
["12. Tax on total income",null,null,null,null,null,null,null,null,{"$f":"IF(J123<=500000,J125,J124)","v":11241}]
["13. Education cess",null,null,null,null,null,null,null,null,{"$f":"ROUND((J126*0.03),0)+ROUND((J126*0.01),0)","v":449}]
["14. Tax payable (12+13)",null,null,null,null,null,null,null,null,{"$f":"J126+J127","v":11690}]
["15. Relief under section 89 (Attach details)",null,null,null,null,null,null,null,null,{"$f":"'IT calculation'!E46","v":0}]
["16. Tax payable (14-15)",null,null,null,null,null,null,null,null,{"$f":"J128-J129","v":11690}]
["Verification"]
["I",{"$f":"Profile!I6","v":0},null,null,"son/daughter of ",{"$f":"Profile!I7","v":0},null,null,null,"working in the "]
["capacity of ",null,{"$f":"Profile!G8","v":0},null,null,"(designation) do hereby certify that the "]
["information given above is true, complete and correct and is based on the books of account, documents,TDS statement and other"]
["available records."]
["Place"]
["Date",null,null,null,"Signature of person responsible for deduction of tax"]
["Designation",null,{"$f":"Profile!G8","v":0},null,"Full name",{"$f":"Profile!I6","v":0}]
[]
["Visit http://ctorone.in for Income Tax calculation program."]

{"sheet":"control","index":7,"n_rows":46,"n_cols":32,"rows_kept":46,"cut":false,"hidden":true,"merged":[[1,30,1,31],[21,0,21,2],[23,12,23,13],[24,12,24,13],[1,27,2,27],[19,17,19,18],[20,17,20,18],[23,23,23,26],[24,23,24,26],[1,19,2,19],[21,7,21,8],[25,23,25,26],[26,23,26,26],[0,25,0,27],[1,20,2,20],[18,0,18,1],[0,1,1,1],[0,2,0,13],[1,25,2,25],[1,26,2,26],[1,18,2,18],[1,17,2,17],[1,16,2,16],[0,14,1,14],[17,0,17,1],[0,15,1,15],[21,11,21,12]]}
[null,"ekg","osru tks fn;k x;k",null,null,null,null,null,null,null,null,null,null,null,"lkeqfgd nq?kZVuk chek","fgrdkjh fuf/k",null,null,null,null,null,null,null,null,null,"PL"]
[null,null,"jfuax is cS.M o xzsM is","ewy osru"," Mh ,","HRA","HRA","NPS","GPF","SI","GPS 2004","Income Tax","RPMF","RPMF",null,null,"MONTH","ACP","GPF/NPS","GPF/NPS","BONUS","YES",{"$f":"K16","v":0},"GPF 2004","GPF 2004","BASIC","DA","TOTAL",null,null,"SURENDER"]
[null,2,3,null,4,5,null,null,6,7,8,9,10,11,{"$f":"Profile!C19","v":2100},{"$f":"IF(V20=1,U20,IF(V20=2,U21,0))","v":250},null,null,null,null,null,"NO",null,"GPF ",{"$f":"IF(Profile!$C$15>=\"GPF 2004\",W2,IF(Profile!$C$15>=\"GPF\",$I$16,))","v":0},null,null,null,"SURENDER",1,"BASIC","DA"]
[3,"ekpZ&20",{"$f":"Profile!C10","v":36900},{"$f":"IF(Profile!$S$7=1,R4,R4)","v":36900},{"$f":"ROUND(((D4)*17%),0)","v":6273},{"$f":"ROUND(((D4)*8%),0)","v":2952},{"$f":"IF(Profile!$S$7=1,F4,0)","v":2952},{"$f":"ROUND(((D4+E4)*10%),0)","v":4317},{"$f":"IF(C4=0,0,IF(C4<23100,1450,IF(C4<2850,1625,IF(C4<38500,2100,IF(C4<51500,2850,IF(C4<62000,3575,IF(C4<72000,4200,IF(C4<80000,4800,IF(C4<116000,6150,IF(C4<167000,8900,IF(C4>167000,10500)))))))))))","v":2100},{"$f":"IF(C4=0,0,IF(C4<22000,800,IF(C4<28500,1200,IF(C4<46500,2200,IF(C4<72000,3000,IF(C4<72000,5000,IF(C4>72000,7000)))))))","v":2200},{"$f":"Profile!A22","v":0},{"$f":"B17","v":0},{"$f":"IF(C4=0,0,IF(C4<18000,265,IF(C4<33500,440,IF(C4<54000,658,IF(C4>54000,875)))))","v":658},{"$f":"IF(Profile!$O$6=\"GPF\",M4,0)","v":0},{"$f":"Profile!C20","v":0},null,3,{"$f":"IF(Profile!$I$10=3,C4,C4)","v":36900},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$4)","v":4317},{"$f":"IF(Profile!$S$7=1,S4,0)","v":4317},{"$f":"6774/12*Profile!L11","v":6774},"YES",null,null,null,{"$f":"R4/31*15","v":17854.838709677417},{"$f":"Z4*17/100","v":3035.3225806451605},{"$f":"SUM(Z4:AA4)","v":20890.161290322576},{"$f":"IF(Profile!$C$11=3,AB4,IF(Profile!C11=4,AB5,IF(Profile!C11=5,AB6,IF(Profile!C11=6,AB7,IF(Profile!C11=7,AB8,IF(Profile!C11=8,AB9,IF(Profile!C11=9,AB10,IF(Profile!C11=10,AB11,IF(Profile!C11=11,AB12,IF(Profile!C11=12,AB13,IF(Profile!C11=1,AB14,IF(Profile!C11=2,AB15,0))))))))))))","v":0},2,{"$f":"AC4-AF4","v":0},{"$f":"AC4*14.53%","v":0}]
[4,"vizsy&20",{"$f":"C4","v":36900},{"$f":"IF(Profile!$S$7=1,R5,R5)","v":36900},{"$f":"ROUND(((D5)*17%),0)","v":6273},{"$f":"ROUND(((D5)*8%),0)","v":2952},{"$f":"IF(Profile!$S$7=1,F5,0)","v":2952},{"$f":"ROUND(((D5+E5)*10%),0)","v":4317},2100,2200,{"$f":"Profile!B22","v":0},{"$f":"C17","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M5,0)","v":0},{"$f":"Profile!L16","v":0},null,4,{"$f":"IF(Profile!$I$10=4,Profile!L10,R4)","v":36900},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$5)","v":4317},{"$f":"IF(Profile!$S$7=1,S5,0)","v":4317},null,{"$f":"IF(Profile!$G$11>=\"YES\",U4,IF(Profile!$G$11<=\"NO\",0))","v":6774},null,null,null,{"$f":"R5/30*15","v":18450},{"$f":"Z5*17/100","v":3136.5},{"$f":"SUM(Z5:AA5)","v":21586.5},null,3]
[5,"ebZ&20",{"$f":"C5","v":36900},{"$f":"IF(Profile!$S$7=1,R6,R6)","v":36900},{"$f":"ROUND(((D6)*17%),0)","v":6273},2952,{"$f":"IF(Profile!$S$7=1,F6,0)","v":2952},4317,2100,2200,{"$f":"Profile!C22","v":0},{"$f":"E17","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M6,0)","v":0},{"$f":"Profile!F20","v":0},null,5,{"$f":"IF(Profile!$I$10=5,Profile!L10,R5)","v":36900},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$6)","v":4317},{"$f":"IF(Profile!$S$7=1,S6,0)","v":4317},null,null,null,null,null,{"$f":"R6/31*15","v":17854.838709677417},{"$f":"Z6*17/100","v":3035.3225806451605},20890.161290322576,null,4]
[6,"twu&20",{"$f":"C6","v":36900},{"$f":"IF(Profile!$S$7=1,R7,R7)","v":36900},6273,2952,{"$f":"IF(Profile!$S$7=1,F7,0)","v":2952},4317,2100,2200,{"$f":"Profile!D22","v":0},{"$f":"F17","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M7,0)","v":0},{"$f":"Profile!L15","v":0},null,6,{"$f":"IF(Profile!$I$10=6,Profile!L10,R6)","v":36900},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$7)","v":4317},{"$f":"IF(Profile!$S$7=1,S7,0)","v":4317},null,null,null,null,null,{"$f":"R7/30*15","v":18450},{"$f":"Z7*17/100","v":3136.5},21586.5,null,5]
[7,"tqyk-&20",{"$f":"IF(AND($C$7=\"\"),\"\",MROUND($C$7*1.03,100))","v":38000},{"$f":"IF(Profile!$S$7=1,R8,R8)","v":38000},{"$f":"ROUND(((D8)*28%),0)","v":10640},3040,{"$f":"IF(Profile!$S$7=1,F8,0)","v":3040},4864,2100,2200,{"$f":"Profile!E22","v":0},{"$f":"H17","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M8,0)","v":0},{"$f":"Profile!I20","v":0},null,"7",{"$f":"IF(AND(R7=\"\"),\"\",MROUND(R7*1.03,100))","v":38000},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$8)","v":4864},{"$f":"IF(Profile!$S$7=1,S8,0)","v":4864},null,null,null,null,null,19000,{"$f":"Z8*28/100","v":5320},24320,null,6]
[8,"vx-&20",{"$f":"IF(AND($C$7=\"\"),\"\",MROUND($C$7*1.03,100))","v":38000},{"$f":"IF(Profile!$S$7=1,R9,R9)","v":38000},{"$f":"ROUND(((D9)*28%),0)","v":10640},{"$f":"ROUND(((D9)*9%),0)","v":3420},{"$f":"IF(Profile!$S$7=1,F9,0)","v":3420},4864,2100,2200,{"$f":"Profile!F22","v":0},{"$f":"I17","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M9,0)","v":0},{"$f":"Profile!F16","v":0},null,8,{"$f":"IF(Profile!$I$10=8,Profile!L10,R8)","v":38000},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$9)","v":4864},{"$f":"IF(Profile!$S$7=1,S9,0)","v":4864},null,null,null,null,null,19000,5320,24320,null,7]
[9,"flr-&20",38000,{"$f":"IF(Profile!$S$7=1,R10,R10)","v":38000},{"$f":"ROUND(((D10)*28%),0)","v":10640},{"$f":"ROUND(((D10)*9%),0)","v":3420},{"$f":"IF(Profile!$S$7=1,F10,0)","v":3420},4864,2100,2200,{"$f":"Profile!G22","v":0},{"$f":"J17","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M10,0)","v":0},{"$f":"Profile!L20","v":0},null,9,{"$f":"IF(Profile!$I$10=9,Profile!L10,R9)","v":38000},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$10)","v":4864},{"$f":"IF(Profile!$S$7=1,S10,0)","v":4864},null,null,null,null,null,19000,5320,24320,null,8]
[10,"vDVw-&20",38000,{"$f":"IF(Profile!$S$7=1,R11,R11)","v":38000},{"$f":"ROUND(((D11)*31%),0)","v":11780},3420,{"$f":"IF(Profile!$S$7=1,F11,0)","v":3420},4978,2100,2200,{"$f":"Profile!H22","v":0},{"$f":"K17","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M11,0)","v":0},null,null,10,{"$f":"IF(Profile!$I$10=10,Profile!L10,R10)","v":38000},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$11)","v":4978},{"$f":"IF(Profile!$S$7=1,S11,0)","v":4978},null,null,null,null,null,19000,5320,24320,null,9]
[11,"uc-&20",38000,{"$f":"IF(Profile!$S$7=1,R12,R12)","v":38000},{"$f":"ROUND(((D12)*31%),0)","v":11780},3420,{"$f":"IF(Profile!$S$7=1,F12,0)","v":3420},4978,2100,2200,{"$f":"Profile!I22","v":0},{"$f":"L17","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M12,0)","v":0},null,null,11,{"$f":"IF(Profile!$I$10=11,Profile!L10,R11)","v":38000},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$12)","v":4978},{"$f":"IF(Profile!$S$7=1,S12,0)","v":4978},null,null,null,null,null,19000,5320,24320,null,10]
[12,"fnl-&20",38000,{"$f":"IF(Profile!$S$7=1,R13,R13)","v":38000},11780,3420,{"$f":"IF(Profile!$S$7=1,F13,0)","v":3420},4978,2100,2200,{"$f":"Profile!J22","v":0},{"$f":"M17","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M13,0)","v":0},null,null,12,{"$f":"IF(Profile!$I$10=12,Profile!L10,R12)","v":38000},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$13)","v":4978},{"$f":"IF(Profile!$S$7=1,S13,0)","v":4978},null,null,null,null,null,19000,5320,24320,null,11]
[1,"tu-&21",38000,{"$f":"IF(Profile!$S$7=1,R14,R14)","v":38000},11780,3420,{"$f":"IF(Profile!$S$7=1,F14,0)","v":3420},4978,2100,2200,{"$f":"Profile!K22","v":0},{"$f":"N17","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M14,0)","v":0},null,null,1,{"$f":"IF(Profile!$I$10=1,Profile!L10,R13)","v":38000},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$14)","v":4978},{"$f":"IF(Profile!$S$7=1,S14,0)","v":4978},null,null,null,null,null,19000,5320,24320,null,12]
[2,"Qj-&21",38000,{"$f":"IF(Profile!$S$7=1,R15,R15)","v":38000},11780,3420,{"$f":"IF(Profile!$S$7=1,F15,0)","v":3420},4978,2100,2200,{"$f":"Profile!L22","v":0},{"$f":"O16","v":0},658,{"$f":"IF(Profile!$O$6=\"GPF\",M15,0)","v":0},null,null,2,{"$f":"IF(Profile!$I$10=2,Profile!L10,R14)","v":38000},{"$f":"IF(Profile!$O$6=\"GPF\",$I$4,$H$15)","v":4978},{"$f":"IF(Profile!$S$7=1,S15,0)","v":4978},null,null,null,null,null,{"$f":"R15/28*15","v":20357.142857142855},5700,26057.142857142855]
[null,null,{"$f":"SUM(C4:C15)","v":451600},null,{"$f":"ROUND(((C16)*17%),0)","v":76772},{"$f":"ROUND(((C16)*8%),0)","v":36128},null,{"$f":"ROUND(((C16+E16)*10%),0)","v":52837},10500,7000,{"$f":"SUM(K4:K15)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(S4:S15)","v":56750},{"$f":"SUM(T4:T15)","v":56750},null,{"$f":"IF(Profile!$O$6>=\"NPS\",H16,IF(Profile!$O$6<=\"GPF\",0))","v":52837},{"$f":"IF(Profile!$O$6>=\"NPS\",I16,IF(Profile!$O$6<=\"GPF\",0))","v":10500}]
["IT",{"$f":"Profile!A25","v":0},{"$f":"Profile!B25","v":0},{"$f":"Profile!C25","v":0},{"$f":"Profile!D25","v":0},{"$f":"Profile!E25","v":0},{"$f":"Profile!F25","v":0},{"$f":"Profile!G25","v":0},{"$f":"Profile!H25","v":0},{"$f":"Profile!I25","v":0},{"$f":"Profile!J25","v":0},{"$f":"Profile!K25","v":0},{"$f":"Profile!L25","v":0},{"$f":"Profile!M25","v":0},null,null,null,null,null,null,null,{"$f":"V16*2","v":105674}]
["AREAR TDS",null,{"$f":"Salary!V22","v":0}]
["AREAR TDS",null,{"$f":"Salary!V23","v":0}]
[null,null,null,null,null,null,null,"LIC",{"$f":"Salary!R25","v":0},{"$f":"Profile!F15","v":0},{"$f":"SUM(I20:J20)","v":0},null,null,null,null,null,null,"GAZETTED",null,null,500,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NON GAZETTED",null,null,250]
["INCOME TAX CALCULATER 2021-22",null,null,null,null,null,null,"HRA AREAR",null,{"$f":"ROUND(((C8)*1%),0)","v":380},null,"DA AREAR",null,{"$f":"(E11-E10)*3","v":3420}]
["BASIC SALARY                         01-03-2021",{"$f":"R4","v":36900}]
["DA",17,null,null,null,null,null,{"$f":"B23","v":36900},{"$f":"H24*4","v":147600},null,null,null,"Standerd Ded.",null,null,null,1,null,null,null,null,null,2,"STATE SERVICE"]
["Income",{"$f":"I30","v":564500},null,null,null,null,null,{"$f":"IF(AND(H24=\"\"),\"\",MROUND(H24*1.03,100))","v":38000},{"$f":"H25*8","v":304000},null,null,null,"Investment",null,null,null,2,null,null,null,null,null,null,"STATE SUBORDINATE(L10 AND ABOVE)"]
["Standerd Ded.",50000,null,null,null,null,null,null,{"$f":"SUM(I24:I25)","v":451600},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINISTRIAL SERVICE(L5 TO L9)"]
["House Loan Interest",0,null,null,null,null,null,"HRA",{"$f":"ROUND(I26*0.08,0)","v":36128},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVTH CLASS(L1 TO L4)"]
["Investments",150000,null,null,null,null,null,"DA",{"$f":"I26*B24","v":7677200}]
["TILL TDS BY Salary",57500,null,null,null,null,null,null,{"$f":"I28/100","v":76772}]
[null,null,null,null,null,null,null,null,{"$f":"I26+I27+I29","v":564500}]
["Labels","Old Slabes","New Slabes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2]
["Income",{"$f":"B25-B26-B27","v":514500},{"$f":"B25","v":564500}]
["Investments",{"$f":"B28","v":150000},{"$f":"C28","v":0}]
["Taxable Income",{"$f":"B32-B33","v":364500},{"$f":"C32-C33","v":564500}]
["Slab 5%",{"$f":"IF($B$34<=250000,0,IF($B$34>250000,(250000)*0.05,0))","v":12500},{"$f":"IF($C$34<=250000,0,IF($C$34>250000,(250000)*0.05,0))","v":12500}]
["Slab 10%",0,{"$f":"IF($C$34<=500000,0,IF($C$34>500000,(250000)*0.1,0))","v":25000}]
["Slab 15%",0,{"$f":"IF($C$34<=750000,0,IF($C$34>750000,(250000)*0.15,0))","v":0}]
["Slab 20%",{"$f":"IF($B$34<=500000,0,IF($B$34>500000,(B34-500000)*0.2,0))","v":0},{"$f":"IF($C$34<=1000000,0,IF($C$34>1000000,(250000)*0.2,0))","v":0}]
["Slab 25%",0,{"$f":"IF($C$34<=1250000,0,IF($C$34>1250000,(250000)*0.25,0))","v":0}]
["Slab 30%",{"$f":"IF($B$34<=1000000,0,IF($B$34>1000000,(B34-1000000)*0.3,0))","v":0},{"$f":"IF($C$34<=1500000,0,IF($C$34>1500000,(C34-1500000)*0.3,0))","v":0}]
["Tax Rebate",{"$f":"IF(B34<=500000,12500,0)","v":12500},{"$f":"IF(C34<=500000,12500,0)","v":0}]
["Surcharge 10%"]
["Surcharge 15%"]
["Cess 4%",{"$f":"(B35+B38+B40)*0.04","v":500},{"$f":"(C35+C36+C37+C38+C39+C40)*0.04","v":1500}]
["Income Tax",{"$f":"B35+B38+B40+B44","v":13000},{"$f":"C35+C36+C37+C38+C39+C40+C44","v":39000}]
["Tax Refund",{"$f":"B29-B45","v":44500},{"$f":"C29-C45","v":-39000}]