archivew

As a help for the definition this function can be selected from the menu entry Format/Functions (or with the right mouse button on the cell).

With the use of these functions, the archive entries read-in are not shown in the report. On saving, the archive entries are overwritten with values and stati existing at other places (e.g. calculated).

On entering the status texts (independent of whether the statuses are input fixed or read-in from another cell) the defined short texts from the "ZENON.INI" file or from the internal system default configuration must be given. With several statuses they must be separated by ",".

The calculated values are updated regardless of whether the newly calculated value has changed in comparison to the read-in value. The status is changed to "Hand value".

The configuring is not done via the input help but directly in the cell.

Parameter:

Start-cell values

Starting cell, relative to which the calculated values lie.
Status text input Input of a fixed status text (e.g. MVALUE) or the starting cell from which the status text should be taken.

Syntax: =archivew(ArchiveVariable,contents,direction,Start cell value,Status text)

Example

=archivew(4,value,bottom,B12,C12)

?In a month report with dayly values it is calculated, on how many days a limit x was violated. The sum of the limit violations is written into a cell of the report. For an archive a value was defined, that gets one entry per month. This entry is read into the report via archivew(...), the parameter "Start cell value" points to the calculated cell. On saving the archive values the sum is written onto the archive value. The monthly sum of the limit violations is available e.g. for reduction to yearly values as an archive value.