{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Database"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[21,0,21,1],[10,6,10,7],[3,0,3,1],[3,3,3,4],[3,6,3,7],[15,0,15,1],[15,3,15,4],[15,6,15,7]]}
["DESIGN OF CONCRETE PAVEMENTS  FOR RURAL ROADS AS PER IRC:SP 62-2014. [Ready Reckoner]"]
["Case-1: Only wheel load  stresses|Case-2: Wheel Load & Temperature  stresses | Case-3: fatigue analysis  considering wheel load and temperature stresses"]
["  Case 1: design traffic is <50 CVPD  / Case 2 : traffic is in between 50 to 150 CVPD /  Case 3  traffic is >150 CVPD"]
["Input Parameters",null,null,"Default Parameters",null,null,"Calculated Parameters"]
["No of CVPD (Commercial Vehicles/Day)",null,null,"Wheel Type (1- single/2 - dual)",2,null,"Case 1/2/3",{"$f":"IF(B5<=50,1,IF(B5<=150,2,3))","v":1}]
["Soaked Subgrade CBR (%)",null,null,"Spacing of wheels Sd (mm)",310,null,"Temperature differntial, ∆T oC                                            ",{"$f":"IFERROR(IF(B$12=1, IF(B$14<=0.2, 12*(B$14-0.15)+12.5, 24*(B$14-0.2)+13.1), IF(B$12=2,IF(B$14<=0.2, 16*(B$14-0.15)+15.6, 4*(B$14-0.2)+16.4),  IF(B$12=3,IF(B$14<=0.2, 34*(B$14-0.15)+17.3, 26*(B$14-0.2)+19),   IF(B$12=4,IF(B$14<=0.2, 28*(B$14-0.15)+15, 24*(B$14-0.2)+16.4),   IF(B$12=5,IF(B$14<=0.2, 24*(B$14-0.15)+14.6, 8*(B$14-0.2)+15.8),   IF(B$12=6,IF(B$14<=0.2, 3*(B$14-0.15)+15.5, 4*(B$14-0.2)+17),  )))) )),\"\")","v":0}]
["Type of Sub-Base/Base Proposed",null,null," Wheel load, P kN",50,null,"Radius of contact, a (mm)",{"$f":"IFERROR(IF(E$5=1,POWER(E$7*1000/(E$8*PI()),0.5),POWER(((0.8521*E$7*1000/(E$8*2*PI())+E8/PI())+((E6/PI())*(((E7*1000)/(0.5227*2*E8))^0.5))),0.5)),\"\")","v":180.56481741501179}]
["Modulus of the subgrade reaction, k Mpa/m",{"$f":"IFERROR(Database!F17,\"\")","v":""},null,"Tyre pressure, q MPa",0.8,null,"Ratio of L/l",{"$f":"IFERROR(IF(H5=2,(B13*1000/B17),(\"NO NEED TO CALC TEMP STRESS\" )),\"\")","v":"NO NEED TO CALC TEMP STRESS"}]
["Grade of Concrete","M30",null,"Design life of pavement, Years",20,null,"Correction factor C",{"$f":"IFERROR(IF(H5=2, (IF(H8<=4.25,((0.045*H8^2)-(0.072*H8)+0.028),(IF(H8<=7.5,((-0.043*H8^2)+(0.667*H8)-1.503),((-0.005*H8^2)+(0.1*H8)+0.637))))),(\"\")),\"\")","v":""}]
["Modulus of rupture of concrete, fcr",{"$f":"IFERROR(ROUND(1.1*0.7*_xlfn.NUMBERVALUE(SQRT(RIGHT(B9,2))),2),\"\")","v":4.22},null,"Rate of increase of traffic ",0.06]
["Select your Region",null,null,"% of trucks with 50kN Wheel load",10,null,{"$f":"IF(AND(B5<>\"\",B6<>\"\",B9<>\"\",B7<>\"\",B12<>\"\",B13<>\"\",B14<>\"\",E5<>\"\",E9<>\"\",E10<>\"\",E11<>\"\"),\"All Required Data Entered\",\"All Required Data NOT Entered\")","v":"All Required Data NOT Entered"}]
["Temperature Zone (1 to 6)",{"$f":"IFERROR(VLOOKUP(B11,Region_Zone,2,FALSE),\"\")","v":""},null,"Elastic modulus of concrete E, MPa",{"$f":"IF(B9=\"\",\"\",ROUND(IF(_xlfn.NUMBERVALUE(RIGHT(B9,2))>=30,30000,5000*SQRT(_xlfn.NUMBERVALUE(RIGHT(B9,2)))),0))","v":30000}]
["Transverse joint spacing,m",null,null,"Poisson Ratio of the concrete, µ",0.15]
["Trial thickness, h m",null,null,"Co-efficient of thermal expansion,α",9.9999999999999991E-6]
[]
["Case 1\n(Only Wheel Load Stresses Considered)",null,null,"Case 2\n(Wheel Load/Temperature Stresses Considered)",null,null,"Case 3\n(Wheel Load/Temperature/Fatigue Stresses Considered)"]
["Radius of relative stiffness, l m",{"$f":"IFERROR(POWER((E12*((B14*1000)^3)/(11.73*B8/1000)),0.25),\"\")","v":""},null,"Temparature stress at  edge, Mpa",{"$f":"IFERROR(IF(H5=2,(( 0.67*H9*E14*H6*E12*0.5) - (0.33*0.0767*H6)),(\"\")),\"\")","v":""},null,"Design No.of vehicles for fatigue analysis",{"$f":"IFERROR((B5*((1+E10)^E9-1)*365*E11/(100*0.06)),\"\")","v":0}]
["Stress developed, σ, Mpa",{"$f":"IFERROR(IF(H5=1,((0.803*E7*1000/((B14*1000)^2))*((4*LOG(B17/H7))+(0.666*H7/B17)-0.034)),(\"\")),\"\")","v":""},null,"Wheel load Stresses at edge, Mpa",{"$f":"IFERROR(IF(H5=2,((0.803*E7*1000/((B14*1000)^2))*((4*LOG(B17/H7))+(0.666*H7/B17)-0.034)),(\"\")),\"\")","v":""},null,"Stresses due to wheel load,σ, Mpa",{"$f":"IFERROR(IF(H5=3,((0.803*E7*1000/((B14*1000)^2))*((4*LOG(B17/H7))+(0.666*H7/B17)-0.034)),(\"\")),\"\")","v":""}]
["Design is",{"$f":"IFERROR(IF(H5=1,(IF(B18<B10,(\"Safe\"),(\"Unsafe\"))),(\"\")),\"\")","v":"Unsafe"},null,"Total stresses, σ, Mpa",{"$f":"IFERROR(IF(H5=2,(E17+E18),(\"\")),\"\")","v":""},null,"Ratio of L/l",{"$f":"IFERROR(IF(H5=3,(B13*1000/B17),(\"\" )),\"\")","v":""}]
[null,null,null,"Design is",{"$f":"IFERROR(IF(H5=2,(IF(E19<B10,(\"Safe\"),(\"Unsafe\"))),(\"\")),\"\")","v":""},null,"Correction factor C",{"$f":"IFERROR(IF(H5=3, (IF(H19<=4.25,((0.045*H19^2)-(0.072*H19)+0.028),(IF(H19<=7.5,((-0.043*H19^2)+(0.667*H19)-1.503),((-0.005*H19^2)+(0.1*H19)+0.637))))),(\"\")),\"\")","v":""}]
[{"$nulls":6},"Stresses due to temparature,σ, Mpa",{"$f":"IFERROR(IF(H5=3,( 0.67*H20*E14*H6*E12*0.5),(\"\")),\"\")","v":""}]
["Legend",{"$nulls":5},"Negative stress due to nonlinear temparature diffrential,σ, Mpa",{"$f":"IFERROR(IF(H5=3,(E12*E14*H6/(3*3.91)),(\"\")),\"\")","v":""}]
["Data Input Cells",{"$nulls":5},"Total stress for Fatigue calculation,σ, Mpa",{"$f":"IFERROR(IF(H5=3,(H18+H21-H22),(\"\")),\"\")","v":""}]
["Calaculated Values",{"$nulls":5},"Stress Ratio",{"$f":"IFERROR(IF(H5=3,(H23/B10),(\"\")),\"\")","v":""}]
["Design Output Cells",{"$nulls":5},"Allowable repetititons",{"$f":"IFERROR(IF(H5=3,(10^(1.912/H24^2.22208)),(\"\")),\"\")","v":""}]
["Cell with Tip on Mouse Over",{"$nulls":5},"Design is",{"$f":"IFERROR(IF(H5=3,((IF(H17<H25,(\"Safe\"),(\"Unsafe\")))),(\"\")),\"\")","v":""}]
[{"$nulls":6},"Cummulative fatigue damage ",{"$f":"IFERROR(IF(H5=3, (H17/H25),(\"\")),\"\")","v":""}]

{"sheet":"Database","index":1,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":true,"merged":[[3,1,4,1],[3,2,3,3]]}
["CBR",{"$f":"Sheet1!B6","v":0},{"$nulls":5},"Zone","Regions"]
["Sub-Base",{"$f":"Sheet1!B7","v":0},{"$nulls":5},1,"Punjab, Haryana, Uttar Pradesh, Uttaranchal, Manipur, Meghalaya, Mizoram, Nagaland, Sikkim, Arunachal Pradesh, Tripura, Himachala Pradesh, Rajasthan, Gujarat, and North Madhya Pradesh [Excluding Hilly & Coastal Regions]"]
[{"$nulls":7},2,"Bihar, Jharkhand, West Bengal, Assam, and Eastern Odisha [Excluding Hilly & Coastal Regions]"]
[null,"CBR","Subgrade Reaction",{"$nulls":4},3,"Maharashtra, Karnataka, South Madhya Pradesh, Andhra Pradesh, Telangana, Western Odisha, and North Tamil Nadu [Excluding Hilly & Coastal Regions]"]
[null,null,"Granular","Cementitious",null,null,null,4,"Kerala and South Tamil Nadu [Excluding Hilly & Coastal Regions]"]
[null,2,25,42,null,null,null,5,"Coastal Areas bounded by Hills"]
[null,3,34,56,null,null,null,6,"Coastal Areas un-bounded by Hills"]
[null,4,42,70]
[null,5,50,84,{"$nulls":4},"The UI & UX of Programmed Excel Sheet (Ready Reckoner) is enhanced "]
[null,7,58,96,null,null,null,1,"Intuitive Interface & Better User Experience"]
[null,10,60,100,null,null,null,2,"Legend is given for cells - for data inputs, calculated values, design outputs, and tips for data entry etc"]
[null,15,74,124,null,null,null,3,"Data Entry is permitted only Data Input Cells, and other cells are frozen to protect from accidental deletion/modification"]
[null,20,83,138,null,null,null,4,"Data Input Cells are organized in separate columns"]
[null,50,170,280,null,null,null,5,"Some Data Input Cells are Populated with default values (which are most likely values), but can be modified as per requirement"]
[{"$nulls":7},6,"Integrity Constraints are enforced for Data Input Cells in type of data (Whole Numbers/Decimals ..) and Permissible Range"]
[{"$nulls":7},7,"Tips are given (Red-Cornered Cells) regarding type and range of values that can be entered in Data Input Cells"]
[null,"Lower Bound",{"$f":"VLOOKUP(B1,OFFSET(Subgrade_Reaction,0,0,,1),1,TRUE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C17,Subgrade_Reaction,IF($B$2=\"Granular\",2,3),FALSE)","v":{"$error":"#N/A"}},null,{"$f":"D17+(B1-C17)*(D18-D17)/(C18-C17)","v":{"$error":"#N/A"}},null,8,"Now only CVPD has to be entered and Case (1/2/3) is automatically selected based on the range of CVPD"]
[null,"Upper Bound",{"$f":"INDEX(OFFSET(Subgrade_Reaction,0,0,,1),MATCH(C17,OFFSET(Subgrade_Reaction,0,0,,1),0)+1,1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C18,Subgrade_Reaction,IF($B$2=\"Granular\",2,3),FALSE)","v":{"$error":"#N/A"}},null,null,null,9,"Modulus of Subgrade Reaction (k) - Previously code has to be referred to read this value based on Soaked Subgrade CBR and type of sub-base/base proposed (Granular/Cementitious). Also for Intermediate values of CBR, interpolation calculations have to be carried out. Now this value is automatically populated based on values of soaked subgrade CBR and type of sub-base/base proposed"]
[{"$nulls":7},10,"Temperature Zone of the Region: On entry of value of Zone, corresponding regions are shown for clarity"]
[]
[]
[{"$nulls":7},"Region","Zone"]
[{"$nulls":7},"Andhra Pradesh",3]
[{"$nulls":7},"Arunachal Pradesh",1]
[{"$nulls":7},"Assam",2]
[{"$nulls":7},"Bihar",2]
[{"$nulls":7},"Gujarat",1]
[{"$nulls":7},"Haryana",1]
[{"$nulls":7},"Himachal Pradesh",1]
[{"$nulls":7},"Jharkhand",2]
[{"$nulls":7},"Karnataka",3]
[{"$nulls":7},"Kerala",4]
[{"$nulls":7},"Madhya Pradesh (North)",1]
[{"$nulls":7},"Madhya Pradesh (South)",3]
[{"$nulls":7},"Maharashtra",3]
[{"$nulls":7},"Manipur",1]
[{"$nulls":7},"Meghalaya",1]
[{"$nulls":7},"Mizoram",1]
[{"$nulls":7},"Nagaland",1]
[{"$nulls":7},"Odisha (Easteren)",2]
[{"$nulls":7},"Odisha (Western)",3]
[{"$nulls":7},"Punjab",1]
[{"$nulls":7},"Rajasthan",1]
[{"$nulls":7},"Sikkim",1]
[{"$nulls":7},"Tamilnadu (North)",3]
[{"$nulls":7},"Tamilnadu (South)",4]
[{"$nulls":7},"Telangana",3]
[{"$nulls":7},"Tripura",1]
[{"$nulls":7},"Uttar Pradesh",1]
[{"$nulls":7},"Uttaranchal",1]
[{"$nulls":7},"West Bengal",2]
[{"$nulls":7},"Coastal Areas Bounded by Hills",5]
[{"$nulls":7},"Coastal Areas Un-Bounded by Hills",6]