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

{"sheet":"Sheet1","index":0,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[25,0,25,6],[0,0,0,6]]}
["OHD L-14  METHOD OF TEST FOR BULK SPECIFIC GRAVITY, PERCENT ABSORPTION, PERCENT AIR VOIDS, PERCENT DENSITY",null,null,null,null,null,null,null,null,"Drying Method:"]
["v 1.01",null,null,null,null,null,null,null,null,"1 - 125 ± 5⁰F"]
["Project  ",null,"Contract  ",null,"Lab Number  ",null,null,null,null,"2 - 230 ± 9⁰F"]
["Producer  ",null,"Type Mix  ",null,"Design Number  ",null,null,null,null,"3 - D 7227"]
["Date  ",null,"SiteManager™  ",null,"Gmm (Max. Theo. Sp. Gr.)  "]
[]
["Specimen Number"]
["Pan Number"]
["Pan Weight"]
["Wt. Pan + Spec. In Air "]
["Drying Method (1, 2, 3)"]
["Wt. Pan + Spec. In Air "]
["A (Wt. Dry Spec. in Air)",{"$f":"IF(B10=\"\",\"\",B12-B9)","v":""},{"$f":"IF(C10=\"\",\"\",C12-C9)","v":""},"","","",""]
["C (Wt. Spec. In H2O)"]
["B (Wt. Spec. SSD)"]
["Volume (B - C)",{"$f":"IF(B14=\"\",\"\",B15-B14)","v":""},"","","","",""]
["Gmb = A/(B-C)",{"$f":"IF(B14=\"\",\"\",ROUND(B13/(B16),3))","v":""},{"$f":"IF(C14=\"\",\"\",ROUND(C13/(C16),3))","v":""},"","","",""]
["Pabs = (B-A)/(B-C)*100",{"$f":"IF(B15=\"\",\"\",(B15-B13)/B16*100)","v":""},{"$f":"IF(C15=\"\",\"\",(C15-C13)/C16*100)","v":""},"","","",""]
["X = Used for Averages"]
["OHD L-45 Required (Yes/No)",{"$f":"IF(B18=\"\",\"\",IF(B18>2,\"Yes\",\"No\"))","v":""},{"$f":"IF(C18=\"\",\"\",IF(C18>2,\"Yes\",\"No\"))","v":""},"","","",""]
["Average Gmb",{"$f":"IF(COUNT(B23:G23)=0,\"\",ROUND(AVERAGE(B23:G23),3))","v":""}]
["Average PGmm",{"$f":"IF(B21=\"\",\"\",ROUND(B21/F5*100,1))","v":""}]
[null,{"$f":"IF(B19=\"\",\"\",B17)","v":""},{"$f":"IF(C19=\"\",\"\",C17)","v":""},"","","",""]
["Tested by:"]
[]
["OHD L-45  METHOD OF TEST FOR DETERMINING THE SPECIFIC GRAVITY AND UNIT WEIGHT OF COMPACTED BITUMINOUS MIXTURES USING THE CORELOK™  APPARATUS"]
[]
["Specimen Number"]
["Pan Number"]
["Pan Weight"]
["Wt. Pan + Spec. In Air "]
["Drying Method (1, 2, 3)"]
["Wt. Pan + Spec. In Air "]
["A (Wt. Dry Spec. in Air)",{"$f":"IF(B31=\"\",\"\",B33-B30)","v":""},"",{"$f":"IF(D31=\"\",\"\",D33-D30)","v":""},{"$f":"IF(E31=\"\",\"\",E33-E30)","v":""},{"$f":"IF(F31=\"\",\"\",F33-F30)","v":""},{"$f":"IF(G31=\"\",\"\",G33-G30)","v":""}]
["Bag Weight"]
["B (Sealed Wt. in Air)",{"$f":"IF(B35=\"\",\"\",B34+B35)","v":""},{"$f":"IF(C35=\"\",\"\",C34+C35)","v":""},"","","",""]
["E (Sealed Spec. Wt. in H2O)"]
["C (Final Wt. Dry Spec. in Air)"]
["Redo (Yes/No)",{"$f":"IF(B38=\"\",\"\",IF(AND(B34-B38<B34*0.0008,B38-B34<=B34*0.0004),\"No\",\"Yes\"))","v":""},{"$f":"IF(C38=\"\",\"\",IF(AND(C34-C38<C34*0.0008,C38-C34<=C34*0.0004),\"No\",\"Yes\"))","v":""},"","","",""]
["F (Bag's Gsa)",{"$f":"IF(B39=\"No\",IF(B35>=35,0.8596-(0.00166*B34/B35),0.8121-(0.000566*B34/B35)),\"\")","v":""},{"$f":"IF(C39=\"No\",IF(C35>=35,0.8596-(0.00166*C34/C35),0.8121-(0.000566*C34/C35)),\"\")","v":""},"","","",""]
["Gmb = A/(C+(B-A)-E-(B-A)/F))",{"$f":"IF(B40=\"\",\"\",ROUND(B34/(B38+B35-B37-(B35/B40)),3))","v":""},{"$f":"IF(C40=\"\",\"\",ROUND(C34/(C38+C35-C37-(C35/C40)),3))","v":""},"","","",""]
["X = Used for Averages"]
["Density in pcf @ 25°C",{"$f":"IF(B41=\"\",\"\",ROUND(B41*62.2,2))","v":""},{"$f":"IF(C41=\"\",\"\",ROUND(C41*62.2,2))","v":""},"","","",""]
["Average Gmb",{"$f":"IF(COUNT(B23:G23,B46:G46)=0,\"\",ROUND(AVERAGE(B23:G23,B46:G46),3))","v":""}]
["Average PGmm",{"$f":"IF(B44=\"\",\"\",ROUND(B44/F5*100,1))","v":""}]
[null,{"$f":"IF(B42=\"\",\"\",B41)","v":""},{"$f":"IF(C42=\"\",\"\",C41)","v":""},"","","",""]
["Tested by:"]
[]
["Eq. 1","Eq. 2",null,"Eq. 3",null,"Note:  Round and report F and Gmb to nearest 0.001"]
[null,null,null,null,null,"Note: Avg. values are ALL X marked specimens for"]
[null,null,null,null,null,"          both L-14 and L-45."]