Inspiration
Managing production data from multiple plants with inconsistent Excel formats is a common bottleneck in manufacturing. We built PlantUnify to solve this — a centralized platform that standardizes and visualizes performance metrics across all plants.
What it does
PlantUnify is a data platform that unifies Excel reports from 7 different manufacturing plants, each with inconsistent formats. It standardizes the data, cleans it, and generates a centralized dashboard with key metrics like: Bottles Produced Defect Rate Downtime Shift-wise Performance Users can select individual plant files or combine all data, view summary stats, and generate visual reports — all through a simple and intuitive Streamlit interface.
How we built it
Data Ingestion: Processes Excel files from 7 plants with varied formats. Standardization: Mapping + cleaning modules unify data using JSON configs. Dashboard: Built with Streamlit to show key metrics (bottles produced, defect rate, downtime) with interactive visualizations.
Challenges we ran into
Handling diverse formats and missing fields Balancing dashboard clarity and functionality Ensuring future extensibility within a limited time
Accomplishments that we're proud of
Built a fully functional data pipeline that gracefully handles messy Excel files. Designed a modular system where new plant formats can be added with minimal effort. Delivered a clean and interactive dashboard within 36 hours. Maintained a balance between scalability, usability, and visual clarity.
What we learned
How to handle real-world, inconsistent data using Python and Pandas. Streamlit’s powerful layout system for building multi-page apps. The importance of planning data architecture and user flow before coding. Managing a complete product lifecycle — from ingestion to visualization — under time pressure.
What's next for PlantUnify
Manual Data Entry Interface – for plants that don’t use Excel. Cloud Storage Integration – auto-fetch reports from Google Drive or OneDrive. User Roles & Authentication – allowing different access levels for plant managers and HQ.
Log in or sign up for Devpost to join the conversation.