Personal tools
You are here: Home Documents HOWTO The contribution spreadsheet

The contribution spreadsheet

A detailed explanations about how to fill in a correct way a contribution spreadsheet.

Fill the wwhypda contribution spreadsheet is an easy task, but it should be done with care..

General rules

White cells

white cells
  • You can modify only white cells (the other cells are protected).
  • If you select them, a comment will appear in order to help you to fill in its content.
  • On the right ( grey cells) there are also additional comments and examples.
  • The color of the left cell is green when the field of the corresponding white cell is required, yellow when a content is not required(but if you have more information, please add them).
  • Many cells values are validated by the spreadsheet: please follow the suggestions in the messages box.
  • When the cell does not contain a drop down box, you can fill it with your content; when a cell contains a drop down box, please select one of the options. If there is not a suitable option for your case, please contact the site administrator. However, some drop down lists allow to add a custom field: just add your option, and if there is no message box, your option will be stored in the database and reviewed in order to eventually add it to the default options in the drop down list.

Green cells

Green cells

Fill all the fields on the right of these cells, they are required.

Yellow cells

Yellow cells

The field on the right of these cells is optional, but if you have the information please add them.

Grey cells

Grey cells

These cells contains suggestion and examples about how to fill the white cells.

What insert in each field?

In the following subsections, corresponding to the 5 input boxes of the spreadsheet, suggestions are provided about "How to fill" the white fields.

Site Informations

site_name   A reference name for the measurement site. If in the future you will add measurement related to the same site, please refer to the same name.

region  Add here information about the region where the measurements were made.

country_name   The country where the measurement were made.

longitude and  latitude  Enter here the coordinates of your measurement site (for example where it is centered). Please use decimal degrees.
To convert your data from degrees, minutes, seconds to decimal you can for example use this link

General information about measurements

env_name  Select here an hydrogeological environment from the drop-down list.
If the list does not contain an environment in line whith your site, you can add your own environment. Your environment will be reviewed and eventually added to the list of available environments. Another way to include an environment in agreement with your needs is to contact the site administrator and propose a new environment for the environments catalog.

review_level  Select here the level of review endured by your measurements.

Source of information

This section is devoted to all the information related to the paper, the technical report or the thesis which contains the measurements.

authors  Please insert here the authors of the source. Please use the standard format showed in the example:

For example Ankeny M.D.,M. Ahmed, T.C. Kaspar, and R. Horton

title  The title of the source.

For example Simple field for determining unsaturated hydraulic conductivity .

source  The journal or in general "the source" of the paper or of the techical report.

For example Journal of Contaminant Hydrology, Vol. 91, Issues 3-4, 14 May 2007 .

year_Source  The year of pulication (or of completion) of the paper (or technical report, thesis...).

For example 1991 .

pages  The reference pages.

For example 445-462 .

doi  The digital  object identifier® of the source. For more details follow this link.

An example of DOI: 10.1007/s10040-004-0432-3.

source_link  A link to the source. Even if the references are not stable (at the contrary of the DOI®), it is useful to provide a link to have access to the complete document (if available).

For example or something like http://domain/.../document.pdf.

Measurement "Sample"

For sample we mean for example a core of and earth material analyzed in a laboratory or the region of an aquifer which is affected by a pumping test. On the same sample many parameters can be measured. For this reason the information which is shared by the same "sample" is regrouped in this section, and the details about the measurement should be included in the following section ("Measurements")

smpl_name  The sample name. You can leave the default value: it will appear in the section Measurements (id_smpl box) in order to provide a reference to the sample. You can also define in this box a custom name for your samples: in any case it will be added to the drop-down box in the section Measurements (id_smpl box). If you use your custom names, please provide unique names!
If your measurement source contains more samples than the number of samples available in the spreadsheet, please add the remaining information into another spreadsheet.

rock_type  The earth material which composes the measured sample. Here the drop down list proposes a variety of earth material. We suggest to select one earth material among the materials listed, but you can always add your own material. In this case, the same approach of the environments is applied.

scale  The reference scale of the sample. Five scale values are available:

-- unknown -- unknown scale value
micro lengths < 1 m
macro 1 m < lengths < 10 m
meso 10 m < lengths < 100 m
mega lengths > 100 m

fracturation_degree  The degree of fracturation of your sample. The available degrees are: null, low, medium, high (and -- unknown --).

Sample_comment A comment about the sample.


id_smpl  Select here the ID of the sample to which the measurement is related

param_name  Select here the name of the measured parameter. If you measured a parameter which is not listed, please contact the site administrator.
If you look for the definitions of the parameters, please consult this page

msr_value The measurement value. Please use the International System of Units. When the measured parameter is selected, the units are showed in the column units.

error  If the measurement value is obtained as mean value of many measurements, insert here the associated uncertainty, otherwise insert an estimate of the uncertainty related to the measurement technique and interpretation.

quality  Express here your advice about the quality of the measurement.

Experiment_type  Select here the experimental procedure adopted to obtain the measurement. Choose among the proposed methods, or if your method is not included add the method you adopted: it will be reviewed and eventually included in the default drop down list.

Interpretation_method Select here the interpretation used to analyze the data. For example, if you selected as experiment type a pumping test, then the results can be interpreted with different models. If in the drop down list you can't find an interpretation method suitable for your experiment type, please add a custom interpretations method (the same considerations made for the Experiment_type apply).

ms_comment  A comment about the measurement.

Document Actions

wwhypda is © 2006-2019 by the University of Neuchâtel and chyn      -:-:-      about      -:-:-      contact      -:-:-      Terms of Use