In Progress

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

See more: world programming, programming help games, play programming, formula it, excel help formula, programming world, indoor, excel formula, determine, excel format formula, result soccer, ref data, certain, idea data entry format, can determine, excel write, soccer result excel, entry ref, data entry formula, excel formula programming, need excel formula programming, data programming excel, soccer data excel, processing programming, game processing

About the Employer:
( 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

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
phoenixinfo80

data entry

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