{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["TimeStamps","ProjectsList","SubprojectsList","EmployeeList","SystemVariables","StatHolidays","PayPeriods","TimeSheet"],"not_rendered":{"charts":0,"images":0,"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":"TimeStamps","index":0,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Employee","Time In","Time Out","Project","SubProject"]
[5496,"2010-03-15T13:50:00","2010-03-15T14:30:39.880",2108,100]
[5496,"2010-03-15T15:02:15.340","2010-03-15T15:04:13.370",2108,100]
[5496,"2010-03-15T15:34:51.470","2010-03-15T16:50:54.580",2108,900]
[5496,"2010-03-15T20:11:00","2010-03-15T20:17:56.430",2108,100]
[5496,"2010-03-17T15:45:00","2010-03-17T16:15:00",2108,900]
[5496,"2010-03-19T17:05:05","2010-03-19T17:36:04.830",2108,110]
[5496,"2010-03-19T18:23:32.710","2010-03-19T18:54:18.950",2108,110]
[5496,"2010-03-19T19:35:03.640","2010-03-19T20:36:25.790",2108,110]
[5496,"2010-03-20T00:03:35.630","2010-03-20T01:27:28.940",2108,110]
[5496,"2010-03-20T10:29:33.390","2010-03-20T11:48:17.600",2108,110]
[5496,"2010-03-20T11:57:33.730","2010-03-20T12:13:04.730",2108,110]
[5496,"2010-03-20T14:01:46.060","2010-03-20T14:26:54.180",2108,110]
[5496,"2010-03-25","2010-03-25T01:00:00",2108,110]
[5496,"2010-03-22T15:30:00","2010-03-22T16:45:00",2108,900]
[5496,"2010-03-24T15:30:00","2010-03-24T16:45:52.580",2108,900]
[5496,"2010-03-29T14:32:20.740","2010-03-29T15:05:29.240",2108,120]
[5496,"2010-03-29T15:39:55.560","2010-03-29T16:49:37.110",2108,900]
[5496,"2010-03-29T22:35:00","2010-03-29T23:10:00",2108,120]
[5496,"2010-03-30T10:15:41.320","2010-03-30T10:49:43.600",2108,130]
[5496,"2010-03-30T14:48:28.830","2010-03-30T15:00:00",2108,130]
[5496,"2010-03-30T18:30:00","2010-03-30T19:12:00",2108,130]
[5496,"2010-03-30T20:52:25.650","2010-03-30T21:55:00",2108,130]
[5496,"2010-03-31T00:10:00","2010-03-31T00:25:00",2108,150]
[5496,"2010-03-31T08:08:43.490","2010-03-31T09:00:00",2108,150]
[5496,"2010-03-31T12:32:05.450","2010-03-31T13:10:19",2108,150]
[5496,"2010-03-31T15:05:23.520","2010-03-31T15:11:16.270",2108,150]
[5496,"2010-03-31T15:27:11","2010-03-31T16:25:00",2108,900]
[5496,"2010-03-31T18:19:24.580","2010-03-31T19:14:30.950",2108,150]
[5496,"2010-03-31T19:50:00","2010-03-31T22:59:54.690",2108,160]
[5496,"2010-04-05T15:30:00","2010-04-05T17:00:00",2108,900]
[5496,"2010-04-07T15:30:00","2010-04-07T16:50:00",2108,900]
[5496,"2010-04-08T17:03:22.730","2010-04-08T17:16:54.580",2108,910]
[5496,"2010-04-08T17:17:02.100","2010-04-08T17:20:55",2108,170]
[5496,"2010-04-08T21:40:00","2010-04-08T22:16:55",2108,170]
[9999998,"2010-04-13T20:02:04","2010-04-13T20:02:18",9998,99998]
[9999998,"2010-04-13T20:02:26","2010-04-13T20:03:52",9998,99998]
[9999998,"2010-04-13T20:04:07","2010-04-13T20:04:09",9998,99998]
[9999998,"2010-04-13T20:04:13","2010-04-13T20:06:09",9998,99998]
[9999998,"2010-04-13T20:06:12","2010-04-13T20:06:13",9998,99998]
[9999998,"2010-04-13T20:06:15","2010-04-13T20:06:15",9998,99998]
[9999998,"2010-04-13T21:14:58","2010-04-13T21:15:57",9998,99998]
[9999998,"2010-04-13T21:16:03","2010-04-13T21:16:06",9998,99998]
[9999998,"2010-04-13T21:16:19","2010-04-13T21:28:04",9998,99998]
[9999998,"2010-04-13T21:28:07","2010-04-13T21:29:43",9998,99998]
[5496,"2010-04-13T21:30:01","2010-04-13T21:30:12",9998,99998]
[9999998,"2010-04-13T21:30:16","2010-04-13T21:30:17",9998,99998]
[9999998,"2010-04-13T21:30:22","2010-04-13T21:30:30",9998,99998]

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

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

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

{"sheet":"SystemVariables","index":4,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Company Name","Minchin.ca"]
["Company Address Line 1","Clyde Building"]
["Company Address Line 2","Provo UT 84602"]
["Company Phone Number","801-555-CALL",null,null,null,null,"Created by William Minchin"]
[".",null,null,null,null,null,"William@Minchin.ca"]
["Weekday Start","U","(U/M/T/W/R/F/S)",null,null,null,"www.minchin.ca/index.htm"]
["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":5,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"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":6,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"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":"TimeSheet","index":7,"n_rows":50,"n_cols":29,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Minchin.ca",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 1"]
[null,"Clyde Building"]
[null,"Provo UT 84602"]
[null,"Phone: 801-555-CALL"]
[]
[null,"Timesheet for: Mar 13, 2010 to Mar 26, 2010 for Employee #5496"]
[]
[]
[null,null,"Project",null,null,null,null,"Subproject",null,null,null,null,null,"Mar",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[null,null,2,1,0,8,null,0,0,1,0,0,null,null,null,2.0655138492584229,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N12:AA12)","v":2.0655138492584229}]
[]
[null,null,2,1,0,8,null,0,0,9,0,0,null,null,null,3.1688263416290283,null,1.25,null,null,null,null,3.125,null,3.1615138053894043,null,null,{"$f":"SUM(N14:AA14)","v":10.705340147018433}]
[]
[null,null,2,1,0,8,null,0,0,1,1,0,null,null,null,null,null,null,null,5.1307086944580078,8.4698886871337891,null,null,null,null,2.5,null,{"$f":"SUM(N16:AA16)","v":16.100597381591797}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N18:AA18)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N20:AA20)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N22:AA22)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N24:AA24)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N26:AA26)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N28:AA28)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N30:AA30)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N32:AA32)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N34:AA34)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N36:AA36)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N38:AA38)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N40:AA40)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N42:AA42)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(N12:N43)","v":0},0,5.2343401908874512,0,1.25,0,5.1307086944580078,8.4698886871337891,0,3.125,0,3.1615138053894043,2.5,0,28.871451377868652]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature"]
[]
[null,"     Minchin Timesheet System v1.0.25059                    Revised Apr 14, 2010                                                                           www.Minchin.ca                                                                           Timesheet Generated at Apr 13, 2010 9:57 pm"]