🔍 Adam Checker
Automated quality control - daily data validation
PRODUCTION MODE
Manual Trigger
Run Adam Checker to validate data integrity across all 13 raw sheets (4 spreadsheets):
📋 Abholscheine
TAU, TAR, MEL, TLT, RAN
🧾 Rechnung
LS, MINEROL, CICA, SOCAR
🛒 Einkauf
LS, MINEROL, CICA, SOCAR
🚚 Lieferscheine
Lieferschein
📊 Last Run Summary
26.09.2026, 15:15
47 rows
5 violations
▼
Total Sheets
16
Successful
16
Failed
0
Rows Processed
47
Total Violations
5
Violation Breakdown
🔄 Duplicates
0
📅 Old Dates (>2 months)
0
❌ Invalid Dates
0
💰 Price Anomalies
0
📄 Extraction Errors
5
🛡️ Row Protection (Step 5)
Sheets Protected
10
Sheets Skipped
6
Protection Failures
0
Total Rows Protected
7094
Protection applies to verified rows (checked_by_adam_checker='true') that are 2+ days old.
📑 Sheet Details
📋 Abholscheine
Abholscheine → TAU
1 rows |
✓ Clean
| 🛡️ 920 protected
Abholscheine → TAR
8 rows |
✓ Clean
| 🛡️ 2155 protected
Abholscheine → MEL
0 rows |
✓ Clean
| 🛡️ 1147 protected
Abholscheine → TLT
0 rows |
✓ Clean
| 🛡️ 1535 protected
Abholscheine → RAN
5 rows |
5 violations
| 🛡️ 93 protected
🧾 Rechnung
Rechnung → LS
0 rows |
✓ Clean
Rechnung → MINEROL
12 rows |
✓ Clean
Rechnung → CICA
0 rows |
✓ Clean
Rechnung → SOCAR
13 rows |
✓ Clean
Rechnung → TAMOIL
0 rows |
✓ Clean
🛒 Einkauf
Einkauf → LS
0 rows |
✓ Clean
| 🛡️ 50 protected
Einkauf → MINEROL
0 rows |
✓ Clean
| 🛡️ 463 protected
Einkauf → CICA
0 rows |
✓ Clean
| 🛡️ 347 protected
Einkauf → SOCAR
0 rows |
✓ Clean
| 🛡️ 319 protected
Einkauf → TAMOIL
0 rows |
✓ Clean
| 🛡️ 65 protected
🚚 Lieferscheine
Lieferscheine → Lieferschein
8 rows |
✓ Clean