View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
000618710000-013: AggregatesSpecpublic2020-10-28 19:382021-12-09 15:49
ReporterArchie Miller Assigned ToRod Stein  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version1.05.02 RC1 
Summary0006187: TimeAverage2:Historian1 requires updates as per Get Time Weighted Status
Description

The TimeAverage2 data for Historian1 requires updating after further review of Part 9 5.4.3.2.1 regarding Time Weighted status codes.

TreatUncertainAsBad = False then Uncertain regions are included with the Good regions when calculating the above ratios, if the TreatUncertainAsBad = True then the Uncertain regions are included as Bad regions.

The original test tool makes no allowance for Uncertain regions as described above. The CTT test tool calculations has been reworked to follow the spec.

Detailed Calculations from both the original tool and the CTT implementation can be found in the attached TimeAverage2-Historian1.csv spreadsheet.
It should be noted that the calculations from the original tool and the CTT implementation calculating the same Simple Bound Results, region duration are identical. Changes can be isolated to calculating the time weighted status code from the regions.

Historian1
Timestamp Value StatusCode Updated Status Code
12:00:00.000 BadNoData
12:00:05.000 BadNoData
12:00:10.000 12.500 Good, Calculated
12:00:15.000 17.500 Good, Calculated
12:00:20.000 22.500 Good, Calculated
12:00:25.000 27.500 Good, Calculated
12:00:30.000 30 UncertainDataSubNormal, Calculated Good, Calculated
12:00:35.000 30 UncertainDataSubNormal, Calculated Good, Calculated
12:00:40.000 BadNoData
12:00:45.000 BadNoData
12:00:50.000 52.500 Good, Calculated
12:00:55.000 57.500 Good, Calculated
12:01:00.000 62.500 UncertainDataSubNormal, Calculated Good, Calculated
12:01:05.000 67.500 UncertainDataSubNormal, Calculated Good, Calculated
12:01:10.000 72.500 UncertainDataSubNormal, Calculated Good, Calculated
12:01:15.000 77.500 UncertainDataSubNormal, Calculated Good, Calculated
12:01:20.000 82.500 Good, Calculated
12:01:25.000 87.500 Good, Calculated
12:01:30.000 90 UncertainDataSubNormal, Calculated, Partial Good, Calculated, Partial
12:01:35.000 BadNoData
TagsNo tags attached.
Attached Files
TimeAverage2-Historian1.csv (12,372 bytes)    
Historian1,TimeAverage2
Stepped Interpolation,False
Sloped Extrapolation,False
TreatUncertainAsBad,False
PercentGood,100
PercentBad,100
Raw,Raw Value,Raw Status,Timestamp,Index,Original Simple Values,Current Simple Values,,Original Durations,Current Durations,,Original Calculation,Current Calculation,,Original Result,Current Result
,,,12:00:00,0,
,,,,,,,,,,Good Duration,,
,,,,,,,,,,Bad Duration,,
,,,,,,,,,,Total Duration,,
,,,,,,,,,,Status,"",""
,,,,,,,,,,,,,Time,12:00:00,00:00:00
,,,,,,,,,,,,,Value,(null),Null
,,,,,,,,,,,,,Status,"BadNoData","BadNoData (0x809b0000)"
,,,12:00:05,1,
,,,,,"12:00:05 (null) BadNoData","00:00:05 Null BadNoData (0x809b0000)"
,,,,,"12:00:10 10 Good","00:00:10 10.000 Good (0x00000000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:05 AM,00:00:05
,,,,,,,Start Value, 0,0
,,,,,,,End Value, 10,10
,,,,,,,Status, "BadNoData","BadNoData (0x809b0000)"
,,,,,,,,,,Good Duration,,
,,,,,,,,,,Bad Duration,,
,,,,,,,,,,Total Duration,,
,,,,,,,,,,Status,"",""
,,,,,,,,,,,,,Time,12:00:05,00:00:05
,,,,,,,,,,,,,Value,(null),Null
,,,,,,,,,,,,,Status,"BadNoData","BadNoData (0x809b0000)"
12:00:10,10,"Good",12:00:10,2,
,,,,,"12:00:10 10 Good","00:00:10 10.000 Good (0x00000000)"
,,,,,"12:00:15 15 Good [0402]","00:00:15 15.000 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:10 AM,00:00:10
,,,,,,,Start Value, 10,10
,,,,,,,End Value, 15,15
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,,,,Good Duration,5000 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"Good","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:00:10,00:00:10
,,,,,,,,,,,,,Value,12.500,12.500
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:00:15,3,
,,,,,"12:00:15 15 Good [0402]","00:00:15 15.000 Good (0x00000402) - Limit None"
,,,,,"12:00:20 20 Good","00:00:20 20.000 Good (0x00000000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:15 AM,00:00:15
,,,,,,,Start Value, 15,15
,,,,,,,End Value, 20,20
,,,,,,,Status, "Good [0402]","Good (0x00000402) - Limit None"
,,,,,,,,,,Good Duration,5000 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"Good","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:00:15,00:00:15
,,,,,,,,,,,,,Value,17.500,17.500
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
12:00:20,20,"Good",12:00:20,4,
,,,,,"12:00:20 20 Good","00:00:20 20.000 Good (0x00000000)"
,,,,,"12:00:25 25 Good [0402]","00:00:25 25.000 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:20 AM,00:00:20
,,,,,,,Start Value, 20,20
,,,,,,,End Value, 25,25
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,,,,Good Duration,5000 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"Good","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:00:20,00:00:20
,,,,,,,,,,,,,Value,22.500,22.500
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:00:25,5,
,,,,,"12:00:25 25 Good [0402]","00:00:25 25.000 Good (0x00000402) - Limit None"
,,,,,"12:00:30 30 Good","00:00:30 30.000 Good (0x00000000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:25 AM,00:00:25
,,,,,,,Start Value, 25,25
,,,,,,,End Value, 30,30
,,,,,,,Status, "Good [0402]","Good (0x00000402) - Limit None"
,,,,,,,,,,Good Duration,5000 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"Good","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:00:25,00:00:25
,,,,,,,,,,,,,Value,27.500,27.500
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
12:00:30,30,"Good",12:00:30,6,
,,,,,"12:00:30 30 Good","00:00:30 30.000 Good (0x00000000)"
,,,,,"12:00:35 30 UncertainDataSubNormal [0402]","00:00:35 30.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:30 AM,00:00:30
,,,,,,,Start Value, 30,30
,,,,,,,End Value, 30,30
,,,,,,,Status, "UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Good Duration,0 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:00:30,00:00:30
,,,,,,,,,,,,,Value,30,30.000
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","Good (0x00000401) - Limit None"
,,,12:00:35,7,
,,,,,"12:00:35 30 UncertainDataSubNormal [0402]","00:00:35 30.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,"12:00:40 40 Bad","00:00:40 Null Bad (0x80000000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:35 AM,00:00:35
,,,,,,,Start Value, 30,30
,,,,,,,End Value, 30,30
,,,,,,,Status, "UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Good Duration,0 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:00:35,00:00:35
,,,,,,,,,,,,,Value,30,30.000
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","Good (0x00000401) - Limit None"
12:00:40,40,"Bad",12:00:40,8,
,,,,,"12:00:40 40 Bad","00:00:40 Null Bad (0x80000000)"
,,,,,"12:00:45 (null) BadNoData","00:00:45 Null BadNoData (0x809b0000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:40 AM,00:00:40
,,,,,,,Start Value, 0,0
,,,,,,,End Value, 0,0
,,,,,,,Status, "Bad","Bad (0x80000000)"
,,,,,,,,,,Good Duration,,
,,,,,,,,,,Bad Duration,,
,,,,,,,,,,Total Duration,,
,,,,,,,,,,Status,"",""
,,,,,,,,,,,,,Time,12:00:40,00:00:40
,,,,,,,,,,,,,Value,(null),Null
,,,,,,,,,,,,,Status,"BadNoData","BadNoData (0x809b0000)"
,,,12:00:45,9,
,,,,,"12:00:45 (null) BadNoData","00:00:45 Null BadNoData (0x809b0000)"
,,,,,"12:00:50 50 Good","00:00:50 50.000 Good (0x00000000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:45 AM,00:00:45
,,,,,,,Start Value, 0,0
,,,,,,,End Value, 50,50
,,,,,,,Status, "BadNoData","BadNoData (0x809b0000)"
,,,,,,,,,,Good Duration,,
,,,,,,,,,,Bad Duration,,
,,,,,,,,,,Total Duration,,
,,,,,,,,,,Status,"",""
,,,,,,,,,,,,,Time,12:00:45,00:00:45
,,,,,,,,,,,,,Value,(null),Null
,,,,,,,,,,,,,Status,"BadNoData","BadNoData (0x809b0000)"
12:00:50,50,"Good",12:00:50,10,
,,,,,"12:00:50 50 Good","00:00:50 50.000 Good (0x00000000)"
,,,,,"12:00:55 55 Good [0402]","00:00:55 55.000 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:50 AM,00:00:50
,,,,,,,Start Value, 50,50
,,,,,,,End Value, 55,55
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,,,,Good Duration,5000 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"Good","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:00:50,00:00:50
,,,,,,,,,,,,,Value,52.500,52.500
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:00:55,11,
,,,,,"12:00:55 55 Good [0402]","00:00:55 55.000 Good (0x00000402) - Limit None"
,,,,,"12:01:00 60 Good","00:01:00 60.000 Good (0x00000000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:55 AM,00:00:55
,,,,,,,Start Value, 55,55
,,,,,,,End Value, 60,60
,,,,,,,Status, "Good [0402]","Good (0x00000402) - Limit None"
,,,,,,,,,,Good Duration,5000 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"Good","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:00:55,00:00:55
,,,,,,,,,,,,,Value,57.500,57.500
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
12:01:00,60,"Good",12:01:00,12,
,,,,,"12:01:00 60 Good","00:01:00 60.000 Good (0x00000000)"
,,,,,"12:01:05 65 UncertainDataSubNormal [0402]","00:01:05 65.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:01:00 AM,00:01:00
,,,,,,,Start Value, 60,60
,,,,,,,End Value, 65,65
,,,,,,,Status, "UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Good Duration,0 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:01:00,00:01:00
,,,,,,,,,,,,,Value,62.500,62.500
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","Good (0x00000401) - Limit None"
,,,12:01:05,13,
,,,,,"12:01:05 65 UncertainDataSubNormal [0402]","00:01:05 65.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,"12:01:10 70 Uncertain","00:01:10 70.000 Uncertain (0x40000000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:01:05 AM,00:01:05
,,,,,,,Start Value, 65,65
,,,,,,,End Value, 70,70
,,,,,,,Status, "UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Good Duration,0 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:01:05,00:01:05
,,,,,,,,,,,,,Value,67.500,67.500
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","Good (0x00000401) - Limit None"
12:01:10,70,"Uncertain",12:01:10,14,
,,,,,"12:01:10 70 Uncertain","00:01:10 70.000 Uncertain (0x40000000)"
,,,,,"12:01:15 75 UncertainDataSubNormal [0402]","00:01:15 75.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:01:10 AM,00:01:10
,,,,,,,Start Value, 70,70
,,,,,,,End Value, 75,75
,,,,,,,Status, "UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Good Duration,0 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:01:10,00:01:10
,,,,,,,,,,,,,Value,72.500,72.500
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","Good (0x00000401) - Limit None"
,,,12:01:15,15,
,,,,,"12:01:15 75 UncertainDataSubNormal [0402]","00:01:15 75.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,"12:01:20 80 Good","00:01:20 80.000 Good (0x00000000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:01:15 AM,00:01:15
,,,,,,,Start Value, 75,75
,,,,,,,End Value, 80,80
,,,,,,,Status, "UncertainDataSubNormal [0402]","UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,,,,Good Duration,0 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:01:15,00:01:15
,,,,,,,,,,,,,Value,77.500,77.500
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","Good (0x00000401) - Limit None"
12:01:20,80,"Good",12:01:20,16,
,,,,,"12:01:20 80 Good","00:01:20 80.000 Good (0x00000000)"
,,,,,"12:01:25 85 Good [0402]","00:01:25 85.000 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:01:20 AM,00:01:20
,,,,,,,Start Value, 80,80
,,,,,,,End Value, 85,85
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,,,,Good Duration,5000 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"Good","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:01:20,00:01:20
,,,,,,,,,,,,,Value,82.500,82.500
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:01:25,17,
,,,,,"12:01:25 85 Good [0402]","00:01:25 85.000 Good (0x00000402) - Limit None"
,,,,,"12:01:30 90 Good","00:01:30 90.000 Good (0x00000000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:01:25 AM,00:01:25
,,,,,,,Start Value, 85,85
,,,,,,,End Value, 90,90
,,,,,,,Status, "Good [0402]","Good (0x00000402) - Limit None"
,,,,,,,,,,Good Duration,5000 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"Good","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:01:25,00:01:25
,,,,,,,,,,,,,Value,87.500,87.500
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
12:01:30,90,"Good",12:01:30,18,
,,,,,"12:01:30 90 Good","00:01:30 90.000 Good (0x00000000)"
,,,,,"12:01:35 (null) BadNoData","00:01:35 90.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,Duration, 1,5000
,,,,,,,Start Time, 12:01:30 AM,00:01:30
,,,,,,,Start Value, 90,90
,,,,,,,End Value, 90,90
,,,,,,,Status, "UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Good Duration,0 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,1 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:01:30,00:01:30
,,,,,,,,,,,,,Value,90,90.000
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0405]","Good (0x00000405) - Limit None"
TimeAverage2-Historian1.csv (12,372 bytes)   
Commit Version

Relationships

related to 0006188 closedRod Stein TimeAverage2:Historian2 requires updates as per Get Time Weighted Status 
related to 0006190 closedRod Stein Total2:Historian1 requires updates as per Get Time Weighted Status 
related to 0006192 closedRod Stein Total2:Historian2 requires updates as per Get Time Weighted Status 
related to 0006193 closedRod Stein Maximum2:Historian1 requires updates as per Get Time Weighted Status 
related to 0006194 closedRod Stein MaximumActualTime2:Historian1 requires updates as per Get Time Weighted Status 
related to 0006202 closedRod Stein Minimum2:Historian1 requires updates as per Get Time Weighted Status 
related to 0006203 closedRod Stein MinimumActualTime2:Historian1 requires updates as per Get Time Weighted Status 
related to 0006204 closedRod Stein Range2:Historian1 requires updates as per Get Time Weighted Status 
related to 0006205 closedRod Stein DurationInStateZero:Historian1 requires updates as per Get Time Weighted Status 
related to 0006246 closedRod Stein DurationInStateNonZero:Historian1 requires updates as per Get Time Weighted Status 

Activities

Archie Miller

2020-11-12 16:40

administrator   ~0013192

Explanation

12:00:30 Interval

Simple Bound Values
00:00:30 30.000 Good (0x00000000)
00:00:35 30.000 UncertainDataSubNormal (0x40a40402) - Limit None

Regions

Region Original Updated
Duration 5000 5000
Start Time 12:00:30 AM 0:00:30
Start Value 30 30
End Value 30 30
Status "UncertainDataSubNormal" UncertainDataSubNormal (0x40a40000)

Durations

Time Based Status Code Calculations Original Updated
Good Duration 0 5000
Bad Duration 0 0
Total Duration 5000 5000
Status UncertainDataSubNormal Good (0x00000000)

Since the status is Uncertain, the full duration should be treated as Good resulting in a different status of Good

12:00:35 Interval

Simple Bound Values
00:00:35 30.000 UncertainDataSubNormal (0x40a40402) - Limit None
00:00:40 Null Bad (0x80000000)

Regions

Original Updated
Duration 5000 5000
Start Time 12:00:35 AM 0:00:35
Start Value 30 30
End Value 30 30
Status "UncertainDataSubNormal" UncertainDataSubNormal (0x40a40000)

Durations

Time Based Status Code Calculations Original Updated
Good Duration 0 5000
Bad Duration 0 0
Total Duration 5000 5000
Status UncertainDataSubNormal Good (0x00000000)

Since the status is Uncertain, the full duration should be treated as Good resulting in a different status of Good

12:01:00 Interval

Simple Bound Values
00:01:00 60.000 Good (0x00000000)
00:01:05 65.000 UncertainDataSubNormal (0x40a40402) - Limit None

Regions

Original Updated
Duration 5000 5000
Start Time 12:01:00 AM 0:01:00
Start Value 60 60
End Value 65 65
Status "UncertainDataSubNormal" UncertainDataSubNormal (0x40a40000)

Durations

Time Based Status Code Calculations Original Updated
Good Duration 0 5000
Bad Duration 0 0
Total Duration 5000 5000
Status UncertainDataSubNormal Good (0x00000000)

Since the status is Uncertain, the full duration should be treated as Good resulting in a different status of Good

12:01:05 Interval

Simple Bound Values
00:01:05 65.000 UncertainDataSubNormal (0x40a40402) - Limit None
00:01:10 70.000 Uncertain (0x40000000)

Regions

Original Updated
Duration 5000 5000
Start Time 12:01:05 AM 0:01:05
Start Value 65 65
End Value 70 70
Status "UncertainDataSubNormal" UncertainDataSubNormal (0x40a40000)

Durations

Time Based Status Code Calculations Original Updated
Good Duration 0 5000
Bad Duration 0 0
Total Duration 5000 5000
Status UncertainDataSubNormal Good (0x00000000)

Since the status is Uncertain, the full duration should be treated as Good resulting in a different status of Good

12:01:10 Interval

Simple Bound Values
00:01:10 70.000 Uncertain (0x40000000)
00:01:15 75.000 UncertainDataSubNormal (0x40a40402) - Limit None

Regions

Original Updated
Duration 5000 5000
Start Time 12:01:10 AM 0:01:10
Start Value 70 70
End Value 75 75
Status "UncertainDataSubNormal" UncertainDataSubNormal (0x40a40000)

Durations

Time Based Status Code Calculations Original Updated
Good Duration 0 5000
Bad Duration 0 0
Total Duration 5000 5000
Status UncertainDataSubNormal Good (0x00000000)

Since the status is Uncertain, the full duration should be treated as Good resulting in a different status of Good

12:01:15 Interval

Simple Bound Values
00:01:15 75.000 UncertainDataSubNormal (0x40a40402) - Limit None
00:01:20 80.000 Good (0x00000000)

Regions

Original Updated
Duration 5000 5000
Start Time 12:01:15 AM 0:01:15
Start Value 75 75
End Value 80 80
Status "UncertainDataSubNormal [0402]" UncertainDataSubNormal (0x40a40402) - Limit None

Durations

Time Based Status Code Calculations Original Updated
Good Duration 0 5000
Bad Duration 0 0
Total Duration 5000 5000
Status UncertainDataSubNormal Good (0x00000000)

Since the status is Uncertain, the full duration should be treated as Good resulting in a different status of Good

12:01:20 Interval

Simple Bound Values
00:01:20 80.000 Good (0x00000000)
00:01:25 85.000 Good (0x00000402) - Limit None

Regions

Original Updated
Duration 5000 5000
Start Time 12:01:20 AM 0:01:20
Start Value 80 80
End Value 85 85
Status "Good" Good (0x00000000)

Durations

Time Based Status Code Calculations Original Updated
Good Duration 5000 5000
Bad Duration 0 0
Total Duration 5000 5000
Status Good Good (0x00000000)

Since the status is Uncertain, the full duration should be treated as Good resulting in a different status of Good

12:01:30 Interval

Simple Bound Values
12:01:30 90 Good
12:01:35 (null) BadNoData

Regions Original Updated
Duration 1 1
Start Time 12:01:30 AM 0:01:30
Start Value 90 90
End Value 90 90
Status "UncertainDataSubNormal" UncertainDataSubNormal (0x40a40000)

Durations

Time Based Status Code Calculations Original Updated
Good Duration 0 1
Bad Duration 0 0
Total Duration 1 1
Status UncertainDataSubNormal Good (0x00000000)

Since the status is Uncertain, the full duration should be treated as Good resulting in a different status of Good

Rod Stein

2021-09-22 22:04

developer   ~0014936

TimeAverage2 Historian1 is now taking uncertain regions into account when calculating StatusCodes.

Errata added to 1.04.11.

Jim Luth

2021-09-24 15:39

administrator   ~0015004

Reviewed and accepted the changes in the 1.05 draft. Need to review 1.04 Errata to close.

Jim Luth

2021-12-09 15:49

administrator   ~0015548

Agreed to 1.04.11 Errata in Virtual F2F.

Issue History

Date Modified Username Field Change
2020-10-28 19:38 Archie Miller New Issue
2020-10-28 19:38 Archie Miller File Added: TimeAverage2-Historian1.csv
2020-10-28 20:22 Archie Miller Relationship added related to 0006188
2020-10-28 23:26 Archie Miller Relationship added related to 0006190
2020-10-29 14:22 Archie Miller Relationship added related to 0006192
2020-10-29 15:04 Archie Miller Relationship added related to 0006193
2020-10-29 16:01 Archie Miller Relationship added related to 0006194
2020-11-02 16:20 Archie Miller Relationship added related to 0006202
2020-11-02 16:24 Archie Miller Relationship added related to 0006203
2020-11-02 16:41 Archie Miller Relationship added related to 0006204
2020-11-02 17:17 Archie Miller Relationship added related to 0006205
2020-11-10 23:00 Archie Miller Relationship added related to 0006246
2020-11-12 16:40 Archie Miller Note Added: 0013192
2020-12-10 17:01 Jim Luth Status new => assigned
2020-12-10 17:01 Jim Luth Assigned To => Rod Stein
2021-09-22 22:04 Rod Stein Status assigned => resolved
2021-09-22 22:04 Rod Stein Resolution open => fixed
2021-09-22 22:04 Rod Stein Fixed in Version => 1.05
2021-09-22 22:04 Rod Stein Note Added: 0014936
2021-09-24 15:39 Jim Luth Note Added: 0015004
2021-12-09 15:49 Jim Luth Status resolved => closed
2021-12-09 15:49 Jim Luth Fixed in Version => 1.05.02 RC1
2021-12-09 15:49 Jim Luth Note Added: 0015548