Book excerpt: Latest developments of urban hydrology and hydraulic design procedures for storm water management.Drainage planning is an approach that integrates both local and regional efforts to identify drainage conveyance and storage facilities based on hydrologic optimization and cost minimization individually and collectively. In general, the first six chapters cover the hydrologic procedures for rainfall and runoff predictions, and the next 12 chapters focus on hydraulic designs of urban channel, culvert, street inlet, sewer drain, detention basin, retention basin, infiltration basin, low impact designs, and storm water modeling techniques by various routing methods.Hydrology analyses are lengthy in calculation and repetitive in procedure. As a result, Excel Spreadsheet is the most useful and handy tool for hydraulic and hydrologic designs. This book includes 18 sets of spreadsheets developed for 18 subjects. With these spreadsheets, it is easy for the reader to conduct sensitivity tests. Many of the design methods documented in this book have been adopted as the recommended design procedure by Denver, Las Vegas, and Sacramento metropolitan areas in the United States. Based on these methods, there are many design computer models that have been developed and supported by the Denver metro governments for stormwater design purposes.