{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Sublot 1","Sublot 2","Sublot 3","Sublot 4","Sublot 5","Sublot 6","Pay Factors","Instructions","Tables","Disclaimer"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":4,"defined_names":45,"comments":1,"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":"Sublot 1","index":0,"n_rows":67,"n_cols":20,"rows_kept":67,"cut":false,"hidden":false,"merged":[[10,1,10,6],[11,4,11,6],[6,6,6,8],[5,9,5,10],[7,6,7,8],[23,8,23,9],[13,8,13,12],[10,9,10,10],[11,9,11,11],[12,9,12,11],[36,8,36,9],[37,8,37,9],[55,8,55,9],[56,8,56,9],[57,8,57,9],[42,8,42,12],[40,1,40,5],[42,1,42,2],[43,1,43,2],[41,1,41,2],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[34,8,34,9],[35,8,35,9],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[38,1,38,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[26,8,26,12],[6,1,6,4],[9,1,9,6],[0,1,0,13],[6,9,6,10],[7,9,7,10],[2,0,2,13],[7,11,7,13],[5,1,5,4],[7,1,7,4],[5,6,5,8],[5,11,5,13],[6,11,6,13],[1,0,1,13],[3,0,3,13],[24,8,24,9],[50,1,50,2],[45,1,45,5],[53,8,53,9],[54,8,54,9],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2]]}
["v 1.14","OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
["SUPERPAVE"]
["McALESTER RESIDENCY"]
["HOT MIX ASPHALT SAMPLE SHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INFORMATION FROM MIX DESIGN:"]
[" Project No.",null,null,null,null,"J.P. No.",null,null,null,"Contract No. "]
[" Contractor",null,null,null,null,"Producer",null,null,null," Plant Location "]
["SM Sample ID",null,null,null,null,"Mix Type",null,null,null,"Design No. ",null,null,null,null,"3M+","    Million ESALs or PG Grade: Select from drop-down list."]
[]
[null,"EXTRACTIONS AND GRADATIONS",null,null,null,null,null,"IOC",1000,"  TOTAL TONS for this SubLOT"]
[null,"(OHD L-26, AASHTO T-30, T-11)",null,null,null,null,null,0.18,2.6589999999999998,"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",2.6120000000000001,"  Gsb from Design",null,null,null,null,"A","    Change for each sheet if A is not used on each.  Rices Precision: Select from drop-down list.  "]
[null," Temperature ",null,"Lot",1,"SubLot",1,4700,1.01,"  Spec. Grav. AC from Design",null,null,null,null,{"$f":"VLOOKUP(O12,PTable,2,FALSE)","v":1.4E-2},"    Method A - Mechanical or Method B - Manual"]
[null,"SIEVE","JMF","Acc. Wt.","Acc. %"," Total Agg.",null,null,"MAXIMUM SPECIFIC GRAVITY  (AASHTO T209)"]
[null,"SIZE",null,"Retd.","Retd."," % Passing","Dev.",null," Sub-Lot No.",null,null,null,null,null,null,"Limits",null,null,"Tolerance"]
[null,"1 1/2\" (37.5 mm)",100,0,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$27))","v":0},{"$f":"IF(D16=\"\",\"\",100-E16)","v":100},{"$f":"IF(D16=\"\",\"\",IF(F16<$P16,ABS(F16-$P16),IF(F16>$Q16,ABS($Q16-F16),Tables!$E$27)))","v":0},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":100},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":100},null,0]
[null,"1\" (25.0 mm)",100,0,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$27))","v":0},100,{"$f":"IF(D17=\"\",\"\",IF(F17<$P17,ABS(F17-$P17),IF(F17>$Q17,ABS($Q17-F17),Tables!$E$27)))","v":0},null," Flask No.",null,2,"|",4,null,"1\" (25.0 mm)",100,100,null,0]
[null,"3/4\" (19.0 mm",100,0,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$27))","v":0},100,{"$f":"IF(D18=\"\",\"\",IF(F18<$P18,ABS(F18-$P18),IF(F18>$Q18,ABS($Q18-F18),Tables!$E$27)))","v":0},null," Sample Wt.","           (A)  ",1534.4,"|",1576.5,null,"3/4\" (19.0 mm",93,100,null,7]
[null,"1/2\" (12.5 mm)",96,19.8,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$27))","v":1},99,{"$f":"IF(D19=\"\",\"\",IF(F19<$P19,ABS(F19-$P19),IF(F19>$Q19,ABS($Q19-F19),Tables!$E$27)))","v":0},null," Calib. Wt.","           (B)  ",6179,"|",6250.7,null,"1/2\" (12.5 mm)",89,100,null,7]
[null,"3/8\" (9.5 mm)",86,120.5,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$27))","v":8},92,{"$f":"IF(D20=\"\",\"\",IF(F20<$P20,ABS(F20-$P20),IF(F20>$Q20,ABS($Q20-F20),Tables!$E$27)))","v":0},null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":7713.4},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":7827.2},null,"3/8\" (9.5 mm)",79,93,null,7]
[null,"# 4 ( 4.75 mm)",61,382.6,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$27))","v":26},74,{"$f":"IF(D21=\"\",\"\",IF(F21<$P21,ABS(F21-$P21),IF(F21>$Q21,ABS($Q21-F21),Tables!$E$27)))","v":6},null," Sample + Flask + H²O  (D)",null,7085,"|",7183.1,null,"# 4 ( 4.75 mm)",54,68,null,7]
[null,"# 8 (2.36 mm)",44,662.3,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$27))","v":45},55,{"$f":"IF(D22=\"\",\"\",IF(F22<$P22,ABS(F22-$P22),IF(F22>$Q22,ABS($Q22-F22),Tables!$E$27)))","v":6},null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":628.39999999999964},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":644.09999999999945},null,"# 8 (2.36 mm)",39,49,null,5]
[null,"# 16 ( 1.18 mm)",32,897,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$27))","v":61},39,{"$f":"IF(D23=\"\",\"\",IF(F23<$P23,ABS(F23-$P23),IF(F23>$Q23,ABS($Q23-F23),Tables!$E$27)))","v":3},null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$40),\"\")","v":2.4420000000000002},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$40),\"\")","v":2.448},null,"# 16 ( 1.18 mm)",28,36,null,4]
[null,"# 30 (.600 mm)",23,1069,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$27))","v":73},27,{"$f":"IF(D24=\"\",\"\",IF(F24<$P24,ABS(F24-$P24),IF(F24>$Q24,ABS($Q24-F24),Tables!$E$27)))","v":0},null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$41))","v":2.4449999999999998},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",19,27,null,4]
[null,"# 50 (.300 mm)",13,1247.8,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$27))","v":85},15,{"$f":"IF(D25=\"\",\"\",IF(F25<$P25,ABS(F25-$P25),IF(F25>$Q25,ABS($Q25-F25),Tables!$E$27)))","v":0},null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$42),\"\")","v":2.6560000000000001},null,null,"# 50 (.300 mm)",9,17,null,4]
[null,"# 100 (.150 mm)",7,1329.6,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$27))","v":91},9,{"$f":"IF(D26=\"\",\"\",IF(F26<$P26,ABS(F26-$P26),IF(F26>$Q26,ABS($Q26-F26),Tables!$E$27)))","v":0},null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",4,10,null,3]
[null,"# 200 (.075 mm)",4.4000000000000004,1370.3,null,null,null,null,"   LAB MOLDED DENSITY  (OHD L-8, L-14) @ Ndes"]
[null," Total -200 (W3)",null,null,null,{"$f":"IF(E34=\"\",\"\",ROUND((E38/E34)*100,Tables!$E$28))","v":6.1},{"$f":"IF(D27=\"\",\"\",IF(F28<$P28,ROUND($P28-F28,Tables!$E$28),IF(F28>$Q28,ROUND(F28-$Q28,Tables!$E$28),0)))","v":0},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$44))","v":2.609},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":2.4000000000000004},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":6.4},null,2]
[null," % AC (P5m)",4.9000000000000004,5.3,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":1.01}]
[null," Corrected %AC",".",null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$29))","v":5.3},{"$f":"IF(D29=\"\",\"\",IF(ABS(C29-F30)>S30,ROUND(ABS(C29-F30),Tables!$E$33),0))","v":0},null," % AC",null,null,{"$f":"IF(K33=\"\",\"\",+F30)","v":5.3},null,null," Corrected %AC",{"$f":"IF(C29=\"\",\"\",C29-S30)","v":4.5},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":5.3000000000000007},null,0.4]
[null," Basket (A)",null,null,3363.6,null,null,null," Max. Theo. Spec. Grav.",null,null,{"$f":"IF(L24=\"\",\"\",ROUND(L24,Tables!$E$45))","v":2.4449999999999998}]
[null," Basket + Mix (B)",null,null,4910.3999999999996,null,null,null," Specimen No.",null,1,2]
[null," Mix (B-A)",null,null,{"$f":"IF(E31=\"\",\"\",+E32-E31)","v":1546.7999999999997},null,null,null," A (Wt. Spec. in Air)",null,4703.3,4698]
[null," Extr. Aggr. Wt (C)",null,{"$f":"IF(D31=\"\",\"\",+D31+D32)","v":""},1460,null,null,null," C (Wt. Spec. in Water",null,2701.8,2702.8]
[null," Washed Wt (D)",null,null,1374.7,null,null,null," B (Wt. Spec. S.S.D.)",null,4706,4699.7]
[null," Pan Matl (E)",null,null,4.0999999999999996,null,null,null," B - C",null,{"$f":"IF(K33=\"\",\"\",+K35-K34)","v":2004.1999999999998},{"$f":"IF(L33=\"\",\"\",+L35-L34)","v":1996.8999999999996},{"$f":"IF(M33=\"\",\"\",+M35-M34)","v":""}]
[null," Wt of Loss by Washing (W1)",null,null,{"$f":"IF(E35=\"\",\"\",E34-E35)","v":85.299999999999955},null,null,null," L.M. Spec. Grav. - Gmb",null,{"$f":"IF(K33=0,\"\",ROUND((K33/K36),Tables!$E$46))","v":2.347},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$46))","v":2.3530000000000002},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$46))","v":""}]
[null," Total Agg. Passing 200 (W2)",null,null,{"$f":"IF(E36=\"\",\"\",+E37+E36)","v":89.399999999999949},null,null,null," Avg. L.M. Spec. Grav.",null,null,{"$f":"IF(K37=\"\",\"\",ROUND(AVERAGE(K37,L37,M37),Tables!$E$47))","v":2.35}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$30))","v":0},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$48))","v":96.1},{"$f":"IF(L39=\"\",\"\",IF(OR(ROUND(L39,1)<O39,ROUND(L39,1)>Q39),\"ERR\",\"\"))","v":""},null,94.5,"-",97.4,"  Enter %Density of Gmm req'd for lab compaction as listed for JMF on mix design."]
[null,null,null,null,null,null,null,null," % Air Voids",null,null,{"$f":"IF(L39=\"\",\"\",ROUND(100-(L38/L31*100),Tables!$E$49))","v":3.9},{"$f":"IF(L40=\"\",\"\",ABS(O40-L40))","v":0.10000000000000009},null,{"$f":"100-ROUND(AVERAGE(O39,Q39),0)","v":4},null,"%Air Voids Target",null,null," e.g. Superpave & SMA = 4%,  RIL = 3%, RBL = 2%"]
[null,"MOISTURE & VOLATILE SAMPLE",null,null,null,null,null,null," % V.M.A.",null,null,{"$f":"IF(L38=\"\",\"\",IF(L38>0,ROUND(100-L38*(100-L30)/L28,Tables!$E$50),Tables!E50))","v":14.7},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":""},null,14,null,"Enter required field VMA from mix design. "]
[null," Pan",null,null,0,null,null,null,{"$f":"IF(M39=\"ERR\",\"%L.M. Density out of range\",\"\")","v":""},null,null,{"$f":"IF(M41=\"ERR\",\" %VMA out of range\",\"\")","v":""},null,null,null,null,"     S.P. 708-26 VMA Field:  S6=16.0, S5=15.0, S4=14.0, S3=13.0, S2=12.0"]
[null," Original Mix (W1m)",null,null,4910.3999999999996,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":4910.3999999999996},null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)",null,null,null,null,null,null,null,"     2009 Specs VMA Field:  S6=15.5, S5=14.5, S4=13.5, S3=12.5, S2=11.5"]
[null," Dry Mix (W5m)",null,null,4910.3999999999996,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":4910.3999999999996},null,null,"m = ",0.98919999999999997,"b = ",2.7300000000000001E-2]
[null,null,null,null,null,null,null,null,{"$f":"IF(O45=\"\",\" Avg. Rice\",\" Max. Theo. at JMF AC\")","v":" Max. Theo. at JMF AC"},null,null,{"$f":"IF(L24=\"\",\"\",ROUND(L24,Tables!$E$52))","v":2.4449999999999998},"Gmm",null,{"$f":"IF(O8=\"\",\"\",VLOOKUP(O8,GTable,5))","v":85.5},null," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null," Specimen No.",null,1,2,3,null,{"$f":"IF(O8=\"\",\"\",VLOOKUP(O8,GTable,7))","v":89},null," Nini Maximum Requirement"]
[null," S.E. No.",null,"1","2",{"$f":"+IF(F48=\"\",\"\",3)","v":""},null,null," Station"]
[null," Sand Reading",null,null,null,null,null,null," Expressway"]
[null," Clay Reading",null,null,null,null,null,null," Lane"]
[null," Sand Equivalent",null,{"$f":"IF(D49=\"\",\"\",ROUNDUP(MROUND(D48/D49*100,0.1),0))","v":""},{"$f":"IF(E49=\"\",\"\",ROUNDUP(MROUND(E48/E49*100,0.1),0))","v":""},{"$f":"IF(F49=\"\",\"\",ROUNDUP(MROUND(F48/F49*100,0.1),0))","v":""},null,null," Shot # 1",null,145.19999999999999,140.9,142.30000000000001]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",ROUNDUP(MROUND(SUM(D50:F50)/COUNT(D50:F50),0.1),0))","v":""},null,null,null," Shot # 2",null,146.1,140.5,144.19999999999999,null,45,null," Minimum S.E. Requirement.  See mix design or Specifications for limit by ESALs or binder type."]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O51,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Shot # 3"]
[null,"Lab Molded","# of","Specimen","RATIO","LSMG","% Density",null," Shot # 4"]
[null,"Specimen","Gyrations","Height","(Ht@Ndes","(RATIO x","(LSMG",null," Avg. Unit Weight",null,{"$f":"IF(K51=\"\",\"\",AVERAGE(K50:K53))","v":145.64999999999998},{"$f":"IF(L51=\"\",\"\",AVERAGE(L50:L53))","v":140.69999999999999},{"$f":"IF(M51=\"\",\"\",AVERAGE(M50:M53))","v":143.25}]
[null," @ Ndes",null,null,"/Ht@Nini)","LSMG @","X 100/",null," Nuclear Core Spec. Grav.",null,{"$f":"IF(K54=\"\",\"\",ROUND((K54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.3359999999999999},{"$f":"IF(L54=\"\",\"\",ROUND((L54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.258},{"$f":"IF(M54=\"\",\"\",ROUND((M54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.298},null,{"$f":"COUNT(K54:M54)","v":3},null," No. of Cores"]
[null,null,null,null,null,"Ndes)","Rice's)",null," Calc. Avg. Bulk Core Sp. Gr.",null,null,{"$f":"IF(K55=\"\",\"\",ROUND(SUM(((K55+L55+M55))/O55),Tables!$E$55))","v":2.2970000000000002}]
[null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":8},123.4,{"$f":"IF(D57=\"\",\"\",ROUND((D58/D57),Tables!$E$35))","v":0.9254},{"$f":"IF(D57=\"\",\"\",ROUND((E57*F58),Tables!$E$36))","v":2.1749999999999998},{"$f":"IF(AND(F58<>\"\",OR(D57=\"\",D58=\"\")),\"ERR\",IF(D58=\"\",\"\",ROUND(((F57*100)/$L$24),Tables!$E$37)))","v":89},null," % Roadway Density",null,{"$f":"IF(K55=\"\",\"\",ROUND(K55/$L$45*100,Tables!$E$56))","v":95.5},{"$f":"IF(L55=\"\",\"\",ROUND(L55/$L$45*100,Tables!$E$56))","v":92.4},{"$f":"IF(M55=\"\",\"\",ROUND(M55/$L$45*100,Tables!$E$56))","v":94}]
[null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":100},114.2,1,{"$f":"IF(D58=\"\",\"\",L38)","v":2.35},{"$f":"IF(D58=\"\",\"\",ROUND(((F58*100)/$L$24),Tables!$E$38))","v":96.1},null," % Avg. Roadway Density",null,null,{"$f":"IF(L44=\"\",\"\",IF(L44>0,ROUND(L56/L45*100,Tables!$E$57),\"\"))","v":93.9},null,null,{"$f":"100-O40-2","v":94},null,"100 - (lab-molded % Air Voids) - 2, is the usual target roaday percent compaction."]
[null,{"$f":"(IF(G58=\"\",\"\",IF(OR($G$57=\"ERR\",OR($G57>$O46,$G$57<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""},{"$f":"(IF(G58=\"\",\"\",IF(OR($G$57=\"ERR\",OR($G57>$O46,$G$57<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""},null,null,null,null,null,null,{"$f":"IF(L58=\"\",\"\",IF(OR(L58>97,L58<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]
[]
[null,"Signature / Cert. ID",null,null,"/"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"Sublot 2","index":1,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[53,8,53,9],[54,8,54,9],[55,8,55,9],[48,1,48,2],[37,8,37,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[42,8,42,12],[36,8,36,9],[1,0,1,13],[2,0,2,13],[3,0,3,13],[5,1,5,4],[5,6,5,8],[5,9,5,10],[5,11,5,13],[6,1,6,4],[6,6,6,8],[6,9,6,10],[6,11,6,13],[7,1,7,4],[7,6,7,8],[7,9,7,10],[7,11,7,13],[9,1,9,6],[10,1,10,6],[10,9,10,10],[11,4,11,6],[11,9,11,11],[27,8,27,9],[29,8,29,9],[30,8,30,9],[12,9,12,11],[13,8,13,12],[23,8,23,9],[24,8,24,9],[26,8,26,12],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[28,8,28,9],[30,1,30,2],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[0,1,0,13],[57,8,57,9],[56,8,56,9],[42,1,42,2],[43,1,43,2],[45,1,45,5],[46,1,46,2],[47,1,47,2],[49,1,49,2],[50,1,50,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,1,40,5],[41,1,41,2],[31,1,31,2]]}
[{"$f":"'Sublot 1'!A1","v":"v 1.14"},"OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
["SUPERPAVE"]
[{"$f":"'Sublot 1'!A3:N3","v":"McALESTER RESIDENCY"}]
["HOT MIX ASPHALT SAMPLE SHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INFORMATION FROM MIX DESIGN:"]
[" Project No. ",{"$f":"IF('Sublot 1'!B6=\"\",\"\",'Sublot 1'!B6)","v":""},null,null,null,"J.P. No.",{"$f":"IF('Sublot 1'!G6=\"\",\"\",'Sublot 1'!G6)","v":""},null,null,"Contract No. ",null,{"$f":"IF('Sublot 1'!L6=\"\",\"\",'Sublot 1'!L6)","v":""}]
[" Contractor ",{"$f":"IF('Sublot 1'!B7=\"\",\"\",'Sublot 1'!B7)","v":""},null,null,null,"Producer",{"$f":"IF('Sublot 1'!G7=\"\",\"\",'Sublot 1'!G7)","v":""},null,null," Plant Location ",null,{"$f":"IF('Sublot 1'!L7=\"\",\"\",'Sublot 1'!L7)","v":""}]
[{"$f":"'Sublot 1'!A8","v":"SM Sample ID"},null,null,null,null,"Mix Type",{"$f":"IF('Sublot 1'!G8=\"\",\"\",'Sublot 1'!G8)","v":""},null,null,"Design No. ",null,{"$f":"IF('Sublot 1'!L8=\"\",\"\",'Sublot 1'!L8)","v":""},null,null,{"$f":"'Sublot 1'!O8","v":"3M+"},"    Million ESALs or PG Grade: Select from drop-down list."]
[]
[null,"EXTRACTIONS AND GRADATIONS",null,null,null,null,null,"IOC",1000,"  TOTAL TONS for this SubLOT"]
[null,"(OHD L-26, AASHTO T-30, T-11)",null,null,null,null,null,{"$f":"IF('Sublot 1'!H11=\"\",\"\",'Sublot 1'!H11)","v":0.18},{"$f":"'Sublot 1'!I11","v":2.6589999999999998},"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",{"$f":"'Sublot 1'!I12","v":2.6120000000000001},"  Gsb from Design",null,null,null,null,"A","    Change for each sheet if A is not used on each.  Rices Precision: Select from drop-down list.  "]
[null," Temperature ",null,"Lot",{"$f":"IF('Sublot 1'!E13=\"\",\"\",'Sublot 1'!E13)","v":1},"SubLot",2,{"$f":"IF('Sublot 1'!H13=\"\",\"\",'Sublot 1'!H13)","v":4700},{"$f":"'Sublot 1'!I13","v":1.01},"  Spec. Grav. AC from Design",null,null,null,null,{"$f":"VLOOKUP(O12,PTable,2,FALSE)","v":1.4E-2},"    Method A - Mechanical or Method B - Manual"]
[null,"SIEVE","JMF","Acc. Wt.","Acc. %"," Total Agg.",null,null,"MAXIMUM SPECIFIC GRAVITY  (AASHTO T209)"]
[null,"SIZE",null,"Retd.","Retd."," % Passing","Dev.",null," Sub-Lot No.",null,null,null,null,null,null,"Limits",null,null,"Tolerance"]
[null,"1 1/2\" (37.5 mm)",{"$f":"'Sublot 1'!C16","v":100},0,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$27))","v":0},{"$f":"IF(D16=\"\",\"\",100-E16)","v":100},{"$f":"IF(D16=\"\",\"\",IF(F16<$P16,ABS(F16-$P16),IF(F16>$Q16,ABS($Q16-F16),Tables!$E$27)))","v":0},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":100},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":100},null,0]
[null,"1\" (25.0 mm)",{"$f":"'Sublot 1'!C17","v":100},0,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$27))","v":0},100,{"$f":"IF(D17=\"\",\"\",IF(F17<$P17,ABS(F17-$P17),IF(F17>$Q17,ABS($Q17-F17),Tables!$E$27)))","v":0},null," Flask No.",null,2,"|",4,null,"1\" (25.0 mm)",100,100,null,0]
[null,"3/4\" (19.0 mm",{"$f":"'Sublot 1'!C18","v":100},0,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$27))","v":0},100,{"$f":"IF(D18=\"\",\"\",IF(F18<$P18,ABS(F18-$P18),IF(F18>$Q18,ABS($Q18-F18),Tables!$E$27)))","v":0},null," Sample Wt.","           (A)  ",1507.9,"|",1513.2,null,"3/4\" (19.0 mm",100,100,null,0]
[null,"1/2\" (12.5 mm)",{"$f":"'Sublot 1'!C19","v":96},25.6,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$27))","v":2},98,{"$f":"IF(D19=\"\",\"\",IF(F19<$P19,ABS(F19-$P19),IF(F19>$Q19,ABS($Q19-F19),Tables!$E$27)))","v":0},null," Calib. Wt.","           (B)  ",6179,"|",6250.7,null,"1/2\" (12.5 mm)",89,100,null,7]
[null,"3/8\" (9.5 mm)",{"$f":"'Sublot 1'!C20","v":86},176,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$27))","v":12},88,{"$f":"IF(D20=\"\",\"\",IF(F20<$P20,ABS(F20-$P20),IF(F20>$Q20,ABS($Q20-F20),Tables!$E$27)))","v":0},null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":7686.9},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":7763.9},null,"3/8\" (9.5 mm)",79,93,null,7]
[null,"# 4 ( 4.75 mm)",{"$f":"'Sublot 1'!C21","v":61},506.2,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$27))","v":34},66,{"$f":"IF(D21=\"\",\"\",IF(F21<$P21,ABS(F21-$P21),IF(F21>$Q21,ABS($Q21-F21),Tables!$E$27)))","v":0},null," Sample + Flask + H²O  (D)",null,7076.2,"|",7151.5,null,"# 4 ( 4.75 mm)",54,68,null,7]
[null,"# 8 (2.36 mm)",{"$f":"'Sublot 1'!C22","v":44},807.4,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$27))","v":55},45,{"$f":"IF(D22=\"\",\"\",IF(F22<$P22,ABS(F22-$P22),IF(F22>$Q22,ABS($Q22-F22),Tables!$E$27)))","v":0},null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":610.69999999999982},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":612.39999999999964},null,"# 8 (2.36 mm)",39,49,null,5]
[null,"# 16 ( 1.18 mm)",{"$f":"'Sublot 1'!C23","v":32},995.3,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$27))","v":68},32,{"$f":"IF(D23=\"\",\"\",IF(F23<$P23,ABS(F23-$P23),IF(F23>$Q23,ABS($Q23-F23),Tables!$E$27)))","v":0},null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$40),\"\")","v":2.4689999999999999},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$40),\"\")","v":2.4710000000000001},null,"# 16 ( 1.18 mm)",28,36,null,4]
[null,"# 30 (.600 mm)",{"$f":"'Sublot 1'!C24","v":23},1128.3,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$27))","v":77},23,{"$f":"IF(D24=\"\",\"\",IF(F24<$P24,ABS(F24-$P24),IF(F24>$Q24,ABS($Q24-F24),Tables!$E$27)))","v":0},null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$41))","v":2.4700000000000002},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",19,27,null,4]
[null,"# 50 (.300 mm)",{"$f":"'Sublot 1'!C25","v":13},1275.2,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$27))","v":87},13,{"$f":"IF(D25=\"\",\"\",IF(F25<$P25,ABS(F25-$P25),IF(F25>$Q25,ABS($Q25-F25),Tables!$E$27)))","v":0},null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$42),\"\")","v":2.6640000000000001},null,null,"# 50 (.300 mm)",9,17,null,4]
[null,"# 100 (.150 mm)",{"$f":"'Sublot 1'!C26","v":7},1347.2,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$27))","v":92},8,{"$f":"IF(D26=\"\",\"\",IF(F26<$P26,ABS(F26-$P26),IF(F26>$Q26,ABS($Q26-F26),Tables!$E$27)))","v":0},null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",4,10,null,3]
[null,"# 200 (.075 mm)",{"$f":"'Sublot 1'!C27","v":4.4000000000000004},1386,null,null,null,null,"   LAB MOLDED DENSITY  (OHD L-8, L-14) @ Ndes"]
[null," Total -200 (W3)",null,null,null,{"$f":"IF(E34=\"\",\"\",ROUND((E38/E34)*100,Tables!$E$28))","v":5.6},{"$f":"IF(D27=\"\",\"\",IF(F28<$P28,ROUND($P28-F28,Tables!$E$28),IF(F28>$Q28,ROUND(F28-$Q28,Tables!$E$28),0)))","v":0},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$44))","v":2.617},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":2.4000000000000004},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":6.4},null,2]
[null," % AC (P5m)",{"$f":"'Sublot 1'!C29","v":4.9000000000000004},4.8099999999999996,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":1.01}]
[null," Corrected %AC",".",null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$29))","v":4.8},{"$f":"IF(D29=\"\",\"\",IF(ABS(C29-F30)>S30,ROUND(ABS(C29-F30),Tables!$E$33),0))","v":0},null," % AC",null,null,{"$f":"IF(K33=\"\",\"\",+F30)","v":4.8},null,null," Corrected %AC",{"$f":"IF(C29=\"\",\"\",C29-S30)","v":4.5},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":5.3000000000000007},null,0.4]
[null," Basket (A)",null,null,3362.5,null,null,null," Max. Theo. Spec. Grav.",null,null,{"$f":"IF(D29=\"\",\"\",IF($L$24=\"\",ROUND((100/(($F$30/$I$13)+(100-$F$30)/#REF!)),Tables!$E$45),L24))","v":2.4700000000000002}]
[null," Basket + Mix (B)",null,null,4710.3999999999996,null,null,null," Specimen No.",null,1,2]
[null," Mix (B-A)",null,null,{"$f":"IF(E31=\"\",\"\",+E32-E31)","v":1347.8999999999996},null,null,null," A (Wt. Spec. in Air)",null,4700.3,4704.8]
[null," Extr. Aggr. Wt (C)",null,{"$f":"IF(D31=\"\",\"\",+D31+D32)","v":""},1468.9,null,null,null," C (Wt. Spec. in Water",null,2719.6,2722.4]
[null," Washed Wt (D)",null,null,1390,null,null,null," B (Wt. Spec. S.S.D.)",null,4705.3,4709]
[null," Pan Matl (E)",null,null,3.6,null,null,null," B - C",null,{"$f":"IF(K33=\"\",\"\",+K35-K34)","v":1985.7000000000003},{"$f":"IF(L33=\"\",\"\",+L35-L34)","v":1986.6},{"$f":"IF(M33=\"\",\"\",+M35-M34)","v":""}]
[null," Wt of Loss by Washing (W1)",null,null,{"$f":"IF(E35=\"\",\"\",E34-E35)","v":78.900000000000091},null,null,null," L.M. Spec. Grav. - Gmb",null,{"$f":"IF(K33=0,\"\",ROUND((K33/K36),Tables!$E$46))","v":2.367},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$46))","v":2.3679999999999999},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$46))","v":""}]
[null," Total Agg. Passing 200 (W2)",null,null,{"$f":"IF(E36=\"\",\"\",+E37+E36)","v":82.500000000000085},null,null,null," Avg. L.M. Spec. Grav.",null,null,{"$f":"IF(K37=\"\",\"\",ROUND(AVERAGE(K37,L37,M37),Tables!$E$47))","v":2.3679999999999999}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$30))","v":0},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$48))","v":95.9},{"$f":"IF(L39=\"\",\"\",IF(OR(ROUND(L39,1)<O39,ROUND(L39,1)>Q39),\"ERR\",\"\"))","v":""},null,{"$f":"'Sublot 1'!O39","v":94.5},"-",{"$f":"'Sublot 1'!Q39","v":97.4},"  Enter %Density of GMM reqd.  as listed on JMF"]
[null,null,null,null,null,null,null,null," % Air Voids",null,null,{"$f":"IF(L39=\"\",\"\",ROUND(100-(L38/L31*100),Tables!$E$49))","v":4.0999999999999996},{"$f":"IF(L40=\"\",\"\",ABS(O40-L40))","v":9.9999999999999645E-2},null,{"$f":"'Sublot 1'!O40","v":4},null,"%Air Voids Target",null,null," (Superpave, SMA) = 4%,  (RBL) = 2%"]
[null,"MOISTURE & VOLATILE SAMPLE",null,null,null,null,null,null," % V.M.A.",null,null,{"$f":"IF(L38=\"\",\"\",IF(L38>0,ROUND(100-L38*(100-L30)/L28,Tables!$E$50),Tables!E50))","v":13.9},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":"ERR"},null,{"$f":"'Sublot 1'!O41","v":14},null,"Enter required field VMA from mix design. "]
[null," Pan",null,null,null,null,null,null,{"$f":"IF(M39=\"ERR\",\"%L.M. Density out of range\",\"\")","v":""},null,null,{"$f":"IF(M41=\"ERR\",\" %VMA out of range\",\"\")","v":" %VMA out of range"}]
[null," Original Mix (W1m)",null,null,4710.3999999999996,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":4710.3999999999996},null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Dry Mix (W5m)",null,null,4710.3999999999996,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":4710.3999999999996},null,null,"m = ",0.98919999999999997,"b = ",2.7300000000000001E-2]
[null,null,null,null,null,null,null,null,{"$f":"IF(O45=\"\",\" Avg. Rice\",\" Max. Theo. at JMF AC\")","v":" Max. Theo. at JMF AC"},null,null,{"$f":"IF(L24=\"\",\"\",ROUND(L24,Tables!$E$52))","v":2.4700000000000002},"Gmm",null,{"$f":"VLOOKUP(O8,GTable,5)","v":85.5}," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null," Specimen No.",null,1,"2","3",null,{"$f":"VLOOKUP(O8,GTable,7)","v":89}," Nini Maximum Requirement"]
[null," S.E. No.",null,"1","2",{"$f":"+IF(F48=\"\",\"\",3)","v":""},null,null," Station"]
[null," Sand Reading",null,null,null,null,null,null," Expressway"]
[null," Clay Reading",null,null,null,null,null,{"$f":"IF(O49=1,\"OHD L-14\",\"\")","v":""}," Lane"]
[null," Sand Equivalent",null,{"$f":"IF(D49=\"\",\"\",ROUNDUP(MROUND(D48/D49*100,0.1),0))","v":""},{"$f":"IF(E49=\"\",\"\",ROUNDUP(MROUND(E48/E49*100,0.1),0))","v":""},{"$f":"IF(F49=\"\",\"\",ROUNDUP(MROUND(F48/F49*100,0.1),0))","v":""},null,null," Shot # 1",null,140.30000000000001,141.5,140.5]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",ROUNDUP(MROUND(SUM(D50:F50)/COUNT(D50:F50),0.1),0))","v":""},null,null,null," Shot # 2",null,141.4,142.5,140.4,null,45," Minimum S.E. Requirement"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O50,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Shot # 3"]
[null,"Lab Molded","# of","Specimen","RATIO","LSMG","% Density",null," Shot # 4"]
[null,"Specimen","Gyrations","Height","(Ht@Ndes","(RATIO x","(LSMG",null," Avg. Unit Weight",null,{"$f":"IF(K51=\"\",\"\",AVERAGE(K50:K53))","v":140.85000000000002},{"$f":"IF(L51=\"\",\"\",AVERAGE(L50:L53))","v":142},{"$f":"IF(M51=\"\",\"\",AVERAGE(M50:M53))","v":140.44999999999999}]
[null," @ Ndes",null,null,"/Ht@Nini)","LSMG @","X 100/",null," Nuclear Core Spec. Grav.",null,{"$f":"IF(K54=\"\",\"\",ROUND((K54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.2599999999999998},{"$f":"IF(L54=\"\",\"\",ROUND((L54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.278},{"$f":"IF(M54=\"\",\"\",ROUND((M54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.254},null,{"$f":"COUNT(K54:M54)","v":3}," No. of Cores"]
[null,null,null,null,null,"Ndes)","Rice's)",null," Calc. Avg. Bulk Core Sp. Gr.",null,null,{"$f":"IF(K55=\"\",\"\",ROUND(SUM(((K55+L55+M55))/O55),Tables!$E$55))","v":2.2639999999999998}]
[null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":8},124.1,{"$f":"IF(D57=\"\",\"\",ROUND((D58/D57),Tables!$E$35))","v":0.92100000000000004},{"$f":"IF(D57=\"\",\"\",ROUND((E57*F58),Tables!$E$36))","v":2.181},{"$f":"IF(AND(F58<>\"\",OR(D57=\"\",D58=\"\")),\"ERR\",IF(D58=\"\",\"\",ROUND(((F57*100)/$L$24),Tables!$E$37)))","v":88.3},null," % Roadway Density",null,{"$f":"IF(K55=\"\",\"\",ROUND(K55/$L$45*100,Tables!$E$56))","v":91.5},{"$f":"IF(L55=\"\",\"\",ROUND(L55/$L$45*100,Tables!$E$56))","v":92.2},{"$f":"IF(M55=\"\",\"\",ROUND(M55/$L$45*100,Tables!$E$56))","v":91.3}]
[null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":100},114.3,1,{"$f":"IF(D58=\"\",\"\",L38)","v":2.3679999999999999},{"$f":"IF(D58=\"\",\"\",ROUND(((F58*100)/$L$24),Tables!$E$38))","v":95.9},null," % Avg. Roadway Density",null,null,{"$f":"IF(L44=\"\",\"\",IF(L44>0,ROUND(L56/L45*100,Tables!$E$57),\"\"))","v":91.7}]
[null,null,{"$f":"(IF(G58=\"\",\"\",IF(OR($G$57=\"ERR\",OR($G57>$O46,$G$57<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""},null,null,null,null,null,null,{"$f":"IF(L58=\"\",\"\",IF(OR(L58>97,L58<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]
[]
[null,"Signature / Cert. ID",null,null,"/"]

{"sheet":"Sublot 3","index":2,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[40,8,40,9],[57,8,57,9],[56,8,56,9],[55,8,55,9],[53,8,53,9],[54,8,54,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[37,8,37,9],[50,1,50,2],[49,1,49,2],[33,8,33,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[41,1,41,2],[42,1,42,2],[43,1,43,2],[45,1,45,5],[46,1,46,2],[47,1,47,2],[48,1,48,2],[42,8,42,12],[38,8,38,9],[39,8,39,9],[13,8,13,12],[23,8,23,9],[24,8,24,9],[40,1,40,5],[26,8,26,12],[28,8,28,9],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[27,8,27,9],[12,9,12,11],[6,1,6,4],[6,6,6,8],[6,9,6,10],[6,11,6,13],[7,1,7,4],[7,6,7,8],[7,9,7,10],[7,11,7,13],[9,1,9,6],[10,1,10,6],[10,9,10,10],[11,4,11,6],[11,9,11,11],[0,1,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[5,1,5,4],[5,6,5,8],[5,9,5,10],[5,11,5,13]]}
[{"$f":"'Sublot 1'!A1","v":"v 1.14"},"OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
["SUPERPAVE"]
[{"$f":"'Sublot 1'!A3:N3","v":"McALESTER RESIDENCY"}]
["HOT MIX ASPHALT SAMPLE SHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INFORMATION FROM MIX DESIGN:"]
[" Project No. ",{"$f":"IF('Sublot 1'!B6=\"\",\"\",'Sublot 1'!B6)","v":""},null,null,null,"J.P. No.",{"$f":"IF('Sublot 1'!G6=\"\",\"\",'Sublot 1'!G6)","v":""},null,null,"Contract No. ",null,{"$f":"IF('Sublot 1'!L6=\"\",\"\",'Sublot 1'!L6)","v":""}]
[" Contractor ",{"$f":"IF('Sublot 1'!B7=\"\",\"\",'Sublot 1'!B7)","v":""},null,null,null,"Producer",{"$f":"IF('Sublot 1'!G7=\"\",\"\",'Sublot 1'!G7)","v":""},null,null," Plant Location ",null,{"$f":"IF('Sublot 1'!L7=\"\",\"\",'Sublot 1'!L7)","v":""}]
[{"$f":"'Sublot 1'!A8","v":"SM Sample ID"},null,null,null,null,"Mix Type",{"$f":"IF('Sublot 1'!G8=\"\",\"\",'Sublot 1'!G8)","v":""},null,null,"Design No. ",null,{"$f":"IF('Sublot 1'!L8=\"\",\"\",'Sublot 1'!L8)","v":""},null,null,{"$f":"'Sublot 1'!O8","v":"3M+"},"    Million ESALs or PG Grade: Select from drop-down list."]
[]
[null,"EXTRACTIONS AND GRADATIONS",null,null,null,null,null,"IOC",1000,"  TOTAL TONS for this SubLOT"]
[null,"(OHD L-26, AASHTO T-30, T-11)",null,null,null,null,null,{"$f":"IF('Sublot 1'!H11=\"\",\"\",'Sublot 1'!H11)","v":0.18},{"$f":"'Sublot 1'!I11","v":2.6589999999999998},"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",{"$f":"'Sublot 1'!I12","v":2.6120000000000001},"  Gsb from Design",null,null,null,null,"A","    Change for each sheet if A is not used on each.  Rices Precision: Select from drop-down list.  "]
[null," Temperature ",null,"Lot",{"$f":"IF('Sublot 1'!E13=\"\",\"\",'Sublot 1'!E13)","v":1},"SubLot",3,{"$f":"IF('Sublot 1'!H13=\"\",\"\",'Sublot 1'!H13)","v":4700},{"$f":"'Sublot 1'!I13","v":1.01},"  Spec. Grav. AC from Design",null,null,null,null,{"$f":"VLOOKUP(O12,PTable,2,FALSE)","v":1.4E-2},"    Method A - Mechanical or Method B - Manual"]
[null,"SIEVE","JMF","Acc. Wt.","Acc. %"," Total Agg.",null,null,"MAXIMUM SPECIFIC GRAVITY  (AASHTO T209)"]
[null,"SIZE",null,"Retd.","Retd."," % Passing","Dev.",null," Sub-Lot No.",null,null,null,null,null,null,"Limits",null,null,"Tolerance"]
[null,"1 1/2\" (37.5 mm)",{"$f":"'Sublot 2'!C16","v":100},0,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$27))","v":0},{"$f":"IF(D16=\"\",\"\",100-E16)","v":100},{"$f":"IF(D16=\"\",\"\",IF(F16<$P16,ABS(F16-$P16),IF(F16>$Q16,ABS($Q16-F16),Tables!$E$27)))","v":0},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":100},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":100},null,0]
[null,"1\" (25.0 mm)",{"$f":"'Sublot 2'!C17","v":100},0,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$27))","v":0},100,{"$f":"IF(D17=\"\",\"\",IF(F17<$P17,ABS(F17-$P17),IF(F17>$Q17,ABS($Q17-F17),Tables!$E$27)))","v":0},null," Flask No.",null,2,"|",4,null,"1\" (25.0 mm)",100,100,null,0]
[null,"3/4\" (19.0 mm",{"$f":"'Sublot 2'!C18","v":100},0,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$27))","v":0},100,{"$f":"IF(D18=\"\",\"\",IF(F18<$P18,ABS(F18-$P18),IF(F18>$Q18,ABS($Q18-F18),Tables!$E$27)))","v":0},null," Sample Wt.","           (A)  ",1576.3,"|",1548,null,"3/4\" (19.0 mm",100,100,null,0]
[null,"1/2\" (12.5 mm)",{"$f":"'Sublot 2'!C19","v":96},48,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$27))","v":3},97,{"$f":"IF(D19=\"\",\"\",IF(F19<$P19,ABS(F19-$P19),IF(F19>$Q19,ABS($Q19-F19),Tables!$E$27)))","v":0},null," Calib. Wt.","           (B)  ",6179,"|",6250.7,null,"1/2\" (12.5 mm)",89,100,null,7]
[null,"3/8\" (9.5 mm)",{"$f":"'Sublot 2'!C20","v":86},188.9,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$27))","v":13},87,{"$f":"IF(D20=\"\",\"\",IF(F20<$P20,ABS(F20-$P20),IF(F20>$Q20,ABS($Q20-F20),Tables!$E$27)))","v":0},null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":7755.3},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":7798.7},null,"3/8\" (9.5 mm)",79,93,null,7]
[null,"# 4 ( 4.75 mm)",{"$f":"'Sublot 2'!C21","v":61},516.4,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$27))","v":35},65,{"$f":"IF(D21=\"\",\"\",IF(F21<$P21,ABS(F21-$P21),IF(F21>$Q21,ABS($Q21-F21),Tables!$E$27)))","v":0},null," Sample + Flask + H²O  (D)",null,7115,"|",7171,null,"# 4 ( 4.75 mm)",54,68,null,7]
[null,"# 8 (2.36 mm)",{"$f":"'Sublot 2'!C22","v":44},800.5,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$27))","v":55},45,{"$f":"IF(D22=\"\",\"\",IF(F22<$P22,ABS(F22-$P22),IF(F22>$Q22,ABS($Q22-F22),Tables!$E$27)))","v":0},null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":640.30000000000018},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":627.69999999999982},null,"# 8 (2.36 mm)",39,49,null,5]
[null,"# 16 ( 1.18 mm)",{"$f":"'Sublot 2'!C23","v":32},983.7,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$27))","v":67},33,{"$f":"IF(D23=\"\",\"\",IF(F23<$P23,ABS(F23-$P23),IF(F23>$Q23,ABS($Q23-F23),Tables!$E$27)))","v":0},null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$40),\"\")","v":2.4620000000000002},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$40),\"\")","v":2.4660000000000002},null,"# 16 ( 1.18 mm)",28,36,null,4]
[null,"# 30 (.600 mm)",{"$f":"'Sublot 2'!C24","v":23},1116.8,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$27))","v":76},24,{"$f":"IF(D24=\"\",\"\",IF(F24<$P24,ABS(F24-$P24),IF(F24>$Q24,ABS($Q24-F24),Tables!$E$27)))","v":0},null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$41))","v":2.464},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",19,27,null,4]
[null,"# 50 (.300 mm)",{"$f":"'Sublot 2'!C25","v":13},1262.3,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$27))","v":86},14,{"$f":"IF(D25=\"\",\"\",IF(F25<$P25,ABS(F25-$P25),IF(F25>$Q25,ABS($Q25-F25),Tables!$E$27)))","v":0},null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$42),\"\")","v":2.657},null,null,"# 50 (.300 mm)",9,17,null,4]
[null,"# 100 (.150 mm)",{"$f":"'Sublot 2'!C26","v":7},1335.4,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$27))","v":91},9,{"$f":"IF(D26=\"\",\"\",IF(F26<$P26,ABS(F26-$P26),IF(F26>$Q26,ABS($Q26-F26),Tables!$E$27)))","v":0},null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",4,10,null,3]
[null,"# 200 (.075 mm)",{"$f":"'Sublot 2'!C27","v":4.4000000000000004},1373.3,null,null,null,null,"   LAB MOLDED DENSITY  (OHD L-8, L-14) @ Ndes"]
[null," Total -200 (W3)",null,null,null,{"$f":"IF(E34=\"\",\"\",ROUND((E38/E34)*100,Tables!$E$28))","v":6.1},{"$f":"IF(D27=\"\",\"\",IF(F28<$P28,ROUND($P28-F28,Tables!$E$28),IF(F28>$Q28,ROUND(F28-$Q28,Tables!$E$28),0)))","v":0},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$44))","v":2.61},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":2.4000000000000004},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":6.4},null,2]
[null," % AC (P5m)",{"$f":"'Sublot 2'!C29","v":4.9000000000000004},4.8,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":1.01}]
[null," Corrected %AC",".",null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$29))","v":4.8},{"$f":"IF(D29=\"\",\"\",IF(ABS(C29-F30)>S30,ROUND(ABS(C29-F30),Tables!$E$33),0))","v":0},null," % AC",null,null,{"$f":"IF(K33=\"\",\"\",+F30)","v":4.8},null,null," Corrected %AC",{"$f":"IF(C29=\"\",\"\",C29-S30)","v":4.5},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":5.3000000000000007},null,0.4]
[null," Basket (A)",null,null,3362.5,null,null,null," Max. Theo. Spec. Grav.",null,null,{"$f":"IF(D29=\"\",\"\",IF($L$24=\"\",ROUND((100/(($F$30/$I$13)+(100-$F$30)/#REF!)),Tables!$E$45),L24))","v":2.464}]
[null," Basket + Mix (B)",null,null,4902.5,null,null,null," Specimen No.",null,1,2]
[null," Mix (B-A)",null,null,{"$f":"IF(E31=\"\",\"\",+E32-E31)","v":1540},null,null,null," A (Wt. Spec. in Air)",null,4695.7,4696.3]
[null," Extr. Aggr. Wt (C)",null,{"$f":"IF(D31=\"\",\"\",+D31+D32)","v":""},1461.7,null,null,null," C (Wt. Spec. in Water",null,2721.7,2723.6]
[null," Washed Wt (D)",null,null,1375.6,null,null,null," B (Wt. Spec. S.S.D.)",null,4697.8,4698.3]
[null," Pan Matl (E)",null,null,2.6,null,null,null," B - C",null,{"$f":"IF(K33=\"\",\"\",+K35-K34)","v":1976.1000000000004},{"$f":"IF(L33=\"\",\"\",+L35-L34)","v":1974.7000000000003},{"$f":"IF(M33=\"\",\"\",+M35-M34)","v":""}]
[null," Wt of Loss by Washing (W1)",null,null,{"$f":"IF(E35=\"\",\"\",E34-E35)","v":86.100000000000136},null,null,null," L.M. Spec. Grav. - Gmb",null,{"$f":"IF(K33=0,\"\",ROUND((K33/K36),Tables!$E$46))","v":2.3759999999999999},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$46))","v":2.3780000000000001},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$46))","v":""}]
[null," Total Agg. Passing 200 (W2)",null,null,{"$f":"IF(E36=\"\",\"\",+E37+E36)","v":88.700000000000131},null,null,null," Avg. L.M. Spec. Grav.",null,null,{"$f":"IF(K37=\"\",\"\",ROUND(AVERAGE(K37,L37,M37),Tables!$E$47))","v":2.3769999999999998}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$30))","v":0},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$48))","v":96.5},{"$f":"IF(L39=\"\",\"\",IF(OR(ROUND(L39,1)<O39,ROUND(L39,1)>Q39),\"ERR\",\"\"))","v":""},null,{"$f":"'Sublot 1'!O39","v":94.5},"-",{"$f":"'Sublot 1'!Q39","v":97.4},"  Enter %Density of GMM reqd.  as listed on JMF"]
[null,null,null,null,null,null,null,null," % Air Voids",null,null,{"$f":"IF(L39=\"\",\"\",ROUND(100-(L38/L31*100),Tables!$E$49))","v":3.5},{"$f":"IF(L40=\"\",\"\",ABS(O40-L40))","v":0.5},null,{"$f":"'Sublot 1'!O40","v":4},null,"%Air Voids Target",null,null," (Superpave, SMA) = 4%,  (RBL) = 2%"]
[null,"MOISTURE & VOLATILE SAMPLE",null,null,null,null,null,null," % V.M.A.",null,null,{"$f":"IF(L38=\"\",\"\",IF(L38>0,ROUND(100-L38*(100-L30)/L28,Tables!$E$50),Tables!E50))","v":13.3},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":"ERR"},null,{"$f":"'Sublot 2'!O41","v":14},null,"Enter required field VMA from mix design. "]
[null," Pan",null,null,0,null,null,null,{"$f":"IF(M39=\"ERR\",\"%L.M. Density out of range\",\"\")","v":""},null,null,{"$f":"IF(M41=\"ERR\",\" %VMA out of range\",\"\")","v":" %VMA out of range"}]
[null," Original Mix (W1m)",null,null,4902.5,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":4902.5},null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Dry Mix (W5m)",null,null,4902.5,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":4902.5},null,null,"m = ",0.98919999999999997,"b = ",2.7300000000000001E-2]
[null,null,null,null,null,null,null,null,{"$f":"IF(O45=\"\",\" Avg. Rice\",\" Max. Theo. at JMF AC\")","v":" Max. Theo. at JMF AC"},null,null,{"$f":"IF(L24=\"\",\"\",ROUND(L24,Tables!$E$52))","v":2.464},"Gmm",null,{"$f":"VLOOKUP(O8,GTable,5)","v":85.5}," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null," Specimen No.",null,1,"2","3",null,{"$f":"VLOOKUP(O8,GTable,7)","v":89}," Nini Maximum Requirement"]
[null," S.E. No.",null,"1","2",{"$f":"+IF(F48=\"\",\"\",3)","v":""},null,null," Station"]
[null," Sand Reading",null,null,null,null,null,null," Expressway"]
[null," Clay Reading",null,null,null,null,null,{"$f":"IF(O49=1,\"OHD L-14\",\"\")","v":""}," Lane"]
[null," Sand Equivalent",null,{"$f":"IF(D49=\"\",\"\",ROUNDUP(MROUND(D48/D49*100,0.1),0))","v":""},{"$f":"IF(E49=\"\",\"\",ROUNDUP(MROUND(E48/E49*100,0.1),0))","v":""},{"$f":"IF(F49=\"\",\"\",ROUNDUP(MROUND(F48/F49*100,0.1),0))","v":""},null,null," Shot # 1",null,142.4,144.69999999999999,142.19999999999999]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",ROUNDUP(MROUND(SUM(D50:F50)/COUNT(D50:F50),0.1),0))","v":""},null,null,null," Shot # 2",null,144.30000000000001,144.69999999999999,141.1,null,45," Minimum S.E. Requirement"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O50,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Shot # 3"]
[null,"Lab Molded","# of","Specimen","RATIO","LSMG","% Density",null," Shot # 4"]
[null,"Specimen","Gyrations","Height","(Ht@Ndes","(RATIO x","(LSMG",null," Avg. Unit Weight",null,{"$f":"IF(K51=\"\",\"\",AVERAGE(K50:K53))","v":143.35000000000002},{"$f":"IF(L51=\"\",\"\",AVERAGE(L50:L53))","v":144.69999999999999},{"$f":"IF(M51=\"\",\"\",AVERAGE(M50:M53))","v":141.64999999999998}]
[null," @ Ndes",null,null,"/Ht@Nini)","LSMG @","X 100/",null," Nuclear Core Spec. Grav.",null,{"$f":"IF(K54=\"\",\"\",ROUND((K54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.2999999999999998},{"$f":"IF(L54=\"\",\"\",ROUND((L54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.3210000000000002},{"$f":"IF(M54=\"\",\"\",ROUND((M54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.2730000000000001},null,{"$f":"COUNT(K54:M54)","v":3}," No. of Cores"]
[null,null,null,null,null,"Ndes)","Rice's)",null," Calc. Avg. Bulk Core Sp. Gr.",null,null,{"$f":"IF(K55=\"\",\"\",ROUND(SUM(((K55+L55+M55))/O55),Tables!$E$55))","v":2.298}]
[null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":8},123.1,{"$f":"IF(D57=\"\",\"\",ROUND((D58/D57),Tables!$E$35))","v":0.92200000000000004},{"$f":"IF(D57=\"\",\"\",ROUND((E57*F58),Tables!$E$36))","v":2.1920000000000002},{"$f":"IF(AND(F58<>\"\",OR(D57=\"\",D58=\"\")),\"ERR\",IF(D58=\"\",\"\",ROUND(((F57*100)/$L$24),Tables!$E$37)))","v":89},null," % Roadway Density",null,{"$f":"IF(K55=\"\",\"\",ROUND(K55/$L$45*100,Tables!$E$56))","v":93.3},{"$f":"IF(L55=\"\",\"\",ROUND(L55/$L$45*100,Tables!$E$56))","v":94.2},{"$f":"IF(M55=\"\",\"\",ROUND(M55/$L$45*100,Tables!$E$56))","v":92.2}]
[null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":100},113.5,1,{"$f":"IF(D58=\"\",\"\",L38)","v":2.3769999999999998},{"$f":"IF(D58=\"\",\"\",ROUND(((F58*100)/$L$24),Tables!$E$38))","v":96.5},null," % Avg. Roadway Density",null,null,{"$f":"IF(L44=\"\",\"\",IF(L44>0,ROUND(L56/L45*100,Tables!$E$57),\"\"))","v":93.3}]
[null,null,{"$f":"(IF(G58=\"\",\"\",IF(OR($G$57=\"ERR\",OR($G57>$O46,$G$57<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""},null,null,null,null,null,null,{"$f":"IF(L58=\"\",\"\",IF(OR(L58>97,L58<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]
[]
[null,"Signature / Cert. ID",null,null,"/"]

{"sheet":"Sublot 4","index":3,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[57,8,57,9],[53,8,53,9],[54,8,54,9],[55,8,55,9],[56,8,56,9],[39,8,39,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[40,8,40,9],[47,1,47,2],[42,8,42,12],[48,1,48,2],[49,1,49,2],[50,1,50,2],[31,8,31,9],[32,8,32,9],[33,8,33,9],[37,8,37,9],[38,8,38,9],[31,1,31,2],[32,1,32,2],[33,1,33,2],[45,1,45,5],[46,1,46,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,1,40,5],[41,1,41,2],[42,1,42,2],[43,1,43,2],[30,1,30,2],[27,8,27,9],[29,8,29,9],[30,8,30,9],[9,1,9,6],[10,1,10,6],[10,9,10,10],[11,4,11,6],[11,9,11,11],[12,9,12,11],[13,8,13,12],[23,8,23,9],[24,8,24,9],[26,8,26,12],[28,8,28,9],[6,1,6,4],[6,6,6,8],[6,9,6,10],[6,11,6,13],[7,1,7,4],[7,6,7,8],[7,9,7,10],[7,11,7,13],[0,1,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[5,1,5,4],[5,6,5,8],[5,9,5,10],[5,11,5,13]]}
[{"$f":"'Sublot 1'!A1","v":"v 1.14"},"OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
["SUPERPAVE"]
["McALESTER RESIDENCY"]
["HOT MIX ASPHALT SAMPLE SHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INFORMATION FROM MIX DESIGN:"]
[" Project No. ",{"$f":"IF('Sublot 1'!B6=\"\",\"\",'Sublot 1'!B6)","v":""},null,null,null,"J.P. No.",{"$f":"IF('Sublot 1'!G6=\"\",\"\",'Sublot 1'!G6)","v":""},null,null,"Contract No. ",null,{"$f":"IF('Sublot 1'!L6=\"\",\"\",'Sublot 1'!L6)","v":""}]
[" Contractor ",{"$f":"IF('Sublot 1'!B7=\"\",\"\",'Sublot 1'!B7)","v":""},null,null,null,"Producer",{"$f":"IF('Sublot 1'!G7=\"\",\"\",'Sublot 1'!G7)","v":""},null,null," Plant Location ",null,{"$f":"IF('Sublot 1'!L7=\"\",\"\",'Sublot 1'!L7)","v":""}]
[{"$f":"'Sublot 1'!A8","v":"SM Sample ID"},null,null,null,null,"Mix Type",{"$f":"IF('Sublot 1'!G8=\"\",\"\",'Sublot 1'!G8)","v":""},null,null,"Design No. ",null,{"$f":"IF('Sublot 1'!L8=\"\",\"\",'Sublot 1'!L8)","v":""},null,null,{"$f":"'Sublot 1'!O8","v":"3M+"},"    Million ESALs or PG Grade: Select from drop-down list."]
[]
[null,"EXTRACTIONS AND GRADATIONS",null,null,null,null,null,"IOC",1000,"  TOTAL TONS for this SubLOT"]
[null,"(OHD L-26, AASHTO T-30, T-11)",null,null,null,null,null,{"$f":"IF('Sublot 1'!H11=\"\",\"\",'Sublot 1'!H11)","v":0.18},{"$f":"'Sublot 1'!I11","v":2.6589999999999998},"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",{"$f":"'Sublot 1'!I12","v":2.6120000000000001},"  Gsb from Design",null,null,null,null,"A","    Change for each sheet if A is not used on each.  Rices Precision: Select from drop-down list.  "]
[null," Temperature ",null,"Lot",{"$f":"IF('Sublot 1'!E13=\"\",\"\",'Sublot 1'!E13)","v":1},"SubLot",4,{"$f":"IF('Sublot 1'!H13=\"\",\"\",'Sublot 1'!H13)","v":4700},{"$f":"'Sublot 1'!I13","v":1.01},"  Spec. Grav. AC from Design",null,null,null,null,{"$f":"VLOOKUP(O12,PTable,2,FALSE)","v":1.4E-2},"    Method A - Mechanical or Method B - Manual"]
[null,"SIEVE","JMF","Acc. Wt.","Acc. %"," Total Agg.",null,null,"MAXIMUM SPECIFIC GRAVITY  (AASHTO T209)"]
[null,"SIZE",null,"Retd.","Retd."," % Passing","Dev.",null," Sub-Lot No.",null,null,null,null,null,null,"Limits",null,null,"Tolerance"]
[null,"1 1/2\" (37.5 mm)",{"$f":"'Sublot 3'!C16","v":100},0,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$27))","v":0},{"$f":"IF(D16=\"\",\"\",100-E16)","v":100},{"$f":"IF(D16=\"\",\"\",IF(F16<$P16,ABS(F16-$P16),IF(F16>$Q16,ABS($Q16-F16),Tables!$E$27)))","v":0},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":100},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":100},null,0]
[null,"1\" (25.0 mm)",{"$f":"'Sublot 3'!C17","v":100},0,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$27))","v":0},100,{"$f":"IF(D17=\"\",\"\",IF(F17<$P17,ABS(F17-$P17),IF(F17>$Q17,ABS($Q17-F17),Tables!$E$27)))","v":0},null," Flask No.",null,2,"|",4,null,"1\" (25.0 mm)",100,100,null,0]
[null,"3/4\" (19.0 mm",{"$f":"'Sublot 3'!C18","v":100},0,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$27))","v":0},100,{"$f":"IF(D18=\"\",\"\",IF(F18<$P18,ABS(F18-$P18),IF(F18>$Q18,ABS($Q18-F18),Tables!$E$27)))","v":0},null," Sample Wt.","           (A)  ",1544.5,"|",1578.9,null,"3/4\" (19.0 mm",100,100,null,0]
[null,"1/2\" (12.5 mm)",{"$f":"'Sublot 3'!C19","v":96},50.4,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$27))","v":3},97,{"$f":"IF(D19=\"\",\"\",IF(F19<$P19,ABS(F19-$P19),IF(F19>$Q19,ABS($Q19-F19),Tables!$E$27)))","v":0},null," Calib. Wt.","           (B)  ",6179,"|",6250.7,null,"1/2\" (12.5 mm)",89,100,null,7]
[null,"3/8\" (9.5 mm)",{"$f":"'Sublot 3'!C20","v":86},247.3,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$27))","v":17},83,{"$f":"IF(D20=\"\",\"\",IF(F20<$P20,ABS(F20-$P20),IF(F20>$Q20,ABS($Q20-F20),Tables!$E$27)))","v":0},null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":7723.5},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":7829.6},null,"3/8\" (9.5 mm)",79,93,null,7]
[null,"# 4 ( 4.75 mm)",{"$f":"'Sublot 3'!C21","v":61},533.9,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$27))","v":36},64,{"$f":"IF(D21=\"\",\"\",IF(F21<$P21,ABS(F21-$P21),IF(F21>$Q21,ABS($Q21-F21),Tables!$E$27)))","v":0},null," Sample + Flask + H²O  (D)",null,7095.2,"|",7189.3,null,"# 4 ( 4.75 mm)",54,68,null,7]
[null,"# 8 (2.36 mm)",{"$f":"'Sublot 3'!C22","v":44},803.7,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$27))","v":55},45,{"$f":"IF(D22=\"\",\"\",IF(F22<$P22,ABS(F22-$P22),IF(F22>$Q22,ABS($Q22-F22),Tables!$E$27)))","v":0},null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":628.30000000000018},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":640.30000000000018},null,"# 8 (2.36 mm)",39,49,null,5]
[null,"# 16 ( 1.18 mm)",{"$f":"'Sublot 3'!C23","v":32},993.7,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$27))","v":67},33,{"$f":"IF(D23=\"\",\"\",IF(F23<$P23,ABS(F23-$P23),IF(F23>$Q23,ABS($Q23-F23),Tables!$E$27)))","v":0},null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$40),\"\")","v":2.4580000000000002},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$40),\"\")","v":2.4660000000000002},null,"# 16 ( 1.18 mm)",28,36,null,4]
[null,"# 30 (.600 mm)",{"$f":"'Sublot 3'!C24","v":23},1131.4000000000001,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$27))","v":77},23,{"$f":"IF(D24=\"\",\"\",IF(F24<$P24,ABS(F24-$P24),IF(F24>$Q24,ABS($Q24-F24),Tables!$E$27)))","v":0},null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$41))","v":2.4620000000000002},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",19,27,null,4]
[null,"# 50 (.300 mm)",{"$f":"'Sublot 3'!C25","v":13},1281.3,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$27))","v":87},13,{"$f":"IF(D25=\"\",\"\",IF(F25<$P25,ABS(F25-$P25),IF(F25>$Q25,ABS($Q25-F25),Tables!$E$27)))","v":0},null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$42),\"\")","v":2.6539999999999999},null,null,"# 50 (.300 mm)",9,17,null,4]
[null,"# 100 (.150 mm)",{"$f":"'Sublot 3'!C26","v":7},1335,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$27))","v":91},9,{"$f":"IF(D26=\"\",\"\",IF(F26<$P26,ABS(F26-$P26),IF(F26>$Q26,ABS($Q26-F26),Tables!$E$27)))","v":0},null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",4,10,null,3]
[null,"# 200 (.075 mm)",{"$f":"'Sublot 3'!C27","v":4.4000000000000004},1391.7,null,null,null,null,"   LAB MOLDED DENSITY  (OHD L-8, L-14) @ Ndes"]
[null," Total -200 (W3)",null,null,null,{"$f":"IF(E34=\"\",\"\",ROUND((E38/E34)*100,Tables!$E$28))","v":5.4},{"$f":"IF(D27=\"\",\"\",IF(F28<$P28,ROUND($P28-F28,Tables!$E$28),IF(F28>$Q28,ROUND(F28-$Q28,Tables!$E$28),0)))","v":0},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$44))","v":2.6070000000000002},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":2.4000000000000004},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":6.4},null,2]
[null," % AC (P5m)",{"$f":"'Sublot 3'!C29","v":4.9000000000000004},4.8099999999999996,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":1.01}]
[null," Corrected %AC",".",null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$29))","v":4.8},{"$f":"IF(D29=\"\",\"\",IF(ABS(C29-F30)>S30,ROUND(ABS(C29-F30),Tables!$E$33),0))","v":0},null," % AC",null,null,{"$f":"IF(K33=\"\",\"\",+F30)","v":4.8},null,null," Corrected %AC",{"$f":"IF(C29=\"\",\"\",C29-S30)","v":4.5},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":5.3000000000000007},null,0.4]
[null," Basket (A)",null,null,3362.5,null,null,null," Max. Theo. Spec. Grav.",null,null,{"$f":"IF(D29=\"\",\"\",IF($L$24=\"\",ROUND((100/(($F$30/$I$13)+(100-$F$30)/#REF!)),Tables!$E$45),L24))","v":2.4620000000000002}]
[null," Basket + Mix (B)",null,null,4914.7,null,null,null," Specimen No.",null,1,2]
[null," Mix (B-A)",null,null,{"$f":"IF(E31=\"\",\"\",+E32-E31)","v":1552.1999999999998},null,null,null," A (Wt. Spec. in Air)",null,4701.6000000000004,4704.3]
[null," Extr. Aggr. Wt (C)",null,{"$f":"IF(D31=\"\",\"\",+D31+D32)","v":""},1472.2,null,null,null," C (Wt. Spec. in Water",null,2717.7,2719.8]
[null," Washed Wt (D)",null,null,1396.2,null,null,null," B (Wt. Spec. S.S.D.)",null,4707.3999999999996,4710.2]
[null," Pan Matl (E)",null,null,4.2,null,null,null," B - C",null,{"$f":"IF(K33=\"\",\"\",+K35-K34)","v":1989.6999999999998},{"$f":"IF(L33=\"\",\"\",+L35-L34)","v":1990.3999999999996},{"$f":"IF(M33=\"\",\"\",+M35-M34)","v":""}]
[null," Wt of Loss by Washing (W1)",null,null,{"$f":"IF(E35=\"\",\"\",E34-E35)","v":76},null,null,null," L.M. Spec. Grav. - Gmb",null,{"$f":"IF(K33=0,\"\",ROUND((K33/K36),Tables!$E$46))","v":2.363},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$46))","v":2.363},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$46))","v":""}]
[null," Total Agg. Passing 200 (W2)",null,null,{"$f":"IF(E36=\"\",\"\",+E37+E36)","v":80.2},null,null,null," Avg. L.M. Spec. Grav.",null,null,{"$f":"IF(K37=\"\",\"\",ROUND(AVERAGE(K37,L37,M37),Tables!$E$47))","v":2.363}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$30))","v":0},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$48))","v":96},{"$f":"IF(L39=\"\",\"\",IF(OR(ROUND(L39,1)<O39,ROUND(L39,1)>Q39),\"ERR\",\"\"))","v":""},null,{"$f":"'Sublot 1'!O39","v":94.5},"-",{"$f":"'Sublot 1'!Q39","v":97.4},"  Enter %Density of GMM reqd.  as listed on JMF"]
[null,null,null,null,null,null,null,null," % Air Voids",null,null,{"$f":"IF(L39=\"\",\"\",ROUND(100-(L38/L31*100),Tables!$E$49))","v":4},{"$f":"IF(L40=\"\",\"\",ABS(O40-L40))","v":0},null,{"$f":"'Sublot 1'!O40","v":4},null,"%Air Voids Target",null,null," (Superpave, SMA) = 4%,  (RBL) = 2%"]
[null,"MOISTURE & VOLATILE SAMPLE",null,null,null,null,null,null," % V.M.A.",null,null,{"$f":"IF(L38=\"\",\"\",IF(L38>0,ROUND(100-L38*(100-L30)/L28,Tables!$E$50),Tables!E50))","v":13.7},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":"ERR"},null,{"$f":"'Sublot 3'!O41","v":14},null,"Enter required field VMA from mix design. "]
[null," Pan",null,null,0,null,null,null,{"$f":"IF(M39=\"ERR\",\"%L.M. Density out of range\",\"\")","v":""},null,null,{"$f":"IF(M41=\"ERR\",\" %VMA out of range\",\"\")","v":" %VMA out of range"}]
[null," Original Mix (W1m)",null,null,4914.7,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":4914.7},null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Dry Mix (W5m)",null,null,4914.7,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":4914.7},null,null,"m = ",0.98919999999999997,"b = ",2.7300000000000001E-2]
[null,null,null,null,null,null,null,null,{"$f":"IF(O45=\"\",\" Avg. Rice\",\" Max. Theo. at JMF AC\")","v":" Max. Theo. at JMF AC"},null,null,{"$f":"IF(L24=\"\",\"\",ROUND(L24,Tables!$E$52))","v":2.4620000000000002},"Gmm",null,{"$f":"VLOOKUP(O8,GTable,5)","v":85.5}," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null," Specimen No.",null,1,"2","3",null,{"$f":"VLOOKUP(O8,GTable,7)","v":89}," Nini Maximum Requirement"]
[null," S.E. No.",null,"1","2","3",null,null," Station"]
[null," Sand Reading",null,null,null,null,null,null," Expressway"]
[null," Clay Reading",null,null,null,null,null,{"$f":"IF(O49=1,\"OHD L-14\",\"\")","v":""}," Lane"]
[null," Sand Equivalent",null,{"$f":"IF(D49=\"\",\"\",ROUNDUP(D48/D49*100,1))","v":""},{"$f":"IF(E49=\"\",\"\",ROUNDUP(E48/E49*100,Tables!$E$31))","v":""},{"$f":"IF(F49=\"\",\"\",ROUNDUP(F48/F49*100,Tables!$E$31))","v":""},null,null," Shot # 1",null,144.5,141.1,139]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",AVERAGE(D50:F50))","v":""},null,null,null," Shot # 2",null,143.4,142,141.9,null,45," Minimum S.E. Requirement"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O50,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Shot # 3"]
[null,"Lab Molded","# of","Specimen","RATIO","LSMG","% Density",null," Shot # 4"]
[null,"Specimen","Gyrations","Height","(Ht@Ndes","(RATIO x","(LSMG",null," Avg. Unit Weight",null,{"$f":"IF(K51=\"\",\"\",AVERAGE(K50:K53))","v":143.94999999999999},{"$f":"IF(L51=\"\",\"\",AVERAGE(L50:L53))","v":141.55000000000001},{"$f":"IF(M51=\"\",\"\",AVERAGE(M50:M53))","v":140.44999999999999}]
[null," @ Ndes",null,null,"/Ht@Nini)","LSMG @","X 100/",null," Nuclear Core Spec. Grav.",null,{"$f":"IF(K54=\"\",\"\",ROUND((K54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.3090000000000002},{"$f":"IF(L54=\"\",\"\",ROUND((L54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.2709999999999999},{"$f":"IF(M54=\"\",\"\",ROUND((M54/62.4)*$J$44+$L$44,Tables!$E$53))","v":2.254},null,{"$f":"COUNT(K54:M54)","v":3}," No. of Cores"]
[null,null,null,null,null,"Ndes)","Rice's)",null," Calc. Avg. Bulk Core Sp. Gr.",null,null,{"$f":"IF(K55=\"\",\"\",ROUND(SUM(((K55+L55+M55))/O55),Tables!$E$55))","v":2.278}]
[null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":8},123.6,{"$f":"IF(D57=\"\",\"\",ROUND((D58/D57),Tables!$E$35))","v":0.92310000000000003},{"$f":"IF(D57=\"\",\"\",ROUND((E57*F58),Tables!$E$36))","v":2.181},{"$f":"IF(AND(F58<>\"\",OR(D57=\"\",D58=\"\")),\"ERR\",IF(D58=\"\",\"\",ROUND(((F57*100)/$L$24),Tables!$E$37)))","v":88.6},null," % Roadway Density",null,{"$f":"IF(K55=\"\",\"\",ROUND(K55/$L$45*100,Tables!$E$56))","v":93.8},{"$f":"IF(L55=\"\",\"\",ROUND(L55/$L$45*100,Tables!$E$56))","v":92.2},{"$f":"IF(M55=\"\",\"\",ROUND(M55/$L$45*100,Tables!$E$56))","v":91.6}]
[null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":100},114.1,1,{"$f":"IF(D58=\"\",\"\",L38)","v":2.363},{"$f":"IF(D58=\"\",\"\",ROUND(((F58*100)/$L$24),Tables!$E$38))","v":96},null," % Avg. Roadway Density",null,null,{"$f":"IF(L44=\"\",\"\",IF(L44>0,ROUND(L56/L45*100,Tables!$E$57),\"\"))","v":92.5}]
[null,null,{"$f":"(IF(G58=\"\",\"\",IF(OR($G$57=\"ERR\",OR($G57>$O46,$G$57<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""},null,null,null,null,null,null,{"$f":"IF(L58=\"\",\"\",IF(OR(L58>97,L58<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]
[]
[null,"Signature / Cert. ID",null,null,"/"]

{"sheet":"Sublot 5","index":4,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[56,8,56,9],[57,8,57,9],[42,8,42,12],[37,8,37,9],[38,8,38,9],[55,8,55,9],[53,8,53,9],[54,8,54,9],[40,8,40,9],[39,8,39,9],[35,8,35,9],[36,8,36,9],[0,1,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[5,1,5,4],[5,6,5,8],[5,9,5,10],[5,11,5,13],[6,1,6,4],[6,6,6,8],[6,9,6,10],[6,11,6,13],[7,1,7,4],[32,8,32,9],[7,6,7,8],[7,9,7,10],[7,11,7,13],[9,1,9,6],[10,1,10,6],[10,9,10,10],[11,4,11,6],[11,9,11,11],[12,9,12,11],[13,8,13,12],[23,8,23,9],[24,8,24,9],[26,8,26,12],[28,8,28,9],[30,1,30,2],[27,8,27,9],[29,8,29,9],[30,8,30,9],[31,1,31,2],[31,8,31,9],[32,1,32,2],[33,1,33,2],[34,1,34,2],[34,8,34,9],[33,8,33,9],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,1,40,5],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[45,1,45,5],[46,1,46,2]]}
[{"$f":"'Sublot 1'!A1","v":"v 1.14"},"OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
["SUPERPAVE"]
["McALESTER RESIDENCY"]
["HOT MIX ASPHALT SAMPLE SHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INFORMATION FROM MIX DESIGN:"]
[" Project No. ",{"$f":"IF('Sublot 1'!B6=\"\",\"\",'Sublot 1'!B6)","v":""},null,null,null,"J.P. No.",{"$f":"IF('Sublot 1'!G6=\"\",\"\",'Sublot 1'!G6)","v":""},null,null,"Contract No. ",null,{"$f":"IF('Sublot 1'!L6=\"\",\"\",'Sublot 1'!L6)","v":""}]
[" Contractor ",{"$f":"IF('Sublot 1'!B7=\"\",\"\",'Sublot 1'!B7)","v":""},null,null,null,"Producer",{"$f":"IF('Sublot 1'!G7=\"\",\"\",'Sublot 1'!G7)","v":""},null,null," Plant Location ",null,{"$f":"IF('Sublot 1'!L7=\"\",\"\",'Sublot 1'!L7)","v":""}]
[{"$f":"'Sublot 1'!A8","v":"SM Sample ID"},null,null,null,null,"Mix Type",{"$f":"IF('Sublot 1'!G8=\"\",\"\",'Sublot 1'!G8)","v":""},null,null,"Design No. ",null,{"$f":"IF('Sublot 1'!L8=\"\",\"\",'Sublot 1'!L8)","v":""},null,null,{"$f":"'Sublot 1'!O8","v":"3M+"},"    Million ESALs or PG Grade: Select from drop-down list."]
[]
[null,"EXTRACTIONS AND GRADATIONS",null,null,null,null,null,"IOC",null,"  TOTAL TONS for this SubLOT"]
[null,"(OHD L-26, AASHTO T-30, T-11)",null,null,null,null,null,{"$f":"IF('Sublot 1'!H11=\"\",\"\",'Sublot 1'!H11)","v":0.18},{"$f":"'Sublot 1'!I11","v":2.6589999999999998},"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",{"$f":"'Sublot 1'!I12","v":2.6120000000000001},"  Gsb from Design",null,null,null,null,"A","    Change for each sheet if A is not used on each.  Rices Precision: Select from drop-down list.  "]
[null," Temperature ",null,"Lot",{"$f":"IF('Sublot 1'!E13=\"\",\"\",'Sublot 1'!E13)","v":1},"SubLot",5,{"$f":"IF('Sublot 1'!H13=\"\",\"\",'Sublot 1'!H13)","v":4700},{"$f":"'Sublot 1'!I13","v":1.01},"  Spec. Grav. AC from Design",null,null,null,null,{"$f":"VLOOKUP(O12,PTable,2,FALSE)","v":1.4E-2},"    Method A - Mechanical or Method B - Manual"]
[null,"SIEVE","JMF","Acc. Wt.","Acc. %"," Total Agg.",null,null,"MAXIMUM SPECIFIC GRAVITY  (AASHTO T209)"]
[null,"SIZE",null,"Retd.","Retd."," % Passing","Dev.",null," Sub-Lot No.",null,null,null,null,null,null,"Limits",null,null,"Tolerance"]
[null,"1 1/2\" (37.5 mm)",{"$f":"'Sublot 4'!C16","v":100},null,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$27))","v":""},{"$f":"IF(D16=\"\",\"\",100-E16)","v":""},{"$f":"IF(D16=\"\",\"\",IF(F16<$P16,ABS(F16-$P16),IF(F16>$Q16,ABS($Q16-F16),Tables!$E$27)))","v":""},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":100},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":100},null,0]
[null,"1\" (25.0 mm)",{"$f":"'Sublot 4'!C17","v":100},null,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D17=\"\",\"\",IF(F17<$P17,ABS(F17-$P17),IF(F17>$Q17,ABS($Q17-F17),Tables!$E$27)))","v":""},null," Flask No.",null,null,"|",null,null,"1\" (25.0 mm)",100,100,null,0]
[null,"3/4\" (19.0 mm",{"$f":"'Sublot 4'!C18","v":100},null,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D18=\"\",\"\",IF(F18<$P18,ABS(F18-$P18),IF(F18>$Q18,ABS($Q18-F18),Tables!$E$27)))","v":""},null," Sample Wt.","           (A)  ",null,"|",null,null,"3/4\" (19.0 mm",100,100,null,0]
[null,"1/2\" (12.5 mm)",{"$f":"'Sublot 4'!C19","v":96},null,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D19=\"\",\"\",IF(F19<$P19,ABS(F19-$P19),IF(F19>$Q19,ABS($Q19-F19),Tables!$E$27)))","v":""},null," Calib. Wt.","           (B)  ",null,"|",null,null,"1/2\" (12.5 mm)",89,100,null,7]
[null,"3/8\" (9.5 mm)",{"$f":"'Sublot 4'!C20","v":86},null,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D20=\"\",\"\",IF(F20<$P20,ABS(F20-$P20),IF(F20>$Q20,ABS($Q20-F20),Tables!$E$27)))","v":""},null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":""},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":""},null,"3/8\" (9.5 mm)",79,93,null,7]
[null,"# 4 ( 4.75 mm)",{"$f":"'Sublot 4'!C21","v":61},null,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D21=\"\",\"\",IF(F21<$P21,ABS(F21-$P21),IF(F21>$Q21,ABS($Q21-F21),Tables!$E$27)))","v":""},null," Sample + Flask + H²O  (D)",null,null,"|",null,null,"# 4 ( 4.75 mm)",54,68,null,7]
[null,"# 8 (2.36 mm)",{"$f":"'Sublot 4'!C22","v":44},null,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D22=\"\",\"\",IF(F22<$P22,ABS(F22-$P22),IF(F22>$Q22,ABS($Q22-F22),Tables!$E$27)))","v":""},null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":""},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":""},null,"# 8 (2.36 mm)",39,49,null,5]
[null,"# 16 ( 1.18 mm)",{"$f":"'Sublot 4'!C23","v":32},null,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D23=\"\",\"\",IF(F23<$P23,ABS(F23-$P23),IF(F23>$Q23,ABS($Q23-F23),Tables!$E$27)))","v":""},null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$40),\"\")","v":""},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$40),\"\")","v":""},null,"# 16 ( 1.18 mm)",28,36,null,4]
[null,"# 30 (.600 mm)",{"$f":"'Sublot 4'!C24","v":23},null,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D24=\"\",\"\",IF(F24<$P24,ABS(F24-$P24),IF(F24>$Q24,ABS($Q24-F24),Tables!$E$27)))","v":""},null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$41))","v":""},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",19,27,null,4]
[null,"# 50 (.300 mm)",{"$f":"'Sublot 4'!C25","v":13},null,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D25=\"\",\"\",IF(F25<$P25,ABS(F25-$P25),IF(F25>$Q25,ABS($Q25-F25),Tables!$E$27)))","v":""},null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$42),\"\")","v":""},null,null,"# 50 (.300 mm)",9,17,null,4]
[null,"# 100 (.150 mm)",{"$f":"'Sublot 4'!C26","v":7},null,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D26=\"\",\"\",IF(F26<$P26,ABS(F26-$P26),IF(F26>$Q26,ABS($Q26-F26),Tables!$E$27)))","v":""},null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",4,10,null,3]
[null,"# 200 (.075 mm)",{"$f":"'Sublot 4'!C27","v":4.4000000000000004},null,null,null,null,null,"   LAB MOLDED DENSITY  (OHD L-8, L-14) @ Ndes"]
[null," Total -200 (W3)",null,null,null,{"$f":"IF(E34=\"\",\"\",ROUND((E38/E34)*100,Tables!$E$28))","v":""},{"$f":"IF(D27=\"\",\"\",IF(F28<$P28,ROUND($P28-F28,Tables!$E$28),IF(F28>$Q28,ROUND(F28-$Q28,Tables!$E$28),0)))","v":""},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$44))","v":""},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":2.4000000000000004},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":6.4},null,2]
[null," % AC (P5m)",{"$f":"'Sublot 4'!C29","v":4.9000000000000004},null,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":""}]
[null," Corrected %AC",".",null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$29))","v":""},{"$f":"IF(D29=\"\",\"\",IF(ABS(C29-F30)>S30,ROUND(ABS(C29-F30),Tables!$E$33),0))","v":""},null," % AC",null,null,{"$f":"IF(K33=\"\",\"\",+F30)","v":""},null,null," Corrected %AC",{"$f":"IF(C29=\"\",\"\",C29-S30)","v":4.5},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":5.3000000000000007},null,0.4]
[null," Basket (A)",null,null,null,null,null,null," Max. Theo. Spec. Grav.",null,null,{"$f":"IF(D29=\"\",\"\",IF($L$24=\"\",ROUND((100/(($F$30/$I$13)+(100-$F$30)/#REF!)),Tables!$E$45),L24))","v":""}]
[null," Basket + Mix (B)",null,null,null,null,null,null," Specimen No.",null,1,2]
[null," Mix (B-A)",null,null,{"$f":"IF(E31=\"\",\"\",+E32-E31)","v":""},null,null,null," A (Wt. Spec. in Air)"]
[null," Extr. Aggr. Wt (C)",null,{"$f":"IF(D31=\"\",\"\",+D31+D32)","v":""},null,null,null,null," C (Wt. Spec. in Water"]
[null," Washed Wt (D)",null,null,null,null,null,null," B (Wt. Spec. S.S.D.)"]
[null," Pan Matl (E)",null,null,null,null,null,null," B - C",null,{"$f":"IF(K33=\"\",\"\",+K35-K34)","v":""},{"$f":"IF(L33=\"\",\"\",+L35-L34)","v":""},{"$f":"IF(M33=\"\",\"\",+M35-M34)","v":""}]
[null," Wt of Loss by Washing (W1)",null,null,{"$f":"IF(E35=\"\",\"\",E34-E35)","v":""},null,null,null," L.M. Spec. Grav. - Gmb",null,{"$f":"IF(K33=0,\"\",ROUND((K33/K36),Tables!$E$46))","v":""},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$46))","v":""},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$46))","v":""}]
[null," Total Agg. Passing 200 (W2)",null,null,{"$f":"IF(E36=\"\",\"\",+E37+E36)","v":""},null,null,null," Avg. L.M. Spec. Grav.",null,null,{"$f":"IF(K37=\"\",\"\",ROUND(AVERAGE(K37,L37,M37),Tables!$E$47))","v":""}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$30))","v":""},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$48))","v":""},{"$f":"IF(L39=\"\",\"\",IF(OR(ROUND(L39,1)<O39,ROUND(L39,1)>Q39),\"ERR\",\"\"))","v":""},null,{"$f":"'Sublot 1'!O39","v":94.5},"-",{"$f":"'Sublot 1'!Q39","v":97.4},"  Enter %Density of GMM reqd.  as listed on JMF"]
[null,null,null,null,null,null,null,null," % Air Voids",null,null,{"$f":"IF(L39=\"\",\"\",ROUND(100-(L38/L31*100),Tables!$E$49))","v":""},{"$f":"IF(L40=\"\",\"\",ABS(O40-L40))","v":""},null,{"$f":"'Sublot 1'!O40","v":4},null,"%Air Voids Target",null,null," (Superpave, SMA) = 4%,  (RBL) = 2%"]
[null,"MOISTURE & VOLATILE SAMPLE",null,null,null,null,null,null," % V.M.A.",null,null,{"$f":"IF(L38=\"\",\"\",IF(L38>0,ROUND(100-L38*(100-L30)/L28,Tables!$E$50),Tables!E50))","v":""},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":""},null,{"$f":"'Sublot 4'!O41","v":14},null,"Enter required field VMA from mix design. "]
[null," Pan",null,null,null,null,null,null,{"$f":"IF(M39=\"ERR\",\"%L.M. Density out of range\",\"\")","v":""},null,null,{"$f":"IF(M41=\"ERR\",\" %VMA out of range\",\"\")","v":""}]
[null," Original Mix (W1m)",null,null,null,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":""},null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Dry Mix (W5m)",null,null,null,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":""},null,null,"m = ",null,"b = "]
[null,null,null,null,null,null,null,null,{"$f":"IF(O45=\"\",\" Avg. Rice\",\" Max. Theo. at JMF AC\")","v":" Max. Theo. at JMF AC"},null,null,{"$f":"IF(L24=\"\",\"\",ROUND(L24,Tables!$E$52))","v":""},"Gmm",null,{"$f":"VLOOKUP(O8,GTable,5)","v":85.5}," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null," Specimen No.",null,1,"2","3",null,{"$f":"VLOOKUP(O8,GTable,7)","v":89}," Nini Maximum Requirement"]
[null," S.E. No.",null,"1","2",{"$f":"+IF(F48=\"\",\"\",3)","v":""},null,null," Station"]
[null," Sand Reading",null,null,null,null,null,null," Expressway"]
[null," Clay Reading",null,null,null,null,null,{"$f":"IF(O49=1,\"OHD L-14\",\"\")","v":""}," Lane"]
[null," Sand Equivalent",null,{"$f":"IF(D49=\"\",\"\",ROUNDUP(MROUND(D48/D49*100,0.1),0))","v":""},{"$f":"IF(E49=\"\",\"\",ROUNDUP(MROUND(E48/E49*100,0.1),0))","v":""},{"$f":"IF(F49=\"\",\"\",ROUNDUP(MROUND(F48/F49*100,0.1),0))","v":""},null,null," Shot # 1"]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",ROUNDUP(MROUND(SUM(D50:F50)/COUNT(D50:F50),0.1),0))","v":""},null,null,null," Shot # 2",null,null,null,null,null,45," Minimum S.E. Requirement"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O50,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Shot # 3"]
[null,"Lab Molded","# of","Specimen","RATIO","LSMG","% Density",null," Shot # 4"]
[null,"Specimen","Gyrations","Height","(Ht@Ndes","(RATIO x","(LSMG",null," Avg. Unit Weight",null,{"$f":"IF(K51=\"\",\"\",AVERAGE(K50:K53))","v":""},{"$f":"IF(L51=\"\",\"\",AVERAGE(L50:L53))","v":""},{"$f":"IF(M51=\"\",\"\",AVERAGE(M50:M53))","v":""}]
[null," @ Ndes",null,null,"/Ht@Nini)","LSMG @","X 100/",null," Nuclear Core Spec. Grav.",null,{"$f":"IF(K54=\"\",\"\",ROUND((K54/62.4)*$J$44+$L$44,Tables!$E$53))","v":""},{"$f":"IF(L54=\"\",\"\",ROUND((L54/62.4)*$J$44+$L$44,Tables!$E$53))","v":""},{"$f":"IF(M54=\"\",\"\",ROUND((M54/62.4)*$J$44+$L$44,Tables!$E$53))","v":""},null,{"$f":"COUNT(K54:M54)","v":0}," No. of Cores"]
[null,null,null,null,null,"Ndes)","Rice's)",null," Calc. Avg. Bulk Core Sp. Gr.",null,null,{"$f":"IF(K55=\"\",\"\",ROUND(SUM(((K55+L55+M55))/O55),Tables!$E$55))","v":""}]
[null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":8},null,{"$f":"IF(D57=\"\",\"\",ROUND((D58/D57),Tables!$E$35))","v":""},{"$f":"IF(D57=\"\",\"\",ROUND((E57*F58),Tables!$E$36))","v":""},{"$f":"IF(AND(F58<>\"\",OR(D57=\"\",D58=\"\")),\"ERR\",IF(D58=\"\",\"\",ROUND(((F57*100)/$L$24),Tables!$E$37)))","v":""},null," % Roadway Density",null,{"$f":"IF(K55=\"\",\"\",ROUND(K55/$L$45*100,Tables!$E$56))","v":""},{"$f":"IF(L55=\"\",\"\",ROUND(L55/$L$45*100,Tables!$E$56))","v":""},{"$f":"IF(M55=\"\",\"\",ROUND(M55/$L$45*100,Tables!$E$56))","v":""}]
[null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":100},null,1,{"$f":"IF(D58=\"\",\"\",L38)","v":""},{"$f":"IF(D58=\"\",\"\",ROUND(((F58*100)/$L$24),Tables!$E$38))","v":""},null," % Avg. Roadway Density",null,null,{"$f":"IF(L44=\"\",\"\",IF(L44>0,ROUND(L56/L45*100,Tables!$E$57),\"\"))","v":""}]
[null,null,{"$f":"(IF(G58=\"\",\"\",IF(OR($G$57=\"ERR\",OR($G57>$O46,$G$57<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""},null,null,null,null,null,null,{"$f":"IF(L58=\"\",\"\",IF(OR(L58>97,L58<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]
[]
[null,"Signature / Cert. ID",null,null,"/"]

{"sheet":"Sublot 6","index":5,"n_rows":67,"n_cols":20,"rows_kept":67,"cut":false,"hidden":false,"merged":[[49,1,49,2],[50,1,50,2],[43,1,43,2],[45,1,45,5],[46,1,46,2],[47,1,47,2],[48,1,48,2],[39,8,39,9],[40,1,40,5],[40,8,40,9],[41,1,41,2],[42,1,42,2],[42,8,42,12],[36,1,36,2],[36,8,36,9],[37,1,37,2],[37,8,37,9],[38,1,38,2],[38,8,38,9],[33,1,33,2],[33,8,33,9],[34,1,34,2],[34,8,34,9],[35,1,35,2],[35,8,35,9],[32,1,32,2],[32,8,32,9],[13,8,13,12],[23,8,23,9],[24,8,24,9],[26,8,26,12],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,1,30,2],[30,8,30,9],[31,1,31,2],[31,8,31,9],[12,9,12,11],[6,1,6,4],[6,6,6,8],[6,9,6,10],[6,11,6,13],[7,1,7,4],[7,6,7,8],[7,9,7,10],[7,11,7,13],[9,1,9,6],[10,1,10,6],[10,9,10,10],[11,4,11,6],[11,9,11,11],[0,1,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[5,1,5,4],[5,6,5,8],[5,9,5,10],[5,11,5,13],[53,8,53,9],[54,8,54,9],[55,8,55,9],[56,8,56,9],[57,8,57,9]]}
[{"$f":"'Sublot 1'!A1","v":"v 1.14"},"OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
["SUPERPAVE"]
["McALESTER RESIDENCY"]
["HOT MIX ASPHALT SAMPLE SHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INFORMATION FROM MIX DESIGN:"]
[" Project No. ",{"$f":"IF('Sublot 1'!B6=\"\",\"\",'Sublot 1'!B6)","v":""},null,null,null,"J.P. No.",{"$f":"IF('Sublot 1'!G6=\"\",\"\",'Sublot 1'!G6)","v":""},null,null,"Contract No. ",null,{"$f":"IF('Sublot 1'!L6=\"\",\"\",'Sublot 1'!L6)","v":""}]
[" Contractor ",{"$f":"IF('Sublot 1'!B7=\"\",\"\",'Sublot 1'!B7)","v":""},null,null,null,"Producer",{"$f":"IF('Sublot 1'!G7=\"\",\"\",'Sublot 1'!G7)","v":""},null,null," Plant Location ",null,{"$f":"IF('Sublot 1'!L7=\"\",\"\",'Sublot 1'!L7)","v":""}]
[{"$f":"'Sublot 1'!A8","v":"SM Sample ID"},null,null,null,null,"Mix Type",{"$f":"IF('Sublot 1'!G8=\"\",\"\",'Sublot 1'!G8)","v":""},null,null,"Design No. ",null,{"$f":"IF('Sublot 1'!L8=\"\",\"\",'Sublot 1'!L8)","v":""},null,null,{"$f":"'Sublot 1'!O8","v":"3M+"},"    Million ESALs or PG Grade: Select from drop-down list."]
[]
[null,"EXTRACTIONS AND GRADATIONS",null,null,null,null,null,"IOC",null,"  TOTAL TONS for this SubLOT"]
[null,"(OHD L-26, AASHTO T-30, T-11)",null,null,null,null,null,{"$f":"IF('Sublot 1'!H11=\"\",\"\",'Sublot 1'!H11)","v":0.18},{"$f":"'Sublot 1'!I11","v":2.6589999999999998},"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",{"$f":"'Sublot 1'!I12","v":2.6120000000000001},"  Gsb from Design",null,null,null,null,"A","    Change for each sheet if A is not used on each.  Rices Precision: Select from drop-down list.  "]
[null," Temperature ",null,"Lot",{"$f":"IF('Sublot 1'!E13=\"\",\"\",'Sublot 1'!E13)","v":1},"SubLot",6,{"$f":"IF('Sublot 1'!H13=\"\",\"\",'Sublot 1'!H13)","v":4700},{"$f":"'Sublot 1'!I13","v":1.01},"  Spec. Grav. AC from Design",null,null,null,null,{"$f":"VLOOKUP(O12,PTable,2,FALSE)","v":1.4E-2},"    Method A - Mechanical or Method B - Manual"]
[null,"SIEVE","JMF","Acc. Wt.","Acc. %"," Total Agg.",null,null,"MAXIMUM SPECIFIC GRAVITY  (AASHTO T209)"]
[null,"SIZE",null,"Retd.","Retd."," % Passing","Dev.",null," Sub-Lot No.",null,null,null,null,null,null,"Limits",null,null,"Tolerance"]
[null,"1 1/2\" (37.5 mm)",{"$f":"'Sublot 4'!C16","v":100},null,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$27))","v":""},{"$f":"IF(D16=\"\",\"\",100-E16)","v":""},{"$f":"IF(D16=\"\",\"\",IF(F16<$P16,ABS(F16-$P16),IF(F16>$Q16,ABS($Q16-F16),Tables!$E$27)))","v":""},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":100},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":100},null,0]
[null,"1\" (25.0 mm)",{"$f":"'Sublot 4'!C17","v":100},null,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D17=\"\",\"\",IF(F17<$P17,ABS(F17-$P17),IF(F17>$Q17,ABS($Q17-F17),Tables!$E$27)))","v":""},null," Flask No.",null,null,"|",null,null,"1\" (25.0 mm)",100,100,null,0]
[null,"3/4\" (19.0 mm",{"$f":"'Sublot 4'!C18","v":100},null,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D18=\"\",\"\",IF(F18<$P18,ABS(F18-$P18),IF(F18>$Q18,ABS($Q18-F18),Tables!$E$27)))","v":""},null," Sample Wt.","           (A)  ",null,"|",null,null,"3/4\" (19.0 mm",100,100,null,0]
[null,"1/2\" (12.5 mm)",{"$f":"'Sublot 4'!C19","v":96},null,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D19=\"\",\"\",IF(F19<$P19,ABS(F19-$P19),IF(F19>$Q19,ABS($Q19-F19),Tables!$E$27)))","v":""},null," Calib. Wt.","           (B)  ",null,"|",null,null,"1/2\" (12.5 mm)",89,100,null,7]
[null,"3/8\" (9.5 mm)",{"$f":"'Sublot 4'!C20","v":86},null,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D20=\"\",\"\",IF(F20<$P20,ABS(F20-$P20),IF(F20>$Q20,ABS($Q20-F20),Tables!$E$27)))","v":""},null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":""},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":""},null,"3/8\" (9.5 mm)",79,93,null,7]
[null,"# 4 ( 4.75 mm)",{"$f":"'Sublot 4'!C21","v":61},null,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D21=\"\",\"\",IF(F21<$P21,ABS(F21-$P21),IF(F21>$Q21,ABS($Q21-F21),Tables!$E$27)))","v":""},null," Sample + Flask + H²O  (D)",null,null,"|",null,null,"# 4 ( 4.75 mm)",54,68,null,7]
[null,"# 8 (2.36 mm)",{"$f":"'Sublot 4'!C22","v":44},null,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D22=\"\",\"\",IF(F22<$P22,ABS(F22-$P22),IF(F22>$Q22,ABS($Q22-F22),Tables!$E$27)))","v":""},null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":""},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":""},null,"# 8 (2.36 mm)",39,49,null,5]
[null,"# 16 ( 1.18 mm)",{"$f":"'Sublot 4'!C23","v":32},null,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D23=\"\",\"\",IF(F23<$P23,ABS(F23-$P23),IF(F23>$Q23,ABS($Q23-F23),Tables!$E$27)))","v":""},null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$40),\"\")","v":""},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$40),\"\")","v":""},null,"# 16 ( 1.18 mm)",28,36,null,4]
[null,"# 30 (.600 mm)",{"$f":"'Sublot 4'!C24","v":23},null,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D24=\"\",\"\",IF(F24<$P24,ABS(F24-$P24),IF(F24>$Q24,ABS($Q24-F24),Tables!$E$27)))","v":""},null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$41))","v":""},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",19,27,null,4]
[null,"# 50 (.300 mm)",{"$f":"'Sublot 4'!C25","v":13},null,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D25=\"\",\"\",IF(F25<$P25,ABS(F25-$P25),IF(F25>$Q25,ABS($Q25-F25),Tables!$E$27)))","v":""},null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$42),\"\")","v":""},null,null,"# 50 (.300 mm)",9,17,null,4]
[null,"# 100 (.150 mm)",{"$f":"'Sublot 4'!C26","v":7},null,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$27))","v":""},"",{"$f":"IF(D26=\"\",\"\",IF(F26<$P26,ABS(F26-$P26),IF(F26>$Q26,ABS($Q26-F26),Tables!$E$27)))","v":""},null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",4,10,null,3]
[null,"# 200 (.075 mm)",{"$f":"'Sublot 4'!C27","v":4.4000000000000004},null,null,null,null,null,"   LAB MOLDED DENSITY  (OHD L-8, L-14) @ Ndes"]
[null," Total -200 (W3)",null,null,null,{"$f":"IF(E34=\"\",\"\",ROUND((E38/E34)*100,Tables!$E$28))","v":""},{"$f":"IF(D27=\"\",\"\",IF(F28<$P28,ROUND($P28-F28,Tables!$E$28),IF(F28>$Q28,ROUND(F28-$Q28,Tables!$E$28),0)))","v":""},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$44))","v":""},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":2.4000000000000004},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":6.4},null,2]
[null," % AC (P5m)",{"$f":"'Sublot 4'!C29","v":4.9000000000000004},null,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":""}]
[null," Corrected %AC",".",null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$29))","v":""},{"$f":"IF(D29=\"\",\"\",IF(ABS(C29-F30)>S30,ROUND(ABS(C29-F30),Tables!$E$33),0))","v":""},null," % AC",null,null,{"$f":"IF(K33=\"\",\"\",+F30)","v":""},null,null," Corrected %AC",{"$f":"IF(C29=\"\",\"\",C29-S30)","v":4.5},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":5.3000000000000007},null,0.4]
[null," Basket (A)",null,null,null,null,null,null," Max. Theo. Spec. Grav.",null,null,{"$f":"IF(D29=\"\",\"\",IF($L$24=\"\",ROUND((100/(($F$30/$I$13)+(100-$F$30)/#REF!)),Tables!$E$45),L24))","v":""}]
[null," Basket + Mix (B)",null,null,null,null,null,null," Specimen No.",null,1,2]
[null," Mix (B-A)",null,null,{"$f":"IF(E31=\"\",\"\",+E32-E31)","v":""},null,null,null," A (Wt. Spec. in Air)"]
[null," Extr. Aggr. Wt (C)",null,{"$f":"IF(D31=\"\",\"\",+D31+D32)","v":""},null,null,null,null," C (Wt. Spec. in Water"]
[null," Washed Wt (D)",null,null,null,null,null,null," B (Wt. Spec. S.S.D.)"]
[null," Pan Matl (E)",null,null,null,null,null,null," B - C",null,{"$f":"IF(K33=\"\",\"\",+K35-K34)","v":""},{"$f":"IF(L33=\"\",\"\",+L35-L34)","v":""},{"$f":"IF(M33=\"\",\"\",+M35-M34)","v":""}]
[null," Wt of Loss by Washing (W1)",null,null,{"$f":"IF(E35=\"\",\"\",E34-E35)","v":""},null,null,null," L.M. Spec. Grav. - Gmb",null,{"$f":"IF(K33=0,\"\",ROUND((K33/K36),Tables!$E$46))","v":""},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$46))","v":""},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$46))","v":""}]
[null," Total Agg. Passing 200 (W2)",null,null,{"$f":"IF(E36=\"\",\"\",+E37+E36)","v":""},null,null,null," Avg. L.M. Spec. Grav.",null,null,{"$f":"IF(K37=\"\",\"\",ROUND(AVERAGE(K37,L37,M37),Tables!$E$47))","v":""}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$30))","v":""},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$48))","v":""},{"$f":"IF(L39=\"\",\"\",IF(OR(ROUND(L39,1)<O39,ROUND(L39,1)>Q39),\"ERR\",\"\"))","v":""},null,{"$f":"'Sublot 1'!O39","v":94.5},"-",{"$f":"'Sublot 1'!Q39","v":97.4},"  Enter %Density of GMM reqd.  as listed on JMF"]
[null,null,null,null,null,null,null,null," % Air Voids",null,null,{"$f":"IF(L39=\"\",\"\",ROUND(100-(L38/L31*100),Tables!$E$49))","v":""},{"$f":"IF(L40=\"\",\"\",ABS(O40-L40))","v":""},null,{"$f":"'Sublot 1'!O40","v":4},null,"%Air Voids Target",null,null," (Superpave, SMA) = 4%,  (RBL) = 2%"]
[null,"MOISTURE & VOLATILE SAMPLE",null,null,null,null,null,null," % V.M.A.",null,null,{"$f":"IF(L38=\"\",\"\",IF(L38>0,ROUND(100-L38*(100-L30)/L28,Tables!$E$50),Tables!E50))","v":""},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":""},null,{"$f":"'Sublot 4'!O41","v":14},null,"Enter required field VMA from mix design. "]
[null," Pan",null,null,null,null,null,null,{"$f":"IF(M39=\"ERR\",\"%L.M. Density out of range\",\"\")","v":""},null,null,{"$f":"IF(M41=\"ERR\",\" %VMA out of range\",\"\")","v":""}]
[null," Original Mix (W1m)",null,null,null,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":""},null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Dry Mix (W5m)",null,null,null,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":""},null,null,"m = ",null,"b = "]
[null,null,null,null,null,null,null,null,{"$f":"IF(O45=\"\",\" Avg. Rice\",\" Max. Theo. at JMF AC\")","v":" Max. Theo. at JMF AC"},null,null,{"$f":"IF(L24=\"\",\"\",ROUND(L24,Tables!$E$52))","v":""},"Gmm",null,{"$f":"VLOOKUP(O8,GTable,5)","v":85.5}," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null," Specimen No.",null,1,"2","3",null,{"$f":"VLOOKUP(O8,GTable,7)","v":89}," Nini Maximum Requirement"]
[null," S.E. No.",null,"1","2",{"$f":"+IF(F48=\"\",\"\",3)","v":""},null,null," Station"]
[null," Sand Reading",null,null,null,null,null,null," Expressway"]
[null," Clay Reading",null,null,null,null,null,null," Lane"]
[null," Sand Equivalent",null,{"$f":"IF(D49=\"\",\"\",ROUNDUP(MROUND(D48/D49*100,0.1),0))","v":""},{"$f":"IF(E49=\"\",\"\",ROUNDUP(MROUND(E48/E49*100,0.1),0))","v":""},{"$f":"IF(F49=\"\",\"\",ROUNDUP(MROUND(F48/F49*100,0.1),0))","v":""},null,null," Shot # 1"]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",ROUNDUP(MROUND(SUM(D50:F50)/COUNT(D50:F50),0.1),0))","v":""},null,null,null," Shot # 2",null,null,null,null,null,45," Minimum S.E. Requirement"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O50,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Shot # 3"]
[null,"Lab Molded","# of","Specimen","RATIO","LSMG","% Density",null," Shot # 4"]
[null,"Specimen","Gyrations","Height","(Ht@Ndes","(RATIO x","(LSMG",null," Avg. Unit Weight",null,{"$f":"IF(K51=\"\",\"\",AVERAGE(K50:K53))","v":""},{"$f":"IF(L51=\"\",\"\",AVERAGE(L50:L53))","v":""},{"$f":"IF(M51=\"\",\"\",AVERAGE(M50:M53))","v":""}]
[null," @ Ndes",null,null,"/Ht@Nini)","LSMG @","X 100/",null," Nuclear Core Spec. Grav.",null,{"$f":"IF(K54=\"\",\"\",ROUND((K54/62.4)*$J$44+$L$44,Tables!$E$53))","v":""},{"$f":"IF(L54=\"\",\"\",ROUND((L54/62.4)*$J$44+$L$44,Tables!$E$53))","v":""},{"$f":"IF(M54=\"\",\"\",ROUND((M54/62.4)*$J$44+$L$44,Tables!$E$53))","v":""},null,{"$f":"COUNT(K54:M54)","v":0}," No. of Cores"]
[null,null,null,null,null,"Ndes)","Rice's)",null," Calc. Avg. Bulk Core Sp. Gr.",null,null,{"$f":"IF(K55=\"\",\"\",ROUND(SUM(((K55+L55+M55))/O55),Tables!$E$55))","v":""}]
[null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":8},null,{"$f":"IF(D57=\"\",\"\",ROUND((D58/D57),Tables!$E$35))","v":""},{"$f":"IF(D57=\"\",\"\",ROUND((E57*F58),Tables!$E$36))","v":""},{"$f":"IF(AND(F58<>\"\",OR(D57=\"\",D58=\"\")),\"ERR\",IF(D58=\"\",\"\",ROUND(((F57*100)/$L$24),Tables!$E$37)))","v":""},null," % Roadway Density",null,{"$f":"IF(K55=\"\",\"\",ROUND(K55/$L$45*100,Tables!$E$56))","v":""},{"$f":"IF(L55=\"\",\"\",ROUND(L55/$L$45*100,Tables!$E$56))","v":""},{"$f":"IF(M55=\"\",\"\",ROUND(M55/$L$45*100,Tables!$E$56))","v":""}]
[null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":100},null,1,{"$f":"IF(D58=\"\",\"\",L38)","v":""},{"$f":"IF(D58=\"\",\"\",ROUND(((F58*100)/$L$24),Tables!$E$38))","v":""},null," % Avg. Roadway Density",null,null,{"$f":"IF(L44=\"\",\"\",IF(L44>0,ROUND(L56/L45*100,Tables!$E$57),\"\"))","v":""}]
[null,null,{"$f":"(IF(G58=\"\",\"\",IF(OR($G$57=\"ERR\",OR($G57>$O46,$G$57<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""},null,null,null,null,null,null,{"$f":"IF(L58=\"\",\"\",IF(OR(L58>97,L58<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]
[]
[null,"Signature / Cert. ID",null,null,"/"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"Pay Factors","index":6,"n_rows":230,"n_cols":129,"rows_kept":230,"cut":false,"hidden":false,"merged":[[35,2,48,10],[1,1,1,10],[2,2,2,4],[4,2,4,5],[8,1,8,3],[8,5,8,6],[11,1,11,2],[4,8,4,10],[2,6,2,8],[11,9,12,9],[11,10,12,10],[32,6,32,7]]}
[null,{"$f":"'Sublot 1'!A1","v":"v 1.14"},null,"OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
[null,"ASPHALT CONCRETE PAVING"]
[null,"PROJECT  NO:",{"$f":"IF('Sublot 1'!B6=\"\",\"\",'Sublot 1'!B6)","v":""},null,null,"  COUNTY:",null,null,null,"  DATE:  "]
[]
[null,"CONTRACTOR:",{"$f":"IF('Sublot 1'!B7=\"\",\"\",'Sublot 1'!B7)","v":""},null,null,null,"  ASPHALT  DESIGN  NO:",null,{"$f":"IF('Sublot 1'!L8=\"\",\"\",'Sublot 1'!L8)","v":""}]
[]
[]
[]
[null,"ID  ",null,null,"LOT NO.",{"$f":"'Sublot 1'!E13","v":1},null,null,"Total Tons",{"$f":"SUM('Sublot 1'!I10,'Sublot 2'!I10,'Sublot 3'!I10,'Sublot 4'!I10,'Sublot 5'!I10,'Sublot 6'!I10)","v":4000}]
[]
[]
[null,"DESIGN",null,{"$f":"\"SUBLOT \" &'Sublot 1'!G13","v":"SUBLOT 1"},{"$f":"\"SUBLOT \" &'Sublot 2'!G13","v":"SUBLOT 2"},{"$f":"\"SUBLOT \" &'Sublot 3'!G13","v":"SUBLOT 3"},{"$f":"\"SUBLOT \" &'Sublot 4'!G13","v":"SUBLOT 4"},{"$f":"\"SUBLOT \" &'Sublot 5'!G13","v":"SUBLOT 5"},{"$f":"\"SUBLOT \" &'Sublot 6'!G13","v":"SUBLOT 6"},"PFs","Reason to\nWaive PF"]
[null,"SIEVE SIZE","JMF","Test Result","Test Result","Test Result","Test Result","Test Result","Test Result"]
[null,"1\"",{"$f":"IF('Sublot 1'!$C$17=\"\",\"\",'Sublot 1'!$C$17)","v":100},{"$f":"IF('Sublot 1'!$F$17=\"\",\"\",'Sublot 1'!$F$17)","v":100},{"$f":"IF('Sublot 2'!$F$17=\"\",\"\",'Sublot 2'!$F$17)","v":100},{"$f":"IF('Sublot 3'!$F$17=\"\",\"\",'Sublot 3'!$F$17)","v":100},{"$f":"IF('Sublot 4'!$F$17=\"\",\"\",'Sublot 4'!$F$17)","v":100},{"$f":"IF('Sublot 5'!$F$17=\"\",\"\",'Sublot 5'!$F$17)","v":""},{"$f":"IF('Sublot 6'!$F$17=\"\",\"\",'Sublot 6'!$F$17)","v":""}]
[null,"3/4\"",{"$f":"IF('Sublot 1'!$C$18=\"\",\"\",'Sublot 1'!$C$18)","v":100},{"$f":"IF('Sublot 1'!$F$18=\"\",\"\",'Sublot 1'!$F$18)","v":100},{"$f":"IF('Sublot 2'!$F$18=\"\",\"\",'Sublot 2'!$F$18)","v":100},{"$f":"IF('Sublot 3'!$F$18=\"\",\"\",'Sublot 3'!$F$18)","v":100},{"$f":"IF('Sublot 4'!$F$18=\"\",\"\",'Sublot 4'!$F$18)","v":100},{"$f":"IF('Sublot 5'!$F$18=\"\",\"\",'Sublot 5'!$F$18)","v":""},{"$f":"IF('Sublot 6'!$F$18=\"\",\"\",'Sublot 6'!$F$18)","v":""}]
[null,"1/2\"",{"$f":"IF('Sublot 1'!$C$19=\"\",\"\",'Sublot 1'!$C$19)","v":96},{"$f":"IF('Sublot 1'!$F$19=\"\",\"\",'Sublot 1'!$F$19)","v":99},{"$f":"IF('Sublot 2'!$F$19=\"\",\"\",'Sublot 2'!$F$19)","v":98},{"$f":"IF('Sublot 3'!$F$19=\"\",\"\",'Sublot 3'!$F$19)","v":97},{"$f":"IF('Sublot 4'!$F$19=\"\",\"\",'Sublot 4'!$F$19)","v":97},{"$f":"IF('Sublot 5'!$F$19=\"\",\"\",'Sublot 5'!$F$19)","v":""},{"$f":"IF('Sublot 6'!$F$19=\"\",\"\",'Sublot 6'!$F$19)","v":""}]
[null,"3/8\"",{"$f":"IF('Sublot 1'!$C$20=\"\",\"\",'Sublot 1'!$C$20)","v":86},{"$f":"IF('Sublot 1'!$F$20=\"\",\"\",'Sublot 1'!$F$20)","v":92},{"$f":"IF('Sublot 2'!$F$20=\"\",\"\",'Sublot 2'!$F$20)","v":88},{"$f":"IF('Sublot 3'!$F$20=\"\",\"\",'Sublot 3'!$F$20)","v":87},{"$f":"IF('Sublot 4'!$F$20=\"\",\"\",'Sublot 4'!$F$20)","v":83},{"$f":"IF('Sublot 5'!$F$20=\"\",\"\",'Sublot 5'!$F$20)","v":""},{"$f":"IF('Sublot 6'!$F$20=\"\",\"\",'Sublot 6'!$F$20)","v":""}]
[null,"No. 4",{"$f":"IF('Sublot 1'!$C$21=\"\",\"\",'Sublot 1'!$C$21)","v":61},{"$f":"IF('Sublot 1'!$F$21=\"\",\"\",'Sublot 1'!$F$21)","v":74},{"$f":"IF('Sublot 2'!$F$21=\"\",\"\",'Sublot 2'!$F$21)","v":66},{"$f":"IF('Sublot 3'!$F$21=\"\",\"\",'Sublot 3'!$F$21)","v":65},{"$f":"IF('Sublot 4'!$F$21=\"\",\"\",'Sublot 4'!$F$21)","v":64},{"$f":"IF('Sublot 5'!$F$21=\"\",\"\",'Sublot 5'!$F$21)","v":""},{"$f":"IF('Sublot 6'!$F$21=\"\",\"\",'Sublot 6'!$F$21)","v":""}]
[null,"No. 8",{"$f":"IF('Sublot 1'!$C$22=\"\",\"\",'Sublot 1'!$C$22)","v":44},{"$f":"IF('Sublot 1'!$F$22=\"\",\"\",'Sublot 1'!$F$22)","v":55},{"$f":"IF('Sublot 2'!$F$22=\"\",\"\",'Sublot 2'!$F$22)","v":45},{"$f":"IF('Sublot 3'!$F$22=\"\",\"\",'Sublot 3'!$F$22)","v":45},{"$f":"IF('Sublot 4'!$F$22=\"\",\"\",'Sublot 4'!$F$22)","v":45},{"$f":"IF('Sublot 5'!$F$22=\"\",\"\",'Sublot 5'!$F$22)","v":""},{"$f":"IF('Sublot 6'!$F$22=\"\",\"\",'Sublot 6'!$F$22)","v":""}]
[null,"No. 16",{"$f":"IF('Sublot 1'!$C$23=\"\",\"\",'Sublot 1'!$C$23)","v":32},{"$f":"IF('Sublot 1'!$F$23=\"\",\"\",'Sublot 1'!$F$23)","v":39},{"$f":"IF('Sublot 2'!$F$23=\"\",\"\",'Sublot 2'!$F$23)","v":32},{"$f":"IF('Sublot 3'!$F$23=\"\",\"\",'Sublot 3'!$F$23)","v":33},{"$f":"IF('Sublot 4'!$F$23=\"\",\"\",'Sublot 4'!$F$23)","v":33},{"$f":"IF('Sublot 5'!$F$23=\"\",\"\",'Sublot 5'!$F$23)","v":""},{"$f":"IF('Sublot 6'!$F$23=\"\",\"\",'Sublot 6'!$F$23)","v":""}]
[null,"No. 30",{"$f":"IF('Sublot 1'!$C$24=\"\",\"\",'Sublot 1'!$C$24)","v":23},{"$f":"IF('Sublot 1'!$F$24=\"\",\"\",'Sublot 1'!$F$24)","v":27},{"$f":"IF('Sublot 2'!$F$24=\"\",\"\",'Sublot 2'!$F$24)","v":23},{"$f":"IF('Sublot 3'!$F$24=\"\",\"\",'Sublot 3'!$F$24)","v":24},{"$f":"IF('Sublot 4'!$F$24=\"\",\"\",'Sublot 4'!$F$24)","v":23},{"$f":"IF('Sublot 5'!$F$24=\"\",\"\",'Sublot 5'!$F$24)","v":""},{"$f":"IF('Sublot 6'!$F$24=\"\",\"\",'Sublot 6'!$F$24)","v":""}]
[null,"No. 50",{"$f":"IF('Sublot 1'!$C$25=\"\",\"\",'Sublot 1'!$C$25)","v":13},{"$f":"IF('Sublot 1'!$F$25=\"\",\"\",'Sublot 1'!$F$25)","v":15},{"$f":"IF('Sublot 2'!$F$25=\"\",\"\",'Sublot 2'!$F$25)","v":13},{"$f":"IF('Sublot 3'!$F$25=\"\",\"\",'Sublot 3'!$F$25)","v":14},{"$f":"IF('Sublot 4'!$F$25=\"\",\"\",'Sublot 4'!$F$25)","v":13},{"$f":"IF('Sublot 5'!$F$25=\"\",\"\",'Sublot 5'!$F$25)","v":""},{"$f":"IF('Sublot 6'!$F$25=\"\",\"\",'Sublot 6'!$F$25)","v":""}]
[null,"No. 100",{"$f":"IF('Sublot 1'!$C$26=\"\",\"\",'Sublot 1'!$C$26)","v":7},{"$f":"IF('Sublot 1'!$F$26=\"\",\"\",'Sublot 1'!$F$26)","v":9},{"$f":"IF('Sublot 2'!$F$26=\"\",\"\",'Sublot 2'!$F$26)","v":8},{"$f":"IF('Sublot 3'!$F$26=\"\",\"\",'Sublot 3'!$F$26)","v":9},{"$f":"IF('Sublot 4'!$F$26=\"\",\"\",'Sublot 4'!$F$26)","v":9},{"$f":"IF('Sublot 5'!$F$26=\"\",\"\",'Sublot 5'!$F$26)","v":""},{"$f":"IF('Sublot 6'!$F$26=\"\",\"\",'Sublot 6'!$F$26)","v":""}]
[null,"No. 200",{"$f":"IF('Sublot 1'!$C$27=\"\",\"\",'Sublot 1'!$C$27)","v":4.4000000000000004},{"$f":"IF('Sublot 1'!$F$28=\"\",\"\",'Sublot 1'!$F$28)","v":6.1},{"$f":"IF('Sublot 2'!$F$28=\"\",\"\",'Sublot 2'!$F$28)","v":5.6},{"$f":"IF('Sublot 3'!$F$28=\"\",\"\",'Sublot 3'!$F$28)","v":6.1},{"$f":"IF('Sublot 4'!$F$28=\"\",\"\",'Sublot 4'!$F$28)","v":5.4},{"$f":"IF('Sublot 5'!$F$28=\"\",\"\",'Sublot 5'!$F$28)","v":""},{"$f":"IF('Sublot 6'!$F$28=\"\",\"\",'Sublot 6'!$F$28)","v":""}]
[null,"% AC",{"$f":"IF('Sublot 1'!$C$29=\"\",\"\",'Sublot 1'!$C$29)","v":4.9000000000000004},{"$f":"IF('Sublot 1'!$F$30=\"\",\"\",'Sublot 1'!$F$30)","v":5.3},{"$f":"IF('Sublot 2'!$F$30=\"\",\"\",'Sublot 2'!$F$30)","v":4.8},{"$f":"IF('Sublot 3'!$F$30=\"\",\"\",'Sublot 3'!$F$30)","v":4.8},{"$f":"IF('Sublot 4'!$F$30=\"\",\"\",'Sublot 4'!$F$30)","v":4.8},{"$f":"IF('Sublot 5'!$F$30=\"\",\"\",'Sublot 5'!$F$30)","v":""},{"$f":"IF('Sublot 6'!$F$30=\"\",\"\",'Sublot 6'!$F$30)","v":""},{"$f":"IFERROR(PFPWL(C25,D25:I25,0.4,-0.4),\"\")","v":1.05},null,null,null,null,null,"Reasons: e.g. Mix is <1.5\" thick, Mix is type PFC, OGFSC, OGBB with no roadway density requirement."]
[null,"% VMA",{"$f":"IF('Sublot 1'!$O$41=\"\",\"\",'Sublot 1'!$O$41)","v":14},{"$f":"IF('Sublot 1'!$L$41=\"\",\"\",'Sublot 1'!$L$41)","v":14.7},{"$f":"IF('Sublot 2'!$L$41=\"\",\"\",'Sublot 2'!$L$41)","v":13.9},{"$f":"IF('Sublot 3'!$L$41=\"\",\"\",'Sublot 3'!$L$41)","v":13.3},{"$f":"IF('Sublot 4'!$L$41=\"\",\"\",'Sublot 4'!$L$41)","v":13.7},{"$f":"IF('Sublot 5'!$L$41=\"\",\"\",'Sublot 5'!$L$41)","v":""},{"$f":"IF('Sublot 6'!$L$41=\"\",\"\",'Sublot 6'!$L$41)","v":""},{"$f":"IFERROR(PFPWL(C26,D26:I26,3,-0.5),\"\")","v":0.87},null,null,null,null,"Comp.","<1.5\" Thick",null,"Note: Not all reasons are valid for both density and air voids.  Non-blank entries are 1.00 PF."]
[null,"% Air Voids",{"$f":"IF('Sublot 1'!$O$40=\"\",\"\",'Sublot 1'!$O$40)","v":4},{"$f":"IF('Sublot 1'!$L$40=\"\",\"\",'Sublot 1'!$L$40)","v":3.9},{"$f":"IF('Sublot 2'!$L$40=\"\",\"\",'Sublot 2'!$L$40)","v":4.0999999999999996},{"$f":"IF('Sublot 3'!$L$40=\"\",\"\",'Sublot 3'!$L$40)","v":3.5},{"$f":"IF('Sublot 4'!$L$40=\"\",\"\",'Sublot 4'!$L$40)","v":4},{"$f":"IF('Sublot 5'!$L$40=\"\",\"\",'Sublot 5'!$L$40)","v":""},{"$f":"IF('Sublot 6'!$L$40=\"\",\"\",'Sublot 6'!$L$40)","v":""},{"$f":"IFERROR(PFPWL(C27,D27:I27,1.35,-1.35),\"\")","v":1.05},null,null,"<- Waive?",null,{"$f":"IFERROR(PFoldPWL(C27,D27:I27,1.35,1.35,0.75,-0.75),\"\")","v":0.6},"PFC"]
[null,"PGmm Core 1",null,{"$f":"IF('Sublot 1'!$K$57=\"\",\"\",'Sublot 1'!$K$57)","v":95.5},{"$f":"IF('Sublot 2'!$K$57=\"\",\"\",'Sublot 2'!$K$57)","v":91.5},{"$f":"IF('Sublot 3'!$K$57=\"\",\"\",'Sublot 3'!$K$57)","v":93.3},{"$f":"IF('Sublot 4'!$K$57=\"\",\"\",'Sublot 4'!$K$57)","v":93.8},{"$f":"IF('Sublot 5'!$K$57=\"\",\"\",'Sublot 5'!$K$57)","v":""},{"$f":"IF('Sublot 6'!$K$57=\"\",\"\",'Sublot 6'!$K$57)","v":""},null,null,null,null,null,null,"OGFSC"]
[null,"PGmm Core 2",null,{"$f":"IF('Sublot 1'!$L$57=\"\",\"\",'Sublot 1'!$L$57)","v":92.4},{"$f":"IF('Sublot 2'!$L$57=\"\",\"\",'Sublot 2'!$L$57)","v":92.2},{"$f":"IF('Sublot 3'!$L$57=\"\",\"\",'Sublot 3'!$L$57)","v":94.2},{"$f":"IF('Sublot 4'!$L$57=\"\",\"\",'Sublot 4'!$L$57)","v":92.2},{"$f":"IF('Sublot 5'!$L$57=\"\",\"\",'Sublot 5'!$L$57)","v":""},{"$f":"IF('Sublot 6'!$L$57=\"\",\"\",'Sublot 6'!$L$57)","v":""},null,null,null,null,null,null,"OGBB"]
[null,"PGmm Core 3",null,{"$f":"IF('Sublot 1'!$M$57=\"\",\"\",'Sublot 1'!$M$57)","v":94},{"$f":"IF('Sublot 2'!$M$57=\"\",\"\",'Sublot 2'!$M$57)","v":91.3},{"$f":"IF('Sublot 3'!$M$57=\"\",\"\",'Sublot 3'!$M$57)","v":92.2},{"$f":"IF('Sublot 4'!$M$57=\"\",\"\",'Sublot 4'!$M$57)","v":91.6},{"$f":"IF('Sublot 5'!$M$57=\"\",\"\",'Sublot 5'!$M$57)","v":""},{"$f":"IF('Sublot 6'!$M$57=\"\",\"\",'Sublot 6'!$M$57)","v":""},null,null,null,null,null,"Comp.","UTBWC"]
[null,"Avg. PGmm",{"$f":"100-'Sublot 1'!$O$40-2","v":94},{"$f":"IF(D28=\"\",\"\",ROUND(AVERAGE(D28:D30),1))","v":94},{"$f":"IF(E28=\"\",\"\",ROUND(AVERAGE(E28:E30),1))","v":91.7},93.2,92.5,"","",{"$f":"IFERROR(PFPWL(C31,D31:I31,3,-2),\"\")","v":0.92},null,null,"<- Waive?",null,{"$f":"IFERROR(PFoldPWL(C31,D31:I31,3,-2.5,2,-1),\"\")","v":1.03}]
[null,"Final PFs","PGmm",{"$f":"IF(K31<>\"\",1,J31)","v":0.92},"% Air Voids",{"$f":"IF(K27<>\"\",1,J27)","v":1.05},"% AC",{"$f":"J25","v":1.05},"VMA",{"$f":"J26","v":0.87}]
[null,"CPF",{"$f":"IF(K31<>\"\",ROUND((4*J31+3*J27+2*J25+J26)/10,2),IFERROR(IF(COUNT(D28:I28)>2,ROUND((4*J31+3*J27+2*J25+J26)/10,2),\"\"),\"\"))","v":0.98},"CUP",63.81,null,"Pay Adjustment on Lot",null,{"$f":"IF(OR(C33=\"\",C33=0,E33=\"\"),\"\",(C33-1)*E33*J9)","v":-5104.8000000000047}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<-End Reasons"]
[null,null,{"$f":"IF(OR(J25=0,J26=0,J27=0,J31=0),\"*Remove and Replace or Accept using CPF.\",\"\")","v":""}]
[null,"Notes: "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Signature / Cert. ID",null,null,"/"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"{BRANCH O74}"]

{"sheet":"Instructions","index":7,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[" REQUIRED DATA FOR CALCULATIONS:  (Enter on Sublot 1 Tab only)",null,"Information:"]
["Sheet Sublot 1:"]
["Enter project information in the header cells B6 to L8.",null,"All data in blue text with yellow background is test data entry."]
[]
["Enter JMF gradations in cells C16 to C27."]
[]
["Enter JMF AC content in cell C29."]
[]
["Enter Tons for this Test Report in cell I9"]
[]
["Enter Data from Design in cells I11 to I13"]
[]
["Select the ESAL level or PG Grade in cell O8 using the dropdown selection list."]
[]
["Goto cells O39 and Q39 and enter %Density of GMM reqd. as listed on JMF."]
[]
["Goto cell O41 and enter min. %VMA as listed on JMF."]
[]
["Enter the SE limit in cell O51."]
[]
["Enter tolerances for gradataion and AC in cells S16 to S30."]
[]
["Enter 1 in cell O45 if PGmm by Pb at JMF in table 411:2.  Leave blank if SP 411:17 on Contract or OHD L-14 modified after 5/27/2008.  "]
[]
["Enter Rice method type for each Sublot sheet.  Mechanical method A is the default for all sublots unless changed on each."]
[]
[]
["Sheet Pay Factors:"]
["Enter county in G3."]
[]
["Enter date in K3."]
[]
["Enter Contract Unit Price (CUP) in E33."]
[]
["In P31:P34 add reasons to use a PF of 1.00 if reasons above them need addition."]
[]
["Enter comments in C36 block."]
[]
["Enter ODOT Asphalt Certification ID number in G31."]
[]
[]
[]
[]
[]
[]
["Revision history:"]
["2014-12-07","- Made new Pay Factors sheet for PWL."]
[]
["2016-02-17","- Revised Gradations to percentages on Pay Factors Sheet"]
[]
["2016-03-21","- Reset conditional formating on Dev. Column on Sublot 1 to Sublot 6 Tabs."]
[]
["2016-06-07","- Fixed Contractor data on Pay Factors Tab.."]
[]
["2016-06-21","- Corrected %AC Deviation calculation on Sublot 1, Sublot 2, Sublot 3, Sublot 4, Sublot 5 & Sublot 6 in cell G30."]
[]
["2018-10-24","- Added RIL-PG76E option to \"Million ESALs or PG Grade\" drop down list (cell O8) of \"Sublot 1\" sheet and added RIL-PG76E row and applicable specifications to \"Special Provisions 708-3 and 2009 Standard Specifications\" table on \"Tables\" sheet."]

{"sheet":"Tables","index":8,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[50,2,50,4],[51,2,51,3],[44,2,44,3],[31,2,31,4],[32,2,32,3],[33,2,33,4],[34,2,34,3],[35,2,35,3],[36,2,36,3],[38,2,38,4],[39,2,39,3],[40,2,40,3],[42,2,42,4],[43,2,43,3],[30,2,30,3],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[11,6,11,7],[12,6,12,7],[24,2,24,4],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[13,6,13,7],[13,8,13,9],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,6,7,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[6,6,6,7],[1,6,1,7],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7]]}
[null,null,"Special Provision 708-3 and 2009 Standard Specifications:"]
[null,null,"MESALs","Nini","Ndes","Nmax","MinNini",null,"MaxNini"]
[null,null,"0.3M-",6,50,75,85.5,null,91.5]
[null,null,"0.3M+",7,75,115,85.5,null,90.5]
[null,null,"3M+",8,100,160,85.5,null,89]
[null,null,"10M+",8,100,160,85.5,null,89]
[null,null,"30M+",9,125,205,85.5,null,89]
[null,null,"PG64",6,50,96,85.5,null,91.5]
[null,null,"PG70",7,65,96,85.5,null,90.5]
[null,null,"PG76",8,80,96,85.5,null,89]
[null,null,"SMA-PG76",0,50,96,0,null,0]
[null,null,"PFC-PG76",0,50,96,0,null,0]
[null,null,"RBL-PG64",0,50,96,0,null,0]
[null,null,"RIL-PG76E",0,50,97,0,null,0]
[]
[]
[null,null,"AASHTO T-209-12 Rices Precision"]
[null,null,"Method","Tolerance"]
[null,null,"A",1.4E-2]
[null,null,"B",1.7999999999999999E-2]
[]
[]
[]
[]
[null,null,"ROUNDING"]
[]
["Cells E16 thru E26",null,"Gradation % Ret. & Dev.",null,0,"E27"]
["Cells F28",null,"Gradation #200 & Dev.",null,1,"E28"]
["Cell F30",null,"Corrected % AC",null,1,"E29"]
["Cell E39",null,"Precision (+/- 0.2 %)",null,1,"E30"]
["Cells E50, F50",null,"Sand Equivalent",null,1,"E31"]
[null,null,"DENSITY (OHD L-45)"]
["Cells D60, E60, F60",null,"Core Spec. Grav. ( Gmb )",null,3,"E33"]
[null,null,"LAB MOLDED @ Ndes"]
["Cell E57",null,"NINI Ratio",null,4,"E35"]
["Cell F57",null,"NINI LSMG",null,3,"E36"]
["Cell G57",null,"NINI % Density",null,1,"E37"]
["Cell G58",null,"Ndes % Density",null,1,"E38"]
[null,null,"MAX. SPECIFIC GRAVITY"]
["Cells K23, M23",null,"Rice's Gravity",null,3,"E40"]
["Cell L24",null,"Avg. Rice Gravity (Gmm)",null,3,"E41"]
["Cell L25",null,"Eff. Spec. Grav. (Gse)",null,3,"E42"]
[null,null,"LAB MOLDED DENSITY"]
["Cell L28",null,"New Gsb  ( calculated )",null,3,"E44"]
["Cell L31",null,"Max. Theo. Spec. Grav.",null,3,"E45"]
["Cells K37, L37, M37",null,"L.M. Spec. Grav. - Gmb",null,3,"E46"]
["Cell L38",null,"Avg. L.M. Spec. Grav.",null,3,"E47"]
["Cell L39",null,"% L.M. Density @ Ndes",null,1,"E48"]
["Cell L40",null,"% Air Voids",null,{"$f":"H49","v":1},"E49",null,{"$f":"IF('Sublot 1'!O44=1,2,1)","v":1}]
["Cell L41",null,"% V.M.A.",null,1,"E50"]
[null,null,"ROADWAY DENSITY"]
["Cell L45",null,"Max. Theo. Sp. Gr. at JMF",null,3,"E52"]
["Cells K55, L55, M55",null,"Nuclear Core Spec. Grav.",null,3,"E53"]
[]
["Cell L56",null,"Avg. Core Sp. Gr. ( Gmb )",null,3,"E55"]
["Cells K57, L57, M57",null,"% Roadway Density",null,1,"E56"]
["Cell L58",null,"% Avg. Roadway Density",null,1,"E57"]

{"sheet":"Disclaimer","index":9,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["By using this file, you are agreeing to this License Agreement:"]
[]
["The Oklahoma Department of Transportation (ODOT) does not provide technical support with respect to these files. Read the following disclaimer for terms of use pior to using this file."]
[]
[]
["ODOT makes no warranty of any kind, express or implied, with respect to any file. ODOT makes no warranty that any file is marketable or fit for any particular purpose. A description of a file shall not be deemed to create an express warranty that the file conforms to that description. You agree to accept the files in the format provided."]
[]
[]
["You assume all risk and liability for any losses, damages, claims, or expenses resulting from the use or possession of any file."]
[]
[]
["You agree to indemnify, defend, and hold harmless ODOT and its officers, agents, and employees from and against any and all claims, suits, losses, damages, or costs, including reasonable attorney's fees, arising from or by reason of your use or possession of any file. This indemnification shall survive your acceptance of any file."]
[]
[]
["Revisions or additions may occur at any time. You agree to indemnify, defend, and hold harmless ODOT and its officers, agents, and employees from and against any and all claims, suits, losses, damages, or costs, including reasonable attorney's fees, arising from the use of outdated files. This indemnification shall survive your acceptance of any file."]
[]
[]
["The files are copyrighted by ODOT and may not be resold without the express written consent of ODOT. "]