{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Placement Timesheet","Look Up Lists"],"not_rendered":{"charts":0,"images":0,"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":"Placement Timesheet","index":0,"n_rows":105,"n_cols":18,"rows_kept":105,"cut":false,"hidden":false,"merged":[[38,1,40,1],[38,2,38,5],[38,6,38,9],[38,10,38,13],[38,14,38,17],[39,2,40,2],[39,3,40,3],[84,1,88,17],[83,1,83,17],[20,1,20,17],[13,15,13,17],[24,6,25,6],[24,7,25,7],[24,8,24,9],[24,3,25,3],[24,4,24,5],[23,2,23,5],[24,2,25,2],[17,1,17,3],[4,7,17,12],[10,2,10,5],[19,0,19,18],[0,1,0,17],[7,2,7,5],[2,1,2,17],[69,16,69,17],[68,1,70,1],[68,2,68,5],[68,6,68,9],[68,10,68,13],[68,14,68,17],[69,2,70,2],[69,3,70,3],[69,4,69,5],[69,6,70,6],[69,7,70,7],[53,1,55,1],[53,2,53,5],[53,6,53,9],[53,10,53,13],[53,14,53,17],[11,2,11,5],[8,2,9,5],[8,1,9,1],[10,14,10,17],[6,2,6,5],[22,1,22,17],[39,14,40,14],[39,15,40,15],[39,16,39,17],[69,8,69,9],[69,10,70,10],[69,11,70,11],[69,12,69,13],[54,8,54,9],[54,10,55,10],[54,11,55,11],[54,12,54,13],[54,14,55,14],[54,15,55,15],[49,12,49,13],[49,14,49,15],[49,16,49,17],[39,10,40,10],[39,11,40,11],[39,12,39,13],[39,4,39,5],[51,12,51,13],[51,14,51,15],[51,16,51,17],[64,16,64,17],[54,16,54,17],[4,14,4,17],[24,11,25,11],[24,12,24,13],[5,2,5,5],[4,1,4,5],[16,15,16,17],[7,15,7,17],[15,15,15,17],[11,15,11,17],[5,15,5,17],[17,15,17,17],[8,15,8,17],[14,15,14,17],[23,14,23,17],[24,14,25,14],[24,15,25,15],[24,16,24,17],[23,10,23,13],[24,10,25,10],[23,1,25,1],[23,6,23,9],[6,15,6,17],[9,15,9,17],[35,4,35,5],[36,4,36,5],[34,2,34,3],[35,2,35,3],[36,2,36,3],[15,1,15,3],[16,1,16,3],[14,1,14,3],[34,4,34,5],[36,12,36,13],[35,12,35,13],[34,12,34,13],[34,16,34,17],[35,16,35,17],[36,14,36,15],[35,14,35,15],[34,14,34,15],[36,16,36,17],[36,8,36,9],[35,8,35,9],[34,8,34,9],[36,6,36,7],[35,6,35,7],[34,6,34,7],[34,10,34,11],[35,10,35,11],[36,10,36,11],[50,6,50,7],[50,8,50,9],[50,10,50,11],[39,6,40,6],[39,7,40,7],[50,12,50,13],[39,8,39,9],[50,14,50,15],[50,16,50,17],[49,2,49,3],[49,4,49,5],[49,6,49,7],[49,8,49,9],[49,10,49,11],[50,2,50,3],[50,4,50,5],[51,2,51,3],[51,4,51,5],[51,6,51,7],[51,8,51,9],[51,10,51,11],[54,7,55,7],[54,3,55,3],[54,4,54,5],[54,6,55,6],[54,2,55,2],[64,2,64,3],[64,4,64,5],[64,6,64,7],[64,8,64,9],[64,10,64,11],[64,12,64,13],[64,14,64,15],[65,12,65,13],[65,14,65,15],[79,6,79,7],[79,8,79,9],[79,10,79,11],[65,16,65,17],[66,2,66,3],[66,4,66,5],[66,6,66,7],[66,8,66,9],[66,10,66,11],[66,12,66,13],[66,14,66,15],[66,16,66,17],[65,2,65,3],[65,4,65,5],[65,6,65,7],[65,8,65,9],[65,10,65,11],[69,14,70,14],[69,15,70,15],[89,1,90,16],[104,1,104,17],[12,15,12,17],[81,12,81,13],[81,14,81,15],[81,16,81,17],[81,2,81,3],[81,4,81,5],[81,6,81,7],[81,8,81,9],[81,10,81,11],[79,12,79,13],[79,14,79,15],[79,16,79,17],[80,2,80,3],[80,4,80,5],[80,6,80,7],[80,8,80,9],[80,10,80,11],[80,12,80,13],[80,14,80,15],[80,16,80,17],[79,2,79,3],[79,4,79,5]]}
[null,"SHEFFIELD HALLAM UNIVERSITY - PLACEMENT TIMESHEET"]
[]
[null,"Please complete the below table at the end of your placement block to record the number of hours and minutes attended for each shift eg 7 (hours) 30 (minutes).  The information should match that record in your assessment booklet which should have been signed off by your Practice Placement Assessor (PPE)"]
[]
[null,"STUDENT INFORMATION",null,null,null,null,null,"INSTRUCTION FOR THE CODE COLUMN\nBank Holidays - Please indicate by selecting BH from the drop down list.\nInterview - Please indicate by selecting INT from the dropdown list\nNight Duty -  Please indicate shifts undertaken by selecting ND code from the drop down list\nMakeup Time - If any additional shifts have be completed for 'Makeup Time' please indicate with MT \nStudy Day - If any study days have been authorised please indicate with SD\nMissed Shifts - If any rostered shift has been missed please record the reason using the code as specified in the 'Key'\n",null,null,null,null,null,null,"KEY - FOR THE CODE COLUMN"]
[null,"STUDENT SURNAME",null,null,null,null,null,null,null,null,null,null,null,null,"BH","Bank Holiday"]
[null,"STUDENT FORENAME",null,null,null,null,null,null,null,null,null,null,null,null,"INT","Interview"]
[null,"STUDENT NUMBER",null,null,null,null,null,null,null,null,null,null,null,null,"ND","Night Duty"]
[null,"COURSE TYPE",null,null,null,null,null,null,null,null,null,null,null,null,"MT","Makeup Time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD","Study Day"]
[null,"COHORT",null,null,null,null,null,null,null,null,null,null,null,null,"Missed Shift Codes"]
[null,"PLACEMENT PROVIDER",null,null,null,null,null,null,null,null,null,null,null,null,"A","Absent"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA","Authorised Absence"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ASA","Approved SHU Attendance"]
[null,"TOTALS FOR PLACEMENT BLOCK HOURS",null,null,"Decimal","Hrs:Min",null,null,null,null,null,null,null,null,"CL","Compassionate Leave"]
[null,"MISSED SHIFTS FROM PLACEMENT",null,null,{"$f":"SUM(C35,G35,K35,O35,C50,G50,K50,O50,C65,G65,K65,O65,C80,G80,K80,O80)","v":0},{"$f":"SUM(E35,I35,M35,Q35,E50,I50,M50,Q50,E65,I65,M65,Q65,E80,I80,M80,Q80)","v":0},null,null,null,null,null,null,null,null,"NCP","Not Clear for Placement"]
[null,"NIGHT DUTY HOURS COMPLETED",null,null,{"$f":"SUM(C36,G36,K36,O36,C51,G51,K51,O51,C66,G66,K66,O66,C81,G81,K81,O81)","v":0},{"$f":"SUM(E36,I36,M36,Q36,E51,I51,M51,Q51,E66,I66,M66,Q66,E81,I81,M81,Q81)","v":0},null,null,null,null,null,null,null,null,"S","Sick"]
[null,"PLACEMENT HOURS ATTENDED",null,null,{"$f":"SUM(C37,G37,K37,O37,C52,G52,K52,O52,C67,G67,K67,O67,C82,G82,K82,O82)","v":0},{"$f":"SUM(E37,I37,M37,Q37,E52,I52,M52,Q52,E67,I67,M67,Q67,E82,I82,M82,Q82)","v":0},null,null,null,null,null,null,null,null,"SL","Special Leave"]
[]
["After completion of your 'Placement Timesheet' please submit electionically to the below, submitting your Assessment Booklet to the module lead"]
[null,"HWB-AHPTimesheets@shu.ac.uk "]
[]
[null,"RECORD OF YOUR PLACEMENT HOURS"]
[null,"DAY OF THE WEEK","WEEK 1",null,null,null,"WEEK 2",null,null,null,"WEEK 3",null,null,null,"WEEK 4"]
[null,null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked"]
[null,null,null,null,"Hours","Minutes",null,null,"Hours","Minutes",null,null,"Hours","Minutes",null,null,"Hours","Minutes"]
[null,"Monday ",null,null,null,null,null,null,{"$f":"IF(H27=\"\",\"\",VLOOKUP(H27,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H27=\"\",\"\",VLOOKUP(H27,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L27=\"\",\"\",VLOOKUP(L27,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L27=\"\",\"\",VLOOKUP(L27,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P27=\"\",\"\",VLOOKUP(P27,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P27=\"\",\"\",VLOOKUP(P27,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Tuesday",null,null,{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H28=\"\",\"\",VLOOKUP(H28,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H28=\"\",\"\",VLOOKUP(H28,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L28=\"\",\"\",VLOOKUP(L28,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L28=\"\",\"\",VLOOKUP(L28,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P28=\"\",\"\",VLOOKUP(P28,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P28=\"\",\"\",VLOOKUP(P28,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Wednesday",null,null,{"$f":"IF(D29=\"\",\"\",VLOOKUP(D29,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D29=\"\",\"\",VLOOKUP(D29,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H29=\"\",\"\",VLOOKUP(H29,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H29=\"\",\"\",VLOOKUP(H29,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L29=\"\",\"\",VLOOKUP(L29,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L29=\"\",\"\",VLOOKUP(L29,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P29=\"\",\"\",VLOOKUP(P29,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P29=\"\",\"\",VLOOKUP(P29,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Thursday",null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H30=\"\",\"\",VLOOKUP(H30,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H30=\"\",\"\",VLOOKUP(H30,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L30=\"\",\"\",VLOOKUP(L30,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L30=\"\",\"\",VLOOKUP(L30,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P30=\"\",\"\",VLOOKUP(P30,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P30=\"\",\"\",VLOOKUP(P30,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Friday",null,null,{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H31=\"\",\"\",VLOOKUP(H31,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H31=\"\",\"\",VLOOKUP(H31,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L31=\"\",\"\",VLOOKUP(L31,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L31=\"\",\"\",VLOOKUP(L31,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P31=\"\",\"\",VLOOKUP(P31,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P31=\"\",\"\",VLOOKUP(P31,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Saturday",null,null,{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H32=\"\",\"\",VLOOKUP(H32,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H32=\"\",\"\",VLOOKUP(H32,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L32=\"\",\"\",VLOOKUP(L32,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L32=\"\",\"\",VLOOKUP(L32,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P32=\"\",\"\",VLOOKUP(P32,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P32=\"\",\"\",VLOOKUP(P32,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Sunday",null,null,{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H33=\"\",\"\",VLOOKUP(H33,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H33=\"\",\"\",VLOOKUP(H33,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L33=\"\",\"\",VLOOKUP(L33,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L33=\"\",\"\",VLOOKUP(L33,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P33=\"\",\"\",VLOOKUP(P33,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P33=\"\",\"\",VLOOKUP(P33,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Hidded calculation row",null,null,{"$f":"TIME(0,SUM(SUMIF(D27:D33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},E27:E33)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(D27:D33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},F27:F33)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(H27:H33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},I27:I33)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(H27:H33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},J27:J33)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(L27:L33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},M27:M33)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(L27:L33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},N27:N33)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(P27:P33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},Q27:Q33)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(P27:P33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},R27:R33)),0)","v":0}]
[null,"MISSED SHIFTS TOTAL",{"$f":"E35*24","v":0},null,{"$f":"E34+F34","v":0},null,{"$f":"I35*24","v":0},null,{"$f":"I34+J34","v":0},null,{"$f":"M35*24","v":0},null,{"$f":"M34+N34","v":0},null,{"$f":"Q35*24","v":0},null,{"$f":"Q34+R34","v":0}]
[null,"NIGHT DUTY TOTAL",{"$f":"SUMIF(D$27:D$33,\"ND\",E$27:E$33)+SUMIF(D$27:D$33,\"ND\",F$27:F$33)/60","v":0},null,{"$f":"C36/24","v":0},null,{"$f":"SUMIF(H$27:H$33,\"ND\",I$27:I$33)+SUMIF(H$27:H$33,\"ND\",J$27:J$33)/60","v":0},null,{"$f":"G36/24","v":0},null,{"$f":"SUMIF(L$27:L$33,\"ND\",M$27:M$33)+SUMIF(L$27:L$33,\"ND\",N$27:N$33)/60","v":0},null,{"$f":"K36/24","v":0},null,{"$f":"SUMIF(P$27:P$33,\"ND\",Q$27:Q$33)+SUMIF(P$27:P$33,\"ND\",R$27:R$33)/60","v":0},null,{"$f":"O36/24","v":0}]
[null,"OVERALL TOTAL INC ND",{"$f":"SUM(E27:E33)+(SUM(F27:F33)/60)-C35","v":0},null,{"$f":"C37/24","v":0},null,{"$f":"SUM(I27:I33)+(SUM(J27:J33)/60)-G35","v":0},null,{"$f":"G37/24","v":0},null,{"$f":"SUM(M27:M33)+(SUM(N27:N33)/60)-K35","v":0},null,{"$f":"K37/24","v":0},null,{"$f":"SUM(Q27:Q33)+(SUM(R27:R33)/60)-O35","v":0},null,{"$f":"O37/24","v":0}]
[]
[null,"DAY OF THE WEEK","WEEK 5",null,null,null,"WEEK 6",null,null,null,"WEEK 7",null,null,null,"WEEK 8"]
[null,null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked"]
[null,null,null,null,"Hours","Minutes",null,null,"Hours","Minutes",null,null,"Hours","Minutes",null,null,"Hours","Minutes"]
[null,"Monday ",null,null,{"$f":"IF(D42=\"\",\"\",VLOOKUP(D42,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D42=\"\",\"\",VLOOKUP(D42,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H42=\"\",\"\",VLOOKUP(H42,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H42=\"\",\"\",VLOOKUP(H42,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L42=\"\",\"\",VLOOKUP(L42,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L42=\"\",\"\",VLOOKUP(L42,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P42=\"\",\"\",VLOOKUP(P42,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P42=\"\",\"\",VLOOKUP(P42,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Tuesday",null,null,{"$f":"IF(D43=\"\",\"\",VLOOKUP(D43,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D43=\"\",\"\",VLOOKUP(D43,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H43=\"\",\"\",VLOOKUP(H43,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H43=\"\",\"\",VLOOKUP(H43,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L43=\"\",\"\",VLOOKUP(L43,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L43=\"\",\"\",VLOOKUP(L43,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P43=\"\",\"\",VLOOKUP(P43,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P43=\"\",\"\",VLOOKUP(P43,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Wednesday",null,null,{"$f":"IF(D44=\"\",\"\",VLOOKUP(D44,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D44=\"\",\"\",VLOOKUP(D44,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H44=\"\",\"\",VLOOKUP(H44,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H44=\"\",\"\",VLOOKUP(H44,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L44=\"\",\"\",VLOOKUP(L44,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L44=\"\",\"\",VLOOKUP(L44,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P44=\"\",\"\",VLOOKUP(P44,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P44=\"\",\"\",VLOOKUP(P44,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Thursday",null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H45=\"\",\"\",VLOOKUP(H45,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H45=\"\",\"\",VLOOKUP(H45,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L45=\"\",\"\",VLOOKUP(L45,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L45=\"\",\"\",VLOOKUP(L45,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P45=\"\",\"\",VLOOKUP(P45,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P45=\"\",\"\",VLOOKUP(P45,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Friday",null,null,{"$f":"IF(D46=\"\",\"\",VLOOKUP(D46,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D46=\"\",\"\",VLOOKUP(D46,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H46=\"\",\"\",VLOOKUP(H46,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H46=\"\",\"\",VLOOKUP(H46,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L46=\"\",\"\",VLOOKUP(L46,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L46=\"\",\"\",VLOOKUP(L46,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P46=\"\",\"\",VLOOKUP(P46,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P46=\"\",\"\",VLOOKUP(P46,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Saturday",null,null,{"$f":"IF(D47=\"\",\"\",VLOOKUP(D47,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D47=\"\",\"\",VLOOKUP(D47,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H47=\"\",\"\",VLOOKUP(H47,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H47=\"\",\"\",VLOOKUP(H47,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L47=\"\",\"\",VLOOKUP(L47,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L47=\"\",\"\",VLOOKUP(L47,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P47=\"\",\"\",VLOOKUP(P47,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P47=\"\",\"\",VLOOKUP(P47,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Sunday",null,null,{"$f":"IF(D48=\"\",\"\",VLOOKUP(D48,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D48=\"\",\"\",VLOOKUP(D48,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H48=\"\",\"\",VLOOKUP(H48,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H48=\"\",\"\",VLOOKUP(H48,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L48=\"\",\"\",VLOOKUP(L48,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L48=\"\",\"\",VLOOKUP(L48,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P48=\"\",\"\",VLOOKUP(P48,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P48=\"\",\"\",VLOOKUP(P48,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Hidded calculation row",null,null,{"$f":"TIME(0,SUM(SUMIF(D42:D48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},E42:E48)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(D42:D48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},F42:F48)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(H42:H48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},I42:I48)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(H42:H48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},J42:J48)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(L42:L48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},M42:M48)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(L42:L48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},N42:N48)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(P42:P48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},Q42:Q48)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(P42:P48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},R42:R48)),0)","v":0}]
[null,"MISSED SHIFTS TOTAL",{"$f":"E50*24","v":0},null,{"$f":"E49+F49","v":0},null,{"$f":"I50*24","v":0},null,{"$f":"I49+J49","v":0},null,{"$f":"M50*24","v":0},null,{"$f":"M49+N49","v":0},null,{"$f":"Q50*24","v":0},null,{"$f":"Q49+R49","v":0}]
[null,"NIGHT DUTY TOTAL",{"$f":"SUMIF(D$42:D$48,\"ND\",E$42:E$48)+SUMIF(D$42:D$48,\"ND\",F$42:F$48)/60","v":0},null,{"$f":"C51/24","v":0},null,{"$f":"SUMIF(H$42:H$48,\"ND\",I$42:I$48)+SUMIF(H$42:H$48,\"ND\",J$42:J$48)/60","v":0},null,{"$f":"G51/24","v":0},null,{"$f":"SUMIF(L$42:L$48,\"ND\",M$42:M$48)+SUMIF(L$42:L$48,\"ND\",N$42:N$48)/60","v":0},null,{"$f":"K51/24","v":0},null,{"$f":"SUMIF(P$42:P$48,\"ND\",Q$42:Q$48)+SUMIF(P$42:P$48,\"ND\",R$42:R$48)/60","v":0},null,{"$f":"O51/24","v":0}]
[null,"OVERALL TOTAL INC ND",{"$f":"SUM(E42:E48)+(SUM(F42:F48)/60)-C50","v":0},null,{"$f":"C52/24","v":0},null,{"$f":"SUM(I42:I48)+(SUM(J42:J48)/60)-G50","v":0},null,{"$f":"G52/24","v":0},null,{"$f":"SUM(M42:M48)+(SUM(N42:N48)/60)-K50","v":0},null,{"$f":"K52/24","v":0},null,{"$f":"SUM(Q42:Q48)+(SUM(R42:R48)/60)-O50","v":0},null,{"$f":"O52/24","v":0}]
[]
[null,"DAY OF THE WEEK","WEEK 9",null,null,null,"WEEK 10",null,null,null,"WEEK 11",null,null,null,"WEEK 12"]
[null,null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked"]
[null,null,null,null,"Hours","Minutes",null,null,"Hours","Minutes",null,null,"Hours","Minutes",null,null,"Hours","Minutes"]
[null,"Monday ",null,null,{"$f":"IF(D57=\"\",\"\",VLOOKUP(D57,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D57=\"\",\"\",VLOOKUP(D57,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H57=\"\",\"\",VLOOKUP(H57,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H57=\"\",\"\",VLOOKUP(H57,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L57=\"\",\"\",VLOOKUP(L57,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L57=\"\",\"\",VLOOKUP(L57,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P57=\"\",\"\",VLOOKUP(P57,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P57=\"\",\"\",VLOOKUP(P57,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Tuesday",null,null,{"$f":"IF(D58=\"\",\"\",VLOOKUP(D58,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D58=\"\",\"\",VLOOKUP(D58,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H58=\"\",\"\",VLOOKUP(H58,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H58=\"\",\"\",VLOOKUP(H58,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L58=\"\",\"\",VLOOKUP(L58,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L58=\"\",\"\",VLOOKUP(L58,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P58=\"\",\"\",VLOOKUP(P58,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P58=\"\",\"\",VLOOKUP(P58,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Wednesday",null,null,{"$f":"IF(D59=\"\",\"\",VLOOKUP(D59,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D59=\"\",\"\",VLOOKUP(D59,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H59=\"\",\"\",VLOOKUP(H59,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H59=\"\",\"\",VLOOKUP(H59,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L59=\"\",\"\",VLOOKUP(L59,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L59=\"\",\"\",VLOOKUP(L59,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P59=\"\",\"\",VLOOKUP(P59,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P59=\"\",\"\",VLOOKUP(P59,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Thursday",null,null,{"$f":"IF(D60=\"\",\"\",VLOOKUP(D60,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D60=\"\",\"\",VLOOKUP(D60,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H60=\"\",\"\",VLOOKUP(H60,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H60=\"\",\"\",VLOOKUP(H60,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L60=\"\",\"\",VLOOKUP(L60,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L60=\"\",\"\",VLOOKUP(L60,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P60=\"\",\"\",VLOOKUP(P60,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P60=\"\",\"\",VLOOKUP(P60,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Friday",null,null,{"$f":"IF(D61=\"\",\"\",VLOOKUP(D61,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D61=\"\",\"\",VLOOKUP(D61,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H61=\"\",\"\",VLOOKUP(H61,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H61=\"\",\"\",VLOOKUP(H61,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L61=\"\",\"\",VLOOKUP(L61,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L61=\"\",\"\",VLOOKUP(L61,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P61=\"\",\"\",VLOOKUP(P61,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P61=\"\",\"\",VLOOKUP(P61,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Saturday",null,null,{"$f":"IF(D62=\"\",\"\",VLOOKUP(D62,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D62=\"\",\"\",VLOOKUP(D62,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H62=\"\",\"\",VLOOKUP(H62,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H62=\"\",\"\",VLOOKUP(H62,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L62=\"\",\"\",VLOOKUP(L62,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L62=\"\",\"\",VLOOKUP(L62,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P62=\"\",\"\",VLOOKUP(P62,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P62=\"\",\"\",VLOOKUP(P62,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Sunday",null,null,{"$f":"IF(D63=\"\",\"\",VLOOKUP(D63,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D63=\"\",\"\",VLOOKUP(D63,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H63=\"\",\"\",VLOOKUP(H63,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H63=\"\",\"\",VLOOKUP(H63,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L63=\"\",\"\",VLOOKUP(L63,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L63=\"\",\"\",VLOOKUP(L63,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P63=\"\",\"\",VLOOKUP(P63,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P63=\"\",\"\",VLOOKUP(P63,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Hidded calculation row",null,null,{"$f":"TIME(0,SUM(SUMIF(D57:D63,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},E57:E63)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(D57:D63,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},F57:F63)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(H57:H63,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},I57:I63)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(H57:H63,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},J57:J63)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(L57:L63,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},M57:M63)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(L57:L63,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},N57:N63)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(P57:P63,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},Q57:Q63)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(P57:P63,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},R57:R63)),0)","v":0}]
[null,"MISSED SHIFTS TOTAL",{"$f":"E65*24","v":0},null,{"$f":"E64+F64","v":0},null,{"$f":"I65*24","v":0},null,{"$f":"I64+J64","v":0},null,{"$f":"M65*24","v":0},null,{"$f":"M64+N64","v":0},null,{"$f":"Q65*24","v":0},null,{"$f":"Q64+R64","v":0}]
[null,"NIGHT DUTY TOTAL",{"$f":"SUMIF(D$57:D$63,\"ND\",E$57:E$63)+SUMIF(D$57:D$63,\"ND\",F$57:F$63)/60","v":0},null,{"$f":"C66/24","v":0},null,{"$f":"SUMIF(H$57:H$63,\"ND\",I$57:I$63)+SUMIF(H$57:H$63,\"ND\",J$57:J$63)/60","v":0},null,{"$f":"G66/24","v":0},null,{"$f":"SUMIF(L$57:L$63,\"ND\",M$57:M$63)+SUMIF(L$57:L$63,\"ND\",N$57:N$63)/60","v":0},null,{"$f":"K66/24","v":0},null,{"$f":"SUMIF(P$57:P$63,\"ND\",Q$57:Q$63)+SUMIF(P$57:P$63,\"ND\",R$57:R$63)/60","v":0},null,{"$f":"O66/24","v":0}]
[null,"OVERALL TOTAL INC ND",{"$f":"SUM(E57:E63)+(SUM(F57:F63)/60)-C65","v":0},null,{"$f":"C67/24","v":0},null,{"$f":"SUM(I57:I63)+(SUM(J57:J63)/60)-G65","v":0},null,{"$f":"G67/24","v":0},null,{"$f":"SUM(M57:M63)+(SUM(N57:N63)/60)-K65","v":0},null,{"$f":"K67/24","v":0},null,{"$f":"SUM(Q57:Q63)+(SUM(R57:R63)/60)-O65","v":0},null,{"$f":"O67/24","v":0}]
[]
[null,"DAY OF THE WEEK","WEEK 13",null,null,null,"WEEK 14",null,null,null,"WEEK 15",null,null,null,"WEEK 16"]
[null,null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked",null,"Date of Shift","Code","Hours Worked"]
[null,null,null,null,"Hours","Minutes",null,null,"Hours","Minutes",null,null,"Hours","Minutes",null,null,"Hours","Minutes"]
[null,"Monday ",null,null,{"$f":"IF(D72=\"\",\"\",VLOOKUP(D72,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D72=\"\",\"\",VLOOKUP(D72,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H72=\"\",\"\",VLOOKUP(H72,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H72=\"\",\"\",VLOOKUP(H72,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L72=\"\",\"\",VLOOKUP(L72,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L72=\"\",\"\",VLOOKUP(L72,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P72=\"\",\"\",VLOOKUP(P72,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P72=\"\",\"\",VLOOKUP(P72,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Tuesday",null,null,{"$f":"IF(D73=\"\",\"\",VLOOKUP(D73,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D73=\"\",\"\",VLOOKUP(D73,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H73=\"\",\"\",VLOOKUP(H73,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H73=\"\",\"\",VLOOKUP(H73,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L73=\"\",\"\",VLOOKUP(L73,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L73=\"\",\"\",VLOOKUP(L73,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P73=\"\",\"\",VLOOKUP(P73,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P73=\"\",\"\",VLOOKUP(P73,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Wednesday",null,null,{"$f":"IF(D74=\"\",\"\",VLOOKUP(D74,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D74=\"\",\"\",VLOOKUP(D74,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H74=\"\",\"\",VLOOKUP(H74,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H74=\"\",\"\",VLOOKUP(H74,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L74=\"\",\"\",VLOOKUP(L74,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L74=\"\",\"\",VLOOKUP(L74,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P74=\"\",\"\",VLOOKUP(P74,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P74=\"\",\"\",VLOOKUP(P74,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Thursday",null,null,{"$f":"IF(D75=\"\",\"\",VLOOKUP(D75,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D75=\"\",\"\",VLOOKUP(D75,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H75=\"\",\"\",VLOOKUP(H75,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H75=\"\",\"\",VLOOKUP(H75,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L75=\"\",\"\",VLOOKUP(L75,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L75=\"\",\"\",VLOOKUP(L75,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P75=\"\",\"\",VLOOKUP(P75,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P75=\"\",\"\",VLOOKUP(P75,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Friday",null,null,{"$f":"IF(D76=\"\",\"\",VLOOKUP(D76,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D76=\"\",\"\",VLOOKUP(D76,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H76=\"\",\"\",VLOOKUP(H76,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H76=\"\",\"\",VLOOKUP(H76,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L76=\"\",\"\",VLOOKUP(L76,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L76=\"\",\"\",VLOOKUP(L76,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P76=\"\",\"\",VLOOKUP(P76,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P76=\"\",\"\",VLOOKUP(P76,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Saturday",null,null,{"$f":"IF(D77=\"\",\"\",VLOOKUP(D77,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D77=\"\",\"\",VLOOKUP(D77,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H77=\"\",\"\",VLOOKUP(H77,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H77=\"\",\"\",VLOOKUP(H77,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L77=\"\",\"\",VLOOKUP(L77,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L77=\"\",\"\",VLOOKUP(L77,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P77=\"\",\"\",VLOOKUP(P77,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P77=\"\",\"\",VLOOKUP(P77,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Sunday",null,null,{"$f":"IF(D78=\"\",\"\",VLOOKUP(D78,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(D78=\"\",\"\",VLOOKUP(D78,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(H78=\"\",\"\",VLOOKUP(H78,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(H78=\"\",\"\",VLOOKUP(H78,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(L78=\"\",\"\",VLOOKUP(L78,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(L78=\"\",\"\",VLOOKUP(L78,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,{"$f":"IF(P78=\"\",\"\",VLOOKUP(P78,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(P78=\"\",\"\",VLOOKUP(P78,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Hidded calculation row",null,null,{"$f":"TIME(0,SUM(SUMIF(D72:D78,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},E72:E78)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(D72:D78,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},F72:F78)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(H72:H78,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},I72:I78)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(H72:H78,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},J72:J78)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(L72:L78,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},M72:M78)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(L72:L78,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},N72:N78)),0)","v":0},null,null,{"$f":"TIME(0,SUM(SUMIF(P72:P78,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},Q72:Q78)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(P72:P78,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},R72:R78)),0)","v":0}]
[null,"MISSED SHIFTS TOTAL",{"$f":"E80*24","v":0},null,{"$f":"E79+F79","v":0},null,{"$f":"I80*24","v":0},null,{"$f":"I79+J79","v":0},null,{"$f":"M80*24","v":0},null,{"$f":"M79+N79","v":0},null,{"$f":"Q80*24","v":0},null,{"$f":"Q79+R79","v":0}]
[null,"NIGHT DUTY TOTAL",{"$f":"SUMIF(D$72:D$78,\"ND\",E$72:E$78)+SUMIF(D$72:D$78,\"ND\",F$72:F$78)/60","v":0},null,{"$f":"C81/24","v":0},null,{"$f":"SUMIF(H$72:H$78,\"ND\",I$72:I$78)+SUMIF(H$72:H$78,\"ND\",J$72:J$78)/60","v":0},null,{"$f":"G81/24","v":0},null,{"$f":"SUMIF(L$72:L$78,\"ND\",M$72:M$78)+SUMIF(L$72:L$78,\"ND\",N$72:N$78)/60","v":0},null,{"$f":"K81/24","v":0},null,{"$f":"SUMIF(P$72:P$78,\"ND\",Q$72:Q$78)+SUMIF(P$72:P$78,\"ND\",R$72:R$78)/60","v":0},null,{"$f":"O81/24","v":0}]
[null,"OVERALL TOTAL INC ND",{"$f":"SUM(E72:E78)+(SUM(F72:F78)/60)-C80","v":0},null,{"$f":"C82/24","v":0},null,{"$f":"SUM(I72:I78)+(SUM(J72:J78)/60)-G80","v":0},null,{"$f":"G82/24","v":0},null,{"$f":"SUM(M72:M78)+(SUM(N72:N78)/60)-K80","v":0},null,{"$f":"K82/24","v":0},null,{"$f":"SUM(Q72:Q78)+(SUM(R72:R78)/60)-O80","v":0},null,{"$f":"O82/24","v":0}]
[]
[null,"NOTES - PLEASE FEEL FREE TO USE THE BELOW FOR ANY INFORMATION YOU FEEL WE REQUIRE WITH REGARDS TO YOUR PLACEMENT TIMESHEET"]
[]
[]
[]
[]
[]
[null,"Please complete this form at the end of your placement block.  Ask your supervisor to sign it , then scan this in and and return this electronically as soon as possible via email to: HWB-AHPTimesheets@shu.ac.uk "]
[]
[]
[]
[null,"Student Signature:"]
[]
[null,"Date:"]
[]
[]
[null,"Educator Signature:"]
[]
[null,"Educator Name:"]
[]
[null,"Date:"]
[]
[null,"EDUCATOR: PLEASE NOTE - By signing this form you are confirming that this is an accurate reflection of the hours completed by the student"]

{"sheet":"Look Up Lists","index":1,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["CODES","DESCRIPTION","HOURS","MINUTES"]
["BH","Bank Holiday",7,30]
["INT","Interview"]
["MT","Makeup time"]
["ND","Night Duty"]
["SD","Study Day"]
["A","Absent",7,30]
["AA","Authorised Absence",7,30]
["ASA","Approved SHU Attendance ",7,30]
["CL","Compassionate Leave",7,30]
["NCP","Not Cleared for Placement",7,30]
["S","Sick",7,30]
["SL","Special Leave",7,30]
[]
[]
["COURSE"]
["BSC HON OCCUPATIONAL THERAPY "]
["MSC OCCUPATIONAL THERAPY"]
["DA OCCUPATIONAL THERAPY"]
[]
["COHORT"]
["2017 September"]
["2018 January"]
["2018 September"]
["2019 January"]
["2019 September"]
["2020 January"]
["2020 September"]
["2021 January"]
["2021 September"]
["2022 January"]
["2022 September"]
[]
[]
["PLACEMENT BLOCK "]
["Year/Block 1 - Placement 1"]
["Year/Block 1 - Placement 2"]
["Year/Block 2 - Placement 1"]
["Year/Block 2 - Placement 2"]
["Year/Block 3 - Placement 1"]
["Year/Block 3 - Placement 2"]
["Year/Block 3 - Placement 3"]