DissolutionApparatus12QualityChecker

Dissolution Apparatus 1 & 2

LabEx laboratory QC CSV→JSON URS & FS chromatography solid dosage forms spectroscopy utilities / cleanroom
Open selection
Dissolution Apparatus 1 & 2 Quality Checker — Dissolution Testing (Apparatus 1 & 2)

ℹ️  Utility assesses dissolution profile of solid dosage forms according to USP <711> using Apparatus 1 (Basket) and Apparatus 2 (Paddle):
     • Mean Dissolution ≥ Q (specified limit, e.g., 80%)
     • Individual Values: 
       - No unit less than Q - 15%
       - Not more than 2 units less than Q - 5% (Stage 2 criterion)
     • Control of physical parameters: Temperature (37.0 ± 0.5°C), Rotation Speed (±4%)
     • Support for acceptance criteria Stage 1 (n=6) and Stage 2 (n=12)

⚠️  CRITICAL: Presence of even one tablet/capsule with dissolution < Q-15% leads to immediate batch rejection!
     Temperature deviation > 0.5°C invalidates the test due to effect on dissolution kinetics.

Usage:
  DissolutionApparatus12QualityChecker.exe                            → demo mode (console output)
  DissolutionApparatus12QualityChecker.exe input.csv output.json      → evaluate your data

Input format:
BatchNumber,ProductName,ApparatusType,RPM,Temperature_C,Volume_ml,Q_Value,MeanDissolvedPercent,MinIndividualPercent,MaxIndividualPercent,UnitsBelowQ_Minus_5,UnitsBelowQ_Minus_15

Example:
  DISS-2026-TAB-001,Ibuprofen 400mg,2,50.0,37.1,900.0,80.0,88.5,82.0,94.0,0,0

— WHY IS THIS NEEDED?
Dissolution test is a key quality indicator for solid oral dosage forms.
It simulates drug release in the gastrointestinal tract and correlates with bioavailability.
Non-compliance of dissolution profile may indicate manufacturing process issues (compression, granulation) or raw material problems.

⚠️  CRITICAL:
• Q-value: Specified in monograph (e.g., Q=80% at 45 minutes).
• Stage 1 (S1): 6 units tested. Pass: Mean ≥ Q and each unit ≥ Q-5%.
• Stage 2 (S2): If S1 fails, 6 more units tested (total 12). Pass: Mean ≥ Q, not more than 2 units < Q-5%, none < Q-15%.
• Medium Degassing: Solvent must be degassed to prevent bubble formation on tablet surfaces/paddles.
• Calibration: Apparatus must undergo mechanical calibration (centering, verticality, speed) regularly.

Key features:
• Automatic check of USP <711> criteria (S1/S2)
• Control of individual extremes (Min/Max)
• Test condition verification (Temperature, RPM)
• Generation of reports for QC departments and LIMS LabWare
• Compliance with GMP and Pharmacopoeia requirements

Critical parameters:
• Mean Dissolution: ≥ Q%
• Units < Q-5%: ≤ 2
• Units < Q-15%: 0
• Temperature: 37.0 ± 0.5°C

💡 Usage tips:
1. Sampling: Automated sampling systems are preferred to minimize medium disturbance.
2. Filtration: First few mL of filtrate are usually discarded to saturate the filter.
3. Analytics: Analysis method (HPLC/UV) must be validated for specificity and linearity.
4. Interpretation: If batch fails S2, investigation of causes is required (tablet defects, analytical error).
5. Apparatus 1 vs 2: Apparatus 1 (Basket) is often used for capsules or floating drugs. Apparatus 2 (Paddle) is standard for tablets.

⚠️ Note: Dissolution test is a surrogate marker for bioequivalence. For narrow therapeutic index drugs, dissolution uniformity requirements are particularly strict.

input.csv

BatchNumber,ProductName,ApparatusType,RPM,Temperature_C,Volume_ml,Q_Value,MeanDissolvedPercent,MinIndividualPercent,MaxIndividualPercent,UnitsBelowQ_Minus_5,UnitsBelowQ_Minus_15
DISS-2026-TAB-001,Ibuprofen Tablets 400mg,2,50.0,37.1,900.0,80.0,88.5,82.0,94.0,0,0
DISS-2026-CAP-002,Omeprazole Capsules,1,100.0,36.8,500.0,75.0,72.0,65.0,78.0,2,0
DISS-2026-TAB-FAIL-003,Metformin XR,2,50.0,37.5,900.0,85.0,80.0,60.0,88.0,3,1

