Kanban Board Sprint Start Date
8/10/2020
Type Role Feature or Activity Reason
😴 Backlog
Customize Headings and Card
Update Team Edit the Legend in the Type column as needed.
Types
The backlog is where you stick the to-dos that
Research All Add ideas to the backlog you might work on later.
User Story: As a [Role] I want [Feature] so that
Feature Who For Be specific [Reason]
Articles, White Papers,
Content
Documentation
😐 To Do This Sprint
To decide what you are going to work on during
Task All Move Backlog cards here this sprint.
Decide how much we can get The total estimated Pts cannot be higher than
Task All
X, based on past performance.
done
😃 In Progress
Move tasks between lanes to Google Sheets: select the row # and drag it with
Update All
the hand cursor.
track completion
😅 Test / Verify
Take joy in accomplishment, Don't be afraid to
Update All Test and Refine scrap what isn't working.
Task All Is the Process Helping? Don't add unnecessary work.
😎 Done
Moving stuff to DONE deserves a high five or
Research All Congratulations fist bump.
Total This Sprint
TYPE LEGEND
Feature
Content
Update
Task
Research
Days Progress
14 25.0% ⚑⚑⚑⚑⚐⚐⚐⚐⚐⚐⚐⚐⚐⚐
Priority Pts Hrs Details
Look at the conditional formatting rules to see how the color-coding
Low 5
works.
Some ideas may not lead to deliverables, but time may need to be
High 2
allocated to researching them.
High 6
We use the Content type for writing blog posts, preparing marketing
Medium 3
materials, and support content.
6.0 0.0
0.0 0.0
0.0 0.0
Make sure that challenges are worth trying to overcome, so that you don't
waste time on useless stuff.
2 0
High 2
8.0 0.0
PRIORITY LEGEND
Kanban Board Template © 2017 Vertex42.com
https://www.vertex42.com/ExcelTemplates/agile-kanban-board.html
High
Medium
Low
PROGRESS CALCULATIONS
Progress: 25.00% ⚑⚑⚑⚑⚐⚐⚐⚐⚐⚐⚐⚐⚐⚐
Complete: 4
Time: 14
Sprint Record Book
Sprint Start Date Sprint Days Pts Planned Pts Done Velocity
8/10/2020 8 48 24 3
-
-
-
-
-
-
-
-
-
-
-
-
Most Notable Achievements
HELP © 2017 Vertex42.com
https://www.vertex42.com/ExcelTemplates/agile-kanban-board.html
Copyright &modifications
Terms of Use (Limited
of this Private
template to any Sharing)
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
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
Just insert Cards
a new row /below
Tasksor 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
Select the row,to new
then Lanes
drag and drop the row by dragging the row number (the row number on the far left of the
spreadsheet).
Show/Hide rows and selecting Hide Rows. Google Sheets will display up/down arrows when rows are hidden,
on the row numbers,
so to show them, click on the arrows.
After Each Sprint
2) Create a copy of this spreadsheet and rename the copy based on the date of the sprint (e.g. "Sprint - 2017 11
1) Update
27") the RecordBook
and store worksheet
the copy in an archived with theYou
folder. results
couldof duplicate
the sprint.the Kanban worksheet instead and rename the
duplicate
3) Begin atonew
store previous
sprint sprints within
by removing the same
the tasks in the workbook.
Done section and adding, moving and reprioritizing the tasks
that you will focus on for the next sprint.
When sharing the spreadsheet with somebody else, share it with a specific email address only (i.e. an email
IMPORTANTassociated
note aboutwithFile Sharing
a Google via Google
Account). Sheets
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
Share the following link to vertex42.com via email, facebook, linkedin, etc. You may share this spreadsheet among
Like this Template?
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
