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.

来源