{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Input Parameters","Longitudinal Section","Admin Notes","Earth Work Data","Abstract Data","Cross Sections"],"not_rendered":{"charts":1,"images":11,"macros":1,"external_links":0,"defined_names":61,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input Parameters","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,1,14,5],[16,1,16,5],[15,1,15,5],[13,1,13,5],[17,1,17,5],[9,0,10,0],[0,0,0,5],[6,0,7,0],[1,1,1,5],[9,4,10,4],[9,2,10,2],[6,1,7,1],[6,2,6,3],[5,0,5,3],[6,4,7,4],[6,5,7,5],[5,4,5,5]]}
["Input Parameters",{"$nulls":5},{"$f":"AND(G2,G4:G5,G9:G11)","v":false}]
["Name of the Work",{"$nulls":5},{"$f":"Work<>\"\"","v":false}]
["Program","Sub Program","Package/Work_ID","Length (km)","Terrain","Design Speed"]
[{"$nulls":5},{"$f":"IF(Terrain=\"Plain\",50,IF(Terrain=\"Rolling\",40,25))","v":25},{"$f":"AND(Program<>\"\",Sub_Program<>\"\",Work_ID<>\"\",Length<>\"\",Terrain<>\"\",Design_Speed<>\"\")","v":false}]
["Rainfall (mm)",null,"RD From",0,"RD To",{"$f":"Length","v":0},{"$f":"AND(Rainfall<>\"\",RD_From<>\"\",RD_To<>\"\")","v":false}]
["Design Geometrics",null,null,null,"Existing Geometrics"]
["Carriageway (m)","Roadway (m)","Side Slopes (1V:H)",null,"Roadway (m)","Side Slopes (1V:H)"]
[null,null,"Filling","Cutting"]
[3.75,{"$f":"IF(Carriageway=3,6,IF(Carriageway=3.75,7.5,9))","v":7.5},2,0.5,null,null,{"$f":"AND(Carriageway<>\"\",Roadway<>\"\",Side_Slope_Filling<>\"\",D9<>\"\",OR(AND(Existing_Roadway<>\"\",Existing_Side_Slope<>\"\"),AND(Existing_Roadway=\"\",Existing_Side_Slope=\"\")))","v":true}]
["Proposed Layers\n(up to which formation proposed)","Sub Base","Width (m)",null,"Thickness (mm)",null,{"$f":"OR(AND(Subbase_Width<>\"\",Subbase_Thickness<>\"\"),AND(Subbase_Width=\"\",Subbase_Thickness=\"\"))","v":true}]
[null,"Base",{"$nulls":4},{"$f":"OR(AND(Base_Width<>\"\",Base_Thickness<>\"\"),AND(Base_Width=\"\",Base_Thickness=\"\"))","v":true}]
[]
["Legend",{"$f":"AND(Subbase_Width<>\"\",Subbase_Thickness<>\"\")","v":false},{"$f":"AND(Base_Width<>\"\",Base_Thickness<>\"\")","v":false},{"$f":"AND(Existing_Roadway<>\"\",Existing_Side_Slope<>\"\")","v":false}]
[null,"Mandatory Data Input Boxes"]
[null,"Optional Data Input Boxes "]
[null,"Data Entry in the Adjoining Cell/Row Complete & Valid"]
[null,"Data Entry in the Adjoining Cell/Row Incomplete and/or invalid"]
[null,"On Mouse-Over the cell - Additional/Supporting/Help Information for the Data Entry "]

{"sheet":"Longitudinal Section","index":1,"n_rows":24,"n_cols":22,"rows_kept":24,"cut":false,"hidden":true,"merged":[[21,0,21,1],[22,0,22,1],[23,0,23,1],[0,13,0,15],[0,9,0,11],[0,5,0,7],[0,3,0,4],[0,0,0,2]]}
["Terrain",null,null,{"$f":"Terrain","v":0},null,"Ruling Gradient (%)",null,null,{"$f":"IF(OR($D$1=\"Plain\",$D$1=\"Rolling\"),3.3,5)","v":5},"Limiting Gradient (%)",null,null,{"$f":"IF(OR($D$1=\"Plain\",$D$1=\"Rolling\"),5,IF($D$1=\"Hilly\",6,7))","v":7},"Exceptional Gradient (%)",null,null,{"$f":"IF(OR($D$1=\"Plain\",$D$1=\"Rolling\"),6,IF($D$1=\"Hilly\",7,8))","v":8}]
{"$rows_empty":16}
[null,0,10,20,30,40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190,200]
["Pre-Levels",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Final-Levels",{"$f":"B19+3","v":3},3,3,3,3,3,3,3,3,3,3,3,3,{"$f":"O19+3","v":3},{"$f":"P19+3","v":3},{"$f":"Q19+3","v":3},{"$f":"R19+3","v":3},{"$f":"S19+3","v":3},3,{"$f":"U19+3","v":3},{"$f":"V19+3","v":3}]
[]
["            Reach\nGradient ",null,{"$f":"B18 & \" to \" & C18","v":"0 to 10"},{"$f":"C18 & \" to \" & D18","v":"10 to 20"},"20 to 30","30 to 40","40 to 50","50 to 60","60 to 70","70 to 80",{"$f":"J18 & \" to \" & K18","v":"80 to 90"},{"$f":"K18 & \" to \" & L18","v":"90 to 100"},{"$f":"L18 & \" to \" & M18","v":"100 to 110"},{"$f":"M18 & \" to \" & N18","v":"110 to 120"},{"$f":"N18 & \" to \" & O18","v":"120 to 130"},{"$f":"O18 & \" to \" & P18","v":"130 to 140"},{"$f":"P18 & \" to \" & Q18","v":"140 to 150"},{"$f":"Q18 & \" to \" & R18","v":"150 to 160"},{"$f":"R18 & \" to \" & S18","v":"160 to 170"},{"$f":"S18 & \" to \" & T18","v":"170 to 180"},{"$f":"T18 & \" to \" & U18","v":"180 to 190"},{"$f":"U18 & \" to \" & V18","v":"190 to 200"}]
["@ Pre-Levels",null,{"$f":"ROUND(100*(C19-B19)/(C$18-B$18),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(100*(O19-N19)/(O$18-N$18),2)","v":0},0,0,0,0,0,0,0]
["@Final-Levels",null,{"$f":"ROUND(100*(C20-B20)/(C$18-B$18),2)","v":0},{"$f":"ROUND(100*(D20-C20)/(D$18-C$18),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Admin Notes","index":2,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Feature Upgrades"]
["After Generation of Pre-Levels, Freeze Chainages"]
["Longitudinal Sections - Pre-Levels and PRE And Final Levels - Critical Gradient Reaches"]
["Random Transverse Levels @ 1 m "]
["Incorporate Deductions"]
["Cutting/Filling Regions and Balance Statement"]
["Only Widening Quantities"]

{"sheet":"Earth Work Data","index":3,"n_rows":11,"n_cols":187,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,1,0,2],[1,0,1,8],[4,4,4,5],[6,10,7,10],[6,9,7,9],[6,0,7,0],[6,3,6,5],[6,6,7,6],[6,1,6,2],[6,7,6,8],[2,0,2,1],[3,0,3,1],[2,3,2,5],[7,148,7,178],[7,180,7,184],[7,42,7,46],[7,108,7,138],[7,140,7,144],[7,48,7,54],[7,76,7,106],[7,12,7,18],[7,28,7,32],[7,66,7,69],[7,71,7,74],[7,20,7,26],[7,34,7,38],[7,58,7,62]]}
[{"$f":"ROUND(SUM(Volume_Draft),0)","v":0},"EW Quantity (cum)"]
["Earthwork Data",{"$nulls":8},{"$f":"AND(J4,J7)","v":false}]
["Cross Section Interval (m)",null,null,"Randomization of GL Variation (mm)"]
[{"$f":"IF(OR(Terrain = \"Plain\",Terrain=\"Rolling\"),50,20)","v":20},{"$nulls":8},{"$f":"AND(Posted_Levels<>\"\",GL_Variation_Min<>\"\",GL_Variation_Max<>\"\")","v":false}]
[null,null,null,"Posted Levels","Interpolated Levels"]
[]
["Chainage","Roadway  (M)",null,"Posted Pre-Levels (M)",null,null,"Road Top Level","Side Slope",null,{"$f":"AND(OFFSET(EW_Data,1,9,,1))","v":false},{"$f":"AND(OFFSET(EW_Data,1,10,,1))","v":false}]
[null,"Design","Existing","Left","Center*","Right",null,"Design","Existing",null,null,null,"Abscissa_Design",{"$nulls":7},"Draft Pre-Levels (New Formation)",{"$nulls":7},"Abscissa_Existing",{"$nulls":5},"Draft Pre-Levels (Existing Formation)",{"$nulls":7},"PLA_New",{"$nulls":5},"PLA_Existing",{"$nulls":9},"FLA",{"$nulls":7},"Abscissa_Left",{"$nulls":4},"Abscissa_Right",{"$nulls":4},"Abscissa",{"$nulls":31},"Pre-Levels",{"$nulls":31},"Final-Levels",{"$nulls":7},"Pre-Levels Areas",{"$nulls":31},"Final-Levels Area"]
[]
["Chainage","Roadway (Design)","Roadway (Existing)","RL_Left","RL_Center","RL_Right","Road_Top","Side_Slope (Design)","Side_Slope (Existing)","Pre-Levels\nValidation","Road Top\nValidation",null,"LeftEnd","LeftToe","LeftRW_Edge","Center","RightRW_Edge","RightToe","RightEnd",null,"LeftEnd","LeftToe","LeftRW_Edge","Center","RightRW_Edge","RightToe","RightEnd",null,"LeftToe","LeftRW_Edge","Center","RightRW_Edge","RightToe",null,"LeftToe","LeftRW_Edge","Center","RightRW_Edge","RightToe",null,"Draft Datum",null,"New_PLA1","New_PLA2","New_PLA3","New_PLA4","New_PLA",null,"LeftToe-Toe","LeftToe-Edge","LeftEdge-Center","RightCenter-Edge","RightEdge-Toe","RightToe-Toe","Existing_PLA",null,"PLA",null,"FLA1","FLA2","FLA3","FLA4","FLA",null,"Draft Volume",null,"LeftEnd","LeftToe","LeftRW_Edge","LeftToe",null,"RightToe","RightRW_Edge","RightToe","RightEnd",null,"X1","X2","X3","X4","X5","X6","X7","X8","X9","X10","X11","X12","X13","X14","X15","X16","X17","X18","X19","X20","X21","X22","X23","X24","X25","X26","X27","X28","X29","X30","X31",null,"P1","P2","P3","P4","P5","P6","P7","P8","P9","P10","P11","P12","P13","P14","P15","P16","P17","P18","P19","P20","P21","P22","P23","P24","P25","P26","P27","P28","P29","P30","P31",null,"LeftToe","LeftRW_Edge","Center","RightRW_Edge","RightToe",null,"Datum",null,"PA1","PA2","PA3","PA4","PA5","PA6","PA7","PA8","PA9","PA10","PA11","PA12","PA13","PA14","PA15","PA16","PA17","PA18","PA19","PA20","PA21","PA22","PA23","PA24","PA25","PA26","PA27","PA28","PA29","PA30","PATotal",null,"FA1","FA2","FA3","FA4","FATotal",null,"Volume"]
[{"$nulls":9},{"$f":"AND(A11<>\"\",B11<>\"\",E11<>\"\",H11<>\"\",OR(AND(D11<>\"\",F11<>\"\"),AND(D11=\"\",F11=\"\")),OR(AND(Existing_Geometrics,C11<>\"\",I11<>\"\",D11<>\"\",F11<>\"\",C11<B11-1,I11<H11-0.5),AND(NOT(Existing_Geometrics),C11=\"\",I11=\"\")))","v":false},{"$f":"G11<>\"\"","v":false},null,{"$f":"CEILING(N11,-1)","v":0},{"$f":"-ROUND(($B11/2)+($G11-$D11)*$H11,2)","v":0},{"$f":"-ROUND($B11/2,2)","v":0},0,{"$f":"ROUND($B11/2,2)","v":0},{"$f":"ROUND(($B11/2)+($G11-$F11)*$H11,2)","v":0},{"$f":"CEILING(R11,1)","v":0},null,{"$f":"D11","v":0},{"$f":"IFERROR(CEILING(($U11+(N11-$M11)*($X11-$U11)/($P11-$M11))-0.005,0.005),0)","v":0},{"$f":"IFERROR(CEILING(($U11+(O11-$M11)*($X11-$U11)/($P11-$M11))-0.005,0.005),0)","v":0},{"$f":"E11","v":0},{"$f":"IFERROR(CEILING(($X11+(Q11-$P11)*($AA11-$X11)/($S11-$P11))-0.005,0.005),0)","v":0},{"$f":"IFERROR(CEILING(($X11+(R11-$P11)*($AA11-$X11)/($S11-$P11))-0.005,0.005),0)","v":0},{"$f":"F11","v":0},null,{"$f":"-ROUND(($C11/2)+0.75*($E11-$D11)*$I11,2)","v":0},{"$f":"-ROUND($C11/2,2)","v":0},0,{"$f":"ROUND($C11/2,2)","v":0},{"$f":"ROUND(($C11/2)+0.75*($E11-$F11)*$I11,2)","v":0},null,{"$f":"AJ11-(AD11-AC11)*$I11","v":-5.0000000000000001E-3},{"$f":"CEILING($E11-Existing_Roadway*0.035/2-0.005,0.005)","v":-5.0000000000000001E-3},{"$f":"E11","v":0},{"$f":"CEILING($E11-Existing_Roadway*0.035/2-0.005,0.005)","v":-5.0000000000000001E-3},{"$f":"AL11-(AG11-AF11)*$I11","v":-5.0000000000000001E-3},null,{"$f":"IF(Existing_Geometrics, MIN(MIN(U11:AA11),MIN(AI11:AM11)),MIN(U11:AA11))","v":0},null,{"$f":"IFERROR(ROUND((O11-N11)*((V11-$AO11)+(W11-$AO11))/2,3),0)","v":0},{"$f":"IFERROR(ROUND((P11-O11)*((W11-$AO11)+(X11-$AO11))/2,3),0)","v":0},0,0,{"$f":"SUM(AQ11:AT11)","v":0},null,{"$f":"IFERROR(ROUND((AC11-N11)*((AI11-$AO11)+(V11-$AO11))/2,3),0)","v":0},{"$f":"IFERROR(ROUND((AD11-AC11)*((AI11-$AO11)+(AJ11-$AO11))/2,3),0)","v":0},{"$f":"IFERROR(ROUND((AE11-AD11)*((AJ11-$AO11)+(AK11-$AO11))/2,3),0)","v":0},{"$f":"IFERROR(ROUND((AF11-AE11)*((AK11-$AO11)+(AL11-$AO11))/2,3),0)","v":0},{"$f":"IFERROR(ROUND((AG11-AF11)*((AL11-$AO11)+(AM11-$AO11))/2,3),0)","v":0},{"$f":"IFERROR(ROUND((R11-AG11)*((AM11-$AO11)+(Z11-$AO11))/2,3),0)","v":0},{"$f":"SUM(AW11:BB11)","v":0},null,{"$f":"IF(Existing_Geometrics,BC11,AU11)","v":0},null,{"$f":"ROUND((O11-N11)*((EK11-$AO11)+(EL11-$AO11))/2,3)","v":0},{"$f":"ROUND((P11-O11)*((EL11-$AO11)+(EM11-$AO11))/2,3)","v":0},{"$f":"ROUND((Q11-P11)*((EM11-$AO11)+(EN11-$AO11))/2,3)","v":0},{"$f":"ROUND((R11-Q11)*((EN11-$AO11)+(EO11-$AO11))/2,3)","v":0},{"$f":"SUM(BG11:BJ11)","v":0},null,{"$f":"IFERROR(ROUND(($A11-$A10)*((BK10-BE10)+(BK11-BE11))/2,2),0)","v":0},null,{"$f":"M11","v":0},{"$f":"N11","v":0},{"$f":"O11","v":0},{"$f":"AC11","v":0},null,{"$f":"AG11","v":0},{"$f":"Q11","v":0},{"$f":"R11","v":0},{"$f":"S11","v":0},{"$nulls":33},{"$f":"IF(BY11=\"\",\"\",IF(ISNUMBER(MATCH(BY11,$AC11:$AG11,0)),OFFSET($AI11:$AM11,0,MATCH(BY11,$AC11:$AG11,0)-1,1,1),IF(ISNUMBER(MATCH(BY11,$M11:$S11,0)),OFFSET($U11:$AA11,0,MATCH(BY11,$M11:$S11,0)-1,1,1),\"\")))","v":""},{"$f":"IF(BZ11=\"\",\"\",IF(ISNUMBER(MATCH(BZ11,$AC11:$AG11,0)),OFFSET($AI11:$AM11,0,MATCH(BZ11,$AC11:$AG11,0)-1,1,1),IF(ISNUMBER(MATCH(BZ11,$M11:$S11,0)),OFFSET($U11:$AA11,0,MATCH(BZ11,$M11:$S11,0)-1,1,1),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,{"$f":"V11","v":0},{"$f":"CEILING($G11-Roadway*0.035/2-0.005,0.005)","v":-0.13500000000000001},{"$f":"G11","v":0},{"$f":"CEILING($G11-Roadway*0.035/2-0.005,0.005)","v":-0.13500000000000001},{"$f":"Z11","v":0},null,{"$f":"IFERROR(MIN(MIN(OFFSET(DE11:EI11,0,COUNTA(DE11:EI11)-1,1,)),MIN(EK11:EO11)),0)","v":-0.13500000000000001},null,{"$f":"IFERROR(ROUND(ABS(BY11-BZ11)*((DE11-$EQ11) + (DF11-$EQ11))/2,3),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(ABS(CP11-CQ11)*((DV11-$EQ11) + (DW11-$EQ11))/2,3),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(ES11:FV11),3)","v":0},null,{"$f":"ROUND(ABS(N11-O11)*((EK11-$EQ11) + (EL11-$EQ11))/2,3)","v":0},{"$f":"ROUND(ABS(O11-P11)*((EL11-$EQ11) + (EM11-$EQ11))/2,3)","v":0},{"$f":"ROUND(ABS(P11-Q11)*((EM11-$EQ11) + (EN11-$EQ11))/2,3)","v":0},{"$f":"ROUND(ABS(Q11-R11)*((EN11-$EQ11) + (EO11-$EQ11))/2,3)","v":0},{"$f":"SUM(FY11:GB11)","v":0},null,{"$f":"IFERROR(ROUND(($A11-$A10)*((GC10-FW10)+(GC11-FW11))/2,2),0)","v":0}]

{"sheet":"Abstract Data","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Abstract Earthwork Quantity"]
[]
["Chainage (m)","Cross Sectional Area (sqm)","Quantity (cum)"]
[{"$f":"'Earth Work Data'!A11","v":0},{"$f":"'Earth Work Data'!FW11","v":0},{"$f":"'Earth Work Data'!GE11","v":0}]

{"sheet":"Cross Sections","index":5,"n_rows":8,"n_cols":26,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,0,0,27],[1,17,1,20],[1,21,1,22],[1,23,1,24],[1,25,1,27],[1,1,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,14],[1,15,1,16]]}
["Earthwork Cross Sections (Levels & Charts)"]
[null,"Cross Section (km)",{"$nulls":5},"Datum",null,null,null,"Total Final-Level Area ",{"$nulls":5},"Total Pre-Level Area ",{"$nulls":5},"Total Area ",null,{"$f":"P2-V2","v":0}]
[]
[]
["Pre-Levels"]
["Final-Levels"]
["Pre-Level Area wrt Datum",{"$f":"ROUND(ABS(B$4-C$4)*((B5-$J$2)+(C5-$J$2))/2,3)","v":0}]
["Final-Level Area wrt Datum",{"$f":"ROUND(ABS(B$4-C$4)*((B6-$J$2)+(C6-$J$2))/2,3)","v":0}]