{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Worksheet","Pay Factors","Tables","Instructions","Disclaimer"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Worksheet","index":0,"n_rows":62,"n_cols":23,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,1,0,13],[6,6,6,8],[6,1,6,4],[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],[5,9,5,10],[1,0,1,13],[3,0,3,13],[12,9,12,11],[9,1,9,6],[10,1,10,6],[11,4,11,6],[35,1,35,2],[26,8,26,12],[27,8,27,9],[28,8,28,9],[29,8,29,9],[24,8,24,9],[23,8,23,9],[13,8,13,12],[12,4,12,5],[30,1,30,2],[31,1,31,2],[32,1,32,2],[34,1,34,2],[36,1,36,2],[33,1,33,2],[38,8,38,9],[38,1,38,2],[37,1,37,2],[50,1,50,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[45,1,45,5],[40,1,40,5],[41,1,41,2],[42,1,42,2],[43,1,43,2],[8,11,8,13],[43,8,43,10],[10,9,10,10],[11,9,11,11],[7,6,7,8],[39,8,39,9],[40,8,40,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[42,8,42,12],[33,8,33,9],[30,8,30,9],[31,8,31,9],[32,8,32,9]]}
["v 2.03","OKLAHOMA DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"6/7/2010","v":"00:00:36.844"}]
["SUPERPAVE"]
[]
["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,"J.P. No.",null,null,null,"Contract No. "]
[" Contractor ",null,null,null,null,"Producer",null,null,null," Plant Location "]
["Sample ID ",null,null,null,null,"Mix Type",null,null,null,"Design No. ",null," ",null,null,"PG64","    PG Grade: Select from drop-down list."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"O8","v":"PG64"}]
[null,"EXTRACTIONS AND GRADATIONS",null,null,null,null,null,"IOC",null,"  TOTAL TONS for this LOT"]
[null,"(OHD L-26, AASHTO T-30, T-11)",null,null,null,null,null,null,null,"  Gse from Design",null,"(Gse >= Gsb)"]
[null," Time",null,"Date",null,null,null,"Specimen Wt.",null,"  Gsb from Design",null,null,null,null,"A","    Rices Precision: Select from drop-down list."]
[null," Temperature ",null,"Lot",1,null,null,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,null,{"$f":"IF(D16=\"\",\"\",ROUND(D16/$E$34*100,Tables!$E$31))","v":""},{"$f":"IF(D16=\"\",\"\",100-E16)","v":""},{"$f":"IF(D16=\"\",\"\",IF(F16<$P16,ABS(F16-$P16),IF(F16>$Q16,ABS($Q16-F16),Tables!$E$31)))","v":""},null," Sample No.",null,1,"|",2,null,"1 1/2\" (37.5 mm)",{"$f":"IF(C16=\"\",\"\",C16-S16)","v":""},{"$f":"IF(C16=\"\",\"\",IF(C16+S16>100,100,C16+S16))","v":""},null,0]
[null,"1\" (25.0 mm)",null,null,{"$f":"IF(D17=\"\",\"\",ROUND(D17/$E$34*100,Tables!$E$31))","v":""},"",{"$f":"IF(D17=\"\",\"\",IF(F17<$P17,ABS(F17-$P17),IF(F17>$Q17,ABS($Q17-F17),Tables!$E$31)))","v":""},null," Flask No.",null,null,"|",null,null,"1\" (25.0 mm)",{"$f":"IF(C17=\"\",\"\",C17-S17)","v":""},{"$f":"IF(C17=\"\",\"\",IF(C17+S17>100,100,C17+S17))","v":""},null,0]
[null,"3/4\" (19.0 mm",null,null,{"$f":"IF(D18=\"\",\"\",ROUND(D18/$E$34*100,Tables!$E$31))","v":""},"",{"$f":"IF(D18=\"\",\"\",IF(F18<$P18,ABS(F18-$P18),IF(F18>$Q18,ABS($Q18-F18),Tables!$E$31)))","v":""},null," Sample Wt.","           (A)  ",null,"|",null,null,"3/4\" (19.0 mm",{"$f":"IF(C18=\"\",\"\",C18-S18)","v":""},{"$f":"IF(C18=\"\",\"\",IF(C18+S18>100,100,C18+S18))","v":""},null,0]
[null,"1/2\" (12.5 mm)",null,null,{"$f":"IF(D19=\"\",\"\",ROUND(D19/$E$34*100,Tables!$E$31))","v":""},"",{"$f":"IF(D19=\"\",\"\",IF(F19<$P19,ABS(F19-$P19),IF(F19>$Q19,ABS($Q19-F19),Tables!$E$31)))","v":""},null," Calib. Wt.","           (B)  ",null,"|",null,null,"1/2\" (12.5 mm)","",{"$f":"IF(C19=\"\",\"\",IF(C19+S19>100,100,C19+S19))","v":""},null,7]
[null,"3/8\" (9.5 mm)",null,null,{"$f":"IF(D20=\"\",\"\",ROUND(D20/$E$34*100,Tables!$E$31))","v":""},"",{"$f":"IF(D20=\"\",\"\",IF(F20<$P20,ABS(F20-$P20),IF(F20>$Q20,ABS($Q20-F20),Tables!$E$31)))","v":""},null," A + B","           (C)  ",{"$f":"IF(K18=\"\",\"\",+K18+K19)","v":""},"|",{"$f":"IF(M18=\"\",\"\",+M18+M19)","v":""},null,"3/8\" (9.5 mm)","","",null,7]
[null,"# 4 ( 4.75 mm)",null,null,{"$f":"IF(D21=\"\",\"\",ROUND(D21/$E$34*100,Tables!$E$31))","v":""},"",{"$f":"IF(D21=\"\",\"\",IF(F21<$P21,ABS(F21-$P21),IF(F21>$Q21,ABS($Q21-F21),Tables!$E$31)))","v":""},null," Sample + Flask + H²O  (D)",null,null,"|",null,null,"# 4 ( 4.75 mm)","","",null,7]
[null,"# 8 (2.36 mm)",null,null,{"$f":"IF(D22=\"\",\"\",ROUND(D22/$E$34*100,Tables!$E$31))","v":""},"",{"$f":"IF(D22=\"\",\"\",IF(F22<$P22,ABS(F22-$P22),IF(F22>$Q22,ABS($Q22-F22),Tables!$E$31)))","v":""},null," C - D","           (E)  ",{"$f":"IF(K20=\"\",\"\",+K20-K21)","v":""},"|",{"$f":"IF(M20=\"\",\"\",+M20-M21)","v":""},null,"# 8 (2.36 mm)","","",null,5]
[null,"# 16 ( 1.18 mm)",null,null,{"$f":"IF(D23=\"\",\"\",ROUND(D23/$E$34*100,Tables!$E$31))","v":""},"",{"$f":"IF(D23=\"\",\"\",IF(F23<$P23,ABS(F23-$P23),IF(F23>$Q23,ABS($Q23-F23),Tables!$E$31)))","v":""},null," Rice's Gravity","        (A/E)  ",{"$f":"IF(K18>0,ROUND(K18/K22,Tables!$E$44),\"\")","v":""},"|",{"$f":"IF(M18>0,ROUND(M18/M22,Tables!$E$44),\"\")","v":""},null,"# 16 ( 1.18 mm)","","",null,4]
[null,"# 30 (.600 mm)",null,null,{"$f":"IF(D24=\"\",\"\",ROUND(D24/$E$34*100,Tables!$E$31))","v":""},"",{"$f":"IF(D24=\"\",\"\",IF(F24<$P24,ABS(F24-$P24),IF(F24>$Q24,ABS($Q24-F24),Tables!$E$31)))","v":""},null," Avg. Rice Gravity (Gmm)",null,null,{"$f":"IF(K23=\"\",\"\",ROUND(AVERAGE(K23,M23),Tables!$E$45))","v":""},{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR\",\"\"))","v":""},null,"# 30 (.600 mm)","","",null,4]
[null,"# 50 (.300 mm)",null,null,{"$f":"IF(D25=\"\",\"\",ROUND(D25/$E$34*100,Tables!$E$31))","v":""},"",{"$f":"IF(D25=\"\",\"\",IF(F25<$P25,ABS(F25-$P25),IF(F25>$Q25,ABS($Q25-F25),Tables!$E$31)))","v":""},null," Eff. Spec. Grav. (Gse)",null,null,{"$f":"IF(K18>0,ROUND((100-F30)/((100/L24)-(F30/$I$13)),Tables!$E$46),\"\")","v":""},null,null,"# 50 (.300 mm)","","",null,4]
[null,"# 100 (.150 mm)",null,null,{"$f":"IF(D26=\"\",\"\",ROUND(D26/$E$34*100,Tables!$E$31))","v":""},"",{"$f":"IF(D26=\"\",\"\",IF(F26<$P26,ABS(F26-$P26),IF(F26>$Q26,ABS($Q26-F26),Tables!$E$31)))","v":""},null,null,{"$f":"IF(K23=\"\",\"\",IF(ABS(K23-M23)>O13,\"ERR = Precision Out of Tolerance\",\"\"))","v":""},null,null,null,null,"# 100 (.150 mm)","","",null,3]
[null,"# 200 (.075 mm)",null,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$32))","v":""},{"$f":"IF(D27=\"\",\"\",IF(F28<$P28,ROUND($P28-F28,Tables!$E$32),IF(F28>$Q28,ROUND(F28-$Q28,Tables!$E$32),0)))","v":""},null," New Gsb  ( calculated )",null,null,{"$f":"IF(I11=\"\",\"\",ROUND(IF(I11=\"\",\"\",(I12/I11)*L25),Tables!$E$48))","v":""},null,null," Total -200 (W3)",{"$f":"IF(C27=\"\",\"\",C27-S28)","v":""},{"$f":"IF(C27=\"\",\"\",C27+S28)","v":""},null,2]
[null," % AC (P5m)",null,null,null,null,null,null," Spec. Grav. AC",null,null,{"$f":"IF(K33=\"\",\"\",$I13)","v":""}]
[null," Corrected %AC",".",null,null,{"$f":"IF(D29=\"\",\"\",ROUND(((((D29*F43)/100)-(F43-F44))/F44)*100,Tables!$E$33))","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":""},{"$f":"IF(C29=\"\",\"\",C29+S30)","v":""},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$49))","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$50))","v":""},{"$f":"IF(L33=0,\"\",ROUND((L33/L36),Tables!$E$50))","v":""},{"$f":"IF(M33=0,\"\",ROUND((M33/M36),Tables!$E$50))","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$51))","v":""}]
[null," Precision (+/- 0.2 %)",null,null,{"$f":"IF(E35=\"\",\"\",ROUND(((E35-(D27+E36))/E35)*100,Tables!$E$34))","v":""},null,null,null," % L.M. Density @ Ndes",null,null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L31*100,Tables!$E$52))","v":""},{"$f":"IF(L39=\"\",\"\",IF(OR(ROUND(L39,1)<O39,ROUND(L39,1)>Q39),\"ERR\",\"\"))","v":""},null,94.5,"-",97.5,"  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$53))","v":""},{"$f":"IF(L40=\"\",\"\",ABS(O40-L40))","v":""},null,4,null,"%Air Voids Target",null,null,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,1),Tables!$E$54))","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,"ROADWAY DENSITY  (OHD L-14 / OHD L-45)"]
[null," Dry Mix (W5m)",null,null,null,{"$f":"IF(E44=\"\",\"\",E44-E42)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(O45=1,\"OHD L-14\",\"\")","v":""},{"$f":"IF(O45=\"\",\" Avg. Rice Gravity\",\" Max. Theo. at JMF AC\")","v":" Avg. Rice Gravity"},null,null,{"$f":"IF(K50=\"\",\"\",IF(O45=1,ROUND((100/((C29/I13)+(100-C29)/L25)),Tables!$E$56),L24))","v":""},"Gmm",null,null,null,"= 1 if density by PGmm by Pb at JMF in 411 pay table, else leave blank."]
[null,"      SAND EQUIVALENT  (AASHTO T-176)",null,null,null,null,null,{"$f":"IF(O45=1,\"05/27/08\",\"\")","v":""}," Specimen No.",null,1,"2","3"]
[null," S.E. No.",null,"1","2",{"$f":"+IF(F48=\"\",\"\",3)","v":""},null,null," Station"]
[null," Sand Reading",null,null,null,null,null,null," Expressway"]
[null," Clay Reading",null,null,null,null,null,null," Lane"]
[null," Sand Equivalent",null,{"$f":"IF(D49=\"\",\"\",ROUNDUP(MROUND(D48/D49*100,0.1),0))","v":""},{"$f":"IF(E49=\"\",\"\",ROUNDUP(MROUND(E48/E49*100,0.1),0))","v":""},{"$f":"IF(F49=\"\",\"\",ROUNDUP(MROUND(F48/F49*100,0.1),0))","v":""},null,null," Shot # 1"]
[null," Average Sand Equivalent",null,null,{"$f":"IF(D50=\"\",\"\",ROUNDUP(MROUND(SUM(D50:F50)/COUNT(D50:F50),0.1),0))","v":""},null,null,null," Shot # 2",null,null,null,null,null,45," Minimum S.E. Requirement"]
[null,null,{"$f":"IF(E51=0,\"\",IF(E51<O51,\"           Fails Minimum S.E. Requirements\",\"\"))","v":""},null,null,null,null,null," Shot # 3"]
[null,"Lab Molded","# of","Specimen","RATIO","LSMG","% Density",null," Shot # 4"]
[null,"Specimen","Gyrations","Height","(Ht@Ndes/","(RATIO x","(LSMG",null," Avg. Unit Weight",null,{"$f":"IF(K51=\"\",\"\",AVERAGE(K50:K53))","v":""},{"$f":"IF(L51=\"\",\"\",AVERAGE(L50:L53))","v":""},{"$f":"IF(M51=\"\",\"\",AVERAGE(M50:M53))","v":""}]
[null," @ Ndes",null,null,"Ht@Nini)","LSMG @","X 100/",null," Nuclear Core Spec. Grav.",null,{"$f":"IF(K54=\"\",\"\",ROUND((K54/62.4),Tables!$E$57))","v":""},{"$f":"IF(L54=\"\",\"\",ROUND((L54/62.4),Tables!$E$57))","v":""},{"$f":"IF(M54=\"\",\"\",ROUND((M54/62.4),Tables!$E$57))","v":""},null,{"$f":"COUNT(K54:M54)","v":0}," No. of Cores"]
[null,null,null,null,null,"Ndes)","Rice's)",null," Avg. Core Sp. Gr. ( Gmb )",null,null,{"$f":"IF(K55=\"\",\"\",ROUND(SUM(((K55+L55+M55))/O55),Tables!$E$59))","v":""}]
[null,"  Nini",{"$f":"VLOOKUP(O8,GTable,2,FALSE)","v":6},null,{"$f":"IF(D57=\"\",\"\",ROUND((D58/D57),Tables!$E$39))","v":""},{"$f":"IF(D57=\"\",\"\",ROUND((E57*F58),Tables!$E$40))","v":""},{"$f":"IF(AND(F58<>\"\",OR(D57=\"\",D58=\"\")),\"ERR\",IF(D58=\"\",\"\",ROUND(((F57*100)/$L$24),Tables!$E$41)))","v":""},null," % Roadway Density",null,{"$f":"IF(K55=\"\",\"\",ROUND(K55/$L$45*100,Tables!$E$60))","v":""},{"$f":"IF(L55=\"\",\"\",ROUND(L55/$L$45*100,Tables!$E$60))","v":""},{"$f":"IF(M55=\"\",\"\",ROUND(M55/$L$45*100,Tables!$E$60))","v":""},null,{"$f":"VLOOKUP(O8,GTable,5,FALSE)","v":85.5}," Nini Minimun Requirement"]
[null,"  Ndes",{"$f":"VLOOKUP(O8,GTable,3,FALSE)","v":50},null,1,{"$f":"IF(D58=\"\",\"\",L38)","v":""},{"$f":"IF(D58=\"\",\"\",ROUND(((F58*100)/$L$24),Tables!$E$42))","v":""},null," % Avg. Roadway Density",null,null,{"$f":"IF(L45=\"\",\"\",IF(L45>0,ROUND(L56/L45*100,Tables!$E$61),\"\"))","v":""},null,null,{"$f":"VLOOKUP(O8,GTable,7,FALSE)","v":91.5}," Nini Maximum Requirement"]
[null,null,{"$f":"(IF(G58=\"\",\"\",IF(OR($G$57=\"ERR\",OR($G57>$O58,$G$57<$O$57)),\"  Fails Nini Requirements\",\"\")))","v":""}]
[]
[]
[null,"Signature / Cert. ID",null,null,"/",null,null,{"$f":"(IF(G58=\"\",\"\",IF(OR($G$57=\"ERR\",OR($G57>$O58,$G$57<$O$57)),\"  Fails Nini Requirements\",\"\")))","v":""},null,{"$f":"IF(L58=\"\",\"\",IF(OR(L58>97,L58<88.1),\"  Fails Roadway Density Requirements\",\"\"))","v":""}]

{"sheet":"Pay Factors","index":1,"n_rows":242,"n_cols":128,"rows_kept":242,"cut":false,"hidden":false,"merged":[[46,2,59,9],[48,0,59,1],[0,1,0,9],[4,8,4,9],[1,0,1,9],[2,6,2,7],[8,4,8,5],[2,1,2,3],[4,1,4,4],[8,0,8,2]]}
[{"$f":"Worksheet!A1","v":"v 2.03"},"OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
[{"$f":"Worksheet!G8 & \"ASPHALT CONCRETE PAVING\"","v":"ASPHALT CONCRETE PAVING"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Print",":PR~{CE}B:A1..B:J39~G"]
["PROJECT  NO:",{"$f":"Worksheet!B6","v":" "},null,null,"      COUNTY:",null,null,null,"DATE:",{"$f":"(IF(Worksheet!E12=\"\",\"\",Worksheet!E12))","v":""}]
[]
["CONTRACTOR:",{"$f":"Worksheet!B7","v":0},null,null,null,"ASPHALT  DESIGN  NO:",null,null,{"$f":"Worksheet!L8","v":" "}]
[]
[null,null,null,null,null,null,null,null,"500 to 1,499 TON  =  ONE LOT"]
[]
[{"$f":"\"ID  \" & Worksheet!B8","v":"ID  "},null,null,"LOT NO.",{"$f":"Worksheet!E13","v":1},null,null,"Total Tons",{"$f":"Worksheet!I10","v":0}]
[]
[]
[]
[]
[]
[]
[null,"    AC CONTENT",null,"       AIR VOIDS",null,null,"       DENSITY",null,"Waive Density?","No"]
[null,"           (AC)",null,"           (AV)",null,null,"         (D)",null,"Reason",null,null,null,"Reasons: Mix is <1.5\" thick, Mix is type PFC, OGFSC, OGBB with no roadway density requirement."]
[null," --------------------",null,"  -----------------------",null,null,"-----------------------",null,null,null,null,null,"<1.5\" Thick"]
[null,null,null,null,null,null,null,null,"Waive Air Voids?","No",null,null,"PFC",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Worksheet!AF29>=Tables!$D$5,Worksheet!AF29<=Tables!$E$5),Tables!$G$5,IF(AND(Worksheet!AF29>=Tables!$D$6,Worksheet!AF29<=Tables!$E$6),Tables!$F$6-Worksheet!AF29,IF(AND(Worksheet!AF29>=Tables!$D$7,Worksheet!AF29<=Tables!$E$7),Tables!$F$7-(Tables!$H$7*Worksheet!AF29),IF(Worksheet!AF29>Tables!$E$8,Tables!$G$8,\" \"))))","v":1}]
[null,{"$f":"IF(AND(Worksheet!G30>=Tables!$D$5,Worksheet!G30<=Tables!$E$5),Tables!$G$5,IF(AND(Worksheet!G30>=Tables!$D$6,Worksheet!G30<=Tables!$E$6),ROUND(Tables!$F$6-Worksheet!G30,2),IF(Worksheet!G30>Tables!$E$8,Tables!$G$8,\"\")))","v":0},null,{"$f":"IF(J19=\"Yes\",1,IF(AND(Worksheet!M40>=Tables!$O$5,Worksheet!M40<=Tables!$P$5),Tables!$T$5,IF(AND(Worksheet!M40>=Tables!$O$6,Worksheet!M40<=Tables!$P$6),ROUND((Tables!$Q$6*(Worksheet!M40*Worksheet!M40))+(Tables!$T$6*Worksheet!M40)+Tables!$V$6,2),IF(Worksheet!M40>Tables!$P$7,Tables!$T$7,\"\"))))","v":0},null,null,{"$f":"IF(J16=\"Yes\",1,IF(Worksheet!L58>Tables!AA4,0,IF(AND(Worksheet!L58>=Tables!Y5,Worksheet!L58<=Tables!AA5),1,IF(AND(Worksheet!L58>=Tables!Y6,Worksheet!L58<=Tables!AA6),ROUND((1-(0.07)*(92-Worksheet!L58)),2),IF(AND(Worksheet!L58>=Tables!Y7,Worksheet!L58<=Tables!AA7),ROUND((0.93-(0.15)*(91-Worksheet!L58)),2),IF(Worksheet!L58<Tables!AA8,0,\"\"))))))","v":0},null,"Reason",null,null,null,"OGFSC"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OGBB"]
[null,null,null,null,null,null,null,null,null,null,null,null,"UTBWC"]
[]
[null,null,"CPF=","   4RD + 3AC + 3AV   "]
[null,null,null,"10  "]
[]
[]
[null,null,null,null,null,null,null,null,null," "]
[null,"CUP (Contract Unit Price)="]
[]
[null,"QL  (Quantity of Asphalt per Lot / TONS)=",null,null,null,null,null,null,{"$f":"I9","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(B20=0,D20=0,G20=0)","v":true},null,"Remove And Replace!"]
[null,null,"*","Combined Pay Factor=",null,null,null,null,{"$f":"IF(OR(L36<L35,L34=TRUE),\"REMOVE & REPLACE!\",L36)","v":"REMOVE & REPLACE!"},null,null,0.56000000000000005,null,"CPF Minimum"]
[null,null,null,null,null,null,null,{"$f":"IF(L34=TRUE,\"SEE SPECIAL PROVISIONS FOOTNOTE #2\",\"\")","v":"SEE SPECIAL PROVISIONS FOOTNOTE #2"},null,null,null,{"$f":"ROUND(((3*B20)+(3*D20)+(4*G20))/10,3)","v":0},null,"CPF Computed"]
[null,null,"*","Tons Deduction=",null,null,null,null,{"$f":"IF(L34=TRUE,\"\",-1*I35*I31+I31)","v":""}]
[]
[null,null,"*","Pay Adjustment on Lot=",null,null,null,null,{"$f":"IF(L34=TRUE,\"\",(I35-1)*(I29)*(I31))","v":""}]
[]
[]
[]
[null,null,{"$f":"IF(L34=TRUE,\"Footnote #2  Unless otherwise directed by the Engineer, products testing in this range are unacceptable\",\"\")","v":"Footnote #2  Unless otherwise directed by the Engineer, products testing in this range are unacceptable"}]
[null,null,{"$f":"IF(L34=TRUE,\"                        and shall be removed and replaced at no additional cost to the Department.\",\"\")","v":"                        and shall be removed and replaced at no additional cost to the Department."}]
[]
[]
[null,"Notes: "]
[null,null,null,null,null,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":"IF(AND(K11=1,Z39<Z38),\"**\",IF(AND(K11=2,Z39<Z38),\"**\",IF(AND(K11=3,Z39<Z38),\"**\",IF(AND(K11=4,Z39<Z38),\"**\",\" \"))))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":2,"n_rows":61,"n_cols":28,"rows_kept":61,"cut":false,"hidden":false,"merged":[[21,19,21,20],[13,17,13,18],[14,17,14,18],[15,17,15,18],[16,17,16,18],[17,17,17,18],[13,19,13,20],[14,19,14,20],[15,19,15,20],[18,17,18,18],[18,19,18,20],[19,17,19,18],[19,19,19,20],[16,19,16,20],[17,19,17,20],[20,19,20,20],[46,2,46,4],[28,2,28,4],[30,2,30,3],[31,2,31,3],[32,2,32,3],[35,2,35,4],[36,2,36,3],[40,2,40,3],[22,17,22,18],[22,19,22,20],[23,17,23,18],[23,19,23,20],[37,2,37,4],[33,2,33,3],[21,17,21,18],[47,2,47,3],[48,2,48,3],[38,2,38,3],[39,2,39,3],[20,17,20,18],[24,17,24,18],[24,19,24,20],[58,2,58,3],[59,2,59,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[54,2,54,4],[55,2,55,3],[34,2,34,3],[56,2,56,3],[57,2,57,3],[42,2,42,4],[43,2,43,3],[44,2,44,3]]}
[]
[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,"PAF for ROADWAY DENSITIES"]
[null,null,"CHARACTERISTICS","            1",null,"PAY",null,null,null,null,null,null,null,"CHARACTERISTICS","            1",null,"PAY",null,null,null,null,null,null,null,"(ALD)",null,null,"(PAF)"]
[null,null,null,"       TEST",null,"FACTOR",null,null,null,null,null,null,null,null,"       TEST",null,"FACTOR",null,null,null,null,null,null,null,"Above  ",null,97,"Unacceptable *"]
[null,null," ASPHALT CEMENT",0,0.4,null,1,null,null,null,null,null,null,"        AIR VOIDS",0,1.5,null,null,null,1,null,null,null,null,92,"-",97,1]
[null,null," CONTENT",0.41,0.8,1.4,"-","x",null,null,null,null,null,"(Lab Molded",1.51,2.5,-0.16,"x^2     +",null,0.24,"x  +",1,null,null,91,"-",91.9,"1.00-(0.07)(92.0-ALD)"]
[null,"(Extraction, Nuclear or Ignition Oven)  ",null,0.41,0.8,1.4,"-",0,"x",null,null,null,null,"specimens)",null,2.5,null,null,null,0,null,null,"  Unacceptable",null,88.1,"-",90.9,"0.93-(0.15)(91.0-ALD)"]
[null,"Target","JMF - Percent (%)",null,0.8,null,0,null,null,"  Unacceptable",null,null,null,"Target ",null,null,null,null,null,null,null,null,null,null,"Below  ",null,88.1,"Unacceptable *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Superpave, SMA   - 4% "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"RBL   - 2% "]
[null,null,"Average of Deviations from Target (without regard to signs)"]
[null,null,"CHARACTERISTICS","            1",null,"PAY",null,null,null,null,null,null,null,"Special Provision 708-3 and 2009 Standard Specifications:"]
[null,null,null,"       TEST",null,"FACTOR",null,null,null,null,null,null,null,"MESALs","Nini","Ndes","Nmax","MinNini",null,"MaxNini"]
[null,null,"ASPHALT CEMENT",0,0.2,null,1,null,null,null,null,null,null,"0.3M-",6,50,75,85.5,null,91.5]
[null,null,"CONTENT",0.21,0.3,1.8,"-",4,"x",null,null,null,null,"0.3M+",7,75,115,85.5,null,90.5]
[null,null,"(Digital Printout)",0.21,0.3,1.8,"-",4,"x",null,null,null,null,"3M+",8,100,160,85.5,null,89]
[null,"Target","JMF - Percent (%)",null,0.3,null,0,null,null,"  Unacceptable",null,null,null,"10M+",8,100,160,85.5,null,89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"30M+",9,125,205,85.5,null,89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PG64",6,50,96,85.5,null,91.5]
["   To use the Digital Printout Characteristics you will need to copy the pink box",null,null,null,null,null,null,null,null,null,null,null,null,"PG70",7,65,96,85.5,null,90.5]
["   into the green box.  Use Copy Button Below.",null,null,null,null,null,null,null,null,null,null,null,null,"PG76",8,80,96,85.5,null,89]
["   Be sure you keep a Master copy for Extraction AC.",null,null,null,null,null,null,null,null,null,null,null,null,"SMA-PG76",0,50,96,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PFC-PG76",0,50,96,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"RBL-PG64",0,50,96,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"RIL-PG76E",0,50,97,0,null,0]
[]
[]
[]
[null,null,"ROUNDING"]
[]
["Cells L16 thru L26",null,"Gradation % Ret. & Dev.",null,0,"E31"]
["Cells F28, G28",null,"Gradation #200 & Dev.",null,1,"E32"]
["Cell E30",null,"Corrected % AC",null,1,"E33"]
["Cell E39",null,"Precision (+/- 0.2 %)",null,1,"E34"]
["Cells E50, F50",null,"Sand Equivalent",null,1,"E35",null,null,null,null,null,null,null,"AASHTO T-209-12 Rices Precision"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Method","Tolerance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A",1.4E-2]
[null,null,"LAB MOLDED @ Ndes",null,null,null,null,null,null,null,null,null,null,"B",1.7999999999999999E-2]
["Cell E57",null,"NINI Ratio",null,4,"E39"]
["Cell F57",null,"NINI LSMG",null,3,"E40"]
["Cell G57",null,"NINI % Density",null,1,"E41"]
["Cell G58",null,"Ndes % Density",null,1,"E42"]
[null,null,"MAX. SPECIFIC GRAVITY"]
["Cells K23, M23",null,"Rice's Gravity",null,3,"E44"]
["Cell L24",null,"Avg. Rice Gravity (Gmm)",null,3,"E45"]
["Cell L25",null,"Eff. Spec. Grav. (Gse)",null,3,"E46"]
[null,null,"LAB MOLDED DENSITY"]
["Cell L28",null,"New Gsb  ( calculated )",null,3,"E48"]
["Cell L31",null,"Max. Theo. Spec. Grav.",null,3,"E49"]
["Cells K37, L37, M37",null,"L.M. Spec. Grav. - Gmb",null,3,"E50"]
["Cell L38",null,"Avg. L.M. Spec. Grav.",null,3,"E51"]
["Cell L39",null,"% L.M. Density @ Ndes",null,1,"E52"]
["Cell L40",null,"% Air Voids",null,{"$f":"H53","v":1},"E53",null,{"$f":"IF(Worksheet!O44=1,2,1)","v":1}]
["Cell L41",null,"% V.M.A.",null,1,"E54"]
[null,null,"ROADWAY DENSITY"]
["Cell L45",null,"Max. Theo. Sp. Gr. at JMF",null,3,"E56"]
["Cells K56, L56, M56",null,"Nuclear Core Spec. Grav.",null,3,"E57"]
[]
["Cell L57",null,"Avg. Core Sp. Gr. ( Gmb )",null,3,"E59"]
["Cells K58, L58, M58",null,"% Roadway Density",null,1,"E60"]
["Cell L59",null,"% Avg. Roadway Density",null,1,"E61"]

{"sheet":"Instructions","index":3,"n_rows":69,"n_cols":3,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
[null," REQUIRED DATA FOR CALCULATIONS:","Information:"]
[]
[null,"Select the ESAL level in O8 using the dropdown selection list.","All data in blue text with yellow background is test data entry."]
[]
[null,"Select the Rices Method in O12 using the dropdown selection list."]
[]
[null," Goto cells O38 and Q38 and enter %Density of GMM reqd.  as listed on JMF."]
[]
[null," Goto cell O40 and enter min. %VMA as listed on JMF."]
[]
[null,"Enter tolerances for gradataion and AC in cells S15 to S29."]
[]
[null,"Enter the SE limit in cell O50."]
[]
[null,"Enter JMF gradations in cells C15 to C26."]
[]
[null,"Enter JMF AC content in cell C28."]
[]
[null,"Enter project information in the header cells B6 to L7."]
[]
[null,"Enter the tons represented by the lot."]
[]
[null,"Enter Tons for this Test Report in cell I9"]
[]
[null,"Enter Data from Design in cells I10 to I12"]
[]
[null,"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.  "]
[]
["Note:","Deviations on Worksheet Tab are derived from Tollerance Limits on design not deviations from JMF."]
[]
[]
[]
["2013-08-15","- Added Rices Method for Precision"]
[]
["2014-01-23","- Revised Cell I37 in Pay Factor Tab, corrected rounding in Cell M39 & L39 on Worksheet Tab, added note on Instruction Tab about deviations "]
[null,"  on Worksheet Tab, found on HMA Excel Files Committee."]
[]
["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","- Revised cell link on Pay Factors worksheet"]
[]
["2014-08-08","- Revised sand equivalent rounding"]
[]
["2014-08-19","- Added button to \"Worksheet\" to make copies.  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","- Added formula to Worksheet!I45.  Labels the Gmm method used more clearly based on the value in Worksheet!O45. "]
[]
["2014-08-28","- Updated PDF Print All and Specimen Number to text format"]
[]
["2014-09-11","- Added signature line to Worksheet. Added Notes area to the Pay Factor spreadsheet."]
[]
["2014-09-29"," - Revised VMA to Field VMA requirements."]
[]
["2014-12-19"," - Corrected Air Voids in cell O40 to 0.1 place, & corrected error on Print to PDF button."]
[]
["2015-06-29"," - Corrected Nuclear Core calculations"]
[]
["2015-09-29"," - Revised CPF rounding in cell L36 to 3 places in Pay Factors."]
[]
["2016-03-21","- Added \"Print\" button on Workshtet tab and reset conditional formating on Dev. Column."]
[]
["2016-06-21","- Corrected %AC Deviation calculation on Worksheet in cell G30."]
[]
["2016-10-03","- Correct Text Wrapping in Notes: on Pay Factors Tab"]

{"sheet":"Disclaimer","index":4,"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. "]