{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Soil Classification","Database"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":19,"comments":1,"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":"Soil Classification","index":0,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,3,33,4],[33,15,33,17],[33,12,33,14],[33,5,33,11],[14,5,14,9],[30,2,30,10],[31,2,32,10],[0,2,0,17],[16,10,17,10],[18,10,19,10],[1,5,1,7],[16,5,17,6],[18,5,19,6],[16,7,17,9],[18,7,19,9],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[10,5,10,9],[11,5,11,9],[12,5,12,9],[9,5,9,10]]}
[null,null,"Classification and Identification of Soil as per IS-1498 (1970)"]
["% Passing","Sieve Size","Sieve Size (mm)","% Passing",null,"Soil Fractions (%)"]
[]
[null,null,null,"% Passing"]
[{"$f":"D30","v":0},{"$f":"C30","v":0},75,100,null,"Coarse-Grained Soils",null,{"$f":"IF(D29<>\"\",100-D29,\"\")","v":0},null,"D10",{"$f":"IF(E30,ROUND(Interpolated_Value(_xlfn.NUMBERVALUE(RIGHT(J5,2)),Size_Passing,2),4),\"\")","v":7.4999999999999997E-3},{"$nulls":7},{"$f":"E30","v":true},{"$f":"IF(S5,\"\",\"Sives and % Passing Values must not be EMPTY. Sieves to be in descending order\")","v":""}]
[{"$f":"D29","v":100},{"$f":"C29","v":7.4999999999999997E-2},63,{"$f":"D5","v":100},{"$f":"AND(C6<C5,C6<>\"\",D6<>\"\")","v":true},"Fine-Grained Soils",null,{"$f":"IF(D29<>\"\",D29,\"\")","v":100},null,"D30",{"$f":"IF(E30,ROUND(Interpolated_Value(_xlfn.NUMBERVALUE(RIGHT(J6,2)),Size_Passing,2),4),\"\")","v":2.2499999999999999E-2},{"$nulls":7},{"$f":"OR(Fine_Grained_Soils<12,Plasticity_Index<>\"\")","v":false},{"$f":"IF(S6,\"\",\"Since Fines >=12%, It is mandatory to enter PI - Plasticity Index value\")","v":"Since Fines >=12%, It is mandatory to enter PI - Plasticity Index value"}]
[{"$f":"D28","v":100},{"$f":"C28","v":0.1},53,{"$f":"D6","v":100},{"$f":"AND(C7<C6,C7<>\"\",D7<>\"\")","v":true},"Gravel Fraction",null,{"$f":"IF(D18<>\"\",100-D18,\"\")","v":0},null,"D60",{"$f":"IF(E30,ROUND(Interpolated_Value(_xlfn.NUMBERVALUE(RIGHT(J7,2)),Size_Passing,2),4),\"\")","v":4.4999999999999998E-2},{"$nulls":7},{"$f":"OR(Fine_Grained_Soils<=50,Liquid_Limit<>\"\")","v":false},{"$f":"IF(S7,\"\",\"Since Fines >50%, It is mandatory to enter LL-Liquid Limit value\")","v":"Since Fines >50%, It is mandatory to enter LL-Liquid Limit value"}]
[{"$f":"D27","v":100},{"$f":"C27","v":0.15},45,100,true,"Sand Fraction",null,{"$f":"IF(AND(D18<>\"\",D29<>\"\"),D18-D29,\"\")","v":0},{"$nulls":10},{"$f":"OR(Liquid_Limit<20,Plasticity_Index>Plasticity_Index_A,Organic_Content<>\"\")","v":true},{"$f":"IF(S8,\"\",\"Presence/Absence of Organic Content to be specified\")","v":""}]
[{"$f":"D26","v":100},{"$f":"C26","v":0.2},37.5,100,true,{"$nulls":13},{"$f":"AND(S6:S8)","v":false},{"$f":"IF(S9,\"\",\"Correct the Above Mentioned Error(s)\")","v":"Correct the Above Mentioned Error(s)"}]
[{"$f":"D25","v":100},{"$f":"C25","v":0.3},31.5,100,true,"Fines (- 0.425 mm)"]
[{"$f":"D24","v":100},{"$f":"C24","v":0.42499999999999999},26.5,100,true,"Liquid Limit (LL)"]
[{"$f":"D23","v":100},{"$f":"C23","v":0.6},22.4,100,true,"Plasticity Index (Ip)"]
[{"$f":"D22","v":100},{"$f":"C22","v":0.9},20,100,true,"Presence of Organic Content"]
[{"$f":"D21","v":100},{"$f":"C21","v":1.18},16,100,true]
[{"$f":"D20","v":100},{"$f":"C20","v":2.36},13.2,100,true,"A-Line Plasticity Index Ip = 0.73 (LL-20) =",{"$nulls":4},{"$f":"MAX(0.73*(Liquid_Limit-20),0)","v":0}]
[{"$f":"D19","v":100},{"$f":"C19","v":2.8},10,100,true]
[{"$f":"D18","v":100},{"$f":"C18","v":4.75},6.3,100,true,"Uniformity Coefficient =",{"$nulls":4},{"$f":"IFERROR(ROUND(D_60/D_10,0),\"\")","v":6}]
[{"$f":"D17","v":100},{"$f":"C17","v":6.3},4.75,100,true]
[{"$f":"D16","v":100},{"$f":"C16","v":10},2.8,100,true,"Coeffcient of Curvature =",{"$nulls":4},{"$f":"IFERROR(ROUND(K6^2/(K5*K7),0),\"\")","v":2}]
[{"$f":"D15","v":100},{"$f":"C15","v":13.2},2.36,100,true]
[{"$f":"D14","v":100},{"$f":"C14","v":16},1.18,100,true]
[{"$f":"D13","v":100},{"$f":"C13","v":20},0.9,100,true]
[{"$f":"D12","v":100},{"$f":"C12","v":22.4},0.6,100,true]
[{"$f":"D11","v":100},{"$f":"C11","v":26.5},0.42499999999999999,100,true]
[{"$f":"D10","v":100},{"$f":"C10","v":31.5},0.3,100,true]
[{"$f":"D9","v":100},{"$f":"C9","v":37.5},0.2,100,true]
[{"$f":"D8","v":100},{"$f":"C8","v":45},0.15,100,true]
[{"$f":"D7","v":100},{"$f":"C7","v":53},0.1,100,true]
[{"$f":"D6","v":100},{"$f":"C6","v":63},{"$f":"75/1000","v":7.4999999999999997E-2},100,true]
[{"$f":"D5","v":100},{"$f":"C5","v":75},0,0,{"$f":"AND(E6:E29)","v":true}]
[null,null,"Group Symbol & Classification of Soil"]
[null,null,{"$f":"IF(Input_Valid,Soil_Classification(Coarse_Grained_Soils,Gravel_Fraction,Sand_Fraction,Fine_Grained_Soils,Uniformity_Coefficient,Curvature_Coefficient,Liquid_Limit,Plasticity_Index,Plasticity_Index_A,Organic_Content),\"\")","v":""}]
[]
[null,null,"Index","Data Input Box",null,"Mouse Over to view Help Comment (Red Dot on Top-Right Corner)",{"$nulls":6},"Data Input Correct",null,null,"Data Input Error"]

{"sheet":"Database","index":1,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Gravel Sieves","Sand Sieves1","Sand Sieves2"]
[71,4.5,0.4]
[63,3.55,0.35499999999999998]
[56,3.35,0.315]
[53,3.15,0.3]
[50,2.8,0.28000000000000003]
[45,2.5,0.25]
[40,2.36,0.224]
[37.5,2.2400000000000002,0.21199999999999999]
[31.5,2,0.2]
[28,1.8,0.18]
[26.5,1.7,0.16]
[25,1.4,0.15]
[22.4,1.25,0.14000000000000001]
[20,1.18,0.125]
[19,1.1200000000000001,0.112]
[18,1,0.106]
[16,0.9,0.1]
[14,0.85,0.09]
[13.2,0.8,0.08]
[12.5,0.71]
[11.2,0.63]
[10,0.6]
[9.5,0.56000000000000005]
[9,0.5]
[8,0.45]
[7.1]
[6.7]
[6.3]
[5.6]
[5]