MSCR Results in Oklahoma

Download Report

Transcript MSCR Results in Oklahoma 

MSCR RESULTS IN
OKLAHOMA
KENNETH RAY HOBSON, P.E
AUGUST 25, 2011
SEAUPG WEBINAR
SUMMARY
1. Data
2. Reporting / Rounding
3. Trends
4. Conclusions
5. Excel Macro Function
6. TA Instruments
DATA
Temp (C)
PG
Source
ER %
R100
R3200
R diff
G*/sind RTFO
Jnr0.1
Jnr3.2
Jnr diff
MSCR Grade
64.0
76-28
A1
95
98
98
0
2.48
0.01
0.02
3.3
PG 64-28 E
64.0
76-28
A7
92.5
94
94
0
3.94
0.03
0.03
-3.1
PG 64-28 E
64.0
76-28
A3
92.5
92
92
0
3.64
0.03
0.03
-3.8
PG 64-28 E
64.0
76-28
A1
97.5
98
98
0
3.28
0.01
0.01
-7.2
PG 64-28 E
64.0
76-28
A1
97.5
98
98
0
2.62
0.01
0.01
0.8
PG 64-28 E
64.0
76-28
A7
95
95
95
0
4.29
0.02
0.02
1.9
PG 64-28 E
64.0
76-28
A1
97.5
98
98
0
2.35
0.02
0.02
8.5
PG 64-28 E
64.0
76-28
A4
95
89
89
1
3.58
0.06
0.05
-12.1
PG 64-28 E
64.0
70-28
A4
92.5
81
81
-1
4.05
0.13
0.12
-8.8
PG 64-28 E
64.0
70-28
A5
87.5
74
72
3
3.9
0.20
0.21
6.1
PG 64-28 E
64.0
70-28
A1
95
95
95
0
2.66
0.05
0.05
-0.9
PG 64-28 E
64.0
70-28
A4
92.5
79
80
-1
4.17
0.15
0.13
-9.6
PG 64-28 E
64.0
70-28
A5
90
71
66
8
3.52
0.28
0.34
21.9
PG 64-28 E
64.0
70-28
A4
92.5
71
68
5
4.88
0.20
0.23
18.0
PG 64-28 E
64.0
70-28
A1
95
96
95
1
2.55
0.05
0.05
5.5
PG 64-28 E
64.0
70-28
A10
84
84
0
3
0.17
0.17
1.2
PG 64-28 E
64.0
64-22
A2
1
0
82
2.4
4.04
4.22
4.4
ER% = ASTM D 6084, 77 oF, RTFO
DATA
Temp (C)
PG
Source
64.0
64-22
64.0
ER %
R100
R3200
R diff
A4
8
2
64-22
A1
-3
64.0
64-22
A2
64.0
64-22
64.0
G*/sind RTFO
Jnr0.1
Jnr3.2
Jnr diff
MSCR Grade
80
2.10
2.39
13.6
PG 64-22 S
0
113
3.28
3.27
-0.3
PG 64-22 S
-2
0
108
2.51
3.81
3.86
1.5
PG 64-22 S
A7
42
23
45
3.35
1.32
1.90
43.8
PG 64-22 H
64-22
A10
0
2
-366
4.58
2.14
2.23
4.3
PG 64-22 S
64.0
70-28
A3
90
64
50
21
2.47
0.54
0.78
45.0
PG 64-28 V
64.0
76-28
A3
95
86
88
-2
2.88
0.10
0.09
-12.0
PG 64-28 E
64.0
76-28
A1
97.5
96
97
-1
2.87
0.03
0.03
-22.9
PG 64-28 E
64.0
76-28
A4
97.5
85
86
-2
2.85
0.11
0.10
-10.5
PG 64-28 E
64.0
70-28
A4
95
95
95
0
3.98
0.04
0.03
-16.6
PG 64-28 E
64.0
76-28
A7
95
94
95
-1
2.53
0.05
0.04
-15.8
PG 64-28 E
64.0
64-22
A8
-3
0
104
2.22
4.60
4.72
2.6
64.0
64-22
A9
1
1
-16
3.29
2.87
3.03
5.6
PG 64-22 S
64.0
64-22
A1
8
1
81
3.96
2.18
2.47
13.4
PG 64-22 S
64.0
64-22
A11
4
0
97
2.45
3.83
4.18
9.1
64.0
64-22
A7
45
27
40
5.36
0.83
1.18
41.8
64.0
64-22
A2
5
0
100
2.45
3.82
4.18
9.4
ER% = PG 70-28 Min. 65, PG 76-28 Min. 75
PG 64-22 H
REPORTING / ROUNDING
1. Data in Excel File Reported, Not
Rounded
2. Computations Used Full Values
AASHTO TP 70-4, 8.1.3.
Rdiff

