{"text_format":"2","workbook":"xlsx","n_sheets":27,"sheets":["Dash Board","Design Parameters","Data Store","Calibration","Format-Calibration","Core_Cutter","Format-Core_Cutter","BT_Content","Format-BT_Content","Index","Sand_Replacement","Format-Sand_Replacement","Gradation-Soil","Gradation-WMM","Format-Gradation-WMM","Gradation-GSB-Gr I","Format-Gradation-GSB-Gr I","Gradation-GSB-Gr II","Format-Gradation-GSB-Gr II","Gradation-GSB-Gr III","Format-Gradation-GSB-Gr III","Gradation-WBM-Gr I","Format-Gradation-WBM-Gr I","Gradation-WBM-Gr II","Format-Gradation-WBM-Gr II","Gradation-WBM-Gr III","Format-Gradation-WBM-Gr III"],"not_rendered":{"charts":0,"images":170,"macros":1,"external_links":0,"defined_names":150,"comments":2,"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":"Dash Board","index":0,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[[20,0,21,0],[19,1,19,7],[1,0,2,7],[12,5,12,6],[8,0,12,4],[9,5,9,6],[10,5,10,6],[11,5,11,6],[4,3,4,4],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[14,5,14,7],[13,5,13,6],[13,0,18,4],[3,4,3,7],[3,0,3,3],[8,5,8,7],[7,5,7,7],[7,0,7,4],[4,7,5,7],[4,1,4,2],[4,0,5,0],[4,5,5,5],[4,6,5,6]]}
[]
[{"$f":"Work_Name","v":0},{"$nulls":7},{"$f":"AND(From<>\"\",To<>\"\",Test_Date<>\"\")","v":false}]
[{"$nulls":8},{"$f":"AND(Layer_Type<>\"\",Layer_Thickness<>\"\",MDD<>\"\",OMC<>\"\")","v":false}]
[{"$f":"Program","v":0},null,null,null,{"$f":"Work_ID","v":0},null,null,null,{"$f":"AND(Road_Valid,Layer_Valid,Filler_Content<>0)","v":false}]
["Length","Test Reach",null,"Layer",null,"MDD (gm/cc)","OMC (%)","BT/Filler  Content (%)"]
[null,"From","To","Type","Thickness (mm)"]
[{"$f":"Length","v":0},{"$nulls":4},{"$f":"IFERROR(VLOOKUP(Layer_Type,Design_Parameters,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Layer_Type,Design_Parameters,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Layer_Type,Design_Parameters,5,FALSE),\"\")","v":""}]
["Name of the Test",{"$nulls":4},"Parameters"]
["Compaction by Core Cutter",{"$nulls":4},"Core Cutter",null,null,{"$f":"AND(Road_Valid,Layer_Valid,I10)","v":false}]
[{"$nulls":5},"Empty Weight (gm)",null,null,{"$f":"AND(Empty_Weight_CC<>\"\",Dia_CC<>\"\",Height_CC<>\"\")","v":false}]
[{"$nulls":5},"Diameter (cm)"]
[{"$nulls":5},"Height (cm)"]
[{"$nulls":5},"Volume (cc)",null,{"$f":"ROUND(PI()*H11^2*H12/4,0)","v":0}]
["Compaction by Sand Replacement",{"$nulls":4},"Sand Density",null,null,{"$f":"AND(Road_Valid,Layer_Valid,I15)","v":false}]
[{"$nulls":5},"Calibrating Cylinder",null,null,{"$f":"AND(Sand_Density<>\"\",Dia_SR<>\"\",Height_SR<>\"\",Sand_ConeWeight<>\"\")","v":false}]
[{"$nulls":5},"Diameter (cm)"]
[{"$nulls":5},"Height (cm)"]
[{"$nulls":5},"Volume (cc)",null,{"$f":"ROUND(PI()*H16^2*H17/4,0)","v":0}]
[{"$nulls":5},"Sand Cone Weight (gm)"]
["Test Date","Test Chainages"]
[{"$nulls":8},{"$f":"IF(COUNT(Chainages)<>0,TRUE,FALSE)","v":false}]
[]
[null,null,null,{"$f":"ROUND((RANDBETWEEN(65,75)/100)*PI()*(Dia_SR^2)*(Layer_Thickness/10)*MDD/4,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND((50*50*Layer_Thickness/10)*IF(MDD<>\"\",MDD,1.4),0)","v":0},null,{"$f":"ROUND((15*15*Layer_Thickness/10)*MDD,0)","v":{"$error":"#VALUE!"}}]

{"sheet":"Design Parameters","index":1,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,7],[28,1,28,6],[1,7,4,7],[6,7,7,7],[31,1,31,6],[2,3,2,6],[3,3,3,6],[4,3,4,6],[1,3,1,6],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[27,1,27,6],[6,2,7,2],[6,3,6,6],[6,0,7,0],[6,1,7,1],[29,1,29,6],[30,1,30,6]]}
["Design Paraments for Pavement Layers"]
["Program",{"$nulls":6},{"$f":"AND(Program<>\"\",Work_ID<>\"\",Work_Name<>\"\",Length<>\"\")","v":false}]
["Work_ID/Package …"]
["Name of the Work"]
["Length (km)"]
[]
["Layer","New Technology\n(Optional)","Layer","Parameters \n(Select for at least for one layer)",null,null,null,{"$f":"AND(H9:H17,H21:H22,H25:H26,I8)","v":false}]
[null,null,null,"MDD (gm/cc)","OMC (%)","UCS (Mpa)","BT Content (%)",null,{"$f":"OR(Parameters_Defined)","v":false}]
["Embankment",null,{"$f":"IF(B9<>\"\",A9&\"{\"&B9&\")\",A9)","v":"Embankment"},{"$nulls":4},{"$f":"OR(AND(D9<>\"\",E9<>\"\"),AND(D9=\"\",E9=\"\"))","v":true},{"$f":"AND(D9<>\"\",E9<>\"\")","v":false}]
["Subgrade",null,{"$f":"IF(B10<>\"\",A10&\"{\"&B10&\")\",A10)","v":"Subgrade"},{"$nulls":4},{"$f":"OR(AND(D10<>\"\",E10<>\"\"),AND(D10=\"\",E10=\"\"))","v":true},{"$f":"AND(D10<>\"\",E10<>\"\")","v":false}]
["Shoulders",null,"Shoulders",{"$nulls":4},true,false]
["GSB-Gr I",null,"GSB-Gr I",{"$nulls":4},true,false]
["GSB-Gr II",null,"GSB-Gr II",{"$nulls":4},true,false]
["GSB-Gr III",null,"GSB-Gr III",{"$nulls":4},{"$f":"OR(AND(D14<>\"\",E14<>\"\"),AND(D14=\"\",E14=\"\"))","v":true},false]
["Sub-Base",null,"Sub-Base",{"$nulls":4},{"$f":"OR(AND(D15<>\"\",E15<>\"\",F15<>\"\"),AND(D15=\"\",E15=\"\",F15=\"\"))","v":true},{"$f":"AND(D15<>\"\",E15<>\"\",F15<>\"\")","v":false}]
["Gravel Subbase",null,"Gravel Subbase",{"$nulls":4},{"$f":"OR(AND(D16<>\"\",E16<>\"\"),AND(D16=\"\",E16=\"\"))","v":true},false]
["WMM",null,"WMM",{"$nulls":4},{"$f":"OR(AND(D17<>\"\",E17<>\"\"),AND(D17=\"\",E17=\"\"))","v":true},false]
["WBM-Gr I",null,"WBM-Gr I",{"$nulls":5},{"$f":"D18<>\"\"","v":false}]
["WBM-Gr II",null,"WBM-Gr II",{"$nulls":5},{"$f":"D19<>\"\"","v":false}]
["WBM-Gr III",null,"WBM-Gr III",{"$nulls":5},false]
["Base",null,"Base",{"$nulls":4},{"$f":"OR(AND(D21<>\"\",E21<>\"\",F21<>\"\"),AND(D21=\"\",E21=\"\",F21=\"\"))","v":true},{"$f":"AND(D21<>\"\",E21<>\"\",F21<>\"\")","v":false}]
["BM",null,"BM",{"$nulls":4},{"$f":"OR(AND(D22<>\"\",G22<>\"\"),AND(D22=\"\",G22=\"\"))","v":true},{"$f":"AND(D22<>\"\",G22<>\"\")","v":false}]
["OGPC",null,"OGPC",{"$nulls":5},{"$f":"G23<>\"\"","v":false}]
["MSS",null,"MSS",{"$nulls":5},{"$f":"G24<>\"\"","v":false}]
["SDBC",null,"SDBC",{"$nulls":4},{"$f":"OR(AND(D25<>\"\",G25<>\"\"),AND(D25=\"\",G25=\"\"))","v":true},{"$f":"AND(D25<>\"\",G25<>\"\")","v":false}]
["DBC",null,"DBC",{"$nulls":4},{"$f":"OR(AND(D26<>\"\",G26<>\"\"),AND(D26=\"\",G26=\"\"))","v":true},{"$f":"AND(D26<>\"\",G26<>\"\")","v":false}]
["Legend",null,"Legend",{"$nulls":4},{"$f":"AND(Road_Valid,Set)","v":false},{"$f":"IF(Input_Valid,\"Data Entry for Design Parameters Sufficient and Reports for Layers for which Design Parameters are specified can be generated\",\"Data Entry for Design Parameters In-Sufficient/Invalid and Reports can not be generated\")","v":"Data Entry for Design Parameters In-Sufficient/Invalid and Reports can not be generated"}]
[null,"Data Entry Cells (Enter Data only for the Layers relevant to the Work)"]
[null,"Shows additional information on Mouse Over the Cell"]
[null,"Data Entry in the Adjoining Cell Complete & Valid"]
[null,"Data Entry in the Adjoining Cell Incomplete OR Invalid"]
[null,"Cells in which Data Entry is NOT Applicable/Permitted"]
["Click Here","Go to Video -> Description Box -> click download links for updated AppFile"]

