{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Vancomycin calculator","Vanc intermittent infusion","Vancomycin continuous infusion"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Vancomycin calculator","index":0,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,4],[1,1,1,5],[3,3,3,5],[2,3,2,5],[2,1,3,2],[5,3,5,5],[6,3,6,5],[4,3,4,5],[13,3,13,5],[28,1,28,3],[16,1,16,5],[8,5,9,5],[14,1,15,1],[14,2,15,2],[14,3,14,4],[15,3,15,4],[8,3,9,3],[8,4,9,4]]}
[null,"        Note: this is NOT a prescription chart.  Please complete patient details below and file for reference."]
[null," INTRAVENOUS VANCOMYCIN DOSE CALCULATOR FOR ADULT PATIENTS",null,null,null,null,null,null,"Vancomycin Pulsed Infusion",null,null,"Vancomycin Continuous Infusion"]
[null,{"$f":"IF(AND($C$5>=16,$C$9>0,$C$11>0,$C$23=0),\"* Height is a required field - please enter *\",\"Type in the data shown in blue and press <enter> \")","v":"Type in the data shown in blue and press <enter> "},null,"Recommended doses and dosage intervals are shown in black below",null,null,null,null,"CrCL (ml/min)","Dose","Interval","Creat CL (ml/min)","Dose / 12 h"]
[null,null,null,"INITIAL IV LOADING DOSE (intermittent and continuous infusion)",null,null,"< 20",500,48,null,"<20 ","Use pulsed infusion or renal unit guidelines"]
[null,"Age (years)",null,{"$f":"IF(AND(C$22>0,C$23>115),G$24,\"\")","v":""},null,null,"20-29",500,24,null,"20-29",250]
[null,"Height (cm)",null,"REGULAR IV MAINTENANCE DOSE ",null,null,"30-39",750,24,null,"30-39",375]
[null,"OR Height (feet)",null,"Prescribe an intermittent (pulsed) IV infusion OR a continuous IV infusion",null,null,"40-54",500,12,null,"40-54",500]
[null,"(inches)",null,"MODE OF ADMINISTRATION","INTERMITTENT infusion","CONTINUOUS infusion","55-74",750,12,null,"55-74",750]
[null,"Weight (kg)",null,"Time after loading to start FIRST maintenance infusion",{"$f":"IF(E12=\"12 hours\",\"6 to 12 hours after loading dose\",IF(E12=\"24 hours\",\"18 to 24 hours after loading dose\",IF(E12=\"48 hours\",\"36 to 48 hours after loading dose\",\"\")))","v":""},{"$f":"IF(C22=0,\"\",IF(C22>=20,\"Immediately after the loading dose\",\"Use pulsed infusion or renal unit guidelines\"))","v":""},"75-89",1000,12,null,"75-89",1000]
[null,"Sex (m/f)",null,null,null,null,"90-110",1250,12,null,"90-110",1250]
[null,"Creatinine (mmol/L)",null,"Maintenance Dose",{"$f":"IF(L30=\"DATAOK\",H21&\" mg\",\"\")","v":""},{"$f":"IF(AND(L30=\"DATAOK\",C22>=20),L22&\" mg\",\"\")","v":""},">110",1500,12,null,">110",1500]
[null,"Height (cm)",{"$f":"IF(C23>0,C23,\"\")","v":""},"Interval",{"$f":"IF(L30=\"DATAOK\",I21&\" hours\",\"\")","v":""},{"$f":"IF(AND(L30=\"DATAOK\",C22>=20),\"12 hours\",\"\")","v":""},null,"Doses","Interval",null,null,"Doses"]
[null,"Ideal body weight (kg)",{"$f":"IF(L30=\"DATAOK\",C24,\"\")","v":""},"Duration of infusion",{"$f":"IF(L30=\"DATAOK\",(H21/500)&\" hour(s)\",\"\")","v":""},{"$f":"IF(AND(L30=\"DATAOK\",C22>=20),\"12 hours\",\"\")","v":""},null,{"$f":"IF($C$15<20,H4,0)","v":0},{"$f":"IF($C$15<20,I4,0)","v":0},null,null,{"$f":"IF(C15<20,L4,0)","v":0}]
[null,"Weight for creatinine clearance (kg)",{"$f":"IF(L30=\"DATAOK\",C25,\"\")","v":""},"See individual intermittent (pulsed) or continuous infusion worksheets below for vancomycin monitoring guidelines",null,null,null,{"$f":"IF(AND($C$15>=20,$C$15<30),H5,0)","v":0},{"$f":"IF(AND($C$15>=20,$C$15<30),I5,0)","v":0},null,null,{"$f":"IF(AND($C$15>=20,$C$15<30),L5,0)","v":0}]
[null,"Creatinine CL (ml/min)",{"$f":"IF(L30=\"DATAOK\",C22,\"\")","v":""},"Patient Name",null,"Date printed: ",null,{"$f":"IF(AND($C$15>=30,$C$15<40),H6,0)","v":0},{"$f":"IF(AND($C$15>=30,$C$15<40),I6,0)","v":0},null,null,{"$f":"IF(AND($C$15>=30,$C$15<40),L6,0)","v":0}]
[null,null,null,"Patient CHI no.",null,{"$f":"NOW()","v":"2022-02-08T09:49:21.890"},null,{"$f":"IF(AND($C$15>=40,$C$15<55),H7,0)","v":0},{"$f":"IF(AND($C$15>=40,$C$15<55),I7,0)","v":0},null,null,{"$f":"IF(AND($C$15>=40,$C$15<55),L7,0)","v":0}]
[null,{"$f":"IF(L30=\"DATAOK\",\"\",IF($L$30=\"REVIEW DATA\",\"   Highlighted value is outside the range of this calculator. Please correct value or seek advice from pharmacy\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(AND($C$15>=55,$C$15<75),H8,0)","v":0},{"$f":"IF(AND($C$15>=55,$C$15<75),I8,0)","v":0},null,null,{"$f":"IF(AND($C$15>=55,$C$15<75),L8,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($C$15>=75,$C$15<90),H9,0)","v":0},{"$f":"IF(AND($C$15>=75,$C$15<90),I9,0)","v":0},null,null,{"$f":"IF(AND($C$15>=75,$C$15<90),L9,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($C$15>=90,$C$15<=110),H10,0)","v":0},{"$f":"IF(AND($C$15>=90,$C$15<=110),I10,0)","v":0},null,null,{"$f":"IF(AND($C$15>=90,$C$15<=110),L10,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF($C$15>110,H11,0)","v":1500},{"$f":"IF($C$15>110,I11,0)","v":12},null,null,{"$f":"IF($C$15>110,L11,0)","v":1500}]
[null,null,null,null,null,null,"Dose",{"$f":"SUM(H13:H20)","v":1500},{"$f":"SUM(I13:I20)","v":12},null,"Sum",{"$f":"SUM(L13:L20)","v":1500}]
[null,"CrCl",{"$f":"IF(L30=\"DATAOK\",(C$26*(140-$C$5)*$C$14/$C$27),0)","v":0},null,null,null,null,null,null,null,"Dose",{"$f":"IF(L21>0,L21,L13)","v":1500}]
[null,"Height",{"$f":"IF(C$6>0,C$6,(C$7*12+C$8)*2.54)","v":0}]
[null,"IBW",{"$f":"IF(C$23>0,(IF(C$10=\"m\",50+2.3*((C$12-152.4)/2.54),45.5+2.3*((C$12-152.4)/2.54))),\"Not available\")","v":"Not available"},null,null,"Load",{"$f":"IF(C$9<40,\"750 mg over 1.5 hours\",(IF(AND(C$9>=40,C$9<60),\"1000 mg over 2 hours\",(IF(AND(C$9>=60,C$9<=90),\"1500 mg over 3 hours\",\"2000 mg over 4 hours\")))))","v":"750 mg over 1.5 hours"},null,"Patient data","Range min","Range max","Check"]
[null,"MBW",{"$f":"IF(C$9=0,\"\",IF(C$12=0,C$9,(IF(C$9>(C$13+0.2*C$13),(C$13+0.2*C$13),C$9))))","v":""},null,null,null,{"$f":"IF(C$9<40,750,(IF(AND(C$9>=40,C$9<60),1000,(IF(AND(C$9>=60,C$9<=90),1500,2000)))))","v":750},null,"Age Check",16,110,{"$f":"IF($C$5=\"\",\"not entered\",(IF(AND($C$5>=J25,$C$5<=K25),\"OK\",\"outwith range\")))","v":"not entered"}]
[null,"Sex",{"$f":"IF($C$10=\"m\",1.23,IF($C$10=\"f\",1.04,0))","v":0},null,null,null,{"$f":"IF(G$25<H$21,H$21,G$25)","v":1500},null,"Height Check",110,214,{"$f":"IF($C$23=0,\"not entered\",IF(AND($C$23>=J26,$C$23<=K26),\"OK\",\"outwith range\"))","v":"not entered"}]
[null,"Creatinine",{"$f":"IF(AND(C$11>0,C$11<60),60,C$11)","v":0},null,null,"Load",{"$f":"IF(G26=500,\"500 mg over 1 hour\",IF(G26=750,\"750 mg over 1.5 hours\",IF(G26=1000,\"1000 mg over 2 hours\",IF(G26=1250,\"1250 mg over 2.5 hours\",IF(G26=1500,\"1500 mg over 3 hours\",IF(G26=2000,\"2000 mg over 4 hours\",\"\"))))))","v":"1500 mg over 3 hours"},null,"Weight Check",30,300,{"$f":"IF($C$9=\"\",\"not entered\",IF(AND($C$9>=J27,$C$9<=K27),\"OK\",\"outwith range\"))","v":"not entered"}]
[null,null,null,null,null,null,null,null,"Sex Check","M","F",{"$f":"IF($C$10=\"\",\"not entered\",IF(OR($C$10=J28,$C$10=K28),\"OK\",\"outwith range\"))","v":"not entered"}]
[null,"Vancomycin loading dose is based on actual body weight",null,null,null,null,null,null,"Creatinine Check",20,800,{"$f":"IF($C$11=\"\",\"not entered\",IF(AND($C$11>=J29,$C$11<=K29),\"OK\",\"outwith range\"))","v":"not entered"}]
[null,"Revised and tested by Ysobel Gourlay, Gartnavel General Hospital, February 2019  Version 2.1",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($L$25=\"OK\",$L$26=\"OK\",$L$27=\"OK\",$L$28=\"OK\",$L$29=\"OK\"),\"DATAOK\",IF(OR($L$25=\"outwith range\",$L$26=\"outwith range\",$L$27=\"outwith range\",$L$28=\"outwith range\",$L$29=\"outwith range\"),\"REVIEW DATA\",\"DATA NOT COMPLETE\"))","v":"DATA NOT COMPLETE"}]
[null,"Devised by Alison Thomson, NHSGGC"]

{"sheet":"Vanc intermittent infusion","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,8,18,10],[19,8,20,10],[15,6,16,7],[17,6,20,7],[21,6,21,7],[22,6,22,7],[15,8,16,10],[9,3,9,4],[11,2,11,4],[10,7,10,10],[11,7,11,10],[14,8,14,10],[9,7,9,10],[13,6,13,10],[14,6,14,7],[7,6,7,7],[8,7,8,10],[6,3,6,4],[7,3,7,4],[8,3,8,4],[4,6,4,10],[5,6,5,10],[6,6,6,7],[5,3,5,4],[4,2,4,4]]}
[]
[null,null,null,null,null,null,"Vancomycin Intermittent (Pulsed) Infusion "]
[null,null,null,null,null,null,"Dosing and monitoring advice"]
[]
[null,null,"VANCOMYCIN LOADING DOSE",null,null,null,"MONITORING OF VANCOMYCIN CONCENTRATIONS"]
[null,null,"Actual body weight","Dose",null,null,"Target concentration (trough at the end of the dosage interval) "]
[null,null,"< 40 kg","750 mg in 250 ml saline over 1.5 hours",null,null,"Standard:",null,"10 – 20 mg/L "]
[null,null,"40 - 59 kg","1000 mg in 250 ml saline over 2 hours",null,null,"Severe or deep-seated infections:",null,"15 - 20 mg/L "]
[null,null,"60 - 90 kg","1500 mg in 500 ml saline over 3 hours",null,null,"1.","Take a trough sample at the end of the dosage interval after 24 – 48 hours of therapy then every 2 - 3 days or daily if the patient has unstable renal function."]
[null,null,">90 kg","2000 mg in 500 ml saline over 4 hours",null,null,"2.","Use the NHS GGC monitoring form to record dosage and sampling details.  "]
[null,null,null,null,null,null,"3.","Record the times of the last dose and the blood sample on the request form and the sample time on the sample tube.  "]
[null,null,"VANCOMYCIN MAINTENANCE INTERMITTENT INFUSIONS",null,null,null,"4.","Seek advice from pharmacy or microbiology if you need help to interpret the result."]
[null,null,"CrCL (ml/min)","Dose amount","Dosage interval"]
[null,null,"< 20","500 mg over 1 h ","48 hours",null,"ADJUSTMENT OF INTERMITTENT INFUSION DOSAGE REGIMEN"]
[null,null,"20 - 29","500 mg over 1 h ","24 hours",null,"Vancomycin concentration",null,"Suggested dose change"]
[null,null,"30 - 39","750 mg over 1.5 h ","24 hours",null,"< 10 mg/L",null,"Increase the dose by 50% and consider reducing the dosage interval or seek advice"]
[null,null,"40 - 54","500 mg over 1 h ","12 hours"]
[null,null,"55 - 74","750 mg over 1.5 h ","12 hours",null,"10 - 15 mg/L",null,"If the patient is responding, maintain the present dosage regimen   "]
[null,null,"75 - 89","1000 mg over 2 h ","12 hours"]
[null,null,"90 - 110","1250 mg over 2.5 h ","12 hours",null,null,null,"If the patient is seriously ill, consider increasing the dose amount or reducing the dosage interval to achieve a trough level of 15 - 20 mg/L   "]
[null,null,"> 110","1500 mg over 3 h ","12 hours"]
[null,null,null,null,null,null,"15 - 20 mg/L",null,"Maintain the present dosage regimen"]
[null,null,null,null,null,null,"> 20 mg/L",null,"Stop until < 20 mg/L then seek advice"]

{"sheet":"Vancomycin continuous infusion","index":2,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[6,6,7,11],[5,6,5,11],[18,8,18,10],[13,7,13,10],[15,8,15,10],[14,8,14,10],[8,7,8,11],[9,7,9,11],[10,7,10,11],[11,7,11,11],[16,8,16,10],[17,8,17,10],[14,3,14,4],[5,2,5,4],[6,3,6,4],[7,3,7,4],[10,3,10,4],[8,3,8,4],[12,2,12,4],[9,3,9,4]]}
[]
[]
[null,null,null,null,null,"Vancomycin Continuous Infusion "]
[null,null,null,null,null,"Dosing and monitoring advice"]
[]
[null,null,"VANCOMYCIN LOADING DOSE",null,null,null,"MONITORING OF VANCOMYCIN CONCENTRATIONS "]
[null,null,"Actual body weight","Dose",null,null,"Target concentration range: 15 - 25 mg/L"]
[null,null,"< 40 kg","750 mg in 250 ml saline over 1.5  hours"]
[null,null,"40 - 59 kg","1000 mg in 250 ml saline over 2 hours",null,null,"1.","Take a sample 12 - 24 hours after starting the continuous infusion then every 1 - 2 days or daily if the patient has unstable renal function."]
[null,null,"60 - 90 kg","1500 mg in 500 ml saline over 3 hours",null,null,"2.","Use the NHS GGC monitoring form to record dosage and sampling details.  "]
[null,null,">90 kg","2000 mg in 500 ml saline over 4 hours",null,null,"3.","Record the times of the blood sample on the request form and the sample tube.  "]
[null,null,null,null,null,null,"4.","Seek advice from pharmacy or microbiology if you need help to interpret the result."]
[null,null,"VANCOMYCIN  MAINTENANCE CONTINUOUS INFUSION"]
[null,null,"CrCL (ml/min)","Daily dose","Dose for continuous infusion over 12 hours",null,null,"ADJUSTMENT OF CONTINUOUS INFUSION DOSAGE REGIMEN"]
[null,null,"< 20","Used pulsed infusion or follow Renal Unit guidelines",null,null,null,"Vancomycin concentration","Suggested dose change"]
[null,null,"20 - 29","500 mg","250 mg",null,null,"< 15 mg/L","Increase the 12 hourly dose by 250 mg"]
[null,null,"30 - 39","750 mg","375 mg",null,null,"15 - 25 mg/L","No change"]
[null,null,"40 - 54","1000 mg","500 mg",null,null,">25 - 30 mg/L","Decrease the 12 hourly dose by 250 mg"]
[null,null,"55 - 74","1500 mg","750 mg",null,null,"> 30 mg/L","Stop until < 25 mg/L then restart at a lower dose"]
[null,null,"75 - 89","2000 mg","1000 mg"]
[null,null,"90 - 110","2500 mg","1250 mg"]
[null,null,"> 110","3000 mg","1500 mg"]