{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["QA Log","Front sheet","Part 1 - Social cost-benefit","Benefit tool","Worked examples","Sheet4","Part 2 - UC database","Social, YP & kinship care","Education","Disorders","Homelessness","NHS & LA treatment","DA & crime","Part 3 - Annexes","A1 GDP deflator","A2 Discount","A3 Market forces","Kinship carers calcs","Perinatal MH QALY calcs","FASD calcs","Crime cost calcs"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":22,"comments":8,"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":"QA Log","index":0,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[null,"QA log of changes and queries"]
[null,null,null,null,null,null,null,null,"Actions - Status:"]
[null,null,null,null,null,null,null,null,"Actioned"]
[null,null,null,null,null,null,null,null,"Ongoing - to discuss changes?"]
[null,null,null,null,null,null,null,null,"Suggestion rejected"]
[]
[null,"QA log #","Date of QA","Analyst QA","Version","Tab","Cell","Comment","Changed (Y/N)","What changed?","Additional Comments"]
[null,1,"2021-03-31","AM","v1.0","Part 3 - Annexes",null,"Part 2 button is still in burgundy colouring but it should be Part 3 button"]
[null,2,"2021-03-31","AM","v1.0","Part 1 - Social cost-benefit","F12","No Link to Benefit Tool tab"]
[null,3,"2021-03-31","AM","v1.0","Part 1 - Social cost-benefit","F13","No Link to Worked Examples Tab"]
[null,4,"2021-03-31","AM","v1.0","Disorders","L27:M30","Unit cost not checked as hard-coded / no calculation. ",null,null,"Taken directly from source"]
[null,5,"2021-03-31","AM","v1.0","Benefit tool","Rows ","The multipliers are hard-coded. Could they be added in the DA & crime tab along with an explanation of the crime multiplier by type of crime for transparency?"]
[null,6,"2021-03-31","AM","v1.0","All",null,"Could the notes over the cells be checked to display the full text as currently the full text is cut-off or isn't shown - have expanded where spotted but may need another check",null,null,"This will need to be done while tool with pub standards"]
[null,7,"2021-03-31","AM","v1.0","All",null,"Some of the notes have your name on them - have deleted where spotted but may need another check",null,null,"This will need to be done while tool with pub standards"]
[null,8,"2021-03-31","AM","v1.0","Benefit tool","Crime","Just to check, vehicle theft should be excluded?",null,null,"TBD"]
[null,9,"2021-03-31","AM","v1.0","Benefit tool","G53:H53; G54:H54; G56:H56","Total benefits included direcr treatment costs. If 'No' selected to say not mutually exclusive, this results in the Gross social benefit, Net social benefit, and social BCR figures being inconclusive. Need to adjust the formulas for these figures so if select 'No', still returns a figure."]
[null,10,"2021-03-31","AM","v1.0","Benefit tool","G53:H53","Formula needs to adjust for the range of total benefits if 'No' selected "]
[null,11,"2021-03-31","AM","v1.0","Benefit tool",null,"Perhaps add an extra row for the final figures table for the 'Gross wider social benefit' like have for the 'Gross social benefit (LA)'"]
[null,12,"2021-03-31","AM","v1.0","Worked examples","G:H95","Sum includes J78:Q79 which have no figures. Should this be moved up to the total benefits row?"]
[null,13,"2021-03-31","AM","v1.0","Worked examples","G:H96","Sum includes J78:Q79 which have no figures. Should this be moved up to the total benefits row?"]
[null,14,"2021-03-31","AM","v1.0","Worked examples",null,"Can case study 1 also have key areas of costs in Bold, to be consistent with the case studies below?"]
[null,15,"2021-03-31","AM","v1.0","Worked examples","G:H182","Sum includes J165:Q166 which have no figures. Should this be moved up to the total benefits row?"]
[null,16,"2021-03-31","AM","v1.0","Worked examples","G:H183","Sum includes J165:Q166 which have no figures. Should this be moved up to the total benefits row?"]
[null,17,"2021-03-31","AM","v1.0","Worked examples","G:H263","Sum includes J246:Q247 which have no figures. Should this be moved up to the total benefits row?"]
[null,18,"2021-03-31","AM","v1.0","Worked examples","G:H264","Sum includes J246:Q247 which have no figures. Should this be moved up to the total benefits row?"]
[null,19,"2021-03-31","AM","v1.0","Worked examples","G:H344","Sum includes J327:Q328 which have no figures. Should this be moved up to the total benefits row?"]
[null,20,"2021-03-31","AM","v1.0","Worked examples","G:H345","Sum includes J327:Q328 which have no figures. Should this be moved up to the total benefits row?"]
[null,21,"2021-03-31","AM","v1.0","Part 2 - UC database","F19","Link to NHS and LA Treatment not valid"]
[null,22,"2021-03-31","AM","v1.0","Part 2 - UC database","F20","Link to NHS and LA Treatment not valid"]
[null,23,"2021-03-31","AM","v1.0","A1 GDP deflator",null,"The latest GDP deflator for 2019-20 prices has been published if would want to update instead of estimate the infaltion rate for 2019-20."]
[null,24,"2021-03-31","AM","v1.0","Education",null,"Main unit cost figure hard-coded so not QA'd with source of unit cost"]
[null,25,"2021-03-31","AM","v1.0","Disorders","N8:P8","N8:P8 hard-coded. Add as a separate model paraemter and explian why divide lifetime costs by 10?"]
[null,26,"2021-03-31","AM","v1.0","Disorders","Rows 11:15","Lifetime costs hard-coded so not QA'd for source"]
[null,27,"2021-03-31","AM","v1.0","Disorders","N16:P16","N16:P16 hard-coded. Add as a separate model paraemter and explian why divide lifetime costs by 10?",null,null,"Comment states that lifetime costs have been modelled over 10 years"]
[null,28,"2021-03-31","AM","v1.0","Disorders","Rows 18:21","Lifetime costs hard-coded so not QA'd for source"]
[null,29,"2021-03-31","AM","v1.0","Disorders","H23","Add 60% as model parameter and explain why 60% of total costs?",null,null,"Comment explains"]
[null,30,"2021-03-31","AM","v1.0","Disorders","H24","Add 28% as model parameter and explain why 28% of total costs?",null,null,"Comment explains"]
[null,31,"2021-03-31","AM","v1.0","Disorders","H25","Add 12% as model parameter and explain why 12% of total costs?",null,null,"Comment explains"]
[null,32,"2021-03-31","AM","v1.0","Disorders","I27;I28;I30;J29","Unit costs in $ hard-coded and not QA'd for source or how converted to £s",null,null,"TBD"]
[null,33,"2021-03-31","AM","v1.0","Homelessness","H8","Unit costs hard-coded so not QA'd for source"]
[null,34,"2021-03-31","AM","v1.0","Homelessness","H10:H12","Unit costs hard-coded so not QA'd for source"]
[null,35,"2021-03-31","AM","v1.0","Homelessness","H13:K13","Unit cost of crime excluded from Overall cost"]
[null,36,"2021-03-31","AM","v1.0","Homelessness","H14:H18","Unit costs hard-coded so not QA'd for source"]

{"sheet":"Front sheet","index":1,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[12,2,12,7]]}
[]
[]
[]
[]
[]
[]
[null,null,"Parents with problem alcohol and drug use:"]
[null,null,"investing in families workbook, 2020 to 2021"]
[]
[null,null,"Supporting children and families experiencing parental alcohol and drug misuse"]
[]
[null,null,"Introduction"]
[null,null,"This workbook supports local areas, organisations and providers that have collected, or intend to collect, case studies to estimate how much social and economic cost they can avoid by supporting families experiencing alcohol and drug problems. It is designed to be used alongside the 'Using case studies to estimate the cost-benefit of interventions' guidance. \n"]
[null,null,"It is split into 3 sections. "]
[]
[null,null,"Part 1: Social cost-benefit tool"]
[null,null,"Part 2: Unit cost database"]
[null,null,"Part 3: Annexes"]
[]
[null,null,"To open a section, please click on the relevant link at the side, or use the tabs below."]

{"sheet":"Part 1 - Social cost-benefit","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,3,3,9],[4,3,4,9],[6,3,6,9]]}
[]
[null,null,null,"Part 1: Social cost-benefit tool"]
[]
[null,null,null,"This document supports anyone collecting case studies to estimate how much social and economic cost can be avoided by supporting families experiencing problem parental alcohol and drug use. "]
[null,null,null,"It is important to remember when using case studies of families, that the estimated costs represent potential benefits specific to that family, and not the average benefits of the intervention. To do the latter, areas would need to collect data on every family receiving the intervention."]
[]
[null,null,null,"When exploring the effects of an intervention, it is important to understand family dynamics and experiences before, during and after the intervention. This helps you to understand how things have changed for the family. There are many ways to collate this type of data in a case study and it is possible that you will have your own preferred way to do so. You can download a case study template in the accompanying guidance document as an example for reference. "]
[]
[null,null,null,"Contents"]
[]
[null,null,null,"Social cost-benefit tool component","Corresponding tab"]
[null,null,null,"Template for calculations","Benefit tool"]
[null,null,null,"Examples of case studies","Worked examples"]

{"sheet":"Benefit tool","index":3,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,4,58,5],[47,3,47,6],[36,3,36,6],[37,3,37,6],[53,4,53,5],[54,4,54,5],[55,4,55,5],[57,4,57,5],[56,4,56,5],[11,2,37,2],[40,2,49,2],[49,3,49,6],[11,3,11,5],[52,4,52,5],[51,4,51,5],[48,3,48,6],[11,7,11,14],[26,3,26,5],[26,7,26,14],[30,3,30,5],[40,3,40,5],[40,7,40,14],[7,15,10,15],[8,7,8,12],[8,13,10,13],[8,14,10,14],[9,7,9,10],[9,11,10,11],[9,12,10,12],[2,3,2,12],[7,4,10,4],[7,5,10,5],[7,6,10,6],[7,7,7,14],[7,2,10,3],[4,3,4,12],[3,3,3,11]]}
[]
[null,null,null,"Social cost-benefit tool "]
[null,null,null,"The table below is a template that can be used for calculations. Note: rows can be added, deleted or hidden as necessary. "]
[null,null,null,"Yellow cells require user input. Themes that are not relevant can be left as '0'. Once you have added the number of children and adults affcted by each theme, and selected which agency costs are mutually exclusive and which are not, you can read the summary of results table. You can read more details in the corresponding guidance."]
[null,null,null,"To see how the tool can be used in practice, please see the next tab: 'Worked examples'"]
[]
[]
[null,null,"Cost theme checklist",null,"No. of children","No. of adults","Corresponding tab","Costs avoided in first year after intervention",null,null,null,null,null,null,null,"Notes"]
[null,null,null,null,null,null,null,"Direct costs",null,null,null,null,null,"Indirect","Intangible"]
[null,null,null,null,null,null,null,"LA",null,null,null,"NHS","CJS"]
[null,null,null,null,null,null,null,"Social care","Education","Housing","Treatment"]
[null,null,"SOCIAL BENEFITS","Social care and early help support",null,null,"Social, YP & kinship care"]
[null,null,null,"Looked after - not in high cost placement",0,"n/a","Social, YP & kinship care",{"$f":"$E13*'Social, YP & kinship care'!$L$7","v":0}]
[null,null,null,"Child protection plan ",0,"n/a","Social, YP & kinship care",{"$f":"$E14*'Social, YP & kinship care'!$L$9","v":0}]
[null,null,null,"Child in need",0,"n/a","Social, YP & kinship care",{"$f":"$E15*'Social, YP & kinship care'!$L$10","v":0}]
[null,null,null,"Early help",0,"n/a","Social, YP & kinship care",{"$f":"$E16*'Social, YP & kinship care'!$L$11","v":0}]
[null,null,null,"Troubled Families programme",0,"n/a","Social, YP & kinship care",{"$f":"$E17*'Social, YP & kinship care'!$L$12","v":0}]
[null,null,null,"Young person adopting carer role",0,"n/a","Social, YP & kinship care",null,null,null,null,null,null,{"$f":"E18*'Social, YP & kinship care'!$K$20","v":0}]
[null,null,null,"Kinship care","n/a",0,"Social, YP & kinship care",null,null,null,null,null,null,{"$f":"F19*'Social, YP & kinship care'!$K$21","v":0}]
[null,null,null,"Exclusion from school",0,"n/a","Education ",{"$f":"$E20*(Education!$L$10)","v":0},{"$f":"$E20*(Education!$L$7)","v":0},null,null,{"$f":"E20*Education!$L$11","v":0}]
[null,null,null,"Truancy",0,"n/a","Education ",{"$f":"E21*(Education!$L$16)","v":0},{"$f":"E21*(Education!$L$13)","v":0},null,null,{"$f":"E21*(Education!$L$17)","v":0}]
[null,null,null,"Perinatal depression",0,"n/a","Disorders",null,null,null,null,{"$f":"E22*(Disorders!$L$8+Disorders!$L$10+Disorders!$L$11)","v":0},null,null,{"$f":"E22*(Disorders!$N$8+Disorders!$N$9)","v":0}]
[null,null,null,"Perinatal anxiety",0,"n/a","Disorders",null,null,null,null,{"$f":"E23*(Disorders!$L$16+Disorders!$L$17+Disorders!$L$18+Disorders!$L$19)","v":0},null,{"$f":"E23*(Disorders!$M$19)","v":0},{"$f":"E23*Disorders!$N$16","v":0}]
[null,null,null,"Conduct disorder",0,"n/a","Disorders",{"$f":"$E24*(Disorders!$L$23)","v":0},{"$f":"$E24*(Disorders!$L$21)","v":0},null,null,{"$f":"$E24*Disorders!$L$22","v":0}]
[null,null,null,"Foetal alcohol spectrum disorder",0,"n/a","Disorders",{"$f":"$E25*Disorders!$L$26","v":0},{"$f":"$E25*Disorders!$L$28","v":0},null,null,{"$f":"$E25*Disorders!$L$25","v":0}]
[null,null,null,"Homelessness",0,0,"Homelessness",null,null,{"$f":"IF(E26>0,1*Homelessness!$L$6,0)","v":0},null,{"$f":"E26*(Homelessness!$L$13+Homelessness!$L$14)+F26*Homelessness!$L$8","v":0},{"$f":"F26*Homelessness!L9","v":0},null,{"$f":"E26*Homelessness!$N$15+F26*Homelessness!$N$10","v":0}]
[null,null,null,"NHS treatment",null,null,"NHS and LA Treatment"]
[null,null,null,{"$f":"'NHS & LA treatment'!D18","v":"Cognitive behavioural therapy (CBT) for adolescents"},0,"n/a","NHS and LA Treatment",null,null,null,null,{"$f":"E28*'NHS & LA treatment'!$L$18","v":0}]
[null,null,null,{"$f":"'NHS & LA treatment'!D19","v":"Counselling for children with mental or emotional difficulties"},0,"n/a","NHS and LA Treatment",null,null,null,null,{"$f":"E29*'NHS & LA treatment'!$L$19","v":0}]
[null,null,null,"Domestic abuse","n/a",0,"DA & crime",null,null,null,null,{"$f":"F30*'DA & crime'!$L$7","v":0},{"$f":"F30*'DA & crime'!$L$10","v":0},{"$f":"F30*('DA & crime'!$M$11+'DA & crime'!$M$8)","v":0},{"$f":"F30*'DA & crime'!$N$9","v":0}]
[null,null,null,"Crime","","","DA & crime"]
[null,null,null,"Violence","n/a",0,"DA & crime",null,null,null,null,{"$f":"F32*AVERAGE('DA & crime'!$L$13,'DA & crime'!$L$19)*6","v":0},{"$f":"F32*AVERAGE('DA & crime'!$L$16,'DA & crime'!$L$22)*6","v":0},{"$f":"F32*AVERAGE('DA & crime'!$M$14,'DA & crime'!$M$17,'DA & crime'!$M$20,'DA & crime'!$M$23)*6","v":0},{"$f":"F32*AVERAGE('DA & crime'!$N$15,'DA & crime'!$N$21)*6","v":0}]
[null,null,null,"Shoplifting","n/a",0,"DA & crime",null,null,null,null,null,{"$f":"$F33*'DA & crime'!$L$24*100","v":0}]
[null,null,null,"Robbery","n/a",0,"DA & crime",null,null,null,null,{"$f":"F34*'DA & crime'!$L$26*15","v":0},{"$f":"F34*'DA & crime'!$L$29*15","v":0},{"$f":"F34*('DA & crime'!$M$27+'DA & crime'!$M$30)*15","v":0},{"$f":"F34*'DA & crime'!$N$28*15","v":0}]
[null,null,null,"House burglary","n/a",0,"DA & crime",null,null,null,null,{"$f":"F35*'DA & crime'!$L$32*25","v":0},{"$f":"F35*'DA & crime'!$L$35*25","v":0},{"$f":"F35*('DA & crime'!$M$33+'DA & crime'!$M$36)*25","v":0},{"$f":"F35*'DA & crime'!$N$34*25","v":0}]
[null,null,null,"Police call out","n/a",0,"DA & crime",null,null,null,null,null,{"$f":"$F36*'DA & crime'!$L$44*6","v":0}]
[null,null,null,"Are costs mutually exclusive?",null,null,null,"No","No","No",null,"No","No","No","No"]
[null,null,null,"Total benefits (where costs are not mutually exclusive, a range is presented)",null,null,null,{"$f":"IFERROR(IF(H37=\"No\",\"(£\"&(ROUND(SMALL(H13:H36,COUNTIF(H13:H36,0)+1),0))&\" - £\"&(ROUND(MAX(H13:H36),0))&\")\",SUM(H13:H36)),\"\")","v":""},{"$f":"IFERROR(IF(I37=\"No\",\"(£\"&(ROUND(SMALL(I13:I36,COUNTIF(I13:I36,0)+1),0))&\" - £\"&(ROUND(MAX(I13:I36),0))&\")\",SUM(I13:I36)),\"\")","v":""},{"$f":"IFERROR(IF(J37=\"No\",\"(£\"&(ROUND(SMALL(J13:J36,COUNTIF(J13:J36,0)+1),0))&\" - £\"&(ROUND(MAX(J13:J36),0))&\")\",SUM(J13:J36)),\"\")","v":""},null,{"$f":"IFERROR(IF(L37=\"No\",\"(£\"&(ROUND(SMALL(L13:L36,COUNTIF(L13:L36,0)+1),0))&\" - £\"&(ROUND(MAX(L13:L36),0))&\")\",SUM(L13:L36)),\"\")","v":""},{"$f":"IFERROR(IF(M37=\"No\",\"(£\"&(ROUND(SMALL(M13:M36,COUNTIF(M13:M36,0)+1),0))&\" - £\"&(ROUND(MAX(M13:M36),0))&\")\",SUM(M13:M36)),\"\")","v":""},{"$f":"IFERROR(IF(N37=\"No\",\"(£\"&(ROUND(SMALL(N13:N36,COUNTIF(N13:N36,0)+1),0))&\" - £\"&(ROUND(MAX(N13:N36),0))&\")\",SUM(N13:N36)),\"\")","v":""},{"$f":"IFERROR(IF(O37=\"No\",\"(£\"&(ROUND(SMALL(O13:O36,COUNTIF(O13:O36,0)+1),0))&\" - £\"&(ROUND(MAX(O13:O36),0))&\")\",SUM(O13:O36)),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(H37=\"No\",SMALL((H13:H36),COUNTIF(H13:H36,0)+1),SUM(H13:H36))","v":{"$error":"#NUM!"}},{"$f":"IF(I37=\"No\",SMALL((I13:I36),COUNTIF(I13:I36,0)+1),SUM(I13:I36))","v":{"$error":"#NUM!"}},{"$f":"IF(J37=\"No\",SMALL((J13:J36),COUNTIF(J13:J36,0)+1),SUM(J13:J36))","v":{"$error":"#NUM!"}},null,{"$f":"IF(L37=\"No\",SMALL((L13:L36),COUNTIF(L13:L36,0)+1),SUM(L13:L36))","v":{"$error":"#NUM!"}},{"$f":"IF(M37=\"No\",SMALL((M13:M36),COUNTIF(M13:M36,0)+1),SUM(M13:M36))","v":{"$error":"#NUM!"}},{"$f":"IF(N37=\"No\",SMALL((N13:N36),COUNTIF(N13:N36,0)+1),SUM(N13:N36))","v":{"$error":"#NUM!"}},{"$f":"IF(O37=\"No\",SMALL((O13:O36),COUNTIF(O13:O36,0)+1),SUM(O13:O36))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(H37=\"No\",MAX(H13:H36),SUM(H13:H36))","v":0},{"$f":"IF(I37=\"No\",MAX(I13:I36),SUM(I13:I36))","v":0},{"$f":"IF(J37=\"No\",MAX(J13:J36),SUM(J13:J36))","v":0},null,{"$f":"IF(L37=\"No\",MAX(L13:L36),SUM(L13:L36))","v":0},{"$f":"IF(M37=\"No\",MAX(M13:M36),SUM(M13:M36))","v":0},{"$f":"IF(N37=\"No\",MAX(N13:N36),SUM(N13:N36))","v":0},{"$f":"IF(O37=\"No\",MAX(O13:O36),SUM(O13:O36))","v":0}]
[null,null,"COSTS","Alcohol and drug treatment",0,0,"NHS and LA Treatment"]
[null,null,null,{"$f":"'NHS & LA treatment'!D20","v":"Treatment for opioid use"},"n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F42*'NHS & LA treatment'!$L$20","v":0}]
[null,null,null,{"$f":"'NHS & LA treatment'!D21","v":"Treatment for non-opioid drug use"},"n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F43*'NHS & LA treatment'!$L$21","v":0}]
[null,null,null,{"$f":"'NHS & LA treatment'!D22","v":"Treatment for alcohol use"},"n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F44*'NHS & LA treatment'!$L$22","v":0}]
[null,null,null,{"$f":"'NHS & LA treatment'!D23","v":"Treatment for young people (alcohol and drugs)"},0,"n/a","NHS and LA Treatment",null,null,null,{"$f":"E45*'NHS & LA treatment'!$L$23","v":0}]
[null,null,null,{"$f":"'NHS & LA treatment'!D24","v":"Inpatient detoxfication"},"n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F46*'NHS & LA treatment'!$L$24","v":0}]
[null,null,null,{"$f":"'NHS & LA treatment'!D25","v":"Residential rehabilitation"},"n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F47*'NHS & LA treatment'!$L$25","v":0}]
[null,null,null,"Other treatment cost should be added here",null,null,null,null,null,null,{"$f":"0","v":0}]
[null,null,null,"Any ongoing treatment or social support cost (for example, early help)",null,null,null,0,null,null,{"$f":"0","v":0}]
[null,null,null,"Total costs",null,null,null,{"$f":"SUM(H42:H49)","v":0},null,null,{"$f":"SUM(K42:K49)","v":0}]
[]
[null,null,null,null,"£"]
[null,null,null,"Total costs",{"$f":"SUM(H50:O50)","v":0}]
[null,null,null,"Gross social benefit (LA)",{"$f":"IFERROR(IF(SUM(H39:K39)=SUM(H40:K40),TEXT(ROUND(SUM(H39:K39),-1),\"#,#\"),TEXT(ROUND(SUM(H39:K39),-1),\" #,# - \")&TEXT(ROUND(SUM(H40:K40),-1),\"#,#\")),\"\")","v":""}]
[null,null,null,"Net social benefit (LA)",{"$f":"IFERROR(IF(SUM(H39:K39)=SUM(H40:K40),TEXT(ROUND(SUM(H39:K39)-E53,-1),\"#,#\"),TEXT(ROUND(SUM(H39:K39)-E53,-1),\"#,# - \")&TEXT(ROUND(SUM(H40:K40)-E53,-1),\"#,#\")),\"\")","v":""}]
[null,null,null,"Social benefit-cost ratio (LA costs)",{"$f":"IFERROR(IF(SUM(H39:K39)=SUM(H40:K40),TEXT(ROUND(SUM(H39:K39)/E53,2),\"#.#0\"),TEXT(ROUND(SUM(H39:K39)/E53,2),\"#.#0 - \")&TEXT(ROUND(SUM(H40:K40)/E53,2),\"#.#0\")),0)","v":0}]
[null,null,null,"Wider net social benefits (gross)",{"$f":"IFERROR(IF(SUM(H39:O39)=SUM(H40:O40),TEXT(ROUND(SUM(H39:O39),-1),\"#,#\"),TEXT(ROUND(SUM(H39:O39),-1),\" #,# - \")&TEXT(ROUND(SUM(H40:O40),-1),\"#,#\")),\"\")","v":""}]
[null,null,null,"Wider net social benefits (net)",{"$f":"IFERROR(IF(SUM(H39:O39)=SUM(H40:O40),TEXT(ROUND(SUM(H39:O39)-E53,-1),\" #,#\"),TEXT(ROUND(SUM(H39:O39)-E53,-1),\"#,# - \")&TEXT(ROUND(SUM(H40:O40)-E53,-1),\"#,#\")),\"\")","v":""}]
[null,null,null,"Wider social benefit-cost ratio",{"$f":"IFERROR(IF(SUM(H39:O39)=SUM(H40:O40),TEXT(ROUND(SUM(H39:O39)/E53,2),\"#.#0\"),TEXT(ROUND(SUM(H39:O39)/E53,2),\"#.#0 - \")&TEXT(ROUND(SUM(H40:O40)/E53,2),\"#.#0\")),0)","v":0}]

