{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Option A (English)","Option A (Metric)","Option B (English)","Option B (Metric)"],"not_rendered":{"charts":8,"images":4,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Estimating Application Rate of Bituminous Distributors"]
["ASTM D2995-23"]
[]
["Spreadsheet Template Instructions"]
[]
["1. Select appropriate worksheet for ASTM D2995 Option A (cutback/asphalt binder) or Option B (emulsion) and English or metric units."]
[]
["2. Enter data in project information fields. A specific gravity must be provided for results to calculate properly."]
[]
["3. Enter pad mass data for transverse (up to 18 pads) and longitudinal pads (18 pads)."]
[]
["4. With macros enabled, the auto-scale button can be used to automatically scale plots to fit available data."]
[]
["5. The average shot rate or residual rate can be compared against specification requirements for compliance."]
[]
["6. Individual pads varying more than 20% from the average are highlighted in red text."]
[]
[]
["Terms"]
["Mdry","dry mass of pad prior to prime or tack coat application"]
["Mwet","wet mass of pad immediately after prime or tack coat application"]
["MOD, i min","oven-dry mass of pad and prime or tack coat after i minutes in an oven"]

{"sheet":"Option A (English)","index":1,"n_rows":26,"n_cols":33,"rows_kept":26,"cut":false,"hidden":false,"merged":[[12,0,13,0],[12,1,12,18],[18,0,19,0],[18,1,18,18],[24,0,25,9],[9,12,9,13],[8,0,8,1],[8,2,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,11],[8,12,8,13],[9,0,9,1],[9,2,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,11],[6,14,6,16],[6,17,6,18],[7,0,7,1],[7,2,7,4],[7,5,7,6],[7,7,7,8],[7,9,7,11],[7,12,7,13],[7,14,7,16],[7,17,7,18],[6,0,6,1],[6,2,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,11],[6,12,6,13],[2,10,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,18],[3,10,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18]]}
["Plot Data - Transverse",null,null,"Pad No. (Min / Max):",null,0,{"$f":"MAX(B14:S14)+1","v":19},"Rate Plot (Min / Max):",null,{"$f":"ROUNDDOWN(MIN(B17:S17,B23:S23),2)-0.01","v":-0.01},{"$f":"ROUNDUP(MAX(B17:S17,B23:S23),2)","v":0}]
["Plot Data - Longitudinal",null,null,"Pad No. (Min / Max):",null,0,{"$f":"MAX(B20:S20)+1","v":19}]
["Estimating Application Rate of Bituminous Distributors",null,null,null,null,null,null,null,null,null,"Average Values",null,null,"Transverse",null,"Longitudinal",null,"Average",null,null,null,null,null,null,null,null,null,null,"Tolerance:",0.2]
["ASTM D2995-23 (Option A)",null,null,null,null,null,null,null,null,null,"Shot Rate, gal/yd2",null,null,{"$f":"IFERROR(AVERAGE(B17:S17),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(B23:S23),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(N4:Q4),\"---\")","v":"---"},null,null,null,null,null,null,null,null,null,null,null,"Trans. Tolerance","Long. Tolerance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Shot",{"$f":"N4*(1+$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P4*(1+$AD$3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max. Shot",{"$f":"N4*(1-$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P4*(1-$AD$3)","v":{"$error":"#VALUE!"}}]
["Project:",null,null,null,null,"Verified By:",null,null,null,"Distributor ID:",null,null,null,null,"Target Shot Rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Res.",{"$f":"N5*(1+$AD$3)","v":0},{"$f":"P5*(1+$AD$3)","v":0}]
["Contract No:",null,null,null,null,"Testing Date:",null,null,null,"Spray Bar Height, in.:",null,null,null,null,"Specific Gravity:"]
["Emulsified Material:",null,null,null,null,"Inspector:",null,null,null,"Truck Speed, mph:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max. Res.",{"$f":"N5*(1-$AD$3)","v":0},{"$f":"P5*(1-$AD$3)","v":0}]
["Source/Location:",null,null,null,null,"Report No:",null,null,null,"RPM (Truck):"]
[]
[]
["Mass (M), g","Transverse Pad Number"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["Mdry"]
["Mwet"]
["Shot Rate",{"$f":"IF(ISNUMBER(B16),(B16-B15/$R$8)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
["App. (Plot)",{"$f":"IF(ISNUMBER(B17),B17,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Mass (M), g","Longitudinal Pad Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B17:M17)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B17:M17)","v":{"$error":"#DIV/0!"}},{"$f":"AD19/AC19","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B17:M17)","v":0},{"$f":"MIN(B17:M17)","v":0}]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["Mdry"]
["Mwet"]
["Shot Rate",{"$f":"IF(ISNUMBER(B22),(B22-B21/$R$8)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(ISNUMBER(N22),(N22-N21/$R$8)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---"]
["App. (Plot)",{"$f":"IF(ISNUMBER(B23),B23,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Application Rate, gal/yd² =  (A/G) X 0.000264 gal/mL X 9 ft²/ yd²",null,null,null,null,null,null,null,null,null,"A = net weight of bituminous material per pad assembly, g",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B23:M23)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B23:M23)","v":{"$error":"#DIV/0!"}},{"$f":"AD25/AC25","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B23:M23)","v":0},{"$f":"MIN(B23:M23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"G = specific gravity of bituminous material at spray temperature"]

{"sheet":"Option A (Metric)","index":2,"n_rows":26,"n_cols":33,"rows_kept":26,"cut":false,"hidden":false,"merged":[[12,0,13,0],[12,1,12,18],[18,0,19,0],[18,1,18,18],[24,0,25,9],[9,12,9,13],[8,0,8,1],[8,2,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,11],[8,12,8,13],[9,0,9,1],[9,2,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,11],[6,14,6,16],[6,17,6,18],[7,0,7,1],[7,2,7,4],[7,5,7,6],[7,7,7,8],[7,9,7,11],[7,12,7,13],[7,14,7,16],[7,17,7,18],[6,0,6,1],[6,2,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,11],[6,12,6,13],[2,10,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,18],[3,10,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18]]}
["Plot Data - Transverse",null,null,"Pad No. (Min / Max):",null,0,{"$f":"MAX(B14:S14)+1","v":19},"Rate Plot (Min / Max):",null,{"$f":"ROUNDDOWN(MIN(B17:S17,B23:S23),1)-0.1","v":-0.1},{"$f":"ROUNDUP(MAX(B17:S17,B23:S23),1)","v":0}]
["Plot Data - Longitudinal",null,null,"Pad No. (Min / Max):",null,0,{"$f":"MAX(B20:S20)+1","v":19}]
["Estimating Application Rate of Bituminous Distributors",null,null,null,null,null,null,null,null,null,"Average Values",null,null,"Transverse",null,"Longitudinal",null,"Average",null,null,null,null,null,null,null,null,null,null,"Tolerance:",0.2]
["ASTM D2995-23 (Option A)",null,null,null,null,null,null,null,null,null,"Shot Rate, L/m2",null,null,{"$f":"IFERROR(AVERAGE(B17:S17),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(B23:S23),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(N4:Q4),\"---\")","v":"---"},null,null,null,null,null,null,null,null,null,null,null,"Trans. Tolerance","Long. Tolerance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Shot",{"$f":"N4*(1+$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P4*(1+$AD$3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max. Shot",{"$f":"N4*(1-$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P4*(1-$AD$3)","v":{"$error":"#VALUE!"}}]
["Project:",null,null,null,null,"Verified By:",null,null,null,"Distributor ID:",null,null,null,null,"Target Shot Rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Res.",{"$f":"N5*(1+$AD$3)","v":0},{"$f":"P5*(1+$AD$3)","v":0}]
["Contract No:",null,null,null,null,"Testing Date:",null,null,null,"Spray Bar Height, m:",null,null,null,null,"Specific Gravity:"]
["Emulsified Material:",null,null,null,null,"Inspector:",null,null,null,"Truck Speed, kph:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max. Res.",{"$f":"N5*(1-$AD$3)","v":0},{"$f":"P5*(1-$AD$3)","v":0}]
["Source/Location:",null,null,null,null,"Report No:",null,null,null,"RPM (Truck):"]
[]
[]
["Mass (M), g","Transverse Pad Number"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["Mdry"]
["Mwet"]
["Shot Rate",{"$f":"IF(ISNUMBER(B16),(B16-B15/$R$8)*(0.001)*10.764,\"---\")","v":"---"},{"$f":"IF(ISNUMBER(C16),(C16-C15/$R$8)*(0.001)*10.764,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
["App. (Plot)",{"$f":"IF(ISNUMBER(B17),B17,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Mass (M), g","Longitudinal Pad Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B17:M17)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B17:M17)","v":{"$error":"#DIV/0!"}},{"$f":"AD19/AC19","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B17:M17)","v":0},{"$f":"MIN(B17:M17)","v":0}]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["Mdry"]
["Mwet"]
["Shot Rate",{"$f":"IF(ISNUMBER(B22),(B22-B21/$R$8)*(0.001)*10.764,\"---\")","v":"---"},{"$f":"IF(ISNUMBER(C22),(C22-C21/$R$8)*(0.001)*10.764,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
["App. (Plot)",{"$f":"IF(ISNUMBER(B23),B23,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Application Rate, L/m² =  (A/G) X 0.001 L/mL X 10.764 ft²/ m²",null,null,null,null,null,null,null,null,null,"A = net weight of bituminous material per pad assembly, g",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B23:M23)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B23:M23)","v":{"$error":"#DIV/0!"}},{"$f":"AD25/AC25","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B23:M23)","v":0},{"$f":"MIN(B23:M23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"G = specific gravity of bituminous material at spray temperature"]

{"sheet":"Option B (English)","index":3,"n_rows":38,"n_cols":33,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,15,2,16],[2,17,2,18],[3,15,3,16],[3,17,3,18],[2,10,2,12],[3,10,3,12],[2,13,2,14],[3,13,3,14],[8,7,8,8],[8,9,8,11],[8,12,8,13],[4,15,4,16],[4,17,4,18],[5,15,5,16],[5,17,5,18],[4,10,4,12],[5,10,5,12],[4,13,4,14],[5,13,5,14],[10,9,10,11],[10,12,10,13],[14,0,15,0],[8,14,8,16],[8,17,8,18],[9,0,9,1],[9,2,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,11],[9,12,9,13],[9,14,9,16],[9,17,9,18],[8,0,8,1],[8,2,8,4],[8,5,8,6],[14,1,14,18],[25,0,26,0],[25,1,25,18],[36,0,37,9],[10,14,10,16],[10,17,10,18],[11,0,11,1],[11,2,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,11],[11,12,11,13],[10,0,10,1],[10,2,10,4],[10,5,10,6],[10,7,10,8]]}
["Plot Data - Transverse",null,null,"Pad No. (Min / Max):",null,0,{"$f":"MAX(B16:S16)+1","v":19},"Rate Plot (Min / Max):",null,{"$f":"ROUNDDOWN(MIN(B22:S23,B33:S34),2)-0.01","v":-0.01},{"$f":"ROUNDUP(MAX(B22:S23,B33:S34),2)","v":0}]
["Plot Data - Longitudinal",null,null,"Pad No. (Min / Max):",null,0,{"$f":"MAX(B27:S27)+1","v":19}]
["Estimating Application Rate of Bituminous Distributors",null,null,null,null,null,null,null,null,null,"Average Values",null,null,"Transverse",null,"Longitudinal",null,"Average",null,null,null,null,null,null,null,null,null,null,"Tolerance:",0.2]
["ASTM D2995-23 (Option B)",null,null,null,null,null,null,null,null,null,"Shot Rate, gal/yd2",null,null,{"$f":"IFERROR(AVERAGE(B22:S22),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(B33:S33),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(N4:Q4),\"---\")","v":"---"},null,null,null,null,null,null,null,null,null,null,null,"Trans. Tolerance","Long. Tolerance"]
[null,null,null,null,null,null,null,null,null,null,"Residual Rate, gal/yd2",null,null,{"$f":"IFERROR(AVERAGE(B23:S23),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(B34:S34),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(N5:Q5),\"---\")","v":"---"},null,null,null,null,null,null,null,null,null,null,"Min. Shot",{"$f":"N4*(1+$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P4*(1+$AD$3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Measured Residue, %",null,null,{"$f":"IFERROR((N5/N4)*100,\"---\")","v":"---"},null,{"$f":"IFERROR((P5/P4)*100,\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(N6:Q6),\"---\")","v":"---"},null,null,null,null,null,null,null,null,null,null,"Max. Shot",{"$f":"N4*(1-$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P4*(1-$AD$3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Res.",{"$f":"N5*(1+$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P5*(1+$AD$3)","v":{"$error":"#VALUE!"}}]
[]
["Project:",null,null,null,null,"Verified By:",null,null,null,"Distributor ID:",null,null,null,null,"Target Residual Rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Max. Res.",{"$f":"N5*(1-$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P5*(1-$AD$3)","v":{"$error":"#VALUE!"}}]
["Contract No:",null,null,null,null,"Testing Date:",null,null,null,"Spray Bar Height, in.:",null,null,null,null,"Specific Gravity:"]
["Emulsified Material:",null,null,null,null,"Inspector:",null,null,null,"Truck Speed, mph:",null,null,null,null,"Reported Residue, %:"]
["Source/Location:",null,null,null,null,"Report No:",null,null,null,"RPM (Truck):"]
[]
[]
["Mass (M), g","Transverse Pad Number"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["Mdry"]
["Mwet"]
["MOD, 20 min"]
["MOD, 40 min"]
["MOD, 60 min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average","STDEV","COV","MAX","MIN"]
["Shot Rate",{"$f":"IF(ISNUMBER(B18),(B18-B17/$R$10)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(ISNUMBER(N18),(N18-N17/$R$10)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B22:M22)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B22:M22)","v":{"$error":"#DIV/0!"}},{"$f":"AD22/AC22","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B22:M22)","v":0},{"$f":"MIN(B22:M22)","v":0}]
["Residual Rate",{"$f":"IF(ISNUMBER(B21),(B21-B17/$R$10)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(ISNUMBER(N21),(N21-N17/$R$10)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B23:M23)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B23:M23)","v":{"$error":"#DIV/0!"}},{"$f":"AD23/AC23","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B23:M23)","v":0},{"$f":"MIN(B23:M23)","v":0}]
["App. (Plot)",{"$f":"IF(ISNUMBER(B22),B22,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ISNUMBER(H22),H22,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ISNUMBER(N22),N22,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Res. (Plot)",{"$f":"IF(ISNUMBER(B23),B23,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Mass (M), g","Longitudinal Pad Number"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["Mdry"]
["Mwet"]
["MOD, 20 min"]
["MOD, 40 min"]
["MOD, 60 min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average","STDEV","COV","MAX","MIN"]
["Shot Rate",{"$f":"IF(ISNUMBER(B29),(B29-B28/$R$10)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(ISNUMBER(N29),(N29-N28/$R$10)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B33:M33)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B33:M33)","v":{"$error":"#DIV/0!"}},{"$f":"AD33/AC33","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B33:M33)","v":0},{"$f":"MIN(B33:M33)","v":0}]
["Residual Rate",{"$f":"IF(ISNUMBER(B32),(B32-B28/$R$10)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(ISNUMBER(N32),(N32-N28/$R$10)*(0.000264)*9,\"---\")","v":"---"},"---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B34:M34)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B34:M34)","v":{"$error":"#DIV/0!"}},{"$f":"AD34/AC34","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B34:M34)","v":0},{"$f":"MIN(B34:M34)","v":0}]
["App. (Plot)",{"$f":"IF(ISNUMBER(B33),B33,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(C33),C33,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ISNUMBER(N33),N33,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Res. (Plot)",{"$f":"IF(ISNUMBER(B34),B34,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Application Rate, gal/yd² =  (A/G) X 0.000264 gal/mL X 9 ft²/ yd²",null,null,null,null,null,null,null,null,null,"A = net weight of bituminous material per pad assembly, g"]
[null,null,null,null,null,null,null,null,null,null,"G = specific gravity of bituminous material at spray temperature"]

{"sheet":"Option B (Metric)","index":4,"n_rows":38,"n_cols":33,"rows_kept":38,"cut":false,"hidden":false,"merged":[[14,0,15,0],[14,1,14,18],[25,0,26,0],[25,1,25,18],[36,0,37,9],[10,14,10,16],[10,17,10,18],[11,0,11,1],[11,2,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,11],[11,12,11,13],[10,0,10,1],[10,2,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,11],[10,12,10,13],[8,14,8,16],[8,17,8,18],[9,0,9,1],[9,2,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,11],[9,12,9,13],[9,14,9,16],[9,17,9,18],[8,0,8,1],[8,2,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,11],[8,12,8,13],[4,10,4,12],[4,13,4,14],[4,15,4,16],[4,17,4,18],[5,10,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[2,10,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,18],[3,10,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18]]}
["Plot Data - Transverse",null,null,"Pad No. (Min / Max):",null,0,{"$f":"MAX(B16:S16)+1","v":19},"Rate Plot (Min / Max):",null,{"$f":"ROUNDDOWN(MIN(B22:S23,B33:S34),1)-0.1","v":-0.1},{"$f":"ROUNDUP(MAX(B22:S23,B33:S34),1)","v":0}]
["Plot Data - Longitudinal",null,null,"Pad No. (Min / Max):",null,0,{"$f":"MAX(B27:S27)+1","v":19}]
["Estimating Application Rate of Bituminous Distributors",null,null,null,null,null,null,null,null,null,"Average Values",null,null,"Transverse",null,"Longitudinal",null,"Average",null,null,null,null,null,null,null,null,null,null,"Tolerance:",0.2]
["ASTM D2995-23 (Option B)",null,null,null,null,null,null,null,null,null,"Shot Rate, L/m2",null,null,{"$f":"IFERROR(AVERAGE(B22:S22),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(B33:S33),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(N4:Q4),\"---\")","v":"---"},null,null,null,null,null,null,null,null,null,null,null,"Trans. Tolerance","Long. Tolerance"]
[null,null,null,null,null,null,null,null,null,null,"Residual Rate, L/m2",null,null,{"$f":"IFERROR(AVERAGE(B23:S23),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(B34:S34),\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(N5:Q5),\"---\")","v":"---"},null,null,null,null,null,null,null,null,null,null,"Min. Shot",{"$f":"N4*(1+$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P4*(1+$AD$3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Measured Residue, %",null,null,{"$f":"IFERROR((N5/N4)*100,\"---\")","v":"---"},null,{"$f":"IFERROR((P5/P4)*100,\"---\")","v":"---"},null,{"$f":"IFERROR(AVERAGE(N6:Q6),\"---\")","v":"---"},null,null,null,null,null,null,null,null,null,null,"Max. Shot",{"$f":"N4*(1-$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P4*(1-$AD$3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Res.",{"$f":"N5*(1+$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P5*(1+$AD$3)","v":{"$error":"#VALUE!"}}]
[]
["Project:",null,null,null,null,"Verified By:",null,null,null,"Distributor ID:",null,null,null,null,"Target Residual Rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Max. Res.",{"$f":"N5*(1-$AD$3)","v":{"$error":"#VALUE!"}},{"$f":"P5*(1-$AD$3)","v":{"$error":"#VALUE!"}}]
["Contract No:",null,null,null,null,"Testing Date:",null,null,null,"Spray Bar Height, m:",null,null,null,null,"Specific Gravity:"]
["Emulsified Material:",null,null,null,null,"Inspector:",null,null,null,"Truck Speed, kph:",null,null,null,null,"Reported Residue, %:"]
["Source/Location:",null,null,null,null,"Report No:",null,null,null,"RPM (Truck):"]
[]
[]
["Mass (M), g","Transverse Pad Number"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["Mdry"]
["Mwet"]
["MOD, 20 min"]
["MOD, 40 min"]
["MOD, 60 min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average","STDEV","COV","MAX","MIN"]
["Shot Rate",{"$f":"IF(ISNUMBER(B18),(B18-B17/$R$10)*(0.001)*10.764,\"---\")","v":"---"},{"$f":"IF(ISNUMBER(C18),(C18-C17/$R$10)*(0.001)*10.764,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B22:M22)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B22:M22)","v":{"$error":"#DIV/0!"}},{"$f":"AD22/AC22","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B22:M22)","v":0},{"$f":"MIN(B22:M22)","v":0}]
["Residual Rate",{"$f":"IF(ISNUMBER(B21),(B21-B17/$R$10)*(0.001)*10.764,\"---\")","v":"---"},{"$f":"IF(ISNUMBER(C21),(C21-C17/$R$10)*(0.001)*10.764,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B23:M23)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B23:M23)","v":{"$error":"#DIV/0!"}},{"$f":"AD23/AC23","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B23:M23)","v":0},{"$f":"MIN(B23:M23)","v":0}]
["App. (Plot)",{"$f":"IF(ISNUMBER(B22),B22,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Res. (Plot)",{"$f":"IF(ISNUMBER(B23),B23,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Mass (M), g","Longitudinal Pad Number"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["Mdry"]
["Mwet"]
["MOD, 20 min"]
["MOD, 40 min"]
["MOD, 60 min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average","STDEV","COV","MAX","MIN"]
["Shot Rate",{"$f":"IF(ISNUMBER(B29),(B29-B28/$R$10)*(0.001)*10.764,\"---\")","v":"---"},{"$f":"IF(ISNUMBER(C29),(C29-C28/$R$10)*(0.001)*10.764,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B33:M33)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B33:M33)","v":{"$error":"#DIV/0!"}},{"$f":"AD33/AC33","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B33:M33)","v":0},{"$f":"MIN(B33:M33)","v":0}]
["Residual Rate",{"$f":"IF(ISNUMBER(B32),(B32-B28/$R$10)*(0.001)*10.764,\"---\")","v":"---"},{"$f":"IF(ISNUMBER(C32),(C32-C28/$R$10)*(0.001)*10.764,\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B34:M34)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.STDEV.S(B34:M34)","v":{"$error":"#DIV/0!"}},{"$f":"AD34/AC34","v":{"$error":"#DIV/0!"}},{"$f":"MAX(B34:M34)","v":0},{"$f":"MIN(B34:M34)","v":0}]
["App. (Plot)",{"$f":"IF(ISNUMBER(B33),B33,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(C33),C33,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Res. (Plot)",{"$f":"IF(ISNUMBER(B34),B34,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Application Rate, L/m² =  (A/G) X 0.001 L/mL X 10.764 ft²/ m²",null,null,null,null,null,null,null,null,null,"A = net weight of bituminous material per pad assembly, g"]
[null,null,null,null,null,null,null,null,null,null,"G = specific gravity of bituminous material at spray temperature"]