Hi!
I want to use the Solver to find the best combination possible to get the highest % between all possible combinations.
Here are the details:
- Each variable has a condition (i.e.: Variable 1: Value in TableX[ColumnY] is between 3 and 6) that must be True
- Each variable has a total success % [Count(condition is True)/Count(SUM(True, False))]
- Sum(Weight)=1
- Maximize the % of success with a combination of each variable
- **IMPORTANT** the conditions are cumulative! So, you can have a combination of 1 and 2, 1 and 2 and 3, 2 and 3, etc. and all must be meet at the same time.
Here is an exemple table. (My complete table has 68 different variables):
Thanks !
I want to use the Solver to find the best combination possible to get the highest % between all possible combinations.
Here are the details:
- Each variable has a condition (i.e.: Variable 1: Value in TableX[ColumnY] is between 3 and 6) that must be True
- Each variable has a total success % [Count(condition is True)/Count(SUM(True, False))]
- Sum(Weight)=1
- Maximize the % of success with a combination of each variable
- **IMPORTANT** the conditions are cumulative! So, you can have a combination of 1 and 2, 1 and 2 and 3, 2 and 3, etc. and all must be meet at the same time.
Here is an exemple table. (My complete table has 68 different variables):
Thanks !