The physical activity return on investment tool has been developed to help decision making in physical activity programme planning at local and sub-national levels.
The tool enables the user to evaluate a portfolio of interventions in their geographical area (e.g. region, county or local authority) and models the economic returns that can be expected in different payback timescales. The different interventions included in the tool can be mixed and matched to see which intervention portfolio or package provides the best 'value for money', compared with 'no package of interventions' or any other specified package.
The tool is accompanied by a package of support materials, including a user guide and technical report, and can be downloaded using the links on this page.
This site contains the most up-to-date tool, so please ensure that you are using the latest version. The most recent version is version 1- check this page regularly to ensure the tool you have downloaded is up to date.
The tool is accompanied by a user guide and a technical report. We strongly advise that you read these before using the tool.
In addition to the user guide and technical report, NICE has also developed a guide on how to use the NICE physical activity return on investment tool.
NICE is planning a series of webinars to demonstrate the use of the tool and provide help and support to those using it. If you are interested in attending a webinar session, please contact us. The webinars are approximately one hour and are conducted on line.
NICE has provided this tool to aid decision-making. NICE cannot be held liable for any investment or other decisions that are made using information and results obtained from this tool. Implementation of NICE guidance is the responsibility of local commissioners and/or providers. Commissioners and providers are reminded that it is their responsibility to implement NICE guidance, in their local context, in light of their duties to avoid unlawful discrimination and to have regard to promoting equality of opportunity. Nothing in this tool should be interpreted in a way that would be inconsistent with compliance with those duties.
Download the tool and accompanying support materials
- NICE physical activity ROI tool v.1.05
(Microsoft Excel macro-enabled (.xlsm) file)
To enable the macros in this tool right-click and save to your hard drive before opening.
- NICE physical activity ROI tool user guide (PDF) 2.5 Mb
- NICE physical activity ROI tool technical report (PDF) 700 Kb
To use the tool, right click on the link and save it to a location on your computer. It is not recommended that you left-click to open the tool from the temporary file location it will be saved in, as the file may not work properly. Read the user guide for more information.
Once you have downloaded the tool you will need to enable macros in Excel for the tool to function.
Due to the way this tool was developed, it is not compatible with Excel 2003 and earlier versions, or Excel for Mac. Apologies for any inconvenience caused.
This tool is work-in-progress: we welcome your feedback.