Updates to California County Spreadsheet
All changes listed reflect changes since November 5th, 1999 version. Thanks to all of those who have submitted corrections!!!
From 11/24/99 version------IMPORTANT: I changed the formula for the Column BK so that the formula for row 2 =COUNTIF(D2:BI2,"<2"). Just copy that formula in BK2 to all of the cells in BK--make sure that the row numbers in the formula are correct. The old formula included hidden codes in the count, so this will correct some errors in the totals.
11/15/99 version:
Lassen County: from Tim Manolis and Brad Stovall
taken off list due to lack of documented records:
Yellow-billed Loon
Emperor Goose
Tufted Duck
Harlequin
Duck
Oldsquaw
Black Scoter
Sabine's Gull
Great Gray Owl
Snowy
Owl
Magnolia Warbler
Hutton's
Vireo
-------------------------------------
Semi-p Sandpiper - add green
bar
Common Tern - add green bar
Tree Sparrow - remove green bar
Placer County: from Bruce Webb
added to list:
Franklin's Gull
Bobolink
deleted from list
Plumbeous Vireo
-------------------------------------
add green bar
to:
Greater Roadrunner
Long-eared Owl
Allen's Hummer
remove green bar from:
Black-bellied Plover
Black-crowned
Night Heron
White-faced Ibis
Lesser Yellowlegs
Short-billed
Dowitcher
Thayer's Gull
Glaucous-winged Gulls
Brewer's sparrow
11/18/99 version:
From "Field Notes" Volume 53 No.3
Plumas:
add
Harlequin Duck
Mendocino:
add
Black-throated Sparrow
Kings:
add Common
Grackle
Riverside:
add Cave
Swallow
Change to green:
Amador--Bank Swallow and Solitary
Sandpiper
Calaveras--Bank
Swallow
Kings--Solitary
Sandpiper
From Don Roberson
Monterey:
add
Eastern Wood-Pewee
add California Condor--recent records from 1970s and one
from 1980s
Del Norte:
add
Yellow Rail--pick-up dead by Alan Barron (fide Gary Lester)
San Diego:
delete
Crested Caracara--rejected as probably escaped bird
11/21/99 version:
From Kent Van Vuren
Madera:
add Swamp
Sparrow
From Bruce Deuel
Sutter:
add
Mountain Plover
add Costa's Hummingbird
add Swamp Sparrow
add
Chestnut-collared Longspur
Change to green:
Greater Roadrunner
Allen's Hummingbird
11/22/99 version:
From Bruce Deuel
Marin:
delete
Wandering Albatross
San Francisco:
add
Emperor Goose
Imperial:
add
Baikal Teal
remove green from Red-footed Booby (also hit delete key)
Riverside:
add
Baikal Teal
11/24/99 version:
From Bruce Deuel
Shasta:
add Ruffed
Grouse
Los Angeles:
add
Red-headed Woodpecker
Imperial:
change
text color to black for Gilded Flicker
San Luis
Obispo:
change text color to black for Downy Woodpecker
Monterey:
remove
green bar from Black-headed Gull
IMPORTANT: I changed the formula for the Column BK so that the formula for row 2 =COUNTIF(D2:BI2,"<2"). Just copy that formula in BK2 to all of the cells in BK--make sure that the row numbers in the formula are correct.
11/30/99 version:
From Don Roberson
Alpine:
taken off list due to lack of
documented records:
Tennessee Warbler
Bay-breasted Warbler
12/14/99 version:
From Mac McCormack
Sierra:
Blue-headed Vireo--taken off list due to observer retracting
record
add Lark Bunting
From Todd Easterla
Yolo:
add McCown's Longspur
From Kent Van Vuren
Merced:
add Chestnut-sided Warbler
12/17/99 version:
From Bruce Deuel's review of CBRC reports
Tulare:
delete
Great-crested Flycatcher
Fresno:
add
Scissor-tailed Flycatcher
Ventura:
delete
Curve-billed Thrasher
add Mottled Petrel
add Wedge-rumped
Storm-Petrel
add Brown Booby
add King Eider
add American
Oystercatcher
add Hudsonian Godwit
add White-rumped Sandpiper
add
Black-headed Gull
add Horned Puffin
add Parakeet Auklet
add
Violet-crowned Hummingbird
add Greater Pewee
add Scissor-tailed
Flycatcher
add Gray Catbird
add Black-backed Wagtail
add Sprague's
Pipit
add Yellow-throated Vireo
add Golden-winged Warbler
add
Connecticut Warbler
add Scarlet Tanager
San
Bernardino:
delete Cerulean Warbler
add Reddish
Egret
add Roseate Spoonbill
add White-rumped Sandpiper
add
Rufous-backed Robin
add Veery
add Dickcissel
Mono:
add Cape May
Warbler
add Worm-eating Warbler
add Nelson's Sharp-tailed Sparrow
Shasta:
add Emperor
Goose
Solano:
add Emperor
Goose
add Garganey
add Yellow Rail
Merced:
add Emperor
Goose
add Yellow Rail
Plumas:
add Yellow
Rail
San Luis
Obispo:
add Parakeet Auklet
add Yellow Rail
Del Norte:
add
Upland Sandpiper
Glenn:
add Snow
Bunting
Riverside:
add
Prothonotary Warbler
add Painted Bunting
Los Angeles:
add
Red-headed Woodpecker
add Mourning Warbler
Humboldt:
add Pine
Warbler
Orange:
delete
Anhinga
add Blue-footed Booby
add Emperor Goose
San Mateo:
delete
Anhinga
add Scarlet Tanager
San Francisco:
add
Mottled Petrel
add Wilson's Storm-Petrel
add Anhinga
add Thick-billed
Murre
add Parakeet Auklet
add Eastern Wood Pewee
add Yellow-bellied
Flycatcher
Santa Barbara:
add
Dark-rumped Petrel
add Murphey's Petrel
add Cook's Petrel
add
Red-tailed Tropicbird
add American Oystercatcher
add Upland
Sandpiper
add Red-necked Stint
add Parakeet Auklet
add Yellow-bellied
Flycatcher
Mendocino:
add
Red-tailed Tropicbird
From recent bird tapes:
Lake:
add
Garganey
Colusa:
add
Franklin's Gull
Imperial:
add
Anhinga
From Todd Easterla
San Joaquin:
add
Cape May Warbler
12/20/99 version:
From Todd Easterla
San Joaquin:
add
Lapland Longspur
12/27/99 version:
From John "Mac" MacCormick
Plumas:
add
Mountain Plover
add Ruddy Turnstone
12/29/99 version:
From David Vander Pluym
Ventura:
add
Black-footed Albatross
add Laysan Albatross
add Murphy's Petrel
add
Cook's Petrel
add Flesh-footed Shearwater
add Fork-tailed
Storm-Petrel
add Wilson's Storm-Petrel
add Red-billed Tropicbird
add
Whip-poor-will
add Chimney Swift
add Dusky-capped Flycatcher
add
American Dipper
add Sprague's Pipit
add Bohemian Waxwing
add Northern
Shrike
add Blue-headed Vireo
add Plumbeous Vireo
add Yellow-green
Vireo
add Painted Redstart
add American Tree Sparrow
add Large-billed
Sparrow
add Nelson's Sharp-tailed Sparrow
1/3/00 version:
From John Luther
Tuolumne:
add Long-billed
Curlew
add Western Sandpiper
From RBA
San Luis
Obispo:
add Williamson's Sapsucker
1/10/00 version:
From Tom and Jo Heindel
Inyo:
add Oak
Titmouse