{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculations","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"comments":1,"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":"Calculations","index":0,"n_rows":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Vancomycin Bayesian/Non-Bayesian AUC Calculator for Adults Using Steady State Levels",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sex",null,"Vd(l/kg)","Infusion Period (Hours)","Fitting Type","Level Coefficient of Variation","Vd Coefficient of Variation","Cl Coefficient of Variation","Vdpop","Clpop","Parameters"]
[null,null,null,null,"Marshall Pierce PharmD","https://pkineticdrugdosing.com",null,null,null,null,null,null,null,null,null,null,null,null,"Male",null,0.5,0.5,{"$f":"I9","v":"Non-Bayesian"},{"$f":"VLOOKUP($W2,$W$3:$AB$4,2,FALSE)","v":1},{"$f":"VLOOKUP($W2,$W$3:$AB$4,3,FALSE)","v":1},{"$f":"VLOOKUP($W2,$W$3:$AB$4,4,FALSE)","v":1},{"$f":"VLOOKUP($W2,$W$3:$AB$4,5,FALSE)","v":0},{"$f":"VLOOKUP($W2,$W$3:$AB$4,6,FALSE)","v":0},{"$f":"VLOOKUP($W2,$W$3:$AC$4,7,FALSE)","v":2}]
[null,null,null,null," The Solver Add-in must be available for the file to run. In Excel do the following: Click File, Click Options, Click Add-ins, Manage Excel Add-in Click Go, Check Solver Add-in and select OK. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Female",null,0.65,1,"Bayesian",0.1,0.3,0.3,{"$f":"C16","v":0},{"$f":"C17","v":{"$error":"#DIV/0!"}},0]
[null,"Population Based Vancomycin Calculations",null,null,null,"Individual Based Calculations Based on Post Dose Serum Levels",null,null,null," ",null,null,null,null,null,null,null,null,null,null,1,1.5,"Non-Bayesian",1,1,1,0,0,2]
[null,"Input Age (Years)",null,null,"Input Date-Time of Dose Administered Before Levels Drawn (DD/MM/YY HH:MM) Military Time (10/10/22 14:15)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Input Height (Inches)",null,null,null,"Cmax Drawn at Steady State","Cmin Drawn at Steady State",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Using Log Linear Formula"]
[null,"Input Weight (kg)",null,null,"Input Measured Post Dose Levels (mg/L)",null,null,null,{"$f":"IF(AND(ISNUMBER(F7),ISNUMBER(G7)),IF(G7>F7,\"Levels are entered in reverse order. Enter in correct order\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"K",{"$f":"LN($F$7/$G$7)/(($G$8-$F$8)*24)","v":{"$error":"#DIV/0!"}}]
[null,"Select Sex - Drop Down Box","Male",null,"Input Date-Time of Levels (DD/MM/YY HH:MM)      Military Time (10/10/22 15:00)",null,null,null,null,{"$f":"IF(AND(ISNUMBER(F8), ISNUMBER(G8)),IF(G8<F8,\"Dates are entered in reverse order. Enter in correct order\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"peak","trough"]
[null,"Input Most Recent Serum Creatinine (mg/dL)",null,null,"Expected Level (mg/L)               at entered times",{"$f":"IF(ISNUMBER(F8),$F$24*(1-EXP(-$F$18*$C$20))*EXP(-$F$18*(($F$8-$F$5)*24-$C$20))/($F$16*$F$18*$C$20*(1-EXP(-$F$18*$F$22))),\"\")","v":""},{"$f":"IF(ISNUMBER(G8),$F$24*(1-EXP(-$F$18*$C$20))*EXP(-$F$18*(($G$8-$F$5)*24-$C$20))/($F$16*$F$18*$C$20*(1-EXP(-$F$18*$F$22))),\"\")","v":""},"Select Fitting Type Drop Down Box","Non-Bayesian",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$7/(EXP(-W7*((($F$8-$F$5)*24)-$C$20)))","v":{"$error":"#DIV/0!"}},{"$f":"$G$7*EXP(-W7*($C$22-(($G$8-$F$5)*24)))","v":{"$error":"#DIV/0!"}}]
[null,"LBW Calculated (kg)",{"$f":"IF(C8=\"Male\",2.3*(C6-60)+50, 2.3*(C6-60)+ 45.5)","v":-88},null,"Square of Errors          (Measured - Expected)^2 /(Measured*Levelcv)^2",{"$f":"IF(AND(ISNUMBER(F9),ISNUMBER(F7)),(F7-F9)^2/($F7*$X2)^2,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(G7),ISNUMBER(G9)),(G7-G9)^2/($G7*$X2)^2,\"\")","v":""}]
[null,"LBW Used (kg)",{"$f":"IF(C10<=C7,C10,C7)","v":-88},null,"Total Sum of Square of Errors (SSE) = SSE for Levels + (Vdpop-Vdfit)^2/(Vdfit*Vdcv)^2 + (Clpop-Clfit)^2/(Clfit*CLcv)^2",{"$f":"SUM(F10:G10)+(F16-AA2)^2/(F16*Y2)^2 + (F17-AB2)^2/(F17*Z2)^2-AC2","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUC",{"$f":"((W9+X9)*2/$C$20+(W9-X9)/W7)*24/$C$22","v":{"$error":"#DIV/0!"}}]
[null,"Creatinine Clearance Calculated (ml/min)",{"$f":"IF(C8=\"Male\", (140-C5)*C11/(C9*72),(140-C5)*C11*0.85/(C9*72))","v":{"$error":"#DIV/0!"}},null,"cv = coefficient of variation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VD",{"$f":"$F$24*(1-EXP(-W7*$C$20))/(W9*W7*$C$20*(1-EXP(-W7*$C$22)))","v":{"$error":"#DIV/0!"}}]
[null,"Creatinine Clearance (ml/min/1.73 M2)",{"$f":"1.73*C12/C14","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cl",{"$f":"W12*W7","v":{"$error":"#DIV/0!"}}]
[null,"Body Surface Area",{"$f":"((C6*2.54)^0.725)*((C7)^0.425)*0.007184","v":0}]
[null,"Select Vd (L/kg) Population Based ",0.65]
[null,"Vd (Liters) Population Based",{"$f":"C7*C15","v":0},null,"Vd (Liters) Individualized",{"$f":"C16","v":0}]
[null,"Clearance (L/hour) Population Based",{"$f":"(0.00107*C13+0.0052)*0.65*C7","v":{"$error":"#DIV/0!"}},null,"Clearance (L/hr) Individualized",{"$f":"C17","v":{"$error":"#DIV/0!"}}]
[null,"K (1/hours) Population Based",{"$f":"C17/C16","v":{"$error":"#DIV/0!"}},null,"K (1/hours) Individualized",{"$f":"F17/F16","v":{"$error":"#DIV/0!"}}]
[null,"T1/2 (Hours) Populatons Based",{"$f":"0.693/C18","v":{"$error":"#DIV/0!"}},null,"T1/2 (Hours) Individualized",{"$f":"0.693/F18","v":{"$error":"#DIV/0!"}}]
[null,"Select Vancomycin Infusion Period (hours)",2]
[null,"Suggested Tau (hours)",{"$f":"LN(30/15)/C18+C20","v":{"$error":"#DIV/0!"}},null,"Individualized Dose and Frequency Selection"]
[null,"Input Dosage Interval (Hours)",null,null,"Input Dosage Interval (Hours)",{"$f":"C22","v":0}]
[null,"Calculated Dose (mg)",{"$f":"(30*C18*C16*C20*(1-EXP(-C18*C22))/(1-EXP(-C18*C20)))","v":{"$error":"#DIV/0!"}}]
[null,"Input Dose (mg)",null,null,"Input Dose (mg)",{"$f":"C24","v":0}]
[null,"Loading Dose (mg)",{"$f":"C24/(1-EXP(-C18*C22))","v":{"$error":"#DIV/0!"}}]
[null,"Calculated AUC mg*hour/Liter per Day",{"$f":"C24/C17*(24/C22)","v":{"$error":"#DIV/0!"}},null,"Calculated AUC          mg*hour/Liter per Day",{"$f":"F24/F17*24/F22","v":{"$error":"#DIV/0!"}}]
[null,"Calculated Peak (mg/L)",{"$f":"C24*(1-EXP(-C18*C20))/(C16*C18*C20*(1-EXP(-C18*C22)))","v":{"$error":"#DIV/0!"}},null,"Calculated Peak (mg/L)",{"$f":"F24*(1-EXP(-F18*C20))/(F16*F18*C20*(1-EXP(-F18*F22)))","v":{"$error":"#DIV/0!"}}]
[null,"Calculated Trough (mg/L)",{"$f":"C27*EXP(-C18*(C22-C20))","v":{"$error":"#DIV/0!"}},null,"Calculated Trough (mg/L)",{"$f":"F27*EXP(-F18*(F22-C20))","v":{"$error":"#DIV/0!"}}]
[]
[null,"No Warranties are expressed or implied. For educational use only."]
[null,"Suggested readings are located on the links below. "]
[null,"Bayesian Pharmacokinetics:"]
[null,"https://pkineticdrugdosing.com/documents/bayesian.html"]
[null,"AUC Calculations:"]
[null,"https://pkineticdrugdosing.com/documents/AUCCalculationforOneorTwoCompartmentModel.html"]
[null,"Vancomycin General Information:"]
[null,"https://pkineticdrugdosing.com/documents/vancomycin.html"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}