LAKESHORE RIPRAP DESIGN COMPUTATIONS SPREADSHEET ver 3.24.

17

CLIENT: COUNTY: DATE:

DSN BY: CHECKED BY: DATE:
COMMENTS:
*****************************************************************************************************************************
Average Depth (d) Across Longest Fetch Using Numerical Average
Station No. Station (ft) Depth (ft.) Average Depth (d) = ft
1 Longest Fetch (F) = ft
2 Hazard Class of Site: (1=Low, 2=Med, 3=High)
3 Revetment Slope Ratio (z) = (i.e. 2:1)
4 Ordinary High Water Elev. =
5 Normal Yearly Low Water Elev. = See sketch
6 Average Top of Bank Elev. = on "desc" tab.
7 Proposed Toe Lake Bottom Elev. =
8 Length of Shoreline= ft
9 Observed Boat Wave Height(Bs)= (if applicable) ft
10
Weighted Average = 0.0 feet
Numerical Average = #DIV/0!
Wave Height Design
Storm Wind Speed (Ua) = 35 mph = 51.45 ft/sec
Wave Period (T) = 0.559(UaF)1/3 (Ua-mph, F-miles) = 0.00 sec
Wave Length (L) = 5.12T2 = 0.00 ft
Non-dimensional fetch (χ) = gF/(Ua)^2 = 0.00
Non-dimensional water depth (δ) = gd/(Ua)^2 = #VALUE!
A1 = 0.493δ0.75 = #VALUE!
B1 = 0.00313χ0.57 = 0.0000
Non-dimensional epsilon (έ) = .00364(tanhA1tanh(B1/tanhA1))1.74 = #VALUE!
Wave energy (E) = έUa4/g2 = #VALUE! ft2
Wave Height (Hs) = 4E0.5 = #VALUE! ft #VALUE!
Safety Design Factor (DFwph) = (based on hazard class) = #VALUE!
Design Wave Height (Ho) = DFwphHs = #VALUE! Feet
Ho/L = = 0.00
Relative Runup Ratio = = 0.00
Runup (R) = Ho*(Relative Runup Ratio) = 0.0 Feet
Setup (S) = lesser of 0.5' or 0.1Hs = #VALUE! Feet
Elevation Design #VALUE!
Lower Limit For Protection = Low Water - 1.5Hs = #VALUE! Elev. Calc. ### Elev. Used
Upper Limit For Protection = OHWM+R+S (or OHWM + Bs) = #VALUE! Elev. Calc. ### Elev. Used
Upper Limit For Riprap = OHWM+Hs (or OHWM+Bs) = #VALUE! Elev. Calc. ### Elev. Used
#VALUE! = #VALUE! ft Calc. ### ft- Length Used
Rock Design
Rock Specific Gravity (Gs) = = 2.65 typical 2.65 Gs Used
Shape of Rock = Cubical
Safety Design Factor (DFriprap) = = 0.00 0.00 SDF Used
Rock Size Wave Height (Hrock) = Hs*DFriprap = #VALUE! ft
W50 Rock Size = (RockFactor)GsHrock3/(Gs-1)3z = #VALUE! lbs.
d50 Rock Size = 0.0 0.0 in. D50 Used
Rock Thickness = greater of 12" or 2D50 = 12.0 inches
Recommended Toe Type = #VALUE! #VALUE! Used
0.0 feet

Rock Gradation Style = Riprap Gradation (EFH 17 Method)

Quantities % Passing Size of Stone (Inches)
Riprap: 0 Cu. Yds. 100 0
Geotextile: 0 Sq. Yds. (does not include overlap) 60 - 85 0
Boulders: 0 Cu. Yds. 25 - 50 0
5 - 20 0
0-5 0
Sand or Gravel can be us
as a filter in place of
geotextile

The filter layer gradation

shall be designed per
Chapter 26 of Part 633 o
National Engineering
Handbook .
el can be used
place of

