Snapshot

Snapshot is used to create and insert a Formula to get the latest value and status 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

Start Time can be omitted.

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.

Options

As default, all options are selected.

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.