{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Aggregate Gradations","MixDesign","Advanced","Program v.3","Aggregates","Aggregates (Max-Min)","AEA","Admixtures","Cement","Calculations"],"not_rendered":{"charts":16,"images":46,"macros":1,"external_links":0,"defined_names":4911,"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":"Aggregate Gradations","index":0,"n_rows":112,"n_cols":90,"rows_kept":112,"cut":false,"hidden":true,"merged":[]}
[]
["Aggregate Type",null,"KDOT Kansas River Sand","KDOT Limestone","Midwest Concrete Sand","Midwest SA-1","Granite","LRM - Arch (from Midwest)","LRM - Pea G.","Midwest 3/4 x 3/8","Stone 1","Stone 2","Stone 3","Sand 1","Sand 2","KDOT Kansas River Sand 6/17/03","LRM Pea Gravel 6/17/03","1\" Washed Airport Limestone 10/2003","1 1/4\" Quartzite 10/2003","Quartzite Chip 10/2003","KDOT Kansas River Sand 12/12/03","? Saif 9/2/03","KDOT Kansas River 2-18-04","Pea Gravel 2-18-04","3/4\" KDOT Limestone 2-18-04","3/4\" KDOT Limestone 4/29/2004","1\" Washed Airport Limestone sieved","cement sand","3/4\" KDOT Limestone 6/18/2004","KDOT Kansas River Sand 6/18/04","Pea Gravel 6/18/04","#67 Quartzite 6/23/2004","Quartzite 1 1/4\" 6/24/2004","#67 Quartzite 6/28/2004","Kansas 3/4in. Granite 8/3/04","#57 Limestone HMM 9/7/2004","Martin Marietta Limestone 9/14/2004","#57 Granite 9/14/2004","#67 Quartzite 10/8/2004","3/4\" KDOT Limestone 10/8/2004","KDOT Sand 10/8/2004","ACI 211.1 Apx 1 Example CA","ACI 211.1 Apx 1 Example FA","ACI 211.1 Apx 1 Example Blending","Swapnil's next aggregate","3/4\" KDOT Limestone 01/10/2005","3/4\" Quartzite 01/10/2005","3/4\" Granite 01/10/2005","KDOT Sand 01/10/2005","LRM Pea Gravel 01/10/2005","A1 - Granite","A2 - River Sand","A3 - Pea Gravel","A4 - Small Deco","OK - CA #1","OK - IA #1","OK - FA","OK - IA #2","3/4\" Quartzite 03/19/05","3/4\" KDOT Limestone 03/19/05","OK - CA #2","GMQ 1.5 PCCP","GMQ CA7","GMQ 3MA (3/8\")","GMQ 3/4\"","MA-2 Holliday","KC 3/4\"","LRM Kansas River Sand 5-5-05","LRM 3/4\" Class 1 Limestone","LRM Kansas River Sand 6-6-05","LRM 3/4\" Class 1 Limestone 6-3-05","LRM Pea Gravel 6-14-05","LRM Kansas River Sand 6-23-05","LRM 3/4\" Class 1 Limestone","LRM 3/4\" Class 1 Limestone 7/14/05","LRM Pea Gravel 7/14/05","LRM 3/4\" Limestone >3/8\"","LRM 3/4\" Limestone <3/8\""]
["Data #",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76]
[]
["Specific Gravity",null,2.63,2.58,null,null,2.63,null,null,null,null,null,null,null,null,null,null,2.57,2.63,2.63,null,null,2.63,2.62,"?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2,2.5299999999999998,2.63,2.58,2.63,2.62]
["% Absorption",null,0.3,3,null,null,0.7,null,0.7,null,null,null,null,null,null,null,null,3.92,0.44,0.49,null,null,0.35,0.6,"?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01,2.85,0.5,0.7,0.35,0.6]
["% Fines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.27,0.6,0.6,null,null,1.46,0.55000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,1.46,0.55000000000000004]
["Cumulative Percent Retained"]
["1 1/2\"",null,0,0,0,0,0,0,0,0,0,6.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1\"",null,0,0,0,0,0,0,0,0,0,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.06,0,0,0,0,0,0,0,0,0.4,0,0,0,0,0,0,50,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,1.0999999999999943,14.1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["3/4\"",null,0,0,0,0,0,0,0,0,3.5,67,0,0,0,0,0,25.94,8.31,0,0,0,0,0,0,0,0,0,0.19,0,0,0.6361323155216374,4.3391188251001456,1.58,2.005174644243223,2.7,0,17.899999999999999,1.4,0,0,20.909627879503841,0,0,80,0,2,1.3,0,0,15,0,0,0,0.79999999999999716,0,0,0,0.2,0,14.8,43.5,0,0,{"$f":"100-95","v":5},0,4,0,0,0,0,0,0,0,0.06,0,0.12345679012345678,0]
["1/2\"",null,0,27.9,0,0,38.4,7.9,0,23,39.9,84,28,0,0,0,0,97.66,55.24,0.27,0,13.99,0,0,23.04,19,96.945701357466049,0,11.47,0,0,22.201017811704844,48.531375166889184,27.44,20.181112548512292,30.5,18.440000000000001,53.84,29.7,17.5,0,65.682220909627887,0,0,90,18.899999999999999,33.1,21.7,0,0,{"$f":"40.2+AY11","v":55.2},0,0,7.9,26.4,0,0,0,10.1,22.6,70.7,73.900000000000006,6.5,0,{"$f":"100-56","v":44},0,40,0,17.13,0,25.3,0,0,25,21.8,0,44.855967078189302,0]
["3/8\"",null,0,56.1,0,0,66.599999999999994,39.700000000000003,0,54,65.8,93,47,0,5,0,0,99.12,78.239999999999995,17.77,0,37.01,0,0,49.5,45.7,98.925339366515828,0,30.13,0,0,57.061068702290079,75.300400534045394,55.84,50.970245795601571,56.1,41.94,75.239999999999995,65.8,43.3,0,88.068517424689901,0,16.399999999999999,95,44.4,67.5,51.7,0,0,{"$f":"AY12+23","v":78.2},0,0,{"$f":"31.8+BB12","v":39.700000000000003},68.900000000000006,1.9000000000000057,0,0,32.700000000000003,48.7,86.3,84.1,44.5,5,{"$f":"100-23","v":77},0,{"$f":"100-28","v":72},0,42.34,0,55.1,0,0,54.5,45.9,0,94.444444444444443,0]
["#4",null,1.2,94,5,21,96.8,92.4,10.9,98,93.3,97,85,0,13,0.6,11.8,99.29,95.8,93.77,1.2,87.74,1.4,10.3,91.6,89.6,99.151583710407238,0,78.849999999999994,1.6,12.47,95.419847328244288,97.797062750333779,92.63,95.342820181112558,92.2,86.61,96.37,98.1,88.9,1.4,100,1.0479041916167664,45.6,96,90.8,98.9,97.2,2,9.6,{"$f":"AY13+17.6","v":95.800000000000011},2,9.6,{"$f":"52.7+BB13","v":92.4},97.1,89.4,4,53.8,93.5,90.4,99,98.2,96.7,95.37,{"$f":"100-2","v":98},0,98,0,88.3,1.3,93.3,10.1,0.9,89.7,86.9,9.5,94.444444444444443,80.234833659491201,null,null,null,null,null,null,null,null,"sum",900,{"$f":"CJ14/SUM($CJ$14:$CJ$17)","v":0.30272452068617556},30]
["#8",null,12.4,98,22,65,99.1,97.6,48.1,99,99,98,93,6,45,10.4,52.8,99.33,98.05,99.31,13.8,96.49,14.5,51.3,97.74,97.3,99.208144796380083,0,93.91,14.32,52.98,97.32824427480918,99.265687583444603,96.09,97.02457956015526,97.3,97.81,97.72,99.7,97.2,14.2,100,12.425149700598801,71.3,97,98.5,99.7,98.9,13.8,43.2,{"$f":"AY14+2.3","v":98.100000000000009},13.8,{"$f":"33.6+BA14","v":43.2},{"$f":"5.2+BB14","v":97.600000000000009},98.4,98.4,12,93.6,99.2,97.8,99.2,100,98.5,97.36,{"$f":"100-1","v":99},16,99,16.399999999999999,96.54,11.7,97.3,56.7,10.9,95.3,94.3,50.4,94.444444444444443,94.716242661448135,null,null,null,null,null,null,null,null,null,560,{"$f":"CJ15/SUM($CJ$14:$CJ$17)","v":0.18836192398250926},19]
["#16",null,34.200000000000003,100,49,95,99.9,100,83.2,100,99,99,96,41,48,29.2,85.2,99.91,99.99,100,35.799999999999997,100,35.799999999999997,84.2,100,100,99.208144796380083,0,100,35.25,83.14,100,100,100,99.805950840879703,99.8,100,100,100,100,38,100,35.254491017964071,89.6,98,100,100,100,33.9,76.900000000000006,{"$f":"AY15+1.9","v":100.00000000000001},{"$f":"AZ15+20.1","v":33.900000000000006},{"$f":"BA15+33.7","v":76.900000000000006},{"$f":"2.4+BB15","v":100.00000000000001},100,100,22,97.2,100,100,100,100,100,98.02,100,38,99,40.5,100,31.5,99.7,85,29.8,95.3,94.3,85.6,94.444444444444443,94.716242661448135,null,null,null,null,null,null,null,null,null,270,{"$f":"CJ16/SUM($CJ$14:$CJ$17)","v":9.081735620585267E-2},9]
["#30",null,62,100,71,99,100,100,92.7,100,100,100,98,62,69,54.1,93.1,99.91,99.99,100,63,100,60,92.8,100,100,99.208144796380083,0,100,60.69,92.14,100,100,100,100,100,100,100,100,100,65.599999999999994,100,56.661676646706582,98.1,99,100,100,100,59,89.1,100,{"$f":"AZ16+25.1","v":59.000000000000007},{"$f":"BA16+12.2","v":89.100000000000009},100,100,100,49,97.5,100,100,100,100,100,100,100,69,99,67.7,100,56.6,99.7,93.8,55.5,95.3,94.3,94.4,94.444444444444443,94.716242661448135,null,null,null,null,null,null,null,null,null,1243,{"$f":"CJ17/SUM($CJ$14:$CJ$17)","v":0.41809619912546248},42]
["#50",null,87.8,100,91,100,100,100,97.4,100,100,100,98,83,94,87.1,97.3,99.91,99.99,100,90.1,100,88.6,97.7,100,100,99.208144796380083,0,100,90.22,97.74,100,100,100,100,100,100,100,100,100,91.3,100,76.64670658682634,100,100,100,100,100,87,96.5,100,{"$f":"AZ17+28","v":87},{"$f":"BA17+7.4","v":96.500000000000014},100,100,100,88,97.7,100,100,100,100,100,100,100,92,99,92.1,100,87.2,99.7,97.6,83,95.3,94.3,97.8,94.444444444444443,94.716242661448135]
["#100",null,99.1,100,99,100,100,100,99.3,100,100,100,98.5,99,98,97.6,99.2,99.91,99.99,100,98.4,100,98.9,99.5,100,100,99.208144796380083,0,100,98.85,99.41,100,100,100,100,100,100,100,100,100,98.9,100,88.622754491017957,100,100,100,100,100,98.5,99.5,100,{"$f":"AZ18+11.5","v":98.5},{"$f":"BA18+3","v":99.500000000000014},100,100,100,98,99,100,100,100,100,100,100,100,99.5,99,99.2,100,98.7,99.7,99.1,96.3,95.3,94.3,99.1,94.444444444444443,94.716242661448135]
["#200",null,99.9,100,100,100,100,100,99.7,100,100,100,100,100,99.5,99.2,99.7,99.91,99.99,100,99.5,100,99.9,99.9,100,100,99.208144796380083,0,100,99.84,99.83,100,100,100,100,100,100,100,100,100,99.8,100,97.155688622754482,100,100,100,100,100,99.8,99.9,100,{"$f":"AZ19+1.3","v":99.8},{"$f":"BA19+0.4","v":99.90000000000002},100,100,100,98.8,99.1,100,100,100,100,100,100,100,99.8,99.6,99.8,100,99.6,99.7,99.4,99.4,95.3,94.3,99.4,94.444444444444443,94.716242661448135]
["pan",null,100,100,100,100,100,100,100,100,100,100,100,100,100,99.7,100,99.91,99.99,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,{"$f":"AZ20+0.2","v":100},{"$f":"BA20+0.1","v":100.00000000000001},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,99.8,100,99.6,99.7,100,100,100]
["Initials",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"HM","SD","SD","SD","SD","SD",null,null,null,null,null,null,null,null,"SD","SD"]
[]
["Percent Retained on Each Sieve",null,{"$f":"C2","v":"KDOT Kansas River Sand"},{"$f":"D2","v":"KDOT Limestone"},"Midwest Concrete Sand","Midwest SA-1","Granite","LRM - Arch (from Midwest)","LRM - Pea G.","Midwest 3/4 x 3/8","Stone 1","Stone 2","Stone 3","Sand 1","Sand 2","KDOT Kansas River Sand 6/17/03","LRM Pea Gravel 6/17/03","1\" Washed Airport Limestone 10/2003","1 1/4\" Quartzite 10/2003","Quartzite Chip 10/2003","KDOT Kansas River Sand 12/12/03","? Saif 9/2/03","KDOT Kansas River 2-18-04","Pea Gravel 2-18-04","3/4\" KDOT Limestone 2-18-04","3/4\" KDOT Limestone 4/29/2004","1\" Washed Airport Limestone sieved","cement sand","3/4\" KDOT Limestone 6/18/2004","KDOT Kansas River Sand 6/18/04","Pea Gravel 6/18/04","#67 Quartzite 6/23/2004","Quartzite 1 1/4\" 6/24/2004","#67 Quartzite 6/28/2004","Kansas 3/4in. Granite 8/3/04","#57 Limestone HMM 9/7/2004","Martin Marietta Limestone 9/14/2004","#57 Granite 9/14/2004","#67 Quartzite 10/8/2004","3/4\" KDOT Limestone 10/8/2004","KDOT Sand 10/8/2004","ACI 211.1 Apx 1 Example CA","ACI 211.1 Apx 1 Example FA","ACI 211.1 Apx 1 Example Blending","Swapnil's next aggregate","3/4\" KDOT Limestone 01/10/2005","3/4\" Quartzite 01/10/2005","3/4\" Granite 01/10/2005","KDOT Sand 01/10/2005","LRM Pea Gravel 01/10/2005","A1 - Granite","A2 - River Sand","A3 - Pea Gravel","A4 - Small Deco","OK - CA #1","OK - IA #1","OK - FA",{"$f":"BF2","v":"OK - IA #2"},"3/4\" Quartzite 03/19/05","3/4\" KDOT Limestone 03/19/05","OK - CA #2","GMQ 1.5 PCCP","GMQ CA7","GMQ 3MA (3/8\")","GMQ 3/4\"",{"$f":"BN2","v":"MA-2 Holliday"},"KC 3/4\"","LRM Kansas River Sand 5-5-05","LRM 3/4\" Class 1 Limestone","LRM Kansas River Sand 6-6-05","LRM 3/4\" Class 1 Limestone 6-3-05",{"$f":"BT2","v":"LRM Pea Gravel 6-14-05"},"LRM Kansas River Sand 6-23-05","LRM 3/4\" Class 1 Limestone","LRM 3/4\" Class 1 Limestone 7/14/05","LRM Pea Gravel 7/14/05","LRM 3/4\" Limestone >3/8\"","LRM 3/4\" Limestone <3/8\"",null,"KDOT Specification (min)",null,"KDOT Specification (max)"]
["1 1/2\"",null,{"$f":"+C9","v":0},0,0,0,0,0,0,0,{"$f":"+K9","v":0},6.5,0,0,0,0,0,0,{"$f":"+S9","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+AD9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+BC9","v":0},0,0,0,0,0,{"$f":"+BI9","v":0},0,0,0,0,0,{"$f":"+BO9","v":0},0,0,0,0,0,{"$f":"+BU9","v":0},0,0,0,0,0,null,0,null,0]
["1\"",null,{"$f":"+C10-C9","v":0},0,0,0,0,0,0,0,{"$f":"+K10-K9","v":0},33.5,0,0,0,0,0,0,{"$f":"+S10-S9","v":0},0,0,0,0,0,0,0,0,0,0.06,{"$f":"+AD10-AD9","v":0},0,0,0,0,0,0,0,0.4,0,0,0,0,0,0,50,0,0,0,0,0,4,0,0,0,{"$f":"+BC10-BC9","v":0},0,0,{"$f":"+BF10-BF9","v":0},0,0,{"$f":"+BI10-BI9","v":1.0999999999999943},14.1,0,0,{"$f":"+BM10-BM9","v":0},0,{"$f":"+BO10-BO9","v":0},{"$f":"+BP10-BP9","v":0},0,{"$f":"+BR10-BR9","v":0},0,{"$f":"+BT10-BT9","v":0},0,0,{"$f":"+BW10-BW9","v":0},0,{"$f":"+BY10-BY9","v":0},0,null,2,null,6]
["3/4\"",null,{"$f":"+C11-C10","v":0},0,{"$f":"+E11-E10","v":0},0,0,0,0,0,{"$f":"+K11-K10","v":3.5},27,0,0,0,0,0,25.94,{"$f":"+S11-S10","v":8.31},0,0,0,0,0,0,0,0,0,0.13,{"$f":"+AD11-AD10","v":0},0,0.6361323155216374,4.3391188251001456,1.58,2.005174644243223,2.7,0,17.5,1.4,0,0,20.909627879503841,0,0,30,0,2,1.3,0,0,11,0,0,0,0.79999999999999716,0,0,0,0.2,0,13.700000000000006,29.4,0,0,5,0,4,0,0,0,0,0,0,0,0.06,0,0.12345679012345678,0,null,5,null,22]
["1/2\"",null,0,27.9,0,0,38.4,7.9,0,23,{"$f":"+K12-K11","v":36.4},17,28,0,0,0,0,71.72,{"$f":"+S12-S11","v":46.93},0.27,0,13.99,0,0,23.04,19,96.945701357466049,0,11.280000000000001,{"$f":"+AD12-AD11","v":0},0,21.564885496183205,44.19225634178904,25.86,18.17593790426907,27.8,18.440000000000001,35.940000000000005,28.3,17.5,0,44.772593030124042,0,0,10,18.899999999999999,31.1,20.399999999999999,0,0,40.200000000000003,0,0,7.9,25.6,0,0,0,9.9,22.6,55.900000000000006,30.400000000000006,6.5,0,39,0,36,0,17.13,0,25.3,0,0,25,21.740000000000002,0,44.732510288065846,0,null,8,null,22]
["3/8\"",null,{"$f":"+C13-C12","v":0},28.200000000000003,0,0,28.199999999999996,31.800000000000004,0,31,{"$f":"+K13-K12","v":25.9},9,19,0,5,0,0,1.460000000000008,{"$f":"+S13-S12","v":22.999999999999993},17.5,0,23.019999999999996,0,0,26.46,26.700000000000003,1.9796380090497792,0,18.659999999999997,{"$f":"+AD13-AD12","v":0},0,34.860050890585235,26.76902536715621,28.400000000000002,30.789133247089278,25.6,23.499999999999996,21.399999999999991,36.099999999999994,25.799999999999997,0,22.386296515062014,0,16.399999999999999,5,25.5,34.4,30.000000000000004,0,0,23,0,0,31.800000000000004,42.500000000000007,1.9000000000000057,0,0,22.6,26.1,15.599999999999994,10.199999999999989,38,5,33,0,32,0,25.210000000000004,0,29.8,0,0,29.5,24.099999999999998,0,49.588477366255141,0,null,8,null,22]
["#4",null,1.2,37.9,5,21,30.200000000000003,52.7,10.9,44,{"$f":"+K14-K13","v":27.5},4,38,0,8,0.6,11.8,0.17000000000000171,{"$f":"+S14-S13","v":17.560000000000002},76,1.2,50.73,1.4,10.3,42.099999999999994,43.899999999999991,0.22624434389140902,0,48.72,{"$f":"+AD14-AD13","v":1.6},12.47,38.358778625954209,22.496662216288385,36.789999999999992,44.372574385510987,36.1,44.67,21.13000000000001,32.299999999999997,45.600000000000009,1.4,11.931482575310099,1.0479041916167664,29.200000000000003,1,46.4,31.400000000000006,45.5,2,9.6,17.600000000000009,2,9.6,52.7,28.199999999999989,87.5,4,53.8,60.8,41.7,12.700000000000003,14.100000000000009,52.2,90.37,21,0,26,0,45.959999999999994,1.3,38.199999999999996,10.1,0.9,35.200000000000003,41.000000000000007,9.5,0,80.234833659491201,null,8,null,22]
["#8",null,11.200000000000001,4,17,44,2.2999999999999972,5.1999999999999886,37.200000000000003,1,{"$f":"+K15-K14","v":5.7000000000000028},1,8,6,32,9.8000000000000007,41,3.9999999999992042E-2,{"$f":"+S15-S14","v":2.25},5.5400000000000063,12.600000000000001,8.75,13.1,41,6.1400000000000006,7.7000000000000028,5.6561085972845149E-2,0,15.060000000000002,{"$f":"+AD15-AD14","v":12.72},40.51,1.908396946564892,1.4686248331108231,3.460000000000008,1.6817593790427026,5.0999999999999943,11.200000000000003,1.3499999999999943,1.6000000000000085,8.2999999999999972,12.799999999999999,0,11.377245508982035,25.699999999999996,1,7.7000000000000028,0.79999999999999716,1.7000000000000028,11.8,33.6,2.2999999999999972,11.8,33.6,5.2000000000000028,1.3000000000000114,9,8,39.799999999999997,5.7000000000000028,7.3999999999999915,0.20000000000000284,1.7999999999999972,1.7999999999999972,1.9899999999999949,1,16,1,16.399999999999999,8.2400000000000091,10.399999999999999,4,46.6,10,5.5999999999999943,7.3999999999999915,40.9,0,14.481409001956933,null,8,null,22]
["#16",null,{"$f":"+C16-C15","v":21.800000000000004},2,27,30,0.80000000000001137,2.4000000000000057,35.1,1,{"$f":"+K16-K15","v":0},1,3,35,3,18.799999999999997,32.400000000000006,0.57999999999999829,{"$f":"+S16-S15","v":1.9399999999999977},0.68999999999999773,21.999999999999996,3.5100000000000051,21.299999999999997,32.900000000000006,2.2600000000000051,2.7000000000000028,0,0,6.0900000000000034,{"$f":"+AD16-AD15","v":20.93},30.160000000000004,2.6717557251908204,0.73431241655539736,3.9099999999999966,2.7813712807244428,2.5,2.1899999999999977,2.2800000000000011,0.29999999999999716,2.7999999999999972,23.8,0,22.82934131736527,18.299999999999997,1,1.5,0.29999999999999716,1.0999999999999943,20.099999999999998,33.700000000000003,1.9000000000000057,20.100000000000005,33.700000000000003,2.4000000000000057,1.5999999999999943,1.5999999999999943,10,3.6000000000000085,0.79999999999999716,2.2000000000000028,0.79999999999999716,0,1.5,0.65999999999999659,1,22,0,24.1,3.4599999999999937,19.8,2.4000000000000057,28.299999999999997,18.899999999999999,0,0,35.199999999999996,0,0,null,8,null,22]
["#30",null,27.799999999999997,0,22,4,9.9999999999994316E-2,0,9.5,0,{"$f":"+K17-K16","v":1},1,2,21,21,24.900000000000002,7.8999999999999915,0,{"$f":"+S17-S16","v":0},0,27.200000000000003,0,24.200000000000003,8.5999999999999943,0,0,0,0,0,{"$f":"+AD17-AD16","v":25.439999999999998},9,0,0,0,0.19404915912029708,0.20000000000000284,0,0,0,0,27.599999999999994,0,21.407185628742511,8.5,1,0,0,0,25.1,12.199999999999989,0,25.1,12.200000000000003,0,0,0,27,0.29999999999999716,0,0,0,0,0,1.980000000000004,0,31,0,27.200000000000003,0,25.1,0,8.7999999999999972,25.7,0,0,8.8000000000000114,0,0,null,8,null,15]
["#50",null,25.799999999999997,0,20,1,0,0,4.7000000000000028,0,{"$f":"+K18-K17","v":0},0,0,21,25,32.999999999999993,4.2000000000000028,0,{"$f":"+S18-S17","v":0},0,27.099999999999994,0,28.599999999999994,4.9000000000000057,0,0,0,0,0,{"$f":"+AD18-AD17","v":29.53},5.5999999999999943,0,0,0,0,0,0,0,0,0,25.700000000000003,0,19.985029940119759,1.9000000000000057,1,0,0,0,28,7.4000000000000057,0,27.999999999999993,7.4000000000000057,0,0,0,39,0.20000000000000284,0,0,0,0,0,0,0,23,0,24.399999999999991,0,30.6,0,3.7999999999999972,27.5,0,0,3.3999999999999915,0,0,null,5,null,15]
["#100",null,11.299999999999997,0,8,0,0,0,1.8999999999999915,0,{"$f":"+K19-K18","v":0},0,0.5,16,4,10.5,1.9000000000000057,0,{"$f":"+S19-S18","v":0},0,8.3000000000000114,0,10.300000000000011,1.7999999999999972,0,0,0,0,0,{"$f":"+AD19-AD18","v":8.6299999999999955},1.6700000000000017,0,0,0,0,0,0,0,0,0,7.6000000000000085,0,11.976047904191617,0,0,0,0,0,11.5,3,0,11.5,3,0,0,0,10,1.2999999999999972,0,0,0,0,0,0,0,7.5,0,7.1000000000000085,0,11.5,0,1.5,13.299999999999997,0,0,1.2999999999999972,0,0]
["#200",null,0.80000000000001137,0,1,0,0,0,0.40000000000000568,0,{"$f":"+K20-K19","v":0},0,1.5,1,1.5,1.6000000000000085,0.5,0,{"$f":"+S20-S19","v":0},0,1.0999999999999943,0,1,0.40000000000000568,0,0,0,0,0,{"$f":"+AD20-AD19","v":0.99000000000000909},0.42000000000000171,0,0,0,0,0,0,0,0,0,0.89999999999999147,0,8.5329341317365248,0,0,0,0,0,1.2999999999999972,0.40000000000000568,0,1.2999999999999972,0.40000000000000568,0,0,0,0.79999999999999716,9.9999999999994316E-2,0,0,0,0,0,0,0,0.29999999999999716,0.59999999999999432,0.59999999999999432,0,0.89999999999999147,0,0.30000000000001137,3.1000000000000085,0,0,0.30000000000001137,0,0]
["fines",null,9.9999999999994316E-2,0,0,0,0,0,0.29999999999999716,0,{"$f":"+K21-K20","v":0},0,0,0,0.5,0.5,0.29999999999999716,0,{"$f":"+S21-S20","v":0},0,0.5,0,9.9999999999994316E-2,9.9999999999994316E-2,0,0,0.79185520361991735,100,0,{"$f":"+AD21-AD20","v":0.15999999999999659},0.17000000000000171,0,0,0,0,0,0,0,0,0,0.20000000000000284,0,2.8443113772455177,0,0,0,0,0,0.20000000000000284,9.9999999999994316E-2,0,0.20000000000000284,9.9999999999994316E-2,0,0,0,1.2000000000000028,0.90000000000000568,0,0,0,0,0,0,0,0.20000000000000284,0.40000000000000568,0.20000000000000284,0,0.40000000000000568,0.29999999999999716,0.39999999999999147,0.59999999999999432,4.2999999999999972,5.4000000000000057,0.59999999999999432,5.5555555555555571,5.2837573385518652,null,0,null,2.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Big","cumulative"]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW25","v":0},{"$f":"BW49/$BV$52","v":0},{"$f":"BX49","v":0}]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW26","v":0},{"$f":"BW50/$BV$52","v":0},{"$f":"BX50+BY49","v":0}]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.06,{"$f":"BW51/$BV$52*100","v":0.12345679012345678},{"$f":"BX51+BY50","v":0.12345679012345678}]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(BW49:BW53)+0.5*BW61","v":48.6},21.740000000000002,{"$f":"BW52/$BV$52*100","v":44.732510288065846},44.855967078189302]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/8\"",24.099999999999998,{"$f":"BW53/$BV$52*100","v":49.588477366255141},94.444444444444443]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41.000000000000007,0,94.444444444444443]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BW54:BW60)+0.5*BW61","v":51.1},7.3999999999999915,0,94.444444444444443]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,94.444444444444443]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,94.444444444444443]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,94.444444444444443]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,94.444444444444443]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,94.444444444444443]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW37","v":5.4000000000000057},{"$f":"BW61/2/BV52*100","v":5.5555555555555616},100]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Small"]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"BX63","v":0}]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"BX64+BY63","v":0}]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"BX65+BY64","v":0}]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW54/$BV$55*100","v":80.234833659491201},80.234833659491201]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW55/$BV$55*100","v":14.48140900195693},94.716242661448135]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW56/$BV$55","v":0},94.716242661448135]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW57/$BV$55","v":0},94.716242661448135]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW58/$BV$55","v":0},94.716242661448135]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW59/$BV$55","v":0},94.716242661448135]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW60/$BV$55","v":0},94.716242661448135]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW61/2/$BV$55*100","v":5.2837573385518644},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8","18","Bad Gradation"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 1/2\"",0,18,0]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1\"",0,18,4]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/4\"",8,18,8.5]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2\"",8,18,16]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/8\"",8,18,8.5]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#4",8,18,8.5]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#8",8,18,8.5]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#16",8,18,8.5]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#30",8,18,16]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#50",0,18,16]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#100",0,8,3]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#200",0,8,2]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pan",0,8,0.5]

