FOI-01943

##Request ‘I would like to request annual Pharmacy Dispensing at presentation level between Jan 2023 - December 2023. Ideally this would include Pharmacy ODS Code, BNF Code, BNF Name, Items Thanks’ ##Response Under Section 21 of the Act, we are not required to provide information in response to a request if it is already reasonably accessible to you. The information you requested is available from web links: January 2023 – March 2023 https://opendata.nhsbsa.net/dataset/foi-01204 April 2023 https://opendata.nhsbsa.net/dataset/foi-01240 May 2023 https://opendata.nhsbsa.net/dataset/foi-01310 June 2023 https://opendata.nhsbsa.net/dataset/foi-01378 July 2023 FOI-01424 - Datasets - Open Data Portal BETA (nhsbsa.net) August 2023 https://opendata.nhsbsa.net/dataset/foi-01502 September 2023 https://opendata.nhsbsa.net/dataset/foi-01550 October 2023 https://opendata.nhsbsa.net/dataset/foi-01668 November 2023 https://opendata.nhsbsa.net/dataset/foi-01669 December 2023 https://opendata.nhsbsa.net/dataset/foi-01756 Some data sets are over 1 million rows of data and it may be that you will need to use add-ons already existing on Microsoft Excel to enable you to view the data set in its entirety. Microsoft PowerPivot add-on for Excel can be used to handle larger data sets. The Microsoft PowerPivot add-on for Excel is available using the link in the 'Related Links' section below: https://www.microsoft.com/en-us/download/details.aspx?id=43348 Once PowerPivot has been installed, to load the large files, please follow the instructions below: 1. Start Excel as normal 2. Click on the PowerPivot tab 3. Click on the PowerPivot Window icon (top left) 4. In the PowerPivot Window, click on the "From Other Sources" icon 5. In the Table Import Wizard e.g. scroll to the bottom and select Text File 6. Browse to the file you want to open and choose the file extension you require e.g. CSV