Data downloads
|
The following help page provides an overview on how to access and manipulate the download files available through the Centre for Human Bioarchaeology website. We have tried to make the downloads as small as possible to ease access for those with slower connections.
|
This page will cover the entire process, from downloading the files themselves, to getting the data they contain into state in which analysis and manipulation can occur. Of course, for ease of use only the most direct advice can be offered to facilitate the successful download and assimilation of the data files - for more detailed information users are pointed to the help files and manuals of specific applications.
The download tables indicate the cemetery, type of data and download file type (Fig 1)
Figure 1
To download a file
If you are using a Windows PC right click on the link and select:
'Save target as' - Internet explorer, Netscape, Opera
'Save link as' - Mozilla Firefox
If you are using a Mac:
With mouse over the link use the “command” or “apple key” and “s” to save the page/link - Internet Explorer, Mozilla Firefox and Safari.
Opening the downloaded file
You have downloaded one or more delimited files, (if you downloaded the zip file see the panel on the right of this page), and the following instruction show you how to open them, one-at-a-time in Excel. The download files have a .LST extension and contain values separated with the pipe '|' character.
1. Open Excel
2. Click on the File > Open menu item
3. Locate and open your downloaded file. (Fig 2)
Figure 2
3. This will open the Text Import Wizard. Here you need to click on the Delimited radio button and then press the Next button (Fig. 3).
Figure 3
4. In the next window you need to ensure that the Other tick box is ticked and in the field to the right of it that the pipe character, is inserted. (Fig.4)
The pipe character consist of a single vertical line with a break in the middle and is normally found on the bottom left or right of your keyboard (Fig. 5). You may then click the Finish button and the file should load into Excel.
Figure 4
Figure 5
5. Your data will now be in Excel, but in order to make it more legible you can set each column to the a width large enough to accommodate the longest element in each field. To do this highlight all cells by clicking on the extreme top left of the worksheet, which will cause the entire workbook to be selected (see Fig. 6). Then simple click on the Format > Column > Auto-fit selection menu item.
Figure 6
Osteological database manual
The manual will provide details on all traits recorded onto the database and will allow you to understand the coding present on the data downloads. It is therefore strongly recommended that you download the database manual (PDF 194kb).
The pathological description may have abbreviations. please refer to the abbreviations and acronyms (Word 80kb) document for full details.
A zip file is a compressed or 'zipped' store of either a single document or a collection of files, making it easy to group files together for transporting, copying and saving disk space.
You need a zip compatible program to 'unzip' (decompress) the files.