{"sheet":"MixDesign","index":1,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":false,"merged":[[38,2,38,5],[39,2,39,5],[39,9,39,10],[40,2,40,5],[40,6,40,7],[40,9,40,10],[39,6,39,7],[38,6,38,7],[38,9,38,10],[19,2,19,10],[28,2,28,5],[29,2,29,5],[30,2,30,5],[29,9,29,10],[30,9,30,10],[20,2,20,10],[28,9,28,10],[28,6,28,7],[29,6,29,7],[30,6,30,7],[12,2,12,10],[13,2,13,10],[14,2,14,10],[17,2,17,10],[15,2,15,10],[16,2,16,10],[32,2,32,5],[32,6,32,7],[32,9,32,10],[31,2,31,5],[31,6,31,7],[31,9,31,10],[37,9,37,10],[34,2,34,5],[35,2,35,5],[34,6,34,7],[37,6,37,7],[36,9,36,10],[34,9,34,10],[35,9,35,10],[36,6,36,7],[35,6,35,7],[49,7,49,8],[41,2,41,5],[41,6,41,7],[41,9,41,10],[42,2,42,5],[42,6,42,7],[42,9,42,10],[43,9,43,10],[43,6,43,7],[43,2,43,5],[50,7,50,8],[51,7,51,8],[52,7,52,8],[56,7,56,8],[53,7,53,8],[1,3,2,9],[47,9,47,10],[45,9,45,10],[45,6,45,7],[45,2,45,5],[44,2,44,5],[44,6,44,7],[44,9,44,10],[46,9,46,10],[46,2,46,5],[46,6,46,7],[36,2,36,5],[33,2,33,5],[33,6,33,7],[33,9,33,10],[37,2,37,5]]}
[]
[null,null,null,"KU MIX 5.1 BETA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(ISBLANK(Calculations!B71)=TRUE,\"BLANK\",Calculations!B71)","v":"University of Kansas"}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B72)=TRUE,\"BLANK\",Calculations!B72)","v":"CEAE Department"}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B73)=TRUE,\"BLANK\",Calculations!B73)","v":"2150 Learned Hall"}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B74)=TRUE,\"BLANK\",Calculations!B74)","v":"1530 W. 15th St."}]
[null,null,{"$f":"CONCATENATE(Calculations!B75, \", \",Calculations!B76, \" \",Calculations!B77)","v":"Lawrence, Kansas 66045-7609"}]
[null,null,{"$f":"IF(AND(ISBLANK(Calculations!B78),ISBLANK(Calculations!B79)),\"BLANK\",IF(ISBLANK(Calculations!B78)=TRUE,CONCATENATE(\"Fax: \",Calculations!B79),IF(ISBLANK(Calculations!B79)=TRUE,CONCATENATE(\"Phone: \",Calculations!B78), CONCATENATE(\"Phone: \",Calculations!B78,\"  Fax: \",Calculations!B79))))","v":"Phone: 785.864.3885  Fax: 785.864.5631"}]
[]
[null,null,{"$f":"IF(ISBLANK(Calculations!B85)=TRUE,\"CONCRETE MIX DESIGN\", CONCATENATE(\"CONCRETE MIX DESIGN REPORT #\",Calculations!B85))","v":"CONCRETE MIX DESIGN"}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B86)=TRUE,\"BLANK\",CONCATENATE(\"Compressive Strength: \",Calculations!B86))","v":"BLANK"}]
[]
[null,null,"Contractor:",null,{"$f":"IF(ISBLANK(Calculations!B80),\"BLANK\",Calculations!B80)","v":"Quality Construction Co."}]
[null,null,"Project:",null,{"$f":"IF(ISBLANK(Calculations!B81),\"BLANK\",Calculations!B81)","v":"County Road 443"}]
[null,null,"Source of Concrete:",null,{"$f":"IF(ISBLANK(Calculations!B82),\"BLANK\",Calculations!B82)","v":"Ready Mix Concrete"}]
[null,null,"Project Type:",null,{"$f":"IF(ISBLANK(Calculations!B83),\"BLANK\",Calculations!B83)","v":"LC-HPC Bridge Deck"}]
[null,null,"Placement Type:",null,{"$f":"IF(ISBLANK(Calculations!B84),\"BLANK\",Calculations!B84)","v":"Conventional"}]
[]
[null,null,"Material / Source or Designation / Blend1",null,null,null,"Quantity (SSD)",null,"S.G.","Yield, ft3"]
[null,null,{"$f":"IF(ISBLANK(Calculations!A3)=TRUE,\"BLANK\",CONCATENATE(Calculations!M3,\" / \",Calculations!L3, \" / \",Calculations!U110,\"%\"))","v":"Type I/II Cement / Cement Producer / 100%"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A3)=TRUE,\"\",CONCATENATE(Calculations!H3,\" lb\"))","v":"700 lb"},null,{"$f":"IF(ISBLANK(Calculations!A3)=TRUE,\"\",Calculations!E3)","v":3.13},{"$f":"IF(ISBLANK(Calculations!A3)=TRUE,\"\",Calculations!S110*(27/Calculations!Z134))","v":3.5796986440855423}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A4)=TRUE,\"BLANK\",CONCATENATE(Calculations!M4,\" / \",Calculations!L4, \" / \",Calculations!U111,\"%\"))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A4)=TRUE,\"\",CONCATENATE(Calculations!H4,\" lb\"))","v":""},null,{"$f":"IF(ISBLANK(Calculations!A4)=TRUE,\"\",Calculations!E4)","v":""},{"$f":"IF(ISBLANK(Calculations!A4)=TRUE,\"\",Calculations!S111*(27/Calculations!Z134))","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A5)=TRUE,\"BLANK\",CONCATENATE(Calculations!M5,\" / \",Calculations!L5, \" / \",Calculations!U112,\"%\"))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A5)=TRUE,\"\",CONCATENATE(Calculations!H5,\" lb\"))","v":""},null,{"$f":"IF(ISBLANK(Calculations!A5)=TRUE,\"\",Calculations!E5)","v":""},{"$f":"IF(ISBLANK(Calculations!A5)=TRUE,\"\",Calculations!S112*(27/Calculations!Z134))","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A6)=TRUE,\"BLANK\",CONCATENATE(Calculations!M6,\" / \",Calculations!L6, \" / \",Calculations!U113,\"%\"))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A6)=TRUE,\"\",CONCATENATE(Calculations!H6,\" lb\"))","v":""},null,{"$f":"IF(ISBLANK(Calculations!A6)=TRUE,\"\",Calculations!E6)","v":""},{"$f":"IF(ISBLANK(Calculations!A6)=TRUE,\"\",Calculations!S113*(27/Calculations!Z134))","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A7)=TRUE,\"BLANK\",CONCATENATE(Calculations!M7,\" / \",Calculations!L7, \" / \",Calculations!U114,\"%\"))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A7)=TRUE,\"\",CONCATENATE(Calculations!H7,\" lb\"))","v":""},null,{"$f":"IF(ISBLANK(Calculations!A7)=TRUE,\"\",Calculations!E7)","v":""},{"$f":"IF(ISBLANK(Calculations!A7)=TRUE,\"\",Calculations!S114*(27/Calculations!Z134))","v":""}]
[null,null,"Water",null,null,null,{"$f":"CONCATENATE(Calculations!$Q$108,\" lb\")","v":"314 lb"},null,{"$f":"Calculations!R108","v":1},{"$f":"Calculations!S108*(27/Calculations!Z134)","v":5.029576586522424}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A26)=TRUE,\"BLANK\",CONCATENATE(Calculations!B27,\" / \",Calculations!T27,\" / \",Calculations!U117,\"%\"))","v":"CA-30 Granite  / G-30 / 61.33%"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A26)=TRUE,\"\",CONCATENATE(Calculations!T117,\" lb\"))","v":"1645 lb"},null,{"$f":"IF(ISBLANK(Calculations!A26)=TRUE,\"\",Calculations!C26)","v":2.6},{"$f":"IF(ISBLANK(Calculations!A26)=TRUE,\"\",Calculations!V117*(27/Calculations!Z134))","v":10.138446300536755}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A29)=TRUE,\"BLANK\",CONCATENATE(Calculations!B30,\" / \",Calculations!T30,\" / \",Calculations!U118,\"%\"))","v":"Sand  / S-20 / 38.67%"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A29)=TRUE,\"\",CONCATENATE(Calculations!T118, \" lb\"))","v":"1037 lb"},null,{"$f":"IF(ISBLANK(Calculations!A29)=TRUE,\"\",Calculations!C29)","v":2.62},{"$f":"IF(ISBLANK(Calculations!A29)=TRUE,\"\",Calculations!V118*(27/Calculations!Z134))","v":6.342439248128076}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A32)=TRUE,\"BLANK\",CONCATENATE(Calculations!B33,\" / \",Calculations!T33,\" / \",Calculations!U119,\"%\"))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A32)=TRUE,\"\",CONCATENATE(Calculations!T119, \" lb\"))","v":""},null,{"$f":"IF(ISBLANK(Calculations!A32)=TRUE,\"\",Calculations!C32)","v":""},{"$f":"IF(ISBLANK(Calculations!A32)=TRUE,\"\",Calculations!V119*(27/Calculations!Z134))","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A35)=TRUE,\"BLANK\",CONCATENATE(Calculations!B36,\" / \",Calculations!T36,\" / \",Calculations!U120,\"%\"))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A35)=TRUE,\"\",CONCATENATE(Calculations!T120, \" lb\"))","v":""},null,{"$f":"IF(ISBLANK(Calculations!A35)=TRUE,\"\",Calculations!C35)","v":""},{"$f":"IF(ISBLANK(Calculations!A35)=TRUE,\"\",Calculations!V120*(27/Calculations!Z134))","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A38)=TRUE,\"BLANK\",CONCATENATE(Calculations!B39,\" / \",Calculations!T39,\" / \",Calculations!U121,\"%\"))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A38)=TRUE,\"\",CONCATENATE(Calculations!T121,\" lb\"))","v":""},null,{"$f":"IF(ISBLANK(Calculations!A38)=TRUE,\"\",Calculations!C38)","v":""},{"$f":"IF(ISBLANK(Calculations!A38)=TRUE,\"\",Calculations!V121*(27/Calculations!Z134))","v":""}]
[null,null,"Total Air, percent",null,null,null,{"$f":"CONCATENATE(Calculations!Q109,\"%\")","v":"7%"},null,null,{"$f":"Calculations!S109*(27/Calculations!Z134)","v":1.8898409042797975}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A12)=TRUE,\"BLANK\",CONCATENATE(Calculations!N13,\" / \",Calculations!O13))","v":"Air Entraining Agent / Air R Us"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A12)=TRUE,\"\",CONCATENATE(Calculations!I12,\" fl oz (US)\"))","v":"21 fl oz (US)"},null,{"$f":"Calculations!R130","v":1.01},{"$f":"Calculations!V130*(27/Calculations!Z134)","v":1.9998316447405264E-2}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A17)=TRUE,\"BLANK\",CONCATENATE(Calculations!P17, \" / \",Calculations!Q17))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A17)=TRUE,\"\",CONCATENATE(Calculations!K17,\" fl oz (US)\"))","v":""},null,{"$f":"Calculations!R125","v":""},{"$f":"IF(ISBLANK(Calculations!A17)=TRUE,\"\",Calculations!V125*(27/Calculations!Z134))","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A18)=TRUE,\"BLANK\",CONCATENATE(Calculations!P18, \" / \",Calculations!Q18))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A18)=TRUE,\"\",CONCATENATE(Calculations!K18,\" fl oz (US)\"))","v":""},null,{"$f":"Calculations!R126","v":""},{"$f":"IF(ISBLANK(Calculations!A18)=TRUE,\"\",Calculations!V126*(27/Calculations!Z134))","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A19)=TRUE,\"BLANK\",CONCATENATE(Calculations!P19, \" / \",Calculations!Q19))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A19)=TRUE,\"\",CONCATENATE(Calculations!K19,\" fl oz (US)\"))","v":""},null,{"$f":"Calculations!R127","v":""},{"$f":"IF(ISBLANK(Calculations!A19)=TRUE,\"\",Calculations!Q127*(27/Calculations!Z134))","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A20)=TRUE,\"BLANK\",CONCATENATE(Calculations!P20, \" / \",Calculations!Q20))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A20)=TRUE,\"\",CONCATENATE(Calculations!K20,\" fl oz (US)\"))","v":""},null,{"$f":"Calculations!R128","v":""},{"$f":"IF(ISBLANK(Calculations!A20)=TRUE,\"\",Calculations!Q128*(27/Calculations!Z134))","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!A21)=TRUE,\"BLANK\",CONCATENATE(Calculations!P21, \" / \",Calculations!Q21))","v":"BLANK"},null,null,null,{"$f":"IF(ISBLANK(Calculations!A21)=TRUE,\"\",CONCATENATE(Calculations!K21,\" fl oz (US)\"))","v":""},null,{"$f":"Calculations!R129","v":""},{"$f":"IF(ISBLANK(Calculations!A21)=TRUE,\"\",Calculations!Q129*(27/Calculations!Z134))","v":""}]
[null,null,"1   The blend percentage indicated (by weight) is listed separately for cementitious materials and aggregates.",null,null,null,null,null,null,{"$f":"ROUND(SUM(J30:K47),2)","v":27}]
[]
[null,null,"Total Water Content (including water in admixtures), lb",null,null,null,null,{"$f":"ROUND(Calculations!Y61*SUM(Calculations!Q110:Q114),0)","v":315}]
[null,null,"Water / Cementitious Material Ratio:",null,null,null,null,{"$f":"Calculations!$Y$61","v":"0.45"}]
[null,null,"Concrete Unit Weight, pcf",null,null,null,null,{"$f":"Calculations!$Q$132","v":136.92592592592592}]
[null,null,"Target Slump, in.",null,null,null,null,{"$f":"IF(OR(ISBLANK(Calculations!B88)=TRUE,ISBLANK(Calculations!B89)=TRUE)=TRUE,\"BLANK\",CONCATENATE(Calculations!B88,\" ± \",Calculations!B89))","v":"BLANK"}]
[null,null,"Paste Content, percent",null,null,null,null,{"$f":"Calculations!W109","v":0.31955840455840456}]
[null,null,"Workability Factor (WF)",null,null,null,"Target:",{"$f":"Calculations!$R$61","v":35},"Actual:",{"$f":"Calculations!AJ86","v":37.318325690595543}]
[null,null,"Coarseness Factor (CF)",null,null,null,"Target:",{"$f":"Calculations!$Q$61","v":51.801903896624864},"Actual:",{"$f":"Calculations!$AJ$85","v":62.486894826604754}]
[null,null,"Prepared On:",null,null,null,null,{"$f":"NOW()","v":"2022-02-23T16:32:57.520"}]
[]
[null,null,"Prepared By:"]
[]
[]
[null,null,{"$f":"IF(ISBLANK(Calculations!B87)=TRUE,\"--\",Calculations!B87)","v":"--"}]

