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.
