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.Ĭopyright 2010 Elsevier Ireland Ltd. 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 results showed that the parameters estimated with PKSolver were satisfactory.
#Add in data analysis excel software#
To evaluate the program, a detailed comparison of modeling PK data using PKSolver and professional PK/PD software package WinNonlin and Scientist was performed. On the Data tab, in the Analysis group, you can now click on Data Analysis. Select Analysis ToolPak and click on the Go button. Analyze Data will provide answers with visuals such as tables, charts or PivotTables that can then be inserted into the workbook. Click the File tab, click Options, and then click the Add-Ins category. If you're interested in more specific information, you can enter a question in the query box at the top of the pane, and press Enter. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane. In addition, twenty frequently used pharmacokinetic functions were encoded as a macro and can be directly accessed in an Excel spreadsheet. Simply select a cell in a data range > select the Analyze Data button on the Home tab. 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.
#Add in data analysis excel install#
To install the Data Analysis Toolpak add-in: Click the File tab and then select ‘Options’. This add-in enables you to quickly create the histogram by taking the data and data range (bins) as inputs. The program provides a range of modules for PK and PD analysis including noncompartmental analysis (NCA), compartmental analysis (CA), and pharmacodynamic modeling. To create a histogram using Data Analysis tool pack, you first need to install the Analysis Toolpak add-in. 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.