View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
000618810000-013: AggregatesSpecpublic2020-10-28 20:222021-12-09 15:49
ReporterArchie Miller Assigned ToRod Stein  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version1.05.02 RC1 
Summary0006188: TimeAverage2:Historian2 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 can be found in the attached TimeAverage2-Historian2.csv spreadsheet.

Timestamp Value StatusCode Updated Value Updated Status Code
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.045 Good, Calculated
12:00:35.000 29.273 UncertainDataSubNormal, Calculated
12:00:40.000 30 UncertainDataSubNormal, Calculated Null Value Bad, Calculated
12:00:45.000 42.500 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 59.800 UncertainDataSubNormal, Calculated
12:01:15.000 60 UncertainDataSubNormal, Calculated Null Value Bad, Calculated
12:01:20.000 73.333 UncertainDataSubNormal, Calculated
12:01:25.000 83.667 Good, Calculated
12:01:30.000 90 UncertainDataSubNormal, Calculated, Partial Null Value Bad, Calculated, Partial
12:01:35.000 BadNoData
TagsNo tags attached.
Attached Files
TimeAverage2-Historian2.csv (16,130 bytes)    
Historian2,TimeAverage2
Stepped Interpolation,False
Sloped Extrapolation,True
TreatUncertainAsBad,True
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,
,,,,,"12:00:00 (null) BadNoData","00:00:00 Null BadNoData (0x809b0000)"
,,,,,"12:00:02 10 Good","00:00:02 10.000 Good (0x00000000)"
,,,,,"12:00:05 11.304 Good [0402]","00:00:05 11.304 Good (0x00000402) - Limit None"
,,,,,,,Duration, 2000,2000
,,,,,,,Start Time, 12:00:00 AM,00:00:00
,,,,,,,Start Value, 0,0
,,,,,,,End Value, 10,10
,,,,,,,Status, "BadNoData","BadNoData (0x809b0000)"
,,,,,,,Duration, 3000,3000
,,,,,,,Start Time, 12:00:02 AM,00:00:02
,,,,,,,Start Value, 10,10
,,,,,,,End Value, 11.304347826087,11.3043
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,,,,Good Duration,3000 ,3000 
,,,,,,,,,,Bad Duration,2000 ,2000 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,,,,Time,12:00:00,00:00:00
,,,,,,,,,,,,,Value,10.652,10.652
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0405]","UncertainDataSubNormal (0x40a40405) - Limit None"
12:00:02,10,"Good",
,,,12:00:05,1,
,,,,,"12:00:05 11.304 Good [0402]","00:00:05 11.304 Good (0x00000402) - Limit None"
,,,,,"12:00:10 13.478 Good [0402]","00:00:10 13.478 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:05 AM,00:00:05
,,,,,,,Start Value, 11.304347826087,11.3043
,,,,,,,End Value, 13.4782608695652,13.4783
,,,,,,,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:05,00:00:05
,,,,,,,,,,,,,Value,12.391,12.391
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:00:10,2,
,,,,,"12:00:10 13.478 Good [0402]","00:00:10 13.478 Good (0x00000402) - Limit None"
,,,,,"12:00:15 15.652 Good [0402]","00:00:15 15.652 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:10 AM,00:00:10
,,,,,,,Start Value, 13.4782608695652,13.4783
,,,,,,,End Value, 15.6521739130435,15.6522
,,,,,,,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:10,00:00:10
,,,,,,,,,,,,,Value,14.565,14.565
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:00:15,3,
,,,,,"12:00:15 15.652 Good [0402]","00:00:15 15.652 Good (0x00000402) - Limit None"
,,,,,"12:00:20 17.826 Good [0402]","00:00:20 17.826 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:15 AM,00:00:15
,,,,,,,Start Value, 15.6521739130435,15.6522
,,,,,,,End Value, 17.8260869565217,17.8261
,,,,,,,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,16.739,16.739
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:00:20,4,
,,,,,"12:00:20 17.826 Good [0402]","00:00:20 17.826 Good (0x00000402) - Limit None"
,,,,,"12:00:25 20 Good","00:00:25 20.000 Good (0x00000000)"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:20 AM,00:00:20
,,,,,,,Start Value, 17.8260869565217,17.8261
,,,,,,,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:20,00:00:20
,,,,,,,,,,,,,Value,18.913,18.913
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
12:00:25,20,"Good",12:00:25,5,
,,,,,"12:00:25 20 Good","00:00:25 20.000 Good (0x00000000)"
,,,,,"12:00:28 25 Good","00:00:28 25.000 Good (0x00000000)"
,,,,,"12:00:30 25.909 Good [0402]","00:00:30 25.909 Good (0x00000402) - Limit None"
,,,,,,,Duration, 3000,3000
,,,,,,,Start Time, 12:00:25 AM,00:00:25
,,,,,,,Start Value, 20,20
,,,,,,,End Value, 25,25
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,Duration, 2000,2000
,,,,,,,Start Time, 12:00:28 AM,00:00:28
,,,,,,,Start Value, 25,25
,,,,,,,End Value, 25.9090909090909,25.9091
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,,,,Good Duration,5000 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"Good","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:00:25,00:00:25
,,,,,,,,,,,,,Value,23.682,23.682
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
12:00:28,25,"Good",
,,,12:00:30,6,
,,,,,"12:00:30 25.909 Good [0402]","00:00:30 25.909 Good (0x00000402) - Limit None"
,,,,,"12:00:35 28.182 Good [0402]","00:00:35 28.182 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:30 AM,00:00:30
,,,,,,,Start Value, 25.9090909090909,25.9091
,,,,,,,End Value, 28.1818181818182,28.1818
,,,,,,,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:30,00:00:30
,,,,,,,,,,,,,Value,27.045,27.045
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:00:35,7,
,,,,,"12:00:35 28.182 Good [0402]","00:00:35 28.182 Good (0x00000402) - Limit None"
,,,,,"12:00:39 30 Good","00:00:39 30.000 Good (0x00000000)"
,,,,,"12:00:40 30 UncertainDataSubNormal [0402]","00:00:40 30.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,Duration, 4000,4000
,,,,,,,Start Time, 12:00:35 AM,00:00:35
,,,,,,,Start Value, 28.1818181818182,28.1818
,,,,,,,End Value, 30,30
,,,,,,,Status, "Good [0402]","Good (0x00000402) - Limit None"
,,,,,,,Duration, 1000,1000
,,,,,,,Start Time, 12:00:39 AM,00:00:39
,,,,,,,Start Value, 30,30
,,,,,,,End Value, 30,30
,,,,,,,Status, "UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Good Duration,4000 ,4000 
,,,,,,,,,,Bad Duration,0 ,1000 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,,,,Time,12:00:35,00:00:35
,,,,,,,,,,,,,Value,29.273,29.273
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","UncertainDataSubNormal (0x40a40401) - Limit None"
12:00:39,30,"Good",
,,,12:00:40,8,
,,,,,"12:00:40 30 UncertainDataSubNormal [0402]","00:00:40 30.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,"12:00:42 (null) Bad","00:00:42 Null Bad (0x80000000)"
,,,,,"12:00:45 (null) BadNoData","00:00:45 Null BadNoData (0x809b0000)"
,,,,,,,Duration, 2000,2000
,,,,,,,Start Time, 12:00:40 AM,00:00:40
,,,,,,,Start Value, 30,30
,,,,,,,End Value, 30,30
,,,,,,,Status, "UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,Duration, 3000,3000
,,,,,,,Start Time, 12:00:42 AM,00:00:42
,,,,,,,Start Value, 30,30
,,,,,,,End Value, 30,30
,,,,,,,Status, "Bad","Bad (0x80000000)"
,,,,,,,,,,Good Duration,0 ,0 
,,,,,,,,,,Bad Duration,3000 ,5000 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","Bad (0x80000000)"
,,,,,,,,,,,,,Time,12:00:40,00:00:40
,,,,,,,,,,,,,Value,30,Null
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","Bad (0x80000401) - Limit None"
,,,12:00:45,9,
,,,,,"12:00:45 (null) BadNoData","00:00:45 Null BadNoData (0x809b0000)"
,,,,,"12:00:48 40 Good","00:00:48 40.000 Good (0x00000000)"
,,,,,"12:00:50 45 Good [0402]","00:00:50 45.000 Good (0x00000402) - Limit None"
,,,,,,,Duration, 3000,3000
,,,,,,,Start Time, 12:00:45 AM,00:00:45
,,,,,,,Start Value, 0,0
,,,,,,,End Value, 40,40
,,,,,,,Status, "BadNoData","BadNoData (0x809b0000)"
,,,,,,,Duration, 2000,2000
,,,,,,,Start Time, 12:00:48 AM,00:00:48
,,,,,,,Start Value, 40,40
,,,,,,,End Value, 45,45
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,,,,Good Duration,2000 ,2000 
,,,,,,,,,,Bad Duration,3000 ,3000 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,,,,Time,12:00:45,00:00:45
,,,,,,,,,,,,,Value,42.500,42.500
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","UncertainDataSubNormal (0x40a40401) - Limit None"
12:00:48,40,"Good",
,,,12:00:50,10,
,,,,,"12:00:50 45 Good [0402]","00:00:50 45.000 Good (0x00000402) - Limit None"
,,,,,"12:00:52 50 Good","00:00:52 50.000 Good (0x00000000)"
,,,,,"12:00:55 51.500 Good [0402]","00:00:55 51.500 Good (0x00000402) - Limit None"
,,,,,,,Duration, 2000,2000
,,,,,,,Start Time, 12:00:50 AM,00:00:50
,,,,,,,Start Value, 45,45
,,,,,,,End Value, 50,50
,,,,,,,Status, "Good [0402]","Good (0x00000402) - Limit None"
,,,,,,,Duration, 3000,3000
,,,,,,,Start Time, 12:00:52 AM,00:00:52
,,,,,,,Start Value, 50,50
,,,,,,,End Value, 51.5,51.5
,,,,,,,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,49.450,49.450
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
12:00:52,50,"Good",
,,,12:00:55,11,
,,,,,"12:00:55 51.500 Good [0402]","00:00:55 51.500 Good (0x00000402) - Limit None"
,,,,,"12:01:00 54 Good [0402]","00:01:00 54.000 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:00:55 AM,00:00:55
,,,,,,,Start Value, 51.5,51.5
,,,,,,,End Value, 54,54
,,,,,,,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,52.750,52.750
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:01:00,12,
,,,,,"12:01:00 54 Good [0402]","00:01:00 54.000 Good (0x00000402) - Limit None"
,,,,,"12:01:05 56.500 Good [0402]","00:01:05 56.500 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:01:00 AM,00:01:00
,,,,,,,Start Value, 54,54
,,,,,,,End Value, 56.5,56.5
,,,,,,,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:00,00:01:00
,,,,,,,,,,,,,Value,55.250,55.250
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:01:05,13,
,,,,,"12:01:05 56.500 Good [0402]","00:01:05 56.500 Good (0x00000402) - Limit None"
,,,,,"12:01:10 59 Good [0402]","00:01:10 59.000 Good (0x00000402) - Limit None"
,,,,,,,Duration, 5000,5000
,,,,,,,Start Time, 12:01:05 AM,00:01:05
,,,,,,,Start Value, 56.5,56.5
,,,,,,,End Value, 59,59
,,,,,,,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:05,00:01:05
,,,,,,,,,,,,,Value,57.750,57.750
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,12:01:10,14,
,,,,,"12:01:10 59 Good [0402]","00:01:10 59.000 Good (0x00000402) - Limit None"
,,,,,"12:01:12 60 Good","00:01:12 60.000 Good (0x00000000)"
,,,,,"12:01:15 60 UncertainDataSubNormal [0402]","00:01:15 66.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,Duration, 2000,2000
,,,,,,,Start Time, 12:01:10 AM,00:01:10
,,,,,,,Start Value, 59,59
,,,,,,,End Value, 60,60
,,,,,,,Status, "Good [0402]","Good (0x00000402) - Limit None"
,,,,,,,Duration, 3000,3000
,,,,,,,Start Time, 12:01:12 AM,00:01:12
,,,,,,,Start Value, 60,60
,,,,,,,End Value, 60,60
,,,,,,,Status, "UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Good Duration,2000 ,2000 
,,,,,,,,,,Bad Duration,0 ,3000 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,,,,Time,12:01:10,00:01:10
,,,,,,,,,,,,,Value,59.800,59.800
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","UncertainDataSubNormal (0x40a40401) - Limit None"
12:01:12,60,"Good",
,,,12:01:15,15,
,,,,,"12:01:15 60 UncertainDataSubNormal [0402]","00:01:15 66.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,"12:01:17 70 Uncertain","00:01:17 70.000 Uncertain (0x40000000)"
,,,,,"12:01:20 (null) BadNoData","00:01:20 Null BadNoData (0x809b0000)"
,,,,,,,Duration, 2000,2000
,,,,,,,Start Time, 12:01:15 AM,00:01:15
,,,,,,,Start Value, 60,66
,,,,,,,End Value, 60,66
,,,,,,,Status, "UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,Duration, 3000,3000
,,,,,,,Start Time, 12:01:17 AM,00:01:17
,,,,,,,Start Value, 70,70
,,,,,,,End Value, 70,70
,,,,,,,Status, "BadNoData","BadNoData (0x809b0000)"
,,,,,,,,,,Good Duration,0 ,0 
,,,,,,,,,,Bad Duration,3000 ,5000 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","Bad (0x80000000)"
,,,,,,,,,,,,,Time,12:01:15,00:01:15
,,,,,,,,,,,,,Value,60,Null
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","Bad (0x80000401) - Limit None"
12:01:17,70,"Uncertain",
,,,12:01:20,16,
,,,,,"12:01:20 (null) BadNoData","00:01:20 Null BadNoData (0x809b0000)"
,,,,,"12:01:23 70 Good","00:01:23 70.000 Good (0x00000000)"
,,,,,"12:01:25 76.667 Good [0402]","00:01:25 76.667 Good (0x00000402) - Limit None"
,,,,,,,Duration, 3000,3000
,,,,,,,Start Time, 12:01:20 AM,00:01:20
,,,,,,,Start Value, 0,0
,,,,,,,End Value, 70,70
,,,,,,,Status, "BadNoData","BadNoData (0x809b0000)"
,,,,,,,Duration, 2000,2000
,,,,,,,Start Time, 12:01:23 AM,00:01:23
,,,,,,,Start Value, 70,70
,,,,,,,End Value, 76.6666666666667,76.6667
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,,,,Good Duration,2000 ,2000 
,,,,,,,,,,Bad Duration,3000 ,3000 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,,,,Time,12:01:20,00:01:20
,,,,,,,,,,,,,Value,73.333,73.333
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","UncertainDataSubNormal (0x40a40401) - Limit None"
12:01:23,70,"Good",
,,,12:01:25,17,
,,,,,"12:01:25 76.667 Good [0402]","00:01:25 76.667 Good (0x00000402) - Limit None"
,,,,,"12:01:26 80 Good","00:01:26 80.000 Good (0x00000000)"
,,,,,"12:01:30 90 Good","00:01:30 90.000 Good (0x00000000)"
,,,,,,,Duration, 1000,1000
,,,,,,,Start Time, 12:01:25 AM,00:01:25
,,,,,,,Start Value, 76.6666666666667,76.6667
,,,,,,,End Value, 80,80
,,,,,,,Status, "Good [0402]","Good (0x00000402) - Limit None"
,,,,,,,Duration, 4000,4000
,,,,,,,Start Time, 12:01:26 AM,00:01:26
,,,,,,,Start Value, 80,80
,,,,,,,End Value, 90,90
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,,,,Good Duration,5000 ,5000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,5000 ,5000 
,,,,,,,,,,Status,"Good","Good (0x00000000)"
,,,,,,,,,,,,,Time,12:01:25,00:01:25
,,,,,,,,,,,,,Value,83.667,83.667
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
12:01:26,80,"Good",
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 ,0 
,,,,,,,,,,Bad Duration,0 ,5000 
,,,,,,,,,,Total Duration,1 ,5000 
,,,,,,,,,,Status,"UncertainDataSubNormal","Bad (0x80000000)"
,,,,,,,,,,,,,Time,12:01:30,00:01:30
,,,,,,,,,,,,,Value,90,Null
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0405]","Bad (0x80000405) - Limit None"
TimeAverage2-Historian2.csv (16,130 bytes)   
Commit Version

Relationships

related to 0006187 closedRod Stein TimeAverage2:Historian1 requires updates as per Get Time Weighted Status 

Activities

Rod Stein

2021-09-22 22:05

developer   ~0014937

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

Errata added to 1.04.11.

Jim Luth

2021-09-24 15:45

administrator   ~0015007

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   ~0015549

Agreed to 1.04.11 Errata in Virtual F2F.

Issue History

Date Modified Username Field Change
2020-10-28 20:22 Archie Miller New Issue
2020-10-28 20:22 Archie Miller File Added: TimeAverage2-Historian2.csv
2020-10-28 20:22 Archie Miller Relationship added related to 0006187
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:05 Rod Stein Status assigned => resolved
2021-09-22 22:05 Rod Stein Resolution open => fixed
2021-09-22 22:05 Rod Stein Fixed in Version => 1.05
2021-09-22 22:05 Rod Stein Note Added: 0014937
2021-09-24 15:45 Jim Luth Note Added: 0015007
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: 0015549