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 firstname.lastname@example.org
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
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..