{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Sublot 1","Sublot 2","Sublot 3","Sublot 4","Sublot 5","Pay Factors","Tables","Instructions","Disclaimer"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":3,"defined_names":31,"comments":5,"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],[55,8,55,9],[56,8,56,9],[57,8,57,9],[58,8,58,9],[48,8,48,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[32,8,32,9],[33,8,33,9],[54,1,54,2],[55,1,55,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[38,8,38,9],[39,8,39,9],[40,8,40,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[52,8,52,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[40,1,40,5],[42,1,42,2],[43,1,43,2],[41,1,41,2],[56,1,56,2],[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],[59,1,59,2],[42,8,43,8],[42,9,43,9],[42,10,43,10],[42,11,43,11],[47,8,47,12],[52,1,52,5],[50,1,50,2],[53,1,53,2],[45,1,45,5],[57,1,57,2],[58,1,58,2],[42,12,43,12],[59,8,59,9],[53,8,53,9],[54,8,54,9],[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[64,8,64,9]]}
["v 1.17","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,"PG64","    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,null," ","  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt."," ","  Gsb from Design",null,null,null,null,"A","    Rices Precision: Select from drop-down list."]
[null," Temperature ",null,"Lot",1,"SubLot",1,null," ","  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)"," ",null,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$51))","v":""},{"$f":"IF(D16=\"\",\"\",100-E16)","v":""},{"$f":"IF(D16=\"\",\"\",ABS(C16-F16))","v":""},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":{"$error":"#VALUE!"}},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":{"$error":"#VALUE!"}},null,0]
[null,"1\" (25.0 mm)"," ",null,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D17=\"\",\"\",ABS(C17-F17))","v":""},null," Flask No.",null,null,"|",null,null,"1\" (25.0 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0]
[null,"3/4\" (19.0 mm"," ",null,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D18=\"\",\"\",ABS(C18-F18))","v":""},null," Sample Wt.","           (A)  ",null,"|",null,null,"3/4\" (19.0 mm",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"1/2\" (12.5 mm)"," ",null,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D19=\"\",\"\",ABS(C19-F19))","v":""},null," Calib. Wt.","           (B)  ",null,"|",null,null,"1/2\" (12.5 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"3/8\" (9.5 mm)"," ",null,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$51))","v":""},"","",null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":""},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":""},null,"3/8\" (9.5 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"# 4 ( 4.75 mm)"," ",null,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$51))","v":""},"","",null," Sample + Flask + H²O  (D)",null,null,"|",null,null,"# 4 ( 4.75 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"# 8 (2.36 mm)"," ",null,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$51))","v":""},"","",null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":""},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":""},null,"# 8 (2.36 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,5]
[null,"# 16 ( 1.18 mm)"," ",null,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$51))","v":""},"","",null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$64),\"\")","v":""},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$64),\"\")","v":""},null,"# 16 ( 1.18 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 30 (.600 mm)"," ",null,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$51))","v":""},"","",null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$65))","v":""},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 50 (.300 mm)"," ",null,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$51))","v":""},"","",null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$66),\"\")","v":""},null,null,"# 50 (.300 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 100 (.150 mm)"," ",null,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$51))","v":""},"","",null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3]
[null,"# 200 (.075 mm)"," ",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$52))","v":""},{"$f":"IF(D27=\"\",\"\",ABS(C27-F28))","v":""},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$68))","v":""},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":{"$error":"#VALUE!"}},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":{"$error":"#VALUE!"}},null,2]
[null," % AC (P5m)"," ",null,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":""}]
[null," Corrected %AC",null,null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$53))","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":{"$error":"#VALUE!"}},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":{"$error":"#VALUE!"}},null,0.4]
[null," Basket (A)",null,null,null,null,null,null," Max. Theo. Spec. Grav.",null,null,{"$f":"IF(L24=\"\",\"\",ROUND(L24,Tables!$E$69))","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$70))","v":""},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$70))","v":""},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$70))","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$71))","v":""}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$54))","v":""},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$72))","v":""},{"$f":"IF(L39=\"\",\"\",IF(OR(ROUND(L39,1)<O39,ROUND(L39,1)>Q39),\"ERR\",\"\"))","v":""},null,94.5,"-",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$73))","v":""},{"$f":"IF(L40=\"\",\"\",ABS(O40-L40))","v":""},null,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$74),Tables!E74))","v":""},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":""},null,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,"Lab Molded Specimen         @ Ndes","# of Gyrations","Specimen Height","LSMG Ratio x LSMG @ Ndes)","% Density (LSMG x 100 / Rice's)"]
[null," Dry Mix (W5m)",null,null,null,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":""}]
[null,null,null,null,null,null,null,null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":6},null,{"$f":"IF(K45=\"\",\"\",ROUND((K46/K45),Tables!$E$59)*ROUND(L46,Tables!$E$60))","v":""},{"$f":"IF(AND(L46<>\"\",OR(K45=\"\",K46=\"\")),\"ERR\",IF(K46=\"\",\"\",ROUND(((L45*100)/$L$24),Tables!$E$61)))","v":""},null,{"$f":"VLOOKUP(O8,GTable,5)","v":85.5}," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":50},null,{"$f":"IF(K46=\"\",\"\",L38)","v":""},{"$f":"IF(K46=\"\",\"\",ROUND(((L46*100)/$L$24),Tables!$E$62))","v":""},null,{"$f":"VLOOKUP(O8,GTable,7)","v":91.5}," Nini Maximum Requirement"]
[null," S.E. No.",null,1,2,{"$f":"+IF(F48=\"\",\"\",3)","v":""},null,null,{"$f":"(IF(M46=\"\",\"\",IF(OR($M$45=\"ERR\",OR($M45>$O46,$M$45<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""}]
[null," Sand Reading",null,null,null,null,null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Clay Reading",null,null,null,null,null,{"$f":"IF(O49=1,\"OHD L-14\",\"\")","v":""},{"$f":"IF(O49=\"\",\" Avg. Rice Gravity\",\" Max. Theo. at JMF AC\")","v":" Avg. Rice Gravity"},null,null,{"$f":"IF(K58=\"\",\"\",IF(O49=1,ROUND((100/(($C29/$I$13)+(100-$C29)/L25)),Tables!$E$56),$L$24))","v":""},"Gmm",null,null,null,"= 1 if density by PGmm by Pb at JMF in 411 pay table, else leave blank."]
[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,{"$f":"IF(O49=1,\"05/27/08\",\"\")","v":""}," Specimen No."]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",ROUNDUP(MROUND(SUM(D50:F50)/COUNT(D50:F50),0.1),0))","v":""},null,null,null," Station"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O51,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Expressway"]
[null,"DENSITY TEST FOR ROADWAY CORES (OHD L-45)",null,null,null,null,null,null," Lane"]
[null," A (Wt. Dry Spec. in Air)",null,{"$f":"IF(N(K61)>2,K58,\"\")","v":""},{"$f":"IF(N(L61)>2,L58,\"\")","v":""},{"$f":"IF(N(M61)>2,M58,\"\")","v":""},null,null," Thickness (in.)"]
[null," Bag Weight",null,null,null,null,null,null," Initial Wt. Spec. in Air"]
[null," B (Sealed Wt. in Air)",null,{"$f":"IF(D54=\"\",\"\",D54+D55)","v":""},{"$f":"IF(E54=\"\",\"\",E54+E55)","v":""},{"$f":"IF(F54=\"\",\"\",F54+F55)","v":""},null,null," C (Wt. Spec. in Water)",null,null,null,null,null,45," Minimum S.E. Requirement"]
[null," E (Sealed Spec. Wt. in H2O)",null,null,null,null,null,null," B (Wt. Spec. S.S.D.)"]
[null," C (Final Wt. Dry Spec. in Air)",null,null,null,null,null,null," A (Wt. Dry Spec. in Air)"]
[null," F (Bag's Gsa)",null,{"$f":"IF(OR(D58=\"\",D54=\"\"),\"\",IF((D55)>=35,0.8596-((0.00166*D54)/(D55)),IF((D55)<35,0.8121-((0.000566*D54)/(D55)),\"ERR\")))","v":""},{"$f":"IF(OR(E58=\"\",E54=\"\"),\"\",IF((E55)>=35,0.8596-((0.00166*E54)/(E55)),IF((E55)<35,0.8121-((0.000566*E54)/(E55)),\"ERR\")))","v":""},{"$f":"IF(OR(F58=\"\",F54=\"\"),\"\",IF((F55)>=35,0.8596-((0.00166*F54)/(F55)),IF((F55)<35,0.8121-((0.000566*F54)/(F55)),\"ERR\")))","v":""},null,null," B - C",null,{"$f":"IF(K58=\"\",\"\",+K57-K56)","v":""},{"$f":"IF(L58=\"\",\"\",+L57-L56)","v":""},{"$f":"IF(M58=\"\",\"\",+M57-M56)","v":""}]
[null," Core Spec. Grav.  ( Gmb )",null,{"$f":"IF(OR(D54=\"\",D55=\"\"),\"\",ROUND(D54/(D58+D55-D57-(D55)/D59),Tables!$E$37))","v":""},{"$f":"IF(OR(E54=\"\",E55=\"\"),\"\",ROUND(E54/(E58+E55-E57-(E55)/E59),Tables!$E$37))","v":""},{"$f":"IF(OR(F54=\"\",F55=\"\"),\"\",ROUND(F54/(F58+F55-F57-(F55)/F59),Tables!$E$37))","v":""},null,null," Core Spec. Grav.  ( Gmb )",null,{"$f":"IF(K59=\"\",\"\",ROUND((K58/K59),Tables!$E$77))","v":""},{"$f":"IF(L59=\"\",\"\",ROUND((L58/L59),Tables!$E$77))","v":""},{"$f":"IF(M59=\"\",\"\",ROUND((M58/M59),Tables!$E$77))","v":""},null,{"$f":"COUNT(K60:M60)","v":0}," No. of Cores"]
[null,null,null,{"$f":"IF(D58=\"\",\"\",IF(AND(D54-D58<D54*0.0008,D58-D54<=D54*0.0004),\"\",\"REDO\"))","v":""},{"$f":"IF(E58=\"\",\"\",IF(AND(E54-E58<E54*0.0008,E58-E54<=E54*0.0004),\"\",\"REDO\"))","v":""},{"$f":"IF(F58=\"\",\"\",IF(AND(F54-F58<F54*0.0008,F58-F54<=F54*0.0004),\"\",\"REDO\"))","v":""},null,null," % Absorption",null,{"$f":"IF(K56=\"\",\"\",ROUND((K57-K58)/(K57-K56)*100,Tables!$E$78))","v":""},{"$f":"IF(L58=\"\",\"\",ROUND((L57-L58)/(L57-L56)*100,Tables!$E$78))","v":""},{"$f":"IF(M58=\"\",\"\",ROUND((M57-M58)/(M57-M56)*100,Tables!$E$78))","v":""}]
[null,null,null,{"$f":"IF(D60<>\"\",D60,K60)","v":""},{"$f":"IF(E60<>\"\",E60,L60)","v":""},{"$f":"IF(F60<>\"\",F60,M60)","v":""},null,null," Avg. Core Sp. Gr. ( Gmb )",null,null,{"$f":"IF(K60=\"\",\"\",ROUND(AVERAGE(D62:F62),Tables!$E$79))","v":""}]
[null,null,null,null,null,null,null,null," % Roadway Density",null,{"$f":"IF(K64=\"\",\"\",IF(K64=\"L-14\",ROUND(K60/$L$49*100,Tables!$E$80),ROUND(D62/$L$49*100,Tables!$E$80)))","v":""},{"$f":"IF(L64=\"\",\"\",IF(L64=\"L-14\",ROUND(L60/$L$49*100,Tables!$E$80),ROUND(E62/$L$49*100,Tables!$E$80)))","v":""},{"$f":"IF(M64=\"\",\"\",IF(M64=\"L-14\",ROUND(M60/$L$49*100,Tables!$E$80),ROUND(F62/$L$49*100,Tables!$E$80)))","v":""}]
[null,null,null,null,null,null,null,null," Density Test Method",null,{"$f":"IF(K58=\"\",\"\",IF(AND(K61>2,D60>0),\"L-45  \",\"L-14  \"))","v":""},{"$f":"IF(L58=\"\",\"\",IF(AND(L61>2,E60>0),\"L-45  \",\"L-14  \"))","v":""},{"$f":"IF(M58=\"\",\"\",IF(AND(M61>2,F60>0),\"L-45  \",\"L-14  \"))","v":""}]
[null,"Signature / Cert. ID",null,null,"/",null,null,null," % Avg. Roadway Density",null,null,{"$f":"IF(L49=\"\",\"\",IF(L49>0,ROUND(L62/L49*100,Tables!$E$81),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(N(K61)>2,N(L61)>2,N(M61)>2),\"A core absorption is > 2.0%. OHD L-45 is required for it.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L65=\"\",\"\",IF(OR(L65>97,L65<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]

{"sheet":"Sublot 2","index":1,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":false,"merged":[[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[64,8,64,9],[59,1,59,2],[42,8,43,8],[42,9,43,9],[42,10,43,10],[42,11,43,11],[47,8,47,12],[59,8,59,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[53,8,53,9],[54,8,54,9],[55,8,55,9],[49,8,49,9],[42,12,43,12],[48,1,48,2],[37,8,37,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[48,8,48,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[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],[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],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,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],[0,1,0,13],[57,8,57,9],[58,8,58,9],[56,8,56,9],[52,1,52,5],[53,1,53,2],[57,1,57,2],[58,1,58,2],[54,1,54,2],[55,1,55,2],[42,1,42,2],[43,1,43,2],[56,1,56,2],[45,1,45,5],[46,1,46,2],[47,1,47,2]]}
[{"$f":"'Sublot 1'!A1","v":"v 1.17"},"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":"PG64"},"    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":""},{"$f":"'Sublot 1'!I11","v":" "},"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",{"$f":"'Sublot 1'!I12","v":" "},"  Gsb from Design",null,null,null,null,"A","    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":""},{"$f":"'Sublot 1'!I13","v":" "},"  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":" "},null,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$51))","v":""},{"$f":"IF(D16=\"\",\"\",100-E16)","v":""},{"$f":"IF(D16=\"\",\"\",ABS(C16-F16))","v":""},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":{"$error":"#VALUE!"}},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":{"$error":"#VALUE!"}},null,0]
[null,"1\" (25.0 mm)",{"$f":"'Sublot 1'!C17","v":" "},null,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D17=\"\",\"\",ABS(C17-F17))","v":""},null," Flask No.",null,null,"|",null,null,"1\" (25.0 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0]
[null,"3/4\" (19.0 mm",{"$f":"'Sublot 1'!C18","v":" "},null,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D18=\"\",\"\",ABS(C18-F18))","v":""},null," Sample Wt.","           (A)  ",null,"|",null,null,"3/4\" (19.0 mm",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0]
[null,"1/2\" (12.5 mm)",{"$f":"'Sublot 1'!C19","v":" "},null,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D19=\"\",\"\",ABS(C19-F19))","v":""},null," Calib. Wt.","           (B)  ",null,"|",null,null,"1/2\" (12.5 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"3/8\" (9.5 mm)",{"$f":"'Sublot 1'!C20","v":" "},null,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$51))","v":""},"","",null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":""},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":""},null,"3/8\" (9.5 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"# 4 ( 4.75 mm)",{"$f":"'Sublot 1'!C21","v":" "},null,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$51))","v":""},"","",null," Sample + Flask + H²O  (D)",null,null,"|",null,null,"# 4 ( 4.75 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"# 8 (2.36 mm)",{"$f":"'Sublot 1'!C22","v":" "},null,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$51))","v":""},"","",null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":""},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":""},null,"# 8 (2.36 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,5]
[null,"# 16 ( 1.18 mm)",{"$f":"'Sublot 1'!C23","v":" "},null,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$51))","v":""},"","",null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$64),\"\")","v":""},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$64),\"\")","v":""},null,"# 16 ( 1.18 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 30 (.600 mm)",{"$f":"'Sublot 1'!C24","v":" "},null,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$51))","v":""},"","",null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$65))","v":""},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 50 (.300 mm)",{"$f":"'Sublot 1'!C25","v":" "},null,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$51))","v":""},"","",null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$66),\"\")","v":""},null,null,"# 50 (.300 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 100 (.150 mm)",{"$f":"'Sublot 1'!C26","v":" "},null,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$51))","v":""},"","",null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3]
[null,"# 200 (.075 mm)",{"$f":"'Sublot 1'!C27","v":" "},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$52))","v":""},{"$f":"IF(D27=\"\",\"\",ABS(C27-F28))","v":""},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$68))","v":""},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":{"$error":"#VALUE!"}},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":{"$error":"#VALUE!"}},null,2]
[null," % AC (P5m)",{"$f":"'Sublot 1'!C29","v":" "},null,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":""}]
[null," Corrected %AC",null,null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$53))","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":{"$error":"#VALUE!"}},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":{"$error":"#VALUE!"}},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$69),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$70))","v":""},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$70))","v":""},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$70))","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$71))","v":""}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$54))","v":""},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$72))","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$73))","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$74),Tables!E74))","v":""},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":""},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":""}]
[null," Original Mix (W1m)",null,null,null,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":""},null,null,"Lab Molded Specimen         @ Ndes","# of Gyrations","Specimen Height","LSMG Ratio x LSMG @ Ndes)","% Density (LSMG x 100 / Rice's)"]
[null," Dry Mix (W5m)",null,null,null,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":""}]
[null,null,null,null,null,null,null,null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":6},null,{"$f":"IF(K45=\"\",\"\",ROUND((K46/K45),Tables!$E$59)*ROUND(L46,Tables!$E$60))","v":""},{"$f":"IF(AND(L46<>\"\",OR(K45=\"\",K46=\"\")),\"ERR\",IF(K46=\"\",\"\",ROUND(((L45*100)/$L$24),Tables!$E$61)))","v":""},null,{"$f":"VLOOKUP(O8,GTable,5)","v":85.5}," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":50},null,{"$f":"IF(K46=\"\",\"\",L38)","v":""},{"$f":"IF(K46=\"\",\"\",ROUND(((L46*100)/$L$24),Tables!$E$62))","v":""},null,{"$f":"VLOOKUP(O8,GTable,7)","v":91.5}," Nini Maximum Requirement"]
[null," S.E. No.",null,"1","2",{"$f":"+IF(F48=\"\",\"\",3)","v":""},null,null,{"$f":"(IF(M46=\"\",\"\",IF(OR($M$45=\"ERR\",OR($M45>$O46,$M$45<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""}]
[null," Sand Reading",null,null,null,null,null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Clay Reading",null,null,null,null,null,{"$f":"IF(O49=1,\"OHD L-14\",\"\")","v":""},{"$f":"IF(O49=\"\",\" Avg. Rice Gravity\",\" Max. Theo. at JMF AC\")","v":" Avg. Rice Gravity"},null,null,{"$f":"IF(K58=\"\",\"\",IF(O49=1,ROUND((100/(($C29/$I$13)+(100-$C29)/L25)),Tables!$E$56),$L$24))","v":""},"Gmm",null,null,null,"= 1 if density by PGmm by Pb at JMF in 411 pay table, else leave blank."]
[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,{"$f":"IF(O49=1,\"05/27/08\",\"\")","v":""}," Specimen No."]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",ROUNDUP(MROUND(SUM(D50:F50)/COUNT(D50:F50),0.1),0))","v":""},null,null,null," Station"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O50,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Expressway"]
[null,"DENSITY TEST FOR ROADWAY CORES (OHD L-45)",null,null,null,null,null,null," Lane"]
[null," A (Wt. Dry Spec. in Air)",null,{"$f":"IF(N(K61)>2,K58,\"\")","v":""},{"$f":"IF(N(L61)>2,L58,\"\")","v":""},{"$f":"IF(N(M61)>2,M58,\"\")","v":""},null,null," Thickness (in.)"]
[null," Bag Weight",null,null,null,null,null,null," Initial Wt. Spec. in Air",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS('Sublot 1'!L65-L65)>'Pay Factors'!B22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}}]
[null," B (Sealed Wt. in Air)",null,{"$f":"IF(D54=\"\",\"\",D54+D55)","v":""},{"$f":"IF(E54=\"\",\"\",E54+E55)","v":""},{"$f":"IF(F54=\"\",\"\",F54+F55)","v":""},null,null," C (Wt. Spec. in Water)",null,null,null,null,null,{"$f":"'Sublot 1'!O56","v":45}," Minimum S.E. Requirement"]
[null," E (Sealed Spec. Wt. in H2O)",null,null,null,null,null,null," B (Wt. Spec. S.S.D.)"]
[null," C (Final Wt. Dry Spec. in Air)",null,null,null,null,null,null," A (Wt. Dry Spec. in Air)"]
[null," F (Bag's Gsa)",null,{"$f":"IF(OR(D58=\"\",D54=\"\"),\"\",IF((D55)>=35,0.8596-((0.00166*D54)/(D55)),IF((D55)<35,0.8121-((0.000566*D54)/(D55)),\"ERR\")))","v":""},{"$f":"IF(OR(E58=\"\",E54=\"\"),\"\",IF((E55)>=35,0.8596-((0.00166*E54)/(E55)),IF((E55)<35,0.8121-((0.000566*E54)/(E55)),\"ERR\")))","v":""},{"$f":"IF(OR(F58=\"\",F54=\"\"),\"\",IF((F55)>=35,0.8596-((0.00166*F54)/(F55)),IF((F55)<35,0.8121-((0.000566*F54)/(F55)),\"ERR\")))","v":""},null,null," B - C",null,{"$f":"IF(K58=\"\",\"\",+K57-K56)","v":""},{"$f":"IF(L58=\"\",\"\",+L57-L56)","v":""},{"$f":"IF(M58=\"\",\"\",+M57-M56)","v":""}]
[null," Core Spec. Grav.  ( Gmb )",null,{"$f":"IF(OR(D54=\"\",D55=\"\"),\"\",ROUND(D54/(D58+D55-D57-(D55)/D59),Tables!$E$37))","v":""},{"$f":"IF(OR(E54=\"\",E55=\"\"),\"\",ROUND(E54/(E58+E55-E57-(E55)/E59),Tables!$E$37))","v":""},{"$f":"IF(OR(F54=\"\",F55=\"\"),\"\",ROUND(F54/(F58+F55-F57-(F55)/F59),Tables!$E$37))","v":""},null,null," Core Spec. Grav.  ( Gmb )",null,{"$f":"IF(K59=\"\",\"\",ROUND((K58/K59),Tables!$E$77))","v":""},{"$f":"IF(L59=\"\",\"\",ROUND((L58/L59),Tables!$E$77))","v":""},{"$f":"IF(M59=\"\",\"\",ROUND((M58/M59),Tables!$E$77))","v":""},null,{"$f":"COUNT(K60:M60)","v":0}," No. of Cores"]
[null,null,null,{"$f":"IF(D58=\"\",\"\",IF(AND(D54-D58<D54*0.0008,D58-D54<=D54*0.0004),\"\",\"REDO\"))","v":""},{"$f":"IF(E58=\"\",\"\",IF(AND(E54-E58<E54*0.0008,E58-E54<=E54*0.0004),\"\",\"REDO\"))","v":""},{"$f":"IF(F58=\"\",\"\",IF(AND(F54-F58<F54*0.0008,F58-F54<=F54*0.0004),\"\",\"REDO\"))","v":""},null,null," % Absorption",null,{"$f":"IF(K56=\"\",\"\",ROUND((K57-K58)/(K57-K56)*100,Tables!$E$78))","v":""},{"$f":"IF(L58=\"\",\"\",ROUND((L57-L58)/(L57-L56)*100,Tables!$E$78))","v":""},{"$f":"IF(M58=\"\",\"\",ROUND((M57-M58)/(M57-M56)*100,Tables!$E$78))","v":""}]
[null,null,null,{"$f":"IF(D60<>\"\",D60,K60)","v":""},{"$f":"IF(E60<>\"\",E60,L60)","v":""},{"$f":"IF(F60<>\"\",F60,M60)","v":""},null,null," Avg. Core Sp. Gr. ( Gmb )",null,null,{"$f":"IF(K60=\"\",\"\",ROUND(AVERAGE(D62:F62),Tables!$E$79))","v":""}]
[null,null,null,null,null,null,null,null," % Roadway Density",null,{"$f":"IF(K64=\"\",\"\",IF(K64=\"L-14\",ROUND(K60/$L$49*100,Tables!$E$80),ROUND(D62/$L$49*100,Tables!$E$80)))","v":""},{"$f":"IF(L64=\"\",\"\",IF(L64=\"L-14\",ROUND(L60/$L$49*100,Tables!$E$80),ROUND(E62/$L$49*100,Tables!$E$80)))","v":""},{"$f":"IF(M64=\"\",\"\",IF(M64=\"L-14\",ROUND(M60/$L$49*100,Tables!$E$80),ROUND(F62/$L$49*100,Tables!$E$80)))","v":""}]
[null,null,null,null,null,null,null,null," Density Test Method",null,{"$f":"IF(K58=\"\",\"\",IF(AND(K61>2,D60>0),\"L-45  \",\"L-14  \"))","v":""},{"$f":"IF(L58=\"\",\"\",IF(AND(L61>2,E60>0),\"L-45  \",\"L-14  \"))","v":""},{"$f":"IF(M58=\"\",\"\",IF(AND(M61>2,F60>0),\"L-45  \",\"L-14  \"))","v":""}]
[null,"Signature / Cert. ID",null,null,"/",null,null,null," % Avg. Roadway Density",null,null,{"$f":"IF(L49=\"\",\"\",IF(L49>0,ROUND(L62/L49*100,Tables!$E$81),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(N(K61)>2,N(L61)>2,N(M61)>2),\"A core absorption is > 2.0%. OHD L-45 is required for it.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L65=\"\",\"\",IF(OR(L65>97,L65<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]

{"sheet":"Sublot 3","index":2,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":false,"merged":[[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[64,8,64,9],[59,1,59,2],[42,8,43,8],[42,9,43,9],[42,10,43,10],[42,11,43,11],[47,8,47,12],[42,12,43,12],[59,8,59,9],[58,8,58,9],[57,8,57,9],[56,8,56,9],[55,8,55,9],[53,8,53,9],[54,8,54,9],[47,1,47,2],[48,1,48,2],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[52,8,52,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[48,8,48,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[49,1,49,2],[57,1,57,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],[58,1,58,2],[50,1,50,2],[52,1,52,5],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[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.17"},"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":"PG64"},"    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":""},{"$f":"'Sublot 1'!I11","v":" "},"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",{"$f":"'Sublot 1'!I12","v":" "},"  Gsb from Design",null,null,null,null,"A","    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":""},{"$f":"'Sublot 1'!I13","v":" "},"  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":" "},null,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$51))","v":""},{"$f":"IF(D16=\"\",\"\",100-E16)","v":""},{"$f":"IF(D16=\"\",\"\",ABS(C16-F16))","v":""},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":{"$error":"#VALUE!"}},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":{"$error":"#VALUE!"}},null,0]
[null,"1\" (25.0 mm)",{"$f":"'Sublot 2'!C17","v":" "},null,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D17=\"\",\"\",ABS(C17-F17))","v":""},null," Flask No.",null,null,"|",null,null,"1\" (25.0 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0]
[null,"3/4\" (19.0 mm",{"$f":"'Sublot 2'!C18","v":" "},null,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D18=\"\",\"\",ABS(C18-F18))","v":""},null," Sample Wt.","           (A)  ",null,"|",null,null,"3/4\" (19.0 mm",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0]
[null,"1/2\" (12.5 mm)",{"$f":"'Sublot 2'!C19","v":" "},null,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D19=\"\",\"\",ABS(C19-F19))","v":""},null," Calib. Wt.","           (B)  ",null,"|",null,null,"1/2\" (12.5 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"3/8\" (9.5 mm)",{"$f":"'Sublot 2'!C20","v":" "},null,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$51))","v":""},"","",null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":""},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":""},null,"3/8\" (9.5 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"# 4 ( 4.75 mm)",{"$f":"'Sublot 2'!C21","v":" "},null,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$51))","v":""},"","",null," Sample + Flask + H²O  (D)",null,null,"|",null,null,"# 4 ( 4.75 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"# 8 (2.36 mm)",{"$f":"'Sublot 2'!C22","v":" "},null,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$51))","v":""},"","",null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":""},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":""},null,"# 8 (2.36 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,5]
[null,"# 16 ( 1.18 mm)",{"$f":"'Sublot 2'!C23","v":" "},null,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$51))","v":""},"","",null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$64),\"\")","v":""},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$64),\"\")","v":""},null,"# 16 ( 1.18 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 30 (.600 mm)",{"$f":"'Sublot 2'!C24","v":" "},null,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$51))","v":""},"","",null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$65))","v":""},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 50 (.300 mm)",{"$f":"'Sublot 2'!C25","v":" "},null,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$51))","v":""},"","",null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$66),\"\")","v":""},null,null,"# 50 (.300 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 100 (.150 mm)",{"$f":"'Sublot 2'!C26","v":" "},null,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$51))","v":""},"","",null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3]
[null,"# 200 (.075 mm)",{"$f":"'Sublot 2'!C27","v":" "},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$52))","v":""},{"$f":"IF(D27=\"\",\"\",ABS(C27-F28))","v":""},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$68))","v":""},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":{"$error":"#VALUE!"}},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":{"$error":"#VALUE!"}},null,2]
[null," % AC (P5m)",{"$f":"'Sublot 2'!C29","v":" "},null,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":""}]
[null," Corrected %AC",null,null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$53))","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":{"$error":"#VALUE!"}},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":{"$error":"#VALUE!"}},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$69),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$70))","v":""},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$70))","v":""},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$70))","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$71))","v":""}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$54))","v":""},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$72))","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$73))","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$74),Tables!E74))","v":""},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":""},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":""}]
[null," Original Mix (W1m)",null,null,null,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":""},null,null,"Lab Molded Specimen         @ Ndes","# of Gyrations","Specimen Height","LSMG Ratio x LSMG @ Ndes)","% Density (LSMG x 100 / Rice's)"]
[null," Dry Mix (W5m)",null,null,null,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":""}]
[null,null,null,null,null,null,null,null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":6},null,{"$f":"IF(K45=\"\",\"\",ROUND((K46/K45),Tables!$E$59)*ROUND(L46,Tables!$E$60))","v":""},{"$f":"IF(AND(L46<>\"\",OR(K45=\"\",K46=\"\")),\"ERR\",IF(K46=\"\",\"\",ROUND(((L45*100)/$L$24),Tables!$E$61)))","v":""},null,{"$f":"VLOOKUP(O8,GTable,5)","v":85.5}," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":50},null,{"$f":"IF(K46=\"\",\"\",L38)","v":""},{"$f":"IF(K46=\"\",\"\",ROUND(((L46*100)/$L$24),Tables!$E$62))","v":""},null,{"$f":"VLOOKUP(O8,GTable,7)","v":91.5}," Nini Maximum Requirement"]
[null," S.E. No.",null,"1","2",{"$f":"+IF(F48=\"\",\"\",3)","v":""},null,null,{"$f":"(IF(M46=\"\",\"\",IF(OR($M$45=\"ERR\",OR($M45>$O46,$M$45<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""}]
[null," Sand Reading",null,null,null,null,null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Clay Reading",null,null,null,null,null,{"$f":"IF(O49=1,\"OHD L-14\",\"\")","v":""},{"$f":"IF(O49=\"\",\" Avg. Rice Gravity\",\" Max. Theo. at JMF AC\")","v":" Avg. Rice Gravity"},null,null,{"$f":"IF(K58=\"\",\"\",IF(O49=1,ROUND((100/(($C29/$I$13)+(100-$C29)/L25)),Tables!$E$56),$L$24))","v":""},"Gmm",null,null,null,"= 1 if density by PGmm by Pb at JMF in 411 pay table, else leave blank."]
[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,{"$f":"IF(O49=1,\"05/27/08\",\"\")","v":""}," Specimen No."]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",ROUNDUP(MROUND(SUM(D50:F50)/COUNT(D50:F50),0.1),0))","v":""},null,null,null," Station"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O50,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Expressway"]
[null,"DENSITY TEST FOR ROADWAY CORES (OHD L-45)",null,null,null,null,null,null," Lane"]
[null," A (Wt. Dry Spec. in Air)",null,{"$f":"IF(N(K61)>2,K58,\"\")","v":""},{"$f":"IF(N(L61)>2,L58,\"\")","v":""},{"$f":"IF(N(M61)>2,M58,\"\")","v":""},null,null," Thickness (in.)"]
[null," Bag Weight",null,null,null,null,null,null," Initial Wt. Spec. in Air",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(OR(ABS('Sublot 1'!L65-'Sublot 2'!L65)>'Pay Factors'!$B$22,ABS('Sublot 1'!L65-L65)>'Pay Factors'!$B$22),ABS('Sublot 2'!L65-L65)>'Pay Factors'!$B$22),'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}}]
[null," B (Sealed Wt. in Air)",null,{"$f":"IF(D54=\"\",\"\",D54+D55)","v":""},{"$f":"IF(E54=\"\",\"\",E54+E55)","v":""},{"$f":"IF(F54=\"\",\"\",F54+F55)","v":""},null,null," C (Wt. Spec. in Water)",null,null,null,null,null,{"$f":"'Sublot 1'!O56","v":45}," Minimum S.E. Requirement"]
[null," E (Sealed Spec. Wt. in H2O)",null,null,null,null,null,null," B (Wt. Spec. S.S.D.)"]
[null," C (Final Wt. Dry Spec. in Air)",null,null,null,null,null,null," A (Wt. Dry Spec. in Air)"]
[null," F (Bag's Gsa)",null,{"$f":"IF(OR(D58=\"\",D54=\"\"),\"\",IF((D55)>=35,0.8596-((0.00166*D54)/(D55)),IF((D55)<35,0.8121-((0.000566*D54)/(D55)),\"ERR\")))","v":""},{"$f":"IF(OR(E58=\"\",E54=\"\"),\"\",IF((E55)>=35,0.8596-((0.00166*E54)/(E55)),IF((E55)<35,0.8121-((0.000566*E54)/(E55)),\"ERR\")))","v":""},{"$f":"IF(OR(F58=\"\",F54=\"\"),\"\",IF((F55)>=35,0.8596-((0.00166*F54)/(F55)),IF((F55)<35,0.8121-((0.000566*F54)/(F55)),\"ERR\")))","v":""},null,null," B - C",null,{"$f":"IF(K58=\"\",\"\",+K57-K56)","v":""},{"$f":"IF(L58=\"\",\"\",+L57-L56)","v":""},{"$f":"IF(M58=\"\",\"\",+M57-M56)","v":""}]
[null," Core Spec. Grav.  ( Gmb )",null,{"$f":"IF(OR(D54=\"\",D55=\"\"),\"\",ROUND(D54/(D58+D55-D57-(D55)/D59),Tables!$E$37))","v":""},{"$f":"IF(OR(E54=\"\",E55=\"\"),\"\",ROUND(E54/(E58+E55-E57-(E55)/E59),Tables!$E$37))","v":""},{"$f":"IF(OR(F54=\"\",F55=\"\"),\"\",ROUND(F54/(F58+F55-F57-(F55)/F59),Tables!$E$37))","v":""},null,null," Core Spec. Grav.  ( Gmb )",null,{"$f":"IF(K59=\"\",\"\",ROUND((K58/K59),Tables!$E$77))","v":""},{"$f":"IF(L59=\"\",\"\",ROUND((L58/L59),Tables!$E$77))","v":""},{"$f":"IF(M59=\"\",\"\",ROUND((M58/M59),Tables!$E$77))","v":""},null,{"$f":"COUNT(K60:M60)","v":0}," No. of Cores"]
[null,null,null,{"$f":"IF(D58=\"\",\"\",IF(AND(D54-D58<D54*0.0008,D58-D54<=D54*0.0004),\"\",\"REDO\"))","v":""},{"$f":"IF(E58=\"\",\"\",IF(AND(E54-E58<E54*0.0008,E58-E54<=E54*0.0004),\"\",\"REDO\"))","v":""},{"$f":"IF(F58=\"\",\"\",IF(AND(F54-F58<F54*0.0008,F58-F54<=F54*0.0004),\"\",\"REDO\"))","v":""},null,null," % Absorption",null,{"$f":"IF(K56=\"\",\"\",ROUND((K57-K58)/(K57-K56)*100,Tables!$E$78))","v":""},{"$f":"IF(L58=\"\",\"\",ROUND((L57-L58)/(L57-L56)*100,Tables!$E$78))","v":""},{"$f":"IF(M58=\"\",\"\",ROUND((M57-M58)/(M57-M56)*100,Tables!$E$78))","v":""}]
[null,null,null,{"$f":"IF(D60<>\"\",D60,K60)","v":""},{"$f":"IF(E60<>\"\",E60,L60)","v":""},{"$f":"IF(F60<>\"\",F60,M60)","v":""},null,null," Avg. Core Sp. Gr. ( Gmb )",null,null,{"$f":"IF(K60=\"\",\"\",ROUND(AVERAGE(D62:F62),Tables!$E$79))","v":""}]
[null,null,null,null,null,null,null,null," % Roadway Density",null,{"$f":"IF(K64=\"\",\"\",IF(K64=\"L-14\",ROUND(K60/$L$49*100,Tables!$E$80),ROUND(D62/$L$49*100,Tables!$E$80)))","v":""},{"$f":"IF(L64=\"\",\"\",IF(L64=\"L-14\",ROUND(L60/$L$49*100,Tables!$E$80),ROUND(E62/$L$49*100,Tables!$E$80)))","v":""},{"$f":"IF(M64=\"\",\"\",IF(M64=\"L-14\",ROUND(M60/$L$49*100,Tables!$E$80),ROUND(F62/$L$49*100,Tables!$E$80)))","v":""}]
[null,null,null,null,null,null,null,null," Density Test Method",null,{"$f":"IF(K58=\"\",\"\",IF(AND(K61>2,D60>0),\"L-45  \",\"L-14  \"))","v":""},{"$f":"IF(L58=\"\",\"\",IF(AND(L61>2,E60>0),\"L-45  \",\"L-14  \"))","v":""},{"$f":"IF(M58=\"\",\"\",IF(AND(M61>2,F60>0),\"L-45  \",\"L-14  \"))","v":""}]
[null,"Signature / Cert. ID",null,null,"/",null,null,null," % Avg. Roadway Density",null,null,{"$f":"IF(L49=\"\",\"\",IF(L49>0,ROUND(L62/L49*100,Tables!$E$81),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(N(K61)>2,N(L61)>2,N(M61)>2),\"A core absorption is > 2.0%. OHD L-45 is required for it.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L65=\"\",\"\",IF(OR(L65>97,L65<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]

{"sheet":"Sublot 4","index":3,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":false,"merged":[[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[64,8,64,9],[59,1,59,2],[42,8,43,8],[42,9,43,9],[42,10,43,10],[42,11,43,11],[47,8,47,12],[49,8,49,9],[50,8,50,9],[57,8,57,9],[58,8,58,9],[59,8,59,9],[51,8,51,9],[52,8,52,9],[53,8,53,9],[54,8,54,9],[55,8,55,9],[56,8,56,9],[48,8,48,9],[39,8,39,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[40,8,40,9],[42,12,43,12],[48,1,48,2],[49,1,49,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[47,1,47,2],[31,8,31,9],[32,8,32,9],[33,8,33,9],[37,8,37,9],[38,8,38,9],[57,1,57,2],[58,1,58,2],[50,1,50,2],[52,1,52,5],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[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],[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.17"},"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":"PG64"},"    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":""},{"$f":"'Sublot 1'!I11","v":" "},"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",{"$f":"'Sublot 1'!I12","v":" "},"  Gsb from Design",null,null,null,null,"A","    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":""},{"$f":"'Sublot 1'!I13","v":" "},"  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":" "},null,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$51))","v":""},{"$f":"IF(D16=\"\",\"\",100-E16)","v":""},{"$f":"IF(D16=\"\",\"\",ABS(C16-F16))","v":""},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":{"$error":"#VALUE!"}},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":{"$error":"#VALUE!"}},null,0]
[null,"1\" (25.0 mm)",{"$f":"'Sublot 3'!C17","v":" "},null,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D17=\"\",\"\",ABS(C17-F17))","v":""},null," Flask No.",null,null,"|",null,null,"1\" (25.0 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0]
[null,"3/4\" (19.0 mm",{"$f":"'Sublot 3'!C18","v":" "},null,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D18=\"\",\"\",ABS(C18-F18))","v":""},null," Sample Wt.","           (A)  ",null,"|",null,null,"3/4\" (19.0 mm",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0]
[null,"1/2\" (12.5 mm)",{"$f":"'Sublot 3'!C19","v":" "},null,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D19=\"\",\"\",ABS(C19-F19))","v":""},null," Calib. Wt.","           (B)  ",null,"|",null,null,"1/2\" (12.5 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"3/8\" (9.5 mm)",{"$f":"'Sublot 3'!C20","v":" "},null,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$51))","v":""},"","",null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":""},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":""},null,"3/8\" (9.5 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"# 4 ( 4.75 mm)",{"$f":"'Sublot 3'!C21","v":" "},null,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$51))","v":""},"","",null," Sample + Flask + H²O  (D)",null,null,"|",null,null,"# 4 ( 4.75 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"# 8 (2.36 mm)",{"$f":"'Sublot 3'!C22","v":" "},null,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$51))","v":""},"","",null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":""},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":""},null,"# 8 (2.36 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,5]
[null,"# 16 ( 1.18 mm)",{"$f":"'Sublot 3'!C23","v":" "},null,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$51))","v":""},"","",null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$64),\"\")","v":""},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$64),\"\")","v":""},null,"# 16 ( 1.18 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 30 (.600 mm)",{"$f":"'Sublot 3'!C24","v":" "},null,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$51))","v":""},"","",null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$65))","v":""},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 50 (.300 mm)",{"$f":"'Sublot 3'!C25","v":" "},null,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$51))","v":""},"","",null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$66),\"\")","v":""},null,null,"# 50 (.300 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 100 (.150 mm)",{"$f":"'Sublot 3'!C26","v":" "},null,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$51))","v":""},"","",null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3]
[null,"# 200 (.075 mm)",{"$f":"'Sublot 3'!C27","v":" "},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$52))","v":""},{"$f":"IF(D27=\"\",\"\",ABS(C27-F28))","v":""},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$68))","v":""},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":{"$error":"#VALUE!"}},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":{"$error":"#VALUE!"}},null,2]
[null," % AC (P5m)",{"$f":"'Sublot 3'!C29","v":" "},null,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":""}]
[null," Corrected %AC",null,null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$53))","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":{"$error":"#VALUE!"}},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":{"$error":"#VALUE!"}},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$69),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$70))","v":""},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$70))","v":""},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$70))","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$71))","v":""}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$54))","v":""},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$72))","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$73))","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$74),Tables!E74))","v":""},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":""},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":""}]
[null," Original Mix (W1m)",null,null,null,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":""},null,null,"Lab Molded Specimen         @ Ndes","# of Gyrations","Specimen Height","LSMG Ratio x LSMG @ Ndes)","% Density (LSMG x 100 / Rice's)"]
[null," Dry Mix (W5m)",null,null,null,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":""}]
[null,null,null,null,null,null,null,null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":6},null,{"$f":"IF(K45=\"\",\"\",ROUND((K46/K45),Tables!$E$59)*ROUND(L46,Tables!$E$60))","v":""},{"$f":"IF(AND(L46<>\"\",OR(K45=\"\",K46=\"\")),\"ERR\",IF(K46=\"\",\"\",ROUND(((L45*100)/$L$24),Tables!$E$61)))","v":""},null,{"$f":"VLOOKUP(O8,GTable,5)","v":85.5}," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":50},null,{"$f":"IF(K46=\"\",\"\",L38)","v":""},{"$f":"IF(K46=\"\",\"\",ROUND(((L46*100)/$L$24),Tables!$E$62))","v":""},null,{"$f":"VLOOKUP(O8,GTable,7)","v":91.5}," Nini Maximum Requirement"]
[null," S.E. No.",null,"1","2","3",null,null,{"$f":"(IF(M46=\"\",\"\",IF(OR($M$45=\"ERR\",OR($M45>$O46,$M$45<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""}]
[null," Sand Reading",null,null,null,null,null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Clay Reading",null,null,null,null,null,{"$f":"IF(O49=1,\"OHD L-14\",\"\")","v":""},{"$f":"IF(O49=\"\",\" Avg. Rice Gravity\",\" Max. Theo. at JMF AC\")","v":" Avg. Rice Gravity"},null,null,{"$f":"IF(K58=\"\",\"\",IF(O49=1,ROUND((100/(($C29/$I$13)+(100-$C29)/L25)),Tables!$E$56),$L$24))","v":""},"Gmm",null,null,null,"= 1 if density by PGmm by Pb at JMF in 411 pay table, else leave blank."]
[null," Sand Equivalent",null,{"$f":"IF(D49=\"\",\"\",ROUNDUP(D48/D49*100,1))","v":""},{"$f":"IF(E49=\"\",\"\",ROUNDUP(E48/E49*100,Tables!$E$55))","v":""},{"$f":"IF(F49=\"\",\"\",ROUNDUP(F48/F49*100,Tables!$E$55))","v":""},null,{"$f":"IF(O49=1,\"05/27/08\",\"\")","v":""}," Specimen No."]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",AVERAGE(D50:F50))","v":""},null,null,null," Station"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O50,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Expressway"]
[null,"DENSITY TEST FOR ROADWAY CORES (OHD L-45)",null,null,null,null,null,null," Lane"]
[null," A (Wt. Dry Spec. in Air)",null,{"$f":"IF(N(K61)>2,K58,\"\")","v":""},{"$f":"IF(N(L61)>2,L58,\"\")","v":""},{"$f":"IF(N(M61)>2,M58,\"\")","v":""},null,null," Thickness (in.)"]
[null," Bag Weight",null,null,null,null,null,null," Initial Wt. Spec. in Air",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(OR(OR(OR(OR(ABS('Sublot 1'!L65-'Sublot 2'!L65)>'Pay Factors'!$B$22,ABS('Sublot 1'!L65-'Sublot 3'!L65)>'Pay Factors'!$B$22),ABS('Sublot 1'!L65-L65)>'Pay Factors'!$B$22),ABS('Sublot 2'!L65-'Sublot 3'!L65)>'Pay Factors'!$B$22),ABS('Sublot 2'!L65-L65)>'Pay Factors'!$B$22),ABS('Sublot 3'!L65-L65)>'Pay Factors'!$B$22),'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}}]
[null," B (Sealed Wt. in Air)",null,{"$f":"IF(D54=\"\",\"\",D54+D55)","v":""},{"$f":"IF(E54=\"\",\"\",E54+E55)","v":""},{"$f":"IF(F54=\"\",\"\",F54+F55)","v":""},null,null," C (Wt. Spec. in Water)",null,null,null,null,null,{"$f":"'Sublot 1'!O56","v":45}," Minimum S.E. Requirement"]
[null," E (Sealed Spec. Wt. in H2O)",null,null,null,null,null,null," B (Wt. Spec. S.S.D.)"]
[null," C (Final Wt. Dry Spec. in Air)",null,null,null,null,null,null," A (Wt. Dry Spec. in Air)"]
[null," F (Bag's Gsa)",null,{"$f":"IF(OR(D58=\"\",D54=\"\"),\"\",IF((D55)>=35,0.8596-((0.00166*D54)/(D55)),IF((D55)<35,0.8121-((0.000566*D54)/(D55)),\"ERR\")))","v":""},{"$f":"IF(OR(E58=\"\",E54=\"\"),\"\",IF((E55)>=35,0.8596-((0.00166*E54)/(E55)),IF((E55)<35,0.8121-((0.000566*E54)/(E55)),\"ERR\")))","v":""},{"$f":"IF(OR(F58=\"\",F54=\"\"),\"\",IF((F55)>=35,0.8596-((0.00166*F54)/(F55)),IF((F55)<35,0.8121-((0.000566*F54)/(F55)),\"ERR\")))","v":""},null,null," B - C",null,{"$f":"IF(K58=\"\",\"\",+K57-K56)","v":""},{"$f":"IF(L58=\"\",\"\",+L57-L56)","v":""},{"$f":"IF(M58=\"\",\"\",+M57-M56)","v":""}]
[null," Core Spec. Grav.  ( Gmb )",null,{"$f":"IF(OR(D54=\"\",D55=\"\"),\"\",ROUND(D54/(D58+D55-D57-(D55)/D59),Tables!$E$37))","v":""},{"$f":"IF(OR(E54=\"\",E55=\"\"),\"\",ROUND(E54/(E58+E55-E57-(E55)/E59),Tables!$E$37))","v":""},{"$f":"IF(OR(F54=\"\",F55=\"\"),\"\",ROUND(F54/(F58+F55-F57-(F55)/F59),Tables!$E$37))","v":""},null,null," Core Spec. Grav.  ( Gmb )",null,{"$f":"IF(K59=\"\",\"\",ROUND((K58/K59),Tables!$E$77))","v":""},{"$f":"IF(L59=\"\",\"\",ROUND((L58/L59),Tables!$E$77))","v":""},{"$f":"IF(M59=\"\",\"\",ROUND((M58/M59),Tables!$E$77))","v":""},null,{"$f":"COUNT(K60:M60)","v":0}," No. of Cores"]
[null,null,null,{"$f":"IF(D58=\"\",\"\",IF(AND(D54-D58<D54*0.0008,D58-D54<=D54*0.0004),\"\",\"REDO\"))","v":""},{"$f":"IF(E58=\"\",\"\",IF(AND(E54-E58<E54*0.0008,E58-E54<=E54*0.0004),\"\",\"REDO\"))","v":""},{"$f":"IF(F58=\"\",\"\",IF(AND(F54-F58<F54*0.0008,F58-F54<=F54*0.0004),\"\",\"REDO\"))","v":""},null,null," % Absorption",null,{"$f":"IF(K56=\"\",\"\",ROUND((K57-K58)/(K57-K56)*100,Tables!$E$78))","v":""},{"$f":"IF(L58=\"\",\"\",ROUND((L57-L58)/(L57-L56)*100,Tables!$E$78))","v":""},{"$f":"IF(M58=\"\",\"\",ROUND((M57-M58)/(M57-M56)*100,Tables!$E$78))","v":""}]
[null,null,null,{"$f":"IF(D60<>\"\",D60,K60)","v":""},{"$f":"IF(E60<>\"\",E60,L60)","v":""},{"$f":"IF(F60<>\"\",F60,M60)","v":""},null,null," Avg. Core Sp. Gr. ( Gmb )",null,null,{"$f":"IF(K60=\"\",\"\",ROUND(AVERAGE(D62:F62),Tables!$E$79))","v":""}]
[null,null,null,null,null,null,null,null," % Roadway Density",null,{"$f":"IF(K64=\"\",\"\",IF(K64=\"L-14\",ROUND(K60/$L$49*100,Tables!$E$80),ROUND(D62/$L$49*100,Tables!$E$80)))","v":""},{"$f":"IF(L64=\"\",\"\",IF(L64=\"L-14\",ROUND(L60/$L$49*100,Tables!$E$80),ROUND(E62/$L$49*100,Tables!$E$80)))","v":""},{"$f":"IF(M64=\"\",\"\",IF(M64=\"L-14\",ROUND(M60/$L$49*100,Tables!$E$80),ROUND(F62/$L$49*100,Tables!$E$80)))","v":""}]
[null,null,null,null,null,null,null,null," Density Test Method",null,{"$f":"IF(K58=\"\",\"\",IF(AND(K61>2,D60>0),\"L-45  \",\"L-14  \"))","v":""},{"$f":"IF(L58=\"\",\"\",IF(AND(L61>2,E60>0),\"L-45  \",\"L-14  \"))","v":""},{"$f":"IF(M58=\"\",\"\",IF(AND(M61>2,F60>0),\"L-45  \",\"L-14  \"))","v":""}]
[null,"Signature / Cert. ID",null,null,"/",null,null,null," % Avg. Roadway Density",null,null,{"$f":"IF(L49=\"\",\"\",IF(L49>0,ROUND(L62/L49*100,Tables!$E$81),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(N(K61)>2,N(L61)>2,N(M61)>2),\"A core absorption is > 2.0%. OHD L-45 is required for it.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L65=\"\",\"\",IF(OR(L65>97,L65<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]

{"sheet":"Sublot 5","index":4,"n_rows":67,"n_cols":32,"rows_kept":67,"cut":false,"hidden":false,"merged":[[61,8,61,9],[62,8,62,9],[63,8,63,9],[64,8,64,9],[42,10,43,10],[42,9,43,9],[56,8,56,9],[57,8,57,9],[58,8,58,9],[59,8,59,9],[42,11,43,11],[42,12,43,12],[47,8,47,12],[60,8,60,9],[37,8,37,9],[38,8,38,9],[55,8,55,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[53,8,53,9],[54,8,54,9],[40,8,40,9],[39,8,39,9],[42,8,43,8],[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],[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],[49,1,49,2],[48,8,48,9],[50,1,50,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[52,1,52,5],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2]]}
[{"$f":"'Sublot 1'!A1","v":"v 1.17"},"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":"PG64"},"    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":""},{"$f":"'Sublot 1'!I11","v":" "},"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",{"$f":"'Sublot 1'!I12","v":" "},"  Gsb from Design",null,null,null,null,"A","    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":""},{"$f":"'Sublot 1'!I13","v":" "},"  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":" "},null,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$51))","v":""},{"$f":"IF(D16=\"\",\"\",100-E16)","v":""},{"$f":"IF(D16=\"\",\"\",ABS(C16-F16))","v":""},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":{"$error":"#VALUE!"}},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":{"$error":"#VALUE!"}},null,0]
[null,"1\" (25.0 mm)",{"$f":"'Sublot 4'!C17","v":" "},null,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D17=\"\",\"\",ABS(C17-F17))","v":""},null," Flask No.",null,null,"|",null,null,"1\" (25.0 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0]
[null,"3/4\" (19.0 mm",{"$f":"'Sublot 4'!C18","v":" "},null,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D18=\"\",\"\",ABS(C18-F18))","v":""},null," Sample Wt.","           (A)  ",null,"|",null,null,"3/4\" (19.0 mm",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0]
[null,"1/2\" (12.5 mm)",{"$f":"'Sublot 4'!C19","v":" "},null,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$51))","v":""},"",{"$f":"IF(D19=\"\",\"\",ABS(C19-F19))","v":""},null," Calib. Wt.","           (B)  ",null,"|",null,null,"1/2\" (12.5 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"3/8\" (9.5 mm)",{"$f":"'Sublot 4'!C20","v":" "},null,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$51))","v":""},"","",null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":""},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":""},null,"3/8\" (9.5 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"# 4 ( 4.75 mm)",{"$f":"'Sublot 4'!C21","v":" "},null,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$51))","v":""},"","",null," Sample + Flask + H²O  (D)",null,null,"|",null,null,"# 4 ( 4.75 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7]
[null,"# 8 (2.36 mm)",{"$f":"'Sublot 4'!C22","v":" "},null,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$51))","v":""},"","",null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":""},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":""},null,"# 8 (2.36 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,5]
[null,"# 16 ( 1.18 mm)",{"$f":"'Sublot 4'!C23","v":" "},null,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$51))","v":""},"","",null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$64),\"\")","v":""},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$64),\"\")","v":""},null,"# 16 ( 1.18 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 30 (.600 mm)",{"$f":"'Sublot 4'!C24","v":" "},null,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$51))","v":""},"","",null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$65))","v":""},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 50 (.300 mm)",{"$f":"'Sublot 4'!C25","v":" "},null,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$51))","v":""},"","",null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$66),\"\")","v":""},null,null,"# 50 (.300 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4]
[null,"# 100 (.150 mm)",{"$f":"'Sublot 4'!C26","v":" "},null,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$51))","v":""},"","",null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3]
[null,"# 200 (.075 mm)",{"$f":"'Sublot 4'!C27","v":" "},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$52))","v":""},{"$f":"IF(D27=\"\",\"\",ABS(C27-F28))","v":""},null," New Gsb  ( calculated )",null,null,{"$f":"IF(L25=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$68))","v":""},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":{"$error":"#VALUE!"}},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":{"$error":"#VALUE!"}},null,2]
[null," % AC (P5m)",{"$f":"'Sublot 4'!C29","v":" "},null,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":""}]
[null," Corrected %AC",null,null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$53))","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":{"$error":"#VALUE!"}},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":{"$error":"#VALUE!"}},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$69),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$70))","v":""},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$70))","v":""},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$70))","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$71))","v":""}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$54))","v":""},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$72))","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$73))","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$74),Tables!E74))","v":""},{"$f":"IF(L41=\"\",\"\",IF(L41<O41,\"ERR\",\"\"))","v":""},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":""}]
[null," Original Mix (W1m)",null,null,null,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":""},null,null,"Lab Molded Specimen         @ Ndes","# of Gyrations","Specimen Height","LSMG Ratio x LSMG @ Ndes)","% Density (LSMG x 100 / Rice's)"]
[null," Dry Mix (W5m)",null,null,null,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":""}]
[null,null,null,null,null,null,null,null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":6},null,{"$f":"IF(K45=\"\",\"\",ROUND((K46/K45),Tables!$E$59)*ROUND(L46,Tables!$E$60))","v":""},{"$f":"IF(AND(L46<>\"\",OR(K45=\"\",K46=\"\")),\"ERR\",IF(K46=\"\",\"\",ROUND(((L45*100)/$L$24),Tables!$E$61)))","v":""},null,{"$f":"VLOOKUP(O8,GTable,5)","v":85.5}," Nini Minimun Requirement"]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":50},null,{"$f":"IF(K46=\"\",\"\",L38)","v":""},{"$f":"IF(K46=\"\",\"\",ROUND(((L46*100)/$L$24),Tables!$E$62))","v":""},null,{"$f":"VLOOKUP(O8,GTable,7)","v":91.5}," Nini Maximum Requirement"]
[null," S.E. No.",null,"1","2",{"$f":"+IF(F48=\"\",\"\",3)","v":""},null,null,{"$f":"(IF(M46=\"\",\"\",IF(OR($M$45=\"ERR\",OR($M45>$O46,$M$45<$O$45)),\"  Fails Nini Requirements\",\"\")))","v":""}]
[null," Sand Reading",null,null,null,null,null,null,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Clay Reading",null,null,null,null,null,{"$f":"IF(O49=1,\"OHD L-14\",\"\")","v":""},{"$f":"IF(O49=\"\",\" Avg. Rice Gravity\",\" Max. Theo. at JMF AC\")","v":" Avg. Rice Gravity"},null,null,{"$f":"IF(K58=\"\",\"\",IF(O49=1,ROUND((100/(($C29/$I$13)+(100-$C29)/L25)),Tables!$E$56),$L$24))","v":""},"Gmm",null,null,null,"= 1 if density by PGmm by Pb at JMF in 411 pay table, else leave blank."]
[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,{"$f":"IF(O49=1,\"05/27/08\",\"\")","v":""}," Specimen No."]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",ROUNDUP(MROUND(SUM(D50:F50)/COUNT(D50:F50),0.1),0))","v":""},null,null,null," Station"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O50,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Expressway"]
[null,"DENSITY TEST FOR ROADWAY CORES (OHD L-45)",null,null,null,null,null,null," Lane"]
[null," A (Wt. Dry Spec. in Air)",null,{"$f":"IF(N(K61)>2,K58,\"\")","v":""},{"$f":"IF(N(L61)>2,L58,\"\")","v":""},{"$f":"IF(N(M61)>2,M58,\"\")","v":""},null,null," Thickness (in.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"1-2","1-3","1-4","1-5","2-3","2-4","2-5","3-4","3-5","4-5"]
[null," Bag Weight",null,null,null,null,null,null," Initial Wt. Spec. in Air",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(W55:AF55)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(ABS('Sublot 1'!L65-'Sublot 2'!L65)>'Pay Factors'!$B$22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS('Sublot 1'!L65-'Sublot 3'!L65)>'Pay Factors'!$B$22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS('Sublot 1'!L65-'Sublot 4'!L65)>'Pay Factors'!$B$22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS('Sublot 1'!L65-'Sublot 5'!L65)>'Pay Factors'!$B$22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS('Sublot 2'!L65-'Sublot 3'!L65)>'Pay Factors'!$B$22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS('Sublot 2'!L65-'Sublot 4'!L65)>'Pay Factors'!$B$22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS('Sublot 2'!L65-'Sublot 5'!L65)>'Pay Factors'!$B$22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS('Sublot 3'!L65-'Sublot 4'!L65)>'Pay Factors'!$B$22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS('Sublot 3'!L65-'Sublot 5'!L65)>'Pay Factors'!$B$22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS('Sublot 4'!L65-'Sublot 5'!L65)>'Pay Factors'!$B$22,'Pay Factors'!$CS$55,0)","v":{"$error":"#VALUE!"}}]
[null," B (Sealed Wt. in Air)",null,{"$f":"IF(D54=\"\",\"\",D54+D55)","v":""},{"$f":"IF(E54=\"\",\"\",E54+E55)","v":""},{"$f":"IF(F54=\"\",\"\",F54+F55)","v":""},null,null," C (Wt. Spec. in Water)",null,null,null,null,null,{"$f":"'Sublot 1'!O56","v":45}," Minimum S.E. Requirement"]
[null," E (Sealed Spec. Wt. in H2O)",null,null,null,null,null,null," B (Wt. Spec. S.S.D.)"]
[null," C (Final Wt. Dry Spec. in Air)",null,null,null,null,null,null," A (Wt. Dry Spec. in Air)"]
[null," F (Bag's Gsa)",null,{"$f":"IF(OR(D58=\"\",D54=\"\"),\"\",IF((D55)>=35,0.8596-((0.00166*D54)/(D55)),IF((D55)<35,0.8121-((0.000566*D54)/(D55)),\"ERR\")))","v":""},{"$f":"IF(OR(E58=\"\",E54=\"\"),\"\",IF((E55)>=35,0.8596-((0.00166*E54)/(E55)),IF((E55)<35,0.8121-((0.000566*E54)/(E55)),\"ERR\")))","v":""},{"$f":"IF(OR(F58=\"\",F54=\"\"),\"\",IF((F55)>=35,0.8596-((0.00166*F54)/(F55)),IF((F55)<35,0.8121-((0.000566*F54)/(F55)),\"ERR\")))","v":""},null,null," B - C",null,{"$f":"IF(K58=\"\",\"\",+K57-K56)","v":""},{"$f":"IF(L58=\"\",\"\",+L57-L56)","v":""},{"$f":"IF(M58=\"\",\"\",+M57-M56)","v":""}]
[null," Core Spec. Grav.  ( Gmb )",null,{"$f":"IF(OR(D54=\"\",D55=\"\"),\"\",ROUND(D54/(D58+D55-D57-(D55)/D59),Tables!$E$37))","v":""},{"$f":"IF(OR(E54=\"\",E55=\"\"),\"\",ROUND(E54/(E58+E55-E57-(E55)/E59),Tables!$E$37))","v":""},{"$f":"IF(OR(F54=\"\",F55=\"\"),\"\",ROUND(F54/(F58+F55-F57-(F55)/F59),Tables!$E$37))","v":""},null,null," Core Spec. Grav.  ( Gmb )",null,{"$f":"IF(K59=\"\",\"\",ROUND((K58/K59),Tables!$E$77))","v":""},{"$f":"IF(L59=\"\",\"\",ROUND((L58/L59),Tables!$E$77))","v":""},{"$f":"IF(M59=\"\",\"\",ROUND((M58/M59),Tables!$E$77))","v":""},null,{"$f":"COUNT(K60:M60)","v":0}," No. of Cores"]
[null,null,null,{"$f":"IF(D58=\"\",\"\",IF(AND(D54-D58<D54*0.0008,D58-D54<=D54*0.0004),\"\",\"REDO\"))","v":""},{"$f":"IF(E58=\"\",\"\",IF(AND(E54-E58<E54*0.0008,E58-E54<=E54*0.0004),\"\",\"REDO\"))","v":""},{"$f":"IF(F58=\"\",\"\",IF(AND(F54-F58<F54*0.0008,F58-F54<=F54*0.0004),\"\",\"REDO\"))","v":""},null,null," % Absorption",null,{"$f":"IF(K56=\"\",\"\",ROUND((K57-K58)/(K57-K56)*100,Tables!$E$78))","v":""},{"$f":"IF(L58=\"\",\"\",ROUND((L57-L58)/(L57-L56)*100,Tables!$E$78))","v":""},{"$f":"IF(M58=\"\",\"\",ROUND((M57-M58)/(M57-M56)*100,Tables!$E$78))","v":""}]
[null,null,null,{"$f":"IF(D60<>\"\",D60,K60)","v":""},{"$f":"IF(E60<>\"\",E60,L60)","v":""},{"$f":"IF(F60<>\"\",F60,M60)","v":""},null,null," Avg. Core Sp. Gr. ( Gmb )",null,null,{"$f":"IF(K60=\"\",\"\",ROUND(AVERAGE(D62:F62),Tables!$E$79))","v":""}]
[null,null,null,null,null,null,null,null," % Roadway Density",null,{"$f":"IF(K64=\"\",\"\",IF(K64=\"L-14\",ROUND(K60/$L$49*100,Tables!$E$80),ROUND(D62/$L$49*100,Tables!$E$80)))","v":""},{"$f":"IF(L64=\"\",\"\",IF(L64=\"L-14\",ROUND(L60/$L$49*100,Tables!$E$80),ROUND(E62/$L$49*100,Tables!$E$80)))","v":""},{"$f":"IF(M64=\"\",\"\",IF(M64=\"L-14\",ROUND(M60/$L$49*100,Tables!$E$80),ROUND(F62/$L$49*100,Tables!$E$80)))","v":""}]
[null,null,null,null,null,null,null,null," Density Test Method",null,{"$f":"IF(K58=\"\",\"\",IF(AND(K61>2,D60>0),\"L-45  \",\"L-14  \"))","v":""},{"$f":"IF(L58=\"\",\"\",IF(AND(L61>2,E60>0),\"L-45  \",\"L-14  \"))","v":""},{"$f":"IF(M58=\"\",\"\",IF(AND(M61>2,F60>0),\"L-45  \",\"L-14  \"))","v":""}]
[null,"Signature / Cert. ID",null,null,"/",null,null,null," % Avg. Roadway Density",null,null,{"$f":"IF(L49=\"\",\"\",IF(L49>0,ROUND(L62/L49*100,Tables!$E$81),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(N(K61)>2,N(L61)>2,N(M61)>2),\"A core absorption is > 2.0%. OHD L-45 is required for it.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L65=\"\",\"\",IF(OR(L65>97,L65<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]

{"sheet":"Pay Factors","index":5,"n_rows":243,"n_cols":126,"rows_kept":243,"cut":false,"hidden":false,"merged":[[12,19,12,20],[11,19,11,20],[0,9,0,22],[2,1,2,3],[4,1,4,4],[2,10,2,14],[1,8,1,22],[2,8,2,9],[3,8,3,9],[4,8,4,9],[11,15,11,16],[11,17,11,18],[12,17,12,18],[48,11,48,12],[48,13,48,14],[4,10,4,14],[2,16,2,18],[43,9,43,12],[12,11,12,12],[12,13,12,14],[11,11,11,12],[11,13,11,14],[12,9,12,10],[10,9,10,10],[6,8,6,22],[4,15,4,16],[4,17,4,21],[12,15,12,16],[2,20,2,21],[45,15,45,16],[45,17,45,18],[44,15,44,16],[44,17,44,18],[22,1,22,5],[21,2,21,5],[19,2,19,4],[26,2,26,5],[46,13,46,14],[44,11,44,12],[44,13,44,14],[45,11,45,12],[45,13,45,14],[46,11,46,12],[32,8,32,10],[35,8,35,10],[38,8,38,10],[33,9,33,11],[36,9,36,11],[39,9,39,11],[46,17,46,18],[48,15,48,16],[69,64,69,65],[52,52,52,54],[60,64,60,65],[48,17,48,18],[64,17,64,18],[47,15,47,16],[46,15,46,16],[29,21,29,22],[32,21,32,22],[35,21,35,22],[38,21,38,22],[70,64,70,65],[61,64,61,65]]}
[null,null,null,null,null,null,null,null,{"$f":"'Sublot 1'!A1","v":"v 1.17"},"OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
[null,null,null,null,null,null,null,null,{"$f":"'Sublot 1'!G8 & \" - ASPHALT CONCRETE PAVING\"","v":" - ASPHALT CONCRETE PAVING"}]
[null,null,null,null,null,null,null,null,"PROJECT  NO: ",null,{"$f":"IF('Sublot 1'!B6=\"\",\"\",'Sublot 1'!B6)","v":""},null,null,null,null,"COUNTY:",null,null,null,"DATE:"]
[]
[null,null,null,null,null,null,null,null,"CONTRACTOR: ",null,{"$f":"IF('Sublot 1'!B7=\"\",\"\",'Sublot 1'!B7)","v":""},null,null,null,null,"ASPHALT  DESIGN  NO:",null,{"$f":"IF('Sublot 1'!L8=\"\",\"\",'Sublot 1'!L8)","v":""}]
[]
[null,null,null,null,null,null,null,null,"250 TON - 1000 TON  =  ONE SUBLOT          4,000 TON  =  ONE LOT"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOT NO. ",{"$f":"'Sublot 1'!E13","v":1}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF('Sublot 5'!D29>0,5,IF('Sublot 4'!D29>0,4,IF('Sublot 3'!D29>0,3,IF('Sublot 2'!D29>0,2,1))))","v":1},"SUBLOTS",null,"    Total Tons",{"$f":"'Sublot 1'!I10","v":0},"    Total Tons",{"$f":"'Sublot 2'!I10","v":0},"    Total Tons",{"$f":"'Sublot 3'!I10","v":0},"    Total Tons",{"$f":"'Sublot 4'!I10","v":0},"    Total Tons",{"$f":"'Sublot 5'!I10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Sublot 1'!E12=\"\",\"\",'Sublot 1'!E12)","v":""},null,{"$f":"IF('Sublot 2'!E12=\"\",\"\",'Sublot 2'!E12)","v":""},null,{"$f":"IF('Sublot 3'!E12=\"\",\"\",'Sublot 3'!E12)","v":""},null,{"$f":"IF('Sublot 4'!E12=\"\",\"\",'Sublot 4'!E12)","v":""},null,{"$f":"IF('Sublot 5'!E12=\"\",\"\",'Sublot 5'!E12)","v":""}]
[null,null,null,null,null,null,null,null,null,"SAMPLE ID",null,{"$f":"IF('Sublot 1'!B8=\"\",\"\",'Sublot 1'!B8)","v":""},null,{"$f":"IF('Sublot 2'!B8=\"\",\"\",'Sublot 2'!B8)","v":""},null,{"$f":"IF('Sublot 3'!B8=\"\",\"\",'Sublot 3'!B8)","v":""},null,{"$f":"IF('Sublot 4'!B8=\"\",\"\",'Sublot 4'!B8)","v":""},null,{"$f":"IF('Sublot 5'!B8=\"\",\"\",'Sublot 5'!B8)","v":""}]
[null,"             TAB RIGHT",null,null,null,null,null,null,"SIEVE","   SPEC.",null,"SUBLOT","DEVIA.","SUBLOT","DEVIA.","SUBLOT","DEVIA.","SUBLOT","DEVIA.","SUBLOT","DEVIA.","AVG.","FACTOR"]
[null,null,null,null,null,null,null,null,"SIZE",null,null,{"$f":"'Sublot 1'!$G$13","v":1},null,{"$f":"'Sublot 2'!$G$13","v":2},null,{"$f":"'Sublot 3'!$G$13","v":3},null,{"$f":"'Sublot 4'!$G$13","v":4},null,{"$f":"'Sublot 5'!$G$13","v":5},null," DEV."]
[null,null,null,null,null,null,null,null,"AGGR."]
[null,null,null,null,null,null,{"$f":"'Sublot 1'!C16","v":" "},null,"1-1/2",{"$f":"IF(G17=\"\",\"\",+G17)","v":" "},null,{"$f":"'Sublot 1'!F16","v":""},{"$f":"IF(L17=\"\",0,ABS($G17-L17))","v":0},{"$f":"'Sublot 2'!F16","v":""},{"$f":"IF(N17=\"\",0,ABS($G17-N17))","v":0},{"$f":"'Sublot 3'!F16","v":""},{"$f":"IF(P17=\"\",0,ABS($G17-P17))","v":0},{"$f":"'Sublot 4'!F16","v":""},{"$f":"IF(R17=\"\",0,ABS($G17-R17))","v":0},{"$f":"'Sublot 5'!F16","v":""},{"$f":"IF(T17=\"\",0,ABS($G17-T17))","v":0},{"$f":"ROUND((M17+O17+Q17+S17+U17)/$I$11,2)","v":0},{"$f":"IF(AND(V17>=$BO$51,V17<=$BP$51),$BR$51,IF(AND(V17>=$BO$52,V17<=$BP$52),$BQ$52-($BS$52*V17),IF(AND(V17>=$BO$53,V17<=$BP$53),$BQ$53-($BS$53*V17),IF(V17>$BP$54,$BR$54,\"\"))))","v":1}]
[null,null,null,null,null,null,{"$f":"'Sublot 1'!C17","v":" "},null,"1"," ",null,{"$f":"'Sublot 1'!F17","v":""},0,{"$f":"'Sublot 2'!F17","v":""},0,{"$f":"'Sublot 3'!F17","v":""},{"$f":"IF(P18=\"\",0,ABS($G18-P18))","v":0},{"$f":"'Sublot 4'!F17","v":""},0,{"$f":"'Sublot 5'!F17","v":""},0,{"$f":"ROUND((M18+O18+Q18+S18+U18)/$I$11,2)","v":0},1]
[null,null,null,null,null,null,{"$f":"'Sublot 1'!C18","v":" "},null,"3/4"," ",null,{"$f":"'Sublot 1'!F18","v":""},0,{"$f":"'Sublot 2'!F18","v":""},0,{"$f":"'Sublot 3'!F18","v":""},0,{"$f":"'Sublot 4'!F18","v":""},0,{"$f":"'Sublot 5'!F18","v":""},0,0,1]
[null,33.450000000000003,"   CUP (Contract Unit Price)",null,null,null,{"$f":"'Sublot 1'!C19","v":" "},null,"1/2"," ",null,{"$f":"'Sublot 1'!F19","v":""},0,{"$f":"'Sublot 2'!F19","v":""},0,{"$f":"'Sublot 3'!F19","v":""},0,{"$f":"'Sublot 4'!F19","v":""},0,{"$f":"'Sublot 5'!F19","v":""},0,0,1]
[null,null,null,null,null,null,{"$f":"'Sublot 1'!C20","v":" "},null,"3/8"," ",null,{"$f":"'Sublot 1'!F20","v":""},0,{"$f":"'Sublot 2'!F20","v":""},0,{"$f":"'Sublot 3'!F20","v":""},0,{"$f":"'Sublot 4'!F20","v":""},0,{"$f":"'Sublot 5'!F20","v":""},0,0,1]
[null,4,"  %  AVERAGE DENSITY REQUIREMENT:",null,null,null,{"$f":"'Sublot 1'!C21","v":" "},null,"4"," ",null,{"$f":"'Sublot 1'!F21","v":""},0,{"$f":"'Sublot 2'!F21","v":""},0,{"$f":"'Sublot 3'!F21","v":""},0,{"$f":"'Sublot 4'!F21","v":""},0,{"$f":"'Sublot 5'!F21","v":""},0,0,1]
[null,"Enter 4.0  for New Const. or 5.0  for Resurfacing",null,null,null,null,{"$f":"'Sublot 1'!C22","v":" "},null,"8"," ",null,{"$f":"'Sublot 1'!F22","v":""},0,{"$f":"'Sublot 2'!F22","v":""},0,{"$f":"'Sublot 3'!F22","v":""},0,{"$f":"'Sublot 4'!F22","v":""},0,{"$f":"'Sublot 5'!F22","v":""},0,0,{"$f":"IF(AND(V23>=$BO$60,V23<=$BP$60),$BR$60,IF(AND(V23>=$BO$61,V23<=$BP$61),$BQ$61-($BS$61*V23),IF(AND(V23>=$BO$62,V23<=$BP$62),$BQ$62-($BS$62*V23),IF(V23>$BP$63,$BR$63,\"\"))))","v":1}]
[null,null,null,null,null,null,{"$f":"'Sublot 1'!C23","v":" "},null,"16"," ",null,{"$f":"'Sublot 1'!F23","v":""},0,{"$f":"'Sublot 2'!F23","v":""},0,{"$f":"'Sublot 3'!F23","v":""},0,{"$f":"'Sublot 4'!F23","v":""},0,{"$f":"'Sublot 5'!F23","v":""},0,0,{"$f":"IF(AND(V24>=$BO$60,V24<=$BP$60),$BR$60,IF(AND(V24>=$BO$61,V24<=$BP$61),$BQ$61-($BS$61*V24),IF(AND(V24>=$BO$62,V24<=$BP$62),$BQ$62-($BS$62*V24),IF(V24>$BP$63,$BR$63,\"\"))))","v":1}]
[null,{"$f":"IF('Sublot 1'!O40=\"\",\"\",'Sublot 1'!O40)","v":4},"  Enter Air Voids Target",null,null,null,{"$f":"'Sublot 1'!C24","v":" "},null,"30"," ",null,{"$f":"'Sublot 1'!F24","v":""},0,{"$f":"'Sublot 2'!F24","v":""},0,{"$f":"'Sublot 3'!F24","v":""},0,{"$f":"'Sublot 4'!F24","v":""},0,{"$f":"'Sublot 5'!F24","v":""},0,0,{"$f":"IF(AND(V25>=$BO$60,V25<=$BP$60),$BR$60,IF(AND(V25>=$BO$61,V25<=$BP$61),$BQ$61-($BS$61*V25),IF(AND(V25>=$BO$62,V25<=$BP$62),$BQ$62-($BS$62*V25),IF(V25>$BP$63,$BR$63,\"\"))))","v":1}]
[null,null,null,null,null,null,{"$f":"'Sublot 1'!C25","v":" "},null,"50"," ",null,{"$f":"'Sublot 1'!F25","v":""},0,{"$f":"'Sublot 2'!F25","v":""},0,{"$f":"'Sublot 3'!F25","v":""},0,{"$f":"'Sublot 4'!F25","v":""},0,{"$f":"'Sublot 5'!F25","v":""},0,0,{"$f":"IF(AND(V26>=$BO$60,V26<=$BP$60),$BR$60,IF(AND(V26>=$BO$61,V26<=$BP$61),$BQ$61-($BS$61*V26),IF(AND(V26>=$BO$62,V26<=$BP$62),$BQ$62-($BS$62*V26),IF(V26>$BP$63,$BR$63,\"\"))))","v":1}]
[null,{"$f":"100-'Sublot 1'!O40-2","v":94},"  Enter Roadway Density Target",null,null,null,{"$f":"'Sublot 1'!C26","v":" "},null,"100"," ",null,{"$f":"'Sublot 1'!F26","v":""},0,{"$f":"'Sublot 2'!F26","v":""},0,{"$f":"'Sublot 3'!F26","v":""},0,{"$f":"'Sublot 4'!F26","v":""},0,{"$f":"'Sublot 5'!F26","v":""},0,0,{"$f":"IF(AND(V27>=$BO$60,V27<=$BP$60),$BR$60,IF(AND(V27>=$BO$61,V27<=$BP$61),$BQ$61-($BS$61*V27),IF(AND(V27>=$BO$62,V27<=$BP$62),$BQ$62-($BS$62*V27),IF(V27>$BP$63,$BR$63,\"\"))))","v":1}]
[null,null,null,null,null,null,{"$f":"'Sublot 1'!C27","v":" "},null,"200"," ",null,{"$f":"'Sublot 1'!F28","v":""},0,{"$f":"'Sublot 2'!F28","v":""},0,{"$f":"'Sublot 3'!F28","v":""},0,{"$f":"'Sublot 4'!F28","v":""},0,{"$f":"'Sublot 5'!F28","v":""},0,0,{"$f":"IF(AND(V28>=$BO$69,V28<=$BP$69),$BR$69,IF(AND(V28>=$BO$70,V28<=$BP$70),$BQ$70-($BS$70*V28),IF(AND(V28>=$BO$71,V28<=$BP$71),$BQ$71-($BS$71*V28),IF(V28>$BP$72,$BR$72,\"\"))))","v":1}]
[null,"%Average Density, Air Voids, & Roadway Density"]
[null,"Target must be obtained from the Special Provisions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACTOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(W17:W28)","v":1}]
[]
[null,null,null,null,null,null,{"$f":"'Sublot 1'!C29","v":" "},null,"      A/C  CONTENT ",null,null,{"$f":"'Sublot 1'!F30","v":""},{"$f":"IF(L33=\"\",0,ABS($G$33-L33))","v":0},{"$f":"'Sublot 2'!F30","v":""},{"$f":"IF(N33=\"\",0,ABS($G$33-N33))","v":0},{"$f":"'Sublot 3'!F30","v":""},{"$f":"IF(P33=\"\",0,ABS($G$33-P33))","v":0},{"$f":"'Sublot 4'!F30","v":""},{"$f":"IF(R33=\"\",0,ABS($G$33-R33))","v":0},{"$f":"'Sublot 5'!F30","v":""},{"$f":"IF(T33=\"\",0,ABS($G$33-T33))","v":0},"FACTOR"]
[null,null,null,null,null,null,null,null,{"$f":"G33","v":" "}," TOTAL  AVG.  DEVIATION",null,null,{"$f":"ROUND(SUM(M33+O33+Q33+S33+U33)/$I$11,2)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M34>=$BD$51,M34<=$BE$51),$BG$51,IF(AND(M34>=$BD$52,M34<=$BE$52),$BF$52-M34,IF(AND(M34>=$BD$53,M34<=$BE$53),$BF$53-($BH$53*M34),IF(M34>$BE$54,$BG$54,\"\"))))","v":1}]
[]
[null,null,null,null,null,null,{"$f":"B25","v":4},null,"      AIR  VOIDS",null,null,{"$f":"'Sublot 1'!L40","v":""},{"$f":"IF(L36=\"\",0,ABS($G$36-L36))","v":0},{"$f":"'Sublot 2'!L40","v":""},{"$f":"IF(N36=\"\",0,ABS($G$36-N36))","v":0},{"$f":"'Sublot 3'!L40","v":""},{"$f":"IF(P36=\"\",0,ABS($G$36-P36))","v":0},{"$f":"'Sublot 4'!L40","v":""},{"$f":"IF(R36=\"\",0,ABS($G$36-R36))","v":0},{"$f":"'Sublot 5'!L40","v":""},{"$f":"IF(T36=\"\",0,ABS($G$36-T36))","v":0},"FACTOR"]
[null,null,null,null,null,null,null,null,{"$f":"G36","v":4}," TOTAL  AVG.  DEVIATION",null,null,{"$f":"ROUND(SUM(M36+O36+Q36+S36+U36)/$I$11,2)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M37>=$BZ$51,M37<=$CA$51),$CE$51,IF(AND(M37>=$BZ$52,M37<=$CA$52),($CB$52*(M37*M37))+($CE$52*M37)-$CG$52,IF(M37>$CA$53,$CE$53,\"\")))","v":1}]
[]
[null,null,null,null,null,null,{"$f":"B27","v":94},null,"      ROADWAY DENSITY",null,null,{"$f":"'Sublot 1'!L65","v":""},{"$f":"IF(L39=\"\",0,SUM(L39-$G$39))","v":0},{"$f":"'Sublot 2'!L65","v":""},{"$f":"IF(N39=\"\",0,SUM(N39-$G$39))","v":0},{"$f":"'Sublot 3'!L65","v":""},{"$f":"IF(P39=\"\",0,SUM(P39-$G$39))","v":0},{"$f":"'Sublot 4'!L65","v":""},{"$f":"IF(R39=\"\",0,SUM(R39-$G$39))","v":0},{"$f":"'Sublot 5'!L65","v":""},{"$f":"IF(T39=\"\",0,SUM(T39-$G$39))","v":0},"FACTOR",null,null,null,{"$f":"IF(M40>$CL$51,$CP$51,IF(AND(M40<=$CK$52,M40>=$CL$52),$CP$52,IF(AND(M40<=$CK$53,M40>=$CL$53),ROUND(($CM$53*(M40*M40))-($CP$53*M40)+$CR$53,2),IF(M40<$CL$54,$CP$54,\"\"))))","v":1},1,2,3,4,5]
[null,null,null,null,null,null,null,null,{"$f":"G39","v":94}," TOTAL  AVG.  DEVIATION",null,null,{"$f":"ROUND(SUM(M39+O39+Q39+S39+U39)/$I$11,2)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('Sublot 1'!L65=\"\",1,MIN(Z39:Z40))","v":1},null,null,{"$f":"IF(I11=1,IF(AA40=0,1,CS55),IF(I11=2,IF(AB43=1,1,CS55),IF(I11=3,IF(AC43=1,1,CS55),IF(I11=4,IF(AD43=1,1,CS55),IF(I11=5,IF(AE43=1,1,CS55))))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF45-AA45>B22,CS55,0)","v":{"$error":"#VALUE!"}},{"$f":"'Sublot 2'!U55","v":{"$error":"#VALUE!"}},{"$f":"'Sublot 3'!U55","v":{"$error":"#VALUE!"}},{"$f":"'Sublot 4'!U55","v":{"$error":"#VALUE!"}},{"$f":"'Sublot 5'!U55","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I11=2,Z40<Z39),\"**NOTE: EXCEEDS ALLOWABLE RANGE BETWEEN HIGHEST AND LOWEST DENSITY IN SUBLOTS.\",IF(AND(I11=3,Z40<Z39),\"**NOTE: EXCEEDS ALLOWABLE RANGE BETWEEN HIGHEST AND LOWEST DENSITY IN SUBLOTS.\",IF(AND(I11=4,Z40<Z39),\"**NOTE: EXCEEDS ALLOWABLE RANGE BETWEEN HIGHEST AND LOWEST DENSITY IN SUBLOTS.\",\"\")))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I11=2,IF(AND(AA40=0,AB40=0),1))","v":false},{"$f":"IF(I11=1,IF(AA40=0,1),IF(I11=3,IF(AND(AND(AA40=0,AB40=0),AC40=0),1)))","v":{"$error":"#VALUE!"}},{"$f":"IF(I11=1,IF(AA40=0,1),IF(I11=4,IF(AND(AND(AND(AA40=0,AB40=0),AC40=0),AD40=0),1)))","v":{"$error":"#VALUE!"}},{"$f":"IF(I11=1,IF(AA40=0,1),IF(I11=5,IF(AND(AND(AND(AND(AA40=0,AB40=0),AC40=0),AD40=0),AE40=0),1)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Sublot 1'!L65=\"\",\"\",IF($Z$39<=$Z$40,\"\",IF(AA46=1,\"Sublot #1\",IF(ABS($AF$45-AA45>$B$22),\"Sublot #1\",\"\"))))","v":""},{"$f":"IF('Sublot 2'!L65=\"\",\"\",IF($Z$39<=$Z$40,\"\",IF(AB46=1,\"Sublot #2\",IF(ABS($AF$45-AB45>$B$22),\"Sublot #2\",\"\"))))","v":""},{"$f":"IF('Sublot 3'!L65=\"\",\"\",IF($Z$39<=$Z$40,\"\",IF(AC46=1,\"Sublot #3\",IF(ABS($AF$45-AC45>$B$22),\"Sublot #3\",\"\"))))","v":""},{"$f":"IF('Sublot 4'!L65=\"\",\"\",IF($Z$39<=$Z$40,\"\",IF(AD46=1,\"Sublot #4\",IF(ABS($AF$45-AD45>$B$22),\"Sublot #4\",\"\"))))","v":""},{"$f":"(IF('Sublot 5'!L65=\"\",\"\",IF($Z$39<=$Z$40,\"\",IF(AE46=1,\"Sublot #5\",IF(ABS($AF$45-AE45>$B$22),\"Sublot #5\",\"\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"AC CONTENT",null,"AIR VOIDS",null,"DENSITY",null,"GRADATION",null,null,null,null,null,null,null,null,{"$f":"IF('Sublot 1'!L65=\"\",\"\",'Sublot 1'!L65)","v":""},{"$f":"IF('Sublot 2'!L65=\"\",\"\",'Sublot 2'!L65)","v":""},{"$f":"IF('Sublot 3'!L65=\"\",\"\",'Sublot 3'!L65)","v":""},{"$f":"IF('Sublot 4'!L65=\"\",\"\",'Sublot 4'!L65)","v":""},{"$f":"IF('Sublot 5'!L65=\"\",\"\",'Sublot 5'!L65)","v":""},{"$f":"MAX(AA45:AE45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"(AC)",null,"(AV)",null,"(D)",null,"(G)",null,null,null,null,null,null,null,null,{"$f":"IF(AA45=$AF$45,1,\"\")","v":""},{"$f":"IF(AB45=$AF$45,1,\"\")","v":""},{"$f":"IF(AC45=$AF$45,1,\"\")","v":""},{"$f":"IF(AD45=$AF$45,1,\"\")","v":""},{"$f":"IF(AE45=$AF$45,1,\"\")","v":""}]
[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,{"$f":"I11","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Sublot 1'!L59=\"\",\"\",IF(AND(I11=1,Z40<Z39),\"**\",IF(AND(I11=2,Z40<Z39),\"**\",IF(AND(I11=3,Z40<Z39),\"**\",IF(AND(I11=4,Z40<Z39),\"**\",IF(AND(I11=5,Z40<Z39),\"**\",\"\"))))))","v":""},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,"Average of Deviations from Target (without regard to signs)",null,null,null,null,null,null,null,null,null,null,null,"Average of Deviations from Target (without regard to signs)",null,null,null,null,null,null,null,null,null,null,"Average of Deviations from Target (without regard to signs)",null,null,null,null,null,null,null,null,null,"Average of Deviations from Target (considering signs)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"W34","v":1},null,{"$f":"W37","v":1},null,{"$f":"W40","v":1},null,{"$f":"W31","v":1},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,"CHARACTERISTICS","1, 2, 3 or 4",null,"PAY",null,null,null,null,null,null,null,"CHARACTERISTICS","1, 2, 3 or 4",null,"PAY",null,null,null,null,null,null,null,"CHARACTERISTICS","1, 2, 3 or 4",null,"PAY",null,null,null,null,null,null,null,"CHARACTERISTICS","1, 2, 3 or 4",null,"PAY"]
[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,"       TESTS",null,"FACTOR",null,null,null,null,null,null,null,null,"       TESTS",null,"FACTOR",null,null,null,null,null,null,null,null,"       TESTS",null,"FACTOR",null,null,null,null,null,null,null,null,"       TESTS",null,"FACTOR"]
[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," ASPHALT CEMENT",{"$f":"Tables!D5*2/(SQRT($I$11))","v":0},{"$f":"ROUND(Tables!E5*2/(SQRT($I$11)),2)","v":0.7},null,{"$f":"Tables!G5","v":1},null,null,null,null,null,null,"      GRADATION",{"$f":"ROUND(Tables!O5*2/(SQRT($I$11)),2)","v":0},{"$f":"ROUND(Tables!P5*2/(SQRT($I$11)),2)","v":8},null,{"$f":"Tables!R5","v":1},null,null,null,null,null,null,"        AIR VOIDS",{"$f":"ROUND(Tables!Z5*2/(SQRT($I$11)),2)","v":0},{"$f":"(ROUND(Tables!AA5*2/(SQRT($I$11)),2))","v":2.5},null,null,null,{"$f":"Tables!AE5","v":1},null,null,null,null,"ROADWAY DENSITY",null,{"$f":"(ROUND(Tables!AL5*2/(SQRT($I$11)),2))","v":4},null,null,null,{"$f":"Tables!AP5","v":0}]
[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," CONTENT",{"$f":"IF($I$11=1,BE51+0.01,IF($I$11=2,BE51+0.01,IF($I$11=3,BE51+0.01,ROUND(Tables!D6*2/(SQRT($I$11)),2))))","v":0.71},{"$f":"ROUND(Tables!E6*2/(SQRT($I$11)),2)","v":0.9},{"$f":"Tables!F6","v":1.35},"-",{"$f":"Tables!H6","v":"x"},"x",null,null,null,null,"% Passing No. 4 & ",{"$f":"BP51+0.01","v":8.01},{"$f":"ROUND(Tables!P6*2/(SQRT($I$11)),2)","v":14},{"$f":"Tables!Q6","v":1.1599999999999999},"-",{"$f":"Tables!S6","v":0.04},"x",null,null,null,null,"(Lab Molded",{"$f":"CA51+0.01","v":2.5099999999999998},{"$f":"(ROUND(Tables!AA6*2/(SQRT($I$11)),2))","v":3},{"$f":"Tables!AB6","v":-2.4},"x2   +",null,{"$f":"Tables!AE6","v":5.8},"x    -",{"$f":"Tables!AG6","v":2.5},null,null,"(Core or Nuclear)",{"$f":"(ROUND(Tables!AK6*2/(SQRT($I$11)),2))","v":4},{"$f":"(ROUND(Tables!AL6*2/(SQRT($I$11)),2))","v":-2},null,null,null,{"$f":"Tables!AP6","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   3(AC + AV + D) + G   ",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,"(Extraction, Nuclear or Ignition Oven)  ",null,null,{"$f":"IF($I$11=1,BE52+0.01,IF($I$11=2,BE52+0.01,IF($I$11=3,BE52+0.01,ROUND(Tables!D7*2/(SQRT($I$11)),2))))","v":0.91},{"$f":"ROUND(Tables!E7*2/(SQRT($I$11)),2)","v":1},{"$f":"Tables!F7","v":1.8},"-",{"$f":"Tables!H7","v":2},"x",null,null,null,null,"Larger Sieve",{"$f":"BP52+0.01","v":14.01},{"$f":"ROUND(Tables!P7*2/(SQRT($I$11)),2)","v":18},1.3,"-",0.06,"x",null,null,null,null,"specimens)",null,{"$f":"(ROUND(Tables!AA7*2/(SQRT($I$11)),2))","v":3},null,null,null,{"$f":"Tables!AE7","v":0},null,null,null,"Target ","94% of Maximum",{"$f":"CL52-0.01","v":-2.0099999999999998},{"$f":"(ROUND(Tables!AL7*2/(SQRT($I$11)),2))","v":-8},{"$f":"Tables!AM7","v":-5.6000000000000001E-2},"x2     -",null,{"$f":"Tables!AP7","v":0.112},"x  +",{"$f":"Tables!AR7","v":0.94399999999999995}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10",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,"Target","JMF - Percent (%)",null,{"$f":"ROUND(Tables!E8*2/(SQRT($I$11)),2)","v":1},null,{"$f":"Tables!G8","v":0},null,null,"  Unacceptable",null,null,"Target ","JMF - Percent (%)",null,{"$f":"ROUND(Tables!P8*2/(SQRT($I$11)),2)","v":18},null,{"$f":"Tables!R8","v":0},null,null,"  Unacceptable",null,null,null,"Target ",null,null,null,null,null,null,null,null,null,null,"Theoretical",null,{"$f":"(ROUND(Tables!AL8*2/(SQRT($I$11)),2))","v":-8},null,null,null,{"$f":"Tables!AP8","v":0},null,null,"  Unacceptable"]
[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,"3 Million ESALS or more - 5% ",null,null,null,null,null,null,null,null,null,"                            PAYFACTOR FOR UNIFORM STRENGTH >4 % BETWEEN HIGHEST & LOWEST TESTS =",null,null,null,null,null,null,null,null,null,{"$f":"Tables!AS9","v":0.98}]
[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,"0.3 to 3 Million ESALS   - 4% "]
[null,null,null,null,null,null,null,null,null,null,"CUP (Contract Unit Price)=",null,null,null,null,null,null,null,{"$f":"B20","v":33.450000000000003},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,"Average of Deviations from Target (without regard to signs)",null,null,null,null,null,null,null,null,null,null,null,"Average of Deviations from Target (without regard to signs)",null,null,null,null,null,null,null,null,null,"0.3 Million ESALS or Less   - 3% "]
[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,"CHARACTERISTICS","1, 2, 3 or 4",null,"PAY",null,null,null,null,null,null,null,"CHARACTERISTICS","1, 2, 3 or 4",null,"PAY"]
[null,null,null,null,null,null,null,null,null,null,"QL  (Quantity of Asphalt per Lot / TONS)=",null,null,null,null,null,null,null,{"$f":"M11+O11+Q11+S11+U11","v":0},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,"       TESTS",null,"FACTOR",null,null,null,null,null,null,null,null,"       TESTS",null,"FACTOR",null,null,null,null,null,null,null,"5000 ADT or more - 5% "]
[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,"ASPHALT CEMENT",{"$f":"Tables!D14*2/(SQRT($I$11))","v":0},{"$f":"Tables!E14*2/(SQRT($I$11))","v":0.3},null,{"$f":"Tables!G14","v":1},null,null,null,null,null,null,"      GRADATION",{"$f":"ROUND(Tables!O14*2/(SQRT($I$11)),2)","v":0},{"$f":"ROUND(Tables!P14*2/(SQRT($I$11)),2)","v":6.5},null,{"$f":"Tables!R14","v":1},null,null,null,null,null,null,"1000 - 5000 ADT   - 4% "]
[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,"CONTENT",{"$f":"Tables!D15*2/(SQRT($I$11))","v":0.32},{"$f":"Tables!E15*2/(SQRT($I$11))","v":0.42},{"$f":"Tables!F15","v":1.25},"-",{"$f":"Tables!H15","v":1.67},"x",null,null,null,"% Passing No. 8 Sieve ",null,{"$f":"BP60+0.01","v":6.51},{"$f":"ROUND(Tables!P15*2/(SQRT($I$11)),2)","v":9.5},{"$f":"Tables!Q15","v":1.1299999999999999},"-",{"$f":"Tables!S15","v":0.04},"x",null,null,null,null,"1000 ADT or less   - 3% "]
[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,"(Digital Printout)",{"$f":"Tables!D16*2/(SQRT($I$11))","v":0.44},{"$f":"Tables!E16*2/(SQRT($I$11))","v":0.46},{"$f":"Tables!F16","v":1.95},"-",{"$f":"Tables!H16","v":5},"x",null,null,null,"thru No. 100 Sieve",null,9.51,{"$f":"ROUND(Tables!P16*2/(SQRT($I$11)),2)","v":15.5},1.2250000000000001,"-",0.06,"x"]
[null,null,null,null,null,null,null,null,null,null,null,"*","Combined Pay Factor=",null,null,null,null,null,{"$f":"IF((3*(L49+N49+P49)+R49)/10<=0.9,\"NO PAY OPTION!!!\",ROUND(((3*(L49+N49+P49)+R49)/10),2))","v":1},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,"Target","JMF - Percent (%)",null,{"$f":"Tables!E17*2/(SQRT($I$11))","v":0.48},null,{"$f":"Tables!G17","v":0},null,null,"  Unacceptable",null,null,"Target ","JMF - Percent (%)",null,{"$f":"ROUND(Tables!P17*2/(SQRT($I$11)),2)","v":15.5},null,{"$f":"Tables!R17","v":0},null,null,"  Unacceptable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S63=\"NO PAY OPTION!!!\",\"SEE SPECIAL PROVISIONS FOOTNOTE #3\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"*","Pay Adjustment on Lots=",null,null,null,null,{"$f":"IF((3*(L49+N49+P49)+R49)/10<=0.9,\"\",(S63-1)*(S57)*(S59))","v":0}]
[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,"Average of Deviations from Target (without regard to signs)"]
[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,"CHARACTERISTICS","1, 2, 3 or 4",null,"PAY"]
[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,"       TESTS",null,"FACTOR"]
[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,"      GRADATION",{"$f":"ROUND(Tables!O23*2/(SQRT($I$11)),2)","v":0},{"$f":"ROUND(Tables!P23*2/(SQRT($I$11)),2)","v":3},null,{"$f":"Tables!R23","v":1}]
[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,"% Passing No. 200 Sieve ",null,{"$f":"BP69+0.01","v":3.01},{"$f":"ROUND(Tables!P24*2/(SQRT($I$11)),2)","v":4.2},{"$f":"Tables!Q24","v":1.1499999999999999},"-",{"$f":"Tables!S24","v":0.1},"x"]
[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,"thru No. 100 Sieve",null,4.21,{"$f":"ROUND(Tables!P25*2/(SQRT($I$11)),2)","v":6.6},1.2549999999999999,"-",0.15,"x"]
[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,"Target ","JMF - Percent (%)",null,{"$f":"ROUND(Tables!P26*2/(SQRT($I$11)),2)","v":6.6},null,{"$f":"Tables!R26","v":0},null,null,"  Unacceptable"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Tables","index":6,"n_rows":81,"n_cols":45,"rows_kept":81,"cut":false,"hidden":false,"merged":[[76,2,76,3],[77,2,77,3],[78,2,78,3],[79,2,79,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[74,2,74,4],[75,2,75,3],[68,2,68,3],[55,2,55,4],[56,2,56,3],[57,2,57,4],[58,2,58,3],[59,2,59,3],[60,2,60,3],[62,2,62,4],[63,2,63,3],[64,2,64,3],[66,2,66,4],[67,2,67,3],[54,2,54,3],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[35,6,35,7],[36,6,36,7],[48,2,48,4],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[37,6,37,7],[37,8,37,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,6,31,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[30,6,30,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7]]}
[]
[null,null,"Average of Deviations from Target (without regard to signs)",null,null,null,null,null,null,null,null,null,null,null,"Average of Deviations from Target (without regard to signs)",null,null,null,null,null,null,null,null,null,null,"Average of Deviations from Target (without regard to signs)",null,null,null,null,null,null,null,null,null,"Average of Deviations from Target (considering signs)"]
[null,null,"CHARACTERISTICS","            4",null,"PAY",null,null,null,null,null,null,null,"CHARACTERISTICS","            4",null,"PAY",null,null,null,null,null,null,null,"CHARACTERISTICS","            4",null,"PAY",null,null,null,null,null,null,null,"CHARACTERISTICS","            4",null,"PAY"]
[null,null,null,"       TESTS",null,"FACTOR",null,null,null,null,null,null,null,null,"       TESTS",null,"FACTOR",null,null,null,null,null,null,null,null,"       TESTS",null,"FACTOR",null,null,null,null,null,null,null,null,"       TESTS",null,"FACTOR"]
[null,null," ASPHALT CEMENT",0,0.35,null,1,null,null,null,null,null,null,"      GRADATION",0,4,null,1,null,null,null,null,null,null,"        AIR VOIDS",0,1.25,null,null,null,1,null,null,null,null,"ROADWAY DENSITY",null,2,null,null,null,0]
[null,null," CONTENT",0.36,0.45,1.35,"-","x","x",null,null,null,null,"% Passing No. 4 & ",4.01,7,1.1599999999999999,"-",0.04,"x",null,null,null,null,"(Lab Molded",1.26,1.5,-2.4,"x2   +",null,5.8,"x    -",2.5,null,null,"(Core or Nuclear)",2,-1,null,null,null,1]
[null,"(Extraction, Nuclear or Ignition Oven)  ",null,0.46,0.5,1.8,"-",2,"x",null,null,null,null,"Larger Sieve",7.01,9,1.3,"-",0.06,"x",null,null,null,null,"specimens)",null,1.5,null,null,null,0,null,null,null,"Target ","94% of Maximum",-1.01,-4,-5.6000000000000001E-2,"x2     -",null,0.112,"x  +",0.94399999999999995]
[null,"Target","JMF - Percent (%)",null,0.5,null,0,null,null,"  Unacceptable",null,null,"Target ","JMF - Percent (%)",null,9,null,0,null,null,"  Unacceptable",null,null,null,"Target ",null,null,null,null,null,null,null,null,null,null,"Theoretical",null,-4,null,null,null,0,null,null,"  Unacceptable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 Million ESALS or more - 5% ",null,null,null,null,null,null,null,null,null,"                            PAYFACTOR FOR UNIFORM STRENGTH >4 % BETWEEN HIGHEST & LOWEST TESTS =",null,null,null,null,null,null,null,null,null,0.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.3 to 3 Million ESALS   - 4% "]
[null,null,"Average of Deviations from Target (without regard to signs)",null,null,null,null,null,null,null,null,null,null,null,"Average of Deviations from Target (without regard to signs)",null,null,null,null,null,null,null,null,null,"0.3 Million ESALS or Less   - 3% "]
[null,null,"CHARACTERISTICS","            4",null,"PAY",null,null,null,null,null,null,null,"CHARACTERISTICS","            4",null,"PAY"]
[null,null,null,"       TESTS",null,"FACTOR",null,null,null,null,null,null,null,null,"       TESTS",null,"FACTOR",null,null,null,null,null,null,null,"5000 ADT or more - 5% "]
[null,null,"ASPHALT CEMENT",0,0.15,null,1,null,null,null,null,null,null,"      GRADATION",0,3.25,null,1,null,null,null,null,null,null,"1000 - 5000 ADT   - 4% "]
[null,null,"CONTENT",0.16,0.21,1.25,"-",1.67,"x",null,null,null,"          % Passing No. 8 Sieve",null,3.26,4.75,1.1299999999999999,"-",0.04,"x",null,null,null,null,"1000 ADT or less   - 3% "]
[null,null,"(Digital Printout)",0.22,0.23,1.95,"-",5,"x",null,null,null,"          thru No. 100 Sieve",null,4.76,7.75,1.2250000000000001,"-",0.06,"x"]
[null,"Target","JMF - Percent (%)",null,0.24,null,0,null,null,"  Unacceptable",null,null,"Target ","JMF - Percent (%)",null,7.75,null,0,null,null,"  Unacceptable"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average of Deviations from Target (without regard to signs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CHARACTERISTICS","            4",null,"PAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       TESTS",null,"FACTOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"      GRADATION",0,1.5,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,"          % Passing No. 200 Sieve",null,1.51,2.1,1.1499999999999999,"-",0.1,"x"]
[null,null,"Special Provision 708-3 and 2009 Standard Specifications:",null,null,null,null,null,null,null,null,null,"          thru No. 100 Sieve",null,2.11,3.3,1.2549999999999999,"-",0.15,"x"]
[null,null,"MESALs","Nini","Ndes","Nmax","MinNini",null,"MaxNini",null,null,null,"Target ","JMF - Percent (%)",null,3.3,null,0,null,null,"  Unacceptable"]
[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,"E51"]
["Cells F28",null,"Gradation #200 & Dev.",null,1,"E52"]
["Cell F30",null,"Corrected % AC",null,1,"E53"]
["Cell E39",null,"Precision (+/- 0.2 %)",null,1,"E54"]
["Cells E50, F50",null,"Sand Equivalent",null,1,"E55"]
[null,null,"DENSITY (OHD L-45)"]
["Cells D60, E60, F60",null,"Core Spec. Grav. ( Gmb )",null,3,"E57"]
[null,null,"LAB MOLDED @ Ndes"]
["Cell L45",null,"NINI Ratio",null,4,"E59"]
["Cell L45",null,"NINI LSMG",null,3,"E60"]
["Cell M45",null,"NINI % Density",null,1,"E61"]
["Cell M46",null,"Ndes % Density",null,1,"E62"]
[null,null,"MAX. SPECIFIC GRAVITY"]
["Cells K23, M23",null,"Rice's Gravity",null,3,"E64"]
["Cell L24",null,"Avg. Rice Gravity (Gmm)",null,3,"E65"]
["Cell L25",null,"Eff. Spec. Grav. (Gse)",null,3,"E66"]
[null,null,"LAB MOLDED DENSITY"]
["Cell L28",null,"New Gsb  ( calculated )",null,3,"E68"]
["Cell L31",null,"Max. Theo. Spec. Grav.",null,3,"E69"]
["Cells K37, L37, M37",null,"L.M. Spec. Grav. - Gmb",null,3,"E70"]
["Cell L38",null,"Avg. L.M. Spec. Grav.",null,3,"E71"]
["Cell L39",null,"% L.M. Density @ Ndes",null,1,"E72"]
["Cell L40",null,"% Air Voids",null,{"$f":"H73","v":1},"E73",null,{"$f":"IF('Sublot 1'!O44=1,2,1)","v":1}]
["Cell L41",null,"% V.M.A.",null,1,"E74"]
[null,null,"ROADWAY DENSITY"]
["Cell L44",null,"Max. Theo. Sp. Gr. at JMF",null,3,"E76"]
["Cells K55, L55, M55",null,"Core Spec. Grav. ( Gmb )",null,3,"E77"]
["Cells K56, L56, M56",null,"% Absorption",null,1,"E78"]
["Cell L57",null,"Avg. Core Sp. Gr. ( Gmb )",null,3,"E79"]
["Cells K58, L58, M58",null,"% Roadway Density",null,1,"E80"]
["Cell L60",null,"% Avg. Roadway Density",null,1,"E81"]

{"sheet":"Instructions","index":7,"n_rows":88,"n_cols":3,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[" REQUIRED DATA FOR CALCULATIONS:  (Enter on Sublot 1 Tab only)",null,"Information:"]
[]
["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.  "]
[]
[]
[]
[]
["The clarification listed below was in an e-mail dated 08/25/2005."]
["Bill Hawkins"]
["ODOT-Materials Division"]
["Independent Assurance Branch Supervisor"]
[]
["Bill Gamel has asked me to forward this information out to the Residency Labs and Resident Engineers."]
[]
["In Special Provision 411-3QA(a-g)99, 06-08-05,  Table 1, footnote 5 ,page (g), concerning asphalt densities, to read as follows:"]
[]
["(5)    It is the intent of the Specification that uniform compaction be obtained.  In addition to average density requirements, the allowable range "]
["        (difference between the highest and lowest densities in the affected lot) is limited to 4.0 percent on new construction and 5.0 percent on"]
["        resurfacing.  The density pay factors for lots exceeding these limits shall be limited to 0.98 or the density pay factors shown in Table I, "]
["        whichever is less."]
["        Note: The \"highest and lowest densities\", mentioned above, refer the densities of three specimens per sublot averaged and considered "]
["       as one test, as defined in Subsection 411.04 (n) 5 of these specifications."]
[]
[]
["2007-04-29","- Corrected formula's pointing to  wrong cell's that would produce a penalty due to Average Density requirements on Sublot 3 and Sublot 4 Tabs."]
[]
["2013-05-30","- Converted to Excel for 411-3QA 09 Special Provisions"]
[]
["2013-08-09","- Corrected density allowable range calculations between highest annd lowest in the affected lot"]
[]
["2014-02-01","- Corrected rounding in Cell M39 & L39 on all Sublot Tabs, found on HMA Excel Files Committee. Added Sublot #5. "]
[]
["2014-02-07","- Added IOC & Specimen Weight entry cells to Worksheet"]
[]
["2014-05-23","- Added Rounding Tables and OHD L-14 Calculation on Roadway Densities"]
[]
["2014-07-23","- Removed previous ESG consideration"]
[]
["2014-08-08","- Revised sand equivalent rounding"]
[]
["2014-08-19","- Added button to \"Sublot 1\" to make copies.  E.g. Lot 1 to Lot 10.  The current file is copied.  Save before running."]
[]
["2014-08-19","- Added button to \"Pay Factors\" to make a PDF file with the \"Worksheet\" and \"Pay Factors\"."]
[]
["2014-08-19","- Moved Compute Thickness button on Sublot sheets right of core heights."]
[]
["2014-08-19","- Added formula to Sublot sheets I44.  Labels the Gmm method used more clearly based on the value in Worksheet!O44. "]
[]
["2014-08-19","- Added Hypertext link to mix design when cell \"Sublot 1!L8\" is modified. Hyperlinks to page 1 of the mix design only if it exits and is approved for general use."]
[]
["2014-08-28","- Updated PDF Print All and Specimen Number to text format"]
[]
["2014-09-11","- Revised Worksheet format, revised OHD L-45 to the 08/21/2014 revision, added signature line. Corrected 4% density average calc. on Pay Factor sheet."]
[]
["2014-09-29"," - Revised VMA to Field VMA requirements."]
[]
["2014-10-30"," - Corrected Pay Factor deviation calculations for less than four tests."]
[]
["2014-11-04"," - Corrected Pay Factor cell R12 reference"]
[]
["2014-12-19"," - Corrected Air Voids in cell O40 to 0.1 place, removed inputs on Sublots 2 thru 5 & linked to Sublot 1, added dropdown box for Rices,"]
[null,"   corrected Combined Pay Factor to 0.01 place, & corrected error on Print to PDF button."]
[]
["2015-02-26"," - Corrected Rounding Error targets in cells K59, L59, M59, K60, L60, M60, K61, L61, M61, L62, K63, L63, M63, L65 in Sublot 1, 2, 3, 4, & 5"]
[]
["2016-06-21","- Corrected %AC Deviation calculation on Sublot 1, Sublot 2, Sublot 3, Sublot 4, & Sublot 5 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":"Disclaimer","index":8,"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. "]