{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["JMF1","Stuff","Random Number","Gauge Correction & small quan.","DUST COATING & FUEL CONT. ","EXTRACTION","BURNOUT OVEN ","Ag Belt Samp. + RAP Belt Sample","LOI ","RICE GRAVITY (Gmm)","Marshall Worksheet","TSR"," MOIST TEST","DAILY PLANT REPORT","TANK RECORD A.C.","RECAP SHEET  ","Mix Control Chart","HMA Producers","Terminals","Tack Coat","Sheet1"],"not_rendered":{"charts":5,"images":5,"macros":1,"external_links":4,"defined_names":64,"comments":3,"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":"JMF1","index":0,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[8,2,8,8],[62,2,62,4],[41,6,42,6],[41,7,42,7],[61,0,61,1],[61,2,61,4],[62,0,62,1],[62,6,62,9],[38,0,38,2],[38,3,38,4],[38,5,38,7],[38,8,38,9],[40,1,40,7],[41,1,42,1],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[35,2,35,3],[35,5,35,6],[35,8,35,9],[36,0,36,4],[36,5,36,9],[37,0,37,2],[37,3,37,4],[37,5,37,7],[37,8,37,9],[33,0,33,1],[33,3,33,4],[33,6,33,7],[33,8,33,9],[34,0,34,1],[34,5,34,7],[34,8,34,9],[30,0,30,2],[30,3,30,4],[30,5,30,7],[30,8,30,9],[31,0,31,2],[31,3,31,4],[31,5,31,7],[31,8,31,9],[26,0,26,2],[26,3,26,5],[26,6,26,7],[26,8,26,9],[27,8,27,9],[28,0,28,1],[28,2,28,4],[28,5,28,7],[28,8,28,9],[23,0,23,1],[23,2,23,3],[23,4,23,7],[23,8,23,9],[24,0,24,1],[24,3,24,5],[24,8,24,9],[21,0,21,1],[21,2,21,3],[21,4,21,7],[21,8,21,9],[22,0,22,1],[22,2,22,3],[22,4,22,7],[22,8,22,9],[7,2,7,4],[7,7,7,8],[9,2,9,8],[19,0,19,1],[19,2,19,3],[19,4,19,7],[19,8,19,9],[20,0,20,1],[20,2,20,3],[20,4,20,7],[20,8,20,9],[17,0,17,1],[17,2,17,3],[17,4,17,7],[17,8,17,9],[18,0,18,1],[18,2,18,3],[18,4,18,7],[18,8,18,9],[15,0,15,1],[15,2,15,3],[15,4,15,7],[15,8,15,9],[16,0,16,1],[16,4,16,7],[16,8,16,9],[11,1,11,2],[11,4,11,6],[11,8,11,9],[13,0,13,1],[13,2,13,4],[13,5,13,6],[13,7,13,9],[25,0,25,1],[25,3,25,7],[0,0,0,9],[2,0,2,1],[2,2,2,4],[2,5,2,6],[2,7,2,8],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,8],[6,0,6,1],[6,2,6,4],[6,5,6,6],[6,7,6,8],[8,0,8,1],[4,0,4,1],[4,2,4,4],[4,5,4,6],[4,7,4,8],[5,0,5,1],[5,2,5,4],[5,7,5,8],[16,2,16,3]]}
["STATE OF TENNESSEE ASPHALT JOB MIX FORMULA"]
["V1. 3-RAPs"]
["Project Ref. No.",null,null,null,null,"Date Signed"]
["Project No.",null,null,null,null,"Region"]
["Contract No.",null,null,null,null,"County"]
["Contractor",null,null,null,null,"Date of Letting",null,null,null,"2005-02-10"]
["State Route No.",null,null,null,null,"Roadway Surface"]
["Make of Plant",null,null,null,null,"Location of Plant"]
["Hot-mix Producer"]
["Producer Address"]
[]
["Type",{"$f":"VLOOKUP(Stuff!C1,Stuff!A2:S16,19)","v":"ACS-HM"},{"$f":"VLOOKUP([3]Stuff!#REF!,[3]Stuff!$A$2:$B$22,2)","v":{"$error":"#REF!"}},"Mix",{"$f":"VLOOKUP(Stuff!C1,Stuff!A2:B17,2)&\" \"&VLOOKUP(Stuff!AB17,Stuff!X18:Y28,2)","v":"OGFC "},null,null,"Item"]
[]
["Serial No.:",null,null,null,null,"Design No.:"]
[]
["Material",null,"Size or Grade",null,"Producer and Location",null,null,null,"Percent Used"]
[{"$f":"VLOOKUP(Stuff!AH78,Stuff!$AC$30:$AD$63,2)","v":0},null,{"$f":"VLOOKUP(Stuff!AI78,Stuff!AF$64:AG$71,2)","v":0},null,null,null,null,null,{"$f":"$B$44*(100-$G$25)/100","v":93},{"$f":"E31*(100-D32)/100","v":0}]
[{"$f":"VLOOKUP(Stuff!AH79,Stuff!$AC$30:$AD$63,2)","v":0},null,{"$f":"VLOOKUP(Stuff!AI79,Stuff!AF$64:AG$71,2)","v":0},null,null,null,null,null,{"$f":"$C$44*(100-$G$25)/100","v":0},{"$f":"E32*(100-D33)/100","v":0}]
[{"$f":"VLOOKUP(Stuff!AH80,Stuff!$AC$30:$AD$63,2)","v":0},null,{"$f":"VLOOKUP(Stuff!AI80,Stuff!AF$64:AG$71,2)","v":0},null,null,null,null,null,{"$f":"$D$44*(100-$G$25)/100","v":0},{"$f":"E33*(100-D34)/100","v":{"$error":"#VALUE!"}}]
[{"$f":"VLOOKUP(Stuff!AH81,Stuff!$AC$30:$AD$63,2)","v":0},null,{"$f":"VLOOKUP(Stuff!AI81,Stuff!AF$64:AG$71,2)","v":0},null,null,null,null,null,{"$f":"$E$44*(100-$G$25)/100","v":0},{"$f":"E34*(100-D35)/100","v":0}]
[{"$f":"VLOOKUP(Stuff!AH82,Stuff!$AC$30:$AD$63,2)","v":0},null,{"$f":"VLOOKUP(Stuff!AI82,Stuff!AF$64:AG$71,2)","v":0},null,null,null,null,null,{"$f":"$F$44*(100-$G$25)/100","v":0},{"$f":"E35*(100-D36)/100","v":0}]
[{"$f":"VLOOKUP(Stuff!AH83,Stuff!$AC$30:$AD$63,2)","v":0},null,{"$f":"VLOOKUP(Stuff!AI83,Stuff!AF$64:AG$76,2)","v":0},null,null,null,null,null,{"$f":"IF(C25=0,G44*(100-G25)/100,((G44*(100-G25)/(100-C25))))","v":0},{"$f":"J35*(100-D37)/100","v":0}]
[{"$f":"VLOOKUP(Stuff!AH84,Stuff!$AC$30:$AD$63,2)","v":0},null,{"$f":"VLOOKUP(Stuff!AI84,Stuff!AF$64:AG$76,2)","v":0},null,null,null,null,null,{"$f":"IF(C26=0,H44*(100-G25)/100,((H44*(100-G25)/(100-C26))))","v":0},{"$f":"IF(I37=0,I33*(100-D34)/100,((I33*(100-D34)/(100-I37))))","v":{"$error":"#VALUE!"}}]
["Asphalt Cement",null,{"$f":"(VLOOKUP(Stuff!AB17,Stuff!X18:Z28,3))","v":0},null,{"$f":"Terminals!D1","v":0},null,null,null,{"$f":"IF(AND(C25=0,C26=0),G25,(IF(AND(C25<>0,C26=0),G25-I22*C25/100,(IF(AND(C25=0,C26<>0),G25-(I23*C26/100),G25-(I22*C25/100)-(I23*C26/100))))))","v":7},{"$f":"IF(I37=0,D34,D34-I33*I37/100)","v":"T.S.R.:"}]
["Percent AC in RAP1:",null,null,"Optimum AC Content:",null,null,7,"Total",{"$f":"SUM(I17:I24)","v":100}]
["Percent AC in RAP2:"]
["Anti-Strip Additive:",null,null,null,null,null,"Dosage:"]
["AC Contribution:",null,"Virgin AC",{"$f":"I24","v":7},"RAP AC",{"$f":"G25-I24","v":0},"Percent Virgin AC:",null,{"$f":"(I24/G25*100)","v":100}]
["Asphalt Sp. Gravity:",null,1.032,null,null,"Dust to Asphalt Ratio:"]
[]
["% Fracture Face on CA:",null,null,null,null,"% Glassy Particles on CA:"]
["Theo.Gravity of RAP:",null,null,null,null,"Eff. Gravity of Agg:"]
[]
["Theo. Gravity of Mix:",null,null,"T.S.R.:",null,null,"Lbs/Ft3:",null,{"$f":"(62.4*C34)","v":0}]
["L.O.I.:",null,5,null,null,"Ignition Oven Corr. Factor:",null,null,0.45]
["ADT",null,"Log Miles",null,"Beginning:",null,null,"Ending:"]
["Lab Temperature",null,null,null,null,"Plant Temperature"]
["Mixing Temperature (± 5 °F):",null,null,null,null,"Mixing Temp Range(°F):",null,null,{"$f":"IF(AND((OR(Stuff!C1=3,Stuff!C1=4)),(OR(Stuff!AB17=2,Stuff!AB17=3,Stuff!AB17=7,Stuff!AB17=8))),\"225°F ≤ T ≤ 275°F\",IF(OR(Stuff!C1=3,Stuff!C1=4),\"275°F ≤ T ≤ 330°F\",VLOOKUP(Stuff!AB17,Stuff!X18:AA28,4)))","v":0}]
["Lab Compaction Temp (± 5 °F):",null,null,null,null,"Delivery Temperature(°F):",null,null,{"$f":"IF(AND((OR(Stuff!C1=3,Stuff!C1=4)),(OR(Stuff!AB17=2,Stuff!AB17=3,Stuff!AB17=7,Stuff!AB17=8))),\"225°F ≤ T ≤ 275°F\",IF(OR(Stuff!C1=3,Stuff!C1=4),\"275°F ≤ T ≤ 330°F\",VLOOKUP(Stuff!AB17,Stuff!X18:AA28,4)))","v":0}]
[]
[null,"Percents Used"]
[null,{"$f":"A17","v":0},{"$f":"A18","v":0},{"$f":"A19","v":0},{"$f":"A20","v":0},{"$f":"A21","v":0},{"$f":"A22","v":0},{"$f":"A23","v":0}]
["Sieve",null,null,null,null,null,null,null,"% Req.","Design"]
["Size",100,null,null,null,null,null,null,{"$f":"SUM(B44:H44)","v":100},"Range"]
["2\"",null,null,null,null,null,null,null,{"$f":"ROUND((B45*$B$44+C45*$C$44+D45*$D$44+E45*$E$44+F45*$F$44+G45*$G$44+H45*$H$44)/100,0)","v":0},{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$16,4))","v":0}]
["1.5\"",null,null,null,null,null,null,null,0,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,5))","v":0}]
["1.25\"",50,null,null,null,null,null,null,50,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,6))","v":0}]
["1\"",50,null,null,null,null,null,null,50,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,7))","v":0}]
["3/4\"",50,null,null,null,null,null,null,50,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,8))","v":100}]
["5/8\"",50,null,null,null,null,null,null,50,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,9))","v":0}]
["1/2\"",48,null,null,null,null,null,null,48,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,10))","v":"85-100"}]
["3/8\"",48,null,null,null,null,null,null,48,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,11))","v":"55-75"}]
["No.4",48,null,null,null,null,null,null,48,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,12))","v":"10-25"}]
["No.8",37,null,null,null,null,null,null,37,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,13))","v":"5-10"}]
["No.16",37,null,null,null,null,null,null,37,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,14))","v":0}]
["No.30",37,null,null,null,null,null,null,37,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,15))","v":0}]
["No.50",25,null,null,null,null,null,null,25,{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,16))","v":0}]
["No.100",25,null,null,null,null,null,null,{"$f":"ROUND((B58*$B$44+C58*$C$44+D58*$D$44+E58*$E$44+F58*$F$44+G58*$G$44+H58*$H$44)/100,0)","v":25},{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,17))","v":0}]
["No.200",10,null,null,null,null,null,null,{"$f":"ROUND((B59*$B$44+C59*$C$44+D59*$D$44+E59*$E$44+F59*$F$44+G59*$G$44+H59*$H$44)/100,1)","v":10},{"$f":"IF(Stuff!$C$1=0,\"\",VLOOKUP(Stuff!$C$1,Stuff!$A$2:$R$17,18))","v":"2-4"}]
[]
[]
["Contractor Lab Tech."]
["T.D.O.T. Plant Insp.",null,null,null,null,"Title"]

{"sheet":"Stuff","index":1,"n_rows":99,"n_cols":43,"rows_kept":99,"cut":false,"hidden":false,"merged":[[1,20,1,21],[84,35,84,36]]}
["MIX TYPE",null,16,"2\"","1.5\"","1.25\"","1\"","3/4\"","5/8\"","1/2\"","3/8\"","#4","#8","#16","#30","#50","#100","#200"]
[1," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Void Range",null,"DAR"]
[2,"307-A",null,100,"81-100",null,null,"50-71",null,null,"35-50","24-36","13-27",null,"7-17",null,"0-10","0-4.5","BPMB-HM","307-A"]
[3,"307-AS",null,100,"75-100",null,null,"55-80",null,null,null,"7-11",null,null,null,null,"0-6","0-4.5","BPMB-HM","307-AS"]
[4,"313-TPB",null,"100","70-100",null,null,"55-80",null,null,null,"0-11",null,null,null,null,"0-4","0-3","BPMB-HM","313-TPB"," - "," - "]
[5,"307-BM",null,null,null,null,"100","85-100",null,null,"59-79","42-61","29-47",null,"13-27","7-20","4-10","0-6.5","BPMB-HM","307-BM",3,5.5,"0.6 - 1.5"]
[6,"307-BM2",null,null,null,100,null,"81-93",null,null,"57-73","40-56","28-43",null,"13-25","9-19","6-10","2.5-6.5","BPMB-HM","307-BM2",3,5.5,"0.6 - 1.5"]
[7,"307-C",null,null,null,null,null,"100",null,null,"70-90","39-66","23-47",null,"10-27","8-15","4-8","2.5-6.5","BPMB-HM","307-C",3,5.5,"0.6 - 1.5"]
[8,"307-CW",null,null,null,null,null,"100",null,null,"75-100",null,"43-67",null,"23-47",null,"4-10","2.5-6.5","BPMB-HM","307-CW",3,5,"0.6 - 1.5"]
[9,"307-CS",null,null,null,null,null,null,null,null,"100","89-94","53-77",null,"23-42",null,"9-18","6-13.5","BPMB-HM","307-CS",1,5]
[10,"411-D",null,null,null,null,null,null,"100","95-100","80-93","54-76","35-57",null,"17-29","10-18","3-10","0-6.5","ACS-HM","411-D",3,5.5,"0.6 - 1.2"]
[11,"411-D (low volume)",null,null,null,null,null,null,"100","95-100","80-93","54-76","35-57",null,"17-29","10-18","3-10","0-6.5","ACS-HM","411-D(low volume)",2,5,"0.6 - 1.2"]
[12,"411-E",null,null,null,null,null,null,"100","95-100","80-93","54-76","35-57",null,"17-29","10-18","3-11","0-8","ACS-HM","411-E",3,5.5]
[13,"411-E (shoulders)",null,null,null,null,null,null,100,"95-100","80-93","54-76","35-57",null,"17-29","10-18","3-11","0-8","ACS-HM","411-E(shoulder)",2,5]
[14,"411-TL",null,null,null,null,null,null,null,null,100,"89-94","53-77",null,"23-42",null,"9-18","6-14","ACS-HM","411 TL",3,5.5]
[15,"411-TLD/TLE",null,null,null,null,null,null,null,100,"90-100","54-76","35-57",null,"17-33","10-18","3-10","4-7","ACS-HM","411 TLD",3,5.5]
[16,"OGFC",null,null,null,null,null,100,null,"85-100","55-75","10-25","5-10",null,null,null,null,"2-4","ACS-HM","411 OGFC",20,null,null,"ac Grade +  RAP",null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"PG 64-22","PG 64-22","270ºF ≤ T ≤ 310ºF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"PG 67-22","PG 67-22","270ºF ≤ T ≤ 310ºF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"PG 70-22","PG 70-22","290ºF ≤ T ≤ 330ºF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"PG 76-22","PG 76-22","290ºF ≤ T ≤ 330ºF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"PG 82-22","PG 82-22","290ºF ≤ T ≤ 330ºF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"w/ RAP PG 64-22","PG 64-22","270ºF ≤ T ≤ 310ºF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"w/ Rap PG 67-22","PG 67-22","270ºF ≤ T ≤ 310ºF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"w/ RAP PG 70-22","PG 70-22","290ºF ≤ T ≤ 330ºF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"w/ RAP PG 76-22","PG 76-22","290ºF ≤ T ≤ 330ºF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"w/ RAP PG 82-22","PG 82-22","290ºF ≤ T ≤ 330ºF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGGREGATE TYPE 1",null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,2,"#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,3,"#2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"#24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"#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,6,"#357"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"#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,8,"#467"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"#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,10,"#56"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"#57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"#6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"#67"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"#68"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"#7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"#78"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"D Rock (Limestone)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"BM-2 Rock (Limestone)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"D Rock (Gravel)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"BM-2 Rock (Gravel)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"D Rock (Granite)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"BM-2 Rock (Gravel)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"#8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"#89"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"#9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"#10 (Hard)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"#10 (Soft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"Manufactured Sand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"Natural Sand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"Slag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"Hydrated Lime"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"AG Lime"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"RAP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"Baghouse Fines",null,"AGGREGATE TYPE 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,2,"Coarse Aggregate"]
[null,null,null,null,null,null,null,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,"Medium Coarse Aggregate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Screenings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Washed Screenings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Manufactured Sand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Natural Sand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Mineral Filler"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Non Processed RAP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Recycled Shingles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Minus 3/4 inch Rap"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Minus 1/2 inch Rap"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Minus 5/16 inch Rap"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGGREGATE SELECTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,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,1,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,1,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,1,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,1,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,1,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,1,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,"Tonnage Range"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,2,"0 - 1000"]
[null,null,null,null,null,null,null,null,null,null,null,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,"1001-2000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"2001 - 3000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"3001 - 4000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Strip  test"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Good"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Bad"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"ASA Calcs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Anti-strip based on virgin A.C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Anti-strip based on total A.C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"nuclear guage sheet dropdown"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"12 (Drop High & Low)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"10 (Cores or Less)"]

{"sheet":"Random Number","index":2,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,10,20,12],[21,1,21,2],[21,3,21,6],[21,10,21,12],[22,10,22,12],[19,1,19,2],[19,3,19,6],[19,10,19,12],[0,1,0,14],[3,1,3,2],[3,3,3,5],[3,10,3,11],[5,1,5,2],[5,3,5,5],[7,1,7,2],[7,3,7,5],[7,6,7,11],[17,9,17,10],[18,10,18,12]]}
[null,"TDOT RANDOM NUMBER WORKSHEET"]
[]
[]
[null,"Project Ref #",null,{"$f":"'JMF1'!C3","v":0},null,null,null,null,null,null,"Date:",null,"2017-02-24"]
[]
[null,"Project #",null,{"$f":"'JMF1'!C4","v":0},null,null,null,null,null,null,"Type of Mix:",{"$f":"[4]JMF1!E10","v":""}]
[]
[null,"Contract #",null,{"$f":"'JMF1'!C5","v":0},null,null,"ESTIMATED DAILY PRODUCTION:",null,null,null,null,null,1200]
[]
[null,null,null,null,null,null,null,"Total Tons of Mix:",null,null,null,null,{"$f":"'RECAP SHEET  '!I102","v":2450.69}]
[null,"Sublot #",null,"Sublot ",null,"Random",null,"Sample "]
[null,null,null,"Size",null,"Number",null,"Point"]
[]
[null,1,null,{"$f":"IF(M8=\"\",0,MIN(1000,M8))","v":1000},null,{"$f":"$P$14","v":0.34713949071783223},null,{"$f":"IF(M8=0,\"0\",D14*F14)","v":347.13949071783225},"Ton",null,null,null,null,null,null,0.34713949071783223]
[null,2,null,{"$f":"MIN(1000,$M$8-D14)","v":200},null,{"$f":"F14^F14","v":0.69261325743942492},null,{"$f":"IF(M8=0,\"0\",D15*F15)+1000","v":1138.522651487885},"Ton",null,null,null,null,null,null,0.87045226466043846]
[null,3,null,{"$f":"MIN(1000,$M$8-SUM(D14:D15))","v":0},null,{"$f":"F14*0.9","v":0.31242554164604902},null,{"$f":"IF(M8=0,\"0\",D16*F16)+2000","v":2000},"Ton",null,null,null,null,null,null,7.0012095249262218E-3]
[null,4,null,{"$f":"MIN(1000,$M$8-SUM(D14:D16))","v":0},null,{"$f":"F14*0.75","v":0.26035461803837417},null,{"$f":"IF(M8=0,\"0\",D17*F17)+3000","v":3000},"Ton",null,null,null,null,null,null,0.16272891266571154]
[]
[null,null,null,null,null,null,null,null,null,"Quantity","Number of Sublots"]
[null,"Inspector:",null,{"$f":"[4]JMF1!C60","v":0},null,null,null,null,null,"less than 1000","1  test"]
[null,null,null,null,null,null,null,null,null,"1001-2000 tons","2 tests"]
[null,"Title:",null,{"$f":"[4]JMF1!G60","v":0},null,null,null,null,null,"2001-3000 tons","3 tests"]
[null,null,null,null,null,null,null,null,null,"3001-4000 tons","4 tests"]

