{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Traffic Survey Parameters","Admin Console","Traffic Census","Design ESAL Calculations","Pavement Composition","Database"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":36,"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":"Traffic Survey Parameters","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[0,0,0,5],[5,1,5,5],[6,1,6,5],[3,1,3,5],[4,1,4,5],[1,1,1,5],[2,1,2,2],[2,4,2,5],[25,5,25,6],[24,0,24,4],[24,5,24,6],[12,1,12,4],[14,1,14,4],[13,1,13,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4]]}
["Traffic Census & Subgrade Parameters",{"$nulls":5},{"$f":"AND(G2:G3,G8:G19)","v":false}]
["Work",{"$nulls":5},{"$f":"Work<>\"\"","v":false}]
["Program",null,null,"Work_ID",null,null,{"$f":"AND(Program<>\"\",Work_ID<>\"\")","v":false}]
["T","Average Daily Traffic of a vehicle in given Category during Lean Season"]
["AADT","Average Annual Daily Traffic over Lean &Harvesting Seasons"]
["N0","ESALs (Equivalent Standard Axel Loads at the Start of Design Period)"]
["N","Cum_ESALs (Cumulative Applications of Equivalent Standard Axels over design period)"]
["CBR","California Bearing Ratio of Subgrade (%)",null,null,null,5,{"$f":"CBR_Subgrade<>\"\"","v":true}]
["S","Season(s) during which Traffic Count Taken",null,null,null,"Lean",{"$f":"Census_Season<>\"\"","v":true}]
["L","No of Lanes",null,null,null,"Single",{"$f":"Lanes<>\"\"","v":true}]
["l","Lane Distribution Factor for the Given Lane Construction",null,null,null,{"$f":"IF(F10=\"Two\",0.75,1)","v":1},{"$f":"Lane_Distribution_Factor<>\"\"","v":true}]
["H","No of Harvesting Seasons",null,null,null,2,{"$f":"Harvest_Seasons<>\"\"","v":true}]
["n","Coefficient for enhnaced Average Daily traffic during peak harvesting season over Lean Season\n[In case Traffic Census is taken during one season (Lean/Peak Harvesting) only]",null,null,null,1,{"$f":"IF(AND(F9<>\"Both\",F13=\"\"),FALSE,TRUE)","v":true}]
["O","Assumed Percentage of Over-Loading in Overladen vehicles",null,null,null,0.2,{"$f":"Over_Loading<>\"\"","v":true}]
["t","Duration of each Harvesting Season (Days)",null,null,null,75,{"$f":"Harvest_Period<>\"\"","v":true}]
["p","Proportion of Peak Harvesting Period over total harvesting period",null,null,null,0.2,{"$f":"Peak_Duration<>\"\"","v":true}]
["r","Assumed Rate of Growth of Traffic ",null,null,null,0.06,{"$f":"Traffic_Rate<>\"\"","v":true}]
["C","Construction Period (Years) from Traffic Census Year",null,null,null,2,{"$f":"Construction_Period<>\"\"","v":true}]
["P ","Design Period of Pavement (Years)",null,null,null,10,{"$f":"Design_Period<>\"\"","v":true}]
["Legend"]
[null,"Data Input Boxes"]
[null,"Data in the adjoining cell(s) is complete & valid"]
[null,"Data in the adjoining cell(s) is incomplete and/or in valid"]
[null,"Additional/Help Comments for the Data Entry in the cell"]
["The App may be refined from time to time. Download the latest app from ",{"$nulls":4},"https://www.civilapps.in"]
["Demo Video for the App",{"$nulls":4},"Demo Video"]

{"sheet":"Admin Console","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Feature Request"]
["Incorporate assumed sub base/base and associated thickness while designing pavement composition for upgradation of roads"]

{"sheet":"Traffic Census","index":2,"n_rows":47,"n_cols":20,"rows_kept":47,"cut":false,"hidden":true,"merged":[[46,0,46,14],[34,0,39,0],[34,1,39,1],[22,0,27,0],[22,1,27,1],[28,0,33,0],[28,1,33,1],[42,1,42,12],[0,0,0,17],[1,0,1,17],[2,5,3,5],[2,3,3,3],[2,4,3,4],[2,6,2,9],[2,10,2,13],[2,14,2,15],[2,17,3,17],[2,16,3,16],[2,2,3,2],[4,3,9,4],[2,0,3,0],[2,1,3,1],[44,1,44,15],[40,3,40,4],[10,0,15,0],[10,1,15,1],[16,0,21,0],[16,1,21,1]]}
[{"$f":"\"Name of the Work: \" & Work","v":"Name of the Work: "}]
[{"$f":"\"Traffic Count Taken in Both Directions of the Road during \" & Census_Season & \" Season\"","v":"Traffic Count Taken in Both Directions of the Road during Lean Season"}]
["S.No","Vehicle","CV Category","Axel Type","Laden Condition","Vehicle/ Axel/ Laden","Lean Seson",null,null,null,"Harvest Seson",null,null,null,"ADT",null,"n","AADT"]
[{"$nulls":6},"Day1","Day2","Day3","Average","Day1","Day2","Day3","Average","Lean Season","Harvest Season",null,null,null,"Traffic_Filter"]
[1,"Cycle","None",{"$nulls":6},{"$f":"ROUNDUP(SUM(G5:I5)/3,0)","v":0},null,null,null,{"$f":"ROUNDUP(SUM(K5:M5)/3,0)","v":0},{"$f":"IFERROR(IF(Census_Season=\"Lean\",J5,ROUND((K5+L5+M5)/(3*(Coefficient+1)),2)),0)","v":0},{"$f":"N5","v":0},{"$f":"IFERROR(IF(Census_Season=\"Both\",CEILING((P5-O5)/O5,0.1),Coefficient),1)","v":1},{"$f":"IFERROR(ROUND(O5*(1+(1+Peak_Duration)*Q5*Harvest_Period*Harvest_Seasons/730),2),0)","v":0},null,{"$f":"J5+N5","v":0}]
[2,"Cycle Rickshaw","None",{"$nulls":6},{"$f":"ROUNDUP(SUM(G6:I6)/3,0)","v":0},null,null,null,{"$f":"ROUNDUP(SUM(K6:M6)/3,0)","v":0},{"$f":"IFERROR(IF(Census_Season=\"Lean\",J6,ROUND((K6+L6+M6)/(3*(Coefficient+1)),2)),0)","v":0},{"$f":"N6","v":0},1,0,null,{"$f":"J6+N6","v":0}]
[3,"Animal drawn cart (Pneumatic Tyred)","None",{"$nulls":6},0,null,null,null,0,0,0,1,0,null,0]
[4,"Animal drawn cart (Iron rimmed)","None",{"$nulls":6},0,null,null,null,0,0,0,1,0,null,0]
[5,"Motor Cycle/Scooter","None",{"$nulls":6},0,null,null,null,0,0,0,1,0,null,0]
[6,"Car/Jeep/3W-Auto","LCV",{"$nulls":6},0,null,null,null,0,0,0,1,0,null,0]
[7,"Tractor-Trailer","MCV","Single","Laden",{"$f":"C11&D11&E11","v":"MCVSingleLaden"},null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Single","Unladen",{"$f":"C12&D12&E12","v":"MCVSingleUnladen"},null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Single","Overladen","MCVSingleOverladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Tandem","Laden","MCVTandemLaden",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Tandem","Unladen","MCVTandemUnladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Tandem","Overladen","MCVTandemOverladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[8,"Pickup Van/Mini Bus","MCV","Single","Laden","MCVSingleLaden",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Single","Unladen","MCVSingleUnladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Single","Overladen","MCVSingleOverladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Tandem","Laden","MCVTandemLaden",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Tandem","Unladen","MCVTandemUnladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Tandem","Overladen","MCVTandemOverladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[9,"Medium Truck","MCV","Single","Laden","MCVSingleLaden",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Single","Unladen","MCVSingleUnladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Single","Overladen","MCVSingleOverladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Tandem","Laden","MCVTandemLaden",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Tandem","Unladen","MCVTandemUnladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"MCV","Tandem","Overladen","MCVTandemOverladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[10,"Full-Sized Bus","HCV","Single","Laden","HCVSingleLaden",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"HCV","Single","Unladen","HCVSingleUnladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"HCV","Single","Overladen","HCVSingleOverladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"HCV","Tandem","Laden","HCVTandemLaden",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"HCV","Tandem","Unladen","HCVTandemUnladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"HCV","Tandem","Overladen","HCVTandemOverladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[11,"Heavy Truck","HCV","Single","Laden","HCVSingleLaden",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"HCV","Single","Unladen","HCVSingleUnladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"HCV","Single","Overladen","HCVSingleOverladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"HCV","Tandem","Laden","HCVTandemLaden",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"HCV","Tandem","Unladen","HCVTandemUnladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,"HCV","Tandem","Overladen","HCVTandemOverladen",null,null,null,0,null,null,null,0,0,0,1,0,null,0]
[null,null,null,"ADT/AADT (All Vehicles)",{"$nulls":5},{"$f":"SUM(J5:J40)","v":0},null,null,null,{"$f":"SUM(N5:N40)","v":0},{"$f":"SUM(O5:O40)","v":0},{"$f":"SUM(P5:P40)","v":0},null,{"$f":"SUM(R5:R40)","v":0}]
[]
[null,"AADTi = Average Annual Daily Traffic of a given vehicle category (Census)="]
[]
[null,"Average Annual Daily Traffic for ALL Vehicle Categories (Census)=",{"$nulls":15},{"$f":"R41","v":0}]
[]
["AADT0 = Average Annual Daily Traffic for ALL Vehicle Categories (Start of Design Period)= (1 + Traffic Growth Rate)Construction Period =",{"$nulls":16},{"$f":"ROUND(R45*(1+Traffic_Rate)^Construction_Period,0)","v":0}]

{"sheet":"Design ESAL Calculations","index":3,"n_rows":27,"n_cols":22,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,0,0,21],[3,0,8,0],[3,2,8,2],[9,0,14,0],[9,2,14,2],[1,0,2,0],[1,2,2,2],[1,1,2,1],[1,9,1,11],[1,8,2,8],[1,3,2,3],[1,5,1,7],[1,21,2,21],[1,17,2,17],[1,18,2,18],[1,19,1,20],[26,1,26,2],[26,4,26,6],[25,7,25,18],[24,1,24,8],[21,3,21,17],[26,7,27,21],[15,7,15,20],[1,13,1,15],[23,0,23,2],[25,1,25,2],[25,3,25,6],[15,0,15,3],[16,0,17,2],[20,19,20,21],[21,19,21,21],[18,5,18,17],[20,5,20,17],[1,4,2,4]]}
[{"$f":"\"Name of the Work: \" & Work","v":"Name of the Work: "}]
["S.No","Commercial Vehicle Category","Vehicle","Rear Axel Type","Laden Condition","Load (kN)",null,null,"VDF","Lean Season",null,null,null,"Peak Harvesting Season",null,null,null,"T","n","AADT",null,"N0"]
[{"$nulls":5},"Total","Front\nAxel","Rear\nAxel",null,"Day1","Day2","Day3","Average","Day1","Day2","Day3","Average",null,null,"Census#","Design*"]
[1,"MCV","Tractor-Trailer/ Pickup Van/ Mini Bus/ Medium Truck","Single","Laden",{"$f":"G4+H4","v":88.2},29.4,58.800000000000004,{"$f":"CEILING((G4/80)^4+(H4/IF(D4=\"Single\",80,148))^4,0.01)","v":0.32},{"$f":"SUMIF(OFFSET(CV_Range,0,0,,1),$B4&$D4&$E4,OFFSET(CV_Range,0,1,,1))","v":0},{"$f":"SUMIF(OFFSET(CV_Range,0,0,,1),$B4&$D4&$E4,OFFSET(CV_Range,0,2,,1))","v":0},{"$f":"SUMIF(OFFSET(CV_Range,0,0,,1),$B4&$D4&$E4,OFFSET(CV_Range,0,3,,1))","v":0},{"$f":"ROUND((J4+K4+L4)/3,2)","v":0},{"$f":"SUMIF(OFFSET(CV_Range,0,0,,1),$B4&$D4&$E4,OFFSET(CV_Range,0,5,,1))","v":0},{"$f":"SUMIF(OFFSET(CV_Range,0,0,,1),$B4&$D4&$E4,OFFSET(CV_Range,0,6,,1))","v":0},{"$f":"SUMIF(OFFSET(CV_Range,0,0,,1),$B4&$D4&$E4,OFFSET(CV_Range,0,7,,1))","v":0},{"$f":"ROUND((N4+O4+P4)/3,2)","v":0},{"$f":"IFERROR(IF(Census_Season=\"Lean\",M4,ROUND((N4+O4+P4)/(3*(Coefficient+1)),2)),0)","v":0},{"$f":"IFERROR(IF(Census_Season=\"Both\",CEILING((Q4-M4)/M4,0.1),Coefficient),1)","v":1},{"$f":"IFERROR(ROUND(R4*(1+(1+Peak_Duration)*S4*Harvest_Period*Harvest_Seasons/730),2),0)","v":0},{"$f":"T4*(1+Traffic_Rate)^Construction_Period","v":0},{"$f":"IFERROR(ROUND(I4*U4,2),0)","v":0}]
[null,"MCV",null,"Single","Unladen",44.099999999999994,14.7,29.4,0.02,0,0,0,0,0,0,0,{"$f":"ROUND((N5+O5+P5)/3,2)","v":0},0,{"$f":"IFERROR(IF(Census_Season=\"Both\",CEILING((Q5-M5)/M5,0.1),Coefficient),1)","v":1},{"$f":"IFERROR(ROUND(R5*(1+(1+Peak_Duration)*S5*Harvest_Period*Harvest_Seasons/730),2),0)","v":0},0,0]
[null,"MCV",null,"Single","Overladen",{"$f":"ROUND(F4*(1+Over_Loading),1)","v":105.8},{"$f":"ROUND(G4*(1+Over_Loading),1)","v":35.299999999999997},{"$f":"ROUND(H4*(1+Over_Loading),1)","v":70.599999999999994},0.65,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,"MCV",null,"Tandem","Laden",88.2,29.4,58.800000000000004,0.05,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,"MCV",null,"Tandem","Unladen",44.099999999999994,14.7,29.4,0.01,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,"MCV",null,"Tandem","Overladen",{"$f":"ROUND(F7*(1+Over_Loading),1)","v":105.8},{"$f":"ROUND(G7*(1+Over_Loading),1)","v":35.299999999999997},{"$f":"ROUND(H7*(1+Over_Loading),1)","v":70.599999999999994},0.09,0,0,0,0,0,0,0,0,0,1,0,0,0]
[2,"HCV","Full-Sized Bus/Heavy Truck","Single","Laden",149.1,49.1,100,2.59,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,"HCV",null,"Single","Unladen",88.199999999999989,29.4,58.8,0.32,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,"HCV",null,"Single","Overladen",{"$f":"ROUND(F10*(1+Over_Loading),1)","v":178.9},{"$f":"ROUND(G10*(1+Over_Loading),1)","v":58.9},{"$f":"ROUND(H10*(1+Over_Loading),1)","v":120},5.36,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,"HCV",null,"Tandem","Laden",235.39999999999998,58.8,176.6,2.3199999999999998,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,"HCV",null,"Tandem","Unladen",117.69999999999999,{"$f":"ROUND(G13/2,1)","v":29.4},{"$f":"ROUND(H13/2,1)","v":88.3},0.15,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,"HCV",null,"Tandem","Overladen",{"$f":"ROUND(F13*(1+Over_Loading),1)","v":282.5},{"$f":"ROUND(G13*(1+Over_Loading),1)","v":70.599999999999994},{"$f":"ROUND(H13*(1+Over_Loading),1)","v":211.9},4.8100000000000005,0,0,0,0,0,0,0,0,0,1,0,0,0]
["Design Summary",{"$nulls":6},"Cumulative Application of ESAL/Day for all Commercial Vehicles",{"$nulls":13},{"$f":"SUM(V4:V15)","v":0}]
[{"$f":"\"Traffic Category for Cumulative ESAL Applications of  '\" &E27 & \"' Over design Period =\"","v":"Traffic Category for Cumulative ESAL Applications of  '0' Over design Period ="}]
[null,null,null,{"$f":"VLOOKUP(E27,Traffic_Categories,2,TRUE)","v":"T1"}]
[null,null,"Sub Grade CBR=",{"$f":"CBR_Subgrade","v":5},null,"#AADT = Average Annual Daily Traffic of a given vehicle category ="]
[null,null,"Sub Grade Class=",{"$f":"CBR_Class(CBR_Subgrade)","v":"S3"}]
[{"$nulls":5},"*AADT = Average Annual Daily Traffic at the start of design period =",{"$nulls":13},"#AADT (1+r)C"]
[null,null,null,"N0 = ESALs (Equivalent Standard Axel Loads) at the start of design Period =",{"$nulls":15},"*AADT X VDF"]
[]
["N=Cumulative Application of ESALs over Design Period ="]
[null,{"$f":"\" = 365 x  Lane_Distribution_Factor  x  Initial ESALs  x  (((1 +  Traffic_Rate)^ Design_Period) - 1)/ Traffic_Rate\"","v":" = 365 x  Lane_Distribution_Factor  x  Initial ESALs  x  (((1 +  Traffic_Rate)^ Design_Period) - 1)/ Traffic_Rate"}]
[null,{"$f":"\" = 365 x \"& Lane_Distribution_Factor & \" x \" & $V$16 & \" x  (((1 + \" & Traffic_Rate & \")^\" & Design_Period & \") - 1)/\" & Traffic_Rate","v":" = 365 x 1 x 0 x  (((1 + 0.06)^10) - 1)/0.06"},null,{"$f":"\" = 365 x \"& Lane_Distribution_Factor & \" x \" & $V$16 & \" x  ((\" & (1 +  Traffic_Rate) & \"^\" & Design_Period & \") - 1)/\" & Traffic_Rate","v":" = 365 x 1 x 0 x  ((1.06^10) - 1)/0.06"},null,null,null,{"$f":"\" = 365 x \"& Lane_Distribution_Factor & \" x \" & $V$16 & \" x  ((\" & ROUND((1 +  Traffic_Rate) ^ Design_Period,3) & \") - 1)/\" & Traffic_Rate","v":" = 365 x 1 x 0 x  ((1.791) - 1)/0.06"},{"$nulls":11},{"$f":"\" = 365 x \"& Lane_Distribution_Factor & \" x \" & $V$16 & \" x  \" & ROUND((( (1 +  Traffic_Rate) ^ Design_Period  - 1)),3)&\" /\" & Traffic_Rate","v":" = 365 x 1 x 0 x  0.791 /0.06"}]
[null,{"$f":"\" = 365 x \"& Lane_Distribution_Factor & \" x \" & $V$16 & \" x  \" &ROUND( (( (1 +  Traffic_Rate) ^ Design_Period  - 1)) / Traffic_Rate,3)","v":" = 365 x 1 x 0 x  13.181"},null,{"$f":"\"=\"","v":"="},{"$f":"ROUND(365*Lane_Distribution_Factor*V16*(((1+Traffic_Rate)^(Design_Period))-1)/Traffic_Rate,0)","v":0},null,null,{"$f":"IF(Design_ESAL>2000000,\"Flexible pavement can not be designed if cumulative design ESALs exceed 2 MSA under IRC SP-72. The design has to be done as per IRC-37\",\"\")","v":""}]

