You can, of course, change this file any time afterwards. This file will automatically open each time you launch Culvert Studio. Save your curves by clicking the button and specifying a name for your file. You’ll be taken back to the initial IDF Wizard screen where you’ll see your new IDF curves. Click if you want to edit Correction Factors. For more information, see IDF Correction Factors. Note you can also specify Frequency Correction Factors, Cf on this screen. If using Third Degree Polynomial, enter the A, B, C, & D coefficients. Return Period (Yr)Ī screen similar to the following appears.Ĭlear the table if needed and enter, or edit, B, D & E coefficients. In many cases the C and D coefficients will be zero.įor example, the following table shows the Florida Zone 7 IDF Curve coefficients. You must use the Logarithmic, not the Polynomial equation. There you can add a trendline and Excel will generate the equation coefficients. Intensity points into an Excel spreadsheet and use its charting function. Add a trend or moving average line to a chart - Microsoft Add a Trendline in Excel (In Easy Steps) Web21 de jul. If you do not know the specific equation coefficients you can enter Tc vs. You have the option of creating IDF curves using a third degree polynomial equation as follows: These curves typically do not plot as a straight line on log-log scales. To demonstrate the problem, download my simplified example ( click here ), shown in the image below. The 'restored' trendline label now reflects the actual trendline (positive slope). Some regions have IDF curves which are based on a third-degree polynomial equation. It is sufficient to click the trendline label, right-click and click Delete, then press ctrl+z to 'undo' the deletion. If, in your equation, X = Duration in hours, multiply B by 60^E or B = B x 60^E. This can be transformed into I = B/(X)^E or: There may be occasions where you need to match an equation that differs from the IDF Curve equation shown above. IDF Curve EquationĮ = coefficient My Equation Doesn’t Match This To enter your own coefficients, select Enter Known Equation Coefficients from the IDF Wizard opening screen shown below.Ĭhoose one of the following equation types and click.

Each can accept custom coefficients to match your exact IDF curves. Hydrology Studio uses two types of equations. Even though there are several ways to setup your IDF Curves in the beginning, once completed, they all take the form of an equation.

Excel trendline custom equation