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

Description and use

QuietOps automates the review of a small shop’s operational spreadsheets, flagging stock, PO, and invoice issues, providing AI explanations and draft actions for owner approval and export.

Problem

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

Outcome

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

Workflow

• 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

Evidence

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

Source

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

Source

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

Source

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

Source