Is there a way to have spread a value over adjacent months?

[ks100]

So let's say I have a chart with 12 months of the year on one axis and numbers of tasks due on the other axis.


If January has workload value of 100. Because it's workload value is 100, the work won't ALL be done in January, so I want the next few months to absorb some of January's Value.

I.e. let's say the values for the year are

Jan = 100
Feb = 10
Mar = 20
April = 20

I would want them to actually become:

Jan = 100
Feb = 10 + (Jan - (Jan / 3))
Mar = 20 + (Feb - (Feb / 3))(Jan - (Jan / 3))
Apr = 20 + (Mar - (Mar / 3)) + (Feb - (Feb / 3)) + (Jan - (Jan / 3))

Is there a name for this or something built into Excel that would work similarly?

[JeteMc]

I am going to attach a file to illustrate the total workload for the months of Jan through April. I used the formula (based on the fact that when you subtract 1/3 of the value from the whole you are left with 2/3):

Please Login or Register  to view this content.

I want to make sure that these are the values that you are expecting to see. I initially thought that one of the financial functions might be appropriate, however looking at my results makes me less than sure about that.

Distributed workload.xlsx

Let me know if you have any questions.