Käynnissä

moot competition fixtures

I need a program/spreadsheet that will take a variable number of teams and generate fixtures for a large mooting (debating) competition. I have looked at programmes that generate sporting (soccer) fixtures but the requirements are different.

The parameters are:

- the number of teams is variable, (usually between 6 and 50, may be odd or even number of teams) and each is assigned a team number (eg 1, 2, 3 etc)

- each team must be fixtured to argue against 4 different teams.('4 rounds')

- each team is allocated either gold or green. they must meet 2 green teams and 2 gold teams. (this is so weak teams do not meet 4 strong teams, and strong teams do not meet 4 weak teams).

- the competition involves arguing for the claimant and the respondent. Each team must argue for the claimant twice and the respondent twice. they should argue twice for one side before swapping to argue twice for the other side. In other words in their 4 rounds they can argue CCRR or RRCC, less ideally CRRC or RCCR but not CRCR except as a last resort.

- there should be a manual override and if possible, automatic recalibration of the remaining fixtures. For example if one team is drawn to meet only teams from the same county, the program should allow refixturing for that team, and consequently refixture the others affected, so that a more satisfactory spread of opponents is achieved.(I dont know if this will be possible!)

- reusable each time the competition is run.

Taidot: Excel

Näytä lisää: fixtures, excel spreadsheet soccer, generate team fixtures, excel automatic time, automatic excel, gold spreadsheet excel, excel spreadsheet gold, gold spreadsheet, soccer fixtures, excel soccer, soccer odd, swapping, soccer fixtures teams, soccer fixtures excel spreadsheet, soccer excel, odd excel, excel automatic, soccer fixtures spreadsheet, excel fixtures soccer, fixtures excel, variable excel, generate soccer fixtures, soccer excel fixtures, excel soccer fixtures, excel spread generate

About the Employer:
( 0 reviews ) Perth, Australia

Projektin tunnus: #4281359

Myönnetty käyttäjälle:

Prinol

Hi, We have gone through your requirements and are able to get it done as per conditions specified by you.Please check PMB for further details.

230 $ AUD 3 päivässä
(1 arvostelu)
2.2

4 freelanceria on tarjonnut keskimäärin 558 $ tähän työhön

svet63

If you can provide full instructions, this is doable.

1500 $ AUD 15 päivässä
(46 arvostelua)
6.1
mrbrave

Hi...I will provide you a VBA/excel based solution for this....Details in message box.

250 $ AUD 4 päivässä
(59 arvostelua)
5.2
InfinityGD

ready to start, brilliant mathematician and equation solver

250 $ AUD 6 päivässä
(0 arvostelua)
0.0