To help us to speed up the production of our Annual Report, we ask everyone submitting their annual records to use our spreadsheet to enter and submit their records.

This will also make compiling your records easier.

1. Records can be entered in any order, for example in date order, because the spreadsheet allows our editorial team to re-order the records in the way that we need them.
      
2. Species names are standardised in the form used in our reports but built-in "look-up tables" make finding the correct name very easy.
      
3. A gazetteer of site names, as used in YOC reports, is included for reference. Where the site name for a record is in this list a grid reference is automatically added, but new sites can be entered as well.

What you will need

To use our spreadsheet, you will need either Microsoft Excel, (part of the Microsoft Office suite of programs) or, alternatively, the Open Office suite, which is free software from Sun Microsystems. You can download Open Office from http://www.openoffice.org/ (opens in a new window). This is a very reliable alternative to Microsoft Office.

You will also need software to "unzip" the spreadsheet file, unless you are using a Mac. If you have Winzip installed, you'll have no problem. If not, you can get a free unzip program from http://www.jzip.com/ (opens in a new window)

Downloading the spreadsheet

New versions: updated 7 December 2011
If you are using Microsoft Excel (except Excel 2008 for Macs), use this download link:

Download the YOC spreadsheet from here
(file size: 209 kb)

Windows users: Right-click on the above link, select "Save Target As.." and then select the folder on your hard drive where you want to save the file. Mac users: click on the link and the file will download and unzip in your Download folder.

If you are using Microsoft Excel 2008 for Mac or Open Office's spreadsheet software, use this download link:

Download the YOC spreadsheet for Excel 2008 for Mac and Open Office
(file size: 221 kb)

Again, Windows users: right-click on the link, select "Save Target As.." and choose where you want to save the file. Mac users: click on the link and the file will download and unzip in your Download folder.

Instructions and problems

Once you have downloaded the file, use your unzip software to extract the spreadsheet to a folder on your hard drive.

Basic instructions for entering your records are inside the spreadsheet.

If you have any problems either in downloading or using the spreadsheet, please email our Report Editor, Mike Williams -

This is also the email address to which completed records should be sent.

The spreadsheet has already been extensively tested, but Mike would also welcome any feedback from users of the software.

[ Home | Recording | Sightings | Where to watch | Events & Diary ]
[ Organisation | Web Links | Bookshop | Contact Us ]

York Ornithological Club email: info@yorkbirding.org.uk

Carefully crafted by Ian Traynor of Traynor Kitching & Associates We are pleased to sponsor this web site