Tamamlanmış

Tiebreaker for basketball league standings in excel or libreoffice spreadsheet

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

Daha fazlasını gör: bidding basketball league games, league fixture excel sheet, excel stock spreadsheet, head to head tiebreaker excel, excel league table template, libreoffice calc create table, league table google sheets, premier league table excel spreadsheet, excel league table rank, poker league excel spreadsheet, excel league table formulas, advanced excel mortgage spreadsheet, soccer excel blank spreadsheet league, port excel vba spreadsheet website, league soccer excel, eplain excel budget spreadsheet stock symbols, rent excel scenario spreadsheet, excel turn spreadsheet macro, excel webmaster spreadsheet calculate hosting, can combine contents excel spreadsheets spreadsheet

İş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