{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Module1","Module3","Module4","Module5","24th June"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":0,"reason":"part_missing"},{"sheet":"Module3","index":1,"reason":"part_missing"},{"sheet":"Module4","index":2,"reason":"part_missing"},{"sheet":"Module5","index":3,"reason":"part_missing"}],"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":"24th June","index":4,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[20,0,20,20]]}
[null,null,null,null,null,"AUSTRALIAN NATIONAL UNIVERSITY"]
["All Times should be  in 24-hour format, with a decimal point -- five thirty is 17.30"]
[0,null,null,"Uni ID:",null,0,null,null,"This Period Ends:",null,null,"2013-01-02",null,null,null,null,"Location:",null,0]
[]
[null,{"$f":"TEXT(C5-1,\"dd/mm\")","v":"06/12"},{"$f":"TEXT(D5-3,\"dd/mm\")","v":"07/12"},{"$f":"TEXT(E5-1,\"dd/mm\")","v":"10/12"},{"$f":"TEXT(F5-1,\"dd/mm\")","v":"11/12"},{"$f":"TEXT(G5-1,\"dd/mm\")","v":"12/12"},{"$f":"TEXT(H5-1,\"dd/mm\")","v":"13/12"},{"$f":"TEXT(I5-3,\"dd/mm\")","v":"14/12"},{"$f":"TEXT(J5-1,\"dd/mm\")","v":"17/12"},{"$f":"TEXT(K5-1,\"dd/mm\")","v":"18/12"},{"$f":"TEXT(L5-1,\"dd/mm\")","v":"19/12"},{"$f":"TEXT(M5-1,\"dd/mm\")","v":"20/12"},{"$f":"TEXT(N5-3,\"dd/mm\")","v":"21/12"},{"$f":"TEXT(O5-1,\"dd/mm\")","v":"24/12"},{"$f":"TEXT(P5-1,\"dd/mm\")","v":"25/12"},{"$f":"TEXT(Q5-1,\"dd/mm\")","v":"26/12"},{"$f":"TEXT(R5-1,\"dd/mm\")","v":"27/12"},{"$f":"TEXT(S5-3,\"dd/mm\")","v":"28/12"},{"$f":"TEXT(T5-1,\"dd/mm\")","v":"31/12"},{"$f":"TEXT(U5-1,\"dd/mm\")","v":"01/01"},{"$f":"TEXT(L3,\"dd/mm\")","v":"02/01"}]
[null,"Thur","Fri","Mon","Tue","Wed",{"$f":"B6","v":"Thur"},{"$f":"C6","v":"Fri"},{"$f":"D6","v":"Mon"},{"$f":"E6","v":"Tue"},{"$f":"F6","v":"Wed"},{"$f":"B6","v":"Thur"},{"$f":"C6","v":"Fri"},{"$f":"D6","v":"Mon"},{"$f":"E6","v":"Tue"},{"$f":"F6","v":"Wed"},{"$f":"B6","v":"Thur"},{"$f":"C6","v":"Fri"},{"$f":"D6","v":"Mon"},{"$f":"E6","v":"Tue"},{"$f":"F6","v":"Wed"}]
["Start"]
["Finish"]
["Sub total",{"$f":"TimeAdd(B8,-B7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Start"]
["Finish"]
["Sub total",{"$f":"TimeAdd(B11,-B10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Start"]
["Finish"]
["Sub total",{"$f":"TimeAdd(B14,-B13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Start"]
["Finish"]
["Sub total",{"$f":"TimeAdd(B17,-B16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hours Worked",{"$f":"TimeAdd(TimeAdd(TimeAdd(B18,B15),B12),B9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[false,false,false,false,false,false,false,false,false,false,false,false,false,true,true,false,false,false,true,false,0]
["TIMES TO BE INSERTED ON THIS FORM ARE THE TIMES THAT YOU ACTUALLY COMMENCE AND CEASE WORKING ON DEPARTMENTAL ACTIVITIES, \nNOT TIMES OF ARRIVAL AND DEPARTURE"]
["Span of Hours = 0800 - 1800 Mon-Fri.  Hours worked outside of the span will not be recognised unless prior approval has been given in writing (to be attached)."]
[]
["Public Holiday"]
["Leave",null,null,null,null,null,null,null,null,null,null,null,null,7,7,7,7,7,7,7]
["Type",null,null,null,null,null,null,null,null,null,null,null,null,"Uni","Pub Hol","Pub Hol","Uni","Uni","Uni","Pub Hol"]
["Total  for Day",{"$f":"IF(ISBLANK(B26),B19,TimeAdd(B19,B25))","v":0},0,0,0,0,0,0,0,0,0,0,0,7,7,7,7,7,7,7,0]
["From Previous Day",null,{"$f":"B29","v":0},0,0,0,0,0,0,0,0,0,0,0,7,14,21,28,35,42,49]
["Total  to date",{"$f":"TimeAdd(B28,B27)","v":0},0,0,0,0,0,0,0,0,0,0,0,7,14,21,28,35,42,49,49]
["Standard Hours",7,14,21,28,{"$f":"TimeAdd(E30,7)","v":35},42,49,56,63,70,77,84,91,98,105,112,119,126,133,140]
["Cumulative Total",{"$f":"TimeAdd(B29,-B30)","v":-7},-14,-21,-28,-35,-42,-49,-56,-63,-70,-77,-84,-84,-84,-84,-84,-84,-84,-84,-91]
[]
[]
[]
[]
[]
["   OFFICER'S CERTIFICATION",null,null,null,"SUPERVISOR'S REPORT",null,null,null,null,null,"EXCESS DEBIT OPTIONS:",null,null,null,null,"ERROR CORRECTION"]
["      I certify that the details on",null,null,null,"Attendance record correct",null,null,null,null,null,"Recreation Leave",null,null,null,null,"(Notice Attatched)"]
["      this form are correct",null,null,null,"Overtime performed",null,null,null,null,null,"Leave without Pay"]
[null,null,null,null,null,null,null,null,null,null,"(Attach leave application)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CARRY-ON TOTAL",null,null,{"$f":"TimeAdd(T37,U31)","v":-91}]
["__________________/____/20___",null,null,null,{"$f":"A42","v":"__________________/____/20___"},null,null,null,null,null,"DEDUCTED V ____/_____",null,null,null,null,null,null,null,null,null,"NOTE:  A maximum of 14 hours may be carried over"]