{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["15g","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":"15g","index":0,"n_rows":83,"n_cols":25,"rows_kept":83,"cut":false,"hidden":true,"merged":[[74,6,74,7],[75,5,75,6],[77,12,78,16],[27,10,27,16],[65,1,65,6],[69,1,69,5],[62,1,62,16],[65,10,65,15],[68,6,69,10],[69,12,69,16],[72,1,72,3],[72,5,72,10],[72,12,72,16],[38,2,38,6],[38,8,38,10],[38,12,38,14],[40,12,41,16],[45,1,45,16],[47,2,47,5],[56,12,57,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],[61,1,61,16],[8,8,8,16],[9,1,9,6],[9,8,9,16],[16,1,16,3],[16,5,16,8],[16,10,16,12],[16,14,16,16],[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],[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],[30,1,30,6],[30,10,30,16],[31,1,31,6],[31,10,31,16],[34,2,34,6]]}
[]
[null,"Form No. 15G"]
[null,"[See section 197A(1), 197A(1A) 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 (1) and section 197A(1A) to be made by an individual or a person (not being a company or firm) 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:M152,2,FALSE),\"\")","v":""}]
[]
[null,"3. Status",null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:M152,3,FALSE), \"\")","v":""},null,"4.  Previous year (P.Y.)",null,null,null,null,"2017-18",null,"5. Residential Status",null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:N152,4,FALSE), \"\")","v":""}]
[null,null,null,null,null,"(for which declaration is being made)"]
[]
[null,"6. Flat/Door/Block No",null,null,null,"7. Name of Premises ",null,null,null,null,"8. Road/Street/Lane",null,null,null,"9. Area/Locality"]
[]
[null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:N152,5,FALSE), \"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:N152,6,FALSE), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:N152,7,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:N152,8,FALSE), \"\")","v":""}]
[]
[null,"10. Town/City/District ",null,null,null,"11. State",null,null,null,null,"12. PIN",null,null,null,"13. Email"]
[null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:N152,9,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:N152,10,FALSE), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:N152,11,FALSE), \"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:N152,12,FALSE), \"\")","v":""}]
[]
[null,"14. Telephone No. (with STD Code) and Mobile No.",null,null,null,null,null,null,"15 (a) Whether assessed to tax under the"]
[null,null,null,null,null,null,null,null,"      Income-tax Act, 1961"]
[null,{"$f":"IFERROR(VLOOKUP(I10,database!A3:N152,13,FALSE), \"\")","v":""},null,null,null,null,null,null,"(b) If yes, latest assessment year for which assessed"]
[]
[null,"16. Estimated income for which this declaration is made",null,null,null,null,null,null,null,null,"17. Estimated total income of the P.Y. in which"]
[null,null,null,null,null,null,null,null,null,null,"income mentioned in column 16 to be included"]
[]
[]
[null,"18. Details of Form No. 15G other than this form filed during the previous year, if any"]
[null,"Total No. of Form No. 15G filed",null,null,null,null,null,null,null,null,"Aggregate amount of income for which Form No.15G filed"]
[]
[]
[null,"19. 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,1]
[]
[]
[]
[]
[]
[]
[]
[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 to the best of *my/our knowledge and belief what is stated"]
[null,"above is correct, complete and is truly stated. *I/We declare that the incomes referred to in this form are not includible in the total"]
[null,"income of any other person under sections 60 to 64 of the Income-tax Act, 1961. *I/We further declare that the tax *on my/"]
[null,"/our estimated total income including *income/incomes referred to in column 16 *and aggregate amount of *income/"]
[null,"incomes referred to  in column 18 computed in accordance with the provisions of the Income-tax Act, 1961, for the previous year "]
[null,"ending on",null,{"$f":"VLOOKUP(K12,W3:Y4,3,FALSE)","v":"31st March, 2018"},null,"relevant to the assessment year",null,null,null,null,{"$f":"VLOOKUP(K12,W3:X4,2,FALSE)","v":"2018-19"},null,"will be nil.",null,"*I/We also declare that *my/"]
[null,"/our *income / incomes referred to in column 16 * and the  aggregate  amount  of  *income / incomes  referred  to  in  column  18 "]
[null," for the previous year ending on",null,null,null,{"$f":"VLOOKUP(K12,W3:Y4,3,FALSE)","v":"31st March, 2018"},null,null,"relevant   to   the   assessment   year",null,null,null,null,null,{"$f":"K53","v":"2018-19"},null,"will not exceed"]
[null,"the maximum amount which is not chargeable to income-tax."]
[]
[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,"16 of Part I"]

{"sheet":"database","index":1,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Form 15G Database"]
["PAN","Name","Status","Residential Status","Flat/door/ block No.","Premises Name","Road/Street/Lane","Area/Loaclity","Town/City/District ","State","PIN","Email","Telephone No"]
["aaaaaaaaa","ashutosh lohani","individual","resident",15,"acharya sadan","aliganj road","aliganj","lucknow","uttar pradesh",226024,"lohni@yahoo.com",12456478]
["bbbbbbbb"]
["cccccccccc"]
["dddddd"]

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