Estimation of pharmacokinetic parameters from non-compartmental variables using Microsoft Excel

Area of Science:

• Pharmacokinetics
• Computational Biology
• Mathematical Modeling

Background:

• Non-compartmental analysis (NCA) provides essential pharmacokinetic insights but relies on direct variable interpretation.
• Compartment modeling offers a more mechanistic understanding of drug disposition but requires complex parameter estimation.
• Bridging NCA and compartment modeling can enhance pharmacokinetic analysis efficiency and accessibility.

Purpose of the Study:

• To develop and validate a novel back analysis (BA) method for converting non-compartmental variables into pharmacokinetic parameters.
• To implement the BA method using accessible tools like Microsoft Excel with Solver and Visual Basic.
• To assess the performance of the BA method in estimating parameters for both one- and two-compartment models.

Main Methods:

• Development of a Microsoft Excel spreadsheet incorporating Solver and Visual Basic functions for the back analysis (BA) method.
• Simulation of pharmacokinetic data to generate non-compartmental variables for analysis.
• Comparison of BA-derived pharmacokinetic parameters against those obtained from a standard modeling software, NONMEM.

Main Results:

• The BA method demonstrated reasonable precision in estimating pharmacokinetic parameters.
• The method exhibited low bias for both fixed and random effect parameters in one- and two-compartment models.
• Pharmacokinetic parameters estimated using BA were comparable to those derived from NONMEM.

Conclusions:

• The developed back analysis (BA) method provides a viable and accurate approach for converting non-compartmental variables to pharmacokinetic parameters.
• The Excel-based implementation makes pharmacokinetic modeling more accessible, particularly for one- and two-compartment models.
• The BA method offers a reliable alternative for pharmacokinetic parameter estimation, showing good agreement with established software.