I have updated the Backlog Manager tool now, it's a bit simplified compared to last time. Changes since previous version:
- It works in Microsoft Excel 2003 now (previously only worked in 2007).
- You may now freely delete and insert rows in the backlog without risking that the list gets screwed up (due to missing formulas and such).
- There are no hidden columns or weird formulas in the Excel.
- The Card Generator no longer uses the ID-column, but instead the Autofilter result, so you can now filter with full flexibility and the Card Generator will generate cards for the visible rows only.
- The New Story dialog is simplied and looks better :-)
- The index card template looks better and is somewhat simplified.
- Some redundant columns were removed (simplify ftw! :-))
I have updated the old post from September last year so it links to the new version of the Backlog Manager tool / Excel instead.
Anyway, you can find it here too:
BacklogManager-v8.xls
Good luck!
Posts
What Is an Advanced Scrum Master?
-
Being a scrum master is more than just reminding a team to perform certain
ceremonies, it's about growing the best possible workplace. To begin with,
let's...
1 week ago
Hi I tried you macro's BacklogManager-v8.xls
ReplyDelete1) When I use SORT....
Run-time error '438':
Object doesn't support this property or method.
ActiveWorkbook.Worksheets("Product backlog").Sort.SortFields.Clear
2) When I use New
The new story is written one row below the first empty row all the time, meaning that that story will then be overwritten by the next new one.
I use:
[Office 2003, Macro language Visual Basic 6.3]
Hey why don't you guys just use http://www.scrumedge.com? It's not that hard to set up and is pretty much like the excel sheets i used to use.
ReplyDeleteFound a bug in the story counting function that caused the New button to work incorrectly as described above by Johan Malm. The new version is uploaded and replaces the old file with the same name.
ReplyDeleteIf you are looking for an Agile Planning tool, have a look at Urban Turtle
ReplyDeleteUrban Turtle is the premier Scrum tool for backlog prioritization, iteration planning, and task monitoring. It allows TFS development teams to work with Agile. http://urbanturtle.com
just linked this article on my facebook account. it’s a very interesting article for all.
ReplyDeleteScrum Process