Spreadsheet: 13cfa4c0-80f1-4335-85e0-05af47436262
Sheet: Sheet1

Table: Calculatios of Runoff, drainage flows and evacuation through existing drainage network
Place | Total  Rain | Gross rainfall volumes | Runoff (feet) | Runoff   (MAF) | Drainage flows LBOD System (cfs) | Draiange coefficient (cfs/sq.mi) | Evacuation Period (Days) | Comments
5 years return period
[NAME] | 132 | 0.3320736503906249 | 0.1792140328777433 | 0.1629426531906744 | 4351.477363182993 | 3.063048912334722 | 6
Nawabshah | 90 | 0.155888671875 | 0.08858096140747951 | 0.05545168184108217 | 2437.10573881136 | 2.491609701021198 | 4
Mirpur Khas Area | 112 | 0.1165208333333333 | 0.1215029484177536 | 0.04568510860507535 | 2123.445845161918 | 3.614375906658583 | 4
[NAME] | 112 | 0.1313958333333333 | 0.1341631054728951 | 0.05688515672050753 | 2570.069799796226 | 3.879350641201851 | 4
 |  | 0.7358789889322914 |  | 0.3209646003573394 | 11482.0987469525
10 years return period
[NAME] | 170 | 0.4276706103515625 | 0.2770220516428551 | 0.2518703885080453 | 4472.924107444082 | 3.148536503529134 | 9
Nawabshah | 120 | 0.2078515625 | 0.156023145517042 | 0.09767048909366831 | 3322.887929552201 | 3.397201717114071 | 5
Mirpur Khas Area | 140 | 0.1456510416666666 | 0.186257933530171 | 0.07003298300734428 | 1882.163239180008 | 3.203682109242567 | 7
[NAME] | 140 | 0.1642447916666666 | 0.2019482560905352 | 0.08562606058238692 | 2238.134984672504 | 3.378316957996232 | 7
 |  | 0.9454180061848957 |  | 0.5051999211914449 | 11916.1102608488
25 YEARS
[NAME] | 213.5 | 0.5371039724121093 | 0.3901906653129372 | 0.3547640842371796 | 4833.530299818363 | 3.402370848314798 | 11
Nawabshah | 154.4 | 0.2674356770833333 | 0.2429127955240608 | 0.152063409998062 | 3046.523849627597 | 3.114656970865275 | 8
Mirpur Khas Area | 171.4 | 0.1783184895833333 | 0.2692831425080459 | 0.1012504615830252 | 1775.468662318984 | 3.022074318840824 | 10
[NAME] | 171.4 | 0.2010825520833333 | 0.2879525036283394 | 0.1220918615384159 | 2093.750103605687 | 3.160377514876509 | 10
 | 177.675 | 1.183940691162109 |  | 0.7301698173566828 | 11749.27291537063
ACTUAL 2011
[NAME] | 615 | 1.547161325683593 | 1.638314889793188 | 1.489567366004195 | 3729.122960951004 | 2.624967356178123 | 70
Nawabshah | 836 | 1.448032552083333 | 2.364581320183245 | 1.480227906434711 | 3634.55030742284 | 3.715834180112808 | 65
Mirpur Khas Area | 866 | 0.9009557291666666 | 2.415883396609988 | 0.9083721571253555 | 2113.841930308675 | 3.598028817546681 | 75
[NAME] | 615 | 0.7215039062499997 | 1.64451947245454 | 0.6972762563207252 | 2383.520269220744 | 3.597766444106783 | 50
 |  | 4.617653513183592 |  | 4.575443685884987 | 11861.03546790326
[NAME] | 200 | 0.5031418945312499 | 0.3592333571260377 | 0.3266174829324934 | 4458.443347944313 | 3.138343350506937 | 11
Nawabshah | 200 | 0.3464192708333332 | 0.3677549033767891 | 0.23021456951387 | 3346.513788177765 | 3.421355949574712 | 11
Mirpur Khas Area | 200 | 0.2080729166666666 | 0.3422591155399475 | 0.1286894274430203 | 1877.508325386454 | 3.195758851721624 | 12
[NAME] | 200 | 0.2346354166666666 | 0.363017956254672 | 0.153919613451981 | 2196.793402821995 | 3.31591457029735 | 12
 | 200 | 1.292269498697916 | 0.3580515855316689 | 0.8394410933413646 | 11879.25886433053
[NAME] | 300 | 0.7547128417968749 | 0.6513442173350134 | 0.5922067218105155 | 4446.399324991862 | 3.129865440977458 | 20
Nawabshah | 300 | 0.5196289062499999 | 0.662068103439475 | 0.4144546327531113 | 3314.359605270046 | 3.388482663534872 | 20
Mirpur Khas Area | 300 | 0.312109375 | 0.6297339363712341 | 0.236779960075584 | 1971.379751318584 | 3.355540002244398 | 21
[NAME] | 300 | 0.3519531249999999 | 0.6561170830174129 | 0.2781936431993831 | 2266.999199285869 | 3.421885583827726 | 21
 |  | 1.938404248046875 |  | 1.521634957838594 | 11999.13788086636
[NAME] | 700 | 1.760996630859375 | 1.911002734719213 | 1.737497063425851 | 4811.460534369524 | 3.386835717275049 | 75
Nawabshah | 700 | 1.212467447916667 | 1.925358177756724 | 1.205274219275709 | 3336.881636188545 | 3.411508382045796 | 75
Mirpur Khas Area | 700 | 0.7282552083333332 | 1.881601613913734 | 0.7074822068315639 | 1960.078648758816 | 3.336304082993729 | 75
[NAME] | 700 | 0.8212239583333333 | 1.917410801905896 | 0.8129821800081001 | 2251.075125902921 | 3.397849246645919 | 75
 |  | 4.522943245442708 |  | 4.463235669541225 | 12359.49594521981
[NAME] | 800 | 2.012567578125 | 2.233326253259924 | 2.030555862747695 | 4956.931831563759 | 3.489234434183641 | 85
Nawabshah | 800 | 1.385677083333333 | 2.248107870088817 | 1.407315526675599 | 3434.833364553283 | 3.511650724143931 | 85
Mirpur Khas Area | 800 | 0.8322916666666664 | 2.202999646269717 | 0.8283278669974138 | 2022.905967649816 | 3.443244200255007 | 85
[NAME] | 800 | 0.9385416666666665 | 2.23992663681147 | 0.9497288940080634 | 2318.249084788966 | 3.499243901568251 | 85
 |  | 5.169077994791666 |  | 5.215928150428772 | 12732.92024855582
[NAME] | 900 | 2.264138525390624 | 2.556814969782473 | 2.324674068231013 | 4827.596117444135 | 3.398193717342966 | 100
Nawabshah | 900 | 1.55888671875 | 2.571940638811317 | 1.610034839895884 | 3342.929063234409 | 3.417691055063933 | 100
Mirpur Khas Area | 900 | 0.9363281249999997 | 2.525739559910063 | 0.9496780745261839 | 1972.905366618699 | 3.358136794244593 | 100
[NAME] | 900 | 1.055859375 | 2.563570672544015 | 1.086953965158662 | 2257.072558224899 | 3.406901974679093 | 100
 |  | 5.815212744140624 |  | 5.971340947811743 | 12400.50310552214