er gradation
gned per
f Part 633 of the
neering
 DATA ENTRY UNITS : 1 (1 = US Feet, 2 = Meters)

COORDINATES
PAIR X Y
1 0.00 #VALUE!
2 #DIV/0! #VALUE!
3 #VALUE! 0.00
4 #VALUE! 0.00 Area = #VALUE! square feet
5 #VALUE! -1.00 #VALUE! acres
6 #VALUE! -1.00
7 0.00 #VALUE!
12.00
8
9 10.00
10
11 8.00
12
13
Y

6.00
14
15 4.00
16
17 2.00

18
19 0.00
0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
20
21 X

22
23 Vertical Drop #VALUE!
24 Horizontal #VALUE!
25 Slope Length #VALUE!
26
27
28
29
30
spreadsheet by M.K. King AreaByCoordinateMethod4-2005.
 =X1*Y2
#VALUE!
#DIV/0!
#VALUE! square meters #VALUE!
#VALUE! hectares #VALUE!
#VALUE!
#VALUE!
0
0
0
0
0
0
0
0
0
0
0
0
0.50 0.60 0.70 0.80 0.90 1.00
0
X 0
0
0
0
0
0
0
0
0
0
AreaByCoordinateMethod4-2005.xls Sum #VALUE!
Difference/2 = #VALUE!
 DATA ENTRY UNITS : US feet

COORDINATES
PAIR X Y
=X2*Y1 1 0 #VALUE!
#VALUE! 2 #DIV/0! #VALUE!
#VALUE! 3 #VALUE! 0
#VALUE! 4 #VALUE! 0 Area = #VALUE!
#VALUE! 5 #VALUE! -1 #VALUE!
#VALUE! 6 #VALUE! -1
0 7 0 #VALUE!
#VALUE! 8 0 0
0 9 0 0
0 10 0 0
0 11 0 0
0 12 0 0
0 13 0 0
0 14 0 0
0 15 0 0
12.00
0 16 0 0
0 17 0 0
10.00
0 18 0 0
0 19 0 0
8.00
0 20 0 0
0 21 0 0
Y

6.00
0 22 0 0
0 23 0 0
4.00
0 24 0 0
0 25 0 0
2.00
0 26 0 0
0 27 0 0 0.00
0 28 0 0 0.00 0.10 0.20 0.30 0.40 0.50 0.60
0 29 0 0 X
0 30 0 0
#VALUE! spreadsheet by M.K. King
sq units
 square feet #VALUE! square meters
acres #VALUE! hectares

0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
X

AreaByCoordinateMethod4-2005.xls
 DATA ENTRY UNITS : 1 (1 = US Feet, 2 = Meters)

COORDINATES
PAIR X Y
1 0.00 #VALUE!
2 #DIV/0! #VALUE!
3 #VALUE! 0.00
4 #VALUE! 0.00 Area = #VALUE! square feet
5 #VALUE! -1.00 #VALUE! acres
6 #VALUE! -1.00
7 #DIV/0! -1.00
12.00
8 #DIV/0! #DIV/0!
9 #VALUE! #DIV/0! 10.00
10 #VALUE! #VALUE!
11 0.00 #VALUE! 8.00
12
13
Y

6.00
14
15 4.00
16
17 2.00

18
19 0.00
0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
20
21 X

22
23
24
25
26
27
28
29
30
spreadsheet by M.K. King AreaByCoordinateMethod4-2005.
 =X1*Y2
#VALUE!
#DIV/0!
#VALUE! square meters #VALUE!
#VALUE! hectares #VALUE!
#VALUE!
#VALUE!
#DIV/0!
#DIV/0!
#VALUE!
#VALUE!
0
0
0
0
0
0
0
0
0.50 0.60 0.70 0.80 0.90 1.00
0
0
0
0
0
0
0
0
0
0
0
AreaByCoordinateMethod4-2005.xls Sum #VALUE!
Difference/2 = #VALUE!
 DATA ENTRY UNITS : US feet

