Fixture list for soccer/football league

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.

Kemahiran: Excel

Lihat lagi: fixture list generator, league fixture generator, soccer fixture generator, soccer fixture maker, fixture generator, fixture list soccer, generate soccer fixtures, football league excel, soccer fixture creator, fixture creator, football fixture generator, football fixtures creator, excel fixture, football league generator, list fixture league soccer random, excel league fixture, league creator soccer, league fixtures generator, soccer league creator, excel league fixtures, soccer fixtures creator, league fixture excel, fixture excel, where played, matches list

Tentang Majikan:
( 1 ulasan ) Somerset, United Kingdom

ID Projek: #282068

Dianugerahkan kepada:


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

$60 USD dalam 0 hari
(7 Ulasan)

14 pekerja bebas membida secara purata $96 untuk pekerjaan ini


Hello,Please refer your [login to view URL] you.

$250 USD dalam 3 hari
(47 Ulasan)

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

$88 USD dalam 3 hari
(11 Ulasan)

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.

$100 USD dalam 2 hari
(3 Ulasan)

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.

$100 USD dalam sehari
(1 Ulasan)

can be done.

$150 USD dalam sehari
(1 Ulasan)

ill help u

$30 USD dalam 0 hari
(0 Ulasan)

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

$250 USD dalam 2 hari
(0 Ulasan)

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:[login to view URL]

$100 USD dalam 2 hari
(0 Ulasan)

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 h Lagi

$30 USD dalam 3 hari
(0 Ulasan)

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

$30 USD dalam sehari
(0 Ulasan)

I have thought the problem somedays ,and now i had finished it ,but i do not know if it is [login to view URL] pls contact me. thanks.

$30 USD dalam 2 hari
(0 Ulasan)

I can help with the code for your excel file.

$75 USD dalam 2 hari
(0 Ulasan)

1 day only

$50 USD dalam sehari
(0 Ulasan)