{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Assumptions","Input Data","Assumptions-Input Data","Design Abstract","Discharge-Household & IRs","Discharge-Main Road","Drain-Cross Sections","CS_Main Road"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":27,"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":"Assumptions","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,1,18,2],[19,1,19,2],[20,1,20,2],[0,0,0,2],[10,0,10,2],[14,0,14,2],[17,0,17,2],[5,1,5,2],[13,1,13,2],[15,1,15,2],[16,1,16,2]]}
["Assumptions"]
["No of People/Household",5,"No"]
["Peak Factor",3]
["Self Cleaning Velocity",1,"m/s"]
["Per Capita/Day Demand of Drinking Water",100,"LPCD"]
["Grey Water Discharge Proportion of LPCD",0.8]
["Usage/Day",12,"Hours"]
["Width of the Household Plot",10,"m"]
["Depth of the Household Plot",15,"m"]
["Size of Household Plot",{"$f":"Width_Household*Depth_Household","v":150},"sqm"]
["Road Width"]
["Internal Road",7.5,"m"]
["Main Road",15,"m"]
["Additional Area",0.2]
["Rainfall Percolation Losses"]
["In Household",0.3]
["On Road",0.4]
["Proportion of Internal Roads on Overall Internal Roads"]
["12-houses/side (Total 2 x 12 = 24 Houses)",0.5]
["8-houses/side (Total 2 x 8 = 16 Houses)",{"$f":"1-Proportion_12","v":0.5}]
["Impervious Factor of the Village Area",0.8]

{"sheet":"Input Data","index":1,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1],[6,0,6,1],[9,0,9,1]]}
["Input Parameters"]
["Design Population"]
["Maximum Intensity of Rainfall (cm/hour)"]
["Total No. of Internal Roads",{"$f":"EVEN(CEILING(Population/(40*(Proportion_12+2)),1))","v":0}]
["No of 12-houses/side Internal Roads",{"$f":"CEILING(Proportion_12*B4,1)","v":0}]
["No of 8-houses/side Internal Roads",{"$f":"Proportion_8*B4","v":0}]
["No of Internal Roads with Drains Feasible on both sides"]
["No of 12-houses/side Internal Roads"]
["No of 8-houses/side Internal Roads"]
["No of Internal Roads with Drains Feasible on One Side Only"]
["No of 12-houses/side Internal Roads",{"$f":"B5-B8","v":0}]
["No of 8-houses/side Internal Roads",{"$f":"B6-B9","v":0}]

