Three supplier PDFs used different article numbers, number formats and pack sizes. I retained each original reference, matched the manufacturer and variant, and calculated the per-unit price using the confirmed number of units. A box of five priced at €12.40, for example, is €2.48 per unit.
Protecting the comparison
The catalogue selects the lowest released EUR quote for each variant. The price register retains the original currencies, including USD. Missing prices, ambiguous pack sizes and conflicting prices on identical terms are held for review. Each quotation carries a PDF, page and line reference.
What the workbook contains
The twelve sheets cover 324 source lines and 108 catalogue variants. Six duplicate lines are logged, leaving 318 quotations in the register, of which 18 are on hold. The catalogue, quote register and controls let a buyer inspect the basis of a price before relying on it.


Catalogue and exception excerpts showing selected unit prices and the source line behind each decision.
0 likes · 0 views · Nov 17, 2026
Consolidated 324 lines from three supplier PDFs into Excel, matching variants and comparing unit prices by currency. Disputed quotes stay traceable.