fbpx

Sprint Planning Template

Brief

Download your Sprint Planning Tool

Please note that the use of the free version for commercial/ corporate purposes violates our terms of use. This version of the tool is only intended for personal purposes. For corporate use of this tool, kindly refer to our commercial version.

        Agile is an iterative and highly flexible methodology that allows teams to easily identify and adapt to new challenges, resulting on better outcomes at a faster speed. For those beginning to experience the Agile way, it can be beneficial to study The Scrum Guide. Despite the flexibility that comes from Agile, some level of planning is required and having a sprint planning excel tool can be the differentiator that allows the individual and team to operate more efficiently. This free and customizable Sprint Planning tool features:

1. Dashboard Tab Overview

  • Percentage of sprint completed.
  • Allocation of tasks based on categories.
  • Sprint duration.
  • Total items placed in backlog.
  • Buttons for easy navigation in between tabs (Current Sprint and Backlog).

2. Sprint Tracker Tab

Sprint database for the Sprint Planning tool
  • Item ID
  • Project/ Category
  • Task [Description]
  • Priority (Low, Medium, and High)
  • Effort Estimated [for completion (Story points often based on the Fibonacci sequence)]
  • Actual Effort [Optional]
  • Status (Not Completed, In Progress, and Completed)
  • Buttons for easy navigation (Back to dashboard and backlog)
  • Slicers for ‘Owner’, ‘Status’ and ‘Project/Category’ to help navigate specific segments of the data.

How To Use and Customize Your Sprint Planning Tool?

For the sake of simplicity, we have prepared a “How to” guide to help you navigate through the use of this tool and customize all labels and tabs to your needs.

Once you download the tool, you will receive a blank version ready to be populated and customized accordingly to your sprint. It should look like the following:

1. Insert your name and sprint number: Click on cell B2 and insert your name or your company’s name, then click on cell C3 and insert the number of your current sprint.

2. Insert the start and end date of your sprint, the sprint duration will change automatically.

Now, after you browse around the tool, we believe it’s best to set up the legend before you start inputting your items.

3. Click on the “Legend” worksheet. Once in the “Legend”, do not change anything else besides items 4 and 5, otherwise you may run the risk of “breaking” other features within the worksheet.

4. Start populating the categories that are relevant to your future tasks such as (answering e-mails, budgeting, etc.). Currently, you can populate 5 categories by just replacing the items that have been pre-populated for you. To populate extra items, right click in one of the categories, click on “insert”, then click on “table rows above” (image below).

5. Populate the members of your team by substituting the pre-populated fields. In case you need more fields for members, repeat the step above to insert rows. It is important to follow this step to add a row to the table, otherwise other features within your excel will not work.

In case you are using this tool for personal purposes and do not need extra members, just delete the additional members by selecting the cells you would like deleted, right clicking on the selected cells, press “delete”, then “delete table rows”.

Now, you are ready to start populating your tasks within your Sprint Planning Tool. Click on the button “Current Sprint” and start populating the table with the items you would like to track.

In case you wish to add more items to your list, follow the explanation given earlier.

Under task, you can add your first item, then choose the project category from one of the categories you have previously inserted in the Legend tab. All that you need to do is simply click on the cell and choose from the drop down menu (for example, if you click on cell C8, you will see a small arrow beside the cell in which you can click and he drop down menu will show). Then, you can choose the priority level, the owner, and the status by following the same actions.

Note that other functionalities of your worksheet are buttons and slicers:

  • Buttons: click on such buttons to easily navigate from sheet to sheet
  • Slicers: once you have populated your items, you could for instance click on the “Owner” slicer to choose to visualize only the items owner by Person A. Whenever you want to go back to your normal view, just press on the x on the bottom right corner of the slicer.

The Effort Estimated portions is designed to follow Story Points based on Fibonacci sequence, according to some sprint planning exercises in Agile. However, you may feel free to use minutes or hours instead.

The Backlog tab can be filled very much in the same way as the “Current Sprint” tab and it also features buttons and trackers.

We hope this tool helps you and your team to become more agility driven, which in turn will lead to increased productivity! To gain further insight regarding Agile transformation, please refer to McKinsey and Harvard Business Review material. If you have any questions, concerns, or feedback, shout us an e-mail at [email protected].

Our Latest Posts

RASCI Template

RASCI Template Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                The RASCI matrix is a visual business tool used to define the connection between members and their

Read More »

Communication Plan Template

Communication Plan Template Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                Communication helps instill important information between different parties, helping to build relations, drive collaboration and much

Read More »

Team Charter Template

Team Charter Template Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                Team charters can help teams, projects and organizations build the rules of engagement and roadmap needed

Read More »

Check Register Template

Check Register Template Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                Financial transactions have existed throughout history, helping buyers and sellers exchange goods based on their needs.

Read More »

Employee Training Tracker

Employee Training Tracker Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                Training is a great way to learn or hone the skills relevant to one’s professional career

Read More »

Bi-Weekly Budget Tool

Bi-Weekly Budget Tool Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                There are many cases where employees or contractors are paid bi-weekly for their effort. To some,

Read More »
Receive a monthly newsletter with updates, insights and solutions from GPetrium!