+ Reply to Thread
Results 1 to 19 of 19

Vb code for meeting arrangement

Hybrid View

  1. 01-24-2011, 03:36 PM #1
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Question Vb code for meeting arrangement

    Hello,
    I wonder if anyone can help on this problem? There are 51 people will meet on 25 different days, each day there would be 17 meeting each meeting will consist of 3 people (3*17=51) at the end of 25th.day every person would have met any other person once and nobody meet twice.can you please help with vb code if possible
    Thank you
    Reply With QuoteRegister To Reply
  2. 01-25-2011, 08:38 AM #2
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Question Re: Vb code for meeting arrengement

    Hi,
    Any suggestion please?
    thank you.
    Reply With QuoteRegister To Reply
  3. 01-25-2011, 03:57 PM #3
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: Vb code for meeting arrengement

    Hi,
    any help please?
    tthanks
    Reply With QuoteRegister To Reply
  4. 01-25-2011, 04:10 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Vb code for meeting arrengement

    I don't believe a solution exists for that arrangement.

    For a list of known solutions, Google the social golfer problem
    Last edited by shg; 01-25-2011 at 04:26 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  5. 01-25-2011, 09:36 PM #5
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Red face Re: Vb code for meeting arrangement

    Thanks Shg for your response,
    i googled for social golfer problem, but does not help me to solve this meeting arrangement.
    i was hoping one of you excel gurus my have some clue or suggestion might help to solve it.
    thanks for your time.
    Reply With QuoteRegister To Reply
  6. 01-25-2011, 11:26 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Vb code for meeting arrangement

    If you read the links, then you read that some very good mathematicians have studied these problems for almost 150 years and solved a few dozen specific ones.

    Try as we might, I don't think we're going to best them.
    Reply With QuoteRegister To Reply
  7. 01-27-2011, 09:30 AM #7
    jwright650
    jwright650 is offline
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Vb code for meeting arrangement

    Figuring out a formula to do the math is the key and I have to say that I don't know where to start with this one...sorry. Maybe some sort of looping formula or Do until that keeps going until all of the matches have been made?
    Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
    John Wright
    Reply With QuoteRegister To Reply
  8. 01-27-2011, 10:13 AM #8
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Red face Re: Vb code for meeting arrangement

    Hello John,
    Thanks for your time,last night I come across a website which has the combinations, the only thing needed
    now is finding Vb code to distribute combination to 17 meeting and 25 days.the website link is;
    http://www.ccrwest.org/cover/t_pages.../C_51_3_2.html
    I would appreciate if you can help me on this problem,thanks again .
    sezuh
    Reply With QuoteRegister To Reply
  9. 01-28-2011, 07:17 AM #9
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Red face Re: Vb code for meeting arrangement

    I would appreciate for any suggestion???
    thank you....
    Reply With QuoteRegister To Reply
  10. 01-28-2011, 11:13 AM #10
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Vb code for meeting arrangement

    You might enjoy reading http://www.asap.cs.nott.ac.uk/patat/...riska-HC3b.pdf while you're waiting.
    Reply With QuoteRegister To Reply
  11. 01-28-2011, 03:18 PM #11
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Red face Re: Vb code for meeting arrangement

    thanks SHG ,
    it's very very interesting reading,...much appreciated.
    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1