Excel Production Monitoring Dashboard
Budget: ₹1,500 – ₹12,500 INR
All of our production figures are already captured in a single Excel workbook; what I need now is a clear, interactive dashboard that turns those raw rows into insight. The layout should feature bar charts, pie charts, and line graphs so supervisors can see at a glance where we stand. Key metrics are straightforward—total production volume and accumulated downtime—updated automatically each day as fresh data is entered.
The solution must sit entirely inside Excel (Power Query, PivotTables, dynamic arrays, or light VBA—use whichever combination keeps the file fast and maintenance-friendly). A single click refresh is plenty; real-time streaming is not required.
Deliverables
• One dashboard tab with the visualisations laid out cleanly for shop-floor display
• Any supporting queries, tables, or macros, clearly organised and named
• Brief “how-to” notes showing operators how to add new data and trigger the daily refresh
Acceptance criteria
• Both KPIs recalculate correctly when new rows are appended
• Slicers or equivalent controls allow filtering by date range and line/shift without breaking formulas
• File opens without security warnings and runs on standard Office 365 installations
Hand the finished workbook back and, once everything checks out against those points, the project is complete.
The solution must sit entirely inside Excel (Power Query, PivotTables, dynamic arrays, or light VBA—use whichever combination keeps the file fast and maintenance-friendly). A single click refresh is plenty; real-time streaming is not required.
Deliverables
• One dashboard tab with the visualisations laid out cleanly for shop-floor display
• Any supporting queries, tables, or macros, clearly organised and named
• Brief “how-to” notes showing operators how to add new data and trigger the daily refresh
Acceptance criteria
• Both KPIs recalculate correctly when new rows are appended
• Slicers or equivalent controls allow filtering by date range and line/shift without breaking formulas
• File opens without security warnings and runs on standard Office 365 installations
Hand the finished workbook back and, once everything checks out against those points, the project is complete.