{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Input_Form","Input Data","Design Calculations","Design Abstract","Database"],"not_rendered":{"charts":0,"images":22,"macros":1,"external_links":0,"defined_names":78,"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":"Input_Form","index":0,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[6,0,6,4],[24,6,24,14],[16,0,16,4],[23,0,23,5],[24,0,24,3],[21,0,21,3],[7,0,7,3],[10,0,10,4],[11,0,11,5],[13,0,13,3],[12,0,12,4],[9,0,9,2],[9,3,9,5],[2,7,2,12],[32,1,32,4],[28,0,28,4],[19,0,19,3],[4,3,4,5],[29,1,29,4],[30,1,30,4],[31,1,31,4],[14,0,14,3],[15,0,15,3],[17,0,17,3],[18,0,18,3],[8,0,8,3],[25,0,25,3],[26,0,26,3],[20,0,20,3],[0,0,0,5],[1,0,1,5],[3,0,3,5],[2,0,2,5],[5,0,5,3]]}
[]
["Input Parameters for Design of Rigid pavement\n[As per IRC:SP:62-2014 for Rural Low Volume Roads]"]
["Name of the Work",{"$nulls":5},{"$f":"AND(G4:G10,G13:G20)","v":false},{"$f":"IF(valid_input,\"Overall Data Entry Completed & Valid\",\"Overall Data Entry Not Completed and/or Invalid\")","v":"Overall Data Entry Not Completed and/or Invalid"}]
[{"$nulls":6},{"$f":"Work<>\"\"","v":false}]
["Program",null,"Work_ID",null,null,null,{"$f":"AND(Program<>\"\",Work_ID<>\"\")","v":false}]
["Present CVPD (as per traffic census)",null,null,null,"P1",null,{"$f":"F6<>\"\"","v":false}]
["Design Case for the Present CVPD (as per traffic census)",{"$nulls":4},{"$f":"IF(F6=\"\",\"\",IF(F6<=50,\"Case 1\",IF(F6<=150,\"Case 2\",\"Case 3\")))","v":""},{"$f":"F7<>\"\"","v":false},{"$f":"IF(F7=\"\",\"\",IF(F7=\"Case 1\", \"Only Edge Wheel Stresses are applicable\",IF(F7=\"Case 2\",\"Edge Stresses and Temparature Stresses are applicable\",\"Edge Stresses,  Temparature Stresses, and fatigue stresses are applicable\")))","v":""}]
["Soaked Sub-Grade CBR (%)",null,null,null,"CBRSSG",null,{"$f":"F8<>\"\"","v":false}]
["Grade of Concrete",null,null,null,"M",30,{"$f":"Concrete_Grade<>\"\"","v":true},{"$f":"IF(AND(Concrete_Grade<>\"\",Concrete_Grade<30),\"As Per IRC-SP-62, The Minimum Grade of Concrete for Design of CC Pavement is M30\",\"\")","v":""}]
["Select Region (Location of the Work)",{"$nulls":5},{"$f":"Region<>\"\"","v":false}]
["Temperature Zone of the selected Region",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(Region,Region_Zone,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(Zone_Selected,Zone,2,FALSE),\"\")","v":""}]
["Default Parametes (You may change them if required)"]
["Sub Base/Base",{"$nulls":4},"Granular",{"$f":"Sub_Base<>\"\"","v":true}]
["Construction period (Number of years)\n[Range 0.25 - 2.00, default value 1 year]",null,null,null,"x",1,{"$f":"con_period<>\"\"","v":true}]
["Design Period (Permissible Range: 20 to 30, default is 20)",null,null,null,"n",20,{"$f":"design_period<>\"\"","v":true}]
["Rate of traffic increase in percentage\n[Maximum 5%,Default value is 5%]",null,null,null,"r",0.05,{"$f":"traffic_rate<>\"\"","v":true}]
["Wheel Loading Type (Single/Dual) [Default value dual wheel loading]",{"$nulls":4},"Dual",{"$f":"F17<>\"\"","v":true}]
["Wheel Load (in N) [Assuming Rear -Axel Load of 100,000 N]",null,null,null,"P",50000,{"$f":"F18<>\"\"","v":true}]
["% of total traffic having axel loads equal to 100 KN\n[Range 5% to 20%, default value 10%]",null,null,null,"P100",0.1,{"$f":"F19<>\"\"","v":true}]
["Joint Spacing (mm) [Range 2500 - 4000, default value 3000]",null,null,null,"L",3000,{"$f":"F20<>\"\"","v":true}]
["Spacing Between two wheels (mm) (Assumed)",null,null,null,"Sd",310]
["Tyre Pressure Mpa (Assumed)",null,null,null,"p",0.8]
[]
["Properties of Concrete"]
["Modulus of Elasticity",null,null,null,"E",{"$f":"IF(Concrete_Grade=\"\",\"\",IF(Concrete_Grade>=30,30000,ROUND(5000*SQRT(Concrete_Grade),0)))","v":30000},{"$f":"IF(Concrete_Grade=\"\",\"\",IF(Concrete_Grade>=30,\"Assumed Parameter for Concrete Grades >= 30 as per IRC:SP-62\",\"For grades <= 30, formula adopted as per clause 6.2.3.1 of IS:456 : 5000 x sqrt(fck)\"))","v":"Assumed Parameter for Concrete Grades >= 30 as per IRC:SP-62"}]
["Poisson ratio for concrete (Assumed)",null,null,null,"µ ",0.15]
["Coefficient of thermal expansion of concrete (Assumed)",null,null,null,"α","10x10-6",1.0000000000000001E-5]
[]
["Legend"]
[null,"Input Cell for Data Entry"]
[null,"Data Entry in the Adjoining Cell blank/invalid"]
[null,"Data Entry in the Adjoining Cell Completed and Valid"]
[null,"Additional/Help Information on Mouse Over"]

{"sheet":"Input Data","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":true,"merged":[[22,0,24,0],[0,0,0,2],[28,0,28,2]]}
["Input Parameters and Design Data"]
["Parameter","Description","Value"]
["P1","Present CVPD (as per traffic census)",{"$f":"traffic_census","v":0}]
["x","Construction period (Number of years)",{"$f":"con_period","v":1}]
["r","Annual Rate of traffic increase (%)",{"$f":"traffic_rate","v":0.05}]
["A","Initial CVPD =",{"$f":"ROUND(traffic_census*(1+traffic_rate)^con_period,0)","v":0}]
["n","Design period (Typically 20 years)",{"$f":"design_period","v":20}]
["D","Design CVPD = A(1+r)n",{"$f":"ROUND(traffic_initial*(1+traffic_rate)^design_period,0)","v":0}]
["N","Total number of commercial vehicles \nat the end  of the design period =",{"$f":"IFERROR(ROUND(traffic_initial*365*((1+traffic_rate)^design_period-1)/traffic_rate,0),\"\")","v":0}]
["CBRSSG","Soaked Sub-Grade CBR (%)",{"$f":"CBR_SSG","v":0},{"$f":"MATCH(CBR_SSG,OFFSET(subgrade_k,0,0,,1),1)","v":{"$error":"#N/A"}},{"$f":"INDEX(subgrade_k,D10,1)","v":{"$error":"#N/A"}},{"$f":"INDEX(subgrade_k,D10,IF(Sub_Base=\"Granular\",3,4))","v":{"$error":"#N/A"}}]
["κ",{"$f":"\"Modulus of sub-grade reaction for \" & Sub_Base & \" Sub-Base/Base and soaked CBR of \" & TEXT(CBR_SSG,\"0.00%\") & \" of the pavement foundation (MPa/mm)\n[as per Table 3.1 of IRC SP-62 (2014)]\"","v":"Modulus of sub-grade reaction for Granular Sub-Base/Base and soaked CBR of 0.00% of the pavement foundation (MPa/mm)\n[as per Table 3.1 of IRC SP-62 (2014)]"},{"$f":"IFERROR(CEILING((F10+(F11-F10)*(CBR_SSG-E10)/(E11-E10))/1000,0.001),\"\")","v":""},{"$f":"D10+1","v":{"$error":"#N/A"}},{"$f":"INDEX(subgrade_k,D11,1)","v":{"$error":"#N/A"}},{"$f":"INDEX(subgrade_k,D11,IF(Sub_Base=\"Granular\",3,4))","v":{"$error":"#N/A"}}]
["fck","Characteristic compressive cube strength of concrete (Mpa)",{"$f":"Concrete_Grade","v":30}]
["ff","Flexural Strength of concrete (Mpa) =",{"$f":"CEILING(0.7*SQRT(fck),0.001)","v":3.835}]
["ff-90","90 days Flexural Strength of concrete (Mpa) = 1.10 x ff",{"$f":"CEILING(1.1*ff,0.001)","v":4.2190000000000003}]
["Econcrete","Mudulus of Elasticity (E) of Concrete (Mpa)",{"$f":"E_Concrete","v":30000}]
["µConcrete","Poisson's Ratio ( µ ) of Concrete",{"$f":"poisson_concrete","v":0.15}]
["αConcrete","Coefficient of thermal expansion ( α )of concrete /oC (=10 x 10-6)",{"$f":"alpha_concrete","v":1.0000000000000001E-5}]
["wl_type","Wheel Loading Type",{"$f":"wl_type","v":"Dual"}]
["P","Design Wheel Load",{"$f":"Design_Wheel_Load","v":50000}]
["Pd","Load on single wheel considered (Single wheel/double wheel) (in N)",{"$f":"IF(wl_type=\"Dual\",Design_Wheel_Load/2,Design_Wheel_Load)","v":25000}]
["Sd","Spacing between the centers of dual wheel (mm)",{"$f":"dw_spacing","v":310}]
["p","Tyre pressure (Mpa)",{"$f":"tyre_pressure","v":0.8}]
["a","Radius of equivalent circular area (mm) (for single wheel at edge)= ",{"$f":"IF(wl_type<>\"Dual\",SQRT(load_w/PI()*tyre_pressure),\"\")","v":""}]
[null,"Radius of equivalent circular area (mm) (for dual wheel at edge)= ",{"$f":"IF(wl_type=\"Dual\",CEILING(SQRT((0.8521*load_w/(PI()*tyre_pressure))+(dw_spacing/PI())*SQRT(load_w/(0.5227*tyre_pressure))),0.001),\"\")","v":180.565}]
[null,"Radius of equivalent circular area (mm) (considered)= ",{"$f":"IF(wl_type<>\"Dual\",radius_eq_cir_area_sw,radius_eq_cir_area_dw)","v":180.565}]
["L","Joint Spacing (mm)",{"$f":"joint_spacing","v":3000}]
["P100","% of total traffic having axel loads equal to 100 KN",{"$f":"P_100","v":0.1}]
["Ne","Expected load repetitions =P100 x N",{"$f":"IFERROR(ROUND(total_cv*P_100,0),\"\")","v":0}]
["Temparature differentials based on zone and slab thickness as per Table 4.1 of IRC SP-62 (2014)"]
["T150","Temparature differential for selected zone for slab thickness of 150 mm",{"$f":"IFERROR(INDEX(Zone, Zone_Selected,3),\"\")","v":""}]
["T200","Temparature differential for selected zone for slab thickness of 200 mm",{"$f":"IFERROR(INDEX(Zone, Zone_Selected,4),\"\")","v":""}]
["T250","Temparature differential for selected zone for slab thickness of 250 mm",{"$f":"IFERROR(INDEX(Zone, Zone_Selected,5),\"\")","v":""}]

{"sheet":"Design Calculations","index":2,"n_rows":153,"n_cols":6,"rows_kept":153,"cut":false,"hidden":true,"merged":[[150,0,150,2],[134,0,134,2],[140,0,140,2],[142,0,142,2],[137,0,137,2],[138,0,138,2],[145,0,145,2],[122,0,122,2],[131,0,131,2],[135,0,135,2],[136,0,136,2],[125,0,125,2],[126,0,126,2],[128,0,128,2],[129,0,129,1],[130,0,130,2],[124,0,124,2],[133,0,133,2],[123,0,123,2],[2,0,2,2],[23,0,23,2],[44,0,44,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[3,0,3,2],[9,0,9,1],[121,0,121,1],[102,0,102,2],[103,0,103,2],[104,0,104,2],[105,0,105,2],[106,0,106,2],[115,0,115,2],[116,0,116,2],[117,0,117,2],[118,0,118,2],[120,0,120,2],[0,0,0,2],[152,0,152,2],[46,0,46,2],[83,0,83,2],[96,0,96,2],[64,0,64,2],[51,0,51,2],[52,0,52,2],[53,0,53,2],[54,0,54,2],[55,0,55,2],[56,0,56,2],[114,0,114,2],[101,0,101,2],[65,0,65,2],[66,0,66,2],[67,0,67,2],[68,0,68,2],[75,0,75,2],[76,0,76,2],[70,0,70,2],[71,0,71,1],[73,0,73,2],[72,0,72,2],[85,0,85,2],[74,0,74,2],[78,0,78,2],[79,0,79,1],[80,0,80,2],[81,0,81,2],[82,0,82,1],[84,0,84,2],[94,0,94,2],[86,0,87,2],[88,0,88,2],[89,0,89,2],[91,0,91,2],[93,0,93,2]]}
["Rigid (CC) Pavement Design Calculations"]
[]
[{"$f":"Work","v":0}]
["Design Data",{"$nulls":4},"Check"]
["Traffic CVPD as per census","P1",{"$f":"traffic_census","v":0},null,null,true]
["Soaked Sub-Grade CBR (%)","CBRSSG",{"$f":"CBR_SSG","v":0},null,null,true]
["Construction period (Number of years)","x",{"$f":"con_period","v":1},null,null,true]
["Design period (Number of Years)","n",{"$f":"design_period","v":20},null,null,true]
["Rate of traffic increase in percentage","r",{"$f":"traffic_rate","v":0.05},null,null,true]
["Wheel Loading Type ",null,{"$f":"wl_type","v":"Dual"},null,null,true]
["Design Wheel Load (Total Load on Signle/Dual Wheel)","P",{"$f":"Design_Wheel_Load","v":50000},null,null,true]
["Wheel Load on single Tyre (in N)","Pd",{"$f":"load_w","v":25000},null,null,true]
["Spacing between the centers of dual wheel (mm)","Sd",{"$f":"dw_spacing","v":310},null,null,{"$f":"$C$10=\"Dual\"","v":true}]
["Joint Spacing (mm)","L",{"$f":"joint_spacing","v":3000},null,null,true]
[{"$f":"\"Characteristic compressive cube strength of concrete (Mpa) for M\" & Concrete_Grade & \" Grade of Concrete\"","v":"Characteristic compressive cube strength of concrete (Mpa) for M30 Grade of Concrete"},"fck",{"$f":"fck","v":30},null,null,true]
["Flexural Strength of concrete (Mpa) =","ff",{"$f":"ff","v":3.835},null,null,true]
["90 days Flexural Strength of concrete (Mpa) = 1.10 x ff","ff-90",{"$f":"ff_90","v":4.2190000000000003},null,null,true]
["Mudulus of Elasticity (E) of Concrete (Mpa)","Econcrete",{"$f":"E_Concrete","v":30000},null,null,true]
["Poisson's Ratio ( µ ) of Concrete","µConcrete",{"$f":"poisson_concrete","v":0.15},null,null,true]
["Coefficient of thermal expansion ( α )of concrete /oC (=10 x 10-6)","αConcrete",{"$f":"alpha_concrete","v":1.0000000000000001E-5},null,null,true]
["Tyre pressure (Mpa)","p",{"$f":"tyre_pressure","v":0.8},null,null,true]
["% of total traffic having axel loads equal to 100 KN","P100",{"$f":"P_100","v":0.1},null,null,{"$f":"(traffic_initial>150)","v":false}]
[{"$nulls":5},true]
["Based on the above the following parameters are calculated:",{"$nulls":4},true]
[{"$nulls":5},true]
["Initial CVPD =","A",null,null,null,true]
[{"$f":"\"= \"&C5&\" ( 1 + \" & C9 & \" ) ^ \" &C7 & \" = \" & C5 & \" ( \" & (1+C9)^C7 & \" ) = \" & C5*(1+C9)^C7","v":"= 0 ( 1 + 0.05 ) ^ 1 = 0 ( 1.05 ) = 0"},"≈",{"$f":"traffic_initial","v":0},null,null,true]
["Design CVPD = A(1+r)n","D",null,null,null,true]
[{"$f":"\" = \" & C27 & \" ( 1 + \" & C9 & \" ) ^ \" & C8 & \" = \" & C27 & \" ( \" & CEILING((1+C9)^C8,0.001) & \" )\" & \" = \" & C27*CEILING((1+C9)^C8,0.001)","v":" = 0 ( 1 + 0.05 ) ^ 20 = 0 ( 2.654 ) = 0"},"≈",{"$f":"traffic_design","v":0},null,null,true]
["Total number of commercial vehicles \nat the end  of the design period =","N",null,null,null,{"$f":"(traffic_initial>150)","v":false}]
[{"$f":" \" = \" & C27 & \"[( (1 + \" &C9 & \" ) ^ \" & C8 & \" - 1 )/ \" & C9 & \"] 365\" & \" = \" & C27 & \"[ ( \" & ROUND((1+C9)^C8,4) & \" - 1 )/ \" & C9 & \" ] 365\" & \" = \" & C27 & \"[ \" & (ROUND((1+C9)^C8,4)- 1)/C9 & \"] 365\"","v":" = 0[( (1 + 0.05 ) ^ 20 - 1 )/ 0.05] 365 = 0[ ( 2.6533 - 1 )/ 0.05 ] 365 = 0[ 33.066] 365"},"≈",{"$f":"total_cv","v":0},null,null,{"$f":"(traffic_initial>150)","v":false}]
[{"$f":"\"Modulus of sub grade reaction for \" & Sub_Base & \" Sub-Base/Base and  given value of soaked CBR of  \"&TEXT(CBR_SSG,\"0.00%\")&\" from table 3.2 of IRC-SP-62 (MPa/mm)\"","v":"Modulus of sub grade reaction for Granular Sub-Base/Base and  given value of soaked CBR of  0.00% from table 3.2 of IRC-SP-62 (MPa/mm)"},"κ",{"$f":"mod_subgrade","v":""},null,null,true]
["Radius of equivalent circular area (mm) (for single wheel at edge)= ","a",null,null,null,{"$f":"$C$10<>\"Dual\"","v":false}]
[{"$f":" \" = [ \" & C12 &\" / ( \" &ROUND( PI(),4) & \" x \" & C21 & \")] ^ 0.50\" & \" = [ \" & ROUND(C12/(ROUND(PI(),4) * C21),4) & \"] ^ 0.5\"","v":" = [ 25000 / ( 3.1416 x 0.8)] ^ 0.50 = [ 9947.1607] ^ 0.5"},"≈",{"$f":"radius_eq_cir_area","v":180.565},null,null,{"$f":"F33","v":false}]
["Radius of equivalent circular area (mm) (for dual wheel at edge)= ","a",null,null,null,{"$f":"$C$10=\"Dual\"","v":true}]
[{"$f":"\" = [ { 0.8521 x \" & C12 & \" / ( \" & ROUND(PI(),4) & \" x \" & C21 & \" ) } + ( \" & C13 & \" / \" & ROUND(PI(),4) & \") x { \" & C12 & \" / ( 0.5227 x \" & C21 &\") } ^ 0.50] ^ 0.50\"","v":" = [ { 0.8521 x 25000 / ( 3.1416 x 0.8 ) } + ( 310 / 3.1416) x { 25000 / ( 0.5227 x 0.8) } ^ 0.50] ^ 0.50"},{"$nulls":4},{"$f":"F35","v":true}]
[{"$f":"\" = [ {\" &  0.8521 * C12 & \" / ( \" & ROUND(PI(),4) * C21 & \" ) } + ( \" & ROUND(C13/ROUND(PI(),4),4) & \") x { \" &ROUND( C12  / ( 0.5227 *C21),4) &\" } ^ 0.50] ^ 0.50\"","v":" = [ {21302.5 / ( 2.51328 ) } + ( 98.6758) x { 59785.728 } ^ 0.50] ^ 0.50"},{"$nulls":4},{"$f":"F36","v":true}]
[{"$f":"\" = [ {\" & ROUND(0.8521 * C12/(ROUND(PI(),4) * C21),4) &\" } + ( \" & ROUND(C13/ROUND(PI(),4),4) & \") x { \" &ROUND( (ROUND( C12  / ( 0.5227 *C21),4) ) ^ 0.5,4) & \"}] ^ 0.50\"","v":" = [ {8475.9756 } + ( 98.6758) x { 244.5112}] ^ 0.50"},{"$nulls":4},true]
[{"$f":"\" = [ {\" & ROUND(0.8521 * C12/(ROUND(PI(),4) * C21),4) &\" } + { \" & ROUND(ROUND(C13/ROUND(PI(),4),4)  * ROUND( (ROUND( C12  / ( 0.5227 *C21),4) ) ^ 0.5,4),4) & \"}] ^ 0.50\"","v":" = [ {8475.9756 } + { 24127.3383}] ^ 0.50"},{"$nulls":4},true]
[{"$f":"\" = [ \" & ROUND(0.8521 * C12/(ROUND(PI(),4) * C21),4)  +   ROUND(ROUND(C13/ROUND(PI(),4),4)  * ROUND( (ROUND( C12  / ( 0.5227 *C21),4) ) ^ 0.5,4),4) &\" ] ^ 0.50\"","v":" = [ 32603.3139 ] ^ 0.50"},{"$nulls":4},true]
[{"$f":"ROUND((ROUND(0.8521*C12/(ROUND(PI(),4)*C21),4)+ROUND(ROUND(C13/ROUND(PI(),4),4)*ROUND((ROUND(C12/(0.5227*C21),4))^0.5,4),4))^0.5,4)","v":180.56389999999999},"≈",{"$f":"radius_eq_cir_area","v":180.565},null,null,true]
["Expected load repetitions of traffic having axel loads equal to 100 KN = P100 x N","Ne",{"$f":"Ne","v":0},null,null,{"$f":"(traffic_initial>150)","v":false}]
[{"$nulls":5},true]
[{"$nulls":5},true]
["Design of Concrete Pavement Thickness",{"$nulls":4},true]
[{"$nulls":5},true]
[{"$f":"\"For the initial traffic  CVPD of \" & traffic_initial &\" \" & VLOOKUP(IF(traffic_initial<=50,50,IF(traffic_initial<=150,150,450)),design_stresses,2,FALSE)","v":"For the initial traffic  CVPD of 0 Concrete pavement thickness may be designed considering pavement edge stresses only"},{"$nulls":4},true]
[{"$nulls":5},true]
["Trail 1",{"$nulls":4},true]
[{"$nulls":5},true]
["Assume thickness of concrete pavement","h",100,{"$f":"IF(cc_thick1<=150,1,IF(cc_thick1<=200,2,3))","v":1},null,true]
["Radius of relative stiffness = ",{"$nulls":4},true]
[{"$f":"\"=[ (\" & E_Concrete & \"x\" & cc_thick1 & \"^3)/(12 (1-\" & poisson_concrete &\"^2)\" &mod_subgrade& \" ]^0.25\"","v":"=[ (30000x100^3)/(12 (1-0.15^2) ]^0.25"},{"$nulls":4},true]
[{"$f":"\"=[ (\" & E_Concrete & \"x\" & cc_thick1^3 & \")/(12 (1-\" & poisson_concrete^2 &\")\" &mod_subgrade& \" ]^0.25\"","v":"=[ (30000x1000000)/(12 (1-0.0225) ]^0.25"},{"$nulls":4},true]
[{"$f":"\"=[ (\" & E_Concrete * cc_thick1^3 & \")/(12 (\" &1- poisson_concrete^2 &\")\" &mod_subgrade& \" ]^0.25\"","v":"=[ (30000000000)/(12 (0.9775) ]^0.25"},{"$nulls":4},true]
[{"$f":"\"=[ \" & E_Concrete * cc_thick1^3 & \"/\"&12 *( 1- poisson_concrete^2) *mod_subgrade& \" ]^0.25\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"\"=[ \" & (E_Concrete * cc_thick1^3) /(12 *( 1- poisson_concrete^2) *mod_subgrade)& \" ]^0.25\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"( (E_Concrete * cc_thick1^3) /(12 *( 1- poisson_concrete^2) *mod_subgrade))^0.25","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND(A58,4)","v":{"$error":"#VALUE!"}},null,null,true]
["Temparature differential between two faces of concrete slab, based on slab thickness and zone read from table 4.1","t",{"$f":"IF(cc_thick1<=200,T_150+(T_200-T_150)*(cc_thick1-150)/50,T_200 + (T_250-T_200)*(cc_thick1-200)/50)","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(traffic_census>=50,TRUE,FALSE)","v":false}]
["The ratio of Joint spacing to radius of relative stiffness","L/l",{"$f":"ROUND(joint_spacing/radius_rel_stiff1,4)","v":{"$error":"#VALUE!"}},null,null,{"$f":"F59","v":false}]
["Bradbury's coefficient, based on the ratio of joint spacing to radius of relative stiffness as per equation","C",{"$f":"ROUND(IF(C60<=4.25,0.045*C60^2-0.072*C60+0.028,0)+IF(AND(C60>4.25,C60<=7.5),-0.043*C60^2+0.667*C60-1.503,0)+IF(C60>7.5,-0.005*C60^2+0.1*C60+0.637,0),4)","v":{"$error":"#VALUE!"}},null,null,{"$f":"F60","v":false}]
[{"$nulls":5},true]
["Calculation of stresses",{"$nulls":4},true]
["(A) Stress Due to Edge-Wheel",{"$nulls":4},true]
["Load stress (Mpa)in edge region as per Westerguard eqn =",{"$nulls":4},true]
[{"$f":"\"=(0.803 x \" & Design_Wheel_Load &\" / \" & cc_thick1 &\" ^ 2) [ 4 Log { \" &radius_rel_stiff1 &\" / \"& radius_eq_cir_area &\" } + 0.666 { \" & radius_eq_cir_area & \"/ \" & radius_rel_stiff1 &\"} - 0.034]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"\"=(\" & 0.803 * Design_Wheel_Load &\" / \" & cc_thick1^2& \" ) [ 4 Log { \" &radius_rel_stiff1 / radius_eq_cir_area &\" } + 0.666 { \" & radius_eq_cir_area / radius_rel_stiff1 &\"} - 0.034]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"\"=(\" & 0.803 * Design_Wheel_Load / cc_thick1^2 & \" ) [ \"& 4*LOG(radius_rel_stiff1 / radius_eq_cir_area,10) &\" + \"& 0.666*( radius_eq_cir_area / radius_rel_stiff1 )&\" - 0.034]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"\"=(\" & 0.803 * Design_Wheel_Load / cc_thick1^2 & \" ) [ \"& (4*LOG(radius_rel_stiff1 / radius_eq_cir_area,10)  +  0.666*( radius_eq_cir_area / radius_rel_stiff1 ) - 0.034) &\" ]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"\"=\" & (0.803 * Design_Wheel_Load / cc_thick1^2 )* ( 4*LOG(radius_rel_stiff1 / radius_eq_cir_area,10)  +  0.666*( radius_eq_cir_area / radius_rel_stiff1 ) - 0.034)","v":{"$error":"#VALUE!"}},"σe",{"$f":"ROUND( (0.803 * Design_Wheel_Load / cc_thick1^2 )* ( 4*LOG(radius_rel_stiff1 / radius_eq_cir_area,10)  +  0.666*( radius_eq_cir_area / radius_rel_stiff1 ) - 0.034),4)","v":{"$error":"#VALUE!"}},null,null,true]
["Stress Ratio  SR = EdgeLoad Stress / 90-days flexural strength of concrete",{"$nulls":4},true]
[{"$f":"\"=\" & (stress_edge1)/ ff_90","v":{"$error":"#VALUE!"}},null,{"$f":"TRUNC(stress_edge1/ ff_90,2)","v":{"$error":"#VALUE!"}},{"$f":"SR_1<=1","v":{"$error":"#VALUE!"}},null,true]
[{"$f":"IF(SR_1<=1,\"Since Stress Ratio is less than/equal to 1, Safe\",\"Since Stress Ratio is more than 1, Unsafe\")","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
["(B) Stresses Due to Temperature Differentials ",{"$nulls":4},{"$f":"IF(traffic_census>50,TRUE,FALSE)","v":false}]
["Temparature stresses in the edge region (Mpa)  as per Bradbury eqn and negative stresses due to non-linear distribution= ",{"$nulls":4},{"$f":"F74","v":false}]
[{"$f":"\"=\"& E_Concrete & \" x \" & alpha_concrete & \" x \" & temp_diff1 &\" [ 0.335 x \" & bradbury_coeff1 & \" - 0.08525]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"F75","v":false}]
[{"$f":"\"=\"& E_Concrete*alpha_concrete* temp_diff1 & \" [\"  & 0.335* bradbury_coeff1 & \" - 0.08525]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"F76","v":false}]
[{"$f":"\"=\"& E_Concrete*alpha_concrete* temp_diff1*( 0.335* bradbury_coeff1 - 0.08525)","v":{"$error":"#VALUE!"}},"σte",{"$f":"ROUND(E_Concrete*alpha_concrete* temp_diff1*( 0.335* bradbury_coeff1 - 0.08525),4)","v":{"$error":"#VALUE!"}},null,null,false]
["Total Stresses  = σe + σte =",{"$nulls":4},false]
[{"$f":"\"=\" & stress_edge1 & \" + \" & stress_temp1","v":{"$error":"#VALUE!"}},null,{"$f":"stress_edge1+stress_temp1","v":{"$error":"#VALUE!"}},null,null,false]
["Stress Ratio  SR = Total stresses / 90-days flexural strength of concrete",{"$nulls":4},false]
[{"$f":"\"=\" & stress_total1 & \" / \" & ff_90","v":{"$error":"#VALUE!"}},{"$nulls":4},false]
[{"$f":"\"=\" & (stress_total1)/ ff_90","v":{"$error":"#VALUE!"}},null,{"$f":"TRUNC(stress_total1/ ff_90,2)","v":{"$error":"#VALUE!"}},{"$f":"IF(traffic_initial>50,IF(stress_ratio1<=1,TRUE,FALSE),TRUE)","v":true},null,false]
[{"$f":"IF(stress_ratio1<=1,\"Since the stress ratio is less than/equal to 1, Safe\",\"Since stress ratio is more than one, Unsafe\")","v":{"$error":"#VALUE!"}},{"$nulls":4},false]
["(C) Stresses Due to Fatigue",{"$nulls":4},{"$f":"IF(traffic_census>150,TRUE,FALSE)","v":false}]
["Fatigue life of concrete pavement\n(Allowable load repetitions) =",{"$nulls":4},{"$f":"F85","v":false}]
[{"$nulls":5},{"$f":"F86","v":false}]
[{"$nulls":5},{"$f":"F87","v":false}]
[{"$f":"\"= 10 ^ ( \" & stress_total1/ff_90 & \"^ -2.22208/0.523)\"","v":{"$error":"#VALUE!"}},{"$nulls":4},false]
[{"$f":"\"= 10 ^ ( \" & (stress_total1/ff_90) ^ -2.22208/0.523&\")\"","v":{"$error":"#VALUE!"}},{"$nulls":4},false]
[{"$f":"\"Nf = \"& 10 ^ ( (stress_total1/ff_90) ^ -2.22208/0.523)","v":{"$error":"#VALUE!"}},"≅",{"$f":"ROUND(10 ^ ( (stress_total1/ff_90) ^ -2.22208/0.523),0)","v":{"$error":"#VALUE!"}},null,null,false]
["Expected load repetitions =P100 x N",{"$nulls":4},false]
[{"$f":"\"=\" & P_100 & \" x \" & total_cv","v":"=0.1 x 0"},"Ne",{"$f":"Ne","v":0},null,null,false]
["Cumulative fatigue damage = Ne/Nf",{"$nulls":4},false]
[{"$f":"\"= \" & Ne & \" / \" & Nf_1","v":{"$error":"#VALUE!"}},{"$nulls":4},false]
[{"$f":"\"= \" & Ne/ Nf_1","v":{"$error":"#VALUE!"}},"cfd",{"$f":"TRUNC(Ne/ Nf_1,2)","v":{"$error":"#VALUE!"}},{"$f":"IF(traffic_initial>150,IF(cfd_1<=1,TrueFalse),TRUE)","v":true},null,false]
[{"$f":"IF(cfd_1<=1,\"Since the fatigue stress ratio is less than/equal 1, Safe\",\"Since fatigue stress ratio is more than one, Unsafe\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"AND(D72,D83,D96)","v":{"$error":"#VALUE!"}},null,false]
[{"$nulls":5},true]
["Trail 2",{"$nulls":4},true]
[{"$nulls":5},true]
["Assume thickness of concrete pavement","h",{"$f":"cc_thick1+10","v":110},{"$f":"IF(cc_thick2<=150,1,IF(cc_thick1<=200,2,3))","v":1},null,true]
["Radius of relative stiffness = ",{"$nulls":4},true]
[{"$f":"\"=[ (\" & E_Concrete & \"x\" & cc_thick2 & \"^3)/(12 (1-\" & poisson_concrete &\"^2)\" &mod_subgrade& \" ]^0.25\"","v":"=[ (30000x110^3)/(12 (1-0.15^2) ]^0.25"},{"$nulls":4},true]
[{"$f":"\"=[ (\" & E_Concrete & \"x\" & cc_thick2^3 & \")/(12 (1-\" & poisson_concrete^2 &\")\" &mod_subgrade& \" ]^0.25\"","v":"=[ (30000x1331000)/(12 (1-0.0225) ]^0.25"},{"$nulls":4},true]
[{"$f":"\"=[ (\" & E_Concrete * cc_thick2^3 & \")/(12 (\" &1- poisson_concrete^2 &\")\" &mod_subgrade& \" ]^0.25\"","v":"=[ (39930000000)/(12 (0.9775) ]^0.25"},{"$nulls":4},true]
[{"$f":"\"=[ \" & E_Concrete * cc_thick2^3 & \"/\"&12 *( 1- poisson_concrete^2) *mod_subgrade& \" ]^0.25\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"\"=[ \" & (E_Concrete * cc_thick2^3) /(12 *( 1- poisson_concrete^2) *mod_subgrade)& \" ]^0.25\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"( (E_Concrete * cc_thick2^3) /(12 *( 1- poisson_concrete^2) *mod_subgrade))^0.25","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND(A108,4)","v":{"$error":"#VALUE!"}},null,null,true]
["Temparature differential between two faces of concrete slab, based on slab thickness and zone read from table 4.1","t",{"$f":"IF(cc_thick2<=200,T_150+(T_200-T_150)*(cc_thick2-150)/50,T_200 + (T_250-T_200)*(cc_thick2-200)/50)","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(traffic_initial>=50,TRUE,FALSE)","v":false}]
["The ratio of Joint spacing to radius of relative stiffness","L/l",{"$f":"ROUND(joint_spacing/radius_rel_stiff2,4)","v":{"$error":"#VALUE!"}},null,null,{"$f":"F109","v":false}]
["Bradbury's coefficient, based on the ratio of joint spacing to radius of relative stiffness as per equation","C",{"$f":"ROUND(IF(C110<=4.25,0.045*C110^2-0.072*C110+0.028,0)+IF(AND(C110>4.25,C110<=7.5),-0.043*C110^2+0.667*C110-1.503,0)+IF(C110>7.5,-0.005*C110^2+0.1*C110+0.637,0),4)","v":{"$error":"#VALUE!"}},null,null,{"$f":"F110","v":false}]
[{"$nulls":5},true]
["Calculation of stresses",{"$nulls":4},true]
["(A) Stress Due to Edge-Wheel",{"$nulls":4},true]
["Load stress (Mpa)in edge region =",{"$nulls":4},true]
[{"$f":"\"=(0.803 x \" & Design_Wheel_Load &\" / \" & cc_thick2 &\" ^ 2) [ 4 Log { \" &radius_rel_stiff2 &\" / \"& radius_eq_cir_area &\" } + 0.666 { \" & radius_eq_cir_area & \"/ \" & radius_rel_stiff2 &\"} - 0.034]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"\"=(\" & 0.803 * Design_Wheel_Load &\" / \" & cc_thick2^2& \" ) [ 4 Log { \" &radius_rel_stiff2 / radius_eq_cir_area &\" } + 0.666 { \" & radius_eq_cir_area / radius_rel_stiff2 &\"} - 0.034]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"\"=(\" & 0.803 * Design_Wheel_Load / cc_thick2^2 & \" ) [ \"& 4*LOG(radius_rel_stiff2 / radius_eq_cir_area,10) &\" + \"& 0.666*( radius_eq_cir_area / radius_rel_stiff2 )&\" - 0.034]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"\"=(\" & 0.803 * Design_Wheel_Load / cc_thick2^2 & \" ) [ \"& (4*LOG(radius_rel_stiff2 / radius_eq_cir_area,10)  +  0.666*( radius_eq_cir_area / radius_rel_stiff2 ) - 0.034) &\" ]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
[{"$f":"\"=\" & (0.803 * Design_Wheel_Load / cc_thick2^2 )* ( 4*LOG(radius_rel_stiff2 / radius_eq_cir_area,10)  +  0.666*( radius_eq_cir_area / radius_rel_stiff2 ) - 0.034)","v":{"$error":"#VALUE!"}},"σe",{"$f":"ROUND( (0.803 * Design_Wheel_Load / cc_thick2^2 )* ( 4*LOG(radius_rel_stiff2 / radius_eq_cir_area,10)  +  0.666*( radius_eq_cir_area / radius_rel_stiff2 ) - 0.034),4)","v":{"$error":"#VALUE!"}},null,null,true]
["Stress Ratio  SR = EdgeLoad Stress / 90-days flexural strength of concrete",{"$nulls":4},true]
[{"$f":"\"=\" & (stress_edge2)/ ff_90","v":{"$error":"#VALUE!"}},null,{"$f":"TRUNC(stress_edge2/ ff_90,2)","v":{"$error":"#VALUE!"}},{"$f":"SR_2<=1","v":{"$error":"#VALUE!"}},null,true]
[{"$f":"IF(SR_2<=1,\"Since Stress Ratio is less than/equal to 1, Safe\",\"Since Stress Ratio is more than 1, Unsafe\")","v":{"$error":"#VALUE!"}},{"$nulls":4},true]
["(B) Stresses Due to Temperature Differentials ",{"$nulls":4},{"$f":"IF(traffic_census>50,TRUE,FALSE)","v":false}]
["Temparature stresses in the edge region (Mpa)  as per Bradbury eqn and negative stresses due to non-linear distribution= ",{"$nulls":4},{"$f":"F124","v":false}]
[{"$f":"\"=\"& E_Concrete & \" x \" & alpha_concrete & \" x \" & temp_diff2 &\" [ 0.335  x \" & Bradbury_coeff2 & \" - 0.08525]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"F125","v":false}]
[{"$f":"\"=\"& E_Concrete*alpha_concrete* temp_diff2 & \" [\"  & 0.335* Bradbury_coeff2 & \" - 0.08525]\"","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"F126","v":false}]
[{"$f":"\"=\"& E_Concrete*alpha_concrete* temp_diff2*( 0.335* Bradbury_coeff2 - 0.08525)","v":{"$error":"#VALUE!"}},"σte",{"$f":"CEILING(E_Concrete*alpha_concrete* temp_diff2*( 0.335* Bradbury_coeff2 - 0.08525),0.001)","v":{"$error":"#VALUE!"}},null,null,false]
["Total Stresses  = σe + σte =",{"$nulls":4},false]
[{"$f":"\"=\" & stress_edge2 & \" + \" & stress_temp2 & \"=\"","v":{"$error":"#VALUE!"}},null,{"$f":"stress_edge2+stress_temp2","v":{"$error":"#VALUE!"}},null,null,false]
["Stress Ratio  SR = Total stresses / 90-days flexural strength of concrete",{"$nulls":4},false]
[{"$f":"\"=\" & stress_total2 & \" / \" & ff_90","v":{"$error":"#VALUE!"}},{"$nulls":4},false]
[{"$f":"\"=\" & (stress_total2)/ ff_90","v":{"$error":"#VALUE!"}},"≅",{"$f":"TRUNC(stress_total2/ ff_90,2)","v":{"$error":"#VALUE!"}},{"$f":"IF(traffic_census>50,IF(stress_ratio2<=1,TRUE,FALSE),TRUE)","v":true},null,false]
[{"$f":"IF(stress_ratio2<=1,\"Since the stress ratio is less than/equal to 1, Safe\",\"Since stress ratio is more than one, Unsafe\")","v":{"$error":"#VALUE!"}},{"$nulls":4},false]
["(C) Stresses Due to Fatigue",{"$nulls":4},{"$f":"IF(traffic_initial>150,TRUE,FALSE)","v":false}]
["Fatigue life of concrete pavement\n(Allowable load repetitions) =",{"$nulls":4},{"$f":"IF(traffic_initial>150,TRUE,FALSE)","v":false}]
[{"$nulls":5},{"$f":"F136","v":false}]
[{"$f":"\"= 10 ^ ( \" & stress_total2/ff_90 & \"^ -2.22208/0.523)\"","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"F137","v":false}]
[{"$f":"\"= 10 ^ ( \" & (stress_total2/ff_90) ^ -2.22208/0.523&\")\"","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"F138","v":false}]
[{"$f":"\"= \"& 10 ^ ( (stress_total2/ff_90) ^ -2.22208/0.523)","v":{"$error":"#VALUE!"}},"Nf",{"$f":"ROUND(10 ^ ( (stress_total2/ff_90) ^ -2.22208/0.523),0)","v":{"$error":"#VALUE!"}},null,null,false]
["Expected load repetitions =P100 x N",{"$nulls":4},false]
[{"$f":"\"=\" & P_100 & \" x \" & total_cv","v":"=0.1 x 0"},"Ne",{"$f":"Ne","v":0},null,null,false]
["Cumulative fatigue damage = Ne/Nf",{"$nulls":4},false]
[{"$f":"\"= \" & Ne & \" / \" & Nf_2","v":{"$error":"#VALUE!"}},{"$nulls":4},false]
[{"$f":"\"= \" & Ne/ Nf_2","v":{"$error":"#VALUE!"}},"cfd",{"$f":"TRUNC(Ne/ Nf_2,2)","v":{"$error":"#VALUE!"}},{"$f":"IF(traffic_census>150,IF(cfd_2<=1,TRUE,FALSE),TRUE)","v":true},null,false]
[{"$f":"IF(cfd_2<=1,\"Since the fatigue stress ratio is less than/equal 1, Safe\",\"Since fatigue stress ratio is more than one, Unsafe\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"AND(D122,D133,D145)","v":{"$error":"#VALUE!"}},null,false]
[{"$nulls":5},true]
["Conclusion",{"$nulls":4},true]
[{"$f":"IF(cc_thick2>=150,\"Hence adopt concrete pavement thickness of \"&cc_thick2&\" mm\",\"However adopt the minimum thickness of 150 mm\")","v":"However adopt the minimum thickness of 150 mm"},null,{"$f":"IF(cc_thick2>=150,cc_thick2,150)","v":150},null,null,true]
[]
["Design of Subbase/Base for concrete pavement"]
[]
[{"$f":"\"For the traffic  CVPD of \" & traffic_census & \" and \" & Sub_Base & \" Sub-Base/Base, the sub base requirement as per clause 3.6.2 of IRC-SP-62  is \" & VLOOKUP(IF(traffic_census<=50,50,IF(traffic_census<=150,150,450)),SubBase_Traffic,IF(Sub_Base=\"Granular\",2,3),FALSE)","v":"For the traffic  CVPD of  and Granular Sub-Base/Base, the sub base requirement as per clause 3.6.2 of IRC-SP-62  is 100 mm GSB (CBR ≥ 30%, LL < 25%, PI < 6%)  + 75 mm WBM Gr-III/WMM"}]

{"sheet":"Design Abstract","index":3,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":true,"merged":[[2,0,2,3],[17,0,17,3],[1,0,1,3],[20,0,20,3],[21,0,21,3]]}
[]
[{"$f":"Work","v":0}]
["Design Data"]
["Parameter","Description","Units","Value"]
["P1","Census CVPD","No",{"$f":"traffic_census","v":0}]
["r","Annual Rate of traffic increase (%)","%",{"$f":"traffic_rate","v":0.05}]
["x","Construction period (Number of years)","No",{"$f":"con_period","v":1}]
["n","Design period (Typically 20 years)","No",{"$f":"design_period","v":20}]
["Z","Temparature Zone",null,{"$f":"Zone_Selected","v":""}]
["CBRSSG","Soaked Sub-Grade CBR (%)","%",{"$f":"CBR_SSG","v":0}]
["wl_type","Wheel Loading Type",null,{"$f":"wl_type","v":"Dual"}]
["P","Wheel Load","N",{"$f":"Design_Wheel_Load","v":50000}]
["p","tyre pressure","MPa",{"$f":"tyre_pressure","v":0.8}]
["P100","% of total traffic having axel loads equal to 100 KN","%",{"$f":"P_100","v":0.1}]
["L","CC Pavement Panel Joint Spacing","mm",{"$f":"joint_spacing","v":3000}]
["fck","Characteristic Strength of Concrete ","Mpa",{"$f":"fck","v":30}]
[]
["Design Abstract"]
["Parameter","Description","Units","Value","Check"]
["h","Thickness of Pavement Slab","mm",{"$f":"Design_Thickness","v":150},true]
["Design of Sub Base/Base",null,null,null,true]
[{"$f":"'Design Calculations'!A153:C153","v":"For the traffic  CVPD of  and Granular Sub-Base/Base, the sub base requirement as per clause 3.6.2 of IRC-SP-62  is 100 mm GSB (CBR ≥ 30%, LL < 25%, PI < 6%)  + 75 mm WBM Gr-III/WMM"},null,null,null,true]
["a","Radius of equivalent circular area","mm",{"$f":"radius_eq_cir_area","v":180.565},true]
["l","Radius of Rlative Stiffness","mm",{"$f":"radius_rel_stiff2","v":{"$error":"#VALUE!"}},true]
["ff_90","90-Day Flexural Strength","Mpa",{"$f":"ff_90","v":4.2190000000000003},true]
["σe","Edge Stresses","N/mm2",{"$f":"stress_edge2","v":{"$error":"#VALUE!"}},true]
["t","Temparature Differential across Slab thickness","oC",{"$f":"temp_diff2","v":{"$error":"#VALUE!"}},{"$f":"(traffic_initial>=50)","v":false}]
["L/l","Bradbury Ratio",null,{"$f":"Bradbury_Ratio2","v":{"$error":"#VALUE!"}},{"$f":"E27","v":false}]
["C","Bradbury Coefficient",null,{"$f":"Bradbury_coeff2","v":{"$error":"#VALUE!"}},{"$f":"E28","v":false}]
["σte","Temparature Stresses","N/mm2",{"$f":"stress_temp2","v":{"$error":"#VALUE!"}},{"$f":"E29","v":false}]
["σtotal","Total Stresses","N/mm2",{"$f":"stress_total2","v":{"$error":"#VALUE!"}},false]
["SR","Stress Ratio",null,{"$f":"stress_ratio2","v":{"$error":"#VALUE!"}},false]
["Nf","Fatigue Stress - Allowable Load repetitions of Legal Axel Load (10 t)","No",{"$f":"Nf_2","v":{"$error":"#VALUE!"}},{"$f":"(traffic_initial>150)","v":false}]
["Ne","Fatigue Stress - Expected Load repetitions of Legal Axel Load (10 t)","No",{"$f":"Ne","v":0},{"$f":"E33","v":false}]

{"sheet":"Database","index":4,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,10,1,10],[0,11,0,13],[15,0,15,1],[22,0,22,1],[7,5,7,6],[0,0,0,3],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,5,2,5],[0,5,0,7],[1,6,1,7],[0,9,1,9]]}
["Subgrade Reaction Values",{"$nulls":4},"Subbase Requirement for CC pavement",null,null,null,"Zone","States","Temparature Differential oC in Slabs of thickness (mm)",null,null,null,"Region","Zone"]
["Soaked Sub-grade\nCBR (%)","k Value\n(Mpa/m)","K_effective (Mpa/m)",null,null,"Traffic upto\n(CVPD)","Subbase/Base",{"$nulls":4},150,200,250,null,"Andhra Pradesh",3]
[null,null,"Over Granular Sub-Base/Base","Over Cementitious Sub-Base/Base",null,null,"Granular","Cementitious",null,1,"Punjab, Haryana, U.P., Uttaranchal, Manipur, Meghalaya, Mizoram, Nagaland, Sikkim, Arunachal Pradesh, Tripura, Himachal Pradesh, Rajasthan, Gujarat, and Nort M.P. excluding hilly regions",12.5,13.1,14.3,null,"Arunachal Pradesh",1]
[0.02,21,25,42,null,50,"100 mm GSB (CBR ≥ 30%, LL < 25%, PI < 6%)  + 75 mm WBM Gr-III/WMM","150 mm Cementitious Base (UCS ≥ 3 MPa)",null,2,"Bihar, Jharkhand,West Bengal, Assam, and Eastern Orissa excluding hilly regions and Coastal areas",15.6,16.399999999999999,16.600000000000001,null,"Assam",2]
[0.03,28,32,56,null,150,"100 mm GSB (CBR ≥ 30%, LL < 25%, PI < 6%)  + 75 mm WBM Gr-III/WMM","100 mm Cementitious Sub-Base (UCS ≥ 1.5 MPa) + 100 mm Cementitious Base (UCS ≥ 3 MPa)",null,3,"Maharashtra, Karnataka, South M.P., Chattisgarh, Andhra Pradesh, Telangana, Western Orissa, and North Tamil Nadu excluding hilly regions and coastal areas",17.3,19,20.3,null,"Bihar",2]
[0.04,35,42,70,null,450,"100 mm GSB (CBR ≥ 30%, LL < 25%, PI < 6%)  + 150 mm WBM Gr-III/WMM","100 mm Cementitious Sub-Base (UCS ≥ 1.5 MPa) + 100 mm Cementitious Base (UCS ≥ 3 MPa)",null,4,"Kerala and South Tamil Nadu excluding hilly regions and coastal areas",15,16.399999999999999,17.600000000000001,null,"Gujarat",1]
[0.05,42,50,84,{"$nulls":5},5,"Coastal areas bounded by hills",14.6,15.8,16.2,null,"Haryana",1]
[7.0000000000000007E-2,48,58,96,null,"Design stresses consideration",null,null,null,6,"Coastal areas unbounded by hills",15.5,17,19,null,"Himachal Pradesh",1]
[0.1,50,60,100,null,"Traffic upto\n(CVPD)","Subbase",{"$nulls":8},"Jharkhand",2]
[0.15,62,74,124,null,50,"Concrete pavement thickness may be designed considering pavement edge stresses only",{"$nulls":8},"Karnataka",3]
[0.2,69,83,138,null,150,"Concrete pavement thickness may be designed considering both pavement edge stresses and temparature stresses",{"$nulls":8},"Kerala",4]
[0.5,140,170,280,null,450,"Concrete pavement thickness may be designed considering both pavement edge stresses,  temparature stresses, and fatigue stresses due to repeated application of axel loads of 100 KN during the design period",{"$nulls":8},"Madhya Pradesh (North)",1]
[{"$nulls":15},"Madhya Pradesh (South)",3]
[{"$nulls":15},"Maharashtra",3]
[{"$nulls":15},"Manipur",1]
["Temparature Differential for AP",{"$nulls":14},"Meghalaya",1]
["Slab Thickness \n(mm)","t",{"$nulls":13},"Mizoram",1]
[150,17.3,{"$nulls":13},"Nagaland",1]
[200,19,{"$nulls":13},"Odisha (Easteren)",2]
[250,20.3,{"$nulls":13},"Odisha (Western)",3]
[{"$nulls":15},"Punjab",1]
[{"$nulls":15},"Rajasthan",1]
[{"$nulls":15},"Sikkim",1]
[{"$nulls":15},"Tamilnadu (North)",3]
[{"$nulls":15},"Tamilnadu (South)",4]
[{"$nulls":15},"Telangana",3]
[{"$nulls":15},"Tripura",1]
[{"$nulls":15},"Uttar Pradesh",1]
[{"$nulls":15},"Uttaranchal",1]
[{"$nulls":15},"West Bengal",2]
[{"$nulls":15},"Coastal Areas Bounded by Hills",5]
[{"$nulls":15},"Coastal Areas Un-Bounded by Hills",6]