Mighty QuinnConsultingMighty Quinn Consulting — home
Engineering

Grocery Retail · Logistics

Loading list against actual load

Container loading plans as XLSX against the goods-received manifests as PDF — line by line, automatically instead of by hand.

Duration
~2 months
Budget
< 10.000 €
Project team
MQC 1 · Client 3

End-of-project survey

This client did not answer our end-of-project survey — so there are no scores to show.

The brief

  • Build an automated run that checks XLSX loading plans against the PDF goods-received manifests and makes inbound tracking more accurate
  • Replace the line-by-line check by hand that until then went through every pair of documents one at a time

The build

  • One central document library, and a Power Automate workflow on it that compares loading list and goods received line by line
  • AI for the matching itself: fuzzy hits across several fields, company names that differ, mixed weight units — kilograms to tonnes, converted exactly
Tech stack
  • Power Automate
  • Google Gemini
  • SharePoint Online
  • Office Scripts
Our part
  • Conception
  • Development

The good

  • The breakthrough was moving from rigid, rule-based Power Automate logic to an AI-driven approach — at the point where parsing the data the classical way stopped getting there

The bad

  • Finding the right prompt for some of the matching calculations was harder than expected