Voted best answer

I recommend using Excel and DataDirect which can read online OPC server values and from configured property logs running in a historian, eg Basic History.

1. ABBGetOPCDA() return current value from the OPC server.

2. ABBGetOPCHDA() can read from any property log (possibly with additional aggregate).

A lot can be prepared by implementing a suitable log hierarchy and selection of log aggregates.

Eg a secondary log with Min Time = 1 hour and TimeAverage would reduce the work required in DataDirect down to reading just one single value with ABBGetOPCHDA(). The log will also have the averaged values nicely aligned on even hours.

The primary log will contain the most recent values in case it is necessary to have them (hence, you should be able to survive on HDA functions alone which offload the OPC server and anyway should be quicker than using "online" DA functions).