Quote:
Originally Posted by macropod
Bruno: You really need to pay attention.
In post #1 the OP clearly said 75 random numbers, not 76.
My reply in post #6 clearly shows how to do that. Granted, I used a different set of boundary numbers, but that is not the point.
My reply to you in post #9 was aimed, not at producing random numbers, but at demonstrating the abject fallacy of your 'impossible!' assertion. The simple fact of the matter is that there is a very large number of possible solutions to the problem, with or without allowing for repeated numbers.
|
Saying "allowing for repeated numbers" is ridiculous, see my previous post.
The only mathematical way to solve the problem is:
a - calculate the more then 33681*10^90 combination C561,75
b - chose among them the ones whose sum is 20000
(may be they are many millions)
c - choose random among those many millions.
I don't know any PC/Program able to run that job. Did you?
A shortcut could be using a Linear Programming Algorithm such as
the Simplex Algorithm, but it requires a very complex preliminary
set up (there are 561 variables!) and I'm not sure to be able to do so.
Then, as far as the correct and complete and Excel-solution is concerned,
I repeat: Mission Impossible!
Practical solutions are possible, even off-Excel, as long as one can
forget the "random" attribute.
Bruno