I already store all of my shipment and maintenance records in Google Sheets; now I need those raw rows turned into a clear, interactive dashboard. The focus is strictly on performance metrics—most importantly maintenance downtimes and shipment accuracy—so that I can see, at a glance, how reliably the fleet is running and how often we hit promised delivery targets. Everything must stay within Google Sheets. I’m imagining a streamlined file where the existing data feeds a transformation layer and, ultimately, an eye-catching dashboard tab. Dynamic charts, scorecards, and slicers that refresh automatically as new rows are added will make the sheet truly useful to my team. Feel free to incorporate QUERY, ARRAYFORMULA, pivot tables, and—if needed—lightweight Apps Script, but please keep the solution well-commented so I can tweak it later. Acceptance criteria: • One Google Sheets file containing: raw data (as is), transformation logic, and the visual dashboard. • Real-time KPIs for maintenance downtime (total hours, MTTR, % downtime) and shipment accuracy (on-time %, discrepancy count). • Visuals and figures that update automatically when new data is appended. • Clear documentation of any formulas, named ranges, or scripts you introduce. If you’ve built logistics or maintenance dashboards before and can turn this around within a week, let’s get started.