Other Scholarly Content


Excel worksheet for calculating agronomic biosolids application rates Public Deposited

Downloadable Content

Download PDF


Attribute NameValues
  • The worksheet is designed to show a municipal biosolids manager how many acres are needed for land application of biosolids at an agronomic rate, based on crop nitrogen (N) requirements. The worksheet is based on a peer-reviewed Extension publication: PNW 511, Worksheet for Calculating Biosolids Application Rates in Agriculture authored jointly by Craig Cogger and Andy Bary (WSU) and Dan M. Sullivan (Oregon State University). The layout of this Excel worksheet is not identical to the extension publication (PNW 511). The layout for this Excel worksheet was originally created by Daniel Thompson, while employed by for the Washington Dept of Ecology. This worksheet is designed for use for biosolids managers, especially those serving small municipalities. In 2021, OSU & WSU Extension educators reviewed and edited the worksheet for clarity and consistency with PNW 511 and made minor text edits.
Resource Type
Date Issued
Academic Affiliation
Table of Contents
  • This Excel file contains the following worksheet pages (each item, A-I, in the list below corresponds to a worksheet page): A. Application rate worksheet. The worksheet is set up to print on one page. We recommend that users retain the original Application Rate Worksheet page, and make copies as needed. B. Example scenarios. These examples were used in workshops for biosolids managers. Grass hay is a common crop for biosolids application west of Cascades. Dryland wheat is common east of Cascades. C. PNW embedded. The 2018 version of PNW 511. D. The rest of the worksheets are look-up tables cut and pasted directly from PNW 511: E. Table 1. Estimated N credits for previous biosolids applications at a site F. Table 2. Estimates of ammonium-N retained after biosolids application. G. Table 3. First year mineralization estimates for organic N in biosolids H. Table 4. Unit conversion factors. I. Table 5. Trace element limits for biosolids.
Rights Statement
Related Items
Peer Reviewed
File Format



This work has no parents.