P-III曲线水文频率计算Excel程序

图1-3：通州区(1956-2000)年降水量频率曲线图

F(0.6)F(0.7)F(0.8)F(0.9)F(1.0)F(1.1)F(1.2)F(1.3)F(1.4)F(1.5)

3.96

4.1 4.24 4.39 4.53 4.67 4.81 4.95

5.09 5.23

3.6 3.72 3.85 3.97

4.09 4.2 4.32 4.44 4.56 4.68

3.35 3.45 3.55 3.65 3.76 3.86 3.95

4.05 4.15 4.24

3.13 3.22 3.31 3.4 3.49 3.58 3.66 3.74 3.83 3.91

2.75 2.82 2.89 2.96

3.02 3.09 3.15 3.21 3.27 3.33

2.35 2.4 2.45 2.5 2.54 2.58 2.62 2.67 2.71 2.74

2.12 2.15 2.18 2.22 2.25 2.28 2.31 2.34 2.37 2.39

1.8 1.82 1.84 1.86 1.88 1.89 1.91 1.92 1.94 1.95

1.33 1.33 1.34 1.34 1.34 1.34 1.34 1.34 1.33 1.33

0.80.790.780.770.760.740.730.720.710.69

0.610.590.580.570.550.540.520.510.490.47

0.440.430.410.40.380.360.350.330.310.3

0.160.140.120.110.090.070.050.040.020

-0.1-0.12-0.13-0.15-0.16-0.18-0.19-0.21-0.22-0.24 -0.34-0.36-0.37-0.38-0.39-0.41-0.42-0.43-0.44-0.45 -0.59-0.6-0.6-0.61-0.62-0.62-0.63-0.63-0.64-0.64 -0.72-0.72-0.73-0.73-0.73-0.74-0.74-0.74-0.73-0.73 -0.85-0.85-0.85-0.85-0.85-0.84-0.84-0.83-0.82-0.82 -1.02-1.01-1-0.99-0.98-0.97-0.96-0.95-0.93-0.92 -1.2-1.18-1.17-1.15-1.13-1.1-1.08-1.06-1.04-1.02 -1.45-1.42-1.38-1.35-1.32-1.28-1.24-1.2-1.17-1.13 -1.61-1.57-1.52-1.47-1.42-1.38-1.33-1.28-1.23-1.19 -1.88-1.81-1.74-1.66-1.59-1.52-1.45-1.38-1.32-1.26 -2.27-2.14-2.02-1.9-1.79-1.68-1.58-1.48-1.39-1.31

0.60.70.80.91 1.1 1.2 1.3 1.4 1.5

F(1.6)F(1.7)F(1.8)F(1.9)F(2.0)F(2.1)F(2.2)F(2.3)F(2.4)F(2.5)

5.37 5.5 5.64 5.77 5.91

6.04 6.17 6.3 6.42 6.55

4.8 4.91

5.01 5.12 5.22 5.33 5.43 5.53 5.63 5.73

4.34 4.43 4.52 4.61 4.7 4.79 4.88 4.97

5.05 5.13

3.99

4.07 4.15 4.23 4.3 4.37 4.44 4.51 4.58 4.65

3.39 3.44 3.5 3.55 3.61 3.66 3.71 3.76 3.81 3.85

2.78 2.82 2.85 2.88 2.91 2.93 2.96 2.99

3.02 3.04

2.42 2.44 2.46 2.49 2.51 2.53 2.55 2.56 2.57 2.59

1.96 1.97 1.98 1.992222

2.01 2.01

1.33 1.32 1.32 1.31 1.3 1.29 1.28 1.27 1.26 1.25

0.680.660.640.630.610.590.570.550.540.52

0.460.440.420.40.390.370.350.330.310.29

0.280.260.240.220.20.190.170.150.130.11

-0.02-0.03-0.05-0.07-0.08-0.1-0.11-0.13-0.15-0.16 -0.25-0.27-0.28-0.29-0.31-0.32-0.33-0.34-0.35-0.36 -0.46-0.47-0.48-0.48-0.49-0.49-0.5-0.5-0.51-0.51 -0.64-0.64-0.64-0.64-0.64-0.64-0.64-0.64-0.63-0.63 -0.73-0.72-0.72-0.72-0.71-0.71-0.7-0.69-0.68-0.67 -0.81-0.81-0.8-0.79-0.78-0.76-0.75-0.74-0.72-0.71 -0.9-0.89-0.87-0.85-0.84-0.82-0.8-0.78-0.77-0.75 -0.99-0.97-0.94-0.92-0.895-0.869-0.844-0.82-0.795-0.772 -1.1-1.06-1.02-0.98-0.949-0.914-0.879-0.849-0.82-0.791 -1.14-1.1-1.06-1.01-0.97-0.935-0.9-0.865-0.83-0.8 -1.2-1.14-1.09-1.04-0.989-0.945-0.905-0.867-0.831-0.8 -1.24-1.17-1.11-1.05-0.999-0.952-0.909-0.87-0.833-0.8

1.6 1.7 1.8 1.92

2.1 2.2 2.3 2.4 2.5