PKSolver in Excel: What It Does and How to Use It Safely

How-to basics · Updated November 21, 2026

Yes. PKSolver is an Excel add-in for pharmacokinetic and pharmacodynamic data analysis; it is separate from Microsoft Excel’s built-in Solver tool. It can perform analyses such as noncompartmental analysis and compartmental modeling, but it is an older add-in, so check compatibility and validate results before relying on it.

What PKSolver is and where it came from

PKSolver was developed as a menu-driven program that runs within Microsoft Excel. Its purpose is to help researchers analyze pharmacokinetic data without having to build every calculation and model from scratch in worksheet cells. The software was described in a 2010 paper by Zhang and colleagues, published in Computer Methods and Programs in Biomedicine. That paper and its associated materials are useful starting points for understanding the program’s intended features and original software environment.

PKSolver is not a feature that comes preinstalled in Microsoft 365, and the name does not mean that Excel’s standard Solver has been specially configured for drug data. It is a separate add-in. Depending on the version and distribution, it may appear as an added ribbon or menu command after installation. The interface and installation steps can differ from those shown in older instructions.

In pharmacokinetics, researchers study how drug concentration changes over time, often after a dose. The resulting parameters can help describe exposure and the rate at which concentrations rise or fall. PKSolver is an analysis aid for those tasks, not a source of experimental data or a substitute for scientific judgment.

What analyses it supports

PKSolver is associated with several common types of pharmacokinetic analysis. The options available depend on the installed version and the data supplied, but the main categories include:

  • Noncompartmental analysis (NCA): estimates exposure and related parameters from observed concentration-time data without requiring the user to specify a compartment model first.
  • Compartmental analysis: fits data to a selected mathematical model, such as a one- or multi-compartment description, to estimate model parameters.
  • Statistical moment analysis: uses moments of the concentration-time profile to summarize measures such as mean residence time.
  • Bioavailability and bioequivalence analysis: supports analysis of exposure measures in suitable study designs. The study design and statistical method still need to be chosen and checked appropriately.

For example, an NCA may summarize a subject’s concentration measurements after a dose using measures such as maximum observed concentration (Cmax), time of maximum observed concentration (Tmax), and area under the concentration-time curve (AUC). A compartmental analysis instead estimates parameters under a stated model. These methods answer related but different questions; a model fit should not be treated as interchangeable with an NCA summary.

Prepare the data before opening the add-in

Good input data are essential. A tidy worksheet is easier to review and less likely to be misread than a table with merged cells, decorative headings, or several kinds of measurements mixed together. Keep an unchanged copy of the source data, then prepare a working copy with clear column names.

  • Use a separate row for each observation, with columns identifying the subject or sample, time, concentration, and any relevant treatment or dose group.
  • Record the time and concentration units in the worksheet or accompanying notes. Do not combine hours and minutes, or different concentration units, without a deliberate conversion.
  • Make the dosing context clear: dose amount, route, and sampling schedule can affect how results should be interpreted.
  • Keep missing values distinct from measured zeroes. A blank, a zero, and a concentration below the assay’s quantification limit do not necessarily mean the same thing.
  • Check that each subject’s observations are associated with the right dose or treatment and are in a sensible time sequence.

For a simple illustration, imagine a study with a concentration value for each participant at several scheduled times after a dose. Keep participant identifiers on every row rather than relying on the order of rows to indicate which observations belong together. If the data include a pre-dose sample, label it explicitly and follow the analysis plan for handling it. Do not silently remove unusual values; investigate them and document any decision to exclude or retain them.

A practical workflow in Excel

Because PKSolver is a separate add-in and versions may differ, use the instructions supplied with the exact package you have rather than assuming every version has identical buttons. A careful workflow in Microsoft Excel for Microsoft 365 on Windows looks like this:

  1. Confirm the source and version. Obtain the add-in from a reliable source, and read the included documentation or the original publication. Avoid installing an unexplained file from a download page that does not identify its origin.
  2. Save a working copy. Keep the original dataset unchanged. Save your analysis workbook under a new name before importing or transforming data.
  3. Install or enable the add-in if appropriate. For a standard Excel add-in, the Windows path is File > Options > Add-ins. At the bottom, choose Excel Add-ins beside Manage, select Go, and use Browse if you need to locate the add-in file. PKSolver packages and older Excel versions may require instructions specific to that release.
  4. Check that it loads. Look for the PKSolver commands described in the package documentation. If Excel blocks the file or reports a compatibility issue, do not bypass security warnings without first verifying the file and its source.
  5. Select the analysis that matches the question. Choose the appropriate analysis type and identify the input data according to the installed version’s instructions. Confirm subject grouping, dose information, time units, and concentration units before running it.
  6. Review the output. Check warnings, plots or tables provided by the software, parameter units, and whether the chosen analysis is appropriate for the design. Compare a few records with independently calculated or otherwise verified results when feasible.

