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 for both Excel 2003 and Excel 2007. The calculation engine in both spreadsheets is the same.
    • NOTE: The Excel 2007 version generates several "compiler errors" when it loads, but should work once you have acknowledged the errors. I have tried, but have been unable to eliminate these error messages.
  • Download 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.
Last reviewed: 03/10/11