Utility description: Mercury Speciation: Methyl vs Inorganic
Mercury Speciation: Methyl vs Inorganic — Analysis of Mercury Forms
ℹ️ Utility checks critical parameters of mercury speciation:
• Total Mercury: ≤100 ppb (example)
• Methylmercury: ≤50 ppb (example)
• Inorganic Mercury: ≤50 ppb (example)
• Mass Balance: Difference between sum of species and total Hg ≤15%
⚠️ CRITICAL: High percentage of methylmercury (>80-90%) is characteristic of marine products.
Exceeding total mercury limits or form imbalance indicates contamination or analytical error.
Usage:
Mercury_Speciation_Methyl_vs_Inorganic.exe → demo mode (console output)
Mercury_Speciation_Methyl_vs_Inorganic.exe input.csv output.json → evaluate your data
Input format:
BatchNumber,TotalMercuryPPB,InorganicMercuryPPB,MethylMercuryPPB
Example:
FISH-OIL-SPEC-001,80.0,10.0,70.0
— WHY IS THIS NEEDED?
Mercury speciation is necessary for accurate toxicological risk assessment.
• Methylmercury (MeHg) is a highly toxic organic form that easily crosses the blood-brain barrier.
• Inorganic Mercury (InorgHg) is less lipophilic but also nephrotoxic.
• In fish oil and seafood, up to 90-95% of total mercury may be methylmercury.
• Lumex RA-915M instruments allow determination of total mercury with high sensitivity. Speciation often requires chromatographic separation (LC-ICP-MS) or special kinetic/extraction methods.
• Control of form balance validates the accuracy of the speciation method.
⚠️ CRITICAL:
• Sum of individual forms (MeHg + InorgHg) must equal Total Mercury (within error margin).
• Methylmercury is a priority pollutant in food monitoring (Sanitary Rules).
• For pharmaceutical fish oil, it is important to control both forms, as purification processes may affect them differently.
Key features:
• Calculation of percentage ratio of mercury forms.
• Mass balance check of analytical data.
• Support for data from hybrid systems or external chromatographs.
Critical parameters:
• Total Mercury: <= 100 ppb
• Methylmercury: <= 50 ppb
• Inorganic Mercury: <= 50 ppb
• Mass Balance Error: <= 15%
💡 Usage tips:
1. Use certified standards of methylmercury and inorganic mercury for calibration.
2. When using RA-915M without chromatography, speciation may be performed by "before and after" selective extraction or photolysis.
3. Store samples at low temperature to prevent mercury methylation/demethylation during storage.
4. Account for matrix effects when analyzing complex biological samples.
5. Cross-check results with ICP-MS data if discrepancies occur.
⚠️ Note: Direct determination of mercury speciation by atomic absorption is difficult. Most often, total mercury is determined, and speciation is performed indirectly or using an HPLC attachment. This utility processes the results of such comprehensive analysis.
input.csv
BatchNumber,TotalHg_ppb,InorganicHg_ppb,MethylHg_ppb
FISH-OIL-SPEC-001,80.0,10.0,70.0
FISH-OIL-SPEC-002,95.0,15.0,80.0
FISH-OIL-FAIL-003,120.0,20.0,100.0
Utility description
Mercury Speciation: Methyl vs Inorganic — Analysis of Mercury Forms
ℹ️ Utility checks critical parameters of mercury speciation:
• Total Mercury: ≤100 ppb (example)
• Methylmercury: ≤50 ppb (example)
• Inorganic Mercury: ≤50 ppb (example)
• Mass Balance: Difference between sum of species and total Hg ≤15%
⚠️ CRITICAL: High percentage of methylmercury (>80-90%) is characteristic of marine products.
Exceeding total mercury limits or form imbalance indicates contamination or analytical error.
Usage:
Mercury_Speciation_Methyl_vs_Inorganic.exe → demo mode (console output)
Mercury_Speciation_Methyl_vs_Inorganic.exe input.csv output.json → evaluate your data
Input format:
BatchNumber,TotalMercuryPPB,InorganicMercuryPPB,MethylMercuryPPB
Example:
FISH-OIL-SPEC-001,80.0,10.0,70.0
— WHY IS THIS NEEDED?
Mercury speciation is necessary for accurate toxicological risk assessment.
• Methylmercury (MeHg) is a highly toxic organic form that easily crosses the blood-brain barrier.
• Inorganic Mercury (InorgHg) is less lipophilic but also nephrotoxic.
• In fish oil and seafood, up to 90-95% of total mercury may be methylmercury.
• Lumex RA-915M instruments allow determination of total mercury with high sensitivity. Speciation often requires chromatographic separation (LC-ICP-MS) or special kinetic/extraction methods.
• Control of form balance validates the accuracy of the speciation method.
⚠️ CRITICAL:
• Sum of individual forms (MeHg + InorgHg) must equal Total Mercury (within error margin).
• Methylmercury is a priority pollutant in food monitoring (Sanitary Rules).
• For pharmaceutical fish oil, it is important to control both forms, as purification processes may affect them differently.
Key features:
• Calculation of percentage ratio of mercury forms.
• Mass balance check of analytical data.
• Support for data from hybrid systems or external chromatographs.
Critical parameters:
• Total Mercury: <= 100 ppb
• Methylmercury: <= 50 ppb
• Inorganic Mercury: <= 50 ppb
• Mass Balance Error: <= 15%
💡 Usage tips:
1. Use certified standards of methylmercury and inorganic mercury for calibration.
2. When using RA-915M without chromatography, speciation may be performed by "before and after" selective extraction or photolysis.
3. Store samples at low temperature to prevent mercury methylation/demethylation during storage.
4. Account for matrix effects when analyzing complex biological samples.
5. Cross-check results with ICP-MS data if discrepancies occur.
⚠️ Note: Direct determination of mercury speciation by atomic absorption is difficult. Most often, total mercury is determined, and speciation is performed indirectly or using an HPLC attachment. This utility processes the results of such comprehensive analysis.
URS & FS — User Requirements and Functional Specification
This document describes the controlled interface, user requirements and functional behaviour of Mercury_Speciation_Methyl_vs_Inorganic. The utility is intended for automated verification of laboratory, pharmacopoeial, analytical or manufacturing QC parameters using input.csv and producing a structured output.json result.
Domain limits and critical parameters
Before production use, all limits must be verified against the approved specification, registration dossier, pharmacopoeial monograph, validated method and local SOPs.
- • Total Mercury: ≤100 ppb (example)
- • Methylmercury: ≤50 ppb (example)
- • Inorganic Mercury: ≤50 ppb (example)
- • Mass Balance: Difference between sum of species and total Hg ≤15%
- Exceeding total mercury limits or form imbalance indicates contamination or analytical error.
- • Methylmercury (MeHg) is a highly toxic organic form that easily crosses the blood-brain barrier.
- • Inorganic Mercury (InorgHg) is less lipophilic but also nephrotoxic.
- • In fish oil and seafood, up to 90-95% of total mercury may be methylmercury.
- • Lumex RA-915M instruments allow determination of total mercury with high sensitivity. Speciation often requires chromatographic separation (LC-ICP-MS) or special kinetic/extraction methods.
- • Control of form balance validates the accuracy of the speciation method.
- • Sum of individual forms (MeHg + InorgHg) must equal Total Mercury (within error margin).
- • Methylmercury is a priority pollutant in food monitoring (Sanitary Rules).
- • For pharmaceutical fish oil, it is important to control both forms, as purification processes may affect them differently.
- • Calculation of percentage ratio of mercury forms.
- • Mass balance check of analytical data.
- • Support for data from hybrid systems or external chromatographs.
URS — User Requirements Specification
| ID | Requirement | Criticality | Acceptance criterion |
| URS-001 | The utility shall accept an input.csv file with exact headers defined in the data contract. | High | The file is processed without manual header editing. |
| URS-002 | The utility shall perform deterministic evaluation for Mercury Speciation: Methyl vs Inorganic using input values, approved limits and domain rules. | High | Each row receives a PASS / WARNING / FAIL status. |
| URS-003 | The utility shall validate mandatory fields, data types, numeric ranges, units and domain plausibility. | High | Schema, format and conversion errors are explicitly reported. |
| URS-004 | The utility shall identify critical deviations for parameters stated in the method description and specification. | High | A critical deviation causes FAIL or a dedicated critical finding. |
| URS-005 | The utility shall generate output.json with machine-readable results, source values, warnings and failures. | High | JSON is suitable for LIMS/ELN/MES integration, QA/QC review and archival. |
| URS-006 | The result shall not depend on machine learning or undocumented heuristics. | Medium | All decisions are based on explicit rules, thresholds and input values. |
| URS-007 | The system shall preserve traceability between batch/sample, input data, applied rules and final status. | High | The output contains the batch/sample identifier and checked parameters. |
| URS-008 | The documentation shall support IQ/OQ/PQ preparation and inspection discussion. | Medium | URS, FS, CSV/JSON contract and test scenarios are supplied with the utility. |
| URS-009 | The utility shall support batch processing of multiple input.csv rows. | Medium | Each row is evaluated independently; errors in one row do not mask errors in others. |
| URS-010 | The utility shall support a simple operating model: demo mode and execution with input/output files. | Medium | The CLI scenario is reproducible in test and production environments. |
input.csv contract
| # | Field | Type | Sample | Purpose |
|---|
| 1 | BatchNumber | string | FISH-OIL-SPEC-001 | Batch or lot identifier used for traceability, review and deviation investigation. |
| 2 | TotalHg_ppb | decimal | 80.0 | Controlled input parameter used by deterministic QC rules and traceable result generation. |
| 3 | InorganicHg_ppb | decimal | 10.0 | Controlled input parameter used by deterministic QC rules and traceable result generation. |
| 4 | MethylHg_ppb | decimal | 70.0 | Controlled input parameter used by deterministic QC rules and traceable result generation. |
BatchNumber,TotalHg_ppb,InorganicHg_ppb,MethylHg_ppb
FISH-OIL-SPEC-001,80.0,10.0,70.0
FISH-OIL-SPEC-002,95.0,15.0,80.0
FISH-OIL-FAIL-003,120.0,20.0,100.0
FS — Functional Specification
| ID | Function | Implementation |
| FS-001 | CSV import | Read input.csv in UTF-8/CSV-compatible format and validate the header and expected columns. |
| FS-002 | Schema validation | Check mandatory fields, column count, critical missing values and row structure. |
| FS-003 | Type conversion | Convert numeric, flag and text values; invalid formats are recorded as row-level errors. |
| FS-004 | Domain rule engine | Apply domain rules for Mercury Speciation: Methyl vs Inorganic, including limits from the utility description and approved specification. |
| FS-005 | Status aggregation | Produce final status: FAIL for critical failure, WARNING for non-critical deviation, PASS for conformance. |
| FS-006 | JSON export | Write output.json with detailed checks, source values, warnings, failures and critical findings. |
| FS-007 | Audit support | Keep the result structure suitable for review, deviation investigation, calculation reproduction and IQ/OQ/PQ preparation. |
| FS-008 | Integration contract | Support the production scenario: LIMS/ELN/MES creates input.csv, the utility returns output.json, and the portal displays description and documentation. |
| FS-009 | Error handling | Report errors unambiguously and do not substitute missing values with calculated values unless the rule is explicitly defined. |
| FS-010 | Version control support | Document the utility version, input contract, executable checksum and rule application date. |
Example output.json
{
"utilityId": "mercury-speciation-methyl-vs-inorganic",
"utilityName": "Mercury_Speciation_Methyl_vs_Inorganic",
"overallStatus": "PASS|WARNING|FAIL",
"sourceFile": "input.csv",
"checks": [
{
"parameter": "BatchNumber",
"value": "FISH-OIL-SPEC-001",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "TotalHg_ppb",
"value": "80.0",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "InorganicHg_ppb",
"value": "10.0",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "MethylHg_ppb",
"value": "70.0",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
}
],
"criticalFindings": [],
"warnings": [],
"generatedFor": "QA/QC review and LIMS integration"
}
Traceability matrix
| URS | FS | OQ/PQ coverage |
|---|
| URS-001, URS-003 | FS-001, FS-002, FS-003 | OQ-001/OQ-002/OQ-003 |
| URS-002, URS-004 | FS-004, FS-005 | OQ-004/PQ-001 |
| URS-005, URS-007 | FS-006, FS-007 | OQ-005/PQ-002 |
| URS-008, URS-010 | FS-008, FS-010 | IQ-001/OQ-006 |
OQ/PQ test scenarios
| ID | Scenario | Expected result |
|---|
| OQ-001 | Valid sample row | PASS or acceptable WARNING according to the rules. |
| OQ-002 | Mandatory column missing | Schema error or FAIL. |
| OQ-003 | Non-numeric value in numeric field | Type-conversion error. |
| OQ-004 | Critical parameter outside limit | FAIL and critical finding. |
| OQ-005 | Multiple rows with different statuses | Independent row-level evaluation. |
| PQ-001 | User real batch/sample | Reviewed result with retained input/output files. |
QA/QC and change control
- Do not rename columns without updating the validator, documentation and test set.
- Retain
input.csv, output.json, executable version, documentation and checksum. - Before production use, perform IQ/OQ/PQ or equivalent CSV/CSA verification.
- Critical limits must be verified against the approved specification, local SOPs and registration dossier.