ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Michigan Bird Listers Data Mining Workbook
Ver. 20210921
2
This workbook is custom made to convert your EBird data into a format usable for the Michigan Bird Listers Annual Compilation.
3
In order to use the workbook you need to have basic knowledge of how to use spreadsheets and know how to unzip files, use Google Drive, Google Sheets and Ebird.
4
Note that the workbook requires authorization to run Google App Script to access your EBirdData.csv file on your Google Drive and to update your copy of the workbook with your Annual Compilation totals.
5
This workbook is provided "as is" and without warranty of any kind. Submit questions to ?????, answers will be provided as time permits.
6
7
Getting Started
8
In order to use this workbook please follow these basic steps:
9
1
Make sure you are logged in to your Google account and are familiar with Google Drive and Google Sheets
10
2
Make sure you have your EBird account and are familiar with EBird
11
3
Follow the instructions on the EBird web site to download your EBird data. Use the 'My Ebird/Download my data' link to request a copy of your data.
12
4
Unzip your Ebird data to your PC. Upload the csv file (typically named MyEBirdData.csv) to your Google drive (New/ File Upload).
13
5
Copy the MichListersDataMiner workbook to your Google drive. (File/Make a Copy). Close the original Mich Listers workbook to avoid confusion.
14
6
Open your copy of the MichListersDataMiner workbook from your Google drive. After a few seconds you should see a 'MichListers' menu item in the Google Sheets menu bar.
15
7
Select the MichListers/Import EBird Data menu item and select the desired year, 2020 or 2021. The first time you use this menu item Google will ask you to authorize the Google App Script. Refer to the 'Authorization' section below.
16
8
Enter the name of the Google Drive file that contains your EBird data, (typically named MyEBirdData.csv). The script will create the 'US-MI' worksheet that contains your Michigan EBird data.
17
9
Select the MichListers/Build All Lists menu item and the script will generate all of the Michigan Bird Listers Annual Compilation lists. See 'Worksheet Descriptions' below.
18
19
Locations, Sites, Townships, Municipalities
20
These lists are included in the Location Lists Worksheet.
21
By default the script identifies any individual Ebird location that meets the 100 species minimum for Life list and Big Year and includes those locations in the worksheet.
22
Similar to EBird 'patches' you can create your own Site, Township and Municipality lists to be included in the Location Lists worksheet.
23
Modify the Sites, Townships, or Municipalities worksheets to include your personal groupings and the list of EBird locations to be included in the group
24
Each column represents a grouping, the first row is the title for the group and any addtional rows in that column must contain specific EBird locations.
25
The Sites sheet contains the 'HCMA Metroparks' grouping as an example.
26
27
Worksheet Descriptions
28
Instructions
This worksheet. Do not modify; locked.
29
List of Lists
Simple list of the Annual Compilation lists used. Do not modify; locked.
30
Regions
A list of specific regions used in the annual compilation. Do not modify; worksheet is locked.
31
Sites
Worksheet used to create personal lists. Modify as described above.
32
Townships
Worksheet used to create personal lists. Modify as described above.
33
Municipalities
Worksheet used to create personal lists. Modify as described above.
34
US-MI
This worksheet is generated when your EBird data is imported into the workbook. This worksheet is used to generate the remaining lists. Do not modify.
35
State Lists
The worksheet is generated by the Build State Lists menu item.
36
County Lists
The worksheet is generated by the Build County Lists menu item.
37
Location Lists
The worksheet is generated by the Build Location Lists menu item.
38
39
Authorization
40
Google requires you to authorize the workbook the first time the MichListers menu is run.
41
1
When the 'Authorization Required' dialog is displayed, click 'continue'.
42
2
Next, choose the Google account you are using the workbook with.
43
3
Google indicates theat the application is not verified. Click the small 'Advanced' link.
44
4
Select the ''Go to MichListers (unsafe)' link.
45
5
Google displays the access required by the workbook, click 'Allow'.
46
6
The autohorization process halts the menu operation so you will have to select the menu item again.
47
7
You may see a 'Security Alert' email from Google. This normal because you have granted Drive access to Mich Listers.
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100