Case study · Internal tools · Logistics

Panelforge: replacing spreadsheet chaos with a live, auditable shipment tracker

An internal operations dashboard for a logistics team, built around three roles so the right person can do the right thing and nothing gets lost.

The problem

Spreadsheets weren't built to run daily operations

The team was tracking every shipment by hand. As volume grew, the cracks became impossible to ignore.

Shipment status was scattered across shared spreadsheets. With no shared reference, staff regularly duplicated entries for shipments already logged.

Managers had no way to see what was pending approval. Getting a status update meant chasing someone down, usually over WhatsApp.

When a shipment went wrong there was no record of who changed what, or when. Resolving a dispute meant guesswork, not evidence.

The approach

Built on ASP.NET Core and SQL Server, structured around three permission tiers with a full audit log and live updates.

Staff log shipments, managers approve or reject them, and admins manage user accounts. Three tiers keep the workflow honest.

Every status change writes to an audit log: a permanent, timestamped record of exactly what happened and who did it.

SignalR pushes changes to every connected client instantly, so the whole team sees the same state without refreshing.

Managers generate an Excel or PDF report of any shipment view in a single click, ready to hand to stakeholders.

The result

One shared, always-current view of shipment status across the whole team.

Managers work through a clear queue instead of chasing updates over WhatsApp.

The audit trail turns "who changed this?" from a guessing game into a lookup.

A closer look

From sign-in to reporting, the product as the team sees it day to day.

Built with

ASP.NET Core · Entity Framework Core · SQL Server · React · TypeScript · SignalR · Tailwind CSS

If your team is still running operations out of spreadsheets and group chats, let's talk about what a purpose-built dashboard could look like.