{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["SteadyStateDosing","SSNonSteadyStateDosing","ParameterSelection","Regression Analysis Parameters","Time to Steady State Level"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":33,"comments":2,"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":"SteadyStateDosing","index":0,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
[null,"Phenobarbital Population Based Dosing (Pkineticdrugdosing.com)"]
[null,"Select Patient Age Range - Drop Down Box","19 - 65 years"]
[null,"Input Weight (kg)",80]
[null,"Select Interacting Med. Being Taken - Drop Down Box","None"]
[null,"Clearance Multiplication Factor for Drug Interaction",{"$f":"VLOOKUP(C4,ParameterSelection!Q2:R6,2,FALSE)","v":1}]
[null,"Population Volume of Distribution (L/kg)",{"$f":"VLOOKUP(C2,ParameterSelection!G8:I15,3,FALSE)","v":0.61}]
[null,"Calculated Volume of Distribution (Liters)",{"$f":"C6*C3","v":48.8}]
[null,"Population Clearnace (L/hour/kg)",{"$f":"VLOOKUP(C2,ParameterSelection!G8:H15,2,FALSE)","v":4.1666666666666666E-3}]
[null,"Calculated Clearance (L/hours)",{"$f":"C3*C8*C5","v":0.33333333333333331}]
[null,"K calculated (1/hours)",{"$f":"C9/C7","v":6.8306010928961746E-3}]
[null,"Half Life (Days)",{"$f":"0.693/(24*C10)","v":4.2272999999999996},null,null,20]
[null,"Days to 87.5% of Steady State (3 half-lives)",{"$f":"C11*3","v":12.681899999999999}]
[null,"Select Dosage Form (Note IV product is given rectally) Drop Down Box","Oral"]
[null,"Fraction Absorded (F) for Dosage Form",{"$f":"IF(C13=\"IV\",1,IF(C13=\"IM\",1,IF(C13=\"Rectal\",0.9,IF(C13=\"Oral\",1))))","v":1}]
[null,"Salt (S) for Dosage Form",{"$f":"IF(C13=\"IV\",0.91,IF(C13=\"IM\",0.91,IF(C13=\"Oral\",1,IF(C13=\"Rectal\",0.91))))","v":1}]
[null,"Input Peak Level (mg/L) Desired From Loading Dose",20]
[null,"Calculated Loading Dose (mg) Assumed IV  ",{"$f":"C16*C3*C6/0.91","v":1072.5274725274726}]
[null,"Calculated Loading Dose (mg/kg)",{"$f":"C17/C3","v":13.406593406593407}]
[null,"Input Desired Steady State Level (mg/L)",20]
[null,"Calculated Maintenance Dose (mg/day)",{"$f":"C19*C9*24/(C14*C15)","v":160}]
[null,"Calculated Maintenance Dose (mg/kg/day)",{"$f":"C20/C3","v":2}]
[null,"Input Round Dose (mg/day)",200]
[null,"Calculated Steady State Level (mg/L)",{"$f":"C14*C15*C22/(C9*24)","v":25}]
[null," "]
[null,"Serum Level Based Dosing"]
[null,"Input Measured State State Serum Level (mg/L)",29]
[null,"Calculated Days To Obtain Desired Level when Measured Level Is Greater Than Desired Level. Assumes  Doses Are Not Given During This Time Period.",{"$f":"IF(C26>C19,LN(C26/C19)/(C29*24),\"\")","v":2.6291837253162496}]
[null,"Calculated Clearance (L/hour) from level",{"$f":"C14*C15*C22/(24*C26)","v":0.28735632183908044}]
[null,"Calculated K (1/hours) from level",{"$f":"C28/C7","v":5.8884492180139442E-3}]
[null,"Calculated Half-Life (Days) from level",{"$f":"0.693/(24*C29)","v":4.9036679999999997}]
[null,"Daily Dose (mg/day) Required For Desired Level Input Above (Cell C16)",{"$f":"C19*C28*24/(C14*C15)","v":137.93103448275861}]
[null,"Calculated IV Loading Dose (Cp desired - Cp current)*Vd",{"$f":"IF(C26<C19,(C19-C26)*C7/0.91,\"\")","v":""}]
[null,"Input Rounded Dose (mg/day)",0]
[null,"Calculated Steady State Level (mg/L)",{"$f":"C14*C15*C33/(C28*24)","v":0}]
[null,"Days to 93.75% of Steady State Level For Rising Levels",{"$f":"IF(C26<C34,-LN(0.125/(1-C26/C34))/(C37*24),\"\")","v":""}]
[null,"Daily Dose (mg) Used in Table and Graphic Below",{"$f":"IF(ISNUMBER(C33),C33,C22)","v":0}]
[null,"K (1/hours) Used in Table and Graphic Below",{"$f":"IF(ISNUMBER(C28),C28/C7,C10)","v":5.8884492180139442E-3}]
[null,"For Educational Use Only. No warrenties are expressed or implied. "]
[null,"Clear/update all input cells before stating new patient input."]
[]
[null,"Serum Levels Below Are Calculated By The Method of Superposition",null,null,null,"Hide","hide","Hide"]
[null,"Population Based Without Levels or Serum Level Based if Serum Levels 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(C26),C26,\"\")","v":29},null,null,{"$f":"IF(ISNUMBER(C34),C34,C23)","v":0}]
["Day",null,"Peak (mg/L)","Trough Before Next Dose (mg/L)","Average Level (mg/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(C43),(C$14*C$15*C$36/(C$7))+C43,(C$14*C$15*C$36/(C$7)))","v":29},{"$f":"C45*EXP(-C$37*24)","v":25.178061721678439},{"$f":"(C45+D45)/2","v":27.08903086083922},{"$f":"-LN(1-0.875)/(C37*24)","v":14.714128348926517},{"$f":"IF(F45>0,F45,\"\")","v":14.714128348926517},{"$f":"IF(F45>0,-(LN(1-E45/F$43))/(C$37*24),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(F45>0,-LN((F$43-E45)/F$43)/(C$37*24),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(F$45>I45,F$45-I45,\"\")","v":{"$error":"#DIV/0!"}}]
[2,"Dose 2",{"$f":"(C$14*C$15*C$36/(C$7)+D45)","v":25.178061721678439},{"$f":"C46*EXP(-C$37*24)","v":21.859820415884453},{"$f":"(C46+D46)/2","v":23.518941068781444},{"$f":"F45-1","v":13.714128348926517},{"$f":"IF(F46>0,F46,\"\")","v":13.714128348926517},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3,"Dose 3",21.859820415884453,18.978893367446389,20.419356891665423,{"$f":"F46-1","v":12.714128348926517},12.714128348926517,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[4,"Dose 4",18.978893367446389,16.477646503955821,17.728269935701107,{"$f":"F47-1","v":11.714128348926517},11.714128348926517,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[5,"Dose 5",16.477646503955821,14.30604140360685,15.391843953781336,10.714128348926517,10.714128348926517,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[6,"Dose 6",14.30604140360685,12.42063425699657,13.36333783030171,9.7141283489265167,9.7141283489265167,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[7,"Dose 7",12.42063425699657,10.783706756725975,11.602170506861272,8.7141283489265167,8.7141283489265167,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[8,"Dose 8",10.783706756725975,9.3625115279078432,10.073109142316909,7.7141283489265167,7.7141283489265167,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[9,"Dose 9",9.3625115279078432,8.1286170041237789,8.7455642660158119,6.7141283489265167,6.7141283489265167,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[10,"Dose 10",8.1286170041237789,7.0573386428177036,7.5929778234707417,5.7141283489265167,5.7141283489265167,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[11,"Dose 11",7.0573386428177036,6.1272451013672589,6.5922918720924812,4.7141283489265167,4.7141283489265167,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[12,"Dose 12",6.1272451013672589,5.3197294946923011,5.72348729802978,3.7141283489265167,3.7141283489265167,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[13,"Dose 13",5.3197294946923011,4.6186371572412419,4.969183325966771,2.7141283489265167,2.7141283489265167,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[14,"Dose 14",4.6186371572412419,4.0099424625881879,4.3142898099147153,1.7141283489265167,1.7141283489265167,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[15,"Dose 15",4.0099424625881879,3.4814682352905049,3.7457053489393464,0.71412834892651667,0.71412834892651667,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[16,"Dose 16",3.4814682352905049,3.0226421417312848,3.2520551885108948,-0.28587165107348333,"","","",""]
[17,"Dose 17",3.0226421417312848,2.6242851864502277,2.823463664090756,-1.2858716510734833,"","","",""]
[18,"Dose 18",2.6242851864502277,2.2784280827493189,2.4513566345997733,-2.2858716510734833,"","","",""]
[19,"Dose 19",2.2784280827493189,1.9781518239954423,2.1282899533723807,-3.2858716510734833,"","","",""]
[20,"Dose 20",1.9781518239954423,1.717449266186484,1.8478005450909631,-4.2858716510734833,"","","",""]
[21,"Dose 21",1.717449266186484,1.4911049526860221,1.6042771094362531,-5.2858716510734833,"","","",""]
[22,"Dose 22",1.4911049526860221,1.2945907769734164,1.3928478648297191,-6.2858716510734833,"","","",""]
[23,"Dose 23",1.2945907769734164,1.1239753961018044,1.2092830865376105,-7.2858716510734833,"","","",""]
[24,"Dose 24",1.1239753961018044,0.97584558264480015,1.0499104893733022,-8.2858716510734833,"","","",""]
[25,"Dose 25",0.97584558264480015,0.84723794174682887,0.91154176219581451,-9.2858716510734833,"","","",""]
[26,"Dose 26",0.84723794174682887,0.73557962724998138,0.79140878449840513,-10.285871651073483,"","","",""]
[27,"Dose 27",0.73557962724998138,0.63863687090031906,0.68710824907515022,-11.285871651073483,"","","",""]
[28,"Dose 28",0.63863687090031906,0.55447029494026967,0.59655358292029437,-12.285871651073483,"","","",""]
[29,"Dose 29",0.55447029494026967,0.48139611409804689,0.51793320451915825,-13.285871651073483,"","","",""]

{"sheet":"SSNonSteadyStateDosing","index":1,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[null,"Educational Use Only. No warrenties are expressed or implied."]
[null,"Phenobarbital Population Based Dosing ","Pkineticdrugdosing.com"]
[null,"Select Patient Age Range - Drop Down Box","19 - 65 years"]
[null,"Input Weight (kg)"]
[null,"Select Interacting Med. Being Taken - Drop Down Box","None"]
[null,"Clearance Multiplication Factor for Drug Interaction",{"$f":"VLOOKUP(C5,ParameterSelection!Q2:R6,2,FALSE)","v":1}]
[null,"Population Volume of Distribution (L/kg)",{"$f":"VLOOKUP(C3,ParameterSelection!G8:I15,3,FALSE)","v":0.61}]
[null,"Calculated Volume of Distribution (Liters)",{"$f":"C7*C4","v":0}]
[null,"Population Clearnace (L/hour/kg)",{"$f":"VLOOKUP(C3,ParameterSelection!G8:H15,2,FALSE)","v":4.1666666666666666E-3}]
[null,"Calculated Clearance (L/hours)",{"$f":"C4*C9*C6","v":0}]
[null,"K calculated (1/hours)",{"$f":"C10/C8","v":{"$error":"#DIV/0!"}}]
[null,"Half Life (Days)",{"$f":"0.693/(24*C11)","v":{"$error":"#DIV/0!"}},null,null,20]
[null,"Days to 87.5% of Steady State (3 half-lives)",{"$f":"C12*3","v":{"$error":"#DIV/0!"}}]
[null,"Select Dosage Form (Note IV product is given rectally) Drop Down Box","Oral"]
[null,"Fraction Absorbed (F) for Dosage Form",{"$f":"IF(C14=\"IV\",1,IF(C14=\"IM\",1,IF(C14=\"Rectal\",0.9,IF(C14=\"Oral\",1))))","v":1}]
[null,"Salt (S) for Dosage Form (Assume IV is used for Rectal)",{"$f":"IF(C14=\"IV\",0.91,IF(C14=\"IM\",0.91,IF(C14=\"Oral\",1,IF(C14=\"Rectal\",0.91))))","v":1}]
[null,"Input Peak Level (mg/L) Desired From Loading Dose"]
[null,"Calculated Loading Dose (mg) For IV Administration ",{"$f":"C17*C4*C7/0.91","v":0}]
[null,"Calculated Loading Dose (mg/kg)",{"$f":"C18/C4","v":{"$error":"#DIV/0!"}}]
[null,"Input Desired Average Steady State Level (mg/L)"]
[null,"Calculated Maintenance Dose (mg/day)",{"$f":"C20*C10*24/(C15*C16)","v":0}]
[null,"Calculated Maintenance Dose (mg/kg/day)",{"$f":"C21/C4","v":{"$error":"#DIV/0!"}}]
[null,"Enter level before initial dose (mg/L) if drug on board"]
[null,"Enter Number of Doses given "]
[null,"Input Dosing Interval (Hours), usually 24 hours"]
[null,"Input Rounded Dose (mg) per Interval"]
[null,"Calculated Average Steady State Level (mg/L)",{"$f":"C15*C16*C26/(C10*C25)","v":{"$error":"#DIV/0!"}}]
[null,"Expected trough level (mg/L) after N doses administered and entered starting level.",{"$f":"(C$15*C$16*C$26*(1-EXP(-C11*C$24*C25))*EXP(-C11*C25)/(C$8*(1-EXP(-C11*C25))))+C$23*EXP(-C11*C$24*C25)","v":{"$error":"#DIV/0!"}}]
[null," "]
[null,"Patient Specific Dosing Based on Serum Levels "]
[null,"Input Measured Trough Level after N doses administered (mg/L)"]
["hide","Input Multiplier of K (eg 0.75, 1.25, 0.90, 1.10)"]
[null,"Estimate of K (Population K * K multiplier)",3.3888199439359393E-3]
[null,"Estimated Trough Level after N Dose (mg/L)",{"$f":"(C$15*C$16*C$26*(1-EXP(-C33*C$24*C25))*EXP(-C33*C25)/(C$8*(1-EXP(-C33*C25))))+C$23*EXP(-C33*C$24*C25)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISNUMBER(C34),((C34-C31)^2) /(0.1^2*C31^2)+(((C8*C11-C33*C8)^2)/(C8*C11/10)^2),10)","v":10}]
[null,"Predicted Level - Actual Level: (Value to Minimize)",{"$f":"IF(ISNUMBER(C34),(C34-C31)^2,10)","v":10}]
[null,"Calculated Days To Obtain Desired Level (cell c20) when Measured Level Is Greater Than Desired Level. Assumes Doses Are Held During This Time .",{"$f":"IF(C34>C20,LN(C34/C20)/(C38*24),\"\")","v":{"$error":"#DIV/0!"}}]
[null,"Calculated Clearance (L/hour) for measured level",{"$f":"C33*C8","v":0}]
[null,"Calculated K (1/hours) for measured level",{"$f":"C37/C8","v":{"$error":"#DIV/0!"}}]
[null,"Calculated Half-Life (Days) for measured level",{"$f":"0.693/(24*C38)","v":{"$error":"#DIV/0!"}}]
[null,"Daily Dose (mg/day) Required For Desired Level Input Above in Cell C20.",{"$f":"C20*C37*24/(C15*C16)","v":0}]
[null,"Calculated IV Loading Dose (mg) = (Cp average desired - Cp current)*Vd",{"$f":"IF(C34<C20,(C20-C34)*C8/0.91,\"\")","v":{"$error":"#DIV/0!"}}]
[null,"Input Dosing Interval (Hours), usually 24 hours"]
[null,"Input Rounded Dose (mg/day)"]
[null,"Calculated Average Steady State Level (mg/L)",{"$f":"C15*C16*C43/(C37*C42)","v":{"$error":"#DIV/0!"}}]
[null,"Days to 87.5% of Steady State Level For Rising Levels",{"$f":"IF(AND(C34<C44,C34/C44<0.875),-LN(0.125/(1-C34/C44))/(C47*C42),\"\")","v":{"$error":"#DIV/0!"}}]
[null,"Daily Dose (mg) Used in Table and Graphic Below",{"$f":"IF(ISNUMBER(C43),C43,C26)","v":0}]
[null,"K (1/hours) Used in Table and Graphic Below",{"$f":"IF(ISNUMBER(C31),C37/C8,C11)","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 Specifin 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(C34),C34,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(C44),C44,C27)","v":{"$error":"#DIV/0!"}}]
["Dose",null,"Peak (mg/L) After Dose","Trough Before Next Dose (mg/L)","Average Level (mg/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(C53),(C$15*C$16*C$46/(C$8))+C53,(C$15*C$16*C$46/(C$8)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISNUMBER(C$42),C55*EXP(-C$47*C$42),C55*EXP(-C$47*C$25))","v":{"$error":"#DIV/0!"}},{"$f":"(C55+D55)/2","v":{"$error":"#DIV/0!"}},{"$f":"-LN(1-0.875)/(C47*24)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F55>0,F55,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(F55>0,-(LN(1-E55/F$53))/(C$47*24),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(F55>0,-LN((F$53-E55)/F$53)/(C$47*24),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(F$55>I55,F$55-I55,\"\")","v":{"$error":"#DIV/0!"}}]
[2,"Dose 2",{"$f":"(C$15*C$16*C$46/(C$8)+D55)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISNUMBER(C$42),C56*EXP(-C$47*C$42),C56*EXP(-C$47*C$25))","v":{"$error":"#DIV/0!"}},{"$f":"(C56+D56)/2","v":{"$error":"#DIV/0!"}},{"$f":"F55-1","v":{"$error":"#DIV/0!"}},{"$f":"IF(F56>0,F56,\"\")","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":"F56-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":"F57-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":"ParameterSelection","index":2,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,"Dosage Form","Fraction Absormed","Salt","Peak",null,"Age ","Clearnace (L/hr)/kg","Vd (l/kg)","K","T1/2",null,"Winters","Clearance","Vd",null,"Drug Interactions","Clearance Multiplier"]
[null,"IV",1,0.91,"Immediate",null,"< 2 weeks",4.7000000000000002E-3,0.96,{"$f":"H2/I2","v":4.8958333333333336E-3},{"$f":"0.693/J2","v":141.54893617021276},null,null,4.0000000000000001E-3,0.9,null,"None",1]
[null,"IM",1,0.91,3,null,"< 1 year",4.7000000000000002E-3,0.63,{"$f":"H3/I3","v":7.4603174603174605E-3},{"$f":"0.693/J3","v":92.891489361702114},null,null,null,null,null,"Chloramphenicol",0.6]
[null,"Oral",0.9,1,2,null,"1 - < 19 years",8.2000000000000007E-3,0.63,{"$f":"H4/I4","v":1.3015873015873017E-2},{"$f":"0.693/J4","v":53.242682926829261},null,null,8.0000000000000002E-3,0.7,null,"Phenothiazines",1.3]
[null,"Rectal",0.9,0.91,1.5,null,"19-65 years",5.5999999999999999E-3,0.61,{"$f":"H5/I5","v":9.180327868852459E-3},{"$f":"0.693/J5","v":75.487499999999997},null,null,4.0000000000000001E-3,0.7,null,"Valproic Acid (1000 mg/day)",0.75]
[null,null,null,null,null,null,"> 65 years",2.3999999999999998E-3,0.61,{"$f":"H6/I6","v":3.9344262295081967E-3},{"$f":"0.693/J6","v":176.13749999999999},null,null,3.0000000000000001E-3,0.7,null,"Valrpoic Acid (2000 mg/day)",0.5]
[null,null,null,null,null,null,"Age","Clearance L/hr/kg","Vd L/kg","K Calc","T1/2 calc"]
[null,null,null,null,null,null,"Neonates < 2 weeks",6.2500000000000003E-3,0.96,{"$f":"H8/I8","v":6.510416666666667E-3},{"$f":"0.693/J8","v":106.44479999999999}]
[null,null,null,null,null,null,"Infants 2 weeks - < 1 year",1.0416666666666666E-2,0.63,{"$f":"H9/I9","v":1.6534391534391533E-2},{"$f":"0.693/J9","v":41.912639999999996}]
[null,null,null,null,null,null,"1- 5 years",9.3749999999999997E-3,0.63,1.488095238095238E-2,46.569600000000001]
[null,null,null,null,null,null,"5 - < 10 years",7.5000000000000006E-3,0.63,1.1904761904761906E-2,58.211999999999989]
[null,null,null,null,null,null,"10 - < 15 years",6.0416666666666665E-3,0.63,9.5899470899470894E-3,72.2631724137931]
[null,null,null,null,null,null,"15 - < 19 years",5.208333333333333E-3,0.63,8.2671957671957667E-3,83.825279999999992]
[null,null,null,null,null,null,"19 - 65 years",4.1666666666666666E-3,0.61,6.8306010928961746E-3,101.45519999999999]
[null,null,null,null,null,null,"> 65 years",3.2291666666666666E-3,0.61,5.2937158469945353E-3,130.90993548387095]

{"sheet":"Regression Analysis Parameters","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,"Age (min)","Age (max)","average age","Enter Average Weight for age group","ASHP PK Recommended Dose mg/kg/day","Calculated Clearance (L/kg/hour)=D/(Tau*Cpssavg)","ASHP Clearance (l/kg/hour)","Lexicomp mg/kg/day"]
[null,"< 2 weeks",{"$f":"2/52","v":3.8461538461538464E-2},{"$f":"2/52","v":3.8461538461538464E-2},null,3,{"$f":"F2/(20*24)","v":6.2500000000000003E-3},4.7000000000000002E-3]
[null,"2 weeks ","1 year",1,null,5,{"$f":"F3/(20*24)","v":1.0416666666666666E-2},4.7000000000000002E-3,5.5]
["Years",1,5,{"$f":"AVERAGE(B4:C4)","v":3},null,4.5,9.3749999999999997E-3,8.2000000000000007E-3,7]
["Years",5,10,{"$f":"AVERAGE(B5:C5)","v":7.5},null,3.6,7.5000000000000006E-3,8.2000000000000007E-3,5]
["Years",10,15,{"$f":"AVERAGE(B6:C6)","v":12.5},null,2.9,6.0416666666666665E-3,8.2000000000000007E-3,1.5]
["Years",15,19,{"$f":"AVERAGE(B7:C7)","v":17},null,2.5,5.208333333333333E-3,8.2000000000000007E-3,1.5]
["Years",19,65,{"$f":"AVERAGE(B8:C8)","v":42},null,2,4.1666666666666666E-3,5.5999999999999999E-3]
["Years","> 65",82,82,null,{"$f":"(1.1+2)/2","v":1.55},3.2291666666666666E-3,2.3999999999999998E-3]
[null,null,null,null,null,"Phenobarbital pop PK across pedicatric age spectrum"]
[null,null,"< 31 days",{"$f":"2/52","v":3.8461538461538464E-2},null,4,{"$f":"F11/(31.5*24)","v":5.2910052910052907E-3}]
[null,null,"31d- < 2yr",1,null,6,{"$f":"F12/(27.6*24)","v":9.0579710144927522E-3}]
[null,null,"2-12 yr",7,null,6,{"$f":"F13/(31.3*24)","v":7.9872204472843447E-3}]
[null,null,"13-18 Y",15.5,null,5,{"$f":"F14/(30.3*24)","v":6.875687568756875E-3}]

{"sheet":"Time to Steady State Level","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}