USBR Weir Calculator Home Page

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

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 Updated: 6/17/16