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