{"sheet":"Advanced","index":2,"n_rows":97,"n_cols":17,"rows_kept":97,"cut":false,"hidden":false,"merged":[[1,3,2,15],[10,3,11,15],[35,14,35,16],[17,10,18,15],[17,3,18,9],[19,3,19,9],[20,3,20,9],[19,10,19,15],[12,3,13,4],[29,9,29,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[30,9,30,10],[12,5,13,13],[32,4,32,5],[36,3,37,4],[37,5,37,6],[15,3,16,4],[15,5,16,13],[36,7,36,8],[21,4,22,15],[20,10,20,15],[27,9,27,10],[36,5,36,6],[28,9,28,10],[37,7,37,8],[83,11,83,16],[76,14,76,16],[36,9,38,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[70,9,70,10],[42,11,42,16],[51,9,51,10],[53,9,53,10],[54,9,54,10],[77,5,77,10],[104,11,104,16],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[44,9,44,10],[45,9,45,10],[46,9,46,10],[62,11,62,16],[86,9,86,10],[82,9,82,10],[83,9,83,10],[84,9,84,10],[85,9,85,10],[79,9,79,10],[96,9,96,10],[68,9,68,10],[69,9,69,10],[66,9,66,10],[95,3,95,4],[96,3,96,4],[78,5,78,10],[93,3,93,4],[80,9,80,10],[81,9,81,10],[77,3,77,4],[94,9,94,10],[88,9,88,10],[89,9,89,10],[95,9,95,10],[90,9,90,10],[93,9,93,10],[59,5,59,9],[72,9,72,10],[73,4,73,5],[71,9,71,10],[60,5,60,9],[91,9,91,10],[92,9,92,10],[87,9,87,10],[67,9,67,10]]}
[]
[null,null,null,"GRADATION DETAILS"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"1.  Select Minimum and Maximum Gradation Limits (if desired)"]
[]
[null,null,null,"a.",null,"Press the button at right to input the minimum and maximum gradation limits"]
[]
[]
[null,null,null,"b.",null,"Press the button at right to select minimum and maximum gradation limits"]
[]
[null,null,null,"Aggregate Gradation Comparison",null,null,null,null,null,null,"Minimum or Maximum"]
[]
[null,null,null,{"$f":"IF(ISBLANK(Calculations!B23)=TRUE,\"\",Calculations!B23)","v":"KDOT LC-HPC"},null,null,null,null,null,null,{"$f":"IF(ISBLANK(Calculations!C23)=TRUE,\"\",Calculations!C23)","v":"Min"}]
[null,null,null,{"$f":"IF(ISBLANK(Calculations!B24)=TRUE,\"\",Calculations!B24)","v":"KDOT LC-HPC"},null,null,null,null,null,null,{"$f":"IF(ISBLANK(Calculations!C24)=TRUE,\"\",Calculations!C24)","v":"Max"}]
[null,null,null,null,"Check here to remove these comparison lines from the percent retained charts below"]
[]
[]
[]
[null,null,"Combined Aggregate Details",null,null,null,null,"Blend","Blend",null,null,null,"CF","WF(CF)"]
[null,null,null,null,null,null,null,"(by Weight)","(by Volume)",null,null,null,75,32.90941222]
[null,null,"Aggregates:",null,{"$f":"IF(ISBLANK(Calculations!$A$26)=TRUE,\"\",Calculations!$A$26)","v":"CA-30 Granite  -- G-30"},null,null,{"$f":"IF(Calculations!$P$117=0,\"\",Calculations!$Z$117)","v":0.61343238743684658},{"$f":"IF(Calculations!$P$117=0,\"\",Calculations!$Q$117/1000)","v":0.61506709595362452},null,null,null,70,33.553924269999996]
[null,null,null,null,{"$f":"IF(ISBLANK(Calculations!$A$29)=TRUE,\"\",Calculations!$A$29)","v":"Sand  -- S-20"},null,null,{"$f":"IF(Calculations!$P$118=0,\"\",Calculations!$Z$118)","v":0.38670479378237682},{"$f":"IF(Calculations!$P$118=0,\"\",Calculations!$Q$118/1000)","v":0.38493290404637565},null,null,null,60,35.000278870000002]
[null,null,null,null,{"$f":"IF(ISBLANK(Calculations!$A$32)=TRUE,\"\",Calculations!$A$32)","v":""},null,null,{"$f":"IF(Calculations!$P$119=0,\"\",Calculations!$Z$119)","v":""},{"$f":"IF(Calculations!$P$119=0,\"\",Calculations!$Q$119/1000)","v":""},null,null,null,50,36.54795747]
[null,null,null,null,{"$f":"IF(ISBLANK(Calculations!$A$35)=TRUE,\"\",Calculations!$A$35)","v":""},null,null,{"$f":"IF(Calculations!$P$120=0,\"\",Calculations!$Z$120)","v":""},{"$f":"IF(Calculations!$P$120=0,\"\",Calculations!$Q$120/1000)","v":""},null,null,null,40,38.066820069999999]
[null,null,null,null,{"$f":"IF(ISBLANK(Calculations!$A$38)=TRUE,\"\",Calculations!$A$38)","v":""},null,null,{"$f":"IF(Calculations!$P$121=0,\"\",Calculations!$Z$121)","v":""},{"$f":"IF(Calculations!$P$121=0,\"\",Calculations!$Q$121/1000)","v":""},null,null,null,30,39.426726670000001]
[null,null,"Date:",null,{"$f":"TODAY()","v":"2022-02-23"},null,null,{"$f":"SUM(H28:H32)","v":1.0001371812192235},{"$f":"SUM(I28:I32)","v":1.0000000000000002},null,null,null,20,40.497537270000002]
[null,null,"Contractor:",null,{"$f":"IF(ISBLANK(Calculations!$B$80)=TRUE,\"--\",Calculations!$B$80)","v":"Quality Construction Co."},null,null,null,null,null,null,null,10,41.149111869999999]
[null,null,"Project:",null,{"$f":"IF(ISBLANK(Calculations!$B$81)=TRUE,\"--\",Calculations!$B$81)","v":"County Road 443"},null,null,null,null,null,null,null,0,41.25131047]
[null,null,null,null,null,null,null,null,null,null,null,null,"CF","WF(CF)","trend lines"]
[null,null,null,"Sieves Openings",null,"Combined Gradation",null,"Actual Gradation",null,"Pass/Fail",null,"top",35.833300000000001,100,26.833333,100,{"$f":"O37-1.833333","v":25}]
[null,null,null,null,null,"Percent Retained",null,"Limits",null,null,null,null,40,70,26.83333,{"$f":"90-3.33","v":86.67},24.999997]
[null,null,null,"Nominal","mm","Optimum","Actual",{"$f":"K20","v":"Min"},{"$f":"K21","v":"Max"},null,null,"lt",39.304499999999997,75,{"$f":"25+3.33333","v":28.33333},80,26.499997]
[null,null,null,"1.5\"",37.5,{"$f":"Calculations!AE69","v":0},{"$f":"Calculations!AJ69","v":0},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!E$23)","v":0},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!E$24)","v":0},{"$f":"IF(AND(H40=\"--\",I40=\"--\")=TRUE,\"--\",IF(AND(LEFT($H$39,3)=\"Min\",LEFT($I$39,3)=\"Max\")=TRUE,IF(H40=\"--\",\"--\",IF(AND(G40>=H40,G40<=I40)=TRUE,\"PASS\",\"FAIL\")),IF(AND(LEFT($H$39,3)=\"Max\",LEFT($I$39,3)=\"Min\")=TRUE,IF(AND(G40<=H40,G40>=I40)=TRUE,\"PASS\",\"FAIL\"),IF(LEFT($H$39,3)=\"Min\",IF(G40>=H40,\"PASS\",\"FAIL\"),IF(G40<=H40,\"PASS\",\"FAIL\")))))","v":"PASS"},null,null,28.5,75,36,20,34.166666999999997]
[null,null,null,"1\"",25,{"$f":"Calculations!AE70","v":0},{"$f":"Calculations!AJ70","v":8.3565559490202765E-2},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!F$23)","v":0.02},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!F$24)","v":0.06},"FAIL",null,"rt",43.471499999999999,45,36.833329999999997,10,34.999996999999993]
[null,null,null,"3/4\"",19,{"$f":"Calculations!AE71","v":5.9999999999999429E-2},{"$f":"Calculations!AJ71","v":7.7421033057099589E-2},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!G$23)","v":0.05},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!G$24)","v":0.18},"PASS",null,null,32.758499999999998,45,{"$f":"35+1.8333333","v":36.8333333},0,35.000000299999996]
[null,null,null,"1/2\"",12.5,{"$f":"Calculations!AE72","v":0.13302883975056176},{"$f":"Calculations!AJ72","v":0.12657724452192473},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!H$23)","v":0.08},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!H$24)","v":0.18},"PASS",null,"Modified Coarseness Factor Chart"]
[null,null,null,"3/8\"",9.5,{"$f":"Calculations!AE73","v":0.15772080722900711},{"$f":"Calculations!AJ73","v":0.12104717073213192},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!I$23)","v":0.08},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!I$24)","v":0.18},"PASS"]
[null,null,null,"No. 4",4.75,{"$f":"Calculations!AE74","v":0.16862748063508382},{"$f":"Calculations!AJ74","v":0.19778261455534651},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!J$23)","v":0.08},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!J$24)","v":0.18},"FAIL",null,null,"Percent Retained Chart Sieve Lines"]
[null,null,null,"No. 8",2.36,{"$f":"Calculations!AE75","v":0.15772085642763314},{"$f":"Calculations!AJ75","v":4.7521104779626074E-2},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!K$23)","v":0.08},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!K$24)","v":0.18},"FAIL"]
[null,null,null,"No. 16",1.18,{"$f":"Calculations!AE76","v":0.13157680746519262},{"$f":"Calculations!AJ76","v":8.6907928386094818E-2},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!L$23)","v":0.08},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!L$24)","v":0.18},"PASS",null,null,37.5,37.5,0,0.4]
[null,null,null,"No. 30",0.6,{"$f":"Calculations!AE77","v":9.7421909434017739E-2},{"$f":"Calculations!AJ77","v":0.10113621754665016},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!M$23)","v":0.08},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!M$24)","v":0.15},"PASS",null,null,25,25,0,0.4]
[null,null,null,"No. 50",0.3,{"$f":"Calculations!AE78","v":5.9761358336606757E-2},{"$f":"Calculations!AJ78","v":0.12074818368687509},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!N$23)","v":0.05},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!N$24)","v":0.15},"PASS",null,null,19,19,0,0.4]
[null,null,null,"No. 100",0.15,{"$f":"Calculations!AE79","v":2.5690124154648775E-2},{"$f":"Calculations!AJ79","v":2.8841126676801374E-2},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!O$23)","v":0},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!O$24)","v":0.05},"PASS",null,null,12.5,12.5,0,0.4]
[null,null,null,"No. 200",7.4999999999999997E-2,{"$f":"Calculations!AE80","v":1.5381934227626814E-3},{"$f":"Calculations!AJ80","v":1.5381934227627404E-3},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!P$23)","v":0},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!P$24)","v":0.05},"PASS",null,null,9.5,9.5,0,0.4]
[null,null,null,"pan","NA",{"$f":"Calculations!AE81","v":6.9136231444845127E-3},{"$f":"Calculations!AJ81","v":6.9136231444845136E-3},{"$f":"IF(ISBLANK(Calculations!$A$23)=TRUE,\"--\",Calculations!Q$23)","v":0},{"$f":"IF(ISBLANK(Calculations!$A$24)=TRUE,\"--\",Calculations!Q$24)","v":0.02},"PASS",null,null,4.75,4.75,0,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,2.36,2.36,0,0.4]
[null,null,null,{"$f":"IF(Calculations!AL89=0,\"Workability Factor (WF):\",\"Workability Factor (WF)*:\")","v":"Workability Factor (WF)*:"},null,null,"Target:",{"$f":"Calculations!R61","v":35},"Actual:",{"$f":"Calculations!AJ86","v":37.318325690595543},null,null,1.18,1.18,0,0.4]
[null,null,null,"Coarseness Factor (CF):",null,null,"Target:",{"$f":"Calculations!Q61","v":51.801903896624864},"Actual:",{"$f":"Calculations!AJ85","v":62.486894826604754},null,null,0.6,0.6,0,0.4]
[null,null,null,{"$f":"IF(Calculations!AL89=0,\"\",CONCATENATE(\"*Including a \", -1*ROUND(Calculations!AL89,1), \" correction \",IF(Calculations!AL89<0, \"due to excess cementitious material\", \"due to a low cementitious material content\")))","v":"*Including a 2.7 correction due to excess cementitious material"},null,null,null,null,null,null,null,null,0.3,0.3,0,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,0.15,0.15,0,0.4]
[null,null,null,"Combined Fineness Modulus:",null,null,{"$f":"Calculations!AH83","v":5.3669427186219067},null,null,null,null,null,7.4999999999999997E-2,7.4999999999999997E-2,0,0.4]
[]
[null,null,null,"Model Parameters:",null,{"$f":"CONCATENATE(Calculations!$AA$62,\" to \",Calculations!$AB$62,\" percent retained on the \")","v":"2 to 6 percent retained on the "}]
[null,null,null,null,null,{"$f":"CONCATENATE(Calculations!$Y$63,\" sieve.\")","v":"19 mm (3/4 in.) sieve."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Percent Retained Chart"]
[]
[]
[]
[null,null,"Individual Aggregate Details",null,null,null,null,null,"Blend","Blend"]
[null,null,null,null,null,null,null,null,"(by Weight)","(by Volume)"]
[null,null,"Aggregates:",null,{"$f":"E28","v":"CA-30 Granite  -- G-30"},null,null,null,{"$f":"H28","v":0.61343238743684658},{"$f":"I28","v":0.61506709595362452}]
[null,null,null,null,{"$f":"E29","v":"Sand  -- S-20"},null,null,null,{"$f":"H29","v":0.38670479378237682},{"$f":"I29","v":0.38493290404637565}]
[null,null,null,null,{"$f":"E30","v":""},null,null,null,{"$f":"H30","v":""},{"$f":"I30","v":""}]
[null,null,null,null,{"$f":"E31","v":""},null,null,null,"",{"$f":"I31","v":""}]
[null,null,null,null,{"$f":"E32","v":""},null,null,null,"",{"$f":"I32","v":""}]
[null,null,"Date:",null,{"$f":"TODAY()","v":"2022-02-23"}]
[null,null,"Contractor:",null,{"$f":"E34","v":"Quality Construction Co."}]
[null,null,"Project:",null,{"$f":"E35","v":"County Road 443"}]
[]
[null,null,null,"Sieves Openings",null,"Percent Retained (by weight) on Each Sieve"]
[null,null,null,null,null,"Aggregate Designation"]
[null,null,null,"Nominal","mm",{"$f":"LEFT(Calculations!T26,8)","v":"G-30"},{"$f":"LEFT(Calculations!T29,8)","v":"S-20"},{"$f":"LEFT(Calculations!T32,8)","v":""},{"$f":"LEFT(Calculations!T35,8)","v":""},{"$f":"LEFT(Calculations!T38,8)","v":""},null,null,"Number of Aggregates",null,{"$f":"Calculations!$U$28","v":2}]
[null,null,null,"1.5\"",37.5,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$E$27)","v":0},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$E$30)","v":0},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$E$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$E$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$E$39)","v":""}]
[null,null,null,"1\"",25,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$F$27)","v":0.1358641358641359},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$F$30)","v":0},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$F$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$F$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$F$39)","v":""}]
[null,null,null,"3/4\"",19,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$G$27)","v":0.12587412587412589},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$G$30)","v":0},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$G$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$G$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$G$39)","v":""}]
[null,null,null,"1/2\"",12.5,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$H$27)","v":0.20579420579420579},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$H$30)","v":0},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$H$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$H$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$H$39)","v":""}]
[null,null,null,"3/8\"",9.5,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$I$27)","v":0.19680319680319683},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$I$30)","v":0},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$I$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$I$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$I$39)","v":""}]
[null,null,null,"No. 4",4.75,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$J$27)","v":0.31468531468531474},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$J$30)","v":1.098901098901099E-2},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$J$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$J$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$J$39)","v":""}]
[null,null,null,"No. 8",2.36,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$K$27)","v":1.098901098901099E-2},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$K$30)","v":0.1058941058941059},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$K$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$K$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$K$39)","v":""}]
[null,null,null,"No. 16",1.18,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$L$27)","v":0},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$L$30)","v":0.22577422577422582},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$L$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$L$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$L$39)","v":""}]
[null,null,null,"No. 30",0.6,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$M$27)","v":0},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$M$30)","v":0.26273726273726278},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$M$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$M$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$M$39)","v":""}]
[null,null,null,"No. 50",0.3,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$N$27)","v":0},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$N$30)","v":0.31368631368631372},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$N$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$N$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$N$39)","v":""}]
[null,null,null,"No. 100",0.15,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$O$27)","v":0},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$O$30)","v":7.4925074925074928E-2},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$O$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$O$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$O$39)","v":""}]
[null,null,null,"No. 200",7.4999999999999997E-2,{"$f":"IF($F$80=\"\",\"\",1*Calculations!$P$27)","v":0},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$P$30)","v":3.9960039960039969E-3},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$P$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$P$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$P$39)","v":""}]
[null,null,null,"pan","NA",{"$f":"IF($F$80=\"\",\"\",1*Calculations!$Q$27)","v":9.9900099900099917E-3},{"$f":"IF($G$80=\"\",\"\",1*Calculations!$Q$30)","v":1.9980019980019984E-3},{"$f":"IF($H$80=\"\",\"\",1*Calculations!$Q$33)","v":""},{"$f":"IF($I$80=\"\",\"\",1*Calculations!$Q$36)","v":""},{"$f":"IF($J$80=\"\",\"\",1*Calculations!$Q$39)","v":""}]
[null,null,null,"SUM",null,{"$f":"IF(F81=\"\",\"\",SUM(F81:F93))","v":1.0000000000000002},{"$f":"IF(G81=\"\",\"\",SUM(G81:G93))","v":1.0000000000000002},{"$f":"IF(H81=\"\",\"\",SUM(H81:H93))","v":""},{"$f":"IF(I81=\"\",\"\",SUM(I81:I93))","v":""},{"$f":"IF(J81=\"\",\"\",SUM(J81:K93))","v":""}]
[]
[null,null,null,"Specific Gravity:",null,{"$f":"Calculations!C26","v":2.6},{"$f":"Calculations!C29","v":2.62},{"$f":"Calculations!C32","v":""},{"$f":"Calculations!C35","v":""},{"$f":"Calculations!C38","v":""}]
[null,null,null,"Fineness Modulus:",null,{"$f":"IF(G82=\"\",\"\",Calculations!Y26)","v":6.8551448551448555},{"$f":"IF(G80=\"\",\"\",Calculations!Y29)","v":2.9890109890109895},{"$f":"IF(H80=\"\",\"\",Calculations!Y32)","v":""},{"$f":"IF(I80=\"\",\"\",Calculations!Y35)","v":""},{"$f":"IF(J80=\"\",\"\",Calculations!Y38)","v":""}]

