I have an ods file with the scores of a basketball league and the league standings.

What I need is a formula to use for tiebreaker:

Those are the rules:

1- head to head games between tied teams. I mean, team A and B tied in the 1st place, but team A had won the two games vs team B, so team A is 1st. If each team won a game, so...

2- point difference in head to head games. same example, both teams won a game, team A won 80-70 but team B had won 100-50 so team B is 1st.

3- points coefficient (?). A division between points for/againts in all the tournament. Example: team A has 700 points for and 650 against, the coefficient is 700/650 = 1.07.

4- MorePoints For in the tournament

5- LessPoints Against in the tournament

Tietoa työnantajasta:
( 2 arvostelua ) Messina, Italy

Projektin tunnus: #18905118

## Myönnetty käyttäjälle:

ksriniravi

Greetings! I can write a small macro that would calculate the rank and in the case of a tie use the 5 rules in the order specified to break the tie. Being a full time freelancer working exclusively on Excel based Lisää

€35 EUR 2 päivässä
(163 Arvostelua)
6.6

## 9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Lisää

€140 EUR 3 päivässä
(296 arvostelua)
7.7
best4best

Hi, I am an Excel expert and can create formulas for tiebreakers as per the description. Please see my portfolios for Excel projects and consider me for quality work. Regards Soni

€39 EUR 1 päivässä
(129 arvostelua)
6.3
dungchan44

Hello, sir! I am happy to put my bid on your project. I have a full of experience with data analysis for sports using Excel Formula and VBA. I have finished a lot of projects like this. I can show you one of them i Lisää

€50 EUR 2 päivässä
(12 arvostelua)
3.7
darshan17755

Hello, Hope you are doing well! Thank you for posting this opportunity on the platform. Looking at the project description and the file attached, I am confident that I can of great help to you through out this pr Lisää

€122 EUR 7 päivässä
(1 arvostelu)
1.6
bshyrk59

Hello Friend! First of all, thanks for your time to review my proposal and would like to work on your project I am Simple, Creative, and Quick. I am the man for this job! I have some interesting ideas and I Lisää

€34 EUR 3 päivässä
(0 arvostelua)
0.0
eriksongpealoza

Good morning, my name is eriksong peñaloza, I am a mechatronic engineer, with experience in various areas of engineering. I am passionate about sports, so it would be a pleasure for me to do this task, because I handl Lisää

€30 EUR 2 päivässä
(0 arvostelua)
0.0
diegogrois

Conditional formulas, rank ifs workarounds and vlookups can solve your model. For the first tiebreak I believe a matrix can work with a index/match lookup. You have columns and rows with the team names and the results Lisää

€125 EUR 3 päivässä
(0 arvostelua)
0.0
sbotero628

Hello! I am an engineer with expertise in this kind of projects but I am new to freelancer.com and need to get my account going with some initial jobs and reviews, therefore I would be happy to hepl you with your proje Lisää

€30 EUR 1 päivässä
(0 arvostelua)
0.0