{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["15h","database","Macro-disabled"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"15h","index":0,"n_rows":82,"n_cols":25,"rows_kept":82,"cut":false,"hidden":true,"merged":[[1,1,1,16],[2,1,2,16],[4,1,4,16],[6,1,6,16],[34,8,34,10],[34,12,34,14],[8,1,8,6],[19,1,19,3],[9,8,9,10],[9,12,9,14],[11,1,11,3],[12,1,12,3],[30,10,30,16],[31,1,31,6],[31,10,31,16],[34,2,34,6],[60,1,60,16],[9,1,9,6],[16,1,16,3],[16,5,16,8],[16,10,16,12],[16,14,16,16],[53,2,53,3],[35,12,35,14],[35,8,35,10],[35,2,35,6],[19,5,19,8],[19,10,19,12],[19,14,19,16],[23,1,23,6],[27,1,27,6],[30,1,30,6],[40,12,41,16],[45,1,45,16],[47,2,47,5],[55,12,56,16],[36,2,36,6],[36,8,36,10],[36,12,36,14],[37,2,37,6],[37,8,37,10],[37,12,37,14],[73,6,73,7],[74,5,74,6],[76,12,77,16],[27,10,27,16],[64,1,64,6],[68,1,68,5],[61,1,61,16],[64,10,64,15],[67,6,68,10],[68,12,68,16],[71,1,71,3],[71,5,71,10],[71,12,71,16],[38,2,38,6],[38,8,38,10],[38,12,38,14]]}
[]
[null,"Form No. 15H"]
[null,"[See section 197A(1C) and rule 29C]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-17","2017-18","31st March, 2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-18","2018-19","31st March, 2018"]
[null,"Declaration under section 197A (1C) to be made by an individual who is of the age of sixty years or more claiming certain incomes without deduction of tax."]
[]
[null,"Part-I"]
[]
[null,"1. Name of Assessee (Declarant)",null,null,null,null,null,null,"2. PAN of the Assessee"]
[null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:L152,2,FALSE),\"\")","v":""}]
[]
[null,"3. Date of Birth",null,null,null,"4.  Previous year (P.Y.)",null,null,null,null,"2017-18"]
[null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:L152,3,FALSE),\"\")","v":""},null,null,null,"(for which declaration is being made)"]
[]
[null,"5. Flat/Door/Block No",null,null,null,"6. Name of Premises ",null,null,null,null,"7. Road/Street/Lane",null,null,null,"8. Area/Locality"]
[]
[null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:M152,4,FALSE), \"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:M152,5,FALSE), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:M152,6,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:M152,7,FALSE), \"\")","v":""}]
[]
[null,"9. Town/City/District ",null,null,null,"10. State",null,null,null,null,"11. PIN",null,null,null,"12. Email"]
[null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:M152,8,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:M152,9,FALSE), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:M152,10,FALSE), \"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:M152,11,FALSE), \"\")","v":""}]
[]
[null,"13. Telephone No. (with STD Code) and Mobile No.",null,null,null,null,null,null,"14 (a) Whether assessed to tax "]
[]
[null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:M152,12,FALSE), \"\")","v":""},null,null,null,null,null,null,"(b) If yes, latest assessment year for which assessed"]
[]
[null,"15. Estimated income for which this declaration is made",null,null,null,null,null,null,null,null,"16. Estimated total income of the P.Y. in which"]
[null,null,null,null,null,null,null,null,null,null,"income mentioned in column 15 to be included"]
[]
[]
[null,"17. Details of Form No. 15H other than this form filed during the previous year, if any"]
[null,"Total No. of Form No. 15H filed",null,null,null,null,null,null,null,null,"Aggregate amount of income for which Form No.15H filed"]
[]
[]
[null,"18. Details of income for which the declaration is filed"]
[null,"Sl. No.","Identification number of relevant investment/account, etc",null,null,null,null,null,"Nature of income",null,null,null,"Section under which tax\nis deductible ",null,null,null,"Amount of Income"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Signature of the declarant"]
[]
[null,"Declaration/Verification"]
[]
[null,"*I/We",{"$f":"IF(B10=\"\",\"\",B10)","v":""},null,null,null," do hereby declare that I am resident in India within the meaning of section 6 of the"]
[null,"Income-tax Act, 1961. I also hereby declare that to the best of my knowledge and belief what is stated above is correct, complete"]
[null,"and is truly stated and that the incomes referred to in this form are not includible in the total income of any other person under "]
[null,"sections 60 to 64 of the Income-tax Act, 1961. I further declare that the tax on my estimated total income including *income"]
[null,"/incomes referred to in column 15 *and aggregate amount of *income/incomes referred to in column 17 computed in  accordance"]
[null,"with the provisions of the Income-tax Act, 1961, for the previous year ending on",null,null,null,null,null,null,null,null,null,null,{"$f":"K12","v":"2017-18"},null,"relevant to the assessment "]
[null,"year",{"$f":"VLOOKUP(K12,W3:Y4,3,FALSE)","v":"31st March, 2018"},null,null,"will be nil."]
[]
[]
[null,"Place:"]
[]
[null,"Dated:",null,null,null,null,null,null,null,null,null,null,"Signature of the declarant"]
[]
[null,"PART II"]
[null,"[To be filled by the person responsible for paying the income referred to in column 16 of Part I] "]
[]
[null,"1. Name of the person responsible for paying",null,null,null,null,null,null,null,null,"2. Unique Identification No."]
[]
[]
[null,"3. PAN of the person responsible for paying",null,null,null,null,"4. Complete Address",null,null,null,null,null,"5. TAN of the person responsible "]
[null,null,null,null,null,null,null,null,null,null,null,null,"    for paying"]
[]
[]
[null,"6. Email",null,null,null,"7. Telephone No. (with STD Code) and Mobile No",null,null,null,null,null,null,"8. Amount of income paid"]
[]
[]
[null,"9. Date on which Declaration is received",null,null,null,null,null,null,null,null,"10. Date on which the income has been paid/credited"]
[null,"   (DD/MM/YYYY)",null,null,null,null,null,null,null,null,"   (DD/MM/YYYY)"]
[]
[]
[null,"Place:"]
[]
[null,"Dated:",null,null,null,null,null,null,null,null,null,null,"Signature of the person responsible for"]
[null,null,null,null,null,null,null,null,null,null,null,null,"paying the income referred to in column "]
[null,null,null,null,null,null,null,null,null,null,null,null,"15 of Part I"]

{"sheet":"database","index":1,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Form 15H Database"]
["PAN","Name","date of Birth","Flat/door/ block No.","Premises Name","Road/Street/Lane","Area/Loaclity","Town/City/District ","State","PIN","Email","Telephone No"]
["aaaaaaaaa","ashutosh lohani","1954-04-01",15,"acharya sadan","aliganj road","aliganj","lucknow","uttar pradesh",226024,"lohni@yahoo.com",5222324122]
["bbbbbbbb"]
["cccccccccc"]
["dddddd"]

{"sheet":"Macro-disabled","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Macros must be enabled to use this utility"]