Raw Material Locations Tracker

Built for transportation and planning teams tracking raw material allocations across five manufacturing plants. These teams were sharing an Excel workbook with live SQL connections to the ERP system — functional on paper, but unusable in practice when multiple people needed to view and edit it at the same time.

A real-time web app that replaced a shared Excel workbook. The spreadsheet already had SQL connections pulling live ERP data, but Excel wasn't built to be a multi-user application — data went stale when someone left the file open, one person's filters disrupted everyone else's view, and there was no way to control who could edit what.

The web app solves all of that. It queries the same ERP data via SQL Server, presents it in an Excel-like AG Grid interface, and uses Server-Sent Events to push changes to every connected browser instantly. Role-based editing is gated by Active Directory group membership, while read-only access is open to anyone on the network. Automated daily email reports flag warehouse/location mismatches before they become floor problems.

Built in March 2026 and deployed to production for active daily use. The trigger was a recurring set of problems with the shared Excel workbook: stale data from files left open, filter collisions between users, and no access control over who could change what.

Self-hosted on a Proxmox LXC container behind Nginx Proxy Manager with SSL. Accessible to all LAN users in read-only mode without login; authenticated users get edit access based on Active Directory group membership.

The Excel workbook had the right data — it just wasn't built to be a shared application. When one person had the file open, everyone else got a read-only copy with stale data. Filters applied by one user changed the view for everyone. There was no access control, no edit history, and no way to know if what you were looking at was current.

This system replaced the spreadsheet with a purpose-built web app that supports true simultaneous use. Every user gets their own view, edits propagate instantly, and access control is handled by Active Directory — giving the team the same data they already relied on, in a format that actually works with multiple people.