{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SSNonSSDosing","Sheet1","Bayseian Simulation","Comparison of Vd Equations","Comparison of Cl Equations","Parameter"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":33,"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":"SSNonSSDosing","index":0,"n_rows":98,"n_cols":12,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"For educational use only. No warrenties expressed or implied. "]
[null,"https://pkineticdrugdosing.com"]
[null,"Digoxin Population Based Dosing For Adults  ","Pkineticdrugdosing.com"]
[null,"Does the Paitent Have Congestion Heart Failure","Yes"]
[null,"Input Age (Years)"]
[null,"Input Height (Inches)"]
[null,"Input Weight (kg)"]
[null,"Select Sex - Drop Down Box","Male"]
[null,"Serum Creatinine (mg/dL)"]
[null,"Calculated LBW (kg)",{"$f":"IF(C8=\"Male\",(C6-60)*2.3+50,(C6-60)*2.3+45.5)","v":-88}]
[null,"LBW (kg ) Used",{"$f":"IF(C10<=C7,C10,C7)","v":-88}]
[null,"Body Surface Area Calculated Meters Squared",{"$f":"C7^0.425*(C6*2.54)^0.725*(71.84/10000)","v":0}]
[null,"Select Interacting Drug or Disease State - Drop Down Box","None"]
[null,"Clearance Multiplication Factor",{"$f":"VLOOKUP(C13,Parameter!A10:C21,2,FALSE)","v":1},"Vd Multipliers","Clearance Multipliers"]
[null,"Volume of Distribution Multiplication Factor",{"$f":"VLOOKUP(C13,Parameter!A10:C21,3,FALSE)","v":1},"Quinidine  0.7","Amiodarone  0.5"]
[null,"Calculated Creatinine Clearance (ml/min)",{"$f":"IF(C8=\"Male\",(140-C5)*C11/(C9*72),0.85*(140-C5)*C11/(C9*72))","v":{"$error":"#DIV/0!"}},"Hypothyroid 0.7","Canaglifozin 0.8 "]
[null,"Calculated Creatinine Clearance (ml/min/1.73 Sq. meters) ",{"$f":"C16*1.73/C12","v":{"$error":"#DIV/0!"}},"Hyperthyroid  1","Carvedilol  0.75"]
[null,"Population Volume of Distribution (L) Paulson Equation",{"$f":"((4.5+0.028*C17)*C11)*C15","v":{"$error":"#DIV/0!"}},null,"Dronedarone  0.5"]
[null,"Calculated Volume of Distribution (L/kg)",{"$f":"C18/C11","v":{"$error":"#DIV/0!"}},null,"Ketoconazole/Itraconazole  0.5"]
[null,"Population Clearnace (L/hour) Sheiner Equation",{"$f":"IF(C4=\"Yes\", ((0.33*C11+0.9*C16)*60/1000)*C14,(( 0.8*C11+C16)*60/1000))*C14","v":{"$error":"#DIV/0!"}},null,"Propafenone  0.75"]
["hide","Calculated Clearance (L/hours/kg)",{"$f":"C20/C11","v":{"$error":"#DIV/0!"}}]
[null,"K calculated (1/hours)",{"$f":"C20/C18","v":{"$error":"#DIV/0!"}},null,"Quinidine 0.5 "]
[null,"Half-Life (Days)",{"$f":"0.693/(24*C22)","v":{"$error":"#DIV/0!"}},null,"Ranolazine  0.67",20,null,null,null,null,null,"   "]
[null,"Days to 87.5% of Steady State (3 half-lives)",{"$f":"C23*3","v":{"$error":"#DIV/0!"}},null,"Verapamil  0.75   "]
[null,"Select Dosage Form - Drop Down Box","Tablets",null,"Hypothyroid  0.7"]
[null,"Fraction Absorbed (F) for Dosage Form",{"$f":"VLOOKUP(C25,Parameter!B2:D5,2,FALSE)","v":0.7},null,"Hyperthyroid  1.3"]
[null,"Salt (S) for Dosage Form",{"$f":"VLOOKUP(C25,Parameter!B2:D5,3,FALSE)","v":1}]
[null,"Input Desired Peak Level (mcg/L) From Loading Dose"]
[null,"Calculated Loading Dose (mcg) For IV Administration ",{"$f":"C28*C18/(1)","v":{"$error":"#DIV/0!"}},"Enter Time(Hours) until 1st MD for each LD portion"]
["hide","Calculated Loading Dose (mcg/kg) of Lean Body Weight",{"$f":"C29/C11","v":{"$error":"#DIV/0!"}}]
["hide","Calculated Maintenance Dose (mcg/kg/day) of LBW",{"$f":"C38/C11","v":{"$error":"#DIV/0!"}}]
[null,"Enter 1st part of Loading Dose Given (mcg)"]
[null,"Enter 2nd part of Loading Dose Given (mcg)"]
[null,"Enter 3rd part of Loading Dosge Given (mcg)"]
[null,"Calculated Level before 1st MD from Loading Doses",{"$f":"(C32/C18)*EXP(-C22*D32)+(C33/C18)*EXP(-C22*D33)+(C34/C18)*EXP(-C22*D34)","v":{"$error":"#DIV/0!"}}]
[null,"Enter trough level if available. This is a level drawn before the start of themaintenance regimen that is entered below (mcg/L). This could be an admission level."]
[null,"Input Desired Average Steady State Level (mcg/L)"]
[null,"Calculated Maintenance Dose (mcg/day)",{"$f":"C37*24*C20/(C26*C27)","v":{"$error":"#DIV/0!"}}]
[null,"Enter # of Doses given for regimen - Enter 100 for Steady State"]
[null,"Input Dosing Interval (Hours)"]
[null,"Input Rounded Dose (mcg) per Interval"]
[null,"Calculated Average Steady State Level (mcg/L)",{"$f":"C26*C27*C41/(C20*C40)","v":{"$error":"#DIV/0!"}}]
[null,"Expected trough level (mcg/L) from N doses, and starting level or Loading dose(s).",{"$f":"IF(C35=0,(C$26*C$27*C$41*(1-EXP(-C22*C$39*C40))*EXP(-C22*C40)/(C$18*(1-EXP(-C22*C40))))+C$36*EXP(-C22*C$39*C40)+(C32/C18)*EXP(-C22*((C39)*C40+D32))+(C33/C18)*EXP(-C22*((C39)*C40+D33))+(C34/C18)*EXP(-C22*((C39)*C40+D34)),(C$26*C$27*C$41*(1-EXP(-C22*C$39*C40))*EXP(-C22*C40)/(C$18*(1-EXP(-C22*C40))))+(C32/C18)*EXP(-C22*((C39)*C40+D32))+(C33/C18)*EXP(-C22*((C39)*C40+D33))+(C34/C18)*EXP(-C22*((C39)*C40+D34)))","v":{"$error":"#DIV/0!"}}]
[null," "]
[null,"Patient Specific Dosing Based on Serum Levels "]
[null,"Input Measured Trough Level after above dosing regimen  (mcg/L)"]
["Hide","Input Multiplier of K (eg 0.75, 1.25, 0.90, 1.10)"]
[null,"Estimated Trough Level after above regimen (mcg/L)",{"$f":"IF(C35=0,(C$26*C$27*C$41*(1-EXP(-C50*C$39*C40))*EXP(-C50*C40)/(C$18*(1-EXP(-C50*C40))))+C$36*EXP(-C50*C$39*C40)+(C32/C18)*EXP(-C50*((C39)*C40+D32))+(C33/C18)*EXP(-C50*((C39)*C40+D33))+(C34/C18)*EXP(-C50*((C39)*C40+D34)),(C$26*C$27*C$41*(1-EXP(-C50*C$39*C40))*EXP(-C50*C40)/(C$18*(1-EXP(-C50*C40))))+(C32/C18)*EXP(-C50*((C39)*C40+D32))+(C33/C18)*EXP(-C50*((C39)*C40+D33))+(C34/C18)*EXP(-C50*((C39)*C40+D34)))","v":{"$error":"#DIV/0!"}},"Bayesian Function Minimum"]
[null,"(Predicted Level - Actual Level)^2: Value to Minimize",{"$f":"(C46-C48)^2","v":{"$error":"#DIV/0!"}},{"$f":"((C48-C46)^2) /(0.1^2*C46^2)+(((C22*C18-C50*C18)^2)/(C22*C18/10)^2)","v":{"$error":"#DIV/0!"}}]
[null,"Fit Estimate of K ( 1/hours)",1.0565696038817662E-2]
[null,"Calculated Days To Obtain Desired Level (cell c36) When Measured Level Is Greater Than Desired Level. Assumes Doses Are Held During This Time .",{"$f":"IF(C48>C37,LN(C48/C37)/(C53*24),\"\")","v":{"$error":"#DIV/0!"}}]
[null,"Calculated Clearance (L/hour) for measured level",{"$f":"C50*C18","v":{"$error":"#DIV/0!"}}]
[null,"Calculated K (1/hours) for measured level",{"$f":"C52/C18","v":{"$error":"#DIV/0!"}}]
[null,"Calculated Half-Life (Days) for measured level",{"$f":"0.693/(24*C53)","v":{"$error":"#DIV/0!"}}]
[null,"Calculated IV Loading Dose (mcg) = (Cp average desired - Cp current)*Vd",{"$f":"IF(ISNUMBER(C46),IF(C48<C37,(C37-C48)*C18/1,\"\"),\"\")","v":""}]
[null,"Daily Dose (mcg/day) Required For Desired Level Input Above in Cell C36.",{"$f":"C37*C52*24/(C26*C27)","v":{"$error":"#DIV/0!"}}]
[null,"Input Dosing Interval (Hours), usually 24 hours"]
[null,"Input Rounded Dose (mcg/day)"]
[null,"Calculated Average Steady State Level (mcg/L)",{"$f":"C26*C27*C58/(C52*C57)","v":{"$error":"#DIV/0!"}}]
[null,"Days to 87.5% of Steady State Level For Rising Levels",{"$f":"IF(AND(C48<C59,C48/C59<0.875),-LN(0.125/(1-C48/C59))/(C62*C57),\"\")","v":{"$error":"#DIV/0!"}}]
[null,"Daily Dose (mcg) Used in Table and Graphic Below",{"$f":"IF(ISNUMBER(C58),C58,C41)","v":0}]
[null,"K (1/hours) Used in Table and Graphic Below",{"$f":"IF(ISNUMBER(C46),C52/C18,C22)","v":{"$error":"#DIV/0!"}}]
[null,"For Educational Use Only. No warrenties are expressed or implied. "]
[null,"Clear all input cells, except for drop down boxes, by backspacing through them before stating a new patient input."]
[]
[null,"Serum Levels Below Are Calculated By The Method of Superposition",null,null,null,"Hide","hide","Hide"]
[null,"Population Based Dosing Without Levels or Patient Specific if Serum Levels Are Entered.",null,null,null,"Steady State Level Used (mg/L)"]
[null,"Starting Level if drug is on board from Prior Level (mg/L)",{"$f":"IF(ISNUMBER(C46),C48,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(C59),C59,C42)","v":{"$error":"#DIV/0!"}}]
["Dose",null,"Peak (mcg/L) After Dose","Trough Before Next Dose (mcg/L)","Average Level (mcg/L)","Time To Steady State","Days To State State or 4 Half-Lives)","Time to Level (Days) book eq","Time to Level (Days)","Time (Days) from Level to Steady State"]
[1,"Dose 1",{"$f":"IF(ISNUMBER(C68),(C$26*C$27*C$61/(C$18))+C68,(C$26*C$27*C$61/(C$18)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISNUMBER(C$57),C70*EXP(-C$62*C$57),C70*EXP(-C$62*C$40))","v":{"$error":"#DIV/0!"}},{"$f":"(C70+D70)/2","v":{"$error":"#DIV/0!"}},{"$f":"-LN(1-0.875)/(C62*24)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F70>0,F70,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(F70>0,-(LN(1-E70/F$68))/(C$62*24),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(F70>0,-LN((F$68-E70)/F$68)/(C$62*24),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(F$70>I70,F$70-I70,\"\")","v":{"$error":"#DIV/0!"}}]
[2,"Dose 2",{"$f":"(C$26*C$27*C$61/(C$18)+D70)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(C71+D71)/2","v":{"$error":"#DIV/0!"}},{"$f":"F70-1","v":{"$error":"#DIV/0!"}},{"$f":"IF(F71>0,F71,\"\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3,"Dose 3",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"F71-1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[4,"Dose 4",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"F72-1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[5,"Dose 5",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[6,"Dose 6",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[7,"Dose 7",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[8,"Dose 8",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[9,"Dose 9",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[10,"Dose 10",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[11,"Dose 11",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[12,"Dose 12",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[13,"Dose 13",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[14,"Dose 14",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[15,"Dose 15",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[16,"Dose 16",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[17,"Dose 17",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[18,"Dose 18",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[19,"Dose 19",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[20,"Dose 20",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[21,"Dose 21",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[22,"Dose 22",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[23,"Dose 23",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[24,"Dose 24",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[25,"Dose 25",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[26,"Dose 26",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[27,"Dose 27",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[28,"Dose 28",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[29,"Dose 29",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

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

{"sheet":"Bayseian Simulation","index":2,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Input fraction of Predicted Level","Input",null,"Population Clearance for Predicted level","Clearance for Actual Level",{"$f":"J3/E3","v":4}]
[null,null,"Level Multiplier",0.9,"Std Deviation For level","Std Deviation for Level with Weighting","Input Pop Mean Clearance (l/hr)",null,"Input Std Deviation Divider","Input # divisor for Clearance StdDev (# number)","ratio"]
[null,null,"Predicted population Level","Actual Level",0.5,"1/level^2",7.4,null,4,2,{"$f":"J3/E3","v":4}]
[null,null,null,null,"(Cpactual-Cppredicted)^2/SD^2","(Cpactual-Cppredicted)^2/(stddevlevel*Actual Level)^2",null,null,"(Clpop-Clcalculate)^2/(mean CL/#)^2","(Clpop-Clcalc)^2/(mean Cl/#S)^2"]
[null,null,{"$f":"C$15+C$15*1","v":16},{"$f":"C5*D$2","v":14.4},{"$f":"(D5-C5)^2/E$3^2","v":10.239999999999995},{"$f":"E5/D5^2","v":4.9382716049382686E-2},{"$f":"G$15/C5","v":0.46250000000000002},{"$f":"C5/D5*G5","v":0.51388888888888895},{"$f":"(G5-H5)^2/(G5/I$3)^2","v":0.19753086419753116},{"$f":"(G5-H5)^2/(G5/J$3)^2","v":4.938271604938279E-2}]
[null,null,{"$f":"C$15+C$15*0.9","v":15.2},{"$f":"C6*D$2","v":13.68},{"$f":"(D6-C6)^2/E$3^2","v":9.2415999999999947},{"$f":"E6/D6^2","v":4.9382716049382692E-2},0.48684210526315796,{"$f":"C6/D6*G6","v":0.54093567251461994},{"$f":"(G6-H6)^2/(G6/I$3)^2","v":0.19753086419753069},{"$f":"(G6-H6)^2/(G6/J$3)^2","v":4.9382716049382672E-2}]
[null,null,{"$f":"C$15+C$15*0.8","v":14.4},12.96,8.2943999999999942,4.9382716049382672E-2,0.51388888888888895,0.57098765432098775,0.19753086419753105,{"$f":"(G7-H7)^2/(G7/J$3)^2","v":4.9382716049382762E-2}]
[null,null,{"$f":"C$15+C$15*0.7","v":13.6},12.24,7.3983999999999934,4.9382716049382672E-2,0.54411764705882359,0.60457516339869288,0.19753086419753085,4.9382716049382713E-2]
[null,null,{"$f":"C$15+C$15*0.6","v":12.8},11.520000000000001,6.5535999999999932,4.9382716049382658E-2,0.578125,0.64236111111111105,0.19753086419753049,4.9382716049382623E-2]
[null,null,{"$f":"C$15+C$15*0.5","v":12},10.8,{"$f":"(D10-C10)^2/E$3^2","v":5.7599999999999936},4.9382716049382658E-2,0.6166666666666667,0.68518518518518512,0.1975308641975303,4.9382716049382575E-2]
[null,null,{"$f":"C$15+C$15*0.4","v":11.2},10.08,5.0175999999999927,4.9382716049382644E-2,0.66071428571428581,0.73412698412698407,0.19753086419753002,4.9382716049382505E-2]
[null,null,{"$f":"C$15+C$15*0.3","v":10.4},9.3600000000000012,4.3263999999999925,4.9382716049382616E-2,0.71153846153846156,0.79059829059829045,0.19753086419752999,4.9382716049382498E-2]
[null,null,{"$f":"C$15+C$15*0.2","v":9.6},8.64,3.6863999999999928,4.9382716049382616E-2,0.77083333333333337,0.8564814814814814,0.1975308641975303,4.9382716049382575E-2]
[null,null,{"$f":"C$15+C$15*0.1","v":8.8000000000000007},7.9200000000000008,3.0975999999999995,4.9382716049382699E-2,{"$f":"G$15/C14","v":0.84090909090909083},0.93434343434343425,0.19753086419753085,4.9382716049382713E-2]
[null,"Input mean level",8,7.2,2.5599999999999987,4.9382716049382686E-2,{"$f":"G3","v":7.4},{"$f":"C15/D15*G15","v":8.2222222222222232},0.19753086419753116,4.938271604938279E-2]
[null,null,{"$f":"C$15-C$15*0.1","v":7.2},6.48,2.0735999999999986,4.9382716049382672E-2,{"$f":"G$15/C16","v":1.0277777777777779},1.1419753086419755,0.19753086419753105,4.9382716049382762E-2]
[null,null,{"$f":"C$15-C$15*0.2","v":6.4},5.7600000000000007,1.6383999999999983,4.9382716049382658E-2,{"$f":"G$15/C17","v":1.15625},1.2847222222222221,0.19753086419753049,4.9382716049382623E-2]
[null,null,{"$f":"C$15-C$15*0.3","v":5.6},5.04,1.2543999999999982,4.9382716049382644E-2,1.3214285714285716,1.4682539682539681,0.19753086419753002,4.9382716049382505E-2]
[null,null,{"$f":"C$15-C$15*0.4","v":4.8},4.32,0.9215999999999982,4.9382716049382616E-2,1.5416666666666667,1.7129629629629628,0.1975308641975303,4.9382716049382575E-2]
[null,null,{"$f":"C$15-C$15*0.5","v":4},3.6,0.63999999999999968,4.9382716049382686E-2,1.85,2.0555555555555558,0.19753086419753116,4.938271604938279E-2]
[null,null,{"$f":"C$15-C$15*0.6","v":3.2},2.8800000000000003,0.40959999999999958,4.9382716049382658E-2,2.3125,2.5694444444444442,0.19753086419753049,4.9382716049382623E-2]
[null,null,{"$f":"C$15-C$15*0.7","v":2.4000000000000004},2.1600000000000006,0.23039999999999955,4.9382716049382595E-2,3.083333333333333,3.4259259259259252,0.19753086419753035,4.9382716049382588E-2]
[null,null,{"$f":"C$15-C$15*0.8","v":1.5999999999999996},1.4399999999999997,0.10239999999999989,4.9382716049382686E-2,{"$f":"G$15/C23","v":4.6250000000000009},5.1388888888888902,0.19753086419753108,4.9382716049382769E-2]
[null,null,{"$f":"C$15-C$15*0.9","v":0.79999999999999982},0.71999999999999986,{"$f":"(D24-C24)^2/E$3^2","v":2.5599999999999973E-2},4.9382716049382686E-2,9.2500000000000018,10.27777777777778,0.19753086419753108,4.9382716049382769E-2]
[null,null," "," "," "," "]

{"sheet":"Comparison of Vd Equations","index":3,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Height(inches)",70]
[null,null,null,"Lean Body Weight(kg)",70]
[null,null,null,"Surface Area Meters Squared",{"$f":"(E2^0.425)*((E1*2.54)^0.725)*0.007184","v":1.8695346303527745}]
[null,null,null,"Creaatinine Clearance (ml/min)",150,140,130,120,110,100,90,80,70,60,50,40,30,20,10,0]
[null,null,null,"Creatinine Clearance (ml/min/1.73)",{"$f":"E4*1.73/$E3","v":138.80459649524292},129.5509567288934,120.29731696254387,111.04367719619434,101.79003742984482,92.536397663495279,83.282757897145757,74.029118130796235,64.775478364446698,55.521838598097169,46.26819883174764,37.014559065398117,27.760919299048584,18.507279532699059,9.2536397663495293,0]
[null,"Qunidine Study","Williams Eq.","V(L)=(5.05l/kg +(0.0882*clcrml/min))IBW",{"$f":"(5.05+0.0882*E4)*$E2","v":1279.6000000000001},1217.8599999999999,1156.1199999999999,1094.3800000000001,1032.6399999999999,970.90000000000009,909.16,847.42,785.68000000000006,723.93999999999994,662.2,600.45999999999992,538.72,476.98,415.23999999999995,353.5]
[null,null,null,"Williams L/kg ",{"$f":"E6/$E2","v":18.28},17.398,16.515999999999998,15.634000000000002,14.751999999999999,13.870000000000001,12.988,12.106,11.224,10.341999999999999,9.4600000000000009,8.5779999999999994,7.6960000000000006,6.8140000000000001,5.9319999999999995,5.05]
[null,null,"Reuning Eq.","V(L)=3.8*LBW+3.1*clcrml/min",{"$f":"3.8*$E2 +3.1*E4","v":731},700,669,638,607,576,545,514,483,452,421,390,359,328,297,266]
[null,null,null,"Reuning L/kg",{"$f":"E8/$E2","v":10.442857142857143},10,9.5571428571428569,9.1142857142857139,8.6714285714285708,8.2285714285714278,7.7857142857142856,7.3428571428571425,6.9,6.4571428571428573,6.0142857142857142,5.5714285714285712,5.128571428571429,4.6857142857142859,4.2428571428571429,3.8]
[null,null,"Jusko Eq.","V(L)=[226kper1.73m2+(298*Clcrml/min/1.73m2)/(29.1ml/min/1.73+Clcrml/min/1.73)]*SA/1.73",{"$f":"(226+(298*E5)/(29.1+E5))*$E3/1.73","v":510.45083392337989},507.19543682342481,503.53676244015747,499.39492598433026,494.66745194620972,489.22068101022205,482.87693162176436,475.39474969993938,466.43747721395096,455.52119806378357,441.92433701275212,424.52134140080182,401.45396138446353,369.41916180036486,321.92619463976712,244.22822338712547]
[null,null,null,"Jusko L/kg",{"$f":"E10/$E2","v":7.2921547703339984},7.2456490974774974,7.1933823205736784,7.1342132283475754,7.0666778849458529,6.9888668715746007,6.8982418803109198,6.7913535671419911,6.6633925316278706,6.5074456866254797,6.3132048144678876,6.0645905914400258,5.7350565912066216,5.2774165971480693,4.5989456377109592,3.4889746198160783]
[null,null,"Paulson & Welling Eq.","V(L)=(4.5+0.028xclcrml/min/1.73)*LBW",{"$f":"(4.5+0.028*E5)*$E2","v":587.05700913067608},568.91987518863095,550.78274124658606,532.64560730454093,514.50847336249581,496.37133942045079,478.23420547840567,460.0970715363606,441.95993759431548,423.82280365227047,405.6856697102254,387.54853576818027,369.4114018261352,351.27426788409019,333.13713394204507,315]
[null,null,null,"Paulson and Wellinng L/kr",{"$f":"E12/$E2","v":8.3865287018668013},8.1274267884090143,7.8683248749512291,7.6092229614934421,7.3501210480356542,7.0910191345778681,6.8319172211200812,6.5728153076622942,6.3137133942045072,6.0546114807467211,5.7955095672889341,5.5364076538311471,5.2773057403733601,5.018203826915574,4.759101913457787,4.5]
[null,null,"Sheiner Eq.","V(L)=(153+29.5*clcr(L/hr/m2)*BSA",{"$f":"(153+(29.5*E4*60/($E3*1000))*$E3)","v":418.5},400.79999999999995,383.1,365.4,347.7,330,312.29999999999995,294.60000000000002,276.89999999999998,259.2,241.5,223.8,206.1,188.4,170.7,153]
[null,null,null,"Sheiner L/kg",{"$f":"E14/$E2","v":5.9785714285714286},5.7257142857142851,5.4728571428571433,5.22,4.9671428571428571,4.7142857142857144,4.4614285714285709,4.2085714285714291,3.9557142857142855,3.7028571428571428,3.45,3.1971428571428575,2.9442857142857144,2.6914285714285717,2.4385714285714286,2.1857142857142855]
[null,"hide",null,"Mean",{"$f":"AVERAGE(E7,E9,E11,E13,E15)","v":10.076022408725875},{"$f":"AVERAGE(F7,F9,F11,F13,F15)","v":9.6993580343201593},9.3215414391049798,8.9423443808253467,8.5614740723105882,8.1785486298019219,7.7930603917147705,7.4043194892465722,7.0113640423093333,6.6128114334744392,6.2066000192085067,5.7895139347685198,5.3562438948874256,4.8973526562413001,4.3942952245194631,3.8049377811060729]
[null,"hide",null,"Std Dev",{"$f":"_xlfn.STDEV.P(E7,E9,E11,E13,E15)","v":4.3550712643690179},{"$f":"_xlfn.STDEV.P(F7,F9,F11,F13,F15)","v":4.0900115827880583},3.8280285380576933,3.569599905325191,3.3152891255147061,3.0657560769372467,2.8217625147300933,2.5841636688950205,2.3538691423260651,2.1317412212404379,1.9183743031444174,1.7136705355638717,1.5161507800632603,1.3223828880323896,1.1302469417843348,0.97519569790419336]

{"sheet":"Comparison of Cl Equations","index":4,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,null,"Height(inches)",70]
[null,null,"Lean Body Weight(kg)",70]
[null,null,"Surface Area Meters Squared",{"$f":"(D2^0.425)*((D1*2.54)^0.725)*0.007184","v":1.8695346303527745}]
[null,null,"Creatinine Clearance (ml/min)",150,140,130,120,110,100,90,80,70,60,50,40,30,20,10,0]
["Assumed F",null,"Creatinine Clearance (ml/min/1.73 m2)",{"$f":"D4*1.73/$D3","v":138.80459649524292},{"$f":"E4*1.73/$D3","v":129.5509567288934},120.29731696254387,111.04367719619434,101.79003742984482,92.536397663495279,83.282757897145757,74.029118130796235,64.775478364446698,55.521838598097169,46.26819883174764,37.014559065398117,27.760919299048584,18.507279532699059,9.2536397663495293,0]
[0.6,"Koup Eq. CHF","Cl(L/hr)=(1.303*clcrml/min+20 ml/min)*60/1000",{"$f":"(1.303*D4+20)*60/1000","v":12.927},{"$f":"(1.303*E4+20)*60/1000","v":12.145199999999999},11.3634,10.581599999999998,9.7997999999999994,9.0179999999999989,8.2361999999999984,7.4543999999999997,6.6725999999999992,5.8907999999999996,5.1089999999999991,4.3272000000000004,3.5453999999999994,2.7636000000000003,1.9818000000000002,1.2]
[0.6,"Koup Eq. Non CHF","Cl(L/hr)=(1.303*crclml/min+41ml/min)*60/1000",{"$f":"(1.303*D4+41)*60/1000","v":14.186999999999999},{"$f":"(1.303*E4+41)*60/1000","v":13.405199999999999},12.6234,11.841599999999998,11.059799999999999,10.277999999999999,9.4961999999999982,8.7144000000000013,7.932599999999999,7.1507999999999994,6.3689999999999989,5.5872000000000011,4.8054000000000006,4.0236000000000001,3.2418,2.46]
[]
[0.6,"Sheiner Eq. CHF","Cl(L/hr)=(0.78L/hr/m2+(crclL/hr/m2*0.88)*SA",{"$f":"(0.78+(D4/$D3)*(60/1000)*0.88)*$D3","v":9.3782370116751625},{"$f":"(0.78+(E4/$D3)*(60/1000)*0.88)*$D3","v":8.8502370116751639},8.3222370116751652,7.7942370116751647,7.2662370116751642,6.7382370116751638,6.2102370116751642,5.6822370116751637,5.1542370116751632,4.6262370116751645,4.0982370116751641,3.5702370116751641,3.042237011675164,2.514237011675164,1.9862370116751642,1.4582370116751642]
[0.6,"Sheiner Eq. Non CHF","Ck(L/hr)=1.94L/hr/m2 +(clcrml/hr/m2*1.02)*SA",{"$f":"(1.94+(D4/$D3)*60/1000*1.02)*$D3","v":12.806897182884381},{"$f":"(1.94+(E4/$D3)*60/1000*1.02)*$D3","v":12.194897182884381},{"$f":"(1.94+(F4/$D3)*60/1000*1.02)*$D3","v":11.582897182884382},10.970897182884384,10.358897182884384,9.746897182884382,9.1348971828843837,8.5228971828843818,7.9108971828843826,7.2988971828843834,6.6868971828843824,6.0748971828843823,5.4628971828843822,4.8508971828843821,4.2388971828843829,3.6268971828843823]
["hide",null,"Difference Non CHF",{"$f":"D7-D10","v":1.3801028171156187},{"$f":"E7-E10","v":1.2103028171156183},1.0405028171156179,0.87070281711561393,0.70090281711561531,0.53110281711561669,0.36130281711561452,0.19150281711561945,2.1702817115616391E-2,-0.148097182884384,-0.31789718288438351,-0.48769718288438124,-0.65749718288438164,-0.82729718288438203,-0.99709718288438287,-1.1668971828843824]
["hide",null,"Difference CHF",{"$f":"D6-D9","v":3.5487629883248371},{"$f":"E6-E9","v":3.2949629883248353},3.0411629883248352,2.7873629883248334,2.5335629883248352,2.2797629883248351,2.0259629883248342,1.772162988324836,1.518362988324836,1.264562988324835,1.010762988324835,0.75696298832483633,0.50316298832483541,0.24936298832483628,-4.437011675163971E-3,-0.25823701167516422]
[]
[0.82,"Williams Eq.","Cl(L/hr)=3.1L/hr+0.0516*clcrml/min)",{"$f":"3.1+0.0516*D4","v":10.84},10.324,9.8079999999999998,9.2919999999999998,8.7759999999999998,8.26,7.7439999999999998,7.2279999999999998,6.7119999999999997,6.1959999999999997,5.68,5.1639999999999997,4.6479999999999997,4.1319999999999997,3.6160000000000001,3.1]
["hide","Winters Sheiner CHF","Cl(L/hr)=(0.321ml/kg/min*LBW +0.88)*60/100",{"$f":"(0.33*$D2+0.9*D4)*60/1000","v":9.4860000000000007},{"$f":"(0.33*$D2+0.9*E4)*60/1000","v":8.9459999999999997},8.4060000000000006,7.8659999999999997,7.3259999999999996,6.7859999999999996,6.2460000000000004,5.7060000000000004,5.1660000000000004,4.6260000000000003,4.0859999999999994,3.5459999999999998,3.0059999999999998,2.4660000000000002,1.9259999999999999,1.3859999999999999]
["hide","Winters Sheiner Non CHF","Cl(L/hr)=(0.8ml/kg/min*LBW +1.02clcrml/min)*60/1000",{"$f":"(0.8*$D2+1*D4)*60/1000","v":12.36},{"$f":"(0.8*$D2+1*E4)*60/1000","v":11.76},11.16,10.56,9.9600000000000009,9.36,8.76,8.16,7.56,6.96,6.36,5.76,5.16,4.5599999999999996,3.96,3.36]
["hide","Honish Eq. CHF","Cl(L/hr)=(2.22/24*(clcrml/min+25.7)",{"$f":"((2.22/24)*(D4+25.7))","v":16.25225},{"$f":"((2.22/24)*(E4+25.7))","v":15.327250000000001},14.40225,13.477250000000002,12.552250000000001,11.627250000000002,10.702250000000001,9.7772500000000022,8.8522500000000015,7.9272500000000017,7.002250000000001,6.0772500000000012,5.1522500000000013,4.2272500000000006,3.3022500000000008,2.3772500000000001]

{"sheet":"Parameter","index":5,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Sex",null,"Fraction","Salt",null,"ASHP","Vd(L/kg)","Cl (L/hr/M2)",null,"age","age years","IV mcg/kg","Vd (L/kg) calc serum level = 2","Minimum maintenance dose (mcg/kg/day)","Maximum maintenance dose (mcg/kg/day)","Minimum Clearnance Calc (l/hr/kg) Serum Level = 1","Maximum Clearance Calc (l/hr/kg) Serum Level = 1"]
["Male","Capsule",1,1,null,"Neonates",10,1.5,null,"Premature",{"$f":"38/52","v":0.73076923076923073},{"$f":"(15+25)/2","v":20},{"$f":"L2*(1)/(2)","v":10},4,6,{"$f":"(N2)/(1*24)","v":0.16666666666666666},{"$f":"O2/(24)","v":0.25}]
["Female","Elixir",0.8,1,null,"Infants",16.3,11.2,null,"Full term",{"$f":"40/52","v":0.76923076923076927},25,{"$f":"L3*(1)/(2)","v":12.5},5,8,{"$f":"(N3)/(1*24)","v":0.20833333333333334},{"$f":"O3/(24)","v":0.33333333333333331}]
[null,"Injection",1,1,null,"1-12 years",16.100000000000001,8,null,"1 < 2 years",1.5,40,{"$f":"L4*(0.8)/(2)","v":16},9,15,0.375,0.625]
[null,"Tablets",0.7,1,null,"adults",6.7,null,null,"2-5 years",3.5,{"$f":"(25+35)/2","v":30},{"$f":"L5*(0.8)/(2)","v":12},6,9,0.25,0.375]
[null,null,null,null,null,null,null,null,null,"5 - 10 years",7.5,{"$f":"(15+30)/2","v":22.5},{"$f":"L6*(0.8)/(2)","v":9},4,8,0.16666666666666666,0.33333333333333331]
[null,null,null,null,null,null,null,null,null,"> 10 years",10,10,{"$f":"L7*(0.8)/(2)","v":4},2,3,8.3333333333333329E-2,0.125]
[null,null,null,null,null,null,null,null,null,"adults",18,12.5,{"$f":"L8*(0.75)/(2)","v":4.6875},{"$f":"(125)/(70)","v":1.7857142857142858},{"$f":"250/70","v":3.5714285714285716},7.4404761904761904E-2,0.14880952380952381]
["Drug Interaction Clearnarance Multiplier",null,"Vd",null,"CHF Present"]
["None",1,1,null,"Yes"]
["Amiodarone",0.5,1,null,"No"]
["Canaglifozin",0.8,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"10.4/70","v":0.14857142857142858}]
["Carvedilol",0.75,1]
["Dronedarone",0.5,1]
["Ketoconazole/Itraconazole",0.5,1]
["Propafenone",0.75,1]
["Quinidine",0.5,0.7]
["Ranolazine",0.67,1]
["Verapamil",0.75,1]
["Hypothyroidism",0.7,0.7]
["Hyperthyroidism",1.3,1.3]
[]
["Volume of Distribution Multiplier"]
["Hypothyroidism",0.7,0.7]
["Hyperthyroidism",1.3,1.3]
["Quinidine",0.7]