exemple1.xls

Débit

N N QU1-1 1 50

3 120

U1 1 505 60

15 20060 25077 300

U1-1

Titre : U1-1N° piquet Dist.Part (m) Dist.Cum (m) Cote TN Cote Rad.Am Cote Rad.Av Cotes tampons

1 238.05 236.14 236.14 237.942 39.97 39.97 237.56 235.72 235.72 237.523 32.11 72.08 237.85 235.52 235.52 237.754 7.86 79.93 237.92 235.46 235.46 237.95 24.26 104.19 238.35 235.31 235.31 238.35

U1-1

N° regards Diamètre (m) Type de canalisation Pentes Commentaire Cote Rad Diam.Arr7172 0.3 -0.01173 0.3 -0.007

0.4 -0.0078 0.4 -0.007 Int U1

U1-1

Débit (l/s) N° Piquet X Y Z Angle (grd)371692.47 356496.72

50 371701.06 356457.6950 b 371707.97 356426.31

120 371709.66 356418.66120 371714.88 356394.97

U1

Titre : U1N° piquet Dist.Part (m) Dist.Cum (m) Cote TN Cote Rad.Am Cote Rad.Av Cotes tampons

1 0 0 240.46 238.6 238.6 240.42 40 40 239.98 238.07 238.07 239.873 40 80.01 239.42 237.54 237.54 239.354 40.01 120.02 238.96 237.02 237.02 238.815 31.41 151.43 238.3 236.45 236.45 238.276 8.59 160.02 238.12 236.3 236.3 238.117 22.82 182.84 237.69 235.89 235.89 237.698 34.04 216.89 238.3 235.58 235.58 238.349 5.95 222.84 238.4 235.53 235.53 238.44

10 28.09 250.93 238.35 235.28 235.28 238.3511 40 290.93 238.38 235 235 238.5412 39.97 330.89 238.72 234.72 234.72 238.7213 40 370.89 238.51 234.44 234.44 238.4514 36.83 407.72 238.45 234.18 234.18 238.4515 40.03 447.75 237.31 233.9 233.9 237.5816 40 487.74 237.27 233.62 233.62 237.1817 40.03 527.77 237.16 233.34 233.34 237.0518 8 535.77 237.25 233.28 233.28 237.1319 39.94 575.7 237.42 233.14 233.14 237.5320 39.97 615.67 237.84 233 233 237.9221 29.2 644.87 237.8 232.9 232.9 237.8122 10.74 655.61 237.79 232.86 232.86 237.6723 18.46 674.07 237.31 232.8 232.8 237.424 29 703.07 237.22 232.7 232.7 237.2325 40 743.07 234.93 232.18 232.18 235.0526 40.03 783.09 234.15 231.66 231.66 233.8427 40 823.09 233.93 231.14 231.14 233.6428 40.03 863.12 233.96 230.62 230.62 233.5129 4.35 867.47 233.98 230.56 230.56 233.5330 39.97 907.44 234.04 230.44 230.44 233.6231 34.24 941.67 233.92 230.34 230.34 233.7532 5.73 947.4 233.9 230.32 230.32 233.7833 28.51 975.91 233.99 230.24 230.24 233.8834 40.03 1015.94 234.03 230.12 230.12 233.7735 29.97 1045.9 234.06 230.03 230.03 233.6936 10.03 1055.93 234.07 230 230 233.6637 19.93 1075.87 233.92 229.94 229.94 233.8338 40 1115.87 234.12 229.8 229.8 233.8239 39.97 1155.83 234.17 229.66 229.66 233.9440 34.75 1190.58 234.21 229.55 229.55 234.0441 5.25 1195.83 234.22 229.53 229.53 234.0642 29.5 1225.33 234.15 229.43 229.43 234.1543 40.03 1265.36 234.44 229.29 229.29 234.3944 8.86 1274.23 234.47 229.26 229.26 234.4745 29.26 1303.49 235.13 229.16 229.16 235.0846 10.77 1314.26 235.38 229.12 229.12 235.3247 18.49 1332.75 235.64 229.06 229.06 235.6348 39.97 1372.72 235.34 228.93 228.93 235.4849 4.93 1377.64 235.28 228.91 228.91 235.4550 20.09 1397.74 235.12 228.84 228.84 235.3351 19.93 1417.67 234.97 228.77 228.77 235.252 5.09 1422.76 234.95 228.76 228.76 235.17

U1

