{"text_format":"1","workbook":"xlsx","n_sheets":32,"sheets":["Title Page","Contents","Overview","CLeaR self-assessment","CLeaR partnership","CLeaR evidence","CLeaR peer review","(S1) Setting the context","(S2) Vision and Governance","Good Vision and Governance","(S2) Partnership","Good Partnership","(S2) Planning & Commissioning","Good Planning & Commissioning","(S3) Communications","Good Communications","(S3) Primary Prevention","Good Primary Prevention","(S3) Secondary Prevention","Good Secondary Prevention","(S3) Tertiary Prevention","Good Tertiary Prevention","Good Children and Young People","(S3) Children and Young People","Good Data and Innovation","(S3) Data and Innovation","(S4) Results","Good Results","(S5) Scoring","(S6) Resources","Sheet1","Score"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title Page","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,26,11],[15,4,15,5],[15,6,15,9],[21,6,21,9],[8,2,8,11],[11,4,11,5],[11,6,11,9],[13,4,13,5],[13,6,13,9],[17,4,17,5],[17,6,17,9],[19,4,19,5],[19,6,19,9],[21,4,21,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Alcohol CLeaR\nSelf Assessment"]
[]
[]
[null,null,null,null,"Partnership/Local Authority area "]
[]
[null,null,null,null,"CLeaR lead contact name"]
[]
[null,null,null,null,"E-mail"]
[]
[null,null,null,null,"Telephone/mobile number"]
[]
[null,null,null,null,"Role and employing organisation"]
[]
[null,null,null,null,"Date of completion "]
[]
[]
[null,"This workbook uses macros. These are instructions for excel that allow the automatic addition of scores and population of charts. Please enable editing and enable content when prompted. This will ensure that this document has full functionality. Partners might need to save the blank template onto their system and make the alcohol CLeaR a 'trusted' document, to change the macro settings. "]

{"sheet":"Contents","index":1,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,2,42,5],[19,2,19,4],[22,2,22,4],[23,2,23,3],[24,2,24,4],[27,2,27,3],[28,2,28,3],[30,2,30,3],[31,2,31,5],[32,2,32,3],[35,2,35,4],[39,2,39,4],[36,2,36,4],[13,2,13,4],[14,2,14,3],[16,2,16,3],[1,1,1,4],[33,2,33,3],[29,2,29,4],[15,2,15,3]]}
[]
[null,"Contents"]
[]
[]
[]
[]
[]
[]
[]
[null,"Click to view:"]
[]
[null,"Introduction"]
[null,null,"Overview"]
[null,null,"CLeaR self-assessment"]
[null,null,"CLeaR partnership"]
[null,null,"CLeaR evidence"]
[null,null,"CLeaR peer-review"]
[]
[null,"Section 1: Setting the context"]
[null,null,"Defining your local priorities"]
[]
[null,"Section 2: Leadership"]
[null,null,"Vision & governance"]
[null,null,"Partnership"]
[null,null,"Planning & commissioning"]
[]
[null,"Section 3: Challenging your services"]
[null,null,"Communications and social marketing"]
[null,null,"Primary prevention"]
[null,null,"Secondary prevention"]
[null,null,"Tertiary prevention"]
[null,null,"Supporting children and young people"]
[null,null,"Data and innovation"]
[]
[null,"Section 4: Results"]
[null,null,"Achieving positive outcomes"]
[null,null,"Your priority indicators"]
[]
[null,"Section 5: Outcomes"]
[null,null,"Scoring & CLeaR profile"]
[]
[null,"Section 6: Resources for good practice"]
[null,null,"Good practice guidance and resources"]

{"sheet":"Overview","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,2,6],[4,1,18,8],[20,5,20,7],[20,2,20,3]]}
[]
[null,"Overview"]
[]
[]
[null,"CLeaR is an evidence-based approach to system improvement used to understand the effectiveness of local arrangements for preventing and reducing alcohol-related harm. It can identify areas for further development and help prioritise action across an alcohol partnership.\n\nThe approach comprises two discrete components:\n\n• a self-assessment tool to help showcase good and innovative local practice and to identify opportunities for improvement\n\n• optional participation in a peer review process where a small team of external peer assessors are invited to take an in-depth look at the evidence to validate the findings of the completed self-assessment. After the peer assessment visit the partnership receives a report which summarises key learning from the review process."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"< PREVIOUS PAGE",null,null,"NEXT PAGE >"]

{"sheet":"CLeaR self-assessment","index":3,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,2,6],[4,1,36,8],[38,2,38,3],[38,5,38,6]]}
[]
[null,"CLeaR self-assessment"]
[]
[]
[null,"Undertaking the self-assessment allows partnerships to develop a shared view on their strengths and opportunities for improvement across the three focuses of the CLeaR:\n• Challenge for the local services that deliver interventions to prevent and reduce alcohol-related harm \n• Leadership for comprehensive, collaborative action on this agenda\n• Results achieved through recent activity to reduce alcohol harm evidenced by national and local data sources \n\nEach domain is divided into themes which contain statements (criterion) that show a specific attribute or practice. Partnerships are asked to assess themselves against these and provide evidence for their rating. To inform discussion about the strength of local evidence for each attribute, we have included separate worksheets with advice about what strong practice might look like. It is important to note that the examples provided are not exhaustive.\n\nScoring – how to rate the evidence\nPartnerships are asked whether they can show they are meeting these criteria across their local system: \n• if not meeting the criterion, they should select 'no evidence of achievement'\n• if there is some evidence of the attribute or practice locally, but room for improvement or development they should select 'some evidence of achievement'\n• if the partnership can show that the practice is established locally and the area is delivering well on this, they should select 'strong evidence of achievement'. \n\nGood self-assessments will draw upon a range of local policies, plans, reports and specifications to demonstrate local achievement. It is important to assess the impact of these by using surveys, feedback from service users and partner agencies, and administrative data as evidence. Where possible partners should agree their response to each criterion collectively because different organisations may be able to identify different sources of evidence to illustrate local practice. To rate itself as having ‘strong evidence of achievement’ a partnership should be able to show evidence for all the component parts of each criterion. \n\nWhere a partnership rates itself as having 'some' or 'strong' evidence, it will support action planning and any subsequent peer review if there is a brief note of examples which illustrate this practice, or a record where this evidence can be found in the 'comments and references' column. Partnerships are encouraged to make sure all evidence is well-referenced, so external reviewers can easily match the evidence to the criteria it relates to; including hyperlinks or page references in the 'comments and references' column will help. Our advice is to keep the amount of evidence manageable for everyone involved. We have also included an 'action' column on the template. Partnerships may find this useful for identifying internal priorities for future action or to record the critical reflections and comments coming out of local discussion.\n\nCompleting the self-assessment  is not a test or a competition, it is intended to support local system improvement. The scores provide a snapshot of what the partnership has accomplished and where it may be useful to focus in future. The ratings are just pointers to stimulate discussion about what further action may improve the outcomes achieved locally and to help partnerships determine what should be prioritised."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"< PREVIOUS PAGE",null,null,"NEXT PAGE >"]

{"sheet":"CLeaR partnership","index":4,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,2,6],[4,1,25,8],[26,1,27,8],[29,1,29,3],[29,5,29,7]]}
[]
[null,"CLeaR partnership\nWho should be involved?"]
[]
[]
[null,"The CLeaR approach is for use by local alcohol partnerships – local government, the NHS, those involved in community safety and offender management, third sector agencies and others. It could also be modified for use across different planning footprints such as Police Force Areas, Sustainability and Transformation Partnerships (STPs) or Integrated Care Systems (ICS).\n\nInvolving the right partners and stakeholders in the self-assessment can generate a fuller picture of local activity. Participation presents an opportunity for discussion across organisational boundaries that can result in a collective understanding of what is working and a shared vision about the need for further development.\n\nPreparatory work to get the right organisations and the right people interested may be necessary. Involving the strategic leaders accountable for efforts to reduce alcohol harm – senior officers such as the Director of Public Health (DPH) or chair of the community safety partnership – in the promotion of plans to use the CLeaR approach at high-level boards such as the Health and Wellbeing Board [HWB] may help. This can create opportunities to encourage representatives on the board to task the right people within their own organisations to participate in the self-assessment process. PHE can support this through promotional materials to help local areas engage the relevant partners.\n\nThe following, non-exhaustive, list may help the DPH and the alcohol commissioner identify partners and stakeholders who are playing a role in reducing alcohol-related harm across the partnership area:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"• elected members with responsibility for the alcohol, licensing, children and young people and/or community safety portfolios\n• representatives from the health and wellbeing board and/or the community safety partnership (or equivalent) \n• senior managers based in a range of council departments overseeing regulation and compliance including licensing, trading standards and planning\n• commissioners from NHS clinical commissioning groups and NHS England local area teams\n• substance misuse treatment providers \n• NHS providers in primary care and hospital trusts (acute and MH) \n• mental health commissioners and providers (adult and children) \n• third sector agencies working with vulnerable groups \n• the housing authority, those working with rough sleepers and local housing providers \n• Jobcentre Plus \n• adult and children’s social care \n• education department and schools, pupil referral units (PRUs), colleges and universities \n• local safeguarding boards (children’s and adults) or their equivalent \n• the police \n• the Office of the Police and Crime Commissioner (PCC)\n• National Probation Service (NPS) and the local community rehabilitation company (CRC) \n• youth offending service \n• representatives from the local business community \n• fire and emergency response services \n• service user and carer representatives.\n"]
[]
[]
[null,"< PREVIOUS PAGE",null,null,null,"NEXT PAGE >"]

{"sheet":"CLeaR evidence","index":5,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,1,16,8],[18,2,18,3],[18,5,18,6],[1,1,2,6]]}
[]
[null,"CLeaR evidence"]
[]
[]
[null,"As already indicated, good self-assessments will draw upon a range of local policies, plans, reports and specifications to demonstrate local achievement. It is important to assess the impact of these by using surveys, feedback from service users and partner agencies, and administrative data as evidence. \n\nYour evidence could include: \n• high-level local plans and strategies such as the Joint Health and Wellbeing strategy (JHWS), or Community Safety Partnership plan – specifically referencing where these focus on reducing alcohol harm\n• the alcohol strategy and/or delivery plan\n• needs assessments including the joint strategic needs assessment (JSNA) where it addresses need relating to alcohol harm\n• the statement of licensing policy\n• local service specifications or contracts \n• local protocols and service level agreements \n• reports and/or reviews of your principal alcohol programmes and services\n• terms of reference or minutes of relevant partnership meetings\n• results from local surveys and/or service user feedback\n• relevant overview and scrutiny reports \n• National Drug Treatment Monitoring System (NDTMS) reports, PHE fingertips data (such as the Local Alcohol Profiles for England (LAPE), the Public Health (PH) dashboard and outcomes framework and liver profiles) or locally collated data measuring outputs and outcomes related to a reduction in alcohol harm.\n\nAll evidence should be well-referenced, so it can easily be matched to the CLeaR criteria it is demonstrating.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"< PREVIOUS PAGE",null,null,"NEXT PAGE >"]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"CLeaR peer review","index":6,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,2,6],[5,1,28,8],[30,5,30,7],[30,2,30,3]]}
[]
[null,"CLeaR peer review"]
[]
[]
[]
[null,"Peer review is an optional exercise that takes place after the self-assessment has been completed. \n\nIt provides:\n• an opportunity for external peer reviewers to assess the evidence put forward in the self-assessment \n• a structured day giving local strategic senior decision-makers and influential partners an opportunity to reflect on the evidence in the self-assessment\n• an independent report to ratify the partnership score and identify local strengths and areas that may benefit from further development\n• an opportunity to learn from practice elsewhere by nominating appropriate staff to take part in other peer assessment visits \n• a list of resources and other information relevant to the self-assessment\n• the right to use the alcohol CLeaR logo, for up to one year, on local promotional materials.\n\nThe peer assessment visit takes place in the local area on a date agreed between the partnership and the peer review team. \n\nThere will be a charge to cover the cost of this independent peer review. \n\nOur advice, to those planning to undertake peer review, is to keep the process manageable for those reviewing the findings. The partnership will need to demonstrate the reason for its scores but should try not to submit too many documents as evidence. Only share the most relevant evidence from the completed self-assessment with the lead (core) assessor."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"< PREVIOUS PAGE",null,null,"NEXT PAGE >"]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"(S1) Setting the context","index":7,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,2,35,6],[15,1,15,6],[28,2,28,6],[30,1,30,6],[31,1,31,6],[27,2,27,6],[26,2,26,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[23,1,23,6],[24,1,24,6],[16,1,16,6],[33,2,33,6],[34,2,34,6],[9,1,9,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[8,1,8,6]]}
[]
[null,"Section 1: Setting the context"]
[]
[]
[null,"Key priorities for your partnership area"]
[]
[]
[]
[null,"1.1 What are the top strategic place-based priorities or shared ambitions agreed across your partnership?"]
[null,"For example these might include: ‘best place for health and social care’; ‘thriving and vibrant economy’; ‘build stronger communities’; ‘an active healthy community/place’; ‘improving health and wellbeing’; or ‘a brighter future for children and young people’"]
[]
[null,1]
[null,2]
[null,3]
[]
[null,"1.2 Which of the priorities identified in local strategies or plans will your actions to reduce alcohol harm contribute to achieving?"]
[null,"For example these might include: reducing health inequalities; reducing premature morbidity and mortality; or reducing hospital admissions in the Joint Health and Wellbeing Strategy (JHWS); protecting the public and preventing re-offending; keeping children and young people safe; or tackling violence against women and girls in the Police and Crime Plan;  strengthening prevention and early intervention; or developing locality-based integrated teams supporting primary care in NHS strategic planning documents."]
[]
[null,1]
[null,2]
[null,3]
[]
[]
[null,"1.3 In line with the answers above, what are the 3 most important objectives set out in your alcohol strategy/delivery plan for reducing alcohol harm locally?"]
[null,"(These objectives need to be specific and measurable as you will use these to score the partnership in Results: Section 18 - your priority indicators)"]
[]
[null,1]
[null,2]
[null,3]
[]
[null,"1.4 Are there any specific groups identified as a priority in your partnership's alcohol needs assessment?"]
[null,"For example: those with co-occurring alcohol dependence and mental ill-health issues; older drinkers; dependent drinkers with multi-morbidity; pregnant women or higher risk and vulnerable drinkers not attracted to treatment."]
[]
[null,1]
[null,2]
[null,3]
[]
[null,null,null,"< PREVIOUS PAGE","NEXT PAGE >"]

