{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Spend Tracker","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":"Spend Tracker","index":0,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[8,2,8,3],[12,2,12,3],[9,2,9,3],[13,2,13,3],[10,2,10,3],[11,2,11,3],[27,1,27,3],[25,1,25,3],[26,1,26,3],[14,2,14,3],[17,2,17,3],[16,2,16,3],[23,1,23,3],[24,1,24,3],[15,2,15,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3]]}
["Hertfordshire County Council - Winter Support Discharge Funding"]
[]
[null,"This form is designed to enable you to claim the Winter Support Discharge Funding. You are required to complete this form and submit it alongside an invoice by 7th January 2023"]
[]
[null,"Submitting this form and an invoice is acceptance of the grant conditions. Please send both to ACS.CarePayments@hertfordshire.gov.uk "]
[]
[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,"Contact Name"]
[null,"Contact Telephone number",null,null," "]
[null,"Contact Email Address"]
[]
[null,"Number of full time equivalent FRONTLINE staff",null,null,"In cell L16, input the no. of hours worked per week to calculate an individual's FTE",null,null,null,null,null,null,null,{"$f":"IF(L16>25,1,(L16/25))","v":0},"FTE"]
[null,"Frontline staff funding",{"$f":"C16*(300)","v":0}]
[]
[null,"Number of full time equivalent SUPPORT staff",null,null,"Examples of support staff could include domestic, kitchen and admin roles"]
[null,"Support staff funding",{"$f":"C19*(300)","v":0}]
[]
[null,"Total allocation of funding to be invoiced for",{"$f":"C20+C17","v":0}]
[]
[null,"Measures",null,null,"Amount £"]
["Retention bonuses","Retention bonuses",null,{"$f":"SUMIFS(#REF!,#REF!,A25)","v":{"$error":"#REF!"}}]
["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!,#REF!,A26)","v":{"$error":"#REF!"}}]
["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!,#REF!,A27)","v":{"$error":"#REF!"}}]
[null,"Totals",null,{"$f":"SUM(D25:D27)","v":{"$error":"#REF!"}},{"$f":"SUM(E25:E27)","v":0}]

{"sheet":"Sheet1","index":1,"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 "]