Details

need an Excel expert to build a workbook that analyses production data from raw monitoring data. You'll need to clean a CSV data, create automated calculations, and deliver a user-friendly dashboard. **Key Tasks:** ✔️ Clean & prep production data ✔️ Build formulas to calculate: - Equipment uptime/downtime (I will provide guidance) - Daily & monthly metrics ✔️ Design an optimised Excel workbook ✔️ (Bonus) Create visual dashboards **Skills Needed:** ⭐ **Must-have:** - Advanced Excel (INDEX/MATCH, SUMIFS, array formulas) - Data cleaning & transformation skills - Experience with large datasets ⭐ **Nice-to-have:** - Basic VBA knowledge - Experience with production/equipment data **Project Challenges:** ⚠️ Inconsistent data ⚠️ Complex calculation logic **Deliverables:** 📄 Clean, functional Excel workbook 📄 Documentation of methods used 📄 (Optional) Summary report with visuals Not sure how to price this task, I’m open for suggestions whether an hourly rate or a lump sum, please submit your offer and indicate your preferred option. Looking forward to your proposals!