Sprint Start Date Days Progress
Kanban Board 12/4/2017 14 43.5% ⚑⚑⚑⚑⚑⚑⚐⚐⚐⚐⚐⚐⚐⚐⌛🏁
Type Who / Role [1] Feature or Activity Reason Priority Pts [2] Hrs [3] Details
😴 Backlog
The backlog is where you stick the to-dos Some ideas may not lead to deliverables, but time may need to
Research All Add ideas to the backlog Low 2
that you might work on later. be allocated to researching them.
User Story: As a [Role] I want [Feature]
Feature Be specific High 6
so that [Reason]
Articles, White Papers, We use the Content type for writing blog posts, preparing
Content Medium 3
Documentation marketing materials, and support content.
^ Hide backlog items above this row
^
{42}
😐 To Do 6.5 0.0
Customize Headings and Edit the Legend in the Type column as Look at the conditional formatting rules to see how the color-
Update Low 0.5
Card Types needed. coding works.
To decide what you are going to work on
Task All Move Backlog cards here 3
during this sprint.
Decide how much we can The total estimated Pts cannot be higher
Task All 3
get done than X, based on past performance.
😃 In Progress 0.0 0.0
Move tasks between lanes Google Sheets: select the row # and
Update All
to track completion drag it with the hand cursor.
😅 Test / Verify 0.0 0.0 © 2017 Vertex42.com
Take joy in accomplishment, Don't be Make sure that challenges are worth trying to overcome, so that
Update Test and Refine afraid to scrap what isn't working. you don't waste time on useless stuff.
Task All Is the Process Helping? Don't add unnecessary work.
😎 Done 5 0
Moving stuff to DONE deserves a high
Task All Congratulations High 5
five or fist bump.
Total This Sprint 11.5 0.0
TYPE SPRINT CHART
PRIORITY LEGEND
LEGEND LEGEND Kanban Board Template © 2017 Vertex42.com
https://www.vertex42.com/ExcelTemplates/agile-kanban-board.html
Feature ⚐ days in sprint High
Content ⚑ progress Medium
Update ⌛ current day Low
[42]
Task 🏁 finish / end
Research
PROGRESS CALCULATIONS
Progress: 43.48% ⚑⚑⚑⚑⚑⚑⚐⚐⚐⚐⚐⚐⚐⚐⌛🏁
Complete: 6
Time: 14
Summary
Who / Role Pts (Not Done) Pts (Done)
All 6 5
Name 1 0 0
Name 2 0 0
Name 3 0 0
Name 4 0 0
Name 5 0 0
Name 6 0 0
Name 7 0 0
0 0
0 0
0 0
0 0
0 0
Sprint Record Book
Sprint Start Date Sprint Days Pts Planned Pts Done Velocity Most Notable Achievements
11/27/2017 8 48 24 3
-
-
-
-
-
-
-
-
-
-
-
-
HELP © 2017 Vertex42.com
https://www.vertex42.com/ExcelTemplates/agile-kanban-board.html
Copyright & Terms of Use (Limited Private Sharing)
This spreadsheet, including all worksheets and associated content is copyrighted. Do not submit
copies or modifications of this template to any website or online template gallery. Please review the
following license agreement to learn how you may or may not use this template. Thank you.
License Agreement
https://www.vertex42.com/licensing/EULA_privateuse.html
About This Template
This worksheet was designed as an online collaborative Kanban board for use in Agile Project
Management where the team members may be working remotely. Instead of columns for Backlog,
To Do, In Progress, Testing, and Done, the spreadsheet uses horizontal lanes. Rows within the
worksheet represent cards or sticky notes. Create new "cards" by inserting rows. Move cards
between lanes by dragging and dropping the entire row.
Create New Cards / Tasks
Just insert a new row below or above an existing card or task. Note: In Google Sheets, when you
insert a row above or below the selected line, the formatting in the newly inserted row is based on
the row you have selected.
Move Cards to new Lanes
Select the row, then drag and drop the row by dragging the row number (the row number on the far
left of the spreadsheet).
Show/Hide rows
You'll probably want to show/hide the rows in the Backlog. You can do that by just selecting the
rows, right-clicking on the row numbers, and selecting Hide Rows. Google Sheets will display
up/down arrows when rows are hidden, so to show them, click on the arrows.
Sprint Progress Chart
The progress bar at the top of the worksheet is called a "sprint progress chart" and represents the
number of days in the sprint. Filled-in flags represent the progress in terms of % complete and the
hourglass shows what day it is.
Summary Worksheet
The Summary worksheet tab can be used for (1) editing the list of names or roles that show up in
the drop-down data validation lists and (2) summarizing the number of points currently assigned to
each person or role.
After Each Sprint
1) Update the RecordBook worksheet with the results of the sprint.
2) Create a copy of this spreadsheet and rename the copy based on the date of the sprint (e.g.
"Sprint - 2017 11 27") and store the copy in an archived folder. You could duplicate the Kanban
worksheet instead and rename the duplicate to store previous sprints within the same workbook.
3) Begin a new sprint by removing the tasks in the Done section and adding, moving and
reprioritizing the tasks that you will focus on for the next sprint.
IMPORTANT note about File Sharing via Google Sheets
When sharing the spreadsheet with somebody else, share it with a specific email address only (i.e.
an email associated with a Google Account). Using the "Public on the web" or "Anyone with the link"
option can comprise the security of your information and will also be a violation of the terms of use
for this template.
Do not use the "Public on the Web" option
Do not use the "Anyone with the link" option
Like this Template?
Share the following link to vertex42.com via email, facebook, linkedin, etc. You may share this
spreadsheet among your team members and management, but to recommend the template to
people outside your company, please only share the link to vertex42.com, not the actual
spreadsheet. Thank you!
https://www.vertex42.com/ExcelTemplates/agile-kanban-board.html
[1] This can be a person responsible for the task or the role for describing the user story.
USER STORY: As a [role], I want [feature] so that [reason].
[2] Estimated Effort Points:
Enter the estimated effort, in terms of points or hours, that you have budgeted or allocated to this task.
[3] Actual Hours:
You can use this column to keep track of the actual time spent on a task.
