{"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]]}
[]
[null,"d`Ik;k igys Macros Enable djsaA"]
[]
[]
[]
[]
[]
[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":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":true,"merged":[[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],[24,0,71,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]]}
["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\nSenior Teacher (Science)\nGovt. Sec. School, Machchhipura\nDistt. Sawai Madhopur (Raj)\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,"2015-10-25"]
[]
["What's New:-\n1. Personal exemption limit raised from 2 lakh to 2.5 lakh. \n2. Investment limit US80C raised from 1 lakh to 1.5 lakh.\n3. Deduction limit on account of interest on home loan in respect of self occupied house property raised from 1.5 lakh to 2 lakh.\n4. US80CCD(1) deduction limit not exceed Rs 1 lakh.   \n5. Tax rebate US87A is remained continue which is maximum Rs 2000/-.\n6. Section 80TTA, 80CCG are remained unchanged. \n24-09-2014\n1. RPMF rates updated.  \n25-10-2015\n1. Investment in Sukanya Samriddhi Yojana eligible for section 80C.\n2. US80D Health Insurance Premium limit raised from Rs 15000 to 25000. And for Senior citizen it raised from Rs 20000 to 30000.\n3. US80DDB limit for very senior citizen raised from Rs 60000 to 80000.\n4. US80DD limit raised from Rs 50000 to 75000 and in severe disability it enhanced from Rs 1 lakh to 1.25 lakh.\n5. US80U limit raised from Rs 50000 to 75000 and in severe disability it enhanced from Rs 1 lakh to 1.25 lakh.\n6. US80CCC investment limit enhanced from Rs 1 lakh to 1.5 lakh.\n7. US80CCD(1) Employee contribution towards NPS raised from Rs 1 lakh to 1.5 lakh.\n8. A new section 80CCD(1B) inserted. In this section an additional contribution towards NPS Max Rs 50000 allowed. Which is over and above 80C. \n9 Section 80TTA, 80CCG and Tax rebate US87A remain unchanged. \n10 RPMF and SI rates updated. \n\n"]

{"sheet":"profile","index":2,"n_rows":75,"n_cols":22,"rows_kept":75,"cut":false,"hidden":true,"merged":[[18,8,18,9],[19,13,19,16],[19,3,19,5],[37,16,37,19],[46,0,46,19],[38,0,38,19],[35,2,35,3],[35,5,35,6],[35,8,35,10],[35,11,35,13],[23,1,23,2],[23,7,23,8],[23,9,23,11],[23,12,23,15],[23,16,23,19],[31,16,31,17],[30,18,30,19],[31,18,31,19],[33,18,33,19],[21,4,21,6],[25,1,25,2],[22,12,22,15],[22,7,22,8],[22,16,22,19],[19,6,19,7],[19,8,19,9],[19,10,19,12],[21,7,21,8],[23,3,23,4],[23,5,23,6],[19,17,19,19],[20,0,20,19],[19,1,19,2],[22,1,22,2],[22,3,22,4],[22,5,22,6],[22,9,22,11],[21,12,21,15],[21,16,21,19],[21,10,21,11],[18,10,18,12],[17,0,17,19],[15,9,16,19],[13,7,13,12],[13,13,13,19],[14,1,14,3],[14,7,14,8],[14,9,14,11],[14,12,14,19],[13,1,13,3],[13,4,13,6],[15,0,16,0],[18,1,18,2],[16,1,16,2],[15,1,15,2],[16,5,16,6],[15,5,15,6],[14,4,14,5],[15,3,16,4],[15,7,16,8],[18,13,18,16],[18,17,18,19],[18,4,18,5],[18,6,18,7],[0,0,0,19],[1,0,1,19],[7,1,7,4],[7,5,7,9],[7,10,7,19],[4,5,4,9],[4,10,4,19],[5,5,5,9],[5,1,5,4],[4,1,4,4],[3,1,3,4],[2,1,2,11],[2,12,2,14],[2,15,2,19],[3,5,3,9],[8,5,8,9],[8,1,8,4],[8,10,8,19],[9,0,9,19],[12,3,12,4],[10,1,10,2],[11,1,11,2],[6,1,6,4],[6,5,6,9],[10,15,10,19],[10,9,10,14],[10,7,10,8],[10,3,10,6],[11,17,11,19],[11,9,11,16],[11,7,11,8],[11,5,11,6],[11,3,11,4],[12,1,12,2],[12,7,12,8],[12,17,12,19],[12,5,12,6],[12,9,12,16],[25,5,25,6],[25,7,25,8],[25,9,25,11],[25,12,25,15],[25,16,25,19],[24,1,24,2],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,11],[24,16,24,19],[25,3,25,4],[24,12,24,15],[26,1,26,2],[26,3,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,11],[29,12,29,13],[29,14,29,15],[29,16,29,17],[29,18,29,19],[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],[32,18,32,19],[33,14,33,15],[30,16,30,17],[33,16,33,17],[30,10,30,11],[31,10,31,11],[27,9,27,11],[27,12,27,15],[27,16,27,19],[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],[48,0,48,19],[40,0,40,19],[42,0,42,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],[30,14,30,15],[31,14,31,15],[32,10,32,11],[32,12,32,13],[32,14,32,15],[32,16,32,17]]}
["INCOME TAX CALCULATION FOR FINANCIAL YEAR 2015-2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Developed by Keshav Das Gupta, Senior Teacher (Science), Govt. Sec. School, Machchhipura,                                                                                                                               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,"GENERAL INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"How to use",null,null,null,null,3]
["NAME","KESHAV DAS GUPTA",null,null,null,"PAN",null,null,null,null,"G","G","a","a","a",9,9,9,9,"b",4]
["DESIGNATION","SENIOR TEACHER",null,null,null,"NAME OF OFFICE",null,null,null,null,"GOVT SEC SCHOOL, SAWAI MADHOPUR",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","HEAD MASTER",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,"SBBJ, JOHRI BAZAR 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 2015                              (Pay band + Grade Pay)",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 \n¼is cS.M $ xzsM is½",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,"10 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 20 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½",7,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","RENT RECEIVED",null,null,"HOUSE TAX",null,null,null,"MENDING (30% OF (RENT RECEIVED\n-HOUSE TAX)",null,null,null,null,"INTEREST ON BONDS"]
["INTEREST ON NSC                      (AUTOMATED FROM SHEET NSC INTEREST)",{"$f":"ROUND((SUM('nsc int'!E9:'nsc int'!E14))+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),0)","v":0},null,"INTEREST ON FDR",null,null,null,null,"INTEREST ON SAVING ACCOUNT",null,null,null,null,"OTHER INCOME"]
["INVESTMENTS"]
["D;k vki u;h isU'ku ;kstuk ds lnL; gSaA ;fn gka rks lysDV djsa",null,"LIC PREMIUM (Deposited Directly)",null,"LIC PREMIUM FROM SALARY",null,null,null,null,"US 80CCD\n(1B)",null,null,"US 80 CCG"]
["HOME LOAN CAPITAL",null,null,"HOME LOAN INTEREST",null,null,null,"NSC INTEREST REINVESTMENT",null,{"$f":"ROUND((B20-'nsc int'!E14-'nsc int'!G13-'nsc int'!I13-'nsc int'!E31-'nsc int'!G31),0)","v":0},null,null,"US 80 CCC"]
["NEW NSC PURCHASE",null,null,"PLI",null,null,null,"SUKANYA SMRIDDHI YOJNA",null,null,null,null,"TUTION FEE"]
["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"]
["US 80 G",null,null,"US 80 GGA",null,null,null,"US 80 U",null,null,null,null,"REBATE                           US 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.'!E46","v":0},null,null,"INCOME TAX AFTER TDS",null,null,null,{"$f":"IF('I T cal.'!E56=\"0\",'I T cal.'!E55,'I T cal.'!E56)","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":"2015-10-27"},"2016-10-31"]

{"sheet":"control","index":3,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,14],[2,0,2,1],[2,10,2,14],[3,4,3,5],[4,0,4,1],[4,2,4,3],[4,4,4,5],[23,0,23,1],[23,2,23,4],[4,6,4,10],[4,11,4,13],[2,2,2,5],[2,6,2,7],[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]]}
["CONTROL"]
["Sex",null,"Bonus",1,"Bonus months",12,"US 80G",2,"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>=250,\"247.19\",\"0\")","v":"0"}]
[null,null,{"$f":"IF(D2=2,0,ROUND((3387*F2/12),0))","v":3387},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}]
["NO HRA",false,"NO CCA",true,null,null,"CPF",false,"SURRENDER",{"$f":"profile!B14","v":7},{"$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>8,J4=1,J4=2),M4*1.19,IF(J4=3,M4*1.07,IF(J4>3,M4*1.13,\"0\"))),0)","v":0}]
["Salary",null,"HRA",null,"CCA",null,"G P F / C P F",null,null,null,null,"S I",null,null,"Serv. Tax"]
[null,null,true,false,false,false,null,{"$f":"IF(salary!C6>31000,\"5200\",IF(salary!C6>28000,\"4100\",IF(salary!C6>24000,\"3300\",IF(salary!C6>20000,\"2100\",IF(salary!C6>15000,\"1450\",IF(salary!C6>11000,\"1100\",IF(salary!C6>9000,\"650\",IF(salary!C6>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C6>65000,\"6200\",IF(salary!C6>45000,\"5700\",H6))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C6+salary!D6),I6),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=3,profile!$P$11,profile!$B$11)","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C7>31000,\"5200\",IF(salary!C7>28000,\"4100\",IF(salary!C7>24000,\"3300\",IF(salary!C7>20000,\"2100\",IF(salary!C7>15000,\"1450\",IF(salary!C7>11000,\"1100\",IF(salary!C7>9000,\"650\",IF(salary!C7>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C7>65000,\"6200\",IF(salary!C7>45000,\"5700\",H7))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C7+salary!D7),I7),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=4,profile!$P$11,A7)","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C8>31000,\"5200\",IF(salary!C8>28000,\"4100\",IF(salary!C8>24000,\"3300\",IF(salary!C8>20000,\"2100\",IF(salary!C8>15000,\"1450\",IF(salary!C8>11000,\"1100\",IF(salary!C8>9000,\"650\",IF(salary!C8>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C8>65000,\"6200\",IF(salary!C8>45000,\"5700\",H8))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C8+salary!D8),I8),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=5,profile!$P$11,A8)","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C9>31000,\"5200\",IF(salary!C9>28000,\"4100\",IF(salary!C9>24000,\"3300\",IF(salary!C9>20000,\"2100\",IF(salary!C9>15000,\"1450\",IF(salary!C9>11000,\"1100\",IF(salary!C9>9000,\"650\",IF(salary!C9>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C9>65000,\"6200\",IF(salary!C9>45000,\"5700\",H9))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C9+salary!D9),I9),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=6,profile!$P$11,A9)","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C10>31000,\"5200\",IF(salary!C10>28000,\"4100\",IF(salary!C10>24000,\"3300\",IF(salary!C10>20000,\"2100\",IF(salary!C10>15000,\"1450\",IF(salary!C10>11000,\"1100\",IF(salary!C10>9000,\"650\",IF(salary!C10>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C10>65000,\"6200\",IF(salary!C10>45000,\"5700\",H10))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C10+salary!D10),I10),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=7,profile!$P$11,IF($K$2=1,ROUNDDOWN(J2,-1),ROUNDUP((salary!C9*1.03),-1)))","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C11>31000,\"5200\",IF(salary!C11>28000,\"4100\",IF(salary!C11>24000,\"3300\",IF(salary!C11>20000,\"2100\",IF(salary!C11>15000,\"1450\",IF(salary!C11>11000,\"1100\",IF(salary!C11>9000,\"650\",IF(salary!C11>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C11>65000,\"6200\",IF(salary!C11>45000,\"5700\",H11))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C11+salary!D11),I11),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=8,profile!$P$11,A11)","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C12>31000,\"5200\",IF(salary!C12>28000,\"4100\",IF(salary!C12>24000,\"3300\",IF(salary!C12>20000,\"2100\",IF(salary!C12>15000,\"1450\",IF(salary!C12>11000,\"1100\",IF(salary!C12>9000,\"650\",IF(salary!C12>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C12>65000,\"6200\",IF(salary!C12>45000,\"5700\",H12))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C12+salary!D12),I12),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=9,profile!$P$11,A12)","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C13>31000,\"5200\",IF(salary!C13>28000,\"4100\",IF(salary!C13>24000,\"3300\",IF(salary!C13>20000,\"2100\",IF(salary!C13>15000,\"1450\",IF(salary!C13>11000,\"1100\",IF(salary!C13>9000,\"650\",IF(salary!C13>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C13>65000,\"6200\",IF(salary!C13>45000,\"5700\",H13))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C13+salary!D13),I13),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=10,profile!$P$11,A13)","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C14>31000,\"5200\",IF(salary!C14>28000,\"4100\",IF(salary!C14>24000,\"3300\",IF(salary!C14>20000,\"2100\",IF(salary!C14>15000,\"1450\",IF(salary!C14>11000,\"1100\",IF(salary!C14>9000,\"650\",IF(salary!C14>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C14>65000,\"6200\",IF(salary!C14>45000,\"5700\",H14))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C14+salary!D14),I14),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=11,profile!$P$11,A14)","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C15>31000,\"5200\",IF(salary!C15>28000,\"4100\",IF(salary!C15>24000,\"3300\",IF(salary!C15>20000,\"2100\",IF(salary!C15>15000,\"1450\",IF(salary!C15>11000,\"1100\",IF(salary!C15>9000,\"650\",IF(salary!C15>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C15>65000,\"6200\",IF(salary!C15>45000,\"5700\",H15))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C15+salary!D15),I15),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=12,profile!$P$11,A15)","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C16>31000,\"5200\",IF(salary!C16>28000,\"4100\",IF(salary!C16>24000,\"3300\",IF(salary!C16>20000,\"2100\",IF(salary!C16>15000,\"1450\",IF(salary!C16>11000,\"1100\",IF(salary!C16>9000,\"650\",IF(salary!C16>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C16>65000,\"6200\",IF(salary!C16>45000,\"5700\",H16))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C16+salary!D16),I16),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=1,profile!$P$11,A16)","v":0},null,null,null,null,null,null,{"$f":"IF(salary!C17>31000,\"5200\",IF(salary!C17>28000,\"4100\",IF(salary!C17>24000,\"3300\",IF(salary!C17>20000,\"2100\",IF(salary!C17>15000,\"1450\",IF(salary!C17>11000,\"1100\",IF(salary!C17>9000,\"650\",IF(salary!C17>=6050,\"500\",\"0\"))))))))","v":"0"},{"$f":"IF(salary!C17>65000,\"6200\",IF(salary!C17>45000,\"5700\",H17))","v":"0"},null,{"$f":"ROUND(IF($H$4=TRUE,10%*(salary!C17+salary!D17),I17),0)","v":0},null,{"$f":"IF(salary!$C$6>28000,\"2650\",IF(salary!$C$6>18000,\"1550\",IF(salary!$C$6>11000,\"1100\",IF(salary!$C$6>8500,\"550\",IF(salary!$C$6>=6050,\"400\",\"0\")))))","v":"0"}]
[{"$f":"IF($M$2=2,profile!$P$11,A17)","v":0}]
["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,10%*salary!C6,IF($D$6=TRUE,20%*salary!C6,\"0\"))),0)","v":0},{"$f":"IF(salary!C6>9000,480,IF(salary!C6>7000,300,IF(salary!C6>=6050,190,0)))","v":0},{"$f":"IF(salary!C6>9000,240,IF(salary!C6>7000,130,IF(salary!C6>=6050,70,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*1.07),0)","v":0},{"$f":"ROUND((salary!C6*0.06),0)*3+ROUND(IF(J4=3,M4*0.06),0)","v":0},{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C6>21000,\"535\",IF(salary!C6>13000,\"401\",IF(salary!C6>7000,\"268\",IF(salary!C6>=6050,\"161\",\"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,10%*salary!C7,IF($D$6=TRUE,20%*salary!C7,\"0\"))),0)","v":0},{"$f":"IF(salary!C7>9000,480,IF(salary!C7>7000,300,IF(salary!C7>=6050,190,0)))","v":0},{"$f":"IF(salary!C7>9000,240,IF(salary!C7>7000,130,IF(salary!C7>=6050,70,0)))","v":0},{"$f":"ROUND(IF($D$4=TRUE,\"0\",IF($E$6=TRUE,G21,IF($F$6=TRUE,H21,\"0\"))),0)","v":0},{"$f":"ROUND((salary!C7*1.13),0)","v":0},{"$f":"IF($H$4=TRUE,ROUND(((ROUND((salary!C6*0.06),0)*3)*0.1),0),K20)","v":0},{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C7>21000,\"535\",IF(salary!C7>13000,\"401\",IF(salary!C7>7000,\"268\",IF(salary!C7>=6050,\"161\",\"0\")))))","v":"0"},"April"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,10%*salary!C8,IF($D$6=TRUE,20%*salary!C8,\"0\"))),0)","v":0},{"$f":"IF(salary!C8>9000,480,IF(salary!C8>7000,300,IF(salary!C8>=6050,190,0)))","v":0},{"$f":"IF(salary!C8>9000,240,IF(salary!C8>7000,130,IF(salary!C8>=6050,70,0)))","v":0},0,{"$f":"ROUND((salary!C8*1.13),0)","v":0},{"$f":"ROUND((salary!C10*0.06),0)+ROUND((salary!C11*0.06),0)+ROUND(IF(OR(J4=7,J4=8),M4*0.06),0)","v":0},{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C8>21000,\"565\",IF(salary!C8>13000,\"424\",IF(salary!C8>7000,\"283\",IF(salary!C8>=6050,\"170\",\"0\")))))","v":"0"},"May"]
["HRA rent receipt req",null,{"$f":"ROUND((10%*(ROUND((salary!C6*1.13),0)+ROUND((salary!C7*1.13),0)+ROUND((salary!C8*1.13),0)+ROUND((salary!C9*1.13),0)+ROUND((salary!C10*1.19),0)+ROUND((salary!C11*1.19),0)+ROUND((salary!C12*1.19),0)+ROUND((salary!C13*1.19),0)+ROUND((salary!C14*1.19),0)+ROUND((salary!C15*1.19),0)+ROUND((salary!C16*1.19),0)+ROUND((salary!C17*1.19),0)+SUM(salary!C6:'salary'!C17))+salary!E25),0)","v":0},null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,10%*salary!C9,IF($D$6=TRUE,20%*salary!C9,\"0\"))),0)","v":0},{"$f":"IF(salary!C9>9000,480,IF(salary!C9>7000,300,IF(salary!C9>=6050,190,0)))","v":0},{"$f":"IF(salary!C9>9000,240,IF(salary!C9>7000,130,IF(salary!C9>=6050,70,0)))","v":0},0,{"$f":"ROUND((salary!C9*1.13),0)","v":0},{"$f":"IF($H$4=TRUE,ROUND(((ROUND((salary!C10*0.06),0)+ROUND((salary!C11*0.06),0))*0.1),0),K22)","v":0},{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C9>21000,\"565\",IF(salary!C9>13000,\"424\",IF(salary!C9>7000,\"283\",IF(salary!C9>=6050,\"170\",\"0\")))))","v":"0"},"June"]
["US 80 CCD(1)",null,{"$f":"IF(salary!L25<=150000,salary!L25,150000)","v":0},null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,10%*salary!C10,IF($D$6=TRUE,20%*salary!C10,\"0\"))),0)","v":0},{"$f":"IF(salary!C10>9000,480,IF(salary!C10>7000,300,IF(salary!C10>=6050,190,0)))","v":0},{"$f":"IF(salary!C10>9000,240,IF(salary!C10>7000,130,IF(salary!C10>=6050,70,0)))","v":0},0,{"$f":"ROUND((salary!C10*1.13),0)","v":0},null,{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C10>21000,\"565\",IF(salary!C10>13000,\"424\",IF(salary!C10>7000,\"283\",IF(salary!C10>=6050,\"170\",\"0\")))))","v":"0"},"July"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,10%*salary!C11,IF($D$6=TRUE,20%*salary!C11,\"0\"))),0)","v":0},{"$f":"IF(salary!C11>9000,480,IF(salary!C11>7000,300,IF(salary!C11>=6050,190,0)))","v":0},{"$f":"IF(salary!C11>9000,240,IF(salary!C11>7000,130,IF(salary!C11>=6050,70,0)))","v":0},0,{"$f":"ROUND((salary!C11*1.13),0)","v":0},null,{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C11>21000,\"565\",IF(salary!C11>13000,\"424\",IF(salary!C11>7000,\"283\",IF(salary!C11>=6050,\"170\",\"0\")))))","v":"0"},"August"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,10%*salary!C12,IF($D$6=TRUE,20%*salary!C12,\"0\"))),0)","v":0},{"$f":"IF(salary!C12>9000,480,IF(salary!C12>7000,300,IF(salary!C12>=6050,190,0)))","v":0},{"$f":"IF(salary!C12>9000,240,IF(salary!C12>7000,130,IF(salary!C12>=6050,70,0)))","v":0},0,{"$f":"ROUND((salary!C12*1.19),0)","v":0},null,{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C12>21000,\"565\",IF(salary!C12>13000,\"424\",IF(salary!C12>7000,\"283\",IF(salary!C12>=6050,\"170\",\"0\")))))","v":"0"},"Sept"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,10%*salary!C13,IF($D$6=TRUE,20%*salary!C13,\"0\"))),0)","v":0},{"$f":"IF(salary!C13>9000,480,IF(salary!C13>7000,300,IF(salary!C13>=6050,190,0)))","v":0},{"$f":"IF(salary!C13>9000,240,IF(salary!C13>7000,130,IF(salary!C13>=6050,70,0)))","v":0},0,{"$f":"ROUND((salary!C13*1.19),0)","v":0},null,{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C13>21000,\"595\",IF(salary!C13>13000,\"447\",IF(salary!C13>7000,\"298\",IF(salary!C13>=6050,\"179\",\"0\")))))","v":"0"},"Oct"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,10%*salary!C14,IF($D$6=TRUE,20%*salary!C14,\"0\"))),0)","v":0},{"$f":"IF(salary!C14>9000,480,IF(salary!C14>7000,300,IF(salary!C14>=6050,190,0)))","v":0},{"$f":"IF(salary!C14>9000,240,IF(salary!C14>7000,130,IF(salary!C14>=6050,70,0)))","v":0},0,{"$f":"ROUND((salary!C14*1.19),0)","v":0},null,{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C14>21000,\"595\",IF(salary!C14>13000,\"447\",IF(salary!C14>7000,\"298\",IF(salary!C14>=6050,\"179\",\"0\")))))","v":"0"},"Nov"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,10%*salary!C15,IF($D$6=TRUE,20%*salary!C15,\"0\"))),0)","v":0},{"$f":"IF(salary!C15>9000,480,IF(salary!C15>7000,300,IF(salary!C15>=6050,190,0)))","v":0},{"$f":"IF(salary!C15>9000,240,IF(salary!C15>7000,130,IF(salary!C15>=6050,70,0)))","v":0},0,{"$f":"ROUND((salary!C15*1.19),0)","v":0},null,{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C15>21000,\"595\",IF(salary!C15>13000,\"447\",IF(salary!C15>7000,\"298\",IF(salary!C15>=6050,\"179\",\"0\")))))","v":"0"},"Dec"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,10%*salary!C16,IF($D$6=TRUE,20%*salary!C16,\"0\"))),0)","v":0},{"$f":"IF(salary!C16>9000,480,IF(salary!C16>7000,300,IF(salary!C16>=6050,190,0)))","v":0},{"$f":"IF(salary!C16>9000,240,IF(salary!C16>7000,130,IF(salary!C16>=6050,70,0)))","v":0},0,{"$f":"ROUND((salary!C16*1.19),0)","v":0},null,{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C16>21000,\"595\",IF(salary!C16>13000,\"447\",IF(salary!C16>7000,\"298\",IF(salary!C16>=6050,\"179\",\"0\")))))","v":"0"},"Jan"]
[null,null,null,null,null,{"$f":"ROUND(IF($B$4=TRUE,\"0\",IF($C$6=TRUE,10%*salary!C17,IF($D$6=TRUE,20%*salary!C17,\"0\"))),0)","v":0},{"$f":"IF(salary!C17>9000,480,IF(salary!C17>7000,300,IF(salary!C17>=6050,190,0)))","v":0},{"$f":"IF(salary!C17>9000,240,IF(salary!C17>7000,130,IF(salary!C17>=6050,70,0)))","v":0},0,{"$f":"ROUND((salary!C17*1.19),0)","v":0},null,{"$f":"IF($H$4=TRUE,\"0\",IF(salary!C17>21000,\"595\",IF(salary!C17>13000,\"447\",IF(salary!C17>7000,\"298\",IF(salary!C17>=6050,\"179\",\"0\")))))","v":"0"},"Feb"]

