Spreadsheet: 0cb03e5b-00c3-471c-9020-63aac8cbb07f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
EXHIBIT 1
USDA - Natural Resource Conservation Service
ROOF  RUNOFF  DESIGN  PROGRAM  version 1.2  -   5-minute RAINFALL DURATION
* Note: This worksheet is based upon the procedures described in chapter 10 of the                                                                                                                                       Agricultural Waste Management Field Handbook.
Job: |  | Cooperator Name
Designed: |  |  |  | Date:
Checked: |  |  |  | Date:
Approved: |  |  |  | Date:
Step 1:            Compute Capacity of Selected Gutter Size
qg=0.16407 * Ag * r 0.67 * s 0.5     (recommend s = 0.00521)
Select 10Yr or 25Yr Rainfall |  | 25
5-min. rain depth, P (in) |  | 0.8 |  | (SEE AWMFH, [NAME]. 10B-3 and 10B-4)
 |  | Mushroom roof 1 |  | Germination roof 2 |  | Gazebo3 |  | ROOF 4
GUTTER DATA
Freeboard, FB (in) |  | 0.5 |  | 0.5 |  | 0.5 |  | 0
Depth (in) incl. FB |  | 3.5 |  | 3.5 |  | 3.5 |  | 0
[NAME] (in) |  | 5 |  | 5 |  | 5 |  | 0
[NAME] (in) |  | 4 |  | 4 |  | 4 |  | 0
[NAME], s (ft/ft) |  | 0.00521 |  | 0.00521 |  | 0.00521 |  | 0
Wetted Perimeter, [NAME] (in) |  | 10.12004709540594 |  | 10.12004709540594 |  | 10.12004709540594
[NAME], r (in) |  | 1.312811507739468 |  | 1.312811507739468 |  | 1.312811507739468
Flow Area, Ag (sq in) |  | 13.28571428571429 |  | 13.28571428571429 |  | 13.28571428571429
GUTTER CAPACITY, [NAME] (cfs) |  | 0.1888115421868392 |  | 0.1888115421868392 |  | 0.1888115421868392
Step 2:          Compute Capacity of Downspout
qd=0.010457 * Ad * H 0.5        (arrow "*" indicates value used to determine the area of the downspout, Ad)
 |  | ROOF 1 |  | ROOF 2 |  | ROOF 3 |  | ROOF 4
Head = Depth, H (in) |  | 3 |  | 3 |  | 3 |  | 0
[NAME]. of Downspout (DS), (in) |  | 4 | * | 4 | * | 4 | * | 0
Length of DS Opening, (in) |  | 3.25 |  | 3.25 |  | 3.25 |  | 0 | *
[NAME] of DS Opening, (in) |  | 2.25 |  | 2.25 |  | 2.25 |  | 0 | *
Area of DS, Ad (in2) |  | 12.5664 |  | 12.5664 |  | 12.5664 |  | 0
DOWNSPOUT CAPACITY, qd (cfs) |  | 0.2276033316559181 |  | 0.2276033316559181 |  | 0.2276033316559181 |  | 0
Step 3:        Determine if [NAME] or Downspout Controls
Nd=qg/qd      (If Nd<1, gutter capacity controls)
 |  | ROOF 1 |  | ROOF 2 |  | ROOF 3 |  | ROOF 4
Nd = Number of Downspouts |  | 0.8295640525696574 |  | 0.8295640525696574 |  | 0.8295640525696574
Step 4:    Determine Roof Area Gutter or Downspout can Serve
Ar = q*3,600/P
 |  | ROOF 1 |  | ROOF 2 |  | ROOF 3 |  | ROOF 4
Length of Building, (ft) |  | 83 |  | 120 |  | 40 |  | 0
Width of Building, (ft) |  | 16.5 |  | 16.5 |  | 30 |  | 0
Area of roof, (ft2) |  | 1369.5 |  | 1980 |  | 1200 |  | 0
Controlling Capacity |  | GUTTER |  | GUTTER |  | GUTTER
Roof Area Served, Ar (sq ft) |  | 849.6519398407762 |  | 849.6519398407762 |  | 849.6519398407762
Total Number of Downspouts |  | 2 |  | 3 |  | 2
"Ke", Pipe entrance |  | 0.9 |  | [NAME]
"n", Mannings |  | 0.012 |  | 0.4 |  | "Q", CFS
Length, ft |  | 24 |  | 16 |  | Area of Down Pipe, in^2.
Head, ft |  | 14 |  | 1.333333333333333 |  | Ft, Wier Length
Diameter, Inches |  | 4.5 |  | 2.332831582612584 |  | in. Hp, Flow Depth over wier
"Kp" |  | 0.09850056834063464
Area, ft2 |  | 0.110446875 |  | Orifice Flow-Round Risers
Velocity, fps |  | 14.54111331764788 |  | 0.3 |  | "Q", CFS
"Q", cfs |  | 1.606020524955091 |  | 8 |  | Area of Down Pipe, in^2.
0.017V2, ft. [NAME] |  | 3.594547600783502 |  | 0.9428090415820635 |  | Ft, Wier Length
0.022V2, ft. CM Pipe |  | 4.651767483366884 |  | 3.01875 |  | in. Hp, Orifice Flow
 |  | ROOF 1 |  | ROOF 2 |  | ROOF 3 |  | ROOF 4
[NAME], Sq.Ft. |  | 800 |  | 800 |  | 800 |  | 800
Avg. WS Slope, % |  | 32 |  | 32 |  | 32 |  | 32
[NAME] length, ft. |  | 80 |  | 80 |  | 80 |  | 80
Curve No. |  | 98 |  | 98 |  | 98 |  | 98
S = (1000/CN')-10 |  | 0.204081632653061 |  | 0.204081632653061 |  | 0.204081632653061 |  | 0.204081632653061
(L) Watershed Lag, Hours |  | 0.003528600989813312 |  | 0.003528600989813312 |  | 0.003528600989813312 |  | 0.003528600989813312
Tc, Hours |  | 0.005892763652988231 |  | 0.005892763652988231 |  | 0.005892763652988231 |  | 0.005892763652988231
Rainfall, inches. |  | 12 |  | 12 |  | 12 |  | 12
Runoff, in. |  | 11.75852622928366 |  | 11.75852622928366 |  | 11.75852622928366 |  | 11.75852622928366
Ia/p, in/in
Log (qu), csm/in
qp or "Qi",  cfs