Spreadsheet: 213259d1360410456-how-to-prevent-duplicate-records-from-being-entered-on-a-recording-sheet-test-recording-sheet
Sheet: Example Sheet

Macro | Moth records (Please fill in as many of the fields below, leave blank where information is not known. Each row is a complete record so please make sure that all the recorder information is filled in for every row).
Enter species name in this column only ?
BF Log | Status | Species [NAME] | Species Latin name | Place Name | [NAME]. | [NAME]. | [NAME] | Determiners Name | Date of Record | Qty Recorded | Method of Recording | [NAME] type | Stage | Weather | Aspect | Altitude | [NAME]. | Notes
1637 | A | Oak Eggar | Lasiocampa quercus | Upper down | ST123456 | 47 | [NAME] |  | 2012-08-11 00:00:00 | 1 | Field | n/a | Adult | Sunny | Farmland, woodland and some water. | 217m |  | Caught near the shed
1638 | A | Fox Moth | [NAME] rubi | Upper down | ST123456 | 47 | [NAME] |  | 2012-08-11 00:00:00 | 1 | Field | n/a | Larva | Sunny | Farmland, woodland and some water. | 217m |  | Seen on the heather slope
1638 | A | Fox Moth | [NAME] rubi | Upper down | ST123456 | 47 | [NAME] |  | 2012-08-12 00:00:00 | 2 | Field | n/a | Larva | Cloudy | Farmland, woodland and some water. | 217m |  | Seen on the heather slope
1643 | A | Emperor [NAME] | Saturnia pavonia | Upper down | ST123456 | 47 | [NAME] |  | 2012-08-11 00:00:00 | 1 | Field | n/a | Larva | Sunny | Farmland, woodland and some water. | 217m |  | Seen on the heather slope
2142 | B | Beautiful Yellow Underwing | Anarta myrtilli | Upper down | ST123456 | 47 | [NAME] |  | 2012-08-11 00:00:00 | 1 | Field | n/a | Larva | Sunny | Farmland, woodland and some water. | 217m |  | Seen in the meadow
2107 | A | Large Yellow Underwing | Noctua pronuba | Upper down | ST123456 | 47 | [NAME] |  | 2012-08-26 00:00:00 | 27 | Light | [NAME]. | Adult | Cloudy and mild | Farmland, woodland and some water. | 217m
2111 | A | Lesser Broad-bordered Yellow Underwing | Noctua janthe | Upper down | ST123456 | 47 | [NAME] |  | 2012-08-26 00:00:00 | 2 | Light | [NAME]. | Adult | Cloudy and mild | Farmland, woodland and some water. | 217m
2117 | A | Autumnal Rustic | Eugnorisma glareosa | Upper down | ST123456 | 47 | [NAME] |  | 2012-08-26 00:00:00 | 1 | Light | [NAME]. | Adult | Cloudy and mild | Farmland, woodland and some water. | 217m
1942 | C | Dotted Carpet | Alcis jubata | Upper down | ST123456 | 47 | [NAME] |  | 2012-08-26 00:00:00 | 1 | Light | [NAME]. | Adult | Cloudy and mild | Farmland, woodland and some water. | 217m
2321 | A | [NAME] | Apamea monoglypha | Upper down | ST123456 | 47 | [NAME] |  | 2012-08-26 00:00:00 | 4 | Light | [NAME]. | Adult | Cloudy and mild | Farmland, woodland and some water. | 217m
2107 | A | Large Yellow Underwing | Noctua pronuba | Upper down | ST123456 | 47 | [NAME] |  | 2012-09-09 00:00:00 | 5 | Light | [NAME]. | Adult | Showers | Farmland, woodland and some water. | 217m
2109 | A | Lesser Yellow Underwing | Noctua comes | Upper down | ST123456 | 47 | [NAME] |  | 2012-09-09 00:00:00 | 3 | Light | [NAME]. | Adult | Showers | Farmland, woodland and some water. | 217m
2111 | A | Lesser Broad-bordered Yellow Underwing | Noctua janthe | Upper down | ST123456 | 47 | [NAME] |  | 2012-09-09 00:00:00 | 1 | Light | [NAME]. | Adult | Showers | Farmland, woodland and some water. | 217m |  | Seen on house window
2176 | A | Antler Moth | Cerapteryx graminis | Upper down | ST123456 | 47 | [NAME] |  | 2012-09-09 00:00:00 | 1 | Light | [NAME]. | Adult | Showers | Farmland, woodland and some water. | 217m
1906 | A | Brimstone Moth | Opisthograptis luteolata | Upper down | ST123456 | 47 | [NAME] |  | 2012-09-16 00:00:00 | 1 | Light | [NAME]. | Adult | Heavy rain | Farmland, woodland and some water. | 217m
2107 | A | Large Yellow Underwing | Noctua pronuba | Upper down | ST123456 | 47 | [NAME] |  | 2012-09-16 00:00:00 | 14 | Light | [NAME]. | Adult | Heavy rain | Farmland, woodland and some water. | 217m
2109 | A | Lesser Yellow Underwing | Noctua comes | Upper down | ST123456 | 47 | [NAME] |  | 2012-09-16 00:00:00 | 2 | Light | [NAME]. | Adult | Heavy rain | Farmland, woodland and some water. | 217m
2117 | A | Autumnal Rustic | Eugnorisma glareosa | Upper down | ST123456 | 47 | [NAME] |  | 2012-09-16 00:00:00 | 1 | Light | [NAME]. | Adult | Heavy rain | Farmland, woodland and some water. | 217m |  | Found on shed light
 |  |  | Example Sheet
 |  |  | Do not use this sheet for your records - use the Macro and Micro sheets.