DDSolver Excel Add-in: What It Does and How to Use It

How-to basics · Updated November 18, 2026

DDSolver is a specialized Excel add-in for analyzing and comparing in-vitro drug dissolution profiles; it is not the same as Microsoft Excel’s Solver optimization add-in. Researchers use it to fit dissolution models and apply profile-comparison methods, but it does not replace sound experimental design or applicable regulatory guidance.

What DDSolver Is

DDSolver—also written as DD Solver—is a spreadsheet tool developed for pharmaceutical dissolution testing. It works within Microsoft Excel and provides analysis options for data collected as the amount or percentage of a drug released over time. Its purpose is to make common dissolution calculations and model fitting available through an Excel-based interface rather than requiring users to build every calculation themselves.

The add-in was described in a 2010 scientific paper on modeling and comparing drug dissolution profiles. It has been distributed as a free tool, although where it can currently be obtained, which file version is available, and what systems that version supports can depend on its source. Confirm those details with the software’s official or author-associated documentation before installing it. A search result or an old copy on a download site is not proof that a file is current or safe.

The name can be confusing because “Solver” is also the name of an Excel add-in used to optimize a formula by changing selected cells. DDSolver addresses a different subject: dissolution data. It is most relevant to pharmaceutical scientists, formulation researchers, and students working with dissolution testing—not to ordinary spreadsheet optimization.

How It Differs from Excel Solver

Excel Solver is a general-purpose optimization tool. A user defines an objective cell, changing cells, and any constraints, then asks Solver to find values that meet the objective. For example, it might find a production mix that maximizes a calculated profit subject to capacity limits.

DDSolver is tailored to dissolution-profile analysis. Rather than setting up a general optimization problem from scratch, a user selects from dissolution-related analyses and supplies the relevant data. Depending on the DDSolver version, its capabilities include fitting mathematical models to release-versus-time data and comparing profiles using established methods. It is not an alternative name for Solver, and installing Microsoft’s Solver add-in will not install DDSolver.

Both tools may involve calculations that fit parameters, but that similarity does not make them interchangeable. If the task is to optimize a business or engineering model, Excel Solver may be appropriate. If the task is to analyze pharmaceutical dissolution profiles, look specifically for DDSolver or another validated dissolution-analysis tool.

Analyses and Models It Can Support

Dissolution data can be examined in more than one way. Model-dependent analysis fits an equation to observed release over time. Commonly used dissolution models include zero-order and first-order models, Higuchi, Hixson–Crowell, and Weibull models. These represent different mathematical patterns; a convenient fit does not, by itself, prove that a particular physical mechanism is occurring.

Model-independent approaches compare profiles without requiring the same kind of equation fit. DDSolver has been used for measures such as dissolution efficiency and mean dissolution time, as well as the difference factor f1 and similarity factor f2. Those measures answer different questions: a model fit describes how well a selected equation represents the data, while a profile-comparison statistic summarizes aspects of the difference between two profiles.

Some versions and descriptions of DDSolver also cover resampling or bootstrap-based analysis. Because menus and available methods can vary by release, check the documentation accompanying the specific add-in rather than assuming that every feature mentioned in a paper or online guide appears in your copy. In all cases, the software calculates according to supplied data and settings; it cannot determine whether the study design or method is scientifically suitable.

A Typical DDSolver Workflow

A useful workflow starts before opening the add-in. Organize the measurements, confirm units and sampling times, and decide what analysis is justified. Then use the relevant DDSolver command or worksheet interface to select the data and analysis options. The exact labels and sequence depend on the installed version, so follow its own manual for the final menu steps.

  1. Prepare the profiles. Keep the reference and test formulations clearly identified, and preserve the original measurements in a separate worksheet or file.
  2. Check the inputs. Verify time points, units, replicate structure, and any correction for sample withdrawal or replacement required by the test method.
  3. Select the analysis. Choose a model, profile-comparison method, or other calculation that matches the scientific question and applicable guidance.
  4. Review the output. Inspect calculated values, fit information, warnings, and plots where provided. Do not rely on a single summary number without checking the underlying profiles.
  5. Record the method. Save the workbook and document the add-in version, settings, data source, and any processing performed.

For example, a researcher comparing a test tablet with a reference tablet might first plot both mean percentage-dissolved profiles against time. If the study and relevant guidance permit, the researcher could then calculate f2. The calculation is only meaningful when its assumptions and data requirements are met; selecting “calculate” does not establish that those requirements were satisfied.

Preparing Data and Interpreting Results

Clean input matters more than a polished output sheet. Use consistent time units and dissolution units, distinguish individual vessel results from averages, and label formulations unambiguously. Check for blank cells, text stored where numbers are expected, duplicated time points, and values entered as fractions in one column but percentages in another. Keep a copy of raw data unchanged so any correction or transformation can be traced.

