{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Welcome","from the developer's desk","profile","control","Partial HRA","salary","HRA ex.","I T cal.","Form 16","nsc int","us89(1)form","form10E","control10E"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"Welcome","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,5,17],[7,1,39,17],[6,1,6,17]]}
[]
[null,"PLEASE ENABLE MACROS FIRST"]
[]
[]
[]
[]
[null,"Please install devlys010 fonts on your system. For using this program please enable macros as instructins given on this sheet. "]
[null,"Macro dks Enable djus ds fy, /;ku nhft,] tSls gh vki bl izksxzke dks open djsaxsA ,d Security warning fuEu izdkj fn[kkbZ nsxh&\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nbl Security warning dks Options ij fDyd dj open djsa ,oa Enable this content ij fDyd dj OK djsaA \n\n"]

{"sheet":"from the developer's desk","index":1,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":true,"merged":[[77,0,87,14],[22,0,22,1],[22,2,22,3],[14,0,14,14],[16,0,16,14],[18,0,18,9],[17,10,21,14],[20,0,21,9],[12,0,12,14],[10,1,10,14],[0,0,0,14],[1,0,1,14],[4,1,4,14],[6,1,6,14],[8,1,8,14],[2,0,2,14]]}
["FROM THE DEVELOPER'S DESK"]
["1- vk;dj x.kuk ds fy, ;g odZcqd dsoy jktLFkku jkT; ds deZpkfj;ksa ds fy, rS;kj dh x;h gSA"]
["2- bl odZcqd esa iz;qDr fd, x, QksUV Devlys010 ,oa Times New Roman gS] rFkk blesa fuEu lqfo/kk,a miYkC/k gSa&"]
[]
[null,"¼v½ LVS.MMZ lSysjh 'khV ,oa vk;dj x.kuk 'khV dk vkWVkstusjs'ku"]
[]
[null,"¼c½ QkWeZ 16 dk vkWVkstusjs'ku"]
[]
[null,"¼l½ /kkjk 89¼1½ ds vUrxZr iwoZ o\"kksZa ds ,fj;j ij iznÙk NwV dh x.kuk ,oa QkWeZ 10E dk vkWVkstusjs'ku"]
[]
[null,"¼n½ edku fdjk;k NwV ,oa N S C ij ns; C;kt dh x.kuk"]
[]
["3- izR;sd 'khV ij 'How to use' ls lEcfU/kr dqN fooj.k gS tks dk;Z djrs le; vki ds fy, lgk;d fl+) gksxkA"]
[]
["4- xr o\"kZ dbZ USERS }kjk eglwl dh x;h dfe;ksa ,oa fn, x, lq>koksa dk vf/kdre lekos'k djds iqu% vki yksxksa dh lqfo/kk ds fy, bls izLrqr fd;k tk jgk gSA "]
[]
["5- bl o\"kZ Hkh ;fn vki dksbZ ijs'kkuh eglwl djsa ;k dksbZ lq>ko nsuk pkgsa rks vkidk gkfnZd Lokxr gSA vki eq>s uhps fy[ks bZ&esy irs ij lEidZ dj ldrs gSaA ysfdu d`Ik;k Qksu ij lEidZ ugha djsaA  "]
[null,null,null,null,null,null,null,null,null,null,"Keshav Das Gupta\nLecturer (Biology)\nSwami Vivekanand Govt. Model School\nGangapur City, Distt. Sawai Madhopur (Rajasthan)\nkdgupta1971@gmail.com"]
["If any discrepancy is arise for income tax calculation (or any other calculation) by this program, I am not responsible for that. "]
[]
["6-;fn vki dk;Z djus ds ckn bl QkbZy dks vius uke ls Save djuk pkgsa rks \nSave as ij tkdj Excel Macro Enabled Workbook ds uke ls Save djsaA"]
[]
["LAST UPDATED",null,"2023-11-11"]
[]
["What's New:-"]
["08-11-2020"]
["1. New tax regime "]
["2. Adhoc bonus and CORONA donation updated."]
["16-01-2020"]
["1. US80EEA Max deduction of Rs. 150000/ allowed on interest payable on loan taken for residential house property under certain conditions."]
["12-11-2019"]
["1. Standard deduction has been raised from Rs 40000 to 50000 for salaried employees."]
["2. Rebate us 87A has been raised to 12500/. So there will be no tax if taxable income is <=5 lakhs.",null,null,null,null,null,null,null,null,null,"If taxable income is >5 lakhs then normal tax rates will be applicable. "]
["10-10-2018"]
["1. Standard deduction of Rs 40000 for salaried employees in lieu of transport allowance and medical reimbursement.  "]
["2. Health and Education Cess of 4% is introduced in place of Education Cess. "]
["28-11-2017 \n\n \n"]
["1. The tax rate for income between Rs 2.5 lakh to Rs 5 lakhs has been reduced to 5% from 10%."]
["2. The income tax rebate under section 87A has been reduced from Rs 5,000 to Rs 2,500. Also the eligibility of taxable income limit has been reduced from Rs 5 lakh to Rs 3.5 lakh."]
["3. Tax exemption under section 80CCG for RGESS (Rajiv Gandhi Equity Scheme) would NOT be available from FY 2017-18 on wards. "]
["4. Budget 2017 has bridged the gap between self-occupied and rented property by capping the deduction on home loan interest to Rs 2 lakh in both cases."]
["5. Budget 2017 has introduced 10% surcharge for people with taxable income of more than Rs 50 lakhs but less than Rs 1 crore. The surcharge of 15% on income above Rs 1 crore still applies."]

{"sheet":"profile","index":2,"n_rows":75,"n_cols":52,"rows_kept":75,"cut":false,"hidden":true,"merged":[[35,11,35,13],[33,18,33,19],[32,18,32,19],[24,5,24,6],[25,1,25,2],[31,16,31,17],[27,9,27,11],[29,16,29,17],[29,18,29,19],[30,18,30,19],[31,18,31,19],[23,1,23,2],[26,1,26,2],[29,10,29,11],[26,12,26,15],[26,16,26,19],[27,1,27,2],[27,3,27,4],[27,5,27,6],[27,7,27,8],[28,0,28,21],[26,3,26,4],[0,0,0,19],[1,0,1,19],[10,21,16,21],[34,8,34,10],[34,11,34,13],[34,5,34,6],[34,2,34,3],[30,12,30,13],[31,12,31,13],[33,12,33,13],[30,14,30,15],[31,14,31,15],[32,10,32,11],[32,12,32,13],[32,14,32,15],[32,16,32,17],[27,16,27,19],[30,16,30,17],[26,21,27,21],[25,5,25,6],[25,7,25,8],[27,12,27,15],[24,9,24,11],[31,10,31,11],[19,8,19,9],[48,0,48,19],[40,0,40,19],[44,0,44,19],[36,1,36,3],[36,4,36,7],[36,8,36,13],[33,10,33,11],[36,14,36,21],[34,14,34,21],[35,14,35,21],[33,14,33,15],[33,16,33,17],[37,16,37,19],[46,0,46,19],[38,0,38,19],[35,2,35,3],[35,5,35,6],[26,5,26,6],[26,7,26,8],[26,9,26,11],[35,8,35,10],[23,21,25,21],[42,0,43,19],[2,15,2,19],[3,5,3,9],[6,1,6,4],[6,5,6,9],[10,15,10,19],[10,9,10,14],[10,7,10,8],[10,3,10,6],[7,1,7,4],[7,5,7,9],[7,10,7,19],[8,5,8,9],[8,1,8,4],[8,10,8,19],[9,0,9,19],[10,1,10,2],[4,5,4,9],[4,10,4,19],[21,4,21,6],[25,12,25,15],[24,16,24,19],[25,3,25,4],[24,12,24,15],[30,10,30,11],[29,14,29,15],[29,12,29,13],[24,7,24,8],[15,7,16,8],[2,12,2,14],[18,13,18,16],[5,5,5,9],[5,1,5,4],[4,1,4,4],[21,10,21,11],[21,7,21,8],[23,7,23,8],[23,9,23,11],[23,12,23,15],[23,16,23,19],[20,0,20,21],[21,12,21,15],[21,16,21,19],[22,12,22,15],[22,7,22,8],[22,16,22,19],[22,1,22,2],[22,3,22,4],[22,5,22,6],[22,9,22,11],[23,3,23,4],[23,5,23,6],[19,10,19,12],[25,9,25,11],[3,1,3,4],[25,16,25,19],[24,1,24,2],[24,3,24,4],[11,17,11,19],[11,9,11,16],[11,7,11,8],[11,5,11,6],[11,3,11,4],[17,0,17,21],[15,0,16,0],[18,17,18,19],[18,4,18,5],[18,6,18,7],[12,17,12,19],[16,5,16,6],[15,5,15,6],[14,4,14,5],[12,3,12,4],[16,1,16,2],[15,1,15,2],[15,3,16,4],[19,13,19,16],[18,1,18,2],[2,1,2,11],[13,4,13,6],[19,6,19,7],[19,17,19,19],[19,1,19,2],[2,21,8,21],[18,10,18,12],[15,9,16,19],[13,7,13,12],[13,13,13,19],[14,1,14,3],[14,7,14,8],[11,1,11,2],[12,1,12,2],[12,7,12,8],[12,5,12,6],[12,9,12,16],[13,1,13,3],[18,8,18,9],[14,12,14,19],[14,9,14,11],[19,3,19,5]]}
["INCOME TAX CALCULATION FOR FINANCIAL YEAR 2023-2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700]
["Developed by Keshav Das Gupta, Lecturer (Biology), Swami Vivekanand Govt. Model School, Gangapur City                                                                                                                               Distt. Sawai Madhopur (Rajasthan)               ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1400]
[null,"GENERAL INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"How to use",null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2100]
["NAME","KESHAV DAS GUPTA",null,null,null,"PAN",null,null,null,null,"G","G","a","a","a",9,9,9,9,"b",4]
["DESIGNATION","LECTURER",null,null,null,"NAME OF OFFICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["TAX DEDUCTOR'S NAME",null,null,null,null,"TAX DEDUCTOR'S TAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
["TAX DEDUCTOR'S FATHER'S NAME",null,null,null,null,"TAX DEDUCTOR'S PAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
["TAX DEDUCTOR'S DESIGNATION","PRINCIPAL",null,null,null,"TAX DEDUCTOR'S OFFICE ADDRESS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
["YOUR BANK ACCOUNT NUMBER",null,null,null,null,"YOUR BANK BRANCH NAME",null,null,null,null,"STATE BANK OF INDIA, JAIPUR",null,null,null,null,null,null,null,null,null,9]
["INFORMATION ABOUT SALARY AND ALLOWANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["SALARY IN MARCH 2023\n(According 7th Pay Commission)                           ",null,null,"ewy osru esa dksbZ ifjorZu& , lh ih@vU;\n ¼badzhes.V ds vykok½ ¼ekg dk dzekad nsa½",null,null,null,null,null,"fn, x, ekg ds fy, ewy osru ",null,null,null,null,null,null,null,null,null,null,11]
["H  R  A                                     (Please select only one option)",";fn ,p vkj , dk Hkqxrku ugha gksrk gS rks lysDV djsa",null,null,null,"9 izfr'kr ,p vkj , ds fy, lysDV djsa",null,null,null,";fn vki t;iqj] tks/kiqj] vtesj] chdkusj ;k dksVk esa dk;Zjr gSa rks 18 izfr'kr ds fy, lysDV djsa",null,null,null,null,null,null,null,null,null,null,12]
["C C A                                    (Please select only one option)",";fn lh lh , dk Hkqxrku ugha gksrk gS rks lysDV djsa",null,null,null,"t;iqj ¼'kgjh½ ds fy, lysDV djssa",null,null,null,";fn vki vtesj] tks/kiqj] chdkusj ;k dksVk esa dk;Zjr gSa rks lysDV djsa",null,null,null,null,null,null,null,null,null,null,1]
["SURRENDER OF PL\n¼fdl ekg esa Hkqxrku fy;k½",null,null,null,null,null,null,"fdrus ekg ds fy, cksul feyk",null,null,null,null,null,null,null,null,null,null,null,null,2]
["FOR HRA EXEMPTION\n ¼okf\"kZd Hkqxrku fd, fdjk, dh jkf'k½",null,null,null,"HRA exemption amount",null,{"$f":"control!J3","v":0},"Rent receipt required for max. HRA exempt.",null,{"$f":"IF(B15>0,control!C23,\"0\")","v":"0"},null,null,"vU; HkRrksa dks lSysjh 'khV ij esU;qvyh HkjsaA",null,null,null,null,null,null,null,3]
[";fn fQDls'ku ,fj;j feyk gS rks ,fj;j dh dqy jkf'k fy[ksaA lEcfU/kr ,fj;j ij Vh Mh ,l dks uhps Hkjsa","FIXATION ARRIERS 1",null,"FILL TDS                          (ON ARRIERS 1) IN TDS SECTION BELOW",null,"FIX. ARRIERS 2",null,"FILL TDS                          (ON ARRIERS 2) IN TDS SECTION BELOW",null,";fn vki dks Mh , ,fj;j ,oa fQDls'ku ,fj;j ds vykok vU; dksbZ ,fj;j feyk gS rks d`i;k lsysjh 'khV dh 24 oha jkW esa esU;wvyh HkjsaA"]
[]
["OTHER INCOME"]
["INCOME FROM HOUSE PROPERTY","ANNUAL RENT RECEIVED ",null,null,"MUNICIPAL TAXES",null,null,null,"STANDARD DEDUCTION",null,{"$f":"ROUND((0.3*(D19-G19)),0)","v":0},null,null,"INTEREST ON BONDS"]
["INTEREST ON NSC                      (AUTOMATED FROM SHEET NSC INTEREST)",{"$f":"ROUND((SUM('nsc int'!E9:'nsc int'!E13))+SUM('nsc int'!G9:'nsc int'!G13)+SUM('nsc int'!I9:'nsc int'!I13)+SUM('nsc int'!E22:'nsc int'!E31)+SUM('nsc int'!G22:'nsc int'!G31)+SUM('nsc int'!K9:'nsc int'!K13)+SUM('nsc int'!M9:'nsc int'!M13)+SUM('nsc int'!O9:'nsc int'!O13)+SUM('nsc int'!Q9:'nsc int'!Q13)+SUM('nsc int'!S9:'nsc int'!S13)+SUM('nsc int'!I22:'nsc int'!I31)+SUM('nsc int'!U9:'nsc int'!U13)+SUM('nsc int'!W9:'nsc int'!W13),0)","v":0},null,"INTEREST ON FDR",null,null,null,null,"INTEREST ON SAVING ACCOUNT",null,null,null,null,"OTHER INCOME"]
["INVESTMENTS"]
["Are you recruited on or after 01.01.2004? If Yes, then select it.",null,"LIC PREMIUM (Deposited Directly)",null,"LIC PREMIUM FROM SALARY",null,null,null,null,"US 80CCD\n(1B)",null,null,"US80CCD(1)",null,null,null,null,null,null,null,null,"US80EEA"]
["HOME LOAN CAPITAL",null,null,"HOME LOAN INTEREST",null,null,null,"NSC INTEREST REINVESTMENT",null,{"$f":"ROUND((B20-'nsc int'!E13-'nsc int'!G13-'nsc int'!I13-'nsc int'!E31-'nsc int'!G31-'nsc int'!K13-'nsc int'!M13-'nsc int'!O13-'nsc int'!Q13-'nsc int'!S13-'nsc int'!I31-'nsc int'!U13-'nsc int'!W13),0)","v":0},null,null,"US 80 CCC"]
["NEW NSC PURCHASE",null,null,"PLI",null,null,null,"SUKANYA SMRIDDHI YOJNA",null,null,null,null,"TUITION FEE",null,null,null,null,null,null,null,null,"GROUP PERSONAL ACCIDENT. INSURANCE PREMIUM\n"]
["EQUITY LINK SCHEME",null,null,"NOTIFIED BOND OF NABARD",null,null,null,"PPF",null,null,null,null,"ULIP"]
["FIXED DEPOSIT FOR FIVE YEAR OR MORE",null,null,"DEFERRED ANNUITY",null,null,null,"US 80 TTA",null,{"$f":"K20","v":0},null,null,"US 80 D"]
["US 80 DD",null,null,"US 80 DDB",null,null,null,"US 80 E",null,null,null,null,"US 80 GG",null,null,null,null,null,null,null,null,2100]
["US 80 G",null,null,"US 80 EE",null,null,null,"US 80 U",null,null,null,null,"REBATE\nUS 89 (1)"]
["TAX DEDUCTED AT SOURCE"]
["MONTH'S NAME","MARCH","APRIL","MAY","JUNE","JULY","AUG","SEPT","OCT","NOV","DEC",null,"JAN",null,"FEB",null,"TDS ON ARRIER 1",null,"TDS ON ARRIER   2",null,null,"TDS ON SURRENDER"]
["T D S AMOUNT"]
["Receipt Number of Form No. 24G"]
["DDO Serial Number in Form No. 24G"]
["DATE (dd.mm.yyyy)\n (Date of transfer voucher)"]
["Receipt Numbers of Original statements of TDS under sub-section (3) of section 200","QUARTER 1st",null,null,"QUARTER           2nd",null,null,"QUARTER 3rd",null,null,null,"QUARTER 4th"]
["Amount of tax deducted in respect of the employee","QUARTER 1st",null,null,"QUARTER           2nd",null,null,"QUARTER 3rd",null,null,null,"QUARTER 4th"]
["INCOME TAX BEFORE TDS",{"$f":"'I T cal.'!E47","v":0},null,null,"INCOME TAX AFTER TDS",null,null,null,{"$f":"IF('I T cal.'!E57=\"0\",'I T cal.'!E56,'I T cal.'!E57)","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back"]
["How to Use"]
[]
["1- izksQkby esa okafNr fooj.k HkjsaA ihyh lsYl] QkWeZ 16 ds fy, gSa] vr% ;fn vki dks QkWeZ 16 ugha fudkyuk gks rks ihyh lsYl ugha HkjsaA"]
[]
["2- ;fn vki edku fdjk, HkÙks dh NwV pkgrs gSa rks jkW ua- 15 esa lsy B15 esa vkidks okf\"kZd Hkqxrku fd, fdjk, dh jkf'k nsuh gSA lsy G15 vkidks ml jkf'k ij feyus okyh NwV dh jkf'k crk,xhA lsy J15 esa ml jkf'k dk izn'kZu gksrk gS ftl ij vkidks vf/kdre NwV feysxhA ;g vf/kdre NwV vkidks feyus okys edku fdjk, HkÙks dh okf\"kZd jkf'k ds cjkcj gksxhA ysfdu mDr izn'kZu lSysjh 'khV tusjs'ku ds ckn gh gksxkA  "]
[]
["3- lsy B20 o J23, tks NSC ij feyus okys C;kt ls lEcfU/kr gS] dks vkidks ugha Hkjuk gSA NSC ij C;kt x.kuk ds fy, vki 'nsc int' 'khV ij tk,a o okafNr izfof\"V;ka HkjsaA"]
[]
["4- bl 'khV ij fooj.k Hkjus ds i'pkr LVS.MMZ lSysjh 'khV izkIr djus ds fy, d`i;k lSysjh 'khV ij tkdj 'Generate Salary Sheet' cVu dks nckb;sA "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"TODAY()","v":"2023-11-11"},"2024-10-31"]

{"sheet":"control","index":3,"n_rows":31,"n_cols":24,"rows_kept":31,"cut":false,"hidden":true,"merged":[[25,0,25,1],[23,0,23,1],[23,2,23,4],[4,6,4,10],[4,11,4,13],[22,0,22,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[0,15,0,23],[0,0,0,14],[2,0,2,1],[3,4,3,5],[4,0,4,1],[4,2,4,3],[4,4,4,5],[2,2,2,5],[2,6,2,7]]}
["CONTROL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7TH PAY COMMISSION "]
["Sex",null,"Bonus",2,"Bonus months",12,"US 80G",1,"Salary Round   down",{"$f":"salary!C9*1.03","v":0},{"$f":"--ISNUMBER(FIND(0.1,J2))--ISNUMBER(FIND(0.2,J2))--ISNUMBER(FIND(0.3,J2))--ISNUMBER(FIND(0.4,J2))","v":0},"ACP MONTH",{"$f":"profile!H11","v":0},"Gr. ins.",{"$f":"IF(salary!C7>=700,profile!$V$27,\"0\")","v":"0"},null,"DA","HRA","CCA","CCA","CCA","GPF","GPF ","RPMF"]
[null,null,{"$f":"IF(D2=2,0,ROUND((6774*F2/12),0))","v":0},null,null,null,{"$f":"ROUND(IF(H2=1,profile!B28/2,profile!B28),0)","v":0},null,"HRA exemption",{"$f":"IF('HRA ex.'!H11>0,'HRA ex.'!H11,0)","v":0},null,"7th Pay Month",{"$f":"profile!V13","v":0},"7th Pay Salary",{"$f":"profile!V16","v":0},"OCT",{"$f":"ROUND((salary!C13*0.05),0)","v":0},{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,8%*salary!C13,IF($D$6=TRUE,16%*salary!C13,\"0\"))),0)","v":0},{"$f":"IF(salary!C13>23100,1000,IF(salary!C13>=17700,620,0))","v":0},{"$f":"IF(salary!C13>23100,620,IF(salary!C13>=17700,320,0))","v":0},{"$f":"ROUND(IF($D$4=TRUE,\"0\",IF($E$6=TRUE,S3,IF($F$6=TRUE,T3,\"0\"))),0)","v":0},{"$f":"IF(salary!C13>80000,\"5200\",IF(salary!C13>72000,\"4100\",IF(salary!C13>62000,\"3300\",IF(salary!C13>51500,\"2100\",IF(salary!C13>38500,\"1450\",IF(salary!C13>28500,\"1100\",IF(salary!C13>23100,\"650\",IF(salary!C13>=17700,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C13>167000,\"6200\",IF(salary!C13>116000,\"5700\",V3))","v":"0"},{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C13>54000,\"680\",IF(salary!C13>33500,\"511\",IF(salary!C13>18000,\"341\",IF(salary!C13>=17700,\"205\",\"0\")))))","v":"0"}]
["NO HRA",false,"NO CCA",true,null,null,"CPF",true,"SURRENDER",{"$f":"profile!B14","v":0},{"$f":"ROUND(IF(J4=3,salary!C6/2,IF(J4=4,salary!C7/2,IF(J4=5,salary!C8/2,IF(J4=6,salary!C9/2,IF(J4=7,salary!C10/2,IF(J4=8,salary!C11/2,IF(J4=9,salary!C12/2))))))),0)","v":0},{"$f":"ROUND(IF(J4=10,salary!C13/2,IF(J4=11,salary!C14/2,IF(J4=12,salary!C15/2,IF(J4=1,salary!C16/2,IF(J4=2,salary!C17/2))))),0)","v":0},{"$f":"IF(OR(J4>9,J4=1,J4=2),L4,IF(J4>2,K4,\"0\"))","v":"0"},{"$f":"ROUND(IF(OR(J4>10,J4=1,J4=2),M4*0.46,IF(J4>=4,M4*0.42,IF(J4=3,M4*0.38,\"0\"))),0)","v":0},null,"NOV",{"$f":"ROUND((salary!C14*0.05),0)","v":0},{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,8%*salary!C14,IF($D$6=TRUE,16%*salary!C14,\"0\"))),0)","v":0},{"$f":"IF(salary!C14>23100,1000,IF(salary!C14>=17700,620,0))","v":0},{"$f":"IF(salary!C14>23100,620,IF(salary!C14>=17700,320,0))","v":0},{"$f":"ROUND(IF($D$4=TRUE,\"0\",IF($E$6=TRUE,S4,IF($F$6=TRUE,T4,\"0\"))),0)","v":0},{"$f":"IF(salary!C14>80000,\"5200\",IF(salary!C14>72000,\"4100\",IF(salary!C14>62000,\"3300\",IF(salary!C14>51500,\"2100\",IF(salary!C14>38500,\"1450\",IF(salary!C14>28500,\"1100\",IF(salary!C14>23100,\"650\",IF(salary!C14>=17700,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C14>167000,\"6200\",IF(salary!C14>116000,\"5700\",V4))","v":"0"},{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C14>54000,\"680\",IF(salary!C14>33500,\"511\",IF(salary!C14>18000,\"341\",IF(salary!C14>=17700,\"205\",\"0\")))))","v":"0"}]
["Salary",null,"HRA",null,"CCA",null,"G P F / C P F",null,null,null,null,"S I",null,null,"GPF 2004","DEC",{"$f":"ROUND((salary!C15*0.05),0)","v":0},{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,8%*salary!C15,IF($D$6=TRUE,16%*salary!C15,\"0\"))),0)","v":0},{"$f":"IF(salary!C15>23100,1000,IF(salary!C15>=17700,620,0))","v":0},{"$f":"IF(salary!C15>23100,620,IF(salary!C15>=17700,320,0))","v":0},0,{"$f":"IF(salary!C15>80000,\"5200\",IF(salary!C15>72000,\"4100\",IF(salary!C15>62000,\"3300\",IF(salary!C15>51500,\"2100\",IF(salary!C15>38500,\"1450\",IF(salary!C15>28500,\"1100\",IF(salary!C15>23100,\"650\",IF(salary!C15>=17700,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C15>167000,\"6200\",IF(salary!C15>116000,\"5700\",V5))","v":"0"},{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C15>54000,\"680\",IF(salary!C15>33500,\"511\",IF(salary!C15>18000,\"341\",IF(salary!C15>=17700,\"205\",\"0\")))))","v":"0"}]
[null,"Month",true,false,false,false,null,{"$f":"IF(salary!C6>80000,\"6150\",IF(salary!C6>72000,\"4800\",IF(salary!C6>62000,\"4200\",IF(salary!C6>51500,\"3575\",IF(salary!C6>38500,\"2850\",IF(salary!C6>28500,\"2100\",IF(salary!C6>23100,\"1625\",IF(salary!C6>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C6>167000,\"10500\",IF(salary!C6>116000,\"8900\",H6))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,I6,I6),0)","v":0},null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},3,null,"JAN",{"$f":"ROUND((salary!C16*0.05),0)","v":0},{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,8%*salary!C16,IF($D$6=TRUE,16%*salary!C16,\"0\"))),0)","v":0},{"$f":"IF(salary!C16>23100,1000,IF(salary!C16>=17700,620,0))","v":0},{"$f":"IF(salary!C16>23100,620,IF(salary!C16>=17700,320,0))","v":0},0,{"$f":"IF(salary!C16>80000,\"5200\",IF(salary!C16>72000,\"4100\",IF(salary!C16>62000,\"3300\",IF(salary!C16>51500,\"2100\",IF(salary!C16>38500,\"1450\",IF(salary!C16>28500,\"1100\",IF(salary!C16>23100,\"650\",IF(salary!C16>=17700,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C16>167000,\"6200\",IF(salary!C16>116000,\"5700\",V6))","v":"0"},{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C16>54000,\"680\",IF(salary!C16>33500,\"511\",IF(salary!C16>18000,\"341\",IF(salary!C16>=17700,\"205\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=3,profile!$P$11,profile!$B$11)","v":0},3,null,null,null,null,null,{"$f":"IF(salary!C7>80000,\"6150\",IF(salary!C7>72000,\"4800\",IF(salary!C7>62000,\"4200\",IF(salary!C7>51500,\"3575\",IF(salary!C7>38500,\"2850\",IF(salary!C7>28500,\"2100\",IF(salary!C7>23100,\"1625\",IF(salary!C7>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C7>167000,\"10500\",IF(salary!C7>116000,\"8900\",H7))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,I7,I7),0)","v":0},null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},4,null,"FEB",{"$f":"ROUND((salary!C17*0.05),0)","v":0},{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,8%*salary!C17,IF($D$6=TRUE,16%*salary!C17,\"0\"))),0)","v":0},{"$f":"IF(salary!C17>23100,1000,IF(salary!C17>=17700,620,0))","v":0},{"$f":"IF(salary!C17>23100,620,IF(salary!C17>=17700,320,0))","v":0},0,{"$f":"IF(salary!C17>80000,\"5200\",IF(salary!C17>72000,\"4100\",IF(salary!C17>62000,\"3300\",IF(salary!C17>51500,\"2100\",IF(salary!C17>38500,\"1450\",IF(salary!C17>28500,\"1100\",IF(salary!C17>23100,\"650\",IF(salary!C17>=17700,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C17>167000,\"6200\",IF(salary!C17>116000,\"5700\",V7))","v":"0"},{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C17>54000,\"680\",IF(salary!C17>33500,\"511\",IF(salary!C17>18000,\"341\",IF(salary!C17>=17700,\"205\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=4,profile!$P$11,A7)","v":0},4,null,null,null,null,null,{"$f":"IF(salary!C8>80000,\"6150\",IF(salary!C8>72000,\"4800\",IF(salary!C8>62000,\"4200\",IF(salary!C8>51500,\"3575\",IF(salary!C8>38500,\"2850\",IF(salary!C8>28500,\"2100\",IF(salary!C8>23100,\"1625\",IF(salary!C8>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C8>167000,\"10500\",IF(salary!C8>116000,\"8900\",H8))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,I8,I8),0)","v":0},null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},5]
[{"$f":"IF($M$2=5,profile!$P$11,A8)","v":0},5,null,null,null,null,null,{"$f":"IF(salary!C9>80000,\"6150\",IF(salary!C9>72000,\"4800\",IF(salary!C9>62000,\"4200\",IF(salary!C9>51500,\"3575\",IF(salary!C9>38500,\"2850\",IF(salary!C9>28500,\"2100\",IF(salary!C9>23100,\"1625\",IF(salary!C9>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C9>167000,\"10500\",IF(salary!C9>116000,\"8900\",H9))","v":"0"},null,0,null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},6]
[{"$f":"IF($M$2=6,profile!$P$11,A9)","v":0},6,null,null,null,null,null,{"$f":"IF(salary!C10>80000,\"6150\",IF(salary!C10>72000,\"4800\",IF(salary!C10>62000,\"4200\",IF(salary!C10>51500,\"3575\",IF(salary!C10>38500,\"2850\",IF(salary!C10>28500,\"2100\",IF(salary!C10>23100,\"1625\",IF(salary!C10>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C10>167000,\"10500\",IF(salary!C10>116000,\"8900\",H10))","v":"0"},null,0,null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},7]
[{"$f":"IF($M$2=7,profile!$P$11,ROUND((salary!C9*1.03),-2))","v":0},7,null,null,null,null,null,{"$f":"IF(salary!C11>80000,\"6150\",IF(salary!C11>72000,\"4800\",IF(salary!C11>62000,\"4200\",IF(salary!C11>51500,\"3575\",IF(salary!C11>38500,\"2850\",IF(salary!C11>28500,\"2100\",IF(salary!C11>23100,\"1625\",IF(salary!C11>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C11>167000,\"10500\",IF(salary!C11>116000,\"8900\",H11))","v":"0"},null,0,null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},8]
[{"$f":"IF($M$2=8,profile!$P$11,A11)","v":0},8,null,null,null,null,null,{"$f":"IF(salary!C12>80000,\"6150\",IF(salary!C12>72000,\"4800\",IF(salary!C12>62000,\"4200\",IF(salary!C12>51500,\"3575\",IF(salary!C12>38500,\"2850\",IF(salary!C12>28500,\"2100\",IF(salary!C12>23100,\"1625\",IF(salary!C12>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C12>167000,\"10500\",IF(salary!C12>116000,\"8900\",H12))","v":"0"},null,0,null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},9]
[{"$f":"IF($M$2=9,profile!$P$11,A12)","v":0},9,null,null,null,null,null,{"$f":"IF(salary!C13>80000,\"6150\",IF(salary!C13>72000,\"4800\",IF(salary!C13>62000,\"4200\",IF(salary!C13>51500,\"3575\",IF(salary!C13>38500,\"2850\",IF(salary!C13>28500,\"2100\",IF(salary!C13>23100,\"1625\",IF(salary!C13>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C13>167000,\"10500\",IF(salary!C13>116000,\"8900\",H13))","v":"0"},null,0,null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},10,null,{"$f":"ROUND((salary!C13*0.05),0)","v":0},"Bonus GPF"]
[{"$f":"IF($M$2=10,profile!$P$11,A13)","v":0},10,null,null,null,null,null,{"$f":"IF(salary!C14>80000,\"6150\",IF(salary!C14>72000,\"4800\",IF(salary!C14>62000,\"4200\",IF(salary!C14>51500,\"3575\",IF(salary!C14>38500,\"2850\",IF(salary!C14>28500,\"2100\",IF(salary!C14>23100,\"1625\",IF(salary!C14>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C14>167000,\"10500\",IF(salary!C14>116000,\"8900\",H14))","v":"0"},null,0,null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},11,null,{"$f":"ROUND((salary!C14*0.05),0)","v":0},{"$f":"IF($H$4=TRUE,ROUND((C3*0.25),0),ROUND((C3*0.25),0))","v":0}]
[{"$f":"IF($M$2=11,profile!$P$11,A14)","v":0},11,null,null,null,null,null,{"$f":"IF(salary!C15>80000,\"6150\",IF(salary!C15>72000,\"4800\",IF(salary!C15>62000,\"4200\",IF(salary!C15>51500,\"3575\",IF(salary!C15>38500,\"2850\",IF(salary!C15>28500,\"2100\",IF(salary!C15>23100,\"1625\",IF(salary!C15>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C15>167000,\"10500\",IF(salary!C15>116000,\"8900\",H15))","v":"0"},null,0,null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},12,null,{"$f":"ROUND((salary!C15*0.05),0)","v":0},"Bonus GPF 2004"]
[{"$f":"IF($M$2=12,profile!$P$11,A15)","v":0},12,null,null,null,null,null,{"$f":"IF(salary!C16>80000,\"6150\",IF(salary!C16>72000,\"4800\",IF(salary!C16>62000,\"4200\",IF(salary!C16>51500,\"3575\",IF(salary!C16>38500,\"2850\",IF(salary!C16>28500,\"2100\",IF(salary!C16>23100,\"1625\",IF(salary!C16>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C16>167000,\"10500\",IF(salary!C16>116000,\"8900\",H16))","v":"0"},null,0,null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},1,null,{"$f":"ROUND((salary!C16*0.05),0)","v":0},{"$f":"IF($H$4=TRUE,0,0)","v":0}]
[{"$f":"IF($M$2=1,profile!$P$11,A16)","v":0},1,null,null,null,null,null,{"$f":"IF(salary!C17>80000,\"6150\",IF(salary!C17>72000,\"4800\",IF(salary!C17>62000,\"4200\",IF(salary!C17>51500,\"3575\",IF(salary!C17>38500,\"2850\",IF(salary!C17>28500,\"2100\",IF(salary!C17>23100,\"1625\",IF(salary!C17>=17700,\"1450\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C17>167000,\"10500\",IF(salary!C17>116000,\"8900\",H17))","v":"0"},null,0,null,{"$f":"IF(profile!$B$11>72000,\"5000\",IF(profile!$B$11>46500,\"3000\",IF(profile!$B$11>28500,\"2200\",IF(profile!$B$11>22000,\"1200\",IF(profile!$B$11>=17700,\"800\",\"0\")))))","v":"0"},2,null,{"$f":"ROUND((salary!C17*0.05),0)","v":0}]
[{"$f":"IF($M$2=2,profile!$P$11,A17)","v":0},2]
["PAN OF EMPLOYEE",null,{"$f":"UPPER(CONCATENATE(profile!K4,profile!L4,profile!M4,profile!N4,profile!O4,profile!P4,profile!Q4,profile!R4,profile!S4,profile!T4))","v":"GGAAA9999B"},null,null,"HRA","CCA","CCA","CCA","D A ","D A Arr.","RPMF"]
["PAN OF EMPLOYER",null,{"$f":"UPPER(CONCATENATE(profile!K7,profile!L7,profile!M7,profile!N7,profile!O7,profile!P7,profile!Q7,profile!R7,profile!S7,profile!T7))","v":""},null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C6,IF($D$6=TRUE,18%*salary!C6,\"0\"))),0)","v":0},{"$f":"IF(salary!C6>23100,1000,IF(salary!C6>=17700,620,0))","v":0},{"$f":"IF(salary!C6>23100,620,IF(salary!C6>=17700,320,0))","v":0},{"$f":"ROUND(IF($D$4=TRUE,\"0\",IF($E$6=TRUE,G20,IF($F$6=TRUE,H20,\"0\"))),0)","v":0},{"$f":"ROUND((salary!C6*0.38),0)","v":0},{"$f":"ROUND((salary!C6*0.04),0)*3+ROUND(IF(J4=3,M4*0.04),0)","v":0},{"$f":"IF(salary!C6>54000,\"875\",IF(salary!C6>33500,\"658\",IF(salary!C6>18000,\"440\",IF(salary!C6>=17700,\"265\",\"0\"))))","v":"0"},"March"]
["TAN OF EMPLOYER",null,{"$f":"UPPER(CONCATENATE(profile!K6,profile!L6,profile!M6,profile!N6,profile!O6,profile!P6,profile!Q6,profile!R6,profile!S6,profile!T6))","v":""},null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C7,IF($D$6=TRUE,18%*salary!C7,\"0\"))),0)","v":0},{"$f":"IF(salary!C7>23100,1000,IF(salary!C7>=17700,620,0))","v":0},{"$f":"IF(salary!C7>23100,620,IF(salary!C7>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C7*0.42),0)","v":0},{"$f":"IF($H$4=TRUE,K20,K20)","v":0},{"$f":"IF(salary!C7>54000,\"875\",IF(salary!C7>33500,\"658\",IF(salary!C7>18000,\"440\",IF(salary!C7>=17700,\"265\",\"0\"))))","v":"0"},"April"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C8,IF($D$6=TRUE,18%*salary!C8,\"0\"))),0)","v":0},{"$f":"IF(salary!C8>23100,1000,IF(salary!C8>=17700,620,0))","v":0},{"$f":"IF(salary!C8>23100,620,IF(salary!C8>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C8*0.42),0)","v":0},{"$f":"ROUND((salary!C10*0.04),0)+ROUND((salary!C11*0.04),0)+ROUND((salary!C12*0.04),0)+ROUND((salary!C13*0.04),0)+ROUND(IF(OR(J4=7,J4=8,J4=9,J4=10),M4*0.04),0)","v":0},{"$f":"IF(salary!C8>54000,\"875\",IF(salary!C8>33500,\"658\",IF(salary!C8>18000,\"440\",IF(salary!C8>=17700,\"265\",\"0\"))))","v":"0"},"May"]
["HRA rent receipt req",null,{"$f":"ROUND((10%*(ROUND((salary!C6*0.42),0)+ROUND((salary!C7*0.42),0)+ROUND((salary!C8*0.42),0)+ROUND((salary!C9*0.42),0)+ROUND((salary!C10*0.46),0)+ROUND((salary!C11*0.46),0)+ROUND((salary!C12*0.46),0)+ROUND((salary!C13*0.46),0)+ROUND((salary!C14*0.46),0)+ROUND((salary!C15*0.46),0)+ROUND((salary!C16*0.46),0)+ROUND((salary!C17*0.46),0)+SUM(salary!C6:'salary'!C17))+salary!E25),0)","v":0},null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C9,IF($D$6=TRUE,18%*salary!C9,\"0\"))),0)","v":0},{"$f":"IF(salary!C9>23100,1000,IF(salary!C9>=17700,620,0))","v":0},{"$f":"IF(salary!C9>23100,620,IF(salary!C9>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C9*0.42),0)","v":0},{"$f":"IF($H$4=TRUE,K22,K22)","v":0},{"$f":"IF(salary!C9>54000,\"875\",IF(salary!C9>33500,\"658\",IF(salary!C9>18000,\"440\",IF(salary!C9>=17700,\"265\",\"0\"))))","v":"0"},"June",null,null,null,null,null,null," "]
["US 80 CCD(1)",null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C10,IF($D$6=TRUE,18%*salary!C10,\"0\"))),0)","v":0},{"$f":"IF(salary!C10>23100,1000,IF(salary!C10>=17700,620,0))","v":0},{"$f":"IF(salary!C10>23100,620,IF(salary!C10>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C10*0.42),0)","v":0},{"$f":"IF($H$4=TRUE,(K22-K23),\"0\")","v":0},{"$f":"IF(salary!C10>54000,\"875\",IF(salary!C10>33500,\"658\",IF(salary!C10>18000,\"440\",IF(salary!C10>=17700,\"265\",\"0\"))))","v":"0"},"July"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C11,IF($D$6=TRUE,18%*salary!C11,\"0\"))),0)","v":0},{"$f":"IF(salary!C11>23100,1000,IF(salary!C11>=17700,620,0))","v":0},{"$f":"IF(salary!C11>23100,620,IF(salary!C11>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C11*0.42),0)","v":0},null,{"$f":"IF(salary!C11>54000,\"875\",IF(salary!C11>33500,\"658\",IF(salary!C11>18000,\"440\",IF(salary!C11>=17700,\"265\",\"0\"))))","v":"0"},"August"]
["TAX REGIME",null,2,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C12,IF($D$6=TRUE,18%*salary!C12,\"0\"))),0)","v":0},{"$f":"IF(salary!C12>23100,1000,IF(salary!C12>=17700,620,0))","v":0},{"$f":"IF(salary!C12>23100,620,IF(salary!C12>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C12*0.42),0)","v":0},"D A Arr. For GPF2004",{"$f":"IF(salary!C12>54000,\"875\",IF(salary!C12>33500,\"658\",IF(salary!C12>18000,\"440\",IF(salary!C12>=17700,\"265\",\"0\"))))","v":"0"},"Sept"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C13,IF($D$6=TRUE,18%*salary!C13,\"0\"))),0)","v":0},{"$f":"IF(salary!C13>23100,1000,IF(salary!C13>=17700,620,0))","v":0},{"$f":"IF(salary!C13>23100,620,IF(salary!C13>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C13*0.42),0)","v":0},{"$f":"IF($H$4=TRUE,K20,0)","v":0},{"$f":"IF(salary!C13>54000,\"875\",IF(salary!C13>33500,\"658\",IF(salary!C13>18000,\"440\",IF(salary!C13>=17700,\"265\",\"0\"))))","v":"0"},"Oct"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C14,IF($D$6=TRUE,18%*salary!C14,\"0\"))),0)","v":0},{"$f":"IF(salary!C14>23100,1000,IF(salary!C14>=17700,620,0))","v":0},{"$f":"IF(salary!C14>23100,620,IF(salary!C14>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C14*0.46),0)","v":0},{"$f":"IF($H$4=TRUE,K22,0)","v":0},{"$f":"IF(salary!C14>54000,\"875\",IF(salary!C14>33500,\"658\",IF(salary!C14>18000,\"440\",IF(salary!C14>=17700,\"265\",\"0\"))))","v":"0"},"Nov"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C15,IF($D$6=TRUE,18%*salary!C15,\"0\"))),0)","v":0},{"$f":"IF(salary!C15>23100,1000,IF(salary!C15>=17700,620,0))","v":0},{"$f":"IF(salary!C15>23100,620,IF(salary!C15>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C15*0.46),0)","v":0},null,{"$f":"IF(salary!C15>54000,\"875\",IF(salary!C15>33500,\"658\",IF(salary!C15>18000,\"440\",IF(salary!C15>=17700,\"265\",\"0\"))))","v":"0"},"Dec"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C16,IF($D$6=TRUE,18%*salary!C16,\"0\"))),0)","v":0},{"$f":"IF(salary!C16>23100,1000,IF(salary!C16>=17700,620,0))","v":0},{"$f":"IF(salary!C16>23100,620,IF(salary!C16>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C16*0.46),0)","v":0},null,{"$f":"IF(salary!C16>54000,\"875\",IF(salary!C16>33500,\"658\",IF(salary!C16>18000,\"440\",IF(salary!C16>=17700,\"265\",\"0\"))))","v":"0"},"Jan"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,9%*salary!C17,IF($D$6=TRUE,18%*salary!C17,\"0\"))),0)","v":0},{"$f":"IF(salary!C17>23100,1000,IF(salary!C17>=17700,620,0))","v":0},{"$f":"IF(salary!C17>23100,620,IF(salary!C17>=17700,320,0))","v":0},0,{"$f":"ROUND((salary!C17*0.46),0)","v":0},null,{"$f":"IF(salary!C17>54000,\"875\",IF(salary!C17>33500,\"658\",IF(salary!C17>18000,\"440\",IF(salary!C17>=17700,\"265\",\"0\"))))","v":"0"},"Feb"]

{"sheet":"Partial HRA","index":4,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":true,"merged":[[15,5,15,10],[2,1,2,10],[13,6,13,8],[12,6,12,8],[8,6,8,8],[9,6,9,8],[3,6,4,9],[5,6,6,9]]}
[]
[]
[null,"PARTIAL HRA EXEMPTION WORK SHEET",null,null,null,null,null,null,null,null,null,"7th Pay"]
[null,"MONTHS","\"Y\"","Basic Pay.","HRA",null,"Please select months by typing \"Y\" "]
[null,"MARCH 23","y",{"$f":"IF(C5=\"Y\",salary!C6+ROUND((42%*salary!C6),0),\"0\")","v":0},{"$f":"IF(C5=\"Y\",salary!E6,\"0\")","v":0},null,null,null,null,null,null,null,"  "]
[null,"APRIL 23","y",{"$f":"IF(C6=\"Y\",salary!C7+ROUND((42%*salary!C7),0),\"0\")","v":0},{"$f":"IF(C6=\"Y\",salary!E7,\"0\")","v":0},null,"After selecting months, give rent paid amount. "]
[null,"MAY 23","y",{"$f":"IF(C7=\"Y\",salary!C8+ROUND((42%*salary!C8),0),\"0\")","v":0},{"$f":"IF(C7=\"Y\",salary!E8,\"0\")","v":0}]
[null,"JUNE 23","y",{"$f":"IF(C8=\"Y\",salary!C9+ROUND((42%*salary!C9),0),\"0\")","v":0},{"$f":"IF(C8=\"Y\",salary!E9,\"0\")","v":0}]
[null,"JULY 23","y",{"$f":"IF(C9=\"Y\",salary!C10+ROUND((46%*salary!C10),0),\"0\")","v":0},{"$f":"IF(C9=\"Y\",salary!E10,\"0\")","v":0},null,"RENT PAID AMOUNT"]
[null,"AUGUST 23","y",{"$f":"IF(C10=\"Y\",salary!C11+ROUND((46%*salary!C11),0),\"0\")","v":0},{"$f":"IF(C10=\"Y\",salary!E11,\"0\")","v":0},null,"HRA EXEMPTION AMOUNT",null,null,{"$f":"IF('HRA ex.'!I11>0,'HRA ex.'!I11,\"0\")","v":"0"}]
[null,"SEPTEMBER 23","y",{"$f":"IF(C11=\"Y\",salary!C12+ROUND((46%*salary!C12),0),\"0\")","v":0},{"$f":"IF(C11=\"Y\",salary!E12,\"0\")","v":0}]
[null,"OCTOBER 23","y",{"$f":"IF(C12=\"Y\",salary!C13+ROUND((46%*salary!C13),0),\"0\")","v":0},{"$f":"IF(C12=\"Y\",salary!E13,\"0\")","v":0},null,null,null,null,null,null,{"$f":"IF(C12=\"Y\",salary!C13+ROUND((5%*salary!C13),0),\"0\")","v":0}]
[null,"NOVEMBER 23","y",{"$f":"IF(C13=\"Y\",salary!C14+ROUND((46%*salary!C14),0),\"0\")","v":0},{"$f":"IF(C13=\"Y\",salary!E14,\"0\")","v":0},null,"Max. HRA exemption amount ",null,null,{"$f":"E17","v":0},null,{"$f":"IF(C13=\"Y\",salary!C14+ROUND((5%*salary!C14),0),\"0\")","v":0}]
[null,"DECEMBER 23","y",{"$f":"IF(C14=\"Y\",salary!C15+ROUND((46%*salary!C15),0),\"0\")","v":0},{"$f":"IF(C14=\"Y\",salary!E15,\"0\")","v":0},null,"Rent receipt required for max. exemption",null,null,{"$f":"ROUND(((10%*D17)+E17),0)","v":0},null,{"$f":"IF(C14=\"Y\",salary!C15+ROUND((5%*salary!C15),0),\"0\")","v":0}]
[null,"JANUARY 24","y",{"$f":"IF(C15=\"Y\",salary!C16+ROUND((46%*salary!C16),0),\"0\")","v":0},{"$f":"IF(C15=\"Y\",salary!E16,\"0\")","v":0},null,null,null,null,null,null,{"$f":"IF(C15=\"Y\",salary!C16+ROUND((5%*salary!C16),0),\"0\")","v":0}]
[null,"FEBRUARY 24","y",{"$f":"IF(C16=\"Y\",salary!C17+ROUND((46%*salary!C17),0),\"0\")","v":0},{"$f":"IF(C16=\"Y\",salary!E17,\"0\")","v":0},"IF YOU ARE NOT ELIGIBLE TO GET HRA EXEMPTION FOR COMPLETE YEAR THEN USE THIS SHEET",null,null,null,null,null,{"$f":"IF(C16=\"Y\",salary!C17+ROUND((5%*salary!C17),0),\"0\")","v":0}]
[null,null,null,{"$f":"ROUND((SUM(D5:D16)),0)","v":0},{"$f":"ROUND((SUM(E5:E16)),0)","v":0}]

{"sheet":"salary","index":5,"n_rows":110,"n_cols":27,"rows_kept":110,"cut":false,"hidden":true,"merged":[[0,0,0,26],[1,7,1,11],[1,19,1,26],[1,0,1,6],[2,11,2,23],[2,25,3,25],[2,26,3,26],[2,0,3,0],[2,1,3,1],[2,2,2,10],[2,24,3,24],[36,0,36,25],[38,0,38,25],[29,7,30,18],[26,21,26,26],[26,13,26,17],[26,0,26,11],[32,0,32,25],[34,0,34,25]]}
["osru o dVkSfr;ksa dk fooj.k 2023 & 2024"]
[{"$f":"PROPER(IF(profile!B4=\"\",\"\",profile!B4))","v":"Keshav Das Gupta"},null,null,null,null,null,null,{"$f":"PROPER(IF(profile!B5=\"\",\"\",profile!B5))","v":"Lecturer"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"PROPER(IF(profile!K5=\"\",\"\",profile!K5))","v":""}]
["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",",fj;j","vU;","vU;",";ksx",{"$f":"IF(control!$H$4=TRUE,\"GPF 2004\",\"GPF\")","v":"GPF 2004"},"th ih ,Q _.k","jkT; chek",null,"jkT; chek _.k","RGHSF","L I C","lokjh vfxze","Hkou _.k","Hkou _.k C;kt","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&23",{"$f":"control!A7","v":0},{"$f":"control!J20","v":0},{"$f":"control!F20","v":0},{"$f":"control!I20","v":0},null,null,null,null,{"$f":"ROUND((C6+D6+E6+F6+G6+H6+I6+J6),0)","v":0},{"$f":"control!K6","v":0},null,{"$f":"control!M6","v":"0"},null,null,{"$f":"control!L20","v":"0"},{"$f":"profile!H22","v":0},null,null,null,{"$f":"profile!B31","v":0},null,{"$f":"L6+M6+N6+O6+P6+Q6+R6+S6+T6+U6+V6+W6","v":0},{"$f":"K6-X6","v":0}]
[2,"vizsy&23",{"$f":"control!A8","v":0},{"$f":"control!J21","v":0},{"$f":"control!F21","v":0},{"$f":"control!I21","v":0},null,null,null,null,0,{"$f":"control!K7","v":0},null,{"$f":"control!M7","v":"0"},null,null,{"$f":"control!L21","v":"0"},{"$f":"R6","v":0},null,null,null,{"$f":"profile!C31","v":0},{"$f":"control!O2","v":"0"},0,0]
[3,"ebZ&23",{"$f":"control!A9","v":0},{"$f":"control!J22","v":0},{"$f":"control!F22","v":0},{"$f":"control!I22","v":0},null,null,null,null,0,{"$f":"control!K8","v":0},null,{"$f":"control!M8","v":"0"},null,null,{"$f":"control!L22","v":"0"},{"$f":"R7","v":0},null,null,null,{"$f":"profile!D31","v":0},null,0,0]
[4,"twu&23",{"$f":"control!A10","v":0},{"$f":"control!J23","v":0},{"$f":"control!F23","v":0},{"$f":"control!I23","v":0},null,null,null,null,0,{"$f":"control!K9","v":0},null,{"$f":"control!M9","v":"0"},null,null,{"$f":"control!L23","v":"0"},0,null,null,null,{"$f":"profile!E31","v":0},null,0,0]
[5,"tqyk-&23",{"$f":"control!A11","v":0},{"$f":"control!J24","v":0},{"$f":"control!F24","v":0},{"$f":"control!I24","v":0},null,null,null,null,0,{"$f":"control!K10","v":0},null,{"$f":"control!M10","v":"0"},null,null,{"$f":"control!L24","v":"0"},0,null,null,null,{"$f":"profile!F31","v":0},null,0,0]
[6,"vx-&23",{"$f":"control!A12","v":0},{"$f":"control!J25","v":0},{"$f":"control!F25","v":0},{"$f":"control!I25","v":0},null,null,null,null,0,{"$f":"control!K11","v":0},null,{"$f":"control!M11","v":"0"},null,null,{"$f":"control!L25","v":"0"},0,null,null,null,{"$f":"profile!G31","v":0},null,0,0]
[7,"flr-&23",{"$f":"control!A13","v":0},{"$f":"control!J26","v":0},{"$f":"control!F26","v":0},{"$f":"control!I26","v":0},null,null,null,null,0,{"$f":"control!K12","v":0},null,{"$f":"control!M12","v":"0"},null,null,{"$f":"control!L26","v":"0"},0,null,null,null,{"$f":"profile!H31","v":0},null,0,0]
[8,"vDVw-&23",{"$f":"control!A14","v":0},{"$f":"control!J27","v":0},{"$f":"control!F27","v":0},{"$f":"control!I27","v":0},null,null,null,null,0,{"$f":"control!K13","v":0},null,{"$f":"control!M13","v":"0"},null,null,{"$f":"control!L27","v":"0"},0,null,null,null,{"$f":"profile!I31","v":0},null,0,0]
[9,"uo-&23",{"$f":"control!A15","v":0},{"$f":"control!J28","v":0},{"$f":"control!F28","v":0},{"$f":"control!I28","v":0},null,null,null,null,0,{"$f":"control!K14","v":0},null,{"$f":"control!M14","v":"0"},null,null,{"$f":"control!L28","v":"0"},0,null,null,null,{"$f":"profile!J31","v":0},null,0,0]
[10,"fnl-&23",{"$f":"control!A16","v":0},{"$f":"control!J29","v":0},{"$f":"control!F29","v":0},{"$f":"control!I29","v":0},null,null,null,null,0,{"$f":"control!K15","v":0},null,{"$f":"control!M15","v":"0"},null,null,{"$f":"control!L29","v":"0"},0,null,null,null,{"$f":"profile!K31","v":0},null,0,0]
[11,"tu-&24",{"$f":"control!A17","v":0},{"$f":"control!J30","v":0},{"$f":"control!F30","v":0},{"$f":"control!I30","v":0},null,null,null,null,0,{"$f":"control!K16","v":0},null,{"$f":"control!M16","v":"0"},null,null,{"$f":"control!L30","v":"0"},0,null,null,null,{"$f":"profile!M31","v":0},null,0,0]
[12,"Qj-&24",{"$f":"control!A18","v":0},{"$f":"control!J31","v":0},{"$f":"control!F31","v":0},{"$f":"control!I31","v":0},null,null,null,null,0,{"$f":"control!K17","v":0},null,{"$f":"control!M17","v":"0"},null,null,{"$f":"control!L31","v":"0"},0,null,null,null,{"$f":"profile!O31","v":0},null,0,0]
[13,"Mh , ,fj 1st",null,{"$f":"control!K20","v":0},null,null,null,null,null,null,0,{"$f":"control!K21","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0]
[14,"Mh , ,fj\n2nd",null,{"$f":"control!K22","v":0},null,null,null,null,null,null,0,{"$f":"control!K23","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0]
[15,"le- vo-",{"$f":"control!M4","v":"0"},{"$f":"control!N4","v":0},null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[16,"cksul",null,null,null,null,{"$f":"control!C3","v":0},null,null,null,0,{"$f":"control!Q14","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0]
[17,"fQDls ,fj",null,null,null,null,null,{"$f":"profile!B17","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"profile!Q31","v":0},null,0,0]
[18,"fQDls ,fj",null,null,null,null,null,{"$f":"profile!F17","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"profile!S31","v":0},null,0,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":"C6+C7+C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Prog. Dev. By- Keshav D. Gupta, Contact:-kdgupta1971@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 vkius Hkj fy;k gS rks LVs.MMZ lSysjh 'khV tusjsV djus ds fy, Åij fn;s x;s cVu 'Generate Salary Sheet' dks nckb;sA"]
[]
["2- LVS.MMZ lSysjh 'khV izkIr djus ds i'pkr vki viuh oS;fDrd vko';drkvksa ds vuqlkj blesa Modifications dj ldrs gSaA tSls G P F o  S I dh dVkSfr;ksa dks change dj ldrs gSaA fdUrq /;ku jgs] vkids }kjk ;fn bl 'khV ij dksbZ Hkh ifjorZu fd;k tkrk 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,axsaA ftu dkWye o jkW ds ysoy dk dyj xzhu gS vki muds ysoy vko';drk gksus ij change dj ldrs gSaA"]
[]
["3- iqu% u, O;fDr ds fy, LVS.MMZ lSysjh 'khV tusjsV djus ds fy, izksQkby ij fooj.k Hkjsa ,oa bl 'khV ij ekStwn cVu 'Generate Salary Sheet' dks nck,aA fizaV dek.M nsus ls igys fizaV fizO;w vo'; ns[ksa] ,oa mlh ist dks fizaV djsa ftldh vkidks vko';drk gSA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,0]

{"sheet":"HRA ex.","index":6,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":true,"merged":[[9,3,9,6],[10,3,10,6],[6,3,6,7],[7,3,7,6],[8,3,8,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"HRA exempted from income tax calculator",null,null,null,null,"Partial HRA exemption calculator"]
[null,null,null,"House Rent allowance received ( Annual )",null,null,null,{"$f":"salary!E25","v":0},{"$f":"'Partial HRA'!E17","v":0}]
[null,null,null,"Rent paid ( Annual )",null,null,null,{"$f":"profile!B15","v":0},{"$f":"'Partial HRA'!J9","v":0}]
[null,null,null,"Salary received ( Basic + DA )",null,null,null,{"$f":"ROUND((salary!C6*0.42),0)+ROUND((salary!C7*0.42),0)+ROUND((salary!C8*0.42),0)+ROUND((salary!C9*0.42),0)+ROUND((salary!C10*0.46),0)+ROUND((salary!C11*0.46),0)+ROUND((salary!C12*0.46),0)+ROUND((salary!C13*0.46),0)+ROUND((salary!C14*0.46),0)+ROUND((salary!C15*0.46),0)+ROUND((salary!C16*0.46),0)+ROUND((salary!C17*0.46),0)+SUM(salary!C6:'salary'!C17)","v":0},{"$f":"'Partial HRA'!D17","v":0}]
[null,null,null,"HRA exemption amount from IT",null,null,null,{"$f":"ROUND(IF((H9-10%*H10)<H8,H9-10%*H10,H8),0)","v":0},{"$f":"ROUND(IF((I9-10%*I10)<I8,I9-10%*I10,I8),0)","v":0}]

{"sheet":"I T cal.","index":7,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":true,"merged":[[35,0,35,3],[36,0,36,3],[37,0,37,3],[55,0,55,3],[38,0,38,3],[42,0,42,1],[42,2,42,3],[54,0,54,3],[56,0,56,3],[15,0,15,1],[17,0,17,1],[18,0,18,1],[26,0,26,4],[21,0,21,1],[22,0,22,1],[47,0,47,4],[39,0,39,3],[24,0,24,3],[45,0,45,3],[16,0,16,1],[44,0,44,3],[46,0,46,3],[43,0,43,2],[34,0,34,3],[14,7,19,9],[0,0,0,4],[2,1,2,2],[2,3,2,4],[1,2,1,4],[19,0,19,1],[7,4,8,4],[5,0,5,2],[3,1,3,2],[10,0,10,4],[13,0,13,3],[25,0,25,3],[3,6,8,9],[7,0,7,1],[32,0,32,3],[33,0,33,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[31,0,31,3],[27,0,27,3],[4,0,4,2],[20,0,20,1],[14,0,14,4],[23,0,23,1],[10,6,12,9],[14,6,19,6]]}
["vk;dj x.kuk i= ys[kk o\"kZ 2023&2024 dj fu/kkZj.k o\"kZ 2024&2025"]
[{"$f":"PROPER(IF(profile!B4=\"\",\"\",profile!B4))","v":"Keshav Das Gupta"},{"$f":"PROPER(IF(profile!B5=\"\",\"\",profile!B5))","v":"Lecturer"},{"$f":"PROPER(IF(profile!K5=\"\",\"\",profile!K5))","v":""}]
[{"$f":"CONCATENATE(\"PAN:-   \",control!C19)","v":"PAN:-   GGAAA9999B"},{"$f":"CONCATENATE(\"Bank Ac. No.:-  \",profile!B9)","v":"Bank Ac. No.:-  "},null,{"$f":"CONCATENATE(\"Name of Bank:-\",profile!K9)","v":"Name of Bank:-STATE BANK OF INDIA, JAIPUR"}]
["1- osru en esa vk; ¼HkÙkksa lfgr½",null,null,null,{"$f":"salary!K25","v":0},null,"xzhu dyj lsYl dks vko';drk gks rks esU;wvyh HkjysaA fizaV ysus ls igys fizaV fizO;w ns[kdj mlh ist dks fizaV djsa] ftldh vkidks vko';drk gSA"]
[";fn osru 150000 ls vf/kd gS rks /kkjk 17¼2½ ds varxZr izkIr lqfo/kk,a",null,null,0,{"$f":"E4+D5","v":0}]
["LVs.MMZ fMMD'ku ",null,null,{"$f":"IF(control!C26=2,50000,50000)","v":50000},{"$f":"IF(E5>D6,E5-D6,0)","v":0}]
["?kVkb;s& dVkSfr;ka US10 (13 A)",{"$f":"IF(control!C26=2,0,IF(control!J3>0,control!J3,IF('Partial HRA'!J10>0,'Partial HRA'!J10,\"0\")))","v":0},"US10 ",0,{"$f":"E6-(B7+D7)","v":0}]
["2- ¼1½ v/;k; IV C ds varxr vk;% ¼1½ Lo;a ds mi;ksx esa 'kwU; ",null,"¼2½ izkIr fdjk;k",{"$f":"profile!D19","v":0}]
["¼1½ x`gdj","(2) Standard Deduction","¼3½ _.k ij C;kt","¼4½ izkIr fdjk;k&¼;ksx 1 ls 3½"]
[{"$f":"profile!G19","v":0},{"$f":"profile!K19","v":0},{"$f":"profile!F23","v":0},{"$f":"D8-(A10+B10+C10)","v":0},{"$f":"E7+IF(AND(control!C26=2,D10<0),0,IF(AND(D10<0,ABS(D10)>200000),\"-200000\",D10))","v":0}]
["3- vU; óksrksa ls vk;%"]
["NSC ij C;kt","FDR ls C;kt","Bonds ls C;kt","cpr [kkrs ij C;kt","vU; vk;"]
[{"$f":"profile!B20","v":0},{"$f":"profile!G20","v":0},{"$f":"profile!R19","v":0},{"$f":"profile!K20","v":0},{"$f":"profile!R20","v":0}]
["ldy dqy vk; ",null,null,null,{"$f":"E10+A13+B13+C13+D13+E13","v":0}]
["v/;k; VI A ds vUrxZr dVkSfr;ka ",null,null,null,null,null,null,"u, vFkok iqjkus VSDl flLVe dk p;u djsa-"]
[{"$f":"IF(control!$H$4=TRUE,\"GPF 2004\",\"GPF\")","v":"GPF 2004"},null,{"$f":"IF(control!C26=2,0,IF(control!H4=TRUE,salary!L25,salary!L25))","v":0},"US 80CCD(1)",{"$f":"IF(control!C26=2,0,IF(profile!Q22<=150000,profile!Q22,150000))","v":0}]
["S I",null,{"$f":"IF(control!C26=2,0,salary!N25)","v":0},"Tuition fee: 2 children",{"$f":"IF(control!C26=2,0,profile!Q24)","v":0}]
["LIC",null,{"$f":"IF(control!C26=2,0,profile!D22+salary!R25)","v":0},"jk\"Vªh; cpr i= ",{"$f":"IF(control!C26=2,0,profile!B24)","v":0}]
["Gr. Acc. Ins.",null,{"$f":"IF(control!C26=2,0,salary!W7)","v":0},"jk\"Vªh; cpr i= ij vnÙk C;kt",{"$f":"IF(control!C26=2,0,profile!J23)","v":0}]
["ULIP",null,{"$f":"IF(control!C26=2,0,profile!Q25)","v":0},"bfDoVh fyad lsfoax Ldhe",{"$f":"IF(control!C26=2,0,profile!B25)","v":0}]
["Hkou _.k iquHkqZxrku ",null,{"$f":"IF(control!C26=2,0,profile!B23)","v":0},"LFkfxr okf\"kZdh",{"$f":"IF(control!C26=2,0,profile!F26)","v":0}]
["PPF",null,{"$f":"IF(control!C26=2,0,profile!J25)","v":0},"LFkkbZ tek 5 o\"kZ",{"$f":"IF(control!C26=2,0,profile!B26)","v":0}]
["PLI",null,{"$f":"IF(control!C26=2,0,profile!F24)","v":0},"lqdU;k le`f) ;kstuk",{"$f":"IF(control!C26=2,0,profile!J24)","v":0}]
["NOTIFIED BOND OF NABARD",null,{"$f":"IF(control!C26=2,0,profile!F25)","v":0},"US 80CCC",{"$f":"IF(control!C26=2,0,profile!Q23)","v":0}]
["TOTAL",null,null,null,{"$f":"IF(control!C26=2,0,SUM(E16:E24)+SUM(C16:C24))","v":0}]
["Qualifying Amount US80CCE (Max Rs 150000/)",null,null,null,{"$f":"IF(E25<=150000,E25,150000)","v":0}]
["vU; dVkSfr;ka "]
["US 80 EEA Max Rs 150000/",null,null,null,{"$f":"IF(control!C26=2,0,IF(profile!V23<=150000,profile!V23,150000))","v":0}]
["US 80D",null,null,null,{"$f":"IF(control!C26=2,0,profile!Q26)","v":0}]
["US 80DD",null,null,null,{"$f":"IF(control!C26=2,0,profile!B27)","v":0}]
["US 80DDB  (Patient suffering from Cancer, AIDS, Chronical renal failure, Thalassaemia etc.)",null,null,null,{"$f":"IF(control!C26=2,0,profile!F27)","v":0}]
["US 80 E",null,null,null,{"$f":"IF(control!C26=2,0,profile!J27)","v":0}]
["US 80G",null,null,null,{"$f":"IF(control!C26=2,0,control!G3)","v":0}]
["US 80GG ¼Hkqxrku fd, x, Hkou fdjk;s ds ckjs es dVkSrh] vf/kdre # 5000 rd½",null,null,null,{"$f":"IF(control!C26=2,0,IF(profile!Q27<=60000,profile!Q27,60000))","v":0}]
["US 80EE  ¼izFke vkoklh; ?kj gsrq fy, x, yksu ij C;kt dh vfrfjDr NwV] vf/kdre # 50000 rd½",null,null,null,{"$f":"IF(control!C26=2,0,IF(profile!F28<=50000,profile!F28,50000))","v":0}]
["US 80U",null,null,null,{"$f":"IF(control!C26=2,0,profile!J28)","v":0}]
["US 80 TTA",null,null,null,{"$f":"IF(control!C26=2,0,IF(profile!J26<=10000,profile!J26,10000))","v":0}]
["US 80 CCD (1B)",null,null,null,{"$f":"IF(control!C26=2,0,IF(profile!K22<=50000,profile!K22,50000))","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":0}]
["'kq) dj ;ksX; vk; ¼iw.kkZad esa½",null,null,null,{"$f":"ROUND((E14-E39),-1)","v":0}]
["TAX FOR MEN",null,{"$f":"ROUND(IF(E40<=300000,0,IF(E40<=600000,(E40-300000)*0.05,IF(E40<=900000,15000+(E40-600000)*0.1,IF(E40<=1200000,45000+(E40-900000)*0.15,IF(E40<=1500000,90000+(E40-1200000)*0.2,IF(E40>1500000,150000+(E40-1500000)*0.3,\"0\")))))),0)","v":0},{"$f":"IF(E40<=700000,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":0}]
["Tax Credit, Max Rs 25000/12500",null,{"$f":"IF(AND(E40<=700000,C41>=25000),C41-25000,IF(AND(E40<=700000,C41<25000),0,C41))","v":0},null,{"$f":"IF(AND(E40<=500000,E41>=12500),E41-12500,IF(AND(E40<=500000,E41<12500),0,E41))","v":0}]
[{"$f":"CONCATENATE(\"dqy vk;dj ns;rk\")","v":"dqy vk;dj ns;rk"},null,{"$f":"IF(E40<=350000,\"( With US 87A Tax Credit Max Rs 12500/)\",\"\")","v":"( With US 87A Tax Credit Max Rs 12500/)"},null,{"$f":"IF(control!C26=2,D41,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":"E43+E44","v":0}]
["REBATE US 89 (1)",null,null,null,{"$f":"profile!Q28","v":0}]
["dqy dj ns;rk",null,null,null,{"$f":"E45-E46","v":0}]
["óksr ij gqbZ dVkSrh"]
["ekpZ 2023",{"$f":"salary!V6+IF(profile!B14=3,salary!V20,0)","v":0},"flrEcj 2023",{"$f":"salary!V12+IF(profile!B14=9,salary!V20,0)","v":0},"fQDls'ku ,fj;j ls VhMh,l"]
["vizsy 2023",{"$f":"salary!V7+IF(profile!B14=4,salary!V20,0)","v":0},"vDVwcj 2023",{"$f":"salary!V13+IF(profile!B14=10,salary!V20,0)","v":0},{"$f":"salary!V22+salary!V23+salary!V24","v":0}]
["ebZ 2023",{"$f":"salary!V8+IF(profile!B14=5,salary!V20,0)","v":0},"uoEcj 2023",{"$f":"salary!V14+IF(profile!B14=11,salary!V20,0)","v":0}]
["twu 2023",{"$f":"salary!V9+IF(profile!B14=6,salary!V20,0)","v":0},"fnlEcj 2023",{"$f":"salary!V15+IF(profile!B14=12,salary!V20,0)","v":0}]
["tqykbZ 2023",{"$f":"salary!V10+IF(profile!B14=7,salary!V20,0)","v":0},"tuojh 2024",{"$f":"salary!V16+IF(profile!B14=1,salary!V20,0)","v":0}]
["vxLr 2023",{"$f":"salary!V11+IF(profile!B14=8,salary!V20,0)","v":0},"Qjojh 2024",{"$f":"salary!V17+IF(profile!B14=2,salary!V20,0)","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:-Keshav D. Gupta, Contact:-kdgupta1971@gmail.com",null,null,null,"gLrk{kj deZpkjh"]

{"sheet":"Form 16","index":8,"n_rows":176,"n_cols":17,"rows_kept":176,"cut":false,"hidden":true,"merged":[[175,0,175,4],[3,12,5,19],[107,0,107,4],[107,5,107,6],[120,0,120,4],[120,5,120,6],[120,7,120,8],[111,9,120,10],[119,0,119,4],[119,5,119,6],[119,7,119,8],[113,0,113,4],[113,5,113,6],[113,7,113,8],[109,0,109,4],[109,5,109,6],[109,7,109,8],[109,9,109,10],[110,0,110,4],[110,5,110,6],[110,7,110,8],[110,9,110,10],[114,0,114,4],[114,5,114,6],[114,7,114,8],[68,2,68,3],[68,5,68,10],[115,5,115,6],[115,7,115,8],[111,0,111,4],[111,5,111,6],[111,7,111,8],[106,5,106,6],[106,7,108,8],[108,0,108,4],[108,5,108,6],[112,0,112,4],[112,5,112,6],[112,7,112,8],[115,0,115,4],[95,0,95,4],[95,5,95,6],[95,7,105,8],[96,0,96,4],[96,5,96,6],[97,0,97,4],[97,5,97,6],[98,0,98,4],[118,0,118,4],[118,5,118,6],[118,7,118,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],[98,5,98,6],[102,0,102,4],[102,5,102,6],[103,0,103,4],[103,5,103,6],[104,0,104,4],[104,5,104,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],[65,0,65,10],[66,0,66,1],[66,2,66,3],[56,1,56,2],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[59,1,59,2],[59,3,59,10],[57,1,57,2],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[58,1,58,2],[58,3,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[64,0,64,10],[60,0,60,10],[61,1,61,3],[61,5,61,8],[61,9,61,10],[68,0,68,1],[66,4,66,10],[67,0,67,1],[67,4,67,10],[63,7,63,10],[106,0,106,4],[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],[94,0,94,4],[94,5,94,6],[94,7,94,8],[94,9,94,10],[86,9,86,10],[87,0,87,4],[87,9,90,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],[43,9,43,10],[46,1,46,2],[46,3,46,4],[46,5,46,6],[46,7,46,8],[49,1,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[47,1,47,2],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[48,1,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[46,9,46,10],[39,1,39,2],[39,3,39,10],[62,0,62,1],[62,2,62,4],[62,5,62,10],[63,2,63,6],[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],[40,0,40,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],[34,5,34,7],[34,8,34,10],[35,1,35,2],[35,5,35,7],[35,8,35,10],[36,5,36,7],[36,8,36,10],[38,1,38,2],[38,5,38,7],[38,8,38,10],[134,0,134,10],[131,0,131,10],[132,1,132,3],[132,5,132,8],[19,0,19,3],[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],[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],[132,9,132,10],[127,0,127,4],[138,2,138,3],[138,5,138,10],[154,0,158,10],[159,0,160,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],[133,0,133,1],[133,2,133,4],[133,5,133,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],[121,0,121,4],[121,5,121,6],[121,7,121,8],[121,9,121,10],[122,0,122,4],[122,9,122,10],[123,0,123,4],[123,9,123,10],[130,0,130,4],[130,9,130,10],[127,9,127,10],[128,0,128,4],[128,9,128,10],[129,0,129,4],[129,9,129,10],[124,0,124,4],[124,9,124,10],[125,0,125,4],[125,9,125,10],[126,0,126,4],[126,9,126,10],[124,5,124,6],[125,5,125,6],[124,7,124,8],[105,0,105,4],[105,5,105,6],[91,9,91,10],[92,0,92,4],[92,9,93,10],[93,0,93,4],[77,7,80,8],[78,0,78,2],[78,3,78,4],[79,0,79,2],[80,0,80,2],[80,5,80,6],[84,0,84,1],[84,2,84,4],[84,5,84,6],[88,0,88,3],[89,0,89,3],[90,0,90,3],[90,7,90,8],[85,0,85,4],[85,5,93,6],[85,7,85,8],[86,0,86,4],[86,7,89,8],[91,0,91,4],[91,7,93,8],[72,5,72,6],[73,0,73,4],[73,5,73,6],[74,0,74,4],[74,5,74,6],[75,0,75,4],[76,0,76,4],[76,7,76,8],[82,5,82,6],[76,5,76,6],[19,5,19,7],[19,8,19,10],[70,0,70,10],[71,0,71,4],[71,5,71,6],[71,7,74,8],[71,9,85,10],[72,0,72,4],[81,0,81,4],[81,7,81,8],[82,0,82,4],[83,0,83,1],[83,2,83,4],[83,5,83,6],[75,7,75,8],[77,0,77,4],[31,8,31,10],[36,1,36,2],[27,5,27,7],[27,8,27,10],[37,1,37,2],[37,5,37,7],[37,8,37,10],[34,1,34,2],[18,5,18,7],[18,8,18,10],[17,1,17,3],[18,1,18,3],[15,5,15,7],[15,8,15,10],[16,5,16,7],[16,8,16,10],[15,1,15,3],[16,1,16,3],[137,4,137,10],[138,0,138,1],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,4],[5,5,5,10],[4,0,4,2],[4,5,4,7],[4,8,4,10],[4,3,4,4],[9,8,9,10],[12,1,12,2],[10,5,10,6],[10,7,10,10],[11,5,12,6],[11,9,11,10],[7,5,7,10],[8,0,8,2],[8,3,8,4],[11,1,11,4],[17,5,17,7],[17,8,17,10],[8,8,8,10],[9,5,9,7],[144,0,146,10],[147,0,149,10],[150,0,153,10],[122,5,122,6],[123,5,123,6],[126,5,126,6],[127,5,127,6],[128,5,128,6],[129,5,129,6],[130,5,130,6],[122,7,122,8],[123,7,123,8],[126,7,126,8],[127,7,127,8],[128,7,128,8],[129,7,129,8],[130,7,130,8],[135,0,135,10],[136,0,136,1],[136,2,136,3],[136,4,136,10],[137,0,137,1],[104,9,108,10],[176,0,176,4],[13,12,14,15],[13,16,14,19],[6,12,12,19],[15,12,16,13],[15,14,16,15],[15,16,16,17],[15,18,16,19],[69,0,69,10],[143,0,143,10],[9,0,9,2],[9,3,9,4],[12,7,12,8],[12,9,12,10],[13,0,13,10],[14,5,14,7],[14,8,14,10],[14,1,14,3],[10,0,10,4],[11,7,11,8],[6,0,7,4],[6,5,6,10],[8,5,8,7]]}
["FORM NO. 16"]
["[(See Rule 31(1)(a)]"]
["PART-A"]
["Certificate uner section 203 of the income-tax act, 1961 for tax deducted at source on Salary.",null,null,null,null,null,null,null,null,null,null,null,"d`Ik;k Traces (https://www.tdscpc.gov.in) ls izkIr QkWeZ 16 dk gh mi;ksx djsaA ;g QkWeZ 16 flQZ x.kuk mn~ns'; ds fy, gSA "]
["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"]
[{"$f":"PROPER(IF(profile!K8>0,CONCATENATE(profile!B8,CHAR(10),profile!K8),CONCATENATE(profile!B8,CHAR(10),profile!K5)))","v":"Principal\n"},null,null,null,null,{"$f":"PROPER(IF(profile!B4=\"\",\"\",profile!B4))","v":"Keshav Das Gupta"},null,null,null,null,null,null,"xzhu dyj lsYl dks vko';drk gks rks esU;wvyh HkjysaA fizaV djus ls igys fizaV fizO;w ns[kdj mlh ist dks fizaV djsa] ftldh vkidks vko';drk gSA\n¼QkeZ ua- 16 Download djus ds fy, http://tdscpc.gov.in (Traces) osclkbV ij tk,aA\n"]
[null,null,null,null,null,{"$f":"PROPER(IF(profile!B5=\"\",\"\",profile!B5))","v":"Lecturer"}]
["PAN of the Deductor",null,null,"TAN of Deductor",null,"PAN of the Employee",null,null,"Employee Ref No."]
[{"$f":"control!C20","v":""},null,null,{"$f":"control!C21","v":""},null,{"$f":"control!C19","v":"GGAAA9999B"}]
["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,"2024-25",null,"From",null,"To"]
["City","Jaipur",null,"PIN Code",302005,null,null,"01-4-2023",null,"31-03-2024"]
["Summary of amount paid/credited and tax deducted at source thereon in respect of the employee",null,null,null,null,null,null,null,null,null,null,null,";fn vkidk VhMh,l BIN ds }kjk tek gqvk gS rks lEcfU/kr Annexure ds fy, fuEu cVuksa dk mi;ksx djsaA ",null,null,null,";fn vkidk VhMh,l Challan ds }kjk tek gqvk gS rks lEcfU/kr Annexure ds fy, fuEu cVuksa dk mi;ksx djsaA "]
["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":"IF(profile!C35=\"\",\"\",profile!C35)","v":""},null,null,null,{"$f":"IF(profile!C36=\"\",\"NIL\",profile!C36)","v":"NIL"},null,null,{"$f":"F16","v":"NIL"}]
["IInd",{"$f":"IF(profile!F35=\"\",\"\",profile!F35)","v":""},null,null,null,{"$f":"IF(profile!F36=\"\",\"NIL\",profile!F36)","v":"NIL"},null,null,{"$f":"F17","v":"NIL"}]
["IIIrd",{"$f":"IF(profile!I35=\"\",\"\",profile!I35)","v":""},null,null,null,{"$f":"IF(profile!I36=\"\",\"NIL\",profile!I36)","v":"NIL"},null,null,{"$f":"F18","v":"NIL"}]
["IVth",{"$f":"IF(profile!O35=\"\",\"\",profile!O35)","v":""},null,null,null,{"$f":"IF(profile!O36=\"\",\"NIL\",profile!O36)","v":"NIL"},null,null,{"$f":"F19","v":"NIL"}]
["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(profile!B32=\"\",\"\",profile!B32)","v":""},{"$f":"IF(profile!B33=\"\",\"\",profile!B33)","v":""},{"$f":"IF(profile!B34=\"\",\"\",profile!B34)","v":""},null,null,{"$f":"IF(D25>\"0\",\"Yes\",\"\")","v":""}]
[2,{"$f":"salary!V7","v":0},null,{"$f":"IF(profile!C32=\"\",\"\",profile!C32)","v":""},{"$f":"IF(profile!C33=\"\",\"\",profile!C33)","v":""},{"$f":"IF(profile!C34=\"\",\"\",profile!C34)","v":""},null,null,{"$f":"IF(D26>\"0\",\"Yes\",\"\")","v":""}]
[3,{"$f":"salary!V8","v":0},null,{"$f":"IF(profile!D32=\"\",\"\",profile!D32)","v":""},{"$f":"IF(profile!D33=\"\",\"\",profile!D33)","v":""},{"$f":"IF(profile!D34=\"\",\"\",profile!D34)","v":""},null,null,""]
[4,{"$f":"salary!V9","v":0},null,{"$f":"IF(profile!E32=\"\",\"\",profile!E32)","v":""},{"$f":"IF(profile!E33=\"\",\"\",profile!E33)","v":""},{"$f":"IF(profile!E34=\"\",\"\",profile!E34)","v":""},null,null,""]
[5,{"$f":"salary!V10","v":0},null,{"$f":"IF(profile!F32=\"\",\"\",profile!F32)","v":""},{"$f":"IF(profile!F33=\"\",\"\",profile!F33)","v":""},{"$f":"IF(profile!F34=\"\",\"\",profile!F34)","v":""},null,null,""]
[6,{"$f":"salary!V11","v":0},null,{"$f":"IF(profile!G32=\"\",\"\",profile!G32)","v":""},{"$f":"IF(profile!G33=\"\",\"\",profile!G33)","v":""},{"$f":"IF(profile!G34=\"\",\"\",profile!G34)","v":""},null,null,""]
[7,{"$f":"salary!V12","v":0},null,{"$f":"IF(profile!H32=\"\",\"\",profile!H32)","v":""},{"$f":"IF(profile!H33=\"\",\"\",profile!H33)","v":""},{"$f":"IF(profile!H34=\"\",\"\",profile!H34)","v":""},null,null,""]
[8,{"$f":"salary!V13","v":0},null,{"$f":"IF(profile!I32=\"\",\"\",profile!I32)","v":""},{"$f":"IF(profile!I33=\"\",\"\",profile!I33)","v":""},{"$f":"IF(profile!I34=\"\",\"\",profile!I34)","v":""},null,null,""]
[9,{"$f":"salary!V14","v":0},null,{"$f":"IF(profile!J32=\"\",\"\",profile!J32)","v":""},{"$f":"IF(profile!J33=\"\",\"\",profile!J33)","v":""},{"$f":"IF(profile!J34=\"\",\"\",profile!J34)","v":""},null,null,""]
[10,{"$f":"salary!V15","v":0},null,{"$f":"IF(profile!K32=\"\",\"\",profile!K32)","v":""},{"$f":"IF(profile!K33=\"\",\"\",profile!K33)","v":""},{"$f":"IF(profile!K34=\"\",\"\",profile!K34)","v":""},null,null,""]
[11,{"$f":"salary!V16","v":0},null,{"$f":"IF(profile!M32=\"\",\"\",profile!M32)","v":""},{"$f":"IF(profile!M33=\"\",\"\",profile!M33)","v":""},{"$f":"IF(profile!M34=\"\",\"\",profile!M34)","v":""},null,null,""]
[12,{"$f":"salary!V17","v":0},null,{"$f":"IF(profile!O32=\"\",\"\",profile!O32)","v":""},{"$f":"IF(profile!O33=\"\",\"\",profile!O33)","v":""},{"$f":"IF(profile!O34=\"\",\"\",profile!O34)","v":""},null,null,""]
[13,{"$f":"salary!V22","v":0},null,{"$f":"IF(profile!Q32=\"\",\"\",profile!Q32)","v":""},{"$f":"IF(profile!Q33=\"\",\"\",profile!Q33)","v":""},{"$f":"IF(profile!Q34=\"\",\"\",profile!Q34)","v":""},null,null,""]
[14,{"$f":"salary!V23","v":0},null,{"$f":"IF(profile!S32=\"\",\"\",profile!S32)","v":""},{"$f":"IF(profile!S33=\"\",\"\",profile!S33)","v":""},{"$f":"IF(profile!S34=\"\",\"\",profile!S34)","v":""},null,null,""]
[15,null,null,null,null,null,null,null,{"$f":"IF(D39>\"0\",\"Yes\",\"\")","v":""}]
["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":"IF(profile!B6=\"\",\"\",profile!B6)","v":""},null,null,"son/daughter of ",{"$f":"IF(profile!B7=\"\",\"\",profile!B7)","v":""},null,null,null,"working in the "]
["capacity of ",null,{"$f":"IF(profile!B8=\"\",\"\",profile!B8)","v":"PRINCIPAL"},null,null,"(designation) do hereby certify that a sum of "]
["Rs",{"$f":"I20","v":0},{"$f":"spellIndian($B$64)","v":"No Rupees Only"},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":"IF(profile!B8=\"\",\"\",profile!B8)","v":"PRINCIPAL"},null,"Full name",{"$f":"IF(profile!B6=\"\",\"\",profile!B6)","v":""}]
["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":"'I T cal.'!E4","v":0}]
["(b) Value of perquisites u/s 17(2) (as per Form No. 12BA, wherever applicable)",null,null,null,null,{"$f":"'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":0}]
["Reported total amount of salary received from other employer(s).",null,null,null,null,0,null,{"$f":"H76+F77","v":0}]
["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(E80=\"0\",\"\",salary!E25)","v":0},{"$f":"'I T cal.'!B7","v":0}]
[{"$f":"'I T cal.'!C7","v":"US10 "},null,null,{"$f":"'I T cal.'!D7","v":0},{"$f":"'I T cal.'!D7","v":0},{"$f":"E80+E81","v":0}]
["3. Balance (1 - 2)",null,null,null,null,null,null,{"$f":"H77-F81","v":0}]
["4. Deductions:     (a) Standard deduction us 16(ia)",null,null,null,null,{"$f":"IF(control!C26=2,50000,50000)","v":50000}]
["(a)",null,"Entertainment allowance 16(ii)",null,null,0]
["(b)",null,"Tax on employment 16(iii)",null,null,0]
["5. Aggregate of 4(a) and (b)",null,null,null,null,null,null,{"$f":"F83+F84+F85","v":50000}]
["6. Income chargeable under the head \"salaries\" (3-5)",null,null,null,null,null,null,null,null,{"$f":"IF(H82>H86,H82-H86,0)","v":0}]
["7. Add: Any other income reported by employee "]
["Income",null,null,null,"Rs"]
["From House Property",null,null,null,{"$f":"IF(AND(control!C26=2,'I T cal.'!D10<0),0,IF(AND('I T cal.'!D10<0,ABS('I T cal.'!D10)>200000),\"-200000\",'I T cal.'!D10))","v":0}]
[{"$f":"CONCATENATE(IF('I T cal.'!A13>0,\"NSC int,\",\"\"),IF('I T cal.'!B13>0,\" FDR int,\",\"\"),IF('I T cal.'!C13>0,\" Bonds,\",\"\"),IF('I T cal.'!D13>0,\" SB a/c int,\",\"\"),IF('I T cal.'!E13>0,\" Other income\",\"\"))","v":""},null,null,null,{"$f":"SUM('I T cal.'!A13:'I T cal.'!E13)","v":0},null,null,{"$f":"E90+E91","v":0}]
["8. Gross total income (6+7)",null,null,null,null,null,null,null,null,{"$f":"J87+H91","v":0}]
["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"]
[{"$f":"IF(control!$H$4=TRUE,\"G P F 2004\",\"G P F\")","v":"G P F 2004"},null,null,null,null,{"$f":"'I T cal.'!C16","v":0}]
["S I",null,null,null,null,{"$f":"'I T cal.'!C17","v":0}]
["L I C + ULIP + PLI",null,null,null,null,{"$f":"'I T cal.'!C18+'I T cal.'!C20+'I T cal.'!C23","v":0}]
["Gr. Acc. Insurance",null,null,null,null,{"$f":"'I T cal.'!C19","v":0}]
["Home loan capital",null,null,null,null,{"$f":"'I T cal.'!C21","v":0}]
["PPF",null,null,null,null,{"$f":"'I T cal.'!C22","v":0}]
["Notified Bond Of NABARD",null,null,null,null,{"$f":"'I T cal.'!C24","v":0}]
["Tuition Fee",null,null,null,null,{"$f":"'I T cal.'!E17","v":0}]
["NSC + Interest on NSC",null,null,null,null,{"$f":"'I T cal.'!E18+'I T cal.'!E19","v":0}]
["Equity linked savings",null,null,null,null,{"$f":"'I T cal.'!E20","v":0},null,null,null,"US 80CCE \nMax limit \nRs 150000/-"]
["Deferred Annuity",null,null,null,null,{"$f":"'I T cal.'!E21","v":0}]
["Fixed Deposit",null,null,null,null,{"$f":"'I T cal.'!E22","v":0}]
["Sukanya Samriddhi Yojana",null,null,null,null,{"$f":"'I T cal.'!E23","v":0}]
["(b) Section 80CCC",null,null,null,null,{"$f":"'I T cal.'!E24","v":0}]
["(c) Section 80CCD(1)",null,null,null,null,{"$f":"'I T cal.'!E16","v":0},null,{"$f":"IF(control!C26=2,0,SUM(F96:F110))","v":0},null,{"$f":"IF(H110<=150000,H110,150000)","v":0}]
["(B) Other Sections under Chapter VIA",null,null,null,null,"Gross Amount",null,"Qualifying amount",null,"Deductible Amount"]
["U/S 80EEA",null,null,null,null,{"$f":"profile!V23","v":0},null,{"$f":"'I T cal.'!E28","v":0}]
["U/S 80D",null,null,null,null,{"$f":"'I T cal.'!E29","v":0},null,{"$f":"'I T cal.'!E29","v":0}]
["U/S 80DD",null,null,null,null,{"$f":"'I T cal.'!E30","v":0},null,{"$f":"'I T cal.'!E30","v":0}]
["U/S 80DDB",null,null,null,null,{"$f":"'I T cal.'!E31","v":0},null,{"$f":"'I T cal.'!E31","v":0}]
["U/S 80E",null,null,null,null,{"$f":"'I T cal.'!E32","v":0},null,{"$f":"'I T cal.'!E32","v":0}]
["U/S 80G",null,null,null,null,{"$f":"profile!B28","v":0},null,{"$f":"'I T cal.'!E33","v":0}]
["U/S 80GG",null,null,null,null,{"$f":"profile!Q27","v":0},null,{"$f":"'I T cal.'!E34","v":0}]
["U/S 80EE",null,null,null,null,{"$f":"'I T cal.'!E35","v":0},null,{"$f":"'I T cal.'!E35","v":0}]
["U/S 80U",null,null,null,null,{"$f":"'I T cal.'!E36","v":0},null,{"$f":"'I T cal.'!E36","v":0}]
["US 80CCD (1B)",null,null,null,null,{"$f":"profile!K22","v":0},null,{"$f":"'I T cal.'!E38","v":0}]
["US 80TTA",null,null,null,null,{"$f":"profile!J26","v":0},null,{"$f":"'I T cal.'!E37","v":0},null,{"$f":"ROUND((H112+H113+H114+H115+H116+H117+H118+H119+H120+H121+H122),0)","v":0}]
["10. Aggregate of deductible amount under chapter VIA ",null,null,null,null,null,null,null,null,{"$f":"ROUND((J110+J122),0)","v":0}]
["11. Total income (8-10)",null,null,null,null,null,null,null,null,{"$f":"ROUND((J92-J123),-1)","v":0}]
["Income tax for Men",null,null,null,null,{"$f":"ROUND(IF(J124<=300000,0,IF(J124<=600000,(J124-300000)*0.05,IF(J124<=900000,15000+(J124-600000)*0.1,IF(J124<=1200000,45000+(J124-900000)*0.15,IF(J124<=1500000,90000+(J124-1200000)*0.2,IF(J124>1500000,150000+(J124-1500000)*0.3,\"0\")))))),0)","v":0},null,{"$f":"IF(J124<=700000,F126,F125)","v":0},null,{"$f":"ROUND(IF(J124<=250000,0,IF(J124<=500000,(J124-250000)*0.05,IF(J124<=1000000,12500+(J124-500000)*0.2,IF(J124>1000000,112500+(J124-1000000)*0.3,\"0\")))),0)","v":0}]
["Tax Credit, Max Rs 25000/ or 12500/",null,null,null,null,{"$f":"IF(AND(J124<=700000,F125>=25000),F125-25000,IF(AND(J124<=700000,F125<25000),0,F125))","v":0},null,null,null,{"$f":"IF(AND(J124<=500000,J125>=12500),J125-12500,IF(AND(J124<=500000,J125<12500),0,J125))","v":0}]
["12. Tax on total income",null,null,null,null,null,null,null,null,{"$f":"IF(control!C26=2,H125,IF(J124<=500000,J126,J125))","v":0}]
["13. Health & Education cess",null,null,null,null,null,null,null,null,{"$f":"ROUND((J127*0.04),0)","v":0}]
["14. Tax payable (12+13)",null,null,null,null,null,null,null,null,{"$f":"J127+J128","v":0}]
["15. Relief under section 89 (Attach details)",null,null,null,null,null,null,null,null,{"$f":"'I T cal.'!E46","v":0}]
["16. Tax payable (14-15)",null,null,null,null,null,null,null,null,{"$f":"J129-J130","v":0}]
["Verification"]
["I",{"$f":"IF(profile!B6=\"\",\"\",profile!B6)","v":""},null,null,"son/daughter of ",{"$f":"IF(profile!B7=\"\",\"\",profile!B7)","v":""},null,null,null,"working in the "]
["capacity of ",null,{"$f":"IF(profile!B8=\"\",\"\",profile!B8)","v":"PRINCIPAL"},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":"IF(profile!B8=\"\",\"\",profile!B8)","v":"PRINCIPAL"},null,"Full name",{"$f":"IF(profile!B6=\"\",\"\",profile!B6)","v":""}]
[]
[]
[]
[]
["Notes:-"]
["1. Government deductors to fill information in item 1 if tax is paid without production of an income tax challan and in item II if tax is paid accompanied by an income tax callan."]
[]
[]
["2. The deductor shall furnish the address of the Commissioner of Income tax (TDS) having jurisdiction as regards TDS statements of the assessee."]
[]
[]
["3. If an assessee is employed under one employer only during the year, certificate is 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. "]
[]
[]
[]
["4. If an assessee is employed under more than one employer during the year, each of the employer 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 assesee. "]
[]
[]
[]
[]
["5. In items I and II in column for tax deposited in respect of deductee. Furnish total amount of TDS and education cess. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Prog. Dev. By Keshav D. Gupta Cont- kdgupta1971@gmail.com"]

{"sheet":"nsc int","index":9,"n_rows":31,"n_cols":23,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,22],[6,19,6,20],[6,21,6,22],[5,2,5,22],[13,2,13,22],[19,7,19,8],[18,2,18,8],[6,15,6,16],[6,17,6,18],[19,3,19,4],[19,5,19,6],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14]]}
["NSC INTEREST CALCULATION"]
[]
[]
[]
[]
[null,null,"NSC INTEREST CALCULATION\n(GIVE AMOUNT, PERIOD-WISE)"]
[null,null,"PURCHASE PERIOD","FROM 01-04-2013 TO \n31-03-2016\n5 Year NSC",null,"FROM 01-04-2016 TO \n30-09-2016\n5 Year NSC",null,"FROM 01-10-2016 TO \n31-03-2017\n5 Year NSC",null,"FROM 01-04-2017 TO \n30-06-2017\n5 Year NSC",null,"FROM 01-07-2017 TO \n31-12-2017\n5 Year NSC",null,"FROM 01-01-2018 TO \n30-09-2018\n5 Year NSC",null,"FROM 01-10-2018 TO\n30-06-2019\n5 Year NSC",null,"FROM 01-07-2019 TO \n11-12-2019\n5 Year NSC",null,"FROM 12-12-2019 TO \n31-03-2020\n5 Year NSC",null,"FROM 01-04-2020 TO \n31-03-2022\n5 Year NSC"]
[null,null,"Period    (in years)","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest"]
[null,null,1,null,{"$f":"ROUND((D9*0.0868),0)","v":0},null,{"$f":"ROUND((F9*0.081),0)","v":0},null,{"$f":"ROUND((H9*0.08),0)","v":0},null,{"$f":"ROUND((J9*0.079),0)","v":0},null,{"$f":"ROUND((L9*0.078),0)","v":0},null,{"$f":"ROUND((N9*0.076),0)","v":0},null,{"$f":"ROUND((P9*0.08),0)","v":0},null,{"$f":"ROUND((R9*0.079),0)","v":0},null,{"$f":"ROUND((T9*0.079),0)","v":0},null,{"$f":"ROUND((V9*0.068),0)","v":0}]
[null,null,2,null,{"$f":"ROUND((D10*0.0943),0)","v":0},null,{"$f":"ROUND((F10*0.0876),0)","v":0},null,{"$f":"ROUND((H10*0.0864),0)","v":0},null,{"$f":"ROUND((J10*0.0852),0)","v":0},null,{"$f":"ROUND((L10*0.0841),0)","v":0},null,{"$f":"ROUND((N10*0.0818),0)","v":0},null,{"$f":"ROUND((P10*0.0864),0)","v":0},null,{"$f":"ROUND((R10*0.0852),0)","v":0},null,{"$f":"ROUND((T10*0.0852),0)","v":0},null,{"$f":"ROUND((V10*0.0726),0)","v":0}]
[null,null,3,null,{"$f":"ROUND((D11*0.1025),0)","v":0},null,{"$f":"ROUND((F11*0.0946),0)","v":0},null,{"$f":"ROUND((H11*0.0933),0)","v":0},null,{"$f":"ROUND((J11*0.092),0)","v":0},null,{"$f":"ROUND((L11*0.0906),0)","v":0},null,{"$f":"ROUND((N11*0.088),0)","v":0},null,{"$f":"ROUND((P11*0.0933),0)","v":0},null,{"$f":"ROUND((R11*0.092),0)","v":0},null,{"$f":"ROUND((T11*0.092),0)","v":0},null,{"$f":"ROUND((V11*0.0776),0)","v":0}]
[null,null,4,null,{"$f":"ROUND((D12*0.1114),0)","v":0},null,{"$f":"ROUND((F12*0.1023),0)","v":0},null,{"$f":"ROUND((H12*0.1008),0)","v":0},null,{"$f":"ROUND((J12*0.0993),0)","v":0},null,{"$f":"ROUND((L12*0.0977),0)","v":0},null,{"$f":"ROUND((N12*0.0947),0)","v":0},null,{"$f":"ROUND((P12*0.1008),0)","v":0},null,{"$f":"ROUND((R12*0.0933),0)","v":0},null,{"$f":"ROUND((T12*0.0992),0)","v":0},null,{"$f":"ROUND((V12*0.0828),0)","v":0}]
[null,null,5,null,{"$f":"ROUND((D13*0.1211),0)","v":0},null,{"$f":"ROUND((F13*0.1106),0)","v":0},null,{"$f":"ROUND((H13*0.1088),0)","v":0},null,{"$f":"ROUND((J13*0.107),0)","v":0},null,{"$f":"ROUND((L13*0.1055),0)","v":0},null,{"$f":"ROUND((N13*0.1019),0)","v":0},null,{"$f":"ROUND((P13*0.1088),0)","v":0},null,{"$f":"ROUND((R13*0.1074),0)","v":0},null,{"$f":"ROUND((T13*0.107),0)","v":0},null,{"$f":"ROUND((V13*0.0885),0)","v":0}]
[]
[]
[]
[]
[]
[null,null,"NSC INTEREST CALCULATION\n(GIVE AMOUNT, PERIOD-WISE)"]
[null,null,"PURCHASE PERIOD","FROM 01-12-2011 TO 31-03-2012\n10 Year NSC",null,"FROM 01-04-2012 TO 31-03-2013\n10 Year NSC",null,"FROM 01-04-2013 TO 31-03-2016\n10 Year NSC"]
[null,null,"Period    (in years)","Amount","Interest","Amount","Interest","Amount","Interest"]
[null,null,1,null,{"$f":"ROUND((D22*0.0889),0)","v":0},null,{"$f":"ROUND((F22*0.091),0)","v":0},null,{"$f":"ROUND((H22*0.0899),0)","v":0}]
[null,null,2,null,{"$f":"ROUND((D23*0.0968),0)","v":0},null,{"$f":"ROUND((F23*0.0993),0)","v":0},null,{"$f":"ROUND((H23*0.098),0)","v":0}]
[null,null,3,null,{"$f":"ROUND((D24*0.1054),0)","v":0},null,{"$f":"ROUND((F24*0.1083),0)","v":0},null,{"$f":"ROUND((H24*0.1068),0)","v":0}]
[null,null,4,null,{"$f":"ROUND((D25*0.1148),0)","v":0},null,{"$f":"ROUND((F25*0.1181),0)","v":0},null,{"$f":"ROUND((H25*0.1164),0)","v":0}]
[null,null,5,null,{"$f":"ROUND((D26*0.125),0)","v":0},null,{"$f":"ROUND((F26*0.1289),0)","v":0},null,{"$f":"ROUND((H26*0.1269),0)","v":0}]
[null,null,6,null,{"$f":"ROUND((D27*0.1361),0)","v":0},null,{"$f":"ROUND((F27*0.1406),0)","v":0},null,{"$f":"ROUND((H27*0.1383),0)","v":0}]
[null,null,7,null,{"$f":"ROUND((D28*0.1482),0)","v":0},null,{"$f":"ROUND((F28*0.1534),0)","v":0},null,{"$f":"ROUND((H28*0.1508),0)","v":0}]
[null,null,8,null,{"$f":"ROUND((D29*0.1613),0)","v":0},null,{"$f":"ROUND((F29*0.1674),0)","v":0},null,{"$f":"ROUND((H29*0.1643),0)","v":0}]
[null,null,9,null,{"$f":"ROUND((D30*0.1757),0)","v":0},null,{"$f":"ROUND((F30*0.1826),0)","v":0},null,{"$f":"ROUND((H30*0.1791),0)","v":0}]
[null,null,10,null,{"$f":"ROUND((D31*0.1913),0)","v":0},null,{"$f":"ROUND((F31*0.1992),0)","v":0},null,{"$f":"ROUND((H31*0.1952),0)","v":0}]

{"sheet":"us89(1)form","index":10,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":true,"merged":[[11,16,18,19],[0,16,1,19],[3,16,5,19],[7,16,9,19],[16,0,16,10],[16,11,16,13],[17,0,17,10],[17,11,17,13],[10,0,10,10],[10,11,10,13],[11,0,11,10],[11,11,11,13],[12,0,12,10],[12,11,12,13],[7,0,7,10],[7,11,7,13],[5,0,5,10],[5,11,5,13],[6,0,6,10],[6,11,6,13],[18,0,18,10],[18,11,18,13],[13,0,13,10],[13,11,13,13],[14,0,14,10],[14,11,14,13],[15,0,15,10],[15,11,15,13],[16,15,17,15],[0,0,0,13],[1,0,1,2],[2,0,2,2],[3,0,3,2],[3,7,3,10],[3,3,3,6],[3,11,3,13],[1,3,1,13],[2,3,2,13],[8,0,8,10],[8,11,8,13],[9,0,9,10],[9,11,9,13],[4,0,4,10],[4,11,4,13],[0,15,3,15],[13,14,14,14],[10,14,11,14],[7,14,8,14],[7,15,8,15],[13,15,14,15],[10,15,11,15]]}
["CALCULATION OF RELIEF UNDER SECTION 89 (1)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Male","New Tax Regime ds fy, Check Boxes dks Select djsa","1- loZizFke vius ,fj;j dks xr foÙkh; o\"kksZa ds vuqlkj foHkkftr djsaA"]
["NAME",null,null,null,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,1]
["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- 2019-20",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )"]
["Enter net taxable income for 2019-20 (as per ITR/Form-16) "]
["Enter arrears relates to 2019-20"]
["FINANCIAL YEAR- 2020-21",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )",null,null,false,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 2020-21 (as per ITR/Form-16) "]
["Enter arrears relates to 2020-21"]
["FINANCIAL YEAR- 2021-22",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )",null,null,false]
["Enter net taxable income for 2021-22 (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,null,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 2023&24 ds fy, Hkjh x;h dj ;ksX; vk; esa lEiw.kZ ,fj;j dh jkf'k tqMh gksA vc vxyh 'khV 'form10E' esa 'GENERATE FORM 10E' cVu nckdj QkWeZ 10E, Generate djsaA izkIr NwV dh jkf'k dks 'profile' 'khV ij lsy Q28 esa Rebate US89(1) esa HkjsaA "]
["Enter arrears relates to 2021-22"]
["FINANCIAL YEAR- 2022-23",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )",null,null,false]
["Enter net taxable income for 2022-23 (as per ITR/Form-16) "]
["Enter arrears relates to 2022-23"]
["FINANCIAL YEAR- 2023-24",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )"]
["Enter net taxable income for 2023-24 including entire arrears received (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"form10E","index":11,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":true,"merged":[[2,15,5,18],[40,5,41,8],[19,0,19,10],[9,11,9,13],[6,0,6,13],[7,0,7,10],[7,11,7,13],[8,0,8,10],[8,11,8,13],[18,0,18,13],[10,0,10,10],[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],[3,0,3,2],[4,0,4,2],[4,8,4,9],[2,3,2,13],[3,3,3,13],[4,3,4,7],[4,10,4,13],[16,10,16,13],[9,0,9,10],[25,0,25,10],[26,0,26,10],[21,11,21,13],[22,11,22,13],[23,11,23,13],[24,11,24,13],[25,11,25,13],[20,0,20,10],[19,11,19,13],[20,11,20,13],[26,11,26,13],[21,0,21,10],[22,0,22,10],[23,0,23,10],[24,0,24,10],[30,0,30,1],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[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],[30,12,30,13],[31,12,31,13],[31,10,31,11],[31,8,31,9],[31,6,31,7],[30,10,30,11],[31,2,31,3],[31,0,31,1],[32,0,32,1],[32,2,32,3],[32,4,32,5],[31,4,31,5],[32,10,32,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,6,32,7],[5,0,5,13],[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,8,32,9]]}
["FORM NO. 10 E (See rule 21AA)"]
["Form for furnishing particulars of income undr scetion 192(2A) for year ending 31st March 2024 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":"PROPER(IF('us89(1)form'!D2=\"\",\"\",'us89(1)form'!D2))","v":""},null,null,null,null,null,null,null,null,null,null,null,"QkWeZ ds uhps ds Hkkx esa ekStwn cVu dks nckdj 'khV Generate djsaA "]
["Address",null,null,{"$f":"PROPER(IF('us89(1)form'!D3=\"\",\"\",'us89(1)form'!D3))","v":""}]
["PAN",null,null,{"$f":"UPPER(IF('us89(1)form'!D4=\"\",\"\",'us89(1)form'!D4))","v":""},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 2024-25"]
["1. (a) Salary received in arrears or in advance during 2023-24 in accordance with the provision of sub-rule (2) of rule 21A",null,null,null,null,null,null,null,null,null,null,{"$f":"'us89(1)form'!L7+'us89(1)form'!L10+'us89(1)form'!L13+'us89(1)form'!L16","v":0}]
["(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":0}]
["2. salary received in arrears or advance",null,null,null,null,null,null,null,null,null,null,{"$f":"L8","v":0}]
["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":"'us89(1)form'!L18","v":0}]
["4. Tax on total income (as per item 3)",null,null,null,null,null,null,null,null,null,null,{"$f":"control10E!G14","v":0}]
["5. Tax on total income (as per item 1)",null,null,null,null,null,null,null,null,null,null,{"$f":"control10E!G6","v":0}]
["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":0}]
["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":0}]
[]
["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]
["2019-20",null,{"$f":"'us89(1)form'!L6","v":0},null,{"$f":"'us89(1)form'!L7","v":0},null,{"$f":"C32+E32","v":0},null,{"$f":"control10E!G2","v":0},null,{"$f":"control10E!G10","v":0},null,{"$f":"K32-I32","v":0}]
["2020-21",null,{"$f":"'us89(1)form'!L9","v":0},null,{"$f":"'us89(1)form'!L10","v":0},null,{"$f":"C33+E33","v":0},null,{"$f":"control10E!G3","v":0},null,{"$f":"control10E!G11","v":0},null,{"$f":"K33-I33","v":0}]
["2021-22",null,{"$f":"'us89(1)form'!L12","v":0},null,{"$f":"'us89(1)form'!L13","v":0},null,{"$f":"C34+E34","v":0},null,{"$f":"control10E!G4","v":0},null,{"$f":"control10E!G12","v":0},null,{"$f":"K34-I34","v":0}]
["2022-23",null,{"$f":"'us89(1)form'!L15","v":0},null,{"$f":"'us89(1)form'!L16","v":0},null,{"$f":"C35+E35","v":0},null,{"$f":"control10E!G5","v":0},null,{"$f":"control10E!G13","v":0},null,{"$f":"K35-I35","v":0}]
["Total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M32+M33+M34+M35","v":0}]
[]
["Prog. Dev. By- Keshav D. Gupta, Cont- kdgupta1971@gmail.com"]

{"sheet":"control10E","index":12,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":true,"merged":[[7,0,7,6],[0,7,0,8],[0,9,0,11]]}
["year","amount","tax for male","tax for female","surcharge","edu. cess","total","OLD TAX REGIME",null,"NEW TAX REGIME"]
["2019-20",{"$f":"form10E!C32","v":0},{"$f":"IF(AND(B2<=500000,H2>=12500),H2-12500,IF(AND(B2<=500000,H2<12500),0,H2))","v":0},{"$f":"IF(AND(B2<=500000,H2>=12500),H2-12500,IF(AND(B2<=500000,H2<12500),0,H2))","v":0},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D2*0.04,C2*0.04),0)","v":0},{"$f":"IF('us89(1)form'!$O$3=2,D2+E2+F2,C2+E2+F2)","v":0},{"$f":"ROUND(IF(B2<=250000,0,IF(B2<=500000,(B2-250000)*0.05,IF(B2<=1000000,12500+(B2-500000)*0.2,IF(B2>1000000,112500+(B2-1000000)*0.3,\"0\")))),0)","v":0}]
["2020-21",{"$f":"form10E!C33","v":0},{"$f":"IF('us89(1)form'!$O$8=TRUE,L3,IF(B3<=500000,I3,H3))","v":0},{"$f":"IF('us89(1)form'!$O$8=TRUE,L3,IF(B3<=500000,I3,H3))","v":0},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D3*0.04,C3*0.04),0)","v":0},{"$f":"IF('us89(1)form'!$O$3=2,D3+E3+F3,C3+E3+F3)","v":0},{"$f":"ROUND(IF(B3<=250000,0,IF(B3<=500000,(B3-250000)*0.05,IF(B3<=1000000,12500+(B3-500000)*0.2,IF(B3>1000000,112500+(B3-1000000)*0.3,\"0\")))),0)","v":0},{"$f":"IF(AND(B3<=500000,H3>=12500),H3-12500,IF(AND(B3<=500000,H3<12500),0,H3))","v":0},{"$f":"ROUND(IF(B3<=250000,0,IF(B3<=500000,(B3-250000)*0.05,IF(B3<=750000,12500+(B3-500000)*0.1,IF(B3<=1000000,37500+(B3-750000)*0.15,IF(B3<=1250000,75000+(B3-1000000)*0.2,IF(B3<=1500000,125000+(B3-1250000)*0.25,IF(B3>1500000,187500+(B3-1500000)*0.3,\"0\"))))))),0)","v":0},{"$f":"IF(AND(B3<=500000,J3>=12500),J3-12500,IF(AND(B3<=500000,J3<12500),0,J3))","v":0},{"$f":"IF(B3<=500000,K3,J3)","v":0}]
["2021-22",{"$f":"form10E!C34","v":0},{"$f":"IF('us89(1)form'!$O$11=TRUE,L4,IF(B4<=500000,I4,H4))","v":0},{"$f":"IF('us89(1)form'!$O$11=TRUE,L4,IF(B4<=500000,I4,H4))","v":0},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D4*0.04,C4*0.04),0)","v":0},{"$f":"IF('us89(1)form'!$O$3=2,D4+E4+F4,C4+E4+F4)","v":0},{"$f":"ROUND(IF(B4<=250000,0,IF(B4<=500000,(B4-250000)*0.05,IF(B4<=1000000,12500+(B4-500000)*0.2,IF(B4>1000000,112500+(B4-1000000)*0.3,\"0\")))),0)","v":0},{"$f":"IF(AND(B4<=500000,H4>=12500),H4-12500,IF(AND(B4<=500000,H4<12500),0,H4))","v":0},{"$f":"ROUND(IF(B4<=250000,0,IF(B4<=500000,(B4-250000)*0.05,IF(B4<=750000,12500+(B4-500000)*0.1,IF(B4<=1000000,37500+(B4-750000)*0.15,IF(B4<=1250000,75000+(B4-1000000)*0.2,IF(B4<=1500000,125000+(B4-1250000)*0.25,IF(B4>1500000,187500+(B4-1500000)*0.3,\"0\"))))))),0)","v":0},{"$f":"IF(AND(B4<=500000,J4>=12500),J4-12500,IF(AND(B4<=500000,J4<12500),0,J4))","v":0},{"$f":"IF(B4<=500000,K4,J4)","v":0}]
["2022-23",{"$f":"form10E!C35","v":0},{"$f":"IF('us89(1)form'!$O$14=TRUE,L5,IF(B5<=500000,I5,H5))","v":0},{"$f":"IF('us89(1)form'!$O$14=TRUE,L5,IF(B5<=500000,I5,H5))","v":0},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D5*0.04,C5*0.04),0)","v":0},{"$f":"IF('us89(1)form'!$O$3=2,D5+E5+F5,C5+E5+F5)","v":0},{"$f":"ROUND(IF(B5<=250000,0,IF(B5<=500000,(B5-250000)*0.05,IF(B5<=1000000,12500+(B5-500000)*0.2,IF(B5>1000000,112500+(B5-1000000)*0.3,\"0\")))),0)","v":0},{"$f":"IF(AND(B5<=500000,H5>=12500),H5-12500,IF(AND(B5<=500000,H5<12500),0,H5))","v":0},{"$f":"ROUND(IF(B5<=250000,0,IF(B5<=500000,(B5-250000)*0.05,IF(B5<=750000,12500+(B5-500000)*0.1,IF(B5<=1000000,37500+(B5-750000)*0.15,IF(B5<=1250000,75000+(B5-1000000)*0.2,IF(B5<=1500000,125000+(B5-1250000)*0.25,IF(B5>1500000,187500+(B5-1500000)*0.3,\"0\"))))))),0)","v":0},{"$f":"IF(AND(B5<=500000,J5>=12500),J5-12500,IF(AND(B5<=500000,J5<12500),0,J5))","v":0},{"$f":"IF(B5<=500000,K5,J5)","v":0}]
["2023-24",{"$f":"form10E!L20","v":0},{"$f":"IF('us89(1)form'!$O$18=TRUE,L6,IF(B6<=500000,I6,H6))","v":0},{"$f":"IF('us89(1)form'!$O$18=TRUE,L6,IF(B6<=500000,I6,H6))","v":0},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D6*0.04,C6*0.04),0)","v":0},{"$f":"IF('us89(1)form'!$O$3=2,D6+E6+F6,C6+E6+F6)","v":0},{"$f":"ROUND(IF(B6<=250000,0,IF(B6<=500000,(B6-250000)*0.05,IF(B6<=1000000,12500+(B6-500000)*0.2,IF(B6>1000000,112500+(B6-1000000)*0.3,\"0\")))),0)","v":0},{"$f":"IF(AND(B6<=500000,H6>=12500),H6-12500,IF(AND(B6<=500000,H6<12500),0,H6))","v":0},{"$f":"ROUND(IF(B6<=300000,0,IF(B6<=600000,(B6-300000)*0.05,IF(B6<=900000,15000+(B6-600000)*0.1,IF(B6<=1200000,45000+(B6-900000)*0.15,IF(B6<=1500000,90000+(B6-1200000)*0.2,IF(B6>1500000,150000+(B6-1500000)*0.3,\"0\")))))),0)","v":0},{"$f":"IF(AND(B6<=700000,J6>=25000),J6-25000,IF(AND(B6<=700000,J6<25000),0,J6))","v":0},{"$f":"IF(B6<=700000,K6,J6)","v":0}]
[]
["Tax on income including arrears"]
["year","amount","tax for male","tax for female","surcharge","edu. cess","total"]
["2019-20",{"$f":"form10E!G32","v":0},{"$f":"IF(AND(B10<=500000,H10>=12500),H10-12500,IF(AND(B10<=500000,H10<12500),0,H10))","v":0},{"$f":"IF(AND(B10<=500000,H10>=12500),H10-12500,IF(AND(B10<=500000,H10<12500),0,H10))","v":0},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D10*0.04,C10*0.04),0)","v":0},{"$f":"IF('us89(1)form'!$O$3=2,D10+E10+F10,C10+E10+F10)","v":0},{"$f":"ROUND(IF(B10<=250000,0,IF(B10<=500000,(B10-250000)*0.05,IF(B10<=1000000,12500+(B10-500000)*0.2,IF(B10>1000000,112500+(B10-1000000)*0.3,\"0\")))),0)","v":0}]
["2020-21",{"$f":"form10E!G33","v":0},{"$f":"IF('us89(1)form'!$O$8=TRUE,L11,IF(B11<=500000,I11,H11))","v":0},{"$f":"IF('us89(1)form'!$O$8=TRUE,L11,IF(B11<=500000,I11,H11))","v":0},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D11*0.04,C11*0.04),0)","v":0},{"$f":"IF('us89(1)form'!$O$3=2,D11+E11+F11,C11+E11+F11)","v":0},{"$f":"ROUND(IF(B11<=250000,0,IF(B11<=500000,(B11-250000)*0.05,IF(B11<=1000000,12500+(B11-500000)*0.2,IF(B11>1000000,112500+(B11-1000000)*0.3,\"0\")))),0)","v":0},{"$f":"IF(AND(B11<=500000,H11>=12500),H11-12500,IF(AND(B11<=500000,H11<12500),0,H11))","v":0},{"$f":"ROUND(IF(B11<=250000,0,IF(B11<=500000,(B11-250000)*0.05,IF(B11<=750000,12500+(B11-500000)*0.1,IF(B11<=1000000,37500+(B11-750000)*0.15,IF(B11<=1250000,75000+(B11-1000000)*0.2,IF(B11<=1500000,125000+(B11-1250000)*0.25,IF(B11>1500000,187500+(B11-1500000)*0.3,\"0\"))))))),0)","v":0},{"$f":"IF(AND(B11<=500000,J11>=12500),J11-12500,IF(AND(B11<=500000,J11<12500),0,J11))","v":0},{"$f":"IF(B11<=500000,K11,J11)","v":0}]
["2021-22",{"$f":"form10E!G34","v":0},{"$f":"IF('us89(1)form'!$O$11=TRUE,L12,IF(B12<=500000,I12,H12))","v":0},{"$f":"IF('us89(1)form'!$O$11=TRUE,L12,IF(B12<=500000,I12,H12))","v":0},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D12*0.04,C12*0.04),0)","v":0},{"$f":"IF('us89(1)form'!$O$3=2,D12+E12+F12,C12+E12+F12)","v":0},{"$f":"ROUND(IF(B12<=250000,0,IF(B12<=500000,(B12-250000)*0.05,IF(B12<=1000000,12500+(B12-500000)*0.2,IF(B12>1000000,112500+(B12-1000000)*0.3,\"0\")))),0)","v":0},{"$f":"IF(AND(B12<=500000,H12>=12500),H12-12500,IF(AND(B12<=500000,H12<12500),0,H12))","v":0},{"$f":"ROUND(IF(B12<=250000,0,IF(B12<=500000,(B12-250000)*0.05,IF(B12<=750000,12500+(B12-500000)*0.1,IF(B12<=1000000,37500+(B12-750000)*0.15,IF(B12<=1250000,75000+(B12-1000000)*0.2,IF(B12<=1500000,125000+(B12-1250000)*0.25,IF(B12>1500000,187500+(B12-1500000)*0.3,\"0\"))))))),0)","v":0},{"$f":"IF(AND(B12<=500000,J12>=12500),J12-12500,IF(AND(B12<=500000,J12<12500),0,J12))","v":0},{"$f":"IF(B12<=500000,K12,J12)","v":0}]
["2022-23",{"$f":"form10E!G35","v":0},{"$f":"IF('us89(1)form'!$O$14=TRUE,L13,IF(B13<=500000,I13,H13))","v":0},{"$f":"IF('us89(1)form'!$O$14=TRUE,L13,IF(B13<=500000,I13,H13))","v":0},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D13*0.04,C13*0.04),0)","v":0},{"$f":"IF('us89(1)form'!$O$3=2,D13+E13+F13,C13+E13+F13)","v":0},{"$f":"ROUND(IF(B13<=250000,0,IF(B13<=500000,(B13-250000)*0.05,IF(B13<=1000000,12500+(B13-500000)*0.2,IF(B13>1000000,112500+(B13-1000000)*0.3,\"0\")))),0)","v":0},{"$f":"IF(AND(B13<=500000,H13>=12500),H13-12500,IF(AND(B13<=500000,H13<12500),0,H13))","v":0},{"$f":"ROUND(IF(B13<=250000,0,IF(B13<=500000,(B13-250000)*0.05,IF(B13<=750000,12500+(B13-500000)*0.1,IF(B13<=1000000,37500+(B13-750000)*0.15,IF(B13<=1250000,75000+(B13-1000000)*0.2,IF(B13<=1500000,125000+(B13-1250000)*0.25,IF(B13>1500000,187500+(B13-1500000)*0.3,\"0\"))))))),0)","v":0},{"$f":"IF(AND(B13<=500000,J13>=12500),J13-12500,IF(AND(B13<=500000,J13<12500),0,J13))","v":0},{"$f":"IF(B13<=500000,K13,J13)","v":0}]
["2023-24",{"$f":"form10E!L22","v":0},{"$f":"IF('us89(1)form'!$O$18=TRUE,L14,IF(B14<=500000,I14,H14))","v":0},{"$f":"IF('us89(1)form'!$O$18=TRUE,L14,IF(B14<=500000,I14,H14))","v":0},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D14*0.04,C14*0.04),0)","v":0},{"$f":"IF('us89(1)form'!$O$3=2,D14+E14+F14,C14+E14+F14)","v":0},{"$f":"ROUND(IF(B14<=250000,0,IF(B14<=500000,(B14-250000)*0.05,IF(B14<=1000000,12500+(B14-500000)*0.2,IF(B14>1000000,112500+(B14-1000000)*0.3,\"0\")))),0)","v":0},{"$f":"IF(AND(B14<=500000,H14>=12500),H14-12500,IF(AND(B14<=500000,H14<12500),0,H14))","v":0},{"$f":"ROUND(IF(B14<=300000,0,IF(B14<=600000,(B14-300000)*0.05,IF(B14<=900000,15000+(B14-600000)*0.1,IF(B14<=1200000,45000+(B14-900000)*0.15,IF(B14<=1500000,90000+(B14-1200000)*0.2,IF(B14>1500000,150000+(B14-1500000)*0.3,\"0\")))))),0)","v":0},{"$f":"IF(AND(B14<=700000,J14>=25000),J14-25000,IF(AND(B14<=700000,J14<25000),0,J14))","v":0},{"$f":"IF(B14<=700000,K14,J14)","v":0}]