Smear ut negative values over positive

Hello.

I have this row of values

0,268,281,544,256,359,204,765,59,56,-114,-440,-87,-75

These are how the capacity in our production over a period of time.
As you can see there are negative values in the 4 last periods.

I would like to smear these negative values out in the periods before where we have "overcapacity".
As you also can see is that the total value of the negative values are: 715
If we could smear this negative values out in period 5,6,7 from the end we would not have any problems.

Does anyone have any idea on how I could solve this?
The period values are changing so the solution need to be dynamic.

/Anders

Hello.

Thanks for the links.
It is quite hard to explain.
I have uploaded an example that I hope you could check out to see if you understand my problem better.

/Anders

im suer we can help. The problem for me is taht I don't know what you mean by "smear". Also, from where do you get the numbers that are negative/red? Are they calculated elsewhere?

Hello.

I translated a swedish word to english. Maybe I used the wrong word.
Another translation I found is "spread".

How do I spread the negative values on where I have positive values. It is important that I don't show negative values.

The values and where they are from is in the attached file.
Customer need- capacity = The value
If the need is greater than the capacity I would like to produce the current need in a month where I have a positive result in the calculation above.

/Anders