Capacity: Help with Excel

For every Sprint Planning the capacity, the hours available for the team is an important ingredient. Usually, this is rather straight forward and easy to do. At my current project we have two teams. Each team is cross-functional, i.e. being able to deliver a piece of done software. However, in this case, the skills are very different, so that the overall number of available hours can be deceptive as there might be 120 h of development tasks and only 80 h available. We actually run into this problem when we got additional business analysts. The overall capacity went up so that we could commit to more user stories. As a result, we had far too much programming work and not enough analysis work.

Now, we break the capacity down per skills we need in our teams. Once Sprint Planning Two is over, we add up the hours per skill and see if we are still in the range. If yes – great! Otherwise the Dev Team and Product Owner self-organize and figure out a way to handle it.
Long story short – here is the link to the Excel sheet. It is not fancy but does a great job for the current project.
Enjoy!

About Effective Agile

Ralph Jocham is a Change Agent in Scrum // Agile // Coaching // Evidence Based Management and also a Professional Scrum Trainer based in Europe.

As one of the first Professional Scrum Trainers in the world, Ralph has worked directly with cocreator of #scrum, Ken Schwaber, and has played an integral part in the course development of the #PSPO (Professional Scrum Product Owner) as well as the delivery of all #scrum.org certified courses.

If you’re looking to invest in training that transforms and empowers teams to successfully adopt #scrum or #agile, and create high-performance #productdevelopment environments leveraging the agile values and principles, visit our Professional Scrum Training page.

If you would like to work with Ralph and company as an #agilecoach, #agileconsultant, or powerful change agent to get your team back on track and on the road to high-performance #agile #productdevelopment, connect with Ralph Jocham.

For more great ‘how-to’ videos, blogs, and insights, subscribe to our YouTube channel and visit our blog for more valuable content.

#scrum #agile #scrumorg #scrumcertification #scrumcourses #scrumtraining #agilescrumtraining #agilekata #agility #businessagility #agileprojectmanagement #projectmanagement #productdevelopment #agileproductdevelopment #switzerland #germany #europe #scrumteam #scrumframework #professionalscrumtrainer #PST #certifiedscrumtrainer #certifiedscrumtraining

Latest Short Videos