URS & FS — Dissolution Apparatus 1 & 2

This document describes the user requirements and functional specification for DissolutionApparatus12QualityChecker. The utility is intended for QC laboratory use as a rule-based check of data prepared from an instrument, LIMS, ELN, MES or an approved input.csv.

URS — User Requirements Specification

IDRequirementCriticalityAcceptance criterion
URS-001The utility shall accept input.csv with approved columns: BatchNumber, ProductName, ApparatusType, RPM, Temperature_C, Volume_ml, Q_Value, MeanDissolvedPercent, MinIndividualPercent, MaxIndividualPercent, UnitsBelowQ_Minus_5, UnitsBelowQ_Minus_15.HighThe CSV file is processed without manual header editing.
URS-002The utility shall perform deterministic evaluation for “Dissolution Apparatus 1 & 2” without machine learning.HighThe same input data produce the same JSON result.
URS-003The utility shall validate mandatory fields, numeric formats, flags, ranges and domain plausibility.HighSchema and conversion errors are explicitly reported.
URS-004The utility shall generate output.json with PASS / WARNING / FAIL statuses, source values, warnings and failures.HighThe JSON result is suitable for review, deviation investigation and integration.
URS-005The documentation shall support IQ/OQ/PQ or CSV/CSA verification.MediumURS/FS, CSV/JSON contract and test scenarios are supplied with the utility.

input.csv contract

#FieldSamplePurpose
1BatchNumberDISS-2026-TAB-001Input parameter for deterministic QC evaluation.
2ProductNameIbuprofen Tablets 400mgInput parameter for deterministic QC evaluation.
3ApparatusType2Input parameter for deterministic QC evaluation.
4RPM50.0Input parameter for deterministic QC evaluation.
5Temperature_C37.1Input parameter for deterministic QC evaluation.
6Volume_ml900.0Input parameter for deterministic QC evaluation.
7Q_Value80.0Input parameter for deterministic QC evaluation.
8MeanDissolvedPercent88.5Input parameter for deterministic QC evaluation.
9MinIndividualPercent82.0Input parameter for deterministic QC evaluation.
10MaxIndividualPercent94.0Input parameter for deterministic QC evaluation.
11UnitsBelowQ_Minus_50Input parameter for deterministic QC evaluation.
12UnitsBelowQ_Minus_150Input parameter for deterministic QC evaluation.

FS — Functional Specification

IDFunctionImplementation
FS-001CSV importRead input.csv; validate header, column count and encoding.
FS-002Schema validationCheck required fields and permitted input values.
FS-003Rule engineApply domain rules, limits and system suitability/specification checks described in the source utility description.
FS-004Status aggregationProduce final status: FAIL for critical failure, WARNING for non-critical deviation, PASS for conformance.
FS-005JSON exportWrite machine-readable output.json for LIMS/ELN/MES and QA/QC review.

OQ/PQ scenarios

  • OQ-001: a valid sample row shall be processed without schema error.
  • OQ-002: a missing mandatory column shall produce a schema error.
  • OQ-003: a non-numeric value in a numeric field shall produce a conversion error.
  • OQ-004: a critical parameter outside the limit shall produce FAIL or a critical finding.
  • PQ-001: user real batches shall be checked with retention of input.csv, output.json, utility version and checksum.

Included in packages

Dental & Dental Materials QC Suite

QC utility package for dental medicinal products, oral-care products and dental materials: anaesthetics, antiseptics, analgesic/anti-infective products, polymers/minerals, resins, bonding workflows, microbiology, stability and material QC.

Open

Gastroenterology QC Suite

QC package for gastroenterology: PPIs, antiemetics, prokinetics, IBD medicines, laxatives, enzymes and GI anti-infectives.

Open

LabEx QC Suite

LabEx package for laboratory QC methods: chromatography, spectroscopy, microbiology, sterility, endotoxins, particles, dissolution, water, cleanrooms and sample preparation.

Open

Radiology QC Suite

QC package for radiology and diagnostic imaging: radiopharmaceuticals, PET/SPECT, contrast media, iodinated and gadolinium products, plus particle, sterility and endotoxin checks.

Open

Rheumatology QC Suite

QC package for rheumatology: NSAIDs, glucocorticoids, methotrexate, biologics and supporting impurity/potency checks.

Open