On Mac, Excel has a different settings interface, and older Windows-oriented add-ins may not work as expected. Excel for the web does not run traditional desktop VBA add-ins. If PKSolver depends on an older Windows Excel environment, use a compatible desktop setup documented for that release rather than assuming the same installation path applies on Mac or in a browser.

How to interpret the results

PK parameters are summaries or model estimates, not self-explanatory facts about a treatment. AUC describes integrated exposure over a stated interval; it is not meaningful to compare two AUC values without checking that the interval, units, dose context, and analysis choices are comparable. Cmax is the highest measured concentration in an observed dataset, while Tmax is the time at which that measured maximum occurs. Sampling schedules can therefore affect both values.

A terminal half-life estimate depends on identifying an appropriate terminal portion of the concentration-time curve. If too few late measurements are available, or the selected points do not represent a clear terminal decline, the estimate can be unstable. Likewise, compartmental estimates depend on the selected model and the quality and range of the data. A numerical result can be produced even when the assumptions are weak, so inspect the data and fit rather than accepting every output automatically.

Report the analysis method and relevant assumptions alongside results. Include units, the time interval used for exposure measures, how below-quantification observations were handled, and any exclusions. These details let another analyst understand what the numbers mean and help prevent a spreadsheet from appearing more definitive than the study supports.

PKSolver versus Excel Solver

Microsoft Solver is a general-purpose optimization add-in. It changes specified decision-variable cells to optimize an objective cell, subject to optional constraints. Researchers can use that general mechanism to fit a model if they construct the equations, objective function, parameter bounds, and diagnostic checks themselves.

PKSolver, by contrast, is designed specifically for pharmacokinetic and pharmacodynamic analyses and supplies purpose-built workflows. Having both names include the word Solver can cause confusion, but installing the Microsoft Solver add-in does not install PKSolver. Nor does using PKSolver make a model fit automatically valid: users still need to select an appropriate method, assess assumptions, and interpret the output.

Compatibility, limitations, and common problems

PKSolver originated in an earlier Excel era. Its presence in an old paper or tutorial does not guarantee that a particular package will install cleanly in every current Microsoft 365 setup. Check the documented Excel version, operating system, and file type. Older add-ins can also be affected by organizational security policies, blocked downloads, or restrictions on macros and add-ins.

Common problems include the add-in failing to load, commands not appearing, data being grouped incorrectly, and output values having unexpected units. Start with the documentation and verify the input range and column meanings. If a result is implausible, check the raw data, dose and time units, subject identifiers, analysis settings, and any warnings before rerunning the calculation. Do not “fix” an unexpected value by changing data until the reason is understood.

For a reproducible analysis, record the PKSolver version, Excel version, analysis settings, and any manual data preparation. Preserve the input data and output workbook. If the add-in is incompatible with your current computer, use a documented compatible environment or a different validated tool rather than downloading unofficial replacement files.

Safety and when to use another tool

Pharmacokinetic analysis can inform research and, in some settings, decisions with clinical implications. PKSolver is a calculation tool, not a clinical decision-maker, and this overview is not medical advice. Do not use a spreadsheet output alone to choose or alter a person’s medication dose. Clinical use requires appropriate expertise, validated methods, and the relevant study or patient context.

For regulated work or analyses requiring a formal audit trail, determine whether the software, workflow, and environment meet the project’s validation and documentation requirements. Alternatives include specialist commercial pharmacokinetic software and programming workflows using packages such as PKNCA in R. Each option has its own setup, learning curve, and validation considerations; a newer tool is not automatically suitable simply because it is newer.

Frequently Asked Questions

Is PKSolver included with Excel?
No. PKSolver is a separate add-in. Excel’s built-in Solver is a different, general-purpose optimization tool.

Can I use PKSolver in Excel for Microsoft 365?
Possibly, but compatibility depends on the specific PKSolver package, Excel build, and Windows environment. Check its documentation and test it on a copy of a workbook before using it for an important analysis.

Does PKSolver work in Excel for the web?
Traditional desktop add-ins that rely on VBA do not run in Excel for the web. Use a supported desktop environment or choose a compatible alternative.

Does PKSolver calculate AUC and half-life?
PKSolver supports pharmacokinetic analyses that can produce parameters such as AUC and half-life, depending on the selected analysis and data. The result depends on the method, input quality, and assumptions.

Is PKSolver suitable for deciding a medication dose?
Not on its own. A spreadsheet result is not a substitute for clinical judgment, validated decision processes, or advice from a qualified healthcare professional.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.