 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / August 2007combinations
Hello, People! I am looking for a formula that will help me determine how many different outcome I will get. I have illusrtated below a simple format the way it will be layed out. Home Visitor 1. Tor vs Phil 2. NYI vs NYR 3. Pitts vs NJ 4. FLA vs TB 5. Cal vs EDM 6. MTL vs Ott 7. Bos vs Det 8. Buf vs LA 9. Van vs Nash 10. NC vs Min Please note the formula that I am looking for: In game #1 there are two possible outcomes . Either home team wins or Visitor. The two teams cannot play the following teams below them or above them. Can any one help me or guide me to a formula, hopefully with step by step instructions on how to perform this. I would really appreciate this. 2^10 (2^no_of_games) Equal to the number of different binary numbers up to 10 digits. Regards, Bernd Thanks Bernd! Could you provide a little description. I am a little confused on where and how to input the formula. Regards > 2^10 (2^no_of_games) > Equal to the number of different binary numbers up to 10 digits. > > Regards, > Bernd Hello, You have 10 games with a possible result of 0 or 1, so your result universe is 0000000000 0000000001 0000000010 0000000011 0000000100 ... 1111111111 That makes 2^10. Just write into any cell =2^10 which is 1024 Or take my UDF longbin2dec from http://www.sulprobil.com/html/ longdec2bin__.html: =longbin2dec("10000000000") which results in 1024 again. Regards, Bernd Bernd, Your link return a *Page not found* for me  SignatureRegards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > Hello, > [quoted text clipped - 17 lines] > Regards, > Bernd I think you've only looked at half of the url, Sandy. It is: http://www.sulprobil.com/html/longdec2bin__.html SignatureDavid Biddulph > Bernd, > > Your link return a *Page not found* for me >> Hello, >> [quoted text clipped - 17 lines] >> Regards, >> Bernd David, Thanks for your help. Regards, Bernd Thank you David. The link did not seem to be far enough along for it to have been hit by a line wrap but then there no other*break-point* Also the full colon after the 2nd html fooled me into thinking that that line referred to the text below it. SignatureRegards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk >I think you've only looked at half of the url, Sandy. It is: > http://www.sulprobil.com/html/longdec2bin__.html [quoted text clipped - 24 lines] >>> Regards, >>> Bernd Hi Bernd -- Question going beyond your formula -- I am trying to find an additional formula that looks at how many combinations of 2 digits or 3 digits or so forth -- so if I had something where I had 5 things then I have 2^5-1 (I don't use the 00000 in this case) 31 different combos. What I am trying to figure out is that I know I have 31 combos, but the 31 combos come from 5 single digits (00001,00010,00100,01000,10000) and a bunch come from 2 digits (00011,00101, etc). I am trying to figure out a formula for determining how many 2 digits combos are possible, how many 1 digits are possible, 3 digits, etc. If you know off the top of your head I would appreciate the help -- Thank you -- Jim > Hello, > [quoted text clipped - 17 lines] > Regards, > Bernd Rubble - Check out Pascal's Triangle. Your answers are in the sixth row. Alternately, =COMBIN(5,1) =COMBIN(5,2) =COMBIN(5,3) . . . - David Hilberg > Hi Bernd -- > [quoted text clipped - 35 lines] >> Regards, >> Bernd Thank you !!! That helps me a ton . . . my ability to think through mathematical formulas has diminished greatly since college -- thank you > Rubble - Check out Pascal's Triangle. Your answers are in the sixth row. > [quoted text clipped - 46 lines] > >> Regards, > >> Bernd You're welcome. I'm sure it all comes simply *rushing* back to you now! - David > Thank you !!! That helps me a ton . . . my ability to think through > mathematical formulas has diminished greatly since college -- thank you [quoted text clipped - 49 lines] >>>> Regards, >>>> Bernd |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.