{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Amendment Form","Guidance Notes","Revision History","ICB","HWB"],"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":101,"n_cols":8,"rows_kept":101,"cut":false,"hidden":false,"merged":[[73,1,74,1],[73,2,74,7],[68,1,69,1],[59,1,60,1],[55,1,56,1],[72,4,72,5],[71,1,71,7],[64,1,65,1],[64,2,65,7],[66,1,67,1],[62,1,63,1],[61,1,61,7],[62,2,63,7],[68,2,69,7],[57,2,58,4],[55,5,56,7],[47,0,48,0],[66,2,67,7],[70,1,70,7],[59,2,60,7],[57,5,58,7],[55,2,56,4],[57,1,58,1],[51,1,52,1],[53,1,54,1],[47,1,48,1],[49,2,50,4],[51,2,52,4],[53,2,54,4],[47,5,48,7],[49,5,50,7],[51,5,52,7],[15,2,16,4],[15,5,16,5],[15,6,16,7],[21,1,21,7],[22,1,22,7],[15,1,16,1],[18,1,18,7],[17,1,17,7],[19,2,20,4],[19,5,20,5],[19,6,20,7],[19,1,20,1],[10,1,10,7],[13,6,13,7],[11,1,11,7],[14,1,14,7],[13,2,13,4],[12,1,12,7],[47,2,48,4],[44,2,44,7],[40,1,40,7],[53,5,54,7],[49,1,50,1],[46,1,46,7],[42,5,42,7],[43,5,43,7],[42,2,42,4],[43,2,43,4],[45,1,45,7],[41,5,41,7],[36,1,36,7],[41,2,41,4],[39,1,39,7],[23,6,35,7],[23,1,35,1],[32,2,33,4],[34,2,35,4],[28,2,29,4],[30,2,31,4],[23,2,24,4],[26,2,27,4],[37,1,38,1],[37,2,38,3],[37,4,38,4],[37,5,38,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Private CD Dispensing Doctor Form"]
[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!A2:B44,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:B159,2,FALSE)","v":"N/A"}]
[]
[]
[null,"Please tick applicable box"]
[null,null,"New Private CD Dispensing Contractor",null,null,null,"A new private CD dispensing contractor code will be allocated by NHS Prescription Services to the Dispensing Doctor Practice.   "]
[]
[]
[null,"Please note that a new private CD code will not be issued by NHS Prescription Services for any of the scenarios below."]
[null,null,"Change of name"]
[]
[]
[null,null,"Change of address      "]
[]
[null,null,"Change of ICB"]
[]
[null,null,"Change of private CD dispensing contractor trading name"]
[]
[null,null,"Change of telephone number"]
[]
[null,null,"Closure of private CD dispensing contractor"]
[]
[]
[null,null,"Existing private CD dispensing contractor code (if applicable):"]
[]
[]
[null,"New Private CD Dispensing Contractor Details for Dispensing Doctor Practice"]
[null,null,"Existing Private CD dispensing contractor Details:",null,null,"New Private CD dispensing contractor Details:"]
[null,"Private CD dispensing contractor name (max. 40 characters including spaces):"]
[null,"Private CD Contractor Trading Name (max. 40 characters including spaces):"]
[null,"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,"Start date/Date of Change:"]
[]
[]
[null,"Authorised signatory:"]
[]
[null,"Print name:"]
[]
[null,"Contact Number:"]
[]
[null,"Date:"]
[]
[]
[null,"For NHS Prescription Services use only"]
[null,"Date Sent to Newcastle Division",null,"New Private CD dispensing contractor Code",null,null,"Date Letter Sent to ICB"]
[null,"MDR input (Date & Initials)"]
[]
[null,null,null,null,null,null,null,"v 3.8 Jan 2024"]
[]
[]
[]
[]
[]
[]
[]
[null,"New Private CD dispensing contractor Code"]
[]
[]
[]
[null,null,null,"Walk-in Centre"]
[null,null,null,"Out-of-Hours Service"]
[null,null,null,"Walk-in Centre and Out-of-Hours Service"]
[null,null,null,"Public Health Service"]
[null,null,null,"Community Health Service"]
[null,null,null,"Hospital Service"]
[null,null,null,"Optometry Service"]
[null,null,null,"Urgent and Emergency Care"]
[null,null,null,"Hospice"]
[null,null,null,"Care Home/Nursing Home"]
[null,null,null,"Other"]
[]
[null,"Yes (NHS Prescription Services will allocate a code)",null,"Yes",null,null,"Yes (Provide details below)"]
[null,"No",null,"No",null,null,"No"]

{"sheet":"Guidance Notes","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["ICB Name","The name of the ICB that the NHS Pharmacy Contractor is to be attached to."]
["ICB Code","The code of the ICB (Q**)."]
["Health and Wellbeing Board Area","The name of the Health and Wellbeing Board Area the Private CD Pharmacy is in."]
["Health and Wellbeing Board Code","The code of the HWB (HW***)."]
["Please Tick Applicable Box","If the form is for a new Private CD Pharmacy code, NHS Prescription Services will allocate the code.  If the form is for any other amendment then a new private CD pharmacy code will NOT be allocated ."]
["Existing private CD pharmacy code","Quote private CD code (F****)."]
["NHS pharmacy contractor code","Quote NHS Pharmacy Contractor code (F****)."]
["Private CD Pharmacy contractor/owner name "," The name of the Private CD Pharmacy doctor (max. 40 characters including spaces)."]
["Private CD Contractor Trading Name","The Private CD Contractor trading name (max. 40 characters including spaces)."]
["Email address of the CD Dispensing Doctor Practice","The email address of the CD Dispensing doctor practice."]
["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 the Private CD Pharmacy."]
["Start date/Date of Change","Start date or date of change for the Private CD Pharmacy."]
["Authorised Signatory","This is the authorised signatory at the ICB (or an agency on their behalf)."]

{"sheet":"Revision History","index":2,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Version","Date","Reason for change","Editor"]
[2,"2022-06-07","New document created from Private CD Pharmacy Contractor form.","LAMAT"]
[3,"2022-06-17","ICB & HWB Name & Code drop boxes & autopopulation formatted.","MICBU"]
[3,"2022-06-17","Conditionally reformatted all text insert boxes so typed input can be seen at all times.","MICBU"]
[3,"2022-06-17","Replaced all instances of 'Area  Teams' with 'ICB'.","MICBU"]
[3,"2022-06-23","Title on form and form name changed to Private CD Chemist Form","MICBU"]
[3.1,"2022-06-27","Hidden 'for Rx services use only box' (merged cell B70:H73)","MICBU"]
[3.1,"2022-06-27","Hidden 'HWB' dropdown (merged cell B14:H16) & HWB guidance in guidance sheet (cells A4:B5)","MICBU"]
[3.1,"2022-06-27","General text input colour changed to 'Dark Red', in line with other forms","MICBU"]
[3.1,"2022-06-27","Form title changed from 'Private CD Dispensing Contractor - Dispensing Doctor Form' to 'Private CD Dispensing Doctor Form' - in line with stated file name on NHSBSA STP website","MICBU"]
[3.1,"2022-06-27","Tick boxes: 'Change of ICB' & 'Change of private CD dispensing contractor trading name' hidden (Cells: B28:H31) - in line with file on NHSBSA STP website","MICBU"]
[3.1,"2022-06-27","\"Private CD dispensing contractor contractor/owner name\" changed to \"Private CD dispensing contractor name\"","MICBU"]
[3.1,"2022-06-27","\"Private CD Contractor Trading Name (max. 40 characters including spaces)\" (merged cell B42:H42) hidden","MICBU"]
[3.1,"2022-06-27","\"Email address of owner/head office\" changed to \"Email address\"; merged email address boxes into one","MICBU"]
[3.1,"2022-06-27","Guidance Notes Changes: \"The Private CD Contractor trading name (max. 40 characters including spaces).\" (Cell A10:B10, hidden)","MICBU"]
[3.1,"2022-06-27","Guidance Notes Changes: \"The email address of the owner/head office.\" changed to \"the email address of the CD dispensing doctor practice\"","MICBU"]
[3.1,"2022-06-27","Guidance Notes Changes: \"Private CD Pharmacy contractor/owner name\" guidance hidden (Cells A9:B9)","MICBU"]
[3.1,"2022-06-27","New heading column \"New Private CD Dispensing Contractor Details for Dispensing Doctor Practice\" inserted into merged Cells B40:H40","MICBU"]
[3.1,"2022-06-27","data validation max 28 letter limit set for cells C47:H58","MICBU"]
[3.1,"2022-06-27","added heading column: 'Address Details (max. 28 characters including spaces per line)'; merged cells B46:H46","MICBU"]
[3.1,"2022-06-27","unlocked data input cells & dropdowns","MICBU"]
[3.2,"2022-06-28","Changed font to bold ","LAMAT"]
[3.3,"2022-07-13","Set max characters per address line to 25","LAMAT"]
[3.4,"2023-05-11","Added org data email migration information","FAEVE"]
[3.5,"2023-05-25","updated migration date to June 2023","MICBU"]
[3.6,"2023-06-27","updated email info on form header","MICBU"]
[3.7,"2023-08-31","edit Objects' ticked on sheet security for image insertions","MICBU"]
[3.8,"2024-01-29","Bedford Borough HWB name updated from Bedford","MICBU"]

{"sheet":"ICB","index":3,"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":"HWB","index":4,"n_rows":159,"n_cols":2,"rows_kept":159,"cut":false,"hidden":true,"merged":[]}
["Please select HWB","N/A"]
["Bassetlaw ","HW004"]
["Barking and Dagenham ","HW001"]
["Barnet ","HW002"]
["Barnsley ","HW003"]
["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"]
["Central Bedfordshire","HW026"]
["Cheshire East ","HW027"]
["Cheshire West and Chester ","HW028"]
["City of London ","HW029"]
["Cornwall ","HW030"]
["Coventry ","HW031"]
["Croydon ","HW032"]
["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"]
["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 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"]
["Swindon ","HW138"]
["Tameside ","HW139"]
["Telford & Wrekin ","HW140"]
["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"]
["Wigan ","HW154"]
["Wiltshire ","HW155"]
["Windsor and Maidenhead ","HW156"]
["Wirral ","HW157"]
["Wokingham ","HW158"]
["Wolverhampton ","HW159"]
["Worcestershire ","HW160"]
["York ","HW161"]
["Ashford","HW162"]
["Canterbury and Coastal","HW163"]
["South Kent Coast","HW164"]
["Swale","HW165"]
["Thanet","HW166"]