Darts league score tables and calculations

[m1r0]

Hi everybody.
I'm trying to come up with a table for calculating darts game scores with specific rules.
I would like to avoid using VB if possible, if not, it's OK.

So far I have tried several combinations but I would like to know if is there a better way, I'm sure there is.
I'm trying to find a way to enter the data so it can be easily calculated and manipulated.

At the end of every game, there is a scorecard that I would like to enter into an excel table and have it calculate the score. The issue is, the score is based on multiple criteria.

• Two teams A & B
• 8 Players (A1,A2,B1,B2...)
• There are 4 Turns
• Every turn there is a play score and a set score

Play score is between two players, for example:

Values can only be 1:0 or 0:1

Turn 1
A1 - B1
A2 - B2
A3 - B3
A4 - B4

Turn 2
A1 - B4
A2 - B3
A3 - B2
A4 - B1

The set consists of 3 "legs" and the score can only be 2:0, 2:1, 1:0, 0:2
Legs don't have to be calculated in the table.

A win (whoever has more set score) is considered 3 points, fairly straightforward, but if there is a draw, then there is pairs play that consists of 3 sets and the outcome determines the winner but the winner does not get 3 points, the winner gets 2 and the loser gets 1.

I need totals so the ranking of the teams in the league can be calculated, ranking is based on total points. But if two teams share let's say 3rd position, then the score is calculated based on the total score between those two teams, if it's a draw then it's the totals of the play score, if that is a draw then the totals of the set score of all the games played between the two teams.
Also, I would like to get the total of play score and set score for each of the players, I have managed to do this by using a pivot table and formatting the table in a specific way, but would like to know is there a better one.

I hope I was clear enough, the example is in the attachment. I know how to make some of the calculations work, but the imperative is to set up the table so I can make that happen.

Thank you in advance, whoever is willing to help out.