User Tools

Site Tools


time_series_page

This is an old revision of the document!


Time Series

Many models require time dependent data such as temperature, release rates and precipitation. This screen lists all available time dependent variables and lets you assign values for them.

User interface

To the left is a listing of all available time series. When you select a time series, information, settings and values for the variable is displayed in the table to the right.

The list of time series

The list presents all available time series. Below the list is a section where you can filter out items from the list:

  • Name - Enter the name, or part of the name.
  • Category - Select a category for the time series. The categories are part of the model, so this list is empty unless the model creator has assigned categories to the options.
  • Sub-system - Select a sub-system to only display time series for a specific model component.

Assigning time dependent data

Information

The information section details specifics about the time series. The description box can give you information about the data to enter, and the unit box tells you which unit is expected for the data.

Settings

Interpolation - The interpolation field will determine how values before, between and after the time-points are interpolated/extrapolated.

  • Linear – Values between the specified time-points are linearly interpolated.
  • None – Time-points will not be presented in a form of a step function.

Mode - the Mode will determine the time mode for data that is being entered in the Time Series. User can choose between continual time mode options:

  • Date
  • Year

..or between periodic data options, such as:

  • Month
  • Day of year
  • Day of month
  • Day
  • Hour
  • Minute
  • Second

Entering data

The data table is organized with the time points in the first column and data in the subsequent column(s). For scalar data, such as temperature or precipitation, data is put in the default column. The chart below the table will display the data as you enter it.

Note that time series typically begin at 0. This means, that for year 1, you enter 0. For year 2 you enter 1, etc.

For small data sets, the easiest way is to enter the data directly in the table. For large data set, the easiest way is typically to import it (see below).

The default row

When you enter data for a multidimensional time series, such as a release rate of contaminants, there is a column for each index (contaminant). If you wish to assign the same data for several contaminants, you can put it in the default column. A value set in the default column will be used for all indices, but can be overridden by entering values in the subsequent columns.

Importing and exporting data

There are several ways to import data into the tool.

  1. By copy-paste from another tool, such as Excel.
  2. By importing values from an Excel file.

Copy-paste

  1. Organize the data in Excel, so that the table in Excel matches the columns in the data table.
  2. Select the rows and columns in Excel, right-click and select copy.
  3. Select the first cell in the data table. This is the top-left cell, where the first value should be put.
  4. Right-click and select Paste from the menu.

Importing Excel data

The Excel data sheet must be formatted in a way so that Ecolego Player can read it. The best way is therefore to first export the table (which would be empty) to an Excel file, transfer the data to the file in Excel by copy/paste, and then importing the file back into Ecolego Player.

  1. Select the target time series in the list.
  2. Click on the Export button.
  3. Enter a name for the Excel file, and choose whether to export as Excel or Excel 2007 (with the extension .xslx).
  4. Open the file in Excel.
  5. Changing only the data in the columns (not the sheet name, nor the names of the columns), populate the sheet by either entering data in Excel or by copy-paste from other Excel documents. It is allowed to use formulas, as long as the data is available inside the same file and no scripts are used.
  6. Save the file.
  7. Click the Import button. Select the file and click ok.

References

time_series_page.1636970975.txt.gz · Last modified: 2021/11/15 11:09 by mina