Bird Point Count Data Sheet with Filled and Blank Copies

Use a fictional worksheet to connect detections to a visit, distinguish a zero from a missed visit, and trace one corrected entry.

In short

Keep a visit register and a separate detection table. Use the point and visit IDs to connect them. An attended visit with zero detections gets a 0. A visit marked Not made has an empty count.

Download the filled example (HTML) · Download the blank worksheet (HTML)

What goes in the visit register?

In our fictional Thimblefern Park worksheet, P02 appears twice. It identifies the same point on both dates. V02 is the November 12 visit, and V03 is the November 19 visit. Separate visit IDs make it clear which date each entry describes.

V02 was attended at 08:40 and has zero detections. V03 was planned but never made, so its start time and count are empty. Neither visit has a detection row. The register is where you can tell them apart.

NOS View showing three fictional visits and their detection counts
At P02, V02 shows an attended visit with zero detections. V03 shows a visit that was never made.

What belongs in a detection row?

V01 is the November 12 visit to P01. Its three detections share the same point and visit IDs. The filled copy puts those IDs above the table. In the blank copy, each row has its own ID fields so it can still be matched to the right visit when the sheet holds entries from several visits.

Read across D03. The identification is Unknown, the time band is Late, the distance band is Near, and the mode is Heard. That row is one of V01’s three detections. Early, Middle, and Late describe where an entry falls within this fictional visit. The clock time in the register belongs to the visit itself.

NOS Code with HTML source beside the Thimblefern worksheet
The preview beside Code shows the visit register above the detection rows. D03 stays marked Unknown.

How did one correction change the summary?

We started with D02 marked Heard. The fictional note said it was a sighting only, so we changed that cell to Seen and revised the summary beneath the table. The review note keeps the row ID, both values, the date, and the reason together.

Signed-out reader before the correction with D02 marked Heard
Before the change, the reader showed D02 as Heard and the summary read 1 seen · 2 heard.
NOS Edit open on the original worksheet with D02 visible
In Edit, the original worksheet still shows Heard in the D02 mode cell.
NOS View showing D02 as Seen and the updated mode summary
After the correction, D02 reads Seen. The summary now shows 2 seen · 1 heard across the same three rows.

When not to do this

Use these downloads to practice reading and checking a fictional record. The Vermont Center for Ecostudies lists a field data sheet among its volunteer resources. Its Forest Bird Monitoring Program coding sheet contains point numbers, start times, species, time periods, distance columns, and occurrence codes. Thimblefern uses its own practice labels. For a real program’s records, refer to its own materials.

How can someone read the example in NOS?

The Share panel for the Thimblefern worksheet gives the reader address. We reopened it signed out after saving the correction and saw Seen in D02 and the revised summary.

NOS Share panel showing the reader link and its viewing permissions
The Share panel gives the reader link for the fictional worksheet.
Signed-out reader showing the corrected worksheet and dated note
The same reader address now shows the corrected mode and a note explaining the change.

The trap monitoring log also separates a checked point with a zero from a missed check. The herbarium label template shows how an ID connects a label with its record. See research notes for a separate notes page or changelogs for a running record of edits.

Questions people ask

Does Unknown count as a detection?

Yes. D03 stays in V01's three detection rows. Unknown describes the identification, and Heard describes the mode.

Why is the count blank for V03?

V03 was never made. The blank count records that there is no visit result, while V02 has an observed zero.

Can I type into the blank worksheet?

Yes. Open the downloaded HTML in a browser, fill the labelled fields, and print the finished sheet or save it as a PDF.

Keep reading