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!

spreadsheetexample

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!

22 Responses

  1. Janine Learner says:

    Thanks Di. I use an Excel spreadsheet to list all the comps I enter but having a separate page to list wins is good so I’ve downloaded your template, thanks.

  2. tracey t says:

    thank you so much DI – have downloaded in readiness for starting Bootcamp tomorrow – added my two wins so far this year

  3. Leanne perrett says:

    i have been using A5 diarys for a few years now and have built a small collection of them but i havent had a chance to buy one yet this year so have downloaded the spreadsheet and hoopefully save some time and trees 🙂 now i just need to wait for a win

  4. Jo Godfray says:

    Thanks Di
    I have set mine up this afternoon after receiving first WEM 2018!! Thanks so much and good luck!!

  5. Val Pownall says:

    I’ve set mine up – now waiting for the wins! I was totally disorganised last year for various reasons but hoping this year will be better.

  6. lorraine kirk says:

    Thank you, this is really helpful!

  7. Anneka says:

    Thank you so much Di this is so much better than my table in word lol I’ve done all the steps just waiting for the wins now!

  8. Carolyn Collins says:

    Thank you this Di. What a good idea.

  9. Bex Allum says:

    Thanks managed to save and upload my first two wins 🙂

  10. Maggie Bermann says:

    Thanks Di Very simple to copy for a technopobe like me lol! Ive hit major dry spell so hoping this will give me encouragement to keep going
    Thanks for doing and Happy New Year to you and family x

  11. Marsha Richardson says:

    Thanks Di, I downloaded your template last year and forgot to thank you for it! So, thanks. I love it. So simple to access and look at. I’d recommend anybody to do a spreadsheet. Just looking at what I won last year has given me the nudge to do better this year and try new stuff (for example more creative comps!) So, thanks again and good luck! x

  12. Natalie Ellis says:

    Hi Di, I’ve just downloaded your prize list spreadsheet and have 5 entries on it already!!! Thank you for sharing your Comping knowhow 🙂

  13. Lisa Crowther says:

    Thank you – I’ve added on my one win of 2017 so far…here’s to many more for all of us x

  14. Helen Humphries says:

    Really helpful little vid too, always so much easier when someone talks you through. 🙂

  15. Sarah prescott says:

    Thank you for this template. I have just downloaded a copy and i cant wait to start filling it!!! I wrote my prizes in a note book last year and this year I am going to be more organised.

  16. Cristín Williams says:

    Thank you for your template, I stared keeping track of all my wins last January in an effort to be more organised but I did it all in a notebook. This quickly fell by the wayside when I didn’t always have my notebook to hand. I always have my phone so hopefully less of an excuse to give up on it this 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.