Minnesota Christmas Bird Count Spreadsheet Tools

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/r/o/h/rohair/html/CBC/ref/cbcsqlcon.php on line 2

SPREADSHEETS
Follow the steps below to produce one a spreadsheets of CBC data. The data spreadsheet will appear in a new window, which can be printed, or transported into a different application such as Microsoft Excel.

Spreadsheet
Count Area
Species
Select Range of Count Years
First Year: Last Year:

Warning: mysql_query(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/r/o/h/rohair/html/CBC/data/spread.php on line 91

Warning: mysql_query(): A link to the server could not be established in /home/content/r/o/h/rohair/html/CBC/data/spread.php on line 91

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/r/o/h/rohair/html/CBC/data/spread.php on line 92

NOTES: If you do not know the first and last years, the default values will include all CBC seasons.

Spreadsheet Options
Single Location Census displays all species by year for the seasons selected. Single Species Census displays species census data for each count season selcted. Count Year (or range of Count Years) Census displays the total census of each species for each CBC Location. NOTE: selecting a range of count years gives the total sum of each species for that time period.

To get the data into MS Excel properly I have had to take the following steps. 1. Select the entire data spreadsheet in the new window by using the "Select All" feature of the web browser, and copy the data. 2. Paste the data table into a text editing program such as NoteTab. 3. Save the file as a text file. 4. Open the Text File up with MS Excel (or other spreadsheet software program).


SPREADSHEETS Follow the steps below to produce one a spreadsheets of CBC data. The data spreadsheet will appear in a new window, which can be printed, or transported into a different application such as Microsoft Excel. Spreadsheet Count Area Species Select Range of Count Years First Year: Last Year:		Warning: mysql_query(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/r/o/h/rohair/html/CBC/data/spread.php on line 91 Warning: mysql_query(): A link to the server could not be established in /home/content/r/o/h/rohair/html/CBC/data/spread.php on line 91 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/r/o/h/rohair/html/CBC/data/spread.php on line 92
NOTES: If you do not know the first and last years, the default values will include all CBC seasons.
Spreadsheet Options Single Location Census displays all species by year for the seasons selected. Single Species Census displays species census data for each count season selcted. Count Year (or range of Count Years) Census displays the total census of each species for each CBC Location. NOTE: selecting a range of count years gives the total sum of each species for that time period.	To get the data into MS Excel properly I have had to take the following steps. 1. Select the entire data spreadsheet in the new window by using the *"Select All"* feature of the web browser, and copy the data. 2. Paste the data table into a text editing program such as NoteTab. 3. Save the file as a text file. 4. Open the Text File up with MS Excel (or other spreadsheet software program).