{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Amendment Form","Guidance Notes","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":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":false,"merged":[[34,2,35,6],[36,2,37,6],[23,1,24,1],[40,1,40,6],[38,2,39,6],[38,1,39,1],[23,2,24,6],[34,1,35,1],[28,1,29,1],[36,1,37,1],[30,1,31,1],[32,1,33,1],[25,1,25,6],[41,2,42,6],[47,2,48,6],[43,1,44,1],[43,2,44,6],[45,1,46,1],[45,2,46,6],[47,1,48,1],[41,1,42,1],[10,1,10,6],[13,5,13,6],[11,1,11,6],[13,2,13,3],[14,1,14,6],[12,1,12,6],[15,1,15,6],[16,1,16,6],[17,1,18,1],[17,2,18,6],[21,1,22,1],[21,2,22,2],[21,5,22,5],[21,6,22,6],[21,3,22,4],[20,1,20,6],[19,1,19,6],[26,0,27,0],[28,2,29,6],[30,2,31,6],[32,2,33,6],[26,2,27,6],[26,1,27,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"New Private CD Prescriber Code"]
[null,"Authorised signatory should complete form and send to: prescriptioninformation@nhsbsa.nhs.uk"]
[]
[null,"ICB Name","Please Select ICB",null,"ICB Code",{"$f":"VLOOKUP(C14,ICB!$A$2:$B$44,2,FALSE)","v":"N/A"}]
[]
[null,"Please note that a new private CD prescriber code will be issued by NHS Prescription Services. Only one private CD prescriber code will be allocated per prescriber – if the prescriber already has a private CD prescribing code, please complete the Notification of a private CD prescriber joining an organisation form."]
[null,"Prescriber Type"]
[null,"Please select from the dropdown box:","Please Select"]
[]
[]
[null,"Private CD Prescriber Details"]
[null,"Private CD Prescriber Name (max. 28 characters including spaces):","Surname:",null,null,"Initial(s):"]
[]
[null,"Title (please select from drop down box):","Please Select"]
[]
[null,"Address Details (max. 25 characters including spaces per line):"]
[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:"]
[]
[]
[null,"Authorised signatory:"]
[]
[null,"Print name:"]
[]
[null,"Contact Number:"]
[]
[null,"Date:"]
[]
[null,null,null,null,null,null,"v4.9 Feb 2025"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Please Select",null,"Please Select"]
[null,null,null,"Doctor",null,"Dr"]
[null,null,null,"Nurse",null,"Mr"]
[null,null,null,"Paramedic (for CD requisition use only)",null,"Mrs"]
[null,null,null,"Optometrist",null,"Miss"]
[null,null,null,"Pharmacist",null,"Ms"]
[null,null,null,"Physiotherapist",null,"Mx"]
[null,null,null,"Radiographer",null,"Sister"]

{"sheet":"Guidance Notes","index":1,"n_rows":15,"n_cols":2,"rows_kept":15,"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**)"]
[null,"Please note that a new private CD prescriber code will be issued by NHS Prescription Services. Only one private CD prescriber code will be allocated per prescriber – if the prescriber already has a private CD prescribing code, please complete the Notification of a private CD prescriber joining an organisation form."]
["Prescriber Type","Choose from the drop down box"]
["Private CD Prescriber Name","The surname and initials of the private CD prescriber (max.28 characters including spaces)"]
["Title","Choose from the drop down box"]
["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 private CD prescriber"]
["Start date/Date of Change","Start date of the private CD prescriber"]
["Authorised Signatory","This is the authorised signatory at the ICB (or an agency on their behalf) "]

{"sheet":"Revision History","index":2,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Version","Date","Reason for change","Editor"]
[4,"2022-06-20","STP Terminology changed to ICB","MICBU"]
[4,"2022-06-20","Please Select' added to dropdowns","MICBU"]
[4,"2022-06-20","ICB dropdowns replaced STP dropdowns","MICBU"]
[4,"2022-06-20","removed NHSBSA Rx Services Use Only bottom section","MICBU"]
[4,"2022-06-20","Conditional reformatting of all text inputs","MICBU"]
[4.0999999999999996,"2022-06-27","Added  'Prescriber Type' heading box (merged cells: B16:G16)","MICBU"]
[4.0999999999999996,"2022-06-27","Added 'Address details (max. 25 characters including spaces per line) heading box (merged cells: B25:G25)","MICBU"]
[4.0999999999999996,"2022-06-27","General text input colour changed to 'Dark Red' in line with other forms","MICBU"]
[4.0999999999999996,"2022-06-27","Bracketed text updated to size 10 font","MICBU"]
[4.0999999999999996,"2022-06-27","data validation max 28 letter limit set for cells C26:G37","MICBU"]
[4.0999999999999996,"2022-06-27","Spelling in optometrist corrected from optomotrist","MICBU"]
[4.0999999999999996,"2022-06-27","unlocked all data input cells & drop downs","MICBU"]
[4.2,"2022-06-28","adjusted font size & made bold, renamed files","LAMAT"]
[4.3,"2022-07-12","Adjusted character limits for address to 25 incl.spaces","LAMAT"]
[4.4000000000000004,"2022-08-12","Increased spacing between sections","LAMAT"]
[4.5,"2023-05-11","Added org data email migration information","FAEVE"]
[4.5999999999999996,"2023-05-25","updated migration date to June 2023","MICBU"]
[4.7,"2023-06-27","updated email information on form header","MICBU"]
[4.8,"2023-08-31","edit Objects' ticked on sheet security for image insertions","MICBU"]
[4.9000000000000004,"2025-02-10","inserted Mx into title list","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"]