{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["General Details","Deductee Details"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"General Details","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,1,16,5],[12,1,12,5],[4,1,4,4],[1,1,1,5],[9,1,9,5],[3,1,3,4],[5,1,5,4],[8,1,8,4],[7,1,7,4],[6,1,6,4],[15,1,15,5]]}
[]
[null,"Step 1: Fill in the following Details"]
[]
[null,"ASSESSMENT YEAR",null,null,null,"2014-15"]
[null,"FORM 16A LOCATION\n(For inserting the location, open the folder where you have saved Form 16 and copy and paste the Address Line. For eg. If you have saved the Folder (named Form 16) which contains Form 16 on your Desktop then the Location would look like \"C:\\Documents and Settings\\username\\Desktop\\Form 16\".",null,null,null,"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16"]
[null,"NAME OF THE COMPANY SENDING (DEDUCTOR COMPANY)",null,null,null,"ZZZ & CO."]
[null,"NAME OF THE PERSON SENDING (DEDUCTOR COMPANY)",null,null,null,"MANITA VERMA"]
[null,"DESIGNATION OF THE PERSON SENDING (DEDUCTOR COMPANY)",null,null,null,"MANAGER TAXATION"]
[null,"CONTACT NO. OF THE PERSON SENDING (DEDUCTOR COMPANY)",null,null,null,9870007942]
[null,"Step 2: Go to WorkSheet \"Deductee Details\" and fill in the requisite columns as mentioned below"]
[]
[null,"1. Insert the Employee's Name in Column A "]
[null,"2. Insert the Employee's E-mail ID in Column B. You can type in multiple E-mail ID's separated by \";\". For eg. abc@yahoo.com; abc@gmail.com"]
[null,"3. Insert the Employee's PAN Number in Column C"]
[null,"4. Insert the Employee's Code in Column D"]
[null,"4. Form 16 consists of two parts viz Part A and Part B. Part A is to be mandatorily downloaded from the CPC Website. Part B is to be prepared and given by the Employer. Once you have created Part B, name it in the manner \"PAN No. <SPACE> EMPLOYEE CODE <SPACE> EMPLOYEE NAME\" and keep it in the same folder as mentioned in Cell BE5 above. This Software will send both the Attachments to the Employee viz Part A and Part B."]
[null,"4. Once you are ready with the Data, Press Ctlr+h or Press the Blue Square Button on the Quick Access Toolbar or Click View: Macros:Run. "]

{"sheet":"Deductee Details","index":1,"n_rows":4,"n_cols":21,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["NAME OF THE EMPLOYEE","EMAIL ID","PAN NUMBER","EMPLOYEE CODE"]
["Employee A","mannitaa@ymail.com; abc@yahoo.com","AAAPA1234B","EMP1",null,null,null,null,null,null,null,null,null,null,null,null,null,"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPA1234B_2014-15.pdf",{"$f":"CONCATENATE('General Details'!$F$5,\"\\\",C2,\"_\",'General Details'!$F$4,\".pdf\")","v":"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPA1234B_2014-15.pdf"},"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPA1234B EMP1 Employee A.pdf",{"$f":"CONCATENATE('General Details'!$F$5,\"\\\",C2,\" \",D2,\" \",A2, \".pdf\")","v":"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPA1234B EMP1 Employee A.pdf"}]
["Employee X","xyz@gmail.com","AAAPX2345Y","EMP2",null,null,null,null,null,null,null,null,null,null,null,null,null,"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPX2345Y_2014-15.pdf",{"$f":"CONCATENATE('General Details'!$F$5,\"\\\",C3,\"_\",'General Details'!$F$4,\".pdf\")","v":"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPX2345Y_2014-15.pdf"},"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPX2345Y EMP2 Employee X.pdf",{"$f":"CONCATENATE('General Details'!$F$5,\"\\\",C3,\" \",D3,\" \",A3, \".pdf\")","v":"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPX2345Y EMP2 Employee X.pdf"}]
["Employee P","pqr@yahoo.co.in","AAAPP3456Q","EMP3",null,null,null,null,null,null,null,null,null,null,null,null,null,"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPP3456Q_2014-15.pdf",{"$f":"CONCATENATE('General Details'!$F$5,\"\\\",C4,\"_\",'General Details'!$F$4,\".pdf\")","v":"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPP3456Q_2014-15.pdf"},"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPP3456Q EMP3 Employee P.pdf",{"$f":"CONCATENATE('General Details'!$F$5,\"\\\",C4,\" \",D4,\" \",A4, \".pdf\")","v":"C:\\Documents and Settings\\manita.verma\\Desktop\\Form 16\\AAAPP3456Q EMP3 Employee P.pdf"}]