I gang

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.

Færdigheder: Excel

Se mere: 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, 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, list matches

Om arbejdsgiveren:
( 1 bedømmelse ) Somerset, United Kingdom

Projekt-ID: #282068

Tildelt til:

xxxjmt

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

$60 USD in 0 dage
(7 bedømmelser)
3.2

14 freelancere byder i gennemsnit $96 for dette job

MAnkita

Hello,Please refer your PMB.Thank you.

$250 USD in 3 dage
(47 bedømmelser)
5.7
johnsinit

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

$88 USD in 3 dage
(11 bedømmelser)
3.6
refractocd

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 in 2 dage
(3 bedømmelser)
2.5
demonliang

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 på 1 dag
(1 bedømmelse)
1.4
wincent

can be done.

$150 USD på 1 dag
(1 bedømmelse)
1.2
nibiru

ill help u

$30 USD in 0 dage
(0 bedømmelser)
0.0
reach2algo

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

$250 USD in 2 dage
(0 bedømmelser)
0.0
agp119

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

$100 USD in 2 dage
(0 bedømmelser)
0.0
AddingDynamics

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 Mere

$30 USD in 3 dage
(0 bedømmelser)
1.0
BookwormServices

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 på 1 dag
(0 bedømmelser)
0.0
nccwwq

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.

$30 USD in 2 dage
(0 bedømmelser)
0.0
philipmahaney

I can help with the code for your excel file.

$75 USD in 2 dage
(0 bedømmelser)
0.0
manishsmart80

1 day only

$50 USD på 1 dag
(0 bedømmelser)
0.0