{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Info","Tensile Strength Prediction","Shear Parameter Prediction","Resilient Modulus Prediction"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Info","index":0,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[9,0,21,20],[22,4,22,16],[8,10,8,13],[23,4,25,16],[22,0,22,3],[23,0,25,3],[8,14,8,18],[0,2,7,18],[8,0,8,9],[41,0,43,20],[38,0,40,3],[38,4,40,16],[26,0,28,3],[26,4,28,16],[29,0,31,3],[29,4,31,16],[32,0,34,3],[32,4,34,16],[35,0,37,3],[35,4,37,16],[23,17,37,20],[38,17,40,20],[22,17,22,20]]}
[null,null,"Prediction Models for the Material Properties of Engineered Emulsion-Stabilized Cold Recycled Materials [Tensile Strength, Shear Parameters (Cohesion and Frictional Angle), Resilient Modulus]"]
[]
[]
[]
[]
[]
[]
[]
["Developed by: Ebubechukwu Al-Ihekwaba, Eshan Dave, Jo Sias",null,null,null,null,null,null,null,null,null,"Created: 4/26/2025",null,null,null,"Last Updated: 6/16/2025"]
["This excel workbook provides predictive capabilities for estimating the tensile strength, shear parameters (Cohesion and Frictional Angle) and resilient modulus of Cold recycled materials stabilized with Engineered Emulsion. These properties can be utilized in common mix design evaluation and/or performance modelling efforts within mechanistic-empirical analysis of cold recycled pavement structures. The input variables required to estimate tensile strength and shear parameters include the engineered emulsion content, presence of a chemical additive, mixture compacted density, and gradation characteristics (percentage retained on the 19-mm [3/4 inches] sieve and percentage passing the 4.75-mm [No 4.] sieve). For resilient modulus estimation, temperature is also required in addition to the variables used for tensile strength and shear parameters. These variables are selected based on their common availability in common cold recycling mix design and construction practices. This sheet provides guidelines on the required type and source of data for the input variable. Each material property is specified in different tabs within this workbook. Refer to the Task report for more details on the developed models."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Input Variable",null,null,null,"Data Description",null,null,null,null,null,null,null,null,null,null,null,null,"Data Source"]
["Engineered Emulsion Content",null,null,null,"Amount of engineered emulsion included in the mixture",null,null,null,null,null,null,null,null,null,null,null,null,"Mix Design/Quality Control (QC) Data"]
[]
[]
["Presence of Chemical Additive (Active Filler)",null,null,null,"Presence of Chemical Additive in the mixture (Indicate Yes or No)"]
[]
[]
["Density",null,null,null,"Density that material was compacted to"]
[]
[]
["%Retained on 19mm (3/4 inches) sieve",null,null,null,"Representative of the coarse fraction of the cold recycled material from Gradation Characterization Curve"]
[]
[]
["%Passing 4.75mm (No 4.) sieve",null,null,null,"Representative of the fine fraction of the cold recycled material from Gradation Characterization Curve"]
[]
[]
["Temperature (Resilient Modulus Estimations)",null,null,null,"Temperature of interest for pavement analysis",null,null,null,null,null,null,null,null,null,null,null,null,"Pavement Design Specification"]
[]
[]
["*The authors do not recommend estimation/prediction outside the range of mix variables considered during development. See final report  for more details."]

{"sheet":"Tensile Strength Prediction","index":1,"n_rows":25,"n_cols":27,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,14,24,26],[15,24,16,25],[15,26,16,26],[15,22,16,22],[2,14,3,26],[10,15,11,18],[10,20,11,21],[10,22,11,22],[10,24,11,25],[10,26,11,26],[9,1,9,4],[9,6,9,7],[9,10,9,11],[2,1,3,11],[5,6,5,7],[5,10,5,11],[6,1,6,4],[6,6,6,7],[6,10,6,11],[23,1,23,2],[23,3,23,11],[24,1,24,2],[24,3,24,11],[12,23,13,24],[15,6,15,7],[15,10,15,11],[18,6,18,7],[18,10,18,11],[12,1,12,4],[12,6,12,7],[12,10,12,11],[15,1,16,4],[18,1,19,4],[15,15,16,18],[15,20,16,21]]}
[]
[]
[null,"INPUT",null,null,null,null,null,null,null,null,null,null,null,null,"OUTPUT"]
[]
[]
[null,null,null,null,null,null,"Input fields",null,"Unit",null,"Processed input"]
[null,"Engineered Emulsion Content",null,null,null,null,2.5,null,"%",null,{"$f":"G7","v":2.5}]
[]
[]
[null,"Chemical additive present ?",null,null,null,"Yes","No",null,null,null,{"$f":"IF(G10=\"YES\",1,IF(G10=\"NO\",0,\"\"))","v":0}]
[null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,"Tensile Strength",null,null,null,null,{"$f":"(PredictTensileStrength($K$7,$K$10,$K$13,$K$16,$K$19))*0.1450377377","v":27.747713460721883},null,"psi",null,{"$f":"PredictTensileStrength($K$7, $K$10, $K$13, $K$16, $K$19)","v":191.31374979190593},null,"kPa"]
[]
[null,"Density",null,null,null,null,120,null,"pcf",null,{"$f":"ROUND((G13*16.018463374),0)","v":1922}]
[]
[]
[null,"%Retained on 19mm (3/4 inches) sieve",null,null,null,null,16.73,null,"%",null,{"$f":"G16","v":16.73},null,null,null,null,"Prediction Error Margin",null,null,null,null,2.0699999999999998,null,null,null,14.29]
[]
[]
[null,"%Passing 4.75mm (No 4.) sieve",null,null,null,null,32.450000000000003,null,"%",null,{"$f":"G19","v":32.450000000000003}]
[]
[]
[]
[]
[null,null,null,"Represents cells to be filled in by the user",null,null,null,null,null,null,null,null,null,null,"The prediction error margin is based on the RASE value during model development. "]
[null,null,null,"Represents processed input following user specification"]