{"sheet":"Gauge Correction & small quan.","index":3,"n_rows":57,"n_cols":18,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,3,2,4],[56,5,56,6],[56,7,56,10],[4,8,4,10],[9,2,10,11],[11,2,11,5],[22,7,22,9],[55,5,55,6],[55,7,55,10],[4,3,4,4],[6,3,6,4]]}
[null,"  CALIBRATING NUCLEAR DENSITY GAUGE WITH ASPHALT CORES",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,null," Ref. No.",{"$f":"'JMF1'!C3","v":0},null,"County",{"$f":"'JMF1'!H5","v":0},"Region",{"$f":"'JMF1'!H4","v":0},"Date"]
[]
[null,null,"Mix Des #",{"$f":"'JMF1'!H14","v":0},null,"Contr. No.",{"$f":"'JMF1'!C5","v":0},"Type Mix",{"$f":"'JMF1'!E12","v":"OGFC "}]
[]
[null,null,"Gauge No.",null,null,"Standard Count"]
[]
[]
[null,null,"A control strip one paver width wide and having an area of at least 400 SY per roller*  shall be constructed with an approved bituminous mixture. It shall be compacted until there is no appreciable increase in density (1.0 lbs/cu.ft.) as measured with the nuclear gauge."]
[]
[null,null,"NO. OF CORES"]
[]
[]
[]
[null,null,null,null,null,1,"      7",null,null,"Min. Size"]
[null,null,null,null,null,"   2","        8",null,null," 9' x 400'"]
[null,null,"Typical test pattern for end",null,null,"      3","            9",null,null,"10' x 360'"]
[null,null,"section combining all rollers",null,null,"      4","           10",null,null,"11' x 330'",null,null,null,null,"cores"]
[null,null,null,null,null,"           5",null,11,null,"12' x 300",null,null,null,null,"Min",{"$f":"MIN(I26:I37)","v":0},"core sum",{"$f":"SUM(I26:I37)","v":0}]
[null,null,null,null,null,null,6,"    12",null,null,null,null,null,null,"Max",{"$f":"MAX(I26:I37)","v":0},"count cores",{"$f":"COUNTIF(I26:I37,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P20:P21)","v":0}]
[null,null,null,"( 1 )","( A )","( C )","( B )","     Theoretical Density    =",null,null,null,"lbs/cu.ft.",null,null,"gauge"]
[null,"Site ","Gauge ","Density","Core Wt.","Core Wt.",null," Core *","Density ","%","Cores","% H2O **",null,null,{"$f":"VLOOKUP(P20,A26:D37,4,FALSE)","v":0},"ga.sum",{"$f":"SUM(D26:D37)","v":0}]
[null,"No.","Reading","lbs/cu.ft.","(Dry)","(Wet)","(Blot Dry)","Sp. Gr.","lbs./cu.ft.","Density","Depth","Absorbed",null,null,{"$f":"VLOOKUP(P21,A26:D37,4,FALSE)","v":0},"count gauge",{"$f":"COUNTIF(D26:D37,\">0\")","v":0}]
[{"$f":"I26","v":0},1,null,null,null,null,null,{"$f":"IF(ISBLANK(E26),,E26/(G26-F26))","v":0},{"$f":"(H26*62.4)","v":0},{"$f":"IF(ISBLANK(E26),,I26/$K$23)","v":0},null,{"$f":"IF(ISBLANK(E26),,((G26-E26)/(G26-F26)))","v":0},null,null,{"$f":"SUM(O24:O25)","v":0}]
[0,2,null,null,null,null,null,{"$f":"IF(ISBLANK(E27),,E27/(G27-F27))","v":0},{"$f":"(H27*62.4)","v":0},{"$f":"IF(ISBLANK(E27),,I27/$K$23)","v":0},null,{"$f":"IF(ISBLANK(E27),,((G27-E27)/(G27-F27)))","v":0}]
[0,3,null,null,null,null,null,0,{"$f":"(H28*62.4)","v":0},0,null,{"$f":"IF(ISBLANK(E28),,((G28-E28)/(G28-F28)))","v":0}]
[0,4,null,null,null,null,null,0,{"$f":"(H29*62.4)","v":0},0,null,0]
[0,5,null,null,null,null,null,0,{"$f":"(H30*62.4)","v":0},0,null,0]
[0,6,null,null,null,null,null,0,0,0,null,0]
[0,7,null,null,null,null,null,0,0,0,null,0]
[0,8,null,null,null,null,null,0,0,0,null,0]
[0,9,null,null,null,null,null,0,0,0,null,0]
[0,10,null,null,null,null,null,0,0,0,null,0]
[0,11,null,null,null,null,null,0,0,0,null,0]
[0,12,null,null,null,null,null,0,0,0,null,0]
[]
[null,null,"Avg. =",{"$f":"IF(Stuff!AP97=2,$Q$24/$Q$25,(Q24-O26)/10)","v":{"$error":"#DIV/0!"}},"lbs./ft.3",null,"Avg. =",{"$f":"I39/62.4","v":{"$error":"#DIV/0!"}},{"$f":"IF(P1=2,$R$20/$R$21,($R$20-$P$22)/10)","v":{"$error":"#DIV/0!"}},{"$f":"I39/K23","v":{"$error":"#DIV/0!"}}]
[]
[null,"NOTE:  Nuclear Density Gauge Correction     =",null,null,null,null,"+ or -",{"$f":"I39-D39","v":{"$error":"#DIV/0!"}},"lbs./ft.3"]
[null,null,null,null,null,null,null,"(core -","gauge)"]
[]
[null,"* Core Sp. Gr.     =",null,"(Wt. Dry)"]
[null,null,null,"(Blot Dry)-","(Wt. Water)"]
[]
[null,"Example:","wt. dry","=699grams",null,"Core Sp. Gr.   =",null,"699"]
[null,null,"water","=385grams",null,null,null,"710 - 385"]
[null,null,"blot dry","=710grams"]
[null,null,null,null,null,null,"Sp. Gr. =",2.15]
[null,null,null,null,null,"B - A",null,"A=","mass in grams of sample in air"]
[null,"** Percent Water Absorbed by Volume  =",null,null,null,"B - C","X  100","B=","mass in grams of SSD specimen in air"]
[null,null,null,null,null,null,null,"C=","mass in grams of sample in water"]
[]
[]
[null,null,null,null,null,"T.D.O.T Insp.",null,{"$f":"'JMF1'!C63","v":0}]
[null,null,null,null,null,"Title",null,{"$f":"'JMF1'!G63","v":0}]

