Resource Allocation Formula - Archive Data
2016/17 Allocation
The outputs from this analysis can be obtained using the links below.
2016-17 analysis - HB Summary [370Kb]
Excel file containing data at Health Board level only
2016-17 analysis - Data zone data [13.1Mb]
Excel file containing data at Data zone and GP practice level (warning large file which may be slow to download)
2016-17 analysis - Comparison [216Kb]
Excel file containing NRAC target shares for 2016/17, 2015/16, 2014/15, 2013/14 and 2012/13 for each Health Board
Note: Before opening the spreadsheet please ensure that your Macro security settings are set to medium. To do this; open Microsoft Excel, go to "Tools" menu and select "Macro". Then select "Security" and ensure that the security setting is set to either "Medium" or "Low" (Medium is the recommended option). If your settings were set to "High" you should reset the level when you have finished looking at the results. Whilst the file is opening, you may be asked if you wish to "enable or disable" macros - you must select "Enable Macros"; to ensure the spreadsheets function correctly.
2015/16 Allocation
The outputs from this analysis can be obtained using the links below.
2015-16 analysis - HB Summary [370Kb]
Excel file containing data at Health Board level only
2015-16 analysis - Data zone data [13.1Mb]
Excel file containing data at Data zone and GP practice level (warning large file which may be slow to download)
2015-16 analysis - Comparison [216Kb]
Excel file containing NRAC target shares for 2015/16, 2014/15, 2013/14, 2012/13 and 2011/12 for each Health Board
Note: Before opening the spreadsheet please ensure that your Macro security settings are set to medium. To do this; open Microsoft Excel, go to "Tools" menu and select "Macro". Then select "Security" and ensure that the security setting is set to either "Medium" or "Low" (Medium is the recommended option). If your settings were set to "High" you should reset the level when you have finished looking at the results. Whilst the file is opening, you may be asked if you wish to "enable or disable" macros - you must select "Enable Macros"; to ensure the spreadsheets function correctly.
2014/15 Allocation - New NHS Board Boundaries
Effective from April 2014 (Financial Year 2014/15), new NHS Board boundaries were implemented going forward. This change has been accounted for and the formula recalculated in spreadsheet below.
2014-15 analysis - New NHS Board Boundaries 
[216kb]
2014/15 Allocation - based on previous NHS Board Boundaries
The 2014/15 target shares have also been calculated based on the previous NHS Board boundaries prior to 1st April 2014.
The outputs from this analysis can be obtained using the links below:
2014-15 analysis - HB Summary [370Kb]
Excel file containing data at Health Board level only.
2014-15 analysis - Data zone data [13.09Mb]
Excel file containing data at Data zone and GP Practice level (warning large file which may be slow to download).
2014-15 analysis - Comparison [216kb]
Excel file containing NRAC target shares for 2014/15, 2013/14, 2012/13, 2011/12 and 2010/11 for each Health Board.
Note: Before opening the spreadsheet please ensure that your Macro security settings are set to medium. To do this; open Microsoft Excel, go to "Tools" menu and select "Macro". Then select "Security" and ensure that the security setting is set to either "Medium" or "Low" (Medium is the recommended option). If your settings were set to "High" you should reset the level when you have finished looking at the results. Whilst the file is opening, you may be asked if you wish to "enable or disable" macros - you must select "Enable Macros"; to ensure the spreadsheets function correctly.
2013/14 Results
The outputs from this analysis can be obtained using the links below.
2013-14 analysis - HB Summary [283kb]
Excel file containing data at Health Board level only.
2013-14 analysis - Data zone data [12.86mb]
Excel file containing data at Data zone and GP Practice level (warning large file which may be slow to download).
2013-14 analysis - Comparison [200kb]
Excel file containing NRAC target shares for 2013/14, 2012/13, 2011/12 and 2010/11 for each Health Board.
Note: Before opening the spreadsheet please ensure that your Macro security settings are set to medium. To do this; open Microsoft Excel, go to "Tools" menu and select "Macro". Then select "Security" and ensure that the security setting is set to either "Medium" or "Low" (Medium is the recommended option). If your settings were set to "High" you should reset the level when you have finished looking at the results. Whilst the file is opening, you may be asked if you wish to "enable or disable" macros - you must select "Enable Macros"; to ensure the spreadsheets function correctly.
2012/13 Results
The outputs from this analysis can be obtained using the links below.
2012-13 analysis - HB Summary [0.28mb]
Excel file containing data at Health Board level only.
2012-13 analysis - Data zone data [12.84mb]
Excel file containing data at Data zone and GP Practice level (warning large file which may be slow to download).
2012-13 analysis - Comparison [0.16mb]
Excel file containing NRAC target shares for 2012/13, 2011/12, 2010/11 and 2009/10 for each Health Board.
Note: Before opening the spreadsheet please ensure that your Macro security settings are set to medium. To do this; open Microsoft Excel, go to "Tools" menu and select "Macro". Then select "Security" and ensure that the security setting is set to either "Medium" or "Low" (Medium is the recommended option). If your settings were set to "High" you should reset the level when you have finished looking at the results. Whilst the file is opening, you may be asked if you wish to "enable or disable" macros - you must select "Enable Macros"; to ensure the spreadsheets function correctly.
2011/12 Results
The outputs from this analysis can be obtained using the links below.
2011-12 analysis - HB Summary [0.28mb]
Excel file containing data at Health Board level only.
2011-12 analysis - Datazone Data [13.18mb]
Excel file containing data at Data zone and GP Practice level (warning large file which may be slow to download).
2011-12 analysis - Comparison [0.18mb]
Excel file containing NRAC target shares for 2011/12, 2010/11, 2009/10 and 08/09 for each Health Board.
2010/11 Results
The outputs from this analysis can be obtained using the links below.
2010-11 analysis - HB Summary ( 0.29 MB)
Excel file containing data at Health Board level only.
2010-11 analysis - Datazone data ( 13 MB)
Excel file containing data at Data zone and GP Practice level (warning large file which may be slow to download).
2010-11 analysis - Comparison ( 0.15 MB)
Excel file containing NRAC target shares for 2010/11, 2009/10, 2008/09 and 07/08 for each Health Board.
Note: Before opening the spreadsheet please ensure that your Macro security settings are set to medium. To do this; open Microsoft Excel, go to "Tools" menu and select "Macro". Then select "Security" and ensure that the security setting is set to either "Medium" or "Low" (Medium is the recommended option). If your settings were set to "High" you should reset the level when you have finished looking at the results. Whilst the file is opening, you may be asked if you wish to "enable or disable" macros - you must select "Enable Macros"; to ensure the spreadsheets function correctly.
2009/10
The Resource Allocation formula (NRAC) was used for the first time to calculate 2009/10 target shares. These target shares were used by the Scottish Government to inform the allocation of NHS Revenue Budget between the 14 territorial NHS Boards in Scotland in 2009/10.
2009/10 results
The output from the Resource Allocation formula 2009/10 can be obtained using the links below.
2009-10 analysis - HB Summary ( 0.35 MB)
Excel file containing data at Health Board level only.
2009-10 analysis - Datazone data ( 10.7 MB)
Excel file containing data at Data zone and GP Practice level (warning large file which may be slow to download).
2009-10 analysis - Comparison ( 0.19 MB)
Excel file containing NRAC target shares for 2009/10, 2008/09 and 2007/08 for each Health Board.
Note: Before opening the spreadsheet please ensure that your Macro security settings are set to medium. To do this; open Microsoft Excel, go to "Tools" menu and select "Macro". Then select "Security" and ensure that the security setting is set to either "Medium" or "Low" (Medium is the recommended option). If your settings were set to "High" you should reset the level when you have finished looking at the results. Whilst the file is opening, you may be asked if you wish to "enable or disable" macros - you must select "Enable Macros"; to ensure the spreadsheets function correctly.
2008/09
Prior to the implementation of the new Resource Allocation formula, ISD and the Scottish Government Health Directorate have carried out some pre-implementation analyses during summer 2008 to give an insight into the workings of the new formula and to allow NHS Boards to carry out preparatory work in advance of the introduction of the new formula in 2009/10.
Pre-implementation Analysis (shadow run for 2008/09)
Major changes to the Resource Allocation Formula (the "Arbuthnott Formula") were recommended by the NHSScotland Resource Allocation Committee (NRAC) in a report published in September 2007. The NRAC recommendations were accepted by the Cabinet Secretary for Health & Wellbeing in February 2008 - for implementation in the 2009/10 Resource Allocations.
Prior to the implementation of the new Resource Allocation formula, ISD and the Scottish Government Health Directorate have carried out some pre-implementation analyses to give an insight into the workings of the new formula and to allow NHS Boards to carry out preparatory work in advance of the introduction of the new formula in 2009/10.
The results of this "shadow run" are provided - for information only - in this publication and show the target shares that would have been calculated for 2008/09 if the new formula had been in use at this time.
This publication highlights some of the preparatory work carried out by ISD, in collaboration with the Scottish Government Health Directorate, prior to the implementation of the new Resource Allocation formula in Scotland for the calculation of the 2009/10 target shares. Results of the pre-implementation analysis, showing the target shares that would have been calculated if the 2008/09 calculations had been carried out using the new formula, are available using the links below.
It is important to note that the target shares shown within these spreadsheets have not been used to allocate funds to Boards but are for information. It is hoped that they will help Boards understand the outputs of the new Resource Allocation formula by providing an additional year of data for comparison with the Arbuthnott Formula.
The outputs from this pre-implementation analysis can be obtained using the links below.
2008-09 Shadow run analysis - HB Summary ( 0.35 MB)
Excel file containing data at Health Board level only.
2008-09 Shadow run analysis - Datazone data ( 10.7MB)
Excel file containing data at Data zone and GP Practice level (warning slow to download due to large file size).
2008-09 Shadow run analysis - Comparison ( 0.19 MB)
Excel file containing a comparison of the Arbuthnott and NEW Resource Allocation target shares for each Health Board.
Note: Before opening the spreadsheet please ensure that your Macro security settings are set to medium. To do this; open Microsoft Excel, go to "Tools" menu and select "Macro". Then select "Security" and ensure that the security setting is set to either "Medium" or "Low" (Medium is the recommended option). If your settings were set to "High" you should reset the level when you have finished looking at the results. Whilst the file is opening, you may be asked if you wish to "enable or disable" macros - you must select "Enable Macros"; otherwise the spreadsheets will not function correctly.