{"sheet":"Data Store","index":2,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Layer"]
["Short Name","Long Name","Min_Compaction"]
["Embankment","Embankment",0.98]
["Subgrade","Subgrade",1]
["Shoulders","Shoulders",1]
["GSB-Gr I","Granular Subbase - Grade I",1]
["GSB-Gr II","Granular Subbase - Grade II",1]
["GSB-Gr III","Granular Subbase - Grade III",1]
["Sub-Base","Stabilized Soil Subbase",1]
["Gravel Subbase","Gravel Subbase",1]
["WMM","Wet Mix Macadam",1]
["WBM-Gr I","Water Bound Macadam - Grade I",1]
["WBM-Gr II","Water Bound Macadam - Grade II",1]
["WBM-Gr III","Water Bound Macadam - Grade III",1]
["Base","Stabilized Soil Base",1]
["BM","Bituminious Macadam",0.95]
["OGPC","Open Graded Premix Carpet",1]
["MSS","Mixed Seal Surface",1]
["SDBC","Semi Dense Bituminious Concrete",0.95]
["DBC","Dense Bituminious Concrete",0.95]
[]
[]
[]
["Programs",null,"Defined_Layers"]
["PMGSY"]
["APRRP"]

{"sheet":"Calibration","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,1],[2,2,2,5],[4,0,4,5],[5,1,5,2],[5,4,5,5],[17,0,17,4],[6,0,6,4],[7,0,7,4],[12,0,12,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[9,0,9,5],[10,0,10,4],[11,0,11,4],[13,0,13,5],[8,0,8,4]]}
[]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
[]
["Calibration of  Sand Replacement Equipment"]
["Layer",{"$f":"Layer_Type","v":0},null,"*Date",{"$f":"Test_Date","v":"00:00:00"}]
["Dia of Calibrating Cylinder D (cm)",{"$nulls":4},{"$f":"Dia_SR","v":0}]
["Height of Calibrating Cylinder H (cm)",{"$nulls":4},{"$f":"Height_SR","v":0}]
["∴ Volume of Calibrating Cylinder V (cc) = ",{"$nulls":4},{"$f":"ROUND(PI()*(F7^2)*F8/4,0)","v":0}]
["Determination of Cone Weight of Calibrating Sand"]
["Weight of Sand + Pouring Cylinder (Before pouring onto a flat glass surface) W1  (gm) = ",{"$nulls":4},{"$f":"CEILING((RANDBETWEEN(90,110)/100)*MAX(PI()*1.25*Dia_SR^3,6000),100)","v":6400}]
["Weight of Sand + Pouring Cylinder (after pouring onto a flat glass surface) W2  (gm) = ",{"$nulls":4},{"$f":"F11-F13","v":6400}]
["*Weight of Sand Cone Wc (gm) = W1 - W2",{"$nulls":4},{"$f":"Sand_ConeWeight","v":0}]
["Determination of Bulk Density of Calibrating Sand"]
["*Weight of Sand + Pouring Cylinder (Before pouring into calibrating cylinder) W3  (gm) = ",{"$nulls":4},{"$f":"CEILING((RANDBETWEEN(90,110)/100)*MAX(PI()*1.25*Dia_SR^3,6000),100)","v":5600}]
["*Weight of Sand + Pouring Cylinder (After pouring into calibrating cylinder) W4 (gm)  = ",{"$nulls":4},{"$f":"F15-F17-F13","v":5600}]
["∴  Weight of Sand in Calibrating Cylinder W5  (gm) = W3-W4-Wc =",{"$nulls":4},{"$f":"ROUND(F9*F18,0)","v":0}]
["Bulk Density of Calibrating Sand ϒs  (gm/cc) = W5/V = ",{"$nulls":4},{"$f":"Sand_Density","v":0}]

{"sheet":"Format-Calibration","index":4,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[[16,0,16,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[9,0,9,4],[10,0,10,4],[11,0,11,4],[13,0,13,4],[14,0,14,4],[15,0,15,4],[8,0,8,7],[4,6,4,7],[12,0,12,7],[1,0,1,7],[2,2,2,7],[2,0,2,1],[4,0,4,4]]}
[]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
[]
["Calibration of  Sand Replacement Equipment",{"$nulls":4},"Date"]
["Dia of Calibrating Cylinder D (cm)",{"$nulls":4},10,15,20]
["Height of Calibrating Cylinder H (cm)"]
["∴ Volume of Calibrating Cylinder V (cc) = "]
["Determination of Cone Weight of Calibrating Sand"]
["Weight of Sand + Pouring Cylinder (Before pouring onto a flat glass surface) W1  (gm) = "]
["Weight of Sand + Pouring Cylinder (after pouring onto a flat glass surface) W2  (gm) = "]
["*Weight of Sand Cone Wc (gm) = W1 - W2"]
["Determination of Bulk Density of Calibrating Sand"]
["*Weight of Sand + Pouring Cylinder (Before pouring into calibrating cylinder) W3  (gm) = "]
["*Weight of Sand + Pouring Cylinder (After pouring into calibrating cylinder) W4 (gm)  = "]
["∴  Weight of Sand in Calibrating Cylinder W5  (gm) = W3-W4-Wc ="]
["Bulk Density of Calibrating Sand ϒs  (gm/cc) = W5/V = "]

{"sheet":"Core_Cutter","index":5,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":true,"merged":[[6,2,6,5],[6,9,6,15],[6,0,7,0],[6,1,7,1],[6,6,6,8],[1,0,1,15],[2,0,2,1],[4,0,4,1],[2,2,2,15],[4,2,4,15],[3,0,3,1],[3,2,3,6],[3,7,3,9],[3,10,3,15]]}
[]
["Compaction/FDD by Core Cutter Method"]
["Name of the Road",null,{"$f":"Work_Name","v":0}]
["Program",null,{"$f":"Program","v":0},{"$nulls":4},"Work_ID/Package …",null,null,{"$f":"Work_ID","v":0}]
["Layer"]
[]
["Test Date","Chainage","Calibrated Data of Core Cutter",null,null,null,"Field Data Measurements",null,null,"Calculations"]
[null,null,"Diameter  D  (cm)","Height\nH (cm)","Volume\nV0 (cc) ","Empty Weight\n W0 (gm)","Weight of Sample + Core Cutter - W1  (gm) = ","Moisture Content (m) oon Wet Sample basis [by Rapid Moisture Meter] (%) = ","Moisture Content (w) on Dry Sample basis [by Rapid Moisture Meter] (%) = 100m/(100-m)","∴  Weight of Soil Sample in Hole W2  (gm) = W1-W0=","∴  Bulk Density of Sample ϒb (gm/cc)   =   W2/V0 =","∴  Field Dry Density (FDD) of Sample ϒd (gm/cc)  \n =  ϒb/(1+w) =","Design Maximum Dry Density (MDD)  Γ  (gm/cc) =  ","∴  % Compaction of Layer =  = 100 x ϒd/Γ","Minimum Permissible Compaction of the Layer","Whether conforms to prescribed limits"]
[]
[{"$f":"TEXT(Test_Date,\"dd/mmm/yy\")","v":"00/Jan/00"},null,{"$f":"Dia_CC","v":0},{"$f":"Height_CC","v":0},{"$f":"Volume_CC","v":0},{"$f":"Empty_Weight_CC","v":0},{"$f":"J10+F10","v":{"$error":"#VALUE!"}},{"$f":"ROUND(RANDBETWEEN(50,80)*OMC/100,3)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(100*H10/(100-100*H10),4)","v":{"$error":"#VALUE!"}},{"$f":"$E$10*K10","v":{"$error":"#VALUE!"}},{"$f":"ROUND(L10*(1+I10),3)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(M10*N10/100,3)","v":{"$error":"#VALUE!"}},{"$f":"MDD","v":""},{"$f":"ROUND(MAX(O10,1)*RANDBETWEEN(10025,10250)/100,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Test_Layer,Layer,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(N10>=O10,\"Yes\",\"No\")","v":{"$error":"#N/A"}}]

{"sheet":"Format-Core_Cutter","index":6,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":true,"merged":[[4,0,4,1],[4,2,4,14],[6,0,7,0],[6,1,7,1],[6,2,6,5],[6,6,6,7],[6,8,6,14],[1,0,1,14],[2,0,2,1],[2,2,2,14],[3,0,3,1],[3,2,3,6],[3,7,3,8],[3,9,3,14]]}
[]
["Compaction/FDD by Core Cutter Method"]
["Name of the Road",null,{"$f":"Work_Name","v":0}]
["Program",null,{"$f":"Program","v":0},{"$nulls":4},"Work_ID/Package …",null,{"$f":"Work_ID","v":0}]
["Layer"]
[]
["Test Date","Chainage","Calibrated Data of Core Cutter",null,null,null,"Field Data Measurements",null,"Calculations"]
[null,null,"Diameter  D  (cm)","Height\nH (cm)","Volume\nV0 (cc) ","Empty Weight\n W0 (gm)","Weight of Sample + Core Cutter - W1  (gm) = ","Moisture Content (w) of the Sample  (%) = ","∴  Weight of Soil Sample in Hole W2  (gm) = W1-W0=","∴  Bulk Density of Sample ϒb (gm/cc)   =   W2/V0 =","∴  Field Dry Density (FDD) of Sample ϒd (gm/cc)  \n =  ϒb/(1+w) =","Design Maximum Dry Density (MDD)  Γ  (gm/cc) =  ","∴  % Compaction of Layer =  = 100 x ϒd/Γ","Minimum Permissible Compaction of the Layer","Whether conforms to prescribed limits"]

{"sheet":"BT_Content","index":7,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":true,"merged":[[6,1,6,12],[1,1,1,12],[4,2,4,12],[4,0,4,1],[5,1,5,4],[5,5,5,7],[5,8,5,12]]}
[{"$nulls":13},{"$f":"AND(B11<>\"\",M11=\"Yes\")","v":{"$error":"#VALUE!"}}]
[null,"Bituminious Content Test"]
[]
[]
["Name of the Work",null,{"$f":"Work_Name","v":0}]
["Program",{"$f":"Program","v":0},null,null,null,"Work_ID/Package…",null,null,{"$f":"Work_ID","v":0}]
["Layer"]
[]
["Test Date","Chainage","Weight of Mix Before Extraction (W1) (gm)","Weight of Filter Paper Before Extraction (B) (gm)","Weight of Mix after Extraction (W2) (gm)","Weight of Filter Paper after Extraction (D) (gm)","Weight of filler collected from extract after allowing for settling (W3) (gm)","Weight of filler collected in filter Paper (W4 = B-D) (gm)","Weight of Aggregate in Mix (W5 = W2 + W3 + W4) (gm)","Weight of BT in Mix (W6 = W1 - W5) (gm)","% of BT in total Mix = W6 x 100/W1","Design BT Mix (%)","If BT Content within permissible limits"]
[]
[{"$f":"Test_Date","v":"00:00:00"},null,{"$f":"RANDBETWEEN(495,505)","v":500},{"$f":"RANDBETWEEN(1,2)","v":2},{"$f":"I11-G11-H11","v":{"$error":"#VALUE!"}},{"$f":"D11+RANDBETWEEN(1,2)","v":4},{"$f":"RANDBETWEEN(1,3)","v":3},{"$f":"F11-D11","v":2},{"$f":"C11-J11","v":{"$error":"#VALUE!"}},{"$f":"ROUND(K11*C11,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND($L$11*RANDBETWEEN(10025,10250)/10000,4)","v":{"$error":"#VALUE!"}},{"$f":"Filler_Content","v":""},{"$f":"IF(K11>=L11,\"Yes\",\"No\")","v":{"$error":"#VALUE!"}}]

{"sheet":"Format-BT_Content","index":8,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":true,"merged":[[6,1,6,12],[1,1,1,12],[4,0,4,1],[4,2,4,12],[5,1,5,4],[5,5,5,7],[5,8,5,12]]}
[{"$nulls":13},{"$f":"AND(B11<>\"\",M11=\"Yes\")","v":false}]
[null,"Bituminious Content Test"]
[]
[]
["Name of the Work",null,{"$f":"Work_Name","v":0}]
["Program",{"$f":"Program","v":0},null,null,null,"Work_ID/Package…",null,null,{"$f":"Work_ID","v":0}]
["Layer"]
[]
["Test Date","Chainage","Weight of Mix Before Extraction (W1) (gm)","Weight of Filter Paper Before Extraction (B) (gm)","Weight of Mix after Extraction (W2) (gm)","Weight of Filter Paper after Extraction (D) (gm)","Weight of filler collected from extract after allowing for settling (W3) (gm)","Weight of filler collected in filter Paper (W4 = B-D) (gm)","Weight of Aggregate in Mix (W5 = W2 + W3 + W4) (gm)","Weight of BT in Mix (W6 = W1 - W5) (gm)","% of BT in total Mix = W6 x 100/W1","Design BT Mix (%)","If BT Content within permissible limits\n(Y/N)"]

{"sheet":"Index","index":9,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[[1,0,1,2],[2,1,2,2]]}
[]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},{"$f":"Work_ID","v":0}]
[]
["Layer","Test","Open Test Sheet"]

{"sheet":"Sand_Replacement","index":10,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,0,1,17],[5,0,6,0],[2,0,2,1],[2,14,2,17],[2,2,2,12],[5,1,6,1],[5,5,5,9],[5,10,5,17],[5,2,5,4],[3,0,3,1],[3,2,3,6],[3,8,3,10],[3,11,3,17]]}
[]
["Compaction/FDD by Sand Replacement Method"]
["Name of the Road",null,{"$f":"Work_Name","v":0},{"$nulls":10},"Layer*"]
["Program",null,{"$f":"Program","v":0},{"$nulls":5},"Work_ID/Package …",null,null,{"$f":"Work_ID","v":0}]
[]
["Test Date","Chainage","Calibrated Data of Equipment & Sand",null,null,"Field Data Measurements",{"$nulls":4},"Calculations"]
[null,null,"Diameter of Pouring/Calibrating Cylinder D (cm)","Bulk Density of Calibrated Sand ϒs (gm/cc)","Cone Weight of Calibrated SandWc (gm)","Weight of Sample in the Hole Ws (gm) =","Moisture Content (m) on Wet Sample basis(in hole) [By Rapid Moisture Method] (%) = ","Moisture Content (w) on Dry Sample basis(in hole) [By Rapid Moisture Method] (%) = 100m/(100-m)","Weight of Sand + Pouring Cylinder (Before pouring into hole) W1  (gm) = ","Weight of Sand + Pouring Cylinder (After pouring into hole) W2 (gm)  = ","∴  Weight of Sand in Hole W3  (gm) = W1-W2-Wc =","∴  Volume of Hole Vh (cc) = Weight of Sand in Hole/Bulk Density of Sand = W3/ϒs =","∴  Bulk Density of Sample ϒb (gm/cc)   =   Ws/Vh =","∴  Field Dry Density (FDD) of Sample ϒd (gm/cc)  =  ϒb/(1+w) =","Design Maximum Dry Density (MDD)  Γ  (gm/cc) =  ","Minimum Permissible Compaction of the Layer","∴  % Compaction of Layer = 100 x FDD of Sample / Design MDD = 100 x ϒd/Γ","Whether conforms to prescribed limits"]
[]
[{"$f":"TEXT(Test_Date,\"dd/mmm/yy\")","v":"00/Jan/00"},null,{"$f":"Dia_SR","v":0},{"$f":"Sand_Density","v":0},{"$f":"Sand_ConeWeight","v":0},{"$f":"ROUND(RANDBETWEEN(SR_Sample_Weight*0.95,SR_Sample_Weight*1.05),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(RANDBETWEEN(60,80)*OMC/100,3)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((100*G9/(100-100*G9)),4)","v":{"$error":"#VALUE!"}},{"$f":"CEILING((RANDBETWEEN(90,110)/100)*MAX(PI()*1.25*Dia_SR^3,6000),100)","v":6500},{"$f":"I9-K9-E9","v":{"$error":"#VALUE!"}},{"$f":"ROUND(L9*Sand_Density,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(F9/M9,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(N9*(1+H9),3)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(O9*Q9/100,3)","v":{"$error":"#VALUE!"}},{"$f":"MDD","v":""},{"$f":"VLOOKUP(Test_Layer,Layer,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"ROUND(MAX(P9,1)*RANDBETWEEN(10050,10250)/100,2)","v":{"$error":"#N/A"}},{"$f":"IF(Q9>=P9,\"Yes\",\"No\")","v":{"$error":"#N/A"}}]

{"sheet":"Format-Sand_Replacement","index":11,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":true,"merged":[[1,0,1,16],[2,0,2,1],[2,2,2,11],[2,13,2,16],[3,0,3,1],[3,2,3,6],[3,7,3,9],[3,10,3,16],[5,0,6,0],[5,1,6,1],[5,2,5,4],[5,5,5,8],[5,9,5,16]]}
[]
["Compaction/FDD by Sand Replacement Method"]
["Name of the Road",null,{"$f":"Work_Name","v":0},{"$nulls":9},"Layer*"]
["Program",null,{"$f":"Program","v":0},{"$nulls":4},"Work_ID/Package …",null,null,{"$f":"Work_ID","v":0}]
[]
["Test Date","Chainage","Calibrated Data of Equipment & Sand",null,null,"Field Data Measurements",null,null,null,"Calculations"]
[null,null,"Diameter of Pouring/Calibrating Cylinder D (cm)","Bulk Density of Calibrated Sand ϒs (gm/cc)","Cone Weight of Calibrated SandWc (gm)","Weight of Sample in the Hole Ws (gm) =","Moisture Content (w) of the Sample (in hole) [By Rapid Moisture Method/Digital Moisture Meter] (%) = ","Weight of Sand + Pouring Cylinder (Before pouring into hole) W1  (gm) = ","Weight of Sand + Pouring Cylinder (After pouring into hole) W2 (gm)  = ","∴  Weight of Sand in Hole W3  (gm) = W1-W2-Wc =","∴  Volume of Hole Vh (cc) = Weight of Sand in Hole/Bulk Density of Sand = W3/ϒs =","∴  Bulk Density of Sample ϒb (gm/cc)   =   Ws/Vh =","∴  Field Dry Density (FDD) of Sample ϒd (gm/cc)  =  ϒb/(1+w) =","Design Maximum Dry Density (MDD)  Γ  (gm/cc) =  ","Minimum Permissible Compaction of the Layer","∴  % Compaction of Layer = 100 x FDD of Sample / Design MDD = 100 x ϒd/Γ","Whether conforms to prescribed limits"]

{"sheet":"Gradation-Soil","index":12,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":true,"merged":[[37,0,37,7],[38,5,38,6],[42,0,45,7],[10,6,10,7],[10,8,11,8],[20,5,21,5],[20,6,20,7],[20,8,21,8],[20,0,21,0],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[28,0,28,2],[31,0,31,1],[32,0,32,1],[10,9,11,9],[10,10,11,10],[17,0,17,2],[36,0,36,6],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[20,9,21,9],[20,10,21,10],[33,0,33,1],[34,0,34,1],[5,6,5,7],[0,0,0,7],[1,0,1,7],[2,0,2,5],[2,6,2,7],[3,1,3,7],[5,2,5,5]]}
["Sieve Analysis of Soil"]
["Sieve Analysis of Soil (IS:2720 (Part 4) -1985) "]
[]
["Name of the Raod",{"$f":"Work_Name","v":0}]
["Section Details","Chainage","Location",null,null,null,"Date of Testing"]
[]
[]
["Sample No",{"$nulls":5},"Weight of Sample Taken [gms]"]
[]
["Dry Sieving"]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative Weight of Sample Retained (Kg)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Value (%)",null,"Minimum Retention","Maximum Retention","Validation"]
[{"$nulls":6},"Minimum","Maximum"]
["40 mm",0,{"$f":"IFERROR($B13/$H$8,\"\")","v":""},{"$f":"IF(B13=\"\",\"\",B13)","v":0},{"$f":"IFERROR(D13/$H$8,\"\")","v":""},{"$f":"IFERROR((1-E13)*100,\"\")","v":""},100,100,{"$f":"100-H13","v":0},{"$f":"100-G13","v":0},{"$f":"AND(F13>=G13,F13<=H13)","v":false}]
["25 mm",{"$f":"(RANDBETWEEN(I14,J14)*$H$8/100)-D13","v":0},{"$f":"IFERROR($B14/$H$8,\"\")","v":""},{"$f":"IF(D13=\"\",\"\",D13+B14)","v":0},{"$f":"IFERROR(D14/$H$8,\"\")","v":""},{"$f":"IFERROR((1-E14)*100,\"\")","v":""},90,100,{"$f":"100-H14","v":0},{"$f":"100-G14","v":10},{"$f":"AND(F14>=G14,F14<=H14)","v":false}]
["20 mm",{"$f":"(RANDBETWEEN(I15,J15)*$H$8/100)-D14","v":0},{"$f":"IFERROR($B15/$H$8,\"\")","v":""},{"$f":"IF(D14=\"\",\"\",D14+B15)","v":0},{"$f":"IFERROR(D15/$H$8,\"\")","v":""},"",25,60,40,75,false]
["10 mm",{"$f":"(RANDBETWEEN(I16,J16)*$H$8/100)-D15","v":0},{"$f":"IFERROR($B16/$H$8,\"\")","v":""},0,{"$f":"IFERROR(D16/$H$8,\"\")","v":""},"",0,15,85,100,false]
["4.75 mm",{"$f":"(RANDBETWEEN(I17,J17)*$H$8/100)-D16","v":0},{"$f":"IFERROR($B17/$H$8,\"\")","v":""},0,{"$f":"IFERROR(D17/$H$8,\"\")","v":""},"",0,5,95,100,false]
["PAN",null,null,{"$f":"IFERROR($H$8-D17,\"\")","v":0},{"$nulls":6},{"$f":"AND(K13,K14,K15,K16,K17)","v":false}]
[]
["Wet Sieving",{"$nulls":5},"Weight of Sample Taken [gms]",34]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative Weight of Sample Retained (Kg)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Value (%)",null,"Minimum Retention","Maximum Retention","Validation"]
[{"$nulls":6},"Minimum","Maximum"]
["2.36 mm",0,{"$f":"IFERROR($B23/$H$20,\"\")","v":0},{"$f":"IF(B23=\"\",\"\",B23)","v":0},{"$f":"IFERROR(D23/$H$20,\"\")","v":0},{"$f":"IFERROR((1-E23)*100,\"\")","v":100},100,100,{"$f":"100-H23","v":0},{"$f":"100-G23","v":0},{"$f":"AND(F23>=G23,F23<=H23)","v":true}]
["1.18 mm",{"$f":"(RANDBETWEEN(I24,J24)*$H$20/100)-D23","v":2.04},0.06,{"$f":"IF(D23=\"\",\"\",D23+B24)","v":2.04},{"$f":"IFERROR(D24/$H$20,\"\")","v":0.06},{"$f":"IFERROR((1-E24)*100,\"\")","v":94},90,100,{"$f":"100-H24","v":0},{"$f":"100-G24","v":10},{"$f":"AND(F24>=G24,F24<=H24)","v":true}]
["600 µ",{"$f":"(RANDBETWEEN(I25,J25)*$H$20/100)-D24","v":21.42},0.63,{"$f":"IF(D24=\"\",\"\",D24+B25)","v":23.46},0.69000000000000006,30.999999999999993,25,60,40,75,true]
["425 µ",{"$f":"(RANDBETWEEN(I26,J26)*$H$20/100)-D25","v":6.8000000000000007},0.2,30.26,0.89,10.999999999999998,0,15,85,100,true]
["75 µ",{"$f":"(RANDBETWEEN(I27,J27)*$H$20/100)-D26","v":1.3599999999999994},3.999999999999998E-2,31.62,0.93,6.9999999999999947,0,5,90,100,false]
["2 µ",{"$f":"(RANDBETWEEN(I28,J28)*$H$20/100)-D27","v":2.0399999999999956},5.9999999999999873E-2,{"$f":"IF(D27=\"\",\"\",D27+B28)","v":33.659999999999997},0.98999999999999988,{"$f":"IFERROR((1-E28)*100,\"\")","v":1.000000000000012},0,5,95,100,true]
["PAN",null,null,{"$f":"IFERROR($H$8-D27,\"\")","v":-31.62},{"$nulls":6},{"$f":"AND(K23,K24,K25,K26,K27)","v":false}]
[]
["Summary of Results"]
["Clay (- 2 µ) Percent"]
["Silt (-75 µ + 2 µ) Percent"]
["Sand (-4.75 mm + 75 µ)"]
["Gravel (-40 mm + 4.75 mm)"]
[]
["Whether conforms to prescribed limits",{"$nulls":6},{"$f":"IF(K18=TRUE,\"Yes\",\"No\")","v":"No"}]
["If results do not conform to the prescribed limits, NCR (Non Conformance Certificate) will be issued by the PIU, the reference of the page no on this register on which Non Conformance Reports copy preserved."]
["Page No",{"$nulls":4},"Date of Issue"]
[]
[]
["Checked By",{"$nulls":6},"Tested By"]
[]
[]
[]
[]
[]
[]
[{"$nulls":6},"(Date & Signature)"]
[{"$nulls":6}," Officer-in-charge"]

{"sheet":"Gradation-WMM","index":13,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":true,"merged":[[11,14,12,14],[11,3,12,3],[11,4,12,4],[11,5,12,5],[7,2,7,4],[11,13,12,13],[11,10,12,10],[11,11,12,11],[11,12,12,12],[11,2,12,2],[11,6,11,9],[23,0,23,4],[1,0,1,5],[2,0,2,5],[3,0,3,5],[11,0,12,0],[11,1,12,1],[4,0,4,5],[5,0,5,1],[5,2,5,5]]}
[{"$nulls":11},"c",null,null,null,{"$f":"AND(B8<>\"\",Result_Valid=\"Yes\")","v":false}]
["Test for Wet Mix Macadam"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["WMM [Sieve Range 45 mm to 600 micron]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[{"$nulls":5},{"$f":"Test_Date","v":"00:00:00"}]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]*",{"$f":"ROUND((RANDBETWEEN(95,105)/100)*Gradation_Sample_Weight,0)","v":0}]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Minimum Retention","Maximum Retention","Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range"]
["53 mm",0,{"$f":"IFERROR($B14*100/$F$10,\"\")","v":""},{"$f":"C14","v":""},{"$f":"IFERROR((100-D14),\"\")","v":""},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":0}]
["45 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K15,$F$10*L15)/100),0)-O14,\"\")","v":0},{"$f":"IFERROR(ROUND($B15*100/$F$10,2),\"\")","v":""},{"$f":"IFERROR(D14+C15,\"\")","v":""},{"$f":"IFERROR((100-D15),\"\")","v":""},{"$f":"G15&\" - \"&H15","v":"95 - 100"},95,100,{"$f":"(G15+H15)/2","v":97.5},{"$f":"H15-G15","v":5},{"$f":"100-ROUND(I15+J15/4,0)","v":1},{"$f":"100-G15","v":5},{"$f":"AND(E15>=G15,E15<=H15)","v":false},true,{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":0}]
["22.40 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K16,$F$10*L16)/100),0)-O15,\"\")","v":0},"",{"$f":"IFERROR(D15+C16,\"\")","v":""},"",{"$f":"G16&\" - \"&H16","v":"60 - 80"},60,80,70,20,25,40,false,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":0}]
["11.20 mm",0,"","","","40 - 60",40,60,50,20,45,60,false,true,0]
["4.75 mm",0,"","","","25 - 40",25,40,32.5,15,64,75,false,true,0]
["2.36 mm",0,"","","","15 - 30",15,30,22.5,15,74,85,false,true,0]
["600 µ",0,"","","","8 - 22",8,22,15,14,81,92,false,true,0]
["75 µ",0,"","","","0 - 5",0,5,2.5,5,96,100,false,true,0]
["PAN",{"$f":"$F$10-SUM(B14:B21)","v":0},{"$nulls":10},{"$f":"AND(M14:M21)","v":false},{"$f":"AND(N14:N21)","v":true}]
[]
["Whether conforms to prescribed limits",{"$nulls":4},{"$f":"IF(AND(M22,N22),\"Yes\",\"No\")","v":"No"}]

{"sheet":"Format-Gradation-WMM","index":14,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":true,"merged":[[11,14,12,14],[23,0,23,4],[11,5,12,5],[11,6,11,9],[11,10,12,10],[11,11,12,11],[11,12,12,12],[11,13,12,13],[7,2,7,4],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,1],[5,2,5,5]]}
[{"$nulls":11},"c"]
["Test for Wet Mix Macadam"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["WMM [Sieve Range 45 mm to 600 micron]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]*"]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Minimum Retention","Maximum Retention","Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range"]
["53 mm",{"$nulls":4},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":""}]
["45 mm",{"$nulls":4},{"$f":"G15&\" - \"&H15","v":"95 - 100"},95,100,{"$f":"(G15+H15)/2","v":97.5},{"$f":"H15-G15","v":5},{"$f":"100-ROUND(I15+J15/4,0)","v":1},{"$f":"100-G15","v":5},{"$f":"AND(E15>=G15,E15<=H15)","v":false},true,{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":""}]
["22.40 mm",{"$nulls":4},{"$f":"G16&\" - \"&H16","v":"60 - 80"},60,80,70,20,25,40,false,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":""}]
["11.20 mm",{"$nulls":4},"40 - 60",40,60,50,20,45,60,false,true,""]
["4.75 mm",{"$nulls":4},"25 - 40",25,40,32.5,15,64,75,false,true,""]
["2.36 mm",{"$nulls":4},"15 - 30",15,30,22.5,15,74,85,false,true,""]
["600 µ",{"$nulls":4},"8 - 22",8,22,15,14,81,92,false,true,""]
["75 µ",{"$nulls":4},"0 - 5",0,5,2.5,5,96,100,true,true,""]
["PAN",{"$nulls":11},{"$f":"AND(M14:M21)","v":false},{"$f":"AND(N14:N21)","v":true}]
[]
["Whether conforms to prescribed limits"]

{"sheet":"Gradation-GSB-Gr I","index":15,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[7,2,7,4],[4,0,4,5],[5,0,5,1],[5,2,5,5],[11,14,12,14],[19,0,19,4],[11,5,12,5],[11,12,12,12],[11,13,12,13],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,6,11,9],[11,10,11,11]]}
[{"$nulls":11},"c",null,null,null,{"$f":"AND(B8<>\"\",Result_Valid=\"Yes\")","v":false}]
[]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["GSB - Gr I  [Sieve Range 26.5 mm to 4.75 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[{"$nulls":5},{"$f":"Test_Date","v":"00:00:00"}]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]",{"$f":"ROUND((RANDBETWEEN(95,105)/100)*Gradation_Sample_Weight,0)","v":0}]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention Range",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["53 mm",0,{"$f":"IFERROR($B14*100/$F$10,\"\")","v":""},{"$f":"C14","v":""},{"$f":"IFERROR((100-D14),\"\")","v":""},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":0}]
["26.50 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K15,$F$10*L15)/100),0)-O14,\"\")","v":0},{"$f":"IFERROR(ROUND($B15*100/$F$10,2),\"\")","v":""},{"$f":"IFERROR(D14+C15,\"\")","v":""},{"$f":"IFERROR((100-D15),\"\")","v":""},{"$f":"G15&\" - \"&H15","v":"55 - 75"},55,75,{"$f":"(G15+H15)/2","v":65},{"$f":"H15-G15","v":20},{"$f":"100-ROUND(I15+J15/4,0)","v":30},{"$f":"100-G15","v":45},{"$f":"AND(E15>=G15,E15<=H15)","v":false},true,{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":0}]
["4.75 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K16,$F$10*L16)/100),0)-O15,\"\")","v":0},"",{"$f":"IFERROR(D15+C16,\"\")","v":""},"",{"$f":"G16&\" - \"&H16","v":"10 - 30"},10,30,20,20,75,90,false,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":0}]
["75 µ",0,"","","","0 - 15",0,15,7.5,15,89,100,false,true,0]
["PAN",{"$f":"$F$10-SUM(B14:B17)","v":0},{"$nulls":10},{"$f":"AND(M14:M17)","v":false},{"$f":"AND(N14:N17)","v":true}]
[]
["Whether conforms to prescribed limits",{"$nulls":4},{"$f":"IF(AND(M18,N18),\"Yes\",\"No\")","v":"No"}]

{"sheet":"Format-Gradation-GSB-Gr I","index":16,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":true,"merged":[[19,0,19,4],[11,5,12,5],[11,6,11,9],[11,10,11,11],[11,12,12,12],[11,13,12,13],[11,14,12,14],[7,2,7,4],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,1],[5,2,5,5]]}
[{"$nulls":11},"c"]
["Test for Granular Subbase - Gr I"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["GSB - Gr I  [Sieve Range 26.5 mm to 4.75 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]"]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention Range",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["53 mm",{"$nulls":4},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":""}]
["26.50 mm",{"$nulls":4},{"$f":"G15&\" - \"&H15","v":"55 - 75"},55,75,{"$f":"(G15+H15)/2","v":65},{"$f":"H15-G15","v":20},{"$f":"100-ROUND(I15+J15/4,0)","v":30},{"$f":"100-G15","v":45},{"$f":"AND(E15>=G15,E15<=H15)","v":false},true,{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":""}]
["4.75 mm",{"$nulls":4},{"$f":"G16&\" - \"&H16","v":"10 - 30"},10,30,20,20,75,90,false,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":""}]
["75 µ",{"$nulls":4},"0 - 15",0,15,7.5,15,89,100,true,true,""]
["PAN",{"$nulls":11},{"$f":"AND(M14:M17)","v":false},{"$f":"AND(N14:N17)","v":true}]
[]
["Whether conforms to prescribed limits"]

{"sheet":"Gradation-GSB-Gr II","index":17,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[7,2,7,4],[4,0,4,5],[5,0,5,1],[5,2,5,5],[11,14,12,14],[19,0,19,4],[11,5,12,5],[11,12,12,12],[11,13,12,13],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,6,11,9],[11,10,11,11]]}
[{"$nulls":11},"c",null,null,null,{"$f":"AND(B8<>\"\",Result_Valid=\"Yes\")","v":false}]
["Test for Granular Sub Base - Gr II"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["GSB - Gr II  [Sieve Range 26.5 mm to 4.75 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[{"$nulls":5},{"$f":"Test_Date","v":"00:00:00"}]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]",{"$f":"ROUND((RANDBETWEEN(95,105)/100)*Gradation_Sample_Weight,0)","v":0}]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention Range",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["53 mm",0,{"$f":"IFERROR($B14*100/$F$10,\"\")","v":""},{"$f":"C14","v":""},{"$f":"IFERROR((100-D14),\"\")","v":""},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":0}]
["26.50 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K15,$F$10*L15)/100),0)-O14,\"\")","v":0},{"$f":"IFERROR(ROUND($B15*100/$F$10,2),\"\")","v":""},{"$f":"IFERROR(D14+C15,\"\")","v":""},{"$f":"IFERROR((100-D15),\"\")","v":""},{"$f":"G15&\" - \"&H15","v":"50 - 80"},50,80,{"$f":"(G15+H15)/2","v":65},{"$f":"H15-G15","v":30},{"$f":"100-ROUND(I15+J15/4,0)","v":27},{"$f":"100-G15","v":50},{"$f":"AND(E15>=G15,E15<=H15)","v":false},true,{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":0}]
["4.75 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K16,$F$10*L16)/100),0)-O15,\"\")","v":0},"",{"$f":"IFERROR(D15+C16,\"\")","v":""},{"$f":"IFERROR((100-D16),\"\")","v":""},{"$f":"G16&\" - \"&H16","v":"15 - 35"},15,35,25,20,70,85,false,{"$f":"IFERROR((B16>=0),FALSE)","v":true},{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":0}]
["75 µ",0,"","","","0 - 15",0,15,7.5,15,89,100,false,true,0]
["PAN",{"$f":"$F$10-SUM(B14:B17)","v":0},{"$nulls":10},{"$f":"AND(M14:M17)","v":false},{"$f":"AND(N14:N17)","v":true}]
[]
["Whether conforms to prescribed limits",{"$nulls":4},{"$f":"IF(AND(M18,N18),\"Yes\",\"No\")","v":"No"}]

{"sheet":"Format-Gradation-GSB-Gr II","index":18,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,1],[5,2,5,5],[11,13,12,13],[11,14,12,14],[7,2,7,4],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[19,0,19,4],[11,5,12,5],[11,6,11,9],[11,10,11,11],[11,12,12,12]]}
[{"$nulls":11},"c"]
["Test for Granular Sub Base - Gr II"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["GSB - Gr II  [Sieve Range 26.5 mm to 4.75 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]"]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention Range",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["53 mm",{"$nulls":4},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":""}]
["26.50 mm",{"$nulls":4},{"$f":"G15&\" - \"&H15","v":"50 - 80"},50,80,{"$f":"(G15+H15)/2","v":65},{"$f":"H15-G15","v":30},{"$f":"100-ROUND(I15+J15/4,0)","v":27},{"$f":"100-G15","v":50},{"$f":"AND(E15>=G15,E15<=H15)","v":false},true,{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":""}]
["4.75 mm",{"$nulls":4},{"$f":"G16&\" - \"&H16","v":"15 - 35"},15,35,25,20,70,85,false,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":""}]
["75 µ",{"$nulls":4},"0 - 15",0,15,7.5,15,89,100,true,true,""]
["PAN",{"$nulls":11},{"$f":"AND(M14:M17)","v":false},{"$f":"AND(N14:N17)","v":true}]
[]
["Whether conforms to prescribed limits"]

{"sheet":"Gradation-GSB-Gr III","index":19,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[7,2,7,4],[4,0,4,5],[5,0,5,1],[5,2,5,5],[11,14,12,14],[18,0,18,4],[11,5,12,5],[11,12,12,12],[11,13,12,13],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,6,11,9],[11,10,11,11]]}
[{"$nulls":11},"c",null,null,null,{"$f":"AND(B8<>\"\",Result_Valid=\"Yes\")","v":false}]
[]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["GSB - Gr III  [Sieve Range 26.5 mm to 4.75 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[{"$nulls":5},{"$f":"Test_Date","v":"00:00:00"}]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]",{"$f":"ROUND((RANDBETWEEN(95,105)/100)*Gradation_Sample_Weight,0)","v":0}]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention Range",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["26.5 mm",0,{"$f":"IFERROR($B14*100/$F$10,\"\")","v":""},{"$f":"C14","v":""},{"$f":"IFERROR((100-D14),\"\")","v":""},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":0}]
["4.75 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K15,$F$10*L15)/100),0)-O14,\"\")","v":0},{"$f":"IFERROR(ROUND($B15*100/$F$10,2),\"\")","v":""},{"$f":"IFERROR(D14+C15,\"\")","v":""},{"$f":"IFERROR((100-D15),\"\")","v":""},{"$f":"G15&\" - \"&H15","v":"25 - 45"},25,45,{"$f":"(G15+H15)/2","v":35},{"$f":"H15-G15","v":20},{"$f":"100-ROUND(I15+J15/4,0)","v":60},{"$f":"100-G15","v":75},{"$f":"AND(E15>=G15,E15<=H15)","v":false},true,{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":0}]
["75 µ",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K16,$F$10*L16)/100),0)-O15,\"\")","v":0},"",{"$f":"IFERROR(D15+C16,\"\")","v":""},"",{"$f":"G16&\" - \"&H16","v":"0 - 15"},0,15,7.5,15,89,100,false,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":0}]
["PAN",{"$f":"$F$10-SUM(B14:B16)","v":0},{"$nulls":10},{"$f":"AND(M14:M16)","v":false},{"$f":"AND(N14:N16)","v":true}]
[]
["Whether conforms to prescribed limits",{"$nulls":4},{"$f":"IF(AND(M17,N17),\"Yes\",\"No\")","v":"No"}]

{"sheet":"Format-Gradation-GSB-Gr III","index":20,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":true,"merged":[[11,12,12,12],[11,13,12,13],[11,14,12,14],[7,2,7,4],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[1,0,1,5],[18,0,18,4],[11,5,12,5],[11,6,11,9],[11,10,11,11],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,1],[5,2,5,5]]}
[{"$nulls":11},"c"]
["Test for Granular Subbase - Gr III"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["GSB - Gr III  [Sieve Range 26.5 mm to 4.75 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]"]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention Range",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["26.5 mm",{"$nulls":4},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":""}]
["4.75 mm",{"$nulls":4},{"$f":"G15&\" - \"&H15","v":"25 - 45"},25,45,{"$f":"(G15+H15)/2","v":35},{"$f":"H15-G15","v":20},{"$f":"100-ROUND(I15+J15/4,0)","v":60},{"$f":"100-G15","v":75},{"$f":"AND(E15>=G15,E15<=H15)","v":false},true,{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":""}]
["75 µ",{"$nulls":4},{"$f":"G16&\" - \"&H16","v":"0 - 15"},0,15,7.5,15,89,100,true,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":""}]
["PAN",{"$nulls":11},{"$f":"AND(M14:M16)","v":false},{"$f":"AND(N14:N16)","v":true}]
[]
["Whether conforms to prescribed limits"]

{"sheet":"Gradation-WBM-Gr I","index":21,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[7,2,7,4],[4,0,4,5],[5,0,5,1],[5,2,5,5],[11,14,12,14],[20,0,20,4],[11,5,12,5],[11,12,12,12],[11,13,12,13],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,6,11,9],[11,10,11,11]]}
[{"$nulls":11},"c",null,null,null,{"$f":"AND(B8<>\"\",Result_Valid=\"Yes\")","v":false}]
["Test for Water Bound Macadam - Gr I"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["WBM - Gr I  [Sieve Range 90 mm to 45 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[{"$nulls":5},{"$f":"Test_Date","v":"00:00:00"}]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]",{"$f":"ROUND((RANDBETWEEN(95,105)/100)*Gradation_Sample_Weight,0)","v":0}]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention Range",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["125 mm",0,{"$f":"IFERROR($B14*100/$F$10,\"\")","v":""},{"$f":"C14","v":""},{"$f":"IFERROR((100-D14),\"\")","v":""},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":0}]
["90 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K15,$F$10*L15)/100),0)-O14,\"\")","v":0},{"$f":"IFERROR(ROUND($B15*100/$F$10,2),\"\")","v":""},{"$f":"IFERROR(D14+C15,\"\")","v":""},{"$f":"IFERROR((100-D15),\"\")","v":""},{"$f":"G15&\" - \"&H15","v":"90 - 100"},90,100,{"$f":"(G15+H15)/2","v":95},{"$f":"H15-G15","v":10},{"$f":"100-ROUND(I15+J15/4,0)","v":2},{"$f":"100-G15","v":10},{"$f":"AND(E15>=G15,E15<=H15)","v":false},true,{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":0}]
["63 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K16,$F$10*L16)/100),0)-O15,\"\")","v":0},"",{"$f":"IFERROR(D15+C16,\"\")","v":""},"",{"$f":"G16&\" - \"&H16","v":"25 - 60"},25,60,42.5,35,49,75,false,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":0}]
["45 mm",0,"","","","0 - 15",0,15,7.5,15,89,100,false,true,0]
["22.4 mm",0,"","","","0 - 5",0,5,2.5,5,96,100,false,true,0]
["PAN",{"$f":"$F$10-SUM(B14:B18)","v":0},{"$nulls":10},{"$f":"AND(M14:M18)","v":false},{"$f":"AND(N14:N18)","v":true}]
[]
["Whether conforms to prescribed limits",{"$nulls":4},{"$f":"IF(AND(M19,N19),\"Yes\",\"No\")","v":"No"}]

{"sheet":"Format-Gradation-WBM-Gr I","index":22,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":true,"merged":[[20,0,20,4],[11,5,12,5],[11,6,11,9],[11,10,11,11],[11,12,12,12],[11,13,12,13],[11,14,12,14],[7,2,7,4],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,1],[5,2,5,5]]}
[{"$nulls":11},"c"]
["Test for Water Bound Macadam - Gr I"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["WBM - Gr I  [Sieve Range 90 mm to 45 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]"]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention Range",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["125 mm",{"$nulls":4},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":""}]
["90 mm",{"$nulls":4},{"$f":"G15&\" - \"&H15","v":"90 - 100"},90,100,{"$f":"(G15+H15)/2","v":95},{"$f":"H15-G15","v":10},{"$f":"100-ROUND(I15+J15/4,0)","v":2},{"$f":"100-G15","v":10},{"$f":"AND(E15>=G15,E15<=H15)","v":false},true,{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":""}]
["63 mm",{"$nulls":4},{"$f":"G16&\" - \"&H16","v":"25 - 60"},25,60,42.5,35,49,75,false,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":""}]
["45 mm",{"$nulls":4},"0 - 15",0,15,7.5,15,89,100,true,true,""]
["22.4 mm",{"$nulls":4},"0 - 5",0,5,2.5,5,96,100,true,true,""]
["PAN",{"$nulls":11},{"$f":"AND(M14:M18)","v":false},{"$f":"AND(N14:N18)","v":true}]
[]
["Whether conforms to prescribed limits"]

{"sheet":"Gradation-WBM-Gr II","index":23,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[7,2,7,4],[4,0,4,5],[5,0,5,1],[5,2,5,5],[11,14,12,14],[20,0,20,4],[11,5,12,5],[11,12,12,12],[11,13,12,13],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,6,11,9],[11,10,11,11]]}
[{"$nulls":11},"c",null,null,null,{"$f":"AND(B8<>\"\",Result_Valid=\"Yes\")","v":false}]
["Test for Water Bound Macadam - Gr II"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["WBM - Gr II  [Sieve Range 63 mm to 45 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[{"$nulls":5},{"$f":"Test_Date","v":"00:00:00"}]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]",{"$f":"ROUND((RANDBETWEEN(95,105)/100)*Gradation_Sample_Weight,0)","v":0}]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["90 mm",0,{"$f":"IFERROR($B14*100/$F$10,\"\")","v":""},{"$f":"C14","v":""},{"$f":"IFERROR((100-D14),\"\")","v":""},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":0}]
["63 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K15,$F$10*L15)/100),0)-O14,\"\")","v":0},{"$f":"IFERROR(ROUND($B15*100/$F$10,2),\"\")","v":""},{"$f":"IFERROR(D14+C15,\"\")","v":""},{"$f":"IFERROR((100-D15),\"\")","v":""},{"$f":"G15&\" - \"&H15","v":"90 - 100"},90,100,{"$f":"(G15+H15)/2","v":95},{"$f":"H15-G15","v":10},{"$f":"100-ROUND(I15+J15/4,0)","v":2},{"$f":"100-G15","v":10},{"$f":"AND(E15>=G15,E15<=H15)","v":false},{"$f":"IFERROR((B15>=0),FALSE)","v":true},{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":0}]
["53 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K16,$F$10*L16)/100),0)-O15,\"\")","v":0},"",{"$f":"IFERROR(D15+C16,\"\")","v":""},"",{"$f":"G16&\" - \"&H16","v":"25 - 75"},25,75,50,50,37,75,false,{"$f":"IFERROR((B16>=0),FALSE)","v":true},{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":0}]
["45 mm",0,"","","","0 - 15",0,15,7.5,15,89,100,false,true,0]
["22.4 mm",0,"","","","0 - 5",0,5,2.5,5,96,100,false,true,0]
["PAN",{"$f":"$F$10-SUM(B14:B18)","v":0},{"$nulls":10},{"$f":"AND(M14:M18)","v":false},{"$f":"AND(N14:N18)","v":true}]
[]
["Whether conforms to prescribed limits",{"$nulls":4},{"$f":"IF(AND(M19,N19),\"Yes\",\"No\")","v":"No"}]

{"sheet":"Format-Gradation-WBM-Gr II","index":24,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":true,"merged":[[20,0,20,4],[11,5,12,5],[11,6,11,9],[11,10,11,11],[11,12,12,12],[11,13,12,13],[11,14,12,14],[7,2,7,4],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,1],[5,2,5,5]]}
[{"$nulls":11},"c"]
["Test for Water Bound Macadam - Gr II"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["WBM - Gr II  [Sieve Range 63 mm to 45 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]"]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["90 mm",{"$nulls":5},100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":""}]
["63 mm",{"$nulls":5},90,100,{"$f":"(G15+H15)/2","v":95},{"$f":"H15-G15","v":10},{"$f":"100-ROUND(I15+J15/4,0)","v":2},{"$f":"100-G15","v":10},{"$f":"AND(E15>=G15,E15<=H15)","v":false},{"$f":"IFERROR((B15>=0),FALSE)","v":true},{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":""}]
["53 mm",{"$nulls":5},25,75,50,50,37,75,false,{"$f":"IFERROR((B16>=0),FALSE)","v":true},{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":""}]
["45 mm",{"$nulls":5},0,15,7.5,15,89,100,true,true,""]
["22.4 mm",{"$nulls":5},0,5,2.5,5,96,100,true,true,""]
["PAN",{"$nulls":11},{"$f":"AND(M14:M18)","v":false},{"$f":"AND(N14:N18)","v":true}]
[]
["Whether conforms to prescribed limits"]

{"sheet":"Gradation-WBM-Gr III","index":25,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[7,2,7,4],[4,0,4,5],[5,2,5,5],[5,0,5,1],[11,14,12,14],[20,0,20,4],[11,5,12,5],[11,12,12,12],[11,13,12,13],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,6,11,9],[11,10,11,11]]}
[{"$nulls":11},"c",null,null,null,{"$f":"AND(B8<>\"\",Result_Valid=\"Yes\")","v":false}]
["Test for Water Bound Macadam - Gr III"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["WBM - Gr III  [Sieve Range 53 mm to 22.4 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[{"$nulls":5},{"$f":"Test_Date","v":"00:00:00"}]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]",{"$f":"ROUND((RANDBETWEEN(95,105)/100)*Gradation_Sample_Weight,0)","v":0}]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention Range",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["63 mm",0,{"$f":"IFERROR($B14*100/$F$10,\"\")","v":""},{"$f":"C14","v":""},{"$f":"IFERROR((100-D14),\"\")","v":""},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":0}]
["53 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K15,$F$10*L15)/100),0)-O14,\"\")","v":0},{"$f":"IFERROR(ROUND($B15*100/$F$10,2),\"\")","v":""},{"$f":"IFERROR(D14+C15,\"\")","v":""},{"$f":"IFERROR((100-D15),\"\")","v":""},{"$f":"G15&\" - \"&H15","v":"95 - 100"},95,100,{"$f":"(G15+H15)/2","v":97.5},{"$f":"H15-G15","v":5},{"$f":"100-ROUND(I15+J15/4,0)","v":1},{"$f":"100-G15","v":5},{"$f":"AND(E15>=G15,E15<=H15)","v":false},{"$f":"IFERROR((B15>=0),FALSE)","v":true},{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":0}]
["45 mm",{"$f":"IFERROR(ROUND((RANDBETWEEN($F$10*K16,$F$10*L16)/100),0)-O15,\"\")","v":0},"",{"$f":"IFERROR(D15+C16,\"\")","v":""},"",{"$f":"G16&\" - \"&H16","v":"65 - 90"},65,90,77.5,25,16,35,false,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":0}]
["22.4 mm",0,"","","","0 - 10",0,10,5,10,92,100,false,true,0]
["11.2 mm",0,"","","","0 - 5",0,5,2.5,5,96,100,false,true,0]
["PAN",{"$f":"$F$10-SUM(B14:B18)","v":0},{"$nulls":10},{"$f":"AND(M14:M18)","v":false},{"$f":"AND(N14:N18)","v":true}]
[]
["Whether conforms to prescribed limits",{"$nulls":4},{"$f":"IF(AND(M19,N19),\"Yes\",\"No\")","v":"No"}]

{"sheet":"Format-Gradation-WBM-Gr III","index":26,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,1],[5,2,5,5],[11,13,12,13],[11,14,12,14],[7,2,7,4],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[20,0,20,4],[11,5,12,5],[11,6,11,9],[11,10,11,11],[11,12,12,12]]}
[{"$nulls":11},"c"]
["Test for Water Bound Macadam - Gr III"]
["Sieve Analysis (Gradation) of Aggregate (IS:2386 Part I)"]
["WBM - Gr III  [Sieve Range 53 mm to 22.4 mm]"]
[{"$f":"Work_Name","v":0}]
[{"$f":"Program","v":0},null,{"$f":"Work_ID","v":0}]
["Section Details","Chainage*","Location",null,null,"Date of Testing*"]
[]
[]
[{"$nulls":4},"Weight of Sample Taken [gm]"]
[]
["I.S. Sieve Designation","Weight of Sample Retained (Kg)","% of Weight Retained (%)","Cumulative % of Weight Retained (%)","% of Weight Passing","Permissible Values\n (% by weight passing the sieve)"," Permissible Values\n(% passing IS sieve by weight)",null,null,null,"Random % Retention Range",null,"Range Validation","Weight Validation","Cumulative Weight of Sample Retained (Kg)"]
[{"$nulls":6},"Minimum","Maximum","Average","Range","Minimum","Maximum"]
["63 mm",{"$nulls":4},100,100,100,{"$f":"(G14+H14)/2","v":100},{"$f":"H14-G14","v":0},{"$f":"100-ROUND(I14+J14/4,0)","v":0},{"$f":"100-G14","v":0},{"$f":"AND(E14>=G14,E14<=H14)","v":false},{"$f":"IFERROR((B14>=0),FALSE)","v":true},{"$f":"IF(B14=\"\",\"\",B14)","v":""}]
["53 mm",{"$nulls":4},{"$f":"G15&\" - \"&H15","v":"95 - 100"},95,100,{"$f":"(G15+H15)/2","v":97.5},{"$f":"H15-G15","v":5},{"$f":"100-ROUND(I15+J15/4,0)","v":1},{"$f":"100-G15","v":5},{"$f":"AND(E15>=G15,E15<=H15)","v":false},{"$f":"IFERROR((B15>=0),FALSE)","v":true},{"$f":"IFERROR(IF(O14=\"\",\"\",O14+B15),\"\")","v":""}]
["45 mm",{"$nulls":4},{"$f":"G16&\" - \"&H16","v":"65 - 90"},65,90,77.5,25,16,35,false,true,{"$f":"IFERROR(IF(O15=\"\",\"\",O15+B16),\"\")","v":""}]
["22.4 mm",{"$nulls":4},"0 - 10",0,10,5,10,92,100,true,true,""]
["11.2 mm",{"$nulls":4},"0 - 5",0,5,2.5,5,96,100,true,true,""]
["PAN",{"$nulls":11},{"$f":"AND(M14:M18)","v":false},{"$f":"AND(N14:N18)","v":true}]
[]
["Whether conforms to prescribed limits"]