You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
This post is brought to you by Diego Oppenheimer, a Program Manager on the Excel team.
It’s finally here! The Rugby World Cup 2011 starts tonight. If you want to keep track of scores and simulate possible outcomes, you can download a free Excel template to use for that purpose.
If you want to be able to access this template no matter where you are, you can upload it to Windows Live SkyDrive and then open it in a browser. Here's how to do that:
1. Download the template to your computer.
2. Go here, and then sign in with your Windows Live ID. If you don’t have an account, just click the Sign up button:
3. One you have logged in, click the SkyDrive tab on the top right:
4. Click Add files. Choose a destination SkyDrive folder, and then browse to and upload the template you just downloaded.
5. Once the file is uploaded, click it to open it in a browser.
You can now keep track of scores no matter where you are, whether partying in Auckland or on your couch in Seattle.
Select Favorite Team
Enter your favorite teams name so that the conditional formatting highlights your teams games.
The rugby world cup has some particularities about extra points. When entering scores, if you want points to be calculated correctly, you will need to enter both the final score as well as the number of tries scored by each team.
Point system in the 2011 Rugby World Cup:
By switching over to the Group Standings sheet, we can now see that all our teams points have been automatically updated as we have entered final scores.
Once all the scores have been filled out, we can switch over to the Knockout stage. This sheet automatically determines, based on scores and total points (resolving tie breaker situations), who qualifies for the next stage.
From the Knockout stage, we can now fill in the scores and watch as one team climbs the ladder to victory.
…and that’s all. A simple template to keep track or simulate your 2011 Rugby World Cup! Hope you enjoy.
--Diego Oppenheimer
Comments: (6) Collapse
Wow, impressive template. That must have been quite some work setting up! Thanks a lot for sharing.
Now, I'm not really into rugby myself, but really intruiged by the template. First thing I did was hit alt-f11 (open vba editor) only to find out that you didn't use any macro's at all.
I'm very new to Excel, but do I assume right that the highlighting which you did on the first tab was done by applying a filter or filter section ?
Anyway, this is highly appreciated by me. Examples like these can really people like me to experience and learn new things.
@ShelLUser
Here is another post were I used all the same techniques blogs.office.com/.../track-the-soccer-world-cup-scores-with-excel-174.aspx.
A lot of the work is done in hidden columns to uncover them just select the entire sheet and hit UnHide columns.
Cheers,
Diego
Cool, thanks a lot for the link & that hidden columns tip!
And of course I hope you'll enjoy the rugby games! :-)
A fascinating template which will keep me involved as I follow England's fortunes.
You have introduced formulae that I am not familiar with and in particular what I believe are structured reference formulae on the Group Standings sheet.
Where I would appreciate your comment is the use of the @ reference. The help text for structured references in Excel 2010 seems to only refer to #ThisRow for current row references which is how the formulae appear when I open the template in Excel 2007.
Is the help text incorrect?
Real cool app. I realize that you wanted to keep it macro free, but it would have been great if you worked on Greenwich Mean Time (GMT), instead of (PST) and then created another column "Local Time" and used a timezonecalc function (similar to Chip Pearsons modLocalTimeAndGMT functions) to calculate the local time.
i didnt understand this example as i am nt aware of rugby..can u do the same thng with th game of cricket..
Comments: (loading) Collapse