{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Ratings","Ratings (2)","Ratings (3)","Notes","Investigation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ratings","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,2,0,3],[8,1,8,5],[8,6,8,10]]}
["AMRL Rating Estimates - Hot Mix Asphalt Gyratory",null,"Final Report Date:",null,"2014-08-27",null,"Sample 1:",37,null,"Sample 2:",38]
[]
["Lab Name","Lab #",null,null,null,null,"Nini Gyr.",8,null,"Ndes Gyr.",100]
["Your Lab Name Here",1]
[]
["Location"]
["Your Company Name - City, ST",null,null,null,null,null,null,null,null,null,"v 0.1"]
[]
[null,{"$f":"\"Sample \" &$H$1","v":"Sample 37"},null,null,null,null,{"$f":"\"Sample \" &$K$1","v":"Sample 38"}]
["Test Title","Lab Data","Avg.","1S","Z-Score","Rating","Lab Data","Avg.","1S","Z-Score","Rating"]
["Maximum Specific Gravity (Gyratory)\nMaximum Specific Gravity - T209/D2041",2.5649999999999999,2.5638999999999998,7.4999999999999997E-3,{"$f":"IF(D11=\"\",\"\",(B11-C11)/D11)","v":0.14666666666668013},{"$f":"IF(E11=\"\",\"\",frating(B11,C11,D11))","v":5},2.5110000000000001,2.5150000000000001,7.0000000000000001E-3,{"$f":"IF(I11=\"\",\"\",(G11-H11)/I11)","v":-0.57142857142857195},{"$f":"IF(J11=\"\",\"\",frating(G11,H11,I11))","v":-5}]
[]
["Bulk Specific Gravity Saturated Surface-Dry Method (Gyratory)\nBulk Specific Gravity Saturated Surface-Dry Method (Gyratory) - T166/D2776",2.4670000000000001,2.4695,1.34E-2,{"$f":"IF(D13=\"\",\"\",(B13-C13)/D13)","v":-0.18656716417910049},{"$f":"IF(E13=\"\",\"\",frating(B13,C13,D13))","v":-5},2.4300000000000002,2.4106000000000001,9.4999999999999998E-3,{"$f":"IF(I13=\"\",\"\",(G13-H13)/I13)","v":2.0421052631579037},{"$f":"IF(J13=\"\",\"\",frating(G13,H13,I13))","v":2}]
[]
["Bulk Specfic Gravity Using Vacuum Selaing Method\nBulk Specific Gravity (Vacuum Selaing Method) - T331/D6752",2.3759999999999999,2.4584999999999999,1.72E-2,{"$f":"IF(D15=\"\",\"\",(B15-C15)/D15)","v":-4.7965116279069777},{"$f":"IF(E15=\"\",\"\",frating(B15,C15,D15))","v":0},2.3330000000000002,2.4077000000000002,1.17E-2,{"$f":"IF(I15=\"\",\"\",(G15-H15)/I15)","v":-6.3846153846153832},{"$f":"IF(J15=\"\",\"\",frating(G15,H15,I15))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after \" & $H$3 & \" gyrations (0.1 mm) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after 8 gyrations (0.1 mm) - T312/D6925"},126.1,125.53,1.03,{"$f":"IF(D17=\"\",\"\",(B17-C17)/D17)","v":0.5533980582524205},{"$f":"IF(E17=\"\",\"\",frating(B17,C17,D17))","v":5},130.80000000000001,123.86,0.74,{"$f":"IF(I17=\"\",\"\",(G17-H17)/I17)","v":9.3783783783783949},{"$f":"IF(J17=\"\",\"\",frating(G17,H17,I17))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after \" & $K$3 & \" gyrations (0.1 mm) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after 100 gyrations (0.1 mm) - T312/D6925"},116.5,116.21,0.81,{"$f":"IF(D19=\"\",\"\",(B19-C19)/D19)","v":0.35802469135803239},{"$f":"IF(E19=\"\",\"\",frating(B19,C19,D19))","v":5},122.3,115.64,0.56999999999999995,{"$f":"IF(I19=\"\",\"\",(G19-H19)/I19)","v":11.684210526315784},{"$f":"IF(J19=\"\",\"\",frating(G19,H19,I19))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after \" & $H$3 & \" gyrations (0.1 percent) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after 8 gyrations (0.1 percent) - T312/D6925"},91.4,89.14,0.64,{"$f":"IF(D21=\"\",\"\",(B21-C21)/D21)","v":3.531250000000008},{"$f":"IF(E21=\"\",\"\",frating(B21,C21,D21))","v":0},91.8,89.46,0.53,{"$f":"IF(I21=\"\",\"\",(G21-H21)/I21)","v":4.4150943396226481},{"$f":"IF(J21=\"\",\"\",frating(G21,H21,I21))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after \" & $K$3 & \" gyrations (0.1 percent) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after 100 gyrations (0.1 percent) - T312/D6925"},95.8,96.31,0.6,{"$f":"IF(D23=\"\",\"\",(B23-C23)/D23)","v":-0.85000000000000853},{"$f":"IF(E23=\"\",\"\",frating(B23,C23,D23))","v":-5},95.7,95.85,0.46,{"$f":"IF(I23=\"\",\"\",(G23-H23)/I23)","v":-0.32608695652172059},{"$f":"IF(J23=\"\",\"\",frating(G23,H23,I23))","v":-5}]