{"sheet":"Shear Parameter Prediction","index":2,"n_rows":25,"n_cols":27,"rows_kept":25,"cut":false,"hidden":false,"merged":[[10,15,11,18],[10,20,11,21],[10,24,11,25],[18,15,19,18],[18,20,19,21],[2,14,3,26],[2,1,3,11],[5,6,5,7],[5,10,5,11],[6,1,6,4],[6,6,6,7],[6,10,6,11],[24,1,24,2],[24,3,24,11],[15,6,15,7],[15,10,15,11],[18,6,18,7],[18,10,18,11],[23,3,23,11],[15,1,16,4],[18,1,19,4],[9,1,9,4],[9,6,9,7],[9,10,9,11],[23,1,23,2],[7,26,8,26],[7,24,8,25],[7,22,8,22],[15,22,16,22],[12,1,12,4],[12,6,12,7],[12,10,12,11],[15,15,16,18],[15,20,16,21],[7,15,8,18],[7,20,8,21],[23,14,24,26]]}
[]
[]
[null,"INPUT",null,null,null,null,null,null,null,null,null,null,null,null,"OUTPUT"]
[]
[]
[null,null,null,null,null,null,"Input fields",null,"Unit",null,"Processed input"]
[null,"Engineered Emulsion Content",null,null,null,null,3,null,"%",null,{"$f":"G7","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cohesion",null,null,null,null,{"$f":"((PredictCohesion($K$7,$K$10,$K$13,$K$16,$K$19))*0.1450377377)","v":12.22301983081473},null,"psi",null,{"$f":"PredictCohesion($K$7, $K$10, $K$13, $K$16, $K$19)","v":84.274755140604555},null,"kPa"]
[]
[null,"Chemical additive present ?",null,null,null,"Yes","No",null,null,null,{"$f":"IF(G10=\"YES\",1,IF(G10=\"NO\",0,\"\"))","v":0}]
[null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,"Prediction Error Margin",null,null,null,null,3.39,null,null,null,23.35]
[]
[null,"Density",null,null,null,null,120.5,null,"pcf",null,{"$f":"ROUND((G13*16.018463374),0)","v":1930}]
[]
[]
[null,"%Retained on 19mm (3/4 inches) sieve",null,null,null,null,9.6,null,"%",null,{"$f":"G16","v":9.6},null,null,null,null,"Frictional Angle",null,null,null,null,{"$f":"ROUND((PredictFrictionalAngle($K$7, $K$10, $K$13, $K$16, $K$19)),0)","v":40},null,"°"]
[]
[]
[null,"%Passing 4.75mm (No 4.) sieve",null,null,null,null,42.9,null,"%",null,{"$f":"G19","v":42.9},null,null,null,null,"Prediction Error Margin",null,null,null,null,3.54]
[]
[]
[]
[]
[null,null,null,"Represents cells to be filled in by the user",null,null,null,null,null,null,null,null,null,null,"The prediction error margin is based on the RASE value during model development. "]
[null,null,null,"Represents processed input following user specification"]

{"sheet":"Resilient Modulus Prediction","index":3,"n_rows":28,"n_cols":27,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,21,7,22],[6,23,7,23],[15,21,17,22],[15,23,17,23],[15,26,17,26],[15,24,17,25],[10,26,11,26],[2,14,3,26],[6,24,7,25],[12,1,12,4],[12,6,12,7],[12,10,12,11],[6,15,7,19],[2,1,3,11],[5,6,5,7],[5,10,5,11],[6,1,6,4],[6,6,6,7],[6,10,6,11],[6,26,7,26],[9,15,10,19],[9,21,10,22],[9,24,10,25],[26,1,26,2],[26,3,26,11],[9,1,9,4],[9,6,9,7],[9,10,9,11],[27,1,27,2],[27,3,27,11],[15,15,18,19],[21,1,22,4],[21,6,21,7],[15,6,15,7],[15,10,15,11],[18,6,18,7],[18,10,18,11],[21,10,21,11],[15,1,16,4],[18,1,19,4],[26,14,27,26],[20,15,21,19],[20,21,21,22],[20,24,21,25]]}
[]
[]
[null,"INPUT",null,null,null,null,null,null,null,null,null,null,null,null,"OUTPUT"]
[]
[]
[null,null,null,null,null,null,"Input fields",null,"Unit",null,"Processed input"]
[null,"Engineered Emulsion Content",null,null,null,null,2.5,null,"%",null,{"$f":"G7","v":2.5},null,null,null,null,"Lab Resilient Modulus",null,null,null,null,null,{"$f":"((PredictResilientModulus($K$7,$K$10,$K$13,$K$16,$K$19,K22))*0.145038)","v":55.518748751729667},null,"ksi",{"$f":"PredictResilientModulus($K$7, $K$10, $K$13, $K$16, $K$19,$K$22)","v":382.78760567389008},null,"MPa"]
[]
[]
[null,"Chemical additive present ?",null,null,null,"Yes","No",null,null,null,{"$f":"IF(G10=\"YES\",1,IF(G10=\"NO\",0,\"\"))","v":0},null,null,null,null,"Prediction Error Margin",null,null,null,null,null,9.5830000000000002,null,null,66.069999999999993]
[null,null,null,null,null,"No"]
[]
[null,"Density",null,null,null,null,120,null,"pcf",null,{"$f":"ROUND((G13*16.018463374),0)","v":1922}]
[]
[]
[null,"%Retained on 19mm (3/4 inches) sieve",null,null,null,null,16.73,null,"%",null,{"$f":"G16","v":16.73},null,null,null,null,"Field Estimated Modulus",null,null,null,null,null,{"$f":"Y16*0.145038","v":158.14461645333304},null,"ksi",{"$f":"4581.19-(87.83*$K$22)-(3.27*$Y$7)+0.23*(($Y$7-420.49)*($K$22-20))","v":1090.3667759713526},null,"MPa"]
[]
[]
[null,"%Passing 4.75mm (No 4.) sieve",null,null,null,null,32.450000000000003,null,"%",null,{"$f":"G19","v":32.450000000000003}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prediction Error Margin",null,null,null,null,null,89.944999999999993,null,null,620]
[null,"Temperature (Resilient Modulus Prediction)",null,null,null,null,77,null,"°F",null,{"$f":"ROUND(($G$22-32)*(5/9),0)","v":25}]
[]
[]
[]
[]
[null,null,null,"Represents cells to be filled in by the user",null,null,null,null,null,null,null,null,null,null,"The prediction error margin is based on the RASE value during model development. "]
[null,null,null,"Represents processed input following user specification"]