In many conventional applications, an f2 value from 50 to 100 is treated as indicating similarity, but this is not a universal pass rule. The applicable regulatory guidance and study context set the conditions for using f2, including expectations around sampling times, the number of time points, variability, and the profiles being compared. If those conditions are not met, reporting the number without qualification can be misleading.

For model fitting, compare more than a visual match or one goodness-of-fit statistic. Look at residual patterns, parameter estimates, plausibility, and whether the model is appropriate for the formulation and purpose. A model may fit the measured points reasonably well while extrapolating poorly outside the observed time range. DDSolver helps perform calculations; interpretation remains the analyst’s responsibility.

Installing It and Checking Compatibility

DDSolver is a traditional Excel add-in, not a feature built into every Microsoft 365 installation. Use the desktop version of Excel and obtain the add-in only from a source you trust. Check the download’s documentation for the file type, supported Excel versions, operating system, and any macro requirements. Older add-ins may not behave the same way in current Microsoft 365, and a Windows-specific add-in may not work on a Mac.

In Excel for Microsoft 365 on Windows, a common route for loading an Excel add-in file is File > Options > Add-ins. At the bottom of the Add-ins page, select Excel Add-ins in the Manage box and choose Go. If DDSolver is listed, select its checkbox. If it is not listed, use Browse to locate the supplied add-in file, then follow the accompanying instructions. The exact process can differ by file type and release.

On a Mac, Excel add-ins are managed from Tools > Excel Add-ins in versions that provide that menu. Check the DDSolver documentation for Mac compatibility before trying to load it. Excel for the web does not run traditional desktop Excel add-ins in the same way, so do not assume that a DDSolver file enabled on Windows will be available in a browser.

If the add-in requires macros, do not respond by enabling all macros globally. Use a trusted, verified copy and follow your organization’s security policy. If Excel blocks the file or displays a security warning, investigate the source and file details instead of bypassing the warning blindly.

Common Problems and Limitations

A frequent problem is loading the wrong file or confusing an add-in with a workbook template. Check the supplied instructions and file extension, and make sure you are using the desktop Excel application. If DDSolver does not appear after loading, close and reopen Excel, revisit the Add-ins page, and confirm that its checkbox remains selected. A failure may also reflect compatibility, permissions, or macro-security settings rather than an error in the dissolution data.

Another common issue is inconsistent data layout. If a selection includes headings, blank rows, or unrelated columns, the add-in may misread the intended inputs or return an error. Use clearly labeled, contiguous data where the version’s instructions require it. Do not alter the workbook’s structure or rename special sheets unless the manual says that is supported.

DDSolver is not a substitute for validated software in a regulated workflow. Before relying on it for a quality decision or submission, establish that the specific version, calculations, and process are appropriate for the intended use. Keep audit-ready records where required, independently verify important calculations, and consult the relevant quality, regulatory, or statistical specialists. A free tool can still require careful qualification and control.

Cost and Alternatives

DDSolver has been described as a free add-in, but that does not guarantee that every copy currently offered online is official, supported, or compatible with a particular Excel version. Check the source’s terms and documentation, and avoid paying an unfamiliar site simply for access to an old file without confirming its origin. The time needed to verify compatibility and validate outputs is also part of the practical cost of using a legacy tool.

Alternatives include performing appropriate calculations in a controlled spreadsheet, using statistical or dissolution software designed for the work, or using a validated system already approved by a laboratory. A custom workbook can be transparent, but it needs careful review and testing; it is not automatically safer because its formulas are visible. Excel Solver may help with a separate optimization problem, but it does not provide DDSolver’s dissolution-specific workflow. Choose based on the analysis required, traceability, compatibility, validation expectations, and available technical support.

Frequently Asked Questions

Is DDSolver included with Excel?
No. DDSolver is a separate add-in. Microsoft Excel’s built-in or downloadable Solver add-in is a different tool for general optimization.

Can I use DDSolver in Excel for Microsoft 365?
Possibly, depending on the DDSolver release and its compatibility requirements. Check the version documentation and test it in a controlled copy of a workbook before relying on results. A traditional desktop add-in should not be assumed to work in Excel for the web.

Is DDSolver free?
It has been distributed as a free tool, but current availability and terms depend on the source. Verify the file’s origin and any license or usage conditions before downloading or using it.

Does DDSolver tell me whether two dissolution profiles are equivalent?
It can calculate comparison measures such as f2, but the number alone does not establish equivalence. The method must be appropriate, its requirements must be met, and the result must be interpreted under the relevant scientific and regulatory guidance.

What should I do if DDSolver will not load?
Confirm that you have a compatible desktop Excel version, the correct add-in file, and the installation steps for that release. Check Excel’s add-in list and security notices, and ask your organization’s IT team before changing macro or trust settings.

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.