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

docsupar.gif (2976 bytes)  Hit Counter