Friday, January 23, 2009

Updated backlog manager tool in Excel

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:

Good luck!


  1. Hi I tried you macro's BacklogManager-v8.xls

    1) 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]

  2. Hey why don't you guys just use It's not that hard to set up and is pretty much like the excel sheets i used to use.

  3. Found 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.

  4. If you are looking for an Agile Planning tool, have a look at Urban Turtle
    Urban Turtle is the premier Scrum tool for backlog prioritization, iteration planning, and task monitoring. It allows TFS development teams to work with Agile.

  5. just linked this article on my facebook account. it’s a very interesting article for all.

    Scrum Process

  6. "Nice post!
    We usually don’t find a full time scrum master. Scrum master is described by scrum guide as one who teaches, facilitates and removes impediments. When the team is relatively new it takes time and the team follows scrum religiously. This is when the team needs a scrum master who can teach scrum full time. Certification"

  7. Hi i think a PMP certification is very recognized these days, and if you have the capabality you should try to aim for a PMP certification. There are also a lot of useful resources on the web; most of which are free..One of the useful resource is avaialable http://www.pmstudy.comThe PMP Certification

  8. the needed details should set up your brand-new account, like your initial Click Here and also last name, date of birth, Username, Snapchat Android Updated Version Download & Install E-mail address, produce your password, Snapchat App mobile number.Snapchat will immediately connect you to all Snapchat Download your get in touches with who get on Snapchat.

  9. if your requirements don't match or Kodi Download App this media center is not competing any other reason, check this site you could use an alternating method to utilize it on Kodi your precious computer.To download as well as make use of Kodi on PC, you should download any Android Emulator.

  10. COEPD LLC- Center of Excellence for Professional Development is the most trusted online training platform to global participants. We are primarily a community of Business Analysts who have taken the initiative to facilitate professionals of IT or Non IT background with the finest quality training. Our trainings are delivered through interactive mode with illustrative scenarios, activities and case studies to help learners start a successful career. We impart knowledge keeping in view of the challenging situations individuals will face in the real time, so that they can handle their job deliverables with at most confidence.