This is a bit of a rush order, since it's for an NCAA pool due tomorrow.
i have sorted my teams by odds of winning, but different seeds cost me differently.
So I have 3 columns: team-odds-cost
and I would like Excel to tell me:
"If cost can't go over 100, these are the N teams to choose to maximize the sum of odds." I would not specify N, Excel would be open to any N, as long as it adds to the highest odds.
Any chance of getting this to work tonight?
i have sorted my teams by odds of winning, but different seeds cost me differently.
So I have 3 columns: team-odds-cost
and I would like Excel to tell me:
"If cost can't go over 100, these are the N teams to choose to maximize the sum of odds." I would not specify N, Excel would be open to any N, as long as it adds to the highest odds.
Any chance of getting this to work tonight?