{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Input Sheet","Database","Design Calculations"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":15,"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 Sheet","index":0,"n_rows":60,"n_cols":21,"rows_kept":60,"cut":false,"hidden":false,"merged":[[7,17,8,17],[7,18,8,18],[7,2,7,3],[7,4,8,4],[7,0,8,0],[7,6,8,6],[7,7,8,7],[7,1,8,1],[7,16,8,16],[7,8,7,11],[7,12,8,12],[7,13,8,13],[7,14,8,14],[7,5,8,5],[1,3,1,14],[1,0,1,2],[5,0,5,14],[2,0,2,3],[3,0,3,3],[2,4,2,8],[3,4,3,8],[2,13,2,14],[2,11,2,12],[2,9,2,10],[3,13,3,14],[3,11,3,12],[3,9,3,10]]}
[{"$nulls":16},{"$f":"AND(Q2,Q4,Q8)","v":false},null,null,null,{"$f":"IF(Input_Valid,\"Overall Input Valid\",\"Overall Input Invalid/Incomplete\")","v":"Overall Input Invalid/Incomplete"}]
["Name of the Work",{"$nulls":15},{"$f":"Work<>\"\"","v":false}]
["Program",null,null,null,"Package/Work_ID",{"$nulls":4},"Rainfall (mm)",null,"Terrain",null,"Design Speed"]
[{"$nulls":16},{"$f":"AND(Program<>\"\",Terrain<>\"\",Rainfall<>\"\",Design_Speed<>\"\",Work_ID<>\"\",Design_Speed>=R4,Design_Speed<=S4)","v":false},{"$f":"IFERROR(VLOOKUP(Terrain,Terrain_DesignSpeed,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Terrain,Terrain_DesignSpeed,2,FALSE),0)","v":0},null,{"$f":"IFERROR(\"The Design Speed Can vary from the minimum of \" & VLOOKUP(Terrain,Terrain_DesignSpeed,3,FALSE) & \" to the ruling speed of \" & VLOOKUP(Terrain,Terrain_DesignSpeed,2,FALSE) & \" kmph\",\"\")","v":""}]
[]
["Abstract of Design of Horizontal Curves (All Measurements in Decimal Notation 00.000)"]
[]
["Chainage (km)","[Prposed] wearing surface","Radius of Curvature from Curve Chord & Offset Measurements",null,"OR \nInput Radius of Curvature (m) Directly",null,"Chainage (km)","R - Radius of Curvature (m)","Super Elevation (%)",null,null,null,"Extra Width (m)","Speed Limit (if any)\n(kmph) ","L -Length of Transition Curve on either Side (m)",null,{"$f":"AND(Chainage_Data,T8)","v":false},"Either All Mandatory Fields Entered OR None Entered","There can not be a blank row in the data",{"$f":"OR(Data)","v":false}]
[null,null,"C - Total Chord Length (m)","Offset (m)",{"$nulls":4},"Required","Maximum","Minimum","Design",{"$nulls":7},"All Mandatory Fields Entered"]
[]
[{"$nulls":6},{"$f":"IF(A11<>\"\",A11,\"\")","v":""},{"$f":"IFERROR(ROUND(IF(AND(C11<>\"\",D11<>\"\"),(((C11/2)^2+(D11^2))/(2*D11)),IF(E11<>\"\",E11,\"\")),2),\"\")","v":""},{"$f":"IFERROR(IF(AND(Design_Speed<>\"\",T11),ROUND((Design_Speed^2)/(225*H11),4),\"\"),\"\")","v":""},{"$f":"IF(AND(T11,Terrain<>\"\"),IF(Terrain<>\"\",IF(OR(Terrain=\"Plain\",Terrain=\"Rolling\"),7%,10%),\"\"),\"\")","v":""},{"$f":"IF(AND(T11,Rainfall<>\"\",B11<>\"\"),VLOOKUP(B11,Camber,IF(Rainfall<=1000,2,3),FALSE),\"\")","v":""},{"$f":"IF(T11,IF(I11>J11,J11,IF(I11<K11,K11,I11)),\"\")","v":""},{"$f":"IF(T11,IF(H11<=20,0.9,IF(H11<=60,0.6,0)),\"\")","v":""},{"$f":"IFERROR(IF(T11,IF(SQRT(127*H11*0.22) < Design_Speed, _xlfn.FLOOR.MATH(SQRT(127*H11*0.22),5),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(T11,ROUND(IF(OR(Terrain=\"Plain\",Terrain=\"Rolling\"),2.7,1)*(MIN(Design_Speed,N11)^2)/H11,0),\"\"),\"\")","v":""},null,{"$f":"AND(R11,S11)","v":true},{"$f":"OR(AND(A11=\"\",B11=\"\",H11=\"\"),AND(A11<>\"\",B11<>\"\",H11<>\"\"))","v":true},{"$f":"TRUE","v":true},{"$f":"AND(B11<>\"\",G11<>\"\",H11<>\"\")","v":false}]
[{"$nulls":6},"",{"$f":"IFERROR(ROUND(IF(AND(C12<>\"\",D12<>\"\"),(((C12/2)^2+(D12^2))/(2*D12)),IF(E12<>\"\",E12,\"\")),2),\"\")","v":""},{"$f":"IFERROR(IF(AND(Design_Speed<>\"\",T12),ROUND((Design_Speed^2)/(225*H12),4),\"\"),\"\")","v":""},"","",{"$f":"IF(T12,IF(I12>J12,J12,IF(I12<K12,K12,I12)),\"\")","v":""},{"$f":"IF(T12,IF(H12<=20,0.9,IF(H12<=60,0.6,0)),\"\")","v":""},{"$f":"IFERROR(IF(T12,IF(SQRT(127*H12*0.22) < Design_Speed, _xlfn.FLOOR.MATH(SQRT(127*H12*0.22),5),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(T12,ROUND(IF(OR(Terrain=\"Plain\",Terrain=\"Rolling\"),2.7,1)*(MIN(Design_Speed,N12)^2)/H12,0),\"\"),\"\")","v":""},null,{"$f":"AND(R12,S12)","v":true},true,{"$f":"IF(OR(B12<>\"\",G12<>\"\",H12<>\"\"),IF(OR(B11=\"\",G11=\"\",H11=\"\"),FALSE,TRUE),TRUE)","v":true},false]
[{"$nulls":6},"","","","","","","","","",null,true,true,{"$f":"IF(OR(B13<>\"\",G13<>\"\",H13<>\"\"),IF(OR(B12=\"\",G12=\"\",H12=\"\"),FALSE,TRUE),TRUE)","v":true},false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},{"$f":"IF(A43<>\"\",A43,\"\")","v":""},"","",{"$f":"IF(AND(T43,Terrain<>\"\"),IF(Terrain<>\"\",IF(OR(Terrain=\"Plain\",Terrain=\"Rolling\"),7%,10%),\"\"),\"\")","v":""},{"$f":"IF(AND(T43,Rainfall<>\"\",B43<>\"\"),VLOOKUP(B43,Camber,IF(Rainfall<=1000,2,3),FALSE),\"\")","v":""},"","","","",null,true,{"$f":"OR(AND(A43=\"\",B43=\"\",H43=\"\"),AND(A43<>\"\",B43<>\"\",H43<>\"\"))","v":true},true,{"$f":"AND(B43<>\"\",G43<>\"\",H43<>\"\")","v":false}]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]
[{"$nulls":6},"","","","","","","","","",null,true,true,true,false]

