Total aggregate calculation | OPC UA Standard | Forum

Lost password?

Home Forum OPC UA Standard Total aggregate calculation

Total aggregate calculation

Saurabh Deshpande

Member

Members

Forum Posts: 25

Member Since:
02/03/2016

Offline

05/10/2016 - 21:32

Hello,

Can some one please explain the aggregate calculation(mathematical) for "Total" aggregate for below input:

ProcessingInterval: 00:00:05

StartTime: 00:00:00

EndTime: 00:01:40

TimeStamp Value StatusCode
00:00:02 10 Raw_Good
00:00:25 20 Raw_Good
00:00:28 25 Raw_Good
00:00:39 30 Raw_Good
00:00:42 3 Raw_Bad
00:00:48 40 Raw_Good
00:00:52 50 Raw_Good
00:01:12 60 Raw_Good
00:01:17 70 Raw_Uncertain
00:01:23 70 Raw_Good
00:01:26 80 Raw_Good
00:01:30 90 Raw_Good

Note: This is Historian2 input data. The expected output is not matching with the output given in the Document 13.

Regards,

Saurabh

Paul Hunkar

Cleveland, Ohio, USA

Moderator

Members

Moderators-Specifications

Moderators-Companion

Moderators-Implementation

Moderators-Certification

Moderators-COM

Forum Posts: 109

Member Since:
02/24/2014

Offline

05/12/2016 - 00:33

Saurabh

The total aggregate is defined as

Total = TimeAverage x ProcessingInterval (seconds)

When looking at the results I'm not seeing a problem, can you be more specific as to what the problem is you are seeing?

the time average from time average section is:

12:00:00.000 10.652 UncertainDataSubNormal, Calculated, Partial
12:00:05.000 12.391 Good, Calculated
12:00:10.000 14.565 Good, Calculated
12:00:15.000 16.739 Good, Calculated
12:00:20.000 18.913 Good, Calculated
12:00:25.000 23.682 Good, Calculated
12:00:30.000 27.046 Good, Calculated
12:00:35.000 29.384 UncertainDataSubNormal, Calculated
12:00:40.000 33.889 UncertainDataSubNormal, Calculated
12:00:45.000 40 UncertainDataSubNormal, Calculated
12:00:50.000 49.450 Good, Calculated
12:00:55.000 52.750 Good, Calculated
12:01:00.000 55.250 Good, Calculated
12:01:05.000 57.750 Good, Calculated
12:01:10.000 60.618 UncertainDataSubNormal, Calculated
12:01:15.000 65 UncertainDataSubNormal, Calculated
12:01:20.000 70.515 UncertainDataSubNormal, Calculated
12:01:25.000 83.667 Good, Calculated
12:01:30.000 96.250 UncertainDataSubNormal, Calculated
12:01:35.000 108.750 UncertainDataSubNormal, Calculated

the totals - whcih are just 5x of the averages above appear to match up

12:00:00.000 31.957 UncertainDataSubNormal, Calculated, Partial
12:00:05.000 61.957 Good, Calculated
12:00:10.000 72.826 Good, Calculated
12:00:15.000 83.696 Good, Calculated
12:00:20.000 94.565 Good, Calculated
12:00:25.000 118.409 Good, Calculated
12:00:30.000 135.227 Good, Calculated
12:00:35.000 146.919 UncertainDataSubNormal, Calculated
12:00:40.000 169.444 UncertainDataSubNormal, Calculated
12:00:45.000 200 UncertainDataSubNormal, Calculated
12:00:50.000 247.250 Good, Calculated
12:00:55.000 263.750 Good, Calculated
12:01:00.000 276.250 Good, Calculated
12:01:05.000 288.750 Good, Calculated
12:01:10.000 303.091 UncertainDataSubNormal, Calculated
12:01:15.000 325 UncertainDataSubNormal, Calculated
12:01:20.000 352.576 UncertainDataSubNormal, Calculated
12:01:25.000 418.333 Good, Calculated
12:01:30.000 481.250 UncertainDataSubNormal, Calculated
12:01:35.000 543.750 UncertainDataSubNormal, Calculated

Am I missing something?

Paul

Paul Hunkar - DSInteroperability

Forum Timezone: America/Phoenix

Most Users Ever Online: 510

Currently Online:

Guest(s) 34

Currently Browsing this Page:
1 Guest(s)