This is a Rugby World Cup 2015 spreadsheet you can use to see its tournament schedule and use it as a scoresheet. It is equipped with formulas that will rank all participants in its Pool automatically based on rules specified in its tournament rule document. This is my first spreadsheet created specifically for Rugby. The layout is based on my Soccer World Cup 2014 spreadsheet. I modified excel formula inside to accommodate 5 team per Pool and add new rank columns to accommodate additional ranking method which based on Tries where you won’t find it in soccer tournament. If you like soccer as well as rugby, and you already use my soccer spreadsheets, you won’t have any problem on using this template.
2015 Rugby World Cup tournament is scheduled to commence on 18th September 2015 and it will be finished by 31st October 2015. It will be hosted by England. 20 teams/countries are participated in this tournament where they will be divided into 4 Pools. Each pool will have 5 teams that will compete each other in a single round robin to become the top 2 teams that will qualify for quarterfinals round as well as automatic tickets to 2019 Rugby World Cup tournament. The third team in each group will be eliminated but will get a ticket for the next 2019 Rugby World Cup tournament as well while the remaining two teams in 4th and 5th position will go home empty handed.
For each pool match, the following number of points will be awarded based on each match result :
> Win : 4 points
> Draw : 2 points
> Loss : 0 points
> 4 or more tries : 1 point
> Loss by 7 points or less : 1 point
At the completion of the Pool phase, the team will be ranked based on Points they earned. And if two or more teams are sharing similar points, one team will be ranked higher by following tie breaker rule :
1. they won their head to head matches (two team), or have best overall points among them (three teams and more)
rule 2-5 are based on all Pool Matches
2. they have best difference between Points Scored For (PF) and Points Scored Against (PA)
3. they have best difference between Tries Scored For (TF) and Tries Scored Against (TA)
4. they have best Points Scored For (PF)
5. they have best Tries Scored For (TF)
Should the tie be unresolved at the conclusion of steps 1 through 5, the rankings as per the updated Official World Rugby World Rankings on October 12, 2015 will determine the higher ranked Team.
After all Pool matches are completed, all winners and runner ups will be met in quarterfinals with pairing matches as follows :
QF 1 – Winner pool B v Runner up pool A
QF 2 – Winner pool C v Runner up pool D
QF 3 – Winner pool D v Runner up pool C
QF 4 – Winner pool A v Runner up pool B
Semifinals matches will be arranged as follows :
SF 1 – Winner QF1 v Winner QF2
SF 2 – Winner QF3 v Winner QF4
Semifinals winners will meet in the Final to fight for RWC 2015 trophy while the losers will fight for 3rd place.
To use this 2015 Rugby World Cup Schedule and Scoresheet is simple. Just type the score in its score boxes as well as tries in tries boxes and let excel formulas do the rest.
Pool ranks will be adjusted based on rules explained above automatically every time you update the score. After the completion of its Pool matches, all quarter finalists will be placed in respective brackets automatically.
In knock out rounds, you can full time score results in score boxes next to team’s names. Additional boxes will be revealed if full time results are not generating winners. Since there is only one additional score box, type the final score here to make the winner advance to the next round. Repeat this step until the end of the tournament and you will see the Champion as well as the 2nd and 3rd team revealed in Podium boxes at the bottom left of this scoresheet.
In This 2015 Rugby World Cup Schedule and Scoresheet, you can update the score, change date and time and modify its header name, just in case you want to match it with your own language and timezone since I didn’t create language and timezone selection list. But, you can’t edit team’s/country’s name since they are protected as well as other layout modification functions.
There are two models you can download below. The first one is a model with automatic Flag Adjustment function that will adjust flags based on team position in Pool Standing table and Knock Out Brackets. The second one is a version without those flag function, you will need this model if your excel version has problem with this function and make your excel runs slow.
If you want to modify its layout to meet your own business style, for example putting your own cafe’s/restaurant’s names, as well as learn or tweak its formula, you can purchase the fully editable one. But, remember to not distribute the editable one to other users without my permission or claim it as yours.
If you found any errors or I misinterpret some regulation, I will appreciate if you send me a message through contact form above so I can fix it before the tournament is begun.
Rugby World Cup 2015 Schedule and Scoresheet V1.86 (323.7 KiB, 12,224 hits)
Rugby World Cup 2015 Schedule and Scoresheet V1.86 - no Flag Formulas (151.0 KiB, 2,999 hits)
There is an office pool or a prediction game created specifically for this tournament. You can read more information about Rugby World Cup 2015 Office Pool here.
Get Fully Editable Rugby World Cup 2015 Schedule and Scoresheet