If you are looking an excel fixtures and scoresheet for 2023 Rugby World Cup tournament, you can download and use this one. It is created specifically for this tournament where there are excel formulas are built to make country’s rank adjusted automatically in their respective groups and to place them in correct knock out brackets based on their final group standings, based on score and tries you put in respective boxes.
The tournament will begin on 8th September 2023 and finished by 28th October 2023. France will act as a host of this tournament. There are 20 countries that participate in 2023 Rugby World Cup and they will be divided into 4 groups of 5 countries. Each countries in each group will play a single round robin match and the top two of each groups will advance to the knock out round.
2023 Rugby World Cup Point and Tie-Breaker Regulation
Based on its tournament match regulation, the following number of points will be awarded to each team based on following match condition :
> Win – 4 points
> Draw – 2 points
> Loss – 0 points
> 4 or more tries – 1 point
> Loss by 7 points or less – 1 point
A country with highest point will become a group winner while the second highest point will be put in second place. If two or more countries are having similar points, they will be ranked based on tournament tie-breaker regulation as follows :
1. Country with higher head to head match points (two team), or have best overall points (three teams and more) will be ranked higher
If regulation number one is still generating the same rank, they will be ranked again based on all their group matches statistic as follows :
2. Better Points difference (Points Scored For (PF) – Points Scored Against (PA))
3. Better Tries difference (Tries Scored For (TF) and Tries Scored Against (TA))
4. Better Points Scored For (PF)
5. Better Tries Scored For (TF)
If after regulation number 5 the tie still unresolved, those countries will be ranked based on Official World Rugby World Rankings on October 12, 2015
Then top two teams will be placed in brackets with following arrangement :
- Quarterfinal 2 – Winner group B v Runner up group A
- Quarterfinal 1 – Winner group C v Runner up group D
- Quarterfinal 3 – Winner group D v Runner up group C
- Quarterfinal 4 – Winner group A v Runner up group B
And below are match arrangement after quarterfinals
- Semifinal 1 – Winner QF1 v Winner QF2
- Semifinal 2 – Winner QF3 v Winner QF4
- 3rd Place – Loser Semifinal 1 vs Loser Semifinal 2
- Final – Winner Semifinal 1 vs Winner Semifinal
How to Use 2023 Rugby World Cup spreadsheet :
Group Stages
Type score results in Score boxes
Type tries results in Tries boxes
As explained, group standings will be adjusted automatically based on tournament regulation above.
Knock Out Stages
Knock Out stages is designed with bracket visualization to ease you on evaluating all teams who advance to this round. Also, there is color accessories that should help you identify which group each KO rounds are coming from.
Type full time score results in score boxes at the right side of country name boxes. Extra boxes will be shown if there is no winner after full time match is ended. Type the final score here because there is no extra boxes. Each winner will advance to next round. All spreadsheets require a minimum Excel 2007 for Windows.
There is a Pool version, 2023 Rugby World Cup Office Pool spreadsheet you can use to play prediction game with your friends.
Rugby World Cup 2023 Schedule and Scoresheet V41 - Free (120.2 KiB, 2,231 hits)
