Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to determine the best possible (statistically speaking) lineup to start.
Each car has a value, and each car has odds. I must choose 5 cars, and the value cannot exceed 100. I typed in all my data, can Excel choose the best possible lineup for me? In the end, I need the lowest result possible while only using 100 pts in value. Here is a sample of my data. Car # Value Odds (#to1) (Result=Value x Odds) 1 23.5 4 94.00 2 23.4 5 117.00 3 22.8 5.75 131.10 4 22.6 6.75 152.55 5 22.2 12.5 277.50 6 23 15 345.00 7 15 23.5 352.50 8 22 17.5 385.00 9 21.8 20 436.00 10 19.5 23.5 458.25 11 21.6 23.5 507.60 12 21 25 525.00 13 21.7 25 542.50 14 19 30 570.00 15 22.1 30 663.00 16 20.3 35 710.50 17 21.9 34 744.60 18 20 40 800.00 19 18.8 45 846.00 20 18.6 47.5 883.50 Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Max or Min Value | Excel Discussion (Misc queries) | |||
"how to make data lineup from 1st to 2nd page for printing? | Excel Worksheet Functions | |||
lineup equal values by inserting empty cells | Excel Discussion (Misc queries) | |||
finding the "end" | New Users to Excel | |||
How to match sort and lineup 2 sets of data | Excel Worksheet Functions |