Jon Stika, Agronomist for the area Natural Resource and Conservation Service Office, Dickinson, ND has developed an Excel Spreadsheet that automates the process outlined by Dr. Dwayne Beck, SDSU Dakota Lakes Research Farm, Pierre SD in the publication "The Power Behind Crop Rotations. A Guide for Producers (Diversity Index and Intensity Rating). " You may find that publication on the Dakota Lakes Research Farm website http://www.dakotalakes.com in publications.

The Excel Spreadsheet can be downloaded by clicking here.

The spreadsheet provides a quick method for reviewing how changes in a crop rotation affects the intensity and diversity. If you have questions, feel free to contact us.