{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Amendment Form","ICB","Guidance Notes","Revision History"],"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":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":false,"merged":[[23,1,24,1],[23,2,24,6],[19,1,20,1],[27,0,28,0],[29,2,30,6],[27,2,28,6],[27,1,28,1],[29,1,30,1],[26,1,26,6],[25,1,25,6],[42,1,43,1],[37,1,38,1],[31,1,32,1],[33,1,34,1],[35,2,36,6],[37,2,38,6],[39,2,40,6],[42,2,43,6],[41,1,41,6],[31,2,32,6],[33,2,34,6],[39,1,40,1],[35,1,36,1],[16,1,17,1],[16,2,17,6],[21,1,22,1],[21,2,22,2],[21,5,22,5],[21,6,22,6],[19,2,20,6],[21,3,22,4],[18,1,18,6],[15,1,15,6],[10,1,10,6],[13,5,13,6],[11,1,11,6],[13,2,13,3],[14,1,14,6],[12,1,12,6],[44,1,45,1],[44,2,45,6],[46,1,47,1],[46,2,47,6],[48,2,49,6],[48,1,49,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Private CD Prescriber Joining an Organisation"]
[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,"Prescriber Type:"]
[null,"Please select from the dropdown box:","Please Select"]
[]
[null,"Private CD Prescriber Details"]
[null,"Private CD prescriber code:"]
[]
[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,"v 4.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":"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":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**)"]
["Prescriber Type","Choose from the drop down box"]
["Private CD prescriber code","State the prescriber code of the Private CD Prescriber"]
["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","Start date of the private CD prescriber at the organisation"]
["Authorised Signatory","This is the authorised signatory at the ICB (or an agency on their behalf) "]

{"sheet":"Revision History","index":3,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Version","Date","Reason for change","Editor"]
[3,"2022-02-01","New file created from 2017 forms","LAMAT"]
[3.1,"2022-06-10","Changed area team reference to ICB, removed 'for prescription services only'","LAMAT"]
[4,"2022-06-20","All Area Team References in guidance sheet changed to ICB","MICBU"]
[4,"2022-06-20","Conditionally reformatted all data input boxes","MICBU"]
[4,"2022-06-20","Inserted dropdown for ICB Names, automated ICB code population","MICBU"]
[4,"2022-06-20","removed NHSBSA Rx Services Use Only bottom section","MICBU"]
[4.0999999999999996,"2022-06-27","general text input colour changed to 'dark red'","MICBU"]
[4.0999999999999996,"2022-06-27","title updated from 'CD Prescriber Joining an organisation' to 'Private CD Prescriber Joining an Organisation'","MICBU"]
[4.0999999999999996,"2022-06-27","added heading column: 'Address Details (max. 25 characters including spaces per line)'; merged cells B26:G26","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 C27:G40","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.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 info on form header","MICBU"]
[4.8,"2023-08-31","edit Objects' ticked on sheet security for image insertions","MICBU"]
[4.9000000000000004,"2025-02-10","added Mx to title list","MICBU"]