{"sheet":"Program v.3","index":3,"n_rows":168,"n_cols":37,"rows_kept":168,"cut":false,"hidden":false,"merged":[[70,3,71,7],[74,2,74,3],[43,2,44,2],[58,2,59,2],[58,3,59,7],[48,2,48,3],[63,6,63,7],[55,2,57,10],[27,2,28,2],[27,3,28,7],[43,3,44,8],[45,2,46,3],[45,4,46,4],[50,5,50,6],[47,2,47,3],[45,10,46,10],[63,10,64,10],[45,9,46,9],[45,5,46,6],[47,5,47,6],[61,2,62,2],[61,3,62,7],[49,2,49,3],[45,8,46,8],[40,3,41,7],[34,2,35,2],[37,10,38,10],[31,2,33,10],[37,2,38,2],[40,2,41,2],[20,5,20,8],[37,3,38,5],[34,3,35,7],[246,13,247,13],[246,11,247,11],[223,10,223,12],[78,2,78,3],[219,10,219,12],[218,10,218,12],[78,4,78,5],[194,12,196,12],[194,11,196,11],[246,3,247,4],[221,10,221,12],[222,10,222,12],[82,2,84,10],[88,2,91,2],[88,3,91,7],[85,2,86,2],[85,3,86,7],[248,3,248,4],[248,5,248,10],[246,5,247,10],[194,4,196,5],[194,6,196,6],[194,10,196,10],[194,9,196,9],[194,7,196,7],[220,10,220,12],[246,12,247,12],[77,2,77,3],[77,4,77,5],[51,5,51,6],[48,5,48,6],[49,5,49,6],[51,2,51,3],[63,2,64,3],[63,8,64,8],[72,10,73,10],[63,9,64,9],[72,9,73,9],[67,2,68,2],[67,3,68,7],[72,4,73,5],[72,6,72,7],[63,4,64,5],[70,2,71,2],[72,8,73,8],[50,2,50,3],[76,2,76,3],[65,2,65,3],[65,4,65,5],[74,4,74,5],[75,2,75,3],[76,4,76,5],[75,4,75,5],[72,2,73,3],[21,5,21,8],[22,5,22,8],[37,8,38,8],[45,7,46,7],[1,2,2,10],[19,5,19,8],[18,2,18,4],[19,2,19,4],[9,2,11,10],[17,5,17,8],[18,5,18,8],[17,2,17,4],[12,2,13,2],[15,2,16,2],[12,3,13,7],[15,3,16,7],[24,2,25,2],[24,3,25,7],[20,2,20,4],[21,2,21,4],[22,2,22,4]]}
[]
[null,null,"MIX DESIGN INPUT AND OPTIMIZATION"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1.  Select Cementious Materials, Water-Cementitious Material Ratio, and Design Air Content"]
[]
[]
[null,null,"a.","Press the button at right to Select Cementious Materials"]
[]
[]
[null,null,"b.","Enter cementitious material Quantities into the table below"]
[]
[null,null,"Material",null,null,"Producer -- Sample #",null,null,null,"Specific Gravity","Quantitiy (lbs)"]
[null,null,{"$f":"IF(ISBLANK(Calculations!B3)=TRUE,\"\",Calculations!B3)","v":"Type I/II Cement"},null,null,{"$f":"IF(ISBLANK(Calculations!A3)=FALSE,Calculations!G3,\"\")","v":"Cement Producer-- #1"},null,null,null,{"$f":"IF(ISBLANK(Calculations!E3)=TRUE,\"\",Calculations!E3)","v":3.13},700]
[null,null,{"$f":"IF(ISBLANK(Calculations!B4)=TRUE,\"\",Calculations!B4)","v":""},null,null,{"$f":"IF(ISBLANK(Calculations!A4)=FALSE,Calculations!G4,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Calculations!E4)=TRUE,\"\",Calculations!E4)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B5)=TRUE,\"\",Calculations!B5)","v":""},null,null,{"$f":"IF(ISBLANK(Calculations!A5)=FALSE,Calculations!G5,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Calculations!E5)=TRUE,\"\",Calculations!E5)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B6)=TRUE,\"\",Calculations!B6)","v":""},null,null,{"$f":"IF(ISBLANK(Calculations!A6)=FALSE,Calculations!G6,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Calculations!E6)=TRUE,\"\",Calculations!E6)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B7)=TRUE,\"\",Calculations!B7)","v":""},null,null,{"$f":"IF(ISBLANK(Calculations!A7)=FALSE,Calculations!G7,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(Calculations!E7)=TRUE,\"\",Calculations!E7)","v":""}]
[]
[null,null,"c.","Enter (or select) the Water-Cementitious Material Ratio"]
[]
[]
[null,null,"d.","Enter (or select) the Design Air Content Percent"]
[]
[]
[]
[null,null,"2.  Select Aggregates and Set Gradation Constraints"]
[]
[]
[null,null,"a.","Select the Top Sieve"]
[]
[]
[null,null,"b.",{"$f":"CONCATENATE(\"Enter (or select) the max and min percent retained desired on the \", Calculations!Y63, \" sieve\")","v":"Enter (or select) the max and min percent retained desired on the 19 mm (3/4 in.) sieve"},null,null,null,null,"     min",null,"     max"]
[]
[]
[null,null,"c.","Press the button at right to Select Aggregates"]
[]
[]
[null,null,"d.","Enter aggregate blend Minimum and Maximums (by volume) into the table below                            (leave blank if no blend limitations are desired)"]
[]
[null,null,"Aggregate",null,"Designation","Supplier",null,"Specific Gravity","Minimum1 (%)","Maximum1 (%)","Blend      (by Volume)"]
[]
[null,null,{"$f":"IF(ISBLANK(Calculations!B26)=TRUE,\"\",Calculations!B26)","v":"CA-30 Granite "},null,{"$f":"IF(ISBLANK(Calculations!T26)=TRUE,\"\",Calculations!T26)","v":"G-30"},{"$f":"IF(ISBLANK(Calculations!R26)=TRUE,\"\",Calculations!R26)","v":""},null,{"$f":"IF(ISBLANK(Calculations!C26)=TRUE,\"\",Calculations!C26)","v":2.6},null,null,{"$f":"IF(C48=\"\",\"\",Calculations!Q117/1000)","v":0.61506709595362452}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B29)=TRUE,\"\",Calculations!B29)","v":"Sand "},null,{"$f":"IF(ISBLANK(Calculations!T29)=TRUE,\"\",Calculations!T29)","v":"S-20"},{"$f":"IF(ISBLANK(Calculations!R29)=TRUE,\"\",Calculations!R29)","v":""},null,{"$f":"IF(ISBLANK(Calculations!C29)=TRUE,\"\",Calculations!C29)","v":2.62},null,null,{"$f":"IF(C49=\"\",\"\",Calculations!Q118/1000)","v":0.38493290404637565}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B32)=TRUE,\"\",Calculations!B32)","v":""},null,{"$f":"IF(ISBLANK(Calculations!T32)=TRUE,\"\",Calculations!T32)","v":""},{"$f":"IF(ISBLANK(Calculations!R32)=TRUE,\"\",Calculations!R32)","v":""},null,{"$f":"IF(ISBLANK(Calculations!C32)=TRUE,\"\",Calculations!C32)","v":""},null,null,{"$f":"IF(C50=\"\",\"\",Calculations!Q119/1000)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B35)=TRUE,\"\",Calculations!B35)","v":""},null,{"$f":"IF(ISBLANK(Calculations!T35)=TRUE,\"\",Calculations!T35)","v":""},{"$f":"IF(ISBLANK(Calculations!R35)=TRUE,\"\",Calculations!R35)","v":""},null,{"$f":"IF(ISBLANK(Calculations!C35)=TRUE,\"\",Calculations!C35)","v":""},null,null,{"$f":"IF(C51=\"\",\"\",Calculations!Q120/1000)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B38)=TRUE,\"\",Calculations!B38)","v":""},null,{"$f":"IF(ISBLANK(Calculations!T38)=TRUE,\"\",Calculations!T38)","v":""},{"$f":"IF(ISBLANK(Calculations!R38)=TRUE,\"\",Calculations!R38)","v":""},null,{"$f":"IF(ISBLANK(Calculations!C38)=TRUE,\"\",Calculations!C38)","v":""},null,null,{"$f":"IF(C52=\"\",\"\",Calculations!Q121/1000)","v":""}]
[null,null,"1Minimum and Maximum percent blends must be specified by percent volume of aggregate."]
[]
[]
[null,null,"3.  Select Chemical Admixtures"]
[]
[]
[null,null,"a.","Press the button at right to select an Air Entraining Agent (AEA)"]
[]
[]
[null,null,"b.","Enter the Air Entraining Agent Quantity (US fl oz) into the table below"]
[]
[null,null,"Air Entraining Agent",null,"Producer",null,"Dosage Rate (US fl oz)*",null,"Percent Solids","Specific Gravity","Quantity    (US fl oz)"]
[null,null,null,null,null,null,"min","max"]
[null,null,{"$f":"IF(ISBLANK(Calculations!B12)=TRUE,\"\",Calculations!B12)","v":"Air Entraining Agent"},null,{"$f":"IF(ISBLANK(Calculations!E12)=TRUE,\"\",Calculations!E12)","v":"Air R Us"},null,{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C66=\"\")=TRUE,\"\",Calculations!$C12*Calculations!$H$8/100)","v":0.875},{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C66=\"\")=TRUE,\"\",Calculations!D12*Calculations!$H$8/100)","v":11.2},{"$f":"IF(ISBLANK(Calculations!$J$12)=TRUE,\"\",Calculations!$J$12)","v":0.3},{"$f":"IF(ISBLANK(Calculations!$K$12)=TRUE,\"\",Calculations!$K$12)","v":1.01},21]
[]
[null,null,"c.","Press the button at right to select additional Chemical Admixtures"]
[]
[]
[null,null,"d.","Enter Chemical Admixture Quantities (US fl oz) into the table below"]
[]
[null,null,"Chemical Admixtures",null,"Producer",null,"Dosage Rate (US fl oz)*",null,"Percent Solids","Specific Gravity","Quantity    (US fl oz)"]
[null,null,null,null,null,null,"min","max"]
[null,null,{"$f":"IF(ISBLANK(Calculations!B17)=TRUE,\"\",Calculations!B17)","v":""},null,{"$f":"IF(ISBLANK(Calculations!E17)=TRUE,\"\",Calculations!E17)","v":""},null,{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C75=\"\")=TRUE,\"\",Calculations!$C17*Calculations!$H$8/100)","v":""},{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C75=\"\")=TRUE,\"\",Calculations!D17*Calculations!$H$8/100)","v":""},{"$f":"IF(ISBLANK(Calculations!$I$17)=TRUE,\"\",Calculations!$I$17)","v":""},{"$f":"IF(ISBLANK(Calculations!$J$17)=TRUE,\"\",Calculations!$J$17)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B18)=TRUE,\"\",Calculations!B18)","v":""},null,{"$f":"IF(ISBLANK(Calculations!E18)=TRUE,\"\",Calculations!E18)","v":""},null,{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C76=\"\")=TRUE,\"\",Calculations!$C18*Calculations!$H$8/100)","v":""},{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C76=\"\")=TRUE,\"\",Calculations!D18*Calculations!$H$8/100)","v":""},{"$f":"IF(ISBLANK(Calculations!I18)=TRUE,\"\",Calculations!I18)","v":""},{"$f":"IF(ISBLANK(Calculations!J18)=TRUE,\"\",Calculations!J18)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B19)=TRUE,\"\",Calculations!B19)","v":""},null,{"$f":"IF(ISBLANK(Calculations!E19)=TRUE,\"\",Calculations!E19)","v":""},null,{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C77=\"\")=TRUE,\"\",Calculations!$C19*Calculations!$H$8/100)","v":""},{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C77=\"\")=TRUE,\"\",Calculations!D19*Calculations!$H$8/100)","v":""},{"$f":"IF(ISBLANK(Calculations!I19)=TRUE,\"\",Calculations!I19)","v":""},{"$f":"IF(ISBLANK(Calculations!J19)=TRUE,\"\",Calculations!J19)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B20)=TRUE,\"\",Calculations!B20)","v":""},null,{"$f":"IF(ISBLANK(Calculations!E20)=TRUE,\"\",Calculations!E20)","v":""},null,{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C78=\"\")=TRUE,\"\",Calculations!$C20*Calculations!$H$8/100)","v":""},{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C78=\"\")=TRUE,\"\",Calculations!D20*Calculations!$H$8/100)","v":""},{"$f":"IF(ISBLANK(Calculations!I20)=TRUE,\"\",Calculations!I20)","v":""},{"$f":"IF(ISBLANK(Calculations!J20)=TRUE,\"\",Calculations!J20)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Calculations!B20)=TRUE,\"\",Calculations!B20)","v":""},null,{"$f":"IF(ISBLANK(Calculations!E20)=TRUE,\"\",Calculations!E20)","v":""},null,{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C79=\"\")=TRUE,\"\",Calculations!$C21*Calculations!$H$8/100)","v":""},{"$f":"IF(OR(Calculations!$H$8=0,'Program v.3'!$C79=\"\")=TRUE,\"\",Calculations!D21*Calculations!$H$8/100)","v":""},{"$f":"IF(ISBLANK(Calculations!I21)=TRUE,\"\",Calculations!I21)","v":""},{"$f":"IF(ISBLANK(Calculations!J21)=TRUE,\"\",Calculations!J21)","v":""}]
[null,null,"*Manufacturer's recommended dosage rate per cubic yard"]
[]
[]
[null,null,"4.  Complete and View Concrete Mix Design"]
[]
[]
[null,null,"a.","Press the button at right to optimize the mix design"]
[]
[]
[null,null,"b.","Press a button at right to view the completed mix design or combined aggregate gradation details"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,"OLD Method"]
[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,null,null,null,null,null,null,"MINIMIZE"]
[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,null,null,null,null,null,null,"Difference"]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE69-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE70-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE71-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE72-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE73-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE74-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE75-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE76-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE77-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE78-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE79-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,{"$f":"(Calculations!AE80-Calculations!#REF!)^2","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,"sum",{"$f":"SUM(AK156:AK167)","v":{"$error":"#REF!"}}]

{"sheet":"Aggregates","index":4,"n_rows":200,"n_cols":21,"rows_kept":200,"cut":false,"hidden":false,"merged":[[3,19,5,19],[3,4,3,16],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[3,18,5,18],[4,16,5,16],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,15,5,15],[3,17,5,17],[4,14,5,14],[4,10,5,10],[0,1,2,1],[3,1,5,1],[3,3,5,3],[3,2,5,2]]}
[null,"Aggregate Information"]
[]
[]
[null,"Name","Designation","Specific Gravity","Percent Retained On Each Sieve",null,null,null,null,null,null,null,null,null,null,null,null,"SIEVE CHECK","% Absorption","Supplier"]
[null,null,null,null,"1 1/2\"","1\"","3/4\"","1/2\"","3/8\"","#4","#8","#16","#30","#50","#100","#200","pan",null,null,null,"   Notes:"]
["Name -- Designation"]
[{"$f":"IF(ISBLANK(B7)=TRUE,\"\",IF(C7=\"\",B7,CONCATENATE(B7,\" -- \",C7)))","v":"3/4\" GMQ -- CA-5"},"3/4\" GMQ","CA-5",2.64,0,0,0,0.26,0.26,0.45,0.03,0,0,0,0,0,0,{"$f":"IF(SUM(E7:Q7)=0,\"\",SUM(E7:Q7))","v":1},7.0000000000000001E-3,"GMQ"]
[{"$f":"IF(ISBLANK(B8)=TRUE,\"\",IF(C8=\"\",B8,CONCATENATE(B8,\" -- \",C8)))","v":"1-1/2\" PCCP GMQ -- CA-6"},"1-1/2\" PCCP GMQ","CA-6",2.64,0,0.17,0.27,0.28000000000000003,0.13,0.15,0,0,0,0,0,0,0,{"$f":"IF(SUM(E8:Q8)=0,\"\",SUM(E8:Q8))","v":1},7.0000000000000001E-3,"GMQ"]
["Midwest Concrete Materials -- MA-2","Midwest Concrete Materials","MA-2",2.63,0,0,0,0,0,0.04,0.2,0.26,0.2,0.21,0.09,0,0,0.99999999999999989,1.6299999999999999E-2,"Holliday Sand"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E10:Q10)=0,\"\",SUM(E10:Q10))","v":""}]
["CA-27 Granite>= 3/8\" -- G-27(a)","CA-27 Granite>= 3/8\"","G-27(a)",2.61,0,0,6.0999999999999999E-2,0.54,0.34200000000000003,0,0,0,0,0,0,0,5.7000000000000002E-2,1]
[{"$f":"IF(ISBLANK(B12)=TRUE,\"\",IF(C12=\"\",B12,CONCATENATE(B12,\" -- \",C12)))","v":"CA-27 Granite<= 3/8\"  -- G-27(b)"},"CA-27 Granite<= 3/8\" ","G-27(b)",2.61,0,0,0,0,0,0.88,6.8000000000000005E-2,0,0,0,0,0,5.1999999999999998E-2,1]
["Pea Gravel  -- PG-17","Pea Gravel ","PG-17",2.6,0,0,0,0,0,0.14899999999999999,0.54800000000000004,0.26,3.1E-2,6.0000000000000001E-3,4.0000000000000001E-3,0,2E-3,1]
["Sand  -- S-20","Sand ","S-20",2.62,0,0,0,0,0,1.0999999999999999E-2,0.106,0.22600000000000001,0.26300000000000001,0.314,7.4999999999999997E-2,4.0000000000000001E-3,2E-3,1.0009999999999999]
["Light Weight Aggregate  -- LW-A4","Light Weight Aggregate ","LW-A4",1.54,0,0,0,0,0,0.221,0.75900000000000001,1.4999999999999999E-2,0,0,0,0,4.0000000000000001E-3,0.999]
["CA-28 Granite -- G-28","CA-28 Granite","G-28",2.61,0,7.0000000000000001E-3,9.1999999999999998E-2,0.42,0.20200000000000001,0.23300000000000001,3.5999999999999997E-2,0,0,0,0,0,0.01,1]
["CA-29 Granite -- G-29","CA-29 Granite","G-29",2.61,0,0,1.7999999999999999E-2,0.214,0.216,0.47499999999999998,5.0999999999999997E-2,0,0,0,0,0,2.5999999999999999E-2,1]
["CA-29(2) Granite  -- G-29(2) ","CA-29(2) Granite ","G-29(2) ",2.61,0,0.105,0.13200000000000001,0.19900000000000001,0.182,0.33700000000000002,2.7E-2,0,0,0,0,0,1.7999999999999999E-2,1]
["Sand  -- S-21","Sand ","S-21",2.62,0,0,0,0,0,2.7E-2,9.7000000000000003E-2,0.17799999999999999,0.23599999999999999,0.376,8.1000000000000003E-2,4.0000000000000001E-3,2E-3,1.0009999999999999]
[{"$f":"IF(ISBLANK(B20)=TRUE,\"\",IF(C20=\"\",B20,CONCATENATE(B20,\" -- \",C20)))","v":"CA-30 Granite  -- G-30"},"CA-30 Granite ","G-30",2.6,0,0.13600000000000001,0.126,0.20599999999999999,0.19700000000000001,0.315,1.0999999999999999E-2,0,0,0,0,0,0.01,{"$f":"IF(SUM(E20:Q20)=0,\"\",SUM(E20:Q20))","v":1.0009999999999999}]
[{"$f":"IF(ISBLANK(B21)=TRUE,\"\",IF(C21=\"\",B21,CONCATENATE(B21,\" -- \",C21)))","v":"CA-31 Granite  -- G-31"},"CA-31 Granite ","G-31",2.61,0,7.9000000000000001E-2,5.1999999999999998E-2,0.21,0.249,0.35599999999999998,2.7E-2,0,0,0,0,0,2.7E-2,1]
[{"$f":"IF(ISBLANK(B22)=TRUE,\"\",IF(C22=\"\",B22,CONCATENATE(B22,\" -- \",C22)))","v":"CA-32 Granite  -- G-32"},"CA-32 Granite ","G-32",2.61,0,0,4.7E-2,0.27,0.249,0.36,3.5000000000000003E-2,0,0,0,0,0,0.04,1.0010000000000001]
[{"$f":"IF(ISBLANK(B23)=TRUE,\"\",IF(C23=\"\",B23,CONCATENATE(B23,\" -- \",C23)))","v":"Sand  --  S-22"},"Sand "," S-22",2.6,0,0,0,0,0,2.5000000000000001E-2,0.111,0.17299999999999999,0.245,0.36499999999999999,7.4999999999999997E-2,3.0000000000000001E-3,1E-3,0.998]
[{"$f":"IF(ISBLANK(B24)=TRUE,\"\",IF(C24=\"\",B24,CONCATENATE(B24,\" -- \",C24)))","v":"CA-33 Granite -- G-33"},"CA-33 Granite","G-33",2.61,0,0.20300000000000001,0.17,0.24199999999999999,0.14799999999999999,0.221,7.0000000000000001E-3,0,0,0,0,0,8.9999999999999993E-3,1]
["CA-34 Granite -- G-34","CA-34 Granite","G-34",2.61,0,1E-3,4.1000000000000002E-2,0.316,0.24,0.33700000000000002,3.6999999999999998E-2,0,0,0,0,0,2.8000000000000001E-2,1]
["Sand  -- S-24 ","Sand ","S-24 ",2.61,0,0,0,0,0,2.5000000000000001E-2,0.10199999999999999,0.16800000000000001,0.217,0.317,0.16700000000000001,3.0000000000000001E-3,1E-3,1]
["CA-35 Granite -- G-35","CA-35 Granite","G-35",2.59,0,0,6.6000000000000003E-2,0.38500000000000001,0.23100000000000001,0.26900000000000002,2.5000000000000001E-2,0,0,0,0,0,2.4E-2,1]
["S-24 -- S-24 ","S-24","S-24 ",2.62,0,0,0,0,0,3.5000000000000003E-2,6.9000000000000006E-2,0.10100000000000001,0.188,0.46100000000000002,0.14099999999999999,4.0000000000000001E-3,1E-3,1]
["S-26 -- S-26","S-26","S-26",2.61,0,0,0,0,0,1.9E-2,8.2000000000000003E-2,0.15,0.26,0.377,0.107,3.0000000000000001E-3,2E-3,1]
["Pea Gravel  -- PG-18","Pea Gravel ","PG-18",2.59,0,0,0,0,0,0.04,0.46800000000000003,0.36299999999999999,9.0999999999999998E-2,2.7E-2,6.0000000000000001E-3,2E-3,3.0000000000000001E-3,1]
["G-36 Granite -- G-36","G-36 Granite","G-36",2.58,0,7.0000000000000007E-2,9.5000000000000001E-2,0.20399999999999999,0.17499999999999999,0.35199999999999998,3.9E-2,6.4000000000000001E-2,0,0,0,0,0,0.99900000000000011]
["G-37 Granite  -- G-37 ","G-37 Granite ","G-37 ",2.61,0,0,2.7E-2,0.27400000000000002,0.24,0.36,4.2999999999999997E-2,0,0,0,0,0,5.5E-2,0.99900000000000011]
["S-27 -- S-27","S-27","S-27",2.62,0,0,0,0,0,2.1999999999999999E-2,6.8000000000000005E-2,0.14499999999999999,0.22600000000000001,0.41299999999999998,0.11799999999999999,6.0000000000000001E-3,1E-3,0.99899999999999989]
["G-43 Granite -- G-43","G-43 Granite","G-43",2.61,3.0000000000000001E-3,3.3000000000000002E-2,5.3999999999999999E-2,0.156,0.28399999999999997,0.443,1.4999999999999999E-2,0,0,0,0,0,1.2E-2,1]
["G-41 Granite -- G-41","G-41 Granite","G-41",2.61,0,0,4.9000000000000002E-2,0.316,0.25900000000000001,0.28199999999999997,2.4E-2,0,0,0,0,0,7.0000000000000007E-2,1]
["S-51 -- S-51","S-51","S-51",2.63,0,0,0,0,0,0.02,0.13200000000000001,0.224,0.252,0.248,0.10199999999999999,1.7000000000000001E-2,6.0000000000000001E-3,1.0009999999999999]
["PG-19 -- PG-19","PG-19","PG-19",2.59,0,0,0,0,0,0.161,0.53900000000000003,0.254,3.4000000000000002E-2,6.0000000000000001E-3,3.0000000000000001E-3,0,2E-3,0.99900000000000011]
["",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,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,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,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,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,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,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,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,""]
["",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,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,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,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,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,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,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,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,""]
["",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,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,null,null,null,null,""]
[{"$f":"IF(ISBLANK(B72)=TRUE,\"\",IF(C72=\"\",B72,CONCATENATE(B72,\" -- \",C72)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E72:Q72)=0,\"\",SUM(E72:Q72))","v":""}]
[{"$f":"IF(ISBLANK(B73)=TRUE,\"\",IF(C73=\"\",B73,CONCATENATE(B73,\" -- \",C73)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(ISBLANK(B74)=TRUE,\"\",IF(C74=\"\",B74,CONCATENATE(B74,\" -- \",C74)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(ISBLANK(B75)=TRUE,\"\",IF(C75=\"\",B75,CONCATENATE(B75,\" -- \",C75)))","v":""},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,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,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,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,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,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,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,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,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,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,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,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,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,""]
[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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,""]
[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,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,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,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,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,null,null,null,{"$f":"IF(SUM(E136:Q136)=0,\"\",SUM(E136:Q136))","v":""}]
[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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,""]
[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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,""]
[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,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,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E200:Q200)=0,\"\",SUM(E200:Q200))","v":""}]

{"sheet":"Aggregates (Max-Min)","index":5,"n_rows":75,"n_cols":17,"rows_kept":75,"cut":false,"hidden":false,"merged":[[4,6,5,6],[4,7,5,7],[0,1,2,4],[3,1,5,1],[3,2,5,2],[3,3,3,15],[4,3,5,3],[4,8,5,8],[4,9,5,9],[4,4,5,4],[4,15,5,15],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,5,5,5]]}
[null,"Maximum and Minimum Combined Aggregate Gradation Constraints"]
[]
[]
[null,"Name","Designation                      (Minimum or Maximum)","Percent Retained on Individual Sieves"]
[null,null,null,"1 1/2\"","1\"","3/4\"","1/2\"","3/8\"","#4","#8","#16","#30","#50","#100","#200","pan","   Notes:"]
["Name -- Designation"]
[{"$f":"IF(ISBLANK(B7)=TRUE,\"\",IF(C7=\"\",B7,CONCATENATE(B7,\" -- \",C7)))","v":"8 - 18 Rule -- Min"},"8 - 18 Rule","Min",0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[{"$f":"IF(ISBLANK(B8)=TRUE,\"\",IF(C8=\"\",B8,CONCATENATE(B8,\" -- \",C8)))","v":"8 - 18 Rule -- Max"},"8 - 18 Rule","Max",0.18,0.18,0.18,0.18,0.18,0.18,0.18,0.18,0.18,0.18,0.18,0.18,0.18]
[""]
["KDOT LC-HPC -- Min","KDOT LC-HPC","Min",0,0.02,0.05,0.08,0.08,0.08,0.08,0.08,0.08,0.05,0,0,0]
["KDOT LC-HPC -- Max","KDOT LC-HPC","Max",0,0.06,0.18,0.18,0.18,0.18,0.18,0.18,0.15,0.15,0.05,0.05,0.02]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B72)=TRUE,\"\",IF(C72=\"\",B72,CONCATENATE(B72,\" -- \",C72)))","v":""}]
[{"$f":"IF(ISBLANK(B73)=TRUE,\"\",IF(C73=\"\",B73,CONCATENATE(B73,\" -- \",C73)))","v":""}]
[{"$f":"IF(ISBLANK(B74)=TRUE,\"\",IF(C74=\"\",B74,CONCATENATE(B74,\" -- \",C74)))","v":""}]
[{"$f":"IF(ISBLANK(B75)=TRUE,\"\",IF(C75=\"\",B75,CONCATENATE(B75,\" -- \",C75)))","v":""}]

{"sheet":"AEA","index":6,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[[3,9,5,9],[0,1,2,1],[3,4,3,5],[3,1,5,1],[3,6,5,6],[3,8,5,8],[4,4,4,5],[3,7,5,7],[3,2,5,2],[3,3,5,3]]}
[null,"Air Entraining Agents"]
[]
[]
[null,"Name","Percent Solids","Specific Gravity","Recommended Dosages",null,"Producer","Sample #","Date Obtained","Notes:"]
[null,null,null,null,"(oz per 100 lbs cement)"]
["Material -- Producer -- Sample #",null,null,null,"Minimum","Maximum"]
[{"$f":"IF(ISBLANK(B7)=TRUE,\"\",CONCATENATE(B7, \" -- \", G7, \" -- \", \"# \", H7))","v":"Air Entraining Agent -- Air R Us -- # 1"},"Air Entraining Agent",0.3,1.01,0.125,1.6,"Air R Us",1,"2008-12-23"]
[{"$f":"IF(ISBLANK(B8)=TRUE,\"\",CONCATENATE(B8, \" -- \", G8, \" -- \", \"# \", H8))","v":""}]
["MicroAir -- BASF -- # 1","MicroAir",0.13,1.01,0.125,1.6,"BASF",1,"2009-08-19"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B72)=TRUE,\"\",CONCATENATE(B72, \" -- \", G72, \" -- \", \"# \", H72))","v":""}]
[{"$f":"IF(ISBLANK(B73)=TRUE,\"\",CONCATENATE(B73, \" -- \", G73, \" -- \", \"# \", H73))","v":""}]
[{"$f":"IF(ISBLANK(B74)=TRUE,\"\",CONCATENATE(B74, \" -- \", G74, \" -- \", \"# \", H74))","v":""}]
[{"$f":"IF(ISBLANK(B75)=TRUE,\"\",CONCATENATE(B75, \" -- \", G75, \" -- \", \"# \", H75))","v":""}]

