← All work
PrototypePrototype
Spreadsheet / Data Workflow Automation
Automation demo
Messy spreadsheet → deterministic validation and normalization → duplicate/anomaly report → clean output → optional lightweight reminder/dashboard.
What problem existed?
Operational data lives in spreadsheets that accumulate inconsistent formats, duplicates, and silent errors — and nobody trusts the numbers enough to act on them.
Context / constraints
- Prototype / automation demo. Synthetic data only.
- Deliberately not positioned as a SaaS — no validated demand is claimed.
What was built
- Deterministic validation and normalization passes over messy tabular data.
- A duplicate/anomaly report that shows exactly what was wrong and what changed.
- Clean output suitable for downstream use, with an optional lightweight reminder/dashboard concept.
Architecture
- A pipeline of pure, deterministic transformations: parse → validate → normalize → report → emit clean rows. Same input always produces the same output.
Scroll horizontally to inspect the diagram at a readable size.
Key engineering decisions
- Deterministic rules over heuristics — every change is explainable.
- Anomalies are reported, never silently discarded.
Validation / tests
- Normalization and duplicate-detection logic covered by unit tests against fixed synthetic fixtures.
What is deliberately not claimed
- Not a product, not a client deployment, no users or outcomes claimed.
Interactive demo — runs directly on this page
data-workflow · demoPrototype · synthetic data
Input · messy rows (synthetic)
| name | phone | date | amount | |
|---|---|---|---|---|
| alex morgan | ALEX.MORGAN@example.com | (555) 010-2233 | 03/04/2025 | $1,200.00 |
| Priya Nair | priya.nair@example.com | 555-010-8899 | 2025-03-11 | 860 |
| ALEX MORGAN | alex.morgan@example.com | 5550102233 | 2025-03-04 | $1,200.00 |
| Daniel Osei | (empty) | 555 010 4411 | Apr 2, 2025 | not set |
| mei chen | MEI.CHEN@EXAMPLE.COM | +1 (555) 010-7722 | 2025-04-15 | $2,045.50 |
Scroll horizontally to review every input column.
Source
- Source repository — not yet publicly available
Want this kind of system built for your workflow?
Start a project