{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Record 1","Record 2","Notes","Your Notes","Disclaimer"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":35,"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":"Record 1","index":0,"n_rows":52,"n_cols":26,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,18,7,19],[44,18,44,19],[45,18,45,19],[46,18,46,19],[48,18,48,19],[31,18,31,19],[20,18,20,19],[21,18,21,19],[22,18,22,19],[23,18,23,19],[24,18,24,19],[25,18,25,19],[26,18,26,19],[27,18,27,19],[28,18,28,19],[29,18,29,19],[49,18,49,19],[43,18,43,19],[32,18,32,19],[33,18,33,19],[34,18,34,19],[35,18,35,19],[36,18,36,19],[37,18,37,19],[38,18,38,19],[39,18,39,19],[40,18,40,19],[41,18,41,19],[42,18,42,19],[30,18,30,19],[19,18,19,19],[8,18,8,19],[9,18,9,19],[10,18,10,19],[11,18,11,19],[12,18,12,19],[13,18,13,19],[14,18,14,19],[15,18,15,19],[16,18,16,19],[17,18,17,19],[18,18,18,19],[4,1,4,4],[5,1,5,4],[4,17,4,19],[5,17,5,19],[5,15,5,16],[4,15,4,16],[4,10,4,11],[5,10,5,11],[4,12,4,14],[5,12,5,14],[4,6,4,9],[5,6,5,9],[0,1,0,19],[1,1,1,19],[2,1,2,4],[3,1,3,4],[2,17,2,19],[3,17,3,19],[3,15,3,16],[2,15,2,16],[3,10,3,11],[3,12,3,14],[3,6,3,9]]}
["v 1.4","OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
[null,"Shot Record",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pick Lists:","Typical Use:"]
["Lab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%Shot"]
[" Project No.",null,null,null,null,"J.P. No.",null,null,null,null,"%Residual",null,null,null,null,"Binder Tpe",null,null,null,null,null,null,"BinderType","Typical Use Type","Typical 2 Use Type","Typical 3 Use Type"]
[" Contractor",null,null,null,null,"Contract",null,null,null,null,"Specific Gravity",null,null,null,null,"Use Type",null,null,null,null,null,null,"Cutback","Prime Coat","Tack Coat"]
["P/S Name",null,null,null,null," P/S code",null,null,null,null,"Spec. Rate Gal/SY",null,null,null,null,"Spec. Type",null,null,null,null,null,null,"Emulsion","Tack Coat","Fog Seal","Prime Coat"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt Cement","Tack Coat","Fabric"]
[null,"BEGINNING","ENDING","Ft.","Ft."," SQUARE"," GAL."," GAL."," GAL.","OIL (F)","TEMP.","CORR.","GAL. @","RESIDUAL"," ACC.","Diluted","Raw","Residual","Lane or",null,null,null,"Performance Grade","Fabric"]
["DATE","STATION","STATION"," LENGTH"," WIDTH","  YARDS"," START"," STOP"," SHOT","TEMP","CORR.","GAL.",{"$f":"R3","v":0}," GAL."," GAL.","Gal/SY","Gal/SY","Gal/SY","Comments",null,null,null,null,"<-Additional"]
[null,null,null,{"$f":"IF(B10=\"\",\"\",ABS(C10-B10))","v":""},null,{"$f":"IF(E10=\"\",\"\",+D10*E10/9)","v":""},null,null,{"$f":"IF(G10=\"\",\"\",+G10-H10)","v":""},null,{"$f":"IF(J10=\"\",\"\",mf($R$4,J10,$M$5))","v":""},{"$f":"IF(I10=\"\",\"\",I10*K10)","v":""},{"$f":"IF(L10=\"\",\"\",ROUND(L10*$R$3,2))","v":""},{"$f":"IF(M10=\"\",\"\",ROUND(M10*$M$4,2))","v":""},{"$f":"IF(M10=\"\",\"\",+M10)","v":""},{"$f":"IF(M10=\"\",\"\",L10/F10)","v":""},{"$f":"IF(M10=\"\",\"\",M10/F10)","v":""},{"$f":"IF(N10=\"\",\"\",N10/F10)","v":""}]
[null,null,null,{"$f":"IF(B11=\"\",\"\",ABS(C11-B11))","v":""},null,{"$f":"IF(E11=\"\",\"\",+D11*E11/9)","v":""},null,null,{"$f":"IF(G11=\"\",\"\",+G11-H11)","v":""},null,{"$f":"IF(J11=\"\",\"\",mf($R$4,J11,$M$5))","v":""},{"$f":"IF(I11=\"\",\"\",I11*K11)","v":""},"","",{"$f":"IF(M11=\"\",\"\",+M11+O10)","v":""},{"$f":"IF(M11=\"\",\"\",L11/F11)","v":""},{"$f":"IF(M11=\"\",\"\",M11/F11)","v":""},{"$f":"IF(N11=\"\",\"\",N11/F11)","v":""},null,null,null,null,"UseType"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J12=\"\",\"\",mf($R$4,J12,$M$5))","v":""},{"$f":"IF(I12=\"\",\"\",I12*K12)","v":""},"","",{"$f":"IF(M12=\"\",\"\",+M12+O11)","v":""},{"$f":"IF(M12=\"\",\"\",L12/F12)","v":""},{"$f":"IF(M12=\"\",\"\",M12/F12)","v":""},{"$f":"IF(N12=\"\",\"\",N12/F12)","v":""},null,null,null,null,"Prime Coat"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J13=\"\",\"\",mf($R$4,J13,$M$5))","v":""},"","","","","","","",null,null,null,null,"Tack Coat"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J14=\"\",\"\",mf($R$4,J14,$M$5))","v":""},"","","","","","","",null,null,null,null,"Fog Seal"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J15=\"\",\"\",mf($R$4,J15,$M$5))","v":""},"","","","","","","",null,null,null,null,"Fabric"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J16=\"\",\"\",mf($R$4,J16,$M$5))","v":""},"","","","","","","",null,null,null,null,null,"<-Additional"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J17=\"\",\"\",mf($R$4,J17,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J18=\"\",\"\",mf($R$4,J18,$M$5))","v":""},"","","","","","","",null,null,null,null,"SpecType"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J19=\"\",\"\",mf($R$4,J19,$M$5))","v":""},"","","","","","","",null,null,null,null,"Diluted"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J20=\"\",\"\",mf($R$4,J20,$M$5))","v":""},"","","","","","","",null,null,null,null,"Raw/Original"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J21=\"\",\"\",mf($R$4,J21,$M$5))","v":""},"","","","","","","",null,null,null,null,"Residual"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J22=\"\",\"\",mf($R$4,J22,$M$5))","v":""},"","","","","","","",null,null,null,null,null,"<-Additional"]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J23=\"\",\"\",mf($R$4,J23,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J24=\"\",\"\",mf($R$4,J24,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J25=\"\",\"\",mf($R$4,J25,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J26=\"\",\"\",mf($R$4,J26,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J27=\"\",\"\",mf($R$4,J27,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J28=\"\",\"\",mf($R$4,J28,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J29=\"\",\"\",mf($R$4,J29,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J30=\"\",\"\",mf($R$4,J30,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J31=\"\",\"\",mf($R$4,J31,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J32=\"\",\"\",mf($R$4,J32,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J33=\"\",\"\",mf($R$4,J33,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J34=\"\",\"\",mf($R$4,J34,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J35=\"\",\"\",mf($R$4,J35,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J36=\"\",\"\",mf($R$4,J36,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J37=\"\",\"\",mf($R$4,J37,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J38=\"\",\"\",mf($R$4,J38,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J39=\"\",\"\",mf($R$4,J39,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J40=\"\",\"\",mf($R$4,J40,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J41=\"\",\"\",mf($R$4,J41,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J42=\"\",\"\",mf($R$4,J42,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J43=\"\",\"\",mf($R$4,J43,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J44=\"\",\"\",mf($R$4,J44,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J45=\"\",\"\",mf($R$4,J45,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J46=\"\",\"\",mf($R$4,J46,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J47=\"\",\"\",mf($R$4,J47,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J48=\"\",\"\",mf($R$4,J48,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J49=\"\",\"\",mf($R$4,J49,$M$5))","v":""},"","","","","","",""]
["Totals",null,null,null,null,{"$f":"SUM(F10:F49)","v":0},null,null,null,null,null,{"$f":"SUM(L10:L49)","v":0},{"$f":"SUM(M10:M49)","v":0},{"$f":"SUM(N10:N49)","v":0},{"$f":"SUM(O11:O49)","v":0}]
[]
[null,"Signature / Cert. ID",null,null,"/"]