{"sheet":"Ratings (2)","index":1,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,2,0,3],[8,1,8,5],[8,6,8,10]]}
["AMRL Rating Estimates - Hot Mix Asphalt Gyratory",null,"Final Report Date:",null,{"$f":"Ratings!$E$1","v":"2014-08-27"},null,"Sample 1:",{"$f":"Ratings!$H$1","v":37},null,"Sample 2:",{"$f":"Ratings!$K$1","v":38}]
[]
["Lab Name","Lab #",null,null,null,null,"Nini Gyr.",8,null,"Ndes Gyr.",100]
[{"$f":"Ratings!$A$4","v":"Your Lab Name Here"},{"$f":"Ratings!$B$4","v":1}]
[]
["Location"]
[{"$f":"Ratings!$A$7","v":"Your Company Name - City, ST"},null,null,null,null,null,null,null,null,null,{"$f":"Ratings!K7","v":"v 0.1"}]
[]
[null,{"$f":"\"Sample \" &$H$1","v":"Sample 37"},null,null,null,null,{"$f":"\"Sample \" &$K$1","v":"Sample 38"}]
["Test Title","Lab Data","Avg.","1S","Z-Score","Rating","Lab Data","Avg.","1S","Z-Score","Rating"]
["Maximum Specific Gravity (Gyratory)\nMaximum Specific Gravity - T209/D2041",2.5649999999999999,2.5638999999999998,7.4999999999999997E-3,{"$f":"IF(D11=\"\",\"\",(B11-C11)/D11)","v":0.14666666666668013},{"$f":"IF(E11=\"\",\"\",frating(B11,C11,D11))","v":5},2.5110000000000001,2.5150000000000001,7.0000000000000001E-3,{"$f":"IF(I11=\"\",\"\",(G11-H11)/I11)","v":-0.57142857142857195},{"$f":"IF(J11=\"\",\"\",frating(G11,H11,I11))","v":-5}]
[]
["Bulk Specific Gravity Saturated Surface-Dry Method (Gyratory)\nBulk Specific Gravity Saturated Surface-Dry Method (Gyratory) - T166/D2776",2.4670000000000001,2.4695,1.34E-2,{"$f":"IF(D13=\"\",\"\",(B13-C13)/D13)","v":-0.18656716417910049},{"$f":"IF(E13=\"\",\"\",frating(B13,C13,D13))","v":-5},2.4300000000000002,2.4106000000000001,9.4999999999999998E-3,{"$f":"IF(I13=\"\",\"\",(G13-H13)/I13)","v":2.0421052631579037},{"$f":"IF(J13=\"\",\"\",frating(G13,H13,I13))","v":2}]
[]
["Bulk Specfic Gravity Using Vacuum Selaing Method\nBulk Specific Gravity (Vacuum Selaing Method) - T331/D6752",2.3759999999999999,2.4584999999999999,1.72E-2,{"$f":"IF(D15=\"\",\"\",(B15-C15)/D15)","v":-4.7965116279069777},{"$f":"IF(E15=\"\",\"\",frating(B15,C15,D15))","v":0},2.3330000000000002,2.4077000000000002,1.17E-2,{"$f":"IF(I15=\"\",\"\",(G15-H15)/I15)","v":-6.3846153846153832},{"$f":"IF(J15=\"\",\"\",frating(G15,H15,I15))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after \" & $H$3 & \" gyrations (0.1 mm) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after 8 gyrations (0.1 mm) - T312/D6925"},126.1,125.53,1.03,{"$f":"IF(D17=\"\",\"\",(B17-C17)/D17)","v":0.5533980582524205},{"$f":"IF(E17=\"\",\"\",frating(B17,C17,D17))","v":5},130.80000000000001,123.86,0.74,{"$f":"IF(I17=\"\",\"\",(G17-H17)/I17)","v":9.3783783783783949},{"$f":"IF(J17=\"\",\"\",frating(G17,H17,I17))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after \" & $K$3 & \" gyrations (0.1 mm) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after 100 gyrations (0.1 mm) - T312/D6925"},116.5,116.21,0.81,{"$f":"IF(D19=\"\",\"\",(B19-C19)/D19)","v":0.35802469135803239},{"$f":"IF(E19=\"\",\"\",frating(B19,C19,D19))","v":5},122.3,115.64,0.56999999999999995,{"$f":"IF(I19=\"\",\"\",(G19-H19)/I19)","v":11.684210526315784},{"$f":"IF(J19=\"\",\"\",frating(G19,H19,I19))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after \" & $H$3 & \" gyrations (0.1 percent) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after 8 gyrations (0.1 percent) - T312/D6925"},91.4,89.14,0.64,{"$f":"IF(D21=\"\",\"\",(B21-C21)/D21)","v":3.531250000000008},{"$f":"IF(E21=\"\",\"\",frating(B21,C21,D21))","v":0},91.8,89.46,0.53,{"$f":"IF(I21=\"\",\"\",(G21-H21)/I21)","v":4.4150943396226481},{"$f":"IF(J21=\"\",\"\",frating(G21,H21,I21))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after \" & $K$3 & \" gyrations (0.1 percent) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after 100 gyrations (0.1 percent) - T312/D6925"},95.8,96.31,0.6,{"$f":"IF(D23=\"\",\"\",(B23-C23)/D23)","v":-0.85000000000000853},{"$f":"IF(E23=\"\",\"\",frating(B23,C23,D23))","v":-5},95.7,95.85,0.46,{"$f":"IF(I23=\"\",\"\",(G23-H23)/I23)","v":-0.32608695652172059},{"$f":"IF(J23=\"\",\"\",frating(G23,H23,I23))","v":-5}]