{"sheet":"Assumptions-Input Data","index":2,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":true,"merged":[[22,0,22,1],[28,0,28,1],[31,0,31,1],[0,0,0,1],[10,0,10,1],[14,0,14,1],[17,0,17,1]]}
["Assumptions"]
["No of People/Household",{"$f":"Assumptions!B2","v":5}]
["Peak Factor",{"$f":"Assumptions!B3","v":3}]
["Self Cleaning Velocity",{"$f":"Assumptions!B4","v":1}]
["Per Capita/Day Demand of Drinking Water",{"$f":"Assumptions!B5","v":100}]
["Grey Water Discharge Proportion of LPCD",{"$f":"Assumptions!B6","v":0.8}]
["Usage/Day",{"$f":"Assumptions!B7","v":12}]
["Width of the Household Plot",{"$f":"Assumptions!B8","v":10}]
["Depth of the Household Plot",{"$f":"Assumptions!B9","v":15}]
["Size of Household Plot",{"$f":"Assumptions!B10","v":150}]
["Road Width (m)"]
["Internal Road",{"$f":"Assumptions!B12","v":7.5}]
["Main Road",{"$f":"Assumptions!B13","v":15}]
["Additional Area",{"$f":"Assumptions!B14","v":0.2}]
["Rainfall Percolation Losses (%)"]
["In Household",{"$f":"Assumptions!B16","v":0.3}]
["On Road",{"$f":"Assumptions!B17","v":0.4}]
["Proportion of Internal Roads on Overall Internal Roads (%)"]
["12-houses/side (Total 2 x 12 = 24 Houses)",{"$f":"Assumptions!B19","v":0.5}]
["8-houses/side (Total 2 x 8 = 16 Houses)",{"$f":"Assumptions!B20","v":0.5}]
["Impervious Factor of the Village Area",{"$f":"Assumptions!B21","v":0.8}]
[]
["Input Parameters"]
["Design Population",{"$f":"'Input Data'!B2","v":0}]
["Maximum Intensity of Rainfall (cm/hour)",{"$f":"'Input Data'!B3","v":0}]
["Total No. of Internal Roads",{"$f":"'Input Data'!B4","v":0}]
["No of 12-houses/side Internal Roads",{"$f":"'Input Data'!B5","v":0}]
["No of 8-houses/side Internal Roads",{"$f":"'Input Data'!B6","v":0}]
["No of Internal Roads with Drains Feasible on both sides"]
["No of 12-houses/side Internal Roads",{"$f":"'Input Data'!B8","v":0}]
["No of 8-houses/side Internal Roads",{"$f":"'Input Data'!B9","v":0}]
["No of Internal Roads with Drains Feasible on One Side Only"]
["No of 12-houses/side Internal Roads",{"$f":"'Input Data'!B11","v":0}]
["No of 8-houses/side Internal Roads",{"$f":"'Input Data'!B12","v":0}]

{"sheet":"Design Abstract","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,4,4,4],[0,0,0,10],[6,1,6,10],[2,6,4,6],[2,5,4,5],[3,7,3,9],[2,7,2,10],[2,2,4,2],[2,3,4,3],[7,1,8,1],[9,1,10,1],[7,0,8,0],[9,0,10,0],[2,0,4,0],[2,1,4,1]]}
["Design Abstract"]
[]
["S.No.","Road","No","One Side/ Two Sides","Length of the Road (m)","Total Length of the Drain (m)","Cross Section Area of the Drain (sqm)","Drain Dimensions (mm)"]
[{"$nulls":7},"Trapezoidal",null,null,"Semi-Circular"]
[{"$nulls":7},"Top Width","Bottom Width","Depth","Diameter"]
[1,"Main Road",1,2,{"$f":"'Discharge-Main Road'!$I$23","v":0},{"$f":"C6*D6*E6","v":0},{"$f":"'Drain-Cross Sections'!B8","v":0},{"$f":"'Drain-Cross Sections'!B11","v":""},{"$f":"'Drain-Cross Sections'!B9","v":0},{"$f":"'Drain-Cross Sections'!B10","v":0}]
[2,"Internal Roads"]
["a","12-Houses/Side ",{"$f":"'Input Data'!$B$11","v":0},1,{"$f":"12*Width_Household","v":120},{"$f":"C8*D8*E8","v":0},{"$f":"'Drain-Cross Sections'!B22","v":6.6719999999999995E-4},null,null,null,{"$f":"'Drain-Cross Sections'!B27","v":100}]
[null,null,{"$f":"'Input Data'!$B$8","v":0},2,{"$f":"12*Width_Household","v":120},{"$f":"C9*D9*E9","v":0},{"$f":"'Drain-Cross Sections'!C22","v":3.3359999999999998E-4},null,null,null,{"$f":"'Drain-Cross Sections'!C27","v":100}]
["b","8-Houses/Side ",{"$f":"'Input Data'!$B$12","v":0},1,{"$f":"8*Width_Household","v":80},0,{"$f":"'Drain-Cross Sections'!B36","v":4.4480000000000002E-4},null,null,null,{"$f":"'Drain-Cross Sections'!B41","v":100}]
[null,null,{"$f":"'Input Data'!$B$9","v":0},2,{"$f":"8*Width_Household","v":80},0,{"$f":"'Drain-Cross Sections'!C36","v":2.2240000000000001E-4},null,null,null,{"$f":"'Drain-Cross Sections'!C41","v":100}]

{"sheet":"Discharge-Household & IRs","index":4,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[36,2,36,7],[36,8,36,9],[37,0,37,10],[38,1,38,7],[0,0,0,10],[1,0,1,10],[2,1,2,8],[3,1,3,8],[4,1,4,8],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,0,9,10],[10,1,10,8],[11,1,11,8],[22,1,22,7],[23,1,23,7],[24,0,24,10],[25,1,25,10],[26,1,26,7],[19,0,23,0],[19,1,19,7],[17,0,17,10],[18,0,18,10],[19,8,19,9],[20,1,20,10],[21,1,21,7],[34,1,36,1],[25,0,36,0],[27,1,27,7],[28,1,28,7],[29,1,29,7],[30,1,30,7],[31,1,31,7],[32,1,32,7],[33,1,33,10],[34,2,34,7],[34,8,34,9],[35,2,35,10],[10,0,13,0],[12,1,12,8],[13,1,13,8],[15,0,15,8],[14,0,14,10],[2,0,8,0]]}
["Discharge from one Household"]
["I. Grey Water Discharge"]
[null,"No of persons/household",{"$nulls":7},{"$f":"People_Household","v":5},"No"]
[null,"Total Water Demand/ person/ Day (LPCD)",{"$nulls":7},{"$f":"LPCD","v":100},"lit"]
[null,{"$f":"\"∴ Total Water Demand/Household/Day = \" &J3&\" x \" &J4&\" = \"","v":"∴ Total Water Demand/Household/Day = 5 x 100 = "},{"$nulls":7},{"$f":"J3*J4","v":500},"lit"]
[null,{"$f":"\"Grey Water Discharge at \" & 100*Grey_Water_Proportion & \"% of total water demand = \" & 100*Grey_Water_Proportion & \"% x \" & J5 & \" = \"","v":"Grey Water Discharge at 80% of total water demand = 80% x 500 = "},{"$nulls":7},{"$f":"Grey_Water_Proportion*J5","v":400},"Lit"]
[null,{"$f":"\"Assuming Usage Period at \" & Usage_Day & \" hours, discharge =  \" & J6 & \"/(\" &Usage_Day&\" x 60) = \"","v":"Assuming Usage Period at 12 hours, discharge =  400/(12 x 60) = "},{"$nulls":7},{"$f":"ROUND(J6/(Usage_Day*60),6)","v":0.55555600000000005},"lpm"]
[null,{"$f":"\"Taking Peak factor as \" & Peak_Factor & \", Peak Discharge = \" &J7&\" x \" & Peak_Factor & \" =\"","v":"Taking Peak factor as 3, Peak Discharge = 0.555556 x 3 ="},{"$nulls":7},{"$f":"ROUND(Peak_Factor*J7,6)","v":1.666668},"lpm"]
[null,{"$f":"\"Peak Discharge in cum/sec = \" & J8 & \"/(1000 x 60) = \"","v":"Peak Discharge in cum/sec = 1.666668/(1000 x 60) = "},{"$nulls":7},{"$f":"ROUND(J8/60000,7)","v":2.7800000000000001E-5},"cum/sec"]
["II. Rainfall Discharge"]
[null,"Area of one household plot in sqm =",{"$nulls":7},{"$f":"Area_Household","v":150},"sqm"]
[null,{"$f":"\"Area of one household plot in Ha = \" & J11 & \"/10000 = \"","v":"Area of one household plot in Ha = 150/10000 = "},{"$nulls":7},{"$f":"ROUND(J11/10000,4)","v":1.4999999999999999E-2},"Ha"]
[null,{"$f":"\"Treating Percolation Losses at \" & 100*Percolation_Household & \"%, Effective Area = ( 1- \" & Percolation_Household &\") x \" & J12 & \" =\"","v":"Treating Percolation Losses at 30%, Effective Area = ( 1- 0.3) x 0.015 ="},{"$nulls":7},{"$f":"ROUND((1-Percolation_Household)*J12,4)","v":1.0500000000000001E-2},"Ha"]
[null,{"$f":"\"Assuming Impervious Factor at \" & Impervious_Factor & \", Rainfall Discharge = RAP/36 = \" & Rainfall & \" x \" &J13&\" x \" &Impervious_Factor& \"/36 =\"","v":"Assuming Impervious Factor at 0.8, Rainfall Discharge = RAP/36 =  x 0.0105 x 0.8/36 ="},{"$nulls":7},{"$f":"ROUND(Rainfall*J13*Impervious_Factor/36,7)","v":0},"cum/sec"]
["III. Total Discharge/household "]
[{"$f":"\"Total Discharge = Grey Water Discharge + Rain Water Discharge = \" & J9 & \" + \" &J14& \" =\"","v":"Total Discharge = Grey Water Discharge + Rain Water Discharge = 0.0000278 + 0 ="},{"$nulls":8},{"$f":"J9+J14","v":2.7800000000000001E-5},"cum/sec"]
[]
["Discharge from Internal Roads"]
["I. From Households of the Internal Road"]
[null,"Total Discharge/Household (Grey Water and Rainfall)",{"$nulls":6},{"$f":"Discharge_Household","v":2.7800000000000001E-5},null,"cum/sec"]
[null,"Total Discharge from all house holds of the Internal Road (Grey Water + Rainfall)"]
[null,"No of houses/side",{"$nulls":6},12,8,"No"]
[null,"Total Houses/Internal Road = 2 x No of Houses/Side =",{"$nulls":6},24,16,"No"]
[null,"Total Discharge from all the households @ 0.0000278 cum/sec = ",{"$nulls":6},{"$f":"I23*I20","v":6.6720000000000006E-4},{"$f":"J23*I20","v":4.4480000000000002E-4},"cum/sec"]
["II. Rainfall Discharge from the Internal Road"]
[null,"Width of the Internal Road 7.5 m"]
[null,"Length of the Internal Road taking 10 m (along road)/household x no. of houses on one side =",{"$nulls":6},{"$f":"12*Width_Household","v":120},{"$f":"8*Width_Household","v":80},"m"]
[null,"Area of the Internal Road = Length x Width of the Road = Length x 7.5 =",{"$nulls":6},{"$f":"I27*RW_Internal","v":900},{"$f":"J27*RW_Internal","v":600},"sqm"]
[null,"Add 20% common area for the internal road",{"$nulls":6},{"$f":"0.2*I28","v":180},{"$f":"0.2*J28","v":120},"sqm"]
[null,"Total Area of the Internal Road (Including Common Area) = ",{"$nulls":6},{"$f":"I28+I29","v":1080},{"$f":"J28+J29","v":720},"sqm"]
[null,"Assuming Percolation Losses for Road at 40%, Effective Area = (1-0.4) x Gross Area = ",{"$nulls":6},{"$f":"(1-Percolation_Road)*I30","v":648},{"$f":"(1-Percolation_Road)*J30","v":432},"sqm"]
[null,"Total Area of internal roads in Ha = Effective Area (sqm)/10000 = ",{"$nulls":6},{"$f":"I31/10000","v":6.4799999999999996E-2},{"$f":"J31/10000","v":4.3200000000000002E-2},"Ha"]
[null,"Rainfall Discharge for Internal Road = RAP/36 = ",{"$nulls":6},{"$f":"ROUND(Rainfall*I32*Impervious_Factor/36,7)","v":0},{"$f":"ROUND(Rainfall*J32*Impervious_Factor/36,7)","v":0},"cum/sec"]
[null,"Where"]
[null,null,"R = Rainfall Intensity ",{"$nulls":5},{"$f":"Rainfall","v":0},null,"cm/hour"]
[null,null,"A = Effective Area of Internal Road (considering percolation losses) in Ha as above"]
[null,null,"P = Impervious Factor = ",{"$nulls":5},{"$f":"Impervious_Factor","v":0.8}]
["III. Total Discharge from the Internal Road"]
[null,"Total Discharge for the Internal Roads = Total Discharge from the Households + Rainfall Discharge",{"$nulls":6},{"$f":"I24+I33","v":6.6720000000000006E-4},{"$f":"J24+J33","v":4.4480000000000002E-4},"cum/sec"]

