Upload
julio-cesar-cordeiro
View
219
Download
0
Embed Size (px)
Citation preview
7/25/2019 modelo folha de calculo rede ramificada
1/11
PROJETO DE REDE DE ABASTECIMENTO DE GUA
TRECHO RUA
VAZO (l/s)
A JUNSANTE A MONTANTE FICTCIA
3 8 83!"# $!$$ $!33 $!33 $!%# & &8!3" $!$$ $!# $!# $!$&' & &!&" $!$$ $!3 $!3 $!% 3 %"!%" $!$$ $! $! $!$%& %$!'% $!$# $! $!' $!$"8 %!#3 $!$$ $! $! $!$'" % 88!"3 $!' $!% $!3 $!3
$ ' 33!"% $!$8 $!# $!3 $!$ # %$!3& $!$$ $!8 $!8 $!#
& &"!" $!## $!# $!'" $!'3 & '!&' $!"$ $!$" !$$ $!"'& %%! $!'# $! $!%' $!%$8 #!"" !88 $!$# !" !"$" ! $!$ !3 !3$ '"!" $! $! $!3 $!83 &!'3 !#% $!$ !#& !# 8 8! $!$$ $! $! $!
38#!8&
* MA+, !#%$"3&'-. , $!$$&&&$&
PROJETO DE REDE DE ABASTECIMENTO DE GUA
TRECHO RUA
VAZO (l/s)
A JUNSANTE A MONTANTE FICTCIA
# &!& !" $!$# !"& !"'
3 AV! MARGINA &$!%& !8 $! !" !8&' %$!3& $! $!$" $! $!&' " 33!% $!#3 $! $!%# $!'#% $ !&" $!' $! $!& $!& !8# $!$$ $!& $!& $!38 $"!$% $!$8 $!& $!' $!&" ' '3!#% $!$$ $!$8 $!$8 $!$#
E+TENSO(.) EM
MARCHA
E+TENSO(.) EM
MARCHA
AV! MARGINA(ADUTORA)
7/25/2019 modelo folha de calculo rede ramificada
2/11
$ AV! MARGINA 88!3 $!' $!# $!3" $!3 AV! MARGINA 88!" $!%% $!# $!&" $!& AV! MARGINA &%!#% !$% $! !8 ! $ #$!8 $!$$ $! $! $! " #3!% $!$$ $! $! $!
#
* MA+, !"#$%'-., $!$$'#3
7/25/2019 modelo folha de calculo rede ramificada
3/11
RUGOSIDADE0 C , 3$
'$ $!$8 $!$$$8 "8"!38 $!$' "8"!33$'$ $!$# $!$$$$% "8"!$% $!$$' "8"!$'$ $!$% $!$$$# "8"!'8' $!$8 "8"!'%&'$ $!$3 $!$$$$' "8"!%&$ $!$$3 "8"!%%%'$ $!$' $!$$$$ "8"!#& $!$$% "8"!#'$ $!$3 $!$$$$# "8"!## $!$$ "8"!#'$ $! $!$$$' "8"!$% $!$#% "88!"&$'$ $!$ $!$$$#$ "8"!$ $!$'# "8"!#&'$ $!$& $!$$$ "8"!%&% $!$3' "8"!%#
'$ $!% $!$$3# "8"!$ $!8% "8"!$%'$ $!#8 $!$$&8 "8"!'8' $!38# "8"!$'$ $!3$ $!$$3$& "8"!'8' $!$3 "8"!38&' $!#3 $!$$3%# "8"!%&% $!$" "8"!'8'
$$ $!8 $!$$" "8"!%8" $!$3 "8"!%&%'$ $!$" $!$$$3 "8"!%8" $!$" "8"!%&$
$$ $!3 $!$$#' "8"!& $!$ "8"!%8"'$ $!$' $!$$$ "8"!38 $!$' "8"!3%&
RUGOSIDADE0 C , 3$
&' $!## $!$$38$ ""&!& $!$' ""&!'"'
&' $!# $!$$3'3 ""&!'"' $!'$ ""&!3#''$ $!$8 $!$$$" ""&!$$& $!$8 ""%!"8"'$ $!& $!$$'3 ""&!3#' $!338 ""&!$$&'$ $! $!$$$## ""&!# $!$33 ""&!$"'$ $!$& $!$$$$ ""%!8'3 $!$3# ""%!8"'$ $!$8 $!$$$" ""%!&%8 $!$3 ""%!&3&'$ $!$ $!$$$$ ""%!&3& $!$$ ""%!&3'
DIAMETRO(..)
VEOCIDADE(./s)
PERDA DE CARGAUNITRIA (./.)
COTAPIEZOM1TRICA A
MONTANTE
PERDA DECARGA (.2)
COTAPIEZOM1TRICA A
JUNSANTE
DIAMETRO(..)
VEOCIDADE(./s)
PERDA DE CARGAUNITRIA (./.)
COTAPIEZOM1TRICA A
MONTANTE
PERDA DECARGA (.2)
COTAPIEZOM1TRICA A
JUNSANTE
7/25/2019 modelo folha de calculo rede ramificada
4/11
'$ $!% $!$$$"% ""%!8'3 $!$8' ""%!&%8'$ $!3& $!$$##$ ""&!# $!388 ""%!8'3&' $!' $!$$3% ""&!3#' $!$# ""&!#'$ $!$% $!$$$3 ""&!$"" $!$8 ""&!$8'$ $!$% $!$$$# ""&!$$& $!$$ ""%!"8&
7/25/2019 modelo folha de calculo rede ramificada
5/11
FOHA DE CCUO
COTA DE TERRENO (M)
A MONTANTE A JUNSANTE A MONTANTE A JUNSANTE
"&8 "%3 !38 %!33$"&$!' "%3 8!'% %!$"&8!" "83!% $!%8' '!"%&"&&! "%8!3 !'&$ !3%%"% "'&!' 8!#& 3!%#
"'&!' "'% 3!%## 33!#"&$!' "% 8!'% &!"&$"&% "'&!' 3!$ 3!%#&"&" "'% $!%&% 33!%#
"&% "&$!' 3!$ 8!'%"&8!" "&% $!%8' 3!$"&8!" "&8 $!%8' !38"&" "&8!" $!%&% $!%8'
"&"! "&" $!'8" $!%&%"&"! "&&! $!'8" !'&$"&"!' "&"! $!$$ $!'8""&8 "8!# !38 %!"%&
FOHA DE CCUO
COTA DE TERRENO (M)
A MONTANTE A JUNSANTE A MONTANTE A JUNSANTE
"8!' "8!3 '!$$ '!"'
"8!' "8$!' '!$"' %!8#'"&%!' "&' $!'$& !"8""8$!' "&%!' %!8#' $!'$&"&8 "&' "!# !$""&' "%3!' !8'3 33!3"
"&!% "%' #!%8 3!&3&"%' "%3!' 3!&3& 33!3'
PRESSO DISPONIVE(.2)
PRESSO DISPONIVE(.2)
7/25/2019 modelo folha de calculo rede ramificada
6/11
"&' "&!% !8'3 #!%8"&8 "&' "!# !8'3
"8!' "8$!' #!8#' %!"&' "%'!' !$"" 3!'8
"&%!' "%'!& $!'$& 3!8&
7/25/2019 modelo folha de calculo rede ramificada
7/11
Abastecido pelo r
PROJETO DE REDE DE ABASTECIMENTO DE GUA RUG
TRECHO RUA
VAZO (l/s)
A JUNSANTE A MONTANTE FICTCIA
&!'3 !"8 $!$ !"" !"8 &' '"!" $!& $! $!8 $!3 '$3 # 3 %"!%" $!$$ $!3 $!3 $!$% '$# ' !%8 $!$ !&$ !%" &'' % ' # %$!8& $!$$ $!" $!" $!' '$% & ' #!"" !3# $!$' !38 !3% &'& 8 & & '!&' $!8$ $!$ $!"$ $!8' '$8 " 8 ' 33!"% $!$$ $!# $!# $! '$" " %$!'% $!$$ $! $! $!$% '$
$ $ 8 & &"!" $!# $!# $!'% $!#" '$ $ % 88!"3 $! $!% $!& $!" '$ $ & &8!3" $!$$ $!# $!# $!$& '$3 # & %%!& !$8 $! ! !' '$# ' # 8 83!"# $!$$ $!3# $!3# $!& '$' % # %%!&% $!%3 $! $!&' $!%" '$
% & % " #3!% $!$$ $!% $!% $!3 '$& 8 % %$!3& $!% $! $!3& $!3 '$8 " 8 $ #$!8 $!$$ $!% $!% $!3 '$" 3 & & &!&" $!$$ $!3 $!3 $! '$3 3 3!"# $!$$ $!$# $!$# $!$ '$-/., $!$$8 SOMA (.) , %#!8
*,!""
N4 AJUSANTE
N4 AMONTANTE
E+TENSO(.)
DIAMETRO(..)EM MARCHA
7/25/2019 modelo folha de calculo rede ramificada
8/11
Abastecido pelaPROJETO DE REDE DE ABASTECIMENTO DE GUA RUG
TRECHO RUA
VAZO (l/s)
A JUNSANTE A MONTANTE FICTCIA
$ $ 8 #!$ !3' $!$3 !3" !3& '$ $ 8 #!' $!$$ $!% $!% $!$8 '$ $ A5! M679l &$!& !$" $!$ !" !# '$3 3 " $"!% $!$$ $!' $!' $!$8 '$# # A5! M679l &%!#% $!83 $! $!"3 $!88 '$' ' # $ &$!&" $!$$ $!$ $!$ $!$' '$% % # A5! M679l 88!" $!%$ $! $!&3 $!%% '$& & % !8# $!$$ $!' $!' $! '$8 8 % A5! M679l 88!3 $!3 $! $!3' $!" '$" " 8 $"!$% $!$8 $!' $!3 $!' '$
3$ & " ' '3!#% $!$$ $!$8 $!$8 $!$# '$*, !3" SOMA (.) , "&"!8-/.,$!$$##
#!38
N4 AJUSANTE
N4 AMONTANTE
E+TENSO(.)
DIAMETRO(..)EM MARCHA
7/25/2019 modelo folha de calculo rede ramificada
9/11
servatrio
SIDADE0 C , 3$ FOHA DE CCUOCOTA DE TERRENO (M)
A JUNSANTE A JUNSANTE
$!%8 $!$$838 "8"!&$$ $!$%3 "8"!%3& "&"!' "&"! $!$$ $!'3&$! $!$$$' "8"!%3& $!$3$ "8"!%$& "&"! "&&! $!'3& !'$&$!$3 $!$$$$' "8"!%$& $!$$3 "8"!%$3 "&&! "%8!3 !'$& !3$3$!% $!$$%"$ "8"!%3& $!$&% "8"!'% "&"! "&" $!'3& $!'%$!$& $!$$$3 "8"!'% $!$3& "8"!'# "&" "'% $!'% 33!'#$!'3 $!$$'#3 "8"!'% $!3% "8"!#' "&" "&8!" $!'% $!''$!#3 $!$$'"3 "8"!#' $!33 "8"! "&8!" "&% $!'' 3!$!$% $!$$$% "8"! $!$ "8"!$"$ "&% "'&!' 3! 3!'"$$!$3 $!$$$$# "88!" $!$$ "88!"$" "% "'&!' &!" 3!#$"$!' $!$$ "8"! $!%& "88!"#' "&% "&$!' 3! 8!##'$!$ $!$$$3& "88!"#' $!$33 "88!" "&$!' "% 8!##' &!"$!$# $!$$$$% "88!"#' $!$$' "88!"#$ "&$!' "%3 8!##' '!"#$$!'8 $!$$& "8"!#' $!%8$ "88!' "&8!" "&8 $!'' $!'$!$" $!$$$" "88!' $!$'# "88!%" "&8 "%3 $!' '!%"$!3' $!$$#$ "88!' $!%8 "88!#&& "&8 "&%!' $!' !"&&
$!$& $!$$$" "88!#&& $!$& "88!#' "&%!' "%'!& !"&& !&'$!% $!$$$" "88!#&& $!$'% "88!# "&%!' "&' !"&& 3!#$!$& $!$$$8 "88!# $!$' "88!3"% "&' "%'!' 3!# !8"%33$!$% $!$$$#"## "8"!#' $!$"$"&3 "8"!#$% "&8!" "83!% $!'' '!8$%'"$!$ %!E$$% "8"!%$& $!$$$%# "8"!%$% "&&! "&% !'$& 3!%$%#$%
VEOCIDADE (./s)
PERDA DECARGA
UNITRIA(./.)
COTAPIEZOM1TRICA A
MONTANTE
PERDA DECARGA(.2)
COTAPIEZOM1TRICA A
JUNSANTE
A MONTANTE A MONTANTE
7/25/2019 modelo folha de calculo rede ramificada
10/11
adutoraSIDADE0 C , 3$ FOHA DE CCUO
COTA DE TERRENO (M)
A JUNSANTE A JUNSANTE
$!&$ $!$#8 ""8!' $!3#3 ""8!'& "8!' "8!# %!$$$ '!&'&$!$# $!$$$$8 ""8!'& $!$$" ""8!#" "8!# "&8 '!&'& $!#"$!'8 $!$$8 ""8!'& $!&$ ""&!#3& "8!# "8$!' '!&'& %!"3&$!$# $!$$$$& ""&!#3& $!$$8 ""&!#3$ "8$!' "&%!' %!"3& $!"3$$!#' $!$$%3 ""&!#3& $!#83 ""%!"'# "8$!' "&8 %!"3& 8!"'#$!$3 $!$$$$3 ""%!"'# $!$$ ""%!"' "&8 "&' 8!"'# !"'$!3# $!$$3&' ""%!"'# $!33 ""%!%3 "&8 "&' 8!"'# !%3$!$% $!$$$& ""%!%3 $!$" ""%!'"# "&' "%3!' !%3 33!$"#$!' $!$$$8 ""%!%3 $!$& ""%!'' "&' "&!% !%3 3!"'$!$8 $!$$$' ""%!'' $!$& ""%!'# "&!% "%' 3!"' 3!'#
$!$ $!$$$$ ""%!'# $!$$ ""%!'3 "%' "%3!' 3!'# 33!$3
VEOCIDADE (./s)
PERDA DECARGAUNITRIA
(./.)
COTAPIEZOM1TRICA A
MONTANTE
PERDA DECARGA(.2)
COTAPIEZOM1TRICA A
JUNSANTE
A MONTANTE A MONTANTE
7/25/2019 modelo folha de calculo rede ramificada
11/11
9: