solver-combination of all possible sum for a given number

[bines53]

Hello friends,

I'm looking for a solution with solver,similar to

But with these conditions,I need to find exactly 7 numbers,that add up closer to 235,

Up to five numbers can be above or below 35, and the last digit of the number does not appear

more than twice.


Thank you !

David

 

[PCosta87]

Hi @bines53

This will help you in the first step (add up closer to 235):
http://superuser.com/questions/362349/find-combination-of-values-with-sum-closest-to-number

I don't know about the other constraints though

Hope this helps a little

 

[bines53]

Hi @PCosta,

Thanks, but that's not it

David

 

[AVK]

Dear Bines, Refer attach file. In your file i addition one column for calculating "sumx2my2", sumx2py2, sumxmy2 function.
I have create table range, control point on last record, right click, select "Totals Row". In single cell you find out lot functions i.e. avg, count, min, max, sum, stdDev, var & in more function select as per category (i.e. Math & Treg).

 

[bines53]

Hi @AVK

Thanks, I tuned optimization


David