{"sheet":"Worked examples","index":4,"n_rows":353,"n_cols":16,"rows_kept":353,"cut":false,"hidden":false,"merged":[[213,3,213,14],[214,3,214,14],[186,4,186,5],[184,4,184,5],[215,3,215,14],[262,4,262,5],[263,4,263,5],[346,4,346,5],[345,4,345,5],[334,7,334,14],[341,3,341,6],[342,3,342,6],[343,3,343,6],[269,4,269,5],[264,4,264,5],[265,4,265,5],[266,4,266,5],[267,4,267,5],[268,4,268,5],[212,3,212,14],[185,4,185,5],[301,15,304,15],[302,7,302,12],[302,13,304,13],[302,14,304,14],[303,7,303,10],[303,11,304,11],[303,12,304,12],[301,6,304,6],[352,4,352,5],[347,4,347,5],[348,4,348,5],[349,4,349,5],[350,4,350,5],[351,4,351,5],[301,2,331,2],[301,3,304,3],[301,4,304,4],[301,5,304,5],[305,3,305,5],[331,3,331,6],[334,2,343,2],[334,3,334,5],[296,3,296,14],[297,3,297,14],[298,3,298,14],[305,7,305,14],[320,3,320,5],[320,7,320,14],[324,3,324,5],[330,3,330,6],[301,7,301,14],[251,2,260,2],[251,3,251,5],[251,7,251,14],[258,3,258,6],[259,3,259,6],[260,3,260,6],[222,3,222,5],[222,7,222,14],[237,3,237,5],[237,7,237,14],[241,3,241,5],[218,2,248,2],[247,3,247,6],[248,3,248,6],[218,15,221,15],[219,7,219,12],[219,13,221,13],[219,14,221,14],[220,7,220,10],[220,11,221,11],[220,12,221,12],[218,3,221,3],[218,4,221,4],[218,5,221,5],[218,6,221,6],[218,7,218,14],[8,8,9,8],[8,7,9,7],[8,6,9,6],[8,3,8,5],[8,2,9,2],[165,3,165,6],[168,2,177,2],[168,3,168,5],[168,7,168,14],[127,3,127,14],[128,3,128,14],[131,3,131,14],[132,3,132,14],[129,3,129,14],[130,3,130,14],[94,4,94,5],[95,4,95,5],[79,3,79,5],[87,3,87,6],[135,2,165,2],[23,2,24,2],[23,3,23,5],[23,6,24,6],[23,7,24,7],[17,2,17,9],[18,2,18,9],[19,2,19,9],[23,8,24,8],[75,3,75,6],[76,3,76,6],[50,3,50,5],[65,3,65,5],[69,3,69,5],[46,4,49,4],[46,5,49,5],[46,6,49,6],[46,2,49,3],[50,2,76,2],[43,2,43,14],[46,7,46,14],[48,11,49,11],[48,12,49,12],[47,14,49,14],[48,7,48,10],[47,13,49,13],[183,4,183,5],[139,3,139,5],[90,4,90,5],[91,4,91,5],[180,4,180,5],[139,7,139,14],[154,3,154,5],[179,4,179,5],[154,7,154,14],[175,3,175,6],[176,3,176,6],[177,3,177,6],[181,4,181,5],[182,4,182,5],[158,3,158,5],[164,3,164,6],[86,3,86,6],[88,3,88,6],[135,3,138,3],[79,2,88,2],[96,4,96,5],[92,4,92,5],[93,4,93,5],[97,4,97,5],[46,15,49,15],[135,15,138,15],[136,7,136,12],[136,13,138,13],[136,14,138,14],[137,7,137,10],[137,11,138,11],[137,12,138,12],[135,4,138,4],[135,5,138,5],[135,6,138,6],[135,7,135,14],[79,7,79,14],[50,7,50,14],[65,7,65,14],[47,7,47,12]]}
[]
[null,null,"Worked through examples using case studies"]
[]
[null,null,"The examples below are taken from 'Problem parental alcohol and drug use: Evidence pack'"]
[]
[null,null,"Case study 1: Sarah"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"In Sarah's case study there are 5 themes in the checklist that we can cost:"]
[null,null,null,"1. Child protection plan"]
[null,null,null,"2. Perinatal depression and anxiety"]
[null,null,null,"3. No risk of foetal alchohol spectrum disorder"]
[null,null,null,"4. Homelessness"]
[null,null,null,"5. Specialist treatment (community and residential)"]
[]
[null,null,"We found these themes in the table below, and placed a '1' where it relates to Sarah and or her baby. The table then automatically populated with the relevant costs, in 2019 to 2020 prices."]
[null,null,"Note: We have only presented the relevant cost themes below. You can view the full table by unhiding the rows on the left hand side."]
[]
[null,null,"The cost theme list is split into social benefits and costs. Social benefits are the positive outcomes that are measured following an intervention (for example a child no longer being on a child protection plan). "]
[null,null,"Costs refer to the cost of treatment and any ongoing support from early help or social care."]
[]
[null,null,"Avoiding double counting is the most important step of the process. The local authority (LA) costs below will almost always be mutually exclusive. For other costs it can be difficult to tell which ones overlap and are double counted. For example in Sarah’s case study, for NHS benefits, it is not clear whether any of the NHS costs for perinatal anxiety and depression are also included in the NHS costs associated with FASD and homelessness. For intangible costs also, we are usually given more than one figure. \n\nTo avoid the social cost-benefit being over-estimated by double counting, you can select \"No\" when asked whether the categories under each cost theme are mutually exclusive. The results will automatically update and present a range for these categories."]
[]
[]
[null,null,"Cost theme checklist",null,"No. of children","No. of adults","Corresponding tab","Costs avoided in first year after intervention",null,null,null,null,null,null,null,"Notes"]
[null,null,null,null,null,null,null,"Direct costs",null,null,null,null,null,"Indirect","Intangible"]
[null,null,null,null,null,null,null,"LA",null,null,null,"NHS","CJS"]
[null,null,null,null,null,null,null,"Social care","Education","Housing","Treatment"]
[null,null,"SOCIAL BENEFITS","Social care and early help support",null,null,"Social, YP & kinship care"]
[null,null,null,"Looked after - not in high cost placement",0,"n/a","Social, YP & kinship care",{"$f":"$E52*'Social, YP & kinship care'!$L$7","v":0}]
[null,null,null,"Child protection plan ",1,"n/a","Social, YP & kinship care",{"$f":"$E53*'Social, YP & kinship care'!$L$9","v":10400}]
[null,null,null,"Child in need",0,"n/a","Social, YP & kinship care",{"$f":"$E54*'Social, YP & kinship care'!$L$10","v":0}]
[null,null,null,"Early help",0,"n/a","Social, YP & kinship care",{"$f":"$E55*'Social, YP & kinship care'!$L$11","v":0}]
[null,null,null,"Troubled Families programme",0,"n/a","Social, YP & kinship care",{"$f":"$E56*'Social, YP & kinship care'!$L$12","v":0}]
[null,null,null,"Young person adopting carer role",0,"n/a","Social, YP & kinship care",null,null,null,null,null,null,{"$f":"E57*'Social, YP & kinship care'!$K$20","v":0}]
[null,null,null,"Kinship care","n/a",0,"Social, YP & kinship care",null,null,null,null,null,null,{"$f":"F58*'Social, YP & kinship care'!$K$21","v":0}]
[null,null,null,"Exclusion from school",0,"n/a","Education ",{"$f":"$E59*(Education!$L$10)","v":0},{"$f":"$E59*(Education!$L$7)","v":0},null,null,{"$f":"E59*Education!$L$11","v":0}]
[null,null,null,"Truancy",0,"n/a","Education ",{"$f":"E60*(Education!$L$16)","v":0},{"$f":"E60*(Education!$L$13)","v":0},null,null,{"$f":"E60*(Education!$L$17)","v":0}]
[null,null,null,"Perinatal depression",1,"n/a","Disorders",null,null,null,null,{"$f":"E61*(Disorders!$L$8+Disorders!$L$10+Disorders!$L$11)","v":60},null,null,{"$f":"E61*(Disorders!$N$8+Disorders!$N$9)","v":5100}]
[null,null,null,"Perinatal anxiety",1,"n/a","Disorders",null,null,null,null,{"$f":"E62*(Disorders!$L$16+Disorders!$L$17+Disorders!$L$18+Disorders!$L$19)","v":300},null,{"$f":"E62*(Disorders!$M$19)","v":50},{"$f":"E62*Disorders!$N$16","v":200}]
[null,null,null,"Conduct disorder",0,"n/a","Disorders",{"$f":"$E63*(Disorders!$L$23)","v":0},{"$f":"$E63*(Disorders!$L$21)","v":0},null,null,{"$f":"$E63*Disorders!$L$22","v":0}]
[null,null,null,"Foetal alcohol spectrum disorder",1,"n/a","Disorders",{"$f":"$E64*Disorders!$L$26","v":11100},{"$f":"$E64*Disorders!$L$28","v":3700},null,null,{"$f":"$E64*Disorders!$L$25","v":2400}]
[null,null,null,"Homelessness",1,1,"Homeslessness",null,null,{"$f":"IF(E65>0,1*Homelessness!$L$6,0)","v":16900},null,{"$f":"E65*(Homelessness!$L$13+Homelessness!$L$14)+F65*Homelessness!$L$8","v":1200},{"$f":"F65*Homelessness!L9","v":2700},null,{"$f":"E65*Homelessness!$N$15+F65*Homelessness!$N$10","v":18600}]
[null,null,null,"NHS treatment",null,null,"NHS and LA Treatment"]
[null,null,null,"Cognitive behavioural therapy (CBT) for adolescents",0,"n/a","NHS and LA Treatment",null,null,null,null,{"$f":"E67*'NHS & LA treatment'!$L$18","v":0}]
[null,null,null,"Counselling for children with mental or emotional difficulties",0,"n/a","NHS and LA Treatment",null,null,null,null,{"$f":"E68*'NHS & LA treatment'!$L$19","v":0}]
[null,null,null,"Domestic abuse","n/a",0,"DA & crime",null,null,null,null,{"$f":"F69*'DA & crime'!$L$7","v":0},{"$f":"F69*'DA & crime'!$L$10","v":0},{"$f":"F69*('DA & crime'!$M$11+'DA & crime'!$M$8)","v":0},{"$f":"F69*'DA & crime'!$N$9","v":0}]
[null,null,null,"Crime","","","DA & crime"]
[null,null,null,"Violence","n/a",0,null,null,null,null,null,{"$f":"F71*AVERAGE('DA & crime'!$L$13,'DA & crime'!$L$19)*6","v":0},{"$f":"F71*AVERAGE('DA & crime'!$L$16,'DA & crime'!$L$22)*6","v":0},{"$f":"F71*AVERAGE('DA & crime'!$M$14,'DA & crime'!$M$17,'DA & crime'!$M$20,'DA & crime'!$M$23)*6","v":0},{"$f":"F71*AVERAGE('DA & crime'!$N$15,'DA & crime'!$N$21)*6","v":0}]
[null,null,null,"Shoplifting","n/a",0,"DA & crime",null,null,null,null,null,{"$f":"$F72*'DA & crime'!$L$24*100","v":0}]
[null,null,null,"Robbery","n/a",0,"DA & crime",null,null,null,null,{"$f":"F73*'DA & crime'!$L$26*15","v":0},{"$f":"F73*'DA & crime'!$L$29*15","v":0},{"$f":"F73*('DA & crime'!$M$27+'DA & crime'!$M$30)*15","v":0},{"$f":"F73*'DA & crime'!$N$28*15","v":0}]
[null,null,null,"House burglary","n/a",0,"DA & crime",null,null,null,null,{"$f":"F74*'DA & crime'!$L$32*25","v":0},{"$f":"F74*'DA & crime'!$L$35*25","v":0},{"$f":"F74*('DA & crime'!$M$33+'DA & crime'!$M$36)*25","v":0},{"$f":"F74*'DA & crime'!$N$34*25","v":0}]
[null,null,null,"Police call out","n/a",0,null,null,null,null,null,null,{"$f":"$F75*'DA & crime'!$L$44*6","v":0}]
[null,null,null,"Are costs mutually exclusive?",null,null,null,"No","No","No",null,"No","No","No","No"]
[null,null,null,"Total benefits (where costs are not mutually exclusive, a range is presented)",null,null,null,{"$f":"IF(H76=\"No\",\"(£\"&(ROUND(SMALL(H52:H75,COUNTIF(H52:H75,0)+1),0))&\" - £\"&(ROUND(MAX(H52:H75),0))&\")\",SUM(H52:H75))","v":"(£10400 - £11100)"},{"$f":"IF(I76=\"No\",\"(£\"&(ROUND(SMALL(I52:I75,COUNTIF(I52:I75,0)+1),0))&\" - £\"&(ROUND(MAX(I52:I75),0))&\")\",SUM(I52:I75))","v":"(£3700 - £3700)"},{"$f":"IF(J76=\"No\",\"(£\"&(ROUND(SMALL(J52:J75,COUNTIF(J52:J75,0)+1),0))&\" - £\"&(ROUND(MAX(J52:J75),0))&\")\",SUM(J52:J75))","v":"(£16900 - £16900)"},null,{"$f":"IF(L76=\"No\",\"(£\"&(ROUND(SMALL(L52:L75,COUNTIF(L52:L75,0)+1),0))&\" - £\"&(ROUND(MAX(L52:L75),0))&\")\",SUM(L52:L75))","v":"(£60 - £2400)"},{"$f":"IF(M76=\"No\",\"(£\"&(ROUND(SMALL(M52:M75,COUNTIF(M52:M75,0)+1),0))&\" - £\"&(ROUND(MAX(M52:M75),0))&\")\",SUM(M52:M75))","v":"(£2700 - £2700)"},{"$f":"IF(N76=\"No\",\"(£\"&(ROUND(SMALL(N52:N75,COUNTIF(N52:N75,0)+1),0))&\" - £\"&(ROUND(MAX(N52:N75),0))&\")\",SUM(N52:N75))","v":"(£50 - £50)"},{"$f":"IF(O76=\"No\",\"(£\"&(ROUND(SMALL(O52:O75,COUNTIF(O52:O75,0)+1),0))&\" - £\"&(ROUND(MAX(O52:O75),0))&\")\",SUM(O52:O75))","v":"(£200 - £18600)"}]
[null,null,null,null,null,"Min",null,{"$f":"IF(H76=\"No\",SMALL((H52:H75),COUNTIF(H52:H75,0)+1),SUM(H52:H75))","v":10400},{"$f":"IF(I76=\"No\",SMALL((I52:I75),COUNTIF(I52:I75,0)+1),SUM(I52:I75))","v":3700},16900,null,60,2700,50,200]
[null,null,null,null,null,"Max",null,{"$f":"IF(H76=\"No\",MAX(H52:H75),SUM(H52:H75))","v":11100},{"$f":"IF(I76=\"No\",MAX(I52:I75),SUM(I52:I75))","v":3700},16900,null,2400,2700,50,18600]
[null,null,"COSTS","Alcohol and drug treatment",0,0,"NHS and LA Treatment"]
[null,null,null,"Treatment for opioid use","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F81*'NHS & LA treatment'!$L$20","v":0}]
[null,null,null,"Treatment for non-opioid drug use","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F82*'NHS & LA treatment'!$L$21","v":0}]
[null,null,null,"Treatment for alcohol use","n/a",1,"NHS and LA Treatment",null,null,null,{"$f":"F83*'NHS & LA treatment'!$L$22","v":1300}]
[null,null,null,"Treatment for young people (alcohol and drugs)",0,"n/a","NHS and LA Treatment",null,null,null,{"$f":"E84*'NHS & LA treatment'!$L$23","v":0}]
[null,null,null,"Inpatient detoxfication","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F85*'NHS & LA treatment'!$L$24","v":0}]
[null,null,null,"Residential rehabilitation","n/a",1,"NHS and LA Treatment",null,null,null,{"$f":"F86*'NHS & LA treatment'!$L$25","v":9800}]
[null,null,null,"Other treatment cost should be added here",null,null,null,null,null,null,{"$f":"0","v":0}]
[null,null,null,"Any ongoing treatment or social support cost (for example, early help)",null,null,null,0,null,null,{"$f":"0","v":0}]
[null,null,null,"Total costs",null,null,null,{"$f":"SUM(H81:H88)","v":0},null,null,{"$f":"SUM(K81:K88)","v":11100}]
[]
[null,null,null,null,"£"]
[null,null,null,"Total costs",{"$f":"SUM(H89:O89)","v":11100}]
[null,null,null,"Gross social benefit (LA)",{"$f":"IF(SUM(H78:K78)=SUM(H79:K79),TEXT(ROUND(SUM(H78:K78),-1),\"#,#\"),TEXT(ROUND(SUM(H78:K78),-1),\" #,# - \")&TEXT(ROUND(SUM(H79:K79),-1),\"#,#\"))","v":" 31,000 - 31,700"}]
[null,null,null,"Net social benefit (LA)",{"$f":"IF(SUM(H78:K78)=SUM(H79:K79),TEXT(ROUND(SUM(H78:K78)-E92,-1),\"#,#\"),TEXT(ROUND(SUM(H78:K78)-E92,-1),\"#,# - \")&TEXT(ROUND(SUM(H79:K79)-E92,-1),\"#,#\"))","v":"19,900 - 20,600"}]
[null,null,null,"Social benefit-cost ratio (LA costs)",{"$f":"IFERROR(IF(SUM(H78:K78)=SUM(H79:K79),TEXT(ROUND(SUM(H78:K78)/E92,2),\"#.#0\"),TEXT(ROUND(SUM(H78:K78)/E92,2),\"#.#0 - \")&TEXT(ROUND(SUM(H79:K79)/E92,2),\"#.#0\")),0)","v":"2.79 - 2.86"}]
[null,null,null,"Wider net social benefits (gross)",{"$f":"IF(SUM(H78:O78)=SUM(H79:O79),TEXT(ROUND(SUM(H78:O78),-1),\"#,#\"),TEXT(ROUND(SUM(H78:O78),-1),\" #,# - \")&TEXT(ROUND(SUM(H79:O79),-1),\"#,#\"))","v":" 34,010 - 55,450"}]
[null,null,null,"Wider net social benefits (net)",{"$f":"IF(SUM(H78:O78)=SUM(H79:O79),TEXT(ROUND(SUM(H78:O78)-E92,-1),\" #,#\"),TEXT(ROUND(SUM(H78:O78)-E92,-1),\"#,# - \")&TEXT(ROUND(SUM(H79:O79)-E92,-1),\"#,#\"))","v":"22,910 - 44,350"}]
[null,null,null,"Wider social benefit-cost ratio",{"$f":"IFERROR(IF(SUM(H78:O78)=SUM(H79:O79),TEXT(ROUND(SUM(H78:O78)/E92,2),\"#.#0\"),TEXT(ROUND(SUM(H78:O78)/E92,2),\"#.#0 - \")&TEXT(ROUND(SUM(H79:O79)/E92,2),\"#.#0\")),0)","v":"3.06 - 5.0"}]
[]
[]
[null,null,"Case study 2: Jenny and Steve"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"In Jenny and Steve's case study there are 6 themes in the checklist that we can cost:"]
[null,null,null,"1. Jenny's baby was subject to an interim care order and Jenny has had children removed from her care before, so we can assume that without intervention the baby would have become looked after by the local authority and removed from the family home"]
[null,null,null,"2. The child is now on home placement agreement, but if Jenny and Steve continue to recover, social care involvement will cease. To be conservative, we have assumed that a year post-intervention the ongoing social care cost will average out to an annual cost of being on a child in need plan"]
[null,null,null,"3. If Steve's violence was fuelled by his drug use, then remaining substance free is likely to stop his violent offending"]
[null,null,null,"4. Domestic abuse"]
[null,null,null,"5. Homelessness"]
[null,null,null,"6. Treatment in the community and in a residential centre"]
[]
[]
[null,null,"SOCIAL BENEFITS","Cost theme checklist","No. of children","No. of adults","Corresponding tab","Costs avoided in first year after intervention",null,null,null,null,null,null,null,"Notes"]
[null,null,null,null,null,null,null,"Direct costs",null,null,null,null,null,"Indirect","Intangible"]
[null,null,null,null,null,null,null,"LA",null,null,null,"NHS","CJS"]
[null,null,null,null,null,null,null,"Social care","Education","Housing","Treatment"]
[null,null,null,"Social care and early help support",null,null,"Social, YP & kinship care"]
[null,null,null,"Looked after - not in high cost placement",1,"n/a","Social, YP & kinship care",{"$f":"$E141*'Social, YP & kinship care'!$L$7","v":60000},null,null,null,null,null,null,null,"Baby was subject to an interim care order and Jenny has had children removed from her care before, so we can assume that without intervention the baby would have been removed from the home"]
[null,null,null,"Child protection plan ",0,"n/a","Social, YP & kinship care",{"$f":"$E142*'Social, YP & kinship care'!$L$9","v":0}]
[null,null,null,"Child in need",0,"n/a","Social, YP & kinship care",{"$f":"$E143*'Social, YP & kinship care'!$L$10","v":0}]
[null,null,null,"Early help",0,"n/a","Social, YP & kinship care",{"$f":"$E144*'Social, YP & kinship care'!$L$11","v":0}]
[null,null,null,"Troubled Families programme",0,"n/a","Social, YP & kinship care",{"$f":"$E145*'Social, YP & kinship care'!$L$12","v":0}]
[null,null,null,"Young person adopting carer role",0,"n/a","Social, YP & kinship care",null,null,null,null,null,null,{"$f":"E146*'Social, YP & kinship care'!$K$20","v":0}]
[null,null,null,"Kinship care","n/a",0,"Social, YP & kinship care",null,null,null,null,null,null,{"$f":"F147*'Social, YP & kinship care'!$K$21","v":0}]
[null,null,null,"Exclusion from school",0,"n/a","Education ",{"$f":"$E148*(Education!$L$10)","v":0},{"$f":"$E148*(Education!$L$7)","v":0},null,null,{"$f":"E148*Education!$L$11","v":0}]
[null,null,null,"Truancy",0,"n/a","Education ",{"$f":"E149*(Education!$L$16)","v":0},{"$f":"E149*(Education!$L$13)","v":0},null,null,{"$f":"E149*(Education!$L$17)","v":0}]
[null,null,null,"Perinatal depression",0,"n/a","Disorders",null,null,null,null,{"$f":"E150*(Disorders!$L$8+Disorders!$L$10+Disorders!$L$11)","v":0},null,null,{"$f":"E150*(Disorders!$N$8+Disorders!$N$9)","v":0}]
[null,null,null,"Perinatal anxiety",0,"n/a","Disorders",null,null,null,null,{"$f":"E151*(Disorders!$L$16+Disorders!$L$17+Disorders!$L$18+Disorders!$L$19)","v":0},null,{"$f":"E151*(Disorders!$M$19)","v":0},{"$f":"E151*Disorders!$N$16","v":0}]
[null,null,null,"Conduct disorder",0,"n/a","Disorders",{"$f":"$E152*(Disorders!$L$23)","v":0},{"$f":"$E152*(Disorders!$L$21)","v":0},null,null,{"$f":"$E152*Disorders!$L$22","v":0}]
[null,null,null,"Foetal alcohol spectrum disorder",0,"n/a","Disorders",{"$f":"$E153*Disorders!$L$26","v":0},{"$f":"$E153*Disorders!$L$28","v":0},null,null,{"$f":"$E153*Disorders!$L$25","v":0}]
[null,null,null,"Homelessness",1,1,"Homeslessness",null,null,{"$f":"IF(E154>0,1*Homelessness!$L$6,0)","v":16900},null,{"$f":"E154*(Homelessness!$L$13+Homelessness!$L$14)+F154*Homelessness!$L$8","v":1200},{"$f":"F154*Homelessness!L9","v":2700},null,{"$f":"E154*Homelessness!$N$15+F154*Homelessness!$N$10","v":18600}]
[null,null,null,"NHS treatment",null,null,"NHS and LA Treatment"]
[null,null,null,"Cognitive behavioural therapy (CBT) for adolescents",0,"n/a","NHS and LA Treatment",null,null,null,null,{"$f":"E156*'NHS & LA treatment'!$L$18","v":0}]
[null,null,null,"Counselling for children with mental or emotional difficulties",0,"n/a","NHS and LA Treatment",null,null,null,null,{"$f":"E157*'NHS & LA treatment'!$L$19","v":0}]
[null,null,null,"Domestic abuse","n/a",1,"DA & crime",null,null,null,null,{"$f":"F158*'DA & crime'!$L$7","v":1400},{"$f":"F158*'DA & crime'!$L$10","v":1000},{"$f":"F158*('DA & crime'!$M$11+'DA & crime'!$M$8)","v":8700},{"$f":"F158*'DA & crime'!$N$9","v":21400}]
[null,null,null,"Crime","","","DA & crime"]
[null,null,null,"Violence","n/a",1,null,null,null,null,null,{"$f":"F160*AVERAGE('DA & crime'!$L$13,'DA & crime'!$L$19)*6","v":4200},{"$f":"F160*AVERAGE('DA & crime'!$L$16,'DA & crime'!$L$22)*6","v":15900},{"$f":"F160*AVERAGE('DA & crime'!$M$14,'DA & crime'!$M$17,'DA & crime'!$M$20,'DA & crime'!$M$23)*6","v":5550},{"$f":"F160*AVERAGE('DA & crime'!$N$15,'DA & crime'!$N$21)*6","v":29400},"If Steve's violence was fuelled by his drug use, then remaining substance free is likely to stop his violent offending"]
[null,null,null,"Shoplifting","n/a",0,"DA & crime",null,null,null,null,null,{"$f":"$F161*'DA & crime'!$L$24*100","v":0}]
[null,null,null,"Robbery","n/a",0,"DA & crime",null,null,null,null,{"$f":"F162*'DA & crime'!$L$26*15","v":0},{"$f":"F162*'DA & crime'!$L$29*15","v":0},{"$f":"F162*('DA & crime'!$M$27+'DA & crime'!$M$30)*15","v":0},{"$f":"F162*'DA & crime'!$N$28*15","v":0}]
[null,null,null,"House burglary","n/a",0,"DA & crime",null,null,null,null,{"$f":"F163*'DA & crime'!$L$32*25","v":0},{"$f":"F163*'DA & crime'!$L$35*25","v":0},{"$f":"F163*('DA & crime'!$M$33+'DA & crime'!$M$36)*25","v":0},{"$f":"F163*'DA & crime'!$N$34*25","v":0}]
[null,null,null,"Police call out","n/a",0,null,null,null,null,null,null,{"$f":"$F164*'DA & crime'!$L$44*6","v":0}]
[null,null,null,"Are costs mutually exclusive?",null,null,null,"Yes","[Select]","Yes",null,"No","No","Yes","No"]
[null,null,null,"Total benefits (where costs are not mutually exclusive, a range is presented)",null,null,null,{"$f":"IF(H165=\"No\",\"(£\"&(ROUND(SMALL(H141:H164,COUNTIF(H141:H164,0)+1),0))&\" - £\"&(ROUND(MAX(H141:H164),0))&\")\",SUM(H141:H164))","v":60000},{"$f":"IF(I165=\"No\",\"(£\"&(ROUND(SMALL(I141:I164,COUNTIF(I141:I164,0)+1),0))&\" - £\"&(ROUND(MAX(I141:I164),0))&\")\",SUM(I141:I164))","v":0},16900,null,{"$f":"IF(L165=\"No\",\"(£\"&(ROUND(SMALL(L141:L164,COUNTIF(L141:L164,0)+1),0))&\" - £\"&(ROUND(MAX(L141:L164),0))&\")\",SUM(L141:L164))","v":"(£1200 - £4200)"},"(£1000 - £15900)",14250,"(£18600 - £29400)"]
[null,null,null,null,null,null,null,{"$f":"IF(H165=\"No\",SMALL((H141:H164),COUNTIF(H141:H164,0)+1),SUM(H141:H164))","v":60000},{"$f":"IF(I165=\"No\",SMALL((I141:I164),COUNTIF(I141:I164,0)+1),SUM(I141:I164))","v":0},16900,null,1200,1000,14250,18600]
[null,null,null,null,null,null,null,{"$f":"IF(H165=\"No\",MAX(H141:H164),SUM(H141:H164))","v":60000},{"$f":"IF(I165=\"No\",MAX(I141:I164),SUM(I141:I164))","v":0},16900,null,4200,15900,14250,29400]
[null,null,"COSTS","Alcohol and drug treatment",0,0,"NHS and LA Treatment"]
[null,null,null,"Treatment for opioid use","n/a",2,"NHS and LA Treatment",null,null,null,{"$f":"F170*'NHS & LA treatment'!$L$20","v":5600},null,null,null,null,"Assume the support programme Jenny and Steve received costs the same as standard treatment for heroin use"]
[null,null,null,"Treatment for non-opioid drug use","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F171*'NHS & LA treatment'!$L$21","v":0}]
[null,null,null,"Treatment for alcohol use","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F172*'NHS & LA treatment'!$L$22","v":0}]
[null,null,null,"Treatment for young people (alcohol and drugs)",0,"n/a","NHS and LA Treatment",null,null,null,{"$f":"E173*'NHS & LA treatment'!$L$23","v":0}]
[null,null,null,"Inpatient detoxfication","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F174*'NHS & LA treatment'!$L$24","v":0}]
[null,null,null,"Residential rehabilitation","n/a",2,"NHS and LA Treatment",null,null,null,{"$f":"F175*'NHS & LA treatment'!$L$25","v":19600},null,null,null,null,"Assume Steve received tx for 10% of the time"]
[null,null,null,"Other treatment cost should be added here",null,null,null,null,null,null,{"$f":"0","v":0}]
[null,null,null,"Any ongoing treatment or social support cost (for example, early help)",null,null,null,{"$f":"'Social, YP & kinship care'!L10","v":9300},null,null,{"$f":"0","v":0},null,null,null,null,"The child is now on home placement agreement, but if Jenny and Steve continue to recover, social care involvement will cease. To be conservative, we have assumed that a year post-intervention the ongoing social care cost will average out to an annual cost of being on a child in need plan"]
[null,null,null,"Total costs",null,null,null,{"$f":"SUM(H170:H177)","v":9300},null,null,{"$f":"SUM(K170:K177)","v":25200}]
[]
[null,null,null,null,"£"]
[null,null,null,"Total costs",{"$f":"SUM(H178:O178)","v":34500}]
[null,null,null,"Gross social benefit (LA)",{"$f":"IF(SUM(H167:K167)=SUM(H168:K168),TEXT(ROUND(SUM(H167:K167),-1),\"#,#\"),TEXT(ROUND(SUM(H167:K167),-1),\" #,# - \")&TEXT(ROUND(SUM(H168:K168),-1),\"#,#\"))","v":"76,900"}]
[null,null,null,"Net social benefit (LA)",{"$f":"IF(SUM(H167:K167)=SUM(H168:K168),TEXT(ROUND(SUM(H167:K167)-E181,-1),\"#,#\"),TEXT(ROUND(SUM(H167:K167)-E181,-1),\"#,# - \")&TEXT(ROUND(SUM(H168:K168)-E181,-1),\"#,#\"))","v":"42,400"}]
[null,null,null,"Social benefit-cost ratio (LA costs)",{"$f":"IFERROR(IF(SUM(H167:K167)=SUM(H168:K168),TEXT(ROUND(SUM(H167:K167)/E181,2),\"#.#0\"),TEXT(ROUND(SUM(H167:K167)/E181,2),\"#.#0 - \")&TEXT(ROUND(SUM(H168:K168)/E181,2),\"#.#0\")),0)","v":"2.23"}]
[null,null,null,"Wider net social benefits (gross)",{"$f":"IF(SUM(H167:O167)=SUM(H168:O168),TEXT(ROUND(SUM(H167:O167),-1),\"#,#\"),TEXT(ROUND(SUM(H167:O167),-1),\" #,# - \")&TEXT(ROUND(SUM(H168:O168),-1),\"#,#\"))","v":" 111,950 - 140,650"}]
[null,null,null,"Wider net social benefits (net)",{"$f":"IF(SUM(H167:O167)=SUM(H168:O168),TEXT(ROUND(SUM(H167:O167)-E181,-1),\" #,#\"),TEXT(ROUND(SUM(H167:O167)-E181,-1),\"#,# - \")&TEXT(ROUND(SUM(H168:O168)-E181,-1),\"#,#\"))","v":"77,450 - 106,150"}]
[null,null,null,"Wider social benefit-cost ratio",{"$f":"IFERROR(IF(SUM(H167:O167)=SUM(H168:O168),TEXT(ROUND(SUM(H167:O167)/E181,2),\"#.#0\"),TEXT(ROUND(SUM(H167:O167)/E181,2),\"#.#0 - \")&TEXT(ROUND(SUM(H168:O168)/E181,2),\"#.#0\")),0)","v":"3.24 - 4.08"}]
[]
[]
[null,null,"Case study 3: Hannah and Dave"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"In Hannah and Dave's case study there are 4 themes in the checklist that we can cost:"]
[null,null,null,"1. All 5 children moved from child protection to child in need plans"]
[null,null,null,"2. The eldest daughter was a young carer"]
[null,null,null,"3. Two children were truanting from school, both were displaying physical and verbal aggression as well and one running away from home and so were likely to have become expelled "]
[null,null,null,"4. Family therapy for Hannah and her children"]
[]
[]
[null,null,"SOCIAL BENEFITS","Cost theme checklist","No. of children","No. of adults","Corresponding tab","Costs avoided in first year after intervention",null,null,null,null,null,null,null,"Notes"]
[null,null,null,null,null,null,null,"Direct costs",null,null,null,null,null,"Indirect","Intangible"]
[null,null,null,null,null,null,null,"LA",null,null,null,"NHS","CJS"]
[null,null,null,null,null,null,null,"Social care","Education","Housing","Treatment"]
[null,null,null,"Social care and early help support",null,null,"Social, YP & kinship care"]
[null,null,null,"Looked after - not in high cost placement",0,"n/a","Social, YP & kinship care",{"$f":"$E224*'Social, YP & kinship care'!$L$7","v":0}]
[null,null,null,"Child protection plan ",5,"n/a","Social, YP & kinship care",{"$f":"$E225*'Social, YP & kinship care'!$L$9","v":52000},null,null,null,null,null,null,null,"This is a conservative estimate. Given the family circumstances, it is probable that the children would have been stepped up tp child looked after status."]
[null,null,null,"Child in need",0,"n/a","Social, YP & kinship care",{"$f":"$E226*'Social, YP & kinship care'!$L$10","v":0}]
[null,null,null,"Early help",0,"n/a","Social, YP & kinship care",{"$f":"$E227*'Social, YP & kinship care'!$L$11","v":0}]
[null,null,null,"Troubled Families programme",0,"n/a","Social, YP & kinship care",{"$f":"$E228*'Social, YP & kinship care'!$L$12","v":0}]
[null,null,null,"Young person adopting carer role",1,"n/a","Social, YP & kinship care",null,null,null,null,null,null,{"$f":"E229*'Social, YP & kinship care'!$K$20","v":5900}]
[null,null,null,"Kinship care","n/a",0,"Social, YP & kinship care",null,null,null,null,null,null,{"$f":"F230*'Social, YP & kinship care'!$K$21","v":0}]
[null,null,null,"Exclusion from school",2,"n/a","Education ",{"$f":"$E231*(Education!$L$10)","v":4800},{"$f":"$E231*(Education!$L$7)","v":20400},null,null,{"$f":"E231*Education!$L$11","v":200}]
[null,null,null,"Truancy",0,"n/a","Education ",{"$f":"E232*(Education!$L$16)","v":0},{"$f":"E232*(Education!$L$13)","v":0},null,null,{"$f":"E232*(Education!$L$17)","v":0}]
[null,null,null,"Perinatal depression",0,"n/a","Disorders",null,null,null,null,{"$f":"E233*(Disorders!$L$8+Disorders!$L$10+Disorders!$L$11)","v":0},null,null,{"$f":"E233*(Disorders!$N$8+Disorders!$N$9)","v":0}]
[null,null,null,"Perinatal anxiety",0,"n/a","Disorders",null,null,null,null,{"$f":"E234*(Disorders!$L$16+Disorders!$L$17+Disorders!$L$18+Disorders!$L$19)","v":0},null,{"$f":"E234*(Disorders!$M$19)","v":0},{"$f":"E234*Disorders!$N$16","v":0}]
[null,null,null,"Conduct disorder",0,"n/a","Disorders",{"$f":"$E235*(Disorders!$L$23)","v":0},{"$f":"$E235*(Disorders!$L$21)","v":0},null,null,{"$f":"$E235*Disorders!$L$22","v":0}]
[null,null,null,"Foetal alcohol spectrum disorder",0,"n/a","Disorders",{"$f":"$E236*Disorders!$L$26","v":0},{"$f":"$E236*Disorders!$L$28","v":0},null,null,{"$f":"$E236*Disorders!$L$25","v":0}]
[null,null,null,"Homelessness",0,0,"Homeslessness",null,null,{"$f":"IF(E237>0,1*Homelessness!$L$6,0)","v":0},null,{"$f":"E237*(Homelessness!$L$13+Homelessness!$L$14)+F237*Homelessness!$L$8","v":0},{"$f":"F237*Homelessness!#REF!","v":{"$error":"#REF!"}},null,{"$f":"E237*Homelessness!$N$15+F237*Homelessness!$N$10","v":0}]
[null,null,null,"NHS treatment",null,null,"NHS and LA Treatment"]
[null,null,null,"Cognitive behavioural therapy (CBT) for adolescents",0,"n/a","NHS and LA Treatment",null,null,null,null,{"$f":"E239*'NHS & LA treatment'!$L$18","v":0}]
[null,null,null,"Counselling for children with mental or emotional difficulties",0,"n/a","NHS and LA Treatment",null,null,null,null,{"$f":"E240*'NHS & LA treatment'!$L$19","v":0}]
[null,null,null,"Domestic abuse","n/a",0,"DA & crime",null,null,null,null,{"$f":"F241*'DA & crime'!$L$7","v":0},{"$f":"F241*'DA & crime'!$L$10","v":0},{"$f":"F241*('DA & crime'!$M$11+'DA & crime'!$M$8)","v":0},{"$f":"F241*'DA & crime'!$N$9","v":0}]
[null,null,null,"Crime","","","DA & crime"]
[null,null,null,"Violence","n/a",0,null,null,null,null,null,{"$f":"F243*AVERAGE('DA & crime'!$L$13,'DA & crime'!$L$19)*6","v":0},{"$f":"F243*AVERAGE('DA & crime'!$L$16,'DA & crime'!$L$22)*6","v":0},{"$f":"F243*AVERAGE('DA & crime'!$M$14,'DA & crime'!$M$17,'DA & crime'!$M$20,'DA & crime'!$M$23)*6","v":0},{"$f":"F243*AVERAGE('DA & crime'!$N$15,'DA & crime'!$N$21)*6","v":0}]
[null,null,null,"Shoplifting","n/a",0,"DA & crime",null,null,null,null,null,{"$f":"$F244*'DA & crime'!$L$24*100","v":0}]
[null,null,null,"Robbery","n/a",0,"DA & crime",null,null,null,null,{"$f":"F245*'DA & crime'!$L$26*15","v":0},{"$f":"F245*'DA & crime'!$L$29*15","v":0},{"$f":"F245*('DA & crime'!$M$27+'DA & crime'!$M$30)*15","v":0},{"$f":"F245*'DA & crime'!$N$28*15","v":0}]
[null,null,null,"House burglary","n/a",0,"DA & crime",null,null,null,null,{"$f":"F246*'DA & crime'!$L$32*25","v":0},{"$f":"F246*'DA & crime'!$L$35*25","v":0},{"$f":"F246*('DA & crime'!$M$33+'DA & crime'!$M$36)*25","v":0},{"$f":"F246*'DA & crime'!$N$34*25","v":0}]
[null,null,null,"Police call out","n/a",0,null,null,null,null,null,null,{"$f":"$F247*'DA & crime'!$L$44*6","v":0}]
[null,null,null,"Are costs mutually exclusive?",null,null,null,"Yes","Yes","Yes",null,"Yes","No","Yes","[Select]"]
[null,null,null,"Total benefits (where costs are not mutually exclusive, a range is presented)",null,null,null,{"$f":"IF(H248=\"No\",\"(£\"&(ROUND(SMALL(H224:H247,COUNTIF(H224:H247,0)+1),0))&\" - £\"&(ROUND(MAX(H224:H247),0))&\")\",SUM(H224:H247))","v":56800},{"$f":"IF(I248=\"No\",\"(£\"&(ROUND(SMALL(I224:I247,COUNTIF(I224:I247,0)+1),0))&\" - £\"&(ROUND(MAX(I224:I247),0))&\")\",SUM(I224:I247))","v":20400},{"$f":"IF(J248=\"No\",\"(£\"&(ROUND(SMALL(J224:J247,COUNTIF(J224:J247,0)+1),0))&\" - £\"&(ROUND(MAX(J224:J247),0))&\")\",SUM(J224:J247))","v":0},null,{"$f":"IF(L248=\"No\",\"(£\"&(ROUND(SMALL(L224:L247,COUNTIF(L224:L247,0)+1),0))&\" - £\"&(ROUND(MAX(L224:L247),0))&\")\",SUM(L224:L247))","v":200},0,{"$f":"IF(N248=\"No\",\"(£\"&(ROUND(SMALL(N224:N247,COUNTIF(N224:N247,0)+1),0))&\" - £\"&(ROUND(MAX(N224:N247),0))&\")\",SUM(N224:N247))","v":5900},{"$f":"IF(O248=\"No\",\"(£\"&(ROUND(SMALL(O224:O247,COUNTIF(O224:O247,0)+1),0))&\" - £\"&(ROUND(MAX(O224:O247),0))&\")\",SUM(O224:O247))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H248=\"No\",SMALL((H224:H247),COUNTIF(H224:H247,0)+1),SUM(H224:H247))","v":56800},{"$f":"IF(I248=\"No\",SMALL((I224:I247),COUNTIF(I224:I247,0)+1),SUM(I224:I247))","v":20400},0,null,{"$f":"IF(L248=\"No\",SMALL((L224:L247),COUNTIF(L224:L247,0)+1),SUM(L224:L247))","v":200},0,5900,0]
[null,null,null,null,null,null,null,{"$f":"IF(H248=\"No\",MAX(H224:H247),SUM(H224:H247))","v":56800},{"$f":"IF(I248=\"No\",MAX(I224:I247),SUM(I224:I247))","v":20400},0,null,{"$f":"IF(L248=\"No\",MAX(L224:L247),SUM(L224:L247))","v":200},0,5900,0]
[null,null,"COSTS","Alcohol and/or drug treatment",0,0,"NHS and LA Treatment"]
[null,"Treatment for opioid use",null,"n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F253*'NHS & LA treatment'!$L$20","v":{"$error":"#VALUE!"}}]
[null,null,null,"Treatment for non-opioid drug use","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F254*'NHS & LA treatment'!$L$21","v":0}]
[null,null,null,"Treatment for alcohol use","n/a",{"$f":"1+(0.5*1)","v":1.5},"NHS and LA Treatment",null,null,null,{"$f":"F255*'NHS & LA treatment'!$L$22","v":1950},null,null,null,null,"We have assumed the cost of treating the children are half that of treating mother for alcohol dependency and the children can be considered as one 'unit' for costs purposes."]
[null,null,null,"Treatment for young people (alcohol and drugs)",0,"n/a","NHS and LA Treatment",null,null,null,{"$f":"E256*'NHS & LA treatment'!$L$23","v":0}]
[null,null,null,"Inpatient detoxfication","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F257*'NHS & LA treatment'!$L$24","v":0}]
[null,null,null,"Residential rehabilitation","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F258*'NHS & LA treatment'!$L$25","v":0}]
[null,null,null,"Other treatment cost should be added here",null,null,null,null,null,null,{"$f":"0","v":0}]
[null,null,null,"Any ongoing treatment or social support cost (for example, early help)",null,null,null,{"$f":"5*'Social, YP & kinship care'!$L$10","v":46500},null,null,{"$f":"0","v":0},null,null,null,null,"Child in need plans for the 5 children"]
[null,null,null,"Total costs",null,null,null,{"$f":"SUM(H253:H260)","v":46500},null,null,{"$f":"SUM(K253:K260)","v":1950}]
[]
[null,null,null,null,"£"]
[null,null,null,"Total costs",{"$f":"SUM(H261:O261)","v":48450}]
[null,null,null,"Gross social benefit (LA)",{"$f":"IF(SUM(H250:K250)=SUM(H251:K251),TEXT(ROUND(SUM(H250:K250),-1),\"#,#\"),TEXT(ROUND(SUM(H250:K250),-1),\" #,# - \")&TEXT(ROUND(SUM(H251:K251),-1),\"#,#\"))","v":"77,200"}]
[null,null,null,"Net social benefit (LA)",{"$f":"IF(SUM(H250:K250)=SUM(H251:K251),TEXT(ROUND(SUM(H250:K250)-E264,-1),\"#,#\"),TEXT(ROUND(SUM(H250:K250)-E264,-1),\"#,# - \")&TEXT(ROUND(SUM(H251:K251)-E264,-1),\"#,#\"))","v":"28,750"}]
[null,null,null,"Social benefit-cost ratio (LA costs)",{"$f":"IFERROR(IF(SUM(H250:K250)=SUM(H251:K251),TEXT(ROUND(SUM(H250:K250)/E264,2),\"#.#0\"),TEXT(ROUND(SUM(H250:K250)/E264,2),\"#.#0 - \")&TEXT(ROUND(SUM(H251:K251)/E264,2),\"#.#0\")),0)","v":"1.59"}]
[null,null,null,"Wider net social benefits (gross)",{"$f":"IF(SUM(H250:O250)=SUM(H251:O251),TEXT(ROUND(SUM(H250:O250),-1),\"#,#\"),TEXT(ROUND(SUM(H250:O250),-1),\" #,# - \")&TEXT(ROUND(SUM(H251:O251),-1),\"#,#\"))","v":"83,300"}]
[null,null,null,"Wider net social benefits (net)",{"$f":"IF(SUM(H250:O250)=SUM(H251:O251),TEXT(ROUND(SUM(H250:O250)-E264,-1),\" #,#\"),TEXT(ROUND(SUM(H250:O250)-E264,-1),\"#,# - \")&TEXT(ROUND(SUM(H251:O251)-E264,-1),\"#,#\"))","v":" 34,850"}]
[null,null,null,"Wider social benefit-cost ratio",{"$f":"IFERROR(IF(SUM(H250:O250)=SUM(H251:O251),TEXT(ROUND(SUM(H250:O250)/E264,2),\"#.#0\"),TEXT(ROUND(SUM(H250:O250)/E264,2),\"#.#0 - \")&TEXT(ROUND(SUM(H251:O251)/E264,2),\"#.#0\")),0)","v":"1.72"}]
[]
[]
[null,null,"Case study 4: Tracey and Darryl"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"In Tracey and Darryl's case study there are 3 themes in the checklist that we can cost:"]
[null,null,null,"1. Both children were removed from child in need plans"]
[null,null,null,"2. Frequent police call outs would cease as parents' relationship has improved"]
[null,null,null,"3. Detox for Tracey and family therapy for the family"]
[]
[]
[null,null,"SOCIAL BENEFITS","Cost theme checklist","No. of children","No. of adults","Corresponding tab","Costs avoided in first year after intervention",null,null,null,null,null,null,null,"Notes"]
[null,null,null,null,null,null,null,"Direct costs",null,null,null,null,null,"Indirect","Intangible"]
[null,null,null,null,null,null,null,"LA",null,null,null,"NHS","CJS"]
[null,null,null,null,null,null,null,"Social care","Education","Housing","Treatment"]
[null,null,null,"Social care and early help support",null,null,"Social, YP & kinship care"]
[null,null,null,"Looked after - not in high cost placement",0,"n/a","Social, YP & kinship care",{"$f":"$E307*'Social, YP & kinship care'!$L$7","v":0}]
[null,null,null,"Child protection plan ",0,"n/a","Social, YP & kinship care",{"$f":"$E308*'Social, YP & kinship care'!$L$9","v":0},null,null,null,null,null,null,null,"This is a conservative estimate. Given the family circumstances, it is probable that the children would have been stepped up tp child looked after status."]
[null,null,null,"Child in need",2,"n/a","Social, YP & kinship care",{"$f":"$E309*'Social, YP & kinship care'!$L$10","v":18600}]
[null,null,null,"Early help",0,"n/a","Social, YP & kinship care",{"$f":"$E310*'Social, YP & kinship care'!$L$11","v":0}]
[null,null,null,"Troubled Families programme",0,"n/a","Social, YP & kinship care",{"$f":"$E311*'Social, YP & kinship care'!$L$12","v":0}]
[null,null,null,"Young person adopting carer role",0,"n/a","Social, YP & kinship care",null,null,null,null,null,null,{"$f":"E312*'Social, YP & kinship care'!$K$20","v":0}]
[null,null,null,"Kinship care","n/a",0,"Social, YP & kinship care",null,null,null,null,null,null,{"$f":"F313*'Social, YP & kinship care'!$K$21","v":0}]
[null,null,null,"Exclusion from school",0,"n/a","Education ",{"$f":"$E314*(Education!$L$10)","v":0},{"$f":"$E314*(Education!$L$7)","v":0},null,null,{"$f":"E314*Education!$L$11","v":0}]
[null,null,null,"Truancy",0,"n/a","Education ",{"$f":"E315*(Education!$L$16)","v":0},{"$f":"E315*(Education!$L$13)","v":0},null,null,{"$f":"E315*(Education!$L$17)","v":0}]
[null,null,null,"Perinatal depression",0,"n/a","Disorders",null,null,null,null,{"$f":"E316*(Disorders!$L$8+Disorders!$L$10+Disorders!$L$11)","v":0},null,null,{"$f":"E316*(Disorders!$N$8+Disorders!$N$9)","v":0}]
[null,null,null,"Perinatal anxiety",0,"n/a","Disorders",null,null,null,null,{"$f":"E317*(Disorders!$L$16+Disorders!$L$17+Disorders!$L$18+Disorders!$L$19)","v":0},null,{"$f":"E317*(Disorders!$M$19)","v":0},{"$f":"E317*Disorders!$N$16","v":0}]
[null,null,null,"Conduct disorder",0,"n/a","Disorders",{"$f":"$E318*(Disorders!$L$23)","v":0},{"$f":"$E318*(Disorders!$L$21)","v":0},null,null,{"$f":"$E318*Disorders!$L$22","v":0}]
[null,null,null,"Foetal alcohol spectrum disorder",0,"n/a","Disorders",{"$f":"$E319*Disorders!$L$26","v":0},{"$f":"$E319*Disorders!$L$28","v":0},null,null,{"$f":"$E319*Disorders!$L$25","v":0}]
[null,null,null,"Homelessness",0,0,"Homeslessness",null,null,{"$f":"IF(E320>0,1*Homelessness!$L$6,0)","v":0},null,{"$f":"E320*(Homelessness!$L$13+Homelessness!$L$14)+F320*Homelessness!$L$8","v":0},{"$f":"F320*Homelessness!#REF!","v":{"$error":"#REF!"}},null,{"$f":"E320*Homelessness!$N$15+F320*Homelessness!$N$10","v":0}]
[null,null,null,"NHS treatment",null,null,"NHS and LA Treatment"]
[null,null,null,"Cognitive behavioural therapy (CBT) for adolescents",0,"n/a","NHS and LA Treatment",null,null,null,null,{"$f":"E322*'NHS & LA treatment'!$L$18","v":0}]
[null,null,null,"Counselling for children with mental or emotional difficulties",0,"n/a","NHS and LA Treatment",null,null,null,null,{"$f":"E323*'NHS & LA treatment'!$L$19","v":0}]
[null,null,null,"Domestic abuse","n/a",0,"DA & crime",null,null,null,null,{"$f":"F324*'DA & crime'!$L$7","v":0},{"$f":"F324*'DA & crime'!$L$10","v":0},{"$f":"F324*('DA & crime'!$M$11+'DA & crime'!$M$8)","v":0},{"$f":"F324*'DA & crime'!$N$9","v":0}]
[null,null,null,"Crime","","","DA & crime"]
[null,null,null,"Violence","n/a",0,null,null,null,null,null,{"$f":"F326*AVERAGE('DA & crime'!$L$13,'DA & crime'!$L$19)*6","v":0},{"$f":"F326*AVERAGE('DA & crime'!$L$16,'DA & crime'!$L$22)*6","v":0},{"$f":"F326*AVERAGE('DA & crime'!$M$14,'DA & crime'!$M$17,'DA & crime'!$M$20,'DA & crime'!$M$23)*6","v":0},{"$f":"F326*AVERAGE('DA & crime'!$N$15,'DA & crime'!$N$21)*6","v":0}]
[null,null,null,"Shoplifting","n/a",0,"DA & crime",null,null,null,null,null,{"$f":"$F327*'DA & crime'!$L$24*100","v":0}]
[null,null,null,"Robbery","n/a",0,"DA & crime",null,null,null,null,{"$f":"F328*'DA & crime'!$L$26*15","v":0},{"$f":"F328*'DA & crime'!$L$29*15","v":0},{"$f":"F328*('DA & crime'!$M$27+'DA & crime'!$M$30)*15","v":0},{"$f":"F328*'DA & crime'!$N$28*15","v":0}]
[null,null,null,"House burglary","n/a",0,"DA & crime",null,null,null,null,{"$f":"F329*'DA & crime'!$L$32*25","v":0},{"$f":"F329*'DA & crime'!$L$35*25","v":0},{"$f":"F329*('DA & crime'!$M$33+'DA & crime'!$M$36)*25","v":0},{"$f":"F329*'DA & crime'!$N$34*25","v":0}]
[null,null,null,"Police call out","n/a",1,null,null,null,null,null,null,{"$f":"$F330*'DA & crime'!$L$44*6","v":3000}]
[null,null,null,"Are costs mutually exclusive?",null,null,null,"Yes","[Select]","[Select]",null,"[Select]","Yes","[Select]","[Select]"]
[null,null,null,"Total benefits (where costs are not mutually exclusive, a range is presented)",null,null,null,{"$f":"IF(H331=\"No\",\"(£\"&(ROUND(SMALL(H307:H330,COUNTIF(H307:H330,0)+1),0))&\" - £\"&(ROUND(MAX(H307:H330),0))&\")\",SUM(H307:H330))","v":18600},{"$f":"IF(I331=\"No\",\"(£\"&(ROUND(SMALL(I307:I330,COUNTIF(I307:I330,0)+1),0))&\" - £\"&(ROUND(MAX(I307:I330),0))&\")\",SUM(I307:I330))","v":0},0,null,0,3000,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(H331=\"No\",SMALL((H307:H330),COUNTIF(H307:H330,0)+1),SUM(H307:H330))","v":18600},{"$f":"IF(I331=\"No\",SMALL((I307:I330),COUNTIF(I307:I330,0)+1),SUM(I307:I330))","v":0},0,null,0,3000,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(H331=\"No\",MAX(H307:H330),SUM(H307:H330))","v":18600},{"$f":"IF(I331=\"No\",MAX(I307:I330),SUM(I307:I330))","v":0},0,null,0,3000,0,0]
[null,null,"COSTS","Alcohol and/or drug treatment",0,0,"NHS and LA Treatment"]
[null,null,null,"Treatment for opioid use","n/a",0,"NHS and LA Treatment",null,null,{"$f":"F336*'NHS & LA treatment'!$L$20","v":0}]
[null,null,null,"Treatment for non-opioid drug use","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F337*'NHS & LA treatment'!$L$21","v":0}]
[null,null,null,"Treatment for alcohol use","n/a",{"$f":"1+(1*0.5)","v":1.5},"NHS and LA Treatment",null,null,null,{"$f":"F338*'NHS & LA treatment'!$L$22","v":1950},null,null,null,null,"We have assumed the cost of treating the children and Darryl are half that of treating mother for alcohol dependency and the children/Dave can be considered as one 'unit' for costs purposes."]
[null,null,null,"Treatment for young people (alcohol and drugs)",0,"n/a","NHS and LA Treatment",null,null,null,{"$f":"E339*'NHS & LA treatment'!$L$23","v":0}]
[null,null,null,"Inpatient detoxfication","n/a",1,"NHS and LA Treatment",null,null,null,{"$f":"F340*'NHS & LA treatment'!$L$24","v":2400}]
[null,null,null,"Residential rehabilitation","n/a",0,"NHS and LA Treatment",null,null,null,{"$f":"F341*'NHS & LA treatment'!$L$25","v":0}]
[null,null,null,"Other treatment cost should be added here",null,null,null,null,null,null,{"$f":"0","v":0}]
[null,null,null,"Any ongoing treatment or social support cost (for example, early help)",null,null,null,0,null,null,{"$f":"0","v":0}]
[null,null,null,"Total costs",null,null,null,{"$f":"SUM(H336:H343)","v":0},null,null,{"$f":"SUM(K336:K343)","v":4350}]
[]
[null,null,null,null,"£"]
[null,null,null,"Total costs",{"$f":"SUM(H344:O344)","v":4350}]
[null,null,null,"Gross social benefit (LA)",{"$f":"IF(SUM(H333:K333)=SUM(H334:K334),TEXT(ROUND(SUM(H333:K333),-1),\"#,#\"),TEXT(ROUND(SUM(H333:K333),-1),\" #,# - \")&TEXT(ROUND(SUM(H334:K334),-1),\"#,#\"))","v":"18,600"}]
[null,null,null,"Net social benefit (LA)",{"$f":"IF(SUM(H333:K333)=SUM(H334:K334),TEXT(ROUND(SUM(H333:K333)-E347,-1),\"#,#\"),TEXT(ROUND(SUM(H333:K333)-E347,-1),\"#,# - \")&TEXT(ROUND(SUM(H334:K334)-E347,-1),\"#,#\"))","v":"14,250"}]
[null,null,null,"Social benefit-cost ratio (LA costs)",{"$f":"IFERROR(IF(SUM(H333:K333)=SUM(H334:K334),TEXT(ROUND(SUM(H333:K333)/E347,2),\"#.#0\"),TEXT(ROUND(SUM(H333:K333)/E347,2),\"#.#0 - \")&TEXT(ROUND(SUM(H334:K334)/E347,2),\"#.#0\")),0)","v":"4.28"}]
[null,null,null,"Wider net social benefits (gross)",{"$f":"IF(SUM(H333:O333)=SUM(H334:O334),TEXT(ROUND(SUM(H333:O333),-1),\"#,#\"),TEXT(ROUND(SUM(H333:O333),-1),\" #,# - \")&TEXT(ROUND(SUM(H334:O334),-1),\"#,#\"))","v":"21,600"}]
[null,null,null,"Wider net social benefits (net)",{"$f":"IF(SUM(H333:O333)=SUM(H334:O334),TEXT(ROUND(SUM(H333:O333)-E347,-1),\" #,#\"),TEXT(ROUND(SUM(H333:O333)-E347,-1),\"#,# - \")&TEXT(ROUND(SUM(H334:O334)-E347,-1),\"#,#\"))","v":" 17,250"}]
[null,null,null,"Wider social benefit-cost ratio",{"$f":"IFERROR(IF(SUM(H333:O333)=SUM(H334:O334),TEXT(ROUND(SUM(H333:O333)/E347,2),\"#.#0\"),TEXT(ROUND(SUM(H333:O333)/E347,2),\"#.#0 - \")&TEXT(ROUND(SUM(H334:O334)/E347,2),\"#.#0\")),0)","v":"4.97"}]

