Tobacco Dependence Treatment Service ROI Calculator

A return-on-investment tool which uses the Ottawa model for Smoking Cessation to estimate the impact of fully implementing Tobacco Dependency Treatment Services (TDTS) on indicators including hospital readmissions, A&E presentations, financial savings, new bed spaces and lives saved. This data can be broken down by Foundation Trust, ICB and NHS region.

A new version of the ROI tool has been uploaded with the following corrections (September 2023):

• Added an acknowledgement to About page: The method was developed from work originating in the North East & Yorkshire Regional Prevention team, applying the Ottawa evidence base to model the impact and benefit to Trusts & ICBs across the North East & Yorkshire.
• Barking, Havering and Redbridge University Hospitals NHS Trust was mistakenly included in North West London ICB and has now been corrected to North East London (affecting both ICB totals)
  
• Leicestershire Partnership NHS Trust was mistakenly included in NHS Sussex ICB and has now been corrected to NHS Leicester, Leicestershire and Rutland ICB (affecting both ICB totals)
• Fixed a crash caused by clicking on buttons with a dropdown list open

Once you’ve downloaded it, right click on the file and select ‘Extract All…’ or something similar. Choose a place to save the unzipped document (not your downloads folder). You may want to delete the zipped version so you don’t accidentally open that in future.

Navigate to the folder the file is saved in, right click on the file and select ‘properties’. In the box that comes up there might be a section at the bottom (underneath ‘Attributes: Read only, Hidden’) that says: ‘Security: This file came from another computer and might be blocked to help protect this computer’ with a tickbox labelled ‘unblock.’

If there is, tick the unblock box > click 'Apply' > then click 'OK'. Then open the Excel file.

If prompted by a yellow banner across the top of the Excel screen saying SECURITY WARNING, click the button on it called ‘Enable Content’.

If a box comes up asking you to confirm you want to enable macros, select ‘Yes’.

Similarly, if there’s a yellow banner across the top of the Excel screen saying it’s in PROTECTED VIEW, select the button on it called ‘Enable Editing’ and If a box comes up asking you to confirm you want to enable macros, select ‘Yes

If the Excel window says at the top that it’s in ‘Preview mode’ or ‘Read-Only’
Make sure you followed the instructions above for downloading the document. Opening an unsaved or zipped document means it may not function properly.

If there’s a red banner across the top of the Excel screen saying SECURITY RISK, or the document isn’t working as expected
The document works using macros, which are pieces of computer code. As it’s difficult to tell automatically whether they are designed to harm your computer, Windows and some IT systems might automatically block macros, which will stop the document from working. Try these tips:

• Inside the Excel document go to File > Info. If there’s a red shield icon, click on it and set it to making it a ‘trusted document’
  
• Close the document and open a new Excel document and try going to File > Options > Trust Centre > Trust Centre Settings > macro settings and select ‘disable all VBAs with notification’ or ‘disable all macros with notification’ (wording depends on excel version), and reopen the document.

If you’re not able to access the document, please email laura.bunce@ash.org.uk and we can send you screenshots of the data you need.