{"sheet":"Discharge-Main Road","index":5,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,9],[3,1,3,8],[4,1,4,8],[2,1,2,9],[11,3,11,8],[12,1,12,7],[13,1,13,7],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[22,1,22,7],[23,1,23,7],[24,1,24,7],[25,1,25,7],[14,0,14,9],[15,1,15,7],[16,1,16,7],[17,1,17,7],[18,0,18,9],[19,1,19,7],[34,1,34,7],[10,1,10,9],[32,1,32,7],[32,8,32,9],[2,0,13,0],[15,0,17,0],[19,0,32,0],[33,0,33,9],[26,1,26,7],[27,1,27,7],[28,1,28,7],[29,1,29,9],[30,1,30,7],[31,1,31,9],[20,1,20,9],[21,1,21,7]]}
["Discharge from the Main Road"]
["I. Determination of Distribution of 12_houses/Side-Internal Roads AND 8_houses/side-Internal Roads"]
[null,"Let N be the total no. of internal roads, N1 be the no. of 12-houses/side internal roads, and N2 be the no. of 8-houses/side internal roads "]
[null,"Proportion of N_12 (12-houses/Side Internal Roads) =",{"$nulls":7},{"$f":"Proportion_12","v":0.5}]
[null,"Proportion of N_8 (8-houses/Side Internal Roads) =",{"$nulls":7},{"$f":"Proportion_8","v":0.5}]
[null,{"$f":"\"N1 = No of 12-Houses/Side - Internal Roads = \"","v":"N1 = No of 12-Houses/Side - Internal Roads = "},{"$nulls":7},{"$f":"Proportion_12 & \" x N\"","v":"0.5 x N"}]
[null,{"$f":"\"N2 = No of 8-Houses/Side - Internal Roads = \"","v":"N2 = No of 8-Houses/Side - Internal Roads = "},{"$nulls":7},{"$f":"Proportion_8 & \" x N\"","v":"0.5 x N"}]
[null,{"$f":"\"P1 = Total Population in 12-houses/side-Internal Roads = \nN1 x 2 x 12 x No people/household = \" & Proportion_12 & \"N x 2 x 12 x 5 = \"","v":"P1 = Total Population in 12-houses/side-Internal Roads = \nN1 x 2 x 12 x No people/household = 0.5N x 2 x 12 x 5 = "},{"$nulls":7},{"$f":"Proportion_12*120 & \" x N\"","v":"60 x N"}]
[null,{"$f":"\"P2 = Total Population in 8-houses/side-Internal Roads = \nN2 x 2 x 8 x No people/household = \" & Proportion_8 & \"N x 2 x 8 x 5 = \"","v":"P2 = Total Population in 8-houses/side-Internal Roads = \nN2 x 2 x 8 x No people/household = 0.5N x 2 x 8 x 5 = "},{"$nulls":7},{"$f":"Proportion_8*80 & \" x N\"","v":"40 x N"}]
[null,{"$f":"\"∴ Total Population = P1+P2 = \" & J8 & \" + \" &J9 & \" = (\" & 120*Proportion_12 & \" + \" & 80*Proportion_8 & \") x N = \"","v":"∴ Total Population = P1+P2 = 60 x N + 40 x N = (60 + 40) x N = "},{"$nulls":7},{"$f":"120*Proportion_12 + 80*Proportion_8&\" x N\"","v":"100 x N"}]
[null,"But Total Population P = P1 + P2 = Design Population"]
[null,{"$f":"\"∴ \" &J10 & \" = \" & Population","v":"∴ 100 x N = "},null,{"$f":"\"∴ N  = Total No. of Internal Roads = \" & Population & \"/ (\" & 120*Proportion_12 & \" + \" & 80*Proportion_8 & \") =\" & Population & \"/\" & 120*Proportion_12+ 80*Proportion_8 & \" = \"","v":"∴ N  = Total No. of Internal Roads = / (60 + 40) =/100 = "},{"$nulls":5},{"$f":"EVEN(CEILING(Population/(120*Proportion_12 + 80*Proportion_8),1))","v":0}]
[null,{"$f":"\"N1 = No of 12-Houses/Side - Internal Roads = \" & 100*Proportion_12 & \"% x \" & Total_Roads & \" = \"","v":"N1 = No of 12-Houses/Side - Internal Roads = 50% x 0 = "},{"$nulls":6},{"$f":"CEILING(Proportion_12*Total_Roads,1)","v":0},"No"]
[null,{"$f":"\"N2 = No of 8-Houses/Side - Internal Roads = \" & 100*Proportion_8 & \"% x \" & Total_Roads & \" = \"","v":"N2 = No of 8-Houses/Side - Internal Roads = 50% x 0 = "},{"$nulls":6},{"$f":"CEILING(Proportion_8*Total_Roads,1)","v":0},"No"]
["II. Discharge from Internal Roads"]
[null,{"$f":"\"Discharge from 12_houses/side-Internal roads = No of 12_houses/side-internal roads x Discharge/that road = \" &Twelve_Housed_Roads & \" x \" & Discharge_12_IR","v":"Discharge from 12_houses/side-Internal roads = No of 12_houses/side-internal roads x Discharge/that road = 0 x 0.0006672"},{"$nulls":6},{"$f":"ROUND(Twelve_Housed_Roads*Discharge_12_IR,7)","v":0},"cum/sec"]
[null,{"$f":"\"Discharge from 8_houses/side-Internal roads = No of 12_houses/side-internal roads x Discharge/that road = \" &Eight_Housed_Roads & \" x \" & Discharge_8_IR","v":"Discharge from 8_houses/side-Internal roads = No of 12_houses/side-internal roads x Discharge/that road = 0 x 0.0004448"},{"$nulls":6},{"$f":"ROUND(Eight_Housed_Roads*Discharge_8_IR,7)","v":0},"cum/sec"]
[null,"Total Discharge from the Internal Roads on to the Main Road = ",{"$nulls":6},{"$f":"I16+I17","v":0},"cum/sec"]
["III. Rainfall Discharge for the Main Road"]
[null,"Width of the Main Road = ",{"$nulls":6},{"$f":"RW_Main","v":15},"m"]
[null,"Length of the Main Road = No of Internal Roads on One side of the Main Road x Width of Internal Road"]
[null,{"$f":"\"Length of the Main Road = (\" & Total_Roads & \"/2 ) x \" & RW_Internal&\" =\"","v":"Length of the Main Road = (0/2 ) x 7.5 ="},{"$nulls":6},{"$f":"(Total_Roads/2) *RW_Internal","v":0},"m"]
[null,"Or say",{"$nulls":6},{"$f":"CEILING(I22,5)","v":0},"m"]
[null,{"$f":"\"Area of the Main Road = Length x Width = \" & I23 & \" x \" &I20 & \" =\"","v":"Area of the Main Road = Length x Width = 0 x 15 ="},{"$nulls":6},{"$f":"I23&I20","v":"015"},"sqm"]
[null,{"$f":"\"Add Additional Area @ \" & 100*Additional_Area & \"% for common areas  = \" & I24 & \" x \" & 100*Additional_Area & \"% = \"","v":"Add Additional Area @ 20% for common areas  = 015 x 20% = "},{"$nulls":6},{"$f":"ROUND(Additional_Area*I24,0)","v":3},"sqm"]
[null,{"$f":"\"∴ Total area of the Main Road (Including common areas) = \" & I24 & \" + \" & I25 & \" =\"","v":"∴ Total area of the Main Road (Including common areas) = 015 + 3 ="},{"$nulls":6},{"$f":"I24+I25","v":18},"sqm"]
[null,{"$f":"\"Assuming Percolation losses for the Road @ \" & 100*Percolation_Road & \"%, Effective Area = \n(1-\" &Percolation_Road&\") x \"&I26& \" \"","v":"Assuming Percolation losses for the Road @ 40%, Effective Area = \n(1-0.4) x 18 "},{"$nulls":6},{"$f":"ROUND((1-Percolation_Road)*I26,0)","v":11},"sqm"]
[null,{"$f":"\"Total Effective Area of the Main Road in Ha = Effective Area (sqm)/10000 = \n\" & I27 & \"/10000 = \"","v":"Total Effective Area of the Main Road in Ha = Effective Area (sqm)/10000 = \n11/10000 = "},{"$nulls":6},{"$f":"I27/10000","v":1.1000000000000001E-3},"Ha"]
[null,"∴ RainfallDischarge for the Main Road = RAP/36 = ",{"$nulls":6},{"$f":"ROUND(Rainfall*I28*Impervious_Factor/36,7)","v":0},"cum/sec"]
[null,"Where"]
[null,"R = Rainfall Intensity ",{"$nulls":6},{"$f":"Rainfall","v":0},"cm/hour"]
[null,"A = Effective Area of Internal Road (considering percolation losses) in Ha as above"]
[null,"P = Impervious Factor = ",{"$nulls":6},{"$f":"Impervious_Factor","v":0.8}]
["IV. Total Discharge the Main Road"]
[null,{"$f":"\"Total Discharge for the Main Road = Total Discharge from the Internal Roads + Rainfall Discharge from the Main Road (including common areas) = \n\" &Discharge_IR & \" + \" &I29 & \" =\"","v":"Total Discharge for the Main Road = Total Discharge from the Internal Roads + Rainfall Discharge from the Main Road (including common areas) = \n0 + 0 ="},{"$nulls":6},{"$f":"Discharge_IR+I29","v":0},"cum/sec"]