{"sheet":"(S2) Vision and Governance","index":8,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,2],[5,1,5,2],[13,3,13,4],[2,1,2,2]]}
[]
[]
[null,"2. How engaged are your civic leaders and the membership of the accountable partnership board?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,2.1,"There is a shared understanding about how reducing alcohol harm serves the area’s vision and priorities\n"]
[null,2.2000000000000002,"Effective governance and clear lines of accountability support the achievement of local priorities for reducing alcohol harm\n"]
[null,"3. How do senior managers across the partnership, in local government, the NHS and crime reduction, demonstrate leadership, shared values and commitment for reducing alcohol harm?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,3.1,"A lead agency drives the local alcohol agenda and facilitates collaboration across organisations and sectors  \n"]
[null,3.2,"Public Health promotes the reduction of alcohol-related harm  as an opportunity to deliver health gains and reduce health inequality and address the wider determinants of ill-health across the partnership\n"]
[null,3.3,"Senior clinical champions are identified, from primary and secondary health care, to lead and secure engagement with local activity on reducing alcohol harm \n"]
[null,3.4,"Senior leaders with responsibility for community safety, crime reduction and offender management are committed to reducing alcohol-related harm\n"]
[null,null,"Total score for vision and governance:",{"$f":"Score!B9","v":0}]
[null,null,"< PREVIOUS PAGE",null,"NEXT PAGE >"]

{"sheet":"Good Vision and Governance","index":9,"n_rows":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":true,"merged":[[2,0,2,1],[33,0,42,0],[5,0,11,0],[12,0,17,0],[19,0,23,0],[24,0,27,0],[28,0,32,0]]}
["Leadership","Vision and governance"]
["Context"]
["Visible  leadership across the partnership is essential to ensure a consistent approach to reducing alcohol-related harm. This section asks partnerships to consider the extent to which effective political and managerial leadership, supported by good governance and decision-making arrangements, underpins all local activity to reduce alcohol-related harm."]
["Attribute/Criteria","Pointers to help you rate your evidence"]
["2. How engaged are your civic leaders and the membership of the accountable partnership board?"]
["2.1 There is a shared understanding about how reducing alcohol harm serves the area’s vision and ambition","Indicators of strong practice:"]
[null,"●      senior elected members are engaged with the alcohol agenda and demonstrate a commitment to reducing alcohol harm "]
[null,"●      there is a shared understanding of the impact of alcohol harm locally and a vision for reducing this harm is clearly documented either in an active alcohol strategy or contained within a wider partnership level strategy/action plan"]
[null,"●      the strategy will have been developed collaboratively and signed off by local leaders and senior officers on the Health and Wellbeing Board (HWB)"]
[null,"●      it informs and is cross referenced in other key strategies, and action plans (such as the JHWS, Community Safety Plan, Children and Young People’s Plan, the Statement of Licensing Policy and feeds into NHS strategic planning documents such as the Sustainability and Transformation plan or the Clinical Commissioning Group’s strategic commissioning plan)"]
[null,"●      the strategy is widely disseminated and discussed "]
[null,"●      the aims of this strategy are reflected in local needs assessments (such as the JSNA and the strategic assessment of crime and disorder)."]
["2.2 Effective governance and clear lines of accountability support the achievement of local priorities for reducing alcohol harm","Indicators of strong practice:"]
[null,"●      binding decisions are taken at the right level"]
[null,"●      key performance indicators (KPIs) are agreed and monitored"]
[null,"●      progress against the KPIs is routinely reported to the accountable strategic board through DPH/senior officer reports on alcohol activity and outcomes – (these will include performance and activity data and information about the quality, safety and effectiveness of services)"]
[null,"●      senior leaders are held to account, through member-led scrutiny or other formal review processes, for the outcomes achieved and value for money "]
[null,"●      the findings of the scrutiny process are used to shape future direction and targets are reviewed and adjusted as required."]
["3. How do senior managers across the partnership, in local government, the NHS and crime reduction, demonstrate leadership, shared values and commitment for reducing alcohol harm?"]
["3.1 A lead agency drives the alcohol agenda and facilitates collaboration across other organisations and sectors  ","Indicators of strong practice:"]
[null,"●     the lead agency champions work to reduce alcohol harm across the three levels of prevention (primary, secondary and tertiary)"]
[null,"●      senior management within the lead agency provide visible system leadership, using skills of negotiation and consultation across organisational boundaries , resulting in collaborative direction-setting and decision-making with other stakeholders"]
[null,"●      the lead agency shapes the priorities identified in the local needs assessment and current alcohol strategy into a local delivery plan signed off at senior level to ensure a reduction in health inequity and the improvement of health and wellbeing across the local population"]
[null,"●      the lead agency uses local intelligence and evidence to influence other programmes within local government, the NHS and the Community Safety Partnership."]
["3.2 Public Health promotes the reduction of alcohol-related harm as an opportunity to deliver health gains, reduce health inequality and address the wider determinants of ill-health across the partnership ","Indicators of strong practice:"]
[null,"●      public health influences commissioning strategies across the partnership to explicitly acknowledge the impact of social determinants on alcohol-related health harms"]
[null,"●      commissioned services are designed to meet the needs of specific groups of problematic alcohol users, with a focus on those who are experiencing the detrimental effects of health inequalities"]
[null,"●      public health advocates evidence-based policies and interventions to influence programmes within the NHS to focus on prevention and the integration of action targeting identified groups within the local population most at risk of alcohol harm."]
["3.3 Senior clinical champions are identified, from primary and secondary health care to lead local activity on reducing alcohol harm ","Indicators of strong practice: "]
[null,"●      operational managers have embedded initiatives that provide targeted advice and integrated care to tackle risky and harmful alcohol consumption as standard practice, across a range of health care settings "]
[null,"●      systems are in place to encourage NHS staff to routinely assess patients' alcohol risk and deliver evidence based interventions to prevent alcohol-related ill-health"]
[null,"●      this activity is visibly promoted by senior clinicians"]
[null,"●      this activity is routinely monitored by senior managers or clinicians."]
["3.4 Senior leaders with responsibility for community safety, crime reduction and offender management are committed to reducing alcohol-related harm ","Indicators of strong practice: "]
[null,"●      the PCC and police are represented at the HWB and actively participate in the alcohol partnership"]
[null,"●      the Crime Reduction Strategy includes an explicit reference to reducing alcohol-related crime and other harms "]
[null,"●       local initiatives to reduce alcohol-related crime are strategically led and actively championed by representatives of the community safety partnership to raise the visibility of this work  "]
[null,"●      the police, offender management and health and social care services work together to improve people’s health and wellbeing, reduce crime and protect the most vulnerable people in the locality"]
[null,"●      information sharing protocols have been agreed at a senior level and there is effective data sharing between police and health partners to support collaborative approaches to reduce alcohol-related violence"]
[null,"●      operational police officers are encouraged to identify and record incidents where the offending is alcohol-related to inform wider planning to address crime and disorder "]
[null,"●      there are mechanisms within local multi-agency working arrangements to enable and prioritise earlier intervention and prevention to tackle alcohol-related offending including the screening of offenders to identify alcohol-related need "]
[null,"●      community safety and senior officers in the police and offender management services promote cross-sector partnership work to address alcohol harms, including but not limited to, alcohol-related offending and/or anti-social behaviour, and its impact on victims "]
[null,"●      this activity is routinely monitored in the police and offender management services, by the community safety partnership and the local authority alcohol commissioner."]

{"sheet":"(S2) Partnership","index":10,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,2],[5,1,5,2],[2,1,2,2],[6,2,6,3]]}
[]
[]
[null,"4. How does the local alcohol partnership exercise influence and work collaboratively?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,4.0999999999999996,"A formal strategic partnership has oversight of local work to reduce alcohol harm at population and individual level and the resources to support this\n"]
[null,4.2,"Alcohol misuse and its associated harms are addressed across the wider children’s agenda at both the strategic and operational level\n"]
[null,"5. How well embedded is the focus on alcohol across the wider partnership and within individual organisational priorities?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,5.0999999999999996,"Strategic partnership arrangements support operational protocols and procedures between alcohol service providers and key partner organisations delivering frontline services to residents, including initiatives addressing:\n"]
[null,"5.1.1","Mental health priorities\n\n"]
[null,"5.1.2","Safeguarding practices (adult/children)\n\n"]
[null,"5.1.3","Physical ill-health\n\n"]
[null,"5.1.4","Community safety and crime reduction initiatives\n\n"]
[null,"5.1.5","Work to reduce homelessness and rough sleeping\n\n"]
[null,"5.1.6","Workplace health and wellbeing, increasing productivity and reducing absenteeism and worklessness\n\n"]
[null,"5.1.7","Adverse childhood experience including those relating to parental alcohol misuse, child sexual exploitation, and gang membership\n"]
[null,"5.1.8","Other local initiatives (please specify)\n\n"]
[null,null,"Total score for partnership:",{"$f":"Score!F14","v":0}]
[null,null,"< PREVIOUS PAGE",null,"NEXT PAGE >"]

{"sheet":"Good Partnership","index":11,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":true,"merged":[[5,0,11,0],[12,0,17,0],[19,0,31,0],[2,0,2,1]]}
["Leadership","Partnership"]
["Context"]
["Effective partnership working supports the delivery of co-ordinated policies promoting alcohol harm reduction, and an integrated support offer which achieves positive outcomes for individuals, their families and wider communities."]
["Attribute/Criteria","Pointers to help you rate your evidence"]
["4. How does the local alcohol partnership exercise influence and work collaboratively?"]
["4.1 A formal strategic partnership has oversight of local work to reduce alcohol harm at population and individual level and the resources to support this","Indicators of strong practice:"]
[null,"●      all relevant stakeholders and partner agencies are actively represented at the partnership board and/or operational meetings "]
[null,"●      the alcohol strategy/delivery plan is signed off at senior level and there is clarity about specific partner roles and responsibilities in the delivery of the plan"]
[null,"●     a commitment can be demonstrated to achieving shared goals and finding shared solutions"]
[null,"●      there is a clear understanding of gaps in capacity and resources and agreement on how these are to be addressed"]
[null,"●      partners and relevant stakeholders take responsibility for their own contribution and are held to account for deliverables in this plan"]
[null,"●      decisions are fed back internally to individual partner agencies and shape organisational activity and priority setting."]
["4.2 Alcohol misuse and its associated harms are addressed across the wider children’s agenda at both the strategic and operational level","Indicators of strong practice: "]
[null,"●      there is a common understanding, across children’s strategic planning and commissioning structures, of the alcohol-related needs of children and young people (CYP) and an integrated approach to addressing these needs across the partnership"]
[null,"●      alcohol misuse is recognised as a risk factor for children and young people and is addressed in local CYP focused strategies and action plans"]
[null,"●      there are clear lines of accountability to assure the quality and effectiveness of interventions to reduce harm caused by alcohol to under 18s"]
[null,"●      support to address alcohol harm is routinely available in mainstream provision for children, young people and families"]
[null,"●     local protocols support universal, targeted and specialist services to work together to provide high quality and evidence-based care in response to presenting need."]
["5. How well embedded is the focus on alcohol across the wider partnership and within individual organisational priorities?","For the partnership to rate themselves as having strong evidence of achievement for criteria 5.1 they will need to demonstrate that there are robust partnership arrangements in place supporting effective operational links and that there is a focus on alcohol-related need within the other work strands detailed below. [criteria 5.1.1 -5.1.8]  "]
["5.1 Strategic partnership arrangements support operational procedures between alcohol service providers and key partner organisations delivering frontline services to residents, including initiatives addressing:","Indicators of strong practice:"]
[null,"●      local activity is shaped by a shared understanding of, and a commitment to realising the benefits of tackling alcohol misuse locally, to:"]
[null,"○   reduce costs by reducing sickness absence, and improving productivity and economic performance  "]
[null,"○   protect people from harm by reducing crime, reducing drinking among CYP and tackling health inequalities"]
[null,"○   safeguard CYP from the consequences of harmful parental drinking"]
[null,"○   improve the population’s health by encouraging a sensible drinking culture and reducing risky consumption and dependence among adults"]
[null,"●      commissioners and strategic leaders promote joint working opportunities and information sharing between services to clarify:"]
[null,"○   access"]
[null,"○   thresholds for intervention"]
[null,"○   pathways in and out of services "]
[null,"○   agency specific roles and responsibilities for addressing alcohol harm"]
[null,"●      data and intelligence are shared across the partnership to maximise the contribution that individual partner agencies make to the alcohol agenda"]
[null,"●      there is a shared understanding of the impact that effective alcohol policies and interventions can have on the achievement of other partners’ priority outcomes. "]
["5.1.1          Mental health priorities","[For example: consideration of alcohol misuse in local suicide prevention planning; within local Crisis Care concordat arrangements; addressed in the prevention concordat for better mental health; and timely and effective responses are commissioned for those with co-occurring alcohol misuse and mental health need]"]
["5.1.2          Safeguarding practices (adult/children)","[For example: through links into local multi-agency risk assessment conference (MARAC) and multi-agency safeguarding hub (MASH) arrangements]"]
["5.1.3          Physical ill-health","[For example: identification of alcohol misuse issues and the earlier detection and diagnosis of alcohol-related physical conditions are embedded in primary and secondary care and inclusion health initiatives]"]
["5.1.4          Community safety and crime reduction initiatives","[For example: within licensing and enforcement activity and offender management arrangements] "]
["5.1.5          Work to reduce homelessness and rough sleeping","[For example: there are supported housing opportunities for problematic alcohol users and routine consideration of the needs of drinkers within the Homelessness Prevention Duty]"]
["5.1.6          Workplace health and wellbeing, increasing productivity and reducing absenteeism and worklessness ","[For example: actions to reduce alcohol harm are embedded in work to promote workplace health and wellbeing and opportunities to reduce worklessness]"]
["5.1.7          Adverse childhood experience including disadvantage relating to parental alcohol misuse, child sexual exploitation, and gang membership","[For example: actions to reduce alcohol harm are embedded into the planning and delivery of early interventions to prevent or reduce the impact of adverse childhood experience]"]
["5.1.8          Other local initiatives (please specify)"]

{"sheet":"(S2) Planning & Commissioning","index":12,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,2],[7,1,7,2],[2,1,2,2],[1,1,1,2]]}
[]
[]
[null,"6. How robust are local alcohol-related needs assessment and planning processes?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,6.1,"There is a current, relevant, partnership-wide alcohol needs assessment informing planning and commissioning decisions in the area\n"]
[null,6.2,"Partnership planning processes focus on addressing the needs of higher risk and vulnerable groups with an explicit aim of reducing health inequality\n"]
[null,6.3,"Systems are in place to promote understanding of the impact of parental alcohol misuse within families and wider communities, and this is reflected in commissioning decisions and partnership work across local services\n"]
[null,6.4,"Partnership-wide commitment to the reduction of alcohol harm provides sufficient resource and capacity to deliver the local plan\n"]
[null,"7. How do local commissioning arrangements reflect the evidence based guidelines?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,7.1,"Commissioners can demonstrate that safe, effective and cost-effective alcohol interventions are being delivered in local services\n"]
[null,7.2,"Service users of all ages and their carers are actively involved in local planning, commissioning and service redesign\n"]
[null,7.3,"Services to improve outcomes for those disadvantaged by multiple and complex needs are commissioned jointly by the responsible agencies\n"]
[null,null,"Total score for planning and commissioning:",{"$f":"Score!J10","v":0}]
[null,null,"< PREVIOUS PAGE",null,"NEXT PAGE >"]

{"sheet":"Good Planning & Commissioning","index":13,"n_rows":54,"n_cols":2,"rows_kept":54,"cut":false,"hidden":true,"merged":[[2,0,2,1],[42,0,47,0],[48,0,53,0],[5,0,9,0],[10,0,14,0],[15,0,18,0],[19,0,24,0],[26,0,41,0]]}
["Leadership","Planning and commissioning"]
["Context"]
["Understanding need is at the heart of effective planning to reduce alcohol harm. There is an explicit link between evidence of need and service planning across the local system."]
["Attribute/Criteria","Pointers to help you rate your evidence"]
["6. How robust are local alcohol-related needs assessment and planning processes?"]
["6.1 There is a current, relevant, partnership-wide alcohol needs assessment informing planning and commissioning decisions in the area","Indicators of strong practice:"]
[null,"●      the needs assessment has been agreed by partners across the LA, NHS, police, criminal justice and third sector organisations and addresses the full spectrum of alcohol-related harm with a focus on health equity"]
[null,"●      data sharing protocols have been agreed between relevant public services to support the exchange of information to inform this assessment of need"]
[null,"●     shared data is analysed and guides local planning and commissioning decisions"]
[null,"●      ambition to address identified need is cross-referenced in wider partnership strategies (such as the JHWS, and the local strategic assessment of crime and disorder) and delivery plans which are regularly reviewed and refreshed."]
["6.2 Partnership planning processes focus on addressing the needs of higher risk and vulnerable groups with an explicit aim of reducing health inequality","Indicators of strong practice:"]
[null,"●      plans and processes are in place to reduce both population-wide health inequity and the specific health inequalities experienced by vulnerable groups with complex needs"]
[null,"●      progress against this ambition is routinely monitored through the accountable alcohol governance structure"]
[null,"●      partner agencies show commitment to improving the health and other needs of identified higher risk and vulnerable populations"]
[null,"●      local strategies and delivery plans make explicit reference to health inequalities and include actions to reduce them, including for higher risk and vulnerable drinking populations."]
["6.3 Systems are in place to promote understanding of the impact of parental alcohol misuse within families and wider communities, and this is reflected in commissioning decisions and partnership work across local services","Indicators of strong practice:"]
[null,"●      prevalence data on alcohol dependent parents and local intelligence on the impact on children informs the understanding of local need"]
[null,"●      ambition to reduce the potential for adverse childhood experiences of children living with parental alcohol misusers is shared across partner agencies leading to a joined-up strategy and aligned commissioning"]
[null,"●      data sharing protocols have been agreed between relevant public services and local safeguarding structures to support the exchange of relevant information to inform this assessment of need."]
["6.4 Partnership-wide commitment to the reduction of alcohol harm provides sufficient resource and capacity to deliver the local plan","Indicators of strong practice:"]
[null,"●     resource across the system meets local need as set out in the current alcohol strategy/delivery plan and commissioning arrangements are fit for purpose"]
[null,"●      there is demonstrable capacity to meet presenting need across the range of interventions commissioned in a variety of settings"]
[null,"●      activity and performance are routinely monitored, and the partnership receives regular updates from a named commissioner with expertise and knowledge of the alcohol agenda, who has operational oversight of progress towards the current plan"]
[null,"●     individual partner agencies are each aware of their own role and responsibilities in supporting the delivery plan and actively engage in work to reduce alcohol harm, leading on specific areas of work in line with their expertise and area of responsibility"]
[null,"●      there is sufficient capability for information management and analysis to support the delivery of the alcohol strategy/plan and to demonstrate its impact and value for money. "]
["7. How do local commissioning arrangements reflect the evidence-based guidelines?"]
["7.1 Commissioners can demonstrate that safe, effective and cost-effective alcohol interventions are being delivered in local services","Indicators of strong practice:"]
[null,"●      commissioned services within local authority and NHS settings are specified and monitored against relevant NICE guidelines for effective interventions (PH24, CG115, CG100 and NICE quality standards 83 and 11)"]
[null,"●      appropriate quality governance structures are in place to continually review and improve the safety and effectiveness of commissioned services"]
[null,"●      contracts make specific reference to the quality governance responsibilities of providers addressing expectations around:"]
[null,"○   staff competence"]
[null,"○   training capacity"]
[null,"○   service user involvement"]
[null,"○   clinical leadership"]
[null,"○   capacity to undertake regular clinical audit"]
[null,"●      there are clear lines of accountability and communication between service providers, local commissioners and the responsible strategic partnership"]
[null,"●      the quality assurance mechanisms adopted locally include:"]
[null,"○   contract monitoring arrangements"]
[null,"○   findings of quality audits"]
[null,"○   outcomes reports"]
[null,"○   safeguarding and serious incidence reporting"]
[null,"○   service user and carer feedback."]
["7.2 Service users of all ages and their carers are actively involved in local planning, commissioning and service redesign","Indicators of strong practice:"]
[null,"●      service users are confident about their influence within routine contract monitoring processes and representatives meet regularly with commissioners and service providers to feedback on the treatment experience"]
[null,"●      there are mechanisms for service users and carers to feed into wider planning and commissioning processes  "]
[null,"●      service users actively contribute to and shape strategy development and service redesign"]
[null,"●      there is evidence that support and training is offered to enable service users to feedback and shape local decision-making"]
[null,"●      general patient/public engagement includes consultation on alcohol."]
["7.3 Services to improve outcomes for those disadvantaged by multiple and complex needs are commissioned jointly by the responsible agencies","Indicators of strong practice:"]
[null,"●      commissioners work together across organisational and financial boundaries to commission provision for those with alcohol-related need"]
[null,"●      opportunities for joint planning are maximised and responsible commissioners agree and specify expectations of individual provider agencies in supporting an integrated approach across the spectrum of need and ensuring pathways are configured to meet the needs of the target population"]
[null,"●     there is sufficient capacity to meet presenting need and offer the range of interventions ensuring a holistic response "]
[null,"●      services in the local system are designed around individual users of services and the outcomes that are important to them"]
[null,"●      commissioners have partnership agreements with key agencies and create opportunities for provider dialogue to ensure a cohesive, co-ordinated approach to care planning and delivery supported by effective information sharing agreements."]

{"sheet":"(S3) Communications","index":14,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,1,2,2]]}
[]
[]
[null,"8. How effective is the local communications strategy/plan?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,8.1,"There is a comprehensive and planned approach to communications to support local alcohol prevention and harm reduction initiatives across the partnership \n\n"]
[null,8.1999999999999993,"Local campaigns are evidence-based and targeted towards specific audiences to address identified needs within the local population\n\n"]
[null,8.3000000000000007,"The partnership can demonstrate how their communications and social marketing work contributes to change at a local level\n\n"]
[null,null,"Total score for communications and social marketing:",{"$f":"Score!N6","v":0}]
[null,null,"< PREVIOUS PAGE",null,"NEXT PAGE >"]

{"sheet":"Good Communications","index":15,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":true,"merged":[[5,0,8,0],[9,0,15,0],[16,0,19,0],[2,0,2,1]]}
["Challenging your services","Communications and social marketing"]
["Context"]
["Effective communication is essential to influence stakeholders and raise awareness among the public. This section asks how your partnership communicates and uses social marketing techniques."]
["Attribute/Criteria","Pointers to help you rate your evidence"]
["8. How effective is the local communications strategy/plan?"]
["8.1 There is a comprehensive and planned approach to communications to support local alcohol prevention and harm reduction initiatives across the partnership ","Indicators of strong practice:"]
[null,"●      local partner agencies set out their vision and approach to alcohol-related communications in their organisational communications strategies and/or in the local alcohol strategy/delivery plan"]
[null,"●      local partners are clear about the purpose of each communication"]
[null,"●       the key messages from partner organisations are consistent and clear to the public and the wider partnership."]
["8.2 Local campaigns are evidence-based and targeted towards specific audiences to address identified needs within the local population","Indicators of strong practice :"]
[null,"●      local campaigns link with and amplify national and regional campaigns"]
[null,"●      there is clarity about target audience and the objective of each campaign"]
[null,"●      messages are tailored to suit the specific population (target audience) and appropriate communication channels are used for both the message and the intended audience"]
[null,"●      content and creative is designed to maximise impact and shaped to address health inequity at the local level"]
[null,"●     social marketing is developed, based on audience insight and clear SMART objectives "]
[null,"●      where appropriate, campaigns have integrated PR activity to maximise impact."]
["8.3 The partnership can demonstrate how their communications and social marketing work contributes to change at a local level","Indicators of strong practice:"]
[null,"●      mechanisms have been agreed to support evaluation"]
[null,"●      all activity is robustly evaluated to measure impact"]
[null,"●      communications and/or social marketing strategies are updated based on evaluation of previous activity to improve impact."]

{"sheet":"(S3) Primary Prevention","index":16,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,1,0,2],[2,1,2,2]]}
[]
[]
[null,"9. How integrated is the health agenda within the partnership’s licensing, regulation and enforcement work?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,9.1,"There is a common understanding of the role of each responsible authority in regulation and enforcement activity to reduce alcohol-related harm\n\n"]
[null,9.1999999999999993,"Strategic ambition is realised through effective partnership working between all responsible authorities\n\n"]
[null,9.3000000000000007,"Systems are in place to monitor the impact of partnership working on reducing the incidence of alcohol-related harm through local licensing and enforcement activity \n\n"]
[null,null,"Total score for primary prevention:",{"$f":"Score!R6","v":0}]
[null,null,"< PREVIOUS PAGE",null,"NEXT PAGE >"]

{"sheet":"Good Primary Prevention","index":17,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":true,"merged":[[5,0,10,0],[11,0,16,0],[17,0,22,0]]}
["Challenging your services","Primary prevention"]
["Context","Data and metrics to corroborate your evidence"]
["This section reviews the extent to which effective alcohol licensing, regulation and enforcement initiatives are in place to reduce alcohol-related harms. ","There are a range of data sources that a locality can examine to assess the impact of their activity in this area but the quality, regularity and availability of these datasets will vary depending on local practice. NICE recommends the use of local crime and related trauma data to map the extent of alcohol-related problems as part of a crime reduction approach. This can be used to inform the development or review of a statement of licensing policy."]
["Attribute/Criteria","Pointers to help you rate your evidence"]
["9. How integrated is the health agenda within the partnership’s licensing and enforcement work?"]
["9.1 There is a common understanding of the role of each responsible authority in regulation and enforcement activity to reduce alcohol-related harm","Indicators of strong practice:"]
[null,"●      there is evidence of a shared partnership vision, set out in the statement of licensing policy which includes a strong perspective on alcohol health harms"]
[null,"●      all responsible authorities and community safety partners understand the role of public health in local licensing and enforcement activity"]
[null,"●      there is shared commitment from all partners to use public health intelligence across the partnership"]
[null,"●      this reads across to other strategic boards (for example community safety) and action plans"]
[null,"●     information sharing protocols have been agreed, and shared intelligence is used to shape the strategy and priorities for local action."]
["9.2 Strategic ambition is realised through effective partnership working between all responsible authorities","Indicators of strong practice:"]
[null,"●      there is active partnership working between all responsible authorities"]
[null,"●      there is evidence of the practical application of information sharing agreements - enhanced intelligence (including local crime and related trauma data) is used to:"]
[null,"○   shape representations to the licensing panel"]
[null,"○   inform operational enforcement activity by police and trading standards (including action against premises to prevent under-age sales, sales to people who are intoxicated, and proxy sales to minors; to target crime hotspot areas and reduce the incidence of violent crime)"]
[null,"●      all enforcement partners make use of available tools and powers to minimise crime and disorder in the local day and night time economy."]
["9.3 Systems are in place to monitor the impact of partnership working on reducing the incidence of alcohol-related harm through local licensing and enforcement activity","Indicators of strong practice:"]
[null,"●      there is evidence that activity data is routinely shared and analysed"]
[null,"●      there is evidence of positive impact on the day and night time economy"]
[null,"●      public health intelligence shapes enforcement priorities and there is a demonstrable impact on the incidence of violence and other crime and disorder, with associated improvements in community safety"]
[null,"●      evaluation metrics are established at the outset of all local initiatives"]
[null,"●      senior partners are regularly updated on local developments and their impact through progress reports at strategic planning meetings and best practice examples/lessons learnt are shared with operational managers to shape future activity."]

{"sheet":"(S3) Secondary Prevention","index":18,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,1,2,2]]}
[]
[]
[null,"10. Do you have systems in place locally to identify and motivate those drinking at above low risk levels to reduce their consumption?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,10.1,"Opportunities to deliver alcohol IBA are maximised across primary and secondary health care and other settings in line with NICE guidance (PH24) and the evidence\n\n"]
[null,10.199999999999999,"Systems are in place to routinely monitor the level of IBA delivery in primary and secondary health care and other settings and the quality and effectiveness of reported activity in line with NICE guidance\n\n"]
[null,10.3,"There are clear pathways into treatment for dependent drinkers identified through routine screening\n\n"]
[null,null,"Total score for secondary prevention:",{"$f":"Score!B23","v":0}]
[null,null,"< PREVIOUS PAGE",null,"NEXT PAGE >"]

{"sheet":"Good Secondary Prevention","index":19,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":true,"merged":[[5,0,16,0],[17,0,22,0],[23,0,28,0]]}
["Challenging your services","Secondary prevention"]
["Context","Data and metrics to corroborate your evidence"]
["This section asks for evidence on preventive work and large-scale delivery of targeted brief advice in local authority, health and criminal justice services across your partnership area. Targeted interventions aimed at individuals in identified at-risk groups can help make those drinking at above low risk levels aware of the potential for health harm and promote behaviour change. ","NICE recommends health and social care staff opportunistically carry out identification and brief advice (IBA) for hazardous (increasing risk) and harmful (higher risk) drinking as an integral part of practice. A body of evidence exists to show the value of this activity in reducing alcohol consumption and harm compared to no intervention. The partnership may wish to examine data sources to assess the extent to which IBA is routinely delivered to GP new registrations, at NHS Health Checks, through local MECC initiatives and in secondary care."]
["Attribute/Criteria","Pointers to help you rate your evidence"]
["10. Do you have systems in place locally to identify and motivate those drinking at above lower risk levels to reduce their consumption?"]
["10.1 Opportunities to deliver alcohol IBA are maximised across primary and secondary health care and other settings in line with NICE guidance (PH24) and the evidence","Indicators of strong practice: "]
[null,"●      commissioning strategies and local policies support a joined-up approach to preventing alcohol-related harm through screening at-risk groups and providing advice for increasing risk and higher risk drinkers"]
[null,"●      health and care professionals use their relationships with patients, families and communities to prevent alcohol-related ill health and promote wellbeing as part of their everyday practice"]
[null,"●      health, social care and criminal justice staff are supported to maximise opportunities for screening to identify those drinking above the low risk alcohol guideline and to deliver brief advice or refer on as required. Current opportunities at the local level include, but are not restricted to: "]
[null,"○   the NHS health check"]
[null,"○   preventive initiatives in secondary care settings "]
[null,"○   GP new patient registrations"]
[null,"○   local Making Every Contact Count (MECC) programmes"]
[null,"●      the focus within this work is on addressing health inequality through the targeting of key groups that have been identified as at increased risk of alcohol-related harm"]
[null,"●      there is a partnership-wide plan setting out individual organisational roles and responsibilities for workforce development, monitoring activity and the quality of delivery of IBA "]
[null,"●      training is available to staff to help ensure consistency of delivery "]
[null,"●      there is local agreement about the use of a specific validated tool (such as AUDIT, AUDIT-C, FAST) to identify patients’ alcohol risk. "]
["10.2 Systems are in place to routinely monitor the level of IBA delivery in primary and secondary health care and other settings and the quality and effectiveness of reported activity in line with NICE guidance","Indicators of strong practice:"]
[null,"●      the partnership regularly reviews activity data from across the system to understand each stage of delivery and how the pathway is working. This includes consideration of evidence of IBA activity in:"]
[null,"○   primary care through the GP extraction service (GPES) which reports on delivery against the GP contract"]
[null,"○   NHS health check data to monitor the extent to which alcohol use/misuse is addressed in this process"]
[null,"○ secondary care settings – data is collected to monitor activity with in-patients incentivised through the CQUIN and reports on activity in A&E departments"]
[null,"●      local arrangements are in place within the commissioning framework to review the quality and effectiveness of brief interventions and to ensure that specific populations identified as being at risk of alcohol harm are targeted for opportunistic screening."]
["10.3 There are clear pathways into treatment for dependent drinkers identified through routine screening","Indicators of strong practice: "]
[null,"●      health and social care professionals are aware of access pathways into specialist alcohol services and actively refer those identified as potentially dependent drinkers through the screening process for specialist assessment "]
[null,"●      there is sufficient capacity within treatment services to support timely assessment of need and all assessments are undertaken by appropriately trained and competent specialist staff "]
[null,"●      arrangements are in place to accept self-referral of people who may benefit from specialist assessment or treatment for alcohol misuse "]
[null,"●      protocols are in place between local agencies and specialist alcohol treatment services and pathways from primary and secondary health care and local social care settings are monitored to ensure these are used to full effect"]
[null,"●      in reviewing pathways health equity considerations are addressed. "]

{"sheet":"(S3) Tertiary Prevention","index":20,"n_rows":11,"n_cols":248,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,1,2,2]]}
[]
[]
[null,"11. Do you have systems in place locally to motivate and engage dependent drinkers into treatment?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,11.1,"Arrangements are in place to promote timely access into community-based treatment with a focus on targeting those with complex and multiple need\n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,11.2,"Competent staff deliver high quality, clinically safe care and treatment interventions, in line with NICE guidance \n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,11.3,"There are well-functioning and agreed pathways into and through alcohol treatment\n\n"]
[null,11.4,"Local pathways promote and sustain recovery\n\n"]
[null,11.5,"Alcohol dependent parents are identified, then actively referred to and engaged in treatment and treatment providers are mindful of parental status and respond appropriately to safeguarding concerns\n\n"]
[null,11.6,"Systems are in place to ensure effective care co-ordination for alcohol dependent individuals with multiple need\n\n"]
[null,null,"Total score for tertiary prevention:",{"$f":"Score!F26","v":0}]
[null,null,"< PREVIOUS PAGE",null,"NEXT PAGE >"]

{"sheet":"Good Tertiary Prevention","index":21,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":true,"merged":[[53,0,57,0],[5,0,12,0],[13,0,23,0],[24,0,36,0],[37,0,45,0],[46,0,52,0]]}
["Challenging your services","Tertiary prevention"]
["Context ","Data and metrics to corroborate your evidence"]
["This section looks at evidence around the provision of specialist treatment for alcohol dependence. This could be in a healthcare or in a community setting. Outcomes will be best achieved if services are welcoming, easy to access and flexible. Effective treatment comprises care-planned packages of psychosocial, pharmacological and recovery-focused interventions. ","High-level indicators for effective alcohol treatment at the local level include:\n●  rate of unmet need for alcohol treatment (the number of estimated alcohol dependent people in the locality compared to the number entering treatment).\n●  successful completion of treatment with no representation (alcohol only and alcohol and non-opiates)\n(Source: Public Health Dashboard; NDTMS dataset)\n\nIndicators providing more detail on how the local system is working include:\n●  number of new presentations (alcohol only and alcohol and non-opiates)\n● referral sources\n●  severity of dependence scores and/or consumption levels at initial assessment\n●  deaths in treatment\n●  changes in employment and housing status\n●  break down of interventions and sub-interventions provided.\nThese indicators can be compared with data from the previous year to assess direction of travel.\n(Source: NDTMS dataset; sub-interventions tool) \n\n\n\n"]
["Attribute/Criteria","Pointers to help you rate your evidence"]
["11. Do you have systems in place locally to motivate and engage dependent drinkers into treatment?"]
["11.1 Arrangements are in place to promote timely access into community-based treatment with a focus on targeting those with complex and multiple need","Indicators of strong practice: "]
[null,"●      treatment access points and referral pathways are clear to the public, service users and healthcare and other frontline staff"]
[null,"●      treatment services are geographically and culturally accessible and interventions are delivered flexibly in a range of settings to maximise access"]
[null,"●      there is a prompt response to referrals to improve engagement"]
[null,"●      arrangements are in place to accept self-referral, to facilitate direct access and prompt re-entry into treatment in the event of relapse"]
[null,"●      there is evidence of joint working (with effective pathways) between treatment and local mental health,  primary and secondary care, homeless and criminal justice services to ensure appropriate referral and access to assessment and treatment"]
[null,"●      a whole system response to need and routes into treatment are promoted to relevant local services to ensure the victims and perpetrators of domestic violence can access support as required in a timely way"]
[null,"●      there is evidence of assertive outreach targeting specific vulnerable groups (including people who are homeless, street drinkers, those involved in sex work, offenders, and those with mental ill-health) who may otherwise struggle to access treatment."]
["11.2 Competent staff deliver high quality, clinically safe care and treatment interventions, in line with NICE guidance ","Indicators of strong practice: "]
[null,"●      treatment interventions reflect severity of dependence and are appropriately tailored to meet individual need"]
[null,"●      the treatment system provides evidence-based psychosocial, pharmacological and recovery-focused interventions as appropriate for need and every provider has a named clinical lead with ultimate responsibility for delivery in line with professional and clinical guidelines (see NICE CG100 and CG115 and QS11)  "]
[null,"●      clinical leadership is supported by a clear and accessible clinical governance policy which spells out accountabilities and reporting lines to all staff, including volunteers and peer mentors"]
[null,"●      there are strong links to local safeguarding and practice is continuously monitored, reviewed and reported on to ensure the safety of service users, their families and wider social groups"]
[null,"●      the quality of treatment delivery is monitored through:"]
[null,"○   regular clinical audit "]
[null,"○   staff supervision and appraisals "]
[null,"○   adherence to local safeguarding and serious incident reporting procedures"]
[null,"○   formalised mechanisms to elicit feedback from service users and carers"]
[null,"●      treatment providers have workforce plans that describe how specialist staff are trained and supported and all staff, including volunteers and peer mentors, can access development opportunities to make sure they work within the limits of their competency."]
["11.3 There are well-functioning and agreed pathways into and through alcohol treatment","Indicators of strong practice: "]
[null,"●      there are clearly defined and mutually understood referral pathways supported by up-to-date protocols setting out the roles and responsibilities of each agency, between community alcohol treatment, primary and secondary health care, mental health, criminal justice as well as welfare, housing, social care and safeguarding services"]
[null,"●      there is effective, system-wide joint planning to ensure that treatment services are sufficiently accessible and available to enable continuity of care at the point of transition to and from:"]
[null,"o   inpatient hospital care"]
[null,"o   prison and places of detention into the community"]
[null,"o   children and young people’s to adult alcohol treatment services"]
[null,"●     the partnership can demonstrate that those transitioning from non-community settings in need of ongoing medically assisted alcohol withdrawal are offered timely assessment and treatment within the setting most appropriate to their age, the severity of alcohol dependence, their social support and the presence of any physical or mental health co-morbidities"]
[null,"●      within the treatment system individuals are offered a range of evidence-based interventions"]
[null,"●      processes and systems are designed to give service users the opportunity to shape their own care and treatment"]
[null,"●      care-planned packages of treatment are appropriately tailored to severity of dependence and complexity of need and are regularly reviewed"]
[null,"●      the role, responsibilities and capacity issues of individual treatment providers are mutually understood and operational delivery is monitored in order to ensure an integrated system that meets the needs of the local population across the range of settings"]
[null,"●      all pathways are supported by explicit information governance agreement across services to ensure that information is shared routinely to support effective care delivery, continuity of care and risk management"]
[null,"●      pathways into recovery support options are promoted and well-utilised to sustain the improvements made in treatment."]
["11.4 Local pathways promote and sustain recovery","Indicators of strong practice: "]
[null,"●      there is a shared, locally developed vision of recovery across the treatment system"]
[null,"●     planning for recovery is initiated early and facilitated by access into a range of support interventions and services that promote and sustain recovery including peer support; mutual aid; family/parenting support; education, training and employment (ETE) and housing opportunities"]
[null,"●      relapse prevention planning is an integral component when building recovery capital"]
[null,"●      the treatment system is responsive and facilitates re-entry in the event of relapse"]
[null,"●      mutual aid is appropriately integrated with all alcohol treatment including that within in-patient and residential settings"]
[null,"●      there is access to sustainable housing and across the system, frontline housing workers are trained to meet the housing and related needs of alcohol misusers"]
[null,"●      rough sleepers are encouraged to access emergency accommodation and support"]
[null,"●     local worklessness and employability strategies reflect the education, training and employment (ETE) needs of alcohol misusers and joint planning arrangements are in place between community treatment providers, Job Centre Plus (JCP) and the Work and Health Programme (WHP) to meet these needs."]
["11.5 Alcohol dependent parents are identified, then actively referred to and engaged in treatment and treatment providers are mindful of parental status and respond appropriately to safeguarding concerns","Indicators of strong practice: "]
[null,"●      clear governance arrangements and strategic oversight support joint working and effective communication between treatment and children and family (C&F) services"]
[null,"●      this approach is supported by operational protocols that are regularly reviewed and updated"]
[null,"●      all frontline services refer parents into treatment as well as to C&F services when safeguarding concerns relating to alcohol dependence are identified"]
[null,"●      the children of parental alcohol misusers are linked in to appropriate local children’s services to meet their needs"]
[null,"●      the treatment system offers rapid access, appropriate assessment and care planning to support parents who misuse alcohol as well as signposting to early help"]
[null,"●      routine enquiry is made about parental status on presentation into treatment. Effective referral pathways are in place with C&F services to respond when there are safeguarding issues and with troubled family provision when alcohol misuse is identified as a factor."]
["11.6 Systems are in place to ensure effective care co-ordination for alcohol dependent individuals with multiple need","Indicators of strong practice: "]
[null,"●      there are agreed referral routes and effective communication and joint working arrangements between the range of frontline service providers to enable delivery of holistic packages of concurrent care to address the multiple needs of alcohol misusers (including physical and mental ill-health and welfare need)"]
[null,"●     information is shared routinely to support effective care delivery, continuity of care and risk management"]
[null,"●      care plans are holistic based on comprehensive assessment of need and supported by regular joint reviews"]
[null,"●      alcohol dependent individuals with complex need are assertively engaged to sustain them in meaningful contact with treatment and wider support services until their needs have been met."]

{"sheet":"Good Children and Young People","index":22,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":true,"merged":[[5,0,15,0],[17,0,32,0],[34,0,44,0],[45,0,57,0]]}
["Challenging your services","Supporting children and young people"]
["Context","Data and metrics to corroborate your evidence"]
["This section encourages partnerships to consider the range and quality of support available locally to educate children and young people about alcohol and the harm it can cause, to strengthen resilience and address the risk factors and vulnerabilities which increase the likelihood of young people misusing alcohol and also reviews the extent to which there are appropriate, effective, timely and evidence-based specialist interventions for young people already experiencing alcohol-related harm. ","The key indicator supporting a locality to assess the impact of activity is the rate of under 18 hospital admission episodes for alcohol-specific conditions. Beneath this is a range of local data sources held by children’s services (education and social care), the police and youth justice system and NDTMS activity reporting to support in-depth analysis of the strengths and opportunities for development within children's delivery.    "]
["Attribute/Criteria","Pointers to help you rate your evidence"]
["12. How does the partnership work to prevent or delay the onset of drinking in young people?"]
["12.1 Accurate information and advice about the range of harms associated with alcohol is available to children and young people and their families","Indicators of strong practice:"]
[null,"●      schools and colleges are aware of NICE guidelines and quality standards and offered support to improve practice around the delivery of alcohol education"]
[null,"●      alcohol education is widely available in schools and colleges, either through the curriculum or through a whole-school approach. Intelligence-led targeted sessions are delivered at all stages within the school environment and these are offered by a range of staff in direct contact with young people"]
[null,"●      mechanisms are in place locally to evaluate the impact of this whole school approach to prevention"]
[null,"●      training is offered to all professionals working with young people, regardless of setting, to ensure an evidence-based coordinated approach and a consistency of messages"]
[null,"●      activity data is shared across the system to ensure there are no gaps in delivery, and the partnership has oversight of all opportunities for disseminating relevant information"]
[null,"●      the quality of this information is reviewed regularly both by individual organisations and system wide governance structures"]
[null,"●      alcohol education and information (written and verbal) is tailored for different age groups and takes different learning needs into account"]
[null,"●      written materials about alcohol harm are available in a range of settings including primary care, universities and other public buildings"]
[null,"●      the content of leaflets and the structured prevention programmes offered locally are reviewed against the evidence on a regular basis and updated as required"]
[null,"●      schools and colleges involve parents, carers, children and young people in initiatives to reduce alcohol use."]
["13. How does the partnership work to reduce alcohol-related harm in vulnerable groups of young people?"]
["13.1 Vulnerable children identified as at increased risk of alcohol harm are targeted for evidence-based interventions to strengthen their resilience","Indicators of strong practice:"]
[null,"●      protocols are in place to safeguard vulnerable young people who the evidence indicates are at most risk of alcohol harm including:"]
[null,"○   those known to youth offending services"]
[null,"○   those in contact with pupil referral units"]
[null,"○   homeless young people"]
[null,"○   looked after children"]
[null,"○   truants and excludees"]
[null,"○   those not in education, training and employment"]
[null,"○   those deemed to be at risk of gang membership or susceptible to child sexual exploitation"]
[null,"○   the children of parental alcohol/drug misusers"]
[null,"●      professionals in contact with these (and other) vulnerable groups carry out routine screening using a validated tool to identify need and offer brief interventions and advice or brief treatment to those aged 16/17 identified as drinking at above low risk levels"]
[null,"●     targeted brief interventions are offered in A&E, GP practices and by school nurses"]
[null,"●      all brief interventions reflect the evidence base and approaches are aligned with other services serving the same at-risk groups"]
[null,"●      this work is fully integrated with wider early interventions plans/strategies with a discrete budget and clearly agreed success criteria against which activity is measured"]
[null,"●      the propensity to misuse alcohol is understood and addressed in the context of other health inequalities. The focus of these targeted interventions is on building resilience and supporting the development of techniques to reduce risk"]
[null,"●      there are agreed thresholds and pathways for onward referral by mainstream services for assessment by specialist treatment."]
["14. Does the partnership have systems in place locally to support young people with alcohol-related problems?"]
["14.1 Under 18s in need of structured treatment can access specialist treatment services offering a range of good quality, evidence-based interventions","Indicators of strong practice:"]
[null,"●      the full range of evidence-based interventions as specified in relevant NICE guidance (PH24, CG115, QS11 and NG58) is available to children in need of specialist alcohol treatment across the locality, enabling providers to offer customised packages of care-planned support shaped by the findings of a comprehensive assessment of need"]
[null,"●      interventions delivered are appropriate to the age, development and individual vulnerabilities of the child, and vary in intensity and duration according to changing need"]
[null,"●      there is a quality governance framework in place setting out expectations around:"]
[null,"○   quality standards"]
[null,"○   risk management"]
[null,"○   clinical governance including staff competence"]
[null,"○   clinical supervision"]
[null,"○   compliance with safeguarding policies and legal requirements"]
[null,"●      there is a local system of quality assurance through regular case file audit and service user feedback, reviewed within contact monitoring arrangements and reported back through the local authority governance structure"]
[null,"●      systems are also in place to monitor the adherence to confidentiality policies, and to support the gaining of consent from parents and carers for interventions with under 16s."]
["14.2 There are effective and well-promoted pathways into, through and out of specialist treatment services for under 18s","Indicators of strong practice:"]
[null,"●      young people’s specialist treatment services are delivered flexibly; services open at accessible times, in appropriate settings and locations"]
[null,"●      access points and referral pathways are clearly articulated to young people, their parents and carers and to the public"]
[null,"●      referral pathways are promoted widely to practitioners in universal and targeted children’s services"]
[null,"●      these pathways are supported by explicit information governance agreements across services to ensure that information is shared routinely to support effective care delivery and risk management"]
[null,"●     there are reciprocal arrangements supported by protocols clarifying roles and responsibilities in the referral process and joint working has been agreed between mainstream children’s services and specialist treatment supporting the delivery of holistic interventions to address wider health and social care need"]
[null,"●      multi-agency packages of care are effectively co-ordinated to ensure higher intensity support for the most vulnerable young people especially those with mental ill-health, looked after children and those in contact with the youth justice system"]
[null,"●      transitional arrangements have been agreed and policies are in place across local services setting out standards for effective transfers from:"]
[null,"○   hospitals"]
[null,"○   inpatient facilities"]
[null,"○   CYP secure estate"]
[null,"○   other frontline services including CAMHs and adult provision to ensure continuity of care and to smooth the journey into and out of the treatment system"]
[null,"●      universal and targeted services support young people discharged from substance misuse specialist services and can respond to ongoing health and social needs."]

{"sheet":"(S3) Children and Young People","index":23,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,2],[4,1,4,2],[6,1,6,2],[2,1,2,2]]}
[]
[]
[null,"12. How does the partnership work to prevent or delay the onset of drinking in young people?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )",null,"Peer review score\n\n(not for local use )"]
[null,12.1,"Accurate information and advice about the range of harms associated with alcohol is available to children and young people and their families\n\n"]
[null,"13. How does the partnership work to reduce alcohol–related harm in vulnerable groups of young people?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,13.1,"Vulnerable children identified as at increased risk of alcohol harm are targeted for evidence-based interventions to strengthen their resilience\n\n"]
[null,"14. Does the partnership have systems in place locally to support young people with alcohol-related problems?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,14.1,"Under 18s in need of structured treatment can access specialist treatment services offering a range of good quality, evidence-based interventions\n\n"]
[null,14.2,"There are effective and well-promoted pathways into, through and out of specialist treatment services for under 18s\n\n"]
[null,null,"Total score for children and young people:",{"$f":"Score!J24","v":0}]
[null,null,"< PREVIOUS PAGE",null,"NEXT PAGE >"]

{"sheet":"Good Data and Innovation","index":24,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":true,"merged":[[5,0,8,0],[9,0,12,0],[13,0,21,0],[2,0,2,1]]}
["Challenging your services","Data, innovation and learning"]
["Context"]
["This section affords the partnership the opportunity to reflect on creative local responses to emerging need, to understand how available data is used to enhance understanding of the impact of local activity, and to consider how innovative and resourceful solutions are evaluated and learning from this is disseminated to inform local practice."]
["Attribute/Criteria","Pointers to help you rate your evidence"]
["15. How does the partnership ensure it understands the impact of activity to address identified need and embeds learning from innovative practice?"]
["15.1 There is a co-ordinated approach to data collation, analysis and dissemination which informs local actions to reduce alcohol harm","Indicators of strong practice:"]
[null,"●      systems and protocols are in place for the routine sharing of data reports across key partner agencies and strategy groups"]
[null,"●      activity data is analysed and monitored and considered in the context of indicators of alcohol harm to understand the extent to which local provision is having an impact"]
[null,"●      progress against agreed priorities is reviewed systematically and the strategy/action plan is adjusted accordingly."]
["15.2 New technologies are used to raise awareness, to support delivery and to extend reach","Indicators of strong practice:"]
[null,"●      there is a willingness to test new technological approaches to engage with new audiences and the impact of this is evaluated"]
[null,"●      online tools are used to spread the message about alcohol harm more widely, to tailor the advice offered about the risk associated with the individual’s consumption and to signpost new audiences to appropriate support "]
[null,"●      online referral advice and electronic triage systems encourage improved access into the treatment system."]
["15.3 Systems are in place to evaluate the impact of creative solutions adopted to meet emerging local need","Indicators of strong practice:"]
[null,"●      partners share information about emerging local issues and agree a coherent approach to addressing these"]
[null,"●      the partnership demonstrates a readiness to try out new and creative approaches to problem solving in response to new and emerging need"]
[null,"●      all activity is robustly evaluated to measure impact with evaluation criteria agreed from the outset"]
[null,"●      evaluation is used to ensure value for money in local practice"]
[null,"●     learning from evaluation is disseminated to partners to inform future activity"]
[null,"●      mechanisms are in place to share and embed practitioner learning in order to shape changes in practice coming from:"]
[null,"○   safeguarding reviews"]
[null,"○   serious incident reporting."]

{"sheet":"(S3) Data and Innovation","index":25,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,1,2,2]]}
[]
[]
[null,"15. How does the partnership ensure it understands the impact of activity to address identified need and embeds learning from innovative practice?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,15.1,"There is a co-ordinated approach to data collation, analysis and dissemination which informs local actions to reduce alcohol harm\n"]
[null,15.2,"New technologies are used to raise awareness, to support delivery and to extend reach\n\n"]
[null,15.3,"Systems are in place to evaluate the impact of creative solutions adopted to meet emerging local need\n\n"]
[null,null,"Total score for data innovation and learning:",{"$f":"Score!N23","v":0}]
[null,null,"< PREVIOUS PAGE",null,"NEXT PAGE >"]

{"sheet":"(S4) Results","index":26,"n_rows":39,"n_cols":248,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,2],[24,1,24,2],[33,1,33,2],[4,1,4,6],[13,1,13,6],[25,1,25,6],[3,1,3,2],[16,1,16,6],[27,1,27,6],[20,1,20,6],[10,1,10,6],[29,1,29,6],[30,1,30,6],[32,1,32,6],[2,1,2,6]]}
[]
[]
[null,"Achieving Positive Outcomes"]
[null,"16. How does the partnership demonstrate that the alcohol strategy/delivery plan is working to reduce alcohol-related harm in the general population?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,"From PHE fingertips LAPE\nTrends for the following indicators show a reduction or are rising less steeply in your area"]
[null,16.100000000000001,"The rate of alcohol-related hospital admissions (narrow measure) for adults \n\n"]
[null,16.2,"The rate of alcohol-specific hospital admissions for under 18s \n\n\n"]
[null,16.3,"The rate of years of life lost due to alcohol-related conditions in under 75s \n\n"]
[null,16.399999999999999,"The rate of alcohol-specific mortality \n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,16.5,"The rate of premature mortality from alcoholic liver disease\n\n"]
[null,"For the following indicators you can benchmark your current position against CIPFA neighbours, regional or national comparators or (where trend data is available) consider local direction of travel: trends for the following should show a reduction over time"]
[null,16.600000000000001,"The proportion of the local adult population that report binge drinking on their heaviest drinking day \n\n"]
[null,16.7,"The proportion of the local adult population that report drinking over 14 units of alcohol a week \n\n"]
[null,"From local health data sources including the General Practice Extraction Service (GPES), local hospital data and the CCG outcomes indicator set\nTrends for the following indicators show an increase or are falling less steeply in your area"]
[null,16.8,"Local (GPES) data on the number of newly registered patients and NHS health check recipients asked the alcohol risk question and given brief advice or onward referral as appropriate\n[relevant SNOMED/READ codes set out on pages 7/8 in GMS contract guidance audit requirements. See section 6 for hyperlink]\n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,16.899999999999999,"Activity data from secondary care settings on the number of patients offered identification and brief advice or onward referral as appropriate \n\n"]
[null,"Trends for the following indicators show a reduction or are rising less steeply in your area"]
[null,16.100000000000001,"CCG hospital data for the rate of emergency admissions for alcohol-related liver disease in those aged 19+ \n\n"]
[null,16.11,"CCG hospital data for the rate of alcohol-specific hospital admissions \n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,16.12,"CCG outcomes indicator set data for the rate of emergency alcohol-specific re-admission to any hospital within 30 days of discharge following an alcohol-specific hospital admission\n\n"]
[null,"From local police and crime and other criminal justice data sources"]
[null,16.13,"Police and crime data about the rate of domestic violence offences tagged as alcohol-related \n\n"]
[null,16.14,"Police and crime data about the rate of violent offences tagged as alcohol-related \n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,16.149999999999999,"National Probation Service and Community Rehabilitation Company data measuring the incidence of alcohol-related re-offending\n\n"]
[null,"17. How does the partnership demonstrate that the alcohol strategy/delivery plan is working to reduce alcohol-related harm in the alcohol dependent population?",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,"From the public health dashboard (based on NDTMS activity reporting)\nTrends for the following indicator show a reduction or are rising less steeply in your area"]
[null,17.100000000000001,"The proportion of adults estimated to be alcohol dependent that are not in treatment \n\n"]
[null,"Trends for the following indicator show an increase or are falling less steeply in your area:"]
[null,17.2,"The proportion of alcohol clients successfully completing alcohol treatment and not re-presenting within 6 months of discharge\n\n"]
[null,"From the parental drug and alcohol use toolkit for local authorities [see section 6 for hyperlink]\nFor the following indicator you can benchmark your current position against the national comparator or (where trend data is available) consider local direction of travel: \n trends should show a reduction over time"]
[]
[null,17.3,"The proportion of parents estimated to be alcohol dependent that are not in treatment\n\n"]
[null,"Your Priority Indicators"]
[null,"18. Can you demonstrate progress against your local reducing alcohol harm objectives? (as identified in section 1) ",null,"Self-assessment score","Brief comments and references","Actions","Peer review score\n(not for local use )"]
[null,18.100000000000001,"1st objective – evidence of progress?\n\n\n"]
[null,18.2,"2nd objective – evidence of progress?\n\n\n"]
[null,18.3,"3rd objective – evidence of progress?\n\n\n"]
[null,null,"Total score for results:",{"$f":"Score!R41","v":0}]
[null,null,"< PREVIOUS PAGE",null,"NEXT PAGE >"]

{"sheet":"Good Results","index":27,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[[6,0,6,1],[5,0,5,1],[7,0,7,1]]}
["Results","Achieving positive outcomes"]
["Context","Data and metrics to corroborate your evidence"]
["Reducing alcohol harm requires a multi-component, integrated response from across the system. \nWithin this section partnerships are asked to consider whether there is evidence that alcohol harm is increasing or reducing. Analysis of national indicators and local data sources will show whether current activity, and the arrangements underpinning it, are having a positive impact and supporting local ambition to reduce alcohol harm across health, crime, social care and economic priorities.\n\n\n\n","Partnerships are encouraged to:\n• take account of how they monitor and report on progress against agreed priorities and identify gaps in local intelligence that could be addressed\n• map which national datasets and locally held intelligence can be used to validate the evidence presented in the previous sections\n• identify trends in performance and benchmark local indicators against national or regional average performance.\nA review of process measures and qualitative feedback can also enhance partnership understanding of progress and opportunties for further development.\nEvidence of improving trends against the national and local indicators reviewed in the results section suggests progress in terms of reducing alcohol-related harm across the locality. If, however there are indications of declining performance against any of these measures, the locality is encouraged to investigate further, examining available data sources which offer more information to help partnerships diagnose the issues and determine what actions are needed to reverse the trend and improve outcomes locally.\n"]
["Attribute/criteria","Pointers to help you rate your evidence"]
["How does the partnership demonstrate that the alcohol strategy/delivery plan is working to reduce alcohol-related harm?"]
["Indicators of strong performance: "]
["If operational activity and the arrangements in place to support local delivery are effective and are contributing to an overall reduction in alcohol-related harm across health, crime and social care priorities, the partnership will see, over time, evidence of:\n• an environment that supports low risk drinking for those who choose to drink\n• reduced levels of risky consumption among adults \n• a reduction in alcohol-related health inequalities (Rates of alcohol-specific and related mortality increase as levels of deprivation increase and alcohol-related liver disease is strongly related to the socioeconomic gradient. Effective targeting of interventions will support a narrowing of the gap in health outcomes. LAPE data breaks down key indicators into deciles of deprivation) \n• reduced rates of alcohol-related crime and disorder \n• increased levels of identification of need and delivery of interventions to those already experiencing alcohol-related harm\n• reduced rates of unmet need for treatment among the estimated alcohol dependent population \n• increased access into the treatment system of parents who are alcohol dependent\n• an increased rate of recovery from alcohol dependence."]

{"sheet":"(S5) Scoring","index":28,"n_rows":63,"n_cols":6,"rows_kept":63,"cut":false,"hidden":false,"merged":[[34,3,34,4],[6,2,6,5],[11,1,11,5],[14,2,14,5],[19,2,19,5],[26,2,26,5],[29,1,29,5]]}
[]
[]
[]
[]
[]
[]
[null," CLeaR domain","Evidence of achievement"]
[null,null,"Max score","Self-assessment score","% of max score","Peer review score"]
[null,"Leadership",46,{"$f":"D17+D18+D19","v":0},{"$f":"(D9/C9)","v":0},{"$f":"Score!C30","v":0}]
[null,"Challenge your services",44,{"$f":"SUM(D21:D26)","v":0},{"$f":"(D10/C10)","v":0},{"$f":"Score!C31","v":0}]
[null,"Results",42,{"$f":"SUM(D28:D29)","v":0},{"$f":"(D11/C11)","v":0},{"$f":"Score!C32","v":0}]
[]
[null,"Total score",{"$f":"SUM(C9:C11)","v":132},{"$f":"SUM(D9:D11)","v":0},{"$f":"(D13/C13)","v":0},{"$f":"Score!C33","v":0}]
[]
[null," CLeaR domain","Evidence of achievement"]
[null,"Leadership","Max score","Self-assessment score","% of max score","% of peer review score"]
[null,"Vision and governance",12,{"$f":"'(S2) Vision and Governance'!D11","v":0},{"$f":"(D17/C17)","v":0},{"$f":"(Score!C9/12)","v":0}]
[null,"Partnership",20,{"$f":"'(S2) Partnership'!D16","v":0},{"$f":"(D18/C18)","v":0},{"$f":"(Score!G14/C18)","v":0}]
[null,"Planning and commissioning",14,{"$f":"'(S2) Planning & Commissioning'!D12","v":0},{"$f":"(D19/C19)","v":0},{"$f":"(Score!K10/C19)","v":0}]
[null,"Challenge your services"]
[null,"Communications and social marketing",6,{"$f":"'(S3) Communications'!D7","v":0},{"$f":"(D21/C21)","v":0},{"$f":"(Score!O6/C21)","v":0}]
[null,"Primary prevention",6,{"$f":"'(S3) Primary Prevention'!D7","v":0},0,{"$f":"(Score!S6/C22)","v":0}]
[null,"Secondary prevention",6,{"$f":"'(S3) Secondary Prevention'!D7","v":0},0,{"$f":"(Score!C23/C23)","v":0}]
[null,"Tertiary prevention",12,{"$f":"'(S3) Tertiary Prevention'!D10","v":0},0,{"$f":"(Score!G26/C24)","v":0}]
[null,"Supporting children and young people",8,{"$f":"'(S3) Children and Young People'!D10","v":0},0,{"$f":"(Score!K24/C25)","v":0}]
[null,"Data, innovation and learning",6,{"$f":"'(S3) Data and Innovation'!D7","v":0},0,{"$f":"(Score!O23/C26)","v":0}]
[null,"Results"]
[null,"Achieving positive outcomes ",36,{"$f":"Score!R43","v":0},{"$f":"(D28/C28)","v":0},{"$f":"(Score!S43/C28)","v":0}]
[null,"Your priority indicators",6,{"$f":"Score!R42","v":0},{"$f":"(D29/C29)","v":0},{"$f":"(Score!S42/C29)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"< PREVIOUS PAGE","NEXT PAGE>"]

{"sheet":"(S6) Resources","index":29,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,1,12,1],[1,1,2,2],[4,1,4,3]]}
[]
[null,"Resources "]
[]
[]
[null,"Good practice guidance and resources\n\n\n"]
[]
[null,"Drug and alcohol guidance - information and other resources to support commissioners, service providers and others providing alcohol and drug interventions","alcohol and drug misuse prevention and treatment guidance"]
[null,"Licensing - guidance to help public health teams make local decisions about alcohol licensing","alcohol licensing and public health data and information tools"]
[null,"These alcohol use screening tests can be used by health professionals as a tool to assess a service user's level of risk to alcohol harm","alcohol use screening tests"]
[null,"Nice alcohol pathway","NICE alcohol pathway"]
[null,"CMO revised alcohol consumption guidelines","revised CMO alcohol guidelines"]
[null,"CQC specialist substance misuse services – provider handbook ","CQC SM provider handbook"]
[null,null,"CQC SM provider handbook appendices"]
[null,"WHO - guidance for addressing inequities in alcohol-related harm","alcohol and inequities"]
[null,"GPES alcohol guidance and snomed/read codes","GMS contract Guidance audit requirements"]
[null,"Parental alcohol and drug use toolkit for local authorities: understanding the problem","parental alcohol and drug use"]
[null,"PHE fingertips Local Alcohol Profiles for England (LAPE)","local alcohol profiles"]
[null,"PHE fingertips Liver Disease Profiles","liver disease"]
[null,"PH dashboard","public health dashboard"]
[null,"PH outcomes framework","public health outcomes framework"]
[null,"NDTMS: structured alcohol treatment","ndtms.net"]
[]
[null,"< PREVIOUS PAGE"]

{"sheet":"Sheet1","index":30,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[null,"Self-assessment score","Peer review score\n(not for local use )"]
[]
[]
[null,"No evidence (score 0)",0]
[null,"Some evidence (score 1)",1]
[null,"Strong evidence (score 2)",2]

{"sheet":"Score","index":31,"n_rows":43,"n_cols":19,"rows_kept":43,"cut":false,"hidden":true,"merged":[[4,5,4,6]]}
[]
["Questions","(S2) Vision and Governance","Peer review score",null,"Questions","(S2) Partnership","Peer review score",null,"Questions","(S2) Planning & Commissioning","Peer review score",null,"Questions","Communications","Peer review score",null,"Questions","Primary Prevention","Peer review score"]
[2.1,{"$f":"IF('(S2) Vision and Governance'!D4=\"No evidence (score 0)\",0,IF('(S2) Vision and Governance'!D4=\"Some evidence (score 1)\",1,IF('(S2) Vision and Governance'!D4=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"'(S2) Vision and Governance'!G4","v":0},null,4.0999999999999996,{"$f":"IF('(S2) Partnership'!D4=\"No evidence (score 0)\",0,IF('(S2) Partnership'!D4=\"Some evidence (score 1)\",1,IF('(S2) Partnership'!D4=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Partnership'!G4=0,0,IF('(S2) Partnership'!G4=1,1,IF('(S2) Partnership'!G4=2,2,\" \")))","v":0},null,6.1,{"$f":"IF('(S2) Planning & Commissioning'!D4=\"No evidence (score 0)\",0,IF('(S2) Planning & Commissioning'!D4=\"Some evidence (score 1)\",1,IF('(S2) Planning & Commissioning'!D4=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Planning & Commissioning'!G4=0,0,IF('(S2) Planning & Commissioning'!G4=1,1,IF('(S2) Planning & Commissioning'!G4=2,2,\" \")))","v":0},null,8.1,{"$f":"IF('(S3) Communications'!D4=\"No evidence (score 0)\",0,IF('(S3) Communications'!D4=\"Some evidence (score 1)\",1,IF('(S3) Communications'!D4=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Communications'!G4=0,0,IF('(S3) Communications'!G4=1,1,IF('(S3) Communications'!G4=2,2,\" \")))","v":0},null,9.1,{"$f":"IF('(S3) Primary Prevention'!D4=\"No evidence (score 0)\",0,IF('(S3) Primary Prevention'!D4=\"Some evidence (score 1)\",1,IF('(S3) Primary Prevention'!D4=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Primary Prevention'!G4=0,0,IF('(S3) Primary Prevention'!G4=1,1,IF('(S3) Primary Prevention'!G4=2,2,\" \")))","v":0}]
[2.2000000000000002,{"$f":"IF('(S2) Vision and Governance'!D5=\"No evidence (score 0)\",0,IF('(S2) Vision and Governance'!D5=\"Some evidence (score 1)\",1,IF('(S2) Vision and Governance'!D5=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"'(S2) Vision and Governance'!G5","v":0},null,4.2,{"$f":"IF('(S2) Partnership'!D5=\"No evidence (score 0)\",0,IF('(S2) Partnership'!D5=\"Some evidence (score 1)\",1,IF('(S2) Partnership'!D5=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Partnership'!G5=0,0,IF('(S2) Partnership'!G5= 1,1,IF('(S2) Partnership'!G5=2,2,\" \")))","v":0},null,6.2,{"$f":"IF('(S2) Planning & Commissioning'!D5=\"No evidence (score 0)\",0,IF('(S2) Planning & Commissioning'!D5=\"Some evidence (score 1)\",1,IF('(S2) Planning & Commissioning'!D5=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Planning & Commissioning'!G5=0,0,IF('(S2) Planning & Commissioning'!G5=1,1,IF('(S2) Planning & Commissioning'!G5=2,2,\" \")))","v":0},null,8.1999999999999993,{"$f":"IF('(S3) Communications'!D5=\"No evidence (score 0)\",0,IF('(S3) Communications'!D5=\"Some evidence (score 1)\",1,IF('(S3) Communications'!D5=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Communications'!G5=0,0,IF('(S3) Communications'!G5=1,1,IF('(S3) Communications'!G5=2,2,\" \")))","v":0},null,9.1999999999999993,{"$f":"IF('(S3) Primary Prevention'!D5=\"No evidence (score 0)\",0,IF('(S3) Primary Prevention'!D5=\"Some evidence (score 1)\",1,IF('(S3) Primary Prevention'!D5=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Primary Prevention'!G5=0,0,IF('(S3) Primary Prevention'!G5=1,1,IF('(S3) Primary Prevention'!G5=2,2,\" \")))","v":0}]
[3.1,{"$f":"IF('(S2) Vision and Governance'!D7=\"No evidence (score 0)\",0,IF('(S2) Vision and Governance'!D7=\"Some evidence (score 1)\",1,IF('(S2) Vision and Governance'!D7=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"'(S2) Vision and Governance'!G7","v":0},null,5.0999999999999996,null,null,null,6.3,{"$f":"IF('(S2) Planning & Commissioning'!D6=\"No evidence (score 0)\",0,IF('(S2) Planning & Commissioning'!D6=\"Some evidence (score 1)\",1,IF('(S2) Planning & Commissioning'!D6=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Planning & Commissioning'!G6=0,0,IF('(S2) Planning & Commissioning'!G6=1,1,IF('(S2) Planning & Commissioning'!G6=2,2,\" \")))","v":0},null,8.3000000000000007,{"$f":"IF('(S3) Communications'!D6=\"No evidence (score 0)\",0,IF('(S3) Communications'!D6=\"Some evidence (score 1)\",1,IF('(S3) Communications'!D6=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Communications'!G6=0,0,IF('(S3) Communications'!G6=1,1,IF('(S3) Communications'!G6=2,2,\" \")))","v":0},null,9.3000000000000007,{"$f":"IF('(S3) Primary Prevention'!D6=\"No evidence (score 0)\",0,IF('(S3) Primary Prevention'!D6=\"Some evidence (score 1)\",1,IF('(S3) Primary Prevention'!D6=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Primary Prevention'!G6=0,0,IF('(S3) Primary Prevention'!G6=1,1,IF('(S3) Primary Prevention'!G6=2,2,\" \")))","v":0}]
[3.2,{"$f":"IF('(S2) Vision and Governance'!D8=\"No evidence (score 0)\",0,IF('(S2) Vision and Governance'!D8=\"Some evidence (score 1)\",1,IF('(S2) Vision and Governance'!D8=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"'(S2) Vision and Governance'!G7","v":0},null,"5.1.1",{"$f":"IF('(S2) Partnership'!D8=\"No evidence (score 0)\",0,IF('(S2) Partnership'!D8=\"Some evidence (score 1)\",1,IF('(S2) Partnership'!D8=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Partnership'!G8=0,0,IF('(S2) Partnership'!G8= 1,1,IF('(S2) Partnership'!G8=2,2,\" \")))","v":0},null,6.4,{"$f":"IF('(S2) Planning & Commissioning'!D7=\"No evidence (score 0)\",0,IF('(S2) Planning & Commissioning'!D7=\"Some evidence (score 1)\",1,IF('(S2) Planning & Commissioning'!D7=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Planning & Commissioning'!G7=0,0,IF('(S2) Planning & Commissioning'!G7=1,1,IF('(S2) Planning & Commissioning'!G7=2,2,\" \")))","v":0},null,"Sum",{"$f":"SUM(N3:N5)","v":0},{"$f":"SUM(O3:O5)","v":0},null,"Sum",{"$f":"SUM(R3:R5)","v":0},{"$f":"SUM(S3:S5)","v":0}]
[3.3,{"$f":"IF('(S2) Vision and Governance'!D9=\"No evidence (score 0)\",0,IF('(S2) Vision and Governance'!D9=\"Some evidence (score 1)\",1,IF('(S2) Vision and Governance'!D9=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"'(S2) Vision and Governance'!G8","v":0},null,"5.1.2",{"$f":"IF('(S2) Partnership'!D9=\"No evidence (score 0)\",0,IF('(S2) Partnership'!D9=\"Some evidence (score 1)\",1,IF('(S2) Partnership'!D9=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Partnership'!G9= 0,0,IF('(S2) Partnership'!G9=1,1,IF('(S2) Partnership'!G9=2,2,\" \")))","v":0},null,7.1,{"$f":"IF('(S2) Planning & Commissioning'!D9=\"No evidence (score 0)\",0,IF('(S2) Planning & Commissioning'!D9=\"Some evidence (score 1)\",1,IF('(S2) Planning & Commissioning'!D9=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Planning & Commissioning'!G9=0,0,IF('(S2) Planning & Commissioning'!G9=1,1,IF('(S2) Planning & Commissioning'!G9=2,2,\" \")))","v":0}]
[3.4,{"$f":"IF('(S2) Vision and Governance'!D10=\"No evidence (score 0)\",0,IF('(S2) Vision and Governance'!D10=\"Some evidence (score 1)\",1,IF('(S2) Vision and Governance'!D10=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"'(S2) Vision and Governance'!G9","v":0},null,"5.1.3",{"$f":"IF('(S2) Partnership'!D10=\"No evidence (score 0)\",0,IF('(S2) Partnership'!D10=\"Some evidence (score 1)\",1,IF('(S2) Partnership'!D10=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Partnership'!G10=0,0,IF('(S2) Partnership'!G10=1,1,IF('(S2) Partnership'!G10=2,2,\" \")))","v":0},null,7.2,{"$f":"IF('(S2) Planning & Commissioning'!D10=\"No evidence (score 0)\",0,IF('(S2) Planning & Commissioning'!D10=\"Some evidence (score 1)\",1,IF('(S2) Planning & Commissioning'!D10=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Planning & Commissioning'!G10=0,0,IF('(S2) Planning & Commissioning'!G10=1,1,IF('(S2) Planning & Commissioning'!G10=2,2,\" \")))","v":0}]
["Sum",{"$f":"SUM(B3:B8)","v":0},{"$f":"SUM(C3:C8)","v":0},null,"5.1.4",{"$f":"IF('(S2) Partnership'!D11=\"No evidence (score 0)\",0,IF('(S2) Partnership'!D11=\"Some evidence (score 1)\",1,IF('(S2) Partnership'!D11=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Partnership'!G11=0,0,IF('(S2) Partnership'!G11=1,1,IF('(S2) Partnership'!G11=2,2,\" \")))","v":0},null,7.3,{"$f":"IF('(S2) Planning & Commissioning'!D11=\"No evidence (score 0)\",0,IF('(S2) Planning & Commissioning'!D11=\"Some evidence (score 1)\",1,IF('(S2) Planning & Commissioning'!D11=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Planning & Commissioning'!G11=0,0,IF('(S2) Planning & Commissioning'!G11=1,1,IF('(S2) Planning & Commissioning'!G11=2,2,\" \")))","v":0}]
[null,null,null,null,"5.1.5",{"$f":"IF('(S2) Partnership'!D12=\"No evidence (score 0)\",0,IF('(S2) Partnership'!D12=\"Some evidence (score 1)\",1,IF('(S2) Partnership'!D12=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Partnership'!G12=0,0,IF('(S2) Partnership'!G12=1,1,IF('(S2) Partnership'!G12=2,2,\" \")))","v":0},null,"Sum",{"$f":"SUM(J3:J9)","v":0},{"$f":"SUM(K3:K9)","v":0}]
[null,null,null,null,"5.1.6",{"$f":"IF('(S2) Partnership'!D13=\"No evidence (score 0)\",0,IF('(S2) Partnership'!D13=\"Some evidence (score 1)\",1,IF('(S2) Partnership'!D13=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Partnership'!G13=0,0,IF('(S2) Partnership'!G13=1,1,IF('(S2) Partnership'!G13=2,2,\" \")))","v":0}]
[null,null,null,null,"5.1.7",{"$f":"IF('(S2) Partnership'!D14=\"No evidence (score 0)\",0,IF('(S2) Partnership'!D14=\"Some evidence (score 1)\",1,IF('(S2) Partnership'!D14=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Partnership'!G14=0,0,IF('(S2) Partnership'!G14=1,1,IF('(S2) Partnership'!G14=2,2,\" \")))","v":0}]
[null,null,null,null,"5.1.8",{"$f":"IF('(S2) Partnership'!D15=\"No evidence (score 0)\",0,IF('(S2) Partnership'!D15=\"Some evidence (score 1)\",1,IF('(S2) Partnership'!D15=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S2) Partnership'!G15=0,0,IF('(S2) Partnership'!G15=1,1,IF('(S2) Partnership'!G15=2,2,\" \")))","v":0}]
[null,null,null,null,"Sum",{"$f":"SUM(F3:F13)","v":0},{"$f":"SUM(G3:G13)","v":0}]
[]
[]
[]
[]
["Questions","(S3) Secondary Prevention","Peer review score",null,"Questions","(S3) Tertiary Prevention","Peer review score",null,"Questions","(S3) Children and young people","Peer review score",null,"Questions","(S3) Data and Innovation","Peer review score",null,"Questions","(S4) Results","Peer review score"]
[10.1,{"$f":"IF('(S3) Secondary Prevention'!D4=\"No evidence (score 0)\",0,IF('(S3) Secondary Prevention'!D4=\"Some evidence (score 1)\",1,IF('(S3) Secondary Prevention'!D4=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Secondary Prevention'!G4=0,0,IF('(S3) Secondary Prevention'!G4=1,1,IF('(S3) Secondary Prevention'!G4=2,2,\" \")))","v":0},null,11.1,{"$f":"IF('(S3) Tertiary Prevention'!D4=\"No evidence (score 0)\",0,IF('(S3) Tertiary Prevention'!D4=\"Some evidence (score 1)\",1,IF('(S3) Tertiary Prevention'!D4=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Tertiary Prevention'!G4=0,0,IF('(S3) Tertiary Prevention'!G4=1,1,IF('(S3) Tertiary Prevention'!G4=2,2,\" \")))","v":0},null,12.1,{"$f":"IF('(S3) Children and Young People'!D4=\"No evidence (score 0)\",0,IF('(S3) Children and Young People'!D4=\"Some evidence (score 1)\",1,IF('(S3) Children and Young People'!D4=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Children and Young People'!G4=0,0,IF('(S3) Children and Young People'!G4=1,1,IF('(S3) Children and Young People'!G4=2,2,\" \")))","v":0},null,15.1,{"$f":"IF('(S3) Data and Innovation'!D4=\"No evidence (score 0)\",0,IF('(S3) Data and Innovation'!D4=\"Some evidence (score 1)\",1,IF('(S3) Data and Innovation'!D4=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Data and Innovation'!G4=0,0,IF('(S3) Data and Innovation'!G4=1,1,IF('(S3) Data and Innovation'!G4=2,2,\" \")))","v":0},null,16.100000000000001,{"$f":"IF('(S4) Results'!D6=\"No evidence (score 0)\",0,IF('(S4) Results'!D6=\"Some evidence (score 1)\",1,IF('(S4) Results'!D6=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G6=0,0,IF('(S4) Results'!G6=1,1,IF('(S4) Results'!G6=2,2,\" \")))","v":0}]
[10.199999999999999,{"$f":"IF('(S3) Secondary Prevention'!D5=\"No evidence (score 0)\",0,IF('(S3) Secondary Prevention'!D5=\"Some evidence (score 1)\",1,IF('(S3) Secondary Prevention'!D5=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Secondary Prevention'!G5=0,0,IF('(S3) Secondary Prevention'!G5=1,1,IF('(S3) Secondary Prevention'!G5=2,2,\" \")))","v":0},null,11.2,{"$f":"IF('(S3) Tertiary Prevention'!D5=\"No evidence (score 0)\",0,IF('(S3) Tertiary Prevention'!D5=\"Some evidence (score 1)\",1,IF('(S3) Tertiary Prevention'!D5=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Tertiary Prevention'!G5=0,0,IF('(S3) Tertiary Prevention'!G5=1,1,IF('(S3) Tertiary Prevention'!G5=2,2,\" \")))","v":0},null,13.1,{"$f":"IF('(S3) Children and Young People'!D6=\"No evidence (score 0)\",0,IF('(S3) Children and Young People'!D6=\"Some evidence (score 1)\",1,IF('(S3) Children and Young People'!D6=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Children and Young People'!G6=0,0,IF('(S3) Children and Young People'!G6=1,1,IF('(S3) Children and Young People'!G6=2,2,\" \")))","v":0},null,15.2,{"$f":"IF('(S3) Data and Innovation'!D5=\"No evidence (score 0)\",0,IF('(S3) Data and Innovation'!D5=\"Some evidence (score 1)\",1,IF('(S3) Data and Innovation'!D5=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Data and Innovation'!G5=0,0,IF('(S3) Data and Innovation'!G5=1,1,IF('(S3) Data and Innovation'!G5=2,2,\" \")))","v":0},null,16.2,{"$f":"IF('(S4) Results'!D7=\"No evidence (score 0)\",0,IF('(S4) Results'!D7=\"Some evidence (score 1)\",1,IF('(S4) Results'!D7=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G7=0,0,IF('(S4) Results'!G7=1,1,IF('(S4) Results'!G7=2,2,\" \")))","v":0}]
[10.3,{"$f":"IF('(S3) Secondary Prevention'!D6=\"No evidence (score 0)\",0,IF('(S3) Secondary Prevention'!D6=\"Some evidence (score 1)\",1,IF('(S3) Secondary Prevention'!D6=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Secondary Prevention'!G6=0,0,IF('(S3) Secondary Prevention'!G6=1,1,IF('(S3) Secondary Prevention'!G6=2,2,\" \")))","v":0},null,11.3,{"$f":"IF('(S3) Tertiary Prevention'!D6=\"No evidence (score 0)\",0,IF('(S3) Tertiary Prevention'!D6=\"Some evidence (score 1)\",1,IF('(S3) Tertiary Prevention'!D6=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Tertiary Prevention'!G6=0,0,IF('(S3) Tertiary Prevention'!G6=1,1,IF('(S3) Tertiary Prevention'!G6=2,2,\" \")))","v":0},null,14.1,{"$f":"IF('(S3) Children and Young People'!D8=\"No evidence (score 0)\",0,IF('(S3) Children and Young People'!D8=\"Some evidence (score 1)\",1,IF('(S3) Children and Young People'!D8=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Children and Young People'!G8=0,0,IF('(S3) Children and Young People'!G8=1,1,IF('(S3) Children and Young People'!G8=2,2,\" \")))","v":0},null,15.3,{"$f":"IF('(S3) Data and Innovation'!D6=\"No evidence (score 0)\",0,IF('(S3) Data and Innovation'!D6=\"Some evidence (score 1)\",1,IF('(S3) Data and Innovation'!D6=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Data and Innovation'!G6=0,0,IF('(S3) Data and Innovation'!G6=1,1,IF('(S3) Data and Innovation'!G6=2,2,\" \")))","v":0},null,16.3,{"$f":"IF('(S4) Results'!D8=\"No evidence (score 0)\",0,IF('(S4) Results'!D8=\"Some evidence (score 1)\",1,IF('(S4) Results'!D8=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G8=0,0,IF('(S4) Results'!G8=1,1,IF('(S4) Results'!G8=2,2,\" \")))","v":0}]
["Sum",{"$f":"SUM(B20:B22)","v":0},{"$f":"SUM(C20:C22)","v":0},null,11.4,{"$f":"IF('(S3) Tertiary Prevention'!D7=\"No evidence (score 0)\",0,IF('(S3) Tertiary Prevention'!D7=\"Some evidence (score 1)\",1,IF('(S3) Tertiary Prevention'!D7=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Tertiary Prevention'!G7=0,0,IF('(S3) Tertiary Prevention'!G7=1,1,IF('(S3) Tertiary Prevention'!G7=2,2,\" \")))","v":0},null,14.2,{"$f":"IF('(S3) Children and Young People'!D9=\"No evidence (score 0)\",0,IF('(S3) Children and Young People'!D9=\"Some evidence (score 1)\",1,IF('(S3) Children and Young People'!D9=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Children and Young People'!G9=0,0,IF('(S3) Children and Young People'!G9=1,1,IF('(S3) Children and Young People'!G9=2,2,\" \")))","v":0},null,"Sum",{"$f":"SUM(N20:N22)","v":0},{"$f":"SUM(O20:O22)","v":0},null,16.399999999999999,{"$f":"IF('(S4) Results'!D9=\"No evidence (score 0)\",0,IF('(S4) Results'!D9=\"Some evidence (score 1)\",1,IF('(S4) Results'!D9=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G9=0,0,IF('(S4) Results'!G9=1,1,IF('(S4) Results'!G9=2,2,\" \")))","v":0}]
[null,null,null,null,11.5,{"$f":"IF('(S3) Tertiary Prevention'!D8=\"No evidence (score 0)\",0,IF('(S3) Tertiary Prevention'!D8=\"Some evidence (score 1)\",1,IF('(S3) Tertiary Prevention'!D8=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Tertiary Prevention'!G8=0,0,IF('(S3) Tertiary Prevention'!G8=1,1,IF('(S3) Tertiary Prevention'!G8=2,2,\" \")))","v":0},null,"Sum",{"$f":"SUM(J20:J23)","v":0},{"$f":"SUM(K20:K23)","v":0},null,null,null,null,null,16.5,{"$f":"IF('(S4) Results'!D10=\"No evidence (score 0)\",0,IF('(S4) Results'!D10=\"Some evidence (score 1)\",1,IF('(S4) Results'!D10=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G10=0,0,IF('(S4) Results'!G10=1,1,IF('(S4) Results'!G10=2,2,\" \")))","v":0}]
[null,null,null,null,11.6,{"$f":"IF('(S3) Tertiary Prevention'!D9=\"No evidence (score 0)\",0,IF('(S3) Tertiary Prevention'!D9=\"Some evidence (score 1)\",1,IF('(S3) Tertiary Prevention'!D9=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S3) Tertiary Prevention'!G9=0,0,IF('(S3) Tertiary Prevention'!G9=1,1,IF('(S3) Tertiary Prevention'!G9=2,2,\" \")))","v":0},null,null,null,null,null,null,null,null,null,16.600000000000001,{"$f":"IF('(S4) Results'!D12=\"No evidence (score 0)\",0,IF('(S4) Results'!D12=\"Some evidence (score 1)\",1,IF('(S4) Results'!D12=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G12=0,0,IF('(S4) Results'!G12=1,1,IF('(S4) Results'!G12=2,2,\" \")))","v":0}]
[null,null,null,null,"Sum",{"$f":"SUM(F20:F25)","v":0},{"$f":"SUM(G20:G25)","v":0},null,null,null,null,null,null,null,null,null,16.7,{"$f":"IF('(S4) Results'!D13=\"No evidence (score 0)\",0,IF('(S4) Results'!D13=\"Some evidence (score 1)\",1,IF('(S4) Results'!D13=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G13=0,0,IF('(S4) Results'!G13=1,1,IF('(S4) Results'!G13=2,2,\" \")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.8,{"$f":"IF('(S4) Results'!D15=\"No evidence (score 0)\",0,IF('(S4) Results'!D15=\"Some evidence (score 1)\",1,IF('(S4) Results'!D15=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G15=0,0,IF('(S4) Results'!G15=1,1,IF('(S4) Results'!G15=2,2,\" \")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.899999999999999,{"$f":"IF('(S4) Results'!D16=\"No evidence (score 0)\",0,IF('(S4) Results'!D16=\"Some evidence (score 1)\",1,IF('(S4) Results'!D16=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G16=0,0,IF('(S4) Results'!G16=1,1,IF('(S4) Results'!G16=2,2,\" \")))","v":0}]
[null,null,"Peer review score %",null,null,null,null,null,null,null,null,null,null,null,null,null,16.100000000000001,{"$f":"IF('(S4) Results'!D18=\"No evidence (score 0)\",0,IF('(S4) Results'!D18=\"Some evidence (score 1)\",1,IF('(S4) Results'!D18=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G18=0,0,IF('(S4) Results'!G18=1,1,IF('(S4) Results'!G18=2,2,\" \")))","v":0}]
[null,"Leadership",{"$f":"((C9+G14+K10)/46)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,16.11,{"$f":"IF('(S4) Results'!D19=\"No evidence (score 0)\",0,IF('(S4) Results'!D19=\"Some evidence (score 1)\",1,IF('(S4) Results'!D19=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G19=0,0,IF('(S4) Results'!G19=1,1,IF('(S4) Results'!G19=2,2,\" \")))","v":0}]
[null,"Challenge your services",{"$f":"((O6+S6+C23+G26+K24+O23)/44)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,16.12,{"$f":"IF('(S4) Results'!D20=\"No evidence (score 0)\",0,IF('(S4) Results'!D20=\"Some evidence (score 1)\",1,IF('(S4) Results'!D20=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G20=0,0,IF('(S4) Results'!G20=1,1,IF('(S4) Results'!G20=2,2,\" \")))","v":0}]
[null,"Results",{"$f":"(S41/42)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,16.13,{"$f":"IF('(S4) Results'!D22=\"No evidence (score 0)\",0,IF('(S4) Results'!D22=\"Some evidence (score 1)\",1,IF('(S4) Results'!D22=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G22=0,0,IF('(S4) Results'!G22=1,1,IF('(S4) Results'!G22=2,2,\" \")))","v":0}]
[null,"Total",{"$f":"((C9+G14+K10+O6+S6+C23+G26+K24+O23+S41)/132)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,16.14,{"$f":"IF('(S4) Results'!D23=\"No evidence (score 0)\",0,IF('(S4) Results'!D23=\"Some evidence (score 1)\",1,IF('(S4) Results'!D23=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G23=0,0,IF('(S4) Results'!G23=1,1,IF('(S4) Results'!G23=2,2,\" \")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.149999999999999,{"$f":"IF('(S4) Results'!D24=\"No evidence (score 0)\",0,IF('(S4) Results'!D24=\"Some evidence (score 1)\",1,IF('(S4) Results'!D24=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G24=0,0,IF('(S4) Results'!G24=1,1,IF('(S4) Results'!G24=2,2,\" \")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.100000000000001,{"$f":"IF('(S4) Results'!D27=\"No evidence (score 0)\",0,IF('(S4) Results'!D27=\"Some evidence (score 1)\",1,IF('(S4) Results'!D27=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G27=0,0,IF('(S4) Results'!G27=1,1,IF('(S4) Results'!G27=2,2,\" \")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.2,{"$f":"IF('(S4) Results'!D29=\"No evidence (score 0)\",0,IF('(S4) Results'!D29=\"Some evidence (score 1)\",1,IF('(S4) Results'!D29=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G29=0,0,IF('(S4) Results'!G29=1,1,IF('(S4) Results'!G29=2,2,\" \")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.3,{"$f":"IF('(S4) Results'!D32=\"No evidence (score 0)\",0,IF('(S4) Results'!D32=\"Some evidence (score 1)\",1,IF('(S4) Results'!D32=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G32=0,0,IF('(S4) Results'!G32=1,1,IF('(S4) Results'!G32=2,2,\" \")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.100000000000001,{"$f":"IF('(S4) Results'!D35=\"No evidence (score 0)\",0,IF('(S4) Results'!D35=\"Some evidence (score 1)\",1,IF('(S4) Results'!D35=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G35=0,0,IF('(S4) Results'!G35=1,1,IF('(S4) Results'!G35=2,2,\" \")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.2,{"$f":"IF('(S4) Results'!D36=\"No evidence (score 0)\",0,IF('(S4) Results'!D36=\"Some evidence (score 1)\",1,IF('(S4) Results'!D36=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G36=0,0,IF('(S4) Results'!G36=1,1,IF('(S4) Results'!G36=2,2,\" \")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.3,{"$f":"IF('(S4) Results'!D37=\"No evidence (score 0)\",0,IF('(S4) Results'!D37=\"Some evidence (score 1)\",1,IF('(S4) Results'!D37=\"Strong evidence (score 2)\",2,\" \")))","v":" "},{"$f":"IF('(S4) Results'!G37=0,0,IF('(S4) Results'!G37=1,1,IF('(S4) Results'!G37=2,2,\" \")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(R20:R40)","v":0},{"$f":"SUM(S20:S40)","v":0}]
[null,"For the following indicator you can benchmark your current position against the national comparator or (where trend data is available) consider local direction of travel – trends should show a reduction over time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum of 18",{"$f":"SUM(R38:R40)","v":0},{"$f":"SUM(S38:S40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sum of 16-17",{"$f":"SUM(R20:R37)","v":0},{"$f":"SUM(S20:S37)","v":0}]