Product Backlog Excel Template
This Template is prepared to manage your product backlog Items with, with below features
- Add your backlog item in excel
- Easy navigation in the form
- Compare Stories
- Measure Story Points with Complexity Bucket
- Measure Story Points Story Point Factors
- Find new Story Points
- Watch the video to get the demo to know it in details
- Manage Epics and Status Master
- Manage Project Master
- Manage Frequent use Projects
|Status||Max 8 Status can be configured|
|EPIC||You can Manage an Epic Master with Epic Name and ID|
|Feature Master||You can Manage Feature Master with Parent Epic ID and Feature ID along with a Feature Name|
|Complexity Bucket||Can Customize complexity Bucket factors.
There are 4 Categories for Complexity Bucket if you are using Complexity Bucket for Story Point Measure.
Measurement of story Points using complexity bucket is just for your Idea, Relative sizing is the best way to measure your story Points.
If you don’t need all the 4 categories, Remove the category heading, for example, you want to work on only 3 categories, remove all the values from Category 4 including the text “Category 4”
If you insert more than permissible sub-item under the category, It will not be reflected in your form.
You can change the name of the category for example “.Net Development” to “Java Development” or Category sub items for example “No of CI” to “No of class” or anything else that matters for you.
If you want to reduce the number of sub items, just simply delete the item from the bottom. For example, if you want to have only 7 sub-items under Category Item, Remove the values at rows 10 and 11 for Columns A and B
Complexity Bucket has max fixed factors.
Max 8 Status for workflow
Watch the video tutorial to know how it works. The Video Tutorial is to target version 1 only
We have not tested it. We believe as this template are using complex formulas and formats. It may create problems in google sheets
Go to Backlog, Select any row where you have Data, Press Ctrl+Shift+M
Inside Project tab
There are two section in the Project Tab, Keep your Most recent projects and all projects separately, so that you have option to select your project from less amount of item list
Under EPIC & Features Tab
Under EPIC & Features Tab
Yes – As Features are child of Epic, All features need a Epic ID, in case you don’t use Epic, Create one Epic for Example “All Epic” with one specific id, and use that Epic Id for all features.
Under Status Tab
Yes-Remove the status from bottom that you don’t Need, Don’t remove the value from Column F under status tab
Yes you can
Its advisable to have the Id unchanged and in a sequence
If you use the Story Point measure using complexity bucket, you can define your sets of complexity here
Complexity Bucket estimation measurement can be done in max 4 category, the rules are also mentioned under the Complexity Bucket – Definition Tab.
Please watch the video from the sidebar
Go to Backlog Tab, select Column A at first empty row at the bottom of all available data. Press “CTRL + SHIFT + S” it will check through all available values and give any missing story id or next possible story id. If your active selected cell already have some value, it will show the new id in a message box instead of inserting into your cell.