PKSolver: An add-in program for pharmacokinetic and pharmacodynamic data analysis in Microsoft Excel
PKSolver: An add-in program for pharmacokinetic and pharmacodynamic data analysis in Microsoft Excel
复制标题
DOI：
10.1016/j.cmpb.2010.01.007
复制
发表时间：
2010-09-01
影响因子：
6.1
通讯作者：
Xie, Shaofei
中科院分区：
文献类型：
--
作者：
Zhang, Yong;Huo, Meirong;Xie, Shaofei
本研究提出了PKSolver，一个免费的菜单驱动的插件程序，用于解决药代动力学（PK）和药效学（PD）数据分析的基本问题，用Visual Basic for Applications （VBA）编写。该程序为PK和PD分析提供了一系列模块，包括非区室分析（NCA），区室分析（CA）和药效学建模。在经典单室模型的基础上，开发了两个特殊的内置模块，即多吸收位点（MAS）和肠肝循环（EHC），用于拟合双峰浓度-时间曲线。此外，将20个常用的药代动力学函数编码为宏，可在Excel电子表格中直接访问。为了评估该程序，使用PKSolver和专业PK/PD软件包WinNonlin和Scientist对PK数据建模进行了详细的比较。结果表明，用PKSolver估计的参数是令人满意的。总之，PKSolver简化了PK和PD数据分析过程，其输出可以在Microsoft Word中以集成报告的形式生成。该程序为药代动力学研究人员提供了一个快速和易于使用的工具，用于常规和基本的PK和PD数据分析，具有更友好的用户界面。2010爱思唯尔爱尔兰有限公司版权所有。
This study presents PKSolver, a freely available menu-driven add-in program for Microsoft Excel written in Visual Basic for Applications (VBA), for solving basic problems in pharmacokinetic (PK) and pharmacodynamic (PD) data analysis. The program provides a range of modules for PK and PD analysis including noncompartmental analysis (NCA), compartmental analysis (CA), and pharmacodynamic modeling. Two special built-in modules, multiple absorption sites (MAS) and enterohepatic circulation (EHC), were developed for fitting the double-peak concentration-time profile based on the classical one-compartment model. In addition, twenty frequently used pharmacokinetic functions were encoded as a macro and can be directly accessed in an Excel spreadsheet. To evaluate the program, a detailed comparison of modeling PK data using PKSolver and professional PK/PD software package WinNonlin and Scientist was performed. The results showed that the parameters estimated with PKSolver were satisfactory. In conclusion, the PKSolver simplified the PK and PD data analysis process and its output could be generated in Microsoft Word in the form of an integrated report. The program provides pharmacokinetic researchers with a fast and easy-to-use tool for routine and basic PK and PD data analysis with a more user-friendly interface. (C) 2010 Elsevier Ireland Ltd. All rights reserved.