Utilities for transport monitoring systems

01Problem

Bulk edits of map objects and downtime reports by shift were done by hand. One pass took days, and the engineer spent all of it copying.

02What was done

1. 01Bulk editing of monitoring objects — hundreds of them in one run.
2. 02A downtime report broken down by shift, where before it was assembled by hand.
3. 03The working spreadsheets update themselves, with no export and no reconciliation.

03Outcome

• What used to take days of manual work now takes minutes.

04Stack

• Python
• Excel
• Wialon