{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inputs","Reports","Diagrams","Caveats"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":5,"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":"Inputs","index":0,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,3,2,5],[6,5,15,5],[18,6,20,6]]}
["Value of a social tenancy illustration"]
["Please click 'enable content' to use the calculator"]
["Name of Organisation",null,null,"Name"]
[null,null,null,null,null,null,"Guidance on inputs"]
["Number of tenancies",null,null,0,null,null,"This is the number of lettable properties available for let or currently being let, split into the units to which individual tenancy agreements would usually apply"]
[]
["Geographic mix",null,"London",0,null,null,"Housing stock % in the London area including greater London (any of the 13 Inner London boroughs and 10 Outer London boroughs)"]
[null,null,"South East",0,null,null,"Housing stock % in the following counties: Berkshire, Buckinghamshire, East Sussex, Hampshire, the Isle of Wight, Kent, Oxfordshire, Surrey and West Sussex"]
[null,null,"South West",0,null,null,"Housing stock % in the following counties: Bristol, Cornwall, Dorset, Devon, Gloucestershire,Somerset, and Wiltshire, as well as the Isles of Scilly"]
[null,null,"East of England",0,null,null,"Housing stock % in the following counties: Bedfordshire, Cambridgeshire, Essex, Hertfordshire, Norfolk and Suffolk"]
[null,null,"Midlands",0,null,null,"Housing stock % in the following regions: East Midlands (counties: Derbyshire, Leicestershire, Lincolnshire, Northamptonshire, Nottinghamshire and Rutland and West Midlands (counties: Herefordshire, Shropshire, Staffordshire, Warwickshire, West Midlands and Worcestershire)"]
[null,null,"Yorkshire and the Humber",0,null,null," Housing stock % in the following: South Yorkshire, West Yorkshire, East Riding of Yorkshire, Hull, North Yorkshire and the City of York, as well as North Lincolnshire and North East Lincolnshire"]
[null,null,"North East",0,null,null,"Housing stock % in the following: Northumberland, County Durham, Tyne and Wear"]
[null,null,"North West",0,null,null,"Housing stock % in the following counties: Cheshire, Cumbria, Greater Manchester, Lancashire and Merseyside"]
[null,null,"Wales ",0]
[null,null,"Scotland",0]
[null,null,null,{"$f":"IF(SUM(D7:D16)=100%,\"\",\"Error - does not equal 100%\")","v":"Error - does not equal 100%"}]
[]
["Age of lead tenant",null,"Under 18",0,null,null,"Age of lead tenant: meaning the tenant in regular occupation taking prime responsibility for the rental payment"]
[null,null,"18 - 70",0]
[null,null,"Over 70",0]
[null,null,null,{"$f":"IF(SUM(D19:D21)=100%,\"\",\"Error - does not equal 100%\")","v":"Error - does not equal 100%"}]
[]
["Total construction spend in the last year (£m)",null,null,0,"per annum",null,"Costs incurred during the last full financial year for the construction or total refurbishment (to bring it back into regular use) or properties for letting on social tenancies.  This should be the total disclosed capital cost in the annual accounts"]
[]
["Total maintenance spend in the last year (£m)",null,null,0,"per annum",null,"Costs incurred during the last full financial year for the maintenance of properties for let on social tenancies. This should be the total disclosed capital cost in the annual accounts."]
[]
["% of tenants with additional support needs",null,null,0,null,null,"Number of tenancies in which someone (lead tenant or otherwise) is regularly resident and receives additional support for physical, health, mental health or other social care needs which exceed those used by the majority of tenants, whether supplied by the landlord or another agency, divided by the total number of tenancies."]
[]
["% of tenants not on 5 year tenancies",null,null,0,null,null,"The number of tenancies not let on five-year tenancies, including those that habitually are let for five or more years even if not contractually having an extended right to occupy, divided by the total number of tenancies."]
[]
["Date prepared",null,null,{"$f":"NOW()","v":"2020-08-03T13:23:21.410"}]

