{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["WS3012"," Example","Header"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"WS3012","index":0,"n_rows":66,"n_cols":41,"rows_kept":66,"cut":false,"hidden":false,"merged":[[47,0,47,43],[33,0,33,1],[32,0,32,1],[33,30,33,31],[33,33,33,34],[33,19,33,20],[43,36,43,38],[37,40,37,42],[41,36,41,38],[38,40,38,42],[39,40,39,42],[34,36,34,42],[35,36,35,38],[35,40,35,42],[34,30,34,34],[35,30,35,34],[42,36,42,38],[36,36,36,38],[36,40,36,42],[37,36,37,38],[38,36,38,38],[37,13,37,14],[4,32,4,43],[5,32,5,43],[5,3,5,28],[33,2,33,6],[33,13,33,17],[33,24,33,28],[5,0,5,2],[33,22,33,23],[33,11,33,12],[33,8,33,9],[26,29,26,32],[26,34,26,37],[26,39,26,42],[26,8,26,11],[26,13,26,16],[26,18,26,21],[26,24,26,27],[24,39,24,42],[25,8,25,11],[25,13,25,16],[25,18,25,21],[25,24,25,27],[25,29,25,32],[25,34,25,37],[2,3,2,13],[2,14,2,16],[3,14,3,16],[2,29,2,31],[3,29,3,31],[2,32,2,43],[3,32,3,43],[43,40,43,42],[3,0,3,2],[2,0,2,2],[4,0,4,2],[4,3,4,28],[4,29,4,31],[5,29,5,31],[3,3,3,13],[2,17,2,28],[3,17,3,28],[39,36,39,38],[40,36,40,38],[42,40,42,42],[33,36,33,38],[33,40,33,42],[40,40,40,42],[41,40,41,42],[43,27,43,28],[43,30,43,31],[43,33,43,34],[37,24,37,28],[35,19,35,23],[36,19,36,23],[38,30,38,34],[42,33,42,34],[42,16,42,17],[42,19,42,20],[42,22,42,23],[42,24,42,25],[42,27,42,28],[42,30,42,31],[41,22,41,23],[41,24,41,25],[41,27,41,28],[41,30,41,31],[43,2,43,3],[43,5,43,6],[43,8,43,9],[43,11,43,12],[43,13,43,14],[43,16,43,17],[43,19,43,20],[43,22,43,23],[43,24,43,25],[41,33,41,34],[42,2,42,3],[42,5,42,6],[42,8,42,9],[42,11,42,12],[42,13,42,14],[40,27,40,28],[40,30,40,31],[40,33,40,34],[41,2,41,3],[41,5,41,6],[41,8,41,9],[41,11,41,12],[41,13,41,14],[41,16,41,17],[41,19,41,20],[38,22,38,23],[39,2,39,3],[39,5,39,6],[39,8,39,9],[39,11,39,12],[39,13,39,14],[39,33,39,34],[40,2,40,3],[40,5,40,6],[40,8,40,9],[40,11,40,12],[40,13,40,14],[40,16,40,17],[40,19,40,20],[40,22,40,23],[40,24,40,25],[39,16,39,17],[39,19,39,20],[39,22,39,23],[39,24,39,25],[39,27,39,28],[39,30,39,31],[38,2,38,3],[38,5,38,6],[38,8,38,9],[38,11,38,12],[34,24,34,28],[36,2,36,3],[36,5,36,6],[36,8,36,9],[36,11,36,12],[36,13,36,17],[35,24,35,28],[36,24,36,28],[34,13,34,17],[35,11,35,12],[34,8,34,12],[34,19,34,23],[34,2,34,6],[35,2,35,3],[35,5,35,6],[35,8,35,9],[38,24,38,28],[38,13,38,14],[38,16,38,17],[38,19,38,20],[23,8,23,11],[23,13,23,16],[23,18,23,21],[23,24,23,27],[23,29,23,32],[23,34,23,37],[23,39,23,42],[37,2,37,3],[37,5,37,6],[37,8,37,9],[37,11,37,12],[37,16,37,17],[37,19,37,20],[37,22,37,23],[35,13,35,17],[36,30,36,34],[37,30,37,34],[24,8,24,11],[24,13,24,16],[22,34,22,37],[22,18,22,21],[22,24,22,27],[20,39,20,42],[21,29,21,32],[21,34,21,37],[21,39,21,42],[25,39,25,42],[24,18,24,21],[24,24,24,27],[24,29,24,32],[24,34,24,37],[22,39,22,42],[19,8,19,11],[19,13,19,16],[19,18,19,21],[19,24,19,27],[19,29,19,32],[19,34,19,37],[19,39,19,42],[20,29,20,32],[20,34,20,37],[20,18,20,21],[20,24,20,27],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[16,18,16,21],[16,24,16,27],[15,8,15,11],[15,13,15,16],[15,18,15,21],[15,24,15,27],[34,0,34,1],[35,0,35,1],[36,0,36,1],[17,18,17,21],[17,24,17,27],[18,8,18,11],[18,13,18,16],[18,18,18,21],[18,24,18,27],[20,8,20,11],[20,13,20,16],[21,8,21,11],[21,13,21,16],[21,18,21,21],[12,0,13,22],[14,8,14,11],[14,13,14,16],[14,18,14,21],[14,24,14,27],[48,35,48,38],[14,29,14,32],[14,34,14,37],[14,39,14,42],[15,29,15,32],[15,34,15,37],[16,29,16,32],[16,34,16,37],[15,39,15,42],[16,39,16,42],[37,0,37,1],[16,8,16,11],[16,13,16,16],[17,8,17,11],[17,13,17,16],[22,8,22,11],[22,13,22,16],[42,0,42,1],[43,0,43,1],[50,8,50,11],[50,13,50,16],[50,18,50,21],[50,24,50,27],[48,40,48,43],[49,24,49,27],[49,30,49,33],[49,35,49,38],[49,40,49,43],[48,8,48,21],[48,24,48,27],[48,30,48,33],[50,40,50,43],[53,40,53,43],[52,8,52,11],[52,13,52,16],[51,8,51,11],[51,13,51,16],[51,18,51,21],[51,24,51,27],[51,30,51,33],[51,35,51,38],[51,40,51,43],[57,40,57,43],[56,8,56,11],[56,13,56,16],[54,18,54,21],[54,24,54,27],[52,30,52,33],[52,35,52,38],[52,18,52,21],[52,24,52,27],[54,40,54,43],[55,8,55,11],[55,13,55,16],[55,18,55,21],[55,24,55,27],[55,30,55,33],[55,35,55,38],[55,40,55,43],[54,8,54,11],[54,13,54,16],[52,40,52,43],[53,8,53,11],[53,13,53,16],[53,18,53,21],[53,24,53,27],[60,8,60,11],[60,13,60,16],[58,18,58,21],[58,24,58,27],[56,30,56,33],[56,35,56,38],[56,18,56,21],[56,24,56,27],[58,40,58,43],[59,8,59,11],[59,13,59,16],[59,18,59,21],[59,24,59,27],[59,30,59,33],[59,35,59,38],[59,40,59,43],[58,8,58,11],[58,13,58,16],[56,40,56,43],[57,8,57,11],[57,13,57,16],[57,18,57,21],[57,24,57,27],[57,30,57,33],[62,18,62,21],[62,24,62,27],[60,30,60,33],[60,35,60,38],[60,18,60,21],[60,24,60,27],[62,40,62,43],[63,8,63,11],[63,13,63,16],[63,18,63,21],[63,24,63,27],[63,30,63,33],[63,35,63,38],[63,40,63,43],[62,8,62,11],[62,13,62,16],[60,40,60,43],[61,8,61,11],[61,13,61,16],[61,18,61,21],[61,24,61,27],[61,30,61,33],[61,35,61,38],[61,40,61,43],[8,24,8,27],[10,30,10,32],[62,30,62,33],[62,35,62,38],[58,30,58,33],[58,35,58,38],[54,30,54,33],[54,35,54,38],[50,30,50,33],[50,35,50,38],[57,35,57,38],[53,30,53,33],[53,35,53,38],[9,24,9,27],[10,24,10,27],[12,24,13,42],[17,29,17,32],[17,34,17,37],[17,39,17,42],[18,29,18,32],[21,24,21,27],[18,34,18,37],[18,39,18,42],[22,29,22,32]]}
["COMBINED CONCRETE AGGREGATE GRADATION"]
["PROJECT DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAMPLE INFORMATION"]
["Project ID.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sampled By:"]
["Highway",null,null,null,null,null,null,null,null,null,null,null,null,null,"County",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
["Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time:"]
["Contractor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample No."]
[]
[null,null,"Determination of Combined Aggregate Gradation (% Passing)"]
[null,null,"Aggregate Batched Proportions:",null,null,null,null,null,null,null,null,null,null,"Course Aggregate #2 (C.A. #2) ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Course Aggregate #1 (C.A. #1) ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fine Aggregate (F.A.) = ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y9+Y10+Y11","v":0}]
[]
["Plant Site Aggregate Samples (% Passing)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculate Combined Gradation (% Passing)"]
[]
[null,"Size",null,null,null,null,null,null,"C.A. #2",null,null,null,null,"C.A. #1",null,null,null,null,"F.A.",null,null,null,null,null,"C.A. #2",null,null,null,null,"C.A. #1",null,null,null,null,"F.A.",null,null,null,null,"Combined"]
[null,"2\" (50 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(I16*$Y$9)","v":0},null,null,null,null,{"$f":"(N16*$Y$10)","v":0},null,null,null,null,{"$f":"(S16*$Y$11)","v":0},null,null,null,null,{"$f":"(Y16+AD16+AI16)","v":0}]
[null,"1 1/2\" (37.5 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"1\" (25 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"3/4\" (19 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"3/8\" (9.5 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"#4 (4.75 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"#8 (2.36 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"#16 (1.16 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"#30 (0.6 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"#50 (0.3 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"#100 (0.15 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"#200 (0.075 mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[]
[]
["Determination of Specification Limits for Combined Aggregate Gradation (% Passing)"]
[]
[null,null,"C.A. #2",null,null,null,null,null,null,null,null,null,null,"C.A. #1",null,null,null,null,null,null,null,null,null,null,"F.A.",null,null,null,null,null,null,null,null,null,null,null,"Combined"]
["Sieve"]
["Size",null,"Spec.",null,null,null,null,null,"LCL",null,null,"UCL",null,"Spec.",null,null,null,null,null,"LCL",null,null,"UCL",null,"Spec.",null,null,null,null,null,"LCL",null,null,"UCL",null,null,"LCL",null,null,null,"UCL"]
["2\"",null,100,null,null,null,null,null,{"$f":"($Y$9*C35)","v":0},null,null,null,null,100,null,null,null,null,null,{"$f":"($Y$10*N35)","v":0},null,null,null,null,100,null,null,null,null,null,{"$f":"($Y$11*Y35)","v":0},null,null,null,null,null,{"$f":"(I35+T35+AE35)","v":0}]
["1 1/2\"",null,90,null,"-",100,null,null,0,null,null,{"$f":"($Y$9*F36)","v":0},null,100,null,null,null,null,null,0,null,null,null,null,100,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,{"$f":"(L36+T36+AE36)","v":0}]
["1\"",null,20,null,"-",55,null,null,0,null,null,0,null,100,null,null,null,null,null,0,null,null,null,null,100,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,{"$f":"(L37+T37+AE37)","v":0}]
["3/4\"",null,0,null,"-",15,null,null,0,null,null,0,null,90,null,"-",100,null,null,0,null,null,{"$f":"($Y$10*Q38)","v":0},null,100,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,{"$f":"(L38+W38+AE38)","v":0}]
["3/8\"",null,0,null,"-",5,null,null,0,null,null,0,null,20,null,"-",55,null,null,0,null,null,0,null,100,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,{"$f":"(L39+W39+AE39)","v":0}]
["#4",null,0,null,"-",5,null,null,0,null,null,0,null,0,null,"-",10,null,null,0,null,null,0,null,90,null,"-",100,null,null,0,null,null,{"$f":"($Y$11*AB40)","v":0},null,null,0,null,null,null,{"$f":"(L40+W40+AH40)","v":0}]
["#16",null,0,null,"-",5,null,null,0,null,null,0,null,0,null,"-",5,null,null,0,null,null,0,null,45,null,"-",80,null,null,0,null,null,{"$f":"($Y$11*AB41)","v":0},null,null,0,null,null,null,{"$f":"(L41+W41+AH41)","v":0}]
["#50",null,0,null,"-",5,null,null,0,null,null,0,null,0,null,"-",5,null,null,0,null,null,0,null,10,null,"-",30,null,null,0,null,null,{"$f":"($Y$11*AB42)","v":0},null,null,0,null,null,null,{"$f":"(L42+W42+AH42)","v":0}]
["#100",null,0,null,"-",5,null,null,0,null,null,0,null,0,null,"-",5,null,null,0,null,null,0,null,2,null,"-",10,null,null,0,null,null,{"$f":"($Y$11*AB43)","v":0},null,null,0,null,null,null,{"$f":"(L43+W43+AH43)","v":0}]
["#200",null,0,null,"-",1.5,null,null,0,null,null,0,null,0,null,"-",1.5,null,null,0,null,null,0,null,0,null,"-",3.5,null,null,0,null,null,{"$f":"($Y$11*AB44)","v":0},null,null,0,null,null,null,{"$f":"(L44+W44+AH44)","v":0}]
[]
[null,"LCL = Lower Control Limit"]
[null,"UCL = Upper Control Limit"]
["SUMMARY OF COMBINED AGGREGATE GRADATION SPECIFICATION LIMITS"]
[null,null,null,null,null,null,null,null,"PERCENT PASSING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combined",null,null,null,null,null,"Combined",null,null,null,null,"Concrete",null,null,null,null,"Concrete"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gradation",null,null,null,null,null,"Gradation",null,null,null,null,"Pavement",null,null,null,null,"Structure"]
[null,"Sieve",null,null,null,null,null,null,"Combined",null,null,null,null,"Combined",null,null,null,null,"Combined",null,null,null,null,null,"% Retained",null,null,null,null,null,"% Between",null,null,null,null,"QMP Spec",null,null,null,null,"QMP Spec"]
[null,"Size",null,null,null,null,null,null,"LCL",null,null,null,null,"Gradation",null,null,null,null,"UCL",null,null,null,null,null,"On Sieve",null,null,null,null,null,"Sieves",null,null,null,null,"% Passing",null,null,null,null,"% Passing"]
[null,"2\" (50 mm)",null,null,null,null,null,null,{"$f":"AK35","v":0},null,null,null,null,{"$f":"AN16","v":0},null,null,null,null,{"$f":"AK35","v":0},null,null,null,null,null,{"$f":"1-N53","v":1},null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,1]
[null,"1 1/2\" (37.5 mm)",null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,{"$f":"AO36","v":0},null,null,null,null,null,1,null,null,null,null,null,{"$f":"N53-N54","v":0}]
[null,"1\" (25 mm)",null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,{"$f":"AO37","v":0},null,null,null,null,null,1,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"< or = 89%"]
[null,"3/4\" (19 mm)",null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,{"$f":"AO38","v":0},null,null,null,null,null,1,null,null,null,null,null,0]
[null,"3/8\" (9.5 mm)",null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,{"$f":"AO38","v":0},null,null,null,null,null,1,null,null,null,null,null,0]
[null,"#4 (4.75 mm)",null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,{"$f":"AO40","v":0},null,null,null,null,null,1,null,null,null,null,null,0,null,null,null,null,"< or = 42%*",null,null,null,null,"< or = 42%**"]
[null,"#8 (2.36 mm)",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,0]
[null,"#16 (1.16 mm)",null,null,null,null,null,null,{"$f":"AK41","v":0},null,null,null,null,0,null,null,null,null,{"$f":"AO41","v":0},null,null,null,null,null,1,null,null,null,null,null,0]
[null,"#30 (0.6 mm)",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,0]
[null,"#50 (0.3 mm)",null,null,null,null,null,null,{"$f":"AK42","v":0},null,null,null,null,0,null,null,null,null,{"$f":"AO42","v":0},null,null,null,null,null,1,null,null,null,null,null,0]
[null,"#100 (0.15 mm)",null,null,null,null,null,null,{"$f":"AK43","v":0},null,null,null,null,0,null,null,null,null,{"$f":"AO43","v":0},null,null,null,null,null,1,null,null,null,null,null,0]
[null,"#200 (0.075 mm)",null,null,null,null,null,null,{"$f":"AK44","v":0},null,null,null,null,0,null,null,null,null,{"$f":"AO44","v":0},null,null,null,null,null,1,null,null,null,null,null,0,null,null,null,null,"< or = 2.3%",null,null,null,null,"< or = 2.3%"]
["* 47 % if coarse material is composed completely of crushed stone or recycled concrete.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCL = Lower Control Limit"]
["** 47 % if coarse material is composed completely of crushed stone.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UCL = Upper Control Limit"]

{"sheet":" Example","index":1,"n_rows":66,"n_cols":41,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,43],[47,0,47,43],[32,0,32,1],[33,0,33,1],[25,29,25,32],[25,34,25,37],[25,39,25,42],[26,8,26,11],[33,36,33,38],[33,40,33,42],[33,30,33,31],[33,33,33,34],[5,0,5,2],[5,3,5,28],[5,29,5,31],[5,32,5,43],[26,34,26,37],[26,39,26,42],[25,8,25,11],[25,13,25,16],[4,0,4,2],[4,3,4,28],[4,29,4,31],[25,24,25,27],[4,32,4,43],[2,29,2,31],[2,32,2,43],[3,0,3,2],[3,3,3,13],[3,14,3,16],[3,17,3,28],[3,29,3,31],[3,32,3,43],[2,0,2,2],[42,33,42,34],[42,24,42,25],[42,27,42,28],[42,30,42,31],[41,36,41,38],[41,40,41,42],[41,19,41,20],[41,22,41,23],[23,29,23,32],[24,18,24,21],[24,24,24,27],[24,39,24,42],[23,18,23,21],[23,24,23,27],[23,34,23,37],[23,39,23,42],[2,3,2,13],[2,14,2,16],[2,17,2,28],[43,30,43,31],[41,30,41,31],[43,11,43,12],[43,13,43,14],[43,16,43,17],[43,24,43,25],[43,27,43,28],[42,22,42,23],[24,8,24,11],[24,13,24,16],[23,8,23,11],[23,13,23,16],[22,8,22,11],[43,0,43,1],[43,2,43,3],[43,5,43,6],[43,8,43,9],[43,19,43,20],[43,22,43,23],[42,16,42,17],[42,19,42,20],[42,0,42,1],[42,2,42,3],[42,5,42,6],[42,8,42,9],[42,11,42,12],[42,13,42,14],[41,24,41,25],[41,27,41,28],[41,33,41,34],[40,33,40,34],[40,36,40,38],[40,40,40,42],[41,0,41,1],[41,2,41,3],[41,5,41,6],[41,8,41,9],[41,11,41,12],[41,13,41,14],[41,16,41,17],[40,16,40,17],[40,19,40,20],[40,22,40,23],[40,24,40,25],[40,27,40,28],[40,30,40,31],[40,0,40,1],[40,2,40,3],[40,5,40,6],[40,8,40,9],[40,11,40,12],[40,13,40,14],[39,13,39,14],[39,16,39,17],[39,19,39,20],[38,22,38,23],[38,24,38,28],[38,30,38,34],[38,36,38,38],[38,40,38,42],[39,0,39,1],[39,2,39,3],[39,5,39,6],[39,8,39,9],[39,11,39,12],[39,30,39,31],[39,33,39,34],[39,36,39,38],[39,40,39,42],[39,22,39,23],[39,24,39,25],[39,27,39,28],[38,0,38,1],[38,2,38,3],[38,5,38,6],[38,8,38,9],[38,11,38,12],[38,13,38,14],[38,16,38,17],[38,19,38,20],[37,13,37,14],[37,16,37,17],[37,19,37,20],[36,19,36,23],[36,24,36,28],[36,30,36,34],[36,36,36,38],[36,40,36,42],[37,0,37,1],[37,2,37,3],[37,5,37,6],[37,8,37,9],[37,11,37,12],[36,0,36,1],[36,2,36,3],[36,5,36,6],[36,8,36,9],[36,11,36,12],[36,13,36,17],[37,36,37,38],[37,40,37,42],[37,22,37,23],[37,24,37,28],[37,30,37,34],[35,13,35,17],[35,19,35,23],[35,24,35,28],[35,30,35,34],[35,36,35,38],[35,40,35,42],[34,0,34,1],[34,2,34,6],[34,8,34,12],[34,13,34,17],[34,36,34,42],[35,0,35,1],[35,2,35,3],[35,5,35,6],[35,8,35,9],[35,11,35,12],[34,19,34,23],[34,24,34,28],[34,30,34,34],[33,2,33,6],[33,13,33,17],[33,24,33,28],[33,8,33,9],[33,11,33,12],[33,19,33,20],[33,22,33,23],[24,29,24,32],[24,34,24,37],[26,13,26,16],[26,18,26,21],[26,24,26,27],[26,29,26,32],[25,18,25,21],[22,13,22,16],[22,18,22,21],[22,24,22,27],[22,29,22,32],[22,34,22,37],[22,39,22,42],[21,8,21,11],[21,13,21,16],[21,18,21,21],[21,24,21,27],[21,29,21,32],[21,34,21,37],[21,39,21,42],[18,8,18,11],[18,13,18,16],[18,18,18,21],[18,24,18,27],[18,29,18,32],[18,34,18,37],[18,39,18,42],[19,39,19,42],[20,8,20,11],[20,13,20,16],[20,18,20,21],[20,24,20,27],[20,29,20,32],[20,34,20,37],[20,39,20,42],[19,8,19,11],[19,13,19,16],[19,18,19,21],[19,24,19,27],[19,29,19,32],[19,34,19,37],[8,24,8,27],[12,0,13,22],[12,24,13,42],[10,24,10,27],[10,30,10,32],[60,8,60,11],[61,8,61,11],[54,8,54,11],[55,8,55,11],[56,8,56,11],[57,8,57,11],[57,13,57,16],[58,13,58,16],[52,8,52,11],[53,8,53,11],[58,8,58,11],[59,8,59,11],[61,13,61,16],[48,24,48,27],[49,24,49,27],[50,24,50,27],[53,24,53,27],[54,24,54,27],[16,8,16,11],[63,8,63,11],[51,13,51,16],[52,13,52,16],[53,13,53,16],[54,13,54,16],[55,13,55,16],[56,13,56,16],[51,8,51,11],[9,24,9,27],[16,13,16,16],[16,18,16,21],[16,24,16,27],[17,8,17,11],[17,13,17,16],[17,18,17,21],[17,24,17,27],[14,8,14,11],[14,13,14,16],[14,18,14,21],[14,24,14,27],[15,8,15,11],[15,13,15,16],[15,18,15,21],[15,24,15,27],[63,18,63,21],[63,13,63,16],[51,18,51,21],[52,18,52,21],[53,18,53,21],[54,18,54,21],[55,18,55,21],[56,18,56,21],[57,18,57,21],[60,18,60,21],[61,18,61,21],[58,18,58,21],[59,18,59,21],[59,13,59,16],[60,13,60,16],[62,13,62,16],[55,24,55,27],[56,24,56,27],[48,8,48,21],[50,13,50,16],[51,24,51,27],[52,24,52,27],[50,8,50,11],[50,18,50,21],[62,24,62,27],[62,18,62,21],[62,8,62,11],[63,24,63,27],[57,24,57,27],[58,24,58,27],[59,24,59,27],[60,24,60,27],[58,35,58,38],[58,30,58,33],[59,30,59,33],[60,30,60,33],[61,30,61,33],[61,24,61,27],[62,35,62,38],[62,30,62,33],[63,30,63,33],[63,40,63,43],[63,35,63,38],[51,40,51,43],[52,40,52,43],[53,40,53,43],[54,40,54,43],[55,40,55,43],[56,40,56,43],[57,40,57,43],[58,40,58,43],[51,30,51,33],[50,30,50,33],[50,35,50,38],[60,40,60,43],[61,40,61,43],[62,40,62,43],[59,40,59,43],[59,35,59,38],[60,35,60,38],[61,35,61,38],[57,30,57,33],[56,30,56,33],[55,30,55,33],[54,30,54,33],[53,30,53,33],[52,30,52,33],[51,35,51,38],[52,35,52,38],[53,35,53,38],[54,35,54,38],[55,35,55,38],[56,35,56,38],[57,35,57,38],[49,40,49,43],[48,30,48,33],[49,30,49,33],[48,35,48,38],[49,35,49,38],[50,40,50,43],[14,29,14,32],[14,34,14,37],[14,39,14,42],[48,40,48,43],[15,29,15,32],[15,34,15,37],[15,39,15,42],[16,29,16,32],[16,34,16,37],[16,39,16,42],[17,29,17,32],[17,34,17,37],[17,39,17,42],[43,36,43,38],[43,40,43,42],[42,36,42,38],[42,40,42,42],[43,33,43,34]]}
["COMBINED CONCRETE AGGREGATE GRADATION"]
["PROJECT DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAMPLE INFORMATION"]
["Project ID.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sampled By:"]
["Highway",null,null,null,null,null,null,null,null,null,null,null,null,null,"County",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
["Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time:"]
["Contractor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample No."]
[]
[null,null,"Determination of Combined Aggregate Gradation (% Passing)"]
[null,null,"Aggregate Batched Proportions:",null,null,null,null,null,null,null,null,null,null,"Course Aggregate #2 (C.A. #2) =",null,null,null,null,null,null,null,null,null,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Course Aggregate #1 (C.A. #1) =",null,null,null,null,null,null,null,null,null,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fine Aggregate (F.A.) = ",null,null,null,null,null,null,null,null,null,null,0.4,null,null,null,null,null,{"$f":"Y9+Y10+Y11","v":1}]
[]
["Plant Site Aggregate Samples (% Passing)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculate Combined Gradation (% Passing)"]
[]
[null,"Size",null,null,null,null,null,null,"C.A. #2",null,null,null,null,"C.A. #1",null,null,null,null,"F.A.",null,null,null,null,null,"C.A. #2",null,null,null,null,"C.A. #1",null,null,null,null,"F.A.",null,null,null,null,"Combined"]
[null,"2\" (50 mm)",null,null,null,null,null,null,1,null,null,null,null,1,null,null,null,null,1,null,null,null,null,null,{"$f":"(I16*$Y$9)","v":0.3},null,null,null,null,{"$f":"(N16*$Y$10)","v":0.3},null,null,null,null,{"$f":"(S16*$Y$11)","v":0.4},null,null,null,null,{"$f":"(Y16+AD16+AI16)","v":1}]
[null,"1 1/2\" (37.5 mm)",null,null,null,null,null,null,0.95,null,null,null,null,1,null,null,null,null,1,null,null,null,null,null,0.28499999999999998,null,null,null,null,0.3,null,null,null,null,0.4,null,null,null,null,0.98499999999999999]
[null,"1\" (25 mm)",null,null,null,null,null,null,0.32,null,null,null,null,1,null,null,null,null,1,null,null,null,null,null,9.6000000000000002E-2,null,null,null,null,0.3,null,null,null,null,0.4,null,null,null,null,0.79600000000000004]
[null,"3/4\" (19 mm)",null,null,null,null,null,null,0.12,null,null,null,null,0.97,null,null,null,null,1,null,null,null,null,null,3.5999999999999997E-2,null,null,null,null,0.29099999999999998,null,null,null,null,0.4,null,null,null,null,0.72699999999999998]
[null,"3/8\" (9.5 mm)",null,null,null,null,null,null,0.03,null,null,null,null,0.27,null,null,null,null,1,null,null,null,null,null,8.9999999999999993E-3,null,null,null,null,8.1000000000000003E-2,null,null,null,null,0.4,null,null,null,null,0.49]
[null,"#4 (4.75 mm)",null,null,null,null,null,null,0.03,null,null,null,null,0.06,null,null,null,null,0.96,null,null,null,null,null,8.9999999999999993E-3,null,null,null,null,1.7999999999999999E-2,null,null,null,null,0.38400000000000001,null,null,null,null,0.41100000000000003]
[null,"#8 (2.36 mm)",null,null,null,null,null,null,0.02,null,null,null,null,0.02,null,null,null,null,0.87,null,null,null,null,null,6.0000000000000001E-3,null,null,null,null,6.0000000000000001E-3,null,null,null,null,0.34800000000000003,null,null,null,null,0.36000000000000004]
[null,"#16 (1.16 mm)",null,null,null,null,null,null,0.02,null,null,null,null,0.01,null,null,null,null,0.73,null,null,null,null,null,6.0000000000000001E-3,null,null,null,null,3.0000000000000001E-3,null,null,null,null,0.29199999999999998,null,null,null,null,0.30099999999999999]
[null,"#30 (0.6 mm)",null,null,null,null,null,null,0.02,null,null,null,null,0.01,null,null,null,null,0.42,null,null,null,null,null,6.0000000000000001E-3,null,null,null,null,3.0000000000000001E-3,null,null,null,null,0.16800000000000001,null,null,null,null,0.17700000000000002]
[null,"#50 (0.3 mm)",null,null,null,null,null,null,0.02,null,null,null,null,0.01,null,null,null,null,0.16,null,null,null,null,null,6.0000000000000001E-3,null,null,null,null,3.0000000000000001E-3,null,null,null,null,6.4000000000000001E-2,null,null,null,null,7.3000000000000009E-2]
[null,"#100 (0.15 mm)",null,null,null,null,null,null,0.02,null,null,null,null,0.01,null,null,null,null,0.04,null,null,null,null,null,6.0000000000000001E-3,null,null,null,null,3.0000000000000001E-3,null,null,null,null,1.6E-2,null,null,null,null,2.5000000000000001E-2]
[null,"#200 (0.075 mm)",null,null,null,null,null,null,1.4999999999999999E-2,null,null,null,null,0.01,null,null,null,null,0.03,null,null,null,null,null,4.4999999999999997E-3,null,null,null,null,3.0000000000000001E-3,null,null,null,null,1.2E-2,null,null,null,null,1.95E-2]
[]
[]
["Determination of Specification Limits for Combined Aggregate Gradation (% Passing)"]
[]
[null,null,"C.A. #2",null,null,null,null,null,null,null,null,null,null,"C.A. #1",null,null,null,null,null,null,null,null,null,null,"F.A.",null,null,null,null,null,null,null,null,null,null,null,"Combined"]
["Sieve"]
["Size",null,"Spec.",null,null,null,null,null,"LCL",null,null,"UCL",null,"Spec.",null,null,null,null,null,"LCL",null,null,"UCL",null,"Spec.",null,null,null,null,null,"LCL",null,null,"UCL",null,null,"LCL",null,null,null,"UCL"]
["2\"",null,100,null,null,null,null,null,{"$f":"($Y$9*C35)","v":30},null,null,null,null,100,null,null,null,null,null,{"$f":"($Y$10*N35)","v":30},null,null,null,null,100,null,null,null,null,null,{"$f":"($Y$11*Y35)","v":40},null,null,null,null,null,{"$f":"(I35+T35+AE35)","v":100}]
["1 1/2\"",null,90,null,"-",100,null,null,27,null,null,{"$f":"($Y$9*F36)","v":30},null,100,null,null,null,null,null,30,null,null,null,null,100,null,null,null,null,null,40,null,null,null,null,null,97,null,null,null,{"$f":"(L36+T36+AE36)","v":100}]
["1\"",null,20,null,"-",55,null,null,6,null,null,16.5,null,100,null,null,null,null,null,30,null,null,null,null,100,null,null,null,null,null,40,null,null,null,null,null,76,null,null,null,{"$f":"(L37+T37+AE37)","v":86.5}]
["3/4\"",null,0,null,"-",15,null,null,0,null,null,4.5,null,90,null,"-",100,null,null,27,null,null,{"$f":"($Y$10*Q38)","v":30},null,100,null,null,null,null,null,40,null,null,null,null,null,67,null,null,null,{"$f":"(L38+W38+AE38)","v":74.5}]
["3/8\"",null,0,null,"-",5,null,null,0,null,null,1.5,null,20,null,"-",55,null,null,6,null,null,16.5,null,100,null,null,null,null,null,40,null,null,null,null,null,46,null,null,null,{"$f":"(L39+W39+AE39)","v":58}]
["#4",null,0,null,"-",5,null,null,0,null,null,1.5,null,0,null,"-",10,null,null,0,null,null,3,null,90,null,"-",100,null,null,36,null,null,{"$f":"($Y$11*AB40)","v":40},null,null,36,null,null,null,{"$f":"(L40+W40+AH40)","v":44.5}]
["#16",null,0,null,"-",5,null,null,0,null,null,1.5,null,0,null,"-",5,null,null,0,null,null,1.5,null,45,null,"-",80,null,null,18,null,null,{"$f":"($Y$11*AB41)","v":32},null,null,18,null,null,null,{"$f":"(L41+W41+AH41)","v":35}]
["#50",null,0,null,"-",5,null,null,0,null,null,1.5,null,0,null,"-",5,null,null,0,null,null,1.5,null,10,null,"-",30,null,null,4,null,null,{"$f":"($Y$11*AB42)","v":12},null,null,4,null,null,null,{"$f":"(L42+W42+AH42)","v":15}]
["#100",null,0,null,"-",5,null,null,0,null,null,1.5,null,0,null,"-",5,null,null,0,null,null,1.5,null,2,null,"-",10,null,null,0.8,null,null,{"$f":"($Y$11*AB43)","v":4},null,null,0.8,null,null,null,{"$f":"(L43+W43+AH43)","v":7}]
["#200",null,0,null,"-",1.5,null,null,0,null,null,0.44999999999999996,null,0,null,"-",1.5,null,null,0,null,null,0.44999999999999996,null,0,null,"-",3.5,null,null,0,null,null,{"$f":"($Y$11*AB44)","v":1.4000000000000001},null,null,0,null,null,null,{"$f":"(L44+W44+AH44)","v":2.2999999999999998}]
[]
[null,"LCL = Lower Control Limit"]
[null,"UCL = Upper Control Limit"]
["SUMMARY OF COMBINED AGGREGATE GRADATION SPECIFICATION LIMITS"]
[null,null,null,null,null,null,null,null,"PERCENT PASSING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combined",null,null,null,null,null,"Combined",null,null,null,null,"Concrete",null,null,null,null,"Concrete"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gradation",null,null,null,null,null,"Gradation",null,null,null,null,"Pavement",null,null,null,null,"Structure"]
[null,"Sieve",null,null,null,null,null,null,"Combined",null,null,null,null,"Combined",null,null,null,null,"Combined",null,null,null,null,null,"% Retained",null,null,null,null,null,"% Between",null,null,null,null,"QMP Spec",null,null,null,null,"QMP Spec"]
[null,"Size",null,null,null,null,null,null,"LCL",null,null,null,null,"Gradation",null,null,null,null,"UCL",null,null,null,null,null,"On Sieve",null,null,null,null,null,"Sieves",null,null,null,null,"% Passing",null,null,null,null,"% Passing"]
[null,"2\" (50 mm)",null,null,null,null,null,null,{"$f":"AK35","v":100},null,null,null,null,{"$f":"AN16","v":1},null,null,null,null,{"$f":"AK35","v":100},null,null,null,null,null,{"$f":"1-N53","v":0},null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,1]
[null,"1 1/2\" (37.5 mm)",null,null,null,null,null,null,97,null,null,null,null,0.98499999999999999,null,null,null,null,{"$f":"AO36","v":100},null,null,null,null,null,1.5000000000000013E-2,null,null,null,null,null,{"$f":"N53-N54","v":1.5000000000000013E-2}]
[null,"1\" (25 mm)",null,null,null,null,null,null,76,null,null,null,null,0.79600000000000004,null,null,null,null,{"$f":"AO37","v":86.5},null,null,null,null,null,0.20399999999999996,null,null,null,null,null,0.18899999999999995,null,null,null,null,null,null,null,null,null,"< or = 89%"]
[null,"3/4\" (19 mm)",null,null,null,null,null,null,67,null,null,null,null,0.72699999999999998,null,null,null,null,{"$f":"AO38","v":74.5},null,null,null,null,null,0.27300000000000002,null,null,null,null,null,6.9000000000000061E-2]
[null,"3/8\" (9.5 mm)",null,null,null,null,null,null,46,null,null,null,null,0.49,null,null,null,null,{"$f":"AO38","v":74.5},null,null,null,null,null,0.51,null,null,null,null,null,0.23699999999999999]
[null,"#4 (4.75 mm)",null,null,null,null,null,null,36,null,null,null,null,0.41100000000000003,null,null,null,null,{"$f":"AO40","v":44.5},null,null,null,null,null,0.58899999999999997,null,null,null,null,null,7.8999999999999959E-2,null,null,null,null,"< or = 42%*",null,null,null,null,"< or = 42%**"]
[null,"#8 (2.36 mm)",null,null,null,null,null,null,null,null,null,null,null,0.36000000000000004,null,null,null,null,null,null,null,null,null,null,0.6399999999999999,null,null,null,null,null,5.099999999999999E-2]
[null,"#16 (1.16 mm)",null,null,null,null,null,null,{"$f":"AK41","v":18},null,null,null,null,0.30099999999999999,null,null,null,null,{"$f":"AO41","v":35},null,null,null,null,null,0.69900000000000007,null,null,null,null,null,5.9000000000000052E-2]
[null,"#30 (0.6 mm)",null,null,null,null,null,null,null,null,null,null,null,0.17700000000000002,null,null,null,null,null,null,null,null,null,null,0.82299999999999995,null,null,null,null,null,0.12399999999999997]
[null,"#50 (0.3 mm)",null,null,null,null,null,null,{"$f":"AK42","v":4},null,null,null,null,7.3000000000000009E-2,null,null,null,null,{"$f":"AO42","v":15},null,null,null,null,null,0.92700000000000005,null,null,null,null,null,0.10400000000000001]
[null,"#100 (0.15 mm)",null,null,null,null,null,null,{"$f":"AK43","v":0.8},null,null,null,null,2.5000000000000001E-2,null,null,null,null,{"$f":"AO43","v":7},null,null,null,null,null,0.97499999999999998,null,null,null,null,null,4.8000000000000008E-2]
[null,"#200 (0.075 mm)",null,null,null,null,null,null,{"$f":"AK44","v":0},null,null,null,null,1.95E-2,null,null,null,null,{"$f":"AO44","v":2.2999999999999998},null,null,null,null,null,0.98050000000000004,null,null,null,null,null,5.5000000000000014E-3,null,null,null,null,"< or = 2.3%",null,null,null,null,"< or = 2.3%"]
["* 47 % if coarse material is composed completely of crushed stone or recycled concrete.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCL = Lower Control Limit"]
["** 47 % if coarse material is composed completely of crushed stone.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UCL = Upper Control Limit"]

{"sheet":"Header","index":2,"n_rows":6,"n_cols":30,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["COMBINED CONCRETE AGGREGATE GRADATION"]
["PROJECT DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAMPLE INFORMATION"]
["Project ID.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sampled By:"]
["Highway",null,null,null,null,null,null,null,null,null,null,null,null,null,"County",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
["Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time:"]
["Contractor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample No."]