Resource data reader
CLEM.FileResource
Reads external resource input and output data

The Data reader components are used to read external data for use by CLEM. They can be placed anywhere within the simulation branch of the APSIM simulation. It is recommended to place them with the activities using them or below the CLEM component.
This Data reader is used to read general resource inputs.

The following parameters are used to define this component

The name of the data file. Include the full path of the database if not contained in the same folder as the APSIMX file.
This reader can read delimited ASCII text files or Excel spreadsheets.
The specified file cannot be open some other applications (e.g. Excel) when you run your simulation.

Name of the excel worksheet containing the crop or forage data if reading an Excel spreadsheet.
This property is ignored when not reading spreadsheets and can be left blank.
The following columns are expected in the table. The column name referring to the data can be supplied such that any table can be used to provide data.
Each row of the table must contain a year and month column, with resource name and amount columns.

The name of the column in the specified table identifying the resource to be used.
Default: ResourceName
Two formats are accepted in this data column
- The name given to the resource in the simulation tree assuming it is unique across all stores in the Resource holder
- The full name of the resource including the name of the resource store followed by the resource name, separated by a full stop. ResourceStoreName.ResourceTypeName

The name of the column in the specified table containing year data.
Default: Year

The name of the column in the specified table containing month data.
Default: Month

The name of the column containing amount provided or taken from the resource in the month. This is assumed to be in the units specified by the particular resource.
Default: Amount
Format for this data column
Positive values represent an input of the resource (gain)
Negative values represent an output of the resource (loss)


Text files should be provided as Tab delimited

The following conditions must be met
- Column names in excel files cannot contain spaces
- There must not be any extra details (e.g. text) other than empty records in rows and columns outside the data area of the spreadsheet.
See also