R0.1  R3.2 100

R0.1
Percent Recovery Data in Red:
Rdiff

1  0100

100
1
Rdiff
Vs.

0.5969  0.109100

 81.74
0.5969
REPORTING / ROUNDING
Percent Recovery Data in Red:


86  88100
86.21  87.89100
R 
2 R 
  1.949
diff
86
diff
86.21
Shown as -1.945 by TA Instruments, -2 in spreadsheet
9.1.2. PG Grade to nearest 0.1 oC?
REPORTING / ROUNDING
J nrdiff
J nrdiff
J nrdiff

J nr 3.2  J nr 0.1 100

J 0.1

0.03  0.03100

 0.0
0.03

0.0256  0.0332100

  22.9
0.0332
TRENDS
Temp (C)
PG
Source
ER %
R100
R3200
R diff
G*/sind RTFO
Jnr0.1
Jnr3.2
Jnr diff
MSCR Grade
64.0
76-28
A1
95
98
98
0
2.48
0.01
0.02
3.3
PG 64-28 E
64.0
76-28
A7
92.5
94
94
0
3.94
0.03
0.03
-3.1
PG 64-28 E
64.0
76-28
A3
92.5
92
92
0
3.64
0.03
0.03
-3.8
PG 64-28 E
64.0
76-28
A1
97.5
98
98
0
3.28
0.01
0.01
-7.2
PG 64-28 E
64.0
76-28
A1
97.5
98
98
0
2.62
0.01
0.01
0.8
PG 64-28 E
64.0
76-28
A7
95
95
95
0
4.29
0.02
0.02
1.9
PG 64-28 E
64.0
76-28
A1
97.5
98
98
0
2.35
0.02
0.02
8.5
PG 64-28 E
64.0
76-28
A4
95
89
89
1
3.58
0.06
0.05
-12.1
PG 64-28 E
64.0
76-28
A3
95
86
88
-2
2.88
0.10
0.09
-12.0
PG 64-28 E
64.0
76-28
A1
97.5
96
97
-1
2.87
0.03
0.03
-22.9
PG 64-28 E
64.0
76-28
A4
97.5
85
86
-2
2.85
0.11
0.10
-10.5
PG 64-28 E
64.0
76-28
A7
95
94
95
-1
2.53
0.05
0.04
-15.8
PG 64-28 E
PG 76-28 = PG 64-28 E
TRENDS
Temp (C)
PG
Source
ER %
R100
R3200
R diff
G*/sind RTFO
Jnr0.1
Jnr3.2
Jnr diff
MSCR Grade
64.0
70-28
A4
92.5
81
81
-1
4.05
0.13
0.12
-8.8
PG 64-28 E
64.0
70-28
A5
87.5
74
72
3
3.9
0.20
0.21
6.1
PG 64-28 E
64.0
70-28
A1
95
95
95
0
2.66
0.05
0.05
-0.9
PG 64-28 E
64.0
70-28
A4
92.5
79
80
-1
4.17
0.15
0.13
-9.6
PG 64-28 E
64.0
70-28
A5
90
71
66
8
3.52
0.28
0.34
21.9
PG 64-28 E
64.0
70-28
A4
92.5
71
68
5
4.88
0.20
0.23
18.0
PG 64-28 E
64.0
70-28
A1
95
96
95
1
2.55
0.05
0.05
5.5
PG 64-28 E
64.0
70-28
A10
84
84
0
3
0.17
0.17
1.2
PG 64-28 E
64.0
70-28
A3
90
64
50
21
2.47
0.54
0.78
45.0
PG 64-28 V
64.0
70-28
A4
95
95
95
0
3.98
0.04
0.03
-16.6
PG 64-28 E
PG 70-28  PG 64-28 E
TRENDS
Temp (C)
PG
Source
64.0
64-22
64.0
ER %
R100
R3200
R diff
G*/sind RTFO
Jnr0.1
Jnr3.2
Jnr diff
A2
1
0
82
2.4
4.04
4.22
4.4
64-22
A4
8
2
80
2.10
2.39
13.6
PG 64-22 S
64.0
64-22
A1
-3
0
113
3.28
3.27
-0.3
PG 64-22 S
64.0
64-22
A2
-2
0
108
2.51
3.81
3.86
1.5
PG 64-22 S
64.0
64-22
A7
42
23
45
3.35
1.32
1.90
43.8
PG 64-22 H
64.0
64-22
A10
0
2
-366
4.58
2.14
2.23
4.3
PG 64-22 S
64.0
64-22
A8
-3
0
104
2.22
4.60
4.72
2.6
64.0
64-22
A9
1
1
-16
3.29
2.87
3.03
5.6
PG 64-22 S
64.0
64-22
A1
8
1
81
3.96
2.18
2.47
13.4
PG 64-22 S
64.0
64-22
A11
4
0
97
2.45
3.83
4.18
9.1
64.0
64-22
A7
45
27
40
5.36
0.83
1.18
41.8
64.0
64-22
A2
5
0
100
2.45
3.82
4.18
9.4
PG 64-22  PG 64-22 S
MSCR Grade
PG 64-22 H
TRENDS
1. Most PG 70-28’s and All PG 76-28’s
Grade as PG 64-28 E
2. Jnr3.2 > 4.0 kPa-1 (4 of 12 PG 64-22)
• Not PG 64-22 S
3. Jnr3.2 < 0.0 kPa-1 (8 of 12 PG 76-28)
CONCLUSIONS
1. R3.2 Limit Needed for: PG 70-28 and
PG 76-28 - (60 Min. and 80 Min.?)
2. Other PG Grade Data Needed for
R3.2 Limits
3. Do Not Round Computations
Except for Limit Comparisons
EXCEL MACRO FUNCTION
Function MSCRGrade(PG As String, TestTemp As Double, Jnr32 As Double, JnrDiff As Double) As String
Dim iTestTemp As Double, iJnr32 As Double, iJnrDiff As Double
Dim sColdTemp As String, suffix As String
Application.Volatile
iTestTemp = Round(TestTemp)
sColdTemp = Split(PG, "-")(1)
iJnr32 = WorksheetFunction.Round(Jnr32, 2)
iJnrDiff = WorksheetFunction.Round(JnrDiff, 1)
Select Case (True)
Case iJnr32 < 0.5 And iJnrDiff <= 75:
suffix = "E"
Case iJnr32 <= 1 And iJnrDiff <= 75:
suffix = "V"
Case iJnr32 <= 2 And iJnrDiff <= 75:
suffix = "H"
Case iJnr32 <= 4 And iJnrDiff <= 75:
suffix = "S"
Case Else
suffix = "NA"
End Select
If suffix = "NA" Then
MSCRGrade = ""
Else
MSCRGrade = "PG " & iTestTemp & "-" & sColdTemp & " " & suffix
End If
End Function