{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Amendment Form","Guidance Notes","HWB","Revision History","ICB"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Amendment Form","index":0,"n_rows":125,"n_cols":8,"rows_kept":125,"cut":false,"hidden":false,"merged":[[22,1,24,4],[22,5,24,5],[22,6,24,7],[97,6,98,7],[95,6,95,7],[86,2,87,7],[92,2,93,7],[94,1,94,7],[88,2,89,7],[90,2,91,7],[86,1,87,1],[63,1,64,1],[92,1,93,1],[88,1,89,1],[90,1,91,1],[65,1,65,7],[63,5,64,7],[67,6,68,6],[67,7,68,7],[69,1,70,1],[69,2,70,2],[69,3,70,3],[69,4,70,4],[59,2,60,4],[59,5,60,7],[61,1,62,1],[55,2,56,4],[55,5,56,7],[57,2,58,4],[57,5,58,7],[48,1,48,7],[46,2,46,4],[46,5,46,7],[47,2,47,4],[47,5,47,7],[13,2,13,4],[13,6,13,7],[17,1,17,7],[18,1,21,4],[18,5,21,5],[18,6,21,7],[14,1,14,7],[15,2,15,4],[15,6,15,7],[49,0,50,0],[63,2,64,4],[10,1,10,7],[11,1,11,7],[33,2,34,7],[16,1,16,7],[27,1,27,7],[33,1,34,1],[59,1,60,1],[53,1,54,1],[55,1,56,1],[49,1,50,1],[35,2,35,7],[36,1,36,7],[51,2,52,4],[31,1,32,1],[49,2,50,4],[49,5,50,7],[61,5,62,7],[61,2,62,4],[53,2,54,4],[53,5,54,7],[57,1,58,1],[51,1,52,1],[31,2,32,7],[51,5,52,7],[28,1,28,7],[29,1,30,1],[25,1,26,1],[25,2,26,4],[25,5,26,6],[25,7,26,7],[38,2,39,7],[29,2,30,7],[37,2,37,4],[37,5,37,7],[40,1,41,1],[38,1,39,1],[40,2,41,4],[40,5,41,7],[42,1,43,1],[42,2,43,4],[42,5,43,7],[44,1,45,1],[44,2,45,4],[44,5,45,7],[67,2,68,2],[67,3,68,3],[67,4,68,4],[67,5,68,5],[71,6,72,6],[71,7,72,7],[73,1,74,1],[73,2,74,2],[73,3,74,3],[73,4,74,4],[73,5,74,5],[73,6,74,6],[73,7,74,7],[71,1,72,1],[71,2,72,2],[71,3,72,3],[71,4,72,4],[71,5,72,5],[67,1,68,1],[69,5,70,5],[69,6,70,6],[69,7,70,7],[79,1,80,1],[75,6,76,6],[75,7,76,7],[77,1,78,1],[77,2,78,2],[77,3,78,3],[77,4,78,4],[77,5,78,5],[77,6,78,6],[77,7,78,7],[75,1,76,1],[75,2,76,2],[75,3,76,3],[75,4,76,4],[75,5,76,5],[12,1,12,7],[97,1,98,1],[79,7,80,7],[81,1,82,1],[81,2,82,2],[81,3,82,3],[81,4,82,4],[81,5,82,5],[81,6,82,6],[81,7,82,7],[79,2,80,2],[79,3,80,3],[79,4,80,4],[79,5,80,5],[79,6,80,6],[83,1,84,1],[83,2,84,3],[83,4,84,5],[83,6,84,7],[95,2,95,3],[97,2,98,3],[95,4,95,5],[97,4,98,5],[96,1,96,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Change of Ownership NHS Appliance Contractor "]
[null,"Authorised signatory should complete form and send to: prescriptioninformation@nhsbsa.nhs.uk"]
[]
[null,"ICB Name","Please select ICB",null,null,"ICB Code (automatically populated)",{"$f":"VLOOKUP(C14,ICB!A1:B43,2,FALSE)","v":"N/A"}]
[]
[null,"Health and Wellbeing Board Area","Please select HWB",null,null,"HWB Code (automatically populated)",{"$f":"VLOOKUP(C16,HWB!A1:B163,2, FALSE)","v":"N/A"}]
[]
[null,"Please tick applicable box"]
[null,"Change of ownership (contractor completely buys out another company including debts, liabilities and/or access to bank account) – resulting in change of company name only. See Regulation 26 of the NHS (Pharmaceutical Services) Regulations 2012.",null,null,null,null,"New account code(s) will not be allocated by NHS Prescription Services*."]
[]
[]
[]
[null,"Change of ownership (contractor buys business on a non-debts and liabilities basis). See Regulation 26 of the NHS (Pharmaceutical Services) Regulations 2012.",null,null,null,null,"New account code(s) will be allocated by NHS Prescription Services."]
[]
[]
[null,"Is the change of ownership a result of a consolidation?",null,null,null,"Please state relevant F-Code"]
[]
[]
[null,"*Please provide details of new company director"]
[null,"Name:"]
[]
[null,"Contact Number:"]
[]
[null,"Is the appliance contractor VAT registered?"]
[]
[null,"VAT Number:"]
[null,"Please note: Contractor banking details must be submitted to NHS Prescription Services by following the instructions on our website at: www.nhsbsa.nhs.uk/PrescriptionServices/4031.aspx"]
[null,null,"Existing Owner Details",null,null,"New Owner Details"]
[null,"Date of change of ownership (Please note: 21 day’s notice MUST be provided to ensure all changes to NHS systems can be applied prior to change of ownership)"]
[]
[null,"Contractor Code (allocated by NHS Prescription Services)",null,null,null,"N/A"]
[]
[null,"Contractor/Owner name (max. 40 characters including spaces)"]
[]
[null,"Contractor Trading Name (max. 40 characters including spaces)"]
[]
[null,"Email address of owner/head office"]
[null,"NHS Shared Email Address"]
[null,"Address details (max. 25 characters per line including spaces)"]
[null,"Address line 1"]
[]
[null,"Address line 2"]
[]
[null,"Address line 3 (town or city only)"]
[]
[null,"Address line 4 (county or London only)"]
[]
[null,"Postcode"]
[]
[null,"Telephone number"]
[]
[null,"Distance selling Pharmacy?"]
[]
[null,"Distance selling Pharmacy website address (URL)"]
[]
[null,"Opening Hours ( up to three sets of opening times using 24 hour clock)"]
[null,null,"Opening Time","Closing Time","Opening Time","Closing Time","Opening Time","Closing Time"]
[null,"Example","06:00:00","12:00:00","12:30:00","17:00:00","18:00:00","23:00:00"]
[]
[null,"Monday"]
[]
[null,"Tuesday"]
[]
[null,"Wednesday"]
[]
[null,"Thursday"]
[]
[null,"Friday"]
[]
[null,"Saturday"]
[]
[null,"Sunday"]
[]
[null,"EPS R2 Active System?",null,null,"EPS R2 Go Live Date?\n(if different to COO date)"]
[]
[]
[null,"Authorised signatory:"]
[]
[null,"Print name:"]
[]
[null,"Contact Number:"]
[]
[null,"Date:"]
[]
[null,"For NHS Prescription Services use only"]
[null,"New contractor code",null,null,"Date letter sent to Wakefield division/CPS"]
[]
[null,"MDR input (Date & Initials)",null,null,"Date letter sent to STP"]
[]
[null,null,null,null,null,null,null,"v3.0 November 2024"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Walk-in Centre"]
[null,null,null,null,null,"Out-of-Hours Service"]
[null,null,null,null,null,"Walk-in Centre and Out-of-Hours Service"]
[null,null,null,null,null,"Public Health Service"]
[null,null,null,null,null,"Community Health Service"]
[null,null,null,null,null,"Hospital Service"]
[null,null,null,null,null,"Optometry Service"]
[null,null,null,null,null,"Urgent and Emergency Care"]
[null,null,null,null,null,"Hospice"]
[null,null,null,null,null,"Care Home/Nursing Home"]
[null,null,null,null,null,"Other"]
[]
[null,null,null,null,"Yes","Yes (Please provide VAT Number below)",null,"Yes (please provide details below)"]
[null,null,null,null,"No","No",null,"No"]

{"sheet":"Guidance Notes","index":1,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["ICB Name","The name of the Integrated Care Board that the NHS Pharmacy Contractor is to be attached to (choose from drop down box)"]
["ICB Code","The code of the ICB. (***) - automatically generated"]
["Health and Wellbeing Board Area","The name of the Health and Wellbeing Board Area the NHS Pharmacy Contractor is in (choose from drop down box)"]
["HWB Code","The code of the HWB - automatically generated"]
["Please tick applicable box","Please tick one relevant box only"]
["Date of change of ownership","Please state date of change of ownership"]
["Company Director","Please state relevant details"]
["Is the appliance contractor VAT registered?","Choose from drop down box"]
["VAT Number:","Please input VAT number"]
["Contractor Code","The contractor code (F****)"]
["Contractor/Owner name"," The name of the Contractor/Owner (max. 40 characters including spaces)"]
["Contractor Trading Name","The Contractor trading name (max. 40 characters including spaces)"]
["Email address of owner/head office","The email address of the owner/head office"]
["Address","The address must adhere to the following format.  Each line has 25 characters including spaces"]
[null,"1st Line - address details"]
[null,"2nd Line - address details"]
[null,"3rd Line - Town/City only"]
[null,"4th Line - County/London only"]
["Telephone Number","Please state telephone number of NHS Pharmacy Contractor"]
["Distance selling Pharmacy?","Choose from drop down box"]
["Distance selling Pharmacy website address (URL)","If a Distance Selling pharmacy please state website address "]
["EPS R2 Active System?","Is there an active EPS system for the contract (choose from drop down box)"]
["EPS R2 Go Live Date","Date system goes live if different to that of start of contract"]
["Authorised Signatory","This is the authorised signatory at the Area Team (or an agency on their behalf) "]

{"sheet":"HWB","index":2,"n_rows":163,"n_cols":2,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
["Please select HWB","N/A"]
["Ashford","HW162"]
["Barking and Dagenham ","HW001"]
["Barnet ","HW002"]
["Barnsley ","HW003"]
["Bassetlaw ","HW004"]
["Bath and North East Somerset ","HW005"]
["Bedford Borough","HW006"]
["Bexley ","HW007"]
["Birmingham ","HW008"]
["Blackburn with Darwen ","HW009"]
["Blackpool ","HW010"]
["Bolton","HW011"]
["Bournemouth and Poole ","HW013"]
["Bracknell and Ascot ","HW014"]
["Bradford and Airedale ","HW015"]
["Brent ","HW016"]
["Brighton and Hove ","HW017"]
["Bristol ","HW018"]
["Bromley ","HW020"]
["Buckinghamshire ","HW021"]
["Bury ","HW022"]
["Calderdale ","HW023"]
["Cambridgeshire ","HW024"]
["Camden ","HW025"]
["Canterbury and Coastal","HW163"]
["Central Bedfordshire","HW026"]
["Cheshire East ","HW027"]
["Cheshire West and Chester ","HW028"]
["City of London ","HW029"]
["Cornwall ","HW030"]
["Coventry ","HW031"]
["Croydon ","HW032"]
["Cumberland","HW168"]
["Cumbria ","HW033"]
["Darlington ","HW035"]
["Derby City ","HW036"]
["Derbyshire ","HW037"]
["Devon ","HW038"]
["Doncaster ","HW039"]
["Dorset ","HW040"]
["Dudley ","HW041"]
["Durham ","HW042"]
["Ealing ","HW043"]
["East Riding Of Yorkshire ","HW044"]
["East Sussex ","HW045"]
["Enfield ","HW046"]
["Essex ","HW047"]
["Gateshead ","HW048"]
["Gloucestershire ","HW049"]
["Greenwich ","HW050"]
["Hackney ","HW051"]
["Halton ","HW052"]
["Hammersmith and Fulham ","HW053"]
["Hampshire ","HW054"]
["Haringey ","HW055"]
["Harrow ","HW056"]
["Hartlepool ","HW057"]
["Havering ","HW058"]
["Herefordshire ","HW059"]
["Hertfordshire ","HW060"]
["Hillingdon ","HW061"]
["Hounslow ","HW062"]
["Hull ","HW063"]
["Isle Of Wight ","HW066"]
["Isles of Scilly ","HW067"]
["Islington ","HW068"]
["Kensington & Chelsea ","HW069"]
["Kent ","HW070"]
["Kingston ","HW071"]
["Kirklees ","HW072"]
["Knowsley ","HW073"]
["Lambeth ","HW074"]
["Lancashire ","HW075"]
["Leeds ","HW076"]
["Leicester City ","HW077"]
["Leicestershire ","HW078"]
["Lewisham ","HW079"]
["Lincolnshire ","HW080"]
["Liverpool ","HW081"]
["Luton ","HW082"]
["Manchester ","HW084"]
["Medway ","HW085"]
["Merton ","HW086"]
["Middlesbrough ","HW087"]
["Milton Keynes ","HW088"]
["Newcastle ","HW089"]
["Newham ","HW090"]
["Norfolk ","HW091"]
["North East Lincolnshire ","HW092"]
["North Lincolnshire ","HW093"]
["North Somerset ","HW094"]
["North Tyneside ","HW095"]
["North Yorkshire ","HW096"]
["Northamptonshire ","HW097"]
["Northamptonshire North","HW169"]
["Northamptonshire West","HW170"]
["Northumberland ","HW098"]
["Nottingham City ","HW099"]
["Nottinghamshire ","HW100"]
["Oldham ","HW102"]
["Oxfordshire ","HW103"]
["Peterborough ","HW104"]
["Plymouth ","HW105"]
["Portsmouth ","HW106"]
["Reading ","HW107"]
["Redbridge ","HW108"]
["Redcar & Cleveland ","HW109"]
["Richmond ","HW110"]
["Rochdale ","HW111"]
["Rotherham ","HW112"]
["Rutland ","HW113"]
["Salford ","HW115"]
["Sandwell ","HW116"]
["Sefton ","HW117"]
["Sheffield ","HW118"]
["Shropshire ","HW119"]
["Slough ","HW120"]
["Solihull ","HW121"]
["Somerset ","HW122"]
["South Gloucestershire ","HW123"]
["South Kent Coast","HW164"]
["South Tyneside ","HW124"]
["Southampton ","HW125"]
["Southend on Sea ","HW126"]
["Southwark ","HW127"]
["St Albans ","HW128"]
["St Helens ","HW129"]
["Staffordshire ","HW130"]
["Stockport ","HW131"]
["Stockton-on-Tees ","HW132"]
["Stoke-On-Trent ","HW133"]
["Suffolk ","HW134"]
["Sunderland ","HW135"]
["Surrey ","HW136"]
["Sutton ","HW137"]
["Swale","HW165"]
["Swindon ","HW138"]
["Tameside ","HW139"]
["Telford & Wrekin ","HW140"]
["Thanet","HW166"]
["Thurrock ","HW141"]
["Torbay ","HW142"]
["Tower Hamlets ","HW143"]
["Trafford ","HW144"]
["Wakefield ","HW145"]
["Walsall ","HW146"]
["Waltham Forest ","HW147"]
["Wandsworth ","HW148"]
["Warrington ","HW149"]
["Warwickshire ","HW150"]
["West Berkshire ","HW151"]
["West Sussex ","HW152"]
["Westminster ","HW153"]
["Westmorland and Furness","HW167"]
["Wigan ","HW154"]
["Wiltshire ","HW155"]
["Windsor and Maidenhead ","HW156"]
["Wirral ","HW157"]
["Wokingham ","HW158"]
["Wolverhampton ","HW159"]
["Worcestershire ","HW160"]
["York ","HW161"]

{"sheet":"Revision History","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Version","Date","Reason for change","Editor"]
[2,"2022-05-01","New document created from old Excel forms","LAMAT"]
[2.1,"2022-06-29","Changed dropdown to ICB, added opening hours","ALGRA"]
[2.2000000000000002,"2022-06-30","Fixed conditional formatting issues. Changed remained references to STPs and added revision history. Removed 'for prescription services only' at bottom","LAMAT"]
[2.2999999999999998,"2023-05-04","added migration note - new email","ANSCU"]
[2.4,"2023-05-04","added migration note - new email","ANSCU"]
[2.6,"2023-06-27","updated email info on form header","MICBU"]
[2.6,"2023-06-27","updated HWB list to include Westmorland and Furness (HW167) and Cumberland (HW168)","MICBU"]
[2.6,"2023-06-27","updated ICB names of QUA, QNC, QOC, QOQ, QT6","MICBU"]
[2.6,"2023-06-28","conditional formatting for VAT number and Distance Selling Pharmacy dropdown/input boxes altered","MICBU"]
[2.7,"2023-08-31","edit Objects' ticked on sheet security for image insertions","MICBU"]
[2.8,"2024-01-29","Bedford Borough HWB name updated from Bedford","MICBU"]
[2.9,"2024-04-02","added Northamptonshire North to HWB list","MICBU"]
[2.9,"2024-04-02","added NHS shared email address section","MICBU"]
["v3.0","2024-11-05","updated HWB list","MICBU"]

{"sheet":"ICB","index":4,"n_rows":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Please select ICB","N/A"]
["Bath and North East Somerset, Swindon and Wiltshire ICB","QOX"]
["Bedfordshire, Luton and Milton Keynes ICB","QHG"]
["Birmingham and Solihull ICB","QHL"]
["Black Country ICB","QUA"]
["Bristol, North Somerset and South Gloucestershire ICB","QUY"]
["Buckinghamshire, Oxfordshire and Berkshire West ICB","QU9"]
["Cambridgeshire and Peterborough ICB","QUE"]
["Cheshire and Merseyside ICB","QYG"]
["Cornwall and the Isles of Scilly ICB","QT6"]
["Coventry and Warwickshire ICB","QWU"]
["North East And North Cumbria ICB","QHM"]
["Devon ICB","QJK"]
["Dorset ICB","QVV"]
["North East London ICB","QMF"]
["Frimley ICB","QNQ"]
["Gloucestershire ICB","QR1"]
["Greater Manchester ICB","QOP"]
["Hampshire and the Isle of Wight ICB","QRL"]
["Lancashire and South Cumbria ICB","QE1"]
["Herefordshire and Worcestershire ICB","QGH"]
["Hertfordshire and West Essex ICB","QM7"]
["Humber and North Yorkshire ICB","QOQ"]
["Derby And Derbyshire ICB","QJ2"]
["Kent and Medway ICB","QKS"]
["Leicester, Leicestershire and Rutland ICB","QK1"]
["Lincolnshire ICB","QJM"]
["Mid and South Essex ICB","QH8"]
["Norfolk and Waveney ICB","QMM"]
["North Central London ICB","QMJ"]
["North West London ICB","QRV"]
["Northamptonshire ICB","QPM"]
["Nottingham and Nottinghamshire ICB","QT1"]
["South East London ICB","QKK"]
["Shropshire, Telford and Wrekin ICB","QOC"]
["Somerset ICB","QSL"]
["South West London ICB","QWE"]
["South Yorkshire ICB","QF7"]
["Staffordshire and Stoke-on-Trent ICB","QNC"]
["Suffolk and North East Essex ICB","QJG"]
["Surrey Heartlands ICB","QXU"]
["Sussex ICB","QNX"]
["West Yorkshire ICB","QWO"]