archiveex

Previous chapterNext chapter Show allShow all    Hide allHide all

Syntax: =archiveex(FILTERINDEX,PARAMETER,DIRECTION,STATUS,ALTERNATETEXT,NN_TEXT,NN_ALTERNATEVALUE,CYCLEOFFSET)

Transfer parameters

Valid range

Comment

FILTERINDEX

Corresponding archive variables from report filter

PARAMETER

value, status, time, count

The selected parameter is read from the archive and displayed

DIRECTION

bottom, right

Filling in the stated direction

STATUS

SPONT,HWERT, I-BIT

Status of the values to be displayed

ALTERNATETEXT

Text to be displayed, if the status of the archive variables does not correspond with "STATUS"

ND_TEXT

Text for the "Non-dedectability limit"; not case-sensitive

ND_ALTERNATEVALUE

Cell reference or entered value are possible. If in die the "ALTERNATETEXT" is displayed in the cell and then the report is saved, the "ND_ALTERNATEVALUE" is written into the archive.

CYCLEOFFSET

Only valid for filter types "Time-Day; Time-Month; Time-Year; Time-Week;Time-2Weeks; Time-15min.; Time-30min.; Time-60min."

Example Example

=archiveex(1,"time","bottom","SPONT,HWERT","-","NN",G2,-2)