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.