ADD-IN MACROS FOR RAPID AND VERSATILE CALCULATION OF NON-COMPARTMENTAL PHARMACOKINETIC PARAMETERS ON MICROSOFT-EXCEL SPREADSHEETS

We developed a package of macro programs (named PK_MOMENT) to automati cally calculate non-compartmental pharmacokinetic parameters on Micros oft Excel(R) spreadsheets. These macros include rigorous algorithms to execute moment calculations in a comprehensive manner. An optimum num ber of terminal data points for infinite-time extrapolation can be cal culated with one of these macros so that automatic calculation of infi nite moment parameters. is possible. The moment calculation with PK_MO MENT provided satisfactory results using the hybrid (mixed linear-loga rithmic) trapezoidal method rather than the conventional linear trapez oidal method. The macro-aided pharmacokinetic analyses turned out to b e useful in that the macro-containing cells can be easily copied and p asted to analyze other data sets and that powerful tools of Excel can be utilized. The use of our macros will be significantly time-saving f or routine pharmacokinetic analyses, considering that pharmacokinetic data are usually stored in a spreadsheet format, typically with Excel.