Bird Banding Laboratory


NEW INFO

Bandit

Site Map Index

Contact Info

Asistencia en Espanol

Bandit version 4.0 Excel Template

Before using the excel template that can be downloaded at the end of this page please read this important information:

1. The template is created for adding 3000 records (3000 bandings and 3000 recaptures). If you need to add more records please contact the Bandit help desk or do your data in batches of 3000 records at a time.
2. Columns that are gray are locked from editing. By selecting from the “description” fields beside them the Bandit/BBL code is automatically populated in the adjacent gray cell.
3. The column headers were created to match the Bandit field names. When you import the data into Bandit, if you select Matching Names in the field mapping screen, the fields that need to be imported should all line up. There will be several fields from the excel file that do not and should not have a target field, such as the “description” fields.
4. The Location field should be only the Bandit ID you’ve entered for the location.
5. When you enter a band number in the banding or recapture data entry worksheets it is automatically populated in the two “Marker” worksheets for bandings and recaptures.
6. If you enter a duplicate band number in the Banding Data Entry sheet the duplicate values will be highlighted in red.
If you are entering multiple recaptures per date for a bird, capture time is required. This is especially essential if adding auxiliary marker info.
7. Aux Markers should only be entered into either or both of the “Marker” worksheets. The Data Entry sheets are automatically populated with the marker info correctly formatted for importing into Bandit. **Only select to import the DATA ENTRY worksheets when importing.** If the marker info is the same for capture and release Bandit has the option to copy marker info, so you may want to enter marker info into only 1 of these worksheets. For more info about copying marker info, see: http://www.pwrc.usgs.gov/BBL/resources/bandit/Documentation/Bandit_4.0_User_Manual.html#ch-auxiliary-markers
8. COPYING AND PASTING DATA FROM OTHER WORKBOOKS - if you copy and paste data from other excel files or databases, the preformatting for a field may be overwritten. Thus, lead 0's may get dropped or invalid values will not get translated to BBL codes. For example, if you have your own values for colors, like L for Lime, these will not get properly translated to the BBL code for that color.
9. Parameters, such as number of allowed characters or values, are not set for most fields. Therefore, it’s possible that if, for example, you use 5 decimal places on bill width, Bandit will truncate or not correctly enter this data into the field on import.
10. AN IMPORTANT NOTE ABOUT A PECULIAR BEHAVIOR OF EXCEL FILES:
Excel has a nasty habit of "remembering" how many records were in a worksheet. Because the template is formatted for adding 3000 records in the Banding and Recapture data entry sheets, it thinks you are importing that many records.  If you use the template to import 100 birds for example, Excel (and consequently Bandit) will still consider 3000 to be the last line of data. So when you import the 100, Bandit will think you are importing 3000 and give you a warning similar to this:

2705 records in your file have no disposition code set.  Data for those will not be loaded.

 

Excel Template for Bandit 4.0