Skip

Frequency Curve Determination

short url to this page: http://go.usa.gov/KS6

via Bulletin 17b "Guidelines for Determining Flood Flow Frequency"

The NRCS Frequency Curve Determination spreadsheet has several advantages over other free programs developed by U.S. government. For example, the NRCS spreadsheet gives the user complete control over the graphics and also provides a button for precisely reading values from the curve.

This Microsoft Excel spreadsheet was developed by the NRCS Water Quality and Quantity Technology Development Team, has been tested, and correctly reproduces the results of examples in Bulletin 17B "Guidelines for Determining Flood Flow Frequency", revised edition, March 1982. The spreadsheet employs macros which are safe in this version at the time downloaded. The user is cautioned that proper use of the spreadsheet requires training in hydrology and statistics.

downloads     Get download help here.

FreqCurves_ver304.xlsm


-->The following files require Adobe Acrobat.

Bulletin 17B in 3 parts:     Bulletin17B_thru_appx2.pdf   (5.4 Mb)
                                                 Bulletin17B_appx3-7.pdf  (5.8 Mb)
                                                        Bulletin17B_appx8-end.pdf   (4.9 Mb)

Bulletin 17B as one big file:     Bulletin17B.pdf   (16.1 Mb)

contact

dan moore     (Join the user database and receive emails when new revisions are released.)

Here's a screenshot of an example frequency curve:
                                             (horizontal scroll bar at bottom)

freq curve graph


Here's a screenshot of the instruction page with buttons:
                                             (horizontal scroll bar at bottom)

freq curve button sheet

< Back to H & H Tools and Models