{"sheet":"Record 2","index":1,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,18,7,19],[4,17,4,19],[5,6,5,9],[5,10,5,11],[5,12,5,14],[5,15,5,16],[5,17,5,19],[40,18,40,19],[41,18,41,19],[9,18,9,19],[10,18,10,19],[11,18,11,19],[23,18,23,19],[12,18,12,19],[13,18,13,19],[14,18,14,19],[15,18,15,19],[16,18,16,19],[17,18,17,19],[18,18,18,19],[19,18,19,19],[20,18,20,19],[21,18,21,19],[29,18,29,19],[30,18,30,19],[31,18,31,19],[32,18,32,19],[33,18,33,19],[24,18,24,19],[25,18,25,19],[26,18,26,19],[27,18,27,19],[28,18,28,19],[0,1,0,19],[1,1,1,19],[3,1,3,4],[4,1,4,4],[5,1,5,4],[2,15,2,16],[2,17,2,19],[3,6,3,9],[3,10,3,11],[3,12,3,14],[3,15,3,16],[3,17,3,19],[4,6,4,9],[4,10,4,11],[4,12,4,14],[4,15,4,16],[8,18,8,19],[49,18,49,19],[2,1,2,4],[43,18,43,19],[44,18,44,19],[45,18,45,19],[46,18,46,19],[48,18,48,19],[35,18,35,19],[36,18,36,19],[37,18,37,19],[38,18,38,19],[39,18,39,19],[42,18,42,19],[22,18,22,19],[34,18,34,19]]}
[{"$f":"'Record 1'!A1","v":"v 1.4"},"OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
[null,"Shot Record"]
["Lab",{"$f":"IF('Record 1'!B3=\"\",\"\",'Record 1'!B3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"%Shot",null,{"$f":"IF('Record 1'!R3=\"\",\"\",'Record 1'!R3)","v":""}]
[" Project No.",{"$f":"IF('Record 1'!B4=\"\",\"\",'Record 1'!B4)","v":""},null,null,null,"J.P. No.",{"$f":"IF('Record 1'!G4=\"\",\"\",'Record 1'!G4)","v":""},null,null,null,"%Residual",null,{"$f":"IF('Record 1'!M4=\"\",\"\",'Record 1'!M4)","v":""},null,null,"Binder Tpe",null,{"$f":"IF('Record 1'!R4=\"\",\"\",'Record 1'!R4)","v":""}]
[" Contractor",{"$f":"IF('Record 1'!B5=\"\",\"\",'Record 1'!B5)","v":""},null,null,null,"Contract",{"$f":"IF('Record 1'!G5=\"\",\"\",'Record 1'!G5)","v":""},null,null,null,"Specific Gravity",null,{"$f":"IF('Record 1'!M5=\"\",\"\",'Record 1'!M5)","v":""},null,null,"Use Type",null,{"$f":"IF('Record 1'!R5=\"\",\"\",'Record 1'!R5)","v":""}]
["P/S Name",{"$f":"IF('Record 1'!B6=\"\",\"\",'Record 1'!B6)","v":""},null,null,null," P/S code",{"$f":"IF('Record 1'!G6=\"\",\"\",'Record 1'!G6)","v":""},null,null,null,"Spec. Rate Gal/SY",null,{"$f":"IF('Record 1'!M6=\"\",\"\",'Record 1'!M6)","v":""},null,null,"Spec. Type",null,{"$f":"IF('Record 1'!R6=\"\",\"\",'Record 1'!R6)","v":""}]
[]
[null,"BEGINNING","ENDING","Ft.","Ft."," SQUARE"," GAL."," GAL."," GAL.","OIL (F)","TEMP.","CORR.","GAL. @"," RESID."," ACC.","Diluted","Raw","Residual","Lane or"]
["DATE","STATION","STATION"," LENGTH"," WIDTH","  YARDS"," START"," STOP"," SHOT","TEMP","CORR.","GAL.",{"$f":"G5","v":""}," GAL."," GAL.","Gal/SY","Gal/SY","Gal/SY","Comments"]
[null,null,null,null,null,{"$f":"IF('Record 1'!F49=\"\",\"\",'Record 1'!F50)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF('Record 1'!O49=\"\",\"\",'Record 1'!O50)","v":""}]
[null,null,null,{"$f":"IF(B11=\"\",\"\",ABS(C11-B11))","v":""},null,{"$f":"IF(E11=\"\",\"\",+D11*E11/9)","v":""},null,null,{"$f":"IF(G11=\"\",\"\",+G11-H11)","v":""},null,{"$f":"IF(J11=\"\",\"\",mf($R$4,J11,$M$5))","v":""},{"$f":"IF(I11=\"\",\"\",I11*K11)","v":""},{"$f":"IF(L11=\"\",\"\",ROUND(L11*$R$3,2))","v":""},{"$f":"IF(M11=\"\",\"\",ROUND(M11*$M$4,2))","v":""},{"$f":"IF(M11=\"\",\"\",+M11+O10)","v":""},{"$f":"IF(M11=\"\",\"\",L11/F11)","v":""},{"$f":"IF(M11=\"\",\"\",M11/F11)","v":""},{"$f":"IF(N11=\"\",\"\",N11/F11)","v":""}]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J12=\"\",\"\",mf($R$4,J12,$M$5))","v":""},{"$f":"IF(I12=\"\",\"\",I12*K12)","v":""},{"$f":"IF(L12=\"\",\"\",ROUND(L12*$R$3,2))","v":""},{"$f":"IF(M12=\"\",\"\",ROUND(M12*$M$4,2))","v":""},{"$f":"IF(M12=\"\",\"\",+M12+O11)","v":""},{"$f":"IF(M12=\"\",\"\",L12/F12)","v":""},{"$f":"IF(M12=\"\",\"\",M12/F12)","v":""},{"$f":"IF(N12=\"\",\"\",N12/F12)","v":""}]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J13=\"\",\"\",mf($R$4,J13,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J14=\"\",\"\",mf($R$4,J14,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J15=\"\",\"\",mf($R$4,J15,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J16=\"\",\"\",mf($R$4,J16,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J17=\"\",\"\",mf($R$4,J17,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J18=\"\",\"\",mf($R$4,J18,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J19=\"\",\"\",mf($R$4,J19,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J20=\"\",\"\",mf($R$4,J20,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J21=\"\",\"\",mf($R$4,J21,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J22=\"\",\"\",mf($R$4,J22,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J23=\"\",\"\",mf($R$4,J23,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J24=\"\",\"\",mf($R$4,J24,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J25=\"\",\"\",mf($R$4,J25,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J26=\"\",\"\",mf($R$4,J26,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J27=\"\",\"\",mf($R$4,J27,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J28=\"\",\"\",mf($R$4,J28,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J29=\"\",\"\",mf($R$4,J29,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J30=\"\",\"\",mf($R$4,J30,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J31=\"\",\"\",mf($R$4,J31,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J32=\"\",\"\",mf($R$4,J32,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J33=\"\",\"\",mf($R$4,J33,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J34=\"\",\"\",mf($R$4,J34,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J35=\"\",\"\",mf($R$4,J35,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J36=\"\",\"\",mf($R$4,J36,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J37=\"\",\"\",mf($R$4,J37,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J38=\"\",\"\",mf($R$4,J38,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J39=\"\",\"\",mf($R$4,J39,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J40=\"\",\"\",mf($R$4,J40,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J41=\"\",\"\",mf($R$4,J41,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J42=\"\",\"\",mf($R$4,J42,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J43=\"\",\"\",mf($R$4,J43,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J44=\"\",\"\",mf($R$4,J44,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J45=\"\",\"\",mf($R$4,J45,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J46=\"\",\"\",mf($R$4,J46,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J47=\"\",\"\",mf($R$4,J47,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J48=\"\",\"\",mf($R$4,J48,$M$5))","v":""},"","","","","","",""]
[null,null,null,"",null,"",null,null,"",null,{"$f":"IF(J49=\"\",\"\",mf($R$4,J49,$M$5))","v":""},"","","","","","",""]
["Totals",null,null,null,null,{"$f":"SUM(F10:F49)","v":0},null,null,null,null,null,{"$f":"SUM(L10:L49)","v":0},{"$f":"SUM(M10:M49)","v":0},{"$f":"SUM(N10:N49)","v":0},{"$f":"SUM(O11:O49)","v":0}]
[]
[null,"Signature / Cert. ID",null,null,"/",{"$f":"IF('Record 1'!F52=\"\",\"\",'Record 1'!F52)","v":""}]

