Skip to page content.Oregon State University

Tree Loss Templates

The following spreadsheets calculate the value of a pear, apple, or cherry tree lost due to external factors, such as a vehicle. The value of this loss depends on the value of the fruit, productivity of the lost tree, and years needed for a new tree to produce the same amount of fruit as the lost tree.

Note: You must have Microsoft Excel to view the files.

Apples & Pears
Cherries
Instructions and explanation for completing an analysis

Copyright © 1995-2008 Oregon State University. Disclaimer. Webmaster.