This afternoon, Amber E. and I (others joined in later) started organizing the data sheets from the seedling searches we have completed so far this season. We are sorting the new maps and other data sheets for each site by focal plant number, and adding the new pages to the end of each site’s notebook. As we organize data sheets for each site, we are also reconciling the maps with the master data sheet for each site.

The data we have recorded on the frame data sheets will need to be entered into a spreadsheet, so that we can use the measurements to generate maps and distance matrices for those focal plants.

slingDataEntryBlank.xls
Here’s an Excel file we can use to do the data entry. For each frame data sheet, 2 people should enter the data. The first person will enter data in the DE_1 worksheet, and the second person will enter data in the DE_2 worksheet. The check columns in DE_1 will then allow us to check for data entry errors. The file should be saved as “slingDataEntry2011Page[page number]”.

I’ll put together a master list with all the frame data sheet page numbers. The frame data sheets will be in the seedling notebooks. People will enter their initials when they have completed data entry for a page number.

Let me know if you have suggestions to make the data entry work better.