Blue Book Design Spreadsheet V8

1.
Erosion Hazard and Sediment Basins

Site Name:
Site Location:
Precinct/Stage:
Other Details:
Sub-catchment or Name of Structure
Site area
Notes
Total catchment area (ha)

Disturbed catchment area (ha)
Soil analysis (enter sediment type if known, or laboratory particle size data)
Sediment Type (C, F or D) if known:
From Appendix C (if known)
% sand (fraction 0.02 to 2.00 mm)
Enter the percentage of each soil

fraction. E.g. enter 10 for 10%
% silt (fraction 0.002 to 0.02 mm)

% clay (fraction finer than 0.002 mm)
Dispersion percentage
% of whole soil dispersible
Soil Texture Group
E.g. enter 10 for dispersion of 10%

0
See Section 6.3.3(e). Auto-calculated
Automatic calculation from above
Rainfall data
Design rainfall depth (no of days)
See Section 6.3.4 and, particularly,

Table 6.3 on pages 6-24 and 6-25.
Design rainfall depth (percentile)

x-day, y-percentile rainfall event (mm)
Rainfall R-factor (if known)
Only need to enter one or the other here
IFD: 2-year, 6-hour storm (if known)
RUSLE Factors
0
Length/gradient (LS-factor)
0.00
0.00
0.00
0.00
0.00
0.00
Erosion control practice (P-factor)
1.3
1.3
1.3
1.3
1.3
1.3
Rainfall erosivity (R-factor)
Auto-filled from above
Soil erodibility (K-factor)

Slope length (m)
Slope gradient (%)
Ground cover (C-factor)
RUSLE LS factor calculated for a high

rill/interrill ratio.
Sediment Basin Design Criteria (for Type D/F basins only. Leave blank for Type C basins)
2
Storage (soil) zone design (no of months)
Minimum is generally 2 months

See Table F2, page F-4 in Appendix F
Cv (Volumetric runoff coefficient)
Calculations and Type D/F Sediment Basin Volumes

Soil loss (t/ha/yr)
Soil Loss Class
See Table 4.2, page 4-13
Soil loss (m /ha/yr)
Conversion to cubic metres
Sediment basin storage (soil) volume (m3)
See Sections 6.3.4(i) for calculations
See Sections 6.3.4(i) for calculations
Sediment basin settling (water) volume (m )

3
Sediment basin total volume (m3)
NB for sizing of Type C (coarse) sediment basins, see Worksheet 3 (if required).
2. Flow Calculations
Qy = 0.00278 x C10 x FY x Iy, tc x A
Peak flow is given by the Rational Formula:

where:
Qy
C10
Fy
A
Iy, tc
is peak flow rate (m3/sec) of average recurrence interval (ARI) of "Y" years
is the runoff coefficient (dimensionless) for ARI of 10 years.
is a frequency factor for "Y" years.
is the catchment area in hectares (ha)
is the average rainfall intensity (mm/hr) for an ARI of "Y" years
and a design duration of "tc" (minutes or hours)
Time of concentration (tc) = 0.76 x (A/100)0.38 hrs

Note: For urban catchments the time of concentration should be determined by more precise
calculations or reduced by a factor of 50 per cent. Place an x in the appropriate row below to
automatically halve the time of concentration for that sub-catchment.
Structure Details
Notes
Name
Catchment Area (ha)
Place an x here to halve tc
Place an x if disturbed catchment
Time of concentration (tc)
minutes
Rainfall Intensities
1-year, tc
Enter the relevant rainfall

intensities (in mm/hr) for each of
the nominated rainfall events.
The time of concentration (tc)
determines the duration of the
event to be used
2-year, tc
5-year, tc
10-year, tc
20-year, tc
50-year, tc
100-year, tc
C10 runoff coefficient
Use AR&R or Table F3, pg F-6
Frequency Factors
FF, 1-year
0.8
0.8
0.8
0.8
0.8
0.8
0.8
0.8
Can use 0.8 for a construction site
FF, 2-year
0.85
0.85
0.85
0.85
0.85
0.85
0.85
0.85
FF, 5-year
0.95
0.95
0.95
0.95
0.95
0.95
0.95
0.95
Can use 0.85 for a construction

Can use 0.95 site
for a construction
FF, 10-year
sitealways 1
Generally
FF, 20-year
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
FF, 50-year
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
Can use 1.05 for a construction

Can use 1.15 site
for a construction
FF, 100-year
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
Can use 1.2 forsite

a construction site
1-year, tc (m3/s)
2-year, tc (m3/s)
Flow Calculations
Notes
5-year, tc (m /s)
10-year, tc (m3/s)
20-year, tc (m /s)
50-year, tc (m /s)
3
3
100-year, tc (m3/s)
NB for flow calculations on sediment basin spillways, see Worksheet 3 (if required).
3. Sediment Basin Spillway Design