{"sheet":"Admixtures","index":7,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[[3,9,5,9],[0,1,2,1],[3,4,3,5],[3,1,5,1],[3,6,5,6],[3,8,5,8],[4,4,4,5],[3,2,5,2],[3,3,5,3],[3,7,5,7]]}
[null,"Other Admixtures"]
[]
[]
[null,"Name","Percent Solids","Specific Gravity","Recommended Dosages",null,"Producer","Sample #","Date Obtained","Notes:"]
[null,null,null,null,"(oz per 100 lbs cm)"]
["Material -- Producer -- Sample #",null,null,null,"Minimum","Maximum"]
[{"$f":"IF(ISBLANK(B7)=TRUE,\"\",CONCATENATE(B7, \" -- \", G7, \" -- \", \"# \", H7))","v":"Superplasticizer -- Admixtures R Us -- # 1"},"Superplasticizer",0.4,1.0900000000000001,null,null,"Admixtures R Us",1,"2008-12-25"]
[{"$f":"IF(ISBLANK(B8)=TRUE,\"\",CONCATENATE(B8, \" -- \", G8, \" -- \", \"# \", H8))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B72)=TRUE,\"\",CONCATENATE(B72, \" -- \", G72, \" -- \", \"# \", H72))","v":""}]
[{"$f":"IF(ISBLANK(B73)=TRUE,\"\",CONCATENATE(B73, \" -- \", G73, \" -- \", \"# \", H73))","v":""}]
[{"$f":"IF(ISBLANK(B74)=TRUE,\"\",CONCATENATE(B74, \" -- \", G74, \" -- \", \"# \", H74))","v":""}]
[{"$f":"IF(ISBLANK(B75)=TRUE,\"\",CONCATENATE(B75, \" -- \", G75, \" -- \", \"# \", H75))","v":""}]

{"sheet":"Cement","index":8,"n_rows":75,"n_cols":7,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,1,2,2],[3,3,5,3],[3,6,5,6],[3,1,5,1],[3,2,5,2],[3,5,5,5],[3,4,5,4]]}
[null,"Cementitious Materials"]
[]
[]
[null,"Material","Producer","Sample #","Specific Gravity","Date Obtained","Notes:"]
[]
["Material -- Producer -- Sample #"]
[{"$f":"IF(ISBLANK(B7)=TRUE,\"\",CONCATENATE(B7, \" -- \", C7, \" -- \", \"# \", D7))","v":"Type I/II Cement -- Cement Producer -- # 1"},"Type I/II Cement","Cement Producer",1,3.13]
[{"$f":"IF(ISBLANK(B8)=TRUE,\"\",CONCATENATE(B8, \" -- \", C8, \" -- \", \"# \", D8))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B35)=TRUE,\"\",CONCATENATE(B35, \" -- \", C35, \" -- \", \"# \", D35))","v":""}]
[{"$f":"IF(ISBLANK(B36)=TRUE,\"\",CONCATENATE(B36, \" -- \", C36, \" -- \", \"# \", D36))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B73)=TRUE,\"\",CONCATENATE(B73, \" -- \", C73, \" -- \", \"# \", D73))","v":""}]
[{"$f":"IF(ISBLANK(B74)=TRUE,\"\",CONCATENATE(B74, \" -- \", C74, \" -- \", \"# \", D74))","v":""}]
[{"$f":"IF(ISBLANK(B75)=TRUE,\"\",CONCATENATE(B75, \" -- \", C75, \" -- \", \"# \", D75))","v":""}]

