ࡱ;   !"Root EntryF ̊ABook ;CompObj^SummaryInformation(@  FMicrosoft Excel 5.0 WorksheetBiff5Excel.Sheet.5;  Oh+'Oh+'0H`xPK1 functions PK functions Atul DesaistultulMicrosoft Excel@Z@$@Z @3333331@Z0@9@Z8@fffffY@ZB@:@Z H@ffffff3@Z N@*@Z R@@Z U@@Z X@?Z[@$@Z^@$@baMy DocumentsCOMPUTERPC_Soft_ValidationPK3.xlm ValidationAppendix[Appendix # 1]Appendix # 11Y Z blqZ blqZ blqZ 3333331@Z  fffffY@Z  :@Z  ffffff3@Z  *@Z   @Z ?Z blqZ blqAUC_a%j! &L Page &P of &N&C &F&R &D &T98&LMacintosh 7.51&CExcel version 5.0a&RComputer No. 1120L'(ffffff?)?"P??cU} $} 5} !}  ~G8| - W1W/*T  G8     W1 PW1W1(  G81WWW1 , Names StatementsComments CmaxB`-%Define the result -- Number or a Text( Conc_DataBQ0(Select reference of data to be analyzed <&Counter#H ALB2*For loop to check each value in input data]GA#2 H CH BA#2H A5BaYIserror function can check only one value at a time; display the error me  \ Joel Usansky BPK1`_My DocumentsCOMPUTERPC_Soft_ValidationPK3.xlm Validation[for Atul (Outliers,PKMean)]Sheet1YZ?Z@@Z@$@Z @3333331@Z0@9@Z8@fffffY@ZB@:@Z H@ffffff3@Z N@*@Z R@@Z U@@Z X@?Z[@$@Z^@$@baMy DocumentsCOMPUTERPC_Soft_ValidationPK3.xlm ValidationAppendix[Appendix # 1]Appendix # 11Y Z blqZ blqZ blqZ 3333331@Z  fffffY@Z  :@Z  ffffff3@Z  *@Z   @Z ?Z blqZ blqAUC_aAUC_bAUCa AUCbQSb@$Cmax:V , Conc_Data;Z countcounter  counter_val1counter1'Data;Data1*df_adf_b dfaldfb#&ERROR1:5W "'ERROR10:W +'ERROR11:W ,'ERROR12:X -'ERROR13:oX .'ERROR14:X /'ERROR15:Y 0&ERROR2:OY #&ERROR3:Y $&ERROR4:Y %&ERROR5:Y &&ERROR6:Z '&ERROR7:?Z (&ERROR8:oZ )&ERROR9:Z *LOQ, secondHI_val:[[ (Tdata;%[ , Time_Data;U $Tmax:T  = <X@"1Geneva1Geneva1Geneva1Geneva1Geneva1Times New Roman1Times New Roman"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.000000000000000.000                ( &     (   (  (  H (X    H  (  ( (X )x @I@  (  L (\  L (\ 8 ``iݜ*o?H6A^BbzbO/(fvEE>j(9jJ2BBB PK1 @  ~e$30]51:  dMbP?_*+ssage if error. ARe-do the loopS=#2H B@@ #(H A5B3+Error check - negative values in data rangeV@#)2 H AL@@ #+H A5B5-Error check - two or less value in data rangeN 8#2 H AM##H A5B=5Error check - more then one column specified for data -  #2H BB7 Return the results  B6 Halt function execution.   Tmax function  Tmax  B`- %Define the result -- Number or a Text (  Conc_DataBQ0 (Select reference of data to be analyzed ( Time_DataBQ0(Select reference of data to be analyzed <&Counter#'2H ALB2*For loop to check each value in input data]GA#2 H C2H BA#22H A5BaYIserror function can check only one value at a time; display the error message if error. ]GA## H C82H BA#R22H A5BaYIserror function can check only one value at a time; display the error message if error. ARe-do the loopS=#)2H B@@ #L2(H A5B3+Error check - negative values in data rangeO9##2H B@ #$H A5B3+Error check - negative values in data rangeV@#2 H AL@@ #2+H A5B5-Error check - two or less value in data rangeV@##W2 H AL@@ #+H A5B5-Error check - two or less value in data rangedNC#2H A "8R #9H A5B2*Error check - text character in data rangeN8#2 H AM#2#H A5B=5Error check - more then one column specified for dataN8##Y2 H AM##H A5B=5Error check - more then one column specified for data]G#2 H AL##2H AL#2H A5BD<Error check -time and concentration arrays sizes are unequal>(count##u2H ALB80FOR loop to check ascending order of time valuesvA##2 H CH B##22H C2AH B #aH A5B;3Error check -time values are not in ascending orderARe-do the FOR loop secondHI_val+:@#c2H AE$get current value to process #2 H BC!H  D##,25H #2DH B#2WH B@"B7#yH A5B1)calculate the value for the selected dataD,l;bjAYB-bjj7Eo !G8"|#$%&W1'/*()G8*+,W1-P.W1/W101 23G8@456178W9W:;W1 <,=>? "B6 Halt function execution.!!Error Messages!" ERROR1S"!#=7Invalid data - negative or zero value in selected data B7" Display error message# ERROR2K#!$5/Invalid data - two or less values in data rangeB7# Display error message$ ERROR3H$!%2,Invalid data - text character in data rangeB7$ Display error message% ERROR4C%!&-'More than one column specified for dataB7% Display error message& ERROR5T&"'>8Maximum concentration occurs at more than one time pointB7& Display error message& ' ERROR6T'!(>8Invalid data - negative or zero value in time data rangeB7' Display error message' ( ERROR7P(!):4Invalid data - two or less values in time data rangeB7( Display error message) ERROR8L)!*60Invalid data - text character in time data rangeB7) Display error message* ERROR9H*!+2,More than one column specified for time dataB7* Display error message+ ERROR10E+!,/)Time and concentration arrays are unequalB7+ Display error message,ERROR11c,!-MGTime values are not in ascending order or two time values are identicalB7, Display error message-ERROR126-!. LOQ value negative or zeroB7- Display error message.ERROR13C./-'Invalid data -- Check your input valuesB7. Display error message/ERROR14A/0+%Non numerical character for LOQ valueB7/ Display error message0ERROR15A0err+%Non numerical character in input dataB70 Display error message12[3#SPK1 functions -- August -- September 1995; by Atul Desai, M.S. & J.I Usansky, Ph D.456789:;<=>?D lB.z}n{yy _ @AG8B|CDEFW1G/*HIG8JKLW1MPNW1OW1PQ RSG8TUV1WXWYWZ[W1 \,]^_@ABC(((D(((E(((F(((G((((H(((I((((J(((K(((L(((M(((N(((O(((P(((Q(((R(((S(((T(((U(((V(((W(((X(((Y(((Z)(([)((\)((])((^)((_)((Dl `aG8b|cdefW1g/*hiG8jklW1mPnW1oW1pq rsG8tuv1wxWyWz{W1 |,}`)((a)((b)((c)((d)((e)((f)((g)((h)((i)((j)((( k'&$ l'&$ m'&$ n'&$n$ o'&$o$ p'&$p$ q'&$ r'&$ s%$$ t%$$ u%$$ v%$$ w%$$ x'&$ y'&$ z'&$ {%$$ |%$$ }%$$}$@D]:6< @  Refrences: 1) W.H.Beyer, CRC Handbook of Tables for Probability and Statistics; The Chemical Rubber Company, Cleveland, Ohio. 2) Diane D.-S Tang-Liu and P. Joshua Burke, Pharmaceutical Research, Vol 5, No. 4, 1988, pp 238-241h> 3"