Select and Using a Spreadsheet
Entering sightings using a spreadsheet is new to WR4.
Spreadsheets for various scenarios such as area counts and surveys can be set up and reused as required.
A video tutorial if the spreadsheet set up process can be seen here Video Tutorial HERE
Spreadsheets allow users to enter multiple trips on the same form. Each column of the spreadsheet represents a different trip, each row contains the details for a species.
Spreadsheets can be set up to preload the columns. The following types of spreadsheetcan be defined:
- A single date with multiple site columns.
- A single site with multiple date columns.
- A flexible sheet where the dates and sites for each column can be set manually each time the spreadsheet is opened.
A spreadsheet is associated with a workspace which governs the locations and species which will be available during data entry. Workspaces can be defined using custom species lists to target only those species which are likely to be recorded in the area for which the spreadsheet is to be used. This will greatly speed up the entry of data into the spreadsheet. cies
The basics are select a workspace, site and date then enter your sightings in a grid that looks like that of a spreadsheet.
Workspace - an graphical area containing the species recorded within it and site that are within it.
Site - Can be several sites in one trip on the same date.
Date - Can be several consecutive dates at the same site.
Species list - limits species to to thos on a selected custom species list
One of the great things about using a spreadsheet to enter your sightings is you can restrict the species so that when entering you only see the species for the area. Lets say you regularly visit a certain site and doing so you will have a list of the birds you have seen at that site.
First you will produce a Personal / Custom species list, selecting the species for that list using the check boxes and when complete you save the list. This saved list can be used for many things within WR4. If you want to add or delete a species too or from your list, open up your list and just check or uncheck the boxes, its simple but very powerful.
Now you need to make a new Workspace, give is a meaningful name and select your personal / custom species list. This workspace now limits the number of species that will appear when used.
Now whenever you use that Workspace only the species in your custom species list will appear.
This is especially useful for those who take part in regular surveys and may want to print out a checklist to help.
You can also select locations or dates as you go.
Now simply enter your sightings
To make a new spreadsheet or edit a pesent one.