If you are an agile (Scrum) sprint planning wizard, then you know the importance of using a good tracking spreadsheet. So what is a good tracking spreadsheet? Read on to find out!
A typical sprint planning wizard may get started by listing all of the tasks that are in the sprint and where they are scheduled. This can get pretty tedious and boring because it will not be long before you realize that you do not have any complete list of tasks that are in the sprint. You can make this easy for yourself by creating a series of custom spreadsheet and putting all of the tasks into those cells.
Once you have figured out how many sprints are in the plan, you can list out the first five in order. The next five can be put into one cell with no columns, which would make it easier to read the list of tasks in a cell.
How to Create an Effective Sprint Tracking Spreadsheet
Once you have the first five and the next five in one cell, it’s time to create the next set of cells and add them into the basic plan. Make sure that you have enough space on the spreadsheet so that you can add additional rows or columns at some point.
When you have the first five and the next five in one cell, you’ll want to think about the next five, next six, and so on. In the top row of the cells, there should be an initial row that has nothing but a blank cell, right after the first five cells.
Next, you’ll want to create the first row of cells that start with cell’s number one through five. You should create the first row before any of the columns have been created.
To make the space for more columns and rows, it’s time to add some columns. Since the first column already has blank cells, adding the blank cells at the top of the column will go a long way toward making sure that there are enough rows available for more columns.
On the other hand, if you want to create more blank cells, you can do that by moving the first blank cell back to the right side of the columns, to the left of the column heading. Then you’ll need to add blank cells from the column heading down to the first blank cell.
Then add the remaining blank cells up to the top of the last blank cell. Since the spreadsheet will be very short, it’s best to just add one blank cell after another, as if you were creating a line chart.
Once you’ve added the empty cells, start creating the columns. Since the first column already has cells, you can simply add rows to fill the columns as you did with the cells.
This article is meant to help you when it comes to sprint planning. It is not a substitute for a professional plan, but rather a quick and easy guide for creating your own sprint planning spreadsheet. YOU MUST LOOK : agile spreadsheet template