{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Index","Cube","Cylinder","Beam","Database"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":42,"comments":4,"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":"Index","index":0,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[21,1,21,9],[19,1,19,7],[20,1,20,7],[30,1,30,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[0,1,0,3],[16,0,16,2],[13,0,13,2],[14,0,14,2],[0,6,0,7],[15,0,15,2],[4,0,4,2],[5,0,5,2],[7,0,7,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[6,0,6,2],[2,0,2,2],[3,0,3,2],[8,0,8,2]]}
["Name of the Work",null,null,null,{"$f":"Work_Name<>\"\"","v":false},{"$f":"AND(E1:E12)","v":false},{"$f":"IF(F1,\"Entry of Overall Data Complete & Correct\",\"Entry of Overall Data Incomplete/Incorrect\")","v":"Entry of Overall Data Incomplete/Incorrect"}]
["Program",null,"Work_ID",null,{"$f":"AND(Program<>\"\",Work_ID<>\"\")","v":false}]
["Details/Clear Identification of Concrete Structure being tested",null,null,null,{"$f":"Concrete_Member<>\"\"","v":false}]
["Date of Testing (in DD-MM-YYYY format)",null,null,null,{"$f":"Test_Date<>\"\"","v":false}]
["Grade of Concrete",null,null,null,{"$f":"Concrete_Grade<>\"\"","v":false},{"$f":"IFERROR(VALUE(RIGHT(Concrete_Grade,2)),\"\")","v":""}]
["Sampling of Concrete Specimens",null,null,null,{"$f":"Sampling_Concrete<>\"\"","v":false}]
["Classification of Concrete",null,null,null,{"$f":"Classification_Concrete<>\"\"","v":false}]
["Strength Parameter",null,null,null,{"$f":"Strength_Parameter<>\"\"","v":false}]
["No of Samples being Tested",null,null,null,{"$f":"OR(AND(Sampling_Concrete=\"Fresh Concrete\",Classification_Concrete=\"Structural Concrete\",Strength_Parameter=\"Compressive Strength\",No_Samples<>\"\"),AND(OR(Sampling_Concrete<>\"Fresh Concrete\",Classification_Concrete<>\"Structural Concrete\",Strength_Parameter<>\"Compressive Strength\"),No_Samples=\"\"))","v":true},{"$f":"IF(AND(Sampling_Concrete=\"Fresh Concrete\",Classification_Concrete=\"Structural Concrete\",Strength_Parameter=\"Compressive Strength\"), \"It is Mandatory to enter No of Samples tested\",\"\")","v":""}]
["Specimen Shape",null,null,null,{"$f":"AND(Specimen_Shape<>\"\",OR(AND(Strength_Parameter=\"Compressive Strength\",Sampling_Concrete=\"Fresh Concrete\",Specimen_Shape<>\"Beam\"),AND(Strength_Parameter=\"Compressive Strength\",Sampling_Concrete=\"Hardened Concrete\",Specimen_Shape=\"Cylinder\"),AND(Strength_Parameter<>\"Compressive Strength\",Specimen_Shape=\"Beam\")))","v":false},{"$f":"IF(D8=\"\",\"\",IF(D8=\"Compressive Strength\",IF(Sampling_Concrete=\"Fresh Concrete\", \"Specimen Shape can be Cube/Cylinder only\",\"Specimen Shape can be Cylinder only\"),\"Specimen Shape can be Beam Only\"))","v":""}]
["Age of Speciment @Testing (Days)",null,null,null,{"$f":"AND(Age_Testing<>\"\",OR(AND(Grade<25,Sampling_Concrete=\"Hardened Concrete\",Age_Testing>=14),AND(Grade>=25,Sampling_Concrete=\"Hardened Concrete\",Age_Testing>=7),AND(Sampling_Concrete=\"Fresh Concrete\",OR(Age_Testing=3,Age_Testing=7,Age_Testing=14,Age_Testing=28))))","v":false},{"$f":"IF(D6=\"\",\"\",IF(D6=\"Fresh Concrete\",\"Specimen can be Tested at 3/7/14/28 days (For more than 28 days enter 28 days)\",IF(Grade<=20,\"Cores can be taken only after 14 days\",\"Cores can be taken only after 7 days\")))","v":""}]
["Degree of Quality Control at Site",null,null,null,{"$f":"OR(AND(D6=\"Fresh Concrete\",D12<>\"\"),AND(D6<>\"Fresh Concrete\",D12=\"\"))","v":true},{"$f":"IF(Sampling_Concrete=\"\",\"\",IF(Sampling_Concrete=\"Fresh Concrete\",\"It is mandatory to enter Degree of Quality Control\",\"Do Not specify Degree of Quality Control - if entered Delete\"))","v":""}]
[]
["28-Day Charcteristic Compressive Strength of Concrete fck",null,null,{"$f":"IF(F1,VALUE(RIGHT(D5,2)),\"\")","v":""},"N/mm2"]
[{"$f":"D11&\"-Day Target Compressive Strength of Concrete f'ck\"","v":"-Day Target Compressive Strength of Concrete f'ck"},null,null,{"$f":"IF(F1,IF(D6=\"Fresh Concrete\",VLOOKUP(D11,StrengthGain_FreshConcrete,2,FALSE)*D14,0) + IF(D6=\"Hardened Concrete\",IF(D11<28,ROUND(VLOOKUP(D11,StrengthGain_HardConcrete,2,TRUE)*D14,1),IF(D11<=90,D14,ROUND(1.15*D14,0)))),\"\")","v":""},"N/mm2"]
[{"$f":"D11&\"-Day Target flexural Strength of Concrete \"","v":"-Day Target flexural Strength of Concrete "},null,null,{"$f":"IF(F1,ROUND(0.7*SQRT(D15),3),\"\")","v":""},"N/mm2"]
["Standard Deviation σ",null,null,{"$f":"IF(F1,IF(OR(D14=\"\",D12=\"\"),0,IF(D14<=15,3.5,IF(D14<=25,4,5)) + IF(D12=\"Average\",1,0)),0)","v":0}]
[]
["Acceptance Criteria",null,null,{"$f":"D6&\"/\"&D7&\"/\"&D8","v":"//"}]
["Criteria-1",{"$f":"IF($F$1,VLOOKUP($D$19,Acceptance_Criteria,2,FALSE) & \" (Rounded to nearest \" & IF(Strength_Parameter=\"Compressive Strength\",0.5,0.01)&\")\",\"\")","v":""},{"$nulls":6},{"$f":"IF(F1,VLOOKUP($D$19,Acceptance_Criteria,4,FALSE),\"\")","v":""},"N/mm2"]
["Criteria-2",{"$f":"IF($F$1,VLOOKUP($D$19,Acceptance_Criteria,3,FALSE) & \" (Rounded to nearest \" & IF(Strength_Parameter=\"Compressive Strength\",0.5,0.01)&\")\",\"\")","v":""},{"$nulls":6},{"$f":"IF(F1,VLOOKUP($D$19,Acceptance_Criteria,5,FALSE),\"\")","v":""},"N/mm2"]
["Criteria-3",{"$f":"IF(F1,\"Value of any specimen within a sample (at least 3 specimens) must not vary by more than ±15% of the average value of that sample\",\"\")","v":""}]
[]
["Note: One Sample is minimum 3 specimens"]
[]
["Legend"]
[null,"Data Input Cell"]
[null,"Help on Mouse-Over"]
[null,"Calculated Cell"]
[null,"Data Entry Complete/Valid in the adjoining Row"]
[null,"Data Entry Inomplete/Invalid - Refer to Help Text (Red-Cornered) in adjoining cell"]

{"sheet":"Cube","index":1,"n_rows":60,"n_cols":20,"rows_kept":60,"cut":false,"hidden":true,"merged":[[5,0,5,8],[6,0,6,2],[6,4,6,6],[2,0,2,1],[3,0,3,2],[3,3,3,8],[4,0,4,3],[4,4,4,8],[1,4,1,6],[1,7,1,8],[2,2,2,3],[2,4,2,5],[2,6,2,8],[17,19,19,19],[0,0,0,8],[17,11,19,11],[18,4,18,6],[17,0,19,0],[18,7,19,7],[17,10,19,10],[17,9,19,9],[17,1,17,3],[18,1,18,3],[17,4,17,7],[17,8,19,8],[14,0,14,7],[6,7,6,8],[7,0,7,3],[1,0,1,3],[15,0,15,8],[12,0,12,8],[9,0,9,6],[8,0,8,6],[10,0,10,7],[13,0,13,7],[11,0,11,2],[11,4,11,7],[0,12,0,13],[2,12,10,13],[11,12,11,13],[17,18,19,18],[17,14,19,14],[17,17,19,17],[17,15,19,15],[17,16,19,16]]}
[{"$f":"\"Name of the Work: \" &Work_Name","v":"Name of the Work: "},{"$nulls":11},"Test Results will be displayed only after cube dimension and Maximum/Failure loads of specimens are entered"]
[{"$f":"Classification_Concrete","v":0},null,null,null,{"$f":"Sampling_Concrete","v":0},null,null,{"$f":"Strength_Parameter","v":0},{"$nulls":4},"Enter Sample No to View Reasons for Failure"]
["Program",null,{"$f":"Program","v":0},null,"Work_ID",null,{"$f":"Work_ID","v":0},{"$nulls":5},{"$f":"IFERROR(INDEX(Errors_Cube,N2,1),\"\")","v":""}]
["Concrete Member",null,null,{"$f":"Concrete_Member","v":0}]
["Date of Testing",null,null,null,{"$f":"Test_Date","v":"00:00:00"}]
["Strength Determination & Acceptance Criteria"]
["Grade of Concrete",null,null,{"$f":"Concrete_Grade","v":0},"Degree of Quality Control",null,null,{"$f":"Degree_QC","v":0}]
["Age of Concrete Specimen (Days)",null,null,null,{"$f":"Age_Testing","v":0}]
["28 Days Characeritic Strength of Concrete fck",{"$nulls":6},{"$f":"Strength_28","v":""},"N/mm2"]
[{"$f":"E8 & \" Days Expected Target Strength of Concrete f'ck\"","v":"0 Days Expected Target Strength of Concrete f'ck"},{"$nulls":6},{"$f":"Target_Compression","v":""},"N/mm2"]
["Standard Deviation  for the given Grade of Concrete and degreee of quality control σ",{"$nulls":7},{"$f":"Standard_Deviation","v":0}]
["Dimension of Cube (mm)",null,null,null,"C/S area of the Cube ( mm2)",null,null,null,{"$f":"ROUND(D12^2,0)","v":0},null,null,null,{"$f":"IF(Dimension=\"\",\"Dimension of Cube to be Entered\",\"\")","v":"Dimension of Cube to be Entered"}]
["Acceptance Criteria for Cube Compressive Streength"]
[{"$f":"\"1)\"&Criteria_One&\" N/sq.mm\"","v":"1) N/sq.mm"},{"$nulls":7},{"$f":"Criteria_1","v":""}]
[{"$f":"\"2)\"&Criteria_Two& \" N/sq.mm\"","v":"2) N/sq.mm"},{"$nulls":7},{"$f":"Criteria_2","v":""}]
["3) Value of No Individual Specimen within a sample shall vary by more than ±15% of the avearge value of that sample"]
[]
["Sample No","Failure Load (kN)",null,null,"Cube Compressive Strength (N/mm2)",null,null,null,"Test Result for Individual Specimen!","Test Result for Sample","Mean of four consecutive samples","Test Result !",null,null,"Data Entry Complete","Criteria-1 Failure (Hardened)","Criteria-1 Failure (Fresh)","Criteria-2 Failure\n(Hardened)","Criteria-2 Failure\n(Fresh)","Criteria-3 Failure"]
[null,"Specimen",null,null,"Specimen",null,null,"Average"]
[null,1,2,3,1,2,3]
[1,null,null,null,{"$f":"IFERROR(IF(O21,CEILING(1000*B21/$I$12,0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O21,CEILING(1000*C21/$I$12,0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O21,CEILING(1000*D21/$I$12,0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O21,ROUND((E21+F21+G21)/3,2),\"\"),\"\")","v":""},{"$f":"IF(O21,IF(Sampling_Concrete = \"Hardened Concrete\",AND(E21>=$I$15,F21>=$I$15,G21>=$I$15,E21>=0.85*H21,E21<=1.15*H21,F21>=0.85*H21,F21<=1.15*H21,G21>=0.85*H21,G21<=1.15*H21),AND(E21>=0.85*H21,E21<=1.15*H21,F21>=0.85*H21,F21<=1.15*H21,G21>=0.85*H21,G21<=1.15*H21)),\"\")","v":""},{"$f":"IF(O21,AND(H21>=$I$15,I21),\"\")","v":""},null,null,{"$f":"IFERROR(IF(AND(P21,Sampling_Concrete=\"Hardened Concrete\"),\"/Average value of the sample (3 Specimens) is LESS than the Target Strength (Criteria-1) /\",\"\")&IF(AND(Q21,Sampling_Concrete=\"Fresh Concrete\"),\"Average of Four Consecutive Samples LESS than the Target Strength (Criteria-1)/\",\"\")&IF(AND(R21,Sampling_Concrete=\"Hardened Concrete\"),\"/Value of at least one of the specimens is LESS than Target Strength (Criteria-2) /\",\"\") &IF(AND(S21,Sampling_Concrete=\"Fresh Concrete\"),\"/Average Value of the Sample (3 specimens) is LESS than the Target Strength (Criteria-2)  /\",\"\") & IF(T21,\"/ Value of at least one specimen within a sample varies by more than +/- 15% of value of that sample /\",\"\"),\"\")","v":""},null,{"$f":"AND($D$12<>\"\"&B21<>\"\",C21<>\"\",D21<>\"\")","v":false},{"$f":"AND(O21,H21<$I$14)","v":false},false,{"$f":"AND(O21,OR(E21<$I$15,F21<$I$15,G21<$I$15))","v":false},{"$f":"AND(O21,H21<$I$15)","v":false},{"$f":"IFERROR(AND(O21,OR(E21>1.15*H21,E21<0.85*H21,F21>1.15*H21,F21<0.85*H21,G21>1.15*H21,G21<0.85*H21)),FALSE)","v":false}]
[{"$f":"A21+1","v":2},null,null,null,{"$f":"IFERROR(IF(O22,CEILING(1000*B22/$I$12,0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O22,CEILING(1000*C22/$I$12,0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O22,CEILING(1000*D22/$I$12,0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O22,ROUND((E22+F22+G22)/3,2),\"\"),\"\")","v":""},"",{"$f":"IF(O22,AND(H22>=$I$15,I22),\"\")","v":""},null,null,"",null,false,{"$f":"AND(O22,H22<$I$14)","v":false},false,{"$f":"AND(O22,OR(E22<$I$15,F22<$I$15,G22<$I$15))","v":false},{"$f":"AND(O22,H22<$I$15)","v":false},{"$f":"IFERROR(AND(O22,OR(E22>1.15*H22,E22<0.85*H22,F22>1.15*H22,F22<0.85*H22,G22>1.15*H22,G22<0.85*H22)),FALSE)","v":false}]
[{"$f":"A22+1","v":3},null,null,null,"","","","","","",null,null,"",null,false,false,false,false,false,false]
[4,null,null,null,"","","","","","",{"$f":"IFERROR(IF(O24,ROUND(SUM(H21:H24)/4,2),\"\"),\"\")","v":""},{"$f":"IF(O24,AND(K24>=$I$14,AND(J21:J24)),\"\")","v":""},"",null,false,false,{"$f":"AND(O24,K24<$I$14)","v":false},false,false,false]
[5,null,null,null,"","","","","","",{"$f":"IFERROR(IF(O25,ROUND(SUM(H22:H25)/4,2),\"\"),\"\")","v":""},{"$f":"IF(O25,AND(K25>=$I$14,AND(J22:J25)),\"\")","v":""},"",null,false,false,{"$f":"AND(O25,K25<$I$14)","v":false},false,false,false]
[6,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[7,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[8,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[9,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[10,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[11,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[12,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[13,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[14,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[15,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[16,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[17,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[18,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[19,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[20,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[21,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[22,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[23,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[24,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[25,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[26,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[27,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[28,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[29,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[30,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[31,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[32,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[33,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[34,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[35,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[36,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[37,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[38,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[39,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]
[40,null,null,null,"","","","","","","","","",null,false,false,false,false,false,false]

{"sheet":"Cylinder","index":2,"n_rows":57,"n_cols":30,"rows_kept":57,"cut":false,"hidden":true,"merged":[[1,0,1,2],[1,3,1,6],[1,7,1,8],[1,9,1,17],[14,29,16,29],[11,0,11,17],[7,7,7,17],[14,0,16,0],[14,17,16,17],[14,1,14,9],[15,1,15,3],[15,4,15,6],[15,7,15,9],[14,25,16,25],[14,26,16,26],[12,0,12,17],[14,18,16,18],[14,19,16,19],[0,0,0,17],[6,0,6,8],[6,11,6,15],[7,0,7,5],[5,0,5,3],[2,8,2,13],[2,14,2,17],[4,0,4,17],[5,15,5,16],[5,5,5,8],[5,10,5,13],[3,0,3,3],[3,4,3,13],[3,14,3,15],[3,16,3,17],[2,0,2,7],[14,28,16,28],[8,0,8,17],[9,0,9,15],[10,0,10,15],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[14,13,14,16],[14,10,14,12],[15,15,16,15],[15,16,16,16],[14,27,16,27],[14,24,16,24],[5,21,5,22],[7,21,13,22],[0,21,1,22],[14,20,16,20],[14,23,16,23]]}
[{"$f":"\"Name of the Work: \" & Work_Name","v":"Name of the Work: "},{"$nulls":20},"Test Results will be displayed only after core diameter, Failure loads, and Capped lengths of specimens are entered"]
["Program",null,null,{"$f":"Program","v":0},null,null,null,"Work_ID",null,{"$f":"Work_ID","v":0}]
[{"$f":"Classification_Concrete","v":0},{"$nulls":7},{"$f":"Sampling_Concrete","v":0},{"$nulls":5},{"$f":"Strength_Parameter","v":0}]
["Concrete Member",null,null,null,{"$f":"Concrete_Member","v":0},{"$nulls":9},"Test Date",null,{"$f":"Test_Date","v":"00:00:00"}]
["Strength Determination & Acceptance Criteria"]
["Grade of Concrete",null,null,null,{"$f":"Concrete_Grade","v":0},"Age of Concrete Core (Days)",null,null,null,{"$f":"Age_Testing","v":0},"Diameter of the Core  D (mm)",{"$nulls":4},"Core Area (mm2)",null,{"$f":"ROUND(PI()*O6*O6/4,2)","v":0},null,null,null,{"$f":"IF(Dimension<>\"\",\"\",\"Diameter of the Cylindrical Core to be entered\")","v":"Diameter of the Cylindrical Core to be entered"}]
["28 Days Characeritic Strength of Concrete fck",{"$nulls":8},{"$f":"Strength_28","v":""},"N/mm2",{"$f":"J6&\" Days Target Strength of Concrete\"","v":"0 Days Target Strength of Concrete"},{"$nulls":4},{"$f":"Target_Compression","v":""},"N/mm2",null,null,null,"Enter Sample No to View Reasons for Failure"]
["Correction factor fD for Diameter",{"$nulls":5},{"$f":"IF(O6=\"\",\"\",IF(O6<70,1.06,IF(O6<=80,1.03,1)))","v":""},"Correction factor fR for Length (capped)/Diameter Ratio R = 0.11R+0.78",{"$nulls":13},{"$f":"IFERROR(INDEX(Errors_Cylinder,W7,1),\"\")","v":""}]
["Acceptance Criteria (4 No)"]
[{"$f":"\"1)\"&Criteria_One","v":"1)"},{"$nulls":15},{"$f":"Criteria_1","v":""},"N/mm2"]
[{"$f":"\"2)\"&Criteria_Two","v":"2)"},{"$nulls":15},{"$f":"Criteria_2","v":""},"N/mm2"]
["3) Within a given sample no specimen should vary by more than ± 15% from the average value of that sample"]
["4) L/D Ratio of each specimen ≥ 1 (Else Test Specimen is discarded)"]
[]
["Sample No","Specimens",{"$nulls":8},"Corrected Core Strength (N/mm2) \nbased on Diameter and Length/Diameter Ratio",null,null,"Equivalent Cube Strength (N/mm2) = 1.25 x Corrected Core Strength",null,null,null,"Test Result for Individual Specimens","Test Result for Sample","Mean of four consecutive samples","Test Result !",null,null,"Data Entry Complete","Criteria-1 Failure (Hardened)","Criteria-1 Failure (Fresh)","Criteria-2 Failure\n(Hardened)","Criteria-2 Failure\n(Fresh)","Criteria-3 Failure","Criteria-4 Failure"]
[null,1,null,null,2,null,null,3,null,null,"Specimen1","Specimen2","Specimen3","Specimen1","Specimen2","Specimen3","Average"]
[null,"Maximum/ Failure Load (kN)","Capped Core Length (mm)","Lab Strength\n(N/mm2)","Maximum/ Failure Load (kN)","Capped Core Length (mm)","Lab Strength\n(N/mm2)","Maximum/ Failure Load (kN)","Capped Core Length (mm)","Lab Strength\n(N/mm2)"]
[1,null,null,{"$f":"IFERROR(IF(X18,CEILING(1000*B18/$R$6,0.5),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(X18,CEILING(1000*E18/$R$6,0.5),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(X18,CEILING(1000*H18/$R$6,0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X18,ROUND($G$8*(0.11*(C18/$O$6)+0.78)*D18,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X18,ROUND($G$8*(0.11*(F18/$O$6)+0.78)*G18,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X18,ROUND($G$8*(0.11*(I18/$O$6)+0.78)*J18,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X18,ROUND(1.25*K18,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X18,ROUND(1.25*L18,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X18,ROUND(1.25*M18,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X18,ROUND((N18+O18+P18)/3,2),\"\"),\"\")","v":""},{"$f":"IF(X18,AND(NOT(AD18),IF(Sampling_Concrete = \"Hardened Concrete\",AND(N18>=$Q$11,O18>=$Q$11,P18>=$Q$11,N18>=0.85*Q18,N18<=1.15*Q18,O18>=0.85*Q18,O18<=1.15*Q18,P18>=0.85*Q18,P18<=1.15*Q18),AND(N18>=0.85*Q18,N18<=1.15*Q18,O18>=0.85*Q18,O18<=1.15*Q18,P18>=0.85*Q18,P18<=1.15*Q18))),\"\")","v":""},{"$f":"IF(X18,AND(R18,IF(Sampling_Concrete=\"Fresh Concrete\",Q18>=$Q$11,Q18>=$Q$10)),\"\")","v":""},null,null,{"$f":"IFERROR(IF(AND(Y18,Sampling_Concrete=\"Hardened Concrete\"),\"/Average of three Specimens is LESS than the Target Strength (Criteria-1) /\",\"\")&IF(AND(Z18,Sampling_Concrete=\"Fresh Concrete\"),\"Average of Four Consecutive Samples LESS than the Target Strength (Criteria-1)/\",\"\")&IF(AND(AA18,Sampling_Concrete=\"Hardened Concrete\"),\"/Value of at least one of the specimens is LESS than Target Strength (Criteria-2) /\",\"\") &IF(AND(AB18,Sampling_Concrete=\"Fresh Concrete\"),\"/Average Value of the Sample is LESS than the Target Strength (Criteria-2)  /\",\"\") & IF(AC18,\"/ Value of at least one specimen within a sample varies by more than +/- 15% of value of that sample /\",\"\")& IF(AD18,\"/ L/D Ratio of at least one specimen of the sample is LESS than one /\",\"\"),\"\")","v":""},null,{"$f":"AND($O$6<>\"\",B18<>\"\",C18<>\"\",E18<>\"\",F18<>\"\",H18<>\"\",I18<>\"\")","v":false},{"$f":"AND(X18,Q18<$Q$10)","v":false},false,{"$f":"AND(X18,OR(N18<$Q$11,O18<$Q$11,P18<$Q$11))","v":false},{"$f":"AND(X18,Q18<$Q$11)","v":false},{"$f":"IFERROR(AND(X18,OR(N18>1.15*Q18,N18<0.85*Q18,O18>1.15*Q18,O18<0.85*Q18,P18>1.15*Q18,P18<0.85*Q18)),FALSE)","v":false},{"$f":"IFERROR(AND(X18,OR(C18/$O$6<1,F18/$O$6<1,I18/$O$6<1)),FALSE)","v":false}]
[{"$f":"A18+1","v":2},null,null,{"$f":"IFERROR(IF(X19,CEILING(1000*B19/$R$6,0.5),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(X19,CEILING(1000*E19/$R$6,0.5),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(X19,CEILING(1000*H19/$R$6,0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X19,ROUND($G$8*(0.11*(C19/$O$6)+0.78)*D19,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X19,ROUND($G$8*(0.11*(F19/$O$6)+0.78)*G19,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X19,ROUND($G$8*(0.11*(I19/$O$6)+0.78)*J19,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X19,ROUND(1.25*K19,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X19,ROUND(1.25*L19,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X19,ROUND(1.25*M19,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X19,ROUND((N19+O19+P19)/3,2),\"\"),\"\")","v":""},"","",null,null,"",null,{"$f":"AND($O$6<>\"\",B19<>\"\",C19<>\"\",E19<>\"\",F19<>\"\",H19<>\"\",I19<>\"\")","v":false},{"$f":"AND(X19,Q19<$Q$10)","v":false},false,{"$f":"AND(X19,OR(N19<$Q$11,O19<$Q$11,P19<$Q$11))","v":false},{"$f":"AND(X19,Q19<$Q$11)","v":false},{"$f":"IFERROR(AND(X19,OR(N19>1.15*Q19,N19<0.85*Q19,O19>1.15*Q19,O19<0.85*Q19,P19>1.15*Q19,P19<0.85*Q19)),FALSE)","v":false},false]
[{"$f":"A19+1","v":3},null,null,"",null,null,"",null,null,"","","","","","","","","","",null,null,"",null,false,false,false,false,false,false,false]
[4,null,null,"",null,null,"",null,null,"","","","","","","","","","",{"$f":"IF(AND(X21,Sampling_Concrete=\"Fresh Concrete\"),ROUND(SUM(Q18:Q21)/4,2),\"\")","v":""},{"$f":"IFERROR(IF(AND(X21,Sampling_Concrete=\"Fresh Concrete\"),AND(T21>=$Q$10,AND(S18:S21)),\"\"),\"\")","v":""},"",null,false,false,{"$f":"AND(X21,T21<$Q$10)","v":false},false,false,false,false]
[5,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,{"$f":"AND(X22,T22<$Q$10)","v":false},false,false,false,false]
[6,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[7,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[8,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[9,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[10,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[11,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[12,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[13,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[14,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[15,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[16,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[17,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[18,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[19,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[20,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[21,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[22,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[23,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[24,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[25,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[26,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[27,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[28,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[29,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[30,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[31,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[32,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[33,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[34,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[35,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[36,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[37,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[38,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[39,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]
[40,null,null,"",null,null,"",null,null,"","","","","","","","","","","","","",null,false,false,false,false,false,false,false]

{"sheet":"Beam","index":3,"n_rows":55,"n_cols":24,"rows_kept":55,"cut":false,"hidden":true,"merged":[[6,5,6,6],[6,0,6,4],[0,15,1,16],[6,15,6,16],[12,0,12,11],[0,0,0,11],[1,0,1,3],[1,4,1,7],[1,8,1,11],[3,0,3,11],[2,0,2,2],[2,3,2,8],[2,10,2,11],[4,0,4,1],[4,3,4,5],[5,0,5,4],[12,23,14,23],[12,22,14,22],[5,6,5,10],[9,0,9,10],[8,0,8,11],[6,7,6,10],[12,18,14,18],[7,8,7,10],[7,0,7,2],[7,4,7,6],[13,0,14,0],[13,7,13,10],[13,11,14,11],[13,12,14,12],[13,13,14,13],[13,1,13,3],[11,0,11,11],[13,14,14,14],[12,17,14,17],[12,19,14,19],[12,21,14,21],[12,20,14,20],[8,15,12,16],[13,4,13,6],[10,0,10,10]]}
[{"$f":"\"Name of the Work: \" & Work_Name","v":"Name of the Work: "},{"$nulls":14},"Test Results will be displayed only after Beam Dimensions, Failure loads, and Distance between Flexure crack & nearer support of specimens are entered"]
[{"$f":"Sampling_Concrete","v":0},null,null,null,{"$f":"Strength_Parameter","v":0},null,null,null,{"$f":"Classification_Concrete","v":0}]
["Concrete Member",null,null,{"$f":"Concrete_Member","v":0},{"$nulls":5},"Test Date",{"$f":"Test_Date","v":"00:00:00"}]
["Determination of Strength (N/mm2) , Acceptance Criteria, and Test Results"]
["Grade of Concrete",null,{"$f":"Concrete_Grade","v":0},"Age of Specimen(Days)@Testing",null,null,{"$f":"Age_Testing","v":0},"Characeritic Strength of Concrete fck",null,null,null,{"$f":"Strength_28","v":""}]
[{"$f":"G5& \" Days Target Compressive Strength f'ck\"","v":"0 Days Target Compressive Strength f'ck"},{"$nulls":4},{"$f":"Target_Compression","v":""},{"$f":"G5& \" Days Target Flexural Strength \"","v":"0 Days Target Flexural Strength "},{"$nulls":4},{"$f":"Target_Flexure","v":""}]
["Beam Dimensions (mm)",{"$nulls":6},"a-Critical Distance @ Test Result Discarded",null,null,null,{"$f":"IF(F7=\"\",\"\",IF(D8=600,170,110))","v":""},null,null,null,{"$f":"IF(Dimension=\"\",\"Beam Dimensions to be Entered\",\"\")","v":"Beam Dimensions to be Entered"}]
["L: Span (mm)",null,null,{"$f":"IFERROR((RIGHT(F7,3)-100),\"\")","v":""},"b: Beam Width (mm)",null,null,{"$f":"IFERROR(LEFT(F7,3),\"\")","v":""},"d: Beam Depth (mm)",null,null,{"$f":"IFERROR(MID(F7,5,3),\"\")","v":""},null,null,null,"Enter Sample No to View Reasons for Failure"]
["Acceptance Criteria (4 No)",{"$nulls":14},{"$f":"IFERROR(INDEX(Errors_Beam,Q8,1),\"\")","v":""}]
[{"$f":"\"1)\"&Criteria_One & \" N/sq.mm\"","v":"1) N/sq.mm"},{"$nulls":10},{"$f":"Criteria_1","v":""}]
[{"$f":"\"2)\"&Criteria_Two & \" N/sq.mm\"","v":"2) N/sq.mm"},{"$nulls":10},{"$f":"Criteria_2","v":""}]
["3) Value of individual specimen within a sample should not vary by more than ±15% of average value of sample"]
[{"$f":"IF(F7=\"\",\"\",\"4) 'a' - Distance Between Line of Fracture and Nearer Support must NOT exceed \" & L7 & \" mm for the given specimen of \" & F7)","v":""},{"$nulls":16},"Data Entry Complete","Criteria-1 Failure (Hardened)","Criteria-1 Failure (Fresh)","Criteria-2 Failure\n(Hardened)","Criteria-2 Failure\n(Fresh)","Criteria-3 Failure","Criteria-4 Failure"]
["Sample No","P: Maximum/ Failure Load (kN)",null,null,"a: Distance Between Line of Fracture and Nearer Support (mm)",null,null,"Flexural Strength (N/mm2)",null,null,null,"Test Result for Individual Specimen","Test Result for Sample","Mean of four consecutive samples","Test Result !"]
[null,"Speciman 1","Speciman 2","Speciman 3","Speciman 1","Speciman 2","Speciman 3","Speciman 1","Speciman 2","Speciman 3","Average"]
[1,{"$nulls":6},{"$f":"IF(R16,CEILING((1000*B16/$H$8*$L$8*$L$8)*IF(OR(AND($D$8=600,E16>=200),AND($D$8=500,E16>=133.3)),$D$8,IF(OR(AND($D$8=600,E16>=133.3),AND($D$8=500,E16>=110)),3*E16,0)),0.1),\"\")","v":""},{"$f":"IF(R16,CEILING((1000*C16/$H$8*$L$8*$L$8)*IF(OR(AND($D$8=600,F16>=200),AND($D$8=500,F16>=133.3)),$D$8,IF(OR(AND($D$8=600,F16>=133.3),AND($D$8=500,F16>=110)),3*F16,0)),0.1),\"\")","v":""},{"$f":"IF(R16,CEILING((1000*D16/$H$8*$L$8*$L$8)*IF(OR(AND($D$8=600,G16>=200),AND($D$8=500,G16>=133.3)),$D$8,IF(OR(AND($D$8=600,G16>=133.3),AND($D$8=500,G16>=110)),3*G16,0)),0.1),\"\")","v":""},{"$f":"IF(R16,ROUND((H16+I16+J16)/3,2),\"\")","v":""},{"$f":"IF(R16,AND(NOT(X16),IF(Sampling_Concrete = \"Hardened Concrete\",AND(H16>=$L$11,I16>=$L$11,J16>=$L$11,H16>=0.85*K16,H16<=1.15*K16,I16>=0.85*K16,I16<=1.15*K16,J16>=0.85*K16,J16<=1.15*K16),AND(H16>=0.85*K16,H16<=1.15*K16,I16>=0.85*K16,I16<=1.15*K16,J16>=0.85*K16,J16<=1.15*K16))),\"\")","v":""},{"$f":"IF(R16,AND(IF(Sampling_Concrete=\"Fresh Concrete\",K16>=$L$11,K16>=$L$10),L16),\"\")","v":""},null,null,{"$f":"IFERROR(IF(AND(S16,Sampling_Concrete=\"Hardened Concrete\"),\"/Average of three Specimens is LESS than the Target Strength (Criteria-1) /\",\"\")&IF(AND(T16,Sampling_Concrete=\"Fresh Concrete\"),\"Average of Four Consecutive Samples LESS than the Target Strength (Criteria-1)/\",\"\")&IF(AND(U16,Sampling_Concrete=\"Hardened Concrete\"),\"/Value of at least one of the specimens is LESS than Target Strength (Criteria-2) /\",\"\") &IF(AND(V16,Sampling_Concrete=\"Fresh Concrete\"),\"/Average Value of the Sample is LESS than the Target Strength (Criteria-2)  /\",\"\") & IF(W16,\"/ Value of at least one specimen within a sample varies by more than +/- 15% of value of that sample /\",\"\")& IF(X16,\"/ Distance Between flexural crack & nearer support is less than  /\" & $L$7,\"\"),\"\")","v":""},null,{"$f":"AND($F$7<>\"\",B16<>\"\",C16<>\"\",D16<>\"\",E16<>\"\",F16<>\"\",G16<>\"\")","v":false},{"$f":"AND(R16,K16<$L$10)","v":false},false,{"$f":"AND(R16,OR(H16<$L$11,I16<$L$11,J16<$L$11))","v":false},{"$f":"AND(R16,K16<$L$11)","v":false},{"$f":"IFERROR(AND(R16,OR(H16>1.15*K16,H16<0.85*K16,I16>1.15*K16,I16<0.85*K16,J16>1.15*K16,J16<0.85*K16)),FALSE)","v":false},{"$f":"AND(R16,OR(AND($D$8=600,OR(E16<170,F16<170,G16<170)),AND($D$8=400,OR(E16<110,F16<110,G16<110))))","v":false}]
[{"$f":"A16+1","v":2},{"$nulls":6},"","","",{"$f":"IF(R17,ROUND((H17+I17+J17)/3,2),\"\")","v":""},"","",null,null,"",null,false,{"$f":"AND(R17,K17<$L$10)","v":false},false,{"$f":"AND(R17,OR(H17<$L$11,I17<$L$11,J17<$L$11))","v":false},{"$f":"AND(R17,K17<$L$11)","v":false},{"$f":"IFERROR(AND(R17,OR(H17>1.15*K17,H17<0.85*K17,I17>1.15*K17,I17<0.85*K17,J17>1.15*K17,J17<0.85*K17)),FALSE)","v":false},{"$f":"AND(R17,OR(AND($D$8=600,OR(E17<170,F17<170,G17<170)),AND($D$8=400,OR(E17<110,F17<110,G17<110))))","v":false}]
[{"$f":"A17+1","v":3},{"$nulls":6},"","","","","","",null,null,"",null,false,false,false,false,false,false,false]
[4,{"$nulls":6},"","","","","","",{"$f":"IF(AND(R19,Sampling_Concrete=\"Fresh Concrete\"),ROUND(SUM(K16:K19)/4,2),\"\")","v":""},{"$f":"IF(AND(R19,Sampling_Concrete=\"Fresh Concrete\"),AND(N19>=$L$10,AND(M16:M19)),\"\")","v":""},"",null,false,false,{"$f":"AND(R19,N19<$L$10)","v":false},false,false,false,false]
[5,{"$nulls":6},"","","","","","","","","",null,false,false,{"$f":"AND(R20,N20<$L$10)","v":false},false,false,false,false]
[6,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[7,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[8,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[9,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[10,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[11,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[12,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[13,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[14,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[15,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[16,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[17,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[18,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[19,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[20,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[21,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[22,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[23,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[24,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[25,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[26,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[27,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[28,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[29,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[30,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[31,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[32,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[33,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[34,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[35,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[36,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[37,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[38,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[39,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]
[40,{"$nulls":6},"","","","","","","","","",null,false,false,false,false,false,false,false]

{"sheet":"Database","index":4,"n_rows":152,"n_cols":11,"rows_kept":152,"cut":false,"hidden":true,"merged":[[0,3,0,4],[0,0,0,1]]}
["Gain of Compressivve Strength of hardened concrete with age",null,null,"Gain of Compressivve Strength of fresh concrete with age",null,null,"Concrete Testing Parameter","Criteria1","Criteria2","Criteria1-Value","Criteria2-Value"]
["Days","%",null,"Days","%",null,"Fresh Concrete/Structural Concrete/Compressive Strength","Average compressive strength of any 4 consecutive samples shall not be less than maximum of (f'ck + 0.825σ, f'ck +3) OR (f'ck +4) [Based on No of samples Tested]","Average compressive strength of any sample (3 specimens) shall not be less than (f'ck-3) OR (f'ck-2) [Based on No of samples tested]",{"$f":"ROUND(IF(No_Samples >=4,MAX(Target_Compression+0.825*Standard_Deviation,Target_Compression+3),Target_Compression+4),0.5)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(No_Samples >=4,Target_Compression-3,IF(No_Samples >1,Target_Compression-2,Target_Compression+4)),0.5)","v":{"$error":"#VALUE!"}}]
[2,0.41,null,3,0.4,null,"Fresh Concrete/Structural Concrete/Flexural Strength","Average flexural strength of any 4 consecutive samples shall not be less than  f'cr+0.30","Average flexural strength of any sample (3 specimens) shall not be less than f'cr-0.30",{"$f":"CEILING(Target_Flexure+0.3,0.01)","v":{"$error":"#VALUE!"}},{"$f":"CEILING(Target_Flexure-0.3,0.01)","v":{"$error":"#VALUE!"}}]
[{"$f":"A3+2","v":4},0.6,null,7,0.65,null,"Fresh Concrete/PQC (Pavement Quality Concrete)/Compressive Strength","Average compressive strength of any 4 consecutive samples shall not be less than f'ck +3","Average compressive strength of any sample (3 specimens) shall not be less than f'ck-1",{"$f":"ROUND(Target_Compression+3,0.5)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(Target_Compression-1,0.5)","v":{"$error":"#VALUE!"}}]
[{"$f":"A4+2","v":6},0.71,null,14,0.9,null,"Fresh Concrete/PQC (Pavement Quality Concrete)/Flexural Strength","Average flexural strength of any 4 consecutive samples shall not be less than  f'cr+0.30","Average flexural strength of any sample (3 specimens) shall not be less than f'cr-0.10",{"$f":"CEILING(Target_Flexure+0.3,0.01)","v":{"$error":"#VALUE!"}},{"$f":"CEILING(Target_Flexure-0.1,0.01)","v":{"$error":"#VALUE!"}}]
[8,0.77500000000000002,null,28,1,null,"Hardened Concrete/Structural Concrete/Flexural Strength","Average flexural strength of any sample (3 specimens) shall not be less than 0.85xf'cr","Flexural strength of any individual specimen shall not be less than 0.75xf'cr",{"$f":"CEILING(0.85*Target_Flexure,0.01)","v":{"$error":"#VALUE!"}},{"$f":"CEILING(0.75*Target_Flexure,0.01)","v":{"$error":"#VALUE!"}}]
[10,0.81499999999999995,{"$nulls":4},"Hardened Concrete/PQC (Pavement Quality Concrete)/Flexural Strength","Average flexural strength of any sample (3 specimens) shall not be less than 0.85xf'cr","Flexural strength of any individual specimen shall not be less than 0.75xf'cr",{"$f":"CEILING(0.85*Target_Flexure,0.01)","v":{"$error":"#VALUE!"}},{"$f":"CEILING(0.75*Target_Flexure,0.01)","v":{"$error":"#VALUE!"}}]
[12,0.85,{"$nulls":4},"Hardened Concrete/Structural Concrete/Compressive Strength","Average compressive strength of any sample (3 specimens) shall not be less than 0.85xf'ck","Compressive strength of any individual specimen shall not be less than 0.75xf'ck",{"$f":"ROUND(0.85*Target_Compression,0.5)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(0.75*Target_Compression,0.5)","v":{"$error":"#VALUE!"}}]
[14,0.875,{"$nulls":4},"Hardened Concrete/PQC (Pavement Quality Concrete)/Compressive Strength","Average compressive strength of any sample (3 specimens) shall not be less than 0.85xf'ck","Compressive strength of any individual specimen shall not be less than 0.75xf'ck",{"$f":"ROUND(0.85*Target_Compression,0.5)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(0.75*Target_Compression,0.5)","v":{"$error":"#VALUE!"}}]
[16,0.9]
[18,0.92]
[20,0.94]
[22,0.96]
[24,0.97499999999999998]
[26,0.98499999999999999]
[28,1]
[30,1.01]
[32,1.02]
[34,1.0349999999999999]
[36,1.0449999999999999]
[38,1.0549999999999999]
[40,1.0649999999999999]
[42,1.07]
[44,1.08]
[46,1.095]
[48,1.1000000000000001]
[50,1.105]
[52,1.1100000000000001]
[54,1.1200000000000001]
[56,1.125]
[58,1.1299999999999999]
[60,1.1399999999999999]
[62,{"$f":"B32+0.005","v":1.1449999999999998}]
[64,{"$f":"B33+0.005","v":1.1499999999999997}]
[66,1.1549999999999996]
[68,1.1599999999999995]
[70,1.1649999999999994]
[72,1.1699999999999993]
[74,1.1749999999999992]
[76,1.179999999999999]
[78,1.1849999999999989]
[80,1.1899999999999988]
[82,1.1949999999999987]
[84,1.1999999999999986]
[86,1.2049999999999985]
[88,1.2099999999999984]
[90,1.2149999999999983]
[92,1.2199999999999982]
[94,1.22]
[96,1.2250000000000001]
[98,1.2350000000000001]
[100,1.2350000000000001]
[102,1.2350000000000001]
[104,1.24]
[106,1.2450000000000001]
[108,1.25]
[110,1.25]
[112,1.25]
[114,1.2549999999999999]
[116,1.2549999999999999]
[118,1.26]
[120,1.26]
[122,1.26]
[124,1.27]
[126,1.27]
[128,1.2749999999999999]
[130,1.2749999999999999]
[132,1.28]
[{"$f":"A68+2","v":134},1.2849999999999999]
[136,1.2849999999999999]
[138,1.29]
[140,1.29]
[142,1.2949999999999999]
[144,1.2949999999999999]
[146,1.3]
[148,1.3]
[150,1.3049999999999999]
[152,1.3049999999999999]
[154,1.31]
[156,1.31]
[158,1.3149999999999999]
[160,1.3149999999999999]
[162,1.3149999999999999]
[164,1.32]
[166,1.32]
[168,1.325]
[170,1.325]
[172,1.325]
[174,1.33]
[176,1.33]
[178,1.335]
[180,1.335]
[182,1.34]
[184,1.34]
[186,1.345]
[188,1.345]
[190,1.35]
[192,1.35]
[194,1.35]
[196,1.355]
[198,1.355]
[200,1.355]
[202,1.355]
[204,1.36]
[206,1.36]
[208,1.365]
[210,1.365]
[212,1.365]
[214,1.37]
[216,1.37]
[218,1.37]
[220,1.37]
[222,1.375]
[224,1.375]
[226,1.375]
[228,1.38]
[230,1.38]
[232,1.385]
[234,1.385]
[236,1.385]
[238,1.385]
[240,1.39]
[242,1.39]
[244,1.39]
[246,1.395]
[248,1.395]
[250,1.395]
[252,1.4]
[254,1.4]
[256,1.4]
[258,1.4]
[260,1.405]
[{"$f":"A132+2","v":262},1.405]
[264,1.405]
[266,1.405]
[268,1.41]
[270,1.41]
[272,1.41]
[274,1.415]
[276,1.415]
[278,1.415]
[280,1.42]
[282,1.42]
[284,1.42]
[286,1.42]
[288,1.42]
[290,1.425]
[292,1.425]
[294,1.425]
[296,1.425]
[298,1.425]
[300,1.43]