{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Template for Completion","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":148,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Hertfordshire County Council - Workforce Recruitment and Retention Fund"]
[]
[null,"This spend tracker is designed to help you capture and classify all the costs that you wish to claim from the Workforce Recruitment and Retention Fund."]
[]
[null,"You are required to complete two spend trackers:"]
[]
[null,"Reporting Point","Provider Deadline","Information Required"]
[null,"Submission 1 - Planned spend tracker","2021-12-15","Plan of spend "]
[null,"Submission 2 - Actual spend tracker ","2022-02-28","Actual spend"]
[]
[null,"Returning the spend trackers is acceptance of the grant conditions. Please send the completed trackers back to ACS.CarePayments@hertfordshire.gov.uk "]
[]
[null,"Instructions for completing the 'Template for Completion' tab"]
[]
[null,"Type of Provider","Please type in the type of care provided e.g. care home, supported living, home care"]
[null,"Provider Name","Please type in the name of the provider"]
[null,"Name of Home/Service","Please type in the name of the home or service"]
[null,"Number of full time equivalent care professionals","Please state the number of full time equivalent care professionals in your service between 1 December 2021 and 28 February 2022"]
[null,"Contact Name","Please type in name to contact for any queries"]
[null,"Contact Telephone number","Please type in telephone number to contact above person for any queries"]
[null,"Contact Email Address","Please type in email address to contact above person for any queries"]
[]
[null,"Any 'baseline' and 'planned' columns need to be completed for the December submission"]
[null,"A condition of the grant is that we need to know how many staff left care providers during the baseline period, which is September 21"]
[]
[null,"Any 'actual' columns need to be completed for the February submission"]
[]
[null,"Note: green cells will populate automatically therefore, please do not type figures into these cells  "]

{"sheet":"Template for Completion","index":1,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[30,1,30,3],[28,1,28,3],[29,1,29,3],[11,2,11,3],[14,2,14,3],[13,2,13,3],[15,2,15,3],[21,1,21,2],[22,1,22,2],[26,1,26,3],[27,1,27,3],[20,1,20,2],[8,2,8,3],[16,2,16,3],[9,2,9,3],[17,2,17,3],[10,2,10,3],[12,2,12,3]]}
["Hertfordshire County Council - Workforce Recruitment and Retention Fund"]
[]
[null,"Any 'baseline' and 'planned' columns need to be completed for the December submission"]
[]
[null,"Any 'actual' columns need to be completed for the February submission"]
[]
[null,"Note: green cells will populate automatically therefore, please do not type figures into these cells  "]
[]
[null,"Type of Provider"]
[null,"Provider Name"]
[null,"Name of Care Home or Service"]
[]
[null,"Number of full time equivalent care professionals*",null,null,"*Please submit an extract from your payroll demonstrating expenditure incurred on retention bonuses & other eligible spend, alongside your February submission"]
[null,"Total allocation of funding",{"$f":"C13*(400)","v":0}]
[]
[null,"Contact Name"]
[null,"Contact Telephone number"]
[null,"Contact Email Address"]
[]
[null,null,null,"Baseline \n(September 21)","Planned\n (November 21-March 22)","Actual \n (November 21-March 22)"]
[null,"Total Number of Full time equivalent care professionals* paid"]
[null,"Total (estimated) number of additional care hours generated"]
[null,"Total number of staff that have left "]
[]
[null,"Expenditure Summary "]
[]
[null,"Measures",null,null,"Planned Expenditure\n (November 21-March 22)","Actual Expenditure\n (November 21-March 22)"]
["Retention bonuses","Retention bonuses",null,{"$f":"SUMIFS(#REF!,$B$36:$B$45,A28)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS($H$36:$H$45,$B$36:$B$45,A28)","v":0}]
["Shift-enhancement measures e.g. bank holiday enhancementsiting all staff movement between settings unless absolutely necessary","Shift-enhancement measures e.g. bank holiday enhancements",null,{"$f":"SUMIFS(#REF!,$B$36:$B$45,A29)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS($H$36:$H$45,$B$36:$B$45,A29)","v":0}]
["Employer on-costs for bonuses / shift enhancements miting or cohorting staff to individual groups of residents or floors/wings, including segregation of COVID-19 positive residents","Employer on-costs for bonuses / shift enhancements ",null,{"$f":"SUMIFS(#REF!,$B$36:$B$45,A30)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS($H$36:$H$45,$B$36:$B$45,A30)","v":0}]
[null,"Totals",null,{"$f":"SUM(D28:D30)","v":{"$error":"#REF!"}},{"$f":"SUM(E28:E30)","v":0},{"$f":"SUM(F28:F30)","v":0}]
[]
[null,"Details of actual expenditure - only to be completed on actual spend tracker (February submission)"]
[]
[null,"Category of Expenditure*\nMust be completed - Use Dropdown","November 2021","December 2021","January 2022","February 2022","March 2022","Total"]
[null,null,null,null,null,null,null,{"$f":"SUM(C36:G36)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C37:G37)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]

{"sheet":"Sheet1","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Retention bonuses"]
["Shift-enhancement measures"]
["Employer on-costs for bonuses / shift enhancements "]