COORDINATES
PAIR X Y
=X2*Y1 1 0 #VALUE!
#VALUE! 2 #DIV/0! #VALUE!
#VALUE! 3 #VALUE! 0
#VALUE! 4 #VALUE! 0 Area = #VALUE!
#VALUE! 5 #VALUE! -1 #VALUE!
#VALUE! 6 #VALUE! -1
#DIV/0! 7 #DIV/0! -1
#DIV/0! 8 #DIV/0! #DIV/0!
#DIV/0! 9 #VALUE! #DIV/0!
#DIV/0! 10 #VALUE! #VALUE!
#VALUE! 11 0 #VALUE!
#VALUE! 12 0 0
0 13 0 0
0 14 0 0
0 15 0 0
12.00
0 16 0 0
0 17 0 0
10.00
0 18 0 0
0 19 0 0
8.00
0 20 0 0
0 21 0 0
Y

6.00
0 22 0 0
0 23 0 0
4.00
0 24 0 0
0 25 0 0
2.00
0 26 0 0
0 27 0 0 0.00
0 28 0 0 0.00 0.10 0.20 0.30 0.40 0.50 0.60
0 29 0 0 X
0 30 0 0
#VALUE! spreadsheet by M.K. King
sq units
 square feet #VALUE! square meters
acres #VALUE! hectares

0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
X

AreaByCoordinateMethod4-2005.xls
 DATA ENTRY UNITS : 1 (1 = US Feet, 2 = Meters)

COORDINATES
PAIR X Y
1 0.00 #VALUE!
2 #DIV/0! #VALUE!
3 #VALUE! #VALUE!
4 #DIV/0! #DIV/0! Area = #VALUE! square feet
5 #DIV/0! #DIV/0! #VALUE! acres
6 #DIV/0! #DIV/0!
7 #DIV/0! #DIV/0!
12.00
8 #DIV/0! #DIV/0!
9 0.00 #VALUE! 10.00
10
11 8.00
12
Y

13 6.00
14
15 4.00
16
17 2.00

18
19 0.00
0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
20
21 X

22
23 Vertical Drop #VALUE! #DIV/0!
24 Horizontal #VALUE! #DIV/0!
25 Slope Length #VALUE! #DIV/0! #VALUE!
26
27
28
29
30
spreadsheet by M.K. King AreaByCoordinateMethod4-2005.
 =X1*Y2
#VALUE!
#DIV/0!
#VALUE! square meters #VALUE!
#VALUE! hectares #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0
0
0
0
0
0
0
0
0
0
0.50 0.60 0.70 0.80 0.90 1.00
0
X 0
0
0
0
0
0
0
0
0
0
AreaByCoordinateMethod4-2005.xls Sum #VALUE!
Difference/2 = #VALUE!

0  L.b
0  L.b/2
#DIV/0! phi radians
#DIV/0! drop
 DATA ENTRY UNITS : US feet

COORDINATES
PAIR X Y
=X2*Y1 1 0 #VALUE!
#VALUE! 2 #DIV/0! #VALUE!
#VALUE! 3 #VALUE! #VALUE!
#VALUE! 4 #DIV/0! #DIV/0! Area = #VALUE!
#DIV/0! 5 #DIV/0! #DIV/0! #VALUE!
#DIV/0! 6 #DIV/0! #DIV/0!
#DIV/0! 7 #DIV/0! #DIV/0!
#DIV/0! 8 #DIV/0! #DIV/0!
#DIV/0! 9 0 #VALUE!
#VALUE! 10 0 0
0 11 0 0
0 12 0 0
0 13 0 0
0 14 0 0
0 15 0 0
12.00
0 16 0 0
0 17 0 0
10.00
0 18 0 0
0 19 0 0
8.00
0 20 0 0
0 21 0 0
Y

6.00
0 22 0 0
0 23 0 0
4.00
0 24 0 0
0 25 0 0
2.00
0 26 0 0
0 27 0 0 0.00
0 28 0 0 0.00 0.10 0.20 0.30 0.40 0.50 0.60
0 29 0 0 X
0 30 0 0
#VALUE! spreadsheet by M.K. King
sq units
 square feet #VALUE! square meters
