{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["CA Mix Design","Custom Gradation","Data Store"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":100,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"CA Mix Design","index":0,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,12,8,12],[7,10,8,10],[0,0,0,7],[1,1,1,2],[2,1,2,7],[7,4,7,5],[7,1,7,3],[7,0,8,0],[7,6,8,6],[7,7,8,7],[7,8,7,9]]}
["Blending (proportioning) of  Aggregates to get Required Grading",{"$nulls":11},{"$f":"IF(AND(Sieve_Gradation),\"Mix Proportining satisfies required Gradation\",\"For Aggregates of given Gradations Best mix proportioning NOT possible\")","v":"Mix Proportining satisfies required Gradation"}]
["Layer",null,null,{"$f":"MATCH(B2,OFFSET(Layer_Gradation,,0,,1),0)-1","v":{"$error":"#N/A"}},{"$f":"COUNTIF(OFFSET(Layer_Gradation,0,0,,1),B2)","v":0},{"$f":"(B2<>\"\")","v":false}]
["Layer",{"$f":"IFERROR(VLOOKUP(B2,Layer,2,FALSE),\"\")","v":""},{"$nulls":9},{"$f":"AND(Layer_Valid,Gradations_Entered)","v":false}]
[]
["Mix Proportion",{"$f":"IF(B6=1,$F$6,0)","v":0.33},{"$f":"IF(C6=1,$F$6,0)","v":0.33},{"$f":"IF(D6=1,1-SUM(B5:C5),0)","v":0.33999999999999997},{"$f":"SUM(B5:D5)","v":1},{"$nulls":5},{"$f":"SUM(Deviation)","v":0}]
[null,{"$f":"IF(COUNT(Gradation_A)=Layer_Count,1,0)","v":1},{"$f":"IF(COUNT(Gradation_A)=Layer_Count,1,0)","v":1},{"$f":"IF(COUNT(Gradation_A)=Layer_Count,1,0)","v":1},{"$f":"AND(E7,SUM(B6:D6)>=2)","v":true},{"$f":"IFERROR(ROUND(1/SUM(B6:D6),2),0)","v":0.33}]
[null,{"$f":"OR(COUNT(Gradation_A)=Layer_Count,COUNTBLANK(Gradation_A)=Layer_Count)","v":true},{"$f":"OR(COUNT(Gradation_B)=Layer_Count,COUNTBLANK(Gradation_B)=Layer_Count)","v":true},{"$f":"OR(COUNT(Gradation_C)=Layer_Count,COUNTBLANK(Gradation_C)=Layer_Count)","v":true},{"$f":"AND(B7:D7)","v":true}]
["IS Sieve","Gradation of Source Aggregates",null,null,"Required Grading",null,"Mid Pint","Obtained Gradation","Gradation Valid",null,"Deviation",null,"Gradation Valid"]
[null,"A","B","C","Min","Max",null,null,"Minimum","Maximum"]
[]
[{"$nulls":6},{"$f":"(E11+F11)/2","v":0},{"$f":"B11*$B$5+C11*$C$5+D11*$D$5","v":0},{"$f":"H11-E11","v":0},{"$f":"F11-H11","v":0},{"$f":"(G11-H11)^2","v":0},null,{"$f":"AND(H11>=E11,H11<=F11)","v":true}]

{"sheet":"Custom Gradation","index":1,"n_rows":110,"n_cols":24,"rows_kept":110,"cut":false,"hidden":true,"merged":[[1,21,2,21],[1,23,2,23],[1,4,1,5],[1,6,1,16],[1,17,2,17],[1,18,2,18],[1,19,1,20]]}
[]
[null,null,null,{"$f":"COUNTA(Gradation)","v":0},"Required Gradation\n(Cumulative % by weight passing the sieve)",null,"Enter Gradations for source aggregates (Can replace letters A-K with descriptive names like coarse aggregate, sand, gravel, soil etc)",{"$nulls":10},"Mid Point","Obtained Gradation","Gradation Valid",null,"Deviation",null,"Gradation Valid"]
[null,{"$f":"AND(B5:B103)","v":true},null,"Sieve","Minimum","Maximum","A","B","C","D","E","F","G","H","I","J","K",null,null,"Minimum","Maximum"]
[0,{"$f":"OR(D4=\"\",A4>A2)","v":true}]
[{"$f":"IFERROR(MATCH(D5,Sieves,0),\"\")","v":""},{"$f":"OR(D5=\"\",A5>A3)","v":true},null,null,100,100,{"$nulls":11},{"$f":"(E5+F5)/2","v":100},{"$f":"G5*$G$108+H5*$H$108+I5*$I$108+J5*$J$108+K5*$K$108+L5*$L$108+M5*$M$108+N5*$N$108+O5*$O$108+P5*$P$108+Q5*$Q$108","v":0},{"$f":"S5-E5","v":-100},{"$f":"F5-S5","v":100},{"$f":"(S5-R5)^2","v":10000},null,{"$f":"AND(S5>=E5,S5<=F5)","v":false}]
["",{"$f":"OR(D6=\"\",A6>A5)","v":true}]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
[{"$f":"IFERROR(MATCH(D37,Sieves,0),\"\")","v":""},true]
["",{"$f":"OR(D38=\"\",A38>A37)","v":true}]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
[{"$f":"IFERROR(MATCH(D69,Sieves,0),\"\")","v":""},true]
["",{"$f":"OR(D70=\"\",A70>A69)","v":true}]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",true]
["",{"$f":"OR(D102=\"\",A102>A101)","v":true}]
["",true]
[]
[{"$nulls":6},"A","B","C","D","E","F","G","H","I","J","K"]
["Validate (Full Entrt/No Entry) of source Aggregates gradations",{"$nulls":5},{"$f":"OR(COUNT('Custom Gradation'!Gradation_A)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_A)=Sieve_Count)","v":true},{"$f":"OR(COUNT('Custom Gradation'!Gradation_B)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_B)=Sieve_Count)","v":true},{"$f":"OR(COUNT('Custom Gradation'!Gradation_C)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_C)=Sieve_Count)","v":true},{"$f":"OR(COUNT('Custom Gradation'!Gradation_D)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_D)=Sieve_Count)","v":true},{"$f":"OR(COUNT('Custom Gradation'!Gradation_E)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_E)=Sieve_Count)","v":true},{"$f":"OR(COUNT('Custom Gradation'!Gradation_F)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_F)=Sieve_Count)","v":true},{"$f":"OR(COUNT('Custom Gradation'!Gradation_G)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_G)=Sieve_Count)","v":true},{"$f":"OR(COUNT('Custom Gradation'!Gradation_H)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_H)=Sieve_Count)","v":true},{"$f":"OR(COUNT('Custom Gradation'!Gradation_I)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_I)=Sieve_Count)","v":true},{"$f":"OR(COUNT('Custom Gradation'!Gradation_J)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_J)=Sieve_Count)","v":true},{"$f":"OR(COUNT('Custom Gradation'!Gradation_K)=Sieve_Count,COUNTBLANK('Custom Gradation'!Gradation_K)=Sieve_Count)","v":true},{"$f":"AND(G106:Q106)","v":true}]
["Gradation Entered for Source Aggregates",{"$nulls":5},{"$f":"IF(COUNT('Custom Gradation'!Gradation_A)=Sieve_Count,1,0)","v":1},{"$f":"IF(COUNT('Custom Gradation'!Gradation_B)=Sieve_Count,1,0)","v":1},{"$f":"IF(COUNT('Custom Gradation'!Gradation_C)=Sieve_Count,1,0)","v":1},{"$f":"IF(COUNT('Custom Gradation'!Gradation_D)=Sieve_Count,1,0)","v":1},{"$f":"IF(COUNT('Custom Gradation'!Gradation_E)=Sieve_Count,1,0)","v":1},{"$f":"IF(COUNT('Custom Gradation'!Gradation_F)=Sieve_Count,1,0)","v":1},{"$f":"IF(COUNT('Custom Gradation'!Gradation_G)=Sieve_Count,1,0)","v":1},{"$f":"IF(COUNT('Custom Gradation'!Gradation_H)=Sieve_Count,1,0)","v":1},{"$f":"IF(COUNT('Custom Gradation'!Gradation_I)=Sieve_Count,1,0)","v":1},{"$f":"IF(COUNT('Custom Gradation'!Gradation_J)=Sieve_Count,1,0)","v":1},{"$f":"IF(COUNT('Custom Gradation'!Gradation_K)=Sieve_Count,1,0)","v":1},{"$f":"AND(R106,SUM(G107:Q107)>2)","v":true},{"$f":"IFERROR(1/SUM(G107:Q107),0)","v":9.0909090909090912E-2},null,null,{"$f":"SUM('Custom Gradation'!Deviation)","v":10000}]
[null,null,null,"Blending Proportion",null,null,{"$f":"IF(G107=1,$S$107,0)","v":9.0909090909090912E-2},{"$f":"IF(H107=1,$S$107,0)","v":9.0909090909090912E-2},9.0909090909090912E-2,9.0909090909090912E-2,9.0909090909090912E-2,9.0909090909090912E-2,9.0909090909090912E-2,9.0909090909090912E-2,9.0909090909090912E-2,9.0909090909090912E-2,9.0909090909090912E-2,{"$f":"SUM(G108:Q108)","v":1.0000000000000002}]
[]
[{"$nulls":6},{"$f":"IF(AND(Sieve_Gradation),\"Mix Proportining satisfies required Gradation\",\"For Aggregates of given Gradations Best mix proportioning NOT possible\")","v":"For Aggregates of given Gradations Best mix proportioning NOT possible"}]

{"sheet":"Data Store","index":2,"n_rows":100,"n_cols":10,"rows_kept":100,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,4,0,7]]}
["Layer",null,null,null,"Layer_Gradation",{"$nulls":4},"Sieve"]
["Short Name","Long Name","Min_Compaction",null,"Layer","Sieve","Min","Max",null,"125 mm"]
["Embankment","Embankment",0.97,null,"GSB-Gr I","53 mm",100,100,null,"112 mm"]
["Subgrade","Subgrade",1,null,"GSB-Gr I","26.50 mm",55,75,null,"106 mm"]
["Shoulders","Shoulders",1,null,"GSB-Gr I","4.75 mm",10,30,null,"100 mm"]
["GSB-Gr I","Granular Subbase - Grade I",1,null,"GSB-Gr I","75 µ",0,15,null,"90 mm"]
["GSB-Gr II","Granular Subbase - Grade II",1,null,"GSB-Gr II","53 mm",100,100,null,"80 mm"]
["GSB-Gr III","Granular Subbase - Grade III",1,null,"GSB-Gr II","26.50 mm",50,80,null,"75 mm"]
["CTS-Subbase","Cement Treated Soil Subbase",1,null,"GSB-Gr II","4.75 mm",15,35,null,"71 mm"]
["Gravel Subbase","Gravel Subbase",1,null,"GSB-Gr II","75 µ",0,15,null,"63 mm"]
["WMM","Wet Mix Macadam",1,null,"GSB-Gr III","26.5 mm",100,100,null,"56 mm"]
["WBM-Gr I","Water Bound Macadam - Grade I",1,null,"GSB-Gr III","4.75 mm",25,45,null,"53 mm"]
["WBM-Gr II","Water Bound Macadam - Grade II",1,null,"GSB-Gr III","75 µ",0,15,null,"50 mm"]
["WBM-Gr III","Water Bound Macadam - Grade III",1,null,"WBM-Gr I","125 mm",100,100,null,"45 mm"]
["CTS-Base","Cement Treated Soil Base",1,null,"WBM-Gr I","90 mm",90,100,null,"40 mm"]
["BM","Bituminious Macadam",0.95,null,"WBM-Gr I","63 mm",25,60,null,"37.5 mm"]
["OGPC","Open Graded Premix Carpet",1,null,"WBM-Gr I","45 mm",0,15,null,"35.5 mm"]
["MSS","Mixed Seal Surface",1,null,"WBM-Gr I","22.4 mm",0,5,null,"31.5 mm"]
["SDBC","Semi Dense Bituminious Concrete",0.95,null,"WBM-Gr II","90 mm",100,100,null,"28 mm"]
["DBC","Dense Bituminious Concrete",0.95,null,"WBM-Gr II","63 mm",90,100,null,"26.5 mm"]
["Custom","Custom Layer",null,null,"WBM-Gr II","53 mm",25,75,null,"25 mm"]
[{"$nulls":4},"WBM-Gr II","45 mm",0,15,null,"22.4 mm"]
[{"$nulls":4},"WBM-Gr II","22.4 mm",0,5,null,"20 mm"]
[{"$nulls":4},"WBM-Gr III","63 mm",100,100,null,"19 mm"]
[{"$nulls":4},"WBM-Gr III","53 mm",95,100,null,"18 mm"]
[{"$nulls":4},"WBM-Gr III","45 mm",65,90,null,"16 mm"]
[{"$nulls":4},"WBM-Gr III","22.4 mm",0,10,null,"14 mm"]
[{"$nulls":4},"WBM-Gr III","11.2 mm",0,5,null,"13.2 mm"]
[{"$nulls":4},"WMM","53 mm",100,100,null,"12.5 mm"]
[{"$nulls":4},"WMM","45 mm",95,100,null,"11.2 mm"]
[{"$nulls":4},"WMM","22.40 mm",60,80,null,"10 mm"]
[{"$nulls":4},"WMM","11.20 mm",40,60,null,"9.5 mm"]
[{"$nulls":4},"WMM","4.75 mm",25,40,null,"9 mm"]
[{"$nulls":4},"WMM","2.36 mm",15,30,null,"8 mm"]
[{"$nulls":4},"WMM","600 µ",8,22,null,"7.1 mm"]
[{"$nulls":4},"WMM","75 µ",0,5,null,"6.7 mm"]
[{"$nulls":9},"6.3 mm"]
[{"$nulls":9},"5.6 mm"]
[{"$nulls":9},"5 mm"]
[{"$nulls":9},"4.75 mm"]
[{"$nulls":9},"4.5 mm"]
[{"$nulls":9},"4 mm"]
[{"$nulls":9},"3.55 mm"]
[{"$nulls":9},"3.35 mm"]
[{"$nulls":9},"3.15 mm"]
[{"$nulls":9},"2.8 mm"]
[{"$nulls":9},"2.5 mm"]
[{"$nulls":9},"2.36 mm"]
[{"$nulls":9},"2.24 mm"]
[{"$nulls":9},"2 mm"]
[{"$nulls":9},"1.8 mm"]
[{"$nulls":9},"1.7 mm"]
[{"$nulls":9},"1.6 mm"]
[{"$nulls":9},"1.4 mm"]
[{"$nulls":9},"1.25 mm"]
[{"$nulls":9},"1.18 mm"]
[{"$nulls":9},"1.12 mm"]
[{"$nulls":9},"1 mm"]
[{"$nulls":9},"900 µ"]
[{"$nulls":9},"850 µ"]
[{"$nulls":9},"800 µ"]
[{"$nulls":9},"710 µ"]
[{"$nulls":9},"630 µ"]
[{"$nulls":9},"600 µ"]
[{"$nulls":9},"560 µ"]
[{"$nulls":9},"500 µ"]
[{"$nulls":9},"450 µ"]
[{"$nulls":9},"425 µ"]
[{"$nulls":9},"400 µ"]
[{"$nulls":9},"355 µ"]
[{"$nulls":9},"315 µ"]
[{"$nulls":9},"300 µ"]
[{"$nulls":9},"280 µ"]
[{"$nulls":9},"250 µ"]
[{"$nulls":9},"224 µ"]
[{"$nulls":9},"212 µ"]
[{"$nulls":9},"200 µ"]
[{"$nulls":9},"180 µ"]
[{"$nulls":9},"160 µ"]
[{"$nulls":9},"150 µ"]
[{"$nulls":9},"140 µ"]
[{"$nulls":9},"125 µ"]
[{"$nulls":9},"112 µ"]
[{"$nulls":9},"106 µ"]
[{"$nulls":9},"100 µ"]
[{"$nulls":9},"90 µ"]
[{"$nulls":9},"80 µ"]
[{"$nulls":9},"75 µ"]
[{"$nulls":9},"71 µ"]
[{"$nulls":9},"63 µ"]
[{"$nulls":9},"56 µ"]
[{"$nulls":9},"53 µ"]
[{"$nulls":9},"50 µ"]
[{"$nulls":9},"45 µ"]
[{"$nulls":9},"40 µ"]
[{"$nulls":9},"38 µ"]
[{"$nulls":9},"36 µ"]
[{"$nulls":9},"32 µ"]
[{"$nulls":9},"25 µ"]
[{"$nulls":9},"20 µ"]