Index card generator - version 2!
An excel-only index card generator for Scrum product backlogs
Many people use a spreadsheet to house their Scrum Product Backlog. That works quite fine. However, during sprint planning meetings it is usually much more effective to use physical index cards. See my book Scrum and XP from the Trenches for the reasoning behind this.
Here's a simple tool that generates printable index cards in A5 format directly from your Excel-based product backlog. Thanks Stefan Nijenhuis for making this available!
There is nothing to install. This is simply an Excel document containing a product backlog and a "generate index cards" button.
For more info, see the readme inside the document.
This version requires only Microsoft Excel. The previous version required both Excel and Access.
Update (2008-01-04)
Here's another excel-based index card generator from Claudio Gambetti. Contains a few extra features such as tracks (a.k.a. themes) and components, as mentioned in my book. You choose your flavor. Thanks for contributing this Claudio!
Here's a simple tool that generates printable index cards in A5 format directly from your Excel-based product backlog. Thanks Stefan Nijenhuis for making this available!
There is nothing to install. This is simply an Excel document containing a product backlog and a "generate index cards" button.
For more info, see the readme inside the document.
This version requires only Microsoft Excel. The previous version required both Excel and Access.
Update (2008-01-04)
Here's another excel-based index card generator from Claudio Gambetti. Contains a few extra features such as tracks (a.k.a. themes) and components, as mentioned in my book. You choose your flavor. Thanks for contributing this Claudio!
Re: Index card generator - version 2!
Actually, it isn't designed primarily to print on physical index cards.
It prints to normal paper, but two stories per page. So you print to your normal printer paper, then take out scissors and cut each paper in half. That gives you the equivalent of story cards in roughly A5 format (A5 = half the height of A4).
It prints to normal paper, but two stories per page. So you print to your normal printer paper, then take out scissors and cut each paper in half. That gives you the equivalent of story cards in roughly A5 format (A5 = half the height of A4).
Re: Index card generator - version 2!
I have made it work in openoffice, replace all variables named "name" with "nameVar", since name is a reserved word. Then update the sub OpenForm() to look like this:
Dim dlgUserForm1 as object
Public Sub OpenForm()
Dim libStandard
Dim libDialog
libStandard = DialogLibraries.getByName("Standard")
libDialog = libStandard.getByName("UserForm1")
dlgUserForm1 = CreateUnoDialog(libDialog)
dlgUserForm1.execute
End Sub
Dim dlgUserForm1 as object
Public Sub OpenForm()
Dim libStandard
Dim libDialog
libStandard = DialogLibraries.getByName("Standard")
libDialog = libStandard.getByName("UserForm1")
dlgUserForm1 = CreateUnoDialog(libDialog)
dlgUserForm1.execute
End Sub
Re: Index card generator - version 2!
Hi Henrik,
I'm implementing Scrum in an organisation and would really like to use your Index Card Generator for the Product Backlog. However, we've tried it on various platforms but keep getting the same error when trying to generate the index cards: "The Macro !OpenForm" cannot be found".
Hope you or anyone else monitoring can help.
Regards,
Paul
Re: Index card generator - version 2!
Hi,
Thanks for sharing this really helpful tool. I modified the template UI a bit and have a quick question.
How do you modify the scripts in Excel 2007? I needed to split the lower cell (large cell for the description) into 4 cells, which I then fill in with 4 status details later. Having done so, the priority cell had to move to cell G3 instead of D3. As a result the Priority entry in the BACKLOG does not come over to the CARDS of course.
Basically, I need to change the script to make it grab the priority value from G3 instead of D3. Any help is appreciated.
Thank you,
Ash