Saturday, September 17, 2011

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.



Rafael Gorski said...

Hi Ralph,

A minor change in your spread sheet, the cells D20 and D27 is not summing the BA values.

Rafael Gorski

Ralph Jocham said...

Hi Rafael - thanks for your input. I checked it and it does look ok to me

weddingca said...

Thanks for sharing this with all of us. Every girl has her most beautiful moment in the life just when you wear your own wedding dresses in your wedding.You can visit our wedding dress shop.Cheap wedding dresses have good quality. You can find ball gown wedding dresses,mother of the bride dresses,mermaid wedding dresses,flower girl dresses,strapless wedding dresses,a line wedding dresses,plus size wedding dresses,column wedding dresses,beach wedding dresses,empire wedding dresses,tea length wedding dresses,bridesmaid dresses,cocktail dresses,evening dresses,prom dresses your dream. Get your wedding dress in our bridal shop. Finally,I hope you have a happy wedding.