Skip to content
Code by Sergio
PTENES

Relatório Merger

My first internal system came from a question: why spend an hour on something code can do in minutes?

Proprietary code

Back to category
Relatório Merger
Context
One of my first tools at Virtron.
Problem
Two Excel reports had to be cross-referenced by hand.
Solution
A Python application that cross-references both by the client’s internal code.
Impact
Still in use at the company.

  • ~1 h

    Before, per merge

  • ~5 min

    After, with the tool

  • ~2×

    Per week

Approximate figures.

Technologies

Stack

PythonPandasOpenPyXL