Project Detail

Fixture list for soccer/football league  

Fixture list for soccer/football league is project number 282068
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: xxxjmt

Budget: $30-250

Created: 07/02/2008 at 14:35 EDT

Bid Count: 14

Average Bid:
$ 96

07/09/2008 at 14:35 EDT

Project Creator: chimp
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

I have a spreadsheet that generates games/matches/fixtures (call them what you like ) however i have a small problem where games at the same venues clash and games being played back to back.

I am looking for someone to modify my code to account for the following:

--------------

Every team in a division plays every other team twice (once as home team, once as away team).

some teams share a home field, which may cause some confusion in the process.

For each team, generate the home games and append to a list or array:
Team 2 @ Team 1 (teams 1 and 2 play at team 1's home field)
Team 3 @ Team 1
Team 1 @ Team 2
Team 3 @ Team 2
Team 1 @ Team 3
Team 2 @ Team 3

If you order the teams by home field before matching up, then the resulting list will be grouped by venue. For each venue, pick a random element and assign it to a random date from the list (this can be done by shuffling the list of dates and then assigning sequentially). Continue until all games for a particular venue are assigned different dates. Shuffle the list of dates again (otherwise you'll end up with teams playing each other twice in a row) and repeat for the next venue. Continue until you've assigned all matches.


Additional files submitted:
Fixtures generator.xls

Job Type

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

250

3 days

07-02-2008 21:46 EDT

Hello,Please refer your PMB.Thank you.

help

 

150

1 day

07-02-2008 22:26 EDT

can be done.

help

 

88

3 days

07-04-2008 05:31 EDT

Dear chimp! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. John.

help

 

100

2 days

07-03-2008 02:50 EDT

Reviewed GenFixtures macro. It can certainly be ameneded as you have stated. Please refer to PMB. Note that 2 days are just needed for communication, timezone difference, etc.

help

 

60

0 days

07-03-2008 06:50 EDT

***************************************************** HI, I LIKE TO HELP YOU WITH THIS PROJECT, SEE PM. THANKS *****************************************************

help

 

250

2 days

07-03-2008 14:10 EDT

Have the experts to acomplish the VBA job. Thanks, Businnes Development - Algorhythm

help

 

100

1 day

07-02-2008 21:30 EDT

(No Feedback Yet)

I developed VBA and excel for several years. I will fix the problem in your sheet and make this sheet more easy to use. Please check the PM.

help

 

30

0 days

07-06-2008 23:48 EDT

(No Feedback Yet)

ill help u

help

 

100

2 days

07-04-2008 16:16 EDT

(No Feedback Yet)

Respected Sir, I m a graphic designer my experience in exel ,corel,adobe and plz u give me your work and see my work. WebSite:amnapritningservices.weebly.com

help

 

30

3 days

07-06-2008 12:39 EDT

(No Feedback Yet)

Greetings! I can provide a button that you press to calculate this. With a button (i.e., a macro), you'll be able to add dates, teams, etc., or even use it from year to year. This should take no longer than an hour or two to complete, and then there's testing. My bid, however, is for the entire project. Thanks and good luck! Leslie

help

 

30

1 day

07-06-2008 21:56 EDT

(No Feedback Yet)

I am excel certified and can easily manipulate the spreadsheets to compile the information you have requested. Thank you for your time and consideration.

help

 

30

2 days

07-07-2008 03:47 EDT

(No Feedback Yet)

I have thought the problem somedays ,and now i had finished it ,but i do not know if it is right.so pls contact me. thanks.

help

 

75

2 days

07-07-2008 23:15 EDT

(No Feedback Yet)

I can help with the code for your excel file.

help

 

50

1 day

07-08-2008 01:55 EDT

(No Feedback Yet)

1 day only

help


    Bid on this Project