Enhance Excel Gantt with Key Functions
Budget: €30 – €250 EUR
I require an Excel expert to make significant enhancements to my licensed "ultimate gantt chart" for better project management:
1. Add Task Dependencies: is working
2. Resource Allocation: is working.
3. Progress Tracking: is working
4. Timeframe Selection: Include a button to toggle between day, week, month, year view. This should change both the view and the tasks list, displaying the relevant tasks in the selected timeframe.
4a. Timeframe selection. must work dynamic to year as well. So month and the numbers of days is relation to the year.
5. Critical Path Indicator: Please highlight tasks on the critical path in a distinct color to help quickly identify crucial tasks that directly influence the project's completion time.
Ideal candidates will have strong experience in Excel VBA and project management methodologies, particularly Gantt charts. This project requires a keen eye for usability and detail-oriented mindset.
6. manual step by step.
7. a srceen tutorial showing the function in use. e.i.
1. Add Task Dependencies: is working
2. Resource Allocation: is working.
3. Progress Tracking: is working
4. Timeframe Selection: Include a button to toggle between day, week, month, year view. This should change both the view and the tasks list, displaying the relevant tasks in the selected timeframe.
4a. Timeframe selection. must work dynamic to year as well. So month and the numbers of days is relation to the year.
5. Critical Path Indicator: Please highlight tasks on the critical path in a distinct color to help quickly identify crucial tasks that directly influence the project's completion time.
Ideal candidates will have strong experience in Excel VBA and project management methodologies, particularly Gantt charts. This project requires a keen eye for usability and detail-oriented mindset.
6. manual step by step.
7. a srceen tutorial showing the function in use. e.i.