DRAINS utility spreadsheet
Many calculations needed to set up inputs to DRAINS are best performed on a spreadsheet, with results being pasted into DRAINS using the Paste
buttons available in many property sheets, for example, for rainfall patterns and for detention basins. The Utility Spreadsheet is an Excel spreadsheet distributed to DRAINS users that contains worksheets relating to information required by DRAINS. It is periodically updated.
The worksheets can be used to develop hyetographs, hydrographs, elevation-storage relationships and elevation-discharge relationships. Each sheet has step by step instructions.
While some procedures in the sheets may be implemented in DRAINS, many are not, and users can add their own variations by altering the sheets.
DRAINS users can obtain copies of this spreadsheet from the Watercom website: https://watercom.com.au/additional-downloads/
Note that no responsibility is taken for problems arising from use of these sheets or damage caused by this use. It is the responsibility of users of the sheet to assess the appropriateness of the sheets for their purposes, and to check the correctness of the procedure and the results provided.Related Articles
DRAINS spreadsheet formats and data
The spreadsheet copy options in the Edit menu of DRAINS can transfer input data and results to spreadsheets and other programs that can interface with DRAINS. Data can be transferred both ways - from and to DRAINS. This has the following advantages: ...Spreadsheet transfers
The data that makes up a DRAINS model and the results of runs can be transferred to spreadsheet programs using facilities in the Edit menu. Other spreadsheet transfers can be made for any results that can be pasted to the Windows Clipboard. In the ...Importing data tables from a spreadsheet
Rainfall hyetographs and stream flow hydrographs can be imported into DRAINS via the Windows Clipboard using the following procedure: (a) Set up the data in a table of values, with the times of the start of each period in one column, and the rainfall ...DRAINS Viewer installation and operation
The DRAINS Viewer can be installed on a Microsoft Windows PC using the 'DrainsViewerSetup.exe' file obtainable from Watercom. Once installed, the Viewer can be opened from the Start menu by selecting Programs and then DrainsViewer. The Main Window ...DRAINS menus
These are the main means of operating DRAINS. They appear at the top of the Main Window. You can select from the following menus: The File menu The Edit menu The Project menu The View menu The Draw menu The Run menu The Help menu These menus are ...