{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["NCHRP 9-40A","ASTM D 2995","Notes","Disclaimer"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":4,"defined_names":29,"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":"NCHRP 9-40A","index":0,"n_rows":46,"n_cols":26,"rows_kept":46,"cut":false,"hidden":false,"merged":[[13,8,14,8],[0,1,0,19],[1,1,1,19],[2,1,2,4],[2,15,2,16],[2,17,2,19],[3,17,3,19],[4,1,4,4],[4,6,4,9],[4,10,4,11],[4,12,4,14],[3,1,3,4],[3,6,3,9],[3,10,3,11],[3,12,3,14],[3,15,3,16],[7,1,7,4],[7,6,7,9],[7,10,7,11],[7,12,7,14],[5,1,5,4],[5,6,5,9],[5,10,5,11],[5,12,5,14],[7,15,7,16],[7,17,7,19],[5,15,5,16],[5,17,5,19],[4,15,4,16],[4,17,4,19],[6,15,6,16],[6,17,6,19]]}
["v 0.1","OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
[null,"Calibration Shot Record NCHRP 9-40A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pick Lists:","Typical Use:"]
["Calibrator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%Shot",null,1]
[" Project No.",null,null,null,null,"J.P. No.",null,null,null,null,"%Residual",null,0.621,null,null,"Binder Type",null,"Emulsion",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,1.0121,null,null,{"$f":"R4 & \" (°F)\"","v":"Emulsion (°F)"},{"$f":"R4 & \" (°F)\"","v":"Emulsion (°F)"},160,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,0.1,null,null,"Spec. Type",null,"Raw/Original",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,"Use Type",null,"Tack Coat"]
["Date","2016-04-13",null,null,null,"Dist. ID",null,null,null,null,"Dist. Rate Gal/SY",null,0.1,null,null,"Dist. Speed mpg",null,null,null,null,null,null,"Asphalt Cement","Tack Coat","Fabric"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performance Grade","Fabric"]
["Pad/ID","Pad Initial ","Extra Wt. (g)","Final Wt.","Net","Residual",{"$f":"R4","v":"Emulsion"},null,"Mult.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<-Additional"]
["Number","Wt. (g)","Bag, etc.","Total (g)","Wt. (g)","Gal/SY","Gal/SY",null,"Factor"]
[1,25.3,0,69.400000000000006,{"$f":"IF(D12=\"\",\"\",D12-C12-B12)","v":44.100000000000009},{"$f":"IF($E12=\"\",\"\",$E12*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.5939945733547167E-2},{"$f":"IF($E12=\"\",\"\",$E12*0.000264*9/($M$5*mf($R$4,$R$5)))","v":0.10618348749363472},null,{"$f":"mf($R$4,$R$5)","v":0.97499999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,"UseType"]
[2,25,0,61.7,{"$f":"IF(D13=\"\",\"\",D13-C13-B13)","v":36.700000000000003},{"$f":"IF($E13=\"\",\"\",$E13*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":5.4875192934720651E-2},{"$f":"IF($E13=\"\",\"\",$E13*0.000264*9/($M$5*mf($R$4,$R$5)))","v":8.8365850136426172E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prime Coat"]
[3,25.5,0,69.099999999999994,43.599999999999994,{"$f":"IF($E14=\"\",\"\",$E14*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.5192327301194009E-2},{"$f":"IF($E14=\"\",\"\",$E14*0.000264*9/($M$5*mf($R$4,$R$5)))","v":0.1049795930776071},null,"Average","Residual","Emuslion",null,null,null,null,null,null,null,null,null,null,null,"Tack Coat"]
[4,25.5,0,71.400000000000006,45.900000000000006,{"$f":"IF($E15=\"\",\"\",$E15*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.8631372090018489E-2},{"$f":"IF($E15=\"\",\"\",$E15*0.000264*9/($M$5*mf($R$4,$R$5)))","v":0.11051750739133412},null,null,"Gal/SY","Gal/SY",null,null,null,null,null,null,null,null,null,null,null,"Fog Seal"]
[5,24.9,0,65.400000000000006,40.500000000000007,{"$f":"IF($E16=\"\",\"\",$E16*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.0557093020604545E-2},{"$f":"IF($E16=\"\",\"\",$E16*0.000264*9/($M$5*mf($R$4,$R$5)))","v":9.7515447698235988E-2},null,"Total",{"$f":"F46","v":5.7734833438471439E-2},{"$f":"G46","v":9.2970746277731775E-2},null,null,null,null,null,null,null,null,null,null,null,"Fabric"]
[6,26.6,0,65.3,38.699999999999996,{"$f":"IF($E17=\"\",\"\",$E17*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":5.7865666664133217E-2},{"$f":"IF($E17=\"\",\"\",$E17*0.000264*9/($M$5*mf($R$4,$R$5)))","v":9.3181427800536579E-2},null,"Bot. Trans.",{"$f":"IF(OR(F32<>\"\",F42<>\"\",COUNT(F37:F39)>0,COUNT(F34:F35)>0),AVERAGE(F32,F37:F39,F42,F34:F35),\"\")","v":5.8271516670267802E-2},{"$f":"IF(OR(G32<>\"\",G42<>\"\",COUNT(G37:G39)>0,COUNT(G34:G35)>0),AVERAGE(G32,G37:G39,G42,G34:G35),\"\")","v":9.3834970483523031E-2},null,null,null,null,null,null,null,null,null,null,null,null,"<-Additional"]
[null,null,null,null,"",{"$f":"IF($E18=\"\",\"\",$E18*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":""},{"$f":"IF($E18=\"\",\"\",$E18*0.000264*9/($M$5*mf($R$4,$R$5)))","v":""},null,"Top. Trans.",{"$f":"IF(COUNT(F12:F19)>0,AVERAGE(F12:F19,F18),\"\")","v":6.2201853571781443E-2},{"$f":"IF(OR(G32<>\"\",G42<>\"\",COUNT(G37:G39)>0,COUNT(G34:G35)),AVERAGE(G32,G37:G39,G42,G34:G35),\"\")","v":9.3834970483523031E-2}]
[8,25.2,0,66.900000000000006,41.7,{"$f":"IF($E19=\"\",\"\",$E19*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.2351377258252079E-2},{"$f":"IF($E19=\"\",\"\",$E19*0.000264*9/($M$5*mf($R$4,$R$5)))","v":0.10040479429670222},null,"Trans.",{"$f":"IF(OR(F32<>\"\",F42<>\"\",F18<>\"\",COUNT(F37:F39)>0,COUNT(F34:F35)>0,COUNT(F12:F19)>0),AVERAGE(F32,F37:F39,F42,F34:F35,F12:F19,F18),\"\")","v":6.0236685121024633E-2},{"$f":"IF(OR(G32<>\"\",G42<>\"\",G18<>\"\",COUNT(G37:G39)>0,COUNT(G34:G35)>0,COUNT(G12:G19)>0),AVERAGE(G32,G37:G39,G42,G34:G35,G12:G19,G18),\"\")","v":9.6999492948509847E-2},null,null,null,null,null,null,null,null,null,null,null,"SpecType"]
[null,null,null,null,"",{"$f":"IF($E20=\"\",\"\",$E20*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":""},{"$f":"IF($E20=\"\",\"\",$E20*0.000264*9/($M$5*mf($R$4,$R$5)))","v":""},null,"Lt Long.",{"$f":"IF(COUNT(F26:F30)>0,AVERAGE(F26:F30),\"\")","v":5.5921858740015054E-2},{"$f":"IF(COUNT(G26:G30)>0,AVERAGE(G26:G30),\"\")","v":9.0051302318864823E-2},null,null,null,null,null,null,null,null,null,null,null,"Diluted"]
[10,25.9,0,68.2,42.300000000000004,{"$f":"IF($E21=\"\",\"\",$E21*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.324851937707586E-2},{"$f":"IF($E21=\"\",\"\",$E21*0.000264*9/($M$5*mf($R$4,$R$5)))","v":0.10184946759593536},null,"Rt. Long.",{"$f":"IF(COUNT(F21:F25)>0,AVERAGE(F21:F25),\"\")","v":5.2542623425778846E-2},{"$f":"IF(COUNT(G21:G25)>0,AVERAGE(G21:G25),\"\")","v":8.4609699558420043E-2},null,null,null,null,null,null,null,null,null,null,null,"Raw/Original"]
[11,26.1,0,39.299999999999997,13.199999999999996,{"$f":"IF($E22=\"\",\"\",$E22*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":1.9737126614122955E-2},{"$f":"IF($E22=\"\",\"\",$E22*0.000264*9/($M$5*mf($R$4,$R$5)))","v":3.1782812583128754E-2},null,"Long.",{"$f":"IF(OR(COUNT(F26:F30)>0,COUNT(F21:F25)>0),AVERAGE(F26:F30,F21:F25),\"\")","v":5.4232241082896947E-2},{"$f":"IF(OR(COUNT(G26:G30)>0,COUNT(G21:G25)>0),AVERAGE(G26:G30,G21:G25),\"\")","v":8.7330500938642433E-2},null,null,null,null,null,null,null,null,null,null,null,"Residual"]
[12,25.8,0,66.599999999999994,40.799999999999997,{"$f":"IF($E23=\"\",\"\",$E23*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.1005664080016411E-2},{"$f":"IF($E23=\"\",\"\",$E23*0.000264*9/($M$5*mf($R$4,$R$5)))","v":9.8237784347852519E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<-Additional"]
[13,24.5,0,66.2,41.7,{"$f":"IF($E24=\"\",\"\",$E24*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.2351377258252079E-2},{"$f":"IF($E24=\"\",\"\",$E24*0.000264*9/($M$5*mf($R$4,$R$5)))","v":0.10040479429670222}]
[14,24.3,0,62,37.700000000000003,{"$f":"IF($E25=\"\",\"\",$E25*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":5.6370429799426941E-2},{"$f":"IF($E25=\"\",\"\",$E25*0.000264*9/($M$5*mf($R$4,$R$5)))","v":9.0773638968481382E-2}]
[15,24.2,0,60.1,35.900000000000006,{"$f":"IF($E26=\"\",\"\",$E26*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":5.367900344295564E-2},{"$f":"IF($E26=\"\",\"\",$E26*0.000264*9/($M$5*mf($R$4,$R$5)))","v":8.6439619070782028E-2}]
[16,24.7,0,62.4,37.700000000000003,{"$f":"IF($E27=\"\",\"\",$E27*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":5.6370429799426941E-2},{"$f":"IF($E27=\"\",\"\",$E27*0.000264*9/($M$5*mf($R$4,$R$5)))","v":9.0773638968481382E-2}]
[17,24.3,0,59.2,34.900000000000006,{"$f":"IF($E28=\"\",\"\",$E28*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":5.2183766578249351E-2},{"$f":"IF($E28=\"\",\"\",$E28*0.000264*9/($M$5*mf($R$4,$R$5)))","v":8.4031830238726818E-2}]
[18,26.2,0,65.900000000000006,39.700000000000003,{"$f":"IF($E29=\"\",\"\",$E29*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":5.9360903528839506E-2},{"$f":"IF($E29=\"\",\"\",$E29*0.000264*9/($M$5*mf($R$4,$R$5)))","v":9.5589216632591803E-2}]
[19,24,0,62.8,38.799999999999997,{"$f":"IF($E30=\"\",\"\",$E30*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":5.8015190350603846E-2},{"$f":"IF($E30=\"\",\"\",$E30*0.000264*9/($M$5*mf($R$4,$R$5)))","v":9.3422206683742098E-2}]
[null,null,null,null,"",{"$f":"IF($E31=\"\",\"\",$E31*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":""},{"$f":"IF($E31=\"\",\"\",$E31*0.000264*9/($M$5*mf($R$4,$R$5)))","v":""}]
[21,27.3,0,69.400000000000006,42.100000000000009,{"$f":"IF($E32=\"\",\"\",$E32*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.2949472004134602E-2},{"$f":"IF($E32=\"\",\"\",$E32*0.000264*9/($M$5*mf($R$4,$R$5)))","v":0.10136790982952432}]
[null,null,null,null,"",{"$f":"IF($E33=\"\",\"\",$E33*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":""},{"$f":"IF($E33=\"\",\"\",$E33*0.000264*9/($M$5*mf($R$4,$R$5)))","v":""}]
[23,26,0,67.3,41.3,{"$f":"IF($E34=\"\",\"\",$E34*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.1753282512369563E-2},{"$f":"IF($E34=\"\",\"\",$E34*0.000264*9/($M$5*mf($R$4,$R$5)))","v":9.9441678763880131E-2}]
[24,24.3,0,38.700000000000003,14.400000000000002,{"$f":"IF($E35=\"\",\"\",$E35*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":2.1531410851770502E-2},{"$f":"IF($E35=\"\",\"\",$E35*0.000264*9/($M$5*mf($R$4,$R$5)))","v":3.4672159181595011E-2}]
[null,null,null,null,"",{"$f":"IF($E36=\"\",\"\",$E36*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":""},{"$f":"IF($E36=\"\",\"\",$E36*0.000264*9/($M$5*mf($R$4,$R$5)))","v":""}]
[26,26.8,0,71.5,44.7,{"$f":"IF($E37=\"\",\"\",$E37*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.6837087852370941E-2},{"$f":"IF($E37=\"\",\"\",$E37*0.000264*9/($M$5*mf($R$4,$R$5)))","v":0.10762816079286786}]
[27,26.4,0,66.3,39.9,{"$f":"IF($E38=\"\",\"\",$E38*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":5.9659950901780764E-2},{"$f":"IF($E38=\"\",\"\",$E38*0.000264*9/($M$5*mf($R$4,$R$5)))","v":9.6070774399002842E-2}]
[28,28.3,0,71.400000000000006,43.100000000000009,{"$f":"IF($E39=\"\",\"\",$E39*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":6.4444708868840891E-2},{"$f":"IF($E39=\"\",\"\",$E39*0.000264*9/($M$5*mf($R$4,$R$5)))","v":0.10377569866157954}]
[null,null,null,null,"",{"$f":"IF($E40=\"\",\"\",$E40*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":""},{"$f":"IF($E40=\"\",\"\",$E40*0.000264*9/($M$5*mf($R$4,$R$5)))","v":""}]
[null,null,null,null,"",{"$f":"IF($E41=\"\",\"\",$E41*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":""},{"$f":"IF($E41=\"\",\"\",$E41*0.000264*9/($M$5*mf($R$4,$R$5)))","v":""}]
[31,27.9,0,75.2,47.300000000000004,{"$f":"IF($E42=\"\",\"\",$E42*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":7.072470370060728E-2},{"$f":"IF($E42=\"\",\"\",$E42*0.000264*9/($M$5*mf($R$4,$R$5)))","v":0.11388841175621141}]
[null,null,null,null,"",{"$f":"IF($E43=\"\",\"\",$E43*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":""},{"$f":"IF($E43=\"\",\"\",$E43*0.000264*9/($M$5*mf($R$4,$R$5)))","v":""}]
[null,null,null,null,"",{"$f":"IF($E44=\"\",\"\",$E44*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":""},{"$f":"IF($E44=\"\",\"\",$E44*0.000264*9/($M$5*mf($R$4,$R$5)))","v":""}]
[null,null,null,null,"",{"$f":"IF($E45=\"\",\"\",$E45*0.000264*9/($M$5*mf($R$4,$R$5))*$M$4)","v":""},{"$f":"IF($E45=\"\",\"\",$E45*0.000264*9/($M$5*mf($R$4,$R$5)))","v":""}]
[null,null,null,null,"Avg.",{"$f":"IF(COUNT(F12:F45)>0,AVERAGE(F12:F45),\"\")","v":5.7734833438471439E-2},{"$f":"IF(COUNT(G12:G45)>0,AVERAGE(G12:G45),\"\")","v":9.2970746277731775E-2}]

{"sheet":"ASTM D 2995","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Notes","index":2,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Description","Link / Note"]
["Tack Calibration v0.1.xlsm w/ example data","http://www.odot.org/materials/comn_asphss/EXAMPS_W_DATA/Tack Calibration v0.1 wData.xlsm"]
["Common Asphalt Spreadsheets","https://www.ok.gov/odot/Doing_Business/Materials/comm_asphss.html"]
["Tack Coat Best Practices Workshop","http://ltap.okstate.edu/OK_Tack_Coat.pdf"]
["NCHRP Report 712","http://onlinepubs.trb.org/onlinepubs/nchrp/nchrp_rpt_712.pdf"]
[]
["APL for Binders","http://www.odot.org/materials/htm-smap/11062p-BIT.html"]
[]
["Next 3 and Historical:","https://www.ok.gov/odot/Doing_Business/Materials/spec_grav.html"]
["SG & %Residual Asphalt Cements","http://www.odot.org/materials/BITUM_TST_RPT/XLS/WEB_REPS/PGB/PGB_AVG_SP_GRAVS.xls"]
["SG & %Residual Cutbacks","http://www.odot.org/materials/BITUM_TST_RPT/XLS/WEB_REPS/CBK/CBK_AVG_SP_GRAVS.xls"]
["SG & %Residual Emulsions","http://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."]

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