Dynamic Team Capacity Planner in Excel

Job ID: 39638496

Budget: $10 – $30 USD

I'm looking for an experienced Excel professional to help debug and refine a dynamic Team Capacity Planner tailored for distributed virtual Scrum teams. This tool is critical for accurately planning and visualizing capacity across sprints.

Key Features Required:
• Interactive dashboard for clear capacity breakdown
• Automated adjustments for location-specific holidays
• Real-time insights into:
• Team velocity trends
• Individual availability
• Role-based workload distribution (Developers, Testers, Engineers)

Existing Data to Incorporate:
• Individual team member availability
• Location-specific holidays

Ideal Skills and Experience:
• Advanced Excel proficiency
• Experience with dynamic dashboards
• Knowledge of Scrum and team capacity planning
• Strong data visualization skills