Excel solver allocation in time

[Sergun69]

Hello,


I'm finding the solution to reallocate amounts in time to smooth totals. Is it possible to solve this problem with excel solver? Is there any sample with similar problem?
My data looks like this

[TABLE="width: 924"]
<tbody>[TR]
[TD][/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]2018[/TD]
[TD]2019[/TD]
[TD]2020[/TD]
[TD]2021[/TD]
[TD]2022[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]2018[/TD]
[TD]2020[/TD]
[TD]107[/TD]
[TD]107[/TD]
[TD]107[/TD]
[TD][/TD]
[TD][/TD]
[TD]321[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]2019[/TD]
[TD]2021[/TD]
[TD][/TD]
[TD]47[/TD]
[TD]47[/TD]
[TD]47[/TD]
[TD][/TD]
[TD]141[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]2018[/TD]
[TD]2020[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]2019[/TD]
[TD]2022[/TD]
[TD][/TD]
[TD]55[/TD]
[TD]55[/TD]
[TD]55[/TD]
[TD]55[/TD]
[TD]220[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD]117[/TD]
[TD]219[/TD]
[TD]219[/TD]
[TD]102[/TD]
[TD]55[/TD]
[TD]712[/TD]
[/TR]
</tbody>[/TABLE]

And I want to reallocate to nearly this

[TABLE="width: 924"]
<tbody>[TR]
[TD][/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]2018[/TD]
[TD]2019[/TD]
[TD]2020[/TD]
[TD]2021[/TD]
[TD]2022[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]2018[/TD]
[TD]2020[/TD]
[TD]135[/TD]
[TD]113[/TD]
[TD]73[/TD]
[TD][/TD]
[TD][/TD]
[TD]321[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]2019[/TD]
[TD]2021[/TD]
[TD][/TD]
[TD]18[/TD]
[TD]30[/TD]
[TD]93[/TD]
[TD][/TD]
[TD]141[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]2018[/TD]
[TD]2020[/TD]
[TD]8[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]2019[/TD]
[TD]2022[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]29[/TD]
[TD]50[/TD]
[TD]140[/TD]
[TD]220[/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD]143[/TD]
[TD]143[/TD]
[TD]143[/TD]
[TD]143[/TD]
[TD]140[/TD]
[TD]712[/TD]
[/TR]
</tbody>[/TABLE]

Thanx.

 

[Trevor G]

Welcome to the forum,

Please don't double post its against the forums rules, you can use BUMP https://www.mrexcel.com/forum/excel-questions/1079931-excel-solver-allocation-problem.html