{"sheet":"Sheet4","index":5,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"[Select]"]
[null,null,null,"Yes"]
[null,null,null,"No"]

{"sheet":"Part 2 - UC database","index":6,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,3,4,9],[3,3,3,9],[24,3,24,9]]}
[]
[null,null,null,"Part 2: Unit cost database"]
[]
[null,null,null,"Costs themes are presented below, and can be selected by clicking on the appropriate corresponding tab.\n"]
[null,null,null,"Costs are broken down into 3 types: direct, indirect and intangible. Direct costs are estimated costs that directly relate to providing treatment and support. For example, costs to the local authority (LA), NHS or criminal justice system. \n\nEconomic evaluations typically include wider indirect and intangible costs. Where available, we have also presented these so you can use them to estimate wider social and economic costs. Indirect costs generally relate to productivity losses from people being ill or dying prematurely. Intangible costs represent disease burden and are quantified as quality-adjusted life years (QALYs) and valued at £60,000 per QALY.  \n\nAll costs are in 2020 to 2021 prices (see Annexes for reference) and rounded to emphasise that costs are estimates. The database presents most costs as annual costs. It also presents lifetime costs where these exist, along with methodological explanations such as how many years make up the ‘lifetime’. We have included references for the sources of all costs with links to the publication and an explanation of calculations and limitations."]
[]
[null,null,null,"Contents"]
[]
[null,null,null,"Cost theme","Corresponding tab"]
[null,null,null,"Social care","Social, YP & kinship care"]
[null,null,null,"Young carers","Social, YP & kinship care"]
[null,null,null,"Kinship carers","Social, YP & kinship care"]
[null,null,null,"Education ",{"$f":"D13","v":"Education "}]
[null,null,null,"Perinatal depression","Disorders"]
[null,null,null,"Perinatal anxiety","Disorders"]
[null,null,null,"Conduct disorder","Disorders"]
[null,null,null,"Foetal alcohol spectrum disorder","Disorders"]
[null,null,null,"Homelessness",{"$f":"D18","v":"Homelessness"}]
[null,null,null,"NHS treatment","NHS and LA Treatment"]
[null,null,null,"Alcohol and drug treatment","NHS and LA Treatment"]
[null,null,null,"Domestic abuse","DA & crime"]
[null,null,null,"Crime (by Home Office crime types)","DA & crime"]
[]
[]
[null,null,null,"If you are aware of a unit cost that you think should be included in the database, please contact: Virginia.Wright@phe.gov.uk, Parents, Carers and Families (alcohol and drugs) Programme Manager"]

