MicrobialEnumerationTAMCTYMCQualityChecker
Microbial Enumeration (TAMC/TYMC)
Microbial Enumeration (TAMC/TYMC) Quality Checker — Control of Microbiological Quality ℹ️ Utility checks compliance of microbiological parameters with USP <61> / Ph. Eur. 2.6.12 requirements: • TAMC (Total Aerobic Microbial Count): ≤ specified limit (e.g., 10², 10³ CFU/g) • TYMC (Total Yeast and Mold Count): ≤ specified limit (e.g., 10² CFU/g) ⚠️ CRITICAL: Exceeding limits indicates insufficient preservative efficacy or hygiene breach in manufacturing! Product with exceeded limits is considered microbiologically contaminated. Usage: MicrobialEnumerationTAMCTYMCQualityChecker.exe → demo mode (console output) MicrobialEnumerationTAMCTYMCQualityChecker.exe input.csv output.json → evaluate your data Input format: BatchNumber,TAMC_CFU,TYMC_CFU,TAMC_Limit,TYMC_Limit Example: MICRO-NON-2026-001,50,10,100,100 — WHY IS THIS NEEDED? Control of microbiological quality of non-sterile dosage forms is mandatory for patient safety. • TAMC assesses total bacterial load. • TYMC assesses fungal contamination (yeasts and molds). • Limits depend on route of administration (oral, topical, rectal) and product composition. • USP <61> and Ph. Eur. 2.6.12 regulate plating methods (plate count, membrane filtration) and incubation. • Automation eliminates manual comparison errors with acceptance criteria tables. ⚠️ CRITICAL: • Results are expressed in CFU/g or CFU/mL. • If no growth, result is recorded as <10 or <1 (depending on dilution). • If growth exceeds limits, test for specified microorganisms (USP <62>) is performed. • Method suitability test (validation) is required before batch analysis. Key features: • Verification of TAMC and TYMC compliance with specified limits. • Support for different product categories (different limits). • Generation of PASS/FAIL status for QC reports. Critical parameters: • TAMC: <= Limit (e.g., 100, 1000, 10000 CFU/g) • TYMC: <= Limit (e.g., 100, 1000 CFU/g) 💡 Usage tips: 1. Ensure plates were incubated for correct time (TAMC: 3-5 days, TYMC: 5-7 days). 2. Use media that neutralizes antimicrobial activity of the product (if applicable). 3. For products with low expected bioburden, use membrane filtration method. 4. Regularly perform method validation (Growth Promotion Test). 5. Consider re-testing for borderline results. ⚠️ Note: This test is quantitative. Qualitative absence of specific pathogens (E. coli, Salmonella, etc.) is checked by a separate test (Tests for Specified Microorganisms, USP <62>).
input.csv
BatchNumber,TAMC_CFU,TYMC_CFU,TAMC_Limit,TYMC_Limit MICRO-NON-2026-001,50,10,100,100 MICRO-NON-2026-002,120,40,100,100 MICRO-NON-2026-003,800,90,1000,100
URS & FS — Microbial Enumeration (TAMC/TYMC)
This document describes the user requirements and functional specification for MicrobialEnumerationTAMCTYMCQualityChecker. 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
| ID | Requirement | Criticality | Acceptance criterion |
|---|---|---|---|
| URS-001 | The utility shall accept input.csv with approved columns: BatchNumber, TAMC_CFU, TYMC_CFU, TAMC_Limit, TYMC_Limit. | High | The CSV file is processed without manual header editing. |
| URS-002 | The utility shall perform deterministic evaluation for “Microbial Enumeration (TAMC/TYMC)” without machine learning. | High | The same input data produce the same JSON result. |
| URS-003 | The utility shall validate mandatory fields, numeric formats, flags, ranges and domain plausibility. | High | Schema and conversion errors are explicitly reported. |
| URS-004 | The utility shall generate output.json with PASS / WARNING / FAIL statuses, source values, warnings and failures. | High | The JSON result is suitable for review, deviation investigation and integration. |
| URS-005 | The documentation shall support IQ/OQ/PQ or CSV/CSA verification. | Medium | URS/FS, CSV/JSON contract and test scenarios are supplied with the utility. |
input.csv contract
| # | Field | Sample | Purpose |
|---|---|---|---|
| 1 | BatchNumber | MICRO-NON-2026-001 | Input parameter for deterministic QC evaluation. |
| 2 | TAMC_CFU | 50 | Input parameter for deterministic QC evaluation. |
| 3 | TYMC_CFU | 10 | Input parameter for deterministic QC evaluation. |
| 4 | TAMC_Limit | 100 | Input parameter for deterministic QC evaluation. |
| 5 | TYMC_Limit | 100 | Input parameter for deterministic QC evaluation. |
FS — Functional Specification
| ID | Function | Implementation |
|---|---|---|
| FS-001 | CSV import | Read input.csv; validate header, column count and encoding. |
| FS-002 | Schema validation | Check required fields and permitted input values. |
| FS-003 | Rule engine | Apply domain rules, limits and system suitability/specification checks described in the source utility description. |
| FS-004 | Status aggregation | Produce final status: FAIL for critical failure, WARNING for non-critical deviation, PASS for conformance. |
| FS-005 | JSON export | Write 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
FAILor 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
Biopharmaceuticals Extended QC Suite
Extended QC utility coverage for mAbs, biosimilars, proteins, insulins, vaccines, mRNA/LNP, HCP, sterile release, microbiology, water, cleanroom and stability workflows.
OpenDental & 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.
OpenInfectious Diseases QC Suite
QC utility package for infectious diseases: antibacterial, antiviral, antifungal and antiparasitic products, microbiology, sterility, endotoxins, viral safety and vaccine release checks.
OpenLabEx QC Suite
LabEx package for laboratory QC methods: chromatography, spectroscopy, microbiology, sterility, endotoxins, particles, dissolution, water, cleanrooms and sample preparation.
OpenProctology QC Suite
QC package for proctology: local anaesthetics, corticosteroids, anti-inflammatory, anti-infective and supporting medicines for rectal dosage forms.
Open