design of cross drainage structures
TRANSCRIPT
-
8/19/2019 Design of Cross drainage Structures
1/25
Culvert Analysis Spreadsheet
Client: Siddharthanagar Municipality Date:
Design By: China Guangzhou-Sharma JV Date:Comments:
Inputs:
Headwater !pstream "ater Sur#ace$ %le&ation: 'eet
Cul&ert (nlet (n&ert %le&ation: 'eet
Cul&ert Diameter: (nches Select Cul&ert Material: CM)
*ength o# Cul&ert: 'eet Select Cul&ert (nlet +ype: )ro,ecting - +hin %dge
Cul&ert utlet (n&ert %le&ation: 'eet
+ailwater Downstream$ %le&ation: 'eet
Outputs:
CAPACITY = 0.0 cfs Headwater Elevation EQA!" Tailwater Elevation #
Manning.s n &alue: /0/12 CM)
%ntrance Coe3cient4 5e: /06 )ro,ecting - +hin %dge
Compute
Print
-
8/19/2019 Design of Cross drainage Structures
2/25
(annin)*s +n+ ,alues:Culvert (aterial +n+ ,alue
Concrete /0/71
CM) /0/12
)VC8)lastic /0/77
Corrugated8)% /0/12
Smooth8HD)% /0/71
Culvert Entrance T-pe: Source: 'H"9 Hydraulic DesiEntrance T-pe e
)ro,ecting - Groo&e %dge /01
)ro,ecting - S>uare %dge /0=
)ro,ecting - +hin %dge /06
Headwall - Groo&e %dge /01
Headwall - S>uare %dge /0=
Miter?S>uare?1:7 Slope /0@
Constants for Inlet Control /esi)n Euations
Culvert "1ape Culvert (aterial
Circular Concrete
Circular Concrete
Circular ConcreteCircular Concrete
Circular CM)
Circular CM)
Circular CM)
Circular )VC8)lastic
Circular )VC8)lastic
Circular Smooth8HD)%
Circular Smooth8HD)%
Circular Smooth8HD)%
Circular Corrugated8)%
Circular Corrugated8)%Circular Corrugated8)%
-
8/19/2019 Design of Cross drainage Structures
3/25
Ae#erence: 'H"9 Hydraulic Design o# Highway Cul&erts
Ae#erence: 'H"9 Hydraulic Design o# Highway Cul&erts
Ae#erence: H< !ser Guide
Ae#erence: H< !ser Guide
Ae#erence: H< !ser Guide
n o# Highway Cul&erts4 +a;le 714 76
-
8/19/2019 Design of Cross drainage Structures
4/25
Constants
Y
/0@
/0@2
/06/02 Ae#erenceE r use the same as headwall - s>uare edge0 See Hydra
/06
/0@=
/0=2
/0@ 'rom H< !ser Guide - same as #or Concrete )ipe S>uare %dge with
/0@= 'rom H< !ser Guide - same as #or Corrugated Metal )ipe cul&ert4 M
/0@ 'rom H< !ser Guide - same as #or Concrete )ipe S>uare %dge with
/0=2 'rom H< !ser Guide - same as #or CM) )ro,ecting - +hin %dge
/0@= 'rom H< !ser Guide - same as #or Corrugated Metal )ipe cul&ert4 M
/06 'rom H< !ser Guide - same as #or Corrugated Metal )ipe cul&ert wi
/0=2 'rom H< !ser Guide - same as #or CM) )ro,ecting - +hin %dge/0@= 'rom H< !ser Guide - same as #or Corrugated Metal )ipe cul&ert4 M
4eturn to (ain &indow
-
8/19/2019 Design of Cross drainage Structures
5/25
ulic Design o# Highway Cul&erts rd sentence o# last paragraph on p0 1=
Headwall
itered to con#orm to slope
Headwall
itered to con#orm to slope
th Headwall
itered to con#orm to slope
-
8/19/2019 Design of Cross drainage Structures
6/25
with the socFet end pro,ecting #rom the ll$
Culvert Entrance Conditions:
Pro5ectin) 6roove Ed)e 9pplies only to Concrete C
Headwall 7 6roove Ed)e applies to Concrete pipe
-
8/19/2019 Design of Cross drainage Structures
7/25
socFet end in com;ination with a concrete head
-
8/19/2019 Design of Cross drainage Structures
8/25
non-socFet end o# th
ul&erts Pro5ectin) "uare Ed)e
ith the Headwall 7 "uare Ed)e
4eturn to (ain &indow
-
8/19/2019 Design of Cross drainage Structures
9/25
all$
headwall and a s>ua
"3oot1 H/PE4 or
-
8/19/2019 Design of Cross drainage Structures
10/25
e pipe pro,ecting #rom the ll$
9pplies to Concrete Cul&erts #or
applies to Concrete4 C(P4 P,C plastic4
-
8/19/2019 Design of Cross drainage Structures
11/25
re edge entrance$
orru)ated PE cul&erts with a concrete
-
8/19/2019 Design of Cross drainage Structures
12/25
Pro5ectin) T1in Ed)e 9pplies to Corrugated Metal )i
Smooth H/PE or Corru)ated PE cul&erts pro,e
(iter8"uare89: "lope applies to C(P4 P,C plasti
-
8/19/2019 Design of Cross drainage Structures
13/25
Corru)ated PE cul&erts that are mitered to con
-
8/19/2019 Design of Cross drainage Structures
14/25
e C(P$4
ting #rom the ll$
c4 "3oot1 H/PE or
-
8/19/2019 Design of Cross drainage Structures
15/25
#orm to the slope$
-
8/19/2019 Design of Cross drainage Structures
16/25
$ew ser Infor3ation:
ote that this spreadsheet was designed using %Icel 1//@0 (#
'ile4 ptions4 'ormulas4 Calculation options4 and then under
!i3itations of t1e Culvert Anal-sis "preads1eet:
+his spreadsheet applies to concrete AC)$4 corrugated metal p
(t does not analyze partially lled with rocF or sediment$ cul&e
'ree sur#ace channel Kow$ calculations are approIimate0 +hey
'or &ery high headwater depths e0g0 greater than 7=.$ another
(# a restriction e0g0 another cul&ert or ;ridge$ is located a shortH%C-A9S more compleI4 ;ut detailed$4 or H-uations that were used #or inlet control su;merged and
Calculations are made #or each potentially applica;le conditioninput section near the top o# the Cul&ert 9nalysis sheet0 +he c
Hydraulic Design o# Highway Cul&erts4 Hydraulic Design Series
If -ou are usin) t1is spreads1eet for t1e ;rst ti3e< it is
$OTE for E>cel 900: Be sure that the calculations are set t
+his spreadsheet applies to sin)le Circular Cul&erts only not r
+his spreadsheet should not ;e used to analyze cul&erts with
+he outlet control calculations use the assumption o# a 70/ #or t
+his spreadsheet does not analyze road o&ertopping0
+his spreadsheet pro&ides an approIimate cul&ert hydraulic an
9 downstream tailwater ele&ation must ;e entered as input dat
+he spreadsheet checFs #or inlet control su;merged and unsu
4eferences:
-
8/19/2019 Design of Cross drainage Structures
17/25
H< 'ederal Highway 9dministration.s Cul&ert 9nalysis )rogra
!S 9rmy Corps o# %ngineers4 Hydrologic %ngineering Center H
If -ou are 1avin) pro2le3s wit1 )ettin) t1e (acr
4eturn to (ain &indow
HE!P for (AC4
-
8/19/2019 Design of Cross drainage Structures
18/25
ou are using %Icel 1// or earlier4 the spreadsheet pro;a;ly wi
"orF;ooF Calculation ;e sure that automatic is selected0
ipe CM)$4 )VC plastic4 Smooth HD)%4 or Corrugated )% cul&ert
ts0
do not in&ol&e a detailed water sur#ace prole analysisL
method e0g0 H%C-A9S or H-
-
8/19/2019 Design of Cross drainage Structures
19/25
!ser Guide
C$4 H%C-A9S4 Ai&er 9nalysis System Hydraulic Ae#erence Manu
*s to &or in t1is "preads1eet< please "elect +Hel
"'
-
8/19/2019 Design of Cross drainage Structures
20/25
ll not worF
aterials0
oles are re>uired4 another method4 such as
taFen #rom Ae#erence 7 ;elow0
and indicated directly ;elow the
istration4 Ae&ised May 1//=
ct the Help #or Macros ;utton ;elow and #ollow the instructio
considered in the eIit loss calculations$0
tailed water sur#ace prole analysis0
tly impact the resulting computed cul&ert capacity0
te #ree sur#ace channel Kow$ conditions0
-
8/19/2019 Design of Cross drainage Structures
21/25
l4 March 1//<
p for (acros+ and %ollow t1e instructions
-
8/19/2019 Design of Cross drainage Structures
22/25
ns to install these options0
-
8/19/2019 Design of Cross drainage Structures
23/25
-
8/19/2019 Design of Cross drainage Structures
24/25
$E& ser Instructions:ote that this spreadsheet was designed using %Icel 1//@0 (# you are using %Icel 1// or earlier4 the spreadsheet pro;a;ly will not worF
If -ou are usin) t1is spreads1eet for t1e ;rst ti3e< it is i3portant t1at -ou install several e- E>cel Options'
It would 1elp to print t1ese instructions to use w1ile -ou are installin) t1ese options
Select the 3ce Button in the upper le#t corner o# the %Icel Screen:
"hen the new window opens4 select the N%Icel ptionsO ;utton at the ;ottom o# this window0
Select the N)opularO option on the le#t side o# the %Icel ptions screen and ;e sure that the option
NShow De&eloper ta; in the Ai;;onO is selected:
+hen4 select N9ddP(nsO option #rom the %Icel ptions window:
ote that you do not need 9dministrati&e )ri&ileges to install these options4 5ust follow t1ese instructions:
4eturn to (ain &indow
-
8/19/2019 Design of Cross drainage Structures
25/25
9t the ;ottom o# the 9ddP(ns "indow4 select NManage: %Icel 9ddPinsO and then select NGoO and the
#ollowing window will appear:
(n this window4 select the N9nalysis +ool)aFO4
N*ooFup "izardO and NSol&er 9ddPinO and then select
N5O0
9dministrati&e pri&ileges are not needed to NinstallO
these %Icel 9ddPins howe&er4 it will taFe a minute or
so #or these 9ddPins to ;e loaded0
4eturn to (ain &indow