Structure Details
Structure Name
Catchment Area (ha)
Auto-filled from Worksheet 1

Time of concentration (tc)
Auto-calculated assuming tc is halved
Rainfall Intensities (IFD Values)

1 year, tc
2 year, tc
Enter the relevant rainfall intensities (in

mm/hr) for each of the nominated rainfall
events.
The time of concentration (tc) determines
the duration of the event to be used
5 year, tc
10 year, tc
20 year, tc
50 year, tc
100 year, tc
C10 runoff coefficient
Use AR&R or Table F3, pg F-6
Design ARI event (select):
100
100
100
100
100
100
Select design ARI (years) from dropdown
Frequency Factor
1.2
1.2
1.2
1.2
1.2
1.2
Auto-filled based on selected ARI
Flow Calculation
Auto-calculated based on selected ARI
4. Volume of Type C (Coarse) Sediment Basins

Type C Basin Design Criteria
Structure Name
Catchment Area (ha)
Sediment type (C, F or D)
Design rainfall event

Choose design event from dropdown
Flow volume (m3/s)

Area Factor
Depth of settling (water zone) (m)
Calculated from IFD values above
4100
4100
4100
4100
4100
4100
Default is 4,100. See pg 6-12
0.6
0.6
0.6
0.6
0.6
0.6
Minimum is 0.6m (pg 6-12)
Type C Basin Volume Calculations

Basin Surface Area (m2)
Not Type C
Not Type C
Not Type C
Not Type C
Not Type C
Not Type C
Auto-calculated
Settling (water) zone volume (m 3)
Not Type C
Not Type C
Not Type C
Not Type C
Not Type C
Not Type C
Auto-calculated
Storage (soil) zone volume (m )
Not Type C
Not Type C
Not Type C
Not Type C
Not Type C
Not Type C
Auto-calculated
Total basin volume (m3)
Not Type C
Not Type C
Not Type C
Not Type C
Not Type C
Not Type C
Auto-calculated
Basin Shape
Enter length:width ratio
E.g. for 3:1 (L:W) enter 3.
Length (m)
N/A
N/A
N/A
N/A
N/A
N/A
Width (m)
N/A
N/A
N/A
N/A
N/A
N/A
These figures should be taken as a guide

only. Detailed calcs might be required.

Blue Book Design Spreadsheet V8

Uploaded by

Copyright:

Available Formats

Blue Book Design Spreadsheet V8

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Blue Book Design Spreadsheet V8

Uploaded by

Copyright:

Available Formats

1.

Erosion Hazard and Sediment Basins

Total catchment area (ha)

From Appendix C (if known)

% sand (fraction 0.02 to 2.00 mm)

Enter the percentage of each soil

% silt (fraction 0.002 to 0.02 mm)

E.g. enter 10 for dispersion of 10%

See Section 6.3.3(e). Auto-calculated

Automatic calculation from above

See Section 6.3.4 and, particularly,

Design rainfall depth (percentile)

Only need to enter one or the other here

IFD: 2-year, 6-hour storm (if known)

Erosion control practice (P-factor)

Rainfall erosivity (R-factor)

Auto-filled from above

Soil erodibility (K-factor)

Ground cover (C-factor)

RUSLE LS factor calculated for a high

Storage (soil) zone design (no of months)

Minimum is generally 2 months

Cv (Volumetric runoff coefficient)

Calculations and Type D/F Sediment Basin Volumes

Soil Loss Class

See Table 4.2, page 4-13

Soil loss (m /ha/yr)

Conversion to cubic metres

Sediment basin storage (soil) volume (m3)

See Sections 6.3.4(i) for calculations

See Sections 6.3.4(i) for calculations

Sediment basin settling (water) volume (m )

Sediment basin total volume (m3)

Peak flow is given by the Rational Formula:

Time of concentration (tc) = 0.76 x (A/100)0.38 hrs

Place an x if disturbed catchment

Time of concentration (tc)

Enter the relevant rainfall

Use AR&R or Table F3, pg F-6

Can use 0.8 for a construction site

Can use 0.85 for a construction

Can use 1.05 for a construction

Can use 1.2 forsite

3. Sediment Basin Spillway Design

Catchment Area (ha)

Auto-filled from Worksheet 1

Time of concentration (tc)

Auto-calculated assuming tc is halved

Rainfall Intensities (IFD Values)

Enter the relevant rainfall intensities (in

Use AR&R or Table F3, pg F-6

Design ARI event (select):

Select design ARI (years) from dropdown

Auto-filled based on selected ARI

Auto-calculated based on selected ARI

4. Volume of Type C (Coarse) Sediment Basins

Auto-filled from Worksheet 1

Catchment Area (ha)