How can I calculate inventory rate of change (during a period of time, such as the last seven days), or "time derivitive"(?) to determine increasing / decreasing sales trends of one period and compare with like trends of prior periods, with the objective of determining increasing/decreasing sales trends and then applying optimal adjustments to inventory control macros... using excel?