Re: Creating a Schedule
Actually the answer isn't simple. I've done a number of scheduling programs for athletics over the years, and they are real challenge. If all the events are going to be at the same venue, you need two tables: one for leagues, one for matches Select the info from the matches, loop over the leagues, check to see if the league is already scheduled, if not schedule the first opponent each week that they have not already played. On Sat, Apr 16, 2011 at 3:13 PM, Jim Mixon wrote: > > I have tried for many long hours and for the first time in a good long while > I am sorry to say I am about stumped . . . > > Hopefully some brains here can help me . . . > > I am trying to write a scheduling program for a client. It will create > pool(billiards) matches on a weekly basis . . > > I need to to be able to collect input from client and create the schedule > based on that input. > > 1. Number of weeks of session > 2. Number of teams in league > 3. This is based on a one day per week schedule > 4. Different matches created from week to week, without repeating combination > until they are possible combinations are used. Then repeat the pattern . . . > 5. One week home, next week away and back again . . > > I have tried numerous approaches, but I just never end up with all the > elements correct. Tried looping thru one list, looping thru two lists, etc . > . . > boy I could use some help on this one . . > > Got a feeling the answer is simple, but it just keeps getting away from me! > > > Anyone got time for this?? > > ;-') > jim > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating a Schedule
Yes, for example .. . He has ten teams ... A - - > B C - - -> D E - - -> F G - - > H I - - - > J plays the first week .. . . and I got that week down!!! Course its the following #any_num# weeks that got me . . . jim From: Sean Corfield To: cf-talk Sent: Sat, April 16, 2011 5:27:34 PM Subject: Re: Creating a Schedule Does team A play team B both at home and away at some point in the season? (i.e., do you need both A-home-B-away and B-home-A-away in the schedule?) On Sat, Apr 16, 2011 at 3:13 PM, Jim Mixon wrote: > I am trying to write a scheduling program for a client. It will create >pool(billiards) matches on a weekly basis . . > > I need to to be able to collect input from client and create the schedule > based >on that input. > > 1. Number of weeks of session > 2. Number of teams in league > 3. This is based on a one day per week schedule > 4. Different matches created from week to week, without repeating combination >until they are possible combinations are used. Then repeat the pattern . . . > 5. One week home, next week away and back again . . > > I have tried numerous approaches, but I just never end up with all the > elements >correct. Tried looping thru one list, looping thru two lists, etc . . . > boy I could use some help on this one . . ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343790 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating a Schedule
Does team A play team B both at home and away at some point in the season? (i.e., do you need both A-home-B-away and B-home-A-away in the schedule?) On Sat, Apr 16, 2011 at 3:13 PM, Jim Mixon wrote: > I am trying to write a scheduling program for a client. It will create > pool(billiards) matches on a weekly basis . . > > I need to to be able to collect input from client and create the schedule > based on that input. > > 1. Number of weeks of session > 2. Number of teams in league > 3. This is based on a one day per week schedule > 4. Different matches created from week to week, without repeating combination > until they are possible combinations are used. Then repeat the pattern . . . > 5. One week home, next week away and back again . . > > I have tried numerous approaches, but I just never end up with all the > elements correct. Tried looping thru one list, looping thru two lists, etc . > . . > boy I could use some help on this one . . ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343787 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Creating a Schedule
I have tried for many long hours and for the first time in a good long while I am sorry to say I am about stumped . . . Hopefully some brains here can help me . . . I am trying to write a scheduling program for a client. It will create pool(billiards) matches on a weekly basis . . I need to to be able to collect input from client and create the schedule based on that input. 1. Number of weeks of session 2. Number of teams in league 3. This is based on a one day per week schedule 4. Different matches created from week to week, without repeating combination until they are possible combinations are used. Then repeat the pattern . . . 5. One week home, next week away and back again . . I have tried numerous approaches, but I just never end up with all the elements correct. Tried looping thru one list, looping thru two lists, etc . . . boy I could use some help on this one . . Got a feeling the answer is simple, but it just keeps getting away from me! Anyone got time for this?? ;-') jim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343785 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm