Complex PDF Table Extraction and Reconciliation by Sam ZeninComplex PDF Table Extraction and Reconciliation by Sam Zenin

Complex PDF Table Extraction and Reconciliation

Portfolio project
Sam Zenin
The report combined load charges, handling fees and credits. I created a structured table for each section so fields such as pallets, handling minutes and related load IDs retained their meaning. The conversion normalized numeric conventions and preserved credits as negative amounts.

Handling uncertainty

Four records showed a blank or unconfirmed printed amount. The numeric fields stay blank, with the printed value or missing entry captured in the Exceptions sheet. Each output row points back to the source page.

Completeness

The six-sheet workbook accounts for all 210 source records: 70 loads, 70 handling entries and 70 credits. The raw register, exception log and controls provide a way to check both row coverage and the treatment of doubtful amounts.
Workbook excerpts showing source page references and the negative sign on recorded credits.
Workbook excerpts showing source page references and the negative sign on recorded credits.

0 likes · 0 views · Nov 17, 2026

Extracted 210 records from a fifteen-page PDF into three Excel tables, preserving negative credits, source pages and four unclear amounts for review.

Tags