The alcohol use return on investment tool has been developed to help decision making on interventions and strategies to prevent and reduce alcohol use 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. We have also published an alcohol effect size calculator for this tool. This calculator uses the mean reduction in alcohol units and standard deviation associated with an intervention and control to calculate the impact – effect size – of the intervention. This can be used for custom interventions and local data. Instructions for its use is found in Appendix 4 of the alcohol user guide
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 alcohol 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 alcohol ROI tool v.1.01.01
(Microsoft Excel macro-enabled (.xlsb) file)
To enable the macros in this tool right-click and save to your hard drive before opening.
- NICE alcohol ROI tool user guide (PDF) 2.5 Mb
- NICE alcohol effect size calculator (Excel file) 12 Kb
- NICE alcohol 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.