wastewise-analytics-validated

Waste validation ensures invoices, contracts, and related datasets pass mandatory quality checks across contract terms, formula accuracy, optimization feasibility, and data completeness before any report is produced. Upload 6+ months of invoices with an optional service contract; the Skill runs 30+ validation checks and halts if critical checks fail, guaranteeing accuracy.

If validation fails, the Skill halts report generation and specifies which checks failed—contract detection, clause extraction, formula errors, sheet structure, cross-sheet inconsistencies, or optimization constraints. This prevents unreliable recommendations and forces data correction before output proceeds.

Yes. The Skill performs verbatim clause extraction across seven contract categories and generates a CONTRACT_TERMS sheet with extracted obligations, pricing terms, and calendar reminders, ensuring no contractual detail is missed during waste analysis.

Optimization validation enforces pre-defined criteria including per-compactor pricing accuracy, a 14-day constraint on feasibility windows, and cross-sheet data consistency. Only waste reduction opportunities meeting all strict criteria are recommended, preventing invalid or unfeasible suggestions.

Upload Excel workbooks (.xlsx format); the Skill uses pandas for data processing, openpyxl for spreadsheet validation, python-dateutil for constraint checks, and typing for validation integrity. Standard Python 3 environment with these dependencies installed is required.

Yes. The Skill validates waste data across multiple properties consistently by enforcing identical validation rules, formula accuracy, and cross-sheet completeness. Regional directors can trust validated reports without manual double-checking across properties.