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
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
Bu iş için 9 freelancer ortalamada €67 teklif veriyor
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
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