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

Beceriler: Excel, Excel Macros, Excel VBA, Microsoft Office

İşveren Hakkında:
( 2 değerlendirme ) Messina, Italy

Proje NO: #18905118

## Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 35%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(163 Değerlendirme)
6.6

## Bu iş için 9 freelancer ortalamada €67 teklif veriyor

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. Daha Fazla

€140 EUR in 3 gün içinde
(296 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(129 Değerlendirme)
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 Daha Fazla

€50 EUR in 2 gün içinde
(12 Değerlendirme)
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 Daha Fazla

€122 EUR in 7 gün içinde
(1 Yorum)
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 Daha Fazla

€34 EUR in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

€30 EUR in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

€125 EUR in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0