{"sheet":"Drain-Cross Sections","index":6,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,1,31,2],[28,0,28,2],[29,1,29,2],[14,0,14,2],[15,1,15,2],[17,1,17,2],[0,0,0,2],[1,1,1,2],[2,1,2,2],[5,0,5,2],[6,0,6,2],[12,0,12,2]]}
["Design of Cross Section of Trapezoidal Side Drain for the Main Road on Two Sides of the Road"]
["Shape of the Drain","Trapezoidal"]
["Drain is Considered on One Side/Two Sides","Two Sides"]
["I. Total Discharge from the Main Road =",{"$f":"Discharge_MR","v":0},"cum/sec"]
[{"$f":"\"Since Drains are considered on \" & B3 & \" of the road, design discharge = \" & B4 & IF(B3=\"One Side\",\"\",\"/2\")","v":"Since Drains are considered on Two Sides of the road, design discharge = 0/2"},{"$f":"ROUND(B4/IF(B3=\"One Side\",1,2),3)","v":0},"cum/sec"]
["II. Cross Sectional Area of the Drain "]
["Cross Sectional Area of the Side Drain = Discharge/Self Cleaning Velocity = Q/V"]
[{"$f":"\"= \" &B5& \" / \" & Self_Cleaning_Velocity","v":"= 0 / 1"},{"$f":"B5/Self_Cleaning_Velocity","v":0},"sqm"]
["Assume Bottom Width of the Drain = ",null,"mm"]
["Assuem Depth of the Drain",null,"mm"]
["∴ Top Width of the Drain (Rounded to nearest 100 mm) = ",{"$f":"IFERROR(CEILING((2*B8*1000*1000/B10)-B9,100),\"\")","v":""},"mm"]
[]
["Design of Cross Section of Semi-Crcular Drains for Internal Roads"]
[]
["12 Houses/Side - Internal Roads"]
["Shape of the Drain","Semi-Circular"]
["Drain is Considered on One Side/Two Sides","One Side","Two Sides"]
["I. Total Discharge from a 12-houses/Side Internal Road =",{"$f":"Discharge_12_IR","v":6.6720000000000006E-4}]
[{"$f":"\"Since Drains are considered on \" & B17 & \" of the road, design discharge = \" & B18 & IF(B17=\"One Side\",\"\",\"/2\")","v":"Since Drains are considered on One Side of the road, design discharge = 0.0006672"},{"$f":"ROUND($B$18/IF(B17=\"One Side\",1,2),7)","v":6.6719999999999995E-4},{"$f":"ROUND($B$18/IF(C17=\"One Side\",1,2),7)","v":3.3359999999999998E-4}]
["II. Cross Sectional Area of the Drain "]
["Cross Sectional Area of the Side Drain = Discharge/Self Cleaning Velocity = Q/V"]
[{"$f":"\"= \" &B19& \" / \" & Self_Cleaning_Velocity","v":"= 0.0006672 / 1"},{"$f":"B19/Self_Cleaning_Velocity","v":6.6719999999999995E-4},{"$f":"C19/Self_Cleaning_Velocity","v":3.3359999999999998E-4}]
["Since shape of the drain is Semi-Circular, Cross Sectional Area = "]
["∴ r2 = 2 x Cross Sectional Area/π"]
[{"$f":"\"∴ Radius of Semi-Circular Drain r = Sqrt (2 x Cross Sectional Area/π) = SQRT(2 x \" & B22 & \"/ π)\"","v":"∴ Radius of Semi-Circular Drain r = Sqrt (2 x Cross Sectional Area/π) = SQRT(2 x 0.0006672/ π)"},{"$f":"ROUND(SQRT(2*B22/PI()),3)","v":2.1000000000000001E-2},{"$f":"ROUND(SQRT(2*C22/PI()),3)","v":1.4999999999999999E-2}]
["Or Say Radius = ",{"$f":"CEILING(B25*1000,50)","v":50},{"$f":"CEILING(C25*1000,50)","v":50}]
["∴ Diameter of the Semi-Circular Drain = ",{"$f":"B26*2","v":100},{"$f":"C26*2","v":100}]
[]
["8 Houses/Side - Internal Roads"]
["Shape of the Drain","Semi-Circular"]
["Drain is Considered on One Side/Two Sides","One Side","Two Sides"]
["I. Total Discharge from a 12-houses/Side Internal Road =",{"$f":"Discharge_8_IR","v":4.4480000000000002E-4}]
[{"$f":"\"Since Drains are considered on \" & B31 & \" of the road, design discharge = \" & B32 & IF(B31=\"One Side\",\"\",\"/2\")","v":"Since Drains are considered on One Side of the road, design discharge = 0.0004448"},{"$f":"ROUND($B$32/IF(B31=\"One Side\",1,2),7)","v":4.4480000000000002E-4},{"$f":"ROUND($B$32/IF(C31=\"One Side\",1,2),7)","v":2.2240000000000001E-4}]
["II. Cross Sectional Area of the Drain "]
["Cross Sectional Area of the Side Drain = Discharge/Self Cleaning Velocity = Q/V"]
[{"$f":"\"= \" &B33& \" / \" & Self_Cleaning_Velocity","v":"= 0.0004448 / 1"},{"$f":"B33/Self_Cleaning_Velocity","v":4.4480000000000002E-4},{"$f":"C33/Self_Cleaning_Velocity","v":2.2240000000000001E-4}]
["Since shape of the drain is Semi-Circular, Cross Sectional Area = "]
["∴ r2 = 2 x Cross Sectional Area/π"]
[{"$f":"\"∴ Radius of Semi-Circular Drain r = Sqrt (2 x Cross Sectional Area/π) = SQRT(2 x \" & B36 & \"/ π)\"","v":"∴ Radius of Semi-Circular Drain r = Sqrt (2 x Cross Sectional Area/π) = SQRT(2 x 0.0004448/ π)"},{"$f":"ROUND(SQRT(2*B36/PI()),3)","v":1.7000000000000001E-2},{"$f":"ROUND(SQRT(2*C36/PI()),3)","v":1.2E-2}]
["Or Say Radius = ",{"$f":"CEILING(B39*1000,50)","v":50},{"$f":"CEILING(C39*1000,50)","v":50}]
["∴ Diameter of the Semi-Circular Drain = ",{"$f":"B40*2","v":100},{"$f":"C40*2","v":100}]