acres #VALUE! hectares

0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
X

AreaByCoordinateMethod4-2005.xls
 DATA ENTRY UNITS : 1 (1 = US Feet, 2 = Meters)

COORDINATES
PAIR X Y
1 0.00 #VALUE!
2 #DIV/0! #VALUE!
3 #VALUE! #VALUE!
4 #DIV/0! #DIV/0! Area = #VALUE! square feet
5 #DIV/0! #DIV/0! #VALUE! acres
6 #DIV/0! #DIV/0!
7 #DIV/0! #DIV/0!
12.00
8 #DIV/0! #DIV/0!
9 #VALUE! #DIV/0! 10.00
10 #VALUE! #VALUE!
11 0.00 #VALUE! 8.00
12
Y

13 6.00
14
15 4.00
16
17 2.00

18
19 0.00
0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
20
21 X

22
23
24
25
26
27
28
29
30
spreadsheet by M.K. King AreaByCoordinateMethod4-2005.
 =X1*Y2
#VALUE!
#DIV/0!
#VALUE! square meters #VALUE!
#VALUE! hectares #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#VALUE!
#VALUE!
0
0
0
0
0
0
0
0
0.50 0.60 0.70 0.80 0.90 1.00
0
0
0
0
0
0
0
0
0
0
0
AreaByCoordinateMethod4-2005.xls Sum #VALUE!
Difference/2 = #VALUE!

0  L.b
0  L.b/2
#DIV/0! phi radians
#DIV/0! drop
 DATA ENTRY UNITS : US feet

COORDINATES
PAIR X Y
=X2*Y1 1 0 #VALUE!
#VALUE! 2 #DIV/0! #VALUE!
#VALUE! 3 #VALUE! #VALUE!
#VALUE! 4 #DIV/0! #DIV/0! Area = #VALUE!
#DIV/0! 5 #DIV/0! #DIV/0! #VALUE!
#DIV/0! 6 #DIV/0! #DIV/0!
#DIV/0! 7 #DIV/0! #DIV/0!
#DIV/0! 8 #DIV/0! #DIV/0!
#DIV/0! 9 #VALUE! #DIV/0!
#DIV/0! 10 #VALUE! #VALUE!
#VALUE! 11 0 #VALUE!
#VALUE! 12 0 0
0 13 0 0
0 14 0 0
0 15 0 0
12.00
0 16 0 0
0 17 0 0
10.00
0 18 0 0
0 19 0 0
8.00
0 20 0 0
0 21 0 0
Y

6.00
0 22 0 0
0 23 0 0
4.00
0 24 0 0
0 25 0 0
2.00
0 26 0 0
0 27 0 0 0.00
0 28 0 0 0.00 0.10 0.20 0.30 0.40 0.50 0.60
0 29 0 0 X
0 30 0 0
#VALUE! spreadsheet by M.K. King
sq units
 square feet #VALUE! square meters
acres #VALUE! hectares

0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
X

AreaByCoordinateMethod4-2005.xls
 DATA ENTRY UNITS : 1 (1 = US Feet, 2 = Meters)

COORDINATES
PAIR X Y
1 0.00 #VALUE!
2 #VALUE! 0.00
3 #VALUE! 0.00
4 #VALUE! 1.00 Area = #VALUE! square feet
5 #DIV/0! 1.00 #VALUE! acres
6 #DIV/0! #VALUE!
7 0.00 #VALUE!
12.00
8
9 10.00
10
11 8.00
12
Y

13 6.00
14
15 4.00
16
17 2.00

18
19 0.00
0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
20
21 X

22
23 Vertical Drop #VALUE!
24 Horizontal #VALUE!
25 Slope Length #VALUE!
26
27
28
29
30
spreadsheet by M.K. King AreaByCoordinateMethod4-2005.
 =X1*Y2