{"sheet":"Social, YP & kinship care","index":7,"n_rows":21,"n_cols":26,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,2,2,13],[3,14,3,17],[3,18,4,18],[3,25,4,25],[3,20,4,20],[3,21,4,21],[3,22,3,24],[3,10,3,13],[3,2,4,2],[3,5,3,8],[3,9,4,9],[3,3,4,3],[3,4,4,4]]}
[]
[null,null,"Social, YP and kinship care unit costs"]
[null,null,"Note: you can access the rows containing breakdowns of annual and lifetime costs (if available or applicable), including reference year, by clicking on [+] above rows K and S. Hovering over a cell with a red triangle on the upper right hand corner provides more information."]
[null,null,"Cost grouping","Cost name","Average","Annual cost as reported",null,null,null,"Publication year costs and currency","Annual costs (2020 to 2021 prices, rounded)",null,null,null,"Lifetime costs",null,null,null,"Who pays?",null,"Timeframe\n(for lifetime costs)","Geography","References",null,null,"Methodological limitations/ bias/ notes"]
[null,null,null,null,null,"Total ","Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,{"$f":"F5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",{"$f":"K5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,null,null,null,"Title and author","Year","Link to source"]
[null,null,"Social care","Looked after child in high cost placement (4k+ a week)","Per child",260000,{"$f":"F6","v":260000},null,null,"£s, 2017/18",{"$f":"ROUND((F6*(_202021/_201718)),-4)","v":290000},290000,null,null,null,null,null,null,"LA",null,"n/a","England","Children's commissioner 'Estimating Children’s Services spending on vulnerable children: Vulnerability technical spend report'",2019,"https://www.childrenscommissioner.gov.uk/wp-content/uploads/2019/07/cco-vulnerability-2019-spend-report.pdf","Data from 9 councils only, but with a reasonable geographic distribution. Not possible to know how market forces would vary costs nationally. LAs from North East and West Midlands not included in the study. Possible bias owing to small sample size."]
[null,null,"Social care","Looked after child in not high cost placement (<4k a week)","Per child",53000,{"$f":"F7","v":53000},null,null,"£s, 2017/18",{"$f":"ROUND((F7*(_202021/_201718)),-4)","v":60000},{"$f":"ROUND((G7*(_202021/_201718)),-4)","v":60000},null,null,null,null,null,null,"LA",null,"n/a","England","Children's commissioner 'Estimating Children’s Services spending on vulnerable children: Vulnerability technical spend report'",2019,"https://www.childrenscommissioner.gov.uk/wp-content/uploads/2019/07/cco-vulnerability-2019-spend-report.pdf","Data from 9 councils only, but with a reasonable geographic distribution. Not possible to know how market forces would vary costs nationally. LAs from North East and West Midlands not included in the study. Possible bias owing to small sample size."]
[null,null,"Social care","Permanency","Per child",7000,7000,null,null,"£s, 2017/18",{"$f":"ROUND((F8*(_202021/_201718)),-2)","v":7800},{"$f":"K8","v":7800},null,null,null,null,null,null,"LA",null,"n/a","England","Children's commissioner 'Estimating Children’s Services spending on vulnerable children: Vulnerability technical spend report'",2019,"https://www.childrenscommissioner.gov.uk/wp-content/uploads/2019/07/cco-vulnerability-2019-spend-report.pdf","Data from 9 councils only, but with a reasonable geographic distribution. Not possible to know how market forces would vary costs nationally. LAs from North East and West Midlands not included in the study. Possible bias owing to small sample size."]
[null,null,"Social care","Child protection plan ","Per child",9300,9300,null,null,"£s, 2017/18",10400,{"$f":"K9","v":10400},null,null,null,null,null,null,"LA",null,"n/a","England","Children's commissioner 'Estimating Children’s Services spending on vulnerable children: Vulnerability technical spend report'",2019,"https://www.childrenscommissioner.gov.uk/wp-content/uploads/2019/07/cco-vulnerability-2019-spend-report.pdf","Data from 9 councils only, but with a reasonable geographic distribution. Not possible to know how market forces would vary costs nationally. LAs from North East and West Midlands not included in the study. Possible bias owing to small sample size."]
[null,null,"Social care","Child in need","Per child",8300,8300,null,null,"£s, 2017/18",9300,9300,null,null,null,null,null,null,"LA",null,"n/a","England","Children's commissioner 'Estimating Children’s Services spending on vulnerable children: Vulnerability technical spend report'",2019,"https://www.childrenscommissioner.gov.uk/wp-content/uploads/2019/07/cco-vulnerability-2019-spend-report.pdf","Data from 9 councils only, but with a reasonable geographic distribution. Not possible to know how market forces would vary costs nationally. LAs from North East and West Midlands not included in the study. Possible bias owing to small sample size."]
[null,null,"Social care","Early help","Per child",3500,3500,null,null,"£s, 2017/18",3900,3900,null,null,null,null,null,null,"LA",null,"n/a","England","Children's commissioner 'Estimating Children’s Services spending on vulnerable children: Vulnerability technical spend report'",2019,"https://www.childrenscommissioner.gov.uk/wp-content/uploads/2019/07/cco-vulnerability-2019-spend-report.pdf","Data from 9 councils only, but with a reasonable geographic distribution. Not possible to know how market forces would vary costs nationally. LAs from North East and West Midlands not included in the study. Possible bias owing to small sample size."]
[null,null,"Social care","Troubled Families programme","Per child",1600,1600,null,null,"£s, 2017/18",1800,1800,null,null,null,null,null,null,"LA",null,"n/a","England","Children's commissioner 'Estimating Children’s Services spending on vulnerable children: Vulnerability technical spend report'",2019,"https://www.childrenscommissioner.gov.uk/wp-content/uploads/2019/07/cco-vulnerability-2019-spend-report.pdf","Data from 9 councils only, but with a reasonable geographic distribution. Not possible to know how market forces would vary costs nationally. LAs from North East and West Midlands not included in the study. Possible bias owing to small sample size."]
[null,null,"Social care","Young offender (convicted)","Per child",10000,10000,null,null,"£s, 2017/18",11200,11200,null,null,null,null,null,null,"LA",null,"n/a","England","Children's commissioner 'Estimating Children’s Services spending on vulnerable children: Vulnerability technical spend report'",2019,"https://www.childrenscommissioner.gov.uk/wp-content/uploads/2019/07/cco-vulnerability-2019-spend-report.pdf","Data from 9 councils only, but with a reasonable geographic distribution. Not possible to know how market forces would vary costs nationally. LAs from North East and West Midlands not included in the study. Possible bias owing to small sample size."]
[null,null,"Social care","NEET youth support","Per child",4900,4900,null,null,"£s, 2017/18",5500,5500,null,null,null,null,null,null,"LA",null,"n/a","England","Children's commissioner 'Estimating Children’s Services spending on vulnerable children: Vulnerability technical spend report'",2019,"https://www.childrenscommissioner.gov.uk/wp-content/uploads/2019/07/cco-vulnerability-2019-spend-report.pdf","Data from 9 councils only, but with a reasonable geographic distribution. Not possible to know how market forces would vary costs nationally. LAs from North East and West Midlands not included in the study. Possible bias owing to small sample size."]
[null,null,"Social care","Section 31 care order: overall cost","Per child",25000,25000,null,null,"£s, 2005/06",28000,28000,null,null,null,null,null,null,"Multiple",null,"n/a","England and Wales","Taken from the New Economy Manchester Unit cost database. Original report was DCA and DfES 'Review of the Child Care Proceedings System in England and Wales'",2006,"http://www.familieslink.co.uk/download/june07/Review%20of%20child%20care.pdf","Note age of data - process, and related costings, may have changed over this period. Note that a year for the cost data is not specified in the source, but it has been assumed to be 2005 to 2006, as other relevant data are from this year."]
[null,null,"Social care","Section 31 care order: Legal aid costs","Per child",15000,15000,null,null,"£s, 2005/06",{"$f":"ROUND((F16*(_202021/_200506)),-2)","v":21200},{"$f":"K16","v":21200},null,null,null,null,null,null,"Criminal Justice System",null,"n/a","England and Wales","Ditto",2006,"http://www.familieslink.co.uk/download/june07/Review%20of%20child%20care.pdf","Ditto"]
[null,null,"Social care","Section 31 care order: local authority costs","Per child",6250,6250,null,null,"£s, 2005/06",{"$f":"ROUND((F17*(_202021/_200506)),-2)","v":8800},8800,null,null,null,null,null,null,"Local Authority",null,"n/a","England and Wales","Ditto",2006,"http://www.familieslink.co.uk/download/june07/Review%20of%20child%20care.pdf","Ditto"]
[null,null,"Social care","Section 31 care order: court costs","Per child",1250,1250,null,null,"£s, 2005/06",{"$f":"ROUND((F18*(_202021/_200506)),-2)","v":1800},1800,null,null,null,null,null,null,"Criminal Justice System",null,"n/a","England and Wales","Ditto",2006,"http://www.familieslink.co.uk/download/june07/Review%20of%20child%20care.pdf","Ditto"]
[null,null,"Social care","Section 31 care order: Children and Family Court Advisory and Support Service (CAFCASS) costs","Per child",2500,2500,null,null,"£s, 2005/06",{"$f":"ROUND((F19*(_202021/_200506)),-2)","v":3500},3500,null,null,null,null,null,null,"Department for Education",null,"n/a","England and Wales","Ditto",2006,"http://www.familieslink.co.uk/download/june07/Review%20of%20child%20care.pdf","Ditto"]
[null,null,"Young carer","Unpaid work equivalent","Per carer",{"$f":"4.55*52*25","v":5915},null,{"$f":"F20","v":5915},null,"£s, 2020/21",{"$f":"ROUND(F20,-2)","v":5900},null,{"$f":"K20","v":5900},null,{"$f":"ROUND(M20*SUM('Perinatal MH QALY calcs'!C6:C17),-2)","v":59000},null,{"$f":"O20","v":59000},null,"n/a",null,"11 years (from 7 years old)","England","Action for Children",2020,"https://www.actionforchildren.org.uk/news-and-blogs/press-releases/2020/february/uks-hidden-child-workforce/","Lifetime costs calculated for average 7 year old, lasting until they reach 18 years old. Adapted Action for Children method - using minimum wage instead of hourly rate of £9.78 per part-time carer.  Fifty-two weeks of the year inluded as survey found that during holidays, young carers worked more, not less."]
[null,null,"Kinship care","Foregone employment","Per carer",682.47660799999994,null,{"$f":"F21","v":682.47660799999994},null,"£s, 2018/19",{"$f":"ROUND((F21*(_202021/_201819)),-2)","v":700},null,{"$f":"K21","v":700},null,null,null,null,null,"n/a",null,"n/a","England ","Dame Carol Black Review of Drugs - evidence relating to drug use, supply and effects, including current trends and future risks",2019,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/882953/Review_of_Drugs_Evidence_Pack.pdf","\nForty-four percent of kinship carers give up work to look after children. An estimated 226 hours estimated to be spent looking after children, which has been mulipltied by the minimum wage."]

{"sheet":"Education","index":8,"n_rows":17,"n_cols":26,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,2,2,13],[3,10,3,13],[3,14,3,17],[3,18,4,18],[3,25,4,25],[3,20,4,20],[3,21,4,21],[3,22,3,24],[3,2,4,2],[3,3,4,3],[3,5,3,8],[3,9,4,9],[3,4,4,4]]}
[]
[null,null,"Education unit costs"]
[null,null,"Note: you can access the rows containing breakdowns of annual and lifetime costs (if available or applicable), including reference year, by clicking on [+] above rows K and S. Hovering over a cell with a red triangle on the upper right hand corner provides more information."]
[null,null,"Cost grouping","Cost name","Average","Annual cost as reported",null,null,null,"Publication year costs and currency","Annual costs (2020 to 2021 prices, rounded)",null,null,null,"Lifetime costs",null,null,null,"Who pays?",null,"Timeframe\n(for lifetime costs)","Geography","References",null,null,"Methodological limitations/ bias/ notes"]
[null,null,null,null,null,"Total ","Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,{"$f":"F5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",{"$f":"K5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,null,null,null,"Title and author","Year","Link to source"]
[null,null,"School exclusion","Overall cost","Per child",{"$f":"F7+F10+F11+F8+F9","v":8907.6111111111113},{"$f":"G7+G10+G11+G8+G9","v":8907.6111111111113},null,null,"£s, 2005",{"$f":"ROUND(K7+K10+K11+K8+K9,-2)","v":12700},{"$f":"ROUND(L7+L10+L11+L8+L9,-2)","v":12700},null,null,{"$f":"O7+O10+O11+O8+O9","v":84600},{"$f":"P7+P10+P11+P8+P9","v":47000},{"$f":"Q7+Q10+Q11+Q8+Q9","v":37600},null,"Multiple",null,"Multiple","England","Brooks et al. Misspent Youth: The costs of truancy and exclusion.",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","2005 costs mostly uplifted paper old papers. Net cost calculated however, estimates are based on old data so not possible to estimate the accuracy of the estimate."]
[null,null,"School exclusion","Alternative educational provision","Per child",7181,{"$f":"F7","v":7181},null,null,"£s, 2005",{"$f":"ROUND(F7*_202021/_200506,-2)","v":10200},{"$f":"K7","v":10200},null,null,{"$f":"ROUND(F7*('A2 Discount'!$E$10*0.5+SUM('A2 Discount'!$E$11:$E$13)),-2)","v":23700},{"$f":"O7","v":23700},null,null,"LA",null,"3.5 years","England","Ditto",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","2005 costs mostly uplifted paper old papers. Net cost calculated however, estimates are based on old data so not possible to estimate the accuracy of the estimate."]
[null,null,"School exclusion","Loss of future earnings (lifetime costs only)","Per child",null,null,null,null,"£s, 2005",null,null,null,null,{"$f":"ROUND(21175*_202021/_200506,-2)","v":29900},null,{"$f":"O8","v":29900},null,"n/a",null,"Working age","England","Ditto",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","2005 costs uplifted from paper published in 1999. The Youth Cohort Survey reported that half of excluded children fail to get any A-C grade GCSEs, compared with 22% for the overall population. 23% of all children go on to higher education, compared with 13% of excluded children. To translate levels of qualifications into levels of earnings, the Labour Force Survey (LFS) figures for full-time wages at different ages according to levels of qualifications were used. Both of these were very out of date. The LFS figures for unemployment are for age 21 only. In the absence of other data, the gap in unemployment rates remains throughout the adult working life of the excluded child."]
[null,null,"School exclusion","Crime (lifetime cost only)","Per child",null,null,null,null,"£s, 2005",null,null,null,null,{"$f":"ROUND(15527*_202021/_200506,-2)","v":22000},{"$f":"O9","v":22000},null,null,"CJS",null,"Lifetime","England","Ditto",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","Assumes excluded children who commit crime do so at the same rate up to age 39, after which they are convicted less frequently and their rate decrease at the same rate as the prison population."]
[null,null,"School exclusion","Social care (residential and foster)","Per child",{"$f":"1169+501","v":1670},{"$f":"F10","v":1670},null,null,"£s, 2005",{"$f":"ROUND(F10*_202021/_200506,-2)","v":2400},{"$f":"K10","v":2400},null,null,{"$f":"ROUND((1169*('A2 Discount'!$E$10*0.5)+SUM('A2 Discount'!$E$11:$E$13))+(501*SUM('A2 Discount'!E10:E21))*_202021/_200506,-2)","v":7700},null,{"$f":"O10","v":7700},null,"LA",null,"3.5 years","England","Ditto",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","Assumes most social care costs are incurred from the age of 12½, the average age at which exclusion takes place. Assumes cost of residential and foster care for children occurs between 10-16."]
[null,null,"School exclusion","NHS costs","Per child",{"$f":"1019/18","v":56.611111111111114},{"$f":"F11","v":56.611111111111114},null,null,"£s, 2005",{"$f":"ROUND((F11*(_202021/_200506)),-2)","v":100},{"$f":"ROUND((G11*(_202021/_200506)),-2)","v":100},null,null,{"$f":"ROUND(K11*SUM('A2 Discount'!E10:E25),-2)","v":1300},{"$f":"O11","v":1300},null,null,"NHS",null,"16 years","England","Ditto",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","The most common cause of school exclusion is persistent disruptive behaviour.The method is based on Scott et al (2001) so is out of date. Though this paper is a seminal piece oft cited on costs associated with conduct disorders despite it being set in an inner London with a small sample size."]
[null,null,"School truancy","Overall cost","Per child",{"$f":"SUM(F13:F17)","v":2719.2222222222222},{"$f":"SUM(G13:G17)","v":2719.2222222222222},null,null,"£s, 2005",{"$f":"SUM(K13:K17)","v":3900},{"$f":"SUM(L13:L17)","v":3900},null,null,{"$f":"ROUND(SUM(O13:O17),-3)","v":69000},{"$f":"ROUND(SUM(P13:P17),-2)","v":21000},{"$f":"ROUND(SUM(Q13:Q17),-2)","v":47600},null,"Multiple",null,"Multiple","England","Brooks et al. Misspent Youth: The costs of truancy and exclusion.",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","2005 costs mostly uplifted paper old papers. Net cost calculated however, estimates are based on old data so not possible to estimate the accuracy of the estimate."]
[null,null,"School truancy","Cost to educational system","Per child",706,{"$f":"F13","v":706},null,null,"£s, 2005",{"$f":"ROUND((F13*(_202021/_200506)),-2)","v":1000},{"$f":"ROUND((G13*(_202021/_200506)),-2)","v":1000},null,null,{"$f":"ROUND(K13*SUM('A2 Discount'!E10:E11),-2)","v":2000},{"$f":"O13","v":2000},null,null,"LA",null,"2 years","England","Ditto",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","Assumes that the cost to the education welfare system is only felt over two years when the child is 11 and 12. It is not possible to isolate further costs to the education system, eg, the cost of truancy initiatives. "]
[null,null,"School truancy","Loss of future earnings","Per child",null,null,null,null,"£s, 2005",null,null,null,null,{"$f":"ROUND(33694*_202021/_200506,-2)","v":47600},null,{"$f":"O14","v":47600},null,"n/a",null,{"$f":"U8","v":"Working age"},"England","Ditto",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","Method used to estimate costs is the same as those for excluded children. Almost 60% of children who persistently truant fail to get any A-C grade GCSEs. One child in four who truants gets no qualifications at all. Earnings are on average 13% lower for truants."]
[null,null,"School truancy","Crime (lifetime cost only)","Per child",null,null,null,null,"£s, 2005",null,null,null,null,{"$f":"ROUND(6776*_202021/_200506,-2)","v":9600},{"$f":"O15","v":9600},null,null,"CJS",null,"Lifetime","England","Ditto",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","Same as those for excluded children, taking those with conduct problems committing crimes as a proxy for truants committing crimes."]
[null,null,"School truancy","Social care (residential and foster)","Per child",{"$f":"1967","v":1967},{"$f":"F16","v":1967},null,null,"£s, 2005",{"$f":"ROUND((F16*(_202021/_200506)),-2)","v":2800},{"$f":"ROUND((G16*(_202021/_200506)),-2)","v":2800},null,null,{"$f":"ROUND(K16*SUM('A2 Discount'!E10:E12),-2)","v":8100},{"$f":"O16","v":8100},null,null,"LA",null,"3 years","England","Ditto",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","Same as those for excluded children, taking those with conduct problems receiving social support as a proxy for truants receiving social support."]
[null,null,"School truancy","NHS costs","Per child",{"$f":"832/18","v":46.222222222222221},{"$f":"F17","v":46.222222222222221},null,null,"£s, 2005",{"$f":"ROUND((F17*(_202021/_200506)),-2)","v":100},{"$f":"ROUND((G17*(_202021/_200506)),-2)","v":100},null,null,{"$f":"ROUND(K17*SUM('A2 Discount'!E10:E25),-2)","v":1300},{"$f":"O17","v":1300},null,null,"NHS",null,"16 years","England","Ditto",2007,"https://www.thinknpc.org/resource-hub/misspent-youth/","Method used to estimate costs is the same as those for excluded children."]

{"sheet":"Disorders","index":9,"n_rows":28,"n_cols":26,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,2,2,13],[3,14,3,17],[3,18,4,18],[3,25,4,25],[3,20,4,20],[3,21,4,21],[3,22,3,24],[3,10,3,13],[3,2,4,2],[3,3,4,3],[3,5,3,8],[3,9,4,9],[3,4,4,4]]}
[]
[null,null,"Disorder-related unit costs"]
[null,null,"Note: you can access the rows containing breakdowns of annual and lifetime costs (if available or applicable), including reference year, by clicking on [+] above rows K and S. Hovering over a cell with a red triangle on the upper right hand corner provides more information."]
[null,null,"Cost grouping","Cost name","Average","Annual cost as reported",null,null,null,"Publication year costs and currency","Annual costs (2020 to 2021 prices, rounded)",null,null,null,"Lifetime costs",null,null,null,"Who pays?",null,"Timeframe\n(for lifetime costs)","Geography","References",null,null,"Methodological limitations/ bias/ notes"]
[null,null,null,null,null,"Total ","Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,{"$f":"F5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",{"$f":"K5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,null,null,null,"Title and author","Year","Link to source"]
[null,null,"Perinatal depression","Maternal annual and lifetime cost","Per mother",null,null,null,null,"£s, 2012/13",{"$f":"SUM(L6:N6)","v":5780},{"$f":"P6/10","v":190},290,5300,{"$f":"P6+Q6+R6","v":57800},1900,2900,53000,"Multiple",null,"10 years post birth","UK","Annette Bauer et al. The costs of perinatal mental health problems. ",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Lifetime costs presented in paper for average 32 year old women, 10 years following birth. Annual discount of 3.5% removed from annual costs, but included in lifetime costs. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal depression","Child annual and lifetime: overall cost","Per child",null,null,null,null,"£s, 2012/13",{"$f":"SUM(L7:N7)","v":5200},{"$f":"ROUND(SUM(L8:L13),-2)","v":100},{"$f":"ROUND(SUM(M8:M13),-2)","v":0},{"$f":"ROUND(SUM(N8:N13),-2)","v":5100},{"$f":"ROUND(P7+Q7+R7,-3)","v":287000},{"$f":"SUM(P8:P13)","v":9000},{"$f":"SUM(Q8:Q13)","v":7000},{"$f":"ROUND(SUM(R8:R13),-2)","v":271000},"Multiple",null,"Multiple","UK","Annette Bauer et al. The costs of perinatal mental health problems. ",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% removed from annual costs, but included in lifetime costs. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal depression","Pre-term birth","Per child",null,null,null,null,"£s, 2012/13",{"$f":"L8+M8+N8","v":160},{"$f":"ROUND(P8/18,-1)","v":60},null,{"$f":"ROUND(R8/18,-2)","v":100},2000,{"$f":"ROUND((974*_202021/_201213),-3)","v":1000},null,1000,"Multiple",null,"Childhood","UK","Annette Bauer et al. The costs of perinatal mental health problems. ",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Assumes 'other' as reported in source is an indirect rather than direct cost. Annual discount of 3.5% removed from annual costs, but included in lifetime costs. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal depression","Infant death","Per child",null,null,null,null,"£s, 2012/13",{"$f":"L9+M9+N9","v":5000},null,null,{"$f":"ROUND(R9/18,-3)","v":5000},{"$f":"P9+Q9+R9","v":90000},null,null,90000,"Individual",null,"Childhood","UK","Annette Bauer et al. The costs of perinatal mental health problems. ",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% used in lifetime costs not removed from annual costs, for simplicity. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal depression","Emotional problems","Per child",null,null,null,null,"£s, 2012/13",null,null,null,null,{"$f":"ROUND(P10+Q10+R10,4)","v":104000},{"$f":"ROUND(1020*_202021/_201213,-3)","v":1000},{"$f":"ROUND(2169*_202021/_201213,-3)","v":3000},100000,"Multiple",null,"Lifetime","UK","Annette Bauer et al. The costs of perinatal mental health problems. ",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% used in lifetime costs not removed from annual costs, for simplicity. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal depression","Conduct disorder","Per child",null,null,null,null,"£s, 2012/13",null,null,null,null,{"$f":"P11+Q11+R11","v":85000},{"$f":"ROUND(837+1974*_202021/_201213,-3)","v":3000},{"$f":"ROUND(1797*_202021/_201213,-3)","v":2000},80000,"Multiple",null,"Lifetime","UK","Annette Bauer et al. The costs of perinatal mental health problems. ",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% used in lifetime costs not removed from annual costs, for simplicity. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal depression","Special educational needs","Per child",null,null,null,null,"£s, 2012/13",null,null,null,null,{"$f":"P12+Q12+R12","v":4000},{"$f":"ROUND(3166*_202021/_201213,-3)","v":4000},null,null,"LA",null,"Childhood","UK","Annette Bauer et al. The costs of perinatal mental health problems. ",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% used in lifetime costs not removed from annual costs, for simplicity. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal depression","Leaving school without qualifications","Per child",null,null,null,null,"£s, 2012/13",null,null,null,null,2000,null,{"$f":"ROUND(1463*_202021/_201213,-3)","v":2000},null,"Multiple",null,"Lifetime","UK","Annette Bauer et al. The costs of perinatal mental health problems. ",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% used in lifetime costs not removed from annual costs, for simplicity. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal anxiety ","Maternal annual and lifetime cost","Per mother",null,null,null,null,"£s, 2012/13",{"$f":"O14/10","v":4390},{"$f":"P14/10","v":520},{"$f":"Q14/10","v":670},{"$f":"R14/10","v":3200},43900,{"$f":"ROUND(4320*_202021/_201213,-2)","v":5200},{"$f":"ROUND(5499*_202021/_201213,-2)","v":6700},32000,"Multiple",null,"10 years post birth","UK","Annette Bauer et al. The costs of perinatal mental health problems. ",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Lifetime costs presented in paper for average 32 year old women, 10 years following birth. Annual discount of 3.5% removed from annual costs, but included in lifetime costs. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal anxiety ","Child annual and lifetime: overall cost","Per child",null,null,null,null,{"$f":"J14","v":"£s, 2012/13"},{"$f":"SUM(L15:N15)","v":600},{"$f":"ROUND(SUM(L16:L19),-2)","v":300},{"$f":"ROUND(SUM(M16:M19),-2)","v":100},{"$f":"ROUND(SUM(N16:N19),-2)","v":200},{"$f":"SUM(P15:R15)","v":64600},{"$f":"ROUND(SUM(P16:P19),-2)","v":6500},{"$f":"ROUND(SUM(Q16:Q19),-2)","v":2100},{"$f":"ROUND(SUM(R16:R19),-2)","v":56000},"Multiple",null,"Multiple","UK","Annette Bauer et al. The costs of perinatal mental health problems. ",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% used in lifetime costs not removed from annual costs, for simplicity. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal anxiety ","Pre-term birth","Per child",null,null,null,null,{"$f":"J15","v":"£s, 2012/13"},{"$f":"L16+M16+N16","v":400},{"$f":"ROUND(P16/18,-2)","v":200},{"$f":"ROUND(Q16/18,-1)","v":0},{"$f":"ROUND(R16/18,-2)","v":200},{"$f":"P16+Q16+R16","v":6070},{"$f":"ROUND((2435+13)*_202021/_201213,-3)","v":3000},{"$f":"ROUND(54*_202021/_201213,-1)","v":70},3000,"Multiple",null,"Childhood","UK","Ditto",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% used in lifetime costs not removed from annual costs, for simplicity. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal anxiety ","Emotional problems","Per child",null,null,null,null,{"$f":"J16","v":"£s, 2012/13"},null,null,null,null,{"$f":"P17+Q17+R17","v":12000},{"$f":"ROUND((273+176)*_202021/_201213,-2)","v":500},{"$f":"ROUND(440*_202021/_201213,-2)","v":500},11000,"Multiple",null,"Childhood","UK","Ditto",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% used in lifetime costs not removed from annual costs, for simplicity. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal anxiety ","Conduct disorder","Per child",null,null,null,null,{"$f":"J17","v":"£s, 2012/13"},null,null,null,null,{"$f":"P18+Q18+R18","v":43600},{"$f":"ROUND((236+558)*_202021/_201213,-2)","v":1000},{"$f":"ROUND(508*_202021/_201213,-2)","v":600},42000,"Multiple",null,"Lifetime","UK","Ditto",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% used in lifetime costs not removed from annual costs, for simplicity. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Perinatal anxiety ","Chronic abdominal pain","Per child",null,null,null,null,{"$f":"J17","v":"£s, 2012/13"},{"$f":"L19+M19+N19","v":150},{"$f":"ROUND(P19/18,-2)","v":100},{"$f":"ROUND(Q19/18,-1)","v":50},null,{"$f":"P19+Q19+R19","v":2900},{"$f":"ROUND((1531+140)*_202021/_201213,-3)","v":2000},{"$f":"ROUND(736*_202021/_201213,-2)","v":900},null,"NHS",null,"Ages 5-16","UK","Ditto",2014,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ","Annual discount of 3.5% used in lifetime costs not removed from annual costs, for simplicity. QALYs discounted at 1.5% in line with PHE."]
[null,null,"Conduct disorder","Overall cost","Per child",5500,{"$f":"F20","v":5500},null,null,"£s, 2017/18",{"$f":"K21+K22+K23","v":6100},{"$f":"K20","v":6100},null,null,null,null,null,null,"Multiple",null,"Childhood","GB","Gutman et al. Children of the millennium. Understanding the course of conduct problems during childhood.",2018,"https://www.centreformentalhealth.org.uk/sites/default/files/2018-11/Children%20of%20the%20Millennium.pdf ","Three British studies provide estimates of the costs of conduct disorder in childhood (Knapp et al., 1999; Romeo et al., 2006; and Snell et al., 2013). All of these give figures for the costs to public services (mainly health, social services and education). To compare, costs in all 3 studies were converted to a common price base, with costs in earlier years assumed to rise in line with inflation.  "]
[null,null,"Conduct disorder","Education","Per child",{"$f":"F20*60%","v":3300},{"$f":"F21","v":3300},null,null,"£s, 2017/18",{"$f":"ROUND((F21*(_202021/_201718)),-2)","v":3700},{"$f":"K21","v":3700},null,null,null,null,null,null,"LA",null,"Childhood","GB","Gutman et al. Children of the millennium. Understanding the course of conduct problems during childhood.",2018,"https://www.centreformentalhealth.org.uk/sites/default/files/2018-11/Children%20of%20the%20Millennium.pdf ","Ditto"]
[null,null,"Conduct disorder","NHS","Per child",{"$f":"F20*28%","v":1540.0000000000002},{"$f":"F22","v":1540.0000000000002},null,null,"£s, 2017/18",{"$f":"ROUND((F22*(_202021/_201718)),-2)","v":1700},{"$f":"K22","v":1700},null,null,null,null,null,null,"NHS",null,"Childhood","GB","Gutman et al. Children of the millennium. Understanding the course of conduct problems during childhood.",2018,"https://www.centreformentalhealth.org.uk/sites/default/files/2018-11/Children%20of%20the%20Millennium.pdf ",{"$f":"Z21","v":"Ditto"}]
[null,null,"Conduct disorder","Social services","Per child",{"$f":"F20*12%","v":660},{"$f":"F23","v":660},null,null,"£s, 2017/18",{"$f":"ROUND((F23*(_202021/_201718)),-2)","v":700},{"$f":"K23","v":700},null,null,null,null,null,null,"LA",null,"Childhood","GB","Gutman et al. Children of the millennium. Understanding the course of conduct problems during childhood.",2018,"https://www.centreformentalhealth.org.uk/sites/default/files/2018-11/Children%20of%20the%20Millennium.pdf ",{"$f":"Z22","v":"Ditto"}]
[null,null,"FASD","Overall cost:","Per child",{"$f":"G24","v":"$ 2978"},"$ 2978",null,null,"2017, USD",{"$f":"ROUND(SUM(L24:N24),-2)","v":18100},{"$f":"SUM(L25:L28)","v":17200},{"$f":"SUM(M25:M28)","v":900},null,null,null,null,null,"Multiple",null,"Annual","OECD","Greenmyer at al. A Multicountry Updated Assessment of the Economic Impact of Fetal Alcohol Spectrum Disorder",2018,"https://pubmed.ncbi.nlm.nih.gov/30383615/","Based on reviews of US, Canada, Sweden and New Zealand. Costs were economic costs associated with FASD, not costs associated with risk of FASD. They were presented in the paper as 2017 US dollars and were converted into 2017 Stirling using a mid-year exchange rate of 0.7731 taken from: https://www.poundsterlinglive.com/best-exchange-rates/best-us-dollar-to-british-pound-history-2017 "]
[null,null,"FASD","Health care","Per child",{"$f":"G25","v":"$ 2978"},"$ 2978",null,null,"2017, USD",{"$f":"SUM(L25:N25)","v":2400},2400,null,null,null,null,null,null,"NHS",null,"Annual","OECD","Ditto",2018,"https://pubmed.ncbi.nlm.nih.gov/30383615/","Ditto"]
[null,null,"FASD","Residential care","Per child",{"$f":"G26","v":"$13573"},"$13573",null,null,"2017, USD",{"$f":"SUM(L26:N26)","v":11100},11100,null,null,null,null,null,null,"LA",null,"Annual","OECD","Ditto",2018,"https://pubmed.ncbi.nlm.nih.gov/30383615/","Ditto"]
[null,null,"FASD","Productivity losses","Per child",{"$f":"H27","v":"$1055"},null,"$1055",null,"2017, USD",900,null,900,null,null,null,null,null,"Individual",null,"Annual","OECD","Ditto",2018,"https://pubmed.ncbi.nlm.nih.gov/30383615/","Ditto"]
[null,null,"FASD","Special education","Per child",{"$f":"G28","v":"$4549"},"$4549",null,null,"2017, USD",3700,3700,null,null,null,null,null,null,"LA",null,"Annual","OECD","Ditto",2018,"https://pubmed.ncbi.nlm.nih.gov/30383615/","Ditto"]

{"sheet":"Homelessness","index":10,"n_rows":15,"n_cols":26,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,2,2,13],[3,14,3,17],[3,18,4,18],[3,25,4,25],[3,20,4,20],[3,21,4,21],[3,22,3,24],[3,10,3,13],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,8],[3,9,4,9]]}
[]
[null,null,"Homelessness unit costs"]
[null,null,"Note: you can access the rows containing breakdowns of annual and lifetime costs (if available or applicable), including reference year, by clicking on [+] above rows L and T. Hovering over a cell with a red triangle on the upper right hand corner provides more information."]
[null,null,"Cost grouping","Cost name","Average","Annual cost as reported",null,null,null,"Publication year costs and currency","Annual costs (2020 to 2021 prices, rounded)",null,null,null,"Lifetime costs",null,null,null,"Who pays?",null,"Timeframe\n(for lifetime costs)","Geography","References",null,null,"Methodological limitations/ bias/ notes"]
[null,null,null,null,null,"Total ","Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,{"$f":"F5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",{"$f":"K5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,null,null,null,"Title and author","Year","Link to source"]
[null,null,"Homelessness","Cost of housing homeless people","Per family",15063,{"$f":"F6","v":15063},null,null,"£s, 2017/18",{"$f":"ROUND((F6*(_202021/_201718)),-2)","v":16900},{"$f":"ROUND((G6*(_202021/_201718)),-2)","v":16900},null,null,null,null,null,null,"LA",null,"One year","GB","Crisis: Assessing the costs and benefits of Crisis’ plan to end homelessness.",2018,"https://www.crisis.org.uk/media/238957/assessing_the_costs_and_benefits_of_crisis-_plan_to_end_homelessness_2018.pdf","Specific unit costs are available for accomodation such as hostels and temporary accommodation. Weighted average is used here. Assuming cost of single homeless person equal to cost of family to be conservative."]
[null,null,"Homelessness","Overall cost","Per adult",{"$f":"SUM(F8:F10)","v":11295},{"$f":"SUM(G8:G10)","v":2951},null,{"$f":"SUM(I8:I10)","v":8344},"£s, 2017/18",{"$f":"ROUND(L7+N7,-2)","v":12600},{"$f":"SUM(L8:L10)","v":3300},null,{"$f":"SUM(N8:N10)","v":9300},null,null,null,null,"Multiple",null,"One year","GB","Crisis: Assessing the costs and benefits of Crisis’ plan to end homelessness.",2018,"https://www.crisis.org.uk/media/238957/assessing_the_costs_and_benefits_of_crisis-_plan_to_end_homelessness_2018.pdf","Benefit from less expensive drug and alcohol treatment and NHS spend removed as based on single homeless people who are likely to be more complex cases. Also, drug and alcohol treatment will be offered to all the people in the case studies for which this database was designed. Welfare payments count as transfer payments in economic analysis, unless taking the perspective of the Exchequer, and so have been excluded. Also excluded are crime costs associated with child. being homeless to be conservative."]
[null,null,"Homelessness","Mental health","Per adult",512,{"$f":"F8","v":512},null,null,"£s, 2017/18",{"$f":"ROUND((F8*(_202021/_201718)),-2)","v":600},{"$f":"ROUND((G8*(_202021/_201718)),-2)","v":600},null,null,null,null,null,null,"NHS",null,"One year","GB","Ditto",2018,"https://www.crisis.org.uk/media/238957/assessing_the_costs_and_benefits_of_crisis-_plan_to_end_homelessness_2018.pdf","Average cost for contact with mental health services per person per year based on Pleace and Culhane (2016)."]
[null,null,"Homelessness","Crime","Per adult",2439,{"$f":"F9","v":2439},null,null,"£s, 2017/18",{"$f":"ROUND((F9*(_202021/_201718)),-2)","v":2700},{"$f":"ROUND((G9*(_202021/_201718)),-2)","v":2700},null,null,null,null,null,null,"CJS",null,"One year","GB","Ditto",2018,"https://www.crisis.org.uk/media/238957/assessing_the_costs_and_benefits_of_crisis-_plan_to_end_homelessness_2018.pdf","Average cost of contact with CJS based on  Pleace and Culhane (2016)."]
[null,null,"Homelessness","Wellbeing","Per adult",{"$f":"F15","v":8344},null,null,{"$f":"I15","v":8344},"£s, 2017/18",{"$f":"ROUND((F10*(_202021/_201718)),-2)","v":9300},null,null,{"$f":"ROUND((I10*(_202021/_201718)),-2)","v":9300},null,null,null,null,"Individual",null,"Lifetime","GB","Ditto",2018,"https://www.crisis.org.uk/media/238957/assessing_the_costs_and_benefits_of_crisis-_plan_to_end_homelessness_2018.pdf","CAN WE USE? COMPATIBLE WITH QALYS?"]
[null,null,"Homelessness","Overall cost","Per child",{"$f":"F12+F13+F14+F15","v":30019},{"$f":"G12+G13+G14+G15","v":572},{"$f":"H12+H13+H14+H15","v":21103},{"$f":"I12+I13+I14+I15","v":8344},"£s, 2017/18",{"$f":"ROUND(K12+K13+K14+K15,-2)","v":33500},{"$f":"L12+L13+L14+L15","v":600},{"$f":"M12+M13+M14+M15","v":23600},{"$f":"N12+N13+N14+N15","v":9300},null,null,null,null,"Multiple",null,"Lifetime","GB","Crisis: Assessing the costs and benefits of Crisis’ plan to end homelessness.",2018,"https://www.crisis.org.uk/media/238957/assessing_the_costs_and_benefits_of_crisis-_plan_to_end_homelessness_2018.pdf","Benefit from less expensive drug and alcohol treatment and NHS spend removed as based on single homeless people who are likely to be more complex cases. Also, drug and alcohol treatment will be offered to all the people in the case studies for which this database was designed. Welfare payments count as transfer payments in economic analysis , unless taking the perspective of the Exchequer, and so have been excluded. Also excluded are crime costs associated with child being homeless to be conservative."]
[null,null,"Homelessness","Lifetime employment","Per child",21103,null,{"$f":"F12","v":21103},null,"£s, 2017/18",{"$f":"ROUND((F12*(_202021/_201718)),-2)","v":23600},null,{"$f":"ROUND((H12*(_202021/_201718)),-2)","v":23600},null,null,null,null,null,"n/a",null,"Lifetime","GB","Ditto",2018,"https://www.crisis.org.uk/media/238957/assessing_the_costs_and_benefits_of_crisis-_plan_to_end_homelessness_2018.pdf","The number of children living in poor quality housing (reflects homelessness, overcrowding and poor conditions) gaining no GCSEs to the number of children who do not gain GCSE but are not living in bad housing (25% compared to 10%) are used to generate an expected lifetime earnings  based on the lifetime return to achieving 1-2 GCSEs as calculated by the Department of Education. "]
[null,null,"Homelessness","Physical health","Per child",223,{"$f":"F13","v":223},null,null,"£s, 2017/18",{"$f":"ROUND((F13*(_202021/_201718)),-2)","v":200},200,null,null,null,null,null,null,"NHS",null,"0-19 years old","GB","Ditto",2018,"https://www.crisis.org.uk/media/238957/assessing_the_costs_and_benefits_of_crisis-_plan_to_end_homelessness_2018.pdf","Data on the average cost of NHS for a child in different age bands between 0-19 is weighted based on age distribution of homeless children. Evidence suggests that a child who is homeless represented by children living in bad housing (e.g. unsuitable temporary accommodation) is 25% more likely to have health related issues. "]
[null,null,"Homelessness","Mental health","Per child",349,{"$f":"F14","v":349},null,null,"£s, 2017/18",400,400,null,null,null,null,null,null,"NHS",null,{"$f":"U13","v":"0-19 years old"},"GB","Ditto",2018,"https://www.crisis.org.uk/media/238957/assessing_the_costs_and_benefits_of_crisis-_plan_to_end_homelessness_2018.pdf","Same method as for health mentioned above."]
[null,null,"Homelessness","Wellbeing","Per child",8344,null,null,{"$f":"F15","v":8344},"£s, 2017/18",{"$f":"ROUND((F15*(_202021/_201718)),-2)","v":9300},null,null,{"$f":"ROUND((I15*(_202021/_201718)),-2)","v":9300},null,null,null,null,"Individual",null,"Lifetime","GB","Ditto",2018,"https://www.crisis.org.uk/media/238957/assessing_the_costs_and_benefits_of_crisis-_plan_to_end_homelessness_2018.pdf","Based on Fujiwara and Vine's 2016 paper for HACT on valuing wellbing for moving from temporary accommodation to secure housing."]

{"sheet":"NHS & LA treatment","index":11,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,2,2,13],[3,25,4,25],[3,14,3,17],[3,18,4,18],[3,20,4,20],[3,21,4,21],[3,22,3,24],[3,10,3,13],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,8],[3,9,4,9]]}
[]
[null,null,"NHS and LA treatment unit costs"]
[null,null,"Note: you can access the rows containing breakdowns of annual and lifetime costs (if available or applicable), including reference year, by clicking on [+] above rows K and S. Hovering over a cell with a red triangle on the upper right hand corner provides more information."]
[null,null,"Cost grouping","Cost name","Average","Annual cost as reported",null,null,null,"Publication year costs and currency","Annual costs (2020 to 2021 prices, rounded)",null,null,null,"Lifetime costs",null,null,null,"Who pays?",null,"Timeframe\n(for lifetime costs)","Geography","References",null,null,"Methodological limitations/ bias/ notes"]
[null,null,null,null,null,"Total ","Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,{"$f":"F5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",{"$f":"K5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,null,null,null,"Title and author","Year","Link to source"]
[null,null,"Physiotherapy","Group session","Per child contact",81,{"$f":"F6","v":81},null,null,"£s, 2018/19",{"$f":"ROUND((F6*(_202021/_201819)),-2)","v":100},{"$f":"K6","v":100},null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"Physiotherapy","1:1 session","Per child contact",100,100,null,null,"£s, 2018/19",100,100,null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"Paediatrics","Elective inpatient","Per child contact",2978,2978,null,null,"£s, 2018/19",3300,3300,null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"Paediatrics","Outpatient","Per child contact",198,198,null,null,"£s, 2018/19",200,200,null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"Paediatrics","Critical care","Per child contact",1421,1421,null,null,"£s, 2018/19",1600,1600,null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"Paediatrics","Critical care transportation","Per child contact",3390,3390,null,null,"£s, 2018/19",3700,3700,null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"C&YP mental health","Day care facilities – regular attendance","Per child contact",277,{"$f":"F12","v":277},null,null,"£s, 2018/19",{"$f":"ROUND((F12*(_202021/_201819)),-2)","v":300},{"$f":"K12","v":300},null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"C&YP mental health","Admitted patients","Per child contact",733,733,null,null,{"$f":"J12","v":"£s, 2018/19"},800,800,null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"C&YP mental health","Admitted patients – psychiatric intensive care","Per child contact",1358,1358,null,null,"£s, 2018/19",1500,1500,null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"C&YP mental health","Community contact","Per child contact",234,234,null,null,"£s, 2018/19",300,300,null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"C&YP mental health","Community contact, crisis resolution","Per child contact",192,192,null,null,"£s, 2018/19",200,200,null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"C&YP mental health","Outpatient attendance ","Per child contact",307,307,null,null,"£s, 2018/19",300,300,null,null,null,null,null,null,"NHS",null,"n/a","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"C&YP mental health","Cognitive behavioural therapy (CBT) for adolescents","Per intervention ",229,229,null,null,"£s, 2018/19",{"$f":"ROUND((F18*(_202021/_201819)),-2)","v":300},{"$f":"K18","v":300},null,null,null,null,null,null,"NHS",null,"One year","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","n/a"]
[null,null,"C&YP mental health","Counselling for children with mental or emotional difficulties","Per intervention ",1126,1126,null,null,"£s, 2018/19",{"$f":"ROUND((F19*(_202021/_201819)),-2)","v":1200},{"$f":"K19","v":1200},null,null,null,null,null,null,"NHS",null,"One year","England","PSSRU. Unit cost of health and social care",2019,"https://www.pssru.ac.uk/pub/uc/uc2019/services.pdf","The costs estimated represent a ‘typical’ service. There is significant variability between service models dependent on client and commissioner needs. Biased towards activity of one service."]
[null,null,"Alcohol and drug treatment","Treatment for opioid use","Per adult",null,null,null,null,null,{"$f":"L20","v":2800},2800,null,null,null,null,null,null,"LA",null,"One year","England","PHE internal calculations."]
[null,null,"Alcohol and drug treatment","Treatment for non-opioid drug use","Per adult",null,null,null,null,null,{"$f":"L21","v":1100},1100,null,null,null,null,null,null,"LA",null,"One year","England","PHE internal calculations."]
[null,null,"Alcohol and drug treatment","Treatment for alcohol use","Per adult",null,null,null,null,null,1300,1300,null,null,null,null,null,null,"LA",null,"One year","England","PHE internal calculations."]
[null,null,"Alcohol and drug treatment","Treatment for young people (alcohol and drugs)","Per young person",null,null,null,null,null,2100,2100,null,null,null,null,null,null,"LA",null,"One year","England","PHE internal calculations."]
[null,null,"Alcohol and drug treatment","Inpatient detoxfication","Per adult",null,null,null,null,null,2400,2400,null,null,null,null,null,null,"LA",null,"One year","England","PHE internal calculations."]
[null,null,"Alcohol and drug treatment","Residential rehabilitation","Per adult",null,null,null,null,null,9800,9800,null,null,null,null,null,null,"LA",null,"One year","England","PHE internal calculations."]
[null,null,"Adult mental health",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One year"]
[null,null,"Adult mental health",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One year"]
[null,null,"Adult mental health",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One year"]
[null,null,"Hospital","Ambulance call-out","Per event",null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS",null,"One year"]
[null,null,"Hospital","A&E attendance","Per event",null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS",null,"One year"]
[null,null,"Hospital","Inpatient","Per event",null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS",null,"One year"]
[null,null,"Hospital","Outpatient","Per event",null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS",null,"One year"]
[null,null,"Hospital","Day case","Per event",null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS",null,"One year"]
[null,null,"GP","GP visit","Per event",null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS",null,"One year"]
[null,null,"Pharmacy","Prescription","Per prescription",null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS",null,"One year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One year"]
[null,null,null,"NHS COSTS - FROM LTP?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One year"]
[null,null,null,"TX COSTS FROM VFM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One year"]
[null,null,null,"COSTS PREVENTED FROM RECOVERY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One year"]

{"sheet":"DA & crime","index":12,"n_rows":44,"n_cols":26,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,2,2,13],[3,21,4,21],[3,25,4,25],[3,2,4,2],[3,22,3,24],[3,20,4,20],[3,3,4,3],[3,4,4,4],[3,18,4,18],[3,5,3,8],[3,10,3,13],[3,9,4,9],[3,14,3,17]]}
[]
[null,null,"Domestic abuse and crime unit costs"]
[null,null,"Note: you can access the rows containing breakdowns of annual and lifetime costs (if available or applicable), including reference year, by clicking on [+] above rows K and S. Hovering over a cell with a red triangle on the upper right hand corner provides more information."]
[null,null,"Cost grouping","Cost name","Average","Annual cost as reported",null,null,null,"Publication year costs and currency","Annual costs (2020 to 2021 prices, rounded)",null,null,null,"Lifetime costs",null,null,null,"Who pays?",null,"Timeframe\n(for lifetime costs)","Geography","References",null,null,"Methodological limitations/ bias/ notes"]
[null,null,null,null,null,"Total ","Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,{"$f":"F5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",{"$f":"K5","v":"Total "},"Direct\n(LA/ NHS/ CJS)","Indirect","Intangible (QALYs)",null,null,null,null,"Title and author","Year","Link to source"]
[null,null,"Domestic abuse","Overall cost","Per adult survivor",{"$f":"SUM(G6:I6)","v":31156.176470588234},2470,7245,{"$f":"24300*60/68","v":21441.176470588234},"£s, 2016/17",{"$f":"SUM(L6:N6)","v":32500},{"$f":"ROUND((G6*(_202021/_201617)),-2)","v":2800},{"$f":"ROUND((H6*(_202021/_201617)),-2)","v":8300},{"$f":"ROUND(I6,-2)","v":21400},null,null,null,null,"Multiple",null,"One year","England and Wales","Oliver at al. The economic and social costs of\ndomestic abuse",2019,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/772180/horr107.pdf","Home Office estimate of unit cost based on crime survey for England and Wales (CSEW) and recorded crime data. Small sample size. Does not contain data on repeat incidents. Victims aged 16-59 only. The impact on children and associated social services costs have not been included. QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"Domestic abuse","NHS costs","Per adult survivor",1200,{"$f":"F7","v":1200},null,null,"£s, 2016/17",1400,{"$f":"ROUND((G7*(_202021/_201617)),-2)","v":1400},null,null,null,null,null,null,"NHS",null,"One year","England and Wales","Ibid.",2019,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/772180/horr107.pdf","Home Office estimate of unit cost based on crime survey for England and Wales (CSEW) and recorded crime data. Small sample size. Does not contain data on repeat incidents. Victims aged 16-59 only. The impact on children and associated social services costs have not been included. "]
[null,null,"Domestic abuse","Lost output","Per adult survivor",{"$f":"H8","v":7245},null,{"$f":"H6","v":7245},null,"£s, 2016/17",8300,null,8300,null,null,null,null,null,"n/a",null,"One year","England and Wales","Ibid.",2019,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/772180/horr107.pdf","Ditto"]
[null,null,"Domestic abuse","Quality-adjusted life years (QALYs) lost","Per adult survivor",{"$f":"I6","v":21441.176470588234},null,null,{"$f":"I6","v":21441.176470588234},"£s, 2016/17",21400,null,null,{"$f":"ROUND(I9,-2)","v":21400},null,null,null,null,"Individual",null,"One year","England and Wales","Ibid.",2019,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/772180/horr107.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"Domestic abuse","Police/ criminal justice","Per adult survivor",{"$f":"645+170+70+5","v":890},{"$f":"F10","v":890},null,null,"£s, 2016/17",1000,{"$f":"ROUND((G10*(_202021/_201617)),-2)","v":1000},null,null,null,null,null,null,"Criminal justice system",null,"One year","England and Wales","Ibid.",2019,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/772180/horr107.pdf","Home Office estimate of unit cost based on crime survey for England and Wales (CSEW) and recorded crime data. Small sample size. Does not contain data on repeat incidents. Victims aged 16-59 only. The impact on children and associated social services costs have not been included. "]
[null,null,"Domestic abuse","Other costs","Per adult survivor",{"$f":"F6-SUM(F7:F10)","v":380},null,{"$f":"F11","v":380},null,"£s, 2016/17",{"$f":"SUM(M11:N11)","v":400},null,{"$f":"ROUND((H11*(_202021/_201617)),-2)","v":400},null,null,null,null,null,"Multiple",null,"One year","England and Wales","Ibid.",2019,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/772180/horr107.pdf","Ditto"]
[null,null,"Violence with injury","Overall cost","Per incident",{"$f":"SUM(G12:I12)","v":13090.588235294117},{"$f":"'Crime cost calcs'!I37","v":3420},{"$f":"'Crime cost calcs'!G37","v":2400},{"$f":"'Crime cost calcs'!H37","v":7270.5882352941171},"£s, 2015/16",14100,{"$f":"ROUND((G12*(_202021/_201516)),-2)","v":4000},{"$f":"ROUND((H12*(_202021/_201516)),-2)","v":2800},{"$f":"ROUND(I12,-2)","v":7300},null,null,null,null,"Multiple",null,"One year","England and Wales","Heeks et al. The economic and social costs of crime. Second edition",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"Violence with injury","NHS","Per incident",920,920,null,null,"£s, 2015/16",1100,1100,null,null,null,null,null,null,"NHS",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Violence with injury","Lost output","Per incident",2060,null,2060,null,"£s, 2015/16",2400,null,{"$f":"ROUND((H14*(_202021/_201516)),-2)","v":2400},null,null,null,null,null,"n/a",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Violence with injury","Quality-adjusted life years (QALYs) lost","Per incident",7270.5882352941171,null,null,7270.5882352941171,"£s, 2015/16",7300,null,null,{"$f":"ROUND(I15,-2)","v":7300},null,null,null,null,"Individual",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"Violence with injury","Cost in response to crime","Per incident",2500,2500,null,null,"£s, 2015/16",2900,{"$f":"ROUND((G16*(_202021/_201516)),-2)","v":2900},null,null,null,null,null,null,"Criminal justice system",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Violence with injury","Cost in anticpiation of crime","Per incident",{"$f":"SUM(G17:I17)","v":340},null,340,null,"£s, 2015/16",400,null,{"$f":"ROUND((H17*(_202021/_201516)),-2)","v":400},null,null,null,null,null,"Multiple",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Violence without injury","Overall cost","Per incident",{"$f":"SUM(G18:I18)","v":5609.411764705882},{"$f":"'Crime cost calcs'!I38","v":2340},{"$f":"'Crime cost calcs'!G38","v":790},{"$f":"'Crime cost calcs'!H38","v":2479.411764705882},"£s, 2015/16",{"$f":"SUM(L18:N18)","v":6100},{"$f":"ROUND((G18*(_202021/_201516)),-2)","v":2700},900,{"$f":"ROUND(I18,-2)","v":2500},null,null,null,null,"Multiple",null,"One year","England and Wales","Heeks et al. The economic and social costs of crime. Second edition",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"Violence without injury","NHS","Per incident",270,{"$f":"'Crime cost calcs'!L8","v":270},null,null,"£s, 2015/16",300,300,null,null,null,null,null,null,"NHS",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Violence without injury","Lost output","Per incident",670,null,{"$f":"'Crime cost calcs'!K8","v":670},null,"£s, 2015/16",800,null,{"$f":"ROUND((H20*(_202021/_201516)),-2)","v":800},null,null,null,null,null,"n/a",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Violence without injury","Quality-adjusted life years (QALYs) lost","Per incident",2479.411764705882,null,null,{"$f":"'Crime cost calcs'!H38","v":2479.411764705882},"£s, 2015/16",2500,null,null,{"$f":"ROUND(I21,-2)","v":2500},null,null,null,null,"Individual",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"Violence without injury","Cost in response to crime","Per incident",2070,{"$f":"'Crime cost calcs'!N8+'Crime cost calcs'!O8+'Crime cost calcs'!P8","v":2070},null,null,"£s, 2015/16",2400,{"$f":"ROUND((G22*(_202021/_201516)),-2)","v":2400},null,null,null,null,null,null,"Criminal justice system",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Violence without injury","Cost in anticpiation of crime","Per incident",{"$f":"SUM(G23:I23)","v":120},null,{"$f":"H18-H19-H20-H21-H22","v":120},null,"£s, 2015/16",100,null,{"$f":"ROUND((H23*(_202021/_201516)),-2)","v":100},null,null,null,null,null,"Multiple",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Shoplifting","Shoplifting","Per incident",130,130,null,null,"£s, 2015/16",{"$f":"ROUND((F24*(_202021/_201516)),-1)","v":150},{"$f":"K24","v":150},null,null,null,null,null,null,"Multiple",null,"One year","England and Wales","Fell et al. Understanding organised crime 2015/16 Estimating the scale and the social and economic costs. Second edition.\n",2019,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/782656/understanding-organised-crime-mar16-horr103-2nd.pdf","Shoplifting is not directly comparable to what is available in the latest unit costs of crime published by the Home Office (HO). Instead, the unit costs presented in the 2015/16 HO drug-related crime estimates have been uprated, which were originally sourced from a 2013 estimate."]
[null,null,"Robbery","Overall cost","Per incident",{"$f":"SUM(G25:I25)","v":9867.6470588235297},{"$f":"'Crime cost calcs'!I41","v":5450},{"$f":"'Crime cost calcs'!G41","v":1250},{"$f":"'Crime cost calcs'!H41","v":3167.6470588235293},"£s, 2015/16",{"$f":"SUM(L25:N25)","v":11100},{"$f":"ROUND((G25*(_202021/_201516)),-2)","v":6400},1500,{"$f":"ROUND(I25,-2)","v":3200},null,null,null,null,"Multiple",null,"One year","England and Wales","Heeks et al. The economic and social costs of crime. Second edition",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"Robbery","NHS","Per incident",760,760,null,null,"£s, 2015/16",900,900,null,null,null,null,null,null,"NHS",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Robbery","Lost output","Per incident",920,null,920,null,"£s, 2015/16",1100,null,1100,null,null,null,null,null,"n/a",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Robbery","Quality-adjusted life years (QALYs) lost","Per incident",3167.6470588235293,null,null,3167.6470588235293,"£s, 2015/16",3200,null,null,{"$f":"ROUND(I28,-2)","v":3200},null,null,null,null,"Individual",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"Robbery","Cost in response to crime","Per incident",4690,4690,null,null,"£s, 2015/16",5500,5500,null,null,null,null,null,null,"Criminal justice system",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Robbery","Cost in anticpiation of crime","Per incident",330,null,330,null,"£s, 2015/16",400,null,400,null,null,null,null,null,"Multiple",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"House burglary","Overall cost","Per incident",4380,{"$f":"'Crime cost calcs'!I42","v":2180},{"$f":"'Crime cost calcs'!G42","v":1150},{"$f":"'Crime cost calcs'!H42","v":1050},"£s, 2015/16",4900,{"$f":"ROUND((G31*(_202021/_201516)),-2)","v":2500},{"$f":"ROUND((H31*(_202021/_201516)),-2)","v":1300},{"$f":"ROUND(I31,-2)","v":1100},null,null,null,null,"Multiple",null,"One year","England and Wales","Heeks et al. The economic and social costs of crime. Second edition",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"House burglary","NHS","Per incident",380,380,null,null,"£s, 2015/16",400,{"$f":"ROUND((G32*(_202021/_201516)),-2)","v":400},null,null,null,null,null,null,"NHS",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"House burglary","Lost output","Per incident",440,null,440,null,"£s, 2015/16",500,null,500,null,null,null,null,null,"n/a",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"House burglary","Quality-adjusted life years (QALYs) lost","Per incident",1050,null,null,1050,"£s, 2015/16",1100,null,null,{"$f":"ROUND(I34,-2)","v":1100},null,null,null,null,"Individual",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"House burglary","Cost in response to crime","Per incident",1800,1800,null,null,"£s, 2015/16",2100,{"$f":"ROUND((G35*(_202021/_201516)),-2)","v":2100},null,null,null,null,null,null,"Criminal justice system",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"House burglary","Cost in anticpiation of crime","Per incident",710,null,710,null,"£s, 2015/16",800,null,{"$f":"M31-M32-M33-M34-M35","v":800},null,null,null,null,null,"Multiple",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Criminal damage",{"$f":"C37","v":"Criminal damage"},"Per incident",1098.2352941176471,{"$f":"'Crime cost calcs'!I46","v":720},{"$f":"'Crime cost calcs'!G46","v":140},{"$f":"'Crime cost calcs'!H46","v":238.23529411764704},"£s, 2015/16",1200,{"$f":"ROUND((G37*(_202021/_201516)),-2)","v":800},{"$f":"ROUND((H37*(_202021/_201516)),-2)","v":200},{"$f":"ROUND(I37,-2)","v":200},null,null,null,null,"Multiple",null,"One year","England and Wales","Dame Carol Black Review of Drugs - evidence relating to drug use, supply and effects, including current trends and future risks",2019,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/882953/Review_of_Drugs_Evidence_Pack.pdf"]
[null,null,"Vehicle theft","Overall cost","Per incident",6118.2352941176468,{"$f":"'Crime cost calcs'!I43","v":4000},{"$f":"'Crime cost calcs'!G43","v":1880},{"$f":"'Crime cost calcs'!H43","v":238.23529411764704},"£s, 2015/16",{"$f":"SUM(L38:N38)","v":7100},{"$f":"ROUND((G38*(_202021/_201516)),-2)","v":4700},{"$f":"ROUND((H38*(_202021/_201516)),-2)","v":2200},{"$f":"ROUND(I38,-2)","v":200},null,null,null,null,"Multiple",null,"One year","England and Wales","Heeks et al. The economic and social costs of crime. Second edition",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"Vehicle theft","NHS","Per incident",100,100,null,null,"£s, 2015/16",{"$f":"SUM(L39:N39)","v":100},{"$f":"ROUND((G39*(_202021/_201516)),-2)","v":100},null,null,null,null,null,null,"NHS",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Vehicle theft","Lost output","Per incident",{"$f":"SUM(G40:I40)","v":150},null,150,null,"£s, 2015/16",{"$f":"SUM(L40:N40)","v":200},null,{"$f":"ROUND((H40*(_202021/_201516)),-2)","v":200},null,null,null,null,null,"n/a",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Vehicle theft","Quality-adjusted life years (QALYs) lost","Per incident",238.23529411764704,null,null,238.23529411764704,"£s, 2015/16",{"$f":"SUM(L41:N41)","v":200},null,null,{"$f":"ROUND(I41,-2)","v":200},null,null,null,null,"Individual",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf","QALYs amended so 1 QALY = £60k in line with PHE recommendations."]
[null,null,"Vehicle theft","Cost in response to crime","Per incident",3900,3900,null,null,"£s, 2015/16",4600,{"$f":"ROUND((G42*(_202021/_201516)),-2)","v":4600},null,null,null,null,null,null,"Criminal justice system",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Vehicle theft","Cost in anticpiation of crime","Per incident",{"$f":"SUM(G43:I43)","v":1730},null,1730,null,"£s, 2015/16",{"$f":"SUM(L43:N43)","v":2000},null,{"$f":"M38-M39-M40-M41-M42","v":2000},null,null,null,null,null,"Multiple",null,"One year","England and Wales","Ibid.",2018,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/732110/the-economic-and-social-costs-of-crime-horr99.pdf"]
[null,null,"Police call out","Police call out","Per incident",500,500,null,null,"£s, 2015/16",500,500,null,null,null,null,null,null,{"$f":"S42","v":"Criminal justice system"},null,"n/a","England and Wales","Provided by Department of Work and Pensions Economists",2020]

{"sheet":"Part 3 - Annexes","index":13,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,3,3,10],[24,3,24,10],[22,3,22,10]]}
[]
[null,null,null,"Part 3: Annexes"]
[]
[]
[null,null,null,"Contents"]
[]
[null,null,null,"Annex","Corresponding tab","Notes"]
[null,null,null,"A1 - HM Treasury's GDP deflator","A1 GDP deflator","Used to inflate costs to 2019 to 2020 prices in the database"]
[null,null,null,"A2 - HM Treasury's discount factors","A2 Discount","Used to discount future costs in line with Treasury guidance in the database"]
[null,null,null,"A3 - Market forces","A3 Market forces","LAs can use these multipliers to change national unit costs to local ones. The market forces factor adjusts for differences in staff and building costs across the country."]

{"sheet":"A1 GDP deflator","index":14,"n_rows":80,"n_cols":12,"rows_kept":80,"cut":false,"hidden":false,"merged":[[5,2,5,11],[6,2,6,11],[8,3,8,4],[8,9,8,10],[93,3,93,11],[82,3,82,11],[83,3,83,11],[84,3,84,11],[85,3,85,11],[86,3,86,11],[87,3,87,11],[88,3,88,11],[89,3,89,11],[90,3,90,11],[91,3,91,11],[92,3,92,11],[101,3,101,11],[102,3,102,11],[95,3,95,11],[96,3,96,11],[97,3,97,11],[98,3,98,11],[99,3,99,11],[100,3,100,11]]}
[]
[null,null,"A1: HM Treasury GDP deflators at market prices and money GDP"]
[]
[null,null,"The information below has been used to inflate prices to 2020 to 2021 prices."]
[]
[null,null,"Outturn data are as at the First Quarterly Estimate of GDP from the ONS - last updated 3 March 2021."]
[]
[]
[null,null,null,"GDP deflator at market prices ",null,"Money GDP",null,null,null,"GDP deflator at market prices ",null,"Money GDP"]
[null,null,"Financial year","2019 to 2020 = 100","percent change on previous year","Cash £ million\nnon-seasonally adjusted","Cash £ million\nseasonally adjusted",null,"Calendar year","2020 = 100","percent change on previous year","Cash £ million\nNon-Seasonally Adjusted"]
[null,null,"1955 to 1956",4.0209000000000001,0,19565,19579,null,1955,3.7648999999999999,0,19160]
[null,null,"1956 to 1957",4.2732250000000001,6.2753363674799152,21149,21125,null,1956,4.0259,6.9324550452867308,20832]
[null,null,"1957 to 1958",4.4702000000000002,4.609516231885757,22499,22514,null,1957,4.1871,4.0040736232892025,22093]
[null,null,"1958 to 1959",4.5775000000000006,2.400340029528889,23325,23296,null,1958,4.3403999999999998,3.6612452532779192,23210]
[null,null,"1959 to 1960",4.6005000000000003,0.50245767340250536,24862,24916,null,1959,4.3719999999999999,0.72804349829508974,24378]
[null,null,"1960 to 1961",4.694,2.0323877839365219,26628,26646,null,1960,4.4173,1.0361390667886576,26189]
[null,null,"1961 to 1962",4.8657499999999994,3.6589262888794076,28128,28157,null,1961,4.5845000000000002,3.7851176057772906,27905]
[null,null,"1962 to 1963",5.0186000000000002,3.1413451163746768,29440,29457,null,1962,4.7497999999999996,3.6056276584142073,29224]
[null,null,"1963 to 1964",5.1018749999999997,1.6593273024349331,31915,31871,null,1963,4.8193000000000001,1.4632195039791269,31091]
[null,null,"1964 to 1965",5.3431250000000006,4.7286536812446576,34850,34918,null,1964,4.9922000000000004,3.5876579586247024,34043]
[null,null,"1965 to 1966",5.6315750000000007,5.3985261434085867,37459,37414,null,1965,5.2893999999999997,5.9532871279195394,36826]
[null,null,"1966 to 1967",5.9190249999999995,5.1042559141980499,39952,39948,null,1966,5.5721999999999996,5.3465421408855445,39394]
[null,null,"1967 to 1968",6.08155,2.7458069530032478,42517,42625,null,1967,5.7373000000000003,2.9629230824450072,41684]
[null,null,"1968 to 1969",6.4003499999999995,5.2420846659157538,46778,46800,null,1968,5.9786999999999999,4.2075540759590675,45809]
[null,null,"1969 to 1970",6.8428749999999994,6.9140750115228053,50866,50921,null,1969,6.3754999999999997,6.6368943081271823,49785]
[null,null,"1970 to 1971",7.5181750000000003,9.8686590066309989,57738,57821,null,1970,6.9885999999999999,9.6165006666143871,56057]
[null,null,"1971 to 1972",8.0861750000000008,7.5550249894422574,64582,64489,null,1971,7.5677000000000003,8.2863520590676298,62885]
[null,null,"1972 to 1973",8.7730999999999995,8.495054831239722,73895,73997,null,1972,8.1393000000000004,7.5531535340988691,70553]
[null,null,"1973 to 1974",9.5455000000000005,8.8041855216514247,82801,82825,null,1973,8.8609000000000009,8.8656272652439458,81746]
[null,null,"1974 to 1975",11.4831,20.298570006809488,98121,98292,null,1974,10.2935,16.167657912853084,92612]
[null,null,"1975 to 1976",14.29415,24.479887835166462,120774,120658,null,1975,12.983700000000001,26.134939524942936,115027]
[null,null,"1976 to 1977",16.283950000000001,13.920380015600792,141965,142478,null,1976,14.991300000000001,15.462464474687494,136901]
[null,null,"1977 to 1978",18.52345,13.752805676755331,165933,165716,null,1977,17.068899999999999,13.85870471540159,159631]
[null,null,"1978 to 1979",20.608849999999997,11.258161951472303,192151,192270,null,1978,19.084199999999999,11.806853400043353,185960]
[null,null,"1979 to 1980",24.082250000000002,16.853924406262387,232309,232344,null,1979,21.839400000000001,14.437073600150921,220721]
[null,null,"1980 to 1981",28.68665,19.119475962586545,267219,267501,null,1980,26.252700000000001,20.207972746504023,259663]
[null,null,"1981 to 1982",31.708275,10.533209698588021,297912,297358,null,1981,29.489000000000001,12.327493933957269,289840]
[null,null,"1982 to 1983",34.042149999999999,7.3604603214775928,327113,327373,null,1982,31.850200000000001,8.0070534775679079,319212]
[null,null,"1983 to 1984",35.668500000000002,4.7774597080384238,357776,357033,null,1983,33.6158,5.5434502766073654,351051]
[null,null,"1984 to 1985",37.696550000000002,5.685829233076805,385702,384904,null,1984,35.3703,5.2192718900041051,377644]
[null,null,"1985 to 1986",39.795000000000002,5.5666897899144603,423588,424157,null,1985,37.274799999999999,5.3844609743202589,414428]
[null,null,"1986 to 1987",41.444950000000006,4.1461238849101747,455402,456104,null,1986,38.9465,4.4847993818880356,446635]
[null,null,"1987 to 1988",43.763900000000007,5.5952534627258581,510969,511263,null,1987,41.042200000000001,5.380971332468901,496140]
[null,null,"1988 to 1989",46.622799999999998,6.5325530859909442,570134,571066,null,1988,43.472499999999997,5.9214661982057386,555607]
[null,null,"1989 to 1990",50.236750000000001,7.7514649484801481,628400,628141,null,1989,46.883099999999999,7.8454195180861523,614524]
[null,null,"1990 to 1991",54.367025000000005,8.2216206263343174,678521,680052,null,1990,50.67,8.0773242383716148,668931]
[null,null,"1991 to 1992",57.525350000000003,5.8092658187568613,714840,713503,null,1991,54.0289,6.6289717781724846,705464]
[null,null,"1992 to 1993",59.022625000000005,2.602809022457059,737126,738927,null,1992,55.727400000000003,3.1436879151713302,730578]
[null,null,"1993 to 1994",60.475175,2.4610054195319084,780790,778283,null,1993,57.243099999999998,2.7198469693543847,769159]
[null,null,"1994 to 1995",61.257725000000001,1.2940020429870613,819023,818955,null,1994,58.013199999999998,1.3453149811942389,809486]
[null,null,"1995 to 1996",63.079749999999997,2.9743595603656461,863523,862117,null,1995,59.424399999999999,2.4325498334861737,850181]
[null,null,"1996 to 1997",65.321149999999989,3.5532797767904785,920418,921031,null,1996,61.870100000000001,4.1156494638566015,907265]
[null,null,"1997 to 1998",65.105674999999991,-0.32987018752731379,962452,961038,null,1997,61.833500000000001,-5.915619984451289E-2,951750]
[null,null,"1998 to 1999",66.177275000000009,1.6459394668744589,1009908,1011945,null,1998,62.467100000000002,1.024687264993897,997247]
[null,null,"1999 to 2000",66.472425000000001,0.44599902307853029,1053356,1052515,null,1999,63.059800000000003,0.94881945856298866,1039752]
[null,null,"2000 to 2001",67.684349999999995,1.8231996199927922,1107366,1104074,null,2000,64.210999999999999,1.8255687458571004,1095900]
[null,null,"2001 to 2002",68.6738,1.4618593515340033,1147125,1150867,null,2001,64.925799999999995,1.1132049025867792,1138375]
[null,null,"2002 to 2003",70.206050000000005,2.2312002539542077,1206906,1203341,null,2002,66.291499999999999,2.1034781242587752,1187671]
[null,null,"2003 to 2004",71.714349999999996,2.1483903452764985,1270825,1272015,null,2003,67.860100000000003,2.3662158798639399,1256188]
[null,null,"2004 to 2005",73.762725000000003,2.8562972403710098,1334628,1332488,null,2004,69.582499999999996,2.5381630737355132,1317459]
[null,null,"2005 to 2006",75.708799999999997,2.6382905458007326,1417614,1416731,null,2005,71.457099999999997,2.6940681924334435,1393038]
[null,null,"2006 to 2007",77.858175000000003,2.839002863603711,1487940,1487724,null,2006,73.468400000000003,2.8146958104932969,1470719]
[null,null,"2007 to 2008",80.052824999999999,2.8187791455425146,1566500,1568149,null,2007,75.449399999999997,2.6963973626756461,1546085]
[null,null,"2008 to 2009",82.221874999999997,2.7095233678511641,1572822,1573012,null,2008,77.788799999999995,3.1006210784976393,1589259]
[null,null,"2009 to 2010",83.536000000000001,1.5982668845729975,1559454,1558950,null,2009,79.0351,1.6021586655148363,1548513]
[null,null,"2010 to 2011",85.065825000000004,1.8313361903849867,1624581,1625391,null,2010,80.303399999999996,1.6047300503194104,1606027]
[null,null,"2011 to 2012",86.355574999999988,1.516178794480608,1670141,1667346,null,2011,81.964699999999993,2.0687791550544525,1660141]
[null,null,"2012 to 2013",88.121200000000002,2.0445987418878451,1724150,1726358,null,2012,83.319500000000005,1.6529066781187656,1711770]
[null,null,"2013 to 2014",89.710575000000006,1.8036238725755029,1805768,1803892,null,2013,84.800299999999993,1.7772550243340248,1780336]
[null,null,"2014 to 2015",90.947599999999994,1.3789065558881863,1873833,1877255,null,2014,86.272800000000004,1.7364325362056632,1863008]
[null,null,"2015 to 2016",91.68972500000001,0.81599184585411344,1936795,1935573,null,2015,86.844499999999996,0.66266540555075615,1919641]
[null,null,"2016 to 2017",93.958875000000006,2.4748138354652021,2016681,2017027,null,2016,88.709599999999995,2.1476316865201577,1994712]
[null,null,"2017 to 2018",95.61330000000001,1.7607969444078628,2082483,2084541,null,2017,90.430300000000003,1.9396998746471723,2068757]
[null,null,"2018 to 2019",97.835624999999993,2.3242843830303768,2163750,2162725,null,2018,92.464299999999994,2.2492461044583414,2141792]
[null,null,"2019 to 2020",100,2.2122565272108261,2224077,2220063,null,2019,94.42,2.115086579360907,2217787]
[null,null,"2020 to 2021",{"$f":"(D75*(E76/100))+D75","v":107.06207744997673},7.0620774499767336,2096667,2101287,null,2020,100,5.9097648803219638,2113045]
[null,null,"2021 to 2022","-",-1.6131794020483814,2264458,2264721,null,2021,"-",1.0714247463231352,2223861]
[null,null,"2022 to 2023 ","-",-0.1400071535525349,2374916,2374606,null,2022,"-",-1.4016103775454258,2353633]
[null,null,"2023 to 2024","-",2.0253010553602513,2459209,2459163,null,2023,"-",1.7494375053867195,2436377]
[null,null,"2024 to 2025","-",2.0874678970417504,2551731,2551725,null,2024,"-",2.1455148537080415,2527724]

{"sheet":"A2 Discount","index":15,"n_rows":135,"n_cols":7,"rows_kept":135,"cut":false,"hidden":false,"merged":[[4,2,4,9],[7,3,7,4],[7,5,7,6],[7,2,8,2]]}
[]
[null,null,"A2: HM Treasury discount factors"]
[]
[null,null,"The information below is taken from the Green Book supplementary guidance"]
[null,null,"Discounting is the process by which future costs and benefits are recalculated to present-day values. It is a technique used to compare costs and benefits occurring in different time periods based on the economic principle that society prefers to receive benefits sooner and defer costs to future generations (‘social time preference’). All future costs and benefits are discounted in standard economic evaluations. The standard real discount rate, recommended by the Treasury, is 3.5%. For intangible costs, such as QALYs, we use 1.5% rate as recommended by DH and the Treasury."]
[]
[]
[null,null,"Year","Standard discount factors",null,"Health discount factors (for QALYs)"]
[null,null,null,"Discount \nRate","Discount \nFactor","Discount \nRate","Discount \nFactor"]
[null,null,0,null,1,null,1]
[null,null,1,3.5000000000000003E-2,0.96618357487922713,1.4999999999999999E-2,0.98522167487684742]
[null,null,2,3.5000000000000003E-2,0.93351070036640305,1.4999999999999999E-2,0.97066174864714039]
[null,null,3,3.5000000000000003E-2,0.90194270566802237,1.4999999999999999E-2,0.95631699374102508]
[null,null,4,3.5000000000000003E-2,0.87144222769857238,1.4999999999999999E-2,0.94218423028672427]
[null,null,5,3.5000000000000003E-2,0.84197316685852408,1.4999999999999999E-2,0.92826032540563974]
[null,null,6,3.5000000000000003E-2,0.81350064430775282,1.4999999999999999E-2,0.91454219251787172]
[null,null,7,3.5000000000000003E-2,0.78599096068381924,1.4999999999999999E-2,0.90102679065800173]
[null,null,8,3.5000000000000003E-2,0.75941155621625056,1.4999999999999999E-2,0.88771112380098705]
[null,null,9,3.5000000000000003E-2,0.73373097218961414,1.4999999999999999E-2,0.87459224019801685]
[null,null,10,3.5000000000000003E-2,0.70891881370977217,1.4999999999999999E-2,0.86166723172218418]
[null,null,11,3.5000000000000003E-2,0.68494571372924851,1.4999999999999999E-2,0.84893323322382686]
[null,null,12,3.5000000000000003E-2,0.66178329828912907,1.4999999999999999E-2,0.83638742189539594]
[null,null,13,3.5000000000000003E-2,0.63940415293635666,1.4999999999999999E-2,0.82402701664571032]
[null,null,14,3.5000000000000003E-2,0.61778179027667313,1.4999999999999999E-2,0.81184927748345848]
[null,null,15,3.5000000000000003E-2,0.59689061862480497,1.4999999999999999E-2,0.79985150490981138]
[null,null,16,3.5000000000000003E-2,0.57670591171478747,1.4999999999999999E-2,0.78803103932001128]
[null,null,17,3.5000000000000003E-2,0.55720377943457733,1.4999999999999999E-2,0.77638526041380429]
[null,null,18,3.5000000000000003E-2,0.53836113955031628,1.4999999999999999E-2,0.76491158661458558]
[null,null,19,3.5000000000000003E-2,0.520155690386779,1.4999999999999999E-2,0.75360747449712873]
[null,null,20,3.5000000000000003E-2,0.50256588443167061,1.4999999999999999E-2,0.74247041822377224]
[null,null,21,3.5000000000000003E-2,0.48557090283253201,1.4999999999999999E-2,0.73149794898893827]
[null,null,22,3.5000000000000003E-2,0.46915063075606961,1.4999999999999999E-2,0.72068763447186046]
[null,null,23,3.5000000000000003E-2,0.45328563358074364,1.4999999999999999E-2,0.71003707829739948]
[null,null,24,3.5000000000000003E-2,0.43795713389443836,1.4999999999999999E-2,0.69954391950482719]
[null,null,25,3.5000000000000003E-2,0.42314698926998878,1.4999999999999999E-2,0.6892058320244604]
[null,null,26,3.5000000000000003E-2,0.40883767079225974,1.4999999999999999E-2,0.67902052416202996]
[null,null,27,3.5000000000000003E-2,0.39501224231136212,1.4999999999999999E-2,0.66898573809066997]
[null,null,28,3.5000000000000003E-2,0.38165434039745133,1.4999999999999999E-2,0.65909924935041386]
[null,null,29,3.5000000000000003E-2,0.36874815497338298,1.4999999999999999E-2,0.64935886635508766]
[null,null,30,3.5000000000000003E-2,0.35627841060230242,1.4999999999999999E-2,0.63976242990649035]
[null,null,31,0.03,0.34590136951679845,1.2857142857142853E-2,0.63164132712911603]
[null,null,32,0.03,0.33582657234640628,1.2857142857142853E-2,0.62362331310349961]
[null,null,33,0.03,0.32604521587029733,1.2857142857142853E-2,0.61570707922771473]
[null,null,34,0.03,0.31654875327213333,1.2857142857142853E-2,0.60789133351114288]
[null,null,35,0.03,0.30732888667197411,1.2857142857142853E-2,0.60017480036361071]
[null,null,36,0.03,0.29837755987570302,1.2857142857142853E-2,0.59255622038720379]
[null,null,37,0.03,0.28968695133563399,1.2857142857142853E-2,0.58503435017072303]
[null,null,38,0.03,0.28124946731614953,1.2857142857142853E-2,0.57760796208675047]
[null,null,39,0.03,0.2730577352583976,1.2857142857142853E-2,0.57027584409129095]
[null,null,40,0.03,0.26510459733825009,1.2857142857142853E-2,0.5630367995259572]
[null,null,41,0.03,0.25738310421189331,1.2857142857142853E-2,0.55588964692266574]
[null,null,42,0.03,0.24988650894358574,1.2857142857142853E-2,0.54883321981081246]
[null,null,43,0.03,0.24260826111027742,1.2857142857142853E-2,0.54186636652689524]
[null,null,44,0.03,0.23554200107793924,1.2857142857142853E-2,0.53498795002655386]
[null,null,45,0.03,0.2286815544446012,1.2857142857142853E-2,0.52819684769899533]
[null,null,46,0.03,0.22202092664524387,1.2857142857142853E-2,0.52149195118377534]
[null,null,47,0.03,0.215554297713829,1.2857142857142853E-2,0.51487216618990506]
[null,null,48,0.03,0.20927601719789224,1.2857142857142853E-2,0.50833641231725457]
[null,null,49,0.03,0.20318059922125459,1.2857142857142853E-2,0.50188362288022315]
[null,null,50,0.03,0.19726271769053844,1.2857142857142853E-2,0.49551274473364765]
[null,null,51,0.03,0.19151720164129946,1.2857142857142853E-2,0.48922273810092148]
[null,null,52,0.03,0.18593903071970821,1.2857142857142853E-2,0.48301257640429479]
[null,null,53,0.03,0.18052333079583321,1.2857142857142853E-2,0.47688124609732913]
[null,null,54,0.03,0.17526536970469245,1.2857142857142853E-2,0.47082774649947867]
[null,null,55,0.03,0.17016055311135189,1.2857142857142853E-2,0.46485108963277161]
[null,null,56,0.03,0.16520442049645814,1.2857142857142853E-2,0.45895030006056431]
[null,null,57,0.03,0.16039264125869723,1.2857142857142853E-2,0.45312441472834275]
[null,null,58,0.03,0.15572101093077401,1.2857142857142853E-2,0.44737248280654429]
[null,null,59,0.03,0.15118544750560584,1.2857142857142853E-2,0.44169356553537514]
[null,null,60,0.03,0.14678198786952024,1.2857142857142853E-2,0.43608673607159743]
[null,null,61,0.03,0.14250678433934003,1.2857142857142853E-2,0.43055107933726117]
[null,null,62,0.03,0.13835610130033013,1.2857142857142853E-2,0.42508569187035655]
[null,null,63,0.03,0.13432631194206809,1.2857142857142853E-2,0.41968968167736187]
[null,null,64,0.03,0.1304138950893865,1.2857142857142853E-2,0.4143621680876633]
[null,null,65,0.03,0.12661543212561796,1.2857142857142853E-2,0.4091022816098227]
[null,null,66,0.03,0.12292760400545433,1.2857142857142853E-2,0.40390916378966979]
[null,null,67,0.03,0.11934718835481002,1.2857142857142853E-2,0.39878196707019581]
[null,null,68,0.03,0.11587105665515536,1.2857142857142853E-2,0.39371985465322573]
[null,null,69,0.03,0.11249617150985958,1.2857142857142853E-2,0.38872200036284627]
[null,null,70,0.03,0.10921958399015493,1.2857142857142853E-2,0.38378758851056755]
[null,null,71,0.03,0.10603843105840284,1.2857142857142853E-2,0.37891581376219641]
[null,null,72,0.03,0.10294993306641052,1.2857142857142853E-2,0.3741058810063998]
[null,null,73,0.03,9.9951391326612155E-2,1.2857142857142853E-2,0.36935700522493631]
[null,null,74,0.03,9.7040185753992383E-2,1.2857142857142853E-2,0.36466841136453515]
[null,null,75,0.03,9.4213772576691626E-2,1.2857142857142853E-2,0.36003933421040141]
[null,null,76,2.5000000000000001E-2,9.1915875684577208E-2,1.0714285714285711E-2,0.35622266282301202]
[null,null,77,2.5000000000000001E-2,8.9674025058124107E-2,1.0714285714285711E-2,0.35244645084962323]
[null,null,78,2.5000000000000001E-2,8.7486853715243035E-2,1.0714285714285711E-2,0.3487102693918534]
[null,null,79,2.5000000000000001E-2,8.5353028014871254E-2,1.0714285714285711E-2,0.34501369409794685]
[null,null,80,2.5000000000000001E-2,8.3271246843776847E-2,1.0714285714285711E-2,0.34135630511457643]
[null,null,81,2.5000000000000001E-2,8.1240240823196933E-2,1.0714285714285711E-2,0.33773768703915691]
[null,null,82,2.5000000000000001E-2,7.9258771534826286E-2,1.0714285714285711E-2,0.33415742887266409]
[null,null,83,2.5000000000000001E-2,7.7325630765684189E-2,1.0714285714285711E-2,0.33061512397295389]
[null,null,84,2.5000000000000001E-2,7.5439639771399211E-2,1.0714285714285711E-2,0.32711037000857629]
[null,null,85,2.5000000000000001E-2,7.3599648557462649E-2,1.0714285714285711E-2,0.32364276891307903]
[null,null,86,2.5000000000000001E-2,7.1804535178012344E-2,1.0714285714285711E-2,0.32021192683979549]
[null,null,87,2.5000000000000001E-2,7.0053205051719372E-2,1.0714285714285711E-2,0.31681745411711215]
[null,null,88,2.5000000000000001E-2,6.8344590294360366E-2,1.0714285714285711E-2,0.31345896520420991]
[null,null,89,2.5000000000000001E-2,6.6677649067668654E-2,1.0714285714285711E-2,0.31013607864727483]
[null,null,90,2.5000000000000001E-2,6.5051364944066992E-2,1.0714285714285711E-2,0.30684841703617299]
[null,null,91,2.5000000000000001E-2,6.3464746286894635E-2,1.0714285714285711E-2,0.30359560696158461]
[null,null,92,2.5000000000000001E-2,6.1916825645750871E-2,1.0714285714285711E-2,0.30037727897259253]
[null,null,93,2.5000000000000001E-2,6.0406659166586218E-2,1.0714285714285711E-2,0.29719306753472052]
[null,null,94,2.5000000000000001E-2,5.8933326016181682E-2,1.0714285714285711E-2,0.29404261098841605]
[null,null,95,2.5000000000000001E-2,5.7495927820665059E-2,1.0714285714285711E-2,0.2909255515079735]
[null,null,96,2.5000000000000001E-2,5.6093588117722012E-2,1.0714285714285711E-2,0.28784153506089249]
[null,null,97,2.5000000000000001E-2,5.4725451822167821E-2,1.0714285714285711E-2,0.28479021136766752]
[null,null,98,2.5000000000000001E-2,5.3390684704553978E-2,1.0714285714285711E-2,0.2817712338620032]
[null,null,99,2.5000000000000001E-2,5.2088472882491688E-2,1.0714285714285711E-2,0.27878425965145193]
[null,null,100,2.5000000000000001E-2,5.0818022324382137E-2,1.0714285714285711E-2,0.27582894947846837]
[null,null,101,2.5000000000000001E-2,4.9578558365250866E-2,1.0714285714285711E-2,0.27290496768187683]
[null,null,102,2.5000000000000001E-2,4.8369325234391095E-2,1.0714285714285711E-2,0.27001198215874739]
[null,null,103,2.5000000000000001E-2,4.7189585594527898E-2,1.0714285714285711E-2,0.26714966432667586]
[null,null,104,2.5000000000000001E-2,4.6038620092222343E-2,1.0714285714285711E-2,0.26431768908646375]
[null,null,105,2.5000000000000001E-2,4.4915726919241311E-2,1.0714285714285711E-2,0.2615157347851938]
[null,null,106,2.5000000000000001E-2,4.3820221384625671E-2,1.0714285714285711E-2,0.25874348317969703]
[null,null,107,2.5000000000000001E-2,4.2751435497195782E-2,1.0714285714285711E-2,0.25600061940040697]
[null,null,108,2.5000000000000001E-2,4.1708717558239794E-2,1.0714285714285711E-2,0.25328683191559703]
[null,null,109,2.5000000000000001E-2,4.0691431764136386E-2,1.0714285714285711E-2,0.25060181249599706]
[null,null,110,2.5000000000000001E-2,3.9698957818669646E-2,1.0714285714285711E-2,0.24794525617978508]
[null,null,111,2.5000000000000001E-2,3.8730690554799656E-2,1.0714285714285711E-2,0.24531686123794991]
[null,null,112,2.5000000000000001E-2,3.7786039565658201E-2,1.0714285714285711E-2,0.24271632914002111]
[null,null,113,2.5000000000000001E-2,3.6864428844544592E-2,1.0714285714285711E-2,0.24014336452016224]
[null,null,114,2.5000000000000001E-2,3.596529643370204E-2,1.0714285714285711E-2,0.23759767514362343]
[null,null,115,2.5000000000000001E-2,3.5088094081660533E-2,1.0714285714285711E-2,0.2350789718735497]
[null,null,116,2.5000000000000001E-2,3.4232286908937107E-2,1.0714285714285711E-2,0.23258696863814105]
[null,null,117,2.5000000000000001E-2,3.3397353081889861E-2,1.0714285714285711E-2,0.23012138239816077]
[null,null,118,2.5000000000000001E-2,3.2582783494526694E-2,1.0714285714285711E-2,0.22768193311478804]
[null,null,119,2.5000000000000001E-2,3.1788081458074824E-2,1.0714285714285711E-2,0.22526834371781149]
[null,null,120,2.5000000000000001E-2,3.1012762398121781E-2,1.0714285714285711E-2,0.22288034007415977]
[null,null,121,2.5000000000000001E-2,3.0256353559143204E-2,1.0714285714285711E-2,0.22051765095676587]
[null,null,122,2.5000000000000001E-2,2.9518393716237275E-2,1.0714285714285711E-2,0.21818000801376131]
[null,null,123,2.5000000000000001E-2,2.8798432893890027E-2,1.0714285714285711E-2,0.21586714573799706]
[null,null,124,2.5000000000000001E-2,2.809603209160003E-2,1.0714285714285711E-2,0.21357880143688757]
[null,null,125,2.5000000000000001E-2,2.7410763016195154E-2,1.0714285714285711E-2,0.21131471520257428]

{"sheet":"A3 Market forces","index":16,"n_rows":140,"n_cols":5,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"A3: Market forces factor (MFF)"]
[null,null,"The MFF estimates the unavoidable cost differences across the country of providing healthcare."]
[null,null,"It can be applied to national cost averages to be more locally relevant."]
[null,null,"Source: PHE's value for money team (alcohol, drugs, tobacco and justice division)."]
[]
[null,null,"UTLA code","UTLA Name","MFF Index"]
[null,null,"E06000002","Middlesbrough",0.94602896339852005]
[null,null,"E06000003","Redcar and Cleveland",0.94602896339852005]
[null,null,"E06000005","Darlington",0.94501951569228204]
[null,null,"E06000006","Halton",0.96137313516883305]
[null,null,"E06000007","Warrington",0.96427977706594004]
[null,null,"E06000009","Blackpool",0.94463220573800699]
[null,null,"E06000010","Kingston upon Hull, City of",0.93375655539517499]
[null,null,"E06000012","North East Lincolnshire",0.94199399346357304]
[null,null,"E06000013","North Lincolnshire",0.94188354849929001]
[null,null,"E06000015","Derby",0.95537149425509704]
[null,null,"E06000016","Leicester",0.95973065850762795]
[null,null,"E06000017","Rutland",0.96128040833921402]
[null,null,"E06000018","Nottingham",0.95558637109450795]
[null,null,"E06000019","Herefordshire, County of",0.94418968090255795]
[null,null,"E06000020","Telford and Wrekin",0.94419521625213498]
[null,null,"E06000022","Bath and North East Somerset",0.99376732789510502]
[null,null,"E06000026","Plymouth",0.93763651712909402]
[null,null,"E06000027","Torbay",0.93282786382582195]
[null,null,"E06000030","Swindon",1.0064058357252601]
[null,null,"E06000031","Peterborough",0.98700345541420598]
[null,null,"E06000032","Luton",1.03359757553224]
[null,null,"E06000033","Southend-on-Sea",0.99720691219693602]
[null,null,"E06000034","Thurrock",1.0378693185582599]
[null,null,"E06000035","Medway",1.02055029053438]
[null,null,"E06000042","Milton Keynes",1.01730367333167]
[null,null,"E06000043","Brighton and Hove",0.99245728097493802]
[null,null,"E06000044","Portsmouth",1.0014862145315799]
[null,null,"E06000045","Southampton",1.0003920966022699]
[null,null,"E06000047","County Durham",0.94484941400205003]
[null,null,"E06000049","Cheshire East",0.96217242430710903]
[null,null,"E06000050","Cheshire West and Chester",0.95812392289416004]
[null,null,"E06000051","Shropshire",0.94519873832827495]
[null,null,"E06000052","Cornwall",0.92554091758505896]
[null,null,"E06000053","Isles of Scilly",0.92554091758505896]
[null,null,"E06000054","Wiltshire",0.99378527049279297]
[null,null,"E06000055","Bedford",1.01753880768115]
[null,null,"E06000056","Central Bedfordshire",1.01753880768115]
[null,null,"E06000057","Northumberland",0.94797966129793398]
[null,null,"E06000058","Bournemouth, Christchurch and Poole",0.97600617476356399]
[null,null,"E06000059","Dorset",0.97600617476356399]
[null,null,"E06000060","Buckinghamshire",1.01730367333167]
[null,null,"E08000001","Bolton",0.963604908013178]
[null,null,"E08000002","Bury",0.96503228312727996]
[null,null,"E08000003","Manchester",0.97024720625258098]
[null,null,"E08000004","Oldham",0.96482682660961305]
[null,null,"E08000005","Rochdale",0.96441231277567696]
[null,null,"E08000006","Salford",0.96949614599382306]
[null,null,"E08000007","Stockport",0.97160623016013603]
[null,null,"E08000008","Tameside",0.96782447818070105]
[null,null,"E08000009","Trafford",0.97208386146189396]
[null,null,"E08000010","Wigan",0.95904420769327403]
[null,null,"E08000011","Knowsley",0.95732072573327698]
[null,null,"E08000012","Liverpool",0.95713893936266403]
[null,null,"E08000013","St. Helens",0.95882826316856595]
[null,null,"E08000014","Sefton",0.954215295028222]
[null,null,"E08000015","Wirral",0.95500644195796203]
[null,null,"E08000016","Barnsley",0.94857126169747297]
[null,null,"E08000017","Doncaster",0.95168553923529697]
[null,null,"E08000018","Rotherham",0.94501966112674496]
[null,null,"E08000019","Sheffield",0.94657902129653404]
[null,null,"E08000021","Newcastle upon Tyne",0.949469495768553]
[null,null,"E08000022","North Tyneside",0.948691670558927]
[null,null,"E08000023","South Tyneside",0.94614000099932305]
[null,null,"E08000024","Sunderland",0.94394364722116497]
[null,null,"E08000025","Birmingham",0.95701760150835602]
[null,null,"E08000026","Coventry",0.97301024409904902]
[null,null,"E08000027","Dudley",0.95254466104698399]
[null,null,"E08000028","Sandwell",0.95701760150835602]
[null,null,"E08000030","Walsall",0.95185972680825504]
[null,null,"E08000031","Wolverhampton",0.95119841501512103]
[null,null,"E08000032","Bradford",0.95010270274814301]
[null,null,"E08000033","Calderdale",0.95506847996266098]
[null,null,"E08000034","Kirklees",0.95575087736682396]
[null,null,"E08000036","Wakefield",0.95623511432302399]
[null,null,"E08000037","Gateshead",0.949469495768553]
[null,null,"E09000001","City of London",1.11650035090021]
[null,null,"E09000002","Barking and Dagenham",1.0877865617700899]
[null,null,"E09000003","Barnet",1.1244755285147501]
[null,null,"E09000004","Bexley",1.10198923913545]
[null,null,"E09000005","Brent",1.1155687404655801]
[null,null,"E09000006","Bromley",1.1161087445007301]
[null,null,"E09000007","Camden",1.15030311752612]
[null,null,"E09000008","Croydon",1.1091894519691201]
[null,null,"E09000009","Ealing",1.1161366414893701]
[null,null,"E09000010","Enfield",1.11520329924982]
[null,null,"E09000011","Greenwich",1.1128770777658901]
[null,null,"E09000012","Hackney",1.11650035090021]
[null,null,"E09000013","Hammersmith and Fulham",1.1398746202143599]
[null,null,"E09000014","Haringey",1.1178290941611899]
[null,null,"E09000015","Harrow",1.1053004588017099]
[null,null,"E09000016","Havering",1.0810245397535401]
[null,null,"E09000017","Hillingdon",1.09493786109192]
[null,null,"E09000018","Hounslow",1.1348004141580601]
[null,null,"E09000019","Islington",1.14488498294452]
[null,null,"E09000020","Kensington and Chelsea",1.1413565399622601]
[null,null,"E09000021","Kingston upon Thames",1.1093299310475899]
[null,null,"E09000022","Lambeth",1.13901134396673]
[null,null,"E09000023","Lewisham",1.11828269999547]
[null,null,"E09000024","Merton",1.1101022521222501]
[null,null,"E09000025","Newham",1.1148441264621101]
[null,null,"E09000026","Redbridge",1.09640116678609]
[null,null,"E09000027","Richmond upon Thames",1.1231726097235699]
[null,null,"E09000028","Southwark",1.1417909271797699]
[null,null,"E09000029","Sutton",1.09913320942542]
[null,null,"E09000030","Tower Hamlets",1.11683641510821]
[null,null,"E09000031","Waltham Forest",1.1142840671966701]
[null,null,"E09000032","Wandsworth",1.12226899048458]
[null,null,"E09000033","Westminster",1.1449582385441199]
[null,null,"E10000003","Cambridgeshire",0.98700345541420598]
[null,null,"E10000006","Cumbria",0.94722536220106801]
[null,null,"E10000007","Derbyshire",0.95515417890134302]
[null,null,"E10000008","Devon",0.93523219047745798]
[null,null,"E10000011","East Sussex",0.97961872150322604]
[null,null,"E10000012","Essex",1.0155922870587999]
[null,null,"E10000013","Gloucestershire",0.973878936489463]
[null,null,"E10000014","Hampshire",1.0218402429347699]
[null,null,"E10000015","Hertfordshire",1.04171949463015]
[null,null,"E10000016","Kent",0.99788684072334199]
[null,null,"E10000017","Lancashire",0.95102954238511495]
[null,null,"E10000018","Leicestershire",0.960545893893479]
[null,null,"E10000019","Lincolnshire",0.94365222153155204]
[null,null,"E10000020","Norfolk",0.93876140098959704]
[null,null,"E10000021","Northamptonshire",0.97741982191134702]
[null,null,"E10000023","North Yorkshire",0.94947162392014495]
[null,null,"E10000024","Nottinghamshire",0.95283922143608502]
[null,null,"E10000025","Oxfordshire",1.0104854395204701]
[null,null,"E10000027","Somerset",0.95558025627107002]
[null,null,"E10000028","Staffordshire",0.95083529755389795]
[null,null,"E10000029","Suffolk",0.95588599498544002]
[null,null,"E10000030","Surrey",1.0755600621952599]
[null,null,"E10000031","Warwickshire",0.97038848396801003]
[null,null,"E10000032","West Sussex",1.0205664223965101]
[null,null,"E10000034","Worcestershire",0.95501831534270498]

{"sheet":"Kinship carers calcs","index":17,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[[14,3,15,3]]}
["Kinship Carers"]
["https://www.frg.org.uk/images/e-publications/Kinship_carers_survey_analysis.pdf"]
[]
[null,"Number of children raised by kinship carer's (UK)",180000]
[null,"The survey was completed by 845 kinship carers who are raising at least 1252 kinship children."]
[null,"UK kids: carers",{"$f":"845/1252","v":0.67492012779552712}]
[null,"740 (88%) kinship carers live in England"]
[null,"England kids: carers",{"$f":"C6*0.88","v":0.59392971246006387}]
[null,"Number of kinship carers",1]
[null,"Gave up work to be fulltime kinship carer, %",0.44,"Table 15"]
[null,"Gave up work to be fulltime kinship carer, n",{"$f":"C9*C10","v":0.44}]
[null,"Reason kinship child cannot live with parent: Parental misuse, %",0.46,"Table 20"]
[null,"Reason kinship child cannot live with parent: Parental misuse, n",{"$f":"C11*C12","v":0.2024}]
[]
[null,"Duration of care, annually (hours)",226,"Same approach as Copello et al for lost carer employment opportunities / reduction in productivity. Duration is an estimate of the number of hours spent (the opportunity cost) of caring."]
[null,"Minimum wage",14.92]
[]
[null,"Total 'Indirect' Cost",{"$f":"C13*C15*C16","v":682.47660799999994}]
[null,"Total 'Indirect' Cost (Rounded)",{"$f":"ROUND(C18,-6)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["https://www.theguardian.com/society/2019/sep/23/kinship-carers-left-with-debt-and-ill-health-for-doing-the-right-thing"]

{"sheet":"Perinatal MH QALY calcs","index":18,"n_rows":86,"n_cols":27,"rows_kept":86,"cut":false,"hidden":true,"merged":[[2,8,2,9],[2,10,2,11],[3,10,3,11],[3,8,3,9],[3,13,3,14],[2,13,2,14],[2,25,2,26],[3,25,3,26],[3,21,3,22],[3,23,3,24],[1,13,1,18],[1,21,1,24],[2,21,2,22],[2,23,2,24],[2,17,2,18],[3,17,3,18],[2,15,2,16],[3,15,3,16],[2,19,2,20],[3,19,3,20]]}
[]
[null,"Discount default 0-30 years",3.5000000000000003E-2,1.4999999999999999E-2,null,null,null,null,null,null,null,null,null,"Perinatal depression",null,null,null,null,null,null,null,"Perinatal anxiety"]
[null,"Discount default 31-50 years",{"$f":"3%","v":0.03},0.01,null,null,null,null,"Perinatal lifetime depression (10 years - 1 QALY = £25k)",null,"Perinatal lifetime anxiety (10 years - 1 QALY = £25k)",null,null,"Pre birth costs (aged 5-18; 13 years)",null,"Infant death costs (0-18)",null,"Emotional problems costs (0-76)",null,"Conduct disorder costs (0-76)",null,"Pre birth costs (aged 5-18; 13 years)",null,"Emotional problems costs (0-76)",null,"Conduct disorder costs (0-76)"]
[null,null,null,null,null,null,"Direct","Indirect","Intangible",null,"Intangible",null,null,"Intangible",null,"Intangible",null,"Intangible",null,"Intangible",null,"Intangible",null,"Intangible",null,"Intangible"]
[null,"Year","Multiplier","QALY multiplier",null,null,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,1.4999999999999999E-2,3.5000000000000003E-2,1.4999999999999999E-2,null,3.5000000000000003E-2,1.4999999999999999E-2,3.5000000000000003E-2,1.4999999999999999E-2,3.5000000000000003E-2,1.4999999999999999E-2,3.5000000000000003E-2,1.4999999999999999E-2,3.5000000000000003E-2,1.4999999999999999E-2,3.5000000000000003E-2,1.4999999999999999E-2,3.5000000000000003E-2,1.4999999999999999E-2]
[null,0,{"$f":"'A2 Discount'!E10","v":1},{"$f":"'A2 Discount'!G10","v":1},null,null,{"$f":"C6/C7*G7","v":2381.0907079284525},{"$f":"C6/C7*H7","v":3546.2452842014982},{"$f":"C6/C7*I7","v":25613.652295358312},{"$f":"I6","v":25613.652295358312},{"$f":"C6/C7*K7","v":15481.321397816804},{"$f":"K6","v":15481.321397816804},null,{"$f":"C6/C7*N7","v":653.7336332277556},{"$f":"D6/D7*O7","v":1568.960719746613},{"$f":"$C6/$C7*P7","v":41156.388105031823},{"$f":"$D6/$D7*Q7","v":98775.331452076338},{"$f":"C6/C7*R7","v":50143.677201275488},{"$f":"$D6/$D7*S7","v":120344.82528306115},{"$f":"C6/C7*T7","v":36946.827462688561},{"$f":"$D6/$D7*U7","v":88672.385910452518},{"$f":"$C6/$C7*V7","v":1632.7701270090363},{"$f":"$D6/$D7*W7","v":3918.6483048216865},{"$f":"$C6/$C7*X7","v":5820.5396621137716},{"$f":"$D6/$D7*Y7","v":13969.295189073046},{"$f":"C6/C7*Z7","v":22901.375679905599},{"$f":"$D6/$D7*AA7","v":54963.301631773436}]
[null,1,{"$f":"'A2 Discount'!E11","v":0.96618357487922713},{"$f":"'A2 Discount'!G11","v":0.98522167487684742},null,null,{"$f":"C7/C8*G8","v":2300.570732298022},3426.3239460884042,24747.490140442816,{"$f":"$J$6*D7","v":25235.125414146125},{"$f":"C7/C8*K8","v":14957.798451996914},{"$f":"$J$6*D7","v":25235.125414146125},null,{"$f":"C7/C8*N8","v":631.62669877077838},1545.774108124742,{"$f":"C7/C8*P8","v":39764.626188436545},{"$f":"D7/D8*Q8","v":97315.597489730397},{"$f":"C7/C8*R8","v":48447.997295918351},{"$f":"D7/D8*S8","v":118566.33032813907},35697.417838346439,{"$f":"D7/D8*U8","v":87361.956562022198},{"$f":"$C7/$C8*V8","v":1577.5556782696003},{"$f":"$D7/$D8*W8","v":3860.7372461297409},{"$f":"$C7/$C8*X8","v":5623.7098184674123},13762.852403027633,{"$f":"C7/C8*Z8","v":22126.933024063383},54151.036090417183]
[null,2,{"$f":"'A2 Discount'!E12","v":0.93351070036640305},{"$f":"'A2 Discount'!G12","v":0.97066174864714039},null,null,2222.7736543942242,3310.4579189259948,23910.618493181468,24862.19252625234,14451.979180673348,24862.19252625234,null,{"$f":"C8/C9*N9","v":610.26734180751544},1522.9301557879232,38419.928684479753,95877.4359504733,46809.65922310952,116814.11854989071,34490.258781011056,86070.893164553898,1524.2083848015463,3803.6820158913706,5433.5360564902539,13559.460495593728,21378.679250302786,53350.774473317426]
[null,3,{"$f":"'A2 Discount'!E13","v":0.90194270566802237},{"$f":"'A2 Discount'!G13","v":0.95631699374102508},null,null,2147.6073955499751,3198.5100665951645,23102.046853315431,24494.770961824968,13963.264908863139,24494.770961824968,null,589.6302819396285,1500.4237988058358,37120.704042975609,94460.528030022964,45226.723887062341,115087.80152698593,33323.921527546918,84798.909521727983,1472.6651060884508,3747.4699663954393,5249.7932912949318,13359.074379895301,20655.728744253902,52562.33938257875]
[null,4,{"$f":"'A2 Discount'!E14","v":0.87144222769857238},{"$f":"'A2 Discount'!G14","v":0.94218423028672427},null,null,2074.9829908695415,3090.347890430111,22320.818215763702,24132.779272733958,13491.077206631053,24132.779272733958,null,569.69109366147688,1478.2500480845674,35865.414534275951,93064.559635490616,43697.317765277628,113386.99657831127,32197.025630480115,83545.723666727092,1422.8648368004356,3692.0886368427978,5072.2640495603209,13161.649635364829,19957.225839858846,51785.556041949509]
[null,5,{"$f":"'A2 Discount'!E15","v":0.84197316685852408},{"$f":"'A2 Discount'!G15","v":0.92826032540563974},null,null,2004.8144839319243,2985.8433723962426,21566.007937935945,23776.137214516217,13034.857204474449,23776.137214516217,null,{"$f":"C11/C12*N12","v":550.42617745070231},1456.4039882606578,34652.574429252127,91689.221315754316,42219.6306910895,111711.3266781392,31108.237324135378,82311.057799731134,1374.748634589793,3637.5257505840377,4900.7382121355758,12967.142497896384,19282.343806626905,51020.252258078341]
[null,6,{"$f":"'A2 Discount'!E16","v":0.81350064430775282},{"$f":"'A2 Discount'!G16","v":0.91454219251787172},null,null,1937.0188250549995,2884.8728235712492,20836.722645348742,23424.765728587408,12594.064931859371,23424.765728587408,null,531.81273183642736,1434.8807766114855,33480.748240823312,90334.208192861406,40791.913711197587,110060.42037255094,30056.267946024524,81094.638226336101,1328.2595503283026,3583.7692123980669,4735.0127653483833,12775.509850144223,18630.283871137108,50266.2583823432]
[null,7,{"$f":"'A2 Discount'!E17","v":0.78599096068381924},{"$f":"'A2 Discount'!G17","v":0.90102679065800173},null,null,1871.5157729999996,2787.3167377499994,20132.099174249994,23078.586924716659,12168.178678124998,23078.586924716659,null,513.8287264120072,1413.6756419817593,32348.549024950062,88999.219894444745,39412.477015649849,108433.91169709453,29039.8724116179,79896.19529688287,1283.3425607036741,3530.8071058109035,4574.8915607230756,12586.709211964753,18000.274271630056,49523.407273244535]
[null,8,{"$f":"'A2 Discount'!E18","v":0.75941155621625056},{"$f":"'A2 Discount'!G18","v":0.88771112380098705},null,null,1808.2277999999999,2693.0596499999997,19451.303549999997,22737.524063760258,11756.694374999999,22737.524063760258,null,496.45287576039351,1392.7838837258714,31254.636739082187,87683.960487137694,38079.687937825947,106831.44009565965,28057.847740693625,78715.463346682634,1239.9445030953373,3478.6276904540923,4420.1850828242277,12400.698730999758,17391.569344570104,48791.534259354223]
[null,9,{"$f":"'A2 Discount'!E19","v":0.73373097218961414},{"$f":"'A2 Discount'!G19","v":0.87459224019801685},null,null,{"$f":"C15/C16*G16","v":1747.08},{"$f":"C15/C16*H16","v":2601.9899999999998},18793.53,22401.501540650501,11359.125,22401.501540650501,null,479.66461426124982,1372.2008706658833,30197.716656118057,86388.138410973101,36791.969022054058,105252.65034055139,27109.031633520412,77552.180637125755,1198.0140126524998,3427.2193994621603,4270.7102249509453,12217.437173398777,16803.448642096719,48070.477102812045]
[null,10,{"$f":"'A2 Discount'!E20","v":0.70891881370977217},{"$f":"'A2 Discount'!G20","v":0.86166723172218418},null,null,{"$f":"1688","v":1688},{"$f":"2514","v":2514},{"$f":"18158","v":18158},22070.444867635964,10975,{"$f":"$L$6*D16","v":13339.74735225822},null,463.44407174999986,1351.9220400649097,29176.537831998125,85111.466414751834,35547.796156573975,103697.19245374523,26192.301095188806,76406.089297660845,1157.5014614999998,3376.5708369085328,4126.2900724163728,12036.883914678599,16235.216079320502,47360.075963361625]
[null,11,{"$f":"'A2 Discount'!E21","v":0.68494571372924851},{"$f":"'A2 Discount'!G21","v":0.84893323322382686},null,null,null,null,null,null,null,null,null,447.77204999999992,1331.9428966156747,28189.891625118962,83853.661492366344,34345.696769636692,102164.72162930566,25306.571106462616,75276.93526863138,1118.3588999999999,3326.6707752793432,3986.7536931559157,11858.998930717833,15686.199110454592,46660.173362917863]
[null,12,{"$f":"'A2 Discount'!E22","v":0.66178329828912907},{"$f":"'A2 Discount'!G22","v":0.83638742189539594},null,null,"2020/21",null,null,null,null,null,null,{"$f":"C18/C19*N19","v":432.62999999999994},1312.2590114440147,27236.610265815423,82614.444820065371,{"$f":"C18/C19*R19","v":33184.248086605505},100654.8981569514,24450.793339577409,74164.468244957025,1080.54,3277.5081529845747,3851.9359354163439,11683.742788884565,15155.747932806371,45970.614150657995]
[null,13,{"$f":"'A2 Discount'!E23","v":0.63940415293635666},{"$f":"'A2 Discount'!G23","v":0.82402701664571032},null,null,null,null,null,null,null,null,null,418,{"$f":"N6*$D19*60/25","v":1292.8660211271083},26315.565474217801,81393.541694645697,32062.075445995662,99167.387346750154,23623.954917466097,73068.441620647325,1044,{"$f":"V6*$D19*60/25","v":3229.0720719059855},3721.677232286323,11511.076639295139,14643.234717687315,45291.245468628571]
[null,14,{"$f":"'A2 Discount'!E24","v":0.61778179027667313},{"$f":"'A2 Discount'!G24","v":0.81184927748345848},null,null,{"$f":"G16*(_202021/_201213)","v":2050.8207643059868},3054.3622046595087,{"$f":"I16*60/25","v":43579.199999999997},52969.067682326313,{"$f":"K16*60/25","v":26340},{"$f":"L16*60/25","v":32015.393645419728},null,null,null,25425.667124848118,80190.681472557349,30977.850672459579,97701.859454926263,22825.077214943092,71988.612434135299,null,null,3595.8234128370273,11340.962206202108,14148.05286733074,44621.916717860666]
[null,15,{"$f":"'A2 Discount'!E25","v":0.59689061862480497},{"$f":"'A2 Discount'!G25","v":0.79985150490981138},null,null,null,null,null,null,null,null,null,null,null,24565.861956374996,79005.597509908723,29930.290504791865,96257.989610764795,22053.214700428111,70924.741314419021,null,null,3474.225519649302,11173.361779509467,13669.616296937915,43962.47952498588]
[null,16,{"$f":"'A2 Discount'!E26","v":0.57670591171478747},{"$f":"'A2 Discount'!G26","v":0.78803103932001128},null,null,"https://www.nwcscnsenate.nhs.uk/files/3914/7030/1256/Costs_of_perinatal_mh.pdf ",null,null,null,null,null,null,null,null,23735.132324999999,77838.027103358356,28918.15507709359,94835.457744595871,21307.453816838755,69876.592427999043,null,null,3356.7396325114032,11008.238206413269,13207.358741002818,43312.787709345699]
[null,17,{"$f":"'A2 Discount'!E27","v":0.55720377943457733},{"$f":"'A2 Discount'!G27","v":0.77638526041380429},null,null,null,null,null,null,null,null,null,null,null,22932.494999999999,76687.711431880161,27940.246451298157,{"$f":"D23/D24*S24","v":93433.948516843229},20586.911900327301,{"$f":"D23/D24*U24","v":68843.933426600051},null,null,3243.2266980786508,10845.554883165783,12760.73308309451,42672.697250586898]
[null,18,{"$f":"'A2 Discount'!E28","v":0.53836113955031628},{"$f":"'A2 Discount'!G28","v":0.76491158661458558},null,null,null,null,null,null,null,null,null,null,null,22157,{"$f":"P6*$D24*60/25","v":75554.395499389328},26995.407199321893,{"$f":"R6*D24*60/25","v":92053.151248121416},19890.736135581934,{"$f":"T6*D24*60/25","v":67826.53539566508},null,null,3133.5523652933825,{"$f":"X6*$D24*60/25","v":10685.275746961364},12329.210708303875,{"$f":"Z6*D24*60/25","v":42042.066256735867}]
[null,19,{"$f":"'A2 Discount'!E29","v":0.520155690386779},{"$f":"'A2 Discount'!G29","v":0.75360747449712873},null,null,null,null,null,null,null,null,null,null,null,null,null,26082.51903316125,null,19218.102546455975,null,null,null,3027.5868263704183,null,11912.280877588286]
[null,20,{"$f":"'A2 Discount'!E30","v":0.50256588443167061},{"$f":"'A2 Discount'!G30","v":0.74247041822377224},null,null,null,null,null,null,null,null,null,null,null,null,null,25200.501481315219,null,18568.215020730411,null,null,null,2925.2046631598246,null,11509.450123273708]
[null,21,{"$f":"'A2 Discount'!E31","v":0.48557090283253201},{"$f":"'A2 Discount'!G31","v":0.73149794898893827},null,null,null,null,null,null,null,null,null,null,null,null,null,24348.310609966396,null,17940.304367855471,null,null,null,2826.2846987051448,null,11120.241664998752]
[null,22,{"$f":"'A2 Discount'!E32","v":0.46915063075606961},{"$f":"'A2 Discount'!G32","v":0.72068763447186046},null,null,null,null,null,null,null,null,null,null,null,null,null,23524.937787407147,null,17333.627408556011,null,null,null,2730.7098538213963,null,10744.194845409424]
[null,23,{"$f":"'A2 Discount'!E33","v":0.45328563358074364},{"$f":"'A2 Discount'!G33","v":0.71003707829739948},null,null,null,null,null,null,null,null,null,null,null,null,null,22729.408490248454,null,16747.466095223201,null,null,null,2638.3670085230883,null,10380.864584936642]
[null,24,{"$f":"'A2 Discount'!E34","v":0.43795713389443836},{"$f":"'A2 Discount'!G34","v":0.69954391950482719},null,null,null,null,null,null,null,null,null,null,null,null,null,21960.781149998507,null,16181.126662051402,null,null,null,2549.1468681382498,null,10029.820855011249]
[null,25,{"$f":"'A2 Discount'!E35","v":0.42314698926998878},{"$f":"'A2 Discount'!G35","v":0.6892058320244604},null,null,null,null,null,null,null,null,null,null,null,null,null,21218.146038645904,null,15633.9388039144,null,null,null,2462.9438339500002,null,9690.6481690929941]
[null,26,{"$f":"'A2 Discount'!E36","v":0.40883767079225974},{"$f":"'A2 Discount'!G36","v":0.67902052416202996},null,null,null,null,null,null,null,null,null,null,null,null,null,20500.624191928411,null,15105.254883009084,null,null,null,2379.6558782125608,null,9362.9450909111056]
[null,27,{"$f":"'A2 Discount'!E37","v":0.39501224231136212},{"$f":"'A2 Discount'!G37","v":0.66898573809066997},null,null,null,null,null,null,null,null,null,null,null,null,null,19807.366369012958,null,14594.449162327619,null,null,null,2299.1844233937786,null,9046.323759334402]
[null,28,{"$f":"'A2 Discount'!E38","v":0.38165434039745133},{"$f":"'A2 Discount'!G38","v":0.65909924935041386},null,null,null,null,null,null,null,null,null,null,null,null,null,19137.552047355515,null,14100.91706505084,null,null,null,2221.4342255012357,null,8740.4094293086018]
[null,29,{"$f":"'A2 Discount'!E39","v":0.36874815497338298},{"$f":"'A2 Discount'!G39","v":0.64935886635508766},null,null,null,null,null,null,null,null,null,null,null,null,null,18490.388451551225,null,13624.074458986321,null,null,null,2146.313261353851,null,8444.8400283174906]
[null,30,{"$f":"'A2 Discount'!E40","v":0.35627841060230242},{"$f":"'A2 Discount'!G40","v":0.63976242990649035},null,null,null,null,null,null,null,null,null,null,null,null,null,17865.10961502534,null,13163.356965204175,null,null,null,2073.7326196655567,null,8159.2657278429861]
[null,31,{"$f":"'A2 Discount'!E41","v":0.34590136951679845},{"$f":"'A2 Discount'!G41","v":0.63164132712911603},null,null,null,null,null,null,null,null,null,null,null,null,null,17344.766616529454,null,12779.95821864483,null,null,null,2013.3326404519969,null,7921.6172114980445]
[null,32,{"$f":"'A2 Discount'!E42","v":0.33582657234640628},{"$f":"'A2 Discount'!G42","v":0.62362331310349961},null,null,null,null,null,null,null,null,null,null,null,null,null,16839.579239348983,null,12407.726425868766,null,null,null,1954.6918839339776,null,7690.8904966000428]
[null,33,{"$f":"'A2 Discount'!E43","v":0.32604521587029733},{"$f":"'A2 Discount'!G43","v":0.61570707922771473},null,null,null,null,null,null,null,null,null,null,null,null,null,16349.106057620371,null,12046.336335794918,null,null,null,1897.7591106155121,null,7466.8839772815945]
[null,34,{"$f":"'A2 Discount'!E44","v":0.31654875327213333},{"$f":"'A2 Discount'!G44","v":0.60789133351114288},null,null,null,null,null,null,null,null,null,null,null,null,null,15872.918502544049,null,11695.472170674677,null,null,null,1842.4845734131186,null,7249.4019196908685]
[null,35,{"$f":"'A2 Discount'!E45","v":0.30732888667197411},{"$f":"'A2 Discount'!G45","v":0.60017480036361071},null,null,null,null,null,null,null,null,null,null,null,null,null,15410.600487906844,null,11354.827350169589,null,null,null,1788.8199741874937,null,7038.2542909620079]
[null,36,{"$f":"'A2 Discount'!E46","v":0.29837755987570302},{"$f":"'A2 Discount'!G46","v":0.59255622038720379},null,null,null,null,null,null,null,null,null,null,null,null,null,14961.748046511499,null,11024.10422346562,null,null,null,1736.718421541256,null,6833.2565931669978]
[null,37,{"$f":"'A2 Discount'!E47","v":0.28968695133563399},{"$f":"'A2 Discount'!G47","v":0.58503435017072303},null,null,null,null,null,null,null,null,null,null,null,null,null,14525.968977195629,null,10703.013809189923,null,null,null,1686.1343898458797,null,6634.2297021038812]
[null,38,{"$f":"'A2 Discount'!E48","v":0.28124946731614953},{"$f":"'A2 Discount'!G48","v":0.57760796208675047},null,null,null,null,null,null,null,null,null,null,null,null,null,14102.882502131679,null,10391.275542902837,null,null,null,1637.0236794620191,null,6440.9997107804675]
[null,39,{"$f":"'A2 Discount'!E49","v":0.2730577352583976},{"$f":"'A2 Discount'!G49","v":0.57027584409129095},null,null,null,null,null,null,null,null,null,null,null,null,null,13692.118934108426,null,10088.617031944501,null,null,null,1589.3433781184651,null,6253.3977774567647]
[null,40,{"$f":"'A2 Discount'!E50","v":0.26510459733825009},{"$f":"'A2 Discount'!G50","v":0.5630367995259572},null,null,null,null,null,null,null,null,null,null,null,null,null,13293.319353503326,null,9794.7738174218448,null,null,null,1543.0518234159856,null,6071.259978113364]
[null,41,{"$f":"'A2 Discount'!E51","v":0.25738310421189331},{"$f":"'A2 Discount'!G51","v":0.55588964692266574},null,null,null,null,null,null,null,null,null,null,null,null,null,12906.135294663423,null,9509.4891431280048,null,null,null,1498.1085664232869,null,5894.4271632168584]
[null,42,{"$f":"'A2 Discount'!E52","v":0.24988650894358574},{"$f":"'A2 Discount'!G52","v":0.54883321981081246},null,null,null,null,null,null,null,null,null,null,null,null,null,12530.228441420799,null,9232.5137311922372,null,null,null,1454.4743363332882,null,5722.7448186571437]
[null,43,{"$f":"'A2 Discount'!E53","v":0.24260826111027742},{"$f":"'A2 Discount'!G53","v":0.54186636652689524},null,null,null,null,null,null,null,null,null,null,null,null,null,12165.270331476504,null,8963.6055642643078,null,null,null,1412.1110061488234,null,5556.062930735091]
[null,44,{"$f":"'A2 Discount'!E54","v":0.23554200107793924},{"$f":"'A2 Discount'!G54","v":0.53498795002655386},null,null,null,null,null,null,null,null,null,null,null,null,null,11810.942069394663,null,8702.5296740430167,null,null,null,1370.9815593677897,null,5394.235855082612]
[null,45,{"$f":"'A2 Discount'!E55","v":0.2286815544446012},{"$f":"'A2 Discount'!G55","v":0.52819684769899533},null,null,null,null,null,null,null,null,null,null,null,null,null,11466.934047955983,null,8449.0579359640942,null,null,null,1331.0500576386307,null,5237.1221894005939]
[null,46,{"$f":"'A2 Discount'!E56","v":0.22202092664524387},{"$f":"'A2 Discount'!G56","v":0.52149195118377534},null,null,null,null,null,null,null,null,null,null,null,null,null,11132.945677627167,null,8202.9688698680529,null,null,null,1292.2816093578938,null,5084.5846499034888]
[null,47,{"$f":"'A2 Discount'!E57","v":0.215554297713829},{"$f":"'A2 Discount'!G57","v":0.51487216618990506},null,null,null,null,null,null,null,null,null,null,null,null,null,10808.685123909871,null,7964.0474464738381,null,null,null,1254.6423391824212,null,4936.4899513626106]
[null,48,{"$f":"'A2 Discount'!E58","v":0.20927601719789224},{"$f":"'A2 Discount'!G58","v":0.50833641231725457},null,null,null,null,null,null,null,null,null,null,null,null,null,10493.86905233968,null,7732.084899489163,null,null,null,1218.0993584295352,null,4792.7086906433115]
[null,49,{"$f":"'A2 Discount'!E59","v":0.20318059922125459},{"$f":"'A2 Discount'!G59","v":0.50188362288022315},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C55/C56*R56","v":10188.22238091231},null,7506.878543193362,null,null,null,1182.6207363393546,null,4653.115233634283]
[null,50,{"$f":"'A2 Discount'!E60","v":0.19726271769053844},{"$f":"'A2 Discount'!G60","v":0.49551274473364765},null,null,null,null,null,null,null,null,null,null,null,null,null,9891.4780397206887,null,7288.2315953333609,null,null,null,1148.1754721741306,null,4517.5876054701776]
[null,51,{"$f":"'A2 Discount'!E61","v":0.19151720164129946},{"$f":"'A2 Discount'!G61","v":0.48922273810092148},null,null,null,null,null,null,null,null,null,null,null,null,null,9603.3767375929019,null,7075.9530051780202,null,null,null,1114.7334681302239,null,4386.007383951629]
[null,52,{"$f":"'A2 Discount'!E62","v":0.18593903071970821},{"$f":"'A2 Discount'!G62","v":0.48301257640429479},null,null,null,null,null,null,null,null,null,null,null,null,null,9323.6667355270893,null,6869.8572865806018,null,null,null,1082.2655030390522,null,4258.2595960695426]
[null,53,{"$f":"'A2 Discount'!E63","v":0.18052333079583321},{"$f":"'A2 Discount'!G63","v":0.47688124609732913},null,null,null,null,null,null,null,null,null,null,null,null,null,9052.1036267253294,null,6669.7643559034968,null,null,null,1050.7432068340313,null,4134.2326175432454]
[null,54,{"$f":"'A2 Discount'!E64","v":0.17526536970469245},{"$f":"'A2 Discount'!G64","v":0.47082774649947867},null,null,null,null,null,null,null,null,null,null,null,null,null,8788.4501230342994,null,6475.4993746635892,null,null,null,1020.1390357611954,null,4013.8180752847038]
[null,55,{"$f":"'A2 Discount'!E65","v":0.17016055311135189},{"$f":"'A2 Discount'!G65","v":0.46485108963277161},null,null,null,null,null,null,null,null,null,null,null,null,null,8532.4758476061161,null,6286.8925967607656,null,null,null,990.42624831184014,null,3896.9107527035958]
[null,56,{"$f":"'A2 Discount'!E66","v":0.16520442049645814},{"$f":"'A2 Discount'!G66","v":0.45895030006056431},null,null,null,null,null,null,null,null,null,null,null,null,null,8283.9571335981709,null,6103.7792201560833,null,null,null,961.57888185615548,null,3783.4084977704811]
[null,57,{"$f":"'A2 Discount'!E67","v":0.16039264125869723},{"$f":"'A2 Discount'!G67","v":0.45312441472834275},null,null,null,null,null,null,null,null,null,null,null,null,null,8042.6768287360874,null,5925.9992428699834,null,null,null,933.57172995743247,null,3673.2121337577487]
[null,58,{"$f":"'A2 Discount'!E68","v":0.15572101093077401},{"$f":"'A2 Discount'!G68","v":0.44737248280654429},null,null,null,null,null,null,null,null,null,null,null,null,null,7808.4241055690163,null,5753.3973231747414,null,null,null,906.38032034702178,null,3566.2253725803384]
[null,59,{"$f":"'A2 Discount'!E69","v":0.15118544750560584},{"$f":"'A2 Discount'!G69","v":0.44169356553537514},null,null,null,null,null,null,null,null,null,null,null,null,null,7580.9942772514723,null,5585.8226438589718,null,null,null,879.98089354079787,null,3462.3547306605228]
[null,60,{"$f":"'A2 Discount'!E70","v":0.14678198786952024},{"$f":"'A2 Discount'!G70","v":0.43608673607159743},null,null,null,null,null,null,null,null,null,null,null,null,null,7360.1886186907495,null,5423.1287804456033,null,null,null,854.35038207844445,null,3361.5094472432261]
[null,61,{"$f":"'A2 Discount'!E71","v":0.14250678433934003},{"$f":"'A2 Discount'!G71","v":0.43055107933726117},null,null,null,null,null,null,null,null,null,null,null,null,null,7145.8141929036401,null,5265.1735732481584,null,null,null,829.46639036742181,null,3263.6014050905105]
[null,62,{"$f":"'A2 Discount'!E72","v":0.13835610130033013},{"$f":"'A2 Discount'!G72","v":0.42508569187035655},null,null,null,null,null,null,null,null,null,null,null,null,null,6937.6836824307184,null,5111.8190031535514,null,null,null,805.30717511400178,null,3168.5450534859324]
[null,63,{"$f":"'A2 Discount'!E73","v":0.13432631194206809},{"$f":"'A2 Discount'!G73","v":0.41968968167736187},null,null,null,null,null,null,null,null,null,null,null,null,null,6735.6152256608912,null,4962.9310710228656,null,null,null,781.85162632427352,null,3076.2573334814879]
[null,64,{"$f":"'A2 Discount'!E74","v":0.1304138950893865},{"$f":"'A2 Discount'!G74","v":0.4143621680876633},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C70/C71*R71","v":6539.4322579231948},null,{"$f":"C70/C71*T71","v":4818.3796806047239},null,null,null,759.07924885851799,null,2986.6576053218328]
[null,65,{"$f":"'A2 Discount'!E75","v":0.12661543212561796},{"$f":"'A2 Discount'!G75","v":0.4091022816098227},null,null,null,null,null,null,null,null,null,null,null,null,null,6348.9633572069852,null,4678.0385248589555,null,null,null,{"$f":"$C71/$C72*X72","v":736.97014452283292},null,{"$f":"C71/C72*Z72","v":2899.6675779823618}]
[null,66,{"$f":"'A2 Discount'!E76","v":0.12292760400545433},{"$f":"'A2 Discount'!G76","v":0.40390916378966979},null,null,null,null,null,null,null,null,null,null,null,null,null,6164.0420943757135,null,4541.7849755912184,null,null,null,715.50499468236205,null,2815.2112407595746]
[null,67,{"$f":"'A2 Discount'!E77","v":0.11934718835481002},{"$f":"'A2 Discount'!G77","v":0.39878196707019581},null,null,null,null,null,null,null,null,null,null,null,null,null,5984.5068877434114,null,4409.4999763021533,null,null,null,694.66504338093398,null,2733.2147968539557]
[null,68,{"$f":"'A2 Discount'!E78","v":0.11587105665515536},{"$f":"'A2 Discount'!G78","v":0.39371985465322573},null,null,null,null,null,null,null,null,null,null,null,null,null,5810.2008618868067,null,4281.06793815743,null,null,null,674.43208095236309,null,2653.6065988873356]
[null,69,{"$f":"'A2 Discount'!E79","v":0.11249617150985958},{"$f":"'A2 Discount'!G79","v":0.38872200036284627},null,null,null,null,null,null,null,null,null,null,null,null,null,5640.9717105697155,null,4156.3766389877965,null,null,null,654.78842810909032,null,2576.3170862983839]
[null,70,{"$f":"'A2 Discount'!E80","v":0.10921958399015493},{"$f":"'A2 Discount'!G80","v":0.38378758851056755},null,null,null,null,null,null,null,null,null,null,null,null,null,5476.6715636599174,null,4035.3171252308703,null,null,null,635.71692049426247,null,2501.2787245615377]
[null,71,{"$f":"'A2 Discount'!E81","v":0.10603843105840284},{"$f":"'A2 Discount'!G81","v":0.37891581376219641},null,null,null,null,null,null,null,null,null,null,null,null,null,5317.1568579222494,null,3917.7836167290002,null,null,null,617.20089368375,null,2428.4259461762504]
[null,72,{"$f":"'A2 Discount'!E82","v":0.10294993306641052},{"$f":"'A2 Discount'!G82","v":0.3741058810063998},null,null,null,null,null,null,null,null,null,null,null,null,null,5162.288211574999,null,3803.6734142999999,null,null,null,599.22416862499995,null,2357.6950933750004]
[null,73,{"$f":"'A2 Discount'!E83","v":9.9951391326612155E-2},{"$f":"'A2 Discount'!G83","v":0.36935700522493631},null,null,null,null,null,null,null,null,null,null,null,null,null,5011.930302499999,null,3692.88681,null,null,null,581.77103749999992,null,2289.0243625000003]
[null,74,{"$f":"'A2 Discount'!E84","v":9.7040185753992383E-2},{"$f":"'A2 Discount'!G84","v":0.36466841136453515},null,null,null,null,null,null,null,null,null,null,null,null,null,4865.9517499999993,null,3585.3269999999998,null,null,null,564.82624999999996,null,2222.3537500000002]
[null,75,{"$f":"'A2 Discount'!E85","v":9.4213772576691626E-2},{"$f":"'A2 Discount'!G85","v":0.36003933421040141},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C81/C82*R82","v":4724.2249999999995},null,{"$f":"C81/C82*T82","v":3480.8999999999996},null,null,null,548.375,null,2157.625]
[null,76,{"$f":"'A2 Discount'!E86","v":9.1915875684577208E-2},{"$f":"'A2 Discount'!G86","v":0.35622266282301202},null,null,null,null,null,null,null,null,null,null,null,null,null,4609,null,3396,null,null,null,535,null,2105]
[null,77,{"$f":"'A2 Discount'!E87","v":8.9674025058124107E-2},{"$f":"'A2 Discount'!G87","v":0.35244645084962323}]
[null,78,{"$f":"'A2 Discount'!E88","v":8.7486853715243035E-2},{"$f":"'A2 Discount'!G88","v":0.3487102693918534}]
[null,79,{"$f":"'A2 Discount'!E89","v":8.5353028014871254E-2},{"$f":"'A2 Discount'!G89","v":0.34501369409794685}]
[null,80,{"$f":"'A2 Discount'!E90","v":8.3271246843776847E-2},{"$f":"'A2 Discount'!G90","v":0.34135630511457643}]

{"sheet":"FASD calcs","index":19,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"DOI: 10.1097/ADM.0000000000000438 "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2017 USD","Mid Exchange Rate: 0.7731 on 05/07/2017",null,null,null,"https://www.poundsterlinglive.com/best-exchange-rates/best-us-dollar-to-british-pound-history-2017"]
[null,null,"Exchange rate",0.77310000000000001]
[]
[null,null,"Health",{"$f":"2978*D35","v":2302.2918}]
[null,null,"Residential care",{"$f":"13573*D35","v":10493.2863}]
[null,null,"Productivity losses",{"$f":"1055*D35","v":815.62049999999999}]
[null,null,"Special education",{"$f":"4549*D35","v":3516.8319000000001}]

{"sheet":"Crime cost calcs","index":20,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":true,"merged":[[1,16,3,16],[20,4,22,4],[20,5,21,6],[20,8,21,13],[20,14,21,15],[20,16,22,16],[33,6,33,10],[33,11,33,15],[1,4,3,4],[1,5,2,6],[1,8,2,13],[1,14,2,15]]}
[]
[null,null,null,null,"Crimes","Costs in anticipation of crime",null,null,"Costs as a consequence of crime",null,null,null,null,null,"Cost in response to crime",null,"Total (1)"]
[]
[null,null,null,null,null,"Defensive expenditure","Insurance administration",null,"Value of property stolen/damaged","Physical and emotional harm","Lost output","Health services",null,"Victim services","Police costs","Other CJS Costs"]
[null,null,null,null,"Individual"]
[null,null,null,null,"Homicide",61060,10,null,"-",2082430,254710,1110,null,5480,11960,800980,3217740,{"$f":"SUM(N6:P6,J6:L6,F6:G6)","v":3217740}]
[null,null,null,null,"Violence with Injury",330,10,null,"-",8240,2060,920,null,0,1130,1370,14050]
[null,null,null,null,"Violence without Injury",110,10,null,"-",2810,670,270,null,10,810,1250,5930]
[null,null,null,null,"Rape",970,10,null,"-",24390,5900,1110,null,40,6360,580,39360]
[null,null,null,null,"Other sexual offences",150,10,null,"-",3700,1120,390,null,10,570,580,6520]
[null,null,null,null,"Robbery",190,140,null,1030,3590,920,760,null,10,1010,3670,11320]
[null,null,null,null,"Domestic burglary",320,390,null,1400,1190,440,380,null,0,530,1270,5930]
[null,null,null,null,"Theft of Vehicle",1010,720,null,4140,270,150,100,null,0,2030,1870,10290]
[null,null,null,null,"Theft from Vehicle",110,0,null,350,140,60,40,null,0,80,100,870]
[null,null,null,null,"Theft from Person",20,0,null,180,410,120,210,null,0,40,390,1380]
[null,null,null,null,"Criminal damage – arson",110,220,null,1600,980,340,180,null,10,1080,3900,8420]
[null,null,null,null,"Criminal damage – other",20,40,null,330,270,80,90,null,0,150,350,1350]
[null,null,null,null,"Fraud",170,50,null,500,200,60,70,null,0,60,170,1290]
[null,null,null,null,"Cybercrime",290,0,null,10,150,50,50,null,"-","-",0,550]
[]
[null,null,null,null,"Crimes","Costs in anticipation of crime",null,null,"Costs as a consequence of crime",null,null,null,null,null,"Cost in response to crime",null,"Total (1)"]
[]
[null,null,null,null,null,"Defensive expenditure","Insurance administration",null,"Value of property stolen/damaged","Physical and emotional harm","Lost output","Health services",null,"Victim services","Police costs","Other CJS Costs"]
[null,null,null,null,"Commercial (7 sectors only)"]
[null,null,null,null,"Commercial robbery",2060,240,null,980,4170,2250,600,null,20,1010,3670,15000]
[null,null,null,null,"Commercial burglary",7170,860,null,3600,510,380,160,null,0,530,2240,15460]
[null,null,null,null,"Commercial theft",210,10,null,510,0,0,0,null,0,40,200,970]
[null,null,null,null,"Theft of Commercial Vehicle",4040,1880,null,24800,360,190,10,null,0,2030,1870,35180]
[null,null,null,null,"Theft from Commercial Vehicle",220,20,null,1280,100,80,0,null,0,80,100,1870]
[null,null,null,null,"Commercial criminal damage – arson",1300,530,null,2230,1010,510,340,null,10,1080,3900,10930]
[null,null,null,null,"Commercial criminal damage – other",210,110,null,460,60,30,40,null,0,150,350,1420]
[]
[]
[null,null,null,null,null,null,"UNIT COSTS 2015/16"]
[null,"Alex QA - 07.01.2021",null,null,null,null,"Indirect","Intangible","Direct","Total public value"]
[null,"Intangible","Total"]
[null,null,null,null,null,"Violence with injury",2400,7270.5882352941171,{"$f":"N7+O7+P7+L7","v":3420},{"$f":"G37+H37+I37","v":13090.588235294117}]
[null,null,null,null,null,"Violence without injury",790,2479.411764705882,{"$f":"N8+O8+P8+L8","v":2340},{"$f":"G38+H38+I38","v":5609.411764705882}]
[null,null,null,null,null,"Rape",6880,21520.588235294119,8090,36490.588235294119]
[null,null,null,null,null,"Other sexual offences",1280,3264.7058823529414,1550,6094.7058823529414]
[null,null,null,null,null,"Robbery",1250,3167.6470588235293,5450,9867.6470588235297]
[null,null,null,null,null,"Domestic burglary",1150,1050,2180,4380]
[null,null,null,null,null,"Theft of vehicle",1880,238.23529411764704,4000,6118.2352941176468]
[null,null,null,null,null,"Theft from vehicle",170,123.52941176470588,{"$f":"N14+O14+P14+L14","v":220},513.52941176470586]
[null,null,null,null,null,"Theft from person",140,361.76470588235293,{"$f":"N15+O15+P15+L15","v":640},{"$f":"G45+H45+I45","v":1141.7647058823529}]
[null,"Error spotted - reference to Criminal damagae (arson). Changed to criminal damage (other)","Total cost updated based on change to intangible unit costs",null,null,"Criminal damage",140,238.23529411764704,{"$f":"AVERAGE(L16:P17)","v":720},{"$f":"G46+H46+I46","v":1098.2352941176471}]
[null,"Error spotted - reference to Criminal damage (other). Changed to Fraud.","Total cost updated based on change to intangible unit costs",null,null,"Fraud",280,176.47058823529412,{"$f":"N18+O18+P18+L18","v":300},756.47058823529414]
[null,"Error spotted - reference to Fraud. Changed to Commercial robbery.","Total cost updated based on change to intangible unit costs",null,null,"Commercial robbery",4550,3679.4117647058824,{"$f":"N25+O25+P25+L25","v":5300},13529.411764705883]
[null,"Error spotted - reference to Cybercrime. Changed to Commercial burglary.","Total cost updated based on change to intangible unit costs",null,null,"Commercial burglary",8410,450,{"$f":"N26+O26+P26+L26","v":2930},{"$f":"G49+H49+I49","v":11790}]
[]
[null,null,null,null,null,"Shoplifting",0,null,130,130,null,0,0,135.55221888555224,135.55221888555224]
[null,null,null,null,null,"Other theft",221.79425837320571,73.276104700253313,974.92963692654098,1270,null,231.26695275818082,73.276104700253313,1016.5682734052189,1324.2409075742412]