Simply enter your dissolution data and get accurate F1 and F2 values INSTANTLY.
Try It Free — Sign Up with Your Email
Instant Access. No software installation required
Who Is This For?
This tool is built for:
✓ Pharmaceutical scientists comparing pre- and post-change dissolution profiles
✓ QC and QA analysts performing dissolution profile comparisons for regulatory submissions
✓ Anyone who needs accurate, audit-ready f1 and f2 results without building formulas from scratch
If you’ve ever spent 20 minutes double-checking a formula in a plain Excel sheet — or worried you had the wrong parentheses in your f2 calculation — this tool was built for you.
Everything is handled inside Excel — no internet connection required, no data uploaded anywhere, no new software to learn.
How to Use It
Step 1: Enter your time points
Input the nominal time points for your dissolution study (e.g., 5, 10, 15, 30, 45, 60 min).Step 2: Enter your raw replicate values
Input the individual dissolution values for each unit at each time point — up to 12 replicates per time point. The calculator computes the means at full precision automatically.Step 3: Review the automated checks
The calculator flags any time points that violate the 85% rule or exceed CV thresholds before the calculation runs.Step 4: Read your f1 and f2 results
The results summary shows your calculated f1 and f2 values with clear Pass/Fail indicators against acceptance criteria.Regulatory Basis
The f1 and f2 calculations in this tool follow the methodology described in:✓ FDA Guidance for Industry: Dissolution Testing of Immediate Release Solid Oral Dosage Forms (1997)✓ EMA Guideline on the Investigation of Bioequivalence (CPMP/EWP/QWP/1401/98 Rev. 1)Acceptance criteria applied: f1 ≤ 15 and f2 ≥ 50.Want to understand the full calculation methodology?Read our step-by-step article: “How to Compare Dissolution Profiles Using f1 and f2” → [link]
Try It Before You Buy
Not ready to commit? Start with the free trial.
Sign up with your email and we’ll send you a free trial version of the calculator. The trial gives you limited access so you can explore the tool, test it with your own data, and see how it fits your workflow — before making any decision.
Get Your Free Trial
Sign up below and we’ll send the trial version directly to your inbox.
Frequently Asked Questions
FULL VERSION
Full-feature version
Lifetime access
Ready for implementation
Includes validation documentation
$299
-
The calculator works with Excel 2016 and later, including Microsoft 365. It is not compatible with Google Sheets.
-
The calculator supports up to 12 time points and up to 12 replicates per time point, in line with FDA and EMA guidance.
-
The free trial gives you limited 24-hour access to explore the tool and test it with your data. The full version includes lifetime access, complete functionality, and access to validation documentation of the tool.
-
Yes. The calculator runs entirely within Excel on your own computer. No data is uploaded, shared, or stored externally.
Ready to stop second-guessing your f2 formula?
Try the calculator free today.
f1 and f2 Values Calculator for Dissolution
Quickly determine values for f1 difference and f2 similarity factors used in dissolution testing to compare a reference batch with a test batch.
Eliminate fear of complex formulas and report results with confidence.
Easy to follow step-by-step instructions
100% transparency on calculations for reviews and audits
Formulas locked for editing to maintain data integrity
Full refund within 30 days of purchase, no questions asked, if the template does not meet your satisfaction
Excel in Science — Validated Excel Tools for Pharmaceutical Analysis
f1 and f2 Values Calculator for Dissolution
Price: $299.00
(Full refund within 30 days of purchase, no questions asked, if the template does not meet your satisfaction)
Determine values for f1 difference and f2 similarity factors used in dissolution testing. Check out this article on how it works.
FREE TRIAL
Limited-feature preview
24-hour access
Evaluation use only
Validation documentation not included
Free
f1 and f2 Values Calculator for Dissolution
Quickly determine values for f1 difference and f2 similarity factors used in dissolution testing to compare a reference batch with a test batch.
Eliminate fear of complex formulas and report results with confidence.
Easy to follow step-by-step instructions
100% transparency on calculations for reviews and audits
Formulas locked for editing to maintain data integrity
Full refund within 30 days of purchase, no questions asked, if the template does not meet your satisfaction
The Problem with Manual f1/f2 Calculations
Building f1 and f2 in a plain Excel sheet looks straightforward. In practice, there are at least four ways to get the wrong answer — silently.
• Misplaced parentheses that apply the −0.5 exponent to the wrong expression
• Forgetting to exclude time points where Rt > 85% (the 85% rule)
• Rounding means before using them in the calculation
• No CV check, so non-qualifying data gets included without warning
The troubling part: Excel produces a number either way. You won’t always know when something is wrong.
What the Calculator Does
Sign up for a free trial
.