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

	Start	End	2018	2019	2020	2021	2022	Total
Project 1	2018	2020	107	107	107			321
Project 2	2019	2021		47	47	47		141
Project 3	2018	2020	10	10	10			30
Project 4	2019	2022		55	55	55	55	220
…	…	…	…	…	…	…	…	…
Total			117	219	219	102	55	712

<tbody>
</tbody>

And I want to reallocate to nearly this

	Start	End	2018	2019	2020	2021	2022	Total
Project 1	2018	2020	135	113	73			321
Project 2	2019	2021		18	30	93		141
Project 3	2018	2020	8	11	11			30
Project 4	2019	2022		1	29	50	140	220
…	…	…	…	…	…	…	…	…
Total			143	143	143	143	140	712

<tbody>
</tbody>

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