0
#VALUE!
#VALUE! square meters #VALUE!
#VALUE! hectares #VALUE!
#DIV/0!
#DIV/0!
0
0
0
0
0
0
0
0
0
0
0
0
0.50 0.60 0.70 0.80 0.90 1.00
0
X 0
0
0
0
0
0
0
0
0
0
AreaByCoordinateMethod4-2005.xls Sum #VALUE!
Difference/2 = #VALUE!
 DATA ENTRY UNITS : US feet

COORDINATES
PAIR X Y
=X2*Y1 1 0 #VALUE!
#VALUE! 2 #VALUE! 0
#VALUE! 3 #VALUE! 0
#VALUE! 4 #VALUE! 1 Area = #VALUE!
#DIV/0! 5 #DIV/0! 1 #VALUE!
#DIV/0! 6 #DIV/0! #VALUE!
#VALUE! 7 0 #VALUE!
#VALUE! 8 0 0
0 9 0 0
0 10 0 0
0 11 0 0
0 12 0 0
0 13 0 0
0 14 0 0
0 15 0 0
12.00
0 16 0 0
0 17 0 0
10.00
0 18 0 0
0 19 0 0
8.00
0 20 0 0
0 21 0 0
Y

6.00
0 22 0 0
0 23 0 0
4.00
0 24 0 0
0 25 0 0
2.00
0 26 0 0
0 27 0 0 0.00
0 28 0 0 0.00 0.10 0.20 0.30 0.40 0.50 0.60
0 29 0 0 X
0 30 0 0
#VALUE! spreadsheet by M.K. King
sq units
 square feet #VALUE! square meters
acres #VALUE! hectares

0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
X

AreaByCoordinateMethod4-2005.xls
 DATA ENTRY UNITS : 1 (1 = US Feet, 2 = Meters)

COORDINATES
PAIR X Y
1 0.00 #VALUE!
2 #VALUE! #VALUE!
3 #VALUE! #VALUE!
4 0.00 #VALUE! Area = #VALUE! square feet
5 0.00 #VALUE! #VALUE! acres
6 #VALUE! 0.00
7 #VALUE! 0.00
12.00
8 #VALUE! 1.00
9 #DIV/0! 1.00 10.00
10 #DIV/0! #VALUE!
11 0.00 #VALUE! 8.00
12
13
Y

6.00
14
15 4.00
16
17 2.00

18
19 0.00
0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
20
21 X

22
23
24
25
26
27
28
29
30
spreadsheet by M.K. King AreaByCoordinateMethod4-2005.
 =X1*Y2
#VALUE!
#VALUE!
#VALUE! square meters #VALUE!
#VALUE! hectares #VALUE!
0
#VALUE!
#VALUE!
#VALUE!
#DIV/0!
#DIV/0!
0
0
0
0
0
0
0
0
0.50 0.60 0.70 0.80 0.90 1.00
0
0
0
0
0
0
0
0
0
0
0
AreaByCoordinateMethod4-2005.xls Sum #VALUE!
Difference/2 = #VALUE!
 DATA ENTRY UNITS : US feet

COORDINATES
PAIR X Y
=X2*Y1 1 0 #VALUE!
#VALUE! 2 #VALUE! #VALUE!
#VALUE! 3 #VALUE! #VALUE!
#VALUE! 4 0 #VALUE! Area = #VALUE!
#VALUE! 5 0 #VALUE! #VALUE!
#VALUE! 6 #VALUE! 0
#VALUE! 7 #VALUE! 0
#VALUE! 8 #VALUE! 1
#DIV/0! 9 #DIV/0! 1
#DIV/0! 10 #DIV/0! #VALUE!
#VALUE! 11 0 #VALUE!
#VALUE! 12 0 0
0 13 0 0
0 14 0 0
0 15 0 0
12.00
0 16 0 0
0 17 0 0
10.00
0 18 0 0
0 19 0 0
8.00
0 20 0 0
0 21 0 0
Y

