Owl Pellets &
Biomass : Formulas & Charts Help 
Need
help with your formulas or making charts? Have a look at the
tips below! Totals: add up the numbers from each column: Example : Frequency totals are 28+6+1, etc. Formula: =B8+B9+B0+B11+B12+B13 




% of Diet Formula This number is the frequency Example: Vole: 28 remains Formula: =C8/C15

Biomass Units Formula This number is the frequency of the animal remains found multiplied by the conversion factor. Example: Vole: 28 remains found Formula: =B8*D8 
% of Biomass Formula This number is the biomass units for the remains of one
prey divided Example: Vole: 56 biomass units divided by a total of 109 biomass units. (56/109=51%) Formula: =E8/E15 



Prey
Frequency Chart Highlight the prey and frequency numbers (A8:B13). 
If you want your cells to display percentages then look below: 
Biomass Percentages Chart Highlight the prey, hold down the apple key and then select the % of Biomass (A8:A13, F8:F13). Select InsertChart : choose 3D pie. Enter a title, delete legend, show data labels & % 

