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

Taidot: Excel, Excel Macros, Excel VBA, Microsoft Office

Näytä lisää: 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

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

Projektin tunnus: #18905118

Myönnetty käyttäjälle:


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)

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


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)

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)

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)

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)

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)

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)

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)

Hello! I am an engineer with expertise in this kind of projects but I am new to 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)