13,896
Structurally supported
11,087 historical + 2,809 records from the 2026 source.
Registration totals, tested against their source records.
A focused view of applications, approved product registrations, issued energy labels, and the audit trail recovered from the old system.
Overall verdict
Applications and approvals reconcile structurally. The energy-label total is stale by 138 records.
13,383
Structurally supported
10,828 historical + 2,555 approved 2026 records.
20,256
Needs correction
Current source supports 20,394 — a difference of +138.
Category distribution
Cumulative values displayed in the October 2 report
Year-by-year report construction
Select a year to inspect reported category totals. For 2026, the label evidence column shows the recomputed source.
| Category | Applications | Approved | Reported labels | Source labels | Label difference |
|---|
Swipe horizontally to see all reconciliation columns.
Supporting records
Search the registration-level evidence behind the three metrics. Company names and personal details are intentionally excluded.
Loading supporting records…Registration IDs only · no company or personal information
| Registration ID | Category | Year | Supports | Evidence sources | Validation | Logs |
|---|
Duplicate and test-data review
Potential count inflation is separated from legitimate renewals. Records with a normal-looking registration ID are not classified as dummy/test.
—valid duplicate ID groups
—extra 2026 rows
—possible dummy/test rows
—likely renewal groups
Loading duplicate review…Renewals are expected in the issued/renewed label metric
| Review type | Registration ID | Category | Rows | Extra | Source | Details | Recommended action |
|---|
Evidence timeline
Coverage available across the supplied sources
Dec 13, 2021
First SQL applicationOld-system product registration records begin.
Mar 27, 2023
Audit history beginsTransaction logs preserve users, actions, remarks, and SQL operations.
Nov 18, 2025
Operational SQL endsLatest registration and label rows in the dump.
Feb 27, 2026
Recovered logs endLater activity must be supported by the migrated masterlist.
Oct 2, 2026
Report snapshot2026 applications and approvals are represented in the masterlist/report source.
How to read the verdict
What the available evidence can and cannot establish
✓
Applications reconcile arithmetically
11,087 historical records plus 2,809 for 2026 equals 13,896.
✓
Approvals reconcile arithmetically
10,828 historical approvals plus 2,555 for 2026 equals 13,383.
!
The 2026 label pivot is stale
It displays 2,363, while the source contains 2,501 approved/issued rows.
!
Migration dates require care
10,495 masterlist rows are migrated. A simple “2026” date filter can misclassify historical records.
✓
Original evidence remains untouched
The SQL dump and workbooks were read-only throughout the analysis.