{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","GRTW Timesheet","Validation","Warning"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Instructions","index":0,"n_rows":66,"n_cols":4,"rows_kept":66,"cut":false,"hidden":false,"merged":[[24,0,24,2],[4,0,4,3],[0,0,0,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[14,1,14,3],[18,0,18,3],[20,0,20,2],[22,0,22,2],[2,0,2,3],[49,1,49,3],[26,0,26,3],[32,0,32,1],[30,0,30,1],[28,0,28,1],[34,0,34,3],[36,0,36,3],[38,0,38,3],[40,0,40,3],[42,0,42,3],[44,0,44,3],[48,1,48,3],[63,0,63,3],[65,0,65,3],[51,0,51,3],[53,0,53,3],[55,0,55,3],[57,0,57,3],[59,0,59,3],[61,0,61,3]]}
["INSTRUCTIONS FOR COMPLETING GRTW TIMESHEET"]
[]
["If prompted, the \"Enable Content\" button must be clicked first before completing the GRTW Timesheet."]
[]
["This excel version of the GRTW Timesheet includes formulas to auto-populate specific cells and generate emails to submit to your regional Claims Officer, making it quicker and easier to complete and process."]
[]
["PROCESS"]
[]
["1.","The injured/ill employee electronically completes the timesheet at the end of each week of their GRTW plan."]
["2.","The injured/ill employee emails the completed timesheet to their supervisor for their approval."]
["3.","The supervisor reviews the hours recorded in the timesheet, makes any necessary enquiries or amendments and once hours are confirmed, forwards the email to the RRTWC, noting their approval of the timesheet in their email message."]
["4.","The RRTWC reviews the timesheet and ensures that all sections are appropriately completed.  In particular, the approvals section needs to indicate the dates and methods of approvals for all parties, eg. email approval or signature."]
["5.","The RRTWC then selects the Verify and Submit button at the bottom of the timesheet, which generates an email message to be sent to the appropriate Claims Officers."]
[]
[null,"PLEASE NOTE: Some employees may need assistance to electronically complete the timesheet and/or with emails.  Timesheets may be electronically completed by the RRTWC or Supervisor during a conversation with the injured/ill employee, eg. Cleaners and Schools Officers."]
[]
["GUIDELINES"]
[]
["The type of information to be entered into each field is explained below."]
[]
["Employee Name: SURNAME, Firstname",null,null,"Employee Number: must be 7 digits long"]
[]
["School/Location: School or work unit name",null,null,"WorkCover Claim No: must be 11 digits long"]
[]
["Claims Office: select from drop down list",null,null,"Is this for a Cleaner? yes/no drop down list"]
[]
["Start Date: enter date using / or – to separate numbers, eg. 1/1/17"]
[]
["Rostered Hours:",null,"enter as hours, eg.","7.25 hours NOT 7:15 (hours:minutes)"]
[]
["RTW Plan Hours: ",null,"enter as hours, eg.","7.6 hours NOT 7:36 (hours:minutes)"]
[]
["Actual Hours Worked:",null,"enter as hours"]
[]
["Leave Hours Taken: auto calculates when rostered hours and actual hours worked are entered"]
[]
["Leave Type Used: select from drop down list"]
[]
["The WorkCover-paid leave type is used for the first 26 weeks of most WorkCover claims, where the Department pays employees directly and WorkCover reimburse the Department for wages."]
[]
["The WorkCover-no pay leave type is used for most WorkCover claims longer than 26 weeks, where WorkCover pay wages directly to the employee."]
[]
["Long Service Leave half pay can only be selected for a minimum of 1 week."]
[]
["Annual Leave is available for Cleaners and Teacher Aides only."]
[]
[null,"PLEASE NOTE:"]
[]
[null,"If an employee is on a WorkCover or QSuper claim and is absent due to a different medical condition, a different leave type for the full day of absence needs to be selected.  For example, an employee working a 5 hour/day roster is scheduled to work 3 hours on their GRTW plan with 2 hours of WorkCover leave, but is absent for the full day with a cold, so leave is recorded as sick leave for the full day (5 hours)."]
[null,"For absences in addition to those on the GRTW plan for the same medical condition covered by a WorkCover or QSuper claim, medical certificates are required by WorkCover and QSuper."]
[]
["Approval: select from drop down list – email confirmation/signature provided/verbal confirmation"]
[]
["Signatures on printed timesheets are NOT required."]
[]
["Approvals can be recorded in emails between an injured/ill employee, their supervisor and their RRTWC.\nApproval emails must include signature blocks with name and position title, and must come from an official Department email address, eg. @eq.edu.au or @det.qld.gov.au."]
[]
["Approvals given verbally can be recorded on the timesheet and in rehabilitation case notes."]
[]
["CLAIMS OFFICER USE ONLY"]
[]
["Only Claims Officer are to complete this section and electronically completed timesheets are required for Claims Officers to use the drop down lists and auto calculations in this form."]
[]
["Verify and Submit"]
[]
["Once the timesheet has been electronically completed and approvals are confirmed, selecting the Verify and Select button will generate an email to the correct regional claims office email address.  If the timesheet is for a Cleaner, the auto generated email will also send to the Claims Officers who process Cleaner claims."]

{"sheet":"GRTW Timesheet","index":1,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,0,2,12],[29,2,29,3],[28,2,28,3],[27,2,27,3],[26,2,26,3],[25,2,25,3],[24,2,24,3],[23,2,23,3],[12,0,12,12],[10,0,10,12],[8,0,8,12],[6,0,6,12],[4,0,4,12],[1,0,1,12],[28,5,28,6],[33,9,33,10],[32,9,32,10],[35,11,35,12],[34,11,34,12],[33,11,33,12],[32,11,32,12],[47,1,47,4],[43,1,43,6],[39,7,39,8],[39,2,39,5],[39,9,39,11],[39,0,39,1],[45,9,45,11],[43,9,43,11],[41,3,41,7],[41,0,41,2],[45,1,45,7],[30,11,30,12],[24,5,24,6],[35,1,35,5],[34,1,34,5],[33,1,33,5],[32,1,32,5],[29,5,29,6],[35,6,35,8],[34,6,34,8],[33,6,33,8],[32,6,32,8],[28,0,28,1],[27,0,27,1],[26,0,26,1],[35,9,35,10],[34,9,34,10],[25,11,25,12],[27,5,27,6],[14,1,14,7],[23,5,23,6],[14,8,14,9],[14,10,14,12],[16,8,16,9],[16,1,16,7],[18,1,18,7],[18,8,18,9],[21,1,21,3],[50,1,50,12],[51,1,51,12],[37,0,37,12],[31,0,31,12],[16,10,16,12],[23,11,24,12],[24,0,24,1],[29,0,29,1],[23,0,23,1],[25,0,25,1],[29,11,29,12],[28,11,28,12],[27,11,27,12],[26,5,26,6],[25,5,25,6],[26,11,26,12]]}
["Graduated Return to Work Timesheet"]
["(This form incorporates applications for leave during a GRTW plan)"]
["Excel Version of CM12"]
[null,null,null,null,null,null,null,null,null,null,null,null,"version 1.1.1"]
["Department of Education"]
[]
["Privacy Notice: The Department of Education (the department) is collecting information on the below employee’s work times and leave during their ‘graduated return to work plan’ or ‘maintain at work plan’ in accordance with the department’s ‘Workplace Rehabilitation’ procedure. The information will be used to ensure the employee’s pay and leave are processed correctly by the department and any relevant insurers, e.g. WorkCover Queensland or QSuper, and also to monitor progress with the employee’s rehabilitation plan. The information will only be accessed by the employee’s supervisor, Rehabilitation and Return to Work Coordinator and claims officers to facilitate pay and leave processing. This information may be given to WorkCover Queensland, QSuper or other income protection insurer to facilitate the correct benefit payments from the applicable organisation. The employee’s information will not be given to any other person or agency unless the employee has given their consent or the department is authorised or required to respond to lawful requests from public authorities, including law enforcement."]
[]
["Action Required:  This form must be completed by employees participating in a graduated return to work program."]
[]
["Completing the timesheet each Friday ensures that you receive correct payment from the Department and any relevant insurers, e.g. WorkCover, QSuper.\n\nOnce this timesheet has been approved, please electronically submit using the Verify & Submit button at the bottom of this form."]
[]
["EMPLOYEE DETAILS"]
[]
["Employee Name:",null,null,null,null,null,null,null,"Employee Number:"]
[]
["School/Location:",null,null,null,null,null,null,null,"WorkCover Claim No:"]
[]
["Claims Office:",null,null,null,null,null,null,null,"Is this for a Cleaner?"]
[]
[]
["Start Date:"]
[]
["WEEK COMMENCING",null,"MON",null,"TUE","WED",null,"THU","FRI","SAT","SUN","TOTAL HOURS"]
[{"$f":"IF(B22=\"\",\"\",B22)","v":""},null,{"$f":"IF($A$25=\"\",\"\",A25)","v":""},null,{"$f":"IF($A$25=\"\",\"\",C25+1)","v":""},{"$f":"IF($A$25=\"\",\"\",E25+1)","v":""},null,{"$f":"IF($A$25=\"\",\"\",F25+1)","v":""},{"$f":"IF($A$25=\"\",\"\",H25+1)","v":""},{"$f":"IF($A$25=\"\",\"\",I25+1)","v":""},{"$f":"IF($A$25=\"\",\"\",J25+1)","v":""}]
["Rostered Hours",null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(C26:K26)","v":0}]
["RTW Plan Hours",null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(C27:K27)","v":0}]
["Actual Hours Worked",null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(C28:K28)","v":0}]
["Leave Hours Taken",null,{"$f":"IF(C26-C28=0,\"\",C26-C28)","v":""},null,{"$f":"IF(E26-E28=0,\"\",E26-E28)","v":""},{"$f":"IF(F26-F28=0,\"\",F26-F28)","v":""},null,{"$f":"IF(H26-H28=0,\"\",H26-H28)","v":""},{"$f":"IF(I26-I28=0,\"\",I26-I28)","v":""},{"$f":"IF(J26-J28=0,\"\",J26-J28)","v":""},{"$f":"IF(K26-K28=0,\"\",K26-K28)","v":""},{"$f":"SUM(C29:K29)","v":0}]
["Leave Type Used"]
[null,null,{"$f":"IF(ISNA(VLOOKUP(C30,Validation!$A:$B,2,FALSE)),0,VLOOKUP(C30,Validation!$A:$B,2,FALSE)*C29)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(E30,Validation!$A:$B,2,FALSE)),0,VLOOKUP(E30,Validation!$A:$B,2,FALSE)*E29)","v":0},{"$f":"IF(ISNA(VLOOKUP(F30,Validation!$A:$B,2,FALSE)),0,VLOOKUP(F30,Validation!$A:$B,2,FALSE)*F29)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(H30,Validation!$A:$B,2,FALSE)),0,VLOOKUP(H30,Validation!$A:$B,2,FALSE)*H29)","v":0},{"$f":"IF(ISNA(VLOOKUP(I30,Validation!$A:$B,2,FALSE)),0,VLOOKUP(I30,Validation!$A:$B,2,FALSE)*I29)","v":0},{"$f":"IF(ISNA(VLOOKUP(J30,Validation!$A:$B,2,FALSE)),0,VLOOKUP(J30,Validation!$A:$B,2,FALSE)*J29)","v":0},{"$f":"IF(ISNA(VLOOKUP(K30,Validation!$A:$B,2,FALSE)),0,VLOOKUP(K30,Validation!$A:$B,2,FALSE)*K29)","v":0},{"$f":"SUM(C31:K31)+L28","v":0}]
["APPROVALS"]
["PERSON","RESPONSIBILITY",null,null,null,null,"NAME",null,null,"APPROVAL",null,"DATE"]
["Employee","This is a true reflection of the hours I worked.",null,null,null,null,{"$f":"IF(B15=\"\",\"\",IF(ISERROR(RIGHT(B15,LEN(B15)-SEARCH(\",\",B15,1))&\" \"&LEFT(B15,SEARCH(\",\",B15,1)-1)),B15,RIGHT(B15,LEN(B15)-SEARCH(\",\",B15,1))&\" \"&LEFT(B15,SEARCH(\",\",B15,1)-1)))","v":""}]
["Supervisor","I confirm this is an accurate record of work hours performed."]
["Rehab & RTW Coordinator","I have confirmed the recorded work hours with the employee and supervisor."]
[]
["CLAIMS OFFICER USE ONLY"]
[]
["Hourly Rate of Pay",null,null,null,null,null,null,"Gross wages paid for period",null,{"$f":"IF(C40=\"\",\"\",ROUND(L31*C40,2))","v":""}]
[]
["WorkCover to Reimburse:"]
[]
["Name:",null,null,null,null,null,null,null,"Telephone No:"]
[]
["Email:",null,null,null,null,null,null,null,"Date:"]
[]
["Region:"]
[]
[]
["Email Address:",{"$f":"IF(B19=\"\",\"\",VLOOKUP(B19,Validation!K:L,2,FALSE)&IF(K19=\"Yes\",\"; \"&Validation!L2,\"\"))","v":""}]
["Subject:",{"$f":"IF(OR(K15=\"\",B15=\"\",A25=\"\"),\"\",\"GRTW Timesheet for \"&K15&\" - \"&B15&\" \"&TEXT(A25,\"dd/mm/yyyy\"))","v":""}]

{"sheet":"Validation","index":2,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Leave Types",{"$f":"\"Validation!$A$2:$A$\"&COUNTA(A:A)+1","v":"Validation!$A$2:$A$14"},null,"Regions",{"$f":"\"Validation!$D$2:$D$\"&COUNTA(D:D)","v":"Validation!$D$2:$D$9"},null,"Validation on Submit",null,null,null,"Claims Office","Email Address",{"$f":"\"Validation!$K$3:$K$\"&COUNTA(K:K)","v":"Validation!$K$3:$K$14"},null,"Approval",{"$f":"\"Validation!$O$2:$O$\"&COUNTA(O:O)+1","v":"Validation!$O$2:$O$5"}]
[null,null,null,"Central Office",null,null,"Employee Name is incomplete.",{"$f":"IF(LEN('GRTW Timesheet'!B15)=0,\"ERROR\",\"OK\")","v":"ERROR"},null,null,"Cleaners","claimsmanagement.strathr@det.qld.gov.au",{"$f":"\"Validation!$L$2:$L$\"&COUNTA(L:L)","v":"Validation!$L$2:$L$14"}]
["WorkCover - paid",0,null,"Central Queensland",null,null,"Employee Number is incomplete.",{"$f":"IF(LEN('GRTW Timesheet'!K15)=0,\"ERROR\",\"OK\")","v":"ERROR"},null,null,"Central Office","claimsmanagement.CO@det.qld.gov.au",null,null,"email confirmation"]
["WorkCover - no pay",0,null,"Darling Downs & South West",null,null,"Claims Office is incomplete.",{"$f":"IF(LEN('GRTW Timesheet'!B19)=0,\"ERROR\",\"OK\")","v":"ERROR"},null,null,"Central Queensland","claimsmanagement.CQR@det.qld.gov.au",null,null,"signature provided"]
["QSuper",0,null,"Far North Queensland",null,null,"Week Commencing date is incomplete.",{"$f":"IF(LEN('GRTW Timesheet'!A25)=0,\"ERROR\",\"OK\")","v":"ERROR"},null,null,"Darling Downs and South West","claimsmanagement.DDSWQ@det.qld.gov.au",null,null,"verbal confirmation"]
["Sick Leave",1,null,"Metropolitan",null,null,"Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Timesheet'!C29)<>0,LEN('GRTW Timesheet'!C30)=0),AND(LEN('GRTW Timesheet'!E29)<>0,LEN('GRTW Timesheet'!E30)=0),AND(LEN('GRTW Timesheet'!F29)<>0,LEN('GRTW Timesheet'!F30)=0),AND(LEN('GRTW Timesheet'!H29)<>0,LEN('GRTW Timesheet'!H30)=0),AND(LEN('GRTW Timesheet'!I29)<>0,LEN('GRTW Timesheet'!I30)=0),AND(LEN('GRTW Timesheet'!J29)<>0,LEN('GRTW Timesheet'!J30)=0),AND(LEN('GRTW Timesheet'!K29)<>0,LEN('GRTW Timesheet'!K30)=0)),\"ERROR\",\"OK\")","v":"OK"},null,null,"Far North Queensland","claimsmanagement.farnthqld@det.qld.gov.au"]
["Recreation - Full Pay",1,null,"North Coast",null,null,"Approvals section is incomplete.",{"$f":"IF(OR(LEN('GRTW Timesheet'!J34)=0,LEN('GRTW Timesheet'!J35)=0,LEN('GRTW Timesheet'!J36)=0),\"ERROR\",\"OK\")","v":"ERROR"},null,null,"Metropolitan - North","claimsmanagement.MetroNTH@det.qld.gov.au"]
["Recreation - Half Pay",0.5,null,"North Queensland",null,null,null,null,null,null,"Metropolitan - South","claimsmanagement.MetroSTH@det.qld.gov.au"]
["Annual Leave",1,null,"South East",null,null,null,null,null,null,"Metropolitan - West","claimsmanagement.MetroWST@det.qld.gov.au"]
["Long Service - Full Pay",1,null,null,null,null,null,null,null,null,"North Coast - Maroochydore","claimsmanagement.Nambour@det.qld.gov.au"]
["Long Service - Half Pay",0.5,null,null,null,null,null,null,null,null,"North Coast - Maryborough","claimsmanagement.WBB@det.qld.gov.au"]
["Special Leave - no pay",0,null,null,null,null,null,null,null,null,"North Coast - North Lakes","claimsmanagement.suncoast_SS@det.qld.gov.au"]
["Public Holiday",1,null,null,null,null,null,null,null,null,"North Queensland","claimsmanagement.NTHQLD@det.qld.gov.au"]
["ADO",1,null,null,null,null,null,null,null,null,"South East","claimsmanagement.southcoast@det.qld.gov.au"]

{"sheet":"Warning","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}