Setting up a prize spreadsheet

It’s a new year and we’re all raring to get winning! Get ready to welcome all those shiny new prizes into your home by creating a spreadsheet to record all the details. Unlike a notebook, a spreadsheet enables you to tally up totals easily – you can also search it and create pie charts to see how well you do with different types of comps. 

I set up my 2020 prize spreadsheet last week and am excited to already have several prizes listed on it!

How to create a prize spreadsheet

Zooming in, at the top you can see I have a green highlighted row – the ‘value’ in this row contains a formula and automatically updates with a running total when a new prize is added. If I’m not sure on a prize value I try to estimate it – I’ve not received the light saber yet so have left that blank. It’s always exciting in December to look back over the year and see the total value of all your prizes!

How to create a prize spreadsheet

I use Google Drive to create my spreadsheet – log in at http://drive.google.com using a Google or gmail account. The Drive app is also worth downloading to your mobile device. Using Google means you can access and add to your prize spreadsheet from your computer, phone or anywhere in the world.

Why keep a prize spreadsheet?

It’s useful to:

  • calculate the value of the prizes you win over a certain period of time
  • check on the prizes you’ve not yet received and the date you won them, so you can chase them up after 28 days
  • give you a boost during a dry spell – you’ll be surprised how many small prizes you win, and making sure you list all those little wins will help you feel more positive and enthusiastic
  • see which type of competitions you’re most successful with, and should be focusing on
  • remind yourself to say THANKS to the promoter, which is really appreciated
  • see how you’re doing if you set yourself regular comping goals – eg. to win a prize a week, or to win five Instagram competitions in 2020!

Check out my Comping Year post to see how I use the information from my spreadsheet to do my annual comping success report.

How to set up a spreadsheet

  • First, go to my template here
  • Go to File on the top menu then Make a Copy – this will save a copy to your own Google Drive files (you can also change the name when you save)
  • Tap in the boxes to enter new content – I estimate the individual values if I’m not sure, or leave it blank until the prize arrives and I know exactly what it is!

It’s as simple as that! The box at the top will automatically update with your running total of prizes. 

Spreadsheet tips

  • Hover over the letters at the top of the columns and a small down arrow appears – tap this and you can Sort Sheet A>Z. Using this tool you can sort your prizes into value order, or type of competition – reset it by sorting the Date Won column.
  • Delete or insert columns by clicking on the arrow at the top of a column
  • If you tap Return in a cell, the cursor moves to the cell below – use Option-Return to start a new line in the same cell
  • Change the width of columns by hovering between the letters until a blue bar appears, then drag the bar across
  • Use different colours for text or background by highlighting a row, column or cell and clicking the A or the paint bucket in the top menu.
  • Freeze rows at the top of a spreadsheet, so when you sort the content into alphabetical order those rows are ignored (on my template the top 2 rows are frozen)
  • Create a pie chart or graph by clicking at the top of a column, then going to the option at the end of the menu bar and tapping the bar chart icon.
  • For advanced users, you can add filters to columns by selecting one or more columns, then tapping the funnel icon in themenu. Tap the filter icon at the top of the columns and you can choose which values to display – for example, you can use a filter to only show you prizes you’ve won on Twitter.
  • To search your spreadsheet, go to Edit > Find and replace and type your search term in – keep clicking Find to show all results
  • Save your spreadsheet to your bookmarks bar for easy access!

Expanding your prize spreadsheet

This year I’ve been super organised and expanded my Prize Spreadsheet into a Comping Spreadsheet, by adding extra spreadsheet tabs (do this by tapping the plus sign at the bottom of the sheet), so I have:

  • Prizes – prize spreadsheet
  • Effort – list of creative/effort comps I want to enter
  • Purchase – list of current purchase comps in closing date order
  • Entered – effort, purchase or low entry comps I’ve entered

Compers always ask me if it’s worth keeping a spreadsheet of all the competitions they enter. I consider this to be a waste of time and means you’re focusing on the amount of comps you didn’t win, which can be rather deflating! Rather than recording everything, I just save details of the purchase, creative and low entry comps that I enter.

Set up a prize spreadsheet

Above is a copy of my Purchase spreadsheet, which I check before every shopping trip. I add comps to this from my Lucky Learners group, Compers News magazine and the ones I find myself in store. There are more columns where I can add my unique codes (or barcodes) and more details of the comps.

After entering purchase or creative comps I move these over to my Entered spreadsheet. On the Entered spreadsheet I also save links to any particular comps I’ve entered where I believe I have a good chance of winning – maybe a local comp or a comp with very few entrants. Then I can go back and check they announced a winner after the closing date.

Wishing you lots of luck for a new comping year – and let me know when you’ve added your first prize to the spreadsheet!

10 Responses

  1. Katrina Adams says:

    Hi Di,

    Fantastic organisation. I have multiple spreadsheets, rather than having it all on one but I think I prefer your way so I’m going to have a fiddle round and change them. Can I ask what the colour coding is for in the purchase one?

    • Di says:

      Yellow = must enter this one!
      Green = have entered already but would like to enter again as multiple entries allowed!

  2. Mei says:

    Thanks for the spreadsheet! I note you put your Lidl Cineworld vouchers expiring end of March, mine says end of Feb? I would like longer too 🙂

    • Di says:

      Oops, I misread the date! Yes, mine are end of Feb too. Very soon!

      • Mei Suen says:

        Yes, very soon! Hope the Unlimited card/code comes soon. Then both my husband with the vouchers, and I can go together until end of Feb. He was not lucky enough to win Unlimited. I saw 94 free films last year! One year I saw 132, including 26 premieres and 7 Gala Screenings! Those were the days, not many premiere comps these days 🙂 Only managed 7 premieres/galas last year.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.