Patent US 6,889,141

A method and system for calculating hydraulics and hydrology of watersheds automatically with flexibility. It combines the concepts of hydraulics and hydrology with the flexibility of spreadsheets and the automation of the accompanied standalone computer modules created in this new system. Each standalone module functions as a control center to communicate with other application programs like EXCEL and process the input data, to perform the calculation internally and place results in a popularly adopted format like spreadsheet. One control center relays information to others through linking the input and output data sources. A seamless stream of calculation can be formed flexibly by repeating the above linking procedure. This optimized calculation stream and the new computer functions created in them have eliminated many tedious and labor-intensive tasks. The modules are self-contained, which means easy maintenance and error proof compared with the scripts if any embedded in spreadsheets.