{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":70,"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":"Sheet1","index":0,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,22,12],[31,0,31,2],[30,0,30,4],[23,10,23,12],[24,10,24,12],[27,5,27,8],[28,5,28,8],[29,5,29,8],[30,5,30,8],[31,5,31,8],[28,0,28,2],[27,0,27,2],[24,1,24,2],[23,4,23,8],[23,1,23,2],[24,4,24,8]]}
["                                                                                 Gradation Optimization for Granular Surface Materials\n                                                                                                                Developed in Iowa Highway Research Board Project TR-685\nPurpose:\nThis program was developed based on a performance-based free-design approach used to recycle existing degraded surface materials of granular-surfaced roads by mixing in fresh quarry materials with or without subgrade to achieve an optimized target gradation. This program was developed in the IHRB Project TR-685 sponsored by the Iowa DOT. \nTheory: \nThis program calculates the target optimal gradation based on the maximum aggregate size (Dmax) and particle size distribution shape factor (n) of Fuller’s model. The optimal range of the n value is recommended based on experimental and field test results obtained in Project TR-685. The gradation of representative existing surface and/or subgrade materials need to be accurately determined by users. If the subgrade will be incorporated to improve the plasticity of the surface material, the gradation of the existing surface plus subgrade mixture will be calculated in the program and compared to the theoretical optimal gradation, and then the missing size ranges will be identified. Since the resulting target virgin material gradation may not be locally available, the program can also optimize the proportion of two or three locally available materials to provide the closest gradation to the target virgin material gradation.  \nInputs:          \nThe green color cells are the inputs that need to be provided by users. The dry unit weights of the surface and subgrade materials can be adjusted based on users' experience. The average thicknesses and representative gradations of the existing surface aggregate and/or subgrade need to be measured. If the subgrade will not be incorporated, enter 0 for the thickness and gradation of the subgrade. The target final thickness of the surface aggregate layer must be more than four times the top size of the virgin material.\nInstructions:\n1. Click \"Enable Editing\" and then \"Enable Contents\" in the yellow security warning ribbon above. \n2. Fill in the green cells.          \n3. Enter the gradations of the available virgin materials.      \n4. If using only two materials, enter zeros in the Quarry Material C column.    \n5. Click the \"INSTALL SOLVER\" button to activate the Excel Solver Add-in.      \n6. Click the \"RUN\" button.          \n7. The optimized proportions and quantities of the virgin materials are shown in the blue cells. \n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sieve Sizes","% Passing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50.8,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50.8,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37.5,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37.5,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.4,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.4,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.049999999999997,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.049999999999997,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.7,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.7,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.51,100]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.75,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.75,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.38,100]
["District",1,null,"Project","Granular Surfaced Road",null,null,null,null,"Date","2017-09-03",null,null,null,null,null,2.38,0]
["County","YOURS",null,"Note","This is a trial version of the program",null,null,null,null,"Designer","Cheng Li"]
[]
["Road Geometry ",null,null,null,null,"Properties of Existing Materials"]
["Road Length",null,null,5280,"ft","Thickness of Existing Suface Material",null,null,null,1.5,"in.",null,null,null,null,null,1.19,100]
["Average Road Width",null,null,26,"ft","Dry Unit Weight of the Virgin Material",null,null,null,125,"pcf",null,null,null,null,null,1.19,0]
[null,null,null,null,null,"Thickness of Subgrade to be Incorporated into the Surface",null,null,null,1,"in."]
["Final Design Parameter",null,null,null,null,"Dry Unit Weight of the Subgrade",null,null,null,90,"pcf",null,null,null,null,null,0.59499999999999997,100]
["Target Final Thickness",null,null,5,"in.","Total Thickness of the Existing Surface and Subgrade",null,null,null,{"$f":"J28+J30","v":2.5},"in.",null,null,null,null,null,0.59499999999999997,0]
["Target Maximum Aggregate Size (Dmax)",null,null,1,"in."]
["Target Gradation Shape Factor (n)",null,null,0.35,"0.35 to 0.40 is recommeded. The coarseness increases as the n value increases.",null,null,null,null,null,null,null,null,null,null,null,9.51,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.51,0]
[]
["Sieve No.","Sieve size (mm)","Optimal Gradation (%)","Existing Surface Material Gradation (%)","Subgrade Gradation (%)","Calculated Gradation of the Existing Surface and Subgrade Mixture (%)","Quarry Material A (%)","Quarry Material B (%)","Quarry Material C (%)","Optimized Quarry Virgin Gradation (%)","Target Virgin Material Gradation (%)","Final Gradation with Target Virgin Material (%)","Final Gradation with Optimized Virgin Material (%)","Sq. Error","Sq. Error",null,0.29699999999999999,100]
[2,50.8,{"$f":"IF(B38>$D$33*25.4,100,(B38/($D$33*25.4))^$D$34*100)","v":100},100,100,{"$f":"(D38*$J$28*$J$29+E38*$J$30*$J$31)/($J$28*$J$29+$J$30*$J$31)","v":100},100,100,0,{"$f":"G38*($G$51/100)+H38*($H$51/100)+I38*($I$51/100)","v":100.00000056092956},100,{"$f":"F38*($J$32/$D$32)+K38*(($D$32-$J$32)/$D$32)","v":100},{"$f":"F38*($J$32/$D$32)+J38*(($D$32-$J$32)/$D$32)","v":100.00000028046477},{"$f":"(L38-C38)^2","v":0},{"$f":"(J38-K38)^2","v":3.1464197591582837E-13},null,0.29699999999999999,0]
[1.5,38.1,100,100,100,{"$f":"(D39*$J$28*$J$29+E39*$J$30*$J$31)/($J$28*$J$29+$J$30*$J$31)","v":100},100,100,0,{"$f":"G39*($G$51/100)+H39*($H$51/100)+I39*($I$51/100)","v":100.00000056092956},100,{"$f":"F39*($J$32/$D$32)+K39*(($D$32-$J$32)/$D$32)","v":100},{"$f":"F39*($J$32/$D$32)+J39*(($D$32-$J$32)/$D$32)","v":100.00000028046477},0,3.1464197591582837E-13]
[1,25.4,100,100,100,100,99,93,0,94.261928895739118,100,100,97.130964447869559,0,32.925459997553702,null,0.14899999999999999,100]
["3/4",19,90.338309534105676,93,100,95.270270270270274,77,78,0,77.789679041845957,85.40617626064936,90.338223265459817,86.529974656058116,7.4422792583321608E-9,58.011029884039971,null,0.14899999999999999,0]
["1/2",12.7,78.458409789675073,88.9,98.8,92.110810810810818,36,60,0,54.952286840259198,64.805945105578544,78.458377958194689,73.531548825535012,1.0132431434930452E-9,97.094581209696273]
["3/8",9.51,70.904105110895713,84.8,97.1,88.789189189189187,18,51,0,44.059394228663592,53.019067184549883,70.904128186869542,66.42429170892639,5.325005681413651E-10,80.275739476440179,null,7.4999999999999997E-2,100]
["#4",4.76,55.650700150584598,70.8,95.4,78.778378378378378,16,36,0,31.793572288352529,32.523195773265115,55.650787075821746,55.285975333365457,7.5559968533586095E-9,0.53235042973598756,null,7.4999999999999997E-2,0]
["#8",2.38,43.662654374968987,56.3,93.8,68.462162162162159,13,28,0,24.845179221873689,18.863157586632305,43.662659874397235,46.653670692017926,3.0243711053817024E-11,35.784582844496008]
["#16",1.19,34.257024294562669,44.7,92.3,60.137837837837836,11,21,0,18.896786161004151,8.376185280865176,34.257011559351504,39.517311999420997,1.621856034104751E-10,110.68304287918097]
["#30",0.59499999999999997,26.877516502776523,35.5,91.2,53.564864864864866,9.6,16,0,14.653943157402454,0.19009934213301216,26.877482103498938,34.109404011133662,1.1833102983451319E-9,209.20277791250808]
["#50",0.29699999999999999,21.075260744227378,27,90.3,47.529729729729731,5.4,13,0,11.401557465759641,0,23.764864864864865,29.465643597744688,7.2339703257501489,129.9955126450194]
["#100",0.14899999999999999,16.554779216004007,20.399999999999999,88,42.324324324324323,3.2,11,0,9.3594931754052269,0,21.162162162162161,25.841908749864775,21.22797761254899,87.600112500457016]
["#200",7.4999999999999997E-2,13.019060385623812,16.600000000000001,87.1,39.464864864864865,0,9.6,0,7.5809146553298223,0,19.732432432432432,23.522889760097343,45.069364238871366,57.470267011394476]
[null,null,null,null,null,"Proportion (%)",21.032139567910573,78.967860993018988,0,{"$f":"G51+H51+I51","v":100.00000056092956},100,null,null,{"$f":"SUM(N38:N50)","v":73.531312195090266},{"$f":"SUM(O38:O50)","v":899.57545679052271}]
[null,null,null,null,null,"Quantity (tons)",{"$f":"$D$28*$D$29*($D$32-$J$32)/12*$J$29*$G$51/100/2000","v":375.94949477640148},{"$f":"$D$28*$D$29*($D$32-$J$32)/12*$J$29*$H$51/100/2000","v":1411.5505152502144},{"$f":"$D$28*$D$29*($D$32-$J$32)/12*$J$29*$I$51/100/2000","v":0},{"$f":"$D$28*$D$29*($D$32-$J$32)/12*$J$29*$J$51/100/2000","v":1787.5000100266159},{"$f":"$D$28*$D$29*($D$32-$J$32)/12*$J$29*$K$51/100/2000","v":1787.5}]