{"sheet":"Ratings (3)","index":2,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,2,0,3],[8,1,8,5],[8,6,8,10]]}
["AMRL Rating Estimates - Hot Mix Asphalt Gyratory",null,"Final Report Date:",null,{"$f":"Ratings!$E$1","v":"2014-08-27"},null,"Sample 1:",{"$f":"Ratings!$H$1","v":37},null,"Sample 2:",{"$f":"Ratings!$K$1","v":38}]
[]
["Lab Name","Lab #",null,null,null,null,"Nini Gyr.",8,null,"Ndes Gyr.",100]
[{"$f":"Ratings!$A$4","v":"Your Lab Name Here"},{"$f":"Ratings!$B$4","v":1}]
[]
["Location"]
[{"$f":"Ratings!$A$7","v":"Your Company Name - City, ST"},null,null,null,null,null,null,null,null,null,{"$f":"Ratings!K7","v":"v 0.1"}]
[]
[null,{"$f":"\"Sample \" &$H$1","v":"Sample 37"},null,null,null,null,{"$f":"\"Sample \" &$K$1","v":"Sample 38"}]
["Test Title","Lab Data","Avg.","1S","Z-Score","Rating","Lab Data","Avg.","1S","Z-Score","Rating"]
["Maximum Specific Gravity (Gyratory)\nMaximum Specific Gravity - T209/D2041",2.5649999999999999,2.5638999999999998,7.4999999999999997E-3,{"$f":"IF(D11=\"\",\"\",(B11-C11)/D11)","v":0.14666666666668013},{"$f":"IF(E11=\"\",\"\",frating(B11,C11,D11))","v":5},2.5110000000000001,2.5150000000000001,7.0000000000000001E-3,{"$f":"IF(I11=\"\",\"\",(G11-H11)/I11)","v":-0.57142857142857195},{"$f":"IF(J11=\"\",\"\",frating(G11,H11,I11))","v":-5}]
[]
["Bulk Specific Gravity Saturated Surface-Dry Method (Gyratory)\nBulk Specific Gravity Saturated Surface-Dry Method (Gyratory) - T166/D2776",2.4670000000000001,2.4695,1.34E-2,{"$f":"IF(D13=\"\",\"\",(B13-C13)/D13)","v":-0.18656716417910049},{"$f":"IF(E13=\"\",\"\",frating(B13,C13,D13))","v":-5},2.4300000000000002,2.4106000000000001,9.4999999999999998E-3,{"$f":"IF(I13=\"\",\"\",(G13-H13)/I13)","v":2.0421052631579037},{"$f":"IF(J13=\"\",\"\",frating(G13,H13,I13))","v":2}]
[]
["Bulk Specfic Gravity Using Vacuum Selaing Method\nBulk Specific Gravity (Vacuum Selaing Method) - T331/D6752",2.3759999999999999,2.4584999999999999,1.72E-2,{"$f":"IF(D15=\"\",\"\",(B15-C15)/D15)","v":-4.7965116279069777},{"$f":"IF(E15=\"\",\"\",frating(B15,C15,D15))","v":0},2.3330000000000002,2.4077000000000002,1.17E-2,{"$f":"IF(I15=\"\",\"\",(G15-H15)/I15)","v":-6.3846153846153832},{"$f":"IF(J15=\"\",\"\",frating(G15,H15,I15))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after \" & $H$3 & \" gyrations (0.1 mm) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after 8 gyrations (0.1 mm) - T312/D6925"},126.1,125.53,1.03,{"$f":"IF(D17=\"\",\"\",(B17-C17)/D17)","v":0.5533980582524205},{"$f":"IF(E17=\"\",\"\",frating(B17,C17,D17))","v":5},130.80000000000001,123.86,0.74,{"$f":"IF(I17=\"\",\"\",(G17-H17)/I17)","v":9.3783783783783949},{"$f":"IF(J17=\"\",\"\",frating(G17,H17,I17))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after \" & $K$3 & \" gyrations (0.1 mm) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nHeight During Compaction after 100 gyrations (0.1 mm) - T312/D6925"},116.5,116.21,0.81,{"$f":"IF(D19=\"\",\"\",(B19-C19)/D19)","v":0.35802469135803239},{"$f":"IF(E19=\"\",\"\",frating(B19,C19,D19))","v":5},122.3,115.64,0.56999999999999995,{"$f":"IF(I19=\"\",\"\",(G19-H19)/I19)","v":11.684210526315784},{"$f":"IF(J19=\"\",\"\",frating(G19,H19,I19))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after \" & $H$3 & \" gyrations (0.1 percent) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after 8 gyrations (0.1 percent) - T312/D6925"},91.4,89.14,0.64,{"$f":"IF(D21=\"\",\"\",(B21-C21)/D21)","v":3.531250000000008},{"$f":"IF(E21=\"\",\"\",frating(B21,C21,D21))","v":0},91.8,89.46,0.53,{"$f":"IF(I21=\"\",\"\",(G21-H21)/I21)","v":4.4150943396226481},{"$f":"IF(J21=\"\",\"\",frating(G21,H21,I21))","v":0}]
[]
[{"$f":"\"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after \" & $K$3 & \" gyrations (0.1 percent) - T312/D6925\"","v":"Hot Mix Asphalt Superpave Gyratory Compactor\nPercent of Maximum Specific Gravity after 100 gyrations (0.1 percent) - T312/D6925"},95.8,96.31,0.6,{"$f":"IF(D23=\"\",\"\",(B23-C23)/D23)","v":-0.85000000000000853},{"$f":"IF(E23=\"\",\"\",frating(B23,C23,D23))","v":-5},95.7,95.85,0.46,{"$f":"IF(I23=\"\",\"\",(G23-H23)/I23)","v":-0.32608695652172059},{"$f":"IF(J23=\"\",\"\",frating(G23,H23,I23))","v":-5}]

