# Excel programming formula to determine certain outcomes

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: Data Entry, Data Processing, Excel

( 2 reviews ) Princes Hill, Australia

Project ID: #2559483

## Awarded to:

coolbuddy19

hi I am confident to handle this

\$50 AUD in 1 day
(21 Reviews)
4.9

## 13 freelancers are bidding on average \$82 for this job

asyraf1156

\$100 AUD in 1 day
(55 Reviews)
5.6
mrbrave

Expert Excel User Here....

\$50 AUD in 1 day
(78 Reviews)
5.4
shanki161

We are expert at EXCEL formula. Thanks and Regards Karan

\$75 AUD in 2 days
(21 Reviews)
4.9
kyoby

\$50 AUD in 1 day
(1 Review)
3.7
NourElDeen

Dear Sir, I would like helping you. Best Regards, NourElDeen

\$50 AUD in 4 days
(6 Reviews)
3.0
phoenixinfo80

data entry

\$200 AUD in 11 days
(0 Reviews)
0.0
envest

\$80 AUD in 2 days
(0 Reviews)
0.0
sedevra

I understand that what you want is a simple to use Excel tool to manage your football refereeing. I can produce something that is easy to use and easy to setup for each new season. Thank you,

\$80 AUD in 1 day
(0 Reviews)
0.0
krish1210

I can do this work very easily as I have lots of experience in this kind of work

\$80 AUD in 60 days
(0 Reviews)
0.0
DrMDodd

I believe I have the solution. I shall send you a proposed solution. Regards, Martin

\$45 AUD in 1 day
(0 Reviews)
0.0
Tcsolutions

This is very interesting, just a few clarifications in order to apply the logic. Can a team not playing ref a game ? Please clarify. thanks, TC

\$100 AUD in 1 day
(0 Reviews)
0.0
pran123

Hi I am expert in excel and do your project.

\$100 AUD in 5 days
(0 Reviews)
0.0