{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["1 About","2. Select period","3 Service users","3 Frontline staff","3 Backoffice staff","3 Other","4 Unit costs"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"1 About","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"2. Select period","index":1,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Time period"]
[]
[null,"What is the time period you want to report for?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Duration"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 months (quarterly)",1,{"$f":"IF(Q17=1,\"_____(select period first)\",IF(AND(Q17>1,Q17<6),\"quarter\",\"year\"))","v":"_____(select period first)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 months (quarterly)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9 months (quarterly)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 year (quarterly)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 year (annually)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 years"]

{"sheet":"3 Service users","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Service users"]
[]
[]
[]
[]
[null,null,{"$f":"IF('2. Select period'!$Q$17=1,\"\",IF(AND('2. Select period'!$Q$17>1,'2. Select period'!$Q$17<6),\"Q1\",\"Year 1\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>2,'2. Select period'!$Q$17<6),\"Q2\",IF('2. Select period'!$Q$17>6,\"Year 2\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>3,'2. Select period'!$Q$17<6),\"Q3\",IF('2. Select period'!$Q$17>7,\"Year 3\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>4,'2. Select period'!$Q$17<6),\"Q4\",IF('2. Select period'!$Q$17>8,\"Year 4\",\"\"))","v":""},{"$f":"IF('2. Select period'!$Q$17>9,\"Year 5\",\"\")","v":""}]
[null,"Number of people expected to be working with",null,null,null,null,null,"Input numbers here"]

{"sheet":"3 Frontline staff","index":3,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Frontline staff"]
[]
[null,"This section works out the annual average costs of frontline staff. "]
[]
[null,"A. Employer National Insurance"]
[null,"The employer National Insurance has been set at 13.8% (as of 2020/2021) but you can enter a different amount manually. "]
[]
[null,"Employer National Insurance",0.13800000000000001]
[]
[null,"B. Annual costs per member of staff"]
[]
[null,"If you are reporting multiple years, please provide costs for the first year of the project."]
[]
[null,"Name or grade of role","Salary","National Insurance","Pension","Total salary and oncosts","% of time spent on project","Total project costs"]
[null,"Project assistant",null,{"$f":"IF(ISBLANK(C26),\"\",C26*$C$19)","v":""},null,{"$f":"IF(ISBLANK(C26),\"\",SUM(C26:E26))","v":""},null,{"$f":"IF(ISBLANK(C26),\"\",F26*G26)","v":""},null,"Input numbers into the grey cells"]
[null,null,null,{"$f":"IF(ISBLANK(C27),\"\",C27*$C$19)","v":""},null,{"$f":"IF(ISBLANK(C27),\"\",SUM(C27:E27))","v":""},null,{"$f":"IF(ISBLANK(C27),\"\",F27*G27)","v":""}]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,"Total annual staff costs",{"$f":"SUM(C26:C37)","v":0},{"$f":"SUM(D26:D37)","v":0},0,0,null,{"$f":"SUM(H26:H37)","v":0}]
[]
[null,"C. Total costs"]
[]
[null,"If project runs over multiple years, please estimate the average annual % increase in staff costs, eg. due to salary rises"]
[null,"Annual % increase in staff costs",0]
[]
[]
[null,"Type of cost",{"$f":"IF('2. Select period'!$Q$17=1,\"\",IF(AND('2. Select period'!$Q$17>1,'2. Select period'!$Q$17<6),\"Q1\",\"Year 1\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>2,'2. Select period'!$Q$17<6),\"Q2\",IF('2. Select period'!$Q$17>6,\"Year 2\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>3,'2. Select period'!$Q$17<6),\"Q3\",IF('2. Select period'!$Q$17>7,\"Year 3\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>4,'2. Select period'!$Q$17<6),\"Q4\",IF('2. Select period'!$Q$17>8,\"Year 4\",\"\"))","v":""},{"$f":"IF('2. Select period'!$Q$17>9,\"Year 5\",\"\")","v":""},"Total"]
[null,"Total frontline salary and oncosts (including annual rise if multiple years)",{"$f":"IF(C46=\"Year 1\",$H$38,IF(C46=\"Q1\",$H$38/4,\"\"))","v":""},{"$f":"IF(D46=\"Year 2\",$H$38*(1+C43),IF(D46=\"Q2\",$H$38/4,\"\"))","v":""},{"$f":"IF(E46=\"Year 3\",D47*(1+C43),IF(E46=\"Q3\",$H$38/4,\"\"))","v":""},{"$f":"IF(F46=\"Year 4\",E47*(1+C43),IF(F46=\"Q4\",$H$38/4,\"\"))","v":""},{"$f":"IF(G46=\"Year 5\",F47*(1+C43),\"\")","v":""},{"$f":"SUM(C47:G47)","v":0},"   Input numbers into the grey cells"]
[null,"Recruitment",null,null,null,null,null,{"$f":"SUM(C48:G48)","v":0}]
[null,"Registrations costs/DBS",null,null,null,null,null,0]
[null,"Training",null,null,null,null,null,0]
[null,"Travel and subsidience",null,null,null,null,null,0]
[null,"IT",null,null,null,null,null,0]
[null,"Personal equipment",null,null,null,null,null,0]
[null,"Other management support",null,null,null,null,null,0]
[null,"Printing, copying, post & stationary",null,null,null,null,null,0]
[null,"Telephones",null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0,"  add items as needed"]
[null,null,null,null,null,null,null,0,"  add items as needed"]
[null,null,null,null,null,null,null,0,"  add items as needed"]
[null,null,null,null,null,null,null,0,"  add items as needed"]
[null,"Total",{"$f":"IF(C46=\"\",\"\",SUM(C47:C61))","v":""},{"$f":"IF(D46=\"\",\"\",SUM(D47:D61))","v":""},"",{"$f":"IF(F46=\"\",\"\",SUM(F47:F61))","v":""},{"$f":"IF(G46=\"\",\"\",SUM(G47:G61))","v":""},{"$f":"SUM(H47:H61)","v":0}]

{"sheet":"3 Backoffice staff","index":4,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Backoffice staff"]
[]
[null,"This section works out the annual average costs of backoffice staff. For example, this includes time a CEO or marketing officer would spend on a specific project."]
[]
[null,"A. Employer National Insurance"]
[null,"The employer National Insurance has been set at 13.8% (as of 2020/2021) but you can enter a different amount manually. "]
[]
[null,"Employer National Insurance",0.13800000000000001]
[]
[null,"B. Annual costs per member of staff"]
[]
[null,"If multiple years, please provide costs for the first year of the project."]
[]
[null,"Name or grade of role","Salary","National Insurance","Pension","Total salary and oncosts","% of time spent on project","Total project costs"]
[null,null,null,{"$f":"IF(ISBLANK(C26),\"\",C26*$C$19)","v":""},null,{"$f":"IF(ISBLANK(C26),\"\",SUM(C26:E26))","v":""},null,{"$f":"IF(ISBLANK(C26),\"\",F26*G26)","v":""},null,"Input numbers into the grey cells"]
[null,null,null,{"$f":"IF(ISBLANK(C27),\"\",C27*$C$19)","v":""},null,{"$f":"IF(ISBLANK(C27),\"\",SUM(C27:E27))","v":""},null,{"$f":"IF(ISBLANK(C27),\"\",F27*G27)","v":""}]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,"Total annual staff costs",{"$f":"SUM(C26:C37)","v":0},{"$f":"SUM(D26:D37)","v":0},0,0,null,0]
[]
[null,"C. Total costs"]
[]
[null,"If project runs over multiple years, please estimate the annual % increase in staff costs"]
[null,"Annual % increase in staff costs",0]
[]
[]
[null,"Type of cost",{"$f":"IF('2. Select period'!$Q$17=1,\"\",IF(AND('2. Select period'!$Q$17>1,'2. Select period'!$Q$17<6),\"Q1\",\"Year 1\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>2,'2. Select period'!$Q$17<6),\"Q2\",IF('2. Select period'!$Q$17>6,\"Year 2\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>3,'2. Select period'!$Q$17<6),\"Q3\",IF('2. Select period'!$Q$17>7,\"Year 3\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>4,'2. Select period'!$Q$17<6),\"Q4\",IF('2. Select period'!$Q$17>8,\"Year 4\",\"\"))","v":""},{"$f":"IF('2. Select period'!$Q$17>9,\"Year 5\",\"\")","v":""},"Total"]
[null,"Total frontline salary and oncosts (including annual rise if multiple years)",{"$f":"IF(C46=\"Year 1\",$H$38,IF(C46=\"Q1\",$H$38/4,\"\"))","v":""},{"$f":"IF(D46=\"Year 2\",$H$38*(1+C43),IF(D46=\"Q2\",$H$38/4,\"\"))","v":""},{"$f":"IF(E46=\"Year 3\",D47*(1+C43),IF(E46=\"Q3\",$H$38/4,\"\"))","v":""},{"$f":"IF(F46=\"Year 4\",E47*(1+C43),IF(F46=\"Q4\",$H$38/4,\"\"))","v":""},{"$f":"IF(G46=\"Year 5\",F47*(1+C43),\"\")","v":""},{"$f":"SUM(C47:F47)","v":0},"   Input numbers into the grey cells"]
[null,"Recruitment",null,null,null,null,null,{"$f":"SUM(C48:F48)","v":0}]
[null,"Registrations costs/DBS",null,null,null,null,null,0]
[null,"Training",null,null,null,null,null,0]
[null,"Travel and subsidience",null,null,null,null,null,0]
[null,"IT",null,null,null,null,null,0]
[null,"Personal equipment",null,null,null,null,null,0]
[null,"Other management support",null,null,null,null,null,0]
[null,"Printing, copying, post & stationary",null,null,null,null,null,0]
[null,"Telephones",null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0,"  add items as needed"]
[null,null,null,null,null,null,null,0,"  add items as needed"]
[null,null,null,null,null,null,null,0,"  add items as needed"]
[null,null,null,null,null,null,null,0,"  add items as needed"]
[null,"Total",{"$f":"IF(C46=\"\",\"\",SUM(C47:C61))","v":""},{"$f":"IF(D46=\"\",\"\",SUM(D47:D61))","v":""},"","","",{"$f":"SUM(H47:H61)","v":0}]

{"sheet":"3 Other","index":5,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Other costs"]
[]
[null,"In this section add in the costs associated with your project that have not been included before. "]
[null,"Don’t forget to think about beneficiary costs such as travel, incentives or registrations for courses and qualifications"]
[]
[]
[]
[null,"Item",{"$f":"IF('2. Select period'!$Q$17=1,\"\",IF(AND('2. Select period'!$Q$17>1,'2. Select period'!$Q$17<6),\"Q1\",\"Year 1\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>2,'2. Select period'!$Q$17<6),\"Q2\",IF('2. Select period'!$Q$17>6,\"Year 2\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>3,'2. Select period'!$Q$17<6),\"Q3\",IF('2. Select period'!$Q$17>7,\"Year 3\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>4,'2. Select period'!$Q$17<6),\"Q4\",IF('2. Select period'!$Q$17>8,\"Year 4\",\"\"))","v":""},{"$f":"IF('2. Select period'!$Q$17>9,\"Year 5\",\"\")","v":""},"Total"]
[null,"Accountancy & Auditing",null,null,null,null,null,{"$f":"SUM(C20:F20)","v":0},null,"Input numbers into the grey cells"]
[null,"Bank charges",null,null,null,null,null,{"$f":"SUM(C21:F21)","v":0}]
[null,"Evaluation",null,null,null,null,null,0]
[null,"Governance and management costs",null,null,null,null,null,0]
[null,"Irrecoverable VAT and bad debt",null,null,null,null,null,0]
[null,"Cleaning",null,null,null,null,null,0]
[null,"Heating & Lighting",null,null,null,null,null,0]
[null,"Maintenance & Repairs",null,null,null,null,null,0]
[null,"Rates",null,null,null,null,null,0]
[null,"Rent",null,null,null,null,null,0]
[null,"Office equipment & IT not included above",null,null,null,null,null,0]
[null,"Website/hosting/maintenance",null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,"  add items as needed"]
[null,null,null,null,null,null,null,0,null,"  add items as needed"]
[null,null,null,null,null,null,null,0,null,"  add items as needed"]
[null,null,null,null,null,null,null,0,null,"  add items as needed"]
[null,"Total",{"$f":"IF(C19=\"\",\"\",SUM(C20:C36))","v":""},{"$f":"IF(D19=\"\",\"\",SUM(D20:D36))","v":""},"","","",{"$f":"SUM(H20:H36)","v":0}]

{"sheet":"4 Unit costs","index":6,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Unit costs"]
[]
[null,"Service users"]
[null,null,{"$f":"IF('2. Select period'!$Q$17=1,\"\",IF(AND('2. Select period'!$Q$17>1,'2. Select period'!$Q$17<6),\"Q1\",\"Year 1\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>2,'2. Select period'!$Q$17<6),\"Q2\",IF('2. Select period'!$Q$17>6,\"Year 2\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>3,'2. Select period'!$Q$17<6),\"Q3\",IF('2. Select period'!$Q$17>7,\"Year 3\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>4,'2. Select period'!$Q$17<6),\"Q4\",IF('2. Select period'!$Q$17>8,\"Year 4\",\"\"))","v":""},{"$f":"IF('2. Select period'!$Q$17>9,\"Year 5\",\"\")","v":""}]
[null,"Number of people expected to be working with",{"$f":"IF(C15=\"\",\"\",'3 Service users'!C18)","v":""},{"$f":"IF(D15=\"\",\"\",'3 Service users'!D18)","v":""},{"$f":"IF(E15=\"\",\"\",'3 Service users'!E18)","v":""},{"$f":"IF(F15=\"\",\"\",'3 Service users'!F18)","v":""},{"$f":"IF(G15=\"\",\"\",'3 Service users'!G18)","v":""}]
[]
[null,"Cost summary"]
[null,null,{"$f":"IF('2. Select period'!$Q$17=1,\"\",IF(AND('2. Select period'!$Q$17>1,'2. Select period'!$Q$17<6),\"Q1\",\"Year 1\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>2,'2. Select period'!$Q$17<6),\"Q2\",IF('2. Select period'!$Q$17>6,\"Year 2\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>3,'2. Select period'!$Q$17<6),\"Q3\",IF('2. Select period'!$Q$17>7,\"Year 3\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>4,'2. Select period'!$Q$17<6),\"Q4\",IF('2. Select period'!$Q$17>8,\"Year 4\",\"\"))","v":""},{"$f":"IF('2. Select period'!$Q$17>9,\"Year 5\",\"\")","v":""},"Total"]
[null,"Frontline staff",{"$f":"'3 Frontline staff'!C62","v":""},{"$f":"'3 Frontline staff'!D62","v":""},{"$f":"'3 Frontline staff'!E62","v":""},{"$f":"'3 Frontline staff'!F62","v":""},null,{"$f":"SUM(C20:F20)","v":0}]
[null,"Backoffice staff",{"$f":"'3 Backoffice staff'!C62","v":""},{"$f":"'3 Backoffice staff'!D62","v":""},{"$f":"'3 Backoffice staff'!E62","v":""},{"$f":"'3 Backoffice staff'!F62","v":""},null,{"$f":"SUM(C21:F21)","v":0}]
[null,"Other costs",{"$f":"'3 Other'!C37","v":""},{"$f":"'3 Other'!D37","v":""},{"$f":"'3 Other'!E37","v":""},{"$f":"'3 Other'!F37","v":""},null,0]
[null,"Total",{"$f":"IF(C19=\"\",\"\",SUM(C20:C22))","v":""},{"$f":"IF(D19=\"\",\"\",SUM(D20:D22))","v":""},"","","",{"$f":"SUM(H20:H22)","v":0}]
[]
[null,"Unit costs"]
[null,null,{"$f":"IF('2. Select period'!$Q$17=1,\"\",IF(AND('2. Select period'!$Q$17>1,'2. Select period'!$Q$17<6),\"Q1\",\"Year 1\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>2,'2. Select period'!$Q$17<6),\"Q2\",IF('2. Select period'!$Q$17>6,\"Year 2\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>3,'2. Select period'!$Q$17<6),\"Q3\",IF('2. Select period'!$Q$17>7,\"Year 3\",\"\"))","v":""},{"$f":"IF(AND('2. Select period'!$Q$17>4,'2. Select period'!$Q$17<6),\"Q4\",IF('2. Select period'!$Q$17>8,\"Year 4\",\"\"))","v":""},{"$f":"IF('2. Select period'!$Q$17>9,\"Year 5\",\"\")","v":""},"Average"]
[null,"Costs to deliver service per user",{"$f":"IFERROR(C23/C16,\"\")","v":""},{"$f":"IFERROR(D23/D16,\"\")","v":""},"","","",{"$f":"IFERROR(AVERAGE(C27:G27),\"\")","v":""}]