I Built a Local AI to Turn a Shop's Evening Spreadsheet Hunt Into a Fix Queue

Описание и применение

QuietOps автоматизирует проверку операционных таблиц небольшого магазина, выявляя проблемы с запасами, просроченными заказами и дублирующими счетами, и предоставляет AI‑объяснения и черновики действий, которые владелец может одобрить и экспортировать.

Задача

Small shop owners need to sift through multiple spreadsheets at closing time to identify actionable items before they become tomorrow's problems.

Результат

QuietOps reduced manual spreadsheet review time, surfaced actionable items with AI explanations, and enabled owners to approve and export actions locally without external APIs.

Рабочий процесс

• Import or load spreadsheets
• Confirm header mappings and data consistency
• Run deterministic checks for stock cover, overdue POs, duplicate invoices
• AI generates explanations and draft actions
• Owner reviews and approves drafts
• Export approved actions
• Audit trail records decisions

Доказательства

QuietOps turns operational spreadsheets into an issue inbox, with a calculation and a route back to the source for every flag.

Источник

The interface has eight working views: overview, issue inbox, fix queue, inventory, suppliers, import and mapping, quality review, and audit history.

Источник

The first decision was to keep arithmetic inspectable. The model does not choose whether a purchase order is late or calculate days of cover.

Источник

QuietOps uses frontend port 3002, backend port 9002, and a dedicated Ollama listener on 11436.

Источник