{"sheet":"CS_Main Road","index":7,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,0,0,2],[1,1,1,2],[2,1,2,2],[5,0,5,2],[6,0,6,2]]}
["Design of Cross Section of Trapezoidal Side Drain for the Main Road on Two Sides of the Road"]
["Shape of the Drain","Trapezoidal"]
["Drain is Considered on One Side/Two Sides","Two Sides"]
["I. Total Discharge from the Main Road =",{"$f":"Discharge_MR","v":0},"cum/sec"]
[{"$f":"\"Since Drains are considered on \" & B3 & \" of the road, design discharge = \" & B4 & IF(B3=\"One Side\",\"\",\"/2\")","v":"Since Drains are considered on Two Sides of the road, design discharge = 0/2"},{"$f":"ROUND(B4/IF(B3=\"One Side\",1,2),3)","v":0},"cum/sec"]
["II. Cross Sectional Area of the Drain "]
["Cross Sectional Area of the Side Drain = Discharge/Self Cleaning Velocity = Q/V"]
[{"$f":"\"= \" &B5& \" / \" & Self_Cleaning_Velocity","v":"= 0 / 1"},{"$f":"B5/Self_Cleaning_Velocity","v":0},"sqm"]
["Assume Bottom Width of the Drain = ",200,"mm"]
["Assuem Depth of the Drain",450,"mm"]
["∴ Top Width of the Drain = ",{"$f":"CEILING((2*B8*1000*1000)/(B9+B10),50)","v":0},"mm"]