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

Page 355

Advertising
background image

Micro-PWC CONFIGURATION GUIDE

Appendix A - Excel Functions 335

The fpblkarch( ) Function

Function Name

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

Synopsis

double *fpblkarch(double flag)

Description

The

fpblkarch() function is used in a spreadsheet to switch between the Historical Block Archival

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

Inputs

Outputs

None.

Returns

The current value of the archival flag.

Example

This example selects the Historical Block Archival database as the source for data retrieval.

In Microsoft Excel:

=fpblkarch(1)

Parameter

Description

flag

Use 1 to select the Historical Block Archival database for
data retrieval, or use 0 to select the Historical Block data-
base.

Advertising