Related Experiment Video
Updated: Jun 16, 2026
14:34
A Bilingual Computational Workflow for Identifying Potential PLK1 Inhibitors in American Sign Language and English
Published on: April 3, 2026
PKSolver: An add-in program for pharmacokinetic and pharmacodynamic data analysis in Microsoft Excel
Yong Zhang1, Meirong Huo, Jianping Zhou
1Department of Pharmaceutics, China Pharmaceutical University, No.24, Tongjiaxiang, 210009, Nanjing, China.
Computer Methods and Programs in Biomedicine
|February 24, 2010
Summary
PKSolver is a new Excel add-in for pharmacokinetic (PK) and pharmacodynamic (PD) analysis. It simplifies data analysis with various modules and provides satisfactory results compared to professional software.
Area of Science:
- Pharmacokinetics and Pharmacodynamics
- Computational Biology
- Biostatistics
Background:
- Pharmacokinetic (PK) and pharmacodynamic (PD) data analysis is crucial in drug development.
- Existing software can be complex or costly for routine analysis.
- There is a need for user-friendly tools for basic PK/PD data analysis.
Purpose of the Study:
- To introduce PKSolver, a Microsoft Excel add-in for PK/PD data analysis.
- To provide a freely available, menu-driven tool for researchers.
- To offer modules for noncompartmental analysis (NCA), compartmental analysis (CA), and specialized models like multiple absorption sites (MAS) and enterohepatic circulation (EHC).
Main Methods:
- PKSolver was developed using Visual Basic for Applications (VBA) within Microsoft Excel.
- It includes modules for NCA, CA, PD modeling, MAS, and EHC.
- Twenty common PK functions were encoded as macros for direct spreadsheet access.
- Model performance was validated by comparing PKSolver's parameter estimates with those from WinNonlin and Scientist software.
Main Results:
- PKSolver demonstrated satisfactory performance in estimating PK parameters.
- The program successfully fitted PK data, including complex profiles like double-peak concentration-time data.
- Parameter estimates from PKSolver showed good agreement with established professional software.
Conclusions:
- PKSolver offers a fast, easy-to-use, and user-friendly interface for routine PK/PD data analysis.
- The integrated report generation feature in Microsoft Word enhances usability.
- PKSolver serves as a valuable, accessible tool for pharmacokinetic researchers.
Related Concept Videos
01:12Analysis of Population Pharmacokinetic Data
Analysis of population pharmacokinetic data involves studying the behavior of drugs within diverse populations to understand their pharmacokinetic parameters. Traditional pharmacokinetic methods typically involve collecting samples from a few individuals and estimating these parameters. While these methods are commonly used, they have limitations in capturing the variability in drug response among individuals or heterogeneous populations. Population pharmacokinetics is employed to address these...
01:17Performing a Simple Data Analysis using MS-Excel Function
Microsoft Excel offers a suite of functions and tools ideal for statistical analysis, making it accessible to students and researchers. This article outlines fundamental Excel functions pivotal for data analysis.
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
01:26Pharmacokinetic–Pharmacodynamic Relationship: Exposure, Response and Effect
The pharmacokinetic-pharmacodynamic (PK-PD) relationship describes the intricate link between drug exposure, efficacy, and toxicity, forming the foundation for optimal dosing regimens. This relationship uses mathematical modeling to characterize drug concentration-effect dynamics, ensuring precise therapeutic outcomes.Exposure represents the pharmacokinetic aspect of the PK-PD relationship, denoting the drug amount that elicits a biological response. It is typically quantified by administered...
01:24Pharmacokinetic–Pharmacodynamic Relationship: Problems
The empirical approach to drug therapy optimization relies on correlating pharmacological response with administered dosage. Such an approach can be costly, time-consuming, and often yields poor correlation due to variables like formulation factors and drug elimination characteristics. A more precise approach correlates response with plasma drug concentration or the amount of drug in the body, rather than dosage. This is achieved through pharmacokinetic-pharmacodynamic (PK/PD) modeling, which...
00:59Model-Independent Approaches for Pharmacokinetic Data: Noncompartmental Analysis
Noncompartmental analyses offer an alternative method for describing drug pharmacokinetics without relying on a specific compartmental model. In this approach, the drug's pharmacokinetics are assumed to be linear, with the terminal phase log-linear. This assumption allows for simplified analysis and interpretation of the drug's behavior in the body.
One important characteristic of noncompartmental analyses is that drug exposure increases proportionally with increasing doses. This relationship...
One important characteristic of noncompartmental analyses is that drug exposure increases proportionally with increasing doses. This relationship...
01:13Overview of Microsoft Excel as a Data Analysis Tool
Microsoft Excel is a cornerstone tool for data analysis and statistical operations, offering a wide array of functionalities to manage, analyze, and visualize data efficiently. Recognized for its versatility, Excel facilitates the performance of basic to complex statistical operations, serving as an indispensable asset for analysts, researchers, and students alike. Excel's significance in data analysis emanates from its spreadsheet environment, where data can be organized in rows and columns,...