{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","TimeStamps","ProjectsList","SubprojectsList","EmployeeList","SystemVariables","StatHolidays","PayPeriods","ChangeLog"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Cover","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Minchin Timesheet System (MTS)"]
[null,"Version 1.1 Build 28077"]
[null,"Released July, 7, 2010"]
[]
[null,"Developed by W. Minchin",null,null,"minchinweb@gmail.com"]
[null,"Updates available at ",null,"http://Blog.Minchin.ca/search/MTS"]
[]
[null,"If the main form does not automatically appear, you will need to enable Macros for this file."]
[]
[]
[]
[]
[null,"The Minchin TimeSheet System was developed to allow"]
[null,"timekeeping on complex projects. It allows time to be"]
[null,"recorded by employee, project, and subproject. On the"]
[null,"basis of the timestamps recorded, a bi-weekly"]
[null,"timesheet can be generated, which is then saved as a"]
[null,"PDF."]
[]
[null,"The only requirement to run the program is Excel 2007"]
[null,"with Macros enabled for this file."]
[]
[null,"If you would like this program to be customized for"]
[null,"your organization, or would like to contribute to this"]
[null,"project, please contact the developer, W. Minchin,"]
[null,"at ","minchinweb@gmail.com"]

{"sheet":"TimeStamps","index":1,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Employee","Time In","Time Out","Project","SubProject"]

{"sheet":"ProjectsList","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Code","Description"]

{"sheet":"SubprojectsList","index":3,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Code","Description"]

{"sheet":"EmployeeList","index":4,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Code","Last Name","First Name"]

{"sheet":"SystemVariables","index":5,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Company Name","Minchin.ca"]
["Company Address Line 1","Clyde Building"]
["Company Address Line 2","Provo UT 84602"]
["Company Phone Number","801-555-CALL"]
["."]
["Weekday Start","U","(U/M/T/W/R/F/S)"]
["Pay Period Length",14,"days"]
["Pay Period Start","2010-04-10"]
["."]
["Overtime, Daily",8,"hours"]
["Overtime, Weekly",44,"hours"]
["Overtime, Rate",1.5]
["."]
["Timestamp Lines",49]
["In Or Out?",false,"(True = In / False = Out)"]
["Rounding",15,"minutes"]
["."]
["Default Employee",9999998,"7 digits","cannot be 0"]
["Default Project",9998,"4 digits","cannot be 0"]
["Default SubProject",99998,"5 digits","cannot be 0"]
["."]

{"sheet":"StatHolidays","index":6,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
["Notes:","12 / 25 means December (12th month) 25"]
[null,"M2 / 10 means the 2nd Monday in October"]
[null,"M-24 / 5 means the Monday on or before the 24th of May"]
[]
[null,null,null,2009,null,2010,null,2011,null,2012]
[1,7,"Canada Day",1,7,1,7,1,7,1,7]
["M1",9,"Labour Day",7,9,6,9,5,9,3,9]
[25,12,"Christmas",25,12,25,12,25,12,25,12]
["M-24",5,"Victoria Day",18,5,24,5,23,5,21,5]
["M2",10,"Thanksgiving",12,10,11,10,10,10,8,10]
[1,1,"New Years Days",1,1,1,1,1,1,1,1]
["M_EASTER",null,"Easter Monday",13,4,5,4,25,4,9,4]
[11,11,"Remembrance Day",11,11,11,11,11,11,11,11]
[26,12,"Boxing Day",26,12,26,12,26,12,26,12]
["F_EASTER",null,"Good Friday",10,4,2,4,22,4,6,4]
["M3",2,"Family Day",16,2,15,2,21,2,20,2]
["M1",8,"August Long Weekend",3,8,2,8,1,8,6,8]

{"sheet":"PayPeriods","index":7,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
["First Pay Period Start"]
["2010-04-10"]
[]
[]
[null,2009,null,2010,null,2011,null,2012]
[null,1,3,1,2,1,1,1,14]
[null,1,17,1,16,1,15,1,28]
[null,1,31,1,30,1,29,2,11]
[null,2,14,2,13,2,12,2,25]
[null,2,28,2,27,2,26,3,10]
[null,3,14,3,13,3,12,3,24]
[null,3,28,3,27,3,26,4,7]
[null,4,11,4,10,4,9,4,21]
[null,4,25,4,24,4,23,5,5]
[null,5,9,5,8,5,7,5,19]
[null,5,23,5,22,5,21,6,2]
[null,6,6,6,5,6,4,6,16]
[null,6,20,6,19,6,18,6,30]
[null,7,4,7,3,7,2,7,14]
[null,7,18,7,17,7,16,7,28]
[null,8,1,7,31,7,30,8,11]
[null,8,15,8,14,8,13,8,25]
[null,8,29,8,28,8,27,9,8]
[null,9,12,9,11,9,10,9,22]
[null,9,26,9,25,9,24,10,6]
[null,10,10,10,9,10,8,10,20]
[null,10,24,10,23,10,22,11,3]
[null,11,7,11,6,11,5,11,17]
[null,11,21,11,20,11,19,12,1]
[null,12,5,12,4,12,3,12,15]
[null,12,19,12,18,12,17,12,29]
[null,null,null,null,null,12,31]

{"sheet":"ChangeLog","index":8,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["1.1.28076","2010-07-07"]
[null,"Polish to v1.0 release"]
[null,null,"Added 'About' page, including contact information and changelog"]
[null,null,"Added contact and copyright information"]
["1.0.25059","2010-04-14"]
[null,"Original ISYS Release"]
[null,null,"Basic Userform allowing user to record timestamps, check in/out status, and generate timesheets"]
[null,null,"Framework provided for determining holidays, but not implimented"]