Daily Metrics Excel Automation
₹750-1250 INR / hour
Posted 1 minute ago
•
Ends in 6 days
₹750-1250 INR / hour
Every morning I download raw operational data, move columns around, apply look-ups, then copy the results into a master sheet so the team can see the day’s numbers. I want that entire routine turned into a single, push-button Excel workbook. Here’s what the finished file should do each day: • Pull the newest raw file from a designated folder—whether it arrives as .xlsx, .csv, or a system export. • Clean, reformat, and validate the data exactly the way I do it now. • Recalculate my key daily metrics (sales, orders, inventory turns, staffing hours, etc.) and flag any outliers. • Present the refreshed numbers on a clear summary tab that’s ready to print or email. • Archive a time-stamped copy automatically so nothing is lost. Power Query, VBA, dynamic arrays, or a mix of those tools are fine as long as the solution runs in standard Excel without extra licences. Accuracy must match my current manual totals—no rounding surprises. Deliverables 1. Automated workbook with all import, transformation, and reporting logic in place. 2. A brief hand-off guide or short screencast explaining how to refresh and adjust the file in the future. I’ll share sample exports and my existing tracker once we start. Let me know your turnaround time and anything else you need from me so we can get this automation in place quickly.
Project ID: 40817387
About the project
3 proposals
Open for bidding
Remote project
Active 7 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
3 freelancers are bidding on average ₹767 INR/hour for this job


The key challenge is making the automated totals match your existing manual process, not simply importing a file. The workbook needs to handle the latest export consistently, preserve the current lookup and cleanup rules, and make the refreshed daily figures easy to check before they’re shared. I’ll build the refresh around a single button in standard Excel, using VBA for folder-based file selection, import, transformation, validation, and timestamped archiving. The import logic can accommodate the supplied XLSX and CSV examples, with handling for system exports based on their actual format. I’ll keep the calculations transparent in the workbook and preserve calculation precision so display formatting doesn’t create rounding differences. The summary tab will be arranged for printing or email, and outlier flags will follow the rules established from your tracker and examples. Missing or malformed input should produce a clear message rather than silently refreshing incorrect figures. I’ll verify the output against your existing tracker and sample exports, including the daily metrics and edge cases those files reveal. The hand-off guide will explain the refresh steps and where to adjust the folder or workbook logic if the input changes. I’ll keep the workbook organized so the import, calculations, and reporting are straightforward to maintain, and provide the finished file and guide as clean deliverables. Can you provide representative raw exports and the existing tracker, including the manual totals you use to confirm each day’s results?


Your morning routine of downloading the export, moving columns, running look-ups and pasting into the master sheet can become one button in a standard Excel workbook. I would build the import in Power Query so it picks up the newest .xlsx or .csv from your folder, then rebuild your cleaning and validation steps from your sample exports and check the metrics against your manual totals for several past days until they match exactly. A short VBA macro will refresh everything, flag outliers on a printable summary tab and save a time-stamped copy to an archive folder. You also get a brief PDF guide on refreshing the file and adding new columns or metrics. Based in Frankfurt, Germany, I have worked with data processing and text data in research since 2014 (PhD, 30+ publications). Turnaround is 4 days. As a free sample before you decide, I can rebuild the cleaning steps for one of your raw exports. Which Excel version does your team use (Microsoft 365 or an older one like 2016), since dynamic arrays depend on it? Wahed
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