CAVU’s Sprint Planning Toolkit


Sprint Planning is pivotal for team success and project progress. Today, I’ll walk you through how to leverage our free Sprint Planning Toolkit to optimize your team’s performance and ensure that your sprints are set up for success. The toolkit is designed to help Agile teams, like the CAVU’s Development Team (CAA), streamline their Sprint Planning process, making it more efficient and effective.

Introduction to the Toolkit

The Sprint Planning Toolkit is an Excel-based solution containing critical components for planning and executing sprints. Upon opening your toolkit directory, you’ll find, among other things, an Excel spreadsheet titled “Sprint Planning,” this is the core of the toolkit and a powerful tool in your planning arsenal.

The Sprint Planning toolkit comprises two main tabs:

  • Velocity and Planning Data: This section offers a historical view of your team’s velocity, showcasing planned completions (blue line), extra value earned during the Sprint (green line), and any interruptions (red line) encountered.
  • Team Capacity Data: Here, you delve into your team’s capacity, understanding how many person-days are available and planning accordingly.
Sprint Planning Calculator

Setting Up Your Sprint

  1. Entering Team and Sprint Information: Start by entering your team’s name. For instance, “A Team”. Next, input the current sprint number; for example, if you’re on sprint 51, that’s what you’ll note.
  1. Adjusting Charts: The toolkit allows you to alter the starting Sprint for calculations affecting the charts, providing flexibility in tracking and planning.
  1. Planning New Sprints: When transitioning to a new Sprint, simply update the Sprint number, which, for our example, would change from 51 to 52, signifying the move to the next Sprint.
  2. Tracking: At the end of each Sprint, you’ll enter the following information into the proper row on the spreadsheet
    1. Planned Complete: How many Story Points did you complete that were committed to at the end of your previous Sprint planning.
    2. Interrupts: How many points of interrupt did your team complete during your Sprint
    3. Extra Value: How many points did your team complete in the Sprint as a result of completing work early

Utilizing Capacity and Planning Data

Team Capacity tracking for use in the Sprint Planning Toolkit
  • Understanding Team Capacity: Calculate your team’s total capacity in person-days, considering each member’s availability. Adjust for any days off, ensuring accurate capacity calculations for the Sprint. You can do this by simply entering the days that each team member will be working during the Sprint on the Team Capacity tab.
  • Allocating Sprint Capacity: Based on past data and current Team Capacity, the toolkit suggests an interrupt buffer and points to bring into the Sprint. It assists in making informed decisions about workload and sprint commitments.
How to setup the Sprint Planning Toolkit
  • Reviewing Calculations: The toolkit includes calculations on the right-hand side, offering insights like points per person-day and interrupt buffer size. These figures help in refining Sprint Planning, although they’re not frequently adjusted.

The Importance of Charts and Data Entry

  • Charting Progress: The toolkit visualizes your Sprint Planning and historical performance, offering a clear picture of trends, achievements, and areas for improvement.
  • Data Entry for Sprint Review: Enter actuals such as planned completion, interrupts, and extra value at the end of each Sprint. This practice keeps your historical data up-to-date, providing a solid foundation for future planning.

Other Tools

In addition to the Sprint Planning Toolkit spreadsheet, CAVU provides two invaluable PDF resources to further enhance your team’s Sprint Planning effectiveness. Let’s delve into how these resources can complement your Sprint Planning process.

Potential Problems and Coaching Advice

One of the PDFs serves as a quick guide to common problems you might encounter during Sprint Planning, complete with coaching advice. This guide is crucial for Scrum Masters and Agile Coaches to preemptively identify potential issues and strategize solutions, ensuring a smoother Sprint Planning session. By leveraging this guide, you can foster a more resilient and Agile team, capable of navigating the complexities of Sprint Planning with ease and efficiency.

Schedule and Assessment Rubric

The second PDF focuses on providing a schedule and an assessment rubric to help you assess your current team’s state effectively. This resource is particularly beneficial for Agile teams looking to refine their processes and improve sprint outcomes. The schedule aids in planning sprint activities more systematically, while the assessment rubric offers a structured approach to evaluating the team’s performance and identifying areas for improvement.

Final Thoughts

Effective sprint planning is an art refined through practice, and the CAVU Sprint Planning Toolkit is designed to support this process. By accurately entering and reviewing your team’s data, you can enhance your Sprint Planning, leading to more successful and predictable sprint outcomes.

Remember, Agile is about adaptability and continuous improvement. Use this toolkit to its fullest, but also remain open to adjustments based on your team’s unique experiences and challenges. Happy Sprinting!

Download the Sprint Planning Toolkit

Better Plans Lead to Better Outcomes.

You have the training.
Now you need the job.

Unlock your potential with our new course: ‘How to Build an Agile Resume’. Dive into impactful lessons, gain exclusive insights, and join our Launch Party!


Leave a Reply

Related Posts

Reflect and Adjust: A Key Agile Principle for Continuous Improvement

Continuing our series on the Principles of the Agile Manifesto, let’s delve into a principle that emphasizes the importance of

July 15, 2024
McCaul Baggett

The Role of the Product Owner in the Daily Scrum

The Daily Scrum is a cornerstone of the Scrum framework, designed to synchronize the team’s activities and plan for the

July 10, 2024
McCaul Baggett

Self-Organizing Teams

As we continue to examine the Principles of the Agile Manifesto, we now look at the principle of “The best

July 8, 2024
Corey Stewart

The Art of Simplicity: Maximizing Work Not Done in Agile

As we progress through our series on the Principles of the Agile Manifesto, we now turn our attention to “Simplicity—the

July 2, 2024
Corey Stewart

How Continuous Attention to Technical Excellence and Good Design Enhances Agility

As we continue our exploration of the principles of the Agile Manifesto, we turn our focus to a core tenet

July 1, 2024
Corey Stewart

The Value of Scrum Masters

Alright, gather ’round, you wide-eyed Agile novices and seasoned skeptics alike. It’s time for another rant. Today, we dive into

June 28, 2024
The Agile Curmudgeon

Elevate Your Agility

Join our free weekly coaching tips
Unlock your potential with free, bite-sized Agile training and coaching delivered straight to your inbox. Learn from leaders with practical experience in Agility.