|
This is what I use for a rolling year:
13 column chart Year, Jan, Feb, March, April, May, June, July, August, Sept, Oct, Nov, Dec. Return+ Used - 40.0 40.0 40.0 40.0 Balance 480.0 440.0 400.0 360.0 320.0
_________________________________________________________________ Year Return + 40.0 40.0 40.0 40.0 Used - 40.0 Balance 320.0 360.0 400.0 360.0 400.0 440.0
__________________________________________________________________ Year Return+ Used - Balance
The first year they use, there are no return hours, the second year the return hours are added back into the balance available in the month they were used.
My charting form has 4 years on it so it is easy to manage and look back at useage.
Hope this example gives you an idea of how it works,
Gloria
|