redistribute numbers using solver

For Solver it is very important (and sometimes cruicial) to have a good starting point.

You could try for instance with sorting input data descending, then pre-assign numbers 1 to 19 to all 19 biggest numbers and assign 20 to all other (see Initial Setup sheet). Then you can run solver.
Results are not perfect.
So may be even more pre assignmet would be usefull.
See sheet Manual. I assigned 1-8 to all 10 values and excluded them from solver.
Then I've taken the 9th biggest (ee 8.6) and noticed we have a place for 1.4. Unfortunately, there is no such resulk, so I assigned 9 to (h2 1.3).
the 10th biggest is (mm 8.1) so we have a place for 1.9. Again, no such value, so i wrote 10 next to (nn 1.6) and (a1 0.2) = 1.8 in total. And so on until 20, where I assigned 20 to all remaining values

Now Solver has a good starting point and can quicker provide us with better results.

See attached file