General: How to fill a BEFdata Workbook

Usage Rights

This data is Free for public.

Here you can specify the intended usage. But during upload you still have the choice to open the dataset to members of the project, members of the portal, or to the public.

Dataset Abstract

The BEFdata portal allows to import research data directly from an Excel 2003 workbook. To get most out of the workbook, it's good to know that the "General Metadata" sheet saves dataset ownership, as well as general information of where, how, and why data was sampled. The data can belong to a project and will then be displayed on this project's data set list. It can belong to members of the portal, then these will be asked if someone requests this file for analysis.

Dataset Design

Describe, what was the design of your campaign. How many objects in what groups did you sample? Did you sample along gradients like diversity or successional age? Did you place your samples randomly, selected trees at random or in a stratified random design?

Spatial Extent

This is for the location where all the data comes from


If your data has been published already, you can give citation and doi here.

Temporal Extent

Often, date is not provided in the data itself. So here you can describe when the data was derived. This applies to analysis performed with your data. So individual height of a tree will change from year to year, so it is good to know, when the measurement was taken.

Taxonomic Extent

You can list your organism taxa or state that no organisms were used. You can also specify the column in raw data where the organisms are named.

Measurement Circumstances

Are there circumstances that explain the precision of your measurements? Could it be that a sandstorm destroyed part of the plots in a given year?

Data Analysis

Here you can tell the reader, which columns were the response and which columns in the raw data were explanatory variables. You can also indicate, what the main response means in term of ecosystem functioning. The main response column may be the abundance of tree species, the size of trees derived from dbh and height, or the kinetic energy of raindrops passing through forest canopy.

Data columns available in the raw data part of this dataset

example of a category data column
Data group: Data group
Keywords: data portal
this is a column storing numbers. You can use the definition field to give as much information as is needed to understand, what has been done.
Data group: Data group
this is a text column; Especially if the Data groups are used for a broad range of measurements, it makes sense to provide additional information in the column definition
Data group: Data group
this is a date column; We provide three different types of dates: dates recognized in Excel are given to other software usually in the form "date(2009-07-14)", but you can also use the form "date(14.07.2009)" or just a 4 digit year, then specifying "year" in Data type
Data group: Data group