We developed a package of macro programs (named PKMOMENT) to automatically calculate non-compartmental
pharmaacokinetic parameters on Microsoft Excel* spreadsheets. These macros include rigorous algorithms to execute
moment calculations in a comprehensive manner. An optimum number of terminal data points for infinite-time ex-
trapolation can be calculated with one of these macros so that automatic calculation of infinite moment parameters
is possible. The moment calculation with PLMOMENT provided satisfactory results using the hybrid (mixed linear-
logarithmic) trapezoidal method rather than the conventional linear trapezoidal method. The macro-aided pharmaco-
kinetic analyses turned out to be useful in that the macro-containing cells can be easily copied and pasted to analyze
other data sets and that powerful tools of Excel can be utilized. The use of our macros will be significantly time-saving
for routine pharmacokinetic analyses, considering that pharmacokinetic data are usually stored in a spreadsheet for-
mat., typically with Excel.