MERLIN-Expo Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====Introduction====

The Excel file format is designed in a way so that it is readable for both machines and people, and the same format is used for both [[parameter|parameters]], [[lookup table|time series]] and [[general variable|options]]. For simplicity this page will refer to them all as parameters.

To make things easier when importing values, it is highly recommended to create a template file by exporting the values from MERLIN-Expo. The values in the template are then replaced with real values and the file can then be imported back into MERLIN-Expo.

Simple formulas can be used when entering values. 

When read by MERLIN-Expo, the tabs (sheets) are read from first to last. Each sheet can contain two sections; [[#definitions]] and [[#values]]. The definitions which have been read on one sheet will be remain in memory when the next sheet is read, so that all the definitions can be stored in the first sheet and subsequent sheets need contain only values. 

===Definitions===

A parameter is identified primarily by its name. The definitions section lists the names of parameters for which data is stored in the Excel file. It also lists the [[dependency|dependencies]] of each parameter, the unit, the description and other properties which is shared for all values of the parameter.

A parameter name may not be defined more than once in the entire Excel file. 

  * **Name** - The [[name]] of the parameter.
  * **Dependencies** - A comma-separated list of the [[dependency|dependencies]] of the parameter. 
  * **Unit** - The [[unit]] of the parameter.
  * **Full name** - The [[full name]] of the parameter, used in favour of the name when listing parameters.
  * **Description** - The [[description]] of the parameter.
  * **Category** - The [[category]] of the parameter.
  * **Symbol** - The [[symbol]] used when displaying the parameter in an equation.
  * **Author** - The person who created the parameter definition.

===Values===

The values section contain the actual data for the parameter and is divided into sub-sections. Each row of the values section correspond to values for one dependency of one one single parameter (for time series, each row corresponds to one time point).

A parameter value is identified by the [[name]], the [[index|indices]]. If the same parameter is used in several [[sub-system|sub-systems]] - for instance if two soil [[sub-system|sub-systems]] have been added to the model - the [[tag]], [[id]] or [[guid]] of the [[#Export info]] sub-section is used to identify the parameter.

==Parameter==

The **Parameter** sub-section always contain two columns:

  * **Name** - The [[Name|name]] of the parameter (as listed in the definition section).
  * **Unit** - The [[Unit|unit]] of the parameter (as listed in the definition section)

==Dependencies==

These columns are used for [[Index|indices]] of the value. The number of columns depend on the dependencies of each parameter as listed in the definition section. This means that there might be columns which are relevant only for some parameters. 

==Data== 

This section contains the values entered for the parameter, the [[PDF]] excluded. The number of columns depend on how what data is available for the parameters. The following columns are of special interest:

  
  * **Value** - The (nominal) value of a parameter
  * **Lookup data** - The "x" value of a [[Lookup table|time series]], typically time. 
  * **Values** - The "y" value of a [[Lookup table|time series]]
  * **Cyclic** - Whether the [[Lookup table|time series]] is cyclic or not (TRUE or FALSE)
  * **Interpolation** - Lookup interpolation (see [[lookup table]] for more information.
  * **Expression** - The selection of an [[general variable|option]].

==Distribution==

The distribution section appears only when the sheet contains parameters that have been assigned [[PDF|PDF's]].  

The first column is always **PDF**, which contains the name of the [[PDF]] with arguments within parenthesis. 

The number of columns that follow depends on the arguments of the [[PDF|PDF's]] - there will be one column for every type of argument. 

Example:

^ PDF ^ Max ^ Min ^ Mean ^ Mode ^ Std. Dev. ^
| triang(min,max,mode) | 17 | 8 | | 12,7 | | 
| unif(min,max) | 0,4 | 0,1 | | | |		
| logn(mean,sd)	| | | 0,035 | |0,006 |
 
==References==
This section details the source of values that are entered.

  * **References** - Literature references 
  * **Comments** - Comments

==Export info==

The last column of the values section is used as the final link between a specific [[parameter]] and the row. This section is generated by the software, and it is important that you pay attention to what is written here if you copy/paste rows while working in Excel.

  * [[Tag|Tags]] - Tags that identify the [[parameter]]. Note that the [[sub-system]] and [[scenario]] will be listed here. 
  * [[GUID]] - A unique global identifier for the parameter.
  * [[ID]] - The full path to the [[parameter]] in the model.
  * Type - The type of [[block]] (eg. [[parameter]] or [[lookup table]].

====See also====

  * [[Importing and exporting data]]