Excel Macro for Production Log & Summaries
Budget: $30 – $250 USD
I need someone skilled in Microsoft Excel, particularly with creating automated systems using formulas and macros, to design an editable daily production log for my team. This individual should have experience working with an array of Microsoft Excel functions and formulas and compiling that data to create extensive, detailed reports.
Key requirements include:
- Designing an Excel sheet that is editable by all team members
- Using formulas and macros, creating a system that generates a daily master team summary report
- The master report should calculate and include total team output, individual team member's output, counts of specific tasks, hours worked, and necessary statistics such as charts completed and pages completed
- An automated system that updates the data daily and collates this data for weekly and monthly report generation as well.
The ideal candidate should have demonstrable experience in similar projects or tasks. Strong analytical skills and problem-solving capability will be essential for this job.
Please see the attachments for an idea of what kind of production log I am looking for. The idea is to have individual members fill out this daily log to record their daily activities and have this data exported into a separate master summary report that shows daily, weekly, and monthly statistics.
Key requirements include:
- Designing an Excel sheet that is editable by all team members
- Using formulas and macros, creating a system that generates a daily master team summary report
- The master report should calculate and include total team output, individual team member's output, counts of specific tasks, hours worked, and necessary statistics such as charts completed and pages completed
- An automated system that updates the data daily and collates this data for weekly and monthly report generation as well.
The ideal candidate should have demonstrable experience in similar projects or tasks. Strong analytical skills and problem-solving capability will be essential for this job.
Please see the attachments for an idea of what kind of production log I am looking for. The idea is to have individual members fill out this daily log to record their daily activities and have this data exported into a separate master summary report that shows daily, weekly, and monthly statistics.