Pages

Tuesday, 4 December 2012

How to get the most out of your scoring spreadsheet

Follow this link to get your hands on the Patchwork Challenge official scoring spreadsheet! If that doesn't work there are details at the bottom of this post....

You'll need your own version of this so when it is open, click file and select download...and save it somewhere!

The spreadsheet is dead easy to use. When January 1st comes, all you need to do is enter the birds you see in the 'Spp" column, as and when you see them, along with the date. The spreadsheet will add the values for each species. When you are lucky enough to find a species worth three points or more, put an 'F' in the find column.

The magical spreadsheet will then calculate the number of species you've seen and the number of points you've accumulated. Beware that the spreadsheet gets a little lippy when you enter something incorrectly spelled...there is a 'list' tab where you can look things up if needs be....but dont alter anything on the list page as you will mess up the innards of the spreadsheet and that will make our secret spreadsheet guru very upset ( although if you just downloaded it again he would never know....).

As you enter your list, you'll see your points and total growing in the box to the right of the columns (at the top of the spreadsheet). Once it's downloaded and saved, have a little play around to get the hang of things....anything you put in now can be deleted before January 1st.

For those of you with previous years lists....you'll need a comparative score to 'play against' You can copy the spreadsheet as many times as you like, and put past years lists in it (remembering to fill in the find column, but dont worry about the dates...that wont matter). If you only have a score for this year thats fine, but if you have scores going back even further take an average of the last 2 years for your comparative score.

This site is blockeddocs.google.comThe content on this site violates the acceptable usage policy.An unacceptable security risk is posed by this site.McAfee Content Category: Personal Network StorageMcAfee Security Rating: Green