{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Timesheet Template","Payroll Calendar"],"not_rendered":{"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Timesheet Template","index":0,"n_rows":28,"n_cols":24,"rows_kept":28,"merged":[[0,1,0,16],[2,1,2,5],[2,7,2,10],[2,12,2,13],[4,3,4,5],[4,7,4,9],[4,14,4,16],[18,1,18,2],[18,3,18,8],[18,10,18,15],[19,1,19,2],[20,1,20,2],[20,3,20,9],[20,10,20,16],[25,4,25,9],[26,4,26,9],[27,10,27,15]]}
[]
[null,"Employee Name",{"$nulls":5},"Employee Title",{"$nulls":4},"Employee Number",null,null,"SALARY"]
[{"$nulls":15},"HOURLY",{"$nulls":3},"1. Select Pay Period From (Other dates will fill automatically)"]
[{"$nulls":19},"2. Fill (Enter your time. Standard hours is 7.5 hours. Overtime is over 8.00 hours)"]
[null,null,"Pay Period from: ",{"$nulls":3},"to",{"$f":"Q8","v":""},{"$nulls":5},"Pay Day: ",{"$f":"IFERROR(D8+19,\"\")","v":""},{"$nulls":4},"3. Print (You don't have to save it on your computer)"]
[{"$nulls":19},"4. Sign it (You and your supervisor must sign it)"]
[null,"Pay","Grant","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Bi-Weekly",null,"5. Send to Payroll (Scan to Email or Fax signed copy to payroll@chugachmiut.org)"]
[null,"Code","Code",{"$f":"IF(D5<1,\"\",D5)","v":""},{"$f":"IFERROR(D8+1,\"\")","v":""},{"$f":"IFERROR(D8+2,\"\")","v":""},{"$f":"IFERROR(D8+3,\"\")","v":""},{"$f":"IFERROR(D8+4,\"\")","v":""},{"$f":"IFERROR(D8+5,\"\")","v":""},{"$f":"IFERROR(D8+6,\"\")","v":""},{"$f":"IFERROR(D8+7,\"\")","v":""},{"$f":"IFERROR(D8+8,\"\")","v":""},{"$f":"IFERROR(D8+9,\"\")","v":""},{"$f":"IFERROR(D8+10,\"\")","v":""},{"$f":"IFERROR(D8+11,\"\")","v":""},{"$f":"IFERROR(D8+12,\"\")","v":""},{"$f":"IFERROR(D8+13,\"\")","v":""},"Subtotal"]
[{"$nulls":17},{"$f":"SUM(D9:Q9)","v":0},null,"HR","Regular Time",{"v":7.5,"d":"7.50"},null,"7.50 = 7hours 30 minutes"]
[{"$nulls":17},{"$f":"SUM(D10:Q10)","v":0},null,"PTO","Paid Time Off",{"v":7.5,"d":"7.50"}]
[{"$nulls":17},0,null,"LWP","Leave Without Pay",{"v":7.5,"d":"7.50"}]
[{"$nulls":17},0,null,"HOL","Holiday",{"v":7.5,"d":"7.50"}]
[{"$nulls":17},0,null,"DAY","Daily Rate",{"v":1,"d":"1.00"}]
[{"$nulls":17},0,null,"OT","Overtime","> 8",null,"Overtime is over 8.00 hours (not 7.50!)"]
[{"$nulls":17},0,null,"AD","Admin Leave",{"v":7.5,"d":"7.50"}]
[{"$nulls":17},0,null,"JUR","Jury Duty",{"v":7.5,"d":"7.50"}]
[{"$nulls":17},0]
[{"$nulls":17},0,null,"Question about your time and paycodes, contact payroll at 334-0141"]
[null,"HR Weekly",null,{"$f":"IF(J19>40,\"HR cannot be over 40 hours per week!\",\"\")","v":""},{"$nulls":5},{"$f":"IF(B9=\"HR\",SUM(D9:J9))+IF(B10=\"HR\",SUM(D10:J10))+IF(B11=\"HR\",SUM(D11:J11))+IF(B12=\"HR\",SUM(D12:J12))+IF(B13=\"HR\",SUM(D13:J13))+IF(B14=\"HR\",SUM(D14:J14))+IF(B15=\"HR\",SUM(D15:J15))+IF(B16=\"HR\",SUM(D16:J16))+IF(B17=\"HR\",SUM(D17:J17))+IF(B18=\"HR\",SUM(D18:J18))","v":0},{"$f":"IF(Q19>40,\"HR cannot be over 40 hours per week!\",\"\")","v":""},{"$nulls":5},{"$f":"IF(B9=\"HR\",SUM(K9:Q9))+IF(B10=\"HR\",SUM(K10:Q10))+IF(B11=\"HR\",SUM(K11:Q11))+IF(B12=\"HR\",SUM(K12:Q12))+IF(B13=\"HR\",SUM(K13:Q13))+IF(B14=\"HR\",SUM(K14:Q14))+IF(B15=\"HR\",SUM(K15:Q15))+IF(B16=\"HR\",SUM(K16:Q16))+IF(B17=\"HR\",SUM(K17:Q17))+IF(B18=\"HR\",SUM(K18:Q18))","v":0},null,null,"payroll@chugachmiut.org"]
[null,"Total Daily",null,{"$f":"SUM(D9:D18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Weekly",null,{"$f":"SUM(D20:J20)","v":0},{"$nulls":6},{"$f":"SUM(K20:Q20)","v":0},{"$nulls":8},"Any question about this Timesheet Template, please contact:"]
[{"$nulls":19},"Nikolai: 334-0151",null,"nikolai@chugachmiut.org"]
[]
[null,null,"HR Total: ",{"$f":"IF(B9=\"HR\",R9)+IF(B10=\"HR\",R10)+IF(B11=\"HR\",R11)+IF(B12=\"HR\",R12)+IF(B13=\"HR\",R13)+IF(B14=\"HR\",R14)+IF(B15=\"HR\",R15)+IF(B16=\"HR\",R16)+IF(B17=\"HR\",R17)+IF(B18=\"HR\",R18)","v":0},null,"OT Total: ",{"$f":"IF(B9=\"OT\",R9)+IF(B10=\"OT\",R10)+IF(B11=\"OT\",R11)+IF(B12=\"OT\",R12)+IF(B13=\"OT\",R13)+IF(B14=\"OT\",R14)+IF(B15=\"OT\",R15)+IF(B16=\"OT\",R16)+IF(B17=\"OT\",R17)+IF(B18=\"OT\",R18)","v":0},null,"HOL Total: ",{"$f":"IF(B9=\"HOL\",R9)+IF(B10=\"HOL\",R10)+IF(B11=\"HOL\",R11)+IF(B12=\"HOL\",R12)+IF(B13=\"HOL\",R13)+IF(B14=\"HOL\",R14)+IF(B15=\"HOL\",R15)+IF(B16=\"HOL\",R16)+IF(B17=\"HOL\",R17)+IF(B18=\"HOL\",R18)","v":0},{"$nulls":9},"To unlock this Worksheet no password required:"]
[null,null,"PTO Total: ",{"$f":"IF(B9=\"PTO\",R9)+IF(B10=\"PTO\",R10)+IF(B11=\"PTO\",R11)+IF(B12=\"PTO\",R12)+IF(B13=\"PTO\",R13)+IF(B14=\"PTO\",R14)+IF(B15=\"PTO\",R15)+IF(B16=\"PTO\",R16)+IF(B17=\"PTO\",R17)+IF(B18=\"PTO\",R18)","v":0},null,"LWP Total: ",{"$f":"IF(B9=\"LWP\",R9)+IF(B10=\"LWP\",R10)+IF(B11=\"LWP\",R11)+IF(B12=\"LWP\",R12)+IF(B13=\"LWP\",R13)+IF(B14=\"LWP\",R14)+IF(B15=\"LWP\",R15)+IF(B16=\"LWP\",R16)+IF(B17=\"LWP\",R17)+IF(B18=\"LWP\",R18)","v":0},null,"Other Total: ",{"$f":"R25-D24-G24-D25-J24","v":0},{"$nulls":6},"Pay Period Total: ",{"$f":"SUM(R9:R18)","v":0},null,"right click on [Timesheet Template] Tab, then click [Unprotect]"]
[{"$nulls":3},"Employee signature: ",{"$nulls":7},"Date: ","            /            /2016"]
[{"$nulls":3},"Supervisor signature: ",{"$nulls":7},"Date: ","            /            /2016",{"$nulls":6},"Timesheet Excel Template Version: 4"]
[{"$nulls":10},"These Signatures certify actual hours worked"]

{"sheet":"Payroll Calendar","index":1,"n_rows":29,"n_cols":7,"rows_kept":29}
["Pey Period Start","Pay Period End","Timesheet Due","Pay Day",null,"Holiday","Date observed"]
["2015-12-20","2016-01-02","2016-01-04","2016-01-08",null,"New Years Day","2015-12-25"]
["2016-01-03","2016-01-16","2016-01-19","2016-01-22",null,null,"2016-01-01"]
["2016-01-17","2016-01-30","2016-02-01","2016-02-05",null,"Martin Luther King Jr. Day","2016-01-18"]
["2016-01-31","2016-02-13","2016-02-16","2016-02-19"]
["2016-02-14","2016-02-27","2016-02-29","2016-03-04",null,"Presidents Day","2016-02-15"]
["2016-02-28","2016-03-12","2016-03-14","2016-03-18"]
["2016-03-13","2016-03-26","2016-03-29","2016-04-01",null,"Chenega Day","2016-03-25"]
["2016-03-27","2016-04-09","2016-04-11","2016-04-15",null,"Seward's Day","2016-03-28"]
["2016-04-10","2016-04-23","2016-04-25","2016-04-29"]
["2016-04-24","2016-05-07","2016-05-09","2016-05-13"]
["2016-05-08","2016-05-21","2016-05-23","2016-05-27"]
["2016-05-22","2016-06-04","2016-06-06","2016-06-10",null,"Memorial Day","2016-05-30"]
["2016-06-05","2016-06-18","2016-06-20","2016-06-24"]
["2016-06-19","2016-07-02","2016-07-05","2016-07-08"]
["2016-07-03","2016-07-16","2016-07-18","2016-07-22",null,"Independence Day","2016-07-04"]
["2016-07-17","2016-07-30","2016-08-01","2016-08-05"]
["2016-07-31","2016-08-13","2016-08-15","2016-08-19"]
["2016-08-14","2016-08-27","2016-08-29","2016-09-02"]
["2016-08-28","2016-09-10","2016-09-12","2016-09-16",null,"Labor Day","2016-09-05"]
["2016-09-11","2016-09-24","2016-09-26","2016-09-30"]
["2016-09-25","2016-10-08","2016-10-10","2016-10-14"]
["2016-10-09","2016-10-22","2016-10-24","2016-10-28"]
["2016-10-23","2016-11-05","2016-11-07","2016-11-10"]
["2016-11-06","2016-11-19","2016-11-21","2016-11-25",null,"Veterans Day","2016-11-11"]
["2016-11-20","2016-12-03","2016-12-05","2016-12-09",null,"Thanksgiving Day","2016-11-24"]
["2016-12-04","2016-12-17","2016-12-19","2016-12-23",null,"Day After Thanksgiving","2016-11-25"]
["2016-12-18","2016-12-31","2017-01-02","2017-01-06"]
["2016-12-18","2016-12-31","2017-01-02","2017-01-06",null,"Christmas Day","2016-12-26"]