Success story.
Goodbye to spreadsheets: a system that anticipates the maintenance of each tank
A client was managing the lifecycle of their installed equipment using spreadsheets. Information was being lost between updates, they had to wait for the client to call in to request maintenance, and the technical support couldn't scale with the growth of the installed base.
We take on any challenge
At Zenta there are no obstacles we cannot overcome.
Challenge
Replace spreadsheets with a system that anticipates maintenance needs, formalizing rules that previously existed only as team knowledge: the frequency varies depending on the tank's location (coastal, urban, rural) and had to be codified without sacrificing flexibility. All of this had to coexist with the existing ERP/RP system without modification and within a strict limit of 100 man-hours.
Solution
We developed a lightweight, ERP-independent MVP that formalizes frequency rules by zone, automatically calculates the next service date, and schedules technical visits. It includes a single record per tank with a complete history, a zone-editable rules module (no coding required), a configurable alert engine, a scheduling panel for assigning visits to technicians, and an execution log that closes the cycle for each visit. Data is ingested from existing sources (CSV/API/DB) without ERP/RP intervention, with access control by role (Administrator and Technician).
Results from our management
100% of High priority requirements passed in functional testing, with no blocking defects (13 test cases).
MVP awarded within the agreed limit of 100 man-hours.
6-week timeline met, from design to final demo.
Spreadsheet dependency eliminated and acceptance certificate signed by the client at closing.