{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","GRTW Plan","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":97,"n_cols":4,"rows_kept":97,"cut":false,"hidden":false,"merged":[[96,0,96,3],[82,0,82,3],[84,0,84,3],[86,0,86,3],[88,0,88,3],[90,0,90,3],[92,0,92,3],[80,1,80,3],[58,0,58,3],[60,0,60,3],[62,0,62,3],[64,0,64,3],[66,0,66,3],[68,0,68,3],[70,0,70,3],[74,1,74,3],[76,1,76,3],[72,1,72,3],[78,1,78,3],[52,1,52,3],[50,1,50,3],[54,0,54,1],[56,0,56,1],[56,2,56,3],[54,2,54,3],[48,0,48,3],[26,0,26,3],[34,0,34,2],[32,0,32,2],[30,0,30,2],[28,0,28,2],[36,0,36,3],[38,0,38,3],[40,0,40,2],[44,0,44,3],[46,0,46,3],[42,0,42,2],[0,0,0,3],[18,0,18,3],[16,0,16,3],[20,0,20,2],[22,0,22,2],[2,0,2,3],[24,0,24,2],[4,0,4,3],[14,1,14,3],[13,1,13,3],[12,1,12,3],[11,1,11,3],[10,1,10,3],[9,1,9,3],[8,1,8,3],[6,0,6,3]]}
["INSTRUCTIONS FOR COMPLETING GRTW PLAN"]
[]
["If prompted, the \"Enable Content\" button must be clicked first before completing the GRTW Plan."]
[]
["This excel version of the GRTW Plan includes formulas to auto-populate specific cells and generate emails to submit this plan to your regional Claims Officer, making it quicker and easier to complete and process."]
[]
["PROCESS"]
[]
["1.","The Rehabilitation and Return to Work Coordinator (RRTWC) has discussions with the injured/ill employee and supervisor, and seeks or refers to information from the medical practitioner."]
["2.","The RRTWC electronically completes the GRTW Plan based on these discussions and medical information."]
["3.","The RRTWC seeks commitment to the plan and specific approvals from the supervisor and injured/ill employee.  Approvals can be provided via emails, in discussions or by gaining signatures on the plan."]
["4.","The RRTWC seeks approval of the GRTW plan from the medical practitioner. However, if there is enough detail on the medical certificate or report from the medical practitioner, which is consistent with the plan, further approval is not required from the medical practitioner."]
["5.","Once all parties have provided approval of the plan, the RRTWC records the method of approvals and dates in the electronic plan."]
["6.","The RRTWC then selects the Verify and Submit button at the bottom of the plan, which generates an email message to be sent to the appropriate Claims Office."]
["7.","When a Claims Officer receives a completed GRTW plan, they enter the relevant leave records into the TSS payroll system."]
[]
["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"]
[]
["Position: role title"]
[]
["Medical Condition: as per medical certificate",null,null,"Funding Source: select from drop down list"]
[]
["Rostered Hours (per fortnight): Total number of hours worked per fortnight as hours NOT hours:minutes"]
[]
["Claim No: must be 11 digits long"]
[]
["RTW Location: school or work unit name"]
[]
["Claims Office: select from drop down list",null,null,"Is this for a Cleaner? yes/no drop down list"]
[]
["Long Term Goal: select from drop down list"]
[]
["Objective of this Plan: free text field, eg. Commence part-time team teaching and gradually increase the duties and hours being independently performed, with the goal of full hours and duties by the end of term."]
[]
["Original Commencement Date for RTW: the first date that an employee started to return to work for this medical condition, i.e. the start date on the first GRTW plan."]
[]
["Plan Length: auto-populates from start/end dates"]
[]
["Start Date eg. 2/1/17 or 2-1-17 must be a Monday",null,null,"End Date eg. 8/1/17 or 8-1-17 must be a Sunday"]
[]
["(Once a start date and end date are entered, the correct number of weeks will appear in the tables)"]
[]
["Plan Review Date: enter date using / or – to separate numbers, eg. 1/1/17 or 1-1-17"]
[]
["(the actual Plan Review Date will be highlighted in yellow in the relevant week of the plan)"]
[]
[null,"PLEASE NOTE:"]
[]
[null,"Data entered into week 1 of the plan will automatically copy to every week of the plan.  Details can then be edited in week 2 onwards.  To edit text in the Duties, Restrictions & Supports field, please press CTRL + C, then CTRL + ALT + V, then V and then Enter."]
[]
["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)"]
[]
["Leave Hours: auto calculates when rostered hours and RTW Plan Hours are entered"]
[]
["Leave Type: 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 Queensland 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 during the Christmas vacation or where there is an excessive balance, by specific workplace agreement."]
[]
["Recreation Leave is available for Public Servants and Schools Officers 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 stating the medical condition are required by WorkCover and QSuper."]
[]
[null,"PLEASE NOTE:"]
[]
[null,"Attendance at medical appointments is generally required to be outside of normal school hours unless exceptional circumstances have been discussed and approved by WorkCover."]
[]
["Duties, Restrictions & Supports: free text field, eg. full duties of a Lower Primary Teacher Aide as outlined in the Functional Job Requirements Report, working reduced hours."]
[]
["Approval: select from drop down list – email confirmation, signature provided or verbal confirmation."]
[]
["Signatures on printed GRTW plans are NOT required. If approvals cannot be gained through an email or verbal confirmation, signatures can be collected."]
[]
["Approvals can be recorded in emails between an injured/ill employee, supervisor and RRTWC.  Approval 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 by the RRTWC on the plan and in rehabilitation case notes."]
[]
["A detailed medical certificate or report from a medical practitioner, which is consistent with the plan, can be used as an approval from the medical practitioner. The drop down list option of medical certificate provided can be selected by the RRTWC."]
[]
["Verify and Submit"]
[]
["Once the GRTW Plan has been electronically completed and approvals are confirmed, selecting the Verify and Submit button will generate an email to the correct claims office.  If the plan is for a Cleaner, the auto generated email will also send to the Claims Officers who process Cleaner claims."]

{"sheet":"GRTW Plan","index":1,"n_rows":153,"n_cols":13,"rows_kept":153,"cut":false,"hidden":false,"merged":[[22,1,22,6],[22,7,22,8],[151,1,151,11],[152,1,152,11],[6,0,6,11],[1,0,1,11],[0,0,0,11],[4,0,4,11],[8,0,8,11],[51,0,51,1],[50,0,50,1],[49,0,49,1],[48,0,48,1],[47,0,47,1],[45,0,46,1],[10,7,10,8],[10,9,10,10],[45,6,45,7],[40,6,40,7],[14,7,14,8],[18,1,18,3],[16,1,16,3],[45,11,46,11],[30,9,30,11],[28,9,28,11],[30,6,30,8],[28,6,28,8],[30,1,30,5],[28,1,28,5],[24,0,24,5],[24,6,24,8],[24,9,24,11],[26,9,26,11],[26,6,26,8],[26,1,26,5],[53,0,54,1],[53,6,53,7],[53,11,54,11],[54,6,54,7],[55,0,55,1],[55,6,55,7],[34,1,34,11],[36,1,36,11],[32,0,32,11],[50,6,50,7],[49,6,49,7],[48,6,48,7],[47,6,47,7],[46,6,46,7],[51,2,51,11],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[42,1,42,2],[59,0,59,1],[59,2,59,11],[56,0,56,1],[56,6,56,7],[57,0,57,1],[57,6,57,7],[58,0,58,1],[58,6,58,7],[58,3,58,4],[73,0,73,1],[73,6,73,7],[71,3,71,4],[72,3,72,4],[73,3,73,4],[66,0,66,1],[66,6,66,7],[67,0,67,1],[67,2,67,11],[69,0,70,1],[69,6,69,7],[69,11,70,11],[70,6,70,7],[61,0,62,1],[61,6,61,7],[61,11,62,11],[62,6,62,7],[69,3,69,4],[70,3,70,4],[71,0,71,1],[71,6,71,7],[72,0,72,1],[72,6,72,7],[63,0,63,1],[63,6,63,7],[64,0,64,1],[64,6,64,7],[65,0,65,1],[65,6,65,7],[77,0,78,1],[77,6,77,7],[77,11,78,11],[78,6,78,7],[79,0,79,1],[79,6,79,7],[74,0,74,1],[74,6,74,7],[75,0,75,1],[75,2,75,11],[74,3,74,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[83,0,83,1],[83,2,83,11],[85,0,86,1],[85,6,85,7],[85,11,86,11],[86,6,86,7],[85,3,85,4],[86,3,86,4],[80,0,80,1],[80,6,80,7],[81,0,81,1],[81,6,81,7],[82,0,82,1],[82,6,82,7],[82,3,82,4],[80,3,80,4],[81,3,81,4],[87,0,87,1],[87,6,87,7],[88,0,88,1],[88,6,88,7],[89,0,89,1],[89,6,89,7],[87,3,87,4],[88,3,88,4],[89,3,89,4],[95,0,95,1],[95,6,95,7],[96,0,96,1],[96,6,96,7],[97,0,97,1],[97,6,97,7],[90,0,90,1],[90,6,90,7],[91,0,91,1],[91,2,91,11],[93,0,94,1],[93,6,93,7],[93,11,94,11],[94,6,94,7],[90,3,90,4],[93,3,93,4],[103,0,103,1],[103,6,103,7],[104,0,104,1],[104,6,104,7],[105,0,105,1],[105,6,105,7],[98,0,98,1],[98,6,98,7],[99,0,99,1],[99,2,99,11],[101,0,102,1],[101,6,101,7],[101,11,102,11],[102,6,102,7],[105,3,105,4],[104,3,104,4],[103,3,103,4],[102,3,102,4],[101,3,101,4],[98,3,98,4],[106,0,106,1],[106,6,106,7],[107,0,107,1],[107,2,107,11],[109,0,110,1],[109,6,109,7],[109,11,110,11],[110,6,110,7],[110,3,110,4],[109,3,109,4],[106,3,106,4],[111,0,111,1],[111,6,111,7],[112,0,112,1],[112,6,112,7],[113,0,113,1],[113,6,113,7],[113,3,113,4],[112,3,112,4],[111,3,111,4],[114,0,114,1],[114,6,114,7],[115,0,115,1],[115,2,115,11],[117,0,118,1],[117,6,117,7],[117,11,118,11],[118,6,118,7],[114,3,114,4],[118,3,118,4],[117,3,117,4],[119,0,119,1],[119,6,119,7],[120,0,120,1],[120,6,120,7],[121,0,121,1],[121,6,121,7],[121,3,121,4],[120,3,120,4],[119,3,119,4],[127,0,127,1],[127,6,127,7],[128,0,128,1],[128,6,128,7],[129,0,129,1],[129,6,129,7],[122,0,122,1],[122,6,122,7],[123,0,123,1],[123,2,123,11],[125,0,126,1],[125,6,125,7],[125,11,126,11],[126,6,126,7],[122,3,122,4],[129,3,129,4],[128,3,128,4],[127,3,127,4],[126,3,126,4],[125,3,125,4],[136,6,136,7],[137,0,137,1],[137,6,137,7],[137,3,137,4],[136,3,136,4],[135,3,135,4],[138,3,138,4],[135,0,135,1],[130,0,130,1],[130,6,130,7],[131,0,131,1],[131,2,131,11],[133,0,134,1],[133,6,133,7],[133,11,134,11],[134,6,134,7],[134,3,134,4],[133,3,133,4],[130,3,130,4],[149,0,149,11],[20,1,20,6],[38,0,38,2],[44,0,44,1],[40,3,40,4],[38,3,38,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[50,3,50,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[94,3,94,4],[95,3,95,4],[96,3,96,4],[97,3,97,4],[147,1,147,3],[146,1,146,3],[14,9,14,11],[14,1,14,6],[12,1,12,6],[10,1,10,6],[147,4,147,7],[146,4,146,7],[145,4,145,7],[144,4,144,7],[143,4,143,7],[147,8,147,10],[146,8,146,10],[145,8,145,10],[144,8,144,10],[143,8,143,10],[145,1,145,3],[144,1,144,3],[138,0,138,1],[138,6,138,7],[139,0,139,1],[139,2,139,11],[141,0,141,11],[143,1,143,3],[135,6,135,7],[136,0,136,1]]}
["Graduated Return to Work Plan"]
["Excel version of CM09"]
[null,null,null,null,null,null,null,null,null,null,null,"version 1.0.2"]
[]
["Department of Education"]
[]
["Privacy Notice: The Department of Education (the department) is using information on the below employee’s health and its impact on work in accordance with the department’s ‘Workplace Rehabilitation’ procedure, to support the provision of a workplace rehabilitation program. The information will only be accessed by a Rehabilitation and Return to Work Coordinator, to facilitate the employee’s workplace rehabilitation. Some of this information may be given to WorkCover Queensland, QSuper or other insurer, a treating doctor or allied health professional or a doctor appointed by the department for the purpose of informing rehabilitation options. Information relevant to the impact of an injury/illness upon an employee’s work may be discussed with a supervisor for the purpose of identifying or amending rehabilitation options. Information may also be discussed with regional or central office Injury Management and Human Resources employees. 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."]
[]
["A return to work plan records the hours, duties, restrictions and workplace support strategies for the safe and timely return to work of an injured/ill employee."]
[]
["Employee Name:",null,null,null,null,null,null,"Employee Number:"]
[]
["Position:"]
[]
["Medical Condition:",null,null,null,null,null,null,"Funding Source:"]
[]
["Rostered Hours (per fortnight):"]
[]
["Claim Number:"]
[]
["RTW Location:"]
[]
["Claims Office:",null,null,null,null,null,null,"Is this for a Cleaner?"]
[]
["CONTACTS",null,null,null,null,null,"PHONE",null,null,"EMAIL"]
[]
["Supervisor:"]
[]
["Rehab & RTW Coordinator:"]
[]
["Medical Practitioner:"]
[]
["REHABILITATION GOALS "]
[]
["Long Term Goal:"]
[]
["Objective of this Plan:"]
[]
["Original Commencement Date for RTW: "]
[]
["Plan Length:",10,{"$f":"IF(B41=1,\"week\",\"weeks\")","v":"weeks"},"Start Date:",null,"2018-02-19","End Date:",null,"2018-04-29"]
[]
["Plan Review Date:"]
[]
["Week Commencing"]
[{"$f":"\"Week 1: \"&TEXT(C47,\"DD/MM/YYYY\")","v":"Week 1: 19/02/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M47","v":1}]
[null,null,{"$f":"IF(F41=\"\",\"\",ROUND((F41-42920)/7,0)*7+42919)","v":"2018-02-19"},{"$f":"IF(C47=\"\",\"\",C47+1)","v":"2018-02-20"},null,{"$f":"IF(D47=\"\",\"\",D47+1)","v":"2018-02-21"},{"$f":"IF(F47=\"\",\"\",F47+1)","v":"2018-02-22"},null,{"$f":"IF(G47=\"\",\"\",G47+1)","v":"2018-02-23"},{"$f":"IF(I47=\"\",\"\",I47+1)","v":"2018-02-24"},{"$f":"IF(J47=\"\",\"\",J47+1)","v":"2018-02-25"},null,{"$f":"IF(C47<=$I$41,1,0)","v":1}]
["Rostered Hours",null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(C48:I48)","v":0},{"$f":"M47","v":1}]
["RTW Plan Hours",null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(C49:I49)","v":0},{"$f":"M48","v":1}]
["Leave Hours",null,{"$f":"IF(C48=\"\",\"\",IF(C48-C49=0,\"\",C48-C49))","v":""},{"$f":"IF(D48=\"\",\"\",IF(D48-D49=0,\"\",D48-D49))","v":""},null,{"$f":"IF(F48=\"\",\"\",IF(F48-F49=0,\"\",F48-F49))","v":""},{"$f":"IF(G48=\"\",\"\",IF(G48-G49=0,\"\",G48-G49))","v":""},null,{"$f":"IF(I48=\"\",\"\",IF(I48-I49=0,\"\",I48-I49))","v":""},{"$f":"IF(J48=\"\",\"\",IF(J48-J49=0,\"\",J48-J49))","v":""},{"$f":"IF(K48=\"\",\"\",IF(K48-K49=0,\"\",K48-K49))","v":""},{"$f":"SUM(C50:I50)","v":0},{"$f":"M49","v":1}]
["Leave Type",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M50","v":1}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M51","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M54","v":1}]
[{"$f":"\"Week 2: \"&TEXT(C55,\"DD/MM/YYYY\")","v":"Week 2: 26/02/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M55","v":1}]
[null,null,{"$f":"IF(I47=\"\",\"\",I47+3)","v":"2018-02-26"},{"$f":"IF(C55=\"\",\"\",C55+1)","v":"2018-02-27"},null,{"$f":"IF(D55=\"\",\"\",D55+1)","v":"2018-02-28"},{"$f":"IF(F55=\"\",\"\",F55+1)","v":"2018-03-01"},null,{"$f":"IF(G55=\"\",\"\",G55+1)","v":"2018-03-02"},{"$f":"IF(I55=\"\",\"\",I55+1)","v":"2018-03-03"},{"$f":"IF(J55=\"\",\"\",J55+1)","v":"2018-03-04"},null,{"$f":"IF(C55<=$I$41,1,0)","v":1}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C56:I56)","v":0},{"$f":"M55","v":1}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C57:I57)","v":0},{"$f":"M56","v":1}]
["Leave Hours",null,{"$f":"IF(C56=\"\",\"\",IF(C56-C57=0,\"\",C56-C57))","v":""},{"$f":"IF(D56=\"\",\"\",IF(D56-D57=0,\"\",D56-D57))","v":""},null,{"$f":"IF(F56=\"\",\"\",IF(F56-F57=0,\"\",F56-F57))","v":""},{"$f":"IF(G56=\"\",\"\",IF(G56-G57=0,\"\",G56-G57))","v":""},null,{"$f":"IF(I56=\"\",\"\",IF(I56-I57=0,\"\",I56-I57))","v":""},{"$f":"IF(J56=\"\",\"\",IF(J56-J57=0,\"\",J56-J57))","v":""},{"$f":"IF(K56=\"\",\"\",IF(K56-K57=0,\"\",K56-K57))","v":""},{"$f":"SUM(C58:I58)","v":0},{"$f":"M57","v":1}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M58","v":1}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M59","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M62","v":1}]
[{"$f":"\"Week 3: \"&TEXT(C63,\"DD/MM/YYYY\")","v":"Week 3: 05/03/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M63","v":1}]
[null,null,{"$f":"IF(I55=\"\",\"\",I55+3)","v":"2018-03-05"},{"$f":"IF(C63=\"\",\"\",C63+1)","v":"2018-03-06"},null,{"$f":"IF(D63=\"\",\"\",D63+1)","v":"2018-03-07"},{"$f":"IF(F63=\"\",\"\",F63+1)","v":"2018-03-08"},null,{"$f":"IF(G63=\"\",\"\",G63+1)","v":"2018-03-09"},{"$f":"IF(I63=\"\",\"\",I63+1)","v":"2018-03-10"},{"$f":"IF(J63=\"\",\"\",J63+1)","v":"2018-03-11"},null,{"$f":"IF(C63<=$I$41,1,0)","v":1}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C64:I64)","v":0},{"$f":"M63","v":1}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C65:I65)","v":0},{"$f":"M64","v":1}]
["Leave Hours",null,{"$f":"IF(C64=\"\",\"\",IF(C64-C65=0,\"\",C64-C65))","v":""},{"$f":"IF(D64=\"\",\"\",IF(D64-D65=0,\"\",D64-D65))","v":""},null,{"$f":"IF(F64=\"\",\"\",IF(F64-F65=0,\"\",F64-F65))","v":""},{"$f":"IF(G64=\"\",\"\",IF(G64-G65=0,\"\",G64-G65))","v":""},null,{"$f":"IF(I64=\"\",\"\",IF(I64-I65=0,\"\",I64-I65))","v":""},{"$f":"IF(J64=\"\",\"\",IF(J64-J65=0,\"\",J64-J65))","v":""},{"$f":"IF(K64=\"\",\"\",IF(K64-K65=0,\"\",K64-K65))","v":""},{"$f":"SUM(C66:I66)","v":0},{"$f":"M65","v":1}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M66","v":1}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M67","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M70","v":1}]
[{"$f":"\"Week 4: \"&TEXT(C71,\"DD/MM/YYYY\")","v":"Week 4: 12/03/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M71","v":1}]
[null,null,{"$f":"IF(I63=\"\",\"\",I63+3)","v":"2018-03-12"},{"$f":"IF(C71=\"\",\"\",C71+1)","v":"2018-03-13"},null,{"$f":"IF(D71=\"\",\"\",D71+1)","v":"2018-03-14"},{"$f":"IF(F71=\"\",\"\",F71+1)","v":"2018-03-15"},null,{"$f":"IF(G71=\"\",\"\",G71+1)","v":"2018-03-16"},{"$f":"IF(I71=\"\",\"\",I71+1)","v":"2018-03-17"},{"$f":"IF(J71=\"\",\"\",J71+1)","v":"2018-03-18"},null,{"$f":"IF(C71<=$I$41,1,0)","v":1}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C72:I72)","v":0},{"$f":"M71","v":1}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C73:I73)","v":0},{"$f":"M72","v":1}]
["Leave Hours",null,{"$f":"IF(C72=\"\",\"\",IF(C72-C73=0,\"\",C72-C73))","v":""},{"$f":"IF(D72=\"\",\"\",IF(D72-D73=0,\"\",D72-D73))","v":""},null,{"$f":"IF(F72=\"\",\"\",IF(F72-F73=0,\"\",F72-F73))","v":""},{"$f":"IF(G72=\"\",\"\",IF(G72-G73=0,\"\",G72-G73))","v":""},null,{"$f":"IF(I72=\"\",\"\",IF(I72-I73=0,\"\",I72-I73))","v":""},{"$f":"IF(J72=\"\",\"\",IF(J72-J73=0,\"\",J72-J73))","v":""},{"$f":"IF(K72=\"\",\"\",IF(K72-K73=0,\"\",K72-K73))","v":""},{"$f":"SUM(C74:I74)","v":0},{"$f":"M73","v":1}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M74","v":1}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M75","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M78","v":1}]
[{"$f":"\"Week 5: \"&TEXT(C79,\"DD/MM/YYYY\")","v":"Week 5: 19/03/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M79","v":1}]
[null,null,{"$f":"IF(I71=\"\",\"\",I71+3)","v":"2018-03-19"},{"$f":"IF(C79=\"\",\"\",C79+1)","v":"2018-03-20"},null,{"$f":"IF(D79=\"\",\"\",D79+1)","v":"2018-03-21"},{"$f":"IF(F79=\"\",\"\",F79+1)","v":"2018-03-22"},null,{"$f":"IF(G79=\"\",\"\",G79+1)","v":"2018-03-23"},{"$f":"IF(I79=\"\",\"\",I79+1)","v":"2018-03-24"},{"$f":"IF(J79=\"\",\"\",J79+1)","v":"2018-03-25"},null,{"$f":"IF(C79<=$I$41,1,0)","v":1}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C80:I80)","v":0},{"$f":"M79","v":1}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C81:I81)","v":0},{"$f":"M80","v":1}]
["Leave Hours",null,{"$f":"IF(C80=\"\",\"\",IF(C80-C81=0,\"\",C80-C81))","v":""},{"$f":"IF(D80=\"\",\"\",IF(D80-D81=0,\"\",D80-D81))","v":""},null,{"$f":"IF(F80=\"\",\"\",IF(F80-F81=0,\"\",F80-F81))","v":""},{"$f":"IF(G80=\"\",\"\",IF(G80-G81=0,\"\",G80-G81))","v":""},null,{"$f":"IF(I80=\"\",\"\",IF(I80-I81=0,\"\",I80-I81))","v":""},{"$f":"IF(J80=\"\",\"\",IF(J80-J81=0,\"\",J80-J81))","v":""},{"$f":"IF(K80=\"\",\"\",IF(K80-K81=0,\"\",K80-K81))","v":""},{"$f":"SUM(C82:I82)","v":0},{"$f":"M81","v":1}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M82","v":1}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M83","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M86","v":1}]
[{"$f":"\"Week 6: \"&TEXT(C87,\"DD/MM/YYYY\")","v":"Week 6: 26/03/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M87","v":1}]
[null,null,{"$f":"IF(I79=\"\",\"\",I79+3)","v":"2018-03-26"},{"$f":"IF(C87=\"\",\"\",C87+1)","v":"2018-03-27"},null,{"$f":"IF(D87=\"\",\"\",D87+1)","v":"2018-03-28"},{"$f":"IF(F87=\"\",\"\",F87+1)","v":"2018-03-29"},null,{"$f":"IF(G87=\"\",\"\",G87+1)","v":"2018-03-30"},{"$f":"IF(I87=\"\",\"\",I87+1)","v":"2018-03-31"},{"$f":"IF(J87=\"\",\"\",J87+1)","v":"2018-04-01"},null,{"$f":"IF(C87<=$I$41,1,0)","v":1}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C88:I88)","v":0},{"$f":"M87","v":1}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C89:I89)","v":0},{"$f":"M88","v":1}]
["Leave Hours",null,{"$f":"IF(C88=\"\",\"\",IF(C88-C89=0,\"\",C88-C89))","v":""},{"$f":"IF(D88=\"\",\"\",IF(D88-D89=0,\"\",D88-D89))","v":""},null,{"$f":"IF(F88=\"\",\"\",IF(F88-F89=0,\"\",F88-F89))","v":""},{"$f":"IF(G88=\"\",\"\",IF(G88-G89=0,\"\",G88-G89))","v":""},null,{"$f":"IF(I88=\"\",\"\",IF(I88-I89=0,\"\",I88-I89))","v":""},{"$f":"IF(J88=\"\",\"\",IF(J88-J89=0,\"\",J88-J89))","v":""},{"$f":"IF(K88=\"\",\"\",IF(K88-K89=0,\"\",K88-K89))","v":""},{"$f":"SUM(C90:I90)","v":0},{"$f":"M89","v":1}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M90","v":1}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M91","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M94","v":1}]
[{"$f":"\"Week 7: \"&TEXT(C95,\"DD/MM/YYYY\")","v":"Week 7: 02/04/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M95","v":1}]
[null,null,{"$f":"IF(I87=\"\",\"\",I87+3)","v":"2018-04-02"},{"$f":"IF(C95=\"\",\"\",C95+1)","v":"2018-04-03"},null,{"$f":"IF(D95=\"\",\"\",D95+1)","v":"2018-04-04"},{"$f":"IF(F95=\"\",\"\",F95+1)","v":"2018-04-05"},null,{"$f":"IF(G95=\"\",\"\",G95+1)","v":"2018-04-06"},{"$f":"IF(I95=\"\",\"\",I95+1)","v":"2018-04-07"},{"$f":"IF(J95=\"\",\"\",J95+1)","v":"2018-04-08"},null,{"$f":"IF(C95<=$I$41,1,0)","v":1}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C96:I96)","v":0},{"$f":"M95","v":1}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C97:I97)","v":0},{"$f":"M96","v":1}]
["Leave Hours",null,{"$f":"IF(C96=\"\",\"\",IF(C96-C97=0,\"\",C96-C97))","v":""},{"$f":"IF(D96=\"\",\"\",IF(D96-D97=0,\"\",D96-D97))","v":""},null,{"$f":"IF(F96=\"\",\"\",IF(F96-F97=0,\"\",F96-F97))","v":""},{"$f":"IF(G96=\"\",\"\",IF(G96-G97=0,\"\",G96-G97))","v":""},null,{"$f":"IF(I96=\"\",\"\",IF(I96-I97=0,\"\",I96-I97))","v":""},{"$f":"IF(J96=\"\",\"\",IF(J96-J97=0,\"\",J96-J97))","v":""},{"$f":"IF(K96=\"\",\"\",IF(K96-K97=0,\"\",K96-K97))","v":""},{"$f":"SUM(C98:I98)","v":0},{"$f":"M97","v":1}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M98","v":1}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M99","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M102","v":1}]
[{"$f":"\"Week 8: \"&TEXT(C103,\"DD/MM/YYYY\")","v":"Week 8: 09/04/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M103","v":1}]
[null,null,{"$f":"IF(I95=\"\",\"\",I95+3)","v":"2018-04-09"},{"$f":"IF(C103=\"\",\"\",C103+1)","v":"2018-04-10"},null,{"$f":"IF(D103=\"\",\"\",D103+1)","v":"2018-04-11"},{"$f":"IF(F103=\"\",\"\",F103+1)","v":"2018-04-12"},null,{"$f":"IF(G103=\"\",\"\",G103+1)","v":"2018-04-13"},{"$f":"IF(I103=\"\",\"\",I103+1)","v":"2018-04-14"},{"$f":"IF(J103=\"\",\"\",J103+1)","v":"2018-04-15"},null,{"$f":"IF(C103<=$I$41,1,0)","v":1}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C104:I104)","v":0},{"$f":"M103","v":1}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C105:I105)","v":0},{"$f":"M104","v":1}]
["Leave Hours",null,{"$f":"IF(C104=\"\",\"\",IF(C104-C105=0,\"\",C104-C105))","v":""},{"$f":"IF(D104=\"\",\"\",IF(D104-D105=0,\"\",D104-D105))","v":""},null,{"$f":"IF(F104=\"\",\"\",IF(F104-F105=0,\"\",F104-F105))","v":""},{"$f":"IF(G104=\"\",\"\",IF(G104-G105=0,\"\",G104-G105))","v":""},null,{"$f":"IF(I104=\"\",\"\",IF(I104-I105=0,\"\",I104-I105))","v":""},{"$f":"IF(J104=\"\",\"\",IF(J104-J105=0,\"\",J104-J105))","v":""},{"$f":"IF(K104=\"\",\"\",IF(K104-K105=0,\"\",K104-K105))","v":""},{"$f":"SUM(C106:I106)","v":0},{"$f":"M105","v":1}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M106","v":1}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M107","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M110","v":1}]
[{"$f":"\"Week 9: \"&TEXT(C111,\"DD/MM/YYYY\")","v":"Week 9: 16/04/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M111","v":1}]
[null,null,{"$f":"IF(I103=\"\",\"\",I103+3)","v":"2018-04-16"},{"$f":"IF(C111=\"\",\"\",C111+1)","v":"2018-04-17"},null,{"$f":"IF(D111=\"\",\"\",D111+1)","v":"2018-04-18"},{"$f":"IF(F111=\"\",\"\",F111+1)","v":"2018-04-19"},null,{"$f":"IF(G111=\"\",\"\",G111+1)","v":"2018-04-20"},{"$f":"IF(I111=\"\",\"\",I111+1)","v":"2018-04-21"},{"$f":"IF(J111=\"\",\"\",J111+1)","v":"2018-04-22"},null,{"$f":"IF(C111<=$I$41,1,0)","v":1}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C112:I112)","v":0},{"$f":"M111","v":1}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C113:I113)","v":0},{"$f":"M112","v":1}]
["Leave Hours",null,{"$f":"IF(C112=\"\",\"\",IF(C112-C113=0,\"\",C112-C113))","v":""},{"$f":"IF(D112=\"\",\"\",IF(D112-D113=0,\"\",D112-D113))","v":""},null,{"$f":"IF(F112=\"\",\"\",IF(F112-F113=0,\"\",F112-F113))","v":""},{"$f":"IF(G112=\"\",\"\",IF(G112-G113=0,\"\",G112-G113))","v":""},null,{"$f":"IF(I112=\"\",\"\",IF(I112-I113=0,\"\",I112-I113))","v":""},{"$f":"IF(J112=\"\",\"\",IF(J112-J113=0,\"\",J112-J113))","v":""},{"$f":"IF(K112=\"\",\"\",IF(K112-K113=0,\"\",K112-K113))","v":""},{"$f":"SUM(C114:I114)","v":0},{"$f":"M113","v":1}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M114","v":1}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M115","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M118","v":1}]
[{"$f":"\"Week 10: \"&TEXT(C119,\"DD/MM/YYYY\")","v":"Week 10: 23/04/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M119","v":1}]
[null,null,{"$f":"IF(I111=\"\",\"\",I111+3)","v":"2018-04-23"},{"$f":"IF(C119=\"\",\"\",C119+1)","v":"2018-04-24"},null,{"$f":"IF(D119=\"\",\"\",D119+1)","v":"2018-04-25"},{"$f":"IF(F119=\"\",\"\",F119+1)","v":"2018-04-26"},null,{"$f":"IF(G119=\"\",\"\",G119+1)","v":"2018-04-27"},{"$f":"IF(I119=\"\",\"\",I119+1)","v":"2018-04-28"},{"$f":"IF(J119=\"\",\"\",J119+1)","v":"2018-04-29"},null,{"$f":"IF(C119<=$I$41,1,0)","v":1}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C120:I120)","v":0},{"$f":"M119","v":1}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C121:I121)","v":0},{"$f":"M120","v":1}]
["Leave Hours",null,{"$f":"IF(C120=\"\",\"\",IF(C120-C121=0,\"\",C120-C121))","v":""},{"$f":"IF(D120=\"\",\"\",IF(D120-D121=0,\"\",D120-D121))","v":""},null,{"$f":"IF(F120=\"\",\"\",IF(F120-F121=0,\"\",F120-F121))","v":""},{"$f":"IF(G120=\"\",\"\",IF(G120-G121=0,\"\",G120-G121))","v":""},null,{"$f":"IF(I120=\"\",\"\",IF(I120-I121=0,\"\",I120-I121))","v":""},{"$f":"IF(J120=\"\",\"\",IF(J120-J121=0,\"\",J120-J121))","v":""},{"$f":"IF(K120=\"\",\"\",IF(K120-K121=0,\"\",K120-K121))","v":""},{"$f":"SUM(C122:I122)","v":0},{"$f":"M121","v":1}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M122","v":1}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M123","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M126","v":0}]
[{"$f":"\"Week 11: \"&TEXT(C127,\"DD/MM/YYYY\")","v":"Week 11: 30/04/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M127","v":0}]
[null,null,{"$f":"IF(I119=\"\",\"\",I119+3)","v":"2018-04-30"},{"$f":"IF(C127=\"\",\"\",C127+1)","v":"2018-05-01"},null,{"$f":"IF(D127=\"\",\"\",D127+1)","v":"2018-05-02"},{"$f":"IF(F127=\"\",\"\",F127+1)","v":"2018-05-03"},null,{"$f":"IF(G127=\"\",\"\",G127+1)","v":"2018-05-04"},{"$f":"IF(I127=\"\",\"\",I127+1)","v":"2018-05-05"},{"$f":"IF(J127=\"\",\"\",J127+1)","v":"2018-05-06"},null,{"$f":"IF(C127<=$I$41,1,0)","v":0}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C128:I128)","v":0},{"$f":"M127","v":0}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C129:I129)","v":0},{"$f":"M128","v":0}]
["Leave Hours",null,{"$f":"IF(C128=\"\",\"\",IF(C128-C129=0,\"\",C128-C129))","v":""},{"$f":"IF(D128=\"\",\"\",IF(D128-D129=0,\"\",D128-D129))","v":""},null,{"$f":"IF(F128=\"\",\"\",IF(F128-F129=0,\"\",F128-F129))","v":""},{"$f":"IF(G128=\"\",\"\",IF(G128-G129=0,\"\",G128-G129))","v":""},null,{"$f":"IF(I128=\"\",\"\",IF(I128-I129=0,\"\",I128-I129))","v":""},{"$f":"IF(J128=\"\",\"\",IF(J128-J129=0,\"\",J128-J129))","v":""},{"$f":"IF(K128=\"\",\"\",IF(K128-K129=0,\"\",K128-K129))","v":""},{"$f":"SUM(C130:I130)","v":0},{"$f":"M129","v":0}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M130","v":0}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M131","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M134","v":0}]
[{"$f":"\"Week 12: \"&TEXT(C135,\"DD/MM/YYYY\")","v":"Week 12: 07/05/2018"},null,"MON","TUE",null,"WED","THU",null,"FRI","SAT","SUN","TOTAL HOURS",{"$f":"M135","v":0}]
[null,null,{"$f":"IF(I127=\"\",\"\",I127+3)","v":"2018-05-07"},{"$f":"IF(C135=\"\",\"\",C135+1)","v":"2018-05-08"},null,{"$f":"IF(D135=\"\",\"\",D135+1)","v":"2018-05-09"},{"$f":"IF(F135=\"\",\"\",F135+1)","v":"2018-05-10"},null,{"$f":"IF(G135=\"\",\"\",G135+1)","v":"2018-05-11"},{"$f":"IF(I135=\"\",\"\",I135+1)","v":"2018-05-12"},{"$f":"IF(J135=\"\",\"\",J135+1)","v":"2018-05-13"},null,{"$f":"IF(C135<=$I$41,1,0)","v":0}]
["Rostered Hours",null,{"$f":"IF($C$48<>\"\",$C$48,\"\")","v":""},{"$f":"IF($D$48<>\"\",$D$48,\"\")","v":""},null,{"$f":"IF($F$48<>\"\",$F$48,\"\")","v":""},{"$f":"IF($G$48<>\"\",$G$48,\"\")","v":""},null,{"$f":"IF($I$48<>\"\",$I$48,\"\")","v":""},{"$f":"IF($J$48<>\"\",$J$48,\"\")","v":0},{"$f":"IF($K$48<>\"\",$K$48,\"\")","v":0},{"$f":"SUM(C136:I136)","v":0},{"$f":"M135","v":0}]
["RTW Plan Hours",null,{"$f":"IF($C$49<>\"\",$C$49,\"\")","v":""},{"$f":"IF($D$49<>\"\",$D$49,\"\")","v":""},null,{"$f":"IF($F$49<>\"\",$F$49,\"\")","v":""},{"$f":"IF($G$49<>\"\",$G$49,\"\")","v":""},null,{"$f":"IF($I$49<>\"\",$I$49,\"\")","v":""},{"$f":"IF($J$49<>\"\",$J$49,\"\")","v":0},{"$f":"IF($K$49<>\"\",$K$49,\"\")","v":0},{"$f":"SUM(C137:I137)","v":0},{"$f":"M136","v":0}]
["Leave Hours",null,{"$f":"IF(C136=\"\",\"\",IF(C136-C137=0,\"\",C136-C137))","v":""},{"$f":"IF(D136=\"\",\"\",IF(D136-D137=0,\"\",D136-D137))","v":""},null,{"$f":"IF(F136=\"\",\"\",IF(F136-F137=0,\"\",F136-F137))","v":""},{"$f":"IF(G136=\"\",\"\",IF(G136-G137=0,\"\",G136-G137))","v":""},null,{"$f":"IF(I136=\"\",\"\",IF(I136-I137=0,\"\",I136-I137))","v":""},{"$f":"IF(J136=\"\",\"\",IF(J136-J137=0,\"\",J136-J137))","v":""},{"$f":"IF(K136=\"\",\"\",IF(K136-K137=0,\"\",K136-K137))","v":""},{"$f":"SUM(C138:I138)","v":0},{"$f":"M137","v":0}]
["Leave Type",null,{"$f":"IF($C$51<>\"\",$C$51,\"\")","v":""},{"$f":"IF($D$51<>\"\",$D$51,\"\")","v":""},null,{"$f":"IF($F$51<>\"\",$F$51,\"\")","v":""},{"$f":"IF($G$51<>\"\",$G$51,\"\")","v":""},null,{"$f":"IF($I$51<>\"\",$I$51,\"\")","v":""},{"$f":"IF($J$51<>\"\",$J$51,\"\")","v":""},{"$f":"IF($K$51<>\"\",$K$51,\"\")","v":""},null,{"$f":"M138","v":0}]
["DUTIES, RESTRICTIONS & SUPPORTS",null,{"$f":"IF($C$52<>\"\",$C$52,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"M139","v":0}]
[]
["APPROVALS"]
[]
["PERSON","RESPONSIBILITY",null,null,"NAME",null,null,null,"APPROVAL",null,null,"DATE"]
["Employee","I have been consulted about the content of this plan and agree to participate.",null,null,{"$f":"IF(B11=\"\",\"\",IF(ISERROR(RIGHT(B11,LEN(B11)-SEARCH(\",\",B11,1))&\" \"&LEFT(B11,SEARCH(\",\",B11,1)-1)),B11,RIGHT(B11,LEN(B11)-SEARCH(\",\",B11,1))&\" \"&LEFT(B11,SEARCH(\",\",B11,1)-1)))","v":""}]
["Rehab & RTW Coordinator","I agree to monitor this plan.",null,null,{"$f":"IF(B29=\"\",\"\",B29)","v":""}]
["Supervisor","I agree to ensure this plan is implemented in the work area.",null,null,{"$f":"IF(B27=\"\",\"\",B27)","v":""}]
["Medical Practitioner","I approve this plan.",null,null,{"$f":"IF(B31=\"\",\"\",B31)","v":""}]
[]
["N.B If medical condition is aggravated, employee is to contact their Doctor immediately and advise their Rehabilitation and Return to Work Coordinator."]
[]
["Email Address:",{"$f":"IF(B23=\"\",\"\",VLOOKUP(B23,Validation!J:K,2,FALSE)&IF(J23=\"Yes\",\"; \"&Validation!K2,\"\"))","v":""}]
["Subject:",{"$f":"IF(OR(J11=\"\",B11=\"\",F41=\"\"),\"\",\"GRTW Plan for \"&J11&\" - \"&B11&\" \"&TEXT(F41,\"dd/mm/yyyy\"))","v":""}]

{"sheet":"Validation","index":2,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Leave Types",{"$f":"\"Validation!$A$2:$A$\"&COUNTA(A:A)+1","v":"Validation!$A$2:$A$14"},null,"Rehabilitation Goal",{"$f":"\"Validation!$D$2:$D$\"&COUNTA(D:D)","v":"Validation!$D$2:$D$12"},null,"Approval",{"$f":"\"Validation!$G$2:$G$\"&COUNTA(G:G)","v":"Validation!$G$2:$G$5"},null,"Claims Office","Email Address",{"$f":"\"Validation!$J$3:$J$\"&COUNTA(J:J)","v":"Validation!$J$3:$J$14"},null,"Validation on Submit"]
[null,null,null,"Maintain at work",null,null,null,{"$f":"\"Validation!$G$2:$G$\"&COUNTA(G:G)+1","v":"Validation!$G$2:$G$6"},null,"Cleaners","claimsmanagement.strathr@det.qld.gov.au",null,null,"Employee Name is incomplete.",{"$f":"IF(LEN('GRTW Plan'!B11)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
["WorkCover - paid",null,null,"Maintain at work with reasonable adjustment",null,null,"email confirmation",null,null,"Central Office","claimsmanagement.CO@det.qld.gov.au",null,null,"Employee Number is incomplete.",{"$f":"IF(LEN('GRTW Plan'!J11)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
["WorkCover - no pay",null,null,"Return to pre-injury duties with DoE full time",null,null,"signature provided",null,null,"Central Queensland","claimsmanagement.CQR@det.qld.gov.au",null,null,"Medical Condition is incomplete.",{"$f":"IF(LEN('GRTW Plan'!B15)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
["QSuper",null,null,"Return to pre-injury duties with DoE part time",null,null,"verbal confirmation",null,null,"Darling Downs and South West","claimsmanagement.DDSWQ@det.qld.gov.au",null,null,"Funding Source is incomplete.",{"$f":"IF(LEN('GRTW Plan'!J15)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
["Sick Leave",null,null,"Return to modified duties with DoE full time",null,null,"medical certificate provided",null,null,"Far North Queensland","claimsmanagement.farnthqld@det.qld.gov.au",null,null,"Rostered Hours is incomplete.",{"$f":"IF(LEN('GRTW Plan'!B17)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
["Recreation - Full Pay",null,null,"Return to modified duties with DoE part time",null,null,null,null,null,"Metropolitan - North","claimsmanagement.MetroNTH@det.qld.gov.au",null,null,"RTW Location is incomplete.",{"$f":"IF(LEN('GRTW Plan'!B21)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
["Recreation - Half Pay",null,null,"Return to pre-injury duties with different employer full time",null,null,null,null,null,"Metropolitan - South","claimsmanagement.MetroSTH@det.qld.gov.au",null,null,"Claims Office is incomplete.",{"$f":"IF(LEN('GRTW Plan'!B23)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
["Annual Leave",null,null,"Return to pre-injury duties with different employer part time",null,null,null,null,null,"Metropolitan - West","claimsmanagement.MetroWST@det.qld.gov.au",null,null,"Supervisor details are incomplete.",{"$f":"IF(OR(LEN('GRTW Plan'!B27)=0,LEN('GRTW Plan'!G27)=0,LEN('GRTW Plan'!J27)=0),\"ERROR\",\"OK\")","v":"ERROR"}]
["Long Service - Full Pay",null,null,"Return to modified duties with different employer full time",null,null,null,null,null,"North Coast - Maroochydore","claimsmanagement.Nambour@det.qld.gov.au",null,null,"Rehab & RTW Coordinator details are incomplete.",{"$f":"IF(OR(LEN('GRTW Plan'!B29)=0,LEN('GRTW Plan'!G29)=0,LEN('GRTW Plan'!J29)=0),\"ERROR\",\"OK\")","v":"ERROR"}]
["Long Service - Half Pay",null,null,"Return to modified duties with different employer part time",null,null,null,null,null,"North Coast - Maryborough","claimsmanagement.WBB@det.qld.gov.au",null,null,"Medical Practitioner details are incomplete.",{"$f":"IF(OR(LEN('GRTW Plan'!B31)=0,LEN('GRTW Plan'!G31)=0),\"ERROR\",\"OK\")","v":"ERROR"}]
["Special Leave - no pay",null,null,"Other",null,null,null,null,null,"North Coast - North Lakes","claimsmanagement.suncoast_SS@det.qld.gov.au",null,null,"Long Term Goal is incomplete.",{"$f":"IF(LEN('GRTW Plan'!B35)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
["Public Holiday",null,null,null,null,null,null,null,null,"North Queensland","claimsmanagement.NTHQLD@det.qld.gov.au",null,null,"Objective of this Plan is incomplete.",{"$f":"IF(LEN('GRTW Plan'!B37)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
["ADO",null,null,null,null,null,null,null,null,"South East","claimsmanagement.southcoast@det.qld.gov.au",null,null,"Original Commencement Date for RTW is incomplete.",{"$f":"IF(LEN('GRTW Plan'!D39)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Date is incomplete.",{"$f":"IF(LEN('GRTW Plan'!F41)=0,\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"End Date is incomplete.",{"$f":"IF(LEN('GRTW Plan'!I41)=0,\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan Review Date is incomplete.",{"$f":"IF(LEN('GRTW Plan'!B43)=0,\"ERROR\",\"OK\")","v":"ERROR"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 1 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C50)<>0,LEN('GRTW Plan'!C51)=0),AND(LEN('GRTW Plan'!D50)<>0,LEN('GRTW Plan'!D51)=0),AND(LEN('GRTW Plan'!F50)<>0,LEN('GRTW Plan'!F51)=0),AND(LEN('GRTW Plan'!G50)<>0,LEN('GRTW Plan'!G51)=0),AND(LEN('GRTW Plan'!I50)<>0,LEN('GRTW Plan'!I51)=0),AND(LEN('GRTW Plan'!J50)<>0,LEN('GRTW Plan'!J51)=0),AND(LEN('GRTW Plan'!K50)<>0,LEN('GRTW Plan'!K51)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 2 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C58)<>0,LEN('GRTW Plan'!C59)=0),AND(LEN('GRTW Plan'!D58)<>0,LEN('GRTW Plan'!D59)=0),AND(LEN('GRTW Plan'!F58)<>0,LEN('GRTW Plan'!F59)=0),AND(LEN('GRTW Plan'!G58)<>0,LEN('GRTW Plan'!G59)=0),AND(LEN('GRTW Plan'!I58)<>0,LEN('GRTW Plan'!I59)=0),AND(LEN('GRTW Plan'!J58)<>0,LEN('GRTW Plan'!J59)=0),AND(LEN('GRTW Plan'!K58)<>0,LEN('GRTW Plan'!K59)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 3 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C66)<>0,LEN('GRTW Plan'!C67)=0),AND(LEN('GRTW Plan'!D66)<>0,LEN('GRTW Plan'!D67)=0),AND(LEN('GRTW Plan'!F66)<>0,LEN('GRTW Plan'!F67)=0),AND(LEN('GRTW Plan'!G66)<>0,LEN('GRTW Plan'!G67)=0),AND(LEN('GRTW Plan'!I66)<>0,LEN('GRTW Plan'!I67)=0),AND(LEN('GRTW Plan'!J66)<>0,LEN('GRTW Plan'!J67)=0),AND(LEN('GRTW Plan'!K66)<>0,LEN('GRTW Plan'!K67)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 4 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C74)<>0,LEN('GRTW Plan'!C75)=0),AND(LEN('GRTW Plan'!D74)<>0,LEN('GRTW Plan'!D75)=0),AND(LEN('GRTW Plan'!F74)<>0,LEN('GRTW Plan'!F75)=0),AND(LEN('GRTW Plan'!G74)<>0,LEN('GRTW Plan'!G75)=0),AND(LEN('GRTW Plan'!I74)<>0,LEN('GRTW Plan'!I75)=0),AND(LEN('GRTW Plan'!J74)<>0,LEN('GRTW Plan'!J75)=0),AND(LEN('GRTW Plan'!K74)<>0,LEN('GRTW Plan'!K75)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 5 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C82)<>0,LEN('GRTW Plan'!C83)=0),AND(LEN('GRTW Plan'!D82)<>0,LEN('GRTW Plan'!D83)=0),AND(LEN('GRTW Plan'!F82)<>0,LEN('GRTW Plan'!F83)=0),AND(LEN('GRTW Plan'!G82)<>0,LEN('GRTW Plan'!G83)=0),AND(LEN('GRTW Plan'!I82)<>0,LEN('GRTW Plan'!I83)=0),AND(LEN('GRTW Plan'!J82)<>0,LEN('GRTW Plan'!J83)=0),AND(LEN('GRTW Plan'!K82)<>0,LEN('GRTW Plan'!K83)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 6 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C90)<>0,LEN('GRTW Plan'!C91)=0),AND(LEN('GRTW Plan'!D90)<>0,LEN('GRTW Plan'!D91)=0),AND(LEN('GRTW Plan'!F90)<>0,LEN('GRTW Plan'!F91)=0),AND(LEN('GRTW Plan'!G90)<>0,LEN('GRTW Plan'!G91)=0),AND(LEN('GRTW Plan'!I90)<>0,LEN('GRTW Plan'!I91)=0),AND(LEN('GRTW Plan'!J90)<>0,LEN('GRTW Plan'!J91)=0),AND(LEN('GRTW Plan'!K90)<>0,LEN('GRTW Plan'!K91)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 7 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C98)<>0,LEN('GRTW Plan'!C99)=0),AND(LEN('GRTW Plan'!D98)<>0,LEN('GRTW Plan'!D99)=0),AND(LEN('GRTW Plan'!F98)<>0,LEN('GRTW Plan'!F99)=0),AND(LEN('GRTW Plan'!G98)<>0,LEN('GRTW Plan'!G99)=0),AND(LEN('GRTW Plan'!I98)<>0,LEN('GRTW Plan'!I99)=0),AND(LEN('GRTW Plan'!J98)<>0,LEN('GRTW Plan'!J99)=0),AND(LEN('GRTW Plan'!K98)<>0,LEN('GRTW Plan'!K99)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 8 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C106)<>0,LEN('GRTW Plan'!C107)=0),AND(LEN('GRTW Plan'!D106)<>0,LEN('GRTW Plan'!D107)=0),AND(LEN('GRTW Plan'!F106)<>0,LEN('GRTW Plan'!F107)=0),AND(LEN('GRTW Plan'!G106)<>0,LEN('GRTW Plan'!G107)=0),AND(LEN('GRTW Plan'!I106)<>0,LEN('GRTW Plan'!I107)=0),AND(LEN('GRTW Plan'!J106)<>0,LEN('GRTW Plan'!J107)=0),AND(LEN('GRTW Plan'!K106)<>0,LEN('GRTW Plan'!K107)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 9 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C114)<>0,LEN('GRTW Plan'!C115)=0),AND(LEN('GRTW Plan'!D114)<>0,LEN('GRTW Plan'!D115)=0),AND(LEN('GRTW Plan'!F114)<>0,LEN('GRTW Plan'!F115)=0),AND(LEN('GRTW Plan'!G114)<>0,LEN('GRTW Plan'!G115)=0),AND(LEN('GRTW Plan'!I114)<>0,LEN('GRTW Plan'!I115)=0),AND(LEN('GRTW Plan'!J114)<>0,LEN('GRTW Plan'!J115)=0),AND(LEN('GRTW Plan'!K114)<>0,LEN('GRTW Plan'!K115)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 10 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C122)<>0,LEN('GRTW Plan'!C123)=0),AND(LEN('GRTW Plan'!D122)<>0,LEN('GRTW Plan'!D123)=0),AND(LEN('GRTW Plan'!F122)<>0,LEN('GRTW Plan'!F123)=0),AND(LEN('GRTW Plan'!G122)<>0,LEN('GRTW Plan'!G123)=0),AND(LEN('GRTW Plan'!I122)<>0,LEN('GRTW Plan'!I123)=0),AND(LEN('GRTW Plan'!J122)<>0,LEN('GRTW Plan'!J123)=0),AND(LEN('GRTW Plan'!K122)<>0,LEN('GRTW Plan'!K123)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 11 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C130)<>0,LEN('GRTW Plan'!C131)=0),AND(LEN('GRTW Plan'!D130)<>0,LEN('GRTW Plan'!D131)=0),AND(LEN('GRTW Plan'!F130)<>0,LEN('GRTW Plan'!F131)=0),AND(LEN('GRTW Plan'!G130)<>0,LEN('GRTW Plan'!G131)=0),AND(LEN('GRTW Plan'!I130)<>0,LEN('GRTW Plan'!I131)=0),AND(LEN('GRTW Plan'!J130)<>0,LEN('GRTW Plan'!J131)=0),AND(LEN('GRTW Plan'!K130)<>0,LEN('GRTW Plan'!K131)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Week 12 Leave Type Used is incomplete.",{"$f":"IF(OR(AND(LEN('GRTW Plan'!C138)<>0,LEN('GRTW Plan'!C139)=0),AND(LEN('GRTW Plan'!D138)<>0,LEN('GRTW Plan'!D139)=0),AND(LEN('GRTW Plan'!F138)<>0,LEN('GRTW Plan'!F139)=0),AND(LEN('GRTW Plan'!G138)<>0,LEN('GRTW Plan'!G139)=0),AND(LEN('GRTW Plan'!I138)<>0,LEN('GRTW Plan'!I139)=0),AND(LEN('GRTW Plan'!J138)<>0,LEN('GRTW Plan'!J139)=0),AND(LEN('GRTW Plan'!K138)<>0,LEN('GRTW Plan'!K139)=0)),\"ERROR\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Approvals section is incomplete.",{"$f":"IF(OR(LEN('GRTW Plan'!I145)=0,LEN('GRTW Plan'!I146)=0,LEN('GRTW Plan'!I147)=0,LEN('GRTW Plan'!I148)=0),\"ERROR\",\"OK\")","v":"ERROR"}]

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