History

History is used to create and insert a Formula to get a range of values and statuses of given tag(s).

Parameters

Tag Name

User can insert tag name(s) in three different ways:

• By typing it manually
• By searching for tags with the button
• By binding tag names from cells by clicking on the button

When typing the tag name(s) manually, user has to type either single quotation mark (’) or double quotation mark (") first and the the tag name and use comma to separate multiple tags. Without the quotation marks, MOPS 4.0 Excel Add-In will interpret it as a cell reference and will try to get a value from it.

Start and End Time

Start and End time can be added in three different ways:

• By typing it manually, either as a date or in the OPC-format
• By selecting a date from the date time picker
• By binding date or OPC expression from cells by clicking on the button

Number of Values

Will limit the amount of values to be fetched.

Resolution

Determines the resolution of the data set, default (empty field) is RAW.

Show Advanced Parameters

This will show additional parameters.

Advanced Parameters

This section will go through the parameters that will be shown when Show Advanced Parameters is selected.

Interpolation Method

How Interpolation of data is done. May be Weighted, Extright, Extleft, Extcenter, Interpolated, Exacttime or Aggregate. If missing, Weighted is used. If Resolution = RAW, it is ignored. If Aggregate, see Aggregate Type parameter below. Exacttime only return data if RAW point exists at exact interval time.

Aggregate Type

If Interpolation method (see Interpolation method parameter above) is set to Aggregate this parameter is used. Some Aggregate Types are mutually exclusive (meaning that not all Aggregate Types can be combined).

Status Filter

Specify the values to be returned that DO NOT have the specified statuses.

Statuses can either be selected from the list and multiple statuses can be selected or by binding statuses from cells by clicking on the button. By selecting None, the status selection will be cleared.

Bounding

If set to true, fetch one extra value beyond StartTime and EndTime if they exist.

Alignment

Timestamp alignment for returned intervals when Resolution not set to RAW. May be RIGHT (newest), LEFT (oldest) or CENTER. Default is RIGHT

Edges

Specifies which values to include if they lie on the sample period edge exactly. May be RIGHT (newest), LEFT (oldest) or BOTH. Default is RIGHT.

Elements

A comma-separated list of elements to retrieve for profile tags. If no value given, all elements will be fetched.

Options

As default, all options are selected except Cross-Tabular.

Cross Tabular

Cross Tabular will pivot the data to show tags in columns and the values in rows accordingly to the timestamps.

Show Header

This option determines if the Header should be shown or not in the spreadsheet.

With header:

Without header:

Show Tag Name

This determines wether the tag name should be shown or not.

Show Status

This determines wether the status should be shown or not.

Show Status as String

This determines wether the status should be shown as a string or as a bit value.

Shown as string:

Shown as bit value:

Show Timestamp

This determines wether the timestamp should be shown or not.

Newest First

This determines the sort order of the data set by date when multiple tags are included.

Orientation

This determines how the data set should be presented in the spreadsheet, either Horizontal or Vertical.

Horizontal presentation:

Vertical presentation:

Show Empty Value As

This will determine if an empty or missing value should be shown as “N/A” or as an empty cell.

Insert Formula

When clicking the Insert Formula button, all the parameters and options that has been selected will be inserted to the selected cell and the data set will populate the spreadsheet.

As it can be seen in the following image, there is a formula shown in the formula bar.

The formula can either be edited manually or by clicking on the cell, where the formula was first inserted, and the task pane will be populated with all the parameters and options from that formula to be edited and inserted again.