Menu
This was very simple with Arabic-enabled Windows 98. Now with new version I really don't have a clue. • In the Word document, when you switch to an Arabic keyboard, numbers will be in the Hindi style. • Choose Context in the Numerals menu then close the window Note: Do not choose 'Hindi' as your option unless you want this style in all documents (including English). Is there any way to use Arabic as well as Hindi numerical in different part of a text. Arabic font word 2007.
Items marked with an asterisk (.) are compressed and require WinZip for browsing. An evaluation version of WinZip for free. Viewing PDF files Items in pdf format can be viewed using Adobe Acrobat Reader, which can be. Program Downloads Culvert Bed Material Design Please contact the HQ Hydraulics office for more information. This program calculates the design life of a metal culvert using CalTrans methodology based on corrosion from the surrounding soil and the flow of the culvert.
Typically, WSDOT does not use this approach, but the underlying theory is valid. This Microsoft Excel spreadsheet calculates peak flows for small drainage areas that can be either natural or developed. It uses the rational method as described in the WSDOT Hydraulics Manual. Before finalizing the storm drain layout, designers should verify the layout is constructible with respect to the angle between pipes entering or exiting a junction. That is, in order to maintain the structure integrity of a junction there are minimum clearance requirements that must be met depending on the pipe diameter. Designers can verify the minimum pipe angle with the Pipe Angle Calculation Worksheet at the following link.
Storm Drain Design This Microsoft Excel spreadsheet accomplishes a storm sewer design using the rational method, as described in the WSDOT Hydraulics Manual. This is a Microsoft Excel spreadsheet that calculates runoff using the 2001 version of the USGS regression equations for Washington State. The user should have a 2004 copy of the WSDOT Hydraulics Manual or USGS Fact Sheet 016-01 to determine the input parameters. We are currently working with MIS to deploy the National Flood-Frequency (NFF) program statewide. Until then, the spreadsheets can be used.
If using the routing table, use this link for the. An optimization routine is available, but it is not included in WHAM, the public domain version of the program.
The optimization routine is available through. Inlet Analysis Spreadsheets Inlet Spacing with Side Flow This Microsoft Excel spreadsheet combines the procedure s described in the WSDOT Hydraulics Manual to calculate roadway runoff and inlet interception for a roadway.
Hydrology Tools Gis
For roadways on a longitudinal slope greater than 2% and with velocities between 3-5 ft/s the spreadsheet uses the methods described in the Hydraulics Manual section 5-5.1 Capacity of Inlets on a Continuous Grade. For velocities less than 3ft/s and have longitundal slopes less than 2%, this spreadsheet will also consider the side flow interception as described in the Hydraulics Manual section 5-5.2 Side Flow Interception.
This is a Microsoft Excel spreadsheet that uses the procedure described in the WSDOT Hydraulics Manual to locate inlets in a sag condition. This spreadsheet converts the 2 year, 2 hour storm to the 3 hour storm for any of the four Eastern Washington Climatic Regions.
Hydrology Pdf
For further explanation of how to calculate the 3 hour storm, see Appendix 4D of the Highway Runoff Manual.
Introduction For Excel spreadsheets to use for hydrologyhydrograph calculations,. Read on for information about hydrographs, their components and baseflow separation. Use of hydrographs in hydrology applications often involves calculations with tables of values. Thus Excel spreadsheets are very useful for such calculations.
Read on for information about the components of hydrographs, baseflow separation, generation of unit hydrographs and use of unit hydrographs. What is a Hydrograph? For use in hydrology, the term hydrograph means a graph or table of values showing the changes in flow rate over time at a point on a river or stream or some other point of interest. Possible points of interest for a hydrograph include locations like a storm water drainage outlet from a drainage area or the entrance to a storm water detention system. Hydrographs are used to show flow patterns following a storm, thus providing information about the storm water runoff rate at the point of interest.
For a storm hydrograph at a point on a river or stream, there will typically be a gradually decreasing flow rate before the beginning of the storm. After the storm begins, the flow rate increases as storm water runoff from more of the drainage area reaches the river. The flow rate (discharge) will typically increase to a peak value and then gradually decrease to the pre-storm level again, as shown in sample hydrograph in the figure at the right.
For a hydrograph where there’s no non-storm water flow, the hydrograph will start at zero flow prior to the storm and go back down to zero flow. Hydrograph Components – Baseflow and Direct Runoff The flow represented by a hydrograph for a point on a river or stream is considered to be made up of two parts, the baseflow, which is the normal dry weather flow of the river or stream, and direct runoff, which is the component of flow due to storm water runoff.
The direct runoff due to the storm is often the part that is of interest. In order to determine the direct runoff from a storm, its necessary to separate the baseflow from the hydrograph, leaving the direct runoff hydrograph. The diagram at the left shows three methods used for baseflow separation: the constant discharge method; the constant slope method; and the concave method. The constant discharge method simply uses a horizontal line from the point where the hydrograph begins to rise to its intersection with the receding limb. The baseflow separation line for both the constant slope method and the concave method should intersect with the receding limb at the inflection point (where the receding limb changes from convex to concave). The time from the peak of the hydrograph to the inflection point of the receding limb is often calculated with the equation: N = A 0.2, as shown on the diagram. This is a dimensional equation, in which A is the watershed area in mi 2, and N is time in days.
The constant slope method uses a straight line from the point where the hydrograph begins to rise to the inflection point on the receding limb. The concave method extends the pre-storm slope of the baseflow line to a point directly below the peak and then uses a straight line to the inflection point on the receding limb. For Excel spreadsheets to make a variety of hydrograph calculations, including baseflow separation by the concave method,. Reference McCuen, Richard H., Hydrologic Analysis and Design, 2nd Ed, Upper Saddle River, NJ, 1998. This entry was posted in and tagged,. Bookmark the. About Harlan Bengtson Dr.
Bengtson has B.S. Degrees from Iowa State University and a PhD from the University of Colorado, all in Chemical Engineering. He is now retired after 30 years in engineering education, in teaching and administrative positions.
His areas of expertise are environmental engineering, hydrology, engineering science and renewable energy. He is a licensed Professional Engineer in Missouri. He did consulting work while in academia and had prior industrial experience.
Bengtson has authored numerous publications, presentations and technical reports. He is currently active as a technical writer.
ABSTRACT When beginning hydrologic investigations, a first action is often to gather existing sources of well information, compile this information into a single dataset, and visualize this information in a geographic information system (GIS) environment. This report presents tools (macros) developed using Visual Basic for Applications (VBA) for Microsoft Excel ® 2007 to assist in these tasks. One tool combines multiple datasets into a single worksheet and formats the resulting data for use by the other tools. A second tool produces summary information about the dataset, such as a list of unique site identification numbers, the number of water-level observations for each, and a table of the number of sites with a listed number of water-level observations.
A third tool creates subsets of the original dataset based on user-specified options and produces a worksheet with water-level information for each well in the subset, including the average and standard deviation of water-level observations and maximum decline and rise in water levels between any two observations, among other information. This water-level information worksheet can be imported directly into ESRI ® ArcMap™ as an “XY Data” file, and each of the fields of summary well information can be used for custom display. A separate set of VBA tools distributed in an additional Excel workbook creates hydrograph charts of each of the wells in the data subset produced by the aforementioned tools and produces portable document format (PDF) versions of the hydrograph charts.
These PDF hydrographs can be hyperlinked to well locations in ArcMap™ or other GIS applications. Front cover: Illustration of the path from raw water-level data to useful groundwater information.
For additional information contact:, Arizona Water Science Center U.S. Geological Survey 520 N.
Park Avenue Tucson, AZ 85719 This report is presented in Portable Document Format (PDF); the latest version of Adobe Reader or similar software is required to view it. Suggested citation: Tillman, Fred D, 2009, Excel(R) spreadsheet tools for analyzing groundwater level records and displaying information in ArcMap(TM): U.S. Geological Survey Techniques and Methods 4-F1, 59 p. Contents Abstract Introduction Acknowledgments Data Requirements Spreadsheet Tools Displaying Results in ArcMap Summary and Conclusions References Cited Appendix: Program Listings.
Hydrology, Hydraulics, and Wetland Resources Notice – The following spreadsheets, computer programs and supporting documentation are tools to assist with typical hydrologic or hydraulic calculations or wetland hydrologic evaluations. The engineering practitioner must understand the assumptions and calculations contained in these tools and is responsible for their appropriate use. Some of the spreadsheets contain macros.
Many additional engineering spreadsheets are available in the section. Hydrology NRCS Wisconsin Hydrology Resources: NEW January 2015 (including NOAA Atlas 14 Precipitation Data) NEW January 2015 (including NOAA Atlas 14 Precipitation Data). NEW January 2015(Wisconsin Supplement to the NEH Part 650, Chapter 2) NEW January 2015 – Information about NOAA Atlas 14 Precipitation Data Updates for Wisconsin. (Estimating Runoff and Peak Discharges). NEW January 2015 – Additional NRCS WI Spreadsheets with updated precipitation data. WinTR-55 Watershed Hydrology Computer Program. (pdf, 81 kb) WinTR-20 Watershed Hydrology Computer Program.
Hydraulics NRCS Wisconsin Hydraulics Resources:. See Wisconsin for additional hydraulics related spreadsheets NRCS National Hydraulics Resources:. (download for XP) (accessible from USDA CCE computers only) Wetland Resources NRCS Wisconsin Wetland Resources:. (docx, 4 mb).
(docx, 29 kb) Precipitation Evaluation (Wet, Dry & Normal) Spreadsheets. (xls,1MB). (xls,1MB). (xls,1MB).
(xls,1MB) Information about NOAA Atlas 14 Precipitation Updates See 'Hydrology' Section above. NRCS National Wetland Resources:. (National Engineering Handbook, Chapter 19).
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |