Hi Geoffrey,
Thanks, there was a bug that had broken some of the species-grouped queries. I fixed that this morning, so it's likely that Andy re-tested the queries after the problem had been fixed.
Since Andy wrote the instructions an additional 'taxon rank' column has been added to the search results output, that column along with the 'aggregate' column need to be removed before pasting the results into the spreadsheet template.
I've updated Andy's instructions to reflect this and have refreshed some links and screenshots to use species-grouping that excludes aggregates. The revised version of the word document can be downloaded from:
https://database.bsbi.org/static/Checkl ... _2020.docxThe more recent 'vc Scarce and vc Rare taxa' query may also be worth looking at, it's based on some of the ideas from Andy's worksheet.
Tom Humphrey
Database Officer, Botanical Society of Britain and Ireland (BSBI)
c/o Centre for Ecology and Hydrology,Maclean Building, Crowmarsh Gifford, Wallingford, Oxon, OX10 8BB, UK.
tom.humphrey@bsbi.org