View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
000624610000-013: AggregatesSpecpublic2020-11-10 23:002022-03-10 16:10
ReporterArchie Miller Assigned ToRod Stein  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version1.05.02 RC1 
Summary0006246: DurationInStateNonZero:Historian1 requires updates as per Get Time Weighted Status
Description

Note: DurationInStateNonZero was not in the 1.04 spec.

The DurationInStateZero 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 DurationInStateNonZero-Historian1-forward.csv spreadsheet.

The values from the table start with the original test tool calculations, with updates due to TreatUncertainAsBad.

Timestamp Value StatusCode Updated Status
12:00:00.000 0 UncertainDataSubNormal, Calculated, Partial
12:00:16.000 0 UncertainDataSubNormal, Calculated Good, Calculated
12:00:32.000 0 UncertainDataSubNormal, Calculated
12:00:48.000 0 UncertainDataSubNormal, Calculated
12:01:04.000 0 UncertainDataSubNormal, Calculated Good, Calculated
12:01:20.000 0 UncertainDataSubNormal, Calculated, Partial Good, Calculated, Partial
12:01:36.000 BadNoData
TagsNo tags attached.
Attached Files
DurationInStateNonZero-Historian1-forward.csv (9,103 bytes)    
Historian1,DurationInStateNonZero
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,
,,,,,"12:00:00 (null) BadNoData","00:00:00 Null BadNoData (0x809b0000)"
,,,,,"12:00:10 10 Good","00:00:10 10.000 Good (0x00000000)"
,,,,,"12:00:16 16 Good [0402]","00:00:16 16.000 Good (0x00000402) - Limit None"
,,,,,,,Duration, 10000,10000
,,,,,,,Start Time, 12:00:00 AM,00:00:00
,,,,,,,Start Value, 0,0
,,,,,,,End Value, 0,0
,,,,,,,Status, "BadNoData","BadNoData (0x809b0000)"
,,,,,,,Duration, 6000,6000
,,,,,,,Start Time, 12:00:10 AM,00:00:10
,,,,,,,Start Value, 10,10
,,,,,,,End Value, 10,10
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,Duration, ,10000
,,,,,,,Start Time, ,00:00:00
,,,,,,,Start Value, ,0
,,,,,,,End Value, ,10
,,,,,,,Status, ,"BadNoData (0x809b0000)"
,,,,,,,Duration, ,6000
,,,,,,,Start Time, ,00:00:10
,,,,,,,Start Value, ,10
,,,,,,,End Value, ,16
,,,,,,,Status, ,"Good (0x00000000)"
,,,,,,,,,,Time Based Status Code Calculations
,,,,,,,,,,Good Duration,6000 ,6000 
,,,,,,,,,,Bad Duration,10000 ,10000 
,,,,,,,,,,Total Duration,16000 ,16000 
,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","UncertainDataSubNormal (0x40a40401) - Limit None"
,,,,,,,,,,,,,Time,12:00:00,00:00:00
,,,,,,,,,,,,,Value,6000,6000.000
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0405]","UncertainDataSubNormal (0x40a40405) - Limit None"
12:00:10,10,"Good",
,,,12:00:16,1,
,,,,,"12:00:16 16 Good [0402]","00:00:16 16.000 Good (0x00000402) - Limit None"
,,,,,"12:00:20 20 Good","00:00:20 20.000 Good (0x00000000)"
,,,,,"12:00:30 30 Good","00:00:30 30.000 Good (0x00000000)"
,,,,,"12:00:32 30 UncertainDataSubNormal [0402]","00:00:32 30.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,Duration, 4000,4000
,,,,,,,Start Time, 12:00:16 AM,00:00:16
,,,,,,,Start Value, 16,16
,,,,,,,End Value, 16,16
,,,,,,,Status, "Good [0402]","Good (0x00000402) - Limit None"
,,,,,,,Duration, 10000,10000
,,,,,,,Start Time, 12:00:20 AM,00:00:20
,,,,,,,Start Value, 20,20
,,,,,,,End Value, 20,20
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,Duration, 2000,2000
,,,,,,,Start Time, 12:00:30 AM,00:00:30
,,,,,,,Start Value, 30,30
,,,,,,,End Value, 30,30
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,Duration, ,4000
,,,,,,,Start Time, ,00:00:16
,,,,,,,Start Value, ,16
,,,,,,,End Value, ,20
,,,,,,,Status, ,"Good (0x00000402) - Limit None"
,,,,,,,Duration, ,10000
,,,,,,,Start Time, ,00:00:20
,,,,,,,Start Value, ,20
,,,,,,,End Value, ,30
,,,,,,,Status, ,"Good (0x00000000)"
,,,,,,,Duration, ,2000
,,,,,,,Start Time, ,00:00:30
,,,,,,,Start Value, ,30
,,,,,,,End Value, ,30
,,,,,,,Status, ,"UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Time Based Status Code Calculations
,,,,,,,,,,Good Duration,16000 ,16000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,16000 ,16000 
,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,,,,,,,,,,,Time,12:00:16,00:00:16
,,,,,,,,,,,,,Value,16000,16000.000
,,,,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
12:00:20,20,"Good",
12:00:30,30,"Good",
,,,12:00:32,2,
,,,,,"12:00:32 30 UncertainDataSubNormal [0402]","00:00:32 30.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,"12:00:40 40 Bad","00:00:40 Null Bad (0x80000000)"
,,,,,"12:00:48 (null) BadNoData","00:00:48 Null BadNoData (0x809b0000)"
,,,,,,,Duration, 8000,8000
,,,,,,,Start Time, 12:00:32 AM,00:00:32
,,,,,,,Start Value, 30,30
,,,,,,,End Value, 30,30
,,,,,,,Status, "UncertainDataSubNormal [0402]","UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,Duration, 8000,8000
,,,,,,,Start Time, 12:00:40 AM,00:00:40
,,,,,,,Start Value, 30,30
,,,,,,,End Value, 30,30
,,,,,,,Status, "Bad","Bad (0x80000000)"
,,,,,,,Duration, ,8000
,,,,,,,Start Time, ,00:00:32
,,,,,,,Start Value, ,30
,,,,,,,End Value, ,30
,,,,,,,Status, ,"UncertainDataSubNormal (0x40a40000)"
,,,,,,,Duration, ,8000
,,,,,,,Start Time, ,00:00:40
,,,,,,,Start Value, ,30
,,,,,,,End Value, ,30
,,,,,,,Status, ,"Bad (0x80000000)"
,,,,,,,,,,Time Based Status Code Calculations
,,,,,,,,,,Good Duration,0 ,8000 
,,,,,,,,,,Bad Duration,8000 ,8000 
,,,,,,,,,,Total Duration,16000 ,16000 
,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","UncertainDataSubNormal (0x40a40401) - Limit None"
,,,,,,,,,,,,,Time,12:00:32,00:00:32
,,,,,,,,,,,,,Value,0,0.000
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","UncertainDataSubNormal (0x40a40401) - Limit None"
12:00:40,40,"Bad",
,,,12:00:48,3,
,,,,,"12:00:48 (null) BadNoData","00:00:48 Null BadNoData (0x809b0000)"
,,,,,"12:00:50 50 Good","00:00:50 50.000 Good (0x00000000)"
,,,,,"12:01:00 60 Good","00:01:00 60.000 Good (0x00000000)"
,,,,,"12:01:04 64 UncertainDataSubNormal [0402]","00:01:04 64.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,Duration, 2000,2000
,,,,,,,Start Time, 12:00:48 AM,00:00:48
,,,,,,,Start Value, 0,0
,,,,,,,End Value, 0,0
,,,,,,,Status, "BadNoData","BadNoData (0x809b0000)"
,,,,,,,Duration, 10000,10000
,,,,,,,Start Time, 12:00:50 AM,00:00:50
,,,,,,,Start Value, 50,50
,,,,,,,End Value, 50,50
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,Duration, 4000,4000
,,,,,,,Start Time, 12:01:00 AM,00:01:00
,,,,,,,Start Value, 60,60
,,,,,,,End Value, 60,60
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,Duration, ,2000
,,,,,,,Start Time, ,00:00:48
,,,,,,,Start Value, ,0
,,,,,,,End Value, ,50
,,,,,,,Status, ,"BadNoData (0x809b0000)"
,,,,,,,Duration, ,10000
,,,,,,,Start Time, ,00:00:50
,,,,,,,Start Value, ,50
,,,,,,,End Value, ,60
,,,,,,,Status, ,"Good (0x00000000)"
,,,,,,,Duration, ,4000
,,,,,,,Start Time, ,00:01:00
,,,,,,,Start Value, ,60
,,,,,,,End Value, ,64
,,,,,,,Status, ,"UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Time Based Status Code Calculations
,,,,,,,,,,Good Duration,14000 ,14000 
,,,,,,,,,,Bad Duration,2000 ,2000 
,,,,,,,,,,Total Duration,16000 ,16000 
,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","UncertainDataSubNormal (0x40a40401) - Limit None"
,,,,,,,,,,,,,Time,12:00:48,00:00:48
,,,,,,,,,,,,,Value,14000,14000.000
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","UncertainDataSubNormal (0x40a40401) - Limit None"
12:00:50,50,"Good",
12:01:00,60,"Good",
,,,12:01:04,4,
,,,,,"12:01:04 64 UncertainDataSubNormal [0402]","00:01:04 64.000 UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,"12:01:10 70 Uncertain","00:01:10 70.000 Uncertain (0x40000000)"
,,,,,"12:01:20 80 Good","00:01:20 80.000 Good (0x00000000)"
,,,,,,,Duration, 6000,6000
,,,,,,,Start Time, 12:01:04 AM,00:01:04
,,,,,,,Start Value, 64,64
,,,,,,,End Value, 64,64
,,,,,,,Status, "UncertainDataSubNormal [0402]","UncertainDataSubNormal (0x40a40402) - Limit None"
,,,,,,,Duration, 10000,10000
,,,,,,,Start Time, 12:01:10 AM,00:01:10
,,,,,,,Start Value, 70,70
,,,,,,,End Value, 70,70
,,,,,,,Status, "Uncertain","Uncertain (0x40000000)"
,,,,,,,Duration, ,6000
,,,,,,,Start Time, ,00:01:04
,,,,,,,Start Value, ,64
,,,,,,,End Value, ,70
,,,,,,,Status, ,"UncertainDataSubNormal (0x40a40000)"
,,,,,,,Duration, ,10000
,,,,,,,Start Time, ,00:01:10
,,,,,,,Start Value, ,70
,,,,,,,End Value, ,80
,,,,,,,Status, ,"Uncertain (0x40000000)"
,,,,,,,,,,Time Based Status Code Calculations
,,,,,,,,,,Good Duration,0 ,16000 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,16000 ,16000 
,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","Good (0x00000401) - Limit None"
,,,,,,,,,,,,,Time,12:01:04,00:01:04
,,,,,,,,,,,,,Value,0,0.000
,,,,,,,,,,,,,Status,"UncertainDataSubNormal [0401]","Good (0x00000401) - Limit None"
12:01:10,70,"Uncertain",
12:01:20,80,"Good",12:01:20,5,
,,,,,"12:01:20 80 Good","00:01:20 80.000 Good (0x00000000)"
,,,,,"12:01:30 90 Good","00:01:30 90.000 Good (0x00000000)"
,,,,,"12:01:36 (null) BadNoData","00:01:36 Null BadNoData (0x809b0000)"
,,,,,,,Duration, 10000,10000
,,,,,,,Start Time, 12:01:20 AM,00:01:20
,,,,,,,Start Value, 80,80
,,,,,,,End Value, 80,80
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,Duration, 1,1
,,,,,,,Start Time, 12:01:30 AM,00:01:30
,,,,,,,Start Value, 90,90
,,,,,,,End Value, 90,90
,,,,,,,Status, "Good","Good (0x00000000)"
,,,,,,,Duration, ,10000
,,,,,,,Start Time, ,00:01:20
,,,,,,,Start Value, ,80
,,,,,,,End Value, ,90
,,,,,,,Status, ,"Good (0x00000000)"
,,,,,,,Duration, ,1
,,,,,,,Start Time, ,00:01:30
,,,,,,,Start Value, ,90
,,,,,,,End Value, ,90
,,,,,,,Status, ,"UncertainDataSubNormal (0x40a40000)"
,,,,,,,,,,Time Based Status Code Calculations
,,,,,,,,,,Good Duration,10001 ,10001 
,,,,,,,,,,Bad Duration,0 ,0 
,,,,,,,,,,Total Duration,10001 ,10001 
,,,,,,,,,,Status,"Good [0401]","Good (0x00000401) - Limit None"
,,,,,,,,,,,,,Time,12:01:20,00:01:20
,,,,,,,,,,,,,Value,10001,10001.000
,,,,,,,,,,,,,Status,"Good [0405]","Good (0x00000405) - Limit None"
12:01:30,90,"Good",
DurationInStateNonZero-Historian1-forward.csv (9,103 bytes)   
Commit Version

