CBC compilers: Would you like an excel template for compiling your CBC?
Just ask.
I have been compiling two or three CBCs for many years. They are small counts of four areas each with 12-20 field counters and half a dozen feeder watchers. 32-52 species. Field Tallies are got to me by eBird trip reports (more on that in the autumn) and feeder watchers report by email usually.
This is what I use. It has no macros or complicated formulae. There is only one cell reference to another sheet. If you know a little bit beyond basic excel, you can add areas and feeder watchers fairly easily. If you would prefer I adapt it for you, I maybe able to (I know only as much excel as you see here), for a small donation to the Rocky Mountain Naturalists - tax receipt available.
Features:
- Subtotals for field and feeder watchers
- Count of countable taxon
- Count week species separate
- Weather Audubon style
- Effort calculator for multiple parties
- Effort data entry adaptable to be done by area leader
- etc
