Spreadsheet: 466746d1466428711-workbook-opens-slowly-after-protecting-all-worksheets-sediment-basin-designer
Sheet: Metadata

SURFACE DESCRIPTION | A | B | C | D |  | Counties List |  | Sheet Flow Descriptions List | n value |  | Channel Surface Description Types | n value |  | Ia Table |  |  | Pipe Flow Chart |  |  |  |  |  |  |  |  |  | Design Data for Earth Spillways |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Computations to Determine Emergency Spillway Data
 | 2 | 3 | 4 | 5 |  | Appling |  |  |  |  |  |  |  |  |  |  | H (ft) | 8 | 12 | 18 | 24 | 30 | 36 | 42 | 48 |  | Stage (Hp) in Feet | Spillway Variables | [NAME] (b) in Feet
1 ACRE LOTS | 51 | 68 | 79 | 84 |  | Atkinson |  | Smooth surface | 0.011 |  | Aluminum | 0.024 |  | 40 | 3 |  | 3 | 1.22 | 3.43 | 9.48 | 19.1 | 32.6 | 49.9 | 71.2 | 96.5 |  |  |  | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  |  |  |  | Emergency Spillway Design Options List (blanks) | Emergency Spillway Design Options List (no blanks) | Minimum Stage Height | Minimum [NAME] | Minimum Velocity | Minimum Slope
1/2 ACRE LOTS | 54 | 70 | 80 | 85 |  | Bacon |  | Bermuda grass | 0.41 |  | Asphalt ditch (rough) | 0.016 |  | 41 | 2.878 |  | 4 | 1.4 | 3.97 | 10.9 | 22.1 | 37.6 | 57.7 | 82.3 | 111 |  | 0.5 | Q | 6 | 7 | 8 | 10 | 11 | 13 | 14 | 15 | 17 | 18 | 20 | 21 | 22 | 24 | 25 | 27 | 28 | 4
1/3 ACRE LOTS | 57 | 72 | 81 | 86 |  | [NAME] |  | Cult. Soil (RC < 20%) | 0.06 |  | Asphalt ditch (smooth) | 0.013 |  | 42 | 2.762 |  | 5 | 1.57 | 4.43 | 12.2 | 24.7 | 42.1 | 64.5 | 92 | 125 |  | 0.5 | Vc | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 5
1/4 ACRE LOTS | 61 | 75 | 83 | 87 |  | Baldwin |  | Cult. Soil (RC > 20%) | 0.17 |  | [NAME] | 0.02 |  | 43 | 2.651 |  | 6 | 1.72 | 4.86 | 13.4 | 27 | 46.1 | 70.6 | 101 | 136 |  | 0.5 | Sc | 3.9 | 3.9 | 3.9 | 3.9 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 6
1/8 ACRE OR LESS LOTS (TOWN HOUSES) | 77 | 85 | 90 | 92 |  | Banks |  | Dense grass | 0.24 |  | Concrete | 0.013 |  | 44 | 2.545 |  | 7 | 1.86 | 5.25 | 14.5 | 29.2 | 49.8 | 76.3 | 109 | 147 |  | 0.6 | Q | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 35 | 37 | 39 | 7
2 ACRE LOTS | 46 | 65 | 77 | 82 |  | Barrow |  | Dense underbrush | 0.8 |  | Copper | 0.011 |  | 45 | 2.444 |  | 8 | 1.99 | 5.61 | 15.5 | 31.2 | 53.2 | 81.5 | 116 | 158 |  | 0.6 | Vc | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 8
BRUSH (BRUSH-WEED-GRASS WITH BRUSH MAJOR ELEMENT); FAIR CONDITION | 35 | 56 | 70 | 77 |  | Bartow |  | Fallow | 0.05 |  | Flood plain, brush | 0.06 |  | 46 | 2.348 |  | 9 | 2.11 | 5.95 | 16.4 | 33.1 | 56.4 | 86.5 | 123 | 167 |  | 0.6 | Sc | 3.7 | 3.7 | 3.7 | 3.7 | 3.6 | 3.7 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 9
BRUSH (BRUSH-WEED-GRASS WITH BRUSH MAJOR ELEMENT); GOOD CONDITION | 30 | 48 | 65 | 73 |  | [NAME] |  | Light underbrush | 0.4 |  | Flood plain, cultivated | 0.035 |  | 47 | 2.255 |  | 10 | 2.22 | 6.27 | 17.3 | 34.9 | 59.5 | 91.2 | 130 | 176 |  | 0.7 | Q | 11 | 13 | 16 | 18 | 20 | 23 | 25 | 28 | 30 | 33 | 35 | 38 | 41 | 43 | 44 | 46 | 48 | 10
BRUSH (BRUSH-WEED-GRASS WITH BRUSH MAJOR ELEMENT); POOR CONDITION | 48 | 67 | 77 | 83 |  | [NAME] |  | Prairie grass | 0.15 |  | [NAME] | 0.011 |  | 48 | 2.167 |  | 11 | 2.33 | 6.58 | 18.2 | 36.6 | 62.4 | 95.6 | 136 | 185 |  | 0.7 | Vc | 3.2 | 3.2 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 11
CLOSE SEEDED; CONTOURED & TERRACED; GOOD CONDITION | 51 | 67 | 76 | 80 |  | Bibb |  | Range | 0.13 |  | Natural stream, clean | 0.03 |  | 49 | 2.082 |  | 12 | 2.43 | 6.87 | 19 | 38.2 | 65.2 | 99.9 | 142 | 193 |  | 0.7 | Sc | 3.5 | 3.5 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 | 12
CLOSE SEEDED; CONTOURED & TERRACED; POOR CONDITION | 63 | 73 | 80 | 83 |  | Bleckley |  |  |  |  | Natural stream, stony notes | 0.05 |  | 50 | 2 |  | 13 | 2.53 | 7.15 | 19.7 | 39.8 | 67.8 | 104 | 148 | 201 |  | 0.8 | Q | 13 | 16 | 19 | 22 | 26 | 29 | 32 | 35 | 38 | 42 | 45 | 46 | 48 | 51 | 54 | 57 | 60 | 13
CLOSE SEEDED; CONTOURED; GOOD CONDITION | 55 | 69 | 78 | 83 |  | Brantley |  |  |  |  | Natural stream, weedy | 0.045 |  | 51 | 1.922 |  | 14 | 2.63 | 7.42 | 20.5 | 41.3 | 70.4 | 108 | 154 | 208 |  | 0.8 | Vc | 3.5 | 3.5 | 3.5 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 14
CLOSE SEEDED; CONTOURED; POOR CONDITION | 64 | 75 | 83 | 85 |  | Brooks |  |  |  |  | Rock rip rap, 150 mm | 0.069 |  | 52 | 1.846 |  | 15 | 2.72 | 7.68 | 21.2 | 42.8 | 72.8 | 112 | 159 | 216 |  | 0.8 | Sc | 3.3 | 3.3 | 3.3 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 15
CLOSE SEEDED; STRAIGHT ROW; GOOD CONDITION | 58 | 72 | 81 | 85 |  | [NAME] |  |  |  |  | Rock rip rap, 300 mm | 0.078 |  | 53 | 1.774 |  | 16 | 2.81 | 7.93 | 21.9 | 44.2 | 75.2 | 115 | 165 | 223 |  | 0.9 | Q | 17 | 20 | 24 | 28 | 32 | 35 | 39 | 43 | 47 | 51 | 53 | 57 | 60 | 64 | 68 | 71 | 75 | 16
CLOSE SEEDED; STRAIGHT ROW; POOR CONDITION | 66 | 77 | 85 | 89 |  | [NAME] |  |  |  |  | Rough earth | 0.035 |  | 54 | 1.704 |  | 17 | 2.9 | 8.18 | 22.6 | 45.5 | 77.5 | 119 | 170 | 230 |  | 0.9 | Vc | 3.7 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 17
[NAME] | 72 | 82 | 87 | 89 |  | Burke |  |  |  |  | Rough rocks | 0.04 |  | 55 | 1.636 |  | 18 | 2.98 | 8.41 | 23.2 | 46.8 | 79.8 | 120 | 174 | 236 |  | 0.9 | Sc | 3.2 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 18
FALLOW; BARE SOIL | 77 | 86 | 91 | 94 |  | Butts |  |  |  |  | Soil cement | 0.022 |  | 56 | 1.571 |  | 19 | 3.06 | 8.64 | 23.9 | 48.1 | 82 | 126 | 179 | 243 |  | 1 | Q | 20 | 24 | 29 | 33 | 38 | 42 | 47 | 51 | 56 | 61 | 63 | 68 | 72 | 77 | 81 | 86 | 90 | 19
FALLOW; CROP RESIDUE COVER; GOOD CONDITION | 74 | 83 | 88 | 90 |  | [NAME] |  |  |  |  | Steel | 0.013 |  | 57 | 1.509 |  | 20 | 3.14 | 8.87 | 24.5 | 49.4 | 84.1 | 129 | 184 | 249 |  | 1 | Vc | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 20
FALLOW; CROP RESIDUE COVER; POOR CONDITION | 76 | 85 | 90 | 93 |  | Camden |  |  |  |  |  |  |  | 58 | 1.448 |  |  | 8 | 12 | 18 | 24 | 30 | 36 | 42 | 48 |  | 1 | Sc | 3.1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 21
FARMSTEADS - BUILDINGS, LANES, DRIVEWAYS, SURROUNDING LOTS | 59 | 74 | 82 | 86 |  | Candler |  |  |  |  |  |  |  | 59 | 1.39 |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 1.1 | Q | 23 | 28 | 34 | 39 | 44 | 49 | 54 | 60 | 65 | 70 | 74 | 79 | 84 | 89 | 95 | 100 | 105 | 22
GRAVEL ROADS | 76 | 85 | 89 | 91 |  | Carroll |  | Shallow Concentrated Flow Types | k value |  |  |  |  | 60 | 1.333 |  | 30 | 1.41 | 1.36 | 1.29 | 1.24 | 1.21 | 1.18 | 1.15 | 1.13 |  | 1.1 | Vc | 4.2 | 4.2 | 4.2 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 | 23
MEADOW (PROTECTED FROM GRAZING; MOWED FOR HAY) | 30 | 58 | 71 | 78 |  | Catoosa |  | [NAME] | 0.457 |  |  |  |  | 61 | 1.279 |  | 40 | 1.27 | 1.23 | 1.2 | 1.17 | 1.14 | 1.12 | 1.11 | 1.1 |  | 1.1 | Sc | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 24
OPEN SPACE; FAIR CONDITION | 49 | 69 | 79 | 84 |  | Charlton |  | Unpaved | 0.491 |  |  |  |  | 62 | 1.226 |  | 50 | 1.16 | 1.14 | 1.12 | 1.1 | 1.09 | 1.08 | 1.07 | 1.06 |  | 1.2 | Q | 28 | 33 | 40 | 45 | 51 | 58 | 64 | 69 | 76 | 80 | 86 | 92 | 98 | 104 | 110 | 116 | 122 | 25
OPEN SPACE; GOOD CONDITION | 39 | 61 | 74 | 80 |  | Chatham |  | Paved Area | 0.619 |  |  |  |  | 63 | 1.175 |  | 60 | 1.07 | 1.06 | 1.05 | 1.05 | 1.04 | 1.04 | 1.03 | 1.03 |  | 1.2 | Vc | 4.4 | 4.4 | 4.4 | 4.4 | 4.4 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 26
OPEN SPACE; POOR CONDITION | 68 | 79 | 86 | 89 |  | Chattahoochee |  |  |  |  |  |  |  | 64 | 1.125 |  | 70 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1.2 | Sc | 2.9 | 2.9 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 27
PASTURE, [NAME], OR RANGE (FOR GRAZING); FAIR CONDITION | 49 | 69 | 79 | 84 |  | Chattooga |  |  |  |  |  |  |  | 65 | 1.077 |  | 80 | 0.94 | 0.95 | 0.95 | 0.96 | 0.96 | 0.97 | 0.97 | 0.97 |  | 1.3 | Q | 32 | 38 | 46 | 53 | 58 | 65 | 73 | 80 | 86 | 91 | 99 | 106 | 112 | 119 | 125 | 133 | 140 | 28
PASTURE, [NAME], OR RANGE (FOR GRAZING); GOOD CONDITION | 39 | 61 | 74 | 80 |  | Cherokee |  |  |  |  |  |  |  | 66 | 1.03 |  | 90 | 0.89 | 0.9 | 0.91 | 0.92 | 0.93 | 0.94 | 0.94 | 0.95 |  | 1.3 | Vc | 4.5 | 4.6 | 4.6 | 4.6 | 4.6 | 4.6 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 | 29
PASTURE, [NAME], OR RANGE (FOR GRAZING); POOR CONDITION | 68 | 79 | 86 | 89 |  | Clarke |  | Rainfall Distribution Types |  |  |  |  |  | 67 | 0.985 |  | 100 | 0.85 | 0.86 | 0.88 | 0.89 | 0.9 | 0.91 | 0.92 | 0.93 |  | 1.3 | Sc | 2.8 | 2.8 | 2.8 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 30
PAVED PARKING LOTS, DRIVEWAYS, ETC. | 98 | 98 | 98 | 98 |  | Clay |  | I |  |  |  |  |  | 68 | 0.941 |  | 120 | 0.79 | 0.8 | 0.82 | 0.83 | 0.85 | 0.86 | 0.87 | 0.89 |  | 1.4 | Q | 37 | 44 | 51 | 59 | 66 | 74 | 82 | 90 | 96 | 103 | 111 | 119 | 127 | 134 | 142 | 150 | 158 | 31
PAVED STREET; OPEN DITCHES | 83 | 89 | 92 | 83 |  | [NAME] |  | IA |  |  |  |  |  | 69 | 0.899 |  | 140 | 0.73 | 0.75 | 0.77 | 0.79 | 0.81 | 0.82 | 0.84 | 0.85 |  | 1.4 | Vc | 4.7 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 | 4.9 | 4.9 | 4.9 | 4.9 | 4.9 | 4.9 | 4.9 | 4.9 | 32
PAVED STREETS; CURB AND STORM SEWERS | 98 | 98 | 98 | 98 |  | Clinch |  | II |  |  |  |  |  | 70 | 0.857 |  | 160 | 0.69 | 0.7 | 0.73 | 0.75 | 0.77 | 0.79 | 0.8 | 0.82 |  | 1.4 | Sc | 2.8 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 33
ROW CROPS; CONTOURED & CROP RESIDUE; GOOD CONDITION | 64 | 74 | 81 | 85 |  | Cobb |  | III |  |  |  |  |  | 71 | 0.817 |  |  |  |  |  |  |  |  |  |  |  | 1.5 | Q | 41 | 50 | 58 | 66 | 75 | 85 | 92 | 101 | 108 | 116 | 125 | 133 | 142 | 150 | 160 | 169 | 178 | 34
ROW CROPS; CONTOURED & CROP RESIDUE; POOR CONDITION | 69 | 78 | 83 | 87 |  | Coffee |  |  |  |  |  |  |  | 72 | 0.778 |  |  |  |  |  |  |  |  |  |  |  | 1.5 | Vc | 4.8 | 4.9 | 4.9 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5.1 | 5.1 | 5.1 | 35
ROW CROPS; CONTOURED & TERRACED WITH CROP RESIDUE; GOOD CONDITION | 61 | 70 | 77 | 80 |  | Colquitt |  |  |  |  |  |  |  | 73 | 0.74 |  |  |  |  |  |  |  |  |  |  |  | 1.5 | Sc | 2.7 | 2.7 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.5 | 2.5 | 2.5 | 36
ROW CROPS; CONTOURED & TERRACED WITH CROP RESIDUE; POOR CONDITION | 65 | 73 | 79 | 81 |  | Columbia |  |  |  |  |  |  |  | 74 | 0.703 |  |  |  |  |  |  |  |  |  |  |  | 1.6 | Q | 46 | 56 | 65 | 75 | 84 | 94 | 104 | 112 | 122 | 132 | 142 | 149 | 158 | 168 | 178 | 187 | 197 | 37
ROW CROPS; CONTOURED & TERRACED; GOOD CONDITION | 62 | 71 | 78 | 81 |  | [NAME] |  |  |  |  |  |  |  | 75 | 0.667 |  |  |  |  |  |  |  |  |  |  |  | 1.6 | Vc | 5 | 5.1 | 5.1 | 5.1 | 5.1 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 38
ROW CROPS; CONTOURED & TERRACED; POOR CONDITION | 66 | 74 | 80 | 82 |  | Coweta |  |  |  |  |  |  |  | 76 | 0.632 |  |  |  |  |  |  |  |  |  |  |  | 1.6 | Sc | 2.6 | 2.6 | 2.6 | 2.6 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 39
ROW CROPS; CONTOURED; GOOD CONDITION | 65 | 75 | 82 | 86 |  | Crawford |  |  |  |  |  |  |  | 77 | 0.597 |  |  |  |  |  |  |  |  |  |  |  | 1.7 | Q | 52 | 62 | 72 | 83 | 94 | 105 | 115 | 126 | 135 | 145 | 156 | 167 | 175 | 187 | 196 | 206 | 217 | 40
ROW CROPS; CONTOURED; POOR CONDITION | 70 | 79 | 84 | 88 |  | Crisp |  |  |  |  |  |  |  | 78 | 0.564 |  |  |  |  |  |  |  |  |  |  |  | 1.7 | Vc | 5.2 | 5.2 | 5.2 | 5.3 | 5.3 | 5.3 | 5.3 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 41
ROW CROPS; STRAIGHT ROW & CROP RESIDUE; GOOD CONDITION | 64 | 75 | 82 | 85 |  | Dade |  |  |  |  |  |  |  | 79 | 0.532 |  |  |  |  |  |  |  |  |  |  |  | 1.7 | Sc | 2.6 | 2.6 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 42
ROW CROPS; STRAIGHT ROW & CROP RESIDUE; POOR CONDITION | 71 | 80 | 87 | 90 |  | Dawson |  | Riser Pipe Diamter (in.) | Buoyant Force (lbs/V.F. of Riser Height) | Volume of Concrete/V.F. of Riser Height (ft3/V.F.) Needed to Prevent Flotation | Note: the volumes here are more accurate than Table 6-29.3 of the GWCC Sediment Manual.  NRCA was contacted to provide a volume for 42" pipes since it is missing from the chart, and they provided a spreadsheet that did not use the same Factor of Safety for all pipe sizes (it varied). A Factor of Safety of 2.1 was used here for all pipe sizes. |  |  | 80 | 0.5 |  |  |  |  |  |  |  |  |  |  |  | 1.8 | Q | 58 | 69 | 81 | 93 | 104 | 116 | 127 | 138 | 150 | 160 | 171 | 182 | 194 | 204 | 214 | 226 | 233 | 43
ROW CROPS; STRAIGHT ROW; GOOD CONDITION | 67 | 78 | 85 | 89 |  | Decatur |  |  |  |  |  |  |  | 81 | 0.469 |  |  |  |  |  |  |  |  |  |  |  | 1.8 | Vc | 5.3 | 5.4 | 5.4 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.6 | 5.6 | 5.6 | 5.6 | 5.6 | 5.6 | 44
ROW CROPS; STRAIGHT ROW; POOR CONDITION | 72 | 81 | 88 | 91 |  | DeKalb |  |  |  |  |  |  |  | 82 | 0.439 |  |  |  |  |  |  |  |  |  |  |  | 1.8 | Sc | 2.5 | 2.5 | 2.5 | 2.5 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 45
SMALL GRAIN; CONTOURED & CROP RESIDUE; GOOD CONDITION | 60 | 72 | 80 | 83 |  | Dodge |  |  |  |  |  |  |  | 83 | 0.41 |  |  |  |  |  |  |  |  |  |  |  | 1.9 | Q | 64 | 76 | 88 | 102 | 114 | 127 | 140 | 152 | 164 | 175 | 188 | 201 | 213 | 225 | 235 | 248 | 260 | 46
SMALL GRAIN; CONTOURED & CROP RESIDUE; POOR CONDITION | 62 | 73 | 81 | 84 |  | Dooly |  | 12 |  |  |  |  |  | 84 | 0.381 |  |  |  |  |  |  |  |  |  |  |  | 1.9 | Vc | 5.5 | 5.5 | 5.5 | 5.6 | 5.6 | 5.6 | 5.7 | 5.7 | 5.7 | 5.7 | 5.7 | 5.7 | 5.7 | 5.7 | 5.7 | 5.7 | 5.7 | 47
SMALL GRAIN; CONTOURED & TERRACED WITH CROP RESIDUE; GOOD CONDITION | 58 | 69 | 77 | 80 |  | [NAME] |  | 18 |  |  |  |  |  | 85 | 0.353 |  |  |  |  |  |  |  |  |  |  |  | 1.9 | Sc | 2.5 | 2.5 | 2.5 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 48
SMALL GRAIN; CONTOURED & TERRACED WITH CROP RESIDUE; POOR CONDITION | 60 | 71 | 78 | 81 |  | [NAME] |  | 24 |  |  |  |  |  | 86 | 0.326 |  |  |  |  |  |  |  |  |  |  |  | 2 | Q | 71 | 83 | 97 | 111 | 125 | 138 | 153 | 164 | 178 | 193 | 204 | 218 | 232 | 245 | 256 | 269 | 283 | 49
SMALL GRAIN; CONTOURED & TERRACED; GOOD CONDITION | 59 | 70 | 78 | 81 |  | Early |  | 30 |  |  |  |  |  | 87 | 0.299 |  |  |  |  |  |  |  |  |  |  |  | 2 | Vc | 5.6 | 5.7 | 5.7 | 5.7 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 | 5.9 | 5.9 | 5.9 | 5.9 | 5.9 | 5.9 | 50
SMALL GRAIN; CONTOURED & TERRACED; POOR CONDITION | 61 | 72 | 79 | 82 |  | [NAME] |  | 36 |  |  |  |  |  | 88 | 0.273 |  |  |  |  |  |  |  |  |  |  |  | 2 | Sc | 2.5 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 51
SMALL GRAIN; CONTOURED; GOOD CONDITION | 61 | 73 | 81 | 84 |  | [NAME] |  | 42 |  |  |  |  |  | 89 | 0.247 |  |  |  |  |  |  |  |  |  |  |  | 2.1 | Q | 77 | 91 | 107 | 122 | 135 | 149 | 162 | 177 | 192 | 207 | 220 | 234 | 250 | 267 | 276 | 291 | 305 | 52
SMALL GRAIN; CONTOURED; POOR CONDITION | 63 | 74 | 82 | 85 |  | Elbert |  | 48 |  |  |  |  |  | 90 | 0.222 |  |  |  |  |  |  |  |  |  |  |  | 2.1 | Vc | 5.7 | 5.8 | 5.9 | 5.9 | 5.9 | 5.9 | 5.9 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Values:
SMALL GRAIN; STRAIGHT ROW & CROP RESIDUE; GOOD CONDITION | 60 | 72 | 80 | 84 |  | Emanuel |  | 54 |  |  |  |  |  | 91 | 0.198 |  |  |  |  |  |  |  |  |  |  |  | 2.1 | Sc | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 54
SMALL GRAIN; STRAIGHT ROW & CROP RESIDUE; POOR CONDITION | 64 | 75 | 83 | 86 |  | Evans |  | 60 |  |  |  |  |  | 92 | 0.174
SMALL GRAIN; STRAIGHT ROW; GOOD CONDITION | 63 | 75 | 83 | 87 |  | Fannin |  |  |  |  |  |  |  | 93 | 0.151 |  |  |  |  |  |  |  |  |  | Basin Dimension Calculations Assumption: inside radius of bottom corners of basin = 3' (to modify this radius, edit cell AA60 below); to model a rectangular trapezoidal prism basin without rounded corners, enter zero for the radius. NOTE: this dimension is not specified in GA Detail D-22A and is used as an approximation to more closely model what is constructed
SMALL GRAIN; STRIAGHT ROW; POOR CONDITION | 65 | 76 | 84 | 88 |  | Fayette |  |  |  |  |  |  |  | 94 | 0.128
URBAN COMMERCIAL AND BUSINESS DISTRICTS | 89 | 92 | 94 | 95 |  | [NAME] |  |  |  |  |  |  |  | 95 | 0.105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skimmer Orifice Diameters
URBAN INDUSTRIAL DISTRICTS | 81 | 88 | 91 | 93 |  | [NAME] |  |  |  |  |  |  |  | 96 | 0.083 |  |  |  |  |  |  |  |  |  |  |  | [NAME] of Basin at Riser Crest Iterations | [NAME] of Basin at Bottom Iterations | Length of Basin at Riser Crest Iterations | Length of Basin at Bottom Iterations | Depth/Height of Basin | Slope of Basin Interior | Iterative Storage Volumes | Iterative Storage Volume Differences |  |  |  |  |  | Q= |  |  |  |  |  | 1
WOODS; FAIR CONDITION | 45 | 66 | 77 | 83 |  | Franklin |  |  |  |  |  |  |  | 97 | 0.062 |  |  |  |  |  |  |  |  |  | Inside Radius of corners at the bottom of basin= | 3 | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
WOODS; GOOD CONDITION | 36 | 60 | 73 | 79 |  | Fulton |  |  |  |  |  |  |  | 98 | 0.041 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D= |  |  |  |  |  | 2
WOODS; POOR CONDITION | 30 | 55 | 70 | 77 |  | Gilmer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5 |  |  |  |  |  | 2.5
WOODS - GRASS COMBINATION (ORCHARD OR TREE FARM); FAIR CONDITION | 57 | 73 | 82 | 86 |  | Glascock |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
WOODS - GRASS COMBINATION (ORCHARD OR TREE FARM); GOOD CONDITION | 43 | 65 | 76 | 82 |  | Glynn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Design Width of Basin at Riser Crest = |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
WOODS - GRASS COMBINATION (ORCHARD OR TREE FARM); POOR CONDITION | 32 | 58 | 72 | 79 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  | Grady |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  | Greene
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rounded Up Width of Basin at Crest=
 |  |  |  |  |  | Hall |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Storage Volume using rounded dimensions
 |  |  |  |  |  | Hancock
 |  |  |  |  |  | Haralson
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Hart
 |  |  |  |  |  | Heard
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Houston
 |  |  |  |  |  | Irwin
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Jasper
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Jenkins
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Jones
 |  |  |  |  |  | Lamar
 |  |  |  |  |  | Lanier
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Liberty
 |  |  |  |  |  | Lincoln
 |  |  |  |  |  | Long
 |  |  |  |  |  | Lowndes
 |  |  |  |  |  | Lumpkin
 |  |  |  |  |  | Macon
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Marion
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | McIntosh
 |  |  |  |  |  | Meriwether
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Mitchell
 |  |  |  |  |  | Monroe
 |  |  |  |  |  | Montgomery
 |  |  |  |  |  | Morgan
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Muscogee
 |  |  |  |  |  | Newton
 |  |  |  |  |  | Oconee
 |  |  |  |  |  | Oglethorpe
 |  |  |  |  |  | Paulding
 |  |  |  |  |  | Peach
 |  |  |  |  |  | Pickens
 |  |  |  |  |  | Pierce |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Dimensions
 |  |  |  |  |  | Pike
 |  |  |  |  |  | Polk
 |  |  |  |  |  | Pulaski
 |  |  |  |  |  | Putnam
 |  |  |  |  |  | Quitman
 |  |  |  |  |  | Rabun
 |  |  |  |  |  | Randolph
 |  |  |  |  |  | Richmond
 |  |  |  |  |  | Rockdale
 |  |  |  |  |  | Schley
 |  |  |  |  |  | Screven
 |  |  |  |  |  | Seminole
 |  |  |  |  |  | Spalding
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Sumter
 |  |  |  |  |  | Talbot
 |  |  |  |  |  | Taliaferro
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Telfair
 |  |  |  |  |  | Terrell
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Tift
 |  |  |  |  |  | Toombs
 |  |  |  |  |  | Towns
 |  |  |  |  |  | Treutlen
 |  |  |  |  |  | Troup
 |  |  |  |  |  | Turner
 |  |  |  |  |  | Twiggs
 |  |  |  |  |  | Union
 |  |  |  |  |  | Upson
 |  |  |  |  |  | Walker
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Ware
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Washington
 |  |  |  |  |  | Wayne
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Wheeler
 |  |  |  |  |  | White
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Wilcox
 |  |  |  |  |  | Wilkes
 |  |  |  |  |  | Wilkinson
 |  |  |  |  |  | Worth
 | Unit [NAME] (qu) Calculations
 | Storm 1
 | Rainfall type | Ia/P | C0 | C1 | C2 |  |  |  |  | Unit [NAME] (qu) | Unit [NAME] (qu) Final Values
 | I-0.1 | 0.1 | 2.3055 | -0.51429 | -0.1175
 | I-0.2 | 0.2 | 2.23537 | -0.50387 | -0.08929
 | I-0.25 | 0.25 | 2.18219 | -0.48488 | -0.06589
 | I-0.3 | 0.3 | 2.10624 | -0.45695 | -0.02835
 | I-0.35 | 0.35 | 2.00303 | -0.40769 | 0.01983
 | I-0.4 | 0.4 | 1.87733 | -0.32274 | 0.05754
 | I-0.45 | 0.45 | 1.76312 | -0.15644 | 0.00453
 | I-0.5 | 0.5 | 1.67889 | -0.0693 | 0
 | IA-0.1 | 0.1 | 2.0325 | -0.31583 | -0.13748
 | IA-0.2 | 0.2 | 1.91978 | -0.28215 | -0.0702
 | IA-0.25 | 0.25 | 1.83842 | -0.25543 | -0.02597
 | IA-0.3 | 0.3 | 1.72657 | -0.19826 | 0.02633
 | IA-0.5 | 0.5 | 1.63417 | -0.091 | 0
 | II-0.1 | 0.1 | 2.55323 | -0.61512 | -0.16403
 | II-0.3 | 0.3 | 2.46532 | -0.62257 | -0.11657
 | II-0.35 | 0.35 | 2.41896 | -0.61594 | -0.0882
 | II-0.4 | 0.4 | 2.36409 | -0.59857 | -0.05621
 | II-0.45 | 0.45 | 2.29238 | -0.57005 | -0.02281
 | II-0.5 | 0.5 | 2.20282 | -0.51599 | -0.01259
 | III-0.1 | 0.1 | 2.47317 | -0.51848 | -0.17083
 | III-0.3 | 0.3 | 2.39628 | -0.51202 | -0.13245
 | III-0.35 | 0.35 | 2.35477 | -0.49735 | -0.11985
 | III-0.4 | 0.4 | 2.30726 | -0.46541 | -0.11094
 | III-0.45 | 0.45 | 2.24876 | -0.41314 | -0.11508
 | III-0.5 | 0.5 | 2.17772 | -0.36803 | -0.09525
 | Storm 2
 | Rainfall type | Ia/P | C0 | C1 | C2 |  |  |  |  | Unit [NAME] (qu) | Unit [NAME] (qu) Final Values
 | I-0.1 | 0.1 | 2.3055 | -0.51429 | -0.1175
 | I-0.2 | 0.2 | 2.23537 | -0.50387 | -0.08929
 | I-0.25 | 0.25 | 2.18219 | -0.48488 | -0.06589
 | I-0.3 | 0.3 | 2.10624 | -0.45695 | -0.02835
 | I-0.35 | 0.35 | 2.00303 | -0.40769 | 0.01983
 | I-0.4 | 0.4 | 1.87733 | -0.32274 | 0.05754
 | I-0.45 | 0.45 | 1.76312 | -0.15644 | 0.00453
 | I-0.5 | 0.5 | 1.67889 | -0.0693 | 0
 | IA-0.1 | 0.1 | 2.0325 | -0.31583 | -0.13748
 | IA-0.2 | 0.2 | 1.91978 | -0.28215 | -0.0702
 | IA-0.25 | 0.25 | 1.83842 | -0.25543 | -0.02597
 | IA-0.3 | 0.3 | 1.72657 | -0.19826 | 0.02633
 | IA-0.5 | 0.5 | 1.63417 | -0.091 | 0
 | II-0.1 | 0.1 | 2.55323 | -0.61512 | -0.16403
 | II-0.3 | 0.3 | 2.46532 | -0.62257 | -0.11657
 | II-0.35 | 0.35 | 2.41896 | -0.61594 | -0.0882
 | II-0.4 | 0.4 | 2.36409 | -0.59857 | -0.05621
 | II-0.45 | 0.45 | 2.29238 | -0.57005 | -0.02281
 | II-0.5 | 0.5 | 2.20282 | -0.51599 | -0.01259
 | III-0.1 | 0.1 | 2.47317 | -0.51848 | -0.17083
 | III-0.3 | 0.3 | 2.39628 | -0.51202 | -0.13245
 | III-0.35 | 0.35 | 2.35477 | -0.49735 | -0.11985
 | III-0.4 | 0.4 | 2.30726 | -0.46541 | -0.11094
 | III-0.45 | 0.45 | 2.24876 | -0.41314 | -0.11508
 | III-0.5 | 0.5 | 2.17772 | -0.36803 | -0.09525