{"sheet":"Notes","index":2,"n_rows":67,"n_cols":2,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Description","Link / Note"]
["Shot Record v1.3.xlsm w/ example data","https://www.odot.org/materials/comn_asphss/EXAMPS_W_DATA/Shot Record v1.3 wData.xlsm"]
["Common Asphalt Spreadsheets","https://oklahoma.gov/odot/business-center/materials/comm-asphss.html"]
["Tack Coat Best Practices Workshop","http://ltap.okstate.edu/OK_Tack_Coat.pdf"]
["NCHRP Report 712","https://www.trb.org/Publications/Blurbs/166969.aspx"]
[]
["APL for Binders","https://www.odot.org/materials/htm-smap/11062p-BIT.html"]
[]
["Next 3 and Historical:","https://oklahoma.gov/odot/business-center/materials/spec-grav.html"]
["SG & %Residual Asphalt Cements","https://www.odot.org/materials/BITUM_TST_RPT/XLS/WEB_REPS/PGB/PGB_AVG_SP_GRAVS.xls"]
["SG & %Residual Cutbacks","https://www.odot.org/materials/BITUM_TST_RPT/XLS/WEB_REPS/CBK/CBK_AVG_SP_GRAVS.xls"]
["SG & %Residual Emulsions","https://www.odot.org/materials/BITUM_TST_RPT/XLS/WEB_REPS/EMU/EMU_AVG_SP_GRAVS.xls"]
[]
["Note 1:","Use the last 366 days or one year average percent residual for sheets Record 1 and Record 2. "]
["Note 2:","Shot@ is the percentage of original/raw emulsion.  For example, SS-1 diluted 1:1, 1 part emulsion / 2 parts total x 100 = 50% Shot@."]
["Note 3:","Volume corrections to 60°F."]
["Note 4:","Not all tack coat products are emulsions."]
[]
[null,"Example below is from %residual link above for emulsions. It shows how %residual is found for SS-1 (P/S m00324) from 1/30/14 to 1/30/15."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Update History:","Revison Notes"]
[1,"v1.2 - 6/29/15 Kenneth Hobson - Added unprotected worksheet \"Your Notes\""]
[2,"v1.2 - 6/29/15 Kenneth Hobson - Widended some column widths on worksheets \"Record 1\" and \"Record 2\"."]
[3,"v1.3 - 11/30/16 Virgil Smith - Updated two web page links at the top part of this sheet (\"Notes\" sheet)."]
[4,"v1.4 - 8/11/23 Virgil Smith - Corrected %Shot formula (cell R3) on worksheet \"Record 2\" to reference same cell of worksheet \"Record 1\".  Also, updated web page links at the top part of this sheet (\"Notes\" sheet)."]

{"sheet":"Your Notes","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Disclaimer","index":4,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["By using this file, you are agreeing to this License Agreement:"]
[]
["The Oklahoma Department of Transportation (ODOT) does not provide technical support with respect to these files. Read the following disclaimer for terms of use pior to using this file."]
[]
[]
["ODOT makes no warranty of any kind, express or implied, with respect to any file. ODOT makes no warranty that any file is marketable or fit for any particular purpose. A description of a file shall not be deemed to create an express warranty that the file conforms to that description. You agree to accept the files in the format provided."]
[]
[]
["You assume all risk and liability for any losses, damages, claims, or expenses resulting from the use or possession of any file."]
[]
[]
["You agree to indemnify, defend, and hold harmless ODOT and its officers, agents, and employees from and against any and all claims, suits, losses, damages, or costs, including reasonable attorney's fees, arising from or by reason of your use or possession of any file. This indemnification shall survive your acceptance of any file."]
[]
[]
["Revisions or additions may occur at any time. You agree to indemnify, defend, and hold harmless ODOT and its officers, agents, and employees from and against any and all claims, suits, losses, damages, or costs, including reasonable attorney's fees, arising from the use of outdated files. This indemnification shall survive your acceptance of any file."]
[]
[]
["The files are copyrighted by ODOT and may not be resold without the express written consent of ODOT. "]