View Single Post
 
Old 11-22-2014, 07:50 PM
Bruno Campanini Bruno Campanini is offline Windows 8 Office 2013
Novice
 
Join Date: Nov 2014
Posts: 19
Bruno Campanini is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You obviously haven't tried the solution I posted...

To show how simple it is to get a series of 75 unique numbers that add to 20000, simply insert:
=INT(317.75-ROW()*4/3)
and copy down to row 75. The sum of the rows will be 20000. Granted, these numbers aren't random, but they also go nowhere near exhausting the possibilities contemplated by the OP.
Well, OP requested 76 random numbers in the range 85 to 645
Your formula gives 75 quasi-successive number in the range 216 to 317.
Honestly you can't consider it neither a solution, nor a pseudo-solution.
Another simpler non-solution is:
Sum 75 successive numbers in the range 227 to 301, plus 200.

The problem is a Linear Programming Problem whose solution can be achieved also with the Simplex Algorithm coded in Excel VBA, but it involves a setup of 561 parameters... which is a very long story.
For sure Mathematica can do the job but it requires either a more complex code or an extraordinary long command line.
Taking into account these difficulties I said Mission Impossible.

Bruno
Reply With Quote