Trend , by MarvL

Misc ID = 15
Date Submitted = 2001-02-22

Author's Description:

This is an Excel worksheet that allows you to conveniently enter your various Distribution Items. You can enter a target value and deadband. Conditional formatting is used to highlight low values in red and high values in blue.

A twelve period moving average is used to project where you will be "next year" if you don't make any changes. An associated chart gives you a visual representation of Food (All seven types lumped together), Fleece, and Olive Oil.

There's also a handy area for recording Gifts, Tribute, and Bribes that are part of your commodity dynamics.

Additional information is available at http://www.MarvL.com/Serpentineum/Trend.htm