DRAINS utility spreadsheet

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.