Excel programming formula to determine certain outcomes

IN PROGRESS
Bids
13
Avg Bid (AUD)
$82
Project Budget (AUD)
$30 - $250

Project Description:
Hi there,

I require an Excel formula to be created to help determine the below requirements:

My name is pete and I run Futsal (indoor soccer competitions.) I have a competition that runs where teams provide referees for games every second week or so. The idea is that if there is a game at 6pm, then the team referees one week at 645pm. Teams that play at 645pm, will provide a referee for the 6pm games.

In an ideal world all teams will referee games roughly the same amount of times. In one game week there maybe say 8 teams playing in 4 different games. As a result 4 of those teams will referee a game that day. ideally the next week, the other 4 teams that did not referee will referee the next week.

Is it possible for you to write a formula for these competitions? Say for different numbered teams format, say one competition has 9 teams, one other competition may have 10 teams etc.

Where they ref alternate weeks and roughly the same amount of times.

Please let me know if you can do this?

Skills required:
Data Entry, Data Processing, Excel
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire asyraf1156
$ 100
in 1 days
Hire mrbrave
$ 50
in 1 days
Hire shanki161
$ 75
in 2 days
$ 50
in 1 days
$ 50
in 1 days
$ 50
in 4 days
$ 45
in 1 days
Hire Tcsolutions
$ 100
in 1 days
Hire pran123
$ 100
in 5 days
Hire envest
$ 80
in 2 days