Topic: Error validating excel spreadsheet
I'm trying to use the Record Cleaner to check spreadsheets of records against the new lichen rules, but have hit a few problems.
First I had to change the spreadsheets before it could read them correctly. The grid ref column format had to be changed from General to Text in some (but others worked fine without it being changed). Others had to have any formulae removed by pasting values, to avoid the Object error attached.
Having got the spreadsheets into the format that seems to be required, I find that Validation fails a lot of records on the grounds of not having a unique scientific name. What is non-unique about Parmelia saxatilis, Parmelia omphalodes, Physcia tenella, Ramalina farinacea, Lecanora soralifera, Cliostomum griithii, Hypotrachyna revoluta, Lecanora dispersa etc.? These are relatively common species. How can I get these records to go through to Verification?
These are the standard spreadsheets supplied by the BLS and they are used by many of our members to send in records, so I need to get this working before we demonstrate the Record Cleaner at our AGM in early January. Any help you can give will be much appreciated.
Janet
British Lichen Society