53 40.03 1462.79 234.78 228.62 228.62 234.8754 2.62 1465.41 234.74 228.61 228.61 234.8355 40 1505.41 233.89 228.49 228.49 233.856 40 1545.4 232.34 228.37 228.37 232.7357 39.97 1585.37 231.76 228.25 228.25 231.7758 40 1625.37 231.62 228.13 228.13 231.659 7.55 1632.92 231.63 228.11 228.11 231.5860 27.53 1660.45 231.61 228.03 228.03 231.5161 12.43 1672.88 231.6 227.99 227.99 231.4762 15.1 1687.99 231.59 227.94 227.94 231.4663 40 1727.99 231.7 227.82 227.82 231.6364 30.04 1758.03 231.85 227.73 227.73 231.9265 29.55 1787.57 232.13 227.64 227.64 232.2266 10.43 1798 232.23 227.61 227.61 232.3167 19.11 1817.12 232.47 227.56 227.56 232.4868 28.38 1845.5 232.53 227.47 227.47 232.4569 17.11 1862.6 232.32 227.42 227.42 232.3670 27.8 1890.4 232.18 227.34 227.34 232.2271 10.54 1900.94 232.13 227.3 227.3 232.1772 17.26 1918.2 232.1 227.25 227.25 232.173 39.98 1958.18 232.11 227.13 227.13 232.1174 40 1998.18 232.04 227.01 227.01 232.0475 39.98 2038.16 231.9 226.89 226.89 231.976 3.41 2041.57 231.91 226.88 226.88 231.9177 38.31 2079.88 231.84 226.77 226.77 231.8478 39.99 2119.87 231.96 226.65 226.65 231.9679 39.99 2159.87 231.99 226.53 226.53 231.9980 37.93 2197.8 232.01 226.41 226.41 232.0181 20 2217.8 232.5 226.35 226.35 232.582 19.99 2237.79 232.36 226.29 226.29 232.3683 20 2257.79 232.22 226.23 226.23 232.2284 19.99 2277.78 232.07 226.17 226.17 232.0785 20 2297.79 231.8 226.11 226.11 231.886 19.99 2317.78 231.52 226.05 226.05 231.5287 20 2337.78 231.43 225.99 225.99 231.4388 19.99 2357.77 231.38 225.93 225.93 231.3889 20 2377.77 231.33 225.87 225.87 231.3390 5.95 2383.72 231.32 225.86 225.86 231.3291 19.93 2403.65 230.78 225.8 225.8 230.7892 19.93 2423.58 230.01 225.74 225.74 230.0193 19.93 2443.5 229.24 225.68 225.68 229.2494 19.93 2463.43 228.47 225.62 225.62 228.4795 19.96 2483.39 227.8 225.56 225.56 227.896 19.93 2503.31 227.71 225.5 225.5 227.7197 19.96 2523.27 227.19 225.44 225.44 227.1998 9.37 2532.64 226.91 225.41 225.41 226.91

U1

N° regards Diamètre (m) Type de canalisation Pentes Commentaire Cote Rad Diam.Arr12 0.3 -0.0133 0.3 -0.0134 0.3 -0.0135 0.3 -0.018

0.3 -0.0186 0.3 -0.0187 0.3 -0.009

0.3 -0.0098 0.3 -0.009 Int U1-1 235.31 0.59 0.3 -0.007

10 0.3 -0.007 Int U1-2 234.81 0.411 0.3 -0.00712 0.3 -0.00713 0.3 -0.00714 0.5 -0.007

0.5 -0.00715 0.5 -0.007 Int U1-3 & Int U 235.16 0.316 0.5 -0.00417 0.5 -0.00418 0.5 -0.004

0.5 -0.00419 0.5 -0.004 Int U1-5 235.14 0.520 0.5 -0.004 Int U1-6 234.41 0.521 0.5 -0.01322 0.5 -0.01323 0.5 -0.013

0.5 -0.01324 0.5 -0.013 Int U1-7 & Int U 230.56 0.425 0.6 -0.00326 0.6 -0.003

0.6 -0.00327 0.6 -0.003 Int U1-10 & Int 230.65 0.628 0.6 -0.00329 0.6 -0.003

0.6 -0.00330 0.6 -0.003 Int U1-12 & Int 230.43 0.631 0.6 -0.00332 0.6 -0.00333 0.6 -0.003

0.6 -0.00334 0.6 -0.003 Int U1-14 231.41 0.4

0.6 -0.00335 0.6 -0.003 Int U1-15 & Int 230.99 0.436 0.6 -0.003

0.6 -0.00337 0.6 -0.003 Int U1-17 233.33 0.4

0.6 -0.00338 0.6 -0.003 Int U1-26 232.33 0.3

0.6 -0.0030.6 -0.003

39 0.6 -0.003 Int U1-18 & Int 232.13 0.3

U1

0.6 -0.00340 0.6 -0.003 Int U1-20 228.74 0.541 0.6 -0.00342 0.6 -0.00343 0.6 -0.003

