If you are viewing this website through The National Archives it may be necessary to copy and paste external links directly into your browser.
 

What's New in Tools

Child Health Profiles 2016 - PDF reports

15 March 2016
These popular profiles provide a snapshot of child health and wellbeing for each local authority in England using key health indicators.

Health behaviours in young people

15 March 2016
Our Health Behaviours in Young People Tool gives an insight into healthy lifestyles and risky behaviours. Two-page summaries available for each local authority.

Teenage Parent Outcomes Modelling Tool

24 February 2016
This new tool for teenage pregnancy leads in local authorities brings together data and evidence about factors that affect outcomes for teenage parents and their babies. It allows you to model the potential impact of local services on outcomes in your area.

Child Health Clinical Indicator Summaries

17 December 2015
These summaries present children and young people’s health and healthcare data for each of the 12 strategic clinical network (SCN) areas to help identify priorities, benchmark and track progress and outcomes.

Mental health in pregnancy, the postnatal period and babies and toddlers: needs assessment report

9 December 2015
Our new needs assessment report brings together data and evidence on mental health in pregnancy, the postnatal period and babies and toddlers. Available for local authorities and CCGs.

Continence in children

5 October 2015
We’ve updated our Needs Assessment Report about continence in children and young people with the latest data for local authorities and CCGs. This is one of a series of popular reports which help you undertake local needs assessments as part of children’s and young people’s planning and joint strategic needs assessments.

NHS Atlas of Variation in Healthcare 2015

21 September 2015
We bring together over 60 indicators relating to the care of mothers, babies, children and young people to support the NHS Atlas of Variation in Healthcare in highlighting and tackling unwarranted variation in healthcare and health outcomes.

Outcomes versus Expenditure Tools

Back to about the tool

Using the Outcomes versus Expenditure Tools you can compare expenditure and other aspects of services with a number of outcome measures.

As a commissioner, the Outcomes versus Expenditure Tool allows you to pinpoint opportunities to improve the quality of outcomes and productivity for services in your local area.

You will also find the tool useful if you are a provider of services, as a means of sparking discussion with local commissioners about ways to improve services.

The Outcomes versus Expenditure Tools currently available are:

Each tool is an Excel spreadsheet which you can download below.

User guidance

The following guide explains how to use the tools and what they tell you about your local area.


Child and Adolescent Mental Health Services

To use the tool, click on the link below and select 'Save File' to save the spreadsheet to your local machine. Once you open the spreadsheet enable the macros to use the tool. For help using macros, see below.

Note for Apple Mac users: The Excel spreadsheet will not work in Office 2008 for Apple Mac. This is because the macros feature has been removed from this version of the software.

Child Health

To use the tool, click on the link below and select 'Save File' to save the spreadsheet to your local machine. Once you open the spreadsheet enable the macros to use the tool. For help using macros, see below.

Note for Apple Mac users: The excel spreadsheet will not work in Office 2008 for Apple Mac. This is because the macros feature has been removed from this version of the software.

Maternity and Newborn

To use the tool, click on the link below and select 'Save File' to save the spreadsheet to your local machine. Once you open the spreadsheet enable the macros to use the tool. For help using macros, see below.

Excel 2007 and later

Excel 2003

The tool has been designed in Office 2010. For users of pre-2007 versions of Microsoft Office, we have made a 2003 version available. However some non-essential functionality will be lost. Please save the files to your computer before opening.

Note for Apple Mac users: The excel spreadsheet will not work in Office 2008 for Apple Mac. This is because the macros feature has been removed from this version of the software.

top




Help with macros

Office 2003
Each time you open the Excel files, a pop-up box may ask you to choose a 'macro' setting. Select 'Enable macros' to ensure you are able to navigate around the toolkit. If you are still experiencing problems with the Excel files, your security settings may be too high. Before you download the files, re-set your security settings as follows:

  1. Open Excel
  2. Go to the 'Tools' menu
  3. Select the 'Macros' option
  4. Select 'Security'
  5. Select the 'Medium' option
  6. Click the 'OK' button.

Later versions of Office
When the file is opened in Excel it may have the macros disabled, a security warning will be displayed at the top of the screen click ’Options‘ and select ’Enable this content‘ to use the tool.

If you are still experiencing problems with the Excel files, your security settings may be too high. To reset your macro security, follow the instructions here:


ChiMat Disclaimer

The data in the Outcomes versus Expenditure Tools are published with the permission of the data sources, as listed in the Data Sources section of the tool (see spreadsheet). It is final or provisional data, as published by each source under its standard procedure. ChiMat has presented the data in a user-friendly format. ChiMat accepts no responsibility for how readers and users of these tools interpret the data and information. ChiMat accepts no responsibility for the onward communication and transmission of the data.

top


Validates against XHTML 1.0  Cascading Style Sheet compliance  Single A Accessibility compliance