{"sheet":"Calculations","index":9,"n_rows":134,"n_cols":43,"rows_kept":134,"cut":false,"hidden":false,"merged":[[65,33,66,34],[65,31,66,32],[0,9,0,10],[113,24,113,25]]}
["Cements Selected",null,null,null,null,null,null,null,null,"Error Check",null,null,"Cement Name"]
[null,"Cement Type","Producer","Sample #","Specific Gravity","Date Obtained","Producer -- Sample","Quantity","# of C.M.","Column",null,"LEFT(22)","LEFT(22)"]
["Type I/II Cement -- Cement Producer -- # 1",{"$f":"IF(IF($A3=\"\",\"\",VLOOKUP($A3,Cement!$A$7:$G$75,2,FALSE))=0,\"\",IF($A3=\"\",\"\",VLOOKUP($A3,Cement!$A$7:$G$75,2,FALSE)))","v":"Type I/II Cement"},{"$f":"IF(IF($A3=\"\",\"\",VLOOKUP($A3,Cement!$A$7:$G$75,3,FALSE))=0,\"\",IF($A3=\"\",\"\",VLOOKUP($A3,Cement!$A$7:$G$75,3,FALSE)))","v":"Cement Producer"},{"$f":"IF(IF($A3=\"\",\"\",VLOOKUP($A3,Cement!$A$7:$G$75,4,FALSE))=0,\"\",IF($A3=\"\",\"\",VLOOKUP($A3,Cement!$A$7:$G$75,4,FALSE)))","v":1},{"$f":"IF(IF($A3=\"\",\"\",VLOOKUP($A3,Cement!$A$7:$G$75,5,FALSE))=0,\"\",IF($A3=\"\",\"\",VLOOKUP($A3,Cement!$A$7:$G$75,5,FALSE)))","v":3.13},{"$f":"IF(IF($A3=\"\",\"\",VLOOKUP($A3,Cement!$A$7:$G$75,6,FALSE))=0,\"\",IF($A3=\"\",\"\",VLOOKUP($A3,Cement!$A$7:$G$75,6,FALSE)))","v":""},{"$f":"IF(D3=\"\",C3,CONCATENATE(C3,\"-- #\",D3))","v":"Cement Producer-- #1"},{"$f":"'Program v.3'!K19","v":700},{"$f":"COUNTA(cementc)","v":1},"B",{"$f":"IF(OR(ISERROR($B$3)=TRUE, ISERROR($B$4)=TRUE,ISERROR($B$5)=TRUE,ISERROR($B$6)=TRUE, ISERROR($B$7)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},{"$f":"LEFT(C3,22)","v":"Cement Producer"},{"$f":"LEFT(B3,22)","v":"Type I/II Cement"}]
[null,{"$f":"IF(IF($A4=\"\",\"\",VLOOKUP($A4,Cement!$A$7:$G$75,2,FALSE))=0,\"\",IF($A4=\"\",\"\",VLOOKUP($A4,Cement!$A$7:$G$75,2,FALSE)))","v":""},{"$f":"IF(IF($A4=\"\",\"\",VLOOKUP($A4,Cement!$A$7:$G$75,3,FALSE))=0,\"\",IF($A4=\"\",\"\",VLOOKUP($A4,Cement!$A$7:$G$75,3,FALSE)))","v":""},{"$f":"IF(IF($A4=\"\",\"\",VLOOKUP($A4,Cement!$A$7:$G$75,4,FALSE))=0,\"\",IF($A4=\"\",\"\",VLOOKUP($A4,Cement!$A$7:$G$75,4,FALSE)))","v":""},{"$f":"IF(IF($A4=\"\",\"\",VLOOKUP($A4,Cement!$A$7:$G$75,5,FALSE))=0,\"\",IF($A4=\"\",\"\",VLOOKUP($A4,Cement!$A$7:$G$75,5,FALSE)))","v":""},{"$f":"IF(IF($A4=\"\",\"\",VLOOKUP($A4,Cement!$A$7:$G$75,6,FALSE))=0,\"\",IF($A4=\"\",\"\",VLOOKUP($A4,Cement!$A$7:$G$75,6,FALSE)))","v":""},{"$f":"IF(D4=\"\",C4,CONCATENATE(C4,\"-- #\",D4))","v":""},{"$f":"'Program v.3'!K20","v":0},null,"C",{"$f":"IF(OR(ISERROR($C$3)=TRUE, ISERROR($C$4)=TRUE,ISERROR($C$5)=TRUE,ISERROR($C$6)=TRUE, ISERROR($C$7)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},{"$f":"LEFT(C4,22)","v":""},{"$f":"LEFT(B4,22)","v":""}]
[null,{"$f":"IF(IF($A5=\"\",\"\",VLOOKUP($A5,Cement!$A$7:$G$75,2,FALSE))=0,\"\",IF($A5=\"\",\"\",VLOOKUP($A5,Cement!$A$7:$G$75,2,FALSE)))","v":""},{"$f":"IF(IF($A5=\"\",\"\",VLOOKUP($A5,Cement!$A$7:$G$75,3,FALSE))=0,\"\",IF($A5=\"\",\"\",VLOOKUP($A5,Cement!$A$7:$G$75,3,FALSE)))","v":""},{"$f":"IF(IF($A5=\"\",\"\",VLOOKUP($A5,Cement!$A$7:$G$75,4,FALSE))=0,\"\",IF($A5=\"\",\"\",VLOOKUP($A5,Cement!$A$7:$G$75,4,FALSE)))","v":""},{"$f":"IF(IF($A5=\"\",\"\",VLOOKUP($A5,Cement!$A$7:$G$75,5,FALSE))=0,\"\",IF($A5=\"\",\"\",VLOOKUP($A5,Cement!$A$7:$G$75,5,FALSE)))","v":""},{"$f":"IF(IF($A5=\"\",\"\",VLOOKUP($A5,Cement!$A$7:$G$75,6,FALSE))=0,\"\",IF($A5=\"\",\"\",VLOOKUP($A5,Cement!$A$7:$G$75,6,FALSE)))","v":""},{"$f":"IF(D5=\"\",C5,CONCATENATE(C5,\"-- #\",D5))","v":""},{"$f":"'Program v.3'!K21","v":0},null,"D",{"$f":"IF(OR(ISERROR($D$3)=TRUE, ISERROR($D$4)=TRUE,ISERROR($D$5)=TRUE,ISERROR($D$6)=TRUE, ISERROR($D$7)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},{"$f":"LEFT(C5,22)","v":""},{"$f":"LEFT(B5,22)","v":""}]
[null,{"$f":"IF(IF($A6=\"\",\"\",VLOOKUP($A6,Cement!$A$7:$G$75,2,FALSE))=0,\"\",IF($A6=\"\",\"\",VLOOKUP($A6,Cement!$A$7:$G$75,2,FALSE)))","v":""},{"$f":"IF(IF($A6=\"\",\"\",VLOOKUP($A6,Cement!$A$7:$G$75,3,FALSE))=0,\"\",IF($A6=\"\",\"\",VLOOKUP($A6,Cement!$A$7:$G$75,3,FALSE)))","v":""},{"$f":"IF(IF($A6=\"\",\"\",VLOOKUP($A6,Cement!$A$7:$G$75,4,FALSE))=0,\"\",IF($A6=\"\",\"\",VLOOKUP($A6,Cement!$A$7:$G$75,4,FALSE)))","v":""},{"$f":"IF(IF($A6=\"\",\"\",VLOOKUP($A6,Cement!$A$7:$G$75,5,FALSE))=0,\"\",IF($A6=\"\",\"\",VLOOKUP($A6,Cement!$A$7:$G$75,5,FALSE)))","v":""},{"$f":"IF(IF($A6=\"\",\"\",VLOOKUP($A6,Cement!$A$7:$G$75,6,FALSE))=0,\"\",IF($A6=\"\",\"\",VLOOKUP($A6,Cement!$A$7:$G$75,6,FALSE)))","v":""},{"$f":"IF(D6=\"\",C6,CONCATENATE(C6,\"-- #\",D6))","v":""},{"$f":"'Program v.3'!K22","v":0},null,"E",{"$f":"IF(OR(ISERROR($E$3)=TRUE, ISERROR($E$4)=TRUE,ISERROR($E$5)=TRUE,ISERROR($E$6)=TRUE, ISERROR($E$7)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},{"$f":"LEFT(C6,22)","v":""},{"$f":"LEFT(B6,22)","v":""}]
[null,{"$f":"IF(IF($A7=\"\",\"\",VLOOKUP($A7,Cement!$A$7:$G$75,2,FALSE))=0,\"\",IF($A7=\"\",\"\",VLOOKUP($A7,Cement!$A$7:$G$75,2,FALSE)))","v":""},{"$f":"IF(IF($A7=\"\",\"\",VLOOKUP($A7,Cement!$A$7:$G$75,3,FALSE))=0,\"\",IF($A7=\"\",\"\",VLOOKUP($A7,Cement!$A$7:$G$75,3,FALSE)))","v":""},{"$f":"IF(IF($A7=\"\",\"\",VLOOKUP($A7,Cement!$A$7:$G$75,4,FALSE))=0,\"\",IF($A7=\"\",\"\",VLOOKUP($A7,Cement!$A$7:$G$75,4,FALSE)))","v":""},{"$f":"IF(IF($A7=\"\",\"\",VLOOKUP($A7,Cement!$A$7:$G$75,5,FALSE))=0,\"\",IF($A7=\"\",\"\",VLOOKUP($A7,Cement!$A$7:$G$75,5,FALSE)))","v":""},{"$f":"IF(IF($A7=\"\",\"\",VLOOKUP($A7,Cement!$A$7:$G$75,6,FALSE))=0,\"\",IF($A7=\"\",\"\",VLOOKUP($A7,Cement!$A$7:$G$75,6,FALSE)))","v":""},{"$f":"IF(D7=\"\",C7,CONCATENATE(C7,\"-- #\",D7))","v":""},{"$f":"'Program v.3'!K23","v":0},null,"F",{"$f":"IF(OR(ISERROR($F$3)=TRUE, ISERROR($F$4)=TRUE,ISERROR($F$5)=TRUE,ISERROR($F$6)=TRUE, ISERROR($F$7)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},{"$f":"LEFT(C7,22)","v":""},{"$f":"LEFT(B7,22)","v":""}]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H7)","v":700},null,null,{"$f":"IF(OR(K3=\"Error\",K4=\"Error\",K5=\"Error\",K6=\"Error\",K7=\"Error\"), 1,0)","v":0}]
[]
[]
["Air Entraining Agents","Name","Minimum","Maximum","Producer","Sample #","Date Obtained","min/max","Quantity","% Solids","S.G.","# of AEA","Error Check","Name","Producer"]
["Air Entraining Agent -- Air R Us -- # 1",{"$f":"IF(IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,2,FALSE))=0,\"\",IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,2,FALSE)))","v":"Air Entraining Agent"},{"$f":"IF(IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,5,FALSE))=0,\"\",IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,5,FALSE)))","v":0.125},{"$f":"IF(IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,6,FALSE))=0,\"\",IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,6,FALSE)))","v":1.6},{"$f":"IF(IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,7,FALSE))=0,\"\",IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,7,FALSE)))","v":"Air R Us"},{"$f":"IF(IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,8,FALSE))=0,\"\",IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,8,FALSE)))","v":1},{"$f":"IF(IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,9,FALSE))=0,\"\",IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,9,FALSE)))","v":39805},{"$f":"IF(A12=\"\",\"\",CONCATENATE(C12,\" / \",D12))","v":"0.125 / 1.6"},{"$f":"AEAQ","v":21},{"$f":"IF(A12=\"\",\"\",IF(VLOOKUP($A12,AEA!$A$7:$I$75,3,FALSE)=\"\",\"0\",VLOOKUP($A12,AEA!$A$7:$I$75,3,FALSE)))","v":0.3},{"$f":"IF(IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,4,FALSE))=0,\"\",IF($A12=\"\",\"\",VLOOKUP($A12,AEA!$A$7:$I$75,4,FALSE)))","v":1.01},{"$f":"COUNTA(A12)","v":1},{"$f":"IF(OR(ISERROR($B$12)=TRUE, ISERROR($E$12)=TRUE,ISERROR($C$12)=TRUE,ISERROR($F$12)=TRUE, ISERROR($D$12)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},"LEFT(25)","LEFT(25)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M12=\"Error\",1,0)","v":0},{"$f":"LEFT(B12,25)","v":"Air Entraining Agent"},{"$f":"LEFT(E12,25)","v":"Air R Us"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name","Producer"]
["Chemical Admixtures","Name","Minimum","Maximum","Producer","Sample #","Date Obtained","min/max","% Solids","S.G.","Quantity","# of Chem","Column","Error Check",null,"LEFT(25)","LEFT(25)"]
[null,{"$f":"IF(IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$G$75,2,FALSE))=0,\"\",IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$G$75,2,FALSE)))","v":""},{"$f":"IF(IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$G$75,5,FALSE))=0,\"\",IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$G$75,5,FALSE)))","v":""},{"$f":"IF(IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$G$75,6,FALSE))=0,\"\",IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$G$75,6,FALSE)))","v":""},{"$f":"IF(IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$G$75,7,FALSE))=0,\"\",IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$G$75,7,FALSE)))","v":""},{"$f":"IF(IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$I$75,8,FALSE))=0,\"\",IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$I$75,8,FALSE)))","v":""},{"$f":"IF(IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$I$75,9,FALSE))=0,\"\",IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$I$75,9,FALSE)))","v":""},{"$f":"IF(A17=\"\",\"\",CONCATENATE(C17,\" / \",D17))","v":""},{"$f":"IF(A17=\"\",\"\",IF(VLOOKUP($A17,Admixtures!$A$7:$I$75,3,FALSE)=\"\",\"0\",VLOOKUP($A17,Admixtures!$A$7:$I$75,3,FALSE)))","v":""},{"$f":"IF(IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$I$75,4,FALSE))=\"\",\"\",IF($A17=\"\",\"\",VLOOKUP($A17,Admixtures!$A$7:$I$75,4,FALSE)))","v":""},{"$f":"'Program v.3'!K75","v":0},{"$f":"COUNTA(CHEMc)","v":0},"B",{"$f":"IF(OR(ISERROR($B$17)=TRUE, ISERROR($B$18)=TRUE,ISERROR($B$19)=TRUE,ISERROR($B$20)=TRUE, ISERROR($B$21)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},null,{"$f":"LEFT(B17,25)","v":""},{"$f":"LEFT(E17,25)","v":""}]
[null,{"$f":"IF(IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$G$75,2,FALSE))=0,\"\",IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$G$75,2,FALSE)))","v":""},{"$f":"IF(IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$G$75,5,FALSE))=0,\"\",IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$G$75,5,FALSE)))","v":""},{"$f":"IF(IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$G$75,6,FALSE))=0,\"\",IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$G$75,6,FALSE)))","v":""},{"$f":"IF(IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$G$75,7,FALSE))=0,\"\",IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$G$75,7,FALSE)))","v":""},{"$f":"IF(IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$I$75,8,FALSE))=0,\"\",IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$I$75,8,FALSE)))","v":""},{"$f":"IF(IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$I$75,9,FALSE))=0,\"\",IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$I$75,9,FALSE)))","v":""},{"$f":"IF(A18=\"\",\"\",CONCATENATE(C18,\" / \",D18))","v":""},{"$f":"IF(A18=\"\",\"\",IF(VLOOKUP($A18,Admixtures!$A$7:$I$75,3,FALSE)=\"\",\"0\",VLOOKUP($A18,Admixtures!$A$7:$I$75,3,FALSE)))","v":""},{"$f":"IF(IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$I$75,4,FALSE))=\"\",\"\",IF($A18=\"\",\"\",VLOOKUP($A18,Admixtures!$A$7:$I$75,4,FALSE)))","v":""},{"$f":"'Program v.3'!K76","v":0},null,"C",{"$f":"IF(OR(ISERROR($C$17)=TRUE, ISERROR($C$18)=TRUE,ISERROR($C$19)=TRUE,ISERROR($C$20)=TRUE, ISERROR($C$21)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},"Errors",{"$f":"LEFT(B18,25)","v":""},{"$f":"LEFT(E18,25)","v":""}]
[null,{"$f":"IF(IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$G$75,2,FALSE))=0,\"\",IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$G$75,2,FALSE)))","v":""},{"$f":"IF(IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$G$75,5,FALSE))=0,\"\",IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$G$75,5,FALSE)))","v":""},{"$f":"IF(IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$G$75,6,FALSE))=0,\"\",IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$G$75,6,FALSE)))","v":""},{"$f":"IF(IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$G$75,7,FALSE))=0,\"\",IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$G$75,7,FALSE)))","v":""},{"$f":"IF(IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$I$75,8,FALSE))=0,\"\",IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$I$75,8,FALSE)))","v":""},{"$f":"IF(IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$I$75,9,FALSE))=0,\"\",IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$I$75,9,FALSE)))","v":""},{"$f":"IF(A19=\"\",\"\",CONCATENATE(C19,\" / \",D19))","v":""},{"$f":"IF(A19=\"\",\"\",IF(VLOOKUP($A19,Admixtures!$A$7:$I$75,3,FALSE)=\"\",\"0\",VLOOKUP($A19,Admixtures!$A$7:$I$75,3,FALSE)))","v":""},{"$f":"IF(IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$I$75,4,FALSE))=\"\",\"\",IF($A19=\"\",\"\",VLOOKUP($A19,Admixtures!$A$7:$I$75,4,FALSE)))","v":""},{"$f":"'Program v.3'!K77","v":0},null,"D",{"$f":"IF(OR(ISERROR($D$17)=TRUE, ISERROR($D$18)=TRUE,ISERROR($D$19)=TRUE,ISERROR($D$20)=TRUE, ISERROR($D$21)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},{"$f":"IF(OR(N17=\"Error\",N18=\"Error\",N19=\"Error\",N20=\"Error\",N21=\"Error\"), 1,0)","v":0},{"$f":"LEFT(B19,25)","v":""},{"$f":"LEFT(E19,25)","v":""}]
[null,{"$f":"IF(IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$G$75,2,FALSE))=0,\"\",IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$G$75,2,FALSE)))","v":""},{"$f":"IF(IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$G$75,5,FALSE))=0,\"\",IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$G$75,5,FALSE)))","v":""},{"$f":"IF(IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$G$75,6,FALSE))=0,\"\",IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$G$75,6,FALSE)))","v":""},{"$f":"IF(IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$G$75,7,FALSE))=0,\"\",IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$G$75,7,FALSE)))","v":""},{"$f":"IF(IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$I$75,8,FALSE))=0,\"\",IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$I$75,8,FALSE)))","v":""},{"$f":"IF(IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$I$75,9,FALSE))=0,\"\",IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$I$75,9,FALSE)))","v":""},{"$f":"IF(A20=\"\",\"\",CONCATENATE(C20,\" / \",D20))","v":""},{"$f":"IF(A20=\"\",\"\",IF(VLOOKUP($A20,Admixtures!$A$7:$I$75,3,FALSE)=\"\",\"0\",VLOOKUP($A20,Admixtures!$A$7:$I$75,3,FALSE)))","v":""},{"$f":"IF(IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$I$75,4,FALSE))=\"\",\"\",IF($A20=\"\",\"\",VLOOKUP($A20,Admixtures!$A$7:$I$75,4,FALSE)))","v":""},{"$f":"'Program v.3'!K78","v":0},null,"F",{"$f":"IF(OR(ISERROR($F$17)=TRUE, ISERROR($F$18)=TRUE,ISERROR($F$19)=TRUE,ISERROR($F$20)=TRUE, ISERROR($F$21)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},null,{"$f":"LEFT(B20,25)","v":""},{"$f":"LEFT(E20,25)","v":""}]
[null,{"$f":"IF(IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$G$75,2,FALSE))=0,\"\",IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$G$75,2,FALSE)))","v":""},{"$f":"IF(IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$G$75,5,FALSE))=0,\"\",IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$G$75,5,FALSE)))","v":""},{"$f":"IF(IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$G$75,6,FALSE))=0,\"\",IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$G$75,6,FALSE)))","v":""},{"$f":"IF(IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$G$75,7,FALSE))=0,\"\",IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$G$75,7,FALSE)))","v":""},{"$f":"IF(IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$I$75,8,FALSE))=0,\"\",IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$I$75,8,FALSE)))","v":""},{"$f":"IF(IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$I$75,9,FALSE))=0,\"\",IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$I$75,9,FALSE)))","v":""},{"$f":"IF(A21=\"\",\"\",CONCATENATE(C21,\" / \",D21))","v":""},{"$f":"IF(A21=\"\",\"\",IF(VLOOKUP($A21,Admixtures!$A$7:$I$75,3,FALSE)=\"\",\"0\",VLOOKUP($A21,Admixtures!$A$7:$I$75,3,FALSE)))","v":""},{"$f":"IF(IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$I$75,4,FALSE))=\"\",\"\",IF($A21=\"\",\"\",VLOOKUP($A21,Admixtures!$A$7:$I$75,4,FALSE)))","v":""},{"$f":"'Program v.3'!K79","v":0},null,"H",{"$f":"IF(OR(ISERROR($H$17)=TRUE, ISERROR($H$18)=TRUE,ISERROR($H$19)=TRUE,ISERROR($H$20)=TRUE, ISERROR($F$21)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},null,{"$f":"LEFT(B21,25)","v":""},{"$f":"LEFT(E21,25)","v":""},null,null,null,null,null,"Percent","Aggregate","Aggregate"]
["Limit Name","Min / Max","Min / Max","Left(3)","1 1/2\"","1\"","3/4\"","1/2\"","3/8\"","#4","#8","#16","#30","#50","#100","#200","pan","Errors By Row",null,"Errors","Number",null,"Retained on","S.G.","FM"]
["KDOT LC-HPC -- Min",{"$f":"IF(IF($A23=\"\",\"\",VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,2,FALSE))=0,\"0.00\",IF($A23=\"\",\"\",VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,2,FALSE)))","v":"KDOT LC-HPC"},{"$f":"IF(IF($A23=\"\",\"\",VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,3,FALSE))=0,\"0.00\",IF($A23=\"\",\"\",VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,3,FALSE)))","v":"Min"},{"$f":"LEFT(C23,3)","v":"Min"},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,4,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,4,FALSE)))","v":0},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,5,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,5,FALSE)))","v":0.02},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,6,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,6,FALSE)))","v":0.05},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,7,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,7,FALSE)))","v":0.08},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,8,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,8,FALSE)))","v":0.08},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,9,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,9,FALSE)))","v":0.08},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,10,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,10,FALSE)))","v":0.08},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,11,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,11,FALSE)))","v":0.08},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,12,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,12,FALSE)))","v":0.08},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,13,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,13,FALSE)))","v":0.05},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,14,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,14,FALSE)))","v":0},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,15,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,15,FALSE)))","v":0},{"$f":"IF(IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,16,FALSE))=0,0,IF($A23=\"\",0,VLOOKUP($A23,'Aggregates (Max-Min)'!$A$7:$S$75,16,FALSE)))","v":0},{"$f":"IF(OR(ISERROR($B$23)=TRUE, ISERROR($E$23)=TRUE,ISERROR($C$23)=TRUE,ISERROR($F$23)=TRUE, ISERROR($D$23)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},{"$f":"IF(R23=\"none\",0,1)","v":0},{"$f":"SUM(S23:S24)","v":0},{"$f":"IF(A23=\"\",0,1)","v":1},"Sum","#16 - pan"]
["KDOT LC-HPC -- Max",{"$f":"IF(IF($A24=\"\",\"\",VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,2,FALSE))=0,\"0.00\",IF($A24=\"\",\"\",VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,2,FALSE)))","v":"KDOT LC-HPC"},{"$f":"IF(IF($A24=\"\",\"\",VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,3,FALSE))=0,\"0.00\",IF($A24=\"\",\"\",VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,3,FALSE)))","v":"Max"},{"$f":"LEFT(C24,3)","v":"Max"},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,4,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,4,FALSE)))","v":0},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,5,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,5,FALSE)))","v":0.06},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,6,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,6,FALSE)))","v":0.18},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,7,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,7,FALSE)))","v":0.18},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,8,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,8,FALSE)))","v":0.18},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,9,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,9,FALSE)))","v":0.18},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,10,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,10,FALSE)))","v":0.18},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,11,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,11,FALSE)))","v":0.18},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,12,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,12,FALSE)))","v":0.15},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,13,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,13,FALSE)))","v":0.15},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,14,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,14,FALSE)))","v":0.05},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,15,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,15,FALSE)))","v":0.05},{"$f":"IF(IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,16,FALSE))=0,0,IF($A24=\"\",0,VLOOKUP($A24,'Aggregates (Max-Min)'!$A$7:$S$75,16,FALSE)))","v":0.02},{"$f":"IF(OR(ISERROR($B$24)=TRUE, ISERROR($E$24)=TRUE,ISERROR($C$24)=TRUE,ISERROR($F$24)=TRUE, ISERROR($D$24)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},{"$f":"IF(R24=\"none\",0,1)","v":0},null,{"$f":"IF(A24=\"\",0,1)","v":1},{"$f":"SUM(U23:U24)","v":2}]
["Aggregates","Name","Specific Gravity",null,"1 1/2\"","1\"","3/4\"","1/2\"","3/8\"","#4","#8","#16","#30","#50","#100","#200","pan","Supplier","% Absorption","Designation",null,"Errors"]
["CA-30 Granite  -- G-30",{"$f":"IF(IF($A26=\"\",\"\",VLOOKUP($A26,Aggregates!$A$7:$T$200,2,FALSE))=0,\"\",IF($A26=\"\",\"\",VLOOKUP($A26,Aggregates!$A$7:$T$200,2,FALSE)))","v":"CA-30 Granite "},{"$f":"IF(IF($A26=\"\",\"\",VLOOKUP($A26,Aggregates!$A$7:$T$200,4,FALSE))=0,\"\",IF($A26=\"\",\"\",VLOOKUP($A26,Aggregates!$A$7:$T$200,4,FALSE)))","v":2.6},{"$f":"T27","v":"G-30"},{"$f":"IF(ISERROR(E27)=TRUE,0,E27)","v":"0.00"},{"$f":"IF(ISERROR(E26+F27)=TRUE,0,E26+F27)","v":0.1358641358641359},{"$f":"IF(ISERROR(F26+G27)=TRUE,0,F26+G27)","v":0.26173826173826176},0.46753246753246758,0.66433566433566438,0.97902097902097918,0.99000999000999013,0.99000999000999013,0.99000999000999013,0.99000999000999013,0.99000999000999013,0.99000999000999013,1.0000000000000002,{"$f":"IF(IF($A26=\"\",\"\",VLOOKUP($A26,Aggregates!$A$7:$T$200,19,FALSE))=0,\"\",IF($A26=\"\",\"\",VLOOKUP($A26,Aggregates!$A$7:$T$200,19,FALSE)))","v":""},{"$f":"IF(IF($A26=\"\",\"\",VLOOKUP($A26,Aggregates!$A$7:$T$200,19,FALSE))=0,\"\",IF($A26=\"\",\"\",VLOOKUP($A26,Aggregates!$A$7:$T$200,19,FALSE)))","v":""},{"$f":"IF(IF($A26=\"\",\"\",VLOOKUP($A26,Aggregates!$A$7:$T$200,3,FALSE))=0,\"\",IF($A26=\"\",\"\",VLOOKUP($A26,Aggregates!$A$7:$T$200,3,FALSE)))","v":"G-30"},null,{"$f":"IF(OR(ISERROR($B$26)=TRUE, ISERROR($C$26)=TRUE,ISERROR($E$27)=TRUE,ISERROR($F$27)=TRUE, ISERROR($G$27)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},null,null,{"$f":"SUM(E26,G26,I26,J26,K26,L26,M26,N26,O26)","v":6.8551448551448555}]
[{"$f":"LEFT(A26,14)","v":"CA-30 Granite "},{"$f":"LEFT(B26,30)","v":"CA-30 Granite "},null,{"$f":"T27","v":"G-30"},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,5,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,5,FALSE)*1/T28))","v":"0.00"},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,6,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,6,FALSE)*1/T28))","v":0.1358641358641359},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,7,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,7,FALSE)*1/T28))","v":0.12587412587412589},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,8,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,8,FALSE)*1/T28))","v":0.20579420579420579},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,9,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,9,FALSE)*1/T28))","v":0.19680319680319683},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,10,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,10,FALSE)*1/T28))","v":0.31468531468531474},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,11,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,11,FALSE)*1/T28))","v":1.098901098901099E-2},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,12,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,12,FALSE)*1/T28))","v":"0.00"},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,13,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,13,FALSE)*1/T28))","v":"0.00"},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,14,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,14,FALSE)*1/T28))","v":"0.00"},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,15,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,15,FALSE)*1/T28))","v":"0.00"},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,16,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,16,FALSE)*1/T28))","v":"0.00"},{"$f":"IF(IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,17,FALSE))=0,\"0.00\",IF($A$26=\"\",0,VLOOKUP($A$26,Aggregates!$A$7:$T$200,17,FALSE)*1/T28))","v":9.9900099900099917E-3},null,{"$f":"IF(ISERROR(S26*100)=TRUE,\"unknown\",S26*100)","v":"unknown"},{"$f":"LEFT(T26,15)","v":"G-30"},"# of Agg.",{"$f":"IF(V26=\"none\",0,1)","v":0},{"$f":"IF(ISBLANK(A26)=TRUE,\"\",SUM(L27:Q27))","v":9.9900099900099917E-3},{"$f":"C26","v":2.6}]
[null,null,null,{"$f":"T27","v":"G-30"},{"$f":"IF(ISERROR(1-E26)=TRUE,\"\",1-E26)","v":1},{"$f":"IF(ISERROR(1-F26)=TRUE,\"\",1-F26)","v":0.86413586413586407},0.73826173826173824,0.53246753246753242,0.33566433566433562,2.0979020979020824E-2,9.9900099900098738E-3,9.9900099900098738E-3,9.9900099900098738E-3,9.9900099900098738E-3,9.9900099900098738E-3,9.9900099900098738E-3,-2.2204460492503131E-16,null,{"$f":"IF($A$26=\"\",\"\",SUM(E27:Q27))","v":1.0000000000000002},{"$f":"IF($A$26=\"\",\"\",SUM(VLOOKUP($A$26,Aggregates!$A$7:$T$200,5,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,6,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,7,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,8,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,9,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,10,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,11,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,12,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,13,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,14,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,15,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,16,FALSE)+VLOOKUP($A$26,Aggregates!$A$7:$T$200,17,FALSE)))","v":1.0009999999999999},{"$f":"COUNTA(A26,A29,A32,A35,A38)","v":2}]
["Sand  -- S-20",{"$f":"IF(IF($A29=\"\",\"\",VLOOKUP($A29,Aggregates!$A$7:$T$200,2,FALSE))=0,\"\",IF($A29=\"\",\"\",VLOOKUP($A29,Aggregates!$A$7:$T$200,2,FALSE)))","v":"Sand "},{"$f":"IF(IF($A29=\"\",\"\",VLOOKUP($A29,Aggregates!$A$7:$T$200,4,FALSE))=0,\"\",IF($A29=\"\",\"\",VLOOKUP($A29,Aggregates!$A$7:$T$200,4,FALSE)))","v":2.62},{"$f":"T30","v":"S-20"},{"$f":"IF(ISERROR(E30)=TRUE,0,E30)","v":"0.00"},{"$f":"IF(ISERROR(E29+F30)=TRUE,0,E29+F30)","v":0},0,0,0,1.098901098901099E-2,0.11688311688311689,0.34265734265734271,0.60539460539460555,0.91908091908091927,0.99400599400599421,0.99800199800199818,1.0000000000000002,{"$f":"IF(IF($A29=\"\",\"\",VLOOKUP($A29,Aggregates!$A$7:$T$200,19,FALSE))=0,\"\",IF($A29=\"\",\"\",VLOOKUP($A29,Aggregates!$A$7:$T$200,19,FALSE)))","v":""},{"$f":"IF(IF($A29=\"\",\"\",VLOOKUP($A29,Aggregates!$A$7:$T$200,19,FALSE))=0,\"\",IF($A29=\"\",\"\",VLOOKUP($A29,Aggregates!$A$7:$T$200,19,FALSE)))","v":""},{"$f":"IF(IF($A29=\"\",\"\",VLOOKUP($A29,Aggregates!$A$7:$T$200,3,FALSE))=0,\"\",IF($A29=\"\",\"\",VLOOKUP($A29,Aggregates!$A$7:$T$200,3,FALSE)))","v":"S-20"},null,{"$f":"IF(OR(ISERROR($B$29)=TRUE, ISERROR($C$29)=TRUE,ISERROR($E$30)=TRUE,ISERROR($F$30)=TRUE, ISERROR($G$30)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},null,null,{"$f":"SUM(E29,G29,I29,J29,K29,L29,M29,N29,O29)","v":2.9890109890109895}]
[{"$f":"LEFT(A29,14)","v":"Sand  -- S-20"},{"$f":"LEFT(B29,30)","v":"Sand "},null,{"$f":"T30","v":"S-20"},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,5,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,5,FALSE)*1/T31))","v":"0.00"},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,6,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,6,FALSE)*1/T31))","v":"0.00"},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,7,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,7,FALSE)*1/T31))","v":"0.00"},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,8,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,8,FALSE)*1/T31))","v":"0.00"},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,9,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,9,FALSE)*1/T31))","v":"0.00"},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,10,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,10,FALSE)*1/T31))","v":1.098901098901099E-2},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,11,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,11,FALSE)*1/T31))","v":0.1058941058941059},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,12,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,12,FALSE)*1/T31))","v":0.22577422577422582},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,13,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,13,FALSE)*1/T31))","v":0.26273726273726278},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,14,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,14,FALSE)*1/T31))","v":0.31368631368631372},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,15,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,15,FALSE)*1/T31))","v":7.4925074925074928E-2},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,16,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,16,FALSE)*1/T31))","v":3.9960039960039969E-3},{"$f":"IF(IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,17,FALSE))=0,\"0.00\",IF($A$29=\"\",0,VLOOKUP($A$29,Aggregates!$A$7:$T$200,17,FALSE)*1/T31))","v":1.9980019980019984E-3},null,{"$f":"IF(ISERROR(S29*100)=TRUE,\"unknown\",S29*100)","v":"unknown"},{"$f":"LEFT(T29,15)","v":"S-20"},null,{"$f":"IF(V29=\"none\",0,1)","v":0},{"$f":"IF(ISBLANK(A29)=TRUE,\"\",SUM(L30:Q30))","v":0.8831168831168833},{"$f":"C29","v":2.62}]
[null,null,null,{"$f":"T30","v":"S-20"},{"$f":"IF(ISERROR(1-E29)=TRUE,\"\",1-E29)","v":1},{"$f":"IF(ISERROR(1-F29)=TRUE,\"\",1-F29)","v":1},{"$f":"IF(ISERROR(1-G29)=TRUE,\"\",1-G29)","v":1},1,1,0.98901098901098905,0.88311688311688308,0.65734265734265729,0.39460539460539445,8.0919080919080733E-2,5.994005994005791E-3,1.9980019980018193E-3,-2.2204460492503131E-16,null,{"$f":"IF($A$29=\"\",\"\",SUM(E30:Q30))","v":1.0000000000000002},{"$f":"IF($A$29=\"\",\"\",SUM(VLOOKUP($A$29,Aggregates!$A$7:$T$200,5,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,6,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,7,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,8,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,9,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,10,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,11,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,12,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,13,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,14,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,15,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,16,FALSE)+VLOOKUP($A$29,Aggregates!$A$7:$T$200,17,FALSE)))","v":1.0009999999999999}]
[null,{"$f":"IF(IF($A32=\"\",\"\",VLOOKUP($A32,Aggregates!$A$7:$T$200,2,FALSE))=0,\"\",IF($A32=\"\",\"\",VLOOKUP($A32,Aggregates!$A$7:$T$200,2,FALSE)))","v":""},{"$f":"IF(IF($A32=\"\",\"\",VLOOKUP($A32,Aggregates!$A$7:$T$200,4,FALSE))=0,\"\",IF($A32=\"\",\"\",VLOOKUP($A32,Aggregates!$A$7:$T$200,4,FALSE)))","v":""},{"$f":"T33","v":""},{"$f":"IF(ISERROR(E33)=TRUE,0,E33)","v":"0.00"},{"$f":"IF(ISERROR(E32+F33)=TRUE,0,E32+F33)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(IF($A32=\"\",\"\",VLOOKUP($A32,Aggregates!$A$7:$T$200,19,FALSE))=0,\"\",IF($A32=\"\",\"\",VLOOKUP($A32,Aggregates!$A$7:$T$200,19,FALSE)))","v":""},{"$f":"IF(IF($A32=\"\",\"\",VLOOKUP($A32,Aggregates!$A$7:$T$200,19,FALSE))=0,\"\",IF($A32=\"\",\"\",VLOOKUP($A32,Aggregates!$A$7:$T$200,19,FALSE)))","v":""},{"$f":"IF(IF($A32=\"\",\"\",VLOOKUP($A32,Aggregates!$A$7:$T$200,3,FALSE))=0,\"\",IF($A32=\"\",\"\",VLOOKUP($A32,Aggregates!$A$7:$T$200,3,FALSE)))","v":""},null,{"$f":"IF(OR(ISERROR($B$32)=TRUE, ISERROR($C$32)=TRUE,ISERROR($E$33)=TRUE,ISERROR($F$33)=TRUE, ISERROR($G$33)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},null,null,{"$f":"SUM(E32,G32,I32,J32,K32,L32,M32,N32,O32)","v":0}]
[{"$f":"LEFT(A32,14)","v":""},{"$f":"LEFT(B32,30)","v":""},null,{"$f":"T33","v":""},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,5,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,5,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,6,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,6,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,7,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,7,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,8,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,8,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,9,FALSE))=0,\"0.00\",IF(A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,9,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,10,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,10,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,11,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,11,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,12,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,12,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,13,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,13,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,14,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,14,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,15,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,15,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,16,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,16,FALSE)*1/T34))","v":"0.00"},{"$f":"IF(IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,17,FALSE))=0,\"0.00\",IF($A$32=\"\",0,VLOOKUP($A$32,Aggregates!$A$7:$T$200,17,FALSE)*1/T34))","v":"0.00"},null,{"$f":"IF(ISERROR(S32*100)=TRUE,\"unknown\",S32*100)","v":"unknown"},{"$f":"LEFT(T32,15)","v":""},null,{"$f":"IF(V32=\"none\",0,1)","v":0},{"$f":"IF(ISBLANK(A32)=TRUE,\"\",SUM(L33:Q33))","v":""},{"$f":"C32","v":""}]
[null,null,null,{"$f":"T33","v":""},{"$f":"IF(ISERROR(1-E32)=TRUE,\"\",1-E32)","v":1},{"$f":"IF(ISERROR(1-F32)=TRUE,\"\",1-F32)","v":1},1,1,1,1,1,1,1,1,1,1,1,null,{"$f":"IF($A$32=\"\",\"\",SUM(E33:Q33))","v":""},{"$f":"IF($A$32=\"\",\"\",SUM(VLOOKUP($A$32,Aggregates!$A$7:$T$200,5,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,6,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,7,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,8,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,9,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,10,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,11,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,12,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,13,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,14,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,15,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,16,FALSE)+VLOOKUP($A$32,Aggregates!$A$7:$T$200,17,FALSE)))","v":""}]
[null,{"$f":"IF(IF($A35=\"\",\"\",VLOOKUP($A35,Aggregates!$A$7:$T$200,2,FALSE))=0,\"\",IF($A35=\"\",\"\",VLOOKUP($A35,Aggregates!$A$7:$T$200,2,FALSE)))","v":""},{"$f":"IF(IF($A35=\"\",\"\",VLOOKUP($A35,Aggregates!$A$7:$T$200,4,FALSE))=0,\"\",IF($A35=\"\",\"\",VLOOKUP($A35,Aggregates!$A$7:$T$200,4,FALSE)))","v":""},{"$f":"T36","v":""},{"$f":"IF(ISERROR(E36)=TRUE,0,E36)","v":"0.00"},{"$f":"IF(ISERROR(E35+F36)=TRUE,0,E35+F36)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(IF($A35=\"\",\"\",VLOOKUP($A35,Aggregates!$A$7:$T$200,19,FALSE))=0,\"\",IF($A35=\"\",\"\",VLOOKUP($A35,Aggregates!$A$7:$T$200,19,FALSE)))","v":""},{"$f":"IF(IF($A35=\"\",\"0\",VLOOKUP($A35,Aggregates!$A$7:$T$200,19,FALSE))=0,\"\",IF($A35=\"\",\"\",VLOOKUP($A35,Aggregates!$A$7:$T$200,19,FALSE)))","v":""},{"$f":"IF(IF($A35=\"\",\"\",VLOOKUP($A35,Aggregates!$A$7:$T$200,3,FALSE))=0,\"\",IF($A35=\"\",\"\",VLOOKUP($A35,Aggregates!$A$7:$T$200,3,FALSE)))","v":""},null,{"$f":"IF(OR(ISERROR($B$35)=TRUE, ISERROR($C$35)=TRUE,ISERROR($E$36)=TRUE,ISERROR($F$36)=TRUE, ISERROR($G$36)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},null,null,{"$f":"SUM(E35,G35,I35,J35,K35,L35,M35,N35,O35)","v":0}]
[{"$f":"LEFT(A35,14)","v":""},{"$f":"LEFT(B35,30)","v":""},null,{"$f":"T36","v":""},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,5,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,5,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,6,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,6,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,7,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,7,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,8,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,8,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,9,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,9,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,10,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,10,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,11,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,11,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,12,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,12,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,13,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,13,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,14,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,14,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,15,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,15,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,16,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,16,FALSE)*1/T37))","v":"0.00"},{"$f":"IF(IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,17,FALSE))=0,\"0.00\",IF($A$35=\"\",0,VLOOKUP($A$35,Aggregates!$A$7:$T$200,17,FALSE)*1/T37))","v":"0.00"},null,{"$f":"IF(ISERROR(S35*100)=TRUE,\"unknown\",S35*100)","v":"unknown"},{"$f":"LEFT(T35,15)","v":""},null,{"$f":"IF(V35=\"none\",0,1)","v":0},{"$f":"IF(ISBLANK(A35)=TRUE,\"\",SUM(L36:Q36))","v":""},{"$f":"C35","v":""}]
[null,null,null,{"$f":"T36","v":""},{"$f":"IF(ISERROR(1-E35)=TRUE,\"\",1-E35)","v":1},{"$f":"IF(ISERROR(1-F35)=TRUE,\"\",1-F35)","v":1},1,1,1,1,1,1,1,1,1,1,1,null,{"$f":"IF($A$35=\"\",\"\",SUM(E36:Q36))","v":""},{"$f":"IF($A$35=\"\",\"\",SUM(VLOOKUP($A$35,Aggregates!$A$7:$T$200,5,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,6,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,7,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,8,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,9,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,10,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,11,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,12,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,13,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,14,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,15,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,16,FALSE)+VLOOKUP($A$35,Aggregates!$A$7:$T$200,17,FALSE)))","v":""}]
[null,{"$f":"IF(IF($A38=\"\",\"\",VLOOKUP($A38,Aggregates!$A$7:$T$200,2,FALSE))=0,\"\",IF($A38=\"\",\"\",VLOOKUP($A38,Aggregates!$A$7:$T$200,2,FALSE)))","v":""},{"$f":"IF(IF($A38=\"\",\"\",VLOOKUP($A38,Aggregates!$A$7:$T$200,4,FALSE))=0,\"\",IF($A38=\"\",\"\",VLOOKUP($A38,Aggregates!$A$7:$T$200,4,FALSE)))","v":""},{"$f":"T38","v":""},{"$f":"IF(ISERROR(E39)=TRUE,0,E39)","v":"0.00"},{"$f":"IF(ISERROR(E38+F39)=TRUE,0,E38+F39)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(IF($A38=\"\",\"\",VLOOKUP($A38,Aggregates!$A$7:$T$200,19,FALSE))=0,\"\",IF($A38=\"\",\"\",VLOOKUP($A38,Aggregates!$A$7:$T$200,19,FALSE)))","v":""},{"$f":"IF(IF($A38=\"\",\"\",VLOOKUP($A38,Aggregates!$A$7:$T$200,19,FALSE))=0,\"\",IF($A38=\"\",\"\",VLOOKUP($A38,Aggregates!$A$7:$T$200,19,FALSE)))","v":""},{"$f":"IF(IF($A38=\"\",\"\",VLOOKUP($A38,Aggregates!$A$7:$T$200,3,FALSE))=0,\"\",IF($A38=\"\",\"\",VLOOKUP($A38,Aggregates!$A$7:$T$200,3,FALSE)))","v":""},null,{"$f":"IF(OR(ISERROR($B$38)=TRUE, ISERROR($C$38)=TRUE,ISERROR($E$39)=TRUE,ISERROR($F$39)=TRUE, ISERROR($G$27)=TRUE)=TRUE,\"Error\",\"none\")","v":"none"},null,null,{"$f":"SUM(E38,G38,I38,J38,K38,L38,M38,N38,O38)","v":0}]
[{"$f":"LEFT(A38,14)","v":""},{"$f":"LEFT(B38,30)","v":""},null,{"$f":"T38","v":""},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,5,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,5,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,6,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,6,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,7,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,7,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,8,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,8,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,9,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,9,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,10,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,10,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,11,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,11,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,12,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,12,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,13,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,13,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,14,FALSE))=0,\"0.00\",IF($A$38=\"\",\"\",VLOOKUP($A$38,Aggregates!$A$7:$T$200,14,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,15,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,15,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,16,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,16,FALSE)*1/T40))","v":"0.00"},{"$f":"IF(IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,17,FALSE))=0,\"0.00\",IF($A$38=\"\",0,VLOOKUP($A$38,Aggregates!$A$7:$T$200,17,FALSE)*1/T40))","v":"0.00"},null,{"$f":"IF(ISERROR(S38*100)=TRUE,\"unknown\",S38*100)","v":"unknown"},{"$f":"LEFT(T38,15)","v":""},null,{"$f":"IF(V38=\"none\",0,1)","v":0},{"$f":"IF(ISBLANK(A38)=TRUE,\"\",SUM(L39:Q39))","v":""},{"$f":"C38","v":""}]
[null,null,null,{"$f":"T38","v":""},{"$f":"IF(ISERROR(1-E38)=TRUE,\"\",1-E38)","v":1},{"$f":"IF(ISERROR(1-F38)=TRUE,\"\",1-F38)","v":1},1,1,1,1,1,1,1,1,1,1,1,null,{"$f":"IF($A$38=\"\",\"\",SUM(E39:Q39))","v":""},{"$f":"IF($A$38=\"\",\"\",SUM(VLOOKUP($A$38,Aggregates!$A$7:$T$200,5,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,6,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,7,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,8,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,9,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,10,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,11,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,12,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,13,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,14,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,15,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,16,FALSE)+VLOOKUP($A$38,Aggregates!$A$7:$T$200,17,FALSE)))","v":""}]
["Actual Aggregate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
["Combined Gradation","Cumulative",null,null,{"$f":"AJ69","v":0},{"$f":"E42+AJ70","v":8.3565559490202765E-2},{"$f":"F42+AJ71","v":0.16098659254730235},{"$f":"G42+AJ72","v":0.28756383706922706},{"$f":"H42+AJ73","v":0.40861100780135895},{"$f":"I42+AJ74","v":0.60639362235670546},{"$f":"J42+AJ75","v":0.65391472713633159},{"$f":"K42+AJ76","v":0.74082265552242643},{"$f":"L42+AJ77","v":0.84195887306907657},{"$f":"M42+AJ78","v":0.9627070567559517},{"$f":"N42+AJ79","v":0.99154818343275308},{"$f":"O42+AJ80","v":0.99308637685551582},{"$f":"P42+AJ81","v":1.0000000000000002},null,null,null,"Errors",{"$f":"SUM(V27,V30,V33,V36,V39)","v":0}]
[null,"Individual",null,null,{"$f":"E42","v":0},{"$f":"F42-E42","v":8.3565559490202765E-2},{"$f":"G42-F42","v":7.7421033057099589E-2},0.1265772445219247,0.12104717073213189,0.19778261455534651,4.7521104779626122E-2,8.6907928386094846E-2,0.10113621754665014,0.12074818368687512,2.8841126676801387E-2,1.5381934227627347E-3,6.9136231444844043E-3]
[null,"Passing",null,null,{"$f":"1-E42","v":1},{"$f":"1-F42","v":0.91643444050979728},{"$f":"1-G42","v":0.83901340745269759},0.71243616293077294,0.59138899219864105,0.39360637764329454,0.34608527286366841,0.25917734447757357,0.15804112693092343,3.7292943244048304E-2,8.451816567246917E-3,6.9136231444841822E-3,0]
[]
[null,null,null,null,"*Blue: Percent Retained (DR)",null,null,null,null,null,null,null,null,null,null,null,null,"*Blue: Total Percent Retained (DR)",null,null,null,"Equivalent",{"$f":"MAX(W27,W30,W33,W36,W39)","v":0.8831168831168833}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Green: Total Percent Retained from",null,null,null,"Sand S.G.",2.6,{"$f":"VLOOKUP(W46,W27:X39,2,FALSE)","v":2.62}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aggregates page - used for internally",null,null,null,null,"Note:  Specific gravity is being used as 2.60."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"normalizing percent retained to 100% (DR)",null,null,null,null,"This is for conversion of cementitious "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"materials to equivalent sand.  Now using"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a 'standard' specific gravity. (DR)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHEET CALCULATIONS",null,null,null,null,null,null,null,"Linked Cells - User Input - Iterative Cells"]
[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,"Linked"]
[null,null,null,null,null,null,null,null,null,"Cubic Equation: WF and CF relationship",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent"]
[null,null,null,null,null,null,null,null,null,null,null,"x","y",null,null,null,"Target",null,null,null,null,null,null,null,null,"Sieve Size","Retained",null,"*100"]
[null,null,null,null,null,null,null,null,null,"A",2.1690000000000001E-5,75,{"$f":"$K$60*L60^3+$K$61*L60^2+$K$62*L60+$K$63","v":32.90941222},null,null,null,"CF","WF",null,null,null,null,null,"Air",null,null,null,null,"7",null,null,null,"Top Sieve",null,"# of Iterations",3]
[null,null,null,null,null,null,null,null,null,"B",-3.3975799999999999E-3,70,33.553924269999996,null,null,null,51.801903896624864,35,null,null,null,null,null,"w/cm","0.45",null,"min","max",null,null,null,null,"Iteration"]
[null,null,null,null,null,null,null,null,null,"C",2.1586939999999999E-2,60,35.000278870000002,null,null,null,null,null,null,null,null,null,null,null,null,null,"2","6","Target","Temp","Temp*100",null,"Final",null,"Diff.","SUM Diff.","Initial Diff","Diff*10000"]
[null,null,null,null,null,null,null,null,null,"D",{"$f":"41.14931047+(35-34.898)","v":41.25131047},50,36.54795747,null,null,null,"Q",{"$f":"Q61*(100-R65)/100","v":35.074964697956972},null,null,null,null,null,"Top Sieve","19 mm (3/4 in.)",{"$f":"VLOOKUP(Y63,Calculations!K79:L83,2,FALSE)","v":19},{"$f":"AA62*1","v":2},{"$f":"AB62*1","v":6},{"$f":"AG63*1","v":6},7.7421033057099589E-2,{"$f":"AD63*100","v":7.7421033057099589},null,6,null,{"$f":"ABS(AG63-AC63)","v":0},{"$f":"SUM(AI63:AI65)","v":1.2591644512727207E-5},5.1548141460604366,{"$f":"AI63*10000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,40,38.066820069999999,null,null,null,"I",{"$f":"100-R63-R65","v":32.634833706271706},null,null,null,null,null,"Pan","Pan","Pan",6.9136231444845136E-3,null,{"$f":"AA64*100","v":0.69136231444845131},6.9137070887812652E-3,{"$f":"AD64*100","v":0.69137070887812646},null,null,null,{"$f":"ABS(AC64-AE64)","v":8.3944296751514713E-6},null,null,{"$f":"AI64*10000","v":8.3944296751514713E-2}]
[null,null,null,null,null,null,null,null,null,null,null,30,39.426726670000001,null,null,null,"W",{"$f":"R61+AL89","v":32.290201595771322},null,null,null,null,null,"#200","No. 200",7.4999999999999997E-2,1.5381934227627404E-3,null,{"$f":"AA65*100","v":0.15381934227627403},1.5381514506143646E-3,{"$f":"AD65*100","v":0.15381514506143645},null,null,null,{"$f":"ABS(AC65-AE65)","v":4.1972148375757357E-6},null,null,{"$f":"AI65*10000","v":4.1972148375757357E-2}]
[null,null,null,null,null,null,null,null,null,null,null,20,40.497537270000002,null,null,null,null,null,null,null,null,null,null,"TOP","COND.",null,null,null,null,null,null,"Combined  Gradation",null,"Combined  Gradation",null,"%","Actual","Actual","Gradation","NEW","GRADATIONS",null,"BY WT."]
[null,null,null,null,null,null,null,null,null,null,null,10,41.149111869999999,null,null,null,null,null,null,null,null,null,null,"SIEVE","SUM",null,null,null,"Cubic #1","Cubic #2","Optimum",null,null,null,null,"Retained","Gradation","Gradation","with W","Retained","Optimum vs. Actual",null,"% Retained"]
[null,null,null,null,null,null,null,null,null,null,null,0,41.25131047,null,null,null,null,null,null,null,"Sieve Designation & Size",null,null,"LOCATOR","(EQ. #8)","log(x)3","log(x)2","log(x)",null,null,"Model","(% Retained)",null,"(% Passing)",null,"per Sieve",null,"%per Sieve","Correction","%per Sieve",null,null,"per Sieve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",1.5,37.5,{"$f":"IF(W69=Z63,1,0)","v":0},{"$f":"IF(Z63=W69,1,0)","v":0},{"$f":"LOG(W69)^3","v":3.899779623751586},{"$f":"LOG(W69)^2","v":2.4775744317845296},{"$f":"LOG(W69)","v":1.5740312677277188},{"$f":"Z69*$AA$96+AA69*$AA$97+AB69*$AA$98+$AA$99","v":-18.294196812391817},{"$f":"Z69*$AA$100+AA69*$AA$101+AB69*$AA$102+$AA$103","v":4.744121238727633},{"$f":"Y69*AC69/100","v":0},{"$f":"AJ69","v":0},null,{"$f":"1-AF69","v":1},null,{"$f":"(E27*$Q$117+E30*$Q$118+E33*$Q$119+E36*$Q$120+E39*$Q$121)/1000","v":0},{"$f":"AJ69*$AM$92","v":0},{"$f":"AK69/$AM$92","v":0},{"$f":"AK69","v":0},{"$f":"AM69/$AN$83","v":0},{"$f":"AL69-AE69","v":0},{"$f":"IF(AO69>0.02,1,IF(AO69<-0.02,-1,0))","v":0},{"$f":"(F26*$U$117+F29*$U$118+F32*$U$119+F35*$U$120+F38*$U$121)/100","v":8.3325474525474535E-2}]
["Contact Information","One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",1,25,{"$f":"IF(Z63=W70,1,0)","v":0},{"$f":"IF(Z63>=W70,1,0)","v":0},2.7319050652198156,1.9542362678459768,1.3979400086720377,-1.7026640854027022,9.4333749203233861,0,{"$f":"AF69+AJ70","v":8.3565559490202765E-2},null,{"$f":"1-AF70","v":0.91643444050979728},null,{"$f":"(F27*$Q$117+F30*$Q$118+F33*$Q$119+F36*$Q$120+F39*$Q$121)/1000","v":8.3565559490202765E-2},224.12283055272383,{"$f":"AK70/$AM$92","v":8.3565559490202765E-2},224.12283055272383,8.0102633662752831E-2,{"$f":"AL70-AE70","v":8.3565559490202765E-2},{"$f":"IF(AO70>0.02,1,IF(AO70<-0.02,-1,0))","v":1},{"$f":"(F27*$U$117+F30*$U$118+F33*$U$119+F36*$U$120+F39*$U$121)/100","v":8.3325474525474535E-2}]
["Company Name","University of Kansas",null,null,null,null,null,null,null,null,null,null,null,null,null,"8 Equations, 8 Unknowns",null,null,null,null,"c","3/4",19,{"$f":"IF(Z63=W71,1,0)","v":1},{"$f":"IF(Z63>=W71,1,0)","v":1},2.0910316629476959,1.6352107719498268,1.2787536009528289,5.9999999999999432,11.884914449069944,5.9999999999999429E-2,{"$f":"AF70+AJ71","v":0.16098659254730235},null,0.83901340745269759,null,{"$f":"(G27*$Q$117+G30*$Q$118+G33*$Q$119+G36*$Q$120+G39*$Q$121)/1000","v":7.7421033057099589E-2},{"$f":"AJ71*$AM$92","v":207.64321065914109},7.7421033057099589E-2,207.64321065914109,7.4212734128726851E-2,1.742103305710016E-2,{"$f":"IF(AO71>0.02,1,IF(AO71<-0.02,-1,0))","v":0},{"$f":"(G27*$U$117+G30*$U$118+G33*$U$119+G36*$U$120+G39*$U$121)/100","v":7.7198601398601407E-2}]
["Address1","CEAE Department",null,null,null,null,null,null,null,null,null,null,null,null,null,"#","Equations",null,null,null,"d","1/2",12.5,{"$f":"IF(Z63=W72,1,0)","v":0},{"$f":"IF(Z63>=W72,1,0)","v":1},{"$f":"LOG(W72)^3","v":1.3198148261807028},1.2032115766373346,1.0969100130080565,13.302883975056176,14.602680756146251,0.13302883975056176,0.28756383706922706,null,0.71243616293077294,null,{"$f":"(H27*$Q$117+H30*$Q$118+H33*$Q$119+H36*$Q$120+H39*$Q$121)/1000","v":0.12657724452192473},339.48016980780216,0.12657724452192473,339.48016980780216,0.1213319304009344,-6.4515952286370304E-3,{"$f":"IF(AO72>0.02,1,IF(AO72<-0.02,-1,0))","v":0},{"$f":"(H27*$U$117+H30*$U$118+H33*$U$119+H36*$U$120+H39*$U$121)/100","v":0.1262135864135864}]
["Address2","2150 Learned Hall",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Top Sieve and quantity retained",null,null,null,"e","3/8",9.5,{"$f":"IF(Z63=W73,1,0)","v":0},{"$f":"IF(Z63>=W73,1,0)","v":1},0.93464847476228241,0.95594344833902245,0.97772360528884772,15.772080722900711,15.772080722900743,0.15772080722900711,0.40861100780135895,null,0.59138899219864105,null,{"$f":"(I27*$Q$117+I30*$Q$118+I33*$Q$119+I36*$Q$120+I39*$Q$121)/1000","v":0.12104717073213192},324.6485119035778,{"$f":"AK73/$AM$92","v":0.12104717073213192},324.6485119035778,0.11603102082031105,-3.6673636496875189E-2,-1,{"$f":"(I27*$U$117+I30*$U$118+I33*$U$119+I36*$U$120+I39*$U$121)/100","v":0.12069940059940061}]
["Address3","1530 W. 15th St.",null,null,null,null,null,null,null,null,null,null,null,null,null,2,"No. 200 quantity retained",null,null,null,"f","No. 4",4.75,null,1,0.3098676408487549,0.45791424130713132,0.67669360962486658,16.862748063508381,16.862748063508391,0.16862748063508382,0.60639362235670546,null,0.39360637764329454,null,{"$f":"(J27*$Q$117+J30*$Q$118+J33*$Q$119+J36*$Q$120+J39*$Q$121)/1000","v":0.19778261455534651},530.45297223743933,0.19778261455534651,530.45297223743933,0.18958657627902067,2.9155133920262699E-2,1,{"$f":"(J27*$U$117+J30*$U$118+J33*$U$119+J36*$U$120+J39*$U$121)/100","v":0.19724595404595407}]
["City","Lawrence",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"No 3/8 = No. 3/8",null,null,null,"g","No. 8",2.36,null,1,5.1858396847953528E-2,0.13906336195917676,0.37291200297010657,15.772085642763313,15.772085642763317,0.15772085642763314,0.65391472713633159,null,0.34608527286366841,null,{"$f":"(K27*$Q$117+K30*$Q$118+K33*$Q$119+K36*$Q$120+K39*$Q$121)/1000","v":4.7521104779626074E-2},127.45160301895713,4.7521104779626074E-2,127.45160301895713,4.5551847802299011E-2,-0.11019975164800708,-1,{"$f":"(K27*$U$117+K30*$U$118+K33*$U$119+K36*$U$120+K39*$U$121)/100","v":4.7688811188811193E-2}]
["State","Kansas",null,null,null,null,null,null,null,null,null,null,null,null,null,4,"No. 4 = No. 4",null,null,null,"h","No. 16",1.18,null,1,3.7141598319370922E-4,5.1670229743578594E-3,7.1882007306125359E-2,19.069491178566125,13.157680746519262,{"$f":"AD76/100","v":0.13157680746519262},0.74082265552242643,null,0.25917734447757357,null,{"$f":"(L27*$Q$117+L30*$Q$118+L33*$Q$119+L36*$Q$120+L39*$Q$121)/1000","v":8.6907928386094818E-2},233.08706393150629,8.6907928386094818E-2,233.08706393150629,8.3306496029818169E-2,-4.4668879079097806E-2,-1,{"$f":"(L27*$U$117+L30*$U$118+L33*$U$119+L36*$U$120+L39*$U$121)/100","v":8.730689310689313E-2}]
["Zip Code","66045-7609",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"No. 8 = No. 8",null,null,null,"I","No. 30",0.6,null,1,-1.0918700560685335E-2,4.9216867706340789E-2,-0.22184874961635639,32.721959976242609,9.7421909434017735,{"$f":"AD77/100","v":9.7421909434017739E-2},0.84195887306907657,null,0.15804112693092343,null,{"$f":"(M27*$Q$117+M30*$Q$118+M33*$Q$119+M36*$Q$120+M39*$Q$121)/1000","v":0.10113621754665016},271.24733546011572,0.10113621754665016,271.24733546011572,9.6945170158593705E-2,3.7143081126324168E-3,0,{"$f":"(M27*$U$117+M30*$U$118+M33*$U$119+M36*$U$120+M39*$U$121)/100","v":0.10160049950049953}]
["Telephone Number","785.864.3885",null,null,null,null,null,null,null,"Pull-Down Menus",null,null,null,null,null,6,"Sum I",null,null,null,"j","No. 50",0.3,null,1,-0.142956190020121,0.27340218226594021,-0.52287874528033762,63.777354705916494,5.9761358336606758,{"$f":"AD78/100","v":5.9761358336606757E-2},0.9627070567559517,null,3.7292943244048304E-2,null,{"$f":"(N27*$Q$117+N30*$Q$118+N33*$Q$119+N36*$Q$120+N39*$Q$121)/1000","v":0.12074818368687509},323.84662864819899,0.12074818368687509,323.84662864819899,0.11574442368744647,6.0986825350268337E-2,1,{"$f":"(N27*$U$117+N30*$U$118+N33*$U$119+N36*$U$120+N39*$U$121)/100","v":0.12130249750249752}]
["Fax Number","785.864.5631",null,null,null,null,null,null,null,null,"37.5 mm (1.5 in.)",37.5,0.45,0,0,7,"Sum W",null,null,null,"k","No. 100",0.15,null,1,-0.55929035646081737,0.67882561340445258,-0.82390874094431876,118.55332526459692,2.5690124154648775,{"$f":"AD79/100","v":2.5690124154648775E-2},0.99154818343275308,null,8.451816567246917E-3,null,{"$f":"($O$27*$Q$117+$O$30*$Q$118+$O$33*$Q$119+$O$36*$Q$120+$O$39*$Q$121)/1000","v":2.8841126676801374E-2},77.351901747181287,2.8841126676801374E-2,77.351901747181287,2.764596107184231E-2,3.1510025221525989E-3,0,{"$f":"($O$27*$U$117+$O$30*$U$118+$O$33*$U$119+$O$36*$U$120+$O$39*$U$121)/100","v":2.8973526473526478E-2}]
["Contractor","Quality Construction Co.",null,null,null,null,null,null,null,null,"25 mm (1.0 in.)",25,0.44,1,1,8,"Sum Q",null,null,null,"l","No. 200",7.4999999999999997E-2,null,1,-1.4235955282264694,1.2654871611218779,-1.1249387366082999,203.54990856618195,0.15381934227626815,{"$f":"AD80/100","v":1.5381934227626814E-3},0.99308637685551582,null,6.9136231444841822E-3,null,{"$f":"($P$27*$Q$117+$P$30*$Q$118+$P$33*$Q$119+$P$36*$Q$120+$P$39*$Q$121)/1000","v":1.5381934227627404E-3},4.1254347598496697,1.5381934227627404E-3,4.1254347598496697,1.4744512571649236E-3,5.8980598183211441E-17,0,{"$f":"($P$27*$U$117+$P$30*$U$118+$P$33*$U$119+$P$36*$U$120+$P$39*$U$121)/100","v":1.5452547452547457E-3}]
["Project","County Road 443",null,null,null,null,null,null,null,null,"19 mm (3/4 in.)",19,0.43,2,2,null,null,null,null,null,"m","Pan",{"$f":"W80/2","v":3.7499999999999999E-2},null,null,null,null,null,null,null,{"$f":"AC64/100","v":6.9136231444845127E-3},1.0000000000000002,null,0,null,{"$f":"(Q27*$Q$117+Q30*$Q$118+Q33*$Q$119+Q36*$Q$120+Q39*$Q$121)/1000","v":6.9136231444845136E-3},{"$f":"AJ81*$AM$92","v":18.542337273507467},6.9136231444845144E-3,{"$f":"AK81+$AM$91","v":134.48817631199833},4.8066754701089912E-2,0,0,{"$f":"(Q27*$U$117+Q30*$U$118+Q33*$U$119+Q36*$U$120+Q39*$U$121)/100","v":6.8995004995005002E-3}]
["Source of Concrete","Ready Mix Concrete",null,null,null,null,null,null,null,null,"12.5 mm (1/2 in.)",12.5,0.42,3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINIMIZE"]
["Project Type","LC-HPC Bridge Deck",null,null,null,null,null,null,null,null,"9.5 mm (3/8 in.)",9.5,0.41,4,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fineness modulus",null,{"$f":"(SUM(AF69,AF71,AF73,AF74,AF75,AF76,AF77,AF78,AF79))","v":5.3669427186219067},"Sum",{"$f":"SUM(AJ69:AJ81)","v":1.0000000000000002},{"$f":"SUM(AK69:AK81)","v":2682.0000000000009},{"$f":"SUM(AL69:AL81)","v":1.0000000000000002},{"$f":"SUM(AM69:AM81)","v":2797.9458390384916},{"$f":"SUM(AM91:AM92)","v":2797.9458390384907}]
["Placement Type","Conventional",null,null,null,null,null,null,null,null,null,null,0.4,5,5]
["Report Number",null,null,null,null,null,null,null,null,null,null,null,0.39,6,6,"OPTIMUM GRADATION SOLVE FOR MODEL CONSTANTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coarsness Factor",null,null,null,{"$f":"SUM(AJ69:AJ73)/(SUM(AJ69:AJ75))*100","v":62.486894826604754},{"$f":"SUM(AQ69:AQ73)/(SUM(AQ69:AQ75))*100","v":66.70712746441292}]
["Target Strength",null,null,null,null,null,null,null,null,null,null,null,0.38,7,7,null,"A","B","C","D","A'","B'","C'","D'",null,null,"Equals",null,null,null,null,"Workability Factor",null,null,null,{"$f":"(SUM(AJ76:AJ81))/SUM(AJ69:AJ81)*100-AL89","v":37.318325690595543},{"$f":"(SUM(AQ76:AQ81))/SUM(AQ69:AQ81)*100-AM89","v":32.088987105231908},"W agg",null,"W corr"]
["Prepared By",null,null,null,null,null,null,null,null,null,null,null,0.37,8,8,"#1",{"$f":"SUMPRODUCT(X69:X73,Z69:Z73)","v":2.0910316629476959},{"$f":"SUMPRODUCT(X69:X73,AA69:AA73)","v":1.6352107719498268},{"$f":"SUMPRODUCT(X69:X73,AB69:AB73)","v":1.2787536009528289},1,0,0,0,0,"A",null,{"$f":"AC63","v":6},null,null,null,null,null,"Squared Difference",null,null,null,null,{"$f":"SUM(AL76:AL81)","v":0.34608527286366875},null,{"$f":"SUM(AN76:AN81)","v":0.3731832569059555}]
["Target Slump",9,null,null,null,null,null,null,null,null,null,null,0.36,9,9,"#2",0,0,0,0,{"$f":"Z80","v":-1.4235955282264694},{"$f":"AA80","v":1.2654871611218779},{"$f":"AB80","v":-1.1249387366082999},{"$f":"1","v":1},"B",null,{"$f":"AC65","v":0.15381934227627403},null,null,"No. 8 - No. 4",null,null,{"$f":"(AE69-AJ69)^2","v":0},1.5,null,null,null,"(Wagg-Wcorr)*100"]
["Slump Tolerance",null,null,null,null,null,null,null,null,null,null,null,0.35,10,10,"#3",{"$f":"Z73","v":0.93464847476228241},0.95594344833902245,0.97772360528884772,1,{"$f":"-Z73","v":-0.93464847476228241},-0.95594344833902245,-0.97772360528884772,-1,"C",null,0,null,null,{"$f":"ABS(AE75-AE74)","v":1.0906624207450671E-2},null,null,6.9832027329106176E-3,1,null,null,null,{"$f":"(AL87-AN87)*100","v":-2.7097984042286747}]
["Hold Chart Toolbar calculation page",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"#4",0.3098676408487549,0.45791424130713132,0.67669360962486658,1,-0.3098676408487549,-0.45791424130713132,-0.67669360962486658,-1,"D","=",0,null,null,"3/8\" - No. 4",{"$f":"SUM(AD89,AD91,AD93)","v":2.1813346812153411E-2},null,3.0349239277657655E-4,"3/4"]
["Hold chart toolbar program v.3 page",0,null,null,null,null,null,null,null,"W-Section Correction",null,null,null,null,null,"#5",5.1858396847953528E-2,0.13906336195917676,0.37291200297010657,1,-5.1858396847953528E-2,-0.13906336195917676,-0.37291200297010657,-1,"A'",null,0,null,null,{"$f":"ABS(AE74-AE73)","v":1.0906673406076706E-2},null,null,4.1623080994172094E-5,"1/2",null,null,"W Correction",null,{"$f":"M101","v":115.94583903849086},"(lbs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ft3",null,null,"#6",{"$f":"SUM(Z74:Z75)","v":0.36172603769670841},{"$f":"SUM(AA74:AA75)","v":0.59697760326630811},{"$f":"SUM(AB74:AB75)","v":1.0496056125949731},{"$f":"SUM(Y74:Y75)","v":2},0,0,0,0,"B'",null,{"$f":"Calculations!R64","v":32.634833706271706},null,null,"3/8\"-No. 8",null,null,1.3449556139049359E-3,"3/8",null,null,"Total Aggregate Wt.",null,{"$f":"SUM(T117:T121)","v":2682},"(lbs)"]
[null,null,null,null,null,null,null,null,null,null,null,"V CM",{"$f":"IF(ISBLANK('Program v.3'!K19)=TRUE,\"--\",'Program v.3'!K19/('Program v.3'!J19*62.4))","v":3.5840091750634886},null,null,"#7",0,0,0,0,{"$f":"SUM(Z76:Z80)","v":-2.1363893592848995},{"$f":"SUM(AA76:AA80)","v":2.2720988474729693},{"$f":"SUM(AB76:AB80)","v":-2.6216929651431875},5,"C'",null,{"$f":"Calculations!R65-AC64","v":31.598839281322871},null,null,{"$f":"ABS(AE73-AE75)","v":4.9198626034252513E-8},null,null,8.5002183390845267E-4,"No. 4"]
[null,null,null,null,null,null,null,null,null,null,null,"V MA1",{"$f":"IF(ISBLANK('Program v.3'!K20)=TRUE,\"--\",'Program v.3'!K20/('Program v.3'!J20*62.4))","v":"--"},null,null,"#8",{"$f":"SUMPRODUCT(Y69:Y73,Z69:Z73)","v":4.3454949638906806},{"$f":"SUMPRODUCT(Y69:Y73,AA69:AA73)","v":3.7943657969261837},{"$f":"SUMPRODUCT(Y69:Y73,AB69:AB73)","v":3.3533872192497327},{"$f":"SUM(Y69:Y73)","v":3},0,0,0,0,"D'",null,{"$f":"Calculations!R63","v":35.074964697956972},null,null,null,null,null,1.2143985263282439E-2,"No. 8"]
[null,null,null,null,null,null,null,null,null,null,null,"V MA2",{"$f":"IF(ISBLANK('Program v.3'!K21)=TRUE,\"--\",'Program v.3'!K21/('Program v.3'!J21*62.4))","v":"--"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINIMIZE",null,null,1.9953087581830618E-3,"No. 16"]
[null,null,null,null,null,null,null,null,null,null,null,"V MA3",{"$f":"IF(ISBLANK('Program v.3'!K22)=TRUE,\"--\",'Program v.3'!K22/('Program v.3'!J22*62.4))","v":"--"},null,null,"#1",{"$f":"MINVERSE(Q87:X94)","v":14.812331251830219},1.5752859834557547,-3.8915900991636478,11.633218104443973,-10.11152983673685,4.4939332595421959,-0.78903756298245331,-7.1434319798193648,{"$f":"AA87","v":6},null,{"$f":"MMULT(Q96:X103,Y96:Y103)","v":-39.713234076933702},"A",null,"(WF'-WF)^2",null,null,1.3796084755566987E-5,"No. 30"]
[null,null,null,null,null,null,null,null,null,null,null,"V MA4",{"$f":"IF(ISBLANK('Program v.3'!K23)=TRUE,\"--\",'Program v.3'!K23/('Program v.3'!J23*62.4))","v":"--"},null,null,"#2",-31.634260107236155,-4.3477677175241274,10.740735320873535,-32.107522479482114,27.907683722611662,-11.14814612555999,2.1777328563054383,15.79655193145102,0.15381934227627403,null,68.585105514176291,"B",null,{"$f":"(Calculations!AJ86-Calculations!R61)^2","v":5.3746340076753025},null,null,3.7193928663041328E-3,"No. 50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"6-Sack Mix",null,"#3",19.884798720385263,3.7173443660111927,-9.183336030334992,27.451953634645434,-23.861088630960648,7.7164206132889683,-1.8619630785322792,-9.9083896401043301,0,null,-34.667593596522124,"C",null,null,{"$f":"SUM(AD97,AD100)","v":119.5436651814278},null,9.9288168946120391E-6,"No. 100"]
[null,null,null,null,null,null,null,null,null,null,null,"Σ",{"$f":"SUM(M93:M97)","v":3.5840091750634886},{"$f":"(94*6)/(3.15*62.4)","v":2.8693528693528694},null,"#4",-3.6721287275462791,-0.93802375799104099,2.3172960387612958,-6.9271453427913041,6.021037015569199,-1.0347887507999585,0.46984229390604632,1.7768395058690012,0,"=",21.221836708747091,"D",null,"(CF'-CF)^2",null,null,3.4787109620494448E-33,"No. 200"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#5",-0.54858424498824987,-0.86813076606483419,-0.90290754249635996,0.96011372890952051,0.80746142438330137,-0.83205026441356755,0.34655967537225907,0.44933905433964128,0,null,-3.8674278359198393,"A'",null,{"$f":"(Calculations!AJ85-Calculations!Q61)^2","v":114.1690311737525},null,null,7.5231638452626401E-37,"Pan"]
[null,null,null,null,null,null,null,null,null,"Equivalent Weight of Sand",null,null,{"$f":"(M99-N99)*$W$47*62.4","v":115.94583903849086},"(lbs)",null,"#6",-0.4926273070917096,0.60584245024567129,-0.81080875959590015,0.4656247906339423,0.32854339541139577,-0.35062411347663813,-0.12449660475924663,0.40350536919851598,32.634833706271706,null,-4.0861448168332171,"B'",null,null,null,null,{"$f":"SUM(AG88:AG100)","v":2.7405707443914563E-2},"SUM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#7",0.24477220968425223,0.59326170653594545,0.40286733776348976,-0.96391115121677506,-0.89579938491354494,0.90677065279585367,-0.41002098098055506,-0.20049010563637645,31.598839281322871,null,11.163827389862226,"C'"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#8",0.11780519464086109,-0.33516984430560381,0.19389400945840726,-0.3067695760353335,-0.27398840411620201,0.27926871085527072,0.18966117472249508,-9.6492881886091425E-2,35.074964697956972,null,12.377752053174103,"D'"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIX DESIGN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cement / Water / Air","lbs / %","S.G.","ft3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Content",{"$f":"Y61*SUM(Q110:Q114)","v":315},null,{"$f":"ROUND(Q107/62.4,2)","v":5.05}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Content - Admixtures",{"$f":"ROUND(Y61*H8-SUM(U125:U129,U130),0)","v":314},1,{"$f":"ROUND(Q108/62.4,2)","v":5.03}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Content",{"$f":"AC60","v":"7"},"NA",{"$f":"ROUND(Q109/100*27,2)","v":1.89},null,"%Blend","% Paste",{"$f":"SUM(S110:S114,Q107/62.4)/27","v":0.31955840455840456}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B3","v":"Type I/II Cement"},{"$f":"H3","v":700},{"$f":"E3","v":3.13},{"$f":"IF(Q110=0,\"\",ROUND(Q110/(62.4*R110),2))","v":3.58},null,{"$f":"IF(SUM($Q$110:$Q$114)=0,0,ROUND(Q110/(SUM($Q$110:$Q$114))*100,1))","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B4","v":""},{"$f":"H4","v":0},{"$f":"E4","v":""},{"$f":"IF(Q111=0,\"\",ROUND(Q111/(62.4*R111),2))","v":""},null,{"$f":"IF(SUM($Q$110:$Q$114)=0,0,ROUND(Q111/(SUM($Q$110:$Q$114))*100,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B5","v":""},{"$f":"H5","v":0},{"$f":"E5","v":""},{"$f":"IF(Q112=0,\"\",ROUND(Q112/(62.4*R112),2))","v":""},null,{"$f":"IF(SUM($Q$110:$Q$114)=0,0,ROUND(Q112/(SUM($Q$110:$Q$114))*100,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B6","v":""},{"$f":"H6","v":0},{"$f":"E6","v":""},{"$f":"IF(Q113=0,\"\",ROUND(Q113/(62.4*R113),2))","v":""},null,{"$f":"IF(SUM($Q$110:$Q$114)=0,0,ROUND(Q113/(SUM($Q$110:$Q$114))*100,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original %",{"$f":"B7","v":""},{"$f":"H7","v":0},{"$f":"E7","v":""},{"$f":"IF(Q114=0,\"\",ROUND(Q114/(62.4*R114),2))","v":""},null,{"$f":"IF(SUM($Q$110:$Q$114)=0,0,ROUND(Q114/(SUM($Q$110:$Q$114))*100,1))","v":0},null,null,null,"CHECKS BY DR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary",null,"VOLUME",null,null,null,"WEIGHT",null,null,null,"Volume","Weight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Blend","Aggregates","%Blend","S.G.","ft3","lbs.","Blend %","round ft3","Min %","Max %","% Blend","% Blend"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,615.06709595362452,{"$f":"IF(B26=\"\",0,B26)","v":"CA-30 Granite "},615.06709595362452,{"$f":"IF(C26=\"\",1,C26)","v":2.6},{"$f":"IF(T117=\"\",\"\",T117/62.4/R117)","v":10.139299802761341},{"$f":"IF(P117=0,\"\",ROUND(Q117/1000*$T$122*(R117/$R$122),0))","v":1645},{"$f":"IF(T117=\"\",0,ROUND(100*T117/SUM($T$117:$T$121),2))","v":61.33},{"$f":"IF(P117=0,\"\",T117/(R117*62.4))","v":10.139299802761341},{"$f":"IF(ISBLANK('Program v.3'!I48)=TRUE,0,'Program v.3'!I48*1000)","v":0},{"$f":"IF(ISBLANK('Program v.3'!J48)=TRUE,1000,'Program v.3'!J48*1000)","v":1000},{"$f":"IF(T117=\"\",\"\",ROUND((T117/(R117*62.4))/($T$122/(62.4*$R$122))*100,1))","v":61.5},{"$f":"T117/$Z$123","v":0.61343238743684658}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,384.93290404637565,{"$f":"IF(B29=\"\",0,B29)","v":"Sand "},384.93290404637565,{"$f":"IF(C29=\"\",1,C29)","v":2.62},{"$f":"IF(T118=\"\",\"\",T118/62.4/R118)","v":6.3429731845762385},{"$f":"IF(P118=0,\"\",ROUND(Q118/1000*$T$122*(R118/$R$122),0))","v":1037},{"$f":"IF(T118=\"\",0,ROUND(100*T118/SUM($T$117:$T$121),2))","v":38.67},{"$f":"IF(P118=0,\"\",T118/(R118*62.4))","v":6.3429731845762376},{"$f":"IF(ISBLANK('Program v.3'!I49)=TRUE,0,'Program v.3'!I49*1000)","v":0},{"$f":"IF(ISBLANK('Program v.3'!J49)=TRUE,1000,'Program v.3'!J49*1000)","v":1000},{"$f":"IF(T118=\"\",\"\",ROUND((T118/(R118*62.4))/($T$122/(62.4*$R$122))*100,1))","v":38.5},{"$f":"T118/$Z$123","v":0.38670479378237682}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(B32=\"\",0,B32)","v":0},0,{"$f":"IF(C32=\"\",1,C32)","v":1},{"$f":"IF(T119=\"\",\"\",T119/62.4/R119)","v":""},{"$f":"IF(P119=0,\"\",ROUND(Q119/1000*$T$122*(R119/$R$122),0))","v":""},{"$f":"IF(T119=\"\",0,ROUND(100*T119/SUM($T$117:$T$121),2))","v":0},{"$f":"IF(P119=0,\"\",T119/(R119*62.4))","v":""},{"$f":"IF(ISBLANK('Program v.3'!I50)=TRUE,0,'Program v.3'!I50*1000)","v":0},{"$f":"IF(ISBLANK('Program v.3'!J50)=TRUE,1000,'Program v.3'!J50*1000)","v":1000},{"$f":"IF(T119=\"\",\"\",ROUND((T119/(R119*62.4))/($T$122/(62.4*$R$122))*100,1))","v":""},{"$f":"T119/$Z$123","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(B35=\"\",0,B35)","v":0},0,{"$f":"IF(C35=\"\",1,C35)","v":1},{"$f":"IF(T120=\"\",\"\",T120/62.4/R120)","v":""},{"$f":"IF(P120=0,\"\",ROUND(Q120/1000*$T$122*(R120/$R$122),0))","v":""},{"$f":"IF(T120=\"\",0,ROUND(100*T120/SUM($T$117:$T$121),2))","v":0},{"$f":"IF(P120=0,\"\",T120/(R120*62.4))","v":""},{"$f":"IF(ISBLANK('Program v.3'!I51)=TRUE,0,'Program v.3'!I51*1000)","v":0},{"$f":"IF(ISBLANK('Program v.3'!J51)=TRUE,1000,'Program v.3'!J51*1000)","v":1000},{"$f":"IF(T120=\"\",\"\",ROUND((T120/(R120*62.4))/($T$122/(62.4*$R$122))*100,1))","v":""},{"$f":"T120/$Z$123","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(B38=\"\",0,B38)","v":0},0,{"$f":"IF(C38=\"\",1,C38)","v":1},{"$f":"IF(T121=\"\",\"\",T121/62.4/R121)","v":""},{"$f":"IF(P121=0,\"\",ROUND(Q121/1000*$T$122*(R121/$R$122),0))","v":""},{"$f":"IF(T121=\"\",0,ROUND(100*T121/SUM($T$117:$T$121),2))","v":0},{"$f":"IF(P121=0,\"\",T121/(R121*62.4))","v":""},{"$f":"IF(ISBLANK('Program v.3'!I52)=TRUE,0,'Program v.3'!I52*1000)","v":0},{"$f":"IF(ISBLANK('Program v.3'!J52)=TRUE,1000,'Program v.3'!J52*1000)","v":1000},{"$f":"IF(T121=\"\",\"\",ROUND((T121/(R121*62.4))/($T$122/(62.4*$R$122))*100,1))","v":""},{"$f":"T121/$Z$123","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q117:Q121)","v":1000.0000000000002},2.6,{"$f":"27-SUM(S108:S114,V125:V129,V130)","v":16.48},{"$f":"62.4*R122*S122","v":2673.7152000000001},{"$f":"SUM(U117:U121)","v":100},{"$f":"SUM(V117:V121)","v":16.482272987337581},null,null,null,{"$f":"SUM(Z117:Z121)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T117:T120)","v":2682},null,null,null,null,{"$f":"62.4*(O117/1000*S122*R117+O118/1000*S122*R118+O119/1000*S122*R119+O120/1000*S122*R120+O121/1000*S122*R121)","v":2681.6321304348385}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Admixtures","ft3","SG","% Solids","lbs Admix","lbs Water","ft3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B17","v":""},{"$f":"IF(ISBLANK(A17)=TRUE,\"\",K17*0.001044379)","v":""},{"$f":"J17","v":""},{"$f":"I17","v":""},{"$f":"IF(Q125=\"\",0,Q125*R125*62.4)","v":0},{"$f":"IF(ISBLANK(A17)=TRUE,0,T125*(1-S125))","v":0},{"$f":"IF(A17=\"\",\"0\",ROUND(T125/(R125*62.4),2))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B18","v":""},{"$f":"IF(ISBLANK(A18)=TRUE,\"\",K18*0.001044379)","v":""},{"$f":"J18","v":""},{"$f":"I18","v":""},{"$f":"IF(Q126=\"\",0,Q126*R126*62.4)","v":0},{"$f":"IF(ISBLANK(A18)=TRUE,0,T126*(1-S126))","v":0},{"$f":"IF(A18=\"\",\"0\",ROUND(T126/(R126*62.4),2))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B19","v":""},{"$f":"IF(ISBLANK(A19)=TRUE,\"\",K19*0.001044379)","v":""},{"$f":"J19","v":""},{"$f":"I19","v":""},{"$f":"IF(Q127=\"\",0,Q127*R127*62.4)","v":0},{"$f":"IF(ISBLANK(A19)=TRUE,0,T127*(1-S127))","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":""},{"$f":"IF(ISBLANK(A20)=TRUE,\"\",K20*0.001044379)","v":""},{"$f":"J20","v":""},{"$f":"I20","v":""},{"$f":"IF(Q128=\"\",0,Q128*R128*62.4)","v":0},{"$f":"IF(ISBLANK(A20)=TRUE,0,T128*(1-S128))","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B21","v":""},{"$f":"IF(ISBLANK(A21)=TRUE,\"\",K21*0.001044379)","v":""},{"$f":"J21","v":""},{"$f":"I21","v":""},{"$f":"IF(Q129=\"\",0,Q129*R129*62.4)","v":0},{"$f":"IF(ISBLANK(A21)=TRUE,0,T129*(1-S129))","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B12","v":"Air Entraining Agent"},{"$f":"I12*0.001044379","v":2.1931959000000001E-2},{"$f":"K12","v":1.01},{"$f":"J12","v":0.3},{"$f":"IF(Q130=0,0,Q130*R130*62.4)","v":1.3822397840159999},{"$f":"IF(ISBLANK(A12)=TRUE,0,T130*(1-S130))","v":0.96756784881119984},{"$f":"ROUND(U130/62.4,2)","v":0.02}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit Weight, lb/ft3",{"$f":"SUM(Q107,Q110:Q114,T117:T121)/27","v":136.92592592592592}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum of Volume",{"$f":"IF(S108=\"\",0,S108)+IF(S109=\"\",0,S109)+IF(S110=\"\",0,S110)+IF(S111=\"\",0,S111)+IF(S112=\"\",0,S112)+IF(S113=\"\",0,S113)+IF(S114=\"\",0,S114)+IF(V117=\"\",0,V117)+IF(V118=\"\",0,V118)+IF(V119=\"\",0,V119)+IF(V120=\"\",0,V120)+IF(V121=\"\",0,V121)+IF(V125=\"\",0,V125)+IF(V126=\"\",0,V126)+IF(V127=\"\",0,V127)+IF(V128=\"\",0,V128)+IF(V129=\"\",0,V129)+IF(V130=\"\",0,V130)","v":27.00227298733758}]