Difference between revisions of "Data Entry Assistant (DEA) Procedures"
(→Copy Labels / Comments Formula) |
|||
| Line 9: | Line 9: | ||
Open up the Excel spreadsheet that is to be entered into the database. Copy the formula in the first cell under the ''new_comments (formula)'' column down through the rest of the rows so all of the label data is merged into a single cell. Multiple cells can be selected in Excel by dragging from the start cell to the destination cell; or by clicking on the start cell, holding down the shift key, and clicking the destination cell. After the selection of the cells is made, right click and select ''paste''. The ''new_comments (formula)'' column is the extreme-right column within the Raw Data worksheet. | Open up the Excel spreadsheet that is to be entered into the database. Copy the formula in the first cell under the ''new_comments (formula)'' column down through the rest of the rows so all of the label data is merged into a single cell. Multiple cells can be selected in Excel by dragging from the start cell to the destination cell; or by clicking on the start cell, holding down the shift key, and clicking the destination cell. After the selection of the cells is made, right click and select ''paste''. The ''new_comments (formula)'' column is the extreme-right column within the Raw Data worksheet. | ||
| − | [[File:Formula_select.png| | + | [[File:Formula_select.png|none|frame|Formula prior to copy]] |
| − | [[File:Formula_copy.png| | + | [[File:Formula_copy.png|none|frame|Formula after copy]] |
| + | |||
| + | |||
| + | === Rename New_Comments Column === | ||
| + | Rename the header name for the ''new_comments (formula)'' column by removing the '' formula'' part including the intermediate space. | ||
| + | [[File:Comments_post_paste.png|left|frame|''new_comments'' column before rename]] | ||
| + | [[File:Comments_post_rename.png|none|frame|''new_comments'' column after rename]] | ||
| + | |||
[[Category:Data Entry Assistant]] | [[Category:Data Entry Assistant]] | ||
Revision as of 15:00, 26 October 2010
Introduction
This section contains information on the practices for preparing specimens for entry into the Ohio State University Insect Collecting (OSUC) specimen database using the Data Entry Assistant (DEA). The DEA web program requires that specimen records be present in a properly formatted data entry template (File:Data Entry Template 20-Feb-2007.xls file according to the Data Transcription Procedures protocol.
Initial Preparation
Copy Labels / Comments Formula
Since the OSUC specimen database does not support storing label information in a discrete manner, the transcription of the labels must be merged with the comments column of the data entry template to form a new amalgamated column known as new_comments.
Open up the Excel spreadsheet that is to be entered into the database. Copy the formula in the first cell under the new_comments (formula) column down through the rest of the rows so all of the label data is merged into a single cell. Multiple cells can be selected in Excel by dragging from the start cell to the destination cell; or by clicking on the start cell, holding down the shift key, and clicking the destination cell. After the selection of the cells is made, right click and select paste. The new_comments (formula) column is the extreme-right column within the Raw Data worksheet.
Rename New_Comments Column
Rename the header name for the new_comments (formula) column by removing the formula part including the intermediate space.
