{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Amendment Form","ICB","Guidance Notes","HWB","Revisions","STP"],"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":128,"n_cols":8,"rows_kept":128,"cut":false,"hidden":false,"merged":[[9,1,9,7],[87,1,87,7],[88,1,89,1],[88,2,89,7],[90,1,91,1],[90,2,91,7],[92,1,93,1],[92,2,93,7],[94,1,95,1],[94,2,95,7],[64,1,65,1],[48,2,49,4],[48,5,49,7],[46,2,47,4],[46,5,47,7],[44,1,45,7],[50,5,51,7],[52,2,53,4],[52,5,53,7],[54,2,55,4],[54,5,55,7],[56,2,57,4],[56,5,57,7],[10,1,10,7],[11,2,11,4],[15,1,15,7],[11,6,11,7],[19,1,19,2],[20,1,20,2],[26,1,26,2],[22,1,22,2],[13,1,14,1],[13,2,14,4],[13,5,14,5],[13,6,14,7],[23,1,23,2],[68,7,69,7],[60,1,61,1],[62,1,63,1],[62,2,63,7],[12,1,12,7],[16,1,16,7],[17,4,27,7],[28,2,28,7],[31,2,32,7],[29,1,30,7],[42,1,43,1],[42,2,43,4],[42,5,43,7],[46,0,47,0],[54,1,55,1],[48,1,49,1],[58,1,59,1],[52,1,53,1],[46,1,47,1],[31,1,32,1],[36,1,37,1],[66,1,66,7],[36,5,37,7],[38,2,39,4],[38,5,39,7],[60,2,61,4],[60,5,61,7],[40,1,41,1],[40,2,41,4],[40,5,41,7],[33,2,33,4],[33,5,33,7],[64,2,65,3],[64,5,65,6],[64,4,65,4],[64,7,65,7],[50,2,51,4],[100,3,101,3],[56,1,57,1],[50,1,51,1],[27,1,27,2],[17,1,17,2],[18,1,18,2],[21,1,21,2],[24,1,24,2],[25,1,25,2],[68,2,69,2],[68,3,69,3],[74,2,75,2],[74,3,75,3],[82,2,83,2],[82,3,83,3],[80,2,81,2],[80,3,81,3],[100,2,101,2],[68,1,69,1],[82,1,83,1],[80,1,81,1],[70,1,71,1],[72,2,73,2],[72,3,73,3],[72,1,73,1],[74,1,75,1],[34,1,35,1],[34,2,35,7],[72,6,73,6],[68,4,69,4],[76,5,77,5],[72,7,73,7],[74,4,75,4],[74,6,75,6],[68,5,69,5],[70,7,71,7],[72,4,73,4],[72,5,73,5],[38,1,39,1],[36,2,37,4],[70,2,71,2],[70,3,71,3],[70,4,71,4],[70,5,71,5],[70,6,71,6],[58,2,59,4],[58,5,59,7],[68,6,69,6],[82,5,83,5],[82,6,83,6],[82,7,83,7],[80,4,81,4],[80,5,81,5],[80,6,81,6],[74,7,75,7],[74,5,75,5],[80,7,81,7],[98,5,98,7],[99,1,99,7],[100,5,101,7],[84,1,85,1],[84,2,85,3],[84,4,85,5],[84,6,85,7],[97,1,97,7],[76,1,77,1],[78,1,79,1],[76,6,77,6],[78,4,79,4],[76,7,77,7],[78,2,79,2],[78,3,79,3],[78,5,79,5],[78,6,79,6],[78,7,79,7],[76,2,77,2],[76,3,77,3],[76,4,77,4],[100,4,101,4],[100,1,101,1],[82,4,83,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Change of NHS Pharmacy Contractor Details"]
[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(C12,ICB!A2:B44,2,FALSE)","v":"N/A"}]
[]
[null,"Health and Wellbeing Board Area:","Please select HWB",null,null,"HWB Code (automatically populated):",{"$f":"VLOOKUP(C14,HWB!A1:B163,2,FALSE)","v":"N/A"}]
[]
[]
[null,"Please tick applicable box(es)"]
[null,"Change of contractor/owner name (e.g. to a limited company)"]
[null,"Change of contractor trading name"]
[null,"Change of owner/head office email address"]
[null,"Change of address"]
[null,"Change of telephone number"]
[null,"Change of LPS Contract"]
[null,"Change of Distance Selling Pharmacy "]
[null,"Change of ICB"]
[null,"Change of opening hours"]
[null,"Change of EPS status"]
[null,"Other (please specify below)"]
[null,"Other Reason:"]
[]
[]
[null,"Contractor Code:"]
[]
[null,null,"Existing Details:",null,null,"New Details:"]
[null,"Date of change:"]
[]
[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,"LPS Contract:","Please select",null,null,"Please select"]
[]
[null,"Distance Selling Pharmacy:","Please select",null,null,"Please select"]
[]
[null,"Distance Selling Pharmacy website Address (URL):"]
[]
[null,"ICB Name (ICB Code will be automatically populated):","Please Select ICB",null,{"$f":"VLOOKUP(C65,ICB!$A$2:$B$44,2,FALSE)","v":"N/A"},"Please Select ICB",null,{"$f":"VLOOKUP(F65,ICB!$A$2:$B$44,2,FALSE)","v":"N/A"}]
[]
[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?","Please select",null,"EPS R2 Go Live Date?\n(if different to date of change):"]
[]
[]
[null,"Authorised Signatory Details:"]
[null,"Authorised signatory:"]
[]
[null,"Print name:"]
[]
[null,"Contact Number:"]
[]
[null,"Date:"]
[]
[]
[null,"For NHS Prescription Services use only"]
[null,"Private CD pharmacy code",null,"Divison"]
[]
[null,"MDR input (Date & Initials)",null,"Date sent to Divison/CPS"]
[]
[]
[null,null,null,null,null,null,null,"v5.5 November 2024"]
[]
[]
[]
[]
[]
[]
[]
[null,false]
[null,false]
[null,false]
[null,false,null,"Walk-in Centre"]
[null,false,null,"Out-of-Hours Service"]
[null,false,null,"Walk-in Centre and Out-of-Hours Service"]
[null,false,null,"Public Health Service"]
[null,false,null,"Community Health Service"]
[null,false,null,"Hospital Service"]
[null,false,null,"Optometry Service"]
[null,false,null,"Urgent and Emergency Care"]
[null,null,null,"Hospice"]
[null,null,null,"Care Home/Nursing Home"]
[null,null,null,"Other"]
[null,null,null,"Please select"]
[null,"Yes (NHS Prescription Services will allocate a code)",null,"Yes",null,"Yes (Provide details below)"]
[null,"No",null,"No",null,"No"]

{"sheet":"ICB","index":1,"n_rows":44,"n_cols":2,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Integrated Care Board Name ","ICB Code"]
["Please Select ICB","N/A"]
["BATH&NE SOMERSET,SWINDON & WILTSHIRE ICB","QOX"]
["BEDFORDSHIRE, LUTON & MILTON KEYNES ICB","QHG"]
["BIRMINGHAM AND SOLIHULL ICB","QHL"]
["BLACK COUNTRY ICB","QUA"]
["BRISTOL, N SOMERSET & SOUTH GLOS ICB","QUY"]
["BUCKS, OXFORDSHIRE & BERKSHIRE WEST ICB","QU9"]
["CAMBRIDGESHIRE & PETERBOROUGH ICB","QUE"]
["CHESHIRE AND MERSEYSIDE ICB","QYG"]
["CORNWALL AND THE ISLES OF SCILLY ICB","QT6"]
["COVENTRY AND WARWICKSHIRE ICB","QWU"]
["DERBY AND DERBYSHIRE ICB","QJ2"]
["DEVON ICB","QJK"]
["DORSET ICB","QVV"]
["FRIMLEY ICB","QNQ"]
["GLOUCESTERSHIRE ICB","QR1"]
["GREATER MANCHESTER ICB","QOP"]
["HAMPSHIRE AND ISLE OF WIGHT ICB","QRL"]
["HEREFORDSHIRE AND WORCESTERSHIRE ICB","QGH"]
["HERTFORDSHIRE AND WEST ESSEX ICB","QM7"]
["HUMBER AND NORTH YORKSHIRE ICB","QOQ"]
["KENT AND MEDWAY ICB","QKS"]
["LANCASHIRE AND SOUTH CUMBRIA ICB","QE1"]
["LEICESTER, LEICESTERSHIRE & RUTLAND ICB","QK1"]
["LINCOLNSHIRE ICB","QJM"]
["MID AND SOUTH ESSEX ICB","QH8"]
["NORFOLK AND WAVENEY ICB","QMM"]
["NORTH CENTRAL LONDON ICB","QMJ"]
["NORTH EAST AND NORTH CUMBRIA ICB","QHM"]
["NORTH EAST LONDON ICB","QMF"]
["NORTH WEST LONDON ICB","QRV"]
["NORTHAMPTONSHIRE ICB","QPM"]
["NOTTINGHAM AND NOTTINGHAMSHIRE ICB","QT1"]
["SHROPSHIRE, TELFORD & WREKIN ICB","QOC"]
["SOMERSET ICB","QSL"]
["SOUTH EAST LONDON ICB","QKK"]
["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"]

{"sheet":"Guidance Notes","index":2,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
["ICB Name","The name of the Sustainability and Transformation Partnership 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"]
["Reason For Change","Please tick applicable box"]
[null,"Please note: NHS Prescription Services will not allocate a new contractor code as a result of this change."]
["Contractor Code","The contractor code for England will follow the (F****) format. For Jersey contractors this will be (JER****)."]
["Date of Change","The date of the changes of the NHS pharmacy contractor"]
["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"]
["LPS Contract","Does the NHS Pharmacy Contractor have a Local Pharmaceutical Service contract.  Choose from drop down box"]
["Distance selling Pharmacy?","Choose from drop down box"]
["Distance selling Pharmacy website address (URL)","If a Distance Selling pharmacy please state website address "]
["Opening Hours","Opening Hours for the contractor in 24 hour clock format - a maximum of three sets of data per day."]
["STP Change","Choose from drop down box"]
["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 ICB (or an agency on their behalf) "]

{"sheet":"HWB","index":3,"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":"Revisions","index":4,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Version","Date","Reason","Editor"]
[4.0999999999999996,"2022-04-01","Formulas missing from G12/G14","LAMAT"]
[4.2,"2022-06-20","Reformatted STP dropdowns to ICB ","MICBU"]
[4.2,"2022-06-20","Reformatted data entry boxes","MICBU"]
[4.2,"2022-06-20","Changed STP-->ICB Terms in Guidance","MICBU"]
[4.3,"2022-06-28","Hidden ' for Rx services use only box'","MICBU"]
[4.3,"2022-06-28","general text input colour set at 'dark red' in line with other forms","MICBU"]
[4.4000000000000004,"2022-06-28","made text bold & slightly larger","LAMAT"]
[4.5,"2023-02-24","removed data avlidation from email cell","LAMAT"]
[4.5999999999999996,"2023-05-10","added migration note - new email","ANSCU"]
[4.7,"2023-05-12","added migration note - new email","ANSCU"]
[4.9000000000000004,"2023-06-29","Updated with new PI email, added new HWB list","LAMAT"]
[5.0999999999999996,"2023-11-22","updated contractor code box character limit to 8 characters for Jersey codes","MICBU"]
[5.0999999999999996,"2023-11-22","updated guidance notes for contractor codes","MICBU"]
[5.2,"2024-01-29","Bedford Borough HWB name updated from Bedford","MICBU"]
[5.3,"2024-03-22","Northamptonshire North HW169 added to HWB list as reported missing by PCSE","MICBU"]
[5.4,"2024-04-02","added NHS Shared Email Address section","MICBU"]
[5.5,"2024-11-05","updated HWB list","MICBU"]

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