Index card generator – version 2!

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

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!

Update (2011-06-23)

Here’s another version from Nathalie Beauguerlange. He says:

“I have made a little modification on it, because the cards were a bit too large for our scrum board, so I’ve resized the template and changed the cards number per page, allowing me to print 4 cards per A4 format page, so that we can use less paper.”

Update (2011-06-28)

Here’s a Google Docs version of this tool (and instruction video), for those who use Google Spreadsheets to house their backlog. I usually prefer Google Spreadsheets over Excel, since it is multiuser and in the cloud. And requires no installation. And no payment :o)

Thanks David Vujic for making this available.

47 Comments

  • 1
    December 18, 2007 - 5:06 am | Permalink

    Does A5 correspond to card stock that would be available in the US?  My team is just starting to use scrum, and printing cards sounds like a great idea!

    (Hopefully we should be able to change the layout if necessary to fit our needs.)

    Thanks,

    -james.

  • 2
    December 18, 2007 - 5:53 am | Permalink

    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).

  • 3
    December 19, 2007 - 12:34 pm | Permalink

    It now works for Excel 2000 as well. Thanks Thierry Cros for help in fixing that.

  • 4
    Tobias
    August 18, 2008 - 6:54 am | Permalink

    Have anyone ported this script to OpenOffice? It seems to work a little bit but fails on a syntax error when trying to update the index cards.

  • 6
    August 19, 2008 - 9:48 am | Permalink

    Not that I know of…

  • 7
    Anonymous
    September 22, 2008 - 3:35 am | Permalink

    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

  • 8
    Anonymous
    May 21, 2010 - 8:05 am | Permalink

    Hi, I am not used to use scripts like this in excel and openoffice. I opened the file in openoffice (Tools > Macro > Organize Macros) and the scripts are with the lines commented with Rem.

    What I did wrong ?

  • 9
    Thomas
    March 4, 2009 - 9:43 am | Permalink

    I was wondering what the columns behind estimate in Claudios sheet are good for. The ones with db, api, etc.

  • 10
    Anonymous
    August 3, 2009 - 3:02 am | Permalink

    Many thanks for publishing these generators. I’m sure they will be very helpful in our team.

    Best regards
    Gabriel

  • 11
    September 7, 2009 - 7:51 am | Permalink

    Hi, this script is for the Excel for Windows. There is for Mac OS or Office 2008?

    Applescript.

  • 12
    Montecchyo - Brazil
    October 5, 2009 - 4:58 am | Permalink

    Thx a lot. Nice excel template and card generator.

  • 13
    Prasanna
    January 21, 2010 - 6:25 am | Permalink

    thanks for the script.. we have a different format for our story cards and i have modified the script accordingly.. pretty useful stuff.. thanks again!!

  • 14
    March 9, 2010 - 1:03 am | Permalink

    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

  • 15
    Anonymous
    March 22, 2010 - 8:31 am | Permalink

    How about 1 that works with google docs?

  • 16
    Ash
    March 26, 2010 - 11:44 am | Permalink

    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

  • 17
    Anonymous
    March 31, 2010 - 9:09 am | Permalink

    I figured it out. modified the function Private Sub FillTemplate to suit my needs.
    Ash

  • 18
    Anonymous
    September 9, 2010 - 1:33 am | Permalink

    The Problem is, that my Acceptance Criteria is often longer than the space allows. Like that, it cuts parts from the criteria off on the cards.
    Isn’t there a possibility to put all the text on the card?

  • 19
    Tom Murton
    July 4, 2011 - 10:33 am | Permalink

    Ive got exactly the same problem, dont know Excel well enough to change the script myself
    I am actually using it for my own to do list

  • 20
    Anonymous
    February 3, 2011 - 7:22 am | Permalink

    thanks a lot

  • 21
    Martin
    February 17, 2011 - 9:41 am | Permalink

    Hi there
    Is there any way I can get this wonderful index card generator to work on a MAC? I have Numbers and Excel, but the macro is removed when I open the file.
    Any help would be greatly appreciated.

    Thanks
    Martin

  • 22
    February 17, 2011 - 9:56 am | Permalink

    I’m sure there is a way to make it work. If anybody has time to figure it out then feel free to send a mac-friendly version of the index card generator to me and I’ll add it to this blog entry (with due credits of course). Thanks for pointing out the problem.

  • 23
    February 19, 2011 - 12:06 pm | Permalink

    Microsoft in their wisdom removed VBA support from Office for Mac 2004/2008, but I’ve learned that Office 2011 will bring that back.

    I almost finished converting to AppleScript-macros (which Office 200x does support, somewhat) a year or so ago. I’ll try to find that. Meanwhile I think the OpenOffice version is a way to go.

  • 24
    February 19, 2011 - 5:32 am | Permalink

    Thanks Thomas. I’ve heared several people claim that the index card generator works on Office 2011 for Mac. We’ll see if anyone finds a trick to make it work on earlier version of Office for Mac.

  • 25
    Erik
    May 31, 2011 - 4:31 am | Permalink

    This card generator has been very helpful for a long time. However, I now had a backlog which really did not match the format of your templates. So I tried the old Word Mail Merge feature, linked to my backlog Excel file. Worked like a charm! Super simple to arrange format and no fear of messing up the VBA script.
    http://www.addictivetips.com/microsoft-office/word-2010-mail-merge/

  • 26
    June 1, 2011 - 7:59 am | Permalink

    Cool, thanks for reporting back!

  • 27
    June 27, 2011 - 10:21 am | Permalink

    Hi! I have written a Google Spreadsheet version of the Index Card Generator tool.

    Check out this blog post if you are interested: http://blogg.idg.se/agile/2011/06/27/visa-vad-du-gor-eller-dude-wheres-my-index-cards/

  • 28
    June 28, 2011 - 8:40 am | Permalink

    Awesome! Thanks! Will add this link to the blog entry above.

  • 29
    Billie
    August 16, 2011 - 3:41 am | Permalink

    I am still using version 1 – and very happy, except for 1 problem. I need to have a fractional Importance rating, e.g. 1.5.

    How I do I revise the tool for this?

  • 30
    Jerry Valle
    September 22, 2011 - 4:49 pm | Permalink

    Hi Billie,

    Decimal types are not supported in vba. To make it work, malke the following changes:

    1.The values in the backlog Imp column are coerced to integer in clsIndexCard.Importance(). I set that back to string:

    Property Get Importance() As String

    ‘Dim i As Integer’ not sure why this is her so I commented it out. Jerry’

    If (IsNumeric(mImportance)) Then
    ‘Importance = CInt(mImportance) ‘removed the coercion. Jerry
    Importance = mImportance
    Else
    Importance = 0
    End If

    End Property

    2. Then in modIndexCard.QuickSort coerce Importance to single to preserve the decimals. Provided a snippet only as this is all you have to change, so locate the code and make the changes shown :

    Do While CSng(cards(lngLow).Importance) CSng(varTestVal.Importance)
    lngHigh = lngHigh – 1
    Loop

    You’ll need to format the TEMPLATE’s Importance cell and the BACKLOG’s Imp column to be numeric with the number of paces left of the decimal you need.

    Regards,

    Jerry

  • 31
    Jerry Valle
    September 22, 2011 - 4:50 pm | Permalink

    Hmmm. Looks like I forgot a line or two – use this:

    Do While CSng(cards(lngLow).Importance) CSng(varTestVal.Importance)
    lngHigh = lngHigh – 1
    Loop

  • 32
    Jerry Valle
    September 22, 2011 - 5:02 pm | Permalink

    Interesting, the tool is deleting the second set of code. It look slike it doesn’t like the than characters. Nevertheless, as you can see add the CSng(…) to to each expression that has .Importance. There will be two Do While lines with two occurences of Importance on each line change them to this being sure to keep the LT and GT symbols:
    Do While CSng(cards(lngLow).Importance) CSng(varTestVal.Importance)
    Do While CSng(cards(lngHigh).Importance) CSng(varTestVal.Importance)

    Ah, I see the HTML comments at the bottom of the page now, that explains what happened to the code.

    BTW, Billie, were you planning to use the decimal as a way of expressing priority.order?

    HTH,

    Jerry

  • 33
    October 17, 2011 - 9:47 am | Permalink

    […] Henrik Kniberg  has an excellent  Microsoft Excel spreadsheet for tracking Agile/SCRUM product backlogs. […]

  • 34
    Shen
    October 26, 2011 - 1:23 pm | Permalink

    Hi,

    Thank you very much for the google spreadsheet version, it works great.

    I changed the column “How to test” to read “Acceptance Criteria”, both in backlog and in template, but now when I create the card, the acceptance criteria comes up as “undefined” – where is the script that I need to change it, please?

    I’m sort of new in the excel thing,

    thanks.

  • 35
    February 22, 2012 - 7:22 am | Permalink

    […] template « Index Card Generator » de Henrik Kniberg pour imprimer nos […]

  • 36
    Bo
    March 7, 2012 - 2:03 am | Permalink

    Great job on the generator. I have a question though. How do I modify the template? The format of our stories is a bit different than what I see in the template. I am unfamiliar with how to modify macros in Excel is there an easy explanation on how to modify the fields on the template?

    For instance, if there is no importance value the generator is filling that field with 0. I want to default to blank so we can fill it in by hand after printing out.

    Second, I don’t need the second notes field but need to add some other fields we track. how do I go about changing that?

    Third, how do I manage the number of stories that print per page?

    Thanks for any guidance, and again a huge thanks for the tool itself.

  • 37
    April 4, 2012 - 12:50 pm | Permalink

    […] s Blog » Index card generator – version 2! 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. […]

  • 38
    Warren
    July 19, 2012 - 4:03 pm | Permalink

    I navigated to the Google Spreadsheet version and there was no Story Cards menu item. Has this functionality been removed?

  • 39
    September 11, 2012 - 9:05 pm | Permalink

    Warren:

    The Story Cards menu item is created when you are logged in to your gmail or Google Docs account. From there you should choose “file -> copy” to save your own version to work with.

  • 40
    Hossein Khalaj
    March 18, 2013 - 12:51 pm | Permalink

    Excellent! Thanks. Thanks for sharing Henrik 😉

  • 41
    Pedro
    April 5, 2013 - 1:37 pm | Permalink

    Great tool!!! Thanks for sharing :)

  • 42
    Kalen
    April 15, 2013 - 5:11 pm | Permalink

    Thanks for the great book, and thanks for this script – much obliged

  • 43
    August 22, 2013 - 6:00 pm | Permalink

    Thanks for the Macro to create te Cards of the backlog and THANKS FOR THE EXCELLENT book to get really into SCRUM

  • 44
    Hema
    May 13, 2014 - 4:31 pm | Permalink

    This is an amazing workbook to use. I see that you have backlog and cards. But is there a way to create a sprint please? Would very much appreciate your help on this as I am completely new to scrum. Cheers.

    • 45
      May 20, 2014 - 10:15 am | Permalink

      Glad you like the tool! This tool is just for printing index cards from a backlog. There’s no other support for things like sprints, etc. Google around and you’ll find plent of other tools & templates for that.

  • 46
    Duncan
    September 16, 2014 - 10:37 pm | Permalink

    Great tool – thanks.

  • 47
    December 28, 2015 - 10:32 am | Permalink

    IDG has unfortunately removed their entire blog section/feature and posts are no longer accessible. Here’s the post about index card generator for Google spreadsheet, can you update your post with this one?

    http://davidvujic.blogspot.se/2011/06/visa-vad-du-gor-eller-dude-wheres-my.html

    I am very happy to see that a lot of people still use the tool and I think many have found it from this post.

  • Leave a Reply

    Your email address will not be published. Required fields are marked *