🛠️ Engineering Project Tracker – Excel KPI Dashboard

A senior-level Excel dashboard to track project phases, deadlines, errors, and delivery accuracy in mechanical detailing workflows. Built entirely in Excel with dynamic formulas, conditional formatting, and automated visuals.

---

🔍 Purpose

Engineering teams often lack real-time visibility into task completion, overdue items, and error trends. This project solves that with a centralized Excel tracker, suitable for non-coders and executive leads.

---

📊 Features

• Status-based color logic: Completed ✅, On Track 🟡, Overdue ❌
• Error tracking by part and level
• Auto-updating KPI summary:
  • Total Projects
  • Completed %
  • Overdue Count
  • Error %
• Dashboard visuals:
  • Project status breakdown (bar chart)
  • Error trends (if applicable)

---

💼 Business Value

• Streamlines project tracking for engineering managers
• Fully Excel-based—no external software needed
• Can be expanded with VBA, slicers, or Power BI

---

👤 Author

Yengkong Sayaovong
📧 [email protected]
🔗 LinkedIn