Relationships

related to 0006187 closedRod Stein TimeAverage2:Historian1 requires updates as per Get Time Weighted Status 
related to 0005049 closedRod Stein Sample Data missing for DurationInStateZero and DurationInStateNonZero 

Activities

Rod Stein

2021-12-03 20:59

developer   ~0015448

Fixed in Part 13 1.05 draft 5.

This issue is introduced in the first draft of Part 13 1.05. This calculation for TreatUncertainAsBad was corrected casing some values and a StatusCode to change in DurationInStateNonZero. This is an edit to new tables never published in the 1.04 specification see issue 0005049.

Jim Luth

2022-03-10 16:10

administrator   ~0016305

Agreed to changes in VirtualF2F.

Issue History

Date Modified Username Field Change
2020-11-10 23:00 Archie Miller New Issue
2020-11-10 23:00 Archie Miller File Added: DurationInStateNonZero-Historian1-forward.csv
2020-11-10 23:00 Archie Miller Relationship added related to 0006187
2020-11-10 23:00 Archie Miller Relationship added related to 0005049
2020-12-10 17:01 Jim Luth Status new => assigned
2020-12-10 17:01 Jim Luth Assigned To => Rod Stein
2021-12-03 20:59 Rod Stein Status assigned => resolved
2021-12-03 20:59 Rod Stein Resolution open => fixed
2021-12-03 20:59 Rod Stein Fixed in Version => 1.05
2021-12-03 20:59 Rod Stein Note Added: 0015448
2022-03-10 16:10 Jim Luth Status resolved => closed
2022-03-10 16:10 Jim Luth Fixed in Version 1.05 => 1.05.02 RC1
2022-03-10 16:10 Jim Luth Note Added: 0016305