0.6 -0.00344 0.6 -0.003 Int U1-21 & Int 228.74 0.345 0.6 -0.003

0.6 -0.00346 0.6 -0.00347 0.6 -0.00348 0.6 -0.003 Int U1-23 & Int 228.58 0.449 0.6 -0.003

0.6 -0.00350 0.6 -0.00351 0.6 -0.00352 0.6 -0.003 Int U1-25 228.81 0.6

0.6 -0.00353 0.6 -0.003 Déversoir d'orage54 0.6 -0.003 Fin d'étranglement55 0.6 -0.00356 0.6 -0.003

0.6 -0.00357 0.6 -0.00358 0.6 -0.00359 0.6 -0.00360 0.6 -0.00361 0.6 -0.003

0.6 -0.00362 0.6 -0.003

0.6 -0.00363 0.6 -0.003

0.6 -0.00364 0.6 -0.003

0.6 -0.00365 0.6 -0.003

0.6 -0.00366 0.6 -0.003

0.6 -0.00367 0.6 -0.003

0.6 -0.00368 0.6 -0.003

0.6 -0.00369 0.6 -0.00370 0.6 -0.003

R 0.6 -0.003 Réseau existant

U1

Débit (l/s) N° Piquet X Y Z Angle (grd)371908.03 356367.94

50 371868.97 356359.31 050 371829.91 356350.69 050 371790.84 356342.03 050 b 371760.16 356335.25 060 371751.78 356333.41 060 371729.5 356328.47 99.8983840960 b 371722.19 356361.72 060 371720.91 356367.53 060 371714.88 356394.97 100.011070360 371753.94 356403.56 060 371792.97 356412.16 060 371832.03 356420.75 060 371868 356428.66 -99.9990768460 371859.41 356467.75 0

200 371850.81 356506.81 0200 371842.22 356545.91 0200 371840.5 356553.72 0200 371831.91 356592.72 0200 371823.31 356631.75 0200 b 371817.03 356660.25 0200 371814.72 356670.75 0200 371810.75 356688.78 99.12405396200 371839.16 356694.63 -99.13036346200 371830.56 356733.69 0200 371821.97 356772.78 0200 371813.38 356811.84 0200 371804.78 356850.94 0200 371803.84 356855.19 0200 371795.25 356894.22 0200 b 371787.88 356927.72 0200 371786.66 356933.25 0200 371780.53 356961.09 0200 371771.94 357000.19 0200 b 371765.5 357029.44 0200 371763.34 357039.25 0200 371759.06 357058.72 0200 371750.47 357097.78 0200 371741.88 357136.81 0200 b 371734.41 357170.75 0200 371733.28 357175.88 0200 371726.94 357204.69 0200 371718.31 357243.78 0200 371716.41 357252.44 0200 b 371710.13 357281 0200 371707.81 357291.53 0200 371703.84 357309.59 0200 371695.25 357348.63 0200 371694.19 357353.44 0200 b 371689.88 357373.06 0200 371685.59 357392.53 0200 371684.5 357397.5 0

U1

200 371675.91 357436.59 0200 371675.34 357439.16 0200 371666.75 357478.22 0200 371658.16 357517.28 0200 371649.56 357556.31 0200 371640.97 357595.38 0200 371639.34 357602.75 0200 b 371633.44 357629.56 0250 371630.75 357641.78 0250 371627.5 357656.53 -166.9027405250 371600.63 357686.16 0250 371580.44 357708.41 0250 b 371560.56 357730.28 0250 371553.56 357738 0250 371540.72 357752.16 -193.1381226250 371519.5 357771 192.6925812250 371508.09 357783.75 0250 b 371489.59 357804.47 0250 371482.56 357812.34 0250 371471.06 357825.22 -93.27960968250 371444.22 357795.59 0250 371417.38 357765.94 0250 371390.53 357736.31 0250 371388.25 357733.78 171.7971039250 371352.88 357719.06 194.9259949300 371314.84 357706.69 0300 371276.81 357694.31 0300 371240.75 357682.56 -192.4357452300 371220.78 357673.31 192.520752300 371201.78 357667.09 0300 371182.78 357660.84 0300 371163.78 357654.63 0300 371144.78 357648.38 0300 371125.78 357642.16 0300 371106.78 357635.91 0300 371087.78 357629.69 0300 371068.78 357623.44 0300 371063.13 357621.59 93.62237549300 371058.88 357641.06 0300 371054.63 357660.53 0300 371050.38 357680 0300 371046.13 357699.47 0300 371041.88 357718.97 0300 371037.63 357738.44 0300 371033.38 357757.94 0300 371031.38 357767.09

exemple1.xls

Documents