{"sheet":"Reports","index":1,"n_rows":123,"n_cols":8,"rows_kept":123,"cut":false,"hidden":true,"merged":[[77,1,77,5],[80,1,80,5],[81,1,81,5],[24,1,24,5],[27,1,27,5],[74,1,74,5],[75,1,75,5],[76,1,76,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[2,0,2,5]]}
[null,null,"2019-08-15T17:20:17.300",null,null,null,null,{"$f":"IF((NOW()-C1)>120,\"Assumptions entered over 1 year ago - consider update\",\"\")","v":"Assumptions entered over 1 year ago - consider update"}]
[]
[{"$f":"\"Value of a social tenancy for \"&Inputs!$D$3","v":"Value of a social tenancy for Name"}]
[]
[null,"A social tenancy is so much more than a roof over someone’s head.  The very nature of a social tenancy sets it apart from other housing types.  Social landlords provide affordable, safe and secure tenancies in homes that meet the decent homes standard.  As landlords they have a unique relationship with tenants, enabling responsible services and individual support to be woven into the tenancy itself.  As the name suggests, social landlords also have an eye on good outcomes for communities and wider society.  Everything they do helps to lay and maintain the foundations of a good, stable life for their tenants in community settings that are a pleasure to live in. "]
[null,{"$f":"CONCATENATE(\"This report provides an illustration of the value brought by the social tenancies offered by \",Inputs!D3, \", presented as both a value per tenancy and a total value for \",Inputs!D3, \".\")","v":"This report provides an illustration of the value brought by the social tenancies offered by Name, presented as both a value per tenancy and a total value for Name."}]
[null,"These values are found by applying the core methodology developed by the team from Sonnet Advisory & Impact CIC working together with Hyde Housing Group.  The original report, with detailed explanation of the methodology, its underlying assumptions and value hypotheses can be accessed here: https://www.hyde-housing.co.uk/value-to-society/ "]
[null,"The research underpinning the methodology revolves around the key assumption that in the absence of social housing, tenants would be left with three options – none of which is desirable over the long term – namely:  staying with family or friends (including ‘sofa surfing’); staying in emergency or temporary accommodation arranged by the local authority; or struggling in the ‘bottom end’ of the Private Rented Sector.  Admittedly, people can – and do – manage in these situations but the likelihood of them doing so over the long term is low.  Social tenancies provide a necessary alternative, and one which provides far-reaching beneficial outcomes."]
[]
["Putting a price on value"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In arriving at a value for these outcomes, we have used the 5 Pillars of Wellbeing model, which explores five distinct areas of life (Financial wellbeing, Mental wellbeing, Physical wellbeing, Relational wellbeing, and Purpose) in order:  "]
[null,null,"•    firstly, to see how life is different in a social tenancy compared to its alternatives; and"]
[null,null,"•    secondly, to explore how resulting cost savings, economic benefits or improved life chances accrue to beneficiaries"]
[null,{"$f":"CONCATENATE(\"Based on the data which you have provided us for \",Inputs!D3, \", we estimate that the annual value of a social tenancy with \",Inputs!D3,\" is at least £\",TEXT(Diagrams!V14,\"#,###\"),\". When taking into consideration the effects of maintenance and building activity (including reflecting a designated proportion of wages being spent in the local economy) that value rises to £\",TEXT(Diagrams!V20,\"[red]#,###\"),\".\")","v":"Based on the data which you have provided us for Name, we estimate that the annual value of a social tenancy with Name is at least £. When taking into consideration the effects of maintenance and building activity (including reflecting a designated proportion of wages being spent in the local economy) that value rises to £."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Specific points relevant to \"&Inputs!D3","v":"Specific points relevant to Name"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["About this report"]
[1,"This Social Housing Value Calculator generates a short illustrative report using data supplied by the user by applying key metrics derived from the Value of a Social Tenancy model to the inputs. The inputs used and contents of the report will not be verified or validated by Sonnet unless such support is specifically requested. Neither Sonnet Advisory & Impact CIC, Bates Wells as its predecessor, nor Hyde Group accept liability to the user or any third party who gains access to the report that is generated. This tool has been developed to provide an illustrative result based on summarised calculations: it is not prepared to a standard likely to be required for statutory reporting or applications to obtain grants or investment.  The results should be treated as ‘estimated’ values only.  Depending on the nuance of detailed organisational data, actual valuations may be more or less than the illustrative estimate provided by the Calculator."]
[2,"In line with the above, the report you will receive may be freely quoted, but not relied upon in any form whatsoever related to formal accounting or reporting.  For this reason, assurance or similar regulatory routines are not appropriate for this report."]
[3,"If you would like to talk to us about the range of impact-related services we provide – including full impact studies, such as the one we performed for Hyde Housing – do please get in touch by emailing contact@sonnetimpact.co.uk."]
[4,"Sonnet Advisory & Impact is actively supporting work across the social housing sector.  As part of this we are committed to keeping our information and insight as fresh as possible.  On receiving your report, you will be invited to submit a copy to us, so that we can add your data to our benchmarking activities.  We would be very grateful if you would consider doing so – all data submitted in this way will be kept securely on our systems and anonymised in any publications or communications."]
[]
["About Sonnet Advisory & Impact"]
[null,"Sonnet Advisory & Impact works co-productively with organisations committed to bringing about social good.  We help them to identify their social impact footprint, to spot opportunities for expanding it, and to develop pragmatic impact measurement frameworks for integrated reporting.   We specialise in conducting impact studies which evaluate, value and articulate social outcomes that organisations achieve through their work."]
[null,"www.sonnetimpact.co.uk"]
[]
[]
[]
[]
["Key inputs used"]
[]
["The following information has been used as the basis for the illustration presented above."]
[]
[{"$f":"CONCATENATE(\"Name of organisation: \",Inputs!$D$3)","v":"Name of organisation: Name"}]
[]
[{"$f":"CONCATENATE(\"Number of tenancies: \",TEXT(Inputs!$D$5,\"#,###\"))","v":"Number of tenancies: "}]
[]
["Geographical mix"]
[]
[null,null,{"$f":"CONCATENATE(Inputs!C7,\": \",TEXT(Inputs!D7,\"0%\"))","v":"London: 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C8,\": \",TEXT(Inputs!D8,\"0%\"))","v":"South East: 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C9,\": \",TEXT(Inputs!D9,\"0%\"))","v":"South West: 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C10,\": \",TEXT(Inputs!D10,\"0%\"))","v":"East of England: 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C11,\": \",TEXT(Inputs!D11,\"0%\"))","v":"Midlands: 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C12,\": \",TEXT(Inputs!D12,\"0%\"))","v":"Yorkshire and the Humber: 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C13,\": \",TEXT(Inputs!D13,\"0%\"))","v":"North East: 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C14,\": \",TEXT(Inputs!D14,\"0%\"))","v":"North West: 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C15,\": \",TEXT(Inputs!D15,\"0%\"))","v":"Wales : 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C16,\": \",TEXT(Inputs!D16,\"0%\"))","v":"Scotland: 0%"}]
[]
[]
["Age mix"]
[]
[null,null,{"$f":"CONCATENATE(Inputs!C19,\": \",TEXT(Inputs!D19,\"0%\"))","v":"Under 18: 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C20,\": \",TEXT(Inputs!D20,\"0%\"))","v":"18 - 70: 0%"}]
[null,null,{"$f":"CONCATENATE(Inputs!C21,\": \",TEXT(Inputs!D21,\"0%\"))","v":"Over 70: 0%"}]
[]
[]
["Property costs"]
[{"$f":"CONCATENATE(\"Annual construction spend (£m): \",TEXT(Inputs!$D$24,\"#,###\"))","v":"Annual construction spend (£m): "}]
[{"$f":"CONCATENATE(\"Annual maintenance spend (£m): \",TEXT(Inputs!$D$26,\"#,###\"))","v":"Annual maintenance spend (£m): "}]
[]
["Tenancy types and needs"]
[]
[{"$f":"CONCATENATE(\"Proportion of tenants not on 5 year agreements: \",TEXT(Inputs!$D$30,\"#%\"))","v":"Proportion of tenants not on 5 year agreements: %"}]
[{"$f":"CONCATENATE(\"Proportion of tenants with additional support needs: \",TEXT(Inputs!$D$28,\"#%\"))","v":"Proportion of tenants with additional support needs: %"}]

{"sheet":"Diagrams","index":2,"n_rows":58,"n_cols":30,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tenancies",null,{"$f":"Inputs!$D$5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction cost",null,{"$f":"SUM(Inputs!$D$24)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance cost",null,{"$f":"SUM(Inputs!$D$26)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction multiplier",null,1.88]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Org name","Values","Text box no.","Text box content"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!$D$3","v":"Name"},{"$f":"IFERROR(AD58/W6,\"\")","v":""},"Text 1",{"$f":"CONCATENATE(\"Social value per \",$U$14,\" tenancy £\",TEXT($V$14,\"#,###\"),\" per annum\")","v":"Social value per Name tenancy £ per annum"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M44,\"\")","v":0},"Text 2",{"$f":"CONCATENATE(\"All \",$U$14,\" social homes £\",TEXT(V15,\"#,###\"),\"m per annum\")","v":"All Name social homes £m per annum"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((V17*1000000)/$W$6,\"\")","v":""},"Text 3",{"$f":"CONCATENATE(\"Economic impact of construction £\",TEXT($V$16,\"#,###\"),\" per tenancy\")","v":"Economic impact of construction £ per tenancy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR($W$7*$W$10,\"\")","v":0},"Text 4",{"$f":"CONCATENATE(\"All \",$U$14,\" homes £\",TEXT($V$17,\"#,###\"),\"m in total\")","v":"All Name homes £m in total"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((V19*1000000)/$W$6,\"\")","v":""},"Text 5",{"$f":"CONCATENATE(\"Economic impact of maintenance £\",TEXT(V18,\"#,###\"),\" per tenancy\")","v":"Economic impact of maintenance £ per tenancy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR($W$8*$W$10,\"\")","v":0},"Text 6",{"$f":"CONCATENATE(\"All \",U14,\" homes £\",TEXT($V$19,\"#,###\"),\"m in total\")","v":"All Name homes £m in total"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V14,V16,V18)","v":0},"Text 7",{"$f":"CONCATENATE(\"Total social value per \",$U$14,\" tenancy £\",TEXT(V20,\"#,###\"))","v":"Total social value per Name tenancy £"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V15+V17+V19","v":0},"Text 8",{"$f":"CONCATENATE(\"All \",$U$14,\" homes £\",TEXT(V21,\"#,###\"),\"m\")","v":"All Name homes £m"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of elderly tenancies",{"$f":"$W$6*Inputs!$D$21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential care saving per elderly tenancy",1059.2592592592594]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other LA costs per tenancy (all tenancies)",1162]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total LA cost",{"$f":"(V28*(V29+V30))+((W6-V28)*V30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saving per tenancy",{"$f":"V31/W6","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Savings per tenancy",1.7391542107181917,1.0567991250455706,0.87426175720014576,0.81658767772511853,0.73353991979584399,0.85902296755377328,0.71837404301859276,0.93638352169157857]
[null,null,null,null,null,null,null,null,null,null,null,"Org Name","Values","Text box no.","Text box content",null,null,null,null,null,null,"London","South East","South West","Midlands","North East","North West","Wales ","Scotland"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"52000000/35915","v":1447.8630098844494},{"$f":"$U$14","v":"Name"},{"$f":"IFERROR(AD50/1000000,\"\")","v":""},"Text 9",{"$f":"CONCATENATE(\"Local Authority £\",TEXT($M$36,\"#,##0.0\"),\"m\")","v":"Local Authority £m"},null,null,null,null,null,"Local Authority",{"$f":"$V$32","v":{"$error":"#DIV/0!"}},{"$f":"$V$32","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"55000000/35915","v":1531.3935681470139},null,{"$f":"IFERROR(AD51/1000000,\"\")","v":0},"Text 10",{"$f":"CONCATENATE(\"Police & Justice £\",TEXT($M$37,\"#,##0.0\"),\"m\")","v":"Police & Justice £0.0m"},null,null,null,null,null,"Police and justice",1531,1531,1531,1531,1531,1531,1531,1531]
[null,null,null,null,null,null,null,null,null,null,{"$f":"10000000/35915","v":278.43519420854795},null,0,"Text 11",{"$f":"CONCATENATE(\"Education £\",TEXT($M$38,\"#,##0.0\"),\"m\")","v":"Education £0.0m"},null,null,null,null,null,"Education",278,278,278,278,278,278,278,278]
[null,null,null,null,null,null,null,null,null,null,{"$f":"93000000/35915","v":2589.447306139496},null,0,"Text 12",{"$f":"CONCATENATE(\"NHS £\",TEXT($M$39,\"#,##0.0\"),\"m\")","v":"NHS £0.0m"},null,null,null,null,null,"NHS",2589,2589,2589,2589,2589,2589,2589,2589]
[null,null,null,null,null,null,null,null,null,null,{"$f":"14000000/35915","v":389.80927189196717},null,0,"Text 13",{"$f":"CONCATENATE(\"DWP £\",TEXT($M$40,\"#,##0.0\"),\"m\")","v":"DWP £0.0m"},null,null,null,null,null,"DWP",{"$f":"$AD$40*V34","v":678.27014218009469},{"$f":"$AD$40*W34","v":412.15165876777252},340.96208530805683,318.46919431279622,286.08056872037918,335.01895734597156,280.16587677725119,365.18957345971563,390]
[null,null,null,null,null,null,null,null,null,null,{"$f":"172000000/35915","v":4789.0853403870251},null,0,"Text 14",{"$f":"CONCATENATE(\"Economy £\",TEXT($M$41,\"#,##0.0\"),\"m\")","v":"Economy £0.0m"},null,null,null,null,null,"Economy",{"$f":"$AD$41*V34","v":8328.8095151294201},{"$f":"$AD$41*W34","v":5061.0110098432378},4186.8395552314978,3910.6383886255926,3512.9226759022968,4113.8609916150199,3440.2932920160406,4484.3406853809702,4789]
[null,null,null,null,null,null,null,null,null,null,{"$f":"2000000/35915","v":55.687038841709594},null,0,"Text 15",{"$f":"CONCATENATE(\"Fire Service £\",TEXT($M$42,\"#,##0.0\"),\"m\")","v":"Fire Service £0.0m"},null,null,null,null,null,"Fire Service",56,56,56,56,56,56,56,56]
[null,null,null,null,null,null,null,null,null,null,{"$f":"3000000/35915","v":83.530558262564384},null,0,"Text 16",{"$f":"CONCATENATE(\"Banks/ Creditors £\",TEXT($M$43,\"#,##0.0\"),\"m\")","v":"Banks/ Creditors £0.0m"},null,null,null,null,null,"Banks/creditors",84,84,84,84,84,84,84,84]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K36:K43)","v":11165.251287762774},"Total",{"$f":"SUM(M36:M43)","v":0},"Text 17",{"$f":"CONCATENATE(\"Total: £\",TEXT($M$44,\"#,##0.0\"),\"m value to stakeholders for \",$L$36,\"’s \",TEXT($W$6,\"#,###\"),\" tenancies\")","v":"Total: £0.0m value to stakeholders for Name’s  tenancies"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proportion of tenancies",{"$f":"Inputs!D7","v":0},{"$f":"Inputs!D8","v":0},{"$f":"Inputs!D9","v":0},{"$f":"Inputs!D11","v":0},{"$f":"Inputs!D13","v":0},{"$f":"Inputs!D14","v":0},{"$f":"Inputs!D15","v":0},{"$f":"Inputs!D16","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total area savings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"London","South East","South West","Midlands","North East","North West","Wales ","Scotland","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Authority",{"$f":"$W$6*V$45*V36","v":{"$error":"#DIV/0!"}},{"$f":"$W$6*W$45*W36","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(V50:AC50)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Police and justice",{"$f":"$W$6*V$45*V37","v":0},0,0,0,0,0,0,0,{"$f":"SUM(V51:AC51)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Education",0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS",0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DWP",0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Economy",0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fire Service",0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Banks/creditors",0,0,0,0,0,0,0,0,0]
[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,{"$f":"SUM(AD50:AD57)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Caveats","index":3,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Disclaimer text"]
[]
["Type","The following issues relating to input data are noted for further review:","Apply"]
["Geographic mix",{"$f":"CONCATENATE(Inputs!D3,\"'s geographical footprint has an impact on several of the key calculations within our model. \",D4, Inputs!D3,\"'s geographical presence reflects into its value estimate.  More nuanced calculations are only possible with a detailed study.\")","v":"Name's geographical footprint has an impact on several of the key calculations within our model. In a summary valuation like this it is not possible to reflect that footprint into all the elements of the model that are affected, hence the figures provided represent a broad illustration of how Name's geographical presence reflects into its value estimate.  More nuanced calculations are only possible with a detailed study."},{"$f":"B20","v":"True"},"In a summary valuation like this it is not possible to reflect that footprint into all the elements of the model that are affected, hence the figures provided represent a broad illustration of how "]
["Age mix",{"$f":"CONCATENATE(\"The value estimate provided here is based on a typical distribution of resident age, family and employment profiles for a broad-based general social housing portfolio. If \",Inputs!D3,\" has a differing mix from this, particularly a high proportion of elderly tenants or a high proportion of children in tenancies, then this will influence the value. \",Inputs!D3,\"'s value creation profile is likely to be more complex. A detailed analysis would be required to reveal an accurate picture.\")","v":"The value estimate provided here is based on a typical distribution of resident age, family and employment profiles for a broad-based general social housing portfolio. If Name has a differing mix from this, particularly a high proportion of elderly tenants or a high proportion of children in tenancies, then this will influence the value. Name's value creation profile is likely to be more complex. A detailed analysis would be required to reveal an accurate picture."},{"$f":"B21","v":"True"}]
["Combined construction/maintenance spend",{"$f":"CONCATENATE(\"Our valuation approach assumes a certain amount of construction and maintenance spend each year, which results in both social value (in terms of employment) and wider economic value in the community.\",\" That spend is expressed as a value per tenancy, averaged across the whole portfolio). If this is a year in which \",Inputs!D3,\"'s construction or maintenance spend is particularly high, then there may be broader value issues which this model does not reflect.\")","v":"Our valuation approach assumes a certain amount of construction and maintenance spend each year, which results in both social value (in terms of employment) and wider economic value in the community. That spend is expressed as a value per tenancy, averaged across the whole portfolio). If this is a year in which Name's construction or maintenance spend is particularly high, then there may be broader value issues which this model does not reflect."},{"$f":"B22","v":{"$error":"#DIV/0!"}}]
["Size","The calculations shown here are based upon analysis of a Registered Provider with between 35,000 and 45,000 units. Providers with materially different numbers of units may require further detailed analysis.",{"$f":"B23","v":"True"}]
["Tenancy type","We have built our valuation approach around the concept of safe, secure and stable tenancies, and the positive effects that these have on people’s lives.  A central tenet of our working is an assumption that 5 year tenancy agreements are (or are becoming) the norm for most social landlords.  The estimated valuation we have provided makes that assumption, but we note that your own proportion of tenancy agreements of this length is likely to differ to our starting assumption.  This may have an effect on any subsequent detailed impact valuation.",{"$f":"B24","v":"False"}]
["Needs profile",{"$f":"CONCATENATE(\"The Social Housing Value Calculator is intended to reflect the intrinsic – and often unrecognised – value inherent in a social housing model.\", \" It is based on largely generalist housing provision, allowing for a proportion (but not a large proportion) of residents with additional support needs.  Noting that \",Inputs!D3,\" is likely to have larger numbers of tenants with different or additional needs, a detailed impact study would reveal a more accurate value.\")","v":"The Social Housing Value Calculator is intended to reflect the intrinsic – and often unrecognised – value inherent in a social housing model. It is based on largely generalist housing provision, allowing for a proportion (but not a large proportion) of residents with additional support needs.  Noting that Name is likely to have larger numbers of tenants with different or additional needs, a detailed impact study would reveal a more accurate value."},{"$f":"B25","v":"False"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Geog mix test",{"$f":"IF(+OR(Inputs!$D$7<40%,Inputs!$D$8>40%,Inputs!$D$9>40%,Inputs!$D$11>40%,Inputs!$D$13>40%,Inputs!$D$14>40%,Inputs!$D$15>40%,Inputs!$D$16>40%),\"True\",\"False\")","v":"True"}]
["Age mix test",{"$f":"IF(+OR(Inputs!$D$20<60%,Inputs!$D$21>40%,Inputs!$D$19>30%),\"True\",\"False\")","v":"True"}]
["Combined capital spend test",{"$f":"IF(+OR((((Inputs!D24*1000000)+(Inputs!D26*1000000))/Inputs!D5)>1900,(((Inputs!D24*1000000)+(Inputs!D26*1000000))/Inputs!D5)<1500),\"True\",\"False\")","v":{"$error":"#DIV/0!"}}]
["Size",{"$f":"IF(+OR(Inputs!$D$5<20000,Inputs!$D$5>50000),\"True\",\"False\")","v":"True"}]
["Tenancy type",{"$f":"IF(Inputs!$D$30>10%,\"True\",\"False\")","v":"False"}]
["Needs profile",{"$f":"IF(Inputs!$D$28>15%,\"True\",\"False\")","v":"False"}]