Excel KPI Tracker – Repair, Finalise & Automate Dashboard Overview I already have a working Excel-based KPI Tracking Dashboard that records and calculates performance metrics for engineers at my electrical compliance company (Manchester EICR Ltd). The file is mostly built and working but needs repair, formula fixes, and final polish to make it accurate, efficient, and presentation-ready. Current Setup (Already Built) • The workbook includes multiple tabs: • Input: Daily engineer job data (date, engineer name, sick yes/no, jobs booked, completed, cancelled, etc.). • Calc: Backend calculations for daily, weekly, monthly, FY-to-date, and all-time totals. • Dashboard: Executive KPI summary showing key company-wide metrics and 8-week performance charts. • Engineer KPIs: Individual performance tables (daily, weekly, monthly, YTD, all-time) per engineer. • Engineer Rankings: Leaderboard comparing engineer KPIs. • Settings / Lists: Supporting tables and dropdown values. • The structure, layout, and visual design are already in place. • Data entry and charts are linked — most formulas work, but some references and summaries break or miscalculate. The Work Needed 1. Fix / validate formulas across all KPI calculations. • Ensure “Worked” and “Sick” counts pull correctly from Input. • Confirm all summary tables (Daily / Weekly / Monthly / FY / All-time) update dynamically. • Correct SUMPRODUCT / COUNTIFS logic as needed for macOS Excel compatibility. 2. Engineer KPI sheets • Each engineer’s table should automatically populate and update accurately. • Conditional formatting for performance thresholds (e.g., green >90%, amber 80–89%, red <80%). 3. Engineer Rankings sheet • Rebuild leaderboard so it ranks all engineers by metrics (Jobs Completed %, First Time %, etc.), not just top 3. • Automatically refresh rankings when new data is entered. 4. Dashboard refinements • Fix 8-week trend charts so the latest week appears on the right. • Angle date labels and standardise all chart formatting. • Ensure FY starts from 1st December (accounting year). 5. Data validation & user ease • Dropdowns for dates and engineers. • Error handling for blank rows. • Protect formulas and lock sheets where appropriate. 6. Testing • Run live test scenarios (change data in Input and confirm all KPIs, charts, and rankings update correctly). • Ensure full compatibility on Excel for Mac (no Windows-only VBA). Deliverables • One repaired, working .xlsx file with: • Fully functional Dashboard, Engineer KPIs, and Rankings • Correct and tested formulas • Clean conditional formatting • FY logic (from 1 Dec) • Working 8-week rolling trends