{"sheet":"Database","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,1,0,2],[0,0,1,0],[9,0,10,0],[8,0,8,2],[9,1,9,2]]}
["Terrain","Design Speed"]
[null,"Ruling","Minimum"]
["Plain",50,40]
["Rolling",40,35]
["Hilly",25,20]
["Steep",25,20]
[]
[]
["Camber"]
["Surface","Rainfall"]
[null,"<= 1000 mm","> 1000 mm"]
["BT",0.03,3.5000000000000003E-2]
["CC",0.02,2.5000000000000001E-2]

{"sheet":"Design Calculations","index":2,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[[20,1,20,9],[21,1,21,9],[15,1,15,9],[6,1,6,7]]}
[false,{"$nulls":9},"Go to Input Sheet to Print Design Document"]
[true,{"$f":"\"Design of Horizontal Curve at km \" & B1 & \" with radius of curvature 'R' \" &C1& \" m\"","v":"Design of Horizontal Curve at km  with radius of curvature 'R'  m"}]
[true,"A. Determination of Super Elevation [As per Clause 2.10.3 of IRC-SP-20]"]
[true,"Required Super elevation (m/m) = V2/225R",null,null,null,{"$f":"\" = \" &Design_Speed & \" x \" & Design_Speed & \"/225 x \"&C1","v":" =  x /225 x "},null,{"$f":"\"=\" &POWER(Design_Speed,2) & \"/ \" & 225*C1","v":"=0/ 0"}]
[true,{"$nulls":4},{"$f":"\"=\"&IFERROR(ROUND(POWER(Design_Speed,2)/(225*C1),4),0) & \" m/m \"","v":"=0 m/m "},null,"OR",{"$f":"D1","v":0}]
[true,"Limitations on Super Elevation"]
[true,"A) Minimum super elevation is applicable camber, which depends on the rainfall and surface course of carriageway",{"$nulls":6},{"$f":"F1","v":0}]
[true,{"$f":"\"B) Limiting Super Elevation for the given \" & Terrain & \" terrain = \"","v":"B) Limiting Super Elevation for the given  terrain = "},{"$nulls":6},{"$f":"E1","v":0}]
[true,"Hence Design Super Elevation e'= ",{"$nulls":6},{"$f":"G1","v":0}]
[true,"B. Determination of Extra Width (Table 2.17 of IRC: SP: 20)"]
[true,"Extra Width Required for the given radius of curvature (m)=",{"$nulls":6},{"$f":"H1","v":0}]
[true,"C. Determination of Length of Transition Curve L"]
[true,{"$nulls":5},{"$f":"\"Since Terrain is \" & Terrain & \"Length of Transition Curve L is given by \" & IF(OR(Terrain=\"Plain\",Terrain=\"Rolling\"),2.7,1) & \" x \"","v":"Since Terrain is Length of Transition Curve L is given by 1 x "},"v2/R"]
[true]
[true,"Where"]
[true,"v is applicable speed at the horizontal curve (Design Speed or Limiting Speed which ever is less)"]
[true,"R is Radius of Curvature"]
[true,"L =",{"$f":"J1","v":0},"m"]
[true,"Provide Above Transition Curve on either side of the horizontal Curve"]
[{"$f":"D1>E1","v":false},"D. Speed Limit due to reduction of required super elevation to limiting value"]
[{"$f":"A20","v":false},"Since Required Super Elevation is more than the limiting value of super elevation, the speed may have to be limited at the horizontal curve."]
[{"$f":"A21","v":false},"The Speed Limit has to be worked out from the General Formula of Super elevation, which is given below:"]
[false,"e' + f = v2 / 127 R;"]
[false,"Where"]
[false," v = Limiting value of Speed at this point of curve"]
[false,"e' = Design Super Elevation"]
[false," f = Coefficient of friction of the riding surface (which may be taken as 0.15)"]
[false," and R = Radius of curvature"]
[false,"Reorganizing the equation",{"$nulls":5},"OR v = SQRT(127R(e'+f)"]
[false,null,null,null,"=",{"$f":"\"SQRT(127 x \" & C1 & \" x (\" & E1 & \" + 0.15)\"","v":"SQRT(127 x  x ( + 0.15)"}]
[false,null,null,null,"=",{"$f":"\"SQRT(\"&127*C1*(E1+0.15)&\")\"","v":"SQRT(0)"}]
[false,null,null,null,"=",{"$f":"ROUND(SQRT(127*C1*(E1+0.15)),2)","v":0}]
[false,null,null,null,"Or Say",{"$f":"I1","v":0},"kmph"]
[false,{"$f":"IF(G1>Design_Speed,\"Since Limiting Speed exceeds Design Speed, There is no need to impose speed limits\", \"Place Speed Limit Boards on either side of the curve on LHS as per above limit\")","v":"Place Speed Limit Boards on either side of the curve on LHS as per above limit"}]