Excel programming formula to determine certain outcomes

Closed

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

See more: world programming competition, world programming, programming help games, programming games in c++, programming for games, i play programming, if then programming, game programming competitions, game programming competition, formula it, c programming for games, c programming competitions, c programming competition, competition programming, excel help formula, programming world, indoor, excel formula, determine, excel format formula, result soccer, ref data, certain, idea data entry format, can determine

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

Hi.. Please see PM.. Thanks

$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

tell me more details and ill help you quickly

$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
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
envest

I am an excel power user and can provide you with a formula and spreadsheet to help you manage your referees.

$80 AUD in 2 days
(0 Reviews)
0.0
phoenixinfo80

data entry

$200 AUD in 11 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