{"sheet":"Notes","index":3,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Note","Description"]
[1,"Z-Scores and ratings may be slightly different than AMRL final report values due to rounding."]
[2,"Ratings <= -2 and >= 2 are marked in red color font and may require an investigation and  a response to ODOT's Bitimunous Engineer. "]
[3,"Response form may be found at the link below."]
[4,"http://amrl.net/Amrlsitefinity/Libraries/AMRL_Document_Library/Proficiency_Sample_Corrective_Action_Report.sflb.ashx"]
[5,"See AMRL's web site below for current forms and to enter and track your AMRL proficiency samples."]
[6,"http://amrl.net/Amrlsitefinity/default.aspx"]
[7,"Generic explaination of ratings below."]
[8,"http://amrl.net/Amrlsitefinity/Libraries/AMRL_Document_Library/Generic_Explanation_of_PSP_ratings.sflb.ashx"]
[9,"Qualified asphalt labs and mix design labs with \"A\" and \"AD\" designations must participate in two specific AMRL proficiency sample programs.  Link of labs and link to policy is shown below."]
[10,"http://www.odot.org/materials/htm-smap/11069.html"]
[11,"AMRL mixing demos and presentation link below."]
[12,"http://www.ok.gov/odot/Doing_Business/Construction/Materials_&_Testing_e-Guide/pres.html"]

{"sheet":"Investigation","index":4,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Root Cause Analysis"]
[null,"Attach any documentation in the response form to the ODOT Bituminous Engineer that details any investigation performed below:"]
[null,1,"Check equipment calibration and verification records. "]
[null,"a.","Repeat equipment verifications that might affect test results. "]
[null,2,"Verify that results reported were those used on lab worksheets."]
[null,3,"Re-compute test results submitted for sample."]
[null,4,"Perform the test on another sample while being observed by supervisior."]
[null,5,"Obtain an extra AMRL sample or an OMRL sample where the known results can be compared and compute what ratings would have been."]
[null,6,"Consult with Materials Division or other AMRL accredited labs with experience. "]
[null," "]
[null,"Corrective Action"]
[null,"Some example responses:"]
[null,1,"No cause could be found at this time. An OMRL sample is available. We will obtain the sample and complete those tests in one week and report back. We will compare our results to see if the problem persists or the low rating was an anomaly."]
[null,2,"The problem appears to be that an incorrect sample weight was used. Too little sample resulted in an overly compacted sample as verified by an OMRL sample where the proper sample weight was used and compared to one where too little material was used . The technician was instructed on September 25, 2014 that \"all\" AMRL material batched should be used for AASHTO T 312 compaction. "]
[null,3,"The SGC, ODOT inventory number #258490, was out of calibration for internal angle as shown in the attached records. It was recalibrated and those records are attached. An OMRL sample compacted after the recalibration would have resulted in a rating of -4. Those records are attached. "]
[null," "]
[null,null,"Some of the reports can be hard to follow just which item is being addressed. I suggest that the title be included in the response form in the root cause analysis area to make the response item more clear. For example, for the first AASHTO T 312 item number 4, \"Hot Mix Asphalt Superpave Gyrator Compactor Height During Compaction after 8 gyrations (0.1mm)\". "]
[]
[null,null,"Recompute this ratings file or PDF copy if an Extra sample or OMRL sample is tested during the investigation."]