archivemsp

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 this functions an automatic change of values or times of an archive entry can be made by addition of a constant to the value. The value is read-in and shown in the report with the appropriate manipulation. The corrected values can be saved with Save archive.

Attention

With every Save archive the values are corrected by the defined constant!

Parameter:

Archive variable	Archive variable number
Contents	value, status, time, count
direction	"right" or "bottom"
P1	Number of archive values in the first row
P2	Empty cells between two value outputs
P3	Empty cells until the next value row
P4	Constant with sign, decimal places with ".";

Syntax: =archivemsp(ArchivVariable,"parameter,"direction",P1,P2,P3,P4)

Example

=archivemsp(4,time,right,16,1,0,-0.5)

All time entries in an archive row are corrected for 30 seconds.