Daily Operational Metrics Excel Automation
₹750-1250 INR / hour
Posted 1 minute ago
•
Ends in 6 days
₹750-1250 INR / hour
The goal is to turn a manually-updated Excel workbook into a self-updating dashboard that highlights our key operational performance metrics every single day. All data will be typed directly into predefined sheets, and from there the file should: • Capture new rows automatically through dynamic ranges, tables, Power Query, or VBA—whatever keeps it rock-solid and easy for non-technical staff. • Recalculate KPIs and refresh charts the moment the workbook opens or on demand with a simple button. • Present the results in a clean summary sheet: quick-glance numbers, traffic-light indicators, and interactive charts that drill down when needed. Deliverables 1. An Excel template with protected formulas, clearly labeled input areas, and an intuitive dashboard. 2. Refresh logic (macro, Power Query steps, or both) documented inside the file so future edits are straightforward. 3. A brief walkthrough video or PDF that shows how to add new data and trigger the daily update. Everything must reside in standard Excel—no external add-ins—so the file can be emailed and used anywhere Office 2016+ is installed. Once delivered, I’ll test it with a week of sample entries; the project is complete when the dashboard updates flawlessly without extra tweaks.
Project ID: 40814404
About the project
2 proposals
Open for bidding
Remote project
Active 27 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
2 freelancers are bidding on average ₹775 INR/hour for this job


Hello, "Self-Updating Excel Operations Dashboard" - your team needs to enter daily figures once and have KPIs, traffic-light indicators, and charts update without manual rebuilding. I'll structure the workbook with Excel Tables for expanding input ranges, protected KPI formulas, and a clear dashboard with a refresh button. I'll keep it compatible with Office 2016+, document the refresh process, and include a walkthrough. One important detail is handling blank or incomplete daily entries so they do not distort totals or trigger misleading performance indicators. Are you able to share the current workbook or a sample of the input sheets and KPIs you want displayed? Looking forward to working with you. Aleksandar


Your daily metrics workbook should update itself once staff type in new rows, and the file has to keep working when it is emailed to someone on Office 2016. I would turn each input sheet into an Excel table, so new rows feed the KPI formulas and pivot charts with no range edits. On top of that comes a summary sheet with headline numbers, traffic-light conditional formatting and slicer-driven charts that drill down by date or category. A small VBA macro refreshes everything when the file opens, and a Refresh button does the same on demand. Formulas are protected, input cells are colour-coded, and a Notes sheet inside the file explains the refresh logic. You also get a short PDF walkthrough with screenshots. Based in Frankfurt, Germany, I have worked with data processing since 2014 (PhD, 30+ publications). If you send a few anonymised sample rows, I will build a free mock-up of one KPI tile with its traffic light before you award the project. Which KPIs do you need, and what thresholds should turn each one red, amber or green? Wahed
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