{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Report (Simple)","Report (Detail)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Report (Simple)","index":0,"n_rows":2,"n_cols":20,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Employee Name","Payroll ID","Main Location","Period Start","Period End","Pay Rule","Base Pay","Comparison Award","Comparison Base Pay","Hours Worked in Period","Meal Break Hours","Timesheet Cost","Comparison Cost","Variance","Overtime Hours Worked","Penalty Hours Worked","Overtime Outer Limit","Penalty Outer Limit","Amount Over Overtime Limit","Amount Over Penalty Outer Limit"]
["SAMPLE EMPLOYEE",9.0,"Pay Comparison Sample","2022-08-08","2022-08-14","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,40.0,"02:00",1223.7,332.5,891.2,0.0,13.25,12.0,18.0,0.0,0.0]

{"sheet":"Report (Detail)","index":1,"n_rows":19,"n_cols":23,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Employee Name","Payroll ID","Main Location","Period Start","Period End","Timesheet Date","Timesheet Start Time","Timesheet End Time","Timesheet Break Amount","Timesheet Location","Timesheet Area","Pay Rule","Base Pay","Comparison Award","Base Pay","Pay Condition (Main)","Pay Type","Hours","Cost","Pay Condition (Comparison)","Pay Type","Hours","Cost"]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-08","12:00","20:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,"HIGA - FT - 1-November-2021 - Overtime - RDO","Overtime",7.5,300.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-08","12:00","20:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,"HIGA - FT - 1-November-2021 - M-F 7pm-12am","Penalty",1.0,2.37]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-09","13:00","21:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,"HIGA - FT - 1-November-2021 - Overtime - RDO","Overtime",7.5,300.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-09","13:00","21:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,"HIGA - FT - 1-November-2021 - M-F 7pm-12am","Penalty",2.0,4.74]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-10","14:00","22:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,"HIGA - FT - 1-November-2021 - Overtime - RDO","Overtime",7.5,300.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-10","14:00","22:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,"HIGA - FT - 1-November-2021 - M-F 7pm-12am","Penalty",3.0,7.11]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-11","15:00","23:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,"HIGA - FT - 1-November-2021 - Overtime - RDO","Overtime",7.5,300.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-11","15:00","23:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,"HIGA - FT - 1-November-2021 - M-F 7pm-12am","Penalty",4.0,9.48]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-08","12:00","20:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,{"$nulls":4},"GRIA - CAS - 1-July-2022 - M-F 6pm-9pm","Penalty",2.0,24.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-08","12:00","20:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,{"$nulls":4},"GRIA - CAS - 1-July-2022 - M-F Ordinary","Ordinary",5.5,55.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-09","13:00","21:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,{"$nulls":4},"GRIA - CAS - 1-July-2022 - M-F 6pm-9pm","Penalty",3.0,36.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-09","13:00","21:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,{"$nulls":4},"GRIA - CAS - 1-July-2022 - M-F Ordinary","Ordinary",4.5,45.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-10","14:00","22:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,{"$nulls":4},"GRIA - CAS - 1-July-2022 - M-F 6pm-9pm","Penalty",2.75,33.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-10","14:00","22:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,{"$nulls":4},"GRIA - CAS - 1-July-2022 - M-F After 9pm - First 3 Hours","Penalty",1.0,14.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-10","14:00","22:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,{"$nulls":4},"GRIA - CAS - 1-July-2022 - M-F Ordinary","Ordinary",3.75,37.5]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-11","15:00","23:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,{"$nulls":4},"GRIA - CAS - 1-July-2022 - M-F 6pm-9pm","Penalty",2.5,30.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-11","15:00","23:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,{"$nulls":4},"GRIA - CAS - 1-July-2022 - M-F After 9pm - First 3 Hours","Penalty",2.0,28.0]
["SAMPLE EMPLOYEE","SAMPLE","Pay Comparison Sample","2022-08-08","2022-08-14","2022-08-11","15:00","23:00","00:30","Pay Comparison Sample","Restaurant","TP [MA000009] HIGA - Full Time - 1-November-2021",20.0,"au/casual-2022-07-01-gria-1",10.0,{"$nulls":4},"GRIA - CAS - 1-July-2022 - M-F Ordinary","Ordinary",3.0,30.0]