6.00
0 22 0 0
0 23 0 0
4.00
0 24 0 0
0 25 0 0
2.00
0 26 0 0
0 27 0 0 0.00
0 28 0 0 0.00 0.10 0.20 0.30 0.40 0.50 0.60
0 29 0 0 X
0 30 0 0
#VALUE! spreadsheet by M.K. King
sq units
 square feet #VALUE! square meters
acres #VALUE! hectares

0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
X

AreaByCoordinateMethod4-2005.xls
 DATA ENTRY UNITS : 1 (1 = US Feet, 2 = Meters)

COORDINATES
PAIR X Y
1 0.00 #VALUE!
2 #VALUE! 0.00
3 #VALUE! 0.00
4 #DIV/0! #VALUE! Area = #VALUE! square feet
5 0.00 #VALUE! #VALUE! acres
6
7
12.00
8
9 10.00
10
11 8.00
12
Y

13 6.00
14
15 4.00
16
17 2.00

18
19 0.00
0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
20
21 X

22
23 Vertical Drop #VALUE!
24 Horizontal #VALUE!
25 Slope Length #VALUE!
26
27
28
29
30
spreadsheet by M.K. King AreaByCoordinateMethod4-2005.

z= 0 
phi= 0 
pair 3 opp= 0 
pair 3 adj= 1 
Trock= 12 
 =X1*Y2
0
#VALUE!
#VALUE! square meters #VALUE!
#VALUE! hectares #DIV/0!
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.50 0.60 0.70 0.80 0.90 1.00
0
X 0
0
0
0
0
0
0
0
0
0
AreaByCoordinateMethod4-2005.xls Sum #VALUE!
Difference/2 = #VALUE!
 DATA ENTRY UNITS : US feet

COORDINATES
PAIR X Y
=X2*Y1 1 0 #VALUE!
#VALUE! 2 #VALUE! 0
#VALUE! 3 #VALUE! 0
#DIV/0! 4 #DIV/0! #VALUE! Area = #VALUE!
#VALUE! 5 0 #VALUE! #VALUE!
#VALUE! 6 0 0
0 7 0 0
0 8 0 0
0 9 0 0
0 10 0 0
0 11 0 0
0 12 0 0
0 13 0 0
0 14 0 0
0 15 0 0
12.00
0 16 0 0
0 17 0 0
10.00
0 18 0 0
0 19 0 0
8.00
0 20 0 0
0 21 0 0
Y

6.00
0 22 0 0
0 23 0 0
4.00
0 24 0 0
0 25 0 0
2.00
0 26 0 0
0 27 0 0 0.00
0 28 0 0 0.00 0.10 0.20 0.30 0.40 0.50 0.60
0 29 0 0 X
0 30 0 0
#VALUE! spreadsheet by M.K. King
sq units
 square feet #VALUE! square meters
acres #VALUE! hectares

0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
X

AreaByCoordinateMethod4-2005.xls
 DATA ENTRY UNITS : 1 (1 = US Feet, 2 = Meters)

COORDINATES
PAIR X Y
1 0.00 #VALUE!
2 #VALUE! #VALUE!
3 #VALUE! #VALUE!
4 #DIV/0! #VALUE! Area = #VALUE! square feet
5 #VALUE! 0.00 #VALUE! acres
6 #VALUE! 0.00
7 #DIV/0! #VALUE!
12.00
8 0.00 #VALUE!
9 10.00
10
11 8.00
12
13
Y

6.00
14
15 4.00
16
17 2.00

18
19 0.00
0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
20
21 X

22
23
24
25
26
27
28
29
30
spreadsheet by M.K. King AreaByCoordinateMethod4-2005.

z= 0 
phi= 0 
pair 6 opp= 0 
pair 6 adj= 1 
Trock= 12 
theta= #DIV/0!
 =X1*Y2
