{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Company Info","Employee Information","Current Salary","IT Declaration","Leave Opening Balance","Holiday List"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Company Info","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,2],[6,0,6,1],[8,0,8,1],[12,0,12,1]]}
["Company Details"]
[1,"Company Logo"]
[2,"Company Name","Example Pvt Ltd"]
[3,"Address"]
[4,"PAN Number"]
[5,"GST Number"]
["PF Details"]
[6,"Company PF Number"]
["Profession Tax"]
[7,"Certificate Number"]
[8,"Name of Form 5 Signing Authority"]
[9,"PTO Circle"]
["Income Tax Details"]
[10,"Name of Signing Authority "]
[11,"Designation"]
[12,"Address of Signing Authority "]
[13,"Signing Authority's Father's Name"]
[14,"Form 16 issue place"]
[15,"TDS Circle Address"]

{"sheet":"Employee Information","index":1,"n_rows":2,"n_cols":57,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Employee Number","Name","Joining Date","Date Of Birth","Birthday","Mobile Number","Employee Status","Gender","confirmdate","Nick Name","Extension Number","First Name","Middle Name","Last Name","Email Address","PAN Number","Marital Status","Blood Group","Manager's Employee No","Father's Name","spousename","ipaddress","Login User Name","Probation Period","Notice Period","Is Physical Challanged","Is International Employee","Background Check Status","Background Verification Completed On","Agency Name","Background Check Remarks","Emergency Contact Name","Emergency Contact Number","Bank Account Number","IFSC Code","Bank Account Type","Bank Name","Bank Branch","Salary Payment Mode","DD Payable At ","Name As Per Bank Records","Is employee eligible for PF?","PF Number","PF Scheme","PF Joining Date","Is employee eligible for ESI?","ESI Number","Aadhaar Card Number ","UAN Number","Is existing member of PF?","Location","Department","Grade","Designation","Division","Cost Center","Employee Number Series"]
["E0001","Shivesh Jha","28 Sept 2016","16 Nov 1988","16 Nov 1988",8802812345,"Confirmed","M","1 Oct 2016","Savy","575","Shivesh",null,"Jha","shivesh@taxaj.com","ALLPJ2654F","Married","B+","B0002","Hari Shankar Jha","Neha Jha","","shivesh","30 Days","30 Days",0,0,"Pending","12-May-2013","AuthBridge","Verified","Kumar","9056745612","3114567","A2003114567","Current","CITI BANK","Koramangala","Cheque/Cash/DD/Bank Transfer","Koramangala, Bangalore","Shivesh Jha","yes","28399202","Govt. Scheme","01-May-2005","yes","28349457","123456789012","123546214457","Yes","Bangalore","","","","","","Permanent Employees"]

{"sheet":"Current Salary","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Employee Number","Effective From","Annual CTC","Monthly CTC","Basic","DA","HRA","Conveyance","Medical Allowance","Special Allowance"]
["E0001","2016-05-01",1200000,100000,40000,20000,20000,1600,1250,17150]

{"sheet":"IT Declaration","index":3,"n_rows":2,"n_cols":85,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Employee Number","House Rent Paid","5 Years of Fixed Deposit in Scheduled Bank ","Additional Interest on housing loan borrowed as on 1st Apr 2016","Children Tuition Fees","Contribution to NPS 2015 ","Contribution to Pension Fund","Deposit in NSC","Deposit in NSS","Deposit in Post Office Savings Schemes","Donation - 100% Exemption","Donation - 50% Exemption","Donation - Children Education","Donation - Political Parties","Equity Linked Savings Scheme ( ELSS )","Infrastructure Bonds","Interest on Deposits in Savings Account","Interest on Loan of higher Self education ","Interest on NSC Reinvested","Kisan Vikas Patra (KVP)","Life Insurance Premium","Long term Infrastructure Bonds","Medical Bills - Very Senior Citizen","Medical Insurance Premium","Medical Insurance Premium - Age Limit","Medical Insurance Premium - Dependant Parents","Medical Insurance Premium - Dependant Parents - Age Limit","Medical Treatment / Insurance of handicapped Dependant","Medical Treatment / Insurance of handicapped Dependant (Severe) ","Medical Treatment ( Specified Disease only )","Medical Treatment (Specified Disease only)- Senior Citizen","Medical Treatment (Specified Disease only)- Very Senior Citizen","Mutual Funds","NABARD Rural Bonds","National Pension Scheme","NHB Scheme","Permanent Physical disability (Above 40%)","Permanent Physical disability (Below 40%)","Post office time deposit for 5 years","Pradhan Mantri Suraksha Bima Yojana","Preventive Health Check-up","Preventive Health Checkup - Dependant Parents","Public Provident Fund","Rajiv Gandhi Equity Scheme","Repayment of Housing loan(Principal amount)","Stamp duty and Registration charges","Sukanya Samriddhi Yojana","Unit Linked Insurance Premium (ULIP)","Income/Loss from Let Out Property","Interest on Housing Loan ( Self Occupied)","Other Income 1","Other Income 2","Education cess","Income after Exemptions","Profession Tax -PT","Provident Fund -PF","Surcharge","Tax On Income","Total Tax","Short Term Gain","House Rent For Apr","House Rent For May","House Rent For Jun","House Rent For Jul","House Rent For Aug","House Rent For Sep","House Rent For Oct","House Rent For Nov","House Rent For Dec","House Rent For Jan","House Rent For Feb","House Rent For Mar","Basic DA%","Basic DA% For Apr","Basic DA% For May","Basic DA% For Jun","Basic DA% For Jul","Basic DA% For Aug","Basic DA% For Sep","Basic DA% For Oct","Basic DA% For Nov","Basic DA% For Dec","Basic DA% For Jan","Basic DA% For Feb","Basic DA% For Mar"]
["E0001","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","< 60","2500.00","< 60","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","2500.00","8500","8500","8500","8500","8500","8500","8500","8500","8500","8500","8500","8500","40","40","40","40","40","40","40","40","40","40","40","40","40"]

{"sheet":"Leave Opening Balance","index":4,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Employee Number","Type Of Leave","Type Of Transaction","Leave From","Leave To","Leave Days","From Session","To Session","Reason For Leave","Remarks","Grant Expire Date"]
["E0001","Annual Leave","Opening Balance","2016-01-01","2016-12-31","24","1","2","Annual Grant For the period of 1 Jan to 31 Dec 2009","Ported through Excel on 10 Jan 2009.","1 Mar 2009"]

{"sheet":"Holiday List","index":5,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Holiday Date","Description","Is Optional"]
["2017-01-26","Republic Day",false]