{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["For Import","Immunoglobulin issue form VZIG ","Movianto order form","Sheet1","Sheet2","Data extract form","Data validation sheet"],"not_rendered":{"images":3,"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"For Import","index":0,"n_rows":2,"n_cols":43,"rows_kept":2,"hidden":true}
["HPZoneNo","Name of Requester","Date of request","Post","Name of Institution","Postcode","Email","Phone","Name of Patient","NHS number","DOB","Age","AgeCategory","Sex","Reason for issue","Additional info contact","Nature of contact","History of chickenpox","Exposed to","Date of contact","No of days since contact","AB status of exposed","AB result","Quantitative AB test result","Testing Laboratory","Reason why not tested:","Additional info testing","To be issued","Dose","Issue","Doctor Name","GMC No","Issue signed","Order Taken by","Who to administer","Method of delivery","FAO","Surgery name/Ward/Location:","Delivery address:","Delivery town:","Delivery Post Code:","Receipient e-mail address:","Version"]
[{"$f":"'Immunoglobulin issue form VZIG '!H7","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C11","v":0},{"$f":"'Immunoglobulin issue form VZIG '!H11","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C12","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C13","v":0},{"$f":"'Immunoglobulin issue form VZIG '!H13","v":"00:00:00"},{"$f":"'Immunoglobulin issue form VZIG '!H14","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C14","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C16","v":0},{"$f":"'Immunoglobulin issue form VZIG '!I32","v":0},{"$f":"'Immunoglobulin issue form VZIG '!H16","v":0},{"$f":"'Data validation sheet'!I2","v":122},{"$f":"IF(L2<6,\"0-5\",IF(L2<11,\"6-10\",IF(L2<16,\"11-15\",IF(L2<50,\"15-49\",IF(L2<70,\"50-69\",IF(L2>69,\"70 and over\"))))))","v":"70 and over"},{"$f":"'Immunoglobulin issue form VZIG '!F16","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C17","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C18","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C22","v":0},{"$f":"'Immunoglobulin issue form VZIG '!H17","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C23","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C20","v":"00:00:00"},{"$f":"'Immunoglobulin issue form VZIG '!C21","v":0},{"$f":"'Immunoglobulin issue form VZIG '!H20","v":0},{"$f":"IF(V2=\"Qualitative\",'Immunoglobulin issue form VZIG '!H21,\"N/A\")","v":"N/A"},{"$f":"IF(V2=\"Quantitative (mIU/ml)\",'Immunoglobulin issue form VZIG '!H22&\"IU/ml\",\"N/A\")","v":"N/A"},{"$f":"IF(V2=\"Quantitative (mIU/ml)\",'Immunoglobulin issue form VZIG '!H23,\"N/A\")","v":"N/A"},{"$f":"IF(V2=\"Not tested\",'Immunoglobulin issue form VZIG '!H24,\"N/A\")","v":"N/A"},{"$f":"'Immunoglobulin issue form VZIG '!C24","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C26","v":0},{"$f":"'Immunoglobulin issue form VZIG '!F26","v":""},{"$f":"VALUE(LEFT('Immunoglobulin issue form VZIG '!H26,1))","v":{"$error":"#VALUE!"}},{"$f":"'Immunoglobulin issue form VZIG '!C28","v":0},{"$f":"'Immunoglobulin issue form VZIG '!H28","v":0},{"$f":"'Immunoglobulin issue form VZIG '!H30","v":"00:00:00"},{"$f":"'Immunoglobulin issue form VZIG '!C27","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C40","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C41","v":0},{"$f":"'Immunoglobulin issue form VZIG '!G41","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C42","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C43","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C44","v":0},{"$f":"'Immunoglobulin issue form VZIG '!G44","v":0},{"$f":"'Immunoglobulin issue form VZIG '!C46","v":0},{"$f":"'Immunoglobulin issue form VZIG '!I7","v":"Version 8.1\nApril 2022"}]

{"sheet":"Immunoglobulin issue form VZIG ","index":1,"n_rows":114,"n_cols":9,"rows_kept":114,"merged":[[8,0,8,8],[9,0,9,8],[10,0,10,1],[10,2,10,4],[10,7,10,8],[11,0,11,1],[11,2,11,4],[12,2,12,4],[12,7,12,8],[13,0,13,1],[13,2,13,4],[13,7,13,8],[14,0,14,8],[15,2,15,3],[16,2,16,3],[16,4,16,6],[16,7,16,8],[17,2,17,8],[18,0,18,8],[19,0,19,1],[19,5,19,6],[19,7,19,8],[20,5,20,6],[20,7,20,8],[21,2,21,3],[21,5,21,6],[22,2,22,3],[22,7,22,8],[23,2,23,4],[23,5,23,6],[23,7,23,8],[24,0,24,8],[25,0,25,1],[25,2,25,3],[26,0,26,1],[26,2,26,3],[26,5,26,6],[26,7,26,8],[27,2,27,5],[27,7,27,8],[28,0,29,1],[28,2,29,5],[28,7,28,8],[29,7,29,8],[31,2,31,4],[32,2,32,8],[33,2,33,3],[33,7,33,8],[34,2,34,4],[34,6,34,8],[35,0,35,1],[35,2,35,4],[35,6,35,8],[36,2,36,8],[37,2,37,3],[37,6,37,8],[38,0,38,8],[39,0,39,1],[39,2,39,3],[39,4,39,5],[39,6,39,8],[40,0,40,1],[40,2,40,3],[40,4,40,5],[40,6,40,8],[41,0,41,1],[41,2,41,8],[42,0,42,1],[42,2,42,8],[43,0,43,1],[43,2,43,3],[43,4,43,5],[43,6,43,8],[44,0,44,2],[44,4,44,5],[44,6,44,8],[45,0,45,1],[45,2,45,4],[46,0,46,8],[47,0,48,8],[49,1,49,2],[49,3,49,4],[49,7,49,8],[50,0,50,8],[51,1,51,2],[51,5,51,6],[52,1,52,2],[52,5,52,6],[53,1,53,7],[55,1,55,8],[56,1,56,8],[57,0,58,4],[57,5,58,8],[65,0,65,8],[66,0,66,2],[67,2,67,4],[67,6,67,8],[68,2,68,4],[68,6,68,8],[69,2,69,4],[69,6,69,8],[70,2,70,4],[70,6,70,8],[72,6,72,8],[73,0,73,1],[73,2,73,4],[73,6,73,7],[74,2,74,4],[75,0,75,1],[75,2,75,5],[75,7,75,8],[76,0,76,1],[76,2,76,4],[76,6,76,8],[77,0,77,1],[77,2,77,4],[78,0,78,1],[78,2,78,5],[78,7,78,8],[79,0,79,5],[81,0,81,1],[81,2,81,4],[81,5,81,6],[81,7,81,8],[82,0,82,1],[82,2,82,4],[82,7,82,8],[83,0,83,1],[83,2,83,4],[84,0,84,1],[84,2,84,4],[84,5,84,6],[85,0,85,1],[85,2,85,3],[85,6,85,7],[88,2,88,4],[89,5,89,8],[90,0,91,1],[90,2,91,3],[90,4,91,4],[90,5,91,6],[90,7,91,7],[90,8,91,8],[92,0,92,1],[92,2,92,3],[92,6,92,7],[94,0,94,1],[94,2,94,3],[95,2,95,8],[96,1,96,5],[96,7,96,8],[98,0,98,8],[99,0,99,8],[100,1,100,2],[100,5,100,6],[101,1,101,2],[101,5,101,6],[102,1,102,7],[104,1,104,8],[105,1,105,8],[106,0,107,4],[106,5,107,8],[108,0,108,2],[109,0,109,2],[109,3,109,4],[109,5,109,6],[109,7,109,8],[110,5,110,6],[111,0,111,2],[111,3,111,5],[112,0,112,1],[112,4,112,6],[113,5,113,6]]}
[{"$nulls":5},"Rabies and Immunoglobulin Service (RIgS)"]
[{"$nulls":5},"Immunisation and Vaccine Preventable Diseases Division"]
[{"$nulls":5},"UK Health Security Agency"]
[{"$nulls":5},"61 Colindale Avenue"]
[{"$nulls":5},"London NW9 5EQ",null,"Telephone: 0330 128 1020 option 1"]
[]
["Varicella-Zoster Immunoglobulin clinical record form",{"$nulls":5},"HPZone number",null,"Version 8.1\nApril 2022"]
[]
["To be completed electronically for all requests"]
["Requestor"]
["Name of caller or requestor: ",{"$nulls":5},"Date of call:"]
["Post: for example, GP or consultant",{"$nulls":5},"Time of call:"]
["Name of institution:",{"$nulls":5},"Postcode:"]
["Requestor phone number:",{"$nulls":5},"Bleep or extension:"]
["Exposed patient"]
["Name of patient:",{"$nulls":3},"Sex:",null,"Date of birth:",null,{"$f":"IF(H16=\"\",\"\",IF('Data validation sheet'!I2>0,CONCATENATE('Data validation sheet'!I2,\" yrs\"),CONCATENATE('Data validation sheet'!I3,\" wks\")))","v":""}]
["Reason for issue:",{"$nulls":3},"History of chickenpox or shingles?"]
["Additional information: "]
["Risk assessment"]
["Date of contact:",{"$nulls":4},"VZ IgG antibody testing: "]
["Number of days since contact:",null,{"$f":"H11-C20","v":0},null,null,"Qualitative result:"]
["Nature of contact:",{"$nulls":4},"Quantitative result: ",null,null,"mIU/ml"]
["Exposed to? ",{"$nulls":5},"Testing Lab"]
["Additional information: ",{"$nulls":4},"Reason why not tested:"]
["VZIg issue record"]
["To be issued:",{"$nulls":3},"Dose:",{"$f":"IF(C26<\"yes\",\"\",IF('Data validation sheet'!I2<6,\"250 mg\",IF('Data validation sheet'!I2<11,\"500 mg\",IF('Data validation sheet'!I2<15,\"750 mg\",IF('Data validation sheet'!I2>=15,\"1000 mg\",\"\")))))","v":""},"Issue:",{"$f":"IF(C26=\"YES\",CONCATENATE(VALUE(LEFT(F26,4))/250, \" x 250 mg\"),\"\")","v":""}]
["Order taken by:"]
["Duty doctor's name:",{"$nulls":5},"GMC number:"]
["Duty doctor signature:"]
[{"$nulls":6},"Date:"]
["Exposed patient"]
["Patient name:",null,{"$f":"IF(C26=\"yes\",C16,\"\")","v":""},null,null,"Date of birth:",{"$f":"IF(H16>0,H16,\"\")","v":""},"NHS number:"]
["Patient address:"]
["Patient town: ",{"$nulls":3},"Postcode: ",null,"Country:"]
["GP name:",{"$nulls":4},"GP email 1: "]
["Surgery name:",{"$nulls":4},"GP email 2: "]
["GP address: "]
["GP town:",{"$nulls":4},"GP postcode:"]
["VZIG delivery"]
["Where Ig to be administered:",{"$nulls":3},"Contact telephone number:"]
["Method of delivery:",{"$nulls":3},"For the attention of:"]
["Surgery name, ward or location:"]
["Delivery address:"]
["Delivery town:",{"$nulls":3},"Delivery postcode:"]
["In hours only – Movianto account number:",{"$nulls":3},"Fax or phone number:"]
["Recipient email address:"]
["Please email completed form (secure email only) to PHE.RIGS@nhs.net. If you cannot use secure email, please encrypt the form first."]
["For out of hours and Colindale use only: inform on call duty person by telephone, then email this completed form to: BMSonCall@phe.gov.uk\n"]
[]
["Duty person:",null,null,"On call duty person telephoned?",null,null,"Time:"]
["Dosage and timing of VZIG"]
[null,"0 to 5 years ",null,"250mg (1 vial)",null,"11 to 14 years ",null,"750mg (3 vials)"]
[null,"6 to 10 years",null,"500mg (2 vials)",null,"15 years and older ",null,"1000mg (4 vials)"]
[null,"VZIG should be given within 10 days of exposure. Do not delay beyond 7 days in immunocompromised contacts."]
[null,"To be given by slow intramuscular injection.     "]
[null,"If large total doses (more than 5mls) of VZIG are required, administer divided doses at different sites.       "]
[null,"Give second dose if further exposure occurs and more than 3 weeks since administration."]
["Varicella: the green book, chapter 34",{"$nulls":4},"Varicella zoster immunoglobulin"]
[]
[{"$nulls":5},"Rabies and Immunoglobulin Service (RIgS)"]
[{"$nulls":5},"Immunisation and Vaccine Preventable Diseases Division"]
[{"$nulls":5},"UK Health Security Agency"]
[{"$nulls":5},"61 Colindale Avenue"]
[{"$nulls":5},"London NW9 5EQ",null,"Telephone: 0330 128 1020 option 1"]
["VZIg issue record"]
["VZIg has been ordered for delivery by Movianto. This form is to be emailed, faxed or posted to the recipient."]
["Requestor details"]
["Name of requestor: ",null,{"$f":"IF(C11>0,C11,\"\")","v":""},null,null,"Date of call :",{"$f":"IF(H11>0,H11,\"\")","v":""}]
["Post:",null,{"$f":"IF(C12>0,C12,\"\")","v":""},null,null,"Time of call:",{"$f":"IF(H12>0,H12,\"\")","v":""}]
["Name of institution:",null,{"$f":"IF(C13>0,C13,\"\")","v":""},null,null,"Ward or setting:",{"$f":"IF(C42>0,C42,\"\")","v":""}]
["Requester telephone number:",null,{"$f":"IF(C14>0,C14,\"\")","v":""},null,null,"Extension:",{"$f":"IF(H14>0,H14,\"\")","v":""}]
[]
["Patient details",{"$nulls":4},"Reference number:",{"$f":"IF(H7>0,H7,\"\")","v":""}]
["Patient name:",null,{"$f":"IF(C32>0,C32,\"\")","v":""},null,null,"Date of birth:",{"$f":"IF(C26=\"yes\",G32,\"\")","v":""}]
["NHS number:",null,{"$f":"IF(I32>0,I32,\"\")","v":""}]
["Patient address:",null,{"$f":"IF(C33>0,C33,\"\")","v":""},{"$nulls":3},"Postcode:",{"$f":"IF(F34>0,F34,\"\")","v":""}]
["GP name:",null,{"$f":"IF(C35>0,C35,\"\")","v":""}]
["Surgery name:",null,{"$f":"IF(C36>0,C36,\"\")","v":""}]
["GP address:",null,{"$f":"IF(C37>0,C37,\"\")","v":""},{"$nulls":3},"Postcode:",{"$f":"IF(G38>0,G38,\"\")","v":""}]
["Please note: This product should be administered by a registered healthcare professional"]
["VZIG delivery details"]
["Where Ig to be administered:",null,{"$f":"IF(C40>0,C40,\"\")","v":""},null,null,"Method of delivery:",null,{"$f":"IF(C41>0,C41,\"\")","v":""}]
["For the attention of:",null,{"$f":"IF(G41>0,G41,\"\")","v":""},{"$nulls":3},"Movianto reference number:",{"$f":"IF(H111>0,H111,\"\")","v":""}]
["Surgery name, ward or location:",null,{"$f":"IF(C42>0,C42,\"\")","v":""},{"$nulls":3},"Dose required:",{"$f":"IF(F26>0,F26,\"\")","v":""}]
["Delivery address:",null,{"$f":"IF(C43>0,C43,\"\")","v":""},null,null,"Number of vials required:",null,{"$f":"IF(H26>0,H26,\"\")","v":""}]
["Delivery town:",null,{"$f":"IF(C44>0,C44,\"\")","v":""},null,null,"Postcode:",{"$f":"IF(G44>0,G44,\"\")","v":""}]
[]
["Date of contact:",{"$f":"C20","v":"00:00:00"}]
["Number of  days since first day of contact:",{"$f":"C21","v":0},"VZIg to be administered no later than 10 days from first day of contact."]
["For recipient use: on receipt of goods                         ",{"$nulls":4},"   Once completed, please retain for your records."]
["Number of vials:",null,{"$f":"IF(H26>0,H26,\"\")","v":""},null,"Batch number:",null,null,"Expiry date:"]
[]
["Date received: ",null,"_______ /_______ /_________",null,null,"Time received:"," _________ : __________"]
[]
["Correct to order:  ",null,"Yes    /    No"]
["Comment on condition:"]
["Signed: ",{"$nulls":5},"Date:","________ /_________ /__________"]
["If this order is not correct or received more than 24 hours after despatch, please contact the RIgS Team on 0330 128 1020 during office hours."]
["Please note:\nThe advice given is based on the available information. It remains the responsibility of registered healthcare professionals prescribing, supplying or administering medicines to check the medicine is appropriate for the patient. This includes checking doses, contraindications and drug interactions. The clinician should also be aware of potential side effects and communicate these to the patient."]
["Dosage and timing of VZIG"]
[null,"0 to 5 years",null,"250mg (1 vial)",null,"11 to 14 years ",null,"750mg (3 vials)"]
[null,"6 to 10 years",null,"500mg (2 vials)",null,"15 years and older ",null,"1000mg (4 vials)"]
[null,"VZIG should be given within 10 days of exposure. Do not delay beyond 7 days in immunocompromised contacts."]
[null,"To be given by slow intramuscular injection.     "]
[null,"If large total doses (more than 5mls) of VZIG are required, administer divided doses at different sites.       "]
[null,"Give second dose if further exposure occurs and more than 3 weeks since administration."]
["Varicella: the green book, chapter 34",{"$nulls":4},"Varicella zoster immunoglobulin"]
[]
["For Ig clerks use only"]
["Ordered for delivery via Movianto:  ",null,null,{"$f":"IF(C41>0,C41,\"\")","v":""},null,"Movianto account number:",null,{"$f":"IF(D45=\"\",\"\",D45)","v":""}]
[{"$nulls":5},"Movianto reference:"]
["Ordered by RIgS clerk: (name)"]
["Date ordered:",{"$nulls":3},"Scheduled delivery date:"]
["Despatch note emailed to receipient?",{"$nulls":3},{"$f":"IF($D$114= \"no\",Sheet1!M1,\"\")","v":""},"Customer verified:"]

{"sheet":"Movianto order form","index":2,"n_rows":17,"n_cols":4,"rows_kept":17}
["From account 0010981701","Movianto 'in hours' number: 01234224871","Email form to: ","5hour@movianto.com"]
[null,"Movianto 'out of hours' number: 01234 248 570",null,"hiran.hirani@phe.gov.uk"]
["Movianto account number:",{"$f":"'Immunoglobulin issue form VZIG '!D45","v":0},null,"RIGS@phe.gov.uk"]
["HPZone reference number:",{"$f":"'Immunoglobulin issue form VZIG '!H7","v":0},null,"vaccinesupply@phe.gov.uk"]
[]
["Recipient name:",{"$f":"'Immunoglobulin issue form VZIG '!G41","v":0}]
[]
["Address:",{"$f":"'Immunoglobulin issue form VZIG '!C42","v":0}]
[null,{"$f":"'Immunoglobulin issue form VZIG '!C43","v":0}]
[null,{"$f":"'Immunoglobulin issue form VZIG '!C44","v":0}]
[]
["Postcode:",{"$f":"'Immunoglobulin issue form VZIG '!G44","v":0}]
[]
["Contact telephone number:",{"$f":"'Immunoglobulin issue form VZIG '!G40","v":0}]
[]
["Product:","24VZIG250"]
["Amount:",{"$f":"'Immunoglobulin issue form VZIG '!H26","v":""}]

{"sheet":"Sheet1","index":3,"n_rows":5,"n_cols":13,"rows_kept":5,"hidden":true}
["Surgery","yes","negative","pregnant","RIgSg clerk","England","Movianto 5hr","YES",{"$f":"TODAY()","v":"2022-04-27"},{"$f":"NOW()","v":44678.46528680556},"Debbie Cohen","household","faxed /posted"]
["Hospital","no","equivocal","immunocompromised","duty BMS","Wales","Movianto 24hr","NO",null,null,"Teresa Gibbs","school"]
["Clinic",null,"positive","neonate","Issuing Centre","Northern Ireland","MOVIANTO",{"$nulls":3},"Jayesh Shah","community"]
["Other",null,"not tested","other","not sure","Scotland",{"$nulls":4},"Shirley Cole","healthcare"]
[{"$nulls":10},"RIgS Clerk","other"]

{"sheet":"Sheet2","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"hidden":true}
["Changes to Issue 4"]
[]
["Country list","I42"]
["Greater range of options","H48"]
["Now just BMS name, not BMS/Ig Clerk name","H52"]
["Order no, HPZone no and date uploaded added to page 3","Row 151"]
[]
["Changes to issue5"]
["change of telephone number from 7471 to 6204","H5"]
["change of department name","F1/2"]
["delition of method of delivery-Movianto delivery only",null,"changes to Issue 6 - August 2020 for Movianto orders/delivery only-new system"]
["removed packed by BMS"]
["removed order by Colindale RIgS Clerks"]

{"sheet":"Data extract form","index":5,"n_rows":35,"n_cols":2,"rows_kept":35,"hidden":true}
["HPZoneNo",{"$f":"'Immunoglobulin issue form VZIG '!H7","v":0}]
["Name of Requester",{"$f":"'Immunoglobulin issue form VZIG '!C11","v":0}]
["Date of request",{"$f":"'Immunoglobulin issue form VZIG '!H11","v":"00:00:00"}]
["Post",{"$f":"'Immunoglobulin issue form VZIG '!C12","v":0}]
["Name of Institution",{"$f":"'Immunoglobulin issue form VZIG '!C13","v":0}]
["Name of Patient",{"$f":"'Immunoglobulin issue form VZIG '!C16","v":0}]
["NHS number",{"$f":"'Immunoglobulin issue form VZIG '!I32","v":0}]
["DOB",{"$f":"'Immunoglobulin issue form VZIG '!H16","v":"00:00:00"}]
["Age",{"$f":"'Data validation sheet'!I2","v":122}]
["AgeCategory",{"$f":"IF(B9<6,\"0-5\",IF(B9<11,\"6-10\",IF(B9<16,\"11-15\",IF(B9<50,\"15-49\",IF(B9<70,\"50-69\",IF(B9>69,\"70 and over\"))))))","v":"70 and over"}]
["Sex",{"$f":"'Immunoglobulin issue form VZIG '!F16","v":0}]
["Reason for issue",{"$f":"'Immunoglobulin issue form VZIG '!C17","v":0}]
["If pregnant: weeks",{"$f":"'Immunoglobulin issue form VZIG '!#REF!","v":{"$error":"#REF!"}}]
["Immunosuppressed Gp",{"$f":"'Immunoglobulin issue form VZIG '!#REF!","v":{"$error":"#REF!"}}]
["Immunosuppress cause",{"$f":"'Immunoglobulin issue form VZIG '!#REF!","v":{"$error":"#REF!"}}]
["Additional info contact",{"$f":"'Immunoglobulin issue form VZIG '!C18","v":0}]
["Nature of contact",{"$f":"'Immunoglobulin issue form VZIG '!C22","v":0}]
["History of chickenpox",{"$f":"'Immunoglobulin issue form VZIG '!H17","v":0}]
["Exposed to",{"$f":"'Immunoglobulin issue form VZIG '!C23","v":0}]
["Date of contact",{"$f":"'Immunoglobulin issue form VZIG '!C20","v":"00:00:00"}]
["No of days since contact",{"$f":"'Immunoglobulin issue form VZIG '!C21","v":0}]
["AB status of exposed",{"$f":"'Immunoglobulin issue form VZIG '!H20","v":0}]
["AB result",{"$f":"'Immunoglobulin issue form VZIG '!H21","v":0}]
["Quantitative AB test result",{"$f":"CONCATENATE('Immunoglobulin issue form VZIG '!H22, \"IU/ml\")","v":"IU/ml"}]
["Testing Laboratory",{"$f":"'Immunoglobulin issue form VZIG '!H23","v":0}]
["Additional info testing",{"$f":"'Immunoglobulin issue form VZIG '!C24","v":0}]
["To be issued",{"$f":"'Immunoglobulin issue form VZIG '!C26","v":0}]
["Dose",{"$f":"'Immunoglobulin issue form VZIG '!F26","v":""}]
["Issue",{"$f":"VALUE(LEFT('Immunoglobulin issue form VZIG '!H26,1))","v":{"$error":"#VALUE!"}}]
["Doctor Name",{"$f":"'Immunoglobulin issue form VZIG '!C30","v":0}]
["GMC No"]
["Order Taken by",{"$f":"'Immunoglobulin issue form VZIG '!C27","v":0}]
["Who to administer",{"$f":"'Immunoglobulin issue form VZIG '!C40","v":0}]
["Method of delivery",{"$f":"'Immunoglobulin issue form VZIG '!C41","v":0}]
["Batch No",{"$f":"'Immunoglobulin issue form VZIG '!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Data validation sheet","index":6,"n_rows":17,"n_cols":15,"rows_kept":17,"hidden":true}
["Contact","Abtesting","Sex","History of Chickenpox/Shingles","Exposed to","Reason for Issue","Group A/Group B","Condition",{"$f":"'Immunoglobulin issue form VZIG '!H16","v":"00:00:00"},"Method of Delivery",null,null,"BMS on Call",null,"Yes"]
["Household ","Qualitative","Male","Yes - chickenpox","Chickenpox","Pregnant <20 weeks","Group A","ALL",{"$f":"FLOOR(((TODAY()-I1)/365),1)","v":122},"MOVIANTO 5hr",null,null,"Debbie Cohen",null,"No"]
["School/Nursery","Quantitative (mIU/ml)","Female","Yes - shingles","Shingles","Pregnant >= 20 weeks","Group B","AML",{"$f":"FLOOR(((TODAY()-I1)/7),1)","v":6382},"MOVIANTO 24hr",null,null,"Teresa Gibbs"]
["Healthcare setting","Not tested",null,"Vaccinated x1 ","Vaccine","Immunosuppressed",null,"Other Malignancy",null,"MOVIANTO",null,null,"Jayesh Shah"]
["Other",null,null,"Vaccinated x2","Not known","Neonate",null,"Nephrotic syndrome",{"$nulls":4},"Shirley Cole"]
[{"$nulls":3},"No",{"$nulls":3},"Juvenille Arthritis (JLA)",{"$nulls":4},"Tracey Smeulders"]
[null,"if qualitative",null,"Not known",{"$nulls":3},"Rheumatoid arthritis",{"$nulls":4},"RIgS Clerk"]
[null,"Negative",{"$nulls":5},"Crohn's Disease"]
[null,"Positive",{"$nulls":5},"Inflammatory Bowel Disease"]
[null,"Equivocal",{"$nulls":5},"Other Autoimmune"]
[{"$nulls":7},"Liver transplant"]
[null,"if not tested",{"$nulls":5},"Renal transplant"]
[null,"free text - why not",{"$nulls":5},"Other Transplant"]
[{"$nulls":7},"Immunodeficiency "]
[null,"if quantitive",{"$nulls":5},"Other - please specify",{"$f":"IF(H10>0,'Data validation sheet'!I2FLOOR(((H10-H15)/365),1),\"\")","v":{"$error":"#NAME?"}}]
[null,"result in IU/ml"]
[null,"testing lab"]