![]() Save this new file as Fox8.wks and save another version as Fox8.Text (making sure that you select the text format. Create another new field which contains the sandstone/shale ratio. Enter Sandstone + Shale + Carbonate + Evaporite. Double click on the new field and select Number, General, 2 decimal places and Formula. Under Form select New Field and call the field Total Thickness. You can create new fields which are derived from existing fields. Do NOT use the name of the original file as this would replace the whole data set with the subset. If you want to save the subset then click on the box that says Save Selected Records Only and enter a suitable name. If you had a large data set and wanted to create a subset (a new file) of just those samples you can use the Save As command. Change the filter and obtain all samples with more that 100 feet of sandstone and less than 200 feet of shale. Sort the data by ascending values of Sandstone thickness. Remember that you have not eliminated the other rows of the matrix. Request all Sandstone values greater than 100. Spend some time getting familiar with the application. If you point at a column and hold down on the mouse button, you can drag the field and arrange the columns anyway you want. If you point at the top of the file (where the labels are located) you can drag the field boundaries. In general, when you import a file as a text file all of the columns are in text format. You should make sure that the thickness variables are in number format. ![]() Note that you can change the format and the position of the value in the field. Most Macintosh programs are similar and once you use one application it becomes easier to use another.ĭouble click on one of the fields in the matrix. The Text file will be imported into Cricket and DataDesk. It is good practice to keep a backup copy of your files. You might use the names Fox.Wks and Fox.Text. You can save your file as a Works file or as an ASCII (Text) file. Note that there are several options for saving. When you are finished save the file (command S). It will be worthwhile to check each value to make sure that they are in agreement with the handout. Enter the values as given on the handout. If you use the command L operation you will have a form in which you can enter the data. Enter the names of the columns (variables) as specified above. Open Works and select the database icon from the menu. Keep the handout sheet and the files that you produce during this exercise. A map showing the spatial distribution of these samples is provided on the handout sheet. Each column contains the value of (1) the sample number, (2) the U-axis, (3) the V-axis, (4) sandstone thickness, (5) shale thickness, (6) carbonate thickness and (6) evaporite thickness at each sample locality. Each row of the matrix contains information about a specific geographic location in the study area. Make sure that you save the files that you will prepare in this exercise as you will use them later on. We will use a stratigraphic data set assembled by William Fox as a part of his dissertation studies. Chances are they will be suitable.įor most of our work we will use DataDesk which will accept Works files as imports. ![]() ![]() If you have any questions about other applications please ask. This exercise is designed around Works and Cricket - these are not necessarily the best but they work reasonably well and are available on the departmental clusters. Or, you may have access to one package which performs all of these functions. You may decide to use one application (like Microsoft Works) for database manipulations and another (like Cricket Graph or Delta Graph) for display. Geochem Reading List Preparing a Data MatrixĮach of you should become familiar with database manipulations and graphing applications. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |