Historical database functions are inserted
into spreadsheet cells by FunctionBuilder™ to provide
the following data in your reports:
 |
| ReportBuilder™
FunctionPack™ Functions |
ReportBuilder™
FunctionPack™: |
iHistorian Functions |
National Instruments Lookout
Citadel Log Functions |
Database Logging Functions |
Database
Summary Functions |
Datapoint Logging Functions |
Intellution FIX Historical
Log Functions |
| For use with: |
Any SCADA system logging
via iHistorian |
Lookout System by National
Instruments logging to a Citadel Database |
FactoryLink database logging,
Cimplicity, RSView, RSSQL,
Entivity,
MS Access, MS SQL |
FactoryLink Datapoint logging,
MS Access, MS SQL |
InTouch historical log
files via ODBC, MS Access, MS SQL |
FIX32 &
iFIX historical log files via ODBC. |
| Max value and time of occurrence |
|
|
|
|
|
|
| Min value and time of occurrence |
|
|
|
|
|
|
| First value and time of
occurrence |
|
|
|
|
|
|
| Last value and time of
occurrence |
|
|
|
|
|
|
| Count of values |
|
|
|
|
|
|
| List values |
|
|
|
|
|
|
| Sum of values |
|
|
|
|
|
|
| Standard Deviation |
|
|
|
|
|
|
| Starts |
|
|
|
|
|
|
| Stops |
|
|
|
|
|
|
| Elapsed Time |
|
|
|
|
|
|
| Quality |
|
|
|
|
|
|
| List Points |
|
|
|
|
|
|
| Maximum Count |
|
|
|
|
|
|
| Time Good |
|
|
|
|
|
|
|