#VALUE!
#VALUE!
#VALUE! square meters #VALUE!
#VALUE! hectares #DIV/0!
#VALUE!
#VALUE!
#DIV/0!
0
0
0
0
0
0
0
0
0
0
0
0.50 0.60 0.70 0.80 0.90 1.00
0
X 0
0
0
0
0
0
0
0
0
0
AreaByCoordinateMethod4-2005.xls Sum #VALUE!
Difference/2 = #VALUE!
 DATA ENTRY UNITS : US feet

COORDINATES
PAIR X Y
=X2*Y1 1 0 #VALUE!
#VALUE! 2 #VALUE! #VALUE!
#VALUE! 3 #VALUE! #VALUE!
#VALUE! 4 #DIV/0! #VALUE! Area = #VALUE!
#VALUE! 5 #VALUE! 0 #VALUE!
#VALUE! 6 #VALUE! 0
#DIV/0! 7 #DIV/0! #VALUE!
#VALUE! 8 0 #VALUE!
#VALUE! 9 0 0
0 10 0 0
0 11 0 0
0 12 0 0
0 13 0 0
0 14 0 0
0 15 0 0
12.00
0 16 0 0
0 17 0 0
10.00
0 18 0 0
0 19 0 0
8.00
0 20 0 0
0 21 0 0
Y

6.00
0 22 0 0
0 23 0 0
4.00
0 24 0 0
0 25 0 0
2.00
0 26 0 0
0 27 0 0 0.00
0 28 0 0 0.00 0.10 0.20 0.30 0.40 0.50 0.
0 29 0 0 X
0 30 0 0
#VALUE! spreadsheet by M.K. King
sq units
 square feet #VALUE! square meters
acres #VALUE! hectares

.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
X

AreaByCoordinateMethod4-2005.xls
LAKESHORE RIPRAP DESIGN COMPUTATIONS SPREADSHEET - DRAFT ver 7.12 (Draft)

CLIENT: Example COUNTY: Dodge DATE: 04/23/19

DSN BY: SRS CHK BY: DATE:
COMMENTS: Beaver Dam Lake
*****************************************************************************************************************************
Average Depth Across Longest Fetch
Station No. (min. of 5) Depth (ft.)
1 26
2 26
3 26 Storm Wind Speed (S) = 35 mph
4 26 Wave Period (T) = 3.31 Seconds
5 26 Wave Length (L) = 56.11 Feet
Longest Fetch (F) = 31,500 Feet
Average Depth (d) = 26 Feet 5.97 Miles
d/L = 0.46
Wave type is Transitional Wave

Hazard Class of Site: 3

(1=Low, 2=Med, 3=High)
Wave Height Design
Wave Height (Hs) = 2.4 Feet
High Hazard Wave Height (Ho) = 4.0 Feet (Likely need individual DNR permit)
Input Slope Ratio of Revetment (i.e. 2:1): 2 (USE ONLY 1.5, 2, 3, 4, 5, 6, or 10)
Ho/L = 0.07
Runup (R) = 6.3 Feet Setup (S) = 0.4 Feet
Elevation Design
Ordinary High Water Elevation = 950.0
Normal Yearly Low Lake Elevation = 950.0
Average Top Elevation of Existing Bank = 960.0
Lake Bottom Elevation at Shoreline = 945.0
Lower Limit For Protection = 946.4 Calc 946.4 Used
Upper Limit For Protection = 952.4 Calc 952.4 Used
No Overtopping Pad Needed Calc Used
Rock Design

Shape of Rock: 1=Cubical 2=Sperical 2

d50 Rock Size = 17.4 Inches (Calc) 4 Inches (Used)
Rock Thickness = 12.0 Inches
Toe Type (A,B,C, or boulDer): c Lc = 12 feet
Length of Shoreline= 50 Feet Riprap Gradation
Quantities % Passing Size of Stone (Inches)
Riprap: #VALUE! Cu. Yds. 100 8 to 10
Geotextile: #VALUE! Sq. Yds. 85 6.4 to 8
Filter: #VALUE! Cu. Yds. 50 4 to 6
15 1.2 to 2