Streamline Your Backlog: Unleashing Efficiency with This Template for Seamless Product Management
Exclusive offer for Academy Members
PRODUCT BACKLOG EXCEL TEMPLATE
![Product-Backlog](https://academyassets.agiledigest.com/wp-content/uploads/2023/11/23174415/Product-Backlog_2.jpg)
How to Apply
Eligibility
Minimum 2 Months of Membership age
Process
- Meet the Eligibility Criteria
- Apply for coupon code by filling out the Form
- Admin Validation
- Receive the Coupon Code
- Purchase from the Purchase link by applying the coupon code
- Download the 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
Configuration |
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 |
Limitations
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
– Is this Template work in Google Sheets
We have not tested it. We believe as this template are using complex formulas and formats. It may create problems in google sheets
How to invoke the form
Go to Backlog, Select any row where you have Data, Press Ctrl+Shift+M
In case of issues where to get support
email at [email protected]
Where to update list of my Projects
Inside Project tab
Why there are two list of Projects
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
Where to Update list of Epics
Under EPIC & Features Tab
Where to Update List of Features
Under EPIC & Features Tab
Does Epic Id is mandatory for Feature list
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.
Where can I customize the Status ?
Under Status Tab
Can I have More than 8 Status ?
No
Can I have Less than 8 Status
Yes-Remove the status from bottom that you don’t Need, Don’t remove the value from Column F under status tab
Can I change the Status Name
Yes you can
Can I change the status Id
Its advisable to have the Id unchanged and in a sequence
What is Complexity Bucket – Definition Tab
If you use the Story Point measure using complexity bucket, you can define your sets of complexity here
Please explain more about the Complexity Bucket
Complexity Bucket estimation measurement can be done in max 4 category, the rules are also mentioned under the Complexity Bucket – Definition Tab.
Where Can I get a Demo of this backlog how it works
Please watch the video from the sidebar
How to find a new available Story id
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.
If I need some customization, How can I Get that
Please write to [email protected]
PRODUCT BACKLOG EXCEL TEMPLATE
Explore the Screenshots
Apply for Coupon Code
Seems like You have not logged in yet, Please log in or sign up