I have 13 slots/cells that can host 30 different values.
Meaning that I have 1.59432E+19 possible combinations.
Is there any way I can find out the highest value of the "Avg Games per week during playoffs" possible?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Find/Return highest value from a variable combination
- Thread starter labl
- Start date
-
- Tags
- calendar fantasy nba nba fantasy
I have 13 slots/cells that can host 30 different values.
Meaning that I have 1.59432E+19 possible combinations.
Is there any way I can find out the highest value of the "Avg Games per week during playoffs" possible?
Excel Facts
Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sorry, maybe I did not explain myself in the best way.
It is quite confusing even to me.
Maybe an animated gif will help.
I am trying to find what is the highest number of games I can have in a two-week period.
I would have to manually change the fields on the C collum, I'm trying to find out if there's a way that I can automate excel to find the highest value possible (the red number).
Upvote
0
BSALV
Banned user
- Joined
- Oct 31, 2010
- Messages
- 1,651
- Office Version
- 365
- 2013
- 2007
excel can do the same as you, but at a much higher rate, random clicking and try one-by-one all 1.6E19 possibilities and remember the best. If there is no more information available, your week (even your year) is gone before that solution is found.
Upvote
0
Yes, and that is the problem. I'm looking for a solution that would find the best-case scenario in a much shorter time frame.
But maybe doing that in excel would be quite tricky?
Maybe running some function/loop in javascript would be an easier solution?
Upvote
0
BSALV
Banned user
- Joined
- Oct 31, 2010
- Messages
- 1,651
- Office Version
- 365
- 2013
- 2007
in any application, if you can help to reduce the possibilities from 1,6E19 to 1K to 1M by smart engineering, thinking, that's the way to go.
And with this kind of problems, a solution is always better then infinite waiting for the best, even if the found solution is only the 10th best.
So, can you describe, for the moment just on paper, in what direction excel must search to eliminate 1E13 to 1E16 stupid possibilities and only check the last 1K to 1M remaining potentials.
And with this kind of problems, a solution is always better then infinite waiting for the best, even if the found solution is only the 10th best.
So, can you describe, for the moment just on paper, in what direction excel must search to eliminate 1E13 to 1E16 stupid possibilities and only check the last 1K to 1M remaining potentials.
Upvote
0
