{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["How to Use","Main","Report","Database","Back End"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"How to Use","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"merged":[[1,0,1,5],[2,0,2,5],[4,0,4,5],[5,0,5,5],[6,0,6,5],[9,0,9,9],[10,0,10,9],[11,0,11,9]]}
["How to use this template?"]
["1) This file contains macros. Enable macros to start using this template."]
["2) Read our blog if you are not aware of enabling macros."]
["3) If you are using this template for the first time, please see instructions below."]
["4) In 'Main' Sheet, Enter Employee Details"]
["5) After entering the details press 'Add Employee Details' button."]
["6) To generate report, Enter date range and select the employee from dropdown \n    and press 'Generate Payroll Hours Report'"]
[]
["Customisation:"]
["We can also customise this template as per your requirements. You can email us at excelexpert@excelforcommerce.com"]

{"sheet":"Main","index":1,"n_rows":18,"n_cols":10,"rows_kept":18,"merged":[[5,7,5,11],[7,7,7,8],[7,10,7,11],[15,7,15,8],[15,10,15,11],[17,7,17,11]]}
["Payroll Tracking System Template"]
[]
["Enter Employee Details"]
[]
[]
[{"$nulls":4},"Enter the Employee Name:"]
[]
[{"$nulls":4},"Date",null,"In Time",null,null,"Out Time"]
[]
[]
[]
[]
["Payroll Hours Report"]
[]
[]
[{"$nulls":4},"Enter the Date range:",{"$nulls":4},"to"]
[]
[{"$nulls":4},"Select the Employee Name:"]

{"sheet":"Report","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"hidden":true}
["Payroll Hours Report"]
[]
[]
[null,"Period of Interest :","2016-01-01","-","2016-02-01"]
[]
[]
[null,"Employee Name","Total Hours"]
[null,"Employee 1",{"$f":"IFERROR(SUMIFS(Database!E:E,Database!A:A,Report!B8,Database!B:B,\">=\" & Report!C4,Database!B:B,\"<=\" & Report!E4) & \" Hours\",\"\")","v":"0 Hours"}]

{"sheet":"Database","index":3,"n_rows":1,"n_cols":5,"rows_kept":1,"hidden":true}
["Employee","Date","In Time","Out Time","Total"]

{"sheet":"Back End","index":4,"n_rows":6,"n_cols":1,"rows_kept":6,"hidden":true}
["Employees"]
["Employee 1"]
["Employee 2"]
["Employee 3"]
["Employee 4"]
["Employee 5"]