{"sheet":"Partial HRA","index":4,"n_rows":17,"n_cols":10,"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,"MONTHS","\"Y\"","Basic Pay.","HRA",null,"Please select months by typing \"Y\" "]
[null,"MARCH 15 ","y",{"$f":"IF(C5=\"Y\",salary!C6+ROUND((113%*salary!C6),0),\"0\")","v":0},{"$f":"IF(C5=\"Y\",salary!E6,\"0\")","v":0}]
[null,"APRIL 15","y",{"$f":"IF(C6=\"Y\",salary!C7+ROUND((113%*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 15","y",{"$f":"IF(C7=\"Y\",salary!C8+ROUND((113%*salary!C8),0),\"0\")","v":0},{"$f":"IF(C7=\"Y\",salary!E8,\"0\")","v":0}]
[null,"JUNE 15","y",{"$f":"IF(C8=\"Y\",salary!C9+ROUND((113%*salary!C9),0),\"0\")","v":0},{"$f":"IF(C8=\"Y\",salary!E9,\"0\")","v":0}]
[null,"JULY 15","y",{"$f":"IF(C9=\"Y\",salary!C10+ROUND((119%*salary!C10),0),\"0\")","v":0},{"$f":"IF(C9=\"Y\",salary!E10,\"0\")","v":0},null,"RENT PAID AMOUNT"]
[null,"AUGUST 15","y",{"$f":"IF(C10=\"Y\",salary!C11+ROUND((119%*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 15","y",{"$f":"IF(C11=\"Y\",salary!C12+ROUND((119%*salary!C12),0),\"0\")","v":0},{"$f":"IF(C11=\"Y\",salary!E12,\"0\")","v":0}]
[null,"OCTOBER 15","y",{"$f":"IF(C12=\"Y\",salary!C13+ROUND((119%*salary!C13),0),\"0\")","v":0},{"$f":"IF(C12=\"Y\",salary!E13,\"0\")","v":0}]
[null,"NOVEMBER 15","y",{"$f":"IF(C13=\"Y\",salary!C14+ROUND((119%*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,"DECEMBER 15","y",{"$f":"IF(C14=\"Y\",salary!C15+ROUND((119%*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,"JANUARY 16","y",{"$f":"IF(C15=\"Y\",salary!C16+ROUND((119%*salary!C16),0),\"0\")","v":0},{"$f":"IF(C15=\"Y\",salary!E16,\"0\")","v":0}]
[null,"FEBRUARY 16","y",{"$f":"IF(C16=\"Y\",salary!C17+ROUND((119%*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,{"$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":[[32,0,32,25],[34,0,34,25],[36,0,36,25],[38,0,38,25],[29,7,30,18],[26,10,26,14],[2,0,3,0],[2,1,3,1],[2,2,2,10],[2,24,3,24],[26,21,26,26],[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]]}
["osru o dVkSfr;ksa dk fooj.k 2015 & 2016"]
[{"$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":"Senior Teacher"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"PROPER(IF(profile!K5=\"\",\"\",profile!K5))","v":"Govt Sec School, Sawai Madhopur"}]
["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,\",u ih ,l\",\"th ih ,Q\")","v":"th ih ,Q"},"th ih ,Q _.k","jkT; chek","lsok dj","jkT; chek _.k","RPMF","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&15",{"$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"},{"$f":"control!O6","v":0},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&15",{"$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"},{"$f":"control!O7","v":0},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&15",{"$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"},{"$f":"control!O8","v":0},null,{"$f":"control!L22","v":"0"},{"$f":"R7","v":0},null,null,null,{"$f":"profile!D31","v":0},null,0,0]
[4,"twu&15",{"$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"},{"$f":"control!O9","v":0},null,{"$f":"control!L23","v":"0"},0,null,null,null,{"$f":"profile!E31","v":0},null,0,0]
[5,"tqyk-&15",{"$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"},{"$f":"control!O10","v":0},null,{"$f":"control!L24","v":"0"},0,null,null,null,{"$f":"profile!F31","v":0},null,0,0]
[6,"vx-&15",{"$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"},{"$f":"control!O11","v":0},null,{"$f":"control!L25","v":"0"},0,null,null,null,{"$f":"profile!G31","v":0},null,0,0]
[7,"flr-&15",{"$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"},{"$f":"control!O12","v":0},null,{"$f":"control!L26","v":"0"},0,null,null,null,{"$f":"profile!H31","v":0},null,0,0]
[8,"vDVw-&15",{"$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"},{"$f":"control!O13","v":0},null,{"$f":"control!L27","v":"0"},0,null,null,null,{"$f":"profile!I31","v":0},null,0,0]
[9,"uc-&15",{"$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"},{"$f":"control!O14","v":0},null,{"$f":"control!L28","v":"0"},0,null,null,null,{"$f":"profile!J31","v":0},null,0,0]
[10,"fnl-&15",{"$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"},{"$f":"control!O15","v":0},null,{"$f":"control!L29","v":"0"},0,null,null,null,{"$f":"profile!K31","v":0},null,0,0]
[11,"tu-&16",{"$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"},{"$f":"control!O16","v":0},null,{"$f":"control!L30","v":"0"},0,null,null,null,{"$f":"profile!M31","v":0},null,0,0]
[12,"Qj-&16",{"$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"},{"$f":"control!O17","v":0},null,{"$f":"control!L31","v":"0"},0,null,null,null,{"$f":"profile!O31","v":0},null,0,0]
[13,"Mh , ,fj",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",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":3387},null,null,null,3387,null,null,null,null,null,null,null,null,null,null,null,null,0,3387]
[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,3387,0,0,0,3387,0,0,0,0,0,0,0,0,0,0,0,0,0,3387]
[]
[null,null,null,null,null,null,null,null,null,null,"gLrk{kj deZpkjh ",null,null,null,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*1.13),0)+ROUND((salary!C7*1.13),0)+ROUND((salary!C8*1.13),0)+ROUND((salary!C9*1.13),0)+ROUND((salary!C10*1.19),0)+ROUND((salary!C11*1.19),0)+ROUND((salary!C12*1.19),0)+ROUND((salary!C13*1.19),0)+ROUND((salary!C14*1.19),0)+ROUND((salary!C15*1.19),0)+ROUND((salary!C16*1.19),0)+ROUND((salary!C17*1.19),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":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":true,"merged":[[3,6,7,9],[7,3,7,4],[6,0,6,1],[31,0,31,3],[32,0,32,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[26,0,26,3],[4,0,4,2],[19,0,19,1],[13,0,13,4],[22,0,22,1],[9,0,9,4],[23,0,23,3],[44,0,44,3],[15,0,15,1],[0,0,0,4],[2,1,2,2],[2,3,2,4],[1,2,1,4],[18,0,18,1],[24,0,24,1],[33,0,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[41,0,41,1],[41,2,41,3],[3,1,3,2],[45,0,45,3],[37,0,37,3],[12,0,12,3],[58,3,58,4],[53,0,53,3],[54,0,54,3],[55,0,55,3],[14,0,14,1],[16,0,16,1],[17,0,17,1],[25,0,25,4],[20,0,20,1],[21,0,21,1],[46,0,46,4],[38,0,38,3],[43,0,43,3]]}
["vk;dj x.kuk i= ys[kk o\"kZ 2015&2016 dj fu/kkZj.k o\"kZ 2016&2017"]
[{"$f":"PROPER(IF(profile!B4=\"\",\"\",profile!B4))","v":"Keshav Das Gupta"},{"$f":"PROPER(IF(profile!B5=\"\",\"\",profile!B5))","v":"Senior Teacher"},{"$f":"PROPER(IF(profile!K5=\"\",\"\",profile!K5))","v":"Govt Sec School, Sawai Madhopur"}]
[{"$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:-SBBJ, JOHRI BAZAR JAIPUR"}]
["1- osru en esa vk; ¼HkÙkksa lfgr½",{"$f":"IF(control!H4=TRUE,\"(+ Govt. Contri. towards NPS)\",\"\")","v":""},null,null,{"$f":"salary!K25+IF(control!H4=TRUE,salary!L25,\"0\")","v":3387},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":3387}]
["?kVkb;s& dVkSfr;ka US10 (13 A)",{"$f":"IF(control!J3>0,control!J3,IF('Partial HRA'!J10>0,'Partial HRA'!J10,\"0\"))","v":"0"},"US10 ",0,{"$f":"E5-(B6+D6)","v":3387}]
["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},{"$f":"E6+D7","v":3387}]
["¼1½ x`gdj","¼2½ ejEer-","¼3½ _.k ij C;kt","¼4½ ;ksx 1 ls 3"]
[{"$f":"profile!G19","v":0},{"$f":"profile!K19","v":0},{"$f":"IF(profile!F23<=200000,profile!F23,200000)","v":0},{"$f":"A9+B9+C9","v":0},{"$f":"E7-D9","v":3387}]
["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":"E9+A12+B12+C12+D12+E12","v":3387}]
["v/;k; VI A ds vUrxZr dVkSfr;ka "]
["GPF",null,{"$f":"IF(control!H4=TRUE,\"0\",salary!L25)","v":0},"US 80CCD(1)",{"$f":"IF(control!H4=TRUE,control!C24,\"0\")","v":"0"}]
["S I",null,{"$f":"salary!N25","v":0},"Tution fee: 2 children",{"$f":"profile!Q24","v":0}]
["LIC",null,{"$f":"profile!D22+salary!R25","v":0},"jk\"Vªh; cpr i= ",{"$f":"profile!B24","v":0}]
["Gr. Acc. Ins.",null,{"$f":"IF(salary!W7=\"247.19\",220,\"0\")","v":"0"},"jk\"Vªh; cpr i= ij vnÙk C;kt",{"$f":"profile!J23","v":0}]
["ULIP",null,{"$f":"profile!Q25","v":0},"bfDoVh fyad lsfoax Ldhe",{"$f":"profile!B25","v":0}]
["Hkou _.k iquHkqZxrku ",null,{"$f":"profile!B23","v":0},"LFkfxr okf\"kZdh",{"$f":"profile!F26","v":0}]
["PPF",null,{"$f":"profile!J25","v":0},"LFkkbZ tek 5 o\"kZ",{"$f":"profile!B26","v":0}]
["PLI",null,{"$f":"profile!F24","v":0},"lqdU;k le`f) ;kstuk",{"$f":"profile!J24","v":0}]
["NOTIFIED BOND OF NABARD",null,{"$f":"profile!F25","v":0},"US 80CCC",{"$f":"profile!Q23","v":0}]
[{"$f":"CONCATENATE(\"TOTAL\",IF(control!H4=TRUE,\" (excluding govt. contri. to NPS)\",\"\"))","v":"TOTAL"},null,null,null,{"$f":"SUM(E15:E23)+SUM(C15:C23)","v":0}]
["Qualifying Amount US80CCE (Max Rs 150000/)",null,{"$f":"IF(control!H4=TRUE,\"+US 80CCD(2)\",\"\")","v":""},{"$f":"CONCATENATE(IF(control!H4=TRUE,\"Rs.\",\"\"),IF(control!H4=TRUE,salary!L25,\"\"))","v":""},{"$f":"IF(E24<=150000,E24,150000)+IF(control!H4=TRUE,salary!L25,\"0\")","v":0}]
["vU; dVkSfr;ka "]
["US 80 CCG Max Rs 25000/",null,null,null,{"$f":"IF(ROUND((profile!Q22/2),0)<=25000,ROUND((profile!Q22/2),0),25000)","v":0}]
["US 80D",null,null,null,{"$f":"profile!Q26","v":0}]
["US 80DD",null,null,null,{"$f":"profile!B27","v":0}]
["US 80DDB  (Patient suffering from Cancer, AIDS, Chronical renal failure, Thalassaemia etc.)",null,null,null,{"$f":"profile!F27","v":0}]
["US 80 E",null,null,null,{"$f":"profile!J27","v":0}]
["US 80G",null,null,null,{"$f":"control!G3","v":0}]
["US 80GG ¼Hkqxrku fd, x, Hkou fdjk;s ds ckjs es dVkSrh] vf/kdre `2000 rd½",null,null,null,{"$f":"IF(profile!Q27<=24000,profile!Q27,24000)","v":0}]
["US 80GGA  ¼vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl gsrq fn;k x;k nku 100%½",null,null,null,{"$f":"profile!F28","v":0}]
["US 80U",null,null,null,{"$f":"profile!J28","v":0}]
["US 80 TTA",null,null,null,{"$f":"IF(profile!J26<=10000,profile!J26,10000)","v":0}]
["US 80 CCD (1B)",null,null,null,{"$f":"IF(profile!K22<=50000,profile!K22,50000)","v":0}]
["v/;k; VI A ds vUrxZr dqy dVkSfr;ka ",null,null,null,{"$f":"E25+E27+E28+E29+E30+E31+E32+E33+E34+E35+E36+E37","v":0}]
["'kq) dj ;ksX; vk; ¼iw.kkZad esa½",null,null,null,{"$f":"ROUND((E13-E38),-1)","v":3390}]
["TAX FOR MEN",null,null,null,{"$f":"ROUND(IF(E39<=250000,0,IF(E39<=500000,(E39-250000)*0.1,IF(E39<=1000000,25000+(E39-500000)*0.2,IF(E39>1000000,125000+(E39-1000000)*0.3,\"0\")))),0)","v":0}]
["Tax Credit, Max Rs 2000/",null,null,null,{"$f":"IF(AND(E39<=500000,E40>=2000),E40-2000,IF(AND(E39<=500000,E40<2000),0,E40))","v":0}]
[{"$f":"CONCATENATE(\"dqy vk;dj ns;rk\")","v":"dqy vk;dj ns;rk"},null,{"$f":"IF(E39<=500000,\"( With US 87A Tax Credit Max Rs 2000/)\",0)","v":"( With US 87A Tax Credit Max Rs 2000/)"},null,{"$f":"IF(E39<=500000,E41,E40)","v":0}]
["f'k{kk midj  2%",{"$f":"ROUND((E42*0.02),0)","v":0},"mPp f'k{kk midj 1%",{"$f":"ROUND((E42*0.01),0)","v":0},{"$f":"B43+D43","v":0}]
["dqy vk;dj",null,null,null,{"$f":"E42+E43","v":0}]
["REBATE US 89 (1)",null,null,null,{"$f":"profile!Q28","v":0}]
["dqy dj ns;rk",null,null,null,{"$f":"E44-E45","v":0}]
["óksr ij gqbZ dVkSrh"]
["ekpZ 2015",{"$f":"salary!V6+IF(profile!B14=3,salary!V20,0)","v":0},"flrEcj 2015",{"$f":"salary!V12+IF(profile!B14=9,salary!V20,0)","v":0},"fQDls'ku ,fj;j ls Vh Mh ,l"]
["vizsy 2015",{"$f":"salary!V7+IF(profile!B14=4,salary!V20,0)","v":0},"vDVwcj 2015",{"$f":"salary!V13+IF(profile!B14=10,salary!V20,0)","v":0},{"$f":"salary!V22+salary!V23+salary!V24","v":0}]
["ebZ 2015",{"$f":"salary!V8+IF(profile!B14=5,salary!V20,0)","v":0},"uoEcj 2015",{"$f":"salary!V14+IF(profile!B14=11,salary!V20,0)","v":0}]
["twu 2015",{"$f":"salary!V9+IF(profile!B14=6,salary!V20,0)","v":0},"fnlEcj 2015",{"$f":"salary!V15+IF(profile!B14=12,salary!V20,0)","v":0}]
["tqykbZ 2015",{"$f":"salary!V10+IF(profile!B14=7,salary!V20,0)","v":0},"tuojh 2016",{"$f":"salary!V16+IF(profile!B14=1,salary!V20,0)","v":0}]
["vxLr 2015",{"$f":"salary!V11+IF(profile!B14=8,salary!V20,0)","v":0},"Qjojh 2016",{"$f":"salary!V17+IF(profile!B14=2,salary!V20,0)","v":0}]
["óksr ij gqbZ dqy dVkSrh",null,null,null,{"$f":"SUM(B48:B53)+SUM(D48:D53)+E49","v":0}]
["'ks\"k dj ns;rk ",null,null,null,{"$f":"IF(E46>E54,E46-E54,\"0\")","v":"0"}]
["dj fjQ.M",null,null,null,{"$f":"IF(E54>E46,E46-E54,\"0\")","v":"0"}]
[]
[]
[null,null,null,"gLrk{kj deZpkjh "]

{"sheet":"Form 16","index":8,"n_rows":159,"n_cols":17,"rows_kept":159,"cut":false,"hidden":true,"merged":[[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],[142,0,142,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],[8,8,8,10],[9,5,9,7],[143,0,145,10],[146,0,148,10],[149,0,152,10],[121,5,121,6],[122,5,122,6],[125,5,125,6],[126,5,126,6],[127,5,127,6],[128,5,128,6],[129,5,129,6],[121,7,121,8],[122,7,122,8],[125,7,125,8],[126,7,126,8],[127,7,127,8],[128,7,128,8],[129,7,129,8],[134,0,134,10],[135,0,135,1],[135,2,135,3],[135,4,135,10],[136,0,136,1],[136,4,136,10],[137,0,137,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],[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],[72,5,72,6],[73,0,73,4],[73,5,73,6],[74,0,74,4],[74,5,74,6],[75,0,75,4],[75,5,78,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,84,10],[72,0,72,4],[80,0,80,4],[80,5,81,6],[80,7,80,8],[81,0,81,4],[82,0,82,1],[82,2,82,4],[82,5,82,6],[75,7,75,8],[76,0,76,4],[90,9,90,10],[91,0,91,4],[91,9,92,10],[92,0,92,4],[76,7,79,8],[77,0,77,2],[77,3,77,4],[78,0,78,2],[79,0,79,2],[79,5,79,6],[83,0,83,1],[83,2,83,4],[83,5,83,6],[87,0,87,3],[88,0,88,3],[89,0,89,3],[89,7,89,8],[84,0,84,4],[84,5,92,6],[84,7,84,8],[85,0,85,4],[85,7,88,8],[90,0,90,4],[90,7,92,8],[114,0,114,4],[94,0,94,4],[94,5,94,6],[94,7,104,8],[95,0,95,4],[95,5,95,6],[96,0,96,4],[96,5,96,6],[97,0,97,4],[97,5,97,6],[101,0,101,4],[101,5,101,6],[102,0,102,4],[102,5,102,6],[103,0,103,4],[103,5,103,6],[98,0,98,4],[98,5,98,6],[99,0,99,4],[99,5,99,6],[100,0,100,4],[100,5,100,6],[104,0,104,4],[104,5,104,6],[116,5,116,6],[116,7,116,8],[105,5,105,6],[105,7,107,8],[107,0,107,4],[107,5,107,6],[107,9,107,10],[111,0,111,4],[111,5,111,6],[111,7,111,8],[112,0,112,4],[112,5,112,6],[112,7,112,8],[108,0,108,4],[108,5,108,6],[108,7,108,8],[108,9,108,10],[109,0,109,4],[109,5,109,6],[109,7,109,8],[109,9,109,10],[113,0,113,4],[113,5,113,6],[113,7,113,8],[120,0,120,4],[120,5,120,6],[120,7,120,8],[120,9,120,10],[121,0,121,4],[121,9,121,10],[122,0,122,4],[122,9,122,10],[129,0,129,4],[129,9,129,10],[126,9,126,10],[127,0,127,4],[127,9,127,10],[128,0,128,4],[128,9,128,10],[123,0,123,4],[123,9,123,10],[124,0,124,4],[124,9,124,10],[125,0,125,4],[125,9,125,10],[137,2,137,3],[137,5,137,10],[153,0,157,10],[158,0,159,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],[132,0,132,1],[132,2,132,4],[132,5,132,10],[32,1,32,2],[32,5,32,7],[32,8,32,10],[33,1,33,2],[33,5,33,7],[33,8,33,10],[30,1,30,2],[30,5,30,7],[30,8,30,10],[31,1,31,2],[31,5,31,7],[31,8,31,10],[36,1,36,2],[133,0,133,10],[130,0,130,10],[131,1,131,3],[131,5,131,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],[131,9,131,10],[126,0,126,4],[27,5,27,7],[27,8,27,10],[37,1,37,2],[37,5,37,7],[37,8,37,10],[34,1,34,2],[34,5,34,7],[34,8,34,10],[35,1,35,2],[35,5,35,7],[35,8,35,10],[36,5,36,7],[36,8,36,10],[38,1,38,2],[38,5,38,7],[38,8,38,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],[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],[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],[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],[61,9,61,10],[68,0,68,1],[66,4,66,10],[67,0,67,1],[67,4,67,10],[63,7,63,10],[105,0,105,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],[93,0,93,4],[93,5,93,6],[93,7,93,8],[93,9,93,10],[85,9,85,10],[86,0,86,4],[86,9,89,10],[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],[106,0,106,4],[106,5,106,6],[103,9,106,10],[119,0,119,4],[119,5,119,6],[119,7,119,8],[110,9,119,10],[68,2,68,3],[68,5,68,10],[114,5,114,6],[114,7,114,8],[110,0,110,4],[110,5,110,6],[110,7,110,8],[117,0,117,4],[117,5,117,6],[117,7,117,8],[118,0,118,4],[118,5,118,6],[118,7,118,8],[115,0,115,4],[115,5,115,6],[115,7,115,8],[116,0,116,4]]}
["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."]
["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":"Head Master\nGovt Sec School, Sawai Madhopur"},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":"Senior Teacher"}]
["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,"2016-17",null,"From",null,"To"]
["City","Jaipur",null,"PIN Code",302005,null,null,"01-4-2015",null,"31-03-2016"]
["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,{"$f":"salary!V24","v":0},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":"HEAD MASTER"},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":"HEAD MASTER"},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":3387}]
["(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":3387}]
["2. Less: Allowance to the extent exempt u/s 10 House Rent Allowance"]
["Allowance",null,null,"Rs"]
["House Rent Allow. US10 (13 A)",null,null,{"$f":"IF(E79=\"0\",\"\",salary!E25)","v":""},{"$f":"'I T cal.'!B6","v":"0"}]
[{"$f":"'I T cal.'!C6","v":"US10 "},null,null,{"$f":"'I T cal.'!D6","v":0},{"$f":"'I T cal.'!D6","v":0},{"$f":"E79+E80","v":0}]
["3. Balance (1 - 2)",null,null,null,null,null,null,{"$f":"H76-F80","v":3387}]
["4. Deductions:"]
["(a)",null,"Entertainment allowance",null,null,0]
["(b)",null,"Tax on employment",null,null,0]
["5. Aggregate of 4(a) and (b)",null,null,null,null,null,null,{"$f":"F83+F84","v":0}]
["6. Income chargeable under the head \"salaries\" (3-5)",null,null,null,null,null,null,null,null,{"$f":"H81-H85","v":3387}]
["7. Add: Any other income reported by employee "]
["Income",null,null,null,"Rs"]
["From House Property",null,null,null,{"$f":"'I T cal.'!D7-'I T cal.'!D9","v":0}]
[{"$f":"CONCATENATE(IF('I T cal.'!A12>0,\"NSC int,\",\"\"),IF('I T cal.'!B12>0,\" FDR int,\",\"\"),IF('I T cal.'!C12>0,\" Bonds,\",\"\"),IF('I T cal.'!D12>0,\" SB a/c int,\",\"\"),IF('I T cal.'!E12>0,\" Other income\",\"\"))","v":""},null,null,null,{"$f":"SUM('I T cal.'!A12:'I T cal.'!E12)","v":0},null,null,{"$f":"E89+E90","v":0}]
["8. Gross total income (6+7)",null,null,null,null,null,null,null,null,{"$f":"J86+H90","v":3387}]
["9. Deductions under Chapter VI A"]
["(A) Section 80C, 80CCC and 80CCD"]
["(a) Section 80C",null,null,null,null,null,null,"Gross Amount",null,"Deductible Amount"]
["G P F",null,null,null,null,{"$f":"'I T cal.'!C15","v":0}]
["S I",null,null,null,null,{"$f":"'I T cal.'!C16","v":0}]
["L I C + ULIP + PLI",null,null,null,null,{"$f":"'I T cal.'!C17+'I T cal.'!C19+'I T cal.'!C22","v":0}]
["Gr. Acc. Insurance",null,null,null,null,{"$f":"'I T cal.'!C18","v":"0"}]
["Home loan capital",null,null,null,null,{"$f":"'I T cal.'!C20","v":0}]
["PPF",null,null,null,null,{"$f":"'I T cal.'!C21","v":0}]
["Notified Bond Of NABARD",null,null,null,null,{"$f":"'I T cal.'!C23","v":0}]
["Tution Fee",null,null,null,null,{"$f":"'I T cal.'!E16","v":0}]
["NSC + Interest on NSC",null,null,null,null,{"$f":"'I T cal.'!E17+'I T cal.'!E18","v":0}]
["Equity linked savings",null,null,null,null,{"$f":"'I T cal.'!E19","v":0},null,null,null,{"$f":"IF(control!H4=TRUE,\"US 80CCE (Max limit) +US 80CCD(2)\",\"\")","v":""}]
["Deferred Annuity",null,null,null,null,{"$f":"'I T cal.'!E20","v":0}]
["Fixed Deposit",null,null,null,null,{"$f":"'I T cal.'!E21","v":0}]
["Sukanya Samriddhi Yojana",null,null,null,null,{"$f":"'I T cal.'!E22","v":0}]
["(b) Section 80CCC",null,null,null,null,{"$f":"'I T cal.'!E23","v":0},null,null,null,{"$f":"CONCATENATE(IF(control!H4=TRUE,\"(Rs.\",\"\"),IF(control!H4=TRUE,salary!L25,\"\"),IF(control!H4=TRUE,\")\",\"\"))","v":""}]
["(c) Section 80CCD(1)",null,null,null,null,{"$f":"'I T cal.'!E15","v":"0"},null,{"$f":"SUM(F95:F109)","v":0},null,{"$f":"IF(H109<=150000,H109,150000)+IF(control!H4=TRUE,salary!L25,\"0\")","v":0}]
["(B) Other Sections under Chapter VIA",null,null,null,null,"Gross Amount",null,"Qualifying amount",null,"Deductible Amount"]
["U/S 80CCG",null,null,null,null,{"$f":"profile!Q22","v":0},null,{"$f":"'I T cal.'!E27","v":0}]
["U/S 80D",null,null,null,null,{"$f":"'I T cal.'!E28","v":0},null,{"$f":"'I T cal.'!E28","v":0}]
["U/S 80DD",null,null,null,null,{"$f":"'I T cal.'!E29","v":0},null,{"$f":"'I T cal.'!E29","v":0}]
["U/S 80DDB",null,null,null,null,{"$f":"'I T cal.'!E30","v":0},null,{"$f":"'I T cal.'!E30","v":0}]
["U/S 80E",null,null,null,null,{"$f":"'I T cal.'!E31","v":0},null,{"$f":"'I T cal.'!E31","v":0}]
["U/S 80G",null,null,null,null,{"$f":"profile!B28","v":0},null,{"$f":"'I T cal.'!E32","v":0}]
["U/S 80GG",null,null,null,null,{"$f":"profile!Q27","v":0},null,{"$f":"'I T cal.'!E33","v":0}]
["U/S 80GGA",null,null,null,null,{"$f":"'I T cal.'!E34","v":0},null,{"$f":"'I T cal.'!E34","v":0}]
["U/S 80U",null,null,null,null,{"$f":"'I T cal.'!E35","v":0},null,{"$f":"'I T cal.'!E35","v":0}]
["US 80CCD (1B)",null,null,null,null,{"$f":"profile!K22","v":0},null,{"$f":"'I T cal.'!E37","v":0}]
["US 80TTA",null,null,null,null,{"$f":"profile!J26","v":0},null,{"$f":"'I T cal.'!E36","v":0},null,{"$f":"ROUND((H111+H112+H113+H114+H115+H116+H117+H118+H119+H120+H121),0)","v":0}]
["10. Aggregate of deductible amount under chapter VIA ",null,null,null,null,null,null,null,null,{"$f":"ROUND((J109+J121),0)","v":0}]
["11. Total income (8-10)",null,null,null,null,null,null,null,null,{"$f":"ROUND((J91-J122),-1)","v":3390}]
["Income tax for Men",null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(J123<=250000,0,IF(J123<=500000,(J123-250000)*0.1,IF(J123<=1000000,25000+(J123-500000)*0.2,IF(J123>1000000,125000+(J123-1000000)*0.3,\"0\")))),0)","v":0}]
["Tax Credit, Max Rs 2000/",null,null,null,null,null,null,null,null,{"$f":"IF(AND(J123<=500000,J124>=2000),J124-2000,IF(AND(J123<=500000,J124<2000),0,J124))","v":0}]
["12. Tax on total income",null,null,null,null,null,null,null,null,{"$f":"IF(J123<=500000,J125,J124)","v":0}]
["13. Education cess",null,null,null,null,null,null,null,null,{"$f":"ROUND((J126*0.02),0)+ROUND((J126*0.01),0)","v":0}]
["14. Tax payable (12+13)",null,null,null,null,null,null,null,null,{"$f":"J126+J127","v":0}]
["15. Relief under section 89 (Attach details)",null,null,null,null,null,null,null,null,{"$f":"'I T cal.'!E45","v":0}]
["16. Tax payable (14-15)",null,null,null,null,null,null,null,null,{"$f":"J128-J129","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":"HEAD MASTER"},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":"HEAD MASTER"},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. "]

{"sheet":"nsc int","index":9,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,10],[19,3,19,4],[19,5,19,6],[18,2,18,6],[13,5,13,8],[5,2,5,8],[6,3,6,4],[6,5,6,6],[6,7,6,8]]}
["NSC INTEREST CALCULATION"]
[]
[]
[]
[]
[null,null,"NSC INTEREST CALCULATION\n(GIVE AMOUNT, PERIOD-WISE)"]
[null,null,"PURCHASE PERIOD","FROM 01-03-2003 TO 30-11-2011\n6 Year NSC",null,"FROM 01-12-2011 TO 31-03-2012\n5 Year NSC",null,"FROM 01-04-2012 ONWARDS\n5 Year NSC"]
[null,null,"Period    (in years)","Amount","Interest","Amount","Interest","Amount","Interest"]
[null,null,1,null,{"$f":"ROUND((D9*0.0816),0)","v":0},null,{"$f":"ROUND((F9*0.0858),0)","v":0},null,{"$f":"ROUND((H9*0.0878),0)","v":0}]
[null,null,2,null,{"$f":"ROUND((D10*0.0883),0)","v":0},null,{"$f":"ROUND((F10*0.0931),0)","v":0},null,{"$f":"ROUND((H10*0.0956),0)","v":0}]
[null,null,3,null,{"$f":"ROUND((D11*0.0955),0)","v":0},null,{"$f":"ROUND((F11*0.1011),0)","v":0},null,{"$f":"ROUND((H11*0.104),0)","v":0}]
[null,null,4,null,{"$f":"ROUND((D12*0.1033),0)","v":0},null,{"$f":"ROUND((F12*0.1098),0)","v":0},null,{"$f":"ROUND((H12*0.1131),0)","v":0}]
[null,null,5,null,{"$f":"ROUND((D13*0.1117),0)","v":0},null,{"$f":"ROUND((F13*0.1192),0)","v":0},null,{"$f":"ROUND((H13*0.123),0)","v":0}]
[null,null,6,null,{"$f":"ROUND((D14*0.1208),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 ONWARDS\n10 Year NSC"]
[null,null,"Period    (in years)","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,null,2,null,{"$f":"ROUND((D23*0.0968),0)","v":0},null,{"$f":"ROUND((F23*0.0993),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,null,4,null,{"$f":"ROUND((D25*0.1148),0)","v":0},null,{"$f":"ROUND((F25*0.1181),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,null,6,null,{"$f":"ROUND((D27*0.1361),0)","v":0},null,{"$f":"ROUND((F27*0.1406),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,null,8,null,{"$f":"ROUND((D29*0.1613),0)","v":0},null,{"$f":"ROUND((F29*0.1674),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,null,10,null,{"$f":"ROUND((D31*0.1913),0)","v":0},null,{"$f":"ROUND((F31*0.1992),0)","v":0}]

{"sheet":"us89(1)form","index":10,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":true,"merged":[[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],[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],[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]]}
["CALCULATION OF RELIEF UNDER SECTION 89 (1)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Male",null,"1- loZizFke vius ,fj;j dks xr foÙkh; o\"kksZa ds vuqlkj foHkkftr djsaA"]
["NAME",null,null,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- 2011-12",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )"]
["Enter net taxable income for 2011-12 (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,300000]
["Enter arrears relates to 2011-12",null,null,null,null,null,null,null,null,null,null,50000]
["FINANCIAL YEAR- 2012-13",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )",null,null,null,null,"3- dj ;ksX; vk; og vk; gS ftl ij ml foÙkh; o\"kZ esa fu/kkZfjr vk;dj nj ls vk;dj dh x.kuk dh tkrh gSA "]
["Enter net taxable income for 2012-13 (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,400000]
["Enter arrears relates to 2012-13",null,null,null,null,null,null,null,null,null,null,25000]
["FINANCIAL YEAR- 2013-14",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )"]
["Enter net taxable income for 2013-14 (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,850000,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 2015&16 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 2013-14",null,null,null,null,null,null,null,null,null,null,300]
["FINANCIAL YEAR- 2014-15",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )"]
["Enter net taxable income for 2014-15 (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,450000]
["Enter arrears relates to 2014-15",null,null,null,null,null,null,null,null,null,null,2500]
["FINANCIAL YEAR- 2015-16",null,null,null,null,null,null,null,null,null,null,"INCOME ( Rs )"]
["Enter net taxable income for 2015-16 including entire arrears received (as per ITR/Form-16) ",null,null,null,null,null,null,null,null,null,null,400000]

{"sheet":"form10E","index":11,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":true,"merged":[[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],[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],[31,2,31,3],[31,0,31,1],[32,0,32,1],[32,2,32,3],[32,4,32,5],[31,4,31,5],[30,12,30,13],[31,12,31,13],[31,10,31,11],[31,8,31,9],[31,6,31,7],[30,10,30,11],[30,0,30,1],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[20,0,20,10],[19,11,19,13],[20,11,20,13],[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],[26,11,26,13],[21,0,21,10],[22,0,22,10],[23,0,23,10],[24,0,24,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],[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],[16,10,16,13],[9,0,9,10],[2,15,5,18],[40,5,41,8],[19,0,19,10],[9,11,9,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],[6,0,6,13],[7,0,7,10]]}
["FORM NO. 10 E (See rule 21AA)"]
["Form for furnishing particulars of income undr scetion 192(2A) for year ending 31st March 2016 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 2016-17"]
["1. (a) Salary received in arrears or in advance during 2015-16 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":77800}]
["(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":322200}]
["2. salary received in arrears or advance",null,null,null,null,null,null,null,null,null,null,{"$f":"L8","v":77800}]
["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":400000}]
["4. Tax on total income (as per item 3)",null,null,null,null,null,null,null,null,null,null,{"$f":"control10E!G14","v":13390}]
["5. Tax on total income (as per item 1)",null,null,null,null,null,null,null,null,null,null,{"$f":"control10E!G6","v":5377}]
["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":8013}]
["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":8045}]
["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":-32}]
[]
["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]
["2011-12",null,{"$f":"'us89(1)form'!L6","v":300000},null,{"$f":"'us89(1)form'!L7","v":50000},null,{"$f":"C32+E32","v":350000},null,{"$f":"control10E!G2","v":12360},null,{"$f":"control10E!G10","v":17510},null,{"$f":"K32-I32","v":5150}]
["2012-13",null,{"$f":"'us89(1)form'!L9","v":400000},null,{"$f":"'us89(1)form'!L10","v":25000},null,{"$f":"C33+E33","v":425000},null,{"$f":"control10E!G3","v":20600},null,{"$f":"control10E!G11","v":23175},null,{"$f":"K33-I33","v":2575}]
["2013-14",null,{"$f":"'us89(1)form'!L12","v":850000},null,{"$f":"'us89(1)form'!L13","v":300},null,{"$f":"C34+E34","v":850300},null,{"$f":"control10E!G4","v":103000},null,{"$f":"control10E!G12","v":103062},null,{"$f":"K34-I34","v":62}]
["2014-15",null,{"$f":"'us89(1)form'!L15","v":450000},null,{"$f":"'us89(1)form'!L16","v":2500},null,{"$f":"C35+E35","v":452500},null,{"$f":"control10E!G5","v":18540},null,{"$f":"control10E!G13","v":18798},null,{"$f":"K35-I35","v":258}]
["Total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M32+M33+M34+M35","v":8045}]

{"sheet":"control10E","index":12,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[[7,0,7,6]]}
["year","amount","tax for male","tax for female","surcharge","edu. cess","total"]
["2011-12",{"$f":"form10E!C32","v":300000},{"$f":"ROUND(IF(B2<=180000,0,IF(B2<=500000,(B2-180000)*0.1,IF(B2<=800000,32000+(B2-500000)*0.2,IF(B2>800000,92000+(B2-800000)*0.3,\"0\")))),0)","v":12000},{"$f":"ROUND(IF(B2<=190000,0,IF(B2<=500000,(B2-190000)*0.1,IF(B2<=800000,31000+(B2-500000)*0.2,IF(B2>800000,91000+(B2-800000)*0.3,\"0\")))),0)","v":11000},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D2*0.02+D2*0.01,C2*0.02+C2*0.01),0)","v":360},{"$f":"IF('us89(1)form'!$O$3=2,D2+F2,C2+F2)","v":12360}]
["2012-13",{"$f":"form10E!C33","v":400000},{"$f":"ROUND(IF(B3<=200000,0,IF(B3<=500000,(B3-200000)*0.1,IF(B3<=1000000,30000+(B3-500000)*0.2,IF(B3>1000000,130000+(B3-1000000)*0.3,\"0\")))),0)","v":20000},{"$f":"ROUND(IF(B3<=200000,0,IF(B3<=500000,(B3-200000)*0.1,IF(B3<=1000000,30000+(B3-500000)*0.2,IF(B3>1000000,130000+(B3-1000000)*0.3,\"0\")))),0)","v":20000},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D3*0.02+D3*0.01,C3*0.02+C3*0.01),0)","v":600},{"$f":"IF('us89(1)form'!$O$3=2,D3+F3,C3+F3)","v":20600}]
["2013-14",{"$f":"form10E!C34","v":850000},{"$f":"ROUND(IF(B4<=220000,0,IF(B4<=500000,(B4-200000)*0.1-2000,IF(B4<=1000000,30000+(B4-500000)*0.2,IF(B4>1000000,130000+(B4-1000000)*0.3,\"0\")))),0)","v":100000},{"$f":"ROUND(IF(B4<=220000,0,IF(B4<=500000,(B4-200000)*0.1-2000,IF(B4<=1000000,30000+(B4-500000)*0.2,IF(B4>1000000,130000+(B4-1000000)*0.3,\"0\")))),0)","v":100000},{"$f":"IF(B4>10000000,C4*0.1,0)","v":0},{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D4*0.02+D4*0.01,C4*0.02+C4*0.01),0)","v":3000},{"$f":"IF('us89(1)form'!$O$3=2,D4+E4+F4,C4+E4+F4)","v":103000}]
["2014-15",{"$f":"form10E!C35","v":450000},{"$f":"ROUND(IF(B5<=270000,0,IF(B5<=500000,(B5-250000)*0.1-2000,IF(B5<=1000000,25000+(B5-500000)*0.2,IF(B5>1000000,125000+(B5-1000000)*0.3,\"0\")))),0)","v":18000},{"$f":"ROUND(IF(B5<=270000,0,IF(B5<=500000,(B5-250000)*0.1-2000,IF(B5<=1000000,25000+(B5-500000)*0.2,IF(B5>1000000,125000+(B5-1000000)*0.3,\"0\")))),0)","v":18000},{"$f":"IF(B5>10000000,C5*0.1,0)","v":0},{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D5*0.02+D5*0.01,C5*0.02+C5*0.01),0)","v":540},{"$f":"IF('us89(1)form'!$O$3=2,D5+E5+F5,C5+E5+F5)","v":18540}]
["2015-16",{"$f":"form10E!L20","v":322200},{"$f":"ROUND(IF(B6<=270000,0,IF(B6<=500000,(B6-250000)*0.1-2000,IF(B6<=1000000,25000+(B6-500000)*0.2,IF(B6>1000000,125000+(B6-1000000)*0.3,\"0\")))),0)","v":5220},{"$f":"ROUND(IF(B6<=270000,0,IF(B6<=500000,(B6-250000)*0.1-2000,IF(B6<=1000000,25000+(B6-500000)*0.2,IF(B6>1000000,125000+(B6-1000000)*0.3,\"0\")))),0)","v":5220},{"$f":"IF(B6>10000000,C6*0.12,0)","v":0},{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D6*0.02+D6*0.01,C6*0.02+C6*0.01),0)","v":157},{"$f":"IF('us89(1)form'!$O$3=2,D6+E6+F6,C6+E6+F6)","v":5377}]
[]
["Tax on income including arrears"]
["year","amount","tax for male","tax for female","surcharge","edu. cess","total"]
["2011-12",{"$f":"form10E!G32","v":350000},{"$f":"ROUND(IF(B10<=180000,0,IF(B10<=500000,(B10-180000)*0.1,IF(B10<=800000,32000+(B10-500000)*0.2,IF(B10>800000,92000+(B10-800000)*0.3,\"0\")))),0)","v":17000},{"$f":"ROUND(IF(B10<=190000,0,IF(B10<=500000,(B10-190000)*0.1,IF(B10<=800000,31000+(B10-500000)*0.2,IF(B10>800000,91000+(B10-800000)*0.3,\"0\")))),0)","v":16000},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D10*0.02+D10*0.01,C10*0.02+C10*0.01),0)","v":510},{"$f":"IF('us89(1)form'!$O$3=2,D10+F10,C10+F10)","v":17510}]
["2012-13",{"$f":"form10E!G33","v":425000},{"$f":"ROUND(IF(B11<=200000,0,IF(B11<=500000,(B11-200000)*0.1,IF(B11<=1000000,30000+(B11-500000)*0.2,IF(B11>1000000,130000+(B11-1000000)*0.3,\"0\")))),0)","v":22500},{"$f":"ROUND(IF(B11<=200000,0,IF(B11<=500000,(B11-200000)*0.1,IF(B11<=1000000,30000+(B11-500000)*0.2,IF(B11>1000000,130000+(B11-1000000)*0.3,\"0\")))),0)","v":22500},null,{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D11*0.02+D11*0.01,C11*0.02+C11*0.01),0)","v":675},{"$f":"IF('us89(1)form'!$O$3=2,D11+F11,C11+F11)","v":23175}]
["2013-14",{"$f":"form10E!G34","v":850300},{"$f":"ROUND(IF(B12<=220000,0,IF(B12<=500000,(B12-200000)*0.1-2000,IF(B12<=1000000,30000+(B12-500000)*0.2,IF(B12>1000000,130000+(B12-1000000)*0.3,\"0\")))),0)","v":100060},{"$f":"ROUND(IF(B12<=220000,0,IF(B12<=500000,(B12-200000)*0.1-2000,IF(B12<=1000000,30000+(B12-500000)*0.2,IF(B12>1000000,130000+(B12-1000000)*0.3,\"0\")))),0)","v":100060},{"$f":"IF(B12>10000000,C12*0.1,0)","v":0},{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D12*0.02+D12*0.01,C12*0.02+C12*0.01),0)","v":3002},{"$f":"IF('us89(1)form'!$O$3=2,D12+E12+F12,C12+E12+F12)","v":103062}]
["2014-15",{"$f":"form10E!G35","v":452500},{"$f":"ROUND(IF(B13<=270000,0,IF(B13<=500000,(B13-250000)*0.1-2000,IF(B13<=1000000,25000+(B13-500000)*0.2,IF(B13>1000000,125000+(B13-1000000)*0.3,\"0\")))),0)","v":18250},{"$f":"ROUND(IF(B13<=270000,0,IF(B13<=500000,(B13-250000)*0.1-2000,IF(B13<=1000000,25000+(B13-500000)*0.2,IF(B13>1000000,125000+(B13-1000000)*0.3,\"0\")))),0)","v":18250},{"$f":"IF(B13>10000000,C13*0.1,0)","v":0},{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D13*0.02+D13*0.01,C13*0.02+C13*0.01),0)","v":548},{"$f":"IF('us89(1)form'!$O$3=2,D13+E13+F13,C13+E13+F13)","v":18798}]
["2015-16",{"$f":"form10E!L22","v":400000},{"$f":"ROUND(IF(B14<=270000,0,IF(B14<=500000,(B14-250000)*0.1-2000,IF(B14<=1000000,25000+(B14-500000)*0.2,IF(B14>1000000,125000+(B14-1000000)*0.3,\"0\")))),0)","v":13000},{"$f":"ROUND(IF(B14<=270000,0,IF(B14<=500000,(B14-250000)*0.1-2000,IF(B14<=1000000,25000+(B14-500000)*0.2,IF(B14>1000000,125000+(B14-1000000)*0.3,\"0\")))),0)","v":13000},{"$f":"IF(B14>10000000,C14*0.12,0)","v":0},{"$f":"ROUND(IF('us89(1)form'!$O$3=2,D14*0.02+D14*0.01,C14*0.02+C14*0.01),0)","v":390},{"$f":"IF('us89(1)form'!$O$3=2,D14+E14+F14,C14+E14+F14)","v":13390}]