![]() ![]() You will need to convert the format of the document into a series of sets of lines, each of which is a single coding sheet in CSV format. If you already have a coding sheet typed in a word processing program, you can use the search and replace function to help edit the document and save time formatting. Here is an example of a three-line coding sheet for the column SEX as shown in Example Table 1: In a tDAR CSV format coding sheet each line has a code followed by a comma, followed by its value, followed optionally by a description (e.g. You can then upload these files directly into tDAR coding sheets. Save these as xls files (not as Excel 2007 xlsx files) or CSV files. Each Excel file will have only these two or three columns, in this order (code, value, description), no headings, and nothing after the coding sheet information. If you are creating a coding sheet from scratch or have one already in Excel format, the easiest thing to do is to create an Excel file for each coding sheet. The codes need not be in numerical or alphabetical order. The order of the lines (and hence the values) within the coding sheet doesn’t matter. ![]() The values and optional descriptions can have embedded spaces and can include most special characters (this is not true for ontologies, but never mind that for now). Thus, with a string code flr and Flr are different and 01.1 and 1.1 are different. However, string codes must match exactly. Thus, Flr and Fil could be context codes and 01.1, 1.1, and 1.2.1 could all be codes that would be expressed as strings. Codes can also be standardized string values, including strings of numbers that include decimal points. Thus, leading zeros on integer codes are ignored, so 001 and 01 and 1 are interpreted the same (and appear as 1). For a given coding sheet, if all of the codes are integers, they will be treated as numbers. Johns Black-on-red”), and optionally a description (e.g., “matte, subglaze and glaze varieties included”). In tDAR, a coding sheet has as code (e.g., 107), a value (e.g., “St. Unless it is a very simple coding sheet you will want to maintain it on your computer rather than just type it in in case you need to change it later. Depending upon whether you choose to upload a file or enter the information in a text box, tDAR will allow you to browse to locate the file or will supply the text box to type (or cut and paste) into. There are two ways to enter a coding sheet into tDAR: as an Excel (.xls) file or CSV file, or you can manually enter or cut and paste the lines that represent the coding sheet into a text box on the coding sheet web entry form. This downloadable document summarizes the metadata required to upload a Coding Sheet. If you are just preparing to upload a new Coding Sheet and would like to preview in a condensed format the information you will be asked to provide, check out our upload guide. ![]() You will need a separate coding sheet for each coded column in the spreadsheet. Creating this association is the purpose of the coding sheet. In tDAR, a coding sheet serves the same purpose, but when you enter your information using tDAR’s Coding Sheet page, this allows tDAR to make sense of the columns in your dataset – the user does not need to necessarily “translate” the meaning of the coded values manually when they view your spreadsheet or database.Įach column that is a coded integer, real, or string needs to have a meaningful value associated with the code to make the spreadsheet useful. It is common practice to provide a text-based coding sheet with published datasets so that users can interpret your data and replicate your methods. A Coding Sheet contains all the information that allows tDAR to decode the coded values for the columns in a spreadsheet or database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |