{"text_format":"1","workbook":"xlsx","n_sheets":82,"sheets":["Agg","Agg Prop","Mix Data","Gyratory Data","RAP Prop","Summary","Graphs","45 Chart","Batch Wts","Print Mix Design or Batch Wts","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ","AR","AS","AT","AU","AV","AW","AX","AY","AZ","BA","BB","BC","BD","BE","BF","BG","BH","BI","BJ","BK","BL","BM","BN","BO","BP","BQ","BR","BS","BT","BU","BV","BW","BX","BY","BZ","CA","CB","CC","CD","CE","Compatibility Report"],"not_rendered":{"charts":7,"images":5,"macros":1,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Agg","index":0,"n_rows":76,"n_cols":15,"rows_kept":76,"cut":false,"hidden":false,"merged":[[19,1,19,3],[20,1,20,3]]}
["GENERAL INFORMATION and AGGREGATE GRADATIONS/BLEND"]
["SUPERPAVE MIX DESIGN"]
["Department of Transportation, Materials and Research (Rev. 3-22)"]
[]
["GENERAL INFORMATION"]
["Enter data in shaded boxes."]
[]
["Project:",null,null,null,"Pit #1 Location:"]
[null,null,null,null,"Pit #2 Location:"]
["Location:",null,null,null,"Pit #3 Location:"]
["District:",null,null,null,"Pit Owner(s):    "]
["County:"]
["Date (MM/DD/YY):"]
[null,null,null,null,"AC Specific Gravity:"]
["Lab Number:",null,null,null,"Length of Project:"]
["Type of AC (Top Lift):",null,null,null,"Asphalt Supplier:"]
["Type of AC (Bot. Lift):",null,null,null,"Contractor:"]
["Letting Date:"]
[]
["Mix Design Company:"]
["Mix Design Technician & ID:",null,null,null,"  "]
[null,null,"  "]
[]
["INDIVIDUAL AGGREGATE GRADATIONS"]
[]
[null,"Agg #1","Agg #2","Agg #3","Agg #4","Agg #5","RAP"]
["Aggregate--->",null,null,null,null,null,"Recycled"]
["Description-->",null,null,null,null,null,"Pavement"]
["Sieve ","%","%","%","%","%","%"]
["Size","Passing","Passing","Passing","Passing","Passing","Passing",null,"Virgin "]
["5/8\"    (16mm)",null,null,null,null,null,null,null,{"$f":"+(C$47*B31+C$48*C31+C$49*D31+C$50*E31+C$51*F31)/(100-C$52)","v":0}]
["1/2\"    (12.5mm)",null,null,null,null,null,null,null,{"$f":"+(C$47*B32+C$48*C32+C$49*D32+C$50*E32+C$51*F32)/(100-C$52)","v":0}]
["3/8\"    (9.5mm)",null,null,null,null,null,null,null,0]
["#4      (4.75mm)",null,null,null,null,null,null,null,0]
["#8      (2.36mm)",null,null,null,null,null,null,null,0]
["#16    (1.18mm)",null,null,null,null,null,null,null,0]
["#30    (0.6mm)",null,null,null,null,null,null,null,0]
["#50    (0.3mm)",null,null,null,null,null,null,null,0]
["#100  (0.15mm)",null,null,null,null,null,null,null,0]
["#200  (0.075mm)",null,null,null,null,null,null,null,0]
[]
[]
["BLEND GRADATION"]
[]
["Aggregate","Aggregate","Blend","Sieve","Blend","Lower","Upper",null,null,null,null,null,null,null,"Virgin Bld"]
["Description","#","%","Size","Gradation","Control Pt","Control Pt",null,null,null,{"$f":"MAX(J46:J50)","v":0},null,null,{"$f":"MAX(M46:M50)","v":0}]
[{"$f":"IF(B$27=0,\" \",B$27)","v":" "},1,null,"5/8\"",{"$f":"IF(B31=0,\" \",(($C$47/100)*B31)+(($C$48/100)*C31)+(($C$49/100)*D31)+(($C$50/100)*E31)+(($C$51/100)*F31)+(($C$52/100)*G31))","v":" "},100,100,null,null,null,{"$f":"2*C52","v":0},null,null,{"$f":"2*E50","v":{"$error":"#VALUE!"}},{"$f":"(C47/(100-$C$52))*100","v":0}]
[{"$f":"IF(C$27=0,\" \",C$27)","v":" "},2,null,"1/2\""," ",90,100,null,null,null,{"$f":"4*#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(E48<100,2*E47,0)","v":0},{"$f":"4*E51","v":{"$error":"#VALUE!"}},{"$f":"(C48/(100-$C$52))*100","v":0}]
[{"$f":"IF(D$27=0,\" \",D$27)","v":" "},3,null,"3/8\""," ",null,null,null,null,null,{"$f":"8*#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(E49<100,2*E48,0)","v":0},{"$f":"8*E52","v":{"$error":"#VALUE!"}},0]
[{"$f":"IF(E$27=0,\" \",E$27)","v":" "},4,null,"#4"," ",40,70,null,null,null,{"$f":"14*C53","v":0},null,{"$f":"IF(E50<100,2*E49,0)","v":0},{"$f":"14*E53","v":{"$error":"#VALUE!"}},0]
[{"$f":"IF(F$27=0,\" \",F$27)","v":" "},5,null,"#8"," ",null,null,null,null,null,{"$f":"30*C54","v":0},null,null,{"$f":"30*E54","v":{"$error":"#VALUE!"}},0]
[{"$f":"IF(G$27=0,\" \",G$27)","v":"Recycled"},6,null,"#16"," ",null,null,null,null,null,{"$f":"60*#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"60*E55","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(H$27=0,\" \",H$27)","v":" "},"Sum of % =",{"$f":"SUM(C47:C52)","v":0},"#30 "," ",15,35,null,null,null,{"$f":"160*#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"160*E56","v":{"$error":"#VALUE!"}}]
[null,null,null,"#50 "," "]
[null,null,null,"#100"," ",null,null,null,null,null,{"$f":"SUM(K46:K53)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(N46:N53)","v":{"$error":"#VALUE!"}}]
[null,null,null,"#200"," ",2,7]
[]
["Location RAP Obtained From:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B69^C73","v":{"$error":"#NUM!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B70^C73","v":{"$error":"#NUM!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B71^C73","v":{"$error":"#NUM!"}}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"m=",{"$f":"((C69-C70)/(K67-K69))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,"y intercept=",{"$f":"C69-(K67*L75)","v":{"$error":"#NUM!"}}]

{"sheet":"Agg Prop","index":1,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["AGGREGATE PROPERTIES",null,null,null,null,{"$f":"IF(Agg!B8=0,\" \",Agg!B8)","v":" "}]
["SUPERPAVE MIX DESIGN",null,null,null,null,{"$f":"IF(Agg!B9=0,\" \",Agg!B9)","v":" "}]
["Department of Transportation, Materials and Research (Rev.5-23)",null,null,null,null,{"$f":"IF(Agg!B13=0,\" \",Agg!$B$13)","v":" "}]
[]
[]
["AGGREGATE PROPERTIES"]
[]
[null,"Agg #1","Agg #2","Agg #3","Agg #4","Agg #5","RAP"]
[null,{"$f":"IF(Agg!B27=0,\" \",Agg!B27)","v":" "},{"$f":"IF(Agg!C27=0,\" \",Agg!C27)","v":" "},{"$f":"IF(Agg!D27=0,\" \",Agg!D27)","v":" "},{"$f":"IF(Agg!E27=0,\" \",Agg!E27)","v":" "},{"$f":"IF(Agg!F27=0,\" \",Agg!F27)","v":" "}]
["Bulk SpG (Gsb)"]
["Coarse",null,null,null,null,null,null,"       If using ≤ 15 percent RAP, enter the average coarse and fine virgin aggregate Gsb."]
["Fine",null,null,null,null,null,null,"       If using > 15 percent RAP, enter RAP Gsb from RAP Prop tab in both places."]
["Apparent SpG (Gsa)"]
["Coarse"]
["Fine"]
["Water Absorption",null,null,null,null,null,null,null," "]
["Coarse"]
["Fine"]
["Combined"]
["Bulk SpG (Gsb)",{"$f":"IF(B11=0,1,100/(((100-Agg!B34)/B11)+(Agg!B34/B12)))","v":1},{"$f":"IF(C11=0,1,100/(((100-Agg!C34)/C11)+(Agg!C34/C12)))","v":1},{"$f":"IF(D11=0,1,100/(((100-Agg!D34)/D11)+(Agg!D34/D12)))","v":1},{"$f":"IF(E11=0,1,100/(((100-Agg!E34)/E11)+(Agg!E34/E12)))","v":1},{"$f":"IF(F11=0,1,100/(((100-Agg!F34)/F11)+(Agg!F34/F12)))","v":1},{"$f":"IF(G11=0,1,100/(((100-Agg!G34)/G11)+(Agg!G34/G12)))","v":1}]
["Apparent SpG (Gsa)",{"$f":"IF(B14=0,1,100/(((100-Agg!B34)/B14)+(Agg!B34/B15)))","v":1},{"$f":"IF(C14=0,1,100/(((100-Agg!C34)/C14)+(Agg!C34/C15)))","v":1},{"$f":"IF(D14=0,1,100/(((100-Agg!D34)/D14)+(Agg!D34/D15)))","v":1},{"$f":"IF(E14=0,1,100/(((100-Agg!E34)/E14)+(Agg!E34/E15)))","v":1},{"$f":"IF(F14=0,1,100/(((100-Agg!F34)/F14)+(Agg!F34/F15)))","v":1}]
["Water Absorption",{"$f":"IF(B17=0,1,100/(((100-Agg!B34)/B17)+(Agg!B34/B18)))","v":1},{"$f":"IF(C17=0,1,100/(((100-Agg!C34)/C17)+(Agg!C34/C18)))","v":1},{"$f":"IF(D17=0,1,100/(((100-Agg!D34)/D17)+(Agg!D34/D18)))","v":1},{"$f":"IF(E17=0,1,100/(((100-Agg!E34)/E17)+(Agg!E34/E18)))","v":1},{"$f":"IF(F17=0,1,100/(((100-Agg!F34)/F17)+(Agg!F34/F18)))","v":1}]
[]
[null,null,"Combined Bulk SpG (Gsb) =",{"$f":"IF(Agg!C47=0,\" \",100/((Agg!$C$47/B20)+(Agg!$C$48/C20)+(Agg!$C$49/D20)+(Agg!$C$50/E20)+(Agg!$C$51/F20)+(Agg!$C$52/G20)))","v":" "}]
["Aggregate"]
["Blend",null,"-No. 4 Virgin SpG (Gsb) =",{"$f":"IF(Agg!C47=0,\" \",(100*Agg!I34)/((Agg!$O$47*Agg!B34)/(IF(B12=0,1,B12))+(Agg!$O$48*Agg!C34)/(IF(C12=0,1,C12))+(Agg!$O$49*Agg!D34)/(IF(D12=0,1,D12))+(Agg!$O$50*Agg!E34)/(IF(E12=0,1,E12))+(Agg!$O$51*Agg!F34)/(IF(F12=0,1,F12))))","v":" "}]
["Properties",null,"Apparent SpG (Gsa)=",{"$f":"IF(Agg!C47=0,\" \",100/((Agg!$C$47/B21)+(Agg!$C$48/C21)+(Agg!$C$49/D21)+(Agg!$C$50/E21)+(Agg!$C$51/F21))*((100-Agg!$C$52)/100))","v":" "}]
[null,null,"Water Absorption =",{"$f":"IF(Agg!C47=0,\" \",100/((Agg!$C$47/B22)+(Agg!$C$48/C22)+(Agg!$C$49/D22)+(Agg!$C$50/E22)+(Agg!$C$51/F22))*((100-Agg!$C$52)/100))","v":" "}]
[]
["SUPERPAVE CONSENSUS AGGREGATE PROPERTIES"]
[]
[null,"Agg #1","Agg #2","Agg #3","Agg #4","Agg #5","Recycled"]
[null,{"$f":"IF(Agg!B27=0,\" \",Agg!B27)","v":" "},{"$f":"IF(Agg!C27=0,\" \",Agg!C27)","v":" "},{"$f":"IF(Agg!D27=0,\" \",Agg!D27)","v":" "},{"$f":"IF(Agg!E27=0,\" \",Agg!E27)","v":" "},{"$f":"IF(Agg!F27=0,\" \",Agg!F27)","v":" "},"Pavement"]
["Fine Agg. Angularity"]
["% FAA"]
["Clay Content"]
["% Sand Equivalent"]
[]
[]
["Fractured Particles (+ No.  4 Material)"]
[]
["Nominal maximum Size","Sample Size",null,null,"Wt. of Total Sample ="]
["3/8\" (9.5 mm)","200 g",null,null,"Wt. of Fractured Material ="]
["½\" (12.5 mm)","500 g",null,null,"Wt. of Questionable Material ="]
["3/4\" (19 mm)","1500 g",null,null,"Wt. of Uncrushed Material ="]
[]
[]
["Flat and Elongated Particles"]
[]
["Nominal maximum Size","Sample Size",null,null,"Wt. of Total Sample ="]
["3/8\" (9.5 mm)","1000 g",null,null,"Wt. of Material Larger then 3/8\" ="]
["½\" (12.5 mm)","2000 g",null,null,"Wt. of Flat and Elongated Particles ="]
["3/4\" (19 mm)","5000 g"]
[]
[]
["Superpave",null,"Fine Agg. Angularity % =",{"$f":"IF(B35=0,\" \",((Agg!B34*Agg!C47)+(Agg!C34*Agg!C48)+(Agg!D34*Agg!C49)+(Agg!E34*Agg!C50)+(Agg!F34*Agg!C51)+(Agg!G34*Agg!C52))/(IF(Agg!C47>0,Agg!C47*Agg!B34/'Agg Prop'!B35,0)+(IF(Agg!C48>0,Agg!C34*Agg!C48/'Agg Prop'!C35,0))+(IF(Agg!C49>0,Agg!D34*Agg!C49/'Agg Prop'!D35,0))+(IF(Agg!C50>0,Agg!E34*Agg!C50/'Agg Prop'!E35,0)+(IF(Agg!C51>0,Agg!F34*Agg!C51/'Agg Prop'!F35,0)+(IF(Agg!C52>0,Agg!G34*Agg!C52/'Agg Prop'!G35,0))))))","v":" "}]
["Consensus",null,{"$f":"IF(Agg!C52=0,\" \",\"Virgin Fine Agg. Angularity =\")","v":" "},{"$f":"IF(Agg!C52=0,\" \",((Agg!B34*Agg!O47)+(Agg!C34*Agg!O48)+(Agg!D34*Agg!O49)+(Agg!E34*Agg!O50)+(Agg!F34*Agg!O51))/(IF(Agg!O47>0,Agg!O47*Agg!B34/'Agg Prop'!B35,0)+(IF(Agg!O48>0,Agg!C34*Agg!O48/'Agg Prop'!C35,0))+(IF(Agg!O49>0,Agg!D34*Agg!O49/'Agg Prop'!D35,0))+(IF(Agg!O50>0,Agg!E34*Agg!O50/'Agg Prop'!E35,0)+(IF(Agg!O51>0,Agg!F34*Agg!O51/'Agg Prop'!F35,0)))))","v":" "}]
["Aggregate",null,"Sand Equivalent % =",{"$f":"IF(Agg!B34=0,\" \",(Agg!$B$34*(Agg!$C$47/100)/Agg!$E$50*$B$37)+(Agg!$C$34*(Agg!$C$48/100)/Agg!$E$50*$C$37)+(Agg!$D$34*(Agg!$C$49/100)/Agg!$E$50*$D$37)+(Agg!$E$34*(Agg!$C$50/100)/Agg!$E$50*$E$37)+(Agg!$F$34*(Agg!$C$51/100)/Agg!$E$50*$F$37))/((100-Agg!$C$52)/100)","v":{"$error":"#VALUE!"}},null," "]
["Properties",null,"Fractured Particles % =",{"$f":"IF(F43=0,\" \",((F43+F44/2)/(F43+F44+F45))*100)","v":" "}]
[null,null,"Thin & Elongated Pieces % =",{"$f":"IF(F50=0,\" \",(F52/F51)*100)","v":" "}]

{"sheet":"Mix Data","index":2,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["SUPERPAVE MIX DESIGN DATA",null,null,null,null,null,null,null,{"$f":"IF(Agg!B8=0,\" \",Agg!B8)","v":" "}]
["Department of Transportation, Materials and Research (Rev. 6-23)",null,null,null,null,null,null,null,{"$f":"IF(Agg!B9=0,\" \",Agg!B9)","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"Agg!$B$13","v":"00:00:00"}]
["Bulk Specific Gravity of the Mix (Gmb) @ Ndes"]
[]
["%AC","Weight ","SSD ","Weight ","Volume","Gmb","Unit"]
["  Specimen#","in Air","Weight","in Water",null,"@Ndes"," Weight"]
[{"$f":"IF('Batch Wts'!$C$8=0,\" \",'Batch Wts'!$C$8)","v":" "}]
["A",null,null,null,{"$f":"IF(C9=0,\" \",(+C9-D9))","v":" "},{"$f":"IF(B9=0,\" \",+B9/E9)","v":" "},{"$f":"IF(B9=0,\" \",+F9*62.4)","v":" "}]
["B",null,null,null,{"$f":"IF(C10=0,\" \",(+C10-D10))","v":" "},{"$f":"IF(B10=0,\" \",+B10/E10)","v":" "},{"$f":"IF(B10=0,\" \",+F10*62.4)","v":" "}]
[null,null,null,"Average =",{"$f":"IF(B9=0,\" \",AVERAGE(E9:E10))","v":" "},{"$f":"IF(C9=0,\" \",AVERAGE(F9:F10))","v":" "},{"$f":"IF(D9=0,\" \",AVERAGE(G9:G10))","v":" "}]
[{"$f":"IF('Batch Wts'!$D$8=0,\" \",'Batch Wts'!$D$8)","v":" "}]
["A",null,null,null,{"$f":"IF(C13=0,\" \",(+C13-D13))","v":" "},{"$f":"IF(B13=0,\" \",+B13/E13)","v":" "},{"$f":"IF(B13=0,\" \",+F13*62.4)","v":" "}]
["B",null,null,null,{"$f":"IF(C14=0,\" \",(+C14-D14))","v":" "},{"$f":"IF(B14=0,\" \",+B14/E14)","v":" "},{"$f":"IF(B14=0,\" \",+F14*62.4)","v":" "}]
[null,null,null,"Average =",{"$f":"IF(B13=0,\" \",AVERAGE(E13:E14))","v":" "},{"$f":"IF(C13=0,\" \",AVERAGE(F13:F14))","v":" "},{"$f":"IF(D13=0,\" \",AVERAGE(G13:G14))","v":" "}]
[{"$f":"IF('Batch Wts'!$E$8=0,\" \",'Batch Wts'!$E$8)","v":" "}]
["A",null,null,null,{"$f":"IF(C17=0,\" \",(+C17-D17))","v":" "},{"$f":"IF(B17=0,\" \",+B17/E17)","v":" "},{"$f":"IF(B17=0,\" \",+F17*62.4)","v":" "}]
["B",null,null,null,{"$f":"IF(C18=0,\" \",(+C18-D18))","v":" "},{"$f":"IF(B18=0,\" \",+B18/E18)","v":" "},{"$f":"IF(B18=0,\" \",+F18*62.4)","v":" "}]
[null,null,null,"Average =",{"$f":"IF(B17=0,\" \",AVERAGE(E17:E18))","v":" "},{"$f":"IF(C17=0,\" \",AVERAGE(F17:F18))","v":" "},{"$f":"IF(D17=0,\" \",AVERAGE(G17:G18))","v":" "}]
[{"$f":"IF('Batch Wts'!$F$8=0,\" \",'Batch Wts'!$F$8)","v":" "}]
["A",null,null,null,{"$f":"IF(C21=0,\" \",(+C21-D21))","v":" "},{"$f":"IF(B21=0,\" \",+B21/E21)","v":" "},{"$f":"IF(B21=0,\" \",+F21*62.4)","v":" "}]
["B",null,null,null,{"$f":"IF(C22=0,\" \",(+C22-D22))","v":" "},{"$f":"IF(B22=0,\" \",+B22/E22)","v":" "},{"$f":"IF(B22=0,\" \",+F22*62.4)","v":" "}]
[null,null,null,"Average =",{"$f":"IF(B21=0,\" \",AVERAGE(E21:E22))","v":" "},{"$f":"IF(C21=0,\" \",AVERAGE(F21:F22))","v":" "},{"$f":"IF(D21=0,\" \",AVERAGE(G21:G22))","v":" "}]
[{"$f":"IF('Batch Wts'!$G$8=0,\" \",'Batch Wts'!$G$8)","v":" "}]
["A",null,null,null,{"$f":"IF(C25=0,\" \",(+C25-D25))","v":" "},{"$f":"IF(B25=0,\" \",+B25/E25)","v":" "},{"$f":"IF(B25=0,\" \",+F25*62.4)","v":" "}]
["B",null,null,null,{"$f":"IF(C26=0,\" \",(+C26-D26))","v":" "},{"$f":"IF(B26=0,\" \",+B26/E26)","v":" "},{"$f":"IF(B26=0,\" \",+F26*62.4)","v":" "}]
[null,null,null,"Average =",{"$f":"IF(B25=0,\" \",AVERAGE(E25:E26))","v":" "},{"$f":"IF(C25=0,\" \",AVERAGE(F25:F26))","v":" "},{"$f":"IF(D25=0,\" \",AVERAGE(G25:G26))","v":" "}]
[]
[]
["Rice Test: Theoretical Maximum SpG of the Mix (Gmm) @ Ndes"]
[]
[null,"AC % =",{"$f":"IF('Batch Wts'!$C$8=0,\" \",'Batch Wts'!$C$8)","v":" "},"AC % =",{"$f":"IF('Batch Wts'!D$8=0,\" \",'Batch Wts'!D$8)","v":" "},"AC % =",{"$f":"IF('Batch Wts'!$E$8=0,\" \",'Batch Wts'!$E$8)","v":" "},"AC % =",{"$f":"IF('Batch Wts'!$F$8=0,\" \",'Batch Wts'!$F$8)","v":" "},"AC % =",{"$f":"IF('Batch Wts'!$G$8=0,\" \",'Batch Wts'!$G$8)","v":" "}]
["Flask Number",1,2,1,2,1,2,1,2,1,2]
["Samp., Cont. & Sol."]
["Cont. & Sol. (g)"]
["Samp. in Air (g)"]
["Samp. in Sol. (g)",{"$f":"IF($C$32=0,\" \",+B34-B35)","v":0},{"$f":"IF($C$32=0,\" \",+C34-C35)","v":0},{"$f":"IF($D$32=0,\" \",+D34-D35)","v":0},{"$f":"IF($D$32=0,\" \",+E34-E35)","v":0},{"$f":"IF($G$32=0,\" \",+F34-F35)","v":0},{"$f":"IF($G$32=0,\" \",+G34-G35)","v":0},{"$f":"IF($I$32=0,\" \",+H34-H35)","v":0},{"$f":"IF($I$32=0,\" \",+I34-I35)","v":0},{"$f":"IF($K$32=0,\" \",+J34-J35)","v":0},{"$f":"IF($K$32=0,\" \",+K34-K35)","v":0}]
["Vol. of Voidless Mix",{"$f":"IF($C$32=0,\" \",+B36-B37)","v":0},{"$f":"IF($C$32=0,\" \",+C36-C37)","v":0},{"$f":"IF($E$32=0,\" \",+D36-D37)","v":0},{"$f":"IF($E$32=0,\" \",+E36-E37)","v":0},{"$f":"IF($G$32=0,\" \",+F36-F37)","v":0},{"$f":"IF($G$32=0,\" \",+G36-G37)","v":0},{"$f":"IF($I$32=0,\" \",+H36-H37)","v":0},{"$f":"IF($I$32=0,\" \",+I36-I37)","v":0},{"$f":"IF($K$32=0,\" \",+J36-J37)","v":0},{"$f":"IF($K$32=0,\" \",+K36-K37)","v":0}]
["Theoretical Max. SpG",{"$f":"IF(C34=0,\" \",+B36/B38)","v":" "},{"$f":"IF($C$34=0,\" \",+C36/C38)","v":" "},{"$f":"IF($E$34=0,\" \",+D36/D38)","v":" "},{"$f":"IF($E$34=0,\" \",+E36/E38)","v":" "},{"$f":"IF($G$34=0,\" \",+F36/F38)","v":" "},{"$f":"IF($G$34=0,\" \",+G36/G38)","v":" "},{"$f":"IF($I$34=0,\" \",+H36/H38)","v":" "},{"$f":"IF($I$34=0,\" \",+I36/I38)","v":" "},{"$f":"IF($K$34=0,\" \",+J36/J38)","v":" "},{"$f":"IF($K$34=0,\" \",+K36/K38)","v":" "}]
["Difference Between",{"$f":"IF(C34=0,\" \",ABS(B39-C39))","v":" "},null,{"$f":"IF(E34=0,\" \",ABS(D39-E39))","v":" "},null,{"$f":"IF(G34=0,\" \",ABS(F39-G39))","v":" "},null,{"$f":"IF(I34=0,\" \",ABS(H39-I39))","v":" "},null,{"$f":"IF(K34=0,\" \",ABS(J39-K39))","v":" "},{"$f":"IF(L43=0,\" \",ABS(K39-L50))","v":" "}]
["Flasks",{"$f":"IF(C34=0,\" \",IF(B40>0.0144999,\"Out Of Tolerance\",\"In Tolerance\"))","v":" "},null,{"$f":"IF(E34=0,\" \",IF(D40>0.0144999,\"Out Of Tolerance\",\"In Tolerance\"))","v":" "},null,{"$f":"IF(G34=0,\" \",IF(F40>0.0144999,\"Out Of Tolerance\",\"In Tolerance\"))","v":" "},null,{"$f":"IF(I34=0,\" \",IF(H40>0.0144999,\"Out Of Tolerance\",\"In Tolerance\"))","v":" "},null,{"$f":"IF(K34=0,\" \",IF(J40>0.0144999,\"Out Of Tolerance\",\"In Tolerance\"))","v":" "}]
["Avg Theor. Max. SpG",{"$f":"IF($C$34=0,\" \",+(B39+C39)/2)","v":" "},null,{"$f":"IF($E$34=0,\" \",+(D39+E39)/2)","v":" "},null,{"$f":"IF($G$34=0,\" \",+(F39+G39)/2)","v":" "},null,{"$f":"IF($I$34=0,\" \",+(H39+I39)/2)","v":" "},null,{"$f":"IF($K$34=0,\" \",+(J39+K39)/2)","v":" "}]
["Effective SpG",{"$f":"IF($C$34=0,\" \",+(100-(C32))/((100/B42)-((C32/Agg!$F$14))))","v":" "},null,{"$f":"IF($E$34=0,\" \",+(100-(E32))/((100/D42)-((E32/Agg!$F$14))))","v":" "},null,{"$f":"IF($G$34=0,\" \",+(100-(G32))/((100/F42)-((G32/Agg!$F$14))))","v":" "},null,{"$f":"IF($I$34=0,\" \",+(100-(I32))/((100/H42)-((I32/Agg!$F$14))))","v":" "},null,{"$f":"IF($K$34=0,\" \",+(100-(K32))/((100/J42)-((K32/Agg!$F$14))))","v":" "}]
["AC Absorption",{"$f":"IF(C34=0,\" \",+(100*(B43-('Agg Prop'!$D$24))*(Agg!$F$14)/(B43*('Agg Prop'!$D$24))))","v":" "},null,{"$f":"IF(E34=0,\" \",+(100*(D43-('Agg Prop'!$D$24))*(Agg!$F$14)/(D43*('Agg Prop'!$D$24))))","v":" "},null,{"$f":"IF(G34=0,\" \",+(100*(F43-('Agg Prop'!$D$24))*(Agg!$F$14)/(F43*('Agg Prop'!$D$24))))","v":" "},null,{"$f":"IF(I34=0,\" \",+(100*(H43-('Agg Prop'!$D$24))*(Agg!$F$14)/(H43*('Agg Prop'!$D$24))))","v":" "},null,{"$f":"IF(K34=0,\" \",+(100*(J43-('Agg Prop'!$D$24))*(Agg!$F$14)/(J43*('Agg Prop'!$D$24))))","v":" "}]
[]
["Avg Effective SpG:",null,{"$f":"((IF(D51=\" \",0,B43))+(IF(E51=\" \",0,D43))+(IF(F51=\" \",0,F43))+(IF(G51=\" \",0,H43))+(IF(H51=\" \",0,J43)))/'Batch Wts'!C11","v":{"$error":"#DIV/0!"}}]
[]
[]
["Voids Analysis of the Mix @ Ndes"]
[]
["AC Content (%)",null,null,{"$f":"IF('Batch Wts'!$C$8=0,\" \",'Batch Wts'!$C$8)","v":" "},{"$f":"IF('Batch Wts'!$D$8=0,\" \",'Batch Wts'!D$8)","v":" "},{"$f":"IF('Batch Wts'!$E$8=0,\" \",'Batch Wts'!$E$8)","v":" "},{"$f":"IF('Batch Wts'!$F$8=0,\" \",'Batch Wts'!$F$8)","v":" "},{"$f":"IF('Batch Wts'!$G$8=0,\" \",'Batch Wts'!$G$8)","v":" "}]
["Bulk Specific Gravity of the Mix (Gmb)",null,null,{"$f":"$F11","v":" "},{"$f":"$F15","v":" "},{"$f":"$F19","v":" "},{"$f":"$F23","v":" "},{"$f":"$F27","v":" "}]
["Percent Aggregate",null,null,{"$f":"IF(D51=\" \",\" \",100-D51)","v":" "},{"$f":"IF(E51=\" \",\" \",100-E51)","v":" "}," "," "," "]
["Theor. Maximum SpG of Mix (Gmm)",null,null,{"$f":"B42","v":" "},{"$f":"D42","v":" "},{"$f":"F42","v":" "},{"$f":"H42","v":" "},{"$f":"J42","v":" "}]
["Air Voids, Va (%)",null,null,{"$f":"IF(D51=\" \",\" \",100*(1-(D52/D54)))","v":" "},{"$f":"IF(E51=\" \",\" \",100*(1-(E52/E54)))","v":" "}," "," "," "]
["Voids in Mineral Agg. (VMA)",null,null,{"$f":"IF(D51=\" \",\" \",100-((D52*D53)/'Agg Prop'!$D$24))","v":" "},{"$f":"IF(E51=\" \",\" \",100-((E52*E53)/'Agg Prop'!$D$24))","v":" "},{"$f":"IF(F51=\" \",\" \",100-((F52*F53)/'Agg Prop'!$D$24))","v":" "},{"$f":"IF(G51=\" \",\" \",100-((G52*G53)/'Agg Prop'!$D$24))","v":" "},{"$f":"IF(H51=\" \",\" \",100-((H52*H53)/'Agg Prop'!$D$24))","v":" "}]
["Voids in Mineral Agg. Filled (VFA)",null,null,{"$f":"IF(D51=\" \",\" \",100*((D56-D55)/D56))","v":" "},{"$f":"IF(E51=\" \",\" \",100*((E56-E55)/E56))","v":" "}," "," "," "]
["Asphalt Absorption (%)",null,null,{"$f":"IF(D51=\" \",\" \",100*((C46-'Agg Prop'!D24)/(C46*'Agg Prop'!D24))*Agg!F14)","v":" "}]

{"sheet":"Gyratory Data","index":3,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["SUPERPAVE MIX DESIGN ",null,null,null,null,null,null,null,{"$f":"IF(Agg!B8=0,\" \",Agg!B8)","v":" "}]
["Gyratory Compactor Information",null,null,null,null,null,null,null,{"$f":"IF(Agg!B9=0,\" \",Agg!B9)","v":" "}]
["Department of Transportation, Materials and Research (Rev. 3-22)",null,null,null,null,null,null,null,{"$f":"Agg!$B$13","v":"00:00:00"}]
[]
[]
["Superpave Gyratory Compaction Effort"]
[]
["Number of Gyrations @ Ninitial:"]
["Number of Gyrations @ Ndesign:"]
["Number of Gyrations @ Nmaximum:"]
[]
[]
["Gyratory Plugs Compacted to Ninital and Ndesign"]
[]
[null,"AC % =",{"$f":"IF('Batch Wts'!$C$8=0,\" \",'Batch Wts'!$C$8)","v":" "},"AC % =",{"$f":"IF('Batch Wts'!$D$8=0,\" \",'Batch Wts'!$D$8)","v":" "},"AC % =",{"$f":"IF('Batch Wts'!$E$8=0,\" \",'Batch Wts'!$E$8)","v":" "},"AC % =",{"$f":"IF('Batch Wts'!$F$8=0,\" \",'Batch Wts'!$F$8)","v":" "},"AC % =",{"$f":"IF('Batch Wts'!$G$8=0,\" \",'Batch Wts'!$G$8)","v":" "}]
["Plug Number",1,2,1,2,1,2,1,2,1,2]
["Plug Weight (g)",{"$f":"IF('Mix Data'!B9=0,\" \",'Mix Data'!B9)","v":" "},{"$f":"IF('Mix Data'!B10=0,\" \",'Mix Data'!B10)","v":" "},{"$f":"IF('Mix Data'!B13=0,\" \",'Mix Data'!B13)","v":" "},{"$f":"IF('Mix Data'!B14=0,\" \",'Mix Data'!B14)","v":" "},{"$f":"IF('Mix Data'!B17=0,\" \",'Mix Data'!B17)","v":" "},{"$f":"IF('Mix Data'!B18=0,\" \",'Mix Data'!B18)","v":" "},{"$f":"IF('Mix Data'!B21=0,\" \",'Mix Data'!B21)","v":" "},{"$f":"IF('Mix Data'!B22=0,\" \",'Mix Data'!B22)","v":" "},{"$f":"IF('Mix Data'!B25=0,\" \",'Mix Data'!B25)","v":" "},{"$f":"IF('Mix Data'!B26=0,\" \",'Mix Data'!B26)","v":" "}]
["Plug Height @ Nini (mm)"]
["Plug Height @ Ndes (mm)"]
["% Gmm initial",{"$f":"IF(B19=0,\" \",100*(('Mix Data'!F11*B19)/('Mix Data'!B42*B18)))","v":" "},{"$f":"IF(C19=0,\" \",100*(('Mix Data'!F11*C19)/('Mix Data'!B42*C18)))","v":" "},{"$f":"IF(D19=0,\" \",100*(('Mix Data'!F15*D19)/('Mix Data'!D42*D18)))","v":" "},{"$f":"IF(E19=0,\" \",100*(('Mix Data'!F15*E19)/('Mix Data'!D42*E18)))","v":" "},{"$f":"IF(F19=0,\" \",100*(('Mix Data'!F19*F19)/('Mix Data'!F42*F18)))","v":" "},{"$f":"IF(G19=0,\" \",100*(('Mix Data'!F19*G19)/('Mix Data'!F42*G18)))","v":" "},{"$f":"IF(H19=0,\" \",100*(('Mix Data'!F23*H19)/('Mix Data'!H42*H18)))","v":" "},{"$f":"IF(I19=0,\" \",100*(('Mix Data'!F23*I19)/('Mix Data'!H42*I18)))","v":" "},{"$f":"IF(J19=0,\" \",100*(('Mix Data'!F27*J19)/('Mix Data'!J42*J18)))","v":" "},{"$f":"IF(K19=0,\" \",100*(('Mix Data'!F27*K19)/('Mix Data'!J42*K18)))","v":" "}]
["Avg. % Gmm initial",{"$f":"IF(B19=0,\" \",AVERAGE(B20:C20))","v":" "},null,{"$f":"IF(D19=0,\" \",AVERAGE(D20:E20))","v":" "},null,{"$f":"IF(F19=0,\" \",AVERAGE(F20:G20))","v":" "},null,{"$f":"IF(H19=0,\" \",AVERAGE(H20:I20))","v":" "},null,{"$f":"IF(J19=0,\" \",AVERAGE(J20:K20))","v":" "}]
[]
[]
["Gyratory Plugs Compacted to Nmaximum at Design Optimum Asphalt Content"]
[]
["%AC @ Optimum","Weight ","SSD ","Weight ","Volume","Gmb","Unit"]
["         Specimen#","in Air","Weight","in Water",null,"@Ndes"," Weight"]
[{"$f":"IF(Summary!$B$22=0,\" \",Summary!$B$22)","v":" "}]
["A",null,null,null,{"$f":"IF($A$28=0,\" \",+C29-D29)","v":0},{"$f":"IF(B29=0,\" \",+B29/E29)","v":" "},{"$f":"IF(B29=0,\" \",+F29*62.4)","v":" "}]
["B",null,null,null,{"$f":"IF($A$28=0,\" \",+C30-D30)","v":0},{"$f":"IF(B30=0,\" \",+B30/E30)","v":" "},{"$f":"IF(B30=0,\" \",+F30*62.4)","v":" "}]
[null,null,null,"Average =",{"$f":"AVERAGE(E29:E30)","v":0},{"$f":"IF(B29=0,\" \",AVERAGE(F29:F30))","v":" "},{"$f":"IF(C29=0,\" \",AVERAGE(G29:G30))","v":" "}]
[]
["%Gmm at Nmaximum =",{"$f":"IF(Summary!B36=\" \",\" \",100*(F31/Summary!B36))","v":" "}]
[]
[]
["Moisture Sensitivity (Minimum Percent Strength Retention)"]
[]
["No data is needed to be entered here at this time."]

{"sheet":"RAP Prop","index":4,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["RECYCLED ASPHALT PAVEMENT (RAP) PROPERTIES"]
["SUPERPAVE MIX DESIGN"]
["Department of Transportation, Materials and Research (Rev.5-23)"]
[]
["RAP ASPHALT PROPERTIES",null,null,null,null,null,"RAP AGGREGATE GRADATION"]
[]
["AC Content (%) from Extraction",null,null,null,null,null,"Sieve ","%"]
[null,null,null,null,null,null,"Size","Passing"]
["AC Content (%) from Ignition Oven",null,null,null,null,null,"5/8\"    (16mm)",{"$f":"+Agg!G31","v":0}]
[null,null,null,null," ",null,"1/2\"    (12.5mm)",{"$f":"+Agg!G32","v":0}]
["Ignition Oven AC Correction Factor",null,null,null,null,null,"3/8\"    (9.5mm)",{"$f":"+Agg!G33","v":0}]
[null,null,null,null,null,null,"#4      (4.75mm)",{"$f":"+Agg!G34","v":0}]
[null,null,null,null,null,null,"#8      (2.36mm)",{"$f":"+Agg!G35","v":0}]
["Calculated Percent AC RAP",{"$f":"+'Batch Wts'!C13","v":0},null,null,null,null,"#16    (1.18mm)",{"$f":"+Agg!G36","v":0}]
[null,null,null,null,null,null,"#30    (0.6mm)",{"$f":"+Agg!G37","v":0}]
["RAP Aggregate Bulk Specific Gravity (Gsb)",null,null,null,null,null,"#50    (0.3mm)",{"$f":"+Agg!G38","v":0}]
[null,null,null,null,null,null,"#100  (0.15mm)",{"$f":"+Agg!G39","v":0}]
["RAP Theoretical Maximum Specific Gravity, Gmm(RAP)",null,null,null,null,null,"#200  (0.075mm)",{"$f":"+Agg!G40","v":0}]
[]
["Weight of added AC, g",null,null,null,null,null,"RAP AGGREGATE PROPERTIES"]
["Specific gravity of the AC added"]
["AC Binder Content of the RAP, %",{"$f":"+'Batch Wts'!C13","v":0},null,null,null,null,"Fine Agg. Angularity (FAA)",{"$f":"+'Agg Prop'!G35","v":0}]
["AC Absorption of the RAP, %"]
["Total Weight of RAP, (RAP+addedAC) g",null,null,null,null,null,"Combined Agg. Bulk SpG (Gsb) ",{"$f":"+'Agg Prop'!G20","v":1}]
[]
[null,"Flask 1","Flask 2"]
["Weight of sample in air, g: "]
["Wt of container, solution and cover plate, g: "]
["Wt of sample, container, solution & cover plate, g: "]
[]
["Weight of Added AC per Flask, g",{"$f":"IF(B27=0,\"\",(B27/B24)*B20)","v":""},{"$f":"IF(C27=0,\"\",(C27/B24)*B20)","v":""}]
["Volume of Added AC per Flask, cc or ml",{"$f":"IF(B27=0,\"\",(B31/B21))","v":""},{"$f":"IF(C27=0,\"\",(C31/B21))","v":""}]
[null,null,null,"Avg. Gmm (RAP)"]
["Gmm (RAP)",{"$f":"IF(B27=0,\"\",((B27-B31)/((B27+B28)-(B29+B32))))","v":""},{"$f":"IF(C27=0,\"\",((C27-C31)/((C27+C28)-(C29+C32))))","v":""},{"$f":"IF(B27=0,\"\",(B34+C34)/2)","v":""}]
[]
["RAP Effective Specific Gravity, Gse(RAP)",{"$f":"IF($B$14=0,\" \",+((100-B22)/((100/D34)-(B22/1.04))))","v":" "}]
[]
["RAP Agg Bulk Specific Gravity, Gsb (RAP)",{"$f":"IF($B$14=0,\" \",+((B36)/((B23*B36)/(100*1.04)+1)))","v":" "}]

{"sheet":"Summary","index":5,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[59,0,59,5]]}
["HOT MIX DESIGN DATA - SUPERPAVE"]
["Department of Transportation, Materials and Research (Rev. 5-23)",null,null,null,null,null,{"$f":"Agg!$B$13","v":"00:00:00"}]
[]
["Mix Design Company:",{"$f":"IF(Agg!B20=0,\" \",Agg!B20)","v":" "}]
[]
["Lab. No.",{"$f":"IF(Agg!B15=0,\" \",Agg!B15)","v":" "}]
["Location",{"$f":"IF(Agg!B10=0,\" \",Agg!B10)","v":" "},null,null,null,"Project Specification",null,"Section 430"]
["Project",{"$f":"IF(Agg!B8=0,\" \",Agg!B8)","v":" "},null,null,null,"Type of AC (top lift)",null,{"$f":"IF(Agg!B16=0,\" \",Agg!B16)","v":" "}]
[null,{"$f":"IF(Agg!B9=0,\" \",Agg!B9)","v":" "},null,null,null,"Type of AC (bot lift)",null,{"$f":"IF(Agg!B17=0,\" \",Agg!B17)","v":" "}]
["District",{"$f":"IF(Agg!B11=0,\" \",Agg!B11)","v":" "},null,null,null,"Letting Date",null,{"$f":"IF(Agg!B18=0,\" \",Agg!B18)","v":" "}]
["County",{"$f":"IF(Agg!B12=0,\" \",Agg!B12)","v":" "},null,null,null,"Plus #4 (%)",null,{"$f":"IF(B22=0,\" \",100-G26)","v":" "}]
["Date",{"$f":"Agg!B13","v":"00:00:00"},null,null,null,"Minus #4 (%)",null,{"$f":"G26","v":" "}]
["Pit Owner(s)",{"$f":"IF(Agg!F11=0,\" \",Agg!F11)","v":" "}]
[null,{"$f":"IF(Agg!F12=0,\" \",Agg!F12)","v":" "},null,null,null,"Gyratory Compactive Effort"]
["Pit #1 Location",{"$f":"IF(Agg!F8=0,\" \",Agg!F8)","v":" "},null,null,null,null,"Ninitial",{"$f":"'Gyratory Data'!C8","v":0}]
["Pit #2 Location",{"$f":"IF(Agg!F9=0,\" \",Agg!F9)","v":" "},null,null,null,null,"Ndesign",{"$f":"'Gyratory Data'!C9","v":0}]
["Pit #3 Location",{"$f":"IF(Agg!F10=0,\" \",Agg!F10)","v":" "},null,null,null,null,"Nmaximum",{"$f":"'Gyratory Data'!C10","v":0}]
[]
["Mix Properties at Recommended Asphalt Content",null,null,null,null,"Summary of Aggregate"]
[null,"Mix Design",null,"Specification",null,"Characteristics from Mix Design"]
["Opt. AC @ 3% Air Voids"]
["Opt. AC @ 4% Air Voids",null,null,null,null,"Gradation (% passing)","Blend",{"$f":"IF(Agg!C52=0,\" \",\"Virgin\")","v":" "}]
["Density (pcf)",null,null,null,null," 5/8\"",{"$f":"Agg!E47","v":" "},{"$f":"IF(Agg!$C$52=0,\" \",Agg!I31)","v":" "}]
["Air Voids (%)",null,null,null,null," 1/2\"",{"$f":"Agg!E48","v":" "},{"$f":"IF(Agg!$C$52=0,\" \",Agg!I32)","v":" "}]
["VMA (%)",null,null,null,null," 3/8\"",{"$f":"Agg!E49","v":" "},{"$f":"IF(Agg!$C$52=0,\" \",Agg!I33)","v":" "}]
["VFA (%)",null,null,null,null,"  #4",{"$f":"Agg!E50","v":" "},{"$f":"IF(Agg!$C$52=0,\" \",Agg!I34)","v":" "}]
["%Gmm @ Ninitial",null,null,null,null,"  #8",{"$f":"Agg!E51","v":" "},{"$f":"IF(Agg!$C$52=0,\" \",Agg!I35)","v":" "}]
["%Gmm @ Nmaximum",{"$f":"'Gyratory Data'!B33","v":" "},null,null,null," #16",{"$f":"Agg!E52","v":" "},{"$f":"IF(Agg!$C$52=0,\" \",Agg!I36)","v":" "}]
["AC Film Thickness (m)",{"$f":"IF(B22=0,\" \",J32/(Agg!N55*B24*(1-(B22/100)))*30480000)","v":" "},null,null,null," #30   ",{"$f":"Agg!E53","v":" "},{"$f":"IF(Agg!$C$52=0,\" \",Agg!I37)","v":" "},null,{"$f":"((B24*B22)/100)/(Agg!F14*62.4)","v":{"$error":"#DIV/0!"}}]
["Dust/Effective AC Ratio",{"$f":"IF(B22=0,\" \",G32/(B22-(J30*(100-B22))))","v":" "},null,null,null," #50",{"$f":"Agg!E54","v":" "},{"$f":"IF(Agg!$C$52=0,\" \",Agg!I38)","v":" "},null,{"$f":"((H47-H43)/(H47*H43))*Agg!F14","v":{"$error":"#VALUE!"}}]
["Fine Agg Angularity (%)",{"$f":"IF('Agg Prop'!D56=0,\" \",'Agg Prop'!D56)","v":" "},null,null,null,"#100",{"$f":"Agg!E55","v":" "},{"$f":"IF(Agg!$C$52=0,\" \",Agg!I39)","v":" "},null,{"$f":"(J30*(B24*(1-(B22/100))))/(Agg!F14*62.4)","v":{"$error":"#VALUE!"}}]
["Sand Equivalent (%)",{"$f":"IF('Agg Prop'!D58=0,\" \",'Agg Prop'!D58)","v":{"$error":"#VALUE!"}},null,null,null,"#200",{"$f":"Agg!E56","v":" "},{"$f":"IF(Agg!$C$52=0,\" \",Agg!I40)","v":" "},null,{"$f":"J29-J31","v":{"$error":"#DIV/0!"}}]
["Fractured Particles (%)",{"$f":"IF('Agg Prop'!D59=0,\" \",'Agg Prop'!D59)","v":" "}]
["Flat/Elongated Pieces (%)",{"$f":"IF('Agg Prop'!D60=\" \",\" \",'Agg Prop'!D60)","v":" "},null,null,null,{"$f":"IF(Agg!C52=0,\" \",\"Virgin Add AC at 3% Air Voids\")","v":" "},null,{"$f":"IF(Agg!C52=0,\" \",+B21-((Agg!C52/100)*'Batch Wts'!C13))","v":" "}]
[null,null,null,null,null,{"$f":"IF(Agg!C52=0,\" \",\"Virgin Agg. FAA (%)\")","v":" "},null,{"$f":"IF('Agg Prop'!D57=0,\" \",'Agg Prop'!D57)","v":" "}]
["Maximum SpG @ Ndes",{"$f":"IF(B23=0,\" \",((B23/(100-B24))/62.4)*100)","v":" "}]
[null,null,null,null,null,"Asphalt Absorption (%)",null,{"$f":"IF('Mix Data'!D58=0,\" \",'Mix Data'!D58)","v":" "}]
["Final Aggregate Blend (%)",null,null,null,null,"Water Absorption (%)",null,{"$f":"IF('Agg Prop'!D28=0,\" \",'Agg Prop'!D28)","v":" "}]
[{"$f":"IF(Agg!C47=0,\" \",Agg!C47)","v":" "},{"$f":"IF(Agg!B27=0,\" \",Agg!B27)","v":" "},null,{"$f":"IF(Agg!B28=0,\" \",Agg!B28)","v":" "},null,"Light Wt Particles (%)"]
[{"$f":"IF(Agg!C48=0,\" \",Agg!C48)","v":" "},{"$f":"IF(Agg!C27=0,\" \",Agg!C27)","v":" "},null,{"$f":"IF(Agg!C28=0,\" \",Agg!C28)","v":" "},null,"Toughness (% Loss)"]
[{"$f":"IF(Agg!C49=0,\" \",Agg!C49)","v":" "},{"$f":"IF(Agg!D27=0,\" \",Agg!D27)","v":" "},null,{"$f":"IF(Agg!D28=0,\" \",Agg!D28)","v":" "}]
[{"$f":"IF(Agg!C50=0,\" \",Agg!C50)","v":" "},{"$f":"IF(Agg!E27=0,\" \",Agg!E27)","v":" "},null,{"$f":"IF(Agg!E28=0,\" \",Agg!E28)","v":" "},null,"Specific Gravity Information"]
[{"$f":"IF(Agg!C51=0,\" \",Agg!C51)","v":" "},{"$f":"IF(Agg!F27=0,\" \",Agg!F27)","v":" "},null,{"$f":"IF(Agg!F28=0,\" \",Agg!F28)","v":" "},null,"Combined Bulk (Gsb)",null,{"$f":"IF('Agg Prop'!D24=0,\" \",'Agg Prop'!D24)","v":" "}]
[{"$f":"IF(Agg!C52=0,\" \",Agg!C52)","v":" "},{"$f":"IF(Agg!C52=0,\" \",\"RAP\")","v":" "}]
[null,null,null,null,null,"-No. 4 Virgin Bulk (Gsb)",null,{"$f":"'Agg Prop'!D26","v":" "}]
[null,null,null,null,null,"Apparent (Gsa)",null,{"$f":"IF('Agg Prop'!D27=0,\" \",'Agg Prop'!D27)","v":" "}]
[null,null,null,null,null,"Effective (Gme)",null,{"$f":"IF(B22=0,\" \",'Mix Data'!C46)","v":" "}]
["Remarks:"]
[]
[]
[]
[]
[]
[]
["Mix Design Technician & ID:",{"$f":"IF(Agg!B21=0,\" \",Agg!B21)","v":" "}]
[]
["Distribution:"]
["Materials and Research "]
[{"$f":"Agg!B11","v":0}]

{"sheet":"Graphs","index":6,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":false,"merged":[[8,13,8,14],[12,13,12,15],[13,13,13,15],[9,13,9,14],[11,13,11,14],[10,13,10,14]]}
["SUPERPAVE HOT MIX DESIGN GRAPHS",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Agg!B8=0,\" \",Agg!B8)","v":" "},null,null,null,{"$f":"Agg!B13","v":"00:00:00"}]
["Department of Transportation, Materials and Research (Rev. 3-22)"]
[null,null,null,null,null,null," "," ",null," "," ",null," "," "," "]
[]
[]
[]
[]
[]
["AC%","UNIT",null,null,null,null,null,null,null,"AC%","Air",null,null,"Unit Weight Vs % AC"]
[null,"WT.",null,null,null,null,null,null,null,null,"Voids",null,null,"Air Voids Vs % AC"]
[{"$f":"'Batch Wts'!$C$8","v":0},{"$f":"'Mix Data'!G$11","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$C$8","v":0},{"$f":"'Mix Data'!D$55","v":" "},null,null,"VMA Vs % AC"]
[{"$f":"'Batch Wts'!$D$8","v":0},{"$f":"'Mix Data'!G$15","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$D$8","v":0},{"$f":"'Mix Data'!E$55","v":" "},null,null,"VFA Vs % AC"]
[{"$f":"'Batch Wts'!$E$8","v":0},{"$f":"'Mix Data'!G$19","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$E$8","v":0},{"$f":"'Mix Data'!F$55","v":" "},null,null,"%Gmm at Nini Vs % AC"]
[{"$f":"'Batch Wts'!$F$8","v":0},{"$f":"'Mix Data'!G$23","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$F$8","v":0},{"$f":"'Mix Data'!G$55","v":" "},null,null,"Theo. Max. SpG Vs % AC"]
[{"$f":"'Batch Wts'!$G$8","v":0},{"$f":"'Mix Data'!G$27","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$G$8","v":0},{"$f":"'Mix Data'!H$55","v":" "}]
[]
[]
[]
[]
[]
[]
[]
["AC%","VMA",null,null,null,null,null,null,null,"AC%","VFA"]
[]
[{"$f":"'Batch Wts'!$C$8","v":0},{"$f":"'Mix Data'!D$56","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$C$8","v":0},{"$f":"'Mix Data'!D$57","v":" "}]
[{"$f":"'Batch Wts'!$D$8","v":0},{"$f":"'Mix Data'!E$56","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$D$8","v":0},{"$f":"'Mix Data'!E$57","v":" "}]
[{"$f":"'Batch Wts'!$E$8","v":0},{"$f":"'Mix Data'!F$56","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$E$8","v":0},{"$f":"'Mix Data'!F$57","v":" "}]
[{"$f":"'Batch Wts'!$F$8","v":0},{"$f":"'Mix Data'!G$56","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$F$8","v":0},{"$f":"'Mix Data'!G$57","v":" "}]
[{"$f":"'Batch Wts'!$G$8","v":0},{"$f":"'Mix Data'!H$56","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$G$8","v":0},{"$f":"'Mix Data'!H$57","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
["AC%","%Gmm",null,null,null,null,null,null,null,"AC%","Max"]
[null,null,null,null,null,null,null,null,null,null,"SpG"]
[{"$f":"'Batch Wts'!$C$8","v":0},{"$f":"'Gyratory Data'!B$21","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$C$8","v":0},{"$f":"'Mix Data'!B$42","v":" "}]
[{"$f":"'Batch Wts'!$D$8","v":0},{"$f":"'Gyratory Data'!D$21","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$D$8","v":0},{"$f":"'Mix Data'!D$42","v":" "}]
[{"$f":"'Batch Wts'!$E$8","v":0},{"$f":"'Gyratory Data'!F$21","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$E$8","v":0},{"$f":"'Mix Data'!F$42","v":" "}]
[{"$f":"'Batch Wts'!$F$8","v":0},{"$f":"'Gyratory Data'!H$21","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$F$8","v":0},{"$f":"'Mix Data'!H$42","v":" "}]
[{"$f":"'Batch Wts'!$G$8","v":0},{"$f":"'Gyratory Data'!J$21","v":" "},null,null,null,null,null,null,null,{"$f":"'Batch Wts'!$G$8","v":0},{"$f":"'Mix Data'!J$42","v":" "}]

{"sheet":"45 Chart","index":7,"n_rows":24,"n_cols":23,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,"Sieve","%",null,"Lower","Upper"]
[null,"Sieve","Size (M)","Passing","MDL","Spec","Spec"]
[null,"Size (M)","^0.45",null,null,"Range","Range"]
[0,0,0,0,0,0,0]
["No 200",7.4999999999999993E-5,{"$f":"B5^0.45","v":1.3924434561459077E-2},{"$f":"Agg!E56","v":" "},{"$f":"C5*(100/$B$19)","v":{"$error":"#DIV/0!"}},{"$f":"Agg!F56","v":2},{"$f":"Agg!G56","v":7}," "," "]
[null,1.5000000000000001E-4,1.9021338163495327E-2,{"$f":"Agg!E55","v":" "},{"$error":"#DIV/0!"}]
[{"$f":"[1]Gradations!D55","v":"#50 "},3.0000000000000003E-4,2.5983913668673343E-2,{"$f":"Agg!E54","v":" "},{"$error":"#DIV/0!"}]
[{"$f":"[1]Gradations!D54","v":"#30 "},6.0000000000000006E-4,3.5495072099438578E-2,{"$f":"Agg!E53","v":" "},{"$error":"#DIV/0!"}]
[{"$f":"[1]Gradations!D53","v":"#16"},1.1800000000000001E-3,4.8122358402082642E-2,{"$f":"Agg!E52","v":" "},{"$error":"#DIV/0!"}]
[{"$f":"[1]Gradations!D52","v":"#8"},2.3600000000000001E-3,6.5737078827208015E-2,{"$f":"Agg!E51","v":" "},{"$error":"#DIV/0!"},{"$f":"Agg!F51","v":0},{"$f":"Agg!G51","v":0}]
[{"$f":"[1]Gradations!D51","v":"#4"},4.7499999999999999E-3,9.0055890357662996E-2,{"$f":"Agg!E50","v":" "},{"$error":"#DIV/0!"}]
[{"$f":"[1]Gradations!D50","v":"3/8\""},9.4999999999999998E-3,0.12301997158642765,{"$f":"Agg!E49","v":" "},{"$error":"#DIV/0!"}]
[{"$f":"[1]Gradations!D49","v":"1/2\""},1.2500000000000001E-2,0.13919047145675678,{"$f":"Agg!E48","v":" "},{"$error":"#DIV/0!"},{"$f":"Agg!F48","v":90},{"$f":"Agg!G48","v":100}]
[{"$f":"[1]Gradations!D48","v":"5/8\""},1.5900000000000001E-2,0.15510603853425475,{"$f":"Agg!E47","v":" "},{"$error":"#DIV/0!"},{"$f":"Agg!F47","v":100},{"$f":"Agg!G47","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[{"$f":"'[1]Agg Prop and Batch Wts'!#REF!","v":{"$error":"#REF!"}},1.9E-2,0.16805023357184212,{"$f":"IF('[1]Agg Prop and Batch Wts'!#REF!=0,DEL,'[1]Agg Prop and Batch Wts'!#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},{"$f":"IF('[1]Agg Prop and Batch Wts'!#REF!=0,\"\",'[1]Agg Prop and Batch Wts'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('[1]Agg Prop and Batch Wts'!#REF!=0,\"\",'[1]Agg Prop and Batch Wts'!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"'[1]Agg Prop and Batch Wts'!#REF!","v":{"$error":"#REF!"}},2.5000000000000001E-2,0.19013978736655335,{"$f":"IF('[1]Agg Prop and Batch Wts'!#REF!=0,DEL,'[1]Agg Prop and Batch Wts'!#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},{"$f":"IF('[1]Agg Prop and Batch Wts'!#REF!=0,\"\",'[1]Agg Prop and Batch Wts'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('[1]Agg Prop and Batch Wts'!#REF!=0,\"\",'[1]Agg Prop and Batch Wts'!#REF!)","v":{"$error":"#REF!"}}]
[]
["Max Sieve","Slope (m)"]
[{"$f":"IF(D15<99.9,C16,0)","v":{"$error":"#REF!"}},{"$f":"LARGE(A20:A24,1)","v":0}]
[{"$f":"IF(D14<99.9,C15,0)","v":0}]
[{"$f":"IF(D13<99.9,C14,0)","v":0}]
[{"$f":"IF(D12<99.9,C13,0)","v":0}]
[{"$f":"IF(D11<99.9,C12,0)","v":0}]
[{"$f":"IF(D10<99.9,C11,0)","v":0}]

{"sheet":"Batch Wts","index":8,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Batch Weights",null,null,null,null,{"$f":"IF(Agg!B8=0,\" \",Agg!B8)","v":" "}]
["Superpave Mix Design",null,null,null,null,{"$f":"IF(Agg!B9=0,\" \",Agg!B9)","v":" "}]
["Department of Transportation, Materials and Research (Rev. 3-22)",null,null,null,null,{"$f":"Agg!B13","v":"00:00:00"}]
[]
["MIX DESIGN BATCH WEIGHTS"]
[]
[null,null,"Batch 1","Batch 2","Batch 3","Batch 4","Batch 5",null,{"$f":"+(100-C13)","v":100},"% agg in RAP"]
["AC Contents Used in Mix Design (%):",null,null,null,null,null,null,null,{"$f":"+(I7/100)*(G18)","v":0},"wt agg in RAP"]
[null,null,null,null,null,null,null,null,{"$f":"+G18-I8","v":0},"wt AC in RAP"]
["Aggregate Wt per Batch (g):",null,null,null,null,null,null,null,{"$f":"+(B18+C18+D18+E18+F18)+I8","v":0},"New batch wt of agg"]
["# of AC Percentages used in Design:",null,null,null,null,null,null,null,{"$f":"+($I$10/(100-C8))*100","v":0},"Corrected batch wt incl AC"]
[null,null,null,null,null,null,null,null,{"$f":"+($I$10/(100-D8))*100","v":0}]
["RAP Asphalt Content:",null,null,null,null,null,null,null,{"$f":"+($I$10/(100-E8))*100","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+($I$10/(100-F8))*100","v":0}]
["Batch Weights",null,null,null,null,null,null,null,{"$f":"+($I$10/(100-G8))*100","v":0}]
[null,"Agg #1","Agg #2","Agg #3","Agg #4","Agg #5","Recycled",null,{"$f":"+I11-I10","v":0},"Grams AC needed"]
[null,{"$f":"IF(Agg!B$27=0,\" \",Agg!B$27)","v":" "},{"$f":"IF(Agg!C$27=0,\" \",Agg!C$27)","v":" "},{"$f":"IF(Agg!D$27=0,\" \",Agg!D$27)","v":" "},{"$f":"IF(Agg!E$27=0,\" \",Agg!E$27)","v":" "},{"$f":"IF(Agg!F$27=0,\" \",Agg!F$27)","v":" "},"Pavement",null,{"$f":"+I16-I9","v":0},"Grams virgin AC to add"]
["Tot. Aggregate/Batch (g)",{"$f":"($C$10*Agg!C47/100)","v":0},{"$f":"($C$10*Agg!C48/100)","v":0},{"$f":"($C$10*Agg!C49/100)","v":0},{"$f":"($C$10*Agg!C50/100)","v":0},{"$f":"($C$10*Agg!C51/100)","v":0},{"$f":"($C$10*Agg!C52/100)/(100-$C$13)*100","v":0}]
[]
[null,null,null,null,null,null,"Total RAP"]
["+3/8 Material",{"$f":"(100-Agg!B33)*B18/100","v":0},{"$f":"(100-Agg!C33)*C18/100","v":0},{"$f":"(100-Agg!D33)*D18/100","v":0},{"$f":"(100-Agg!E33)*E18/100","v":0},{"$f":"(100-Agg!F33)*F18/100","v":0},"to Add:"]
["-3/8, +#4 Material",{"$f":"(Agg!B33-Agg!B34)*B18/100","v":0},{"$f":"(Agg!C33-Agg!C34)*C18/100","v":0},{"$f":"(Agg!D33-Agg!D34)*D18/100","v":0},{"$f":"(Agg!E33-Agg!E34)*E18/100","v":0},{"$f":"(Agg!F33-Agg!F34)*F18/100","v":0},{"$f":"+G18","v":0}]
["-#4 Material",{"$f":"(Agg!B34)*B18/100","v":0},{"$f":"(Agg!C34)*C18/100","v":0},{"$f":"(Agg!D34)*D18/100","v":0},{"$f":"(Agg!E34)*E18/100","v":0},{"$f":"(Agg!F34)*F18/100","v":0}]
[]
[]
["AC and Total Batch Weight"]
["AC Content (%)",null,{"$f":"IF(C$8=0,\" \",C$8)","v":" "},{"$f":"IF(D$8=0,\" \",D$8)","v":" "},{"$f":"IF(E$8=0,\" \",E$8)","v":" "},{"$f":"IF(F$8=0,\" \",F$8)","v":" "},{"$f":"IF(G$8=0,\" \",G$8)","v":" "}]
["Weight of total AC (g)"," ",{"$f":"IF(C8=0,\" \",($C$10/((100-C27)/100))-$C$10)","v":" "},{"$f":"IF(D8=0,\" \",($C$10/((100-D27)/100))-$C$10)","v":" "}," "," "," "]
[{"$f":"IF(G23=\" \",\" \",\"Weight of Virgin AC: Add Oil (g)\")","v":"Weight of Virgin AC: Add Oil (g)"},null,{"$f":"IF($G$18=0,\" \",C28-($G$18-($C$10*Agg!$C$52/100)))","v":" "},{"$f":"IF($G$18=0,\" \",D28-($G$18-($C$10*Agg!$C$52/100)))","v":" "},{"$f":"IF($G$18=0,\" \",E28-($G$18-($C$10*Agg!$C$52/100)))","v":" "},{"$f":"IF($G$18=0,\" \",F28-($G$18-($C$10*Agg!$C$52/100)))","v":" "},{"$f":"IF($G$18=0,\" \",G28-($G$18-($C$10*Agg!$C$52/100)))","v":" "}]
["Total Batch Wt (g)",null,{"$f":"IF(C8=0,\" \",$C$10+C28)","v":" "},{"$f":"IF(D8=0,\" \",$C$10+D28)","v":" "},{"$f":"IF(E8=0,\" \",$C$10+E28)","v":" "},{"$f":"IF(F8=0,\" \",$C$10+F28)","v":" "},{"$f":"IF(G8=0,\" \",$C$10+G28)","v":" "}]

{"sheet":"Print Mix Design or Batch Wts","index":9,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Touch the shaded area to print the entire mix design or batch weights."]

{"sheet":"M","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"N","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"O","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"P","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Q","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"R","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"S","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"T","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"U","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"V","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"W","index":20,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"X","index":21,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Y","index":22,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Z","index":23,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AA","index":24,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AB","index":25,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AC","index":26,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AD","index":27,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AE","index":28,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AF","index":29,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AG","index":30,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AH","index":31,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AI","index":32,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AJ","index":33,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AK","index":34,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AL","index":35,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AM","index":36,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AN","index":37,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AO","index":38,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AP","index":39,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AQ","index":40,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AR","index":41,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AS","index":42,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AT","index":43,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AU","index":44,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AV","index":45,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AW","index":46,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AX","index":47,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AY","index":48,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AZ","index":49,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BA","index":50,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BB","index":51,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BC","index":52,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BD","index":53,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BE","index":54,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BF","index":55,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BG","index":56,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BH","index":57,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BI","index":58,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BJ","index":59,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BK","index":60,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BL","index":61,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BM","index":62,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BN","index":63,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BO","index":64,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BP","index":65,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BQ","index":66,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BR","index":67,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BS","index":68,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BT","index":69,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BU","index":70,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BV","index":71,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BW","index":72,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BX","index":73,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BY","index":74,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BZ","index":75,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CA","index":76,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CB","index":77,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CC","index":78,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CD","index":79,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CE","index":80,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Compatibility Report","index":81,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Compatibility Report for Copy of Blank Superpave 2014.xls"]
[null,"Run on 5/12/2014 13:18"]
[]
[null,"The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when opening this workbook in an earlier version of Excel or if you save this workbook in an earlier file format."]
[]
[null,"Minor loss of fidelity",null,null,"# of occurrences","Version"]
[]
[null,"Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.",null,null,8]
[null,null,null,null,"45 Chart'!A7:A14","Excel 97-2003"]