A.1 the fparchive( ) function, The fparchive( ) function – Micromod Micro-PWC: 53PW6000 MicroPWC Configuration Guide User Manual

Page 351

Advertising
background image

Micro-PWC CONFIGURATION GUIDE

Appendix A - Excel Functions 331

The fparchive( ) Function

Function Name

fparchive( ) - switch data retrieval from the Historical database to the Archival database

Synopsis

double fparchive (double flag)

Description

The

fparchive() function is used in a spreadsheet to switch between the Archival and the

Historical database to retrieve values. The same function calls used on the Historical database are
used on the Archival database to retrieve data.

Inputs

Outputs

None.

Returns

The current value of the archival flag.

Example

In Microsoft Excel:

=fparchive(1)

Parameter

Description

flag

Use 1 to select the Archival database for data retrieval or
use 0 to select the Historical database.

Advertising