Railway Repair Tracker
The client managed railway repair processes through a large Excel spreadsheet with multiple stages, deadlines, statuses, and nested workflows.
My goal was to integrate this complex production logic into the company’s existing task-tracker product and make the interface more convenient for daily operations.
This concept was created as part of a presale/product adaptation process to demonstrate how the client could transition from Excel to a full enterprise system without losing their привычный workflow.
My goal was to integrate this complex production logic into the company’s existing task-tracker product and make the interface more convenient for daily operations.
This concept was created as part of a presale/product adaptation process to demonstrate how the client could transition from Excel to a full enterprise system without losing their привычный workflow.
Problem
What I Did
The original Excel system was:
- — Overloaded with information
- — Difficult to navigate
- — Inconvenient when handling a large number of tasks and dates
- — Poorly scalable for everyday use
- It was especially hard to quickly:
- — Spot overdue tasks
- — Understand the hierarchy of stages
- — Work across a large number of columns at once
- Translated the Excel structure into a task-tracker interface I built a system of columns and cards where each repair stage appears as a separate task with a clear structure.
- Added: — Nesting (parent–child task relationships) — A tree-like structure — A UX focused around dates — Dates as the central element of the interface — speeding up visual scanning and making statuses easier to read at a glance Kept from the original workflow: — Workshops — Departments — Repair stages — Nested processes — The team's familiar way of working
Result
The outcome is a modern enterprise railway tracker that:
- Preserves the familiar Excel logic
- Makes work faster and more convenient
- Reduces visual clutter
- Simplifies navigation through complex processes
Before (Table in Excel)
After
