Excel-Driven Automatic Gantt Chart Development
Budget: $30 – $250 USD
I'm looking for an expert in Excel who can help me create an automatic Gantt chart. This chart needs to be designed in a way that it takes inputs in terms of task name, team member name, and start and end dates, then translates into a yearly calendar view for over 80 of my team members. The key details to be displayed for each task on the Gantt chart include:
- Estimated time to completion
- Name of task
- Visualization of duration and utilization
For each team member
The chosen freelancer should have a strong experience in handling complex formatting and data visualization in Excel. The goal is to have a system that simplifies the process of tracking and assigning tasks, monitoring the progress, and ensuring the effective utilization of resources. Your proficiency in Excel should be demonstrated by previous, similar projects. While knowledge about project management would be an added advantage, it is not a necessity. This Gantt chart needs to automatically update with changes in inputs, hence having skills in creating dynamic Excel sheets is crucial.
- Estimated time to completion
- Name of task
- Visualization of duration and utilization
For each team member
The chosen freelancer should have a strong experience in handling complex formatting and data visualization in Excel. The goal is to have a system that simplifies the process of tracking and assigning tasks, monitoring the progress, and ensuring the effective utilization of resources. Your proficiency in Excel should be demonstrated by previous, similar projects. While knowledge about project management would be an added advantage, it is not a necessity. This Gantt chart needs to automatically update with changes in inputs, hence having skills in creating dynamic Excel sheets is crucial.