Bureau of Reclamation Banner

USBR Weir Calculator Home Page

Tony L. Wahl, Bureau of Reclamation, Denver, Colorado


This page provides download links for obtaining the USBRWeir.xls spreadsheet, used to determine rating tables and equations for sharp-crested weirs.

To join the USBRWeir Notification List, please send a blank e-mail to join-usbrweir@listserver.usbr.gov


Download Links

  • Download USBRWeir.xls, version 1.1 - The Zip file you download contains versions that were developed in Excel 2003, Excel 2007, and Excel 2010. The calculation engine in all spreadsheets is the same.
  • Download a conference paper describing the spreadsheet and its use

  • New! Wall Gage CreatorThis companion program allows users to create flow-graduated staff gages for any hydraulic structure for which a rating table or rating equation is known. Gages produced are similar to those generated by WinFlume.

USBRWeir Release Notes

  • The 2007 version throws "compiler errors" when it loads, but should work once you have acknowledged the errors.
  • The 2010 version requires the user to manually print the rating curve chart. For unknown reasons, Excel crashes when the rating curve is printed from inside of a macro, so I have hidden the "Print Rating Curve" button..
Last reviewed: 09/05/14