{"sheet":"DUST COATING & FUEL CONT. ","index":4,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":false,"merged":[[75,0,75,1],[75,2,75,4],[78,1,80,7],[67,4,67,5],[68,4,68,5],[69,4,69,5],[70,4,70,5],[71,4,71,5],[74,0,74,1],[74,2,74,4],[66,4,66,5],[0,2,0,5],[12,2,12,3],[30,2,30,4],[45,0,45,1],[45,2,45,4],[46,0,46,1],[46,2,46,4],[58,2,58,5],[60,2,60,5],[62,2,62,5],[64,4,64,5],[65,4,65,5]]}
[null,null,"Dust Coating Test"]
[]
["At least 1500 gram aggregate sample of plus four material shall be taken from each hot bin,"]
["after drying in a batch plant, or at least 5000 gram aggregate sample of plus four material"]
["shall be taken from material dried in a Dryer Drum plant.  The aggregate shall be gently "]
["manipulated on the No. 4 screen to separate it from all free fines.  Transfer the aggregate"]
["retained on the No. 4 screen to a tared No. 8 screen and determine its dry weight."]
["Thoroughly wash the material retained on the No. 8 screen to remove all fines.  Dry"]
["the aggregate retained on the No. 8 screen and calculate the percent loss."]
[]
[]
[]
[null,null,"BATCH PLANT"]
[]
["Total Wt. of Sample (5000 gram Minimum.)"]
["Must be at least 1500 grams from each bin"]
[]
["Date","Bin No.","% of Agg.","% of ","Sample ","Dry Weight","Weight ","Percent"]
[null,null,"Used From","Total ","wt. From ","After Wash","Loss","Loss"]
[null,null,"This Bin","Sample","Each Bin"]
["2012-01-12",2,null,{"$f":"IF(C21=0,0,(100/$C$24)*C21)","v":0},{"$f":"(D21*E15)/100","v":0}]
[null,3,null,{"$f":"IF(C22=0,0,(100/$C$24)*C22)","v":0},{"$f":"(D22*E15)/100","v":0}]
[null,4,null,{"$f":"IF(C23=0,0,(100/$C$24)*C23)","v":0},{"$f":"(D23*E15)/100","v":0}]
[null,"Totals",{"$f":"C21+C22+C23","v":0},{"$f":"D21+D22+D23","v":0},{"$f":"E21+E22+E23","v":0},null,{"$f":"E24-F24","v":0},{"$f":"IF(E15=0,0,(E24-F24)/E24)","v":0}]
[null,null,null,null,"(1)","(2)","(3)"]
[]
[]
[]
[]
[]
[null,null,"DRUM MIXER PLANT"]
[]
["5000 Gram Minimum"]
[]
[null,null,"(1)","(2)","(3)"]
["Date",null,"Sample ","Dry Wt. ","Weight ","Percent"]
[null,null,"Weight","After Wash","Loss","Loss"]
["2010-10-26",null,5122.8,5100.2,{"$f":"C38-D38","v":22.600000000000364},{"$f":"IF(C38=0,0,E38/C38)","v":4.4116498789725078E-3}]
[]
[]
[]
["Percent Loss  =  (3) divided by (1)  X  100  "]
[]
["Maximum loss as defined by section 903-06 (a) and 903-11 (a)"]
[]
["T.D.O.T. Insp.",null,{"$f":"'JMF1'!C63","v":0}]
["Title",null,{"$f":"'JMF1'!G63","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"FUEL CONTAMINATION TEST"]
[]
[null,null,"Visual Observation"]
[]
[null,null,"Check The One That Applies"]
[]
["Date","2012-01-10","Good",null,"Contaminated"]
["Date",null,"Good",null,"Contaminated"]
["Date",null,"Good",null,"Contaminated"]
["Date",null,"Good",null,"Contaminated"]
["Date",null,"Good",null,"Contaminated"]
["Date",null,"Good",null,"Contaminated"]
["Date",null,"Good",null,"Contaminated"]
["Date",null,"Good",null,"Contaminated"]
[]
[]
["T.D.O.T. Insp.",null,{"$f":"'JMF1'!C63","v":0}]
["Title",null,{"$f":"'JMF1'!G63","v":0}]
[]
[]
["REMARKS:"]

{"sheet":"EXTRACTION","index":5,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[48,0,48,1],[48,5,48,6],[48,10,48,11],[48,15,48,16],[30,3,30,5],[30,13,30,15],[31,1,31,2],[31,6,31,7],[31,11,31,12],[31,16,31,17],[25,5,26,5],[25,15,26,15],[26,1,26,4],[26,11,26,14],[29,3,29,5],[29,13,29,15],[1,4,1,5],[1,6,1,8],[1,14,1,15],[1,16,1,18],[2,1,2,2],[2,4,2,5],[2,6,2,8],[2,11,2,12],[2,14,2,15],[2,16,2,18],[0,16,0,18],[0,1,0,2],[0,4,0,5],[0,6,0,8],[0,11,0,12],[0,14,0,15]]}
["Type Mix",{"$f":"'JMF1'!E12","v":"OGFC "},null,null,"Contract No.",null,{"$f":"'JMF1'!C5","v":0},null,null,null,"Type Mix",{"$f":"'JMF1'!E12","v":"OGFC "},null,null,"Contract No.",null,{"$f":"G1","v":0}]
[]
["Date","2010-10-26",null,null,"T.D.O.T. Insp.",null,{"$f":"'JMF1'!C63","v":0},null,null,null,"Date",null,null,null,"T.D.O.T. Insp.",null,{"$f":"G3","v":0}]
[]
[null,null,null,null,null,null,"(1)",null,"(2)",null,null,null,null,null,null,null,"(3)",null,"(4)"]
["Weight of Filter Aid Used",null,null,null,null,null,33,null,32.9,null,"Weight of Filter Aid Used"]
["Weight of Filter Paper",null,null,null,null,null,27,null,27.1,null,"Weight of Filter Paper"]
[]
["Weight of Mix Sample + Container",null,null,null,null,null,1654.9,null,1544,null,"Weight of Mix Sample + Container"]
[null,"Wt. Of Container",null,null,null,null,null,null,null,null,null,"Wt. Of Container"]
["(1)","Wt. Of Mix sample",null,null,null,null,{"$f":"G9-G10","v":1654.9},null,{"$f":"I9-I10","v":1544},null,"(1)","Wt. Of Mix sample",null,null,null,null,{"$f":"Q9-Q10","v":0},null,{"$f":"S9-S10","v":0}]
[]
["       After  Extracting  A .  C . ",null,null,null,null,null,null,null,null,null,"       After  Extracting  A .  C . "]
[]
["Wt. Of Filter Aid + Filter Paper + (-200) Mtl",null,null,null,null,null,138.1,null,125.4,null,"Wt. Of Filter Aid + Filter Paper + (-200) Mtl"]
[null,"Wt. Of Filter Aid + Filter Paper ",null,null,null,null,{"$f":"G6+G7","v":60},null,{"$f":"I6+I7","v":60},null,null,"Wt. Of Filter Aid + Filter Paper ",null,null,null,null,{"$f":"Q6+Q7","v":0},null,{"$f":"S6+S7","v":0}]
["(2)","Wt. Of  (-200) Mtl.",null,null,null,null,{"$f":"G15-G16","v":78.099999999999994},null,{"$f":"I15-I16","v":65.400000000000006},null,"(2)","Wt. Of  (-200) Mtl.",null,null,null,null,{"$f":"Q15-Q16","v":0},null,{"$f":"S15-S16","v":0}]
[]
["Weight of Extracted Aggregate + Pan",null,null,null,null,null,1486,null,1393.2,null,"Weight of Extracted Aggregate + Pan"]
[null,"Wt. Of  Pan",null,null,null,null,null,null,null,null,null,"Wt. Of  Pan"]
["(3)","Wt. Of Extracted Aggregate",null,null,null,null,{"$f":"G19-G20","v":1486},null,{"$f":"I19-I20","v":1393.2},null,"(3)","Wt. Of Extracted Aggregate",null,null,null,null,{"$f":"Q19-Q20","v":0},null,{"$f":"S19-S20","v":0}]
[]
["(4)","Total Wt. Of Aggregate = (2) + (3) =",null,null,null,null,{"$f":"G17+G21","v":1564.1},null,{"$f":"I17+I21","v":1458.6000000000001},null,"(4)","Total Wt. Of Aggregate = (2) + (3) =",null,null,null,null,{"$f":"Q17+Q21","v":0},null,{"$f":"S17+S21","v":0}]
["(5)","Wt. Of Extracted Asphalt = (1) - (4) =",null,null,null,null,{"$f":"G11-G23","v":90.800000000000182},null,{"$f":"I11-I23","v":85.399999999999864},null,"(5)","Wt. Of Extracted Asphalt = (1) - (4) =",null,null,null,null,{"$f":"Q11-Q23","v":0},null,{"$f":"S11-S23","v":0}]
[]
[null,"% A. C. = Weight of Extracted Asphalt",null,null,null,"x  100  =",null,null,null,null,null,"% A. C. = Weight of Extracted Asphalt",null,null,null,"x  100  ="]
[null,"Weight of Mix Sample",null,null,null,null,{"$f":"IF(G11=0,0,(G24/G11)*100)","v":5.4867363586923794},null,{"$f":"IF(I11=0,0,(I24/I11)*100)","v":5.5310880829015456},null,null,"Weight of Mix Sample",null,null,null,null,{"$f":"IF(Q11=0,0,(Q24/Q11)*100)","v":0},null,{"$f":"IF(S11=0,0,(S24/S11)*100)","v":0}]
[]
[]
[null,null,null,"SIEVE ANALYSIS",null,null,null,null,null,null,null,null,null,"SIEVE ANALYSIS"]
[null,null,null,"AASHTO   T-30",null,null,null,null,null,null,null,null,null,"AASHTO   T-30"]
[null,"(1)",null,null,null,null,"(2)",null,null,null,null,"(3)",null,null,null,null,"(4)"]
["Sieve","Wt. Ret.","% Ret.","% Pass",null,"Sieve","Wt. Ret.","% Ret.","% Pass",null,"Sieve","Wt. Ret.","% Ret.","% Pass",null,"Sieve","Wt. Ret.","% Ret.","% Pass"]
["1 1/2\"",0,{"$f":"IF(B34=0,0,B34/$G$23*100)","v":0},{"$f":"IF(C34=0,0,100-C34)","v":0},null,"1 1/2\"",null,{"$f":"IF(G34=0,0,G34/$I$23*100)","v":0},{"$f":"IF(H34=0,0,100-H34)","v":0},null,"1 1/2\"",null,{"$f":"IF(L34=0,0,L34/$Q$23*100)","v":0},{"$f":"IF(M34=0,0,100-M34)","v":0},null,"1 1/2\"",null,{"$f":"IF(Q34=0,0,Q34/$S$23*100)","v":0},{"$f":"IF(R34=0,0,100-R34)","v":0}]
["1 1/4\"",0,0,{"$f":"IF(C35=0,0,100-C35)","v":0},null,"1 1/4\"",null,{"$f":"IF(G35=0,0,G35/$I$23*100)","v":0},{"$f":"IF(H35=0,0,100-H35)","v":0},null,"1 1/4\"",null,{"$f":"IF(L35=0,0,L35/$Q$23*100)","v":0},{"$f":"IF(M35=0,0,100-M35)","v":0},null,"1 1/4\"",null,{"$f":"IF(Q35=0,0,Q35/$S$23*100)","v":0},{"$f":"IF(R35=0,0,100-R35)","v":0}]
["1\"",0,0,{"$f":"IF(C36=0,0,100-C36)","v":0},null,"1\"",null,{"$f":"IF(G36=0,0,G36/$I$23*100)","v":0},{"$f":"IF(H36=0,0,100-H36)","v":0},null,"1\"",null,{"$f":"IF(L36=0,0,L36/$Q$23*100)","v":0},{"$f":"IF(M36=0,0,100-M36)","v":0},null,"1\"",null,{"$f":"IF(Q36=0,0,Q36/$S$23*100)","v":0},{"$f":"IF(R36=0,0,100-R36)","v":0}]
["3/4\"",null,0,{"$f":"IF(C37=0,0,100-C37)","v":0},null,"3/4\"",null,{"$f":"IF(G37=0,0,G37/$I$23*100)","v":0},{"$f":"IF(H37=0,0,100-H37)","v":0},null,"3/4\"",null,{"$f":"IF(L37=0,0,L37/$Q$23*100)","v":0},{"$f":"IF(M37=0,0,100-M37)","v":0},null,"3/4\"",null,{"$f":"IF(Q37=0,0,Q37/$S$23*100)","v":0},{"$f":"IF(R37=0,0,100-R37)","v":0}]
["5/8\"",0.01,6.3934531040214825E-4,99.999360654689596,null,"5/8\"",0.01,6.8558892088303855E-4,99.999314411079112,null,"5/8\"",null,0,0,null,"5/8\"",null,0,0]
["1/2\"",46.8,2.9921360526820537,97.007863947317944,null,"1/2\"",54.5,3.7364596188125598,96.26354038118744,null,"1/2\"",null,0,0,null,"1/2\"",null,0,0]
["3/8\"",257.8,16.482322102167384,83.517677897832613,null,"3/8\"",222,15.220074043603454,84.779925956396539,null,"3/8\"",null,0,0,null,"3/8\"",null,0,0]
["# 4",742.6,47.477782750463533,52.522217249536467,null,"# 4",717.7,49.204716851775679,50.795283148224321,null,"# 4",null,0,0,null,"# 4",null,0,0]
["# 8",925.8,59.19058883703088,40.80941116296912,null,"# 8",884.1,60.612916495269431,39.387083504730569,null,"# 8",null,0,0,null,"# 8",null,0,0]
["# 30",1107.0999999999999,70.781919314621817,29.218080685378183,null,"# 30",1042.4000000000001,71.465789112847929,28.534210887152071,null,"# 30",null,0,0,null,"# 30",null,0,0]
["# 50",1318.1,84.272105364107148,15.727894635892852,null,"# 50",1238.8,84.930755518990793,15.069244481009207,null,"# 50",null,0,0,null,"# 50",null,0,0]
["# 100",1448.9,92.634742024167267,7.3652579758327335,null,"# 100",1361.2,93.322363910599208,6.6776360894007922,null,"# 100",null,0,0,null,"# 100",null,0,0]
["# 200",1476.5,94.399335080877194,5.6006649191228064,null,"# 200",1385.9,95.015768545180308,4.9842314548196924,null,"# 200",null,0,0,null,"# 200",null,0,0]
[null,null,null,"D.A.R.",null,null,null,null,"D.A.R.",null,null,null,null,"D.A.R.",null,null,null,null,"D.A.R."]
[]
["Total Agg. Wt. =",null,{"$f":"G23","v":1564.1},{"$f":"D46/G27","v":1.0207643584423252},null,"Total Agg. Wt. =",null,{"$f":"I23","v":1458.6000000000001},{"$f":"IF(I23=0,0,I46/I27)","v":0.9011303707542877},null,"Total Agg. Wt. =",null,{"$f":"Q23","v":0},{"$f":"IF(M49=0,0,N46/Q27)","v":0},null,"Total Agg. Wt. =",null,{"$f":"S23","v":0},{"$f":"IF(R49=0,0,S46/S27)","v":0}]
[]
["Fract. Face Count",null,"No. particles",null,null,"Glassy Particles",null,"total wt. "]
[null,null,"No. fractured",null,null,null,null,"wt. Glassy"]
[null,null,"% fractured",{"$f":"IF(D51=0,0,D52/D51)","v":0},null,null,null,"% Glassy",{"$f":"IF(I51=0,0,I52/I51)","v":0}]

{"sheet":"BURNOUT OVEN ","index":6,"n_rows":54,"n_cols":27,"rows_kept":54,"cut":false,"hidden":false,"merged":[[45,2,45,3],[45,9,45,10],[45,16,45,17],[45,23,45,24],[47,2,47,3],[47,9,47,10],[47,16,47,17],[47,23,47,24],[42,21,42,22],[42,23,42,24],[44,2,44,3],[44,9,44,10],[44,16,44,17],[44,23,44,24],[42,16,42,17],[42,0,42,1],[42,2,42,3],[42,7,42,8],[42,9,42,10],[42,14,42,15],[38,2,38,3],[38,9,38,10],[38,16,38,17],[38,23,38,24],[39,2,39,3],[39,9,39,10],[39,16,39,17],[39,23,39,24],[36,2,36,3],[36,9,36,10],[36,16,36,17],[36,23,36,24],[37,2,37,3],[37,9,37,10],[37,16,37,17],[37,23,37,24],[33,21,33,22],[33,23,33,24],[34,2,34,3],[34,9,34,10],[34,16,34,17],[34,23,34,24],[33,16,33,17],[33,0,33,1],[33,2,33,3],[33,7,33,8],[33,9,33,10],[33,14,33,15],[31,21,31,22],[31,23,31,24],[32,2,32,3],[32,9,32,10],[32,16,32,17],[32,23,32,24],[31,16,31,17],[31,0,31,1],[31,2,31,3],[31,7,31,8],[31,9,31,10],[31,14,31,15],[7,25,7,26],[2,1,2,3],[2,8,2,10],[2,15,2,17],[2,22,2,24],[5,1,5,2],[5,4,5,5],[5,8,5,9],[5,11,5,12],[7,1,7,2],[7,4,7,5],[7,8,7,9],[7,11,7,12],[7,18,7,19]]}
[null,null,"WASHED GRADATION FOR IGNITION FURNACE SAMPLES",null,null,null,null,null,null,"WASHED GRADATION FOR IGNITION FURNACE SAMPLES",null,null,null,null,null,null,"WASHED GRADATION FOR IGNITION FURNACE SAMPLES",null,null,null,null,null,null,"WASHED GRADATION FOR IGNITION FURNACE SAMPLES"]
[]
[null,"(AASHTO   T-11   &   AASHTO   T - 27)",null,null,null,null,null,null,"(AASHTO   T-11   &   AASHTO   T - 27)",null,null,null,null,null,null,"(AASHTO   T-11   &   AASHTO   T - 27)",null,null,null,null,null,null,"(AASHTO   T-11   &   AASHTO   T - 27)"]
[]
[]
["Type Mix",{"$f":"'JMF1'!E12","v":"OGFC "},null,"Project No.",{"$f":"'JMF1'!C4","v":0},null,null,"Type Mix",{"$f":"'JMF1'!E12","v":"OGFC "},null,"Project No.",{"$f":"'JMF1'!C4","v":0},null,null,"Type Mix",{"$f":"I6","v":"OGFC "},null,"Project No.",{"$f":"L6","v":0},null,null,"Type Mix",{"$f":"P6","v":"OGFC "},null,"Project No.",{"$f":"S6","v":0}]
[]
["Date",null,null,"T.D.O.T. Insp.",{"$f":"'JMF1'!C63","v":0},null,null,"Date",null,null,"T.D.O.T. Insp.",{"$f":"'JMF1'!C63","v":0},null,null,"Date",null,null,"Inspector",{"$f":"L8","v":0},null,null,"Date",null,null,"Inspector",{"$f":"S8","v":0}]
[]
[null,null,"Sample #(1)",null,null,null,null,null,null,"Sample #(2)",null,null,null,null,null,null,"Sample #(3)",null,null,null,null,null,null,"Sample #(4)"]
["Sieve ","Weight","Percent ","Percent ",null,null,null,"Sieve ","Weight","Percent ","Percent ",null,null,null,"Sieve ","Weight","Percent ","Percent ",null,null,null,"Sieve ","Weight","Percent ","Percent "]
["Size","Retained","Retained","Passing","J. M. F.","Deviation",null,"Size","Retained","Retained","Passing","J. M. F.","Deviation",null,"Size","Retained","Retained","Passing","J. M. F.","Deviation",null,"Size","Retained","Retained","Passing","J. M. F.","Deviation"]
["1 1/2\"",null,{"$f":"IF(B13=0,0,B13/$B$48*100)","v":0},{"$f":"IF(C13=0,0,(100-C13))","v":0},{"$f":"IF('JMF1'!I46=\"\",\"\",'JMF1'!I46)","v":0},{"$f":"IF(B13<0.01,0,D13-E13)","v":0},null,"1 1/2\"",null,{"$f":"IF(I13=0,0,I13/$I$48*100)","v":0},{"$f":"IF(J13=0,0,(100-J13))","v":0},{"$f":"E13","v":0},{"$f":"IF(I13<0.01,0,K13-L13)","v":0},null,"1 1/2\"",null,{"$f":"IF(P13=0,0,P13/$P$48*100)","v":0},{"$f":"IF(Q13=0,0,(100-Q13))","v":0},{"$f":"L13","v":0},{"$f":"IF(P13<0.01,0,R13-S13)","v":0},null,"1 1/2\"",null,{"$f":"IF(W13=0,0,W13/$W$48*100)","v":0},{"$f":"IF(X13=0,0,(100-X13))","v":0},{"$f":"S13","v":0},{"$f":"IF(W13<0.01,0,Y13-Z13)","v":0}]
["1 1/4\"",null,{"$f":"IF(B14=0,0,B14/$B$48*100)","v":0},{"$f":"IF(C14=0,0,(100-C14))","v":0},{"$f":"IF('JMF1'!I47=\"\",\"\",'JMF1'!I47)","v":50},0,null,"1 1/4\"",null,{"$f":"IF(I14=0,0,I14/$I$48*100)","v":0},{"$f":"IF(J14=0,0,(100-J14))","v":0},50,0,null,"1 1/4\"",null,{"$f":"IF(P14=0,0,P14/$P$48*100)","v":0},{"$f":"IF(Q14=0,0,(100-Q14))","v":0},50,0,null,"1 1/4\"",null,{"$f":"IF(W14=0,0,W14/$W$48*100)","v":0},{"$f":"IF(X14=0,0,(100-X14))","v":0},50,0]
["1\"",null,0,{"$f":"IF(C15=0,0,(100-C15))","v":0},{"$f":"IF('JMF1'!I48=\"\",\"\",'JMF1'!I48)","v":50},0,null,"1\"",null,0,{"$f":"IF(J15=0,0,(100-J15))","v":0},50,0,null,"1\"",null,0,{"$f":"IF(Q15=0,0,(100-Q15))","v":0},50,0,null,"1\"",null,0,0,50,0]
["3/4\"",312.10000000000002,15.735337372994248,{"$f":"IF(C16=0,0,(100-C16))","v":84.264662627005748},{"$f":"IF('JMF1'!I49=\"\",\"\",'JMF1'!I49)","v":50},34.264662627005748,null,"3/4\"",312.10000000000002,15.846355845888729,{"$f":"IF(J16=0,0,(100-J16))","v":84.153644154111277},50,34.153644154111277,null,"3/4\"",312.10000000000002,15.846355845888729,{"$f":"IF(Q16=0,0,(100-Q16))","v":84.153644154111277},50,34.153644154111277,null,"3/4\"",312.10000000000002,15.846355845888729,84.153644154111277,50,34.153644154111277]
["5/8\"",null,0,0,{"$f":"IF('JMF1'!I50=\"\",\"\",'JMF1'!I50)","v":50},0,null,"5/8\"",null,0,0,50,0,null,"5/8\"",null,0,0,50,0,null,"5/8\"",null,0,0,50,0]
["1/2\"",null,0,0,{"$f":"IF('JMF1'!I51=\"\",\"\",'JMF1'!I51)","v":48},0,null,"1/2\"",null,0,0,48,0,null,"1/2\"",null,0,0,48,0,null,"1/2\"",null,0,0,48,0]
["3/8\"",805,40.586179382442708,59.413820617557292,{"$f":"IF('JMF1'!I52=\"\",\"\",'JMF1'!I52)","v":48},11.413820617557292,null,"3/8\"",805,40.872529496765225,59.127470503234775,48,11.127470503234775,null,"3/8\"",805,40.872529496765225,59.127470503234775,48,11.127470503234775,null,"3/8\"",805,40.872529496765225,59.127470503234775,48,11.127470503234775]
["#4",1238.3,62.432131589166218,37.567868410833782,{"$f":"IF('JMF1'!I53=\"\",\"\",'JMF1'!I53)","v":48},-10.432131589166218,null,"#4",1238.3,62.872612765024073,37.127387234975927,48,-10.872612765024073,null,"#4",1238.3,62.872612765024073,37.127387234975927,48,-10.872612765024073,null,"#4",1238.3,{"$f":"IF(W20=0,0,W20/$W$48*100)","v":62.872612765024073},37.127387234975927,48,-10.872612765024073]
["#8",1471.6,74.194560967953649,25.805439032046351,{"$f":"IF('JMF1'!I54=\"\",\"\",'JMF1'!I54)","v":37},-11.194560967953649,null,"#8",1471.6,74.718030319800874,25.281969680199126,37,-11.718030319800874,null,"#8",1471.6,74.718030319800874,25.281969680199126,37,-11.718030319800874,null,"#8",1471.6,74.718030319800874,25.281969680199126,37,-11.718030319800874]
["#30",1709.5,86.188911371783618,13.811088628216382,{"$f":"IF('JMF1'!I56=\"\",\"\",'JMF1'!I56)","v":37},-23.188911371783618,null,"#30",1709.5,86.797005185987771,13.202994814012229,37,-23.797005185987771,null,"#30",1709.5,86.797005185987771,13.202994814012229,37,-23.797005185987771,null,"#30",1709.5,86.797005185987771,13.202994814012229,37,-23.797005185987771]
["#50",1793.2,90.408865675274868,9.5911343247251324,{"$f":"IF('JMF1'!I57=\"\",\"\",'JMF1'!I57)","v":25},-15.408865675274868,null,"#50",1793.2,91.046732787080003,8.9532672129199966,25,-16.046732787080003,null,"#50",1793.2,91.046732787080003,8.9532672129199966,25,-16.046732787080003,null,"#50",1793.2,91.046732787080003,8.9532672129199966,25,-16.046732787080003]
["#100",1860.9,93.822138152531238,6.1778618474687619,{"$f":"IF('JMF1'!I58=\"\",\"\",'JMF1'!I58)","v":25},-18.822138152531238,null,"#100",1860.9,94.484087131093688,5.5159128689063124,25,-19.484087131093688,null,"#100",1860.9,94.484087131093688,5.5159128689063124,25,-19.484087131093688,null,"#100",1860.9,94.484087131093688,5.5159128689063124,25,-19.484087131093688]
["#200",1924.3,97.01861488898696,2.98138511101304,{"$f":"IF('JMF1'!I59=\"\",\"\",'JMF1'!I59)","v":10},-7.01861488898696,null,"#200",1924.3,97.703116162267477,2.2968838377325227,10,-7.7031161622674773,null,"#200",1924.3,97.703116162267477,2.2968838377325227,10,-7.7031161622674773,null,"#200",1924.3,97.703116162267477,2.2968838377325227,10,-7.7031161622674773]
[null,null,"Remarks:",null,null,null,null,null,null,"Remarks:",null,null,null,null,null,null,"Remarks:",null,null,null,null,null,null,"Remarks:"]
["Total Wt. Aggr.",{"$f":"B48","v":1983.4338},null,null,null,null,null,"Total Wt. Aggr.",{"$f":"I48","v":1969.5380000000002},null,null,null,null,null,"Total Wt. Aggr.",{"$f":"P48","v":1969.5380000000002},null,null,null,null,null,"Total Wt. Aggr.",{"$f":"W48","v":1969.5380000000002}]
[]
["D.A.R.",{"$f":"IF(B48=0,0,D25/E45)","v":0.55210835389130364},null,null,null,null,null,"D.A.R.",{"$f":"IF(I48=0,0,K25/L45)","v":0.51615367140056689},null,null,null,null,null,"D.A.R.",{"$f":"IF(P48=0,0,R25/S45)","v":0.51615367140056689},null,null,null,null,null,"D.A.R.",{"$f":"IF(W48=0,0,Y25/Z45)","v":0.51615367140056689}]
[]
[]
[{"$f":"2164*0.9555","v":2067.7020000000002},null,"(Before Burnout)",null,null,null,null,null,null,"(Before Burnout)",null,null,null,null,null,null,"(Before Burnout)",null,null,null,null,null,null,"(Before Burnout)"]
[null,null,"Total Wt. Sample & Basket",null,5460.6,null,null,null,null,"Total Wt. Sample & Basket",null,2264,null,null,null,null,"Total Wt. Sample & Basket",null,2264,null,null,null,null,"Total Wt. Sample & Basket",null,2264]
[null,null,"Basket Wt.",null,3364.2,null,null,null,null,"Basket Wt.",null,100,null,null,null,null,"Basket Wt.",null,100,null,null,null,null,"Basket Wt.",null,100]
[null,null,"Wt. of Sample",null,{"$f":"E33-E34","v":2096.4000000000005},null,null,null,null,"Wt. of Sample",null,{"$f":"L33-L34","v":2164},null,null,null,null,"Wt. of Sample",null,{"$f":"S33-S34","v":2164},null,null,null,null,"Wt. of Sample",null,{"$f":"Z33-Z34","v":2164}]
[]
[null,null,"(After Burnout)",null,null,null,null,null,null,"(After Burnout)",null,null,null,null,null,null,"(After Burnout)",null,null,null,null,null,null,"(After Burnout)"]
[null,null,"Total Wt. Sample & Basket",null,5338.2,null,null,null,null,"Total Wt. Sample & Basket",null,2059.8000000000002,null,null,null,null,"Total Wt. Sample & Basket",null,2059.8000000000002,null,null,null,null,"Total Wt. Sample & Basket",null,2059.8000000000002]
[null,null,"Basket Wt.",null,{"$f":"E34","v":3364.2},null,null,null,null,"Basket Wt.",null,{"$f":"L34","v":100},null,null,null,null,"Basket Wt.",null,{"$f":"S34","v":100},null,null,null,null,"Basket Wt.",null,{"$f":"Z34","v":100}]
[null,null,"Wt. of Sample",null,{"$f":"E38-E39","v":1974},null,null,null,null,"Wt. of Sample",null,{"$f":"L38-L39","v":1959.8000000000002},null,null,null,null,"Wt. of Sample",null,{"$f":"S38-S39","v":1959.8000000000002},null,null,null,null,"Wt. of Sample",null,{"$f":"Z38-Z39","v":1959.8000000000002}]
[]
[]
["ORIGINAL HMA SAMPLE",null,"Design  A. C.",null,{"$f":"'JMF1'!G25","v":7},null,null,"ORIGINAL HMA SAMPLE",null,"Design  A. C.",null,{"$f":"E43","v":7},null,null,"ORIGINAL HMA SAMPLE",null,"Design  A. C.",null,{"$f":"L43","v":7},null,null,"ORIGINAL HMA SAMPLE",null,"Design  A. C.",null,{"$f":"S43","v":7}]
[]
["Original Weight",{"$f":"E35","v":2096.4000000000005}," A. C. Content",null,5.4,null,null,"Original Weight",{"$f":"L35","v":2164}," A. C. Content",null,4.45,null,null,"Original Weight",{"$f":"S35","v":2164}," A. C. Content",null,4.45,null,null,"Original Weight",{"$f":"Z35","v":2164}," A. C. Content",null,4.45]
["Correction Factor",{"$f":"'JMF1'!I35","v":0.45},"from N.C.A.T.tape",null,null,null,null,"Correction Factor",{"$f":"B46","v":0.45},"from N.C.A.T.tape",null,null,null,null,"Correction Factor",{"$f":"I46","v":0.45},"from N.C.A.T.tape",null,null,null,null,"Correction Factor",{"$f":"P46","v":0.45},"from N.C.A.T.tape"]
[]
["Total Aggr. Mass",{"$f":"B45*B46/100+E40","v":1983.4338},"A.C. Content Deviation",null,{"$f":"E45-E43","v":-1.5999999999999996},null,null,"Total Aggr. Mass",{"$f":"I45*I46/100+L40","v":1969.5380000000002},"A.C. Content Deviation",null,{"$f":"L45-L43","v":-2.5499999999999998},null,null,"Total Aggr. Mass",{"$f":"P45*P46/100+S40","v":1969.5380000000002},"A.C. Content Deviation",null,{"$f":"S45-S43","v":-2.5499999999999998},null,null,"Total Aggr. Mass",{"$f":"W45*W46/100+Z40","v":1969.5380000000002},"A.C. Content Deviation",null,{"$f":"Z45-Z43","v":-2.5499999999999998}]
[]
[]
[]
["Fract. Face Count","No. particles",100,"Glassy Particles","total wt.",400]
[null,"No. fractured",99,null,"wt. glassy",10]
[null,"% fractured",{"$f":"IF(C53=0,0,(C53/C52))","v":0.99},null,"% glassy",{"$f":"IF(F53=0,0,(F53/F52))","v":2.5000000000000001E-2}]

{"sheet":"Ag Belt Samp. + RAP Belt Sample","index":7,"n_rows":69,"n_cols":27,"rows_kept":69,"cut":false,"hidden":false,"merged":[[7,1,7,2],[8,5,8,6],[8,3,8,4],[21,3,21,4],[21,5,21,6],[11,2,11,4],[11,5,11,7],[1,21,1,23],[3,17,3,19],[5,17,5,23],[7,15,7,16],[40,17,40,19],[8,19,8,20],[31,16,35,26],[38,17,38,18],[38,21,38,23],[24,17,24,18],[24,19,24,20],[11,19,11,21],[11,22,11,23],[21,19,21,20],[25,19,25,21],[25,22,25,23],[68,2,72,12],[1,17,1,18],[31,2,35,12],[38,3,38,4],[38,7,38,9],[5,3,5,9],[1,7,1,9],[1,3,1,4],[3,3,3,5],[40,3,40,5],[42,3,42,9],[44,1,44,2],[68,16,72,26],[42,17,42,23],[44,15,44,16],[8,17,8,18],[11,8,11,9],[25,2,25,4],[25,5,25,7],[25,8,25,9],[11,16,11,18],[21,17,21,18],[24,3,24,4],[24,5,24,6],[25,16,25,18],[48,22,48,23],[45,17,45,18],[45,19,45,20],[45,3,45,4],[45,5,45,6],[48,2,48,4],[48,5,48,7],[48,8,48,9],[48,16,48,18],[48,19,48,21],[58,3,58,4],[58,5,58,6],[62,2,62,4],[62,5,62,7],[62,8,62,9],[61,3,61,4],[61,5,61,6],[58,17,58,18],[58,19,58,20],[62,16,62,18],[62,19,62,21],[62,22,62,23],[61,17,61,18],[61,19,61,20]]}
[]
[null,"Date",null,null,null,null,"Mix Type",{"$f":"'JMF1'!E12","v":"OGFC "},null,null,null,null,null,null,null,"Date",null,null,null,null,"Mix Type",{"$f":"$H$2","v":"OGFC "}]
[]
[null,"Contract Number",null,{"$f":"'JMF1'!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,"Contract Number",null,{"$f":"$D$4","v":0}]
[]
[null,"Producer",null,{"$f":"'HMA Producers'!E1","v":0},null,null,null,null,null,null,null,null,null,null,null,"Producer",null,{"$f":"$D$6","v":0}]
[]
[null,"SAMPLE #1",null,null,null,null,null,null,null,null,null,null,null,null,null,"SAMPLE #3"]
[null,null,null,"Virgin Material",null,"RAP",null,null,null,null,null,null,null,null,null,null,null,"Virgin Material",null,"RAP"]
[null,"Percent of Aggregate",null,100,"%",0,"%",null,null,null,null,null,null,null,null,"Percent of Aggregate",null,null,"%",null,"%"]
[null,"Total wt. Sample",null,100,"grams",null,"grams",null,null,null,null,null,null,null,null,"Total wt. Sample",null,null,"grams",null,"grams"]
[null,null,"Virgin",null,null,"RAP",null,null,"Combined",null,null,"J.M.F.","ABS",null,null,null,"Virgin",null,null,"RAP",null,null,"Combined",null,null,"J.M.F.","ABS"]
[null,"Sieve","Wt. Ret.","% Ret","% Pass","Wt. Ret.","% Ret","% Pass","% Ret","% Pass",null,null," Deviation",null,null,"Sieve","Wt. Ret.","% Ret","% Pass","Wt. Ret.","% Ret","% Pass","% Ret","% Pass",null,null," Deviation"]
[null,"2 \"",null,{"$f":"IF(ISBLANK(C14),\"\",C14/$D$11)","v":""},{"$f":"IF(ISBLANK(C14),\"\",1-D14)","v":""},null,{"$f":"IF(ISBLANK(F14),0,F14/$F$11)","v":0},{"$f":"IF(ISBLANK(F14),\"\",1-G14)","v":""},{"$f":"IF(ISBLANK(C14),\"\",D14*$D$10+G14*$F$10)","v":""},{"$f":"IF(ISBLANK(C14),0,100-I14)","v":0},null,{"$f":"'JMF1'!I45","v":0},{"$f":"ABS(J14-L14)","v":0},null,null,"2 \"",null,{"$f":"IF(ISBLANK(Q14),\"\",Q14/$R$11)","v":""},{"$f":"IF(ISBLANK(Q14),\"\",1-R14)","v":""},null,{"$f":"IF(ISBLANK(T14),0,T14/$T$11)","v":0},{"$f":"IF(ISBLANK(T14),\"\",1-U14)","v":""},{"$f":"IF(ISBLANK(Q14),\"\",R14*$D$10+U14*$F$10)","v":""},{"$f":"IF(ISBLANK(Q14),0,100-W14)","v":0},null,{"$f":"'JMF1'!W45","v":0},{"$f":"ABS(X14-Z14)","v":0}]
[null,"1 1/2\"",null,{"$f":"IF(ISBLANK(C15),\"\",C15/$D$11)","v":""},{"$f":"IF(ISBLANK(C15),\"\",1-D15)","v":""},null,{"$f":"IF(ISBLANK(F15),0,F15/$F$11)","v":0},{"$f":"IF(ISBLANK(F15),\"\",1-G15)","v":""},{"$f":"IF(ISBLANK(C15),\"\",D15*$D$10+G15*$F$10)","v":""},{"$f":"IF(ISBLANK(C15),0,100-I15)","v":0},null,{"$f":"'JMF1'!I46","v":0},{"$f":"ABS(J15-L15)","v":0},null,null,"1 1/2\"",null,{"$f":"IF(ISBLANK(Q15),\"\",Q15/$R$11)","v":""},{"$f":"IF(ISBLANK(Q15),\"\",1-R15)","v":""},null,{"$f":"IF(ISBLANK(T15),0,T15/$T$11)","v":0},{"$f":"IF(ISBLANK(T15),\"\",1-U15)","v":""},{"$f":"IF(ISBLANK(Q15),\"\",R15*$D$10+U15*$F$10)","v":""},{"$f":"IF(ISBLANK(Q15),0,100-W15)","v":0},null,{"$f":"'JMF1'!W46","v":0},{"$f":"ABS(X15-Z15)","v":0}]
[null,"3/4\"",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I49","v":50},50,null,null,"3/4\"",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W49","v":0},0]
[null,"3/8\"",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I52","v":48},48,null,null,"3/8\"",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W52","v":0},0]
[null,"# 4",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I53","v":48},48,null,null,"# 4",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W53","v":0},0]
[null,"# 8",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I54","v":37},37,null,null,"# 8",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W54","v":0},0]
[]
[null,"OPTIONAL: REDUCE SIZE OF -8 MAT'L PER TDOT PROCEDURE FOR BELT SAMPLING, ENTER AMOUNT OF -8 USED FOR FINE AGG SIEVE ANALYSIS BELOW",null,null,null,null,null,null,null,null,null,null,null,null,null,"OPTIONAL: REDUCE SIZE OF -8 MAT'L PER TDOT PROCEDURE FOR BELT SAMPLING, ENTER AMOUNT OF -8 USED FOR FINE AGG SIEVE ANALYSIS BELOW"]
[null,null,null,"Virgin Material",null,"RAP",null,null,null,null,null,null,null,null,null,null,null,"Virgin Material",null,"RAP"]
[null,"Wt. of - #8 original",null,{"$f":"D11*E19","v":{"$error":"#VALUE!"}},"grams",{"$f":"F11*H19","v":{"$error":"#VALUE!"}},"grams",null,null,null,null,null,null,null,null,"Wt. of - #8 original",null,{"$f":"R11*S19","v":{"$error":"#VALUE!"}},"grams",{"$f":"T11*V19","v":{"$error":"#VALUE!"}},"grams"]
[null,"Wt. of - #8 mt'l used",null,45,"grams",0,"grams",null,null,null,null,null,null,null,null,"Wt. of - #8 mt'l used",null,null,"grams",null,"grams"]
[null,null,null,{"$f":"D24/D23","v":{"$error":"#VALUE!"}},null,{"$f":"F24/F23","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"R24/R23","v":{"$error":"#VALUE!"}},null,{"$f":"T24/T23","v":{"$error":"#VALUE!"}}]
[null,null,"Virgin",null,null,"RAP",null,null,"Combined",null,null,"J.M.F.","Deviation",null,null,null,"Virgin",null,null,"RAP",null,null,"Combined",null,null,"J.M.F.","Deviation"]
[null,"Sieve","Wt. Ret.","% Ret","% Pass","Wt. Ret.","% Ret","% Pass","% Ret","% Pass",null,null,null,null,null,"Sieve","Wt. Ret.","% Ret","% Pass","Wt. Ret.","% Ret","% Pass","% Ret","% Pass"]
[null,"# 30",null,{"$f":"IF(ISBLANK(C28),\"\",$D$19+(C28/$D$25)/$D$11)","v":""},{"$f":"IF(ISBLANK(C28),\"\",1-D28)","v":""},null,{"$f":"IF(ISBLANK(F28),0,$G$19+(F28/$F$25)/$F$11)","v":0},{"$f":"IF(ISBLANK(F28),\"\",1-G28)","v":""},{"$f":"IF(ISBLANK(C28),\"\",D28*$D$10+G28*$F$10)","v":""},{"$f":"IF(ISBLANK(C28),0,100-I28)","v":0},null,{"$f":"'JMF1'!I56","v":37},{"$f":"ABS(J28-L28)","v":37},null,null,"# 30",null,{"$f":"IF(ISBLANK(Q28),\"\",$R$19+(Q28/$R$25)/$R$11)","v":""},{"$f":"IF(ISBLANK(Q28),\"\",1-R28)","v":""},null,{"$f":"IF(ISBLANK(T28),0,$U$19+(T28/$T$25)/$T$11)","v":0},{"$f":"IF(ISBLANK(T28),\"\",1-U28)","v":""},{"$f":"IF(ISBLANK(Q28),\"\",R28*$D$10+U28*$F$10)","v":""},{"$f":"IF(ISBLANK(Q28),0,100-W28)","v":0},null,{"$f":"'JMF1'!W56","v":0},{"$f":"ABS(X28-Z28)","v":0}]
[null,"# 50",null,{"$f":"IF(ISBLANK(C29),\"\",$D$19+(C29/$D$25)/$D$11)","v":""},{"$f":"IF(ISBLANK(C29),\"\",1-D29)","v":""},null,{"$f":"IF(ISBLANK(F29),0,$G$19+(F29/$F$25)/$F$11)","v":0},{"$f":"IF(ISBLANK(F29),\"\",1-G29)","v":""},{"$f":"IF(ISBLANK(C29),\"\",D29*$D$10+G29*$F$10)","v":""},{"$f":"IF(ISBLANK(C29),0,100-I29)","v":0},null,{"$f":"'JMF1'!I57","v":25},{"$f":"ABS(J29-L29)","v":25},null,null,"# 50",null,{"$f":"IF(ISBLANK(Q29),\"\",$R$19+(Q29/$R$25)/$R$11)","v":""},{"$f":"IF(ISBLANK(Q29),\"\",1-R29)","v":""},null,{"$f":"IF(ISBLANK(T29),0,$U$19+(T29/$T$25)/$T$11)","v":0},{"$f":"IF(ISBLANK(T29),\"\",1-U29)","v":""},{"$f":"IF(ISBLANK(Q29),\"\",R29*$D$10+U29*$F$10)","v":""},{"$f":"IF(ISBLANK(Q29),0,100-W29)","v":0},null,{"$f":"'JMF1'!W57","v":0},{"$f":"ABS(X29-Z29)","v":0}]
[null,"# 100",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I58","v":25},25,null,null,"# 100",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W58","v":0},0]
[null,"# 200",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I59","v":10},10,null,null,"# 200",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W59","v":0},0]
[null,"Remarks:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Remarks:"]
[]
[]
[]
[]
[]
[]
[null,"Date",null,null,null,null,"Mix Type",{"$f":"$H$2","v":"OGFC "},null,null,null,null,null,null,null,"Date",null,null,null,null,"Mix Type",{"$f":"$H$2","v":"OGFC "}]
[]
[null,"Contract Number",null,{"$f":"$D$4","v":0},null,null,null,null,null,null,null,null,null,null,null,"Contract Number",null,{"$f":"$D$4","v":0}]
[]
[null,"Producer",null,{"$f":"$D$6","v":0},null,null,null,null,null,null,null,null,null,null,null,"Producer",null,{"$f":"$D$6","v":0}]
[]
[null,"SAMPLE #2",null,null,null,null,null,null,null,null,null,null,null,null,null,"SAMPLE #4"]
[null,null,null,"Virgin Material",null,"RAP",null,null,null,null,null,null,null,null,null,null,null,"Virgin Material",null,"RAP"]
[null,"Percent of Aggregate",null,100,"%",null,"%",null,null,null,null,null,null,null,null,"Percent of Aggregate",null,null,"%",null,"%"]
[null,"Total wt. Sample",null,100,"grams",null,"grams",null,null,null,null,null,null,null,null,"Total wt. Sample",null,null,"grams",null,"grams"]
[null,null,"Virgin",null,null,"RAP",null,null,"Combined",null,null,"J.M.F.","ABS",null,null,null,"Virgin",null,null,"RAP",null,null,"Combined",null,null,"J.M.F.","ABS"]
[null,"Sieve","Wt. Ret.","% Ret","% Pass","Wt. Ret.","% Ret","% Pass","% Ret","% Pass",null,null," Deviation",null,null,"Sieve","Wt. Ret.","% Ret","% Pass","Wt. Ret.","% Ret","% Pass","% Ret","% Pass",null,null," Deviation"]
[null,"2 \"",null,{"$f":"IF(ISBLANK(C51),\"\",C51/$D$48)","v":""},{"$f":"IF(ISBLANK(C51),\"\",1-D51)","v":""},null,{"$f":"IF(ISBLANK(F51),0,F51/$F$11)","v":0},{"$f":"IF(ISBLANK(F51),\"\",1-G51)","v":""},{"$f":"IF(ISBLANK(C51),\"\",D51*$D$10+G51*$F$10)","v":""},{"$f":"IF(ISBLANK(C51),0,100-I51)","v":0},null,{"$f":"'JMF1'!I82","v":0},{"$f":"ABS(J51-L51)","v":0},null,null,"2 \"",null,{"$f":"IF(ISBLANK(Q51),\"\",Q51/$R$48)","v":""},{"$f":"IF(ISBLANK(Q51),\"\",1-R51)","v":""},null,{"$f":"IF(ISBLANK(T51),0,T51/$T$48)","v":0},{"$f":"IF(ISBLANK(T51),\"\",1-U51)","v":""},{"$f":"IF(ISBLANK(Q51),\"\",R51*$D$10+U51*$F$10)","v":""},{"$f":"IF(ISBLANK(Q51),0,100-W51)","v":0},null,{"$f":"'JMF1'!W82","v":0},{"$f":"ABS(X51-Z51)","v":0}]
[null,"1 1/2\"",null,{"$f":"IF(ISBLANK(C52),\"\",C52/$D$48)","v":""},{"$f":"IF(ISBLANK(C52),\"\",1-D52)","v":""},null,{"$f":"IF(ISBLANK(F52),0,F52/$F$11)","v":0},{"$f":"IF(ISBLANK(F52),\"\",1-G52)","v":""},{"$f":"IF(ISBLANK(C52),\"\",D52*$D$10+G52*$F$10)","v":""},{"$f":"IF(ISBLANK(C52),0,100-I52)","v":0},null,{"$f":"'JMF1'!I83","v":0},{"$f":"ABS(J52-L52)","v":0},null,null,"1 1/2\"",null,{"$f":"IF(ISBLANK(Q52),\"\",Q52/$R$48)","v":""},{"$f":"IF(ISBLANK(Q52),\"\",1-R52)","v":""},null,{"$f":"IF(ISBLANK(T52),0,T52/$T$48)","v":0},{"$f":"IF(ISBLANK(T52),\"\",1-U52)","v":""},{"$f":"IF(ISBLANK(Q52),\"\",R52*$D$10+U52*$F$10)","v":""},{"$f":"IF(ISBLANK(Q52),0,100-W52)","v":0},null,{"$f":"'JMF1'!W83","v":0},{"$f":"ABS(X52-Z52)","v":0}]
[null,"3/4\"",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I86","v":0},0,null,null,"3/4\"",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W86","v":0},0]
[null,"3/8\"",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I89","v":0},0,null,null,"3/8\"",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W89","v":0},0]
[null,"# 4",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I90","v":0},0,null,null,"# 4",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W90","v":0},0]
[null,"# 8",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I91","v":0},0,null,null,"# 8",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W91","v":0},0]
[]
[null,"OPTIONAL: REDUCE SIZE OF -8 MAT'L PER TDOT PROCEDURE FOR BELT SAMPLING, ENTER AMOUNT OF -8 USED FOR FINE AGG SIEVE ANALYSIS BELOW",null,null,null,null,null,null,null,null,null,null,null,null,null,"OPTIONAL: REDUCE SIZE OF -8 MAT'L PER TDOT PROCEDURE FOR BELT SAMPLING, ENTER AMOUNT OF -8 USED FOR FINE AGG SIEVE ANALYSIS BELOW"]
[null,null,null,"Virgin Material",null,"RAP",null,null,null,null,null,null,null,null,null,null,null,"Virgin Material",null,"RAP"]
[null,"Wt. of - #8 original",null,{"$f":"D48*E56","v":{"$error":"#VALUE!"}},"grams",{"$f":"F48*H56","v":{"$error":"#VALUE!"}},"grams",null,null,null,null,null,null,null,null,"Wt. of - #8 original",null,{"$f":"R48*S56","v":{"$error":"#VALUE!"}},"grams",{"$f":"T48*V56","v":{"$error":"#VALUE!"}},"grams"]
[null,"Wt. of - #8 mt'l used",null,45,"grams",null,"grams",null,null,null,null,null,null,null,null,"Wt. of - #8 mt'l used",null,null,"grams",null,"grams"]
[null,null,null,{"$f":"D61/D60","v":{"$error":"#VALUE!"}},null,{"$f":"F61/F60","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"R61/R60","v":{"$error":"#VALUE!"}},null,{"$f":"T61/T60","v":{"$error":"#VALUE!"}}]
[null,null,"Virgin",null,null,"RAP",null,null,"Combined",null,null,"J.M.F.","Deviation",null,null,null,"Virgin",null,null,"RAP",null,null,"Combined",null,null,"J.M.F.","Deviation"]
[null,"Sieve","Wt. Ret.","% Ret","% Pass","Wt. Ret.","% Ret","% Pass","% Ret","% Pass",null,null,null,null,null,"Sieve","Wt. Ret.","% Ret","% Pass","Wt. Ret.","% Ret","% Pass","% Ret","% Pass"]
[null,"# 30",null,{"$f":"IF(ISBLANK(C65),\"\",$D$56+(C65/$D$62)/$D$48)","v":""},{"$f":"IF(ISBLANK(C65),\"\",1-D65)","v":""},null,{"$f":"IF(ISBLANK(F65),0,$G$19+(F65/$F$25)/$F$11)","v":0},{"$f":"IF(ISBLANK(F65),\"\",1-G65)","v":""},{"$f":"IF(ISBLANK(C65),\"\",D65*$D$10+G65*$F$10)","v":""},{"$f":"IF(ISBLANK(C65),0,100-I65)","v":0},null,{"$f":"'JMF1'!I93","v":0},{"$f":"ABS(J65-L65)","v":0},null,null,"# 30",null,{"$f":"IF(ISBLANK(Q65),\"\",$R$56+(Q65/$R$62)/$R$48)","v":""},{"$f":"IF(ISBLANK(Q65),\"\",1-R65)","v":""},null,{"$f":"IF(ISBLANK(T65),0,$U$56+(T65/$T$62)/$T$48)","v":0},{"$f":"IF(ISBLANK(T65),\"\",1-U65)","v":""},{"$f":"IF(ISBLANK(Q65),\"\",R65*$D$10+U65*$F$10)","v":""},{"$f":"IF(ISBLANK(Q65),0,100-W65)","v":0},null,{"$f":"'JMF1'!W93","v":0},{"$f":"ABS(X65-Z65)","v":0}]
[null,"# 50",null,{"$f":"IF(ISBLANK(C66),\"\",$D$56+(C66/$D$62)/$D$48)","v":""},{"$f":"IF(ISBLANK(C66),\"\",1-D66)","v":""},null,{"$f":"IF(ISBLANK(F66),0,$G$19+(F66/$F$25)/$F$11)","v":0},{"$f":"IF(ISBLANK(F66),\"\",1-G66)","v":""},{"$f":"IF(ISBLANK(C66),\"\",D66*$D$10+G66*$F$10)","v":""},{"$f":"IF(ISBLANK(C66),0,100-I66)","v":0},null,{"$f":"'JMF1'!I94","v":0},{"$f":"ABS(J66-L66)","v":0},null,null,"# 50",null,{"$f":"IF(ISBLANK(Q66),\"\",$R$56+(Q66/$R$62)/$R$48)","v":""},{"$f":"IF(ISBLANK(Q66),\"\",1-R66)","v":""},null,{"$f":"IF(ISBLANK(T66),0,$U$56+(T66/$T$62)/$T$48)","v":0},{"$f":"IF(ISBLANK(T66),\"\",1-U66)","v":""},{"$f":"IF(ISBLANK(Q66),\"\",R66*$D$10+U66*$F$10)","v":""},{"$f":"IF(ISBLANK(Q66),0,100-W66)","v":0},null,{"$f":"'JMF1'!W94","v":0},{"$f":"ABS(X66-Z66)","v":0}]
[null,"# 100",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I95","v":0},0,null,null,"# 100",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W95","v":0},0]
[null,"# 200",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!I96","v":0},0,null,null,"# 200",null,"","",null,0,"","",0,null,{"$f":"'JMF1'!W96","v":0},0]
[null,"Remarks:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Remarks:"]

{"sheet":"LOI ","index":8,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,1,45,2],[45,3,45,5],[49,2,54,8],[2,2,2,3],[2,6,2,7],[4,2,4,3],[4,6,4,7],[23,3,23,4],[44,1,44,2],[44,3,44,5]]}
["  "]
[]
[null,"Project No.",{"$f":"'JMF1'!C4","v":0},null,null,"Contr. No.",{"$f":"'JMF1'!C5","v":0}]
[]
[null,"Date","2010-10-26",null,null,"Type Mix",{"$f":"'JMF1'!E12","v":"OGFC "}]
[]
[1,"Calculating % Filter aid in Extracted Aggregate :"]
[]
[null,null,"NOTE:","Minimum size sample  =  600 grams"]
[]
[null,"(1)","Wt.of total recovered aggregate + filter aid",null,null,null,null,600]
[null,"(2)","Wt.of filter aid used in extraction",null,null,null,null,73]
[null,"(3)","Wt. of total recovered aggregate",null,null,null,null,{"$f":"H11-H12","v":527}]
[]
[null,null,"% filter aid = (2) divided by (1)  x  100 =",null,null,null,null,{"$f":"IF(H13=0,0,H12/H11)","v":0.12166666666666667}]
[]
[null,null,"% recovered aggregate = (3) divided by (1)  x  100 =",null,null,null,null,{"$f":"IF(H15=0,1,H13/H11)","v":0.8783333333333333}]
[]
[2,"Test Sample  ( Corrected for Filter aid ):"]
[]
[null,null,null,null,"Wt.of test sample ",null,null,600]
[]
[null,"(4)","Test sample  X  % Recovered Aggregate",null,null,null,"=",{"$f":"ROUND(H21*H17,1)","v":527}]
[null,null,null,100]
[]
[null,"(5)","Weight of container     =",null,null,null,null,100]
[]
[3,"Determining Weight Loss:"]
[]
[null,"Wt. of container  +  test sample  +  filter aid ( before ignition )",null,null,null,null,null,{"$f":"H21+H26","v":700}]
[]
[null,"Wt. of container  +  test sample  +  filter aid ( after ignition )",null,null,null,null,null,680]
[]
[null,null,null,null,"(6)","Weight loss",null,{"$f":"H30-H32","v":20}]
[]
[]
[]
[]
[4,"Calculating L.O.I. :"]
[]
[null,"L.O.I. =   (6) divided by (4)  X  100 = ",null,null,null,{"$f":"IF(H13=0,0,H34/H23*100)","v":3.795066413662239}]
[]
[]
[]
[null,"T.D.O.T. Insp.",null,{"$f":"'JMF1'!C63","v":0}]
[null,"Title",null,{"$f":"'JMF1'!G63","v":0}]
[]
[]
[]
[null,"Remarks:","hhh"]

{"sheet":"RICE GRAVITY (Gmm)","index":9,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[[7,3,7,4],[7,13,7,14],[5,16,5,18],[6,1,6,2],[6,4,6,5],[6,6,6,8],[6,14,6,15],[6,16,6,18],[5,14,5,15],[4,1,4,2],[5,1,5,2],[5,4,5,5],[5,6,5,8],[5,11,5,12]]}
[null,null,null,null,"MAXIMUM SPECIFIC GRAVITY",null,null,null,null,null,null,null,null,null,"MAXIMUM SPECIFIC GRAVITY"]
[null,null,null,null,"OF BITUMINOUS PAVING MIXTURES",null,null,null,null,null,null,null,null,null,"OF BITUMINOUS PAVING MIXTURES"]
[null,null,null,null,"A.M. Sample",null,null,null,null,null,null,null,null,null,"P.M. Sample"]
[null,null,null,null,"(AASHTO T - 209)",null,null,null,null,null,null,null,null,null,"(AASHTO T - 209)"]
["Date","2010-10-26",null,null,null,null,null,null,null,null,"Date"]
["Type Mix",{"$f":"'JMF1'!E12","v":"OGFC "},null,null,"T.D.O.T. Insp.",null,{"$f":"'JMF1'!C63","v":0},null,null,null,"Type Mix",{"$f":"B6","v":"OGFC "},null,null,"T.D.O.T. Insp.",null,{"$f":"G6","v":0}]
["Proj. No.",{"$f":"'JMF1'!C4","v":0},null,null,"Title",null,{"$f":"'JMF1'!G63","v":0},null,null,null,"Proj. No.",{"$f":"B7","v":"00:00:00"},null,null,"Title",null,{"$f":"G7","v":0}]
[null,null,null,"A.M. Sample",null,null,null,null,null,null,null,null,null,"P.M. Sample"]
[]
["JAR NO. 1",null,null,null,null,"% A.C.",null,null,null,null,"JAR NO. 1",null,null,null,null,"% A.C."]
[null,null,null,null,null,"SP.GR. A.C.",{"$f":"'JMF1'!C29","v":1.032},null,null,null,null,null,null,null,null,"SP.GR. A.C.",{"$f":"G11","v":1.032}]
["Wt. dry sample + jar",null,1606.5,null,null,null,null,null,null,null,"Wt. dry sample + jar"]
["Wt. jar                  -",null,null,null,null,null,null,null,null,null,"Wt. jar                  -"]
["Wt. dry sample    (A)",null,{"$f":"C12-C13","v":1606.5},null,null,null,null,null,null,null,"Wt. dry sample    (A)",null,{"$f":"M12-M13","v":0}]
[]
["Wt. JAR FILLED WITH WATER          (D)",null,null,null,null,null,7364.9,null,null,null,"Wt. JAR FILLED WITH WATER          (D)"]
[]
["Wt. JAR FILLED WITH WATER AND DRY SAMPLE            (E)",null,null,null,null,null,8307.7000000000007,null,null,null,"Wt. JAR FILLED WITH WATER AND DRY SAMPLE            (E)"]
[]
[]
["JAR NO. 2",null,null,null,null,"% A.C.",{"$f":"G10","v":0},null,null,null,"JAR NO. 2",null,null,null,null,"% A.C.",{"$f":"Q10","v":0}]
[null,null,null,null,null,null,{"$f":"G11","v":1.032},null,null,null,null,null,null,null,null,null,{"$f":"Q11","v":1.032}]
["Wt. dry sample + jar",null,null,null,null,null,null,null,null,null,"Wt. dry sample + jar"]
["Wt. jar                  -",null,null,null,null,null,null,null,null,null,"Wt. jar                  -"]
["Wt. dry sample    (A)",null,{"$f":"C23-C24","v":0},null,null,null,null,null,null,null,"Wt. dry sample    (A)",null,{"$f":"M23-M24","v":0}]
[]
["Wt. JAR FILLED WITH WATER          (D)",null,null,null,null,null,null,null,null,null,"Wt. JAR FILLED WITH WATER          (D)"]
[]
["Wt. JAR FILLED WITH WATER AND DRY SAMPLE            (E)",null,null,null,null,null,null,null,null,null,"Wt. JAR FILLED WITH WATER AND DRY SAMPLE            (E)"]
[]
[]
["CALCULATIONS",null,null,null,null,null,null,null,null,null,"CALCULATIONS"]
[]
["COMBINED WEIGHTS  JARS 1 & 2",null,null,null,null,null,null,null,null,null,"COMBINED WEIGHTS  JARS 1 & 2"]
[]
["WTS. DRY SAMPLE           (A)",null,null,null,{"$f":"IF(C25=0,C14,(C14+C25)/2)","v":1606.5},null,null,null,null,null,"WTS. DRY SAMPLE           (A)",null,null,null,{"$f":"IF(M25=0,M14,(M14+M25)/2)","v":0}]
["WTS. JAR FILLED WITH WATER         (D)",null,null,null,null,{"$f":"IF(G27=0,G16,(G16+G27)/2)","v":7364.9},null,null,null,null,"WTS. JAR FILLED WITH WATER         (D)",null,null,null,null,{"$f":"IF(Q27=0,Q16,(Q16+Q27)/2)","v":0}]
["WTS. JAR FILLED WITH WATER & DRY SAMPLE               (E)        ",null,null,null,null,null,{"$f":"IF(G29=0,G18,(G18+G29)/2)","v":8307.7000000000007},null,null,null,"WTS. JAR FILLED WITH WATER & DRY SAMPLE               (E)        ",null,null,null,null,null,{"$f":"IF(Q29=0,Q18,(Q18+Q29)/2)","v":0}]
[]
["MAXIMUM SPECIFIC GRAVITY OF MIX =  A / (A+D-E)   =",null,null,null,null,null,{"$f":"IF(C12=0,0,E36/(E36+F37-G38))","v":2.420521319873441},null,null,null,"MAXIMUM SPECIFIC GRAVITY OF MIX =  A / (A+D-E)   =",null,null,null,null,null,{"$f":"IF(M12=0,0,O36/(O36+P37-Q38))","v":0}]
[]
[]
["CALCULATION OF THE EFFECTIVE GRAVITY OF THE AGGREGATES:",null,null,null,null,null,null,null,null,null,"CALCULATION OF THE EFFECTIVE GRAVITY OF THE AGGREGATES:"]
[]
["EFFECTIVE GRAVITY = ",null,null,null,null,"% AGGREGATE",null,null,null,null,"EFFECTIVE GRAVITY = ",null,null,null,null,"% AGGREGATE"]
[null,null,null,100,null,"-","          % A.C.",null,null,null,null,null,null,100,null,"-","          % A.C."]
[null,null,null,"MAX.SP. GR. MIX",null,null,"       SP. GR. A.C.",null,null,null,null,null,null,"MAX.SP. GR. MIX",null,null,"       SP. GR. A.C."]
[]
[]
["EFFECTIVE GRAVITY = ",null,null,{"$f":"IF(G40=0,0,(100-G10)/(100/G40-G10/G11))","v":2.420521319873441},null,null,null,null,null,null,"EFFECTIVE GRAVITY = ",null,null,{"$f":"IF(Q40=0,0,(100-Q10)/(100/Q40-Q10/Q11))","v":0}]

{"sheet":"Marshall Worksheet","index":10,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[27,1,27,2],[36,6,36,9],[3,4,3,6],[3,8,3,9],[3,12,3,13],[10,1,10,2],[11,1,11,2],[26,1,26,2],[1,4,1,6],[1,8,1,9],[1,12,1,13],[2,0,2,1],[2,4,2,6],[2,8,2,9],[2,12,2,13]]}
[]
[null,null,null,"Date","2010-10-26",null,null,"Cont. No.                         ",{"$f":"'JMF1'!C5","v":0},null,"Contractor",null,{"$f":"'JMF1'!C6","v":0}]
[null,null,null,"Type Mix",{"$f":"'JMF1'!E12","v":"OGFC "},null,null,"County",{"$f":"'JMF1'!H5","v":0},null,"No. Hammer Blows",null,75]
[null,null,null,"Proj. No.",{"$f":"'JMF1'!C4","v":0},null,null,"Region",{"$f":"'JMF1'!H4","v":0},null,"sp.gr. a.c.",null,{"$f":"'JMF1'!C29","v":1.032}]
[]
[null,null,null,"Weight",null,"Grams","Volume","Bulk Sp.Gr.","Theo.","Effective","% Voids","% Voids","%  Voids","Unit Wt.","Stability","Flow"]
["Sample",null,null,"Marshall",null,"Specimen","Marshall","Marshall","Gravity","Gravity"," Total","Min. Agg.","Filled","(PCF)","  Lbs."," ( .01\")"]
["No.","%  AC","%  Agg.","In  Air","  S S D","In  Water","Specimen","Specimen","Mix","  Aggs.","  Mix","  (VMA)","With AC"]
[null,"A","B","C","D","      E","      F","       G","H","I","      J  ","K","L","M","O","P"]
[1,5.49,{"$f":"IF(B10=0,0,100-B10)","v":94.51},1181.8,1184.5999999999999,679.7,{"$f":"E10-F10","v":504.89999999999986},{"$f":"ROUND(IF(G10<1,0,D10/G10),3)","v":2.3410000000000002},2.4209999999999998,{"$f":"IF(I10=0,0,C10/((100/I10)-(B10/M4)))","v":2.6263371893557363},{"$f":"ROUND(IF(H13<1,0,100-H13/I10*100),1)","v":3.4},{"$f":"ROUND(IF(H13<1,0,100-C10*H13/J10),1)","v":15.8},{"$f":"ROUND(IF(H13<1,0,B10*H13/$M$4/L10*100),1)","v":78.8},{"$f":"H13*62.4","v":145.95359999999999},2350,14.5]
[2,"A.M.",null,1189.3,1190.5999999999999,682.4,{"$f":"E11-F11","v":508.19999999999993},{"$f":"ROUND(IF(G11<1,0,D11/G11),3)","v":2.34},null,null,null,null,null,null,2450,14]
[3,"Sample",null,1187.8,1189.2,680.8,{"$f":"E12-F12","v":508.40000000000009},{"$f":"ROUND(IF(G12<1,0,D12/G12),3)","v":2.3359999999999999},null,null,null,null,null,null,2500,14]
[null,null,null,null,null,null,"Average",{"$f":"IF(H12=0,(H10+H11)/2,(H10+H11+H12)/3)","v":2.339},null,null,null,null,null,"Average",{"$f":"IF(COUNT(O10:O12)>0,AVERAGE(O10:O12),\"\")","v":2433.3333333333335},{"$f":"IF(COUNT(P10:P12)>0,AVERAGE(P10:P12),\"\")","v":14.166666666666666}]
[1,null,{"$f":"IF(B14=0,0,100-B14)","v":0},null,null,null,{"$f":"E14-F14","v":0},{"$f":"ROUND(IF(G14<1,0,D14/G14),3)","v":0},null,{"$f":"IF(I14=0,0,C14/((100/I14)-(B14/M$4)))","v":0},{"$f":"ROUND(IF(H17<1,0,100-H17/I14*100),1)","v":0},{"$f":"ROUND(IF(H17<1,0,100-C14*H17/J14),1)","v":0},{"$f":"ROUND(IF(H17<1,0,B14*H17/$M$4/L14*100),1)","v":0},{"$f":"H17*62.4","v":0}]
[2,null,null,null,null,null,{"$f":"E15-F15","v":0},{"$f":"ROUND(IF(G15<1,0,D15/G15),3)","v":0}]
[3,null,null,null,null,null,{"$f":"E16-F16","v":0},{"$f":"ROUND(IF(G16<1,0,D16/G16),3)","v":0}]
[null,null,null,null,null,null,"Average",{"$f":"IF(H16=0,(H14+H15)/2,(H14+H15+H16)/3)","v":0},null,null,null,null,null,"Average",{"$f":"IF(COUNT(O14:O16)>0,AVERAGE(O14:O16),\"\")","v":""},{"$f":"IF(COUNT(P14:P16)>0,AVERAGE(P14:P16),\"\")","v":""}]
[1,null,{"$f":"IF(B18=0,0,100-B18)","v":0},null,null,null,{"$f":"E18-F18","v":0},{"$f":"ROUND(IF(G18<1,0,D18/G18),3)","v":0},null,{"$f":"IF(I18=0,0,C18/((100/I18)-(B18/M$4)))","v":0},{"$f":"ROUND(IF(H21<1,0,100-H21/I18*100),1)","v":0},{"$f":"ROUND(IF(H21<1,0,100-C18*H21/J18),1)","v":0},{"$f":"ROUND(IF(H21<1,0,B18*H21/$M$4/L18*100),1)","v":0},{"$f":"H21*62.4","v":0}]
[2,null,null,null,null,null,{"$f":"E19-F19","v":0},{"$f":"ROUND(IF(G19<1,0,D19/G19),3)","v":0}]
[3,null,null,null,null,null,{"$f":"E20-F20","v":0},{"$f":"ROUND(IF(G20<1,0,D20/G20),3)","v":0}]
[null,null,null,null,null,null,"Average",{"$f":"IF(H20=0,(H18+H19)/2,(H18+H19+H20)/3)","v":0},null,null,null,null,null,"Average",{"$f":"IF(COUNT(O18:O20)>0,AVERAGE(O18:O20),\"\")","v":""},{"$f":"IF(COUNT(P18:P20)>0,AVERAGE(P18:P20),\"\")","v":""}]
[1,null,{"$f":"IF(B22=0,0,100-B22)","v":0},null,null,null,{"$f":"E22-F22","v":0},{"$f":"ROUND(IF(G22<1,0,D22/G22),3)","v":0},null,{"$f":"IF(I22=0,0,C22/((100/I22)-(B22/M$4)))","v":0},{"$f":"ROUND(IF(H25<1,0,100-H25/I22*100),1)","v":0},{"$f":"ROUND(IF(H25<1,0,100-C22*H25/J22),1)","v":0},{"$f":"ROUND(IF(H25<1,0,B22*H25/$M$4/L22*100),1)","v":0},{"$f":"H25*62.4","v":0}]
[2,null,null,null,null,null,{"$f":"E23-F23","v":0},{"$f":"ROUND(IF(G23<1,0,D23/G23),3)","v":0}]
[3,null,null,null,null,null,{"$f":"E24-F24","v":0},{"$f":"ROUND(IF(G24<1,0,D24/G24),3)","v":0}]
[null,null,null,null,null,null,"Average",{"$f":"IF(H24=0,(H22+H23)/2,(H22+H23+H24)/3)","v":0},null,null,null,null,null,"Average",{"$f":"IF(COUNT(O22:O24)>0,AVERAGE(O22:O24),\"\")","v":""},{"$f":"IF(COUNT(P22:P24)>0,AVERAGE(P22:P24),\"\")","v":""}]
[1,null,{"$f":"IF(B26=0,0,100-B26)","v":0},null,null,null,{"$f":"E26-F26","v":0},{"$f":"ROUND(IF(G26<1,0,D26/G26),3)","v":0},null,{"$f":"IF(I26=0,0,C26/((100/I26)-(B26/M$4)))","v":0},{"$f":"ROUND(IF(H29<1,0,100-H29/I26*100),1)","v":0},{"$f":"ROUND(IF(H29<1,0,100-C26*H29/J26),1)","v":0},{"$f":"ROUND(IF(H29<1,0,B26*H29/$M$4/L26*100),1)","v":0},{"$f":"H29*62.4","v":0}]
[2,"P.M.",null,null,null,null,{"$f":"E27-F27","v":0},{"$f":"ROUND(IF(G27<1,0,D27/G27),3)","v":0}]
[3,"Sample",null,null,null,null,{"$f":"E28-F28","v":0},{"$f":"ROUND(IF(G28<1,0,D28/G28),3)","v":0}]
[null,null,null,null,null,null,"Average",{"$f":"IF(H28=0,(H26+H27)/2,(H26+H27+H28)/3)","v":0},null,null,null,null,null,"Average",{"$f":"IF(COUNT(O26:O28)>0,AVERAGE(O26:O28),\"\")","v":""},{"$f":"IF(COUNT(P26:P28)>0,AVERAGE(P26:P28),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"   Efff. Gr. Aggs.",null,null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null," 100 / H - A / Sp. gr. AC "]
[]
[null,null,null,null,null,null,null,null,null,null,"   Theo. Grav.",null,null,100]
[null,null,null,null,null,null,null,null,null,null,"(at any ac content)",null,"   A /Sp. Gr. AC + B / I"]

{"sheet":"TSR","index":11,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[4,2,4,4],[4,6,4,8],[1,2,1,4],[1,6,1,8],[2,2,2,4],[2,6,2,8],[3,2,3,4],[3,6,3,8]]}
[]
["Project no.",null,{"$f":"'JMF1'!C4","v":0},null,null,"Type Mix",{"$f":"'JMF1'!E12","v":"OGFC "}]
[" Additive",null,{"$f":"'JMF1'!D27","v":0},null,null,"Dosage",{"$f":"'JMF1'!I27","v":0}]
["Compaction Method",null,"MARSHALL",null,null,"Effort",17]
["Date tested",null,"2010-10-26",null,null,"By",{"$f":"'JMF1'!C63","v":0}]
[]
[]
["Sample I.D.",null,null,1,2,3,4,5,6]
[]
["Diameter",null,"D",4,4,4,4,4,4]
[]
["Thickness",null,"T",2.61,2.6,2.58,2.6,2.59,2.58]
[]
["Dry mass in air",null,"A",1186.2,1183.5,1190.5999999999999,1181.5999999999999,1184.9000000000001,1180.5]
[]
["SSD mass",null,"B",1191.7,1188.5999999999999,1195.7,1189.8,1192,1189.7]
[]
["Mass in Water",null,"C",666.1,662.8,667.8,660,663.3,661.2]
[]
["Volume (B-C)",null,"E",{"$f":"D16-D18","v":525.6},525.79999999999995,527.90000000000009,529.79999999999995,528.70000000000005,528.5]
[]
["Bulk sp. gr. (A/E)",null,"F",{"$f":"IF(D20=0,0,(D14/D20))","v":2.256849315068493},2.2508558387219475,2.2553513923091488,2.2302755756889394,2.2411575562700965,2.2336802270577105]
[]
["Max sp. gr.",null,"G",2.4209999999999998,{"$f":"+D24","v":2.4209999999999998},{"$f":"+E24","v":2.4209999999999998},{"$f":"+F24","v":2.4209999999999998},{"$f":"+G24","v":2.4209999999999998},{"$f":"+H24","v":2.4209999999999998}]
[]
["% air void (100(G-F)/G)",null,"H",{"$f":"IF(D14=0,0,100*(D24-D22)/D24)","v":6.7802843837879747},7.0278463972760159,6.8421564515014879,7.8779192197877084,7.428436337459865,7.7372892582523463]
[]
["Volume air void, HE/100 ",null,"I",{"$f":"(D26*D20/100)","v":35.637174721189595},{"$f":"ROUND((E26*E20/100),1)","v":37},{"$f":"ROUND((F26*F20/100),1)","v":36.1},{"$f":"ROUND((G26*G20/100),1)","v":41.7},{"$f":"ROUND((H26*H20/100),1)","v":39.299999999999997},{"$f":"ROUND((I26*I20/100),1)","v":40.9}]
[]
["Load",null,"P",null,null,null,2050,2180,2000]
["Saturated",null,"minute @ ",null,null,"\"hg"]
[]
["SSD Mass",null,"B'",1211.7,1209.3,1214.8]
[]
["Vol. Abs. water (B'-A)",null,"J'",{"$f":"IF(D33<1,0,D33-D14)","v":25.5},25.799999999999955,24.200000000000045,0,0,0]
[]
["Saturation (100J' / I)",null,null,{"$f":"IF(D14=0,0,100*(D35/D28))","v":71.554493866310594},69.729729729729613,67.036011080332543,0,0,0]
["Conditioned 24 hours in 140 degree F. water"]
[]
["Thickness",null,"T'",2.61,2.6,2.58,2.6,2.59,2.58]
[]
["Load",null,"P'",1750,1700,1800]
[]
["Dry 2P / ( T * D * 3.1416)",null,null,{"$f":"IF(D30=0,0,2*D30/(D12*D10*3.1416))","v":0},0,0,125.48725784019901,133.96021799383144,123.37563637153241]
["Average dry strength",null,"S td",{"$f":"ROUND(SUM(D44:I44)/3,1)","v":127.6}]
["Wet 2P' / (T' * D * 3.1416)",null,null,{"$f":"IF(D40<1,0,ROUND(2*D42/(D40*D10*3.1416),1))","v":106.7},104.1,111,0,0,0]
["Average wet strength",null,"S tm",{"$f":"ROUND(SUM(D46:I46)/3,1)","v":107.3}]
["100 S tm / S td     ( TSR )",null,null,{"$f":"ROUND(IF(D45<1,0,100*D47/D45),1)","v":84.1}]
["Visual moisture damage"]
["Crack and break aggregate"]

{"sheet":" MOIST TEST","index":12,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[46,6,46,7],[47,6,47,7],[40,6,40,7],[41,6,41,7],[42,6,42,7],[43,6,43,7],[44,6,44,7],[45,6,45,7],[39,6,39,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[31,6,31,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[36,6,36,7],[37,6,37,7],[38,6,38,7],[27,6,27,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[15,6,15,7],[0,2,0,6],[3,1,3,2],[6,6,6,7],[7,6,7,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7]]}
[null,null,"MOISTURE IN RECYCLE MIX"]
[]
[]
["TYPE MIX",{"$f":"'JMF1'!E12","v":"OGFC "},null,null,null,null,"PROJ. NO.",{"$f":"'JMF1'!C4","v":0}]
[]
[null,null,"Wt.","Wt. After",null,"Percent"]
[null,"Date"," Sample (1)","Drying (2)","Diff. (3)","Moisture","Inspector"]
[null,"2010-10-26",1582.4,1581.6,{"$f":"C8-D8","v":0.8000000000001819},{"$f":"IF(E8=0,0,E8/C8)","v":5.0556117290203608E-4},{"$f":"IF(F8=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,{"$f":"C9-D9","v":0},{"$f":"IF(E9=0,0,E9/C9)","v":0},{"$f":"IF(F9=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F10=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F11=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F12=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F13=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F14=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F15=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F16=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F17=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F18=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F19=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F20=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F21=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F22=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F23=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F24=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F25=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,{"$f":"C26-D26","v":0},0,{"$f":"IF(F26=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,{"$f":"C27-D27","v":0},0,{"$f":"IF(F27=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F28=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F29=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F30=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F31=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F32=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F33=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F34=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F35=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F36=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F37=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F38=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F39=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F40=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F41=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F42=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F43=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F44=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F45=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F46=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F47=0,0,'JMF1'!$C$63)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F48=0,0,'JMF1'!$C$63)","v":0}]
[]
[]
[null,"NOTE:","% Moisture = (3) divided by (1)  X  100"]

{"sheet":"DAILY PLANT REPORT","index":13,"n_rows":63,"n_cols":64,"rows_kept":63,"cut":false,"hidden":false,"merged":[[32,27,32,36],[36,52,36,55],[36,56,36,59],[36,60,36,63],[52,46,52,47],[28,6,28,8],[29,6,29,8],[36,48,36,51],[38,46,38,47],[39,46,39,47],[40,46,40,47],[41,46,41,47],[42,46,42,47],[43,46,43,47],[44,46,44,47],[45,46,45,47],[46,46,46,47],[47,46,47,47],[48,46,48,47],[49,46,49,47],[50,46,50,47],[51,46,51,47],[50,31,50,36],[51,6,51,8],[61,18,61,19],[61,20,61,35],[62,18,62,19],[62,20,62,35],[52,30,52,31],[52,35,52,36],[54,27,54,33],[54,12,54,14],[54,15,54,17],[55,5,58,34],[55,2,55,4],[51,27,51,31],[51,32,51,36],[52,2,52,5],[52,6,52,8],[52,9,52,11],[52,12,52,14],[52,15,52,17],[52,18,52,20],[52,22,52,24],[54,6,54,8],[54,9,54,11],[54,2,54,5],[51,9,51,11],[51,12,51,14],[51,15,51,17],[51,18,51,20],[51,21,51,22],[51,24,51,25],[50,2,50,5],[50,6,50,8],[50,9,50,11],[50,12,50,14],[50,15,50,17],[50,18,50,20],[50,21,50,22],[50,24,50,25],[50,27,50,30],[48,31,48,36],[49,2,49,5],[49,6,49,8],[49,9,49,11],[49,12,49,14],[49,15,49,17],[49,18,49,20],[49,21,49,22],[49,24,49,25],[49,27,49,30],[49,31,49,36],[48,2,48,5],[48,6,48,8],[48,9,48,11],[48,12,48,14],[48,15,48,17],[48,18,48,20],[48,21,48,22],[48,24,48,25],[48,27,48,30],[46,31,46,36],[47,2,47,5],[47,6,47,8],[47,9,47,11],[47,12,47,14],[47,15,47,17],[47,18,47,20],[47,21,47,22],[47,24,47,25],[47,27,47,30],[47,31,47,36],[46,2,46,5],[46,6,46,8],[46,9,46,11],[46,12,46,14],[46,15,46,17],[46,18,46,20],[46,21,46,22],[46,24,46,25],[46,27,46,30],[44,31,44,36],[45,2,45,5],[45,6,45,8],[45,9,45,11],[45,12,45,14],[45,15,45,17],[45,18,45,20],[45,21,45,22],[45,24,45,25],[45,27,45,30],[45,31,45,36],[44,2,44,5],[44,6,44,8],[44,9,44,11],[44,12,44,14],[44,15,44,17],[44,18,44,20],[44,21,44,22],[44,24,44,25],[44,27,44,30],[42,34,42,35],[43,2,43,5],[43,6,43,8],[43,9,43,11],[43,12,43,14],[43,15,43,17],[43,18,43,20],[43,21,43,22],[43,24,43,25],[43,27,43,36],[42,2,42,5],[42,6,42,8],[42,9,42,11],[42,12,42,14],[42,15,42,17],[42,18,42,20],[42,21,42,22],[42,24,42,25],[42,32,42,33],[40,34,40,35],[41,2,41,5],[41,6,41,8],[41,9,41,11],[41,12,41,14],[41,15,41,17],[41,18,41,20],[41,21,41,22],[41,24,41,25],[41,32,41,33],[41,34,41,35],[40,2,40,5],[40,6,40,8],[40,9,40,11],[40,12,40,14],[40,15,40,17],[40,18,40,20],[40,21,40,22],[40,24,40,25],[40,32,40,33],[38,34,38,35],[39,2,39,5],[39,6,39,8],[39,9,39,11],[39,12,39,14],[39,15,39,17],[39,18,39,20],[39,21,39,22],[39,24,39,25],[39,32,39,33],[39,34,39,35],[38,2,38,5],[38,6,38,8],[38,9,38,11],[38,12,38,14],[38,15,38,17],[38,18,38,20],[38,21,38,22],[38,24,38,25],[38,32,38,33],[36,18,36,20],[37,2,37,5],[37,6,37,8],[37,9,37,11],[37,12,37,14],[37,15,37,17],[37,18,37,20],[33,29,33,30],[33,35,33,36],[35,2,36,5],[35,6,35,20],[35,21,36,26],[35,27,36,36],[36,6,36,8],[36,9,36,11],[36,12,36,14],[36,15,36,17],[37,21,37,22],[37,24,37,25],[37,32,37,33],[37,34,37,35],[32,6,32,20],[32,21,32,26],[33,6,34,9],[33,11,34,14],[33,16,34,19],[33,21,34,26],[31,2,31,5],[31,6,31,7],[31,9,31,11],[31,12,31,26],[31,27,31,31],[31,32,31,36],[30,2,30,5],[30,6,30,7],[30,9,30,11],[30,12,30,26],[30,27,30,31],[30,32,30,36],[29,2,29,5],[29,9,29,11],[29,12,29,26],[29,27,29,31],[29,32,29,36],[28,2,28,5],[28,9,28,11],[28,12,28,26],[28,27,28,31],[28,32,28,36],[27,2,27,5],[27,6,27,8],[27,9,27,11],[27,12,27,26],[27,27,27,31],[27,32,27,36],[26,2,26,5],[26,6,26,8],[26,9,26,11],[26,12,26,26],[26,27,26,31],[26,32,26,36],[25,2,25,5],[25,6,25,8],[25,9,25,11],[25,12,25,26],[25,27,25,31],[25,32,25,36],[24,2,24,5],[24,6,24,8],[24,9,24,11],[24,12,24,26],[24,27,24,31],[24,32,24,36],[23,2,23,5],[23,6,23,8],[23,9,23,11],[23,12,23,26],[23,27,23,31],[23,32,23,36],[21,32,21,36],[22,2,22,5],[22,6,22,8],[22,9,22,11],[22,12,22,26],[22,27,22,31],[22,32,22,36],[19,2,19,11],[19,12,20,26],[19,27,20,36],[20,2,20,5],[20,6,20,11],[21,2,21,5],[21,6,21,8],[21,9,21,11],[21,12,21,26],[21,27,21,31],[17,2,17,7],[17,8,17,13],[17,14,17,20],[17,21,17,27],[17,28,17,33],[17,34,17,36],[15,26,15,29],[15,33,15,36],[16,2,16,5],[16,6,16,10],[16,11,16,19],[16,20,16,27],[16,28,16,31],[16,32,16,36],[15,5,15,8],[15,9,15,10],[15,12,15,14],[15,15,15,16],[15,20,15,21],[15,22,15,25],[13,28,13,31],[13,32,13,36],[14,2,14,7],[14,8,14,12],[14,14,14,18],[14,19,14,22],[13,2,13,5],[13,6,13,10],[13,11,13,12],[13,13,13,17],[13,18,13,19],[13,20,13,27],[14,23,14,36],[11,2,11,5],[11,6,11,28],[11,29,11,30],[11,31,11,36],[12,2,12,4],[12,5,12,18],[12,19,12,23],[12,24,12,36],[9,31,9,36],[10,2,10,4],[10,5,10,9],[10,12,10,26],[10,29,10,30],[10,31,10,36],[8,2,8,4],[8,5,8,9],[9,2,9,4],[9,5,9,9],[9,12,9,26],[9,29,9,30],[2,2,2,36],[3,2,3,36],[4,2,4,36],[5,2,5,36],[6,2,6,36],[7,2,7,36]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,null,"STATE OF TENNESSEE"]
[null,null,"DEPARTMENT OF TRANSPORTATION"]
[null,null,"DIVISION OF MATERIALS AND TESTS"]
[null,null,"6601 CENTENNIAL BLVD."]
[null,null,"NASHVILLE, TENNESSEE 37243-0360"]
[null,null,"Item No.",null,null,{"$f":"'JMF1'!I12","v":0}]
[null,null,"State Rt.",null,null,{"$f":"'JMF1'!C7","v":0},null,null,null,null,null,null,"DAILY REPORT OF ASPHALT PLANT INSPECTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,"2017-02-24",null,null,null,null,null,null,null,null,null,3]
[null,null,"Report No.",null,null,{"$f":"VLOOKUP(AF10,'RECAP SHEET  '!B11:C80,2)","v":1},null,null,null,null,null,null,"UNOFFICIAL (For Calculating SiteManager Inputs Only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region",null,{"$f":"'JMF1'!H4","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AND(AP10=3)","v":true}]
[null,null,"Reference No.",null,null,null,{"$f":"'JMF1'!C3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County",null,{"$f":"'JMF1'!H5","v":0}]
[null,null,"Project No.",null,null,{"$f":"'JMF1'!C4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Prime Contractor",null,null,null,null,{"$f":"'JMF1'!C6","v":0}]
[null,null,"Air Tem. Min.",null,null,null,null,null,null,null,null,"Max.",null,null,null,null,null,null,"Grading",null,{"$f":"'JMF1'!E12","v":"OGFC "},null,null,null,null,null,null,null,"Contract No.",null,null,null,{"$f":"'JMF1'!C5","v":0}]
[null,null,"Make of Plant & Loc.:",null,null,null,null,null,{"$f":"'JMF1'!C8","v":0},null,null,null,null,",",{"$f":"'JMF1'!H8","v":0},null,null,null,null,"Paving Contractor",null,null,null,{"$f":"'HMA Producers'!E1","v":0}]
[null,null,"Tonnes(Tons)",null,null,"Rap  Agg.",null,null,null,{"$f":"(AH16*(C29+C28)/100)","v":0},null,null,"Rap A.C.",null,null,{"$f":"(AH16*C30)/100","v":0},null,null,"Virgin A.C.",null,{"$f":"(AH16*C22)/100","v":24.548299999999998},null,"Virgin  Agg.",null,null,null,{"$f":"AH16-U16-P16-J16","v":326.14170000000001},null,null,null,null,"Total Mix",null,{"$f":"VLOOKUP(AF10,'RECAP SHEET  '!B11:H129,7)","v":350.69}]
[null,null,"Stripping Test",null,null,null,{"$f":"VLOOKUP(Stuff!AL91,Stuff!AL92:AM93,2)","v":"Good"},null,null,null,null,"Dust Coating +4.75 mm (No. 4) Material",null,null,null,null,null,null,null,null,{"$f":"'DUST COATING & FUEL CONT. '!F38","v":4.4116498789725078E-3},null,null,null,null,null,null,null,"Silicone Used:"]
[null,null,"Fractured Face Count",null,null,null,null,null,{"$f":"IF(AP10=3,0,IF($AP$10=1,EXTRACTION!D53,'BURNOUT OVEN '!C54))","v":0},null,null,null,null,null,"% Glassy Particles by Weight",null,null,null,null,null,null,{"$f":"IF(AP10=3,0,IF(AP10=1,EXTRACTION!I53,'BURNOUT OVEN '!F54))","v":0},null,null,null,null,null,null,"Moisture in Recycle Mix",null,null,null,null,null,{"$f":"VLOOKUP(AF10, ' MOIST TEST'!B8:F48,5)","v":5.0556117290203608E-4}]
[]
[null,null,"Percentage A.C. and Cold Feed Bins",null,null,null,null,null,null,null,null,null,"Producer and Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mix Temperature"]
[null,null,"% from J.M.F",null,null,null,"Material"]
[null,null,{"$f":"'JMF1'!D28","v":7},null,null,null,"Virgin A.C.   Perf. Grade ",null,null,{"$f":"'JMF1'!C24","v":0},null,null,{"$f":"'JMF1'!E24","v":0}]
[1,null,{"$f":"'JMF1'!I17","v":93},null,null,null,{"$f":"'JMF1'!C17","v":0},null,null,{"$f":"'JMF1'!A17","v":0},null,null,{"$f":"'JMF1'!E17","v":0}]
[2,null,{"$f":"'JMF1'!I18","v":0},null,null,null,{"$f":"'JMF1'!C18","v":0},null,null,{"$f":"'JMF1'!A18","v":0},null,null,{"$f":"'JMF1'!E18","v":0}]
[3,null,{"$f":"'JMF1'!I19","v":0},null,null,null,{"$f":"'JMF1'!C19","v":0},null,null,{"$f":"'JMF1'!A19","v":0},null,null,{"$f":"'JMF1'!E19","v":0}]
[4,null,{"$f":"'JMF1'!I20","v":0},null,null,null,{"$f":"'JMF1'!C20","v":0},null,null,{"$f":"'JMF1'!A20","v":0},null,null,{"$f":"'JMF1'!E20","v":0}]
[5,null,{"$f":"'JMF1'!I21","v":0},null,null,null,{"$f":"'JMF1'!C21","v":0},null,null,{"$f":"'JMF1'!A21","v":0},null,null,{"$f":"'JMF1'!E21","v":0}]
[6,null,{"$f":"'JMF1'!I22-'JMF1'!I22*'JMF1'!C25/100","v":0},null,null,null,{"$f":"'JMF1'!C22","v":0},null,null,{"$f":"'JMF1'!A22","v":0},null,null,{"$f":"'JMF1'!E22","v":0}]
[null,null,{"$f":"'JMF1'!I23-'JMF1'!I23*'JMF1'!C26/100","v":0},null,null,null,{"$f":"'JMF1'!C23","v":0},null,null,{"$f":"'JMF1'!A23","v":0},null,null,{"$f":"'JMF1'!E23","v":0}]
[null,null,{"$f":"'JMF1'!F28","v":0},null,null,null,"Total Rap A.C.",null,null,{"$f":"'JMF1'!F28","v":0}]
[null,null,null,null,null,null,"Filler"]
[null,null,{"$f":"SUM(C22:F31)","v":100},null,null,null,"Total"]
[null,null,null,null,null,null,"Method Used to Obtain Complete Mix Gradation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design Number",null,null,null,null,null,"Deviation from Burnout Oven Calibration Factor"]
[null,null,null,null,null,null,"Belt Sample",null,null,null,null,"Extraction",null,null,null,null,"Burnout Oven",null,null,null,null,{"$f":"'JMF1'!H14","v":0},null,null,null,null,null,"Target",null,{"$f":"'JMF1'!I35","v":0.45},null,"  Weekly Check",null,"Actual",null,0.25]
[]
[null,null,null,null,null,null,"Percent Passing Each Sieve",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job Mix Formula Tolerances",null,null,null,null,null,"Marshall Properties                                  each 1/2 days production",null,null,null,null,null,null,null,null,null,null,null,"plus",null,"plus","minus","minus"]
[null,null,null,null,null,null,"Sample 1",null,null,"Sample 2",null,null,"Sample 3",null,null,"Sample 4",null,null,"Sample 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"one test ",null,"two or more","one test ","two or more",null,null,null,null,null,null,null,null,"Belt",null,null,null,"Extraction",null,null,null,"Burnout"]
[null,null,"50 mm (2 in.)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA39,IF($AP$10=3,#REF!,IF($AP$10=1,BE39,BI39))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB39,IF($AP$10=3,#REF!,IF($AP$10=1,BF39,BJ39))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC39,IF($AP$10=3,#REF!,IF($AP$10=1,BG39,BK39))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD39,IF($AP$10=3,#REF!,IF($AP$10=1,BH39,BL39))),\"\")","v":0},null,null,null,null,null,{"$f":"IF(X38=0,0,IF(J38=0,AQ38,AR38))","v":0},null,{"$f":"'JMF1'!I45","v":0},{"$f":"IF(X38=0,0,IF(J38=0,AN38,AP38))","v":0},null,null,null,null,null,null,null,"A.M.",null,"P.M.",null,null,null,null,{"$f":"IF(X38>93.5,\"100\",X38+6.5)","v":6.5},null,{"$f":"IF(X38>94.3,\"100\",X38+5.7)","v":5.7},{"$f":"X38-6.5","v":-6.5},{"$f":"X38-5.7","v":-5.7},null,null,null,null,null,null,null,null,1,2,3,4,1,2,3,4,1,2,3,4]
[null,null,"37.5 mm (1-1/2 in.)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA40,IF($AP$10=3,#REF!,IF($AP$10=1,BE40,BI40))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB40,IF($AP$10=3,#REF!,IF($AP$10=1,BF40,BJ40))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC40,IF($AP$10=3,#REF!,IF($AP$10=1,BG40,BK40))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD40,IF($AP$10=3,#REF!,IF($AP$10=1,BH40,BL40))),\"\")","v":0},null,null,null,null,null,{"$f":"IF(X39=0,0,IF(J39=0,AQ39,AR39))","v":0},null,{"$f":"'JMF1'!I46","v":0},{"$f":"IF(X39=0,0,IF(J39=0,AN39,AP39))","v":0},null,null,"Voids in Tot. Mix",null,null,null,null,{"$f":"'Marshall Worksheet'!K10","v":3.4},null,{"$f":"'Marshall Worksheet'!K26","v":0},null,null,null,null,6.5,null,{"$f":"IF(X39>94.3,\"100\",X39+5.7)","v":5.7},-6.5,{"$f":"X39-5.7","v":-5.7},null,null,"50 mm (2 in.)",null,null,null,null,null,{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J14","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J51","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X14","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X51","v":0}]
[null,null,"31.5 mm (1-1/4 in.)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA41,IF($AP$10=3,#REF!,IF($AP$10=1,BE41,BI41))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB41,IF($AP$10=3,#REF!,IF($AP$10=1,BF41,BJ41))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC41,IF($AP$10=3,#REF!,IF($AP$10=1,BG41,BK41))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD41,IF($AP$10=3,#REF!,IF($AP$10=1,BH41,BL41))),\"\")","v":0},null,null,null,null,null,{"$f":"IF(X40=0,0,IF(J40=0,AQ40,AR40))","v":43.5},null,{"$f":"'JMF1'!I47","v":50},{"$f":"IF(X40=0,0,IF(J40=0,AN40,AP40))","v":56.5},null,null,"Gse (Eff S.G. Agg.)",null,null,null,null,{"$f":"'RICE GRAVITY (Gmm)'!D50","v":2.420521319873441},null,{"$f":"'RICE GRAVITY (Gmm)'!N50","v":0},null,null,null,null,56.5,null,55.7,43.5,44.3,null,null,"37.5 mm (1-1/2 in.)",null,null,null,null,null,{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J15","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J52","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X15","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X52","v":0},{"$f":"EXTRACTION!D34","v":0},{"$f":"EXTRACTION!I34","v":0},{"$f":"EXTRACTION!N34","v":0},{"$f":"EXTRACTION!S34","v":0},{"$f":"'BURNOUT OVEN '!D13","v":0},{"$f":"'BURNOUT OVEN '!K13","v":0},{"$f":"'BURNOUT OVEN '!R13","v":0},{"$f":"'BURNOUT OVEN '!Y13","v":0}]
[null,null,"25.0 mm (1 in.)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA42,IF($AP$10=3,#REF!,IF($AP$10=1,BE42,BI42))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB42,IF($AP$10=3,#REF!,IF($AP$10=1,BF42,BJ42))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC42,IF($AP$10=3,#REF!,IF($AP$10=1,BG42,BK42))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD42,IF($AP$10=3,#REF!,IF($AP$10=1,BH42,BL42))),\"\")","v":0},null,null,null,null,null,43.5,null,{"$f":"'JMF1'!I48","v":50},56.5,null,null,"Voids in Min. Agg.",null,null,null,null,{"$f":"'Marshall Worksheet'!L10","v":15.8},null,{"$f":"'Marshall Worksheet'!L26","v":0},null,null,null,null,56.5,null,55.7,43.5,44.3,null,null,"31.5 mm (1-1/4 in.)",null,null,null,null,null,null,null,null,null,{"$f":"EXTRACTION!D35","v":0},{"$f":"EXTRACTION!I35","v":0},{"$f":"EXTRACTION!N35","v":0},{"$f":"EXTRACTION!S35","v":0},{"$f":"'BURNOUT OVEN '!D14","v":0},{"$f":"'BURNOUT OVEN '!K14","v":0},{"$f":"'BURNOUT OVEN '!R14","v":0},{"$f":"'BURNOUT OVEN '!Y14","v":0}]
[null,null,"19.0 mm (3/4 in.)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA43,IF($AP$10=3,#REF!,IF($AP$10=1,BE43,BI43))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB43,IF($AP$10=3,#REF!,IF($AP$10=1,BF43,BJ43))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC43,IF($AP$10=3,#REF!,IF($AP$10=1,BG43,BK43))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD43,IF($AP$10=3,#REF!,IF($AP$10=1,BH43,BL43))),\"\")","v":0},null,null,null,null,null,43.5,null,{"$f":"'JMF1'!I49","v":50},56.5,null,null,"Stability",null,null,null,null,{"$f":"'Marshall Worksheet'!O13","v":2433.3333333333335},null,{"$f":"'Marshall Worksheet'!L26","v":0},null,null,null,null,56.5,null,55.7,43.5,44.3,null,null,"25.0 mm (1 in.)",null,null,null,null,null,null,null,null,null,{"$f":"EXTRACTION!D36","v":0},{"$f":"EXTRACTION!I36","v":0},{"$f":"EXTRACTION!N36","v":0},{"$f":"EXTRACTION!S36","v":0},{"$f":"'BURNOUT OVEN '!D15","v":0},{"$f":"'BURNOUT OVEN '!K15","v":0},{"$f":"'BURNOUT OVEN '!R15","v":0},{"$f":"'BURNOUT OVEN '!Y15","v":0}]
[null,null,"16.0 mm (5/8 in.)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA44,IF($AP$10=3,#REF!,IF($AP$10=1,BE44,BI44))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB44,IF($AP$10=3,#REF!,IF($AP$10=1,BF44,BJ44))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC44,IF($AP$10=3,#REF!,IF($AP$10=1,BG44,BK44))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD44,IF($AP$10=3,#REF!,IF($AP$10=1,BH44,BL44))),\"\")","v":0},null,null,null,null,null,43.5,null,{"$f":"'JMF1'!I50","v":50},56.5,null,null,"Rice Gravity (Gmm)",null,null,null,null,{"$f":"'RICE GRAVITY (Gmm)'!G40","v":2.420521319873441},null,{"$f":"'RICE GRAVITY (Gmm)'!Q40","v":0},null,null,null,null,56.5,null,55.7,43.5,44.3,null,null,"19.0 mm (3/4 in.)",null,null,null,null,null,{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J16","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J53","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X16","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X53","v":0},{"$f":"EXTRACTION!D37","v":0},{"$f":"EXTRACTION!I37","v":0},{"$f":"EXTRACTION!N37","v":0},{"$f":"EXTRACTION!S37","v":0},{"$f":"'BURNOUT OVEN '!D16","v":84.264662627005748},{"$f":"'BURNOUT OVEN '!K16","v":84.153644154111277},{"$f":"'BURNOUT OVEN '!R16","v":84.153644154111277},{"$f":"'BURNOUT OVEN '!Y16","v":84.153644154111277}]
[null,null,"12.5 mm (1/2 in.)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA45,IF($AP$10=3,#REF!,IF($AP$10=1,BE45,BI45))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB45,IF($AP$10=3,#REF!,IF($AP$10=1,BF45,BJ45))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC45,IF($AP$10=3,#REF!,IF($AP$10=1,BG45,BK45))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD45,IF($AP$10=3,#REF!,IF($AP$10=1,BH45,BL45))),\"\")","v":0},null,null,null,null,null,41.5,null,{"$f":"'JMF1'!I51","v":48},54.5,null,null,"ANTI STRIPPING AGENT",null,null,null,null,null,null,null,null,null,null,null,54.5,null,53.7,41.5,42.3,null,null,"16.0 mm (5/8 in.)",null,null,null,null,null,null,null,null,null,{"$f":"EXTRACTION!D38","v":99.999360654689596},{"$f":"EXTRACTION!I38","v":99.999314411079112},{"$f":"EXTRACTION!N38","v":0},{"$f":"EXTRACTION!S38","v":0},{"$f":"'BURNOUT OVEN '!D17","v":0},{"$f":"'BURNOUT OVEN '!K17","v":0},{"$f":"'BURNOUT OVEN '!R17","v":0},{"$f":"'BURNOUT OVEN '!Y17","v":0}]
[null,null,"9.5 mm (3/8 in.)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA46,IF($AP$10=3,#REF!,IF($AP$10=1,BE46,BI46))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB46,IF($AP$10=3,#REF!,IF($AP$10=1,BF46,BJ46))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC46,IF($AP$10=3,#REF!,IF($AP$10=1,BG46,BK46))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD46,IF($AP$10=3,#REF!,IF($AP$10=1,BH46,BL46))),\"\")","v":0},null,null,null,null,null,41.5,null,{"$f":"'JMF1'!I52","v":48},54.5,null,null,"Brand of ASA",null,null,null,{"$f":"'JMF1'!D27","v":0},null,null,null,null,null,null,null,54.5,null,53.7,41.5,42.3,null,null,"12.5 mm (1/2 in.)",null,null,null,null,null,null,null,null,null,{"$f":"EXTRACTION!D39","v":97.007863947317944},{"$f":"EXTRACTION!I39","v":96.26354038118744},{"$f":"EXTRACTION!N39","v":0},{"$f":"EXTRACTION!S39","v":0},{"$f":"'BURNOUT OVEN '!D18","v":0},{"$f":"'BURNOUT OVEN '!K18","v":0},{"$f":"'BURNOUT OVEN '!R18","v":0},{"$f":"'BURNOUT OVEN '!Y18","v":0}]
[null,null,"4.75 mm (No. 4)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA47,IF($AP$10=3,#REF!,IF($AP$10=1,BE47,BI47))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB47,IF($AP$10=3,#REF!,IF($AP$10=1,BF47,BJ47))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC47,IF($AP$10=3,#REF!,IF($AP$10=1,BG47,BK47))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD47,IF($AP$10=3,#REF!,IF($AP$10=1,BH47,BL47))),\"\")","v":0},null,null,null,null,null,43.38,null,{"$f":"'JMF1'!I53","v":48},52.62,null,null,"% ASA on JMF",null,null,null,{"$f":"'JMF1'!I27","v":0},null,null,null,null,null,null,null,{"$f":"IF(X46>95.38,\"100\",X46+4.62)","v":52.62},null,{"$f":"IF(X46>96,\"100\",X46+4)","v":52},{"$f":"X46-4.62","v":43.38},{"$f":"X46-4","v":44},null,null,"9.5 mm (3/8 in.)",null,null,null,null,null,{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J17","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J54","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X17","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X54","v":0},{"$f":"EXTRACTION!D40","v":83.517677897832613},{"$f":"EXTRACTION!I40","v":84.779925956396539},{"$f":"EXTRACTION!N40","v":0},{"$f":"EXTRACTION!S40","v":0},{"$f":"'BURNOUT OVEN '!D19","v":59.413820617557292},{"$f":"'BURNOUT OVEN '!K19","v":59.127470503234775},{"$f":"'BURNOUT OVEN '!R19","v":59.127470503234775},{"$f":"'BURNOUT OVEN '!Y19","v":59.127470503234775}]
[null,null,"2.36 mm (No. 8)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA48,IF($AP$10=3,#REF!,IF($AP$10=1,BE48,BI48))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB48,IF($AP$10=3,#REF!,IF($AP$10=1,BF48,BJ48))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC48,IF($AP$10=3,#REF!,IF($AP$10=1,BG48,BK48))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD48,IF($AP$10=3,#REF!,IF($AP$10=1,BH48,BL48))),\"\")","v":0},null,null,null,null,null,33.200000000000003,null,{"$f":"'JMF1'!I54","v":37},40.799999999999997,null,null,"Percent Used",null,null,null,{"$f":"IF(Stuff!AN94=2,AF51/(P16+U16),AF51/U16)","v":2.1294753608192833E-3},null,null,null,null,null,null,null,{"$f":"IF(X47>96.2,\"100\",X47+3.8)","v":40.799999999999997},null,{"$f":"IF(X47>96.7,\"100\",X47+3.3)","v":40.299999999999997},{"$f":"X47-3.8","v":33.200000000000003},{"$f":"X47-3.3","v":33.700000000000003},null,null,"4.75 mm (No. 4)",null,null,null,null,null,{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J18","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J55","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X18","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X55","v":0},{"$f":"EXTRACTION!D41","v":52.522217249536467},{"$f":"EXTRACTION!I41","v":50.795283148224321},{"$f":"EXTRACTION!N41","v":0},{"$f":"EXTRACTION!S41","v":0},{"$f":"'BURNOUT OVEN '!D20","v":37.567868410833782},{"$f":"'BURNOUT OVEN '!K20","v":37.127387234975927},{"$f":"'BURNOUT OVEN '!R20","v":37.127387234975927},{"$f":"'BURNOUT OVEN '!Y20","v":37.127387234975927}]
[null,null,"600 mm (No. 30)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA49,IF($AP$10=3,#REF!,IF($AP$10=1,BE49,BI49))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB49,IF($AP$10=3,#REF!,IF($AP$10=1,BF49,BJ49))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC49,IF($AP$10=3,#REF!,IF($AP$10=1,BG49,BK49))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD49,IF($AP$10=3,#REF!,IF($AP$10=1,BH49,BL49))),\"\")","v":0},null,null,null,null,null,33.200000000000003,null,{"$f":"'JMF1'!I56","v":37},40.799999999999997,null,null,"Gallons Used",null,null,null,{"$f":"VLOOKUP(AF10,'RECAP SHEET  '!B11:J100,9)","v":12.3},null,null,null,null,null,null,null,{"$f":"IF(X48>96.2,\"100\",X48+3.8)","v":40.799999999999997},null,{"$f":"IF(X48>96.7,\"100\",X48+3.3)","v":40.299999999999997},{"$f":"X48-3.8","v":33.200000000000003},{"$f":"X48-3.3","v":33.700000000000003},null,null,"2.36 mm (No. 8)",null,null,null,null,null,{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J19","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J56","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X19","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X56","v":0},{"$f":"EXTRACTION!D42","v":40.80941116296912},{"$f":"EXTRACTION!I42","v":39.387083504730569},{"$f":"EXTRACTION!N42","v":0},{"$f":"EXTRACTION!S42","v":0},{"$f":"'BURNOUT OVEN '!D21","v":25.805439032046351},{"$f":"'BURNOUT OVEN '!K21","v":25.281969680199126},{"$f":"'BURNOUT OVEN '!R21","v":25.281969680199126},{"$f":"'BURNOUT OVEN '!Y21","v":25.281969680199126}]
[null,null,"300 mm (No. 50)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA50,IF($AP$10=3,#REF!,IF($AP$10=1,BE50,BI50))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB50,IF($AP$10=3,#REF!,IF($AP$10=1,BF50,BJ50))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC50,IF($AP$10=3,#REF!,IF($AP$10=1,BG50,BK50))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD50,IF($AP$10=3,#REF!,IF($AP$10=1,BH50,BL50))),\"\")","v":0},null,null,null,null,null,21.2,null,{"$f":"'JMF1'!I57","v":25},28.8,null,null,"Calculated",null,null,null,{"$f":"IF(Stuff!AN94=2,(U16+P16)*(AF46*2000)/AF50,U16*(AF46*2000)/AF50)","v":0},null,null,null,null,null,null,null,{"$f":"IF(X49>96.2,\"100\",X49+3.8)","v":28.8},null,{"$f":"IF(X49>96.7,\"100\",X49+3.3)","v":28.3},{"$f":"X49-3.8","v":21.2},{"$f":"X49-3.3","v":21.7},null,null,"600 mm (No. 30)",null,null,null,null,null,{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J28","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J65","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X28","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X65","v":0},{"$f":"EXTRACTION!D43","v":29.218080685378183},{"$f":"EXTRACTION!I43","v":28.534210887152071},{"$f":"EXTRACTION!N43","v":0},{"$f":"EXTRACTION!S43","v":0},{"$f":"'BURNOUT OVEN '!D22","v":13.811088628216382},{"$f":"'BURNOUT OVEN '!K22","v":13.202994814012229},{"$f":"'BURNOUT OVEN '!R22","v":13.202994814012229},{"$f":"'BURNOUT OVEN '!Y22","v":13.202994814012229}]
[null,null,"150 mm (No. 100)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA51,IF($AP$10=3,#REF!,IF($AP$10=1,BE51,BI51))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB51,IF($AP$10=3,#REF!,IF($AP$10=1,BF51,BJ51))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC51,IF($AP$10=3,#REF!,IF($AP$10=1,BG51,BK51))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD51,IF($AP$10=3,#REF!,IF($AP$10=1,BH51,BL51))),\"\")","v":0},null,null,null,null,null,23.2,null,{"$f":"'JMF1'!I58","v":25},26.8,null,null,"Wt. / Per Gal. ASA",null,null,null,8.5,null,null,null,null,null,null,null,{"$f":"IF(X50>98.2,\"100\",X50+1.8)","v":26.8},null,{"$f":"IF(X50>98.4,\"100\",X50+1.6)","v":26.6},{"$f":"X50-1.8","v":23.2},{"$f":"X50-1.6","v":23.4},null,null,"300 mm (No. 50)",null,null,null,null,null,{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J29","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J66","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X29","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X66","v":0},{"$f":"EXTRACTION!D44","v":15.727894635892852},{"$f":"EXTRACTION!I44","v":15.069244481009207},{"$f":"EXTRACTION!N44","v":0},{"$f":"EXTRACTION!S44","v":0},{"$f":"'BURNOUT OVEN '!D23","v":9.5911343247251324},{"$f":"'BURNOUT OVEN '!K23","v":8.9532672129199966},{"$f":"'BURNOUT OVEN '!R23","v":8.9532672129199966},{"$f":"'BURNOUT OVEN '!Y23","v":8.9532672129199966}]
[null,null,"75 mm (No. 200)",null,null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BA52,IF($AP$10=3,#REF!,IF($AP$10=1,BE52,BI52))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BB52,IF($AP$10=3,#REF!,IF($AP$10=1,BF52,BJ52))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BC52,IF($AP$10=3,#REF!,IF($AP$10=1,BG52,BK52))),\"\")","v":0},null,null,{"$f":"IFERROR(IF($AP$11=TRUE,BD52,IF($AP$10=3,#REF!,IF($AP$10=1,BH52,BL52))),\"\")","v":0},null,null,null,null,null,8.1999999999999993,null,{"$f":"'JMF1'!I59","v":10},11.8,null,null,"Tons of ASA",null,null,null,{"$f":"(AF48*AF50)/2000","v":5.2275000000000009E-2},null,null,null,null,null,null,null,{"$f":"IF(X51>98.2,\"100\",X51+1.8)","v":11.8},null,{"$f":"IF(X51>98.4,\"100\",X51+1.6)","v":11.6},{"$f":"X51-1.8","v":8.1999999999999993},{"$f":"X51-1.6","v":8.4},null,null,"150 mm (No. 100)",null,null,null,null,null,{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J30","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J67","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X30","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X67","v":0},{"$f":"EXTRACTION!D45","v":7.3652579758327335},{"$f":"EXTRACTION!I45","v":6.6776360894007922},{"$f":"EXTRACTION!N45","v":0},{"$f":"EXTRACTION!S45","v":0},{"$f":"'BURNOUT OVEN '!D24","v":6.1778618474687619},{"$f":"'BURNOUT OVEN '!K24","v":5.5159128689063124},{"$f":"'BURNOUT OVEN '!R24","v":5.5159128689063124},{"$f":"'BURNOUT OVEN '!Y24","v":5.5159128689063124}]
[null,null,null,null,null,"% A.C.",{"$f":"IF($AP$10=3,0,IF($AP$10=1,EXTRACTION!G27,'BURNOUT OVEN '!E45))","v":0},null,null,{"$f":"IF($AP$10=3,0,IF($AP$10=1,EXTRACTION!I27,'BURNOUT OVEN '!L45))","v":0},null,null,{"$f":"IF($AP$10=3,0,IF($AP$10=1,EXTRACTION!Q27,'BURNOUT OVEN '!S45))","v":0},null,null,{"$f":"IF($AP$10=3,0,IF($AP$10=1,EXTRACTION!S27,'BURNOUT OVEN '!Z45))","v":0},null,null,null,null,null,6.7,null,{"$f":"'JMF1'!G25","v":7},7.3,null,null,"Rotational Viscosity",null,null,null,null,1200,null,null,null,null,null,null,{"$f":"(X52+0.3)","v":7.3},null,{"$f":"(X52+0.25)","v":7.25},{"$f":"X52-0.3","v":6.7},{"$f":"X52-0.25","v":6.75},null,null,"75 mm (No. 200)",null,null,null,null,null,{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J31","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!J68","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X31","v":0},{"$f":"'Ag Belt Samp. + RAP Belt Sample'!X68","v":0},{"$f":"EXTRACTION!D46","v":5.6006649191228064},{"$f":"EXTRACTION!I46","v":4.9842314548196924},{"$f":"EXTRACTION!N46","v":0},{"$f":"EXTRACTION!S46","v":0},{"$f":"'BURNOUT OVEN '!D25","v":2.98138511101304},{"$f":"'BURNOUT OVEN '!K25","v":2.2968838377325227},{"$f":"'BURNOUT OVEN '!R25","v":2.2968838377325227},{"$f":"'BURNOUT OVEN '!Y25","v":2.2968838377325227}]
[null,null,"D.A.R.",null,null,null,{"$f":"IF($AP$10=3,0,IF($AP$10=1,EXTRACTION!D49,'BURNOUT OVEN '!B29))","v":0},null,null,{"$f":"IF($AP$10=3,0,IF($AP$10=1,EXTRACTION!I49,'BURNOUT OVEN '!I29))","v":0},null,null,{"$f":"IF($AP$10=3,0,IF($AP$10=1,EXTRACTION!N49,'BURNOUT OVEN '!P29))","v":0},null,null,{"$f":"IF($AP$10=3,0,IF($AP$10=1,EXTRACTION!S49,'BURNOUT OVEN '!W29))","v":0},null,null,null,null,null,null,{"$f":"VLOOKUP(Stuff!C1,Stuff!A2:W16,23)","v":0},null,null,null,null,"LOI Target",null,null,{"$f":"'JMF1'!C35","v":5},null,"Actual LOI",null,null,{"$f":"'LOI '!F41","v":3.795066413662239},null,null,null,null,null,null,null,null,null,null,"%AC"]
[]
[null,null,"Random numbers:  ",null,null,null,{"$f":"ROUND('Random Number'!H14,0)&\" Tons\"","v":"347 Tons"},null,null,{"$f":"ROUND('Random Number'!H15,0)&\" Tons\"","v":"1139 Tons"},null,null,{"$f":"ROUND('Random Number'!H16,0)&\" Tons\"","v":"2000 Tons"},null,null,{"$f":"ROUND('Random Number'!H17,0)&\" Tons\"","v":"3000 Tons"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Stuff!AN94,Stuff!AN95:AO96,2)","v":"Anti-strip based on virgin A.C"}]
[null,null,"Remarks:",null,null,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"`"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signed",null,{"$f":"'JMF1'!C63","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,{"$f":"'JMF1'!G63","v":0}]

{"sheet":"TANK RECORD A.C.","index":14,"n_rows":105,"n_cols":25,"rows_kept":105,"cut":false,"hidden":false,"merged":[[41,1,41,2],[41,6,41,7],[43,1,43,2],[43,6,43,7],[0,2,0,5],[2,1,2,2],[2,6,2,7],[4,1,4,2],[4,6,4,7],[39,2,39,5]]}
[null,null,"TANK RECORD OF A.C. RECEIVED"]
[]
["Type Mix",{"$f":"'JMF1'!E12","v":"OGFC "},null,null,null,"Item No.",{"$f":"'JMF1'!I12","v":0}]
[]
["Contr.No.",{"$f":"'JMF1'!C5","v":0},null,null,null,"Project No.",{"$f":"'JMF1'!C4","v":0}]
[]
[null,"Tank","Gross ","Tare ","Net","Net","Accum. ","Invoice "]
["Date"," No.","Wt.","Wt."," Wt."," Tons"," Tons"," No."]
[null,null,null,null,{"$f":"C9-D9","v":0},{"$f":"E9/2000","v":0},{"$f":"IF(F9=0,0,F9)","v":0}]
[null,null,null,null,{"$f":"C10-D10","v":0},{"$f":"E10/2000","v":0},{"$f":"IF(F10=0,0,G9+F10)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F11=0,0,G10+F11)","v":0}]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,"page 1"]
[null,null,"TANK RECORD OF A.C. RECEIVED"]
[]
["Type Mix",{"$f":"B3","v":"OGFC "},null,null,null,"Item No.",{"$f":"G3","v":0}]
[]
["Contr.No.",{"$f":"B5","v":0},null,null,null,"Project No.",{"$f":"G5","v":0}]
[]
[null,"Tank","Gross ","Tare ","Net","Net","Accum. ","Invoice "]
["Date"," No.","Wt.","Wt."," Wt."," Tons"," Tons"," No."]
[null,null,null,null,{"$f":"C48-D48","v":0},{"$f":"E48/2000","v":0},{"$f":"IF(F48=0,0,F48+G38)","v":0}]
[null,null,null,null,{"$f":"C49-D49","v":0},{"$f":"E49/2000","v":0},{"$f":"IF(F49=0,0,G48+F49)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(F50=0,0,G49+F50)","v":0}]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,"page 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]

{"sheet":"RECAP SHEET  ","index":15,"n_rows":102,"n_cols":15,"rows_kept":102,"cut":false,"hidden":false,"merged":[[107,13,109,13],[107,14,109,14],[126,0,126,2],[107,5,109,5],[107,6,109,6],[107,7,109,7],[107,8,109,8],[107,9,109,9],[107,10,109,10],[104,0,104,1],[105,0,105,1],[106,0,106,1],[106,8,106,9],[106,10,106,12],[107,0,109,0],[107,1,109,1],[107,2,109,2],[107,3,109,3],[107,4,109,4],[107,11,109,11],[107,12,109,12],[101,0,101,2],[102,2,102,4],[102,6,102,7],[102,8,102,9],[103,2,103,4],[103,6,103,7],[103,8,103,9],[82,9,84,9],[82,10,84,10],[82,11,84,11],[82,12,84,12],[82,13,84,13],[82,14,84,14],[81,10,81,12],[82,0,84,0],[82,1,84,1],[82,2,84,2],[82,3,84,3],[82,4,84,4],[82,5,84,5],[82,6,84,6],[82,7,84,7],[82,8,84,8],[78,2,78,4],[78,6,78,7],[78,8,78,9],[79,0,79,1],[80,0,80,1],[81,0,81,1],[81,8,81,9],[57,11,59,11],[57,12,59,12],[81,5,81,7],[57,13,59,13],[57,14,59,14],[76,0,76,2],[77,2,77,4],[77,6,77,7],[77,8,77,9],[57,5,59,5],[57,6,59,6],[57,7,59,7],[57,8,59,8],[57,9,59,9],[57,10,59,10],[54,0,54,1],[55,0,55,1],[56,0,56,1],[56,8,56,9],[56,10,56,12],[57,0,59,0],[57,1,59,1],[57,2,59,2],[57,3,59,3],[57,4,59,4],[56,5,56,7],[51,0,51,2],[52,2,52,4],[52,6,52,7],[52,8,52,9],[53,2,53,4],[53,6,53,7],[53,8,53,9],[32,9,34,9],[32,10,34,10],[32,11,34,11],[32,12,34,12],[32,13,34,13],[32,14,34,14],[31,10,31,12],[32,0,34,0],[32,1,34,1],[32,2,34,2],[32,3,34,3],[32,4,34,4],[32,5,34,5],[32,6,34,6],[32,7,34,7],[32,8,34,8],[28,2,28,4],[28,6,28,7],[28,8,28,9],[29,0,29,1],[30,0,30,1],[31,0,31,1],[31,8,31,9],[7,11,9,11],[7,12,9,12],[27,2,27,4],[27,6,27,7],[27,8,27,9],[7,5,9,5],[7,6,9,6],[7,7,9,7],[7,8,9,8],[7,9,9,9],[7,10,9,10],[31,5,31,7],[6,10,6,12],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,13,9,13],[7,14,9,14],[26,0,26,2],[2,2,2,4],[2,6,2,7],[2,8,2,9],[3,6,3,7],[3,8,3,9],[4,0,4,1],[5,0,5,1],[6,0,6,1],[6,5,6,7],[6,8,6,9],[3,2,3,4]]}
[]
[]
["        Item No.",null,{"$f":"'JMF1'!I12","v":0},null,null,null,"Contr. No.",null,{"$f":"'JMF1'!C5","v":0}]
["       Type Mix",null,{"$f":"'JMF1'!E12","v":"OGFC "},null,null,null,"Project No.",null,{"$f":"'JMF1'!C4","v":0}]
["% A.C. in mix",null,{"$f":"'JMF1'!G25","v":7},null,null,null,null,null,null,null,null,"page 1"]
["% Virgin A.C.",null,{"$f":"'JMF1'!D28","v":7}]
["% Rap A.C.",null,{"$f":"'JMF1'!F28","v":0},null,"Design No.",{"$f":"'JMF1'!H14","v":0},null,null,"T.D.O.T. Insp.:",null,{"$f":"'JMF1'!C63","v":0}]
["Ticket Book No.","Date","Rept. No.","Tons of Virgin Aggregate","Accum. Tons of Mineral Aggreate","Total Tons of A.C.","Accumulated Tons of A.C.","Total Tons of Mix","Accumulated Tons of Mix","Total Gallons of Anti-Strip","Accumlated Gallons of Anti-Strip","Virgin A.C.","Accumlated Virgin A.C.","Total R.A.P.                A.C.","Total R.A.P Aggregate"]
[]
[]
[1,"2017-02-24",1,{"$f":"H11-F11-O11","v":326.14170000000001},{"$f":"D11+O11","v":326.14170000000001},{"$f":"H11*$C$5/100","v":24.548299999999998},{"$f":"F11","v":24.548299999999998},350.69,{"$f":"H11","v":350.69},12.3,{"$f":"J11","v":12.3},{"$f":"H11*$C$6/100","v":24.548299999999998},{"$f":"L11","v":24.548299999999998},{"$f":"($C$7*H11)/100","v":0},{"$f":"H11*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N11","v":0}]
[null,null,null,{"$f":"H12-F12-O12","v":0},{"$f":"IF(D12=0,0,D12+E11+O12)","v":0},{"$f":"H12*$C$5/100","v":0},{"$f":"IF(F12=0,0,F12+G11)","v":0},null,{"$f":"IF(H12=0,0,H12+I11)","v":0},null,{"$f":"IF(J12=0,0,J12+K11)","v":0},{"$f":"H12*$C$6/100","v":0},{"$f":"IF(L12=0,0,L12+M11)","v":0},{"$f":"($C$7*H12)/100","v":0},{"$f":"H12*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N12","v":0}]
[null,null,null,0,{"$f":"IF(D13=0,0,D13+E12+O13)","v":0},0,0,null,0,null,0,0,0,0,{"$f":"H13*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N13","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H14*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N14","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H15*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N15","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H16*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N16","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H17*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N17","v":0}]
[null,null,null,93,93,7,7,100,100,null,0,7,7,0,{"$f":"H18*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N18","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H19*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N19","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H20*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N20","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H21*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N21","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H22*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N22","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H23*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N23","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H24*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N24","v":0}]
[null,null,null,0,0,0,0,null,0,1,1,0,0,0,{"$f":"H25*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N25","v":0}]
[]
["Totals from page 1",null,null,null,{"$f":"SUM(D11:D25)","v":419.14170000000001},null,{"$f":"SUM(F11:F25)","v":31.548299999999998},null,{"$f":"SUM(H11:H25)","v":450.69},null,{"$f":"SUM(J11:J25)","v":13.3},null,{"$f":"SUM(L11:L25)","v":31.548299999999998}]
["        Item No.",null,{"$f":"C3","v":0},null,null,null,"Contr. No.",null,{"$f":"I3","v":0}]
["       Type Mix",null,{"$f":"C4","v":"OGFC "},null,null,null,"Project No.",null,{"$f":"I4","v":0}]
["% A.C. in mix",null,{"$f":"C5","v":7},null,null,null,null,null,null,null,null,"page 2"]
["% Virgin A.C.",null,{"$f":"C6","v":7}]
["% Rap A.C.",null,{"$f":"C7","v":0},null,"Design No.",{"$f":"F7","v":0},null,null,"T.D.O.T. Insp.:",null,{"$f":"K7","v":0}]
["Ticket Book No.","Date","Rept. No.","Tons of Virgin Aggregate","Accum. Tons of Mineral Aggreate","Total Tons of A.C.","Accumulated Tons of A.C.","Total Tons of Mix","Accumulated Tons of Mix","Total Gallons of Anti-Strip","Accumlated Gallons of Anti-Strip","Virgin A.C.","Accumlated Virgin A.C.","R.A.P.       A.C.","R.A.P Aggregate"]
[]
[]
[null,null,null,{"$f":"H36-F36-O36","v":0},{"$f":"IF(D36=0,0,D36+E35+O36)","v":0},{"$f":"H36*$C$5/100","v":0},{"$f":"F36","v":0},null,{"$f":"H36","v":0},null,{"$f":"J36","v":0},{"$f":"H36*$C$6/100","v":0},{"$f":"L36","v":0},{"$f":"($C$7*H36)/100","v":0},{"$f":"H36*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N36","v":0}]
[null,null,null,{"$f":"H37-F37-O37","v":0},0,{"$f":"H37*$C$5/100","v":0},{"$f":"IF(F37=0,0,F37+G36)","v":0},null,{"$f":"IF(H37=0,0,H37+I36)","v":0},null,{"$f":"IF(J37=0,0,J37+K36)","v":0},{"$f":"H37*$C$6/100","v":0},{"$f":"IF(L37=0,0,L37+M36)","v":0},{"$f":"($C$7*H37)/100","v":0},{"$f":"H37*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N37","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H38*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N38","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H39*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N39","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H40*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N40","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H41*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N41","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H42*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N42","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H43*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N43","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H44*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N44","v":0}]
[null,null,null,465,465,35,35,500,500,null,0,35,35,0,{"$f":"H45*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N45","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H46*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N46","v":0}]
[null,null,null,0,0,0,0,null,0,1,1,0,0,0,{"$f":"H47*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N47","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H48*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N48","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H49*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N49","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H50*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N50","v":0}]
[]
["Totals from page 1, 2",null,null,null,{"$f":"SUM(D36:D50)+E27","v":884.14170000000001},null,{"$f":"SUM(F36:F50)+G27","v":66.548299999999998},null,{"$f":"SUM(H36:H50)+I27","v":950.69},null,{"$f":"SUM(J36:J50)+K27","v":14.3},null,{"$f":"SUM(L36:L50)+M27","v":66.548299999999998}]
["        Item No.",null,{"$f":"C28","v":0},null,null,null,"Contr. No.",null,{"$f":"I28","v":0}]
["       Type Mix",null,{"$f":"C29","v":"OGFC "},null,null,null,"Project No.",null,{"$f":"I29","v":0}]
["% A.C. in mix",null,{"$f":"C30","v":7},null,null,null,null,null,null,null,null,"page 3"]
["% Virgin A.C.",null,{"$f":"C31","v":7}]
["% Rap A.C.",null,{"$f":"C32","v":0},null,"Design No.",{"$f":"F32","v":0},null,null,"T.D.O.T. Insp.:",null,{"$f":"K32","v":0}]
["Ticket Book No.","Date","Rept. No.","Tons of Virgin Aggregate","Accum. Tons of Mineral Aggreate","Total Tons of A.C.","Accumulated Tons of A.C.","Total Tons of Mix","Accumulated Tons of Mix","Total Gallons of Anti-Strip","Accumlated Gallons of Anti-Strip","Virgin A.C.","Accumlated Virgin A.C.","R.A.P.       A.C.","R.A.P Aggregate"]
[]
[]
[null,null,null,{"$f":"H61-F61-O61","v":0},{"$f":"IF(D61=0,0,D61+E60+O61)","v":0},{"$f":"H61*$C$5/100","v":0},{"$f":"F61","v":0},null,{"$f":"H61","v":0},null,{"$f":"J61","v":0},{"$f":"H61*$C$6/100","v":0},{"$f":"L61","v":0},{"$f":"($C$7*H61)/100","v":0},{"$f":"H61*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N61","v":0}]
[null,null,null,{"$f":"H62-F62-O62","v":0},0,{"$f":"H62*$C$5/100","v":0},{"$f":"IF(F62=0,0,F62+G61)","v":0},null,{"$f":"IF(H62=0,0,H62+I61)","v":0},null,{"$f":"IF(J62=0,0,J62+K61)","v":0},{"$f":"H62*$C$6/100","v":0},{"$f":"IF(L62=0,0,L62+M61)","v":0},{"$f":"($C$7*H62)/100","v":0},{"$f":"H62*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N62","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H63*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N63","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H64*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N64","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H65*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N65","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H66*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N66","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H67*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N67","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H68*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N68","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H69*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N69","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H70*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N70","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H71*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N71","v":0}]
[null,null,null,465,465,35,35,500,500,null,0,35,35,0,{"$f":"H72*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N72","v":0}]
[null,null,null,0,0,0,0,null,0,2,2,0,0,0,{"$f":"H73*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N73","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H74*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N74","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H75*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N75","v":0}]
[]
["Totals from page 1, 2, 3",null,null,null,{"$f":"SUM(D61:D75)+E52","v":1349.1417000000001},null,{"$f":"SUM(F61:F75)+G52","v":101.5483},null,{"$f":"SUM(H61:H75)+I52","v":1450.69},null,{"$f":"SUM(J61:J75)+K52","v":16.3},null,{"$f":"SUM(L61:L75)+M52","v":101.5483}]
["        Item No.",null,{"$f":"C53","v":0},null,null,null,"Contr. No.",null,{"$f":"I53","v":0}]
["       Type Mix",null,{"$f":"C54","v":"OGFC "},null,null,null,"Project No.",null,{"$f":"I54","v":0}]
["% A.C. in mix",null,{"$f":"C55","v":7},null,null,null,null,null,null,null,null,"page 4"]
["% Virgin A.C.",null,{"$f":"C56","v":7}]
["% Rap A.C.",null,{"$f":"C57","v":0},null,"Design No.",{"$f":"F57","v":0},null,null,"T.D.O.T. Insp.:",null,{"$f":"K57","v":0}]
["Ticket Book No.","Date","Rept. No.","Tons of Virgin Aggregate","Accum. Tons of Mineral Aggreate","Total Tons of A.C.","Accumulated Tons of A.C.","Total Tons of Mix","Accumulated Tons of Mix","Total Gallons of Anti-Strip","Accumlated Gallons of Anti-Strip","Virgin A.C.","Accumlated Virgin A.C.","R.A.P.       A.C.","R.A.P Aggregate"]
[]
[]
[null,null,null,{"$f":"H86-F86-O86","v":0},{"$f":"IF(D86=0,0,D86+E85+O86)","v":0},{"$f":"H86*$C$5/100","v":0},{"$f":"F86","v":0},null,{"$f":"H86","v":0},null,{"$f":"J86","v":0},{"$f":"H86*$C$6/100","v":0},{"$f":"L86","v":0},{"$f":"($C$7*H86)/100","v":0},{"$f":"H86*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N86","v":0}]
[null,null,null,{"$f":"H87-F87-O87","v":0},0,{"$f":"H87*$C$5/100","v":0},{"$f":"IF(F87=0,0,F87+G86)","v":0},null,{"$f":"IF(H87=0,0,H87+I86)","v":0},null,{"$f":"IF(J87=0,0,J87+K86)","v":0},{"$f":"H87*$C$6/100","v":0},{"$f":"IF(L87=0,0,L87+M86)","v":0},{"$f":"($C$7*H87)/100","v":0},{"$f":"H87*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N87","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H88*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N88","v":0}]
[null,null,null,930,930,70,70,1000,1000,1,1,70,70,0,{"$f":"H89*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N89","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H90*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N90","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H91*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N91","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H92*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N92","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H93*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N93","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H94*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N94","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H95*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N95","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H96*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N96","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H97*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N97","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H98*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N98","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H99*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N99","v":0}]
[null,null,null,0,0,0,0,null,0,null,0,0,0,0,{"$f":"H100*('JMF1'!$I$22+'JMF1'!$I$23)/100-'RECAP SHEET  '!N100","v":0}]
[]
["Totals from page 1, 2, 3, 4",null,null,null,{"$f":"SUM(D86:D100)+E77","v":2279.1417000000001},null,{"$f":"SUM(F86:F100)+G77","v":171.54829999999998},null,{"$f":"SUM(H86:H100)+I77","v":2450.69},null,{"$f":"SUM(J86:J100)+K77","v":17.3},null,{"$f":"SUM(L86:L100)+M77","v":171.54829999999998}]

{"sheet":"Mix Control Chart","index":16,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[25,0,30,0],[28,1,28,2],[29,1,29,2],[30,1,30,2],[13,0,18,0],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,0,24,0],[22,1,22,2],[23,1,23,2],[24,1,24,2],[7,0,12,0],[10,1,10,2],[11,1,11,2],[12,1,12,2],[0,1,0,12],[1,0,6,0],[4,1,4,2],[5,1,5,2],[6,1,6,2]]}
["SCREEN","MIX CONTROL CHARTS"]
["3/4\" or 3/8\"","Upper Limit",{"$f":"C3+5.7","v":71.7},{"$f":"C2","v":71.7},{"$f":"D2","v":71.7},71.7,71.7,71.7,71.7,71.7,71.7,71.7,71.7]
[null,"JMF",66,{"$f":"C3","v":66},66,66,66,66,66,66,66,66,66]
[null,"Lower Limit",{"$f":"C3-5.7","v":60.3},{"$f":"C4","v":60.3},60.3,60.3,60.3,60.3,60.3,60.3,60.3,60.3,60.3]
[null,"DATE"]
[null,"Contractor (QC)",null,66,69,65]
[null,"State (QA)",null,60,62,61]
["#4","Upper Limit",{"$f":"C9+4","v":44},{"$f":"C8","v":44},{"$f":"D8","v":44},44,44,44,44,44,44,44,44]
[null,"JMF",40,{"$f":"C9","v":40},40,40,40,40,40,40,40,40,40]
[null,"Lower Limit",{"$f":"C9-4","v":36},{"$f":"C10","v":36},36,36,36,36,36,36,36,36,36]
[null,"DATE"]
[null,"Contractor (QC)",null,48,42,46,43]
[null,"State (QA)",null,41,43,44,46]
["#30","Upper Limit",{"$f":"C15+3.3","v":31.3},{"$f":"C14","v":31.3},{"$f":"D14","v":31.3},31.3,31.3,31.3,31.3,31.3,31.3,31.3,31.3]
[null,"JMF",28,{"$f":"C15","v":28},28,28,28,28,28,28,28,28,28]
[null,"Lower Limit",{"$f":"C15-3.3","v":24.7},{"$f":"C16","v":24.7},24.7,24.7,24.7,24.7,24.7,24.7,24.7,24.7,24.7]
[null,"DATE",null,"2008-10-01"]
[null,"Contractor (QC)",null,30,32,32,34]
[null,"State (QA)",null,30,29,30,31]
["#200","Upper Limit",{"$f":"C21+1.6","v":6.6},{"$f":"C20","v":6.6},{"$f":"D20","v":6.6},6.6,6.6,6.6,6.6,6.6,6.6,6.6,6.6]
[null,"JMF",5,{"$f":"C21","v":5},5,5,5,5,5,5,5,5,5]
[null,"Lower Limit",{"$f":"C21-1.6","v":3.4},{"$f":"C22","v":3.4},3.4,3.4,3.4,3.4,3.4,3.4,3.4,3.4,3.4]
[null,"DATE"]
[null,"Contractor (QC)",null,4.5,3.1,5.3]
[null,"State (QA)",null,3.5,4,6.5]
["AC%","Upper Limit",{"$f":"C27+0.35","v":5.6499999999999995},{"$f":"C26","v":5.6499999999999995},{"$f":"D26","v":5.6499999999999995},5.6499999999999995,5.6499999999999995,5.6499999999999995,5.6499999999999995,5.6499999999999995,5.6499999999999995,5.6499999999999995,5.6499999999999995]
[null,"JMF",5.3,{"$f":"C27","v":5.3},5.3,5.3,5.3,5.3,5.3,5.3,5.3,5.3,5.3]
[null,"Lower Limit",{"$f":"C27-0.35","v":4.95},{"$f":"C28","v":4.95},4.95,4.95,4.95,4.95,4.95,4.95,4.95,4.95,4.95]
[null,"DATE"]
[null,"Contractor (QC)",null,5,4.8,4.5999999999999996,4.9000000000000004,5]
[null,"State (QA)",null,null,4.5999999999999996,4.7,4.8,4.5]

{"sheet":"HMA Producers","index":17,"n_rows":145,"n_cols":7,"rows_kept":145,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
["PRODUCERS",null,null,null,{"$f":"VLOOKUP(G1,A2:F141,6)","v":0},null,2]
[1]
[2]
[3,1,1,null,null,"ASR Systems Tri-Cities, Bristol",18200022]
[4,1,1,null,null,"ATS Consturction - Williamsburg KY",59900109]
[5,1,1,null,null,"B & F Hot Mix - Asphalt Mix",11300001]
[6,1,1,null,null,"Blalock Asphalt - Kodak Asphalt Mix",17800001]
[7,1,1,null,null,"Blalock Asphalt - Sevierville Asphalt Mix",17800002]
[8,1,1,null,null,"CAPS Asphalt",18600003]
[9,1,1,null,null,"Duracap Asphalt Paving - Bean Station Asphalt Mix",12900004]
[10,1,1,null,null,"Duracap Asphalt Paving - Heiskell Asphalt Mix",14700015]
[11,1,1,null,null,"Duracap Asphalt Paving - Knoxville Asphalt Mix",14700014]
[12,1,1,null,null,"Elmo Greer & Sons - Williamsburg KY Asp Mix",59900109]
[13,1,1,null,null,"Greenback Asphalt /Patty Construction- Asphalt Mix",15300003]
[14,1,1,null,null,"Greene County Highway Dept - Asphalt Mix",13000008]
[15,1,1,null,null,"Harrison Construction - Heiskell Asphalt Mix",14700007]
[16,1,1,null,null,"Harrison Construction - Jefferson City Asphalt Mix",14500003]
[17,1,1,null,null,"Harrison Construction - Knox Cinder Asphalt Mix",14700008]
[18,1,1,null,null,"Harrison Construction - Knox Everett Asphalt Mix",14700010]
[19,1,1,null,null,"Harrison Construction - Maryville Asphalt Mix",10500001]
[20,1,1,null,null,"Harrison Construction - Mascot Asphalt Mix",14700011]
[21,1,1,null,null,"Harrison Construction - Maynardville Asphalt Mix",18700001]
[22,1,1,null,null,"Harrison Construction - Morristown Asphalt Mix",13200001]
[23,1,1,null,null,"Harrison Construction - Rogersville Asphalt Mix",13700010]
[24,1,1,null,null,"Harrison Construction - Spring Hill Asphalt Mix",14700042]
[25,1,1,null,null,"Hinkle Contracting - Middlesboro KY Asphalt Mix",59900010]
[26,1,1,null,null,"Jefferson Co Hwy Dept - Jefferson City Asphalt Mix",14500007]
[27,1,1,null,null,"Maymead - Mountain City Asphalt Mix",14600003]
[28,1,1,null,null,"Miller & Sons Paving - Oneida Asphalt Mix",17600001]
[29,1,1,null,null,"Newport Paving - Newport Asphalt Mix",11500001]
[30,1,1,null,null,"Potters Southeast - Pioneer",10700007]
[31,1,1,null,null,"Rogers Group - Harriman Quarry Rd Asphalt Mix",17300005]
[32,1,1,null,null,"Rogers Group - Jacksboro Towe String Rd Asp Mix",10700006]
[33,1,1,null,null,"Rogers Group - Knoxville Candora Ave Asphalt Mix",14700031]
[34,1,1,null,null,"Rogers Group - Madisonville Asphalt Mix",16200006]
[35,1,1,null,null,"Rogers Group - Oak Ridge Asphalt Mix",10100005]
[36,1,1,null,null,"Rogers Group - Sweetwater Asphalt Mix",16200001]
[37,1,1,null,null,"Rogers Group - Tazewell Asphalt Mix",11300004]
[38,1,1,null,null,"Summers Taylor - Blountville Drum Plant Asp Mix",18200010]
[39,1,1,null,null,"Summers Taylor - Greeneville Asphalt Mix",13000002]
[40,1,1,null,null,"Summers Taylor - Watauga Asphalt Mix",11000002]
[41,2,1,null,null,"W & L Construction - Abington VA Asphalt Mix",59900110]
[42,2,1,null,null,"W & L Construction - Kingsport Asphalt Mix",18200017]
[43,2,1,null,null,"Washington County Highway Dept",19000010]
[44,2,1,null,null,"Willis Paving Inc - Tazewell Asphalt Mix",11300006]
[45,2,1,null,null,"Central Asphalt - Cleveland Asphalt Mix",20600002]
[46,2,1,null,null,"Copeland DRP LLC - Cookeville Asphalt Mix",27100016]
[47,2,1,null,null,"Dunlap Stone - Dunlap Asphalt Mix",27700004]
[48,2,1,null,null,"Dunlap Stone - Pikeville Asphalt Mix",20400003]
[49,2,1,null,null,"Harrison Construction - Hayesville NC Asphalt Mix",59900168]
[50,2,1,null,null,"Hiwassee Paving - Chattanooga Asphalt Mix",23300003]
[51,2,1,null,null,"Hiwassee Paving LLC  - Calhoun Asphalt Mix",25400007]
[52,2,1,null,null,"Rogers Group - Allgood Asphalt Mix",27100005]
[53,2,1,null,null,"Rogers Group - Cookeville Asphalt Mix LAB ONLY",27100006]
[54,2,1,null,null,"Rogers Group - Cowan Asphalt Mix",22600004]
[55,2,1,null,null,"Rogers Group - Crab Orchard Asphalt Mix",21800007]
[56,2,1,null,null,"Rogers Group - Dayton Asphalt Mix",27200002]
[57,2,1,null,null,"Rogers Group - Hillsboro Asphalt Mix",21600004]
[58,2,1,null,null,"Rogers Group - Livingston Asphalt Mix",26700001]
[59,2,1,null,null,"Rogers Group - McMinnville Asphalt Mix",28900007]
[60,2,1,null,null,"Rogers Group - Pall Mall Asphalt Mix",22500003]
[61,2,1,null,null,"Rogers Group - Sparta Asphalt Mix",29300001]
[62,2,1,null,null,"Southeastern Mtls - Chattanooga Asphalt Mix",23300001]
[63,2,1,null,null,"Southeastern Mtls - Cleveland Asphalt Mix",20600006]
[64,null,null,null,null,"Southeastern Mtls - Tiftonia Asphalt Mix",23300012]
[65,null,null,null,null,"Tinsley Asphalt - Decherd Asphalt Mix",22600008]
[66,null,null,null,null,"Tinsley Asphalt - McMinnville Asphalt Mix",28900005]
[67,3,1,null,null,"Tinsley Asphalt - South Pittsburg Asphalt Mix",25800004]
[68,3,1,null,null,"Vulcan - Cookeville Asphalt Mix",27100008]
[69,3,1,null,null,"Charles Deweese Const - Franklin Aphalt Mix",59900204]
[70,3,1,null,null,"Eubank Asphalt - Clarksville Asphalt Mix",36300013]
[71,3,1,null,null,"Eubank Asphalt - Dickson Plants 1-3 Asphalt Mix",32200002]
[72,3,1,null,null,"Fairview Asphalt Products Inc - Asphalt Mix",39400001]
[73,3,1,null,null,"Hawkins Asphalt Paving - Shelbyville Asphalt Mix",30200008]
[74,3,1,null,null,"Hoover - Murfreesboro Asphalt Mix",37500003]
[75,3,1,null,null,"Hoover - Old Hickory Asphalt Mix",31900061]
[76,3,1,null,null,"Hoover - Plant A Lebanon Asphalt Mix",39500016]
[77,3,1,null,null,"Hoover - Plant B Lebanon Asphalt Mix",39500001]
[78,3,1,null,null,"Hoover - Smyrna Asphalt Mix",37500004]
[79,3,1,null,null,"Jones Bros Contractors - Clarksville Asphalt Mix",36300004]
[80,3,1,null,null,"Jones Bros Contractors - Nashville Asphalt Mix",31900009]
[81,3,1,null,null,"Lincoln Paving Co - Fayetteville",35200003]
[82,3,1,null,null,"Lincoln Paving Co - Lewisburg",35900003]
[83,3,1,null,null,"Lincoln Paving Co - Lynchburg",36400001]
[84,3,1,null,null,"Marathon Ashland - Nashville Liquid Asphalt",31900025]
[85,3,1,null,null,"Maury Co Asphalt - Columbia",36000008]
[86,3,1,null,null,"McIntosh Asphalt Co",36300009]
[87,3,1,null,null,"Rogers Group - Columbia Asphalt Mix",36000009]
[88,3,1,null,null,"Rogers Group - Cross Plains Rockhouse Rd Asphalt",37400010]
[89,3,1,null,null,"Rogers Group - Gallatin Asphalt Mix",38300012]
[90,3,1,null,null,"Rogers Group - Hopkinsville Kentucky Asphalt",59900046]
[91,3,1,null,null,"Rogers Group - Lawrenceburg Asphalt Mix",35000003]
[92,3,1,null,null,"Rogers Group - Nashville Asphalt Mix",31900036]
[93,3,1,null,null,"Rogers Group - Pottsville Asphalt Mix",35900007]
[94,3,1,null,null,"Rogers Group - Pulaski Bethel Rd Asphalt Mix",32800008]
[95,3,1,null,null,"Scotty's Asphalt Co",59900047]
[96,3,1,null,null,"Tennessee Calley Asphalt - Fairview",39400001]
[97,3,1,null,null,"Volunteer Materials - Lewisburg Asp Mix",35900008]
[98,3,1,null,null,"Vulcan - City Plant",31900023]
[99,3,1,null,null,"Vulcan - Columbia",36000006]
[100,3,1,null,null,"Vulcan - Danley",31900021]
[101,3,1,null,null,"Vulcan - Franklin",39400002]
[102,3,2,null,null,"Vulcan - Gordonsville",38000002]
[103,3,1,null,null,"Vulcan - Hermitage",31900022]
[104,3,1,null,null,"Vulcan - Lebanon  Asphalt",39500006]
[105,3,1,null,null,"Vulcan - Murfreesboro",37500007]
[106,null,null,null,null,"Vulcan - Nashville River Rd",31900024]
[107,null,null,null,null,"Vulcan - Springfield",37400005]
[108,4,1,null,null,"Wright Paving Co - Pottsville",35900005]
[109,4,1,null,null,"Wright Paving Co - Shelbyville",30200006]
[110,4,1,null,null,"APAC - Glen Mississippi Asphalt Mix",59900054]
[111,4,1,null,null,"APAC - Memphis Harbour Ave Asphalt Mix",47900004]
[112,4,1,null,null,"APAC - Memphis Tuggle Rd Asphalt Mix",47900005]
[113,4,1,null,null,"Arrow Paving Inc - Lexington Asphalt Mix",43900001]
[114,4,1,null,null,"Delta Contracting - Holladay Asphalt Mix",40300002]
[115,4,1,null,null,"Delta Contracting - Humboldt Asphalt Mix",42700001]
[116,4,1,null,null,"Delta Contracting - Jackson Asphalt Mix",45700017]
[117,4,1,null,null,"Delta Contracting - Parsons Asphalt Mix",42000001]
[118,4,1,null,null,"Delta Contracting - Savannah Asphalt Mix",43600002]
[119,4,1,null,null,"Delta Contracting- Paris Asphalt Mix",44000004]
[120,4,1,null,null,"Ford Construction - Dresden Asphalt Mix",49200002]
[121,4,1,null,null,"Ford Construction - Dyersburg Asphalt Mix",42300004]
[122,4,1,null,null,"Ford Construction - Jackson Asphalt Mix",45700006]
[123,4,1,null,null,"Ford Construction - Troy Asphalt Mix",46600004]
[124,4,1,null,null,"Frank Climer and Sons - Munford Asphalt Mix",48400003]
[125,4,1,null,null,"J Hamm Asphalt - Crump Asphalt Mix",43600009]
[126,4,1,null,null,"Lehman Roberts - Arlington Asphalt Mix",47900012]
[127,4,1,null,null,"Lehman Roberts - Memphis Carrier Asphalt Mix",47900014]
[128,4,1,null,null,"Martin Paving - Medina Asphalt Mix",42700002]
[129,4,1,null,null,"Standard Construction - Collierville Asphalt Mix",47900052]
[130,4,1,null,null,"Standard Construction - Cordova Asphalt Mix",47900042]
[131,4,1,null,null,"Standard Construction - Stantonville Asphalt Mix",45500005]
[132,4,1,null,null,"Standard Construction - Whiteville Asphalt Mix",43500002]
[133,4,1]
[134,4,1]
[135,4,1]
[136,4,1]
[137,4,1]
[138,4,1]
[139,4,1]
[140,4,1]
[141,4,1]
[142,4,1]
[143]
[144]

{"sheet":"Terminals","index":18,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["TERMINALS",null,null,{"$f":"VLOOKUP(F1,A3:F24,6)","v":0},null,1]
[]
[1]
[2,1,3,"BRISTOL ASPHALT PRODUCTS","BRISTOL",{"$f":"D4&\", \"&E4","v":"BRISTOL ASPHALT PRODUCTS, BRISTOL"}]
[3,1,3,"MARATHON ASHLAND","KNOXVILLE",{"$f":"D5&\", \"&E5","v":"MARATHON ASHLAND, KNOXVILLE"}]
[4,1,3,"ConocoPhillips(Vol) ASPHALT","KNOXVILLE",{"$f":"D6&\", \"&E6","v":"ConocoPhillips(Vol) ASPHALT, KNOXVILLE"}]
[5,1,3,"VULCAN MATERIALS","KNOXVILLE",{"$f":"D7&\", \"&E7","v":"VULCAN MATERIALS, KNOXVILLE"}]
[6]
[7,2,3,"MARATHON PETROLEUM","CHATTANOOGA TERMINAL",{"$f":"D9&\", \"&E9","v":"MARATHON PETROLEUM, CHATTANOOGA TERMINAL"}]
[8,2,3,"Conoco/Phillips","CHATTANOOGA TERMINAL",{"$f":"D10&\", \"&E10","v":"Conoco/Phillips, CHATTANOOGA TERMINAL"}]
[9,2,3,"HUDSON MATERIALS","CHATTANOOGA TERMINAL",{"$f":"D11&\", \"&E11","v":"HUDSON MATERIALS, CHATTANOOGA TERMINAL"}]
[10]
[11,3,3,"ERGON ASPHALT CO.","NASHVILLE TERMINAL",{"$f":"D13&\", \"&E13","v":"ERGON ASPHALT CO., NASHVILLE TERMINAL"}]
[12,3,3,"MARATHON ASHLAND PETROLEUM, LLC","NASHVILLE TERMINAL",{"$f":"D14&\", \"&E14","v":"MARATHON ASHLAND PETROLEUM, LLC, NASHVILLE TERMINAL"}]
[13,3,3,"HUNT REFINING","DECATUR, AL",{"$f":"D15&\", \"&E15","v":"HUNT REFINING, DECATUR, AL"}]
[14]
[15,4,3,"ERGON ASPHALT & EMULSIONS","MEMPHIS, TN",{"$f":"D17&\", \"&E17","v":"ERGON ASPHALT & EMULSIONS, MEMPHIS, TN"}]
[16,4,3,"ERGON INC","TISHOMINGO, MS","ERGON INC, TISHOMINGO, MS"]
[17,4,3,"SEM MATERIALS","PARSONS, TN","SEM MATERIALS, PARSONS, TN"]
[18,4,3,"SEM MATERIALS","MEMPHIS, TN","SEM MATERIALS, MEMPHIS, TN"]
[19,4,3,"MARATHON ASHLAND PETRO LLC(EMUL)","MEMPHIS, TN","MARATHON ASHLAND PETRO LLC(EMUL), MEMPHIS, TN"]
[20,4,3,"MARATHON ASHLAND PETRO LLC(AC)","CATAWA","MARATHON ASHLAND PETRO LLC(AC), CATAWA"]
[21,4,3,"MARATHON ASHLAND PETRO LLC(AC)","MEMPHIS, TN","MARATHON ASHLAND PETRO LLC(AC), MEMPHIS, TN"]
[22]

{"sheet":"Tack Coat","index":19,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[26,0,26,7],[27,0,27,7],[0,0,0,7],[14,0,14,7],[39,1,39,4],[10,0,10,7],[2,0,5,7],[11,0,11,7]]}
["Tack Coat Field Verification"]
[]
["If Emulsified Asphalt Tack Coat is more than one week old (as measured from the date the material left the terminal) and has been stored in a tanker or distributor, conduct a sieve and residue by evaporation test at the asphalt mix plant.  Failing results are grounds to reject any remaining material in the distributor or tanker."]
[]
[]
[]
[]
["Tack Coat Emulsion Classification"]
[]
[]
["SIEVE TEST"]
["See AASHTO T-59 part 13 for details"]
["1. Record weightof number 20 sieve and Pan (Dry)"]
["2. Remove Pan, and pour 1000 g of emulsion through 20 sieve"]
["3. Wash sieve with distilled water (or sodium oleate solution as noted in T-59) until water leaving sieve is clear"]
["4. Replace pan under sieve and place sieve/pan assembly in 325 F oven for 2 hours"]
["5. Determine weightof sieve, pan and residue"]
[]
[]
["Wt of Sieve+Pan Dry",null,"grams"]
["Sample ",null,"grams"," (1000 g min)"]
["Wt of Sieve+Pan+Residue",null,"grams"]
[]
["% Retained",{"$f":"(B22-B20)/B21*100","v":{"$error":"#DIV/0!"}},"%","(max 0.3% for project samples)"]
[]
[]
["RESIDUE by EVAPORATION"]
["See AASHTO T-59 part 7 for details"]
["1. Record weight of each of four beaker, glass rod, and screen combinations (Tare)"]
["2. Pour 50 g (+/- 0.1 g) into each of four beakers"]
["3. Place Beaker (containing the emulsion, beaker and rod) into an oven at 325 F for 2 Hours"]
["4. Remove Beakers, stir thoroughly and replace beaker (w/ emulsion, rod and screen) in oven for an additional 1 H"]
["5. Remove, allow to cool, record weight of each combination of beaker (containing rod, screen and residue)"]
[]
[null,"sample 1","sample 2","sample 3","sample 4"]
["Wt of Beaker, Rod, Screen Tare",null,null,null,null,"grams"]
["Wt of Beaker, Rod, Screen, Residue",null,null,null,null,"grams"]
[]
["Residue",{"$f":"2*(B37-B36)","v":0},{"$f":"2*(C37-C36)","v":0},0,0]
["Average Residue",{"$f":"AVERAGE(B39:E39)","v":0}]
[]
["Minimum Residue for Emulsion Type:",{"$f":"B8","v":0},{"$f":"VLOOKUP(B42,Sheet1!B2:C13,2,0)","v":{"$error":"#N/A"}},"%"]
[]
["Validation",{"$f":"B40-C42","v":{"$error":"#N/A"}},{"$f":"IF(B44<0,\"FAIL\",\"PASS\")","v":{"$error":"#N/A"}}]

{"sheet":"Sheet1","index":20,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[null,"CQS-1H",62]
[null,"CQS-1HP",62]
[null,"CRS-1 HM",55]
[null,"CSS-1",57]
[null,"CSS-1H",57]
[null,"eTac-H",50]
[null,"NTCRS-1hSP",50]
[null,"NTSS-1HM",50]
[null,"SS-1",57]
[null,"SS-1H",57]
[null,"SS-1VH",50]
[null,"TST-1P",55]