Catchment Area – Runoff Calculator/Spreadsheet. Download and adapt this spreadsheet for your site’s average annual rainfall and/or surface material. Use as a dynamic computer spreadsheet or print out a hard copy to use as a quick reference guide for estimating runoff from variously sized catchments.

Note that the spreadsheet default is a 90% runoff coefficient, meaning 90% of the rain falling on the catchment will run off. The other 10% will be lost to evaporation, wind, leaks, infiltration into the catchment surface, etc. This is typical for an asphalt or concrete roof or hardscape such as a patio, road, or driveway. You can change the runoff coefficient in Excel for different catchment surfaces if needed. (Metal: 95%; Concrete/Asphalt: 80-95%; Tar Roof: 85%; Sonoran Desert Uplands: 20-70%; Bare Earth: 20-75%; Grass/Lawn: 5-35%; Gravel: use coefficient of material below gravel).

Water Harvesting Calculations from Water Harvesting Calculations, Appendix 3 of Rainwater Harvesting for Drylands and Beyond, Vol. 1.

via http://www.harvestingrainwater.com/rainwater-harvesting-inforesources/water-harvesting-calculations/

AttachmentSize
catchment-area-to-runoff-yield.xls43.5 KB

Post new comment

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <link> <meta> <style> <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <a> <p> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <center>
  • Image links with 'rel="lightbox"' in the <a> tag will appear in a Lightbox when clicked on.

More information about formatting options

CAPTCHA
This question is for preventing spam.
Fill in the blank