Setting up a Prize Spreadsheet in Google Drive

Do I keep a list of my prizes? Hell yes! Otherwise, how could I tell you that in 2013 I won £16,600 of prizes, won 28 Twitter comps and have 4 prizes still missing!

I’ve kept a record of my prizes in spreadsheet format for the last ten years, mainly so I can total up my wins each year and see if I’m still worthy of my ‘superlucky’ name! I believe one of the keys to becoming a successful comper is to be organised, and along with my Chrome bookmarks, Moleskine notebook and Evernote lists (more on those soon!), my prize spreadsheet is a very important part of keeping my hobby in order. An organised comper is a successful comper, right?

YouTube_Spreadsheet

Since 2011 I’ve saved my prizes using Google Spreadsheets, which you can set up at http://drive.google.com. You’ll need a Google or Gmail account to do this. Using Google means you can access and add to your spreadsheet from your computer, phone or anywhere in the world – it’s much more flexible than keeping a list in just one place!

Keeping a spreadsheet of wins can be really useful in lots of ways:

  • See which type of competitions you’re most successful with
  • Calculating the value of the prizes you win over a certain period of time
  • Keep check on the prizes you’ve not yet received and the date you won them, so you don’t forget to chase them up!
  • It’s a great morale boost if you’re going through a dry spell – you’d be amazed how many small prizes you win, and making sure you list ALL of them makes you feel much more positive and successful!
  • At a glance you can see which prize came from which promoter, so you can thank them for it!

Here’s my short YouTube guide to how I set up a Google Spreadsheet to record prizes – as for filling it in, you’ll have to work on that part yourself. Good luck!

 

As for keeping a list of every comp I enter… no way! Life’s too short to dwell on the prizes that might have been…

Update! There’s now a DRIVE app available for phones, so you can edit your spreadsheets offline.

8 Responses

  1. Elaine B says:

    This is really useful! Only recently started comping but can’t believe I didn’t think of this! Thank you!

  2. Stevie says:

    That’s cool.

  3. Keri Jones says:

    I have a notebook full of my wins- 150 so far. Hoping to fill it- although that could be a few years down the line 😉 x

  4. Lucy Bishop says:

    Fabby idea Di – I’ve just set up an excel spreadsheet on my laptop of my wins last year (I started comping in sept 2013) and between sept-dec I’ve won over £1400 worth of prizes – amazing! It soon adds up! xxx

  5. Christine Bray says:

    Thanks Di think I will do this … x

  6. Paul Kay says:

    Thanks for the post Di, you really are superlucky that’s an impressive total? Nice look at Google Drive, never really given it much thought. I keep meaning to record my wins in a spreadsheet and after a brief start it falls by the wayside so New Year resolution !! record those wins 🙂

  7. Angela Walton says:

    Thanks Di, just set this up. Nothing filled in yet but it’s only a matter of time, right? 🙂

  8. emmasfabulous says:

    Thanks for this, just having a go now 🙂

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.