#### richard1234567891011

##### Board Regular

- Joined
- Feb 21, 2018

- Messages
- 91

Hello guys. I have an issue. I have to sort the data, but optimised in order to be less than 100.000 but the sum nearest possible.

Virtually I need a way in order to have some data, I want that data selected by the excel (preference for the parameter of the data, but the main preference has to be in order to reach 100.000). I think it is not clear so I will make 2 examples.

Example 1

Parameter Data

1 _______10.000

0,9_____ 8.000

0,8 ______10.000

0,7______ 12.000

Parameter are the best solutions in order, but the main goal is to reach a value nearest possible to 100.000. So the solution here is all. Because the sum is less than 100.000

Parameter __Data

1_______ 15.000

0,9 ______10.000

0,8 ______10.000

0,7 ______10.000

0,6 ______10.000

0,5 _______5.000

0,4 ______10.000

0,3 ______10.000

0,2_____ 10.000

0,1_____ 10.000

0 ____________0

This point is tricky because this is in fact the main point. In this point I want excluded 5.000 because even if it has a better parameter the sum is not optimised in order to reach 10.000. The best way in order to reach 100.000 is to sum everything and excluding 5.000.

I hope is it clear.

How can I set something like that? I thought of the solver but how can I set a solver in this way?

Thank you. I really hope that it is clear.

Virtually I need a way in order to have some data, I want that data selected by the excel (preference for the parameter of the data, but the main preference has to be in order to reach 100.000). I think it is not clear so I will make 2 examples.

Example 1

Parameter Data

1 _______10.000

0,9_____ 8.000

0,8 ______10.000

0,7______ 12.000

Parameter are the best solutions in order, but the main goal is to reach a value nearest possible to 100.000. So the solution here is all. Because the sum is less than 100.000

Parameter __Data

1_______ 15.000

0,9 ______10.000

0,8 ______10.000

0,7 ______10.000

0,6 ______10.000

0,5 _______5.000

0,4 ______10.000

0,3 ______10.000

0,2_____ 10.000

0,1_____ 10.000

0 ____________0

This point is tricky because this is in fact the main point. In this point I want excluded 5.000 because even if it has a better parameter the sum is not optimised in order to reach 10.000. The best way in order to reach 100.000 is to sum everything and excluding 5.000.

I hope is it clear.

How can I set something like that? I thought of the solver but how can I set a solver in this way?

Thank you. I really hope that it is clear.

Last edited: