{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Help","Days","Macro","Calculator","WPRR","Sheet1"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":13,"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":"Help","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"WPRR Calculator Instructions  ."]
[]
[null,"COMPLETING CALCULATOR"]
[]
[]
[null,"NOTE: Macros must be enabled for this calculator to work.\n"]
[null,"Shaded Cells: You only need to enter information into the grey shaded cells.\n"]
[null,"Employer Name / Employer ABN / Location Number / WorkCover Registration Number: Must be per registration details with ReturnToWorkSA."]
[null,"Worker Name / Claim Number / Date of Injury: Can all be located on the latest claim determination letter(s).\n"]
[null,"Date of First Incapacity: This date is the first day where the injured worker was medically certified with an incapacity for work. This is most commonly the date income maintenance was first paid on the claim and should be noted on the initial claim determination letter.\n"]
[null,"Notional Weekly Earnings (NWE): Enter the NWE for the determination period that covers the \"Week Starting\".\n"]
[null,"Normal Hours Worked Per Week: This is the base hours the injured worker is employed for. This is usually 38 or 40 hours per week for a full time employee.\n"]
[null,"Week Starting:  This is the first date in the pay cycle you are claiming for.  This date cannot be prior to 1/07/2015. \n"]
[null,"No of Weeks: You can enter up to 5 weeks at a time into the calculator.  The more weeks that are selected, the further the pre-filled dates will be displayed.\n"]
[null,"Agreed Pay Cycle Start Date: This is the pay cycle that you have entered into an agreement with Gallagher Bassett to pay the worker.  This may be, for example, from Thursday to Wednesday, or Monday to Sunday.  You must enter the start day here.\n"]
[]
[null,"Date / Weekday: These will prefill, based on the date you have entered in \"week starting\".  This can be any date; however the first \"week day\" must match the day you have entered in the \"Agreed Pay Cycle Start Date\".\n"]
[null,"Hours Worked:  If the worker has completed any hours of work, this must be entered into each applicable day.  The hours must include their base hours, overtime and any personal leave. Do not include annual leave (etc.) hours in this field.\n"]
[null,"Earning from Paid Employment:  An amount must be entered (excluding zero) for every day in the period that a the worker has received earning for hours completed. Any amounts entered that are in periods the worker was not entitled to income support will be disregarded.\n"]
[null,"Nil Earnings from Employment for Week: If the worker has not worked for the week, you can tick this box and it will complete the reimbursement information on the WPRR form.  If you have entered earnings and also tick this box, the \"nil earning\" will be displayed.\n"]
[null,"NOTES"]
[null,"\nIf the First Date of Incapacity occurs in the first week that is being submitted for a reimbursement request, the Estimated Reimbursement amount for this week may not be accurate and should be noted as an estimate only.\n"]
[null,"If an anniversary of the First Date of Incapacity falls within the period that a reimbursement request is being submitted for, the Estimated Reimbursement amount for the week that includes this anniversary may not be accurate and should be noted as an estimate only.\n"]
[null,"SUBMITTING WPRR"]
[]
[null,"If you wish to submit the WPRR via email, you can simply click on the \"Email to GB\" button at the top of the WPRR tab.  This will attach the workbook to an email, addressed to the Gallagher Bassett WPRR inbox.  Please remember to attach any payslips to this email as evidence, prior to sending it."]

{"sheet":"Days","index":1,"n_rows":916,"n_cols":2,"rows_kept":916,"cut":false,"hidden":true,"merged":[]}
["2015-07-01","Wednesday"]
["2015-07-02","Thursday"]
["2015-07-03","Friday"]
["2015-07-04","Saturday"]
["2015-07-05","Sunday"]
["2015-07-06","Monday"]
["2015-07-07","Tuesday"]
["2015-07-08","Wednesday"]
["2015-07-09","Thursday"]
["2015-07-10","Friday"]
["2015-07-11","Saturday"]
["2015-07-12","Sunday"]
["2015-07-13","Monday"]
["2015-07-14","Tuesday"]
["2015-07-15","Wednesday"]
["2015-07-16","Thursday"]
["2015-07-17","Friday"]
["2015-07-18","Saturday"]
["2015-07-19","Sunday"]
["2015-07-20","Monday"]
["2015-07-21","Tuesday"]
["2015-07-22","Wednesday"]
["2015-07-23","Thursday"]
["2015-07-24","Friday"]
["2015-07-25","Saturday"]
["2015-07-26","Sunday"]
["2015-07-27","Monday"]
["2015-07-28","Tuesday"]
["2015-07-29","Wednesday"]
["2015-07-30","Thursday"]
["2015-07-31","Friday"]
["2015-08-01","Saturday"]
["2015-08-02","Sunday"]
["2015-08-03","Monday"]
["2015-08-04","Tuesday"]
["2015-08-05","Wednesday"]
["2015-08-06","Thursday"]
["2015-08-07","Friday"]
["2015-08-08","Saturday"]
["2015-08-09","Sunday"]
["2015-08-10","Monday"]
["2015-08-11","Tuesday"]
["2015-08-12","Wednesday"]
["2015-08-13","Thursday"]
["2015-08-14","Friday"]
["2015-08-15","Saturday"]
["2015-08-16","Sunday"]
["2015-08-17","Monday"]
["2015-08-18","Tuesday"]
["2015-08-19","Wednesday"]
["2015-08-20","Thursday"]
["2015-08-21","Friday"]
["2015-08-22","Saturday"]
["2015-08-23","Sunday"]
["2015-08-24","Monday"]
["2015-08-25","Tuesday"]
["2015-08-26","Wednesday"]
["2015-08-27","Thursday"]
["2015-08-28","Friday"]
["2015-08-29","Saturday"]
["2015-08-30","Sunday"]
["2015-08-31","Monday"]
["2015-09-01","Tuesday"]
["2015-09-02","Wednesday"]
["2015-09-03","Thursday"]
["2015-09-04","Friday"]
["2015-09-05","Saturday"]
["2015-09-06","Sunday"]
["2015-09-07","Monday"]
["2015-09-08","Tuesday"]
["2015-09-09","Wednesday"]
["2015-09-10","Thursday"]
["2015-09-11","Friday"]
["2015-09-12","Saturday"]
["2015-09-13","Sunday"]
["2015-09-14","Monday"]
["2015-09-15","Tuesday"]
["2015-09-16","Wednesday"]
["2015-09-17","Thursday"]
["2015-09-18","Friday"]
["2015-09-19","Saturday"]
["2015-09-20","Sunday"]
["2015-09-21","Monday"]
["2015-09-22","Tuesday"]
["2015-09-23","Wednesday"]
["2015-09-24","Thursday"]
["2015-09-25","Friday"]
["2015-09-26","Saturday"]
["2015-09-27","Sunday"]
["2015-09-28","Monday"]
["2015-09-29","Tuesday"]
["2015-09-30","Wednesday"]
["2015-10-01","Thursday"]
["2015-10-02","Friday"]
["2015-10-03","Saturday"]
["2015-10-04","Sunday"]
["2015-10-05","Monday"]
["2015-10-06","Tuesday"]
["2015-10-07","Wednesday"]
["2015-10-08","Thursday"]
["2015-10-09","Friday"]
["2015-10-10","Saturday"]
["2015-10-11","Sunday"]
["2015-10-12","Monday"]
["2015-10-13","Tuesday"]
["2015-10-14","Wednesday"]
["2015-10-15","Thursday"]
["2015-10-16","Friday"]
["2015-10-17","Saturday"]
["2015-10-18","Sunday"]
["2015-10-19","Monday"]
["2015-10-20","Tuesday"]
["2015-10-21","Wednesday"]
["2015-10-22","Thursday"]
["2015-10-23","Friday"]
["2015-10-24","Saturday"]
["2015-10-25","Sunday"]
["2015-10-26","Monday"]
["2015-10-27","Tuesday"]
["2015-10-28","Wednesday"]
["2015-10-29","Thursday"]
["2015-10-30","Friday"]
["2015-10-31","Saturday"]
["2015-11-01","Sunday"]
["2015-11-02","Monday"]
["2015-11-03","Tuesday"]
["2015-11-04","Wednesday"]
["2015-11-05","Thursday"]
["2015-11-06","Friday"]
["2015-11-07","Saturday"]
["2015-11-08","Sunday"]
["2015-11-09","Monday"]
["2015-11-10","Tuesday"]
["2015-11-11","Wednesday"]
["2015-11-12","Thursday"]
["2015-11-13","Friday"]
["2015-11-14","Saturday"]
["2015-11-15","Sunday"]
["2015-11-16","Monday"]
["2015-11-17","Tuesday"]
["2015-11-18","Wednesday"]
["2015-11-19","Thursday"]
["2015-11-20","Friday"]
["2015-11-21","Saturday"]
["2015-11-22","Sunday"]
["2015-11-23","Monday"]
["2015-11-24","Tuesday"]
["2015-11-25","Wednesday"]
["2015-11-26","Thursday"]
["2015-11-27","Friday"]
["2015-11-28","Saturday"]
["2015-11-29","Sunday"]
["2015-11-30","Monday"]
["2015-12-01","Tuesday"]
["2015-12-02","Wednesday"]
["2015-12-03","Thursday"]
["2015-12-04","Friday"]
["2015-12-05","Saturday"]
["2015-12-06","Sunday"]
["2015-12-07","Monday"]
["2015-12-08","Tuesday"]
["2015-12-09","Wednesday"]
["2015-12-10","Thursday"]
["2015-12-11","Friday"]
["2015-12-12","Saturday"]
["2015-12-13","Sunday"]
["2015-12-14","Monday"]
["2015-12-15","Tuesday"]
["2015-12-16","Wednesday"]
["2015-12-17","Thursday"]
["2015-12-18","Friday"]
["2015-12-19","Saturday"]
["2015-12-20","Sunday"]
["2015-12-21","Monday"]
["2015-12-22","Tuesday"]
["2015-12-23","Wednesday"]
["2015-12-24","Thursday"]
["2015-12-25","Friday"]
["2015-12-26","Saturday"]
["2015-12-27","Sunday"]
["2015-12-28","Monday"]
["2015-12-29","Tuesday"]
["2015-12-30","Wednesday"]
["2015-12-31","Thursday"]
["2016-01-01","Friday"]
["2016-01-02","Saturday"]
["2016-01-03","Sunday"]
["2016-01-04","Monday"]
["2016-01-05","Tuesday"]
["2016-01-06","Wednesday"]
["2016-01-07","Thursday"]
["2016-01-08","Friday"]
["2016-01-09","Saturday"]
["2016-01-10","Sunday"]
["2016-01-11","Monday"]
["2016-01-12","Tuesday"]
["2016-01-13","Wednesday"]
["2016-01-14","Thursday"]
["2016-01-15","Friday"]
["2016-01-16","Saturday"]
["2016-01-17","Sunday"]
["2016-01-18","Monday"]
["2016-01-19","Tuesday"]
["2016-01-20","Wednesday"]
["2016-01-21","Thursday"]
["2016-01-22","Friday"]
["2016-01-23","Saturday"]
["2016-01-24","Sunday"]
["2016-01-25","Monday"]
["2016-01-26","Tuesday"]
["2016-01-27","Wednesday"]
["2016-01-28","Thursday"]
["2016-01-29","Friday"]
["2016-01-30","Saturday"]
["2016-01-31","Sunday"]
["2016-02-01","Monday"]
["2016-02-02","Tuesday"]
["2016-02-03","Wednesday"]
["2016-02-04","Thursday"]
["2016-02-05","Friday"]
["2016-02-06","Saturday"]
["2016-02-07","Sunday"]
["2016-02-08","Monday"]
["2016-02-09","Tuesday"]
["2016-02-10","Wednesday"]
["2016-02-11","Thursday"]
["2016-02-12","Friday"]
["2016-02-13","Saturday"]
["2016-02-14","Sunday"]
["2016-02-15","Monday"]
["2016-02-16","Tuesday"]
["2016-02-17","Wednesday"]
["2016-02-18","Thursday"]
["2016-02-19","Friday"]
["2016-02-20","Saturday"]
["2016-02-21","Sunday"]
["2016-02-22","Monday"]
["2016-02-23","Tuesday"]
["2016-02-24","Wednesday"]
["2016-02-25","Thursday"]
["2016-02-26","Friday"]
["2016-02-27","Saturday"]
["2016-02-28","Sunday"]
["2016-02-29","Monday"]
["2016-03-01","Tuesday"]
["2016-03-02","Wednesday"]
["2016-03-03","Thursday"]
["2016-03-04","Friday"]
["2016-03-05","Saturday"]
["2016-03-06","Sunday"]
["2016-03-07","Monday"]
["2016-03-08","Tuesday"]
["2016-03-09","Wednesday"]
["2016-03-10","Thursday"]
["2016-03-11","Friday"]
["2016-03-12","Saturday"]
["2016-03-13","Sunday"]
["2016-03-14","Monday"]
["2016-03-15","Tuesday"]
["2016-03-16","Wednesday"]
["2016-03-17","Thursday"]
["2016-03-18","Friday"]
["2016-03-19","Saturday"]
["2016-03-20","Sunday"]
["2016-03-21","Monday"]
["2016-03-22","Tuesday"]
["2016-03-23","Wednesday"]
["2016-03-24","Thursday"]
["2016-03-25","Friday"]
["2016-03-26","Saturday"]
["2016-03-27","Sunday"]
["2016-03-28","Monday"]
["2016-03-29","Tuesday"]
["2016-03-30","Wednesday"]
["2016-03-31","Thursday"]
["2016-04-01","Friday"]
["2016-04-02","Saturday"]
["2016-04-03","Sunday"]
["2016-04-04","Monday"]
["2016-04-05","Tuesday"]
["2016-04-06","Wednesday"]
["2016-04-07","Thursday"]
["2016-04-08","Friday"]
["2016-04-09","Saturday"]
["2016-04-10","Sunday"]
["2016-04-11","Monday"]
["2016-04-12","Tuesday"]
["2016-04-13","Wednesday"]
["2016-04-14","Thursday"]
["2016-04-15","Friday"]
["2016-04-16","Saturday"]
["2016-04-17","Sunday"]
["2016-04-18","Monday"]
["2016-04-19","Tuesday"]
["2016-04-20","Wednesday"]
["2016-04-21","Thursday"]
["2016-04-22","Friday"]
["2016-04-23","Saturday"]
["2016-04-24","Sunday"]
["2016-04-25","Monday"]
["2016-04-26","Tuesday"]
["2016-04-27","Wednesday"]
["2016-04-28","Thursday"]
["2016-04-29","Friday"]
["2016-04-30","Saturday"]
["2016-05-01","Sunday"]
["2016-05-02","Monday"]
["2016-05-03","Tuesday"]
["2016-05-04","Wednesday"]
["2016-05-05","Thursday"]
["2016-05-06","Friday"]
["2016-05-07","Saturday"]
["2016-05-08","Sunday"]
["2016-05-09","Monday"]
["2016-05-10","Tuesday"]
["2016-05-11","Wednesday"]
["2016-05-12","Thursday"]
["2016-05-13","Friday"]
["2016-05-14","Saturday"]
["2016-05-15","Sunday"]
["2016-05-16","Monday"]
["2016-05-17","Tuesday"]
["2016-05-18","Wednesday"]
["2016-05-19","Thursday"]
["2016-05-20","Friday"]
["2016-05-21","Saturday"]
["2016-05-22","Sunday"]
["2016-05-23","Monday"]
["2016-05-24","Tuesday"]
["2016-05-25","Wednesday"]
["2016-05-26","Thursday"]
["2016-05-27","Friday"]
["2016-05-28","Saturday"]
["2016-05-29","Sunday"]
["2016-05-30","Monday"]
["2016-05-31","Tuesday"]
["2016-06-01","Wednesday"]
["2016-06-02","Thursday"]
["2016-06-03","Friday"]
["2016-06-04","Saturday"]
["2016-06-05","Sunday"]
["2016-06-06","Monday"]
["2016-06-07","Tuesday"]
["2016-06-08","Wednesday"]
["2016-06-09","Thursday"]
["2016-06-10","Friday"]
["2016-06-11","Saturday"]
["2016-06-12","Sunday"]
["2016-06-13","Monday"]
["2016-06-14","Tuesday"]
["2016-06-15","Wednesday"]
["2016-06-16","Thursday"]
["2016-06-17","Friday"]
["2016-06-18","Saturday"]
["2016-06-19","Sunday"]
["2016-06-20","Monday"]
["2016-06-21","Tuesday"]
["2016-06-22","Wednesday"]
["2016-06-23","Thursday"]
["2016-06-24","Friday"]
["2016-06-25","Saturday"]
["2016-06-26","Sunday"]
["2016-06-27","Monday"]
["2016-06-28","Tuesday"]
["2016-06-29","Wednesday"]
["2016-06-30","Thursday"]
["2016-07-01","Friday"]
["2016-07-02","Saturday"]
["2016-07-03","Sunday"]
["2016-07-04","Monday"]
["2016-07-05","Tuesday"]
["2016-07-06","Wednesday"]
["2016-07-07","Thursday"]
["2016-07-08","Friday"]
["2016-07-09","Saturday"]
["2016-07-10","Sunday"]
["2016-07-11","Monday"]
["2016-07-12","Tuesday"]
["2016-07-13","Wednesday"]
["2016-07-14","Thursday"]
["2016-07-15","Friday"]
["2016-07-16","Saturday"]
["2016-07-17","Sunday"]
["2016-07-18","Monday"]
["2016-07-19","Tuesday"]
["2016-07-20","Wednesday"]
["2016-07-21","Thursday"]
["2016-07-22","Friday"]
["2016-07-23","Saturday"]
["2016-07-24","Sunday"]
["2016-07-25","Monday"]
["2016-07-26","Tuesday"]
["2016-07-27","Wednesday"]
["2016-07-28","Thursday"]
["2016-07-29","Friday"]
["2016-07-30","Saturday"]
["2016-07-31","Sunday"]
["2016-08-01","Monday"]
["2016-08-02","Tuesday"]
["2016-08-03","Wednesday"]
["2016-08-04","Thursday"]
["2016-08-05","Friday"]
["2016-08-06","Saturday"]
["2016-08-07","Sunday"]
["2016-08-08","Monday"]
["2016-08-09","Tuesday"]
["2016-08-10","Wednesday"]
["2016-08-11","Thursday"]
["2016-08-12","Friday"]
["2016-08-13","Saturday"]
["2016-08-14","Sunday"]
["2016-08-15","Monday"]
["2016-08-16","Tuesday"]
["2016-08-17","Wednesday"]
["2016-08-18","Thursday"]
["2016-08-19","Friday"]
["2016-08-20","Saturday"]
["2016-08-21","Sunday"]
["2016-08-22","Monday"]
["2016-08-23","Tuesday"]
["2016-08-24","Wednesday"]
["2016-08-25","Thursday"]
["2016-08-26","Friday"]
["2016-08-27","Saturday"]
["2016-08-28","Sunday"]
["2016-08-29","Monday"]
["2016-08-30","Tuesday"]
["2016-08-31","Wednesday"]
["2016-09-01","Thursday"]
["2016-09-02","Friday"]
["2016-09-03","Saturday"]
["2016-09-04","Sunday"]
["2016-09-05","Monday"]
["2016-09-06","Tuesday"]
["2016-09-07","Wednesday"]
["2016-09-08","Thursday"]
["2016-09-09","Friday"]
["2016-09-10","Saturday"]
["2016-09-11","Sunday"]
["2016-09-12","Monday"]
["2016-09-13","Tuesday"]
["2016-09-14","Wednesday"]
["2016-09-15","Thursday"]
["2016-09-16","Friday"]
["2016-09-17","Saturday"]
["2016-09-18","Sunday"]
["2016-09-19","Monday"]
["2016-09-20","Tuesday"]
["2016-09-21","Wednesday"]
["2016-09-22","Thursday"]
["2016-09-23","Friday"]
["2016-09-24","Saturday"]
["2016-09-25","Sunday"]
["2016-09-26","Monday"]
["2016-09-27","Tuesday"]
["2016-09-28","Wednesday"]
["2016-09-29","Thursday"]
["2016-09-30","Friday"]
["2016-10-01","Saturday"]
["2016-10-02","Sunday"]
["2016-10-03","Monday"]
["2016-10-04","Tuesday"]
["2016-10-05","Wednesday"]
["2016-10-06","Thursday"]
["2016-10-07","Friday"]
["2016-10-08","Saturday"]
["2016-10-09","Sunday"]
["2016-10-10","Monday"]
["2016-10-11","Tuesday"]
["2016-10-12","Wednesday"]
["2016-10-13","Thursday"]
["2016-10-14","Friday"]
["2016-10-15","Saturday"]
["2016-10-16","Sunday"]
["2016-10-17","Monday"]
["2016-10-18","Tuesday"]
["2016-10-19","Wednesday"]
["2016-10-20","Thursday"]
["2016-10-21","Friday"]
["2016-10-22","Saturday"]
["2016-10-23","Sunday"]
["2016-10-24","Monday"]
["2016-10-25","Tuesday"]
["2016-10-26","Wednesday"]
["2016-10-27","Thursday"]
["2016-10-28","Friday"]
["2016-10-29","Saturday"]
["2016-10-30","Sunday"]
["2016-10-31","Monday"]
["2016-11-01","Tuesday"]
["2016-11-02","Wednesday"]
["2016-11-03","Thursday"]
["2016-11-04","Friday"]
["2016-11-05","Saturday"]
["2016-11-06","Sunday"]
["2016-11-07","Monday"]
["2016-11-08","Tuesday"]
["2016-11-09","Wednesday"]
["2016-11-10","Thursday"]
["2016-11-11","Friday"]
["2016-11-12","Saturday"]
["2016-11-13","Sunday"]
["2016-11-14","Monday"]
["2016-11-15","Tuesday"]
["2016-11-16","Wednesday"]
["2016-11-17","Thursday"]
["2016-11-18","Friday"]
["2016-11-19","Saturday"]
["2016-11-20","Sunday"]
["2016-11-21","Monday"]
["2016-11-22","Tuesday"]
["2016-11-23","Wednesday"]
["2016-11-24","Thursday"]
["2016-11-25","Friday"]
["2016-11-26","Saturday"]
["2016-11-27","Sunday"]
["2016-11-28","Monday"]
["2016-11-29","Tuesday"]
["2016-11-30","Wednesday"]
["2016-12-01","Thursday"]
["2016-12-02","Friday"]
["2016-12-03","Saturday"]
["2016-12-04","Sunday"]
["2016-12-05","Monday"]
["2016-12-06","Tuesday"]
["2016-12-07","Wednesday"]
["2016-12-08","Thursday"]
["2016-12-09","Friday"]
["2016-12-10","Saturday"]
["2016-12-11","Sunday"]
["2016-12-12","Monday"]
["2016-12-13","Tuesday"]
["2016-12-14","Wednesday"]
["2016-12-15","Thursday"]
["2016-12-16","Friday"]
["2016-12-17","Saturday"]
["2016-12-18","Sunday"]
["2016-12-19","Monday"]
["2016-12-20","Tuesday"]
["2016-12-21","Wednesday"]
["2016-12-22","Thursday"]
["2016-12-23","Friday"]
["2016-12-24","Saturday"]
["2016-12-25","Sunday"]
["2016-12-26","Monday"]
["2016-12-27","Tuesday"]
["2016-12-28","Wednesday"]
["2016-12-29","Thursday"]
["2016-12-30","Friday"]
["2016-12-31","Saturday"]
["2017-01-01","Sunday"]
["2017-01-02","Monday"]
["2017-01-03","Tuesday"]
["2017-01-04","Wednesday"]
["2017-01-05","Thursday"]
["2017-01-06","Friday"]
["2017-01-07","Saturday"]
["2017-01-08","Sunday"]
["2017-01-09","Monday"]
["2017-01-10","Tuesday"]
["2017-01-11","Wednesday"]
["2017-01-12","Thursday"]
["2017-01-13","Friday"]
["2017-01-14","Saturday"]
["2017-01-15","Sunday"]
["2017-01-16","Monday"]
["2017-01-17","Tuesday"]
["2017-01-18","Wednesday"]
["2017-01-19","Thursday"]
["2017-01-20","Friday"]
["2017-01-21","Saturday"]
["2017-01-22","Sunday"]
["2017-01-23","Monday"]
["2017-01-24","Tuesday"]
["2017-01-25","Wednesday"]
["2017-01-26","Thursday"]
["2017-01-27","Friday"]
["2017-01-28","Saturday"]
["2017-01-29","Sunday"]
["2017-01-30","Monday"]
["2017-01-31","Tuesday"]
["2017-02-01","Wednesday"]
["2017-02-02","Thursday"]
["2017-02-03","Friday"]
["2017-02-04","Saturday"]
["2017-02-05","Sunday"]
["2017-02-06","Monday"]
["2017-02-07","Tuesday"]
["2017-02-08","Wednesday"]
["2017-02-09","Thursday"]
["2017-02-10","Friday"]
["2017-02-11","Saturday"]
["2017-02-12","Sunday"]
["2017-02-13","Monday"]
["2017-02-14","Tuesday"]
["2017-02-15","Wednesday"]
["2017-02-16","Thursday"]
["2017-02-17","Friday"]
["2017-02-18","Saturday"]
["2017-02-19","Sunday"]
["2017-02-20","Monday"]
["2017-02-21","Tuesday"]
["2017-02-22","Wednesday"]
["2017-02-23","Thursday"]
["2017-02-24","Friday"]
["2017-02-25","Saturday"]
["2017-02-26","Sunday"]
["2017-02-27","Monday"]
["2017-02-28","Tuesday"]
["2017-03-01","Wednesday"]
["2017-03-02","Thursday"]
["2017-03-03","Friday"]
["2017-03-04","Saturday"]
["2017-03-05","Sunday"]
["2017-03-06","Monday"]
["2017-03-07","Tuesday"]
["2017-03-08","Wednesday"]
["2017-03-09","Thursday"]
["2017-03-10","Friday"]
["2017-03-11","Saturday"]
["2017-03-12","Sunday"]
["2017-03-13","Monday"]
["2017-03-14","Tuesday"]
["2017-03-15","Wednesday"]
["2017-03-16","Thursday"]
["2017-03-17","Friday"]
["2017-03-18","Saturday"]
["2017-03-19","Sunday"]
["2017-03-20","Monday"]
["2017-03-21","Tuesday"]
["2017-03-22","Wednesday"]
["2017-03-23","Thursday"]
["2017-03-24","Friday"]
["2017-03-25","Saturday"]
["2017-03-26","Sunday"]
["2017-03-27","Monday"]
["2017-03-28","Tuesday"]
["2017-03-29","Wednesday"]
["2017-03-30","Thursday"]
["2017-03-31","Friday"]
["2017-04-01","Saturday"]
["2017-04-02","Sunday"]
["2017-04-03","Monday"]
["2017-04-04","Tuesday"]
["2017-04-05","Wednesday"]
["2017-04-06","Thursday"]
["2017-04-07","Friday"]
["2017-04-08","Saturday"]
["2017-04-09","Sunday"]
["2017-04-10","Monday"]
["2017-04-11","Tuesday"]
["2017-04-12","Wednesday"]
["2017-04-13","Thursday"]
["2017-04-14","Friday"]
["2017-04-15","Saturday"]
["2017-04-16","Sunday"]
["2017-04-17","Monday"]
["2017-04-18","Tuesday"]
["2017-04-19","Wednesday"]
["2017-04-20","Thursday"]
["2017-04-21","Friday"]
["2017-04-22","Saturday"]
["2017-04-23","Sunday"]
["2017-04-24","Monday"]
["2017-04-25","Tuesday"]
["2017-04-26","Wednesday"]
["2017-04-27","Thursday"]
["2017-04-28","Friday"]
["2017-04-29","Saturday"]
["2017-04-30","Sunday"]
["2017-05-01","Monday"]
["2017-05-02","Tuesday"]
["2017-05-03","Wednesday"]
["2017-05-04","Thursday"]
["2017-05-05","Friday"]
["2017-05-06","Saturday"]
["2017-05-07","Sunday"]
["2017-05-08","Monday"]
["2017-05-09","Tuesday"]
["2017-05-10","Wednesday"]
["2017-05-11","Thursday"]
["2017-05-12","Friday"]
["2017-05-13","Saturday"]
["2017-05-14","Sunday"]
["2017-05-15","Monday"]
["2017-05-16","Tuesday"]
["2017-05-17","Wednesday"]
["2017-05-18","Thursday"]
["2017-05-19","Friday"]
["2017-05-20","Saturday"]
["2017-05-21","Sunday"]
["2017-05-22","Monday"]
["2017-05-23","Tuesday"]
["2017-05-24","Wednesday"]
["2017-05-25","Thursday"]
["2017-05-26","Friday"]
["2017-05-27","Saturday"]
["2017-05-28","Sunday"]
["2017-05-29","Monday"]
["2017-05-30","Tuesday"]
["2017-05-31","Wednesday"]
["2017-06-01","Thursday"]
["2017-06-02","Friday"]
["2017-06-03","Saturday"]
["2017-06-04","Sunday"]
["2017-06-05","Monday"]
["2017-06-06","Tuesday"]
["2017-06-07","Wednesday"]
["2017-06-08","Thursday"]
["2017-06-09","Friday"]
["2017-06-10","Saturday"]
["2017-06-11","Sunday"]
["2017-06-12","Monday"]
["2017-06-13","Tuesday"]
["2017-06-14","Wednesday"]
["2017-06-15","Thursday"]
["2017-06-16","Friday"]
["2017-06-17","Saturday"]
["2017-06-18","Sunday"]
["2017-06-19","Monday"]
["2017-06-20","Tuesday"]
["2017-06-21","Wednesday"]
["2017-06-22","Thursday"]
["2017-06-23","Friday"]
["2017-06-24","Saturday"]
["2017-06-25","Sunday"]
["2017-06-26","Monday"]
["2017-06-27","Tuesday"]
["2017-06-28","Wednesday"]
["2017-06-29","Thursday"]
["2017-06-30","Friday"]
["2017-07-01","Saturday"]
["2017-07-02","Sunday"]
["2017-07-03","Monday"]
["2017-07-04","Tuesday"]
["2017-07-05","Wednesday"]
["2017-07-06","Thursday"]
["2017-07-07","Friday"]
["2017-07-08","Saturday"]
["2017-07-09","Sunday"]
["2017-07-10","Monday"]
["2017-07-11","Tuesday"]
["2017-07-12","Wednesday"]
["2017-07-13","Thursday"]
["2017-07-14","Friday"]
["2017-07-15","Saturday"]
["2017-07-16","Sunday"]
["2017-07-17","Monday"]
["2017-07-18","Tuesday"]
["2017-07-19","Wednesday"]
["2017-07-20","Thursday"]
["2017-07-21","Friday"]
["2017-07-22","Saturday"]
["2017-07-23","Sunday"]
["2017-07-24","Monday"]
["2017-07-25","Tuesday"]
["2017-07-26","Wednesday"]
["2017-07-27","Thursday"]
["2017-07-28","Friday"]
["2017-07-29","Saturday"]
["2017-07-30","Sunday"]
["2017-07-31","Monday"]
["2017-08-01","Tuesday"]
["2017-08-02","Wednesday"]
["2017-08-03","Thursday"]
["2017-08-04","Friday"]
["2017-08-05","Saturday"]
["2017-08-06","Sunday"]
["2017-08-07","Monday"]
["2017-08-08","Tuesday"]
["2017-08-09","Wednesday"]
["2017-08-10","Thursday"]
["2017-08-11","Friday"]
["2017-08-12","Saturday"]
["2017-08-13","Sunday"]
["2017-08-14","Monday"]
["2017-08-15","Tuesday"]
["2017-08-16","Wednesday"]
["2017-08-17","Thursday"]
["2017-08-18","Friday"]
["2017-08-19","Saturday"]
["2017-08-20","Sunday"]
["2017-08-21","Monday"]
["2017-08-22","Tuesday"]
["2017-08-23","Wednesday"]
["2017-08-24","Thursday"]
["2017-08-25","Friday"]
["2017-08-26","Saturday"]
["2017-08-27","Sunday"]
["2017-08-28","Monday"]
["2017-08-29","Tuesday"]
["2017-08-30","Wednesday"]
["2017-08-31","Thursday"]
["2017-09-01","Friday"]
["2017-09-02","Saturday"]
["2017-09-03","Sunday"]
["2017-09-04","Monday"]
["2017-09-05","Tuesday"]
["2017-09-06","Wednesday"]
["2017-09-07","Thursday"]
["2017-09-08","Friday"]
["2017-09-09","Saturday"]
["2017-09-10","Sunday"]
["2017-09-11","Monday"]
["2017-09-12","Tuesday"]
["2017-09-13","Wednesday"]
["2017-09-14","Thursday"]
["2017-09-15","Friday"]
["2017-09-16","Saturday"]
["2017-09-17","Sunday"]
["2017-09-18","Monday"]
["2017-09-19","Tuesday"]
["2017-09-20","Wednesday"]
["2017-09-21","Thursday"]
["2017-09-22","Friday"]
["2017-09-23","Saturday"]
["2017-09-24","Sunday"]
["2017-09-25","Monday"]
["2017-09-26","Tuesday"]
["2017-09-27","Wednesday"]
["2017-09-28","Thursday"]
["2017-09-29","Friday"]
["2017-09-30","Saturday"]
["2017-10-01","Sunday"]
["2017-10-02","Monday"]
["2017-10-03","Tuesday"]
["2017-10-04","Wednesday"]
["2017-10-05","Thursday"]
["2017-10-06","Friday"]
["2017-10-07","Saturday"]
["2017-10-08","Sunday"]
["2017-10-09","Monday"]
["2017-10-10","Tuesday"]
["2017-10-11","Wednesday"]
["2017-10-12","Thursday"]
["2017-10-13","Friday"]
["2017-10-14","Saturday"]
["2017-10-15","Sunday"]
["2017-10-16","Monday"]
["2017-10-17","Tuesday"]
["2017-10-18","Wednesday"]
["2017-10-19","Thursday"]
["2017-10-20","Friday"]
["2017-10-21","Saturday"]
["2017-10-22","Sunday"]
["2017-10-23","Monday"]
["2017-10-24","Tuesday"]
["2017-10-25","Wednesday"]
["2017-10-26","Thursday"]
["2017-10-27","Friday"]
["2017-10-28","Saturday"]
["2017-10-29","Sunday"]
["2017-10-30","Monday"]
["2017-10-31","Tuesday"]
["2017-11-01","Wednesday"]
["2017-11-02","Thursday"]
["2017-11-03","Friday"]
["2017-11-04","Saturday"]
["2017-11-05","Sunday"]
["2017-11-06","Monday"]
["2017-11-07","Tuesday"]
["2017-11-08","Wednesday"]
["2017-11-09","Thursday"]
["2017-11-10","Friday"]
["2017-11-11","Saturday"]
["2017-11-12","Sunday"]
["2017-11-13","Monday"]
["2017-11-14","Tuesday"]
["2017-11-15","Wednesday"]
["2017-11-16","Thursday"]
["2017-11-17","Friday"]
["2017-11-18","Saturday"]
["2017-11-19","Sunday"]
["2017-11-20","Monday"]
["2017-11-21","Tuesday"]
["2017-11-22","Wednesday"]
["2017-11-23","Thursday"]
["2017-11-24","Friday"]
["2017-11-25","Saturday"]
["2017-11-26","Sunday"]
["2017-11-27","Monday"]
["2017-11-28","Tuesday"]
["2017-11-29","Wednesday"]
["2017-11-30","Thursday"]
["2017-12-01","Friday"]
["2017-12-02","Saturday"]
["2017-12-03","Sunday"]
["2017-12-04","Monday"]
["2017-12-05","Tuesday"]
["2017-12-06","Wednesday"]
["2017-12-07","Thursday"]
["2017-12-08","Friday"]
["2017-12-09","Saturday"]
["2017-12-10","Sunday"]
["2017-12-11","Monday"]
["2017-12-12","Tuesday"]
["2017-12-13","Wednesday"]
["2017-12-14","Thursday"]
["2017-12-15","Friday"]
["2017-12-16","Saturday"]
["2017-12-17","Sunday"]
["2017-12-18","Monday"]
["2017-12-19","Tuesday"]
["2017-12-20","Wednesday"]
["2017-12-21","Thursday"]
["2017-12-22","Friday"]
["2017-12-23","Saturday"]
["2017-12-24","Sunday"]
["2017-12-25","Monday"]
["2017-12-26","Tuesday"]
["2017-12-27","Wednesday"]
["2017-12-28","Thursday"]
["2017-12-29","Friday"]
["2017-12-30","Saturday"]
["2017-12-31","Sunday"]
["2018-01-01","Monday"]

{"sheet":"Macro","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
["EmailToGB"]
["Subject:",{"$f":"\"WPRR Submission for \" & WPRR!B8 &\" - \" & WPRR!H8","v":"WPRR Submission for  - "}]
["Body:","Please ensure to attach payslips for the period that you are claiming reimbursement"]

{"sheet":"Calculator","index":3,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[13,1,13,6],[8,1,8,2],[8,3,8,4],[9,1,9,2],[9,3,9,4],[10,1,10,2],[11,1,11,2],[11,3,11,4],[7,1,7,2],[7,3,7,4],[2,1,2,6],[4,1,4,2],[4,3,4,4],[5,1,5,2],[5,3,5,4]]}
[]
[null,null,null,null,null,null,"Weekly Payment Reimbursement Request  ."]
[]
[]
[null,"Employer Name:",null,null,null,"Employer ABN:"]
[null,"ReturnToWorkSA  Registration No:",null,null,null,"Location No:"]
[]
[null,"Worker Name: ",null,null,null,"Date of Injury:"]
[null,"Claim Number:",null,null,null,"Date of First Incapacity:"]
[null,"Notional Weekly Earnings:",null,null,null,"Normal hrs worked per week:"]
[]
[null," Week Starting:",null,null,null,"No. of Weeks:"]
[null,"Agreed Pay Cycle Start Day:",null,{"$f":"C16","v":""},null,"Entitlement Percentage:"]
[null,"* NOTE: if the reduction date falls within a week, the estimated reimbursement will show at 80%.  This may not be accurate."]
[null,"Date","Week Day","Hours Worked","Earnings from \nPaid Employment",null,{"$f":"DATE(YEAR(G9)+1,MONTH(G9),DAY(G9))","v":"1900-12-31"}]
[null,{"$f":"IF($G$12>=1,D12,\"\")","v":""},{"$f":"IF($G$12>=1,VLOOKUP(B16,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,{"$f":"B16>=$G$9","v":true}]
[null,{"$f":"IF($G$12>=1,B16+1,\"\")","v":""},{"$f":"IF($G$12>=1,VLOOKUP(B17,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,{"$f":"B17>=$G$9","v":true}]
[null,"",{"$f":"IF($G$12>=1,VLOOKUP(B18,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=1,VLOOKUP(B19,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=1,VLOOKUP(B20,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=1,VLOOKUP(B21,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=1,VLOOKUP(B22,Days!A:B,2,FALSE),\"\")","v":""},null,null,false,true]
[null,"Week Ending",null,{"$f":"IF($F22=TRUE,\"\",IF(SUM(D16:D22)=0,\"\",SUMIF($G$16:$G$22,TRUE,$D$16:$D$22)))","v":""},{"$f":"IF($F$22=TRUE,\"\",IF(SUM(E16:E22)=0,\"\",SUMIF($G$16:$G$22,TRUE,$E$16:$E$22)))","v":""},"Estimated Reimbursement",{"$f":"IFERROR(IF(F22=TRUE,($D$10*$G$13)/100,($D$10-E23)*$G$13/100),\"\")","v":""}]
[null,{"$f":"IF($G$12>=2,B22+1,\"\")","v":""},{"$f":"IF($G$12>=2,VLOOKUP(B24,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,{"$f":"B24>=$G$9","v":true}]
[null,{"$f":"IF($G$12>=2,B24+1,\"\")","v":""},{"$f":"IF($G$12>=2,VLOOKUP(B25,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,{"$f":"B25>=$G$9","v":true}]
[null,"",{"$f":"IF($G$12>=2,VLOOKUP(B26,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=2,VLOOKUP(B27,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=2,VLOOKUP(B28,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=2,VLOOKUP(B29,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=2,VLOOKUP(B30,Days!A:B,2,FALSE),\"\")","v":""},null,null,false,true]
[null,"Week Ending",null,{"$f":"IF($F30=TRUE,\"\",IF(SUM(D24:D30)=0,\"\",SUMIF($G$24:$G$30,TRUE,$D$24:$D$30)))","v":""},{"$f":"IF(F30=TRUE,\"\",IF(SUM(E24:E30)=0,\"\",SUMIF($G$24:$G$30,TRUE,$E$24:$E$30)))","v":""},"Estimated Reimbursement",{"$f":"IFERROR(IF(F30=TRUE,($D$10*$G$13)/100,($D$10-E31)*$G$13/100),\"\")","v":""}]
[null,{"$f":"IF($G$12>=3,B30+1,\"\")","v":""},{"$f":"IF($G$12>=3,VLOOKUP(B32,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,{"$f":"B32>=$G$9","v":true}]
[null,{"$f":"IF($G$12>=3,B32+1,\"\")","v":""},{"$f":"IF($G$12>=3,VLOOKUP(B33,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,{"$f":"B33>=$G$9","v":true}]
[null,"",{"$f":"IF($G$12>=3,VLOOKUP(B34,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=3,VLOOKUP(B35,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=3,VLOOKUP(B36,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=3,VLOOKUP(B37,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=3,VLOOKUP(B38,Days!A:B,2,FALSE),\"\")","v":""},null,null,false,true]
[null,"Week Ending",null,{"$f":"IF($F38=TRUE,\"\",IF(SUM(D32:D38)=0,\"\",SUMIF($G$32:$G$38,TRUE,$D$32:$D$38)))","v":""},{"$f":"IF(F38=TRUE,\"\",IF(SUM(E32:E38)=0,\"\",SUMIF($G$32:$G$38,TRUE,$E$32:$E$38)))","v":""},"Estimated Reimbursement",{"$f":"IFERROR(IF(F38=TRUE,($D$10*$G$13)/100,($D$10-E39)*$G$13/100),\"\")","v":""}]
[null,{"$f":"IF($G$12>=4,B38+1,\"\")","v":""},{"$f":"IF($G$12>=4,VLOOKUP(B40,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,{"$f":"B40>=$G$9","v":true}]
[null,{"$f":"IF($G$12>=4,B40+1,\"\")","v":""},{"$f":"IF($G$12>=4,VLOOKUP(B41,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,{"$f":"B41>=$G$9","v":true}]
[null,"",{"$f":"IF($G$12>=4,VLOOKUP(B42,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=4,VLOOKUP(B43,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=4,VLOOKUP(B44,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=4,VLOOKUP(B45,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=4,VLOOKUP(B46,Days!A:B,2,FALSE),\"\")","v":""},null,null,false,true]
[null,"Week Ending",null,{"$f":"IF($F46=TRUE,\"\",IF(SUM(D40:D46)=0,\"\",SUMIF($G$40:$G$46,TRUE,$D$40:$D$46)))","v":""},{"$f":"IF(F46=TRUE,\"\",IF(SUM(E40:E46)=0,\"\",SUMIF($G$40:$G$46,TRUE,$E$40:$E$46)))","v":""},"Estimated Reimbursement",{"$f":"IFERROR(IF(F46=TRUE,($D$10*$G$13)/100,($D$10-E47)*$G$13/100),\"\")","v":""}]
[null,{"$f":"IF($G$12>=5,B46+1,\"\")","v":""},{"$f":"IF($G$12>=5,VLOOKUP(B48,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,{"$f":"B48>=$G$9","v":true}]
[null,{"$f":"IF($G$12>=5,B48+1,\"\")","v":""},{"$f":"IF($G$12>=5,VLOOKUP(B49,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,{"$f":"B49>=$G$9","v":true}]
[null,"",{"$f":"IF($G$12>=5,VLOOKUP(B50,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=5,VLOOKUP(B51,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=5,VLOOKUP(B52,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=5,VLOOKUP(B53,Days!A:B,2,FALSE),\"\")","v":""},null,null,null,true]
[null,"",{"$f":"IF($G$12>=5,VLOOKUP(B54,Days!A:B,2,FALSE),\"\")","v":""},null,null,false,true]
[null,"Week Ending",null,{"$f":"IF($F54=TRUE,\"\",IF(SUM(D48:D54)=0,\"\",SUMIF($G$48:$G$54,TRUE,$D$48:$D$54)))","v":""},{"$f":"IF(F54=TRUE,\"\",IF(SUM(E48:E54)=0,\"\",SUMIF($G$48:$G$54,TRUE,$E$48:$E$54)))","v":""},"Estimated Reimbursement",{"$f":"IFERROR(IF(F54=TRUE,($D$10*$G$13)/100,($D$10-E55)*$G$13/100),\"\")","v":""}]

{"sheet":"WPRR","index":4,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[32,17,32,31],[27,1,27,15],[30,1,30,15],[34,1,34,9],[34,12,34,15],[29,1,29,15],[31,1,31,15],[33,1,33,15],[9,1,9,15],[39,1,39,4],[39,5,39,10],[17,1,17,15],[10,1,10,6],[10,7,10,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,7,16,9],[16,10,16,12],[11,7,11,9],[12,7,12,9],[13,7,13,9],[14,7,14,9],[15,7,15,9],[40,5,40,8],[18,1,18,15],[19,1,19,15],[20,1,20,15],[22,1,22,15],[24,1,24,15],[25,1,25,15],[28,1,28,15],[37,1,37,15],[39,13,39,15],[40,1,40,4],[38,1,38,15],[21,1,21,15],[23,1,23,15],[26,1,26,15],[3,7,3,15],[4,1,4,6],[4,7,4,10],[4,12,4,13],[4,14,4,15],[2,1,2,6],[2,7,2,15],[3,1,3,6],[16,13,16,15],[8,1,8,15],[6,1,6,6],[7,1,7,6],[6,7,6,9],[7,7,7,9],[6,10,6,12],[7,10,7,12],[6,13,6,15],[7,13,7,15],[11,13,11,15],[12,13,12,15],[11,10,11,12],[12,10,12,12],[13,10,13,12],[14,10,14,12],[15,10,15,12],[14,4,14,6],[15,4,15,6],[16,4,16,6],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[11,4,11,6],[12,4,12,6],[13,4,13,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly Payment Reimbursement Request  ."]
[null,"Name of employer (as per registration)",null,null,null,null,null,{"$f":"IF(Calculator!D5=\"\",\"\",Calculator!D5)","v":""}]
[null,"Employer ABN",null,null,null,null,null,{"$f":"IF(Calculator!G5=0,\"\",Calculator!G5)","v":""}]
[null,"ReturnToWorkSA registration no",null,null,null,null,null,{"$f":"IF(Calculator!D6=0,\"\",Calculator!D6)","v":""},null,null,null,null,"Location no",null,{"$f":"IF(Calculator!G6=0,\"\",Calculator!G6)","v":""}]
[]
[null,"Worker’s Name",null,null,null,null,null,"Claim Number",null,null,"Date of Injury",null,null,"NWE*"]
[null,{"$f":"IF(Calculator!D8=\"\",\"\",Calculator!D8)","v":""},null,null,null,null,null,{"$f":"IF(Calculator!D9=\"\",\"\",Calculator!D9)","v":""},null,null,{"$f":"IF(Calculator!G8=\"\",\"\",Calculator!G8)","v":""},null,null,{"$f":"IF(Calculator!D10=\"\",\"\",Calculator!D10)","v":""}]
[null,"*Notional weekly earnings: The worker’s average weekly earnings or where adjusted, the adjusted average weekly earnings."]
[null,"Details of worker earning and hours of paid employment"]
[null,{"$f":"Calculator!B13","v":"Agreed Pay Cycle Start Day:"},null,null,null,null,null,{"$f":"IF(Calculator!D13=0,\"\",Calculator!D13)","v":""}]
[null,"Pay Week Starting",null,null,"Pay Week Ending",null,null,"Nil Earnings",null,null,"Earnings from Paid Employment",null,null,"Hours Worked"]
[null,{"$f":"IF(Calculator!B16=0,\"\",Calculator!B16)","v":""},null,null,{"$f":"Calculator!B22","v":""},null,null,{"$f":"IF(Calculator!$F$22=TRUE,\"X\",\"\")","v":""},null,null,{"$f":"IF(Calculator!$E23=\"0\",\"\",Calculator!$E23)","v":""},null,null,{"$f":"IF(Calculator!$D23=\"0\",\"\",Calculator!$D23)","v":""}]
[null,{"$f":"IF(Calculator!B24=0,\"\",Calculator!B24)","v":""},null,null,{"$f":"Calculator!B30","v":""},null,null,{"$f":"IF(Calculator!F30=TRUE,\"X\",\"\")","v":""},null,null,{"$f":"IF(Calculator!$E31=\"0\",\"\",Calculator!$E31)","v":""},null,null,{"$f":"Calculator!$D31","v":""}]
[null,{"$f":"Calculator!B32","v":""},null,null,{"$f":"Calculator!B38","v":""},null,null,{"$f":"IF(Calculator!F38=TRUE,\"X\",\"\")","v":""},null,null,{"$f":"IF(Calculator!$E39=0,\"\",Calculator!$E39)","v":""},null,null,{"$f":"Calculator!$D39","v":""}]
[null,{"$f":"Calculator!B40","v":""},null,null,{"$f":"Calculator!B46","v":""},null,null,{"$f":"IF(Calculator!F46=TRUE,\"X\",\"\")","v":""},null,null,{"$f":"IF(Calculator!$E47=0,\"\",Calculator!$E47)","v":""},null,null,{"$f":"Calculator!$D47","v":""}]
[null,{"$f":"Calculator!B48","v":""},null,null,{"$f":"Calculator!B54","v":""},null,null,{"$f":"IF(Calculator!F54=TRUE,\"X\",\"\")","v":""},null,null,{"$f":"IF(Calculator!E55=0,\"\",Calculator!E55)","v":""},null,null,{"$f":"Calculator!$D55","v":""}]
[]
[null,"1.     This form is intended to assist employers seeking reimbursement for weekly income support payments made to a worker."]
[null,"2.     Use one form per worker. Please contact your Claims Officer if you need help completing this form. "]
[null,"3.     Additional copies of this form are available on Gallagher Bassett’s website (www.gallagherbassett.com.au) or by contacting "]
[null,"us on 8177 8450"]
[null,"4.     This form must be submitted within three months from the date you paid the worker the payment you are seeking to be "]
[null,"reimbursed."]
[null,"5.     Evidence of payment / pay records must be attached."]
[null,"6.     ReturnToWorkSA will only reimburse income maintenance payments that the worker was legally entitled to receive. It is"]
[null,"the employer’s responsibility to ensure (by obtaining a written authorisation from ReturnToWorkSA or Gallagher Bassett)"]
[null,"that the worker was entitled to receive a particular payment of income maintenance."]
[null,"7.     Tick the ‘Nil earnings’ box if the worker did not perform any work during the week."]
[null,"8.     Only include amounts paid for work performed in your employment by the worker which includes personal leave. Do not "]
[null,"include any allowances or benefits relating to annual leave or other leave type."]
[null,"9.     Weekly payment reimbursement requests and pay slips can be emailed to wprr@gb.rtwsa.com for reimbursement."]
[]
[null,"I declare that weekly payments of income support have been paid to the worker in accordance with the Return to Work Act 2014"]
[null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,"Signature of authorised officer of employer"]
[]
[null,"AGENT OFFICE USE ONLY"]
[null,"I confirm that the details of this form match my knowledge of the worker’s expected earnings from employer"]
[null,"Signed / authorised",null,null,null,null,null,null,null,null,null,null,"Date"]
[null,"Name of authorising officer"]

{"sheet":"Sheet1","index":5,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]