{"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":76,"n_cols":17,"rows_kept":76,"cut":false,"hidden":false,"merged":[[51,2,51,3],[51,4,51,5],[51,9,51,10],[12,15,12,17],[50,14,50,15],[39,9,39,10],[49,2,49,3],[49,4,49,5],[49,9,49,10],[50,2,50,3],[50,4,50,5],[35,9,35,10],[34,9,34,10],[50,9,50,10],[39,7,40,7],[39,8,40,8],[17,15,17,17],[8,15,8,17],[14,15,14,17],[24,12,25,12],[23,1,25,1],[9,15,9,17],[15,1,15,3],[16,1,16,3],[14,1,14,3],[0,1,0,17],[7,2,7,5],[2,1,2,17],[11,2,11,5],[8,2,9,5],[8,1,9,1],[10,14,10,17],[6,2,6,5],[4,14,4,17],[5,2,5,5],[4,1,4,5],[7,15,7,17],[11,15,11,17],[5,15,5,17],[6,15,6,17],[20,1,20,17],[13,15,13,17],[24,7,25,7],[24,8,25,8],[24,9,24,10],[24,3,25,3],[24,4,24,5],[24,2,25,2],[17,1,17,3],[4,7,17,12],[10,2,10,5],[19,0,19,18],[24,13,25,13],[24,14,24,15],[16,15,16,17],[15,15,15,17],[22,1,22,16],[23,2,23,6],[23,7,23,11],[23,12,23,16],[38,2,38,6],[38,7,38,11],[38,12,38,16],[38,1,40,1],[39,2,40,2],[39,3,40,3],[39,12,40,12],[39,13,40,13],[39,14,39,15],[39,4,39,5],[35,4,35,5],[36,4,36,5],[64,12,74,16],[54,14,59,14],[52,14,53,14],[37,15,37,16],[60,1,63,17],[22,17,51,18],[49,14,49,15],[51,14,51,15],[34,2,34,3],[35,2,35,3],[36,2,36,3],[34,4,34,5],[36,14,36,15],[35,14,35,15],[34,14,34,15],[36,9,36,10]]}
[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,"Hours","Minutes",null,null,null,null,null,null,null,null,"CL","Compassionate Leave"]
[null,"MISSED SHIFTS FROM PLACEMENT",null,null,null,null,null,null,null,null,null,null,null,null,"NCP","Not Clear for Placement"]
[null,"NIGHT DUTY HOURS COMPLETED",null,null,null,null,null,null,null,null,null,null,null,null,"S","Sick"]
[null,"PLACEMENT HOURS ATTENDED",null,null,null,null,null,null,null,null,null,null,null,null,"SL","Special Leave"]
[]
["After completion of your 'Placement Timesheet' please submit electionically to the below:"]
[null,"HWB-AHPTimesheets@shu.ac.uk "]
[]
[null,"RECORD OF YOUR PLACEMENT HOURS"]
[null,"DAY OF THE WEEK","WEEK 1",null,null,null,null,"WEEK 2",null,null,null,null,"WEEK 3"]
[null,null,"Date of Shift","Code","Hours Worked",null,null,"Date of Shift","Code","Hours Worked",null,null,"Date of Shift","Code","Hours Worked"]
[null,null,null,null,"Hours","Minutes","Initials",null,null,"Hours","Minutes","Initials",null,null,"Hours","Minutes","Initials"]
[null,"Monday ",null,null,null,null,null,null,null,{"$f":"IF(I27=\"\",\"\",VLOOKUP(I27,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I27=\"\",\"\",VLOOKUP(I27,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N27=\"\",\"\",VLOOKUP(N27,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N27=\"\",\"\",VLOOKUP(N27,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Tuesday",null,null,null,null,null,null,null,{"$f":"IF(I28=\"\",\"\",VLOOKUP(I28,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I28=\"\",\"\",VLOOKUP(I28,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N28=\"\",\"\",VLOOKUP(N28,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N28=\"\",\"\",VLOOKUP(N28,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Wednesday",null,null,null,null,null,null,null,{"$f":"IF(I29=\"\",\"\",VLOOKUP(I29,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I29=\"\",\"\",VLOOKUP(I29,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N29=\"\",\"\",VLOOKUP(N29,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N29=\"\",\"\",VLOOKUP(N29,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""}]
[null,"Thursday",null,null,null,null,null,null,null,{"$f":"IF(I30=\"\",\"\",VLOOKUP(I30,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I30=\"\",\"\",VLOOKUP(I30,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N30=\"\",\"\",VLOOKUP(N30,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N30=\"\",\"\",VLOOKUP(N30,'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,null,{"$f":"IF(I31=\"\",\"\",VLOOKUP(I31,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I31=\"\",\"\",VLOOKUP(I31,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N31=\"\",\"\",VLOOKUP(N31,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N31=\"\",\"\",VLOOKUP(N31,'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,null,{"$f":"IF(I32=\"\",\"\",VLOOKUP(I32,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I32=\"\",\"\",VLOOKUP(I32,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N32=\"\",\"\",VLOOKUP(N32,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N32=\"\",\"\",VLOOKUP(N32,'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,null,{"$f":"IF(I33=\"\",\"\",VLOOKUP(I33,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I33=\"\",\"\",VLOOKUP(I33,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N33=\"\",\"\",VLOOKUP(N33,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N33=\"\",\"\",VLOOKUP(N33,'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,null,{"$f":"TIME(0,SUM(SUMIF(I27:I33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},J27:J33)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(I27:I33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},K27:K33)),0)","v":0},null,null,null,{"$f":"TIME(0,SUM(SUMIF(N27:N33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},O27:O33)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(N27:N33,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},P27:P33)),0)","v":0}]
[null,"MISSED SHIFTS TOTAL"]
[null,"NIGHT DUTY TOTAL"]
[null,"OVERALL TOTAL INC ND"]
[]
[null,"DAY OF THE WEEK","WEEK 4",null,null,null,null,"WEEK 5",null,null,null,null,"WEEK 6"]
[null,null,"Date of Shift","Code","Hours Worked",null,null,"Date of Shift","Code","Hours Worked",null,null,"Date of Shift","Code","Hours Worked"]
[null,null,null,null,"Hours","Minutes","Initials",null,null,"Hours","Minutes","Initials",null,null,"Hours","Minutes","Initials"]
[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,null,{"$f":"IF(I42=\"\",\"\",VLOOKUP(I42,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I42=\"\",\"\",VLOOKUP(I42,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N42=\"\",\"\",VLOOKUP(N42,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N42=\"\",\"\",VLOOKUP(N42,'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,null,{"$f":"IF(I43=\"\",\"\",VLOOKUP(I43,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I43=\"\",\"\",VLOOKUP(I43,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N43=\"\",\"\",VLOOKUP(N43,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N43=\"\",\"\",VLOOKUP(N43,'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,null,{"$f":"IF(I44=\"\",\"\",VLOOKUP(I44,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I44=\"\",\"\",VLOOKUP(I44,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N44=\"\",\"\",VLOOKUP(N44,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N44=\"\",\"\",VLOOKUP(N44,'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,null,{"$f":"IF(I45=\"\",\"\",VLOOKUP(I45,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I45=\"\",\"\",VLOOKUP(I45,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N45=\"\",\"\",VLOOKUP(N45,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N45=\"\",\"\",VLOOKUP(N45,'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,null,{"$f":"IF(I46=\"\",\"\",VLOOKUP(I46,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I46=\"\",\"\",VLOOKUP(I46,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N46=\"\",\"\",VLOOKUP(N46,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N46=\"\",\"\",VLOOKUP(N46,'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,null,{"$f":"IF(I47=\"\",\"\",VLOOKUP(I47,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I47=\"\",\"\",VLOOKUP(I47,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N47=\"\",\"\",VLOOKUP(N47,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N47=\"\",\"\",VLOOKUP(N47,'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,null,{"$f":"IF(I48=\"\",\"\",VLOOKUP(I48,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(I48=\"\",\"\",VLOOKUP(I48,'Look Up Lists'!$A$2:$D$13,4,FALSE))","v":""},null,null,null,{"$f":"IF(N48=\"\",\"\",VLOOKUP(N48,'Look Up Lists'!$A$2:$D$13,3,FALSE))","v":""},{"$f":"IF(N48=\"\",\"\",VLOOKUP(N48,'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,null,{"$f":"TIME(0,SUM(SUMIF(I42:I48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},J42:J48)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(I42:I48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},K42:K48)),0)","v":0},null,null,null,{"$f":"TIME(0,SUM(SUMIF(N42:N48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},O42:O48)),0)*60","v":0},{"$f":"TIME(0,SUM(SUMIF(N42:N48,{\"A\",\"AA\",\"CL\",\"NCP\",\"S\",\"SL\"},P42:P48)),0)","v":0}]
[null,"MISSED SHIFTS TOTAL"]
[null,"NIGHT DUTY TOTAL"]
[null,"OVERALL TOTAL INC ND"]
[]
[]
[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":36,"n_cols":4,"rows_kept":36,"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 OPERATING DEPARTMENT PRACTICE"]
[]
["COHORT"]
["2015 September"]
["2016 September"]
["2017 September"]
["2018 September"]
["2019 September"]
["2020 September"]
[]
["PLACEMENT BLOCK "]
["Year/Block 1 - Placement 1"]
["Year/Block 1 - Placement 2"]
["Year/Block 1 - Placement 3"]
["Year/Block 2 - Placement 1"]
["Year/Block 2 - Placement 2"]
["Year/Block 2 - Placement 3"]
["Year/Block 3 - Placement 1"]
["Year/Block 3 - Placement 2"]
["Year/Block 3 - Placement 3"]