{"sheet":"Pavement Composition","index":4,"n_rows":315,"n_cols":4,"rows_kept":315,"cut":false,"hidden":true,"merged":[[0,0,0,1],[307,0,307,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[141,0,141,3]]}
["Design Pavement Composition for ",null,null,"Sub-Bases/Bases"]
["Name of the Work"]
[{"$f":"Work","v":0}]
[{"$f":"\"Design of Pavement Composition for Subgrade class \" & Subgrade_Class & \" and Traffic Category \" & Traffic_Category & \" for \" &SubBases_Bases & \" Sub-Bases and Bases\"","v":"Design of Pavement Composition for Subgrade class S3 and Traffic Category T1 for  Sub-Bases and Bases"}]
[]
["SxTy","Layer","Thickness (mm)","Legend"]
["S1T1","Gravel Base",200,":"]
["S1T1","Improved Subgrade",100,"*"]
["S1T2","BT Surface Course",null,"_"]
["S1T2","Granular Base",75,"|"]
["S1T2","Gravel Base",150,":"]
["S1T2","Improved Subgrade",100,"*"]
["S1T3","BT Surface Course",null,"_"]
["S1T3","Granular Base",150,"|"]
["S1T3","Granular Sub Base",125,"`"]
["S1T3","Improved Subgrade",100,"*"]
["S1T4","BT Surface Course",null,"_"]
["S1T4","Gravel Base",150,":"]
["S1T4","Granular Sub Base",125,"`"]
["S1T4","Improved Subgrade",150,"*"]
["S1T5","BT Surface Course",null,"_"]
["S1T5","Gravel Base",150,":"]
["S1T5","Granular Sub Base",175,"`"]
["S1T5","Improved Subgrade",150,"*"]
["S1T6","BT Surface Course",null,"_"]
["S1T6","Granular Base",150,"|"]
["S1T6","Granular Sub Base",250,"`"]
["S1T6","Improved Subgrade",150,"*"]
["S1T7","BT Surface Course",null,"_"]
["S1T7","Granular Base",225,"|"]
["S1T7","Granular Sub Base",200,"`"]
["S1T7","Improved Subgrade",225,"*"]
["S1T8","BT Surface Course",null,"_"]
["S1T8","Granular Base",225,"|"]
["S1T8","Granular Sub Base",225,"`"]
["S1T8","Improved Subgrade",200,"*"]
["S1T9","BT Surface Course",null,"_"]
["S1T9","Bituminous Macadam",50,"."]
["S1T9","Granular Base",225,"|"]
["S1T9","Granular Sub Base",250,"`"]
["S1T9","Improved Subgrade",200,"*"]
["S2T1","Gravel Base",200,":"]
["S2T2","Gravel Base",275,":"]
["S2T3","BT Surface Course",null,"_"]
["S2T3","Granular Base",150,"|"]
["S2T3","Granular Sub Base",175,"`"]
["S2T4","BT Surface Course",null,"_"]
["S2T4","Granular Base",150,"|"]
["S2T4","Granular Sub Base",125,"`"]
["S2T4","Improved Subgrade",100,"*"]
["S2T5","BT Surface Course",null,"_"]
["S2T5","Granular Base",150,"|"]
["S2T5","Granular Sub Base",125,"`"]
["S2T5","Improved Subgrade",150,"*"]
["S2T6","BT Surface Course",null,"_"]
["S2T6","Granular Base",225,"|"]
["S2T6","Granular Sub Base",100,"`"]
["S2T6","Improved Subgrade",150,"*"]
["S2T7","BT Surface Course",null,"_"]
["S2T7","Granular Base",225,"|"]
["S2T7","Granular Sub Base",150,"`"]
["S2T7","Improved Subgrade",150,"*"]
["S2T8","BT Surface Course",null,"_"]
["S2T8","Granular Base",225,"|"]
["S2T8","Granular Sub Base",150,"`"]
["S2T8","Improved Subgrade",200,"*"]
["S2T9","BT Surface Course",null,"_"]
["S2T9","Bituminous Macadam",50,"."]
["S2T9","Granular Base",225,"|"]
["S2T9","Granular Sub Base",200,"`"]
["S2T9","Improved Subgrade",100,"*"]
["S3T1","Gravel Base",175,":"]
["S3T2","Gravel Base",250,":"]
["S3T3","Gravel Base",275,":"]
["S3T4","BT Surface Course",null,"_"]
["S3T4","Granular Base",150,"|"]
["S3T4","Granular Sub Base",150,"`"]
["S3T5","BT Surface Course",null,"_"]
["S3T5","Granular Base",150,"|"]
["S3T5","Granular Sub Base",175,"`"]
["S3T6","BT Surface Course",null,"_"]
["S3T6","Granular Base",150,"|"]
["S3T6","Granular Sub Base",125,"`"]
["S3T6","Improved Subgrade",100,"*"]
["S3T7","BT Surface Course",null,"_"]
["S3T7","Granular Base",225,"|"]
["S3T7","Granular Sub Base",100,"`"]
["S3T7","Improved Subgrade",100,"*"]
["S3T8","BT Surface Course",null,"_"]
["S3T8","Granular Base",225,"|"]
["S3T8","Granular Sub Base",200,"`"]
["S3T8","Improved Subgrade",100,"*"]
["S3T9","BT Surface Course",null,"_"]
["S3T9","Bituminous Macadam",50,"."]
["S3T9","Granular Base",225,"|"]
["S3T9","Granular Sub Base",200,"`"]
["S4T1","Gravel Base",150,":"]
["S4T2","Gravel Base",175,":"]
["S4T3","Gravel Base",225,":"]
["S4T4","BT Surface Course",null,"_"]
["S4T4","Granular Base",150,"|"]
["S4T4","Granular Sub Base",125,"`"]
["S4T5","BT Surface Course",null,"_"]
["S4T5","Granular Base",150,"|"]
["S4T5","Granular Sub Base",150,"`"]
["S4T6","BT Surface Course",null,"_"]
["S4T6","Granular Base",150,"|"]
["S4T6","Granular Sub Base",175,"`"]
["S4T7","BT Surface Course",null,"_"]
["S4T7","Granular Base",225,"|"]
["S4T7","Granular Sub Base",150,"`"]
["S4T8","BT Surface Course",null,"_"]
["S4T8","Granular Base",225,"|"]
["S4T8","Granular Sub Base",200,"`"]
["S4T9","BT Surface Course",null,"_"]
["S4T9","Bituminous Macadam",50,"."]
["S4T9","Granular Base",225,"|"]
["S4T9","Granular Sub Base",150,"`"]
["S5T1","Gravel Base",125,":"]
["S5T2","Gravel Base",150,":"]
["S5T3","Gravel Base",175,":"]
["S5T4","BT Surface Course",null,"_"]
["S5T4","Granular Base",75,"|"]
["S5T4","Granular Sub Base",150,"`"]
["S5T5","BT Surface Course",null,"_"]
["S5T5","Granular Base",150,"|"]
["S5T5","Granular Sub Base",125,"`"]
["S5T6","BT Surface Course",null,"_"]
["S5T6","Granular Base",150,"|"]
["S5T6","Granular Sub Base",150,"`"]
["S5T7","BT Surface Course",null,"_"]
["S5T7","Granular Base",225,"|"]
["S5T7","Granular Sub Base",125,"`"]
["S5T8","BT Surface Course",null,"_"]
["S5T8","Granular Base",150,"|"]
["S5T8","Granular Sub Base",175,"`"]
["S5T9","BT Surface Course",null,"_"]
["S5T9","Bituminous Macadam",50,"."]
["S5T9","Granular Base",225,"|"]
["S5T9","Granular Sub Base",125,"`"]
[]
["LEGEND for Conventional Gravel/Granular Sub-Bases/Bases"]
["CBR","Layer","Remarks","Legend"]
[null,"BT Surface Course","MSS/OGPC/MSS/SDBC"]
[null,"Bituminous Macadam",null,"."]
["≥ 100","Granular Base","WBM/WMM/CRBM","|"]
["≥ 80/50 ","Gravel Base",null,":"]
["≥ 20/15","Granular Sub Base",null,"`"]
["≥ 10","Improved Subgrade","Modified/Select Soil","*"]
[]
["SiTj","Layer","Thickness (mm)","Legend"]
["S1T1","Surface Dressing",null,"-"]
["S1T1","Cement Treated Base",150,"|"]
["S1T1","Cement Treated Sub Base",100,"`"]
["S1T2","Surface Dressing",null,"-"]
["S1T2","Cement Treated Base",150,"|"]
["S1T2","Cement Treated Sub Base",110,"`"]
["S1T3","Surface Dressing",null,"-"]
["S1T3","Cement Treated Base",150,"|"]
["S1T3","Cement Treated Sub Base",120,"`"]
["S1T4","Surface Dressing",null,"-"]
["S1T4","Cement Treated Base",150,"|"]
["S1T4","Cement Treated Sub Base",125,"`"]
["S1T5","Surface Dressing",null,"-"]
["S1T5","Cement Treated Base",150,"|"]
["S1T5","Cement Treated Sub Base",130,"`"]
["S1T6","BT Carpet",null,"_"]
["S1T6","Crack Relief Layer",75,","]
["S1T6","Cement Treated Base",150,"|"]
["S1T6","Cement Treated Sub Base",125,"`"]
["S1T7","BT Carpet",null,"_"]
["S1T7","Crack Relief Layer",125,","]
["S1T7","Cement Treated Base",150,"|"]
["S1T7","Cement Treated Sub Base",100,"`"]
["S1T8","BT Carpet",null,"_"]
["S1T8","Crack Relief Layer",125,","]
["S1T8","Cement Treated Base",150,"|"]
["S1T8","Cement Treated Sub Base",125,"`"]
["S1T9","BT Carpet",null,"_"]
["S1T9","Bituminous Macadam",50,"."]
["S1T9","Crack Relief Layer",75,","]
["S1T9","Cement Treated Base",150,"|"]
["S1T9","Cement Treated Sub Base",125,"`"]
["S2T1","Surface Dressing",null,"-"]
["S2T1","Cement Treated Base",100,"|"]
["S2T1","Cement Treated Sub Base",100,"`"]
["S2T2","Surface Dressing",null,"-"]
["S2T2","Cement Treated Base",100,"|"]
["S2T2","Cement Treated Sub Base",100,"`"]
["S2T3","Surface Dressing",null,"-"]
["S2T3","Cement Treated Base",100,"|"]
["S2T3","Cement Treated Sub Base",125,"`"]
["S2T4","Surface Dressing",null,"-"]
["S2T4","Cement Treated Base",100,"|"]
["S2T4","Cement Treated Sub Base",125,"`"]
["S2T5","Surface Dressing",null,"-"]
["S2T5","Cement Treated Base",100,"|"]
["S2T5","Cement Treated Sub Base",150,"`"]
["S2T6","BT Carpet",null,"_"]
["S2T6","Crack Relief Layer",75,","]
["S2T6","Cement Treated Base",125,"|"]
["S2T6","Cement Treated Sub Base",100,"`"]
["S2T7","BT Carpet",null,"_"]
["S2T7","Crack Relief Layer",75,","]
["S2T7","Cement Treated Base",150,"|"]
["S2T7","Cement Treated Sub Base",100,"`"]
["S2T8","BT Carpet",null,"_"]
["S2T8","Crack Relief Layer",75,","]
["S2T8","Cement Treated Base",150,"|"]
["S2T8","Cement Treated Sub Base",125,"`"]
["S2T9","BT Carpet",null,"_"]
["S2T9","Bituminous Macadam",50,"."]
["S2T9","Crack Relief Layer",75,","]
["S2T9","Cement Treated Base",100,"|"]
["S2T9","Cement Treated Sub Base",125,"`"]
["S3T1","Surface Dressing",null,"-"]
["S3T1","Cement Treated Base",100,"|"]
["S3T1","Cement Treated Sub Base",100,"`"]
["S3T2","Surface Dressing",null,"-"]
["S3T2","Cement Treated Base",100,"|"]
["S3T2","Cement Treated Sub Base",100,"`"]
["S3T4","Surface Dressing",null,"-"]
["S3T4","Cement Treated Base",100,"|"]
["S3T4","Cement Treated Sub Base",100,"`"]
["S3T5","Surface Dressing",null,"-"]
["S3T5","Cement Treated Base",100,"|"]
["S3T5","Cement Treated Sub Base",125,"`"]
["S3T6","BT Carpet",null,"_"]
["S3T6","Crack Relief Layer",75,","]
["S3T6","Cement Treated Base",100,"|"]
["S3T6","Cement Treated Sub Base",100,"`"]
["S3T7","BT Carpet",null,"_"]
["S3T7","Crack Relief Layer",75,","]
["S3T7","Cement Treated Base",125,"|"]
["S3T7","Cement Treated Sub Base",100,"`"]
["S3T8","BT Carpet",null,"_"]
["S3T8","Crack Relief Layer",75,","]
["S3T8","Cement Treated Base",125,"|"]
["S3T8","Cement Treated Sub Base",125,"`"]
["S3T9","BT Carpet",null,"_"]
["S3T9","Bituminous Macadam",50,"."]
["S3T9","Crack Relief Layer",75,","]
["S3T9","Cement Treated Base",100,"|"]
["S3T9","Cement Treated Sub Base",100,"`"]
["S4T1","Surface Dressing",null,"-"]
["S4T1","Cement Treated Base",100,"|"]
["S4T1","Cement Treated Sub Base",100,"`"]
["S4T2","Surface Dressing",null,"-"]
["S4T2","Cement Treated Base",100,"|"]
["S4T2","Cement Treated Sub Base",100,"`"]
["S4T3","Surface Dressing",null,"-"]
["S4T3","Cement Treated Base",100,"|"]
["S4T3","Cement Treated Sub Base",100,"`"]
["S4T4","Surface Dressing",null,"-"]
["S4T4","Cement Treated Base",100,"|"]
["S4T4","Cement Treated Sub Base",100,"`"]
["S4T5","Surface Dressing",null,"-"]
["S4T5","Cement Treated Base",100,"|"]
["S4T5","Cement Treated Sub Base",125,"`"]
["S4T6","BT Carpet",null,"_"]
["S4T6","Crack Relief Layer",75,","]
["S4T6","Cement Treated Base",100,"|"]
["S4T6","Cement Treated Sub Base",100,"`"]
["S4T7","BT Carpet",null,"_"]
["S4T7","Crack Relief Layer",75,","]
["S4T7","Cement Treated Base",100,"|"]
["S4T7","Cement Treated Sub Base",100,"`"]
["S4T8","BT Carpet",null,"_"]
["S4T8","Crack Relief Layer",75,","]
["S4T8","Cement Treated Base",125,"|"]
["S4T8","Cement Treated Sub Base",100,"`"]
["S4T9","BT Carpet",null,"_"]
["S4T9","Crack Relief Layer",75,","]
["S4T9","Cement Treated Base",140,"|"]
["S4T9","Cement Treated Sub Base",100,"`"]
["S5T1","Surface Dressing",null,"-"]
["S5T1","Cement Treated Base",100,"|"]
["S5T1","Cement Treated Sub Base",100,"`"]
["S5T2","Surface Dressing",null,"-"]
["S5T2","Cement Treated Base",100,"|"]
["S5T2","Cement Treated Sub Base",100,"`"]
["S5T3","Surface Dressing",null,"-"]
["S5T3","Cement Treated Base",100,"|"]
["S5T3","Cement Treated Sub Base",100,"`"]
["S5T4","Surface Dressing",null,"-"]
["S5T4","Cement Treated Base",100,"|"]
["S5T4","Cement Treated Sub Base",100,"`"]
["S5T5","Surface Dressing",null,"-"]
["S5T5","Cement Treated Base",100,"|"]
["S5T5","Cement Treated Sub Base",100,"`"]
["S5T6","BT Carpet",null,"_"]
["S5T6","Crack Relief Layer",75,","]
["S5T6","Cement Treated Base",100,"|"]
["S5T6","Cement Treated Sub Base",100,"`"]
["S5T7","BT Carpet",null,"_"]
["S5T7","Crack Relief Layer",75,","]
["S5T7","Cement Treated Base",100,"|"]
["S5T7","Cement Treated Sub Base",100,"`"]
["S5T8","BT Carpet",null,"_"]
["S5T8","Crack Relief Layer",75,","]
["S5T8","Cement Treated Base",100,"|"]
["S5T8","Cement Treated Sub Base",100,"`"]
["S5T9","BT Carpet",null,"_"]
["S5T9","Crack Relief Layer",75,","]
["S5T9","Cement Treated Base",125,"|"]
["S5T9","Cement Treated Sub Base",100,"`"]
[]
["LEGEND for Cement Stabilized Sub-Bases/Bases"]
["CBR","Layer","Remarks","Legend"]
[null,"BT Carpet","MSS/OGPC/MSS/SDBC"]
[null,"Surface Dressing",null,"-"]
["≥ 100","Bituminous Macadam",null,"."]
["≥ 80/50 ","Crack Relief Layer",null,","]
["≥ 20/15","Cement Treated Base",null,"|"]
["≥ 10","Cement Treated Sub Base",null,"`"]

{"sheet":"Database","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Cumulative ESAL Applications","Traffic Category"]
[0,"T1"]
[30000,"T2"]
[60000,"T3"]
[100000,"T4"]
[200000,"T5"]
[300000,"T6"]
[600000,"T7"]
[1000000,"T8"]
[1500000,"T9"]
[2000000,"Non-Rural Traffic Category"]