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 and count prizes with a click – you can also search it and change the order of your prize list quickly and easily!
I use Google Drive for my spreadsheet – log in at http://drive.google.com using a Google or gmail account – and 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 – much better than using an Excel spreadsheet on your PC!
Here’s my video guide to using a prize spreadsheet. After watching, find my template at http://bit.ly/PrizeListTemplate – then go to File > Make a Copy and save it to your own Drive, where you can change it to suit.
Why bother keeping a spreadsheet?
It’s useful to:
- calculate the value of the prizes you win over a certain period of time – so you can brag to your friends (estimate the individual values if you’re not sure!)
- 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 of them makes you feel much more positive and enthusiastic!
- see which type of competitions you’re most successful with, and should be focussing on
- remind yourself to say THANKS to the promoter!
Finally, just a note – people ask me if it’s worth keeping a spreadsheet of the competitions they enter. Unless it’s a creative or low-entry competition (in which case I save a link and will check to see they actually announced a winner!), I consider this to be a complete waste of time – it will only make you miserable looking at the amount of comps you didn’t win. It’s far better to focus on the competitions you did win! Instead, I keep a short list of links using a Notes app on my phone – recording only the creative, local or low entry comps I’ve entered, as these are the ones I’m most likely to win (or the most likely for the promoters to ‘forget’ to award!)
Wishing you lots of luck for a new comping year – and let me know when you’ve added your first prize to the spreadsheet!