qwqe.xlsx

Label Elevation (m) Diameter (Valve) (mm) Minor Loss Coefficient (Local)PRV-1 3135.34 42 0PRV-2 3194.34 42 0PRV-3 3080.89 42 0PRV-4 3126.05 42 0PRV-6 3183.45 42 0PRV-7 3176.3 42 0PRV-8 3046.62 42 0PRV-9 3039.96 42 0PRV-10 3094.31 42 0PRV-12 3003.47 42 0PRV-14 3132.56 42 0PRV-16 3028.38 42 0PRV-17 2988.46 42 0PRV-18 3043.76 42 0PRV-19 3030.35 42 0PRV-20 2947.11 42 0PRV-21 2905.73 42 0PRV-22 2834.31 42 0PRV-23 2905.74 42 0PRV-24 2786.77 42 0PRV-26 3003.84 42 0PRV-27 2976.28 42 0PRV-28 2959.18 42 0PRV-29 2743.7 42 0PRV-30 2859.25 42 0PRV-31 2798.41 42 0PRV-32 2945.83 42 0PRV-33 2919.4 42 0PRV-34 2884.56 42 0PRV-35 3036.91 42 0PRV-36 3049.6 42 0PRV-37 2962.25 42 0PRV-38 3182.78 42 0PRV-39 3077.19 42 0PRV-41 3081.82 42 0PRV-42 3143.64 42 0PRV-43 2870.83 42 0PRV-45 3044.76 42 0PRV-46 2783.63 152.4 0PRV-49 3275.02 152.4 0PRV-50 3195.52 152.4 0PRV-51 3138.67 152.4 0PRV-52 3042.67 152.4 0

Hydraulic Grade Setting (Initial) (m) Pressure Setting (Initial) (m H2O) Flow (L/s)0 0 0.0650 0 0.0780 0 0.0390 0 0.2470 0 2.9430 0 2.1120 0 0.1170 0 0.0910 0 2.3440 0 0.0650 0 1.8130 0 0.0390 0 2.1490 0 0.5610 0 0.690 0 1.6150 0 0.9640 0 0.8330 0 0.4420 0 0.690 0 0.4820 0 0.5330 0 0.520 0 0.0910 0 0.3650 0 0.2730 0 0.1430 0 0.5080 0 0.1950 0 0.0650 0 0.0130 0 0.1560 0 0.2480 0 0.0530 0 1.4870 0 2.6180 0 0.9120 0 2.1620 0 0.130 0 1.20 0 0.20 0 0.20 0 0.066

Hydraulic Grade (From) (m) Hydraulic Grade (To) (m) Headloss (m)3194.23 3135.34 58.893247.07 3194.34 52.723135.29 3080.89 54.43181.31 3126.05 55.263214.21 3183.45 30.763215.51 3176.3 39.213086.15 3046.62 39.543086.09 3039.96 46.133141.13 3094.31 46.823042.55 3003.47 39.073173.79 3132.56 41.233077.11 3028.38 48.733043.17 2988.46 54.723079.17 3043.76 35.413077.62 3030.35 47.272986.38 2947.11 39.272937.22 2905.73 31.492866.39 2834.31 32.08

2941.4 2905.74 35.662829.59 2786.77 42.813041.13 3003.84 37.293025.26 2976.28 48.982987.06 2959.18 27.872781.52 2743.7 37.822903.09 2859.25 43.852858.14 2798.41 59.733000.62 2945.83 54.792974.17 2919.4 54.762918.33 2884.56 33.763078.52 3036.91 41.613080.19 3049.6 30.63001.37 2962.25 39.123242.39 3182.78 59.63132.22 3077.19 55.043129.75 3081.82 47.943180.51 3143.64 36.872900.46 2870.83 29.633091.26 3044.76 46.52830.86 2783.63 47.233331.82 3275.02 56.793228.79 3195.52 33.28

3193 3138.67 54.333092.18 3042.67 49.51

Pressure (From) (m H2O) Status (Initial)58.77 Active52.62 Active54.29 Active55.15 Active

30.7 Active39.13 Active39.46 Active46.04 Active46.72 Active

39 Active41.14 Active48.63 Active54.61 Active35.34 Active47.18 Active39.19 Active31.43 Active32.01 Active35.59 Active42.73 Active37.22 Active48.88 Active27.81 Active37.74 Active43.76 Active59.61 Active54.68 Active54.65 Active33.69 Active41.53 Active30.54 Active39.04 Active59.48 Active54.93 Active47.84 Active36.79 Active29.57 Active

46.4 Active47.14 Active56.68 Active33.21 Active54.22 Active49.41 Active