ⓘ
Dashboard: The landing screen shows the 7-step calibration workflow, key metrics, recent groups, and action items. Click any step in the stepper or any sidebar link to navigate. Hover over dotted-underline text for detailed explanations.
⚡ Application Workflow Overview
Complete flow from lab setup to approved calibration report
1. Lab Setup
→
2. Upload Runs
→
3. Analyte Mapping
→
4. Build Group
→
5. Compute / DVD
→
6. Summary Report
→
7. QA Approval
3
Instruments Active
12
CAL Runs Today
4
Groups Pending QA
28
Reports Approved (MTD)
Recent Calibration Groups
| Group | Instrument | Analytes | Status | Date |
|---|---|---|---|---|
| GRP-2026-0312 | MS4 (GC/MS) | 72 | Approved | Mar 8 |
| GRP-2026-0311 | FID5 (FID) | 3 | Approved | Mar 7 |
| GRP-2026-0310 | IC1 (IC) | 7 | Computed | Mar 6 |
| GRP-2026-0309 | MS4 (GC/MS) | 72 | Draft | Mar 5 |
Action Items
| Task | Details | Priority |
|---|---|---|
| Resolve unmatched analytes | 3 compounds in Run #1047 | Medium |
| QA review pending | GRP-2026-0310 (IC1) | High |
| ICV verification needed | GRP-2026-0309 missing ICV | Medium |
| QuickBooks sync | 3 invoices pending | Low |
ⓘ
Lab Setup (Prerequisite): This is the first thing an Admin must complete. The system blocks all calibration workflows (upload, compute, approve) until a Laboratory record and at least one Lab Technician profile exist. This ensures every run is traceable to a real lab and a qualified person.
⛨ Lab Setup PREREQUISITE
Laboratory details and technician profiles must be configured before any analytics workflow can begin.
Laboratory Details
Lab Technicians
| Name | Role | Status | |
|---|---|---|---|
| Robert A. | Analyst | Active | |
| Raina M. | Analyst | Active | |
| Nathan B. | Analyst | Active | |
| Walter R. | Admin QA | Active |
Instruments
| ID | Name | Type | Manufacturer | Model | Status |
|---|---|---|---|---|---|
| INST-001 | MS4 | GC/MS | Agilent | 5977B | Active |
| INST-002 | FID5 | FID | Agilent | 8890 | Active |
| INST-003 | IC1 | IC | Metrohm | 940 Pro | Active |
| INST-004 | ICP-MS1 | ICP-MS | Thermo | iCAP RQ | Maintenance |
ⓘ
Upload Run: An Analyst pastes (or uploads) the raw text output from a lab instrument. The system's parser identifies the format, extracts metadata (operator, method, date), and breaks the text into individual compound result rows. The raw text is stored immutably with a SHA-256 hash for data integrity.
1. Lab Setup
→
2. Upload Runs
→
3. Analyte Mapping
→
4. Build Group
→
5. Compute
→
6. Report
→
7. Approve
⇪ Upload / Paste Raw Instrument Text
Parsed Preview
Parse Status: Valid — 72 compounds parsed, 0 warnings
Metadata Extracted
| Data Path | D:\MassHunter\GCMS\1\data\2026\Mar\ |
| Operator | Robert A. |
| Method | EPA8260C_VOC.M |
| Text Hash (SHA-256) | a7f3c9...e2d1b8 |
Compound Rows (showing first 6 of 72)
| Compound | RT | QIon | Response | Conc | Mapped |
|---|---|---|---|---|---|
| Dichlorodifluoromethane | 1.82 | 85 | 4,562 | 9.87 | Yes |
| Chloromethane | 2.14 | 50 | 3,891 | 10.12 | Yes |
| Vinyl chloride | 2.31 | 62 | 5,234 | 10.34 | Yes |
| Bromomethane | 2.67 | 94 | 2,876 | 9.65 | Yes |
| Chloroethane | 2.89 | 64 | 4,123 | 10.21 | Yes |
| Unknown-Cmpd-X42 | 5.44 | 91 | 1,203 | -- | Unmatched |
ⓘ
Analyte Mapping: Different instruments and methods may use different names for the same compound (e.g., "DCM" vs "Dichloromethane"). This screen resolves ambiguity by letting the analyst map raw names to canonical analytes and save the mapping as a reusable alias. Once an alias is saved, future uploads auto-match.
1. Lab Setup
→
2. Upload Runs
→
3. Analyte Mapping
→
4. Build Group
→
5. Compute
→
6. Report
→
7. Approve
⇄ Resolve Unmatched Compound Names
3 compound names from recent runs could not be matched to canonical analytes. Map them below or create new aliases.
| Raw Compound Name | Run | Suggested Match | Confidence | Action |
|---|---|---|---|---|
| Unknown-Cmpd-X42 | Run #1047 (MS4, Cal_10ppb) | 91% | ||
| Dichloro-DFM | Run #1045 (MS4, Cal_1ppb) | 95% | ||
| trans-1,3-DCP | Run #1046 (MS4, Cal_50ppb) | 88% |
Existing Alias Registry (showing 6 of 142)
| Alias | Canonical Analyte | Created By | Date |
|---|---|---|---|
| DCM | Dichloromethane | Robert A. | Jan 15, 2026 |
| MeCl | Chloromethane | Walter R. | Dec 3, 2025 |
| Benz. | Benzene | Raina M. | Feb 20, 2026 |
| TCE | Trichloroethylene | Robert A. | Jan 22, 2026 |
| PCE | Tetrachloroethylene | Walter R. | Nov 10, 2025 |
| EDB | 1,2-Dibromoethane | Raina M. | Mar 1, 2026 |
ⓘ
Calibration Group Builder: The analyst assembles a group by selecting multiple CAL runs (one per concentration level) and optionally attaching an ICV run. The system validates readiness before allowing regression computation. When "Compute" is clicked, the active Method Config is snapshotted (frozen) so future config changes don't retroactively affect this group's results.
1. Lab Setup
→
2. Upload Runs
→
3. Analyte Mapping
→
4. Build Group
→
5. Compute
→
6. Report
→
7. Approve
⚙ Assemble Calibration Group
Select CAL Runs (check to include)
| Run | Level | True Conc | Date | Status | |
|---|---|---|---|---|---|
| #1040 | Cal_0.1ppb | 0.1 | Mar 10 | Valid | |
| #1041 | Cal_0.5ppb | 0.5 | Mar 10 | Valid | |
| #1042 | Cal_1ppb | 1.0 | Mar 10 | Valid | |
| #1043 | Cal_2ppb | 2.0 | Mar 10 | Valid | |
| #1044 | Cal_5ppb | 5.0 | Mar 10 | Valid | |
| #1045 | Cal_10ppb | 10.0 | Mar 10 | Valid | |
| #1046 | Cal_20ppb | 20.0 | Mar 10 | Valid | |
| #1047 | Cal_50ppb | 50.0 | Mar 10 | Warnings | |
| #1048 | Cal_100ppb | 100.0 | Mar 10 | Valid | |
| #1049 | Cal_200ppb | 200.0 | Mar 10 | Valid |
ICV Run (optional)
Readiness Check
Ready to Compute
All validation checks passed
| CAL Runs | 10 levels (meets minimum of 5) | PASS |
| Level Duplicates | None detected | PASS |
| Analyte Mappings | 72/72 resolved | PASS |
| Internal Standards | 3 IS detected (Fluorobenzene, etc.) | PASS |
| ICV Run | #1050 attached | PASS |
| Method Config | EPA8260C v3 (active) | PASS |
This will snapshot MethodConfig v3 and compute all 9 mathematical models per analyte.
ⓘ
DVD / Regression Dashboard: The core analytical screen. "DVD" stands for Data Validation Dashboard. For each analyte, the system computes all 9 mathematical regression models simultaneously (3 types × 3 weighting schemes). The analyst compares %Diff values, R², RSE across models, can exclude outlier points, and selects the best-fit model. The ICV Calculator verifies the selected curve against an independent standard. All math is done server-side using manual formulas — no third-party math libraries.
1. Lab Setup
→
2. Upload Runs
→
3. Analyte Mapping
→
4. Build Group
→
5. Compute / DVD
→
6. Report
→
7. Approve
★ DVD Regression Dashboard — GRP-2026-0312 (MS4)
(72 analytes total)
LS/IC (Linear 1/x)
LS/IC2 (Linear 1/x²)
QD/IC (Quadratic 1/x)
QD/IC2 (Quadratic 1/x²)
Calibration Points & %Diff by Model
Red cells = point fails %Diff threshold (±20%). Uncheck "Included" to exclude an outlier point — exclusion is audit-logged.
| Level | True Conc | Response | Ratio | LS/IC %Diff | LS/IC2 %Diff | QD/IC %Diff | QD/IC2 %Diff | Included |
|---|---|---|---|---|---|---|---|---|
| Cal_0.1 | 0.1 | 456 | 0.026 | -28.4% | -24.1% | -12.3% | -9.8% | |
| Cal_0.5 | 0.5 | 2,341 | 0.133 | -8.2% | -5.1% | -3.7% | -2.1% | |
| Cal_1 | 1.0 | 4,892 | 0.278 | -3.1% | -1.8% | -1.2% | -0.6% | |
| Cal_2 | 2.0 | 9,567 | 0.544 | 1.2% | 0.8% | 0.4% | 0.2% | |
| Cal_5 | 5.0 | 23,890 | 1.358 | 2.4% | 1.9% | 1.1% | 0.7% | |
| Cal_10 | 10.0 | 47,234 | 2.685 | -1.5% | -0.9% | -0.4% | -0.1% | |
| Cal_20 | 20.0 | 95,678 | 5.440 | 0.8% | 0.5% | 0.3% | 0.1% | |
| Cal_50 | 50.0 | 238,450 | 13.554 | -2.1% | -1.4% | -0.8% | -0.3% | |
| Cal_100 | 100.0 | 471,230 | 26.789 | 1.7% | 1.2% | 0.6% | 0.2% | |
| Cal_200 | 200.0 | 952,100 | 54.123 | -0.9% | -0.5% | -0.2% | -0.1% |
Model Comparison — Curve Statistics
| Metric | LS/IC | LS/IC2 | QD/IC | QD/IC2 | Threshold |
|---|---|---|---|---|---|
| Points Used | 10 | 10 | 10 | 10 | ≥ 5 |
| Points Failed | 1 | 1 | 0 | 0 | ≤ 1 |
| RSD / RSE | 8.42% | 6.31% | 4.18% | 3.25% | ≤ 15% |
| R² | 0.99912 | 0.99954 | 0.99987 | 0.99993 | ≥ 0.995 |
| Slope | 0.2694 | 0.2701 | -- | -- | -- |
| Intercept | -0.0043 | -0.0028 | -- | -- | -- |
ICV Calculator — All Models at Once
ICV True Concentration: 10.0 ppb | Threshold: ±20%
| Model | ICV Calc’d | %Diff | Status |
|---|---|---|---|
| LS/IC | 10.24 | 2.4% | PASS |
| LS/IC2 | 10.11 | 1.1% | PASS |
| QD/IC | 10.05 | 0.5% | PASS |
| QD/IC2 | 10.02 | 0.2% | PASS |
Analyst Recommendation: All 4 models pass. LS/IC (teal) is the simplest passing model.
Report Card — Model Ranking
Higher score = better overall fit. Scores consider %Diff, RSE, R², and point failures.
| Rank | Model | Points Score | RSE Score | R² Score | ICV Score | Total | Selected |
|---|---|---|---|---|---|---|---|
| 1 | QD/IC2 | 10 | 10 | 10 | 10 | 40 | |
| 2 | QD/IC | 10 | 9 | 9 | 9 | 37 | |
| 3 | LS/IC2 | 9 | 8 | 8 | 8 | 33 | |
| 4 | LS/IC | 9 | 7 | 7 | 7 | 30 | Selected (simplest passing) |
ⓘ
Summary Report: A comprehensive, printable report showing pass/fail results for every analyte against the configured acceptance criteria. Mirrors the format from the legacy "Walter's calculator" Excel workbook. Exportable as PDF or CSV. This is what the analyst submits for QA review and what goes into the lab's permanent records.
1. Lab Setup
→
2. Upload Runs
→
3. Analyte Mapping
→
4. Build Group
→
5. Compute
→
6. Summary Report
→
7. Approve
Calibration Summary Report — GRP-2026-0312
Generated Mar 10, 2026 | Config: EPA8260C v3Report Header
Instrument: MS4 (GC/MS, Agilent 5977B)
Method: EPA8260C_VOC.M
Operator: Robert A.
Run Dates: Mar 10, 2026
Config Version: v3 (snapshot)
Cal Points: 10 levels (0.1 – 200 ppb)
ICV Source: Run #1050 (10 ppb)
Approval: Pending QA
Computation: Mar 10, 2026 10:42 AM
Page 1 — Acceptance Criteria (Reference Table)
| Criterion | Threshold |
|---|---|
| RSD / RSE | ≤ 15% |
| Correlation Coefficient (R²) | ≥ 0.995 |
| Max Allowable Cal Point Failures | ≤ 1 |
| Min Cal Points (Average) | ≥ 4 |
| Min Cal Points (Linear) | ≥ 5 |
| Min Cal Points (Quadratic) | ≥ 6 |
| ICV %Diff Limit | ± 20% |
| Cal Point %Diff Limit | ± 20% |
Page 2 — Calibration Evaluation Table (showing 8 of 72 analytes)
| Analyte | Model | Pts Used | Pts Failed | RSD≤15% | RSE≤15% | R²≥.995 | ICV %Diff | ICV≤20% | CAL Status | Overall |
|---|---|---|---|---|---|---|---|---|---|---|
| Benzene | LS/IC | 10 | 1 | 8.42% Y | 6.18% Y | .9991 Y | 2.4% | Y | PASS | Acceptable |
| Toluene | LS/IC | 10 | 0 | 5.21% Y | 4.02% Y | .9996 Y | 1.8% | Y | PASS | Acceptable |
| Ethylbenzene | LS/IC2 | 10 | 0 | 4.87% Y | 3.55% Y | .9997 Y | 0.9% | Y | PASS | Acceptable |
| Xylenes (total) | LS/IC | 10 | 0 | 6.12% Y | 4.76% Y | .9994 Y | 1.4% | Y | PASS | Acceptable |
| Chloroform | LS/IC2 | 10 | 0 | 7.33% Y | 5.89% Y | .9992 Y | 3.1% | Y | PASS | Acceptable |
| 1,1-Dichloroethane | QD/IC | 9 | 0 | 3.95% Y | 3.12% Y | .9998 Y | 0.7% | Y | PASS | Acceptable |
| Dichlorodifluoromethane | AVG | 10 | 0 | 24.4% N | -- | -- | 5.2% | Y | FAIL | Not Acceptable |
| Trichloroethylene | LS/IC | 10 | 1 | 9.15% Y | 7.22% Y | .9989 Y | 4.3% | Y | PASS | Acceptable |
71 of 72 analytes acceptable. 1 analyte requires model change (Dichlorodifluoromethane — RSD exceeds 15% on Average model).
ⓘ
QA Approval: Only users with the QA role can access this screen. Approval is irreversible — once approved, all group data (raw text, computed curves, measurements, config snapshot) is permanently locked. No one can edit or delete approved data. A full audit trail (who, when, comment) is recorded. Rejected groups return to the analyst for correction.
1. Lab Setup
→
2. Upload Runs
→
3. Analyte Mapping
→
4. Build Group
→
5. Compute
→
6. Report
→
7. QA Approval
✓ QA Review & Approval — GRP-2026-0312
Review the calibration results below and approve or reject. Approval locks all group data.
Group Summary
| Group ID | GRP-2026-0312 |
| Instrument | MS4 (GC/MS) |
| Analytes | 72 total (71 pass, 1 fail) |
| CAL Runs | 10 levels included |
| ICV | Run #1050 — 10 ppb |
| Computed By | Robert A. (Analyst) |
| Config Snapshot | EPA8260C v3 |
Quick Status
71
Analytes PASS
1
Analytes FAIL
Failure: Dichlorodifluoromethane — RSD 24.4% exceeds 15% threshold on Average model. Analyst should select a different model (e.g., LS/IC).
Approval Action
Approval locks all group results. No further edits allowed. An audit record will be created.
ⓘ
User Management (Admin Only): Admins create user accounts, assign/remove roles, and link users to Lab Technician profiles. The system prevents the last Admin from removing their own Admin role (self-lockout protection). All role changes are recorded in the Audit Log.
☶ User Management Admin Only
Assign and remove roles for any user. Role changes take effect on next login.
| User | Roles | Lab Technician | Status | Actions | |
|---|---|---|---|---|---|
| Walter R. | walter@precisionenv.com | Admin QA | Linked | Active | |
| Robert A. | robert@precisionenv.com | Analyst | Linked | Active | |
| Raina M. | raina@precisionenv.com | Analyst | Linked | Active | |
| Nathan B. | nathan@precisionenv.com | Analyst | Linked | Active | |
| Kirk W. | kirk@precisionenv.com | Viewer | -- | Active | |
| Jake C. | jake@precisionenv.com | Viewer | -- | Active |
Role Permissions Reference
| Role | Upload Runs | Compute | Approve | Edit Config | Manage Users | View |
|---|---|---|---|---|---|---|
| Admin | Yes | Yes | Yes | Yes | Yes | Yes |
| Analyst | Yes | Yes | No | No | No | Yes |
| QA | No | No | Yes | No | No | Yes |
| Viewer | No | No | No | No | No | Yes |
ⓘ
Method Configuration (Admin Only): Defines all acceptance thresholds, default regression type, weighting, and calibration levels for an EPA method. Changes create a new version — existing groups keep their snapshotted version permanently. This ensures reproducibility: you can always see exactly which rules were applied when a group was computed.
⚒ Method Configuration Admin Only
Changes create a new config version. Existing calibration groups retain the version they were computed with.
Active Config — EPA8260C v3
Calibration Levels
| Level Name | True Concentration | Sort Order | |
|---|---|---|---|
| Cal_0.1ppb | 0.1 | 1 | |
| Cal_0.5ppb | 0.5 | 2 | |
| Cal_1ppb | 1.0 | 3 | |
| Cal_2ppb | 2.0 | 4 | |
| Cal_5ppb | 5.0 | 5 | |
| Cal_10ppb | 10.0 | 6 | |
| Cal_20ppb | 20.0 | 7 | |
| Cal_50ppb | 50.0 | 8 | |
| Cal_100ppb | 100.0 | 9 | |
| Cal_200ppb | 200.0 | 10 |
Version History
| Version | Changed By | Date | Changes |
|---|---|---|---|
| v3 | Walter R. | Feb 15, 2026 | Updated max RSE from 20% to 15% |
| v2 | Walter R. | Jan 8, 2026 | Added Cal_0.1ppb level |
| v1 | Walter R. | Dec 1, 2025 | Initial configuration |
ⓘ
QuickBooks Integration: After QA approval, the system can automatically generate invoices in QuickBooks Online for the client. Uses OAuth 2.0 for secure connection. Customers are synced from QuickBooks and linked to calibration groups via a QuickBooksCustomerLink. Invoice generation only triggers after approval, ensuring only finalized work is billed.
$ QuickBooks Integration
Connection Status
Connected
Realm: Precision Environmental Labs, Inc.
Environment: Production | Token expires: Mar 15, 2026
Customer Sync
Last sync: Mar 9, 2026 3:15 PM
| Customers synced | 24 |
| Created | 0 |
| Updated | 2 |
| Failed | 0 |
Recent Invoices
| Group | Customer | Amount | QB Invoice | Status | Created |
|---|---|---|---|---|---|
| GRP-2026-0312 | Acme Environmental | $150.00 | INV-4521 | Paid | Mar 8 |
| GRP-2026-0311 | Midwest Drilling Co. | $95.00 | INV-4520 | Sent | Mar 7 |
| GRP-2026-0310 | Acme Environmental | $150.00 | -- | Pending | -- |
ⓘ
Audit Log: Every significant action in the system is recorded with who, when, what, and a correlation/trace ID. Entries are immutable — they can never be edited or deleted. This log is essential for regulatory compliance (EPA, TNI) and provides a complete chain of custody for all calibration data.
🔎 Audit Log
| Timestamp | User | Action | Entity | Detail | Trace ID |
|---|---|---|---|---|---|
| Mar 10, 10:45 AM | Walter R. | Approval | GRP-2026-0312 | Approved with comment | 00-a7f3c9 |
| Mar 10, 10:42 AM | Robert A. | Computation | GRP-2026-0312 | Config EPA8260C v3 | 00-b8e2d1 |
| Mar 10, 10:38 AM | Robert A. | Point Excluded | PT-8821 | Cal_0.1 excluded for Benzene (manual: outlier at low end) | 00-c9f4e2 |
| Mar 10, 10:30 AM | Robert A. | Run Uploaded | RUN-1050 | ICV_10ppb on MS4, hash: a7f3...e2d1 | 00-d1a5f3 |
| Mar 10, 10:15 AM | Robert A. | Alias Created | Analyte #42 | "Unknown-Cmpd-X42" mapped to 1,1-Dichloroethane | 00-e2b6a4 |
| Mar 10, 9:00 AM | Robert A. | Run Uploaded | RUN-1040 | CAL Cal_0.1ppb on MS4, hash: f3c9...b8e2 | 00-f3c7b5 |
| Mar 9, 4:30 PM | Walter R. | Role Assigned | User: Kirk W. | Added role: Viewer | 00-a4d8c6 |
| Mar 9, 3:15 PM | Walter R. | QB Customer Sync | QuickBooks | 24 synced (2 updated) | 00-b5e9d7 |