{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Final"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Final","index":0,"n_rows":28,"n_cols":24,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,16,7,16],[6,17,7,17],[6,19,6,20],[0,0,0,7],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[5,19,5,23],[6,22,6,23],[6,13,7,13],[6,14,7,14],[6,15,7,15],[4,13,4,14],[5,2,5,3],[5,5,5,12],[6,4,7,4],[8,0,13,0],[16,0,18,0],[10,5,11,5],[14,0,15,0]]}
["Social Return on Investment - The Impact Map"]
[]
[" SROI Network","Spreadsheet for developing SROI analysis.  Only to by used as part of SROI Network training. The spreadsheet does not include any guidance "]
[]
["Stage 1",null,"Stage 2",null,null,null,"Stage 3",{"$nulls":6},"Stage 4",{"$nulls":5},"Stage 5"]
["Stakeholders","Intended/unintended changes","Inputs",null,"Outputs","The Outcomes (what changes)",{"$nulls":7},"Deadweight      %","Displacement      %","Attribution      %","Drop off         %","Impact",null,"    Calculating Social Return"]
["Who will we have an effect on?                          Who will have an effect on us?","What do we think will change for them?","What will they invest?","Value £","Summary of activity in numbers","Description","Indicator","Source","Quantity","Duration","Financial Proxy","Value £","Source","What would have happened without the activity?","What activity would we displace?","Who else would contribute to  the change?","Will the outcome drop off in future years?","Quantity times financial proxy, less deadweight, displacement and attribution",null,"  Discount rate",null,3.5000000000000003E-2]
[{"$nulls":5},"what changes? (based on how stakeholders would describe the change)","How would we measure it?","Where did we get the information from?","How much change will there be?","How long will it last?","What proxy did we use to value the change?","What is the value of the change?","Where did we get the information from?",{"$nulls":6},"Year 1   (after activity)","Year 2","Year 3","Year 4","Year 5"]
["Community Meals (Meals on Wheels) users","Those at risk of malnutrition are supported to eat nutritious meals","cost of meals",833225.6,null,"Reduction in those at risk of malnutrition/dehydration","Reduction in Malnutrition score from assessment (PROXY: Numbers who receive support to eat their meal (approx 15% of all those who receive meals(1416))","Malnutrition assessment tool (PROXY: Social care database)",207,1,"Increase in QALY",1330,"Quality of  Life research",0.05,0,0.15,0,{"$f":"I9*L9*(1-N9)*(1-O9)*(1-P9)","v":222312.82499999998},null,{"$f":"IF(J9>=1,R9,0)","v":222312.82499999998},{"$f":"IF(J9>1,T9,0)*(1-Q9)","v":0},{"$f":"IF(J9>2,U9,0)*(1-Q9)","v":0},{"$f":"IF(J9>3,V9,0)*(1-Q9)","v":0},{"$f":"IF(J9>4,W9,0)*(1-Q9)","v":0}]
[null,"Older people have someone to carry out basic tasks to help them live independently",null,null,"Total Number who receive meals =  1416","Support to live independently","Number who live in their own home for longer than expected (baseline) and feel more supported to live independently (PROXY: Number receiving additional practical help (support non meal related e.g. bins taken out) (1%)","Social care database and Survey (PROXY: social care database)",9,1,"Cost of home help-e.g. cleaner for 1 hr a week (£20) over a year",1040,"Estimate",0.05,0,0.15,0,7558.2,null,{"$f":"IF(J10>=1,R10,0)","v":7558.2},{"$f":"IF(J10>1,T10,0)*(1-Q10)","v":0},{"$f":"IF(J10>2,U10,0)*(1-Q10)","v":0},{"$f":"IF(J10>3,V10,0)*(1-Q10)","v":0},{"$f":"IF(J10>4,W10,0)*(1-Q10)","v":0}]
[null,"Older people have someone visit regularly to increase their social contact",null,null,"Numbers receiving daily meals = 781 ","Friendly social contact on a daily basis","Number of those who were previously 'quite isolated' who state that they are more likely to see people regularly as a result of service (PROXY: Number receiving daily meals and state that driver is friendly (781) from expected proportion of over 75 who see friends or family less than once a week (19%)","Survey (PROXY: Social care database / Social Capital Survey",148,1,"Value of seeing friends or family  / contribution to wellbeing",520,"Family spending survey and Powdphavee research",0.05,0,0.15,0,62145.2,null,{"$f":"IF(J11>=1,R11,0)","v":62145.2},{"$f":"IF(J11>1,T11,0)*(1-Q11)","v":0},{"$f":"IF(J11>2,U11,0)*(1-Q11)","v":0},{"$f":"IF(J11>3,V11,0)*(1-Q11)","v":0},{"$f":"IF(J11>4,W11,0)*(1-Q11)","v":0}]
[{"$nulls":6},"Number of those who were previously 'very isolated' who state that they are more likely to see people regularly as a result of service (PROXY:  receiving daily meals and state that driver is friendly (781) from expected proportion of over 75s who see friends or family less than once a month (16%)","Survey (PROXY: Social care database / Social Capital Survey",125,1,"Value of seeing friends or family / contribution to wellbeing",2912,"Family spending survey and Powdphavee research",0.05,0,0.15,0,293930,null,{"$f":"IF(J12>=1,R12,0)","v":293930},{"$f":"IF(J12>1,T12,0)*(1-Q12)","v":0},{"$f":"IF(J12>2,U12,0)*(1-Q12)","v":0},{"$f":"IF(J12>3,V12,0)*(1-Q12)","v":0},{"$f":"IF(J12>4,W12,0)*(1-Q12)","v":0}]
[null,"Older people are supported to make choices over their meal to help them feel more in control",null,null,null,"Feel more in control","Number who state the they feel more in control of their lives as result of the service  (PROXY: No. chosen specific needs not on menu (171)  and support to make choice (14))","Survey (PROXY: Social care database / Social Capital Survey",14,1,"Value of autonomy (reduced wages of self employed)",1900,"Survey of Personal Income",0.05,0,0.15,0,21479.5,null,{"$f":"IF(J13>=1,R13,0)","v":21479.5},{"$f":"IF(J13>1,T13,0)*(1-Q13)","v":0},{"$f":"IF(J13>2,U13,0)*(1-Q13)","v":0},{"$f":"IF(J13>3,V13,0)*(1-Q13)","v":0},{"$f":"IF(J13>4,W13,0)*(1-Q13)","v":0}]
[{"$nulls":5},"Receiving a meal from Icare","Number of meals delivered from Icare","Social care database",260383,1,"Cost of meal to service user",3.2,"Community Meals",0,0,0.15,0,708241.76,null,{"$f":"IF(J14>=1,R14,0)","v":708241.76},{"$f":"IF(J14>1,T14,0)*(1-Q14)","v":0},{"$f":"IF(J14>2,U14,0)*(1-Q14)","v":0},{"$f":"IF(J14>3,V14,0)*(1-Q14)","v":0},{"$f":"IF(J14>4,W14,0)*(1-Q14)","v":0}]
["Family","Support from community meals allows family members to have more free time from caring ",null,null,null,"More freedom","Number of family members who state that they have more freedom as a result of the service (PROXY: Family less reliant on daily basis - from expected proportion of daily service users who see family members everyday (14%))","Family survey (PROXY: Social Capital Survey)",109,1,"Value of time",1872,"Minimum wage (£6 a hr)",0.05,0,0.05,0,{"$f":"+I15*L15*(1-N15)*(1-O15)*(1-P15)","v":184153.31999999998},null,184153.31999999998,0,0,0,0]
[null,"Support from community meals to have peace of mind",null,null,null,"Peace of mind","Number of family members who state that they have ore peace of mind as a result of the service (PROXY: Less stress - from expected proportion of daily service users who see family members at least once a month (62%))","Family survey (PROXY: Social Capital Survey)",482,1,"One hour a week counseling over a year",2085,"Internet searches ",0.05,0,0.05,0,906985.42499999993,null,{"$f":"IF(J16>=1,R16,0)","v":906985.42499999993},{"$f":"IF(J16>1,T16,0)*(1-Q16)","v":0},{"$f":"IF(J16>2,U16,0)*(1-Q16)","v":0},{"$f":"IF(J16>3,V16,0)*(1-Q16)","v":0},{"$f":"IF(J16>4,W16,0)*(1-Q16)","v":0}]
["Lunch club attendees","Older people attend lunch clubs in their neighbourhood and feel more part of their community",null,null,"Lunch clubs = 52","Feel part of community","Number who state that they feel more part of their community (PROXY: Feeling more a part of local area from expected proportion of  over 75s see neighbours less than once a month (51%))","Survey (PROXY: Social Capital Survey)",728,1,"Value of talking to neighbours / contribution to wellbeing",764,"Family spending survey and Powdphavee research",0.2,0,0.05,0,422705.92000000004,null,422705.92000000004,0,0,0,0]
[null,"Older people attend lunch clubs in their neighbourhood and   have fun","cost of meals",173171.20000000001,null,"Have fun","Number who state that they have more fun as a result of attending the lunch club (PROXY: Estimation that all attend as they are enjoying themselves","Survey (PROXY: stakeholder engagement)",1450,1,"Average spend on games and hobbies per annum",93,"Family Spending 2009 - A report on the 2008 Living Costs and Food Survey 2008",0.2,0,0.05,0,102486,null,102486,0,0,0,0]
[{"$nulls":5},"Receiving a meal from Icare","Meal delivered from ICare","Social care database",54116,1,"Cost of meal to lunch club attendee",3.2,"Community Meals",0,0,0.05,0,164512.64000000001,null,164512.64000000001,0,0,0,0]
["Volunteers","Volunteers feel that they are contributing to the service and have increased satisfaction in helping others","Minimum wage for 1 hour=£6 * Number of volunteers (208) * weeks a year (52)",64895,null,"Satisfaction in helping others","Number of volunteers who feel they are making a difference (PROXY: Estimate  = Minimum of 4 per club)","Volunteers Survey (PROXY: Stakeholder engagement)",208,1,"Average amount people give to charity a year",110,"Investec Private Bank",0.1,0,0.2,0,16473.600000000002,null,{"$f":"IF(J20>=1,R20,0)","v":16473.600000000002},{"$f":"IF(J20>1,T20,0)*(1-Q20)","v":0},{"$f":"IF(J20>2,U20,0)*(1-Q20)","v":0},{"$f":"IF(J20>3,V20,0)*(1-Q20)","v":0},{"$f":"IF(J20>4,W20,0)*(1-Q20)","v":0}]
["Leicestershire County Council","LCC pay for the contract to allow and support the service to be offered at a substidised price  leading to a reduction in long term care costs","Contract, support and subsidy",497145.17,null,"Reduction in intensive support costs","Reduction in provision of other adult social care service (PROXY: Numbers receiving additional practical help)","Social Care database",9,1,"Annual cost of providing home care",5824,"Unit Costs of Health and Social Care' 2009, PSSRU ",0.05,0,0.15,0,42325.919999999998,null,{"$f":"IF(J21>=1,R21,0)","v":42325.919999999998},{"$f":"IF(J21>1,T21,0)*(1-Q21)","v":0},{"$f":"IF(J21>2,U21,0)*(1-Q21)","v":0},{"$f":"IF(J21>3,V21,0)*(1-Q21)","v":0},{"$f":"IF(J21>4,W21,0)*(1-Q21)","v":0}]
["NHS","The service improves the health of older people reducing costs to the NHS",null,null,null,"Reduction in those at risk of malnutrition/dehydration or potential hospital admissions","Reduction in admissions due to malnutrition (PROXY: Numbers who receive support to eat their meal (15%))","NHS data (PROXY: Social Care Database)",207,1,"Addition cost of treating patients with malnutrition",1000,"Guest, J.F. et al (2011) Health economic impact of managing patients following a community-based diagnosis of",0.05,0,0.15,0,167152.5,null,{"$f":"IF(J22>=1,R22,0)","v":167152.5},{"$f":"IF(J22>1,T22,0)*(1-Q22)","v":0},{"$f":"IF(J22>2,U22,0)*(1-Q22)","v":0},{"$f":"IF(J22>3,V22,0)*(1-Q22)","v":0},{"$f":"IF(J22>4,W22,0)*(1-Q22)","v":0}]
[null,null,null,{"$f":"SUM(D1:D22)","v":1568436.97},{"$nulls":13},{"$f":"SUM(R9:R22)","v":3322462.81},null,{"$f":"SUM(T9:T22)","v":3322462.81},{"$f":"SUM(U9:U22)","v":0},{"$f":"SUM(V9:V22)","v":0},{"$f":"SUM(W9:W22)","v":0},{"$f":"SUM(X10:X18)","v":0}]
[]
[{"$nulls":14},"Present value of each year (after discounting)",{"$nulls":4},{"$f":"+T23/((1+U7)*(1+U7))","v":3322462.81},{"$f":"+U23/((1+V7)*(1+V7))","v":0},{"$f":"+V23/((1+V7)*(1+V7)*(1+V7))","v":0},{"$f":"+W23/((1+V7)*(1+V7)*(1+V7)*(1+V7))","v":0},{"$f":"+X23/((1+V7)*(1+V7)*(1+V7)*(1+V7)*(1+V7))","v":0}]
[{"$nulls":14},"Total Present Value (PV)",{"$nulls":8},{"$f":"NPV(V7,T23:X23)","v":3210108.9951690827}]
[{"$nulls":14},"Net Present Value (PV minus the investment)",{"$nulls":8},{"$f":"+X26-D23","v":1641672.0251690827}]
[{"$nulls":14},"Social Return £ per £",{"$nulls":8},{"$f":"+X26/D23","v":2.0466930176793032}]